How to calculate Home Loan EMI and Outstanding Balance

Today every other person dreams about having home of his own, but the way real estate prices piercing through sky and common mans pocket its highly impossible to fulfill this dream without support of Loan. Home Loan, which is available easily and simply a phone call away. You simply need to fill in few forms, provides some proof and your are ready to get your home loan. Banks even have different schemes of tailored loans to suit the need of its customer. But the person who avails the loan, he knows, getting loan is easy but keep on paying the EMI is tough and inevitable task. Through this article I would like to introduce 2 of small utilities related to home loan that I think can be useful to all home loan customers. Every customer wants to know what EMI he will be paying to for particular amount of loan for given period and interest rates. Also he will be interested in outstanding balance or you can say principal amount remaining after paying up few installments. These utilities will help you to know the exactly same.

  1. How To Calculate Home Loan EMI
  2. How To Calculate Home Loan Outstanding Balance

In these utilities I have simply used the formula that is readily available on net to calculate EMI and reversed it to get outstanding balance. The formula is EMI_CALC Where, E = EMI P = Principal Amount r = Monthly Interest rate (if 10.5 % is annual rate then monthly rate = 10.5/12/100 ) n = No of terms loan opted for. Now while calculating outstanding balance, I need to calculate P on the basis of E, r and n which is remaining term in this case, that means if you have opted for 10 years (120 months) loan and paid 20 EMI then n would be 100. Go on and give this tools a try, If you think they are not correct, please send me your comments and I will do my best to correct it.

2 Comments
  1. Mahendra
    April 20, 2013 | Reply
    • Pavan
      April 23, 2013 | Reply

Leave a Reply to Pavan Cancel reply

Your email address will not be published. Required fields are marked *