Booking holdings inc. (BKNG)
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
OPERATING ACTIVITIES:
Net (loss) income

-699,000

1,171,000

1,950,000

979,000

765,000

646,000

1,767,000

978,000

607,000

-555,223

1,720,391

720,209

455,623

673,921

506,017

580,638

374,424

504,269

1,196,732

517,032

333,327

451,831

1,062,253

576,451

331,218

378,077

832,989

437,440

244,292

289,595

599,972

352,654

181,816

225,956

472,884

256,278

104,013

135,111

224,560

114,596

53,875

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

117,000

-

117,000

119,000

116,000

-

107,000

107,000

103,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Provision for expected credit losses and chargebacks

262,000

-

-

-

40,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation

-

-

-

-

-

-

-

-

-

-

50,613

44,711

40,412

38,047

36,796

34,671

30,486

27,997

26,825

25,021

21,674

23,537

21,815

17,337

15,552

14,400

12,897

11,266

9,802

9,497

8,171

7,465

7,685

5,847

5,576

5,059

4,166

4,141

4,199

3,900

3,969

Provision for uncollectible accounts and chargebacks

-

-

-

-

-

55,000

46,000

33,000

29,000

19,425

16,448

12,597

13,530

13,599

16,284

9,305

6,812

7,082

4,009

4,212

9,021

8,840

6,028

4,451

3,671

3,773

4,497

3,965

4,216

4,807

4,444

2,845

3,998

1,690

2,789

2,040

2,812

1,365

2,273

1,680

1,784

Amortization of Intangible Assets

-

-

-

-

-

-

-

-

-

-

45,297

41,161

43,018

41,625

41,949

43,041

42,385

42,767

42,229

42,653

43,328

48,021

35,784

22,950

22,824

22,721

22,850

14,761

9,278

8,131

7,837

8,198

8,157

7,890

8,381

8,592

8,313

10,062

10,596

7,787

5,810

Deferred income tax (benefit) expense

-97,000

83,000

-21,000

-29,000

89,000

-124,000

-5,000

-30,000

9,000

-6,345

15,284

-16,498

-24,441

-40,028

7,891

-54,182

-25,681

2,340

-22,098

-6,405

-35,172

-14,744

20,381

17,242

8,828

-22,554

14,762

3,917

-7,229

3,150

2,781

8,861

4,804

-

14,300

11,610

8,260

-

57,693

-12,617

-11,426

Equity Securities, FV-NI, Unrealized Gain (Loss)

-307,000

326,000

-49,000

17,000

451,000

-474,000

31,000

21,000

55,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net unrealized gains on marketable equity securities

-307,000

326,000

-49,000

17,000

451,000

-474,000

31,000

21,000

55,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Stock-based compensation expense and other stock-based payments

11,000

80,000

83,000

84,000

78,000

105,000

76,000

79,000

71,000

68,452

66,501

66,988

59,059

74,869

54,115

54,982

66,034

75,065

58,799

60,736

54,533

67,172

46,969

35,739

39,412

50,288

35,006

34,978

21,826

19,993

17,672

17,730

16,640

25,438

13,415

13,231

14,110

19,768

21,254

15,465

11,909

Operating lease amortization

46,000

45,000

42,000

43,000

42,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt discount and debt issuance costs

14,000

15,000

15,000

14,000

14,000

14,000

15,000

13,000

17,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Unrealized foreign currency transaction gains on Euro-denominated debt

33,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of debt issuance costs

-

-

-

-

-

-

-

-

-

-

2,318

2,442

2,067

2,253

2,003

1,907

1,837

1,665

1,695

2,675

1,543

1,411

1,233

1,239

1,346

3,546

1,473

1,447

1,432

1,422

1,453

1,442

895

684

563

560

553

547

892

986

907

Amortization of debt discount

-

-

-

-

-

-

-

-

-

-

17,523

17,761

17,625

17,488

17,332

17,171

17,009

16,819

16,657

16,520

16,691

15,652

14,820

11,847

12,412

14,493

16,993

13,112

11,120

10,989

10,859

10,731

7,241

5,470

5,391

5,314

5,239

5,162

5,482

6,192

3,274

Loss on early extinguishment of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-16

-125

-2,733

-3,396

-26,661

0

0

0

-

-

-

-

-

-

-

-

0

-3,226

-2,857

-5,251

Impairment of goodwill

489,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Equity Securities without Readily Determinable Fair Value, Impairment Loss, Annual Amount

100,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

2,000

-

-

-

7,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Impairment of cost-method investments

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

12,858

50,350

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits on stock-based awards and other equity deductions

-

-

-

-

-

-

-

-

-

-

-

-

-

-11,116

10,646

43,397

18,073

10,573

22,694

18,703

49,538

9,227

1,917

6,723

5,499

4,368

-4,449

13,324

4,443

-7,722

398

8,473

4,040

6,045

2,823

2,653

9,520

-1,884

2,640

679

1,656

Contingent consideration fair value adjustment

-

-

-

-

-

-

8,000

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in assets and liabilities:
Accounts receivable

-760,000

-119,000

-81,000

499,000

24,000

