FinHubFinhub

Loan Amortization Schedule

View year-wise or month-wise breakup of principal, interest, and outstanding balance for your loan.

Loan details

Monthly EMI

₹43,391

Total interest: ₹54,13,879

YearPrincipalInterestBalance
1₹99,511₹4,21,182₹49,00,489
2₹1,08,307₹4,12,387₹47,92,181
3₹1,17,881₹4,02,813₹46,74,300
4₹1,28,300₹3,92,394₹45,46,000
5₹1,39,641₹3,81,053₹44,06,359
6₹1,51,984₹3,68,710₹42,54,375
7₹1,65,418₹3,55,276₹40,88,957
8₹1,80,039₹3,40,655₹39,08,918
9₹1,95,953₹3,24,741₹37,12,965
10₹2,13,274₹3,07,420₹34,99,691
11₹2,32,125₹2,88,569₹32,67,566
12₹2,52,643₹2,68,051₹30,14,923
13₹2,74,974₹2,45,720₹27,39,949
14₹2,99,279₹2,21,415₹24,40,670
15₹3,25,733₹1,94,961₹21,14,937
16₹3,54,525₹1,66,169₹17,60,412
17₹3,85,862₹1,34,832₹13,74,550
18₹4,19,968₹1,00,726₹9,54,582
19₹4,57,090₹63,604₹4,97,492
20₹4,97,492₹23,202₹0

How to read an amortization schedule

An amortization schedule is the month-by-month story of your loan: what each EMI pays in interest, what it repays of the principal, and what you still owe afterwards. It is the single most useful document for understanding why a loan behaves the way it does.

How each row is built

For every month, the lender charges interest on the balance you carried into that month — the annual rate divided by twelve, applied to the outstanding amount. Whatever remains of your fixed EMI after that interest is deducted goes to principal, and the balance falls by exactly that much.

Because the balance is smaller next month, the interest charge is smaller too, so slightly more of the same EMI goes to principal. Repeat that 240 times and you get the familiar curve where progress accelerates towards the end.

The crossover point

On a ₹50 lakh loan at 8.5% for 20 years, the interest portion of the EMI exceeds the principal portion until roughly month 142 — just under twelve years in. Only after that does more than half of each payment actually reduce your debt.

The crossover arrives earlier at lower rates and shorter tenures. It is the clearest argument for prepaying early: before the crossover, your EMIs are mostly rent on the money rather than repayment of it.

Using the schedule in practice

Three checks are worth doing. Confirm the closing balance in the schedule matches your lender statement; if it does not, the rate, the disbursement date, or a fee is different from what you assumed. Check the interest paid in each financial year, which is what tax deductions are based on. And look up the balance at the month you expect a bonus, to size a prepayment.

Note that the final EMI is usually a few rupees different from the rest. Lenders round the EMI to whole rupees, and the last instalment absorbs the accumulated rounding.

First and last EMI compared

Loan
₹50 lakh at 8.5% for 20 years
EMI
₹43,391
Month 1 — interest
₹35,417
Month 1 — principal
₹7,974
Month 240 — interest
≈ ₹305
Month 240 — principal
≈ ₹43,086

The payment never changes, but its job completely inverts. In month one you repay about 18% of the EMI as principal; in the final month you repay 99% of it.

Frequently asked questions

Why is so much of my early EMI going to interest?

Interest is charged on the balance you still owe, which is largest at the start. It is arithmetic rather than a fee structure — the same formula gives you almost pure principal repayment at the end.

Does the schedule change if interest rates move?

Yes. On a floating-rate loan a rate change alters every remaining row. Lenders usually adjust the tenure and keep the EMI level, so ask for a fresh schedule after any reset.

Why does my bank schedule differ slightly from this one?

Differences come from rounding, the day count in the first partial month, pre-EMI interest before full disbursement, and any fees added to the principal. The overall shape should match closely.

How do I use the schedule for tax filing?

Add up the interest column for the months in the financial year — that is the figure relevant to home loan interest deductions under the old regime. Your lender also issues a provisional interest certificate you should reconcile against.

What happens to the schedule if I prepay?

Every row after the prepayment is recalculated on the lower balance. If the lender keeps your EMI unchanged, the schedule simply ends earlier; if it lowers the EMI, the schedule keeps its original length.

Disclaimer

Schedule is an educational estimate using a standard reducing-balance EMI model. Bank statements may differ due to fees, rate resets, and rounding.