Share
Explore BrainMass

Compare 9 Financial Ratios: 3M, Alcoa, Coca-Cola, Abbott Labs

Go to the Yahoo! Finance Web site.

Review the overview/main pages for the four public companies:

3M
Alcoa
Coca-Cola
Abbott Labs

Research the the four firms using either Key Statistics or Financials from the overview/main pages for the stocks onYahoo! Finance Web site. Compute and compare the following financial ratios for the four firms for their most recent fiscal years:

Current Ratio (X)
Sales/Total Assets (percent) or Total asset turnover
Times interest earned (X)
Total Debt/Equity (percent)
Net Income / Net Sales (percent) or Return on Sales (ROS)
Net Income / Total Assets (percent) or Return on Assets (ROA)
Net Income / Common Equity (percent) or Return on Equity (ROE)
P/E or P/E Ratio (X)
Market to Book Value Ratio (X)

Note: In Key Statistics under the heading 'Valuation Measures� there are numbers for both Trailing P/E ratios and Forward P/E ratios. Most commonly, in calculating both ratios the corporation's current stock price is divided by its earnings per share (EPS). The difference is that Trailing P/E ratios use reported EPS for the past year, specifically the past/trailing 12 months (ttm), and Forward P/E ratios use estimated EPS for the upcoming 4 quarters. Also, in interpreting some of the other statistics provided, please note that 'yoy' is an acronym for 'year-on-year' and 'mrq' is an acronym for 'most recent quarter.'

Write a paper responding to the following questions based on your research:

Compare the 9 financial ratios listed above for the four companies. It is recommended that you use a spreadsheet to demonstrate your comparison. Insert the table into your Word document and respond to the following questions:

How would you rank the four firms in terms of financial performance?
Why might their financial performances differ?
What economic or market factors might account for big differences in P/E ratios?
Select ONE of the companies and examine the trend in the ratios for the past three years. Respond to the following question:
Is the firm's performance improving, declining, stable, or is something strange going on? (Please note that you should use these ratios and their trends to assist you in responding to the action items below.)

Continue your research on the company you selected in the previous action item.
At the Yahoo! Finance main page for your company select Competitors under the heading "Company." In the table entitled 'Direct Competitor Comparison' you'll see several key financial line items for the firm along with those for select competitors and the industry as a whole.

Scroll down to see individual competitors ranked by sales with links in the column entitled â??Symbolâ? to each of their own main pages.

Write an analysis of the performance of the company you selected above. Your analysis is to include the information you gained from your research (above) and your responses to the following:

Who are the firm's competitors? Does the selection of competitors make sense to you?
How is your selected company performing against its competition? (Don't just say better or worse on particular ratios; try to think of and offer reasons why).

Solution Preview

Please see the attached file(s) for the complete tutorial.

Financial Ratios 3M Alcoa Coca-Cola Abbott Labs
Current Ratio 2.01 1.31 1.17 1.29
Sales/Total Assets (percent) or Total asset turnover 88% 53% 48% 59%
Times interest earned 29.68 2.11 20.43 11.31
Total Debt/Equity (percent) 93% 189% 135% 166%
Net Income / Net Sales (percent) or Return on Sales (ROS) 15% 1% 34% 1%
Net Income / Total Assets (percent) or Return on Assets (ROA) 14% 1% 16% 1%
Net Income / Common Equity (percent) or Return on Equity (ROE) 26% 2% 38% 2%
P/E or P/E Ratio 16.03 22.98 12.82 17.96
Market to Book Value Ratio 424 1293 491 4

Based on the 9 financial ratios listed above for the 4 companies, the Coca Cola performed the best in terms of financial ...

Solution Summary

The expert discusses and compares nine financial ratios for 3M, Alcoa, Coca-Cola and Abbott Labs. The key statistics of financials are examined.

$2.19