Question

CAPITAL BUDGETING CRITERIA: ETHICAL CONSIDERATIONS

An electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would cost $210.17 million, and the expected cash inflows would be $70 million per year for 5 years. If the firm does invest in mitigation, the annual inflows would be $75.30 million. Unemployment in the area where the plant would be built is high, and the plant would provide about 350 good jobs. The risk adjusted WACC is 16%.

Calculate the NPV and IRR with mitigation. Round your answers to two decimal places. Enter your answer for NPV in millions. Do not round your intermediate calculations. For example, an answer of $10,550,000 should be entered as 10.55. Negative value should be indicated by a minus sign.
NPV $   million
IRR  %

Calculate the NPV and IRR without mitigation. Round your answers to two decimal places. Enter your answer for NPV in millions. Do not round your intermediate calculations. For example, an answer of $10,550,000 should be entered as 10.55.
NPV $   million
IRR  %

Answer 1

1X 1 With Mitigation Year 0 Without Mitigation cash flows $250.17 $75.30 $75.30 $75.30 $75.30 $75.30 15.38% IRR(B3:B8) pv@16% Present value $250.17 cash flows -$210.17 $70.00 $70.00 $70.00 70.00 $70.00 pv @ 16% Present value $210.17 $60.34 $52.02 $44.85 38.66 $33.33 Year 0.862 .743 0.641 0.552 0.476 $55.96 $48.24 $41.59 $35.85 -$3.62 0.862 0.743 0.641 0.552 0.476 IRR 19.82% NV $19.03 9 IRR 10 IRR(G3:G8) 12 NPV -$3.62 Million NPV $19.03 Million 13