Calculate the payback period-internal rate of return

Reference no: EM13979439

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 to determine the revenues that could be expected from the mine. She has projected the expenses of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $850 million today, and it will have a cash outflow of $120 million nine years from today in costs associated with closing the mine and reclaiming the area. The expected cash flows each year from the mine are shown in the following table. Bullock Mining has a 12 percent required return on all of its gold mines.

Year	Cash Flow
0	$(850,000,000.00)
1	$165,000,000.00
2	$190,000,000.00
3	$225,000,000.00
4	$245,000,000.00
5	$235,000,000.00
6	$195,000,000.00
7	$175,000,000.00
8	$155,000,000.00
9	$(120,000,000.00)

1. Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposal.

2. Based on the previous analysis, should the company open the mine?

Reference no: EM13979439

Questions Cloud

Describe the different test events : Describe the different test events and what aspects of the system are covered during each event.

Calculate the common financial ratios : Using only annual numbers, please calculate the common financial ratios found in table 3.5 in the textbook for these companies(Look at the attached slide# 11). What do these ratios mean? Are the ratios similar for all of the companies?

What is the electric field at a point in the cavity : What is the electric field at a point in the cavity, a distance r = 1.50 cm from the center? What is the electric potential at r = 5.00 cm from the center? Find the potential at r = 1.50 cm from the center.

Describe possible approaches to a systems development effort : Describe possible approaches to a systems development effort and the advantages and disadvantages of each approach.

Calculate the payback period-internal rate of return : Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposal.

What must change in order for falling object to change speed : Most importantly, what must change in order for the falling object to change its speed? Is it the distance to the centre of the planet? If you pull the earth away from the object as the object falls, will the object slow down or will it keep acce..

Design and develop a relational database : You are required to produce a structured database design for the LCR system that will represent a blue-print/documentation for the system and create and populate the relational database for the London Car Rental System as specified in Assignment - ..

Problem regarding the parent point of view : (A) Is the proposed project, as given, worthwhile from the project point of view? (B) Is the proposed project, as given, worthwhile from the parent's point of view?

Find magnitude of the impulse exerted by the clay on cart : Suppose the cart has mass m = 348 g, and it strikes the clay at speed vo = 1.77 m/s and comes to a dead stop. Assume the track is frictionless, and the clay is crushed inward by 2.04 cm. Find the magnitude of the impulse exerted by the clay on the ..

User Account

All Pages