B
C
D
E
F
G
H
I
J
K
L
M
N
O
2
3
4
5
Show Formula:
6
7
8
9
Protective Put
10
11
Buy Put
Profit = S - S
0
+ Max(0, E - S) - P
12
Buy Stock
S = spot price, E = strike/excerise price, P = put price (premium), S
0
= stock purchase price
13
14
Spot
15
16
Stock
17
Put
18
Exec
19
20
21
22
23
24
Change the spot, stock, put 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.