Please answer showing excel formulas :D

1 2. The following cash flows are give for the two mutually exclusive projects X and Y. The project X requires an initial investment of $12,000 in time 'O'and project Y needs an initial investment of $10,000 in time 'o'. Year Project X Project Y $4,500 $9,000 2 6,000 5,000 3 7,500 4.500 4 9,000 3,000 5 5,000 4,000 (a) Calculate the NPV for each project using a discount rate of 12%. (b) State your accept/reject decision (c) What would be your accept/reject decision if they were to be independent projects ? 3. Quattro, Inc. has the following mutually exclusive projects available. The required return is 11 percent. (a) Which project, if any, should the company accept? (Use the NPV method) Year 0 1 2 3 4 5 Cash Flow (A) - $82,000 15.700 18.300 23,900 26.200 32.100 Cash Flow (B) -$125,000 38.600 33.400 31.200 27.500 24.000 (b) Which project, if any, should the company accept assuming that these are independent projects