Ilg, inc. (ILG)
CashFlow / TTM
Jun'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

177,000

177,000

177,000

135,000

136,000

294,000

272,000

252,000

239,000

72,211

75,000

78,808

80,912

83,095

82,000

85,289

80,290

81,466

81,782

77,962

61,009

50,490

40,709

34,426

45,710

43,157

41,126

0

0

0

Adjustments to reconcile net income to net cash provided by operating activities:
Amortization expense of intangibles

20,000

20,000

20,000

20,000

21,000

21,000

19,000

18,000

15,000

13,499

14,000

13,260

13,139

12,535

12,000

11,015

10,086

9,087

8,133

7,898

12,617

18,010

23,041

27,854

28,015

27,531

27,301

0

0

0

Amortization of debt issuance costs

0

0

-

0

0

0

-

-

-

-

-

-

1,593

1,027

1,000

813

799

783

783

783

951

1,148

1,376

1,615

1,697

1,758

1,806

0

0

0

Depreciation expense

61,000

60,000

60,000

59,000

59,000

53,000

43,000

33,000

24,000

18,731

18,000

17,566

16,331

16,476

16,000

15,106

14,840

14,660

14,531

14,449

14,261

13,787

13,429

13,110

13,118

13,293

13,277

0

0

0

Allowance for losses on originated loans

43,000

37,000

35,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Allowance for impairment on acquired loans

3,000

5,000

5,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of mortgages receivable

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accretion of original issue discount

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,840

2,518

2,673

2,605

2,538

0

0

0

Non-cash compensation expense

21,000

22,000

22,000

23,000

22,000

21,000

18,000

16,000

14,000

12,478

13,000

12,703

12,520

11,675

11,000

10,972

10,764

10,718

10,428

9,951

9,906

10,411

10,931

11,529

11,899

11,667

11,636

0

0

0

Non-cash interest expense

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

372

382

392

433

469

609

561

464

0

0

0

Non-cash interest income

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

850

0

0

0

-

-

-

-

Deferred income taxes

-27,000

-29,000

-24,000

49,000

27,000

22,000

11,000

0

0

0

-

-

-

5,690

7,000

-2,085

168

-11

-1,569

5,793

5,796

6,048

6,507

1,011

-205

381

1,015

0

0

0

Equity in earnings from unconsolidated entities

2,000

3,000

4,000

5,000

6,000

6,000

5,000

5,000

5,000

4,476

5,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Distributions from investments in unconsolidated entities

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefits from stock-based awards

-

-

-

-

-

-

-

-

-

-

-

-

2,092

1,940

2,000

2,179

2,179

2,272

2,869

2,605

3,382

3,364

3,017

3,013

2,232

2,180

1,271

0

0

0

Gain/(loss) on disposal of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-45

-38

-45

-191

-163

-163

-130

256

0

0

0

-

-

-

-

Change in fair value of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-485

0

0

0

-

-

-

-

-

-

-

-

Changes in operating assets and liabilities:
Restricted cash

-

-

-

-

-

-

-

2,000

-2,000

-4,199

-4,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Accounts receivable

53,000

27,000

8,000

-2,000

3,000

0

11,000

1,000

-11,000

18,879

3,000

4,696

8,584

914

-3,000

-3,224

-6,148

-4,011

661

4,331

4,195

7,571

2,945

1,234

7,636

6,888

2,863

0

0

0

Vacation ownership mortgages receivable (originations)

353,000

351,000

345,000

343,000

368,000

273,000

203,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership mortgages receivable (collections)

278,000

281,000

279,000

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership inventory (additions)

150,000

193,000

231,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership inventory (disposals)

85,000

93,000

81,000

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership mortgages receivable

-

-

-

-

-

-

-

-

-

-

-2,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership inventory

-

-

-

-

-

-

-

-

-

-

-7,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership operating related insurance proceeds

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Vacation ownership consolidated HOAs related insurance proceeds

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Prepaid expenses and other current assets

32,000

32,000

26,000

12,000

13,000

26,000

-3,000

0

6,000

3,215

-4,000

-13,770

-12,418

-8,647

-6,000

1,121

162

-4,867

-5,512

-3,100

-1,919

-965

918

-2,099

-1,980

1,020

585

0

0

0

Prepaid income taxes and income taxes payable

-2,000

-6,000

-4,000

-38,000

-55,000

-45,000

-43,000

8,000

25,000

8,086

10,000

1,512

-2,414

-9,129

-10,000

1,895

-1,508

764

4,231

9,149

2,965

641

-7,947

-11,796

-1,871

7,395

6,836

0

0

0

Accounts payable and other current liabilities

40,000

19,000

12,000

1,000

17,000

45,000

32,000

46,000

12,000

2,484

1,000

13,177

8,275

15,343

11,000

6,686

6,053

-2,818

102

-6,823

-19,451

-17,432

-18,004

-10,341

-5,418

2,698

