AI Tokens
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 »


A consistent upward trajectory in current assets was observed from 2013 through 2016, followed by a moderate contraction in 2017. The period was characterized by significant growth in short-term resource holdings before reaching a plateau and experiencing a slight decline.

Growth Phase Analysis (2013-2016)
Current assets increased from 8.49 billion US$ in 2013 to a peak of 12.36 billion US$ in 2016, representing a cumulative increase of approximately 45.5%. Adjusted current assets mirrored this growth pattern, rising from 8.24 billion US$ to 12.44 billion US$ over the same period.
Adjustment Variance Trends
A shift in the nature of financial adjustments occurred between 2014 and 2015. In 2013 and 2014, adjusted current assets were lower than the reported figures, with the most significant discrepancy occurring in 2013 at approximately 253 million US$. From 2015 onward, the relationship inverted, with adjusted current assets consistently exceeding reported figures, indicating a change in the accounting adjustments applied to the asset base.
Recent Liquidity Contraction (2017)
A downward trend emerged in 2017, where current assets decreased by approximately 3.3% to 11.96 billion US$. Adjusted current assets showed a similar decline of approximately 3.1%, ending the period at 12.05 billion US$. This indicates a synchronized reduction in both reported and adjusted liquidity positions.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 »


The total asset base exhibits moderate volatility over the five-year period from 2013 to 2017, characterized by relative stability, a mid-period contraction, and a subsequent recovery to a peak value.

Total Asset Trajectory
Total assets remained relatively stagnant between 2013 and 2014 before entering a downward trend that culminated in a period low of 51.74 billion US dollars in 2016. This decline was reversed in 2017, as assets increased to 54.26 billion US dollars, representing the highest reported value in the observed timeframe.
Asset Adjustment Patterns
Adjusted total assets consistently exceeded the reported total assets throughout the entire period. In 2013 and 2014, the difference between the two figures was relatively marginal, with adjustments remaining below 70 million US dollars. A notable shift occurred in 2015, where the adjustment increased to approximately 354 million US dollars, remaining at a significantly higher magnitude through 2017.
Comparative Stability and Correlation
A high degree of correlation is evident between total assets and adjusted total assets, as both metrics mirrored each other's fluctuations. The consistent upward adjustment suggests the systematic application of specific accounting treatments to the asset base, with the scale of these adjustments becoming more pronounced from 2015 onward.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 »


An examination of the liability structure from 2013 to 2017 reveals a general upward trajectory in both total and adjusted total liabilities, although the rate of growth and the variance between the two figures differ significantly over the five-year period.

Total Liabilities Trend
Total liabilities exhibited a steady increase from December 31, 2013, at 31,703,400 thousand US$, reaching a peak of 35,862,800 thousand US$ by December 31, 2015. A marginal contraction occurred in 2016, with values declining to 35,501,100 thousand US$, followed by a recovery to 36,130,500 thousand US$ at the end of 2017. This represents an overall increase of approximately 14% over the analyzed period.
Adjusted Total Liabilities Trend
Adjusted total liabilities demonstrated more aggressive growth than the unadjusted figures. Starting at 26,584,530 thousand US$ in 2013, the value climbed consistently to 32,059,786 thousand US$ by 2015. The figures remained relatively stable between 2015 and 2016, ending at 33,805,052 thousand US$ in 2017. The total growth for adjusted liabilities over the period was approximately 27%.
Convergence of Liability Figures
A significant narrowing of the gap between total liabilities and adjusted total liabilities is observed. In 2013, the difference between the two metrics was 5,118,870 thousand US$. By 2017, this variance reduced to 2,325,448 thousand US$. This downward trend in the adjustment amount suggests that the specific items being adjusted out of the total liability calculation have decreased in relative magnitude or volume over time.

The data indicates that while the absolute volume of liabilities increased, the company's adjusted liability profile moved closer to its total reported liabilities, suggesting a shift in the composition of the balance sheet liabilities.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 »


A consistent downward trend in stockholders' equity is observed from 2013 through 2016, followed by a recovery in 2017. Both the reported total equity and the adjusted total equity follow this trajectory, indicating a systemic reduction in equity value during the initial four-year window before a partial rebound.

Reported Equity Performance
Total stockholders' equity declined from 21,837,400 thousand US$ in 2013 to a minimum of 16,236,000 thousand US$ in 2016. This period represents a significant contraction in reported equity, which was subsequently offset by an increase to 18,119,600 thousand US$ in 2017.
Adjusted Equity Performance
Adjusted total stockholders' equity mirrored the reported decline, decreasing from 27,032,200 thousand US$ in 2013 to 19,891,000 thousand US$ in 2016. An upward correction occurred in 2017, with the value rising to 20,752,900 thousand US$.
Equity Adjustment Variance
A positive variance is maintained between the reported total equity and the adjusted total equity throughout the period analyzed. However, the magnitude of this adjustment has steadily decreased. The gap between the two figures narrowed from 5,194,800 thousand US$ in 2013 to 2,633,300 thousand US$ by 2017, indicating a gradual convergence of adjusted and reported equity values over time.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 »


The capitalization structure exhibits a pattern of increasing debt obligations and fluctuating equity levels over the period from 2013 to 2017.

Debt Obligations
Total reported debt remained relatively stable between 2013 and 2014 before experiencing a notable increase to $15.59 billion in 2015. This upward trajectory continued through 2017, ending at $16.01 billion. Adjusted total debt figures consistently exceed reported debt across all years, reflecting a systematic upward adjustment to the reported liabilities.
Stockholders' Equity Trends
A steady decline in total reported stockholders' equity is observed from 2013, when it stood at $21.84 billion, falling to a minimum of $16.24 billion in 2016. This downward trend reversed in 2017, with equity recovering to $18.12 billion. The adjusted equity figures are substantially higher than the reported amounts throughout the period, indicating significant adjustments that bolster the perceived equity position.
Total Capitalization Analysis
Total reported capital followed a U-shaped trajectory, decreasing from $35.78 billion in 2013 to a low of $31.80 billion in 2016, before rising to $34.13 billion in 2017. The adjusted total capital mirrored this trend but remained consistently higher, peaking at $41.30 billion in 2013 and reaching its lowest point of $35.70 billion in 2016. The variance between reported and adjusted capital is primarily driven by the significant positive adjustments made to the stockholders' equity component.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


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 »


Between 2013 and 2017, there is a consistent upward trajectory in reported net income attributable to Express Scripts, while adjusted net income exhibits steady growth followed by a slight contraction in the final year of the period.

Reported Net Income Trends
Net income attributable to the company demonstrated uninterrupted growth throughout the five-year period. Starting at US$ 1,844,600 thousand in 2013, the figure rose to US$ 4,517,400 thousand by 2017. The most significant annual increases occurred between 2015 and 2017, indicating a period of accelerated profitability in reported earnings.
Adjusted Net Income Trends
Adjusted net income grew from US$ 1,415,100 thousand in 2013 to a peak of US$ 2,919,600 thousand in 2016. However, a reversal in this trend is observed in 2017, where adjusted net income decreased slightly to US$ 2,882,500 thousand, despite the continued rise in reported net income.
Divergence Between Reported and Adjusted Figures
A significant widening of the gap between reported net income and adjusted net income is evident in 2017. While reported net income reached its five-year peak, the adjusted figure declined. This divergence suggests that the reported earnings for 2017 were heavily influenced by non-recurring items or accounting adjustments that were excluded from the adjusted net income calculation, resulting in a reported figure that exceeded the adjusted figure by approximately US$ 1.63 billion.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?