Net Present value-tinequal thes Dakota Mining Coingemy has two competing preposalst a d amond core drill or a bydraulic excavator, Both pieces of equipment hive an initial investmeet of 5730,000 The net cath flows estimated for the two proposals are as follows: The estimated rasou value of the diamond cere drill at the end of Year 4 is $20,000 This intormation has been collected in the Microsont fxcel Oeline fle. Open the spreadsheet, perform the required analyus, and input vour ansers in the goestions below. Qpect tiresdsect Cetermine which equipmem inbidd te favored, cemparing the net present vaies of the the proposals and assurting a minimim rate of retum of ism. If required, reund to the nearest doliar. The estimated residual value of the diamond core drill at the end of Ycar 4 is $280,000. This information has been collected in the Microsoft Excel Online file. Open the spreadshect, perform the required analysis, and input your answers in the questions bele Open spreadsteet Determine which equigment should be fovored, 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. Fchaniwis 3) sibtred the amourd to be invesied from the bal ipesent valie of ere net cash fore