Question

The city of Pawnee is considering the addition of a splash fountain to its recreation center....

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%?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Pls see table below for calculations. B/C Ratio is 4.59

Benefit / 1.03^Time
Time Investment Annual Benefit Annual Cost Net Benefit Cost PV
0 -5,00,000.00 5,00,000.00
1 2,00,000.00 -35,000.00 1,65,000.00    1,60,194.17
2 2,00,000.00 -36,050.00 1,63,950.00    1,54,538.60
3 2,00,000.00 -37,131.50 1,62,868.50    1,49,047.75
4 2,00,000.00 -38,245.45 1,61,754.56    1,43,716.83
5 2,00,000.00 -39,392.81 1,60,607.19    1,38,541.17
6 2,00,000.00 -40,574.59 1,59,425.41    1,33,516.27
7 2,00,000.00 -41,791.83 1,58,208.17    1,28,637.72
8 2,00,000.00 -43,045.59 1,56,954.41    1,23,901.26
9 2,00,000.00 -44,336.95 1,55,663.05    1,19,302.76
10 2,00,000.00 -45,667.06 1,54,332.94    1,14,838.20
11 2,00,000.00 -47,037.07 1,52,962.93    1,10,503.67
12 2,00,000.00 -48,448.19 1,51,551.81    1,06,295.39
13 2,00,000.00 -49,901.63 1,50,098.37    1,02,209.69
14 2,00,000.00 -51,398.68 1,48,601.32        98,242.98
15 2,00,000.00 -52,940.64 1,47,059.36        94,391.81
16 2,00,000.00 -54,528.86 1,45,471.14        90,652.81
17 2,00,000.00 -56,164.73 1,43,835.27        87,022.71
18 2,00,000.00 -57,849.67 1,42,150.33        83,498.34
19 2,00,000.00 -59,585.16 1,40,414.84        80,076.62
20 2,00,000.00 -61,372.71 1,38,627.29        76,754.57
Total 5,00,000.00 22,95,883.32
B/C Ratio                  4.59
Add a comment
Know the answer?
Add Answer to:
The city of Pawnee is considering the addition of a splash fountain to its recreation center....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Problem (2): A city is considering upgrading a dump area (landfill) to meet the environment standards....

    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...

  • Q1.A local government is considering promoting tourism in the city. It will cost S5,000 to develo...

    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...

  • .A city government is considering increasing the capacity of the current wastewater treatment plant. The estimated...

    .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.

  • A large city is considering two transportation projects to address its traffic congestion. The first one...

    A large city is considering two transportation projects to address its traffic congestion. The first one is a light-rail system while the second one is a new highway. Some economic data on both are presented below: Operating cost, First cost, million S millionShyear Project Light-rail system 45 8.5 Highway 73 In addition, the expected benefits from reduction in air pollution are $25 million per year in the case of the light-rail system and $22 million per year in the case...

  • the benefits are also per year The city of Ottawa is considering to build a new...

    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...

    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 p...

    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...

  • Your county is considering building a public recreation center. Analysts have estimated the present values of...

    Your county is considering building a public recreation center. Analysts have estimated the present values of the impacts over the expected useful life of the center as listed below. Present Value (millions of dollars) County perspective Global perspective Impact Amount B/C/T/NS Amount B/C/T/NS State Grant to County 5 Construction and maintenance costs 15 Personnel costs 8 Revenue from county residents admission fee 9 Revenue from non- residents admission fee 3 Monetized value of benefits to county residents 16 Monetized value...

  • AThe city of Munich decides to urban an area for a new MERICAN ITshopping center. The...

    AThe city of Munich decides to urban an area for a new MERICAN ITshopping center. The costs of the land for the future parking places can be purchased for $400,000. The costs for the new roads are $560,000 and the annual maintenance expenses are $22,000. A new train station will cost $240,000. The annual operating costs for the train station are estimated to $175,000. KUWAIT The benefits are Tax from the shopping center $400,000/year Fee from the parking area $90,000/year...

  • The Town of Pawnee recently sent a survey to each of the residents asking them how...

    The Town of Pawnee recently sent a survey to each of the residents asking them how much they would be willing to pay for each acre of a proposed park. The results of the survey are shown below. # of Acres Ann Leslie Tom Ron 100 $400 $1000 $50 $0 200 $600 $1500 $30 $0 300 $400 $2000 $20 $500 400 $200 $2500 $10 $0 500 $100 $3000 $0 $0 (3 points) Assuming that creating the park costs $5/acre (or...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT