Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Express Scripts Holding Co., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Express Scripts Holding Co. net fixed asset turnover ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Express Scripts Holding Co. total asset turnover ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Express Scripts Holding Co. equity turnover ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |
Net Fixed Asset Turnover
Express Scripts Holding Co., net fixed asset turnover calculation (quarterly data)
| 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
| Revenues | 25,563,200) | 25,641,800) | 24,769,400) | 25,378,800) | 24,683,400) | 25,347,500) | 24,654,900) | 24,863,300) | 25,410,100) | 25,222,300) | 24,791,800) | 26,175,400) | 25,222,600) | 25,454,200) | 24,899,600) | 26,312,600) | 25,778,500) | 25,111,000) | 23,685,000) | 25,781,400) | 25,915,600) | 26,381,900) | 26,019,900) | |||||||
| Property and equipment, net | 490,900) | 504,700) | 552,900) | 551,300) | 1,266,600) | 1,255,200) | 1,277,800) | 1,273,600) | 1,255,500) | 1,249,100) | 1,259,700) | 1,291,300) | 1,343,100) | 1,411,900) | 1,510,200) | 1,584,000) | 1,639,900) | 1,644,100) | 1,659,400) | 1,658,900) | 1,629,200) | 1,663,600) | 1,679,700) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 206.46 | 199.08 | 181.19 | 181.51 | 78.60 | 79.89 | 78.38 | 78.74 | 80.92 | 81.19 | 80.69 | 78.80 | 75.86 | 72.56 | 67.61 | 63.69 | 61.20 | 61.12 | 61.33 | 62.75 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Abbott Laboratories | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CVS Health Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Elevance Health Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuitive Surgical Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Medtronic PLC | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| UnitedHealth Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2018 Calculation
Net fixed asset turnover
= (RevenuesQ3 2018
+ RevenuesQ2 2018
+ RevenuesQ1 2018
+ RevenuesQ4 2017)
÷ Property and equipment, net
= (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800)
÷ 490,900 = 206.46
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Express Scripts Holding Co. net fixed asset turnover ratio improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |
Total Asset Turnover
Express Scripts Holding Co., total asset turnover calculation (quarterly data)
| 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
| Revenues | 25,563,200) | 25,641,800) | 24,769,400) | 25,378,800) | 24,683,400) | 25,347,500) | 24,654,900) | 24,863,300) | 25,410,100) | 25,222,300) | 24,791,800) | 26,175,400) | 25,222,600) | 25,454,200) | 24,899,600) | 26,312,600) | 25,778,500) | 25,111,000) | 23,685,000) | 25,781,400) | 25,915,600) | 26,381,900) | 26,019,900) | |||||||
| Total assets | 55,441,600) | 54,677,800) | 53,405,600) | 54,255,800) | 51,206,200) | 50,513,400) | 51,056,000) | 51,744,900) | 50,909,300) | 50,858,600) | 51,107,600) | 53,243,300) | 51,996,500) | 51,867,800) | 51,905,100) | 53,798,900) | 53,439,200) | 54,633,800) | 52,747,100) | 53,548,200) | 54,763,000) | 54,581,500) | 55,585,700) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Total asset turnover1 | 1.83 | 1.84 | 1.88 | 1.84 | 1.94 | 1.99 | 1.96 | 1.94 | 2.00 | 1.99 | 1.99 | 1.91 | 1.96 | 1.98 | 1.97 | 1.88 | 1.88 | 1.84 | 1.93 | 1.94 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Abbott Laboratories | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CVS Health Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Elevance Health Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuitive Surgical Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Medtronic PLC | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| UnitedHealth Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2018 Calculation
Total asset turnover
= (RevenuesQ3 2018
+ RevenuesQ2 2018
+ RevenuesQ1 2018
+ RevenuesQ4 2017)
÷ Total assets
= (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800)
÷ 55,441,600 = 1.83
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Express Scripts Holding Co. total asset turnover ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |
Equity Turnover
Express Scripts Holding Co., equity turnover calculation (quarterly data)
| 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||||||
| Revenues | 25,563,200) | 25,641,800) | 24,769,400) | 25,378,800) | 24,683,400) | 25,347,500) | 24,654,900) | 24,863,300) | 25,410,100) | 25,222,300) | 24,791,800) | 26,175,400) | 25,222,600) | 25,454,200) | 24,899,600) | 26,312,600) | 25,778,500) | 25,111,000) | 23,685,000) | 25,781,400) | 25,915,600) | 26,381,900) | 26,019,900) | |||||||
| Total Express Scripts stockholders’ equity | 20,565,900) | 19,370,000) | 18,442,500) | 18,119,600) | 15,916,500) | 15,744,600) | 15,922,600) | 16,236,000) | 15,600,300) | 15,403,100) | 14,841,100) | 17,372,800) | 16,538,300) | 15,822,200) | 20,604,800) | 20,054,200) | 20,157,700) | 20,451,900) | 21,874,300) | 21,837,400) | 23,702,300) | 23,866,500) | 23,617,800) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Equity turnover1 | 4.93 | 5.19 | 5.43 | 5.52 | 6.25 | 6.37 | 6.29 | 6.18 | 6.51 | 6.58 | 6.85 | 5.86 | 6.16 | 6.47 | 4.96 | 5.03 | 4.98 | 4.91 | 4.65 | 4.77 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Abbott Laboratories | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| CVS Health Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Elevance Health Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Intuitive Surgical Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Medtronic PLC | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| UnitedHealth Group Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q3 2018 Calculation
Equity turnover
= (RevenuesQ3 2018
+ RevenuesQ2 2018
+ RevenuesQ1 2018
+ RevenuesQ4 2017)
÷ Total Express Scripts stockholders’ equity
= (25,563,200 + 25,641,800 + 24,769,400 + 25,378,800)
÷ 20,565,900 = 4.93
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Express Scripts Holding Co. equity turnover ratio deteriorated from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018. |