Course Highlights
  • A complete "done-for-you" institutional-level equity waterfall model to use in any real estate transaction.
  • A thorough understanding of the key components of an equity waterfall and how it is used in real estate investing.
  • The ability to build a fully functioning, dynamic equity waterfall model in Microsoft Excel to use for any deal in any situation.
Curriculum

6 Topics
Welcome!
What We Will Cover
A Sneak Peek Into What You'll Build
Who This Course Is For
About The Instructor & Student Success Stories
Disclaimer

5 Topics
Real Estate Partnership Basics
The General Partner
The Limited Partner
GP Compensation
The Waterfall Structure

5 Topics
The "Why" Behind an Equity Waterfall
How Equity Waterfall Structures Work
Equity Waterfall Example
Promoted Interest vs. Cash Flow Split
Measuring Partnership Investment Returns

26 Topics
Equity Waterfall Modeling Walk-Through
Modeling GP & LP Cash Flow Splits
Building Out The Investment Timeline
Modeling Project-Level Cash Flows
Building Out The NOI
Modeling Principal & Interest Payments
Purchase & Loan Metrics
Disposition Metrics
Modeling Loan Payoff & Project-Level Cash Flows
Modeling The Preferred Return
Beginning Balance & Preferred Interest Accrual
Modeling The Preferred Return Over Time
Modeling LP Contributions & Distributions
Modeling GP Contributions & Distributions
Total Distributions & Cash Flow Remaining
Modeling Hurdle #2
Beginning Balance & Hurdle #2 Accrual
Modeling Hurdle #2 LP Distributions & Total Cash Flow
Modeling Hurdle #2 GP Distributions
Modeling Hurdle #3
Hurdle #3 GP Distributions
Modeling Hurdle #4
Total LP Cash Flows & Returns
Total GP Cash Flows & Returns
Project-Level Return Metrics
Calculating Promoted Interest

3 Topics
IRR Does Not Equal Cash-on-Cash
How To Add What You've Built To Another Model
How To Incorporate Multiple Partners

1 Topic
Where To Go From Here

1 Topic
Bonus Lecture - The Next Step

  Write a Review

The Real Estate Equity Waterfall Modeling Master Class

Go to Paid Course