Allscripts healthcare solutions, inc. (MDRX)
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'11Dec'10Sep'10Jun'10Mar'10
Cash flows from operating activities:
Net loss

-194,979

-182,602

222,264

204,143

428,345

407,807

36,774

43,158

-174,125

-154,175

-166,156

-148,537

-7,662

3,030

16,525

11,235

10,155

-2,056

-20,611

-41,241

-55,795

-66,453

-84,893

-108,070

-113,176

-104,026

-107,730

-49,415

-18,558

-1,153

49,152

58,914

66,809

73,609

23,484

22,924

20,138

0

-

-

0

Less: Loss from discontinued operations

-

-

-

-

-

395,138

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(Loss) income from continuing operations

-

-

-

-

-

12,669

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

209,072

207,106

201,580

197,757

194,524

192,346

145,236

151,223

155,582

157,328

170,963

161,049

151,570

136,328

156,998

154,099

153,802

161,011

167,203

169,024

170,797

174,263

178,564

182,577

181,945

178,815

171,449

162,314

157,015

150,234

145,746

141,573

136,750

132,400

129,694

113,801

90,858

0

-

-

0

Operating right-of-use asset amortization

22,845

22,534

16,722

11,007

5,320

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation expense

37,278

38,982

38,334

39,274

36,339

34,638

34,267

35,233

38,551

36,540

35,516

35,497

35,120

37,093

37,155

36,403

35,462

34,663

34,276

35,423

38,304

39,254

40,619

41,048

39,076

37,010

41,257

39,580

39,403

39,126

38,060

39,187

39,732

40,752

38,434

38,137

30,559

0

-

-

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,270

1,273

839

644

-1,900

-1,885

-1,130

0

2,837

3,612

3,365

3,887

6,203

5,908

5,069

3,516

4,739

1,868

4,743

8,818

4,231

6,594

4,382

0

-

-

0

Provision for doubtful accounts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

Deferred taxes

40,136

37,970

5,013

7,031

-3,427

-4,144

-1,187

-4,100

7,935

10,228

5,646

7,619

5,728

4,520

8,727

2,707

1,619

2,206

3,729

7,950

5,403

56

6,347

8,406

25,402

43,880

45,268

48,471

30,198

12,780

-9,134

-25,660

-33,838

-33,395

-31,181

-10,962

0

0

-

-

0

Asset impairment charges

10,739

10,837

32,128

31,880

58,264

58,166

0

0

0

-

-

-

-

4,650

5,853

5,875

6,168

1,544

597

763

2,221

2,390

3,084

10,267

11,330

11,454

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Recovery of long-term investments

1,651

651

-1,058

-1,058

8,987

15,487

15,500

36,200

170,790

165,290

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Equity in net (loss) income of unconsolidated investments

-

-

-

-

-

-

0

0

475

-

706

257

-4,613

-7,501

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on sale of businesses, net

-

-

-

-

-

172,258

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Change in fair value of 1.25% call option and cash conversion option

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

Other loss (income), net

-9,428

-9,377

5,723

6,448

8,161

9,338

1,625

287

-724

-2,905

-5,180

-4,857

-4,310

-3,526

845

701

1,123

614

-2,627

-2,247

-3,055

-3,553

-7,272

-6,911

-11,436

-1,398

1,048

1,880

6,254

-2,407

-1,623

-2,412

-5,630

-3,513

-3,307

-2,707

0

0

-

-

0

Changes in operating assets and liabilities (net of businesses acquired):
Accounts receivable and contract assets, net

39,920

13,273

56,776

80,868

109,902

109,134

62,405

68,152

70,124

95,189

27,451

9,558

-11,342

8,918

16,568

20,379

14,279

-3,215

-14,703

-19,920

-18,778

14,644

40,958

25,177

24,978

7,705

-65,038

-40,219

-42,066

-45,978

-15,481

-8,752

32,535

30,731

66,229

38,726

9,097

0

-

-

0

Inventories

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

Prepaid expenses and other assets

-637

15,374

42,778

62,548

45,659

55,818

-7,733

-12,489

-11,182

-13,219

5,866

7,700

-1,805

-4,454

-9,265

-14,494

-17,759

-17,614

-20,872

-10,100

11,361

7,038

14,331

12,870

8,286

23,481

36,662

27,560

17,800

14,430

779

8,725

18,201

17,551

15,271

28,924

26,370

0

-

-

0

Accounts payable

-3,550

27,799

-9,834

-22,057

-16,484

-19,159

-4,447

2,228

-17,947

-19,785

22,091

26,943

31,396

45,524

16,438

4,279

-6,773

-11,953

-17,645

-6,254

10,762

-1,944

28,738

6,520

1,170

23,794

4,380

8,546

9,763

3,440

8,667

9,689

9,154

