In: Finance
New Century Energy Partners, Ltd. plans to explore a new oil field to expand its overseas operations. This capital investment project requires an initial outlay of $10 million and it is expected to generate annual cash flows of $3 million for a period of five years. At the end of the sixth year, the firm will incur shut-down and clean-up costs of $2 million.
Assuming that projects of similar risk have a cost of capital is 11%, what is the MIRR for this project?
| Cash flows | Year | 
| (10.00) | 0 | 
| 3.000 | 1 | 
| 3.000 | 2 | 
| 3.000 | 3 | 
| 3.000 | 4 | 
| 3.000 | 5 | 
| (2.000) | 6 | 
Use MIRR function in Excel
MIRR = 11.03%