Question: Please show all steps, formulas in excel format. Thank you. A mining company is considering a new project. Because the mine has received a permit,

 Please show all steps, formulas in excel format. Thank you. A

Please show all steps, formulas in excel format. Thank you.

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 $10.33 million at Year 0 to mitigate the environmental Problem, but it would not be required to do so. Developing the mine (without mitigation) would require an initial outlay of $63 million, and the expected cash inflows would be $21 million per year for 5 years. If the firm does invest in mitigation, the annual inflows would be $22 million. The risk-adjusted WACC is 11%. a. Calculate the NPV and IRR with 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. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!