please show how to complete part D using excel with instructions.

-Mutually 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: 5. The firm's cost of capital is 15%. a. Calculate the net present value (NPV) of each press. 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 Pi. a. The NPV of press Ais $ - 4228.21. (Round to the nearest cent.) The NPV of press B is $ 2,584.34. (Round to the nearest cent.) The NPV of press C is $ 15,043.89. (Round to the nearest cent.) b. Based on NPV, Hook Industries should reject press A. (Select from the drop-down menu.) Based on NPV, Hook Industries should accept press B. (Select from the drop-down menu.) Based on NPV, Hook Industries should accept press C. (Select from the drop-down menu.) c. In ranking the presses from best to worst, Press C is the number 1 investment. (Select from the drop-down menu.) Press B is the number 2 investment. (Select from the drop-down menu.) Press A is the number 3 investment (Select from the drop-down menu) d. The Pio press Ais (Round to two decilaal places.) Enter your answer in the answer box and then click Chock Answer 5 parts remaining Clour All Check Answer 100N 2:33 PM 4/11/2021 he pre i Data Table - X sv of of pre (Click on the icon here into a spreadsheet.) in order to copy the contents of the data table below of pre ed on NA Machine C $130,000 on NPV on NPV. Initial investment (CF) Year (t) 1 2 3 4 5 6 7 B Machine A Machine B $85,000 $60,000 Cash inflows (CF) $18,000 $12,000 $18,000 $14,000 $18,000 $16,000 $18,000 $18,000 $18,000 $20,000 $18,000 $25,000 $18,000 $18,000 ranking $50,000 $30,000 $20,000 $20,000 $20,000 $30.000 $40,000 $50,000 pwn menu.) SB is the SSA is the The Pl of pre Print Dono