Projected Income Statement: Diageo plc

Forecast Balance Sheet: Diageo plc

Forecast Balance Sheet - Diageo plc
Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 16,657 19,195 20,371 21,548 19,991 17,752 15,968 15,143
Change - 15.24% 6.13% 5.78% -7.23% -11.2% -10.05% -5.17%
Announcement Date 7/28/22 8/1/23 7/30/24 8/5/25 8/6/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Diageo plc

Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 1,330 1,504 1,510 1,549 1,181 1,247 1,226 1,262
Change - 13.02% 0.42% 2.58% -23.76% 5.56% -1.68% 2.97%
Free Cash Flow (FCF) 1 3,442 3,511 2,595 2,748 3,211 2,732 3,480 3,722
Change - 2% -26.08% 5.9% 16.85% -14.91% 27.35% 6.96%
Announcement Date 7/28/22 8/1/23 7/30/24 8/5/25 8/6/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Diageo plc

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

Profitability

        
EBITDA Margin (%) 36.4% 35.76% 34.72% 32.82% 33.85% 33.77% 34.95% 35.38%
EBIT Margin (%) 31.04% 30.7% 29.33% 28.17% 28.93% 29.69% 30.77% 31.25%
EBT Margin (%) 28.39% 27.67% 26.94% 17.47% 13.05% 25.75% 28.46% 29.91%
Net margin (%) 21.03% 21.82% 19.09% 11.63% 8.84% 17.98% 20.47% 21.32%
FCF margin (%) 18.37% 16.1% 12.8% 13.57% 16.35% 14.29% 18.06% 18.83%
FCF / Net Income (%) 87.35% 73.78% 67.05% 116.74% 184.86% 79.47% 88.21% 88.33%

Profitability

        
ROA 10.28% 10.26% 8.88% 7.7% 7.65% 7.9% 7.9% 8.25%
ROE 47.91% 47.39% 40.35% 34.54% 33.49% 31.1% 27.94% 26.03%

Financial Health

        
Leverage (Debt/EBITDA) 2.44x 2.46x 2.89x 3.24x 3.01x 2.75x 2.37x 2.17x
Debt / Free cash flow 4.84x 5.47x 7.85x 7.84x 6.23x 6.5x 4.59x 4.07x

Capital Intensity

        
CAPEX / Current Assets (%) 7.1% 6.9% 7.45% 7.65% 6.01% 6.52% 6.36% 6.39%
CAPEX / EBITDA (%) 19.5% 19.28% 21.46% 23.31% 17.76% 19.31% 18.2% 18.05%
CAPEX / FCF (%) 38.65% 42.83% 58.19% 56.37% 36.78% 45.63% 35.23% 33.91%

Items per share

        
Cash flow per share 1 2.053 1.697 1.833 1.929 1.969 1.517 2.004 2.228
Change - -17.33% 8.05% 5.19% 2.07% -22.93% 32.11% 11.14%
Dividend per Share 1 0.9239 1.019 1.035 1.035 0.5 0.5426 0.5861 0.6381
Change - 10.34% 1.51% 0% -51.68% 8.51% 8.02% 8.88%
Book Value Per Share 1 4.151 4.394 4.491 4.991 4.888 5.777 6.786 7.759
Change - 5.84% 2.21% 11.14% -2.06% 18.2% 17.46% 14.34%
EPS 1 1.694 2.095 1.728 1.057 0.779 1.583 1.786 1.917
Change - 23.65% -17.52% -38.83% -26.3% 103.22% 12.84% 7.31%
Nbr of stocks (in thousands) 2,278,906 2,245,879 2,219,979 2,222,295 2,223,723 2,224,397 2,224,397 2,224,397
Announcement Date 7/28/22 8/1/23 7/30/24 8/5/25 8/6/26 - - -
1USD
Estimates
2027 *2028 *
P/E 14.6x 12.9x
PBR 4x 3.41x
EV / Sales 3.56x 3.44x
Yield 2.35% 2.53%

EPS & Dividend

EPS & Dividend - Diageo plc


Y-o-Y evolution of P/E

Valuation ratios - P/E - Diageo plc
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Diageo plc
Trader
Investor
Global
Quality
ESG MSCI
-
MarketScreener Ratings - Diageo plc
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
22
Last Close Price
23.13USD
Average target price
26.72USD
Spread / Average Target
+15.55%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Diageo plc