Summary information from the financial statements of two companies
competing in the same industry follows.
Barco Company |
Kyan Company |
Barco Company |
Kyan Company |
|||||||||||
Data from the current year-end balance sheets | Data from the current year’s income statement | |||||||||||||
Assets | Sales | $ | 770,000 | $ | 880,200 | |||||||||
Cash | $ | 19,500 | $ | 34,000 | Cost of goods sold | 585,100 | 632,500 | |||||||
Accounts receivable, net | 46,500 | 64,600 | Interest expense | 7,900 | 13,000 | |||||||||
Merchandise inventory | 84,440 | 132,500 | Income tax expense | 14,800 | 24,300 | |||||||||
Prepaid expenses | 5,000 | 6,950 | Net income | 162,200 | 210,400 | |||||||||
Plant assets, net | 290,000 | 304,400 | Basic earnings per share | 4.51 | 5.11 | |||||||||
Total assets | $ | 445,440 | $ | 542,450 | Cash dividends per share | 3.81 | 3.93 | |||||||
Liabilities and Equity | Beginning-of-year balance sheet data | |||||||||||||
Current liabilities | $ | 61,340 | $ | 93,300 | Accounts receivable, net | $ | 29,800 | $ | 54,200 | |||||
Long-term notes payable | 80,800 | 101,000 | Merchandise inventory | 55,600 | 107,400 | |||||||||
Common stock, $5 par value | 180,000 | 206,000 | Total assets | 398,000 | 382,500 | |||||||||
Retained earnings | 123,300 | 142,150 | Common stock, $5 par value | 180,000 | 206,000 | |||||||||
Total liabilities and equity | $ | 445,440 | $ | 542,450 | Retained earnings | 98,300 | 93,600 | |||||||
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.
(Do not round intermediate calculations.)
1b. Identify the company you consider to be the
better short-term credit risk.
Current ratio indicates liquidity of company. It determines whether company has sufficient current assets available to pay its current liabilities | ||||||||
Company | Choose numerator | / | Choose denominator | = | Current ratio | |||
Current assets | / | Current liabilities | = | Current ratio | ||||
Barco | $155,440 | / | $61,340 | = | 2.53 | to 1 | ||
Kyan | $238,050 | / | $93,300 | = | 2.55 | to 1 | ||
b. | ||||||||
Acid test ratio | ||||||||
Company | Choose numerator | / | Choose denominator | = | Acid test ratio | |||
Current assets-Inventory-Prepaid expenses | / | Current liabilities | = | Acid test ratio | ||||
Barco | $66,000 | / | $61,340 | = | 1.08 | to 1 | ||
Kyan | $98,600 | / | $93,300 | = | 1.06 | to 1 | ||
c. | ||||||||
Accounts receivable turnover ratio | ||||||||
Company | Choose numerator | / | Choose denominator | = | Accounts receivable turnover ratio | |||
Sales | / | Average accounts receivable | = | Accounts receivable turnover ratio | ||||
Barco | $770,000 | / | $38,150 | = | 20.18 | times | ||
Kyan | $880,200 | / | $59,400 | = | 14.82 | times | ||
Average accounts receivable | ||||||||
Barco | (46500+29800)/2 | |||||||
Barco | $38,150 | |||||||
Kyan | (64600+54200)/2 | |||||||
Kyan | $59,400 | |||||||
d. | ||||||||
Inventory turnover ratio | ||||||||
Company | Choose numerator | / | Choose denominator | = | Inventory turnover ratio | |||
Cost of goods sold | / | Average inventory | = | Inventory turnover ratio | ||||
Barco | $585,100 | / | $70,020 | = | 8.36 | times | ||
Kyan | $632,500 | / | $119,950 | = | 5.27 | times | ||
Average inventory | ||||||||
Barco | (84440+55600)/2 | |||||||
Barco | $70,020 | |||||||
Kyan | (132500+107400)/2 | |||||||
Kyan | $119,950 | |||||||
e. | ||||||||
Days' sales in inventory | ||||||||
Company | Choose numerator | / | Choose denominator | * | Days | = | Days' sales uncollected | |
Average inventory | / | Cost of goods sold | * | 365 | = | Days' sales uncollected | ||
Barco | $70,020 | / | $585,100 | * | 365 | = | 43.68 | days |
Kyan | $119,950 | / | $632,500 | * | 365 | = | 69.22 | days |
f. | ||||||||
Days' sales uncollected | ||||||||
Company | Choose numerator | / | Choose denominator | * | Days | = | Days' sales uncollected | |
Average receivables | / | Sales | * | 365 | = | Days' sales uncollected | ||
Barco | $38,150 | / | $770,000 | * | 365 | = | 18.08 | days |
Kyan | $59,400 | / | $880,200 | * | 365 | = | 24.63 | days |
1B. | ||||||||
Current ratio of Kyan is higher than Barco while acid test ratio of Barco is slightly higher than that of Kyan | ||||||||
Accounts receivable and inventory turnover of Barco is better than kyan which indicates better short term liquidity. | ||||||||
Barco collects cash faster then Kyan and inventory converted is faster than kyan | ||||||||
Thus, based on above liquidity ratios better short term credit risk company is Barco. | ||||||||
Summary information from the financial statements of two companies competing in the same industry follows. ...
of 2 Summary information from the financial statements of two companies competing in the same industry follows. Sales Barco Kyan Company Company Data from the current year-end balance sheets Assets Cash $ 22,500 $ 35,000 Accounts receivable, net 35,400 57.400 Merchandise inventory 84,840 128,500 Prepaid expenses 5.800 7,200 Plant annets, net 320,000 309, 400 Total anseta $468,540 $537,500 Barco Kyan Company Company Data from the current year's income statement $770,000 $879,200 cost of goods sold 587,100 32,500 Interest expense 8.400...
Check my work Summary information from the financial statements of two companies competing in the same industry follows. Barco Kyan Company Company Data from the current year-end balance sheets Assets Cash $ 20,000 $ 35,000 Accounts receivable, net 35, 400 53,400 Current notes receivable (trade) 9.500 8.400 Merchandise inventory 34,740 136,500 Prepaid expenses 5,700 7150 Plant assets, net 290,000 308,400 Total assets $445, 340 $548.850 Barco Kyan Company Company Data from the current year's income statement Sales $750,000 $878, 200...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense 7,900 13,000 Merchandise inventory 84,440 132,500 Income tax expense 14,800 24,300 Prepaid expenses 5,000 6,950 Net income 162,200...
Summary information from the financial statements of two companies competing in the same industry follows. Barco Kyan Company Company Data from the current year and balance sheets Assets Cash $ 21,000 $31.000 Accounts receivable, et 37.400 54,400 Current notes receivable (trade) 9,800 3.200 Merchandise inventory 84,840 134,500 Prepaid expenses 6,200 2,850 Plant annets, net 290,000 306,400 Total assets $449,240 $542,350 Barco Kyan Company Coepany Data from the current year's income statement Sales $800,000 $920,200 cost of goods sold 587,100 634.500...
[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 Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense 7,900 13,000 Merchandise inventory 84,440 132,500 Income tax expense...
pter 17 Assignment i Summary Information from the financial statements of two companies competing in the same industry follows. + 1 of 2 Barco Kyan Barco Kyan Company Company Company Company Data from the current year-end balance sheets Data from the current year's income statement Assets Sales $790,000 $ 889 200 Cash $ 22,000 31000 Cost of goods sold 589,100 646,500 Accounts receivable, net 34,400 51,400 Interest expense 8,300 11,000 Current notes receivable (trade) 9,200 7.400 Income tax expense 15,185...
Required information [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 Company Company Data from the current year-end balance sheets Assets Cash $ 18,000 $ 35,000 Accounts receivable, net 40,400 54,400 Merchandise inventory 85,040 134,500 Prepaid expenses 5,500 7,750 Plant assets, net 320,000 312,400 Total assets $ 468,940 $544,050 Barco Kyan Company Company Data from the current year's income statement Sales $800,000 $882,200...
Summary Information from the financial statements of two companies competing in the same industry follows. Barco Kyan Barco Kyan Company Company Company Company Data from the current year-end balance sheets Data from the current year's income statement Assets Sales $770,000 $888,200 Cash $ 21.000 $ 34,000 cost of goods sold 586,100 644.500 Accounts receivable, net 35,400 56,400 Interest expense 8,100 12,000 Current notes receivable (trade) 9.900 8.000 Income tax expense 14,800 24,521 Merchandise Inventory 84,640 128,500 Net income 161,000 207,...
Required Informatilon The folowing nformation apawes to the questions dlapiayed below Summary Informstion from the financlal statements oftwo companles competing In the asme Industry follawa. Barco Kyan Barco yan Company Company Data tron the current year-end balanca Data xon the currant year"a incona atatomant 5800,000 두881,2 584,100 636,00 21,00033,000 Coat of gooda sold Account receivable, net 39,4DO 52 , 400 Interegt expen Current 9.200 17.000 15.37724.27 191,323 203.373 5.63 194 t notaa scaivabla 1.000 8 8.800 Incona tax xpenaa Marchandiaa...
Required information (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 Company Company Data from the current year-end balance sheets Assets Cash $ 22,000 $ 35,000 Accounts receivable, net 33,400 51,400 Merchandise inventory 84,640 134,500 Prepaid expenses 5,900 7,650 Plant assets, net 360,000 306, 400 Total assets $505,940 $534,950 Barco Kyan Company Company Data from the current year's income statement Sales $770,000 $912,200...