Free Amortization Schedule Templates for a Variety of Loan Types

If you take out a loan or mortgage, it’s important to keep track of your payments. However, calculating payment amounts and planning a schedule can be tricky. That’s where an Excel amortization schedule template comes in handy. An amortization schedule is a table that lists all payments that will be made on a loan over time. The payment amounts are generated by an amortization calculator.

“Amortizing” a loan means paying off the total balance—including both the interest and the principal—in regular, incremental amounts. Using an amortization template for Excel will show you the amount of your payment going toward the principal, and how much is going toward the interest. Early on, your payments will mostly go toward paying interest, but over time, larger portions of your payments will go toward paying off the principal. 

The following amortization schedule templates provide a framework for easily determining balances paid and owed. They also list all scheduled payments over the lifetime of the loan, and show the total amount that remains. Simply plug in your figures for the total loan amount, interest rate, loan duration, and payment frequency, and the calculator will do the rest. We’ve provided a variety of templates you can use for a number of different loans - choose the one that’s best for you and start managing your finances more effectively. You can also use Excel’s built-in amortization template by following these instructions.