Dun & bradstreet corp/nw (DNB)
CashFlow / Quarterly
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

51,700

94,700

65,600

25,800

55,800

46,700

16,700

79,500

-27,700

19,900

30,700

77,900

59,900

-6,600

41,900

92,600

68,400

50,900

86,000

76,600

73,500

58,400

53,600

95,200

80,700

56,500

64,100

94,400

58,800

58,700

48,300

91,900

56,800

56,400

45,800

Loss on Disposal of Business - Discontinued Operations

0

0

0

0

0

0

-800

-3,200

-900

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

0

-100

700

1,500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Income from Continuing Operations

51,700

94,700

65,600

25,800

55,800

46,700

17,500

82,700

-26,800

19,900

30,700

77,100

60,100

30,900

40,400

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

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

22,600

22,700

21,100

21,300

20,100

19,400

18,900

17,700

17,200

17,300

16,400

16,100

16,100

14,100

12,400

12,400

13,300

10,900

15,900

6,800

17,400

17,900

18,300

18,400

20,000

19,700

20,200

20,500

20,600

20,600

19,400

19,800

17,100

16,000

15,200

Amortization of Unrecognized Pension Loss

10,500

10,400

10,200

9,500

9,500

9,400

9,500

8,900

9,100

8,800

9,000

9,800

9,700

10,100

10,200

8,300

7,900

8,400

8,300

8,400

8,500

8,200

8,300

5,800

5,800

6,000

5,900

3,400

3,500

3,800

3,900

2,500

2,300

3,700

3,700

(Gain) Loss from Sales of Business

0

0

0

0

0

0

-700

-5,500

-89,600

0

0

-

-

-

-

-

-

-

-

-

-

-

-

100

0

0

6,000

0

-8,600

-3,100

0

-

-

-

-

Impairment of Assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

3,200

12,900

3,300

0

0

0

-

-

-

-

Income Tax Benefit from Stock-Based Awards

200

300

4,200

400

100

1,100

5,300

500

9,800

1,000

2,900

900

200

1,600

4,300

700

200

500

3,000

4,600

1,200

3,900

2,500

2,100

1,200

700

3,000

800

2,900

5,000

3,500

2,700

1,800

1,100

3,600

Equity-Based Compensation Expense

4,100

3,900

-700

4,200

5,400

5,500

5,400

5,800

5,700

5,300

4,400

2,800

4,500

5,100

2,300

3,500

3,100

2,600

2,000

500

1,200

3,400

3,400

1,800

3,000

2,700

3,100

3,200

3,200

2,400

3,600

3,000

3,700

6,200

5,400

Excess Tax Benefit on Stock-Based Awards

-

-

-

-

-

-

-

100

6,700

200

200

200

0

800

2,000

200

100

200

1,100

2,100

400

500

500

1,100

500

100

500

400

1,600

3,200

600

1,700

700

400

400

Restructuring Charge

2,100

10,500

11,000

9,800

5,800

7,500

9,000

3,300

3,200

5,900

9,700

17,200

5,500

4,800

4,800

3,000

2,000

5,000

4,900

3,300

6,100

2,200

2,300

6,200

4,800

9,300

9,100

4,100

5,300

8,500

4,200

4,700

3,900

1,600

4,600

Restructuring Payments

8,700

8,900

10,400

7,100

6,200

7,900

4,500

4,300

7,700

10,300

10,400

7,800

4,900

5,400

2,800

2,700

3,800

3,000

5,900

3,200

4,100

3,400

4,000

4,500

10,400

8,300

5,000

4,500

6,900

4,200

4,100

4,700

4,200

4,400

6,600

Changes in Deferred Income Taxes, Net

-2,900

-22,500

-8,400

-31,400

1,800

-3,600

1,300

-7,200

-100

0

1,600

-12,700

0

0

0

-13,100

21,000

-2,200

62,000

-17,400

-700

-500

0

20,500

-30,200

1,000

3,800

15,100

3,300

-13,000

6,300

14,000

10,200

3,000

-1,500

Changes in Accrued Income Taxes, Net

-4,800

-36,800

-3,600

71,900

