EMI Calculation Formula India: Excel & Manual Method

EMI Calculation Formula India: EMI = P × r × (1+r)^n / ((1+r)^n – 1). P = Principal, r = Monthly interest rate (Annual rate / 12 / 100), n = Tenure in months. For a ₹10L loan at 10% for 5 years (n=60): r=0.00833. EMI = 10,00,000 × 0.00833 × (1.00833)^60 / ((1.00833)^60 – 1) = ₹21,247. Use INDwallet EMI Calculator for instant results.

AI Summary: EMI Calculation Formula India

• The EMI formula uses reducing balance method — interest calculated on outstanding principal.
• Manual calculation requires finding (1+r)^n — use scientific calculator or Excel.
• Excel PMT function: =PMT(annual_rate/12, tenure_months, -loan_amount).
• Always convert annual interest rate to monthly (r = rate/12/100).
• Total interest = (EMI × n) – Principal.

1. The EMI Formula Explained

EMI = P × r × (1+r)^n / ((1+r)^n – 1)

This is the reducing balance formula used by all banks and NBFCs in India.

• P = Principal loan amount (e.g., ₹25,00,000)
• r = Monthly interest rate = (Annual rate / 12) / 100
• n = Tenure in months (e.g., 20 years = 240 months)

Interest is calculated on the outstanding principal each month, not the original amount.

This is why EMI reduces principal slowly in early years and faster later.

2. Step-by-Step Manual EMI Calculation

Let’s calculate EMI for a ₹10,00,000 loan at 10% annual interest for 5 years (60 months).

1. Calculate monthly interest rate (r): r = 10 / 12 / 100 = 0.008333
2. Calculate (1+r)^n: (1.008333)^60 = 1.6453 (use scientific calculator or Excel =POWER(1.008333,60))
3. Numerator: P × r × (1+r)^n = 10,00,000 × 0.008333 × 1.6453 = 13,710.8
4. Denominator: (1+r)^n – 1 = 1.6453 – 1 = 0.6453
5. EMI = Numerator / Denominator: 13,710.8 / 0.6453 = ₹21,247

Total interest = (EMI × n) – P = (21247 × 60) – 10,00,000 = ₹2,74,820.

Try with different numbers using INDwallet EMI Calculator.

3. Mistakes to Avoid When Calculating EMI Manually

4. How to Use Excel PMT Function for EMI

The Excel PMT function calculates EMI instantly. Syntax: =PMT(rate, nper, pv, [fv], [type])

• rate: Monthly interest rate = Annual rate / 12. Example: 9%/12 = 0.0075.
• nper: Total number of payments (tenure in months). Example: 240 for 20 years.
• pv: Present value (loan amount). Use negative value to get positive EMI.

Example: ₹25,00,000 loan at 9% for 20 years.

=PMT(9%/12, 240, -2500000) → Result: ₹22,493 (monthly EMI).

To see total interest: = (EMI * n) – loan amount.

For step-by-step, read EMI Calculator India Guide.

5. Real India Examples: Manual vs Excel

Excel PMT matches manual calculation exactly. Use EMI Calculator to avoid both.

6. Reducing Balance vs Flat Rate: Why Formula Matters

Banks use reducing balance method (the formula above). Some informal lenders quote flat rate.

Flat rate interest is calculated on full principal always — you pay nearly double interest.

Always confirm reducing balance. Read personal loan EMI planning to avoid traps.

7. How Prepayment Changes the EMI Calculation

Prepayment reduces outstanding principal (P). After prepayment, you can:

• Keep EMI same, reduce tenure: Recalculate n with new P. Saves more interest.
• Keep tenure same, reduce EMI: Recalculate EMI with new P and original n.

Example: On ₹25L loan at 9% for 20y, EMI=₹22,493. After 5 years, prepay ₹2L. New outstanding = ₹19.5L.

Option 1 (reduce tenure): New tenure ≈ 13 years remaining (save 2 years). Option 2 (reduce EMI): New EMI ≈ ₹19,500.

Use Prepayment Calculator to model scenarios.

8. The EMI Calculation Flow

9. Decision: When to Calculate EMI Yourself?

• If you’re learning loan math → Manual calculation builds understanding.
• If you’re comparing multiple loan offers → Excel PMT is faster.
• If you need amortization schedule → Use INDwallet EMI Calculator.
• If you’re on the go → Online calculator is most convenient.

10. Explore More INDwallet Loan Tools

• EMI Calculator – instant monthly payment.
• Prepayment Calculator – see savings from extra payments.
• Home Loan EMI Strategy – save lakhs.
• EMI to Income Ratio – safe limits.
• EMI Calculator Guide – complete usage.