Step by Step Guide on How to Calculate Home Loan EMI

Those who do not have a home to call their own, dream of buying a home. Those who own a home, dream of getting a bigger one. While those who own more than one home in one city, dream of owning homes in other cities too. Then there are dreams of country houses, duplex apartments and villas, the list is endless. But for a first-time homeowner, purchasing a home is fraught with doubts and uncertainties. Home loans are the most feasible option, but not everyone knows how to calculate home loan EMI. The challenges of long-time loan burden discourage many. In today’s age, home loans are a blessing for those who are seriously planning to purchase a home. All you need is willingness, preparation for taking a loan and planning out a way with information and knowledge on managing the monthly instalments while keeping yourself safe from pitfalls. A home is a necessity and with help from home loans, as Marissa Mayer says, even if you can’t have everything you want, you can have the things that matter to you.

Home Loan EMI Calculation

Before availing of a home loan your planning should include your loan-paying capacity while balancing your finances. When you calculate in advance the monthly outgo you can plan the rest of your spending better. Do this before you approach a bank as they will only give you a loan looking at your repaying capacity and you can verify the calculation that the bank puts up. The checks for repayment are planned which helps to secure the tenure of repaying the home loan in its course.

The repayment includes the principal sum and the interest. The payment is made monthly through equated monthly instalments, (EMI).

The Equated Monthly Instalments (EMI) includes two components
Principal Loan amount: The loan amount you have applied for and is disbursed to you.

Loan Interest: The cost added for borrowing the amount that keeps adding through the repayment tenure.

The fundamental of the EMI amount is based on these factors, however, the tenure of repayment you choose determines the EMI size.

Repaying the loan in a shorter duration increases the EMI value but you can save on the interest outflow. Stretching the EMI to a longer tenure makes the EMI easier to manage, but the interest or the borrowing cost keeps adding on. So, the choice of EMI should be based on your financial standing, repayment capacity, and future goals. Fix the repayment tenure accordingly.

So how to calculate EMI for a housing loan?

There is a three-way process of home loan EMI calculation formula, that informs individuals on how to calculate home loan EMI.

There is a simple mathematical formula. You can calculate by just fixing the numbers in the formula to get the right sum.

You can also calculate by using an excel sheet.

You will find online EMI calculators that will help to calculate your EMIs.

Home loan EMI calculation formula

Let us begin with the first, mathematical formula that calculates your EMIs for you. 

Formula: EMI = P x R x [{(1 + R)^N} / {1 – (1+R)^N}]

Where,

P stands for the principal loan

R stands for your monthly interest rate [(annual rate/12)/100]

N stands for the total number of months during the loan tenure.

Check this example for a clearer understanding:

Say X took a loan of Rs 60 lakhs at an interest rate of 8.50 per cent. The loan tenure is 20 years. How to calculate home loan EMI?

R = [(annual rate /12)/100]= (8.5/12)/100= 0.70/100= 0.0070N = 240EMI = P x R x [{(1 + R)^N}/{1 – (1+R)^N}]= 60,00,000 x 0.00708333 x [{(1 + 0.00708333)^240}/{1-(1 + 0.00708333^240)}]= 50,00,000 x 0.00708333 x [{5.44123824}/{4.44123824}]= 60,00,000 x 0.00708333 x [1.22516243]EMI = Rs 52,069

How to calculate home loan EMI on an Excel sheet?

The home loan EMI calculation formula on the Excel sheet helps you to calculate the present value of payments (PMT) which is a simpler way of calculating the EMI.

The formula (r, nper, pv)

Where,

R here stands for rate of interest (8.50 per cent)
NPER stands for the number of months over which the money has to be paid. (240 months)
PV stands for the present value of the loan, meaning the principal amount (Rs 60,00,000).

The Stepwise Process:

The first key in loan amount is the interest rate and the tenure in years.
Don't forget to mention the currency and while logging the interest rate, add the percentage sign. You can also mention the term in years here.

Now key in the formula, PMT= r, nper, pv. The loan tenure needs to be keyed in every month

=PMT(8.5%/12,240,6000000)

After pressing Enter you get the payable EMI value

How to calculate EMI for housing loans using the online EMI calculator?

Online EMI calculators are readily available by banks and financial institutes. Enabling easy user-friendly calculations, you just key in the loan amount, interest rate and loan tenure. The tool helps you get a precise breakup of the loan.

Benefits of calculating home loan EMI

Once you get a complete calculation of the home loan EMI, it helps you to get a view of what you are embarking on. The figures help in calculating making additions or subtractions to the principal sum based on your capacity for repayment. So, what are the Benefits of calculating home loan EMI in short?

• You can choose a home loan amount according to your comfort
• The amount that helps you manage your EMIs better
• The amount that doesn't strain your financial balance

Conclusion

Whatever may be your EMIs, this is one task that all home loan seekers should follow. Once you know the monthly expenses you are looking at, your EMIs will not press on your regular financial plans. So even before you apply for a home loan with a bank or any financial institution, you have a clear and calculated sheet that gives you an insight into what your loan repayment entails. Once you learn how to calculate EMI for a housing loan, you can compare the best deal and start paying it off at your convenience.