Please do in Excel

Potable (drinkable) water is in short supply in many countries. To address this need, two mutually exclusive systems to purify water are being considered for implementation in one country by Engineers without Borders. Doing nothing is not an option. Refer to the data below and state your key assumptions in working this problem. Use a MARR of 10%. Capital Investment Annual Revenues Annual Expenses Market Value at End of Life Useful Life $100,000 $48,000 $24,000 $18,000 5 years $150,000 $65,000 $35,000 10 years 4. Select the best option using Rate of Return Analysis. You must present the IRR for each individual alternative as well as the incremental computations required along the way for each alternative. Compute the IRR for each option and the incremental computations using the Excel function to 4 decimal places (i.e. 0.245 = 2.45%). 5. Select the best option using the Payback method. You must compute the payback period for each option