QA: us_hotels 2009-2024

Ranks across the years

	name	name_short	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2009-val	2010-val	2011-val	2012-val	2013-val	2014-val	2015-val	2016-val	2017-val	2018-val	2019-val	2020-val	2021-val	2022-val	2023-val	2024-val	2009->2010	2010->2011	2011->2012	2012->2013	2013->2014	2014->2015	2015->2016	2016->2017	2017->2018	2018->2019	2019->2020	2020->2021	2021->2022	2022->2023	2023->2024
0000906553	BOYD Gaming CORP	BOYD Ga	NaN	NaN	NaN	28	NaN	NaN	NaN	NaN	2	3	4	3	2	2	2	1	NaN	NaN	NaN	42.31	NaN	NaN	NaN	NaN	172.09	155.80	158.32	127.82	197.64	219.28	216.63	208.47	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	1	-1	-1	0	0	-1
0000907242	Monarch Casino Resort INC	Monarch	NaN	NaN	6	7	1	5	2	1	3	7	9	7	5	3	3	2	NaN	NaN	126.57	107.92	140.89	136.31	155.39	172.15	170.04	140.29	114.16	105.44	152.10	200.10	189.82	177.22	NaN	NaN	1	-6	4	-3	-1	2	4	2	-2	-2	-2	0	-1
0001048286	Marriott International INC MD	Marriot	1	1	13	4	2	3	6	3	4	5	5	6	6	6	4	3	124.85	135.73	103.33	133.19	140.67	139.75	134.46	129.48	158.28	146.21	139.37	114.50	132.03	150.60	177.62	141.58	0	12	-9	-2	1	3	-3	1	1	0	1	0	0	-2	-1
0001061937	HOST Hotels Resorts L P	HOST Ho	NaN	NaN	NaN	NaN	8	8	9	2	9	6	6	11	11	8	9	4	NaN	NaN	NaN	NaN	103.73	124.45	116.46	132.12	120.04	144.47	131.65	56.04	87.92	114.23	118.06	109.83	NaN	NaN	NaN	NaN	0	1	-7	7	-3	0	5	0	-3	1	-5
0001468174	Hyatt Hotels Corp	Hyatt H	NaN	NaN	11	9	NaN	10	16	10	13	8	7	15	20	17	17	5	NaN	NaN	106.90	106.07	NaN	105.82	90.93	94.50	100.44	130.03	120.75	41.89	55.09	82.98	74.99	101.93	NaN	NaN	-2	NaN	NaN	6	-6	3	-5	-1	8	5	-3	0	-12
0001046311	Choice Hotels International INC DE	Choice	NaN	3	7	25	NaN	NaN	22	12	19	13	11	9	9	9	10	6	NaN	122.45	125.32	61.81	NaN	NaN	71.21	78.66	76.23	99.23	101.20	62.98	109.91	107.18	86.30	87.40	NaN	4	18	NaN	NaN	NaN	-10	7	-6	-2	-2	0	0	1	-4
0001617406	Park Hotels Resorts Inc	Park Ho	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	19	13	14	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37.01	57.77	86.94	80.49	85.87	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-6	1	-7
0001616000	Xenia Hotels Resorts Inc	Xenia H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	9	12	10	18	11	12	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	102.60	121.91	94.74	58.13	61.06	91.24	84.19	83.03	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	3	-2	8	-7	1	-4
0001722684	Wyndham Hotels Resorts INC	Wyndham	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	10	11	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	90.17	100.40	84.90	82.83	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1	-2
0001300514	LAS Vegas Sands CORP	LAS Veg	NaN	6	9	8	NaN	NaN	NaN	8	6	10	10	20	27	12	13	10	NaN	91.72	113.16	106.35	NaN	NaN	NaN	105.00	131.22	108.42	111.63	39.59	41.30	89.48	81.69	81.97	NaN	3	-1	NaN	NaN	NaN	NaN	-2	4	0	10	7	-15	1	-3
0001692412	Playa Hotels Resorts N V	Playa H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22	16	16	24	24	16	15	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	70.93	79.31	67.81	34.78	48.97	83.06	79.74	79.03	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	0	8	0	-8	-1	-4
0001653653	Red Rock Resorts Inc	Red Roc	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	26	NaN	21	13	13	20	18	12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69.01	60.77	NaN	57.13	42.11	75.79	69.45	66.74	78.34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	NaN	NaN	-8	0	7	-2	-6
0001585689	Hilton Worldwide Holdings Inc	Hilton	NaN	NaN	NaN	NaN	NaN	23	17	18	NaN	NaN	NaN	22	21	19	20	13	NaN	NaN	NaN	NaN	NaN	62.41	81.67	62.79	NaN	NaN	NaN	37.84	52.77	72.58	62.03	63.60	NaN	NaN	NaN	NaN	NaN	-6	1	NaN	NaN	NaN	NaN	-1	-2	1	-7
0001674168	Hilton Grand Vacations Inc	Hilton	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	12	13	19	16	15	16	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	112.74	102.90	86.09	40.37	72.34	84.87	76.72	56.89	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	1	6	-3	-1	1	-2
0001361658	Travel Leisure Co	Travel	NaN	8	19	19	15	21	19	14	15	18	17	18	23	23	22	15	NaN	84.96	80.91	77.97	73.67	72.02	72.84	73.00	86.68	73.27	66.15	40.47	52.11	53.79	58.40	56.67	NaN	11	0	-4	6	-2	-5	1	3	-1	1	5	0	-1	-7
0000789570	MGM Resorts International	MGM Res	NaN	4	1	10	NaN	7	7	NaN	1	4	1	4	3	5	5	16	NaN	96.18	243.45	100.39	NaN	128.72	127.97	NaN	186.20	148.79	184.53	127.48	163.51	161.85	165.32	55.27	NaN	-3	9	NaN	NaN	0	NaN	NaN	3	-3	3	-1	2	0	11
0001174922	WYNN Resorts LTD	WYNN Re	NaN	5	8	20	12	18	28	21	20	19	22	27	29	27	21	17	NaN	91.86	116.49	72.83	79.21	77.57	51.06	53.39	74.05	72.39	55.33	26.06	38.39	40.28	59.47	53.78	NaN	3	12	-8	6	10	-7	-1	-1	3	5	2	-2	-6	-4
0001590895	Caesars Entertainment Inc	Caesars	NaN	NaN	NaN	NaN	NaN	27	15	15	21	21	18	16	26	25	19	18	NaN	NaN	NaN	NaN	NaN	45.96	93.39	69.67	73.40	63.68	64.92	41.69	42.26	42.27	64.34	48.94	NaN	NaN	NaN	NaN	NaN	-12	0	6	0	-3	-2	10	-1	-6	-1
0000921738	PENN Entertainment Inc	PENN En	NaN	10	14	16	29	32	29	23	18	24	23	14	17	21	23	19	NaN	69.44	100.49	91.76	2.37	37.78	41.95	44.25	78.54	51.60	54.21	42.03	71.78	61.84	44.79	42.92	NaN	4	2	13	3	-3	-6	-5	6	-1	-9	3	4	2	-4
0001590584	Civeo Corp	Civeo C	NaN	NaN	NaN	NaN	NaN	35	33	25	29	25	20	26	12	18	8	20	NaN	NaN	NaN	NaN	NaN	29.10	10.04	41.82	47.00	39.96	60.24	33.37	81.30	72.73	123.26	42.24	NaN	NaN	NaN	NaN	NaN	-2	-8	4	-4	-5	6	-14	6	-10	12
0001747079	Bally s Corp	Bally s	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	12	22	29	24	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	81.07	54.30	52.24	35.03	42.42	33.70	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	10	7	-5	-3
0001819395	Sonder Holdings Inc	Sonder	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	30	26	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	119.97	33.97	16.54	16.19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	-4	-4
0000844887	Diamondhead Casino CORP	Diamond	NaN	NaN	NaN	NaN	NaN	NaN	30	27	31	26	NaN	28	30	31	27	23	NaN	NaN	NaN	NaN	NaN	NaN	41.57	13.17	11.60	29.31	NaN	2.65	6.82	4.51	7.90	4.88	NaN	NaN	NaN	NaN	NaN	NaN	-3	4	-5	NaN	NaN	2	1	-4	-4
0000316206	Starwood Hotels Resorts Worldwide LLC	Starwoo	2	7	18	13	7	16	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.18	85.73	86.52	98.32	104.27	79.03	72.27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	11	-5	-6	9	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000356213	Gold Merger Sub LLC	Gold Me	NaN	2	22	27	25	24	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	130.75	63.57	52.28	40.70	51.28	53.74	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	5	-2	-1	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001115836	Belmond Ltd	Belmond	NaN	9	23	18	13	28	25	11	16	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	71.74	62.58	79.82	74.34	41.79	55.73	87.48	79.63	55.23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	-5	-5	15	-3	-14	5	6	NaN	NaN	NaN	NaN	NaN	NaN
0000216877	Pismo Coast Village INC	Pismo C	NaN	NaN	10	6	3	6	3	NaN	NaN	1	3	2	1	4	6	NaN	NaN	NaN	112.03	113.23	122.43	128.82	140.58	NaN	NaN	192.18	177.47	149.31	198.51	185.52	159.32	NaN	NaN	NaN	-4	-3	3	-3	NaN	NaN	NaN	2	-1	-1	3	2	NaN
0000834162	MTR Gaming Group INC	MTR Gam	NaN	NaN	29	29	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37.52	42.29	42.18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000858339	Caesars Holdings INC	Caesars	NaN	NaN	27	32	28	36	1	28	NaN	NaN	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42.04	39.83	30.38	6.01	273.34	12.43	NaN	NaN	41.19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-4	8	-35	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000863015	ISLE OF Capri Casinos INC	ISLE OF	NaN	NaN	4	17	5	17	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	141.37	88.28	118.14	77.61	138.67	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	13	-12	12	-13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000891482	FULL House Resorts INC	FULL Ho	NaN	NaN	2	1	14	33	21	NaN	28	NaN	24	8	14	24	25	NaN	NaN	NaN	160.31	173.45	73.75	34.01	71.38	NaN	52.95	NaN	50.60	64.51	72.62	43.50	42.00	NaN	NaN	NaN	-1	13	19	-12	NaN	NaN	NaN	NaN	-16	6	10	1	NaN
0000911147	Century Casinos INC CO	Century	NaN	NaN	5	3	4	13	12	5	7	14	NaN	NaN	15	22	NaN	NaN	NaN	NaN	137.24	149.84	119.80	98.35	111.96	119.42	127.70	93.58	NaN	NaN	72.53	55.96	NaN	NaN	NaN	NaN	-2	1	9	-1	-7	2	7	NaN	NaN	NaN	7	NaN	NaN
0000912145	Ameristar Casinos INC	Amerist	NaN	NaN	3	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	141.99	165.94	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000918543	Castle Group INC	Castle	NaN	NaN	25	23	19	22	NaN	17	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49.78	62.28	51.80	70.55	NaN	65.31	57.79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-4	3	NaN	NaN	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001005276	Mohegan Tribal Gaming Authority	Mohegan	NaN	NaN	21	24	NaN	NaN	NaN	NaN	23	17	25	21	25	26	NaN	NaN	NaN	NaN	71.40	61.97	NaN	NaN	NaN	NaN	67.58	76.00	42.71	39.22	42.28	42.13	NaN	NaN	NaN	NaN	3	NaN	NaN	NaN	NaN	NaN	-6	8	-4	4	1	NaN	NaN
0001052595	Red Lion Hotels CORP	Red Lio	NaN	NaN	20	22	18	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	78.87	66.08	56.04	103.26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-4	-7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001162556	Dover Downs Gaming Entertainment INC	Dover D	NaN	NaN	16	12	9	14	13	7	11	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	96.74	98.73	100.70	86.75	108.43	105.21	104.13	107.62	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-3	5	-1	-6	4	0	NaN	NaN	NaN	NaN	NaN	NaN
0001180638	WYNN LAS Vegas LLC	WYNN LA	NaN	NaN	24	30	23	25	31	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51.26	40.97	41.64	49.11	40.94	42.12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	-7	2	6	-7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001294538	Great Wolf Resorts Inc	Great W	NaN	NaN	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42.30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001295810	Sunstone Hotel Investors Inc	Sunston	NaN	NaN	17	15	11	12	5	6	8	2	8	17	8	7	7	NaN	NaN	NaN	92.70	93.70	97.37	101.23	138.54	119.40	122.44	179.19	120.71	41.12	116.85	118.19	139.44	NaN	NaN	NaN	-2	-4	1	-7	1	2	-6	6	9	-9	-1	0	NaN
0001297735	American Casino Entertainment Properties LLC	America	NaN	NaN	15	11	10	9	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	97.53	99.53	99.47	109.08	114.78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-1	-1	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001342126	Morgans Hotel Group Co	Morgans	NaN	NaN	30	34	27	34	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23.39	31.54	32.87	29.75	40.66	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-7	7	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001476246	Tropicana Entertainment Inc	Tropica	NaN	NaN	12	NaN	NaN	1	8	4	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	106.02	NaN	NaN	220.66	119.27	120.69	138.66	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-4	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001485589	Nevada Property 1 LLC	Nevada	NaN	NaN	28	31	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41.14	40.51	40.36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000899647	Riviera Holdings CORP	Riviera	NaN	NaN	NaN	33	NaN	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.53	NaN	40.61	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001479046	Tropicana Las Vegas Hotel Casino Inc	Tropica	NaN	NaN	NaN	21	16	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69.77	73.31	82.07	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001487685	Greektown Superholdings Inc	Greekto	NaN	NaN	NaN	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	54.28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001510130	Southern States SIGN Co	Souther	NaN	NaN	NaN	14	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	97.82	40.94	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517007	Marina District Finance Company Inc	Marina	NaN	NaN	NaN	5	6	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	130.49	113.48	151.73	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001551510	Revel AC Inc	Revel A	NaN	NaN	NaN	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.86	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001313536	Sotherly Hotels LP	Sotherl	NaN	NaN	NaN	NaN	20	26	24	20	25	23	19	25	28	14	NaN	NaN	NaN	NaN	NaN	NaN	43.69	48.42	60.54	59.59	61.08	55.17	60.34	33.96	39.24	86.33	NaN	NaN	NaN	NaN	NaN	NaN	6	-2	-4	5	-2	-4	6	3	-14	NaN	NaN
0001499268	Affinity Gaming	Affinit	NaN	NaN	NaN	NaN	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	67.93	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001527705	ALST Casino Holdco LLC	ALST Ca	NaN	NaN	NaN	NaN	21	19	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42.31	73.73	105.67	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517401	Peak Resorts Inc	Peak Re	NaN	NaN	NaN	NaN	NaN	4	10	9	24	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	138.42	115.44	98.29	67.44	67.60	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	-1	15	-4	NaN	NaN	NaN	NaN	NaN	NaN
0001576575	Gaming Entertainment International INC	Gaming	NaN	NaN	NaN	NaN	NaN	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001581164	Extended Stay America Inc	Extende	NaN	NaN	NaN	NaN	NaN	20	18	13	17	15	15	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	72.49	80.12	77.33	79.08	82.40	73.79	156.22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-5	4	-2	0	-14	NaN	NaN	NaN	NaN
0001594617	La Quinta Holdings Inc	La Quin	NaN	NaN	NaN	NaN	NaN	31	23	19	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37.88	66.14	60.81	87.58	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	-4	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001610979	Caesars Entertainment Resort Properties LLC	Caesars	NaN	NaN	NaN	NaN	NaN	29	26	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41.02	53.91	47.33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001656239	Pinnacle Entertainment Inc	Pinnacl	NaN	NaN	NaN	NaN	NaN	NaN	NaN	26	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	31.20	43.61	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001723177	Syndicated Resorts Association Inc	Syndica	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.00	0.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN
0001712189	Target Hospitality Corp	Target	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	5	4	1	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	181.45	121.73	158.27	221.94	396.84	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-1	-3	0	NaN
0001846510	Soho House Co Inc	Soho Ho	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35.23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

PDF reports

All reports for 2024 are collected in a single PDF for easier review.

2009

Logs

error	1 × Minimum and maximum are surprisingly similar	check_abs_values	{'var_name': 'Assets', 'min_val': '8,761,000,000', 'max_val': '8,903,000,000'}
warning	10 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0001048286 0000789570 0000356213 0000921738 0001046311 0001115836 0001174922 0001300514 0001361658
warning	4 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '2 of 2'} {'var_name': 'DepreciationDepletionAndAmortization', 'zeros': '2 of 2'} {'var_name': 'CostOfGoodsAndServicesSold', 'zeros': '2 of 2'} {'var_name': 'OperatingExpenses', 'zeros': '2 of 2'}
warning	1 × Missing logo	subcommand.report	0000316206

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	1,443,000,000	1,538,350,000	2,396,690,700	3,254,650,000	3,350,000,000	0001048286	0000316206	0000316206
1	AssetsNonCurrent	460,000,000	465,300,000	513,010,600	560,700,000	566,000,000	0000316206	0001048286	0001048286
2	AssetsCurrent	1,491,000,000	1,586,750,000	2,448,691,500	3,310,250,000	3,406,000,000	0000316206	0001048286	0001048286
3	IntangibleAssets	0	79,250,000	792,658,500	1,505,750,000	1,585,000,000	0000316206	0001048286	0001048286
4	remainder_Assets	1,903,000,000	1,980,850,000	2,681,655,700	3,382,150,000	3,460,000,000	0001048286	0000316206	0000316206
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	2,027,000,000	2,052,300,000	2,280,050,600	2,507,700,000	2,533,000,000	0000316206	0001048286	0001048286
7	remainder_Liabilities	0	244,450,000	2,444,988,900	4,644,550,000	4,889,000,000	0001048286	0000316206	0000316206
8	GeneralAndAdministrativeExpense	314,000,000	338,450,000	558,548,900	778,550,000	803,000,000	0000316206	0001048286	0001048286
9	DepreciationDepletionAndAmortization	0	0	0	0	0	0000316206	0001048286	0000316206
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	0	0	0	0	0	0000316206	0001048286	0000316206
12	remainder_Expenses	4,306,000,000	4,681,900,000	8,065,751,800	11,448,100,000	11,824,000,000	0000316206	0001048286	0001048286
13	remainder_Revenues	4,712,000,000	5,122,250,000	8,815,320,500	12,506,750,000	12,917,000,000	0000316206	0001048286	0001048286
14	remainder_NetIncome	-317,000,000	-298,300,000	-129,962,600	38,300,000	57,000,000	0000316206	0001048286	0001048286
15	remainder_ComprehensiveNetIncome	-66,000,000	-57,150,000	22,517,700	102,150,000	111,000,000	0001048286	0000316206	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	8,761,000,000	8,768,100,000	8,832,014,200	8,895,900,000	8,903,000,000	0000316206	0001048286	0001048286
1	Liabilities	2,533,000,000	2,752,150,000	4,724,938,300	6,696,850,000	6,916,000,000	0001048286	0000316206	0000316206
2	Expenses	4,620,000,000	5,020,350,000	8,624,300,700	12,226,650,000	12,627,000,000	0000316206	0001048286	0001048286
3	Revenues	4,712,000,000	5,122,250,000	8,815,320,500	12,506,750,000	12,917,000,000	0000316206	0001048286	0001048286
4	StockholdersEquity	1,845,000,000	2,071,250,000	4,107,952,500	6,143,750,000	6,370,000,000	0000316206	0001048286	0001048286
5	NetIncome	-225,000,000	-196,400,000	61,057,200	318,400,000	347,000,000	0000316206	0001048286	0001048286
6	ComprehensiveNetIncome	-114,000,000	-94,250,000	83,539,500	261,250,000	281,000,000	0000316206	0001048286	0001048286
7	BaseVar	31,360,100,000	33,170,868,500	49,471,406,537	65,764,701,500	67,575,470,000	0000316206	0001048286	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	0.113	0.163	0.610	1.06	1.11	0000316206	0001048286	0001048286
9	EconomicCapitalRatio	0.532	0.568	0.890	1.21	1.25	0000316206	0001048286	0001048286

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.0672	-0.0584	0.0209	0.100	0.109	0001048286	0000316206	0000316206
1	AssetsNonCurrent	-0.00597	-0.00525	0.00122	0.00770	0.00842	0001048286	0000316206	0000316206
2	AssetsCurrent	-0.00377	-0.00344	-0.000494	0.00245	0.00278	0000316206	0001048286	0001048286
3	IntangibleAssets	-0.0300	-0.0273	-0.00289	0.0215	0.0242	0000316206	0001048286	0001048286
4	remainder_Assets	-0.0650	-0.0564	0.0219	0.100	0.109	0001048286	0000316206	0000316206
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0420	-0.0330	0.0477	0.128	0.137	0000316206	0001048286	0001048286
7	remainder_Liabilities	-0.252	-0.210	0.167	0.544	0.586	0000316206	0001048286	0001048286
8	GeneralAndAdministrativeExpense	-0.0388	-0.0360	-0.0111	0.0139	0.0166	0001048286	0000316206	0000316206
9	DepreciationDepletionAndAmortization	0	0	0	0	0	0000316206	0001048286	0000316206
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	0	0	0	0	0	0000316206	0001048286	0000316206
12	remainder_Expenses	-0.936	-0.883	-0.402	0.0781	0.131	0001048286	0000316206	0000316206
13	remainder_Revenues	-0.312	-0.255	0.257	0.770	0.827	0000316206	0001048286	0001048286
14	remainder_NetIncome	-0.0927	-0.0775	0.0602	0.198	0.213	0000316206	0001048286	0001048286
15	remainder_ComprehensiveNetIncome	-0.0951	-0.0883	-0.0273	0.0338	0.0406	0001048286	0000316206	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.102	-0.0913	0.00676	0.105	0.116	0001048286	0000316206	0000316206
1	Liabilities	-0.299	-0.251	0.184	0.618	0.666	0000316206	0001048286	0001048286
2	Expenses	-0.988	-0.932	-0.427	0.0786	0.135	0001048286	0000316206	0000316206
3	Revenues	-0.312	-0.255	0.257	0.770	0.827	0000316206	0001048286	0001048286
4	StockholdersEquity	-0.0495	-0.0414	0.0322	0.106	0.114	0000316206	0001048286	0001048286
5	NetIncome	-0.104	-0.0866	0.0674	0.221	0.238	0000316206	0001048286	0001048286
6	ComprehensiveNetIncome	-0.0668	-0.0558	0.0433	0.142	0.153	0000316206	0001048286	0001048286
7	BaseVar	nan	nan	nan	nan	nan	0000316206	0001048286	0000316206
8	EconomicCapitalRatiobeforeLimitedLiability	-0.382	-0.346	-0.0235	0.299	0.335	0000316206	0001048286	0001048286
9	EconomicCapitalRatio	-0.358	-0.323	0.0000717	0.323	0.358	0000316206	0001048286	0001048286

2010

Logs

warning	18 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0000789570 0001048286 0000921738 0001046311 0001115836 0001174922 0001300514 0001361658 0000216877 0000858339 0000918543 0001005276 0001180638 0001297735 0001479046 0001485589
warning	10 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246
warning	2 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '10 of 10'} {'var_name': 'CostOfGoodsAndServicesSold', 'zeros': '10 of 10'}
warning	2 × Missing logo	subcommand.report	0000316206 0000356213
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001479046

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	55,662,000	499,064,100	1,720,137,443	14,530,881,150	14,554,350,000	0001046311	0000921738	0000789570
1	AssetsNonCurrent	0	6,887,250	156,528,406	2,334,974,350	2,951,050,000	0001174922	0001048286	0000789570
2	AssetsCurrent	163,582,000	224,662,300	1,508,485,442	3,754,298,850	4,058,907,000	0001046311	0001174922	0001300514
3	IntangibleAssets	0	15,866,100	143,241,012	1,624,058,600	1,643,000,000	0000316206	0001115836	0001048286
4	remainder_Assets	-429,157,000	-233,132,950	285,712,089	4,274,750,000	4,691,000,000	0000789570	0000921738	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	165,258,000	169,212,150	1,067,397,463	2,555,677,150	2,600,413,000	0001046311	0000789570	0001300514
7	remainder_Liabilities	0	0	1,402,026,723	7,813,180,400	10,009,328,000	0000356213	0000921738	0001300514
8	GeneralAndAdministrativeExpense	94,540,000	137,764,300	401,352,645	971,841,650	1,128,803,000	0001046311	0000921738	0000789570
9	DepreciationDepletionAndAmortization	0	0	142,627,269	667,274,400	694,971,000	0000316206	0001361658	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	0	0	0	1,012,245,600	1,587,000,000	0000316206	0001048286	0001361658
12	remainder_Expenses	63,251,000	207,228,950	2,266,602,338	7,872,898,900	10,489,000,000	0001115836	0001174922	0001048286
13	remainder_Revenues	571,942,000	582,802,300	4,021,643,028	9,533,231,900	11,726,000,000	0001115836	0001174922	0001048286
14	remainder_NetIncome	-1,135,528,000	-754,234,450	-10,195,715	82,355,700	138,000,000	0000789570	0001046311	0000316206
15	remainder_ComprehensiveNetIncome	-15,000,000	-8,250,000	0	550,000	1,000,000	0001048286	0001115836	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	411,722,000	1,074,154,400	7,830,826,153	20,106,839,650	21,044,308,000	0001046311	0001048286	0001300514
1	Liabilities	174,045,000	307,131,600	2,593,222,202	10,215,857,550	12,609,741,000	0000356213	0000921738	0001300514
2	Expenses	486,084,000	541,439,400	3,532,032,804	9,042,445,900	11,269,000,000	0001046311	0001174922	0001048286
3	Revenues	571,942,000	582,802,300	4,021,643,028	9,533,231,900	11,726,000,000	0001115836	0001174922	0001048286
4	StockholdersEquity	-58,071,000	450,851,100	2,433,387,374	13,538,708,350	17,714,824,000	0001046311	0000316206	0000789570
5	NetIncome	-1,437,397,000	-818,729,350	212,206,739	667,931,650	781,603,000	0000789570	0001174922	0001300514
6	ComprehensiveNetIncome	-1,437,397,000	-818,729,350	212,206,739	668,381,650	781,603,000	0000789570	0001174922	0001300514
7	BaseVar	3,054,911,010	3,709,187,488	25,278,306,336	55,248,244,829	61,198,510,000	0001046311	0001361658	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	0.305	0.318	0.616	1.22	1.25	0000921738	0001174922	0001048286
9	EconomicCapitalRatio	0.694	0.705	0.918	1.33	1.36	0000921738	0001174922	0001048286

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.121	-0.120	-0.0127	0.301	0.383	0001046311	0001174922	0000789570
1	AssetsNonCurrent	-0.0224	-0.0212	-0.00955	0.0475	0.0738	0001174922	0000316206	0000789570
2	AssetsCurrent	-0.0583	-0.0453	-0.000249	0.0334	0.0413	0000921738	0001174922	0001115836
3	IntangibleAssets	-0.0354	-0.0353	-0.00977	0.134	0.213	0000316206	0001048286	0000921738
4	remainder_Assets	-0.0610	-0.0568	-0.0218	0.175	0.225	0000789570	0001046311	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0551	-0.0516	-0.00321	0.0947	0.117	0000316206	0000921738	0000356213
7	remainder_Liabilities	-0.236	-0.224	-0.0749	0.624	0.739	0001300514	0000921738	0001048286
8	GeneralAndAdministrativeExpense	-0.302	-0.248	-0.00479	0.293	0.389	0000356213	0001361658	0001048286
9	DepreciationDepletionAndAmortization	-0.184	-0.144	-0.0246	0.261	0.345	0000356213	0001115836	0001048286
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	-0.524	-0.522	0.193	0.386	0.462	0001361658	0001174922	0001048286
12	remainder_Expenses	-3.35	-2.10	-0.118	0.495	0.508	0001048286	0001174922	0001115836
13	remainder_Revenues	-0.313	-0.287	-0.0396	0.902	0.982	0001115836	0000921738	0001048286
14	remainder_NetIncome	-0.301	-0.210	0.0480	0.167	0.180	0000789570	0001361658	0001048286
15	remainder_ComprehensiveNetIncome	-0.00883	-0.00477	0.000301	0.000592	0.000661	0001048286	0001174922	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.139	-0.128	-0.0184	0.266	0.294	0001046311	0000316206	0001115836
1	Liabilities	-0.257	-0.255	-0.0502	0.670	0.770	0001300514	0000921738	0001048286
2	Expenses	-1.62	-1.19	0.0530	0.213	0.243	0001048286	0000316206	0001300514
3	Revenues	-0.313	-0.287	-0.0396	0.902	0.982	0001115836	0000921738	0001048286
4	StockholdersEquity	-0.817	-0.613	-0.0942	0.463	0.549	0001046311	0001361658	0000789570
5	NetIncome	-0.565	-0.401	0.107	0.480	0.746	0000789570	0001300514	0001046311
6	ComprehensiveNetIncome	-0.565	-0.400	0.103	0.481	0.747	0000789570	0001300514	0001046311
7	BaseVar	nan	nan	nan	nan	nan	0000316206	0001048286	0000316206
8	EconomicCapitalRatiobeforeLimitedLiability	-0.286	-0.276	-0.0628	0.354	0.377	0000921738	0001174922	0001048286
9	EconomicCapitalRatio	-0.286	-0.276	-0.0627	0.354	0.377	0000921738	0001174922	0001048286

2011

Logs

warning	24 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0001180638 0001297735 0001485589 0000789570 0001048286 0001300514 0001361658 0000216877 0000858339 0000918543 0001005276 0001115836 0001479046 0000921738 0001046311 0001174922 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007
warning	18 × No stock price available	subcommand.plot	0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001180638 0001294538 0001297735 0001342126 0001485589 0000216877 0000858339 0000918543 0001005276 0001115836 0001162556 0001476246
warning	12 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001294538 0001342126 0000858339 0001162556 0001476246 0000899647
warning	11 × Missing logo	subcommand.report	0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001180638 0001294538 0001297735 0001342126 0001485589
warning	5 × Similarly named company. Duplicate?	None	0000912145 0001300514 0001476246 0001174922 0001468174
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '30 of 30'}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001180638
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001499268
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	7,171,329	25,145,331	1,142,647,900	14,957,028,250	17,266,000,000	0000918543	0001048286	0000858339
1	AssetsNonCurrent	0	0	27,675,882	1,116,651,000	10,086,912,000	0000858339	0001046311	0000789570
2	AssetsCurrent	2,098,004	12,558,089	192,846,374	2,687,296,000	5,397,152,000	0000216877	0001046311	0001300514
3	IntangibleAssets	0	0	52,524,727	5,144,049,300	8,120,700,000	0000216877	0001342126	0000858339
4	remainder_Assets	-7,944,726,000	-4,567,112	44,853,210	2,516,750,000	4,441,000,000	0000789570	0001180638	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001005276	0000216877
6	LiabilitiesCurrent	0	3,403,009	167,400,981	2,270,688,300	2,558,000,000	0001342126	0000912145	0001048286
7	remainder_Liabilities	0	0	507,531,034	8,021,045,750	25,859,400,000	0000789570	0000834162	0000858339
8	GeneralAndAdministrativeExpense	0	2,713,790	172,308,171	1,203,677,250	2,118,500,000	0000216877	0001005276	0000858339
9	DepreciationDepletionAndAmortization	0	0	49,866,498	757,547,200	817,146,000	0000216877	0001294538	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	953,150	6,271,000	0000216877	0000921738	0000834162
11	OperatingExpenses	0	0	0	262,562,100	1,781,000,000	0000216877	0000918543	0001361658
12	remainder_Expenses	5,196,497	34,678,064	534,163,524	6,356,752,350	11,361,000,000	0000216877	0000863015	0001048286
13	remainder_Revenues	0	2,666,506	631,218,687	9,151,434,750	12,317,000,000	0000907242	0001046311	0001048286
14	remainder_NetIncome	-1,134,421,000	-200,098,100	-6,497,100	109,784,843	940,275,000	0000789570	0001048286	0001295810
15	remainder_ComprehensiveNetIncome	-63,000,000	-37,450,000	0	0	66,210	0000316206	0001046311	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	13,195,313	51,491,462	1,940,801,275	25,281,307,150	28,515,600,000	0000918543	0000356213	0000858339
1	Liabilities	6,111,176	18,518,328	811,209,535	10,098,684,050	27,462,200,000	0000216877	0001115836	0000858339
2	Expenses	5,196,497	44,627,404	744,882,105	8,647,899,950	12,113,000,000	0000216877	0001295810	0001048286
3	Revenues	0	2,666,506	631,218,687	9,151,434,750	12,317,000,000	0000907242	0001046311	0001048286
4	StockholdersEquity	-223,770,000	-57,960,400	714,621,008	7,364,133,600	26,021,512,000	0001485589	0001297735	0000789570
5	NetIncome	-666,700,000	-96,379,450	4,551,710	1,407,016,300	3,234,944,000	0000858339	0001162556	0000789570
6	ComprehensiveNetIncome	-666,700,000	-96,379,450	4,220,801	1,407,016,300	3,234,944,000	0000858339	0001162556	0000789570
7	BaseVar	38,516,458	262,483,038	5,804,138,757	61,035,300,499	72,530,761,000	0000216877	0001485589	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-0.817	-0.282	0.696	1.45	2.43	0001342126	0001297735	0000789570
9	EconomicCapitalRatio	0.234	0.392	0.971	1.52	2.43	0001342126	0001297735	0000789570

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.495	-0.265	-0.00516	0.227	0.375	0000918543	0000891482	0001297735
1	AssetsNonCurrent	-0.408	-0.0670	-0.00996	0.00511	0.0118	0000789570	0001295810	0001468174
2	AssetsCurrent	-0.102	-0.0609	-0.00549	0.0380	0.0485	0000918543	0001295810	0000316206
3	IntangibleAssets	-0.254	-0.114	-0.0146	0.0441	0.102	0000789570	0000912145	0000921738
4	remainder_Assets	-0.0384	-0.0319	-0.00534	0.178	0.299	0001162556	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001005276	0000216877
6	LiabilitiesCurrent	-0.286	-0.124	0.00690	0.0782	0.118	0001005276	0000216877	0000912145
7	remainder_Liabilities	-0.544	-0.344	0.0487	0.667	0.699	0001485589	0001052595	0000912145
8	GeneralAndAdministrativeExpense	-1.00	-0.673	0.00137	0.468	0.629	0000907242	0001485589	0001048286
9	DepreciationDepletionAndAmortization	-0.192	-0.167	-0.00898	0.255	0.596	0001294538	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.0250	-0.00576	0.00186	0.00534	0.00621	0001052595	0000921738	0001048286
11	OperatingExpenses	-1.05	-0.635	0.101	0.211	0.356	0000834162	0000789570	0001048286
12	remainder_Expenses	-5.14	-2.98	-0.0568	0.544	0.976	0001048286	0000921738	0000789570
13	remainder_Revenues	-4.72	-1.11	0.194	0.976	1.20	0000907242	0001468174	0000891482
14	remainder_NetIncome	-0.501	-0.399	-0.135	0.444	1.27	0000912145	0000216877	0000907242
15	remainder_ComprehensiveNetIncome	-0.0289	-0.0178	0.00167	0.00376	0.0280	0001048286	0001468174	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.772	-0.467	-0.00357	0.192	0.232	0000789570	0001342126	0001297735
1	Liabilities	-0.510	-0.323	0.0503	0.670	0.752	0001485589	0001297735	0000912145
2	Expenses	-2.83	-1.20	-0.0254	0.228	0.969	0001048286	0000316206	0000789570
3	Revenues	-4.72	-1.11	0.194	0.976	1.20	0000907242	0001468174	0000891482
4	StockholdersEquity	-0.811	-0.707	-0.0757	0.441	0.980	0000918543	0001485589	0000789570
5	NetIncome	-0.273	-0.213	-0.0192	0.626	0.919	0001115836	0001485589	0000789570
6	ComprehensiveNetIncome	-0.272	-0.212	-0.0241	0.630	0.920	0001115836	0001485589	0000789570
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001005276	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.699	-0.541	0.0385	0.588	1.50	0001342126	0001297735	0000789570
9	EconomicCapitalRatio	-0.717	-0.559	0.0204	0.570	1.48	0001342126	0001297735	0000789570

2012

Logs

error	2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001005276
warning	27 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0001180638 0001297735 0001479046 0001485589 0001487685 0001510130 0001517007 0001551510 0000789570 0000921738 0001046311 0001048286 0001115836 0001174922 0001300514 0001361658 0001499268 0000216877 0000808377 0000858339 0000918543 0001005276 0001061937 0001313536 0001527705
warning	22 × No stock price available	subcommand.plot	0000316206 0000356213 0000834162 0000863015 0000899647 0000912145 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001487685 0001510130 0001517007 0001551510 0001115836 0000216877 0000858339 0000918543 0001005276 0001162556
warning	16 × Missing logo	subcommand.report	0000316206 0000356213 0000834162 0000863015 0000899647 0000912145 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001487685 0001510130 0001517007 0001551510
warning	14 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000834162 0000863015 0000899647 0000912145 0001052595 0001342126 0001046311 0001115836 0000858339 0001162556 0001294538 0001476246
warning	6 × Similarly named company. Duplicate?	None	0000912145 0001479046 0000906553 0001174922 0001300514 0001468174
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '35 of 35'}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001517007
warning	1 × Negative minimum value	check_abs_values	{'var_name': 'OperatingExpenses', 'min_value': -4889000}
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001499268
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	7,380,379	40,423,890	1,171,872,212	14,646,766,400	15,766,748,000	0000918543	0001115836	0001300514
1	AssetsNonCurrent	0	0	41,040,676	1,215,296,199	9,582,994,000	0000858339	0001485589	0000789570
2	AssetsCurrent	2,228,853	5,228,059	185,353,756	2,803,044,400	4,477,514,000	0000216877	0000356213	0001300514
3	IntangibleAssets	0	0	40,322,553	3,604,816,200	7,640,680,000	0000216877	0000891482	0000789570
4	remainder_Assets	-7,640,680,000	-357,729,676	35,216,657	1,456,040,000	4,458,000,000	0000789570	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001048286	0000216877
6	LiabilitiesCurrent	0	3,917,231	176,196,371	2,598,656,900	2,773,000,000	0001342126	0001046311	0001048286
7	remainder_Liabilities	0	0	330,798,055	7,493,624,600	25,741,400,000	0000789570	0001297735	0000858339
8	GeneralAndAdministrativeExpense	0	308,700	139,119,758	1,284,541,800	2,103,800,000	0000216877	0001517007	0000858339
9	DepreciationDepletionAndAmortization	0	0	43,983,793	768,463,800	927,697,000	0000316206	0001115836	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	248,400	7,374,000	0000216877	0001005276	0000834162
11	OperatingExpenses	-4,889,000	0	0	251,806,200	1,842,000,000	0001517007	0000316206	0001361658
12	remainder_Expenses	3,070,000	17,069,403	430,364,852	7,322,077,200	10,644,000,000	0001510130	0001517007	0001048286
13	remainder_Revenues	0	0	609,476,824	9,751,930,400	11,814,000,000	0000899647	0001485589	0001048286
14	remainder_NetIncome	-1,861,121,000	-291,163,800	-230,215	121,969,902	877,600,000	0000789570	0000911147	0001295810
15	remainder_ComprehensiveNetIncome	-223,326,000	-156,341,600	0	21,340,000	33,000,000	0001174922	0000216877	0001468174

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	12,990,627	82,223,646	1,576,047,994	23,399,977,800	27,998,100,000	0000918543	0000863015	0000858339
1	Liabilities	5,912,369	17,348,517	751,254,676	9,323,972,000	28,329,700,000	0000216877	0000906553	0000858339
2	Expenses	5,390,568	17,897,708	628,807,755	9,535,653,900	11,289,000,000	0000216877	0001517007	0001048286
3	Revenues	0	0	609,476,824	9,751,930,400	11,814,000,000	0000899647	0001485589	0001048286
4	StockholdersEquity	-548,904,000	-338,609,078	209,373,636	6,504,663,900	24,359,067,000	0001046311	0001005276	0000789570
5	NetIncome	-1,616,912,000	-1,093,812,500	471,553	618,309,700	1,881,813,000	0000789570	0000216877	0001300514
6	ComprehensiveNetIncome	-1,759,366,000	-1,078,478,900	471,905	572,900,000	1,693,067,000	0000789570	0000216877	0001300514
7	BaseVar	39,888,269	139,004,372	4,114,140,400	63,986,354,547	73,688,800,000	0000216877	0001517007	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-1.43	-0.400	0.443	1.49	1.70	0001551510	0001115836	0000891482
9	EconomicCapitalRatio	0.0686	0.364	0.798	1.55	1.73	0001551510	0001115836	0000891482

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.419	-0.271	-0.00983	0.263	0.358	0000918543	0000356213	0001479046
1	AssetsNonCurrent	-0.169	-0.107	-0.0333	0.103	0.433	0000918543	0001115836	0001510130
2	AssetsCurrent	-0.0902	-0.0673	-0.00299	0.0582	0.0949	0000906553	0001551510	0000899647
3	IntangibleAssets	-0.128	-0.0641	-0.00843	0.111	0.141	0000918543	0001180638	0000789570
4	remainder_Assets	-0.235	-0.120	0.0192	0.157	0.357	0001551510	0001479046	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001048286	0000216877
6	LiabilitiesCurrent	-0.231	-0.0376	0.0704	0.242	0.345	0001510130	0000216877	0000891482
7	remainder_Liabilities	-0.493	-0.277	0.00987	0.604	0.913	0001485589	0001297735	0001048286
8	GeneralAndAdministrativeExpense	-0.659	-0.609	0.00494	0.427	0.628	0000907242	0001485589	0001048286
9	DepreciationDepletionAndAmortization	-0.164	-0.0858	-0.00926	0.266	0.510	0001479046	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.0261	-0.00468	0.00120	0.00303	0.00446	0000834162	0001479046	0001048286
11	OperatingExpenses	-1.36	-0.556	0.0863	0.186	0.273	0000834162	0000789570	0001048286
12	remainder_Expenses	-4.39	-2.64	-0.0250	0.522	0.605	0001048286	0001174922	0001361658
13	remainder_Revenues	-3.28	-1.57	0.231	0.995	1.33	0000907242	0001005276	0001048286
14	remainder_NetIncome	-0.711	-0.564	-0.224	0.789	1.08	0001517007	0000863015	0000907242
15	remainder_ComprehensiveNetIncome	-0.399	-0.0465	0.0106	0.0374	0.0696	0000863015	0000216877	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.490	-0.284	-0.000439	0.230	0.306	0000918543	0001180638	0001510130
1	Liabilities	-0.559	-0.336	0.0273	0.730	0.920	0001510130	0000921738	0001048286
2	Expenses	-2.35	-1.06	-0.0159	0.234	0.556	0001048286	0001551510	0001510130
3	Revenues	-3.28	-1.57	0.231	0.995	1.33	0000907242	0001005276	0001048286
4	StockholdersEquity	-0.743	-0.660	-0.0127	0.484	0.589	0001046311	0000921738	0000789570
5	NetIncome	-0.849	-0.426	0.111	0.478	0.992	0000906553	0001295810	0000891482
6	ComprehensiveNetIncome	-0.820	-0.414	0.119	0.488	1.02	0000906553	0001295810	0000891482
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001048286	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.733	-0.438	-0.00346	0.745	0.933	0001551510	0001115836	0000891482
9	EconomicCapitalRatio	-0.759	-0.463	-0.0292	0.719	0.907	0001551510	0001115836	0000891482

