Lpl financial holdings inc. (LPLA)
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

560,123

559,880

553,502

528,653

501,327

439,459

383,259

334,536

284,204

238,863

216,501

210,313

189,728

191,931

177,007

166,105

168,498

168,784

190,517

182,737

175,586

178,043

173,916

178,275

180,275

181,857

174,377

171,045

165,456

151,918

154,428

156,557

162,562

170,382

0

0

0

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

98,953

95,779

92,013

90,789

90,425

87,656

85,897

85,055

84,025

84,071

83,716

80,154

77,713

75,928

78,672

77,469

75,916

73,383

38,215

45,503

52,125

57,977

53,664

50,577

47,004

44,497

80,237

77,228

74,395

71,796

69,957

70,756

71,751

72,741

0

0

0

Amortization of intangible assets

65,702

65,300

64,400

63,813

63,246

60,300

54,604

48,260

42,031

38,300

37,760

37,910

37,966

38,000

38,067

38,100

38,127

38,239

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt issuance costs

4,994

4,672

4,400

4,207

4,106

4,118

4,122

3,951

4,056

4,304

4,706

5,285

5,596

5,752

5,525

4,820

4,114

3,405

2,930

3,279

3,626

3,973

4,321

4,306

4,324

4,365

4,406

4,461

4,484

4,591

4,743

4,894

5,046

5,091

0

0

0

Share-based compensation

33,232

32,864

30,625

29,993

30,529

29,162

30,161

30,928

29,148

28,522

29,906

28,604

26,847

24,896

23,511

23,480

27,040

29,213

27,507

27,820

26,485

27,579

29,991

27,588

27,158

24,672

22,001

21,743

20,427

21,122

22,171

21,123

19,898

18,250

0

0

0

Excess tax benefits related to share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

65

1,410

1,965

2,663

3,810

3,439

3,698

5,397

8,685

12,919

11,801

9,982

7,172

5,462

7,105

17,266

53,296

50,066

50,147

59,287

57,590

0

0

0

Provision for bad debts

6,140

6,698

6,501

6,378

7,654

6,113

5,131

3,723

3,664

2,789

4,165

4,228

4,014

4,057

3,795

3,435

2,949

2,542

1,940

2,841

2,571

2,432

2,234

2,306

2,725

2,021

1,849

1,246

659

1,159

3,943

3,522

3,638

3,833

0

0

0

Deferred income tax provision

-18,694

-18,615

-1,175

-1,617

-1,639

-1,754

-9,810

-9,477

-9,502

-9,391

-11,424

-11,460

-11,490

-11,550

-28,993

-29,129

-28,427

-30,153

-26,039

-26,049

-25,900

-24,100

-18,508

-16,569

-20,559

-28,943

-9,772

-17,560

-8,301

-12,219

-14,776

-8,721

-15,225

-8,432

0

0

0

Loss on extinguishment of debt

-

-

-

-

-

-

-

-

-

-22,407

-22,407

-21,139

-21,139

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

16,524

-16,524

-16,524

-16,524

0

0

0

0

Net changes in estimated fair value of contingent consideration obligations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

12,676

-2,660

9,441

9,841

11,353

0

0

0

-

-

-

-

Lease abandonment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

Loan forgiveness

95,409

92,502

88,131

82,348

78,457

71,520

64,642

59,833

56,553

53,660

52,230

50,262

47,569

45,163

42,835

41,218

39,700

37,658

35,552

33,363

30,502

28,409

40,331

33,289

27,108

21,006

0

0

0

-

-

-

-

1,530

0

0

0

Other

11,567

11,421

510

-3,270

-3,641

-5,447

-3,246

4,782

6,192

8,295

11,163

5,271

2,827

2,810

3,412

1,650

1,877

-1,304

1,551

18

-1,625

-594

-4,206

-2,275

-1,567

-1,598

605

479

-342

-455

-1,035

-2,371

-1,955

-1,511

0

0

0

Changes in operating assets and liabilities:
Cash and securities segregated under federal and other regulations

-

-

-

-

-

-

-

-

-

-

-

-

-

-

126,392

247,504

170,108

102,409

52,215

-8,350

55,038

56,579

-9,536

-31,893

61,379

-65,082

34,460

118,181

59,489

194,528

125,738

96,049

60,718

9,271

0

0

0

Deposit of restricted cash related to captive insurance subsidiary

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

21,516

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Decrease in Restricted Cash Operating Activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,546

8,626

7,263

6,550

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Receivables from clients

-32,787

20,602

-16,049

100,799

9,051

68,888

43,614

66,382

87,876

1,916

97,962

-12,751

407

2,226

-51,509

-24,708

-29,269

-26,081

2,147

-21,717

-15,258

-7,628

1,586

48,307

-1,014

