Amber road, inc. (AMBR)
CashFlow / TTM
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

-11,511

-13,602

-12,788

-10,418

-13,978

-12,977

-15,677

-17,230

-17,453

-18,726

-20,864

-23,336

-26,814

-28,078

-22,772

-18,747

-12,714

-27,703

-26,874

-28,127

-31,300

-14,397

0

0

0

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

4,916

4,979

5,133

4,925

5,117

5,386

5,542

6,264

6,460

6,590

7,562

7,651

7,701

7,575

6,357

5,810

5,324

4,896

4,869

4,508

4,125

3,791

0

0

0

Bad debt expense

201

195

325

257

374

568

291

814

531

509

525

183

253

80

104

111

58

47

19

21

20

46

0

0

0

Stock-based compensation

10,005

12,275

11,537

7,908

9,104

6,077

5,539

5,169

5,345

5,467

5,013

5,646

6,091

6,460

7,072

5,973

4,290

2,746

1,514

691

618

521

0

0

0

Loss on asset impairment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Restricted stock non-cash compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

18,683

19,305

21,298

24,481

9,327

0

0

0

Compensation related to puttable common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

54

54

54

54

54

54

45

31

18

0

0

0

Acquisition related deferred compensation

-

-

-

-

-

-

-

-

-

1,419

1,135

1,514

1,230

946

0

0

0

-

-

-

-

-

-

-

-

Changes in fair value of contingent consideration liability

-

-

-

-

-

18

38

48

68

30

-280

-1,062

-1,083

-1,350

-1,226

-428

-412

-43

226

203

187

106

0

0

0

Accretion of debt discount

35

35

35

35

35

37

44

51

58

62

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of warrant liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,244

1,368

1,785

2,348

1,600

0

0

0

Non-cash interest expense related to debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

0

0

-

-

-

-

Amortization of debt financing costs and accretion of debt discount

-

-

-

-

-

-

-

-

-

-

-

-

-

-

42

66

52

43

0

0

0

-

-

-

-

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

1,090

577

-2,395

2,522

-1,785

-1,615

3,326

1,448

1,634

1,213

-313

320

388

1,658

-318

-718

5,977

4,798

2,803

2,385

481

1,004

0

0

0

Unbilled receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-2

11

249

-96

0

0

0

Prepaid expenses and other assets

-626

881

373

90

-274

-1,313

-1,461

24

1,052

1,437

2,717

1,216

589

863

564

331

1,046

801

1,005

1,633

3,498

3,274

0

0

0

Accounts payable

914

-193

-450

-288

210

-166

735

884

234

1,284

137

-181

152

-316

-235

107

-936

-182

-841

-165

1,395

431

0

0

0

Accrued expenses

792

2,055

-1,094

-1,928

-2,740

-2,988

385

1,581

2,618

4,228

4,902

3,173

2,575

-304

-1,131

-1,308

-2,220

432

1,317

1,521

4,638

3,232

0

0

0

Other liabilities

89

215

267

242

263

-209

-322

-302

-2,396

-2,084

-2,078

-2,719

-436

-281

-264

377

280

-102

-115

-32

-67

-64

0

0

0

Deferred revenue

387

-952

2,007

3,070

1,882

3,021

4,207

3,818

3,657

3,702

3,758

5,014

3,747

4,451

1,511

1,130

2,015

-2,833

-2,282

-2,472

-1,472

504

0

0

0

Net cash provided by (used in) operating activities

5,367

3,548

6,995

1,192

-36

-669

-2,878

-1,888

-2,426

-165

-2,514

-5,807

-7,153

-13,229

-9,954

-6,166

-11,149

-8,303

-5,197

-4,726

800

989

0

0

0

Cash flows from investing activities:
Capital expenditures

310

219

277

280

262

257

181

195

155

231

675

850

1,361

1,385

1,012

893

408

723

153

209

506

327

0

0

0

Addition of capitalized software development costs

3,090

3,214

2,773

2,188

1,835

1,458

1,643

1,722

2,039

2,286

2,260

2,389

2,392

1,926

1,967

1,858

1,660

1,970

2,285

2,147

2,446

2,409

0

0

0

Addition of intangible assets

-

-

-

-

-

-

-

-

