QTS Realty Trust, Inc. QTS Balance Sheet

Qts realty trust, inc. (QTS)

Balance Sheet / Yearly

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	Dec'12
ASSETS
Real Estate Assets
Land
130	130	127	107	105	105	105	105	88	88	86	86	74	74	73	64	57	57	52	52	48	48	48	48	30	30	-	24
Buildings, improvements and equipment
2,411	2,178	2,155	2,087	2,031	1,917	1,881	1,833	1,778	1,701	1,668	1,625	1,585	1,524	1,449	1,393	1,241	1,180	1,108	1,073	954	914	894	829	743	728	-	622
Less: Accumulated depreciation
588	558	555	523	494	467	450	434	417	394	378	354	340	317	295	274	255	239	222	205	192	180	168	157	147	137	-	102
Total real estate assets
1,953	1,750	1,727	1,671	1,642	1,555	1,536	1,504	1,449	1,394	1,375	1,356	1,318	1,281	1,227	1,184	1,043	997	938	920	811	782	774	720	626	621	-	544
Construction in progress
877	920	843	856	803	790	731	649	636	567	429	363	361	365	320	316	340	345	353	320	266	214	174	183	182	146	-	87
Real Estate Assets, net
2,830	2,671	2,571	2,527	2,446	2,345	2,268	2,154	2,085	1,962	1,805	1,720	1,679	1,647	1,548	1,501	1,384	1,343	1,292	1,241	1,077	997	948	903	809	768	-	631
Investments in unconsolidated entity
32	30	30	32	44	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease right-of-use assets, net
55	57	58	59	61	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash and cash equivalents
171	15	13	10	18	11	13	52	15	8	9	42	18	9	11	12	9	8	10	10	5	10	5	7	7	5	0	8
Restricted cash
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0
Deferred offering costs
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2	-
Rents and other receivables, net
74	81	76	60	56	55	51	50	45	47	47	44	42	41	34	35	30	28	31	30	16	15	13	12	11	14	-	11
Acquired intangibles, net
78	81	85	89	92	95	96	100	104	109	114	119	124	129	135	142	125	115	119	122	17	18	18	19	4	5	-	9
Deferred costs, net
53	52	48	46	45	45	42	44	42	41	38	38	38	38	35	34	31	30	38	38	37	37	33	23	19	19	-	15
Prepaid expenses
13	10	8	8	9	6	7	10	10	6	7	8	10	6	9	8	10	6	9	7	6	3	4	4	4	1	-	1
Goodwill
173	173	173	173	173	173	173	173	173	173	173	173	173	173	173	173	171	181	174	173	-	-	-	-	-	-	-	-
Assets held for sale
-	-	-	-	-	71	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets, net
49	49	57	57	55	56	64	68	64	66	63	59	43	39	37	36	35	33	29	29	24	24	25	19	20	17	-	7
TOTAL ASSETS
3,533	3,223	3,123	3,066	3,004	2,861	2,718	2,654	2,542	2,415	2,258	2,206	2,130	2,086	1,986	1,946	1,799	1,747	1,705	1,652	1,185	1,106	1,050	990	877	831	2	685
LIABILITIES
Secured credit facility
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	316
Unsecured credit facility, net
1,222	1,010	918	949	828	945	776	694	832	825	775	744	702	634	529	493	607	520	400	330	140	239	197	439	314	256	-	-
Senior notes, net of debt issuance costs
395	395	395	395	394	394	394	394	394	394	293	292	292	292	291	291	291	290	297	297	297	297	297	-	-	-	-	-
Finance leases and mortgage notes payable
46	46	47	48	48	4	6	6	8	10	30	34	37	38	41	43	46	49	53	56	13	13	9	4	2	2	-	2
Operating lease liabilities
62	64	65	67	69	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Mortgage notes payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	70	70	86	86	87	87	88	88	-	171
Accounts payable and accrued liabilities
177	142	94	90	120	99	122	109	144	113	67	84	72	86	84	63	69	95	80	92	82	64	52	47	53	63	-	36
Dividends and distributions payable
37	34	32	33	33	29	30	25	24	22	22	21	21	19	19	19	17	15	15	15	13	10	10	10	10	8	-	-
Advance rents, security deposits and other liabilities
24	18	52	47	34	29	29	29	28	28	29	31	28	24	20	20	20	18	19	19	3	3	3	3	3	3	-	3
Derivative liabilities
61	26	-	-	-	2	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	0	0	0	-	0
Liabilities held for sale
-	-	-	-	-	24	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income taxes
0	0	1	1	1	1	1	2	2	4	9	12	13	15	16	19	21	18	15	16	-	-	-	-	-	-	-	-
Deferred income
39	39	41	40	38	33	31	32	28	25	22	23	23	21	18	18	16	16	25	19	11	10	9	8	8	7	-	6
Member advances and notes payable
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	26
TOTAL LIABILITIES
2,069	1,779	1,649	1,673	1,569	1,565	1,391	1,294	1,462	1,424	1,250	1,244	1,192	1,133	1,021	970	1,088	1,027	976	917	647	726	666	600	481	431	2	563
Due to affiliates
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	2	-
EQUITY
Common stock/units
0	0	-	-	-	-	0	0	-	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-
Additional paid-in capital
1,412	1,330	1,326	1,219	1,214	1,062	1,059	1,056	1,052	1,049	1,032	972	933	931	930	928	671	670	668	664	474	324	321	320	319	318	-	-
Accumulated other comprehensive income (loss)
-57	-24	-28	-23	-6	2	10	8	6	1	-1	-1	-	-	-	-	-	-	-	-	-	-	-	-0	-0	-0	-	-
Accumulated dividends in excess of earnings
403	376	340	316	292	278	257	223	195	173	139	126	111	97	85	73	61	52	44	38	29	22	18	-	-	3	-	-
Accumulated deficit
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-13	-8	-	-	-
Total stockholders' equity
1,358	1,337	1,364	1,287	1,323	1,193	1,220	1,249	967	877	892	844	822	834	845	854	610	617	624	627	444	302	302	307	311	314	-	121
Noncontrolling interests
105	106	109	105	110	102	106	109	112	113	115	117	116	118	119	120	100	101	104	107	93	77	81	82	83	84	-	-
TOTAL EQUITY
1,463	1,444	1,473	1,393	1,434	1,296	1,327	1,359	1,080	990	1,008	962	938	952	964	975	710	719	728	734	538	380	383	389	395	399	-	121
TOTAL PARTNERS' CAPITAL
-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	124	121
TOTAL LIABILITIES AND EQUITY
3,533	3,223	3,123	3,066	3,004	2,861	2,718	2,654	2,542	2,415	2,258	2,206	2,130	2,086	1,986	1,946	1,799	1,747	1,705	1,652	1,185	1,106	1,050	990	877	831	2	685
Qualitytech, LP
Land
130	130	127	107	105	105	-	-	-	88	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Buildings, improvements and equipment
2,411	2,178	2,155	2,087	2,031	1,917	-	-	-	1,701	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Less: Accumulated depreciation
588	558	555	523	494	467	-	-	-	394	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total real estate assets
1,953	1,750	1,727	1,671	1,642	1,555	-	-	-	1,394	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Construction in progress
877	920	843	856	803	790	-	-	-	567	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Real Estate Assets, net
2,830	2,671	2,571	2,527	2,446	2,345	-	-	-	1,962	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Investments in unconsolidated entity
32	30	30	32	44	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease right-of-use assets, net
55	57	58	59	61	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Cash and cash equivalents
171	15	13	10	18	11	-	-	-	8	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Rents and other receivables, net
74	81	76	60	56	55	-	-	-	47	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Acquired intangibles, net
78	81	85	89	92	95	-	-	-	109	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred costs, net
53	52	48	46	45	45	-	-	-	41	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Prepaid expenses
13	10	8	8	9	6	-	-	-	6	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Goodwill
173	173	173	173	173	173	-	-	-	173	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Assets held for sale
-	-	-	-	-	71	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Other assets, net
49	49	57	57	55	56	-	-	-	66	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL ASSETS
3,533	3,223	3,123	3,066	3,004	2,861	-	-	-	2,415	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Unsecured credit facility, net
1,222	1,010	918	949	828	945	-	-	-	825	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Senior notes, net of debt issuance costs
395	395	395	395	394	394	-	-	-	394	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Capital lease, lease financing obligations and mortgage notes payable
-	-	-	-	-	-	-	-	-	10	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Finance leases and mortgage notes payable
46	46	47	48	48	4	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Operating lease liabilities
62	64	65	67	69	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accounts payable and accrued liabilities
177	142	94	90	120	99	-	-	-	113	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Dividends and distributions payable
37	34	32	33	33	29	-	-	-	22	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Advance rents, security deposits and other liabilities
24	18	52	47	34	29	-	-	-	28	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Derivative liabilities
61	26	-	-	-	2	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Liabilities held for sale
-	-	-	-	-	24	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income taxes
0	0	1	1	1	1	-	-	-	4	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Deferred income
39	39	41	40	38	33	-	-	-	25	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL LIABILITIES
2,069	1,779	1,649	1,673	1,569	1,565	-	-	-	1,424	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Accumulated other comprehensive income (loss)
-64	-27	-32	-26	-7	2	-	-	-	1	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL EQUITY
1,463	1,444	1,473	1,393	-	1,296	-	-	-	990	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL PARTNERS' CAPITAL
1,463	1,444	1,473	1,393	1,434	1,296	-	-	-	990	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
TOTAL LIABILITIES AND EQUITY
3,533	3,223	3,123	3,066	3,004	2,861	-	-	-	2,415	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Series A Redeemable Perpetual Preferred Stock
Cumulative redeemable perpetual preferred stock / units
103	103	103	103	103	103	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Series B Convertible Perpetual Preferred Stock
Cumulative redeemable perpetual preferred stock / units
304	304	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Series B Convertible Preferred Units
Cumulative redeemable perpetual preferred stock / units
-	-	304	304	304	304	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Common stock
Common stock / units
-	-	0	0	0	0	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-