Rockwell collins inc (COL)
CashFlow / TTM
Sep'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'10Dec'09Sep'09Jun'09Mar'09Dec'08
Operating Activities:
Net income

1,032,000

1,005,000

909,000

840,000

705,000

700,000

735,000

738,000

728,000

704,000

668,000

654,000

686,000

669,000

649,000

640,000

604,000

612,000

618,000

631,000

632,000

609,000

611,000

611,000

609,000

632,000

624,000

613,000

634,000

609,000

593,000

591,000

561,000

545,000

548,000

564,000

594,000

0

0

0

Income from discontinued operations, net of taxes

-

-

-

-

-

-

-

-

1,000

1,000

1,000

-4,000

-8,000

-14,000

-19,000

-13,000

-14,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income from continuing operations

-

-

-

-

-

-

-

-

727,000

703,000

667,000

658,000

694,000

683,000

668,000

653,000

618,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Adjustments to arrive at cash (used for) provided by operating activities:
Non-cash restructuring and impairment charges and settlement of a contract matter

-

-

-

-

-

-

-

-

6,000

6,000

6,000

6,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain on sale of business

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

10,000

10,000

10,000

10,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation

204,000

203,000

196,000

182,000

168,000

155,000

148,000

146,000

144,000

145,000

147,000

149,000

152,000

153,000

150,000

147,000

141,000

135,000

130,000

126,000

124,000

121,000

119,000

119,000

116,000

116,000

114,000

109,000

108,000

109,000

112,000

114,000

115,000

114,000

115,000

115,000

114,000

0

0

0

Amortization of intangible assets, pre-production engineering costs and other

386,000

378,000

364,000

298,000

226,000

157,000

105,000

109,000

109,000

109,000

108,000

99,000

100,000

101,000

95,000

96,000

84,000

70,000

61,000

52,000

53,000

53,000

55,000

54,000

54,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of acquired contract liability

141,000

11,000

1,000

39,000

69,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization of Intangible Assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

36,000

36,000

33,000

30,000

0

0

0

Stock-based compensation expense

35,000

37,000

37,000

34,000

31,000

27,000

25,000

27,000

27,000

28,000

27,000

25,000

24,000

24,000

24,000

24,000

24,000

18,000

19,000

19,000

20,000

24,000

24,000

24,000

24,000

25,000

25,000

25,000

24,000

25,000

25,000

24,000

24,000

20,000

19,000

18,000

18,000

0

0

0

Compensation and benefits paid in common stock

58,000

62,000

61,000

64,000

67,000

66,000

65,000

63,000

59,000

54,000

54,000

51,000

50,000

50,000

49,000

49,000

50,000

48,000

48,000

47,000

53,000

58,000

63,000

69,000

69,000

68,000

70,000

69,000

68,000

69,000

66,000

64,000

64,000

62,000

62,000

63,000

63,000

0

0

0

Tax benefit from stock-based compensation

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

Excess tax benefit from stock-based compensation (see Note 2)

-

-

-

-

-

-

-

-

-

-

-

9,000

13,000

13,000

10,000

11,000

6,000

7,000

11,000

10,000

9,000

9,000

5,000

6,000

9,000

7,000

11,000

11,000

7,000

11,000

13,000

15,000

17,000

14,000

9,000

4,000

2,000

0

0

0

Deferred income taxes

-13,000

-35,000

-69,000

-91,000

43,000

27,000

15,000

44,000

48,000

45,000

65,000

52,000

50,000

76,000

105,000

118,000

113,000

61,000

57,000

56,000

55,000

58,000

82,000

93,000

102,000

144,000

112,000

94,000

93,000

91,000

131,000

96,000

86,000

124,000

64,000

93,000

88,000

0

0

0

Pension plan contributions

467,000

79,000

66,000

68,000

68,000

69,000

69,000

69,000

69,000

69,000

69,000

69,000

69,000

75,000

75,000

76,000

75,000

68,000

68,000

122,000

122,000

126,000

125,000

133,000

126,000

123,000

124,000

160,000

113,000

112,000

112,000

12,000

110,000

160,000

160,000

236,000

139,000

0

0

0

Changes in assets and liabilities, excluding effects of acquisitions and foreign currency adjustments:
Receivables

680,000

212,000

41,000

0

-121,000

-12,000

93,000

60,000

91,000

101,000

17,000

15,000

46,000

79,000

64,000

34,000

-67,000

61,000

47,000

78,000

97,000

28,000

105,000

33,000

27,000

-64,000

-130,000

-59,000

-49,000

63,000

128,000

87,000

32,000

-118,000

-169,000

-233,000

-39,000

0

0

0

Production inventory

255,000

178,000

155,000

62,000

50,000

33,000

-2,000

18,000

18,000

24,000

54,000

55,000

23,000

61,000

67,000

88,000

84,000

92,000

106,000

99,000

96,000

57,000

-6,000

21,000

70,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Pre-production engineering costs

85,000

51,000

66,000

88,000

94,000

