Projected Income Statement: Shell plc

Forecast Balance Sheet: Shell plc

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 75,386 52,555 44,837 43,541 38,809 42,098 43,721 43,639
Change - -30.29% -14.69% -2.89% -10.87% 8.47% 3.86% -0.19%
Announcement Date 2/4/21 2/3/22 2/2/23 2/1/24 1/30/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Shell plc

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 16,585 19,000 22,600 22,993 19,601 19,816 20,342 20,556
Change - 14.56% 18.95% 1.74% -14.75% 1.09% 2.66% 1.05%
Free Cash Flow (FCF) 1 20,828 40,345 45,814 36,460 39,530 23,366 22,657 25,764
Change - 93.71% 13.56% -20.42% 8.42% -40.89% -3.03% 13.71%
Announcement Date 2/4/21 2/3/22 2/2/23 2/1/24 1/30/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Shell plc

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 14.91% 21.03% 22.1% 21.65% 23.14% 20.21% 20.06% 20.24%
EBIT Margin (%) 5.96% 12.52% 16.42% 11.76% 15.16% 11.76% 11.29% 11.59%
EBT Margin (%) -14.94% 11.41% 17% 10.31% 10.52% 10.62% 10.74% 11.67%
Net margin (%) -12.01% 7.69% 11.1% 6.11% 5.66% 6.28% 6.59% 7.29%
FCF margin (%) 11.54% 15.43% 12.01% 11.52% 13.9% 8.64% 8.4% 9.12%
FCF / Net Income (%) -96.07% 200.71% 108.28% 188.33% 245.63% 137.56% 127.41% 125.02%

Profitability

        
ROA 1.24% 4.92% 9.41% 6.7% 5.97% 4.01% 4.44% 5.49%
ROE 2.84% 11.79% 23.35% 15% 13% 10.19% 10.42% 11.92%

Financial Health

        
Leverage (Debt/EBITDA) 2.8x 0.96x 0.53x 0.64x 0.59x 0.77x 0.81x 0.76x
Debt / Free cash flow 3.62x 1.3x 0.98x 1.19x 0.98x 1.8x 1.93x 1.69x

Capital Intensity

        
CAPEX / Current Assets (%) 9.19% 7.27% 5.93% 7.26% 6.89% 7.33% 7.54% 7.27%
CAPEX / EBITDA (%) 61.62% 34.54% 26.81% 33.55% 29.79% 36.26% 37.6% 35.93%
CAPEX / FCF (%) 79.63% 47.09% 49.33% 63.06% 49.59% 84.81% 89.78% 79.79%

Items per share

        
Cash flow per share 1 4.375 5.778 9.232 7.97 8.593 6.778 7.519 8.544
Change - 32.06% 59.79% -13.67% 7.82% -21.12% 10.92% 13.64%
Dividend per Share 1 0.653 0.8935 0.99 1.294 1.39 1.448 1.512 1.586
Change - 36.83% 10.8% 30.66% 7.46% 4.18% 4.43% 4.86%
Book Value Per Share 1 19.92 22.38 27.2 28.6 29.16 30.09 31.65 33.77
Change - 12.33% 21.53% 5.16% 1.95% 3.19% 5.2% 6.68%
EPS 1 -2.78 2.57 5.71 2.85 2.53 2.975 3.499 4.257
Change - 192.45% 122.18% -50.09% -11.23% 17.59% 17.61% 21.66%
Nbr of stocks (in thousands) 7,772,923 7,640,301 7,003,503 6,524,109 6,115,031 5,890,027 5,890,027 5,890,027
Announcement Date 2/4/21 2/3/22 2/2/23 2/1/24 1/30/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 11.8x 10x
PBR 1.16x 1.11x
EV / Sales 0.92x 0.93x
Yield 4.14% 4.32%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
BUY
Number of Analysts
17
Last Close Price
34.99USD
Average target price
41.25USD
Spread / Average Target
+17.88%
Consensus

Quarterly revenue - Rate of surprise