Startup Finance for First Time Entrepreneurs - CAP TABLE

	A	B	C	D	F	G	H	I	J	L	M	N	O	P	R	S	T	U	V
1	Hello to those using a screen reader cell B1 describes this file. Additional accessibility information available in the Accessibility Info tab.	This spreadsheet provides the mathematical functions to create a Capitalization Table (Cap Table) for an example start up company after three rounds of funding. Values in BLUE may be entered, values in BLACK are calculated by the spreadsheet. (Editable cells have blue italicized text and bold cell outlines.) The main take away is to notice the dilution (or reduction in your percentage ownership) when you take investment money and the effects of valuation and outstanding shares on this percentage, please note how each table feeds into the next table as another round of investment occurs				This spreadsheet is supplemental to the Startup Finance for First Time Entrepreneurs Open Education Resource PowerPoint Deck which explains this spreadsheet in detail. “Startup Finance for First Time Entrepreneurs - CAP TABLE” by Karen Crofton is licensed under CC BY 4.0.
2	Round 1: Pre-Financing				Round 2: Friends and Family					Round 3: Angel Round					Round 4: VC Round
3	Company Details	Amount			Company Details	Amount				Company Details	Amount				Company Details	Amount
4	Pre-Money Valuation:	$0			Pre-Money Valuation:	$200,000				Pre-Money Valuation:	$500,000				Pre-Money Valuation:	$1,000,000
5	Total Investment:	$0			Total Investment:	$20,000				Investment:	$120,000				Investment:	$500,000
6	Post-Money Valuation:	$0			Post-Money Valuation:	$220,000				Post-Money Valuation:	$620,000				Post-Money Valuation:	$1,500,000
7	Outstanding Shares:	0			Outstanding Shares:	250,000				Outstanding Shares:	275,000				Outstanding Shares:	416,000
8	Share Price:	$0.01			New Share Price:	$0.80				New Share Price:	$1.82				New Share Price:	$2.40
9	Participants	New Investment	New Shares	Fully-Diluted Stock %	Participants	New Investment	New Shares	Total Post-Round Shares	Fully-Diluted Stock %	Participants	New Investment	New Shares	Total Post-Round Shares	Fully-Diluted Stock %	Participants	New Investment	New Shares	Total Post-Round Shares	Fully-Diluted Stock %
10	Co-Founder #1	$0	100,000	40.0%	Co-Founder #1			100,000	36.4%	Co-Founder #1			100,000	29.3%	Co-Founder #1			100,000	16.0%
11	Co-Founder #2	$0	100,000	40.0%	Co-Founder #2			100,000	36.4%	Co-Founder #2			100,000	29.3%	Co-Founder #2			100,000	16.0%
12	Option Pool	$0	50,000	20.0%	Option Pool			50,000	18.2%	Option Pool			50,000	15%	Option Pool* see T17	$0	75,000	125,000	20%
13	Totals		250,000	100%	Friend #1	$20,000	25,000	25,000	9.1%	Friend #1			25,000	7.3%	Friend #1			25,000	4.0%
14					Totals			275,000	100%	Angel Group #1	$100,000	55,000	55,000	16%	Angel Group #1			55,000	9%
15										Angel #2	$20,000	11,000	11,000	3.2%	Angel #2			11,000	1.8%
16										Totals		66,000	341,000	100%	VC #1	$500,000	208,000	208,000	33.3%
17															Totals		283,000	624,000	100%
18																*additional option pool is added at $0 AND Option shares go outstanding immediately
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
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