Question

In: Economics

Suppose a municipality is proposing to upgrade its municipal water treatment plant to reduce pesticide contamination...

Suppose a municipality is proposing to upgrade its municipal water treatment plant to reduce pesticide contamination of its water supply to a level that does not adversely affect human health. The new plant would be constructed over the course of the initial year (year “0”) at a cost of $15 million. Once the plant begins operating in year “1”, estimated operating and maintenance costs of $3 million will be incurred per year for the life of the plant which is 12 years, and estimated accrued benefits will be $5 million per year. Conduct a benefit-cost analysis to determine whether this project should be considered feasible at a discount rate of 5%. What about a discount rate of 10%? Use Excel to save much time and effort. I have provided a template that you could use. If you prefer to do calculations manually you can complete the table below. Year Benefits Costs Net Benefits in Current Values Net Benefits in Present Values

Solutions

Expert Solution

Present value of initial cost is $15 million

Present value of annual cost of $3 million for 12 years at 5% will be PV = P*(1-(1+r)^-n)/r

= 3*(1-(1+5%)^-12)/5%

= 3*(1-(1.05)^-12)/0.05

= 3*(1-0.5568)/0.05

=3*(0.4432)/0.05

= $26.59

Hence total Present Value of cost = 15+26.59 = $41.59

Present value of annual benefit of $5 million for 12 years at 5% will be PV = P*(1-(1+r)^-n)/r

= 5*(1-(1+5%)^-12)/5%

= 5*(1-(1.05)^-12)/0.05

= 5*(1-0.5568)/0.05

=5*(0.4432)/0.05

= $44.32

Hence Present value of Total Benefits = $44.32

Hence Benefit Cost Ratio = Benefits/ Costs = 44.32/41.59 = 1.066

Since Benefit cost ratio is more than 1 project is feasible for discount rate of 5%

Present value of annual cost of $3 million for 12 years at 10% will be PV = P*(1-(1+r)^-n)/r

= 3*(1-(1+10%)^-12)/10%

= 3*(1-(1.1)^-12)/0.10

= 3*(1-0.3186)/0.10

=3*(0.6814)/0.10

= $20.44

Hence total Present Value of cost = 15+20.44 = $35.44

Present value of annual benefit of $5 million for 12 years at 10% will be PV = P*(1-(1+r)^-n)/r

= 5*(1-(1+10%)^-12)/10%

= 5*(1-(1.1)^-12)/0.10

= 5*(1-0.3186)/0.10

=5*(0.6814)/0.10

= $34.06

Hence Present value of Total Benefits = $34.06

Hence Benefit Cost Ratio = Benefits/ Costs = 34.06/35.44 = 0.96

Since Benefit cost ratio is less than 1 project is not feasible at discount rate of 10%


Related Solutions

