Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 4-23 Ratio Analysis Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2014 (In

Problem 4-23 Ratio Analysis

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

Barry Computer Company:
Balance Sheet as of December 31, 2014 (In Thousands)
Cash $111,825 Accounts payable $119,280
Receivables 283,290 Other current liabilities 82,005
Inventories 186,375 Notes payable 52,185
Total current assets $581,490 Total current liabilities $253,470
Long-term debt $164,010
Net fixed assets 164,010 Common equity 328,020
Total assets $745,500 Total liabilities and equity $745,500

Barry Computer Company: Income Statement for Year Ended December 31, 2014 (In Thousands)
Sales $1,050,000
Cost of goods sold
Materials $430,500
Labor 262,500
Heat, light, and power 73,500
Indirect labor 63,000
Depreciation 52,500 $882,000
Gross profit $168,000
Selling expenses 94,500
General and administrative expenses 31,500
Earnings before interest and taxes (EBIT) $42,000
Interest expense 18,041
Earnings before taxes (EBT) 23,959
Federal and state income taxes (40%) 9,584
Net income $14,375

Calculate the indicated ratios for Barry. Round your answers to two decimal places.

Ratio Barry Industry Average
Current ____ 2.27x
Quick ____ 1.57x
Days sales outstandinga ____days 46.89days
Inventory turnover ____ 6.04x
Total assets turnover ____ 1.64x
Profit margin ____% 1.30%
ROA ____% 2.14%
ROE ____% 4.66%
ROIC ____% 7.70%
TIE ____ 2.50x
Debt/Total capital ____% 46.00%

aCalculation is based on a 365-day year. Construct the Du Pont equation for both Barry and the industry. Round your answers to two decimal places.

FIRM INDUSTRY
Profit margin ___% 1.30%
Total assets turnover ____ 1.64x
Equity multiplier ____ ____

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing The Audit Function A Corporate Audit Department Procedures Guide

Authors: Michael P. Cangemi

2nd Edition

0471012556, 978-0471012559

More Books

Students also viewed these Finance questions

Question

suggest a range of work sample exercises and design them

Answered: 1 week ago