Microsoft Excel LibreOffice Calc

CVS Health Corp. (CVS)

Long-term (Investment) Activity Analysis

Difficulty: Beginner

  • Annual Data
  • Quarterly Data

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