jagomart
digital resources
picture1_Construction Template Excel 33349 | Entire Shell Ar21


 235x       Filetype XLSX       File size 0.59 MB       Source: reports.shell.com


File: Construction Template Excel 33349 | Entire Shell Ar21
sheet 1 index index ndash shell plc annual report and accounts 2021 risk factors ndash oil and gas production available for sale risk factors ndash proved developed and undeveloped oil ...

icon picture XLSX Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Index
Index – Shell plc Annual Report and Accounts 2021
Risk factors – Oil and gas production available for sale
Risk factors – Proved developed and undeveloped oil and gas reserves
Summary of results – Key statistics
Oil and gas production available for sale
Capitalisation table
Cash flow information
Divestment proceeds
Cash capital expenditure
Contractual obligations
Purchases of equity securities by issuer and affiliated purchasers in 2021
Oil and gas average industry prices
Refining marker average industry gross margins
Cracker industry margins
Integrated Gas – Key statistics
Integrated Gas – LNG liquefaction volumes
Integrated Gas – LNG liquefaction plants in operation
Integrated Gas – LNG liquefaction plants under construction
Integrated Gas – GTL plants in operation
Integrated Gas – LNG regasification terminals
Integrated Gas – Renewable power capacity in operation and in development
Upstream – Key statistics
Upstream – Proved developed and undeveloped reserves of Shell subsidiaries and Shell share of joint ventures and associates
Upstream – Summary of proved oil and gas reserves of Shell subsidiaries and Shell share of joint ventures and associates
Upstream – Oil and gas production – Crude oil and natural gas liquids
Upstream – Oil and gas production – Synthetic crude oil
Upstream – Oil and gas production – Natural gas
Upstream – Average realised price by geographical area – Crude oil and natural gas liquids
Upstream – Average realised price by geographical area – Synthetic crude oil
Upstream – Average realised price by geographical area – Natural gas
Upstream – Average production cost by geographical area – Crude oil, natural gas liquids and natural gas
Upstream – Average production cost by geographical area – Synthetic crude oil
Downstream – Key statistics
Downstream – Oil Products sales volumes
Downstream – Branded Retail Sites
Downstream – Oil products - cost of crude oil processed or consumed
Downstream – Crude distillation capacity
Downstream – Oil products - crude oil processed
Downstream – Refinery processing intake
Downstream – Refinery processing outturn
Downstream – Refineries in operation
Downstream – Chemicals – Key statistics
Downstream – Chemicals – Ethylene capacity
Downstream – Chemicals sales volumes
Downstream – Major chemical plants in operation
Corporate – Earnings
Our NCF performance
Performance – absolute emissions
2021 equity control Basis
Growing a material power business
2021 Scorecard: Scope 1 and 2 GHG intensity targets – operational control
2021 scorecard: Scope 1 sustained emission reductions – operational control
Greenhouse gas emissions in million tonnes of CO₂ equivalent
Inputs used for calculating the GHG emissions intensity ratio
Energy consumption in billion kilowatt-hours
Actual number of employees by geographical area
Gender diversity data
Local national coverage
Nomination and Succession Committee – Committee membership and attendance
Safety, Environment and Sustainability Committee – Committee membership and attendance
Members and meeting attendance of the AC
REMCO meeting attendance
Single total figure of remuneration for Non-executive Directors (audited)
Single total figure of remuneration for Executive Directors (audited)
Scheme interests awarded to Executive Directors in 2021 (audited)
Executive Directors’ shareholding (audited)
Directors’ share interests (audited)
Directors’ scheme interests (audited)
CEO pay outcomes
Percentage change in remuneration of Directors and employees
Relative importance of spend on pay
Accrued pension (audited)
Approval of Directors’ Remuneration Report
Approval of Directors’ Remuneration Policy
CEO pay ratio
Non-executive Directors’ fees 2022
Share capital percentage
What we have audited
Adjusted Earnings
Scope of work
Operating units selected, together with the ranges of materiality
Consolidated Statement of Income
Consolidated Statement of Comprehensive Income
Consolidated Balance Sheet
Consolidated Statement of Changes in Equity
Consolidated Statement of Cash Flows
Sensitivity + 10% to the mid-price outlook
Sensitivity - 10% to the mid-price outlook
Average prices from four 1.5-2 degrees Celsius external climate change scenarios
Sensitivity Hybrid Shell Plan + IEA NZE50
Income information by business segment 2021
Income information by business segment 2020
Income information by business segment 2019
Reconciliation of CCS earnings to income for the period
Information by geographical area 2021
Information by geographical area 2020
Information by geographical area 2019
Interest and other income
Interest expense
Intangible assets 2021
Intangible assets 2020
Property, plant and equipment 2021
Property, plant and equipment 2020
Property, plant and equipment – Right-of-use assets – relate to leases 2021
Property, plant and equipment – Right-of-use assets – relate to leases 2020
Property, plant and equipment – Impairments
Commodity price assumptions
Capitalised exploration drilling costs
Exploration drilling costs capitalised for periods greater than one year
Shell share of comprehensive income of joint ventures and associates
Carrying amount of interests in joint ventures and associates
Transactions with joint ventures and associates
Other arrangements in respect of joint ventures and associates
Investments in securities
Investments in securities measured using predominantly unobservable inputs
Trade and other receivables
Finance lease
Inventories
Cash and cash equivalents
Debt and lease arrangements – Debt
Debt and lease arrangements – Net debt
Debt and lease arrangements – Gearing
Borrowing facilities and amounts undrawn
Debt (excluding lease liabilities) 2021
Debt (excluding lease liabilities) 2020
Lease expenses not included in the measurement of lease liability
Lease arrangements 2021
Lease arrangements 2020
Trade and other payables
Taxation charge
Reconciliation of applicable tax charge at statutory tax rates to taxation charge
Deferred tax 2021
Deferred tax 2020
Retirement Benefits – Financial position
Retirement benefit expense
Remeasurements
Defined benefit plan obligations 2021
Defined benefit plan obligations 2020
Defined benefit plan assets 2021
Defined benefit plan assets 2020
Type of pension assets
Weighted averages for assumptions and related sensitivity information
Decommissioning and other provisions
Pre-tax effects of currency appreciation
Value-at-risk (pre-tax)
Net and gross assets and liabilities 2021
Net and gross assets and liabilities 2020
IBOR exposures disaggregated by tenure
Derivative contracts 2021
Derivative contracts 2020
Contractual maturities of derivative liabilities 2021
Contractual maturities of derivative liabilities 2020
Net carrying amounts of derivative contracts 2021
Net carrying amounts of derivative contracts 2020
Net carrying amounts of derivative contracts measured using predominantly unobservable inputs
Unrecognised gain on derivative contracts
Share capital – Issued and fully paid ordinary shares of €0.07 each
Share-based compensation expense
Share awards
Other reserves attributable to Shell plc shareholders
Accumulated other comprehensive income attributable to Shell plc shareholders
Interim dividends
Note – Earnings per share
Employee costs
Average employee numbers
Remuneration of Directors of the Company
Directors and Senior Management expense
Auditor’s remuneration
Assets held for sale
Cost of emission schemes and related environmental programmes recognised in the Consolidated Statement of Income
Purchased environmental certificates (presented under Other Intangible assets, see Note 8) [A]
Obligation (presented under Other payables, see Note 16)
Royal Dutch Shell plc – Listing information
Share capital 2021
Share capital 2022
Notification of major shareholdings – Investor
Dividends – A and B shares (Dollar)
Dividends – A shares (Euro)
Dividends – B shares (Pence)
Dividends – A and B ADSs (Dollar)
Capital gains tax
Reconciliation of income for the period to CCS earnings
Adjusted Earnings
Adjusted EBITDA
Identified Items
Cash capital expenditure
Operating expenses and underlying operating expenses
Calculation of return on average capital employed
Free cash flow and Organic free cash flow
Calculation of shareholder distribution
Calculation of Divestment proceeds

