Venture Hacks Cap Table Example

Effective Pre-Money $2,000,000 Share Price $1.000000 Pre-Money $2,000,000 Post-Money Pool 0% Post-Money $3,000,000 Debt Discount 0% Investment Shares Ownership Series A Investor 1 $1,000,000 1,000,000 33.33% Series A Investor 2 $0 0 0.00% Total Series A $1,000,000 1,000,000 33.33% Lender 1 $0 0 0.00% Lender 2 $0 0 0.00% Total Seed Debt $0 0 0.00% Common Stock and Pre-Money Options 2,000,000 66.67% Post-Money Options 0 0.00% Total $1,000,000 3,000,000 100.00% Pre-Money Post-Money Share Value Founders 100.00% 66.67% $2,000,000 Preferred 0.00% 33.33% $1,000,000 All Options 0.00% 0.00% $0 Total 100.00% 100.00% $3,000,000 Summary Series A Cap Table Misc Inputs and OutputsExit Value assumes there is no liquidation preference and no additional dilution before an exit. Share Value assumes that the Common Stock's fair market value is equal to the Share Price. License You may share and remix this work under the Creative Commons "Attribution-ShareAlike 3.0 Originally created by Venture Hacks http://venturehacks.com/Version 0.9 (You can always find the latest version at http://Calculations For your information, after you fill in the blue numbers, the main variables are calculated with These are useful if you want to customize the spreadsheet. Post-Money = Pre-Money + Total Series A Share Price = (Pre-Money -Post Money x Post-Money Pool -Total Seed Debt /(1 -Debt Discount)) Effective Pre-Money = Share Price x Common Stock and Pre-Money Options Post-Money Options = Post Money x Post-Money Pool /Share Price Investor Shares = Investment /Share Price Lender Shares = Investment /(Share Price x (1 -Debt Discount)) Disclaimer Venture Hacks makes no representations that this cap table is accurate in any way or is fit for Venture Hacks does not take responsibility for anything that results from using this cap table, If you did not receive this cap table from venturehacks.com, it may have been modified by a (from other worksheet) Exit Value $33,333,333 $16,666,667 $0 $50,000,000dilution before an exit. equal to the Share Price. In reality, the Common Stock's fair market value is much lower than the Share Attribution-ShareAlike 3.0 Unported" license if you include this line and the following two lines: latest version at http://venturehacks.com/articles/cap-table ) variables are calculated with the following equations. Debt /(1 -Debt Discount)) /Common Stock and Pre-Money Options in any way or is fit for any purpose. This is not legal advice. from using this cap table, including, but not limited to, losing all your money and going to jail. have been modified by a third party. We take no responsibility for these modifications.reality, the Common Stock's fair market value is much lower than the Share Price. Unported" license if you include this line and the following two lines: including, but not limited to, losing all your money and going to jail.Shares Post-Money Share Value Exit Value Common Stock Founder 1 2,000,000 66.67% $2,000,000 $33,333,333 Founder 2 0 0.00% $0 $0 Total Common 2,000,000 66.67% $2,000,000 $33,333,333 Pre-Money Options Employee 0 0.00% $0 $0 Employee 0 0.00% $0 $0 Employee 0 0.00% $0 $0 Employee 0 0.00% $0 $0 Employee 0 0.00% $0 $0 Total Options 0 0.00% $0 $0 2,000,000 66.67% $2,000,000 $33,333,333 Common Stock and Pre-Money Options Common Stock and Pre-Money Options