Formula
Current payment = current balance × r₀ ÷ (1 − (1 + r₀)^−m₀), with r₀ = current rate ÷ 12 and m₀ = months remaining. Remaining cost of current loan = current payment × m₀.
New principal = current balance + prepayment penalty + new loan fees and closing costs.
New payment = new principal × r₁ ÷ (1 − (1 + r₁)^−m₁), with r₁ = new rate ÷ 12 and m₁ = new term in months. Total cost of new loan = new payment × m₁.
Lifetime saving = remaining cost of current loan − total cost of new loan. Monthly cash-flow change = current payment − new payment.
Worked examples
Example 1: $120,000 at 15 percent with 30 months left, refinanced at 10 percent over 36 months (the defaults)
Current loan: r₀ = 0.15 ÷ 12 = 0.0125; m₀ = 30. Payment = $120,000 × 0.0125 ÷ (1 − 1.0125^−30) = $1,500 ÷ 0.3111 = $4,821.43. Remaining cost = $4,821.43 × 30 = $144,643. New loan: principal = $120,000 + $1,200 penalty + $2,400 costs = $123,600. r₁ = 0.10 ÷ 12 = 0.0083333; m₁ = 36. Payment = $123,600 × 0.0083333 ÷ (1 − 1.0083333^−36) = $1,030 ÷ 0.2583 = $3,988.22. Total cost = $3,988.22 × 36 = $143,576. Lifetime saving = $144,643 − $143,576 = $1,067. Monthly change = $4,821.43 − $3,988.22 = $833.20 of relief. The tool shows $1,067, $4,821.43, $3,988.22, $833.20, $144,643 and $143,576. Five points of rate bought only $1,067 of lifetime saving because the new loan runs six months longer and starts $3,600 bigger. The $833 a month of relief is real, but most of it is deferral, not saving.
Example 2: a short, expensive loan stretched to four years
Current: $60,000 at 22 percent with 18 months left, no penalty. r₀ = 0.018333; payment = $60,000 × 0.018333 ÷ (1 − 1.018333^−18) = $1,100 ÷ 0.2789 = $3,943.72; remaining cost = $70,987. New: $60,000 + $0 + $1,500 fees = $61,500 at 12 percent over 48 months. r₁ = 0.01; payment = $61,500 × 0.01 ÷ (1 − 1.01^−48) = $615 ÷ 0.3797 = $1,619.53; total cost = $77,737. Lifetime saving = $70,987 − $77,737 = −$6,751, an extra cost. Monthly relief = $3,943.72 − $1,619.53 = $2,324.19. The rate fell by ten points and the loan still costs $6,751 more, because 48 months of 12 percent is more interest than 18 months of 22 percent. Whether this is a bad refinance depends on what $2,324 a month is worth to the business right now; if the alternative is a missed payroll, it may be the right one. Run the new loan through the prepayment calculator to see what paying it at the old pace would save.
Example 3: a small rate cut that costs almost exactly what it saves
Current: $200,000 at 9 percent with 48 months left, $2,000 penalty. r₀ = 0.0075; payment = $200,000 × 0.0075 ÷ (1 − 1.0075^−48) = $1,500 ÷ 0.3014 = $4,977.01; remaining cost = $238,896. New: $200,000 + $2,000 + $4,000 costs = $206,000 at 7.5 percent over 48 months. r₁ = 0.00625; payment = $206,000 × 0.00625 ÷ (1 − 1.00625^−48) = $1,287.50 ÷ 0.2585 = $4,980.85; total cost = $239,081. Lifetime saving = −$185. Monthly change = −$3.85. A one-and-a-half-point rate cut over the same term is worth about $6,800 of interest on this balance, and the $6,000 of penalty and costs, which themselves accrue interest, consume all of it. This refinance does nothing except reset the paperwork. It would make sense only if the new lender also released collateral, removed a covenant or dropped a guarantor, which is a reason to refinance that the arithmetic cannot see.