Quarterly data by segment

-1 Quarterly data by segment Shell Investors’ Handbook 2013-2017
(XLS:) Download XLS

Quarterly earnings by segment

$ million

 

2017

2016

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

Attributable to shareholders.

Integrated Gas

1,822

1,191

1,217

848

5,078

905

982

614

28

2,529

Upstream

 

 

 

 

 

 

 

 

 

 

Europe

309

(138)

27

1,560

1,758

(86)

(820)

12

495

(399)

Asia

251

284

85

477

1,097

(18)

(83)

91

(113)

(123)

Oceania

–

–

–

–

–

–

–

–

–

–

Africa

69

176

394

1,124

1,763

(92)

34

269

(139)

72

North America

(1,166)

(520)

46

(854)

(2,494)

(1,153)

(1,061)

(917)

56

(3,075)

South America

7

(346)

23

(257)

(573)

(1)

(44)

160

(264)

(149)

Total Upstream

(530)

(544)

575

2,050

1,551

(1,350)

(1,974)

(385)

35

(3,674)

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

Refining & Trading

870

193

571

19

1,653

181

509

(42)

(72)

576

Marketing

895

1,376

1,104

548

3,923

1,113

981

1,117

1,153

4,364

Oil Products

1,765

1,569

1,675

567

5,576

1,294

1,490

1,075

1,081

4,940

Chemicals

815

588

730

549

2,682

406

227

521

494

1,648

Total Downstream

2,580

2,157

2,405

1,116

8,258

1,700

1,717

1,596

1,575

6,588

Corporate

(410)

(774)

(394)

(838)

(2,416)

(456)

(423)

(306)

(566)

(1,751)

Non-controlling interest

(81)

(110)

(105)

(94)

(390)

15

(63)

(71)

(40)

(159)

CCS earnings attributable to shareholders

3,381

1,920

3,698

3,082

12,081

814

239

1,448

1,032

3,533

CCS adjustment for Downstream [A]

(157)

375

(389)

(725)

(896)

(330)

936

(73)

509

1,042

Income attributable to Royal Dutch Shell plc shareholders

3,538

1,545

4,087

3,807

12,977

484

1,175

1,375

1,541

4,575
(XLS:) Download XLS

 

$ million

 

Quarterly earnings by segment Continued

$ million

 

2015

2014

2013

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

[A]

Attributable to shareholders.

Integrated Gas

1,139

1,335

(429)

1,125

3,170

3,183

3,963

2,331

1,133

10,610

2,858

2,240

2,006

1,894

8,998

Upstream

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Europe

957

(76)

(40)

241

1,082

863

469

438

782

2,552

1,225

829

649

727

3,430

Asia

195

114

(26)

(206)

77

504

448

476

216

1,644

539

509

470

496

2,014

Oceania

–

–

–

–

–

–

–

–

–

–

–

(1)

–

–

(1)

Africa

1,484

220

173

(98)

1,779

513

500

217

682

1,912

805

423

549

34

1,811

North America

(882)

(762)

(7,827)

(977)

(10,448)

256

(1,371)

608

22

(485)

403

(2,102)

(296)

(867)

(2,862)

South America

(354)

(57)

(494)

(418)

(1,323)

108

(189)

(121)

(190)

(392)

(9)

(217)

(88)

(438)

(752)

Total Upstream

1,400

(561)

(8,214)

(1,458)

(8,833)

2,244

(143)

1,618

1,512

5,231

2,963

(559)

1,284

(48)

3,640

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Refining & Trading

1,136

1,192

1,043

733

4,104

–

–

–

–

–

–

–

–

–

–

Marketing

978

1,051

930

1,591

4,550

–

–

–

–

–

–

–

–

–

–

Oil Products

2,114

2,243

1,973

2,324

8,654

(1,481)

884

1,145

1,446

1,994

1,133

468

303

122

2,026

Chemicals

400

503

508

178

1,589

476

387

456

98

1,417

555

335

603

350

1,843

Total Downstream

2,514

2,746

2,481

2,502

10,243

(1,005)

1,271

1,601

1,544

3,411

1,688

803

906

472

3,869

Corporate

(171)

(68)

109

(295)

(425)

77

100

(301)

(32)

(156)

491

(73)

88

(134)

372

Non-controlling interest

(121)

(91)

(67)

(34)

(313)

(34)

(44)

17

6

(55)

(49)

(17)

(36)

(32)

(134)

CCS earnings attributable to shareholders

4,761

3,361

(6,120)

1,840

3,842

4,465

5,147

5,266

4,163

19,041

7,951

2,394

4,248

2,152

16,745

CCS adjustment for Downstream [A]

(331)

625

(1,296)

(901)

(1,903)

44

160

(803)

