Personal Loan Early Settlement Calculator – Excel Template

See what you would pay to close a personal or car loan early, including the bank's early settlement fee, and how much interest you save compared with running it to the end.

• Automatic summary: Outstanding principal now, Early settlement fee, Total to settle today, Remaining instalments if you continue, You save by settling now
• Calculated for you: Balance at that point, Settlement fee, Pay to close, Instalments avoided, Saving, Verdict
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.