Loan Amortization Schedule: Month-by-Month EMI, Interest and Balance

How to use

1. Enter the loan amount, interest rate and tenure.
2. Set the date of your first EMI so the months match your statement.
3. Scroll the table, or switch to the yearly view under More options.

Good to know

Amortization is how an EMI loan is paid off. Each month the interest is the balance × yearly rate ÷ 12; the rest of the EMI reduces the balance. Early EMIs are mostly interest, later ones mostly principal.

Your bank statement may differ by a few rupees because banks round the EMI, charge broken-period interest for the days before the first EMI, and calculate interest on actual days in some months. The pattern and totals will be very close.

The schedule is useful for tax planning (interest and principal paid each year), deciding when to prepay and checking the outstanding amount before a balance transfer or sale of the property.

Questions

Last updated: 27 October 2026