Stock Analysis on Net

Express Scripts Holding Co. (NASDAQ:ESRX)

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

Analysis of Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Express Scripts Holding Co., profitability ratios (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Return on Sales
Gross profit margin 8.81% 8.77% 8.75% 8.76% 8.65% 8.62% 8.63% 8.60% 8.41% 8.33% 8.28% 8.26% 8.08% 7.94% 7.84% 7.86% 7.86% 7.77% 7.78% 7.81%
Operating profit margin 5.27% 5.31% 5.39% 5.49% 5.41% 5.31% 5.19% 5.07% 4.75% 4.51% 4.38% 4.26% 3.99% 3.79% 3.64% 3.57% 3.48% 3.36% 3.36% 3.41%
Net profit margin 4.83% 4.65% 4.59% 4.51% 3.64% 3.50% 3.42% 3.39% 2.70% 2.64% 2.52% 2.43% 2.24% 2.15% 2.08% 1.99% 1.92% 1.76% 1.77% 1.77%
Return on Investment
Return on equity (ROE) 23.82% 24.11% 24.91% 24.93% 22.77% 22.27% 21.51% 20.97% 17.58% 17.41% 17.26% 14.25% 13.81% 13.94% 10.29% 10.01% 9.56% 8.66% 8.23% 8.45%
Return on assets (ROA) 8.84% 8.54% 8.60% 8.33% 7.08% 6.94% 6.71% 6.58% 5.39% 5.27% 5.01% 4.65% 4.39% 4.25% 4.09% 3.73% 3.61% 3.24% 3.41% 3.44%

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

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Express Scripts Holding Co. gross profit margin ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Express Scripts Holding Co. operating profit margin ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Express Scripts Holding Co. net profit margin ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Express Scripts Holding Co. ROE deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
ROA A profitability ratio calculated as net income divided by total assets. Express Scripts Holding Co. ROA deteriorated from Q1 2018 to Q2 2018 but then improved from Q2 2018 to Q3 2018 exceeding Q1 2018 level.

Gross Profit Margin

Express Scripts Holding Co., gross profit margin calculation (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Selected Financial Data (US$ in thousands)
Gross profit 2,351,400 2,204,200 1,879,400 2,490,500 2,237,700 2,161,200 1,872,700 2,338,200 2,274,100 2,161,200 1,847,000 2,263,200 2,173,500 2,131,200 1,834,000 2,094,000 2,073,000 2,007,700 1,750,400 2,061,000 1,994,200 2,115,100 1,962,100
Revenues 25,563,200 25,641,800 24,769,400 25,378,800 24,683,400 25,347,500 24,654,900 24,863,300 25,410,100 25,222,300 24,791,800 26,175,400 25,222,600 25,454,200 24,899,600 26,312,600 25,778,500 25,111,000 23,685,000 25,781,400 25,915,600 26,381,900 26,019,900
Profitability Ratio
Gross profit margin1 8.81% 8.77% 8.75% 8.76% 8.65% 8.62% 8.63% 8.60% 8.41% 8.33% 8.28% 8.26% 8.08% 7.94% 7.84% 7.86% 7.86% 7.77% 7.78% 7.81%
Benchmarks
Gross Profit Margin, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Danaher Corp.
Elevance Health Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

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

1 Q3 2018 Calculation
Gross profit margin = 100 × (Gross profitQ3 2018 + Gross profitQ2 2018 + Gross profitQ1 2018 + Gross profitQ4 2017) ÷ (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017)
= 100 × (2,351,400 + 2,204,200 + 1,879,400 + 2,490,500) ÷ (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800) = 8.81%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Express Scripts Holding Co. gross profit margin ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Operating Profit Margin

Express Scripts Holding Co., operating profit margin calculation (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Selected Financial Data (US$ in thousands)
Operating income 1,488,600 1,312,200 961,600 1,582,400 1,478,400 1,378,600 1,054,600 1,474,700 1,416,000 1,256,300 940,800 1,213,800 1,166,200 1,132,700 826,600 942,800 984,400 966,000 709,200 828,800 875,500 1,004,300 843,100
Revenues 25,563,200 25,641,800 24,769,400 25,378,800 24,683,400 25,347,500 24,654,900 24,863,300 25,410,100 25,222,300 24,791,800 26,175,400 25,222,600 25,454,200 24,899,600 26,312,600 25,778,500 25,111,000 23,685,000 25,781,400 25,915,600 26,381,900 26,019,900
Profitability Ratio
Operating profit margin1 5.27% 5.31% 5.39% 5.49% 5.41% 5.31% 5.19% 5.07% 4.75% 4.51% 4.38% 4.26% 3.99% 3.79% 3.64% 3.57% 3.48% 3.36% 3.36% 3.41%
Benchmarks
Operating Profit Margin, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Danaher Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

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

1 Q3 2018 Calculation
Operating profit margin = 100 × (Operating incomeQ3 2018 + Operating incomeQ2 2018 + Operating incomeQ1 2018 + Operating incomeQ4 2017) ÷ (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017)
= 100 × (1,488,600 + 1,312,200 + 961,600 + 1,582,400) ÷ (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800) = 5.27%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Express Scripts Holding Co. operating profit margin ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Net Profit Margin

Express Scripts Holding Co., net profit margin calculation (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Selected Financial Data (US$ in thousands)
Net income attributable to Express Scripts 1,071,600 877,300 623,200 2,327,600 841,700 801,800 546,300 1,434,700 722,900 720,700 526,100 773,500 661,700 600,100 441,100 581,800 582,300 515,200 328,300 501,900 426,700 543,000 373,000
Revenues 25,563,200 25,641,800 24,769,400 25,378,800 24,683,400 25,347,500 24,654,900 24,863,300 25,410,100 25,222,300 24,791,800 26,175,400 25,222,600 25,454,200 24,899,600 26,312,600 25,778,500 25,111,000 23,685,000 25,781,400 25,915,600 26,381,900 26,019,900
Profitability Ratio
Net profit margin1 4.83% 4.65% 4.59% 4.51% 3.64% 3.50% 3.42% 3.39% 2.70% 2.64% 2.52% 2.43% 2.24% 2.15% 2.08% 1.99% 1.92% 1.76% 1.77% 1.77%
Benchmarks
Net Profit Margin, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Danaher Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

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

1 Q3 2018 Calculation
Net profit margin = 100 × (Net income attributable to Express ScriptsQ3 2018 + Net income attributable to Express ScriptsQ2 2018 + Net income attributable to Express ScriptsQ1 2018 + Net income attributable to Express ScriptsQ4 2017) ÷ (RevenuesQ3 2018 + RevenuesQ2 2018 + RevenuesQ1 2018 + RevenuesQ4 2017)
= 100 × (1,071,600 + 877,300 + 623,200 + 2,327,600) ÷ (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800) = 4.83%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Express Scripts Holding Co. net profit margin ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Return on Equity (ROE)

Express Scripts Holding Co., ROE calculation (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Selected Financial Data (US$ in thousands)
Net income attributable to Express Scripts 1,071,600 877,300 623,200 2,327,600 841,700 801,800 546,300 1,434,700 722,900 720,700 526,100 773,500 661,700 600,100 441,100 581,800 582,300 515,200 328,300 501,900 426,700 543,000 373,000
Total Express Scripts stockholders’ equity 20,565,900 19,370,000 18,442,500 18,119,600 15,916,500 15,744,600 15,922,600 16,236,000 15,600,300 15,403,100 14,841,100 17,372,800 16,538,300 15,822,200 20,604,800 20,054,200 20,157,700 20,451,900 21,874,300 21,837,400 23,702,300 23,866,500 23,617,800
Profitability Ratio
ROE1 23.82% 24.11% 24.91% 24.93% 22.77% 22.27% 21.51% 20.97% 17.58% 17.41% 17.26% 14.25% 13.81% 13.94% 10.29% 10.01% 9.56% 8.66% 8.23% 8.45%
Benchmarks
ROE, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Danaher Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

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

1 Q3 2018 Calculation
ROE = 100 × (Net income attributable to Express ScriptsQ3 2018 + Net income attributable to Express ScriptsQ2 2018 + Net income attributable to Express ScriptsQ1 2018 + Net income attributable to Express ScriptsQ4 2017) ÷ Total Express Scripts stockholders’ equity
= 100 × (1,071,600 + 877,300 + 623,200 + 2,327,600) ÷ 20,565,900 = 23.82%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Express Scripts Holding Co. ROE deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Return on Assets (ROA)

Express Scripts Holding Co., ROA calculation (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 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
Selected Financial Data (US$ in thousands)
Net income attributable to Express Scripts 1,071,600 877,300 623,200 2,327,600 841,700 801,800 546,300 1,434,700 722,900 720,700 526,100 773,500 661,700 600,100 441,100 581,800 582,300 515,200 328,300 501,900 426,700 543,000 373,000
Total assets 55,441,600 54,677,800 53,405,600 54,255,800 51,206,200 50,513,400 51,056,000 51,744,900 50,909,300 50,858,600 51,107,600 53,243,300 51,996,500 51,867,800 51,905,100 53,798,900 53,439,200 54,633,800 52,747,100 53,548,200 54,763,000 54,581,500 55,585,700
Profitability Ratio
ROA1 8.84% 8.54% 8.60% 8.33% 7.08% 6.94% 6.71% 6.58% 5.39% 5.27% 5.01% 4.65% 4.39% 4.25% 4.09% 3.73% 3.61% 3.24% 3.41% 3.44%
Benchmarks
ROA, Competitors2
Abbott Laboratories
Cigna Group
CVS Health Corp.
Danaher Corp.
Elevance Health Inc.
Humana Inc.
Intuitive Surgical Inc.
Medtronic PLC
UnitedHealth Group Inc.

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

1 Q3 2018 Calculation
ROA = 100 × (Net income attributable to Express ScriptsQ3 2018 + Net income attributable to Express ScriptsQ2 2018 + Net income attributable to Express ScriptsQ1 2018 + Net income attributable to Express ScriptsQ4 2017) ÷ Total assets
= 100 × (1,071,600 + 877,300 + 623,200 + 2,327,600) ÷ 55,441,600 = 8.84%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Express Scripts Holding Co. ROA deteriorated from Q1 2018 to Q2 2018 but then improved from Q2 2018 to Q3 2018 exceeding Q1 2018 level.