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.

Analysis of Property, Plant and Equipment

Microsoft Excel

Property, Plant and Equipment Disclosure

Express Scripts Holding Co., balance sheet: property, plant and equipment

US$ in thousands

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Land and buildings 195,300 184,700 200,000 224,000 215,800
Furniture 74,500 70,400 71,900 72,800 71,600
Equipment 543,500 801,400 773,000 785,100 707,500
Computer software — 1,926,000 1,733,800 1,638,600 1,582,300
Leasehold improvements 290,800 240,500 229,000 194,100 173,400
Property and equipment, gross 1,104,100 3,223,000 3,007,700 2,914,600 2,750,600
Accumulated depreciation (552,800) (1,949,400) (1,716,400) (1,330,600) (1,091,700)
Property and equipment, net 551,300 1,273,600 1,291,300 1,584,000 1,658,900

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).


The net book value of property and equipment exhibited a consistent downward trajectory from 2013 to 2017, declining from 1,658,900 thousand US dollars to 551,300 thousand US dollars. While gross assets grew steadily between 2013 and 2016, a significant contraction occurred in 2017, coinciding with a substantial reduction in accumulated depreciation and the absence of reported computer software assets.

Gross Asset Composition and Trends
From 2013 to 2016, gross property and equipment increased from 2,750,600 thousand US dollars to 3,223,000 thousand US dollars. This growth was primarily driven by computer software, which rose from 1,582,300 thousand US dollars in 2013 to 1,926,000 thousand US dollars in 2016, and leasehold improvements, which grew steadily each year to reach 240,500 thousand US dollars by 2016. However, in 2017, gross assets fell sharply to 1,104,100 thousand US dollars, largely due to the removal of computer software from the reporting and a decrease in equipment value.
Analysis of Specific Asset Classes
Leasehold improvements demonstrated the most consistent growth over the five-year period, increasing from 173,400 thousand US dollars in 2013 to 290,800 thousand US dollars in 2017. Land and buildings and furniture remained relatively stable, with land and buildings fluctuating slightly around the 200,000 thousand US dollar mark. Equipment saw a peak of 801,400 thousand US dollars in 2016 before dropping to 543,500 thousand US dollars in 2017.
Depreciation and Net Valuation
Accumulated depreciation increased steadily from 2013 to 2016, rising from 1,091,700 thousand US dollars to 1,949,400 thousand US dollars, which contributed to the gradual decline in net property and equipment during this period. In 2017, accumulated depreciation decreased sharply to 552,800 thousand US dollars. This reduction in both gross assets and accumulated depreciation in 2017 suggests a significant asset disposal, write-off, or a reclassification of assets within the balance sheet.

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?


Asset Age Ratios (Summary)

Express Scripts Holding Co., asset age ratios

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Average age ratio 50.07% 60.48% 57.07% 45.65% 39.69%
Estimated total useful life (years) 8 10 5 6 6
Estimated age, time elapsed since purchase (years) 4 6 3 3 3
Estimated remaining life (years) 4 4 2 3 4

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).


The analysis of asset age ratios between 2013 and 2017 indicates a period of increasing asset maturity followed by a significant correction in the final year. The overall trend suggests a cycle of asset aging and subsequent renewal or accounting re-estimation.

Average Age Ratio
A consistent upward trend is observed from 2013 to 2016, with the ratio increasing from 39.69% to a peak of 60.48%. This progression indicates that the property, plant, and equipment were becoming progressively older relative to their estimated useful lives. However, a notable reversal occurred in 2017, where the ratio decreased to 50.07%, signaling a reduction in the average age of the asset base.
Estimated Total Useful Life
The estimated total useful life remained relatively stable at 5 to 6 years from 2013 to 2015. A significant adjustment occurred in 2016, where the estimate was extended to 10 years, before being revised slightly downward to 8 years in 2017. This fluctuation suggests a change in the accounting assumptions regarding the longevity of the company's assets.
Estimated Asset Age and Remaining Life
The estimated age of assets remained constant at 3 years from 2013 through 2015, during which time the remaining life decreased linearly from 4 years to 2 years. In 2016, the estimated age spiked to 6 years, but the remaining life simultaneously increased to 4 years, likely as a direct result of the extension in total useful life estimates. By 2017, the estimated age dropped to 4 years and the remaining life stabilized at 4 years, which is consistent with the acquisition of new assets or the disposal of older ones.

The correlation between the peak average age ratio in 2016 and the subsequent decline in 2017 suggests a strategic refresh of the asset portfolio. The extension of useful life in 2016 served to temporarily offset the increasing age of assets, while the 2017 figures indicate a tangible lowering of the asset base's average age.

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?


Average Age

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Accumulated depreciation 552,800 1,949,400 1,716,400 1,330,600 1,091,700
Property and equipment, gross 1,104,100 3,223,000 3,007,700 2,914,600 2,750,600
Asset Age Ratio
Average age1 50.07% 60.48% 57.07% 45.65% 39.69%

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).

2017 Calculations

1 Average age = 100 × Accumulated depreciation ÷ Property and equipment, gross
= 100 × 552,800 ÷ 1,104,100 = 50.07%


Between 2013 and 2016, a consistent upward trend is observed in both gross property and equipment and accumulated depreciation, indicating a period of steady asset accumulation and subsequent aging. This progression peaked in 2016 before a significant contraction occurred in 2017, characterized by a substantial reduction in the total asset base and associated depreciation.

Gross Property and Equipment Trends
Asset holdings grew incrementally from 2,750,600 thousand US$ in 2013 to a peak of 3,223,000 thousand US$ by the end of 2016. However, 2017 experienced a sharp decline to 1,104,100 thousand US$, representing a reduction of approximately 65.7% from the previous year's levels, suggesting a major divestiture or asset write-down.
Accumulated Depreciation Patterns
Accumulated depreciation rose steadily from 1,091,700 thousand US$ in 2013 to 1,949,400 thousand US$ in 2016. In 2017, this figure dropped precipitously to 552,800 thousand US$, mirroring the contraction seen in the gross asset value and indicating that a significant portion of the depreciated asset base was removed from the balance sheet.
Average Age Ratio Analysis
The average age ratio exhibited a continuous increase from 39.69% in 2013 to 60.48% in 2016, reflecting an aging infrastructure where a larger proportion of the asset's useful life had been consumed. In 2017, the ratio declined to 50.07%. This decrease, occurring alongside the overall reduction in assets, suggests that the assets disposed of or written off were, on average, older than the remaining portfolio, thereby lowering the relative average age of the remaining property and equipment.

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?


Estimated Total Useful Life

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Property and equipment, gross 1,104,100 3,223,000 3,007,700 2,914,600 2,750,600
Depreciation expense 134,600 321,800 628,200 489,400 428,800
Asset Age Ratio (Years)
Estimated total useful life1 8 10 5 6 6

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).

2017 Calculations

1 Estimated total useful life = Property and equipment, gross ÷ Depreciation expense
= 1,104,100 ÷ 134,600 = 8


The analysis of property, plant, and equipment reveals a period of steady asset accumulation followed by a significant contraction in the asset base, accompanied by volatile adjustments to the estimated useful lives of those assets.

Gross Asset Trajectory
From 2013 to 2016, gross property and equipment exhibited a consistent upward trend, increasing from US$ 2,750,600 thousand to a peak of US$ 3,223,000 thousand. However, this trend reversed sharply in 2017, with the gross value declining to US$ 1,104,100 thousand, representing a substantial reduction in the total asset base.
Depreciation Expense and Useful Life Correlation
Depreciation expenses rose from 2013 to 2015, peaking at US$ 628,200 thousand. This peak coincides with a reduction in the estimated total useful life to 5 years in 2015, which accelerated the recognition of expenses. In 2016, despite the gross asset value reaching its maximum, depreciation expenses fell to US$ 321,800 thousand. This inverse relationship is attributable to a significant extension of the estimated useful life to 10 years, which effectively lowered the annual depreciation charge.
Useful Life Volatility
The estimated total useful life was inconsistent over the five-year period, fluctuating between a minimum of 5 years in 2015 and a maximum of 10 years in 2016, before settling at 8 years in 2017. These adjustments suggest periodic reassessments of asset longevity or changes in the composition of the asset portfolio.
2017 Financial Shift
The 2017 fiscal year is characterized by a simultaneous drop in gross property and equipment and a corresponding decrease in depreciation expense to US$ 134,600 thousand. This suggests a large-scale disposal of assets or a significant corporate restructuring that reduced the company's physical infrastructure requirements.

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?