(3,568)

(4,167)

225

(657)

429

(371)

(374)

Income attributable to Royal Dutch Shell plc shareholders

4,430

3,986

(7,416)

939

1,939

4,509

5,307

4,463

595

14,874

8,176

1,737

4,677

1,781

16,371
(XLS:) Download XLS

Quarterly identified items by segment

$ million

 

2017

2016

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Integrated Gas

641

22

(65)

(788)

(190)

(89)

114

(317)

(879)

(1,171)

Upstream

 

 

 

 

 

 

 

 

 

 

Europe

86

(331)

(67)

1,065

753

(21)

(597)

140

(40)

(518)

Asia

–

–

(44)

210

166

(3)

(24)

(15)

(246)

(288)

Oceania

–

–

–

–

–

–

–

–

–

–

Africa

(90)

(8)

(98)

389

193

(5)

(11)

86

(8)

62

North America

(1,136)

(361)

42

(1,081)

(2,536)

(52)

(354)

(478)

404

(480)

South America

70

(183)

180

(183)

(116)

168

337

(122)

(129)

254

Total Upstream

(1,070)

(883)

13

400

(1,540)

87

(649)

(389)

(19)

(970)

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

Refining & Trading

155

(567)

(320)

(77)

(809)

(481)

50

(313)

(149)

(893)

Marketing

(43)

231

(23)

(240)

(75)

142

(128)

(148)

407

273

Oil Products

112

(336)

(343)

(317)

(884)

(339)

(78)

(461)

258

(620)

Chemicals

(21)

(36)

80

37

60

29

(21)

(21)

(22)

(35)

Total Downstream

91

(372)

(263)

(280)

(824)

(310)

(99)

(482)

236

(655)

Corporate

(63)

(451)

(90)

(553)

(1,157)

(525)

(189)

(152)

(101)

(967)

Non-controlling interest

28

–

–

–

28

98

17

(4)

–

111

CCS earnings impact

(373)

(1,684)

(405)

(1,221)

(3,683)

(739)

(806)

(1,344)

(763)

(3,652)
(XLS:) Download XLS

 

$ million

 

Quarterly identified items by segment Continued

$ million

 

2015

2014

2013

 

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Q1

Q2

Q3

Q4

Year

Integrated Gas

(352)

(68)

(1,347)

(120)

(1,887)

(1)

1,279

(695)

(305)

278

299

(401)

38

63

(1)

Upstream

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Europe

547

43

(153)

(174)

263

15

17

(6)

311

337

(5)

16

50

(24)

37

Asia

(31)

(3)

(111)

(30)

(175)

(40)

(68)

(6)

–

(114)

(48)

1

4

–

(43)

Oceania

–

–

–

–

–

–

–

–

–

–

–

–

–

–

–

Africa

1,417

(2)

(2)

(29)

1,384

(7)

–

(72)

341

262

(4)

79

(1)

(371)

(297)

North America

(84)

(168)

(7,037)

(93)

(7,382)

(83)

(1,757)

52

183

(1,605)

11

(1,986)

(238)

(488)

(2,701)

South America

(254)

38

(329)

(123)

(668)

54

(216)

(194)

(47)

(403)

–

–

–

–

–

Total Upstream

1,595

(92)

(7,632)

(449)

(6,578)

(61)

(2,024)

(226)

788

(1,523)

(46)

(1,890)

(185)

(883)

(3,004)

Downstream (CCS basis)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Refining & Trading

(126)

(121)

(1)

22

(226)

–

–

–

–

–

–

–

–

–

–

Marketing

3

(34)

(111)

960

818

–

–

–

–

–

–

–

–

–

–

Oil Products

(123)

(155)

(112)

982

592

(2,576)

(76)

(185)

(58)

(2,895)

(158)

(362)

2

(130)

(648)

Chemicals

(9)

(60)

(24)

(4)

(97)

(4)

–

(7)

52

41

(2)

(3)

12

44

51

Total Downstream

(132)

(215)

(136)

978

495

(2,580)

(76)

(192)

(6)

(2,854)

(160)

(365)

14

(86)

(597)

Corporate

(88)

(27)

619

(141)

363

1

(1)

17

72

89

403

4

(47)

(61)

299

Non-controlling interest

–

3

–

–

3

–

–

–

–

–

15

–

–

15

30

CCS earnings impact

1,023

(399)

(8,496)

268

(7,604)

(2,641)

(822)

(1,096)

549

(4,010)

511

(2,652)

(180)

(952)

(3,273)

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. These items, either individually or collectively, can cause volatility to net income, in some cases driven by external factors, which may hinder the comparative understanding of Shell’s financial results from period to period. A description of Shell’s identified items per quarter can be found in the Quarterly Results Announcements.