Appfolio, inc. (APPF)
CashFlow / Quarterly
Mar'20Dec'19Sep'19Jun'19Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15
Cash from operating activities
Net income

1,983

4,428

4,978

23,151

3,725

2,649

5,524

7,474

4,320

2,577

3,682

2,797

660

-1,289

-1,125

-2,264

-3,603

-3,890

-4,760

-3,400

-3,618

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

6,414

6,226

5,678

5,415

5,076

3,792

3,705

3,579

3,500

3,352

3,237

3,114

2,996

2,823

2,636

2,359

2,117

1,852

1,638

1,431

1,183

Amortization of operating lease right-of-use assets

1,053

1,114

1,088

986

942

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

362

-4,423

-1,389

-21,362

-4,281

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchased investment premium, net of amortization

-

-

-

-

-

-

-

-

-

-

-82

90

14

-60

-90

50

-145

485

380

0

0

Amortization of Debt Issuance Costs

-

-

-

-

-

-

-

-

-

-

16

16

16

15

16

16

16

15

410

26

5

Loss on disposal of property, equipment, and intangibles

-

-

-

-

-

-

-

-

-

-

-5

-61

-28

-8

-1

-3

-29

-60

6

-6

-7

Stock-based compensation

959

1,878

2,192

1,687

1,552

1,918

1,764

1,337

1,318

1,792

1,588

1,619

1,097

1,457

1,289

1,092

463

384

278

212

133

Other

38

104

-28

-81

-27

-59

-19

-67

-79

-

-

-

-

-

-

-

-

-

-

-

-

Lease abandonment

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-101

31

-91

0

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

1,616

-747

83

644

2,051

-557

-703

1,020

1,148

-32

-813

418

1,303

-196

-337

402

594

-190

-286

557

665

Prepaid expenses and other current assets

2,822

-372

-796

1,622

3,577

2,171

3,343

1,000

-441

153

644

614

-402

-427

157

-634

1,281

548

737

82

526

Other assets

148

-247

125

-594

-660

-556

3,941

296

766

30

3

56

-5

-60

71

-18

110

-64

37

39

44

Accounts payable

-362

241

82

88

100

137

-362

424

415

-469

688

-300

-19

205

-538

82

-653

-606

-716

674

209

Accrued employee expenses

-5,427

4,056

-194

3,547

-2,867

4,444

-1,185

1,802

-3,842

2,397

270

2,238

-1,662

2,367

-1,050

812

94

-1,223

2,046

163

901

Accrued expenses

726

69

-1,398

-196

1,580

-116

1,964

822

611

-1,442

919

321

473

-206

603

-236

987

-99

674

-240

800

Deferred revenue

693

154

458

313

268

-342

-958

-1,955

-1,334

-428

-529

-660

1,059

1,011

526

443

705

511

187

20

455

Operating lease liabilities

784

224

-1,127

-1,024

-735

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other liabilities

522

245

616

504

-124

184

5,657

478

-252

186

-434

31

69

-357

-312

637

858

705

373

-33

-51

Net cash provided by operating activities

3,083

15,474

11,600

11,518

295

11,667

9,547

11,712

3,342

7,815

9,690

8,059

3,807

6,777

2,346

3,113

-736

-3,070

-967

-1,596

-1,211

Cash from investing activities
Purchases of available-for-sale investments

649

14,508

10,012

678

0

732

7,952

5,259

15,573

9,051

2,000

9,060

6,537

7,217

7,649

7,300

9,385

13,750

60,426

0

0

Proceeds from sales of available-for-sale investments

13,942

0

1,000

0

1,750

20,199

696

0

5

0

15

0

0

2,543

-1

3,512

6,505

4,100

0

0

0

Proceeds from maturities of available-for-sale investments

7,250

4,660

7,000

1,750

2,250

4,342

12,882

7,299

8,296

5,500

3,485

3,044

4,445

4,225

5,725

4,557

6,830

17,186

8,950

0

0

Purchases of property, equipment and intangible assets

7,992

3,999

1,690

1,365

1,030

362

1,160

317

263

534

843

445

392

682

399

1,270

1,891

1,460

724

789

721

Additions to capitalized software

6,822

5,329

6,249

4,762

4,658

3,307

3,492

2,569

2,936

2,370

2,814

2,280

2,991

2,612

3,395

2,980

2,179

2,304

2,218

1,924

1,231

Acquisition, net of cash acquired

0

0

0

0

54,004

0

14,441

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1

5

6

5

Net cash provided by (used in) investing activities

5,729

-19,146

-9,951

-5,085

-55,692

20,140

-13,467

-846

-10,471

-6,454

-2,157

-8,742

-5,475

-3,743

-5,721

-3,481

-120

3,771

-54,423

-6,758

-1,957

Cash from financing activities
Proceeds from stock option exercises

97

294

60

109

90

322

55

188

470

155

122

241

145

92

107

73

80

29

10

250

68

Proceeds from issuance of restricted stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

141

Tax withholding for net share settlement

6,458

614

790

3,436

1,315

233

400

1,593

901

188

263

138

1,207

26

85

0

0

-

-

-

-

Payment of contingent consideration

5,977

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of debt

49,437

472

528

572

597

50,045

30

31

32

30

29

30

29

30

30

28

29

253

0

0

10,000

Principal payments on debt

749

785

840

885

909

45

30

31

32

30

29

30

29

29

28

30

41

241

9,958

42

0

Payment of debt issuance costs

0

0

0

60

360

0

0

0

0

-

-

-

-

-

-

-

-

218

7

119

413

Principal payments under capital lease obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

5

9

8

7

5

7

9

6

Purchase of treasury stock

4,194

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

32,156

-633

-1,042

-3,700

-1,897

28,527

-345

-1,405

-431

-33

-141

103

-1,062

62

15

63

61

-396

-2,776

66,244

9,790

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

40,968

-4,305

607

2,733

-57,294

60,334

-4,265

9,461

-7,560

1,328

7,392

-580

-2,730

3,096

-3,360

-305

-795

305

-58,166

57,890

6,622

Noncash investing and financing activities
Purchases of property and equipment included in accounts payable and accrued expenses

4,251

1,834

1,033

135

445

463

-407

348

114

-250

48

165

58

149

-60

-528

700

923

177

-233

353

Additions of capitalized software included in accrued and accrued employee expenses

687

586

-264

474

391

527

-178

233

243

143

-154

189

196

227

-228

-95

554

-137

187

-42

282

Stock-based compensation capitalized for software development

406

523

532

451

338

336

249

267

235

211

203

207

138

123

131

126

51

54

45

36

31

Tax withholding for net share settlement included in accrued employee expenses

0

-

-

-1,190

1,258

-

-

-749

749

-

-

-

0

-

-

-

-

-

-

-

-

Purchase consideration for acquisitions included in other current liabilities

0

0

-23

0

6,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Debt issuance and other financing costs accrued, not paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-124

137

Initial public offering costs included in accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-3,105

1,921

1,396