The Advanced Real Estate Equity Waterfall Modeling Class
What you'll learn
- Learn to model real estate equity waterfall structures with a GP Catch-Up clause
- Learn to model waterfall structures with an LP clawback clause
- Learn to model waterfall structures with multiple preferred return hurdles (IRR & Equity Multiple)
- Learn to model waterfall structures based on cash-on-cash preferred return hurdles
Requirements
- Students should have a basic understanding of real estate finance
- The Real Estate Equity Waterfall Modeling Master Class is recommended
Description
Learn to model advanced real estate equity waterfall structures like catch-ups, clawbacks, multiple return hurdles, and more in a step-by-step, easy to understand way.
Real estate equity waterfall modeling is one of the most complex and advanced topics in real estate finance and financial modeling.
And with so many different structures out there, it can get overwhelming really quickly.
But fortunately, it doesn't have to be.
If you're looking to learn how to model complex equity waterfall structures like GP catch-ups, clawbacks, multiple return hurdles, and cash-on-cash return hurdles in an easy-to-understand, step-by-step way, you're in the right place.
My name is Justin Kivel, and I've taught over 15,000 students real estate financial modeling and analysis through my Break Into CRE courses.
And personally, throughout my career I've modeled over $1.5 billion of closed commercial real estate acquisitions, each of which involved raising capital from equity investors, and incorporating a unique waterfall structure to match each specific deal.
In this course, we're going to go step-by-step through building four real estate equity waterfall models from scratch:
The GP Catch-Up Model: In this model, we'll cover how to build out a GP "Catch-Up" waterfall structure in Excel, where cash flows are split pari passu until a certain hurdle rate, then cash flows are split in a different ratio until the GP "catches up" to a certain percentage of the overall profits, and then an additional structure above that. And we'll build it in a way where you can just change a few manual inputs, and everything else will change automatically for you.
The Clawback Model: In this model, we'll build out a "Clawback" waterfall structure in Excel, where the GP or sponsor was paid promoted interest early in the fund life based on achieving high returns, but then is required to return that promoted interest at the end of the fund life if the fund as a whole did not hit the preferred returns it promised investors.
The Multiple Return Hurdle Model: In this model, we'll build out a waterfall structure in which two different hurdles need to be hit in order for the GP to earn promoted interest on the deal. For cases where you have an IRR hurdle and also an equity multiple hurdle, this will be your go-to resource.
The Cash-on-Cash Waterfall Model: In this model, we'll build out a cash-on-cash based waterfall model. If you're doing a deal that you don't plan to sell any time soon, and want to get paid now (rather than after a return of capital), you'll find this model extremely helpful. We'll also include the build-out of a separate, back-end profit sharing structure, so you can customize the split of sale proceeds whenever you decide to sell the property.
We'll also clearly explain what's happening in each structure, behind the complex formulas that you see in Excel, so you know exactly how each structure functions in a real estate deal.
Here's what some our students have had to say about the course:
★★★★★ "Very clear explanations! I like the repetition through the different examples to embed learning. It's also helpful to say which shortcuts you are doing so that this becomes second nature."
★★★★★ "This is amazing training. It covers those hands-on things which are hard to get without being into the CRE business. Very detailed, error-less explanation of complex scenarios."
★★★★★ "Unbelievable course. I spent the weekend working through this and the prerequisite Equity Waterfall Modeling Master Class. This was the practical deep dive I needed to compliment my real world and academic exposure to Real Estate Private Equity."
★★★★★ "Fantastic course, and just like with Justin's other courses: crammed with great content and hands-on application. No fluff. Just into the materials and the mechanics. This course is rather advanced, but it covers a lot of different techniques, methods, and concepts."
At the end of this course, you'll be prepared to build a real estate equity waterfall model for any structure that's thrown your way, whether you're taking an Excel test for a real estate analyst or associate job at a real estate private equity or brokerage firm, or you're syndicating capital to buy your first real estate deal and building out investor materials and models to calculate investor returns and promoted interest.
Ready to get started? Just click the enroll button and let's start working through this step-by-step.
Looking forward to seeing you in class!
Who this course is for:
- Real estate investors and investment professionals who want to learn to build advanced equity waterfall structures in Microsoft Excel from scratch
- Real estate entrepreneurs who want to raise capital from investors and clearly present cash flows to investors and partners for their specific partnership structure
- Aspiring real estate investment professionals who want to add a lucrative skill set to their resume
Instructor
- 4.8 Instructor Rating
- 30,827 Reviews
- 80,623 Students
- 20 Courses
Master real estate financial modeling, advance your career, and earn more money.
If you’re an aspiring real estate investment professional looking to break into the real estate investment field, or a current real estate professional looking to advance your career and increase your compensation, you’re in the right place.
My name is Justin Kivel, and I’m a real estate investment professional with a love for teaching. Throughout my career, I’ve worked on over $1.5 billion of closed acquisitions across multifamily, retail, office, and mixed-use properties. I’ve had the opportunity to work with some of the brightest minds in real estate investing and have spent almost a decade in the industry across private equity, finance, and brokerage roles.
Unfortunately, most of what I know today I had to learn on the job. Although great courses exist on Microsoft Excel and financial modeling, I couldn’t find a resource that was specifically tailored toward real estate investment professionals that would actually walk me through exactly what I needed to know to succeed in the real estate investment industry.
These courses are that resource.
After dozens of phone calls and coffee meetings with college students and aspiring real estate investment professionals, I realized that most people were asking exactly what I was asking when I was in their shoes.
“What skills do I actually need to know to break into the real estate investment industry, or advance in my current real estate investment career?”
These courses were created to teach you those skills.
Our students have gone on to land jobs at some of the top real estate investment, development, and brokerage firms across the globe, including Brookfield Asset Management, Hines, Starwood Capital Group, LaSalle Investment Management, Eastdil Secured, JLL, CBRE, and many more.
Over 70,000 current and aspiring real estate investment professionals have used these courses to help them ace real estate financial modeling interview exams to land their dream jobs, secure consulting gigs with top private equity firms, build (and rebuild) entire financial models from scratch, and confidently analyze their own potential real estate investments.
So whatever that next step in your real estate investment career looks like, these courses are here to help you get there as quickly and efficiently as possible.
Looking forward to seeing you in class!