Use the spreadsheet from the Excel Application model to answer these questions. a. Plot the payoff and profit diagrams to a straddle position with an exercise (strike) price of $1:30. Assume the options are priced as they are in the Excel Application b. Plot the payoff and profit diagrams to a spread position with exercise (strike) prices of $120 and $130 Assume the options are priced as they are in the Excel Application. Chapter 15 Problem 17 Student Name: Course Name: Student ID: Course Number Use the Excel Applications model below to answer each question. The data for the payoff diagram is created. Use the Data Table Function For help with the Data Table function go to Office Online Create the Payoff Diagram and post below Stock Prices Beginning Market Price Ending Market Price 116.5 130 Ending Buying Options: Stock Price X 130 Straddle Profit -37.20 Call Options Strike Price Payoff Profit Return % 50 110 22.80 20.00 2.80 -12.28% 60 120 16.80 10.00 6.80 40.48% 70 130 13.60 0.00 -13.60 -100.00% 80 140 10.30 0.00 -10.30 -100.00% 90 100 Put Options Strike Price Payoff Profit Return % 110 110 12.60 0.00 -12.60 -100.00% 120 120 17.20 0.00 -17.20 -100.00% 130 130 23.60 0.00 23.60 -100.00% 140 140 30.50 10.00 -20.50 67.21% 150 160 Straddle Price Payoff Profit Return % 170 110 35.40 20.00 -15.40 43.50% 180 120 34.00 10.00 -24.00 -70.59% 190 130 37.20 0.00 -37.20 -100.00% 200 140 40.80 10.00 30.80 -75.49% 210 Selling Options: Bullish Call Options Strike Price Payoff Profit Return % Ending Spread 110 22.80 -201 2.80 12.28% Stock Price 6.80 120 16.80 -10 6.80 40.48% 50 130 13.60 0 13.60 100.00% 60 140 10.30 0 10.30 100.00% 70 80 Put Options Strike Price Payoff Profit Return% 90 110 12.60 0 12.60 100.00% 100 120 17.20 17.20 100.00% 110 130 140 23.60 0 23.60 100.00% 120 30.50 10 40.50 132.79% 130 140 Money Spread Price Payoff Bullish Spread Cell Ref Cell Ref Combined Proft Profit -6.80 13.60 0.00 150 160 170 180 6.80 190 200 210 Post your Payoff Diagram here