Capella education co (CPLA)
CashFlow / TTM
Jun'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'10Jun'10Mar'10
Operating activities
Net Income

27,121

26,086

23,505

42,201

45,997

44,937

42,969

43,191

38,813

39,449

40,188

40,865

40,450

39,163

37,943

35,634

33,887

35,265

35,203

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Income (loss) from discontinued operations, net of tax

0

0

95

54

3,017

1,638

565

-439

-4,032

-3,520

-3,442

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income from continuing operations

27,121

26,086

23,410

42,147

42,980

43,299

42,404

43,630

42,845

42,969

43,630

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net income

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

36,291

39,520

44,183

48,150

51,543

57,630

61,322

60,517

61,179

0

0

0

Adjustments to reconcile net income to net cash provided by operating activities:
Provision for bad debts

13,371

12,914

12,726

12,244

11,074

11,153

10,663

11,326

12,884

13,062

14,275

14,238

14,140

14,465

14,835

15,139

14,972

14,920

15,132

16,538

17,327

17,522

17,310

15,818

14,003

12,328

10,565

9,174

8,772

8,998

8,744

0

0

0

Depreciation and amortization

19,244

19,437

19,718

20,528

21,106

21,260

21,343

21,221

21,416

21,812

21,917

21,069

21,432

21,784

22,638

24,176

24,337

24,915

25,877

27,251

28,448

29,164

29,255

28,517

27,518

26,059

24,165

22,379

20,915

19,841

18,512

0

0

0

Amortization of investment discount/premium, net

-1,092

-1,231

-1,410

-1,654

-1,871

-2,044

-2,129

-2,199

-2,272

-2,289

-2,293

-2,226

-2,160

-2,075

-1,843

-1,547

-1,277

-980

-768

-642

-525

-537

-692

-4,302

-3,687

-2,927

-2,049

923

-101

-1,147

-2,180

0

0

0

Impairment of property and equipment

916

73

440

478

882

809

442

0

0

0

-

-

-

-

277

277

277

312

229

229

423

271

1,150

1,150

991

991

35

0

0

0

-

-

-

0

Loss on disposal of property and equipment

-260

-412

-414

-401

-263

-148

-164

-144

-181

-62

-64

-55

-26

-26

-69

-83

-83

-116

-52

-205

-197

-131

-81

146

140

115

30

0

0

0

-

-

-

-

Share-based compensation

7,616

7,001

6,524

6,172

5,469

4,883

6,422

6,563

7,132

7,670

6,594

6,667

6,265

5,419

5,129

5,266

5,482

5,195

5,330

5,763

5,553

5,347

4,880

4,800

4,906

5,114

4,883

4,451

4,242

4,146

3,698

0

0

0

Excess tax benefits from share-based compensation

-

-

-

-

-

-

1,136

395

387

395

439

518

555

841

547

627

636

380

310

139

98

39

69

382

373

401

248

37

1,291

2,086

4,251

0

0

0

Deferred income taxes

-1,352

-865

-909

3,330

-1,485

-3,126

-4,280

-5,869

-1,538

-1,945

-1,641

-574

-204

203

-323

-1,758

-1,994

-1,505

-1,463

-2,249

-1,996

-3,758

-3,584

-3,934

-3,053

2,289

2,516

6,248

5,181

1,058

1,354

0

0

0

Changes in operating assets and liabilities
Accounts receivable

16,923

16,176

14,751

15,171

13,049

13,345

13,568

13,546

16,343

16,358

15,150

16,432

16,133

15,373

16,163

15,895

14,647

13,673

16,141

15,161

15,869

17,056

14,979

34,579

21,115

16,726

13,789

-10,545

3,722

8,307

9,733

0

0

0

Prepaid expenses and other current assets

905

-1,778

963

-2,129

-4,346

1,687

470

1,571

6,840

6,197

7,162

15,826

13,911

11,058

9,302

-2,123

-732

431

-1,787

749

-3,460

-971

-2,586

6,691

4,835

-312

3,424

-7,011

-149

1,628

1,635

0

0

0

Accounts payable and accrued liabilities

-842

-1,108

-6,214

-4,831

-5,994

811

9,063

-2,092

-4,009

-1,194

-2,474

4,270

4,646

1,388

-3,441

-2,515

-1,671

786

4,578

6,277

3,002

1,549

-6,296

-2,753

-1,296

-1,384

-612

-1,093

-3,658

-9,112

4,787

0

0

0

Income taxes payable

2,527

2,507

6,822

-2,601

-533

-304

-2,823

4,806

-11

-1,105

-2,980

-864

368

1,173

3,013

859

265

-903

-1,826

-1,678

-3,026

-7,087

-4,306

-2,980

-735

-3,636

1,559

4,398

4,558

9,808

5,030

0

0

0

Deferred rent

-1,068

-1,199

-1,328

-1,426

11,556

11,688

11,819

11,968

-681

-624

-566

-499

-633

-810

-781

-757

-721

-489

-929

-794

-683

-530

-65

-81

-221

-333

750

878

1,283

1,348

514

0

0

0

Deferred revenue

904

902

1,451

1,279

1,712

3,555

3,902

6,723

5,585

4,491

1,540

1,399

1,269

-378

438

988

905

1,582

1,062

-484

697

2,251

1,882

3,574

2,274

1,434

342

-2,439

-3,006

-3,072

-1,991

0

0

0

