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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!