Wesco aircraft holdings, inc (WAIR)
CashFlow / TTM
Sep'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'10
Operating activities
Net income (loss)

21,369

39,691

36,331

39,321

32,654

-12,907

-253,269

-250,827

-237,346

-175,798

77,826

83,876

91,378

-145,882

-153,419

-153,865

-154,744

83,903

96,196

97,462

102,102

107,426

105,680

110,756

104,812

101,821

97,088

87,423

92,175

83,223

74,891

77,106

75,598

0

0

0

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

29,376

28,674

28,880

29,098

29,256

29,449

29,421

28,879

28,352

27,949

27,399

27,712

27,980

28,754

28,517

28,141

27,726

33,118

30,576

26,333

21,402

14,527

12,159

11,368

11,380

6,610

5,891

5,167

4,427

3,694

3,696

3,699

3,699

0

0

0

Depreciation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

4,947

5,160

5,330

5,536

5,805

5,864

6,133

5,859

0

0

0

Amortization of deferred debt issuance costs

5,200

5,314

5,399

5,496

5,700

5,264

4,888

4,406

6,100

6,619

6,997

7,001

4,627

4,236

3,949

4,163

4,354

4,505

4,288

3,795

3,300

2,687

2,591

2,648

7,788

7,760

7,570

7,469

2,803

3,337

11,091

11,342

11,416

0

0

0

Bad debt and sales return reserve

223

-51

-91

185

220

980

1,101

-79

225

-1,103

-1,938

-726

-810

-3,164

-886

-299

354

3,675

2,380

2,011

965

1,196

1,448

410

411

344

-291

-146

-218

-590

-72

287

256

0

0

0

Non-cash foreign currency exchange

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-1,499

-893

-705

-436

144

341

43

427

0

0

0

Stock-based compensation expense

9,303

10,384

10,622

10,381

9,252

7,663

5,736

6,460

7,335

8,042

9,491

8,986

8,490

7,280

7,527

7,875

7,891

8,113

7,102

6,189

5,507

5,093

4,574

3,935

3,394

3,190

2,810

1,948

1,626

3,402

3,439

3,959

3,658

0

0

0

Inventory Write-down

2,700

4,269

14,501

17,402

16,800

14,767

12,375

15,177

12,900

0

0

0

-

-

-

-

95,052

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess tax benefit related to stock-based incentive plans

-

-

-

-

-

-

-

-

-

-

-

-

-

949

1,088

422

443

388

3,695

7,790

10,235

13,896

12,565

8,688

6,879

0

0

0

-

-

-

-

-

-

-

-

Change in fair value of derivative

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,703

2,520

3,400

4,160

4,958

0

0

0

Income from equity investment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

596

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Deferred income taxes

4,257

8,625

8,577

8,567

9,172

41,684

-21,051

-20,968

-21,070

-53,259

11,624

11,972

13,212

-122,802

-124,896

-125,344

-127,035

4,137

3,889

5,946

8,273

3,313

8,016

9,631

9,941

19,644

22,919

21,223

20,616

17,019

10,944

11,127

11,176

0

0

0

Other non-cash items

484

493

693

871

615

-228

-1,790

-2,478

-1,434

-800

1,815

4,262

4,102

-3,017

-2,257

-5,259

-3,491

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Subtotal

-74,974

-105,467

-101,320

-95,267

-102,407

-131,003

-126,026

-121,491

-109,087

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Changes in assets and liabilities:
Accounts receivable

45,500

31,706

31,560

44,271

28,393

39,567

19,892

4,352

8,531

9,583

819

20,441

4,077

-14,681

-8,533

-46,908

-43,841

-18,631

-32,813

25,140

38,545

43,110

63,663

27,896

26,972

25,679

33,921

19,893

21,802

16,120

3,577

1,011

8,281

0

0

0

Income tax receivable

1,436

33

916

-178

-1,544

1,250

-5,092

-4,092

2,159

1,188

7,484

6,992

1,269

-3,325

-4,437

-11,781

-16,036

-10,453

-18,664

-16,383

-19,003

-34,710

-36,846

-38,985

-35,952

-13,231

3,899

19,939

18,022

0

0

0

-

-

-

-

Inventories

-19,424

-9,997

15,312

73,721

73,106

105,948

128,286

118,397

129,772

117,253

94,345

61,633

41,798

12,310

10,506

22,495

48,977

82,895

87,152

82,896

72,702

79,267

84,329

106,027

81,273

62,929

50,757

42,996

32,344

25,724

15,605

3,036

129

0

0

0

Prepaid expenses and other assets

5,478

7,719

3,734

3,142

-365

2,527

5,836

7,065

5,989

2,706

-5,175

-4,917

1,204

-1,197

6,859

3,627

-1,250

-6,326

-6,182

-5,783

-5,799

-727

618

3,671

3,335

4,530

3,879

3,308

2,431

3,370

1,021

-836

-1,388

0

0

0

Accounts payable

36,933

20,848

-13,299

23,233

-3,430

16,998

12,663

-11,780

2,201

7,516

23,813

10,012

34,657

3,136

-6,308

-11,922

-9,992

20,054

6,008

27,264

3,099

-2,943

8,454

18,866

19,330

20,734

21,327

13,694

21,836

22,802

14,026

7,316

-5,558

0

0

0

Accrued expenses and other liabilities

6,564

3,734

9,812

5,158

19,252

19,504

17,074

