Valaris plc (ESV)
CashFlow / TTM
Mar'20Dec'19Sep'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'10Sep'10Jun'10Mar'10Dec'09Sep'09Jun'09Mar'09
OPERATING ACTIVITIES
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest

-3,011,900

-192,200

-181,300

-126,700

-684,100

-636,600

-640,600

-525,900

-420,100

-304,200

-56,600

58,900

695,800

897,100

-1,613,700

-1,407,200

-1,737,100

-1,585,900

-2,564,100

-2,425,000

-3,857,300

-3,888,500

-76,000

-127,500

1,404,700

1,427,900

1,285,100

1,249,100

1,229,200

1,176,700

1,185,900

1,046,600

807,500

605,600

509,500

435,500

459,800

585,900

661,800

680,500

754,000

784,500

0

0

0

Adjustments to reconcile net loss to net cash used in operating activities:
(Gain) loss on disposal of discontinued operations, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

-

-

-

Asset Impairment Charges

2,912,200

104,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Bargain purchase gain

-

-

-

-

-

1,800

142,000

148,500

156,800

140,200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Depreciation expense

649,200

609,700

568,300

525,900

488,700

478,900

476,000

463,600

450,800

444,800

435,500

436,700

441,200

445,300

484,800

520,600

548,700

572,500

562,200

552,200

543,900

537,900

502,200

499,600

499,400

496,200

421,600

431,400

435,700

443,800

493,500

486,900

434,100

357,600

330,000

249,800

218,200

210,400

210,800

204,100

197,500

189,500

0

0

0

Deferred Income Tax Expense (Benefit)

-61,500

23,900

7,900

58,000

51,200

56,600

65,400

44,900

46,500

55,000

39,600

33,300

15,200

28,700

-189,800

-165,700

-139,700

-158,000

9,800

-84,100

-102,800

-123,500

-51,100

9,400

9,500

10,100

-2,900

7,000

18,000

27,800

15,100

10,000

900

-13,100

-4,100

-700

-4,400

16,700

-2,000

8,400

25,100

20,500

0

0

0

Share-based compensation expense

39,800

37,300

37,000

34,300

26,800

29,900

24,500

28,100

31,300

34,200

42,200

41,900

44,000

39,600

35,000

35,800

37,600

40,200

43,500

43,900

42,700

45,100

47,700

48,400

49,400

50,300

50,400

55,700

54,300

53,200

54,700

49,100

47,900

47,700

44,900

44,300

45,300

44,500

43,900

40,900

39,200

35,500

0

0

0

Business Combination, Bargain Purchase, Adjustment

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Income (Loss) from Equity Method Investments

-18,900

-12,600

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Gain (Loss) on Extinguishment of Debt

197,200

194,100

194,100

0

-200

-19,000

-19,000

-19,000

-18,000

-2,600

6,200

24,400

284,400

287,800

279,000

260,800

-6,900

-33,500

-33,500

-33,500

-26,600

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Amortization, net

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Loss from discontinued operations, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-128,600

-421,600

-389,100

-1,197,400

-1,199,200

-825,800

-844,500

-9,900

-2,200

136,400

130,100

119,400

100,600

0

0

0

-

-

-

-

-

-

-

18,700

29,300

0

0

0

Gain (Loss) on Disposition of Property Plant Equipment

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-27,300

-16,800

-23,200

-11,500

-5,800

-4,500

13,200

16,400

22,500

26,500

54,000

46,100

45,900

38,300

18,300

22,400

19,600

27,900

23,000

17,700

18,100

11,400

4,200

4,700

1,400

7,700

500

3,300

3,100

-6,000

-17,000

-14,700

-4,700

900

3,600

900

-3,900

-6,600

-12,000

-11,100

-15,900

-7,500

0

0

0

Changes in operating assets and liabilities

198,300

27,900

92,600

124,800

27,600

6,300

-14,000

-104,300

-123,600

-72,400

-89,100

-80,800

-244,800

-140,600

-341,600

-205,300

-57,700

-113,500

181,700

-600