18,800

-38,800

-2,100

28,400

-1,600

-10,700

-6,700

3,100

-4,200

-15,700

100

12,100

1,500

-9,100

5,700

-14,300

17,800

-22,400

3,500

-17,400

13,900

-6,800

-21,700

300

-3,500

-10,800

6,500

7,600

-3,400

-5,200

25,700

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

-38,200

36,600

-57,800

194,000

12,300

-51,400

-120,700

155,500

-4,500

-25,600

-79,600

145,000

6,900

-61,200

-66,200

127,700

12,600

-64,600

-68,200

132,700

20,700

-63,300

-83,300

123,600

19,200

-62,500

-65,900

129,000

3,100

-57,200

-62,900

110,100

-22,400

-35,400

-21,000

(Increase) Decrease in Other Current Assets

-4,100

7,900

1,200

2,600

2,300

-1,800

-1,600

1,600

-7,700

200

-1,200

1,400

2,600

-900

-7,800

1,200

1,000

5,000

-2,000

3,600

-500

-6,400

-11,600

15,200

-3,000

-5,300

-15,900

19,300

500

4,200

-8,100

1,000

700

5,300

2,400

Increase (Decrease) in Deferred Revenue

-61,500

11,200

26,000

73,500

-35,100

-23,700

13,500

46,200

-20,600

-33,700

16,100

70,100

-18,200

-39,400

28,900

59,300

-46,500

-51,300

26,600

55,400

-40,500

-52,100

26,700

65,800

-34,100

-50,600

27,800

68,800

-44,900

-49,300

26,400

57,900

-32,300

-23,200

44,200

Increase (Decrease) in Accounts Payable

-5,500

-19,400

10,700

-3,300

1,300

-3,500

-6,200

-7,500

3,000

3,100

20,000

-7,300

-5,400

-12,400

26,900

-6,000

-2,900

-5,800

9,100

4,500

-5,200

-2,300

1,500

200

-9,100

10,100

2,600

5,900

3,100

-8,600

1,600

-500

-14,700

4,800

2,500

Increase (Decrease) in Accrued Liabilities

25,000

8,200

-74,100

11,900

19,500

800

-62,200

38,400

18,200

36,300

-39,200

25,100

9,200

11,200

-44,100

11,700

25,600

9,700

-25,400

18,200

10,000

0

-37,900

11,300

17,100

-15,800

-43,200

-11,900

22,100

21,100

-52,000

4,200

36,600

-3,500

-23,400

Increase (Decrease) in Other Accrued and Current Liabilities

6,700

-6,700

6,700

-11,900

10,600

-10,600

10,800

-9,900

9,900

-9,900

9,900

-13,200

12,100

-8,600

9,100

-9,100

9,100

-9,100

9,100

-

-

-

9,100

-

-

-

8,200

-7,400

7,800

-9,800

7,900

-6,300

1,600

-2,100

1,400

(Increase) Decrease in Other Long-Term Assets

3,900

3,800

-5,700

-1,200

1,000

-9,300

-4,300

13,900

2,000

-6,200

-5,800

6,600

-11,000

-5,100

-4,800

7,500

-13,100

-4,300

-27,900

-1,400

-1,300

1,100

4,300

-2,700

-21,800

1,100

-4,400

9,900

4,100

-19,900

-10,700

21,600

8,100

-5,100

3,100

Net Increase (Decrease) in Long-Term Liabilities

-12,000

-12,900

-17,000

-10,100

-14,700

-18,500

-17,200

-21,400

-14,300

-14,000

-17,300

-7,200

-13,200

-7,000

-12,200

-28,400

-10,300

-11,500

-14,800

-42,400

-12,300

-9,800

-6,300

-17,300

-12,600

-9,100

-3,800

-3,000

-15,700

-18,100

-24,500

-24,500

-11,800

-12,700

-9,600

Net, Other Non-Cash Adjustments

-1,000

-300

-1,200

-400

-2,300

800

-100

-700

-800

0

-200

-400

1,900

-400

800

-300

1,000

3,600

-1,000

3,900

-500

1,100

-1,200

-2,000

-100

700

-600

-2,200

1,900

800

-3,800

-2,600

3,200

-4,900

2,400

Net Cash Provided by Operating Activities from Continuing Operations

-

-

-

-

-

-

-

-

-

-

130,500

53,300

71,100

56,100

156,300

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by Operating Activities from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

0

1,100

2,800

2,500

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by Operating Activities

72,700

51,700

121,600

34,200

75,800

52,700

123,800

-

-

-

-

53,300

72,200

58,900

158,800

38,800

55,000

61,200

160,500

34,000

64,600

62,400

172,300

50,700

63,500

76,300

167,300

41,700

57,000

78,300

135,900

40,500

67,900

82,500

128,500

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,200

0

-100

8,000

4,800

0

300

0

200

9,000

900

-900

Payments for Acquisitions of Businesses, Net of Cash Acquired

0

0

0

0

0

0

150,000

0

0

0

0

0

0

320,000

124,200

0

0

8,300

0

-

-

-

-

-

-

-

-

11,800

1,400

0

300

1,700

202,800

0

500

Cash Settlements of Foreign Currency Contracts

1,000

5,900

-2,700

2,300

-6,900

-900

-1,000

5,900

-1,300

7,200

-400

5,300

4,900

-3,700

9,100

3,700

3,800

-4,500

4,700

1,000

1,100

-400

5,500

2,800

-7,000

4,000

-5,800

4,900

1,500

-2,400

-3,000

-1,000

-10,100

300

7,800

Capital Expenditures

1,400

800

1,000

1,700

900

3,000

2,800

2,300

2,600

5,800

3,700

6,000

2,000

3,200

1,600

2,000

5,400

100

2,300

800

1,800

1,500

3,000

4,900

1,000

600

500

3,200

1,000

700

1,300

1,900

1,600

3,100

2,900

Additions to Computer Software and Other Intangibles

13,100

13,500

13,900

11,500

14,700

14,800

12,700

10,000

12,400

11,500

11,900

15,400

12,000

13,200

11,400

10,900

10,600

6,200

9,700

12,200

7,800

8,800

13,400

17,600

16,700

18,300

14,800

17,500

12,700

8,800

8,200

15,100

14,000

11,800

15,500

(Reimbursement) Receipt of Proceeds Related to a Divested Business

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

3,800

3,600

-

-

-

-

Net, Other

0

-200

-200

-200

-100

100

-100

-

-

-

0

-100

0

0

100

100

0

0

0

-

-

-

100

-200

0

0

-100

2,400

-100

-100

0

0

0

2,800

0

Net Cash Used in Investing Activities from Continuing Operations

-

-

-

-

-

-

-

-

-

-

-15,200

-18,400

126,400

-332,700

-146,400

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Used in Investing Activities from Discontinued Operations

-

-

-

-

-

-

-

-

-

-

-

0

-3,000

-1,400

-1,000

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Used in Investing Activities

-15,000

-20,300

-12,000

-15,300

-8,000

-18,900

-164,400

-

-

-

-

-18,400

123,400

-334,100

-147,400

-18,600

-21,200

-13,500

-16,700

-19,100

-10,700

-9,800

-22,000

-23,900

-10,700

-23,000

-1,400

-35,000

-16,500

-11,500

-10,400

-18,000

-199,500

-8,500

-27,600

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

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

55,000

72,000

98,000

61,900

75,000

162,100

121,000

268,000

36,000

204,000

0

63,800

54,100

33,800

33,700

20,000

20,000

30,000

64,800

Net (Payment) Proceeds Related to Stock-Based Plans

-100

2,900

-6,000

2,200

-200

3,100

-5,300

1,700

38,300

5,800

-1,800

1,100

1,800

4,700

800

1,300

1,800

3,100

1,500

17,100

5,300

44,300

2,900

5,200

6,400

1,200

7,300

2,700

8,500

11,900

6,500

5,100

1,200

1,400

400

Payment of Debt Issuance Costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1,300

0

100

200

1,900

0

0

0

Payments of Dividends

19,400

19,400

19,300

18,600

18,500

18,600

18,500

17,800

17,700

17,500

