Excel Assessment A company is considering three mutually exclusive projects for its expansion plans. The initial investment in the project is OMR 400000. The finance director thinks that the project...

Extracted text: Excel Assessment A company is considering three mutually exclusive projects for its expansion plans. The initial investment in the project is OMR 400000. The finance director thinks that the project with the higher NPV should be chosen, whereas the managing director believes that the higher IRR should be undertaken, especially as projects have the same initial outlay and length of life. The company anticipates a cost of capital of 10.5%, and the net after-tax cash flows of the projects are as follows: Year Cash Flow A Cash Flow B Cash Flow C 1 70000 436000 90000 160000 20000 149000 180000 20000 51200 4 150000 8000 100000 5 40000 6000 49400 (All amounts are in OMR) Required: (a) Calculate the NPV, IRR, and MIRR of each project. (6)