Answered step by step
Verified Expert Solution
Question
1 Approved Answer
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Cash
RATIO ANALYSIS
Data for Barry Computer Co. and its industry averages follow.
Barry Computer Company: | ||||
Balance Sheet as of December 31, 2016 (In Thousands) | ||||
Cash | $86,710 | Accounts payable | $113,390 | |
Receivables | 193,430 | Other current liabilities | 106,720 | |
Inventories | 146,740 | Notes payable to bank | 53,360 | |
Total current assets | $426,880 | Total current liabilities | $273,470 | |
Long-term debt | $160,080 | |||
Net fixed assets | 240,120 | Common equity | 233,450 | |
Total assets | $667,000 | Total liabilities and equity | $667,000 |
Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In Thousands) | |||
Sales | $1,150,000 | ||
Cost of goods sold | |||
Materials | $563,500 | ||
Labor | 276,000 | ||
Heat, light, and power | 46,000 | ||
Indirect labor | 57,500 | ||
Depreciation | 46,000 | 989,000 |
Gross profit | $ 161,000 | |
Selling expenses | 92,000 | |
General and administrative expenses | 34,500 | |
Earnings before interest and taxes (EBIT) | $ 34,500 | |
Interest expense | 12,806 | |
Earnings before taxes (EBT) | $ 21,694 | |
Federal and state income taxes (40%) | 8,678 | |
Net income | $ 13,016 |
Calculate the indicated ratios for Barry. Round your answers to two decimal places.
Ratio | Barry | Industry Average |
Current | x | 1.61x |
Quick | x | 0.97x |
Days sales outstandinga | days | 29.23 days |
Inventory turnover | x | 8.40x |
Total assets turnover | x | 1.91x |
Profit margin | % | 1.08% |
ROA | % | 2.05% |
ROE | % | 5.93% |
ROIC | % | 8.00% |
TIE | x | 2.64x |
Debt/Total capital | % | 46.66% |
aCalculation is based on a 365-day year. Construct the DuPont equation for both Barry and the industry. Round your answers to two decimal places.
FIRM | INDUSTRY | |
Profit margin | % | 1.08% |
Total assets turnover | x | 1.91x |
Equity multiplier | x | x
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started