Question

In: Finance

Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as...

Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Cash $69,615 Accounts payable $119,340 Receivables 348,075 Other current liabilities 79,560 Inventories 198,900 Notes payable to bank 89,505 Total current assets $616,590 Total current liabilities $288,405 Long-term debt $198,900 Net fixed assets 377,910 Common equity 507,195 Total assets $994,500 Total liabilities and equity $994,500 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In Thousands) Sales $1,950,000 Cost of goods sold Materials $916,500 Labor 448,500 Heat, light, and power 97,500 Indirect labor 117,000 Depreciation 97,500 1,677,000 Gross profit $ 273,000 Selling expenses 195,000 General and administrative expenses 19,500 Earnings before interest and taxes (EBIT) $ 58,500 Interest expense 21,879 Earnings before taxes (EBT) $ 36,621 Federal and state income taxes (40%) 14,648 Net income $ 21,973 Calculate the indicated ratios for Barry. Round your answers to two decimal places.

Ratio   Barry, Industry Average

Current x 2.15x

Quick x 1.48x

Days sales outstandinga days 30.45 days

Inventory turnover x 10.28x

Total assets turnover x 2.33x

Profit margin 1.13 % 1.05%

ROA % 2.45%

ROE % 4.81%

ROIC % 7.30%

TIE x 2.60x

Debt/Total capital % 35.15%

the calculation 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

Total assets turnover

Equity multiplier

Solutions

Expert Solution


Related Solutions

Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as...
Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Cash $112,560 Accounts payable $103,180 Receivables 356,440 Other current liabilities 103,180 Inventories 196,980 Notes payable to bank 75,040    Total current assets $665,980    Total current liabilities $281,400 Long-term debt $253,260 Net fixed assets 272,020 Common equity 403,340 Total assets $938,000 Total liabilities and equity $938,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In Thousands) Sales...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $61,950 Accounts payable $80,535 Receivables 210,630 Other current liabilities 92,925 Inventories 130,095 Notes payable to bank 68,145    Total current assets $402,675    Total current liabilities $241,605 Long-term debt $130,095 Net fixed assets 216,825 Common equity 247,800 Total assets $619,500 Total liabilities and equity $619,500 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $228,480 Accounts payable $261,120 Receivables 587,520 Other current liabilities 146,880 Inventories 391,680 Notes payable to bank 163,200    Total current assets $1,207,680    Total current liabilities $571,200 Long-term debt $326,400 Net fixed assets 424,320 Common equity 734,400 Total assets $1,632,000 Total liabilities and equity $1,632,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $66,250 Accounts payable $159,000 Receivables 503,500 Other current liabilities 132,500 Inventories 265,000 Notes payable to bank 106,000    Total current assets $834,750    Total current liabilities $397,500 Long-term debt $291,500 Net fixed assets 490,250 Common equity 636,000 Total assets $1,325,000 Total liabilities and equity $1,325,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $126,000 Accounts payable $90,000 Receivables 270,000 Other current liabilities 72,000 Inventories 270,000 Notes payable to bank 108,000    Total current assets $666,000    Total current liabilities $270,000 Long-term debt $270,000 Net fixed assets 234,000 Common equity 360,000 Total assets $900,000 Total liabilities and equity $900,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
Ratio Analysis Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $90,450 Accounts payable $160,800 Receivables 402,000 Other current liabilities 80,400 Inventories 221,100 Notes payable 110,550    Total current assets $713,550    Total current liabilities $351,750 Long-term debt $251,250 Net fixed assets 291,450 Common equity 402,000 Total assets $1,005,000 Total liabilities and equity $1,005,000 Barry Computer Company: Income Statement for Year Ended December 31, 2014 (In Thousands) Sales...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $63,480 Accounts payable $103,155 Receivables 238,050 Other current liabilities 71,415 Inventories 198,375 Notes payable to bank 39,675    Total current assets $499,905    Total current liabilities $214,245 Long-term debt $166,635 Net fixed assets 293,595 Common equity 412,620 Total assets $793,500 Total liabilities and equity $793,500 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $58,320 Accounts payable $116,640 Receivables 196,830 Other current liabilities 65,610 Inventories 211,410 Notes payable to bank 43,740    Total current assets $466,560    Total current liabilities $225,990 Long-term debt $153,090 Net fixed assets 262,440 Common equity 349,920 Total assets $729,000 Total liabilities and equity $729,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance...
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 $143,100 Accounts payable $171,720 Receivables 372,060 Other current liabilities 128,790 Inventories 386,370 Notes payable to bank 85,860    Total current assets $901,530    Total current liabilities $386,370 Long-term debt $372,060 Net fixed assets 529,470 Common equity 672,570 Total assets $1,431,000 Total liabilities and equity $1,431,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at...
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 dollars are in thousands, number of shares are shown in thousands too. Barry Computer Company: Balance Sheet as of December 31, 2018 (In Thousands) Cash $44,175 Accounts payable $88,350 Receivables 265,050 Other current liabilities 141,360 Inventories 212,040 Notes payable to bank 70,680    Total current assets $521,265    Total current liabilities $300,390 Long-term...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT