Secureworks corp. (SCWX)
CashFlow / TTM
Jan'20Nov'19Aug'19May'19Feb'19Nov'18Oct'18Aug'18Jul'18May'18Apr'18Jan'18Oct'17Jul'17Apr'17Jan'17Oct'16Jul'16Apr'16Jan'16Oct'15Jul'15Apr'15
Cash flows from operating activities:
Net loss

-31,666

-38,216

-34,043

-33,552

-39,101

0

-22,466

-

-28,117

0

-28,619

-28,077

-39,751

-38,083

-39,863

-38,213

-46,295

-57,105

-66,178

-72,381

0

0

0

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

42,932

42,352

41,843

41,285

41,207

-

41,723

-

42,017

0

42,197

42,171

41,497

40,669

40,060

39,425

39,182

39,338

39,687

40,638

0

0

0

Change in fair value of convertible notes

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

132

132

5,625

5,625

5,493

0

0

0

Stock-based compensation expense

19,548

20,512

20,253

19,556

19,370

-

18,173

-

16,274

0

14,892

13,790

12,586

12,676

12,151

8,883

6,602

3,792

1,001

841

0

0

0

Effects of exchange rate changes on monetary assets and liabilities denominated in foreign currencies

-300

-22

2,175

1,353

1,800

-

36

-

-532

0

-2,230

-3,256

-1,309

-339

1,131

2,239

1,903

827

-38

-836

0

0

0

Income tax benefit

-

0

0

0

-

-

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Other non cash impacts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-4,792

0

0

0

Provision for doubtful accounts

3,099

1,636

1,811

1,643

2,356

-

2,793

-

2,927

0

4,550

3,947

4,144

3,864

2,912

2,613

3,707

4,287

4,312

4,661

0

0

0

Changes in assets and liabilities:
Accounts receivable

-26,789

-14,683

-11,355

-9,795

-13,750

-

227

-

13,507

0

28,870

48,540

32,749

26,923

16,907

-956

30,280

25,232

33,965

52,443

0

0

0

Net transactions with parent

12,483

22,640

13,365

-2,950

1,797

-

-3,881

-

-2,037

0

-4,621

-11,024

-13,860

-13,103

-2,788

15,582

1,596

-659

-10,827

-21,691

0

0

0

Inventories

278

274

467

-38

-562

-

-331

-

-546

0

-802

-917

-1,765

-2,363

-2,755

-1,610

-1,703

1,476

2,311

1,179

0

0

0

Other assets

-13,293

-8,033

-3,399

2,180

7,277

-

-4,681

-

-26,551

0

-26,473

-27,699

-15,293

5,847

811

1,724

-2,496

434

5,601

7,453

0

0

0

Accounts payable

7,008

2,396

2,698

6,191

-6,117

-

5,872

-

1,482

0

-1,068

3,302

533

-666

3,658

3,626

1,740

14,012

-421

-301

0

0

0

Deferred revenue

14,463

19,538

15,877

15,538

20,942

-

0

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue

-

-

-

-

-

-

-

-

-

-

20,098

-

-

-

10,385

7,185

25,801

24,047

29,943

34,591

0

0

0

Accrued and other current liabilities

13,692

27,838

19,513

22,206

21,975

-

-1,558

-

3,050

0

-667

9,416

6,085

10,240

-1,437

11,975

5,599

379

35,187

50,567

0

0

0

Net cash provided by operating activities

78,839

67,012

59,545

72,578

57,199

-

30,031

-

20,088

0

2,038

787

8,631

6,327

-10,285

-6,838

-22,322

-28,012

-17,872

-9,843

0

0

0

Cash flows from investing activities:
Capital expenditures

12,590

15,308

15,493

15,000

10,200

-

9,117

-

10,809

0

12,685

13,819

17,752

19,807

19,237

19,361

15,301

10,746

9,410

9,023

0

0

0

Net cash used in investing activities

-12,590

-15,308

-15,493

-15,000

-10,200

-

-9,117

-

-10,809

0

-12,685

-13,819

-17,752

-19,807

-19,237

-19,361

-15,301

-10,746

-9,410

-9,023

0

0

0

Cash flows from financing activities:
Principal payments on financing arrangement with Dell Financial Services

0

1,104

1,104

1,104

2,208

-

0

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Net transactions with parent, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

24,383

0

0

0

Taxes paid on vested restricted shares

8,453

8,251

8,140

7,659

2,207

-

929

-

915

0

789

0

1,224

1,224

1,224

0

0

0

0

-

-

-

-

Purchases of stock for treasury

6,377

18,840

19,908

14,441

13,531

-

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on financed capital expenditures

500

500

500

500

1,000

-

0

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on financing arrangement with Dell Financial Services

-

-

-

-

-

-

-

-

-

-

-1,104

-

-

-

0

-

-

-

-

-

-

-

-

Proceeds from Issuance Initial Public Offering

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

99,604

99,604

99,604

99,971

0

0

0

0

Capital contribution from parent, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,547

9,547

9,547

10,000

0

0

0

0

Excess tax benefit from share-based payment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

221

0

0

0

-

-

-

-

Payments on financed capital expenditures

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

Net cash used in financing activities

-14,003

-28,695

-29,652

-23,704

-18,946

-

-4,825

-

-3,743

0

-3,617

-2,024

-2,024

-2,024

-2,623

109,372

109,007

131,785

139,056

45,619

0

0

0

Net (decrease) increase in cash and cash equivalents

52,246

23,009

14,400

33,874

28,053

0

-

0

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

Net (decrease) increase in cash and cash equivalents

-

-

-

-

-

-

16,089

-

5,536

-

-14,264

-15,056

-11,145

-15,504

-32,145

83,173

71,384

93,027

111,774

26,753

0

0

0

Supplemental Disclosures of Non-Cash Investing and Financing Activities:
Conversion of convertible notes to common stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

28,125

0

0

0

0

Income taxes paid

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-