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.
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!***