Cap Table Waterfall & Exit Scenario Simulator
Seed: Cap table (share classes, percentages, liquidation preferences), exit scenarios table (enterprise value); core formula: =IF(TermPref>0,MIN(TermPref,EV),...)ADVERTISEMENT - IN-ARTICLE
Implementation Guide
Model for cap table outcomes under multiple exit scenarios: waterfall allocations, liquidation preferences, participating vs non-participating rules, option pool impact, and IRR per investor. Produces per-scenario outputs (payoffs, ownership post-exit), waterfall charts, and sensitivity toggles for pool size and new-money terms. Useful for finance teams advising leadership on dilution, stakeholder returns, and scenario-driven valuations. Includes a clean audit trail mapping input assumptions to outputs for board pack inclusion.
💡 Expert Q&A Insights
Q: \
Can it model convertible notes with caps?\" \"
Q: Yes—include note terms and conversion logic to choose between cap- or discount-based conversions at exit.\"\n\"
How to show founder dilution?\" \"