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

Tuesday, April 12, 2016

Lance Kohler: Foreclosure Analysis Tool

Executive Summary


The business for which I created my VBA tool (Auction Information Tool) is a real estate business which attempts to buy foreclosed properties at Utah auctions.  There are 4 or 5 law firms which specialize in these foreclosure auctions.  Each law firm posts information on a separate site. Information is updated daily so it is important to go through the sites daily if you do not want to miss potential deals.  Usually it takes about 30 to 45 minutes to comb through the sites to get a good sense of what is going on in the market. This tool pulls the data from the sites into one excel document, saving considerable time.  The tool also allows you to quickly search on Zillow for a “Market Estimate” of the house so that you can get a sense of how good of a deal the property might be. From there the analyst must do additional research. 

No comments:

Post a Comment

Blog Archive