CyrusOne Inc. CONE Cash Flow

Cyrusone inc. (CONE)

CashFlow / TTM

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
-33,300	41,400	-12,300	-67,300	47,100	1,200	109,800	97,100	-9,600	-83,500	-85,500	-26,000	-16,100	19,900	17,900	8,200	-7,400	-20,200	-30,800	-25,300	-22,400	-14,500	-6,500	-8,900	-12,100	-15,600	0	0	0
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
423,700	417,700	407,500	386,100	361,600	334,100	307,000	291,700	277,800	258,900	237,400	219,300	200,300	183,900	174,500	163,000	149,700	141,500	132,200	123,100	121,500	118,000	114,000	107,900	101,100	89,900	0	0	0
Provision for bad debt expense
1,600	1,700	1,800	1,900	2,100	2,600	300	300	700	200	1,200	1,200	1,500	1,600	600	500	100	0	0	0	0	-	-	-	-	-	-	-	-
Unrealized gain on marketable equity investment
-20,900	65,600	-58,500	-107,500	70,600	9,900	106,600	143,200	40,500	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Foreign currency and derivative gains, net
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from swap terminations
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Loss on asset disposals
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-
Asset Impairment Charges
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	13,500	13,500	8,600	8,600	0	0	0	0	-	-	-	-
Gain (Loss) on Extinguishment of Debt
-75,200	-71,800	0	0	0	-3,100	-3,100	-3,100	-3,400	-36,500	-36,500	-36,500	-36,200	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Interest expense amortization, net
5,800	5,000	4,500	4,500	4,500	4,000	3,800	3,800	4,000	4,200	-2,800	5,600	4,900	4,900	12,200	3,500	3,600	3,400	3,000	3,000	3,200	3,400	5,500	4,800	5,100	4,000	0	0	0
Stock-based compensation expense
15,900	16,700	16,900	17,300	18,100	17,500	16,100	15,400	14,900	14,700	15,400	13,800	13,000	12,300	12,400	14,400	14,400	14,400	13,200	11,500	11,100	10,300	8,700	8,000	7,000	6,000	0	0	0
Deferred income tax benefit
6,300	7,500	-6,400	-3,400	-800	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	600	0	0	0
Operating lease cost
21,500	20,300	14,600	9,600	5,000	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other income (expense)
0	-	-	0	0	-	-	1,300	1,300	1,500	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Change in operating assets and liabilities:
Rent and other receivables, net and other assets
85,600	74,200	76,300	84,500	80,200	80,200	66,000	59,800	62,300	64,300	76,400	84,100	77,900	51,700	36,000	25,000	19,500	23,900	22,600	13,400	28,500	37,000	46,100	57,100	33,600	15,700	0	0	0
Accounts payable and accrued expenses
37,800	-800	38,200	-2,100	-7,900	3,000	2,400	21,000	7,200	29,300	7,800	10,400	100	6,900	-300	3,300	9,900	7,000	2,700	9,800	-400	6,900	10,800	7,000	-16,300	-14,600	0	0	0
Deferred revenue and prepaid rents
11,700	15,600	25,200	36,200	36,300	34,500	32,200	31,400	23,600	34,000	30,900	23,400	15,500	-2,500	-1,600	-2,400	3,300	5,400	400	-200	700	9,800	11,000	13,900	13,100	-100	0	0	0
Operating lease liabilities
-22,600	-22,100	-16,700	-9,800	-5,100	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Due to affiliates
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-900	-1,100	-2,300	-1,700	-200	1,100	1,900	23,000	18,400	0	0	0
Other
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
Net Cash Provided by (Used in) Operating Activities
408,100	365,700	383,400	328,300	309,000	309,300	302,300	316,500	278,500	289,500	229,100	209,200	183,000	180,600	180,300	171,400	159,700	140,200	124,300	128,800	106,500	111,100	102,900	81,900	92,400	77,400	0	0	0
Cash flows from investing activities:
Payments to Acquire Other Property, Plant, and Equipment
-	-	-	-	-	-	-	-	-	-	-	-	704,000	600,000	501,700	390,100	263,800	217,200	230,200	241,600	266,400	284,200	243,200	222,700	195,900	172,900	0	0	0
Investment in real estate
0	-	0	0	0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments to Acquire Real Estate Held-for-investment
-	-	-	-	-	-	-	-	-	492,300	492,300	492,300	492,300	131,100	131,100	131,100	131,100	17,300	17,300	17,300	17,300	0	14,700	21,400	29,800	48,000	0	0	0
Equity investments
7,100	3,800	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Changes in restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-8,100	-	0	0	0	-	-	-	-	4,400	0	0	0
Net cash used in investing activities
-577,800	-679,900	-775,000	-1,333,700	-1,497,800	-1,341,100	-1,398,400	-852,200	-977,200	-1,506,800	-1,377,500	-1,331,400	-1,197,100	-731,100	-622,500	-909,600	-783,700	-624,100	-645,900	-258,900	-283,700	-284,200	-258,100	-244,300	-223,300	-216,700	0	0	0
Cash flows from financing activities:
Issuance of common stock, net
252,800	357,200	401,000	800,000	661,700	699,600	848,800	449,300	637,600	705,700	407,300	599,200	402,100	447,100	448,800	256,700	1,055,500	799,500	0	0	0	-	-	-	-	360,500	0	0	0
Stock issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
Payments of Dividends
218,400	210,400	202,300	195,800	190,500	181,100	170,600	163,200	154,300	145,700	138,900	130,500	123,900	114,300	105,300	99,900	90,100	80,800	71,800	60,700	54,000	50,900	47,700	44,700	41,400	31,000	0	0	0
Repayments of Senior Debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payment for Debt Extinguishment or Debt Prepayment Cost
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Payment of deferred financing costs
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from Issuance of Long-term Debt
-	-	-	-	-	-	-	-	-	1,037,300	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of Long-term Debt
-	-	-	-	-	-	-	-	-	1,275,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from revolving credit facility
0	-	0	0	0	-	0	0	0	-	-	-	-	-	570,000	605,000	560,000	260,000	505,000	385,000	335,000	315,000	0	0	0	-	-	-	-
Repayments of revolving credit facility
0	-	-	-	0	-	-	-	-	-	-	-	-	-	470,000	325,000	315,000	10,000	0	0	0	-	-	-	-	-	-	-	-
Proceeds from Euro bond
0	-	-	-	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Proceeds from unsecured term loan
1,100,000	0	4,900	314,600	314,400	1,300,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of unsecured term loan
1,300,000	200,000	197,300	197,300	-2,700	900,000	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Payments on finance lease liabilities
0	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Debt issuance costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	2,100	7,500	7,500	5,400	0	0	0	-	-	-	-	-	-	-	-
Proceeds from issuance of debt
-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Repayments of Long-term Capital Lease Obligations
-	-	-	-	-	-	-	-	10,100	9,800	9,600	9,500	8,300	9,100	8,900	8,200	7,900	5,900	4,600	3,800	3,600	3,900	4,700	5,000	6,100	5,300	0	0	0
Payment, Tax Withholding, Share-based Payment Arrangement
6,900	9,300	9,100	9,300	9,500	5,200	5,400	5,000	4,900	6,900	7,100	7,200	7,000	14,200	14,500	14,400	14,400	800	0	0	0	-	-	-	-	-	-	-	-
Contributions from/(distributions to) parent, net
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	0
Net cash provided by (used in) financing activities
97,300	324,800	385,400	1,035,300	1,087,900	944,700	1,132,300	611,100	906,400	1,354,600	1,160,600	1,148,300	945,900	549,300	414,900	339,400	687,200	463,200	531,000	494,300	78,000	60,800	-27,600	-55,400	-72,500	275,800	0	0	0
Effect of exchange rate changes on cash, cash equivalents and restricted cash
3,700	2,700	-1,800	-700	-500	-400	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Net decrease in cash, cash equivalents and restricted cash
-68,700	13,300	-8,000	29,200	-101,400	-87,500	36,300	75,400	207,700	137,300	12,200	26,100	-68,200	-1,200	-27,300	-398,800	63,200	-20,700	9,400	364,200	-99,200	-112,300	0	0	0	-	-	-	-
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
84,600	123,000	125,900	124,800	119,900	115,400	0	0	0	-	-	-	-	55,000	55,700	52,400	47,100	43,700	40,300	39,300	42,500	41,300	41,300	41,300	40,500	40,700	0	0	0
Cash paid for income taxes
-	-	-	-	-	3,400	0	0	0	-	-	-	-	1,200	2,100	2,700	2,400	3,400	2,500	2,000	1,500	400	0	0	0	-	-	-	-
Non-cash investing and financing activities:
Capitalized interest
-	-	-	-	-	-	-	-	-	-	-	-	-	-	8,700	8,600	6,900	6,100	5,800	6,200	5,400	4,600	3,000	1,400	1,700	1,600	0	0	0
Non-cash investing and financing activities:
Dividends payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	33,700	30,100	33,600	23,600	23,700	25,900	22,100	14,300	0	0	0	-	-	-	-
Debt issuance cost payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	-	-	-	-	-	-	-	-	-	-
Taxes on vesting of shares
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	-	-	0	0	-	-	-	-
Acquisition and development of properties in accounts payable and other liabilities
-	-	-	-	-	-	-	-	-	-	-	-	-	-	139,000	109,400	149,600	59,200	14,600	9,000	-3,900	26,800	55,700	51,200	69,100	35,800	0	0	0
Deferred IPO costs reclassified to additional paid in capital
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	9,500	0	0	0