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
Write an essay of 1,250-1,500 words that describes the change in the interpretation of the due process clause. Discuss whether or not the earlier interpretations gave the be
Effect of continual energy efficiency gains on energy growth and what does this tell you about the role of ease of substitution in determining the economy's response to an en
What you thought about the content of the material - remember, you don't have to agree with anything you see, hear or do in this class but you DO need to explain why you
How will each of the following changes in demand and/or supply affect equilibrium price and equilibrium quantity in a competitive market? That is, will the equilibrium price
Current and Future Economic Issues Impacting Healthcare Sector  Use the Internet or Strayer online databases to research five (5) of what you believe to be the most important
A competitive environment where there is weak rivalry among sellers, high entry barriers, weak threat of substitute products and no bargaining leverage on the part of custom
Do you think that what the participants did was wrong? Does it mean that they are "evil"? According to the text, "ordinary" people are more likely than not to follow an autho
Include specific examples from the various religious traditions described in the Week 1 readings, such as a belief in one God or many gods and goddesses, church on Sunday, h