Explore BrainMass
Share

Ratio Analysis for Barry Computer Company

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Data for Barry Computer Company and its industry averages follow:

A. Calculate the indicated ratios for Barry.

B. Construct and extend DuPont evaluation for both Barry and the industry.

C. Outline Barry's strengths and weaknesses as revealed by your analysis.

D. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2004. How would that information affect the validity of your ratio analysis? (hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.)

Barry Computer Company: Balance Sheet as of December 31, 2003 (In Thousands)

Cash $77,500 Accounts payable $129,000
Receivables 336,000 Notes payable 84,000
Inventories 241,500 Other current liabilities 117,000
Total Cash Assets 655,000 Total current liabilities 330,000
Net fixed assets 292,500 Long-term debt 256,500
Common equity 361,000
Total assets $947,500 Total liabilities and equity 947,500

Barry Computer Company Income Statement for year ended December 31, 2004 (in Thousands)

Sales $1,607,500
Costs of goods sold 1,392,500
Selling, general, and administrative expenses 145,000
Earnings before interest and taxes (EBIT) $70,000
Interest expense 24,500
Earning before taxes (EBT) $45,500
Federal and state incomes taxes (40%) 18,200
Net Income $27,300

A. Calculate the indicated ratios for Barry.
B. Construct and extend DuPont evaluation for both Barry and the industry.
C. Outline Barry's strengths and weaknesses as revealed by your analysis.
D. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2004. How would that information affect the validity of your ratio analysis? (hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.)

© BrainMass Inc. brainmass.com October 24, 2018, 6:00 pm ad1c9bdddf
https://brainmass.com/business/financial-ratios/ratio-analysis-for-barry-computer-company-27861

Attachments

Solution Preview

see attached file

Data for Barry Computer Company and its industry averages follow:

A. Calculate the indicated ratios for Barry.

B. Construct and extend DuPont evaluation for both Barry and the industry.

C. Outline Barry's strengths and weaknesses as revealed by your analysis.

D. Suppose Barry had doubled its sales as well as its inventories, accounts receivable, and common equity during 2004. How would that information affect the validity of your ratio analysis? (hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.)

Barry Computer Company: Balance Sheet as of December 31, 2003 (In Thousands)

Cash $77,500 Accounts payable $129,000
Receivables 336,000 Notes payable 84,000
Inventories 241,500 Other current liabilities 117,000
Total Cash Assets 655,000 Total current liabilities 330,000
Net fixed assets 292,500 Long-term debt 256,500
Common equity 361,000
Total assets $947,500 Total liabilities and equity 947,500

Barry Computer Company Income Statement for year ended December 31, 2004 (in Thousands)

Sales $1,607,500
Costs of goods sold 1,392,500
Selling, general, and administrative expenses 145,000
Earnings before interest and taxes (EBIT) $70,000
Interest expense 24,500
Earning before taxes (EBT) $45,500
Federal and state incomes taxes (40%) 18,200
Net Income $27,300

A. Calculate the indicated ratios for Barry.

The calculations have been shown below

Ratio Barry Industry Average
Current Asserts/current ...

Solution Summary

The financial ratios for Barry Computer Company have been calculated based on balance sheet and income statement . These are compared with industry averages to indicate strengths and weaknesses of the company. Also Du Pont analysis has been carried out.

$2.19
See Also This Related BrainMass Solution

Finance Question and Process

Baker brothers have a DSO of 40 days. The company's average daily sales are $20,000.
What is the level of its accounts receivable? Assume there are 365 days in a year.

Data for Barry Computer Company and its industry averages follow.
a) Calculate the indicated ratios for Barry.
b) Construct the extended Du Pont equation for both Barry and the industry.
c) Outline Barry's strengths and weaknesses as revealed by your analysis.
d) Suppose Barry had doubled its sales as well as its inventories, accounts receivable , and common equity during 2004. How would that information affect the validity of your ratio analysis? (A hint: Think about averages and the effects of rapid growth on ratios if averages are not used. No calculations are needed.)

Barry Computer Company: Balance Sheet as of December 31, 2004 (in thousands)

Cash $77,500 Accounts Payable $129,000
Receivables 336,000 Notes payable 84,000
Inventories 241,500 Other current liabilities 117,000
Total current assets $655,000 Total current liabilities $330,000

Net fixed assets 292,500 Long term Debt 256,000
Common equity 361,000
Total Assets $947,500 Total liabilities & equity $947, 500

Barry Computer Company: income statement for year ended December 31, 2004 (in thousands).

Sales $1,607,500
Cost of goods sold 1,392,500
Selling general and admin
Expenses 145,000
Earnings before interest &
Taxes $ 70,000
Interest expense 24,500
Earnings before taxes $ 45,500
Federal and state income taxes (40%) 18,200
Net income $ 27,300

Ratio Barry Industry average

Current assets/current liabilities 2.0x
Days sales outstanding 35 days
Sales/inventory 6.7x
Sales/fixed assets 12.1x
Sales/total assets 3.0x
Net income/sales 1.2%
Net income/total assets 3.6%
Net income/common equity 9.0%
Total debt/total assets 60.0%

Carter Corporation's sales are expected to increase from $5 million in 2004 to $6 million in 2005, or by 20%. Its assets totaled $3 million at the end of 2004. Carter is at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2004, current liabilities were $1 million, consisting of $250,000 of accounts payable, $500,000 of notes payable, and $250,000 of accruals. The after-tax profit margin is forecasted payout ratio is 70 percent.

a) Use the AFN formula to forecast Carter's additional funds needed for the coming year.
b) What would be the additional funds needed if the company's year-end 2004 assets had been $4 million? Assume that all other numbers are the same. Why is this AFN different from the one found in question A. Is the company's capitol intensity the same or different?

Pierce furnishings generated $2.0 million in sales during 2004, and its year-end total assets were $1.5 million. Also, at year-end 2004, current liabilities were $500,000, consisting of $200,000 of notes payable, $200,000 of accounts payable, and $100,000 of accruals. Looking ahead to 2005, the company estimates that its assets must increase by 75 cents for every $1 increase in sales. Pierces profit margin is 5 percent, and its payout ratio is 60 percent. How large a sales increase can the company achieve without having to raise funds externally.

View Full Posting Details