Most loan calculators give you one number: the monthly instalment. That is a useful start, but the table behind it, the amortisation schedule, is where the real information sits. Here is how to read one.
What the table shows
Each row is a month (or a year, in summary). It lists the opening balance, the interest charged that month, the part of the instalment that repays principal, and the closing balance. The instalment itself is the same in every row. What changes is the split.
A small example you can check by hand
Take a deliberately small fictional loan of ₹1,00,000 at 12% a year for 12 months. The monthly rate is 1%. The EMI is roughly ₹8,885.
- Month 1: interest ₹1,000; principal repaid ₹7,885; closing balance ₹92,115.
- Month 2: interest ₹921; principal ₹7,964; closing balance ₹84,151.
- Month 12: interest about ₹88; principal about ₹8,797; closing balance zero.
Total paid is about ₹1,06,620, so the interest is around ₹6,620. Check the first row yourself: 1% of ₹1,00,000 is ₹1,000, and the remainder of the instalment goes to principal.
What to take from the schedule
- Interest is front-loaded. Because it is charged on the outstanding balance, the first payments are mostly interest. This is why paying off a long loan early in its life saves more than doing so near the end.
- Your balance falls slowly at first. After the first third of a long loan, a much smaller share of the principal is typically repaid than the share of time that has passed.
- Small changes in tenure matter. Adding a few years lowers the instalment but increases the total interest substantially.
- Part-prepayments reduce the balance on which interest is charged, so they cut the total interest. Check the lender’s charges for doing so.
Using a calculator for this
A good calculator shows the schedule rather than only the instalment. You can enter the principal, rate and tenure and see the year-by-year totals of principal and interest. One that displays this split is at https://wealthstar.in/tools/emi-calculator/.
The same loan at two rates
The schedule makes comparison easy. Take ₹50 lakh over 20 years. At an assumed 8.5% the EMI is about ₹43,400 and the total interest about ₹54.1 lakh. At 9.0% the EMI is about ₹44,990 and the total interest about ₹58.0 lakh. A half-point difference in rate adds roughly ₹1,600 a month and about ₹3.8 lakh over the life of the loan. The monthly difference looks modest, which is exactly why a total is worth computing.
Yearly summaries
A 240-row monthly table is unwieldy, so most tools offer a yearly summary: for each year, the total principal repaid, the total interest paid, and the closing balance. For the 8.5% loan above, the first year’s interest is close to ₹4.2 lakh, while the principal repaid is only about ₹1.0 lakh. By the final year, the proportions are reversed. That crossover, the year when more of the instalment goes to principal than to interest, falls around the middle of a long loan, in about the twelfth year for this one.
When the rate is not fixed
A schedule assumes a constant rate. If your loan is floating, the lender will recalculate when the rate changes, so treat the table as an estimate. The lender’s statement shows the actual position, and it is worth asking for one at least once a year.
Comparing two offers
- Use the same loan amount and tenure for both.
- Enter each rate and note the EMI and total interest.
- Add the processing fee and any other charges to the total cost.
- Check what each lender charges for prepayment and how it treats a part-prepayment (lower EMI or shorter tenure).
- Ask whether the rate is linked to a benchmark and how often it resets.
Why the table beats the headline rate
A rate quoted by itself says little. The table converts it into rupees you will actually pay, and it shows when the cost falls. It also helps you plan: if you expect extra income in a few years, you can see how much interest a part-prepayment would remove. The table does not tell you whether to borrow, only what the borrowing costs. Fixed instalments also shrink in real terms over a long tenure, and an inflation calculator lets you see by how much at an assumed rate.
Next time you see a loan offer, ask for the tenure, the rate, the fees and the schedule. With those four you can reproduce the numbers yourself and check that the lender’s figures match.
A final check
Compare the calculator’s EMI with the figure in your sanction letter. Small differences are common, because lenders may use different day-count conventions, rounding, or charge the first instalment on a part-month. If the difference is large, ask the lender for the schedule and compare the interest rate and tenure.
The schedule will not change what you owe, but it changes how well you understand it, and that helps when you decide whether to prepay, refinance or simply plan the budget around the instalment.
