Illumina, inc. (ILMN)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Apr'18Dec'17Sep'17Jun'17Mar'17Jan'17Sep'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
Cash flows from operating activities:
Consolidated net income

939,000

990,000

948,000

902,000

809,000

782,000

642,000

607,000

0

678,000

728,000

692,000

688,000

428,000

424,474

423,095

409,342

458,000

507,806

485,674

430,032

353,351

280,732

218,600

207,872

125,308

116,550

114,941

102,465

151,254

91,071

81,474

88,693

86,628

113,348

128,644

127,820

124,891

0

0

0

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

151,000

151,000

153,000

151,000

147,000

140,000

129,000

123,000

0

110,000

106,000

100,000

95,000

90,000

85,226

80,796

77,246

73,000

69,896

66,124

64,066

61,905

58,512

57,077

53,644

50,810

49,766

48,490

48,049

48,249

50,836

53,063

54,705

55,575

49,896

44,389

39,642

34,204

0

0

0

Amortization of intangible assets

34,000

37,000

40,000

40,000

40,000

39,000

39,000

41,000

0

46,000

49,000

50,000

51,000

51,000

51,116

52,402

52,652

54,000

53,714

51,319

50,203

50,669

51,277

52,901

52,157

47,115

39,611

30,298

22,374

17,070

15,252

14,238

14,100

13,617

11,796

10,903

9,170

7,805

0

0

0

Share-based compensation expense

182,000

194,000

192,000

194,000

196,000

193,000

187,000

173,000

0

164,000

150,000

151,000

144,000

129,000

137,896

135,125

136,082

133,000

135,566

148,006

151,045

152,551

143,835

126,575

115,031

105,826

100,256

95,919

95,514

94,324

91,964

93,463

93,082

92,092

90,117

83,506

76,685

71,645

0

0

0

Accretion of debt discount

42,000

46,000

51,000

52,000

47,000

41,000

33,000

31,000

0

30,000

31,000

30,000

29,000

30,000

31,172

33,624

36,831

39,000

39,908

40,448

39,246

38,069

37,131

36,202

36,220

36,237

35,999

35,738

35,414

35,004

34,600

34,286

34,258

32,173

29,176

26,088

22,718

21,407

0

0

0

Loss on extinguishment of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-37,611

0

0

0

-

-

-

-

Contingent compensation expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

6,366

6,092

4,778

6,306

4,609

3,849

5,174

3,457

0

0

0

-

-

-

-

Incremental tax benefit related to share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

145,543

155,308

152,396

126,479

132,092

119,167

101,928

56,678

35,545

24,422

16,567

20,783

18,430

24,239

45,848

46,354

68,281

67,765

47,945

42,445

0

0

0

Deferred income taxes

7,000

-11,000

-1,000

-10,000

18,000

18,000

4,000

7,000

0

-81,000

-89,000

-132,000

-186,000

-94,000

-55,321

-28,419

-21,548

-81,000

-213,953

-211,939

-187,241

-99,846

125,734

97,008

107,310

36,663

-43,902

-22,779

-53,079

-21,698

-23,421

-12,646

7,268

19,227

36,061

44,777

50,680

48,696

0

0

0

Marketable Securities, Unrealized Gain (Loss)

54,000

53,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deconsolidation, Gain (Loss), Amount

-

54,000

0

0

0

-

-

-

-

453,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss on derivative assets related to terminated acquisition

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of intangible assets

-

-

-

-

-

-

-

-

-

23,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-8,847

-9,623

-13,483

-5,356

-10,711

-16,813

-21,008

-18,784

-10,769

-470

4,176

1,975

-5,763

-7,695

-5,967

-4,500

0

0

0

-

-

-

-

Cost-method investment gain, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,000

0

0

0

-

-

-

-

61,357

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other

0

1,000

6,000

-5,000

-7,000

-4,000

-3,000

0

0

-1,000

5,000

6,000

-1,000

-2,000

-2,822

-3,396

-1,745

-4,000

-15,427

-17,042

-17,509

-15,618

-16,649

-12,849

-8,068

-12,811

100

955

-1,017

-251

-4,761

-8,460

-10,865

-9,949

-12,314

-12,212

-12,663

-8,811

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

15,000

58,000

110,000

71,000

60,000

105,000

51,000

28,000

0

26,000

1,000

-4,000

-32,000

-3,000

-30,309

7,811

49,526

96,000

133,957

108,381

57,699

50,381

41,157

45,071

74,213

15,928

9,900

9,274

-846

34,441

41,512

-527

25,057

7,011

-2,364

34,757

18,168

7,844

0

0

0

Inventory

-27,000

-25,000

46,000

61,000

62,000

53,000

46,000

52,000

0

33,000

15,000

-2,000

12,000

30,000

79,402

89,474

83,956

81,000

35,447

45,881

40,595

36,542

38,078

8,611

-4,492

-6,217

