How to Calculate Your Home Loan EMI: Formula, Examples and 2026 Rates

Dasadia Editorial Team · Updated June 2026

Your EMI — Equated Monthly Instalment — is the single number that decides whether a home loan fits your budget. It is the fixed amount you pay your lender every month until the loan is cleared, and it bundles two things together: a slice of the principal you borrowed and the interest on what you still owe. Get this number right before you sign, and you avoid the most common home-buying mistake: borrowing more than your monthly cash flow can comfortably carry.

The good news is that the maths behind an EMI is fixed and easy to follow. This guide shows you exactly how it is worked out — by hand, in Excel, and with online calculators — using India’s mid-2026 interest rates, real worked examples, and the levers you can pull to bring your EMI down.

Key Takeaways

Your EMI is calculated with one standard formula based on three inputs: loan amount (P), monthly interest rate (R) and tenure in months (N).
Indian home loans use the reducing-balance method — interest is charged only on the outstanding principal, so your interest share shrinks every month.
As of June 2026, home loan rates run from about 7.10% to 10.15% p.a., with most borrowers offered 7.65%–8.50% depending on credit score and lender.
A longer tenure lowers your EMI but raises total interest sharply; a shorter tenure does the opposite.
Excel's PMT function and any lender's online calculator give the same answer as the formula — instantly and without arithmetic errors.
Prepaying early and keeping the EMI the same (so the tenure shortens) saves the most interest over the life of the loan.

What Is a Home Loan EMI?

An EMI is a fixed monthly payment that stays the same through the loan tenure (on a fixed-rate loan), made up of two parts. The principal component repays the money you borrowed. The interest component is the lender’s charge for that month, calculated on the balance still outstanding. Because most of the principal is still unpaid at the start, the early EMIs are interest-heavy; as the balance falls, the interest share drops and more of each EMI goes towards principal. The total payment, though, stays level — that is the whole point of an equated instalment.

Indian banks and housing finance companies calculate home loan EMIs on a reducing-balance basis, meaning interest each month is applied only to the remaining principal, not the original loan amount. This is more borrower-friendly than the flat-rate method used for some other loans, where interest is charged on the full amount throughout.

Source: ICICI Bank · Bajaj Finserv

The Home Loan EMI Formula

Every EMI calculator on the internet uses the same equation. It looks intimidating but only has three moving parts:

EMI = [ P × R × (1 + R)^N ] ÷ [ (1 + R)^N − 1 ]

The numerator grows the EMI with the loan size and rate; the denominator spreads it across the tenure. The longer the tenure (larger N), the smaller each instalment — but the more months of interest you pay in total.

Source: Shriram Finance · Groww

How to Calculate Your EMI Manually

Let’s work a realistic example: a ₹50 lakh home loan at 8.5% per annum for 20 years.

Step 1 — Find R: 8.5 ÷ 12 ÷ 100 = 0.007083 (the monthly rate).
Step 2 — Find N: 20 years × 12 = 240 months.
Step 3 — Compute (1 + R)ᴺ: (1.007083)^240 ≈ 5.442.
Step 4 — Plug in: EMI = [50,00,000 × 0.007083 × 5.442] ÷ [5.442 − 1].
Step 5 — Result: EMI ≈ ₹43,391 per month.

Over the full 20 years you would pay roughly ₹1.04 crore in total — the ₹50 lakh principal plus about ₹54.1 lakh in interest. That interest figure is exactly why the inputs you choose matter so much.

Source: BankBazaar · ICICI Bank

How to Calculate EMI in Excel

If you would rather not do the powers by hand, Excel (or Google Sheets) does it in one line with the built-in PMT function:

=PMT(rate, nper, -pv)

For our example you would type =PMT(8.5%/12, 240, -5000000) and Excel returns about ₹43,391 — the same answer as the formula. To see the month-by-month split of principal and interest, add the PPMT (principal paid) and IPMT (interest paid) functions for each period; together they build a full amortisation schedule.

Source: Stable Investor · Kotak Mahindra Bank

Using an Online EMI Calculator

The fastest route is an online home loan EMI calculator — every major lender and finance portal offers one for free. You enter three values (loan amount, interest rate and tenure) and it instantly shows your EMI, the total interest, the total amount payable, and often a year-wise breakup or pie chart of principal versus interest. Because the tool applies the standard formula automatically, it removes the risk of arithmetic slips and lets you test different scenarios in seconds. Always confirm the rate the calculator uses matches the actual rate your lender quotes you, since advertised “starting” rates are usually reserved for the strongest credit profiles.

