+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
Explain what you understand by the term the "invisible hand"and competitive market. Why would the workings of a competitive market result in an efficient allocation of resou
If company A finds minerals below company B's surface property, it may mine and use the minerals for its own use because it has not gone onto or disturbed company B's proper
What is the expected social welfare the pool can generate for the community - Show that it is impossible to satisfy the association's goals simultaneously if house-holds play
What role, if any, should the U.S. Government play in health care coverage for Americans? Should the government's role in terms of health insurance be different for those wi
Find the Excess Demand curve for the economy and show how to use it solve for the Equilibrium price. Solve for the equilibrium price and then the rest of the equilibrium.
Households make four kinds of economic decisions (textbook, pp. 4-5). Suppose you have two households with the same income. Household A has one income earner and Household B h
Calculate the fractions of this population who will suffer from disease A in the last four age intervals and discuss what information, in addition to that provided below, you
Analyze how historical trends and conditions have affected social, political, and management theories, and how they have influenced the evolution of public administration in