3,862

14,290

13,082

52,902

68,393

44,657

4,762

-7,447

30,302

0

0

0

Receivables from product sponsors, broker-dealers and clearing organizations

58,094

7,180

-46,417

-11,773

-59,818

-29,414

34,311

21,410

53,014

21,085

2,835

-32,662

-4,321

13,899

22,435

35,316

-4,673

-16,247

-24,133

-9,308

26,593

3,400

25,857

3,280

-35,535

21,120

17,140

38,412

20,632

9,457

-30,018

-28,696

-14,401

-59,839

0

0

0

Advisor loans

238,094

235,499

227,365

209,169

168,620

152,227

140,633

94,073

90,123

79,703

60,597

80,057

95,178

91,866

77,271

71,662

57,247

66,312

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Receivables from others

85,659

52,365

33,088

23,887

26,387

20,894

24,892

27,311

47,159

32,618

16,226

26,656

12,395

12,466

14,967

8,500

1,981

10,514

-20,836

-9,279

-7,522

469

60,766

53,689

36,228

44,043

45,354

50,445

74,233

53,124

23,883

14,680

14,134

22,549

0

0

0

Securities owned

4,041

16,848

1,097

5,470

11,685

13,741

19,375

10,451

3,011

5,276

1,198

3,092

1,347

-835

-4,593

-368

-3,294

-144

4,402

1,469

3,920

4,638

3,774

1,988

5,466

1,148

2,061

1,836

568

1,321

-1,291

-2,815

-3,089

-3,158

0

0

0

Securities borrowed

13,257

12,855

3,957

2,255

-3,993

-7,660

-10,381

-12,628

-11,540

6,930

6,208

3,476

10,738

-442

3,959

8,540

-428

966

-1,839

-3,947

-371

-2,067

-2,289

1,994

506

-2,346

577

-2,572

-4,219

1,558

-408

-1,422

178

-501

0

0

0

Operating leases

1,563

1,446

942

548

254

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other assets

83,376

62,670

66,846

67,969

50,717

51,708

47,545

38,398

48,835

23,156

25,365

31,585

24,753

30,013

32,514

25,687

38,656

30,714

33,532

36,074

21,691

45,523

28,617

33,210

35,462

19,458

14,016

23,102

49,518

52,216

44,231

31,624

20,786

7,806

0

0

0

Drafts payable

-36,284

-6,398

-53,920

30,179

49,180

39,105

41,977

4,081

-20,290

-12,910

-8,077

-7,416

-25,233

9,757

17,137

23,939

12,248

8,984

9,212

-18,585

-10,436

-14,872

-43,056

-3,349

43,027

-8,161

12,140

5,583

-19,729

15,557

28,717

12,143

-8,161

5,086

0

0

0

Payables to clients

549,980

107,927

314,777

1,984

-138,604

-11,945

37,548

-19,084

146,930

99,126

51,961

8,335

-18,967

116,344

156,749

151,122

159,607

94,707

-6,681

70,198

65,287

87,510

27,138

59,767

-18,042

-184,301

132,061

82,938

170,684

292,786

27,280

-9,948

-5,559

73,430

0

0

0

Payables to broker-dealers and clearing organizations

-16,515

15,822

30,981

-5,411

72,220

21,918

1,121

10,407

5,015

-8,770

1,349

-6,512

18,729

15,000

8,359

20,229

-6,247

2,605

5,216

7,118

14,034

2,270

15,272

8,450

-23,547

-9,874

-14,756

-12,269

24,853

18,276

-12,225

-1,486

-33,285

-4,315

0

0

0

Accrued commission and advisory expenses payable

-1,137

8,462

-7,729

-5,842

3,699

17,116

35,044

29,736

29,599

18,619

3,883

2,860

1,947

-1,036

-3,433

-8,421

-15,289

-16,992

-10,342

-1,863

9,644

11,355

14,423

5,832

319

6,690

20,877

32,427

19,118

18,744

-1,592

-13,368

-6,602

-20,693

0

0

0

Accounts payable and accrued liabilities

86,429

87,210

57,197

39,338

24,182

43,987

68,553

63,696

78,978

66,404

30,656

24,555

30,795

33,512

38,352

39,610

29,568

50,077

35,291

48,904

51,067

-8,109

22,850

9,002

8,160

48,127

30,803

26,965

38,774

20,743

7,817

2,586

-23,493

-21,016

0

0

0

Income taxes receivable/payable

-9,458

-12,861

-15,384

-6,243

51,315

32,521

11,090

1,527

-4,396

-4,138

13,789

9,117

-8,101

-4,008

16,476

20,194

13,333

12,574

11,602

15,285

5,940

4,281

-5,375

-13,860

130

14,916

-2,051

16,939

50,182

47,175

56,637

