In: Finance
A mining company is considering a new project. Because the mine has received a permit, the project would be legal; but it would cause significant harm to a nearby river. The firm could spend an additional $11 million at Year 0 to mitigate the environmental Problem, but it would not be required to do so. Developing the mine (without mitigation) would cost $69 million, and the expected cash inflows would be $23 million per year for 5 years. If the firm does invest in mitigation, the annual inflows would be $24 million. The risk-adjusted WACC is 14%.
Calculate the NPV and IRR without
mitigation. Enter your answer for NPV in millions. For example, an
answer of $10,550,000 should be entered as 10.55. Do not round
intermediate calculations. Round your answers to two decimal
places.
NPV: $ ______ million
IRR: _______%
c. Should this project be undertaken?
I. The project should not be undertaken under the “no mitigation” assumption.
II. The project should be undertaken only under the “no mitigation” assumption.
III. The project should not be undertaken under the “mitigation” assumption.
IV. Even when mitigation is considered the project has a positive NPV, so it should be undertaken.
V. Even when mitigation is considered the project has a positive
IRR, so it should be undertaken.
If so, should the firm do the mitigation?
a. PVIFA14%, n=5 = [ { 1 - ( 1 / 1.14) 5 } / 0.14 ] = 3.4331
NPV with mitigation : $ 2.39 million
IRR:
NPV = 3.4331 x $ 24 million - $ 80 million = $ 2.3944 million
Spreadsheet calculation of IRR:15%
A | B | C | D | E | F | G | |
1 | Year | 0 | 1 | 2 | 3 | 4 | 5 |
2 | Cash Flow | (80) | 24 | 24 | 24 | 24 | 24 |
3 | |||||||
=IRR(B2:G2) | 15% |
NPV ( without mitigation) : $ 9.96 million.
IRR: 20%
NPV = 3.4331 x $ 23 million - $ 69 million = $ 9.9613 million.
A | B | C | D | E | F | G | |
1 | Year | 0 | 1 | 2 | 3 | 4 | 5 |
2 | Cash Flow | (69) | 23 | 23 | 23 | 23 | 23 |
3 | |||||||
=IRR(B2:G2) | 20% |
b. I.The environmental effects if not mitigated could result in additional loss of cash flows and/or fines and penalties due to ill will among customers, community, etc. Therefore, even though the mine is legal without mitigation, the company needs to make sure that they have anticipated all costs in the "no mitigation" analysis from not doing the environmental mitigation.
c. I.The project should not be undertaken under the “no mitigation” assumption.
IV. Even when mitigation is considered the project has a positive NPV, so it should be undertaken.
d. III. Under the assumption that all costs have been considered, the company would not mitigate for the environmental impact of the project since its NPV without mitigation is greater than its NPV when mitigation costs are included in the analysis.