In: Finance
Given the following:
Call Option: strike price = $100, costs $4
Put Option: strike price = $90, costs $6
How can a strangle be created from these 2 options? What are the profit patterns from this? Show using excel.
A strangle is a strategy in which an investor buys a European put and a European call with the same expiration date and different strike prices.
The strangle buyer investor is betting that there will be a large price move.
The investor buys a Put of strike price $90(X1) costing $6 and sells a call of strike price $100(X2) for $4.
Stock price at maturity time T | Payoff from call | Payoff from put | Total payoff |
ST ≤ 90 | 0 | 90-ST | 90-ST |
90 < ST < 100 | 0 | 0 | 0 |
ST ≥ 100 | ST-100 | 0 | ST-100 |
Stock price at maturity time T | Payoff from call +call premium paid | Payoff from put +put premium paid | Total payoff |
50 | -4 | 34 | 30 |
51 | -4 | 33 | 29 |
52 | -4 | 32 | 28 |
53 | -4 | 31 | 27 |
54 | -4 | 30 | 26 |
55 | -4 | 29 | 25 |
56 | -4 | 28 | 24 |
57 | -4 | 27 | 23 |
58 | -4 | 26 | 22 |
59 | -4 | 25 | 21 |
60 | -4 | 24 | 20 |
61 | -4 | 23 | 19 |
62 | -4 | 22 | 18 |
63 | -4 | 21 | 17 |
64 | -4 | 20 | 16 |
65 | -4 | 19 | 15 |
66 | -4 | 18 | 14 |
67 | -4 | 17 | 13 |
68 | -4 | 16 | 12 |
69 | -4 | 15 | 11 |
70 | -4 | 14 | 10 |
71 | -4 | 13 | 9 |
72 | -4 | 12 | 8 |
73 | -4 | 11 | 7 |
74 | -4 | 10 | 6 |
75 | -4 | 9 | 5 |
76 | -4 | 8 | 4 |
77 | -4 | 7 | 3 |
78 | -4 | 6 | 2 |
79 | -4 | 5 | 1 |
80 | -4 | 4 | 0 |
81 | -4 | 3 | -1 |
82 | -4 | 2 | -2 |
83 | -4 | 1 | -3 |
84 | -4 | 0 | -4 |
85 | -4 | -1 | -5 |
86 | -4 | -2 | -6 |
87 | -4 | -3 | -7 |
88 | -4 | -4 | -8 |
89 | -4 | -5 | -9 |
90 | -4 | -6 | -10 |
91 | -4 | -6 | -10 |
92 | -4 | -6 | -10 |
93 | -4 | -6 | -10 |
94 | -4 | -6 | -10 |
95 | -4 | -6 | -10 |
96 | -4 | -6 | -10 |
97 | -4 | -6 | -10 |
98 | -4 | -6 | -10 |
99 | -4 | -6 | -10 |
100 | -4 | -6 | -10 |
101 | -3 | -6 | -9 |
102 | -2 | -6 | -8 |
103 | -1 | -6 | -7 |
104 | 0 | -6 | -6 |
105 | 1 | -6 | -5 |
106 | 2 | -6 | -4 |
107 | 3 | -6 | -3 |
108 | 4 | -6 | -2 |
109 | 5 | -6 | -1 |
110 | 6 | -6 | 0 |
111 | 7 | -6 | 1 |
112 | 8 | -6 | 2 |
113 | 9 | -6 | 3 |
114 | 10 | -6 | 4 |
115 | 11 | -6 | 5 |
116 | 12 | -6 | 6 |
117 | 13 | -6 | 7 |
118 | 14 | -6 | 8 |
119 | 15 | -6 | 9 |
120 | 16 | -6 | 10 |
121 | 17 | -6 | 11 |
122 | 18 | -6 | 12 |
123 | 19 | -6 | 13 |
124 | 20 | -6 | 14 |
125 | 21 | -6 | 15 |
126 | 22 | -6 | 16 |
127 | 23 | -6 | 17 |
128 | 24 | -6 | 18 |
129 | 25 | -6 | 19 |
130 | 26 | -6 | 20 |
131 | 27 | -6 | 21 |
132 | 28 | -6 | 22 |
133 | 29 | -6 | 23 |
134 | 30 | -6 | 24 |
135 | 31 | -6 | 25 |
136 | 32 | -6 | 26 |
137 | 33 | -6 | 27 |
138 | 34 | -6 | 28 |
139 | 35 | -6 | 29 |
140 | 36 | -6 | 30 |
141 | 37 | -6 | 31 |
142 | 38 | -6 | 32 |
143 | 39 | -6 | 33 |
144 | 40 | -6 | 34 |
145 | 41 | -6 | 35 |
146 | 42 | -6 | 36 |
147 | 43 | -6 | 37 |
148 | 44 | -6 | 38 |
149 | 45 | -6 | 39 |
150 | 46 | -6 | 40 |