ESOP Calculator_Mysa

	A	B	C	D	E	F	G	H	I	J	K	L	M
1					Please copy this template & use
2
3
4
5	Cap table calculator ( Input in grey cells)
6		Seed	Series A	Series B
7	Funding amount	$750,000	$6,000,000	$20,000,000	👈 Replace sample numbers
8	Pre-money valuation	$4,000,000	$32,000,000	$80,000,000	👈 Replace sample numbers
9	Post Money valuation	$4,750,000	$38,000,000	$100,000,000
10	ESOP pool %	10.00%
11
12
13	Cap Table			Funding amount + Pre-money valuation		(Founder share / Founders holding) - Founders share	Founder share + Other share holders (Incl. ESOP pool)	100% - ESOP pool% - Round investors %	Previous ESOP pool% - (Previous ESOP pool% / Investor holding%)	Post money valuation / funding amount
14		Funding amount	Pre-Money Valn	Post Money ( calculated)	Founder shares	Other shareholders (incl. ESOP pool)	Total Number of shares	Founders holding	ESOPs	Investors holding	Seed	Series A	Total
15	Incorporation	0	0	0	10,000	0	10,000	100.0%					100.0%
16	Seed	$750,000	$4,000,000	$4,750,000	10,000	3,475	13,475	74.2%	10.0%	15.8%			100.0%
17	Series A	$6,000,000	$32,000,000	$38,000,000	10,000	6,002	16,002	62.5%	8.4%	15.8%	13.3%		100.0%
18	Series B	$20,000,000	$80,000,000	$100,000,000	10,000	10,002	20,002	50.0%	6.7%	20.0%	10.6%	12.6%	100.0%
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