3171 students

This is the fourth course in the 16-course Accelerator and a companion to course 3. Anatomy of the Real Estate DCF. In this  mini-course, you will continue where you left off with the Lakefront Industrial I hold/sell analysis case. Taking the DCF model you built from scratch, you will calculate other important risk and return metrics to complete your analysis.

The concepts learned in course 3. Anatomy of the Real Estate DCF, together with those learned in this course, provide the framework for building more sophisticated acquisition, development, and value-add models later in the Accelerator.

In this course you will learn to calculate:

  1. Unlevered and Levered IRR (annual and non-annual periods)
  2. Unlevered and Levered Equity Multiple
  3. Free and Clear Return and Cash-on-Cash Return
  4. Net Profit
  5. Average Rate of Return
  6. Operating Expense Ratio
  7. Expense Recovery Ratio
  8. Economic and Physical Occupancy

In addition, we will show a technique for partitioning the IRR and Equity Multiple.

CASE DESCRIPTION – LAKEFRONT INDUSTRIAL PART 2

Continuing the case from course 3, you are a member of A.CRE Advisors’ asset management team. You are personally responsible for managing 17 industrial assets. Your assets consist largely of bulk warehouses built in this cycle (i.e. since 2010) for e-commerce and logistics tenants.

The assets are all held within an open-end core fund, with no expressly defined fund termination date. The strategy is to provide consistent long-term income to the investors, while timing acquisitions and dispositions so as to maximize overall returns and beat the NFI-ODCE index.

In a recent conversation with your portfolio manager, he mentions that the acquisitions team is looking at an exciting industrial opportunity. However, he doesn’t want to add another industrial asset to the fund without identifying an equally attractive disposition opportunity. Lakefront Industrial Building 1 comes up as a potential disposition target, and so you commit to doing a hold/sell analysis on the property.

You’ve built a 10-year discounted cash flow model forecasting the projected cash flows for Lakefront Industrial Building I were you to hold the asset long-term. You also quickly calculated the unlevered IRR of that scenario. You’ve now been asked to analyze the hold scenario further and calculate a few more risk and return metrics to help your Portfolio Manager make a more informed decision.

PROPERTY TYPE

  • Industrial; concepts apply to all property types

SOFTWARE RECOMMENDED/REQUIRED

  • While we recommend using Microsoft Excel, as that is the industry standard, this course will work with most other spreadsheet software such as Google Sheets and OpenOffice Calc

EXCEL PROFICIENCY REQUIREMENT

  • The course assumes you have at least an intermediate proficiency working with Microsoft Excel, Google Sheets, or OpenOffice Calc

Instructor(s)

User Avatar

Spencer Burton

Spencer Burton is the Co-Founder and CEO of CRE Agents, a Vertical AI Agentic Platform changing how work gets done in commercial real estate. With over 20 years of experience as a fiduciary, principal, and founder in real estate, he is a recognized expert in applying AI to CRE. His mission at CRE Agents is to give people back life’s most precious asset—time. By pushing repetitive tasks to AI-driven “digital coworkers”, CRE Agents empowers professionals to focus on high-impact work, driving better returns and more fulfilling careers.

Prior to CRE Agents, Spencer served as President and founding team member of Stablewood, a multi-strategy institutional real estate investor leveraging AI, machine learning, and data analytics. At Stablewood, he co-developed an AI-enabled digital coworker that underwrote and created investment memos for 50,000+ CRE transactions, equating to four years of work for 20 full-time analysts.

Spencer is also the co-creator of Adventures in CRE (A.CRE), the industry’s leading platform for financial modeling, education, AI learning, and career development. Through A.CRE, he’s trained thousands of professionals at some of the world’s top companies and universities.

Spencer has built a reputation as an innovator and thought leader in CRE. He has held senior roles at top institutional firms, helped launch two successful startups, and deployed automation across brokerage, development, acquisitions, debt production, and management.

Spencer holds a Bachelor’s in International Affairs with an emphasis in economics from Florida State University and a Master’s in Real Estate with a concentration in finance from Cornell University.

Free