Amber road, inc. (AMBR)
CashFlow / Quarterly
Mar'19Dec'18Sep'18Jun'18Mar'18Dec'17Sep'17Jun'17Mar'17Dec'16Sep'16Jun'16Mar'16Dec'15Sep'15Jun'15Mar'15Dec'14Sep'14Jun'14Mar'14Dec'13Sep'13Jun'13Mar'13
Cash flows from operating activities:
Net loss

-3,323

-2,622

-4,608

-957

-5,413

-1,809

-2,237

-4,517

-4,413

-4,508

-3,791

-4,740

-5,686

-6,647

-6,262

-8,218

-6,950

-1,340

-2,238

-2,185

-21,939

-511

-3,491

-5,357

-5,037

Adjustments to reconcile net loss to net cash provided by (used in) operating activities:
Depreciation and amortization

1,221

1,218

1,214

1,262

1,284

1,371

1,007

1,454

1,553

1,526

1,729

1,650

1,683

2,498

1,818

1,701

1,556

1,279

1,271

1,215

1,129

1,252

910

832

796

Bad debt expense

8

132

-104

165

2

262

-172

282

195

-13

349

-0

174

1

8

68

1

26

15

16

-10

-1

17

15

15

Stock-based compensation

1,982

2,536

5,453

33

4,252

1,798

1,824

1,228

1,225

1,260

1,454

1,403

1,348

806

2,088

1,848

1,717

1,418

989

165

173

185

166

92

76

Loss on asset impairment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

30

Restricted stock non-cash compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

18,683

621

1,993

3,182

3,529

Compensation related to puttable common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

13

13

13

13

13

13

13

13

13

4

0

0

Acquisition related deferred compensation

-

-

-

-

-

-

-

-

-

567

283

283

283

283

662

0

0

-

-

-

-

-

-

-

-

Changes in fair value of contingent consideration liability

-

-

-

-

-

0

0

0

18

20

10

20

-20

-291

-772

0

-287

-166

25

15

81

103

2

0

0

Accretion of debt discount

8

8

8

8

8

8

8

8

11

15

15

15

15

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of warrant liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

1,244

124

416

562

496

Non-cash interest expense related to debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

188

58

-

-

0

0

-

-

-

-

Amortization of debt financing costs and accretion of debt discount

-

-

-

-

-

-

-

-

-

-

-

-

-

-

15

13

9

3

39

0

0

-

-

-

-

Changes in operating assets and liabilities:
Accounts receivable and unbilled receivables

-2,844

4,597

-3,355

2,692

-3,357

1,623

1,562

-1,614

-3,187

6,566

-314

-1,428

-3,608

5,039

318

-1,360

-2,337

3,061

-81

5,335

-3,517

1,067

-500

3,432

-2,994

Unbilled receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

360

-

62

-318

372

-118

76

-80

26

Prepaid expenses and other assets

-638

19

196

-203

869

-489

-86

-567

-169

-637

1,399

459

215

642

-101

-167

490

342

-334

548

244

546

293

2,413

20

Accounts payable

507

1,058

-614

-36

-600

801

-452

462

-978

1,703

-303

-187

71

555

-622

147

-397

636

-279

-896

357

-22

396

664

-606

Accrued expenses

-1,952

1,334

1,527

-117

-689

-1,815

694

-929

-938

1,558

1,890

107

671

2,232

161

-490

-2,208

1,405

-15

-1,402

444

2,291

188

1,714

-962

Other liabilities

255

2

-55

-113

381

54

-80

-92

-91

-58

-59

-2,186

220

-52

-700

96

375

-35

-58

-0

-7

-49

24

-35

-3

Deferred revenue

1,053

-415

-1,842

1,591

-285

2,543

-779

404

852

3,730

-1,168

243

897

3,786

86

-1,023

1,602

846

-294

-138

-3,246

1,396

-485

862

-1,268

Net cash provided by (used in) operating activities

3,246

-1,364

4,139

-652

1,427

2,082

-1,663

-1,882

793

-126

-672

-2,420

3,054

-2,475

-3,965

-3,765

-3,021

798

-177

-8,748

-175

3,903

294

-3,221

12

Cash flows from investing activities:
Capital expenditures

106

30

110

62

15

88

114

44

11

11

128

5

87

454

304

516

110

82

184

31

424

-487

240

329

244

Addition of capitalized software development costs

725

682

963

718

850

241

377

365

473

426

456

682

721

400

585

685

254

441

476

487

565

755

338

786

528

Addition of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-275

550

0

0

0

0

-

-

-

-

Acquisition, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-0

123

0

25,593

0

0

0

0

-

-

-

-

Cash paid for deposits

-25

-72

118

-165

0

14

-36

-151

-18

24

-4

-139

0

15

-32

-4

-0

109

-33

120

30

-500

1

-25

-10

Decrease (increase) in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

113

0

112

0

0

-

-

-

-

-

-

-

-

Net cash used in investing activities

-857

-785

-955

-946

-865

-315

-528

-561

-502

-526

-589

-1,102

-694

-838

-932

-931

-26,509

-413

-694

-342

-960

-768

-2,493

-1,141

-783

Cash flows from financing activities:
Proceeds from revolving line of credit

1,500

5,500

4,700

6,650

7,000

6,000

6,100

6,250

6,000

6,000

5,500

5,500

3,250

5,000

0

0

0

-

-

-

-

-

-

-

-

Payments on revolving line of credit

1,500

5,500

4,700

6,650

7,000

6,100

6,250

6,000

6,000

5,500

5,500

3,250

5,000

0

0

0

0

0

0

0

6,978

0

500

0

0

Proceeds from term loan

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

20,000

0

0

0

0

-

-

-

-

Payments on term loan

187

187

187

187

187

187

187

93

187

93

93

93

93

5,093

250

0

0

-

-

-

-

-

-

-

-

Debt financing costs

-

-

-

-

-

0

0

0

35

0

0

0

0

2

0

2

183

0

35

0

-35

-

-

-

-

Amortization of Financing Costs, Financing Activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-31

0

0

Repayments on capital lease obligations

431

397

380

362

357

319

391

478

367

373

242

408

401

375

381

367

369

385

303

309

247

835

73

57

56

Proceeds from the exercise of stock options

321

380

161

249

81

138

76

73

24

419

1,069

262

135

0

140

172

986

744

483

0

339

0

3

1

25

Proceeds from the exercise of common stock warrant

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

40

0

0

0

0

Payment of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7

483

3,774

271

207

0

0

Proceeds from initial public offering, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-4,266

0

0

57,824

0

0

0

0

Net cash used in financing activities

-297

-274

-406

-299

-464

-467

-651

-1,556

-566

452

732

2,010

-2,109

-493

-490

-197

20,432

359

137

-793

47,239

172

2,341

2,972

-31

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

-7

-200

-144

95

-145

-220

42

68

-117

-144

64

17

-504

45

-61

-133

-46

-74

0

-20

-38

-46

-237

-111

5

Net decrease in cash, cash equivalents and restricted cash

2,083

-2,625

2,631

-1,803

-48

1,078

-2,800

-3,931

-393

-345

-464

-1,494

-254

-3,763

-5,450

-5,028

-9,144

669

-733

-9,905

46,064

3,261

-94

-1,502

-796

Supplemental disclosures of cash flow information:
Accretion of Series E Preferred Stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

2,289

1,185

1,185

1,185

1,185

Accretion of Series A, B, C, D and E issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

91

25

26

26

26

Accretion of puttable common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

35

-8

8

0

0

Cash paid for interest

348

298

316

330

290

221

263

226

226

225

173

222

167

239

490

66

61

57

48

55

112

144

-4

-0

5

Non-cash property and equipment acquired under finance lease

2,483

27

414

385

318

298

254

65

1,319

588

246

0

0

608

-11

330

618

331

274

969

44

2,239

1,292

0

0

Noncash or Part Noncash Acquisition, Property Acquired Under Operating Lease Right-Of-Use Assets

7,781

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash property and equipment purchases in accounts payable

22

129

-7

14

0

-46

34

-6

17

22

-16

-10

27

75

-21

278

35

233

-30

-5

38

78

6

-10

37

Non-cash deferred offering costs in accounts payable and accrued expenses

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

Non-cash conversion of Series A, B, C, D and E preferred stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

77,139

0

0

0

0

Non-cash acquisition contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

0

1,609

-1,538

2,251

0

0

0

0

-

-

-

-