Stock Analysis on Net

CVS Health Corp. (NYSE:CVS)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 27.05 26.62 26.00 25.63 24.98 24.90 24.05 23.26 22.56 22.24 21.90 21.42 21.25 21.48 21.52 21.49 21.24
Net fixed asset turnover (including operating lease, right-of-use asset) 11.72 11.33 11.01 10.81 10.46 10.17 9.80 9.44 9.09 8.55 8.37 8.15 8.04 8.08 8.02 7.95 7.77
Total asset turnover 1.43 1.38 1.35 1.38 1.41 1.36 1.33 1.28 1.25 1.21 1.20 1.18 1.16 1.14 1.12 1.13 1.15
Equity turnover 4.66 4.66 4.65 4.62 4.53 4.45 4.08 4.05 3.87 3.82 3.79 3.81 3.86 3.86 3.87 4.01 4.00

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-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. CVS Health Corp. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). CVS Health Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. CVS Health Corp. total asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. CVS Health Corp. equity turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

CVS Health Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues from customers 93,545 89,487 88,647 84,944 83,523 80,958 80,490 76,658 76,237 73,548 72,327 68,800 69,306 66,852 65,157 66,593 66,683 64,547 63,138 61,397
Property and equipment, net 13,183 13,022 13,001 12,872 12,873 12,626 12,764 12,844 12,896 12,771 12,664 12,611 12,606 12,349 12,221 12,146 12,044 11,651 11,483 11,348
Long-term Activity Ratio
Net fixed asset turnover1 27.05 26.62 26.00 25.63 24.98 24.90 24.05 23.26 22.56 22.24 21.90 21.42 21.25 21.48 21.52 21.49 21.24
Benchmarks
Net Fixed Asset Turnover, Competitors2
Abbott Laboratories 3.95 4.18 4.26 4.47 4.76 5.18 5.17 5.00 4.81 4.79 4.56 4.23 3.83 3.74 3.77 4.06 3.97
Cigna Group 52.53 48.12 47.67 47.44 47.53 47.84 48.61 47.95 46.73 41.42 40.56 39.29 37.85 37.05 36.02 35.37 34.45
Elevance Health Inc. 39.05 39.41 36.19 36.14 36.07 36.22 36.17 35.81 34.94 34.54 34.17 34.94 34.69 34.61 32.74 32.30 32.92
Humana Inc. 34.75 30.35 29.59 29.40 28.71 28.37 28.64 27.05 26.97 27.83 29.47 31.04 32.05 32.90 33.07 33.20 32.93
Intuitive Surgical Inc. 2.01 2.23 2.35 2.49 2.62 2.73 2.83 3.00 3.04 3.16 3.13 2.86 2.76 2.85 3.00 3.36 3.52
Medtronic PLC 5.61 5.66 5.82 5.88 5.85 6.05 6.13 6.12 5.77 5.56 5.64 5.72 5.99 6.52 6.50 6.51 6.54 6.65 6.70 6.62
Shockwave Medical Inc. 10.59 10.82 10.31 10.31 10.17 10.95 11.28 10.72 9.73 7.61 6.06 4.18 4.14 4.47 3.85 3.89 8.74
UnitedHealth Group Inc. 32.10 32.18 31.60 31.35 31.81 33.07 32.33 32.16 31.81 31.77 30.94 30.76 29.64 30.80 30.30 29.91 27.60

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover = (Revenues from customersQ4 2023 + Revenues from customersQ3 2023 + Revenues from customersQ2 2023 + Revenues from customersQ1 2023) ÷ Property and equipment, net
= (93,545 + 89,487 + 88,647 + 84,944) ÷ 13,183 = 27.05

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. CVS Health Corp. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

CVS Health Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues from customers 93,545 89,487 88,647 84,944 83,523 80,958 80,490 76,658 76,237 73,548 72,327 68,800 69,306 66,852 65,157 66,593 66,683 64,547 63,138 61,397
 
Property and equipment, net 13,183 13,022 13,001 12,872 12,873 12,626 12,764 12,844 12,896 12,771 12,664 12,611 12,606 12,349 12,221 12,146 12,044 11,651 11,483 11,348
Operating lease right-of-use assets 17,252 17,564 17,703 17,660 17,872 18,270 18,562 18,801 19,122 20,462 20,476 20,542 20,729 20,484 20,571 20,672 20,860 20,757 20,865 20,992
Property and equipment, net (including operating lease, right-of-use asset) 30,435 30,586 30,704 30,532 30,745 30,896 31,326 31,645 32,018 33,233 33,140 33,153 33,335 32,833 32,792 32,818 32,904 32,408 32,348 32,340
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 11.72 11.33 11.01 10.81 10.46 10.17 9.80 9.44 9.09 8.55 8.37 8.15 8.04 8.08 8.02 7.95 7.77
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Shockwave Medical Inc. 7.40 7.27 6.78 6.50 6.08 5.94 6.24 5.47 4.57 5.04 4.60 3.08 2.83 2.81 2.39 2.36 3.13

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Revenues from customersQ4 2023 + Revenues from customersQ3 2023 + Revenues from customersQ2 2023 + Revenues from customersQ1 2023) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (93,545 + 89,487 + 88,647 + 84,944) ÷ 30,435 = 11.72

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). CVS Health Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Total Asset Turnover

