Case #1 Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dorty, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimated of the gold deposits to Alma Garret, the company's CFO. Alma has been asked to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine. Seth Alam has used the estimated the cost provided by Dan to determine the revenues that could be expected from the mine. She also projected the expense of opening mine and the annual operatine expenses. If the company opens the mine, it will cost $500 million today, and will have a cash outflow of 580 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the table. Bullock Mining has a 12% required return on all of its Gold mines. year cash flow 160000000 2 90000000 3 170000000 4 230000000 205000000 6 140000000 7 110000000 8 70000000 9 -80000000 1. Construct a spreadsheet to calculate a. b, c. the payback period, (10%) internal rate of return, (10%) and net present value (10%) of the proposed mine. 2. Based on your analysis, should thedompany open the mine? why?(10%)