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, December 6, 2011

Real Estate Project Analyzer

The real estate analyzer is a simple program that will help a real estate investor determine the worth and feasibility of possible investments. This is a spreadsheet that will have to be done in steps, however, due to scope limitations.

This first phase of the project helps an investor create pro forma operating statements and to check up-to-date market data for current interest rates. This is the last step an investor will need to do an evaluation, to see if after valuation and financing is lined up, if the investment will actually have positive cash flows in the first few years. Once initially calculated, an investor can check the sensitive of their results by creating a new spreadsheet with slightly different inputs.

In the future, the program will also help an investor through valuation, financing and tax decisions, simple risk analysis, and the rent vs buy option.

Link to Write-up

Link to Real Estate Project Analyzer

No comments:

Post a Comment

Blog Archive