Reference no: EM131341018
Assignment
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 stimated 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 to 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 $750 million today, and it will have a cash outflow of $75 million nine years from today in 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 following table. Bullock Mining has a 12 percent required return on all of its gold mines.
Mini Case
Year Cash Flow
0 2$750,000,000
1 130,000,000
2 180,000,000
3 190,000,000
4 245,000,000
5 205,000,000
6 155,000,000
7 135,000,000
8 95,000,000
9 275,000,000
1. 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.
2. Based on your analysis, should the company open the mine?
3. 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.
|
Financial planning process
: As part of the financial planning process, a common practice in the corporate finance world is restructuring through the process of mergers and acquisitions (M&A).
|
|
Implement the merge-sort algorithm recursively
: Implement the merge-sort algorithm recursively. In it the initial array is divided into two equal in size parts, which are sorted (recursively via merge-sort) and after that the two sorted parts are merged in order to get the whole sorted array.
|
|
Management of asset-liability risk
: Give an example of how you would use a best practice approach to balance sheet management, giving careful consideration to management of asset/liability risks and returns in concert with one another.
|
|
Find an iterative solution for generating permutations
: Write a recursive program, which generates and prints all permutations of the numbers 1, 2, ..., n, for a given integer n
|
|
Construct a spreadsheet to calculate the payback period
: 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.
|
|
Can you solve the task efficiently for large arrays
: You are given an array of positive integers. Write a program that checks whether there is one or more numbers in the array (subset), whose sum is equal to S. Can you solve the task efficiently for large arrays?
|
|
Implement the algorithm bfs for finding the shortest path
: Modify the previous program to check whether a path exists between two cells without finding all possible paths. Test the program with a matrix 100x100 filled only with passable cells.
|
|
What is political-social-religious affiliation of the source
: HIST 101 :What is political, social, religious affiliation of the source? ?How does this mesh with the subject itself? What did the source have to gain by presenting the subject matter in the particular tenor chosen? ??Can you detect bias in the sou..
|
|
How the communication plan addresses what you are hoping
: In addition, explain how the communication plan addresses what you are hoping to achieve with your strategic goal. What leadership or managerial skills will you draw upon in implementing this plan?
|