My Excel mortgage spreadsheet

Mr_Black

I see! ha thanks for helping me out, quite clearly I'm a bit of a biff.

Locoblade

No worries, I could just publish the compatibility version really but it's got extra hidden sheets to compensate so it's quite a bit bigger file size and not quite as pretty.

Mr_Black

Locoblade wrote: »

No worries, I could just publish the compatibility version really but it's got extra hidden sheets to compensate so it's quite a bit bigger file size and not quite as pretty.

Would you mind emailing me that please?

Locoblade

It's on the website, right next to the regular download!

always29

Locoblade, thank you for this spreadsheet, it is truly awesome. I've just downloaded and working out how to pay my mortgage off by the time husband and I are 50. I think we might have to sell a kidney each or something but it's great to play with the figures!

ellie27

Thanks for the spreadsheet! It is great.

I would be looking to make a lump sum overpayment every year or so, is there anywhere I can input that to see how it changes things? I see there is a monthly overpayment but it was going to be a lumpsum each year perhaps.

Thanks!

Locoblade

Hi

Thanks, yep just go into the "Mortgage 1 Monthly Payment" page and put the lump sum in the "Monthly Overpayment" column on the month you want it to be paid, then scroll down and repeat for subsequent years leaving all other months as zero

ellie27

Wow, its amazing how much a lumpsum payment every now and again can make in the amount of interest you will have paid by the end of the mortgage! Thanks! :beer:

carlosveiga

Kudos for such a great tool!

I have a question - is there a recommended way to update the sheet with the "actuals" from the mortgage payments that the bank takes every month, in case the values aren't always correct 100%?
Thanks for your help!

Locoblade

Hi

You could adjust it in the monthly detailed section, not directly in the start/end balance but say it was £5 over your actual, you could put -5 in the monthly overpayment or 5 in the additional borrowing to bring the end balance back in line.