Robson Company is considering two capital investments. Both investments have an initial cost of $$5,000,000$ and total net cash inflows of $$8,000,000$ over $10$ years. Robson Company requires a $12\%$ rate of return on this type of investment. Expected net cash inflows are as follows:

View the expected net cash inflows.

Read the requirements.

Requirement $1.$ Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? $($Use parentheses or a minus sign for a negative NPV$.$ Round the NPV calculations to the nearest whole dollar and the IRR calculations to two decimal places, X$.$XX$\%.)$

The NPV $($net present value$)$ of Plan Alpha is

The NPV $($net present value$)$ of Plan Beta is

$$

$$ Expected Net Ca$h Inflows

$\backslash$table$[[$Year$,$Plan Alpha,Plan Beta$],[$Year $1,$$$,800,000$$$,1,000,000$