The Real Estate Equity Waterfall Modeling Master Class

The Complete Guide To Building Dynamic Real Estate Equity Waterfall Models In Microsoft Excel

Last updated 2022-01-10 | 4.8

- 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.

What you'll learn

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.

* Requirements

* Access to Microsoft Excel for PC or Mac.
* A basic understanding of Microsoft Excel.
* Some background knowledge in real estate investing is recommended.

Description

Everything you need to know about real estate equity waterfalls, all in one place. 

This course will teach you everything need to know about how an equity waterfall works in real estate transactions, from the underlying mechanisms behind a waterfall, to how an equity waterfall is structured, to how to build an equity waterfall financial model in Excel. Whether you're syndicating a real estate deal on your own, investing as a Limited Partner in a real estate syndication, or you're a current real estate professional looking to add a lucrative skill set to your arsenal, this is a one-stop shop for everything real estate equity waterfall-related.

This course was designed for people from all parts of the real estate spectrum, including:

  • Current or aspiring real estate syndicators who want to earn outsize returns on their investments - Being aligned with investor interests is critical when structuring a real estate transaction, and a clear waterfall structure with incentives based on investment performance is the most direct way to create a win-win relationship for your team and your capital partners. Understanding the mechanisms behind an equity waterfall and having a dynamic waterfall model in your toolkit will allow you to structure your deals in the most advantageous way for both yourself and your investors.

  • Passive real estate investors involved as LPs in real estate syndications who want to invest passively with confidence - The Limited Partner position in real estate investing is a great role - no work involved, an inflation-protected, tax-shielded investment, and experienced management - but do you know how much you're paying in fees? Understanding how a waterfall structure functions and having a dynamic Excel model to calculate true net returns can be the difference between a sound investment and being locked into a watered-down deal for years to come.

  • Current real estate professionals who want to earn more money - Equity waterfall modeling is one of the most desired skill-sets in all of real estate finance, with professionals proficient in this topic earning more than 8.1% above their peers according to national real estate recruiting firm RETS Associates. If you are a current or aspiring real estate professional, understanding the mechanics of an equity waterfall functions and how to build an equity waterfall in Microsoft Excel will put you head and shoulders ahead of your peers and add a rare and lucrative skill-set to your real estate investing arsenal.

Here's what some of our students have had to say:

★★★★★ "I've tried other real estate financial modeling classes, and they tended to be too general (even where they had some hands-on Excel exercises). Justin hit just the right balance between the big picture and the nuts and bolts of building the worksheet, and, therefore, truly understanding it."

★★★★★"Clear and straightforward. Wow! Amazed at this curriculum. He has made something super difficult easy and he explains it super clear. Its like meeting a super cool private equity guy spend the time to show you step by step. He can make your career!"

★★★★★"This course is highly recommended for individuals wanting to learn about equity waterfall modeling. It's obvious that the instructor understands this topic very well and he presents it in a very simplified manner. The process of creating the model from scratch and having the instructor walk you through it on a step-by-step basis really solidified my understanding of this material. Excellent course!"

★★★★★"Highly detailed and informative. Great for analyst who are just getting started. It's like taking an MBA level course!"

★★★★★"This is a phenomenal course as are Justin's other courses. I am a commercial real estate professional working as an analyst at a 'Big Four' broker and have found all these courses to be invaluable, particularly if you are concerned about the technical test for job interviews."

Understanding equity waterfalls will put you miles ahead of the game, whether you're looking to do your first deal or trying to land a job in commercial real estate finance. Looking forward to seeing you in the course!

Who this course is for:

  • Real estate investors and syndicators who want to learn how to build an equity waterfall model from scratch.
  • Real estate private equity analysts and associates who want to add another valuable and lucrative skill set to their arsenal.

Course content

7 sections • 47 lectures

Welcome! Preview 00:49

What We Will Cover Preview 03:20

A Sneak Peek Into What You'll Build Preview 02:22

Who This Course Is For Preview 02:25

About The Instructor & Student Success Stories Preview 02:51

Disclaimer Preview 01:23

Real Estate Partnership Basics Preview 02:18

The General Partner Preview 02:44

The Limited Partner Preview 03:05

GP Compensation Preview 04:02

The Waterfall Structure Preview 02:36

The "Why" Behind an Equity Waterfall Preview 02:05

How Equity Waterfall Structures Work Preview 04:40

Equity Waterfall Example Preview 03:49

Promoted Interest vs. Cash Flow Split Preview 04:06

Measuring Partnership Investment Returns Preview 03:51

Equity Waterfall Modeling Walk-Through Preview 03:40

Modeling GP & LP Cash Flow Splits Preview 04:58

Building Out The Investment Timeline Preview 08:07

Modeling Project-Level Cash Flows Preview 05:54

Building Out The NOI Preview 05:43

Modeling Principal & Interest Payments Preview 06:37

Purchase & Loan Metrics Preview 04:04

Disposition Metrics Preview 05:23

Modeling Loan Payoff & Project-Level Cash Flows Preview 06:37

Modeling The Preferred Return Preview 04:44

Beginning Balance & Preferred Interest Accrual Preview 04:14

Modeling The Preferred Return Over Time Preview 04:37

Modeling LP Contributions & Distributions Preview 09:24

Modeling GP Contributions & Distributions Preview 07:19

Total Distributions & Cash Flow Remaining Preview 04:59

Modeling Hurdle #2 Preview 07:04

Beginning Balance & Hurdle #2 Accrual Preview 05:38

Modeling Hurdle #2 LP Distributions & Total Cash Flow Preview 05:23

Modeling Hurdle #2 GP Distributions Preview 04:51

Modeling Hurdle #3 Preview 10:32

Hurdle #3 GP Distributions Preview 03:19

Modeling Hurdle #4 Preview 06:57

Total LP Cash Flows & Returns Preview 09:10

Total GP Cash Flows & Returns Preview 06:57

Project-Level Return Metrics Preview 03:39

Calculating Promoted Interest Preview 07:48

IRR Does Not Equal Cash-on-Cash Preview 03:09

How To Add What You've Built To Another Model Preview 09:55

How To Incorporate Multiple Partners Preview 06:44

Bonus Lecture - The Next Step Preview 00:34