+1-415-670-9189
info@expertsmind.com
Environmental economics
Course:- Public Economics
Reference No.:- EM13141




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
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.

587_environmental_economics.png




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (Public Economics) Materials
How did mental institutions gain respect and authority? What caused the change in the view of mental illness? How did the creation of medical institutions and mental instituti
Explain the essential skills that would make a person successful in each of the described positions. Recommend one of the career options. Identify the most attractive features
Describe Abell's three-dimensional business-definition model and explain where it can be utilized. Then, consider Reader's Digest Association, publisher of Reader's Digest,
What is the equilibrium level of automobile tire production? What is the socially optimal quantity? What is the underlying economic intuition for the difference in your answer
Evaluate the impact of exchange rate adjustments and their effects on the balance of payments. Select a current exchange rate practice and explain the economic factors that
Show equilibrium, graphically. Assume k/h > 0, -(1-c(1-t))/b
Mitchell's managers have vaguely suggested a willingness to lower price in order to deter entry. Is this threat credible in light of the payoff matrix above and If the threa
How much of the private good will George donate in equilibrium. What does it mean for a good to be non-excludable? In theory one may worry that such a problem could completel