Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, please advise, I got the ROIC wrong, and I need help with that, everything else is good, thanks Q-9 Data for Barry Computer Co.
Hello, please advise, I got the ROIC wrong, and I need help with that, everything else is good, thanks
Q-9
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 $ 52,200 Accounts payable Receivables 354,960 Other current liabilities Inventories 292,320 Notes payable to bank Total current assets $ 699,480 Total current liabilities Long-term debt Net fixed assets 344,520 Common equity (44,892 shares) Total assets $ 1,044,000 Total liabilities and equity 156,600 93,960 52,200 $ 302,760 292,320 448,920 $ 1,044,000 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (In Thousands) Sales $ 1,450,000 Cost of goods sold Materials $710,500 Labor 362,500 Heat, light, and power 43,500 Indirect labor 87,000 Depreciation 58,000 1,261,500 Gross profit $ 188,500 Selling expenses 101,500 General and administrative expenses 14,500 Earnings before interest and taxes (EBIT) 72,500 Interest expense 26,309 Earnings before taxes (EBT) 46,191 Federal and state income taxes (25%) 11,548 Net income $ 34,643 Earnings per share $ 0.7717 Price per share on December 31, 2019 $ 12.00 a. Calculate the indicated ratios for Barry. Do not round intermediate calculations. Round your answers to two decimal places. Ratio Barry Industry Average Current 2.31 x 2.32 x Quick 1.34 x 1.29 x Days sales outstandinga 89.35 days 42 days Inventory turnover 4.96 5.20 x Total assets turnover 1.39 1.56 x Profit margin 2.39 2.23% ROA 3.32 3.49% ROE 8.21 % ROIC 7.80% 7.72 TIE 2.73 x 2.76 43.42 Debt/Total capital 42.12% M/B 1.2 4.20 P/E 15.55 17.97 EV/EBITDA 6.37 9.30 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. FIRM INDUSTRY Profit margin 2.38 % 2.23% Total assets turnover 1.39 x 1.56x Equity multiplier 2.32 x 2.36 x
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started