Sps commerce, inc. (SPSC)
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'11
Cash flows from operating activities
Net income

36,414

33,712

31,691

30,811

27,431

23,872

9,953

4,068

620

351

8,187

8,520

6,904

4,963

6,037

4,798

5,097

4,639

3,361

2,929

2,917

2,704

2,144

1,576

1,225

1,051

1,123

1,027

1,165

1,222

13,999

14,002

13,467

13,703

0

0

0

Reconciliation of net income to net cash provided by operating activities
Deferred income taxes

7,411

7,581

6,224

3,934

2,616

2,798

9,310

9,803

10,337

9,616

975

-333

-1,482

-2,083

-1,133

-632

-289

-38

243

610

807

1,031

1,353

988

688

443

-80

-348

-229

-15

0

0

0

-

-

-

-

Change in earn-out liability

-429

-445

0

0

0

-

-

-

-

-

-

-

-

-1,103

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation and amortization of property and equipment

11,601

11,100

10,435

9,748

9,154

8,600

8,247

7,945

7,592

7,200

6,976

6,770

6,663

6,598

6,455

6,415

6,350

6,265

6,154

6,000

5,951

5,714

5,560

5,363

5,026

4,893

4,620

4,260

3,730

3,151

2,685

2,353

2,174

2,004

0

0

0

Amortization of intangible assets

5,347

5,315

4,904

4,505

4,272

4,093

4,200

4,400

4,484

4,574

4,645

4,711

4,792

4,738

4,353

3,988

3,623

3,307

3,319

3,135

2,984

2,856

2,761

3,123

3,158

3,158

3,158

2,681

2,224

1,767

0

0

0

-

-

-

-

Provision for credit losses

4,129

3,499

3,241

3,111

2,837

2,592

2,120

1,817

1,783

1,705

1,763

1,656

1,403

1,375

1,402

1,345

1,437

1,271

1,056

912

698

717

671

617

556

479

403

404

381

383

475

469

452

425

0

0

0

Stock-based compensation

13,740

14,690

13,848

13,967

14,271

12,510

15,873

14,954

13,961

12,728

8,852

8,517

8,396

8,023

7,627

7,225

6,807

6,379

6,161

5,844

5,556

5,396

5,074

4,866

4,618

4,203

3,833

3,463

3,067

2,755

2,524

2,296

2,068

1,768

0

0

0

Other, net

439

574

660

510

572

364

251

235

22

15

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in assets and liabilities
Accounts receivable

6,496

6,771

3,960

4,965

4,377

4,569

5,389

8,352

4,905

5,586

4,332

2,847

3,747

3,735

3,969

3,615

5,112

3,517

4,827

4,227

5,196

3,890

3,117

2,259

510

1,150

1,406

1,783

1,890

2,067

1,729

2,246

2,078

2,810

0

0

0

Deferred costs

1,283

1,441

1,902

2,999

4,350

5,564

6,438

7,221

8,098

7,813

5,079

4,706

4,663

4,085

4,313

3,489

2,925

3,023

4,218

4,456

6,217

4,590

3,690

3,179

642

2,184

2,385

2,419

2,571

2,290

2,051

2,023

1,837

1,595

0

0

0

Other current and non-current assets

390

2,768

3,472

3,172

4,037

3,333

1,423

314

-580

-393

-2,064

-1,224

1,830

1,911

2,821

2,465

1,833

2,037

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

1,102

132

666

882

0

0

0

Accounts payable

-187

-489

736

258

973

937

582

826

-20

832

340

-906

-907

-382

-165

-975

602

-1,569

-523

194

349

1,271

413

1,350

209

-59

-1,054

-294

794

446

1,352

123

-339

413

0

0

0

Accrued compensation

-140

319

833

211

-947

3,957

2,229

675

-765

1,304

601

1,017

740

2,291

1,375

2,143

556

1,295

-402

1,501

2,275

1,568

1,640

1,128

997

1,943

1,770

1,705

2,149

920

1,445

970

1,186

1,541

0

0

0

Accrued expenses

31

706

499

207

517

-135

5

