Question: please use excel give me ans in 10 mins I will thumb you up Question 2 (10 points) Calculate the payoff and Profit/Loss given the

please use excel give me ans in 10 mins I will thumb you up
Question 2 (10 points) Calculate the payoff and Profit/Loss given the information below (2 points each): CALL PUT Exercise Price Mar 2021 Apr 2021 May 2021 Mar 2021 Apr 2021 May 2021 90 8.00 10.00 17.00 1.50 5.50 10.00 95 5.00 9.00 14.00 2.75 8.00 14.00 100 3.00 6.50 10.00 5.50 12.00 17.00 105 2.00 5.00 8.00 8.00 15.00 22.00 110 1.20 3.00 6.00 11.50 19.00 28.00 115 1.00 2.50 4.00 15.00 24.00 32.00 Action Option Exercise Prices Premiums (Calc the net amount) Stock Price 95 Buy Bull Call Mar Spread -3.00 120 105 100 Buy Bull Put Apr Spread 7.00 90 110 90 Buy Bear Put May Spread - 18.00 100 110 90 Long Butterfly Call May Spread -3.00 115 110 105 Short Butterfly Call Mar Spread 0.60 130 115 Question 2 (10 points) Calculate the payoff and Profit/Loss given the information below (2 points each): CALL PUT Exercise Price Mar 2021 Apr 2021 May 2021 Mar 2021 Apr 2021 May 2021 90 8.00 10.00 17.00 1.50 5.50 10.00 95 5.00 9.00 14.00 2.75 8.00 14.00 100 3.00 6.50 10.00 5.50 12.00 17.00 105 2.00 5.00 8.00 8.00 15.00 22.00 110 1.20 3.00 6.00 11.50 19.00 28.00 115 1.00 2.50 4.00 15.00 24.00 32.00 Action Option Exercise Prices Premiums (Calc the net amount) Stock Price 95 Buy Bull Call Mar Spread -3.00 120 105 100 Buy Bull Put Apr Spread 7.00 90 110 90 Buy Bear Put May Spread - 18.00 100 110 90 Long Butterfly Call May Spread -3.00 115 110 105 Short Butterfly Call Mar Spread 0.60 130 115
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
