Molina healthcare, inc. (MOH)
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'11
Operating activities:
Net income

717,000

737,000

770,000

792,000

798,000

707,000

244,000

-50,000

-482,000

-512,000

-297,000

-158,000

105,000

52,000

129,000

133,000

139,000

143,000

146,569

116,691

85,502

62,000

19,376

10,823

27,583

53,000

87,698

83,493

21,616

9,790

-48,813

-33,227

21,519

20,818

0

0

0

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

84,000

89,000

91,000

101,000

115,000

127,000

143,000

155,000

166,000

178,000

186,000

189,000

187,000

182,000

168,000

153,000

137,000

126,000

127,536

130,346

134,006

134,000

125,429

115,747

105,195

94,000

88,510

84,661

82,224

78,764

80,258

77,791

74,628

74,383

0

0

0

Deferred income taxes

-9,000

-10,000

-33,000

-19,000

-15,000

6,000

58,000

59,000

95,000

94,000

66,000

58,000

13,000

-22,000

-25,000

-25,000

-22,000

7,000

3,295

-3,308

330

2,000

4,263

8,153

32,654

32,000

48,852

30,778

18,166

9,887

-6,290

-15,411

-20,480

-13,836

0

0

0

Share-based compensation

42,000

39,000

36,000

33,000

30,000

27,000

28,000

24,000

46,000

46,000

40,000

45,000

25,000

26,000

31,000

30,000

24,000

23,000

21,885

20,544

22,404

22,000

24,461

27,306

30,175

29,000

25,224

22,356

19,773

20,018

19,777

18,490

17,654

17,052

0

0

0

Gain on debt repayment

12,000

15,000

18,000

10,000

-9,000

-22,000

-39,000

-29,000

-24,000

-14,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash restructuring charges

-

-

-

-

-

17,000

28,000

77,000

77,000

60,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of premium/discount on investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-7,108

-7,418

-7,448

-7,242

0

0

0

Amortization of deferred financing costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

1,192

2,326

2,573

2,818

0

0

0

Change in fair value of derivatives, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

-

-

-

-

Change in fair value of contingent consideration liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Gain on disposal of property and equipment, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Tax deficiency from employee stock compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

226

275

481

714

0

0

0

Gain on sale of subsidiary

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Amortization of convertible senior notes and lease financing obligations

-

-

-

-

-

22,000

26,000

29,000

31,000

32,000

32,000

32,000

31,000

31,000

31,000

30,000

31,000

30,000

28,805

28,545

27,326

27,000

27,067

26,767

25,951

23,000

17,656

12,715

8,222

5,942

5,831

5,716

5,615

5,512

0

0

0

Other, net

-14,000

-5,000

-7,000

3,000

8,000

4,000

14,000

18,000

20,000

21,000

15,000

12,000

13,000

16,000

20,000

21,000

22,000

19,000

16,125

14,277

11,548

7,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Receivables

244,000

76,000

-27,000

124,000

476,000

530,000

376,000

180,000

-52,000

-103,000

-51,000

-35,000

114,000

348,000

348,000

324,000

315,000

-56,000

194,252

158,421

153,703

298,000

131,463

259,485

187,728

149,000

137,058

52,769

-72,003

-18,216

-5,930

19,756

73,392

-352

0

0

0

Prepaid expenses and other current assets

221,000

-28,000

-117,000

-205,000

-265,000

-6,000

120,000

199,000

283,000

56,000

6,000

-36,000

-121,000

69,000

88,000

81,000

100,000

35,000

31,418

50,113

78,977

20,000

47,030

67,031

92,067

23,000

25,936

21,462

12,274

8,958

5,447

4,264

-5,737

-3,308

0

0

0

Medical claims and benefits payable

-14,000

-107,000

-68,000

-153,000

-29,000

-226,000

-430,000

-152,000

103,000

263,000

607,000

292,000

-32,000

226,000

291,000

272,000

489,000

482,000

435,941

568,605

629,246

531,000

490,883

458,438

328,139

175,000

96,243

-60,051

35,312

92,054

175,408

183,925

104,451

48,120

0

0

0

Amounts due government agencies

-155,000

-303,000

-418,000

-762,000

-781,000

-574,000

-292,000

-96,000

140,000

341,000

92,000

606,000

665,000

473,000

252,000

413,000

288,000

202,000

582,225

648,128

521,735

470,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Accounts payable, accrued liabilities and other

279,000

2,000

-316,000

-365,000

-304,000

45,000

296,000

355,000

257,000

-12,000

85,000

-169,000

-159,000

-4,000

51,000

73,000

100,000

84,000

71,384

111,375

141,048

11,000

-14,375

107,593

123,799

33,000

38,099

14,092

11,027

8,078

-6,498

-11,489

-6,222

2,778

0

0

0

Deferred revenue

-164,000

38,000

30,000

-160,000

-155,000

-21,000

-242,000

-44,000

-50,000

-34,000

