Public Template: Stock Option Grant Evaluator for Candidates
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWX
1
Calculator to evaluate the value of your option grant
2
Make a copy of this for your own use by copying all cells and pasting into a new Google Sheet. You can then edit or download to Excel.
3
The grey cells with blue font are variables that you can adjust, and the rest are formulas that should be left alone.
4
5
Part 1: Estimating what number of options you should be granted
6
7
Cash compensation offered by company
$80,000
The total cash compensation offered to you by the prospective company
8
Role/level categoryIndividual Contributor
Your role - pick the one that best suits your level/function
9
Option grant value multiplier0.23
This is the multiplier based on your level
10
Target value of the option grant$18,400
This could be considered a "market rate" grant value based on your comp and level
11
12
Company revenue as of last month$5,000,000
You'll need to get this information from the company
13
Estimated revenue multiple5.0x
Ask the company what their valuation multiple was at the last round of fundraising
14
Estimated market value of the company
$300,000,000
This is what you estimate the company to be worth overall
15
16
Fully diluted shares outstanding20,000,000
You'll need to get this from the company as well
17
Implied market value per share$15.00
The estimated value per share
18
19
Most recent strike price$1.75
Ask the company for the most recent stock price
20
Implied 'notional value' per option$13.25
The difference between the market value per share and the strike price
21
22
ESTIMATED 'MARKET' OPTION GRANT
1,389
What the calculator says would be a reasonable option grant for your level/comp
23
24
Part 2: Evaluating the grant you were given
25
Fill in the information above first -- that data drives this section
26
27
How many options they granted you1,500
28
The implied value per option (from above)
$13.25
29
Total estimated value of the grant today
$19,875
30
31
Estimated target value of grant per above
$18,400
32
$ amount over/(under) market$1,475
33
% amount over/(under) market8.02%
34
35
What could your grant be worth in 4 years?
Revenue multiple in year 4...
36
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
37
Annual 4 yr growth rate25%$8,000$30,000$52,000$74,000$96,000
38
50%$20,000$66,000$111,000$157,000$202,000
39
75%$40,000$124,000$208,000$293,000$377,000
40
100%$69,000$213,000$357,000$501,000$645,000
41
42
For example, if the company grows at 50% per year for the next 4 years, and are valued at 5x revenue, your current option grant would be worth $111,000
43
44
45
46
Equity multipliers by role.
47
These are Skillshare's estimates based on Union Square's evaluation of local market comparables.
48
Exec Team/C-level2.45
49
VP1.86
50
Director0.54
51
Sr. Engineer0.40
52
Engineer0.26
53
Key Contributor/Specialist0.43
54
Individual Contributor0.23
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
Loading...