10,645

27,256

32,132

23,707

623

-12,818

-26,261

-22,152

2,805

16,293

44,352

48,583

0

0

0

Prepaid expenses and other current assets

34,000

14,000

16,000

7,000

-13,000

-5,000

-1,000

-4,000

0

-8,000

-10,000

1,000

-4,000

1,000

3,018

4,618

12,843

11,000

-21,789

-6,699

-5,337

-6,619

16,979

-971

-372

-1,783

3,050

5,563

2,757

3,062

-12,056

-6,374

-4,660

2,016

15,491

6,077

4,438

-2,554

0

0

0

Operating lease right-of-use assets and liabilities, net

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

33,000

30,000

29,000

15,000

16,000

9,000

11,000

7,000

0

5,000

4,000

5,000

6,000

7,000

7,572

3,654

1,470

2,000

31,422

23,055

29,814

36,256

18,192

29,642

23,241

16,357

3,613

4,178

2,865

2,903

3,611

2,359

3,037

4,004

4,209

5,738

5,473

3,566

0

0

0

Accounts payable

-4,000

-35,000

-14,000

1,000

-4,000

45,000

0

0

0

-

-

-

-8,000

-2,000

-10,532

23,282

20,133

46,000

32,678

14,728

16,701

-2,106

28,013

18,271

3,990

2,389

-14,198

80

13,312

15,112

12,234

1,906

-10,208

-21,097

-9,246

-3,202

15,226

23,150

0

0

0

Accrued liabilities

-77,000

-44,000

-23,000

-1,000

51,000

103,000

70,000

57,000

0

81,000

89,000

48,000

58,000

-24,000

18,116

92,437

120,044

99,000

43,618

27,036

32,435

60,332

67,216

66,783

30,670

38,550

8,989

-21,281

-5,102

24,388

24,882

31,731

35,485

38,945

42,134

43,139

44,650

32,028

0

0

0

Other long-term liabilities

8,000

-33,000

-14,000

-1,000

-26,000

-4,000

133,000

126,000

0

160,000

29,000

27,000

16,000

16,000

20,220

11,455

7,479

5,000

-7,167

1,158

2,297

1,861

5,581

4,356

3,527

3,816

9,790

3,748

3,601

6,640

3,769

11,410

13,422

8,058

3,633

1,934

423

-113

0

0

0

Accrued legal contingencies

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

Unrealized (gain) loss on foreign exchange

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Net cash provided by operating activities

1,134,000

1,051,000

908,000

933,000

1,085,000

1,142,000

1,136,000

1,079,000

0

875,000

843,000

784,000

848,000

779,000

883,782

888,776

818,221

786,000

559,767

524,378

530,963

501,271

487,561

425,092

335,668

386,421

338,458

306,550

314,273

291,873

321,297

360,111

335,002

358,140

331,321

296,107

302,086

272,573

0

0

0

Cash flows from investing activities:
Maturities of available-for-sale securities

463,000

1,387,000

1,412,000

1,508,000

1,476,000

860,000

850,000

781,000

0

321,000

173,000

123,000

112,000

140,000

252,071

311,388

327,436

294,000

221,929

153,198

148,718

150,229

174,013

167,516

221,939

289,197

505,446

514,557

490,112

400,379

496,060

509,455

452,205

492,444

0

0

0

-

-

-

-

Purchases of available-for-sale securities

1,149,000

1,010,000

1,267,000

2,115,000

2,378,000

2,859,000

2,735,000

1,793,000

0

742,000

575,000

678,000

871,000

895,000

762,138

521,575

556,617

797,000

1,076,414

1,010,803

863,380

791,252

614,189

565,376

519,776

364,001

301,637

520,736

691,306

925,478

1,035,948

1,065,525

1,281,264

1,310,269

1,259,452

1,340,176

1,092,826

846,208

0

0

0

Sales of available-for-sale securities

697,000

629,000

605,000

651,000

427,000

597,000

528,000

515,000

0

322,000

451,000

347,000

544,000

543,000

652,649

653,553

468,844

582,000

402,452

363,838

454,781

391,655

335,672

313,861

334,484

523,635

344,309

639,772

587,786

498,371

519,649

534,759

540,080

568,447

0

0

0

-

-

-

-

Deconsolidation of Helix cash

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the deconsolidation of GRAIL

-

15,000

0

0

0

-

-

-

-

278,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for derivative assets related to terminated acquisition

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from sale of strategic investment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

Purchases of property and equipment

193,000

209,000

217,000

232,000

262,000

296,000

307,000

325,000

0

310,000

316,000

291,000

290,000

260,000

213,639

186,098

159,449

143,000

142,193

141,562

123,535

105,996

98,474

88,576

76,786

79,215

69,006

67,726

77,138

68,781

78,794

83,327

78,584

77,800

63,070

53,999

50,938

49,818

0

0

0

Net purchases of strategic investments

-