88,000

179,000

367,000

92,000

310,000

43,000

-79,000

24,000

-123,640

12,271

23,940

74,000

66,050

-422

10,054

-20,000

-18,913

-130,424

40,314

90,851

58,800

79,197

-26,227

-8,154

0

0

0

Income taxes

2,000

-15,000

-63,000

-79,000

16,000

51,000

124,000

141,000

3,000

-16,000

-80,000

-46,000

57,000

-26,000

-20,000

-33,000

-48,000

-22,000

46,937

26,984

39,358

42,000

-12,925

-31,960

-42,782

-39,000

39,038

46,885

30,259

18,172

-27,776

-37,021

-23,088

-24,855

0

0

0

Net cash provided by operating activities

314,000

427,000

275,000

-472,000

-459,000

-314,000

-344,000

446,000

479,000

804,000

997,000

1,067,000

1,253,000

673,000

852,000

755,000

710,000

1,125,000

1,124,802

1,472,540

1,403,103

1,060,000

919,454

537,208

380,793

190,000

195,504

53

317,313

347,784

334,256

346,480

191,847

225,395

0

0

0

Investing activities:
Purchases of investments

2,929,000

2,536,000

2,180,000

1,692,000

1,240,000

1,444,000

2,005,000

1,975,000

2,353,000

2,697,000

2,379,000

2,591,000

2,051,000

1,929,000

2,056,000

1,904,000

2,096,000

1,923,000

1,647,676

1,577,696

1,248,855

953,000

758,371

606,153

836,133

770,000

699,925

694,240

294,250

306,437

322,224

306,669

329,183

345,968

0

0

0

Proceeds from sales and maturities of investments

2,429,000

2,302,000

2,265,000

1,901,000

2,268,000

2,445,000

2,293,000

2,220,000

1,869,000

1,759,000

1,990,000

2,028,000

2,051,000

1,966,000

1,775,000

1,397,000

1,219,000

1,126,000

1,022,164

847,352

740,630

633,000

646,036

577,228

471,723

400,000

312,141

310,654

307,886

298,006

289,919

318,005

307,159

302,667

0

0

0

Purchases of property, equipment and capitalized software

72,000

57,000

36,000

36,000

32,000

30,000

25,000

40,000

64,000

86,000

118,000

134,000

156,000

176,000

174,000

168,000

153,000

132,000

144,229

143,330

122,212

115,000

105,345

100,441

104,621

98,000

90,023

80,073

75,807

78,145

67,208

63,016

59,145

60,581

0

0

0

Increase in restricted investments held-to-maturity

-

-

-

-

-

-

-

-

-

-

-

-

-3,000

-

-3,000

-13,000

5,000

6,000

14,699

32,378

24,619

34,000

22,177

21,788

22,365

19,000

20,737

13,327

13,170

2,647

-1,296

-2,012

-2,650

4,064

0

0

0

Proceeds from sale of subsidiary, net of cash surrendered

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Net cash paid in business combinations

-

-

-

-

-

-

-

-

-

-

-

-

-

48,000

421,000

450,000

444,000

450,000

113,500

52,000

52,000

44,000

11,816

62,000

62,000

62,000

0

0

0

-

-

-

-

84,253

0

0

0

Other, net

-5,000

2,000

-3,000

11,000

17,000

18,000

28,000

23,000

37,000

38,000

40,000

37,000

26,000

19,000

13,000

24,000

27,000

35,000

41,780

32,612

29,453

23,000

11,191

-6,624

-5,861

-6,000

6,777

17,152

11,474

13,523

6,140

8,471

3,345

1,898

0

0

0

Proceeds from sale of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Change in deferred contract costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

28,864

49,480

46,188

42,830

0

0

0

Net cash (used in) provided by investing activities

-567,000

-293,000

242,000

352,000

1,169,000

1,143,000

235,000

182,000

-580,000

-1,062,000

-551,000

-779,000

-229,000

-206,000

-886,000

-1,136,000

-1,506,000

-1,420,000

-939,720

-990,664

-736,509

-536,000

-262,864

-213,524

-549,291

-543,000

-544,206

-464,089

-72,066

-93,584

-205,059

-179,457

-199,890

-236,927

0

0

0

Financing activities:
Proceeds from borrowings under term loan facility

-

-

-

-

-

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

60,000

0

0

0

-

-

-

-

Purchase of call option

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

149,000

149,331

149,331

149,331

0

0

0

0

-

-

-

-

Proceeds from issuance of warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

75,000

75,074

75,074

75,074

0

0

0

0

-

-

-

-

Contingent consideration liabilities settled

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

50,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments for Repurchase of Common Stock

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

53,000

53,000

53,000

53,000

3,000

0

0

0

-

-

-

-

Cash paid for financing transaction fees

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from senior notes offerings, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

538,000

537,973

537,973

537,973

0

0

0

0

-

-

-

-

Proceeds from borrowings under term loan facility

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for Repurchase of Warrants

