Complete this question in ExcelSocial Cost(in millions)Social Benefit(in millions)Net Social Benefit(in millions)Project A 1 10Project B 10 30Project C 4 8Project D 10 8Project E 7 21a) Using the information in the above table, calculate the net social benefit.b) If the projects are mutually exclusive, which project should be selected. Justify youranswer.c) If the projects are not mutually exclusive, which project(s) should be selected. Justifyyour answer.
Question
Complete this question in ExcelSocial Cost(in millions)Social Benefit(in millions)Net Social Benefit(in millions)Project A 1 10Project B 10 30Project C 4 8Project D 10 8Project E 7 21a) Using the information in the above table, calculate the net social benefit.b) If the projects are mutually exclusive, which project should be selected. Justify youranswer.c) If the projects are not mutually exclusive, which project(s) should be selected. Justifyyour answer.
Solution
a) The net social benefit is calculated by subtracting the social cost from the social benefit. Here's how you do it for each project:
- Project A: 10 million - 1 million = 9 million
- Project B: 30 million - 10 million = 20 million
- Project C: 8 million - 4 million = 4 million
- Project D: 8 million - 10 million = -2 million (This means the social cost is greater than the social benefit)
- Project E: 21 million - 7 million = 14 million
b) If the projects are mutually exclusive (meaning you can only choose one), you should select the project with the highest net social benefit. In this case, that would be Project B with a net social benefit of 20 million.
c) If the projects are not mutually exclusive (meaning you can choose more than one), you should select all projects that have a positive net social benefit. In this case, that would be Projects A, B, C, and E. Project D should not be selected because it has a negative net social benefit.
Similar Questions
The table below lists four mutually exclusive projects.Which project runs at the highest equivalent annual net cost?Assume an 8% discount rate? Total Operating Cost (PV) Project life (years)Project A 40000 8Project B 37500 7Project C 38500 6Project D 35500 5
If the projects in Table 1 are mutually exclusive and the required rate of return is 10%, which of the projects is chosen by NPV?Project AProject BProject B and Project CProject A and Project BProject C
A Corporation must decide between two mutually exclusive projects. Both projects requirean initial spending of $100 million, and they generate cash ows that are independent of thegrowth of the economy.Project A has equal probability of four gross payos: $80 million, $100 million, $120 million,or $140 million.Project B has a 50/50 chance of paying either $90 million or $130 million.Assuming that the shareholders are all risk-averse, prove that they unanimously prefer projectB to project A.1
QUESTION 3The table below summarises the potential net benefit for four individuals involved in four distinct projects. Which statement in relation to Pareto conditions is most correct? Project A Project B Project CProject DBob48362412Anna33276845David-88-34-6425Caroline63-25-4226Both project A and project B are examples of potential Pareto improvement. Project C is an example of strict Pareto improvement. Only project A represents an example of potential Pareto improvement.Both project A and project B are an example of strict Pareto improvement.
There are two projects: project A and project B. Each of the project has the cost of Rs 100,000 and cost of capital for each project is 12 percent. The project's expected net cash flows are as follows: Year Project A Project B 0 Rs (100,000) Rs (100,000) 1 65,000 35,000 2 30,000 30,000 3 30,000 30,000 4 10,000 10,000 a. Calculate NPV for each project. Which project or projects should be accepted if they are independent? b. Calculate IRR for each project. Which project should be accepted if they are mutually exclusive?
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.