Loan Amortization Schedule
Every EMI split into interest and principal, with the balance left — by year or by month.
From month 143, more of each EMI repays the loan than pays interest.
Year by year
| Year | Paid | Interest | Principal | Left |
|---|---|---|---|---|
| 1 | ₹3.1L | ₹2.5L | ₹59,710 | ₹29.4L |
| 2 | ₹3.1L | ₹2.5L | ₹64,988 | ₹28.8L |
| 3 | ₹3.1L | ₹2.4L | ₹70,733 | ₹28L |
| 4 | ₹3.1L | ₹2.4L | ₹76,984 | ₹27.3L |
| 5 | ₹3.1L | ₹2.3L | ₹83,791 | ₹26.4L |
| 6 | ₹3.1L | ₹2.2L | ₹91,196 | ₹25.5L |
| 7 | ₹3.1L | ₹2.1L | ₹99,256 | ₹24.5L |
| 8 | ₹3.1L | ₹2L | ₹1.1L | ₹23.5L |
| 9 | ₹3.1L | ₹1.9L | ₹1.2L | ₹22.3L |
| 10 | ₹3.1L | ₹1.8L | ₹1.3L | ₹21L |
| 11 | ₹3.1L | ₹1.7L | ₹1.4L | ₹19.6L |
| 12 | ₹3.1L | ₹1.6L | ₹1.5L | ₹18.1L |
| 13 | ₹3.1L | ₹1.5L | ₹1.6L | ₹16.4L |
| 14 | ₹3.1L | ₹1.3L | ₹1.8L | ₹14.6L |
| 15 | ₹3.1L | ₹1.2L | ₹2L | ₹12.7L |
| 16 | ₹3.1L | ₹99,691 | ₹2.1L | ₹10.6L |
| 17 | ₹3.1L | ₹80,888 | ₹2.3L | ₹8.2L |
| 18 | ₹3.1L | ₹60,423 | ₹2.5L | ₹5.7L |
| 19 | ₹3.1L | ₹38,147 | ₹2.7L | ₹3L |
| 20 | ₹3.1L | ₹13,905 | ₹3L | ₹0 |
At a fixed rate with the EMI rounded to the rupee. A lender’s schedule can differ by a few rupees a month, and changes whenever a floating rate resets.
How it’s worked out
What an amortization schedule shows
An amortization schedule lists every EMI of a loan and splits it into the interest charged that month and the principal it repays, with the balance left afterwards. The EMI stays the same, but the split changes every month because interest is charged only on what you still owe.
Your lender’s quarterly statement gives the same information in summary. RBI requires lenders to send borrowers of floating-rate loans a statement each quarter showing the principal and interest recovered so far, the EMI, and the number of EMIs left.
A worked example: ₹30 lakh at 8.5% for 20 years
The EMI is about ₹26,035. In the first month ₹21,250 of it is interest and only ₹4,785 repays principal. Across the whole first year you pay about ₹2,52,710 of interest and clear just ₹59,710 of the loan.
The balance falls slowly at first and faster later. The principal part of the EMI overtakes the interest part only in month 143, almost 12 years in, and half the loan is still outstanding until almost 14 years in. Over 240 months the interest adds up to about ₹32.5 lakh, more than the amount borrowed.
How an extra payment changes the schedule
Enter an extra monthly amount and the schedule shows the same loan with that extra going to principal each month. Every extra rupee lowers the balance that next month’s interest is charged on, so the loan clears sooner and the total interest falls.
The table can be read by year, which is useful for tax records and for comparing against your lender’s statement, or month by month. Months are counted from your first EMI rather than shown as calendar dates.
Questions people ask
What is a loan amortization schedule?
It is a table of every EMI on a loan showing how much goes to interest, how much repays principal, and the balance left after each payment. It shows why the balance falls slowly at the start and quickly towards the end.
Why does most of my early EMI go towards interest?
Interest is charged on the outstanding balance, which is highest at the start. On ₹30 lakh at 8.5%, the first month’s interest is ₹21,250 out of an EMI of about ₹26,035, leaving only ₹4,785 to reduce the loan.
When does the principal part of the EMI become larger than the interest?
It depends on the rate and tenure. For ₹30 lakh at 8.5% over 20 years, the principal part overtakes the interest part in month 143, close to the 12-year mark. The calculator marks that month on your own loan.
How can I get my home loan amortization schedule from my bank?
Most lenders provide one in net banking or on request, and RBI requires a quarterly statement of principal and interest recovered, the EMI and the EMIs left for floating-rate loans. This page lets you build the same table yourself from the balance, rate and tenure.
Does the schedule change when the interest rate changes?
Yes. When a floating rate resets, the lender either changes the EMI, changes the tenure, or both, and you can ask which. Re-run the schedule with the new rate and the balance left at that point to see the updated split.
An estimate from the figures you entered. Not a loan offer or advice.