61,301

156,613

202,537

0

0

0

Unearned revenue

10,385

2,318

2,457

3,576

2,625

8,302

8,995

10,370

16,998

9,437

592

2,084

2,686

-2,695

1,112

-4,442

-3,536

998

3,030

11,991

945

-9,257

5,343

5,500

10,807

11,931

6,602

6,722

2,959

2,271

423

-5,300

5,123

5,919

0

0

0

Securities sold, but not yet purchased

229

7

-126

4

-268

-1,013

197

-21

144

999

49

-32

-89

-85

-141

-1,605

201

-35

208

1,655

-459

91

-300

-152

371

-155

-59,779

232

-177

205

0

0

0

-

-

-

0

Net cash provided by operating activities

969,814

623,871

895,286

467,047

639,144

581,580

525,761

408,603

423,748

453,306

250,456

339,127

277,195

388,933

333,069

183,058

268,681

279,451

216,458

366,791

276,190

232,242

242,461

280,942

238,622

160,117

294,748

193,811

289,617

254,268

180,059

148,775

224,854

442,378

0

0

0

CASH FLOWS FROM INVESTING ACTIVITIES:
Capital expenditures

160,030

156,389

151,740

147,410

140,086

132,688

111,511

101,794

104,133

111,910

115,795

130,002

138,248

127,646

118,460

97,231

78,756

72,565

71,371

75,601

80,554

89,648

107,282

92,001

87,513

78,239

63,039

68,154

64,254

54,786

44,542

42,640

37,325

36,347

0

0

0

Deposits of restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,679

0

0

0

-

-

-

-

-

-

-

-

7,794

0

0

0

Release of restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

943

1,444

1,997

609

5,788

5,291

4,745

4,820

343

953

947

815

1,363

750

7,050

7,550

10,122

10,499

5,739

22,245

0

0

0

Payments to Acquire Businesses, Net of Cash Acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

41,977

0

0

0

Proceeds from disposal of fixed assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,123

7,123

1,059

1,000

0

0

0

0

-

-

-

-

-

-

-

-

Purchase of securities classified as held-to-maturity

6,300

3,745

4,977

3,708

7,375

6,137

0

0

0

-

-

-

-

-

-

-

-

4,602

5,351

9,004

9,004

7,498

6,849

100

100

2,595

6,791

7,690

9,705

7,210

5,965

5,918

4,918

7,685

0

0

0

Proceeds from maturity of securities classified as held-to-maturity

5,000

5,000

5,000

5,000

5,000

5,000

3,750

3,750

2,500

3,000

4,000

3,750

4,750

5,000

5,000

4,850

4,600

3,350

3,850

3,750

4,500

5,750

4,250

5,400

6,900

5,900

7,650

9,100

7,100

8,100

8,350

7,350

7,350

6,000

0

0

0

Purchases of minority interest investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2,500

2,500

2,575

2,575

1,575

0

0

0

-

-

-

-

Net cash used in investing activities

-187,183

-180,987

-204,529

-174,046

-170,389

-161,753

-110,487

-425,780

-430,411

-437,688

-444,195

-132,405

-138,963

-126,666

-117,777

-99,793

-76,995

-74,948

-66,214

-83,179

-87,869

-93,132

-114,154

-82,879

-78,456

-74,809

-64,814

-65,087

-106,132

-91,669

-86,908

-88,986

-61,751

-65,558

0

0

0

CASH FLOWS FROM FINANCING ACTIVITIES:
Proceeds from revolving credit facility

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

456,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of revolving credit facility

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

566,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net proceeds from revolving credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Repayment of senior secured term loans

410,175

411,250

15,000

15,000

15,000

15,000

15,000

211,250

211,750

2,405,360

2,406,030

2,210,449

2,210,618

17,677

14,349

12,639

10,930

9,221

10,838

10,839

10,839

10,838

10,839

10,838

858,563

866,579

874,594

882,610

42,900

1,364,843

1,357,611

1,350,378

1,343,146

53,971

0

0

0

Payment for Contingent Consideration Liability, Financing Activities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from senior secured term loans and senior notes

-

-

-

-

-

-

-

-

-

2,611,593

2,611,594

2,197,360

2,197,360

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

1,330,681

1,330,681

1,330,681

1,330,681

0

0

0

0

Payments of debt issuance costs

-

-

-

-

-

-

-

-

-

23,798

22,676

16,548

13,936

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

4,431

4,431

4,431

4,431

0

0

0

0

Payment of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-3,300

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Tax payments related to settlement of restricted stock units

9,805

5,863

5,672

5,655

5,673

4,843

4,842

4,515

4,532

3,461

3,298

3,100

3,037

1,241

1,249

2,052

1,997

3,018

3,062

2,117

2,036

868

673

