Loan Amortization Schedule Template

This template breaks down each loan payment, showing how it affects the remaining balance and how much goes toward interest and principal. Enter the loan amount, interest rate, term, payment frequency, and start date to generate a schedule that details each installment’s breakdown.

An extra payment field is included, making it possible to see the impact of additional payments on the loan balance and total interest. This feature can be used to explore different repayment strategies by adjusting for extra payments and tracking how they influence the overall term and interest costs.

The template is editable in both Excel and Google Sheets, and can be adapted to fit mortgages, car loans, personal loans, or other loan types with regular payment schedules.