Upland software, inc. (UPLD)
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'14
Operating activities
Net loss

-57,622

-45,371

-23,704

-15,647

-15,508

-10,839

-16,435

-15,691

-16,272

-18,725

-16,904

-15,788

-13,554

-13,513

-15,803

-15,737

-15,494

-13,664

-12,076

-12,197

-11,240

-20,117

0

0

0

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

38,971

34,621

30,465

27,282

24,562

21,347

18,406

16,085

13,688

11,914

10,407

9,765

9,677

9,794

9,873

9,486

8,965

8,451

8,071

7,892

7,660

7,457

0

0

0

Deferred income taxes

-10,969

-9,432

-11,329

-12,031

-2,675

268

-539

-379

-308

-262

976

819

743

529

8

-26

244

207

103

-246

-346

-295

0

0

0

Amortization of deferred costs

3,569

3,476

3,213

2,987

2,629

2,367

1,709

1,115

539

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Foreign currency re-measurement loss

-816

-58

-355

176

8

-305

-145

-69

181

382

264

-15

-236

64

20

-428

-350

-981

-779

-292

-272

0

0

0

0

Non-cash interest and other expense

1,667

1,398

1,237

1,035

967

874

792

876

707

592

547

318

338

327

260

259

413

376

382

373

537

589

0

0

0

Non-cash stock compensation expense

30,446

25,754

22,466

19,060

16,181

14,130

12,553

10,656

10,250

9,977

9,473

8,689

5,943

4,333

3,415

2,970

2,881

2,741

2,450

2,045

1,447

1,077

0

0

0

Stock-based compensationrelated party vendor

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

11,220

0

0

0

Non-cash loss on divestiture of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-746

-686

-731

-731

0

0

0

0

-

-

-

-

Changes in operating assets and liabilities, net of purchase business combinations:
Accounts receivable

4,484

-3,160

1,980

-235

-213

5,212

2,290

5,785

8,090

4,710

-82

-2,313

-2,504

361

2,638

-588

-2,323

-741

-5,597

-2,974

2,361

1,579

0

0

0

Prepaids and other

7,042

5,532

3,963

-2,162

2,255

2,798

3,224

1,836

262

-1,555

-1,492

-945

-504

-648

-1,596

-2,458

-2,417

-1,873

-5,224

-2,094

-1,485

-484

0

0

0

Accounts payable

-3,243

-73

-3,623

-3,406

-2,544

-3,399

-1,161

-79

-330

1,254

409

913

-370

-1,453

-9

-1,766

-1,325

157

-2,866

678

1,305

639

0

0

0

Accrued expenses and other liabilities

-9,329

-4,153

-15,555

-19,473

-14,812

-17,615

-4,171

279

-1,065

3,715

2,030

-307

1,709

413

-1,555

-1,456

-2,074

-2,796

-3,243

-2,682

-3,509

-924

0

0

0

Deferred revenue

14,805

3,865

7,705

6,975

5,949

7,919

921

2,039

3,657

2,807

-18

-919

899

2,200

2,148

637

-664

-570

-2,241

529

1,317

2,626

0

0

0

Net cash provided by (used in) operating activities

1,890

12,076

7,604

9,003

12,699

7,347

6,705

5,714

2,314

7,716

8,548

8,670

8,920

3,875

-2,039

-1,428

-1,233

-1,503

2,180

1,752

-3,433

1,177

0

0

0

Investing activities
Purchase of property and equipment

1,163

1,040

1,015

784

682

935

596

536

474

396

227

194

338

670

1,381

1,482

1,444

956

778

862

822

861

0

0

0

Purchase of customer relationships

0

-

-

-

0

-

-

-

-

-

-

-

55

408

827

827

1,199

791

0

0

0

-

-

-

-

Purchase business combinations, net of cash acquired

280,677

216,025

218,672

198,213

129,430

160,751

97,011

118,590

125,388

110,324

61,468

37,403

23,305

12,151

16,796

16,688

12,946

7,664

8,931

9,037

9,037

6,217

0

0

0

Net cash used in investing activities

-282,737

-217,761

-220,125

-198,997

-130,112

-161,686

-97,662

-119,181

-125,862

-110,775

-61,695

-37,597

-23,698

-13,229

-19,004

-18,997

-15,589

-9,411

-10,081

-10,271

-9,859

-7,078

0

0

0

Financing activities
Payments on finance leases

351

529

742

988

1,071

1,136

1,292

1,257

1,464

1,497

1,461

1,520

1,495

1,683

1,573

1,447

1,308

1,020

924

791

673

541

0

0

0

Proceeds from notes payable, net of issuance costs

625,714

625,666

505,328

162,361

122,902

172,397

69,230

90,605

107,986

74,538

70,750

49,313

41,932

30,992

14,920

15,246

29,070

24,083

0

0

0

-

-

-

-

Payments on notes payable

383,137

383,568

325,000

16,562

5,626

4,689

3,500

3,063

6,001

11,912

16,949

16,793

13,636

7,190

1,875

2,196

23,220

23,907

30,749

30,948

10,141

10,910

0

0

0

Taxes paid related to net share settlement of equity awards

11,923

12,659

10,866

10,349

10,236

9,400

7,401

6,877

3,982

3,387

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Issuance of Series B redeemable preferred stock, net of issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Issuance of common stock, net of issuance costs

151,496

151,551

151,498

151,960

816

807

1,398

1,106

43,713

43,797

42,545

42,445

-362

-515

117

-3

-6

-18

38,908

38,944

38,852

38,846

0

0

0

Additional consideration paid to sellers of businesses

16,435

16,693

9,648

7,102

7,336

8,056

4,294

5,317

3,754

5,361

5,956

4,933

5,664

2,079

0

0

0

-

-

-

-

-

-

-

-

Net cash used in financing activities

365,364

363,768

310,570

279,320

99,449

149,923

54,141

75,197

136,498

96,178

88,301

68,140

20,702

19,525

9,755

9,757

4,177

-1,221

33,700

34,615

33,124

32,384

0

0

0

Effect of exchange rate fluctuations on cash

149

203

-832

-2

-519

-1,172

-71

-113

138

449

342

20

-92

114

74

-197

-358

-380

-295

-103

90

-198

0

0

0

Change in cash and cash equivalents

84,666

158,286

97,217

89,324

-18,483

-5,588

-36,887

-38,383

13,088

-6,432

35,496

39,233

5,832

10,285

-11,214

-10,865

-13,003

-12,515

25,504

25,993

19,922

26,285

0

0

0

Supplemental disclosures of cash flow information:
Cash paid for interest, net of interest rate swaps

26,443

23,862

21,813

17,467

14,967

12,429

10,216

9,288

7,464

6,012

4,714

3,346

2,823

2,455

2,122

1,922

1,696

1,523

1,455

1,375

1,356

1,382

0

0

0

Cash paid for taxes

3,307

3,557

3,053

3,183

3,062

3,348

2,799

2,466

2,235

1,782

1,433

1,411

1,077

488

505

241

220

314

545

541

318

252

0

0

0

Sales commissions paid, net of amortization of deferred commissions

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash investing and financing activities:
Business combination consideration including holdbacks and earnouts

16,453

16,108

18,533

16,107

12,413

17,713

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Equipment acquired pursuant to financing lease obligations

0

44

44

44

44

0

-71

-115

-94

50

612

1,118

1,216

1,293

2,434

2,683

3,071

3,428

2,309

2,495

2,133

1,572

0

0

0

Issuance of common stock in business combination

-

-

-

-

-

-

-

-

-

-

-

-

-

8,300

9,486

7,086

7,086

1,386

0

0

0

-

-

-

-