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
- Kumod Ranjan(last updated: 16/04/2019 09:36)
- Ganti Kumar(last updated: 15/04/2019 15:50)
- Akintade Oluwarotimi 518(last updated: 03/04/2019 11:07)
- ongkes(last updated: 29/03/2019 09:41)
- 현성 나(last updated: 20/03/2019 17:39)
- Quintin Reynolds(last updated: 20/03/2019 02:52)
- Hardik Purohit(last updated: 18/03/2019 10:31)
- Sukhee Turkhuu(last updated: 11/03/2019 03:18)
- Sampath Dinusha(last updated: 05/03/2019 11:54)
- Fotios Bampanas(last updated: 24/02/2019 14:13)
- Aryan Ganotra(last updated: 19/02/2019 04:26)
- Beechwood London(last updated: 16/02/2019 08:38)
- Dr. Marlon Mitchell, PMP, PhD(last updated: 30/01/2019 16:39)
- Nick Vardalachos(last updated: 26/01/2019 09:34)
- William Böll(last updated: 24/01/2019 14:18)
- Francis Nyambiri MRICS, MREIZ(last updated: 23/01/2019 12:30)
- 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)
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.assumptionsatkersoncap ratecapitalizationellwood456$10.00 by Prof. Norm Miller PhD
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 financingassumptionsentrepreneurfinancefinancinginvestment11,196
Rental Property Investment ModelA model for calculating returns on rental propertiesfinanceinvestmentinvestorpropertyreal estate7,399free by Amit Tandon
Real Estate - Hotel/Resort Development Excel Model TemplateComplete financial model for financing, building, operating, refinancing, and selling hotel/resort property types.buildingfinancefinancial modelinghotelinvesting269$40.00 by Spencer Dobson
Real Estate - Property Acquisition Excel Model TemplateComplete financial model for purchasing, holding, and selling all investment property types.buildingfinancefinancial modelinginvestinginvestment540$25.00 by Spencer Dobson
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.borrowed moneydebtequityfinancefinancial management67
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.appraisalexcelfinancehotelinvestment351$49.00 by Mahender K. Punhani
Valuation Partial Commitment of the EntrepreneurLearn how to value an entrepreneur's partial commitment to a ventureentrepreneurfinanceinvestmentnet present valuepartial commitment389
Property Valuations ModelingSimple Property Valuation Model showing the 3 primary methods for valuing property assets with an interactive visual.discounted cash flowfinancial modelingmodanomodelerproperty valuation2,278$9.50 by 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 perspectivesacquisitioncash flowdcfdiscounted cash flowfinance12,820$40.00 by Prof. Norm Miller PhD
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