441,000

514,000

644,000

860,000

652,000

549,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of principal amount of 1.125% Convertible Notes

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for partial settlement of conversion option

490,000

578,000

724,000

962,000

738,000

623,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash received for partial settlement of call option

490,000

578,000

724,000

962,000

738,000

623,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of principal amount of convertible senior notes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on term loan

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

48,000

47,754

48,027

1,119

1,129

0

0

0

-

-

-

-

Repayment of amount borrowed under credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

40,000

40,000

50,000

60,000

20,000

0

0

0

-

-

-

-

Proceeds from employee stock plans

-

-

-

-

-

-

-

-

-

-

-

-

19,000

-

20,000

20,000

17,000

18,000

14,372

14,383

13,670

14,000

11,472

11,765

10,095

9,000

7,790

7,572

5,692

8,205

7,278

7,192

7,633

7,347

0

0

0

Excess tax benefits from employee stock compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

3,759

3,762

4,167

1,651

0

0

0

Other, net

25,000

29,000

35,000

46,000

24,000

18,000

11,000

2,000

8,000

11,000

25,000

26,000

15,000

19,000

3,000

3,000

3,000

5,000

2,883

3,936

5,143

2,000

3,754

3,064

2,857

2,000

0

0

0

-

-

-

-

-

-

-

-

Net cash used in financing activities

-622,000

-552,000

-691,000

-1,052,000

-1,236,000

-1,193,000

-1,008,000

-200,000

632,000

636,000

640,000

341,000

16,000

19,000

712,000

712,000

1,082,000

1,085,000

380,217

504,668

119,932

79,000

85,325

-39,128

82,231

493,000

489,778

479,614

406,541

47,743

98,791

100,856

61,974

49,473

0

0

0

Net (decrease) increase in cash, cash equivalents, and restricted cash and cash equivalents

-875,000

-418,000

-174,000

-1,172,000

-526,000

-364,000

-1,117,000

428,000

531,000

378,000

1,086,000

629,000

1,040,000

486,000

678,000

331,000

286,000

790,000

565,299

986,544

786,526

603,000

741,915

284,556

-86,267

140,000

141,076

15,578

651,788

301,943

227,988

267,879

53,931

37,941

0

0

0

Supplemental cash flow information:
Cash paid during the period for:
Income taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

95,000

66,448

35,699

9,021

-4,634

12,187

24,874

41,652

54,663

0

0

0

Interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

35,000

32,471

27,313

26,365

10,099

12,036

11,733

11,929

11,399

0

0

0

Schedule of non-cash investing and financing activities:
Common stock issued in exchange for convertible senior notes

-

-

-

-

-

131,000

324,000

324,000

324,000

193,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Component of convertible senior notes allocated to additional paid-in capital, net of income taxes

-

-

-

-

-

-23,000

-55,000

-55,000

-55,000

-32,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net increase to additional paid-in capital

-

-

-

-

-

108,000

269,000

269,000

269,000

161,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Retirement of treasury stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

56,000

53,000

53,000

53,000

0

0

0

0

-

-

-

-

Increase in non-cash lease financing obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14,000

21,619

39,447

34,775

27,000

0

0

0

-

-

-

-

-

-

-

-

Common stock used for share-based compensation

7,000

7,000

7,000

7,000

8,000

6,000

7,000

7,000

21,000

22,000

21,000

22,000

7,000

8,000

14,000

13,000

13,000

15,000

9,405

9,547

9,783

9,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Fair value of assets acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

186,000

506,000

520,000

523,000

389,000

113,500

52,000

52,000

52,000

0

0

0

-

-

-

-

0

0

0

0

-

-

-

-

Fair value of liabilities assumed

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Payable to seller

-

-

-

-

-

-

-

-

-

-

-

-

-

8,000

16,000

29,000

38,000

0

0

0

0

8,000

0

0

0

-

-

-

-

0

0

0

0

-

-

-

-

Amounts advanced for acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

102,000

0

0

0

-102,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash paid in business combinations

-

-

-

-

-

-

-

-

-

-

-

-

-

48,000

421,000

450,000

444,000

450,000

113,500

52,000

52,000

44,000

11,816

62,000

62,000

62,000

0

0

0

-

-

-

-

84,253

0

0

0

Common stock used for stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

Details of change in fair value of derivatives, net:
Change in fair value of derivatives, net

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

-8

-10

-2

0

-609

-606

-4,117

-4,000

0

0

0

-

-

-

-

-

-

-

-

Proceeds from sale of subsidiary, net of cash surrendered

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

1.125% Call Option
Change in fair value of derivatives, net

-25,000

132,000

380,000

608,000

669,000

577,000

418,000

217,000

404,000

255,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Embedded Derivative Financial Instruments [Member]
Change in fair value of derivatives, net

25,000

-132,000

-380,000

-608,000

-669,000

-577,000

-418,000

-217,000

-404,000

-255,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-