Jones lang lasalle incorporated (JLL)
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'11Dec'10Sep'10Jun'10Mar'10
Cash flows used for operating activities:
Net income

17,600

276,100

129,300

111,300

21,200

203,200

136,100

109,800

42,600

77,700

99,200

94,900

7,700

178,100

48,200

94,400

25,200

198,400

113,200

91,400

43,300

194,756

104,737

72,362

16,145

147,523

63,116

49,451

13,262

107,262

49,682

37,730

14,169

85,025

33,900

45,088

1,599

84,744

37,230

32,051

414

Adjustments to reconcile net income to net cash used in operating activities:
Depreciation and amortization

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

27,186

22,023

22,780

22,411

20,857

19,742

20,175

19,079

20,100

19,089

19,962

19,659

22,332

22,835

19,350

18,315

18,584

17,743

17,533

17,713

Equity in earnings from real estate ventures

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,355

19,552

12,490

8,903

10,211

6,574

9,076

5,482

1,357

10,698

-46

11,848

3,703

514

4,139

-1,971

-22,316

19,861

-2,797

-6,127

(Gain) loss on sale of assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-3,161

61

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions of earnings from real estate ventures

3,600

9,000

5,900

3,100

3,000

29,300

11,100

6,500

12,600

6,100

7,100

5,300

11,800

6,500

6,400

11,600

6,400

10,000

30,900

8,600

1,700

3,717

6,156

9,138

489

2,907

4,553

2,560

3,652

2,645

6,423

261

1,312

38

517

38

0

0

38

75

75

Provision for loss on receivables and other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-2,415

4,236

1,076

5,303

-3,090

960

5,771

5,074

-3,966

-823

6,382

4,993

816

-78

5,281

4,254

-1,940

879

6,081

2,061

Amortization of deferred compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

4,280

4,745

4,942

6,233

4,555

5,073

5,542

7,533

6,095

6,143

6,676

13,362

9,853

5,897

8,219

10,033

14,115

7,400

8,058

11,657

Accretion of interest and amortization of debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,057

1,148

1,561

1,134

2,187

1,819

1,946

1,885

6,258

3,845

3,830

3,811

4,289

4,712

5,462

5,040

6,455

5,732

6,161

6,060

Other adjustments, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

37,900

-

12,800

8,700

29,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other adjustment, net

132,200

-183,800

61,300

70,400

37,500

-131,400

53,600

31,000

29,700

-143,100

33,800

37,000

51,600

-91,300

51,200

466,500

-406,400

360,200

39,800

12,200

-409,800

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in working capital, net

699,500

-

-35,100

116,400

613,200

-

-66,800

156,600

343,500

-

-176,200

-35,800

282,700

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

893

920

907

907

1,177

1,176

1,177

1,142

1,078

1,077

1,078

1,077

1,078

1,114

1,115

1,115

1,544

1,544

1,544

Change in:
Receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

175,130

118,854

55,684

-85,668

205,679

88,994

20,342

-47,465

138,795

21,873

34,812

-104,985

174,292

7,772

10,756

-2,200

30,144

32,460

43,610

-51,970

Prepaid expenses and other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-13,600

31,174

6,572

24,654

-4,326

24,703

8,764

15,873

-8,372

11,389

3,522

27,447

-9,074

5,133

3,933

-3,312

46,667

-36,319

13,526

994

Deferred tax assets, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

28,823

-10,839

-16,101

-21,683

-3,562

-16,841

-158

-7,497

18,732

-12,166

-2,091

8,125

38,676

-13,689

-3,743

-11,974

-21,932

23,992

-2,223

-5,294

Excess tax benefit from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,802

1,617

1,942

158

2,873

274

274

-115

254

2,223

961

475

12,492

-76

5,108

11,384

-6,290

128

582

Accounts payable and accrued liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

415,769

210,030

63,694

-387,693

427,033

154,479

11,588

-386,451

302,472

103,517

36,006

-311,110

337,155

38,498

-8,676

-251,884

244,835

103,701

46,710

-247,671

Net cash used in operating activities

-546,100

735,300

231,600

68,400

-551,500

604,400

267,600

-9,300

-258,600

521,000

316,300

173,000

-211,600

374,500

130,900

54,100

-336,900

394,000

196,700

120,900

-335,800

456,544

189,364

116,211

-263,219

395,108

144,685

56,898

-301,456

291,611

156,906

73,504

-196,122

252,513

95,137

60,867

-197,179

276,198

188,435

65,969

-146,332

Cash flows used in investing activities:
Net capital additions - property and equipment

44,400

56,700

