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...
Enroll Now - Select a section to enroll in
Type
3 week
Dates
Nov 20, 2024 to Dec 10, 2024
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jan 15, 2025 to Feb 04, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jan 29, 2025 to Feb 18, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Mar 12, 2025 to Apr 01, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
May 07, 2025 to May 27, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jul 02, 2025 to Jul 22, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Aug 27, 2025 to Sep 16, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Oct 22, 2025 to Nov 11, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Dec 17, 2025 to Jan 06, 2026
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Required fields are indicated by .