Loan Amortization Schedule Template for iWork Numbers
August 16th, 2007 | by Michael |
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
6 Responses to “Loan Amortization Schedule Template for iWork Numbers”
By Douglas Head on Aug 19, 2007 | Reply
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.
By Michael on Aug 20, 2007 | Reply
Thanks Douglas! I think it’s fixed now.
By Samantha on Sep 16, 2007 | Reply
This is great - I have been trying to get something very similar to work..thanks for saving me the time!
By Barbara Bergstreser on Dec 28, 2007 | Reply
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
By Kevin on Mar 31, 2008 | Reply
There are no links to download.
By Michael on Apr 1, 2008 | Reply
Fixed. Thanks Kevin.