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 |
- Calculate the indicated ratios for Barry. Do not round intermediate calculations. Round your answers to two decimal places.
aCalculation is based on a 365-day year.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 - 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
Get step-by-step solutions from verified subject matter experts