Sheet 2: sr-production-afs
Back to index
Shell plc Annual Report and Accounts 2021
Risk factors – Oil and gas production available for sale







Million boe [A]

2021 2020 2019
Shell subsidiaries 1,047 1,104 1,182
Shell share of joint ventures and associates 134 135 156
Total 1,181 1,239 1,338
[A] Natural gas volumes are converted into oil equivalent using a factor of 5,800 scf per barrel.

Sheet 3: sr-reserves
Back to index
Shell plc Annual Report and Accounts 2021
Risk factors – Proved developed and undeveloped oil and gas reserves







Million boe [C]

Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Shell subsidiaries 8,456 8,222 9,980
Shell share of joint ventures and associates 909 902 1,116
Total 9,365 9,124 11,096
Attributable to non-controlling interest of Shell subsidiaries 267 322 304
[A] We manage our total proved reserves base without distinguishing between proved reserves from subsidiaries and those from joint ventures and associates.
[B] Includes proved reserves associated with future production that will be consumed in operations.
[C] Natural gas volumes are converted into oil equivalent using a factor of 5,800 scf per barrel.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet index ndash shell plc annual report and accounts risk factors oil gas production available for sale proved developed undeveloped reserves summary of results key statistics capitalisation table cash flow information divestment proceeds capital expenditure contractual obligations purchases equity securities by issuer affiliated purchasers in average industry prices refining marker gross margins cracker integrated lng liquefaction volumes plants operation under construction gtl regasification terminals renewable power capacity development upstream subsidiaries share joint ventures associates crude natural liquids synthetic realised price geographical area cost downstream products sales branded retail sites processed or consumed distillation refinery processing intake outturn refineries chemicals ethylene major chemical corporate earnings our ncf performance absolute emissions control basis growing a material business scorecard scope ghg intensity targets operational sustained emissi...

no reviews yet
Please Login to review.