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 Best Practice includes
1 Excel Model
Will Ferrigno offers you this Best Practice for free!
download for free
Add to bookmarks
4.7 / 5 (93 votes)
- Rate this Downloadable Best Practice
Write a review
- Lou Lipschultz(last updated: 17/11/2020 03:35)
- Adib Basbous(last updated: 10/09/2020 07:55)
- Tung Phan(last updated: 26/08/2020 04:16)
- Nunez(last updated: 27/07/2020 09:58)
- Javed Siraj(last updated: 22/07/2020 08:15)
- Michael B. Fozouni(last updated: 27/06/2020 04:40)
- Abdulaziz Aldawi(last updated: 05/05/2020 09:03)
- George Frank(last updated: 02/05/2020 21:11)
- WalidD(last updated: 31/03/2020 09:48)
- Carmen Salcedo Rivas(last updated: 01/03/2020 16:03)
- Hanz Hargianto(last updated: 23/12/2019 00:33)
- Stylianos-Georgios Tsoukalas(last updated: 27/10/2019 07:41)
- Vivek Kulshestha(last updated: 06/10/2019 19:04)
- Charles.HA. Chen(last updated: 26/09/2019 10:16)
- Vladimir Petropoljac(last updated: 23/08/2019 08:52)
- Nathan Herber(last updated: 01/08/2019 14:02)
- Ingvar Sporsem(last updated: 23/07/2019 14:25)
- Elio Rodrigues(last updated: 18/07/2019 16:56)
- Anh Vo(last updated: 17/07/2019 09:33)
- 长霖 李(last updated: 15/07/2019 07:39)
- Nikhil Ganotra(last updated: 07/07/2019 12:04)
- Paul Devlin(last updated: 26/06/2019 14:59)
- Ormondi Seda(last updated: 22/06/2019 22:36)
- Ravi Sharma(last updated: 17/06/2019 11:25)
- Alia Kasey(last updated: 15/06/2019 06:53)
- Chris Gee(last updated: 03/06/2019 16:33)
- Divesh Prahladka(last updated: 29/05/2019 10:26)
- ABDULAZIZ(last updated: 15/05/2019 16:50)
- Sihle Sibeko(last updated: 14/05/2019 19:03)
- Choi Tony(last updated: 13/05/2019 02:41)
People using this Best Practice also downloaded
Band Mortgage Equity Capitalization or Atkerson format EllwoodIncorporate and understand a financing's impact on value and compute the cap rate.financereal estatemortgageassumptionsellwood661add_shopping_cartfreeby Norm Miller PhD
Real Estate - Hotel/Resort Development Excel Model TemplateComplete financial model for financing, building, operating, refinancing, and selling hotel/resort property types.investmentfinancereal estatepropertyprivate equity3,252add_shopping_cart$40.00by Spencer Dobson
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorproperty10,565add_shopping_cartfreeby Amit Tandon
Real Estate - Property Acquisition Excel Model TemplateComplete financial model for purchasing, holding, and selling all investment property types.investmentfinancereal estatepropertyprivate equity1,573add_shopping_cart$25.00by Spencer Dobson
Venture Capital Method (Single Round Financing)A full model enabling an entrepreneur to understand assumptions of both sides of the table in a single round financinginvestmentfinancevaluationfinancingventure capital15,257add_shopping_cartfreeby Richard L. Smith
Real Estate Excel Financial Model TemplateA detailed Real Estate Financial Model brought to you by CFI to help you successfully model your development project.investmentprojectreal estatemodelingfinancial model1,978add_shopping_cart$100.00by CFI
Estimating the Discount for a Minority Stake in a Private BusinessThis model can be used to estimate the discounts for a minority stake in a private businessinvestmentfinancediscountmanagementprivate business228add_shopping_cartfreeby Aswath Damodaran
2016 Round 2, Section 2: Fund the FutureExcel training/competition model from the 2016 Financial Modeling World Championshipsinvestmentfinancemodelingforecastreturn129add_shopping_cartfreeby ModelOff
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.investmentfinanceequitydebtleverage169
Discussion feed for Commercial Real Estate Financial Model
The user community and author are here to help. Go ahead!
- Interesting model! I would just avoid the division per 100 and multiplication per 100 in the Property Valuation formula (C24)
- I dont see the download link
- Hi Frankir,
To download the file, simply go to: https://www.eloquens.com/account/products 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.
The Eloquens Team
- Nice model