How to Model a Startup Exit Waterfall: A Step-by-Step Guide for Indian Founders

An exit waterfall is a calculation that distributes the proceeds from a company's sale or acquisition among its shareholders, in the order determined by each shareholder's rights and preferences. For Indian startups that have raised institutional funding through CCPS, the waterfall involves multiple layers: preference payouts, participation distributions, conversion decisions, and common equity allocations.

Modelling the waterfall before a funding round, rather than after, gives founders an accurate picture of how proposed preference terms affect each stakeholder's payout across different exit scenarios. This post explains what inputs the model needs, how to calculate each layer, and what the output should tell you.

What an Exit Waterfall Model Is

An exit waterfall model shows, at a given exit price, how much each class of shareholder receives. The model runs through the distribution in a defined sequence, applying each shareholder's rights in turn, until the total proceeds are allocated.

For a company with multiple rounds of CCPS, an ESOP pool, and founders holding equity shares, the waterfall typically has these layers:

1. Outstanding debt and transaction costs
2. CCPS preference payouts (in pari-passu or stacked order)
3. Participation distributions (for any CCPS carrying participating rights)
4. Conversion decisions (each CCPS series checks whether converting to common equity yields more)
5. Common equity distribution to remaining shareholders

Run the model across multiple exit values and you produce a scenario table: a complete picture of how each stakeholder's payout changes across conservative, base, and optimistic exit assumptions.

Step 1: Gather Your Inputs

The model is only as accurate as its inputs. Collect the following from your cap table records and each investor's SHA before building anything.

From the cap table:

• Total shares outstanding on a fully diluted basis, including all CCPS on an as-converted basis, all ESOP shares (granted vested, granted unvested, and ungranted), and all warrants
• Each investor's CCPS series: number of shares, issue price per share, and total investment amount
• Each investor's ownership percentage on a fully diluted, as-converted basis
• Founders' equity shares and ownership percentage
• ESOP pool breakdown: granted and ungranted

From each investor's SHA and CCPS terms:

• Preference multiple (1x, 1.5x, 2x, etc.)
• Participation rights: non-participating, participating uncapped, or participating with a specific cap multiple
• Seniority structure: pari-passu or stacked, and if stacked, the order among series
• Current conversion ratio (may differ from 1:1 if anti-dilution adjustments have been triggered)
• Conversion rights and trigger events

Your exit scenarios: Choose at least three values. A conservative case (roughly 2x to 3x the last post-money valuation), a base case (5x to 7x), and an optimistic case (10x to 15x). The purpose of multiple scenarios is to see how the waterfall behaves across the realistic range, not to predict a single outcome.

Step 2: Deduct Debt and Transaction Costs

Before any equity distribution, outstanding debt and transaction costs are settled from the gross exit proceeds.

Net Proceeds = Gross Exit Value - Outstanding Debt - Transaction Costs

Transaction costs in Indian M&A typically include investment banker fees, legal costs, and escrow holdbacks. These commonly run 1% to 3% of total deal value. Model on net proceeds, not gross.

If the company has no outstanding debt and you are in early stages, this step produces a simple deduction for legal and advisory costs.

Step 3: Calculate Preference Payouts

Each investor's preference payout is:

Preference Payout = Investment Amount × Preference Multiple

Sum the preference payouts across all CCPS series. This is your total preference pool.

If the seniority structure is pari-passu: All preference holders are paid simultaneously and proportionally from the net proceeds. If net proceeds exceed the total preference pool, each investor receives their full preference amount. If net proceeds are less than the total preference pool, each investor receives a pro-rata share of what is available:

Each investor's payout = Their preference amount / Total preference pool × Net proceeds

If the seniority structure is stacked: Pay out in order of seniority. The most senior series (typically the latest round) receives its full preference first. Whatever remains is available for the next series. Continue until either all preferences are paid or net proceeds are exhausted.

Common shareholders receive nothing if net proceeds are fully absorbed by preference payouts.

Step 4: Distribute Participation (If Applicable)

If any CCPS series carries participating rights, the participating investors receive a pro-rata share of the remaining proceeds after their preference payout.

For each participating series:

Participation Payout = Remaining Proceeds × Investor Ownership Percentage (as-converted, fully diluted)

If the participation is uncapped: The investor takes their pro-rata share of whatever remains. There is no ceiling.

If the participation is capped: Compare the uncapped participation amount to the cap (typically a multiple of the investment, such as 2x total). The investor receives the lower of the two. Once the cap is reached, participation stops.

After all participation distributions, recalculate the remaining proceeds available for common equity.

Step 5: Check Conversion Optionality for Each CCPS Series

Before finalising the waterfall, check whether any CCPS series is better off converting to common equity than taking the preference and participation route.

For each CCPS series:

As-converted equity value = Investor's as-converted ownership percentage × Total net proceeds

Compare this to the investor's total from preference + participation.

If the as-converted equity value is higher, the investor converts. This means:

