170 Get UHVA VUR Seth Bullock, the owner of Bulock Gold Mining is evaluating a new gold mine in Soum Dakota Dar Docity the company's geologist, has just finished his analysis of the mine site. He has stated that the mine would be productive for eight years after which the gold would be completely mind. Dan has taken a estimate of the gold deposits to Alma Garrott, the company's financial officer Alma has been asked by Set to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine Collants get access to Way! rience in U-info.org/reply V w Sver O 1 Cash Flow -5625.000.000 70,000,000 129,000,000 183.000.000 235.000.000 2 3 F. NOLACTIC 210,000,000 5 6 7 164.000.000 108,000,000 86.000.000 - 90,000,000 9 feau LO Cad 23.00 210.000.000 ed Experien HEMEROS 166.000.000 08.000.000 86.000.000 0.000.000 -Info.org/reply perience in Alma has used the estimates provided by Dan to determine the venues that could be uspected from the mine. She also has projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost 5625 million today, and I will have a cash outflow of 590 million in years from today in costs associated with closing the mine and recoming the area surrounding. The expected cash flows each year from the mine are shown in the nearby table. Bullock Gold Mining has a 12 percent required return on all of its goldmines QUESTIONS 1. Construct a spreadsheet to calculate the payback period, Internal role of return, modified internal role of return, and not present value of the proposed mine 2. Based on your analysis should the company open the mine? 3. Bonus question: Most spreadsheets do not have built-in formula to calculate the payback period Wine a VBA script that calculates the payback period for a project SCHOLASTIC 170 Get UHVA VUR Seth Bullock, the owner of Bulock Gold Mining is evaluating a new gold mine in Soum Dakota Dar Docity the company's geologist, has just finished his analysis of the mine site. He has stated that the mine would be productive for eight years after which the gold would be completely mind. Dan has taken a estimate of the gold deposits to Alma Garrott, the company's financial officer Alma has been asked by Set to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine Collants get access to Way! rience in U-info.org/reply V w Sver O 1 Cash Flow -5625.000.000 70,000,000 129,000,000 183.000.000 235.000.000 2 3 F. NOLACTIC 210,000,000 5 6 7 164.000.000 108,000,000 86.000.000 - 90,000,000 9 feau LO Cad 23.00 210.000.000 ed Experien HEMEROS 166.000.000 08.000.000 86.000.000 0.000.000 -Info.org/reply perience in Alma has used the estimates provided by Dan to determine the venues that could be uspected from the mine. She also has projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost 5625 million today, and I will have a cash outflow of 590 million in years from today in costs associated with closing the mine and recoming the area surrounding. The expected cash flows each year from the mine are shown in the nearby table. Bullock Gold Mining has a 12 percent required return on all of its goldmines QUESTIONS 1. Construct a spreadsheet to calculate the payback period, Internal role of return, modified internal role of return, and not present value of the proposed mine 2. Based on your analysis should the company open the mine? 3. Bonus question: Most spreadsheets do not have built-in formula to calculate the payback period Wine a VBA script that calculates the payback period for a project SCHOLASTIC