Spend, Save and Invest Smartly

What is an EMI and how does one calculate it?

A Story About 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.

While 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

If you miss your 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


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

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.

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

Year Interest/month Principal/month EMI
1 8333 5229 13562
2 7810 5752 13562
3 7235 6327 13562
4 6603 6959 13562
5 5907 7655 13562
6 5141 8421 13562
7 4299 9263 13562
8 3373 10189 13562
9 2354 11208 13562
10 1233 12329 13562

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). For more queries on the topic please feel free to contact Moneymindz.com

Commercial Vehicle Loan