Question

1. Do the following problems In Excel. Submit your Excel spreadsheet so I can see how you solved the problems.    In 2013, Barrick Gold, a Canadian mining company, adopted a plan to accumulate remediation beginning Aug. 2, 2018 at an estimated cost of $32 million. Barrick plans to make equal semiannual payments into a fund earning 5.2% interested compounded semiannually. The first deposit is scheduled for Aug. 1, 2013. Determine the required semiannual deposit. First determine how many payments Barrick will be making. Assume the last payment is made on Feb. 1, 2018 but the funds are not needed until Aug. 1, 2018.

N =            I/Y =               PV =                PMT =             FV =

2. Assume the same facts as in part 1, except on Feb. 1, 2016, due to financial problems, Barrick deposit nothing in the fund. After this date, they resume and make sufficient equal payments to meet their goal of $32 million on Aug. 1, 2018. In other words, they make the same amount of payments in the fund as part 1 from Aug. 1, 2013-Aug. 1, 2015. Determine the first set of required payments and the second set of required payments. Show your work.

3. Barrick is comparing two gold mines.

*Mine A:

The mine is expected to make $3.5 billion in year 1, $4.5 billion in year 2, and $5.5 billion in years 3-6 and $4.25 billion in years 7-10. At the end of year 10, Barrick will need to spend $202 million on environmental clean-up costs and expects the residual value to be $200 billion.

*Mine B:

The mine is currently in operation and produces $4.1 billion per year. At the end of 10 years the residual value would be $200 billion and no environmental clean-up costs would be necessary.

Which mine should Barrick buy for $142 billion. (To simplify things, assume Net Income is earned one time per year at the end of the year.) The appropriate discount rate is 6.22% compounded quarterly. Show your work.

Answer 1