MoneySavingExpert Chair, Martin Lewis · Editor, Marcus Herbert
🗳️ ELECTION 2024: THE MSE LEADERS' DEBATE Got a burning question you want us to ask the party leaders ahead of the general election? Submit your suggestions via this form or post them on our dedicated Forum board where you can see and upvote other users' questions. Please note that the Forum's rules on avoiding general political discussion still apply across all boards.

# Mortgage-free calculation

Options
Posts: 434 Forumite
edited 12 January 2023 at 1:07PM
I know there are a few calculators around but I can't quite see one that does what I want to work out, sorry if I am missing something obvious, this is my first mortgage! What I'd like to simply work out is, if I overpay the maximum of 10% a year, when will my mortgage be clear? I'm not sure how to account for the interest, and the monthly payments. Is the 10% overpayment over and above your monthly payments, or taking them into account too? And how do you work out the interest - obviously it's not as simple as having a £250k mortgage so if you pay off £25k then the next year you will have a balance of £225k, because interest will be added on. And then, the next year, is the permitted overpayment 10% of the remaining capital, or of the total outstanding amount including interest?

Is there a calculator (or a spreadsheet formula) I can use to work this out? Thanks in advance!

• Posts: 103 Forumite
edited 12 January 2023 at 7:39PM
Options
This will do all the work for you: https://www.moneysavingexpert.com/mortgages/mortgage-overpayment-calculator/
You enter your mortgage balance, the monthly payment or interest rate, and the amount you wish to overpay (either in £ or as a % per month/year) and it works it all out for you.

ETA: the results show the mortgage repayment both with and without the overpayments, to answer your other query.
• Posts: 434 Forumite
Options
I'm not sure that quite does what I'm after, as you can only enter a recurring payment in £ not as a percentage. Thanks though!
• Posts: 274 Forumite
Options
They have changed it, you used to be able to select % for the reoccurring overpayment too
Mortgage start date Nov 2014  - £90,545 over 25 years
Re-mortgage Oct 2017 - 78,295 over 23 years
Re-mortgage Jan 2020 - 55,000 over 26 years @ 1.94%
Current Mortgage Outstanding Middle December 2020 - £
47893.35 - a reduction of £42,652 in just over 6 years!

#### Categories

• All Categories
• 8 Election 2024: The MSE Leaders' Debate
• 343.9K Banking & Borrowing
• 250.3K Reduce Debt & Boost Income
• 450K Spending & Discounts
• 236K Work, Benefits & Business
• 609.2K Mortgages, Homes & Bills
• 173.4K Life & Family
• 248.6K Travel & Transport
• 1.5M Hobbies & Leisure
• 15.9K Discuss & Feedback
• 15.1K Coronavirus Support Boards