Xcel energy inc (XEL)

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'10Dec'09Sep'09Jun'09Mar'09
Operating activities
Net income

1,352

1,372

1,294

1,258

1,285

1,261

1,236

1,237

1,200

1,148

1,186

1,151

1,120

1,123

1,104

1,073

1,073

984

971

913

912

1,021

975

971

972

948

938

971

957

905

905

845

821

841

837

811

792

755

788

696

673

680

0

0

0

Remove income from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

4

3

1

1

-3

-4

0

0

0

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

1,813

1,785

1,778

1,771

1,710

1,659

1,595

1,525

1,513

1,495

1,449

1,407

1,364

1,319

1,284

1,236

1,189

1,143

1,108

1,083

1,063

1,036

1,030

1,004

999

1,001

976

987

963

943

906

909

912

908

934

913

890

872

861

837

832

835

0

0

0

Conservation and demand side management program amortization

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4

4

4

5

5

5

5

6

6

6

6

6

6

6

7

7

7

7

8

9

10

12

16

21

26

31

30

29

0

0

0

Nuclear fuel amortization

121

119

119

118

122

122

118

119

114

114

115

115

122

117

112

114

103

106

104

103

114

114

113

109

99

98

99

102

104

102

104

106

101

100

102

99

104

105

98

91

86

80

0

0

0

Deferred income taxes

151

143

164

155

185

218

323

441

505

640

608

643

620

587

586

597

613

536

565

524

501

569

538

515

534

515

477

465

471

508

517

547

519

466

478

440

434

414

428

431

546

407

0

0

0

Amortization of investment tax credits

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4

4

4

5

5

11

8

5

15

6

5

5

-6

-6

-6

-6

-6

-6

-6

-6

-6

-6

-6

-6

-5

-6

-6

-6

0

0

0

Allowance for equity funds used during construction

80

77

84

99

105

108

100

93

84

75

68

63

60

60

60

58

56

56

61

69

80

89

93

91

89

87

81

76

69

62

57

53

51

51

55

56

56

56

59

65

70

75

0

0

0

Equity earnings of unconsolidated subsidiaries

41

39

39

38

38

35

33

31

28

30

31

34

36

42

42

40

39

34

31

31

30

30

30

30

29

30

30

30

30

29

29

29

29

30

30

30

30

29

36

33

28

24

0

0

0

Dividends from unconsolidated subsidiaries

41

40

40

39

38

37

36

35

38

41

43

47

46

46

45

43

41

40

39

38

37

36

36

35

35

36

36

44

34

33

33

25

33

34

34

33

33

32

31

31

30

29

0

0

0

Share-based compensation expense

65

58

67

70

58

45

38

35

45

57

55

48

45

41

45

48

47

45

45

42

37

32

12

16

21

24

34

28

31

26

33

41

38

45

40

39

38

35

43

28

27

29

0

0

0

Loss on Monticello life cycle management/extended power uprate project

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

129

129

129

129

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net realized and unrealized hedging and derivative transactions

-

-

-

-

-

-

-

-

-

-

-

-

-

-8

-6

-12

-14

-22

-25

-21

-10

-5

-5

4

-2

4

7

95

92

85

94

-0

-2

-9

-40

40

35

35

68

-9

-16

-39

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

-101

20

18

-28

148

105

77

88

134

60

84

101

75

83

48

49

-61

-66

23

-23

-15

125

16

28

177

108

179

275

216

197

171

119

85

79

95

-82

83

29

111

141

-15

-122

0

0

0

Accrued unbilled revenues

-99

-42

-27

-9

58

-9

24

40

49

34

58

19

30

75

21

6

-19

-74

-28

-26

-31

41

-0

-16

-10

23

53

76

95

-25

-30

-41

-59

-19

18

-243

-316

14

63

354

347

-49

0

0

0

Inventories

135

84

162

141

99

65

-43

-33

-27

3

1

15

-0

-1

-30

-6

14

11

10

31

68

20

31

9

-8

43

42

21

-26

-82

-45

-11

32

57

12

-187

-241

-9

36

230

229

-100

0

0

0

Other current assets

-27

-25

31

2

16

-18

3

-132

-87

-9

-44

92

-0

-61

-17

-9

64

-9

12

10

-11

111

50

79

33

18

-5

-60

10

30

27

51

52

-62

-38

-92

-54

-10

-20

116

80

84

0

0

0

Recoverable purchased natural gas and electric energy costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Accounts payable

