Search

# Find out whether you need a house or not in 60 seconds

Share

Most of my classmates and friends have started purchasing houses. This coupled with the fact that I am in coveted DINK (double income no kids) group now have prompted me to do some preliminary research on buying a house. In my quest few things became obvious,

• Any house worth its tiles costs more than a million rupees.
• For a first house 2bhk is ok, 3bhk is good.
• An apartment with 2bhk in Chennai (where we would be based for a while) costs atleast 15L (that is on the lower side, it might be upwards of 20L)
• Making a quick decision on whether or not to have your own roof is not so easy.

So I have come up with a way to decide it based on pure numbers (obviously using excel). Here it is.

At the outset the choices are whether (1) to invest in house or (2) to invest the money somewhere while paying the rents.

The cash flows associated with (1) are: EMIs, One time down payment, tax benefits on interest and principal. And at the end of the period house value if I decide to sell. I have assumed that I would sell it off.

The cash flows for (2) are: rent, tax benefits on HRA, any appreciation of money (EMIs) through investments and tax paid on the same

The variables that control the net present value (npv) of these investments are,

• monthly rent
• basic & hra (to calculate the tax benefits on hra)
• growth rates in basic sal and rent YoY
• cost of the house
• loan %age & tenure
• interest rate (assumed to fixed through out)
• house value appreciation %age YoY
• maximum allowed tax free interest & principal payments
• tax rate
• returns on your investments if you invest it elsewhere
• returns on 5 yr. bank FD.

A sample set of values are shown aside.

My guess is you need about 4 seconds for each of these 15 values. Once you know them, you can generate the cashflow for both buy and rent options. As you can see, for this set the npv of rent is higher than buy.

Some observations:
1. House value need to appreciate at really high rates for it to become attractive. Something like 12% YoY. Given the current property prices, 12-15% growth may be unreasonable over a horizon of 12-20 years.

2. On the contrary even if your investments generate a modest 11% return they could be worth so much more than the house.

3. As house cost goes up so is the attractiveness of the rent option.

My conclusion:

I have decided not to buy a house although not entirely based on this. I want to give some more time to myself and that little freedom of having a bulging savings account or whatever.

But if you want to play around and find out if the house is actually working out for you can download the excel sheet I have made. Just use the sliders to change the values, have fun. And let me know how it is. Download the house investment decision maker excel sheet

### Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

### Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

### Announcing Power BI Dashboard Contest (win \$500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to \$500 in Amazon Gift Cards, plus some serious bragging rights!

## Related Tips

Learn Excel

Learn Excel

Learn Excel

Excel Howtos

### How to fix SPILL Error in Excel Tables (3 easy solutions)

Financial Modeling

Excel Howtos

### 4 Responses to “Find out whether you need a house or not in 60 seconds”

1. [...] Buy or rent calculator in Excel - calculate returns on property investments [...]

2. Vishwanath Ramani says:

Sir,

I am really amazed with your way of teaching excel i have learn't a lot and still learning from your site. Thanks for this opportunity.

3. Pratik Karwa says:

You are posting some great stuff here..
Awesome...

4. Rajeev says:

I am not sure since I have not gone though each formula. But,
Where does it taking care of the rent saving? If we do renting then xxx cost and if we buy then yyy cost. But when we buy, we also save our monthly rent. I am not able to find that integration in NPA of Buying a house. Please explain.

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.