Ratio analysis Data for Barry Computer Co. and its industry averages follow. a.
ID: 2738807 • Letter: R
Question
Ratio analysis Data for Barry Computer Co. and its industry averages follow.
a. Calculate the indicated ratios for Barry.
b. Construct the extended Du Pont 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 2005. 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, 2005 (In Thousands)
Cash $ 77,500 Accounts payable $129,000
Receivables 336,000 Notes payable 84,000
Inventories 241,500 Other current liabilities 117,000
Total current assets $655,000 Total current liabilities $330,000
Long-term debt 256,500
Net fixed assets 292,500 Common equity 361,000
Total assets $947,500 Total liabilities and equity $947,500
Barry Computer Company: Income Statement for Year Ended December 31, 2005 (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 percent) 18,200
Net income $ 27,300
Ratio Barry Industry Average
Current _____ 2.0
Quick _____ 1.3
Days sales outstanding* _____ 35 days
Inventory turnover _____ 6.7
Total assets turnover _____ 3.0
Net profit margin _____ 1.2%
ROA _____ 3.6%
ROE _____ 9.0%
Total debt/total assets _____ 60.0%
*Calculation is based on a 365-day year.
Explanation / Answer
Current Ratio=Current Assets/Current Liabilities=$655,000/$330,000=1.985
Quick Ratio=(Current Assets-Inventory)/Current Liabilities=($655,000-$241,500)$330,000=$413,500/$330,000=1.25
Days sales outstanding=Receivables*365/Sales=$336,000*365/$1,607,500=76.29 days=76 days
Inventory Turnover=Turnover/Inventory=$1,607,500/$$241,500=6.66
Total assets turnover =Sales/Total Asssets=$1,607,500/$947,500=1.7
Net Profit Margin=Net Profit/Sales=$27,300/$1,607,500=0.01698=1.7%
ROA=Net Income/Total Assets=$27,300/$947,500=0.0288=2.899%=2.9%
ROE=Net Income/Equity=$27,300/$361,000=0.0756=7.56%
Total Debt/Total Assets=($330,000+$256,500)/$947,500=$586,500/$947,500=0.6189=61.9%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.