Zayo Group Holdings, Inc. ZAYO Cash Flow

Zayo group holdings, inc. (ZAYO)

CashFlow / Quarterly

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
Cash flows from operating activities
Net income/(loss)
61,400	17,900	63,000	34,700	30,200	22,100	42,900	23,500	13,200	23,300	24,600	27,000	19,800	15,700	-30,900	-19,300	-10,800	-15,200	5,100	-53,700	3,800	-110,500	-73,500	-41,600	-36,800	-27,400
Earnings from discontinued operations, net of income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,300	1,100	800	1,700
Loss from continuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-12,500	-	-	-	-	-72,200	-42,700	-37,600	-29,100
Adjustments to reconcile net income to net cash provided by operating activities
Depreciation and amortization
157,900	156,100	157,500	161,200	146,900	167,800	176,100	190,900	195,700	183,800	180,600	155,700	131,400	138,500	148,300	137,200	113,700	117,100	113,200	100,100	96,900	96,000	91,300	84,200	81,700	81,000
Loss on extinguishment of debt
-	-	-	-	-	-	0	0	0	-4,900	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of SRT
-	-	0	0	0	5,500	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash interest expense
2,800	2,700	2,700	2,600	2,500	2,500	100	4,900	2,400	2,400	1,900	2,600	2,500	2,600	2,800	2,500	3,100	3,500	3,400	6,900	6,700	2,700	7,200	4,400	4,000	6,500
Stock-based compensation
27,000	27,200	29,400	27,000	26,200	26,700	26,200	19,200	23,500	27,800	21,100	26,500	34,500	32,000	33,400	33,500	42,900	46,100	42,900	40,700	-6,000	123,100	88,600	65,200	57,000	42,900
Amortization of deferred revenue
41,400	40,300	39,200	38,600	37,300	37,000	36,000	34,700	33,200	32,400	31,000	29,900	28,100	27,500	44,900	24,700	21,500	20,400	19,200	18,300	17,300	17,300	15,200	14,200	13,600	12,600
Foreign currency (gain)/loss on intercompany loans
27,400	-12,900	-8,300	7,100	-8,300	-4,600	-22,400	13,900	3,100	10,800	14,400	3,900	-17,400	-11,200	-24,900	-11,100	-7,100	-10,700	16,800	-13,300	-13,200	-14,700	-	-	-	-
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	7,900	-	-	-	-	-	-	-	-
Deferred income taxes
16,900	11,800	-35,900	4,700	16,500	15,900	-16,700	21,800	14,500	2,700	19,800	-5,900	-5,300	4,800	-17,100	6,000	6,300	2,000	6,800	-19,400	-6,900	6,200	-	-	7,100	8,500
Provision for bad debts
2,300	2,600	1,500	4,600	2,600	1,500	-700	3,500	1,500	800	1,600	700	500	900	800	600	1,900	600	600	400	300	600	300	800	400	400
Non-cash loss on investments
-	-	0	200	300	300	400	200	200	100	400	200	200	300	0	600	400	200	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities
Trade receivables
-27,000	-20,900	-38,500	17,400	-18,400	-4,500	14,400	-7,800	9,500	32,000	1,200	-10,500	14,600	1,900	13,400	0	-20,900	5,600	-7,300	13,500	9,000	-4,000	3,600	-9,300	-7,200	-7,600
Prepaid expenses
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,700	-2,300	2,100	600	2,500	-100	-1,600
Payables to/(from) related parties, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,700
Accounts payable and accrued liabilities
-25,800	27,300	-33,300	46,100	-35,900	9,000	-16,400	-5,500	-24,200	53,400	-3,900	42,100	-38,600	5,600	8,700	-18,700	-50,500	24,500	24,300	21,100	-20,700	-46,800	26,500	-16,300	16,000	-32,800
Additions to deferred revenue
59,600	81,400	54,400	57,600	50,600	30,500	74,800	76,100	21,400	40,500	43,800	72,400	43,400	40,900	38,600	58,800	36,900	49,700	25,500	39,500	40,900	43,200	51,200	65,200	23,400	24,000
Other assets and liabilities
3,900	8,700	21,800	22,000	-1,300	1,100	7,000	31,000	14,500	-4,300	12,100	40,100	-6,600	-9,700	8,800	-8,800	4,200	10,100	10,500	-200	11,900	-4,400	-	-	-	-
Net cash provided by operating activities
256,400	311,800	225,100	253,600	230,600	241,800	251,700	262,800	187,900	268,800	244,900	262,400	169,700	232,800	176,200	196,400	146,200	195,200	195,000	168,500	123,700	118,200	168,100	159,000	142,300	97,100
Other assets, current and non-current
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,500
Other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-1,100
Cash flows from investing activities
Purchases of property and equipment
254,600	217,100	195,800	206,400	202,200	182,500	208,000	195,100	193,400	193,400	205,300	208,300	213,600	208,300	187,400	185,100	172,400	159,200	155,500	130,100	129,500	115,300	94,900	90,900	88,300	86,700
Proceeds from sale of SRT, net of cash held in escrow
-	-	0	0	0	39,000	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
-	-	-	-	-	-	-	-	-	-	-	0	0	-1,500	-	-	0	300	-	0	0	100	-	-	-	-
Net cash used in investing activities
-254,600	-217,100	-195,800	-206,400	-202,200	-143,500	-229,400	-350,400	-193,600	-193,400	-217,100	-1,631,500	-214,900	-206,800	-207,900	-484,100	-290,100	-159,500	-153,900	-860,900	-129,500	-241,800	-387,200	-108,400	-171,500	-87,000
Cash flows from financing activities
Proceeds from debt
-	-	-	-	-	-	0	150,000	0	312,800	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Equity contributions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600
Principal payments on long-term debt
-	21,300	-	-	-	1,300	1,300	1,200	1,300	311,900	-	-	-	-	521,600	5,100	4,200	4,100	348,700	680,100	254,600	5,100	5,100	4,400	4,400	4,100
Principal payments on finance lease obligations
2,000	2,100	600	1,600	2,100	1,900	2,000	2,400	2,300	1,700	1,800	2,800	1,000	1,000	1,600	1,100	1,000	1,200	1,100	1,100	600	700	1,000	1,000	5,500	400
Payment of debt issue costs
-	-	-	-	-	-	100	800	0	3,400	6,400	28,300	0	700	-	-	-	-	-	-	-	-	3,200	0	1,500	200
Common stock repurchases
-	-	0	0	402,300	200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	7,900	-	-	-	-	-	-	-	-
Cash paid for Santa Clara acquisition financing arrangement and other
-	-	0	1,200	1,300	3,300	1,500	1,200	1,300	1,300	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in financing activities
-78,200	-23,400	-27,500	-44,100	-196,900	-6,700	-98,400	144,400	-4,900	-5,500	-9,000	1,423,000	-1,000	-1,700	-10,700	323,300	-23,500	2,600	-5,200	803,700	3,000	-5,800	264,600	-4,600	136,800	-4,100
Net cash flows
-76,400	71,300	1,800	3,100	-168,500	91,600	-76,100	56,800	-10,600	69,900	18,800	53,900	-46,200	24,300	-42,400	35,600	-167,400	38,300	35,900	111,300	-2,800	-129,400	45,500	46,000	107,600	6,000
Effect of changes in foreign exchange rates on cash
4,000	-2,700	4,600	200	-9,000	2,200	3,400	-8,300	400	600	3,500	500	-2,800	-2,000	-2,100	3,400	-2,100	-1,200	-1,000	-1,200	-900	-700	500	300	100	100
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
-72,400	68,600	6,400	3,300	-177,500	93,800	-72,700	48,500	-10,200	70,500	22,300	54,400	-49,000	22,300	-44,500	39,000	-169,500	37,100	34,900	110,100	-3,700	-130,100	42,500	48,200	109,200	6,200
Supplemental disclosure of non-cash investing and financing activities:
Cash paid for interest, net of capitalized interest
88,700	67,200	92,400	69,700	89,700	63,400	85,100	58,800	82,000	54,300	86,400	11,900	84,100	13,200	83,500	32,500	83,200	29,300	14,300	32,200	71,100	73,600	15,100	68,400	16,800	75,000
Cash paid for interest, net of capitalized interest - discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	100	100	100	100
Cash paid for income taxes
1,800	3,000	3,500	800	700	2,000	3,400	13,800	1,700	1,400	3,300	3,800	4,100	1,900	2,600	4,700	2,000	4,700	1,800	1,900	2,100	8,700	3,000	1,600	600	500
Non-cash purchases of equipment through finance leasing
3,500	5,700	2,400	0	31,100	21,900	3,900	17,900	200	100	400	-26,300	34,600	3,300	1,700	100	500	5,300	600	400	4,200	1,600	4,900	500	1,800	3,300
Non-cash purchases of equipment and other assets through nonmonetary exchange
45,100	19,500	13,500	4,600	0	31,100	6,400	0	9,200	1,500	-	-	-	-	24,400	700	14,500	11,000	-200	2,700	-100	6,000	23,000	4,800	-2,700	-14,200
Change in accounts payable and accrued expenses for purchases of property and equipment
69,600	-39,900	49,300	10,500	-24,400	-2,400	13,600	1,600	-29,400	-18,000	-20,200	14,400	11,300	11,400	-	-	-	-	-	-	-	-	-	-	-	-
Cash flows from continuing operations
-76,400	71,300	1,800	3,100	-168,500	91,600	-76,100	56,800	-10,600	69,900	18,800	53,900	-46,200	24,300	-	-	-	-	-	-	-	-	-	46,000	107,600	6,000
Discontinued operations:
Operating activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,900	5,400	3,100	3,300
Investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-800	-2,000	-1,000	-1,300
Financing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-3,400	-1,500	-600	-1,900
Net cash flows from discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-300	1,900	1,500	100
Cash flows from discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,900	1,500	100
(Decrease)/increase in accruals for purchases of property and equipment - discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	100