-

-

-

-

-

275

275

275

550

0

0

0

0

-

-

-

-

Acquisition, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

25,717

25,717

25,593

25,593

0

0

0

0

-

-

-

-

Cash paid for deposits

-145

-119

-32

-186

-172

-190

-180

-149

-137

-118

-127

-155

-20

-21

71

70

195

226

-383

-349

-494

-534

0

0

0

Decrease (increase) in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

225

112

0

0

0

-

-

-

-

-

-

-

-

Net cash used in investing activities

-3,546

-3,553

-3,083

-2,655

-2,269

-1,907

-2,118

-2,179

-2,720

-2,912

-3,225

-3,568

-3,398

-29,212

-28,787

-28,549

-27,960

-2,411

-2,765

-4,564

-5,363

-5,186

0

0

0

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

18,350

23,850

24,350

25,750

25,350

24,350

24,350

23,750

23,000

20,250

19,250

13,750

8,250

5,000

0

0

0

-

-

-

-

-

-

-

-

Payments on revolving line of credit

18,350

23,850

24,450

26,000

25,350

24,350

23,750

23,000

20,250

19,250

13,750

8,250

5,000

0

0

0

0

6,978

6,978

7,478

7,478

500

0

0

0

Proceeds from term loan

-

-

-

-

-

-

-

-

-

-

-

-

-

20,000

20,000

20,000

20,000

0

0

0

0

-

-

-

-

Payments on term loan

750

750

750

750

656

656

562

468

468

375

5,375

5,531

5,437

5,343

0

0

0

-

-

-

-

-

-

-

-

Debt financing costs

-

-

-

-

-

35

35

35

35

0

2

2

4

188

186

222

219

0

0

0

0

-

-

-

-

Amortization of Financing Costs, Financing Activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Repayments on capital lease obligations

1,571

1,497

1,419

1,430

1,546

1,556

1,610

1,462

1,392

1,425

1,427

1,565

1,525

1,493

1,503

1,425

1,368

1,246

1,695

1,465

1,213

1,022

0

0

0

Proceeds from the exercise of stock options

1,112

872

630

546

370

313

594

1,587

1,776

1,887

1,467

539

449

1,299

2,044

2,387

2,215

1,568

823

342

343

29

0

0

0

Proceeds from the exercise of common stock warrant

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

40

40

40

40

0

0

0

0

Payment of offering costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,538

4,737

4,253

478

0

0

0

Proceeds from initial public offering, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

53,558

57,824

57,824

57,824

0

0

0

0

Net cash used in financing activities

-1,278

-1,445

-1,639

-1,883

-3,141

-3,242

-2,322

-938

2,629

1,086

140

-1,082

-3,290

19,250

20,103

20,732

20,135

46,942

46,755

48,960

52,726

5,455

0

0

0

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

-256

-394

-414

-227

-255

-227

-151

-129

-180

-567

-378

-503

-655

-196

-316

-254

-140

-133

-104

-343

-434

-390

0

0

0

Net decrease in cash, cash equivalents and restricted cash

286

-1,845

1,858

-3,574

-5,702

-6,047

-7,471

-5,135

-2,698

-2,559

-5,977

-10,963

-14,497

-23,387

-18,954

-14,237

-19,114

36,094

38,687

39,325

47,728

867

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,289

3,475

4,661

5,847

4,743

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

91

116

143

169

105

0

0

0

Accretion of puttable common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

35

26

35

35

0

0

0

0

Cash paid for interest

1,293

1,236

1,159

1,106

1,002

938

942

853

849

790

804

1,120

964

858

675

234

223

275

362

309

252

145

0

0

0

Non-cash property and equipment acquired under finance lease

3,310

1,145

1,416

1,256

935

1,936

2,226

2,218

2,153

834

854

596

926

1,545

1,268

1,554

2,193

1,618

3,527

4,545

3,576

3,532

0

0

0

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

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash property and equipment purchases in accounts payable

158

136

-39

2

-17

0

68

17

12

22

75

70

360

368

526

517

233

236

81

118

113

112

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

77,139

77,139

77,139

77,139

0

0

0

0

Non-cash acquisition contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

2,322

2,322

713

2,251

0

0

0

0

-

-

-

-