Projected Income Statement: Walgreens Boots Alliance, Inc.

Forecast Balance Sheet: Walgreens Boots Alliance, Inc.

Fiscal Period: August 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 15,722 7,787 9,202 8,323 6,440 6,287 6,844 6,206
Change - -50.47% 18.17% -9.55% -22.62% -2.38% 8.86% -9.32%
Announcement Date 10/15/20 10/14/21 10/13/22 10/12/23 10/15/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Walgreens Boots Alliance, Inc.

Fiscal Period: August 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 1,374 1,379 1,734 2,117 1,381 1,191 1,177 1,168
Change - 0.36% 25.74% 22.09% -34.77% -13.77% -1.19% -0.74%
Free Cash Flow (FCF) 1 4,111 4,176 2,165 141 -363 -378.8 408.4 850.3
Change - 1.58% -48.16% -93.49% -357.45% -4.35% 207.82% 108.2%
Announcement Date 10/15/20 10/14/21 10/13/22 10/12/23 10/15/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Walgreens Boots Alliance, Inc.

Fiscal Period: August 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 5.12% 4.96% 4.72% 3.6% 2.71% 2.3% 2.22% 2.38%
EBIT Margin (%) 3.73% 3.86% 3.87% 2.78% 1.78% 1.32% 1.22% 1.31%
EBT Margin (%) 0.53% 1.51% 3% -3.9% -9.63% -3.74% -0.71% -0.49%
Net margin (%) 0.33% 1.92% 3.27% -2.21% -5.85% -2.22% -0.29% 0.15%
FCF margin (%) 2.95% 3.15% 1.63% 0.1% -0.25% -0.25% 0.27% 0.54%
FCF / Net Income (%) 901.54% 164.28% 49.92% -4.58% 4.2% 11.28% -90.21% 365.76%

Profitability

        
ROA 0.59% 5.46% 5.06% 3.68% -9.72% -4.6% -0.55% -
ROE 18.91% 20.45% 16.39% 11.92% 12.35% 15.55% 15.28% 16.57%

Financial Health

        
Leverage (Debt/EBITDA) 2.2x 1.19x 1.47x 1.66x 1.61x 1.8x 2.01x 1.65x
Debt / Free cash flow 3.82x 1.86x 4.25x 59.03x -17.74x -16.6x 16.76x 7.3x

Capital Intensity

        
CAPEX / Current Assets (%) 0.98% 1.04% 1.31% 1.52% 0.94% 0.79% 0.76% 0.74%
CAPEX / EBITDA (%) 19.25% 21% 27.66% 42.32% 34.46% 34.09% 34.49% 31.12%
CAPEX / FCF (%) 33.42% 33.02% 80.09% 1,501.42% -380.44% -314.39% 288.12% 137.36%

Items per share

        
Cash flow per share 1 6.23 6.412 4.503 2.616 1.18 2.404 2.243 3.077
Change - 2.92% -29.77% -41.91% -54.91% 103.81% -6.68% 37.18%
Dividend per Share 1 1.87 1.88 1.912 1.92 1.23 0.7225 0.84 0.76
Change - 0.53% 1.73% 0.39% -35.94% -41.26% 16.26% -9.52%
Book Value Per Share 1 23.84 27.53 33.96 32.81 13.91 9.206 9.726 10.97
Change - 15.46% 23.38% -3.39% -57.61% -33.81% 5.65% 12.8%
EPS 1 0.52 2.93 5.01 -3.57 -10.01 -3.89 -0.3097 0.3073
Change - 463.46% 70.99% -171.26% -180.39% 61.14% 92.04% 199.25%
Nbr of stocks (in thousands) 866,534 864,987 864,257 863,261 863,275 864,959 864,959 864,959
Announcement Date 10/15/20 10/14/21 10/13/22 10/12/23 10/15/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio -2.93x -36.8x
PBR 1.24x 1.17x
EV / Sales 0.11x 0.11x
Yield 6.34% 7.37%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
14
Last Close Price
11.39USD
Average target price
12.41USD
Spread / Average Target
+8.98%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. WBA Stock
  4. Financials Walgreens Boots Alliance, Inc.