Excet Online Structured Activity: NPV profiles A company is considering two mutually exclusive expansion plans. PAan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6,39 milion per year for 20 years. Plan 8 requires 3$13 million expenditure to build a somewhat less etficient, more labor intensive plant with an expected cash flow of 92.91 million per year for 20 years. The firm's WaCC is 10 th. The data has been collected in the Microsoft Excel Online fale below. Open the spreadsheet and perform the required analycis to answer the questions below. Open spreadsheet a. Calculate each projeck's NP. Round your answers to two decimal places, Do not round vour intermediate calculations. Fnter your answers in milions, For example, an answer of $10,550,000 should be entered as 10,55 , Pan A: 5 millien Plan Bis mill on Calcialate each broject's 1ith, Round your ans ver to two decinal places. pinhA than t: Calculate each project's IRR. Round your answer to two decimal places. Plan A: Plan B: b. By oraphing the RPV profiles for Plan A and PLanB, approximate the crossover rate to the nearest percent. c. Calculate the crossover rate where the two prolects' Nops are equal. Round your answer to two decimal places. d. Why is NPV better than tret for making capital budgeting decisions that add to shareholder value? The input in the box below mill not be graded, but may be reviewed and considered by your instructor