Please show answer using excel with all work and the formulas included!

Assignment #8 - Capital Budgeting Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, 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 depleted. Dan has taken an estimate of the gold deposits to you, the company's financial officer. You have been asked by Seth to perform an analysis of the proposed mine and present your recommendation on whether the company should proceed with this project. You used the estimates provided by Dan to determine the projected after-tax, incremental cash inflows that would be generated during the life of this project (see below). The cost to open this mine is estimated to be $500,000,000 and it is expected that closing the mine at the end of its useful life (and reclaiming the surrounding area) will result in an additional cost of $80,000,000 at the end of Year 9 (simply treat this as a Year 9 negative cash flow in your analysis). Bullock Mining has a 12% required rate of return on its mining projects, and a maximum acceptable payback period of 4 years. Year Cash Flow $ 60,000,000 $ 90,000,000 $170,000,000 $230,000,000 $205,000,000 $140,000,000 $110,000,000 $ 70,000,000 8 You are to evaluate the proposed mine using the payback period, net present value, profitability index and internal rate of return. Based on your analysis, provide a recommendation to Seth of whether to proceed with this project and explain your rationale