← All financial models

Shell (SHEL) Financial Model

📊 Download Model

Three-statement Excel model · 23 quarters and 5 fiscal years of history · 9 quarters and 5 fiscal years of projections

current ✓ C13 recon ✓ C14 trace ✓ C15 terminals

About the SHEL model

This three-statement Excel model covers Shell plc (SHEL): its income statement, balance sheet and cash flow statement. It holds 23 quarters and 5 fiscal years of history and 9 quarters and 5 fiscal years of projections.

Projected revenue is built from KPI drivers: LNG, upstream, marketing, refinery, and energy volumes × effective unit realizations, plus corporate revenue, across 5 segments.

Beyond the income statement, the workbook has these sections: Filed segment revenue and operating data, Adjusted Earnings Reconciliation, KPI Drivers, Balance Sheet, Cash Flow Statement and Issued Ordinary Shares.

Model thesis: LNG growth and upstream volumes support cash generation as commodity realizations normalize.

On November 18, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated November 16, 2026.

History
23 quarters and 5 fiscal years
Projections
9 quarters and 5 fiscal years
KPI
LNG, upstream, marketing, refinery, and energy volumes × effective unit realizations, plus corporate revenue
Segments
5
Units
USD millions except per-share data and where indicated
Verified
Updated
File
Excel workbook (.xlsx), 249 KB
Access
Free account required: 3 different models a month at no charge, then $9 a month.

Income statement preview

Columns 2023–2025 are actual results and 2026E–2028E are our estimates. Figures were recalculated in Excel on November 18, 2026. USD millions except per-share data and where indicated.

Income statement preview for SHEL. USD millions except per-share data and where indicated. Actual fiscal years followed by our estimates.
Income Statement
ActualEstimate
2023202420252026E2027E2028E
Revenue$316,620.0$284,312.0$266,886.0$347,351.7$326,896.4$307,667.1
Share of profit/(loss) of joint ventures and associates3,725.02,993.01,618.02,108.12,451.72,215.2
Interest and other income/(expenses)2,838.01,724.05,227.0(2,839.7)1,600.91,724.8
Rounding residual · Total revenue and other income/(expenses)(1.000)0.0000.000
Total revenue and other income/(expenses)$323,183.0$289,029.0$273,731.0$346,619.1$330,949.1$311,607.1
Purchases(212,883.0)(188,120.0)(177,194.0)(228,595.7)(218,366.8)(206,444.6)
Production and manufacturing expenses(25,240.0)(23,379.0)(21,898.0)(23,344.7)(22,229.0)(21,229.0)
Selling, distribution and administrative expenses(13,433.0)(12,439.0)(12,607.0)(10,955.5)(10,787.6)(10,460.7)
Research and development(1,287.0)(1,099.0)(1,170.0)(991.5)(1,144.1)(1,076.8)
Exploration(1,750.0)(2,411.0)(1,136.0)(1,139.4)(980.7)(923.0)
Depreciation, depletion and amortisation(31,290.0)(26,872.0)(25,299.0)(25,000.0)(25,170.7)(25,251.1)
Interest expense(4,673.0)(4,787.0)(4,671.0)(4,848.0)(4,380.0)(4,358.8)
Rounding residual · Total expenditure(1.000)0.0000.000
Total expenditure($290,556.0)($259,107.0)($243,975.0)($294,875.8)($283,058.9)($269,744.0)
Rounding residual · Income/(loss) before taxation1.0000.0000.000
Income before taxation$32,627.0$29,922.0$29,756.0$51,744.4$47,890.2$41,863.1
Taxation charge/(credit)(12,991.0)(13,401.0)(11,637.0)(21,339.0)(19,682.9)(16,954.5)
Rounding residual · Income/(loss) for the period0.0000.0000.000
Net Income · Income/(loss) for the period$19,636.0$16,521.0$18,119.0$30,405.3$28,207.3$24,908.5
Ratios & Assumptions
Gross margin (analytical)24.8%25.6%25.4%27.5%26.4%26.0%
Operating margin9.7%10.5%10.3%16.5%14.8%13.7%
Parent net margin6.1%5.7%6.7%8.7%8.6%8.0%
Effective tax rate39.8%44.8%39.1%41.2%41.1%40.5%

The full workbook adds 23 historical and 9 projected quarters, plus Filed segment revenue and operating data · Adjusted Earnings Reconciliation · KPI Drivers · Balance Sheet · Cash Flow Statement · Issued Ordinary Shares — every subtotal a live formula, every projection traced to a driver.

Download the full SHEL model (xlsx)3 free models a month with an account, then $9 a month

Shell research

Aardvark Labs Capital Research has published 5 reports on Shell (SHEL). The latest is the Q3 2026 Earnings Recap, published October 31, 2026, rated Hold.

A $5B Top-Up on a Record Refining Quarter, but at $108 Shell Has Reached Our Target: Downgrading to Hold

All SHEL research →

Methodology

Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.