Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

Adjusted Financial Ratios

Microsoft Excel

Adjusted Financial Ratios (Summary)

Medtronic PLC, adjusted financial ratios

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Activity Ratio
Total Asset Turnover
Reported 0.34 0.35 0.32 0.32 0.34 0.33
Adjusted 0.36 0.36 0.33 0.33 0.34 0.33
Liquidity Ratio
Current Ratio
Reported 2.39 1.86 2.65 2.13 2.59 2.28
Adjusted 2.50 1.93 2.77 2.19 2.68 2.34
Solvency Ratios
Debt to Equity
Reported 0.47 0.46 0.51 0.49 0.51 0.51
Adjusted 0.51 0.49 0.55 0.52 0.51 0.51
Debt to Capital
Reported 0.32 0.31 0.34 0.33 0.34 0.34
Adjusted 0.34 0.33 0.35 0.34 0.34 0.34
Financial Leverage
Reported 1.77 1.73 1.81 1.79 1.79 1.80
Adjusted 1.76 1.72 1.79 1.77 1.75 1.76
Profitability Ratios
Net Profit Margin
Reported 12.03% 15.90% 11.97% 16.56% 15.16% 10.36%
Adjusted 7.58% 17.79% 11.24% 9.25% 10.71% 9.76%
Return on Equity (ROE)
Reported 7.30% 9.59% 7.01% 9.44% 9.25% 6.12%
Adjusted 4.76% 11.06% 6.75% 5.36% 6.46% 5.68%
Return on Assets (ROA)
Reported 4.13% 5.54% 3.87% 5.28% 5.16% 3.40%
Adjusted 2.70% 6.42% 3.76% 3.03% 3.68% 3.22%

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

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Medtronic PLC adjusted total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Medtronic PLC adjusted current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Adjusted debt-to-equity ratio A solvency ratio calculated as adjusted total debt divided by adjusted total equity. Medtronic PLC adjusted debt-to-equity ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Adjusted debt-to-capital ratio A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. Medtronic PLC adjusted debt-to-capital ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Medtronic PLC adjusted financial leverage ratio decreased from 2021 to 2022 but then increased from 2022 to 2023 not reaching 2021 level.
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Medtronic PLC adjusted net profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted total equity. Medtronic PLC adjusted ROE improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Medtronic PLC adjusted ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Medtronic PLC, Financial Ratios: Reported vs. Adjusted


Adjusted Total Asset Turnover

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
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
Activity Ratio
Total asset turnover1 0.34 0.35 0.32 0.32 0.34 0.33
Adjusted
Selected Financial Data (US$ in millions)
Adjusted net sales2 31,233 31,717 30,182 28,901 30,583 29,953
Adjusted total assets3 87,736 87,875 90,210 88,115 88,968 90,851
Activity Ratio
Adjusted total asset turnover4 0.36 0.36 0.33 0.33 0.34 0.33

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 Adjusted net sales. See details »

3 Adjusted total assets. See details »

4 2023 Calculation
Adjusted total asset turnover = Adjusted net sales ÷ Adjusted total assets
= 31,233 ÷ 87,736 = 0.36

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Medtronic PLC adjusted total asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Adjusted Current Ratio

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Current assets 21,675 23,059 22,548 22,031 21,967 22,980
Current liabilities 9,051 12,394 8,509 10,366 8,472 10,084
Liquidity Ratio
Current ratio1 2.39 1.86 2.65 2.13 2.59 2.28
Adjusted
Selected Financial Data (US$ in millions)
Adjusted current assets2 21,851 23,289 22,789 22,239 22,157 23,173
Adjusted current liabilities3 8,737 12,089 8,233 10,153 8,261 9,888
Liquidity Ratio
Adjusted current ratio4 2.50 1.93 2.77 2.19 2.68 2.34

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
Current ratio = Current assets ÷ Current liabilities
= 21,675 ÷ 9,051 = 2.39

2 Adjusted current assets. See details »

3 Adjusted current liabilities. See details »

4 2023 Calculation
Adjusted current ratio = Adjusted current assets ÷ Adjusted current liabilities
= 21,851 ÷ 8,737 = 2.50

Liquidity ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Medtronic PLC adjusted current ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Adjusted Debt to Equity

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Total debt 24,364 24,114 26,389 24,797 25,324 25,757
Shareholders’ equity 51,483 52,551 51,428 50,737 50,091 50,720
Solvency Ratio
Debt to equity1 0.47 0.46 0.51 0.49 0.51 0.51
Adjusted
Selected Financial Data (US$ in millions)
Adjusted total debt2 25,413 24,984 27,404 25,742 25,877 26,428
Adjusted total equity3 49,796 51,009 50,271 49,887 50,712 51,488
Solvency Ratio
Adjusted debt to equity4 0.51 0.49 0.55 0.52 0.51 0.51

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
Debt to equity = Total debt ÷ Shareholders’ equity
= 24,364 ÷ 51,483 = 0.47

2 Adjusted total debt. See details »

3 Adjusted total equity. See details »

4 2023 Calculation
Adjusted debt to equity = Adjusted total debt ÷ Adjusted total equity
= 25,413 ÷ 49,796 = 0.51

Solvency ratio Description The company
Adjusted debt-to-equity ratio A solvency ratio calculated as adjusted total debt divided by adjusted total equity. Medtronic PLC adjusted debt-to-equity ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Adjusted Debt to Capital

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Total debt 24,364 24,114 26,389 24,797 25,324 25,757
Total capital 75,847 76,665 77,817 75,534 75,415 76,477
Solvency Ratio
Debt to capital1 0.32 0.31 0.34 0.33 0.34 0.34
Adjusted
Selected Financial Data (US$ in millions)
Adjusted total debt2 25,413 24,984 27,404 25,742 25,877 26,428
Adjusted total capital3 75,209 75,993 77,675 75,629 76,589 77,916
Solvency Ratio
Adjusted debt to capital4 0.34 0.33 0.35 0.34 0.34 0.34

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
Debt to capital = Total debt ÷ Total capital
= 24,364 ÷ 75,847 = 0.32

2 Adjusted total debt. See details »

3 Adjusted total capital. See details »

4 2023 Calculation
Adjusted debt to capital = Adjusted total debt ÷ Adjusted total capital
= 25,413 ÷ 75,209 = 0.34

Solvency ratio Description The company
Adjusted debt-to-capital ratio A solvency ratio calculated as adjusted total debt divided by adjusted total debt plus adjusted total equity. Medtronic PLC adjusted debt-to-capital ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Adjusted Financial Leverage

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Total assets 90,948 90,981 93,083 90,689 89,694 91,393
Shareholders’ equity 51,483 52,551 51,428 50,737 50,091 50,720
Solvency Ratio
Financial leverage1 1.77 1.73 1.81 1.79 1.79 1.80
Adjusted
Selected Financial Data (US$ in millions)
Adjusted total assets2 87,736 87,875 90,210 88,115 88,968 90,851
Adjusted total equity3 49,796 51,009 50,271 49,887 50,712 51,488
Solvency Ratio
Adjusted financial leverage4 1.76 1.72 1.79 1.77 1.75 1.76

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
Financial leverage = Total assets ÷ Shareholders’ equity
= 90,948 ÷ 51,483 = 1.77

2 Adjusted total assets. See details »

3 Adjusted total equity. See details »

4 2023 Calculation
Adjusted financial leverage = Adjusted total assets ÷ Adjusted total equity
= 87,736 ÷ 49,796 = 1.76

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Medtronic PLC adjusted financial leverage ratio decreased from 2021 to 2022 but then increased from 2022 to 2023 not reaching 2021 level.

Adjusted Net Profit Margin

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Net income attributable to Medtronic 3,758 5,039 3,606 4,789 4,631 3,104
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
Profitability Ratio
Net profit margin1 12.03% 15.90% 11.97% 16.56% 15.16% 10.36%
Adjusted
Selected Financial Data (US$ in millions)
Adjusted net income2 2,369 5,642 3,392 2,672 3,276 2,924
Adjusted net sales3 31,233 31,717 30,182 28,901 30,583 29,953
Profitability Ratio
Adjusted net profit margin4 7.58% 17.79% 11.24% 9.25% 10.71% 9.76%

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 profit margin = 100 × Net income attributable to Medtronic ÷ Net sales
= 100 × 3,758 ÷ 31,227 = 12.03%

2 Adjusted net income. See details »

3 Adjusted net sales. See details »

4 2023 Calculation
Adjusted net profit margin = 100 × Adjusted net income ÷ Adjusted net sales
= 100 × 2,369 ÷ 31,233 = 7.58%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by total revenue. Medtronic PLC adjusted net profit margin ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Adjusted Return on Equity (ROE)

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Net income attributable to Medtronic 3,758 5,039 3,606 4,789 4,631 3,104
Shareholders’ equity 51,483 52,551 51,428 50,737 50,091 50,720
Profitability Ratio
ROE1 7.30% 9.59% 7.01% 9.44% 9.25% 6.12%
Adjusted
Selected Financial Data (US$ in millions)
Adjusted net income2 2,369 5,642 3,392 2,672 3,276 2,924
Adjusted total equity3 49,796 51,009 50,271 49,887 50,712 51,488
Profitability Ratio
Adjusted ROE4 4.76% 11.06% 6.75% 5.36% 6.46% 5.68%

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
ROE = 100 × Net income attributable to Medtronic ÷ Shareholders’ equity
= 100 × 3,758 ÷ 51,483 = 7.30%

2 Adjusted net income. See details »

3 Adjusted total equity. See details »

4 2023 Calculation
Adjusted ROE = 100 × Adjusted net income ÷ Adjusted total equity
= 100 × 2,369 ÷ 49,796 = 4.76%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted total equity. Medtronic PLC adjusted ROE improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Adjusted Return on Assets (ROA)

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
Reported
Selected Financial Data (US$ in millions)
Net income attributable to Medtronic 3,758 5,039 3,606 4,789 4,631 3,104
Total assets 90,948 90,981 93,083 90,689 89,694 91,393
Profitability Ratio
ROA1 4.13% 5.54% 3.87% 5.28% 5.16% 3.40%
Adjusted
Selected Financial Data (US$ in millions)
Adjusted net income2 2,369 5,642 3,392 2,672 3,276 2,924
Adjusted total assets3 87,736 87,875 90,210 88,115 88,968 90,851
Profitability Ratio
Adjusted ROA4 2.70% 6.42% 3.76% 3.03% 3.68% 3.22%

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
ROA = 100 × Net income attributable to Medtronic ÷ Total assets
= 100 × 3,758 ÷ 90,948 = 4.13%

2 Adjusted net income. See details »

3 Adjusted total assets. See details »

4 2023 Calculation
Adjusted ROA = 100 × Adjusted net income ÷ Adjusted total assets
= 100 × 2,369 ÷ 87,736 = 2.70%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Medtronic PLC adjusted ROA improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.