Skip to content

Introductory offer: $0 setup and free migration from your current CRM(for a limited time)See pricing

Ferrylend

Using Ferrylend · Lesson 4 of 7

The offer calculator, worked through

Enter a lender's offer, read every number the calculator returns, and check it by hand.

8 min Updated Agents, Processors, Managers, Owners

A short walkthrough video is coming. The written steps below cover everything in the meantime.

Why it matters

Offers arrive as a few numbers in an email. The merchant cares about cash in hand and the payment; you care about affordability and commission. The calculator works all of it out the same way every time, and the server recalculates and stores every figure, so what you compare is what you saved.

Enter an offer

  1. 1On the deal's Lenders tab, open the submission's menu and click Add offer, or click Add offer on the Offers card.
  2. 2In Add offer, pick the Lender, then enter Advance amount, Factor (sell rate), Origination fee (%), and any Other fees and Payoffs.
  3. 3Pick Payment frequency and enter the Term in months, or switch to Payments and enter the number of payments.
  4. 4If you can see commissions, enter Buy rate, Base commission (the lender default is pre-filled) and Commission on.
  5. 5Read the panel on the right: payback, net to merchant, payment, affordability and your commission. Save.

The formulas

payback (RTR)        = advance x factor
origination fee      = advance x fee %
net to merchant      = advance - fee - other fees - payoffs
cost of capital      = payback - net
effective factor     = payback / net
payments per month   = daily: business days (21 by default), weekly: 52/12, biweekly: 26/12, monthly: 1
number of payments   = round(term months x payments per month), unless entered
payment              = payback / number of payments (to the cent; the last payment absorbs the rounding)
holdback %           = payment x payments per month / monthly revenue x 100
combined holdback %  = (existing monthly payments + payment x payments per month) / revenue x 100
upsell points        = (sell factor - buy factor) x 100
commission %         = base % + upsell points
commission $         = basis x commission %   (basis: advance, net funding or payback)
Business days per month comes from the lender, else your organization setting. Split deals use the daily convention for the estimate.

Worked example

A landscaping company averages $72,000 a month in true revenue and already pays one advance at $220 a day ($220 x 21 = $4,620 a month). A lender offers $40,000 at a 1.32 factor with a 3% origination fee, daily payments over 7 months. Your buy rate is 1.27 and the lender pays a 4% base commission on the advance.

StepArithmeticResult
Payback40,000 x 1.32$52,800.00
Origination fee40,000 x 3%$1,200.00
Net to merchant40,000 - 1,200$38,800.00
Cost of capital52,800 - 38,800$14,000.00
Effective factor52,800 / 38,8001.3608
Number of payments7 x 21147
Payment52,800 / 147$359.18 a day (last payment $359.72)
Monthly payment359.18 x 21$7,542.78
Holdback (this offer)7,542.78 / 72,00010.48%
Combined with existing(7,542.78 + 4,620) / 72,00016.89%
Upsell points(1.32 - 1.27) x 1005
Commission %4 + 59%
Commission $40,000 x 9%$3,600.00

The last payment absorbs the rounding: 146 payments of $359.18 come to $52,440.28, so the 147th is $52,800 - 52,440.28 = $359.72.

With the default thresholds (amber at 15%, red above 25%) the affordability badge reads Tight: this offer alone is fine, but together with the existing advance the merchant would hand over almost 17% of revenue. Switch Payment frequency to Weekly and the same offer becomes 30 payments of $1,760.00, about $7,626.67 a month, so the combined holdback is about 17.0%. Weekly feels lighter to the merchant but costs a little more per month, because 52/12 weeks is more than four.

Change Commission on and the commission changes too: 9% of net funding ($38,800) is $3,492.00, and 9% of payback ($52,800) is $4,752.00. Use whatever basis your ISO agreement with that lender states.

Common mistakes

  • No revenue on the deal. Without a statement analysis or stated revenue, the affordability box asks you to add one and shows no holdback.
  • Entering payoffs on a consolidation but leaving the paid-off positions active. The net is right, but the combined holdback counts payments that will stop.
  • Typing the factor as a percent. The factor is a multiplier: 1.32, not 32.
  • Showing the merchant the commission panel. It is marked Internal for a reason; present payback, net, payment and term.

Only users with commission access see Buy rate, Base commission and Your commission. Processors and anyone else without it see the merchant-side numbers only.

Questions

Why does the effective factor differ from the factor rate?

The factor rate is applied to the full advance, but fees and payoffs come out before the merchant receives cash. The effective factor divides the payback by the net funding, so it shows what the merchant pays back for each dollar actually received. In the example, a 1.32 factor with a 3% fee is an effective 1.3608.

How is the number of payments worked out from a term in months?

The term in months is multiplied by payments per month and rounded: 21 business days a month for daily payments (or the lender's own setting), 52/12 for weekly, 26/12 for biweekly and 1 for monthly. A 7 month daily term is 7 x 21 = 147 payments. You can also enter the number of payments directly.

Try it in the app

Signed in? Open the screen this lesson covers.

Open a deal

Finished this lesson?

0 of 7 lessons in Underwriting and analysis

Progress is saved in this browser. Sign in to keep it across devices.