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
- 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)
- Khareen Cee(last updated: 10/05/2019 02:22)
- Amir Ganic(last updated: 05/05/2019 14:40)
- Peter Trydeman(last updated: 03/05/2019 15:47)
- 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)
People using this tool also downloaded
Real Estate - Hotel/Resort Development Excel Model TemplateComplete financial model for financing, building, operating, refinancing, and selling hotel/resort property types.investmentfinancereal estatepropertyprivate equity600$40.00 by Spencer Dobson
Band Mortgage Equity Capitalization or Atkerson format EllwoodIncorporate and understand a financing's impact on value and compute the cap rate.financereal estatemortgageassumptionsellwood490$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 financinginvestmentfinancevaluationfinancingventure capital12,937
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorproperty8,663free by Amit Tandon
Real Estate - Property Acquisition Excel Model TemplateComplete financial model for purchasing, holding, and selling all investment property types.investmentfinancereal estatepropertyprivate equity712$25.00 by Spencer Dobson
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotel471$49.00 by Mahender K. Punhani
OneClick US S&P Stock Prediction Using Monte Carlo and Brownian Motion in PythonMonte Carlo and Brownian Motion Models Python script to predict future stock movements.investmentfinancefinancial modellingfinancial marketsmonte carlo76
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.investmentfinanceequitydebtleverage84
Feasibility Metrics (NPV, IRR and Payback Period) Excel TemplateNet present value, internal rate of return and payback period and see the results in dynamic graphs.investmentfinancecash flowcapital budgetingnpv208$3.00 by Big4WallStreet
LBO Excel Model Excel TemplateComplete LBO (Leveraged Buyout) model for financial analysis of potential investments and acquisitions.investmentfinanceleveraged buyoutprivate equityinvesting156free by Spencer Dobson
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