13,979

11,761

1,995

-1,892

3,523

-11,008

-2,290

-4,253

-5,312

3,425

2,066

-4,419

333

-8,830

-9,013

-2,112

-2,861

1,071

1,208

5,044

3,479

1,833

2,058

-1,826

-1,444

2,406

0

0

0

Income tax payable

891

-8,221

-1,109

-1,681

-771

12,472

-2,037

-1,882

-3,526

-9,649

-5,922

-2,105

-13,236

-1,277

9,987

5,367

15,768

7,056

5,229

1,990

2,481

2,060

-3,688

490

820

445

4,175

-909

946

1,060

583

-6,127

-4,063

0

0

0

Gain on fixed asset disposal

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-331

0

0

0

-

-

-

-

Net cash provided by (used in) operating activities

86,372

86,247

47,376

15,301

17,868

-13,147

-29,074

-28,722

-26,928

18,016

68,866

78,705

117,455

123,912

106,526

140,519

141,172

135,094

136,852

91,057

53,689

30,376

19,145

54,697

84,829

65,454

59,035

36,053

54,569

81,315

90,187

106,408

86,317

0

0

0

Investing activities
Payments to Acquire Property, Plant, and Equipment

21,121

18,138

10,753

6,571

5,666

6,101

7,623

8,942

8,923

9,662

10,968

14,146

13,992

16,142

13,952

9,494

9,631

7,267

10,256

9,963

10,517

13,938

9,866

9,138

7,882

298

4,525

4,481

4,528

7,202

3,550

5,529

5,119

0

0

0

Proceeds from sales of property, plant and equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Acquisitions of business, net of cash acquired

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

250

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash used in investing activities

-21,121

-18,138

-10,753

-6,571

-5,666

-6,101

-7,623

-8,942

-8,923

-9,662

-10,968

-12,146

-11,992

-14,125

-11,935

-9,477

-9,864

-8,058

-11,292

-571,199

-571,503

-574,383

-570,066

-9,138

-7,882

-134,929

-139,178

-139,134

-136,422

-4,465

-791

-2,770

-5,119

0

0

0

Financing activities
Proceeds from short-term borrowings

95,000

57,000

54,500

51,500

67,500

84,500

87,000

98,000

77,000

60,000

50,000

25,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of short-term borrowings

143,000

100,500

68,500

51,500

68,500

51,000

44,000

44,000

22,000

12,000

12,000

5,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from issuance of long-term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

625,000

0

0

0

-

-

-

-

-

-

-

-

Repayments of long-term debt

20,000

20,000

20,000

20,000

20,000

20,000

20,000

20,000

21,344

51,344

92,344

112,344

111,000

126,000

134,750

139,750

149,750

0

0

0

-

-

-

-

683,000

673,000

649,500

636,000

25,000

53,000

690,243

690,243

679,243

0

0

0

Debt issuance costs

0

0

0

0

1,900

1,900

1,957

4,234

12,796

12,796

12,789

12,588

2,126

0

0

0

-

-

-

-

-

-

-

-

7,274

0

0

0

-

-

-

-

-

-

-

-

Repayments of capital lease obligations

2,941

2,888

3,099

3,209

3,001

3,036

2,777

2,324

2,107

1,550

1,344

917

1,309

1,332

1,363

1,830

1,511

1,607

1,551

1,468

1,338

1,183

1,068

1,078

1,146

1,335

1,601

1,804

1,984

2,009

2,060

2,032

1,898

0

0

0

Excess tax benefit related to stock-based incentive plans

-

-

-

-

-

-

-

-

-

-

-

-

1,098

949

1,088

422

443

388

3,695

7,790

10,235

13,896

12,565

8,688

6,879

0

0

0

-

-

-

-

-

-

-

-

Net proceeds from exercise of stock options

37

52

56

90

78

62

33

687

2,964

2,912

5,560

8,200

6,073

6,164

3,883

795

823

1,223

3,706

7,648

9,643

11,922

13,256

10,281

9,895

0

0

0

-

-

-

-

-

-

-

-

Settlement on restricted stock tax withholding

2,200

1,637

1,649

1,723

1,321

934

1,172

1,098

1,072

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net cash (used in) provided by financing activities

-73,104

-67,973

-38,692

-24,842

-27,144

7,692

17,127

27,031

20,645

-15,597

-63,472

-97,492

-108,121

-123,046

-133,919

-141,064

-150,696

-124,840

-69,494

523,465

543,035

564,225

546,092

-29,109

-58,098

-33,350

79,465

97,851

96,869

51,589

-79,728

-86,260

-75,126

0

0

0

Purchase of treasury stock

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

Effect of foreign currency exchange rate on cash and cash equivalents

-335

-306

-1,128

-655

-461

88

1,523

1,389

-230

-1,186

-3,494

-3,530

-3,147

-3,329

121

-4,035

-2,521

-557

-3,066

840

838

-743

189

-635

-989

-256

-679

289

315

-338

-96

31

-10

0

0

0

Net decrease in cash and cash equivalents

-8,188

-170

-3,197

-16,767

-15,403

-11,468

-18,047

-9,244

-15,436

-8,429

-9,068

-34,463

-5,805

-16,588

-39,207

-14,057

-21,909

1,639

53,000

44,163

26,059

19,475

-4,640

15,815

17,860

-103,081

-1,357

-4,941

15,331

128,101

9,572

17,409

6,062

0

0

0