PERMUM PP SEUNGGUVES Der Mining Company has two competing proposals a processing it and an electries to pieces of equipment have an initial westment 0,000, Thanh How stimated for the are as follows Net Cash Flow Year Processing Mil Electric Shovel 1 $307.000 $350,000 2 2711,000 315.000 3 278,000 319,000 260,000 322,000 5 100,000 130.000 2 121,000 121,000 The estimated residual value of the processing in the end of Year 4 is $200,000 This information has been collected in the Microsoft Excel Online File Open the spreadshest perform the required analysis, and out your answers in the questions below Open sonder Determine which eument should be favored, comparing the nepret valts of the two proposals and sun amitimum rate of return of 12 roond to the rest Processing Mill Electric Shovel Net present value P 121,000 121,000 The estimated residual value of the processing mill at the end of Year 4 $280,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below D Open spreadsheet Determine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 123. If required, mount to the nearesto Processing Mill Electric Shovel Net present value Which project should be favored? Electric Shovel