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 7,103 6,919 5,999
Change - -50.47% 18.17% -9.55% -22.62% 10.3% -2.59% -13.3%
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,218 1,162 1,162
Change - 0.36% 25.74% 22.09% -34.77% -11.77% -4.64% 0.02%
Free Cash Flow (FCF) 1 4,111 4,176 2,165 141 -363 -298.2 226 1,039
Change - 1.58% -48.16% -93.49% -357.45% -17.84% -175.8% 359.59%
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.17% 2.08% 2.29%
EBIT Margin (%) 3.73% 3.86% 3.87% 2.78% 1.78% 1.18% 1.15% 1.29%
EBT Margin (%) 0.53% 1.51% 3% -3.9% -9.63% -0.89% -0.47% 0.13%
Net margin (%) 0.33% 1.92% 3.27% -2.21% -5.85% -0.45% -0.31% 0.21%
FCF margin (%) 2.95% 3.15% 1.63% 0.1% -0.25% -0.2% 0.15% 0.66%
FCF / Net Income (%) 901.54% 164.28% 49.92% -4.58% 4.2% 43.95% -46.64% 321.17%

Profitability

        
ROA 0.59% 5.46% 5.06% 3.68% -9.72% -1.62% -0.21% 0.49%
ROE 18.91% 20.45% 16.39% 11.92% 12.35% 13.06% 14.28% 16.34%

Financial Health

        
Leverage (Debt/EBITDA) 2.2x 1.19x 1.47x 1.66x 1.61x 2.15x 2.15x 1.66x
Debt / Free cash flow 3.82x 1.86x 4.25x 59.03x -17.74x -23.82x 30.61x 5.77x

Capital Intensity

        
CAPEX / Current Assets (%) 0.98% 1.04% 1.31% 1.52% 0.94% 0.8% 0.75% 0.74%
CAPEX / EBITDA (%) 19.25% 21% 27.66% 42.32% 34.46% 36.94% 36.04% 32.22%
CAPEX / FCF (%) 33.42% 33.02% 80.09% 1,501.42% -380.44% -408.58% 514.01% 111.87%

Items per share

        
Cash flow per share 1 6.23 6.412 4.503 2.616 1.18 1.882 2.488 3.132
Change - 2.92% -29.77% -41.91% -54.91% 59.56% 32.18% 25.91%
Dividend per Share 1 1.87 1.88 1.912 1.92 1.23 0.8 1 1
Change - 0.53% 1.73% 0.39% -35.94% -34.96% 25% 0%
Book Value Per Share 1 23.84 27.53 33.96 32.81 13.91 11.37 10.69 11.05
Change - 15.46% 23.38% -3.39% -57.61% -18.22% -6.05% 3.42%
EPS 1 0.52 2.93 5.01 -3.57 -10.01 -0.5794 -0.2668 0.3873
Change - 463.46% 70.99% -171.26% 180.39% -94.21% -53.95% -245.18%
Nbr of stocks (in thousands) 866,534 864,987 864,257 863,261 863,275 864,153 864,153 864,153
Announcement Date 10/15/20 10/14/21 10/13/22 10/12/23 10/15/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio -16.7x -36.4x
PBR 0.85x 0.91x
EV / Sales 0.1x 0.1x
Yield 8.25% 10.3%
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
18
Last Close Price
9.750USD
Average target price
12.35USD
Spread / Average Target
+26.64%
Consensus

Quarterly revenue - Rate of surprise

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