Construct a spreadsheet to calculate the payback period

Assignment Help Financial Econometrics

Reference no: EM13328791

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. Bullock Mining has a 12 percent required return on all of its gold mines.

Year	Cash Flow in $1,000,000s
0	-650
1	80
2	121
3	162
4	221
5	210
6	154
7	108
8	86
9	-72

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?

Reference no: EM13328791

Questions Cloud

How to prepare a multiple-step income statement for 2013 : sales revenue, $2,105; cost of goods sold, $1,250; selling expenses, $120; general and administrative expenses, $110; interest expense, $35; and gain on sale of investments, $50. Income tax expense has not yet been accrued.

Explain the rate of the reaction in terms of the product : H2(g) + I2(g) = 2HI(g) Write a general equation that expresses the rate of this reaction in terms of the product.

What amount would appear as cost of goods : What amount would appear as cost of goods sold on the income statement and Company management is approached by a new customer to fill a large one-time order for 1,000 books, a product similar to one offered to regular customers.

At what point does the ball have maximum speed : A toy cannon uses a spring to project a 5.23 g soft rubber ball. The spring is originally compressed by 4.90 cm and has a force constant of 8.04 N/m. At what point does the ball have maximum speed

Construct a spreadsheet to calculate the payback period : 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.

Explain the equilibrium a mixture of reactants and products : The equilibrium constant for this reaction at 1400K is 4.7. A mixture of reactants and products at 1400K contains 0.035 M H2O, 0.050 M CH4, 0.15 M CO, and 0.20 M H2

Find the coefficient of friction between skis and the snow : An olympic skier moving at 20.0 m/s down a 30.0 Degrees slope encounters a region of wet snow and slides 145 m before coming to a halt

Find the minimum radius you can use for the vertical loop : You are designing the section of a roller coaster ride. Previous sections of the ride give the train a speed of 14.9 m/s at the top of the incline, find the minimum radius you can use for the vertical loop

Explain the reaction of 3-methyl-2-butanol and hbr : In the reaction of 3-methyl-2-butanol and HBr, determine the products that would be made. Explain why the experiment will not be as successful for production of an alkyl bromide as the reaction of 1-butanol with HBr.

User Account

All Pages