Question

In: Finance

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 Thousands)
Sales $2,650,000
Cost of goods sold
   Materials $1,192,500
   Labor 742,000
   Heat, light, and power 159,000
   Indirect labor 132,500
   Depreciation 132,500 2,358,500
Gross profit $   291,500
Selling expenses 159,000
General and administrative expenses 53,000
   Earnings before interest and taxes (EBIT) $     79,500
Interest expense 20,405
   Earnings before taxes (EBT) $     59,095
Federal and state income taxes (40%) 23,638
Net income $     35,457
  1. Calculate the indicated ratios for Barry. Round your answers to two decimal places.
    Ratio Barry              Industry Average
    Current x 2.07x
    Quick x 1.37x
    Days sales outstandinga days 32.41 days
    Inventory turnover x 10.92x
    Total assets turnover x 2.38x
    Profit margin % 1.25%
    ROA % 2.97%
    ROE % 6.19%
    ROIC % 7.20%
    TIE x 4.00x
    Debt/Total capital % 37.86%

    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.25%
    Total assets turnover x 2.38x
    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 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.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
  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 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.
    2. 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.
    3. 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.
    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 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.
    5. 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.

Solutions

Expert Solution

a.

Ratio Formula Barry Industry Average
Current Ratio Total Current Assets / Total Current Liabilities 2.1 x 2.07 x
Quick Ratio ( Total Current Assets - Inventories ) / Total Current Liabilities 1.43 x 1.37 x
Days Sales Outstanding ( 365 x Receivables ) / Sales 69.35 days 32.41 days
Inventory Turnover Cost of Goods Sold / Inventories 4.5 x 10.92 x
Total Assets Turnover Sales / Total Assets 2 x 2.38 x
Profit Margin Net Income / Sales 1.34 % 1.25 %
ROA Net Income / Total Assets 2.68 % 2.97 %
ROE Net Income / Common Equity 5.58 % 6.19 %
ROIC NOPAT / ( Long Term Debt + Common Equity) 4.62 % 7.2 %
TIE EBIT / Interest Expense 3.90 x 4.00 x
Debt / Total Capital Total Liabilities / ( Total Liabilities + Common Equity ) 52 % 37.86 %

b. DuPont Equation :

ROE = Profit Margin x Total Assets Turnover x Equity Multiplier

Firm Industry
Profit Margin 1.34 % 1.25 %
Total Assets Turnover 2 x 2.38 x
Equity Multiplier 2.08 x 2.08 x

c. III. 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.

d. IV. 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.


Related Solutions

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