# Real Estate Waterfall Model – Equity Multiple Hurdles

I’ve created a companion to my real estate equity waterfall model to work with equity multiple hurdles, rather than IRR hurdles. It took me longer than I expected to build this, largely because I was over thinking it. I messed around with IF statements, and adding rows, and a whole lot of other ideas that were unnecessary. In the end, after scrapping my earlier versions and starting over, the solution was simple.

Rows 39, 53, and 68 calculate the “required return to the LP”, right? Well, all that needed to happen was to change how those three rows calculated the required return to the LP. I altered the ‘Promote Structure’ (B10:I13) to use equity multiple values instead of IRR values, and then added a formula in the required returns rows that essentially looked at the contributions from the LP in the previous period, and calculated the equity multiple that would need to be realized based on those contributions before flowing to the next hurdle.

In the coming days, I’ll record and post a video discussing the changes and how they might affect your models. The video will also provide a brief tutorial on how to setup the promote structure.

This is version 1.0, and so there may be errors. Let me know if you find any, and I’ll be happy to correct them. In the coming weeks, I’m planning to work on an all-in-one real estate equity waterfall model that will incorporate IRR hurdles, equity multiples hurdles, and let the user choose whether to use one, the other, or both in their waterfall calculations.

NOTE: Since writing this post, I’ve combined my IRR and equity multiple waterfall models into one. While this post still describes the methodology used to model equity waterfalls based on an equity multiple promote structure, the Excel file download includes the new, combined model.

To make this model accessible to everyone, it is offered on a “Pay What You’re Able” basis with no minimum (enter \$0 if you’d like) or maximum (your support helps keep the content coming – typical real estate models sell for \$100 – \$300 each). Just enter a price together with an email address to send the download link to, and then click ‘Continue’. If you have any questions about our “Pay What You’re Able” program or why we offer our models on this basis, please reach out to either Mike or Spencer.

#### Real Estate Equity Waterfall Model - Annual with IRR and Equity Multiple Hurdles

• Up to a four tier promote structure
• IRR or equity multiple hurdles
• Pari-passu return of capital; possible to create senior/junior equity structures