please help with the question, I don't know the formulas to use, please show work in excel doc, thank you

what information are you missing? that is the entire question

Proble... x 212 195% - 5. The Airbus A220 has the following investments in R&D (in millions, all negative cash flows); Year 1: $400M Year 2: $350M Each plane will be sold for $18.5M - 25% down and 75% due on delivery one year later. The cost to produce each plane is $14M - these costs are recognized on delivery. The Sales and Marketing Department says that you will sell 22 planes (year 3), 32 planes (year 4), 52 planes/year (years 5-9), and 77 planes (year 10). What are the NPV (as of the beginning of year 1) AND the IRR of the A220 using an 11% discount rate? Clipboard Formatting Table Font Alignment Number G Styles D21 fo B D E F G H I A 4 Discount rate J K L M 5 Years 6 6 1 2 3 4 5 7 8 9 10 11 7 # of planes sold 8 Investment 9 Revenues 10 Production Costs 11 Cash Flow 12 NPV 13 IRR 14 15 16 17 18 19 20 21 22 23 24 25