Magellan midstream partners, l.p. (MMP)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11Dec'10Sep'10Jun'10Mar'10
Operating Activities:
Net income

1,100,750

1,020,849

1,048,476

1,369,972

1,330,678

1,333,925

1,257,748

861,714

857,705

869,531

844,927

840,978

818,437

802,771

796,603

853,024

842,556

819,122

864,084

811,732

780,601

839,519

777,441

704,444

711,824

582,237

546,033

470,932

455,113

435,670

392,129

451,847

417,025

413,566

391,261

337,658

337,111

311,580

0

0

0

Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation, Depletion and Amortization

247,797

246,134

284,379

283,980

275,069

265,077

212,253

205,934

201,211

196,630

190,108

187,280

181,686

178,142

176,769

171,731

168,869

166,812

163,459

159,470

165,927

161,741

158,904

156,120

143,409

142,230

139,112

135,534

132,834

128,012

125,606

124,148

123,326

121,179

119,469

116,638

111,689

108,668

0

0

0

Gain on sale and retirement of assets

20,209

28,966

9,741

359,078

351,811

328,055

341,752

5,880

6,599

5,135

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss (gain) on sale and retirement of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-10,133

-

-6,771

-5,997

-6,015

-7,223

-8,396

-8,847

-7,249

-7,835

-6,319

-7,564

-9,009

-12,625

-11,645

-8,852

-12,176

-8,599

-8,485

-9,449

-4,509

-1,062

0

0

0

Debt placement fee amortization expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

2,151

2,130

2,108

2,087

2,207

2,098

1,965

1,831

1,566

1,514

1,458

1,401

0

0

0

Income (Loss) from Equity Method Investments

181,366

168,961

172,503

176,109

177,834

181,117

173,664

151,020

134,086

120,994

105,326

92,751

82,514

78,696

68,373

65,318

74,521

66,483

64,981

51,105

28,518

19,394

5,179

5,909

4,690

6,275

3,248

2,622

3,364

2,961

6,873

7,079

7,044

6,763

6,174

5,873

5,910

5,732

0

0

0

Distributions from operations of non-controlled entities

215,276

203,602

186,876

185,094

188,001

196,686

196,470

182,966

176,360

146,211

135,631

114,813

92,295

87,987

69,096

66,122

74,353

66,285

47,924

32,616

11,931

3,086

2,985

2,905

2,202

2,494

-7

1,137

1,989

2,961

6,108

6,014

5,879

5,598

5,978

5,693

5,200

4,853

0

0

0

Equity-based incentive compensation expense

19,253

24,012

30,018

31,178

30,335

32,053

31,070

26,603

23,126

20,641

18,804

20,016

16,855

19,358

23,756

23,765

26,144

24,245

24,779

25,070

26,947

27,284

27,315

26,554

24,315

24,083

22,980

24,310

23,049

21,036

18,514

15,701

16,803

17,710

19,168

21,007

17,690

18,899

0

0

0

Settlement gain, amortization of prior service credit and actuarial loss

8,055

8,245

10,396

10,352

8,369

12,135

10,479

10,530

11,171

8,650

7,442

6,311

4,331

2,211

2,296

2,485

3,262

3,478

2,875

2,092

2,830

2,115

2,340

2,744

1,414

1,964

5,542

2,239

2,589

2,962

-846

2,667

1,891

1,117

882

282

169

106

0

0

0

Debt prepayment costs

0

-8,270

-8,270

-8,270

-8,270

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on exchange of interest in non-controlled entity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

28,144

28,144

26,900

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Trade accounts receivable and other accounts receivable

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Inventory

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Energy commodity derivatives contracts, net of derivatives deposits

-

-

-

-

-

-

-

-

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Reimbursable costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

-

0

0

0

Accounts payable

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Accrued payroll and benefits

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Accrued interest payable

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Accrued taxes other than income

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Accrued product liabilities

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Deferred revenue

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

Tank bottom inventory

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Current and noncurrent environmental liabilities

-

-

-

-

-

-

-

-

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Other current and noncurrent assets and liabilities

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Net cash provided by operating activities

1,499,244

1,321,179

1,411,766

1,359,444

1,281,604

1,352,950

1,181,309

1,111,732

1,142,248

1,131,229

1,148,010

1,149,799

1,030,619

973,304

984,583

1,061,941

1,088,177

1,069,692

1,118,090

1,044,764

1,028,310

1,107,301

960,199

910,759

876,209

773,076

760,405

647,642

723,655

646,455

563,423

697,754

519,679

577,323

534,909

429,409

498,704

424,656

0

0

0

Investing Activities:
Additions to property, plant and equipment, net

910,225

943,990

896,542

820,477

659,222

552,257

514,750

496,607

516,625

558,669

574,588

645,530

676,152

674,159

707,701

655,436

632,156

621,151

559,747

485,848

416,253

363,250

366,529

393,520

407,002

421,435

413,822

427,235

406,976

354,168

286,517

212,490

186,585

199,665

203,891

218,809

230,085

221,419

0

0

0

Proceeds from sale and disposition of assets

344,479

65,366

62,694

640,214

630,030

576,568

579,537

39,747

41,238

44,392

45,757

7,682

10,903

7,552

6,291

4,974

299

3,371

13,694

13,826

13,827

10,780

1,460

1,412

3,627

3,610

3,215

3,124

1,041

1,056

1,999

5,783

6,312

6,299

7,558

3,925

5,290

8,300

0

0

0

Acquisition of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

17,807

17,798

17,798

36,663

29,300

0

0

0

Investments in non-controlled entities

164,071

212,380

227,521

183,816

232,082

216,424

167,798

224,414

151,293

134,828

139,201

145,363

182,796

200,023

193,993

225,956

200,453

152,466

163,154

158,499

294,054

408,001

447,338

436,773

331,173

250,495

218,816

158,729

118,299

74,934

40,089

20,466

10,249

8,094

0

0

0

-

-

-

-

Acquisition of non-controlling owners' interests

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

40,500

0

0

0

-

-

-

0

Distributions from returns of investments in non-controlled entities

994

8,494

7,500

9,286

9,286

1,786

0

0

0

-

-

-

-2,212

0

9,314

16,097

11,754

14,155

10,910

3,722

9,413

5,487

4,094

1,795

1,279

780

4,208

4,355

4,150

4,832

0

0

0

-

-

-

0

-

-

-

-

Other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,100

0

0

0

-

-

-

0

Net cash provided (used) by investing activities

-653,565

-1,007,252

-955,441

-298,941

-180,917

-119,256

-56,461

-583,772

-570,749

-593,174

-619,794

-785,153

-850,257

-866,630

-886,089

-860,321

-875,234

-810,769

-827,975

-756,477

-762,067

-829,984

-913,551

-1,011,548

-935,912

-882,046

-724,547

-562,929

-474,835

-368,081

-273,521

-214,828

-202,683

-258,741

-324,413

-628,879

-648,027

-590,160

0

0

0

Financing Activities:
Distributions paid

928,548

921,606

911,696

898,935

883,323

865,431

848,732

833,177

818,195

803,216

787,623

771,464

755,310

739,157

721,801

703,314

683,695

662,948

641,103

618,131

594,032

568,806

543,612

518,995

494,956

475,461

458,794

444,684

424,648

403,485

905,373

710,278

528,467

350,892

293,133

-6,014

157,640

318,817

0

0

0

Net commercial paper borrowings

0

-

-

0

0

-

-

-76,975

-166,951

-49,986

233,972

172,876

166,951

-229,975

-191,968

-120,987

0

-16,981

-89,001

-75,995

0

296,942

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net borrowings under revolver

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-15,000

0

-35,000

-75,200

-86,600

0

0

0

Borrowings under long-term notes

499,550

996,405

996,405

496,855

496,855

0

0

0

0

-

-

-

-

1,142,997

1,142,997

649,187

649,187

499,589

499,589

499,589

499,589

257,713

556,393

556,393

556,393

298,680

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments on notes

0

550,000

550,000

800,000

800,000

250,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Debt placement costs

6,657

12,012

12,090

6,895

5,444

404

6,642

6,642

6,631

6,316

406

5,498

5,588

10,906

11,969

6,897

6,880

6,223

4,754

4,759

4,925

2,912

7,761

7,736

7,497

4,849

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net payment on financial derivatives

25,314

33,342

29,648

-16,591

-16,591

-24,619

0

0

0

-

-

-

-

-

-

-

-

42,908

42,908

42,908

42,908

3,613

3,797

3,797

3,797

184

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Increase (decrease) in outstanding checks

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,875

4,402

-8,479

-5,408

-3,536

-6,980

6,458

2,393

0

0

0

Payments associated with settlement of equity-based incentive compensation

14,736

9,800

9,779

9,779

9,779

9,300

9,310

9,310

9,310

13,900

13,899

13,899

13,899

14,400

14,376

14,376

14,376

17,784

17,784

17,784

17,784

14,813

14,813

14,813

14,813

12,259

12,259

12,259

12,259

13,001

27,821

27,821

27,821

7,410

-668

-668

-668

3,371

0

0

0

Debt prepayment costs

0

8,270

8,270

8,270

8,270

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common units

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Net cash used by financing activities

-746,651

-538,589

-525,063

-1,133,314

-1,124,355

-1,100,501

-865,999

-429,374

-504,357

-376,688

-817,932

-393,438

-383,299

-120,704

183,596

-196,387

-55,764

-247,255

-295,961

-259,988

-410,060

-285,489

-46,023

-17,971

35,330

-194,073

-122,121

-198,938

-179,459

-159,716

-387,476

-262,202

-193,886

-116,445

-89,448

177,368

170,939

168,819

0

0

0

Change in cash, cash equivalents and restricted cash

99,028

-224,662

-68,738

-72,811

-23,668

133,193

258,849

98,586

67,142

161,367

-289,716

-28,792

-202,937

-14,030

282,090

5,233

157,179

11,668

-5,846

28,299

-143,817

-8,172

625

-118,760

-24,373

-303,043

-86,263

-114,225

69,361

118,658

-97,574

220,724

123,110

202,137

121,048

-22,102

21,616

3,315

0

0

0

Supplemental non-cash investing activities:
Contribution of property, plant and equipment to a non-controlled entity

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

13,252

13,252

13,252

13,252

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of limited partner units in settlement of equity-based incentive plan awards

-

-

-

-

-

-

-

-

120

-

1,866

1,866

1,866

7,289

7,092

7,092

7,092

8,045

8,045

8,045

8,045

7,315

7,315

7,315

7,315

6,404

6,404

6,404

6,404

7,295

7,295

7,295

7,295

4,315

4,315

4,315

4,315

2,034

0

0

0

Additions to property, plant and equipment

872,133

980,575

961,806

857,280

717,646

562,296

504,904

503,002

535,493

572,744

582,762

622,013

656,527

653,528

697,773

675,525

635,216

623,289

568,926

486,156

423,859

366,445

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in accounts payable and other current liabilities related to capital expenditures

-38,092

36,585

65,264

36,803

58,424

10,039

-9,846

6,395

18,868

14,075

8,174

-23,517

-19,625

-20,631

-9,928

20,089

3,060

2,138

9,179

308

7,606

3,195

-5,433

-11,746

-31,034

-37,678

-19,832

15,556

45,249

55,133

49,867

11,127

-2,436

2,126

-9,864

-6,788

689

-3,432

0

0

0

Payments to Acquire Property, Plant, and Equipment

910,225

943,990

896,542

820,477

659,222

552,257

514,750

496,607

516,625

558,669

574,588

645,530

676,152

674,159

707,701

655,436

632,156

621,151

559,747

485,848

416,253

363,250

366,529

393,520

407,002

421,435

413,822

427,235

406,976

354,168

286,517

212,490

186,585

199,665

203,891

218,809

230,085

221,419

0

0

0