Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site

Repayment mortgage overpayment calculator

mortgage deals, ideas and discussion
Gerry557
Lemon Quarter
Posts: 2198
Joined: September 2nd, 2019, 10:23 am
Has thanked: 192 times
Been thanked: 613 times

Repayment mortgage overpayment calculator

#667850

Postby Gerry557 » June 7th, 2024, 10:00 am

Is there a formula for calculating the saving by making an overpayment on a repayment mortgage.

Obviously you can calculate the interest saving fairly easily but how do you account for the capital part.

So on a 500k mortgage at 5.29% over 35 years

£2,616.66 would be monthly payment
£2,204.17 of that is interest

So if you overpay £250, how much would the monthly payment reduce to.

More than the £1.10 monthly interest saving obviously.

kempiejon
Lemon Quarter
Posts: 3704
Joined: November 5th, 2016, 10:30 am
Has thanked: 1 time
Been thanked: 1244 times

Re: Repayment mortgage overpayment calculator

#667854

Postby kempiejon » June 7th, 2024, 10:15 am

You could build a complicated spreadsheet, but Martin's gang have an online tool https://www.moneysavingexpert.com/mortg ... alculator/

DrFfybes
Lemon Quarter
Posts: 3921
Joined: November 6th, 2016, 10:25 pm
Has thanked: 1247 times
Been thanked: 2054 times

Re: Repayment mortgage overpayment calculator

#667860

Postby DrFfybes » June 7th, 2024, 10:53 am

Most overpayment calculators assume you keep the monthly payments the same. Not seen one that gives you the option to reduce them.

The reason is probably because if you overpay and reduce your payments by the reduced interest, then the mortgage is pretty much unaffected and the repayments reduce by the drop in interest, as you're still paying the same amount off the capital each month. It does change slightly, but £250/500k is such a small amount it is negligable.

If you do keep the payments the same then the mortgage ends earlier, the calc linked to above says by 1 month.

The calcuator is good for showing what a huge difference a very small regular overpayment makes. Something I fortunately discovered very early on when I first remortgaged and noticed the 'savings' were by increasing the term by 3 years back to the original, so I dropped it 2 more years for about an extra tenner a week. In this example increasing the payments by £26.20/month, 1% of the payment saves £20k in interest (4% of the total interest) and clears the debt 1 year (or nearly 3% of the term) sooner.

Paul

tacpot12
2 Lemon pips
Posts: 157
Joined: July 19th, 2018, 10:24 am
Has thanked: 162 times
Been thanked: 89 times

Re: Repayment mortgage overpayment calculator

#667886

Postby tacpot12 » June 7th, 2024, 1:05 pm

I use the Loan Amortization Template in Excel. This allows quite a bit of flexibility to model the effect of overpayments.

Gerry557
Lemon Quarter
Posts: 2198
Joined: September 2nd, 2019, 10:23 am
Has thanked: 192 times
Been thanked: 613 times

Re: Repayment mortgage overpayment calculator

#667929

Postby Gerry557 » June 7th, 2024, 5:51 pm

kempiejon wrote:You could build a complicated spreadsheet, but Martin's gang have an online tool https://www.moneysavingexpert.com/mortg ... alculator/


It doesn't answer the question though. I've played with this.

Gerry557
Lemon Quarter
Posts: 2198
Joined: September 2nd, 2019, 10:23 am
Has thanked: 192 times
Been thanked: 613 times

Re: Repayment mortgage overpayment calculator

#667931

Postby Gerry557 » June 7th, 2024, 5:59 pm

DrFfybes wrote:Most overpayment calculators assume you keep the monthly payments the same. Not seen one that gives you the option to reduce them.

The reason is probably because if you overpay and reduce your payments by the reduced interest, then the mortgage is pretty much unaffected and the repayments reduce by the drop in interest, as you're still paying the same amount off the capital each month. It does change slightly, but £250/500k is such a small amount it is negligable.

If you do keep the payments the same then the mortgage ends earlier, the calc linked to above says by 1 month.

The calcuator is good for showing what a huge difference a very small regular overpayment makes. Something I fortunately discovered very early on when I first remortgaged and noticed the 'savings' were by increasing the term by 3 years back to the original, so I dropped it 2 more years for about an extra tenner a week. In this example increasing the payments by £26.20/month, 1% of the payment saves £20k in interest (4% of the total interest) and clears the debt 1 year (or nearly 3% of the term) sooner.

Paul


I did try inputting x2 lots of info into a mortgage calculator with one 250 less but still over 35 years it saved £1.331 so 21p more ish

Gerry557
Lemon Quarter
Posts: 2198
Joined: September 2nd, 2019, 10:23 am
Has thanked: 192 times
Been thanked: 613 times

Re: Repayment mortgage overpayment calculator

#667932

Postby Gerry557 » June 7th, 2024, 6:00 pm

tacpot12 wrote:I use the Loan Amortization Template in Excel. This allows quite a bit of flexibility to model the effect of overpayments.


I can suggest trying this.


Return to “Mortgages”

Who is online

Users browsing this forum: No registered users and 2 guests