144,000

156,000

166,000

177,000

190,000

194,000

189,000

183,000

176,000

181,000

192,000

198,000

195,000

185,000

178,000

170,000

171,000

166,000

154,000

141,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Inventories

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

86,000

116,000

138,000

-12,000

0

0

0

Accounts payable

-102,000

44,000

52,000

39,000

141,000

56,000

33,000

21,000

38,000

47,000

-12,000

-10,000

-29,000

-32,000

15,000

14,000

23,000

63,000

28,000

36,000

14,000

-23,000

-7,000

-24,000

-27,000

-18,000

-47,000

29,000

58,000

28,000

92,000

36,000

43,000

-116,000

-148,000

-186,000

-63,000

0

0

0

Compensation and benefits

-109,000

27,000

38,000

-4,000

39,000

-8,000

-7,000

-21,000

-4,000

0

-8,000

29,000

24,000

26,000

-21,000

-11,000

-60,000

-47,000

-49,000

-25,000

33,000

20,000

6,000

-1,000

-75,000

-41,000

-19,000

0

61,000

59,000

54,000

14,000

64,000

-246,000

-214,000

-256,000

-122,000

0

0

0

Advance payments from customers

17,000

-26,000

-9,000

9,000

10,000

21,000

-34,000

-83,000

-82,000

-98,000

-64,000

-25,000

16,000

24,000

23,000

-3,000

-11,000

-2,000

-23,000

3,000

32,000

22,000

60,000

55,000

23,000

4,000

-13,000

-45,000

-55,000

-53,000

-57,000

-26,000

-25,000

-11,000

19,000

30,000

15,000

0

0

0

Accrued customer incentives

-7,000

-3,000

-29,000

-69,000

-8,000

-16,000

-23,000

23,000

14,000

11,000

36,000

33,000

30,000

50,000

7,000

16,000

18,000

17,000

14,000

13,000

10,000

12,000

32,000

39,000

46,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Product warranty costs

10,000

-11,000

-14,000

-19,000

-21,000

0

-3,000

-3,000

-2,000

-12,000

-14,000

-16,000

-14,000

-12,000

-12,000

-9,000

-14,000

-8,000

-7,000

-5,000

-5,000

-7,000

-5,000

-20,000

-21,000

-28,000

-40,000

-36,000

-35,000

-37,000

-32,000

-32,000

-34,000

0

0

0

-

-

-

-

Income taxes

64,000

4,000

54,000

62,000

-45,000

-34,000

-16,000

2,000

25,000

25,000

31,000

49,000

50,000

62,000

50,000

-7,000

-21,000

1,000

17,000

28,000

70,000

36,000

-19,000

-48,000

-63,000

-56,000

-10,000

57,000

59,000

76,000

5,000

21,000

48,000

-10,000

37,000

-34,000

2,000

0

0

0

Other assets and liabilities

291,000

55,000

13,000

-4,000

6,000

4,000

49,000

45,000

32,000

47,000

43,000

45,000

64,000

74,000

51,000

71,000

8,000

-8,000

-5,000

-21,000

2,000

7,000

24,000

29,000

16,000

40,000

52,000

41,000

72,000

40,000

11,000

39,000

26,000

78,000

131,000

91,000

27,000

0

0

0

Cash (Used for) Provided by Operating Activities from Continuing Operations

-310,000

1,044,000

1,186,000

1,106,000

1,264,000

916,000

679,000

713,000

723,000

631,000

662,000

718,000

749,000

736,000

714,000

624,000

660,000

549,000

492,000

506,000

593,000

630,000

647,000

640,000

513,000

603,000

575,000

536,000

657,000

517,000

558,000

684,000

711,000

692,000

776,000

696,000

633,000

0

0

0

Investing Activities:
Property additions

257,000

265,000

278,000

262,000

240,000

225,000

190,000

197,000

193,000

188,000

199,000

196,000

210,000

203,000

197,000

187,000

163,000

150,000

129,000

118,000

120,000

121,000

130,000

134,000

138,000

150,000

155,000

164,000

152,000

130,000

116,000

115,000

109,000

119,000

138,000

134,000

153,000

0

0

0

Acquisition of business, net of cash acquired

0

0

3,418,000

3,418,000

3,429,000

3,429,000

11,000

28,000

17,000

0

0

0

-

-

-

-

1,405,000

1,405,000

1,415,000

1,420,000

0

0

0

0

-

-

-

-

17,000

18,000

19,000

11,000

96,000

95,000

212,000

210,000

146,000

0

0

0

Proceeds from business divestitures

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

24,000

24,000

24,000

24,000

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other investing activities

-1,000

-4,000

-1,000

-1,000

5,000

0

0

0

-

-

-

-

10,000

0

2,000

6,000

-8,000

0

0

0

-

-

-

-

1,000

4,000

4,000

2,000

-3,000

-3,000

-3,000

-3,000

0

0

0

2,000

1,000

0

0

0

Cash (Used for) Investing Activities from Continuing Operations

