present value (NPV) of each press. ate fron tabi Data Table fron -X N Ais (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $ s $] Initial investment (CF) Year (t) Machine C $130,000 ook Indi Machine A Machine B $85,200 $60,200 Cash inflows (CF) $18,200 $11,500 $18, 200 $14,300 $18,200 $15,600 $18,200 $18,100 $18,200 $19,700 $18,200 $25,500 $18,200 $18,200 1 2 3 4 5 6 7 8 Ind $50,400 $29,600 $20,200 $20,300 $20,500 $29,700 $39,600 $50,300 esse ber ber Print Done is (Round to two decimal places) (Round to two decimal places.) NPV --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 The firm's cost of capital is 14% 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 (PD) for each press e. Rank the presses from best to worst using PL a. The NPV of press Ais $. (Round to the nearest cent) The NPV of press B is $(Round to the nearest cent) The NPV of press Ciss (Round to the nearest cent) ho b. Based on NPV, Hook Industries should press A. (Select from the drop-down menu.) Based on NPV Hook Industries should Select from the drop down menu) rejec accept Based on NPV, Hook Industries should Select from the drop down menu) c. 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) d. The Pl of press Ais (Round to two decimal places) The Pl of press Bis (Round to two decimal places.) F c. In ranking the presses from best to worst is the number 1 investment. (Select from the drop-down menu.) is the number 2 investment (Selec Press B wn menu) Press A wn menu.) N is the number 3 investment (Selec Press C d. The Pl of press Ais (Round to two decorar The Pl of press Bis (Round to two decimal places.) The Pl of press Cis (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 hyeg NPV-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 The firm's cost of capital is 14% 3. 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 PL Based on NPV, Hook Industries should press B (Select from the drop-down menu.) Based on NPV Hook Industries should press C (Select from the drop-down menu.) C. 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.) d. The Pl of press Ais (Round to two decimal places) The P1 of press Bis (Round to two decimal places.) The Pl of press Cis. (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 (Sele bwn menu.) is the number 3 investment (Sele Press A Press B Press C own menu) Enter your answer in each of the answer boxes