17,500

16,700

16,700

16,700

16,600

15,800

15,900

16,000

16,300

15,200

15,300

15,900

16,100

16,200

17,100

17,500

18,200

17,200

17,600

17,700

17,900

17,400

17,400

17,400

17,800

Proceeds from Borrowings on Credit Facilities

89,100

795,600

74,900

559,100

142,800

136,300

490,900

108,300

111,100

131,800

88,600

735,400

44,900

266,800

462,100

127,100

705,500

160,100

116,400

144,500

111,500

198,100

152,100

400,100

138,300

252,800

123,900

545,600

76,600

10,500

45,100

209,100

68,800

15,100

28,700

Payments of Borrowings on Credit Facilities

89,900

743,300

417,000

105,600

157,300

138,600

396,300

93,300

235,900

137,200

155,800

766,100

71,400

482,400

411,600

107,000

638,800

106,900

118,400

84,100

63,400

92,500

139,900

480,000

126,800

81,300

246,200

474,000

48,800

40,500

127,100

189,100

39,200

41,200

39,500

Payments of borrowings on Term Loan Facilities

3,800

345,000

7,500

7,500

5,000

5,000

5,000

5,000

5,000

5,000

5,000

5,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Excess Tax Benefit on Stock-Based Awards

-

-

-

-

-

-

-

100

6,700

200

200

200

0

800

2,000

200

100

200

1,100

2,100

400

500

500

1,100

500

100

500

400

1,600

3,200

600

1,700

700

400

400

Capital Lease and Other Long-Term Financing Obligation Payment

-

-

-

-

-

-

-

0

0

100

100

-100

0

200

100

0

100

500

0

-

-

-

-

-200

700

300

1,200

-800

1,200

300

2,500

3,900

2,000

0

0

Net, Other

-100

-3,200

-100

-100

-2,600

-200

-200

100

-1,600

-1,400

-100

0

-400

-100

-100

-700

100

-100

0

-

-

-

-

-200

-1,100

-200

-100

0

200

-1,800

1,400

-200

-1,000

-1,200

-100

Net Cash (Used in) Provided by Financing Activities

-24,200

-15,900

-375,000

-20,500

-40,800

-23,100

65,600

-5,900

-104,100

-23,400

-91,500

49,000

-42,600

67,800

36,500

5,000

-3,600

-32,100

-113,700

1,900

-39,200

-25,500

-121,500

-16,200

-36,500

-49,200

-134,000

-6,800

-34,800

-68,600

-127,800

-17,700

-8,900

-73,600

-92,700

Effect of Exchange Rate Changes on Cash and Cash Equivalents

-4,800

-4,100

11,100

13,000

3,800

14,100

-2,200

-13,000

-26,900

10,900

-23,800

-12,100

-4,400

-2,500

-12,100

-15,800

-6,100

2,000

2,300

4,800

3,100

-3,400

-5,100

1,500

2,100

-3,200

1,400

-5,000

700

1,300

7,400

-3,500

8,000

-9,400

-12,400

Increase (Decrease) in Cash and Cash Equivalents

28,700

11,400

-254,300

11,400

30,800

24,800

22,800

21,700

-48,200

13,400

0

-

-

-209,900

35,800

9,400

24,100

17,600

32,400

21,600

17,800

23,700

23,700

12,100

18,400

900

33,300

-5,100

6,400

-500

5,100

1,300

-132,500

-9,000

-4,200

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

17,600

20,500

6,800

25,000

6,900

52,900

6,300

18,700

11,500

24,000

16,300

20,900

7,200

29,700

13,400

27,100

30,800

33,000

16,600

40,200

17,600

44,500

17,800

30,900

19,800

29,300

23,200

24,600

22,100

33,300

12,800

18,300

24,900

25,500

9,600

Interest

7,100

19,100

7,600

25,900

4,100

25,300

3,200

22,300

2,700

23,800

3,000

25,900

1,400

20,700

1,900

19,700

1,700

19,700

1,300

19,400

1,000

18,800

700

28,500

900

16,800

-4,400

16,100

600

15,900

800

17,000

8,600

13,200

9,200