How need to answer the misisng info. Excel formulas.

c 2 Rates: 3 Discount rate 4 Risk-free rate 6 7 Cash from Operations minus: Capital Expenditures 9 = Net Cash Flow (NCF) 10 Temlinal Value 11 PV of NCF 12 13 14 Cash from Operations 15 minus: Capital Expenditures 16 - Net Cash Flow (NCF) 17 Temlinal Value 18 PV of NCF 19 PVofCap_ Ex. (Yrs. 1-2) 20 21 B Start (4.0) 86.3 Start (4.0) 94.7' D Zion Aviation E G Scenario: No Real Options 6.0 so 1.0 6.0 6.0 2 5.0 2.0 3 8.5 4.5 4 8.5 5.0 3.5 Scenario: Real Options 2 7.0 7.0 3 8.5 4.5 4 5.0 3.5 5 so 4.0 5 5.0 4.0 H 6 5.0 6.0 6 11.0 5.0 6.0 7 12.0 5.0 7.0 11.0 7 12.0 7.0 11.0 Option Pricing: PV ofCap_ Ex_ (Yrs. 1-2) PV of NCF Risk free rate Volatity BS calculations: dl N(dl) N(d2) Price of call Difference: Value of Option over PV 0/0 ofPV 94_7 6_71 1.00 6.31 1.00 87.68