Quarterly data by segment

-1 Quarterly data by segment Shell Investors’ Handbook 2012-2016
(XLS:) Download XLS

Quarterly earnings by segment

$ million

 

2016

2015

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

Attributable to shareholders.

Integrated Gas

905

982

614

28

2,529

1,139

1,335

(429)

1,125

3,170

Upstream

 

 

 

 

 

 

 

 

 

 

Europe

(86)

(820)

12

495

(399)

957

(76)

(40)

241

1,082

Asia

(18)

(83)

91

(113)

(123)

195

114

(26)

(206)

77

Oceania

–

–

–

–

–

–

–

–

–

–

Africa

(92)

34

269

(139)

72

1,484

220

173

(98)

1,779

North America

(1,153)

(1,061)

(917)

56

(3,075)

(882)

(762)

(7,827)

(977)

(10,448)

South America

(1)

(44)

160

(264)

(149)

(354)

(57)

(494)

(418)

(1,323)

Total Upstream

(1,350)

(1,974)

(385)

35

(3,674)

1,400

(561)

(8,214)

(1,458)

(8,833)

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

Refining & Trading

181

509

(42)

(72)

576

1,136

1,192

1,043

733

4,104

Marketing

1,113

981

1,117

1,153

4,364

978

1,051

930

1,591

4,550

Oil Products

1,294

1,490

1,075

1,081

4,940

2,114

2,243

1,973

2,324

8,654

Chemicals

406

227

521

494

1,648

400

503

508

178

1,589

Total Downstream

1,700

1,717

1,596

1,575

6,588

2,514

2,746

2,481

2,502

10,243

Corporate and non-controlling interest

 

 

 

 

 

 

 

 

 

 

Corporate

(456)

(423)

(306)

(566)

(1,751)

(171)

(68)

109

(295)

(425)

Non-controlling interest

15

(63)

(71)

(40)

(159)

(121)

(91)

(67)

(34)

(313)

Total Corporate and non-controlling interest

(441)

(486)

(377)

(606)

(1,910)

(292)

(159)

42

(329)

(738)

CCS earnings attributable to shareholders

814

239

1,448

1,032

3,533

4,761

3,361

(6,120)

1,840

3,842

CCS adjustment for Downstream [A]

(330)

936

(73)

509

1,042

(331)

625

(1,296)

(901)

(1,903)

Income attributable to Royal Dutch Shell plc shareholders

484

1,175

1,375

1,541

4,575

4,430

3,986

(7,416)

939

1,939
(XLS:) Download XLS

 

$ million

 

Quarterly earnings by segment Continued

$ million

 

2014

2013

2012

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

Attributable to shareholders.

Integrated Gas

3,183

3,963

2,331

1,133

10,610

2,858

2,240

2,006

1,894

8,998

2,427

2,621

2,776

3,166

10,990

Upstream

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Europe

863

469

438

782

2,552

1,225

829

649

727

3,430

1,314

1,158

675

1,081

4,228

Asia

504

448

476

216

1,644

539

509

470

496

2,014

904

531

470

415

2,320

Oceania

–

–

–

–

–

–

(1)

–

–

(1)

49

78

83

70

280

Africa

513

500

217

682

1,912

805

423

549

34

1,811

864

369

1,101

1,118

3,452

North America

256

(1,371)

608

22

(485)

403

(2,102)

(296)

(867)

(2,862)

958

12

(508)

309

771

South America

108

(189)

(121)

(190)

(392)

(9)

(217)

(88)

(438)

(752)

207

(61)

14

43

203

Total Upstream

2,244

(143)

1,618

1,512

5,231

2,963

(559)

1,284

(48)

3,640

4,296

2,087

1,835

3,036

11,254

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Oil Products

(1,481)

884

1,145

1,446

1,994

1,133

468

303

122

2,026

830

885

1,406

887

4,008

Chemicals

476

387

456

98

1,417

555

335

603

350

1,843

490

475

195

214

1,374

Total Downstream

(1,005)

1,271

1,601

1,544

3,411

1,688

803

906

472

3,869

1,320

1,360

1,601

1,101

5,382

Corporate and non-controlling interest

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Corporate

77

100

(301)

(32)

(156)

491

(73)

88

(134)

372

(264)

(36)

15

82

(203)

Non-controlling interest

(34)

(44)

17

6

(55)

(49)

(17)

(36)

(32)

(134)

(102)

(48)

(75)

(34)

(259)

Total Corporate and non-controlling interest

43

56

(284)

(26)

(211)

442

(90)

52

(166)

238

(366)

(84)

(60)

48

(462)

CCS earnings attributable to shareholders

4,465

5,147

5,266

4,163

19,041

7,951

2,394

4,248

2,152

16,745

7,677

5,984

6,152

7,351

27,164

CCS adjustment for Downstream [A]

44

160

(803)

(3,568)

(4,167)

225

(657)

429

(371)

(374)

1,060

(1,901)

1,012

(623)

(452)

Income attributable to Royal Dutch Shell plc shareholders

4,509

5,307

4,463

595

14,874

8,176

1,737

4,677

1,781

16,371

8,737

4,083

7,164

6,728

26,712
(XLS:) Download XLS

Quarterly identified items by segment [A]

$ million

 

2016

