Page

Page < aircraft's fuel efficiency- The airline plans to operate the aircraft for 15 years, then sell it in year 16 for an estimated net cash price of $32 million. The airline targets a return on invested capital of 10% annually (use this rate rather than the interest rate to discount future cash flows). Note: This computation is easiest to perform using MS Excel- -Develop a discounted cash flow analysts using Excel and present your recommendatjonsw Copy and paste the Excel spreadsheets into your problem set answers (do not just use Excel's built-in formulas)- 'There are many Excel formats that could be used, including a built-in template. Here is one format that can be usecL NCF Imillions Discount PV(millions Year S) Factor 10 11 12 13 14 IS a. DJs the Is the A-220neo a good investmeot fort e lfline (the NPV ot the cast-flows is positiiveY? iih!Compleieifte foflopingtai?le' nd snWrteaccotppenving questions- Note: The ijmj;sing. Variables} be omputecl LIEjng the mathematcel definitio This i $0' pl paste the resumng table tnto tms