Environmental economics
Course:- Public Economics
Reference No.:- EM13141

Assignment Help
Assignment Help >> Public Economics

Use Excel formulas to calculate everything.

There are three alternative plans that indicate the benefits and costs associated with the construction of a Manitoba hazardous waste facility (see table on next page).

a. For the three alternatives calculate the net present value and benefit-cost ratio for four different discount rates (0%, 6%, 12%, 18%). You must use Excel or some other spreadsheet program and do not use the built in formula for net present value.

b. Create a ranking for each of the discount rates based on their net present values. Based on the ranking which alternative would you choose at each discount rate?

c. On a single graph show the impact of discount rates on net present value for each alternative. The vertical access should be net present value and on the horizontal access should be discount rate. 

Indicate on the graph the lowest approximate discount rate where each alternative should not be undertaken.


Put your comment

Ask Question & Get Answers from Experts
Browse some more (Public Economics) Materials
How could the Klamath Basin water shortage have been avoided? And how can we avoid this situation in the future and how do we decide between "fish vs farmers" in general?
Identify the type of public organization for which you work, as well as what types of services, goods, or activities the organization provides to the public. Identify the si
Discuss the agents of socialization involved in the transmission of the three interesting aspects you chose. Finally, how does each of these aspects affect the development of
Quantitative Analysis is a vital part of any problem solving, be it from Engineering, Economics,  Logistics or Business Analysis. It enables us to glean information
According to the text, the Hatch Act defines prohibited activities of public employees. Analyze the significance of these prohibitions with regard to an individual's politic
Describe a significant economic event that is currently taking place in the world. Explain what you now understand more clearly and possibly relate your understanding back
The effect of the current value, and trajectory, of the Yuan on the US and world economies. The theoretical arguments for changes to the Chinese exchange rate regime, includi
How does economics differ from a natural science like chemistry and formal science like mathematics? How is it similar to other social sciences like anthropology and political