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
- 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)
- Chloe Lee647(last updated: 18/07/2018 11:24)
- Nyarumwe family(last updated: 13/07/2018 15:02)
- David Tang(last updated: 07/07/2018 21:51)
- AlexSmith(last updated: 03/07/2018 19:58)
- Islam Raslan(last updated: 12/06/2018 20:28)
- Stella G(last updated: 30/05/2018 10:58)
- Allen Chng(last updated: 05/05/2018 13:50)
- Tianrong(last updated: 10/04/2018 03:48)
- Mohammed Halaseh(last updated: 12/03/2018 12:53)
- Ken Creighton(last updated: 14/12/2017 22:28)
- Emmanouil Saloustros(last updated: 28/11/2017 08:02)
- Ediale Eremionkhale(last updated: 22/11/2017 13:01)
- Mamadou Dr. Bass(last updated: 29/09/2017 09:38)
- Raffaella Pirrello(last updated: 02/05/2017 14:10)
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 ratenoiatkerson448 remove_red_eye
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorpropertysensitivity analysisrental property5,981 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,472 remove_red_eye
Credit Analysis Excel Model of Project Finance with Methane/Diesel PlantHow to use a model for evaluating credit analysis within project finance.financemodelfinancial modelcredit analysisproject financeexcelspreadsheetexcel modelmethane plantdiesel plant157 remove_red_eye
Property Mortgage CalculatorModel for calculating and tracking mortgage repaymentsbudgetfinanceinterestreal estatemortgagepropertypaymet schedule697 remove_red_eye
Property Valuations ModelingSimple Property Valuation Model showing the 3 primary methods for valuing property assets.real estatefinancial modelingdiscounted cash flowmodelerproperty valuationmodano1,881 remove_red_eye$15.00by Lance Rubin
Valuation Partial Commitment of the EntrepreneurLearn how to value an entrepreneur's partial commitment to a ventureinvestmentventurefinancevaluationpresent valuereturn on investmentnet present valueentrepreneurpartial commitmentunder diversified346 remove_red_eye
An Introduction to Leverage AnalysisA quick and informative video on leverage analysis.investmentfinanceequitydebtleveragefinancial managementleverage analysisborrowed money34 remove_red_eye
Calculate Effective Rent SpreadsheetDetermine effective rent of landlords and tenants while considering discount rates and uneven rent payments.financepresent valuereal estateeffective rentlandlordtenantdiscount ratetemplatefree1,983 remove_red_eye
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,968 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