Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Dell Technologies Inc., profit margin by reportable segment

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Infrastructure Solutions Group (ISG) 12.65% 13.15% 10.87% 11.59% 11.78% 11.30%
Client Solutions Group (CSG) 7.18% 6.57% 7.10% 6.93% 6.85% 4.54%
VMware 30.08% 28.25% 32.89%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Infrastructure Solutions Group (ISG) Infrastructure Solutions Group (ISG) segment profit margin ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.
Client Solutions Group (CSG) Client Solutions Group (CSG) segment profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.
VMware

Segment Profit Margin: Infrastructure Solutions Group (ISG)

Dell Technologies Inc.; Infrastructure Solutions Group (ISG); segment profit margin calculation

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Reportable segment operating income 4,286 5,045 3,736 3,776 4,001 4,151
Reportable segment net revenue 33,885 38,356 34,366 32,588 33,969 36,720
Segment Profitability Ratio
Segment profit margin1 12.65% 13.15% 10.87% 11.59% 11.78% 11.30%

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 2024 Calculation
Segment profit margin = 100 × Reportable segment operating income ÷ Reportable segment net revenue
= 100 × 4,286 ÷ 33,885 = 12.65%

Segment profitability ratio Reportable segment The company
Segment profit margin Infrastructure Solutions Group (ISG) Infrastructure Solutions Group (ISG) segment profit margin ratio improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Segment Profit Margin: Client Solutions Group (CSG)

Dell Technologies Inc.; Client Solutions Group (CSG); segment profit margin calculation

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Reportable segment operating income 3,512 3,824 4,365 3,352 3,138 1,960
Reportable segment net revenue 48,916 58,213 61,464 48,355 45,838 43,196
Segment Profitability Ratio
Segment profit margin1 7.18% 6.57% 7.10% 6.93% 6.85% 4.54%

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 2024 Calculation
Segment profit margin = 100 × Reportable segment operating income ÷ Reportable segment net revenue
= 100 × 3,512 ÷ 48,916 = 7.18%

Segment profitability ratio Reportable segment The company
Segment profit margin Client Solutions Group (CSG) Client Solutions Group (CSG) segment profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Profit Margin: VMware

Dell Technologies Inc.; VMware; segment profit margin calculation

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Selected Financial Data (US$ in millions)
Reportable segment operating income 3,571 3,081 2,989
Reportable segment net revenue 11,873 10,905 9,088
Segment Profitability Ratio
Segment profit margin1 30.08% 28.25% 32.89%

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 2024 Calculation
Segment profit margin = 100 × Reportable segment operating income ÷ Reportable segment net revenue
= 100 × 0 ÷ 0 =

Segment profitability ratio Reportable segment The company
Segment profit margin VMware

Reportable segment net revenue

Dell Technologies Inc., reportable segment net revenue by reportable segment

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Infrastructure Solutions Group (ISG) 33,885 38,356 34,366 32,588 33,969 36,720
Client Solutions Group (CSG) 48,916 58,213 61,464 48,355 45,838 43,196
VMware 11,873 10,905 9,088
Total 82,801 96,569 95,830 92,816 90,712 89,004

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


Reportable segment operating income

Dell Technologies Inc., reportable segment operating income by reportable segment

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Infrastructure Solutions Group (ISG) 4,286 5,045 3,736 3,776 4,001 4,151
Client Solutions Group (CSG) 3,512 3,824 4,365 3,352 3,138 1,960
VMware 3,571 3,081 2,989
Total 7,798 8,869 8,101 10,699 10,220 9,100

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