Seth Bullock, the Ownor of Bullock Gold Mining is eualuating 9 new gold mine in South Dakots. Dan Dosity, the Company geology has just finished his ansysis of the inine site. He Rasestimated that the mine voould be productive for eight years, after wohich the gold would be complety mined. Alma has used the estimates provided by Dan to determine the reuenues that Could be expected from the mine. If the Company Opens the mine It will cost $950 milliuntoday, and It will have a cash Outflow of $75 million hine years from today in costs 9ssociated with Closing the mite and reclaining the ares Suscoounding it. Butlock Mining has 912 percent reguired return Da all of its gold imine. 1. Construct a spereacsheet to Glculate the Payback period, Internal rate of return, modified internal rate of return, Profitability Index, and net present value of the proposed mine. 2. Based On your analysis, should the Company Open the mine? mine? 3. Write a VBA Script that calculates the payback prriou for a project.  Tear 0123456789​ Cash How −$950,000,000190,000,000215,000,000225,000,000285,000,000275,000,000235,000,000205,000,000165,000,00075,000,000​