Analysis of the new mine and present

Assignment Help Finance Basics
Reference no: EM131387651

CHAPTER CASE

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 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.

Reference no: EM131387651

Questions Cloud

Explain whether jones and walker would be successful : Walker made offers to complete the job, but Jacobs declined to permit Walker to fulfill his contract. Explain whether Jones and Walker would be successful in an action against Jacobs for breach of contract.
Will the movie theatre owner prefer this arrangement : The movie distributor charges a movie theatre $ 8 per ticket to watch a movie. Suppose the theatre can seat a maximum of 1,900 people. The demand for the movie is different for the afternoon showing and for the evening showing. Suppose that the movie..
Provide a brief description of organisation which it belongs : Provide a brief description of this organisation and the industry to which it belongs. You may also want to include in this description any mission statements, value statements or ‘slogans' that this organisation utilizes to communicate its purpos..
Explain who will prevail : Barta, therefore, could not obtain a leasing agreement meeting his approval. Barta refused to close the sale. In a suit by K&K Pharmacy against Barta for breach of contract, who will prevail? Explain.
Analysis of the new mine and present : 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.
Draw the fully reduced state diagram : (State Reduction) Given the state diagram in Figure Ex. 8.5, draw the fully reduced state diagram. State succinctly what strings cause the recognizer to output a 1.
Record the entry that neumann would make : Neumann needs $160,000 to cover next Friday's payroll. Its balance of outstanding accounts receivable totals $800,000. To alleviate this cash crunch, the company sells $170,000 of its receivables. Record the entry that Neumann would make. (Assume ..
Component of the loan closing costs : We indicated that statutory costs are one component of the loan closing costs and as such the effective borrowing cost. In English, what do these mean?
Whether the restriction prohibits the construction : Robert V. Gross owned certain land on which he proposed to construct an eighty-three-unit apartment house.- Explain whether the restriction prohibits the construction and operation of an apartment house.

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd