round to 2 decimal places, need help on homework

n, if any, should the company pursue? (Use parentheses or a minus sign for a negative NPV Round Data Table i Requirements 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any." should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $9,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Mpha 500,000 300,000 500,000 300,000 500,000 500,000 500,000 500,000 500,000 T600,000 16,000,000 Print Done 10 $ Total Il 3 of 3 (0 complete) Question Help ost of $10,000,000 and total net cash inflows of $16,000,000 over 10 years Foreman requires a 10% rate of return on this type of investment Expected of cash inflows ny, should the company pursue? (Use parentheses or a minus sign for a negative NPV Round the NPV calculations to the nearest whole door and the IRR calculations to Data Table - X Year 1 Plan Alpha 1,600.000 S 1,600,000 1.600.000 1 600 000 1.600.000 1.600.000 1,600,000 1,600,000 1.600.000 1 500 000 5 16 000 000 $ Plan Beta 1000.000 2,300,000 3.000.000 2.300.000 1 600.000 1.200.000 1.100.000 1.000.000 900,000 1,000,000 16.000.000 10 Total Check