Cash Receivables Inventories Balance Sheet as of December 31, 2021 (in thousands) $ 121,000 Accounts payable...

Transcribed Image Text:

Cash Receivables Inventories Balance Sheet as of December 31, 2021 (in thousands) $ 121,000 Accounts payable 453,750 363,000 Other current liabilities Notes payable to bank Total current assets $ 937,750 Net fixed assets Total assets 574,750 $1,512,500 Total current liabilities Long-term debt Common equity (57,475 shares) Total liabilities and equity Barry Computer Company: Income Statement for Year Ended December 31, 2021 (in thousands) Sales $2,750,000 $ 151,250 211,750 181,500 $ 544,500 393,250 574,750 $1,512,500 Cost of goods sold Materials Labor Heat, light, and power Indirect labor Gross profit $1,127,500 605,000 192,500 275,000 2,200,000 $ 550,000 Selling expenses 275,000 General and administrative expenses 27,500 Depreciation 137,500 Earnings before interest and taxes (EBIT) $110,000 Interest expense 31,460 Earnings before taxes (EBT) $ 78,540 Federal and state income taxes (25%) 19,635 Net income $ 58,905 Earnings per share $ 1.0249 Price per share on December 31, 2021 $ 12.00 Barry Current a. Calculate the indicated ratios for Barry. Do not round intermediate calculations. Round your answers to two decimal places. Ratio Industry Average 1.69 x 2.08 x Quick 1.11 x 1.29 x Days sales outstanding 42 days 28 days Inventory turnover 8.27 x 4.73 Total assets turnover 1.61 x 2.16 x Profit margin 2.00% 2.45 ROA 4.33% 3.94 % ROE 10.65 10.90% % ROIC 7.5 7.70% % TIE 3.41 x 3.43 Debt/Total capital 50.90% 53.45 % M/B 5.20 5.1 P/E 14.52 14.26 EV/EBITDA 7.34 9.92 "Calculation is based on a 365-day year. b. Construct the DuPont equation for both Barry and the industry. Do not round intermediate calculations. Round your answers to two decimal places. Profit margin INDUSTRY 2.00% FIRM 2.45 % Total assets turnover 2.16x 1.61 x Equity multiplier 2.08 x 1.69 x Cash Receivables Inventories Balance Sheet as of December 31, 2021 (in thousands) $ 121,000 Accounts payable 453,750 363,000 Other current liabilities Notes payable to bank Total current assets $ 937,750 Net fixed assets Total assets 574,750 $1,512,500 Total current liabilities Long-term debt Common equity (57,475 shares) Total liabilities and equity Barry Computer Company: Income Statement for Year Ended December 31, 2021 (in thousands) Sales $2,750,000 $ 151,250 211,750 181,500 $ 544,500 393,250 574,750 $1,512,500 Cost of goods sold Materials Labor Heat, light, and power Indirect labor Gross profit $1,127,500 605,000 192,500 275,000 2,200,000 $ 550,000 Selling expenses 275,000 General and administrative expenses 27,500 Depreciation 137,500 Earnings before interest and taxes (EBIT) $110,000 Interest expense 31,460 Earnings before taxes (EBT) $ 78,540 Federal and state income taxes (25%) 19,635 Net income $ 58,905 Earnings per share $ 1.0249 Price per share on December 31, 2021 $ 12.00 Barry Current a. Calculate the indicated ratios for Barry. Do not round intermediate calculations. Round your answers to two decimal places. Ratio Industry Average 1.69 x 2.08 x Quick 1.11 x 1.29 x Days sales outstanding 42 days 28 days Inventory turnover 8.27 x 4.73 Total assets turnover 1.61 x 2.16 x Profit margin 2.00% 2.45 ROA 4.33% 3.94 % ROE 10.65 10.90% % ROIC 7.5 7.70% % TIE 3.41 x 3.43 Debt/Total capital 50.90% 53.45 % M/B 5.20 5.1 P/E 14.52 14.26 EV/EBITDA 7.34 9.92 "Calculation is based on a 365-day year. b. Construct the DuPont equation for both Barry and the industry. Do not round intermediate calculations. Round your answers to two decimal places. Profit margin INDUSTRY 2.00% FIRM 2.45 % Total assets turnover 2.16x 1.61 x Equity multiplier 2.08 x 1.69 x

Answer rating: 100% (QA)

DuPont Equation For Barry Computer Company Barrys ROE Profit Margin Tota... View the full answer