Stock Analysis on Net

McKesson Corp. (NYSE:MCK)

This company has been moved to the archive! The financial data has not been updated since October 27, 2016.

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

McKesson Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011 Dec 31, 2010 Sep 30, 2010 Jun 30, 2010
Net fixed asset turnover 84.46 79.45 83.79 89.55 89.05 87.20 87.55 79.90 73.64 67.40 61.93 95.72 94.19 92.92 92.70 99.06 100.72 101.19 117.67 118.12 116.60 116.01 113.10
Total asset turnover 3.33 3.33 3.37 3.43 3.36 3.27 3.32 3.13 3.06 2.81 2.66 3.57 3.53 3.49 3.52 3.69 3.74 3.89 3.71 3.62 3.68 3.70 3.63
Equity turnover 20.56 20.87 21.39 21.31 21.36 20.68 22.38 18.96 17.92 16.58 16.15 16.21 15.89 16.72 17.32 16.15 15.97 17.15 17.97 16.08 16.48 16.57 15.52

Based on: 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-K (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-K (reporting date: 2015-03-31), 10-Q (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-K (reporting date: 2014-03-31), 10-Q (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-K (reporting date: 2013-03-31), 10-Q (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-K (reporting date: 2012-03-31), 10-Q (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-K (reporting date: 2011-03-31), 10-Q (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. McKesson Corp. net fixed asset turnover ratio deteriorated from Q4 2016 to Q1 2017 but then improved from Q1 2017 to Q2 2017 exceeding Q4 2016 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. McKesson Corp. total asset turnover ratio deteriorated from Q4 2016 to Q1 2017 and from Q1 2017 to Q2 2017.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. McKesson Corp. equity turnover ratio deteriorated from Q4 2016 to Q1 2017 and from Q1 2017 to Q2 2017.

Net Fixed Asset Turnover

McKesson Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011 Dec 31, 2010 Sep 30, 2010 Jun 30, 2010
Selected Financial Data (US$ in millions)
Revenues 49,957 49,733 46,678 47,899 48,761 47,546 44,925 46,484 44,160 43,476 38,141 34,306 32,954 32,208 30,620 31,187 29,850 30,798 31,699 30,839 30,216 29,980 28,853 28,247 27,534 27,450
Property, plant and equipment, net 2,300 2,430 2,278 2,112 2,108 2,100 2,045 2,156 2,174 2,209 2,222 1,359 1,348 1,333 1,321 1,247 1,223 1,221 1,043 1,015 1,006 988 991 934 860 864
Long-term Activity Ratio
Net fixed asset turnover1 84.46 79.45 83.79 89.55 89.05 87.20 87.55 79.90 73.64 67.40 61.93 95.72 94.19 92.92 92.70 99.06 100.72 101.19 117.67 118.12 116.60 116.01 113.10
Benchmarks
Net Fixed Asset Turnover, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-K (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-K (reporting date: 2015-03-31), 10-Q (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-K (reporting date: 2014-03-31), 10-Q (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-K (reporting date: 2013-03-31), 10-Q (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-K (reporting date: 2012-03-31), 10-Q (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-K (reporting date: 2011-03-31), 10-Q (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30).

1 Q2 2017 Calculation
Net fixed asset turnover = (RevenuesQ2 2017 + RevenuesQ1 2017 + RevenuesQ4 2016 + RevenuesQ3 2016) ÷ Property, plant and equipment, net
= (49,957 + 49,733 + 46,678 + 47,899) ÷ 2,300 = 84.46

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. McKesson Corp. net fixed asset turnover ratio deteriorated from Q4 2016 to Q1 2017 but then improved from Q1 2017 to Q2 2017 exceeding Q4 2016 level.

Total Asset Turnover

McKesson Corp., total asset turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011 Dec 31, 2010 Sep 30, 2010 Jun 30, 2010
Selected Financial Data (US$ in millions)
Revenues 49,957 49,733 46,678 47,899 48,761 47,546 44,925 46,484 44,160 43,476 38,141 34,306 32,954 32,208 30,620 31,187 29,850 30,798 31,699 30,839 30,216 29,980 28,853 28,247 27,534 27,450
Total assets 58,315 57,904 56,563 55,087 55,819 55,925 53,870 55,110 52,232 53,006 51,759 36,479 35,947 35,491 34,786 33,433 32,968 31,748 33,093 33,157 31,907 31,017 30,886 30,396 26,792 27,399
Long-term Activity Ratio
Total asset turnover1 3.33 3.33 3.37 3.43 3.36 3.27 3.32 3.13 3.06 2.81 2.66 3.57 3.53 3.49 3.52 3.69 3.74 3.89 3.71 3.62 3.68 3.70 3.63
Benchmarks
Total Asset Turnover, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-K (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-K (reporting date: 2015-03-31), 10-Q (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-K (reporting date: 2014-03-31), 10-Q (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-K (reporting date: 2013-03-31), 10-Q (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-K (reporting date: 2012-03-31), 10-Q (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-K (reporting date: 2011-03-31), 10-Q (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30).

1 Q2 2017 Calculation
Total asset turnover = (RevenuesQ2 2017 + RevenuesQ1 2017 + RevenuesQ4 2016 + RevenuesQ3 2016) ÷ Total assets
= (49,957 + 49,733 + 46,678 + 47,899) ÷ 58,315 = 3.33

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. McKesson Corp. total asset turnover ratio deteriorated from Q4 2016 to Q1 2017 and from Q1 2017 to Q2 2017.

Equity Turnover

McKesson Corp., equity turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013 Dec 31, 2012 Sep 30, 2012 Jun 30, 2012 Mar 31, 2012 Dec 31, 2011 Sep 30, 2011 Jun 30, 2011 Mar 31, 2011 Dec 31, 2010 Sep 30, 2010 Jun 30, 2010
Selected Financial Data (US$ in millions)
Revenues 49,957 49,733 46,678 47,899 48,761 47,546 44,925 46,484 44,160 43,476 38,141 34,306 32,954 32,208 30,620 31,187 29,850 30,798 31,699 30,839 30,216 29,980 28,853 28,247 27,534 27,450
Total McKesson Corporation stockholders’ equity 9,449 9,249 8,924 8,876 8,788 8,853 8,001 9,084 8,931 8,979 8,522 8,027 7,989 7,408 7,070 7,649 7,715 7,203 6,831 7,456 7,116 6,917 7,220 7,080 6,815 6,879
Long-term Activity Ratio
Equity turnover1 20.56 20.87 21.39 21.31 21.36 20.68 22.38 18.96 17.92 16.58 16.15 16.21 15.89 16.72 17.32 16.15 15.97 17.15 17.97 16.08 16.48 16.57 15.52
Benchmarks
Equity Turnover, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

Based on: 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-K (reporting date: 2016-03-31), 10-Q (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-K (reporting date: 2015-03-31), 10-Q (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-K (reporting date: 2014-03-31), 10-Q (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-K (reporting date: 2013-03-31), 10-Q (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-K (reporting date: 2012-03-31), 10-Q (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-K (reporting date: 2011-03-31), 10-Q (reporting date: 2010-12-31), 10-Q (reporting date: 2010-09-30), 10-Q (reporting date: 2010-06-30).

1 Q2 2017 Calculation
Equity turnover = (RevenuesQ2 2017 + RevenuesQ1 2017 + RevenuesQ4 2016 + RevenuesQ3 2016) ÷ Total McKesson Corporation stockholders’ equity
= (49,957 + 49,733 + 46,678 + 47,899) ÷ 9,449 = 20.56

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. McKesson Corp. equity turnover ratio deteriorated from Q4 2016 to Q1 2017 and from Q1 2017 to Q2 2017.