-131,000

58,000

296,000

96,000

-209,184

145,639

255,117

78,428

-186,295

126,148

152,443

191,704

-220,910

1,664

167,347

120,593

-171,148

40,398

218,803

94,156

-172,389

40,978

127,821

115,162

-127,383

55,939

118,486

58,235

-76,294

47,871

97,729

56,487

-83,480

27,239

65,293

20,223

Prepaid expenses and other current assets

445,000

16,000

-337,000

-85,000

669,000

0

-373,000

-135,000

709,000

-12,304

-302,337

-5,002

443,643

-109,097

-182,879

-53,509

340,485

-5,197

-213,674

7,814

292,668

13,591

-228,622

-53,849

317,812

-1,605

-124,544

-74,935

207,993

-56,264

1,665

-49,953

145,345

-6,232

3,108

-5,782

-3,307

14,339

-1,602

11,529

-1,893

Deferred merchant bookings and other current liabilities

-1,135,000

-314,000

-719,000

952,000

561,000

-370,000

-324,000

697,000

632,000

46,040

-232,745

567,947

305,758

-9,279

-160,116

389,046

294,349

-25,896

-213,937

204,603

201,215

-5,687

-103,368

165,317

147,608

-98,782

-47,065

139,898

188,112

-62,033

73,370

91,445

153,239

-81,835

87,853

26,544

177,763

-85,148

46,055

100,132

23,711

Other long-term assets and liabilities

79,000

-62,000

63,000

-20,000

418,000

7,000

10,000

45,000

-32,000

-2,779

-28,197

-12,986

9,962

32

10,405

11,432

-869

-2,638

13,121

-10,490

23,916

-1,674

2,132

371

-2,705

12,144

7,504

14,516

-23,423

-27,621

-5,990

1,232

-1,485

2,402

-296

14,030

-4,170

-15,878

-2,857

2,071

-1,111

Net cash provided by operating activities

-380,000

1,077,000

1,851,000

1,787,000

150,000

1,084,000

1,964,000

1,650,000

640,000

1,173,575

1,886,591

1,221,216

380,618

1,096,831

1,519,943

1,022,468

344,758

982,364

1,309,800

702,376

208,983

755,280

1,292,132

689,981

177,004

554,473

970,464

593,382

183,117

496,819

674,945

431,606

182,380

281,841

560,469

223,283

276,219

179,917

305,364

187,319

104,697

INVESTING ACTIVITIES:
Purchase of investments

72,000

-24,000

116,000

135,000

445,000

491,000

835,000

646,000

714,000

1,602,556

2,468,541

1,371,180

1,498,723

1,927,263

2,119,075

1,650,316

1,051,346

3,071,793

911,390

2,717,215

1,969,292

3,224,579

3,022,602

1,692,986

2,612,047

2,855,719

2,873,519

2,721,886

1,504,676

1,562,389

1,800,155

1,688,494

1,301,457

774,736

1,223,967

533,822

472,872

783,021

233,283

270,235

526,493

Proceeds from sale and maturity of investments

1,885,000

159,000

963,000

4,312,000

2,665,000

1,120,000

999,000

1,016,000

2,481,000

1,108,117

991,647

803,762

676,474

848,430

658,702

924,264

1,252,604

1,903,257

949,055

1,351,152

880,774

1,199,468

3,624,621

3,426,398

2,652,013

2,949,795

1,688,835

2,130,706

1,521,947

1,730,170

1,198,472

945,414

925,356

699,565

504,484

407,087

618,427

405,744

195,727

257,524

212,674

Additions to property and equipment

80,000

87,000

82,000

88,000

111,000

86,000

121,000

104,000

131,000

64,308

76,423

76,710

70,559

51,924

54,377

60,443

53,256

47,278

42,286

53,088

31,263

40,779

28,739

32,255

29,731

27,487

20,477

21,430

15,051

16,208

10,527

14,726

13,697

17,063

11,693

9,798

8,279

8,122

4,238

5,402

4,831

Payments to Acquire Businesses and Interest in Affiliates

-

-

-

-

-

-

-

-

-

195

552,315

484

6

189

16

72

723

4,674

89,727

19,775

26,162

282

2,395,034

98,417

2,633

361

713

330,742

102

19,990

442

143

13,286

219

899

870

66,204

1,433

0

108,472

2,500

Proceeds from foreign currency contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

453,818

0

5,325

9,029

0

-

-

-

-

7,331

17,082

29,563

32,183

25,840

5,205

0

0

0

12,086

22,771

9,707

Payments on foreign currency contracts

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

448,640

0

15,795

35,486

43,380

25,825

11,858

26,648

17,539

1,792

2,222

0

0

0

8,268

17,759

16,005

-

-

-

-

Change in restricted cash

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-225

170

55

-

-14,503

117

5,077

1,277

960

-35

581

-718

487

2,387

600

2

2,885

19

16

-104

-189

2

31

Net cash provided by (used in) investing activities

1,733,000

96,000

765,000

4,080,000

2,109,000

409,000

43,000

127,000

1,636,000

-558,942

-2,105,632

-644,612

-892,814

-1,130,452

