NPV - Mutually exclusive projects Hook Industries is considering the replacement of one of told metal stamping machines. Three antive replacement machines are under consideration. The relevant cash Bows associated with each are shown in the following table. The firm's cost of capital is 11% Calculate the net present value (NPV) of each press Data Table b. Using NPV, evaluate the acceptability of each press c. Rank the presses from best to worst using NPY d. Calculate the profitability index (P) for each press . Rank the presses from best to worst using 21 Click on the con located on the top-right comer of the datatable below in order to copy its contents into a spreadsheet) The NPV of Dress Ais Round to the nearestent Machine A Machine Machine C The NPV of press Round to the nearesto Initial investment (CF) 584.000 100.100 5130,300 Year (0 Cash Intlows (CF) The NPV of resist (Round to the nearest cant) $17.700 $17.500 500 400 2 $17.700 $14.500 b. Based on NPV Hook Industries should $29.700 row (Select from the drop down menu.) 3 517.700 $15.000 320,400 4 $17.700 118.400 120.000 Based on NPV,Hooks (elect from the drop-down meru) $17,700 120.400 $19.500 $17.700 $25.400 $30.000 Based on NPV. Hook Industries should press (Select from the drop-down menu 7 $17.700 140.500 $17.700 350.200 cin ranking the present from best to worst is the number 1 investment (elect from the drop down menu) is the number 2 investment (Select from the drop-down menu.) Done 5 is the number 3 investment (Select from the drop down menu) d. The Pl of press A is (Round to two decimal places.) (Round to two decimal places.) The Pl of press B is The Pl of press C is (Round to two decimal places.) e. In ranking the presses from best to worst, is the number 1 investment. (Select from the drop-down menu.) is the number 2 investment. (Select from the drop-down menu.) is the number 3 investment. (Select from the drop-down menu.) Enter your answer in each of the answer boxes