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
