1. Real Options

A. JTM is looking to buy gates at their home airport. Its discount rate is 7%; the risk free rate is 2.5%. What is the NPV of the purchase if bought today? Use the data in the template and note that the terminal value is as of the end of year 6.

B. After you do part A, you remember back to the concept of real options, which means that JTM can make dynamic changes as time passes:

1. Present valuing the purchase price of the gates (that is, the years 1 and 2 Capital Expenditures) separately using the risk-free rate because once JTM decides to go with the purchase there is no risk.

2. Present valuing the Net Cash Flow excluding those Cap Ex. This calculation will include Cap. Ex. For years 3-6 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 1-year maturity and a 20% price volatility for gate prices.

4. Compare the price of the call option with the NPV in the No Real Options scenario. Is the option worth it?

File Horne Insert Draw Page Layout Formulas Data Review Vien Help Acrobat Camments Share AA === Wrap Text Custom E. Times New Roman - - 12 B TUBO AutoSum FI - 49 Posto Copy == +E + Morge & Center $ % 98 99 % Insert Delta Format I Fomat Painter Cipboard Canditional Formatas CHI Formatting Wale Styles Sort Find a Filtar Select Analys Data Linda Fort Alignme Numbo Sys CH Editing Analysis 4 E T G II I J K L M N 0 6 3 3.8 37 4 4.6 4. 5 5.3 52 6.1 60 50 Option Pricing: PV of Cap. Ex. (Yrs. 1-2) Maturity PV of NCF Risk free rats Volatility BS calculations: di N(d) d2 N(D2) Price of call Difference: - Value of Call over No Real Option -% of PV of No Real Option #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! /0 0 5 A B C D 1 JTM Z Rates: 3 Discount rate 7.0% 4 Risk-free rate 2.5% 5 Scenario: No Real Options 6 Start 1 2 2 7 Cash from Operations 2.3 3.1 8 minus: Capital Expenditures 1.0 2.2 3.0 9 = Net Cash Flow 10 Terminal Value 11 PV of NCF 12 12 Scenario: Real Options 13 Start 1 2 14 Cash from Operations 2.3 3.1 15 minus: Capital Expxenditures 1.0 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 Prob. 1 Prabs. 2 JAN 22 JAN 22 Festty 3 3.8 4 4.6 45 6 6.1 6.0 3.2 52 5.0 Answer part B, 4 in the hox helow play Settings 1224 8.57 AM 1/30/2022 I R