Answer;
Current Ratio = Current Assets / Current Liabilities = 849160 / 490360 = 1.73
Quick Ratio = Quick Assets / Current Liabilities = 550160 / 490360 = 1.12
Days Sales Outstanding = 365 / ( 2300000 / 382720 ) = 365 / 6.01 = 60.73 Days.
Inventory Turnover = Cost of goods sold / Inventory = 1886000 / 299000 = 6.31
Total Assets Turnover = Sales / Total Assets = 2300000 / 1196000 = 2300000/1196000 = 1.92
Profit Margin = Net Income / Sales = 27838 / 2300000 = 1.21%
ROA = Net Income / Total Assets = 27838 / 1196000 = 2.33%
ROE = Net Income / Total Equity = 27838 / 454480 = 6.13%
ROIC = Net Income / ( Long Term Debt + Equity ) = 27838 / (251160 + 454480 ) = 27838 / 705640 = 3.95%
Times Interest Earned = EBIT / Interest Expense = 69000 / 22604 = 3.05 Times
Debt / Total Capital = Total Liabilities / Equity = (490360 + 251160 ) / 454480 = 741520 / 454480 = 1.63
Market Value / Book Value = 454480 / 454480 = 1
Price Earnings = Market Price / Earning per share = 10 / 0.61252 = 16.33
EV/EBITDA = Enterprise Value / EBITDA = 1028560 / (69000 + 115000 ) = 1028560 / 184000 = 5.59
Enterprise Value = Market Capitalization + Total Liabilities - Cash = 454480 + 490360 + 251160 - 167440 = 1028560
Requirement b
Dupont Equation :
ROE = Profit Margin x Asset Turnover x Equity Multiplier = 1.21% x 1.92 x 2.63 = 6.13%
Equity Multiplier = Total Assets / Total Equity = 1196000 / 454480 = 2.63
Barry Computer Company: Balance Sheet as of December 31, 2018 (In Thousands) Cash $167,440 Accounts payable...
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 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...
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...
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...
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...
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...
Chapter 4 Analysis of Financial Statements 141 Barry Computer Company: Income Statement for Year Ended December 31, 2019 (in Thousands) Sales Cost of goods sold $1,607,500 Materials $717,000 Labor 453,000 Heat, light, and power 68,000 Indirect labor 113,000 Depreciation 41,500 1,392,500 Gross profit $ 215,000 Selling expenses 115,000 General and administrative expenses 30,000 Earnings before interest and taxes (EBIT) 70,000 Interest expense 21,000 Earnings before taxes (EBT) 49,000 Federal and state income taxes (25%) 12,250 Net income $ 36,750 Earnings...
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...