Only solve using excel

A do-nothing and two mutually exclusive alterna- tives are being considered for reducing traffic con- gestion. User benefits come from reduced congestion once the project is complete, while user disbenefits are due to increased congestion during construc- tion. The interest rate is 8%, and the life of each alternative is 15 years. Which alternative should be chosen? Alternative A User benefits (SM/yr) User disbenefits (SM) First cost ($M) Operations and maintenance (SMlyr) 0.75 0.825 2.1 2.6 1.2 2.1 6.9 9.9 (a) Use the benefit-cost ratio (b) Use the modified benefit-cost ratio (c) Use the public/government version of the B/C ratio. ' (d) Assume these numbers apply to a private firm and use a present worth index (e) Are your recommendations for (a) through (d) consistent? Which measure gives the largest value? Why? o What are the generic B/C for each of the three alternatives in this problem? Which alternative you recommend based on your B/C ANALYSIS? (ICF) Which one you recommend based on a present worth analysis