Projected Income Statement: Dell Technologies Inc.

Forecast Balance Sheet: Dell Technologies Inc.

Fiscal Period: January 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 17,477 20,981 18,628 20,934 19,975 18,294 15,993 14,234
Change - 20.05% -11.21% 12.38% -4.58% -8.42% -12.58% -11%
Announcement Date 24/02/22 02/03/23 29/02/24 27/02/25 26/02/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Dell Technologies Inc.

Fiscal Period: January 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 2,796 3,003 2,753 2,563 2,630 3,038 3,166 3,345
Change - 7.4% -8.33% -6.9% 2.61% 15.5% 4.22% 5.67%
Free Cash Flow (FCF) 1 7,511 562 5,923 1,958 8,555 9,340 9,887 11,269
Change - -92.52% 953.91% -66.94% 336.93% 9.17% 5.86% 13.98%
Announcement Date 24/02/22 02/03/23 29/02/24 27/02/25 26/02/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Dell Technologies Inc.

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

Profitability

        
EBITDA Margin (%) 9.54% 10.54% 11.48% 11.49% 11.03% 10.41% 10.53% 10.49%
EBIT Margin (%) 7.69% 8.44% 8.68% 8.92% 8.8% 8.24% 8.4% 8.79%
EBT Margin (%) 5.85% 3.15% 4.4% 5.28% 6.4% 6.62% 6% 7.45%
Net margin (%) 5.5% 2.39% 3.63% 4.81% 5.23% 5.16% 5.15% 5.98%
FCF margin (%) 7.42% 0.55% 6.7% 2.05% 7.53% 6.57% 6.45% 6.98%
FCF / Net Income (%) 135.02% 23.01% 184.46% 42.64% 144.12% 127.41% 125.07% 116.65%

Profitability

        
ROA 5.15% 6.29% 6.11% 7.2% 7.78% 8.31% 8.35% 9.45%
ROE 1,240.05% - - - - 1,338.89% 357.52% 197.94%

Financial Health

        
Leverage (Debt/EBITDA) 1.81x 1.95x 1.84x 1.91x 1.6x 1.24x 0.99x 0.84x
Debt / Free cash flow 2.33x 37.33x 3.15x 10.69x 2.33x 1.96x 1.62x 1.26x

Capital Intensity

        
CAPEX / Current Assets (%) 2.76% 2.94% 3.11% 2.68% 2.32% 2.14% 2.06% 2.07%
CAPEX / EBITDA (%) 28.94% 27.86% 27.13% 23.33% 21% 20.52% 19.6% 19.75%
CAPEX / FCF (%) 37.23% 534.34% 46.48% 130.9% 30.74% 32.53% 32.02% 29.69%

Items per share

        
Cash flow per share 1 13.03 4.734 11.76 6.281 16.35 22.83 25.84 24.96
Change - -63.67% 148.31% -46.57% 160.33% 39.64% 13.15% -3.4%
Dividend per Share 1 - 1.32 1.48 1.78 1.78 2.46 2.771 3.043
Change - - 12.12% 20.27% 0% 38.19% 12.65% 9.8%
Book Value Per Share 1 -2.211 -4.141 -3.368 -2.102 -3.601 -2.996 5.608 3.95
Change - -87.25% 18.66% 37.58% -71.29% 16.78% 287.14% -29.56%
EPS 1 7.03 3.24 4.36 6.38 8.68 11.17 12.61 15.43
Change - -53.91% 34.57% 46.33% 36.05% 28.73% 12.83% 22.36%
Nbr of stocks (in thousands) 7,63,885 7,16,128 7,06,335 6,97,705 6,62,690 6,49,568 6,49,568 6,49,568
Announcement Date 24/02/22 02/03/23 29/02/24 27/02/25 26/02/26 - - -
1USD
Estimates
2027 *2028 *
P/E ratio 21.3x 18.9x
PBR -79.4x 42.4x
EV / Sales 1.22x 1.11x
Yield 1.03% 1.16%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
-
Global
-
Quality
-
ESG MSCI
A
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
27
Last Close Price
238.03USD
Average target price
203.09USD
Spread / Average Target
-14.68%

Quarterly revenue - Rate of surprise

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