-8,546

-23,616

-12,651

-12,191

0

-

-

0

Accrued expenses

156,276

141,407

173,298

182,143

21,967

40,484

28,963

20,500

29,368

10,131

-127

748

-3,176

-2,774

-14,028

-16,755

-12,774

-22,974

-18,436

-25,194

-23,877

-22,767

-17,691

-4,723

-11,191

-4,552

12,332

-5,276

-1,616

3,397

-18,829

-6,385

3,271

8,581

11,349

21,686

18,920

0

-

-

0

Accrued compensation and benefits

6,318

-32,471

-30,160

-38,218

-7,475

13,440

12,961

25,193

5,608

18,717

8,349

-1,212

8,914

-10,514

1,996

10,583

-3,536

10,257

-9,320

-14,066

-13,653

-29,544

-3,727

5,345

5,606

33,482

27,042

17,699

17,288

13,101

550

-8,407

-12,347

-14,766

-16,078

-9,580

-3,640

0

-

-

0

Deferred revenue

-76,522

-94,353

-33,364

3,950

54,797

58,010

46,758

64,479

50,103

112,684

-23,344

-24,118

-12,124

-11,418

53,719

47,927

40,525

20,372

9,617

10,436

8,101

33,109

-4,010

-5,437

17,213

-1,573

-7,801

-467

-9,699

-16,591

19,116

22,531

56,767

57,606

53,720

80,844

54,508

0

-

-

0

Other liabilities

-6,193

-7,746

13,149

10,481

10,561

12,091

3,316

10,226

21,876

17,969

15,087

7,742

1,114

2,165

879

755

-82

-183

-2,646

-1,460

-2,719

-7,025

-12,865

-15,908

-18,469

-15,862

-6,796

-3,589

-319

2,356

-510

337

-366

-690

487

-281

946

0

-

-

0

Operating leases

-24,670

-24,350

-17,897

-11,874

-5,854

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accrued DOJ settlement

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by operating activities - discontinued operations

0

-30,000

-67,568

-56,337

-55,336

-21,343

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by operating activities

0

46,254

20,281

-559

15,399

67,891

187,786

236,596

258,253

279,415

257,029

246,264

268,548

269,004

268,424

254,869

228,982

211,579

179,806

154,031

140,738

103,496

69,679

68,465

62,909

80,987

121,433

140,026

187,442

222,670

271,977

283,047

276,454

268,754

181,722

194,928

176,845

0

-

-

0

Cash flows from investing activities:
Capital expenditures

14,598

16,600

22,860

26,716

28,648

31,309

20,467

27,746

31,743

38,759

47,277

40,510

38,879

32,107

29,157

25,339

19,959

18,322

19,993

18,782

20,608

26,438

37,798

45,751

69,640

74,130

81,673

87,084

77,178

80,166

66,486

61,860

75,513

44,306

63,489

45,730

0

0

-

-

0

Capitalized software

113,792

113,836

116,405

111,191

115,740

113,308

94,255

103,998

110,398

118,241

129,264

126,655

111,056

92,179

86,562

64,686

55,083

49,264

45,039

44,296

40,832

40,661

39,882

40,559

43,299

42,026

34,087

35,545

37,568

42,965

146,617

118,007

90,337

60,748

-4,337

6,613

0

0

-

-

0

Sales and maturities of marketable securities and other investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

3,774

1,326

1,336

50

0

0

0

-

-

0

0

-

-

-

-

55

1,592

1,630

4,339

0

-

-

0

Cash paid for business acquisitions, net of cash acquired

-

-

-

-

-

177,233

292,748

343,081

273,060

169,823

-781,135

-801,728

103,812

99,837

935,280

905,540

9,372

9,372

0

0

0

-

-

-

-

148,875

148,875

148,875

148,802

0

0

0

0

-

-

-

-

-

-

-

-

Purchases of equity securities, other investments and related intangible assets, net

10,251

7,191

21,402

15,370

16,902

16,934

0

0

0

-

-

-

-

21,185

23,817

26,384

215,536

215,786

212,654

217,557

16,326

21,544

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other proceeds from investing activities

-9

-14

-14

-17

-22

-54

-54

-261

-252

-215

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of marketable securities and other investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12,901

12,909

4,213

0

-

-

0

Proceeds received from sale of fixed assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

19

-

14

38

37

85

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,225

-2,225

-4,441

-4,441

0

-

-

0

Sales and maturities of other investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

Net cash used in investing activities - discontinued operations

-

-

-

-

-

-221,021

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-162,075

-161,056

572,070

395,985

585,436

469,034

-439,482

-315,527

0

-412,972

-309,849

-275,995

-1,183,141

-1,154,006

-1,074,779

-1,019,454

-297,473

-288,966

-283,270

-308,823

