In: Finance
A mining company is deciding whether to open a strip mine, which costs $2 million. Cash inflows of $14 million would occur at the end of Year 1. The land must be returned to its natural state at a cost of $11 million, payable at the end of Year 2.
NPV at 10% | 1.64 |
NPV at 20% | 2.03 |
Situations when there will be multiple IRRs are when the project has non-conventional cash flows. The number of IRRs will be equal to the number of times the sign changes in the cash flow table.
MIRR at 10% | 17.84% |
MIRR at 20% | 32.02% |
WORKINGS as per excel