Formula
Scheduled payment = current balance × r ÷ (1 − (1 + r)^−months remaining), where r = annual interest rate ÷ 12. Interest without prepaying = scheduled payment × months remaining − current balance.
With prepaying: starting balance = current balance − one-time lump sum. Each month, interest = balance × r; balance = balance + interest − (scheduled payment + extra paid each month); repeat until the balance reaches zero. Interest with prepaying = the sum of the monthly interest figures; new payoff time = the number of months run.
Amount prepaid = lump sum + extra paid each month × new payoff months. Prepayment penalty = amount prepaid × penalty rate.
Net interest saved = interest without prepaying − interest with prepaying − prepayment penalty. Months cut = months remaining − new payoff months.
Worked examples
Example 1: $90,000 at 11 percent with 48 months left, $500 extra a month and $10,000 now, 1 percent penalty (the defaults)
Scheduled payment: r = 0.11 ÷ 12 = 0.0091667; (1.0091667)^−48 = 0.6452; 1 − 0.6452 = 0.3548; $90,000 × 0.0091667 = $825; $825 ÷ 0.3548 = $2,326.10. Interest without prepaying = $2,326.10 × 48 − $90,000 = $111,653 − $90,000 = $21,653. With prepaying: starting balance = $90,000 − $10,000 = $80,000. Month 1: interest = $80,000 × 0.0091667 = $733.33; balance = $80,000 + $733.33 − ($2,326.10 + $500) = $77,907.23. Month 2: interest = $714.15; balance = $75,795.28. Continuing, the balance reaches zero in month 33, and the interest figures sum to $13,042. Amount prepaid = $10,000 + $500 × 33 = $26,500. Penalty = $26,500 × 0.01 = $265. Net interest saved = $21,653 − $13,042 − $265 = $8,346. Months cut = 48 − 33 = 15. The tool shows $8,346, 15, 33 months, $21,653, $13,042 and $265. Note that the final month's payment is smaller than a full payment, so the actual amount prepaid is slightly less than $26,500; the penalty figure is a conservative upper bound.
Example 2: the lump sum alone, then the extra alone
Keep the defaults but set the extra to $0. Starting balance $80,000; scheduled payment unchanged at $2,326.10. The balance reaches zero in month 42; interest with prepaying = $16,545; amount prepaid = $10,000; penalty = $100; net saved = $21,653 − $16,545 − $100 = $5,007; months cut = 6. Now instead set the lump to $0 and the extra back to $500. Starting balance $90,000; payoff in month 38; interest = $16,915; amount prepaid = $500 × 38 = $19,000; penalty = $190; net saved = $21,653 − $16,915 − $190 = $4,548; months cut = 10. Each move alone saves roughly half of what both together save, and the lump sum saves more per dollar because it comes first, when the balance and the interest are largest. A $10,000 lump saves $5,007; $19,000 of extra payments spread over three years saves $4,548. Timing is the whole lesson of prepayment: a dollar paid in month 1 saves 48 months of interest, a dollar paid in month 40 saves 8.
Example 3: a larger loan with a 3 percent penalty
Balance $150,000 at 12 percent with 60 months left; $1,000 extra a month; no lump; 3 percent penalty. Scheduled payment: r = 0.01; (1.01)^−60 = 0.5504; $1,500 ÷ 0.4496 = $3,336.67. Interest without prepaying = $3,336.67 × 60 − $150,000 = $50,200. With $1,000 extra, the balance reaches zero in month 43; interest with prepaying = $35,005. Amount prepaid = $1,000 × 43 = $43,000; penalty at 3 percent = $1,290. Net saved = $50,200 − $35,005 − $1,290 = $13,905; months cut = 17. Even a 3 percent penalty leaves most of the saving intact here, because the penalty is charged on the amount prepaid while the saving comes from the interest avoided on it over years. The penalty would need to approach the interest saved per dollar prepaid, roughly a third in this case, before prepaying stopped paying. The exception is a penalty expressed as a share of the whole remaining balance, or as all remaining interest, which some contracts use; enter that as a large percentage and the result will show it.