Source: Bajaj Finserv · Groww

Principal vs Interest: How Amortisation Works

Although your EMI stays level, its internal split shifts every month. In month one of our ₹50 lakh example, almost ₹35,400 of the ₹43,391 EMI is interest and only about ₸8,000 is principal. Years later, that ratio flips — most of each EMI chips away at the principal. This front-loading of interest is the single most important thing to understand about home loans, and it explains why prepaying early in the tenure saves dramatically more interest than prepaying near the end.

Source: FinCalC · EMI Calculator

Worked Examples at Today's Rates

Here is what monthly EMIs look like across common loan sizes and tenures, all calculated at a representative 8.5% p.a. reducing-balance rate (mid-2026):

Read across each row to see how stretching the tenure lowers the monthly outgo — and read the next section to see what that convenience costs you in total interest.

Source: Author calculation using the standard EMI formula · rate range per ClearTax · BankBazaar

Factors That Change Your EMI

Four inputs move your EMI. The loan amount and interest rate push it up; a longer tenure pulls the monthly figure down (while raising total interest). Your credit score matters too — a CIBIL score of 750+ unlocks the lowest advertised rates, while a weaker score attracts a higher rate or a rejection. A larger down payment reduces the principal and the loan-to-value ratio, often earning a better rate as well.

Tenure effect on a ₹50 lakh loan at 8.5%:

Interest-rate effect on the same ₹50 lakh loan over 20 years:

Notice the asymmetry: moving from a 20-year to a 30-year tenure trims the EMI by under ₹5,000 but adds more than ₹34 lakh in interest. Even a 0.5% rate difference is worth several lakh over the life of the loan — which is why shopping around and protecting your credit score pays off.

Source: Author calculation · Finance Buddha · ClearTax

Fixed vs Floating: Which Rate to Pick?

The rate type shapes how your EMI behaves over time. A floating rate is tied to the RBI repo rate through the External Benchmark Lending Rate (EBLR) or Repo Linked Lending Rate (RLLR), so it falls when the RBI cuts and rises when it hikes. A fixed rate locks your EMI for a set period at a small premium.

As of June 2026 the RBI repo rate sits at 5.25% — unchanged since the December 2025 cut, after a cumulative 1.25% of cuts through 2025 — keeping home loan rates near multi-year lows. With the central bank’s stance neutral, most borrowers continue to favour floating rates.

Source: Reserve Bank of India · BankBazaar · Finance Buddha

How to Reduce Your Home Loan EMI

Make a bigger down payment so you borrow less principal to begin with.
Improve your credit score before applying — 750+ typically earns the lowest rate band.
Choose a longer tenure to cut the monthly figure (accepting more total interest in exchange).
Negotiate, or move to an EBLR-linked floating rate so RBI cuts reach you faster.
Consider a balance transfer if your current rate is more than about 1% above the market.
Add a co-applicant (such as a working spouse) to improve eligibility and the rate offered.

Source: Finance Buddha · HDFC Bank

Prepayment: Reduce the EMI or the Tenure?

When you have surplus cash and make a part-prepayment, your lender lets you either lower the EMI (keeping the tenure) or shorten the tenure (keeping the EMI). For maximum interest savings, keep the EMI the same and let the tenure shrink.

Keep EMI same, shorten tenure

Lower EMI, keep tenure

Either way, prepay early. In our ₹50 lakh example, a single ₹5 lakh prepayment after the first year — with the EMI held steady — clears the loan in about 16 years instead of 20, saving roughly four years of instalments. Floating-rate home loans to individuals carry no prepayment penalty in India, so there is rarely a downside.

Source: FinCalC · Author calculation

Verified Key Facts

EMI formula EMI = [P×R×(1+R)ᴺ] ÷ [(1+R)ᴺ−1]: Verified (Shriram Finance, Groww, ICICI).
Indian home loans use the reducing-balance method: Verified (ICICI, Bajaj Finserv).
RBI repo rate 5.25%, unchanged since the 5 December 2025 cut: Verified (RBI, BankBazaar).
Home loan rates ~7.10%–10.15% p.a. in June 2026: Verified (ClearTax, BankBazaar, Finance Buddha).
₹50 lakh at 8.5% for 20 years → EMI ≈ ₹43,391, interest ≈ ₹54.1 lakh: Verified (author calculation).
Excel =PMT(rate, nper, -pv) returns the same EMI: Verified (Stable Investor, Kotak, BankBazaar).

