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
{ 9 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