+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
Describe how Marx sees the critique of religion as a model for the philosophical critique of political economy and how he tries in the manuscripts to provide what he might c
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
An example point of comparison is the human needs each fulfilled and what social institutions those are tied to. A point of contrast could be the activities that took place
Discuss how a public good is different than a private good. Discuss whether only government can supply a public good. What are the challenges related to public goods. How sh
Suppose all firms in a monopolistically competitive industry were merged into one large firm. Would that new firm produce as many different brands? Would it produce only a s
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
What is the rationale for discounting when you calculate the cost and benefits of government programs and amortize an investment of $50,000 for a three-year period at an inter
Now consider the graph below. If the average vehicle gets 25 miles per gallon, then according to the data reported in the article, what is the value of BE in the graph below