Shell midstream partners, l.p. (SHLX)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15
Cash flows from operating activities
Cash flows from operating activities
Net income

551,000

546,000

549,000

558,000

554,000

482,000

437,700

382,200

358,900

392,000

462,300

424,600

407,600

377,500

378,100

406,900

392,900

374,000

0

0

0

Adjustments to reconcile net income to net cash provided by operating activities
Depreciation, amortization and accretion

50,000

49,000

48,000

47,000

47,000

46,000

45,700

45,400

44,700

45,000

49,300

47,700

48,500

43,100

49,000

45,400

38,600

37,900

0

0

0

Non-cash interest expense

-

-

-

-

-

-

-

-

-

0

2,800

2,700

2,600

2,700

0

0

0

-

-

-

-

Loss from revision of asset retirement obligation

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of credit facilities issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Allowance oil reduction to net realizable value

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Undistributed equity earnings

3,000

6,000

9,000

7,000

8,000

6,000

1,100

3,800

4,100

6,000

5,500

1,100

-2,200

-4,100

1,600

3,300

5,300

4,300

0

0

0

Changes in operating assets and liabilities
Accounts receivable

1,000

-7,000

-10,000

6,000

15,000

7,000

18,100

-3,500

-5,500

7,000

8,900

17,100

-500

-300

-3,900

-2,200

7,500

-3,400

0

0

0

Allowance oil

2,000

0

4,000

0

4,000

6,000

4,300

9,700

5,000

3,000

1,900

3,700

1,600

4,000

6,000

3,700

5,800

4,700

0

0

0

Prepaid expenses and other assets

1,000

0

0

0

3,000

4,000

1,200

2,900

3,700

7,000

900

2,700

2,000

100

-1,800

-800

500

700

0

0

0

Accounts payable

0

2,000

-2,000

-7,000

-13,000

-7,000

200

4,400

15,900

8,000

5,400

9,400

-2,400

300

-4,400

-6,200

-1,300

-7,700

0

0

0

Deferred revenue and other unearned income

-1,000

-11,000

-11,000

-12,000

-10,000

-4,000

-12,000

-7,400

-4,500

6,000

22,300

20,000

18,200

7,900

-7,300

-23,000

-22,900

-14,200

0

0

0

Accrued liabilities

-

-

-

-

-

10,000

7,500

13,600

17,200

4,000

1,500

1,500

-900

-2,800

4,800

4,300

4,300

9,100

0

0

0

Net cash provided by operating activities

609,000

597,000

597,000

577,000

548,000

507,000

453,800

424,900

424,900

432,000

526,900

481,800

472,900

429,200

420,500

426,500

395,600

395,800

0

0

0

Cash flows from investing activities
Cash flows from investing activities
Capital expenditures

35,000

38,000

42,000

48,000

50,000

49,000

53,600

57,200

56,500

58,000

59,400

51,900

51,600

45,800

69,300

66,700

53,800

51,700

0

0

0

Contributions to investment

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase price adjustment

-

-

-

-

-

-

-

-

-

-

400

400

400

0

0

0

0

-

-

-

-

Return of investment

72,000

66,000

63,000

62,000

45,000

48,000

45,800

40,500

22,200

18,000

19,400

18,300

18,500

15,800

17,600

15,100

13,400

12,500

0

0

0

Payment of pre-IPO distributions from investments to SPLC

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,900

0

0

0

Net cash provided by (used in) investing activities

-73,000

-87,000

-89,000

-100,000

-520,000

-511,000

-780,300

-772,300

-503,700

-509,000

-334,300

-364,100

-247,500

-244,800

-265,600

-269,700

-220,200

-230,900

0

0

0

Cash flows from financing activities
Cash flows from financing activities
Net proceeds from equity offerings

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from equity offerings

-

-

-

-

-

-

-

-

-

-

-

-

397,700

818,100

1,114,900

1,114,900

717,200

296,800

0

0

0

Repayments of credit facilities

-

-

-

-

-

1,573,000

1,841,000

1,506,000

1,506,000

533,000

265,000

0

0

410,000

410,000

410,000

410,000

0

0

0

0

Contributions from general partner

-

-

-

-

-

20,000

20,200

25,900

26,000

6,000

5,800

100

1,100

9,800

9,800

9,800

14,800

6,100

0

0

0

Distributions to noncontrolling interests

19,000

17,000

18,000

18,000

17,000

16,000

13,600

14,300

15,300

19,000

29,500

27,500

23,500

30,200

34,400

62,500

60,500

73,200

0

0

0

Distributions to unitholders and general partner

552,000

519,000

500,000

482,000

469,000

423,000

379,600

334,800

292,400

268,000

244,300

225,100

203,200

179,900

156,300

135,000

117,400

96,500

0

0

0

Net distributions to Parent

-

-

-

-

-

-

-

-

-

-66,000

0

0

0

-

-

-

-

-148,100

0

0

0

Other contributions from Parent

12,000

19,000

14,000

16,000

18,000

12,000

11,400

11,600

16,200

18,000

24,900

26,400

15,400

14,400

43,500

40,800

42,200

40,400

0

0

0

Capital lease payments

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

-

-

-

-

Credit facility issuance costs

-

-

-

-

-

-

-

-

-

2,000

1,300

1,300

1,300

600

0

0

0

-

-

-

-

Net cash used in financing activities

-470,000

-428,000

-414,000

-395,000

13,000

74,000

352,900

385,900

107,900

92,000

-181,500

-151,500

-209,200

-156,100

-110,800

-100,400

-193,500

-221,300

0

0

0

Net increase in cash and cash equivalents

66,000

82,000

94,000

82,000

41,000

70,000

26,400

38,500

29,100

15,000

11,100

-33,800

16,200

28,300

44,100

56,400

-18,100

-56,400

0

0

0

Non-cash investing and financing transactions:
Change in accrued capital expenditures

-3,000

3,000

-5,000

-5,000

-5,000

-2,000

300

-800

300

0

-3,500

-1,500

5,400

1,100

11,400

11,900

6,400

6,500

0

0

0

Other non-cash contributions from Parent

-

-

-

-

-

2,000

500

900

200

0

1,400

1,200

3,900

200

2,100

1,900

1,900

1,800

0

0

0