Actuarial Settlement Calculator
This app will calculate the settlement figure of any loan using the Actuarial method, as required by the (Early Settlement) Regulations 2004 in the UK. This formula assumes all payments are made on time.
No options selected.
Enter your figures and calculate.
Overview
The settlement calculator works out how much you'd need to pay off a regulated consumer-credit agreement early. It uses the actuarial method required by the Consumer Credit (Early Settlement) Regulations 2004, which entitles a borrower to a rebate of the interest they haven't yet incurred. Enter the original loan amount, the term, the repayment amounts and how many months have run, and it returns the settlement figure along with the APR and the payments made to date.
The actuarial method finds the periodic interest rate implied by the agreement, grows the balance to the settlement date and then credits future interest back as a rebate. The Regulations also let the lender add a short stretch of extra interest, known as the statutory deferment, to cover the settlement notice period. That's broadly 28 days, with a further payment anticipated on agreements longer than a year. Lenders are required to follow this calculation, so the figure here is the one you should expect to settle at.
How it works
The original loan amount, the term in months, the first, standard and final repayment amounts, and how many monthly payments have been made.
The APR implied by the repayment schedule is found by iteration, then converted to the monthly period rate used to value the outstanding balance.
The balance is grown to the settlement date, future interest is rebated, and the statutory deferment interest is added to give the regulated settlement figure.
Worked example
Settling a £5,000 loan halfway through the term
Take a £5,000 loan repaid at £165 a month over 36 months, so £5,940 repayable in total, and settle it after 18 payments with £2,970 paid so far. The calculator solves an APR of 12.2% from those figures, values what you still owe on the actuarial basis, and credits back the interest built into the remaining payments as a rebate.
Because the term is longer than a year, the statutory deferment adds 28 days plus one anticipated month's interest before the rebate is applied. That gives a regulated settlement figure of about £2,764.25, which is the amount the lender has to accept to close the agreement early.