PropertyNivesh.in

Free calculator · India

EMI Calculator for Home Loan With Repayment Schedule: Every EMI, Dated

This EMI calculator for home loan with repayment schedule gives your monthly EMI and a dated table of every payment, from the first EMI to the last. Each row splits the EMI into principal and interest and shows the balance left. You can total the schedule by financial year to line it up with your bank’s interest certificate. For example, a ₹50 lakh loan at an example 8.5% for 20 years has an EMI of ₹43,391. If the first EMI is in November 2026, the last is in October 2046, and the interest adds up to ₹54.1 lakh.

By the PropertyNivesh Research Desk · Edited by Rakesh Mahajan · Published

Interest is worked out every month on the balance still owed (reducing balance). The schedule assumes the rate stays the same and every EMI is paid on its due date. Grouped by financial year, the interest and principal columns line up with the interest certificate lenders issue for income tax. 8.5% is only an example rate: enter your own.

₹43,391/month

First EMI
Dec 2026
Last EMI
Nov 2046
Number of EMIs
240
Total interest
₹54,13,879
Total of all EMIs
₹1,04,13,879
Interest as a share of the loan
108.3%
Interest in FY 2026-27
₹1,41,326 (4 EMIs)

Home loan repayment schedule

Financial yearEMIsOpening balancePrincipalInterestTotal paidClosing balance
FY 2026-274₹50,00,000₹32,238₹1,41,326₹1,73,565₹49,67,762
FY 2027-2812₹49,67,762₹1,02,361₹4,18,333₹5,20,694₹48,65,400
FY 2028-2912₹48,65,400₹1,11,409₹4,09,285₹5,20,694₹47,53,992
FY 2029-3012₹47,53,992₹1,21,256₹3,99,438₹5,20,694₹46,32,735
FY 2030-3112₹46,32,735₹1,31,974₹3,88,720₹5,20,694₹45,00,761
FY 2031-3212₹45,00,761₹1,43,640₹3,77,054₹5,20,694₹43,57,121
FY 2032-3312₹43,57,121₹1,56,336₹3,64,358₹5,20,694₹42,00,785
FY 2033-3412₹42,00,785₹1,70,155₹3,50,539₹5,20,694₹40,30,630
FY 2034-3512₹40,30,630₹1,85,195₹3,35,499₹5,20,694₹38,45,435
FY 2035-3612₹38,45,435₹2,01,564₹3,19,129₹5,20,694₹36,43,871
FY 2036-3712₹36,43,871₹2,19,381₹3,01,313₹5,20,694₹34,24,490
FY 2037-3812₹34,24,490₹2,38,772₹2,81,922₹5,20,694₹31,85,718
FY 2038-3912₹31,85,718₹2,59,877₹2,60,816₹5,20,694₹29,25,840
FY 2039-4012₹29,25,840₹2,82,848₹2,37,846₹5,20,694₹26,42,992
FY 2040-4112₹26,42,992₹3,07,850₹2,12,844₹5,20,694₹23,35,143
FY 2041-4212₹23,35,143₹3,35,061₹1,85,633₹5,20,694₹20,00,082
FY 2042-4312₹20,00,082₹3,64,677₹1,56,017₹5,20,694₹16,35,405
FY 2043-4412₹16,35,405₹3,96,911₹1,23,783₹5,20,694₹12,38,494
FY 2044-4512₹12,38,494₹4,31,994₹88,700₹5,20,694₹8,06,500
FY 2045-4612₹8,06,500₹4,70,179₹50,515₹5,20,694₹3,36,321
FY 2046-478₹3,36,321₹3,36,321₹10,808₹3,47,129₹0

What a home loan repayment schedule shows

A repayment schedule, also called an amortisation table, is the full plan of your loan. It has one row for every EMI, and each row shows the same things.

  • Month and EMI number: when the payment is due, counted from your first EMI.
  • Opening balance: what you owe before that EMI.
  • Interest: the opening balance times the yearly rate divided by 12. Interest is charged only on what you still owe, which is why this is called a reducing-balance loan.
  • Principal: the EMI less the interest. This is the part that actually pays the loan down.
  • Closing balance: the opening balance less the principal. It becomes next month’s opening balance.

The EMI stays the same each month, but the split changes. Early EMIs are mostly interest because the balance is large. As the balance falls, the interest part shrinks and the principal part grows, until the last EMI is almost all principal.