10. Suppose a municipality is proposing to upgrade its municipal water treatment plant to reduce pesticide...
10. Suppose a municipality is proposing to upgrade its municipal water treatment plant to reduce pesticide contamination of its water supply to a level that does not adversely affect human health. The new plant would be constructed over the course of the initial year (year “0”) at a cost of $15 million. Once the plant begins operating in year “1”, estimated operating and maintenance costs of $3 million will be incurred per year for the life of the plant which...
A certain municipality is planning to construct a new water treatment plant. The average water requirement...
A certain municipality is planning to construct a new water treatment plant. The average water requirement is equivalent to 123456 m3 /d). The peak flow rate is twice the average flow rate. A jar test experiment revealed the following results: Alum dose: 15 mg/L Temperature: 20 o C Coagulation: G = 850 s-1 , t = 40 s Flocculation: GT =123456 . Settling: t = 1.5 h. a) Determine the size of the coagulation tank (L=2W, W=D) and flocculation tank...
A municipal water treatment plant is designed to produce 20 million gallons per day (MGD) of...
A municipal water treatment plant is designed to produce 20 million gallons per day (MGD) of potable water. The plant treats surface water using coagulation followed by sedimentation, filtration, and chlorination. Although the water is hard, it is not presently softened. The water is coagulated using a 30 mg/L dosage of alum (aluminum sulfate, Al2(SO4)3•14.3H2O, MW = 600). This chemical reacts in water to form Al(OH)3 as follows: Al2(SO4)3 + 6HCO3- → 2Al(OH)3(s) + 3SO4-2 + 6CO2 How many mg/L...
A pump is required for a sewage treatment plant in a municipality. Three options are under...
A pump is required for a sewage treatment plant in a municipality. Three options are under consideration. Applying an interest rate of 7.5%, the pump options data shown below, and the most computationally efficient appropriate engineering economic measure that can be used to compare the cost of the pump options, answer the questions that follow. Option Cost A B C Purchase Cost 56,000 26,000 20,000 First Year Operating Cost 8,000 10,500 11,500 Operating Cost Increase per Period 500 1000 1400...
The Iowa City Water Treatment Plant and the University of Iowa Water Treatment Plant remove calcium...
The Iowa City Water Treatment Plant and the University of Iowa Water Treatment Plant remove calcium hardness (Ca2+) by precipitating (making) CaCO3(s). If, after establishing equilibrium with CaCO3(s), the dissolved Ca2+ concentration is 10 mg/L and the pH is 10.5. a. What is the CO32- concentration in mol/L? b. What is the HCO3- concentration in mol/L? c. What is the alkalinity in mg/L as CaCO3?
The Water Treatment Plant and the University Water Treatment Plant remove calcium hardness (Ca2+) by precipitating...
The Water Treatment Plant and the University Water Treatment Plant remove calcium hardness (Ca2+) by precipitating (making) CaCO3(s). If, after establishing equilibrium with CaCO3(s), the dissolved Ca2+ concentration is 10 mg/L and the pH is 10.5. a. What is the CO32- concentration in mol/L? b. What is the HCO3- concentration in mol/L? c. What is the alkalinity in mg/L as CaCO3?
You are provided the following information about a municipal wastewater treatment plant. This plant uses the...
You are provided the following information about a municipal wastewater treatment plant. This plant uses the traditional activated-sludge process. Assume the microorganisms are 55 percent efficient at converting food to biomass, the organisms have a first-order death rate constant of 0.05/day, have a maximum specific growth rate of 0.1/day, and the microbes reach half of their maximum growth rate when the BOD5 concentration is 10 mg/L. There are 150,000 people in the community (their wastewater production is 225 L/day-capita, 0.1...
Q3. You have been selected to design a secondary wastewater treatment plant for a municipality in...
Q3. You have been selected to design a secondary wastewater treatment plant for a municipality in Amman of 15,000 people which has some industry that discharges wastewater to the municipal sewer system. The average daily wastewater flow is 2.1 MGD (million gallon/d) and the raw sewage entering the WWTP has an average BOD5 of 240 mg/L and average suspended solids of 260 mg/L. If the average domestic per capita sewage flow is 115 gpcd, what is the average flow of...
Suppose that a city has to justify the net benefits of a proposed water treatment plant....
Suppose that a city has to justify the net benefits of a proposed water treatment plant. (A) Name and discuss the importance of the four things that the City must consider in terms of estimating the Present Value of Net Benefits (PVNB). (B) Calculate the PVNB’s from the following information: Year​ 0 ​1​ 2​ 3​ 4​ 5​ 6​ Cost​ 100 ​ 50​ 30​ 20​ 20​ 10​ 10​​ Benefit​ 10​ 20 ​20​ 40​ 100​ 120​ 150​ (i) PVNB (@ 4%) =...
A municipal wastewater treatment plant is designed for COD removal and nitrification. The wastewater characteristics and...
A municipal wastewater treatment plant is designed for COD removal and nitrification. The wastewater characteristics and kinetic coefficients are described in the table below. The aeration tank DO concentration is 2.0 mg/L and MLSS concentration is 2500 mg/L. The temperature is 15C. Assume that the concentration of influent NH4-N that is nitrified accounts for 80% of influent TKN. Calculate the following parameters as a function of SRT (i.e., derive mathematical expressions of the following parameters as a function of SRT,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT