External - Generic Cap Table Calculator

	B	C	D	E	F	G	H	J	K
1

2
3		Want to edit this document?	Go to File > Make a Copy, and then save that copy to your own drive so you can edit the cap table.
4		Questions? Email chloe@chloealpert.com
5
6		Incorporation Table
7			Shares	10,000,000				Key
8		Shareholder	Ownership %	Number of Shares	Price		Value	Blue text represents numbers that are negotiable, change these to see how it impacts everything
9		Founders	85.00%	8,500,000	$0.0001		$850	A box with a triangle has a comment for you to reference
10		Employee Option Pool	15.00%	1,500,000	$0.0001		$150
11		Totals	100.00%	10,000,000			$1,000
12
13		Seed Round						Total Seed Ownership	%
14				Cap:	10,000,000			Founders	84.16%
15	Investment	Shareholder	Ownership %	Number of Shares	Price	Valuation Step up	Value	Employee Pool	14.85%
16		Founders	84.16%	8,500,000	$1.00	10000x	$8,500,000	Seed Investor	0.99%
17		Employee Option Pool	14.85%	1,500,000	$1.00	10000x	$1,500,000		100.00%
18	100,000	Seed Investor	0.99%	100,000	$1.00	0	$100,000
19	100,000		100.00%	10,100,000			$10,100,000
20
21		Series A						Total A Ownership	%
22				Cap:	25,000,000			Founders	65.75%
23	Investment	Shareholder	Ownership %	Number of Shares	Price	Value Step up	Value	Employee Pool	11.60%
24		Founders	65.75%	8,500,000	$2.48	2.47x	$21,039,604	Seed Investor	0.77%
25		Employee Option Pool	11.60%	1,500,000	$2.48	2.47x	$3,712,871	Series A Investor	21.88%
26		Seed Investor	0.77%	100,000	$2.48	2.47x	$247,525		100.00%
27	7,000,000	Series A Investor	21.88%	2,828,000	$2.48	0	$7,000,000
28	7,000,000		100.00%	12,928,000			$32,000,000
29
30		Series B						Total B Ownership	%
31				Cap:	200,000,000			Founders	51.17%
32	Investment	Shareholder	Ownership %	Number of Shares	Price	Value Step up	Value	Employee Pool	9.03%
33		Founders	51.17%	8,500,000	$15.47	6.25x	$131,497,525	Seed Investor	0.60%
34		Employee Option Pool	9.03%	1,500,000	$15.47	6.25x	$23,205,446	Series A Investor	19.75%
35		Seed Investor	0.60%	100,000	$15.47	6.25x	$1,547,030	Series B Investor 1	11.67%
36		Series A Investor	17.02%	2,828,000	$15.47	6.25x	$43,750,000	Series B Investor 2	7.78%
37	7,000,000	Series A Investor Pro Rata	2.72%	452,480	$15.47	0	$7,000,000		100.00%
38	30,000,000	Series B Investor 1	11.67%	1,939,200	$15.47	0	$30,000,000
39	20,000,000	Series B Investor 2	7.78%	1,292,800	$15.47	0	$20,000,000
40	57,000,000		100.00%	16,612,480			$257,000,000
41
42		Series C						Total C Ownership	%
43				Cap:	800,000,000			Founders	40.93%
44	Investment	Shareholder	Ownership %	Number of Shares	Price	Value Step up	Value	Employee Pool	7.22%
45		Founders	40.93%	8,500,000	$48.16	3.11x	$409,330,816	Seed Investor	0.48%
46		Employee Option Pool	7.22%	1,500,000	$48.16	3.11x	$72,234,850	Series A Investor	15.80%
47		Seed Investor	0.48%	100,000	$48.16	3.11x	$4,815,657	Series B Investor 1	14.34%
48		Series A Investor	13.62%	2,828,000	$48.16	3.11x	$136,186,770	Series B Investor 2	11.23%
49		Series A Investor Pro Rata	2.18%	452,480	$48.16	3.11x	$21,789,883	Series C Investor	10.00%
50		Series B Investor 1	9.34%	1,939,200	$48.16	3.11x	$93,385,214		100.00%
51		Series B Investor 2	6.23%	1,292,800	$48.16	3.11x	$62,256,809
52	50,000,000	Series B Investor 1 Pro Rata	5.00%	1,038,280	$48.16		$50,000,000
53	50,000,000	Series B Investor 2 Pro Rata	5.00%	1,038,280	$48.16		$50,000,000
54	100,000,000	Series C Investor	10.00%	2,076,560	$48.16		$100,000,000
55	200,000,000		100.00%	20,765,600			$1,000,000,000
56							🦄
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100