Id systems inc (IDSY)
CashFlow / TTM
Jun'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 of assets acquired)
Net loss

-8,485

-7,016

-5,812

-3,877

-3,566

-2,974

-3,870

-5,079

-6,585

-7,558

-6,370

-5,257

-5,060

-6,705

-9,952

-13,577

-14,126

-12,689

-11,575

-10,074

-7,706

-7,708

-7,499

-5,451

-3,208

-3,567

-2,592

-1,564

-3,945

-3,922

-4,040

0

0

0

Adjustments to reconcile net loss to cash used in operating activities:
Bad debt expense

137

55

31

-11

-88

70

115

210

427

336

117

27

-127

193

326

548

836

732

853

850

637

471

482

232

436

522

432

594

325

251

275

0

0

0

Proceeds from sale of New Jersey net operating loss carryforwards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Stock-based compensation expense

2,258

2,252

2,163

2,242

2,229

2,218

2,437

2,012

1,928

1,849

1,658

1,875

1,869

1,743

1,609

1,604

1,469

1,112

1,334

1,233

1,146

1,475

1,118

1,137

1,178

1,154

1,154

1,142

1,152

1,133

1,188

0

0

0

Depreciation and amortization

1,631

1,550

1,561

1,564

1,521

1,366

1,132

905

724

667

685

683

678

677

718

1,107

1,496

1,883

2,216

2,269

2,241

2,183

2,171

2,110

2,123

2,171

2,186

2,215

2,262

2,316

2,367

0

0

0

Inventory reserve

274

306

321

317

270

283

313

301

268

235

205

160

152

138

186

198

236

201

122

2,171

2,101

2,092

2,066

0

0

0

-

-

-

-

-

-

-

-

Change in contingent consideration

104

133

169

240

206

150

94

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred rent expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

0

Proceeds from sale of New Jersey net operating loss carryforward

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

63

63

63

63

662

0

0

0

-

-

-

-

-

-

-

-

Other non-cash items

-70

-69

-85

-73

34

41

69

68

65

62

-2

-100

-122

-156

-106

-29

-25

-11

-18

-13

-7

3

13

0

0

0

-

-

-

-

-

-

-

-

Proceeds from sale of New Jersey net operating loss carryforward

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Changes in:
Accounts receivable

-954

3,686

554

205

2,910

-754

-1,597

-145

-1,679

-1,615

-1,174

-3,742

-2,338

-994

-3,350

2,196

3,510

3,197

6,293

2,781

3,263

2,552

1,186

2,344

415

-339

1,299

1,591

1,638

4,013

1,240

0

0

0

Financing receivables

-416

-552

-562

-805

-1,041

-1,154

-1,344

-1,447

-1,426

-1,315

-832

-446

-406

-467

-943

-1,471

-1,937

-2,171

-2,535

-2,510

-1,399

-15

354

1,447

8,371

7,473

8,639

0

0

0

-

-

-

-

Note and lease receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Inventory

3,197

428

384

-452

484

858

-87

-2,104

-2,551

-2,166

-3,027

-981

-3,181

-2,161

1,086

1,872

4,240

3,038

1,218

126

-1,255

-792

-290

-991

-15

520

-468

314

964

-227

849

0

0

0

Prepaid expenses and other assets

-1,827

-2,376

-401

984

735

2,506

138

1,333

1,552

1,072

1,120

52

338

129

437

823

830

662

860

271

209

506

-119

-413

-56

-460

-1,149

0

0

0

-

-

-

-

Deferred costs

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Prepaid expenses and other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Deferred costs

-

-

-

-

-

-

-

0

0

3,162

-

2,701

2,369

1,699

1,166

1,028

679

498

491

213

-167

-273

-58

-101

1,028

1,259

1,165

1,483

-693

-756

-271

0

0

0

Deferred revenue

-

-

-

-

-

-

-

0

0

5,459

-

1,732

1,637

868

-347

1,531

1,611

1,907

3,492

1,187

617

613

621

1,430

2,975

2,639

3,136

2,825

1,580

1,621

622

0

0

0

Accounts payable and accrued expenses

3,866

1,085

587

-65

-1,460

1,442

-1,099

4

199

-1,788

-1,874

-2,372

-2,352

-4,012

-1,151

1,229

1,811

4,715

3,694

2,084

1,765

1,268

385

