Projected Income Statement: Dell Technologies Inc.

Forecast Balance Sheet: Dell Technologies Inc.

Fiscal Period: January 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 33,783 17,477 20,981 18,628 20,934 20,666 19,458 18,110
Change - -48.27% 20.05% -11.21% 12.38% -1.28% -5.85% -6.93%
Announcement Date 25/02/21 24/02/22 02/03/23 29/02/24 27/02/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Dell Technologies Inc.

Fiscal Period: January 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 2,082 2,796 3,003 2,753 2,563 2,749 2,995 3,118
Change - 34.29% 7.4% -8.33% -6.9% 7.25% 8.97% 4.09%
Free Cash Flow (FCF) 1 9,325 7,511 562 5,923 1,958 6,697 7,999 8,488
Change - -19.45% -92.52% 953.91% -66.94% 242.03% 19.44% 6.11%
Announcement Date 25/02/21 24/02/22 02/03/23 29/02/24 27/02/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Dell Technologies Inc.

Fiscal Period: January 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 13.5% 9.54% 10.54% 11.48% 11.49% 10.96% 10.87% 11.19%
EBIT Margin (%) 11.44% 7.69% 8.44% 8.68% 8.92% 8.67% 8.56% 8.68%
EBT Margin (%) 3.89% 5.85% 3.15% 4.4% 5.28% 6.09% 5.97% 6.38%
Net margin (%) 3.44% 5.5% 2.39% 3.63% 4.81% 5.12% 5.01% 5.34%
FCF margin (%) 9.88% 7.42% 0.55% 6.7% 2.05% 5.99% 6.45% 6.39%
FCF / Net Income (%) 286.92% 135.02% 23.01% 184.46% 42.64% 116.9% 128.72% 119.67%

Profitability

        
ROA 2.68% 5.15% 6.29% 6.11% 7.2% 6.55% 6.9% 7.4%
ROE 718.23% 1,240.05% - - - - 4,677.8% 771.03%

Financial Health

        
Leverage (Debt/EBITDA) 2.65x 1.81x 1.95x 1.84x 1.91x 1.69x 1.44x 1.22x
Debt / Free cash flow 3.62x 2.33x 37.33x 3.15x 10.69x 3.09x 2.43x 2.13x

Capital Intensity

        
CAPEX / Current Assets (%) 2.21% 2.76% 2.94% 3.11% 2.68% 2.46% 2.41% 2.35%
CAPEX / EBITDA (%) 16.33% 28.94% 27.86% 27.13% 23.33% 22.42% 22.22% 20.97%
CAPEX / FCF (%) 22.33% 37.23% 534.34% 46.48% 130.9% 41.04% 37.45% 36.73%

Items per share

        
Cash flow per share 1 14.87 13.03 4.734 11.76 6.281 16.02 18.71 18.89
Change - -12.37% -63.67% 148.31% -46.57% 155% 16.79% 0.98%
Dividend per Share 1 - - 1.32 1.48 1.78 2.081 2.318 2.583
Change - - - 12.12% 20.27% 16.89% 11.4% 11.46%
Book Value Per Share 1 3.292 -2.211 -4.141 -3.368 -2.102 -2.124 3.542 7.234
Change - -167.17% -87.25% 18.66% 37.58% -1.02% 266.8% 104.23%
EPS 1 4.22 7.03 3.24 4.36 6.38 8.322 9.29 10.72
Change - 66.59% -53.91% 34.57% 46.33% 30.45% 11.63% 15.39%
Nbr of stocks (in thousands) 749,804 763,885 716,128 706,335 697,705 662,690 662,690 662,690
Announcement Date 25/02/21 24/02/22 02/03/23 29/02/24 27/02/25 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 13.6x 12.2x
PBR -53.3x 32x
EV / Sales 0.86x 0.76x
Yield 1.84% 2.05%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
25
Last Close Price
113.26USD
Average target price
161.91USD
Spread / Average Target
+42.96%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. DELL Stock
  4. Financials Dell Technologies Inc.