Formula
Upsell (points) = (Proposed sell rate − Buy rate) × 100; Commission = Funded amount × (Proposed sell rate − Buy rate)
Merchant payback = Funded amount × Proposed sell rate; Merchant daily payment = Merchant payback ÷ Number of daily payments
Net to merchant = Funded amount − Fees deducted from the merchant. Merchant APR = daily internal rate of return r such that the present value of the daily payments at r equals the net to merchant, multiplied by 252 business days per year
Pricing ladder: the same four figures recomputed at Buy rate, Buy + 0.04, Buy + 0.08, Buy + 0.12 and Buy + 0.16. The calculator flags an upsell above 15 points and an APR above 100 percent.
Worked examples
Example 1: the default deal, $50,000 at 1.30 on a 1.18 buy over 140 payments
Funded amount $50,000, buy rate 1.18, proposed sell rate 1.30, 140 daily payments, $1,500 in fees. Upsell = (1.30 − 1.18) × 100 = 12 points. Commission = $50,000 × 0.12 = $6,000. Merchant payback = $50,000 × 1.30 = $65,000. Daily payment = $65,000 ÷ 140 = $464.29. Net to merchant = $50,000 − $1,500 = $48,500. The APR solves for the daily rate at which 140 payments of $464.29 are worth $48,500 today; that rate is about 0.438 percent per business day, and 0.438 percent × 252 = 110 percent. The ladder reads: at the 1.18 buy, $0 commission, $59,000 payback, $421.43 a day, 73 percent APR; at 1.22, $2,000, $61,000, $435.71, 85 percent; at 1.26, $4,000, $63,000, $450.00, 98 percent; at 1.30, $6,000, $65,000, $464.29, 110 percent; at 1.34, $8,000, $67,000, $478.57, 123 percent. Twelve points of upsell lifted the merchant's APR by 37 percentage points.
Example 2: a longer term lowers the APR at the same points
Funded amount $80,000, buy rate 1.22, sell rate 1.36, 200 daily payments, $2,000 fees. Upsell = (1.36 − 1.22) × 100 = 14 points. Commission = $80,000 × 0.14 = $11,200. Payback = $80,000 × 1.36 = $108,800. Daily payment = $108,800 ÷ 200 = $544.00. Net to merchant = $80,000 − $2,000 = $78,000. Solving for the daily rate that discounts 200 payments of $544.00 to $78,000 and annualizing over 252 business days gives an APR of about 89 percent. The sell rate is higher than in example 1 and the upsell is two points wider, yet the APR is lower, because the merchant has 200 business days rather than 140 to repay. Term is the lever that funders control and brokers rarely ask about; a buy rate quoted without a term tells you very little.
Example 3: a short, small deal at twenty points
Funded amount $25,000, buy rate 1.25, sell rate 1.45, 100 daily payments, $750 fees. Upsell = (1.45 − 1.25) × 100 = 20 points, which the calculator flags. Commission = $25,000 × 0.20 = $5,000. Payback = $25,000 × 1.45 = $36,250. Daily payment = $36,250 ÷ 100 = $362.50. Net to merchant = $25,000 − $750 = $24,250. The daily rate that discounts 100 payments of $362.50 to $24,250, annualized, is roughly 217 percent APR. The merchant pays $11,250 above the advance to receive $24,250 in hand over about five months. Twenty points exceeds most funders' caps, so the submission is likely to be cut to the cap or declined, and in a disclosure state the merchant will see a triple-digit APR on the offer summary before signing.