A company is considering two imutually exclusive expansion plans. Plan A requires a $41 million expenditure on a largeiscale integrated plant that would provide expected cash flows of $6.55 million per year for 20 yoars. Plan B requires a $13 miltion expenditure to build a somevhat less eflicient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 114 . The data has been collected in the Microsoft Excel Online flle below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spresdsheet a. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate catculations. Enter your answers in millions. For example, an answer of 510,550,000 should be entered as 10.55 . Calculate each project's 1RR. Round your answer to two decimal places. Pian A Pisin 8: 6. By graphing the NPY profiles for Plan A and Plan B1 approximate the crossover rate to the aearest percent. c. Calculate the crossover rate where the two projects' N\$Vn are equal. Round your answer to two decimal places. d. Why is Npy better than thR for malong capital budgeting decisions that add to shareholder value? The input in the bok below wie not be graded, but may be reviewed and considered by your instructor whec NPVProties Catsean of chanw ilat Capiouplika o mine Hurcis Excel Online Structured Activity: NPV profiles A company is considering two mutually exclosive expansion plansi. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan 8 requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cosh flow of 52.91 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 analysis to answer the questions below. Open spreadstheet a. Calculate each project's. NPV: Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in mililons. For example, an answer of $10,550,000 should be entered as 10.55 Phan Ais milison Plan 8:5 miltion Calculate each project's 1RR. Round your answer to two decimal places. Pian A. Pian B: b. By oraphing the NPV profiles for Pian A and Plan B, approximate the crossover rate to the neareat percent: c. Calculate the crossover rate where the two projects' NPVs are equal. flownd your aniwer to two decimal places. d. Why in NIV better than taR for making capital budgeting decisions thst add to shareholder value? The inpout in the bax below wail not be graded, but may be reviewed and considered br your instructor A company is considering two imutually exclusive expansion plans. Plan A requires a $41 million expenditure on a largeiscale integrated plant that would provide expected cash flows of $6.55 million per year for 20 yoars. Plan B requires a $13 miltion expenditure to build a somevhat less eflicient, more labor-intensive plant with an expected cash flow of $2.91 million per year for 20 years. The firm's WACC is 114 . The data has been collected in the Microsoft Excel Online flle below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spresdsheet a. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate catculations. Enter your answers in millions. For example, an answer of 510,550,000 should be entered as 10.55 . Calculate each project's 1RR. Round your answer to two decimal places. Pian A Pisin 8: 6. By graphing the NPY profiles for Plan A and Plan B1 approximate the crossover rate to the aearest percent. c. Calculate the crossover rate where the two projects' N\$Vn are equal. Round your answer to two decimal places. d. Why is Npy better than thR for malong capital budgeting decisions that add to shareholder value? The input in the bok below wie not be graded, but may be reviewed and considered by your instructor whec NPVProties Catsean of chanw ilat Capiouplika o mine Hurcis Excel Online Structured Activity: NPV profiles A company is considering two mutually exclosive expansion plansi. Plan A requires a $41 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.55 million per year for 20 years. Plan 8 requires a $13 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cosh flow of 52.91 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 analysis to answer the questions below. Open spreadstheet a. Calculate each project's. NPV: Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in mililons. For example, an answer of $10,550,000 should be entered as 10.55 Phan Ais milison Plan 8:5 miltion Calculate each project's 1RR. Round your answer to two decimal places. Pian A. Pian B: b. By oraphing the NPV profiles for Pian A and Plan B, approximate the crossover rate to the neareat percent: c. Calculate the crossover rate where the two projects' NPVs are equal. flownd your aniwer to two decimal places. d. Why in NIV better than taR for making capital budgeting decisions thst add to shareholder value? The inpout in the bax below wail not be graded, but may be reviewed and considered br your instructor