thank you so much for your help

The intemal rate of retum method is used by Royston Construction Co. in analyzing a copital expenditure proposal that involves an investment of 5174,160 and annual nef cash fows of 540,000 for each of the sh years of its uscful Me This informotion has been collected in the Microsoft Excel Online fle. Open the spresdsheet, pefform the required analysis, and input your answers in the question beio. Open spreatsheet Determine the internsl rate of return for the proposal. x% Net Prevent Vilue-unequat Lives Dakota Moning Company has two competing propossis a datmond core drill or a hydraulc excavatoc, Both pieces of equipment have an initial investrent of $710, o0o. The net cosh flows estimated for the two proposals are as follons: The estimateo resiovel value of the damond coie drill at the ent of Year 4 is $270,000 This intormation has been collected in the Michosoh Excei online file. Open the spresidshert, perform the required analysn, and input your answers in the questions below. Determine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 10%. If required, round to the nearest dolis