Pro Forma II: Investment Waterfalls - Spring 2025

Modeling investment waterfalls is the most complex task in developing a pro forma, but it doesn’t need to intimidate you. In this course, you will develop the skills to be able to produce your own investment waterfall pro forma.

3.5 Hours 26 Lessons Live Class Pro Forma Fundamentals Certificate
Charles Tu

Daniel F. Mulvihill Endowed Chair of Real Estate, University of San Diego - Knauss School of Business

img
Get started!

Registration for this course closes April 8, 2025.

Pricing:
  • ULI Members: $395
  • ULI Members (Government/NonProfit/Academic): 11% off Member Price
  • Non-Members: $525

Topics

Finance and Investment
Pro Formas

Overview

This course takes you from the point of being capable of modeling a basic development or investment pro forma, to being able to model investment waterfalls in the context of advanced analytics and sensitivities testing. Develop and hone your analytical skills while learning to model investment pro formas involving multiple investors with different stakes and deals.

Learning Objectives

Upon completion of this course, you will:

  • Understand how to test your pro forma’s sensitivities to avoid costly errors.
  • Model investment waterfalls to plan distributions to equity partners.
  • Analyze a complex pro forma.

This course counts towards the Pro Forma Fundamentals Certificate - Winter 2025

To earn a certificate, you can complete courses in live, on-demand, or hybrid (live + on-demand) formats. Purchase the full certificate upfront or enroll in individual courses over time. If you upgrade from individual courses to a full certificate, you may qualify for a prorated price. Contact learning@uli.org to explore your options.

Format

This course includes three live online Q&A Sessions with the instructor in addition to on-demand content.

  • Tuesday, April 1, 2025 from 12-1pm EST
  • Thursday, April 3, 2025 from 12-1pm EST
  • Tuesday, April 8, 2025 from 12-1pm EST

* Please note that all live courses have a 180-day access period from the date of the first live session, unless purchased as part of a certificate. If you have any questions, please reach out to learning@uli.org

    Instructor

    instructor

    Charles Tu

    Daniel F. Mulvihill Endowed Chair of Real Estate, University of San Diego - Knauss School of Business

    Read More

    Curriculum

    26 Lessons
    Course Overview and Objectives
    Meet Your Instructor
    What is Included?
    Course Materials
    Getting Around
    Before You Begin...
    Before Your First Zoom Class (Please read)
    Tuesday, April 1, 2025 12-1pm ET - Join Zoom here!
    Session 1 Recording
    Thursday, April 3, 2025 12-1pm ET - Join Zoom here!
    Tuesday, April 8, 2025 12-1pm ET - Join Zoom here!
    Part 1: Distributing Operating Cashflow
    Part 2: Waterfall Distribution of Terminal
    Excel Modeling: Financial Performance for Each Partner
    Modifying Basic Model for More Flexibility
    Separating Tier One and Tier Two Cashflows
    Modeling Unpaid Preferred Return that is Not Compounded
    Modeling for Flexibility Based on Hurdle Rate
    Different Approaches to Modeling with a Hurdle Rate Requirement
    Permitting the Promote Before the Property is Sold
    Multiple Tier Waterfall Structure
    When GP and LP Do Not Receive Cashflow Simultaneously
    Test Your Knowledge
    Pro Forma II: Investment Waterfalls Quiz
    Your Thoughts
    Thank You

    img

    Curriculum

    26 Lessons
    Course Overview and Objectives
    Meet Your Instructor
    What is Included?
    Course Materials
    Getting Around
    Before You Begin...
    Before Your First Zoom Class (Please read)
    Tuesday, April 1, 2025 12-1pm ET - Join Zoom here!
    Session 1 Recording
    Thursday, April 3, 2025 12-1pm ET - Join Zoom here!
    Tuesday, April 8, 2025 12-1pm ET - Join Zoom here!
    Part 1: Distributing Operating Cashflow
    Part 2: Waterfall Distribution of Terminal
    Excel Modeling: Financial Performance for Each Partner
    Modifying Basic Model for More Flexibility
    Separating Tier One and Tier Two Cashflows
    Modeling Unpaid Preferred Return that is Not Compounded
    Modeling for Flexibility Based on Hurdle Rate
    Different Approaches to Modeling with a Hurdle Rate Requirement
    Permitting the Promote Before the Property is Sold
    Multiple Tier Waterfall Structure
    When GP and LP Do Not Receive Cashflow Simultaneously
    Test Your Knowledge
    Pro Forma II: Investment Waterfalls Quiz
    Your Thoughts
    Thank You
    Enroll Free Preview