Over the years, my real estate equity waterfall with annual periods and the option of using either IRR or Equity Multiple Hurdles has been one of the most popular models download at Adventures in CRE. I’ve received dozens of requests for how to improve the model, and so I thought I’d incorporate some of those changes into an updated version.
About this Real Estate Equity Waterfall Model
The model allows for up to four tiers (IRR or equity multiple hurdles), with the first tier paying a preferred return, pari-passu, to the sponsor and LPs after the full return of capital to the partners based on their proportionate share of equity contribution. Tiers two through four model a promote paid to the sponsor at a proportion greater than its relative share of equity contribution.
Working with a less-complicated real estate partnership structure? Check out my Real Estate Equity Waterfall Model with Cash-on-Cash Return Hurdle
Real Estate Equity Waterfall as a Module
This equity waterfall model is built for inclusion in other models – or in other words it is not standalone. As a result, it assumes you have already modeled the total equity required, and have calculated the net cash flow stream before taxes but after debt service (equity cash flow).
It is built on an annual basis for up to 15 years of analysis, and assumes only one sponsor (GP). While the model is simple, the foundation is there to easily add additional IRR or Equity Multiple hurdles, years of analysis, or partners. Also, with a little more effort, the model can be adjusted to use both equity multiple hurdles and IRR hurdles together.
Download The 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.
Note (especially for Gmail users): The model is sent via email and occasionally is blocked by spam filters. If you don't see the email arrive within five minutes, check your spam folder.
We regularly update the model (see version notes). Paid contributors receive a new download link via email each time the model is updated.
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
- Easy to add to your existing model
This Excel file (the "software") is distributed as is, completely without warranty or service support. www.AdventuresinCRE.com and its authors are not liable for the condition or performance of the software. www.AdventuresinCRE.com owns the copyright and grants users a perpetual, irrevocable, worldwide, non-exclusive, royalty-free license with respect to the software as set forth below.
www.AdventuresinCRE.com and its authors hereby disclaim all implied warranties. www.AdventuresinCRE.com grants the users the right to modify, copy, and redistribute the software and documentation, both within the user's organization and externally, subject to the following restrictions:
1. The users agree not to charge others for use of the software, regardless of whether users have altered and/or improved the software in anyway.
2. In any use of the software, the users agree to acknowledge the www.AdventuresinCRE.com authors that developed the software.
3. The users agree to obey all government restrictions governing redistribution or export of the software.
4. The users agree to reproduce any copyright notice which appears on the software and documentation on any copy or modification of such made available to others.
Video Walkthroughs of the Real Estate Equity Waterfall
I recorded this video nearly three years, and as a result several of the inputs and outputs are out-of-date. In the coming weeks, I’ll record an updated video including the new features and changes added to the current version of the model.
Original Walkthrough (Based on Older version)
Quick Tutorial on How to Adjust Hold Period
A bit of history behind the progression of this model:
- I first built this model with IRR hurdles only, and then followed up with a companion waterfall model using equity multiple hurdles. After concluding the models were redundant, I converted this model into a combined model with both IRR and equity multiple hurdles. You can toggle between IRR hurdles and Equity Multiple hurdles using the drop-down menu in cell D4 of the ‘Partnership Returns – Annual’ tab.
- Many users have requested the inclusion of a catch-up. This model was not conducive to adding a catch-up so my co-contributor, Michael Belasco, has built his own equity waterfall model with the ability to model catch-up clauses. You can check it out here.
- Another common request we’ve received over the years is to model the waterfall using monthly, rather than annual, periods. Monthly waterfall modeling is common with shorter term, more opportunistic real estate investments. Again, rather than boggin this model down with too many options, I created a separate equity waterfall model with monthly periods.
- In many of my standalone models on A.CRE, I’ve added this equity waterfall model with minor tweaks from one model to the next. For instance, you can find this model included in my Real Estate Portfolio Acquisition Model, as well as in my All-in-One Model.
v1.21 – July 13, 2018
- Added logic to make adjusting hold period more intuitive; simply delete Net Levered Cash Flow from any years not included in the analysis, and those years will no longer appear
- Fixed circular reference in asset management fee input row
v1.20 – June 17, 2018
- Added option to model sponsor fees; can include up to two different sponsor fees (e.g. AUM fee, acquisition/disposition fee)
- Removed reference to USD to better support non-US users
- Renamed tab to ‘Partnership Returns – Annual’, to better reflect purpose of module
- Various formatting improvements
- Revised ‘Error Check’ formula to account for rounding errors
- Simplied hurdle 1 modeling; no longer tracking sponsor capital account
- Improved version tracking
v1.10 – December 29, 2017
- Added option to use Equity Multiple hurdles, rather than IRR hurdles (cell D4)
- Miscallaneous bug fixes
- Added link to waterfall module with monthly periods
About the Author: Born and raised in the Northwest United States, Spencer Burton has over 15 years of real estate investment and development experience. In his current position, Spencer assesses new acquisition, development, and debt opportunities for a $45bn real estate fund. He resides in Dallas, TX.