Amortization Table in Excel
Believe it or not, a loan amortization spreadsheet was the very first Excel template I downloaded from the internet. Since then, I've discovered the great boost in productivity that can come from not having to start from scratch.
This page of Vertex42's Excel Nexus lists THE best place to go to find a FREE Excel amortization spreadsheet for creating your own amortization table, schedule, or template.
Find a Free Loan Amortization Spreadsheet
Listed below are the articles and spreadsheets available for download at Vertex42.com that are related to amortization:
- Amortization Calculator (web-based)
- Simple Interest Amortization
- Auto Loan Amortization Calculator
- Balloon Payment Loan Calculator
- Home Equity Loan Amortization Calculator
- Extra Payment Mortgage Calculator
- Loan Payment Schedule (with optional extra payments)
- Adjustable Rate Mortgage (ARM) Calculator
- See Also: Amortization Formulas in Excel
You can also find a free excel loan amortization spreadsheet in Microsoft's very own directory of free Office templates. They offer templates in Word, PowerPoint, Publisher, and of course Excel. Browse for templates at Microsoft.
Microsoft has at least 5 different templates related to Excel loan amortization calculations. Some of them use some pretty fancy Excel formulas for creating the amortization table and making it possible to manipulate the schedule by including extra payments.
Loan Amortization Software and Resources
If you would like to see specific resources related to amortization calculations listed here, please email us your suggestions.