-55,700

-93,300

-39,300

-75,300

16,600

151,100

-176,900

-149,300

-171,400

-439,200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Amortization, net

0

-

-

-

0

-

-

-

0

-

-

-

-153,700

-139,700

-183,900

-163,200

-166,000

-165,000

900

-16,700

-9,100

-7,900

-16,200

-17,400

-21,900

-28,400

-30,200

-31,300

-29,800

-33,600

-64,200

-50,600

-36,800

-18,200

30,700

30,200

26,000

31,300

32,800

31,500

33,900

31,000

0

0

0

Contributions to pension plans and other post-retirement benefits

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Net Cash Provided by (Used in) Operating Activities

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Contributions to pension plans and other post-retirement benefits

17,200

13,200

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Decrease (increase) in other assets

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

24,100

10,600

169,000

116,100

88,500

67,600

0

0

0

Decrease (increase) in accounts receivable

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-38,200

-108,600

-251,000

-222,200

-183,800

-167,400

0

0

0

Decrease in trading securities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

-

Increase (decrease) in liabilities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-34,500

-157,400

5,300

-69,600

-35,200

29,300

0

0

0

Net cash provided by operating activities of continuing operations

-

-

-

-

-

-55,700

-42,400

110,900

194,300

259,400

302,200

407,700

948,900

1,077,400

1,418,100

1,607,100

1,463,300

1,697,900

1,819,800

1,986,000

2,092,700

2,057,900

1,974,500

2,042,800

1,945,300

1,811,200

1,707,400

1,669,900

1,697,800

1,954,600

1,952,000

1,597,600

1,187,800

757,400

687,600

607,400

772,500

807,000

809,200

1,004,700

1,035,900

1,185,600

0

0

0

INVESTING ACTIVITIES
Additions to property and equipment

234,300

227,000

222,200

229,600

186,400

426,700

441,300

536,000

523,400

536,700

540,800

445,400

446,700

322,200

429,200

915,000

1,380,500

1,619,500

1,767,400

1,850,900

1,691,200

1,566,700

1,735,000

1,801,800

1,871,400

1,763,500

1,403,000

1,257,500

1,113,800

1,713,200

1,731,100

1,427,200

1,278,800

645,700

636,200

804,300

838,800

875,300

913,600

725,200

840,900

857,200

0

0

0

Proceeds from Sale of Property, Plant, and Equipment

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

-

1,900

1,700

2,000

2,600

0

0

0

Maturities of short-term investments

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Maturities of short-term investments

349,000

145,000

1,120,000

1,179,000

366,000

919,000

1,777,700

1,338,000

424,000

1,040,000

2,643,900

2,609,600

3,359,600

2,474,600

955,300

1,505,300

1,860,000

1,780,000

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Purchases of short-term investments

0

-

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Other

-

-

-

-

-

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

0

0

0

-

-13,200

-12,400

-10,400

-5,300

0

0

0

-

-

-

-

-

-

-

-

Net Cash Provided by (Used in) Investing Activities

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

0

0

-

0

0

0

-

-3,382,600

-3,552,000

-931,700

-873,800

-769,900

-581,700

-734,800

-840,300

0

0

0

FINANCING ACTIVITIES
Borrowings on credit facility

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Repayments of credit facility borrowings

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Reduction of long-term borrowings

937,800

928,100

928,100

0

200

771,200

771,200

771,200

971,400

537,000

538,500

716,100

1,200,500

863,900

862,400

699,300

210,800

1,072,500

1,101,700

1,094,400

914,700

60,100

47,500

47,500

47,500

47,500

47,500

47,500

47,500

47,500

47,500

47,400

220,400

213,300

0

0

0

-

-

-

-

-

-

-

-

Proceeds from short-term borrowings

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Cash dividends paid

0

4,500

9,000

13,400

17,900

17,900

17,800

16,600

15,100

13,800

12,500

12,300

12,400

11,600

43,800

76,200

108,400

141,200

282,200

422,300

562,500

703,000

702,100

643,500

584,800

525,600

437,400