-2,242

555

193

-3,844

-149

-2,192

-3,345

293

0

0

0

Net cash used in operating activities

-673

-1,265

-1,702

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Net cash provided by (used in) operating activities

-

-

-

-

-

-

-

-

-

-1

-

-637

136

-5,149

-6,902

-5,970

-8,155

-1,543

-301

-1,148

157

-1,587

-1,143

0

0

0

-

-

-

-

-

-

-

-

Cash flows from investing activities:
Acquisitions

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capital expenditures

497

404

251

344

349

395

386

313

414

410

505

700

983

1,638

2,182

1,958

1,603

1,065

410

558

609

460

538

391

324

292

326

461

567

547

434

0

0

0

Purchase of investments

1,371

2,625

3,235

2,880

12,741

11,588

11,083

10,806

884

878

956

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

4,423

4,120

3,848

3,841

4,906

6,020

7,017

5,478

8,559

7,442

6,241

7,196

0

0

0

Proceeds from the sale and maturities of investments

10,805

12,061

10,082

9,743

4,666

3,555

1,113

852

923

878

932

934

2,695

7,692

8,434

9,034

7,376

4,635

5,187

6,441

8,081

7,819

10,427

9,709

10,723

11,860

8,399

9,903

6,771

5,146

4,434

0

0

0

Principal payments of capital lease obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

149

159

154

149

144

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by investing activities

5,137

5,935

6,596

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Cash flows from financing activities:
Net cash (used in) provided by investing activities

-

-

-

-

-

-

-

-

-

-410

-

-764

645

4,041

3,498

3,457

2,308

-1,235

-580

1,460

3,352

3,511

6,048

0

0

0

-

-

-

-

-

-

-

-

Borrowings under revolving credit facility

-

-

-

-

-

-

11,655

24,405

26,305

24,505

14,650

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments under revolving credit facility

-

-

-

-

-

-

14,648

24,991

26,305

23,238

11,657

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of stock options

-

-

721

384

253

299

1,277

1,304

1,265

1,234

70

61

129

1,852

2,006

2,102

2,298

572

460

336

251

239

203

206

102

117

117

101

25

7

35

0

0

0

Common stock repurchased - vesting of restricted stock

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Common stock repurchased - vesting of restricted stock

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,050

0

0

0

Net cash used in financing activities

267

64

69

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Net cash used in financing activities

-

-

-

-

-

-

-

-

-

2,501

-

619

59

1,742

1,857

1,943

2,144

423

316

218

170

193

191

0

0

0

-

-

-

-

-

-

-

-

Effect of foreign exchange rate changes on cash and cash equivalents

-

237

-

-

-

-534

-413

-158

106

434

433

63

48

139

62

133

-63

-193

-43

-20

169

124

-128

0

0

0

-

-

-

-

-

-

-

-

Net decrease in cash, cash equivalents and restricted cash

4,706

4,971

5,063

5,983

-5,056

-2,121

126

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Reconciliation of cash, cash equivalents, and restricted cash, beginning of period
Effect of foreign exchange rate changes on cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Net (decrease) increase in cash and cash equivalents

-

-

-

-

-

-

-

-

-

-

-

-719

888

773

-1,485

-437

-3,766

-2,548

-608

510

3,848

2,241

4,968

-388

-1,387

-1,049

-6,772

-8,172

-4,040

-6,323

-6,105

0

0

0

Supplemental disclosure of cash flow information:
Cash paid for:
Taxes

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Interest

-

-

-

-

-

-

130

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Taxes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

-

-

-

Interest

-

-

-

-

-

-

-

-

-

-

-

-

0

45

-

16

21

24

29

24

17

9

0

0

0

0

0

0

0

0

0

0

0

0

Noncash investing and financing activities:
Unrealized loss on investments, net of realized amounts

185

173

66

-58

-178

-166

-102

-47

-11

-22

-11

-1

7

15

15

28

-4

8

-6

-15

26

-44

-82

-92

-57

-4

96

86

1

65

-8

0

0

0

Value of shares withheld pursuant to stock issuance

-

-

-

-

-

-

465

0

0

0

-

-

-

-

457

462

358

169

144

157

200

155

265

258

215

352

260

247

247

110

47

0

0

0

Value of shares withheld pursuant to stock issuance

-

-

-

-

-

0

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash paid

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-