I got all the answers, but I am having troubles with the Excel Portion.... I want to know how do the Excel Portion

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 net AW of each system over the service life. b. Calculate the conventional B/C ratio for each of the two systems. c. Use the B/C ratio method to determine the more economical system System1 Systen 2 $140,000 $260,000 Initial Capital Annual Revenues S55,000 80,000 Annual Costs Service life (years) Salvage value $24,000 $36,000 12 12 S16,800 57,200 a. The net AW of System 1 is$13307 (Round to two decimal places.) The net AW of System 2 is $ 12512 (Round to two decimal places.) b. The conventional BiC ratio for System 1 is 1.32. (Round to two decimal places.) The convetional B/C ratio for System 2 is 1.19. (Round to two decimal places.) c. The incremental B/C ratio is 79 (Round to two decimal places.)