It says the NPV is not $55,451. Can you please solve for the NPV of Project B and the rest of the problem

(Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, that both cost $150,000. The company's board of directors has set a 4-year payback requirement the cost of capital is 10%. The project cash flows are shown in the following table: a. Calculate the payback period for each project. Rank the projects by payback period. b. Calculate the NPV of each project. Rank the project by NPV. c. Calculate the IRR of each project. Rank the project by IRR. d. Make a recommendation. a. The payback period of project A is years. (Round to two decimal places.) The payback period of project B is years. (Round to two decimal places.) According to the payback method, which project should the firm choose? (Select the best answer below.) A. Project B B. Project A b. The NPV of project A is $67,763. (Round to the nearest cent.) The NPV of project B is $ . (Round to the nearest cent.) (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, that both cost $150,000. The company's board of directors has set a 4-year payback requirement the cost of capital is 10%. The project cash flows are shown in the following table: a. Calculate the payback period for each project. Rank the projects by payback period. b. Calculate the NPV of each project. Rank the project by NPV. c. Calculate the IRR of each project. Rank the project by IRR. d. Make a recommendation. a. The payback period of project A is years. (Round to two decimal places.) The payback period of project B is years. (Round to two decimal places.) According to the payback method, which project should the firm choose? (Select the best answer below.) A. Project B B. Project A b. The NPV of project A is $67,763. (Round to the nearest cent.) The NPV of project B is $ . (Round to the nearest cent.)