Question

Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. Both pieces of equipment have an initial investment of $750,000. The net cash flows estimated for the two proposals are as follows:
Net Cash Flow Year Processing Mill Electric Shovel
1 $310,000 $330,000
2 260,000 325,000
3 260,000 325,000
4 260,000 320,000
5 180,000
6 130,000
7 120,000
8 120,000
The estimated residual value of the processing mill at the end of Year 4 is $280,000.
Present Value of $1 at Compound Interest
Year 6% 10% 12% 15% 20%
1 0.943 0.909 0.893 0.870 0.833
2 0.890 0.826 0.797 0.756 0.694
3 0.840 0.751 0.712 0.658 0.579
4 0.792 0.683 0.636 0.572 0.482
5 0.747 0.621 0.567 0.497 0.402
6 0.705 0.564 0.507 0.432 0.335
7 0.665 0.513 0.452 0.376 0.279
8 0.627 0.467 0.404 0.327 0.233
9 0.592 0.424 0.361 0.284 0.194
10 0.558 0.386 0.322 0.247 0.162
Determine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 15%. Use the present value table appearing above. If required, round to the nearest dollar.
Processing mill electric shovel
Present value of net cash flow total $_____ $_____
Less amount to be invested $_____ $_____
Net present value $_____ $_____

Answer 1

Answer:

Year    NCF Processing Mill     NCF Processing Mill     NCF Electric Shovel

0          -$750,000                        -$750,000                      -$750,000      

1           $310,000                          $310,000                        $330,000

2          $260,000                         $260,000                       $325,000

3          $260,000                         $260,000                       $325,000

4          $260,000                         $540,000                       $320,000

5          $180,000

6          $130,000

7          $120,000

8          $120,000

discount rate = 15%

NPV Processing Mill (8 years) = -$750,000 + ($310,000 x .87) + ($260,000 x .756) + ($260,000 x .658) + ($260,000 x .572) + ($180,000 x .497) + ($130,000 x .432) + ($120,000 x .376) + ($120,000 x .327) = -$750,000 + $267,700 + $196,560 + $171,080 + $148,720 + $89,460 + $56,160 + $45,120 + $39,240 = -$750,000 + $1,014,040 = $264,040 HIGHEST NPV, SO THIS PROJECT SHOULD BE SELECTED

NPV Processing Mill (4 years) = -$750,000 + ($310,000 x .87) + ($260,000 x .756) + ($260,000 x .658) + ($540,000 x .572) = -$750,000 + $267,700 + $196,560 + $171,080 + $308,880 = -$750,000 + $944,220 = $194,220

NPV Electric Shovel (4 years) = -$750,000 + ($330,000 x .87) + ($325,000 x .756) + ($325,000 x .658) + ($320,000 x .572) = -$750,000 + $287,100 + $245,700 + $213,850 + $183,040 = -$750,000 + $929,690 = $179,690