During this week, continue working on Case Study which is due at the end of this week. This is the Chapter Case: Bullock Gold Mining at the end of Chapter 8 on page 274 of your text.

This case requires that you use Excel to calculate the Net Present Value, Internal Rate of Return, Modified Internal Rate of Return, and payback period of a project. You will need to provide answers to Steps 1 and 2 in the exercise using Excel to present your calculations (Step 3 is not required.).

For Step 1: You must use Excel functions and formulas to perform all necessary calculations. Submissions with only numbers and no formulas or functions will not receive credit for this assignment. Your submission must be neatly organized and must clearly present your work and results.

For Step 2: Submit a Microsoft Word document that:

Summarizes the problem.

Provides your analysis of the work performed in Step 1.

Recommends whether the company should open the mine based upon your analysis.

Step by Step please and thank you, I am extremely confused on this assignment.

eth Bullock, the owner of Bullock Gold Mining, is Alma has used the estimates provided by Dan to evaluating a new gold mine in South Dakota. Dan determine the revenues that could be expected from Dority, the company's geologist, has just finished his the mine. She also has projected the expense of openanalysis of the mine site. He has estimated that the ing the mine and the annual operating expenses. If the mine would be productive for eight years, after which company opens the mine, it will cost $625 million today, the gold would be completely mined. Dan has taken an and it will have a cash outlow or $90 million nine years estimate of the gold deposits to Alma Garrett, the com- from today in costs assoclated with closing the mine and pany's financial afficer, Alma has been asked by Seth reclaiming the area surrounding it. The expected cash to perform an analysis of the new mine and present her flows each year from the mine are shown in the nearby recommendation on whether the company should table. Bullock Gold Mining has a 12 percent required reopen the new mine. turn on all of its gold mines. Chapter 8 Bullock Gold Mining Input area: Solutions Payback Calculation - Show Your work Payback period