EMI Calculation: Formula, Examples and How EMI Is Calculated

Before you take a home loan, car loan or personal loan, there is one number that matters more than any other: your EMI, the amount that will leave your bank account every month for years. Knowing how EMI is calculated helps you check what a bank tells you, compare offers and avoid loans that look cheap but are not.

This guide explains the EMI calculation formula in simple steps, with worked examples you can repeat on your phone calculator or in Excel. When you finish, test yourself with our free loans and EMI quiz.

What is EMI?

EMI stands for Equated Monthly Instalment. It is the same amount that goes out every month until the loan is cleared. Every instalment is made of two parts:

• Interest on the amount you still owe, and
• Principal, which reduces the loan itself.

The EMI stays the same each month (for a fixed rate), but the mix inside it changes. At the start most of it is interest; towards the end most of it is principal.

The EMI calculation formula

Banks and lenders in India use the reducing balance method. The EMI calculation formula is:

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

Where:

Symbol	Meaning	Example
P	Principal: the loan amount	₹5,00,000
r	Monthly interest rate = yearly rate ÷ 12 ÷ 100	10.5% ÷ 12 ÷ 100 = 0.00875
n	Tenure in months	5 years = 60 months

The most common mistake is using the yearly rate directly. Always convert it to a monthly rate first.

How to calculate EMI: a worked example

Let us calculate the EMI on a ₹5 lakh personal loan at 10.5% a year for 5 years.

1. Monthly rate: r = 10.5 ÷ 12 ÷ 100 = 0.00875
2. Months: n = 5 × 12 = 60
3. (1 + r)^n: 1.00875 raised to the power 60 = 1.6866 (use the x^y key on a scientific calculator)
4. Top part: P × r × 1.6866 = 5,00,000 × 0.00875 × 1.6866 = 7,378.9
5. Bottom part: 1.6866 − 1 = 0.6866
6. EMI: 7,378.9 ÷ 0.6866 = about ₹10,747

Now the totals:

• Total you repay: ₹10,747 × 60 = about ₹6,44,817
• Total interest: ₹6,44,817 − ₹5,00,000 = about ₹1,44,817

So this loan costs you nearly ₹1.45 lakh on top of what you borrowed.

How EMI is calculated month by month

Here is how the first few EMIs of the same ₹5 lakh loan are split. Interest each month is the balance × 0.00875.

Month	EMI	Interest part	Principal part	Loan left
1	₹10,747	₹4,375	₹6,372	₹4,93,628
2	₹10,747	₹4,319	₹6,428	₹4,87,200
3	₹10,747	₹4,263	₹6,484	₹4,80,716
30	₹10,747	₹2,544	₹8,203	₹2,82,485
60	₹10,747	₹93	₹10,654	₹0

This table is called an amortisation schedule. Ask your lender for it. It shows exactly how much interest you pay and how fast the loan falls.

The effect is much stronger on long loans. On a ₹30 lakh home loan at 8.5% for 20 years, the EMI is about ₹26,035. In the first month, about ₹21,250 (82%) is interest and only about ₹4,785 reduces the loan. Over 20 years you would pay about ₹32.5 lakh in interest, more than the loan itself.

EMI calculation in Excel or Google Sheets

You do not need to do this by hand every time. In Excel or Google Sheets, type:

=PMT(10.5%/12, 60, -500000)

This returns 10,746.95, the same EMI as our manual calculation. The three parts are the monthly rate, the number of months, and the loan amount with a minus sign (so the answer shows as a positive payment).

To build your own schedule, put the balance in one column, interest (balance × monthly rate) in the next, principal (EMI − interest) in the next, and subtract principal from the balance each row.

How tenure and interest rate change your EMI

The same ₹5 lakh loan at 10.5% over different tenures:

Tenure	EMI	Total interest
3 years	₹16,251	₹85,044
5 years	₹10,747	₹1,44,817
7 years	₹8,430	₹2,08,148

A longer tenure lowers the EMI but raises the total interest. Choose the shortest tenure whose EMI you can comfortably pay.

The same ₹5 lakh loan for 5 years at different rates:

Interest rate	EMI	Total interest
10%	₹10,624	₹1,37,411
12%	₹11,122	₹1,67,333
14%	₹11,634	₹1,98,048
16%	₹12,159	₹2,29,542

A few percentage points add up to tens of thousands of rupees. A good credit score is one of the best ways to get a lower rate.

EMI calculation for home, car and personal loans

The EMI calculation works the same way for every loan type. Only the typical rate and tenure differ:

Loan type	Typical tenure	What to watch
Home loan	15 to 30 years	Floating rate linked to the repo rate; small rate changes move the total a lot
Car loan	3 to 7 years	Often a fixed rate; check whether the rate is flat or reducing
Personal loan	1 to 5 years	Higher rates and processing fees; compare the APR
Consumer or phone EMI	3 to 24 months	“No-cost” offers, GST on interest and lost cash discounts