599

584

0

0

0

0

-

-

-

-

-

-

-

-

Payment of contingent consideration obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

-

-

-

-

-

-

-

Repurchase of common stock

525,372

500,370

498,142

498,352

489,131

417,891

330,098

224,624

149,232

113,728

83,721

58,710

18,290

25,013

275,013

300,024

385,834

390,835

265,893

265,893

205,093

275,079

193,390

293,126

314,170

219,091

267,319

194,202

166,556

199,121

107,524

77,955

126,523

89,037

0

0

0

Dividends on common stock

81,231

82,597

83,904

85,360

86,878

88,360

89,355

89,931

90,214

90,273

90,073

89,825

89,458

89,081

90,531

92,044

93,901

95,814

95,568

95,781

95,675

95,616

91,440

87,354

77,731

68,008

61,682

55,015

263,183

248,809

0

0

0

-

-

-

-

Excess tax benefits related to share-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

65

1,410

1,965

2,663

3,810

3,439

3,698

5,397

8,685

12,919

11,801

9,982

7,172

5,462

7,105

17,266

53,296

50,066

50,147

59,287

57,590

0

0

0

Proceeds from stock option exercises and other

32,033

40,162

38,350

35,415

38,300

51,538

49,777

75,207

72,198

84,405

81,845

53,588

47,451

6,865

12,026

15,233

29,245

33,030

27,096

25,940

19,190

28,530

32,170

39,058

41,977

35,025

31,472

23,317

19,102

16,117

14,249

14,289

13,263

10,162

0

0

0

Principal payment of finance leases and obligations

842

692

6,994

7,606

8,211

8,807

9,073

9,012

8,952

7,949

2,621

2,169

1,723

1,284

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in financing activities

-507,007

-533,225

-575,502

-579,218

-566,593

-483,363

-399,714

-57,142

11,889

51,429

85,065

-129,798

-92,195

-127,366

162,036

115,181

98,988

107,694

-199,702

-174,868

-173,932

-243,362

-254,553

-344,358

-125,893

-34,985

-90,165

-24,909

-436,271

-417,110

-310,369

-260,204

-70,869

-75,256

0

0

0

NET INCREASE (DECREASE) IN CASH, CASH EQUIVALENTS AND RESTRICTED CASH

275,624

-90,341

115,255

-286,217

-97,838

-63,536

15,560

-74,319

5,226

67,047

-108,674

76,924

46,037

134,901

377,328

198,446

290,674

312,197

-49,458

108,744

14,389

-104,252

-126,246

-146,295

34,273

50,323

139,769

103,815

-252,786

-254,511

-217,218

-200,415

92,234

301,564

0

0

0

SUPPLEMENTAL DISCLOSURES OF CASH FLOW INFORMATION:
Interest Paid, Excluding Capitalized Interest, Operating Activities

119,235

126,949

130,466

129,726

127,508

123,623

120,454

110,087

110,584

92,650

100,427

88,626

92,108

92,344

81,775

72,005

66,912

51,114

51,220

51,072

46,716

51,588

52,156

52,906

52,743

51,712

51,028

50,092

50,926

54,883

57,976

61,877

66,464

68,669

0

0

0

Income taxes paid

213,632

213,339

202,264

187,867

125,286

122,215

125,297

132,563

138,880

139,200

131,069

113,636

118,863

122,909

113,931

121,930

130,314

131,833

142,409

132,742

139,233

139,315

132,389

140,972

128,567

123,583

126,288

110,961

65,992

62,260

53,243

48,546

60,987

60,651

0

0

0

NONCASH DISCLOSURES:
Capital expenditures included in accounts payable and accrued liabilities

15,788

13,736

8,400

7,078

21,748

20,634

30,719

32,662

14,001

16,096

15,688

20,469

29,486

24,339

24,550

19,674

13,740

11,462

9,565

2,362

5,193

8,184

0

0

0

-

-

-

-

-

-

-

-

-

0

0

0

Right-of-Use Asset Obtained in Exchange for Operating Lease Liability

3,787

108,879

108,539

108,539

108,539

0

0

0

0

-

-

-

-

45,998

62,756

65,248

74,761

59,940

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Fixed assets acquired under built-to-suit lease

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

8,114

22,005

31,093

31,093

22,979

0

0

0

-

-

-

-

-

-

-

-

Debt issuance cost included in accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

0

-

0

0

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on interest rate swaps, net of tax expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

-

0

0

0

Discount on proceeds from senior secured credit facilities recorded as debt issuance costs

-

-

-

-

-

-

-

-

-

5,040

5,040

2,640

2,640

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

19,319

19,319

19,319

19,319

0

0

0

0

Pending settlement of treasury stock purchases

-

-

-

-

-

-

-

0

0

-

-

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-