Microstrategy incorporated (MSTR)
CashFlow / Quarterly
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'14Dec'13Sep'13Jun'13Mar'13Dec'12Sep'12Jun'12Mar'12Dec'11Sep'11Jun'11Mar'11
Operating activities:
Net income (loss)

657

12,167

9,700

20,394

-7,906

3,301

12,699

4,828

1,673

-25,499

18,184

9,953

15,557

32,455

26,628

18,884

14,272

39,111

23,893

22,467

20,460

22,699

-845

-10,337

-6,482

16,148

17,146

-1,553

51,591

8,240

4,763

7,271

272

9,000

4,921

2,885

1,134

Less: Income from discontinued operations, net of tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

56,782

-110

-371

-657

-789

-

-

-

-

Income from continuing operations, net of tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,148

17,146

-1,553

-5,191

8,350

5,134

7,928

1,061

-

-

-

-

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

2,756

5,156

3,856

6,030

1,657

218

-387

572

3,298

3,523

3,469

4,049

4,491

6,855

4,257

4,279

4,553

5,042

5,856

5,213

5,103

5,990

6,045

6,558

6,702

6,815

6,482

6,646

6,456

6,257

5,388

4,891

5,918

4,366

5,054

4,233

3,618

Reduction in carrying amount of right-of-use assets

2,053

-

-

-

2,007

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Credit losses and sales allowances

828

-792

96

-31

827

847

105

783

165

574

-109

791

1,044

-995

696

-8

531

201

222

97

364

727

209

346

1,687

893

-7

550

845

-2,461

1,782

2,063

977

508

675

-550

816

Net realized loss on short-term investments

0

0

0

0

-41

-153

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized net loss on foreign currency forward contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-2,590

949

756

1,012

-46

-40

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash restructuring costs and adjustments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-9

0

-225

98

364

-165

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred taxes

957

738

-133

-1,525

-1,694

-1,607

-909

-3,096

-2,662

1,903

-1,854

-2,686

-968

-11

-1,902

-3,225

688

-1,349

-2,293

8,520

4,788

10,811

-3,413

-4,500

-4,424

716

2,106

-2,179

-3,962

-272

-4,117

8,723

-2,367

-637

118

-1,129

-1,723

Release of liabilities for unrecognized tax benefits

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

838

0

0

61

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Share-based compensation expense

3,111

2,322

1,834

3,036

3,017

3,504

3,011

3,378

4,743

3,710

3,668

3,774

3,115

3,393

3,349

3,571

1,504

4,796

4,546

4,360

3,597

3,225

3,879

3,084

1,598

1,634

444

0

0

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

36

0

-58

1,266

133

0

495

468

0

0

0

0

0

0

1

23,579

0

0

0

0

-3,791

1,937

2

1,852

Changes in operating assets and liabilities:
Accounts receivable

-14,406

15,453

-5,796

4,281

-10,266

17,657

-4,256

-4,622

-422

3,456

-2,771

-6,449

-9,584

25,861

3,893

-961

-11,915

14,508

147

-3,494

-16,164

23,764

2,955

-9,880

-16,563

23,727

-11,697

4,688

-17,394

14,605

-3,000

5,280

-17,411

18,715

8,760

5,653

-18,802

Prepaid expenses and other current assets

3,295

-1,902

2,576

-10,159

3,070

5,486

1,528

-4,236

3,783

-303

4,050

722

270

84

-2,798

-96

3,551

-1,069

-2,005

-995

-377

-2,484

1,207

4,096

-106

653

1,626

-1,295

-419

-2,412

-1,936

5,063

-1,020

-2,272

83

-1,770

-3,273

Deposits and other assets

-84

-412

-253

-230

134

245

612

572

-228

-4,317

1,013

373

-98

151

1,835

2,074

-4

-69

-1,270

-102

-190

-497

-6

-19

-387

-291

-369

-109

-25

364

-325

20

-234

-411

378

480

-542

Accounts payable and accrued expenses

-154

4,297

-3,222

-5,288

-3,108

9,194

1,959

-1,759

-6,016

5,375

1,004

823

-16,295

11,649

-281

-1,294

-3,093

6,837

3,691

-2,463

-6,161

1,056

2,434

-3,312

-1,879

3,222

-5,886

-1,768

-354

1,341

8,123

-7,259

1,558

5,784

1,344

-469

-1,637

Accrued compensation and employee benefits

-13,031

4,710

714

4,113

-12,195

9,017

-886

5,070

-8,085

4,228

275

584

-11,296

-138

865

3,935

-4,083

1,888

-4,050

6,726

-12,951

-7,495

2,517

5,363

-27,260

15,084

5,607

6,951

-19,466

10,980

5,319

5,765

-17,486

14,977

4,538

7,908

-17,707

Accrued restructuring costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-2

-23

-7

-26

18

-186

-634

-1,120

-5,704

8,083

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue and advance payments

22,001

-2,776

-9,877

-5,013

38,502

-18,094

-14,534

-9,068

19,570

-1,729

-9,918

-11,236

22,294

-9,744

-1,947

-8,683

30,065

-15,329

-2,472

-13,995

27,620

-10,992

-10,503

-2,356

24,582

-4,258

8,022

-9,781

19,482

-1,877

-5,262

-12,677

15,849

6,899

-420

-8,467

20,298

Operating lease liabilities

-2,238

-2,226

-2,078

-2,242

-2,074

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

934

-177

-165

-829

320

4,222

-3,253

-4,384

9,164

35,821

-257

-814

-833

-777

-830

-772

-686

-609

-645

-761

-1,009

-533

-1,452