Whatever the loan, do your own EMI calculation before you sign, and match it with the lender’s figure. If the two differ, ask the lender to explain why.

Flat rate vs reducing balance rate

Some lenders, especially for consumer goods, two-wheelers and some personal loans, quote a flat interest rate. A flat rate charges interest on the full original loan for the whole tenure, even as you repay it.

Example: ₹1 lakh for 2 years.

	10% flat rate	10% reducing rate
Interest	₹20,000 (1,00,000 × 10% × 2)	about ₹10,748
EMI	₹5,000	about ₹4,614
Real yearly cost	about 18.2% on a reducing basis	10%

So “10% flat” really costs about the same as 18% on a reducing balance. Always ask: “Is this a flat rate or a reducing balance rate?” Under RBI rules, lenders must give you a Key Facts Statement (KFS) before you sign for retail loans. It shows the Annual Percentage Rate (APR), the all-in yearly cost including fees, which makes offers easy to compare.

Is no-cost EMI really free?

“No-cost EMI” on phones and appliances usually works like this: the bank still charges interest, and the seller or brand gives you a discount equal to that interest, so the total you pay equals the price.

On a ₹30,000 phone over 6 months at 15%, the interest would be about ₹1,326. In a no-cost offer, roughly that amount is knocked off the price upfront. But check the small print:

• GST on the interest part is often still charged by the bank.
• There may be a processing fee.
• You lose any cash discount available to people who pay in full.

No-cost EMI can be useful, but it is rarely exactly zero cost.

How prepayment reduces your total interest

Paying a lump sum early cuts the principal, so every later month charges less interest.

On the ₹30 lakh home loan at 8.5% for 20 years, a one-time prepayment of ₹1 lakh after the first year, keeping the same EMI, would:

• finish the loan about 18 months earlier, and
• save about ₹3.7 lakh in interest.

Under RBI rules, banks and NBFCs cannot charge prepayment or foreclosure penalties on floating-rate term loans taken by individuals for non-business purposes. Fixed-rate and business loans may carry charges, so check your loan agreement.

What happens to EMI when interest rates change?

Most home loans have a floating rate linked to an external benchmark such as the RBI repo rate. When rates rise, the lender can either raise your EMI or extend your tenure.

On the ₹30 lakh, 20-year loan, a rise from 8.5% to 9%:

• EMI goes up from about ₹26,035 to about ₹26,992, or
• tenure stretches from 240 months to about 268 months if the EMI stays the same.

RBI guidelines require lenders to tell you clearly when the rate is reset and to let you choose between a higher EMI, a longer tenure or a mix, and to offer an option to switch to a fixed rate as per their board-approved policy.

How much EMI can you afford?

A common guideline is to keep all your EMIs together under about 40% of your monthly take-home pay. Many lenders look at a similar figure, called FOIR (fixed obligations to income ratio), before approving a loan.

For example, with a take-home salary of ₹50,000, total EMIs should ideally stay under about ₹20,000. Remember to leave room for an emergency fund, insurance and savings too.

Tips to lower your EMI and total interest

• Improve your credit score before applying to get a better rate.
• Compare the APR in the Key Facts Statement, not just the headline rate.
• Make a bigger down payment so you borrow less.
• Choose the shortest tenure you can afford; it saves the most interest.
• Prepay whenever you get a bonus, especially in the early years.
• Avoid flat-rate offers unless you have converted them to a reducing rate.
• Never miss an EMI. Late payments add penalties and hurt your credit score.

Frequently asked questions

How do I calculate EMI quickly?

Use the formula EMI = P × r × (1 + r)^n ÷ [(1 + r)^n − 1], or type =PMT(yearly rate/12, months, −loan) in Excel or Google Sheets. Both give the same answer.

What is the EMI on a ₹5 lakh loan for 5 years?

At 10.5% a year, the EMI is about ₹10,747, and the total interest is about ₹1.45 lakh. At 12%, the EMI is about ₹11,122.

Why is most of my early EMI going to interest?

Interest is charged on the outstanding balance, which is highest at the start. As you repay, the interest part falls and the principal part grows.

Is a longer tenure better?

It gives a lower EMI but costs more interest overall. Pick the shortest tenure whose EMI fits comfortably in your budget.

Is EMI calculated on a flat rate or reducing balance?

Most bank loans in India use the reducing balance method. Some consumer and personal loans quote a flat rate, which is much more expensive than it looks. Check the APR in the Key Facts Statement.

Can I reduce my EMI after taking a loan?

Yes. You can prepay part of the loan and ask the lender to reduce the EMI, or move the loan to a lender with a lower rate (a balance transfer), after comparing the fees.

The bottom line

Your EMI depends on three things: how much you borrow, the interest rate and the tenure. Use the formula or Excel’s PMT to check every offer, compare loans by APR, beware of flat rates, and prepay when you can. A little maths before you sign can save you lakhs over the life of a loan.

Test yourself with our loans and EMI quiz, try the budgeting and saving quiz, or read our guide to SIP investment.