Reference no: EM131067461
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 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 on this page. Bullock Mining has a 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 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.
|
Discuss your advocacy project and how you will implement
: Advocating for Your Children - A Preservice Teacher Education Project and What you will do as a teacher to continue this type of advocacy.
|
|
Use the minus sign to indicate cash out flows
: Land Transactions on the A summary of the cash receipts and cash payments for a specific period of time, such as a month or a year.Statement of Cash Flows Easterly Corporation purchased land for $398,000. Later in the year, the company sold a diff..
|
|
What are some of the symptoms and is it treatable or curable
: For your first post, write a description about the disease/disorder you chose. What are some of the symptoms? Is it treatable/curable? If so, how?
|
|
Using the sales-based inventory turnover ratio
: Mall Toys Co. has a quick ratio of 2.00x, $32,175 in cash, $17,875 in accounts receivable, some inventory, total current assets of $71,500, and total current liabilities of $25,025. The company reported annual sales and cost of goods sold of $300,000..
|
|
Calculate the payback period-internal rate of return
: 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, a..
|
|
Examine the song lyrics as an example of poetry
: Find a song you enjoy or find interesting. Copy the complete lyrics down. Lyrics are usually found in the CD jacket or online. This song must contain at least one metaphor or simile.
|
|
Describe the relationship between chromosomes and dna
: Describe the relationship between chromosomes and DNA. Identify an example of a genetic disorder and describe the genetic disorder including symptoms, impact on quality of life, and life expectancy. How common is this disorder?
|
|
Conductivities off brass and copper
: What mass of ice is melted in 5.10 min by the heat conducted by the composite rod? [Hint: Thermal conductivities off brass and copper are 109.0 W/(m⋅K) and 385.0 W/(m⋅K), respectively.]
|
|
Account paying interest convertible monthly
: David makes a sequence of 38 monthly deposits of $450 each into an account paying interest convertible monthly. Immediately after making the 38th deposit, the account balance is $18870.45 dollars. What is the nominal rate of interest convertible mont..
|