Commercial Real Estate Financial Model

Description
The purpose of this spreadsheet model is twofold:

1) to estimate the valuation of commercial property and

2) to determine the financial feasibility of an investment in the subject property for a 10 year holding period.

The uncertainty in this model lies in the many economic factors to be input as assumptions by the user.

The most important assumptions in this analysis are the Net Operating Income assumptions (Annual Gross Rent, Vacancy and Collection Loss Factor, and Operating Expenses) and the Cap Rate at Purchase. Special attention should be given to these assumptions.

INSTRUCTIONS:

1.) Conduct comparables analysis of similar properties to estimate the cap rate at purchase.
2.) Define all assumption distributions to reflect current and local market conditions.
3.) Run simulation.
4.) Analyze results.

- Questor Consulting LLC - Will Ferrigno - Better Analysis. Better Decisions.