Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Use the option prices in the Excel File to create a bull spread using call options with strike prices $155.00 and $160.00. Be sure to

Use the option prices in the Excel File to create a bull spread using call options with strike prices $155.00 and $160.00. Be sure to use the appropriate bid and ask prices.

When you set up the position, the cash inflow is $__; the cash outflow is $__, and the net cash flow is $__.

The maximum profit on the bull spread with calls is $__.

The minimum profit on the bull spread with calls is $__.

The breakeven point on the bull spread with calls is $__.

If at expiration, the price of the underlying stock is $157.30, your profit on the strategy is $__.

image text in transcribed

\begin{tabular}{|r|r|r|r|r|} \hline & \multicolumn{2}{|c}{ Calls } & \multicolumn{2}{l|}{ Puts } \\ \hline Strike & \multicolumn{1}{|l|}{ Bid } & \multicolumn{1}{l|}{ Ask } & \multicolumn{1}{l|}{ Bid } & \multicolumn{1}{l|}{ Ask } \\ \hline 120 & 44.80 & 45.20 & 0.15 & 0.20 \\ \hline 125 & 39.90 & 40.20 & 0.26 & 0.31 \\ \hline 130 & 35.10 & 35.35 & 0.42 & 0.47 \\ \hline 135 & 30.20 & 30.60 & 0.68 & 0.73 \\ \hline 140 & 25.70 & 25.95 & 1.07 & 1.14 \\ \hline 145 & 21.25 & 21.50 & 1.68 & 1.74 \\ \hline 150 & 17.20 & 17.35 & 2.59 & 2.65 \\ \hline 155 & 13.45 & 13.60 & 3.85 & 3.95 \\ \hline 157.5 & 11.70 & 11.90 & 4.65 & 4.75 \\ \hline 160 & 10.15 & 10.30 & 5.55 & 5.65 \\ \hline 162.5 & 8.75 & 8.85 & 6.60 & 6.75 \\ \hline 165 & 7.40 & 7.50 & 7.85 & 7.95 \\ \hline 167.5 & 6.25 & 6.35 & 9.10 & 9.25 \\ \hline 170 & 5.15 & 5.25 & 10.55 & 10.70 \\ \hline 175 & 3.45 & 3.50 & 13.80 & 14.00 \\ \hline 180 & 2.22 & 2.25 & 17.55 & 17.75 \\ \hline 185 & 1.38 & 1.44 & 21.70 & 21.90 \\ \hline 190 & 0.83 & 0.88 & 26.20 & 26.45 \\ \hline 195 & 0.50 & 0.55 & 30.85 & 31.15 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline & \multicolumn{2}{|c}{ Calls } & \multicolumn{2}{l|}{ Puts } \\ \hline Strike & \multicolumn{1}{|l|}{ Bid } & \multicolumn{1}{l|}{ Ask } & \multicolumn{1}{l|}{ Bid } & \multicolumn{1}{l|}{ Ask } \\ \hline 120 & 44.80 & 45.20 & 0.15 & 0.20 \\ \hline 125 & 39.90 & 40.20 & 0.26 & 0.31 \\ \hline 130 & 35.10 & 35.35 & 0.42 & 0.47 \\ \hline 135 & 30.20 & 30.60 & 0.68 & 0.73 \\ \hline 140 & 25.70 & 25.95 & 1.07 & 1.14 \\ \hline 145 & 21.25 & 21.50 & 1.68 & 1.74 \\ \hline 150 & 17.20 & 17.35 & 2.59 & 2.65 \\ \hline 155 & 13.45 & 13.60 & 3.85 & 3.95 \\ \hline 157.5 & 11.70 & 11.90 & 4.65 & 4.75 \\ \hline 160 & 10.15 & 10.30 & 5.55 & 5.65 \\ \hline 162.5 & 8.75 & 8.85 & 6.60 & 6.75 \\ \hline 165 & 7.40 & 7.50 & 7.85 & 7.95 \\ \hline 167.5 & 6.25 & 6.35 & 9.10 & 9.25 \\ \hline 170 & 5.15 & 5.25 & 10.55 & 10.70 \\ \hline 175 & 3.45 & 3.50 & 13.80 & 14.00 \\ \hline 180 & 2.22 & 2.25 & 17.55 & 17.75 \\ \hline 185 & 1.38 & 1.44 & 21.70 & 21.90 \\ \hline 190 & 0.83 & 0.88 & 26.20 & 26.45 \\ \hline 195 & 0.50 & 0.55 & 30.85 & 31.15 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions