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, 2018 (In Thousands) | ||||
Cash | $90,720 | Accounts payable | $196,560 | |
Receivables | 589,680 | Other current liabilities | 151,200 | |
Inventories | 302,400 | Notes payable to bank | 75,600 | |
Total current assets | $982,800 | Total current liabilities | $423,360 | |
Long-term debt | $302,400 | |||
Net fixed assets | 529,200 | Common equity (78,624 shares) | 786,240 | |
Total assets | $1,512,000 | Total liabilities and equity | $1,512,000 |
Barry Computer Company: Income Statement for Year Ended December 31, 2018 (In Thousands) |
|||
Sales | $2,100,000 | ||
Cost of goods sold | |||
Materials | $903,000 | ||
Labor | 546,000 | ||
Heat, light, and power | 105,000 | ||
Indirect labor | 168,000 | ||
Depreciation | 84,000 | 1,806,000 |
Gross profit | $ | 294,000 |
Selling expenses | 126,000 | |
General and administrative expenses | $ | 42,000 |
Earnings before interest and taxes (EBIT) | $ | 126,000 |
Interest expense | 36,288 | |
Earnings before taxes (EBT) | $ | 89,712 |
Federal and state income taxes (40%) | 35,885 | |
Net income | $ | 53,827 |
Earnings per share | $ | 0.68461 |
Price per share on December 31, 2018 | $ | 11.00 |
Ratio | Barry | Industry Average |
Current | x | 2.27x |
Quick | x | 1.64x |
Days sales outstandinga | days | 47.89 days |
Inventory turnover | x | 7.58x |
Total assets turnover | x | 1.65x |
Profit margin | % | 2.40% |
ROA | % | 3.96% |
ROE | % | 7.61% |
ROIC | % | 7.50% |
TIE | x | 3.50x |
Debt/Total capital | % | 33.57% |
M/B | % | 4.10% |
P/E | % | 18.51% |
EV/EBITDA | % | 7.89% |
FIRM | INDUSTRY | |
Profit margin | % | 2.40% |
Total assets turnover | x | 1.65x |
Equity multiplier | x | x |
As per rules I am answering the first 4 subparts of the question
1: Current ratio = Current assets/ Current liabilities
= 982800/423360
=2.32
2: Quick ratio = (Cash + receivables)/ current liabilities
= (90720+589680)/ 423360
=1.61
3: DSO= AR*365/ Sales
= 589680*365/ 2100000
=102.49 days
4: Inventory turnover = COGS/ Average inventory
= 1806000/ 302400
=5.97
Data for Barry Computer Co. and its industry averages follow. The firm's debt is priced at...
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, 2018 (In Thousands) Cash $90,720 Accounts payable $196,560 Receivables 589,680 Other current liabilities 151,200 Inventories 302,400 Notes payable to bank 75,600 Total current assets $982,800 Total current liabilities $423,360 Long-term...
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, 2018 (In Thousands) Cash $90,720 Accounts payable $196,560 Receivables 589,680 Other current liabilities 151,200 Inventories 302,400 Notes payable to bank 75,600 Total current assets $982,800 Total current liabilities $423,360 Long-term...
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, 2018 (In Thousands) Cash $183,600 Accounts payable $285,600 Receivables 571,200 Other current liabilities 183,600 Inventories 571,200 Notes payable to bank 183,600 Total current assets $1,326,000 Total current liabilities $652,800 Long-term...
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 $ 95,760 Accounts payable Receivables 340,480 Other current liabilities Inventories 297,920 Notes payable to bank Total current assets $ 734,160 Total current liabilities Long-term debt Net...
eBook 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 Accounts payable $ 85,760 $ 107,200 Receivables 428,800 Other current liabilities 85,760 Inventories 310,880 Notes payable to bank 117,920 Total current liabilities Total current assets...
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 $ 68,640 Accounts payable $ 145,860 Receivables 231,660 Other current liabilities 68,640 Inventories 205,920 Notes payable to bank 77,220 Total current assets $ 506,220 Total current...
Ratio Analysis Data for Barry Computer Co. and its industry averages follow Barry Computer Company: Balance Sheet as of December 31, 2014 (In Thousands) Cash Receivables Inventories $52,650 379,080 221,130 $652,860 Accounts payable Other current liabilities Notes payable $136,890 136,890 126,360 $400,140 Total current liabilities Long-term debt Common equity Total liabilities and equity Total current assets $294,840 358,020 $1,053,000 Net fixed assets 400,140 Total assets $1,053,000 Barry Computer Company Income Statement for Year Ended December 31, 2014 (In Thousands) Sales...
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, 2018 (In Thousands) Cash $221,260 Accounts payable $255,300 Receivables 629,740 Other current liabilities 187,220 Inventories 476,560 Notes payable to bank 170,200 Total current assets $1,327,560 Total current liabilities $612,720 Long-term...
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, 2018 (In Thousands) Cash Accounts payable $82,225 Receivables $56,925 202,400 164,450 Other current liabilities 101,200 Inventories Notes payable to bank 44,275 Total current assets $423,775 Total current liabilities $227,700 $132,825...
Please and 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) $ 190,275 Accounts payable Cash 177,590 Receivables 431,290 Other current liabilities 101,480 253,700 Notes payable to bank 139,535 Inventories $ 875,265 Total current...