Dun & bradstreet corp/nw (DNB)
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'10
Cash Flows from Operating Activities:
Net Income

237,800

241,900

193,900

145,000

198,700

115,200

88,400

102,400

100,800

188,400

161,900

173,100

187,800

196,300

253,800

297,900

281,900

287,000

294,500

262,100

280,700

287,900

286,000

296,500

295,700

273,800

276,000

260,200

257,700

255,700

253,400

250,900

0

0

0

Loss on Disposal of Business - Discontinued Operations

0

0

0

-800

-4,000

-4,900

-4,900

-4,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

2,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Income from Continuing Operations

237,800

241,900

193,900

145,800

202,700

120,100

93,300

106,500

100,900

187,800

198,800

208,500

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Reconciliation of Net Income to Net Cash Provided by Operating Activities:
Depreciation and Amortization

87,700

85,200

81,900

79,700

76,100

73,200

71,100

68,600

67,000

65,900

62,700

58,700

55,000

52,200

49,000

52,500

46,900

51,000

58,000

60,400

72,000

74,600

76,400

78,300

80,400

81,000

81,900

81,100

80,400

76,900

72,300

68,100

0

0

0

Amortization of Unrecognized Pension Loss

40,600

39,600

38,600

37,900

37,300

36,900

36,300

35,800

36,700

37,300

38,600

39,800

38,300

36,500

34,800

32,900

33,000

33,600

33,400

33,400

30,800

28,100

25,900

23,500

21,100

18,800

16,600

14,600

13,700

12,500

12,400

12,200

0

0

0

(Gain) Loss from Sales of Business

0

0

0

-700

-6,200

-95,800

-95,800

-95,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

6,100

6,000

-2,600

-5,700

-11,700

0

0

0

-

-

-

-

Impairment of Assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

16,100

19,400

19,400

16,200

3,300

0

0

0

-

-

-

-

Income Tax Benefit from Stock-Based Awards

5,100

5,000

5,800

6,900

7,000

16,700

16,600

14,200

14,600

5,000

5,600

7,000

6,800

6,800

5,700

4,400

8,300

9,300

12,700

12,200

9,700

9,700

6,500

7,000

5,700

7,400

11,700

12,200

14,100

13,000

9,100

9,200

0

0

0

Equity-Based Compensation Expense

11,500

12,800

14,400

20,500

22,100

22,400

22,200

21,200

18,200

17,000

16,800

14,700

15,400

14,000

11,500

11,200

8,200

6,300

7,100

8,500

9,800

11,600

10,900

10,600

12,000

12,200

11,900

12,400

12,200

12,700

16,500

18,300

0

0

0

Excess Tax Benefit on Stock-Based Awards

-

-

-

-

-

-

-

7,200

7,300

600

1,200

3,000

3,000

3,100

2,500

1,600

3,500

3,800

4,100

3,500

2,500

2,600

2,200

2,200

1,500

2,600

5,700

5,800

7,100

6,200

3,400

3,200

0

0

0

Restructuring Charge

33,400

37,100

34,100

32,100

25,600

23,000

21,400

22,100

36,000

38,300

37,200

32,300

18,100

14,600

14,800

14,900

15,200

19,300

16,500

13,900

16,800

15,500

22,600

29,400

27,300

27,800

27,000

22,100

22,700

21,300

14,400

14,800

0

0

0

Restructuring Payments

35,100

32,600

31,600

25,700

22,900

24,400

26,800

32,700

36,200

33,400

28,500

20,900

15,800

14,700

12,300

15,400

15,900

16,200

16,600

14,700

16,000

22,300

27,200

28,200

28,200

24,700

20,600

19,700

19,900

17,200

17,400

19,900

0

0

0

Changes in Deferred Income Taxes, Net

-65,200

-60,500

-41,600

-31,900

-7,700

-9,600

-6,000

-5,700

-11,200

-11,100

-11,100

-12,700

-13,100

7,900

5,700

67,700

63,400

41,700

43,400

-18,600

19,300

-10,200

-8,700

-4,900

-10,300

23,200

9,200

11,700

10,600

17,500

33,500

25,700

0

0

0

Changes in Accrued Income Taxes, Net

