please do all parts to this one question and do it in excel not handwritten thanks

Required information Below is summary information from the financial statements of 2 separate entities. Both entities operate in the same industry. Barco Kyan Company Company Data from the current year-end balance sheets Assets Cash $ 20,000 $ 37,000 Accounts receivable, net 38,400 59,400 Merchandise inventory 84,440 140,500 Prepaid expenses 5,500 7,350 Plant assets, net 290,000 304,400 Total assets $438,340 $548,650 Barco kyan Company Company Data from the current year's income statement Sales $770,000 $914,200 Coat of goods sold 594,100 642,500 Interest expense 8,500 17.000 Income tax expense 14,800 25,238 Net income 152,600 229,462 Basic earnings per share 4.24 5.85 Cash dividends per share 3.76 3.91 Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings Total liabilities and equity $ 67,340 $101,300 78,800 115,000 180,000 196,000 112,200 136,350 $438,340 $548,650 Beginning-of-year balance sheet data Accounts receivable, net Merchandise inventory Total assets Common stock, $5 par value Retained earnings $ 28,800 $ 51,200 57,600 117,400 438,000 422,500 180,000 196,000 94,960 60,160 Required: 1a. For both companies compute the (a) current ratio, (b) acid-test ratio, ( accounts receivable turnover, () inventory turnover. (e) days' sales in Inventory, and (7 days' sales uncollected. (Do not round intermediate calculations.) 1b. Identify the company you consider to be the better short-term credit risk. Complete this question by entering your answers in the tabs below. Ratio 1A Current 1A Acid Test 1A Acct Rec 1A Invent 1A Days Sal in 1A Days Sal Ratio Turn Turnover Iny Uncol 18 short term For both companies compute the current ratio. (a) Current Ratio Company Choose Numerator: Choose Denominator: = Current Ratio Current assets 1 Current liabilities Current ratio Barco $ 148.000 $ 67,340 = 22 to 1 Kyan $ 118,100/ $ 101,300] = 1.2 to 1 A Current Ratio 1A Acid Test Ratio > 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent A Days Salin 1A Days Sal Turnover Uncol 18 short term For both companies compute the acid-test ratio, Acid-Test Ratio Choose Numerator (b) Company Cash Barco Kyan Choose Denominator Current abilities Acid Testai Acid-best rabo 101 0151 1A Current Ratio 1A Acid Test Ratio 1A Accorec Turn 1A Invent Turnover 1A Days Salin Inv 1A Days Sal Uncol 1B short term For both companies compute the accounts (Including notes) receivable turnover. - (c) Company Choose Numerator: Accounts Recevable Turnover Choose Denominator: - Accounts Receivable Turnover = Accounts receivable turnover 0 times 0 times Barco Kyan 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1A Days Salin 1A Days Sal Inv Uncol 18 short term For both companies compute the inventory turnover. Company Choose Numerator Inventory Turnover Choose Denominator: 1 - Inventory Turnover Inventory turnover o times Barco 1 Kyan / O times 1A Current 1A Acid Test 1A Acct Rec 1A Invent 1A Days Salin 1A Days Sal Ratio Ratio 18 short term Turn Turnover Inv Uncol For both companies compute the days' sales in inventory. () Days' Sales In Inventory Company Choose Numerator Choose Denominator: Days = Days Sales In Inventory = Days' sales in inventory = Barco 0 days x o days Kyan X 1A Current 1A Acid Test 1A Acct Rec 1A Invent 1A Days Sal in 1A Days Sal Ratio Ratio Turn 18 short term Turnover Iny ncol For both companies compute the days' sales uncollected. (0 Days' Sales Uncollected CompanyChoose Numerator: 1 Choose Denominator: x Days + Days' Sales Uncollected = Days' sales uncollected Barco 0 days Kyan 11 11 o days 1A Current Ratio 1A Acid Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1A Days Salin IA Days Sal Iny Uncol 1B short term Identify the company you consider to be the better short-term credit risk. Better short-term credit risk