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.

Enterprise Value (EV)

Microsoft Excel

Current Enterprise Value (EV)

Express Scripts Holding Co., current enterprise value calculation

Microsoft Excel
Current share price (P) $96.97
No. shares of common stock outstanding 563,860,000
US$ in thousands
Common equity (market value)1 54,677,504
Add: Preferred stock, $0.01 par value per share; and no shares issued and outstanding (per books)
Add: Non-controlling interest (per books) 5,700
Total equity 54,683,204
Add: Short-term debt and current maturities of long-term debt (per books) 1,032,900
Add: Long-term debt, excluding current maturities (per books) 14,981,500
Total equity and debt 70,697,604
Less: Cash and cash equivalents 2,309,600
Enterprise value (EV) 68,388,004

Based on: 10-K (reporting date: 2017-12-31).

1 Common equity (market value) = Share price × No. shares of common stock outstanding
= 96.97 × 563,860,000


Historical Enterprise Value (EV)

Express Scripts Holding Co., EV calculation

Microsoft Excel
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Share price1, 2 $78.64 $69.63 $68.65 $86.72 $77.12
No. shares of common stock outstanding1 564,347,000 605,720,000 668,046,000 726,898,000 776,032,000
US$ in thousands
Common equity (market value)3 44,380,248 42,176,284 45,861,358 63,036,595 59,847,588
Add: Preferred stock, $0.01 par value per share; and no shares issued and outstanding (book value)
Add: Non-controlling interest (book value) 5,700 7,800 7,700 9,800 7,400
Total equity 44,385,948 42,184,084 45,869,058 63,046,395 59,854,988
Add: Short-term debt and current maturities of long-term debt (book value) 1,032,900 722,300 1,646,400 2,555,300 1,584,000
Add: Long-term debt, excluding current maturities (book value) 14,981,500 14,846,000 13,946,300 11,012,700 12,363,000
Total equity and debt 60,400,348 57,752,384 61,461,758 76,614,395 73,801,988
Less: Cash and cash equivalents 2,309,600 3,077,200 3,186,300 1,832,600 1,991,400
Enterprise value (EV) 58,090,748 54,675,184 58,275,458 74,781,795 71,810,588

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 Data adjusted for splits and stock dividends.

2 Closing price as at the filing date of Express Scripts Holding Co. Annual Report.

3 2017 Calculation
Common equity (market value) = Share price × No. shares of common stock outstanding
= 78.64 × 564,347,000


Equity Trends
The common equity (market value) exhibited an initial increase from 59,847,588 thousand US dollars in 2013 to 63,036,595 thousand US dollars in 2014. However, a significant decline followed, reaching 45,861,358 thousand US dollars in 2015 and continuing downward to 42,176,284 thousand US dollars in 2016. In 2017, a slight recovery was observed with common equity rising to 44,380,248 thousand US dollars.
Total equity mirrored this pattern closely. It rose from 59,854,988 thousand US dollars in 2013 to 63,046,395 thousand US dollars in 2014, then sharply decreased to 45,869,058 thousand US dollars in 2015 and further to 42,184,084 thousand US dollars in 2016. By 2017, total equity experienced a mild increase to 44,385,948 thousand US dollars.
Total Equity and Debt
Total equity and debt followed a downward trajectory after peaking in 2014 at 76,614,395 thousand US dollars. It decreased markedly to 61,461,758 thousand US dollars in 2015, then gradually declined further to 57,752,384 thousand US dollars in 2016. In 2017, there was a moderate rebound to 60,400,348 thousand US dollars.
Enterprise Value
Enterprise value (EV) trends closely resembled changes in total equity and debt. The EV increased from 71,810,588 thousand US dollars in 2013 to 74,781,795 thousand US dollars in 2014, followed by a significant drop to 58,275,458 thousand US dollars in 2015, and further decline to 54,675,184 thousand US dollars in 2016. In 2017, it increased moderately to 58,090,748 thousand US dollars.
Summary Insights
The data reveals a consistent pattern of growth in 2014 followed by a notable contraction through 2015 and 2016 across all major financial metrics: common equity, total equity, total equity and debt, and enterprise value. The slight recovery in 2017 suggests stabilization or modest improvement in the company's financial position after experiencing significant declines in the prior years. Overall, the volatility observed may indicate market or operational challenges during 2015 and 2016, with signs of cautious recovery thereafter.