275 students

COURSE DESCRIPTION

This is the first course in the 16-course Accelerator. In this case-based course, you will learn to value income-producing real estate using the Direct Capitalization method.

Regardless of your role in real estate, you will use the concepts, skills, and techniques learned in this course almost daily.

In this course you will:

  1. Learn to build out a static real estate pro forma for a multifamily investment, modeling from Gross Rental Revenue to Net Operating Income
  2. Derive an appropriate capitalization rate (“cap rate”) from a competitive set of similar properties in the market
  3. Combine the net operating income and cap rate to arrive at an estimated value for the investment
  4. See how the principles learned in this course apply in the real world

CASE DESCRIPTION – THE FOLES

You have recently been hired by A.CRE Advisors as part of their multifamily acquisitions team, underwriting prospective investments. Your boss has called you into his office to discuss an Offering Memorandum (“OM”) he just received from a broker, East Lang Ellis, for Foles Tower – a 300 unit, Class A, multifamily high rise in the Center City submarket of Anycity, USA.

Your boss would like you to put together a basic real estate financial model using the information provided in the OM and the supplemental documents that have been uploaded to the broker’s “War Room”. He is requesting you use both the direct capitalization and discounted cash flow methods to assess the value of the opportunity.

PROPERTY TYPE

  • Multifamily; 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

Spencer Burton

Born and raised in the Northwest United States, Spencer Burton has over 15 years of residential and commercial real estate experience. In his current position, Spencer sources and analyzes new investments for a $45bn real estate fund.

Spencer Burton holds a Bachelor of Arts in International Affairs with an emphasis in economics from Florida State University and a Master of Professional Studies in Real Estate with a concentration in finance from Cornell University.

Free