X i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF) Year (0) 1 2 3 4 5 Project X Project Y $500,000 $290,000 Cash inflows (CF) $100,000 $120,000 $140,000 $140,000 $150,000 $85,000 $210,000 $70,000 $230,000 $40,000 Print Done IRR-Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table The firm's cost of capital is 12% a Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRs. b. Which project is preferred? a. The internal rate of return (IRR) of project X is % (Round to two decimal places.) Is project X acceptable on the basis of IRR? (Select the best answer below.) O No Yes The internal rate of return (IRR) of project is %. (Round to two decimal places.) is project Y acceptable on the basis of IRR? (Select the best answer below) Yes IRR-Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table: The firm's cost of capital is 12%. a Calculate the IRR for each of the projects. Assess the acceptability of each project on the basis of the IRRs. b. Which project is preferred? The mernal rate or returney or project TIS 70. ROTOLO Wo vecmar paces.) Is project Y acceptable on the basis of IRR? (Select the best answer below.) Yes O No b. Which project is preferred? (Select the best answer below.) O A. Neither OB. Project X OC. Project Y Click to select your answer(s)