July 08, 2019

Excel - Home Loan Calculator (EMI)

One of the major financial decision which is made by most individual at some point of time is that of buying house. Typically saying goes, you should have zero debt except it is for house. Which is quite true, as that is one asset which is difficult to buy cash down (for most of the people).

With current Budget 2019 announcement of additional Rs 1.5 lakh interest eligible for deduction, I find many of my friend actually struggling to calculate, what will be the actual interest component for the different years. So here’s quick worksheet that will help you to find out your monthly installment amount and your annual and total interest/principal outflow.

Note:
  • To use this worksheet, you will need to update cells highlighted in yellow
  • Worksheet is built basis Excel’s inbuilt function of PMT
  • Calculation assumes interest for full month – so if installment date is different – amount might be slightly different
  • Currently, I have kept provision for 30 years

Lastly, worksheet is not password protected, so feel free to edit and make it suitable for your need.

Download from Google Drive


If you are non-finance guy and need some specific help, feel free to drop in your queries.

No comments:

Post a Comment