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,257 51,910 53,442
Change - 28.24% 2.85% -0.73% 11% 25.64% 1.27% 2.95%
Announcement Date 2/17/22 2/21/23 2/20/24 2/20/25 2/19/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,840
Change - 28.62% 22.24% 15.42% 12.02% 9.25% -5.13% 0.82%
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 2/17/22 2/21/23 2/20/24 2/20/25 2/19/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.79% 7.04%
EBIT Margin (%) 4.59% 4.06% 4.2% 4.37% 4.4% 4.47% 4.69% 4.96%
EBT Margin (%) 3.29% 2.81% 3.4% 3.9% 4.17% 4.09% 4.34% 4.59%
Net margin (%) 2.41% 1.93% 2.41% 2.88% 3.1% 3.06% 3.23% 3.43%
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.08% 63.48% 65.47%

Profitability

        
ROA 7.29% 7.05% 7.25% 14.92% 8.03% 8.26% 8.74% 9.1%
ROE 22.07% 21.5% 22.39% 22.23% 22.97% 21.64% 22.06% 22.36%

Financial Health

        
Leverage (Debt/EBITDA) 0.76x 1.01x 0.95x 0.87x 0.9x 1.04x 0.97x 0.92x
Debt / Free cash flow 2.53x 3x 2.45x 2.9x 2.73x 4.36x 3.22x 2.89x

Capital Intensity

        
CAPEX / Current Assets (%) 2.31% 2.78% 3.21% 3.53% 3.77% 3.87% 3.51% 3.39%
CAPEX / EBITDA (%) 35.7% 47.42% 53.02% 55.99% 58.96% 59.2% 51.79% 48.1%
CAPEX / FCF (%) 118.34% 140.66% 136.28% 187.86% 178.53% 247.5% 171.16% 150.78%

Items per share

        
Cash flow per share 1 2.874 3.516 4.406 4.51 5.181 4.961 5.468 5.676
Change - 22.37% 25.31% 2.35% 14.89% -4.26% 10.23% 3.8%
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.95 16
Change - -5.58% 10.63% 9.01% 9.71% 9.38% 10.1% 6.98%
EPS 1 1.623 1.423 1.913 2.41 2.73 2.878 3.185 3.56
Change - -12.32% 34.43% 25.96% 13.28% 5.42% 10.65% 11.8%
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 2/17/22 2/21/23 2/20/24 2/20/25 2/19/26 - - -
1USD
Estimates
2027 *2028 *
P/E 41.2x 37.3x
PBR 8.74x 7.94x
EV / Sales 1.32x 1.26x
Yield 0.84% 0.88%

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
-
MarketScreener Ratings - Walmart Inc.
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
43
Last Close Price
118.70USD
Average target price
127.35USD
Spread / Average Target
+7.29%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Walmart Inc.