B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
9
Covered Call
10
11
Write Call
Profit = S - S
0
- Max(0, S - E) + C
12
Buy Stock
S = spot price, E = strike/excerise price, C = call price (premium), S
0
= stock purchase price
13
14
Spot
15
16
Stock
17
Call
18
Exec
19
20
21
22
23
24
Change the spot, stock, call and exec values and see how the profit changes.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
Copyright.
Anthony's VBA Page.
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.