Quinstreet, inc. (QNST)
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'10
Cash Flows from Operating Activities
Net income

20,016

7,038

58,315

62,480

64,485

70,661

19,782

15,930

9,141

2,603

-7,194

-12,208

-14,173

-18,017

-16,625

-19,420

-21,115

-21,066

-20,085

-20,008

-113,743

-113,200

-151,752

-146,404

-49,223

-48,712

-68,174

-67,372

-65,589

-60,554

7,370

13,001

19,246

22,712

25,207

27,214

0

0

0

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

11,112

10,622

10,139

8,975

8,170

7,715

7,154

7,767

8,371

9,125

10,265

11,377

12,633

13,694

14,516

15,087

15,526

16,175

17,389

18,867

20,920

23,161

24,843

26,097

26,614

27,211

30,722

32,325

34,159

34,983

32,321

31,150

29,677

29,277

28,483

27,272

0

0

0

Write-off of bank loan upfront fees

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

809

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for sales returns and doubtful accounts receivable

255

9,068

9,227

9,343

9,411

709

631

525

563

321

335

291

55

366

957

789

927

306

-113

142

378

609

353

-104

-630

-556

-740

-781

-2,048

-352

-268

84

1,665

401

471

-35

0

0

0

Stock-based compensation

15,405

16,486

15,665

14,128

12,505

12,172

10,856

10,182

9,689

9,149

8,728

8,898

9,455

10,194

10,786

10,968

10,812

10,577

10,369

9,855

9,700

9,569

9,669

10,429

11,314

11,878

12,281

12,016

11,718

11,900

12,392

12,996

13,188

13,499

13,594

13,950

0

0

0

Non-cash lease expense

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

3,260

-2,291

-51,903

-52,019

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gains on sale of domain names

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

160

289

946

3,331

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

285

498

543

490

415

228

156

111

150

186

197

860

2,243

7,206

7,458

0

0

0

Other adjustments, net

624

509

967

610

238

-466

-1,253

-1,108

-871

-241

40

-116

0

0

0

-

-

-

-

247

306

-143

50

296

331

1,292

510

146

2,039

865

766

598

-1,367

-889

-327

-99

0

0

0

Changes in assets and liabilities:
Accounts receivable

-872

10,110

10,216

8,321

5,129

12,404

17,204

24,958

26,522

7,920

4,927

-2,868

-6,338

940

-600

1,767

5,466

-265

4,640

4,403

3,326

6,652

1,140

3,484

-20,730

-6,680

-5,332

-15,309

9,946

-9,796

-12,427

1,983

-3,715

-4,174

-7,806

-3,885

0

0

0

Prepaid expenses and other assets

2,568

137

500

545

-1,212

-2,174

-1,940

-1,910

-728

-226

-692

-830

-8,489

-8,953

1,626

-4,448

3,415

3,757

-6,631

181

3,585

6,110

8,225

6,254

-1,968

-7,446

-4,012

-3,344

4,385

8,900

5,781

2,617

-2,792

-9,320

-9,954

-4,947

0

0

0

Deferred taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

496

-1,776

-1,776

-1,776

-1,786

-3,139

-4,684

-45,055

-45,075

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other assets, noncurrent

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

0

0

-

49

53

-129

-120

0

0

0

Accounts payable

5,306

-214

5,875

4,534

4,629

9,319

6,732

7,350

9,526

4,936

6,993

5,394

-1,517

3,067

1,271

-505

2,023

-3,879

297

2,030

1,799

3,699

-984

539

2,266

-483

328

-4,582

-7,298

-5,223

-7,617

-376

750

1,672

3,902

6,375

0

0

0

Accrued liabilities

-1,823

1,510

-2,219

-3,368

-5,272

-2,713

4,685

8,489

12,768

6,890

2,513

-1,155

-3,676

-11

-1,502

608

1,355

60

1,707

494

3,816

2,251

2,257

-161

-1,639

-1,593

-760

-1,382

-2,153

-2,768

-6,024

-7,405

-7,677

-5,081

-2,028

2,552

0

0

0

Deferred revenue

118

276

-42

46

293

162

47

-411

-485

-519

-203

-74

137

10

-109

-8

-453

-114

-100

33

125

114

-192

-702

-706

-765

-855

-725

-651

-347

-212

-242

-160

110

634

1,043

0

0

0

Other liabilities, noncurrent

418

1,008

1,513

1,468

1,427

1,904

467

258

-296

-1,466

-550

-530

-506

-485

-466

-445

-213

-159

-139

-202

-350

-441

-557

-558

-563

-463

-253

251

-2,159

-1,978

-1,593

-1,416

1,569

1,973

1,983

1,459

0

0

0

Net cash provided by operating activities

43,273

34,565

37,279

37,965

40,993

40,239

34,882

26,979

25,573

26,065

19,653

18,536

8,502

8,068

-1,021

1,015

2,160

570

12,877

6,133

10,178

8,636

10,994

18,377

32,828

39,367

44,176

50,665

34,796

43,069

46,069

46,375

61,971

73,398

80,004

78,171

0

0

0

Cash Flows from Investing Activities
Capital expenditures

2,100

2,268

2,182

1,972

1,407

1,063

820

610

578

755

883

1,160

1,148

1,320

1,771

1,859

2,406

2,204

1,694

3,346

3,405

3,561

6,406

5,455

4,894

4,699

2,240

1,341

1,377

