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
- Sri Challapalli(last updated: 13/01/2019 16:13)
- Michael (Mickey) Noone(last updated: 05/01/2019 17:19)
- Joseph Gasper(last updated: 04/01/2019 00:23)
- Pimchanok Chanpeng(last updated: 27/11/2018 16:41)
- P Dimas(last updated: 16/11/2018 10:27)
- Velenjani Lupankwa(last updated: 13/11/2018 07:43)
- Kraig Wall(last updated: 05/11/2018 18:08)
- Heba Elsayed(last updated: 05/11/2018 12:12)
- Cason Chatham(last updated: 05/11/2018 03:07)
- Mohammed Santina(last updated: 03/11/2018 20:58)
- FREDRICK KIPCHUMBA739(last updated: 31/10/2018 09:03)
- Murph Ada(last updated: 29/10/2018 22:41)
- Bruce zhang(last updated: 25/10/2018 09:25)
- Shamsu Hamid(last updated: 25/10/2018 07:45)
- Abdul Ghafur BE, MCIOB, AClArb, CQS,610(last updated: 22/10/2018 08:57)
- Mostafa Ramdan(last updated: 18/10/2018 11:31)
- Waleed El-Shennawy(last updated: 15/10/2018 10:22)
- kevin frank(last updated: 28/09/2018 21:59)
- Ramzi Qasmieh(last updated: 27/09/2018 08:43)
- Robert Lee Phillips(last updated: 09/09/2018 16:57)
- GAURASHI SAWANT(last updated: 08/09/2018 13:07)
- Peter Cranes(last updated: 07/09/2018 16:45)
- Sam Schnitzler(last updated: 30/08/2018 03:35)
- Nirvana Martin(last updated: 28/08/2018 21:11)
- ayman saleh(last updated: 25/08/2018 13:49)
- Lola MRICS(last updated: 17/08/2018 13:00)
- RAJU G V V S(last updated: 08/08/2018 15:49)
- Jeremy Moore(last updated: 31/07/2018 00:43)
- frankiir(last updated: 30/07/2018 03:54)
- Brawin Andrew(last updated: 28/07/2018 12:53)
People using this tool also downloaded
Band Mortgage Equity Capitalization or Atkerson format EllwoodIncorporate and understand a financing's impact on value and compute the cap rate.financereal estatemortgageassumptionsellwoodcapitalizationcap ratenoiatkerson403 remove_red_eye
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 capitalassumptionsentrepreneursingle roundunstaged investmentstaged investment9,313 remove_red_eye
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorpropertysensitivity analysisrental property5,939 remove_red_eyefreeby Amit Tandon
Real Estate - Property Acquisition ModelComplete financial model for purchasing, holding, and selling all investment property types.investmentfinancereal estatepropertyprivate equityinvestingfinancial modelinglbobuildingproformaNew!
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotelappraisal168 remove_red_eye$89.00by Mahender K. Punhani
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.investmentfinanceequitydebtleveragefinancial managementleverage analysisborrowed money48 remove_red_eye
Valuation Partial Commitment of the EntrepreneurLearn how to value an entrepreneur's partial commitment to a ventureinvestmentventurefinancevaluationpresent valuereturn on investmentnet present valueentrepreneurpartial commitmentunder diversified320 remove_red_eye
Property Valuations ModelingSimple Property Valuation Model showing the 3 primary methods for valuing property assets.real estatefinancial modelingdiscounted cash flowmodelerproperty valuationmodano1,987 remove_red_eye$15.00by Lance Rubin
Discounted Cash Flow (DCF) Analysis with IRR and NPVSeveral spreadsheets that can be used for the analysis of a real estate investment from various perspectivesacquisitionfinancecash flownpvirrdcfreal estatefinancial analysisinvestingdiscounted cash flow10,907 remove_red_eye
Value of Equity in a BankEstimate the value of equity in a bankvalueinvestmentfinancepresent valueequitybank397 remove_red_eye
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