We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Loan Amortization in Excel - updated, important!
Options

youreds
Posts: 305 Forumite



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
Comments
-
youreds,
where abouts in the spreadsheet was the error? As I have used yours as a template and modded it for my situation.
Thanks0 -
xlt_hunter wrote:youreds,
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!0 -
This sort of calculation tends to ignore inflation - which makes the savings from early payments rather less in real terms.0
-
exil wrote:This sort of calculation tends to ignore inflation - which makes the savings from early payments rather less in real terms.
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.
Regards0 -
Fantastic calc thanks YOUREDS
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 folks0 -
Don't shout!! (ignore above post)
Before you all say i';ve just noticed
thanks0 -
I do not seem to be able to download the spreadsheet at the moment. Is anyone else having problems?
OIMO0 -
OIMO wrote:I do not seem to be able to download the spreadsheet at the moment. Is anyone else having problems?
OIMO30th June 2021 completely debt free…. Downsized, reduced working hours and living the dream.0 -
xlt_hunter wrote: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
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.0 -
Has anyone got this spreadsheet to work with the Open Office package ?
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.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.8K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.7K Work, Benefits & Business
- 598.5K Mortgages, Homes & Bills
- 176.8K Life & Family
- 257K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards