Problem 1 Capitol Health, Inc., is expanding its imaging department and needs to acquire a new computed tomography scanner (CT scanner). The CFO is trying to select the best option from among four alternatives. Capital Health's cost of capital (CCC) is 16%. The initial cost and future cash flows of the alternatives are presented below. Each of these scanners is expected to last for 10 years with a final residual value of $0 at the end of the 10th year of service. The first row of the table (for year 0) shows the price (cash outflow) of each scanner. The projects' expected net cash inflows (rows 1 10) are also presented in the table. Year 0 GE LP ($) -400,000 Aquilion LB ($) -400,000 Siemens AS 64 ($) Philips MX ($) -500,000 -600,000 1 110,000 40,000 100,000 120,000 2 110,000 50,000 100,000 100,000 3 100,000 60,000 100,000 100,000 4 80,000 70,000 100,000 70,000 5 80,000 90,000 100,000 70,000 6 80,000 90,000 100,000 20,000 7 60,000 130,000 100,000 120,000 8 60,000 150,000 100,000 300,000 9 50,000 160,000 100,000 300,000 10 50,000 180,000 100,000 300,000 | You can use excel to answer the different parts of this assignment. If you do, please submit your homework document and the excel file. If you are not submitting an excel file with the solutions, please document your work in the way you prefer. Undocumented solutions will not earn full credit. A) Calculate the Payback period for each alternative and complete the following table (round to two decimal places): GE LP Aquilion LB Siemens AS 64 Philips MX Payback period