47,300

39,200

44,600

51,800

39,100

29,400

41,600

53,300

34,900

31,600

31,600

76,800

59,600

46,500

33,300

60,200

42,200

26,200

19,200

29,010

36,046

34,380

33,264

55,489

24,983

17,524

12,688

39,921

22,351

20,660

11,826

35,636

19,707

19,025

17,170

-

-

-

-

Net investment activity (less than wholly-owned)

3,200

-

-

-

15,600

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Acquisition of investment properties (less than wholly-owned)

-

-

-

-

-

-

0

-7,100

17,700

-

0

0

0

36,100

29,300

0

34,400

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,139

9,180

4,478

Proceeds from Sales of Assets

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-140

1,340

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Business acquisitions, net of cash acquired

0

12,100

760,900

1,600

26,700

69,600

20,500

2,500

8,700

0

200

1,900

16,600

65,300

325,600

16,500

76,500

288,700

61,200

38,000

3,700

14,039

3,997

10,991

9,173

3,012

9,219

43,997

1,316

1,516

11,810

9,432

4,948

17,786

11,474

210,152

12,375

12,404

1,627

1,282

8,937

Payments to Acquire Interest in Joint Venture

54,000

72,100

30,000

24,600

11,000

20,500

17,700

11,900

8,700

13,100

5,200

12,300

9,500

-

-

-

60,300

6,800

8,500

13,100

19,200

22,183

15,632

14,440

4,145

2,848

20,507

1,740

12,122

11,156

83,578

4,706

6,882

5,343

53,727

4,092

7,865

5,165

14,743

3,408

10,537

Proceeds from Real Estate and Real Estate Joint Ventures

13,400

89,400

4,600

12,200

7,600

11,500

12,900

11,400

16,100

19,800

3,000

11,700

10,200

-

-

-

22,800

8,300

20,600

6,100

14,200

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from Sale, Maturity and Collection of Investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

26,697

15,243

7,285

6,933

3,271

12,076

5,349

36,898

8,080

25,049

7,507

5,612

6,672

6,929

5,823

10,842

1,279

2,547

168

Other, net

2,300

-7,500

-29,600

-6,100

700

-900

-900

-1,600

-600

-100

800

100

2,200

41,000

2,300

-44,400

2,600

-

0

100

-6,900

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-90,500

-55,600

-852,400

-50,700

-91,000

-133,200

-63,500

-23,700

-60,000

-48,800

-38,100

-34,200

-49,700

-188,100

-418,300

-14,800

-184,300

-400,100

-92,200

-71,300

-21,000

-76,397

-27,638

-44,568

-39,297

-52,053

-49,398

-41,984

-20,777

-15,695

-109,659

-9,749

-16,149

-53,153

-78,236

-226,340

-31,587

-31,539

-24,230

-11,323

-23,784

Cash flows provided by financing activities:
Proceeds from borrowings under credit facility

2,555,000

1,159,000

2,160,000

1,266,000

1,279,000

634,000

731,000

855,000

925,000

594,000

622,000

699,000

1,157,000

615,000

837,000

629,000

1,064,000

784,000

434,000

324,000

631,000

350,000

307,000

397,000

610,000

339,045

436,755

542,926

639,065

317,458

377,677

407,507

587,500

285,837

413,651

660,785

190,317

198,015

198,948

268,569

495,270

Repayments of borrowings under credit facility

1,630,000

1,759,000

1,534,900

1,291,000

754,100

874,000

906,000

765,000

600,000

1,044,000

847,000

1,199,000

907,000

776,000

562,000

573,200

544,800

745,500

518,500

330,300

294,900

624,229

448,617

425,251

329,703

640,000

486,000

521,000

332,500

719,000

413,500

429,508

454,992

378,600

282,000

492,100

96,000

254,000

248,499

318,501

312,000

Proceeds from Short-term debt.

6,600

-

-

-

86,300

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for Contingent Consideration Liability, Financing Activities

9,800

37,500

13,200

2,100

24,500

9,300

21,500

15,500

10,800

5,800

18,000

13,100

10,100

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payment for deferred acquisition obligations and earn-out obligation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,000

28,500

2,100

3,000

7,300

37,600

3,900

1,678

1,190

35,080

1,352

1,990

38,244

30,452

1,796

112,069

0

31,699

0

1,577

150,037

0

12,602

4,353

78,193

5,657

17,595

Acquisition of redeemable noncontrolling interest

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

4,119

0

0

495

946

0

0

0

-

-

-

-

-

-

-

-

Shares repurchased for payment of employee taxes on stock awards

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

361

11,310

228

