o more iformation to add,

Use the data set which is labeled on your name in Excel sheet. Names are given alphabetical from A to Z. [ Click on left or right to find the sheet with your name] Hook Industries is considering the replacement of one of its old drill presses. Three alternative replacement presses (A, B and C) are under consideration. The relevant cash flows associated with each are shown in the excel sheet uploaded on Eduoasis. The 'r' in the excel sheet (Yellow color) represents required rate of return. Calculate the payback period, internal rate of return, net present value, and profitability index of proposed projects. Select one project after doing the above analysis and justify the selection. c D 0.15 E G H A J L K 0.151 M Year N P Year 3 0-385000 1 30000 2 95000 3 145000 4 190000 5 205000 0 120000 7 10000 8 70000 3 116000 B Ir CF 0-430000 1 72000 2 90000 120000 4 190000 205000 100000 7 110000 76000 9 48000 101 F0000 9 O C Year CF 0 -020000 1 90000 2 120000 3 170000 4 200000 5 225000 210000 115000 100000 85000 50000 11 11000g 10 2 0 19