How to Calculate EMI — Home, Car & Personal Loans

Equated Monthly Instalment (EMI) is how most Indians repay loans — from home mortgages to car finance and personal credit. Understanding how EMI is calculated helps you compare offers, plan cash flow and avoid over-borrowing.

What is EMI?

EMI is a fixed monthly payment that includes both principal repayment and interest. Early in the loan, a larger share goes to interest; over time, more goes toward principal. This is called a reducing-balance schedule.

The EMI formula

Banks use the standard reducing-balance formula:

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

Where:

• P = loan amount (principal)
• r = monthly interest rate (annual rate ÷ 12)
• n = total number of monthly instalments

If the rate is 0%, EMI is simply principal divided by tenure in months.

Example calculation

Suppose you borrow ₹25,00,000 at 8.5% per year for 20 years (240 months).

• Monthly rate r = 8.5 ÷ 12 ÷ 100 = 0.007083
• EMI ≈ ₹21,696
• Total repayment ≈ ₹52.07 lakh
• Total interest ≈ ₹27.07 lakh

Use our free EMI calculator to try your own numbers instantly. For investment planning alongside loan repayment, model returns with the SIP calculator.

Step-by-step EMI calculation

Here is how EMI is calculated step by step for a standard reducing-balance loan in India:

1. Convert annual rate to monthly — Divide the annual interest rate by 12 and by 100. Example: 9% annual → 0.0075 monthly.
2. Set tenure in months — Multiply loan years by 12. A 15-year home loan = 180 months.
3. Apply the EMI formula — EMI = P × r × (1+r)^n ÷ ((1+r)^n − 1).
4. Round to currency — Banks round to the nearest rupee on statements.
5. Verify total interest — Multiply EMI by n and subtract principal P for lifetime interest.

Walk through each step in MerQPrime’s loan repayment calculator — it shows the full amortization schedule so you can see how each month splits principal and interest. If you run a business and need to price products after loan costs, pair EMI planning with the profit margin calculator.

What affects your EMI?

Loan amount

Higher principal directly increases EMI. A larger down payment reduces P and lowers your monthly burden.

Interest rate

Even a 0.5% change in annual rate can add lakhs in total interest over a long home loan.

Tenure

Longer tenure lowers EMI but increases total interest paid. Shorter tenure raises EMI but saves interest.

Tips before you sign

1. Compare EMI across lenders, not just headline rates.
2. Check processing fees and insurance bundled into the loan.
3. Model prepayment scenarios if your bank allows them.
4. Keep EMI within a comfortable share of monthly income (often cited as 40–50% of net income for all EMIs combined).

Frequently asked questions

Is EMI the same every month?

Yes for standard fixed-rate loans. Floating-rate loans can change EMI or tenure when rates reset.

Can I calculate EMI without Excel?

Yes. MerQPrime’s EMI calculator runs entirely in your browser — enter amount, rate and tenure for instant results plus a full amortization table.