2013

Logs

error	9 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001499268 0001046311 0001046311 0001046311 0001046311 0001005276 0001005276 0001005276 0001005276
warning	30 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0001180638 0001297735 0001479046 0001485589 0001499268 0001510130 0001517007 0001527705 0000918543 0000921738 0001046311 0001048286 0001061937 0001115836 0001174922 0001361658 0000216877 0000858339 0001005276 0001313536 0000789570 0001610979 0001517401 0001576575 0001300514 0001551510 0000808377 0001487685
warning	21 × No stock price available	subcommand.plot	0000316206 0000356213 0000834162 0000863015 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001499268 0001510130 0001517007 0001527705 0000918543 0001061937 0001115836 0000216877 0000858339 0001162556 0001313536
warning	16 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000834162 0000863015 0001052595 0001342126 0001046311 0001115836 0000858339 0001162556 0000899647 0001581164 0001594617 0001476246 0000912145 0001294538
warning	14 × Missing logo	subcommand.report	0000316206 0000356213 0000834162 0000863015 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001499268 0001510130 0001517007 0001527705
warning	3 × Similarly named company. Duplicate?	None	0001479046 0001499268 0001061937
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001517007 0001566897
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '29 of 29'}
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001499268
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	7,160,790	31,971,738	498,959,393	8,570,779,600	13,237,900,000	0000918543	0000921738	0000858339
1	AssetsNonCurrent	0	0	6,402,116	360,200,000	543,000,000	0000858339	0001527705	0000316206
2	AssetsCurrent	2,426,013	6,489,189	126,013,651	2,579,688,400	3,770,300,000	0000216877	0000834162	0000858339
3	IntangibleAssets	0	0	15,512,431	2,021,200,000	6,551,000,000	0000216877	0001052595	0000858339
4	remainder_Assets	-59,916,000	-20,196,000	15,799,945	1,146,080,000	4,277,000,000	0001510130	0001313536	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001115836	0000216877
6	LiabilitiesCurrent	0	0	64,555,629	2,288,080,000	2,675,000,000	0001061937	0000834162	0001048286
7	remainder_Liabilities	0	0	327,485,707	6,603,887,000	24,061,900,000	0000863015	0001297735	0000858339
8	GeneralAndAdministrativeExpense	0	1,744,233	77,515,954	1,173,000,000	2,168,600,000	0000216877	0001499268	0000858339
9	DepreciationDepletionAndAmortization	0	0	27,816,417	487,540,400	697,000,000	0000316206	0001499268	0001061937
10	CostOfGoodsAndServicesSold	0	0	0	321,000	8,309,000	0000216877	0001115836	0000834162
11	OperatingExpenses	0	0	0	332,756,400	2,161,000,000	0000216877	0000858339	0001361658
12	remainder_Expenses	-3,115,000	12,698,074	218,151,196	7,326,000,000	11,461,000,000	0001510130	0001342126	0001048286
13	remainder_Revenues	0	0	445,785,769	7,581,820,000	12,784,000,000	0000907242	0001499268	0001048286
14	remainder_NetIncome	-303,568,000	-215,561,800	-196,375	165,733,390	975,011,000	0001174922	0000216877	0001295810
15	remainder_ComprehensiveNetIncome	-276,769,000	-85,264,800	0	2,661,200	5,506,000	0001174922	0001297735	0000863015

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	13,399,348	45,259,911	1,175,674,546	11,584,800,000	24,688,900,000	0000918543	0001297735	0000858339
1	Liabilities	5,576,209	30,025,139	439,801,669	8,193,207,400	26,592,700,000	0000216877	0001499268	0000858339
2	Expenses	5,689,182	15,828,123	528,523,348	9,119,880,000	12,187,000,000	0000216877	0000834162	0001048286
3	Revenues	0	0	445,785,769	7,581,820,000	12,784,000,000	0000907242	0001499268	0001048286
4	StockholdersEquity	-1,903,800,000	-326,463,800	137,283,680	3,816,600,000	7,452,000,000	0000858339	0001052595	0001061937
5	NetIncome	-2,939,800,000	-529,955,800	-5,258,688	631,400,000	1,004,157,000	0000858339	0001527705	0001174922
6	ComprehensiveNetIncome	-2,939,800,000	-580,382,400	-5,258,688	633,200,000	727,388,000	0000858339	0001527705	0001174922
7	BaseVar	41,183,641	121,623,617	3,177,430,078	53,144,116,000	73,983,472,000	0000216877	0000834162	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-1.80	-0.580	0.360	1.22	1.32	0000921738	0001361658	0000907242
9	EconomicCapitalRatio	0.0237	0.314	0.737	1.33	1.41	0000921738	0001361658	0000907242

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.488	-0.332	-0.0290	0.310	0.350	0000918543	0001052595	0001479046
1	AssetsNonCurrent	-0.142	-0.0575	-0.0234	0.0456	0.332	0000918543	0001061937	0001510130
2	AssetsCurrent	-0.0680	-0.0556	-0.00697	0.0436	0.0800	0001313536	0000907242	0001174922
3	IntangibleAssets	-0.137	-0.0687	-0.00496	0.0661	0.148	0000918543	0001180638	0001499268
4	remainder_Assets	-0.258	-0.0666	0.0103	0.114	0.314	0001510130	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001115836	0000216877
6	LiabilitiesCurrent	-0.206	-0.0844	0.00242	0.0840	0.108	0001162556	0001180638	0000891482
7	remainder_Liabilities	-0.430	-0.303	0.0172	0.619	0.999	0001485589	0001061937	0001048286
8	GeneralAndAdministrativeExpense	-0.719	-0.609	0.0127	0.512	0.767	0000891482	0001180638	0001048286
9	DepreciationDepletionAndAmortization	-0.141	-0.109	0.000363	0.269	0.542	0001479046	0000356213	0001048286
10	CostOfGoodsAndServicesSold	-0.0115	-0.000790	0.00141	0.00414	0.00592	0001052595	0001479046	0001048286
11	OperatingExpenses	-1.27	-0.611	0.0534	0.247	0.521	0000834162	0000858339	0001048286
12	remainder_Expenses	-4.92	-2.94	-0.0441	0.462	0.576	0001048286	0001174922	0001361658
13	remainder_Revenues	-3.93	-2.46	0.172	0.827	1.41	0000907242	0001052595	0001048286
14	remainder_NetIncome	-0.886	-0.659	-0.199	0.648	1.41	0001517007	0001313536	0000907242
15	remainder_ComprehensiveNetIncome	-0.102	-0.0148	0.00719	0.0367	0.0693	0001174922	0001297735	0001162556

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.550	-0.349	-0.0217	0.240	0.312	0000918543	0001342126	0001479046
1	Liabilities	-0.387	-0.304	0.112	0.643	0.996	0001485589	0001061937	0001048286
2	Expenses	-2.31	-1.08	-0.0417	0.248	0.369	0001048286	0001517007	0001174922
3	Revenues	-3.93	-2.46	0.172	0.827	1.41	0000907242	0001052595	0001048286
4	StockholdersEquity	-0.640	-0.447	-0.0619	0.437	0.557	0000918543	0000316206	0001517007
5	NetIncome	-0.415	-0.308	0.00203	0.472	0.754	0000921738	0001297735	0001048286
6	ComprehensiveNetIncome	-0.399	-0.300	0.00833	0.487	0.793	0000921738	0000834162	0001048286
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001115836	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.679	-0.388	0.0345	0.631	0.707	0000921738	0001361658	0000907242
9	EconomicCapitalRatio	-0.724	-0.434	-0.0110	0.586	0.661	0000921738	0001361658	0000907242

2014

Logs

error	13 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001046311 0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001005276 0001499268 0001499268 0001499268 0001499268
warning	37 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0000863015 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001576575 0001610979 0000789570 0000918543 0000921738 0001046311 0001048286 0001061937 0001115836 0001174922 0001361658 0001581164 0001594617 0000216877 0000858339 0001005276 0001162556 0001313536 0001476246 0001499268 0001517401 0001300514 0001485589 0001510130 0001551510 0000808377 0001487685
warning	24 × No stock price available	subcommand.plot	0000316206 0000356213 0000863015 0000899647 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001576575 0001610979 0000918543 0001061937 0001115836 0001581164 0001594617 0000216877 0000858339 0001162556 0001313536 0001476246 0001517401
warning	16 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000863015 0000899647 0001052595 0001342126 0001046311 0001115836 0001581164 0001594617 0000858339 0001162556 0001476246 0000834162 0000912145 0001294538
warning	13 × Missing logo	subcommand.report	0000316206 0000356213 0000863015 0000899647 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001576575 0001610979
warning	9 × Similarly named company. Duplicate?	None	0001479046 0001527705 0001576575 0001610979 0001061937 0001174922 0001468174 0001590895 0001517401
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '37 of 37'}
warning	1 × Negative minimum value	check_abs_values	{'var_name': 'OperatingExpenses', 'min_value': -1746000}
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001499268
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	13,066,324	1,065,622,625	11,151,200,000	14,441,542,000	0001576575	0001297735	0000789570
1	AssetsNonCurrent	0	0	4,179,298	4,282,429,800	23,626,000,000	0000858339	0001052595	0001585689
2	AssetsCurrent	1,470	4,662,800	132,758,259	2,831,296,800	3,673,000,000	0001576575	0000863015	0000858339
3	IntangibleAssets	0	0	54,102,968	5,643,600,000	7,261,966,000	0000216877	0001342126	0000789570
4	remainder_Assets	-13,637,000,000	-3,856,916,400	23,001,209	982,600,000	4,380,000,000	0001585689	0001313536	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001180638	0000216877
6	LiabilitiesCurrent	0	0	118,454,352	3,129,585,000	18,280,000,000	0001061937	0001590584	0000858339
7	remainder_Liabilities	0	0	318,200,304	8,030,284,000	19,154,000,000	0000789570	0001297735	0001585689
8	GeneralAndAdministrativeExpense	0	0	85,471,035	1,366,399,200	2,306,000,000	0000216877	0001590895	0000858339
9	DepreciationDepletionAndAmortization	0	0	50,462,569	649,000,000	815,765,000	0000316206	0001476246	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	68,521	9,348,000	0000216877	0001115836	0001590895
11	OperatingExpenses	-1,746,000	0	0	472,557,600	2,262,000,000	0001517007	0000356213	0001361658
12	remainder_Expenses	-6,602,000	4,650,806	354,556,255	9,520,000,000	12,462,000,000	0001594617	0001476246	0000858339
13	remainder_Revenues	0	0	738,241,420	10,165,987,200	13,796,000,000	0000891482	0001517007	0001048286
14	remainder_NetIncome	-848,816,000	-307,532,800	0	275,600,000	1,145,688,000	0000789570	0001162556	0001295810
15	remainder_ComprehensiveNetIncome	-367,000,000	-240,511,000	-3,887	0	2,227,000	0001585689	0000918543	0000863015

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	17,250	16,307,644	1,297,974,055	24,053,000,000	26,702,511,000	0001576575	0001517007	0000789570
1	Liabilities	80,665	10,761,109	906,283,782	11,363,616,000	28,277,000,000	0001576575	0001115836	0000858339
2	Expenses	65,287	20,512,305	644,497,082	10,547,000,000	15,404,000,000	0001576575	0001517007	0000858339
3	Revenues	0	0	738,241,420	10,165,987,200	13,796,000,000	0000891482	0001517007	0001048286
4	StockholdersEquity	-4,742,000,000	-77,443,000	290,336,374	5,289,800,000	23,294,586,000	0000858339	0000356213	0000789570
5	NetIncome	-7,196,000,000	-347,725,600	650,449	748,200,000	962,644,000	0000858339	0000918543	0001174922
6	ComprehensiveNetIncome	-7,196,000,000	-353,339,200	228,509	698,200,000	731,146,000	0000858339	0001527705	0001174922
7	BaseVar	291,854	113,110,383	4,494,011,696	70,749,770,000	84,295,480,000	0001576575	0001115836	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-3.94	-0.816	0.360	1.33	2.20	0001576575	0001527705	0001476246
9	EconomicCapitalRatio	0.000000421	0.245	0.737	1.42	2.21	0001576575	0001527705	0001476246

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.376	-0.230	-0.0204	0.285	0.404	0000918543	0000907242	0001479046
1	AssetsNonCurrent	-0.112	-0.0701	-0.0230	0.151	0.418	0000918543	0000858339	0001585689
2	AssetsCurrent	-0.0510	-0.0446	-0.00118	0.0520	0.0763	0000863015	0001297735	0001174922
3	IntangibleAssets	-0.110	-0.0597	-0.00666	0.0706	0.114	0000918543	0001517007	0001585689
4	remainder_Assets	-0.318	-0.107	0.00186	0.107	0.298	0001594617	0000907242	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001180638	0000216877
6	LiabilitiesCurrent	-0.238	-0.0750	0.0217	0.124	0.152	0000899647	0000911147	0001061937
7	remainder_Liabilities	-0.455	-0.402	0.0194	0.563	0.978	0001313536	0001297735	0001048286
8	GeneralAndAdministrativeExpense	-0.684	-0.575	0.0209	0.479	0.789	0000907242	0001342126	0001048286
9	DepreciationDepletionAndAmortization	-0.145	-0.132	-0.00705	0.314	0.531	0000907242	0001297735	0001048286
10	CostOfGoodsAndServicesSold	-0.0307	0.000814	0.00913	0.0201	0.0348	0001590895	0001361658	0001048286
11	OperatingExpenses	-2.84	-0.714	0.105	0.305	0.494	0001517401	0000891482	0001048286
12	remainder_Expenses	-4.74	-2.09	-0.0357	0.476	1.23	0001048286	0000789570	0001517401
13	remainder_Revenues	-3.89	-3.19	0.123	0.934	1.40	0000907242	0001297735	0001048286
14	remainder_NetIncome	-1.15	-0.988	-0.240	0.755	1.36	0001517401	0001313536	0000907242
15	remainder_ComprehensiveNetIncome	-0.356	-0.0875	0.0259	0.0963	0.123	0001115836	0000921738	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.430	-0.256	-0.0129	0.210	0.285	0000918543	0001468174	0001581164
1	Liabilities	-0.350	-0.330	0.0581	0.621	0.979	0001180638	0000891482	0001048286
2	Expenses	-2.12	-1.11	0.0448	0.323	0.461	0001048286	0001517007	0001476246
3	Revenues	-3.89	-3.19	0.123	0.934	1.40	0000907242	0001297735	0001048286
4	StockholdersEquity	-0.629	-0.329	-0.00275	0.540	0.576	0001048286	0001576575	0001517401
5	NetIncome	-0.476	-0.320	0.0900	0.463	1.25	0000863015	0000356213	0001476246
6	ComprehensiveNetIncome	-0.402	-0.349	0.105	0.536	1.29	0001590584	0001517401	0001476246
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001180638	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.679	-0.435	0.0580	0.742	1.53	0001576575	0001527705	0001476246
9	EconomicCapitalRatio	-0.793	-0.548	-0.0555	0.629	1.41	0001576575	0001527705	0001476246

2015

Logs

error	15 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268 0001499268
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0000863015 0001180638 0001297735 0001342126 0001527705 0001610979 0000789570 0000858339 0000921738 0001046311 0001048286 0001061937 0001115836 0001174922 0001361658 0001581164 0001594617 0000216877 0001005276 0001052595 0001162556 0001313536 0001476246 0001499268 0001517401 0001300514 0001656239 0000918543 0001479046 0001485589 0001510130 0001551510 0000808377 0001487685 0001517007 0001576575
warning	19 × No stock price available	subcommand.plot	0000316206 0000356213 0000844887 0000863015 0001180638 0001297735 0001342126 0001527705 0001610979 0000858339 0001061937 0001115836 0001581164 0001594617 0000216877 0001162556 0001313536 0001476246 0001517401
warning	17 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000863015 0001342126 0000789570 0000858339 0001046311 0001115836 0001581164 0001594617 0001052595 0001162556 0001476246 0000834162 0000912145 0001294538 0000899647
warning	9 × Missing logo	subcommand.report	0000316206 0000356213 0000844887 0000863015 0001180638 0001297735 0001342126 0001527705 0001610979
warning	6 × Similarly named company. Duplicate?	None	0001180638 0001610979 0001061937 0001468174 0001590895 0001313536
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	43,705,185	1,053,888,563	9,735,800,000	15,371,795,000	0000844887	0001297735	0000789570
1	AssetsNonCurrent	0	0	12,761,106	4,662,206,200	23,131,000,000	0000863015	0001590584	0001585689
2	AssetsCurrent	16,153	7,937,428	233,649,178	2,447,560,600	2,585,000,000	0000844887	0000356213	0001585689
3	IntangibleAssets	0	0	83,276,074	3,674,619,200	5,887,000,000	0000216877	0001581164	0001585689
4	remainder_Assets	-15,006,000,000	-3,919,159,400	35,232,003	1,059,600,000	4,525,000,000	0001585689	0001180638	0001361658
5	LongTermLiabilities	0	0	0	0	271,977,944	0000216877	0001115836	0001313536
6	LiabilitiesCurrent	0	0	125,121,254	2,329,570,600	3,233,000,000	0001061937	0001115836	0001048286
7	remainder_Liabilities	0	0	771,643,766	8,529,697,200	17,298,000,000	0000789570	0001342126	0001585689
8	GeneralAndAdministrativeExpense	0	2,886,868	134,281,802	1,309,041,600	1,574,000,000	0000216877	0001046311	0001361658
9	DepreciationDepletionAndAmortization	0	0	63,083,238	701,600,000	819,883,000	0000216877	0001476246	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	11,199,400	212,000,000	0000216877	0001115836	0000858339
11	OperatingExpenses	0	0	0	740,441,600	2,461,000,000	0000216877	0000911147	0001361658
12	remainder_Expenses	-316,458,000	-106,747,713	568,990,190	8,024,761,200	13,065,000,000	0001594617	0001476246	0001048286
13	remainder_Revenues	0	0	860,252,934	10,022,840,800	14,486,000,000	0000844887	0001046311	0001048286
14	remainder_NetIncome	-632,128,000	-386,234,600	619,281	780,485,200	6,108,000,000	0000789570	0001476246	0000858339
15	remainder_ComprehensiveNetIncome	-172,926,000	-168,365,200	-2,112,021	907,200	592,960,000	0001581164	0000863015	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,637,212	62,198,472	1,514,199,381	17,403,071,200	25,716,000,000	0000844887	0001115836	0001585689
1	Liabilities	4,722,130	32,574,449	1,114,186,510	10,177,365,600	19,765,000,000	0000216877	0001046311	0001585689
2	Expenses	1,486,315	49,429,910	924,492,326	9,823,353,400	13,699,000,000	0000844887	0001594617	0001048286
3	Revenues	0	0	860,252,934	10,022,840,800	14,486,000,000	0000844887	0001046311	0001048286
4	StockholdersEquity	-678,043,000	-334,027,600	564,072,896	6,460,600,000	22,977,227,000	0000921738	0001590584	0000789570
5	NetIncome	-1,039,649,000	-103,638,800	20,663,451	1,081,800,000	6,052,000,000	0000789570	0000907242	0000858339
6	ComprehensiveNetIncome	-446,689,000	-171,204,000	12,089,510	939,000,000	5,920,000,000	0000789570	0001297735	0000858339
7	BaseVar	14,260,125	296,286,858	5,384,435,121	66,398,579,970	75,538,780,000	0000844887	0000863015	0001585689
8	EconomicCapitalRatiobeforeLimitedLiability	-1.27	-0.200	0.469	1.39	2.73	0001590584	0001585689	0000858339
9	EconomicCapitalRatio	0.100	0.408	0.817	1.46	2.73	0001590584	0001585689	0000858339

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.275	-0.200	-0.0125	0.240	0.299	0001046311	0001342126	0001581164
1	AssetsNonCurrent	-0.0584	-0.0544	-0.0226	0.232	0.492	0001046311	0001061937	0001594617
2	AssetsCurrent	-0.0492	-0.0363	-0.00191	0.0705	0.0875	0000356213	0001581164	0001174922
3	IntangibleAssets	-0.0507	-0.0451	-0.00779	0.0905	0.116	0000858339	0001476246	0001610979
4	remainder_Assets	-0.330	-0.135	-0.00102	0.210	0.321	0001594617	0000907242	0000844887
5	LongTermLiabilities	-0.700	0.00127	0.0259	0.0684	0.119	0001313536	0000316206	0001048286
6	LiabilitiesCurrent	-0.634	-0.157	0.0223	0.121	0.148	0000844887	0001610979	0000863015
7	remainder_Liabilities	-0.513	-0.394	0.0385	0.721	0.948	0001342126	0000316206	0001048286
8	GeneralAndAdministrativeExpense	-0.712	-0.669	0.00769	0.481	0.925	0000891482	0001342126	0001048286
9	DepreciationDepletionAndAmortization	-0.200	-0.131	-0.00222	0.256	0.602	0001590584	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.223	-0.0529	0.00759	0.0157	0.0317	0000911147	0001061937	0001048286
11	OperatingExpenses	-2.04	-1.36	0.170	0.412	0.922	0001590895	0001581164	0001048286
12	remainder_Expenses	-6.82	-1.84	-0.144	0.744	0.921	0001048286	0001590584	0001590895
13	remainder_Revenues	-3.90	-3.51	0.134	1.05	1.34	0000907242	0000356213	0001048286
14	remainder_NetIncome	-1.73	-0.970	-0.353	1.34	1.82	0001048286	0001594617	0000858339
15	remainder_ComprehensiveNetIncome	-0.284	-0.223	0.0339	0.106	0.199	0001590584	0001594617	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.249	-0.182	-0.00363	0.155	0.193	0001046311	0001590895	0001581164
1	Liabilities	-0.550	-0.361	-0.00435	0.735	0.954	0000844887	0000316206	0001048286
2	Expenses	-3.31	-1.32	0.00212	0.289	0.940	0001048286	0001361658	0000858339
3	Revenues	-3.90	-3.51	0.134	1.05	1.34	0000907242	0000356213	0001048286
4	StockholdersEquity	-0.714	-0.369	-0.0481	0.436	0.659	0001048286	0001585689	0000789570
5	NetIncome	-0.525	-0.326	-0.0337	0.299	2.00	0000789570	0001174922	0000858339
6	ComprehensiveNetIncome	-0.919	-0.298	-0.0260	0.309	2.01	0001590584	0001174922	0000858339
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001174922	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.803	-0.495	-0.0859	0.562	1.83	0001590584	0001585689	0000858339
9	EconomicCapitalRatio	-0.824	-0.516	-0.108	0.540	1.81	0001590584	0001585689	0000858339

