Full amortization table for any loan with principal, interest, and balance. This ready-to-use spreadsheet can be customized for your workflow and reporting needs.
Free Excel template: Use the preview below to see the structure of the spreadsheet before downloading it.
Excel Template Preview
| Payment # | Payment Date | Payment Amount | Principal | Interest | Balance |
|---|---|---|---|---|---|
| 1 | Jan-2025 | 1073.64 | 573.64 | 500 | 99426.36 |
| 2 | Feb-2025 | 1073.64 | 577.01 | 496.63 | 98849.35 |
| 3 | Mar-2025 | 1073.64 | 580.4 | 493.24 | 98268.95 |
| 4 | Apr-2025 | 1073.64 | 583.8 | 489.84 | 97685.15 |
| 5 | May-2025 | 1073.64 | 587.22 | 486.42 | 97097.93 |
| 6 | Jun-2025 | 1073.64 | 590.65 | 482.99 | 96507.28 |
About this Loan Amortization Schedule template
This Excel template is designed to make loan amortization schedule easier to organize and maintain. You can edit the headings, values and formulas after downloading the workbook to match your requirements.