20,000

18,000

19,000

15,000

15,000

16,000

13,000

0

29,000

30,000

33,000

18,000

14,000

10,900

12,926

22,067

6,000

9,100

-853

-5,912

11,755

-82,854

-78,326

-80,982

-95,580

-61,882

-61,483

-58,379

-40,881

17,415

22,091

20,794

13,769

16,611

16,735

12,001

27,677

0

0

0

Sales and maturities of available-for-sale securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Net cash paid for acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

18,000

0

0

0

-

-

-

-

-

-

-

-

523,501

0

0

0

-

-

-

0

58,302

58,303

81,444

146,513

98,211

0

0

0

Cash paid for intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

36,220

15,219

9,126

11,468

11,344

0

0

0

-

-

-

1,636

1,750

0

0

0

-

-

-

-

Net cash (used in) provided by investing activities

-378,000

745,000

501,000

-221,000

-837,000

-1,813,000

-1,780,000

-937,000

0

-214,000

-73,000

-317,000

-308,000

-515,000

-112,456

189,617

3,147

-107,000

-668,327

-673,631

-416,384

-406,624

-224,651

-281,715

-149,015

-69,649

99,772

183,962

-73,163

-150,012

-211,583

-127,377

-389,993

-400,999

-428,096

-589,069

-413,265

-285,053

0

0

0

Cash flows from financing activities:
Payments on financing obligations

-

550,000

551,000

552,000

3,000

4,000

5,000

5,000

0

9,000

2,000

0

-9,000

66,000

99,793

308,336

320,886

245,000

216,318

8,908

451

29,991

30,011

31,459

40,448

10,852

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

Proceeds from issuance of convertible notes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

903,492

0

0

0

-

-

-

-

Repurchase of convertible notes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Incremental tax benefit related to share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

145,543

155,308

152,396

126,479

132,092

119,167

101,928

56,678

35,545

24,422

16,567

20,783

18,430

24,239

45,848

46,354

68,281

67,765

47,945

42,445

0

0

0

Payments for Repurchase of Common Stock

449,000

324,000

0

0

0

-

-

-

-

251,000

0

0

0

-

-

-

-

274,000

107,008

69,505

141,919

237,183

202,431

202,431

155,026

50,020

80,033

100,043

107,533

82,522

52,509

236,579

232,086

570,406

0

0

0

-

-

-

-

Taxes paid related to net share settlement of equity awards

94,000

82,000

86,000

85,000

84,000

74,000

58,000

59,000

0

68,000

52,000

51,000

53,000

100,000

107,843

110,018

112,161

127,000

95,527

90,611

85,051

10,038

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the exercise of warrants

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,954

17,895

16,029

0

0

0

Proceeds from issuance of common stock

64,000

59,000

60,000

54,000

52,000

46,000

53,000

62,000

0

71,000

63,000

51,000

46,000

47,000

53,332

56,487

65,273

72,000

77,263

84,689

94,010

96,328

98,967

107,533

113,267

94,460

95,877

67,417

43,474

54,358

35,076

48,049

70,636

61,938

85,787

83,990

91,280

102,016

0

0

0

Contributions from noncontrolling interest owners

-

-

-

-

-

92,000

92,000

135,000

0

79,000

88,000

45,000

25,000

89,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on acquisition related contingent consideration liability

-

-

-

-

-

-

-

-

-

-

-

-

-

29,000

0

0

0

-

-

-

-

-

-

-

-

3,985

3,985

3,985

7,359

3,374

0

0

0

-

-

-

-

-

-

-

-

Net cash used in financing activities

-1,028,000

-897,000

-936,000

-112,000

467,000

594,000

639,000

-17,000

0

-176,000

-212,000

-198,000

-311,000

-296,000

-530,379

-720,276

-603,466

-545,000

-165,419

70,973

-93,358

-166,748

-123,394

-253,942

-111,637

-38,719

-88,317

-21,329

-57,377

-10,755

3,135

-176,630

-94,849

97,016

115,712

315,950

307,649

116,474

0

0

0

Effect of exchange rate changes on cash and cash equivalents

0

-

-

-

-

-4,000

-3,000

0

0

5,000

1,000

-2,000

-3,000

-2,000

2,678

2,980

3,715

-1,000

-4,387

-5,884

-6,197

-3,382

-1,457

2,175

415

-397

-1,166

-1,984

-845

-103

394

-776

-307

-126

358

909

646

320

0

0

0

Net (decrease) increase in cash and cash equivalents

-279,000

898,000

469,000

599,000

710,000

-81,000

-8,000

125,000

0

490,000

559,000

267,000

226,000

-34,000

243,625

361,097

221,617

133,000

-278,366

-84,164

15,024

-75,483

138,059

-108,390

75,431

277,656

348,747

467,199

182,888

131,003

113,243

55,328

-150,147

54,031

19,079

23,897

197,116

104,314

0

0

0