pencil·pencil·pencil

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.

GetKin Labs · Fund Economics

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.

Capital structure
Waterfall terms
Deal cash flows
Order of distributions each year: accrued preferred (pro rata) → return of capital (pro rata) → tier 1 split until LP IRR reaches the hurdle → tier 2 split above it. GP co-invests pari passu.
Limited partners
13.3%
IRR
1.77x
Multiple
Capital invested$900,000
Total distributions$1,593,236
Profit$693,236
General partner / sponsor
28.4%
IRR on co-invest
3.25x
Multiple
Co-investment$100,000
Co-invest returns$191,855
Promote / carried interest$133,458
co-invest 59%promote 41%
Distributions by waterfall tier
Annual distribution ledger
YrCashPrefROCTier 1Tier 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
Unpaid preferred compounds annually and carries forward until cash is available.
Models a common LP/GP structure with annual periods and pari passu co-investment; actual operating agreements vary (catch-up provisions, lookbacks, clawbacks, monthly periods). Verify against your legal documents — this is not investment or legal advice.

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.

Assumptions: annual periods, GP co-invests pari passu, two promote tiers, no GP catch-up or clawback. Real operating agreements vary — verify against the actual legal documents before circulating numbers to investors.

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.