Projected Income Statement: Diageo plc

Forecast Balance Sheet: Diageo plc

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 17,295 16,871 16,657 19,195 20,371 21,114 20,397 19,555
Change - -2.45% -1.27% 15.24% 6.13% 3.65% -3.4% -4.13%
Announcement Date 04/08/20 29/07/21 28/07/22 01/08/23 30/07/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Diageo plc

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 895.7 874.5 1,330 1,504 1,510 1,478 1,318 1,176
Change - -2.37% 52.14% 13.02% 0.42% -2.12% -10.85% -10.78%
Free Cash Flow (FCF) 1 2,133 4,230 3,442 3,511 2,595 2,580 3,356 3,725
Change - 98.26% -18.63% 2% -26.08% -0.59% 30.08% 10.99%
Announcement Date 04/08/20 29/07/21 28/07/22 01/08/23 30/07/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Diageo plc

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

Profitability

        
EBITDA Margin (%) 33.93% 32.93% 36.4% 35.76% 34.72% 31.52% 31.89% 32.2%
EBIT Margin (%) 29.73% 29.42% 31.04% 30.7% 29.33% 27.62% 28.03% 28.28%
EBT Margin (%) 17.38% 29.11% 28.39% 27.67% 26.94% 23.68% 25.27% 26.31%
Net margin (%) 11.99% 20.89% 21.03% 21.82% 19.09% 16.95% 18.14% 18.86%
FCF margin (%) 13.9% 23.78% 18.37% 16.1% 12.8% 12.78% 16.22% 17.38%
FCF / Net Income (%) 115.94% 113.83% 87.35% 73.78% 67.05% 75.38% 89.39% 92.12%

Profitability

        
ROA 7.94% 8.41% 10.28% 10.26% 8.88% 7.62% 7.76% 8.1%
ROE 33.91% 40.18% 47.91% 47.39% 40.35% 34.34% 32.85% 30.67%

Financial Health

        
Leverage (Debt/EBITDA) 3.32x 2.88x 2.44x 2.46x 2.89x 3.32x 3.09x 2.83x
Debt / Free cash flow 8.11x 3.99x 4.84x 5.47x 7.85x 8.18x 6.08x 5.25x

Capital Intensity

        
CAPEX / Current Assets (%) 5.84% 4.92% 7.1% 6.9% 7.45% 7.32% 6.37% 5.48%
CAPEX / EBITDA (%) 17.2% 14.93% 19.5% 19.28% 21.46% 23.23% 19.97% 17.03%
CAPEX / FCF (%) 41.98% 20.67% 38.65% 42.83% 58.19% 57.29% 39.26% 31.56%

Items per share

        
Cash flow per share 1 1.287 2.171 2.053 1.697 1.833 1.95 2.15 2.261
Change - 68.7% -5.45% -17.33% 8.05% 6.35% 10.24% 5.18%
Dividend per Share 1 0.9127 1.013 0.9239 1.019 1.005 1.03 1.04 1.081
Change - 11.04% -8.84% 10.34% -1.44% 2.55% 0.92% 3.93%
Book Value Per Share 1 3.769 4.11 4.151 4.394 4.491 4.772 5.428 6.182
Change - 9.05% 1% 5.84% 2.21% 6.27% 13.75% 13.87%
EPS 1 0.7823 1.584 1.694 2.095 1.728 1.535 1.676 1.794
Change - 102.49% 6.95% 23.65% -17.52% -11.16% 9.16% 7.09%
Nbr of stocks (in thousands) 23,34,335 23,34,775 22,78,906 22,45,879 22,19,979 22,22,326 22,22,326 22,22,326
Announcement Date 04/08/20 29/07/21 28/07/22 01/08/23 30/07/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 16.5x 15.1x
PBR 5.33x 4.68x
EV / Sales 3.84x 3.72x
Yield 4.06% 4.1%
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
AAA
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
23
Last Close Price
25.42USD
Average target price
32.50USD
Spread / Average Target
+27.86%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. DGE Stock
  4. Financials Diageo plc