4-23 RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since dol- lars are in thousands, number of shares are shown in thousands too. a. Calculate the indicated ratios for Barry. b. Construct the DuPont equation for both Barry and the industry. c. Outline Barry's strengths and weaknesses as revealed by your analysis. d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2018. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.) Barry Computer Company: Balance Sheet as of December 31, 2018 (in Thousands) Cash $ 77,500 Accounts payable $129,000 Receivables 336,000 Other current liabilities 117,000 Inventories 241,500 Notes payable to bank 84,000 Total current assets $ 655,000 Total current liabilities $330,000 Long-term debt 256,500 Net fixed assets 292,500 Common equity (36,100 shares) 361,000 Total assets $ 947,500 Total liabilities and equity $947,500 Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203 Cengage Learning All Rights Reserved. May not he copied, scanned, or duplicated, in whole or in purt. Due to clectronie rights, some thind parny content may he suppressed from the ellook andlor eChaptent) deemed that any suppeessed content does not materially aflect the overall learning experience. Cengage Leaning reserves the right to remove additinal content at any time if sabsequent rights restrictions require it. Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in Thousands) Sales $1,607,500 Cost of goods sold Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) $ 70,000 Interest expense 24,500 Earnings before taxes (EBT) 45,500 Federal and state income taxes (40%) 18,200 Net income 27,300 Earnings per share 0.75623 Price per share on December 31, 2018 $ 12.00 Ratio Barry Industry Average Current 2.0x Quick 1.3X Days sales outstanding 35 days Inventory turnover 6.7X Total assets turnover 3.0x Profit margin 1.2% ROA 3.6% ROE 9.0% ROIC 7.5% TIE 3.0x Debt/Total capital 47.0% M/B 4.22 P/E 17.86 EV/EBITDA 9.14 "Calculation is based on a 365-day year.

Fundamentals of Financial Management, Concise Edition (MindTap Course List)
9th Edition
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter4: Analysis Of Financial Statements
Section: Chapter Questions
Problem 23P: RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. a. Calculate the...
icon
Related questions
Question
100%

Data for Barry Computer Co. and its industry averages follow. The

firm’s debt is priced at par, so the market value of its debt equals its book value. Since dol-
lars are in thousands, number of shares are shown in thousands too.

a. Calculate the indicated ratios for Barry.
b. Construct the DuPont equation for both Barry and the industry.
c. Outline Barry’s strengths and weaknesses as revealed by your analysis.
d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and
common equity during 2018. How would that information affect the validity of your
ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if
averages are not used. No calculations are needed.)

4-23
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The
firm's debt is priced at par, so the market value of its debt equals its book value. Since dol-
lars are in thousands, number of shares are shown in thousands too.
a. Calculate the indicated ratios for Barry.
b. Construct the DuPont equation for both Barry and the industry.
c. Outline Barry's strengths and weaknesses as revealed by your analysis.
d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and
common equity during 2018. How would that information affect the validity of your
ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if
averages are not used. No calculations are needed.)
Barry Computer Company:
Balance Sheet as of December 31, 2018 (in Thousands)
Cash
$ 77,500
Accounts payable
$129,000
Receivables
336,000
Other current liabilities
117,000
Inventories
241,500
Notes payable to bank
84,000
Total current assets
$ 655,000
Total current liabilities
$330,000
Long-term debt
256,500
Net fixed assets
292,500
Common equity (36,100 shares)
361,000
Total assets
$ 947,500
Total liabilities and equity
$947,500
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
Cengage Learning All Rights Reserved. May not he copied, scanned, or duplicated, in whole or in purt. Due to clectronie rights, some thind parny content may he suppressed from the ellook andlor eChaptent)
deemed that any suppeessed content does not materially aflect the overall learning experience. Cengage Leaning reserves the right to remove additinal content at any time if sabsequent rights restrictions require it.
Chapter 4 Analysis of Financial Statements
141
Barry Computer Company: Income Statement for Year Ended
December 31, 2018 (in Thousands)
Sales
$1,607,500
Cost of goods sold
Materials
$717,000
Labor
453,000
Heat, light, and power
68,000
Indirect labor
113,000
Depreciation
41,500
1,392,500
Gross profit
215,000
Selling expenses
115,000
General and administrative expenses
30,000
Earnings before interest and taxes (EBIT)
$
70,000
Interest expense
24,500
Earnings before taxes (EBT)
45,500
Federal and state income taxes (40%)
18,200
Net income
27,300
Earnings per share
0.75623
Price per share on December 31, 2018
$ 12.00
Ratio
Barry
Industry Average
Current
2.0x
Quick
1.3X
Days sales outstanding
35 days
Inventory turnover
6.7X
Total assets turnover
3.0x
Profit margin
1.2%
ROA
3.6%
ROE
9.0%
ROIC
7.5%
TIE
3.0x
Debt/Total capital
47.0%
M/B
4.22
P/E
17.86
EV/EBITDA
9.14
"Calculation is based on a 365-day year.
Transcribed Image Text:4-23 RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at par, so the market value of its debt equals its book value. Since dol- lars are in thousands, number of shares are shown in thousands too. a. Calculate the indicated ratios for Barry. b. Construct the DuPont equation for both Barry and the industry. c. Outline Barry's strengths and weaknesses as revealed by your analysis. d. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2018. How would that information affect the validity of your ratio analysis? (Hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.) Barry Computer Company: Balance Sheet as of December 31, 2018 (in Thousands) Cash $ 77,500 Accounts payable $129,000 Receivables 336,000 Other current liabilities 117,000 Inventories 241,500 Notes payable to bank 84,000 Total current assets $ 655,000 Total current liabilities $330,000 Long-term debt 256,500 Net fixed assets 292,500 Common equity (36,100 shares) 361,000 Total assets $ 947,500 Total liabilities and equity $947,500 Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203 Cengage Learning All Rights Reserved. May not he copied, scanned, or duplicated, in whole or in purt. Due to clectronie rights, some thind parny content may he suppressed from the ellook andlor eChaptent) deemed that any suppeessed content does not materially aflect the overall learning experience. Cengage Leaning reserves the right to remove additinal content at any time if sabsequent rights restrictions require it. Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in Thousands) Sales $1,607,500 Cost of goods sold Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) $ 70,000 Interest expense 24,500 Earnings before taxes (EBT) 45,500 Federal and state income taxes (40%) 18,200 Net income 27,300 Earnings per share 0.75623 Price per share on December 31, 2018 $ 12.00 Ratio Barry Industry Average Current 2.0x Quick 1.3X Days sales outstanding 35 days Inventory turnover 6.7X Total assets turnover 3.0x Profit margin 1.2% ROA 3.6% ROE 9.0% ROIC 7.5% TIE 3.0x Debt/Total capital 47.0% M/B 4.22 P/E 17.86 EV/EBITDA 9.14 "Calculation is based on a 365-day year.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ratio Analysis
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781285867977
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781285065137
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning