Finance ratio paper

profilehannet418
1.LiquidityAnalysisRatios.xlsx
Home>Business & Finance homework help>Financial markets homework help>Finance ratio paper

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