Question

In: Accounting

Summary information from the financial statements of two companies competing in the same industry follows. Barco...

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 $ 810,000 $ 923,200 Cash $ 20,000 $ 35,000 Cost of goods sold 589,100 636,500 Accounts receivable, net 35,400 51,400 Interest expense 9,300 11,000 Current notes receivable (trade) 9,000 8,400 Income tax expense 15,569 25,487 Merchandise inventory 84,940 140,500 Net income 196,031 250,213 Prepaid expenses 5,200 7,600 Basic earnings per share 5.16 5.54 Plant assets, net 280,000 313,400 Cash dividends per share 3.79 3.97 Total assets $ 434,540 $ 556,300 Beginning-of-year balance sheet data Liabilities and Equity Accounts receivable, net $ 30,800 $ 51,200 Current liabilities $ 61,340 $ 101,300 Current notes receivable (trade) 0 0 Long-term notes payable 86,800 103,000 Merchandise inventory 55,600 105,400 Common stock, $5 par value 190,000 226,000 Total assets 408,000 392,500 Retained earnings 96,400 126,000 Common stock, $5 par value 190,000 226,000 Total liabilities and equity $ 434,540 $ 556,300 Retained earnings 44,389 55,231 Required: 1a. 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.) 1b. Identify the company you consider to be better short-term credit risk.

Solutions

Expert Solution

1a.(a) current ratio - current assets/ current liabilities

(cash + account receivable+ current notes receivable+ merchandise inventory+prepaid expenses ) / current liabilities

(b) acid test ratio = (current assets - prepaid exp - inventory )/ current liabilities

(cash + account receivable+ current notes receivable ) / current liabilities

This ratio shows whether the company has sufficient receivables to cover the immediate liabilities.

(c) accounts receivable turnover = net credit sales / average accounts receivable

(NOTE: here we will assume that all the sales shown are credit sales )

This ratio shows the effectiveness of the credit that is extended to the customers.

average accounts receivable = (opening accounts receivable + closing accounts receivable )/ 2

(d) inventory turnover = cost of goods sold / [( opening inventory + closing inventory )/2]

This ratio tells us how many times the company has sold the average inventory

(e) days sales in inventory = (ending inventory/ cost of goods sold )*365

(NOTE: we have assumed the year contains 365 days )

this ratio tells the average number of days it took to sell average inventory.

(f) days sales uncollected = (accounts receivable/ net sales)*365

This ratio means how long will it take for the creditors to pay off their dues.

RATIO BARCO CO KYAN CO
current ratio (20000+35400+9000+84940+5200)/61340 (35000+51400+8400+140500+7600)/101300
=2.52 =2.40
acid test ratio (20000+35400+9000)/61340 (35000+51400+8400)/101300
1.05 0.94
accounts receivable turnover 810000/{(35400+30800)/2} 923000/{(51400+51200)/2}
24.47 17.99
inventory turnover 589100/{(84940+55600)/2}

636500/{(140500+105400)/2}

8.12 5.18
days sales in inventory (84940/589100)*365 (140500/636500)*365
52.62 80.57
days sales collected (35400/810000)*365 (51400/923000)*365
15.95 20.32

1b.The company at a lesser short term credit risk is Barco company as the company even though has a higher current ratio it is within good limits also has a higher quick ratio which means the company can quickly convert it's receivables into cash and meet it's financial obligations  and higher accounts receivable turnover which means that the extension of credit of the good and it makes timely collection of it's dues. therefore as barco company can convert it's receivables into cash and meet it's obligations it is at a lower risk.


Related Solutions

Summary information from the financial statements of two companies competing in the same industry follows. Barco...
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 $ 790,000 $ 927,200 Cash $ 18,500 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 36,400 59,400 Interest expense 8,200 16,000 Current notes receivable (trade) 10,000 7,800 Income tax expense 15,185 25,597 Merchandise inventory 84,340 140,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
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 $ 800,000 $ 926,200 Cash $ 18,500 $ 34,000 Cost of goods sold 594,100 642,500 Accounts receivable, net 39,400 53,400 Interest expense 8,400 15,000 Current notes receivable (trade) 9,700 7,400 Income tax expense 15,377 25,570 Merchandise inventory 84,540 134,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows. Barco...
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 $ 780,000 $ 919,200 Cash $ 21,000 $ 37,000 Cost of goods sold 588,100 642,500 Accounts receivable, net 39,400 54,400 Interest expense 8,100 19,000 Current notes receivable (trade) 9,200 7,200 Income tax expense 14,992 25,376 Merchandise inventory 84,340 132,500 Net income...
Summary information from the financial statements of two companies competing in the same industry follows.   ...
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...
Income statements for two different companies in the same industry are as follows: Trimax Inc Quintex...
Income statements for two different companies in the same industry are as follows: Trimax Inc Quintex Inc Sales $500,000 $500,000 Less: Variable costs 250,000 100,000 Contribution margin 250,000 400,000 Less: Fixed Costs 200,000 350,000 Operating income 50,000 50,000 Required: 1. Compute the degree of operating leverage for each company. 2. Compute the break-even point for each company. Explain why the break-even point for Quintex Inc. is higher. 3. Suppose that both companies experience a 50 percent increase in revenue. Compute...
Operating Leverage Income statements for two different companies in the same industry are as follows: Trimax,...
Operating Leverage Income statements for two different companies in the same industry are as follows: Trimax, Inc. Quintex, Inc. Sales $600,000     $675,000     Less: Variable costs 300,000     135,000        Contribution margin $300,000     $540,000     Less: Fixed costs 240,000     480,000        Operating income $60,000     $60,000     Required: 1. Compute the degree of operating leverage for each company. Trimax Quintex 2. Compute the break-even point in dollars for each company. Trimax, Inc. $ Quintex, Inc. $ Why is the break-even point for Quintex, Inc., higher? Because it...
Provide an example of any two leading companies from the same industry which are competing directly...
Provide an example of any two leading companies from the same industry which are competing directly for marketshare. Give a short profile (300-500 words) for each (provide references for your answers). If you are the manager of one of these companies, what pricing policy do you adopt to be in the first position? Why? (100-200 words) When the whole sector of the market is occupied by the little number of big corporations who share the leadership, what do we call...
Provide an example of any two leading companies from the same industry which are competing directly...
Provide an example of any two leading companies from the same industry which are competing directly for marketshare. Give a short profile (300-500 words) for each (provide references for your answers). If you are the manager of one of these companies, what pricing policy do you adopt to be in the first position? Why? (100-200 words) When the whole sector of the market is occupied by the little number of big corporations who share the leadership, what do we call...
1. Provide an example of any two leading companies from the same industry which are competing...
1. Provide an example of any two leading companies from the same industry which are competing directly for marketshare. Give a short profile (300-500 words) for each (provide references for your answers). 2. If you are the manager of one of these companies, what pricing policy do you adopt to be in the first position? Why? (100-200 words) 3. When the whole sector of the market is occupied by the little number of big corporations who share the leadership, what...
Provide an example of any two leading companies from the same industry which are competing directly...
Provide an example of any two leading companies from the same industry which are competing directly for marketshare. Give a short profile (300-500 words) for each (provide references for your answers). If you are the manager of one of these companies, what pricing policy do you adopt to be in the first position? Why? (100-200 words) When the whole sector of the market is occupied by the little number of big corporations who share the leadership, what do we call...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT