5-Tier IRR and Equity Multiple Hybrid Waterfall Model
A free Excel equity waterfall model for real estate private equity deals, with five tiers gated on two tests at once. A tier only promotes when both the IRR hurdle and the equity multiple threshold are cleared, which protects the limited partner on deals where IRR alone can look stronger than the dollars actually returned.
What’s inside
Model Features
Five Distribution Tiers
Each tier carries its own IRR hurdle and its own equity multiple threshold.
Dual-Test Gating
Both tests must clear before a tier's promote split applies. If either one fails, distributions stay at the prior tier's split.
Return of Capital
Contributed equity is returned in full before any profit is split.
Preferred Return Accrual
Tracks the preferred return as it accrues and is paid down.
GP Catch-Up Tier
Brings the general partner up to its full negotiated share of profit once the preferred return is satisfied, before the promote tiers begin.
Tiered Promote Splits
Every split is an input, so the structure can be re-cut without rebuilding the logic.
Cash Flow Driven
Accepts a distributable cash flow stream and runs the full waterfall against it.
Returns Reported at Every Tier
IRR, equity multiple, and total dollars for the limited partner and the general partner at each level.
Live Excel Formulas
Nothing is hardcoded or locked. Every cell is traceable.
Why two tests
How the Dual Test Works
IRR is sensitive to time and equity multiple is not. A deal that exits early can clear a 15 percent IRR hurdle while returning well under 1.5x, and a deal that holds longer can return 2.0x while missing that same hurdle. A single-test waterfall pays promote in one of those cases and not the other, which is rarely what either party intended when the structure was negotiated.
Gating each tier on both tests means the general partner earns the higher split only when the deal has performed on speed and on size. If your structure uses IRR hurdles alone, use the 4-Tier IRR GP Catch-Up Waterfall or the 4-Tier IRR Pari Passu Waterfall instead.
How it works
How an IRR and Equity Multiple Waterfall Works
An equity waterfall, also called a distribution waterfall, sets the order in which a real estate deal's cash flow is paid to the limited partner (LP) and the general partner (GP). In a hybrid waterfall each promote tier has two hurdles instead of one. As an example of how the tiers can be set:
- 01
Return of Capital, Preferred Return and Catch-Up
Equity comes back first, then an 8 percent preferred return, then the GP catch-up.
- 02
Tier 2
The GP earns a 20 percent promote once the LP has cleared both a 12 percent IRR and a 1.40x equity multiple.
- 03
Tier 3
30 percent once the LP clears 15 percent and 1.75x.
- 04
Tier 4
40 percent once the LP clears 18 percent and 2.00x.
- 05
Tier 5
50 percent on cash above the final hurdles.
Every hurdle and split is an input. The model shows which test is binding at each tier, along with each partner's dollars, IRR and equity multiple.
Who it’s for
Who Uses This Model
Institutional LPs and family offices that want promote tied to dollars returned as well as speed, CRE firms and developers negotiating JV terms with those investors, and analysts modeling deals where an early sale or refinance could otherwise trigger promote on a modest multiple.
Questions
Frequently Asked Questions
What is an equity multiple hurdle in a real estate waterfall?
An equity multiple hurdle requires the LP to receive a set multiple of its invested capital, for example 1.5x, before the GP's promote increases. Unlike IRR, the equity multiple does not depend on how quickly the money comes back.
Why use both IRR and equity multiple hurdles?
IRR rewards speed and the equity multiple rewards size. A quick exit can clear an IRR hurdle on a small profit, and a long hold can produce a strong multiple while missing the IRR hurdle. Requiring both means the GP earns the higher promote only when the deal has performed on both measures.
Does this model include a GP catch-up?
Yes. A catch-up tier follows the preferred return and brings the GP up to its negotiated share of profit before the promote tiers begin. Its percentage is an input.
Is this private equity waterfall model really free?
Yes. Enter your name and email and the Excel template downloads with live formulas. Nothing is locked or hardcoded.
Can Reina Property Group build a waterfall to match our operating agreement?
Yes. RPG's investment team builds custom waterfalls, development models and acquisition models for CRE firms, and can review proposed JV terms before they are signed.
Custom models
Need a Waterfall Built to Your Operating Agreement?
Free templates cover standard structures. When your deal has its own hurdles, fees, clawbacks or partner splits, Reina Property Group's investment team builds the model to match the documents. See our real estate financial modeling services, or, if you are raising LP or JV equity for the deal, our capital raising advisory. More free templates are in the model library.
Free download
Download the Model
Enter your name and email below and the Excel file is yours. Live formulas, nothing locked.