Dakota Mining Company has two competing proposals: a diamand core drill or a hydralic excayator. Both pleces of equipment have an iniciar iovestment of 5730,000. The net cash flows estimated for the two nrannoule The estimated residual valun of the diamond cone drat at the end of Year 4 is $260,000. This information has been coliected in the Microsoft Excel Online file. Open the spreaditieet, perform the required analysis, and input your ansmers in the ouestoni below. Opert spreadsheet Determine which equipenervt should be favored, camparing the not present values of the two nroposals and asiuming a minumum rete of retura of ists. If reauired, round to the nearest dollar. The estimated residual value of the diamond core drill at the end of Year 4 is $280,000. This information has been collected in the Microsoft Excel Online flie, Open the spreadsheet, perform the required analysis, and ingut your answers in the questions below. 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 s. if required, round to the nearest dollar