Projected Income Statement: Walmart Inc.

Forecast Balance Sheet: Walmart Inc.

Forecast Balance Sheet - Walmart Inc.
Fiscal Period: January 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 28,071 35,997 37,024 36,753 40,796 51,277 52,064 53,879
Change - 28.24% 2.85% -0.73% 11% 25.69% 1.53% 3.49%
Announcement Date 17/2/22 21/2/23 20/2/24 20/2/25 19/2/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Walmart Inc.

Fiscal Period: January 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 13,106 16,857 20,606 23,783 26,642 29,106 27,613 27,818
Change - 28.62% 22.24% 15.42% 12.02% 9.25% -5.13% 0.75%
Free Cash Flow (FCF) 1 11,075 11,984 15,120 12,660 14,923 11,760 16,132 18,463
Change - 8.21% 26.17% -16.27% 17.88% -21.2% 37.18% 14.45%
Announcement Date 17/2/22 21/2/23 20/2/24 20/2/25 19/2/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Walmart Inc.

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

Profitability

        
EBITDA Margin (%) 6.47% 5.87% 6.05% 6.3% 6.4% 6.53% 6.78% 7.03%
EBIT Margin (%) 4.59% 4.06% 4.2% 4.37% 4.4% 4.47% 4.69% 4.95%
EBT Margin (%) 3.29% 2.81% 3.4% 3.9% 4.17% 4.09% 4.33% 4.57%
Net margin (%) 2.41% 1.93% 2.41% 2.88% 3.1% 3.06% 3.23% 3.41%
FCF margin (%) 1.95% 1.98% 2.35% 1.88% 2.11% 1.56% 2.05% 2.25%
FCF / Net Income (%) 81% 102.6% 97.48% 65.14% 68.16% 51.1% 63.61% 65.78%

Profitability

        
ROA 7.29% 7.05% 7.25% 14.92% 8.03% 8.25% 8.69% 8.97%
ROE 22.07% 21.5% 22.39% 22.23% 22.97% 21.63% 22.01% 22.28%

Financial Health

        
Leverage (Debt/EBITDA) 0.76x 1.01x 0.95x 0.87x 0.9x 1.04x 0.98x 0.93x
Debt / Free cash flow 2.53x 3x 2.45x 2.9x 2.73x 4.36x 3.23x 2.92x

Capital Intensity

        
CAPEX / Current Assets (%) 2.31% 2.78% 3.21% 3.53% 3.77% 3.87% 3.51% 3.38%
CAPEX / EBITDA (%) 35.7% 47.42% 53.02% 55.99% 58.96% 59.21% 51.84% 48.15%
CAPEX / FCF (%) 118.34% 140.66% 136.28% 187.86% 178.53% 247.5% 171.16% 150.67%

Items per share

        
Cash flow per share 1 2.874 3.516 4.406 4.51 5.181 4.956 5.435 5.584
Change - 22.37% 25.31% 2.35% 14.89% -4.35% 9.68% 2.72%
Dividend per Share 1 0.7333 0.7467 0.76 0.83 0.94 0.9964 1.05 1.108
Change - 1.82% 1.79% 9.21% 13.25% 6% 5.41% 5.52%
Book Value Per Share 1 9.939 9.385 10.38 11.32 12.42 13.58 14.94 15.94
Change - -5.58% 10.63% 9.01% 9.71% 9.36% 9.99% 6.73%
EPS 1 1.623 1.423 1.913 2.41 2.73 2.877 3.179 3.542
Change - -12.32% 34.43% 25.96% 13.28% 5.37% 10.51% 11.43%
Nbr of stocks (in thousands) 8,321,635 8,090,400 8,076,701 8,033,386 7,970,167 7,933,746 7,933,746 7,933,746
Announcement Date 17/2/22 21/2/23 20/2/24 20/2/25 19/2/26 - - -
1USD
Estimates
2027 *2028 *
P/E 37.6x 34x
PBR 7.96x 7.24x
EV / Sales 1.21x 1.16x
Yield 0.92% 0.97%

EPS & Dividend

EPS & Dividend - Walmart Inc.


Y-o-Y evolution of P/E

Valuation ratios - P/E - Walmart Inc.
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Walmart Inc.
Trader
Investor
Global
Quality
ESG MSCI
BBB
Ratings Surperformance© - Walmart Inc.
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
43
Last Close Price
108.16USD
Average target price
126.78USD
Spread / Average Target
+17.21%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Walmart Inc.
  1. Stock Market
  2. Stocks
  3. WMT Stock
  4. Financials Walmart Inc.