find the pi for each project and whether it should be accepted or rejected

use the pl to determine which projects the Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, company should accept. X i Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Cash Flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Project A - $1,500,000 $350,000 $350,000 $350,000 $350,000 $350,000 4% Project B - $1,500,000 $400,000 $400,000 $400,000 $400,000 $400,000 8% Project C - $2,000,000 $700,000 $600,000 $500,000 $400,000 $300,000 13% Project D - $2,000,000 $200,000 $400,000 $600,000 $800,000 $1,000,000 18% Discount rate