o Required information Problem 13-5A Comparative ratio analysis LO P3 The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. Barco Kyan Barco kyan Company Company Company Data from the current year end balance sheets Data from the current year's Income statement Assets Sales $790,000 $097,200 Cash $ 21,000 $ 35,000 Cost of goods sold 587,100 63250 Accounts receivable. net 33,400 51,400 Interest expense 7,600 16.000 Merchandise Inventory 84,940 128,500 Income tax expense 15,185 201709 Prepaid expenses 5,400 7,700 Net Income 179,915 273,931 plant assets, net 290,00 305,400 Basic earnings per share 5.00 Total assets $434,740 3528,000 Cash dividends per share 3.70 Liabilities and Equity Beginning of-year balance sheet data Current liabilities $ 61,340 5100,300 Accounts receivable, net $ 27,800 $ 55,200 Long-term notes payable 35,800 115,000 Merchandise Inventory 63,600 109.400 Connon stock, 35 par value 100,000 216,000 Total assets 448,000 382.500 Retained earnings 107,600 96.700 Common stock, 55 par value 150,000 216,00 Total liabilities and equity $434,740 3528.000 Retained earnings 60,385 46.865 3.15 Problem 13-5A Part 1 Required: 1a. For both companies compute the (a) current ratio, () acid-test ratio. (caccounts receivable turnover. (inventory turnover (c) days sales in inventory, and (1 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. 1A Current Ratio 1A Acid Test Ratio 1A Act Rec Turn 1A Invent Turnover IA Days Salin 1A Days Sal Iny Uncol 18 short term For both companies compute the current ratio. (a) Company Choose Numerator: Current assets Barco 5 144,740 Kyan 5 222.600 Current Ratio Choose Denoninator Current liabilities Current Ratio Current ratio 0001 Oto 1 1A Acid Test Ratio > Required information Problem 13-5A Comparative ratio analysis LO P3 The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. Barco Marco Kyan Company Company Company Company Data from the current year and balance sheets Data fron the current year's income statement Sales $790,000 $897,200 Cash 5 21,000 $ 15,000 Cont of goods sold 587,100 612.500 Accounts receivable, net 33,000 51,400 Interest expense 7.500 16,000 Merchandise Inventory 14,90 120,500 Income tax expense 15,185 24709 Prepaid expenses 5.400 2,700 Net Income 179,915223,931 plant assets, net 290.000 305,400 Basit earnings per share 5.00 1.18 Total assets 344,740 5520.000 Cash dividends per share 3.70 4.93 Liabilities and Equity Current liabilities Longteremtes payable Comstock, 35 p valve tetained earnings Total liabilities and equity Beginning-of-year balance sheet data $ 61,340 $100,100 Accounts receivable, et 55,00 115,000 Merchandise inventory 150,000 216,600 Total assets 107,600 96.300 Common stock, 15 par valve 1434,740 $520,00 Retainer arnings $ 27,000 $ 55100 69,00 109,400 448,000 382500 10,000 216,000 60, 46.65 Problem 13-5A Part 1 Required: 10. For both companies compute the current ratio (1) acid-test ratio, id accounts receivable turnover (inventory turnover (edays sales in inventory, and 1 days' sales uncollected. (Do not round intermediate calculations) tb. Identify the company you consider to be the better short term credits Complete this question by entering your answers in the tabs below. 1A Current ato IA Acid Test IA Acct ac Turn TA went Turnover 1A Days Salin LA wa Sal Inv Unce 1 short term For the companies compute the add-test ratio Acido h) Company Choco Nunerator Choose Denominato - Acid Test Hati Adid test ratio otot Barco 1 (A Current Ratio 1A Acel Rec Tum> 0 Required information Problem 13-5A Comparative ratio analysis LO P3 The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. arco Kyan Barco yan Company Company Company Company Data from the current year end balance sheets Data from the current year's income statement Assets Sales 5790,000 5897,200 Cash $ 21,000 5 35,000 cost of goods sold 567,100 632/500 Accounts receivable, net 33,400 51,400 Interest expense 7.000 16,000 Merchandise inventory 14,940 128,500 Income tax expense 15,165 24.769 Prepaid expenses 5,400 7,700 Net Inco 179,915 223,931 plant assets, net 290,00 305,400 Basic earnings per share 5.00 3.10 Total assets 5434,740 5520,000 Cash dividends per share 4.3 Liabilities and Equity Current liabilities Long-term rotes payable Common stock, 55 par value Retained earning Total liabilities and equity teginning of year balance sheet data 3 61,340 $100,300 Accounts receivable, et 35,800 115,000 Merchandise Inventory 180,000 216,000 Total assets 107.6 26,200 Connon stock. 55 par value 1434,740 5520,000 Retained earnings $ 27,000 $ 55,200 63.600 102,400 40,000 302500 100.000 216,000 60,585 46165 Problem 13-5A Part 1 Required: 10. For both companies compute the (a current ratio, (b) acid-test ratio, (accounts receivable turnover, to inventory turnover, (e days sales in inventory, and (days' sales uncollected (Do not round Intermediate calculations.) 1b. Identity the company you consider to be the better short-term credit risk Complete this question by entering your answers in the tabs below. 1A Current Ratio 1A Acid Test Ratio IA Acct Rec TOT 1A Invent Turnover 1A Days Salin 1A Days Sal Uncol th 10 short term For both companies compute the accounts (including notes) receivable turnover Accounts Receivable Turnover Choose Denominator Company Choose Numerator Accounts Receivable Tardver Accounts receivable turnover olis Barco Kyan Required information Problem 13-5A Comparative ratio analysis LO P3 The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. Barco kyan Barco Kyan Company Chany Company Company Data from the current year end balance sheets Data from the current year's income statement Assets Sales $790,000 $097,200 Cash $ 21,000 $ 35,000 Cost of goods sold Accounts receivable, net 587,100 6*2/500 33.400 51,400 Interest expense 7.000 16,000 Merchandise Inventory 84,940 128,500 Income tax expense 15,105 24.769 Prepaid expenses 5,400 7.700 Net Income Plant assets, het 129,915 223,931 290.000 305 400 Basic earnings per share 5.00 5.18 Total assets $431,940 5520,000 Cash dividends per share 3.70 Liabilities and Equity Beginning of year balance sheet data Current liabilities $ 61,340 5100, 500 Accounts receivable, net $ 27,000 $ 55,00 Lonsters notes payable 55,600 115,000 Merchandise Inventory 63,600 109,400 Common stock, 35 par Value 180,000 216,000 Total assets 40,000 382)500 Retained earnings 107.600 96,700 Connon stock, 55 por value 180, 216,00 Total liabilities and equity 1434,740 5525,000 detained earnings 0,335 46 Problem 13-5A Part 1 Required: 1a. For both companies compute the current ratio, acid test ratio, ( accounts receivable turnover (inventory turnovec (clays sales in inventory, and (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. 1A Current Ratio IA Add Test Ratio 1A Acct Rec Turn 1A Invent Turnover 1A Days Salin A Days Sal Inv Uncal 18 short term For both companies compute the inventory turnover. (4) Company Choose Numerater: Inventory Turnover Choose Denominator Inventory Tuniver Inventory tumover Domes Barco Myan O times Required information Problem 13-5A Comparative ratio analysis LO P3 The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. Sarco Kyan Barco kyan Company Company Company Data from the current year-end balance sheets Data from the current year's Income statement Assets Sales 5790,000 $897,200 Cash $ 21,000 $ 35,000 cost of goods sold 387,100 632/500 Accounts receivable, net 33,00 51,400 Interest expense 7,800 Merchandise inventory 16,000 84,940 128,500 Tacone expense Prepaid expenses 15,185 24769 5,400 7.700 et Inco 179,915 323,931 Plant assets, net 200.000 305,400 Basic earnings per share 5.60 9.18 Total assets $434,740 5520,000 Cash dividends per share 3.70 Liabilities and Equity Beginning-of-year balance sheet data Current liabilities $ 61,300 $100, 300 Accounts receivable, et $ 27,00 5551200 Long term notes payable 35,000 115.000 Merchandise intory 63.600 109,400 Common stock, 55 par value 150.000 216.000 Total assets 448,000 Retained earnings 107,600 5200 Con stock, 55 par value 180,00 215,000 Total liabilities and equity 5434,740 5520,000 Betained earnings 60,835 ces Problem 13-5A Part 1 Required: 1o. For both companies compute the (a current ratio. (b) acid-test ratio, id accounts receivable turnover (inventory turnover (edays sales in inventory, and (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. 1A Current Ratio LA Add Test Ratio 1A Act Rec Turn 1A Invent Turnover 1A Days Salin 1A Days Sal Ilv 18 short term For both companies compute the days' sales in inventory Dan Sales in letary Company Choose usator Choose Denominato Days Barco Kyan 24 Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows yan Barca Kyan Barco Company Company Company Data from the current year-end balance sheets Data from the current year's income statement Assets Sales 5790.000 $897,200 Cash $ 21,000 $ 35,000 Cost of goods sold 587.100 Accounts receivable, net 632/500 33,400 51,400 Interest expense 7. 16.000 Merchandise Inventory 114,940 128,500 Income tax expense 15,105 241769 Prepaid expenses 5,400 7,700 Net Income 179,915 plant assets, net 223,931 290,000 3es.400 Basic earnings per share 5.00 3.18 Total assets $434,740 5528,000 Cash dividends per share 3.70 Liabilities and Equity Beginning of-year balance sheet data Current liabilities $ 61,340 5100,300 Accounts receivable, net $ 27,000 $ 55200 Long term notes payable 35,000 115,000 Merchandise Inventory 63,600 109,400 Common stock, 35 par value 150.00 210,00 Total assets 445,000 382/500 Retained earnings 96.700 Cmon stock, 35 par value 180,00 216,000 Total abilities and equity 5414,740 3528,000 Retained earnings 60,00 46.865 Problem 13-5A Part 1 Required: 10. For both companies compute the current ratio) acid test ratio, ( accounts receivable turnover (chinventory turnover (edays sales in inventory, and ( 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. 1A Current Ratio 1A Acid Test Ratio JA Acct Rec Turn 1A Invent Turnover 1A Days Satin 1A Davy sal Inv Uncel 1 short term For both companies compute the days sales uncollected Company Choose Numeratori Daya Sales Uncollected Choose Denominator Barco Kyan Days - Days Sales collected Days Sales uncollected o days o days 1A Days Salin in 101 short terme> work 0 Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below) Summary information from the financial statements of two companies competing in the same industry follows. Barco Barco Company Company Company Data from the current year-end balance sheets Data from the current year's income statement Assets Sales $70.000 $197,200 Cash $ 21,000 $ 35,000 Cost of goods sold 587.100 2.500 Accounts receivable, et 51,400 Interest expense 7.100 15.00 Merchandise Inventory 84,940 128,500 Income tax expense 15,185 Prepaid expenses 26,79 7,700 Net Income 179,915 223,931 plant assets, net 290.000 305,400 Basic earnings per share 5.10 Total assets 5434,740 5528.000 Cash dividends per share 3.70 Liabilities and Equity Current liabilities Long term rotes payable Common stock, 55 par value Retained earnings Total liabilities and equity Beginning of year balance sheet data $ 61,540 5100,300 Accounts receivable, net 85,600 115,000 Merchandise Inventory 180,000 216.000 Total assets 107.000 90.700 Common stock, 55 par value 5434,740 5528,000 Retained earnings $ 27,100 $ 55.00 109,00 440,000 33200 150,000 216,000 6,385 45,665 Problem 13-5A Part 1 Required: 1a. For both companies compute the (m) current ratio (6) acid-test ratio. ( accounts receivable turnover, (cinventory turnover (edays sales in inventory, and (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. 1A Current Ratio 1A Adid Test Ratio 1A Acct Rec Turn 1A Invent 1A Days Salin A Days Sal Turnover Inw Lincol 1B short term Identify the company you consider to be the better short-term credit risk Bette sottm credits