Valaris plc ESV Cash Flow

Valaris plc (ESV)

CashFlow / Quarterly

Mar'20	Dec'19	Sep'19	Jun'19	Mar'19	Dec'18	Sep'18	Jun'18	Mar'18	Dec'17	Sep'17	Jun'17	Mar'17	Dec'16	Sep'16	Jun'16	Mar'16	Dec'15	Sep'15	Jun'15	Mar'15	Dec'14	Sep'14	Jun'14	Mar'14	Dec'13	Sep'13	Jun'13	Mar'13	Dec'12	Sep'12	Jun'12	Mar'12	Dec'11	Sep'11	Jun'11	Mar'11	Dec'10	Sep'10	Jun'10	Mar'10	Dec'09	Sep'09	Jun'09	Mar'09
OPERATING ACTIVITIES
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest
-3,007,700	-214,000	-197,500	407,300	-188,000	-203,100	-142,900	-150,100	-140,500	-207,100	-28,200	-44,300	-24,600	40,500	87,300	592,600	176,700	-2,470,300	293,800	262,700	327,900	-3,448,500	432,900	-1,169,600	296,700	364,000	381,400	362,600	319,900	221,200	345,400	342,700	267,400	230,400	206,100	103,600	65,500	134,300	132,100	127,900	191,600	210,200	150,800	201,400	222,100
Adjustments to reconcile net loss to net cash used in operating activities:
(Gain) loss on disposal of discontinued operations, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	5,700	29,200	-	-	-	-
Asset Impairment Charges
2,808,200	13,300	88,200	2,500	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Bargain purchase gain
-	-	-	-	-	0	-6,500	-8,300	16,600	140,200	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Depreciation expense
164,500	163,800	163,000	157,900	125,000	122,400	120,600	120,700	115,200	119,500	108,200	107,900	109,200	110,200	109,400	112,400	113,300	149,700	145,200	140,500	137,100	139,400	135,200	132,200	131,100	103,700	132,600	132,000	127,900	29,100	142,400	136,300	136,000	78,800	135,800	83,500	59,500	51,200	55,600	51,900	51,700	51,600	48,900	45,300	43,700
Deferred Income Tax Expense (Benefit)
-79,500	27,700	-21,100	11,400	5,900	11,700	29,000	4,600	11,300	20,500	8,500	6,200	19,800	5,100	2,200	-11,900	33,300	-213,400	26,300	14,100	15,000	-45,600	-67,600	-4,600	-5,700	26,800	-7,100	-4,500	-5,100	13,800	2,800	6,500	4,700	1,100	-2,300	-2,600	-9,300	10,100	1,100	-6,300	11,800	-8,600	11,500	10,400	7,200
Share-based compensation expense
7,800	8,600	9,500	13,900	5,300	8,300	6,800	6,400	8,400	2,900	10,400	9,600	11,300	10,900	10,100	11,700	6,900	6,300	10,900	13,500	9,500	9,600	11,300	12,300	11,900	12,200	12,000	13,300	12,800	12,300	17,300	11,900	11,700	13,800	11,700	10,700	11,500	11,000	11,100	11,700	10,700	10,400	8,100	10,000	7,000
Business Combination, Bargain Purchase, Adjustment
6,300	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Income (Loss) from Equity Method Investments
-6,300	-9,500	-3,700	600	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain (Loss) on Extinguishment of Debt
3,100	0	194,100	0	0	0	0	-200	-18,800	0	0	800	-3,400	8,800	18,200	260,800	0	0	0	-6,900	-26,600	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Amortization, net
2,800	-	-	-	-14,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss from discontinued operations, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-95,000	-23,300	-10,100	-200	-388,000	9,200	-818,400	-2,000	-14,600	-9,500	16,200	5,700	124,000	-15,800	5,500	-13,100	-	-	-	-	-	-	-	400	9,900	5,800	2,600	11,000
Gain (Loss) on Disposition of Property Plant Equipment
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
-9,700	-3,400	-8,500	-5,700	800	-9,800	3,200	0	2,100	7,900	6,400	6,100	6,100	35,400	-1,500	5,900	-1,500	15,400	2,600	3,100	6,800	10,500	-2,700	3,500	100	3,300	-2,200	200	6,400	-3,900	600	0	-2,700	-14,900	2,900	10,000	2,900	-12,200	200	5,200	200	-17,600	1,100	400	8,600
Changes in operating assets and liabilities
129,900	-119,400	42,500	145,300	-40,500	-54,700	74,700	48,100	-61,800	-75,000	-15,600	28,800	-10,600	-91,700	-7,300	-135,200	93,600	-292,700	129,000	12,400	37,800	2,500	-53,300	-42,700	200	56,500	-89,300	49,200	134,700	-271,500	-61,700	27,100	-133,100	-	-	-	-	-	-	-	-	-	-	-	-
Amortization, net
14,200	-	-	-	2,200	-	-	-	-16,800	-	-	-	-19,000	-123,500	-5,000	-6,200	-5,000	-167,700	15,700	-9,000	-4,000	-1,800	-1,900	-1,400	-2,800	-10,100	-3,100	-5,900	-9,300	-11,900	-4,200	-4,400	-13,100	-42,500	9,400	9,400	5,500	6,400	8,900	5,200	10,800	7,900	7,600	7,600	7,900
Contributions to pension plans and other post-retirement benefits
4,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net Cash Provided by (Used in) Operating Activities
-204,400	-	-	-	-24,400	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Contributions to pension plans and other post-retirement benefits
4,000	5,200	4,000	4,000	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Decrease (increase) in other assets
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	9,200	-14,800	25,500	4,200	-4,300	143,600	-27,400	-23,400	-25,200
Decrease (increase) in accounts receivable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	55,700	-174,700	90,000	-9,200	-14,700	-317,100	118,800	29,200	1,700
Decrease in trading securities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-49,300	-	-	-	-5,400	-	-	-	-
Increase (decrease) in liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	11,000	-110,400	50,600	14,300	-111,900	52,300	-24,300	48,700	-47,400
Net cash provided by operating activities of continuing operations
-	-	-	-	-	26,500	-64,200	-57,500	39,500	39,800	89,100	25,900	104,600	82,600	194,600	567,100	233,100	423,300	383,600	423,300	467,700	545,200	549,800	530,000	432,900	461,800	618,100	432,500	298,800	358,000	580,600	460,400	555,600	355,400	226,200	50,600	125,200	285,600	146,000	215,700	159,700	287,800	341,500	246,900	309,400
INVESTING ACTIVITIES
Additions to property and equipment
36,300	52,800	39,400	105,800	29,000	48,000	46,800	62,600	269,300	62,600	141,500	50,000	282,600	66,700	46,100	51,300	158,100	173,700	531,900	516,800	397,100	321,600	615,400	357,100	272,600	489,900	682,200	426,700	164,700	129,400	536,700	283,000	764,100	147,300	232,800	134,600	131,000	137,800	400,900	169,100	167,500	176,100	212,500	284,800	183,800
Proceeds from Sale of Property, Plant, and Equipment
10,400	-	-	-	300	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,700	43,900	500	-	400	500	200	800	200	800	800
Maturities of short-term investments
-	-	-	-	-	-	-	-	390,000	-	-	-	602,000	-	-	-	965,000	-	-	-	12,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Maturities of short-term investments
0	619,000	-135,000	-135,000	-204,000	1,594,000	-76,000	-948,000	349,000	2,452,700	-515,700	-1,862,000	965,000	4,056,600	-550,000	-1,112,000	80,000	2,537,300	0	-757,300	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Purchases of short-term investments
0	-	0	25,000	120,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
-	-	-	-	-	-	-7,100	-2,800	-100	-	-900	-1,500	-200	-	-100	-7,500	-100	-	-300	-700	-400	-	-7,400	-1,600	-800	-	-2,300	-600	-900	-	-800	2,500	-5,100	-9,800	0	4,500	0	-	-	-	-	-	-	-	-
Net Cash Provided by (Used in) Investing Activities
-25,900	-	-	-	55,300	-	-	-	-228,200	-	-	-	-645,400	-	-	-	727,000	-	-	-	-384,700	-	-	-	-271,800	-	-	-376,100	-163,800	-	-535,900	-281,000	-759,000	-	-231,100	-2,751,200	-130,500	-269,800	-400,500	-130,900	-72,600	-165,900	-212,300	-284,000	-178,100
FINANCING ACTIVITIES
Borrowings on credit facility
343,900	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of credit facility borrowings
15,000	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Reduction of long-term borrowings
9,700	0	928,100	0	0	0	0	200	771,000	0	0	200,400	336,600	1,500	177,600	684,800	0	0	14,500	196,300	861,700	29,200	7,200	16,600	7,100	16,600	7,200	16,600	7,100	16,600	7,200	16,600	7,100	16,600	7,100	189,600	0	-	-	-	-	-	-	-	-
Proceeds from short-term borrowings
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-
Cash dividends paid
0	0	0	0	4,500	4,500	4,400	4,500	4,500	4,400	3,200	3,000	3,200	3,100	3,000	3,100	2,400	35,300	35,400	35,300	35,200	176,300	175,500	175,500	175,700	175,400	116,900	116,800	116,500	87,200	87,100	87,000	86,800	80,900	80,700	80,500	50,200	50,100	50,000	50,100	3,500	3,500	3,600	3,600	3,500
Commercial paper borrowings, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-22,100	-177,900	75,000	-50,000	85,100	89,900	0	-	-	-	-	-	-	-	-
Proceeds from issuance of senior notes
-	-	-	-	-	0	0	0	1,000,000	-	-	-	0	-	-	-	-	0	0	0	1,078,700	0	1,246,400	0	0	-	-	-	-	-	-	-	-	0	0	0	2,462,800	-	-	-	-	-	-	-	-
Debt financing costs
-	-	-	-	-	-	-	-	16,800	-	-	-	4,500	-	-	-	0	-	-	-	8,900	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-
Debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-100	100	6,300	25,500	-	-	-	-	-	-	-	-
Premium paid on redemption of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	6,900	23,400	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from exercise of share options
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	300	0	8,600	13,400	13,700	7,700	2,500	11,900	-	-	-	-	-	-	-	-	-	-	-	-
Other
-900	-2,500	-7,200	2,300	-2,800	-1,000	-4,200	700	-1,200	-3,200	-900	-1,200	-2,400	-4,800	-400	-1,400	-500	-7,600	-1,600	-5,500	-1,300	-9,600	-4,200	-7,200	-6,200	-900	-7,000	-8,300	-5,500	-2,000	-4,400	-7,400	-3,600	-29,100	4,300	9,600	-500	-3,900	-600	-11,100	-1,300	-16,300	2,600	2,400	-1,100
Net cash provided by (used in) financing activities
318,300	-143,200	-791,200	-10,600	-7,300	-5,500	-6,600	-6,200	206,500	-14,100	-4,100	-205,600	-346,700	816,700	-181,000	-103,800	-2,900	-42,900	-51,500	-245,600	148,200	-217,200	1,048,200	-199,300	-189,000	-197,200	-131,100	-133,100	-115,700	-92,100	-113,100	-219,700	-10,600	-136,600	-68,400	-177,500	2,386,600	-61,200	-50,600	-76,000	-4,800	-12,500	-3,300	-13,800	-4,600
DISCONTINUED OPERATIONS
Operating activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-8,500	4,500	-8,700	-14,400	52,100	-25,200	-16,300	86,100	30,600	9,100	43,500	241,600	-3,700	2,900	-8,300	-	-	-	-	32,800	-27,000	-900	6,200	14,600	9,100	5,200	11,300
Investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	300	-1,000	400	51,700	-1,200	55,700	1,000	26,400	-2,100	-3,400	11,900	-700	4,500	54,500	0	-	-	-	-	25,700	0	37,700	94,700	9,400	0	0	4,900
Net cash provided by (used in) discontinued operations
-	-	-	-	-	0	0	0	2,500	-400	-200	400	-600	1,000	-300	2,100	5,600	4,300	-8,200	3,500	-8,300	37,300	50,900	30,500	-15,300	112,500	28,500	5,700	55,400	240,900	800	57,400	-8,300	-	-	-	-	-	-	-	-	-	-	-	-
Effect of Exchange Rate on Cash and Cash Equivalents [Abstract]
Effect of exchange rate changes on cash and cash equivalents
-300	300	-300	0	-300	100	0	-400	-300	-100	100	500	100	-800	-200	-300	-100	-300	-200	100	100	-	-	100	100	800	0	-1,000	0	100	700	700	500	-100	-800	0	100	0	200	-200	-500	200	200	400	-300
INCREASE IN CASH AND CASH EQUIVALENTS
87,700	-32,300	-829,600	660,700	23,300	79,100	-289,500	20,100	20,000	-279,000	554,800	-102,100	-888,000	694,300	-324,900	-293,700	962,700	-119,100	-407,900	-239,500	223,000	-508,900	1,028,700	22,500	-43,100	-159,800	-164,400	-72,000	74,700	327,300	-66,900	17,800	-221,800	-49,200	-74,100	-2,878,100	2,381,400	145,500	-331,900	7,700	88,000	124,200	135,200	-45,300	137,700