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 year | EMIs | Principal | Interest | Closing balance |
|---|---|---|---|---|
| FY 2026-27 | 5 | ₹40,441 | ₹1,76,514 | ₹49,59,559 |
| FY 2027-28 | 12 | ₹1,03,086 | ₹4,17,608 | ₹48,56,473 |
| FY 2030-31 | 12 | ₹1,32,909 | ₹3,87,785 | ₹44,89,250 |
| FY 2035-36 | 12 | ₹2,02,992 | ₹3,17,702 | ₹36,26,291 |
| FY 2038-39 | 12 | ₹2,61,718 | ₹2,58,976 | ₹29,03,174 |
| FY 2040-41 | 12 | ₹3,10,030 | ₹2,10,664 | ₹23,08,292 |
| FY 2045-46 | 12 | ₹4,73,509 | ₹47,185 | ₹2,95,312 |
| FY 2046-47 | 7 | ₹2,95,312 | ₹8,426 | ₹0 |
| All 20 years | 240 | ₹50,00,000 | ₹54,13,879 |
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. | Month | Opening balance | Principal | Interest | Closing balance |
|---|---|---|---|---|---|
| 1 | Nov 2026 | ₹50,00,000 | ₹7,974 | ₹35,417 | ₹49,92,026 |
| 2 | Dec 2026 | ₹49,92,026 | ₹8,031 | ₹35,360 | ₹49,83,995 |
| 3 | Jan 2027 | ₹49,83,995 | ₹8,088 | ₹35,303 | ₹49,75,907 |
| 12 | Oct 2027 | ₹49,09,107 | ₹8,618 | ₹34,773 | ₹49,00,489 |
| 143 | Sep 2038 | ₹30,58,530 | ₹21,727 | ₹21,665 | ₹30,36,804 |
| 240 | Oct 2046 | ₹43,086 | ₹43,086 | ₹305 | ₹0 |
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 happens | EMI | EMIs left | Interest still to pay |
|---|---|---|---|
| Rate stays at 8.5% | ₹43,391 | 204 | ₹41,77,497 |
| Rate 9.5%, EMI unchanged | ₹43,391 | 243 | ₹58,69,358 |
| Rate 9.5%, end date unchanged | ₹46,265 | 204 | ₹47,63,825 |
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.