pencil·pencil·pencil / tools
Equity Waterfall Modeler
Model LP/GP distributions the way operating agreements actually read: preferred return that compounds when unpaid, capital returned pro rata, and promote tiers that switch on real LP IRR hurdles — period by period, not a shortcut on totals.
Equity Waterfall Modeler
Period-by-period distributions with compounding preferred return, return of capital, and IRR-hurdle promote tiers — the math your LPs will check.
| Yr | Cash | Pref | ROC | Tier 1 | Tier 2 | → LP | → GP |
|---|---|---|---|---|---|---|---|
| 1 | $60,000 | $60,000 | · | · | · | $54,000 | $6,000 |
| 2 | $61,800 | $61,800 | · | · | · | $55,620 | $6,180 |
| 3 | $63,654 | $63,654 | · | · | · | $57,289 | $6,365 |
| 4 | $65,564 | $65,564 | · | · | · | $59,007 | $6,556 |
| 5 | $1,667,531 | $164,794 | $1,000,000 | $338,186 | $164,551 | $1,367,320 | $300,211 |
Why period-by-period matters
Most free waterfall calculators apply the tier splits to total profits at the end — which quietly misprices the preferred return and overstates or understates the promote, sometimes by six figures on a mid-size deal. This model distributes each year's cash in sequence: accrued pref first (compounding annually when unpaid), then return of capital, then the tier-one split until the LP's actual IRR reaches the hurdle, then tier two above it. That's how the lawyers wrote it, so that's how the math should run. Promote structures explained.
Reading the output
The LP card answers an investor's question: what do I earn and when does my capital come back. The GP card answers the sponsor's: how much of my income is co-invest return versus promote — the carried interest earned by outperforming the hurdle. The annual ledger shows every dollar's path through the tiers, which is exactly the table to drop into an investor deck.
Waitlist
Pro is coming
PDF exports, saved deals, and shareable links — $29/mo when it ships. Leave an email and you’ll get launch pricing.
No spam, no sharing — one email when Pro launches.