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

90.2K

Verified Solution

Question

Finance

RATIO ANALYSIS

Data for Barry Computer Co. and its industry averagesfollow.

Barry Computer Company:
Balance Sheet as of December 31, 2016 (InThousands)
Cash$58,320Accounts payable$116,640
Receivables196,830Other current liabilities65,610
Inventories211,410Notes payable to bank43,740
   Total current assets$466,560   Total current liabilities$225,990
Long-term debt$153,090
Net fixed assets262,440Common equity349,920
Total assets$729,000Total liabilities and equity$729,000
Barry Computer Company:
Income Statement for Year Ended December 31, 2016 (InThousands)
Sales$1,350,000
Cost of goods sold
   Materials$675,000
   Labor270,000
   Heat, light, and power40,500
   Indirect labor148,500
   Depreciation27,0001,161,000
Gross profit$   189,000
Selling expenses135,000
General and administrative expenses13,500
   Earnings before interest and taxes(EBIT)$     40,500
Interest expense10,716
   Earnings before taxes (EBT)$     29,784
Federal and state income taxes (40%)11,914
Net income$     17,870
  1. Calculate the indicated ratios for Barry. Round your answers totwo decimal places.
    RatioBarry             Industry Average
    Currentx2.09x
    Quickx1.18x
    Days sales outstandingadays24.87 days
    Inventory turnoverx6.97x
    Total assets turnoverx2.20x
    Profit margin%1.24%
    ROA%2.72%
    ROE%5.43%
    ROIC%7.00%
    TIEx3.75x
    Debt/Total capital%34.90%

    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.
    FIRMINDUSTRY
    Profit margin%1.24%
    Total assets turnoverx2.20x
    Equity multiplierxx
  1. Select the correct option based on Barry's strengths andweaknesses as revealed by your analysis.
    -Select-IIIIIIIVVItem 16
    1. The firm's days sales outstanding is comparable to the industryaverage, indicating that the firm should neither tighten credit norenforce a more stringent collection policy. The total assetsturnover ratio is well below the industry average so sales shouldbe increased, assets increased, or both. While the company's profitmargin is higher than the industry average, its other profitabilityratios are low compared to the industry - net income should behigher given the amount of equity, assets, and invested capital.However, the company seems to be in a below average liquidityposition and financial leverage is similar to others in theindustry.
    2. The firm's days sales outstanding ratio is more than twice aslong as the industry average, indicating that the firm shouldtighten credit or enforce a more stringent collection policy. Thetotal assets turnover ratio is well below the industry average sosales should be increased, assets decreased, or both. While thecompany's profit margin is higher than the industry average, itsother profitability ratios are low compared to the industry - netincome should be higher given the amount of equity, assets, andinvested capital. However, the company seems to be in an averageliquidity position and financial leverage is similar to others inthe industry.
    3. The firm's days sales outstanding is more than twice as long asthe industry average, indicating that the firm should loosen creditor apply a less stringent collection policy. The total assetsturnover ratio is well below the industry average so sales shouldbe increased, assets increased, or both. While the company's profitmargin is higher than the industry average, its other profitabilityratios are low compared to the industry - net income should behigher given the amount of equity, assets, and invested capital.However, the company seems to be in an average liquidity positionand financial leverage is similar to others in the industry.
    4. The firm's days sales outstanding is less than the industryaverage, indicating that the firm should tighten credit or enforcea more stringent collection policy. The total assets turnover ratiois well below the industry average so sales should be increased,assets decreased, or both. While the company's profit margin islower than the industry average, its other profitability ratios arehigh compared to the industry - net income should be higher giventhe amount of equity, assets, and invested capital. However, thecompany seems to be in an average liquidity position and financialleverage is similar to others in the industry.
    5. The firm's days sales outstanding is more than the industryaverage, indicating that the firm should tighten credit or enforcea more stringent collection policy. The total assets turnover ratiois well above the industry average so sales should be increased,assets increased, or both. While the company's profit margin ishigher than the industry average, its other profitability ratiosare low compared to the industry - net income should be highergiven the amount of equity, assets, and invested capital. However,the company seems to be in an above average liquidity position andfinancial leverage is similar to others in the industry.
  2. Suppose Barry had doubled its sales as well as its inventories,accounts receivable, and common equity during 2016. How would thatinformation affect the validity of your ratio analysis?(Hint: Think about averages and the effects of rapidgrowth on ratios if averages are not used. No calculations areneeded.)
    -Select-IIIIIIIVVItem 17
    1. If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be distorted and a comparisonbetween 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'sstock price.
    2. If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be accurate and a comparison betweenthem and industry averages will have substantial meaning. Potentialinvestors need only look at 2016 ratios to be well informed, and areturn to normal conditions in 2017 could help the firm's stockprice.
    3. If 2016 represents a period of normal growth for the firm,ratios based on this year will be distorted and a comparisonbetween 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 thefirm's stock price.
    4. If 2016 represents a period of normal growth for the firm,ratios based on this year will be accurate and a comparison betweenthem and industry averages will have substantial meaning. Potentialinvestors who look only at 2016 ratios will be misled, and a returnto supernormal conditions in 2017 could hurt the firm's stockprice.
    5. If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be distorted and a comparisonbetween them and industry averages will have substantial meaning.Potential investors who look only at 2016 ratios will be wellinformed, and a return to normal conditions in 2017 could hurt thefirm's stock price.

Answer & Explanation Solved by verified expert
3.6 Ratings (638 Votes)
a Ratio Formula Barry Industry Average a Current Ratio Total Current Assets Total Current Liabilities 206 x 209 x b Quick Ratio Cash Receivables Total Current Liabilities 113 x 118 x c Days Sales Outstanding 365 Sales Accounts Receivable 5322 days 2487 days d Inventory Turnover Cost of Goods Sold Inventory 549 x 697 x e Total Asset    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

RATIO ANALYSISData for Barry Computer Co. and its industry averagesfollow.Barry Computer Company:Balance Sheet as of December 31, 2016 (InThousands)Cash$58,320Accounts payable$116,640Receivables196,830Other current liabilities65,610Inventories211,410Notes payable to bank43,740   Total current assets$466,560   Total current liabilities$225,990Long-term debt$153,090Net fixed assets262,440Common equity349,920Total assets$729,000Total liabilities and equity$729,000Barry Computer Company:Income Statement for Year Ended December 31, 2016 (InThousands)Sales$1,350,000Cost of goods sold   Materials$675,000   Labor270,000   Heat, light, and power40,500   Indirect labor148,500   Depreciation27,0001,161,000Gross profit$   189,000Selling expenses135,000General and administrative expenses13,500   Earnings before interest and taxes(EBIT)$     40,500Interest expense10,716   Earnings before taxes (EBT)$     29,784Federal and state income taxes (40%)11,914Net income$     17,870Calculate the indicated ratios for Barry. Round your answers totwo decimal places.RatioBarry             Industry AverageCurrentx2.09xQuickx1.18xDays sales outstandingadays24.87 daysInventory turnoverx6.97xTotal assets turnoverx2.20xProfit margin%1.24%ROA%2.72%ROE%5.43%ROIC%7.00%TIEx3.75xDebt/Total capital%34.90%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.FIRMINDUSTRYProfit margin%1.24%Total assets turnoverx2.20xEquity multiplierxxSelect the correct option based on Barry's strengths andweaknesses as revealed by your analysis.-Select-IIIIIIIVVItem 16The firm's days sales outstanding is comparable to the industryaverage, indicating that the firm should neither tighten credit norenforce a more stringent collection policy. The total assetsturnover ratio is well below the industry average so sales shouldbe increased, assets increased, or both. While the company's profitmargin is higher than the industry average, its other profitabilityratios are low compared to the industry - net income should behigher given the amount of equity, assets, and invested capital.However, the company seems to be in a below average liquidityposition and financial leverage is similar to others in theindustry.The firm's days sales outstanding ratio is more than twice aslong as the industry average, indicating that the firm shouldtighten credit or enforce a more stringent collection policy. Thetotal assets turnover ratio is well below the industry average sosales should be increased, assets decreased, or both. While thecompany's profit margin is higher than the industry average, itsother profitability ratios are low compared to the industry - netincome should be higher given the amount of equity, assets, andinvested capital. However, the company seems to be in an averageliquidity position and financial leverage is similar to others inthe industry.The firm's days sales outstanding is more than twice as long asthe industry average, indicating that the firm should loosen creditor apply a less stringent collection policy. The total assetsturnover ratio is well below the industry average so sales shouldbe increased, assets increased, or both. While the company's profitmargin is higher than the industry average, its other profitabilityratios are low compared to the industry - net income should behigher given the amount of equity, assets, and invested capital.However, the company seems to be in an average liquidity positionand financial leverage is similar to others in the industry.The firm's days sales outstanding is less than the industryaverage, indicating that the firm should tighten credit or enforcea more stringent collection policy. The total assets turnover ratiois well below the industry average so sales should be increased,assets decreased, or both. While the company's profit margin islower than the industry average, its other profitability ratios arehigh compared to the industry - net income should be higher giventhe amount of equity, assets, and invested capital. However, thecompany seems to be in an average liquidity position and financialleverage is similar to others in the industry.The firm's days sales outstanding is more than the industryaverage, indicating that the firm should tighten credit or enforcea more stringent collection policy. The total assets turnover ratiois well above the industry average so sales should be increased,assets increased, or both. While the company's profit margin ishigher than the industry average, its other profitability ratiosare low compared to the industry - net income should be highergiven the amount of equity, assets, and invested capital. However,the company seems to be in an above average liquidity position andfinancial leverage is similar to others in the industry.Suppose Barry had doubled its sales as well as its inventories,accounts receivable, and common equity during 2016. How would thatinformation affect the validity of your ratio analysis?(Hint: Think about averages and the effects of rapidgrowth on ratios if averages are not used. No calculations areneeded.)-Select-IIIIIIIVVItem 17If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be distorted and a comparisonbetween 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'sstock price.If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be accurate and a comparison betweenthem and industry averages will have substantial meaning. Potentialinvestors need only look at 2016 ratios to be well informed, and areturn to normal conditions in 2017 could help the firm's stockprice.If 2016 represents a period of normal growth for the firm,ratios based on this year will be distorted and a comparisonbetween 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 thefirm's stock price.If 2016 represents a period of normal growth for the firm,ratios based on this year will be accurate and a comparison betweenthem and industry averages will have substantial meaning. Potentialinvestors who look only at 2016 ratios will be misled, and a returnto supernormal conditions in 2017 could hurt the firm's stockprice.If 2016 represents a period of supernormal growth for the firm,ratios based on this year will be distorted and a comparisonbetween them and industry averages will have substantial meaning.Potential investors who look only at 2016 ratios will be wellinformed, and a return to normal conditions in 2017 could hurt thefirm's stock price.

Other questions asked by students