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 = <u>$264,040 HIGHEST NPV, SO THIS PROJECT SHOULD BE SELECTED</u>
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
