Concept explainers
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 $525 million today, and it will have a
Year | Cash Flow |
0 | −$525,000,000 |
1 | 74,000,000 |
2 | 97,000,000 |
3 | 125,000,000 |
4 | 157,000,000 |
5 | 185,000,000 |
6 | 145,000,000 |
7 | 125,000,000 |
8 | 102,000,000 |
9 | −35,000,000 |
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.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Fundamentals of Corporate Finance
- 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 $850 million today, and it will have a cash outflow of $120 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…arrow_forwardseth 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 compnay's financial officer alma has been asked by seth to perform an analysis of the new mine and present her recommendation on wheter the company should open the new mine. year cashflow 0 -625,000,000 1 70,000,000 2 129,000,000 3 183.000.000 4 235,000,000 5 210,000,000 6 164,000,000 7 108,000,000 8 86,000,000 9 -90,000,000 alma has used the estimates provided by dan to determine the revenues that could be expected form the mine. she also has projected the expense of opening the mine and the annual operating expenses. if the company opens the mine, it…arrow_forwardBullock 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 $745 million today, and it will have a cash outflow of $55 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows…arrow_forward
- Dr. Ron Patterson, the owner of Chadron Gold Mining, is evaluating a new gold mine in Colorado. Dr. Tawny Tibbits, the company's geologist, has just finished her analysis of the mine site. She has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Tawny has taken an estimate of the gold deposits to Dr. Pil Joon Kim, the company's financial officer. Pil Joon has been asked by Ron to perform an analysis of the new mine and present his recommendation on whether the company should open the new mine. Year Cash Flow 0 1 2 -$650,000,000 80,000,000 121,000,000 3 162,000,000 4 221,000,000 5 210,000,000 6 154,000,000 7 108,000,000 8 9 86,000,000 -72,000,000 Pil Joon has used the estimates provided by Tawny to determine the revenues that could be expected from the mine. He 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…arrow_forward3. 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 three 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 also has projected the expense of opening the mine with two different alternatives. A project cost 25000 is expects to generate cash flows are given as follows @12% for both the projects. Year 1 2 3 4 5 Alternative 1 13000 8000 6000 8000 7000 Alternative 28000 14000 5000 6500 4000 PV factor 0.893 0.792 0.7120.6360.567 Required: 1. Compute the…arrow_forwardBullock Gold Mining Seth Bullock, the owner of Bullock Gold Mining,... 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. Year Cash Flow 0 −$600,000,000 1 75,000,000 2 120,000,000 3 160,000,000 4 130,000,000 5 240,000,000 6 180,000,000 7 210,000,000 8 90,000,000 9 − 95,000,000 Alma has used the estimates provided by Dan to…arrow_forward
- I need this in Excel Worksheet to show formulas and calculations please. 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. Year Cash Flow0 −$625,000,0001 70,000,0002 129,000,0003 183,000,0004 235,000,0005 210,000,0006 164,000,0007 108,000,0008 86,000,0009 − 90,000,000 Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She also has projected the expense of opening the mine…arrow_forwardAfter discovering a new gold vein in the Colorado mountains, CTC Mining Corporation must decide whether to go ahead and develop the deposit. The most cost-effective method of mining gold is sulfuric acid extraction, a process that could result in environmental damage. Before proceeding with the extraction, CTC must spend 900,000 for new mining equipment and pay 165,000 for its installation. The mined gold will net the firm an estimated 350,000 each year for the 5-year life of the vein. CTCs cost of capital is 14%. For the purposes of this problem, assume that the cash inflows occur at the end of the year. a. What are the projects NPV and IRR? b. Should this project be undertaken if environmental impacts were not a consideration? c. How should environmental effects be considered when evaluating this or any other project? How might these concepts affect the decision in part b?arrow_forwardA mining company in South Africa has discovered a new gold vein in a mountain 150 kilometers north of Johannesburg. SA Mining Corporation will have to decide if they should set up a mine in the newly discovered location. They will be using the most cost-effective, but environmentally damaging method of gold mining sulfuric acid extraction. To go ahead SA Mining Corporation must spend $900,000 on new mining equipment and pay $165,000 for its installation. The goldmine will make an annual profit contribution of $350,000 each year for the next five years of the extraction. SA’s cost of capital is 14% and assumes that cash flows occur at the end of each year. What is the NPV, and IRR of the project? [Note: you are supposed to show every step of your calculation and interpret the result.] Critically discuss how environmental effects should be considered when evaluating these types of projects (impact investing), include in your discussion the challenges in quantifying these issues in…arrow_forward
- Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land three weeks ago (the survey cost $25,000) and concluded the following: • You can extract 1,000 tons of iron ore per year. • There are 4,000 tons of iron ore underneath this land. Once all the ore has been extracted, the project will cease to produce any revenues. • The price of ore will remain constant for the next 4 years. Currently ore sells for $100 per ton. • The operating cost to extract the ore will be $60 per ton for the next 4 years. . • We will need to invest in the equipment for this project right now for $100,000. . mention The equipment will be depreciated over a period of four years using the straight-line method, with an assumed salvage value of zero for tax purposes. At the end of year 4, we can sell the equipment involved in the project for $20,000. The expansion requires additional working capital (NWC) of $10,000 from the start (at time t=0)…arrow_forwardUnderwood’s Miners recently purchased the rights to a diamond mine. It is estimated that there are two million tons of ore within the mine. Underwood’s paid $46,000,000 for the rights and expects to harvest the ore over the next fifteen years. The following is the expected extraction for the next five years. Year 1: 50,000 tons Year 2: 900,000 tons Year 3: 400,000 tons Year 4: 210,000 tons Year 5: 150,000 tons Calculate the depletion expense for the next five years. Year 1 = Year 2 = Year 3 = Year 4 = Year 5 =arrow_forwardGimli Miners recently purchased the rights to a diamond mine. It is estimated that there are one million tons of ore within the mine. Gimli paid $23,400,000 for the rights and expects to harvest the ore over the next ten years. The following is the expected extraction for the next five years. Year 1: 52,000 tons Year 2: 94,000 tons Year 3: 150,000 tons Year 4: 160,000 tons Year 5: 180,000 tons Calculate the depletion expense for the next five years. Do not round intermediate calculations. Year 1 $ Year 2 $ Year 3 $ Year 4 $ Year 5 $ Prepare the journal entry for year one. If an amount box does not require an entry, leave it blank.arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningPrinciples of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College