Projected Income Statement: Diageo plc

Forecast Balance Sheet: Diageo plc

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 16,871 16,657 19,195 20,371 21,548 20,067 17,212 15,469
Change - -1.27% 15.24% 6.13% 5.78% -6.87% -14.23% -10.13%
Announcement Date 7/29/21 7/28/22 8/1/23 7/30/24 8/5/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Diageo plc

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 874.5 1,330 1,504 1,510 1,549 1,224 1,197 1,152
Change - 52.14% 13.02% 0.42% 2.58% -20.96% -2.25% -3.77%
Free Cash Flow (FCF) 1 4,230 3,442 3,511 2,595 2,748 3,043 3,374 3,532
Change - -18.63% 2% -26.08% 5.9% 10.73% 10.87% 4.69%
Announcement Date 7/29/21 7/28/22 8/1/23 7/30/24 8/5/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Diageo plc

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

Profitability

        
EBITDA Margin (%) 32.93% 36.4% 35.76% 34.72% 32.82% 32.43% 32.04% 32.4%
EBIT Margin (%) 29.42% 31.04% 30.7% 29.33% 28.17% 28.47% 28.02% 28.44%
EBT Margin (%) 29.11% 28.39% 27.67% 26.94% 17.47% 24.38% 25.02% 26.63%
Net margin (%) 20.89% 21.03% 21.82% 19.09% 11.63% 17.43% 17.81% 18.92%
FCF margin (%) 23.78% 18.37% 16.1% 12.8% 13.57% 15.5% 17.42% 17.67%
FCF / Net Income (%) 113.83% 87.35% 73.78% 67.05% 116.74% 88.95% 97.8% 93.43%

Profitability

        
ROA 8.41% 10.28% 10.26% 8.88% 7.7% 7.01% 6.9% 7.07%
ROE 40.18% 47.91% 47.39% 40.35% 34.54% 28.97% 24.65% 22.54%

Financial Health

        
Leverage (Debt/EBITDA) 2.88x 2.44x 2.46x 2.89x 3.24x 3.15x 2.77x 2.39x
Debt / Free cash flow 3.99x 4.84x 5.47x 7.85x 7.84x 6.59x 5.1x 4.38x

Capital Intensity

        
CAPEX / Current Assets (%) 4.92% 7.1% 6.9% 7.45% 7.65% 6.24% 6.18% 5.76%
CAPEX / EBITDA (%) 14.93% 19.5% 19.28% 21.46% 23.31% 19.23% 19.28% 17.79%
CAPEX / FCF (%) 20.67% 38.65% 42.83% 58.19% 56.37% 40.24% 35.48% 32.61%

Items per share

        
Cash flow per share 1 2.171 2.053 1.697 1.833 1.929 1.898 2.036 2.155
Change - -5.45% -17.33% 8.05% 5.19% -1.59% 7.26% 5.87%
Dividend per Share 1 1.013 0.9239 1.019 1.035 1.035 0.5362 0.5583 0.5986
Change - -8.84% 10.34% 1.51% 0% -48.18% 4.12% 7.21%
Book Value Per Share 1 4.11 4.151 4.394 4.491 4.991 5.841 6.895 8.017
Change - 1% 5.84% 2.21% 11.14% 17.02% 18.06% 16.27%
EPS 1 1.584 1.694 2.095 1.728 1.057 1.545 1.564 1.716
Change - 6.95% 23.65% -17.52% -38.83% 46.2% 1.23% 9.68%
Nbr of stocks (in thousands) 2,334,775 2,278,906 2,245,879 2,219,979 2,222,295 2,223,630 2,223,630 2,223,630
Announcement Date 7/29/21 7/28/22 8/1/23 7/30/24 8/5/25 - - -
1USD
Estimates
2026 *2027 *
P/E 13.3x 13.1x
PBR 3.51x 2.97x
EV / Sales 3.34x 3.24x
Yield 2.62% 2.73%

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
OUTPERFORM
Number of Analysts
23
Last Close Price
20.48USD
Average target price
26.07USD
Spread / Average Target
+27.26%

Quarterly revenue - Rate of surprise