2016

Logs

error	14 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001005276 0001052595 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001180638 0001610979 0000789570 0000858339 0000921738 0001046311 0001048286 0001061937 0001115836 0001174922 0001300514 0001361658 0001581164 0001594617 0001656239 0000918543 0001005276 0001052595 0001162556 0001313536 0001476246 0001517401 0000316206 0000356213 0000216877 0000863015 0001297735 0001342126 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001576575
warning	19 × The stock price does not exist	industry.us_generic	0000789570 0000858339 0001046311 0001115836 0001581164 0001594617 0001052595 0001162556 0001476246 0001617406 0001692412 0000316206 0000356213 0000834162 0000863015 0000912145 0001294538 0001342126 0000899647
warning	14 × No stock price available	subcommand.plot	0000844887 0001180638 0001610979 0000858339 0001061937 0001115836 0001581164 0001594617 0001656239 0000918543 0001162556 0001313536 0001476246 0001517401
warning	5 × Similarly named company. Duplicate?	None	0001300514 0001468174 0001590895 0001313536 0001517401
warning	3 × Missing logo	subcommand.report	0000844887 0001180638 0001610979
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001617406 0001479046 0000808377
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001594617 0001499268
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001692412
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	5,601,687	2,386,842,948	9,719,750,000	15,903,000,000	0000844887	0001653653	0001300514
1	AssetsNonCurrent	0	0	24,344,979	2,198,366,950	22,654,000,000	0000844887	0001180638	0001585689
2	AssetsCurrent	17,958	13,156,481	275,514,294	3,491,900,000	4,988,000,000	0000844887	0001610979	0000858339
3	IntangibleAssets	0	0	98,844,064	5,161,000,000	16,868,000,000	0000844887	0001300514	0001048286
4	remainder_Assets	-15,771,000,000	-1,711,962,150	11,451,508	1,019,700,000	4,677,000,000	0001585689	0001590895	0001361658
5	LongTermLiabilities	0	0	0	0	282,708,289	0000844887	0001174922	0001313536
6	LiabilitiesCurrent	0	0	213,614,549	4,327,650,000	7,748,000,000	0000844887	0001653653	0000858339
7	remainder_Liabilities	0	2,763,950	1,480,488,501	10,240,043,750	17,678,000,000	0001048286	0001594617	0001585689
8	GeneralAndAdministrativeExpense	0	2,012,197	177,442,829	1,242,700,000	1,543,000,000	0000918543	0001594617	0001361658
9	DepreciationDepletionAndAmortization	0	0	151,900,385	710,700,000	1,111,000,000	0000844887	0001653653	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	5,812,950	26,921,000	0000844887	0001174922	0001590895
11	OperatingExpenses	0	0	0	864,531,300	2,511,000,000	0000844887	0000921738	0001361658
12	remainder_Expenses	-305,480,000	-155,125,691	671,277,444	8,953,800,000	15,638,000,000	0001594617	0001361658	0001048286
13	remainder_Revenues	0	0	1,139,149,783	11,574,450,000	17,072,000,000	0000844887	0001581164	0001048286
14	remainder_NetIncome	-2,378,000,000	-348,432,100	-950,161	256,445,600	1,207,469,000	0000858339	0000911147	0001295810
15	remainder_ComprehensiveNetIncome	-824,000,000	-364,700,000	-83,292	2,139,350	16,000,000	0000858339	0001656239	0001061937

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,601,317	68,154,665	3,329,264,979	22,855,150,000	26,211,000,000	0000844887	0001653653	0001585689
1	Liabilities	9,057,686	26,268,989	2,520,410,123	15,143,350,000	20,362,000,000	0000844887	0001581164	0001585689
2	Expenses	775,349	47,987,758	1,088,825,675	10,638,350,000	16,342,000,000	0000844887	0001581164	0001048286
3	Revenues	0	0	1,139,149,783	11,574,450,000	17,072,000,000	0000844887	0001581164	0001048286
4	StockholdersEquity	-1,418,000,000	-483,666,000	387,699,855	7,391,700,000	18,993,000,000	0000858339	0001590584	0001048286
5	NetIncome	-2,747,000,000	-330,912,500	30,648,904	776,850,000	2,016,000,000	0000858339	0001115836	0001300514
6	ComprehensiveNetIncome	-3,571,000,000	-329,955,450	24,688,616	711,750,000	1,617,000,000	0000858339	0001590895	0001300514
7	BaseVar	10,181,397	327,216,669	8,736,168,125	75,269,005,000	96,017,150,000	0000844887	0001581164	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.17	-0.950	0.329	1.19	1.69	0000858339	0001361658	0000907242
9	EconomicCapitalRatio	0.124	0.195	0.713	1.31	1.72	0000858339	0001361658	0000907242

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.411	-0.230	-0.0145	0.191	0.354	0000918543	0000858339	0001581164
1	AssetsNonCurrent	-0.139	-0.0604	-0.0264	0.264	0.445	0000918543	0001476246	0001594617
2	AssetsCurrent	-0.0601	-0.0502	-0.00225	0.0706	0.0986	0000921738	0001468174	0001174922
3	IntangibleAssets	-0.157	-0.0600	-0.0114	0.180	0.238	0000918543	0001468174	0001048286
4	remainder_Assets	-0.356	-0.215	-0.0157	0.208	0.421	0001594617	0001048286	0001313536
5	LongTermLiabilities	-0.740	0.000892	0.0227	0.0714	0.0837	0001313536	0001585689	0000907242
6	LiabilitiesCurrent	-0.360	-0.0977	0.0114	0.127	0.232	0001517401	0001468174	0000918543
7	remainder_Liabilities	-0.300	-0.273	0.0272	0.707	0.839	0001610979	0001046311	0000907242
8	GeneralAndAdministrativeExpense	-0.788	-0.525	0.000102	0.444	0.582	0000907242	0001180638	0001162556
9	DepreciationDepletionAndAmortization	-0.476	-0.137	-0.00524	0.310	0.357	0001590584	0001180638	0001162556
10	CostOfGoodsAndServicesSold	-0.203	-0.0496	0.00688	0.0157	0.0256	0000911147	0001610979	0000918543
11	OperatingExpenses	-2.50	-1.08	0.123	0.431	0.506	0001590895	0001656239	0000907242
12	remainder_Expenses	-5.27	-2.72	-0.0722	0.594	0.696	0000918543	0001174922	0001590895
13	remainder_Revenues	-6.77	-3.28	0.122	0.872	0.993	0000918543	0001313536	0001162556
14	remainder_NetIncome	-0.483	-0.361	-0.182	0.917	1.72	0000921738	0001361658	0000907242
15	remainder_ComprehensiveNetIncome	-0.0687	-0.0644	0.0104	0.0575	0.103	0001581164	0001656239	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.511	-0.209	0.00747	0.167	0.187	0000918543	0001061937	0001581164
1	Liabilities	-0.281	-0.218	0.0254	0.694	0.890	0001174922	0001590584	0000907242
2	Expenses	-2.16	-1.26	0.0101	0.238	0.271	0000918543	0001180638	0001653653
3	Revenues	-6.77	-3.28	0.122	0.872	0.993	0000918543	0001313536	0001162556
4	StockholdersEquity	-0.438	-0.355	-0.00838	0.414	0.478	0000918543	0001594617	0000907242
5	NetIncome	-0.469	-0.254	0.106	0.404	0.534	0001590584	0001115836	0000907242
6	ComprehensiveNetIncome	-0.424	-0.276	0.106	0.385	0.582	0001590584	0001174922	0000907242
7	BaseVar	nan	nan	nan	nan	nan	0000844887	0001180638	0000844887
8	EconomicCapitalRatiobeforeLimitedLiability	-0.623	-0.553	-0.0343	0.564	0.974	0000858339	0001361658	0000907242
9	EconomicCapitalRatio	-0.656	-0.586	-0.0671	0.531	0.941	0000858339	0001361658	0000907242

2017

Logs

error	14 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001052595 0001052595 0001005276 0001005276 0001005276 0001005276 0001499268 0001499268
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000789570 0000921738 0001046311 0001048286 0001052595 0001061937 0001115836 0001174922 0001300514 0001361658 0001581164 0001594617 0001656239 0000918543 0001005276 0001162556 0001313536 0001476246 0001517401 0000216877 0001723177 0000316206 0000356213 0000858339 0000863015 0001180638 0001297735 0001342126 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001610979 0001576575
warning	20 × The stock price does not exist	industry.us_generic	0000789570 0001046311 0001052595 0001115836 0001581164 0001594617 0001617406 0001692412 0001162556 0001476246 0001585689 0000316206 0000356213 0000834162 0000858339 0000863015 0000912145 0001294538 0001342126 0000899647
warning	17 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000911147 0000921738 0001048286 0001052595 0001061937 0001300514 0001468174 0001581164 0001590584 0001590895 0001594617 0001005276 0001162556 0000907242 0001295810 0001674168 0001499268
warning	13 × No stock price available	subcommand.plot	0000844887 0001061937 0001115836 0001581164 0001594617 0001656239 0001692412 0000918543 0001005276 0001162556 0001313536 0001476246 0001517401
warning	7 × Ignoring company because Expenses is zero	pre-agg	0001617406 0001617406 0001617406 0001617406 0001585689 0001479046 0000808377
warning	3 × Similarly named company. Duplicate?	None	0001590895 0001656239 0001476246
warning	3 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001692412 0001295810
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	3,015,362	1,466,435,473	12,604,000,000	19,635,459,000	0000844887	0001692412	0000789570
1	AssetsNonCurrent	0	0	22,338,486	2,053,671,500	7,149,092,000	0000844887	0001295810	0000789570
2	AssetsCurrent	435	16,218,184	251,079,388	3,085,500,000	3,423,784,000	0000844887	0001590895	0001174922
3	IntangibleAssets	0	0	89,018,441	3,714,206,500	18,012,000,000	0000844887	0001300514	0001048286
4	remainder_Assets	-5,684,491,000	-1,414,392,500	98,852,806	1,031,500,000	4,642,000,000	0000789570	0001476246	0001361658
5	LongTermLiabilities	0	0	0	389,659,408	898,215,000	0000789570	0001115836	0001692412
6	LiabilitiesCurrent	0	0	134,655,870	3,020,191,000	6,010,000,000	0000918543	0001115836	0001048286
7	remainder_Liabilities	0	0	845,775,589	8,327,049,500	10,104,000,000	0000789570	0001046311	0001300514
8	GeneralAndAdministrativeExpense	0	2,920,630	145,104,981	1,418,000,000	1,559,915,000	0000918543	0001476246	0000789570
9	DepreciationDepletionAndAmortization	0	0	105,952,656	872,240,000	1,171,000,000	0000844887	0001590895	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	191,452,500	603,253,000	0000844887	0001115836	0001616000
11	OperatingExpenses	0	0	0	1,068,759,500	2,194,000,000	0000789570	0000921738	0001361658
12	remainder_Expenses	-480,034,000	-222,976,446	631,278,132	6,056,734,000	21,393,000,000	0001590895	0001476246	0001048286
13	remainder_Revenues	0	0	1,008,190,984	11,827,952,000	22,894,000,000	0000844887	0001046311	0001048286
14	remainder_NetIncome	-605,748,000	-483,027,000	-475,206	880,857,500	1,245,288,000	0000789570	0000844887	0001295810
15	remainder_ComprehensiveNetIncome	-322,000,000	-150,147,500	0	96,500,000	480,000,000	0001300514	0001313536	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,476,612	88,681,387	2,953,582,636	22,317,500,000	29,159,178,000	0000844887	0001594617	0000789570
1	Liabilities	9,919,588	30,084,700	1,471,409,334	10,561,694,500	13,052,000,000	0000844887	0001616000	0001300514
2	Expenses	122,469	55,330,184	1,096,702,432	8,804,869,000	22,287,000,000	0000918543	0001295810	0001048286
3	Revenues	0	0	1,008,190,984	11,827,952,000	22,894,000,000	0000844887	0001046311	0001048286
4	StockholdersEquity	-320,971,000	-142,624,000	637,475,635	12,786,500,000	26,066,796,000	0001656239	0001653653	0000789570
5	NetIncome	-105,254,000	-24,988,000	76,490,197	1,734,209,000	3,261,000,000	0001590584	0001005276	0001300514
6	ComprehensiveNetIncome	-70,996,000	-3,118,002	74,047,563	1,896,762,500	2,939,000,000	0001590584	0001590895	0001300514
7	BaseVar	10,609,387	440,420,099	8,222,208,197	67,627,336,015	126,865,660,000	0000844887	0001295810	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.21	0.0304	0.440	1.68	1.84	0000844887	0001115836	0000789570
9	EconomicCapitalRatio	0.116	0.453	0.796	1.71	1.86	0000844887	0001115836	0000789570

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.264	-0.220	-0.0112	0.252	0.368	0001046311	0001048286	0001581164
1	AssetsNonCurrent	-0.0732	-0.0591	-0.0235	0.175	0.525	0001590584	0001674168	0001594617
2	AssetsCurrent	-0.109	-0.0834	-0.0165	0.0680	0.176	0001656239	0001468174	0000918543
3	IntangibleAssets	-0.0789	-0.0623	-0.0180	0.0531	0.311	0001590584	0001616000	0001590895
4	remainder_Assets	-0.411	-0.169	-0.00829	0.139	0.444	0000891482	0001476246	0001313536
5	LongTermLiabilities	-0.782	-0.332	0.0451	0.135	0.173	0001313536	0000921738	0001048286
6	LiabilitiesCurrent	-0.156	-0.0200	0.0783	0.188	0.194	0000844887	0001590895	0000906553
7	remainder_Liabilities	-0.731	-0.286	0.0521	0.733	0.902	0000918543	0001590584	0001048286
8	GeneralAndAdministrativeExpense	-0.751	-0.669	0.00163	0.413	0.619	0000891482	0000789570	0001162556
9	DepreciationDepletionAndAmortization	-0.543	-0.125	-0.0109	0.311	0.400	0001590584	0001174922	0001048286
10	CostOfGoodsAndServicesSold	-0.984	-0.0908	0.0444	0.0975	0.117	0001616000	0001313536	0001048286
11	OperatingExpenses	-1.41	-0.991	0.185	0.401	0.517	0001590895	0001653653	0001048286
12	remainder_Expenses	-3.61	-2.46	-0.172	0.652	0.787	0001048286	0001295810	0001594617
13	remainder_Revenues	-3.82	-2.53	0.261	1.02	1.28	0000907242	0001590895	0001048286
14	remainder_NetIncome	-0.674	-0.522	-0.272	0.966	1.70	0000906553	0001656239	0000907242
15	remainder_ComprehensiveNetIncome	-0.0895	-0.0666	-0.00709	0.0954	0.137	0001581164	0001517401	0001115836

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.347	-0.250	-0.0304	0.119	0.277	0000891482	0001300514	0000918543
1	Liabilities	-0.616	-0.154	0.0388	0.855	0.995	0000918543	0001616000	0001048286
2	Expenses	-1.93	-1.29	0.0342	0.260	0.333	0001162556	0001295810	0000921738
3	Revenues	-3.82	-2.53	0.261	1.02	1.28	0000907242	0001590895	0001048286
4	StockholdersEquity	-0.439	-0.291	0.0116	0.528	0.735	0001046311	0001468174	0000789570
5	NetIncome	-0.729	-0.284	0.0621	0.409	0.534	0001590584	0001476246	0001300514
6	ComprehensiveNetIncome	-0.557	-0.302	0.0535	0.381	0.460	0001590584	0001468174	0001300514
7	BaseVar	nan	nan	nan	nan	nan	0000789570	0001295810	0000789570
8	EconomicCapitalRatiobeforeLimitedLiability	-0.814	-0.477	-0.133	0.781	0.932	0000844887	0001115836	0000789570
9	EconomicCapitalRatio	-0.827	-0.490	-0.146	0.768	0.919	0000844887	0001115836	0000789570

2018

Logs

