EXCEL ONLY

Consider the projects described in the table below: End of Year 0 1 2 3 4 5 6 7 8 9 10 Project R Cash Flow (S) $90,000 17,000 17,000 17,000 17,000 17,000 17,000 17,000 17,000 17,000 17,000 Project S Cash Flow ($) $-90,000 0 0 0 0 0 34,000 34,000 34,000 34,000 90,000 Both projects have an appropriate risk adjusted discount rate of 7 percent. Required: a. Calculate the NPV and IRR for both projects b. If projects R and S are independent, which will you undertake? c. If projects R and S are mutually exclusive, which will you undertake