Projected Income Statement: Diageo plc

Forecast Balance Sheet: Diageo plc

balance-sheet-analysis-chart 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 20,401 19,829 18,982
Change - -2.45% -1.27% 15.24% 6.13% 0.15% -2.8% -4.27%
Announcement Date 8/4/20 7/29/21 7/28/22 8/1/23 7/30/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,435 1,350 1,155
Change - -2.37% 52.14% 13.02% 0.42% -4.95% -5.95% -14.45%
Free Cash Flow (FCF) 1 2,133 4,230 3,442 3,511 2,595 2,953 3,230 3,740
Change - 98.26% -18.63% 2% -26.08% 13.79% 9.4% 15.76%
Announcement Date 8/4/20 7/29/21 7/28/22 8/1/23 7/30/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.91% 32.02% 32.22%
EBIT Margin (%) 29.73% 29.42% 31.04% 30.7% 29.33% 28.36% 28.59% 28.85%
EBT Margin (%) 17.38% 29.11% 28.39% 27.67% 26.94% 25.24% 25.46% 26.24%
Net margin (%) 11.99% 20.89% 21.03% 21.82% 19.09% 18.22% 18.57% 19.16%
FCF margin (%) 13.9% 23.78% 18.37% 16.1% 12.8% 14.65% 15.5% 17.22%
FCF / Net Income (%) 115.94% 113.83% 87.35% 73.78% 67.05% 80.41% 83.47% 89.89%

Profitability

        
ROA 7.94% 8.41% 10.28% 10.26% 8.88% 7.84% 7.73% 8.08%
ROE 33.91% 40.18% 47.91% 47.39% 40.35% 33.87% 31.41% 29.84%

Financial Health

        
Leverage (Debt/EBITDA) 3.32x 2.88x 2.44x 2.46x 2.89x 3.17x 2.97x 2.71x
Debt / Free cash flow 8.11x 3.99x 4.84x 5.47x 7.85x 6.91x 6.14x 5.08x

Capital Intensity

        
CAPEX / Current Assets (%) 5.84% 4.92% 7.1% 6.9% 7.45% 7.12% 6.48% 5.32%
CAPEX / EBITDA (%) 17.2% 14.93% 19.5% 19.28% 21.46% 22.31% 20.23% 16.51%
CAPEX / FCF (%) 41.98% 20.67% 38.65% 42.83% 58.19% 48.61% 41.79% 30.88%

Items per share

        
Cash flow per share 1 1.287 2.171 2.053 1.697 1.833 2.114 2.154 2.304
Change - 68.7% -5.45% -17.33% 8.05% 15.33% 1.89% 6.94%
Dividend per Share 1 0.9127 1.013 0.9239 1.019 1.005 1.046 1.081 1.13
Change - 11.04% -8.84% 10.34% -1.44% 4.09% 3.36% 4.54%
Book Value Per Share 1 3.769 4.11 4.151 4.394 4.491 5.157 5.831 6.659
Change - 9.05% 1% 5.84% 2.21% 14.83% 13.07% 14.2%
EPS 1 0.7823 1.584 1.694 2.095 1.728 1.658 1.743 1.875
Change - 102.49% 6.95% 23.65% -17.52% -4.05% 5.12% 7.59%
Nbr of stocks (in thousands) 2,334,335 2,334,775 2,278,906 2,245,879 2,219,979 2,222,120 2,222,120 2,222,120
Announcement Date 8/4/20 7/29/21 7/28/22 8/1/23 7/30/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 18.8x 17.9x
PBR 6.03x 5.34x
EV / Sales 4.44x 4.27x
Yield 3.36% 3.47%
More valuation ratios * Estimated data

EPS & Dividend

eps-dividend-chart DIAGEO-PLC

Year-on-year evolution of the PER

evolution-chart DIAGEO-PLC

Year-on-year evolution of the Yield

evolution-chart DIAGEO-PLC
Trading Rating
Investor Rating
ESG Refinitiv
A-
surperformance-ratings-light-chart DIAGEO-PLCMore Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
22
Last Close Price
31.11USD
Average target price
33.85USD
Spread / Average Target
+8.80%
Consensus

Quarterly revenue - Rate of surprise

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