-217

-12

-3

-66

136

90

148

94

145

43

-0

38

-3

118

46

39

-43

-120

-13

-37

-114

-53

-20

-16

89

132

14

78

107

-100

-21

-195

-116

13

11

69

-61

-188

-47

33

-10

-50

0

0

0

Net regulatory assets and liabilities

118

66

-53

-105

-229

-223

-175

-126

-113

16

49

52

35

19

10

-6

9

-102

-149

-261

-342

-195

-202

-128

-52

-141

-104

-69

-32

-5

-16

-204

-193

-149

-85

-21

-79

-36

-26

98

92

38

0

0

0

Other current liabilities

-56

-15

-3

-9

-80

-61

-84

-95

-12

-38

-28

-18

9

20

-45

18

10

78

194

186

182

148

11

79

107

126

208

77

45

42

71

72

124

112

65

74

43

13

-3

-46

-3

49

0

0

0

Pension and other employee benefit obligations

-147

-135

-183

-176

-178

-179

-132

-135

-130

-133

-129

-122

-121

-91

-83

-98

-102

-69

-72

-64

-61

-101

-108

-101

-101

-156

-162

-185

-184

-183

-195

-187

-196

-150

-189

-187

-194

-62

0

0

0

-

-

-

-

Other, net

76

40

103

-67

-77

-71

-125

-89

-93

-73

-60

-61

-53

-58

-1

-1

-1

-1

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in other noncurrent assets

-

-

-

-

-

-

-

-

-

-

0

0

14

-

3

-3

-9

-11

-2

2

3

-44

-7

-20

-13

9

-32

-24

-30

33

35

29

25

-24

-27

-20

-12

-5

0

9

-1

1

0

0

0

Change in other noncurrent liabilities

-

-

-

-

-

-

-

-

-

-

0

0

-28

-

-23

-36

-34

-52

-36

-22

-21

-15

-25

-12

-7

17

10

9

7

-3

-24

-38

-40

-61

-50

-56

-54

-35

79

76

-54

-65

0

0

0

Operating cash flows provided by (used in) discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Investing activities
Capital/construction expenditures

4,988

4,225

4,294

3,792

3,941

3,957

3,669

3,624

3,355

3,244

3,264

3,255

3,243

3,195

3,683

3,618

3,612

3,683

3,084

3,102

3,147

3,199

3,242

3,374

3,465

3,395

3,218

3,063

2,825

2,570

2,407

2,186

2,162

2,205

2,258

2,371

2,275

2,216

2,028

1,797

1,781

1,777

0

0

0

Proceeds from insurance recoveries

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

27

27

27

25

6

6

46

70

90

130

123

121

97

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of investment securities

1,525

995

831

974

973

853

1,219

1,696

1,709

1,697

1,128

595

610

547

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the sale of investment securities

1,505

975

816

954

954

833

1,199

1,676

1,680

1,669

1,100

566

542

479

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Merricourt deposit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

90

91

91

91

1

0

0

0

-

-

-

-

Purchases of investments in external decommissioning fund

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

803

995

1,125

1,481

1,778

1,621

1,474

1,102

857

1,243

1,613

2,098

2,214

2,006

3,569

3,781

3,674

3,631

2,158

1,644

0

0

0

Proceeds from the sale of investments in external decommissioning fund

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

783

975

1,104

1,461

1,758

1,603

1,458

1,087

857

1,243

1,613

2,098

2,213

2,006

3,568

3,786

3,702

3,658

2,185

1,664

0

0

0

Investments in unconsolidated subsidiaries and other

-

-

-

-

-

-

-

-

-

-

-

-

6

-

5

3

1

2

0

1

1

2

6

7

8

7

3

2

1

0

1

1

1

2

3

6

7

8

9

20

29

42

0

0

0

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-95

-99

0

9

95

99

-0

-0

-0

0

0

0

-

-

-

-

Other, net

89

98

100

17

6

9

20

12

25

24

12

11

1

-2

-0

-1

-1

0

3

3

4

3

4

4

3

4

4

4

4

2

1

2

1

6

0

0

0

-

-

-

-

-

-

-

-

Other investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Net cash used in investing activities

-5,097

-4,343

-4,409

-3,829

-3,966

-3,986

-3,763

-3,687

-3,420

-3,296

-3,293

-3,291

-3,314

-3,261

-3,690

-3,635

-3,578

-3,623

-3,021

-3,017

