Stock Analysis on Net
Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

Analysis of Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Dell Technologies Inc., adjustment to 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
Net income (loss) attributable to Dell Technologies Inc. (as reported) 3,211 2,442 5,563 3,250 4,616 (2,310)
Add: Net change in market value of investments — — — — — 45
Net income (loss) attributable to Dell Technologies Inc. (adjusted) 3,211 2,442 5,563 3,250 4,616 (2,265)

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

Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Dell Technologies Inc., adjusted profitability ratios

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Net Profit Margin
Reported net profit margin 3.63% 2.39% 5.50% 3.45% 5.01% -2.55%
Adjusted net profit margin 3.63% 2.39% 5.50% 3.45% 5.01% -2.50%
Return on Equity (ROE)
Reported ROE — — — 131.10% — —
Adjusted ROE — — — 131.10% — —
Return on Assets (ROA)
Reported ROA 3.91% 2.73% 6.00% 2.63% 3.88% -2.07%
Adjusted ROA 3.91% 2.73% 6.00% 2.63% 3.88% -2.03%

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

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Dell Technologies Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Dell Technologies Inc. adjusted ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Dell Technologies Inc., Profitability Ratios: Reported vs. Adjusted

Adjusted Net Profit Margin

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,310)
Net revenue 88,425 102,301 101,197 94,224 92,154 90,621
Profitability Ratio
Net profit margin1 3.63% 2.39% 5.50% 3.45% 5.01% -2.55%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,265)
Net revenue 88,425 102,301 101,197 94,224 92,154 90,621
Profitability Ratio
Adjusted net profit margin2 3.63% 2.39% 5.50% 3.45% 5.01% -2.50%

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

2024 Calculations

1 Net profit margin = 100 × Net income (loss) attributable to Dell Technologies Inc. ÷ Net revenue
= 100 × 3,211 ÷ 88,425 = 3.63%

2 Adjusted net profit margin = 100 × Adjusted net income (loss) attributable to Dell Technologies Inc. ÷ Net revenue
= 100 × 3,211 ÷ 88,425 = 3.63%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Dell Technologies Inc. adjusted net profit margin ratio deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Adjusted Return on Equity (ROE)

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,310)
Total Dell Technologies Inc. stockholders’ equity (deficit) (2,404) (3,122) (1,685) 2,479 (1,574) (5,765)
Profitability Ratio
ROE1 — — — 131.10% — —
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,265)
Total Dell Technologies Inc. stockholders’ equity (deficit) (2,404) (3,122) (1,685) 2,479 (1,574) (5,765)
Profitability Ratio
Adjusted ROE2 — — — 131.10% — —

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

2024 Calculations

1 ROE = 100 × Net income (loss) attributable to Dell Technologies Inc. ÷ Total Dell Technologies Inc. stockholders’ equity (deficit)
= 100 × 3,211 ÷ -2,404 = —

2 Adjusted ROE = 100 × Adjusted net income (loss) attributable to Dell Technologies Inc. ÷ Total Dell Technologies Inc. stockholders’ equity (deficit)
= 100 × 3,211 ÷ -2,404 = —

Adjusted Return on Assets (ROA)

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,310)
Total assets 82,089 89,611 92,735 123,415 118,861 111,820
Profitability Ratio
ROA1 3.91% 2.73% 6.00% 2.63% 3.88% -2.07%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,265)
Total assets 82,089 89,611 92,735 123,415 118,861 111,820
Profitability Ratio
Adjusted ROA2 3.91% 2.73% 6.00% 2.63% 3.88% -2.03%

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

2024 Calculations

1 ROA = 100 × Net income (loss) attributable to Dell Technologies Inc. ÷ Total assets
= 100 × 3,211 ÷ 82,089 = 3.91%

2 Adjusted ROA = 100 × Adjusted net income (loss) attributable to Dell Technologies Inc. ÷ Total assets
= 100 × 3,211 ÷ 82,089 = 3.91%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Dell Technologies Inc. adjusted ROA deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.