Mortgage amortization schedule

Monthly payment and full amortization schedule, month by month, for any fixed-payment loan.

What it includes

• Payment with the PMT function
• Interest, principal and balance every month
• Up to 40 years

Download Excel Spanish version

How to use it

1. Download the file and open it in Excel, LibreOffice or Numbers.
2. To use it in Google Sheets: upload it to Google Drive and open it with Google Sheets.
3. Replace the example figures in the sand-colored cells with yours.

Estimates only. The template does not send your data anywhere: it stays in your file.