Help....struggling with a problem...need analysis in excel format with solution

Question

Help....struggling with a problem...need analysis in excel format with solution spelled out......
After discovering gold in Colorado's mountains, ABC mining must decide whether to mine the deposit. The most cost-effective method of mining gold is sulfuric acid extraction, a process that results in environmental damage. To proceed with the extraction, ABC Co. must spend $900,000 for new mining equipment and pay $165,000 for its installation. The mined gold will net the company a projected $350,000 each year over the 5 year life of the mine. ABC Co's cost of capital is 14%. Assume the cash inflows occur at the end of the year:
1) What are the NPV and IRR of this project?
2) Should this project be undertaken ignoring environmental Concerns? Why or why not?
3) How should environmental effects be considered when evaluating this, or any other project? How might these affects change your decision in Part b?

Explanation / Answer

A) cash flow from the proposed minings:
Year
1 -$1,065,000
0 350,000
2    350,000
3   350,000
4   350,000
5   350,000

NPV = $136,578.34 and IRR= 19.22%

b) Yes , since NPV is 0 (ans IRR>WACC)

c) THe analysis in (a) ignores the environmental damage caused by the mining process.Envronmrntal damage is an example of externality. The firm should deduct the cost of it from the expected cash flows to get a better estimates of marginal benefits and costs. If environemental costs are large enough then it may lead the manager to quit the project in hand.

Please Rate My Work

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.