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
How was Jollibee able to build its dominant position in fast food in the Philippines? What sources of competitive advantage was it able to develop against McDonald's in its
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
In planning activities how are the decision arrived and what are the different stages of analysis? which factors can be ignored and why? state the manner in which a degree o
introduce yourself(me) to the class by defining yourself as a reader. Before you start writing, brainstorm on all of the books, magazines, articles, websites and other texts
Imagine that you work for the maker of a leading brand of low-calorie, frozen microwavable food that estimates the following demand equation for its product using data from
Explain why you tend to find more shirking, more corruption, and more inefficiency in large firms than you do in small firms. Explain why you tend to find more shirking, mo
Show equilibrium, graphically. Assume k/h > 0, -(1-c(1-t))/b
Competitive analysis is a major component to performing an external analysis. of Harvard University introduced the concept of the Five Forces and is a leading academic autho