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.


Put your comment

Ask Question & Get Answers from Experts
Browse some more (Public Economics) Materials
Final Paper is to provide you with an opportunity to demonstrate your knowledge of the organizational communication concepts and skills that you have learned throughout this
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
What are the transfer coefficients for each of the two firms - Calculate the cutoff discount rate, c, such that the dam is a good idea for discount rates c.
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
Global Economics Assignment - Show how the one-year and five-year T-Bill rates are related through the term structure. Estimate the expected total cost of borrowing over entir
What are the likely targets for fraud in the workplace - what are the early warning signs employees should look for to detect fraud in the workplace and How can employees help
Do you believe society would gain or lose if these monopolies' practices were regulated in any dimension? Consider issues like overcharging, incentives for innovation, excl
Use your solution from i.) to compute the utility of society in the case where the central banker cannot commit to monetary policy. Find the value of cCB that maximizes soci