Loan 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, and hopefully this page will help you get a head start. This page lists the best places to find an Excel amortization spreadsheet for creating your own amortization table or schedule.

Loan Amortization Table in Excel

If you want a spreadsheet for creating an amortization table for a fixed-rate loan or mortgage, try the one listed below. It is one of our most powerful and flexible templates.

Amortization Schedule - Annual, Quarterly, Semi-annual, Bi-Monthly, Monthly, Bi-Weekly, or Weekly Payments - Complete flexibility in adding extra payments. - Values are rounded, and the final value is adjusted to bring the balance to zero.

Creating an Amortization Table

The article "Amortization Calculation" explains the basics of how loan amortization works and how an amortization table or "schedule" is created. You can delve deep into the formulas used in my Loan Amortization Schedule template listed above, but you may get lost, because that template has a lot of features and the formulas can be kind of hairy.

To get started, I would recommend downloading the Simple Amortization Chart template.

If you are wanting to create your own amortization table, or even if you just want to understand how amortization works, I'd recommend you also read about Negative Amortization. In that article, I explain what happens when a payment is missed or the payment is not enough to cover the interest due.