Economic III-4
Not what you're looking for?
A cost-benefit analysis of a new irrigation project indicates that the net benefits = Benefit - Cost (B-C) of the project in each year will be $20 million. This project will yield benefits for 10 years. Calculate the present value of benefits minus costs when the social rate of discount is 10%. Does the program merit approval? How would the present value of the net benefits change if the social rate of discount were 15%? You can use spreadsheet software, such as MS Excel, to do the calculation. After that, copy and paste it into a MS Word document, write your answer in the MS Word document, and upload it to Blackboard.
Purchase this Solution
Solution Summary
The cost benefit analysis for new irrigations are examined.
Solution Preview
Please see the attached file
Discount Rate 10%
Year Benefit (MM) PV (MM)
1 $ 20.00 $ 18.18
2 $ 20.00 $ 16.53
3 $ 20.00 $ 15.03
4 $ 20.00 $ 13.66
5 $ 20.00 $ 12.42
6 $ 20.00 $ 11.29
7 $ 20.00 $ 10.26
8 $ 20.00 $ 9.33
9 $ 20.00 $ 8.48
10 $ 20.00 $ 7.71
$ 122.89 <- npv
Discount Rate 15%
Year Benefit (MM) PV (MM)
...
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Pricing Strategies
Discussion about various pricing techniques of profit-seeking firms.
Economic Issues and Concepts
This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.
Economics, Basic Concepts, Demand-Supply-Equilibrium
The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.
Basics of Economics
Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.
Elementary Microeconomics
This quiz reviews the basic concept of supply and demand analysis.