using the attached docs please fill in the spreadsheet in excel, I do not know the formulas so if you can attach a spreadsheet that would be great

the data is in the 2 doc that is attached, what other data do you need?

Formatting Table Clipboard Font Alignment Number G Styles D21 fo B D E F G H I J K L M A 4 Discount rate 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 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