Sign in

Paying users zone. Data is covered by hidden .

Get to Express Scripts Holding Co. for $13.99, or
get to entire website for at least 3 months from $49.99.

Visa

Mastercard

Maestro

American Express

Discover

JCB

PayPal

This company is transferred to the archive: financial data is no longer updated!

Microsoft Excel

LibreOffice Calc

Express Scripts Holding Co. (ESRX)

DuPont Analysis: Decomposition of ROE
Quarterly Data

Difficulty: Beginner

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE
Three-Component Disaggregation of ROE
Five-Component Disaggregation of ROE
Two-Way Decomposition of ROA
Four-Way Decomposition of ROA
Decomposition of Net Profit Margin

Two-Component Disaggregation of ROE

Express Scripts Holding Co., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	ROA	×	Leverage

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the decrease in Return on Equity (ROE) over Q3 2018 is the decrease in Financial Leverage.

Three-Component Disaggregation of ROE

Express Scripts Holding Co., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	Net Profit Margin	×	Asset Turnover	×	Leverage

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the decrease in Return on Equity (ROE) over Q3 2018 is the decrease in Financial Leverage.

Five-Component Disaggregation of ROE

Express Scripts Holding Co., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	Tax Burden	×	Interest Burden	×	EBIT Margin	×	Asset Turnover	×	Leverage

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the decrease in Return on Equity (ROE) over Q3 2018 is the decrease in Financial Leverage.

Two-Way Decomposition of ROA

Express Scripts Holding Co., decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Net Profit Margin	×	Asset Turnover

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the increase in Return on Assets (ROA) over Q3 2018 is the increase in profitability measured by Net Profit Margin.

Four-Way Decomposition of ROA

Express Scripts Holding Co., decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Tax Burden	×	Interest Burden	×	EBIT Margin	×	Asset Turnover

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the increase in Return on Assets (ROA) over Q3 2018 is the increase in effect of taxes measured by Tax Burden.

Decomposition of Net Profit Margin

Express Scripts Holding Co., decomposition of Net Profit Margin (quarterly data)

Microsoft Excel

LibreOffice Calc

	Net Profit Margin	=	Tax Burden	×	Interest Burden	×	EBIT Margin

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

Based on: 10-Q (filing date: 2018-10-31), 10-Q (filing date: 2018-08-01), 10-Q (filing date: 2018-05-02), 10-K (filing date: 2018-02-27), 10-Q (filing date: 2017-10-24), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-04-24), 10-K (filing date: 2017-02-14), 10-Q (filing date: 2016-10-25), 10-Q (filing date: 2016-07-25), 10-Q (filing date: 2016-04-25), 10-K (filing date: 2016-02-16), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-28), 10-Q (filing date: 2015-04-28), 10-K (filing date: 2015-02-23), 10-Q (filing date: 2014-10-28), 10-Q (filing date: 2014-07-29), 10-Q (filing date: 2014-04-29), 10-K (filing date: 2014-02-20), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-29), 10-Q (filing date: 2013-04-29).

The primary reason for the increase in Net Profit Margin over Q3 2018 is the increase in effect of taxes measured by Tax Burden.

	Express Scripts Holding Co.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Price of access to Express Scripts Holding Co.^*

1 month

$13.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

American Express

Discover

JCB

PayPal

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

Prices of access to the entire website^*

3 months

$49.99

6 months

12% off

~~$99.98~~

$87.49

9 months

25% off

~~$149.97~~

$112.49

12 months

37% off

~~$199.96~~

$124.99

* You can pay in USD, CHF, GBP or EUR.

Visa

Mastercard

Maestro

American Express

Discover

JCB

PayPal