# Exit Waterfall Model Build an exit waterfall model that traces sale proceeds through stacked liquidation preferences, participation rights, conversion decisions, option holders, and management carve-outs so you can see exactly who gets paid at each exit valuation. - Canonical: https://finamodel.com/templates/exit-waterfall-model - Excel download: https://finamodel.com/templates/exit-waterfall.xlsx - Category: Corporate Finance - Model type: Valuation - Difficulty: Advanced - Audiences: Fund managers, Bankers & advisors, Founders, Investors, M&A advisors, Corporate development - Tags: exit, waterfall, m&a, liquidation, proceeds ## Overview An exit waterfall model allocates M&A or IPO proceeds through the cap table according to liquidation preferences. When a startup worth $500 million exits, the proceeds are distributed first to pay off debt (with accrued interest), then to preferred stockholders according to their liquidation preference (non-participating, participating, or capped multiple), and finally to founders and common stockholders. The model is essential because a common founder assumption - "I own 20% of the company, so I get 20% of proceeds" - is often catastrophically wrong if preferred investors have 1x, 2x, or capped multiple liquidation preferences. The workbook shows the per-founder economics across different exit values: how much does a founder receive at $200 million versus $1 billion? It highlights scenarios where junior investors receive zero (underwater rounds). Sensitivity analysis shows the impact of different exit values and down-round scenarios on founder and early investor returns. The model accounts for transaction costs (investment banking fees, legal, taxes) that reduce net proceeds available for distribution. This template is standard for venture boards, angel investors, and founders during exit negotiations - where clarity on who gets what is non-negotiable. ## What's included - Seniority-aware preference stack across seed, Series A, Series B, and later rounds - Participating preferred versus common conversion logic by shareholder class - Proceeds distribution by investor, founder, employee option pool, and other stakeholders - Scenario testing across low, mid, and high exit values to show breakpoints in payout outcomes - Visibility into preference overhang, common participation, and effective take-home by group - Transaction proceeds and transaction costs (fees, taxes) - Debt payoff with accrued interest - Preferred stock liquidation preferences: non-participating, participating, multiple - Distribution order: senior to junior tranches - Per-share and per-founder economics - Sensitivity to exit valuation and down-round scenarios ## Exit Waterfall Model: How the Template Allocates Exit Proceeds This exit waterfall model template helps you allocate M&A or IPO proceeds across a startup cap table. It handles multi-class equity, liquidation preferences, participation caps, anti-dilution, SAFE and note conversion, warrants, and transaction fees. The public download is a values-only preview, but the underlying model captures the full distribution logic for evaluating who gets paid at each exit valuation. ### Operating Drivers and Assumptions The model is driven by inputs on the Assumptions sheet, including a cap-table snapshot, deal terms for each priced round, SAFE and convertible-note slots, anti-dilution toggle, transaction parameters, tax settings, and exit scenarios. Each priced round has a seniority rank, liquidation preference multiple, participation cap, warrant coverage, and investor name. - Seniority defaults to reverse-vintage, with Series E most senior and Seed most junior, and pari-passu handling when ranks tie. SAFE and note conversion depends on seed price, discount, valuation cap, or accrued interest. - These drivers feed the Waterfall and Returns sheets. ### Calculation Flow Through the Distribution Chain The Waterfall sheet processes seven exit scenarios through a defined chain. It starts with gross proceeds, subtracts debt payoff and transaction fees to arrive at available proceeds. - Then it walks seniority tiers from most to least senior, paying each class its liquidation preference where funds allow. For participating classes, payout is the lesser of paid preference plus pro-rata share of remainder, or the cap multiple times invested capital. - The model performs a conversion election, converting to common when as-converted pro-rata exceeds the capped payout. A distribution check ensures total payouts equal available proceeds. Anti-dilution adjustments and SAFE or note conversions are applied on the Cap_Table before the waterfall. ### Outputs and Diagnostic Reports The Waterfall sheet outputs per-class distributions and a totals row with a check. A 'Cap Triggered?' - diagnostic row flags classes hitting participation caps per scenario, and a stack-underwater diagnostic highlights when total liquidation preferences exceed available proceeds. The Returns sheet reports MOIC and gain or loss by class, plus pre- and post-tax founder payouts, with a split between common and preferred. - Founder net-of-tax block incorporates QSBS eligibility, LTCG rate, and exclusion cap. Investor-name labels customize cap-table and returns labels. These outputs support exit-negotiation analysis. ### Practical Use and Documented Limitations This template is designed as a board-ready exit-negotiation tool. - It helps stakeholders compare outcomes across exit valuations and capital structures. - Users should note documented limitations: the conversion election uses a single-shot approach, which may show small mismatches on aggressive stacks where multiple classes interact; anti-dilution adjustments apply only against the immediately-following round; and SAFE conversion uses a post-ESOP fully-diluted denominator excluding SAFE shares. - The model includes checks for distribution consistency and named-range errors, but the public download is a values-only preview and does not recalculate. ## Built for preference stacks that change the story Use this structure when headline enterprise value is not enough and the real question is how much of the exit actually flows to founders, employees, and each investor class after preferences are paid. ## Focused on conversion thresholds and payout breakpoints A proper exit waterfall model should show when preferred investors stay in their preference, when they convert to common, how participation caps bite, and where the proceeds split shifts materially as exit value increases. ## Better for board, fundraising, and exit negotiations This gives you a clearer basis for discussing term sheet implications, management expectations, and sale scenarios because it makes the economic consequences of each preference term visible rather than implied. ## Built for preference stacks that change the story Use this structure when headline enterprise value is not enough and the real question is how much of the exit actually flows to founders, employees, and each investor class after preferences are paid. ## Focused on conversion thresholds and payout breakpoints A proper exit waterfall model should show when preferred investors stay in their preference, when they convert to common, how participation caps bite, and where the proceeds split shifts materially as exit value increases. ## Better for board, fundraising, and exit negotiations This gives you a clearer basis for discussing term sheet implications, management expectations, and sale scenarios because it makes the economic consequences of each preference term visible rather than implied. ## Workbook structure ### Cap Table Inputs This sheet captures the ownership stack and rights that determine how proceeds are distributed on exit. - Ownership by shareholder class - Preference terms by round - Participation and conversion setup - Starting point for waterfall logic ### Preference Stack The preference stack sheet applies seniority and liquidation rights before any common proceeds are distributed. - Stacked liquidation preferences - Round seniority ordering - Preference claims by class - Economic rights before conversion ### Conversion Logic This sheet shows when preferred holders stay in their preference or convert to common under different exit values. - Conversion threshold logic - Participating versus non-participating treatment - Cap behaviour where relevant - Breakpoints that change payout outcomes ### Proceeds Output The output sheet summarises who gets paid under different exit values so negotiations can be grounded in real economics. - Proceeds by stakeholder group - Low, base, and high exit scenarios - Founder, employee, and investor take-home - Clear waterfall outcome summary ### Cap Table Inputs This sheet captures the ownership stack and rights that determine how proceeds are distributed on exit. - Ownership by shareholder class - Preference terms by round - Participation and conversion setup - Starting point for waterfall logic ### Preference Stack The preference stack sheet applies seniority and liquidation rights before any common proceeds are distributed. - Stacked liquidation preferences - Round seniority ordering - Preference claims by class - Economic rights before conversion ### Conversion Logic This sheet shows when preferred holders stay in their preference or convert to common under different exit values. - Conversion threshold logic - Participating versus non-participating treatment - Cap behaviour where relevant - Breakpoints that change payout outcomes ### Proceeds Output The output sheet summarises who gets paid under different exit values so negotiations can be grounded in real economics. - Proceeds by stakeholder group - Low, base, and high exit scenarios - Founder, employee, and investor take-home - Clear waterfall outcome summary ## Features - **Liquidation preference modeling:** Support non-participating, participating, and capped participating preferences to show holder outcomes accurately. - **Multi-round cap table:** Model Series A, B, C proceeds and preferences to show distribution order in exit. - **Tax and transaction cost deductions:** Deduct fees, legal, accounting, and estimated tax liability before distributing proceeds. ## Use cases - **Investment decision and term sheet evaluation:** Show investor returns under multiple exit scenarios (IPO, strategic sale, low exit). - **Employee option and retention incentives:** Demonstrate to employees their likely proceeds at different exit values to justify equity packages. - **M&A process and purchase price negotiation:** Model allocation of purchase price to holders to validate deal attractiveness to all parties. ## Frequently asked questions ### What is an exit waterfall model? It is a model that shows how sale proceeds are distributed across equity holders, preferred investors, and other stakeholders. ### Why is it important? Because liquidation preferences and participation rights can materially change founder and investor outcomes. ### What should an exit waterfall model include? It should include preference stacks, participation rules, conversion logic, and proceeds distribution by stakeholder. ### Who uses exit waterfall models? Founders, investors, legal advisers, and finance teams use them when exit proceeds may be complex to interpret. ### When is this most useful? It is especially useful when multiple rounds of preferred equity or participation rights make outcomes hard to estimate intuitively. ## Related templates - [Cap Table Management Model](https://finamodel.com/templates/cap-table-model) - [Leveraged Buyout Model](https://finamodel.com/templates/lbo-model) - [Preferred Equity Waterfall Model](https://finamodel.com/templates/preferred-equity-waterfall-model)