Venture Capital & Startup Cap Tables
VC Participating vs Non-Participating Preference Formula
Calculate Venture Capital exit payouts under 1x Non-Participating Preferred versus Capped Participating Preferred MIN(W, MAX(alpha*W, MIN(Cap, Pref + alpha*MAX(0, W - Pref)))) across all four exit zones.
Quantify the exact founder cost of "double-dip" participating preferred stock!
Two Venture Capital term sheets at the exact same $40M post-money valuation ($10M invested for alpha = 25.0% ownership) split M&A proceeds very differently! Under standard 1x Non-Participating Preferred, the VC chooses EITHER its Liquidation Preference Pref = m_pref * I_inv OR converting to alpha * W_exit common shares: Payout_NP = MIN(W_exit, MAX(Pref, alpha * W_exit)), converting cleanly above Conversion Threshold W_conv = Pref / alpha = $40.00M! Under Participating Preferred ("double-dip") with Participation Cap Multiple m_cap (say 3x = $30M), the VC takes Pref FIRST AND ALSO takes alpha of the remaining common pool up to Cap = m_cap * I_inv, converting to pure common alpha * W_exit only above W_cap_conv = Cap / alpha = $120.00M!
Verify on Invested_Capital I_inv = $10.00M (B2), Liquidation_Multiple m_pref = 1.0x (B3 -> Pref = $10M), VC_Ownership alpha = 0.25 (25.0%, B4), Participation_Cap m_cap = 3.0x (B5 -> Cap = $30M), and Exit_Proceeds W_exit = $50.00M (B6): (1) 1x Non-Participating VC converts at W_exit = $50M > $40M to receive 0.25 * 50 = $12.50M (Founders/Common receive $37.50M); (2) 3x-Capped Participating VC takes $10M pref + 0.25 * ($50M - $10M) = $20.00M (reducing Founders/Common by -$7.50M to $30.00M)! Test the flat cap zone W_exit = $100M -> Capped Participating freezes at $30.00M, and test W_exit = $160M (> $120M) -> converts to 0.25 * $160M = $40.00M!
| Exit Waterfall Scenario ($10M Invested, 25% Own, 1x Pref, 3x Cap) | 1x Non-Participating VC | 1x Participating (3x Cap) VC |
|---|---|---|
| Distressed Sale (W_exit = $8M) | $8.00M (100% Sweep) | $8.00M (100% Sweep) |
| Mid-Size M&A (W_exit = $50M) | $12.50M (Converts > $40M) | $20.00M (+$7.50M Double-Dip) |
| Cap Flat Zone (W_exit = $100M) | $25.00M | $30.00M (Frozen at 3x Cap) |
| Home-Run Exit (W_exit = $160M) | $40.00M | $40.00M (Converts > $120M) |
Universal Capped Participating Preferred Waterfall Formula
Combining MIN(W_exit, ...) for insolvency, MIN(Cap, Pref + alpha*MAX(0, W_exit - Pref)) for capped participation, and MAX(alpha*W_exit, ...) for Voluntary Common Conversion handles all four exit zones in one formula!
=LET(in_vc, B2, mp_rf, B3, al_ow, B4, mc_cp, B5, wx_pr, B6, IF(OR(in_vc <= 0, mp_rf <= 0, al_ow <= 0, al_ow >= 1, mc_cp < mp_rf, wx_pr < 0), "Invalid Term Sheet", LET(pr_am, mp_rf * in_vc, cp_am, mc_cp * in_vc, ROUND(MIN(wx_pr, MAX(al_ow * wx_pr, MIN(cp_am, pr_am + al_ow * MAX(0, wx_pr - pr_am)))), 2))))Non-Participating Conversion Threshold & Double-Dip Founder Cost Formula
Subtract Non-Participating Payout (E2) from Capped Participating Payout (E4) to show founders the exact dollar cost of participating language at any M&A exit!
=IF(ISTEXT(E4), E4, ROUND(E4 - E2, 2))Try the example
Use the original values or change them to test your understanding.