Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceLoans & Debt ManagementMortgage Overpayment Calculator

SpreadsheetLoans & Debt ManagementFree

Mortgage Overpayment Calculator

Compare overpayment scenarios side by side: years saved, interest saved and the new payoff date.

Shown with sample data

Colour

Mortgage Overpayment Calculator

Compare overpayment scenarios side by side: years saved, interest saved and the new payoff date.

Standard monthly payment
$1,368
Interest with no overpayment
$171,852
Most interest saved
$95,283
Most years saved
12.8
Interest saved by scenario
  • Small top-up$24,226
  • Round up payment$49,357
  • Pay rise goes in$75,562
  • Aggressive$95,283

How to use it

  1. 1Type your balance, interest rate and remaining years on the Settings sheet.
  2. 2List the monthly overpayments you want to compare.
  3. 3Read years saved and interest saved for each.
  4. 4Check your lender’s overpayment limits before you start.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

See what an extra payment each month really does. Enter your balance, rate and remaining term once, then list overpayment amounts; each scenario shows the new payoff time, the interest you would pay and how much time and money it saves compared with making no overpayments.

Who it’s for

  • Deciding whether to overpay or save
  • Testing a pay rise or bonus
  • Remortgage planning

What’s included

  • Scenarios sheet: One row per overpayment amount.
  • Settings sheet: Your mortgage.

How to use it

  1. 1Type your balance, interest rate and remaining years on the Settings sheet.
  2. 2List the monthly overpayments you want to compare.
  3. 3Read years saved and interest saved for each.
  4. 4Check your lender’s overpayment limits before you start.
Related searchesmortgage overpaymentextra mortgage paymentsmortgage payoffinterest savedhome loan

Details

Format
Spreadsheet
Category
Loans & Debt Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetLoans & Debt ManagementFree

Mortgage Overpayment Calculator

Compare overpayment scenarios side by side: years saved, interest saved and the new payoff date.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Loans & Debt Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More loans & debt management templates

View all
Debt Snowball Payoff Planner3 sheets

Debt-free in

31

Total interest

$3,458

Total debt today

$36,790

Interest paid by debt
$1,728
$782.68
$666.05
$264.03
$16.56
Student loanPersonal loanCar loanVisa cardStore card
SpreadsheetLoans & Debt Management

Debt Snowball Payoff Planner

A month-by-month payoff plan with roll-over payments, your debt-free date and total interest, snowball or avalanche.

10 min setupPreview
Credit Card Payoff Tracker5 sheets

Total card debt

$18,290

Overall utilisation

51%

Interest this month

$303

ABCD
1CardCredit limitBalanceAPR
2Rewards Visa$8,000$4,85024.5%
3Store card$2,500$1,92030%
4Travel Mastercard$12,000$6,30022%
5Balance-transfer card (0% promo)$7,000$3,4000%
Cards
SpreadsheetLoans & Debt Management

Credit Card Payoff Tracker

Every card’s balance, APR and utilisation, the months and interest to pay it off, and what paying only the minimum costs you.

10 min setupPreview
Loan Amortization Schedule2 sheets

Monthly payment

$1,539

Months to payoff

266

Total interest

$212,319

Balance over time
SpreadsheetLoans & Debt Management

Loan Amortization Schedule

Every payment for the full term, with extra payments, payoff date and the interest you save.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