Guides / How to Calculate EMI: Formula, Worked Example and Ways to Reduce It

How to Calculate EMI: Formula, Worked Example and Ways to Reduce It

Your EMI (Equated Monthly Instalment) is the fixed amount you pay every month to repay a loan. It depends on three things: the loan amount, the interest rate and the tenure. The formula is:

EMI = P × r × (1 + r)ⁿ ÷ [(1 + r)ⁿ − 1]

where P is the loan amount, r is the monthly interest rate (the annual rate ÷ 12 ÷ 100) and n is the number of months. You can skip the maths with the EMI Calculator, but understanding the formula helps you spot how to pay less.

A worked example

Take a ₹5,00,000 loan at 12% a year for 2 years.

1. P = 5,00,000
2. r = 12 ÷ 12 ÷ 100 = 0.01 a month
3. n = 2 × 12 = 24 months
4. (1 + r)ⁿ = 1.01²⁴ = 1.26973
5. EMI = 5,00,000 × 0.01 × 1.26973 ÷ (1.26973 − 1) = 6,348.67 ÷ 0.26973 = ₹23,537

Over 24 months you pay ₹5,64,882 in total, so the interest is ₹64,882.

What each EMI actually pays

Every EMI covers two things: the interest for that month, and part of the principal. The interest each month is the outstanding balance × r.

The EMI stays the same, but the interest share falls and the principal share rises each month. This is called reducing balance interest, and it is how most bank loans work.

Why early EMIs are mostly interest

On a long loan the effect is dramatic. For a ₹50 lakh home loan at 8.5% for 20 years (EMI ₹43,391):

In year 1 about 81% of what you pay is interest. This is why prepaying early saves far more than prepaying late.

How to calculate EMI in Excel or Google Sheets

Use the PMT function:

=PMT(rate/12, months, -loan_amount)

For the example above, =PMT(12%/12, 24, -500000) gives ₹23,537.

Flat rate vs reducing rate: a costly trap

Some lenders and dealers quote a flat rate, where interest is charged on the full original amount for the whole tenure. It sounds cheaper than it is.

For the same ₹5 lakh loan over 2 years:

The flat 12% loan has the same cost as a reducing-balance loan at about 21.6%. Always ask for the reducing-balance rate (or the annual percentage rate) so you can compare loans fairly.

What changes your EMI

Here is a ₹50 lakh home loan, changing one thing at a time:

• Rate: a 0.5% rise adds about ₹1,600 to the monthly EMI and ₹3.8 lakh to the total interest.
• Tenure: stretching from 20 to 25 years cuts the EMI by about ₹3,100 but adds nearly ₹17 lakh of interest.

For more on tenure, read how to choose the right loan tenure.

What happens when your interest rate changes

If your loan has a floating rate, a rate change usually does not change your EMI immediately. Lenders often keep the EMI the same and change the tenure instead. If the rate on the ₹50 lakh loan rises from 8.5% to 9% and you keep paying ₹43,391, the loan takes about 22 years 4 months instead of 20 years. Check your statements, and consider paying a little more when rates rise.

How to reduce your EMI and your total interest

1. Choose a lower rate. Compare lenders, keep a good credit score and ask your current lender to match offers. See credit score basics.
2. Increase the down payment. A smaller loan means a smaller EMI and less interest.
3. Prepay. Even small extra payments cut the interest. A lump sum of ₹2 lakh every year on the ₹50 lakh loan finishes it in about 11 years and saves roughly ₹27 lakh of interest. Try this in the Loan Prepayment Calculator.
4. Switch lenders if the saving covers the costs. See the home loan balance transfer guide.
5. Lengthen the tenure only if you must, and prepay later when you can.

Do banks charge for prepayment?

Since 1 January 2026, RBI rules do not allow lenders to charge prepayment fees on floating-rate loans to individuals for non-business purposes, for loans sanctioned or renewed from that date. Fixed-rate loans can still carry charges. Check your sanction letter and Key Facts Statement before you decide.

How much EMI can you afford?

A common guide is to keep all your EMIs within about 40% of your monthly income, and lenders often use a limit of 40% to 60%. If you earn ₹1 lakh a month and have no other loans, an EMI of ₹40,000 is a comfortable upper limit. The Loan Eligibility Calculator shows how much loan that EMI supports, and the guide to home loan eligibility explains how banks decide.

What the EMI does not include

• Processing fee and other upfront charges.
• Insurance premiums, if bundled with the loan.
• Late payment charges.

Ask for the total cost of the loan, not just the EMI.

EMI examples for common loans

The formula is the same for every loan type. Only the amount, rate and tenure change.

The education loan EMI is higher because the interest during the course (₹8.4 lakh in this example) is added to the loan before repayment starts. These rates are only examples. Your actual rate depends on your lender, your credit profile and the type of loan.

What to check in your loan papers

Lenders must give you a Key Facts Statement that lists the EMI, the annual percentage rate, the fees and the total amount you will repay. Before you sign, check:

1. Rate type. Is it fixed or floating? If floating, what is it linked to, and how often does it reset?
2. Total cost. Compare the total amount payable, not just the EMI.
3. Fees. Processing fee, documentation charges and any insurance bundled into the loan.
4. Prepayment and foreclosure terms. Floating-rate loans to individuals cannot carry prepayment charges, but fixed-rate loans can.
5. Late payment charges. How much, and from which day.

A quick sanity check: put the same amount, rate and tenure into the EMI Calculator. If your lender's EMI is clearly higher, ask why. The cause is often fees added to the loan or a flat rate presented as a reducing rate.

Common mistakes

• Comparing EMIs only. A lower EMI over a longer tenure usually costs more.
• Ignoring flat vs reducing rates.
• Stretching your budget. An EMI at the limit leaves no room for emergencies.
• Forgetting that floating rates move. Keep a buffer for a rise.

Frequently asked questions

Is EMI the same for the whole loan?

On a fixed-rate loan, yes. On a floating-rate loan the EMI or the tenure can change when the rate changes.

Can I calculate EMI for a car or personal loan the same way?

Yes. The formula is the same. Try the Car Loan EMI Calculator and the Personal Loan EMI Calculator.

Does a longer tenure always cost more?

It costs more in total interest, but the EMI is lower. Choose the shortest tenure you can manage comfortably.

What is a moratorium?

A period, such as the course period for an education loan, when you may not pay EMIs but interest still builds up. See the Education Loan EMI Calculator.

Why is my first EMI mostly interest?

Interest is charged on the outstanding balance, which is highest at the start.

These examples use assumed rates and are for illustration. Your lender's terms, fees and rules will change the exact result.