Loading...

Course Description

In this course, you will apply real estate financial modeling skills to a real-world example, offering the advantages of immersive decision-making but also assessment of that decision based on the outcome of a real example. You will examine an opportunity to invest in a Class B building located within the New York City submarket of Hell’s Kitchen on the west side of Manhattan. You will walk through the process of carefully underwriting the deal and, ultimately, deciding whether or not to invest.

In the process of this example transaction, you will gain experience using the industry’s commonly adopted approach: utilizing widely used modeling tools including Microsoft Excel and ARGUS, which is used to model office, retail, and industrial operating cash flows. By adjusting crucial variables, you will discover new insights in the process of creating a dynamic model using these industry best practices. Finally, you will delve into the step-by-step market analysis behind each one of the tenant scenarios to inform a final recommendation. By experiencing the whole project process, you will be equipped to apply these skills to your projects across the industry.

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

  • Discounted Cash Flows in Real Estate
  • Unlevered Real Estate Acquisitions
  • Real Estate Debt Financing and Scenario Analysis
  • Real Estate Development Financing
  • Equity Waterfalls in Joint Ventures

Faculty Author

Daniel Lebret

Benefits to the Learner

  • Integrate ARGUS outputs into Excel-based models to create a market analysis
  • Build and organize financial scenarios within the context of a development project
  • Apply an equity waterfall to a development project which distributes equity cash flows based on a partnership agreement
  • Create data tables to produce a summary of outputs for reporting purposes

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
Dec 18, 2024 to Jan 07, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Feb 12, 2025 to Mar 04, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Apr 09, 2025 to Apr 29, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Apr 23, 2025 to May 13, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jun 04, 2025 to Jun 24, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Jul 30, 2025 to Aug 19, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Sep 24, 2025 to Oct 14, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Type
3 week
Dates
Nov 19, 2025 to Dec 09, 2025
Total Number of Hours
15.0
Course Fee(s)
Standard Price $1,199.00
Required fields are indicated by .