26,700

50,300

48,300

49,800

6,300

-14,100

14,000

9,400

-15,900

-18,500

-23,500

-16,700

-7,700

-2,000

4,600

10,200

-16,200

100

-13,200

-15,400

-18,500

-22,400

-6,800

-32,000

-14,300

-31,700

-35,700

-7,500

-200

-100

5,500

24,700

0

0

0

Changes in Operating Assets and Liabilities (1):
(Increase) Decrease in Accounts Receivable

134,600

185,100

97,100

34,200

-4,300

-21,100

4,700

45,800

35,300

46,700

11,100

24,500

7,200

12,900

9,500

7,500

12,500

20,600

21,900

6,800

-2,300

-3,800

-3,000

14,400

19,800

3,700

9,000

12,000

-6,900

-32,400

-10,600

31,300

0

0

0

(Increase) Decrease in Other Current Assets

7,600

14,000

4,300

1,500

500

-9,500

-7,500

-7,100

-7,300

3,000

1,900

-4,700

-4,900

-6,500

-600

5,200

7,600

6,100

-5,300

-14,900

-3,300

-5,800

-4,700

-9,000

-4,900

-1,400

8,100

15,900

-2,400

-2,200

-1,100

9,400

0

0

0

Increase (Decrease) in Deferred Revenue

49,200

75,600

40,700

28,200

900

15,400

5,400

8,000

31,900

34,300

28,600

41,400

30,600

2,300

-9,600

-11,900

-15,800

-9,800

-10,600

-10,500

-100

6,300

7,800

8,900

11,900

1,100

2,400

1,000

-9,900

2,700

28,800

46,600

0

0

0

Increase (Decrease) in Accounts Payable

-17,500

-10,700

5,200

-11,700

-15,900

-14,200

-7,600

18,600

18,800

10,400

-5,100

1,800

3,100

5,600

12,200

-5,600

4,900

2,600

6,100

-1,500

-5,800

-9,700

2,700

3,800

9,500

21,700

3,000

2,000

-4,400

-22,200

-8,800

-7,900

0

0

0

Increase (Decrease) in Accrued Liabilities

-29,000

-34,500

-41,900

-30,000

-3,500

-4,800

30,700

53,700

40,400

31,400

6,300

1,400

-12,000

4,400

2,900

21,600

28,100

12,500

2,800

-9,700

-16,600

-9,500

-25,300

-30,600

-53,800

-48,800

-11,900

-20,700

-4,600

9,900

-14,700

13,900

0

0

0

Increase (Decrease) in Other Accrued and Current Liabilities

-5,200

-1,300

-5,200

-1,100

900

200

900

0

-3,300

-1,100

200

-600

3,500

500

0

0

0

0

0

-

-

-

0

-

-

-

-1,200

-1,500

-400

-6,600

1,100

-5,400

0

0

0

(Increase) Decrease in Other Long-Term Assets

800

-2,100

-15,200

-13,800

1,300

2,300

5,400

3,900

-3,400

-16,400

-15,300

-14,300

-13,400

-15,500

-14,700

-37,800

-46,700

-34,900

-29,500

2,700

1,400

-19,100

-19,100

-27,800

-15,200

10,700

-10,300

-16,600

-4,900

-900

13,900

27,700

0

0

0

Net Increase (Decrease) in Long-Term Liabilities

-52,000

-54,700

-60,300

-60,500

-71,800

-71,400

-66,900

-67,000

-52,800

-51,700

-44,700

-39,600

-60,800

-57,900

-62,400

-65,000

-79,000

-81,000

-79,300

-70,800

-45,700

-46,000

-45,300

-42,800

-28,500

-31,600

-40,600

-61,300

-82,800

-78,900

-73,500

-58,600

0

0

0

Net, Other Non-Cash Adjustments

-2,900

-4,200

-3,100

-2,000

-2,300

-800

-1,600

-1,700

-1,400

1,300

900

1,900

2,000

1,100

5,100

3,300

7,500

6,000

3,500

3,300

-2,600

-2,200

-2,600

-2,000

-2,200

-200

-100

-3,300

-3,700

-2,400

-8,100

-1,900

0

0

0

