Projected Income Statement: 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,751 15,935 15,186
Change - 15.24% 6.13% 5.78% -7.23% -11.21% -10.23% -4.7%
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,244 1,225 1,266
Change - 13.02% 0.42% 2.58% -23.76% 5.3% -1.52% 3.38%
Free Cash Flow (FCF) 1 3,442 3,511 2,595 2,748 3,211 2,749 3,518 3,755
Change - 2% -26.08% 5.9% 16.85% -14.38% 27.98% 6.72%
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.89% 35.27%
EBIT Margin (%) 31.04% 30.7% 29.33% 28.17% 28.93% 29.55% 30.74% 31.19%
EBT Margin (%) 28.39% 27.67% 26.94% 17.47% 13.05% 25.59% 28.38% 29.56%
Net margin (%) 21.03% 21.82% 19.09% 11.63% 8.84% 17.96% 20.45% 21.19%
FCF margin (%) 18.37% 16.1% 12.8% 13.57% 16.35% 14.36% 18.15% 18.89%
FCF / Net Income (%) 87.35% 73.78% 67.05% 116.74% 184.86% 79.95% 88.75% 89.13%

Profitability

        
ROA 10.28% 10.26% 8.88% 7.7% 7.65% 7.88% 7.89% 8.24%
ROE 47.91% 47.39% 40.35% 34.54% 33.49% 31.04% 28.11% 26.07%

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.46x 4.53x 4.04x

Capital Intensity

        
CAPEX / Current Assets (%) 7.1% 6.9% 7.45% 7.65% 6.01% 6.49% 6.32% 6.37%
CAPEX / EBITDA (%) 19.5% 19.28% 21.46% 23.31% 17.76% 19.27% 18.11% 18.06%
CAPEX / FCF (%) 38.65% 42.83% 58.19% 56.37% 36.78% 45.23% 34.81% 33.72%

Items per share

        
Cash flow per share 1 2.053 1.697 1.833 1.929 1.969 1.839 2.056 2.255
Change - -17.33% 8.05% 5.19% 2.07% -6.56% 11.79% 9.65%
Dividend per Share 1 0.9239 1.019 1.035 1.035 - 0.5496 0.5888 0.6425
Change - 10.34% 1.51% 0% - - 7.12% 9.12%
Book Value Per Share 1 4.151 4.394 4.491 4.991 4.888 5.749 6.734 7.716
Change - 5.84% 2.21% 11.14% -2.06% 17.61% 17.13% 14.58%
EPS 1 1.694 2.095 1.728 1.057 0.779 1.594 1.794 1.923
Change - 23.65% -17.52% -38.83% -26.3% 104.59% 12.54% 7.2%
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 13.6x 12.1x
PBR 3.77x 3.22x
EV / Sales 3.45x 3.31x
Yield 2.53% 2.71%

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
22
Last Close Price
21.70USD
Average target price
27.06USD
Spread / Average Target
+24.71%

Quarterly revenue - Rate of surprise

LAST HOURS | 40% Discount: The Best Subscriber-Only Tools to Unlock Hidden Opportunities!
d
:
:
SEIZE THE OFFER!