Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Calculate the indicated ratios for barry

11/10/2021 Client: muhammad11 Deadline: 2 Day

Finance

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

a. Calculate the indicated ratios for Barry.

b. Construct the DuPont 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 2018. 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, 2018 (in Thousands)

Cash

$ 77,500

Accounts payable

$129,000

Receivables

336,000

Other current liabilities

117,000

Inventories

241,500

Notes payable to bank

84,000

Total current assets

$ 655,000

Total current liabilities

$330,000

Long-term debt

256,500

Net fixed assets

292,500

Common equity (36,100 shares)

361,000

Total assets

$ 947,500

Total liabilities and equity

$947,500

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in Thousands)

Sales

$1,607,500

Cost of goods sold

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

24,500

Earnings before taxes (EBT)

$ 45,500

Federal and state income taxes (40%)

18,200

Net income

$ 27,300

Earnings per share

$ 0.75623

Price per share on December 31, 2018

$ 12.00

Ratio

Barry

Industry Average

Current

___

2.0×

Quick

___

1.3×

Days sales outstanding a

___

35 days

Inventory turnover

___

6.7×

Total assets turnover

___

3.0×

Profit margin

___

1.2%

ROA

___

3.6%

ROE

___

9.0%

ROIC

___

7.5%

TIE

___

3.0×

Debt/Total capital

___

47.0%

M/B

___

4.22

P/E

___

17.86

EV/EBITDA

___

9.14

a Calculation is based on a 365-day year.

4-24 DuPONT ANALYSIS A firm has been experiencing low profitability in recent years. Perform an analysis of the firm’s financial position using the DuPont equation. The firm has no lease payments but has a $2 million sinking fund payment on its debt. The most recent industry average ratios and the firm’s financial statements are as follows:

Industry Average Ratios

Current ratio

Fixed assets turnover

Debt-to-capital ratio

20%

Total assets turnover

Times interest earned

Profit margin

3%

EBITDA coverage

Return on total assets

9%

Inventory turnover

10×

Return on common equity

12.86%

Days sales outstanding a

24 days

Return on invested capital

11.50%

a Calculation is based on a 365-day year.

Balance Sheet as of December 31, 2018 (Millions of Dollars)

Cash and equivalents

$ 78

Accounts payable

$ 45

Accounts receivable

66

Other current liabilities

11

Inventories

159

Notes payable

29

Total current assets

$303

Total current liabilities

$ 85

Long-term debt

50

Total liabilities

$135

Gross fixed assets

225

Common stock

114

Less depreciation

78

Retained earnings

201

Net fixed assets

$147

Total stockholders’ equity

$315

Total assets

$450

Total liabilities and equity

$450

Income Statement for Year Ended December 31, 2018 (Millions of Dollars)

Net sales

$795.0

Cost of goods sold

660.0

Gross profit

$135.0

Selling expenses

73.5

EBITDA

$ 61.5

Depreciation expense

12.0

Earnings before interest and taxes (EBIT)

$ 49.5

Interest expense

4.5

Earnings before taxes (EBT)

$ 45.0

Taxes (40%)

18.0

Net income

$ 27.0

a. Calculate the ratios you think would be useful in this analysis.

b. Construct a DuPont equation, and compare the company’s ratios to the industry average ratios.

c. Do the balance sheet accounts or the income statement figures seem to be primarily responsible for the low profits?

d. Which specific accounts seem to be most out of line relative to other firms in the industry?

e. If the firm had a pronounced seasonal sales pattern or if it grew rapidly during the year, how might that affect the validity of your ratio analysis? How might you correct for such potential problems?

The following will hopefully help you with your Du Ponts:

First , please note that the third and last ratio of the Du Pont equation (p. 124) is Total Assets/Total Common Equity. This ratio is what we refer to as the "Equity Multiplier." People often get confused about the denominator in this ratio. If you look at Table 3-1 on page 68, you will see that Total Common Equity is the TOTAL of the common stock and retained earnings. For the company that number is $940mm. Now, go back to the Du Pont on page 124 and look at the equity multiplier. They use that same $940mm. They do not just use the "common stock" number.

Now, look at problem 4-24 where they use some slightly different wording. It shows that "total stockholder equity" = $315mm. That is your number for the Du Pont. It is a common (no pun intended!) error for learners to think "total common equity" (for the DuPont)? That must mean "Common stock"! They then use only the $114mm instead of the total $315mm and incorrectly calculate the Du Pont.

Second, remember (read page 124) that the Du Pont should calculate the very same number that you derive by calculating the ROE ratio. Du Pont does not give you a different ROE, it helps you understand more about that same number (such as, why is the ratio the way it is). So, if your ROE ratio and your Du Pont are different, you have an error somewhere in either your ratio or your equation.

Third, here is a major hint on how to calculate the industry Du Pont in 4-23(b):

To get the EM for the industry, recognize that ROE/ROA = (NI/E)/(NI/A) = NI/E × A/NI = A/E = Equity multiplier = 2.5.

I hope all this helps!

Thanks

RATIO ANALYSIS

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.

a.

Calculate the indicated ratios for Barry.

b.

Construct the DuPont 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 2018. 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, 2018 (in Thousands)

Cash

$ 77,500

Accounts payable

$129,000

Receivables

336,000

Other current liabilities

117,000

Inventories

241,500

Notes payable to bank

84,000

Total current assets

$ 655,000

Total current liabilities

$330,000

Long

-

term debt

256,500

Net fixed assets

292,500

Common equity (36,100 shares)

361,000

Total assets

$ 947,500

Total liabilities and equity

$947,500

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in

Thousands)

Sales

$1,607,500

Cost of goods sold

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

24,500

Earnings before taxes (EBT)

$ 45,500

Federal and state income taxes (40%)

18,200

Net income

$ 27,300

Earnings per share

$ 0.75623

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

a. Calculate the indicated ratios for Barry.

b. Construct the DuPont 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 2018. 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, 2018 (in Thousands)

Cash $ 77,500 Accounts payable $129,000

Receivables 336,000 Other current liabilities 117,000

Inventories 241,500 Notes payable to bank 84,000

Total current assets $ 655,000 Total current liabilities $330,000

Long-term debt 256,500

Net fixed assets 292,500 Common equity (36,100 shares) 361,000

Total assets $ 947,500 Total liabilities and equity $947,500

Barry Computer Company: Income Statement for Year Ended December 31, 2018 (in

Thousands)

Sales

$1,607,500

Cost of goods sold

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

24,500

Earnings before taxes (EBT)

$ 45,500

Federal and state income taxes (40%)

18,200

Net income

$ 27,300

Earnings per share

$ 0.75623

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Study Master
Quick Mentor
Math Guru
Engineering Exam Guru
Smart Homework Helper
Isabella K.
Writer Writer Name Offer Chat
Study Master

ONLINE

Study Master

I have read and understood all your initial requirements, and I am very professional in this task.

$37 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I have read and understood all your initial requirements, and I am very professional in this task.

$49 Chat With Writer
Math Guru

ONLINE

Math Guru

I will cover all the points which you have mentioned in your project details.

$34 Chat With Writer
Engineering Exam Guru

ONLINE

Engineering Exam Guru

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$38 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I have read and understood all your initial requirements, and I am very professional in this task.

$22 Chat With Writer
Isabella K.

ONLINE

Isabella K.

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$42 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

By products of atp-pc - Hd-48650 digital technician ii - Discussion 6666 - Ps4 error code ws 38220 5 - Research - No wonder they call me a bitch - Country manager simulation toothpaste - Week 7 - Assignment 2: Research Information Systems Project Management - Electric blanket safety bed wetting - Focus Group Assignment (Creative Writing) - Siemens masterdrive parameter list - Casa analysis - Where did christianity originate - The beatles eleanor rigby lyrics meaning - Managerial accounting final exam - Essentials of healthcare finance free pdf - Help me with this - Spelling words for grade 3 - RESEARCH PAPER - Metaphor meanings worksheet answers - Mbo blood pressure monitor instructions - Black ridge generator brg 800 manual - Wk 5 - Signature Assignment: Agencies, Regulations, Technology, and Electronic Health Records - INTERNSHIP - compare and contrast methods for evaluating evidence - What's driving porsche case study - Financial reporting in the catholic church case study - 4000 essential english words - Cross product how to remember - How to find equation of tangent line using implicit differentiation - Utas the george alexander foundation scholarship - Boston university regalia - The last will and testament of rosalind leigh explanation - Metacognitive forum - DISCUSSION POST 6 - Acel leadership capability framework - Marley dry ridge batten section - Barnsley federation of racing pigeons - How do i find out my rms customer number - Chapter 13 leverage and capital structure solutions - Certificate of evidence of resident status - Essay Due - A chart of accounts for a merchandising business - An audience centered approach means - Assignment: Regulation for Nursing Practice Staff Development Meeting - Manifest destiny political cartoon - As nzs 3500 part 3 - Microobservatory image - Res gestae divi augusti - Fairphone case study - IT217: Programming Language - Products such as furniture, audio equipment, bicycles, and clothing are generally classified as: - Andrea bocelli barilla commercial 2010 - Point loma nazarene university essay prompt - Read reason write an argument text and reader 11th edition - A spur gearset has a module of mm - Crash course psychology intelligence - Bottling industry five forces analysis - When was nursing founded - Examples of short stories with conflict and resolution - Fluid overload - Week 2 Discussion - Fetch decode execute cycle steps - Common module human experiences - Do i capitalize after a semicolon - What are the side effects of diabex - All about dental care roxborough - Leader you admire - Consumer behaviour case study questions - Find 3 consecutive even integers - Tina jones cardiovascular subjective data - Uni of greenwich portal - Quality associates inc case problem solution free - A converging lens has a focal length of - Why do microorganisms differ in their response to disinfectants - Business Math (Inventory development plan) - Below is a project wbs with cost apportioned by percents - How similar are the observed phenotypes in each replicate - 1 Question - 1 page in APA 6th Format Operational Excellence - Wireless - Southwest airlines tangible and intangible resources - Amazon route 53 pricing - Question 1 - When the tulip bubble burst ielts - How does the phrase "respect is always due to all creatures" illustrate the indigenous worldview? - Project report on supply chain management of amul - Salts confidence be convex - Asco solenoid valve 8327 catalogue - Particle theory of matter definition - Talley and o'connor neurological examination - Thai tea mix target - Butan 1 ol oxidation - Peking university medical school - What is a2 size in cm - Week 4 HR - How to use a dumpy level - Coulomb's law lab report example - Courage in to kill a mockingbird sparknotes - Why do mergers and acquisitions sometimes fail to produce anticipated results?