Commercial Real Estate Financial Model
  • Commercial Real Estate Financial Model
  • Commercial Real Estate Financial Model
  • Commercial Real Estate Financial Model
Originally published: 25/11/2016 10:59
Publication number: ELQ-56438-1
View all versions & Certificate
certified

Commercial Real Estate Financial Model

Compute a Commercial Real Estate Valuation and Financial Feasibility of your Investment Project - excel model

assumptionsfinanceinvestmentproject financeproperty valuationreal estate

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.

This business tool includes
1 Excel Model

Will Ferrigno offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Commercial Real Estate Financial Model

The user community and author are here to help. Go ahead!

  • Yann Iffer
    Interesting model! I would just avoid the division per 100 and multiplication per 100 in the Property Valuation formula (C24)
    arrow_drop_uparrow_drop_downReply reply
    please wait...