Waterfall Analysis: Meaning, Types, Examples and Applications in Finance

Waterfall analysis is a method of showing how a starting value moves, step by step, to a final value — and who or what absorbs the difference at each stage. In finance it most often answers one question: when a company is sold, how are the proceeds actually distributed among preferred investors, common shareholders and option holders?

The term is used in three different fields, which is a common source of confusion. This guide covers the two that matter in finance and business.

The Three Things People Mean by "Waterfall"

If you are here for the software development lifecycle, this is not that article. Everything below is financial.

What a Waterfall Chart Shows

A waterfall chart — also called a bridge chart, cascade chart or waterfall diagram — displays a starting column, a series of floating increases and decreases, and an ending column. The floating bars make it immediately visible which drivers added value and which consumed it.

Because it isolates each step, the format has become standard in board packs and management reporting. Waterfall reports built on this structure are used to explain budget variances, margin movement and revenue bridges in a single view, without requiring the reader to reconcile two separate tables.

The chart is a presentation layer. The analysis underneath it is where the real work happens.

Types of Waterfall Analysis

The first is a legal and contractual calculation. The other three are performance diagnostics. They share a visual language but answer different questions.

Distribution Waterfall: A Worked Example

This is where waterfall analysis carries the most financial consequence, so it is worth walking through with actual numbers.

Assume the following capital structure:

The total preference stack is $20 million. That figure is the first thing to calculate, because common shareholders receive nothing until it is cleared.

Scenario 1: Exit at $18 million

Series B holds the senior preference and takes its $15 million first. That leaves $3 million, which goes to Series A against its $5 million preference. Series A is short by $2 million.

Common owns half the company on paper and receives nothing. This is the outcome founders most often fail to anticipate.

Scenario 2: Exit at $40 million

Each preferred class now compares two options: take the preference, or convert to common and share pro rata.

Series B converting would yield 30% of $40 million, or $12 million — less than its $15 million preference. It takes the preference. After that, $25 million remains.

Series A converting would give it 2,000,000 of the 7,000,000 shares sharing that residual, or roughly $7.14 million — more than its $5 million preference. It converts.

Scenario 3: Exit at $120 million

Both classes are better off converting, and the waterfall collapses into a straight pro-rata split.

Reading the Breakpoints

The three scenarios reveal the thresholds that define this cap table:

• $20 million — the point at which the preference stack is cleared and common begins to participate

• $32.5 million — the point above which Series A prefers conversion to its preference

• $50 million — the point above which Series B prefers conversion

These breakpoints are not incidental. They are the same inputs that drive an Option Pricing Model in a 409A valuation, which is why a defensible waterfall is a prerequisite for defensible equity compensation.

Participating vs Non-Participating Preferred

The example above assumes non-participating preferred, where an investor chooses between the preference and conversion. Participating preferred allows both.

At the same $40 million exit, if Series B held 1x participating preferred it would receive its $15 million preference and 30% of the remaining $25 million — $22.5 million in total, rather than $15 million. That additional $7.5 million comes directly out of what Series A and common receive.

A single word in a term sheet moves eight figures.

Seniority: Stacked vs Pari Passu

Seniority determines the order in which preferences are paid, and it changes outcomes materially in downside scenarios.

Under a stacked structure, later rounds are paid first — Series B before Series A. Under pari passu, all preferred classes rank equally and share proportionally if proceeds are insufficient to cover the full stack.

Applying pari passu to Scenario 1 above, the $18 million would be split 75/25 between Series B and Series A in proportion to their $15 million and $5 million preferences, giving Series B $13.5 million and Series A $4.5 million — a materially different result from the stacked outcome.

The Fund Waterfall in Private Equity

Private equity and venture funds use the same term for a different calculation: how a fund distributes returns between its limited partners and its general partner. A standard structure pays capital back to LPs first, then a preferred return or hurdle, typically 8%, then a catch-up allocation to the GP, and finally an 80/20 split of remaining profit as carried interest.

The distinction that matters is whether the fund operates a deal-by-deal waterfall, where carry is calculated on each investment as it exits, or a whole-fund waterfall, where carry is only paid once the entire fund has returned capital. Deal-by-deal pays the GP earlier and usually requires a clawback provision. The mechanics are separate from a company-level exit waterfall, but a portfolio company's distribution feeds directly into it.

Revenue, Gross Margin and Price Waterfalls

The same visual structure supports three widely used operational analyses.

Revenue waterfall analysis bridges opening to closing revenue across new business, expansion, contraction and churn. For subscription businesses it isolates whether growth is being driven by acquisition or by retention.

Gross margin waterfall analysis explains why margin moved between periods, separating volume, price, input cost and product mix. Two companies can report an identical margin decline for entirely different reasons, and only the bridge distinguishes them.

Price waterfall analysis traces list price down to pocket price through every discount, rebate, allowance and payment term. It routinely surfaces revenue leakage that headline pricing conceals, which is why it is a standard component of commercial due diligence.

Building a Waterfall Chart

In Excel, waterfall is a native chart type — select the data series and insert it directly. Older versions require a stacked bar chart with an invisible base series to create the floating effect.

A waterfall chart in Power BI is available as a standard visual. Assign the movement dimension to Category, the measure to Y Axis, and use the Breakdown field to decompose the change by driver. Power BI waterfall visuals handle variance analysis particularly well because the breakdown updates dynamically with report filters.

For distribution waterfalls, a chart alone is insufficient. Spreadsheet models become difficult to maintain once a cap table includes multiple preference classes, participation caps, warrants, convertible instruments and unvested options, and the errors they produce are not visible in the chart.

What Investors and Auditors Examine

A waterfall presented in a financing or transaction is reviewed against source documents. Reviewers typically check:

• Preference amounts and multiples against executed charter documents

• Seniority, and whether classes are genuinely stacked or pari passu

• Participation rights and any caps

• Treatment of convertible notes and SAFEs, and whether conversion occurs pre- or post-money

• Option pool treatment, including unvested and out-of-the-money options

• Consistency with the assumptions used in the most recent 409A valuation

Discrepancies between a waterfall and the governing documents are among the more common findings in equity diligence, and they typically surface at the least convenient moment.

Get Your Waterfall Modeled Correctly

A waterfall is only as reliable as the documents behind it. AcumenSphere builds distribution waterfalls, cap table models and equity allocation analyses that hold up through investor diligence, audit review and 409A scrutiny.

If you are approaching a financing, an exit, or a valuation refresh, contact our team to review your capital structure and model the scenarios that matter.