Excel Online Structured Activity: NPV profles A company is considering two mutually exclusive expansion pians. Plan A requires a $41 mililon expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan B requires a $12 million expenditure to bulld a somewhat less efficient, more laborintensive plant with an expected cash fiow of $2.69 million per year for 20 years. The firm's WACC is 11%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysts to answer the questions below. Open spreadsheet a. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in miltions. For example, an answer of $10,550,000 should be entered as 10.55. Plan A: 5 million Plan B: 3 Calculate each projects IRR. Round your answer to two decimal places. Plan A: Plan B: b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. c. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. A. Calculate each projects NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in militions. For example, an anwwer of 310,550,000 should be entered as 10,55. Man A1 3 Plan B: 5 Calculate each projects IRR. Round your anwwer to two decimal places. PanA= Plan B: b. By graphing the NpV profiles for Plan A and Pian 8, approximate the crossover rate to the nearest petrcent. c. Calculate the crossover rate where the two projects' NPVs are equal, Round your answer to two decimal places; d. Why is NPV better than 1RR for making capital budgeting decisions that add to shareholder value? The input in the box below will not be graded, but may be reviewed and considered by your instructor. \begin{tabular}{l} File \\ \hline \end{tabular} NPV Profiles