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 (95 votes)
- Rate this Downloadable Best Practice
Write a review
- Wayne Greenhalgh(last updated: 25/07/2021 08:55)
- Etta Thorpe(last updated: 05/02/2021 12:32)
- 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)
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 estatemortgageassumptionsellwood734add_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 equity4,256add_shopping_cart$40.00by DW Financial Services
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorproperty10,951add_shopping_cartfreeby Amit Tandon
Real Estate - Property Acquisition Excel Model TemplateComplete financial model for purchasing, holding, and selling all investment property types.investmentfinancereal estatepropertyprivate equity2,006add_shopping_cart$25.00by DW Financial Services
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.investmentfinanceequitydebtleverage221
2016 Round 2, Section 2: Fund the FutureExcel training/competition model from the 2016 Financial Modeling World Championshipsinvestmentfinancemodelingforecastreturn212add_shopping_cart
Bajaj Auto Fundamental Analysis and Financial RatiosFundamental Analysis in Microsoft Excel of Bajaj Auto Shares.investmentfinanceequityinvestingfinancial ratios135add_shopping_cart$3.50by Valuation
Hotel Development Financial Model (Construction, Operation & Valuation)Financial model presenting a Hotel's construction, operation and valuation phases.developmentcash flowreal estatefinancial modelproperty valuation29add_shopping_cart$109.00by GL Consulting
Real Estate Financial Model (Very Detailed)Real Estate Financial Model for real estate investment professionals in fields like RE Private Equity, RE Valuation, etcfinancevaluationreal estateprivate equityfinancial modelling131add_shopping_cart$50.00by Anuj Verma
Discussion feed for Commercial Real Estate Financial Model
The user community and author are here to help. Go ahead!
- I did a model for $2mm deal with $600K down and 10 year hold. My Pro - Forma Cash flow stmt show's the Debt Service for the 1st year as a Debit and as a credit for the other years? Is this intended? Thanks!
- 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