VBA for Real Estate Analysis

VBA for Real Estate Analysis
Wilford Wong


I. Executive Summary
As a real estate acquisition analyst, my duty is to analyze multi-family properties that are currently on the market. On average, I spend 4-5 hours to analyze each property in excel. I can use VBA to automate part of that process. It will not only help me save time, but also help me concentrate on analyzing the parts that re-quire more intellectual focus. The first process that can be automated is retrieving data from the Internet. Using a few websites as the data sources, the macro can insert those demographics and economics data from those web-sites by searching with the subject and comparable property ad-dresses. The second process that can be automated is to insert photos of the subject and comparable properties into the Excel. The third process that can be automated is to perform a rent anal-ysis base on the rent roll. The macro will populate a few graphs to look at rent trend and seasonality.

Here is the list of my files:
http://files.gove.net/shares/files/15f/hilsyn/Real_Estate.pdf
http://files.gove.net/shares/files/15f/hilsyn/Real_Estate.xlsm