Venture Capital & Startup Cap Tables
VC Option Pool Shuffle & Effective Pre-Money Formula
Calculate the Series A Share Price P_A, New Option Pool Top-Up Shares, Effective True Pre-Money Valuation of existing shares, and Founder Ownership under Investor-Friendly Pre-Money Pool Creation vs Shared Post-Money Pool.
Uncover the hidden pre-money valuation haircut buried inside Series A option-pool clauses!
In Venture Capital term sheets, the "Option Pool Shuffle" occurs when an investor offers Headline Pre-Money Valuation V_pre plus New Cash I_vc (Post-Money V_post = V_pre + I_vc, VC Stake w_vc = I_vc / V_post), conditioned on an unallocated Post-Closing Option Pool p_pool carved 100% out of the Pre-Money share count! If Founders hold S_fdr shares and the existing unallocated pool holds S_p0 shares (with natural diluted share S_p0 / (S_fdr + S_p0) * (1 - w_vc) < p_pool), solving S_fdr / S_post = 1 - w_vc - p_pool sets Post-Money Shares S_post = S_fdr / (1 - w_vc - p_pool), Series A Share Price P_A = V_post / S_post, Pool Top-Up Shares S_top = p_pool * S_post - S_p0, and Effective True Pre-Money Valuation of existing (S_fdr + S_p0) shares to V_eff = (S_fdr + S_p0) * P_A < V_pre!
Verify on Founder_Shares S_fdr = 6.50M (B2), Existing_Unallocated_Pool S_p0 = 0.50M (B3 -> 7.00M existing shares), Headline_Pre_Money V_pre = $16.00M (B4), Series_A_Investment I_vc = $4.00M (B5 -> V_post = $20.00M, w_vc = 20.0%), and Target_Post_Option_Pool p_pool = 0.15 (15.0%, B6): Post-Money Shares equal 6.50 / (1 - 0.20 - 0.15) = 10.00M, Series A Price is $20.00M / 10.00M = $2.00/sh (vs $16M / 7M = $2.29/sh without shuffle!), Pool Top-Up is 1.50M - 0.50M = 1.00M shares ($2.00M value), Effective True Pre-Money Valuation of existing shares drops to 7.00M * $2.00 = $14.00M (-$2.00M below the $16.00M headline!), and Founder Ownership lands at 0.6500 (65.00%)! Zero out S_p0 = 0 in cell B3: Effective Pre-Money drops all the way to $13.00M (V_pre - p_pool * V_post)!
| Series A Cap Table Metric ($16M Pre + $4M VC, 6.5M Fdr + 0.5M Old Pool, 15% Target Pool) | Formula | Verified Output |
|---|---|---|
| Shuffled Series A Share Price P_A | V_post * (1 - w_vc - p_pool) / S_fdr | $2.00 / sh (vs $2.29 Headline) |
| New Pool Top-Up Shares (M) | p_pool * S_post - S_p0 | 1.00M shares ($2.00M Haircut) |
| Effective True Pre-Money Valuation | (S_fdr + S_p0) * P_A | $14.00M ($13.00M if S_p0 = 0) |
| Founder Post-Close Ownership | 1 - I_vc / V_post - p_pool | 0.6500 (vs 0.6800 Shared Pool) |
Effective True Pre-Money Valuation Formula (With Existing Pool Credit)
Use MAX for S_post so if an unusually large existing pool S_p0 already satisfies p_pool without any new top-up, P_A cleanly defaults to V_pre / (S_fdr + S_p0)!
=LET(s_fd, B2, s_p0, B3, v_pr, B4, i_vc, B5, p_pl, B6, v_ps, v_pr + i_vc, w_vc, i_vc / v_ps, IF(OR(s_fd <= 0, s_p0 < 0, v_pr <= 0, i_vc <= 0, p_pl < 0, w_vc + p_pl >= 1), "Invalid Pool Shuffle", LET(s_ps, MAX((s_fd + s_p0) / (1 - w_vc), s_fd / (1 - w_vc - p_pl)), ROUND((s_fd + s_p0) * (v_ps / s_ps), 2))))Founder Ownership Share Under Pre-Money Pool Shuffle Formula
Compare against negotiating a Post-Close Pro-Rata Pool (where VC and Founders share the top-up): Founders retain (S_fdr / S_post) = 65.00% under the shuffle!
=LET(s_fd, B2, s_p0, B3, v_pr, B4, i_vc, B5, p_pl, B6, v_ps, v_pr + i_vc, w_vc, i_vc / v_ps, IF(ISTEXT(E4), E4, LET(s_ps, MAX((s_fd + s_p0) / (1 - w_vc), s_fd / (1 - w_vc - p_pl)), ROUND(s_fd / s_ps, 4))))Try the example
Use the original values or change them to test your understanding.