Free Loan Amortization Schedule Calculator
An amortization schedule shows every single monthly payment of a loan — how much principal you paid down, how much interest you paid and the remaining balance. Use it to plan prepayments, compare loan structures or share with your accountant.
Results
Disclaimer: This calculator provides estimates only and does not constitute financial advice. Actual loan terms may vary by lender.
About the Amortization Schedule Calculator
How the schedule is built
For each month: interest = current balance × monthly rate; principal = EMI − interest; new balance = old balance − principal. Repeat until the balance reaches zero. The EMI stays constant while the principal and interest components shift.
What the schedule reveals
In year one of a 10-year loan, you might pay down only 5–8% of the principal — the rest goes to interest. Seeing that written out month by month is what convinces most borrowers to shorten tenure or make part-prepayments.
Using the export
Download as CSV to open in Excel or Google Sheets, or as PDF to attach to a loan application or share with your CA. Both include every row of the schedule plus a summary of total principal and interest paid.
Frequently asked questions
Related Loan Tools
Other free tools in the loans & financing silo.
Business Loan EMI Calculator
Calculate monthly EMI, total interest and total repayment for a business loan. Includes a principal vs interest split.
Open toolLoan Refinance Calculator
Compare your existing loan against a refinancing offer. See new EMI, total interest saved and breakeven month.
Open toolCompound Interest Calculator
Calculate compound interest and maturity value with adjustable compounding frequency and a growth chart.
Open tool