Wondering how to find EMI for any loan? Banks calculate your EMI using a fixed formula. Whether you want to know how to calculate EMI for a personal loan, how to calculate home loan EMI for a ₹50 lakh property, or how to calculate car loan EMI on a 5-year tenure — the underlying math is the same. Understanding it helps you verify your bank's figures, compare offers quickly, and negotiate better.
The EMI Formula
Where:
- P = Principal loan amount (e.g. ₹50,00,000)
- R = Monthly interest rate = Annual rate ÷ 12 ÷ 100 (e.g. 8.5% → 0.085÷12 = 0.007083)
- N = Loan tenure in months (e.g. 20 years → 240 months)
Worked Example: ₹20 Lakh Loan at 9% for 5 Years
P = ₹20,00,000 | Annual Rate = 9% | Tenure = 5 years = 60 months
- R = 9 ÷ 12 ÷ 100 = 0.0075
- (1 + R)^N = (1.0075)^60 = 1.5657
- Numerator = 20,00,000 × 0.0075 × 1.5657 = 23,485
- Denominator = 1.5657 − 1 = 0.5657
- EMI = 23,485 ÷ 0.5657 = ₹41,519/month
The "Thumb Rule" Shortcut
For a rough estimate without any calculation:
| Loan Amount | Rate | Tenure | Approx EMI |
|---|---|---|---|
| ₹10 lakh | 8.5% | 10 years | ≈ ₹12,400 |
| ₹10 lakh | 8.5% | 20 years | ≈ ₹8,680 |
| ₹1 lakh | 8.5% | Any | Scale proportionally |
Rule of thumb: For a 20-year home loan at ~8.5%, EMI ≈ ₹868 per ₹1 lakh borrowed. For ₹50 lakh → ₹868 × 50 = ₹43,400 (actual: ₹43,391 ✓)
EMI per ₹1 Lakh Borrowed (Quick Reference)
| Interest Rate | 10 Years | 15 Years | 20 Years | 25 Years |
|---|---|---|---|---|
| 7.5% | ₹1,186 | ₹927 | ₹806 | ₹739 |
| 8.0% | ₹1,213 | ₹956 | ₹836 | ₹772 |
| 8.5% | ₹1,240 | ₹985 | ₹868 | ₹805 |
| 9.0% | ₹1,267 | ₹1,014 | ₹900 | ₹839 |
| 9.5% | ₹1,294 | ₹1,044 | ₹932 | ₹873 |
| 10.0% | ₹1,322 | ₹1,075 | ₹965 | ₹909 |
Why Your Bank's EMI Might Differ Slightly
Banks may use slightly different compounding conventions (daily vs monthly), round up to the nearest rupee, or add insurance/processing fees into the EMI. If your bank's EMI differs by more than ₹50–100 from this formula, ask for a detailed amortisation schedule.
How to Calculate EMI in Excel
If you prefer a spreadsheet, Excel has a built-in PMT function that does the entire calculation in one line:
For a ₹20 lakh loan at 9% for 5 years: =PMT(9%/12, 60, -2000000) returns ₹41,519 — the same answer as the formula above. The minus sign before principal flips the result to a positive number.
How to Calculate Bike EMI and Two-Wheeler Loan EMI
Bike loans typically run for 1–3 years at 9.5–13% interest. The same EMI formula applies — a ₹1 lakh bike loan at 11% for 3 years comes to ~₹3,273/month. Many showrooms quote inflated "flat rates" — always re-check using the reducing-balance formula above.
How to Reduce Your EMI Without Paying More
- Negotiate the rate: 0.25% less on ₹50L = ₹900/month cheaper EMI
- Longer tenure: 20yr vs 15yr reduces EMI by ~₹6,000/month (but costs more total)
- Larger down payment: Borrow ₹40L instead of ₹50L → EMI drops by ₹8,678
- Balance transfer: Shift to a lower-rate bank after 3 years if rates have fallen