Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Medtronic PLC, long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Jan 26, 2024 Oct 27, 2023 Jul 28, 2023 Apr 28, 2023 Jan 27, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017
Net fixed asset turnover 5.54 5.57 5.57 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 6.51
Total asset turnover 0.36 0.35 0.35 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 0.33
Equity turnover 0.62 0.62 0.62 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 0.59

Based on: 10-Q (reporting date: 2024-01-26), 10-Q (reporting date: 2023-10-27), 10-Q (reporting date: 2023-07-28), 10-K (reporting date: 2023-04-28), 10-Q (reporting date: 2023-01-27), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-K (reporting date: 2022-04-29), 10-Q (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-K (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-K (reporting date: 2020-04-24), 10-Q (reporting date: 2020-01-24), 10-Q (reporting date: 2019-10-25), 10-Q (reporting date: 2019-07-26), 10-K (reporting date: 2019-04-26), 10-Q (reporting date: 2019-01-25), 10-Q (reporting date: 2018-10-26), 10-Q (reporting date: 2018-07-27), 10-K (reporting date: 2018-04-27), 10-Q (reporting date: 2018-01-26), 10-Q (reporting date: 2017-10-27), 10-Q (reporting date: 2017-07-28).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Medtronic PLC net fixed asset turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Medtronic PLC total asset turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Medtronic PLC equity turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover

Medtronic PLC, net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Jan 26, 2024 Oct 27, 2023 Jul 28, 2023 Apr 28, 2023 Jan 27, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017
Selected Financial Data (US$ in millions)
Net sales 8,089 7,984 7,702 8,544 7,727 7,585 7,371 8,089 7,763 7,847 7,987 8,188 7,775 7,647 6,507 5,997 7,717 7,706 7,493 8,146 7,546 7,481 7,384 8,144 7,369 7,050 7,390
Property, plant, and equipment, net 5,838 5,735 5,665 5,569 5,437 5,298 5,281 5,413 5,251 5,188 5,162 5,221 5,023 4,938 4,882 4,828 4,764 4,756 4,711 4,675 4,593 4,536 4,524 4,604 4,517 4,441 4,387
Long-term Activity Ratio
Net fixed asset turnover1 5.54 5.57 5.57 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 6.51
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
CVS Health Corp. 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
Danaher Corp. 5.25 6.87 7.27 7.61 7.96 8.40 8.12 7.94 7.77 7.71 7.84 7.59 6.83 6.68 6.35 6.03 7.78
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
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-Q (reporting date: 2024-01-26), 10-Q (reporting date: 2023-10-27), 10-Q (reporting date: 2023-07-28), 10-K (reporting date: 2023-04-28), 10-Q (reporting date: 2023-01-27), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-K (reporting date: 2022-04-29), 10-Q (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-K (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-K (reporting date: 2020-04-24), 10-Q (reporting date: 2020-01-24), 10-Q (reporting date: 2019-10-25), 10-Q (reporting date: 2019-07-26), 10-K (reporting date: 2019-04-26), 10-Q (reporting date: 2019-01-25), 10-Q (reporting date: 2018-10-26), 10-Q (reporting date: 2018-07-27), 10-K (reporting date: 2018-04-27), 10-Q (reporting date: 2018-01-26), 10-Q (reporting date: 2017-10-27), 10-Q (reporting date: 2017-07-28).

1 Q3 2024 Calculation
Net fixed asset turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Property, plant, and equipment, net
= (8,089 + 7,984 + 7,702 + 8,544) ÷ 5,838 = 5.54

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. Medtronic PLC net fixed asset turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Total Asset Turnover

Medtronic PLC, total asset turnover calculation (quarterly data)

Microsoft Excel
Jan 26, 2024 Oct 27, 2023 Jul 28, 2023 Apr 28, 2023 Jan 27, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017
Selected Financial Data (US$ in millions)
Net sales 8,089 7,984 7,702 8,544 7,727 7,585 7,371 8,089 7,763 7,847 7,987 8,188 7,775 7,647 6,507 5,997 7,717 7,706 7,493 8,146 7,546 7,481 7,384 8,144 7,369 7,050 7,390
Total assets 90,836 90,087 90,776 90,948 94,134 93,241 89,914 90,981 91,804 91,756 91,802 93,083 97,270 95,886 93,906 90,689 92,822 91,053 91,268 89,694 88,730 88,150 89,721 91,393 95,800 94,458 100,250
Long-term Activity Ratio
Total asset turnover1 0.36 0.35 0.35 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 0.33
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
CVS Health Corp. 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
Danaher Corp. 0.28 0.34 0.36 0.36 0.37 0.39 0.38 0.36 0.35 0.34 0.34 0.33 0.29 0.28 0.27 0.26 0.29
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
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-Q (reporting date: 2024-01-26), 10-Q (reporting date: 2023-10-27), 10-Q (reporting date: 2023-07-28), 10-K (reporting date: 2023-04-28), 10-Q (reporting date: 2023-01-27), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-K (reporting date: 2022-04-29), 10-Q (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-K (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-K (reporting date: 2020-04-24), 10-Q (reporting date: 2020-01-24), 10-Q (reporting date: 2019-10-25), 10-Q (reporting date: 2019-07-26), 10-K (reporting date: 2019-04-26), 10-Q (reporting date: 2019-01-25), 10-Q (reporting date: 2018-10-26), 10-Q (reporting date: 2018-07-27), 10-K (reporting date: 2018-04-27), 10-Q (reporting date: 2018-01-26), 10-Q (reporting date: 2017-10-27), 10-Q (reporting date: 2017-07-28).

1 Q3 2024 Calculation
Total asset turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Total assets
= (8,089 + 7,984 + 7,702 + 8,544) ÷ 90,836 = 0.36

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. Medtronic PLC total asset turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Equity Turnover

Medtronic PLC, equity turnover calculation (quarterly data)

Microsoft Excel
Jan 26, 2024 Oct 27, 2023 Jul 28, 2023 Apr 28, 2023 Jan 27, 2023 Oct 28, 2022 Jul 29, 2022 Apr 29, 2022 Jan 28, 2022 Oct 29, 2021 Jul 30, 2021 Apr 30, 2021 Jan 29, 2021 Oct 30, 2020 Jul 31, 2020 Apr 24, 2020 Jan 24, 2020 Oct 25, 2019 Jul 26, 2019 Apr 26, 2019 Jan 25, 2019 Oct 26, 2018 Jul 27, 2018 Apr 27, 2018 Jan 26, 2018 Oct 27, 2017 Jul 28, 2017
Selected Financial Data (US$ in millions)
Net sales 8,089 7,984 7,702 8,544 7,727 7,585 7,371 8,089 7,763 7,847 7,987 8,188 7,775 7,647 6,507 5,997 7,717 7,706 7,493 8,146 7,546 7,481 7,384 8,144 7,369 7,050 7,390
Shareholders’ equity 51,792 51,460 51,178 51,483 51,441 51,880 52,672 52,551 52,542 51,991 51,486 51,428 50,758 50,164 50,296 50,737 51,808 50,578 50,363 50,091 49,829 49,607 50,224 50,720 50,234 51,469 50,672
Long-term Activity Ratio
Equity turnover1 0.62 0.62 0.62 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 0.59
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
CVS Health Corp. 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
Danaher Corp. 0.45 0.56 0.59 0.60 0.63 0.67 0.66 0.65 0.65 0.65 0.62 0.61 0.56 0.54 0.52 0.58 0.59
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
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-Q (reporting date: 2024-01-26), 10-Q (reporting date: 2023-10-27), 10-Q (reporting date: 2023-07-28), 10-K (reporting date: 2023-04-28), 10-Q (reporting date: 2023-01-27), 10-Q (reporting date: 2022-10-28), 10-Q (reporting date: 2022-07-29), 10-K (reporting date: 2022-04-29), 10-Q (reporting date: 2022-01-28), 10-Q (reporting date: 2021-10-29), 10-Q (reporting date: 2021-07-30), 10-K (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-29), 10-Q (reporting date: 2020-10-30), 10-Q (reporting date: 2020-07-31), 10-K (reporting date: 2020-04-24), 10-Q (reporting date: 2020-01-24), 10-Q (reporting date: 2019-10-25), 10-Q (reporting date: 2019-07-26), 10-K (reporting date: 2019-04-26), 10-Q (reporting date: 2019-01-25), 10-Q (reporting date: 2018-10-26), 10-Q (reporting date: 2018-07-27), 10-K (reporting date: 2018-04-27), 10-Q (reporting date: 2018-01-26), 10-Q (reporting date: 2017-10-27), 10-Q (reporting date: 2017-07-28).

1 Q3 2024 Calculation
Equity turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Shareholders’ equity
= (8,089 + 7,984 + 7,702 + 8,544) ÷ 51,792 = 0.62

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. Medtronic PLC equity turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.