Please help me solve this.

All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $150,000. The company's board of directors has set a 4-year payback requirement and has set its cost of capital at 9%. The cash inflows associated with the two projects 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. - Data table in order to copy the contents of the data table below (Click on the icon here into a spreadsheet.) Year 1 2 Cash inflows (CF) Project A Project B $45,000 $75,000 $45,000 $60,000 $45,000 $30,000 $45,000 $30,000 $45,000 $30,000 $45,000 $30,000 3 0 0 WN 4 5 6