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 $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 $1,400,000
Cost of goods sold
   Materials $658,000
   Labor 322,000
   Heat, light, and power 56,000
   Indirect labor 98,000
   Depreciation 70,000 1,204,000
Gross profit $   196,000
Selling expenses 126,000
General and administrative expenses 14,000
   Earnings before interest and taxes (EBIT) $     56,000
Interest expense 30,391
   Earnings before taxes (EBT) $     25,609
Federal and state income taxes (40%) 10,244
Net income $     15,365
  1. Calculate the indicated ratios for Barry. Round your answers to two decimal places.
    Ratio Barry              Industry Average
    Current x 2.32x
    Quick x 1.64x
    Days sales outstandinga days 44.25 days
    Inventory turnover x 7.32x
    Total assets turnover x 1.74x
    Profit margin % 1.05%
    ROA % 1.82%
    ROE % 4.23%
    ROIC % 7.10%
    TIE x 1.94x
    Debt/Total capital % 43.57%

    aCalculation is based on a 365-day year.
  2. Construct the DuPont equation for both Barry and the industry. Round your answers to two decimal places.
    FIRM INDUSTRY
    Profit margin % 1.05%
    Total assets turnover x 1.74x
    Equity multiplier x x
  3. Select the correct option based on Barry's strengths and weaknesses as revealed by your analysis.
    -Select-IIIIIIIVVItem 16
    1. The firm's days sales outstanding is comparable to the industry average, indicating that the firm should neither tighten credit nor enforce a more stringent collection policy. The total assets turnover ratio is well below the industry average so sales should be increased, assets increased, or both. While the company's profit margin is higher than the industry average, its other profitability ratios are low compared to the industry - net income should be higher given the amount of equity, assets, and invested capital. However, the company seems to be in a below average liquidity position and financial leverage is similar to others in the industry.
    2. The firm's days sales outstanding ratio is more than twice as long as the industry average, indicating that the firm should tighten credit or enforce a more stringent collection policy. The total assets turnover ratio is well below the industry average so sales should be increased, assets decreased, or both. While the company's profit margin is higher than the industry average, its other profitability ratios are low compared to the industry - net income should be higher given the amount of equity, assets, and invested capital. However, the company seems to be in an average liquidity position and financial leverage is similar to others in the industry.
    3. The firm's days sales outstanding is more than twice as long as the industry average, indicating that the firm should loosen credit or apply a less stringent collection policy. The total assets turnover ratio is well below the industry average so sales should be increased, assets increased, or both. While the company's profit margin is higher than the industry average, its other profitability ratios are low compared to the industry - net income should be higher given the amount of equity, assets, and invested capital. However, the company seems to be in an average liquidity position and financial leverage is similar to others in the industry.
    4. The firm's days sales outstanding is less than the industry average, indicating that the firm should tighten credit or enforce a more stringent collection policy. The total assets turnover ratio is well below the industry average so sales should be increased, assets decreased, or both. While the company's profit margin is lower than the industry average, its other profitability ratios are high compared to the industry - net income should be higher given the amount of equity, assets, and invested capital. However, the company seems to be in an average liquidity position and financial leverage is similar to others in the industry.
    5. The firm's days sales outstanding is more than the industry average, indicating that the firm should tighten credit or enforce a more stringent collection policy. The total assets turnover ratio is well above the industry average so sales should be increased, assets increased, or both. While the company's profit margin is higher than the industry average, its other profitability ratios are low compared to the industry - net income should be higher given the amount of equity, assets, and invested capital. However, the company seems to be in an above average liquidity position and financial leverage is similar to others in the industry.
  4. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2016. 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.)
    -Select-IIIIIIIVVItem 17
    1. If 2016 represents a period of supernormal growth for the firm, ratios based on this year will be accurate and a comparison between them and industry averages will have substantial meaning. Potential investors need only look at 2016 ratios to be well informed, and a return to normal conditions in 2017 could help the firm's stock price.
    2. If 2016 represents a period of normal growth for the firm, ratios based on this year will be distorted and a comparison between them and industry averages will have little meaning. Potential investors who look only at 2016 ratios will be misled, and a continuation of normal conditions in 2017 could hurt the firm's stock price.
    3. If 2016 represents a period of normal growth for the firm, ratios based on this year will be accurate and a comparison between them and industry averages will have substantial meaning. Potential investors who look only at 2016 ratios will be misled, and a return to supernormal conditions in 2017 could hurt the firm's stock price.
    4. If 2016 represents a period of supernormal growth for the firm, ratios based on this year will be distorted and a comparison between them and industry averages will have substantial meaning. Potential investors who look only at 2016 ratios will be well informed, and a return to normal conditions in 2017 could hurt the firm's stock price.
    5. If 2016 represents a period of supernormal growth for the firm, ratios based on this year will be distorted and a comparison between them and industry averages will have little meaning. Potential investors who look only at 2016 ratios will be misled, and a return to normal conditions in 2017 could hurt the firm's stock price.

Solutions

Expert Solution

Barry Industry
Current Ratio = Current Assets = 858000 = 1.73 1.69
Current Liabilites 495000
Current Assets = Cash + Receivable + Inventories
= 82500 + 412500 + 3,63,000.00
= 8,58,000.00
Current Liabilities = Accounts Payable + Other Current Liabilities + Notes payable to bank
= 2,31,000.00 + 181500 + 82500
= 4,95,000.00
Quick Ratio = Quick Assets = 495000 = 1 0.94
Current Liabilities 495000
Quick Assets = Cash + Receivable
82500 + 412500
= 495000
Current Liabilities = Accounts Payable + Other Current Liabilities + Notes payable to bank
= 0.00 + 0 + 2460000
= 24,60,000.00
Days Sales Outstanding = Receivable = 412500 X 365= 50.19 23.45
Sales 3000000
Inventory Turnover = Turnover = 3000000 = 8.26 9.02
Inventory 363000
Total Asset Turnover = Turnover = 3000000 = 1.82 2.05
Asset 1650000
Profit Margin = Profit = 48834 X 100 = 1.6278 1.52%
Sales 3000000
Return on Assets = Profit = 48834 X 100 = 2.96 3.12%
Assets 1650000
Return on Equity = Profit = 48834 X 100 = 6.73 7.47%
Common Equity 726000
Return on Invested Capital = Net operating profit after tax = 72000 X 100 = 6.23 7.10%
Invested Capital 1155000
Net operating profit after tax = EBIT X(1-Tax rate)
Invested capital = Long Term Debt + Common Equity
Times interest earned = Earning Before interest and taxes = 120000 3.11 3.14
Interest expenses 38610
Debt To Total Capital Debt = 429000 X 100 = 59% 42.23%
Capital 726000
Dupont Analysis Barry Industry
Profit Margin 1.63% 1,52%
Total Asset Turnover 1.82 2.05
Equity Multiplier Total Asset = 1650000 2.27
Total equity 726000
Or Return on Equity 6.73 2.27 7.47% 2.39
Return on Assets 2.96 3.12%
Answer C Option II
Answer D Option III

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 $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...
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