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 years income statement |
Assets | | | | | | Sales | $ | 760,000 | $ | 901,200 |
Cash | $ | 20,500 | $ | 31,000 | | Cost of goods sold | | 592,100 | | 646,500 |
Accounts receivable, net | | 35,400 | | 56,400 | | Interest expense | | 8,300 | | 11,000 |
Current notes receivable (trade) | | 9,500 | | 7,400 | | Income tax expense | | 14,608 | | 24,879 |
Merchandise inventory | | 84,240 | | 128,500 | | Net income | | 144,992 | | 218,821 |
Prepaid expenses | | 5,200 | | 7,400 | | Basic earnings per share | | 3.30 | | 4.84 |
Plant assets, net | | 300,000 | | 313,400 | | Cash dividends per share | | 3.72 | | 3.93 |
| | | | | | | | | | |
Total assets | $ | 454,840 | $ | 544,100 | | | | | | |
| | | | | | | | | | |
| | | | | | Beginning-of-year balance sheet data |
Liabilities and Equity | | | | | | Accounts receivable, net | $ | 27,800 | $ | 52,200 |
Current liabilities | $ | 61,340 | $ | 104,300 | | Current notes receivable (trade) | | 0 | | 0 |
Long-term notes payable | | 83,800 | | 103,000 | | Merchandise inventory | | 63,600 | | 109,400 |
Common stock, $5 par value | | 220,000 | | 226,000 | | Total assets | | 378,000 | | 382,500 |
Retained earnings | | 89,700 | | 110,800 | | Common stock, $5 par value | | 220,000 | | 226,000 |
| | | | | | | | | | |
Total liabilities and equity | $ | 454,840 | $ | 544,100 | | Retained earnings | | 108,388 | | 69,615 |
| | | | | | | | | | |
|
Required: 1.1 For both companies compute the (a) current ratio, (b) acid-test ratio, (c) accounts (including notes) receivable turnover, (d) inventory turnover, (e) days sales in inventory, and (f) days sales uncollected. (Do not round intermediate calculations.)
|
| (a) | Current Ratio | Company | Choose Numerator: | / | Choose Denominator: | = | Current Ratio | | | / | | = | Current ratio | Barco | | / | | = | | to 1 | Kyan | | / | | = | | to 1 | |
|
| (b) | Acid-Test Ratio | Company | Choose Numerator: | | Choose Denominator: | = | Acid-Test Ratio | | | + | | + | | / | | = | Acid-test ratio | Barco | | + | | + | | / | | = | | to 1 | Kyan | | + | | + | | / | | | | to 1 | |
|
| (c) | Accounts Receivable Turnover | Company | Choose Numerator: | / | Choose Denominator: | = | Accounts Receivable Turnover | | | / | | = | Accounts receivable turnover | Barco | | / | | = | | times | Kyan | | / | | = | | times | |
|
| (d) | Inventory Turnover | Company | Choose Numerator: | / | Choose Denominator: | = | Inventory Turnover | | | / | | = | Inventory turnover | Barco | | / | | = | | times | Kyan | | / | | = | | times | |
|
| (e) | Days Sales in Inventory | Company | Choose Numerator: | / | Choose Denominator: | x | Days | = | Days Sales in Inventory | | | / | | x | | = | Days sales in inventory | Barco | | / | | x | | = | | days | Kyan | | / | | x | | = | | days | |
|
| (f) | Days' Sales Uncollected | Company | Choose Numerator: | / | Choose Denominator: | x | Days | = | Days' Sales Uncollected | | | / | | x | | = | Days' sales uncollected | Barco | | / | | x | | = | | days | Kyan | | / | | x | | = | | days | |
1.2 | Identify the company you consider to be better in managing short-term credit risk. |
| |
| | Barco company | | Kyan company | 2.1 | For both companies compute the (a) profit margin ratio, (b) total asset turnover, (c) return on total assets, and (d) return on common stockholders equity. Assuming that share and each companys stock can be purchased at $95 per share, compute their (e) price-earnings ratios and (f) dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.) | | (a) | Profit Margin Ratio | Company | Choose Numerator: | / | Choose Denominator: | = | Profit margin ratio | | | | / | | = | Profit margin ratio | | Barco | | / | | = | | % | Kyan | | / | | = | | % | | | |
|
| (b) | Total Asset Turnover | Company | Choose Numerator: | / | Choose Denominator: | = | Total Asset Turnover | | | / | | = | Total asset turnover | Barco | | / | | = | | times | Kyan | | / | | = | | times | |
|
| (c) | Return on Total Assets | Company | Choose Numerator: | / | Choose Denominator: | = | Return on Total Assets | | | | / | | = | Return on total assets | | Barco | | / | | = | | % | Kyan | | / | | = | | % | |
|
| (d) | Return On Common Stockholders' Equity | Company | Choose Numerator: | / | Choose Denominator | = | Return On Common Stockholders' Equity | | | | - | | / | | = | Return On common stockholders' equity | | Barco | | - | | / | | = | | % | Kyan | | - | | / | | = | | % | |
|
| (e) | Price-Earnings Ratio | Company | Choose Numerator: | / | Choose Denominator: | = | Price-Earnings Ratio | | | / | | = | Price-earnings ratio | | Barco | | / | | = | | times | Kyan | | / | | = | | times | |
|
| (f) | Dividend Yield | Company | Choose Numerator: | / | Choose Denominator: | = | Dividend Yield | | | | / | | = | Dividend yield | | Barco | | / | | = | | % | Kyan | | / | | = | | % | |
2.2 | Identify which companys stock you would recommend as the better investment. |
| |
| | Barco company | | Kyan company | |