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
- 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 ratenoiatkerson348 remove_red_eye
Rental Property Investment ModelA model for calculating returns on rental propertiesinvestmentfinancereal estateinvestorpropertysensitivity analysisrental property3,622 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 investment6,076 remove_red_eye
Property Valuations ModelingSimple Property Valuation Model showing the 3 primary methods for valuing property assets.real estatefinancial modelingdiscounted cash flowmodelerproperty valuationmodano1,198 remove_red_eye$15.00by Lance Rubin
Stock Analysis Excel ModelAnalyze past company performance and arrive at its intrinsic value in 30 minutes or lessinvestmentfinancemodelvaluationexcelstock analysisperformance analysisfinancial markets1,509 remove_red_eye
Real Estate Excel ModelA Real Estate Financial Model where new property owners purchase their houses outrightfinancereal estatefinancial modelproceedstown housereturnsenior debtmezzanine debt2,619 remove_red_eye
Cash Flow Waterfall ModelA cash flow model for Real Estate based on a waterfall structurefinancecash flowreal estatewaterfallinvestordeveloper4,809 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 flow6,963 remove_red_eye
Startup Excel ModelA startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.financecash flowprivate equityfinancial modelstartupfundraisingventure capitalassumptionscapexheadcount9,657 remove_red_eye
Present Value of Entrepreneur's Wealth and CommitmentCalculate how much your entrepreneurial investment is worth in your total projected wealth over your careerinvestmentventurefinancepresent valuestartupdecision makingcareer managemententrepreneurwealth96 remove_red_eye
Discussion feed for Commercial Real Estate Financial Model
The user community and author are here to help. Go ahead!