Microsoft Excel LibreOffice Calc

Long-term (Investment) Activity Analysis

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.


Ratios (Summary)

CVS Health Corp., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net fixed asset turnover 17.95 17.45 15.55 15.76 14.71
Total asset turnover 1.94 1.88 1.64 1.88 1.77
Equity turnover 4.90 4.82 4.12 3.67 3.34

Based on: 10-K (filing date: 2018-02-14), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-09), 10-K (filing date: 2015-02-10), 10-K (filing date: 2014-02-11).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. CVS Health Corp.'s net fixed asset turnover improved from 2015 to 2016 and from 2016 to 2017.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. CVS Health Corp.'s total asset turnover improved from 2015 to 2016 and from 2016 to 2017.
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. CVS Health Corp.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017.

Net Fixed Asset Turnover

CVS Health Corp., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Net revenues 184,765  177,526  153,290  139,367  126,761 
Property and equipment, net 10,292  10,175  9,855  8,843  8,615 
Ratio
Net fixed asset turnover1 17.95 17.45 15.55 15.76 14.71
Benchmarks
Net Fixed Asset Turnover, Competitors
Walgreens Boots Alliance Inc. 8.67 8.19 6.87 6.23 5.95
Net Fixed Asset Turnover, Sector
Food & Drug Retailers 12.66 12.03 10.30 10.23 9.59
Net Fixed Asset Turnover, Industry
Consumer Services 3.90 3.89 3.99 3.80 3.70

Based on: 10-K (filing date: 2018-02-14), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-09), 10-K (filing date: 2015-02-10), 10-K (filing date: 2014-02-11).

2017 Calculations

1 Net fixed asset turnover = Net revenues ÷ Property and equipment, net
= 184,765 ÷ 10,292 = 17.95

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. CVS Health Corp.'s net fixed asset turnover improved from 2015 to 2016 and from 2016 to 2017.

Total Asset Turnover

CVS Health Corp., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Net revenues 184,765  177,526  153,290  139,367  126,761 
Total assets 95,131  94,462  93,657  74,252  71,526 
Ratio
Total asset turnover1 1.94 1.88 1.64 1.88 1.77
Benchmarks
Total Asset Turnover, Competitors
Walgreens Boots Alliance Inc. 1.79 1.61 1.50 2.05 2.04
Total Asset Turnover, Sector
Food & Drug Retailers 1.88 1.76 1.58 1.94 1.86
Total Asset Turnover, Industry
Consumer Services 1.28 1.27 1.37 1.37 1.35

Based on: 10-K (filing date: 2018-02-14), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-09), 10-K (filing date: 2015-02-10), 10-K (filing date: 2014-02-11).

2017 Calculations

1 Total asset turnover = Net revenues ÷ Total assets
= 184,765 ÷ 95,131 = 1.94

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. CVS Health Corp.'s total asset turnover improved from 2015 to 2016 and from 2016 to 2017.

Equity Turnover

CVS Health Corp., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Net revenues 184,765  177,526  153,290  139,367  126,761 
Total CVS Health shareholders' equity 37,691  36,830  37,196  37,958  37,938 
Ratio
Equity turnover1 4.90 4.82 4.12 3.67 3.34
Benchmarks
Equity Turnover, Competitors
Walgreens Boots Alliance Inc. 4.30 3.93 3.35 3.73 3.71
Equity Turnover, Sector
Food & Drug Retailers 4.65 4.42 3.77 3.69 3.47
Equity Turnover, Industry
Consumer Services 4.10 3.95 4.11 3.78 3.49

Based on: 10-K (filing date: 2018-02-14), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-09), 10-K (filing date: 2015-02-10), 10-K (filing date: 2014-02-11).

2017 Calculations

1 Equity turnover = Net revenues ÷ Total CVS Health shareholders' equity
= 184,765 ÷ 37,691 = 4.90

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. CVS Health Corp.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017.