Home Loan EMI Calculator: Instalment, Interest and Prepayment

Four years into his home loan, Nilesh Kadam sat down with his passbook and did the subtraction himself. He had paid the bank roughly ₹13.4 lakh in EMIs since the day he signed. His outstanding loan balance had fallen by barely ₹2.9 lakh. For a moment he assumed he had made an error, because it did not feel possible that four years of disciplined, on-time payment could move the actual debt so little.

Nilesh is a factory line supervisor in Satara, 38 years old, ₹32 lakh home loan at 8.6% over 20 years, EMI a shade under ₹28,000. Nothing about his loan is unusual. What is unusual is that he never once opened the one document that would have told him, on day one, exactly what year four would look like — because that document was legally his from the moment he signed, and almost nobody asks for it.

The document that was legally his from day one

Every home loan sanction in India comes with a repayment schedule — the month-by-month table showing exactly how each EMI splits between principal and interest, all the way from month one to the last month of the tenure. Lenders are required under RBI’s fair-practices framework for lenders to disclose the loan’s terms, the effective annualised rate and the schedule of payments to the borrower as part of the loan documentation, not as an optional extra a borrower has to negotiate for. It sits in the loan file the day the loan is sanctioned.

Almost nobody reads it. Nilesh signed a stack of papers the day his loan was disbursed and could not, four years later, say whether the schedule was even among them. That is the actual finding here, and it is one competitor articles about home loan EMIs never make: the answer to “why does my balance move so little” was disclosed to the borrower in writing before a single EMI was ever paid. The information asymmetry people complain about with banks does not exist on this particular question. What exists is an attention asymmetry.

Nilesh’s actual numbers, reconstructed

EMI = P × i × (1+i)ⁿ ÷ [(1+i)ⁿ − 1], where P is the loan amount, i is the monthly interest rate, and n is the number of months. Run that for Nilesh’s ₹32 lakh at 8.6% over 240 months and the EMI comes to roughly ₹27,977.

Reconstructing his own schedule from that formula: across his first 48 EMIs he paid the bank about ₹13.4 lakh, of which only about ₹2.9 lakh reduced principal. The remaining ₹10.5 lakh — roughly 79 paise of every rupee he sent the bank in those four years — was interest on a balance that had barely moved. That is not a bank error and it is not a hidden fee. It is the arithmetic of amortisation on a large balance at the start of a long tenure, and it was printed in his file the whole time.

The crossover nobody tells you about

Here is the number that almost never appears in generic EMI explainers, because it requires actually running someone’s schedule rather than describing the shape of one. For Nilesh’s loan, the month in which the principal portion of his EMI finally overtakes the interest portion — the point where more than half of that month’s payment starts reducing the loan rather than servicing it — is roughly month 143. That is just short of twelve years into a twenty-year loan. For the first 60% of his tenure, on a month-by-month basis, interest is the larger half of every single payment he makes.

What to actually do with the schedule you already have

The practical use of the schedule is not to feel resentful about it — it is to see exactly where a rupee of prepayment does the most work. A larger down payment shrinks the base the entire calculation runs on for the full tenure, so the interest it saves usually exceeds the extra amount put down. Stretching from a 10% down payment to 20–25% typically saves well beyond the extra rupees committed up front, because every one of those rupees stops accruing interest at 8.6% for twenty years.

The cheapest lever most borrowers skip entirely is one extra EMI a year, funded from a bonus. Because that payment lands when the balance is still large, it strikes directly at principal and eliminates every future month of interest that principal would otherwise have generated — which is exactly why prepaying in year three is worth more than the same rupee amount prepaid in year fifteen. Floating-rate home loans in India generally cannot carry a prepayment penalty by RBI rule, so there is little reason to hold that extra EMI back once you can see, from your own schedule, how early in the curve you still are.

Tax benefits worth claiming

Under the old tax regime, you can claim interest paid under Section 24(b) and principal repayment under 80C — both meaningful deductions on a home loan, though only available if you are filing under the old regime rather than the new one. This does not change the underlying arithmetic of the schedule; it changes what the after-tax cost of that interest actually is, and is worth running once a year alongside the regime comparison, not assumed by default.

The home-loan counter’s quiet toolkit

Home loans are where a lender’s politest habits live, because the amounts forgive anything. The set: tenure-stretching on rate hikes without proactively telling you (RBI now requires the choice between tenure and EMI be offered to you); the loyalty spread — your 9.4% against the 8.5% a brand-new customer gets on the identical product, curable by asking rather than by a “conversion fee” the bank hopes you never discover; insurance premiums packed into the principal so they quietly earn interest alongside the house; and festival-season processing-fee waivers that cost the bank less than the rate spread it holds you at regardless.

Each of these monetises the same thing the schedule already exposes: inattention after signing. A once-a-year, thirty-minute audit — your rate against the new-customer rate, your tenure against the original schedule, any insurance you never asked for — is worth more per minute than almost any other financial task on your calendar.

What this does not mean

It does not mean the bank hid anything from Nilesh, or that amortisation schedules are some kind of trap. The schedule was in his file exactly as the rules require; the gap was his own attention, and that is true for most borrowers, not a character flaw specific to him.

It also does not mean every rupee of spare cash should chase prepayment. If Nilesh is carrying costlier debt elsewhere, or has no emergency fund, or could deploy that money at a return meaningfully above 8.6% after tax, prepayment stops being obviously correct and becomes one option among several. The schedule tells you where you are on the curve. It does not tell you what else is competing for the same rupee, and that second question still needs answering separately, on its own numbers, every time.

How much home loan can I actually get? Lenders typically cap it so your EMI, across all loans, stays within roughly 40–50% of your monthly income, though this varies by lender and income level.

Fixed rate or floating rate? Floating is far more common in India and lets you prepay without penalty; fixed rates offer certainty but are less flexible and often reset after an initial period anyway.

Frequently asked questions

Can I ask my bank for my repayment schedule if I never received one?

Yes. It is part of your loan documentation and the bank is expected to be able to furnish it on request; most lenders can also regenerate it instantly through net banking. There is no fee and no approval needed — it is your own loan’s arithmetic, not a discretionary disclosure.

Fixed or floating right now?

Floating with vigilance, for most. Fixed-rate premiums embed the bank’s own forecasts; you rarely out-trade your counterparty by accepting their price for certainty.

Does switching lenders hurt?

A balance transfer costs processing and legal fees and resets some paperwork — worth it when the rate gap survives those costs. Often the mere quote makes your own bank discover flexibility it did not previously offer.

Why does the schedule matter more than the EMI amount itself?

Because the EMI is one fixed number for twenty years, but what that number is buying you changes completely across the tenure. Two borrowers paying the identical EMI can be in wildly different positions if one is in month 12 and the other is in month 180 — the schedule is the only document that tells you which one you are.

Regulatory source: the Reserve Bank of India’s fair-practices framework for lenders requires disclosure of loan terms, the effective rate and the repayment schedule as part of loan documentation — verify the current wording directly on rbi.org.in, since the framework is revised from time to time. The reconstruction of Nilesh’s own schedule, the crossover-month calculation and the framing of attention over disclosure are this article’s own.

Disclaimer: This article is for general information only and is not financial or tax advice. “Nilesh Kadam” is a composite character, not a real individual, built to illustrate a typical repayment pattern. Consult a qualified advisor and your own loan documentation before making prepayment or tax decisions. Rates, tenures and disclosure requirements change — verify current figures with your lender and the applicable RBI framework.