Projected Income Statement: 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 52,301 51,119 52,425
Change - 28.24% 2.85% -0.73% 11% 28.2% -2.26% 2.55%
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 28,485 27,599 27,828
Change - 28.62% 22.24% 15.42% 12.02% 6.92% -3.11% 0.83%
Free Cash Flow (FCF) 1 11,075 11,984 15,120 12,660 14,923 11,705 16,183 18,523
Change - 8.21% 26.17% -16.27% 17.88% -21.56% 38.25% 14.46%
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.54% 6.79% 7.04%
EBIT Margin (%) 4.59% 4.06% 4.2% 4.37% 4.4% 4.48% 4.69% 4.96%
EBT Margin (%) 3.29% 2.81% 3.4% 3.9% 4.17% 4.09% 4.33% 4.58%
Net margin (%) 2.41% 1.93% 2.41% 2.88% 3.1% 3.05% 3.23% 3.42%
FCF margin (%) 1.95% 1.98% 2.35% 1.88% 2.11% 1.55% 2.06% 2.25%
FCF / Net Income (%) 81% 102.6% 97.48% 65.14% 68.16% 50.92% 63.72% 65.86%

Profitability

        
ROA 7.29% 7.05% 7.25% 14.92% 8.03% 8.18% 8.59% 9.04%
ROE 22.07% 21.5% 22.39% 22.23% 22.97% 21.63% 21.98% 22.26%

Financial Health

        
Leverage (Debt/EBITDA) 0.76x 1.01x 0.95x 0.87x 0.9x 1.06x 0.96x 0.9x
Debt / Free cash flow 2.53x 3x 2.45x 2.9x 2.73x 4.47x 3.16x 2.83x

Capital Intensity

        
CAPEX / Current Assets (%) 2.31% 2.78% 3.21% 3.53% 3.77% 3.78% 3.51% 3.38%
CAPEX / EBITDA (%) 35.7% 47.42% 53.02% 55.99% 58.96% 57.85% 51.72% 47.98%
CAPEX / FCF (%) 118.34% 140.66% 136.28% 187.86% 178.53% 243.35% 170.54% 150.23%

Items per share

        
Cash flow per share 1 2.874 3.516 4.406 4.51 5.181 4.95 5.42 5.539
Change - 22.37% 25.31% 2.35% 14.89% -4.47% 9.5% 2.2%
Dividend per Share 1 0.7333 0.7467 0.76 0.83 0.94 0.997 1.044 1.1
Change - 1.82% 1.79% 9.21% 13.25% 6.06% 4.76% 5.31%
Book Value Per Share 1 9.939 9.385 10.38 11.32 12.42 13.63 15.02 16.11
Change - -5.58% 10.63% 9.01% 9.71% 9.79% 10.15% 7.25%
EPS 1 1.623 1.423 1.913 2.41 2.73 2.88 3.185 3.559
Change - -12.32% 34.43% 25.96% 13.28% 5.49% 10.61% 11.72%
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 37.2x 33.6x
PBR 7.86x 7.13x
EV / Sales 1.2x 1.15x
Yield 0.93% 0.97%

EPS & Dividend



Y-o-Y evolution of P/E

 

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
43
Last Close Price
107.14USD
Average target price
127.72USD
Spread / Average Target
+19.21%

Quarterly revenue - Rate of surprise

40% Discount: Identify Tomorrow's Best Investments With The Best Subscriber-Only Tools!
d
:
:
SEIZE THE OFFER!