Question: **** Need Help with Missing Values, Please include breakdown & formulas. I am completely lost. Thank you! Data for Barry Computer Co. and its industry

**** Need Help with Missing Values, Please include breakdown & formulas. I am completely lost. Thank you!

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, 2019 (In Thousands)
Cash $ 81,030 Accounts payable $ 148,555
Receivables 378,140 Other current liabilities 135,050
Inventories 378,140 Notes payable to bank 108,040
Total current assets $ 837,310 Total current liabilities $ 391,645
Long-term debt 297,110
Net fixed assets 513,190 Common equity (66,174.5 shares) 661,745
Total assets $ 1,350,500 Total liabilities and equity $ 1,350,500

Barry Computer Company: Income Statement for Year Ended December 31, 2019 (In Thousands)
Sales $ 1,850,000
Cost of goods sold
Materials $925,000
Labor 407,000
Heat, light, and power 129,500
Indirect labor 74,000
Depreciation 74,000 1,609,500
Gross profit $ 240,500
Selling expenses 111,000
General and administrative expenses 37,000
Earnings before interest and taxes (EBIT) $ 92,500
Interest expense 29,711
Earnings before taxes (EBT) $ 62,789
Federal and state income taxes (25%) 15,697
Net income $ 47,092
Earnings per share $ 0.7116
Price per share on December 31, 2019 $ 11.00

  1. Calculate the indicated ratios for Barry. Do not round intermediate calculations. Round your answers to two decimal places.
    Ratio Barry Industry Average
    Current 2.14 2.07
    Quick 1.17 1.11
    Days sales outstandinga 74.61 35 days
    Inventory turnover 5.13
    Total assets turnover 1.37 1.54
    Profit margin 2.55% 2.38 %
    ROA 3.49 % 3.67 %
    ROE 7.12% 7.91 %
    ROIC % 7.30 %
    TIE 3.11 3.04
    Debt/Total capital 37.97% 38.87 %
    M/B 5.10
    P/E 17.91
    EV/EBITDA 8.78
    aCalculation is based on a 365-day year.
  2. Construct the DuPont equation for both Barry and the industry. Do not round intermediate calculations. Round your answers to two decimal places.
    FIRM INDUSTRY
    Profit margin % 2.38%
    Total assets turnover 1.54
    Equity multiplier 2.04

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!