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,744 15,911 15,184
Change - 15.24% 6.13% 5.78% -7.23% -11.24% -10.33% -4.57%
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,243 1,222 1,263
Change - 13.02% 0.42% 2.58% -23.76% 5.24% -1.67% 3.36%
Free Cash Flow (FCF) 1 3,442 3,511 2,595 2,748 3,211 2,758 3,511 3,747
Change - 2% -26.08% 5.9% 16.85% -14.12% 27.32% 6.73%
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.71% 34.92% 35.27%
EBIT Margin (%) 31.04% 30.7% 29.33% 28.17% 28.93% 29.59% 30.68% 31.09%
EBT Margin (%) 28.39% 27.67% 26.94% 17.47% 13.05% 25.65% 28.46% 29.95%
Net margin (%) 21.03% 21.82% 19.09% 11.63% 8.84% 18.01% 20.55% 21.41%
FCF margin (%) 18.37% 16.1% 12.8% 13.57% 16.35% 14.4% 18.18% 18.9%
FCF / Net Income (%) 87.35% 73.78% 67.05% 116.74% 184.86% 79.97% 88.44% 88.29%

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% 30.95% 27.71% 25.76%

Financial Health

        
Leverage (Debt/EBITDA) 2.44x 2.46x 2.89x 3.24x 3.01x 2.75x 2.36x 2.17x
Debt / Free cash flow 4.84x 5.47x 7.85x 7.84x 6.23x 6.43x 4.53x 4.05x

Capital Intensity

        
CAPEX / Current Assets (%) 7.1% 6.9% 7.45% 7.65% 6.01% 6.49% 6.33% 6.37%
CAPEX / EBITDA (%) 19.5% 19.28% 21.46% 23.31% 17.76% 19.25% 18.12% 18.06%
CAPEX / FCF (%) 38.65% 42.83% 58.19% 56.37% 36.78% 45.07% 34.81% 33.71%

Items per share

        
Cash flow per share 1 2.053 1.697 1.833 1.929 1.969 1.774 2.068 2.256
Change - -17.33% 8.05% 5.19% 2.07% -9.9% 16.6% 9.09%
Dividend per Share 1 0.9239 1.019 1.035 1.035 0.5 0.549 0.5879 0.6413
Change - 10.34% 1.51% 0% -51.68% 9.8% 7.09% 9.08%
Book Value Per Share 1 4.151 4.394 4.491 4.991 4.888 5.788 6.886 7.853
Change - 5.84% 2.21% 11.14% -2.06% 18.42% 18.96% 14.04%
EPS 1 1.694 2.095 1.728 1.057 0.779 1.602 1.793 1.931
Change - 23.65% -17.52% -38.83% -26.3% 105.7% 11.9% 7.71%
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 13.1x
PBR 4.05x 3.41x
EV / Sales 3.65x 3.53x
Yield 2.34% 2.51%

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.46USD
Average target price
26.66USD
Spread / Average Target
+13.63%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Diageo plc