Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Dell Technologies Inc., adjusted current assets

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Current assets 35,947 42,351 45,033 43,567 36,868 36,138
Adjustments
Add: Allowance for expected credit losses 71 78 90 104 94 85
After Adjustment
Adjusted current assets 36,018 42,429 45,123 43,671 36,962 36,223

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).


Adjustments to Total Assets

Dell Technologies Inc., adjusted total assets

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Total assets 82,089 89,611 92,735 123,415 118,861 111,820
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 1,515
Add: Allowance for expected credit losses 71 78 90 104 94 85
Less: Noncurrent deferred tax assets, net2 1,432 1,360 643 5,428 4,938
After Adjustment
Adjusted total assets 80,728 88,329 92,182 118,091 114,017 113,420

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Noncurrent deferred tax assets, net. See details »


Adjustments to Current Liabilities

Dell Technologies Inc., adjusted current liabilities

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Current liabilities 48,494 51,654 56,219 54,132 52,456 44,972
Adjustments
Less: Short-term deferred revenue 15,318 15,542 14,261 16,525 14,881 12,944
After Adjustment
Adjusted current liabilities 33,176 36,112 41,958 37,607 37,575 32,028

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).


Adjustments to Total Liabilities

Dell Technologies Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Total liabilities 84,398 92,636 94,315 115,390 115,077 111,566
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,515
Less: Noncurrent deferred tax liabilities2 1,450
Less: Deferred revenue 29,145 30,286 27,573 30,801 27,800 24,010
Less: Warranty liability 426 467 480 473 496 524
Less: Severance liability 352 408 74 138 196 146
After Adjustment
Adjusted total liabilities 54,475 61,475 66,188 83,978 86,585 86,951

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Noncurrent deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Dell Technologies Inc., adjusted total Dell Technologies Inc. stockholders’ equity (deficit)

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Total Dell Technologies Inc. stockholders’ equity (deficit) (2,404) (3,122) (1,685) 2,479 (1,574) (5,765)
Adjustments
Less: Net deferred tax assets (liabilities)1 1,432 1,360 643 5,428 4,938 (1,450)
Add: Allowance for expected credit losses 71 78 90 104 94 85
Add: Deferred revenue 29,145 30,286 27,573 30,801 27,800 24,010
Add: Warranty liability 426 467 480 473 496 524
Add: Severance liability 352 408 74 138 196 146
Add: Non-controlling interests 95 97 105 5,074 4,729 4,823
After Adjustment
Adjusted total stockholders’ equity (deficit) 26,253 26,854 25,994 33,641 26,803 25,273

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

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


Adjustments to Capitalization Table

Dell Technologies Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Short-term debt 6,982 6,573 5,823 6,362 7,737 4,320
Long-term debt 19,012 23,015 21,131 41,622 44,319 49,201
Total reported debt 25,994 29,588 26,954 47,984 52,056 53,521
Total Dell Technologies Inc. stockholders’ equity (deficit) (2,404) (3,122) (1,685) 2,479 (1,574) (5,765)
Total reported capital 23,590 26,466 25,269 50,463 50,482 47,756
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,515
Add: Current operating lease liabilities (included in Accrued and other current liabilities)2 253 260 287 436 432
Add: Non-current operating lease liabilities (included in Other non-current liabilities)3 576 630 720 1,787 1,360
Adjusted total debt 26,823 30,478 27,961 50,207 53,848 55,036
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 1,432 1,360 643 5,428 4,938 (1,450)
Add: Allowance for expected credit losses 71 78 90 104 94 85
Add: Deferred revenue 29,145 30,286 27,573 30,801 27,800 24,010
Add: Warranty liability 426 467 480 473 496 524
Add: Severance liability 352 408 74 138 196 146
Add: Non-controlling interests 95 97 105 5,074 4,729 4,823
Adjusted total stockholders’ equity (deficit) 26,253 26,854 25,994 33,641 26,803 25,273
After Adjustment
Adjusted total capital 53,076 57,332 53,955 83,848 80,651 80,309

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current operating lease liabilities (included in Accrued and other current liabilities). See details »

3 Non-current operating lease liabilities (included in Other non-current liabilities). See details »

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


Adjustments to Revenues

Dell Technologies Inc., adjusted net revenue

US$ in millions

Microsoft Excel
12 months ended: Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Net revenue 88,425 102,301 101,197 94,224 92,154 90,621
Adjustment
Add: Increase (decrease) in deferred revenue (1,141) 2,713 1,981 3,001 3,790 3,194
After Adjustment
Adjusted net revenue 87,284 105,014 103,178 97,225 95,944 93,815

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).


Adjustments to Reported Income

Dell Technologies Inc., adjusted net income (loss) attributable to Dell Technologies Inc.

US$ in millions

Microsoft Excel
12 months ended: Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,310)
Adjustments
Add: Deferred income tax expense (benefit)1 (91) (717) (221) (399) (6,339) (1,331)
Add: Increase (decrease) in allowance for expected credit losses (7) (12) (9) 10 9 (18)
Add: Increase (decrease) in deferred revenue (1,141) 2,713 1,981 3,001 3,790 3,194
Add: Increase (decrease) in warranty liability (41) (13) 7 (23) (28) (15)
Add: Increase (decrease) in severance liability (56) 334 (35) (58) 50 (29)
Less: Income from discontinued operations, net of income taxes 765
Add: Other comprehensive income (loss), net of tax 201 (571) (125) 395 (242) (533)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest (16) (21) 144 255 913 135
After Adjustment
Adjusted net income (loss) 2,060 4,155 6,540 6,431 2,769 (907)

Based on: 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31), 10-K (reporting date: 2019-02-01).

1 Deferred income tax expense (benefit). See details »