Reference no: EM13853419
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 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 $650 million today, and it will have a cash outflow of $72 million nine years from today in cost 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 12 percent required return on all of its gold mines.
|
Year
|
Cash Flow
|
|
0
|
-$650,000,000
|
|
1
|
80,000,000
|
|
2
|
121,000,000
|
|
3
|
162,000,000
|
|
4
|
221,000,000
|
|
5
|
210,000,000
|
|
6
|
154,000,000
|
|
7
|
108,000,000
|
|
8
|
86,000,000
|
|
9
|
-72,000,000
|
Questions:
1. Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present of the proposed mine.
2. Based on your analysis, should the company open the mine?
3. Most spreadsheet does not have a built-in formula to calculate the payback period. Write VBA script that calculates the payback period.
|
Discuss key differences between the two types of evolution
: Discuss the key differences between the two types of evolution. Be sure to demonstrate you read the articles and other reading assignments. This is not an opinion discussion.
|
|
Are corporations good or bad
: Are corporations good or bad? Defend your position.
|
|
Described by the previously defined utility faction
: Suppose my tastes could be modeled with the utility function u(x1, x2) = 20x1^0.5 + x2, where x1 refers to mozartkugeln and x2 refers to other consumption. consider the bundles A,B, and C as defined in part A: (bundle A: 100 mozartkugeln and $500 in ..
|
|
Compare the evolutionary design process to waterfall method
: Compare the evolutionary design process to the waterfall method. Why do you think some companies move to the newer design methods (evolutionary) and some remain with the older methods (waterfall)
|
|
Problem regarding the 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.
|
|
What is the internal rate of return on your investment
: Suppose you purchase a 30-year, zero-coupon bond with a yield to maturity of 6%. You hold the bond for five years before selling it. If the bond's yield to maturity is 6% when you sell it, what is the internal rate of return on your investment?
|
|
Explain how they relate to current microeconomic theories
: Explain how they relate to current microeconomic theories and The paper must include a graph used as an explanatory tool of the economic principle presented.
|
|
Create the work breakdown structure
: Create the work breakdown structure (WBS) as shown in the textbook listing the tasks that will need to be completed to meet the project's objectives.
|
|
Describes the increase in the money supply
: Your book describes the increase in the money supply as being analogous to giving people more money. If the output of goods and services is not growing at a similar rate, inflation will eventually occur. According to PPP Theory, what will happen to t..
|