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.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Express Scripts Holding Co., adjusted current assets

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Current assets
Adjustments
Add: Allowance for doubtful accounts
Less: Current deferred tax assets1
After Adjustment
Adjusted current assets

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 Current deferred tax assets. See details »


Adjustments to Total Assets

Express Scripts Holding Co., adjusted total assets

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total assets
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for doubtful accounts
Less: Current deferred tax assets2
Less: Noncurrent deferred tax assets (included in Other assets)3
After Adjustment
Adjusted total assets

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Current deferred tax assets. See details »

3 Noncurrent deferred tax assets (included in Other assets). See details »


Adjustments to Total Liabilities

Express Scripts Holding Co., adjusted total liabilities

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Noncurrent deferred tax liabilities2
After Adjustment
Adjusted total liabilities

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Noncurrent deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Express Scripts Holding Co., adjusted total Express Scripts stockholders’ equity

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total Express Scripts stockholders’ equity
Adjustments
Less: Net deferred tax assets (liabilities)1
Add: Allowance for doubtful accounts
Add: Non-controlling interest
After Adjustment
Adjusted total stockholders’ equity

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 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

Express Scripts Holding Co., adjusted capitalization table

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Short-term debt and current maturities of long-term debt
Long-term debt, excluding current maturities
Total reported debt
Total Express Scripts stockholders’ equity
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Adjusted total debt
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2
Add: Allowance for doubtful accounts
Add: Non-controlling interest
Adjusted total stockholders’ equity
After Adjustment
Adjusted total capital

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Net deferred tax assets (liabilities). See details »


Adjustments to Reported Income

Express Scripts Holding Co., adjusted net income attributable to Express Scripts

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Net income attributable to Express Scripts
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for doubtful accounts
Less: Net loss from discontinued operations, net of tax
Add: Other comprehensive income (loss)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest
After Adjustment
Adjusted net income

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 Deferred income tax expense (benefit). See details »