How to use the calculator

  • Loan amount: the amount the bank pays out, not the property price.
  • Interest rate (default 8.5%): an example input, not a quoted rate. A typical range to try is 7.5% to 9.5%; change it to the rate on your sanction letter or latest statement.
  • Tenure: the loan term in years.
  • First EMI month and year: the month your first full EMI is due. It sets the date on every row.
  • Group the schedule by: financial year (April to March) for tax, calendar year, or loan year (every 12 EMIs from the first).

The yearly view shows one row per year with the number of EMIs in it, the opening balance, the principal and interest paid, the total paid and the closing balance. Switch to the monthly view for every EMI with its date. The panel above the table gives the EMI, the first and last EMI dates, the total interest, the total of all EMIs, and the interest in the first year of the schedule.

Worked example: a ₹50 lakh loan from November 2026

Take a ₹50 lakh loan for 20 years at an example rate of 8.5%, with the first EMI due in November 2026. The EMI is ₹43,391 and there are 240 of them, ending in October 2046. Grouped by financial year, the schedule looks like this (selected years).

Financial yearEMIsPrincipalInterestClosing balance
FY 2026-275₹40,441₹1,76,514₹49,59,559
FY 2027-2812₹1,03,086₹4,17,608₹48,56,473
FY 2030-3112₹1,32,909₹3,87,785₹44,89,250
FY 2035-3612₹2,02,992₹3,17,702₹36,26,291
FY 2038-3912₹2,61,718₹2,58,976₹29,03,174
FY 2040-4112₹3,10,030₹2,10,664₹23,08,292
FY 2045-4612₹4,73,509₹47,185₹2,95,312
FY 2046-477₹2,95,312₹8,426₹0
All 20 years240₹50,00,000₹54,13,879
Reducing-balance schedule at an example 8.5% held for 20 years. First EMI November 2026, last October 2046.

The first financial year has only five EMIs (November to March), so its totals are small. From FY 2027-28 each year has twelve EMIs totalling ₹5,20,694. In that year ₹4.18 lakh is interest and just ₹1.03 lakh is principal. By FY 2038-39, about twelve years in, the two are roughly equal, and in the last full year almost all of the money goes to principal.

Why the first EMIs are mostly interest

In month one, interest is charged on the full ₹50 lakh: ₹50,00,000 × 8.5% ÷ 12 = ₹35,417. That leaves ₹7,974 of the ₹43,391 EMI for principal. The next month the balance is ₹49,92,026, so the interest is a little lower (₹35,360) and the principal a little higher (₹8,031).

EMI no.MonthOpening balancePrincipalInterestClosing balance
1Nov 2026₹50,00,000₹7,974₹35,417₹49,92,026
2Dec 2026₹49,92,026₹8,031₹35,360₹49,83,995
3Jan 2027₹49,83,995₹8,088₹35,303₹49,75,907
12Oct 2027₹49,09,107₹8,618₹34,773₹49,00,489
143Sep 2038₹30,58,530₹21,727₹21,665₹30,36,804
240Oct 2046₹43,086₹43,086₹305₹0
Rows from the monthly view of the calculator. ₹50 lakh, 20 years, example rate 8.5%.

The pattern is slow at first and fast at the end. After 12 EMIs you still owe ₹49 lakh. Principal overtakes interest only at the 143rd EMI, in September 2038. The last EMI is ₹43,391 like all the others, but ₹43,086 of it is principal and only ₹305 is interest. This is also why prepaying early saves so much; the EMI calculator with prepayment shows by how much.

Financial year schedule and your income tax

Lenders issue an interest certificate for each financial year, April to March, showing the interest and principal you paid in it. Your tax return uses the same figures, which is why this calculator groups the schedule by financial year unless you choose otherwise. Under the rules in force for FY 2025-26:

  • Old regime, self-occupied home: up to ₹2 lakh of interest a year is deductible under Section 24(b), and up to ₹1.5 lakh of principal under Section 80C, shared with other 80C items such as PPF and life insurance.
  • In the example, FY 2027-28 has ₹4.18 lakh of interest, so only ₹2 lakh of it is deductible for a single borrower. Joint owners who are also co-borrowers can each claim up to the limit on their share.
  • Interest paid before the home is ready (pre-construction interest) is claimed in five equal parts from the year construction is completed, within the same ₹2 lakh limit.
  • New regime, now the default: no deduction for interest or principal on a self-occupied home. For a let-out home, interest is deductible against the rent.