Estimated Age, Time Elapsed since Purchase

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Accumulated depreciation 552,800 1,949,400 1,716,400 1,330,600 1,091,700
Depreciation expense 134,600 321,800 628,200 489,400 428,800
Asset Age Ratio (Years)
Time elapsed since purchase1 4 6 3 3 3

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).

2017 Calculations

1 Time elapsed since purchase = Accumulated depreciation ÷ Depreciation expense
= 552,800 ÷ 134,600 = 4


The analysis of property, plant, and equipment reveals significant volatility in asset aging and depreciation patterns between 2013 and 2017, culminating in a substantial realignment of the asset base in the final year of the period.

Accumulated Depreciation and Asset Disposal
Accumulated depreciation exhibited a consistent upward trend from 2013 to 2016, rising from 1,091,700 thousand US$ to a peak of 1,949,400 thousand US$. However, a sharp decline occurred in 2017, with the balance falling to 552,800 thousand US$. This precipitous drop suggests a large-scale disposal of older assets, a significant write-off, or a restructuring of the capitalized asset portfolio.
Depreciation Expense Trends
Annual depreciation expenses increased steadily through 2015, reaching 628,200 thousand US$. Following this peak, expenses declined to 321,800 thousand US$ in 2016 and further to 134,600 thousand US$ in 2017. The reduction in annual expense correlates with the diminished accumulated depreciation balance, indicating a smaller depreciable base at the end of the period.
Asset Age and Replacement Cycles
The estimated time elapsed since purchase remained constant at three years from 2013 to 2015. An increase to six years was observed in 2016, indicating an aging asset portfolio. By 2017, the estimated age decreased to four years. This reduction in average age, occurring simultaneously with the drop in accumulated depreciation, indicates that older assets were removed from the balance sheet and replaced with newer acquisitions, effectively resetting the age of the equipment pool.

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?


Estimated Remaining Life

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (US$ in thousands)
Property and equipment, net 551,300 1,273,600 1,291,300 1,584,000 1,658,900
Depreciation expense 134,600 321,800 628,200 489,400 428,800
Asset Age Ratio (Years)
Estimated remaining life1 4 4 2 3 4

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).

2017 Calculations

1 Estimated remaining life = Property and equipment, net ÷ Depreciation expense
= 551,300 ÷ 134,600 = 4


A consistent downward trend is observed in the net value of property and equipment from 2013 to 2017. The net book value decreased from 1,658,900 thousand US dollars to 551,300 thousand US dollars over the five-year period, representing a substantial contraction in the asset base.

Asset Valuation Trends
Net property and equipment declined steadily between 2013 and 2016, followed by a sharp reduction of approximately 56.7% between December 31, 2016, and December 31, 2017. This suggests a period of significant asset retirement or a shift in the company's capital structure.
Depreciation Expense Volatility
Depreciation expenses exhibited a non-linear trajectory, increasing from 428,800 thousand US dollars in 2013 to a peak of 628,200 thousand US dollars in 2015. Following this peak, expenses declined sharply to 134,600 thousand US dollars by 2017, which correlates with the diminishing value of the net property and equipment.
Analysis of Estimated Remaining Life
The estimated remaining life of assets showed a progressive decline from four years in 2013 to two years by 2015. This reduction in estimated life coincided with the peak in depreciation expenses in 2015, indicating accelerated depreciation of existing assets. However, in 2016, the estimated remaining life reset to four years and remained constant through 2017, suggesting either the acquisition of new assets with longer lifespans or a revision in accounting estimates for the remaining asset portfolio.

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?