Bucker Company in considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 ovor 10 years. Buckner requires a 16% rase of retum on this type of investment. Expectod net eash infows are as follows (Cick the icon to view the expected net canh intlows ) Fesd the roguremests Requirement 1. Use Excel to compute the NPV and IRR of the two plans. Which plati, if any, ehould the company pursue? (Use parentheses or a minus sign for a negative NPV Round the NPV callodlatons to the nearest whole dollar and the iRR colovilations to tho decimal places, x0. The NPV (net present valve) of Plan Alpha is The NPV (net prevent value) of Plan Beta is Requirements 1. Use Eicel to compule the NPV and IRA of the two plane. Which plan, t agy whoula the compacy gursue? 2. Explain the relationship between NPV and SFF. Based en this relugorship and the comparye recurod rate of cetam, are your anwere as expected in Requienent i7 Why or why not? 3. Aher Noter negotisting, the conpany can now invest with an intiw cost of Ehavild the oceroeny pirsue