.A city government is considering increasing the capacity of the current wastewater treatment plant. The estimated financial data for the project are as follows: Description Cash flow Capital investment $1,500,000 Project life 25 years Incremental annual benefits $180,000 Incremental annual costs $75,000 Salvage value $35,000 Discount rate 6% Calculate the benefit-cost ratio for this capacity expansion project.
Capital Investment = $1,500,000
Incremental annual benefits = $180,000
Incremental annual costs = $75,000
Salvage value = $35,000
Discount Rate = 6%
Project life = 25 years
Present worth of annual Benefits = $180,000 (P/A, 6%, 25)
Present worth of Benefits = $180,000 (12.7834) = 2,301,012
Present worth of cost
PW of capital investment = Capital investment – PW of Salvage value
PW of capital investment = $1,500,000 – $35,000 (P/F, 6%, 25)
PW of capital investment = $1,500,000 – $35,000 (0.2330) = 1,508,155
PW of Incremental annual costs = $75,000 (P/A, 6%, 25)
PW of Incremental annual costs = $75,000 (12.7834) = 958,755
Benefit cost Ratio = 2,301,012 / 1,508,155 + 958,755 = 0.93
Benefit cost ratio < 1- Reject the Project or investment
.A city government is considering increasing the capacity of the current wastewater treatment plant. The estimated...
A major city in Eastern Canada is planning to build a new wastewater treatment plant to accommodate the increasing water consumption of the city, Plant construction will start in 2018 and is going to take five years at a cost of $30 million per year. After construction is completed, the cost of operation, maintenance is expected to be $2 million for the first year, and to increase by 1% per year thereafter. The salvage/scrap value of the wastewater treatment plant...
Use Microsoft Excel formulas to answer the following
question:
Q1.A local government is considering promoting tourism in the city. It will cost S5,000 to develop the plan. The anticipated annual benefits and costs are as follows: Annual benefits: Annual support service: Parking lot expansion, S41,350 Increased local income$98,400 and tax collections rest room, patrol car, and street repar If the city government uses a discount rate of 6% and a study period of 5 years, is this tourism project justifiable...
The city of Pawnee is considering the addition of a splash fountain to its recreation center. The splash fountain will have an initial cost of $500,000. The annual expenses will be $35,000, increasing by 3% per year. The benefits are estimated to be $200,000 per year through increased tourism. The splash fountain has an estimated useful life of 20 years. What is the benefit-cost (B/C) ratio of this project if the city uses a MARR of 3%?
Spacely Sprockets is considering increasing its production of sprockets at its Orbit City plant. You have been provided the following pieces of information on this ten year project. The expansion will require the purchase of machinery costing $50,000,000. The firm has spent $750,000 to train workers to use the new machinery. If the project is accepted, the firm expects to spend an additional $350,000 in training costs payable today (t=0). The sales from this project will be $20,000,000 per year....
Problem (2): A city is considering upgrading a dump area (landfill) to meet the environment standards. The project planning horizon is 12 years and MARR is 12%. The following data are available for this project: First cost $650,000 Annual Net benefits Operating & Maintenance costs (O&M) Annual Savings (generated from collecting dump fees from households & businesses) $120,000 $35,000 in the first year, increasing by $8,000 each year thereafter $100,000 a) Compute the benefit-cost ratio (BCR) for this project. Is...
the
benefits are also per year
The city of Ottawa is considering to build a new toll highway that spans from Orleans to Kanata, the project cost is estimated to be $90,000,000 and is to be paid in 3 equal payments (Payment 1 before commencement, Payment 2 at the end of the 1t year and Payment 3 at the end of 2nd year when the construction is done). The feasibility assessment of this project is 25 years after construction. This...
The city of Ottawa is considering to build a new toll highway that spans from Orleans to Kanata, the project cost is estimated to be $90,000,000 and is to be paid in 3 equal payments (Payment 1 before commencement, Payment 2 at the end of the 1st year and Payment 3 at the end of 2nd year when the construction is done). The feasibility assessment of this project is 25 years after construction. This highway benefits the city a total...
Question 2 (30%) The city of Ottawa is considering to build a new toll highway that spans from Orleans to Kanata, the project cost is estimated to be $90,000,000 and is to be paid in 3 equal payments (Payment 1 before commencement, Payment 2 at the end of the 1st year and Payment 3 at the end of 2nd year when the construction is done). The feasibility assessment of this project is 25 years after construction. This highway benefits the...
Assume salvage value is 70% of the initial investment and the
interest rate is 12%
ncremental Benefit-Cost Analysis 4 The U.S. government is considering building apartments for its employees working in a foreign country and currently living in locally owned housing. A comparison of two possible buildings indicates the following: Original investment by government agencies Estimated annual maintenance costs Savings in annual rent now being paid to BuildingX $8,000,000 $240,000 $1,960,000 Building Y $12,000,000 $180,000 $1,320,000 house employees Assume the...
Benefit-Cost Analysis Table Road Project Analysis Government XYZ is considering the addition of a tool road segment to the regional road system. The projected costs and benefits for it has been estimated and converted into monetary units. The resulting data is outlined in the Table below. Furthermore, the discount rate has been determined to be 7% based on the entity’s weighted average cost of capital (WACC). Based on a benefit-cost analysis, determine whether this “pilot project” will provide a net...