5-Tier IRR-EM Hybrid Waterfall Model
A five-tier equity waterfall 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.
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.
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.