Net cash provided by operating activities - continuing operations

66,916

67,948

63,705

65,575

79,410

80,376

86,074

86,407

63,402

65,433

60,797

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) operating activities - discontinued operations

0

0

95

52

-2,303

-2,029

-2,874

-2,874

-779

-1,804

400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

66,916

67,948

63,800

65,627

77,107

78,347

83,200

83,533

62,623

63,629

61,197

69,382

72,256

69,267

65,188

63,634

61,642

66,690

69,349

69,331

70,755

63,112

64,828

73,279

70,922

76,675

80,304

91,308

89,924

83,145

88,407

0

0

0

Investing activities
Capital expenditures

19,056

20,021

22,097

23,968

23,047

21,381

20,908

18,876

18,255

18,622

20,417

20,749

21,618

21,562

20,293

19,715

19,232

18,963

18,728

20,115

21,891

23,298

23,278

27,531

28,322

30,268

29,587

26,257

24,404

25,758

25,481

0

0

0

Proceeds from the sale of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

303

303

303

303

0

0

0

0

-

-

-

-

Investment in partnership interests

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

77,926

70,922

73,680

62,843

45,935

35,518

29,216

29,204

27,131

34,685

32,640

40,597

40,461

35,949

64,308

48,957

42,093

50,665

22,426

35,660

36,313

20,469

13,887

653

0

2,000

3,500

25,827

37,449

43,118

60,211

0

0

0

Maturities of marketable securities

66,080

67,480

66,220

54,330

53,800

31,410

31,430

31,630

27,315

33,755

30,175

35,705

34,925

29,595

25,415

14,140

7,725

4,300

7,885

16,530

30,645

42,865

55,545

67,407

66,017

62,747

51,442

34,513

28,438

18,738

10,978

0

0

0

Net cash used in investing activities - continuing operations

-33,119

-25,384

-31,344

-33,349

-15,867

-59,187

-54,346

-52,565

-54,269

-22,732

-23,816

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities - discontinued operations

0

0

3,243

4,483

18,349

18,306

15,032

13,802

-94

-26

-224

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-33,119

-25,384

-28,101

-28,866

2,482

-40,881

-39,314

-38,763

-54,363

-22,758

-24,040

-26,637

-28,096

-28,826

-60,930

-55,985

-54,663

-66,391

-33,269

-39,245

-27,559

-2,478

17,107

37,950

23,782

18,142

5,715

-30,211

-33,415

-50,138

-74,714

0

0

0

Financing activities
Excess tax benefits from share-based compensation

-

-

-

-

-

-

1,136

395

387

395

439

518

555

841

547

627

636

380

310

139

98

39

69

242

197

163

248

177

1,467

2,324

4,251

0

0

0

Net proceeds (payments) for exercise of stock options

-564

181

1,042

4,297

5,085

5,477

5,363

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Taxes paid for restricted stock units

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

3,170

5,048

5,874

5,599

4,431

4,566

3,739

3,452

2,735

908

469

628

653

421

608

1,634

2,225

4,281

5,403

6,842

0

0

0

Payment of dividends

24,656

19,342

19,078

18,791

18,519

18,375

18,254

18,198

18,161

18,092

18,012

17,865

17,662

17,462

17,256

12,961

8,659

4,326

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Repurchases of common stock

-

-

-

-

-

-

25,633

30,023

30,525

29,798

26,006

21,767

17,866

17,811

17,299

18,189

16,754

12,036

8,965

17,462

28,072

38,615

51,418

64,868

76,041

89,362

103,375

90,589

87,603

67,311

49,775

0

0

0

Net cash used in financing activities

-33,933

-23,620

-22,705

-20,259

-25,103

-31,971

-38,319

-46,254

-47,368

-46,694

-43,112

-35,944

-29,925

-34,503

-34,354

-32,037

-26,156

-12,243

-5,203

-14,588

-27,066

-38,107

-50,721

-63,973

-75,423

-88,591

-101,493

-88,187

-81,855

-59,584

-38,682

0

0

0

Effect of foreign exchange rates on cash

-2

-1

2

1

-13

17

-24

-16

4

22

-21

-39

-36

-70

2

55

51

15

0

-8

-12

12

29

18

29

27

35

0

0

0

-

-

-

-

Net increase (decrease) in cash and cash equivalents

-138

18,943

12,996

16,503

54,473

5,512

5,543

-1,500

-39,104

-5,801

-5,976

6,762

14,199

5,868

-30,094

-24,333

-19,126

-11,929

30,877

15,490

16,118

22,539

31,243

47,274

19,310

6,253

-15,439

-27,078

-25,346

-26,577

-24,989

0

0

0

Supplemental disclosures of cash flow information
Income taxes paid

18,766

19,029

16,616

22,624

25,952

29,690

33,093

27,884

27,887

29,199

31,171

28,065

26,509

24,808

23,061

25,530

25,255

26,585

27,486

27,781

27,703

33,354

30,947

27,629

30,309

30,024

26,340

26,664

26,990

25,044

29,563

0

0

0

Non-cash investing and financing activities:
Purchase of equipment included in accounts payable and accrued liabilities

166

588

379

870

1,183

1,216

784

995

618

988

854

756

-611

1,024

799

834

2,556

876

775

405

241

48

472

-496

-163

577

348

0

0

0

-

-

-

-

Repurchases of common stock included in accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of equipment included in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0