error	13 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
warning	56 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000907242 0000907242 0000907242 0000907242 0000911147 0000921738 0000921738 0000921738 0000921738 0001005276 0001005276 0001005276 0001005276 0001048286 0001048286 0001048286 0001048286 0001052595 0001061937 0001061937 0001061937 0001061937 0001162556 0001174922 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001581164 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001674168 0001674168 0001674168 0001674168 0000858339 0000891482 0001653653 0001747079 0001499268 0001594617
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001723177 0000789570 0000921738 0001005276 0001046311 0001048286 0001052595 0001061937 0001115836 0001162556 0001174922 0001300514 0001361658 0001581164 0000216877 0001313536 0001517401 0000858339 0000316206 0000356213 0000863015 0000918543 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001594617 0001610979 0001576575 0001656239
warning	21 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001052595 0001115836 0001162556 0001581164 0001585689 0001617406 0001692412 0000858339 0000316206 0000356213 0000834162 0000863015 0000912145 0001294538 0001342126 0001476246 0000899647 0001594617
warning	11 × No stock price available	subcommand.plot	0000844887 0001723177 0001005276 0001061937 0001115836 0001162556 0001581164 0000216877 0001313536 0001517401 0001692412
warning	9 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001295810 0001295810 0001692412
warning	9 × Ignoring company because Expenses is zero	pre-agg	0000911147 0001585689 0001617406 0001617406 0001617406 0001617406 0001617406 0001479046 0000808377
warning	2 × Missing logo	subcommand.report	0000844887 0001723177
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	0	1,396,442,912	13,535,800,000	20,729,888,000	0000844887	0001005276	0000789570
1	AssetsNonCurrent	0	0	2,308,805	1,376,800,000	6,954,040,000	0000216877	0000907242	0000789570
2	AssetsCurrent	1,797	1,348,337	243,897,552	2,686,612,800	5,566,000,000	0001723177	0001046311	0001300514
3	IntangibleAssets	0	0	81,022,773	4,961,685,500	17,419,000,000	0000216877	0001674168	0001048286
4	remainder_Assets	-5,765,855,000	0	109,243,692	985,100,000	4,893,000,000	0000789570	0001581164	0001361658
5	LongTermLiabilities	0	0	0	532,248,653	989,387,000	0000216877	0001048286	0001692412
6	LiabilitiesCurrent	0	0	59,515,819	3,094,564,600	6,437,000,000	0001061937	0000907242	0001048286
7	remainder_Liabilities	0	0	862,424,282	9,510,998,400	12,645,000,000	0000789570	0001115836	0001300514
8	GeneralAndAdministrativeExpense	0	2,888	104,031,135	1,063,500,000	1,483,000,000	0000216877	0001061937	0001300514
9	DepreciationDepletionAndAmortization	0	0	81,903,548	825,978,800	1,111,000,000	0000789570	0001005276	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	217,056,737	689,762,000	0000789570	0001048286	0001616000
11	OperatingExpenses	0	0	0	372,924,000	1,642,000,000	0000216877	0001046311	0001361658
12	remainder_Expenses	21,570	594,585	686,679,257	9,805,488,400	18,017,000,000	0000844887	0001295810	0001048286
13	remainder_Revenues	0	2,541,011	1,169,829,055	13,139,228,800	20,758,000,000	0000844887	0001295810	0001048286
14	remainder_NetIncome	-687,790,000	-509,860,900	0.0780	627,300,000	932,000,000	0000789570	0001162556	0001061937
15	remainder_ComprehensiveNetIncome	-592,000,000	-325,464,400	-159,787	704,200	53,000,000	0001300514	0001162556	0001468174

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	1,797	9,597,149	2,754,084,426	23,351,300,000	30,210,706,000	0001723177	0001674168	0000789570
1	Liabilities	13,320	5,370,063	1,317,394,376	11,049,973,300	15,802,000,000	0001723177	0001616000	0001300514
2	Expenses	61,889	2,567,028	1,025,067,141	10,706,723,600	19,170,000,000	0001723177	0001295810	0001048286
3	Revenues	0	2,541,011	1,169,829,055	13,139,228,800	20,758,000,000	0000844887	0001295810	0001048286
4	StockholdersEquity	-569,000,000	-130,384,040	640,497,496	14,389,500,000	27,261,824,000	0001361658	0001115836	0000789570
5	NetIncome	-81,847,000	-19,958,847	115,091,056	1,680,200,000	2,951,000,000	0001590584	0000906553	0001300514
6	ComprehensiveNetIncome	-125,279,000	-47,163,700	112,666,094	1,402,000,000	2,359,000,000	0001590584	0001581164	0001300514
7	BaseVar	156,783	22,483,809	8,397,020,347	77,484,491,818	112,953,470,000	0001723177	0001005276	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-40.6	-0.526	0.643	1.69	1.91	0001723177	0000911147	0000216877
9	EconomicCapitalRatio	0	0.325	0.936	1.72	1.92	0001723177	0000911147	0000216877

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.245	-0.181	0.00000511	0.262	0.354	0001313536	0001723177	0001692412
1	AssetsNonCurrent	-0.0171	-0.0151	-0.00426	0.0220	0.0297	0001162556	0001590895	0001468174
2	AssetsCurrent	-0.0507	-0.0376	-0.00468	0.0329	0.0944	0001361658	0001590895	0001674168
3	IntangibleAssets	-0.0740	-0.0633	-0.00820	0.101	0.214	0001162556	0000907242	0001590895
4	remainder_Assets	-0.0848	-0.0666	-0.0181	0.290	0.371	0001162556	0000907242	0001313536
5	LongTermLiabilities	-0.728	-0.376	0.0556	0.137	0.160	0001313536	0001005276	0001048286
6	LiabilitiesCurrent	-0.779	0.00609	0.0912	0.194	0.266	0000844887	0000907242	0001061937
7	remainder_Liabilities	-0.528	-0.458	0.00701	0.635	0.673	0001361658	0001590584	0001048286
8	GeneralAndAdministrativeExpense	-0.717	-0.464	0.0495	0.405	0.564	0000911147	0001300514	0001162556
9	DepreciationDepletionAndAmortization	-0.311	-0.216	0.00288	0.236	0.356	0001590584	0001468174	0001162556
10	CostOfGoodsAndServicesSold	-1.17	-0.803	0.136	0.242	0.299	0001616000	0001517401	0001162556
11	OperatingExpenses	-1.21	-0.598	0.129	0.258	0.321	0001517401	0001313536	0001162556
12	remainder_Expenses	-3.70	-1.93	0.0000948	0.536	0.811	0001162556	0001723177	0001616000
13	remainder_Revenues	-0.403	-0.164	0.111	0.812	1.04	0000844887	0001061937	0001048286
14	remainder_NetIncome	-0.342	-0.234	-0.0395	0.357	0.531	0000906553	0001313536	0001295810
15	remainder_ComprehensiveNetIncome	-0.111	-0.0833	0.0210	0.0668	0.0747	0000911147	0001692412	0000216877

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.210	-0.113	0.00000351	0.128	0.197	0001162556	0001723177	0001692412
1	Liabilities	-0.464	-0.317	0.0401	0.708	0.764	0000844887	0001300514	0001048286
2	Expenses	-1.51	-0.588	0.129	0.314	0.423	0001162556	0001313536	0001295810
3	Revenues	-0.403	-0.164	0.111	0.812	1.04	0000844887	0001061937	0001048286
4	StockholdersEquity	-0.371	-0.237	0.0358	0.636	0.652	0001046311	0001468174	0000216877
5	NetIncome	-0.274	-0.106	0.245	0.601	0.749	0001590584	0001005276	0001295810
6	ComprehensiveNetIncome	-0.452	-0.135	0.189	0.644	0.772	0001590584	0000906553	0001295810
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001174922	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.236	0.0890	0.700	1.49	1.69	0001723177	0000911147	0000216877
9	EconomicCapitalRatio	-0.969	-0.644	-0.0331	0.753	0.953	0001723177	0000911147	0000216877

2019

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001585689
warning	82 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000789570 0000789570 0000858339 0000891482 0000891482 0000891482 0000891482 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0001005276 0001005276 0001005276 0001005276 0001005276 0001048286 0001048286 0001048286 0001048286 0001048286 0001061937 0001061937 0001061937 0001061937 0001061937 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001581164 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001747079 0001747079 0001747079 0001747079 0001585689 0001052595 0001162556 0001499268 0001594617
warning	40 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001723177 0000789570 0000858339 0000921738 0001005276 0001046311 0001048286 0001061937 0001174922 0001300514 0001361658 0001581164 0000216877 0001313536 0000844887 0000316206 0000356213 0001115836 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001594617 0001610979 0001517401 0001576575 0001656239
warning	21 × The stock price does not exist	industry.us_generic	0000789570 0000858339 0000911147 0001046311 0001581164 0001617406 0001692412 0001585689 0000316206 0000356213 0001115836 0000834162 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246 0000899647 0001594617
warning	11 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0000911147 0000911147 0001617406 0001617406 0001617406 0001617406 0001585689 0001479046 0000808377
warning	9 × No stock price available	subcommand.plot	0001723177 0000858339 0001005276 0001061937 0001581164 0001692412 0001747079 0000216877 0001313536
warning	9 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001295810 0001692412
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001581164
warning	1 × Missing logo	subcommand.report	0001723177
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	4,594,488	1,931,693,986	14,936,400,000	18,285,955,000	0001313536	0001692412	0000789570
1	AssetsNonCurrent	0	0	60,025,925	4,165,200,000	11,582,708,000	0000216877	0001674168	0000789570
2	AssetsCurrent	1,669	10,023,382	346,833,289	3,743,485,100	5,305,000,000	0001723177	0001581164	0001300514
3	IntangibleAssets	0	0	159,068,076	6,558,520,400	17,689,000,000	0000216877	0001712189	0001048286
4	remainder_Assets	-5,911,068,000	-9,016,000	195,825,535	927,500,000	5,305,000,000	0000789570	0001005276	0001361658
5	LongTermLiabilities	0	0	0	976,860,600	1,293,054,000	0000216877	0001046311	0001616000
6	LiabilitiesCurrent	0	0	110,471,486	3,214,226,900	6,677,000,000	0001061937	0001590584	0001048286
7	remainder_Liabilities	-5,516,000	0	972,642,054	12,858,700,000	21,071,000,000	0001712189	0001295810	0000858339
8	GeneralAndAdministrativeExpense	0	0	111,038,449	1,768,000,000	2,101,217,000	0000216877	0001674168	0000789570
9	DepreciationDepletionAndAmortization	0	0	51,132,332	1,121,800,000	1,304,649,000	0000906553	0001674168	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	388,849,400	772,857,000	0000891482	0001046311	0001616000
11	OperatingExpenses	0	0	0	367,835,000	1,648,000,000	0000789570	0001046311	0001361658
12	remainder_Expenses	29,527	6,338,902	861,624,188	7,708,500,000	18,613,000,000	0001723177	0001005276	0001048286
13	remainder_Revenues	0	55,584,594	1,389,977,894	13,487,201,600	20,972,000,000	0001723177	0001005276	0001048286
14	remainder_NetIncome	-973,969,000	-556,640,000	-2,051	546,200,000	902,000,000	0000789570	0001723177	0001468174
15	remainder_ComprehensiveNetIncome	-569,000,000	-182,410,000	0	6,040,400	30,000,000	0001300514	0001295810	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	1,669	77,865,054	3,919,264,217	25,256,800,000	33,876,356,000	0001723177	0001295810	0000789570
1	Liabilities	4,989	48,612,882	2,374,513,576	15,387,180,000	23,134,000,000	0001723177	0001005276	0000858339
2	Expenses	40,348	34,903,177	1,254,338,020	10,658,196,900	19,892,000,000	0001723177	0001005276	0001048286
3	Revenues	0	55,584,594	1,389,977,894	13,487,201,600	20,972,000,000	0001723177	0001005276	0001048286
4	StockholdersEquity	-524,000,000	-16,458,696	810,450,776	15,101,900,000	30,684,933,000	0001361658	0001692412	0000789570
5	NetIncome	-1,198,000,000	-42,854,900	81,161,659	1,931,966,000	3,304,000,000	0000858339	0001590895	0001300514
6	ComprehensiveNetIncome	-1,232,000,000	-42,892,800	67,598,916	1,822,608,600	2,735,000,000	0000858339	0001581164	0001300514
7	BaseVar	105,530	333,326,512	9,190,796,515	80,559,879,108	114,883,670,000	0001723177	0001005276	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-62.2	-0.121	0.460	1.78	1.82	0001723177	0001747079	0000789570
9	EconomicCapitalRatio	0	0.416	0.811	1.80	1.85	0001723177	0001747079	0000789570

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.234	-0.202	-0.0310	0.285	0.316	0001313536	0000789570	0001581164
1	AssetsNonCurrent	-0.0905	-0.0386	-0.00859	0.0327	0.125	0000789570	0000891482	0000921738
2	AssetsCurrent	-0.0512	-0.0501	-0.00659	0.0467	0.112	0001692412	0001046311	0001674168
3	IntangibleAssets	-0.0809	-0.0649	-0.0183	0.116	0.163	0001174922	0001712189	0001590895
4	remainder_Assets	-0.0965	-0.0643	-0.00855	0.212	0.457	0000891482	0001061937	0001313536
5	LongTermLiabilities	-1.79	-0.455	0.0668	0.164	0.184	0001712189	0001747079	0001048286
6	LiabilitiesCurrent	-0.312	-0.122	-0.0180	0.0716	0.101	0001048286	0000906553	0001061937
7	remainder_Liabilities	-0.454	-0.363	0.0000826	0.643	0.701	0001361658	0001723177	0001048286
8	GeneralAndAdministrativeExpense	-0.633	-0.352	0.0492	0.394	0.457	0000891482	0001174922	0000906553
9	DepreciationDepletionAndAmortization	-0.161	-0.142	-0.00585	0.173	0.190	0001061937	0000907242	0000906553
10	CostOfGoodsAndServicesSold	-1.15	-0.740	0.0983	0.181	0.220	0001616000	0000907242	0001048286
11	OperatingExpenses	-2.02	-0.596	0.131	0.211	0.266	0000216877	0001174922	0001048286
12	remainder_Expenses	-2.26	-1.38	0.00401	0.824	1.28	0001048286	0001005276	0000216877
13	remainder_Revenues	-0.199	-0.155	0.0465	0.520	0.822	0001692412	0001361658	0001048286
14	remainder_NetIncome	-0.296	-0.223	0.0371	0.179	0.533	0001712189	0001581164	0001468174
15	remainder_ComprehensiveNetIncome	-0.0883	-0.0672	0.0142	0.0371	0.0717	0001581164	0000907242	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.285	-0.125	-0.0131	0.160	0.225	0000891482	0001712189	0001692412
1	Liabilities	-0.505	-0.279	-0.0737	0.679	0.703	0001712189	0001674168	0000906553
2	Expenses	-0.856	-0.385	0.0818	0.315	0.959	0001048286	0000907242	0001712189
3	Revenues	-0.199	-0.155	0.0465	0.520	0.822	0001692412	0001361658	0001048286
4	StockholdersEquity	-0.311	-0.284	-0.0454	0.603	0.718	0001046311	0000858339	0000789570
5	NetIncome	-0.293	-0.217	0.178	0.586	1.22	0001590584	0001295810	0001712189
6	ComprehensiveNetIncome	-0.238	-0.165	0.189	0.561	1.24	0001590584	0001295810	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001300514	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.0377	0.379	0.773	1.76	1.81	0001723177	0001747079	0000789570
9	EconomicCapitalRatio	-0.925	-0.509	-0.114	0.878	0.920	0001723177	0001747079	0000789570

2020

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
warning	102 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001581164 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001747079 0001747079 0001747079 0001747079 0001747079 0000858339 0001052595 0001162556 0001499268 0001594617
warning	40 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000844887 0000216877 0000789570 0000921738 0001005276 0001046311 0001048286 0001061937 0001174922 0001300514 0001361658 0001581164 0001313536 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001594617 0001610979 0001517401 0001576575 0001656239 0001723177
warning	21 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001581164 0001585689 0001617406 0001692412 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246 0000899647 0001594617
warning	11 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0001005276 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412
warning	9 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	8 × No stock price available	subcommand.plot	0000844887 0000216877 0001005276 0001061937 0001581164 0001692412 0001747079 0001313536
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001581164
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	5,438,018	1,621,267,634	14,527,409,150	15,109,000,000	0000844887	0001692412	0001300514
1	AssetsNonCurrent	0	0	62,294,291	9,949,910,000	15,912,184,000	0000216877	0001653653	0000789570
2	AssetsCurrent	88,711	13,379,011	434,035,524	5,338,628,350	6,667,000,000	0000844887	0001295810	0001590895
3	IntangibleAssets	0	0	126,414,839	11,096,200,000	18,164,000,000	0000216877	0001712189	0001048286
4	remainder_Assets	-6,094,000,000	-3,732,895,800	143,068,751	1,004,200,000	2,174,000,000	0001585689	0001692412	0001361658
5	LongTermLiabilities	0	0	0	753,350,000	1,374,480,000	0000216877	0001061937	0001616000
6	LiabilitiesCurrent	0	0	113,124,267	2,531,100,000	5,752,000,000	0001061937	0001590584	0001048286
7	remainder_Liabilities	0	0	1,494,983,558	15,512,500,000	28,766,000,000	0000789570	0001692412	0001590895
8	GeneralAndAdministrativeExpense	0	0	98,126,908	1,117,570,000	2,122,333,000	0000216877	0001692412	0000789570
9	DepreciationDepletionAndAmortization	0	0	117,579,219	1,007,925,700	1,210,556,000	0000844887	0001361658	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	277,496,450	460,148,000	0000844887	0001046311	0000789570
11	OperatingExpenses	0	0	0	296,600,000	1,130,000,000	0000789570	0000921738	0001361658
12	remainder_Expenses	395,700	8,755,833	647,827,495	4,274,950,000	9,625,000,000	0000216877	0001005276	0001048286
13	remainder_Revenues	0	29,855,892	968,562,475	4,862,803,300	10,571,000,000	0000844887	0001581164	0001048286
14	remainder_NetIncome	-1,195,000,000	-722,550,050	-5,767,506	97,007,500	178,000,000	0001590895	0001692412	0001061937
15	remainder_ComprehensiveNetIncome	-73,578,000	-12,900,000	0	262,667,700	490,000,000	0001581164	0000844887	0001300514

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,564,888	89,039,568	3,438,613,076	32,295,600,000	36,494,934,000	0000844887	0001653653	0000789570
1	Liabilities	3,871,882	63,840,359	2,310,730,726	17,900,800,000	31,351,000,000	0000216877	0001674168	0001590895
2	Expenses	1,593,703	37,599,169	1,122,346,410	5,748,258,700	10,733,000,000	0000844887	0001005276	0001048286
3	Revenues	0	29,855,892	968,562,475	4,862,803,300	10,571,000,000	0000844887	0001581164	0001048286
4	StockholdersEquity	-1,486,000,000	-887,260,950	472,267,003	14,568,750,000	34,638,351,000	0001585689	0001692412	0000789570
5	NetIncome	-2,326,946,000	-2,008,250,000	-187,700,066	85,242,950	989,297,000	0001174922	0001653653	0001581164
6	ComprehensiveNetIncome	-2,061,962,000	-1,698,500,000	-164,180,778	85,289,950	915,719,000	0001174922	0001005276	0001581164
7	BaseVar	15,265,579	306,715,947	8,152,503,754	52,458,197,584	67,366,850,000	0000844887	0001005276	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.77	-0.661	-0.0964	1.33	1.51	0000844887	0000921738	0001581164
9	EconomicCapitalRatio	0.0265	0.286	0.420	1.42	1.56	0000844887	0000921738	0001581164

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.230	-0.168	-0.0175	0.251	0.279	0001046311	0001712189	0001617406
1	AssetsNonCurrent	-0.0605	-0.0570	-0.0130	0.119	0.258	0001590584	0001361658	0001585689
2	AssetsCurrent	-0.0666	-0.0435	-0.00253	0.0599	0.0663	0001590584	0000921738	0001674168
3	IntangibleAssets	-0.0756	-0.0676	-0.0110	0.112	0.340	0001061937	0001295810	0001048286
4	remainder_Assets	-0.0813	-0.0578	-0.0100	0.0556	0.334	0000891482	0001712189	0001313536
5	LongTermLiabilities	-0.491	-0.0483	0.00498	0.0564	0.0627	0001616000	0001585689	0000216877
6	LiabilitiesCurrent	-0.0843	-0.0258	0.0204	0.106	0.144	0001048286	0001313536	0001581164
7	remainder_Liabilities	-0.633	-0.253	-0.0196	0.633	0.669	0001581164	0001046311	0001048286
8	GeneralAndAdministrativeExpense	-0.556	-0.219	-0.000691	0.159	0.284	0000891482	0001590895	0000216877
9	DepreciationDepletionAndAmortization	-0.154	-0.116	0.00435	0.133	0.133	0001061937	0001005276	0001712189
10	CostOfGoodsAndServicesSold	-0.485	-0.218	0.0166	0.0874	0.111	0001616000	0001585689	0000891482
11	OperatingExpenses	-1.67	-0.227	0.0290	0.146	0.193	0000216877	0001585689	0000891482
12	remainder_Expenses	-1.55	-1.03	-0.0107	0.353	0.787	0001590584	0001061937	0000216877
13	remainder_Revenues	-0.313	-0.269	0.000608	0.599	0.724	0001295810	0000921738	0001048286
14	remainder_NetIncome	-0.231	-0.107	0.0151	0.133	0.167	0001712189	0001585689	0001616000
15	remainder_ComprehensiveNetIncome	-0.0939	-0.0177	-0.00169	0.0330	0.0394	0001581164	0001617406	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.468	-0.268	-0.00127	0.154	0.161	0001590584	0001468174	0000789570
1	Liabilities	-0.333	-0.197	0.00354	0.654	0.731	0001581164	0001468174	0000906553
2	Expenses	-1.26	-0.492	-0.0138	0.380	0.712	0001590584	0001585689	0001581164
3	Revenues	-0.313	-0.269	0.000608	0.599	0.724	0001295810	0000921738	0001048286
4	StockholdersEquity	-0.273	-0.183	-0.0182	0.570	0.836	0001046311	0001300514	0000789570
5	NetIncome	-0.484	-0.247	-0.00484	0.703	1.14	0001295810	0001590895	0001581164
6	ComprehensiveNetIncome	-0.491	-0.251	-0.00171	0.699	1.09	0001295810	0000921738	0001581164
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001295810	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.488	-0.228	-0.0946	0.904	1.05	0000844887	0000921738	0001581164
9	EconomicCapitalRatio	-0.607	-0.347	-0.213	0.785	0.929	0000844887	0000921738	0001581164

