Calculate payback period-net present value of proposed mine

Assignment Help Financial Management

Reference no: EM13937496

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

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: EM13937496

Questions Cloud

Compute the irr on the cash flow streams : An initial investment of $27,775 followed by a single cash flow of $45,590 in year 6. (Round intermediate calculations to 0 decimal places, e.g. 1,251 and final answer to 2 decimal places, e.g. 15.25%.) IRR _______ %. An initial investment of $833,32..

The discounted payback period for the project : Nugent Communication Corp. is investing $9,145,700 in new technologies. The company’s management expects significant benefits in the first three years after installation (as can be seen by the following cash flows), and smaller constant benefits in e..

Calculate interest and principle for the payments : The investor takes $200,000 loan (at time zero) to purchase the machine at 8% interest rate. Loan has to be repaid by constant annual payments from year 1 to year 5 (5 payments). Assume 40% tax and minimum rate of return 10%. Calculate interest and p..

What are examples of uses for sensitivity analysis : What are examples of uses for sensitivity analysis and what-if scenarios? Give examples from your work experience or research?

Calculate payback period-net present value of proposed mine : 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. Construct a spreadsheet to calculate the payback period, internal rat..

Agreement to purchase all of the outstanding shares : In August 2008, Apburn Inc. entered into an agreement to purchase all of the outstanding shares of Ballard Corp. for $80 per share. Immediately prior to the Apburn Inc.’s bid, the shares of Ballard Corp. traded at $40 per share. The number of outstan..

What is the new van terminal cash flow : Your company is considering the replacement of an old delivery van with a new one that is more efficient. The old van cost $40,000 when it was purchased 5 years ago. The old van is being depreciated using the simplified straight -line method over a u..

Calculate the profitability of the chester company account : Wizard Corporation has analyzed their customer and order handling data for the past year and has determined the following costs: Order processing cost per order $7 Additional costs if order must be expedited (rushed) $10.00 Customer technical support..

What is the value of the treynor measure of this portfolio : A stock has a total return of 16.4%, a standard deviation of 14.5% and a beta of 1.63. The market rate of return is 12.4%, while the market's Treynor measure is 6.3. What is the value of the Treynor measure of this portfolio?

User Account

All Pages