Sample Stock Options Planning Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCD
1
Note: I can't grant you access to this document, but you can select "Make a copy" from the "File" menu above to save an editable version of this sheet to your Google Drive.
2
Simply fill out the green boxes below. Mouse over them to see a description of what should be entered
3
4
My options
5
My Total options available to me20,000
6
My percentage ownership in the company0.385%
7
8
Total shares in the company5,200,000
9
10
My Vested shares15,000
11
Percent vested (of my options) to date75.00%
12
Percent vested of total company shares0.29%
13
14
Strike price (price I pay per share)$0.10
15
Price to exercise (purchase) my vested options$1,500
16
17
Total market value as of Jan 2018$35,000,000
18
19
20
Current market value price per share$6.73
21
22
Current market value of vested shares$100,962
23
24
Minus price to purchase$99,462
25
Taxes - if I wait for 1 year before selling$20,638
26
Taxes - if sell before 1 year passes$38,541
27
28
Take home - Minus taxes (if I wait for 1 year before selling)$78,823
29
Take home - Minus taxes (if sell before 1 year passes)$60,920
30
31
Take home diff if I wait one year$17,903
32
Loading...
Main menu