Stock Analysis on Net

Medtronic PLC (NYSE:MDT)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Medtronic PLC, adjusted current assets

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Current assets 21,675 23,059 22,548 22,031 21,967 22,980
Adjustments
Add: Allowance for doubtful accounts 176 230 241 208 190 193
After Adjustment
Adjusted current assets 21,851 23,289 22,789 22,239 22,157 23,173

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


Adjustments to Total Assets

Medtronic PLC, adjusted total assets

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Total assets 90,948 90,981 93,083 90,689 89,694 91,393
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 553 671
Add: Allowance for doubtful accounts 176 230 241 208 190 193
Less: Deferred tax assets2 3,388 3,336 3,114 2,782 1,469 1,406
After Adjustment
Adjusted total assets 87,736 87,875 90,210 88,115 88,968 90,851

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Deferred tax assets. See details »


Adjustments to Current Liabilities

Medtronic PLC, adjusted current liabilities

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Current liabilities 9,051 12,394 8,509 10,366 8,472 10,084
Adjustments
Less: Deferred revenue (included in Other accrued expenses) 314 305 276 213 211 196
After Adjustment
Adjusted current liabilities 8,737 12,089 8,233 10,153 8,261 9,888

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


Adjustments to Total Liabilities

Medtronic PLC, adjusted total liabilities

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Total liabilities 39,283 38,260 41,481 39,817 39,482 40,571
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 553 671
Less: Deferred tax liabilities2 708 884 1,028 1,174 1,278 1,423
Less: Deferred revenue 405 399 368 303 315 289
Less: Restructuring reserve 230 110 146 112 186 167
After Adjustment
Adjusted total liabilities 37,940 36,867 39,939 38,228 38,256 39,363

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Medtronic PLC, adjusted shareholders’ equity

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Shareholders’ equity 51,483 52,551 51,428 50,737 50,091 50,720
Adjustments
Less: Net deferred tax assets (liabilities)1 2,680 2,452 2,086 1,608 191 (17)
Add: Allowance for doubtful accounts 176 230 241 208 190 193
Add: Deferred revenue 405 399 368 303 315 289
Add: Restructuring reserve 230 110 146 112 186 167
Add: Noncontrolling interests 182 171 174 135 121 102
After Adjustment
Adjusted total equity 49,796 51,009 50,271 49,887 50,712 51,488

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 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

Medtronic PLC, adjusted capitalization table

US$ in millions

Microsoft Excel
Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Current debt obligations 20 3,742 11 2,776 838 2,058
Long-term debt 24,344 20,372 26,378 22,021 24,486 23,699
Total reported 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
Total reported capital 75,847 76,665 77,817 75,534 75,415 76,477
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 553 671
Add: Operating lease current liability (classified in Other accrued expenses)2 180 167 186 171
Add: Operating lease non-current liability (classified in Other liabilities)3 869 703 829 774
Adjusted total debt 25,413 24,984 27,404 25,742 25,877 26,428
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 2,680 2,452 2,086 1,608 191 (17)
Add: Allowance for doubtful accounts 176 230 241 208 190 193
Add: Deferred revenue 405 399 368 303 315 289
Add: Restructuring reserve 230 110 146 112 186 167
Add: Noncontrolling interests 182 171 174 135 121 102
Adjusted total equity 49,796 51,009 50,271 49,887 50,712 51,488
After Adjustment
Adjusted total capital 75,209 75,993 77,675 75,629 76,589 77,916

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease current liability (classified in Other accrued expenses). See details »

3 Operating lease non-current liability (classified in Other liabilities). See details »

4 Net deferred tax assets (liabilities). See details »


Adjustments to Revenues

Medtronic PLC, adjusted net sales

US$ in millions

Microsoft Excel
12 months ended: Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Net sales 31,227 31,686 30,117 28,913 30,557 29,953
Adjustment
Add: Increase (decrease) in deferred revenue 6 31 65 (12) 26
After Adjustment
Adjusted net sales 31,233 31,717 30,182 28,901 30,583 29,953

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


Adjustments to Reported Income

Medtronic PLC, adjusted net income attributable to Medtronic

US$ in millions

Microsoft Excel
12 months ended: Apr 28, 2023 Apr 29, 2022 Apr 30, 2021 Apr 24, 2020 Apr 26, 2019 Apr 27, 2018
As Reported
Net income attributable to Medtronic 3,758 5,039 3,606 4,789 4,631 3,104
Adjustments
Add: Deferred income tax expense (benefit)1 (253) (611) (461) (1,277) (438) (1,115)
Add: Increase (decrease) in allowance for doubtful accounts (54) (11) 33 18 (3) 38
Add: Increase (decrease) in deferred revenue 6 31 65 (12) 26
Add: Increase (decrease) in restructuring reserve 120 (36) 34 (10) 19 (124)
Add: Other comprehensive income (loss), net of tax (1,234) 1,213 83 (851) (975) 1,030
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 26 17 32 15 16 (9)
After Adjustment
Adjusted net income 2,369 5,642 3,392 2,672 3,276 2,924

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 Deferred income tax expense (benefit). See details »