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

Commercial Real Estate Financial Model

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

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.


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




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
    • frankiir
      I dont see the download link
      arrow_drop_uparrow_drop_downReply reply
      • Eloquens Team
        Hi Frankir,

        To download the file, simply go to: and then click on the title of the tool. You will then have a page from which you can click on a blue button to download the excel model.

        Let us know if you have further questions.

        Best regards,
        The Eloquens Team
        arrow_drop_uparrow_drop_downReply reply
      please wait...