When you run a loan through an EMI calculator, the headline numbers (the EMI, the total interest, and the total repayment) are only the summary. The real story is in the amortization schedule: a row-by-row table showing what happens to your loan with every single payment. Learning to read it tells you where your money is going, how fast your debt is actually shrinking, and when prepaying will save the most. This guide explains each column, shows how to spot the key patterns, and uses a worked example you can follow along with. The figures are illustrative, based on a ₹30 lakh loan at 9% over 20 years.
What an Amortization Schedule Is
An amortization schedule lists every instalment over the life of your loan and breaks it into:
- Interest: the cost of borrowing for that month
- Principal: the part that actually reduces your debt
- Balance: what you still owe after the payment
Because your EMI is fixed, the split between interest and principal changes every month, and the schedule shows exactly how.
The Columns, Explained
Most schedules include some or all of these:
- Instalment number or date: which payment this is
- Opening balance: what you owed at the start of the month
- EMI: the fixed payment (the same every month)
- Interest portion: opening balance × annual rate ÷ 12
- Principal portion: EMI − interest
- Closing balance: opening balance − principal portion
- Cumulative interest (sometimes): total interest paid so far
You can check any row yourself: the interest should equal the opening balance times the monthly rate, and the closing balance should equal the opening balance minus the principal.
A Worked Example
For a ₹30 lakh loan at 9% over 20 years (240 months), the EMI is about ₹26,992, and total interest is about ₹34.8 lakh. Here are selected rows:
- Month 1: opening ₹30,00,000, interest ₹22,500, principal ₹4,492, closing ₹29,95,508
- Month 2: interest ₹22,466, principal ₹4,525, closing ₹29,90,983
- Month 3: interest ₹22,432, principal ₹4,559, closing ₹29,86,423
- Month 12: interest ₹22,115, principal ₹4,877, closing ₹29,43,819, with about ₹2.68 lakh of interest paid so far
- Month 60: interest ₹20,011, principal ₹6,980, closing ₹26,61,211, with about ₹12.8 lakh of interest paid
- Month 120: interest ₹16,063, principal ₹10,929, closing ₹21,30,777, with about ₹23.7 lakh of interest paid
- Month 180: interest ₹9,880, principal ₹17,111, closing ₹13,00,285
- Month 239: interest ₹400, principal ₹26,591, closing ₹26,791
- Month 240: interest ₹201, principal ₹26,791, closing ₹0
Pattern 1: Early Payments Are Mostly Interest
In month 1, ₹22,500 of the ₹26,992 EMI, about 83%, is interest, and only ₹4,492 reduces your debt. Across the entire first year, about 83% of the EMIs you pay go to interest. By the final year, interest is only about 5% of what you pay.
This is the single most important thing the schedule shows: the early years feel like you’re barely making progress, because you aren’t, in terms of principal.
Pattern 2: The Crossover Point
At some point, the principal portion overtakes the interest portion. In this loan, that happens at month 149, a little over 12 years in. Before that, more of each EMI goes to interest than to principal. Look for this crossover in your own schedule, since it shows how long you’ll be in the interest-heavy phase.
Pattern 3: Slow Progress on the Balance
The schedule also shows how little of the loan you’ve repaid over time:
- After 5 years: about 11% of the principal repaid (balance ₹26.6 lakh), though you’ve paid about ₹12.8 lakh (37%) of the total interest
- After 10 years: about 29% repaid (balance ₹21.3 lakh), with about ₹23.7 lakh (68%) of the total interest paid
- After 15 years: about 57% repaid (balance ₹13.0 lakh)
Most of the interest cost is incurred in the first half of the loan, which is why prepaying early is so effective.
Reading the Annual Summary
Some lenders show yearly totals instead of monthly rows:
- Year 1: interest about ₹2.68 lakh, principal about ₹0.56 lakh
- Year 5: interest about ₹2.43 lakh, principal about ₹0.80 lakh
- Year 10: interest about ₹1.98 lakh, principal about ₹1.26 lakh
- Year 15: interest about ₹1.27 lakh, principal about ₹1.97 lakh
- Year 20: interest about ₹15,000, principal about ₹3.09 lakh
Notice how the interest column shrinks steadily while the principal column grows.
Using the Schedule to Plan Prepayments
- Early prepayments reduce the balance on which all future interest is calculated, so they have the biggest effect. Look at where your balance is and how much interest is in the upcoming rows.
- After a prepayment, ask for a revised schedule. If you keep the EMI, the schedule shortens, with fewer rows. If you reduce the EMI, the schedule has the same number of rows but smaller payments.
- If your rate changes, the schedule should be recalculated from that point.
How to Check Your Schedule
- Verify a few rows by hand: interest = opening balance × (annual rate ÷ 12), principal = EMI − interest.
- Check that the closing balance reaches zero (the last payment may differ by a few rupees due to rounding).
- Compare total interest with the summary figure.
- Look for differences if your lender uses daily interest, which can cause small variations.
- Use a spreadsheet: =IPMT() and =PPMT() return the interest and principal for any month.
What to Look For
- How much of your early EMIs is interest
- When the crossover happens
- How quickly the balance falls
- Total interest over the loan
- Whether fees, insurance, or other charges appear
- How the schedule changes with extra payments
This is general information rather than financial advice, so consider speaking to a qualified adviser, and ask your lender for the official schedule.
Frequently Asked Questions
Q1. Why is so little of my early EMI going toward the loan balance?
Because interest is charged on the full outstanding balance, so at the start most of each payment covers interest, and the principal portion only grows as the balance falls.
Q2. Why does the last payment look slightly different?
Rounding over many months can leave a small remainder, so lenders adjust the final instalment to bring the balance exactly to zero.
Q3. What does the crossover point tell me?
It shows when the principal part of your EMI becomes larger than the interest part, which marks the point where your loan starts shrinking noticeably faster.
Q4. Can I get a schedule that includes my prepayments?
Yes, ask your lender for a revised amortization schedule after any prepayment or rate change, or use a calculator that lets you add extra payments.
