In: Finance
Here are some data on DCRB options as of May 14. Current stock price is $125.94, expirations are May 21, June 18, and July 16, and the risk-free rates are 0.0447, 0.0446, and 0.0453 respectively.
CALLS PUTS
| 
 Exercise Price  | 
 May  | 
 June  | 
 July  | 
 May  | 
 June  | 
 July  | 
| 
 120  | 
 8.75  | 
 15.40  | 
 20.90  | 
 2.75  | 
 9.25  | 
 13.65  | 
| 
 125  | 
 5.75  | 
 13.50  | 
 18.60  | 
 4.60  | 
 11.50  | 
 16.60  | 
| 
 130  | 
 3.60  | 
 11.35  | 
 16.40  | 
 7.35  | 
 14.25  | 
 19.65  | 
Draw a payoff diagram, and calculate the maximum loss, maximum gain, and breakeven for each of the following strategies.
Question 1: A call bull spread strategy: long the June 125 and short the June 130 calls.
Question 2: A put bear spread: long the June 130 put and short the June 125 put.
Question 3: Buy the stock at $125.94, buy the July 120 put for $13.65, and sell a call that has the same price, $13.65. But no such call exists! It turns out that I can “create” such a call if its exercise price were $136.165. [Hint: this is a collar.]
1. A call bull spread Strategy
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

2. A put bear spread
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

3. Collar Strategy
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.