Frequently Asked Questions

How is home loan EMI calculated?

It is calculated with the formula EMI = [P × R × (1 + R)ᴺ] ÷ [(1 + R)ᴺ − 1], where P is the loan amount, R is the monthly interest rate (annual rate ÷ 12 ÷ 100) and N is the tenure in months. Indian lenders apply this on a reducing-balance basis, so interest is charged only on the outstanding principal each month.

What is the EMI for a ₹50 lakh home loan?

At about 8.5% p.a. for 20 years, the EMI is roughly ₹43,391 per month, with total interest of about ₹54.1 lakh over the tenure. The exact figure depends on your actual rate and tenure.

What is the EMI for a ₹30 lakh home loan?

At 8.5% p.a., a ₹30 lakh loan works out to about ₹29,542 over 15 years, ₹26,035 over 20 years, or ₹24,157 over 25 years.

How do I calculate EMI in Excel?

Use the PMT function: =PMT(rate, nper, -pv). Enter the monthly rate (annual rate ÷ 12), the number of months, and the loan amount as a negative number. For example, =PMT(8.5%/12, 240, -5000000) returns about ₹43,391.

What are the current home loan interest rates in India?

As of June 2026, home loan rates range from about 7.10% to 10.15% p.a. The lowest rates (around 7.10–7.50%) come from select public-sector banks for borrowers with a credit score of 750 or above; most borrowers are offered between 7.65% and 8.50%. Always confirm the live rate on the lender’s official website.

Does a longer tenure reduce my EMI?

Yes — a longer tenure lowers the monthly EMI because the loan is spread over more months. However, it increases the total interest you pay. On a ₹50 lakh loan at 8.5%, moving from 20 to 30 years cuts the EMI by under ₹5,000 a month but adds more than ₹34 lakh in interest.

What is the difference between fixed and floating interest rates?

A fixed rate keeps your EMI the same for an agreed period but usually starts 0.5–1% higher. A floating rate is linked to the RBI repo rate (via EBLR/RLLR) and changes when the RBI moves rates, so your EMI can rise or fall. Most borrowers currently choose floating rates.

Is it better to reduce the EMI or the tenure after prepayment?

Keeping the EMI the same and reducing the tenure saves more total interest and closes the loan sooner. Reducing the EMI eases monthly cash flow but saves less interest overall. Prepaying early in the tenure delivers the biggest savings either way.

How does my credit score affect my EMI?

Your credit score determines the interest rate you are offered, which directly affects the EMI. A CIBIL score of 750 or above typically unlocks the lowest rates; a lower score means a higher rate (and therefore a higher EMI) or a possible rejection.

Is there a penalty for prepaying a home loan?

For floating-rate home loans taken by individuals, lenders in India generally cannot charge a prepayment or foreclosure penalty. Fixed-rate loans may carry a charge, so check your loan agreement before prepaying.

What is the reducing-balance method?

Under reducing balance, interest each month is charged only on the principal still outstanding, not on the original loan amount. As you repay, the principal falls and so does the interest portion of each EMI — which is why your interest outgo declines over the tenure.

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

Home loans are front-loaded: at the start, the outstanding principal is highest, so the interest charge is largest and the principal repaid is small. The split gradually reverses, with later EMIs going mostly towards principal. This is why early prepayment saves the most interest.

Conclusion and Next Steps

Calculating your home loan EMI comes down to three inputs and one formula — and a calculator or Excel’s PMT function does the heavy lifting in seconds. The real skill is using that number wisely: pick a tenure your monthly budget can carry without strain, protect the credit score that earns you the best rate, and plan to prepay early so more of your money repays principal rather than interest.

Next step: run your own figures at your lender’s actual quoted rate, compare at least three or four lenders, and stress-test the EMI against a rate that is 1–2% higher so you are comfortable even if rates move. Then you can shortlist properties with a budget you genuinely understand.

Sources and References

Disclaimer

This article is for informational purposes only and does not constitute financial advice. Interest rates, EMI figures and repo-rate data are indicative as of June 2026 and change frequently. Always verify the current rate, charges and terms on your lender’s official website or with the Reserve Bank of India before making any borrowing decision.

Planning Your Home Budget in Andheri East?

153 East by Dasadia Developers LLP is a MahaRERA-registered (PR1180002502968) residential project in J.B. Nagar, Andheri East, offering 1–4 BHK homes. Get the brochure with floor plans and details to match the right configuration to your EMI budget, or arrange a site visit.