Loan Amortisation Schedule
Generate a full year-by-year home loan amortisation schedule: principal paid, interest paid and outstanding balance for every year of the loan.
💼 Are you a real estate agent or broker? Send this calculator to your buyers on your own branded listing page — every enquiry comes straight to your WhatsApp. Create free agent page →An amortisation schedule shows where each EMI actually goes. The EMI is constant, but the split is not: in the first years most of it is interest, and only late in the loan does principal dominate. Seeing the table is usually what convinces people to prepay.
The schedule below is generated for your loan. Read the Interest column against Principal in year 1 versus year 15 — on a 20-year loan at 8.5%, roughly 70% of your first year's EMIs is pure interest.
Reading the schedule
Each month the lender charges interest on the balance you still owe. Whatever is left of your EMI after that interest reduces the principal. Because the balance shrinks, next month's interest is slightly smaller and slightly more of the EMI goes to principal — the effect accelerates towards the end.
Month's interest = outstanding balance × (annual rate ÷ 12 ÷ 100)
Principal repaid = EMI − month's interest
What the table tells you
- The halfway point is not year 10. On a 20-year loan at 8.5% you only clear half the principal around year 13.
- Early prepayment is disproportionately powerful, because it removes balance during the years when interest is largest.
- Section 24(b) interest deduction is capped at ₹2 lakh a year for a self-occupied property. On a large loan your year-1 interest may far exceed the cap — the schedule shows when you drop below it.
Turn a calculation into an enquiry
Buyers who run these numbers are ready to talk. Give every listing its own page with your photo, phone and WhatsApp on it — leads land straight on your phone.
Create your free property pageFrequently asked questions
Why is so much of my early EMI going to interest?
Interest is charged on the outstanding balance, which is at its largest at the start. It is not a fee structure or a trick — as the balance falls, the interest portion falls with it automatically.
Does the schedule change if rates move?
Yes. On a floating loan a rate change alters every future row. Most lenders keep the EMI and extend the tenure instead, so ask for a fresh schedule after any rate revision.
Can I get this from my bank?
Yes — every lender must provide an amortisation statement, usually free in net banking. Use this calculator to model scenarios before committing.
How does this help with tax?
The interest column is what you claim under Section 24(b), capped at ₹2 lakh a year for self-occupied property, and the principal column feeds Section 80C within its ₹1.5 lakh overall limit.