My Excel mortgage spreadsheet
468 replies
405.2K views
Quick links
Essential Money | Who & Where are you? | Work & Benefits | Household and travel | Shopping & Freebies | About MSE | The MoneySavers Arms | Covid-19 & Coronavirus Support
Essential Money | Who & Where are you? | Work & Benefits | Household and travel | Shopping & Freebies | About MSE | The MoneySavers Arms | Covid-19 & Coronavirus Support
Replies
Until this.
What a cracking workbook!! Nice piece of work.
I think I will use this to set my 5 and 10 year plans, my own spreadsheets are now superseded!
As someone else said, thank you for sharing it.
Can I suggest though, it would be handy if there was a facility to input a date in the future to start overpaying. Say the person using the spreadsheet knows that they have a loan ending in 2 years time and they can start overpaying at that point. Possibly a 'Stop overpaying at X date' box as well, so that they could just overpay for a certain length of time.
As an example, I often advise clients to overpay on their mortgage when a Car Loan ends, then stop overpaying when they need to change their car and get another loan. That way their outgoings stay the same and they don't get used to the luxury of extra money to spend each month and then go through the pain of having to find money when the car conks out.
Also, a facility to input a Lump Sum at a date in the future. They may have an Endowment maturing at a certain date or a Pension Lump Sum.
Other than that it's very good, though I would have to take your word for its' accuracy
Those features aren't configurable from the key info page Im afraid, but you can easily add them in by going to the monthly sheet and manually adding them in. For example if you wanted to do £300 a month repayments from the start of year 2 for 12 months, you'd go to the monthly page, scroll down adding £300 manually into the "overpayment" cell corresponding to month 24, then copy that down 12 cells to make the overpayment for the year.
Likewise if you want to put in a single lump overpayment you can put the lump sum figure in the "overpayment" box for the month you want to put the lump sum in.
I could put it in a selection box on the front page but that would possibly limit you to one period of overpayments etc, whereas if you add them manually you can put as many ad-hoc periods in as you wish.
Thanks all for the compliments BTW :beer:
If you think that would be worthwhile I can knock something up for you to build in.
I am in awe!
One slight problem though, when I go to manually type in an overpayment figure, it tells me the cells are locked/protected, can anyone help. I've tried on the most recent version of excel, and a previous version and both give the same message.