Logmein, inc. (LOGM)
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
Cash flows from operating activities
Net income (loss)

-16,801

-14,555

14,935

22,544

35,620

74,371

142,304

139,507

147,799

99,523

8,064

-2,513

-14,853

2,638

7,011

13,231

13,113

14,558

11,636

8,381

7,323

7,955

4,183

1,819

-871

-7,682

-5,026

-4,252

-2,317

3,566

3,385

3,795

5,902

5,761

0

0

0

Adjustments to reconcile net income (loss) to net cash provided by operating activities:
Stock-based compensation

70,036

68,206

67,759

65,836

64,799

65,734

66,857

69,934

69,064

67,292

60,278

50,512

43,952

38,350

34,591

32,260

30,238

26,499

25,583

25,185

24,184

24,769

23,240

21,583

19,987

19,714

19,280

19,000

16,972

14,792

12,795

11,001

10,163

8,925

0

0

0

Depreciation and amortization

297,897

304,596

306,245

307,043

305,725

301,071

285,741

269,096

252,327

221,321

164,190

109,387

56,345

21,505

20,542

18,468

16,265

13,698

12,088

11,572

11,542

11,137

10,333

9,607

8,472

7,704

7,304

6,847

6,421

6,100

5,573

5,177

4,780

4,403

0

0

0

Gain on disposition of assets, excluding transaction costs

-

-

-

-

-

36,281

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of premium on investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-446

-448

-398

-328

-285

-239

-228

-224

-237

-243

-247

-198

-161

-108

-57

-54

-46

-61

-85

-134

0

0

0

Change in fair value of contingent consideration liability

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

273

253

234

187

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for bad debts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

40

49

61

61

102

108

87

102

96

107

122

116

94

86

105

100

117

110

93

85

0

0

0

Benefit from deferred income taxes

-33,828

-35,698

-57,495

-58,212

-59,754

-57,456

-143,234

-146,384

-149,728

-156,831

0

0

0

-

-

-

-

-

-

-

-

-2,707

1,238

996

1,135

926

1,155

-633

-1,782

-831

-76

2,457

4,813

3,793

0

0

0

Excess tax benefits realized from stock-based awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

Other, net

-1,960

-1,776

-1,763

-1,917

-1,644

-1,771

-1,942

-1,685

-2,491

-2,266

-2,879

-2,652

-1,526

-1,275

25

-2

29

12

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(Gain) loss on disposal of equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

0

0

-

-

0

0

-

0

0

0

Changes in assets and liabilities, excluding effect of acquisitions:
Accounts receivable

20,531

13,521

-4,058

10,869

-3,955

-7,751

-6,163

-6,115

9,925

16,618

16,615

11,779

8,140

10,214

-214

-292

1,754

-2,224

5,697

4,885

2,292

5,804

-285

724

-548

-302

824

1,311

5,225

4,471

4,253

1,006

917

4,088

0

0

0

Prepaid expenses and other current assets

32,428

12,998

27,560

16,849

15,555

13,671

9,738

2,278

11,154

22,819

-2,941

4,284

-3,196

-5,996

1,473

2,609

-1,799

2,794

-378

-340

5,953

-1,822

-592

607

1,049

2,986

5,185

3,944

3,513

1,070

689

514

380

-494

0

0

0

Other assets

24,735

27,147

24,153

22,208

20,503

16,596

12,252

6,521

1,286

-1,569

-1,293

-697

-1,663

-1,490

-1,016

-288

733

454

117

-473

-580

-476

1,383

1,760

1,792

3,764

3,376

3,113

3,037

1,308

-12

40

332

215

0

0

0

Accounts payable

-485

17,464

18,980

15,108

10,802

11,104

-1,583

-4,695

755

-5,004

11,598

14,820

8,324

6,149

3,104

-438

-711

1,420

4,164

5,675

6,578

1,727

532

609

-2,113

-2,233

-638

14

2,171

1,552

2,240

2,270

-595

3,787

0

0

0

Accrued liabilities

22,137

37,884

29,844

20,076

26,349

26,811

-119

271

-5,370

15,354

40,763

46,055

51,387

8,353

9,286

6,402

