P4. The following information pertains to expected cash flows from two investment projects: Instructions: Use Excel, if possible, to do the followings. The discount rate is 10%. 1. Compute the NPV of the X and the NPV of Y. 2. Select the better between X and Y using the NPV method. 3. Compute the Payback period of the X and the Payback period of Y. 4. Select the better between X and Y using the payback method. 5. Compute the IRR of the X and the IRR of Y. 6. Select the better between X and Y using the IRR method.|