Spreadsheet to work out overpayments - in mortgage

Ace Modder · 2 Feb 2016 at 19:38

I want to work out how it affects my mortage if I make an overpayment.

Does anybody have a spreadsheet/table/chart I can enter the info to obtain the results.

For exmaple if I pay off £1000 extra in month 2 on my mortage how many months it cuts from my total payments

Richie · 2 Feb 2016 at 20:00

I have a Google Docs Sheet... Just made a new one to share so you can download a copy if you want - https://docs.google.com/spreadsheets/d/1kROOoW5fXiqtS-3RknDBXivUxFp2YVvTifg0n-3dwYE/edit?usp=sharing

Ace Modder · 2 Feb 2016 at 20:06

You my friend are a legend!

BennyC · 2 Feb 2016 at 20:14

See here:

http://www.moneysavingexpert.com/mortgages/mortgage-overpayment-calculator

Syla5 · 3 Feb 2016 at 10:17

https://www.drcalculator.com/mortgage/uk/

fill in the pre-payment box with the overpayment amount and which month you want it to start...this calculator is sooooo good.

topgun06 · 3 Feb 2016 at 10:27

I'll look at this later. Cool