Mortgage Overpayment Calculator – Excel Template

See how much interest and how many years you save by paying extra each month or making a lump-sum payment on your mortgage.

• Automatic summary: Regular monthly payment, Interest without overpaying, Months to repay with overpayments, Interest with overpayments, Interest saved, Time saved (years)
• Calculated for you: Month, Opening balance, Interest, Payment, Principal, Closing balance
• 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.