How to calculate home loan EMI?

Home loan EMI calculation is based on various factors such as, Principal Loan Amount, Tenure of the loan, and Interest rate. Now, how to calculate Home Loan EMI also depends on your lender. Yes, that is right. Usually, when you apply for a home loan or just want to check EMI options for the loan amount, banks give you an option to check for an estimated value via their Home Loan EMI calculators. You can calculate monthly EMI for home loan by visiting the following links:

1. HDFC Bank

2. Axis Bank

3. ICICI Bank

4. Punjab National Bank

5. SBI

How to calculate home loan EMI formula (MS Excel)

EMI = [P x (R/100) x (1+R/100) ^n] / [(1+R/100)^ n-1]

where, P is Principal loan amount, R is Rate of interest per month, n is Number of monthly instalments.

An example to help you calculate monthly EMI for home loan is as follows:

Let us assume that P is 30 lakhs, R is 9% per annum N is 180 months

EMI = [3000000 x (0.75/100) x (1+0.75/100) ^ 180] / [(1+0.75/100) ^ 180-1)] = 30,428

Therefore, monthly EMI would be Rs. 30, 428.

Buying a property requires a lot of finances and these days to realise their dream of owning a home, people opt for home loans. Many banks are offering home loans at attractive interest rates. But the real questions are how to calculate home loan EMI and what is the home loan EMI calculation formula. I am going to answer these two questions for you here.

Before telling you about home loan EMI calculation, I would like to highlight the factors that affect calculation of EMI.

There are three major factors affecting home loan EMI calculation, these are:

1. Amount of loan

2. Tenure of loan

3. Interest rate on EMI (fixed rate or floating rate)

The home loan EMI calculation is done on the basis of following formula:

EMI = [P x (R/100) x (1+R/100) ^n] / [(1+R/100)^ n-1]

Note that 

• P is Principal loan amount

• R is Rate of interest per month

• n is Number of monthly instalments.

Let us assume that P is Rs. 40 lakhs, R is 7.2% per annum N is 180 months

EMI = [4000000 x (0.6/100) x (1+0.6/100) ^ 180] / [(1+0.6/100) ^ 180-1)] = 36402

Hence, monthly EMI would be Rs. 36402.

I hope this was helpful.

The monthly EMI that you pay must be taken into account when applying for a house loan. The type of interest rate you chose, floating or fixed, the length of your mortgage, and the principal amount; are a few factors that are required while calculating your EMI. I recently calculated the housing loan EMI, so I can help you with your question "How to calculate EMI for housing loan?"

There are several online home loan EMI calculators that are widely available. I have personally used the NoBroker EMI Calculator, which I found immensely helpful. 

Hence, you can use it as well to check home loan EMI. 

While using the NoBroker EMI calculator, you will need to add 3 things,

• the loan amount

• Rate of interest

• loan tenure

All the EMI calculators available online, including the EMI calculator NoBroker employs a special formula to calculate the EMI amount, as indicated by the answers provided above.

NoBroker EMI calculator provides a clear grasp regarding, how to calculate EMI for housing loan? This aids in determining the maximum amount of the loan that can be obtained. Hence, understanding the EMI is essential for determining your eligibility for a house loan and properly organising your home-buying process.

Read more:

Last month, my sister was

planning to buy a house. I knew she had saved enough to make the downpayment on the house but she still wanted to know

how can we calculate home loan EMI.

She decided to calculate her home loan EMI before she started house shopping. 

How Home Loan Interest Rate is Calculated?

Let me tell you the formula she used.

EMI = (P * R * (1 + R)^N) / ((1 + R)^N - 1)

Where:

• P is the principal loan amount

• R is the monthly interest rate

• N is the loan term in months

They entered the following information into the formula:

• P = Rs. 50 lakhs (principal loan amount)

• R = 8% (monthly interest rate)

• N = 240 (loan term in months)

The EMI calculator calculated her monthly EMI to be Rs. 33,333.33.

It helped her understand how much her monthly repayments would be. It also helped them to budget for her home purchase.

Now that I have told you

how to calculate EMI amount for home loan, I will also give you so

me tips for calculating home loan EMI in India:

• Make sure you have accurate information about the principal loan amount, interest rate, and loan term.

• Use an EMI calculator to make the calculation easier.

• Compare EMI quotes from different lenders to get the best deal.

Now you know

how can we calculate home loan EMI.