| A | B | C | D | |
|---|---|---|---|---|
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 me | 20,000 | ||
6 | My percentage ownership in the company | 0.385% | ||
7 | ||||
8 | Total shares in the company | 5,200,000 | ||
9 | ||||
10 | My Vested shares | 15,000 | ||
11 | Percent vested (of my options) to date | 75.00% | ||
12 | Percent vested of total company shares | 0.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 | ||||