-3,054

-3,117

-3,137

-3,232

-3,300

-3,213

-3,034

-2,888

-2,647

-2,332

-2,196

-2,114

-2,022

-2,247

-2,946

-2,962

-2,970

-2,806

-1,961

-1,735

-1,721

-1,734

0

0

0

Financing activities
Proceeds from short-term borrowings, net

513

-443

496

916

228

225

-76

-102

420

422

148

337

422

-454

301

-4

-786

-174

-633

-326

204

260

395

423

340

157

-2

-127

86

383

254

-175

-192

-247

10

527

65

7

-454

-241

27

3

0

0

0

Proceeds from issuances of long-term debt

2,528

2,920

2,231

1,308

2,067

1,675

0

0

0

-

-

-

-

2,424

1,631

2,121

2,373

1,626

1,626

840

541

837

834

933

1,233

1,431

1,533

3,016

2,283

1,790

1,691

799

689

688

0

0

0

-

-

-

-

-

-

-

-

Repayments of long-term debt, including reacquisition premiums

549

949

550

851

852

452

0

0

0

-

-

-

-

1,036

580

830

250

251

250

0

276

275

273

276

401

652

1,304

1,951

1,553

1,302

654

106

105

105

464

536

535

560

201

478

478

621

0

0

0

Proceeds from issuance of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7

7

7

118

180

180

181

135

231

231

231

166

8

38

38

38

38

457

456

456

457

21

21

21

20

0

0

0

Repurchases of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

32

2

0

0

0

0

0

0

-

-

-

-

-

-

-

-

18

18

18

18

0

0

0

0

-

-

-

-

-

-

-

-

Purchase of common stock for settlement of equity awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

23

23

23

23

0

0

0

0

-

-

-

-

-

-

-

-

Dividends paid

808

791

773

758

742

730

727

725

723

721

711

700

691

681

662

644

625

607

596

585

573

561

549

538

521

514

506

498

492

486

485

481

478

474

461

451

441

432

427

423

419

414

0

0

0

Other, net

-34

-14

-14

-14

-15

-20

-20

-16

-18

-21

-20

-21

-20

-12

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by financing activities

2,108

1,181

1,874

831

916

928

556

686

167

168

114

357

319

209

665

622

691

590

143

-75

3

430

587

724

785

654

-47

670

490

349

696

-71

-195

-205

625

885

978

905

271

-281

-158

-322

0

0

0

Net change in cash, cash equivalents and restricted cash

150

101

651

21

-22

64

45

270

42

-2

-185

-14

-27

0

-51

-59

-31

5

266

36

0

-27

36

40

19

24

-645

-4

13

21

553

-38

5

-47

-29

26

8

-7

120

-316

-228

-144

0

0

0

Net increase (decrease) in cash and cash equivalents - discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Supplemental disclosure of cash flow information:
Cash paid for interest (net of amounts capitalized)

715

698

686

664

642

633

618

628

623

616

619

599

601

592

579

570

545

543

530

527

521

512

510

508

513

514

538

540

560

563

562

545

536

531

545

542

547

530

1,304

517

799

514

0

0

0

Cash received (paid) for income taxes, net

-53

-53

0

0

0

-

-

-

-

-

-

-

-

-62

-61

-60

-2

-58

-58

-58

-58

4

4

1

0

-17

-13

-9

-9

9

4

5

4

-55

-54

-46

-42

16

-25

-39

-18

-21

0

0

0

Supplemental disclosure of non-cash investing and financing transactions:
Accrued property, plant and equipment additions

467

421

468

426

383

388

535

497

521

464

358

291

304

311

258

367

274

322

294

318

367

417

560

455

485

452

359

317

322

289

231

291

245

137

248

241

263

174

97

159

65

68

0

0

0

Inventory transfers to property, plant and equipment

103

88

119

134

131

129

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Operating lease right-of-use assets

184

1,843

1,718

1,843

1,659

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Allowance for equity funds used during construction

80

77

84

99

105

108

100

93

84

75

69

64

61

61

60

58

56

56

61

69

80

89

93

91

89

87

81

76

69

62

57

53

51

51

55

56

56

56

59

65

70

75

0

0

0

Issuance of common stock for equity awards

64

63

61

64

64

67

60

47

39

31

34

34

33

29

31

35

46

53

58

63

61

62

44

48

52

56

71

69

67

67

67

69

70

71

70

69

67

63

58

50

44

54

0

0

0