help with stuarts spreadsheet
clarew
Forumite 500 Posts
Some of you oldies on here (in time lurking i mean, not old in age!) will remember stuart had a overpayment spreadsheet he kindly shared also.
I, being a non excel expert, used this very happily, inputting my monthly minimum payment, interest rates, regular overpayment and extra overpayments in the columns given, I liked the fact it told you then how many months earlier your mortgage would be paid off etc if you continued at this rate.
Since coming off my fixed rate however, I can't seem to get it to change my minimum monthly payment amount in that column. (theres a column to change the interest rates which ive adjusted) but it is still automatically putting in my minimum monthly payment as the same ie:£1000, whereas now with the interest change it has changed to say, £800 and i can't see how to change it,
So any ideas if any of you use this spreadsheet on how to alter it. (eg-so i can enter overpayment of £100 which equals £800 payment and total monthly payment therefore of £900. At the moment, if i put overpayment of £100 it would assume i have paid the £1000 plus a further £100 equalling total payment of £1100)
Please if you understand the above, and are familar with this spreadsheet, try and help a non spreadsheet expert out!!
I, being a non excel expert, used this very happily, inputting my monthly minimum payment, interest rates, regular overpayment and extra overpayments in the columns given, I liked the fact it told you then how many months earlier your mortgage would be paid off etc if you continued at this rate.
Since coming off my fixed rate however, I can't seem to get it to change my minimum monthly payment amount in that column. (theres a column to change the interest rates which ive adjusted) but it is still automatically putting in my minimum monthly payment as the same ie:£1000, whereas now with the interest change it has changed to say, £800 and i can't see how to change it,
So any ideas if any of you use this spreadsheet on how to alter it. (eg-so i can enter overpayment of £100 which equals £800 payment and total monthly payment therefore of £900. At the moment, if i put overpayment of £100 it would assume i have paid the £1000 plus a further £100 equalling total payment of £1100)
Please if you understand the above, and are familar with this spreadsheet, try and help a non spreadsheet expert out!!
Original mortgage 185k. 2003
Current mortgage. 65k Jan 2020
OP £321/month-Aiming to finish August 2025 instead of October 2028 (whilst keeping the 4 dependents fed,watered,clothed,sheltered and paying for school/activities paraphernalia):rotfl:
Current mortgage. 65k Jan 2020
OP £321/month-Aiming to finish August 2025 instead of October 2028 (whilst keeping the 4 dependents fed,watered,clothed,sheltered and paying for school/activities paraphernalia):rotfl:
0
This discussion has been closed.
Latest MSE News and Guides
Replies
I'm not going to be of much help here I think but....Yes, I remember Stuart (GMC) very fondly, he actually popped in once earlier this year to say hi us.
I do have a copy of his SS but can't seem to find it at the mo, I know I have it somewhere) but could you have a look at the cell that is self populating with your minimum payment and tell us if there is a formulae in it as if so it may be pulling that number from elsewhere
Regards
ATT
Original Mortgage o/s £187,643 / £71,904 (-115,739)
Repay o/s £92,661 / now £55,900 (-36,761)
Int Only o/s £94,982, now £16,004 (-78,978)
Total daily interest £1 [a) £0.77 b)£0.23
Total OP's:2018 target £TBC YTD £1,995
Will have a look and get back to you
Was starting to think no one remember stuart (GMC)...him, yourself, Tall Girl and Financial Bliss were some of the first diaries that got me hooked!!
Thanks
Current mortgage. 65k Jan 2020
OP £321/month-Aiming to finish August 2025 instead of October 2028 (whilst keeping the 4 dependents fed,watered,clothed,sheltered and paying for school/activities paraphernalia):rotfl: