Loading...

Course Description

In the competitive world of commercial real estate and asset management, creating reliable tools like acquisition models will allow you to make confident predictions, even in the face of common risks such as building vacancy. In this hands-on course, you will analyze the procedure for building a structural model from the ground up.

This course will start with forecasting rental income and its main challenge, vacancy, for an office building. Forecasting future operating income requires looking lease by lease through each source of operational revenue and expense. Some items, such as expense recoveries, are recurring; others, like tenant improvements and leasing commissions, are exceptional. From here, an estimation of value and performance will require an assessment of the risks to which the investment will be exposed. Aggregating this forecast of unlevered income after making the proper adjustments for risk is the foundation for all future acquisition models. By the end of this course, you will be poised for success as you apply the concepts from this course in your role and beyond.

You are required to have completed the following course or have equivalent experience before taking this course:

  • Discounted Cash Flows in Real Estate

OR

  • Familiarity with the Microsoft Excel environment and the structure of a basic discounted cash flow model
  • The ability to apply conditional functions in Excel (IF statements and LOOKUP, TRUE/FALSE, INDEX/MATCH, OFFSET, and MIN/MAX functions) to produce the desired outcome

Faculty Author

Daniel Lebret

Benefits to the Learner

  • Precisely model vacancy for different property types
  • Model for certainty versus uncertainty
  • Create a model for expense recovery by lease type taking vacancies into consideration
  • Develop a model for operating expenses by property type
  • Create a model that demonstrates variations in recurring capital expenses

Target Audience

  • Acquisition and asset managers
  • Financial analysts
  • Real estate investors
  • Real estate development professionals
  • Individuals looking to invest in commercial real estate
  • MBA students
  • City and regional planning professionals

Accrediting Associations

Applies Towards the Following Certificates

Loading...
Cornell SC Johnson College of Business
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .