Waterfall Analysis: How to Calculate Distribution Waterfalls

A distribution waterfall is the sequence of rules that determines who gets paid, in what order, and how much, when a company exits or a fund returns capital. Get the order wrong and a $100M exit pays the wrong stakeholders. This guide shows you how to calculate a distribution waterfall end-to-end, with a worked Series A / Series B example you can replicate in any spreadsheet — or in a dedicated tool when the math outgrows Excel.

What Is a Distribution Waterfall?

A distribution waterfall (also called a waterfall distribution) is a tiered payout structure that allocates exit or fund proceeds across stakeholders in a defined priority order. The two terms are used interchangeably. In venture-backed companies, the waterfall divides sale proceeds among preferred shareholders, common shareholders, and option holders. In private equity funds, it splits realized gains between LPs and GPs through return-of-capital, preferred return, catch-up, and carry tiers.

The metaphor is literal: money pours into the highest tier first, fills it, then overflows into the next tier until proceeds are exhausted. Two practitioners running the same waterfall on the same cap table should get identical numbers — but they often don’t, because liquidation-preference stacks, conversion math, and participation caps create branching logic that compounds quickly.

This article focuses on the company-level exit waterfall: what happens when a startup is acquired and the proceeds need to be split across Series A, Series B, common stock, and an option pool. The same principles apply to fund-level waterfalls, with carried interest replacing liquidation preference as the primary trigger.

Inputs You Need Before You Calculate

A waterfall is only as accurate as the inputs feeding it. Before you touch a formula, gather four things.

1. A Clean Cap Table Snapshot

You need every share, option, warrant, and convertible instrument outstanding as of the exit date. That includes vested-only counts where relevant, the strike price for each option grant, and the security class for every share. A messy cap table modeling input is the most common reason waterfalls disagree across parties — if your captable is stale, the waterfall is wrong before you start.

Capture, at minimum:

• Common shares outstanding
• Each preferred series, with original issue price and shares outstanding
• Vested and unvested options, by strike price
• Warrants, by strike and class
• Any unconverted SAFEs or convertible notes (with their conversion mechanics)

2. Liquidation Preferences

For each preferred series, document the liquidation preference terms. Three variables matter:

• Multiple — 1x is standard; 1.5x or 2x appear in down rounds or distressed financings.
• Participation — non-participating, participating preferred, or capped-participating. This single switch changes the entire waterfall.
• Seniority — pari passu (rank equally) or stacked (later rounds get paid first). Read the Certificate of Incorporation; don’t infer from the term sheet.

3. Conversion Ratios

Each preferred series has a conversion ratio that determines how many common shares it becomes if converted. The default is 1:1, but anti-dilution adjustments from prior down rounds can shift this. The waterfall must compare each preferred series’ “take preference” outcome against its “convert to common” outcome and pick whichever pays the holder more — that’s the core mechanic of convertible preferred stock.

4. Exit Value and Transaction Costs

The exit value is the gross consideration: cash plus stock plus assumed liabilities, net of transaction expenses, escrow holdbacks, and any management carve-out. The number you waterfall is the net distributable proceeds, not the headline acquisition price. Fees and escrows can easily reduce the distributable pool by 5–10% relative to the announced number.

How to Calculate a Distribution Waterfall: Step-by-Step

The calculation has five steps. We’ll walk a concrete example to make it land.

The Setup

A SaaS company is acquired for $120,000,000 in all-cash consideration. Net of $5M in transaction costs and a $5M escrow, $110,000,000 is distributable today. The cap table:

• Common stock: 8,000,000 shares (founders + employees who exercised)
• Series A preferred: 3,000,000 shares, $5M invested, 1x non-participating, $1.667 per share, converts 1:1
• Series B preferred: 2,000,000 shares, $20M invested, 1x non-participating, $10.00 per share, converts 1:1
• Option pool: 1,500,000 vested options, weighted-average strike $0.50

Series A and B are pari passu in seniority for this example. We’ll handle the participating-preferred variant later.

Step 1: Calculate Liquidation Preference Claims

Each preferred series can claim its preference: shares × original issue price × multiple.

