in excel

as le possible projects. The required return is 12 percent. howing two Year Project Y Project 2 0 1 2 3 4 -$47,600 23,900 18,600 20,700 14,600 -$81,000 34,000 32,800 30,500 27.300 What is the profitability index for each project? b. What is the NPV for each project? Which, if either of the projects should the c