Net Cash Provided by Operating Activities from Continuing Operations

-

-

-

-

-

-

-

-

-

-

311,000

336,800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by Operating Activities from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

6,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by Operating Activities

280,200

283,300

284,300

286,500

0

0

0

-

-

-

-

343,200

328,700

311,500

313,800

315,500

310,700

320,300

321,500

333,300

350,000

348,900

362,800

357,800

348,800

342,300

344,300

312,900

311,700

322,600

326,800

319,400

0

0

0

Cash Flows from Investing Activities:
Proceeds from Sales of Businesses and Property, Net of Cash Divested and Transaction Costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

9,100

12,700

12,700

13,100

5,100

500

9,500

10,100

9,200

0

0

0

Payments for Acquisitions of Businesses, Net of Cash Acquired

0

0

0

150,000

150,000

150,000

150,000

0

0

0

320,000

444,200

444,200

444,200

132,500

8,300

0

0

0

-

-

-

-

-

-

-

-

13,500

3,400

204,800

204,800

205,000

0

0

0

Cash Settlements of Foreign Currency Contracts

6,500

-1,400

-8,200

-6,500

-2,900

2,700

10,800

11,400

10,800

17,000

6,100

15,600

14,000

12,900

12,100

7,700

5,000

2,300

6,400

7,200

9,000

900

5,300

-6,000

-3,900

4,600

-1,800

1,000

-4,900

-16,500

-13,800

-3,000

0

0

0

Capital Expenditures

4,900

4,400

6,600

8,400

9,000

10,700

13,500

14,400

18,100

17,500

14,900

12,800

8,800

12,200

9,100

9,800

8,600

5,000

6,400

7,100

11,200

10,400

9,500

7,000

5,300

5,300

5,400

6,200

4,900

5,500

7,900

9,500

0

0

0

Additions to Computer Software and Other Intangibles

52,000

53,600

54,900

53,700

52,200

49,900

46,600

45,800

51,200

50,800

52,500

52,000

47,500

46,100

39,100

37,400

38,700

35,900

38,500

42,200

47,600

56,500

66,000

67,400

67,300

63,300

53,800

47,200

44,800

46,100

49,100

56,400

0

0

0

(Reimbursement) Receipt of Proceeds Related to a Divested Business

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

7,400

0

0

0

-

-

-

-

Net, Other

-600

-700

-400

-300

0

0

0

-

-

-

-100

0

200

200

200

100

0

0

0

-

-

-

-100

-300

2,300

2,200

2,100

2,200

-200

-100

2,800

2,800

0

0

0

Net Cash Used in Investing Activities from Continuing Operations

-

-

-

-

-

-

-

-

-

-

-239,900

-371,100

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Used in Investing Activities from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

-5,400

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Used in Investing Activities

-62,600

-55,600

-54,200

-206,600

0

0

0

-

-

-

-

-376,500

-376,700

-521,300

-200,700

-70,000

-70,500

-60,000

-56,300

-61,600

-66,400

-66,400

-79,600

-59,000

-70,100

-75,900

-64,400

-73,400

-56,400

-239,400

-236,400

-253,600

0

0

0

Cash Flows from Financing Activities:
Payments for Purchases of Treasury Shares

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

225,000

286,900

306,900

397,000

420,000

626,100

587,100

629,000

508,000

303,800

321,900

151,700

185,400

141,600

107,500

103,700

134,800

0

0

0

Net (Payment) Proceeds Related to Stock-Based Plans

-1,000

-1,100

-900

-200

-700

37,800

40,500

44,000

43,400

6,900

5,800

8,400

8,600

8,600

7,000

7,700

23,500

27,000

68,200

69,600

57,700

58,800

15,700

20,100

17,600

19,700

30,400

29,600

32,000

24,700

14,200

8,100

0

0

0

Payment of Debt Issuance Costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,600

2,200

2,200

2,100

1,900

0

0

0

Payments of Dividends

76,700

75,800

75,000

74,200

73,400

72,600

71,500

70,500

69,400

68,400

67,600

66,700

65,800

65,000

64,300

64,000

63,400

62,800

62,700

62,500

63,500

65,300

66,900

69,000

70,000

70,500

70,700

