Loading...

Finance ratio paper


Open Posted By: nikiedward Date: 25/08/2020 Academic Level: High School Paper Type: Report Writing

The ratios are calculated, as these Excels below

Revising my report of the ratios as what the picture says. (Actually only revising is not enough, its a lot work)



requirement:

Your analysis should include a review of the most interesting ratios, decribe the changes over time as well as a comparison with competitors. Provide an interpretaton of the calculated ratios. what are the conclusions of your analysis?


Category: Accounting & Finance Subjects: Finance Deadline: 24 Hours Budget: $60 - $90 Pages: 2-3 Pages (Short Assignment)

Attachment 1

1

Analyzing the Financial Health of 3M Company

There are several relevant economic theories that can be used to better understand what has helped transform 3M Company into a successful multibillion dollar business, one of which is demand-side economics. This is a theory that argues that economic growth is best created by a high demand for products and services. In the case of 3M, the company has experienced significant growth since it was founded 115 years ago because of the existing demand for its products. If there were no demand for items like abrasives, adhesives, laminates, fire protection, and so on, then there would be no macroeconomic growth. If there were no macroeconomic growth, then there would be little microeconomic growth either, and 3M would suffer as a result of there being little demand for its products.

To analyze the company’s financial figures, I first needed to access the raw annual data that was provided through the company’s income statements. I did this by using the website Stock Analysis on Net, which provides annual data for the past five years. I was able to then export this data to Excel and calculate the different margins and ratios using a variety of formulas that interacted with the data. Having this raw data in Excel form made it easy to create the necessary formulas and then apply them to each year because I could simply calculate a ratio once and then apply the formula to the remaining years in the income statement.

I was able to determine the adjusted current ratio by dividing the adjusted current assets by the adjusted current liabilities. This figure is similar to the quick ratio in the sense that assets are being compared to liabilities and a higher ratio is going to indicate the company is in a better position. From 2008 to 2017, 3M company had an adjusted current ratio that ranged from 1.54 to 2.25. Its peak ratio of 2.25 was achieved during 2011 when it had $12.240 billion in adjusted current assets and $5.441 billion in adjusted current liabilities.

To find the quick ratio, I divided the total quick assets by the current liabilities. From 2010 to 2017, 3M Company had a quick ratio of 0.85 to 1.39 with the quick ratio being at a low point in 2015 and a high point in 2011 and 2012. The quick ratio can be used to measure how well a company can fulfill its short-term financial liabilities, so a larger quick ratio is better. If the quick ratio is under 1.0, this indicates the company has more current liabilities than quick assets. This was the case in 2015 when the company had $6.070 billion in assets and $7.118 in liabilities giving it a quick ratio of 0.85. The low point was a result of the company having a smaller than usual amount of cash and cash equivalents and marketable securities with $1.798 billion in cash and $118 million in securities.

In terms of working capital turnover ratio, I was able to find this figure by dividing the net sales by working capital. From 2011 to 2017, 3M Company had a working capital turnover ratio between 4.02 and 7.83, with 2015 being the peak year and 2012 seeing the smallest ratio. The point of the working capital turnover ratio is to determine how effective a company is at using its working capital, so the higher this ratio is, the better. It seems that 2015 was a particularly good year for 3M because they were able to raise $30.274 billion in net sales with just $3.868 billion in working capital.

Next, I was able to calculate ROA by dividing the net working capital by total assets. From 2011 to 2017, 3M Company had an ROA that ranged from 13.57% to 15.35%. These higher percentages are better because they indicate that the company was able to get a higher return on its assets by achieving a higher net income. Additionally, I was able to calculate adjusted ROA by adding by interest expense adjusted for tax effects to net income. This resulted in slightly different ROA percentages, but only by a few tenths of a percent. Then, I calculated ROE by dividing net income by the average stockholders’ equity. I also calculated adjusted ROE by taking deferred taxes into account. This resulted in ROE figures ranging from 26.94% to 47.49% for ROE and 25.29% to 49.04% for adjusted ROE. Since 3M would benefit from having a higher return on equity, it wants to do everything in its power to get this figure as close to 100% as possible.

As for net profit margin and adjusted net profit margin, I was able to calculate this figure by dividing net income by sales and then factoring in adjustments due to deferred taxes. For the original net profit margin, 3M Company had percentages ranging from 13.57% to 15.35% and then 14.46% to 16.76% for adjusted net profit margin. Higher net profit margins are going to be better because they indicate that there is more revenue left over after expenses have been deducted out of sales. If a company’s net profit margins are below 0%, this indicates they are not profitable. What is good is that 3M Company has never slipped below double-digit net profit margin percentages and has been consistent in bringing in billions of dollars of profits.

Other items I analyzed include activity analysis ratios, capital structure analysis ratios, and capital market analysis ratios. For instance, I calculated total asset turnover and adjusted total asset turnover by dividing sales by average total assets. Inventory turnover ratios were also calculated by dividing the cost of goods sold by the average inventories. The same was done through account receivables turnover ratios by dividing sales by the average accounts receivable. I found interest coverage by dividing income before interest and income tax by interest expense. I then calculated the debt to capital ratios by dividing total liabilities by total stockholders’ equity. Finally, I found the P/E ratio by dividing the market price of common stock per share by the earnings per share. The dividend payout ratio was calculated by dividing cash dividends by net income.

Another business whose data can be compared to 3M’s is Honeywell International Inc. Honeywell is another multinational conglomerate that specializes in engineering and manufacturing consumer products. With a revenue of over $40 billion as of 2017 and an operating income of $6.9 billion, Honeywell is somewhat larger than 3M and also has around 30,000 more employees. Some of the key ratios for Honeywell include its operating margin of 17.64, net margin of 4.08, asset turnover ratio of 0.71, return on assets percentage of 2.92, return on equity percentage of 9.03, and return on invested capital percentage of 4.99. Each of these figures comes from 2017, and it seems that 2017 was a bit of an unusual year for Honeywell because prior years saw its ratios as much higher with an ROE of 25.54% in 2016 and an ROA of 9.30% in 2016. So in 2017 alone, 3M seems to have come out ahead due to its healthier ratios, but on a long-term basis, Honeywell is the more financially sound company.

These findings are important because they help to reveal important financial figures about 3M Company that are relevant to investors and potential business partners. Without analyzing a company’s financial figures, it would be impossible to determine the financial health of the company and make accurate predictions about the company’s projected path. There is no single data point that rises above the rest in terms of importance either. Instead, investors and those willing to provide financial services to 3M Company need to examine every bit of information to get a clearer picture on the overall health of the company. This is why it is crucial to take the raw data from the company’s financial reports and analyze it by putting it into ratios and margins to get a better understanding of the company’s financial status.

Attachment 2

Adjusted Current Ratio

3M Co., Adjusted Current Ratio
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 30, 2010 Dec 30, 2009 Dec 30, 2008
As Reported
Current assets (USD $ in millions) 14,277 11,726 10,986 11,765 12,733 13,640 12,240 12,215 10,795 9,598
Current liabilities (USD $ in millions) 7,687 6,219 7,118 5,998 7,498 6,200 5,441 6,089 4,897 5,839
Current ratio 1.86 1.89 1.54 2.06 1.70 2.20 2.25 2.01 2.20 1.64
Adjusted for Deferred Taxes
Adjusted current assets (USD $ in millions) 14,277 11,726 10,986 11,765 12,733 13,640 12,240 12,215 10,795 9,598
Adjusted current liabilities (USD $ in millions) 7,687 6,219 7,118 5,998 7,498 6,200 5,441 6,089 4,897 5,839
Adjusted current ratio 1.86 1.89 1.54 1.96 1.70 2.20 2.25 2.01 2.20 1.64

Quick Ratio

3M Co., Quick Ratio
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010 Dec 31, 2009 Dec 31, 2008
Selected Financial Data (USD $ in millions)
Cash and cash equivalents 3,053 2,398 1,798 1,897 2,581 2,883 2,219 3,377 3,040 1,849
Marketable securities, current 1,076 280 118 1,439 756 1,648 1,461 1,101 744 373
Accounts receivable, net of allowances 4,911 4,392 4,154 4,238 4,253 4,061 3,867 3,615 3,250 3,195
Total quick assets 9,040 7,070 6,070 7,574 7,590 8,592 7,547 8,093 7,034 5,417
Current liabilities 7,687 6,219 7,118 5,964 7,498 6,200 5,441 6,089 4,897 5,839
Ratio
Quick ratio 1.18 1.14 0.85 1.27 1.01 1.39 1.39 1.33 1.44 0.93
Quick ratio = Total quick assets ÷ Current liabilities
= 9,040 ÷ 7,687 = 1.18

Working Capital Turnover

3M Co., Working Capital Turnover
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $ in millions)
Current assets 14,277 11,726 10,986 12,303 12,733 13,630 12,240
Less: Current liabilities 7,687 6,219 7,118 5,964 7,498 6,200 5,441
Working capital 6,590 5,507 3,868 6,339 5,235 7,430 6,799
Net sales 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Ratio
Working capital turnover 4.80 5.47 7.83 5.02 5.90 4.02 4.36

Attachment 3

Adjusted Total Asset Turnover

3M Co., Adjusted Total Asset Turnover
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010 Dec 31, 2009 Dec 31, 2008
As Reported
Net sales (USD $ in millions) 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Total assets (USD $ in millions) 37,987 32,906 32,718 31,269 33,550 33,876 31,616
Total asset turnover 0.90 1.00 0.98 0.98 0.85 0.91 0.92
Adjusted for Deferred Taxes
Net sales (USD $ in millions) 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Adjusted total assets (USD $ in millions) 37,476 32,484 32,208 29,936 32,688 33,876 31,616
Adjusted total asset turnover 0.84 0.93 0.94 1.06 0.94 0.88 0.94

Inventory Turnover ratio

3M Co., Inventory Turnover
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $ in millions)
Cost of sales 16,001 15,040 15,343 16,447 16,106 15,685 15,693
Inventories 4,034 3,385 3,518 3,706 3,864 3,837 3,416
Ratio
Inventory turnover 3.97 4.44 4.36 4.44 4.17 4.09 4.59
Inventory turnover = Cost of sales ÷ Inventories
= 16,001 ÷ 4,034 = 3.97

Account Receivables Turnover

3M Co., Receivables Turnover
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $ in millions)
Net sales 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Accounts receivable, net of allowances 4,911 4,392 4,154 4,238 4,253 4,061 3,867
Ratio
Receivables turnover 6.45 6.86 7.29 7.51 7.26 7.36 7.66
Receivables turnover = Net sales ÷ Accounts receivable, net of allowances
= 31,657 ÷ 4,911 = 6.45

Attachment 4

Return on Assets

