Data for Barry Computer Co. and its industry averages follow. a. Calculate the indicated ratios for Barry. b. Construct the DuPont equation for both Barry and the industry. c. Outline Barry’s strengths and weaknesses as revealed by your analysis. d. 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?
Barry Computer Company:CashReceivablesInventoriesTotal current assets Net fixed assetsTotal assetsBalance Sheet as of December 31, 2016 (in Thousands)$ 77.500336.000241.500$ 655.000 292.500$ 947.500Accounts payableOther current liabilitiesNotes payable to bankTotal current liabilitiesLong-term debtCommon equityTotal liabilities and equity$ 129.000117.00084.000$ 330.000256.500361.000$ 947.500
Barry Computer Company:SalesCosts of goods soldMaterialsLaborHeat, light, and powerIndirect laborDeprecationGross profitSelling expensesGeneral and administrative expensesEarnings before interest and taxes (EBIT)Interest expenseEarnings before taxes (EBT)Federal and state income taxes (40%)Net incomeBalance Sheet as of December 31, 2016 (in Thousands) $ 717.000453.00068.000113.00041.500 $ 1.607.5001.392.500$ 215.000115.00030.000$ 70.00024.500$45.50018.200$ 27.300
RatioCurrentQuickDays sales outstandingInventory turnoverTotal assets turnoverProfit marginROAROEROICTIEDebt/Total capitalBarry Industry Average2.0 ×1.3 ×35 days6.7 ×3.0 ×1.2%3.6%9.0%7.5%3.0 ×47.0%