Problem: Simon Company is considering two investments, Project A and Project B They require a 9% return from investments The initial investment for Project A is $250,000 The initial investment for Project B is $525,000 The expected cash flows from each project are below a. Compute the NPV for each project Use the NPV formula in excel. b. Compute the profitability index for each project. c. Compute IRR for each project. Use the IRR formula in excel to solve d. Which project do you recommend? Project A 115,000 94,000 75,000 52,000 47,000 Project B 170,000 145,000 115,000 98,000 75,000 Year 4