3186 students

COURSE DESCRIPTION

This is the 14th course in the 16-course Accelerator, and the first of three capstone courses. In this case-based course, you will put in practice what you learned in the previous courses to build an institutional-quality, single-tenant acquisition model from scratch.

In this course you will rely heavily on the following concepts learned from previous Accelerator courses:

  1. Use the inputs –> calculation modules –> outputs concept to build a fully dynamic real estate model
  2. Create a direct cap pro forma to derive a purchase price
  3. Model operating cash flows, applying appropriate growth rate, recovery percentage, and vacancy assumptions
  4. Create a direct cap pro forma to derive a reversion value
  5. Layer in debt, modeling debt service, loan payoff, and various risk metrics
  6. Build a discounted cash flow model, summing to unlevered and levered net cash flow lines
  7. Calculate property-level return metrics
  8. Model a partnership waterfall to arrive at partnership-level returns
  9. Use proper formatting and layout convention

CASE DESCRIPTION – 10000 Fitness Way

You own a small real estate investment firm. Your firm, consisting of just you and an administrative assistant, largely sticks to a value-add multifamily investment strategy. Over the past nine years, you have bought and sold 12 class B and C multifamily properties totally over 1200 multifamily units. Your strategy has been simple. Buy underperforming, older apartment projects in good locations, renovate 70% – 80% of the units, and then sell the properties at a profit.

However, as the cycle has matured, it has become ever more difficult to find profitable apartment flips. You are now convinced the market has reached peak pricing and you’re considering putting your gains into a more conservative long-term strategy while you wait for the buying opportunities to return.

In addition to placing your own capital in a longer term real estate play, you have limited partners from previous deals who are anxious to redeploy their capital. You worry that if you don’t find a smart opportunity or two in the next 6-12 months, they may place their capital elsewhere.

This evening you head to a local CCIM networking event. There, you bump into your old friend and former classmate from business school, Trey Fishman. Trey mentions that he is about to bring to market a great single-tenant acquisition opportunity. The tenant, a BBB-rated fitness operator, recently signed a 15-year absolute NNN lease with 2% annual rent bumps. He remarks that this asset would be a great place to park capital through a market downturn.

You’re intrigued. While you don’t have direct experience in retail, the single-tenant NNN nature of the lease would make managing this asset simple. Which in turn would both allow you to place a portion of your capital in a steady investment and still have time to seek opportunistic investments.

He offers to send you the book, and you gladly accept.

PROPERTY TYPE

  • Retail; most 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
  • This course was built using the Google Chrome browser, thus we recommend you use Google Chrome for optimal view experience
  • This course is best taken on a desktop computer, although the platform is compatible with tablet and mobile devices

EXCEL PROFICIENCY REQUIREMENT

  • The course assumes you have at least a basic proficiency working with Microsoft Excel

Instructor

User Avatar The A.CRE Team

Spencer and Michael started Adventures in CRE in their first year of graduate school. Since that time, the two have written over 350 in-depth articles on real estate financial modeling, careers, and education options; built and shared over 60 institutional-quality real estate financials models; developed an extensive glossary of real estate terms, recorded over 100 tutorial videos, and created the most comprehensive real estate financial modeling training program available.
Michael Belasco has over eight years of real estate and construction experience. He currently works for a global real estate investment, development, and asset management firm in San Francisco managing large scale development projects in the city. Michael has both an MBA and Master in Real Estate with a concentration in Real Estate Finance from Cornell University.
Born and raised in the Northwest United States, Spencer Burton has nearly 20 years of residential and commercial real estate experience. Over his career, Spencer has helped close $4.5 billion and underwrite $30 billion of commercial real estate at some of the largest institutional real estate firms in the world. He is currently the Head of Real Estate Investments and member of the founding team at Stablewood Properties. Spencer Burton holds a Bachelor of Arts in International Affairs with an emphasis in economics from Florida State University and a Masters in Real Estate with a concentration in finance from Cornell University.