1,048

-345

1,192

1,333

732

2,025

990

-231

327

-898

-461

854

620

1,457

1,365

154

-184

-67

-108

67

135

100

101

259

387

254

140

0

0

0

Deferred revenue

6,064

6,366

4,984

6,107

7,112

7,094

7,357

5,808

4,227

5,588

4,195

4,544

4,874

2,852

2,899

4,241

3,684

587

1,978

1,302

1,788

2,440

1,980

2,069

1,528

1,309

1,951

1,800

1,974

2,551

2,536

3,045

2,521

1,853

0

0

0

Deferred rent

-

-

-

-

-

2,440

242

161

563

-1,027

-117

2

-152

234

1,491

1,600

1,544

1,331

739

809

861

925

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Operating leases

864

971

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by operating activities

76,260

71,794

68,428

62,430

55,867

55,015

46,625

35,391

30,000

31,050

30,384

27,879

22,253

18,765

17,904

20,834

18,278

14,429

12,049

12,235

16,292

16,788

13,753

16,550

15,252

18,243

14,670

10,891

11,774

6,829

9,205

7,930

5,529

4,485

0

0

0

Cash flows from investing activities
Purchases of property and equipment

14,651

13,585

12,262

12,620

12,765

13,750

11,904

10,418

9,856

7,271

7,278

8,272

7,191

8,008

8,225

6,748

8,565

8,757

9,692

9,281

9,029

7,582

5,065

7,344

5,473

5,701

8,168

5,830

6,442

5,983

3,713

3,485

2,726

2,584

0

0

0

Purchases of investments

73,713

73,700

79,199

74,098

74,186

81,666

82,493

77,644

62,810

47,878

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of investments

85,122

84,472

77,449

74,949

79,949

82,224

70,000

57,029

43,029

33,029

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of business and intangible assets, net

-

-

-

-

-

27,273

381

381

381

500

470

470

590

18,032

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-14,742

-14,313

-52,404

-38,661

-33,894

-40,465

-24,778

-31,414

-30,018

-22,620

-17,018

-12,210

-13,398

-34,157

-36,942

-43,347

-49,029

-31,284

-39,796

-31,865

-21,624

-20,177

-5,065

-7,344

-5,473

-5,701

-8,168

-32,092

-32,704

-32,245

-29,951

-3,461

-13,567

-13,425

0

0

0

Repurchases of common stock

29,652

20,618

20,963

16,961

16,959

19,864

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

122

0

0

0

Net proceeds from exercise of options to purchase common stock

7,418

6,207

7,817

12,595

16,101

14,344

11,903

5,286

1,088

1,410

2,090

3,798

4,271

4,303

4,687

3,793

3,462

4,440

3,586

3,360

3,346

1,886

2,213

3,060

3,273

3,735

3,521

2,349

2,519

1,563

1,420

1,159

690

621

0

0

0

Excess tax benefit from exercise of options to purchase common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

4,070

3,867

3,357

3,057

2,336

1,380

601

536

261

0

0

0

-

-

-

-

72

0

0

0

-

-

-

-

Net proceeds from employee stock purchase plan

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for earn-out liability

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-20,566

-12,142

-11,082

-2,378

887

-3,775

-6,021

-10,640

-8,665

-2,472

5,407

8,404

9,052

10,105

10,077

8,673

7,997

8,254

6,373

5,368

5,220

3,485

51,321

52,168

52,265

52,702

4,596

60,834

60,426

59,481

58,915

1,244

654

452

0

0

0

Effect of foreign currency exchange rate changes

-183

54

37

247

308

-43

-62

304

523

1,292

576

511

-89

-374

709

-344

93

-656

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net increase in cash and cash equivalents

40,769

45,393

4,979

21,638

23,168

10,732

15,764

-6,359

-8,160

7,250

19,349

24,584

17,818

-5,661

-8,252

-14,184

-22,661

-9,257

-22,935

-15,164

-1,053

-499

60,009

61,374

62,044

65,244

11,098

39,633

39,496

34,065

38,169

5,713

-7,384

-8,488

0

0

0