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%