2015

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

With effect from 2016, identified items include the impact on deferred tax balances of exchange rate movements arising on the conversion to dollars of the local currency tax base of non-monetary assets and liabilities, as well as losses, and the conversion of dollar-denominated inter-segment loans to local currency. Comparative information has been restated.

Integrated Gas

(89)

114

(317)

(879)

(1,171)

(352)

(68)

(1,347)

(120)

(1,887)

Upstream

 

 

 

 

 

 

 

 

 

 

Europe

(21)

(597)

140

(40)

(518)

547

43

(153)

(174)

263

Asia

(3)

(24)

(15)

(246)

(288)

(31)

(3)

(111)

(30)

(175)

Oceania

–

–

–

–

–

–

–

–

–

–

Africa

(5)

(11)

86

(8)

62

1,417

(2)

(2)

(29)

1,384

North America

(52)

(354)

(478)

404

(480)

(84)

(168)

(7,037)

(93)

(7,382)

South America

168

337

(122)

(129)

254

(254)

38

(329)

(123)

(668)

Total Upstream

87

(649)

(389)

(19)

(970)

1,595

(92)

(7,632)

(449)

(6,578)

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

Refining & Trading

(481)

50

(313)

(149)

(893)

(126)

(121)

(1)

22

(226)

Marketing

142

(128)

(148)

407

273

3

(34)

(111)

960

818

Oil Products

(339)

(78)

(461)

258

(620)

(123)

(155)

(112)

982

592

Chemicals

29

(21)

(21)

(22)

(35)

(9)

(60)

(24)

(4)

(97)

Total Downstream

(310)

(99)

(482)

236

(655)

(132)

(215)

(136)

978

495

Corporate and non-controlling interest

 

 

 

 

 

 

 

 

 

 

Corporate

(525)

(189)

(152)

(101)

(967)

(88)

(27)

619

(141)

363

Non-controlling interest

98

17

(4)

–

111

–

3

–

–

3

Total Corporate and non-controlling interest

(427)

(172)

(156)

(101)

(856)

(88)

(24)

619

(141)

366

CCS earnings impact

(739)

(806)

(1,344)

(763)

(3,652)

1,023

(399)

(8,496)

268

(7,604)
(XLS:) Download XLS

 

$ million

 

Quarterly identified items by segment Continued

$ million

 

2014

2013

2012

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

With effect from 2016, identified items include the impact on deferred tax balances of exchange rate movements arising on the conversion to dollars of the local currency tax base of non-monetary assets and liabilities, as well as losses, and the conversion of dollar-denominated inter-segment loans to local currency. Comparative information has been restated.

Integrated Gas

(1)

1,279

(695)

(305)

278

299

(401)

38

63

(1)

–

539

202

835

1,576

Upstream

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Europe

15

17

(6)

311

337

(5)

16

50

(24)

37

(64)

160

(357)

45

(216)

Asia

(40)

(68)

(6)

–

(114)

(48)

1

4

–

(43)

–

–

–

–

–

Oceania

–

–

–

–

–

–

–

–

–

–

–

–

1

–

1

Africa

(7)

–

(72)

341

262

(4)

79

(1)

(371)

(297)

–

(373)

295

567

489

North America

(83)

(1,757)

52

183

(1,605)

11

(1,986)

(238)

(488)

(2,701)

517

(145)

(439)

354

287

South America

54

(216)

(194)

(47)

(403)

–

–

–

–

–

–

–

–

–

–

Total Upstream

(61)

(2,024)

(226)

788

(1,523)

(46)

(1,890)

(185)

(883)

(3,004)

453

(358)

(500)

966

561

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Oil Products

(2,576)

(76)

(185)

(58)

(2,895)

(158)

(362)

2

(130)

(648)

198

32

(47)

(89)

94

Chemicals

(4)

–

(7)

52

41

(2)

(3)

12

44

51

–

32

(87)

–

(55)

Total Downstream

(2,580)

(76)

(192)

(6)

(2,854)

(160)

(365)

14

(86)

(597)

198

64

(134)

(89)

39

Corporate and non-controlling interest

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Corporate

1

(1)

17

72

89

403

4

(47)

(61)

299

(234)

–

–

–

(234)

Non-controlling interest

–

–

–

–

–

15

–

–

15

30

(37)

–

–

–

(37)

Total Corporate and non-controlling interest

1

(1)

17

72

89

418

4

(47)

(46)

329

(271)

–

–

–

(271)

CCS earnings impact

(2,641)

(822)

(1,096)

549

(4,010)

511

(2,652)

(180)

(952)

(3,273)

380

245

(432)

1,712

1,905

Identified items

Identified items comprise: divestment gains and losses; impairments; fair value accounting of commodity derivatives and certain gas contracts; redundancy and restructuring; the impact of exchange rate movements on certain deferred tax balances; and other items. Identified items are deducted from relevant GAAP measures to provide additional insight into Shell's financial performance, in the form of non-GAAP measures such as "Earnings excluding identified items" or "Underlying operating expenses". A description of Shell’s identified items per quarter can be found in the Quarterly Results Announcements.

Download centre
Chart generator
Compare to last year
Print page

You may also be interested in

World map showing geographical areas of shell assets (world map)

Interactive world map

More in the report