2021

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	126 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001046311 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001617406 0001617406 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0000858339 0001052595 0001162556 0001499268 0001581164 0001594617
warning	40 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000844887 0000789570 0000921738 0001005276 0001046311 0001048286 0001061937 0001174922 0001300514 0001361658 0000216877 0001313536 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001581164 0001594617 0001610979 0001517401 0001576575 0001656239 0001723177
warning	22 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001585689 0001617406 0001692412 0001846510 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246 0000899647 0001581164 0001594617
warning	19 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0000911147 0000911147 0000911147 0001005276 0001005276 0001005276 0001005276 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412 0001712189
warning	8 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	6 × No stock price available	subcommand.plot	0001005276 0001061937 0001692412 0001747079 0000216877 0001313536
warning	4 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684 0001722684 0001722684
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	0	1,172,752,112	13,272,021,150	14,601,000,000	0000844887	0001048286	0001590895
1	AssetsNonCurrent	0	0	108,802,351	9,215,745,000	20,047,441,000	0000216877	0001046311	0000789570
2	AssetsCurrent	82,091	4,967,256	542,426,449	5,759,700,000	6,416,182,000	0000844887	0001747079	0000789570
3	IntangibleAssets	0	0	206,630,143	11,991,621,900	17,999,000,000	0000216877	0001653653	0001048286
4	remainder_Assets	-7,097,382,000	-2,956,800,000	145,884,679	1,876,300,000	2,185,000,000	0000789570	0001590895	0001674168
5	LongTermLiabilities	0	0	0	821,827,050	2,913,000,000	0000216877	0001061937	0001674168
6	LiabilitiesCurrent	0	0	158,568,282	4,462,368,800	6,407,000,000	0000844887	0001295810	0001048286
7	remainder_Liabilities	0	0	1,262,154,676	14,343,750,000	28,193,000,000	0000789570	0001692412	0001590895
8	GeneralAndAdministrativeExpense	0	299,605	132,833,611	1,588,905,000	2,507,239,000	0000216877	0001046311	0000789570
9	DepreciationDepletionAndAmortization	0	0	127,348,778	1,087,750,000	1,150,610,000	0000844887	0001295810	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	400,377,350	446,047,000	0000844887	0000844887	0001616000
11	OperatingExpenses	0	0	0	762,590,550	1,359,000,000	0000789570	0000891482	0001361658
12	remainder_Expenses	-24,000,000	475,740	560,553,007	4,619,250,000	11,565,000,000	0001722684	0001747079	0001048286
13	remainder_Revenues	0	4,414,908	1,342,336,215	9,630,577,000	13,857,000,000	0000844887	0001617406	0001048286
14	remainder_NetIncome	-2,759,000,000	-680,278,350	-16,994,200	253,805,800	466,000,000	0001590895	0001674168	0001468174
15	remainder_ComprehensiveNetIncome	-207,000,000	-91,760,150	-13,919	180,032,200	264,000,000	0001048286	0001674168	0001300514

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,558,268	209,831,189	3,707,939,634	32,415,900,000	40,899,116,000	0000844887	0001722684	0000789570
1	Liabilities	3,702,663	31,867,885	2,977,368,325	17,113,050,000	33,490,000,000	0000216877	0001653653	0001590895
2	Expenses	735,497	8,374,494	1,186,102,081	7,787,705,550	12,608,000,000	0000844887	0001747079	0001048286
3	Revenues	0	4,414,908	1,342,336,215	9,630,577,000	13,857,000,000	0000844887	0001617406	0001048286
4	StockholdersEquity	-836,215,000	-807,750,000	539,954,178	13,487,700,000	37,456,852,000	0001174922	0001692412	0000789570
5	NetIncome	-1,276,000,000	-1,014,195,500	9,542,124	813,180,700	1,208,389,000	0001300514	0000891482	0000789570
6	ComprehensiveNetIncome	-1,017,000,000	-895,623,700	8,095,563	711,550,000	1,254,222,000	0001590895	0000891482	0000789570
7	BaseVar	14,292,839	156,716,196	10,550,377,768	74,053,803,178	84,338,870,000	0000844887	0001722684	0001590895
8	EconomicCapitalRatiobeforeLimitedLiability	-1.43	-0.313	0.343	1.80	1.97	0000844887	0000911147	0000216877
9	EconomicCapitalRatio	0.0682	0.388	0.724	1.82	1.99	0000844887	0000911147	0000216877

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.224	-0.182	-0.0171	0.331	0.355	0001585689	0000789570	0001061937
1	AssetsNonCurrent	-0.0786	-0.0715	-0.0148	0.112	0.236	0001590584	0000844887	0001585689
2	AssetsCurrent	-0.0937	-0.0525	-0.00621	0.0856	0.303	0000216877	0000907242	0000891482
3	IntangibleAssets	-0.0952	-0.0887	-0.0189	0.147	0.213	0001590584	0001819395	0001747079
4	remainder_Assets	-0.268	-0.163	-0.0439	0.209	1.18	0001585689	0001046311	0001819395
5	LongTermLiabilities	-0.531	-0.169	0.0293	0.0877	0.123	0001616000	0001722684	0000906553
6	LiabilitiesCurrent	-0.253	-0.168	0.000487	0.0762	0.0897	0001048286	0000844887	0001361658
7	remainder_Liabilities	-0.269	-0.191	-0.0192	0.832	1.08	0001361658	0001468174	0000906553
8	GeneralAndAdministrativeExpense	-0.343	-0.247	0.00150	0.182	0.384	0000907242	0001300514	0000216877
9	DepreciationDepletionAndAmortization	-0.259	-0.139	0.00345	0.140	0.173	0001590584	0001747079	0001048286
10	CostOfGoodsAndServicesSold	-0.592	-0.360	0.0619	0.141	0.166	0001313536	0001674168	0001590584
11	OperatingExpenses	-1.70	-0.786	0.103	0.267	0.372	0000216877	0001585689	0001590584
12	remainder_Expenses	-1.95	-1.44	-0.0396	0.397	0.793	0001590584	0001174922	0000216877
13	remainder_Revenues	-0.551	-0.275	0.0479	0.795	1.10	0001819395	0001585689	0000906553
14	remainder_NetIncome	-0.272	-0.236	0.0188	0.288	0.311	0001712189	0001313536	0001295810
15	remainder_ComprehensiveNetIncome	-0.125	-0.101	0.00414	0.0306	0.0384	0001692412	0001061937	0001722684

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.346	-0.221	-0.0150	0.160	0.715	0001590584	0000789570	0001819395
1	Liabilities	-0.192	-0.179	-0.0181	0.803	1.14	0001585689	0001722684	0000906553
2	Expenses	-1.55	-0.681	-0.0109	0.219	0.510	0001590584	0001300514	0001712189
3	Revenues	-0.551	-0.275	0.0479	0.795	1.10	0001819395	0001585689	0000906553
4	StockholdersEquity	-0.366	-0.322	-0.0640	0.642	0.778	0001361658	0001468174	0001819395
5	NetIncome	-0.248	-0.223	0.0545	0.605	0.973	0001616000	0001674168	0001712189
6	ComprehensiveNetIncome	-0.242	-0.215	0.0585	0.616	0.981	0001617406	0000921738	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001295810	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.761	-0.442	-0.105	0.993	1.16	0000844887	0000911147	0000216877
9	EconomicCapitalRatio	-0.786	-0.467	-0.130	0.968	1.13	0000844887	0000911147	0000216877

2022

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	145 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001046311 0001046311 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001617406 0001617406 0001617406 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0000858339 0001052595 0001162556 0001499268 0001581164 0001594617
warning	40 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000844887 0000789570 0000921738 0001005276 0001046311 0001048286 0001061937 0001174922 0001300514 0001361658 0000216877 0001313536 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001527705 0001581164 0001594617 0001610979 0001517401 0001576575 0001656239 0001723177
warning	22 × The stock price does not exist	industry.us_generic	0001846510 0000789570 0000911147 0001046311 0001585689 0001617406 0001692412 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246 0000899647 0001581164 0001594617
warning	19 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0000911147 0000911147 0001005276 0001005276 0001005276 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412 0001712189 0001712189 0001712189 0001712189
warning	10 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	7 × No stock price available	subcommand.plot	0001846510 0001005276 0001061937 0001692412 0001747079 0000216877 0001313536
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684 0001722684 0001722684 0001722684
warning	2 × Similarly named company. Duplicate?	None	0001846510 0001590895
warning	2 × Missing logo	subcommand.report	0000844887 0001846510
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	0	1,203,105,395	10,599,500,000	14,598,000,000	0000844887	0001747079	0001590895
1	AssetsNonCurrent	0	0	214,402,000	9,469,100,000	32,313,586,000	0000216877	0001617406	0000789570
2	AssetsCurrent	55,885	16,718,290	348,312,918	5,386,793,500	8,154,692,000	0000844887	0001046311	0000789570
3	IntangibleAssets	0	0	245,357,424	11,149,282,000	17,619,000,000	0000216877	0001174922	0001048286
4	remainder_Assets	-6,580,564,000	-3,171,688,000	168,395,223	1,811,500,000	2,447,000,000	0000789570	0001616000	0001674168
5	LongTermLiabilities	0	0	0	714,552,500	2,651,000,000	0000216877	0001174922	0001674168
6	LiabilitiesCurrent	0	0	293,358,542	4,208,946,000	7,339,000,000	0000844887	0001653653	0001048286
7	remainder_Liabilities	0	0	1,512,690,733	13,862,521,000	27,108,000,000	0000789570	0001046311	0001590895
8	GeneralAndAdministrativeExpense	0	3,775,228	186,670,001	1,589,200,000	4,226,617,000	0000216877	0001692412	0000789570
9	DepreciationDepletionAndAmortization	0	0	126,401,916	1,174,500,000	3,482,050,000	0000844887	0001295810	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	445,059,000	672,275,000	0000844887	0000921738	0001616000
11	OperatingExpenses	0	0	0	699,515,000	1,603,000,000	0000789570	0000789570	0001361658
12	remainder_Expenses	724,700	927,510	666,025,844	6,131,000,000	17,386,000,000	0000216877	0001653653	0001048286
13	remainder_Revenues	0	86,808,766	1,590,730,825	11,974,242,500	20,773,000,000	0000844887	0001005276	0001048286
14	remainder_NetIncome	-2,690,000,000	-747,243,000	0	145,000,000	3,005,000,000	0001590895	0000844887	0001300514
15	remainder_ComprehensiveNetIncome	-387,000,000	-226,863,000	0	384,552,000	1,314,113,000	0001048286	0001313536	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,532,062	216,559,060	3,348,081,750	29,171,000,000	45,692,206,000	0000844887	0001653653	0000789570
1	Liabilities	3,547,796	85,757,469	3,161,305,448	17,496,500,000	29,776,000,000	0000216877	0001722684	0001590895
2	Expenses	1,855,705	79,574,224	1,147,632,219	10,632,984,000	18,470,000,000	0000844887	0001653653	0001048286
3	Revenues	0	86,808,766	1,590,730,825	11,974,242,500	20,773,000,000	0000844887	0001005276	0001048286
4	StockholdersEquity	-1,640,365,000	-1,001,000,000	539,331,724	12,177,500,000	41,176,314,000	0001174922	0000907242	0000789570
5	NetIncome	-910,000,000	-567,457,000	129,896,699	1,307,000,000	2,358,000,000	0001590895	0001692412	0001048286
6	ComprehensiveNetIncome	-843,000,000	-562,320,500	90,817,402	1,683,922,000	1,971,000,000	0001590895	0001295810	0001048286
7	BaseVar	16,001,749	661,566,038	10,849,688,569	88,605,303,660	111,717,850,000	0000844887	0001005276	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.59	-0.479	0.488	2.09	2.21	0000844887	0001692412	0001712189
9	EconomicCapitalRatio	0.0451	0.345	0.831	2.10	2.22	0000844887	0001692412	0001712189

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.208	-0.186	-0.0304	0.361	0.447	0000891482	0001048286	0001617406
1	AssetsNonCurrent	-0.169	-0.103	-0.0170	0.286	0.317	0001590584	0001722684	0001846510
2	AssetsCurrent	-0.0903	-0.0683	-0.0132	0.0598	0.116	0000216877	0001005276	0001361658
3	IntangibleAssets	-0.155	-0.0968	-0.0136	0.0967	0.192	0000906553	0001174922	0001747079
4	remainder_Assets	-0.165	-0.103	-0.00952	0.111	0.466	0001585689	0001692412	0001313536
5	LongTermLiabilities	-0.635	-0.146	0.0234	0.0884	0.0968	0001616000	0001313536	0000906553
6	LiabilitiesCurrent	-0.310	-0.219	-0.00234	0.0900	0.101	0001712189	0001747079	0001061937
7	remainder_Liabilities	-0.267	-0.179	-0.0224	1.01	1.18	0001361658	0000911147	0000906553
8	GeneralAndAdministrativeExpense	-0.464	-0.310	-0.000355	0.288	0.383	0000907242	0001590895	0000216877
9	DepreciationDepletionAndAmortization	-0.406	-0.208	0.00438	0.179	0.289	0000789570	0001005276	0001048286
10	CostOfGoodsAndServicesSold	-1.06	-0.673	0.0811	0.240	0.306	0001313536	0001617406	0001590584
11	OperatingExpenses	-1.84	-0.773	0.136	0.365	0.390	0000216877	0001300514	0000906553
12	remainder_Expenses	-2.78	-1.91	-0.00447	0.563	0.893	0001048286	0001846510	0000216877
13	remainder_Revenues	-0.555	-0.245	0.0559	1.06	1.09	0001300514	0001722684	0000907242
14	remainder_NetIncome	-0.308	-0.241	0.0189	0.246	0.481	0001590895	0001692412	0001300514
15	remainder_ComprehensiveNetIncome	-0.187	-0.147	0.00871	0.0704	0.220	0001590584	0001046311	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.405	-0.115	-0.00187	0.0920	0.161	0001590584	0000844887	0001617406
1	Liabilities	-0.191	-0.155	0.00459	0.984	1.22	0000891482	0000844887	0000906553
2	Expenses	-1.89	-0.892	-0.0128	0.229	0.820	0001590584	0001313536	0001712189
3	Revenues	-0.555	-0.245	0.0559	1.06	1.09	0001300514	0001722684	0000907242
4	StockholdersEquity	-0.254	-0.216	-0.0193	0.752	0.835	0001361658	0001300514	0000906553
5	NetIncome	-0.278	-0.235	0.0484	0.613	1.45	0001846510	0001295810	0001712189
6	ComprehensiveNetIncome	-0.423	-0.260	0.0563	0.630	1.46	0001590584	0001295810	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001313536	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.820	-0.521	-0.0349	1.23	1.35	0000844887	0001692412	0001712189
9	EconomicCapitalRatio	-0.873	-0.574	-0.0879	1.18	1.30	0000844887	0001692412	0001712189

2023

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001052595 0001052595 0001052595 0001052595 0001499268 0001499268
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	155 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001046311 0001046311 0001046311 0001046311 0001046311 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001617406 0001617406 0001617406 0001617406 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0000858339 0001005276 0001005276 0001005276 0001005276 0001005276 0001052595 0001162556 0001499268 0001581164 0001594617
warning	40 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000844887 0000789570 0000921738 0001046311 0001048286 0001061937 0001174922 0001300514 0001361658 0000216877 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001005276 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001499268 0001510130 0001551510 0000808377 0001487685 0001517007 0001313536 0001527705 0001581164 0001594617 0001610979 0001517401 0001576575 0001656239 0001723177
warning	22 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001585689 0001617406 0001692412 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001294538 0001342126 0001476246 0000899647 0001581164 0001594617 0001846510
warning	15 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0000911147 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412 0001712189 0001712189 0001712189 0001005276 0001005276
warning	12 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0000911147 0000911147 0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	6 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684 0001722684 0001722684 0001722684 0001722684
warning	4 × No stock price available	subcommand.plot	0001061937 0001692412 0001747079 0000216877
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000789570 0001499268
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001499268

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	4,803,575	1,416,002,113	10,894,500,000	14,756,000,000	0000844887	0001692412	0001590895
1	AssetsNonCurrent	0	0	187,325,220	9,804,700,000	32,008,411,000	0000216877	0000921738	0000789570
2	AssetsCurrent	426,124	30,358,677	529,426,878	4,709,901,400	5,777,000,000	0000844887	0000906553	0001300514
3	IntangibleAssets	0	0	330,405,559	12,926,182,800	18,076,000,000	0000216877	0001174922	0001048286
4	remainder_Assets	-6,890,276,000	-3,803,800,000	204,496,961	2,445,500,000	6,390,600,000	0000789570	0001590895	0000921738
5	LongTermLiabilities	0	0	0	1,220,801,900	3,049,000,000	0000216877	0001174922	0001674168
6	LiabilitiesCurrent	0	0	349,504,431	4,212,000,000	7,762,000,000	0001061937	0001653653	0001048286
7	remainder_Liabilities	0	0	1,420,180,871	13,793,800,000	25,956,000,000	0000789570	0001046311	0001590895
8	GeneralAndAdministrativeExpense	0	9,939,276	194,057,411	1,877,420,000	4,700,657,000	0000216877	0001674168	0000789570
9	DepreciationDepletionAndAmortization	0	0	132,573,606	1,089,838,400	1,356,000,000	0000844887	0001653653	0001590895
10	CostOfGoodsAndServicesSold	0	0	0	476,548,700	703,770,000	0000844887	0001048286	0001616000
11	OperatingExpenses	0	0	0	780,734,700	1,684,000,000	0000789570	0000906553	0001361658
12	remainder_Expenses	342,600	1,882,480	733,290,995	8,424,390,900	19,509,000,000	0000216877	0001747079	0001048286
13	remainder_Revenues	0	79,143,439	2,449,720,210	14,773,374,300	23,713,000,000	0000844887	0001747079	0001048286
14	remainder_NetIncome	-2,532,000,000	-532,603,000	-1,243,911	253,180,000	289,000,000	0001590895	0001692412	0001617406
15	remainder_ComprehensiveNetIncome	-176,000,000	-131,944,800	0	77,500,000	86,082,000	0001300514	0000216877	0001747079

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,814,030	183,495,818	6,274,334,672	31,058,400,000	42,368,548,000	0000844887	0000906553	0000789570
1	Liabilities	3,228,687	63,393,613	3,288,101,425	17,725,800,000	28,646,000,000	0000216877	0001722684	0001590895
2	Expenses	1,351,055	60,857,700	2,348,214,852	12,824,240,900	20,709,000,000	0000844887	0001747079	0001048286
3	Revenues	0	79,143,439	2,449,720,210	14,773,374,300	23,713,000,000	0000844887	0001747079	0001048286
4	StockholdersEquity	-2,347,000,000	-1,045,753,800	636,140,380	14,586,200,000	39,242,480,000	0001585689	0001747079	0000789570
5	NetIncome	-491,400,000	-263,217,600	258,586,282	1,396,177,200	3,083,000,000	0000921738	0001046311	0001048286
6	ComprehensiveNetIncome	-442,700,000	-243,028,000	258,078,078	1,254,272,800	3,165,000,000	0000921738	0001046311	0001048286
7	BaseVar	15,643,065	603,804,968	19,009,519,954	93,747,591,014	124,163,030,000	0000844887	0001747079	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.37	-0.747	0.452	2.08	3.97	0000844887	0001617406	0001712189
9	EconomicCapitalRatio	0.0790	0.242	0.805	2.09	3.97	0000844887	0001617406	0001712189

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.200	-0.167	-0.0521	0.334	0.423	0001585689	0000844887	0001616000
1	AssetsNonCurrent	-0.0909	-0.0788	-0.0139	0.180	0.244	0000921738	0001295810	0001585689
2	AssetsCurrent	-0.144	-0.0460	-0.00935	0.0872	0.154	0001712189	0001590584	0001361658
3	IntangibleAssets	-0.119	-0.0831	-0.0186	0.111	0.221	0000906553	0001295810	0001590895
4	remainder_Assets	-0.207	-0.0813	-0.00126	0.152	0.169	0001585689	0000216877	0000891482
5	LongTermLiabilities	-0.576	-0.441	0.0388	0.162	0.197	0001616000	0001300514	0001712189
6	LiabilitiesCurrent	-0.122	-0.0477	0.159	0.414	0.578	0000844887	0001617406	0001712189
7	remainder_Liabilities	-0.453	-0.333	-0.0178	0.893	0.997	0001361658	0001061937	0000906553
8	GeneralAndAdministrativeExpense	-0.506	-0.470	0.00779	0.308	0.437	0000907242	0001819395	0001048286
9	DepreciationDepletionAndAmortization	-0.319	-0.194	-0.00104	0.221	0.301	0001590584	0001653653	0001048286
10	CostOfGoodsAndServicesSold	-1.08	-0.190	0.0876	0.215	0.226	0001616000	0001061937	0001590584
11	OperatingExpenses	-2.02	-0.822	0.196	0.482	0.548	0000216877	0001616000	0001590584
12	remainder_Expenses	-2.91	-2.31	-0.150	0.531	1.01	0001590584	0000789570	0000216877
13	remainder_Revenues	-0.275	-0.262	0.0231	1.04	1.97	0000844887	0001300514	0001712189
14	remainder_NetIncome	-0.266	-0.187	0.0270	0.187	0.272	0001590895	0000921738	0001295810
15	remainder_ComprehensiveNetIncome	-0.148	-0.0211	0.00350	0.0349	0.0589	0001653653	0001061937	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.170	-0.138	0.00809	0.133	0.201	0001590584	0001653653	0001712189
1	Liabilities	-0.213	-0.180	-0.0109	1.14	1.20	0001174922	0001046311	0001712189
2	Expenses	-2.04	-0.975	-0.0639	0.255	1.31	0001590584	0001616000	0001712189
3	Revenues	-0.275	-0.262	0.0231	1.04	1.97	0000844887	0001300514	0001712189
4	StockholdersEquity	-0.267	-0.256	0.00194	0.768	0.824	0000844887	0001674168	0000906553
5	NetIncome	-0.314	-0.276	0.0471	0.477	2.88	0000921738	0001361658	0001712189
6	ComprehensiveNetIncome	-0.297	-0.265	0.0305	0.489	2.89	0000921738	0001653653	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001361658	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.888	-0.725	-0.162	1.12	3.00	0000844887	0001617406	0001712189
9	EconomicCapitalRatio	-0.958	-0.795	-0.232	1.05	2.93	0000844887	0001617406	0001712189