1,705

1,806

2,268

2,950

3,800

5,214

5,363

0

0

0

Business acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

60,075

54,754

36,413

87,921

91,838

0

0

0

Other intangibles

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,816

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Internal software development costs

2,284

2,256

2,247

2,336

2,340

2,279

2,199

2,146

1,984

2,064

2,033

2,185

2,527

2,733

2,901

3,482

3,603

3,340

3,191

2,342

2,021

2,223

2,264

2,494

2,599

2,458

2,517

2,511

2,446

2,554

2,471

2,379

2,265

2,043

2,016

1,841

0

0

0

Purchases of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,600

30,980

44,134

48,397

50,770

47,455

45,835

49,146

51,030

49,022

52,609

52,116

46,864

0

0

0

-

-

-

-

Proceeds from maturities of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

26,849

40,797

55,710

47,312

49,768

46,940

46,148

49,980

49,911

49,630

52,075

51,718

45,002

0

0

0

-

-

-

-

Proceeds from sale of domain names

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

160

304

711

3,371

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other investing activities

125

89

89

-56

-399

-1,007

-1,206

-1,061

-821

-152

116

26

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-30

0

0

0

-

-

0

0

Net cash provided by (used in) investing activities

-5,985

-15,194

-37,255

-36,989

-25,504

-24,491

-15,967

-15,849

-15,895

-16,821

-3,032

-3,371

-3,648

-3,959

-4,483

-5,202

-8,951

19,650

32,256

33,270

38,085

10,747

-8,740

-10,731

-11,696

-10,409

-6,516

-7,469

-11,150

-36,165

-34,544

-66,554

-73,866

-63,676

-135,015

-134,763

0

0

0

Cash Flows from Financing Activities
Net proceeds from issuance of common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

106

0

0

0

Proceeds from exercise of common stock options

5,905

5,736

7,472

7,789

13,577

15,336

13,172

11,028

0

0

0

-

-

-

-

-

-

-

-

1,300

2,370

2,702

3,636

3,329

2,400

2,115

1,214

457

1,488

2,780

3,117

4,698

7,656

9,283

16,432

16,710

0

0

0

Principal payments on bank debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

6,250

5,000

5,062

5,125

5,188

4,813

4,376

3,963

0

0

0

Payment of bank loan upfront fees

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

272

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on acquisition-related notes payable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

484

798

1,160

2,874

2,953

4,879

4,893

5,083

8,128

7,024

7,067

5,721

3,366

5,917

6,112

9,300

11,452

0

0

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

285

498

543

490

415

228

156

111

150

186

197

860

2,243

7,206

7,458

0

0

0

Payment of withholding taxes related to release of restricted stock, net of share settlement

6,521

6,659

6,392

9,891

10,155

12,070

11,618

6,487

5,368

2,317

1,397

1,018

1,108

1,270

1,506

2,482

2,392

2,285

2,041

1,163

1,108

1,256

1,364

1,958

0

0

0

-

-

303

334

417

0

0

0

-

-

-

-

Repurchases of common stock

-

-

-

-

-

-

-

647

1,368

2,091

2,612

2,487

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

6,157

0

0

0

-

-

-

-

-

-

-

-

Principal payments on term loan facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

77,500

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-7,272

-5,741

-872

-4,054

3,422

3,266

1,032

3,894

-3,571

-3,510

-19,009

-18,505

-17,915

-17,354

-1,521

-2,497

-52,406

-57,350

-60,882

-63,119

-15,909

-14,701

-14,126

-13,539

-15,052

-13,987

-13,773

-21,616

-25,649

-43,989

-53,405

-43,447

-35,014

-11,078

34,102

33,072

0

0

0

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

119

48

-28

26

130

152

205

105

4

-58

-45

-33

3

-9

-69

-74

-101

-60

-12

7

3

11

-2

-47

-49

-47

-40

6

-146

-149

-141

-133

86

92

84

40

0

0

0

Net increase in cash, cash equivalents and restricted cash

30,135

13,678

-876

-3,052

19,041

19,166

20,152

15,129

6,111

5,676

-2,433

-3,373

-13,058

-13,254

-7,094

-6,758

-59,298

-37,190

-15,761

-23,709

32,357

4,693

-11,874

-5,940

6,031

14,924

23,847

21,586

-2,149

-37,234

-42,021

-63,759

-46,823

-1,264

-20,825

-23,480

0

0

0

Supplemental Disclosure of Cash Flow Information
Cash paid for interest

-

-

-

-

-

-

-

-

-

-

-

295

446

550

625

643

1,129

1,815

2,163

3,052

3,254

3,377

3,839

3,762

3,941

4,063

4,598

4,333

4,320

4,188

3,441

3,786

4,073

4,043

4,170

4,128

0

0

0

Cash paid for income taxes

337

264

267

334

376

256

254

245

140

440

442

390

502

648

827

863

194

-140

31

237

1,037

1,008

1,719

1,569

1,509

1,608

2,111

2,163

7,037

10,556

13,790

13,721

12,510

8,852

11,235

16,885

0

0

0

Supplemental Disclosure of Non-cash Investing and Financing Activities
Purchases of property and equipment included in accrued liabilities

397

328

305

230

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Notes payable issued in connection with business acquisitions

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,096

3,355

3,522

602

3,311

0

0

0

Retirement of treasury stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

6,157

0

0

0

-

-

-

-

-

-

-

-