Connect 1 Semester Access Card for Fundamentals of Corporate Finance
11th Edition
ISBN: 9781259289392
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 9, Problem 3M
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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 $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…
BULLOCK GOLD MININGSeth 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 $750 million today, and it will have a cash outflow of $105 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows…
Bullock 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…
Chapter 9 Solutions
Connect 1 Semester Access Card for Fundamentals of Corporate Finance
Ch. 9.1 - Prob. 9.1ACQCh. 9.1 - Prob. 9.1BCQCh. 9.2 - Prob. 9.2ACQCh. 9.2 - Why do we say that the payback period is, in a...Ch. 9.3 - Prob. 9.3ACQCh. 9.3 - What advantage(s) does the discounted payback have...Ch. 9.4 - What is an average accounting rate of return...Ch. 9.4 - What are the weaknesses of the AAR rule?Ch. 9.5 - Prob. 9.5ACQCh. 9.5 - Is it generally true that an advantage of the IRR...
Ch. 9.6 - What does the profitability index measure?Ch. 9.6 - How would you state the profitability index rule?Ch. 9.7 - Prob. 9.7ACQCh. 9.7 - If NPV is conceptually the best procedure for...Ch. 9 - Prob. 9.1CTFCh. 9 - Prob. 9.2CTFCh. 9 - Prob. 9.3CTFCh. 9 - Prob. 9.4CTFCh. 9 - What is a benefitcost ratio?Ch. 9 - Prob. 9.7CTFCh. 9 - Prob. 1CRCTCh. 9 - Net Present Value [LO1] Suppose a project has...Ch. 9 - Prob. 3CRCTCh. 9 - Prob. 4CRCTCh. 9 - Prob. 5CRCTCh. 9 - Net Present Value [LO1] Concerning NPV: a....Ch. 9 - Prob. 7CRCTCh. 9 - Profitability Index [LO7] Concerning the...Ch. 9 - Payback and Internal Rate of Return [LO2, 5] A...Ch. 9 - Prob. 10CRCTCh. 9 - Capital Budgeting Problems [LO1] What difficulties...Ch. 9 - Prob. 12CRCTCh. 9 - Modified Internal Rate of Return [LO6] One of the...Ch. 9 - Net Present Value [LO1] It is sometimes stated...Ch. 9 - Internal Rate of Return [LO5] It is sometimes...Ch. 9 - Calculating Payback [LO2] What is the payback...Ch. 9 - Calculating Payback [LO2] An investment project...Ch. 9 - Calculating Payback [LO2] Siva, Inc., imposes a...Ch. 9 - Calculating Discounted Payback [LO3] An investment...Ch. 9 - Calculating Discounted Payback [LO3] An investment...Ch. 9 - Calculating AAR [LO4] Youre trying to determine...Ch. 9 - Calculating IRR [LO5] A firm evaluates all of its...Ch. 9 - Calculating NPV [LO1] For the cash flows in the...Ch. 9 - Calculating NPV and IRR [LO1, 5] A project that...Ch. 9 - Calculating IRR [LO5] What is the IRR of the...Ch. 9 - Prob. 11QPCh. 9 - NPV versus IRR [LO1, 5] Garage, Inc., has...Ch. 9 - Prob. 13QPCh. 9 - Problems with IRR [LO5] Light Sweet Petroleum,...Ch. 9 - Prob. 15QPCh. 9 - Problems with Profitability Index [LO1, 7] The...Ch. 9 - Comparing Investment Criteria [LO1, 2, 3, 5, 7]...Ch. 9 - NPV and Discount Rates [LO1] An investment has an...Ch. 9 - MIRR [L06] RAK Corp. is evaluating a project with...Ch. 9 - Prob. 20QPCh. 9 - Prob. 21QPCh. 9 - Cash Flow Intuition [LO1, 2] A project has an...Ch. 9 - Payback and NPV [LO1, 2] An investment under...Ch. 9 - Prob. 24QPCh. 9 - NPV Valuation [LO1] The Yurdone Corporation wants...Ch. 9 - Problems with IRR [LO5] A project has the...Ch. 9 - Problems with IRR [LO5] McKeekin Corp. has a...Ch. 9 - Prob. 28QPCh. 9 - Prob. 1MCh. 9 - Prob. 2MCh. 9 - Bullock Gold Mining Seth Bullock, the owner of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- After 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_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 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 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. www.themegallery.com Company Logo 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 $ 725 million today, and it will have a cash outflow of $80 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it.…arrow_forward
- 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 also has projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $950 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…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 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 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_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_forwardA new diamond deposit has been found in northern Alberta. Your researchers have determined that it will cost $2.5 million to purchase the land and prepare it for mining. At the beginning of both the second and third years, another $1 million investment will be required to establish the mining operations. Starting at the end of the second year, the deposit is expected to earn net profits of $3 million, which will be sustained for three years before the deposit is depleted. If the cost of capital is 16%, should your company pursue this venture? Provide calculations to support your decision.arrow_forwardA new diamond deposit has been found in northern Alberta. Your researchers have determined that it will cost $4.5 million to purchase the land and prepare it for mining. Starting at the end of the second year, the lode is expected to earn net profits of $3 million, which will be sustained for three years before the deposit is depleted. Calculate the IRR on the diamond mine. If the cost of capital is 21%, should the deposit be aquired?arrow_forward
- Investment Criteria. The Utah Mining Corporation is set to open a gold mine near Provo, Utah. According to the treasurer, Monty Goldstein, “This is a golden opportunity.” The mine will cost $750,000 to open and will have an economic life of 6 years. It will generate cash inflow of $175,000 at the end of the first year, and the cash inflows are projected to grow at 5 percent per year for the next 5 years. What is the IRR for the gold mine? Please show the work.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,100,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: 50,000 tons Year 2: 90,000 tons Year 3: 100,000 tons Year 4: 110,000 tons Year 5: 130,000 tons Calculate the depletion expense for the next five years, and create the journal entry for year one.arrow_forwardUnderwoods Miners recently purchased the rights to a diamond mine. It is estimated that there are two million tons of ore within the mine. Underwoods 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 and create the journal entry for year one.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License