Mastering Waterfalls & Promotes

Understand real estate waterfalls, IRR hurdles, and promote structures in detail. Learn how to model investor distributions, partnership structures, and equity return calculations with clarity and precision using professional real estate financial modelling techniques.

  • DIFFICULTY LEVEL: Advanced

  • CPD HOURS: 9.0

Mastering Waterfalls & Promotes

Understand real estate waterfalls, IRR hurdles, and promote structures in detail. Learn how to model investor distributions, partnership structures, and equity return calculations with clarity and precision using professional real estate financial modelling techniques.

  • DIFFICULTY LEVEL: Advanced

  • CPD HOURS: 9.0

Course Overview

Waterfall and promote structures are among the most technically challenging areas of real estate financial modelling. Used across joint ventures, private equity, development partnerships, and investment structures, waterfalls determine how profits are distributed between investors and sponsors.

This course provides a practical, step-by-step guide to understanding and building real estate waterfall models in Excel using industry-standard modelling techniques.

You’ll learn how IRR-based waterfalls work, how promote structures are negotiated, and how to model equity contributions, preferred returns, hurdle rates, catch-up structures, and promote tiers accurately within a professional financial model.

The course also explores equity multiple structures, combined waterfall approaches, and methods for analysing and comparing different promote arrangements across investment scenarios.

Using practical real estate examples throughout, this course is designed to help you move beyond simply using waterfall templates - giving you the confidence to understand, build, test, and explain complex investor distribution models from scratch.

What you will learn

By the end of this course, you’ll be able to:

  • Explain how real estate waterfall and promote structures work

  • Understand IRR hurdles, preferred returns, and investor distribution mechanics

  • Build professional waterfall models in Excel from scratch

  • Set up flexible modelling inputs for equity splits, hurdle rates, and promote tiers

  • Model equity contributions, return of capital, and preferred returns accurately

  • Calculate promote structures across multiple hurdle layers and return tiers

  • Understand catch-up structures and how they impact investor distributions

  • Compare IRR-based and equity multiple-based waterfall structures

  • Analyse and compare different promote terms across investment scenarios

  • Test and audit waterfall models to ensure accurate distribution calculations

  • Improve your understanding of joint venture and partnership structures used in commercial real estate transactions

Who this course is for

This course is designed for professionals looking to develop advanced real estate financial modelling skills focused on equity waterfalls and promote structures.

It is particularly valuable for:

  • Real estate analysts and financial modellers

  • Investment and acquisitions professionals

  • Private equity and fund professionals

  • Development and joint venture professionals

  • Anyone involved in structuring or analysing commercial real estate partnerships

  • Professionals preparing for advanced modelling roles or technical interviews

A solid understanding of Excel and real estate financial modelling is recommended.

Ready to master real estate waterfalls?

Join the EiP Academy to access this course alongside the full library of real estate financial modelling training, live support sessions, downloadable tools, and practical commercial real estate case studies.

FAQs

What is a real estate waterfall model?

A real estate waterfall model determines how profits and cash flows are distributed between investors and sponsors based on agreed return hurdles and promote structures.

Will I learn IRR-based waterfall modelling?

Yes. The course focuses heavily on IRR-based waterfall structures, including preferred returns, hurdle rates, promote tiers, and catch-up mechanics.

Do you cover equity multiple waterfalls?

Yes. The course explores both IRR-based and equity multiple-based waterfall structures, including combined approaches used in commercial real estate transactions.

Is this course practical or theoretical?

The course is highly practical and focuses on building and analysing real estate waterfall models in Excel using real-world examples and industry-standard modelling approaches.

Will I build waterfall models from scratch?

Yes. You’ll learn how to structure and build waterfall models step-by-step rather than simply using pre-built templates.

Is this suitable for beginners?

This is an advanced course and is best suited to professionals with existing experience in Excel and real estate financial modelling. You can gain the requisite skills by undertaking other courses within the EiP Academy.

Copyright © 2026. EiP. All Rights Reserved.