Loan Amortization in Excel - updated, important!

302 Posts



There is a link to my Mortgage/Savings spreadsheet in another thread.
I just spotted an error in one of my formulae in that any savings out weren't updating the total correctly. I've now corrected the formula & replaced the spreadsheet. The link is still the same, so if you downloaded it prior to 27/2, then please download it again. I'm suprised noone spotted it, perhaps none of you are planning to draw a bit out of your savings!
LINK NOW DEAD _ SORRY.
I just spotted an error in one of my formulae in that any savings out weren't updating the total correctly. I've now corrected the formula & replaced the spreadsheet. The link is still the same, so if you downloaded it prior to 27/2, then please download it again. I'm suprised noone spotted it, perhaps none of you are planning to draw a bit out of your savings!
LINK NOW DEAD _ SORRY.
0
This discussion has been closed.
Latest MSE News and Guides
Replies
where abouts in the spreadsheet was the error? As I have used yours as a template and modded it for my situation.
Thanks
The formula was wrong in that savings out weren't being deducted from the running total savings. Everything else was fine.
Youreds!
Exil
I am fine tuning my bolt on to a sheet based on this and the loan calc. How would inflation effect the calc? is inflation % to be added to the overall overpayment paid in or somewhere else? I do understand that let say that £1 now may be worth £1.20 in the later years?
I still all lost on this.
Regards
Does anyone know or help if there is a Excel calc that you can use for an off set endowement Mortgage.
I'm doing a bit of stoozing and have some savings, so would like to see how much is saved month by month
Thanks folks
Before you all say i';ve just noticed
thanks
OIMO
Use the real interest rate - that is, interest rate minus inflation
eg 7% minus 3% = 4%.
Doesn't affect the "cash" value of repayments but tells you how much they are worth in today's money.
This appears to be very similar to Office but is distributed freely by Sun.
http://www.openoffice.org/
I am useless at excel but those familiar with excel seem to get the hang of it.
It's 90Mb to download the entire suite.
J_B.