These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 10, 2015

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

No comments:

Post a Comment

Blog Archive