Alteryx, inc. (AYX)
CashFlow / TTM
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16
Cash flows from operating activities:
Net Income (Loss) Attributable to Parent

5,756

27,143

12,996

30,057

29,037

28,020

9,940

-4,180

-6,935

-17,499

-22,037

-22,930

-23,392

-24,258

0

0

0

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

9,640

8,292

5,459

4,771

5,361

5,218

3,901

4,478

4,187

3,484

3,165

2,427

1,935

1,677

0

0

0

Non-cash operating lease cost

5,845

5,088

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation

41,454

33,125

26,777

22,323

18,193

16,647

14,497

12,394

10,733

8,886

7,404

6,031

4,589

3,284

0

0

0

Amortization (accretion) of discounts and premiums on investments, net

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt discount and issuance costs

23,601

18,625

13,668

10,904

9,351

6,652

0

0

0

-

-

-

-

-

-

-

-

Provision for doubtful accounts, net of recoveries

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Deferred income taxes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Provision for doubtful accounts, net of recoveries

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Deferred income taxes

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

Other non-cash operating activities, net

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Recoveries of doubtful accounts

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Change in fair value of contingent consideration

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Loss on disposal of assets

-

-

-

-

-

-

-

-

-

-

-42

-22

-131

-66

0

0

0

Loss on remeasurement of intercompany loan

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities, net of effect of business acquisitions:
Accounts receivable

3,304

35,325

17,639

20,820

23,313

45,640

20,520

17,513

5,947

15,325

7,014

11,330

11,368

14,248

0

0

0

Deferred commissions

18,823

20,461

11,509

11,336

12,709

12,741

8,950

6,037

4,012

3,663

2,160

2,095

1,999

1,582

0

0

0

Prepaid expenses and other current assets and other assets

47,866

34,971

26,151

19,463

15,585

16,077

20,154

14,463

10,256

3,508

5,334

5,336

5,156

4,314

0

0

0

Accounts payable

4,842

2,319

3,708

2,255

5,849

4,530

2,784

3,584

-515

-1,483

1,208

3,028

918

2,134

0

0

0

Accrued payroll and payroll related liabilities

9,504

28,651

12,904

7,180

4,991

12,898

7,411

4,628

4,917

4,047

1,867

2,929

375

1,177

0

0

0

Accrued expenses, other current liabilities, operating lease liabilities, and other liabilities

3,767

8,091

5,106

9,475

3,669

1,315

-1,772

-2,873

-878

3,048

2,834

1,924

1,651

1,123

0

0

0

Deferred revenue

7,784

310

10,492

17,815

20,499

29,059

32,793

35,559

35,689

39,835

27,481

26,537

26,004

27,840

0

0

0

Other liabilities

-

-

-

-

-

-

-

0

282

-

-389

1,084

833

666

0

0

0

Net cash provided by operating activities

38,129

34,192

27,910

26,389

30,026

26,089

24,330

19,786

26,183

19,105

9,536

3,616

-4,012

-6,030

0

0

0

Cash flows from investing activities:
Purchases of property and equipment

14,901

11,453

6,959

6,773

6,840

6,728

7,295

5,965

4,577

3,669

3,156

3,198

3,414

4,307

0

0

0

Cash paid in business acquisitions, net of cash acquired

-

-

-

-

-

3,537

3,537

3,537

8,755

9,097

0

0

0

-

-

-

-

Purchases of investments

842,761

602,703

338,827

320,670

435,667

445,705

346,817

287,281

159,073

91,517

87,565

76,067

16,422

5,720

0

0

0

Sales and maturities of investments

417,684

377,974

327,987

312,778

251,093

185,112

105,013

64,259

40,338

37,862

0

0

0

-

-

-

-

Net cash provided by (used in) investing activities

-480,927

-277,131

-34,403

-31,269

-191,409

-270,858

-252,636

-232,524

-132,067

-66,421

-68,670

-62,732

5,566

10,735

0

0

0

Cash flows from financing activities:
Proceeds from exercise of stock options and taxes withheld

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

Proceeds from receipt of Section 16(b) disgorgement

0

4,918

4,918

4,918

4,918

0

0

0

0

-

-

-

-

-

-

-

-

Proceeds from initial public offering, net of underwriting commissions and discounts

-

-

-

-

-

-

-

-

-

134,757

0

0

0

-

-

-

-

Payment of initial public offering costs

-

-

-

-

-

-

-

-

-

2,396

0

0

0

-

-

-

-

Principal payments on capital lease obligations

-

-

-

-

-

-

-

-

-

-

356

328

329

274

0

0

0

Proceeds from exercise of stock options and taxes withheld

13,331

20,156

0

0

0

-

-

-

-

4,342

2,705

1,245

1,267

413

0

0

0

Minimum tax withholding paid on behalf of employees for restricted stock units

18,149

10,643

8,976

7,943

5,169

2,730

0

0

0

-

-

-

-

-

-

-

-

Payment for Contingent Consideration Liability, Financing Activities

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Other financing activity

-433

-1,305

-1,387

-467

-1,549

-577

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by financing activities

545,469

563,846

565,161

15,536

230,939

215,980

217,943

212,922

23,156

135,701

136,596

136,160

118,004

822

0

0

0

Effect of exchange rate changes on cash, cash equivalents and restricted cash

-1,567

-444

-383

-67

-440

-166

-89

-28

219

25

0

0

0

-

-

-

-

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

101,104

320,463

558,285

10,589

69,116

-28,955

-10,452

156

-82,509

88,410

77,470

77,041

119,533

5,527

0

0

0

Supplemental disclosure of cash flow information:
Cash paid for interest

3,747

930

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for income taxes

2,159

1,630

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid for amounts included in the measurement of operating lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental disclosure of noncash investing and financing activities:
Property and equipment recorded in accounts payable and accrued expenses and other current liabilities

4,600

2,002

1,203

1,100

929

720

588

826

4

0

-44

-614

250

38

0

0

0

Right-of-use assets obtained in exchange for new operating lease liabilities

26,108

13,312

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Consideration for business acquisition included in accrued expenses and other current liabilities and other liabilities

-

-

-

-

-

1,200

1,200

1,200

1,200

1,660

0

0

0

-

-

-

-

Deferred initial public offering costs recorded in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Contingent consideration settled through issuance of common stock

0

750

750

750

750

656

0

0

0

-

-

-

-

-

-

-

-

Accretion of Series A redeemable convertible preferred stock

-

-

-

-

-

-

-

-

-

1,983

3,959

5,692

7,147

6,442

0

0

0

Property and equipment funded by capital lease borrowing

-

-

-

-

-

-

-

-

-

-

-

-

-

987

0

0

0