Periodic rate
r = APR ÷ payments per yearThe entered APR is split into 12, 26 or 52 equal periodic rates for this simplified illustration.
Early Loan Settlement · Methodology
Estimate the balance and cash-flow effect of settling a standard reducing-balance consumer loan on a selected future date.
Return to calculatorIncluded
Outside this method
Calculation
r = APR ÷ payments per yearThe entered APR is split into 12, 26 or 52 equal periodic rates for this simplified illustration.
Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]When no actual payment is entered, the calculator derives the constant amount that amortises the opening balance over the remaining periods.
Bₜ = Bₜ₋₁ + interestₜ − paymentₜInterest is applied first and each payment then reduces interest and capital.
Balance at selected period + settlement adjustmentA positive adjustment increases the estimate; a negative rebate or credit reduces it.
Σ scheduled interest after settlement dateThis is the modelled interest that would arise if the remaining schedule continued.
Remaining interest avoided − settlement adjustmentThis shows the cash difference before allowing for alternative uses of the settlement money.
Timing convention
The selected date is converted to the nearest repayment period using an average 365.2425-day year. The model does not know the contractual payment day. Interest is charged and the regular payment is made once in each modelled period.
Limitations
Reference tests
| Case | Inputs | Expected result |
|---|---|---|
| Zero-rate loan | £12,000 balance; 0% APR; 48 monthly payments | £250 calculated monthly payment and no interest avoided |
| Immediate settlement | £12,000 balance; settlement today; £0 adjustment | £12,000 estimated settlement before lender-specific calculations |
| Positive fee | £12,000 balance; settlement today; £100 adjustment | £12,100 estimate and net saving reduced by £100 |
| Non-amortising payment | Payment no higher than the interest charged in the first period | Warning that the entered payment does not reduce the balance |
Evidence