I need assistance with solving the empty yellow cells in the attached A B C E 1

I need assistance with solving the empty yellow cells in the attached

Transcribed Image Text:

A B C E 1 2 3 4 5 6 7 8 9 10 JTM pays its C-suite officers with stock options. Treasury asked you to price them. JTM's stock trades at $17.50/share; U.S. Treasurys, aka the risk-free rate, yield 3.40% and stock's volatility is 20%. The details of the stock option offers are below. What are the prices of the options? F G JTM's treasury unit bought jet fuel futures to hedge its expenses. It uses 61M gallons/yr. Each contract runs 42,000 gallons. The contract price locked JTM at $4.7912/gal. At maturity, JTM found that the spot price was $4.7699/gal. In effect, had they not taken the futures, they'd have paid less. What was the profit/(loss) on the contract? H I J K L M N C. JTM's can swap its bonds as per the data below. You are asked to show the cash flows for the fixed and floating scenarios and the net difference each year plus the net overall difference undiscounted and discounted using a 7% discount rate. Show all fixed and floating payments as negative cash flows. Net benefits use the formula: floating payments minus fixed payments. State whether the swap is better or worse in the space provided. 11 a. Option Pricing 12 13 Exercise price 14 Maturity 15 Stock price CEO CFO CIO 31.00 11.0 38.00 8.0 37.00 Gallons 8.0 Gallons/contract # of contracts b. Futures Prices Bond outstanding Maturity (yrs.) Fixed rate c. Interest Rate Swap 900 Fixed Cash Flows Floating Net 30 Year 1 4.25% Year 2 16 Risk free rate 17 Volatility Contract price Spot price Spread over BSTBY 1.25% Year 3 BSTBY: Year 4 18 BS calculations: 19 dl 20 N(dl) 21 d2 22 N(d2) 23 Price of call 24 25 26 27 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! Profit/(Loss) Years 1-2 3.00% Year 5 Years 3-4 3.25% Year 6 Years 5-7 3.55% Year 7 Undiscounted Net Discounted Net A B C E 1 2 3 4 5 6 7 8 9 10 JTM pays its C-suite officers with stock options. Treasury asked you to price them. JTM's stock trades at $17.50/share; U.S. Treasurys, aka the risk-free rate, yield 3.40% and stock's volatility is 20%. The details of the stock option offers are below. What are the prices of the options? F G JTM's treasury unit bought jet fuel futures to hedge its expenses. It uses 61M gallons/yr. Each contract runs 42,000 gallons. The contract price locked JTM at $4.7912/gal. At maturity, JTM found that the spot price was $4.7699/gal. In effect, had they not taken the futures, they'd have paid less. What was the profit/(loss) on the contract? H I J K L M N C. JTM's can swap its bonds as per the data below. You are asked to show the cash flows for the fixed and floating scenarios and the net difference each year plus the net overall difference undiscounted and discounted using a 7% discount rate. Show all fixed and floating payments as negative cash flows. Net benefits use the formula: floating payments minus fixed payments. State whether the swap is better or worse in the space provided. 11 a. Option Pricing 12 13 Exercise price 14 Maturity 15 Stock price CEO CFO CIO 31.00 11.0 38.00 8.0 37.00 Gallons 8.0 Gallons/contract # of contracts b. Futures Prices Bond outstanding Maturity (yrs.) Fixed rate c. Interest Rate Swap 900 Fixed Cash Flows Floating Net 30 Year 1 4.25% Year 2 16 Risk free rate 17 Volatility Contract price Spot price Spread over BSTBY 1.25% Year 3 BSTBY: Year 4 18 BS calculations: 19 dl 20 N(dl) 21 d2 22 N(d2) 23 Price of call 24 25 26 27 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! Profit/(Loss) Years 1-2 3.00% Year 5 Years 3-4 3.25% Year 6 Years 5-7 3.55% Year 7 Undiscounted Net Discounted Net