Answer:
Current Ratio = Current Assets / Current Liabilities = 423775 / 227700 = 1.86
Quick Ratio = Quick Assets / Current Liabilities = 259325 / 227700 = 1.14
Days Sales Outstanding = 365 / (sales / Average accounts receivable)
= 365 / (1150000 / 202400 )
= 365 / 5.68 = 64.26 Days
Inventory Turnover = Cost of goods sold / Inventory = 1012000 / 164450 = 6.15
Total Assets Turnover = Sales / Total Assets = 1150000 / 632500 = 1.82
Profit Margin = Net Income / Sales = 21224 / 1150000 = 1.85%
ROA = Net Income / Total Assets = 21224 / 632500 = 3.36%
ROE = Net Income / Total Equity = 21224 / 271975 = 7.8%
ROIC = Net Income / (Long Term Liabilities + Total Equity )
= 21224 / ( 132825 + 271975 ) = 21224 / 404800 = 5.24%
TIE = EBIT / Interest Expense = 46000/ 10626 = 4.32 times
Debt / Total Capital = ( 227700 + 132825 ) / ( 227700 + 132825 + 271975 ) = 360525 / 632500 = 0.57
M/B = Market Value / Book Value = 11 / (271975 / 27197.50 ) = 11 / 10 = 1.1
P /E = Market Value / EPS = 11 / 0.78037 = 14.0958
EV / EBITDA = (Market value of Equity + Market Value of Debt - Cash) / EBITDA
= (27197.50 x 11 + 227700 + 132825 - 56925 ) / ( 46000 + 57500 )
= ( 299172.50 + 227700 + 132825 - 56924 / 103500
= 602773.50 / 103500
= 5.82
Equity Multiplier Barry = Total Assets / Total Equity = 632500 / 271975 = 2.33
Industry Equity Multiplier = ROE / ROA = 8.67 / 3.73 = 2.32
ROE Dupont Barry = Profit Margin x Total Assets Turnover x Equity Multiplier = 1.85% x 1.82 x 2.33 = 7.85%
ROE Dupont Industry = 1.76% x 2.12 x 2.32 = 8.67%
Data for Barry Computer Co, and its industry averages follow. The firm's debt is priced at par,...
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, 2019 (In Thousands) Cash $ 122,760 Accounts payable $ 133,920 Receivables 446,400 Other current liabilities 156,240 Inventories 301,320 Notes payable to bank 55,800 Total current assets $ 870,480 Total current...
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 $ 84,000 Accounts payable $ 119,000 Receivables 252,000 Other current liabilities 105,000 Inventories 196,000 Notes payable to bank 84,000 Total current assets $ 532,000 Total current...
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 $ 107,360 Accounts payable $ 214,720 Receivables 496,540 Other current liabilities 214,720 Inventories 389,180 Notes payable to bank 80,520 Total current assets $ 993,080 Total current...
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 $ 131,250 Accounts payable Receivables 253,125 Other current liabilities Inventories 196,875 Notes payable to bank Total current assets $581,250 Total current liabilities Long-term debt Net fixed...
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 $ 89,540 Accounts payable Receivables 219,780 Other current liabilities Inventories 203,500 Notes payable to bank Total current assets $512,820 Total current liabilities Long-term debt Net fixed...
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 $ 87,615 Accounts payable $ 87,615 Receivables 302,670 Other current liabilities 111,510 Inventories 215,055 Notes payable to bank 55,755 Total current assets $605,340 Total current liabilities...
RATIO ANALYSIS Data for Barry Computer Co. and its industry averages follow. Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Cash $114,000 Accounts payable $142,500 Receivables 456,000 Other current liabilities 199,500 Inventories 313,500 Notes payable to bank 71,250 Total current assets $883,500 Total current liabilities $413,250 Long-term debt $299,250 Net fixed assets 541,500 Common equity 712,500 Total assets $1,425,000 Total liabilities and equity $1,425,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (In...
Data for Barry Computer Co. and its industry averages follow Barry Computer Company: Balance Sheet as of December 31, 2016 (In Thousands) Accounts payable Cash $174,960 $160,380 Receivables Other current liabilities 174,960 510,300 Inventories 393,660 Notes payable to bank 116,640 Total current assets $1,078,920 Total current liabilities $451,980 Long-term debt $335,340 Net fixed assets 379,080 Common equity 670,680 Total assets $1,458,000 Total liabilities and equity $1,458,000 Barry Computer Company: Income Statement for Year Ended December 31, 2016 (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 $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...