The loan amortization schedule template is based on an Excel worksheet that can be found here. Feel free to use it or modify it in any way.The sheet is suitable for calculating both short term loan amortizations, such as a car loan, as well as mortgage amortization schedules of up to 30 years. It also allows you to add extra payments, so you can run what if scenarios.
Usage:
Type your loan parameters into the “Enter Values” table, and the sheet will do the rest.
I have not been able to figure out a way to have tables grow or shrink automatically, so the amortization schedule displays 361 rows. Use a page range when printing loans with a term shorter than 30 years.
***Update 8/20/2007: Fixed download link, reset download count to zero. Thanks Douglas!***
Download Loan Amortiztion Schedule for Numbers
{ 12 comments… read them below or add one }
Your download links are not working. I tried several times to download the “Loan Amortization Schedule Template for iWork Numbers”, but the links keep sending me round and round between 2 web pages.
Thanks Douglas! I think it’s fixed now.
This is great – I have been trying to get something very similar to work..thanks for saving me the time!
Can I change the interest rate 18 months into a mortgage payment schedule? We are financing a loan to our son….first at 6% and 18 months later, at 5%. I’m using Numbers ’08
There are no links to download.
Fixed. Thanks Kevin.
you should note on the site that this spreadsheet ignores the actual date inserted and always calculates the interest based on regular 30 day periods regardless of what date you insert.
I would like to insert an extra payment in different amounts periodically in the amortization schedule. How would I do that without screwing up the formula?
Jeff,
I will have to think about that one, I will try to look at it the first of next week.. In the mean time, you could try posting this question to AppleInquiry.com, and see if that gets a response.
- Michael
This is great! Two things:
1. The total interest formula (in the upper right) doesn’t calculate if you enter a term different than 30 years. I have a 27 year loan.
2. I make an extra payment a year – but all at once (instead of monthly). It would be great if I could drop it into the relevant month/year and see the results. How could I do that?
This is great. I would like to see a “Principal Build Up” column after “Cumulative Interest” so that you can see how principal is building up also. Nice work.
this is great. thanks. i was trying to create my own for a few days and gave up. i’m new to numbers.