-96,573

-108,688

-119,243

-100,246

-118,531

-252,140

-251,770

-258,607

-250,953

-123,037

-119,949

-119,157

-98,290

-95,674

52,804

70,275

72,399

0

-

-

0

Cash flows from financing activities:
Proceeds from sale or issuance of common stock

-

-

-

-

-

1,283

2,851

1,780

1,780

1,568

0

79

79

84

1,624

2,204

103,596

103,631

101,908

101,236

-146

1,487

1,861

3,866

5,189

11,447

12,733

10,921

11,435

5,519

11,680

19,004

20,237

35,119

0

0

0

-

-

-

-

Net proceeds from stock-based compensation activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Proceeds from employee stock purchase plan, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Excess tax benefits from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

1,014

1,270

1,273

839

644

-1,900

-1,885

-1,130

0

2,837

3,612

3,365

3,887

6,203

5,908

5,069

3,516

4,739

1,868

4,743

8,818

4,231

6,594

4,382

0

-

-

0

Taxes paid related to net share settlement of equity awards

5,133

7,286

7,465

7,551

6,297

9,466

9,255

9,325

9,901

7,269

7,602

7,395

9,922

8,204

8,727

8,892

9,001

7,062

7,223

7,371

9,423

10,400

10,739

11,634

11,268

9,732

13,824

13,331

9,642

10,292

13,629

15,077

13,754

11,456

0

0

0

-

-

-

-

Payments for issuance costs on 0.875% Convertible Senior Notes

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments of lease obligations

-

-

-

-

-

-

0

0

-1,477

-

5,525

4,698

3,146

370

4,145

2,099

769

598

429

369

413

455

379

381

386

458

603

691

772

822

988

1,140

1,293

1,427

1,567

1,548

1,520

0

-

-

0

Credit facility payments

295,000

220,000

478,750

508,750

718,751

713,751

272,859

242,201

51,413

138,139

189,944

214,747

213,732

155,170

129,106

248,590

246,050

238,511

213,037

75,033

87,188

96,876

109,063

101,252

612,292

609,593

591,896

618,296

253,966

250,874

243,187

259,464

105,431

170,424

217,376

195,880

170,390

0

-

-

0

Credit facility borrowings, net of issuance costs

369,241

279,241

354,241

335,000

405,000

430,843

461,146

480,844

390,844

325,001

-214,437

-229,135

330,000

250,000

668,577

753,785

269,161

284,161

279,719

176,475

101,964

101,964

141,964

105,000

346,940

460,983

410,958

410,808

453,053

324,010

324,035

324,016

-169

47,193

594,937

595,106

591,506

0

-

-

0

Repurchase of common stock

56,104

111,460

139,183

102,093

146,399

138,928

101,905

101,905

69,676

12,077

62,236

81,243

83,724

121,241

71,082

52,075

37,517

0

0

0

0

-

-

-

-

-

-

-

-

225,961

227,372

227,372

52,009

51,462

0

0

0

-

-

-

-

Payment of acquisition and other financing obligations

17,541

14,685

13,445

3,445

2,027

5,198

2,111

4,509

4,509

1,283

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of subsidiary shares owned by non-controlling interest

-264

53,800

54,317

54,317

61,262

7,198

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by financing activities - discontinued operations

-

-

-

-

-

149,432

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided (used in) by financing activities

190,302

67,343

-351,998

-182,900

-375,212

-292,983

262,327

146,668

0

198,585

-814,212

-870,692

20,372

-33,887

792,017

779,211

80,259

142,265

159,038

193,053

3,664

-4,280

26,181

-1,389

6,947

131,933

99,270

71,318

-20,237

-154,904

-144,722

-158,165

-147,676

-143,639

-311,577

-294,376

-225,531

0

-

-

0

Effect of exchange rate changes on cash and cash equivalents

-673

203

-399

-190

-526

-624

-264

-27

506

860

47

-276

-662

-532

191

-508

-132

-1,178

-1,521

-974

-929

-309

-62

436

-1,973

-1,782

-1,815

-1,126

296

1,474

1,588

-1,023

-254

-1,091

-265

1,434

1,440

0

-

-

0

Net increase (decrease) in cash and cash equivalents

64,284

-47,256

18,933

7,363

4,076

22,297

10,367

51,662

39,381

65,888

32,173

-1,541

4,275

-20,263

-14,147

14,118

11,636

63,700

54,053

37,287

46,900

-9,781

-23,445

-32,734

-50,648

-41,002

-32,882

-48,389

-83,452

-53,797

8,894

4,702

30,234

28,350

-77,316

-27,739

25,153

0

-

-

0

Supplemental non-cash information:
Accretion of redemption preference on redeemable convertible non-controlling interest in Netsmart

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Obligations to enter into capital leases

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-