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.

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 11,957,100 12,363,400 12,059,500 10,568,100 8,491,400
Adjustments
Add: Allowance for doubtful accounts 95,300 75,000 87,300 165,100 202,200
Less: Current deferred tax assets1 390,800 455,400
After Adjustment
Adjusted current assets 12,052,400 12,438,400 12,146,800 10,342,400 8,238,200

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 54,255,800 51,744,900 53,243,300 53,798,900 53,548,200
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 236,952 240,743 266,786 294,809 321,730
Add: Allowance for doubtful accounts 95,300 75,000 87,300 165,100 202,200
Less: Current deferred tax assets2 390,800 455,400
Less: Noncurrent deferred tax assets (included in Other assets)3 30,100 31,100
After Adjustment
Adjusted total assets 54,557,952 52,029,543 53,597,386 53,868,009 53,616,730

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 36,130,500 35,501,100 35,862,800 33,734,900 31,703,400
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 236,952 240,743 266,786 294,809 321,730
Less: Noncurrent deferred tax liabilities2 2,562,400 3,603,300 4,069,800 4,923,200 5,440,600
After Adjustment
Adjusted total liabilities 33,805,052 32,138,543 32,059,786 29,106,509 26,584,530

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 18,119,600 16,236,000 17,372,800 20,054,200 21,837,400
Adjustments
Less: Net deferred tax assets (liabilities)1 (2,532,300) (3,572,200) (4,069,800) (4,532,400) (4,985,200)
Add: Allowance for doubtful accounts 95,300 75,000 87,300 165,100 202,200
Add: Non-controlling interest 5,700 7,800 7,700 9,800 7,400
After Adjustment
Adjusted total stockholders’ equity 20,752,900 19,891,000 21,537,600 24,761,500 27,032,200

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 1,032,900 722,300 1,646,400 2,555,300 1,584,000
Long-term debt, excluding current maturities 14,981,500 14,846,000 13,946,300 11,012,700 12,363,000
Total reported debt 16,014,400 15,568,300 15,592,700 13,568,000 13,947,000
Total Express Scripts stockholders’ equity 18,119,600 16,236,000 17,372,800 20,054,200 21,837,400
Total reported capital 34,134,000 31,804,300 32,965,500 33,622,200 35,784,400
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 236,952 240,743 266,786 294,809 321,730
Adjusted total debt 16,251,352 15,809,043 15,859,486 13,862,809 14,268,730
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 (2,532,300) (3,572,200) (4,069,800) (4,532,400) (4,985,200)
Add: Allowance for doubtful accounts 95,300 75,000 87,300 165,100 202,200
Add: Non-controlling interest 5,700 7,800 7,700 9,800 7,400
Adjusted total stockholders’ equity 20,752,900 19,891,000 21,537,600 24,761,500 27,032,200
After Adjustment
Adjusted total capital 37,004,252 35,700,043 37,397,086 38,624,309 41,300,930

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 4,517,400 3,404,400 2,476,400 2,007,600 1,844,600
Adjustments
Add: Deferred income tax expense (benefit)1 (1,678,900) (497,400) (462,100) (430,500) (573,700)
Add: Increase (decrease) in allowance for doubtful accounts 20,300 (12,300) (77,800) (37,100) 69,700
Less: Net loss from discontinued operations, net of tax (53,600)
Add: Other comprehensive income (loss) 9,400 1,700 (16,100) (9,600) (7,200)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 14,300 23,200 23,100 27,400 28,100
After Adjustment
Adjusted net income 2,882,500 2,919,600 1,943,500 1,557,800 1,415,100

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 »