[Solved] Must Use Excel Functions

During this week, start working on the Case Study which is due at the end of Week 6. 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:

1. Summarizes the problem.
2. Provides your analysis of the work performed in Step 1.
3. Recommends whether the company should open the mine based upon your analysis.