Residential Investment Search

Executive Summary

Owning one’s home has always been a part of the American Dream. With the recent recession, that part of the American Dream has been halted for many. Families and individuals are flocking to good rentals in good neighborhoods and rents are rising. Rental properties have become a great source of primary and secondary income for many investors. The problem is finding the right property.

Energy and time are wasted to a large extent on properties that don’t fit into your financial model. This Excel VBA Program is built to address this need. An investor can use this program to quickly investigate current homes on the market. Then he/she can plug the information quickly into the financial analysis spreadsheet and see if it really is worth spending some more time looking at that home. It does not definitively suggest that a particular home ought to be purchased as an investment, but it will help guide energy and time.

This program pulls data from a popular real estate website to easily sort and investigate current listings. It also pulls data on local rental properties as comparisons as the rental income is a key factor in the investment decision. This data can be searched and sorted easily. Once you have zeroed in on a property and thought through other key factors, you can easily plug those into the financial analysis and see the resulting IRR and NPV.

• http://files.gove.net/shares/files/12f/msw6/ResInvestSearch_Writeup_Matt_Wheelwright.pdf
• http://files.gove.net/shares/files/12f/msw6/Residential_Investment_Search2.xlsm