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 date6/26/2023
7
8
PART 1: Your current option grants
9
10
Vesting Start Date
Options GrantedStrike Price% VestedVested optionsUnvested optionsVested optionsUnvested OptionsTotal options
11
12/2/20164,500\$0.50100.00%4,5000\$2,250\$0\$2,250
12
7/12/20171,000\$1.25100.00%1,0000\$1,250\$0\$1,250
13
1/30/181,000\$2.00100.00%1,0000\$2,000\$0\$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,500100.00%6,5000\$5,500\$0\$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 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 DateOptions GrantedStrike PriceShare priceValue per optionTotal grantVested optionsUnvested optionsvesting monthly
33
12/2/20164,500\$0.50\$15.00\$14.50\$65,250\$65,250\$0FALSE
34
7/12/20171,000\$1.2515.0013.7513,75013,7500FALSE
35
1/30/20181,000\$2.0015.0013.0013,00013,0000FALSE
36
0.000.000000
37
0.000.000000
38
0.000.000000
39
0.000.000000
40
Total\$92,000\$92,000\$0\$0
41
Summary
42
Your total option grants are worth an estimated amount of...
\$92,000
43
The vested portion is worth approximately...
\$92,000
44
The amount that has not yest vested is worth...
\$0
45
Every month, you vest an additional amount of...
\$0
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
\$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
\$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
\$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
\$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