| A | B | C | D | E | F | G | H | I | J | K | L | M | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | This is a simple tool to help you run scenarios about your next financing round. | |||||||||||||
2 | File > Make a copy, fill the green cells with your data and enjoy! | |||||||||||||
3 | For more context, visit | https://marathon.vc/blog/a-plain-cap-table-template/ | ||||||||||||
4 | ||||||||||||||
5 | New investment ($) | |||||||||||||
6 | Investor 1 | 500,000 | ||||||||||||
7 | Investor 2 | 2,500,000 | ||||||||||||
8 | Investor 3 | |||||||||||||
9 | ||||||||||||||
10 | Unallocated option pool (post Series X, %) | 5% | ||||||||||||
11 | ||||||||||||||
12 | Fully-diluted pre-money valuation ($) | 17,000,000 | ||||||||||||
13 | ||||||||||||||
14 | ||||||||||||||
15 | Cap table | Series X-1 | Series X | |||||||||||
16 | Holder name | Common Shares (#) | Preferred Shares (#) | Total Shares (#) | Equity stake (%) | New Common Shares (#) | New Preferred X Shares (#) | Total Shares (#) | Equity stake (%) | Value ($) | ||||
17 | ||||||||||||||
18 | Founder 1 | 1,000,000 | 1,000,000 | 36.04% | 1,000,000 | 29.41% | 5,882,352.94 | |||||||
19 | Founder 2 | 1,000,000 | 1,000,000 | 36.04% | 1,000,000 | 29.41% | 5,882,352.94 | |||||||
20 | Founder 3 | 0.00% | 0.00% | 0.00 | ||||||||||
21 | Founders Total | 2,000,000 | 0 | 2,000,000 | 72.07% | 0 | 0 | 2,000,000 | 58.82% | 11,764,705.88 | ||||
22 | ||||||||||||||
23 | Investor 1 | 500,000 | 500,000 | 18.02% | 85,000 | 585,000 | 17.21% | 3,441,176.47 | ||||||
24 | Investor 2 | 0.00% | 425,000 | 425,000 | 12.50% | 2,500,000.00 | ||||||||
25 | Investor 3 | 0.00% | 0 | 0 | 0.00% | 0.00 | ||||||||
26 | Investors total | 0 | 500,000 | 500,000 | 18.02% | 0 | 510,000 | 1,010,000 | 29.71% | 5,941,176.47 | ||||
27 | ||||||||||||||
28 | Allocated Options | 220,000 | 220,000 | 7.93% | 220,000 | 6.47% | 1,294,117.65 | |||||||
29 | Unallocated Options | 55,000 | 55,000 | 1.98% | 115,000 | 170,000 | 5.00% | 1,000,000.00 | ||||||
30 | Option Pool Total | 275,000 | 275,000 | 9.91% | 115,000 | 390,000 | 11.47% | 2,294,117.65 | ||||||
31 | ||||||||||||||
32 | Total | 2,275,000 | 500,000 | 2,775,000 | 100.00% | 115,000 | 510,000 | 3,400,000 | 100.00% | 20,000,000.00 | ||||
33 | ||||||||||||||
34 | ||||||||||||||
35 | Calcs | |||||||||||||
36 | ||||||||||||||
37 | New Preferred as of Total (%) | A | 15.00% | |||||||||||
38 | Total Existing Shares (#) | T | 2,775,000 | |||||||||||
39 | Unallocated option pool (post Series X, %) | P | 5% | |||||||||||
40 | Existing unallocated option pool | U | 55,000 | |||||||||||
41 | ||||||||||||||
42 | New Preferred Shares (#) | X | ||||||||||||
43 | New Unallocated Option Pool (#) | Y | ||||||||||||
44 | ||||||||||||||
45 | A=X/(T+X+Y) | |||||||||||||
46 | P=(Y+U)/(T+X+Y) | |||||||||||||
47 | ||||||||||||||
48 | Solving for X & Y... | |||||||||||||
49 | X=A(U-T)/(A+P-1) | X | 510,000 | |||||||||||
50 | Y=(-AU-PT+U)/(A+P-1) | Y | 115,000 | |||||||||||
51 | ||||||||||||||
52 | Price per Share ($) | 5.88 | ||||||||||||
53 | ||||||||||||||
54 | ||||||||||||||
55 | ||||||||||||||