Microstrategy incorporated (MSTR)
CashFlow / TTM
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)

42,918

34,355

25,489

28,488

12,922

22,501

-6,299

-814

4,311

18,195

76,149

84,593

93,524

92,239

98,895

96,160

99,743

105,931

89,519

64,781

31,977

5,035

-1,516

16,475

25,259

83,332

75,424

63,041

71,865

20,546

21,306

21,464

17,078

17,940

0

0

0

Less: Income from discontinued operations, net of tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

56,782

56,672

56,301

55,644

-1,927

0

0

0

-

-

-

-

Income from continuing operations, net of tax

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

26,550

18,752

6,740

16,221

22,473

0

0

0

-

-

-

-

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

17,798

16,699

11,761

7,518

2,060

3,701

7,006

10,862

14,339

15,532

18,864

19,652

19,882

19,944

18,131

19,730

20,664

21,214

22,162

22,351

23,696

25,295

26,120

26,557

26,645

26,399

25,841

24,747

22,992

22,454

20,563

20,229

19,571

17,271

0

0

0

Reduction in carrying amount of right-of-use assets

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Credit losses and sales allowances

101

100

1,739

1,748

2,562

1,900

1,627

1,413

1,421

2,300

731

1,536

737

224

1,420

946

1,051

884

1,410

1,397

1,646

2,969

3,135

2,919

3,123

2,281

-1,073

716

2,229

2,361

5,330

4,223

1,610

1,449

0

0

0

Net realized loss on short-term investments

0

-41

-194

-194

-194

-153

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized net loss on foreign currency forward contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-1,641

-885

127

2,671

1,682

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash restructuring costs and adjustments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-136

237

72

297

199

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred taxes

37

-2,614

-4,959

-5,735

-7,306

-8,274

-4,764

-5,709

-5,299

-3,605

-5,519

-5,567

-6,106

-4,450

-5,788

-6,179

5,566

9,666

21,826

20,706

7,686

-1,526

-11,621

-6,102

-3,781

-3,319

-4,307

-10,530

372

1,967

1,602

5,837

-4,015

-3,371

0

0

0

Release of liabilities for unrecognized tax benefits

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

899

61

61

61

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Share-based compensation expense

10,303

10,209

11,391

12,568

12,910

14,636

14,842

15,499

15,895

14,267

13,950

13,631

13,428

11,817

13,220

14,417

15,206

17,299

15,728

15,061

13,785

11,786

10,195

6,760

3,676

2,078

0

0

0

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

1,244

1,341

1,341

1,894

1,096

963

963

468

0

0

0

1

23,580

23,580

23,580

23,579

0

-3,791

-1,854

-1,852

0

0

0

0

Changes in operating assets and liabilities:
Accounts receivable

-468

3,672

5,876

7,416

-1,487

8,357

-5,844

-4,359

-6,186

-15,348

7,057

13,721

19,209

16,878

5,525

1,779

-754

-5,003

4,253

7,061

675

276

239

-14,413

155

-676

-9,798

-1,101

-509

-526

3,584

15,344

15,717

14,326

0

0

0

Prepaid expenses and other current assets

-6,190

-6,415

973

-75

5,848

6,561

772

3,294

8,252

4,739

5,126

-1,722

-2,540

741

-412

381

-518

-4,446

-5,861

-2,649

2,442

2,713

5,850

6,269

878

565

-2,500

-6,062

296

-305

-165

1,854

-4,979

-7,232

0

0

0

Deposits and other assets

-979

-761

-104

761

1,563

1,201

-3,361

-2,960

-3,159

-3,029

1,439

2,261

3,962

4,056

3,836

731

-1,445

-1,631

-2,059

-795

-712

-909

-703

-1,066

-1,156

-794

-139

-95

34

-175

-950

-247

213

-95

0

0

0

Accounts payable and accrued expenses

-4,367

-7,321

-2,424

2,757

6,286

3,378

-441

-1,396

1,186

-9,093

-2,819

-4,104

-6,221

6,981

2,169

6,141

4,972

1,904

-3,877

-5,134

-5,983

-1,701

465

-7,855

-6,311

-4,786

-6,667

7,342

1,851

3,763

8,206

1,427

8,217

5,022

0

0

0

Accrued compensation and employee benefits

-3,494

-2,658

1,649

49

1,006

5,116

327

1,488

-2,998

-6,209

-10,575

-9,985

-6,634

579

2,605

-2,310

481

-8,387

-17,770

-11,203

-12,566

-26,875

-4,296

-1,206

382

8,176

4,072

3,784

2,598

4,578

8,575

7,794

9,937

9,716

0

0

0

Accrued restructuring costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-58

-38

-201

-828

-1,922

-7,644

625

1,259

2,379

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred revenue and advance payments

4,335

20,836

5,518

861

-3,194

-22,126

-5,761

-1,145

-3,313

-589

-8,604

-633

1,920

9,691

4,106

3,581

-1,731

-4,176

161

-7,870

3,769

731

7,465

25,990

18,565

13,465

15,846

2,562

-334

-3,967

4,809

9,651

13,861

18,310

0

0

0

Operating lease liabilities

-8,784

-8,620

-6,394

-4,316

-2,074

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other long-term liabilities

-237

-851

3,548

460

-3,095

