Transcribed Image Text
10. Suppose a municipality is proposing to upgrade its municipalwater treatment plant to reduce pesticide contamination of itswater supply to a level that does not adversely affect humanhealth. The new plant would be constructed over the course of theinitial year (year “0”) at a cost of $15 million. Once the plantbegins operating in year “1”, estimated operating and maintenancecosts of $3 million will be incurred per year for the life of theplant which is 12 years, and estimated accrued benefits will be $5million per year. Conduct a benefit-cost analysis to determinewhether this project should be considered feasible at a discountrate of 5%. What about a discount rate of 10%? Use Excel to savemuch time and effort. I have provided a template that you coulduse. If you prefer to do calculations manually you can complete thetable below. Year Benefits Costs Net Benefits in Current Values NetBenefits in Present Values 0 1 2 3 4 5 6 7 8 9 10 11 12