Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel

Long-term Activity Ratios (Summary)

Medtronic PLC, long-term (investment) activity ratios

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Net fixed asset turnover 5.61 5.85 5.77 5.99 6.54 6.51
Net fixed asset turnover (including operating lease, right-of-use asset) 4.72 5.06 4.84 5.02 6.54 6.51
Total asset turnover 0.34 0.35 0.32 0.32 0.34 0.33
Equity turnover 0.61 0.60 0.59 0.57 0.61 0.59

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

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 2021 to 2022 but then deteriorated significantly from 2022 to 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). Medtronic PLC net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Medtronic PLC total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Medtronic PLC equity turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Net Fixed Asset Turnover

Medtronic PLC, net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Selected Financial Data (US$ in millions)
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
Property, plant, and equipment, net 5,569 5,413 5,221 4,828 4,675 4,604
Long-term Activity Ratio
Net fixed asset turnover1 5.61 5.85 5.77 5.99 6.54 6.51
Benchmarks
Net Fixed Asset Turnover, Competitors2
Abbott Laboratories 3.95 4.76 4.81 3.83 3.97
Cigna Group 52.53 47.53 46.73 37.85 34.45
CVS Health Corp. 27.05 24.98 22.56 21.25 21.24
Elevance Health Inc. 39.05 36.07 34.94 34.69 32.92
Humana Inc. 34.75 28.71 26.97 32.05 32.93
Intuitive Surgical Inc. 2.01 2.62 3.04 2.76 3.52
Shockwave Medical Inc. 10.59 10.17 9.73 4.14 8.74
UnitedHealth Group Inc. 32.10 31.81 31.81 29.64 27.60
Net Fixed Asset Turnover, Sector
Health Care Equipment & Services 23.13 22.48 21.54 20.27 19.95
Net Fixed Asset Turnover, Industry
Health Care 10.07 10.50 10.29 9.54 9.64

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

1 2023 Calculation
Net fixed asset turnover = Net sales ÷ Property, plant, and equipment, net
= 31,227 ÷ 5,569 = 5.61

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 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

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

Medtronic PLC, net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Selected Financial Data (US$ in millions)
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
 
Property, plant, and equipment, net 5,569 5,413 5,221 4,828 4,675 4,604
Operating lease right-of-use assets (classified in Other assets) 1,041 854 998 927
Property, plant, and equipment, net (including operating lease, right-of-use asset) 6,610 6,267 6,219 5,755 4,675 4,604
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 4.72 5.06 4.84 5.02 6.54 6.51
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Abbott Laboratories 3.56 4.25 4.26 3.42 3.56
Cigna Group 47.75 43.23 41.37 33.46 30.72
CVS Health Corp. 11.72 10.46 9.09 8.04 7.77
Elevance Health Inc. 34.43 31.64 30.12 29.26 27.82
Humana Inc. 29.75 24.76 22.09 27.07 27.22
Intuitive Surgical Inc. 1.97 2.53 2.93 2.66 3.32
Shockwave Medical Inc. 7.40 6.08 4.57 2.83 3.13
UnitedHealth Group Inc. 22.48 21.54 21.54 19.55 18.97
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Health Care Equipment & Services 15.73 14.86 13.77 12.52 12.33
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Health Care 8.24 8.48 8.17 7.50 7.58

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

1 2023 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Net sales ÷ Property, plant, and equipment, net (including operating lease, right-of-use asset)
= 31,227 ÷ 6,610 = 4.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). Medtronic PLC net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Total Asset Turnover

Medtronic PLC, total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Selected Financial Data (US$ in millions)
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
Total assets 90,948 90,981 93,083 90,689 89,694 91,393
Long-term Activity Ratio
Total asset turnover1 0.34 0.35 0.32 0.32 0.34 0.33
Benchmarks
Total Asset Turnover, Competitors2
Abbott Laboratories 0.55 0.59 0.57 0.48 0.47
Cigna Group 1.27 1.25 1.11 1.02 0.98
CVS Health Corp. 1.43 1.41 1.25 1.16 1.15
Elevance Health Inc. 1.56 1.51 1.41 1.39 1.33
Humana Inc. 2.24 2.15 1.87 2.17 2.21
Intuitive Surgical Inc. 0.46 0.48 0.42 0.39 0.46
Shockwave Medical Inc. 0.47 0.76 0.69 0.25 0.19
UnitedHealth Group Inc. 1.34 1.31 1.34 1.30 1.38
Total Asset Turnover, Sector
Health Care Equipment & Services 1.26 1.22 1.13 1.08 1.07
Total Asset Turnover, Industry
Health Care 0.80 0.81 0.76 0.70 0.71

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

1 2023 Calculation
Total asset turnover = Net sales ÷ Total assets
= 31,227 ÷ 90,948 = 0.34

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 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Equity Turnover

Medtronic PLC, equity turnover calculation, comparison to benchmarks

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Selected Financial Data (US$ in millions)
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
Shareholders’ equity 51,483 52,551 51,428 50,737 50,091 50,720
Long-term Activity Ratio
Equity turnover1 0.61 0.60 0.59 0.57 0.61 0.59
Benchmarks
Equity Turnover, Competitors2
Abbott Laboratories 1.04 1.19 1.20 1.06 1.03
Cigna Group 4.20 4.00 3.66 3.16 3.36
CVS Health Corp. 4.66 4.53 3.87 3.86 4.00
Elevance Health Inc. 4.33 4.29 3.80 3.64 3.25
Humana Inc. 6.48 6.04 5.15 5.54 5.35
Intuitive Surgical Inc. 0.54 0.56 0.48 0.45 0.54
Shockwave Medical Inc. 1.09 0.96 0.98 0.30 0.22
UnitedHealth Group Inc. 4.14 4.14 3.98 3.90 4.17
Equity Turnover, Sector
Health Care Equipment & Services 3.43 3.33 3.03 2.91 2.94
Equity Turnover, Industry
Health Care 2.25 2.19 2.11 2.08 2.08

Based on: 10-K (reporting date: 2023-04-28), 10-K (reporting date: 2022-04-29), 10-K (reporting date: 2021-04-30), 10-K (reporting date: 2020-04-24), 10-K (reporting date: 2019-04-26), 10-K (reporting date: 2018-04-27).

1 2023 Calculation
Equity turnover = Net sales ÷ Shareholders’ equity
= 31,227 ÷ 51,483 = 0.61

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 2021 to 2022 and from 2022 to 2023.