Loan Amortization Schedule preview
Input console for entering loan amount, annual interest rate, term in years, and extra payment parameters. 1/8

About this loan amortization schedule spreadsheet template

This loan amortization schedule template provides a complete framework for modeling any fixed-rate loan, from mortgages to auto loans. The Inputs sheet lets you set the loan amount, annual interest rate, term in years, payment frequency, start date, and optional extra payments — and instantly see the scheduled payment, total interest, and months saved versus no extra payment.

The Calculation sheet generates a full amortization table with payment dates, opening and closing balances, interest, principal, and cumulative interest for every period. The Scenarios sheet includes a sensitivity matrix that compares monthly payments across different interest rates (5%–8%) and terms (10–30 years), plus an extra payment analysis that shows how $100, $250, $500, or $1,000 extra per period accelerates payoff.

A visual Dashboard summarizes the repayment journey with balance and cumulative interest data across the loan lifecycle. The Instructions sheet documents every input field with validation rules, risk notes, and editable flags so you can confidently adapt the model. Fully compatible with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

5 interconnected sheets

Inputs, Calculation, Scenarios, Dashboard, and Instructions work together for complete loan analysis.

Sensitivity matrix built in

Compare monthly payments across 5 interest rates and 5 loan terms in one glance.

Extra payment modeling

See exactly how additional payments reduce total interest and shorten your loan term.

Standard XLSX format

Works with WPS Office, Microsoft Excel, Google Sheets, and Apple Numbers.

Frequently asked questions
The Loan Amortization Schedule template is designed for modeling fixed-rate loans such as mortgages, auto loans, and personal loans. Customize the loan amount, interest rate, term, and extra payment fields in WPS Office to analyze your own loan scenarios.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data and structure in a Notion database; for branded visual documents, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and enter your loan amount, interest rate, term, start date, and extra payment values in the Inputs sheet. All calculations, the schedule, and the dashboard update automatically.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for mortgage analysis, auto loan comparisons, business loan modeling, and client-facing financial reports. It is available for personal and commercial projects, subject to the applicable template license.