Zayo Group Holdings, Inc. ZAYO Cash Flow

Zayo group holdings, inc. (ZAYO)
CashFlow / TTM

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)
177,000	145,800	150,000	129,900	118,700	101,700	102,900	84,600	88,100	94,700	87,100	31,600	-14,700	-45,300	-76,200	-40,200	-74,600	-60,000	-155,300	-233,900	-221,800	-262,400	-179,300	0	0	0
Earnings from discontinued operations, net of income taxes
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,300	0	0	0
Loss from continuing operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-181,600	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities
Depreciation and amortization
632,700	621,700	633,400	652,000	681,700	730,500	746,500	751,000	715,800	651,500	606,200	573,900	555,400	537,700	516,300	481,200	444,100	427,300	406,200	384,300	368,400	353,200	338,200	0	0	0
Loss on extinguishment of debt
-	-	-	-	-	-	-4,900	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Gain on sale of SRT
-	-	5,500	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Non-cash interest expense
10,800	10,500	10,300	7,700	10,000	9,900	9,800	11,600	9,300	9,400	9,600	10,500	10,400	11,000	11,900	12,500	16,900	20,500	19,700	23,500	21,000	18,300	22,100	0	0	0
Stock-based compensation
110,600	109,800	109,300	106,100	98,300	95,600	96,700	91,600	98,900	109,900	114,100	126,400	133,400	141,800	155,900	165,400	172,600	123,700	200,700	246,400	270,900	333,900	253,700	0	0	0
Amortization of deferred revenue
159,500	155,400	152,100	148,900	145,000	140,900	136,300	131,300	126,500	121,400	116,500	130,400	125,200	118,600	111,500	85,800	79,400	75,200	72,100	68,100	64,000	60,300	55,600	0	0	0
Foreign currency (gain)/loss on intercompany loans
13,300	-22,400	-14,100	-28,200	-21,400	-10,000	5,400	42,200	32,200	11,700	-10,300	-49,600	-64,600	-54,300	-53,800	-12,100	-14,300	-20,400	-24,400	0	0	0	-	-	-	-
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,900	0	0	0	-	-	-	-	-	-	-	-
Deferred income taxes
-2,500	-2,900	1,200	20,400	37,500	35,500	22,300	58,800	31,100	11,300	13,400	-23,500	-11,600	0	-2,800	21,100	-4,300	-17,500	-13,300	0	0	0	-	-	0	0
Provision for bad debts
11,000	11,300	10,200	8,000	6,900	5,800	5,100	7,400	4,600	3,600	3,700	2,900	2,800	4,200	3,900	3,700	3,500	1,900	1,900	1,600	2,000	2,100	1,900	0	0	0
Non-cash loss on investments
-	-	800	1,200	1,200	1,100	900	900	900	900	1,100	700	1,100	1,300	1,200	0	0	0	-	-	-	-	-	-	-	-
Changes in operating assets and liabilities
Trade receivables
-69,000	-60,400	-44,000	8,900	-16,300	11,600	48,100	34,900	32,200	37,300	7,200	19,400	29,900	-5,600	-1,900	-22,600	-9,100	20,800	11,200	22,100	-700	-16,900	-20,500	0	0	0
Prepaid expenses
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	4,100	2,900	5,100	1,400	0	0	0
Payables to/(from) related parties, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Accounts payable and accrued liabilities
14,300	4,200	-14,100	2,800	-48,800	-37,100	7,300	19,800	67,400	53,000	5,200	17,800	-43,000	-54,900	-36,000	-20,400	19,400	49,200	-22,100	-19,900	-57,300	-20,600	-6,600	0	0	0
Additions to deferred revenue
253,000	244,000	193,100	213,500	232,000	202,800	212,800	181,800	178,100	200,100	200,500	195,300	181,700	175,200	184,000	170,900	151,600	155,600	149,100	174,800	200,500	183,000	163,800	0	0	0
Other assets and liabilities
56,400	51,200	43,600	28,800	37,800	53,600	48,200	53,300	62,400	41,300	35,900	32,600	-16,300	-5,500	14,300	16,000	24,600	32,300	17,800	0	0	0	-	-	-	-
Net cash provided by operating activities
1,046,900	1,021,100	951,100	977,700	986,900	944,200	971,200	964,400	964,000	945,800	909,800	841,100	775,100	751,600	714,000	732,800	704,900	682,400	605,400	578,500	569,000	587,600	566,500	0	0	0
Other assets, current and non-current
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Cash flows from investing activities
Purchases of property and equipment
873,900	821,500	786,900	799,100	787,800	779,000	789,900	787,200	800,400	820,600	835,500	817,600	794,400	753,200	704,100	672,200	617,200	574,300	530,400	469,800	430,600	389,400	360,800	0	0	0
Proceeds from sale of SRT, net of cash held in escrow
-	-	39,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other
-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	0	0	-	0	0	0	-	-	-	-
Net cash used in investing activities
-873,900	-821,500	-747,900	-781,500	-925,500	-916,900	-966,800	-954,500	-2,235,600	-2,256,900	-2,270,300	-2,261,100	-1,113,700	-1,188,900	-1,141,600	-1,087,600	-1,464,400	-1,303,800	-1,386,100	-1,619,400	-866,900	-908,900	-754,100	0	0	0
Cash flows from financing activities
Proceeds from debt
-	-	-	-	-	-	462,800	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Equity contributions
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Principal payments on long-term debt
-	155,000	-	-	-	5,100	315,700	0	0	0	-	-	-	-	535,000	362,100	1,037,100	1,287,500	1,288,500	944,900	269,200	19,000	18,000	0	0	0
Principal payments on finance lease obligations
6,300	6,400	6,200	7,600	8,400	8,600	8,400	8,200	8,600	7,300	6,600	6,400	4,700	4,700	4,900	4,400	4,400	4,000	3,500	3,400	3,300	8,200	7,900	0	0	0
Payment of debt issue costs
-	-	-	-	-	-	4,300	10,600	38,100	38,100	35,400	0	0	0	-	-	-	-	-	-	-	-	4,900	0	0	0
Common stock repurchases
-	-	402,500	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Excess tax benefit from stock-based compensation
-	-	-	-	-	-	-	-	-	-	-	-	-	-	7,900	0	0	0	-	-	-	-	-	-	-	-
Cash paid for Santa Clara acquisition financing arrangement and other
-	-	5,800	7,300	7,300	7,300	5,300	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net cash used in financing activities
-173,200	-291,900	-275,200	-346,100	-157,600	34,400	35,600	125,000	1,403,600	1,407,500	1,411,300	1,409,600	309,900	287,400	291,700	297,200	777,600	804,100	795,700	1,065,500	257,200	391,000	392,700	0	0	0
Net cash flows
-200	-92,300	-72,000	-149,900	-96,200	61,700	40,000	134,900	132,000	96,400	50,800	-10,400	-28,700	-149,900	-135,900	-57,600	18,100	182,700	15,000	24,600	-40,700	69,700	205,100	0	0	0
Effect of changes in foreign exchange rates on cash
6,100	-6,900	-2,000	-3,200	-11,700	-2,300	-3,900	-3,800	5,000	1,800	-800	-6,400	-3,500	-2,800	-2,000	-900	-5,500	-4,300	-3,800	-2,300	-800	200	1,000	0	0	0
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect
5,900	-99,200	-74,000	-153,100	-107,900	59,400	36,100	131,100	137,000	98,200	50,000	-16,800	-32,200	-152,700	-137,900	-58,500	12,600	178,400	11,200	18,800	-43,100	69,800	206,100	0	0	0
Supplemental disclosure of non-cash investing and financing activities:
Cash paid for interest, net of capitalized interest
318,000	319,000	315,200	307,900	297,000	289,300	280,200	281,500	234,600	236,700	195,600	192,700	213,300	212,400	228,500	159,300	159,000	146,900	191,200	192,000	228,200	173,900	175,300	0	0	0
Cash paid for interest, net of capitalized interest - discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	400	0	0	0
Cash paid for income taxes
9,100	8,000	7,000	6,900	19,900	20,900	20,300	20,200	10,200	12,600	13,100	12,400	13,300	11,200	14,000	13,200	10,400	10,500	14,500	15,700	15,400	13,900	5,700	0	0	0
Non-cash purchases of equipment through finance leasing
11,600	39,200	55,400	56,900	74,800	43,900	22,100	18,600	-25,600	8,800	12,000	13,300	39,700	5,600	7,600	6,500	6,800	10,500	6,800	11,100	11,200	8,800	10,500	0	0	0
Non-cash purchases of equipment and other assets through nonmonetary exchange
82,700	37,600	49,200	42,100	37,500	46,700	17,100	0	0	0	-	-	-	-	50,600	26,000	28,000	13,400	8,400	31,600	33,700	31,100	10,900	0	0	0
Change in accounts payable and accrued expenses for purchases of property and equipment
89,500	-4,500	33,000	-2,700	-11,600	-16,600	-32,200	-66,000	-53,200	-12,500	16,900	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Cash flows from continuing operations
-200	-92,300	-72,000	-149,900	-96,200	61,700	40,000	134,900	132,000	96,400	50,800	0	0	0	-	-	-	-	-	-	-	-	-	0	0	0
Discontinued operations:
Operating activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	15,700	0	0	0
Investing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-5,100	0	0	0
Financing activities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-7,400	0	0	0
Net cash flows from discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	3,200	0	0	0
Cash flows from discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0
(Decrease)/increase in accruals for purchases of property and equipment - discontinued operations
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0