• Their preference obligation is removed (they do not receive the preference payout)
• They join the common equity pool as equity shareholders
• The remaining proceeds available for common equity increase (because their preference is not deducted)
• But the common equity pool is now shared among more total shares (because their converted shares are added)

After checking all CCPS series for conversion optionality, recalculate the remaining proceeds and the total common equity share count with any converted investors included.

Step 6: Distribute Remaining Proceeds to Common Equity

After all preferences, participation distributions, and conversion decisions are resolved, the remaining proceeds flow to common equity shareholders in proportion to their ownership on a fully diluted basis.

Common equity shareholders include:

• Founders (holding equity shares)
• ESOP holders (holding exercised equity shares)
• CCPS holders who have converted to common equity

For ESOP holders: Proceeds per ESOP share equal the per-share common equity value minus the exercise price. If the per-share value from the waterfall is below the exercise price, those options are out of the money. ESOP holders in this position receive nothing. This is the option overhang problem: high exercise prices make ESOP economically worthless even in a successful acquisition if the waterfall has absorbed too much of the proceeds above the exercise price level.

Step 7: Build the Scenario Table

Run the waterfall calculation across your three exit scenarios. Produce a single table showing each stakeholder's payout at each exit value.

This table serves several purposes. It shows the minimum exit value at which founders receive meaningful proceeds. It shows where the waterfall becomes more equitable as exit values increase. And it shows the specific rupee value of any term change, such as moving from uncapped participating to a 2x cap or from stacked to pari-passu preferences.

Running the table twice: once under proposed new round terms and once under a negotiated alternative, quantifies exactly what you are negotiating for.

Common Modelling Mistakes

Using pre-adjustment ownership percentages. If anti-dilution adjustments have been triggered by a down round, the investor's as-converted ownership percentage has changed. Always use the current adjusted conversion ratio to calculate ownership percentages, not the original 1:1 ratio from the time of investment.

Ignoring ESOP exercise prices. ESOP holders do not receive their gross per-share proceeds. They pay the exercise price and receive the net amount. A model that ignores exercise prices overstates ESOP proceeds, sometimes significantly.

Modelling gross proceeds rather than net. Transaction costs and any outstanding debt reduce the amount available for equity distribution. Model on net proceeds after these deductions.

Only modelling the base case. The base case is where everything works as planned. The conservative case is where the preference stack does its most significant work. Both matter for a complete picture.

Running the model after signing the term sheet. The exit waterfall should be modelled before the term sheet is signed. That is when the preference terms, seniority structure, and participation rights are still negotiable. The model is a negotiating input, not just an informational output.

When to Use a Platform vs a Spreadsheet

A basic exit waterfall with one or two CCPS rounds and no anti-dilution adjustments is achievable in a spreadsheet in a few hours. The formulas are not complex; the challenge is accuracy in the inputs.

A multi-round cap table with stacked preferences, different participation rights across series, anti-dilution adjustments, and a large ESOP pool takes significantly longer to model accurately in a spreadsheet and is prone to formula errors. At this level of complexity, purpose-built cap table tools produce more reliable outputs and allow faster scenario testing.

The test for either approach is the same: can you clearly trace where every rupee of the exit proceeds goes, for every stakeholder, at every exit value you test? If not, the model has a gap.

Frequently Asked Questions

How long does it take to build an exit waterfall model? For a simple cap table with one CCPS round and no anti-dilution adjustments, a basic model takes two to three hours in a spreadsheet. For a multi-round cap table with stacked preferences, participation rights, and anti-dilution adjustments, a reliable model takes a full day. Purpose-built tools automate the calculation once inputs are correctly entered.

Do I need a lawyer to build an exit waterfall model? No. The waterfall is a financial model, not a legal document. You do need someone to translate the SHA terms accurately into model inputs: preference multiples, participation rights, cap amounts, and conversion ratios. Misreading the SHA language and entering incorrect inputs produces a model that looks correct but calculates the wrong outcomes.

Should I share the waterfall model with investors during a negotiation? Sometimes. A model that shows how a participation cap works in an investor's favour at modest exits while protecting founders at larger exits can be a useful tool for framing the negotiation around numbers. Sharing a model that exposes the full preference stack may also give new investors additional negotiating leverage. Use judgment based on the specific negotiation context.

What is the dead zone in an exit waterfall? The dead zone is a range of exit values at which a preference holder's payout does not change regardless of whether the exit price is at the low or high end of that range. This occurs with non-participating preferred at values between the preference amount and the conversion threshold. Within this range, the investor receives the same amount, creating a period of incentive misalignment: the investor has no financial incentive to push for a higher exit price within the dead zone.

Conclusion

An exit waterfall model converts the abstract terms in a term sheet into concrete rupee outcomes for every stakeholder at every exit value. It makes the cost or benefit of any specific clause visible before it is agreed.

Founders who model the waterfall before each term sheet negotiation go into those conversations with a clear picture of what is at stake. The model does not change the negotiation. It makes it easier to have the right one.