Question

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, 2018 (In Thousands)

Cash

$77,500

Accounts payable

$129,000

Receivables

336,000

Other current liabilities

117,000

Inventories

241,500

Notes payable

84,000

Total current assets

$655,000

Total current liabilities

$330,000

Long-term debt

$256,500

Net fixed assets

292,500

Common equity

361,000

Total assets

$947,500

Total liabilities and equity

$648,000

Barry Computer Company:
Income Statement for Year Ended December 31, 2015(In Thousands)

Sales

$1,607,500

Cost of goods sold

Materials

$717000

Labor

453,000

Heat, light, and power

68,000

Indirect labor

113,000

Depreciation

41,500

$1,39,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

24,500

Earnings before taxes (EBT)

45,500

Federal and state income taxes (40%)

18,200

Net income

$27,300

Calculate the indicated ratios for Barry. Round your answers to two decimal places.

Ratio

Barry

Industry Average

Current

x

2.0x

Quick

x

1.3x

Days sales outstandinga

days

35days

Inventory turnover

x

6.7x

Total assets turnover

x

3.0x

Profit margin

%

1.2%

ROA

%

3.6%

ROE

%

9.0%

ROIC

%

7.5%

TIE

x

3.0x

Debt/Total capital

M/B

P/E

EV/EBITDA

%

x

x

x

47.0%

4.22

17.86

9.14

Homework Answers

Answer #2

Please find the below link for detailed excel file.

https://ufile.io/yqzgt

Days salesoutstanging = (365 * receivables )/ sales 76.29238
Inventory turnover= COGS / Inventory 2.968944
Total assets turnover = sales / assets 1.69657
Profit margin = net profit / sales 1.698289
ROA = Net income/ assets 2.881266
ROE = net income / equity 7.562327
ROIC = EBIT(1-t) / Invested capital 11.63435
TIE = EBIT / Interest expense 2.857143
Debt to total capital ratio = longterm debt /(long term debt + equity) 41.53846
answered by: anonymous
Know the answer?
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
Similar Questions
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 $ 43,750 Accounts payable $ 122,500 Receivables 245,000 Other current liabilities 140,000 Inventories 183,750 Notes payable to bank 52,500    Total current assets $ 472,500    Total current...
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 $ 69,000 Accounts payable $ 89,700 Receivables 269,100 Other current liabilities 69,000 Inventories 207,000 Notes payable to bank 41,400    Total current assets $ 545,100    Total current...
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 $208,800 Accounts payable $295,800 Receivables 435,000 Other current liabilities 139,200 Inventories 417,600 Notes payable to bank 87,000    Total current assets $1,061,400    Total current liabilities $522,000 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 $212,520 Accounts payable $182,160 Receivables 516,120 Other current liabilities 136,620 Inventories 425,040 Notes payable to bank 182,160    Total current assets $1,153,680    Total current liabilities $500,940 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 $ 93,800 Accounts payable $ 150,080 Receivables 234,500 Other current liabilities 93,800 Inventories 206,360 Notes payable to bank 93,800    Total current assets $ 534,660    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 $ 249,900 Accounts payable $ 249,900 Receivables 678,300 Other current liabilities 232,050 Inventories 428,400 Notes payable to bank 89,250    Total current assets $ 1,356,600    Total...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company:...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $   220,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,155,000 Other current liabilities 540,000   Total current assets $2,950,000   Total current liabilities $1,240,000 Net fixed assets 1,325,000 Long-term debt 400,000 Common equity 2,635,000 Total assets $4,275,000 Total liabilities and equity $4,275,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company:...
Comprehensive Ratio Analysis Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $   220,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,155,000 Other current liabilities 540,000   Total current assets $2,950,000   Total current liabilities $1,240,000 Net fixed assets 1,325,000 Long-term debt 400,000 Common equity 2,635,000 Total assets $4,275,000 Total liabilities and equity $4,275,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands...
Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as...
Data for Lozano Chip Company and its industry averages follow. Lozano Chip Company: Balance Sheet as of December 31, 2019 (Thousands of Dollars) Cash $   220,000 Accounts payable $   600,000 Receivables 1,575,000 Notes payable 100,000 Inventories 1,155,000 Other current liabilities 540,000   Total current assets $2,950,000   Total current liabilities $1,240,000 Net fixed assets 1,325,000 Long-term debt 400,000 Common equity 2,635,000 Total assets $4,275,000 Total liabilities and equity $4,275,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) Sales...
Sales 1,067,500 Cost of goods sold 1,392,500 Selling, general and administrative 145,000 Earnings before interest and...
Sales 1,067,500 Cost of goods sold 1,392,500 Selling, general and administrative 145,000 Earnings before interest and taxes (EBIT) 70,000 Federal and state income taxes (40%) 18,200 Net income 27,300 HH Company Balance Sheet as of December 31, 20XX Assets 80,500 Accounts Payable 132,000 Accounts Receivable 334,500 Current portion of debt 84,000 Inventories 240,000 Other current liabilities 114,000 Total current assets 655,000 Total current liabilities 330,000 Net fixed assets 292,500 Long-term debt 256,500 Total assets 947,500 Total liabilities 586,500 Common equity...