Environmental economics
Course:- Public Economics
Reference No.:- EM13141

Assignment Help
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
Read the article, A tool kit for the real world (LINK BELOW). In this article, the author discusses the importance of communication skills within a field that many people ma
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
Explain the essential skills that would make a person successful in each of the described positions. Recommend one of the career options. Identify the most attractive features
Suppose an A-type player would contribute $5 million per year to the team's revenue whereas a G-type would contribute $0.5 million. What is the maximum a team owner would be
Write a 3-4 page analysis of the article listed below on how you see your career path supporting the direction of an organization while motivating and leading employees to b
How did natural resources, existing Indian cultures and physical barriers such as mountains, deserts and rivers invite or hinder the effort to settle the vast and continuall
Giapetto's Woodcarving Inc. manufactures two types of wooden toys: soldier and trains. A soldier sells for $27 and uses $10 worth of raw materials. Each solider that is manu
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