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 also need help with Part 2 of the Tabs section
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 also need help with Part 2 of the Tabs section
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
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 | |||||||
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 | |||||||||
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 also need help with Part 2 of the Tabs section
![Problem 17-5A Part 2
2a. 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 each company's stock can be purchased at $100 per share, compute their (e) price-earnings ratios
and (f dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
2b. Identify which company's stock you would recommend as the better investment.
Complete this question by entering your answers in the tabs below.
2A Prof Mar
2A Tot Asset
2A Ret on Tot
2A Ret On
2A Price Earn
2A Div Yield
Req 2B
Ratio
Turn
Assets
Com Stock
Ratio
For both companies compute the profit margin ratio.
(a)
Profit Margin Ratio
Company Choose Numerator:
I Choose Denominator:
Profit margin ratio
Profit margin ratio
Barco
0 %
%3D
|Кyan
0 %
< 2A Prof Mar Ratio
2A Tot Asset Turn >](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F34b06b3a-cf06-42fd-a4ac-3963b5656154%2Fb79a4f4f-63c5-41f5-b16a-14eed318bb99%2F2g1t99o_processed.png&w=3840&q=75)
Transcribed Image Text:Problem 17-5A Part 2
2a. 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 each company's stock can be purchased at $100 per share, compute their (e) price-earnings ratios
and (f dividend yields. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
2b. Identify which company's stock you would recommend as the better investment.
Complete this question by entering your answers in the tabs below.
2A Prof Mar
2A Tot Asset
2A Ret on Tot
2A Ret On
2A Price Earn
2A Div Yield
Req 2B
Ratio
Turn
Assets
Com Stock
Ratio
For both companies compute the profit margin ratio.
(a)
Profit Margin Ratio
Company Choose Numerator:
I Choose Denominator:
Profit margin ratio
Profit margin ratio
Barco
0 %
%3D
|Кyan
0 %
< 2A Prof Mar Ratio
2A Tot Asset Turn >
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education