Search in Indianmoney's WealthPedia

Home Articles What is an EMI? How to Calculate EMI?

What is an EMI? How to Calculate EMI? Research Team | Posted On Thursday, September 10,2009, 07:17 PM

5.0 / 5 based on 1 User Reviews

What is an EMI? How to Calculate EMI?



EMI - Equated Monthly Installment

In this article we have briefly explained the concept of EMI (Equated Monthly Installment). Most of the people don’t know what is EMI and how does it works. Normally people use to choose EMI Without analysing the real financial condition. From outside EMI looks very attractive but there are many things that you have to really understand. This article comprises all such information about EMI.

EMI stands for Equated Monthly Installment. This is the fixed amount of amount paid by the borrower on each month. This will help you to pay off your debt on an installment basis. Initially, a major part of the EMI goes in paying the interest. As the tenure increases the principal component of the loan increases. In other words, EMI is a fixed amount paid by a borrower to a lender at a specified date in each month. Equated monthly installments are used to pay off both interest and principal each month, so that over a specific number of years, the loan is paid off in full. If you are taking a mortgage loan and repaying it by EMI, you have to pay a fixed amount of money every month. The difference between EMI and other variable payment plan is that your installment amount is fixed in EMI.

Interests are generally calculated on a month or sometimes every three months period. The calculated interest on the principal amount (loan amount) is added with the principal itself and then the repayment amount (EMI) is deducted from this sum to arrive at a balance amount. At the next step, the interest is calculated on the last balance amount and the new reducing balance amount is obtained in the same way. This process is continued iteratively until the balance amount reduces to zero. And then the loan is fully repaid.

Balance amount = Previous balance amount + Interest on the balance amount – Repayment amount.

Are you Applying for a Home Loan? You Have to Answer the Following Questions

  • How much loan you want
  • What is the value of the property
  • What is the term you are looking for
  • What’s your gross salary & Net salary

Home Loan EMI

There are many reasons that cause us to fall behind loan repayments. Loss of job, medical expenses, etc can happen to anyone, this will make us to delay the repayment of loans. If you neglect payments of home loan EMI, it will hurt your credit rating and many other severe implications could follow. In case you default on your home loan repayments the lenders undertake some measures to recover the amount :

  • Lenders follow up by sending the collection agents to recover the due amount.
  • Then the lenders follow up with the person who co-signed the loan documents.
  • As a consequence of default in payment the borrower might lose possession of the house.

According to the Securitisation Act, housing companies have the right to take over the house property of the defaulting customer. They can classify the asset secured or mortgaged as a non-performing asset and give a 60 day’s notice to the borrower. If the borrower fails to clear off his liability within this period, the lending institution has four options such as;

  • Take possession of the asset
  • Take over the management of the asset of the borrower
  • Appoint any manager to manage the asset

See Also: Tips For Home Loan EMI Repayment


If you are planning to seek a remedy after defaulting on your EMI, you have to file an appeal to the Debt Recovery Tribunal (DRT) within 45 days. If the order of Debt Recovery Tribunal is against you, then an appeal has to be filed before the Appellate Tribunal within 30 days of receiving it. If the Appellate Tribunal is finding that the possession of the asset taken by the lender was wrongful, the Tribunal may direct them to return it back to the borrower, along with adequate compensation.

Other Options for Redressal

It is not necessary that you have to do a legal battle with your lender, unless the lender initiates legal proceedings against you. Contact him as soon as you know your payments will be overdue. Never ignore the lender’s letters and do not imagine you are in a hopeless situation. Following are some of the steps, which you can take to keep property’s possession with you.

  • Talk to the lender
  • Refinance your debt
  • Balloon repayment scheme
  • Lower your EMI by changing the payment plan

See Also: Home Loan Interest Rates

Talk to the Lender

Financiers make money by collecting your principal and interest payments, not by foreclosing on homes. Foreclosing is the process by which mortgaged property enters into the possession of the mortgagee without right of redemption by the mortgagor. If you present your situation to them along with a reasonable plan for temporary relief, they may suggest some plan to help you.

Refinance Your Debt

There is a possibility that you might build your home when interest rates were high and, therefore, your EMI is high. You can solve this problem by refinancing your debt at a lower interest rate.

Balloon Repayment Scheme

You also have the option to pay lower EMI in the initial years and a bulk payment in the last installment so that the major burden can be shifted to the later years.

Lower Your EMI by Changing the Payment Plan

If you are not able to pay the existing EMI, by increasing your repayment period you can considerably reduce your monthly installment. If you have taken the loan for 15 years then you can extend it to 20 years. But always remember even though your monthly payment may decrease, you will end up in paying more by way of interest since it will take longer time to pay off the loan.

See also: No Cost EMI

How to Calculate EMI?

Below given is the equation to calculate EMI.

EMI = [(P x r) (1+r) n]/ [(1+ r) n-1]


P = Principal Loan Amount
r = Annual Interest Rate / 12
n = Number of Monthly Installments


The below given illustration will help you in understanding how EMI works. Imagine you are taking a home loan of Rs. 10,00,000 with an interest rate of 10% for a period of 10 years. In this case your EMI will be around Rs. 13,562. Your EMI constitute a certain amount of Principle and Interest. But the amount of interest and principal will change as the time goes.


Loan Amount – 10,00,000
Interest rate – 10%
Tenure - 10 years

EMI – 13562

This table illustrates the amount of interest and principal included in EMI













































A combination of interest and Principal makes EMI but. Over a period of 10 years you will pay an amount of Rs.1627440 to the lender. Rs. 1000000 as principal and remaining Rs. 627440 as interest.

Total Interest Amount – 6,27,440
Total Principal Amount – 1000000
Total Paid Amount - 1627440

How to Calculate EMI in MS Excel?

Microsoft excel has an excellent option to calculate EMI. Below given Steps will help you to calculate the EMI for a fixed rate and term.

Step 1

Open Microsoft Excel.

Step 2

Select 'Insert' and then 'function' in MS Office 2007 we have option called Formulas, select that.

Step 3

Select category as 'financial' and look for PMT in the options displayed.

Step 4

Select PMT. This will open a function argument dialogue box.

Step 5

Enter the rate of Interest against the Rate column (if you are paying monthly installments do not forget to put the % sign after the rate and then /12)

Step 6

In the Nper column insert the number of monthly payments.

Step 7

In the Pv column enter the total amount of loan.

Step 8

Click on Ok and you have your EMI in the excel sheet.

How to Calculate the Rate of Interest for a Given EMI in Excel?

Step 1

Open the excel sheet

Step 2

Select 'insert' followed by 'function'

Step 3

Select Rate, this will open a function arguments box will open.

Step 4

Against Nper, put the total no of installments

Step 5

Against Pmt enter the given EMI. (Put a minus (-) sign before the amount)

Step 6

Against Pv enter the Loan amount

We believe that this article has hepled you in imparting sufficient knowledge about EMI (Equated Monthly Instalments).

Keep your Financial Cognizance up to date with IndianMoney App. Download NOW for simple tips & solutions for your financial wellbeing.

Have a complaint against any company?'s complaint portal can help you resolve the issue. Just visit and lodge your complaint. If you want to post a review on any company you can post it on review and complaint portal

Be Wise, Get Rich.

What is your Credit Score? Get FREE Credit Score in 1 Minute!

Get Start Now!
Get It now!

This is to inform that Suvision Holdings Pvt Ltd ("") do not charge any fees/security deposit/advances towards outsourcing any of its activities. All stake holders are cautioned against any such fraud.