ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
2
Grant Information>>>
Black Scholes Calcs>>
Cumulative vested>>>
**This is only under the straightline method. What it shold be taking is the daily expense over the service period (which is either from grant date or vesting start date to the last vesting date). There are two caveats: 1) Expensing can't happen before the grant date, so if the vest start date is before grant date and the vest start date method is chosen, then there will be a catch up of expense on the grant date for the period before the grant date. 2) The minimum cumulative expense must equal the FV * vested shares. So the formula must take the bigger of comulative daily expense or cumulative vested expense
3
Grant NumberNameDepartmentExercise PriceShares GrantedGrant DateVesting ScheduleMonths VestingVesting Start DateVesting End DateTermination DateMarket ValueExpected TermVolatilityDividend YieldRisk free interest ratePV Stock Ex DividendPV Exercise PriceCumulative VolatilityProportion of Stock PVProportion of Exercise Price PVPer Share Fair Value1st Vest dateTotal ExpenseDaily Expense (Straight-line)12/31/20211/31/20222/28/20223/31/20224/30/20225/31/20226/30/20227/31/20228/31/20229/30/202210/31/202211/30/202212/31/20221/31/20232/28/20233/31/20234/30/20235/31/20236/30/20237/31/20238/31/20239/30/202310/31/202311/30/202312/31/20231/31/20242/29/20243/31/20244/30/20245/31/20246/30/20247/31/20248/31/20249/30/202410/31/202411/30/202412/31/20241/31/20252/28/20253/31/20254/30/20255/31/20256/30/20257/31/20258/31/20259/30/202510/31/202511/30/202512/31/20251/31/20262/28/20263/31/20264/30/20265/31/20266/30/20267/31/20268/31/20269/30/202610/31/202611/30/202612/31/20261/31/20272/28/20273/31/20274/30/20275/31/20276/30/20277/31/20278/31/20279/30/202710/31/202711/30/2027
4
1Aaron LevieFinance$0.88200,0007/31/25
25% after 1 yr., then 1/36 of remaining per mo.
485/5/255/5/290.88662%0.00%4.03%0.880.69151.87%82.08%-27.42%0.526685/5/2026105336$76.610000000000000000000000000000000000000000000000000000050,00054,16658,33362,50066,66670,83375,00079,16683,33387,50091,66695,833100,000104,166108,333112,500116,666120,833125,000
5
2Marc BenioffFinance$3.005,0001/1/23
25% after 1 yr., then 1/36 of remaining per mo.
4810/1/2210/1/26$3.006.0871.64%0.00%3.98%$3.002.36176.61%84.61%-22.78%$2.0010/1/2023$10,008.33$7.3100000000000000000000001,2501,3541,4581,5621,6661,7701,8751,9792,0832,1872,2912,3952,5002,6042,7082,8122,9163,0203,1253,2293,3333,4373,5413,6453,7503,8543,9584,0624,1664,2704,3754,4794,5834,6874,7914,8955,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,0005,000
6
3Frank SlootmanFinance$1.8036,0003/15/22
25% after 1 yr., then 1/36 of remaining per mo.
4812/15/2112/15/25$1.806.0873.42%0.00%2.13%$1.801.58181.01%83.56%-20.23%$1.1812/15/2022$42,632.19$31.070000000000009,0009,75010,50011,25012,00012,75013,50014,25015,00015,75016,50017,25018,00018,75019,50020,25021,00021,75022,50023,25024,00024,75025,50026,25027,00027,75028,50029,25030,00030,75031,50032,25033,00033,75034,50035,25036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,00036,000
7
4OnlyCFOFinance$8.001,000,0005/15/23
25% after 1 yr., then 1/36 of remaining per mo.
481/1/241/1/28$8.006.0871.64%0.00%3.47%$8.006.48176.61%84.19%-22.25%$5.291/1/2025$5,293,685.87$3,620.850000000000000000000000000000000000000250,000270,833291,666312,500333,333354,166375,000395,833416,666437,500458,333479,166500,000520,833541,666562,500583,333604,166625,000645,833666,666687,500708,333729,166750,000770,833791,666812,500833,333854,166875,000895,833916,666937,500958,333
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
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