ABCDEFGHIJKLMNOPQRSTUVWXY
1
To make a copy for your own use, copy all of the cells and then paste them into a new Google sheet. You can then edit or download to Excel.
2
3
Company NameCompany X
4
5
1Company X revenue as of last month$5,000,000
Our most recent monthly revenue
6
2Est revenue multiple5.0x
Our estimate of a revenue multiple given our size, growth and market
7
3 Estimated market valuation$300,000,000= 1 x 2 x 12 mos
Our best guess of the true valuation of Company X; this is an estimate not a guarantee - the real value could be much higher or lower
8
4
9
5Company X fully diluted shares20,000,000
The total number of fully diluted shares of Company X as of today
10
6 Estimated value per share$15.00= 3 / 5
Our total estimated market value divided by our total number of shares = estimated market value per share
11
7
12
8Most recent strike price$2.00
The exercise cost of an option based on our 409a valuation; the amt you will have to pay to exercise option and acquire a share
13
9 Implied 'notional value' of an option$13.00= 6 - 8
The difference between the exercise price and the est. market value; our best guess as to the true value of each option
14
10
15
11Your annual cash compensation$80,000
Your annual salary
16
12Your level/roleEngineer
How we are classifying your role for equity grant purposes
17
13The equity multiplier for your level/role0.26
This is a multiplier based on Union Square Ventures' research and equity grant framework of market comparables for your role
18
14 Our target value of your grant for this role$20,800= 12 x 13
Our target value of your equity grant as of today -- we want to grant you $20,800 worth of options
19
15
20
16Notional value of an option (from above)$13.00= 9
The estimated value per grant per the notional value on line 9 above
21
17 Options granted (rounded to nearest 50)1,600= 14 / 16
The number of options we need to grant you to get you to $20,800 worth of options assuming a $13.00 value per option
22
18 Options granted as % of total0.008%= 17 / 5
Your overall percentage of the fully diluted shares of the company
23
24
What could your grant be worth in 4 years?
Revenue multiple in year 4...
25
This is not a guarantee of value, and there is no specific timeline for your shares to become liquid (meaning you can cash out). We just want to give you an better sense for what your options could be worth if we execute well in the coming years.1.0x3.0x5.0x7.0x9.0x
26
Annual 4 yr growth rate25%$9,000$32,000$55,000$79,000$102,000
27
50%$21,000$70,000$118,000$167,000$216,000
28
75%$42,000$132,000$222,000$312,000$402,000
29
100%$74,000$227,000$381,000$534,000$688,000
30
31
For example, if we grow at 50% per year for the next 4 years, and are valued at 5x revenue, your current option grant would be worth $118,000
32
33
Equity multipliers by role
34
Exec Team/C-level2.45
35
VP1.86
36
Director0.54
37
Sr. Engineer0.40
38
Engineer0.26
39
Key Contributor/Specialist0.43
40
Individual Contributor0.23
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