Problem 17-5A Comparative ratio analysis LO P3 Skip to question   [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   $ 882,200   Cash $ 19,000   $ 37,000     Cost of goods sold   593,100     638,500   Accounts receivable, net   36,400     58,400     Interest expense   7,800     18,000   Merchandise inventory   84,440     130,500     Income tax expense   14,800     24,355   Prepaid expenses   5,500     7,150     Net income   154,300     201,345   Plant assets, net   370,000     312,400     Basic earnings per share   4.06     4.09   Total assets $ 515,340   $ 545,450     Cash dividends per share   3.78     3.94                     Liabilities and Equity               Beginning-of-year balance sheet data   Current liabilities $ 67,340   $ 95,300     Accounts receivable, net $ 26,800   $ 56,200   Long-term notes payable   79,800     103,000     Merchandise inventory   61,600     111,400   Common stock, $5 par value   190,000     246,000     Total assets   438,000     392,500   Retained earnings   178,200     101,150     Common stock, $5 par value   190,000     246,000   Total liabilities and equity $ 515,340   $ 545,450     Retained earnings   167,540     93,653       I need help filling out the tabs thnak you once again

Accounting (Text Only)
26th Edition
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter17: Financial Statement Analysis
Section: Chapter Questions
Problem 17.1EX
icon
Related questions
icon
Concept explainers
Topic Video
Question

Problem 17-5A Comparative ratio analysis LO P3

Skip to question

 

[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   $ 882,200  
Cash $ 19,000   $ 37,000     Cost of goods sold   593,100     638,500  
Accounts receivable, net   36,400     58,400     Interest expense   7,800     18,000  
Merchandise inventory   84,440     130,500     Income tax expense   14,800     24,355  
Prepaid expenses   5,500     7,150     Net income   154,300     201,345  
Plant assets, net   370,000     312,400     Basic earnings per share   4.06     4.09  
Total assets $ 515,340   $ 545,450     Cash dividends per share   3.78     3.94  
                 
Liabilities and Equity               Beginning-of-year balance sheet data  
Current liabilities $ 67,340   $ 95,300     Accounts receivable, net $ 26,800   $ 56,200  
Long-term notes payable   79,800     103,000     Merchandise inventory   61,600     111,400  
Common stock, $5 par value   190,000     246,000     Total assets   438,000     392,500  
Retained earnings   178,200     101,150     Common stock, $5 par value   190,000     246,000  
Total liabilities and equity $ 515,340   $ 545,450     Retained earnings   167,540     93,653  
 

 

I need help filling out the tabs thnak you once again.

Problem 17-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
Кyan
Company
Barco
Кyan
Company
Company
Compar
Data from the current year-end balance sheets
Data from the current year's income statement
Sales
$770,000 $882, 20
593,100
7,800
14,800
154, 300
Assets
$ 19,000 $ 37,000
58,400
130,500
7,150
312,400
638,50
Cost of goods sold
Interest expense
Cash
Accounts receivable, net
Merchandise inventory
Prepaid expenses
36,400
84,440
5,500
370,000
18,0=
Income tax expense
24,35
Net income
201,34
Plant assets, net
Basic earnings per share
4.06
4.
Total assets
$515,340 $545,450
Cash dividends per share
3.78
3.5
Liabilities and Equity
$ 67,340 $ 95,300
103,000
246,000
101,150
Beginning-of-year balance sheet data
Accounts receivable, net
Merchandise inventory
Total assets
$ 26,800 $ 56,20
111,40
61,600
392,50
438,000
Current liabilities
Long-term notes payable
Common stock, $5 par value
Retained earnings
79,800
190,000
178, 200
Common stock, $5 par value
190, 000
246,00
Total liabilities and equity
$515,340 $545,450
Retained earnings
167,540
93,6
oblem 17-5A Part 1
Transcribed Image Text:Problem 17-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 Кyan Company Barco Кyan Company Company Compar Data from the current year-end balance sheets Data from the current year's income statement Sales $770,000 $882, 20 593,100 7,800 14,800 154, 300 Assets $ 19,000 $ 37,000 58,400 130,500 7,150 312,400 638,50 Cost of goods sold Interest expense Cash Accounts receivable, net Merchandise inventory Prepaid expenses 36,400 84,440 5,500 370,000 18,0= Income tax expense 24,35 Net income 201,34 Plant assets, net Basic earnings per share 4.06 4. Total assets $515,340 $545,450 Cash dividends per share 3.78 3.5 Liabilities and Equity $ 67,340 $ 95,300 103,000 246,000 101,150 Beginning-of-year balance sheet data Accounts receivable, net Merchandise inventory Total assets $ 26,800 $ 56,20 111,40 61,600 392,50 438,000 Current liabilities Long-term notes payable Common stock, $5 par value Retained earnings 79,800 190,000 178, 200 Common stock, $5 par value 190, 000 246,00 Total liabilities and equity $515,340 $545,450 Retained earnings 167,540 93,6 oblem 17-5A Part 1
Problem 17-5A Part 1
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.
Complete this question by entering your answers in the tabs below.
1A Acid Test
Ratio
1A Acct Rec
1A Days Sal
Uncol
1A Current
1Α Invent
1A Days Sal in
1B short term
Ratio
Turn
Turnover
Inv
For both companies compute the accounts (including notes) receivable turnover.
(c)
Accounts Receivable Turnover
Company Choose Numerator:
I Choose Denominator:
Accounts Receivable Turnover
Accounts receivable turnover
Barco
0 times
Кyan
0 times
< 1A Acid Test Ratio
1A Invent Turnover >
Transcribed Image Text:Problem 17-5A Part 1 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. Complete this question by entering your answers in the tabs below. 1A Acid Test Ratio 1A Acct Rec 1A Days Sal Uncol 1A Current 1Α Invent 1A Days Sal in 1B short term Ratio Turn Turnover Inv For both companies compute the accounts (including notes) receivable turnover. (c) Accounts Receivable Turnover Company Choose Numerator: I Choose Denominator: Accounts Receivable Turnover Accounts receivable turnover Barco 0 times Кyan 0 times < 1A Acid Test Ratio 1A Invent Turnover >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781337398169
Author:
Carl Warren, Jeff Jones
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning