please use excel

Potable water is in short supply in many developing countries. To address this need, two mutually exclusive water purification systems are being considered for implementation in a developing country. Doing nothing is not an option. The MARR is 8% per year. Use EXCEL to answer the following questions: a. Calculate the discounted payback period for each system. b Calculate the net AW of each system over the service life. c. Calculate the conventional B/C ratio of each of the two systems. d. Use the B/C ratio method to determine the more economical system. Initial Capital Annual Revenues Annual Costs Service life (years) Salvage value System 1 System 2 $140,000 $240,000 $90,000 $24.000 $44,000 $50,000 10 10 $16.800 $52.800 a. The discounted payback period for System 1 isyears (Round to one decimal place.) The discounted payback period for System 2 isyears (Round to one decimal place.) b. The net AW of System 1 is $ (Round to the nearest dollar.) The net AW of System 2 is Round to the nearest dollar.) c. The conventional B/C ratio for System is(Round to two decimal places.) The conventional B/C ratio for System 2 is (Round to two decimal places.) d. The incremental B/C raio isRound to two decimal places.) Therefore, Systemis more economical than System