An airline is considering the purchase of an Airbus A-220-300 which offers improved fuel efficiency over the previous generation of narrow-body aircraft.The list price of the A-220 is $92 million, but the airline will receive a 30% discount off of list (typical in the airline industry).The finance department estimates the aircraft will generate a positive net cash flow of $6 million in the first year increasing by 5% annually owing to the 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 analysis using Excel and present your recommendations.