5,749

37,348

40,344

43,914

33,917

-2,681

-3,254

-3,212

-3,065

-2,897

-2,712

-2,701

-3,024

-2,948

-3,755

-99

70

281

1,281

-2,204

-2,928

-3,179

-3,343

-1,352

-2,000

1,254

1,079

2,890

7,746

0

0

0

Net cash provided by operating activities

-

-

-

-

-

-

-

-

-

-

-

-

86,283

-

0

0

0

-

-

-

-

14,600

31,666

60,918

50,873

30,598

23,969

13,778

20,705

52,163

0

0

0

-

-

-

-

Net cash used in operating activities from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-664

-683

-357

-1,754

-2,279

0

0

0

-

-

-

-

Net cash provided by operating activities

63,480

60,867

39,702

36,502

18,366

10,627

0

0

0

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

29,934

23,286

13,421

18,951

49,884

69,625

49,197

53,380

60,814

0

0

0

Investing activities:
Proceeds from redemption of short-term investments

379,953

684,356

732,177

615,723

610,383

491,800

398,780

484,540

495,400

390,720

429,080

360,720

389,320

361,680

436,720

460,520

452,700

479,200

402,600

387,200

315,700

308,900

280,300

180,200

170,200

87,000

0

0

0

-

-

-

-

-

-

-

-

Purchases of property and equipment

4,832

10,182

11,771

12,634

11,563

6,846

6,157

5,159

4,456

3,982

3,059

2,869

2,964

2,337

1,692

1,165

2,142

3,484

3,896

11,470

12,259

12,400

12,880

6,306

7,222

11,043

12,756

15,276

22,231

29,621

34,447

41,151

45,252

36,691

0

0

0

Purchases of short-term investments

192,316

320,487

339,977

309,890

348,677

694,018

719,330

836,242

776,487

456,468

473,717

409,783

421,003

354,999

422,694

435,961

453,041

473,779

410,518

358,083

391,158

370,050

318,553

306,663

321,150

224,103

0

0

0

-

-

-

-

-

-

-

-

Capitalized software development costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,598

15,740

17,994

13,750

8,396

0

0

0

-

-

-

-

-

-

-

-

5,907

0

0

0

Insurance proceeds

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,206

4,596

4,596

5,251

7,065

0

0

0

Increase in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-962

95

-294

164

1,399

489

897

483

-54

-99

-121

-225

-184

-158

53

51

0

0

0

Net cash used in investing activities

-

-

-

-

-

-

-

-

-

-

-

-

-34,647

-

0

0

0

-

-

-

-

-82,110

-54,809

-136,959

-164,506

-154,066

-198,231

-149,054

-28,858

-34,338

0

0

0

-

-

-

-

Net cash provided by investing activities from discontinued operations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

99,136

98,768

98,317

98,703

-1,495

0

0

0

-

-

-

-

Net cash (used in) provided by investing activities

182,805

353,687

380,429

293,199

250,143

-209,064

0

0

0

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-54,930

-99,463

-50,737

69,845

-35,833

-42,911

-43,196

-43,348

-36,182

0

0

0

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

5,402

6,569

5,442

1,836

3,978

2,471

2,471

2,471

582

1,677

2,183

2,183

2,517

1,663

5,247

5,247

8,303

9,529

6,295

6,295

2,323

856

0

0

2

341

1,634

7,644

9,609

10,250

9,213

3,856

1,953

2,463

0

0

0

Payment of taxes relating to net exercise of employee stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

3,739

3,739

3,739

3,739

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from share-based compensation arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

1,244

1,341

1,341

1,894

1,096

963

963

468

0

0

0

1

23,580

23,580

23,580

23,579

0

-3,791

-1,854

-1,852

0

0

0

0

Purchases of treasury stock

75,222

72,719

159,221

159,221

159,221

110,977

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

-

-

-

-

-

9

13

18

22

21

23

-1,036

56

172

183

2,451

1,405

1,447

1,721

2,201

2,234

2,326

2,282

2,301

2,397

2,284

2,272

815

634

491

0

0

0

-

-

-

-

Net cash used in financing activities

-69,820

-66,150

-153,779

-157,385

-155,245

-108,515

0

0

0

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

21,637

22,942

30,409

32,554

9,759

5,166

2,002

101

2,463

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

2,439

-

0

0

0

-

-

-

-

-1,470

-2,282

-2,301

-2,394

21,637

22,942

30,409

32,554

9,759

0

0

0

-

-

-

-

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

-4,112

-1,374

-3,466

-1,171

-6,779

-3,444

-2,674

736

8,118

8,222

1,162

18

-4,136

-4,176

93

-1,802

747

-5,837

-6,485

-7,591

-8,707

-4,272

-2,346

1,513

1,080

-863

403

55

-2,287

949

-1,571

-5,488

-2,144

-1,558

0

0

0

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

172,353

347,030

262,886

171,145

106,485

-310,396

-274,636

-289,136

-206,347

18,470

21,498

32,495

49,939

109,753

135,272

146,225

143,833

145,379

94,182

89,287

-49,657

-73,252

-27,771

-76,829

-115,444

-4,222

-52,832

-6,852

119,063

24,759

30,309

2,515

7,989

25,537

0

0

0

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

14

84

84

84

70

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-