help with stuarts spreadsheet

clarew

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!!

abouttimetoo

Hi ClareW

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

clarew

Thank you, i will see if i can do that! I remember him saying "hi" as you said awhile back, and have pm'd him just in case he ever logs on here again!!
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