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 43,040 45,780 48,354
Change - -30.29% -14.69% -2.89% -10.87% 10.9% 6.37% 5.62%
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,963 20,219 20,391
Change - 14.56% 18.95% 1.74% -14.75% 1.84% 1.29% 0.85%
Free Cash Flow (FCF) 1 20,828 40,345 45,814 36,460 39,530 25,592 24,349 26,645
Change - 93.71% 13.56% -20.42% 8.42% -35.26% -4.85% 9.43%
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% 21.17% 20.08% 19.49%
EBIT Margin (%) 5.96% 12.52% 16.42% 11.76% 15.16% 12.16% 11.23% 11.09%
EBT Margin (%) -14.94% 11.41% 17% 10.31% 10.52% 11.04% 10.25% 9.91%
Net margin (%) -12.01% 7.69% 11.1% 6.11% 5.66% 6.72% 6.42% 6.6%
FCF margin (%) 11.54% 15.43% 12.01% 11.52% 13.9% 9.56% 9.03% 9.27%
FCF / Net Income (%) -96.07% 200.71% 108.28% 188.33% 245.63% 142.23% 140.71% 140.42%

Profitability

        
ROA 1.24% 4.92% 9.41% 6.7% 5.97% 4.66% 4.68% 5%
ROE 2.84% 11.79% 23.35% 15% 13% 10.97% 10.34% 11.33%

Financial Health

        
Leverage (Debt/EBITDA) 2.8x 0.96x 0.53x 0.64x 0.59x 0.76x 0.85x 0.86x
Debt / Free cash flow 3.62x 1.3x 0.98x 1.19x 0.98x 1.68x 1.88x 1.81x

Capital Intensity

        
CAPEX / Current Assets (%) 9.19% 7.27% 5.93% 7.26% 6.89% 7.46% 7.5% 7.09%
CAPEX / EBITDA (%) 61.62% 34.54% 26.81% 33.55% 29.79% 35.22% 37.36% 36.4%
CAPEX / FCF (%) 79.63% 47.09% 49.33% 63.06% 49.59% 78% 83.04% 76.53%

Items per share

        
Cash flow per share 1 4.375 5.778 9.232 7.97 8.593 7.327 7.518 8.461
Change - 32.06% 59.79% -13.67% 7.82% -14.73% 2.6% 12.54%
Dividend per Share 1 0.653 0.8935 0.99 1.294 1.39 1.441 1.502 1.575
Change - 36.83% 10.8% 30.66% 7.46% 3.64% 4.27% 4.87%
Book Value Per Share 1 19.92 22.38 27.2 28.6 29.16 29.96 31.3 33.14
Change - 12.33% 21.53% 5.16% 1.95% 2.76% 4.46% 5.87%
EPS 1 -2.78 2.57 5.71 2.85 2.53 3.09 3.29 3.876
Change - 192.45% 122.18% -50.09% -11.23% 22.14% 6.46% 17.82%
Nbr of stocks (in thousands) 7,772,923 7,640,301 7,003,503 6,524,109 6,115,031 5,745,973 5,745,973 5,745,973
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.9x 11.2x
PBR 1.23x 1.17x
EV / Sales 0.95x 0.95x
Yield 3.92% 4.08%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
18
Last Close Price
36.77USD
Average target price
41.71USD
Spread / Average Target
+13.42%
Consensus

Quarterly revenue - Rate of surprise