How to Calculate Home Loan EMI Manually (Formula + Examples)
Every home buyer faces the same question: how much will I pay every month? Banks calculate your EMI using a fixed mathematical formula — and once you understand it, you can plan your budget with confidence, compare offers from different lenders intelligently, and avoid surprises over a 20-year loan.
⚡ Want the answer right now? Skip the math — enter your loan details and get instant results.
Open EMI Calculator →What is EMI?
EMI stands for Equated Monthly Instalment — the fixed amount you pay your lender every month until the loan is fully repaid. Each payment has two components:
- Principal repayment — reduces your outstanding loan balance
- Interest charge — cost of borrowing for that month
In the early months, most of your EMI goes toward interest. As the loan matures, the split gradually shifts toward principal. This is called an amortising loan structure, and it's why making prepayments early in the loan tenure saves far more than prepaying later.
The EMI Formula
All Indian banks and RBI-regulated NBFCs use this standard formula:
The formula looks complex, but it's just three numbers and one exponent. The trickiest part
is computing (1 + r)ⁿ — use the ^ key on any scientific calculator,
or the POWER() function in Excel/Google Sheets.
Step-by-Step Calculation
- Convert annual rate to monthly: divide by 12, then by 100.
Example: 8.5% annual → r = 8.5 ÷ 12 ÷ 100 = 0.007083 - Calculate the exponent (1 + r)ⁿ:
Example: (1 + 0.007083)²⁴⁰ ≈ 5.2844 - Apply the numerator: P × r × (1 + r)ⁿ
Example: 50,00,000 × 0.007083 × 5.2844 = 1,87,199 - Apply the denominator: (1 + r)ⁿ − 1
Example: 5.2844 − 1 = 4.2844 - Divide and round: 1,87,199 ÷ 4.2844 ≈ ₹43,391
Worked Example — ₹50 Lakh Home Loan
Let's work through a realistic scenario: Ravi takes a home loan of ₹50,00,000 from SBI at 8.5% per annum for 20 years.
| Metric | Amount |
|---|---|
| Loan Amount (Principal) | ₹50,00,000 |
| Monthly EMI | ₹43,391 |
| Total Amount Paid (240 months) | ₹1,04,13,840 |
| Total Interest Paid | ₹54,13,840 |
| Interest as % of Principal | 108% |
That means Ravi pays more than double the original loan amount over 20 years — ₹54 lakh in interest alone. This is why the loan tenure decision matters so much.
🏠 Try your own numbers Change the amount, rate, or tenure and see the EMI update instantly.
Calculate My EMI →How Tenure Affects Your EMI
One of the most important decisions is the loan tenure. Here's how the same ₹50 lakh at 8.5% looks across different tenures:
| Tenure | Monthly EMI | Total Interest | Total Paid |
|---|---|---|---|
| 10 years | ₹61,993 | ₹24,39,160 | ₹74,39,160 |
| 15 years | ₹49,237 | ₹38,62,660 | ₹88,62,660 |
| 20 years | ₹43,391 | ₹54,13,840 | ₹1,04,13,840 |
| 25 years | ₹40,260 | ₹70,78,000 | ₹1,20,78,000 |
| 30 years | ₹38,446 | ₹88,40,560 | ₹1,38,40,560 |
Going from 20 to 30 years saves only ₹4,945 per month in EMI — but costs an extra ₹34 lakh in interest. The 10-year loan costs ₹18,602 more per month but saves ₹30 lakh overall.
- Shorter tenure = higher EMI but far less total interest
- The "right" tenure is where your EMI stays below 40% of take-home salary
- Consider starting with a longer tenure and making annual prepayments to cut interest
3 Practical Tips to Reduce Your EMI
1. Increase your down payment
Every extra rupee in the down payment reduces your principal directly. On a ₹80 lakh property, putting 30% down (₹24 lakh) instead of 20% (₹16 lakh) reduces your loan by ₹8 lakh — saving roughly ₹6,943 in monthly EMI at 8.5% over 20 years, and over ₹8 lakh in total interest.
2. Negotiate the interest rate
Even 0.25% matters more than most people think. On a ₹50 lakh, 20-year loan:
- At 8.5%: EMI = ₹43,391, Total Interest = ₹54.14 lakh
- At 8.25%: EMI = ₹42,603, Total Interest = ₹52.25 lakh
- Difference: ₹788/month · ₹1.89 lakh over 20 years
Always negotiate, especially if you have a good CIBIL score (750+).
3. Make annual part-prepayments
Prepaying even ₹50,000 per year in the first 5 years of a 20-year loan can reduce the effective tenure by 4–5 years and save ₹10–15 lakh in interest. Most banks allow prepayment without penalty for floating-rate loans.
Frequently Asked Questions
Yes — the same formula applies to all reducing-balance loans regardless of type. The only difference is the interest rate and tenure: personal loans typically carry higher rates (10–18%) and shorter tenures (1–5 years), while home loans are lower rate, longer tenure.
Most financial advisors recommend keeping all EMIs combined below 40–50% of take-home monthly income. Banks typically approve loans where the EMI doesn't exceed 50–60% of monthly net salary.
Indirectly yes — a higher CIBIL score (750+) qualifies you for lower interest rates, which directly lowers your EMI. A 0.5% rate reduction on a ₹50 lakh, 20-year loan saves ₹1,576/month and ₹3.78 lakh in total interest.
Yes. Use the built-in PMT function:
=PMT(rate/12, tenure_months, -principal)
Example: =PMT(8.5%/12, 240, -5000000) returns ₹43,391.
📊 Ready to calculate your exact EMI? Use our free calculator — no sign-up required.
Open EMI Calculator →