Problem 7-16 You own a coal mining company and are considering opening a new mine. The mine will cost $120 million to open. If this money is spent immediately, the mine will generate $20 million for the next 10 years. After that, the coal will run out and the site must be cleaned and maintained at environmental standards. The cleaning and maintenance are expected to cost $2 million per year in perpetuity. What does the IRR rule say about whether you should accept this opportunity? If the cost of capital is 8%, what does the NPV rule say? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section. $120 Cost of new mine (million) Annual cash flows (million) $20 10 Number of periods (years) Cleaning costs (million) Cost of capital $2 Cost of Capital 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% NPV (million) 8%