-4,104

2,288

2,805

6,789

17,405

9,234

5,972

133

-6,167

3,457

2,628

5,615

10,674

5,854

3,323

2,585

1,002

-531

0

0

0

Deferred revenue

53,753

29,047

25,049

29,882

20,551

35,416

45,932

69,068

87,392

93,036

76,668

60,632

44,938

26,953

19,444

20,606

27,734

28,874

38,088

34,930

32,109

23,983

24,615

29,835

29,438

14,493

14,977

14,873

12,922

10,960

10,874

11,269

13,147

15,471

0

0

0

Other long-term liabilities

8,210

1,782

-3,627

-4,256

-3,917

4,014

18,069

21,097

18,216

17,108

-2,036

-1,896

-1,368

-409

6,464

5,253

4,756

2,698

1,649

1,781

1,269

1,597

1,143

687

314

-208

-45

-1,645

-1,292

-418

-112

1,885

1,464

739

0

0

0

Net cash provided by (used in) operating activities

329,198

360,849

359,543

350,204

369,716

404,039

363,801

380,614

364,300

316,197

291,485

221,106

160,185

92,315

97,846

91,199

83,792

85,770

87,281

87,316

89,758

74,153

71,095

62,511

48,278

30,020

23,881

25,021

26,508

28,257

31,016

35,194

32,340

32,871

0

0

0

Cash flows from investing activities
Purchases of marketable securities

-

-

-

-

-

-

-

-

-

-

-

-

-

35,609

70,774

66,738

86,123

92,335

102,539

132,528

110,353

95,342

74,969

49,979

44,983

90,376

80,366

120,479

130,471

135,085

135,097

139,979

174,981

150,066

0

0

0

Proceeds from sale or disposal or maturity of marketable securities

-

-

-

-

-

-

-

-

-

55,598

56,359

64,609

77,259

64,756

85,000

81,292

100,792

107,042

117,087

132,045

110,045

95,045

75,000

50,000

45,000

90,000

80,000

120,000

130,000

130,000

125,000

130,000

165,000

145,000

0

0

0

Purchases of property and equipment

31,652

35,438

39,188

39,417

35,903

30,965

34,903

40,460

40,190

36,635

24,708

15,007

13,333

14,015

15,926

16,462

14,694

14,219

12,696

9,692

9,592

7,471

6,976

8,830

10,563

10,938

10,749

9,448

6,092

5,277

4,256

2,512

2,543

2,322

0

0

0

Intangible asset additions

41,193

39,789

37,502

35,102

36,038

34,219

33,951

33,859

30,771

29,706

22,415

14,553

7,198

1,559

977

1,206

1,749

2,375

3,197

3,091

3,041

2,529

13,709

13,468

13,026

13,061

1,378

1,397

1,481

1,049

889

774

392

346

0

0

0

Cash paid for acquisitions, net of cash acquired

-

22,463

0

0

0

-

-

-

-

22,348

25,182

-18,193

-18,193

6,083

0

0

0

-

-

-

-

22,449

0

0

0

-

-

-

-

14,831

0

0

0

-

-

-

-

Restricted cash acquired through acquisitions

-

-

-

-

-

-

-

-

-

1,181

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from disposition of assets

-

-

-

-

-

42,394

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by (used in) investing activities

-65,345

-90,190

-91,653

-95,703

-436,476

-364,862

-357,532

-397,080

-45,521

-31,910

-14,928

50,154

54,139

7,490

-110,343

-109,242

-107,998

-107,974

146

-28,328

-28,202

-32,942

-43,420

-30,029

-30,999

-24,368

-12,369

-11,199

-11,602

-29,800

-33,633

-41,656

-37,749

-17,760

0

0

0

Cash flows from financing activities
Decrease (increase) in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

30

-1,508

-1,412

-1,488

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

26

0

0

0

Repayments under credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

30,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of common stock upon option exercises

0

-

0

0

0

-

0

0

2,089

-

8,673

11,703

15,113

11,753

11,986

10,914

10,069

17,794

19,859

19,573

20,672

17,595

14,255

13,837

9,497

3,798

2,616

936

2,281

2,682

5,570

5,787

5,564

