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,046 43,415 43,501
Change - -30.29% -14.69% -2.89% -10.87% 8.34% 3.26% 0.2%
Announcement Date 04/02/21 03/02/22 02/02/23 01/02/24 30/01/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 24,199 23,299 26,068
Change - 93.71% 13.56% -20.42% 8.42% -38.78% -3.72% 11.89%
Announcement Date 04/02/21 03/02/22 02/02/23 01/02/24 30/01/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.08% 20.15% 20.3%
EBIT Margin (%) 5.96% 12.52% 16.42% 11.76% 15.16% 11.86% 11.48% 11.63%
EBT Margin (%) -14.94% 11.41% 17% 10.31% 10.52% 10.8% 10.98% 11.8%
Net margin (%) -12.01% 7.69% 11.1% 6.11% 5.66% 6.41% 6.8% 7.37%
FCF margin (%) 11.54% 15.43% 12.01% 11.52% 13.9% 8.96% 8.66% 9.26%
FCF / Net Income (%) -96.07% 200.71% 108.28% 188.33% 245.63% 139.65% 127.32% 125.7%

Profitability

        
ROA 1.24% 4.92% 9.41% 6.7% 5.97% 4.16% 4.43% 5.48%
ROE 2.84% 11.79% 23.35% 15% 13% 10.33% 10.46% 11.61%

Financial Health

        
Leverage (Debt/EBITDA) 2.8x 0.96x 0.53x 0.64x 0.59x 0.77x 0.8x 0.76x
Debt / Free cash flow 3.62x 1.3x 0.98x 1.19x 0.98x 1.74x 1.86x 1.67x

Capital Intensity

        
CAPEX / Current Assets (%) 9.19% 7.27% 5.93% 7.26% 6.89% 7.33% 7.56% 7.3%
CAPEX / EBITDA (%) 61.62% 34.54% 26.81% 33.55% 29.79% 36.52% 37.52% 35.99%
CAPEX / FCF (%) 79.63% 47.09% 49.33% 63.06% 49.59% 81.89% 87.31% 78.85%

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.26 32.01 34.33
Change - 12.33% 21.53% 5.16% 1.95% 3.78% 5.77% 7.24%
EPS 1 -2.78 2.57 5.71 2.85 2.53 2.994 3.53 4.241
Change - 192.45% 122.18% -50.09% -11.23% 18.35% 17.9% 20.13%
Nbr of stocks (in thousands) 7,772,923 7,640,301 7,003,503 6,524,109 6,115,031 5,895,529 5,895,529 5,895,529
Announcement Date 04/02/21 03/02/22 02/02/23 01/02/24 30/01/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 12x 10.2x
PBR 1.19x 1.13x
EV / Sales 0.95x 0.96x
Yield 4.02% 4.19%
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
36.07USD
Average target price
41.50USD
Spread / Average Target
+15.06%
Consensus

Quarterly revenue - Rate of surprise