Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. Both pieces of equipment have an initial investment $800,000. The net cash flows estimated for the two proposals are as follows: Net Cash Flow Processing Mill Electric Shovel $318,000 $349,000 251,000 323,000 251,000 312,000 249,000 312,000 184,000 137,000 120,000 120,000 The estimated residual value of the processing mall at the end of Year 4 is $270,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 questions below x1 Open spreadsheet values of the two proposals and assuming a minimum rate of return of 1596. IF Determine which equipment should be favored, comparing the net preser required, round to the nearest dollar Processing Mill Electric Shovel 251,000 312,000 249,000 312.000 184,000 137,000 120,000 120,000 The estimated residual value of the processing mill at the end of Year 4 is $270,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 questions below. X2 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 15%. If required, round to the nearest dollar Processing Mill Electric Shovel Net present value S Which project should be favored? Net present vakre unequal lives Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. The following data is provided Year DATA Net Cash Flow Processing Mill Electric Shovel 5318 000 $349.000 251.000 323.000 251.000 312.000 249 000 312,000 270 000 184.000 137.000 128 000 128.000 4 (residual value) Initial investment $800.000 POO Initial investment Minimum rate of return $800,000 15% Using formulas and cell references, perform the required analysis, and input your answers into the Processing Mill and Electric Shovel columns. Transfer the numeric results for the green entry cells (C24:D24) into the appropriate fields in CNOWV2 for grading. Processing Mill Electric Shovel Formulas Net present value