407,600

377,800

348,100

341,800

335,400

328,900

292,300

261,500

230,800

200,400

153,700

107,100

60,700

14,200

14,200

0

0

0

Commercial paper borrowings, net

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-125,000

-175,000

-67,800

200,000

125,000

0

0

0

-

-

-

-

-

-

-

-

Proceeds from issuance of senior notes

-

-

-

-

-

1,000,000

0

0

0

-

-

-

0

-

-

-

-

1,078,700

1,078,700

2,325,100

2,325,100

1,246,400

0

0

0

-

-

-

-

-

-

-

-

2,462,800

0

0

0

-

-

-

-

-

-

-

-

Debt financing costs

-

-

-

-

-

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

Debt issuance costs

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

31,800

0

0

0

-

-

-

-

-

-

-

-

Premium paid on redemption of debt

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

30,300

30,300

30,300

23,400

0

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

Proceeds from exercise of share options

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

22,300

35,700

43,400

37,300

35,800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Other

-8,300

-10,200

-8,700

-5,700

-7,300

-5,700

-7,900

-4,600

-6,500

-7,700

-9,300

-8,800

-9,000

-7,100

-9,900

-11,100

-15,200

-16,000

-18,000

-20,600

-22,300

-27,200

-18,500

-21,300

-22,400

-21,700

-22,800

-20,200

-19,300

-17,400

-44,500

-35,800

-18,800

-15,700

9,500

4,600

-16,100

-16,900

-29,300

-26,100

-12,600

-12,400

0

0

0

Net cash provided by (used in) financing activities

-626,700

-952,300

-814,600

-30,000

-25,600

188,200

179,600

182,100

-17,300

-570,500

260,300

83,400

185,200

529,000

-330,600

-201,100

-342,900

-191,800

-366,100

733,600

779,900

442,700

462,700

-716,600

-650,400

-577,100

-472,000

-454,000

-540,600

-435,500

-480,000

-435,300

-393,100

2,004,100

2,079,500

2,097,300

2,198,800

-192,600

-143,900

-96,600

-34,400

-34,200

0

0

0

DISCONTINUED OPERATIONS
Operating activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-27,100

33,500

3,800

-3,800

96,700

75,200

109,500

169,300

324,800

290,500

284,300

232,500

0

0

0

-

-

-

-

11,100

-7,100

29,000

35,100

40,200

0

0

0

Investing activities

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

51,400

49,900

106,600

107,200

81,900

81,000

21,900

32,800

5,700

12,300

70,200

58,300

0

0

0

-

-

-

-

158,100

141,800

141,800

104,100

14,300

0

0

0

Net cash provided by (used in) discontinued operations

-

-

-

-

-

2,500

2,100

1,900

2,300

-800

600

500

2,200

8,400

11,700

3,800

5,200

-8,700

24,300

83,400

110,400

103,400

178,600

156,200

131,400

202,100

330,500

302,800

354,500

290,800

0

0

0

-

-

-

-

-

-

-

-

-

-

-

-

Effect of Exchange Rate on Cash and Cash Equivalents [Abstract]
Effect of exchange rate changes on cash and cash equivalents

-300

-300

-500

-200

-600

-600

-800

-700

200

600

-100

-400

-1,200

-1,400

-900

-900

-500

-300

0

0

0

-

-

1,000

-100

-200

-900

-200

1,500

2,000

1,800

300

-400

-800

-700

300

100

-500

-300

-300

300

500

0

0

0

INCREASE IN CASH AND CASH EQUIVALENTS

-113,500

-177,900

-66,500

473,600

-167,000

-170,300

-528,400

315,900

193,700

-714,300

259,000

-620,700

-812,300

1,038,400

225,000

142,000

196,200

-543,500

-933,300

503,300

765,300

499,200

848,300

-344,800

-439,300

-321,500

165,600

263,100

352,900

56,400

-320,100

-327,300

-3,223,200

-620,000

-425,300

-683,100

2,202,700

-90,700

-112,000

355,100

302,100

351,800

0

0

0