Excel templates / Loan amortization schedule

Loan amortization schedule template

The monthly payment for a loan, and a row for every payment showing interest, principal and the balance left, for up to 30 years.

Download the loan amortization schedule template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Enter the loan amount, the annual interest rate, the term in years and the date of the first payment in the yellow cells, B3 to B6.
  2. The monthly payment appears in B8, and the schedule below fills in one row per payment: up to 360 payments, a 30-year mortgage. Rows past the last payment stay blank.
  3. The balance in the last row comes to $0.00: the loan is paid off.

How it works

Learn the skills behind it

Functions used: PMT, EDATE, IF, MAX, SUM.

More free templates