P10-10 (similar to) The firm's NPVMutually exclusive projects Hook Industries is considering the replacement of one of its old metal stamping machines. Three alternative replacement machines are under consideration. The relevant cash flows associated with each are shown in the following table: cost of capital is 12%. a. Calculate the net present value (NPV) of each press. Data Table x b. Using NPV, evaluate the acceptability of each press. c. Rank the presses from best to worst using NPV. d. Calculate the profitability index (PI) for each press. e. Rank the presses from best to worst using Pl. (Click on the icon located on the top-right corner of the data table below in order to a. The NPV of press A is $ (Round to the nearest cent.) copy its contents into a spreadsheet.) Machine A Machine B Machine C Initial investment (CF) $85,400 $59,900 $130,400 Year (t) Cash inflows (CF) 1 $18,100 $11,900 $49,800 2 $18, 100 $29,600 3 $18, 100 $16,300 $20,000 $18,100 $18,400 $20,300 5 $18, 100 $19,600 $20,100 6 $18, 100 $25,200 $30,300 7 $18, 100 $40,400 8 $18, 100 $49,800 $13,800 4 Print Done