Mortgage Overpayments and Monzo

Financial Chat
9

@ndrw, @Revels, @Feathers and @danbeddows

I have created a crude template that you may or may not have success trying to use. Do not expect this to provide super accurate values. This should more be taken to give an insight into the impact of overpayments, it has a lot of limitations:

In short;

  1. Click File then Make a copy
  2. Update the box of fields to match your circumstances
  3. wait for a bit for the fields to update
  4. scroll down and see whether the charts have updated

If not, check the calculations sheet for any obvious errors then check the pivot table for issues.

I’m sure someone like @BritishLibrary can probably point out a more efficient way to do the calculations. I’ve gone about in a brute force kind of way when I’m sure there’s a simple set of array formula that would do much of the heavy lifting more efficiently.

Also note that the ‘Calculations’ sheet contains my helper columns that I use in all of my spreadsheets that you may find useful for your own stuff.

8 Likes