Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

Analysis of Long-term (Investment) Activity Ratios 

Microsoft Excel LibreOffice Calc

Long-term Activity Ratios (Summary)

Medtronic PLC, long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018 Apr 28, 2017 Apr 29, 2016
Net fixed asset turnover 5.77 5.99 6.54 6.51 6.81 5.96
Net fixed asset turnover (including operating lease, right-of-use asset) 4.84 5.02 6.54 6.51 6.81 5.96
Total asset turnover 0.32 0.32 0.34 0.33 0.30 0.29
Equity turnover 0.59 0.57 0.61 0.59 0.59 0.55

Based on: 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), 10-K (reporting date: 2017-04-28), 10-K (reporting date: 2016-04-29).

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 deteriorated from 2019 to 2020 and from 2020 to 2021.
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) deteriorated from 2019 to 2020 and from 2020 to 2021.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Medtronic PLC total asset turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Medtronic PLC equity turnover ratio deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Net Fixed Asset Turnover

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

Microsoft Excel LibreOffice Calc
Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018 Apr 28, 2017 Apr 29, 2016
Selected Financial Data (US$ in millions)
Net sales 30,117  28,913  30,557  29,953  29,710  28,833 
Property, plant, and equipment, net 5,221  4,828  4,675  4,604  4,361  4,841 
Long-term Activity Ratio
Net fixed asset turnover1 5.77 5.99 6.54 6.51 6.81 5.96
Benchmarks
Net Fixed Asset Turnover, Competitors2
Abbott Laboratories 4.81 3.83 3.97 4.04 3.60
Anthem Inc. 34.94 34.69 32.92 33.40 40.95
Bristol-Myers Squibb Co. 7.67 7.22 4.18 4.49 4.15
CVS Health Corp. 22.56 21.25 21.24 17.09 17.95
Danaher Corp. 7.77 6.83 7.78 7.92 7.47
HCA Healthcare Inc. 2.44 2.22 2.26 2.36 2.44
Intuitive Surgical Inc. 3.04 2.76 3.52 4.59 5.10
Stryker Corp. 6.04 5.21 5.80 5.94 6.30
UnitedHealth Group Inc. 31.81 29.64 27.60 26.59 28.54
Net Fixed Asset Turnover, Sector
Health Care Equipment & Services 12.01 11.20 10.83 10.40 10.60
Net Fixed Asset Turnover, Industry
Health Care 8.07 7.33 7.39 7.19 7.12

Based on: 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), 10-K (reporting date: 2017-04-28), 10-K (reporting date: 2016-04-29).

1 2021 Calculation
Net fixed asset turnover = Net sales ÷ Property, plant, and equipment, net
= 30,117 ÷ 5,221 = 5.77

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 deteriorated from 2019 to 2020 and from 2020 to 2021.

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 LibreOffice Calc
Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018 Apr 28, 2017 Apr 29, 2016
Selected Financial Data (US$ in millions)
Net sales 30,117  28,913  30,557  29,953  29,710  28,833 
 
Property, plant, and equipment, net 5,221  4,828  4,675  4,604  4,361  4,841 
Operating lease right-of-use assets (classified in Other assets) 998  927  —  —  —  — 
Property, plant, and equipment, net (including operating lease, right-of-use asset) 6,219  5,755  4,675  4,604  4,361  4,841 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 4.84 5.02 6.54 6.51 6.81 5.96
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Abbott Laboratories 4.26 3.42 3.56 4.04 3.60
Anthem Inc. 30.12 29.26 27.82 33.40 40.95
Bristol-Myers Squibb Co. 6.66 6.30 3.76 4.49 4.15
CVS Health Corp. 9.09 8.04 7.77 17.09 17.95
Danaher Corp. 6.10 5.30 5.84 7.92 7.47
HCA Healthcare Inc. 2.24 2.04 2.09 2.36 2.44
Intuitive Surgical Inc. 2.93 2.66 3.32 4.59 5.10
Stryker Corp. 5.26 4.52 5.04 5.94 6.30
UnitedHealth Group Inc. 21.54 19.55 18.97 26.59 28.54
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Health Care Equipment & Services 8.63 7.85 7.63 10.40 10.60
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Health Care 6.53 5.87 5.93 7.19 7.12

