Please use excel formulas showing how you got each equation.

BULLOCK GOLD MINING Seth Bul ock, the owner of Bubck Gold Mining, is evalualing a new gold mine in South Dakota. Dan Dority, the comparys geolopist, has just inished his analyse of tha mine site. He has estimated that the mine would be productwo for elght years, after which the gold would be complotely mined. Dan has taken an estimate of the pold deposits to Ama Garret, the company's financial oticer. Aima has been asked by Seth to perform an analysis of the new mine and prosent her recommendation on whether the company thould ocen the naw mine. Amn has used the estimaten provided by Dan to determine the revenues that could be expected from the mine. She has-also projected the expense of opening the mine associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the tabie that follows. Bullock has a 12 porcent required roturn on all of its gold mines. 1. Construct a spreadsheet to calculase the payback poriod, internal rate of return, mod tied internal rate of roturn, and net present value of the proposed mine. 2. Based on your analysis, ahould the company open the mine