Question

Barry Computer Company: Balance Sheet as of December 31, 2018 (In Thousands) Cash $167,440 Accounts payable $191,360 Receivab
Barry Computer Company: Income Statement for Year Ended December 31, 2018 (In Thousands) Sales $2,300,000 Cost of goods sold
a. Calculate the indicated ratios for Barry. Round your answers to two decimal places. Ratio Barry Industry Average Current 1
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Barry Computer Company: Balance Sheet as of December 31, 2018 (In Thousands) Cash $167,440 Accounts payable...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Ratio Analysis Data for Barry Computer Co. and its industry averages follow Barry Computer Company: Balance...

    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, 2...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT