financial statements of two companies competing in the same industry follows. Data from the current year-end...

Transcribed Image Text:

financial statements of two companies competing in the same industry follows. Data from the current year-end balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings income statement Sales Barco Company Kyan Company Barco Company Kyan Company Data from the current year's $ 790,000 $ 888,200 $ 20,000 $ 34,000 35,400 53,400 84,840 134,500 7,200 310,400 593,100 650,500 8,000 18,000 15,185 24,521 173,715 195,179 4.14 4.52 3.77 3.94 5,700 370,000 $ 515,940 $ 539,500 Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividends per share Beginning-of-year balance sheet data $ 68,340 $ 94,300 Accounts receivable, net $ 29,800 $ 58,200 84,800 111,000 Merchandise inventory 53,600 113,400 216,000 Total assets 418,000 372,500 152,800 118,200 Total liabilities and equity $ 515,940 $ 539,500 Common stock, $5 par value Retained earnings 210,000 216,000 137,425 93,229 210,000 Required: 1a. For both companies compute the (a) current ratio, (b) acid-test ratio, (c) accounts receivable turnover, (d) inventory turnover, (e) days' sales in inventory, and (f) days' sales uncollected. Note: 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 Ratio Turn 1A Invent Turnover 1A Days Sal in 1A Days Sal Inv Uncol 1B short term For both companies compute the days' sales in inventory. Company Barco Kyan Numerator: 1 Days' Sales in Inventory Denominator: X Days = < 1A Invent Turnover x = = Days' Sales in Inventory Days' sales in inventory 1A Days Sal Uncol > 0 days 0 days financial statements of two companies competing in the same industry follows. Data from the current year-end balance sheets Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings income statement Sales Barco Company Kyan Company Barco Company Kyan Company Data from the current year's $ 790,000 $ 888,200 $ 20,000 $ 34,000 35,400 53,400 84,840 134,500 7,200 310,400 593,100 650,500 8,000 18,000 15,185 24,521 173,715 195,179 4.14 4.52 3.77 3.94 5,700 370,000 $ 515,940 $ 539,500 Cost of goods sold Interest expense Income tax expense Net income Basic earnings per share Cash dividends per share Beginning-of-year balance sheet data $ 68,340 $ 94,300 Accounts receivable, net $ 29,800 $ 58,200 84,800 111,000 Merchandise inventory 53,600 113,400 216,000 Total assets 418,000 372,500 152,800 118,200 Total liabilities and equity $ 515,940 $ 539,500 Common stock, $5 par value Retained earnings 210,000 216,000 137,425 93,229 210,000 Required: 1a. For both companies compute the (a) current ratio, (b) acid-test ratio, (c) accounts receivable turnover, (d) inventory turnover, (e) days' sales in inventory, and (f) days' sales uncollected. Note: 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 Ratio Turn 1A Invent Turnover 1A Days Sal in 1A Days Sal Inv Uncol 1B short term For both companies compute the days' sales in inventory. Company Barco Kyan Numerator: 1 Days' Sales in Inventory Denominator: X Days = < 1A Invent Turnover x = = Days' Sales in Inventory Days' sales in inventory 1A Days Sal Uncol > 0 days 0 days