
Last version published: 12/11/2020 08:27
Publication number: ELQ-94669-18
View all versions & Certificate

Commercial Real Estate Acquisition Model - Protected
Advanced Real Estate Model, that allows a professional DCF Valuation for Office, Retail or Industrial Properties
Description
MODEL DESCRIPTION:
This model is one of the most detailed and comprehensive out there to assess Retail, Office or Industrial Properties, either as a value-add or already stabilized deal. This is not a Multifamily or Ground-Up Development Model. The maximum number of tenants is 60. If you need adjustments to the model please contact me.
Its functionality supports a wide variety of investment scenarios including different capital structures, lease recoveries, tenant rollover, refinance analysis as well as asset management considerations. It is ideal for brokers or investors, who are looking in presenting a deal to capital partners or clients or would like an accurate valuation of an investment property. Even though the model was originally designed for US-use, area, and currency can be adjusted in the Underwriting Dashboard.
The model has taken years of building and updating, which has translated in a very detailed and robust tool, which makes it a great Excel-based alternative for Argus at a fraction of the cost.
As a first step, review the Version Tab, which gives you an overview of the color-coding methodology and the sections of the model. Note the back-end of the model is locked, if you would like the model to be fully unprotected please purchase the unprotected version, that can be found here: https://www.eloquens.com/tool/8wPgFxEw/finance/real-estate/commercial-real-estate-acquisition-model-unprotected
Watch the links below to better understand the structure and functionality of the model:
General Walkthrough: https://youtu.be/-4qGkDbuaJc
Value-Add Case Study: https://youtu.be/W79R9A3tBVE
The model has undergone various iterations and extensive testing to ensure that there are no errors. Given the size and impressive depth, it is impossible to ensure there are none. However, if you do come across errors please let me know so that I can fix them.
The Model is provided as-is. Customization is available upon request. I'm continuously updating the model and therefore feedback is appreciated.
Hope you enjoy the model and feel free to reach out to me for comments, questions, or additional requests.
-Julian
CONTENTS:
Executive Dashboard: Quick summary over the deal, includes major key metrics, Rolled up Cash Flows and Key Metrics Charts
Executive Summary: Printable booklet of the deal and present to clients, investors, partners or lenders
Sensitivity Analysis: Availability to stress-test Model, Two-way data table for Purchase/Exit Price Sensitivity
Exit Analysis: Shows IRR and EMx based on Exit Timing
Monthly and Annual Waterfall: Partnership Distribution for General and Limited Partner, includes an option to add Sponsor Fees
Debt Module: Up to 3 different Loans, can be used for Acquisition Loan or Refinance
Construction Module: Capital Improvements and Construction Loan
Audit: Allows to overwrite and detail out Cash Flows, where the model does not provide pre-set logic
Rent Roll: Existing Leases, Vacant Lease-Up, 2nd Generation Lease and Market Leasing Assumption s for Rollover, % Rent
Underwriting Dashboard: Global Deal Assumptions, such as Acquisition, Disposition, Tax Re-Assessment, Inflation
Operating Expenses: Fixed/Variable %, Min. and Max and Start End Dates
Recovery Settings: Option to include expenses in recovery settings, Gross-Up, Recovery Options are Net, Stop Amount, Base Year Stop and Gross
Historical Financials: Option to add historical Cash Flows to come up with underwritten expenses
LIMITATIONS:
65 Tenants Max, 10 Year Investment Horizon (those are limits due to size constraints if you would like to expand limitations get in-touch with me)
This Best Practice includes
1 Excel Template
Reviews
- Rate this Downloadable Best Practice
Write a review
Mamoun Abusaad(last updated: 18/10/2020 11:00)
Ed Constable(last updated: 31/08/2020 03:01)
Financial Modeler(last updated: 12/08/2020 04:43)
Orianna Rangel 914(last updated: 25/07/2020 13:44)
Javed Siraj(last updated: 22/07/2020 08:25)
Amir Ganic(last updated: 24/04/2020 09:48)
People using this Best Practice also downloaded
Real Estate Proforma Excel Model Template
This is a Real Estate Proforma Template in Excel for you to use and analyse for your own needs.pro formaexcelcommercial real estatereal estate financereal estate proforma9,018Discussadd_shopping_cartfreeby Property Metrics
Real Estate Financial Model (Very Detailed)
Real Estate Financial Model for real estate investment professionals in fields like RE Private Equity, RE Valuation, etcfinancevaluationreal estateprivate equityfinancial modelling57Discussadd_shopping_cart$175.00by Anuj Verma
Commercial Real Estate Acquisition Model - Unprotected
Advanced Real Estate Model, for a professional DCF Valuation of Office, Industrial or Retail Propertiesmodelnpvirrreal estatefinancial model6076add_shopping_cart$99.00by Julian Scheeff
Real Estate - Financial Model for an Industrial Warehouse Development Project
Case study PDF and Excel File for the Financial Model.financereal estatecase studyfinancial modelexcel259Discussadd_shopping_cart$10.00by Padmashri V
Commercial Real Estate Excel Model Template
A complete & thorough Commercial Real Estate Model for you to adapt and use for your own usage.investmentscash flowirrleveragereal estate1,1042add_shopping_cart$49.00by Big4WallStreet
Real Estate Multi Family Development Excel Model
Real Estate Financial Model to evaluate a development project, with Equity Waterfall and Advanced Scenarios Modelingirrreal estatenoiexcelreal estate finance2,4644add_shopping_cart$35.00by Jair Almeida
Income Property Valuation Model Excel Template
An Income Property Valuation Model template in excel along with step-by-step instructions.valuationreal estatesaassoftware as a serviceexcel1,610Discussadd_shopping_cartfreeby Ben Murray
Real Estate Valuation Excel Model - Income and Cost approach
A simple Real-Estate Valuation model that also allows to use the income approach (capitalization) and cost approach.valuationreal estatereal estate valuationincome approachcapitalization method1,564Discussadd_shopping_cartfreeby Finance Cell
Financial Modeling In a Nutshell
Financial Modeling Guide with Free Excel Model Samplefinancevaluationfinancial modelfinancial modelingexcel1,665Discussadd_shopping_cartfreeby P MB
Stock Analysis Excel Model
Analyze past company performance and arrive at its intrinsic value in 30 minutes or lessinvestmentfinancemodelvaluationexcel7,9781add_shopping_cartfreeby Vishal Khandelwal
More Best Practices from Julian Scheeff
Commercial Real Estate Acquisition Model - Unprotected
Advanced Real Estate Model, for a professional DCF Valuation of Office, Industrial or Retail Propertiesmodelnpvirrreal estatefinancial model6076add_shopping_cart$99.00by Julian Scheeff
Incredible Bulk Email Blast Spreadsheet
This tool will enable you to send emails with the same or varying attachments to a list of recipients.marketingreal estatetoolsusefulemail68Discussadd_shopping_cart$5.00by Julian Scheeff
Any questions on Commercial Real Estate Acquisition Model - Protected?
The user community and author are here to help. Go ahead!