Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota.
Question:
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 | -650000000 |
| 1 | 80000000 |
| 2 | 121000000 |
| 3 | 162000000 |
| 4 | 221000000 |
| 5 | 210000000 |
| 6 | 154000000 |
| 7 | 108000000 |
| 8 | 86000000 |
| 9 | -72000000 |
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.
Net Present ValueWhat is NPV? The net present value is an important tool for capital budgeting decision to assess that an investment in a project is worthwhile or not? The net present value of a project is calculated before taking up the investment decision at... Payback Period
Payback period method is a traditional method/ approach of capital budgeting. It is the simple and widely used quantitative method of Investment evaluation. Payback period is typically used to evaluate projects or investments before undergoing them,...
Step by Step Answer:
Input area Year Cash flow 0 650000000 1 80000000 2 121000000 3 1620...View the full answer
Essentials of Corporate Finance
ISBN: 978-1259277214
9th edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