CVS Health Corp., total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues from customers 93,545 89,487 88,647 84,944 83,523 80,958 80,490 76,658 76,237 73,548 72,327 68,800 69,306 66,852 65,157 66,593 66,683 64,547 63,138 61,397
Total assets 249,728 251,306 250,071 239,330 228,275 231,212 230,279 232,873 232,999 234,891 231,164 229,606 230,715 232,898 235,495 230,639 222,449 220,113 218,904 219,768
Long-term Activity Ratio
Total asset turnover1 1.43 1.38 1.35 1.38 1.41 1.36 1.33 1.28 1.25 1.21 1.20 1.18 1.16 1.14 1.12 1.13 1.15
Benchmarks
Total Asset Turnover, Competitors2
Abbott Laboratories 0.55 0.55 0.55 0.56 0.59 0.62 0.61 0.60 0.57 0.57 0.55 0.51 0.48 0.47 0.46 0.48 0.47
Cigna Group 1.27 1.26 1.23 1.23 1.25 1.24 1.17 1.15 1.11 1.09 1.07 1.06 1.02 0.97 0.96 0.99 0.98
Elevance Health Inc. 1.56 1.52 1.51 1.46 1.51 1.48 1.47 1.42 1.41 1.35 1.33 1.29 1.39 1.34 1.28 1.31 1.33
Humana Inc. 2.24 1.81 1.73 1.74 2.15 1.80 1.91 1.86 1.87 1.78 2.08 2.08 2.17 1.90 1.82 1.94 2.21
Intuitive Surgical Inc. 0.46 0.47 0.48 0.49 0.48 0.46 0.44 0.43 0.42 0.42 0.42 0.39 0.39 0.41 0.43 0.47 0.46
Medtronic PLC 0.34 0.33 0.33 0.35 0.35 0.35 0.35 0.34 0.32 0.29 0.29 0.30 0.32 0.33 0.34 0.34 0.34 0.34 0.34 0.33
Shockwave Medical Inc. 0.47 0.46 0.78 0.71 0.76 0.90 0.87 0.80 0.69 0.59 0.47 0.31 0.25 0.21 0.18 0.23 0.19
UnitedHealth Group Inc. 1.34 1.26 1.23 1.18 1.31 1.29 1.32 1.33 1.34 1.30 1.29 1.27 1.30 1.31 1.28 1.29 1.38

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Total asset turnover = (Revenues from customersQ4 2023 + Revenues from customersQ3 2023 + Revenues from customersQ2 2023 + Revenues from customersQ1 2023) ÷ Total assets
= (93,545 + 89,487 + 88,647 + 84,944) ÷ 249,728 = 1.43

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. CVS Health Corp. total asset turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Equity Turnover

CVS Health Corp., equity turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenues from customers 93,545 89,487 88,647 84,944 83,523 80,958 80,490 76,658 76,237 73,548 72,327 68,800 69,306 66,852 65,157 66,593 66,683 64,547 63,138 61,397
Total CVS Health shareholders’ equity 76,461 74,337 72,726 71,382 71,015 70,683 75,184 73,830 75,075 74,308 73,244 70,850 69,389 68,807 68,022 65,140 63,864 62,614 61,282 59,686
Long-term Activity Ratio
Equity turnover1 4.66 4.66 4.65 4.62 4.53 4.45 4.08 4.05 3.87 3.82 3.79 3.81 3.86 3.86 3.87 4.01 4.00
Benchmarks
Equity Turnover, Competitors2
Abbott Laboratories 1.04 1.07 1.08 1.12 1.19 1.26 1.25 1.26 1.20 1.23 1.19 1.11 1.06 1.03 1.03 1.06 1.03
Cigna Group 4.20 4.13 4.07 4.09 4.00 3.98 3.88 3.81 3.66 3.56 3.40 3.36 3.16 3.24 3.24 3.39 3.36
Elevance Health Inc. 4.33 4.36 4.31 4.27 4.29 4.22 4.13 3.97 3.80 3.71 3.65 3.65 3.64 3.43 3.26 3.41 3.25
Humana Inc. 6.48 5.98 5.82 5.74 6.04 5.62 5.77 5.63 5.15 4.96 5.34 5.48 5.54 4.65 4.86 5.44 5.35
Intuitive Surgical Inc. 0.54 0.55 0.56 0.57 0.56 0.53 0.50 0.49 0.48 0.48 0.48 0.45 0.45 0.47 0.50 0.54 0.54
Medtronic PLC 0.61 0.60 0.59 0.59 0.60 0.60 0.61 0.61 0.59 0.55 0.56 0.56 0.57 0.60 0.61 0.61 0.61 0.61 0.61 0.60
Shockwave Medical Inc. 1.09 1.12 1.00 0.98 0.96 1.21 1.19 1.12 0.98 0.80 0.62 0.41 0.30 0.25 0.21 0.29 0.22
UnitedHealth Group Inc. 4.14 4.22 4.19 4.10 4.14 4.19 4.18 4.06 3.98 3.95 3.92 3.94 3.90 3.85 3.87 4.29 4.17

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Equity turnover = (Revenues from customersQ4 2023 + Revenues from customersQ3 2023 + Revenues from customersQ2 2023 + Revenues from customersQ1 2023) ÷ Total CVS Health shareholders’ equity
= (93,545 + 89,487 + 88,647 + 84,944) ÷ 76,461 = 4.66

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. CVS Health Corp. equity turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.