70,400

70,600

70,400

70,100

70,000

0

0

0

Proceeds from Borrowings on Credit Facilities

1,518,700

1,572,400

913,100

1,329,100

878,300

846,600

842,100

439,800

1,066,900

1,000,700

1,135,700

1,509,200

900,900

1,561,500

1,454,800

1,109,100

1,126,500

532,500

570,500

606,200

861,800

888,600

943,300

915,100

1,060,600

998,900

756,600

677,800

341,300

333,500

338,100

321,700

0

0

0

Payments of Borrowings on Credit Facilities

1,355,800

1,423,200

818,500

797,800

785,500

864,100

862,700

622,200

1,295,000

1,130,500

1,475,700

1,731,500

1,072,400

1,639,800

1,264,300

971,100

948,200

372,800

358,400

379,900

775,800

839,200

828,000

934,300

928,300

850,300

809,500

690,400

405,500

395,900

396,600

309,000

0

0

0

Payments of borrowings on Term Loan Facilities

363,800

365,000

25,000

22,500

20,000

20,000

20,000

20,000

20,000

15,000

10,000

5,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess Tax Benefit on Stock-Based Awards

-

-

-

-

-

-

-

7,200

7,300

600

1,200

3,000

3,000

3,100

2,500

1,600

3,500

3,800

4,100

3,500

2,500

2,600

2,200

2,200

1,500

2,600

5,700

5,800

7,100

6,200

3,400

3,200

0

0

0

Capital Lease and Other Long-Term Financing Obligation Payment

-

-

-

-

-

-

-

200

100

100

200

200

300

400

700

600

0

0

0

-

-

-

-

2,000

1,400

1,900

1,900

3,200

7,900

8,700

8,400

5,900

0

0

0

Net, Other

-3,500

-6,000

-3,000

-3,100

-2,900

-1,900

-3,100

-3,000

-3,100

-1,900

-600

-600

-1,300

-800

-800

-700

0

0

0

-

-

-

-

-1,600

-1,400

-100

-1,700

-200

-400

-1,600

-1,000

-2,500

0

0

0

Net Cash (Used in) Provided by Financing Activities

-435,600

-452,200

-459,400

-18,800

-4,200

-67,500

-67,800

-224,900

-170,000

-108,500

-17,300

110,700

66,700

105,700

5,800

-144,400

-147,500

-183,100

-176,500

-184,300

-202,400

-199,700

-223,400

-235,900

-226,500

-224,800

-244,200

-238,000

-248,900

-223,000

-228,000

-192,900

0

0

0

Effect of Exchange Rate Changes on Cash and Cash Equivalents

15,200

23,800

42,000

28,700

2,700

-28,000

-31,200

-52,800

-51,900

-29,400

-42,800

-31,100

-34,800

-36,500

-32,000

-17,600

3,000

12,200

6,800

-600

-3,900

-4,900

-4,700

1,800

-4,700

-6,100

-1,600

4,400

5,900

13,200

2,500

-17,300

0

0

0

Increase (Decrease) in Cash and Cash Equivalents

-202,800

-200,700

-187,300

89,800

100,100

21,100

9,700

-13,100

0

0

0

-

-

-140,600

86,900

83,500

95,700

89,400

95,500

86,800

77,300

77,900

55,100

64,700

47,500

35,500

34,100

5,900

12,300

-126,600

-135,100

-144,400

0

0

0

Supplemental Disclosure of Cash Flow Information:
Cash Paid for:
Income Taxes, Net of Refunds

69,900

59,200

91,600

91,100

84,800

89,400

60,500

70,500

72,700

68,400

74,100

71,200

77,400

101,000

104,300

107,500

120,600

107,400

118,900

120,100

110,800

113,000

97,800

103,200

96,900

99,200

103,200

92,800

86,500

89,300

81,500

78,300

0

0

0

Interest

59,700

56,700

62,900

58,500

54,900

53,500

52,000

51,800

55,400

54,100

51,000

49,900

43,700

44,000

43,000

42,400

42,100

41,400

40,500

39,900

49,000

48,900

46,900

41,800

29,400

29,100

28,200

33,400

34,300

42,300

39,600

48,000

0

0

0