• Series A preference: 3,000,000 × $1.667 × 1.0 = $5,000,000
• Series B preference: 2,000,000 × $10.00 × 1.0 = $20,000,000
• Total preference stack: $25,000,000

Since net proceeds ($110M) exceed the preference stack ($25M), there’s room for common to receive distributions. If proceeds were below $25M, common and options would get zero — preferred would split proceeds pro rata within their seniority tier.

Step 2: Test Conversion for Each Preferred Series

Non-participating preferred holders face a choice: take their preference, or convert to common and share pro rata. They take whichever is higher.

To test conversion, calculate the “as-converted common” pool and figure each series’ pro-rata share if they convert.

If both Series A and Series B convert, common-equivalent shares total:

• Common: 8,000,000
• Options (vested, in-the-money): 1,500,000
• Series A as-converted: 3,000,000
• Series B as-converted: 2,000,000
• Total: 14,500,000 fully diluted shares

Per-share value if everyone shares pro rata: $110M ÷ 14,500,000 = $7.586 per share.

For Series B: convert proceeds = 2,000,000 × $7.586 = $15.17M. That’s less than its $20M preference. Series B will take its preference and not convert.

For Series A: convert proceeds = 3,000,000 × $7.586 = $22.76M. That’s more than its $5M preference. Series A converts to common.

This is the conversion math people get wrong most often. Each series tests independently — but the test depends on what other series do, because the as-converted denominator changes. You iterate: assume conversion, recompute, check the assumption still holds. With two preferred series this is easy; with five or six, spreadsheets start to break.

Step 3: Pay the Preference Tier

Series B takes $20M off the top. Remaining proceeds: $110M − $20M = $90M.

Series A doesn’t take a preference (it converted). Options receive their proceeds in Step 4 alongside common.

Step 4: Distribute the Common Pool Pro Rata

The remaining $90M is split among common shareholders, in-the-money option holders (net of strike), and the now-converted Series A.

Common pool denominator (Series B excluded — it took its preference and is done):

• Common: 8,000,000
• Vested options: 1,500,000
• Series A as-converted: 3,000,000
• Subtotal: 12,500,000 shares

Per-share value: $90M ÷ 12,500,000 = $7.20 per share.

Apply that price to each holder, netting strike for options:

In a real waterfall the strike payment is netted against the option’s gross share, and the difference flows back into the common pool, marginally lifting the per-share price. We’ve simplified to keep the worked example readable.

Step 5: Sanity Check the Result

Two checks before you trust the output:

1. Sum check: payouts add to $110M (the net distributable amount). They do.
2. Conversion check: Series A’s converted payout ($21.6M) is greater than its $5M preference. Series B’s preference ($20M) is greater than its converted hypothetical ($15.17M). Both decisions hold.

If a series’ conversion decision flips when you recompute Step 2 with the new pool, you have a circular reference and need to iterate. This is rare with two series, common with five, and the main reason participation caps and stacked preferences are best handled in code.

European vs American Distribution Models

The example above is a single-company exit waterfall. In private equity funds, the same logic applies to each deal — but the question of when GPs collect carry is governed by either a European or American waterfall.

In a European waterfall, carry is calculated at the fund level: LPs receive their capital back plus the preferred return across the entire fund before GPs see any carried interest. In an American waterfall, carry is calculated deal-by-deal, so GPs can earn carry on early winners even if later deals lose money — typically backstopped by a clawback.

For the full breakdown, see European vs American waterfall distribution models. At the company-exit level, the model choice doesn’t apply — there’s only one transaction. But if you’re modeling PE-style structures, get this right early.

Common Pitfalls in Waterfall Calculations

The math is mechanical. The errors are not.

Mixing pari passu with stacked preferences. Term sheets say “pari passu with Series A,” then the COI silently stacks Series C senior to both. Always work from the executed Certificate of Incorporation, not the term sheet.

Treating participating preferred like non-participating. Participating preferred takes its preference and shares pro rata in the residual — sometimes capped, sometimes uncapped. Forget the participation right and you’ll under-pay preferred by tens of percent on mid-size exits.

Ignoring the conversion break-even. There’s an exit value where each non-participating series flips between “take preference” and “convert.” Below it, preferred takes the preference; above it, they convert. With multiple series, break-evens interact — your spreadsheet needs an iterative solver.

