Calculate the payback period and internal rate of return

Assignment Help Financial Accounting

Reference no: EM132480757

Point 1: Beth Boondock, owner of Boondock Silver Mining, is reviewing the details of a new silver mine in South Dakota. According to the company's geologist, Dory Donovan, a detailed analysis of the mine suggests it would be productive for eight years. After that amount of time, all of the silver ore would be completely mined. Dory sent an estimate of the silver deposits to Gina Albert, the company's chief financial officer. Beth has contacted Gina to request a full financial analysis of the new mine and to present her recommendations on whether the company should open the new mine. Gina used the estimates provided by Dory to determine the revenues that could be expected from the mine. She has projected both the annual operating expenses of the new mine and the expense of opening the mine. If the company opens the mine, it will cost $635 million today, and it will have a cash outflow of $45 million nine years from today in costs associated with closing the mine and reclaiming the surrounding area.

The expected cash flows each year each year from the mine are shown below:

Year- Cash Flow

0- $635,000,000

1- 89,000,000

2- 105,000,000

3- 130,000,000

4- 173,000,000

5- 205,000,000

6- 155,000,000

7- 145,000,000

8- 122,000,000

9- 45,000,000

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

Question 2. Based on analysis, should the company open the mine? Why or why not?

Reference no: EM132480757

Questions Cloud

Identify 5 markers that you can identify as masculine : Identify 5 markers /socialization that can be defined as feminine Identify 5 markers that you can identify as masculine in society.

What is depreciation : What is depreciation? Discuss the various depreciation methods. What is the difference between depreciation, depletion and amortization.

What is intangible asset : What is intangible asset? What are some approaches to value an intangible asset? What are the useful life of intangibles? provide the example

Calculate the working capital and current ratio : Calculate the working capital, current ratio, and acid-test ratio. Explain what additional information you would require in order to use the three measures

Calculate the payback period and internal rate of return : Calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposed mine.

What is the safety margin ratio at the given level of sales : What is the break-even point? What is the safety margin ratio at the given level of sales? What is the degree of operating leverage?

Compute all six variances : Compute all 6 variances and for each of them determine if they are favored or adverse, information is given about the unit standard costs

Prepare the appropriate entries for both Nguyen and Nevels : Nevels expects the residual value at December 31, 2024, will be $114,000. Prepare the appropriate entries for both Nguyen and Nevels on January 1, 2021

Determine which financial ratio would relevant to creditor : Determine Which financial ratio would be relevant to creditors such as the bank and why are these ratios of concern to the bank? and provide the example

User Account

All Pages