Round your answers to the nearest integer. Pioneer Pte Ltd is considering two mutually exclusive projects shown as follows: Year 1 2. Project Rhodium 21,000 22,000 19,000 12,000 9,000 Project Iridium 20,000 20,000 35,000 30,000 10,000 3 4 5 The initial cash outlay for Project Rhodium and Project Iridium is $55,000 and $76,000 respectively. Assume the discount rate for both projects to be 10%. Fill in values of Cells B2:C2 in the Excel table below. Solve for the net present value (NPV) and internal rate of return (IRR) for both projects. Appraise which project should be accepted. You are expected to show the relevant Excel formulas. A B Project Rhodium Project Iridium Year 1 2 0 3 1 4 2 3 5 6 7 21,000 22,000 19,000 12,000 9,000 20,000 20,000 35,000 30,000 10,000 4 5