Public Template: Stock Option Value Calculator for Current Employees
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
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
Options value calculator
3
Disclaimer: This is not a guarantee of value. This is a simple calculator to estimate the value of your options assuming a range of valuations and growth rates that may or may not happen. It does not include factors like the liquidation preference of our preferred stock that may impact the value of your options in the event of a sale or IPO, nor does it include the exact potential dilution of future funding rounds. If we don't execute well, your options may be worth less than a Starbucks gift card. So consider this calculator to be for entertainment and/or daydreaming purposes only, and then get back to work :-)
4
How to use: Make a copy of this for yourself. The cells in grey with blue text are the variables that you can adjust, everything else is a formula and should be left alone.
5
6
Today's date8/7/2019
7
8
PART 1: Your current option grants
9
Your cost to exercise your...
10
Vesting Start Date
Options Granted
Strike Price% VestedVested options
Unvested options
Vested optionsUnvested OptionsTotal options
11
12/2/20164,500$0.5066.99%3,0141,486$1,507$743$2,250
12
7/12/20171,000$1.2551.78%518482$647$603$1,250
13
1/30/181,000$2.0037.95%379621$759$1,241$2,000
14
0.00%00$0$0$0
15
0.00%00$0$0$0
16
0.00%00$0$0$0
17
0.00%00$0$0$0
18
Total6,50060.18%3,9122,588$2,913$2,587$5,500
19
20
21
PART 2: Estimating what your options are worth today
22
23
Most recent monthly revenue
$5,000,000As of June 2019
24
Annualized run-rate
$60,000,000
25
Estimated valuation multiple
5.0x
26
Estimated Skillshare market value
$300,000,000
27
28
Total shares outstanding
20,000,000
29
Estimated value per share
$15.00
30
31
Estimated value of your...
Approximate value
32
Grant Date
Options Granted
Strike PriceShare price
Value per option
Total grantVested optionsUnvested options
vesting monthly
33
12/2/20164,500$0.50$15.00$14.50$65,250$43,709$21,541$1,359
34
7/12/20171,000$1.2515.0013.7513,7507,1206,630286
35
1/30/20181,000$2.0015.0013.0013,0004,9338,067271
36
0.000.000000
37
0.000.000000
38
0.000.000000
39
0.000.000000
40
Total$92,000$55,761$36,239$1,917
41
Summary
42
Your total option grants are worth an estimated amount of...
$92,000
43
The vested portion is worth approximately...
$55,761
44
The amount that has not yest vested is worth...
$36,239
45
Every month, you vest an additional amount of...
$1,917
at our current valuation - this will go up or down along with our valuation
46
47
48
PART 3: Estimating what your options could potentially be worth if we execute really, really, really well and navigate our way to a successful exit (via IPO, acquisition, etc)
49
This formula takes our current revenue, grows it for the defined years at the defined rate, multiplies by the valuation multiple, reduces value for future fundraising dilution, divides by the outstanding shares, then subtracts your cost to exercise your options
50
51
Assumed future fundraising dilution
15%
52
How many years forward to project
4
53
54
Revenue multiple in 4 years...
55
Annualized 4 year growth rate of...
1.0x3.0x5.0x7.0x9.0x
56
25%
Company revenue (millions)
$146.5$146.5$146.5$146.5$146.5
57
Estimated company valuation (millions)
$146.5$439.5$732.4$1,025.4$1,318.4
58
Estimated value of your options
$34,966$115,899$196,832$277,764$358,697
59
50%
Company revenue (millions)
$303.8$303.8$303.8$303.8$303.8
60
Estimated company valuation (millions)
$303.8$911.3$1,518.8$2,126.3$2,733.8
61
Estimated value of your options
$78,411$246,233$414,055$581,877$749,698
62
75%
Company revenue (millions)
$562.7$562.7$562.7$562.7$562.7
63
Estimated company valuation (millions)
$562.7$1,688.2$2,813.7$3,939.1$5,064.6
64
Estimated value of your options
$149,955$460,866$771,777$1,082,688$1,393,598
65
100%
Company revenue (millions)
$960.0$960.0$960.0$960.0$960.0
66
Estimated company valuation (millions)
$960.0$2,880.0$4,800.0$6,720.0$8,640.0
67
Estimated value of your options
$259,700$790,100$1,320,500$1,850,900$2,381,300
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...