2024

Logs

error	9 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000891482 0000891482 0001295810 0001295810 0001712189 0001712189 0000216877 0000216877 0001807616
warning	15 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000906553 0000907242 0000921738 0001046311 0001048286 0001061937 0001174922 0001300514 0001468174 0001590895 0001617406 0001653653 0001674168 0001747079
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000891482 0001295810 0001712189 0000216877
warning	2 × The stock price does not exist	industry.us_generic	0000911147 0001692412
warning	2 × No stock price available	subcommand.plot	0001061937 0001692412
warning	1 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684
warning	1 × Ignoring company because Expenses is zero	pre-agg	0000911147

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	0	14,739,700	1,689,316,800	11,884,300,000	14,812,000,000	0000844887	0001468174	0001590895
1	AssetsNonCurrent	0	0	589,468,899	12,345,880,000	24,391,267,000	0001361658	0001722684	0000789570
2	AssetsCurrent	188,806	79,423,100	554,016,515	4,209,500,000	4,363,599,000	0000844887	0001061937	0000789570
3	IntangibleAssets	0	0	1,104,355,760	13,946,638,500	18,219,000,000	0000844887	0001046311	0001048286
4	remainder_Assets	-5,446,000,000	0	420,619,901	2,174,750,000	3,460,000,000	0001585689	0000789570	0001674168
5	LongTermLiabilities	0	0	0	1,201,232,700	4,601,000,000	0000789570	0001174922	0001674168
6	LiabilitiesCurrent	0	0	462,728,214	5,690,900,000	8,649,000,000	0001061937	0001046311	0001048286
7	remainder_Liabilities	0	0	4,946,451,939	24,898,900,000	35,159,988,000	0000844887	0001674168	0000789570
8	GeneralAndAdministrativeExpense	907,316	39,520,500	415,026,897	1,884,840,000	4,825,313,000	0000844887	0001585689	0000789570
9	DepreciationDepletionAndAmortization	0	0	187,265,754	1,260,309,700	1,324,000,000	0000844887	0001653653	0001590895
10	CostOfGoodsAndServicesSold	0	0	0	531,420,000	730,414,000	0000844887	0001046311	0001616000
11	OperatingExpenses	0	0	0	871,516,600	1,744,000,000	0000789570	0000921738	0001361658
12	remainder_Expenses	0	4,430,200	1,933,189,327	9,487,857,400	21,730,000,000	0000844887	0001617406	0001048286
13	remainder_Revenues	0	532,094,600	3,864,145,627	16,646,290,500	25,100,000,000	0000844887	0001361658	0001048286
14	remainder_NetIncome	-2,428,000,000	-486,804,100	-2,776,688	268,100,000	1,582,000,000	0001590895	0001692412	0001468174
15	remainder_ComprehensiveNetIncome	-523,162,000	-413,500,000	-22,998,951	0	2,384,000	0000789570	0001061937	0001819395

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,576,712	433,723,100	6,740,337,200	31,949,200,000	42,231,627,000	0000844887	0001361658	0000789570
1	Liabilities	20,312,516	168,650,100	5,830,206,883	27,413,700,000	38,511,671,000	0000844887	0001747079	0000789570
2	Expenses	981,174	474,507,200	3,177,212,770	15,123,803,700	22,804,000,000	0000844887	0000906553	0001048286
3	Revenues	0	532,094,600	3,864,145,627	16,646,290,500	25,100,000,000	0000844887	0001361658	0001048286
4	StockholdersEquity	-3,689,000,000	-959,742,700	651,386,733	6,676,213,000	17,533,000,000	0001585689	0001722684	0001048286
5	NetIncome	-567,754,000	-304,378,700	289,005,042	1,730,700,000	2,375,000,000	0001747079	0001722684	0001048286
6	ComprehensiveNetIncome	-618,463,000	-428,580,000	287,009,442	1,471,700,000	1,959,000,000	0001747079	0001722684	0001048286
7	BaseVar	17,288,097	2,864,493,871	21,070,188,927	118,477,100,936	134,057,090,000	0000844887	0000906553	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.56	-0.986	0.422	1.70	2.08	0000844887	0001653653	0000906553
9	EconomicCapitalRatio	0.0488	0.179	0.783	1.74	2.08	0000844887	0001653653	0000906553

Effect quantiles (final effects with respect to final var and normalized if applicable)

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.353	-0.174	-0.0614	0.408	0.436	0001590584	0001046311	0001617406
1	AssetsNonCurrent	-0.276	-0.0930	-0.0223	0.159	0.237	0001590584	0001300514	0001585689
2	AssetsCurrent	-0.0331	-0.0328	-0.00787	0.134	0.145	0001590895	0000844887	0001361658
3	IntangibleAssets	-0.260	-0.107	-0.0187	0.112	0.137	0001590584	0000844887	0001747079
4	remainder_Assets	-0.253	-0.173	-0.00983	0.137	0.146	0001590584	0001692412	0001674168
5	LongTermLiabilities	-0.557	-0.289	0.0320	0.125	0.139	0001616000	0001653653	0000906553
6	LiabilitiesCurrent	-0.000358	0.00392	0.115	0.251	0.465	0000844887	0001174922	0000906553
7	remainder_Liabilities	-0.356	-0.286	-0.0482	0.876	1.04	0001361658	0001747079	0000906553
8	GeneralAndAdministrativeExpense	-0.465	-0.231	0.00927	0.233	0.401	0000907242	0001590895	0001048286
9	DepreciationDepletionAndAmortization	-0.345	-0.199	-0.0142	0.143	0.305	0001590584	0001617406	0001048286
10	CostOfGoodsAndServicesSold	-7.60	-0.981	0.144	0.381	0.389	0001590584	0001361658	0000906553
11	OperatingExpenses	-0.940	-0.679	0.119	0.353	0.377	0001692412	0001174922	0000906553
12	remainder_Expenses	-3.18	-1.20	-0.199	0.468	0.499	0001048286	0001617406	0001692412
13	remainder_Revenues	-0.254	-0.176	0.0897	0.958	1.00	0000844887	0001653653	0001048286
14	remainder_NetIncome	-0.268	-0.148	0.0425	0.151	0.594	0001590895	0001590584	0001468174
15	remainder_ComprehensiveNetIncome	-0.218	-0.0486	0.00990	0.0398	0.0441	0001590584	0001674168	0000907242

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.647	-0.110	0.00329	0.143	0.206	0001590584	0001692412	0001617406
1	Liabilities	-0.161	-0.119	-0.000185	1.00	1.23	0001722684	0000844887	0000906553
2	Expenses	-2.86	-1.11	-0.0375	0.230	0.321	0001590584	0001361658	0001653653
3	Revenues	-0.254	-0.176	0.0897	0.958	1.00	0000844887	0001653653	0001048286
4	StockholdersEquity	-0.245	-0.178	0.0496	0.613	0.963	0000844887	0001590895	0000906553
5	NetIncome	-0.480	-0.245	0.115	0.515	0.583	0001590584	0001174922	0000906553
6	ComprehensiveNetIncome	-0.666	-0.243	0.109	0.548	0.618	0001590584	0001174922	0000906553
7	BaseVar	nan	nan	nan	nan	nan	0000789570	0001468174	0000789570
8	EconomicCapitalRatiobeforeLimitedLiability	-0.676	-0.545	0.0587	1.01	1.36	0000844887	0001653653	0000906553
9	EconomicCapitalRatio	-0.731	-0.600	0.00399	0.957	1.31	0000844887	0001653653	0000906553

Estimates

Parameter	Value	Min	Max
PresentValueFactor	4.82	1.0	15.0
BalanceFactor	0.78	0.5	5.0
OCIFactor	1.0	0.5	1.0
HiddenReservesFactor	0.0	0.0	1.0
LLPO_stddev	0.75	0.02	10.0

Stock Table

					Adjusted stock price	Split	Original stock price (Adjusted stock price * Split)	Outstanding shares	Market cap (Original stock price * Outstanding shares)	obs_EconomicCapitalRatio
Company	Name	Name_short	Identifier	Year
0000216877	Pismo Coast Village INC	Pismo C	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
				2023	nan	nan	nan	nan	nan	nan
0000316206	Starwood Hotels Resorts Worldwide LLC	Starwoo	nan	2009	nan	nan	nan	nan	nan	nan
				2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	195,332,051.0	nan	nan
				2012	nan	nan	nan	196,106,079.0	nan	nan
				2013	nan	nan	nan	191,511,857.0	nan	nan
				2014	nan	nan	nan	178,575,327.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0000356213	Gold Merger Sub LLC	Gold Me	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	62,134,794.0	nan	nan
				2012	nan	nan	nan	62,149,308.0	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0000789570	MGM Resorts International	MGM Res	MGM	2010	13.9700	1.0000	13.9700	nan	nan	nan
				2011	9.1800	1.0000	9.1800	488,830,987.0	4,487,468,460.66	0.3041
				2012	10.9900	1.0000	10.9900	489,201,152.0	5,376,320,660.48	0.3811
				2014	19.7000	1.0000	19.7000	491,120,180.0	9,675,067,546.00	0.6426
				2015	21.2600	1.0000	21.2600	563,465,386.0	11,979,274,106.36	0.8726
				2017	31.9500	1.0000	31.9500	566,138,245.0	18,088,116,927.75	1.1215
				2018	23.1100	1.0000	23.1100	527,197,958.0	12,183,544,809.38	0.7348
				2019	33.0300	1.0000	33.0300	514,984,359.0	17,009,933,377.77	0.9178
				2020	31.0300	1.0000	31.0300	493,939,099.0	15,326,930,241.97	0.7993
				2021	44.7700	1.0000	44.7700	468,959,843.0	20,995,332,171.11	0.9470
				2022	33.8400	1.0000	33.8400	384,020,296.0	12,995,246,816.64	0.5177
				2023	44.5800	1.0000	44.5800	341,583,381.0	15,227,787,124.98	0.6694
				2024	34.5000	1.0000	34.5000	297,740,481.0	10,272,046,594.50	0.2544
0000834162	MTR Gaming Group INC	MTR Gam	nan	2011	nan	nan	nan	27,637,686.0	nan	nan
				2012	nan	nan	nan	27,668,839.0	nan	nan
				2013	nan	nan	nan	27,928,641.0	nan	nan
0000844887	Diamondhead Casino CORP	Diamond	DHCC	2015	nan	1.0000	nan	36,297,576.0	nan	nan
				2016	nan	1.0000	nan	36,297,576.0	nan	nan
				2017	nan	1.0000	nan	36,297,576.0	nan	nan
				2018	nan	1.0000	nan	36,297,576.0	nan	nan
				2020	nan	1.0000	nan	nan	nan	nan
				2021	0.2700	1.0000	0.2700	36,297,576.0	9,800,345.52	0.9218
				2022	0.3500	1.0000	0.3500	36,297,576.0	12,704,151.60	1.0924
				2023	0.2100	1.0000	0.2100	36,297,576.0	7,622,490.96	0.6373
				2024	0.1300	1.0000	0.1300	39,052,472.0	5,076,821.36	0.4043
0000858339	Caesars Holdings INC	Caesars	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	125,297,197.0	nan	nan
				2013	nan	nan	nan	136,881,638.0	nan	nan
				2014	nan	nan	nan	144,362,466.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
0000863015	ISLE OF Capri Casinos INC	ISLE OF	nan	2011	nan	nan	nan	38,982,281.0	nan	nan
				2012	nan	nan	nan	38,982,281.0	nan	nan
				2013	nan	nan	nan	39,829,177.0	nan	nan
				2014	nan	nan	nan	40,027,800.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0000891482	FULL House Resorts INC	FULL Ho	FLL	2011	2.5900	1.0000	2.5900	18,673,681.0	48,364,833.79	0.7230
				2012	3.1100	1.0000	3.1100	18,679,681.0	58,093,807.91	0.4763
				2013	2.8800	1.0000	2.8800	18,750,681.0	54,001,961.28	0.4672
				2014	1.4400	1.0000	1.4400	18,876,681.0	27,182,420.64	0.2414
				2015	1.6600	1.0000	1.6600	18,969,396.0	31,489,197.36	0.2750
				2017	3.8400	1.0000	3.8400	22,890,823.0	87,900,760.32	0.5969
				2019	3.3500	1.0000	3.3500	26,999,518.0	90,448,385.30	0.4935
				2020	3.8200	1.0000	3.8200	27,105,728.0	103,543,880.96	0.5619
				2021	11.7500	1.0000	11.7500	34,227,493.0	402,173,042.75	0.9633
				2022	7.5700	1.0000	7.5700	34,399,084.0	260,401,065.88	0.4771
				2023	5.4400	1.0000	5.4400	34,587,350.0	188,155,184.00	0.2899
0000899647	Riviera Holdings CORP	Riviera	nan	2012	nan	nan	nan	10.0	nan	nan
0000899647	Riviera Holdings CORP	Riviera	nan	2014	nan	nan	nan	10.0	nan	nan
0000906553	BOYD Gaming CORP	BOYD Ga	BYD	2012	6.3500	1.0000	6.3500	86,588,933.0	549,839,724.55	0.1553
				2017	33.2600	1.0000	33.2600	112,473,050.0	3,740,853,643.00	1.4769
				2018	19.6500	1.0000	19.6500	112,205,979.0	2,204,847,487.35	0.7083
				2019	29.2000	1.0000	29.2000	111,165,446.0	3,246,031,023.20	0.9009
				2020	41.0200	1.0000	41.0200	111,540,103.0	4,575,375,025.06	1.2919
				2021	62.2800	1.0000	62.2800	112,345,594.0	6,996,883,594.32	2.0637
				2022	53.5700	1.0000	53.5700	104,375,084.0	5,591,373,249.88	1.6214
				2023	61.2100	1.0000	61.2100	97,862,123.0	5,990,140,548.83	1.7439
				2024	71.5200	1.0000	71.5200	88,389,119.0	6,321,589,790.88	1.8024
0000907242	Monarch Casino Resort INC	Monarch	MCRI	2011	9.2700	1.0000	9.2700	16,138,158.0	149,600,724.66	1.3078
				2012	9.1300	1.0000	9.1300	16,141,492.0	147,371,821.96	0.8294
				2013	17.9800	1.0000	17.9800	16,476,435.0	296,246,301.30	1.8218
				2014	14.9200	1.0000	14.9200	16,803,129.0	250,702,684.68	1.5306
				2015	20.5400	1.0000	20.5400	16,981,355.0	348,797,031.70	2.0175
				2016	23.0200	1.0000	23.0200	17,368,559.0	399,824,228.18	2.2428
				2017	41.7300	1.0000	41.7300	17,700,513.0	738,642,407.49	3.7145
				2018	33.6800	1.0000	33.6800	17,894,057.0	602,671,839.76	1.9790
				2019	43.5900	1.0000	43.5900	18,082,135.0	788,200,264.65	1.7903
				2020	52.4900	1.0000	52.4900	18,263,405.0	958,646,128.45	1.9650
				2021	66.3000	1.0000	66.3000	18,736,377.0	1,242,221,795.10	2.6632
				2022	69.5700	1.0000	69.5700	18,961,643.0	1,319,161,503.51	3.1151
				2023	67.3000	1.0000	67.3000	19,067,522.0	1,283,244,230.60	3.0242
				2024	77.9600	1.0000	77.9600	18,389,057.0	1,433,610,883.72	3.3129
0000911147	Century Casinos INC CO	Century	CNTY	2011	2.4100	1.0000	2.4100	23,877,362.0	57,544,442.42	0.7152
				2012	2.8000	1.0000	2.8000	24,117,362.0	67,528,613.60	0.8644
				2013	5.2300	1.0000	5.2300	24,377,761.0	127,495,690.03	1.0137
				2014	5.0100	1.0000	5.0100	24,381,057.0	122,149,095.57	0.9675
				2015	7.2200	1.0000	7.2200	24,404,263.0	176,198,778.86	1.4273
				2016	7.8900	1.0000	7.8900	24,444,571.0	192,867,665.19	1.2984
				2017	9.5900	1.0000	9.5900	24,472,320.0	234,689,548.80	1.2951
				2018	6.7600	1.0000	6.7600	29,439,179.0	199,008,850.04	1.0642
				2021	12.2300	1.0000	12.2300	29,614,814.0	362,189,175.22	0.5766
				2022	6.9700	1.0000	6.9700	29,864,047.0	208,152,407.59	0.2577
0000912145	Ameristar Casinos INC	Amerist	nan	2011	nan	nan	nan	32,632,793.0	nan	nan
0000912145	Ameristar Casinos INC	Amerist	nan	2012	nan	nan	nan	32,867,902.0	nan	nan
0000918543	Castle Group INC	Castle	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0000921738	PENN Entertainment Inc	PENN En	PENN	2010	7.8500	4.4230	34.7200	nan	nan	nan
				2011	8.5300	4.4230	37.7300	78,233,972.0	2,951,767,763.56	0.8150
				2012	11.0600	4.4230	48.9200	76,690,695.0	3,751,708,799.40	0.8300
				2013	14.3400	1.0000	14.3400	77,346,817.0	1,109,153,355.78	0.6143
				2014	13.6200	1.0000	13.6200	78,703,844.0	1,071,946,355.28	0.5469
				2015	16.0200	1.0000	16.0200	80,185,538.0	1,284,572,318.76	0.2344
				2016	14.3200	1.0000	14.3200	83,522,580.0	1,196,043,345.60	0.2279
				2017	30.8300	1.0000	30.8300	91,095,622.0	2,808,478,026.26	0.5328
				2018	18.8700	1.0000	18.8700	118,855,917.0	2,242,811,153.79	0.2117
				2019	25.6800	1.0000	25.6800	115,912,626.0	2,976,636,235.68	0.2243
				2020	91.7400	1.0000	91.7400	155,324,295.0	14,249,450,823.30	1.0682
				2021	50.7400	1.0000	50.7400	169,514,408.0	8,601,161,061.92	0.5802
				2022	30.4600	1.0000	30.4600	155,117,678.0	4,724,884,471.88	0.3009
				2023	25.2400	1.0000	25.2400	151,758,888.0	3,830,394,333.12	0.2648
				2024	18.6600	1.0000	18.6600	152,629,402.0	2,848,064,641.32	0.2058
0001005276	Mohegan Tribal Gaming Authority	Mohegan	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
0001046311	Choice Hotels International INC DE	Choice	CHH	2010	24.5700	1.0000	24.5700	nan	nan	nan
				2011	24.6900	1.0000	24.6900	59,166,765.0	1,460,827,427.85	3.1724
				2012	29.2000	1.0000	29.2000	58,053,476.0	1,695,161,499.20	2.1588
				2015	46.1700	1.0000	46.1700	56,622,700.0	2,614,270,059.00	2.8572
				2016	52.0700	1.0000	52.0700	56,096,987.0	2,920,970,113.09	2.8975
				2017	72.8700	1.0000	72.8700	56,593,820.0	4,123,991,663.40	3.9897
				2018	66.9300	1.0000	66.9300	55,980,838.0	3,746,797,487.34	3.0455
				2019	99.4000	1.0000	99.4000	55,730,708.0	5,539,632,375.20	3.9612
				2020	100.2600	1.0000	100.2600	55,458,082.0	5,560,227,301.32	3.4966
				2021	148.5500	1.0000	148.5500	55,629,330.0	8,263,736,971.50	4.5938
				2022	109.4800	1.0000	109.4800	53,299,203.0	5,835,196,744.44	2.8818
				2023	111.2100	1.0000	111.2100	49,798,586.0	5,538,100,749.06	2.3298
				2024	140.1100	1.0000	140.1100	46,907,321.0	6,572,184,745.31	2.5741
