Bullock Gold Mining – Seth Bullock, the owner of Bullock Gold Mining is evaluating a new gold mine in South Dakota.
CASE – 4 Bullock Gold Mining
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 mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company’s financial officer. Alma has been asked by Seth perform an analysis of the new mine and present her recommendation on whether the company should open the new mine.
Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $500 million today, and it will have a cash flow of $80 million nine years from today costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the table. Bullock Mining has a 12 percent required return on all of its gold mines.
| Year | Cash Flow |
| 012
3 4 5 6 7 8 9 |
─$500,000,00060,000,00090,000,000
170,000,000 230,000,000 205,000,000 140,000,000 110,000,000 70,000,000 ─80,000,000 |
Question:
- Construct a spreadsheet to calculate the payback period internal rate of return, modified internal rate of return and net present value of the proposed mine.
- Based on your analysis should the company open the mine?
- Bonus question: Most spreadsheets do not have a built-in formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.
At Global Study Solutions, we take immense pride in our ability to offer specialized support to students pursuing various programs at IIBMS (Institute Indian Institute of Business Management & Studies). Our dedicated team comprises experienced professionals who excel in crafting precise and well-researched solutions for assignments and case studies across different disciplines and courses.
Our commitment to aiding students in achieving academic success aligns perfectly with the educational standards upheld by IIBMS Institute (Institute Indian Institute of Business Management & Studies). We understand the importance of delivering high-quality, customized solutions that meet the unique requirements of assignments and case studies within the institute\’s curriculum.
Whether in MBA, EMBA, GMS, DMS, or any other programs offered at IIBMS Institute (Institute Indian Institute of Business Management & Studies), our team is equipped to provide expert guidance and meticulously crafted solutions. We prioritize accuracy, originality, and timely delivery; ensuring students receive the necessary assistance to excel academically.
We are dedicated to fostering an environment of academic excellence and providing dependable support to the esteemed students of IIBMS Institute (Institute Indian Institute of Business Management & Studies).
To get complete solutions or answer sheets for your IIBMS Case study papers, contact Dr. Aravind Banakar. With over 24 years of experience, he specializes in crafting customized, unique, and plagiarism-free case study answers with Project reports and Thesis.
Dr. Banakar is a trusted resource for reputable and reliable academic support in India. He has a team of over 100 PhD professionals.
You can contact Dr. Banakar through the following channels:
- Email: aravind.banakar@gmail.com
- Phone: +91 9901366442 & +91 9902787224
IIBMS MBA Solved Answer Sheets
EMBA IIBMS Answer Sheets & Case Studies
IIBMS Doctorate Case Study Answers and Thesis
IIBMS MBA, EMBA & DMS Projects & Thesis