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
What is the empirical evidence regarding the usefulness of the expectations hypothesis of the term structure (EHTS) for explaining future spot interest rates? How well does th
A generous university benefactor has agreed to donate a large amount of money for student scholarships. The money can be provided in one lump sum of $12 million in Year 0 (t
How could the Klamath Basin water shortage have been avoided? And how can we avoid this situation in the future and how do we decide between "fish vs farmers" in general?
Oct. 17. Sold office equipment in exchange for $135,000 cash plus receipt of a $1,00,000, 90-day, 9% note. The equipment had a cost of $320,000 and accumulated depreciation
What are the key characteristics of a monopolistically competitive market? Some experts have argued that too many brands of breakfast cereal are on the market. Give an argum
The GDP in country I is $2,900 per capita-or about $3.3 trillion for all of country I. If country I expect growth in GDP to be about 7% for next year, health expenditures sh
List and briefly describe the dependent and independent variables. What theoretical basis or conceptual framework does the author utilize in framing an understanding of the p
In a single posting, describe in detail how you would address this growing problem using each of the policing styles listed above. Explain which approach is best, using rese