-256,000

-261,000

-3,695,000

-3,679,000

-3,674,000

-3,657,000

-201,000

-224,000

-209,000

-258,000

-268,000

-266,000

-294,000

-227,000

-211,000

-179,000

-1,537,000

-1,530,000

-1,518,000

-1,512,000

-118,000

-123,000

-119,000

-122,000

-129,000

-80,000

-100,000

-102,000

-92,000

-152,000

-140,000

-150,000

-232,000

-220,000

-355,000

-348,000

-302,000

0

0

0

Financing Activities:
Repayment of long-term debt, including current portion

389,000

943,000

844,000

806,000

930,000

338,000

300,000

300,000

0

0

0

0

-

-

-

-

200,000

0

0

0

-

-

-

-

-

-

-

-

24,000

0

0

0

-

-

-

-

-

-

-

-

Repayment of acquired long-term debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of treasury stock

12,000

11,000

52,000

52,000

46,000

46,000

78,000

170,000

261,000

261,000

276,000

253,000

330,000

430,000

392,000

362,000

211,000

176,000

213,000

275,000

589,000

528,000

649,000

657,000

714,000

761,000

619,000

572,000

328,000

343,000

328,000

304,000

183,000

175,000

176,000

140,000

153,000

0

0

0

Cash dividends

216,000

216,000

216,000

205,000

194,000

183,000

172,000

172,000

172,000

173,000

173,000

170,000

167,000

163,000

161,000

161,000

162,000

162,000

162,000

163,000

164,000

167,000

169,000

163,000

157,000

150,000

144,000

146,000

148,000

150,000

151,000

151,000

151,000

151,000

151,000

152,000

152,000

0

0

0

Increase in long-term borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,089,000

1,089,000

1,089,000

1,089,000

0

0

0

0

247,000

247,000

247,000

247,000

0

0

0

0

-

-

-

-

-

-

-

-

Increase in short-term commercial paper borrowings, net

-

-

-

-

-

-

-

-

-

-

0

-26,000

-

0

0

-86,000

-

0

0

572,000

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Increase (decrease) in short-term commercial paper borrowings, net

1,170,000

353,000

-96,000

-192,000

-110,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

0

0

0

-

-

-

0

-

0

0

0

Proceeds from the exercise of stock options

63,000

83,000

94,000

96,000

64,000

47,000

35,000

33,000

21,000

16,000

32,000

35,000

49,000

50,000

36,000

47,000

37,000

58,000

73,000

61,000

61,000

42,000

24,000

26,000

21,000

20,000

26,000

20,000

22,000

26,000

29,000

35,000

38,000

40,000

38,000

25,000

19,000

0

0

0

Excess tax benefit from stock-based compensation (see Note 2)

-

-

-

-

-

-

-

-

-

-

-

9,000

13,000

13,000

10,000

11,000

6,000

7,000

11,000

10,000

9,000

9,000

5,000

6,000

9,000

7,000

11,000

11,000

7,000

11,000

13,000

15,000

17,000

14,000

9,000

4,000

2,000

0

0

0

Other financing activities

-6,000

-5,000

-6,000

-6,000

-5,000

-4,000

-2,000

-2,000

-2,000

-2,000

-2,000

-2,000

-1,000

0

0

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash Provided by (Used for) Financing Activities from Continuing Operations

610,000

-739,000

2,860,000

2,815,000

2,759,000

3,006,000

-482,000

-499,000

-422,000

-352,000

-380,000

-407,000

-492,000

-642,000

-589,000

-552,000

827,000

1,071,000

1,079,000

1,094,000

-448,000

-445,000

-501,000

-491,000

-594,000

-506,000

-411,000

-406,000

-471,000

-410,000

-432,000

-477,000

-279,000

-389,000

-369,000

-346,000

-275,000

0

0

0

Operating activities

-

-

-

-

-

-

-

-

-

-

-

-

-14,000

-2,000

-15,000

-3,000

-16,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Cash (Used For) Discontinued Operations

-

-

-

-

-

-

-

-

-

0

0

-10,000

-11,000

11,000

-2,000

7,000

-6,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Effect of exchange rate changes on cash and cash equivalents

-9,000

-1,000

36,000

33,000

14,000

6,000

-15,000

-16,000

-4,000

-8,000

2,000

-16,000

-23,000

-34,000

-38,000

-24,000

-12,000

10,000

11,000

4,000

5,000

0

0

0

-

-20,000

-3,000

-5,000

1,000

10,000

4,000

0

0

2,000

4,000

4,000

4,000

0

0

0

Net Change in Cash and Cash Equivalents

35,000

43,000

387,000

275,000

363,000

271,000

-19,000

-26,000

88,000

13,000

16,000

19,000

-71,000

-156,000

-126,000

-124,000

-68,000

96,000

73,000

102,000

56,000

0

0

0

-

-3,000

61,000

23,000

95,000

-35,000

-10,000

57,000

200,000

85,000

56,000

6,000

60,000

0

0

0