Counting unvested options. Unvested options usually accelerate or get cashed out per the merger agreement, but treatment varies. Read the deal docs; don’t assume.

Forgetting the pool top-up. Acquirers often require a pre-closing option pool expansion that dilutes selling stockholders. If the term sheet says “$X equity value, post-money X% pool,” the waterfall input is the pre-pool-expansion count.

Anti-dilution conversion ratio shifts. If a prior down round triggered weighted-average or full-ratchet anti-dilution protection, the conversion ratio is no longer 1:1. Pull the adjusted ratio from the COI.

When a Spreadsheet Stops Working

A two-series, non-participating waterfall fits in Excel. A six-series cap table with stacked seniority, two participating-preferred classes with different caps, anti-dilution-adjusted conversion ratios, and an unconverted SAFE doesn’t — at least not without circular references and IFERROR wrappers that nobody trusts six months later.

The signs you’ve outgrown a spreadsheet:

• You can’t explain to a counterparty why a number changed when an input moved
• Conversion decisions cascade across two or more iterations
• Participation caps interact with seniority tiers
• You need a MOIC by holder and by class, alongside the waterfall

Waterfalls.app is built for this — model complex preference stacks, test exit values across a range, and share auditable outputs with founders, investors, and counsel. Start with your existing cap table; the tool walks the conversion logic and surfaces break-evens automatically. If you’re building a spreadsheet right now and second-guessing your conversion math, that’s the moment to switch.

Frequently Asked Questions

How do I model an exit using a distribution waterfall?

Start with a clean cap table, document liquidation preference terms for each preferred series, then walk five steps: calculate the preference stack, test conversion for each non-participating series, pay preferences for series that don’t convert, distribute the residual pro rata to common (plus converted preferred and in-the-money options), and sanity-check with sum and conversion tests. The hardest step is the conversion test, because each series’ decision depends on what others do — iterate until decisions stop changing.

What’s the difference between European and American waterfalls?

European waterfalls calculate carried interest at the fund level — LPs must be made whole across the entire fund before GPs earn carry. American waterfalls calculate deal-by-deal, letting GPs earn carry on winning investments even before the fund as a whole is profitable, typically with a clawback if later deals underperform. The full comparison is in our European vs American waterfall distribution models breakdown.

Do convertible preferred stockholders take part of the common distribution?

Only if they convert. Non-participating convertible preferred holders choose between taking their liquidation preference or converting to common and sharing pro rata — they get whichever pays more, but not both. Participating preferred holders take their preference and share in common pro rata, which is why participation rights are negotiated hard.

What triggers conversion in the waterfall?

A non-participating preferred series converts to common voluntarily when the as-converted pro-rata payout exceeds its liquidation preference. There’s also forced (mandatory) conversion at IPO and forced conversion above contractual thresholds — but inside an exit waterfall, conversion is purely an optimization: each holder picks the higher number.

How does a participation cap work?

A participation cap puts an upper bound on what participating preferred can collect via the participation right. With a 3x cap, the holder takes its 1x preference plus pro-rata participation, but stops collecting once total proceeds reach 3x its original investment. Above that point, the holder is better off converting to common — so capped participating preferred has three potential outcomes (preference only, preference + capped participation, or convert) and the waterfall picks the best.

What’s a liquidation preference waterfall vs a distribution waterfall?

A liquidation preference waterfall is a specific case of a distribution waterfall where the priority rules are driven by liquidation-preference terms in a startup’s preferred stock. A distribution waterfall is the broader category — it includes private equity fund waterfalls (LP capital → preferred return → catch-up → carry), real estate joint-venture waterfalls, and similar tiered-payout structures. Same mechanic, different tiers.

Can I run a waterfall analysis in Excel?

Yes, for simple structures — two or three preferred series, all non-participating, pari passu seniority. As soon as you add stacked seniority, participation caps, or anti-dilution-adjusted conversion ratios, Excel becomes fragile. Iterative conversion logic in particular tends to introduce circular references that mask errors. Move to a dedicated tool once your conversion decisions cascade across multiple series.