CyrusOne Inc. CONE Cash Flow

Cyrusone inc. (CONE)

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
Cash flows from operating activities:
Net income
14,700	-52,100	12,600	-8,500	89,400	-105,800	-42,400	105,900	43,500	2,800	-55,100	-800	-30,400	800	4,400	9,100	5,600	-1,200	-5,300	-6,500	-7,200	-11,800	200	-3,600	700	-3,800	-2,200	-6,800	-2,800
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
108,100	108,100	105,400	102,100	102,100	97,900	84,000	77,600	74,600	70,800	68,700	63,700	55,700	49,300	50,600	44,700	39,300	39,900	39,100	31,400	31,100	30,600	30,000	29,800	27,600	26,600	23,900	23,000	16,400
Provision for bad debt expense
-100	1,900	100	-300	0	2,000	200	-100	500	-300	200	300	0	700	200	600	100	-300	100	200	0	-	-	-	-	-	-	-	-
Unrealized gain on marketable equity investment
14,700	27,400	12,400	-75,400	101,200	-96,700	-36,600	102,700	40,500	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Foreign currency and derivative gains, net
5,100	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from swap terminations
-2,900	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on asset disposals
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Asset Impairment Charges
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	4,900	0	8,600	0	0	0	0	-	-	-	-
Gain (Loss) on Extinguishment of Debt
-3,400	-71,800	0	0	0	0	0	0	-3,100	0	0	-300	-36,200	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Interest expense amortization, net
2,000	1,500	1,200	1,100	1,200	1,000	1,200	1,100	700	800	1,200	1,300	900	-6,200	9,600	600	900	1,100	900	700	700	700	900	900	900	2,800	200	1,200	-200
Stock-based compensation expense
3,700	4,300	4,200	3,700	4,500	4,500	4,600	4,500	3,900	3,100	3,900	4,000	3,700	3,800	2,300	3,200	3,000	3,900	4,300	3,200	3,000	2,700	2,600	2,800	2,200	1,100	1,900	1,800	1,200
Deferred income tax benefit
-2,000	13,900	-3,000	-2,600	-800	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600	0	0	0
Operating lease cost
6,200	5,700	5,000	4,600	5,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other income (expense)
200	-	-	300	-500	-	-	0	0	200	1,100	0	200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in operating assets and liabilities:
Rent and other receivables, net and other assets
29,400	22,700	10,400	23,100	18,000	24,800	18,600	18,800	18,000	10,600	12,400	21,300	20,000	22,700	20,100	15,100	-6,200	7,000	9,100	9,600	-1,800	5,700	-100	24,700	6,700	14,800	10,900	1,200	-11,200
Accounts payable and accrued expenses
-1,200	-12,600	20,000	31,600	-39,800	26,400	-20,300	25,800	-28,900	25,800	-1,700	12,000	-6,800	4,300	900	1,700	0	-2,900	4,500	8,300	-2,900	-7,200	11,600	-1,900	4,400	-3,300	7,800	-25,200	6,100
Deferred revenue and prepaid rents
3,200	-500	-1,900	10,900	7,100	9,100	9,100	11,000	5,300	6,800	8,300	3,200	15,700	3,700	800	-4,700	-2,300	4,600	0	1,000	-200	-400	-600	1,900	8,900	800	2,300	1,100	-4,300
Operating lease liabilities
-5,600	-5,400	-6,900	-4,700	-5,100	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Due to affiliates
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600	400	-300	-1,600	400	-800	300	-100	1,700	0	21,400	-4,700
Other
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
Net Cash Provided by (Used in) Operating Activities
86,300	88,700	109,500	123,600	43,900	106,400	54,400	104,300	44,200	99,400	68,600	66,300	55,200	39,000	48,700	40,100	52,800	38,700	39,800	28,400	33,300	22,800	44,300	6,100	37,900	14,600	23,300	16,600	22,900
Cash flows from investing activities:
Payments to Acquire Other Property, Plant, and Equipment
-	-	-	-	-	-	-	-	-	-	-	-	182,500	174,600	178,300	168,600	78,500	76,300	66,700	42,300	31,900	89,300	78,100	67,100	49,700	48,300	57,600	40,300	26,700
Investment in real estate
196,500	-	212,500	212,900	301,900	-	308,500	177,500	145,200	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments to Acquire Real Estate Held-for-investment
-	-	-	-	-	-	-	-	-	0	0	0	492,300	0	0	0	131,100	0	0	0	17,300	0	0	0	0	14,700	6,700	8,400	18,200
Equity investments
3,300	3,500	0	300	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Changes in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-300	-400	-800	-	0	0	0	-	-	-	-	0	0	2,600	1,800
Net cash used in investing activities
-199,800	-153,000	-211,600	-13,400	-301,900	-248,100	-770,300	-177,500	-145,200	-305,400	-224,100	-302,500	-674,800	-176,100	-178,000	-168,200	-208,800	-67,500	-465,100	-42,300	-49,200	-89,300	-78,100	-67,100	-49,700	-63,200	-64,300	-46,100	-43,100
Cash flows from financing activities:
Issuance of common stock, net
600	103,900	700	147,600	105,000	147,700	399,700	9,300	142,900	296,900	200	197,600	211,000	-1,500	192,100	500	256,000	200	0	799,300	0	-	-	-	-	0	0	0	360,500
Stock issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-23,400	23,400
Payments of Dividends
58,400	56,900	52,200	50,900	50,400	48,800	45,700	45,600	41,000	38,300	38,300	36,700	32,400	31,500	29,900	30,100	22,800	22,500	24,500	20,300	13,500	13,500	13,400	13,600	10,400	10,300	10,400	10,300	0
Repayments of Senior Debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payment for Debt Extinguishment or Debt Prepayment Cost
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payment of deferred financing costs
13,600	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from Issuance of Long-term Debt
-	-	-	-	-	-	-	-	-	-908,700	180,000	565,100	1,200,900	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of Long-term Debt
-	-	-	-	-	-	-	-	-	62,900	0	467,300	744,800	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from revolving credit facility
244,400	-	246,500	12,100	275,700	-	370,000	0	0	-	-	-	-	-	115,000	95,000	320,000	40,000	150,000	50,000	20,000	285,000	30,000	0	0	-	-	-	-
Repayments of revolving credit facility
623,100	-	-	-	0	-	-	-	-	-	-	-	-	-	145,000	10,000	305,000	10,000	0	0	0	-	-	-	-	-	-	-	-
Proceeds from Euro bond
550,600	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from unsecured term loan
1,100,000	0	0	0	0	4,900	309,700	-200	985,600	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of unsecured term loan
1,100,000	0	0	200,000	0	-2,700	0	0	902,700	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on finance lease liabilities
700	-	900	600	600	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	2,100	0	5,400	0	0	-	-	-	-	-	-	-	-
Proceeds from issuance of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of Long-term Capital Lease Obligations
-	-	-	-	-	-	-	-	2,600	2,500	2,500	2,500	2,300	2,300	2,400	1,300	3,100	2,100	1,700	1,000	1,100	800	900	800	1,400	1,600	1,200	1,900	600
Payment, Tax Withholding, Share-based Payment Arrangement
6,300	300	200	100	8,700	100	400	300	4,400	300	0	200	6,400	500	100	0	13,600	800	0	0	0	-	-	-	-	-	-	-	-
Contributions from/(distributions to) parent, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
Net cash provided by (used in) financing activities
93,500	85,000	10,700	-91,900	321,000	145,600	660,600	-39,300	177,800	333,200	139,400	256,000	626,000	139,200	127,100	53,600	229,400	4,800	51,600	401,400	5,400	72,600	14,900	-14,900	-11,800	-15,800	-12,900	-32,000	336,500
Effect of exchange rate changes on cash, cash equivalents and restricted cash
900	4,000	-1,000	-200	-100	-500	100	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net decrease in cash, cash equivalents and restricted cash
-19,100	24,700	-92,400	18,100	62,900	3,400	-55,200	-112,500	76,800	127,200	-16,100	19,800	6,400	2,100	-2,200	-74,500	73,400	-24,000	-373,700	387,500	-10,500	6,100	-18,900	-75,900	-23,600	-	-	-	-
Supplemental disclosure of cash flow information:
Cash paid for interest, including amounts capitalized of $32.9 million, $24.4 million and $17.0 million in 2019, 2018 and 2017, respectively
8,300	14,000	46,300	16,000	46,700	16,900	45,200	11,100	42,200	-	-	-	-	21,600	6,200	21,000	6,200	22,300	2,900	15,700	2,800	18,900	1,900	18,900	1,600	18,900	1,900	18,100	1,800
Cash paid for income taxes
-	-	-	-	-	100	300	2,700	300	-	-	-	-	0	0	1,100	100	900	600	800	1,100	0	100	300	0	-	-	-	-
Non-cash investing and financing activities:
Capitalized interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,800	2,900	2,100	1,900	1,700	1,200	1,300	1,600	2,100	400	500	0	500	700	400
Non-cash investing and financing activities:
Dividends payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	1,800	300	31,500	100	-1,800	3,800	21,500	200	400	0	13,700	-	-	-	-
Debt issuance cost payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Taxes on vesting of shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	100	600	-	-	0	0	-	-	-	-
Acquisition and development of properties in accounts payable and other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	40,300	-34,500	111,900	21,300	10,700	5,700	21,500	-23,300	5,100	-7,200	52,200	5,600	600	10,700	18,900
Deferred IPO costs reclassified to additional paid in capital
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	9,500