-1,563,260

-786,567

147,279

-1,220,488

-94,123

-1,439,096

-1,140,820

-2,075,481

-1,817,721

1,576,166

-40,855

39,126

-1,215,426

-969,965

-16,002

137,840

-598,279

-730,773

-371,501

-66,615

-738,023

-155,181

55,051

-392,006

-29,519

-108,099

-311,474

FINANCING ACTIVITIES:
Proceeds from revolving credit facility and short-term borrowings

0

0

-37,000

187,000

250,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from short-term borrowing

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

100,000

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from revolving credit facility

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of short-term borrowings

0

0

0

400,000

25,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from the issuance of long-term debt

-

-

-

-

-

-

-

-

-

48

993,230

0

1,051,722

295

0

992,205

2,500

788,585

0

-1,438

1,611,887

-17,464

2,282,217

0

0

-

-

-

-

0

0

0

1,000,000

0

0

0

0

0

0

0

575,000

Payment of debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,241

0

0

-

-

-

-

0

495

94

20,327

0

0

0

0

0

0

396

12,938

Payments for conversion of senior notes

-

-

-

-

-

0

0

0

1,487,000

196,425

6,102

83,469

4

0

0

0

0

0

0

0

147,629

3,211

4,095

59,381

58,449

414,561

8

0

0

-

-

-

-

-

-

-

-

3

122,023

74,987

98,388

Repayment of debt

-

-

-

-

-

-

-

-

-

-

15,118

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments for repurchase of common stock

1,281,000

1,347,000

1,349,000

2,718,000

2,773,000

1,861,000

2,205,000

1,187,000

718,000

704,898

567,852

345,453

209,797

257,658

233,776

278,847

241,719

821,455

1,280,803

677,963

308,618

504,922

148,130

666

96,660

507

459,723

346,905

76,380

1,624

229

943

254,225

802

3,678

1,429

157,262

3,792

230

6,491

118,932

Proceeds from exercise of stock options

-

-

-

-

-

-

-

-

-

-

1,513

1,311

1,479

2,738

3,496

4,951

4,815

1,712

6,314

3,755

9,070

3,955

2,748

1,993

7,693

5,297

13,500

71,845

965

28

962

648

1,045

311

121

3,326

544

1,128

1,174

10,852

12,597

Net cash (used in) provided by financing activities

-1,281,000

-1,344,000

-1,389,000

-2,939,000

-2,548,000

-1,839,000

-2,204,000

-1,183,000

-2,205,000

-900,460

401,072

-423,012

843,400

-254,625

-230,280

618,309

-134,404

-122,093

-1,262,730

-660,713

1,214,248

-496,174

2,118,416

-51,331

-141,917

-405,492

-451,561

524,514

-70,972

-9,318

635

-52,995

730,533

5,554

-734

-8,649

-147,198

38,433

-118,439

-66,032

358,995

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

-21,000

18,000

-18,000

-6,000

-2,000

-3,000

-17,000

-31,000

11,000

963

30,467

46,833

21,737

-52,809

2,182

-17,669

22,296

-4,213

-238

30,568

-175,248

-88,331

-53,002

933

3,924

5,793

30,403

3,073

-21,282

12,538

8,383

-27,127

17,827

-9,110

-11,795

722

8,035

-498

19,680

-5,928

-5,584

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

51,000

-153,000

1,209,000

2,922,000

-291,000

-349,000

-214,000

563,000

82,000

-284,864

212,498

200,425

352,941

-341,055

-271,415

836,541

379,929

-364,430

-47,291

-1,366,865

107,163

-1,904,706

1,539,825

2,215,749

-1,844

193,900

-666,120

151,004

74,861

637,879

85,684

-379,289

559,239

211,670

-190,083

60,175

192,107

-174,154

177,086

7,260

146,634

SUPPLEMENTAL CASH FLOW INFORMATION:
Cash paid during the period for income taxes (see Note 14)

762,000

88,000

37,000

133,000

816,000

125,000

59,000

201,000

784,000

100,752

24,001

41,055

536,192

24,388

116,209

47,089

449,314

34,684

27,071

92,747

379,603

79,345

26,679

18,346

367,160

125,866

18,266

18,144

228,893

95,283

16,195

15,533

173,528

133,386

43,915

26,505

28,956

107,752

30,566

15,069

15,933

Cash paid during the period for interest

68,000

50,000

70,000

33,000

68,000

64,000

54,000

27,000

74,000

44,255

50,437

21,812

38,496

38,573

43,700

3,608

40,119

3,899

36,863

2,696

10,841

2,419

6,451

2,259

5,821

2,340

9,074

468

9,072

470

9,114

437

3,912

130

3,726

116

3,601

262

3,863

25

751

Non-cash fair value increase for redeemable noncontrolling interests

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-85,044

0

-246

42,768

-143,948

15,815

-8,774

52,214

50,416

7,587

23,385

10,355

-

-

-

-

Non-cash investing activity for contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

9,170

-2,610

-11,067

24,377

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Non-cash financing activity for loan forgiveness

-

-

-

-

-

-

-

-

-

-

0

0

1,000

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-