2,895

-840

-322

-452

-590

-1,564

-573

-616

1,401

-2,212

2,681

-791

3,212

2,644

Net cash provided by operating activities

-

-

-

-

-

-

-

-

-

-

-

-

26,521

-

27,488

15,721

50,827

-

-

-

-

-1,721

1,951

3,590

10,780

15,345

31,203

-6,455

-9,495

8,716

21,012

472

21,963

-

-

-

-

Net cash used in operating activities from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-664

-19

326

-1,397

-1,189

-

-

-

-

Net cash provided by operating activities

29,069

8,544

3,121

22,746

26,456

-12,621

-79

4,610

18,717

-

-

-

-

-

-

-

-

-

-

-

55,846

-

-

-

-

15,345

31,203

-6,455

-10,159

8,697

21,338

-925

20,774

28,438

910

3,258

28,208

Investing activities:
Proceeds from redemption of short-term investments

10,000

94,999

219,754

55,200

314,403

142,820

103,300

49,860

195,820

49,800

189,060

60,720

91,140

88,160

120,700

89,320

63,500

163,200

144,500

81,500

90,000

86,600

129,100

10,000

83,200

58,000

29,000

0

0

-

-

-

-

-

-

-

-

Purchases of property and equipment

661

800

950

2,421

6,011

2,389

1,813

1,350

1,294

1,700

815

647

820

777

625

742

193

132

98

1,719

1,535

544

7,672

2,508

1,676

1,024

1,098

3,424

5,497

2,737

3,618

10,379

12,887

7,563

10,322

14,480

4,326

Purchases of short-term investments

9,928

0

108,239

74,149

138,099

19,490

78,152

112,936

483,440

44,802

195,064

53,181

163,421

62,051

131,130

64,401

97,417

129,746

144,397

81,481

118,155

66,485

91,962

114,556

97,047

14,988

80,072

129,043

0

-

-

-

-

-

-

-

-

Capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

4,244

5,354

6,142

2,254

0

0

-

-

-

-

-

-

-

-

0

475

1,656

3,776

Insurance proceeds

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

1,400

1,806

1,390

0

2,055

3,620

Increase in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-134

-59

80

-849

923

-448

538

386

13

-40

124

-151

-32

-62

20

-110

-6

149

18

Net cash used in investing activities

-

-

-

-

-

-

-

-

-

-

-

-

-73,101

-

-11,055

24,177

-34,110

-

-

-

-

14,278

26,289

-106,616

-16,061

41,579

-55,861

-134,163

-5,621

-2,586

-6,684

-13,967

-11,101

-

-

-

-

Net cash provided by investing activities from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-497

99,633

-368

-451

-111

-565

-

-

-

-

Net cash (used in) provided by investing activities

-589

94,199

110,565

-21,370

170,293

120,941

23,335

-64,426

-288,914

-

-

-

-

-

-

-

-

-

-

-

-35,124

-

-

-

-

41,579

-55,861

-134,660

94,012

-2,954

-7,135

-14,078

-11,666

-10,032

-7,420

-14,230

-4,500

Financing activities:
Proceeds from sale of class A common stock under exercise of employee stock options

340

1,127

3,606

329

1,507

0

0

2,471

0

0

0

582

1,095

506

0

916

241

4,090

0

3,972

1,467

856

0

0

0

0

0

2

339

1,293

6,010

1,967

980

256

653

64

1,490

Payment of taxes relating to net exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

3,739

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

36

0

-58

1,266

133

0

495

468

0

0

0

0

0

0

1

23,579

0

0

0

0

-3,791

1,937

2

1,852

Purchases of treasury stock

50,747

24,475

0

0

48,244

110,977

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on capital lease obligations and other financing arrangements prior to the adoption of ASU 2016-02

-

-

-

-

-

0

0

2

7

4

5

6

6

6

-1,054

1,098

122

17

1,214

52

164

291

1,694

85

256

247

1,713

181

143

235

256

0

0

-

-

-

-

Net cash used in financing activities

-50,407

-23,348

3,606

329

-46,737

-110,977

0

2,469

-7

-

-

-

-

-

-

-

-

-

-

-

1,771

-

-

-

-

-247

-1,713

-178

23,775

1,058

5,754

1,967

980

-3,535

2,590

66

3,342

Net cash provided by financing activities from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

0

0

0

0

-

-

-

-

Net cash (used in) provided by financing activities

-

-

-

-

-

-

-

-

-

-

-

-

1,089

-

1,054

-240

-2,354

-

-

-

-

565

-1,694

-85

-256

-247

-1,713

-178

23,775

1,058

5,754

1,967

980

-

-

-

-

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

-3,871

2,552

-3,959

1,166

-1,133

460

-1,664

-4,442

2,202

1,230

1,746

2,940

2,306

-5,830

602

-1,214

2,266

-1,561

-1,293

1,335

-4,318

-2,209

-2,399

219

117

-283

1,460

-214

-1,826

983

1,112

-2,556

1,410

-1,537

-2,805

788

1,996

Net (decrease) increase in cash, cash equivalents, and restricted cash

-25,798

81,947

113,333

2,871

148,879

-2,197

21,592

-61,789

-268,002

33,563

7,092

21,000

-43,185

36,591

18,089

38,444

16,629

62,110

29,042

36,052

18,175

10,913

24,147

-102,892

-5,420

56,394

-24,911

-141,507

105,802

7,784

21,069

-15,592

11,498

13,334

-6,725

-10,118

29,046

Supplemental disclosure of noncash investing and financing activities:
Assets acquired under capital lease obligations and other financing arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

14

70

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-