3M Co., Adjusted Return on Assets (ROA)
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Net income attributable to 3M (USD $ in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Total assets (USD $ in millions) 37,987 32,906 32,883 31,209 33,550 33,876 31,616
ROA 13.71% 15.35% 15.08% 15.31% 13.82% 13.57% 13.87%
Adjusted for Deferred Taxes
Net income attributable to 3M (USD $ in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Total assets (USD $ in millions) 37,987 32,906 32,883 31,209 33,550 33,876 31,616
Adjusted ROA 12.79% 15.35% 14.70% 15.88% 13.89% 13.12% 13.55%

Return on Equity

3M Co., Adjusted Return on Equity (ROE)
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
As Reported
Net income attributable to 3M (USD $ in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Total 3M Company shareholders' equity (USD $ in millions) 11,563 10,298 11,429 13,109 17,502 17,575 15,420
ROE 46.49% 39.39% 32.38% 26.56% 26.94% 27.56% 28.74%
Adjusted for Deferred Taxes
Adjusted net income attributable to 3M (USD $ in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Adjusted total 3M Company shareholders' equity (USD $ in millions) 11,563 10,298 11,429 13,109 17,502 17,575 15,420
Adjusted ROE 42.01% 49.04% 42.29% 37.81% 26.62% 25.29% 27.78%

Net Profit Margin

3M Co., Adjusted Net Profit Margin
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011 Dec 31, 2010 Dec 31, 2009
As Reported
Net income attributable to 3M (USD $ in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283 4,085 3,193
Net sales (USD $ in millions) 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Net profit margin 13.71% 15.35% 15.08% 15.31% 13.82% 13.57% 13.87%
Adjusted for Deferred Taxes
Adjusted net income attributable to 3M (USD $ in millions) 5,111 5,045 4,810 4,765 4,560 4,444 4,283 4,085 3,193
Net sales (USD $ in millions) 31,657 30,109 30,274 31,821 30,871 29,904 29,611
Adjusted net profit margin 16.14% 16.76% 15.89% 14.97% 14.77% 14.86% 14.46%

Attachment 5

PE & EPS

3M Co., Price to Earnings (P/E)
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
No. shares of common stock outstanding 595 597 609 635 663 687 695
Selected Financial Data (USD $)
Net income attributable to 3M (in millions) 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Earnings per share (EPS) 8.1660783325 8.4632143456 7.9320531758 7.8034955125 7.0239710538 6.4677630621 6.1625899281
Share price 222.89 178.18 150.67 165.91 130.14 102.78 87.65
Ratio
P/E ratio 27.29 21.05 19.00 21.26 18.53 15.89 14.22

Dividend Payout Ratio

3M Co., Dividend Payout Ratio
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $)
Total Cash Common Dividends 2,803 2,678 2,565 2,220 1,732 1,638 1,559
Net Income 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Dividend Payout Ratio 0.58 0.53 0.53 0.45 0.37 0.37 0.36

ROA

3M Co., Dividend Payout Ratio
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $)
Profit Margin 16.14% 16.76% 15.89% 14.97% 14.77% 14.86% 14.46%
Assets Turnover Ratio 0.84 0.93 0.94 1.06 0.94 0.88 0.94
ROA 0.14 0.16 0.15 0.16 0.14 0.13 0.14
ROA = Profit Margin * Assets Turnover Ratio

Attachment 6

Interest Coverage

3M Co., Interest Coverage
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $ in millions)
Net income attributable to 3M 4,858 5,050 4,833 4,956 4,659 4,444 4,283
Add: Net income attributable to noncontrolling interest 11 8 8 42 62 67 74
Add: Income tax expense 2,679 1,995 1,982 2,028 1,841 1,840 1,674
Add: Interest expense 322 199 149 142 145 171 186
Earnings before interest and tax (EBIT) 7,870 7,252 6,972 7,168 6,707 6,522 6,217
Ratio
Interest coverage 24.44 36.44 46.79 50.48 46.26 38.14 33.42
Interest coverage = EBIT ÷ Interest expense = 7,870 ÷ 322 = 24.44

Debt to Capital

3M Co., Debt to Capital
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (USD $ in millions)
Short-term borrowings and current portion of long-term debt 1,853 972 2,044 106 1,683 1,085 682
Long-term debt, excluding current portion 12,096 10,678 8,753 6,705 4,326 4,916 4,484
Capital lease obligations 60 45 46 59 58 58 58
Total debt 14,009 11,695 10,843 6,870 6,067 6,059 5,224
Total 3M Company shareholders' equity 11,563 10,298 11,708 13,109 17,502 17,502 17,502
Total capital 25,572 21,993 22,551 19,979 23,569 23,561 22,726
Ratio
Debt to capital 0.55 0.53 0.48 0.34 0.26 0.26 0.23
Debt to capital = Total debt ÷ Total capital = 14,009 ÷ 25,572 = 0.55