A city council has estimated that it has a surplus of $100 Million (M). The council...

A city council has estimated that it has a surplus of $100 Million (M). The council is exploring the following three projects, each of which costs $100 M. a. A bridge which takes five years to build, then yields $50M benefit per year for the next 10 years. The benefits are received at the end of each year. Assume that the costs are spread out evenly over the five years (i.e. year 1 to year 5) and are paid at the end of each year. b. Temporary classrooms for schools yielding $50M benefit per year for five years. The benefits are received at the end of each year. Assume that all costs are paid at the end of year 1. c. Tax breaks per year to a foreign auto manufacturer for a new auto plant yielding $20M benefit per year from the third year for next 5 years. The benefits are received at the end of each year. Assume that all costs (i.e. tax breaks) are paid equally at the end of year 1 and year 2. Assuming the discount rate of 5 percent, calculate the following for each of the projects: Discounted Benefits, Discounted Costs, Net Present Value (NPV) and Benefit Cost Ratio (BCR). Which one of the above projects would you suggest that the City Council can undertake based on the BCR? Explain your answer. You should be able to use Excel for this exercise.

Please post excel screenshot as well as how to calculate each cell.

Expert Solution

Solution uploaded

ekkarill92 answered 7 months ago

Budget Surplus: A Case Study A small midwestern city has a $1 million budget surplus. Two...

Budget Surplus: A Case Study A small midwestern city has a $1 million budget surplus. Two groups immediately begin vying for the funds. One of the requests comes from downtown businesses requesting to use the money to beautify downtown by adding brick sidewalks and planting areas with the goal of attracting customers. As city manager, you are aware that the downtown area has not been doing as well as predicted and that the small businesses are necessary for the development...

The City of Chicago has to select a representative from the city council to go to...

The City of Chicago has to select a representative from the city council to go to an economic development conference. It will also select an alternate representative, in case there is a conflict or emergency that prevents the representative from attending. City policy says that these selections are to be made completely at random from the members of the city council. The council’s membership is made up of 7 Democrats and 5 Republicans. I'm interested in the political party affiliation...

The population of the earth in the 1500s was estimated to be 100 million people. In...

The population of the earth in the 1500s was estimated to be 100 million people. In 1990 the world population was estimated at 2,600 million. Assuming that the growth rate is proportional to the population at each moment, estimate the year in which the population is 3,000 million.

The City Council has gathered data on the number of minor traffic accidents and the number...

The City Council has gathered data on the number of minor traffic accidents and the number of youth football games that occur in a town over a weekend X (Soccer Games) 20 30 10 12 15 25 24 Y (minor accdnt) . 6 9 4 5 7 8 9 Plot the data Develop the estimating equation that describes the data Predict the number of minor traffic accidents that will occur on a weekend during which 33 soccer games takes place

You have been contracted by the City of Sydney Council to inspect an issue that has...

You have been contracted by the City of Sydney Council to inspect an issue that has been reported by residents living in a western suburb. The residents claim that one of the roads in their suburb has lately had issues with traffic speeding. The City of Sydney Council wants you to investigate if traffic speeding is an issue and, if this is the case, they will invest in building asphalt speed bumps to enforce reduced traffic speeds on that particular...

City Council Transportation hearing on Congestion Pricing

A city budget transmittal memo to the city council included this statement: similar to the 2008...

A city budget transmittal memo to the city council included this statement: similar to the 2008 budget, our 2009 proposed expenditures exceed projected revenues in our levy controlled funds in order to invest cash reserves generated by sound fiscal management back into the community. How would you respond to that approach to budget development.

Consider the following hypothetical scenario: The city council has just approved the construction of an amusement...

Consider the following hypothetical scenario: The city council has just approved the construction of an amusement park in your town. You are responsible for studying the impact of the new amusement park on the local economy and the surrounding community. Write a paper of approximately 500 words that addresses all of the questions below. Include the graphs, where indicated: o Question 1: You know that the amusement park will increase the traffic flow in the streets around the amusement park....

The City Council wants to gather input from residents about the recreational opportunities in the city....

The City Council wants to gather input from residents about the recreational opportunities in the city. Categorize each technique as simple random sample, stratified sample, systematic sample, cluster sample, or convenience sample. a) Get an alphabetical list of all residents and question every 250th resident on the list. b) Have 10 volunteers go downtown on Saturday afternoon and question people that they see. The volunteers may quit when they have questioned 25 people. c) Get an alphabetical list of all...

10. A city is experiencing over-exploitation of its grazing areas. The city council is looking for...

10. A city is experiencing over-exploitation of its grazing areas. The city council is looking for a consultancy organization that can suggest viable solutions. Your research team is bidding for this job, and you are responsible for the methodology section in the bidding document. Carefully explain what you would include in the methodology section. Your explanation must include the details of the method (or methods) you choose, the data that need to be collected, the assumptions or restrictions you may...

Question