In: Finance
You are considering constructing a new plant in a remote wilderness area to process the ore from a planned mining operation. You anticipate that the plant will take a year to build and cost $100 million upfront. Once built, it will generate cash flows of $15 million at the end of every year over the life of the plant. The plant will be useless 20 years after its completion once the mine runs out of ore. At that point you expect to pay $200 million to shut the plant down and restore the area to its pristine state. Using a cost of capital of 12%,
(please answer it in Excel with )
a. | What is the NPV of the project? | ||||||
b. | Is using the IRR rule reliable for this project? | ||||||
c. | What is the IRR of this project? Find the non-zero IRR. | ||||||
Upfront costs | $100 | ||||||
Annual cash flows (million) | $15 | ||||||
Number of periods (years) | 20 | ||||||
Closing costs (million) | $200 | ||||||
Cost of capital | 12% |
Hope you understood the solution. If you have any doubt please leave your doubt in the comment section so that I can clarify your doubt.
Thank you.