Your Cart
Loading

Loan & Mortgage Overpayment Calculator Spreadsheet – See Interest Saved and Months Cut by Overpaying (Excel + Google Sheets)

On Sale
£2.99
£2.99
Added to cart

See what a little extra could save.

What's inside:

Inputs: loan amount, APR, term in months and extra payment

Dashboard: standard vs overpayment: months, total interest, total paid, interest and time saved

Schedule: month-by-month balances for both plans (up to 480 months)

What you get:

Loan-and-Mortgage-Overpayment-Calculator-Spreadsheet.xlsx – the blank calculator

Loan-and-Mortgage-Overpayment-Calculator-Spreadsheet-EXAMPLE.xlsx – filled with a sample loan

The calculations were checked against an independent model.

Estimates only: lenders may use daily interest, fees, early repayment charges or overpayment limits. Check with your lender first. Not financial advice.

Instructions are on the Start Here tab.

Works in Microsoft Excel 2016 or newer (Windows and Mac), Excel for the web, and Google Sheets (upload the .xlsx to Google Drive and open it with Google Sheets). No macros.

This is a digital download. No physical item will be shipped. For personal use only.

You will get a ZIP (29KB) file