Formula
Amount to pay today = Remaining payback balance × (1 − Discount offered). Discount saved = Remaining payback balance − Amount to pay today.
Days of debits avoided = Remaining payback balance ÷ Daily remittance. Years left = Days of debits avoided ÷ 252.
Opportunity cost of the cash = Amount to pay today × Annual return you could earn × (Years left ÷ 2). The half reflects that under the schedule the cash would have left in instalments, so on average it would have been in the business for half the remaining term.
Net benefit of paying early = Discount saved − Opportunity cost. Discount as annualized return = Discount saved ÷ Amount to pay today ÷ Years left.
Worked examples
Example 1: the default quote, $40,000 balance with a 10 percent discount
Remaining payback balance $40,000, daily remittance $500, discount offered 10 percent, annual return available on the cash 20 percent. Amount to pay today = 40,000 × (1 − 0.10) = $36,000. Discount saved = 40,000 − 36,000 = $4,000. Days of debits avoided = 40,000 ÷ 500 = 80 business days. Years left = 80 ÷ 252 = 0.3175. Opportunity cost = 36,000 × 0.20 × (0.3175 ÷ 2) = 36,000 × 0.20 × 0.15873 = $1,143. Net benefit of paying early = 4,000 − 1,143 = $2,857, shown in green. Discount as annualized return = 4,000 ÷ 36,000 ÷ 0.3175 = 0.35, or 35 percent. The reading: paying $36,000 now instead of $40,000 over the next 80 business days is like earning 35 percent a year on the $36,000; even after allowing for a 20 percent return the cash could have made in the business, the owner is $2,857 ahead.
Example 2: a small discount against a high-return use of cash
Remaining payback balance $18,000, daily remittance $300, discount offered 5 percent, annual return available 40 percent (for instance, inventory bought at a volume discount and sold within the quarter). Amount to pay today = 18,000 × 0.95 = $17,100. Discount saved = 18,000 − 17,100 = $900. Days of debits avoided = 18,000 ÷ 300 = 60. Years left = 60 ÷ 252 = 0.2381. Opportunity cost = 17,100 × 0.40 × (0.2381 ÷ 2) = 17,100 × 0.40 × 0.11905 = $814. Net benefit = 900 − 814 = $86, still green but barely. Discount as annualized return = 900 ÷ 17,100 ÷ 0.2381 = 22 percent. Here the discount is a 22 percent annualized return and the business can earn 40 percent on the cash, yet the net benefit is still slightly positive, because the schedule would only have kept the cash in the business for half the remaining term on average. A result this close to zero is a coin toss; the decision should turn on liquidity, not on the $86.
Example 3: a large discount with idle cash
Remaining payback balance $90,000, daily remittance $600, discount offered 15 percent, annual return available 0 percent (the cash is sitting in the account). Amount to pay today = 90,000 × 0.85 = $76,500. Discount saved = 90,000 − 76,500 = $13,500. Days of debits avoided = 90,000 ÷ 600 = 150. Years left = 150 ÷ 252 = 0.5952. Opportunity cost = 76,500 × 0 × (0.5952 ÷ 2) = $0. Net benefit = $13,500. Discount as annualized return = 13,500 ÷ 76,500 ÷ 0.5952 = 30 percent. With idle cash the entire discount is net benefit, and 30 percent a year on cash that was earning nothing is an easy decision, provided that the $76,500 is not the operating buffer. Paying it and then bouncing payroll three weeks later would cost more than the $13,500 saved.