Answer all of the following questions in the Excel. For the following problems assume the effective 6-month interest rate is 2% (i.e., compute the future value) and use these premiums for S&R options with 6 months to expiration:

strike	call	put
$950	$120.405	$51.777
$1,000	$93.809	$74.201
$1020	$84.47	$84.47
$1050	$71.802	$101.214
$1107	$51.873	$137.167

2) Construct payoff and profit diagrams for the purchase of a 950-strike S&R call and sale of a 1000-strike S&R call. Verify that you obtain exactly the same profit diagram for the purchase of a 950-strike S&R put and sale of a 1000-strike S&R put. What is the difference in the payoff diagrams for the call and put spreads? Why is there a difference?