6,207

0

0

0

Excess tax benefits realized from stock-based awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

17

2,632

4,084

5,658

6,634

0

0

0

-

-

-

-

Payments of withholding taxes in connection with restricted stock unit vesting

14,262

20,114

19,595

20,339

29,176

30,617

31,775

32,973

36,083

34,474

33,202

35,283

19,951

14,445

13,925

13,373

12,114

11,641

11,624

9,094

6,507

5,766

5,578

4,474

2,499

1,834

0

0

0

-

-

-

-

-

-

-

-

Payment of debt issuance costs

-

-

-

-

-

-

-

-

-

2,032

1,990

1,990

1,874

346

360

563

577

988

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment of contingent consideration

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

226

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividends paid on common stock

-

64,600

64,036

63,522

62,962

62,200

60,083

57,741

55,258

52,300

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase of treasury stock

-

208,504

226,102

256,273

254,310

247,144

208,384

154,717

108,665

69,229

53,657

35,659

24,479

25,381

26,157

22,695

21,393

18,090

25,190

44,283

36,655

36,500

36,275

22,867

26,454

30,525

0

0

0

-

-

-

-

-

-

-

-

Net cash provided by (used in) financing activities

-214,642

-289,828

-311,459

-339,102

-142,658

-136,132

-96,271

-43,260

-228,125

-181,493

-165,093

-153,194

-87,500

-79,448

-1,158

22,026

31,228

49,592

-17,565

-34,421

-23,009

-24,288

-28,218

-13,593

-19,568

-28,648

-16,692

-10,592

-1,365

9,227

12,346

12,198

12,452

12,094

0

0

0

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

-4,713

-1,435

-4,851

-2,664

-10,804

-6,762

-4,477

-2,371

8,186

8,080

3,398

2,342

-2,241

-2,633

-157

-243

2,009

-5,205

-5,791

-9,253

-10,123

-5,220

-2,100

861

1,278

321

-839

-595

-1,166

644

-120

-1,296

-751

-881

0

0

0

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

44,498

-20,604

-48,420

-87,265

-220,222

-103,717

-94,479

-62,097

98,840

110,874

114,862

120,408

124,583

17,724

-13,812

3,740

9,031

22,183

64,071

15,314

28,424

11,703

-2,643

19,750

-1,011

-22,675

-6,019

2,634

12,373

8,328

9,608

4,440

6,291

26,324

0

0

0

Supplemental disclosure of cash flow information
Cash paid for interest

7,117

6,318

0

0

0

-

-

-

-

201

375

591

743

937

1,335

1,119

872

574

2

2

2

2

0

0

0

-

-

-

-

-

0

0

1

1

0

0

0

Cash paid (refunds received) from income taxes

38,355

18,585

37,844

38,751

43,193

48,244

52,148

56,602

59,425

55,730

0

0

0

-

-

-

0

-

-

2,015

2,385

1,489

2,575

4,375

6,153

10,094

9,427

7,708

5,799

1,802

823

561

395

356

0

0

0

Noncash investing and financing activities
Debt issuance costs included in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchase consideration of the GoTo Business paid in equity

-

-

-

-

-

-

-

-

-

2,921,179

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of property and equipment through capital lease

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of property and equipment included in accounts payable and accrued liabilities

8,152

7,949

8,243

9,876

14,156

9,109

2,020

3,922

4,011

3,522

7,139

2,296

678

1,023

1,766

5,143

4,458

3,145

2,275

1,566

883

1,032

1,953

682

1,275

1,510

409

1,385

1,597

742

1,445

1,300

981

671

0

0

0

Withholding taxes in connection with restricted stock unit vesting in accrued liabilities

-

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of treasury stock included in accrued liabilities

-

-

756

780

5,206

1,789

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of intangible assets included in accrued liabilities

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Fair value of contingent consideration in connection with acquisition, included in accrued liabilities

-

2,000

0

0

0

-

-

-

-

-

-

-

-

-

4,501

4,532

4,363

2,028

0

0

0

-

-

-

-

-

-

102

106

161

0

0

0

-

-

-

-

Lease assets obtained (relieved) and related operating lease liabilities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-