Check the latest Budget and your chartered accountant before filing. The schedule here assumes one rate throughout, so use your lender’s certificate for the exact figures each year.

How a rate change rewrites the schedule

Most Indian home loans have a floating rate linked to an external benchmark, usually the RBI repo rate, and the rate is reset at least once every three months. When it moves, your schedule changes from that point. Banks usually keep the EMI the same and change the tenure unless you ask for something else. RBI’s 2023 rules on resetting floating rates require lenders to tell you about a change and give you the choice of a higher EMI, a longer tenure or a mix of both.

Here is what that means for the example. After 36 EMIs the balance is ₹46,74,300. If the rate then rises from 8.5% to 9.5%:

What happensEMIEMIs leftInterest still to pay
Rate stays at 8.5%₹43,391204₹41,77,497
Rate 9.5%, EMI unchanged₹43,391243₹58,69,358
Rate 9.5%, end date unchanged₹46,265204₹47,63,825
Example rates only. Balance after 36 EMIs on ₹50 lakh over 20 years.

Keeping the EMI the same adds 39 EMIs and about ₹16.9 lakh of interest. Paying ₹2,874 more each month keeps the end date and adds only about ₹5.9 lakh. When your rate goes up, run this calculator again with the outstanding balance, the new rate and the tenure left, and ask your lender for the option you want.

Why your bank’s schedule may differ slightly

  • Interest for the first few days: if the loan is paid out partway through a month, the bank charges interest for the days before your first EMI, often deducted at disbursement or added to the first EMI.
  • Rounding: banks round the EMI to the rupee and may round the interest each month, so balances can differ by a few rupees.
  • Pre-EMI: on an under-construction home paid out in stages, you pay only interest on the amount released until full EMIs start. The schedule here starts from the first full EMI.
  • Rate resets and prepayments: each one changes every later row. Use your latest statement’s balance as the new loan amount.
  • Insurance or fees added to the loan: some borrowers finance an insurance premium with the loan, which raises the amount and the EMI.

To see where an existing loan stands today, use the home loan EMI repayment calculator. To plan a faster payoff, try the increase EMI calculator. Before you borrow, check prices for the area on our property rates pages and read our home loan strategy for 2026.

Questions buyers ask

Frequently Asked Questions

How do I get the repayment schedule for my home loan? +

Your lender gives one with the sanction letter and can send an updated one on request. You can also build it here: enter the loan amount, rate, tenure and first EMI month, and the calculator lists every EMI with its principal, interest and balance.

What is an amortisation schedule? +

It is a table of every EMI on a loan, showing how much of each payment goes to interest, how much to principal, and what you still owe after it. Amortisation simply means paying off a loan in instalments.

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

Because interest is charged on the balance you still owe, and the balance is highest at the start. On a ₹50 lakh loan at an example 8.5%, ₹35,417 of the first ₹43,391 EMI is interest. The share falls every month as the balance shrinks.

Can I see my home loan schedule by financial year? +

Yes. Choose "Financial year (April to March)" and the yearly view totals principal and interest for each financial year, which is how your lender’s interest certificate and your tax return count them.

Does the repayment schedule change when the interest rate changes? +

Yes. From the reset onwards, either the EMI or the number of EMIs changes. Most banks keep the EMI and extend the tenure unless you ask otherwise. Run the calculator again with your current balance, the new rate and the tenure left to get the new schedule.

Why does my bank’s schedule differ slightly from this one? +

Usually because of rounding, interest for the days before the first EMI, a pre-EMI period, or a rate change or prepayment along the way. The method is the same reducing-balance calculation.

When does the principal part of my EMI become bigger than the interest? +

It depends on the rate and tenure. On a 20-year loan at an example 8.5% it happens at the 143rd EMI, nearly 12 years in. A shorter tenure or a lower rate brings it forward.

Is the EMI the same every month? +

Yes, as long as the rate does not change and you do not prepay. Only the split between interest and principal changes. The last EMI can be slightly smaller if only a small balance is left.

Calculators are simplified models for orientation, not financial advice. Rates, taxes and rules change — verify with your bank and chartered accountant. For a scenario built around your exact situation, talk to an advisor.

A happy family in their new home with the money they got back

Brokerage back offer

Book your home with us and get the brokerage back*

Builders pay a brokerage to whoever brings them a buyer. Book through Property Nivesh and we give it back to you.

*Brokerage is part of the discussion with our advisor.

Unbiased advice. Your data is never sold to builders or brokers.