50.1K

Verified Solution

Link Copied!

(Only need help with question 4. The rest is for context)

JTM Airlines, where you work, is looking at potentially buying more gates at their home airport. If it pays the airport $1M, JTM will hold exclusive rights to buy those gates for $8M (at the start) and $9M (one year later) at any time in the next 3 years. The option expires at the end of year 3. JTM's discount rate is 6.6% and the risk free rate is 2%. What is the NPV of the gate purchases if it bought them today? Use the data in the Excel template provided.b.After you run the numbers for part A, you remember back to your ERAU corporate finance class's coverage of real options. You know that the 3-year option has value, so you decide to calculate it by:

1.Present valuing the purchase price of the gates separately using the risk-free rate. Once JTM decides to go ahead with the purchase, there is no risk to that expenditure.

2.Present valuing the Net Cash Flow excluding those purchase prices. This calculation will include Cap. Ex. for years 3-15 as they are part of the normal operation of the gates and are unrelated to the purchase price.

3.Use the Black-Scholes Option Pricing formula to come up with option's price assuming a 5-year maturity and a 55% price volatility for gate prices.

4.Compare the price of the call option as calculated using the BSO formula with the NPV in the No Real Options scenario. With this, you can decide whether or not the $1M option is worth it. Is it? What is the value of the option over not taking it? What is it net of the $1M cost?

B C D E F I J K L M M N R S T U V W G H JTM Airlines 6.6% 2.0% 10 4 6.8 1 5.0 8.0 (3.0) 3 6.2 2.0 2 5.6 9.0 (3.4) 5 7.4 2.6 11 11.0 Scenario: No Real Options 6 7 8 2 8.0 8.6 9.2 9.8 2.9 3.2 3.5 3.8 5.1 5.4 5.7 6.0 10.4 4.1 12 11.6 4.7 13 12.2 5.0 14 12.8 5.3 15 13.4 5.6 2.3 4.4 4.2 4.5 4.8 6.3 6.6 6.9 7.2 7.5 7.8 55.0 58.4 1 5.0 2 5.6 A 1 2 Rates: 3 Discount rate 4 Risk-free rate 5 6 7 Cash from Operations 8 minus: Capital Expenditures 9 Net Cash Flow 10 Terminal Value 11 PV of NCF 12 13 14 Cash from Operations 15 minus: Capital Expenditures 16 - Net Cash Flow 17 Terminal Value 18 PV of NCF 19 PV of Cap. Ex. (Yrs. 1-2) 20 21 22 23 24 25 26 27 28 29 30 3 6.2 2.0 4 6.8 2.3 5 7.4 2.6 6 8.0 2.9 Scenario: Real Options 7 8 2 8.6 9.2 9.8 3.2 3.5 3.8 5.4 5.7 6.0 10 10.4 4.1 11 11.0 4.4 12 11.6 4.7 13 12.2 5.0 14 12.8 5.3 15 13.4 5.6 15.4 5.0 73.9 5.0 5.6 4.2 4.5 4.8 5.1 6.3 6.6 6.9 7.2 7.5 7.8 55.0 2.0% 55% 73.9 15.4 Option Pricing: PV of Cap. Ex. (Yrs. 1-2) Maturity PV of NCF Risk free rate Volatility BS calculations: d1 N(dl) d2 N(D2) Price of call Difference: - Value of Option over PV - % of PV 1.97 0.98 0.74 0.77 61.3 45.9 297% Text answer here. B C D E F I J K L M M N R S T U V W G H JTM Airlines 6.6% 2.0% 10 4 6.8 1 5.0 8.0 (3.0) 3 6.2 2.0 2 5.6 9.0 (3.4) 5 7.4 2.6 11 11.0 Scenario: No Real Options 6 7 8 2 8.0 8.6 9.2 9.8 2.9 3.2 3.5 3.8 5.1 5.4 5.7 6.0 10.4 4.1 12 11.6 4.7 13 12.2 5.0 14 12.8 5.3 15 13.4 5.6 2.3 4.4 4.2 4.5 4.8 6.3 6.6 6.9 7.2 7.5 7.8 55.0 58.4 1 5.0 2 5.6 A 1 2 Rates: 3 Discount rate 4 Risk-free rate 5 6 7 Cash from Operations 8 minus: Capital Expenditures 9 Net Cash Flow 10 Terminal Value 11 PV of NCF 12 13 14 Cash from Operations 15 minus: Capital Expenditures 16 - Net Cash Flow 17 Terminal Value 18 PV of NCF 19 PV of Cap. Ex. (Yrs. 1-2) 20 21 22 23 24 25 26 27 28 29 30 3 6.2 2.0 4 6.8 2.3 5 7.4 2.6 6 8.0 2.9 Scenario: Real Options 7 8 2 8.6 9.2 9.8 3.2 3.5 3.8 5.4 5.7 6.0 10 10.4 4.1 11 11.0 4.4 12 11.6 4.7 13 12.2 5.0 14 12.8 5.3 15 13.4 5.6 15.4 5.0 73.9 5.0 5.6 4.2 4.5 4.8 5.1 6.3 6.6 6.9 7.2 7.5 7.8 55.0 2.0% 55% 73.9 15.4 Option Pricing: PV of Cap. Ex. (Yrs. 1-2) Maturity PV of NCF Risk free rate Volatility BS calculations: d1 N(dl) d2 N(D2) Price of call Difference: - Value of Option over PV - % of PV 1.97 0.98 0.74 0.77 61.3 45.9 297% Text answer here

Answer & Explanation Solved by verified expert

See Answer