Based on: 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), 10-K (reporting date: 2017-04-28), 10-K (reporting date: 2016-04-29).

1 2021 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)
= 30,117 ÷ 6,219 = 4.84

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) deteriorated from 2019 to 2020 and from 2020 to 2021.

Total Asset Turnover

Medtronic PLC, total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018 Apr 28, 2017 Apr 29, 2016
Selected Financial Data (US$ in millions)
Net sales 30,117  28,913  30,557  29,953  29,710  28,833 
Total assets 93,083  90,689  89,694  91,393  99,816  99,782 
Long-term Activity Ratio
Total asset turnover1 0.32 0.32 0.34 0.33 0.30 0.29
Benchmarks
Total Asset Turnover, Competitors2
Abbott Laboratories 0.57 0.48 0.47 0.46 0.36
Anthem Inc. 1.41 1.39 1.33 1.28 1.26
Bristol-Myers Squibb Co. 0.42 0.36 0.20 0.64 0.62
CVS Health Corp. 1.25 1.16 1.15 0.99 1.94
Danaher Corp. 0.35 0.29 0.29 0.42 0.39
HCA Healthcare Inc. 1.16 1.09 1.14 1.19 1.19
Intuitive Surgical Inc. 0.42 0.39 0.46 0.47 0.54
Stryker Corp. 0.49 0.42 0.49 0.50 0.56
UnitedHealth Group Inc. 1.34 1.30 1.38 1.48 1.44
Total Asset Turnover, Sector
Health Care Equipment & Services 0.94 0.87 0.85 0.92 1.01
Total Asset Turnover, Industry
Health Care 0.71 0.65 0.66 0.69 0.67

Based on: 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), 10-K (reporting date: 2017-04-28), 10-K (reporting date: 2016-04-29).

1 2021 Calculation
Total asset turnover = Net sales ÷ Total assets
= 30,117 ÷ 93,083 = 0.32

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 deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.

Equity Turnover

Medtronic PLC, equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018 Apr 28, 2017 Apr 29, 2016
Selected Financial Data (US$ in millions)
Net sales 30,117  28,913  30,557  29,953  29,710  28,833 
Shareholders’ equity 51,428  50,737  50,091  50,720  50,294  52,063 
Long-term Activity Ratio
Equity turnover1 0.59 0.57 0.61 0.59 0.59 0.55
Benchmarks
Equity Turnover, Competitors2
Abbott Laboratories 1.20 1.06 1.03 1.00 0.89
Anthem Inc. 3.80 3.64 3.25 3.20 3.36
Bristol-Myers Squibb Co. 1.29 1.12 0.51 1.61 1.77
CVS Health Corp. 3.87 3.86 4.00 3.33 4.90
Danaher Corp. 0.65 0.56 0.59 0.71 0.70
HCA Healthcare Inc. 90.09
Intuitive Surgical Inc. 0.48 0.45 0.54 0.56 0.66
Stryker Corp. 1.15 1.10 1.16 1.16 1.25
UnitedHealth Group Inc. 3.98 3.90 4.17 4.35 4.19
Equity Turnover, Sector
Health Care Equipment & Services 2.50 2.39 2.32 2.46 2.63
Equity Turnover, Industry
Health Care 1.99 1.96 1.98 1.98 1.86

Based on: 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), 10-K (reporting date: 2017-04-28), 10-K (reporting date: 2016-04-29).

1 2021 Calculation
Equity turnover = Net sales ÷ Shareholders’ equity
= 30,117 ÷ 51,428 = 0.59

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 deteriorated from 2019 to 2020 but then slightly improved from 2020 to 2021.