Tableau software, inc. (DATA)
CashFlow / TTM
Jun'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'13
Operating activities
Net loss

-142,904

-119,452

-77,042

-121,713

-146,929

-177,385

-185,560

-164,810

-148,518

-153,518

-144,449

-164,682

-147,794

-119,251

-83,700

-21,672

-12,930

1,475

5,873

-3,589

3,483

5,482

7,076

0

0

0

Adjustments to reconcile net loss to net cash provided by operating activities
Depreciation and amortization expense

46,281

41,003

35,787

38,355

39,959

40,958

44,746

52,089

50,842

48,834

43,006

32,537

29,522

26,475

23,667

20,260

18,116

15,791

13,512

11,743

9,654

8,028

6,850

0

0

0

Amortization (accretion) on investments, net

2,254

1,265

424

-165

-496

-477

-359

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Stock-based compensation expense

259,362

248,587

238,731

230,681

223,049

216,851

210,283

203,381

196,450

189,707

185,712

175,145

159,335

142,421

119,468

97,771

78,711

61,302

47,018

36,448

27,665

19,921

14,457

0

0

0

Donation of Class A common stock

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14,991

11,548

11,056

14,061

8,660

8,563

9,011

5,725

0

0

0

Deferred income taxes

788

449

-2,180

-6,572

-7,418

-7,342

-2,988

711

1,445

1,248

1,219

31,972

31,681

31,228

28,558

-7,563

-6,959

-6,851

-899

-221

-132

265

-3,052

0

0

0

Changes in operating assets and liabilities
Accounts receivable, net

49,746

51,347

36,519

53,305

28,510

-8,627

-12,493

-6,983

3,528

25,309

78,197

22,866

37,006

24,749

34,225

50,100

45,114

37,156

41,015

23,946

22,462

21,936

30,001

0

0

0

Prepaid expenses and other assets

89,647

95,320

95,347

63,479

56,390

26,107

-8,054

8,770

-951

5,422

18,987

10,972

7,029

15,000

13,783

17,206

13,668

8,120

6,950

4,856

3,414

4,119

4,758

0

0

0

Income taxes receivable

1,430

1,618

1,675

946

543

715

515

425

225

4

56

-198

-142

-126

-147

-1,898

-1,929

-1,827

-1,816

-2,431

-1,764

-1,539

961

0

0

0

Deferred revenue

61,137

53,886

56,555

83,495

89,973

112,423

123,938

112,101

115,278

111,901

116,860

83,444

80,254

71,131

71,383

68,327

71,499

68,018

62,752

47,445

37,785

33,132

34,740

0

0

0

Accounts payable and accrued liabilities

12,610

29,958

38,396

42,554

38,613

25,870

13,529

48,566

36,650

54,827

71,157

35,655

37,927

31,718

30,224

38,691

31,776

24,569

21,181

19,111

14,876

14,613

19,037

0

0

0

Income taxes payable

-1,334

-2,881

-1,586

5,368

-708

1,330

2,528

506

1,415

1,779

997

1,024

720

690

664

315

220

330

224

-88

-84

-50

62

0

0

0

Net cash provided by operating activities

117,093

126,230

154,696

154,603

151,592

194,987

226,867

250,494

250,760

224,043

177,262

166,143

148,385

145,113

142,403

115,730

112,032

110,129

89,451

75,588

60,543

47,846

37,725

0

0

0

Investing activities
Purchases of property and equipment

34,833

27,237

20,446

32,627

39,039

43,836

61,823

61,577

71,140

70,317

60,732

54,672

49,465

51,163

45,130

42,952

41,387

40,660

36,748

32,680

25,741

18,277

17,607

0

0

0

Business combinations, net of cash acquired

4,500

15,447

10,947

0

0

0

-

-

-

-

16,399

16,399

17,399

17,399

1,000

0

0

0

-

-

-

-

-

-

-

-

Purchases of investments

534,846

436,846

285,277

430,029

578,310

524,169

421,719

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of investments

412,525

277,821

262,835

230,515

170,315

108,015

30,630

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Sales of investments

2,072

2,072

2,171

15,015

15,015

15,015

14,916

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-159,582

-199,637

-51,664

-228,073

-466,932

-468,941

-461,962

-283,687

-71,140

-70,317

-77,131

-71,071

-66,864

-68,562

-46,130

-43,952

-39,693

-38,966

-35,054

-30,986

-25,741

-18,277

-17,607

0

0

0

Financing activities
Proceeds from public offering, net of underwriters' discount and offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

344,077

344,077

344,097

521,360

176,974

0

0

0

Proceeds from issuance of common stock

49,035

48,505

44,710

41,415

42,791

37,039

38,856

37,458

37,962

34,673

34,356

25,210

25,257

15,761

20,117

19,547

19,663

19,022

16,151

21,564

18,338

14,947

10,522

0

0

0

Repurchases of common stock

64,337

94,343

120,024

110,024

99,990

89,990

79,991

79,995

60,023

40,017

20,009

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred initial public offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Excess tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14,991

11,548

11,056

14,061

8,660

8,563

9,011

5,725

0

0

0

Net cash provided by (used in) financing activities

-15,302

-45,838

-75,314

-68,609

-57,199

-52,951

-41,135

-42,537

-22,061

-5,344

14,347

20,522

24,624

15,437

20,117

34,538

31,191

29,769

374,289

374,301

370,998

546,368

193,221

0

0

0

Effect of exchange rate changes on cash and cash equivalents

238

-3,693

-2,574

-9,612

-9,274

-3,750

-4,609

2,082

598

-1,735

-1,661

-1,192

-904

350

-1,103

-641

-1,338

-1,776

-747

-724

103

91

33

0

0

0

Net decrease in cash and cash equivalents

-57,553

-122,938

25,144

-151,691

-381,813

-330,655

-280,839

-73,648

158,157

146,647

112,817

114,402

105,241

92,338

115,287

105,675

102,192

99,156

427,939

418,179

405,903

576,028

213,372

0

0

0

Non-cash activities
Accrued purchases of property and equipment

13,023

14,432

7,885

-4,316

7,108

2,623

6,470

29,995

13,760

24,943

26,548

12,003

18,673

13,296

10,012

10,064

7,129

8,541

4,776

0

0

0

-

-

0

0

Asset retirement obligations recognized, net

-

-

-

-

-

-

-

-

-

-

-

409

37

118

271

447

971

971

667

0

0

0

-

-

-

-

Deferred public offering cost accruals

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0