Stock Analysis on Net
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.

Common-Size Balance Sheet: Assets
Quarterly Data

Express Scripts Holding Co., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014 Dec 31, 2013 Sep 30, 2013 Jun 30, 2013 Mar 31, 2013
Cash and cash equivalents 6.68 5.38 4.34 4.26 6.63 4.66 6.20 5.95 4.53 2.60 3.47 5.98 0.84 1.39 1.75 3.41 1.56 5.19 3.51 3.72 3.15 2.46 3.58
Receivables, net 14.11 13.42 12.72 13.01 13.42 13.99 13.59 13.65 13.69 14.50 13.22 12.62 14.21 12.52 11.21 11.12 11.95 9.48 7.41 7.51 9.34 8.34 7.73
Inventories 3.91 4.19 3.80 3.92 4.01 3.80 3.44 3.79 3.29 3.37 3.39 3.80 3.33 3.18 3.63 3.93 3.35 3.23 3.27 3.49 3.00 3.06 2.98
Deferred taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.69 0.82 0.82 0.73 0.82 0.95 1.00 0.85 0.77 0.71 0.69
Prepaid expenses and other current assets 1.18 1.09 0.63 0.86 0.70 0.59 0.46 0.51 0.34 0.39 0.27 0.24 0.68 0.67 0.26 0.47 0.48 0.28 0.23 0.22 0.36 0.38 0.38
Current assets of discontinued operations 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.06 0.23 0.25 0.31
Current assets 25.89% 24.09% 21.49% 22.04% 24.76% 23.04% 23.68% 23.89% 21.85% 20.87% 20.35% 22.65% 19.76% 18.58% 17.67% 19.64% 18.16% 19.13% 15.42% 15.86% 16.84% 15.21% 15.67%
Property and equipment, net 0.89 0.92 1.04 1.02 2.47 2.48 2.50 2.46 2.47 2.46 2.46 2.43 2.58 2.72 2.91 2.94 3.07 3.01 3.15 3.10 2.98 3.05 3.02
Computer software, net 1.49 1.52 1.53 1.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Goodwill 56.11 56.90 58.24 57.32 57.46 58.25 57.34 56.58 57.51 57.57 57.29 54.99 56.31 56.45 56.41 54.43 54.84 53.64 55.56 54.73 53.51 53.76 52.79
Other intangible assets, net 15.20 16.15 17.29 17.74 15.03 15.96 16.21 16.69 17.87 18.80 19.62 19.66 21.08 21.98 22.77 22.78 23.76 24.06 25.73 26.17 26.53 27.52 27.94
Other assets 0.42 0.42 0.41 0.38 0.27 0.26 0.27 0.37 0.30 0.30 0.28 0.27 0.27 0.27 0.24 0.21 0.18 0.16 0.15 0.14 0.10 0.11 0.12
Noncurrent assets of discontinued operations 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.04 0.35 0.46
Noncurrent assets 74.11% 75.91% 78.51% 77.96% 75.24% 76.96% 76.32% 76.11% 78.15% 79.13% 79.65% 77.35% 80.24% 81.42% 82.33% 80.36% 81.84% 80.87% 84.58% 84.14% 83.16% 84.79% 84.33%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31).

A structural shift in the asset composition is observed over the analyzed period, characterized by a gradual increase in liquidity and a corresponding reduction in noncurrent asset concentration. Total current assets expanded from 15.67% of total assets in March 2013 to 25.89% by September 2018, while noncurrent assets declined from 84.33% to 74.11% during the same timeframe.

Current Asset Trends
The growth in current assets was primarily driven by a significant increase in net receivables, which rose from 7.73% in March 2013 to 14.11% in September 2018. Cash and cash equivalents exhibited higher volatility, fluctuating between a low of 0.84% in September 2015 and a peak of 6.68% in September 2018. Inventories remained relatively stable, maintaining a range between approximately 3% and 4% of total assets throughout the period.
Intangible Asset Dynamics
Goodwill represents the largest single component of the balance sheet, remaining consistently high and fluctuating between 52.79% and 58.25%. In contrast, other net intangible assets showed a persistent downward trend, decreasing from 27.94% in March 2013 to 15.20% in September 2018, suggesting systematic amortization or impairment over time.
Fixed and Other Noncurrent Assets
Property and equipment, net, remained stable at approximately 2.4% to 3.1% until December 2017, after which a sharp decline occurred, falling to 0.89% by September 2018. This period also saw the introduction of computer software as a distinct asset class starting in December 2017, accounting for approximately 1.5% of total assets.
Operational Transitions
Assets related to discontinued operations were present in early 2013 but were eliminated from the balance sheet by March 2014, signaling the completion of a divestiture or business segment exit.

AI Ask an analyst for more

My previous chats

Add tokens

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?