Stock Analysis on Net

Express Scripts Holding Co. (NASDAQ:ESRX)

$22.49

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

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Express Scripts Holding Co., profit margin by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin PBM PBM segment profit margin ratio improved from 2015 to 2016 and from 2016 to 2017.
Other Business Operations Other Business Operations segment profit margin ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.

Segment Profit Margin: PBM

Express Scripts Holding Co.; PBM; segment profit margin calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Operating income
Revenues
Segment Profitability Ratio
Segment profit margin1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment profit margin = 100 × Operating income ÷ Revenues
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment profit margin PBM PBM segment profit margin ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Profit Margin: Other Business Operations

Express Scripts Holding Co.; Other Business Operations; segment profit margin calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Operating income
Revenues
Segment Profitability Ratio
Segment profit margin1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment profit margin = 100 × Operating income ÷ Revenues
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment profit margin Other Business Operations Other Business Operations segment profit margin ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.

Segment Return on Assets (Segment ROA)

Express Scripts Holding Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA PBM PBM segment ROA improved from 2015 to 2016 and from 2016 to 2017.
Other Business Operations Other Business Operations segment ROA deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment ROA: PBM

Express Scripts Holding Co.; PBM; segment ROA calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Operating income
Total assets
Segment Profitability Ratio
Segment ROA1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment ROA = 100 × Operating income ÷ Total assets
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment ROA PBM PBM segment ROA improved from 2015 to 2016 and from 2016 to 2017.

Segment ROA: Other Business Operations

Express Scripts Holding Co.; Other Business Operations; segment ROA calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Operating income
Total assets
Segment Profitability Ratio
Segment ROA1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment ROA = 100 × Operating income ÷ Total assets
= 100 × ÷ =

Segment profitability ratio Reportable segment The company
Segment ROA Other Business Operations Other Business Operations segment ROA deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment Asset Turnover

Express Scripts Holding Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover PBM PBM segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.
Other Business Operations Other Business Operations segment asset turnover ratio improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Segment Asset Turnover: PBM

Express Scripts Holding Co.; PBM; segment asset turnover calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Revenues
Total assets
Segment Activity Ratio
Segment asset turnover1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment asset turnover = Revenues ÷ Total assets
= ÷ =

Segment activity ratio Reportable segment The company
Segment asset turnover PBM PBM segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Asset Turnover: Other Business Operations

Express Scripts Holding Co.; Other Business Operations; segment asset turnover calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Revenues
Total assets
Segment Activity Ratio
Segment asset turnover1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment asset turnover = Revenues ÷ Total assets
= ÷ =

Segment activity ratio Reportable segment The company
Segment asset turnover Other Business Operations Other Business Operations segment asset turnover ratio improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Segment Capital Expenditures to Depreciation

Express Scripts Holding Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation PBM PBM segment capital expenditures to depreciation ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.
Other Business Operations Other Business Operations segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 and from 2016 to 2017.

Segment Capital Expenditures to Depreciation: PBM

Express Scripts Holding Co.; PBM; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Capital expenditures
Depreciation and amortization expense
Segment Financial Ratio
Segment capital expenditures to depreciation1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= ÷ =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation PBM PBM segment capital expenditures to depreciation ratio improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Segment Capital Expenditures to Depreciation: Other Business Operations

Express Scripts Holding Co.; Other Business Operations; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Capital expenditures
Depreciation and amortization expense
Segment Financial Ratio
Segment capital expenditures to depreciation1

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).

1 2017 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation and amortization expense
= ÷ =

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Other Business Operations Other Business Operations segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 and from 2016 to 2017.

Revenues

Express Scripts Holding Co., revenues by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations
Total

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).


Depreciation and amortization expense

Express Scripts Holding Co., depreciation and amortization expense by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations
Total

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).


Operating income

Express Scripts Holding Co., operating income by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations
Total

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).


Capital expenditures

Express Scripts Holding Co., capital expenditures by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations
Total

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).


Total assets

Express Scripts Holding Co., total assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
PBM
Other Business Operations
Discontinued operations
Total

Based on: 10-K (reporting date: 2017-12-31), 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31).