Options Analysis Template.xlsx

	B	C	D	F	G	H	I	J	K	L	M
1
2	Total Number of Shares Granted	30,000
3	Last employee strike price	$0.26
4	Last investor share price	$1.13
5	% company	0.0228%		SCENARIOS (YOY Growth)
6	Total # shares outstanding	153,508,771.93		Sell at last round price				Medium
7				Growth rate:	0%			Growth rate:	8%
8	Year-end	Shares granted in period	Total shares accumulated	Strike Price	Market Value	Spread	Return	Strike Price	Market Value	Spread	Return
9	1	7500	7500	$ 0.26	$ 1.13	$ 0.87	$6,525.00	$ 0.26	$ 1.22	$ 0.96	$7,203.00
10	2	7500	15000	$ 0.26	$ 1.13	$ 0.87	$13,050.00	$ 0.26	$ 1.32	$ 1.06	$15,870.48
11	3	7500	22500	$ 0.26	$ 1.13	$ 0.87	$19,575.00	$ 0.26	$ 1.42	$ 1.16	$26,178.18
12	4	7500	30000	$ 0.26	$ 1.13	$ 0.87	$26,100.00	$ 0.26	$ 1.54	$ 1.28	$38,320.58
13
14				High				Higher
15	Event	Probability	Return	Growth rate:	10%			Growth rate:	20%
16	Worthless	15%	($1,170.00)	Strike Price	Market Value	Spread	Return	Strike Price	Market Value	Spread	Return
17	1x	25%	$6,525.00	$ 0.26	$ 1.24	$ 0.98	$7,372.50	$ 0.26	$ 1.36	$ 1.10	$8,220.00
18	3x	45%	$42,255.00	$ 0.26	$ 1.37	$ 1.11	$16,609.50	$ 0.26	$ 1.63	$ 1.37	$20,508.00
19	10x	15%	$49,680.00	$ 0.26	$ 1.50	$ 1.24	$27,990.68	$ 0.26	$ 1.95	$ 1.69	$38,084.40
20	Expected Value	100%	$97,290.00	$ 0.26	$ 1.65	$ 1.39	$41,832.99	$ 0.26	$ 2.34	$ 2.08	$62,495.04
21
22				Worthless				Sell at 2018 price
23				Growth rate:	0%			Growth rate:	1
24				Strike Price	Market Value	Spread	Return	Strike Price	Market Value	Spread	Return
25				$ 0.26	$ -	$ (0.26)	($7,800.00)	$ 0.26	$ 1.13	$ 0.87	$26,100.00
26
27				3x				10x
28				Growth rate:	3			Growth rate:	10
29				Strike Price	Market Value	Spread	Return	Strike Price	Market Value	Spread	Return
30				$ 0.26	$ 3.39	$ 3.13	$93,900.00	$ 0.26	$ 11.30	$ 11.04	$331,200.00
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