-3,158

0

0

0

Deferred income

-57,000

-91,000

-72,000

80,000

25,000

-6,000

66,000

-14,000

-15,000

-6,313

-7,000

-6,068

-3,133

-3,224

-7,000

-7,014

-9,947

-13,866

-13,934

-13,208

-12,489

-5,317

-5,414

-4,741

-2,678

-1,614

-6,974

0

0

0

Payments of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-

-

-9,000

4,000

9,000

11,000

1,000

-4,000

0

-5,132

-5,000

-5,595

-5,909

-4,943

8,000

7,499

8,244

9,697

-2,792

-2,996

-3,775

-3,451

-3,983

-3,341

-3,160

-4,665

-4,225

0

0

0

Net cash provided by (used in) operating activities

-

-

-

-

-

-

-

-

-

118,295

143,000

154,544

141,344

141,648

111,000

112,018

104,261

96,472

109,864

105,618

91,499

90,257

80,438

83,172

89,339

104,123

95,907

0

0

0

Net cash and restricted cash provided by operating activities

307,000

299,000

205,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash flows from investing activities:
Capital expenditures

93,000

113,000

119,000

133,000

118,000

110,000

95,000

49,000

38,000

22,196

20,000

17,734

16,854

20,703

19,000

19,628

17,254

14,726

14,700

13,953

14,314

15,008

15,040

13,547

14,316

13,235

13,038

0

0

0

Acquisitions net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

39,963

0

0

0

-

-

-

-

Investments in unconsolidated entities

-

-

-

-

-

-

5,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other, net

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on revolving credit facility

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

0

0

0

-

-

-

-

-

-

-

-

Net cash used in investing activities

-85,000

-109,000

-115,000

-78,000

-64,000

-136,000

-127,000

-135,000

-125,000

-29,190

-21,000

-256,984

-255,097

-259,202

-258,000

-147,641

-147,226

-144,446

-134,032

-6,022

9,685

10,544

-47,264

-46,157

-68,292

-83,266

-35,174

0

0

0

Cash flows from financing activities:
Proceeds from disposal of property and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10

7

-7

5

230

0

0

0

-

-

-

-

Investment in financing receivables

-

-

-

-

-

-

-

-

0

0

-

-

-

-

16,000

0

0

0

-

-

-

-

9,480

0

0

0

-

-

-

-

Payments received on financing receivables

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,876

9,876

23,992

25,547

16,989

0

0

0

-

-

-

-

Other

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Borrowings (payments) on revolving credit facility, net

-

-

-

-

0

0

-

-

0

0

-

-

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Principal payments on term loan

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

56,000

61,000

66,000

20,000

20,000

0

0

0

Payments of debt issuance costs

-

-

-

-

-

-

-

-

-

-

7,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Payments on securitized debt

198,000

191,000

178,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of treasury stock

-

-

28,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Dividend payments to stockholders

80,000

77,000

74,000

71,000

66,000

64,000

52,000

44,000

37,000

28,108

28,000

27,039

26,319

25,542

25,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Payments of contingent consideration

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Withholding taxes on vesting of restricted stock units and restricted stock

11,000

11,000

7,000

6,000

6,000

5,000

2,000

2,000

1,000

667

4,000

4,052

4,028

4,633

4,000

4,704

4,740

6,254

5,234

4,486

7,033

5,467

6,182

6,197

4,761

4,637

3,495

0

0

0

Proceeds from the exercise of stock options

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

747

768

774

835

424

650

808

659

635

419

440

457

0

0

0

Excess tax benefits from stock-based awards

-

-

-

-

-

-

-

-

-

-

2,000

2,088

2,092

1,940

2,000

2,179

2,179

2,272

2,869

2,605

3,382

3,364

3,017

3,013

2,232

2,180

1,271

0

0

0

Net cash and restricted cash used in financing activities

-101,000

-25,000

12,000

140,000

121,000

242,000

259,000

114,000

61,000

-84,475

-103,000

127,789

138,417

159,175

185,000

17,841

5,914

-21,308

-27,464

-126,501

-112,546

-145,630

-131,841

-98,660

-104,992

-43,805

-43,555

0

0

0

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

0

8,000

6,000

1,000

4,000

-4,000

-5,000

-4,000

-11,000

-5,229

-7,000

-7,834

-6,812

-8,443

-5,000

-1,834

2,662

1,638

-1,068

-1,489

-774

-2,529

4,312

2,650

-5,059

-1,495

-2,163

0

0

0

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

121,000

173,000

108,000

155,000

98,000

128,000

135,000

57,000

35,000

-599

12,000

17,515

17,852

33,178

33,000

-19,616

-34,389

-67,644

-52,700

-28,394

-12,136

-47,358

-94,355

-58,995

-89,004

-24,443

15,015

0

0

0

Interest paid, net of amounts capitalized

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

Income taxes paid, net of refunds

0

0

-

0

0

0

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0