solve in excel

Q.No.2 A company XYZ ltd. is considering which of two mutually exclusive projects it should undertake. The finance director thinks that the project with the higher NPV should be chosen, whereas the managing director thinks that the one with the higher IRR should be undertaken, especially as both projects have the same initial outlay and length of life. The company anticipates a cost of capital of 10%, and the net after tax cashflows of the projects are as follows: Year Project x $000 Project Y $000 (200) 218 0 (200) 1 35 2 80 10 10 3 90 75 4. 4 5 20 3 Required: (a) Calculate the NPV and IRR of each project. (b) Recommend, with reasons, which project you would undertake (if either). (c) Briefly explain the inconsistency in ranking of the two projects in view of the remarks of (03 marks) the directors