4,101

197

12,951

36

1,093

97

7,634

24

3,901

40

21,035

76

9,083

111

13,431

50

5,856

Excess tax adjustment from share-based payment arrangements

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

5,802

1,617

1,942

158

2,873

274

274

-115

254

2,223

961

475

12,492

-76

5,108

224

4,870

128

582

Common stock issued under compensation plans including tax benefit

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,876

376

1,715

133

193

136

837

89

215

387

3,008

95

59

238

833

80

327

211

696

172

Payments for Repurchase of Common Stock

25,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Capital lease payments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,013

1,106

1,069

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other loan proceeds, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

3,980

14,297

6,000

0

-5,060

0

-

-

-

-

-

-

-

-

-

-

-

-

Noncontrolling interest (distributions) contributions, net

-

-

-

-

-

-

-

-

-

-

-

-

-

3,600

2,700

-20,600

25,600

9,600

-4,300

-3,900

-2,900

1,980

3,469

5,951

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-13,500

1,400

52,600

2,000

6,100

8,900

-5,000

-30,600

27,600

26,100

-6,700

900

-23,000

41,200

40,100

-55,300

-2,400

-2,300

700

2,300

-15,900

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash provided by financing activities

883,300

-610,000

647,100

-45,300

592,800

-313,800

-210,700

41,400

341,800

-458,100

-249,700

-132,600

216,900

-142,900

301,800

-62,800

540,300

31,400

-95,400

-57,800

313,400

-285,769

-145,483

-61,895

290,147

-307,965

-97,434

-26,533

303,544

-251,286

-37,016

-50,102

129,663

-100,577

-26,845

160,137

77,820

-64,479

-147,482

-59,372

160,573

Effect of currency exchange rate on Cash and Cash Equivalents

-21,100

8,600

-11,300

1,200

700

1,000

-6,500

-16,400

2,000

1,900

2,400

4,900

4,100

-8,800

300

-3,200

4,700

-2,200

-6,600

700

-8,500

-6,520

-4,383

812

-209

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect

225,600

78,300

15,000

-26,400

-49,000

158,400

-13,100

-8,000

25,200

16,000

30,900

11,100

-40,300

34,700

14,700

-26,700

23,800

23,100

2,500

-7,500

-51,900

87,858

11,860

10,560

-12,578

33,022

-2,147

-11,619

-18,689

26,429

10,231

13,653

-82,608

98,783

-9,944

-5,336

-150,946

180,180

16,723

-4,726

-9,543

Supplemental disclosure of cash flow information:
Interest Paid, Excluding Capitalized Interest, Operating Activities

9,300

-

-

-

4,300

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash paid during the period for:
Interest

-

-

-

-

-

-

-

13,600

7,100

14,000

8,700

16,900

8,000

10,500

7,800

12,100

4,400

9,400

2,300

8,600

1,400

7,890

22,090

-8,750

-1,030

37,010

-3,730

-8,610

-1,820

-6,400

-2,900

-3,620

-2,560

-1,210

-3,460

-3,170

-2,100

3,010

5,270

5,130

3,840

Income taxes, net of refunds

44,400

62,000

98,600

82,700

37,500

45,400

57,400

16,500

34,100

32,100

42,200

39,600

30,800

31,800

36,700

43,800

31,300

58,000

26,900

35,800

34,900

23,335

113,636

-30,157

-18,314

147,247

-19,918

-24,278

-18,100

-25,899

-16,437

-16,242

-17,352

-11,754

-26,618

-14,589

-12,627

18,282

11,151

8,114

1,552

Operating Lease, Payments

47,100

43,500

44,400

42,200

41,100

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash activities
Business acquisitions, including contingent consideration

0

3,400

841,200

0

1,500

8,900

1,000

0

1,700

0

800

1,100

9,600

12,800

43,300

14,900

32,300

68,200

23,500

4,100

9,300

6,179

2,937

1,184

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Supplemental acquisition fees and costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-5,439

0

-1,059

136,928

0

-141,619

-1,907

-

-

-

-

Capital Leases

-

-

-

-

-

-

-

-

-

-

-

-

-

1,900

2,200

1,400

4,300

1,500

800

1,800

2,600

1,452

1,504

10,674

7,570

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Deferred business acquisition obligations

0

10,500

0

0

6,500

2,000

1,900

0

0

0

0

0

1,800

9,600

23,700

5,900

23,500

8,900

9,100

4,600

500

9,588

3,000

8,912

0

2,283

9,912

-12,059

13,059

32,450

2,541

0

1,290

134,799

11,699

2,032

991

-

-

-

-