real estate | Excel & VBA

Case Shiller Home Price Index and the Base Effect

The Case Shiller Home Price Indices are constant quality house price indices for the United States. A number of Case Shiller home price indices exist: A national home price index, a 20-city composite index, a 10-city composite index, and twenty individual metro area indices. These indices were developed by economists Karl Case and Robert Shiller. (wiki) The Case Shiller Index has been one of the most keenly watched indices over the past few months. It ...

Retirement Planner in Excel

Posted on 04 June 2009

Retirement planner in Excel will help you calculate your savings at the time of retirement. The Excel retirement planner takes in to consideration your monthly income, expenses, asset purchase over time, saving allocations and expectations of interest rates and asset appreciation to calculate the growth of your savings over a given period. You can download the retirement planner in excel here. All of us worry about the impeding retirement. How ...

Comments

Factors Affecting Real Estate Growth

Posted on 04 October 2008

Real Estate can and does appreciate. And prices can drift downwards too. I would classify the factors that decide on these movements as being: 1) Local (Distance from central business district, prevailing living conditions in that area including offices, shopping malls, parks, entertainment centers, distance from major arterial roads, distance from landmarks such as airports, town halls etc.) 2) Regional or National (Growth rate of a country, Rate of unemployment, Rise in income levels, Rise in populations segment that can afford housing, ...

Comments (2)

Own, Let-out or Rent – Making of a house

Posted on 21 September 2008

One question that comes to everybody's mind when thinking of investing in a house is whether the investment will be worth it. Over the weekend I worked out a basic model that attempts to work out the financials in three different scenarios - buying a house and occupying it, buying and letting out and thirdly, not buying a house at all. Expectedly, we can see, that buying a house may turn ...

Comments (2)

NY Times – Home Foreclosure Graph

Posted on 07 September 2008

This appeared some time back in April-2008. What is interesting to note is that not only this chart is visually appealing but it does pack a lot of data. The color of the stacks shows the % of subprime mortgaes as a % of all mortgages in an area while the height of a stack shows subprimes mortgages foreclosed as a % of all subprime mortgages in that area. If ...

Comments (1)