PLEASE DO NOT USE EXCEL TO SOLVE THIS QUENTION. DO IT MANUALLY.

Sane Bhd is considering 3 capital investment projects. The firm, having a 15% cost of capital and has estimated that after tax cash flows for each project are as follows:

a) Calculate the NPV of each project

b) Calculate the IRR of each project

c) Calculate the payback period for each of the project. What would you advise if the firms maximum desired payback period is 3 years?

d) Based on the NPV and IRR above, analyze the acceptability of each project if: i) Project X and Y are mutually exclusive ii) All three projects are independent

Project X Project Y Project Z RM RM RM Initial investment 50,000 100,000 450,000 Year 1 32,000 200,000 10,000 15,000 2 32,000 200,000 3 20,000 32,000 200,000 4 25,000 32,000 5 30,000 32,000