0001048286	Marriott International INC MD	Marriot	MAR	2009	22.4000	1.0610	23.7700	nan	nan	nan
				2010	33.7200	1.0610	35.7800	nan	nan	nan
				2011	25.2600	1.0000	25.2600	335,126,113.0	8,465,285,614.38	1.9993
				2012	32.6300	1.0000	32.6300	315,540,075.0	10,296,072,647.25	2.2592
				2013	43.2100	1.0000	43.2100	299,538,446.0	12,943,056,251.66	2.7335
				2014	70.6600	1.0000	70.6600	283,360,811.0	20,022,274,905.26	4.0348
				2015	62.3400	1.0000	62.3400	257,128,905.0	16,029,415,937.70	3.4418
				2016	78.1000	1.0000	78.1000	390,479,820.0	30,496,473,942.00	2.0826
				2017	125.8900	1.0000	125.8900	364,581,283.0	45,897,137,716.87	3.0642
				2018	101.3600	1.0000	101.3600	341,130,300.0	34,576,967,208.00	2.2949
				2019	146.0800	1.0000	146.0800	326,937,219.0	47,758,988,951.52	3.0105
				2020	124.8100	1.0000	124.8100	324,331,716.0	40,479,841,473.96	2.6585
				2021	159.9300	1.0000	159.9300	325,683,100.0	52,086,498,183.00	3.2595
				2022	144.9700	1.0000	144.9700	316,539,613.0	45,888,747,696.61	2.8542
				2023	219.1200	1.0000	219.1200	293,691,348.0	64,353,648,173.76	3.8494
				2024	282.2800	1.0000	282.2800	277,893,432.0	78,443,757,984.96	4.5043
0001052595	Red Lion Hotels CORP	Red Lio	nan	2011	nan	nan	nan	19,113,698.0	nan	nan
				2012	nan	nan	nan	19,255,939.0	nan	nan
				2013	nan	nan	nan	19,685,393.0	nan	nan
				2014	nan	nan	nan	19,846,508.0	nan	nan
0001061937	HOST Hotels Resorts L P	HOST Ho	nan	2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
				2023	nan	nan	nan	nan	nan	nan
				2024	nan	nan	nan	nan	nan	nan
0001115836	Belmond Ltd	Belmond	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	103,404,460.0	nan	nan
				2014	nan	nan	nan	103,964,923.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
0001162556	Dover Downs Gaming Entertainment INC	Dover D	nan	2011	nan	nan	nan	16,603,173.0	nan	nan
				2012	nan	nan	nan	16,603,173.0	nan	nan
				2013	nan	nan	nan	14,870,673.0	nan	nan
				2014	nan	nan	nan	14,870,673.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
0001174922	WYNN Resorts LTD	WYNN Re	WYNN	2010	71.9100	1.0000	71.9100	nan	nan	nan
				2011	79.5700	1.0000	79.5700	124,957,158.0	9,942,841,062.06	1.7180
				2012	89.9700	1.0000	89.9700	100,581,636.0	9,049,329,790.92	1.2525
				2013	156.7900	1.0000	156.7900	101,155,304.0	15,860,140,114.16	1.9084
				2014	129.4400	1.0000	129.4400	101,349,797.0	13,118,717,723.68	1.4646
				2015	60.5600	1.0000	60.5600	101,568,512.0	6,150,989,086.72	0.5852
				2016	79.8500	1.0000	79.8500	101,740,911.0	8,124,011,743.35	0.6870
				2017	154.9100	1.0000	154.9100	102,782,543.0	15,922,043,736.13	1.3113
				2018	92.1100	1.0000	92.1100	108,738,518.0	10,015,904,892.98	0.8137
				2019	134.9600	1.0000	134.9600	107,354,606.0	14,488,577,625.76	1.1060
				2020	111.6300	1.0000	111.6300	107,870,602.0	12,041,595,301.26	0.8457
				2021	83.9700	1.0000	83.9700	115,657,896.0	9,711,793,527.12	0.7500
				2022	80.0700	1.0000	80.0700	113,313,591.0	9,073,019,231.37	0.6373
				2023	89.2200	1.0000	89.2200	112,945,993.0	10,077,041,495.46	0.6927
				2024	88.2200	1.0000	88.2200	109,814,972.0	9,687,876,829.84	0.7196
0001180638	WYNN LAS Vegas LLC	WYNN LA	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
0001294538	Great Wolf Resorts Inc	Great W	nan	2011	nan	nan	nan	32,562,073.0	nan	nan
0001295810	Sunstone Hotel Investors Inc	Sunston	SHO	2011	5.0500	1.0000	5.0500	118,672,242.0	599,294,822.10	0.2509
				2012	6.8700	1.0000	6.8700	136,777,430.0	939,660,944.10	0.4040
				2013	8.7300	1.0000	8.7300	182,870,062.0	1,596,455,641.26	0.6303
				2014	11.2900	1.0000	11.2900	205,396,771.0	2,318,929,544.59	0.8311
				2015	9.3500	1.0000	9.3500	208,590,736.0	1,950,323,381.60	0.7259
				2016	11.8900	1.0000	11.8900	216,509,093.0	2,574,293,115.77	1.0405
				2017	13.5100	1.0000	13.5100	225,321,660.0	3,044,095,626.60	1.1861
				2018	11.1800	1.0000	11.1800	228,247,062.0	2,551,802,153.16	0.9750
				2019	12.4800	1.0000	12.4800	224,855,351.0	2,806,194,780.48	1.0759
				2020	10.2200	1.0000	10.2200	215,635,550.0	2,203,795,321.00	1.1358
				2021	10.6600	1.0000	10.6600	219,333,783.0	2,338,098,126.78	1.2167
				2022	8.8900	1.0000	8.8900	210,399,520.0	1,870,451,732.80	0.9163
				2023	10.2100	1.0000	10.2100	205,444,026.0	2,097,583,505.46	1.0154
0001297735	American Casino Entertainment Properties LLC	America	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001300514	LAS Vegas Sands CORP	LAS Veg	LVS	2010	29.2400	1.0000	29.2400	nan	nan	nan
				2011	27.3300	1.0000	27.3300	732,718,517.0	20,025,197,069.61	1.1426
				2012	32.1200	1.0000	32.1200	823,449,212.0	26,449,188,689.44	1.4830
				2016	44.2500	1.0000	44.2500	794,793,918.0	35,169,630,871.50	2.1033
				2017	59.9500	1.0000	59.9500	790,480,010.0	47,389,276,599.50	2.8093
				2018	45.7300	1.0000	45.7300	783,554,277.0	35,831,937,087.21	1.8687
				2019	65.0800	1.0000	65.0800	768,036,535.0	49,983,817,697.80	2.5059
				2020	55.0200	1.0000	55.0200	763,828,127.0	42,025,823,547.54	2.2073
				2021	35.8700	1.0000	35.8700	763,989,752.0	27,404,312,404.24	1.4473
				2022	44.7800	1.0000	44.7800	764,166,260.0	34,219,365,122.80	1.6930
				2023	47.1900	1.0000	47.1900	764,490,874.0	36,076,324,344.06	1.8290
				2024	50.8800	1.0000	50.8800	725,026,178.0	36,889,331,936.64	1.9328
0001313536	Sotherly Hotels LP	Sotherl	nan	2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
0001342126	Morgans Hotel Group Co	Morgans	nan	2011	nan	nan	nan	30,731,457.0	nan	nan
				2012	nan	nan	nan	30,792,328.0	nan	nan
				2013	nan	nan	nan	33,569,047.0	nan	nan
				2014	nan	nan	nan	34,377,788.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001361658	Travel Leisure Co	Travel	TNL	2010	8.8100	2.2150	19.5100	nan	nan	nan
				2011	10.8800	2.2150	24.1000	154,017,892.0	3,711,831,197.20	0.4695
				2012	15.8700	2.2150	35.1500	140,266,725.0	4,930,375,383.75	0.5804
				2013	22.2700	2.2150	49.3300	130,306,798.0	6,428,034,345.34	0.7199
				2014	26.6000	2.2150	58.9200	123,262,818.0	7,262,645,236.56	0.8023
				2015	23.1300	2.2150	51.2300	116,106,000.0	5,948,110,380.00	0.6439
				2016	25.2500	2.2150	55.9300	107,776,539.0	6,027,941,826.27	0.6372
				2017	38.1000	2.2150	84.3900	101,326,244.0	8,550,921,731.16	0.8585
				2018	27.5900	1.0000	27.5900	97,452,743.0	2,688,721,179.37	0.3613
				2019	41.2600	1.0000	41.2600	90,704,218.0	3,742,456,034.68	0.4851
				2020	36.1300	1.0000	36.1300	85,861,306.0	3,102,168,985.78	0.3831
				2021	46.6900	1.0000	46.6900	86,356,226.0	4,031,972,191.94	0.5772
				2022	32.0900	1.0000	32.0900	81,280,625.0	2,608,295,256.25	0.3618
				2023	37.4300	1.0000	37.4300	72,420,073.0	2,710,683,332.39	0.3767
				2024	49.4600	1.0000	49.4600	68,405,120.0	3,383,317,235.20	0.4715
0001468174	Hyatt Hotels Corp	Hyatt H	H	2011	36.4200	1.0000	36.4200	44,680,334.0	1,627,257,764.28	0.3195
				2012	37.1700	1.0000	37.1700	45,387,810.0	1,687,064,897.70	0.3229
				2014	58.2800	1.0000	58.2800	39,277,514.0	2,289,093,515.92	0.3928
				2015	46.7100	1.0000	46.7100	29,197,002.0	1,363,791,963.42	0.2436
				2016	54.7400	1.0000	54.7400	23,611,575.0	1,292,497,615.50	0.2230
				2017	70.6500	1.0000	70.6500	47,464,707.0	3,353,381,549.55	0.5682
				2018	65.4800	1.0000	65.4800	42,768,452.0	2,800,478,236.96	0.4825
				2019	88.4800	1.0000	88.4800	36,582,951.0	3,236,859,504.48	0.5031
				2020	72.1800	1.0000	72.1800	38,479,041.0	2,777,417,179.38	0.3693
				2021	93.3600	1.0000	93.3600	50,301,183.0	4,696,118,444.88	0.4340
				2022	89.8700	1.0000	89.8700	48,101,088.0	4,322,844,778.56	0.4132
				2023	129.7000	1.0000	129.7000	44,221,190.0	5,735,488,343.00	0.5191
				2024	157.5500	1.0000	157.5500	42,289,812.0	6,662,759,880.60	0.5839
0001476246	Tropicana Entertainment Inc	Tropica	nan	2011	nan	nan	nan	26,312,500.0	nan	nan
				2014	nan	nan	nan	26,312,500.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0001479046	Tropicana Las Vegas Hotel Casino Inc	Tropica	nan	2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
0001485589	Nevada Property 1 LLC	Nevada	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
0001487685	Greektown Superholdings Inc	Greekto	nan	2012	nan	nan	nan	nan	nan	nan
0001499268	Affinity Gaming	Affinit	nan	2013	nan	nan	nan	nan	nan	nan
0001510130	Southern States SIGN Co	Souther	nan	2012	nan	nan	nan	nan	nan	nan
0001510130	Southern States SIGN Co	Souther	nan	2013	nan	nan	nan	nan	nan	nan
0001517007	Marina District Finance Company Inc	Marina	nan	2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
0001517401	Peak Resorts Inc	Peak Re	nan	2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
0001527705	ALST Casino Holdco LLC	ALST Ca	nan	2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001551510	Revel AC Inc	Revel A	nan	2012	nan	nan	nan	nan	nan	nan
0001576575	Gaming Entertainment International INC	Gaming	nan	2014	nan	nan	nan	nan	nan	nan
0001581164	Extended Stay America Inc	Extende	nan	2014	nan	nan	nan	204,627,256.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	177,560,635.0	nan	nan
0001585689	Hilton Worldwide Holdings Inc	Hilton	HLT	2014	50.6900	0.4870	24.6900	984,617,365.0	24,310,202,741.85	1.0227
				2015	42.5300	0.4870	20.7100	987,451,862.0	20,450,128,062.02	0.8994
				2016	54.2800	0.4870	26.4300	989,783,195.0	26,159,969,843.85	1.1236
				2020	105.5000	1.0000	105.5000	277,446,309.0	29,270,585,599.50	1.6727
				2021	153.1000	1.0000	153.1000	278,721,682.0	42,672,289,514.20	2.6921
				2022	125.4000	1.0000	125.4000	270,456,017.0	33,915,184,531.80	2.1116
				2023	180.6400	1.0000	180.6400	256,440,305.0	46,323,376,695.20	2.7949
				2024	249.3900	1.0000	249.3900	243,779,806.0	60,796,245,818.34	3.3101
0001590584	Civeo Corp	Civeo C	CVEO	2014	89.6600	0.0830	7.4400	106,733,659.0	794,098,422.96	0.5677
				2015	16.9100	0.0830	1.4000	107,465,397.0	150,451,555.80	0.1910
				2016	25.6100	0.0830	2.1300	108,098,786.0	230,250,414.18	0.3417
				2017	26.3300	0.0830	2.1900	132,259,000.0	289,647,210.00	0.4695
				2018	14.7900	0.0830	1.2300	167,970,631.0	206,603,876.13	0.2808
				2019	14.7300	0.0830	1.2200	169,549,135.0	206,849,944.70	0.2861
				2020	14.2100	1.0000	14.2100	170,582,021.0	2,423,970,518.41	4.3815
				2021	17.4400	1.0000	17.4400	14,250,180.0	248,523,139.20	0.5060
				2022	28.4500	1.0000	28.4500	13,712,661.0	390,125,205.45	0.9414
				2023	21.8000	1.0000	21.8000	14,745,906.0	321,460,750.80	0.8315
				2024	21.9300	1.0000	21.9300	13,772,802.0	302,037,547.86	1.0541
0001590895	Caesars Entertainment Inc	Caesars	CZR	2014	4.2400	1.0000	4.2400	46,447,432.0	196,937,111.68	0.1792
				2015	10.7800	1.0000	10.7800	46,444,694.0	500,673,801.32	0.4210
				2016	16.5500	1.0000	16.5500	47,105,744.0	779,600,063.20	0.6810
				2017	33.2000	1.0000	33.2000	76,824,595.0	2,550,576,554.00	0.8298
				2018	35.3600	1.0000	35.3600	77,391,244.0	2,736,554,387.84	0.5071
				2019	59.0300	1.0000	59.0300	77,769,501.0	4,590,733,644.03	0.9034
				2020	74.2900	1.0000	74.2900	208,277,138.0	15,472,908,582.02	0.4569
				2021	93.2000	1.0000	93.2000	213,774,052.0	19,923,741,646.40	0.5572
				2022	42.8400	1.0000	42.8400	214,566,105.0	9,192,011,938.20	0.2904
				2023	47.4100	1.0000	47.4100	215,710,686.0	10,226,843,623.26	0.3298
				2024	33.2100	1.0000	33.2100	212,480,370.0	7,056,473,087.70	0.2321
0001594617	La Quinta Holdings Inc	La Quin	nan	2014	nan	nan	nan	130,722,563.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0001610979	Caesars Entertainment Resort Properties LLC	Caesars	nan	2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
0001616000	Xenia Hotels Resorts Inc	Xenia H	XHR	2017	17.2800	1.0000	17.2800	106,729,984.0	1,844,294,123.52	0.8042
				2018	14.3100	1.0000	14.3100	112,559,248.0	1,610,722,838.88	0.7178
				2019	18.9600	1.0000	18.9600	112,641,568.0	2,135,684,129.28	0.8992
				2020	13.5400	1.0000	13.5400	113,730,716.0	1,539,913,894.64	0.6705
				2021	16.2800	1.0000	16.2800	114,209,134.0	1,859,324,701.52	0.7850
				2022	11.9800	1.0000	11.9800	113,847,779.0	1,363,896,392.42	0.5802
				2023	12.8300	1.0000	12.8300	105,201,059.0	1,349,729,586.97	0.6016
				2024	14.6400	1.0000	14.6400	101,816,814.0	1,490,598,156.96	0.6802
0001617406	Park Hotels Resorts Inc	Park Ho	PK	2020	12.6300	1.0000	12.6300	235,612,787.0	2,975,789,499.81	0.3645
				2021	14.0000	1.0000	14.0000	236,479,179.0	3,310,708,506.00	0.4391
				2022	8.7300	1.0000	8.7300	224,843,229.0	1,962,881,389.17	0.2589
				2023	13.1200	1.0000	13.1200	209,983,724.0	2,754,986,458.88	0.3657
				2024	13.5600	1.0000	13.5600	206,404,619.0	2,798,846,633.64	0.3801
0001653653	Red Rock Resorts Inc	Red Roc	RRR	2016	17.9600	1.0000	17.9600	41,468,746.0	744,778,678.16	0.2321
				2017	26.8100	1.0000	26.8100	68,728,266.0	1,842,604,811.46	0.5581
				2019	19.4800	1.0000	19.4800	70,321,959.0	1,369,871,761.32	0.3679
				2020	20.2900	1.0000	20.2900	71,216,902.0	1,444,990,941.58	0.4202
				2021	45.8700	1.0000	45.8700	68,696,282.0	3,151,098,455.34	1.0116
				2022	36.7300	1.0000	36.7300	58,000,419.0	2,130,355,389.87	0.6397
				2023	49.5300	1.0000	49.5300	58,398,749.0	2,892,490,037.97	0.7548
				2024	44.7500	1.0000	44.7500	59,633,233.0	2,668,587,176.75	0.6856
0001656239	Pinnacle Entertainment Inc	Pinnacl	nan	2016	nan	nan	nan	nan	nan	nan
0001656239	Pinnacle Entertainment Inc	Pinnacl	nan	2017	nan	nan	nan	nan	nan	nan
0001674168	Hilton Grand Vacations Inc	Hilton	HGV	2017	41.7600	1.0000	41.7600	99,088,973.0	4,137,955,512.48	1.9473
				2018	25.9400	1.0000	25.9400	96,911,130.0	2,513,874,712.20	1.0280
				2019	34.5000	1.0000	34.5000	85,469,804.0	2,948,708,238.00	1.0554
				2020	30.5000	1.0000	30.5000	85,106,483.0	2,595,747,731.50	0.8808
				2021	51.4000	1.0000	51.4000	119,837,039.0	6,159,623,804.60	0.8782
				2022	38.7500	1.0000	38.7500	115,057,769.0	4,458,488,548.75	0.6434
				2023	41.7000	1.0000	41.7000	107,984,020.0	4,502,933,634.00	0.5904
				2024	39.2900	1.0000	39.2900	98,488,634.0	3,869,618,429.86	0.3687
0001692412	Playa Hotels Resorts N V	Playa H	nan	2017	nan	nan	nan	110,305,064.0	nan	nan
				2018	nan	nan	nan	130,478,993.0	nan	nan
				2019	nan	nan	nan	129,351,389.0	nan	nan
				2020	nan	nan	nan	134,496,340.0	nan	nan
				2021	nan	nan	nan	164,220,739.0	nan	nan
				2022	nan	nan	nan	162,387,308.0	nan	nan
				2023	nan	nan	nan	138,454,910.0	nan	nan
				2024	nan	nan	nan	121,554,617.0	nan	nan
0001712189	Target Hospitality Corp	Target	TH	2019	4.8800	1.0000	4.8800	103,538,296.0	505,266,884.48	0.9363
				2020	1.6100	1.0000	1.6100	101,170,915.0	162,885,173.15	0.3362
				2021	3.4000	1.0000	3.4000	101,837,297.0	346,246,809.80	0.7450
				2022	15.4000	1.0000	15.4000	97,257,392.0	1,497,763,836.80	2.2311
				2023	9.3400	1.0000	9.3400	101,661,411.0	949,517,578.74	1.8776
0001722684	Wyndham Hotels Resorts INC	Wyndham	WH	2021	82.7800	1.0000	82.7800	93,177,853.0	7,713,262,671.34	2.0711
				2022	66.5700	1.0000	66.5700	88,324,241.0	5,879,744,723.37	1.6144
				2023	77.4500	1.0000	77.4500	82,961,907.0	6,425,399,697.15	1.7555
				2024	100.1900	1.0000	100.1900	77,789,308.0	7,793,710,768.52	1.9995
0001723177	Syndicated Resorts Association Inc	Syndica	nan	2018	nan	nan	nan	nan	nan	nan
0001723177	Syndicated Resorts Association Inc	Syndica	nan	2019	nan	nan	nan	nan	nan	nan
0001747079	Bally s Corp	Bally s	BALY	2019	nan	1.0000	nan	34,233,501.0	nan	nan
				2020	nan	1.0000	nan	30,476,057.0	nan	nan
				2021	nan	1.0000	nan	54,363,371.0	nan	nan
				2022	nan	1.0000	nan	47,261,307.0	nan	nan
				2023	nan	1.0000	nan	45,622,485.0	nan	nan
				2024	16.6400	1.0000	16.6400	40,666,844.0	676,696,284.16	0.1158
0001819395	Sonder Holdings Inc	Sonder	SOND	2021	199.0000	0.0500	9.9500	45,000,000.0	447,750,000.00	1.7805
				2022	24.4000	0.0500	1.2200	218,058,524.0	266,031,399.28	0.1680
				2023	3.4500	1.0000	3.4500	11,064,738.0	38,173,346.10	0.0223
				2024	3.2000	1.0000	3.2000	11,585,625.0	37,074,000.00	0.0273
0001846510	Soho House Co Inc	Soho Ho	SHCO	2022	nan	nan	nan	197,581,922.0	nan	nan

QA: us_hotels 2009-2024

Table of Contents

Ranks across the years

PDF reports

2009

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2010

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2011

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2012

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2013

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2014

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2015

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2016

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2017

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2018

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2019

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2020

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

Effect quantiles (final effects with respect to final var and normalized if applicable)

2021

Logs

Diagrams

Calculation Linkbase Overview