QA: us_hotels 2009-2025

Ranks across the years

	name	name_short	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025	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	2025-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	2024->2025
0000906553	BOYD Gaming CORP	BOYD Ga	NaN	NaN	NaN	27	NaN	NaN	NaN	NaN	2	3	4	3	2	2	2	1	1	NaN	NaN	NaN	41.79	NaN	NaN	NaN	NaN	174.39	157.42	160.04	128.07	200.64	222.67	219.97	211.65	354.83	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	1	-1	-1	0	0	-1	0
0001048286	Marriott International INC MD	Marriot	1	1	13	4	2	3	6	4	4	5	5	6	6	6	4	3	2	124.22	135.61	101.70	132.49	140.42	139.31	133.59	129.29	159.27	146.59	139.45	113.63	131.83	151.09	179.11	141.56	169.17	0	12	-9	-2	1	3	-2	0	1	0	1	0	0	-2	-1	-1
0000216877	Pismo Coast Village INC	Pismo C	NaN	NaN	10	6	3	7	3	NaN	NaN	1	3	2	1	4	6	NaN	3	NaN	NaN	110.70	111.98	121.56	128.31	140.71	NaN	NaN	194.75	179.64	150.21	201.22	187.97	160.92	NaN	148.73	NaN	NaN	-4	-3	4	-4	NaN	NaN	NaN	2	-1	-1	3	2	NaN	NaN
0001061937	HOST Hotels Resorts L P	HOST Ho	NaN	NaN	NaN	NaN	8	8	9	3	9	6	6	11	11	8	9	4	4	NaN	NaN	NaN	NaN	102.14	123.54	115.23	131.56	118.93	144.47	131.00	54.78	86.22	112.81	116.76	108.21	111.09	NaN	NaN	NaN	NaN	0	1	-6	6	-3	0	5	0	-3	1	-5	0
0001046311	Choice Hotels International INC DE	Choice	NaN	3	7	25	NaN	NaN	22	13	19	13	11	9	9	9	10	6	5	NaN	120.19	123.24	58.55	NaN	NaN	68.31	75.86	73.57	96.53	98.66	60.70	107.66	104.80	83.82	84.87	93.72	NaN	4	18	NaN	NaN	NaN	-9	6	-6	-2	-2	0	0	1	-4	-1
0001616000	Xenia Hotels Resorts Inc	Xenia H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	9	12	10	18	11	12	8	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	100.88	120.80	93.02	56.87	59.65	89.40	82.39	81.24	85.55	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	3	-2	8	-7	1	-4	-2
0001300514	LAS Vegas Sands CORP	LAS Veg	NaN	6	9	9	NaN	NaN	NaN	9	6	11	10	20	27	12	13	10	7	NaN	89.74	111.43	104.42	NaN	NaN	NaN	103.01	130.01	106.37	109.62	37.23	39.01	87.16	79.48	79.71	79.84	NaN	3	0	NaN	NaN	NaN	NaN	-3	5	-1	10	7	-15	1	-3	-3
0001722684	Wyndham Hotels Resorts INC	Wyndham	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	10	11	9	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	87.97	98.16	82.64	80.55	67.75	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1	-2	-1
0001590584	Civeo Corp	Civeo C	NaN	NaN	NaN	NaN	NaN	35	33	26	29	25	19	26	12	18	8	20	9	NaN	NaN	NaN	NaN	NaN	26.63	8.18	39.64	46.00	37.79	58.93	31.02	79.71	71.29	122.22	40.02	65.03	NaN	NaN	NaN	NaN	NaN	-2	-7	3	-4	-6	7	-14	6	-10	12	-11
0001468174	Hyatt Hotels Corp	Hyatt H	NaN	NaN	11	8	NaN	10	16	11	13	8	8	15	20	17	17	5	10	NaN	NaN	105.49	104.63	NaN	104.23	89.20	92.70	98.57	129.00	119.34	39.67	53.34	80.92	73.00	99.78	64.00	NaN	NaN	-3	NaN	NaN	6	-5	2	-5	0	7	5	-3	0	-12	5
0001617406	Park Hotels Resorts Inc	Park Ho	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	19	13	14	7	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34.72	56.36	85.07	78.64	83.93	56.94	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-6	1	-7	4
0001585689	Hilton Worldwide Holdings Inc	Hilton	NaN	NaN	NaN	NaN	NaN	23	17	19	NaN	NaN	NaN	22	21	19	20	13	12	NaN	NaN	NaN	NaN	NaN	60.41	79.52	60.86	NaN	NaN	NaN	35.29	50.45	70.13	59.56	61.04	54.69	NaN	NaN	NaN	NaN	NaN	-6	2	NaN	NaN	NaN	NaN	-1	-2	1	-7	-1
0000789570	MGM Resorts International	MGM Res	NaN	4	1	10	NaN	6	7	NaN	1	4	1	4	3	5	5	16	13	NaN	95.56	247.28	99.77	NaN	128.82	128.19	NaN	188.81	150.00	187.16	127.85	165.45	163.65	167.38	53.16	53.07	NaN	-3	9	NaN	NaN	1	NaN	NaN	3	-3	3	-1	2	0	11	-3
0001674168	Hilton Grand Vacations Inc	Hilton	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	12	13	19	16	15	16	14	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	110.66	100.67	83.82	38.03	70.34	82.74	74.65	54.90	52.65	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	1	6	-3	-1	1	-2	0
0001361658	Travel Leisure Co	Travel	NaN	8	19	19	16	21	19	15	15	18	17	18	23	23	22	15	15	NaN	82.89	78.79	75.82	71.53	69.84	70.61	70.73	84.28	70.80	63.76	38.07	49.69	51.36	55.96	54.24	47.42	NaN	11	0	-3	5	-2	-4	0	3	-1	1	5	0	-1	-7	0
0001174922	WYNN Resorts LTD	WYNN Re	NaN	5	8	20	12	18	28	22	20	19	22	27	29	27	21	17	16	NaN	89.80	114.67	70.48	76.80	75.19	48.82	51.19	71.79	70.22	53.26	23.19	35.88	37.86	57.10	51.43	45.59	NaN	3	12	-8	6	10	-6	-2	-1	3	5	2	-2	-6	-4	-1
0001590895	Caesars Entertainment Inc	Caesars	NaN	NaN	NaN	NaN	NaN	27	15	16	21	21	18	16	26	25	19	18	17	NaN	NaN	NaN	NaN	NaN	43.94	91.10	67.68	71.41	61.66	62.92	39.42	40.01	40.01	62.26	46.93	41.82	NaN	NaN	NaN	NaN	NaN	-12	1	5	0	-3	-2	10	-1	-6	-1	-1
0000921738	PENN Entertainment Inc	PENN En	NaN	10	14	16	28	32	29	24	18	24	23	14	17	21	23	19	18	NaN	67.76	98.56	89.78	1.60	35.38	39.65	41.83	76.10	49.47	52.18	39.78	69.77	59.89	42.91	41.01	38.88	NaN	4	2	12	4	-3	-5	-6	6	-1	-9	3	4	2	-4	-1
0000911147	Century Casinos INC CO	Century	NaN	NaN	5	3	4	13	12	7	7	14	NaN	NaN	15	22	NaN	NaN	19	NaN	NaN	137.55	150.91	118.86	96.87	110.77	118.35	127.09	92.13	NaN	NaN	70.47	54.00	NaN	NaN	37.51	NaN	NaN	-2	1	9	-1	-5	0	7	NaN	NaN	NaN	7	NaN	NaN	NaN
0001611046	Modulink Inc	Modulin	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15.13	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
0000316206	Starwood Hotels Resorts Worldwide LLC	Starwoo	2	7	18	13	7	17	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51.30	83.57	84.43	96.25	102.30	76.83	70.13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	11	-5	-6	10	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000356213	Gold Merger Sub LLC	Gold Me	NaN	2	22	26	24	24	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	131.09	61.71	50.40	38.35	49.14	51.63	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	4	-2	0	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001115836	Belmond Ltd	Belmond	NaN	9	23	18	13	28	25	12	16	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	70.24	61.21	78.16	72.76	39.59	54.32	85.63	77.83	53.69	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	-5	-5	15	-3	-13	4	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000834162	MTR Gaming Group INC	MTR Gam	NaN	NaN	28	28	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35.00	40.03	39.92	NaN	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	NaN
0000858339	Caesars Holdings INC	Caesars	NaN	NaN	26	31	27	36	1	30	NaN	NaN	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39.77	37.41	27.55	4.42	274.78	10.06	NaN	NaN	38.89	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-4	9	-35	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000863015	ISLE OF Capri Casinos INC	ISLE OF	NaN	NaN	4	17	5	16	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	142.26	87.60	117.87	77.16	139.34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	13	-12	11	-12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000891482	FULL House Resorts INC	FULL Ho	NaN	NaN	2	1	15	33	21	NaN	28	NaN	24	8	14	24	25	NaN	NaN	NaN	NaN	160.83	174.18	72.22	31.59	69.66	NaN	51.25	NaN	48.84	62.64	70.60	41.55	39.74	NaN	NaN	NaN	NaN	-1	14	18	-12	NaN	NaN	NaN	NaN	-16	6	10	1	NaN	NaN
0000907242	Monarch Casino Resort INC	Monarch	NaN	NaN	6	7	1	5	2	2	3	7	9	7	5	3	3	2	NaN	NaN	NaN	126.05	106.37	140.84	136.14	156.22	173.84	171.69	140.18	112.73	103.79	152.48	202.51	191.88	178.90	NaN	NaN	NaN	1	-6	4	-3	0	1	4	2	-2	-2	-2	0	-1	NaN
0000912145	Ameristar Casinos INC	Amerist	NaN	NaN	3	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	142.91	167.93	NaN	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	NaN
0000918543	Castle Group INC	Castle	NaN	NaN	25	23	18	22	NaN	18	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	47.46	60.00	49.59	68.34	NaN	63.26	55.79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-5	4	NaN	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001005276	Mohegan Tribal Gaming Authority	Mohegan	NaN	NaN	21	24	NaN	NaN	NaN	NaN	24	17	25	21	25	26	NaN	NaN	NaN	NaN	NaN	69.18	59.83	NaN	NaN	NaN	NaN	65.46	73.76	40.55	36.77	40.02	39.85	NaN	NaN	NaN	NaN	NaN	3	NaN	NaN	NaN	NaN	NaN	-7	8	-4	4	1	NaN	NaN	NaN
0001052595	Red Lion Hotels CORP	Red Lio	NaN	NaN	20	22	17	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	77.33	64.89	55.01	101.78	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-5	-6	NaN	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	8	11	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	94.97	97.03	99.12	85.28	107.10	103.87	102.85	106.41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-3	5	-1	-5	3	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001180638	WYNN LAS Vegas LLC	WYNN LA	NaN	NaN	24	29	22	25	31	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49.46	38.64	39.34	46.85	38.58	39.84	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-7	3	6	-6	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	7	17	8	7	7	NaN	NaN	NaN	NaN	90.82	91.93	95.68	99.60	138.20	118.44	121.57	180.68	119.78	39.02	115.97	117.19	139.38	NaN	NaN	NaN	NaN	-2	-4	1	-7	1	2	-6	5	10	-9	-1	0	NaN	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	NaN	96.15	98.17	98.10	107.87	113.79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-1	-1	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001342126	Morgans Hotel Group Co	Morgans	NaN	NaN	29	33	26	34	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20.48	28.66	30.00	26.76	38.21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-7	8	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001476246	Tropicana Entertainment Inc	Tropica	NaN	NaN	12	NaN	NaN	1	8	5	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	104.77	NaN	NaN	222.98	118.33	119.80	138.82	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-3	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001485589	Nevada Property 1 LLC	Nevada	NaN	NaN	27	30	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.79	38.12	37.94	NaN	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	NaN
0000899647	Riviera Holdings CORP	Riviera	NaN	NaN	NaN	32	NaN	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36.31	NaN	38.36	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
0001479046	Tropicana Las Vegas Hotel Casino Inc	Tropica	NaN	NaN	NaN	21	14	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69.21	72.45	80.95	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001510130	Southern States SIGN Co	Souther	NaN	NaN	NaN	14	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	95.68	38.67	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	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	NaN	130.90	113.11	153.10	NaN	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	NaN
0001313536	Sotherly Hotels LP	Sotherl	NaN	NaN	NaN	NaN	19	26	24	21	25	23	20	25	28	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41.68	46.34	58.48	57.65	59.18	53.20	58.40	31.33	36.81	83.99	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-2	-3	4	-2	-3	5	3	-14	NaN	NaN	NaN
0001527705	ALST Casino Holdco LLC	ALST Ca	NaN	NaN	NaN	NaN	20	19	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40.77	71.91	103.79	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517401	Peak Resorts Inc	Peak Re	NaN	NaN	NaN	NaN	NaN	4	10	10	23	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	139.24	114.70	96.86	65.56	65.72	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	0	13	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001581164	Extended Stay America Inc	Extende	NaN	NaN	NaN	NaN	NaN	20	18	14	17	15	15	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	70.59	78.15	75.40	77.12	80.40	71.85	155.83	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-4	3	-2	0	-14	NaN	NaN	NaN	NaN	NaN
0001594617	La Quinta Holdings Inc	La Quin	NaN	NaN	NaN	NaN	NaN	31	23	20	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35.48	64.22	58.91	85.44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	-3	-6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001610979	Caesars Entertainment Resort Properties LLC	Caesars	NaN	NaN	NaN	NaN	NaN	29	26	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.72	51.89	45.32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000844887	Diamondhead Casino CORP	Diamond	NaN	NaN	NaN	NaN	NaN	NaN	30	29	31	26	NaN	28	30	30	27	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39.21	10.58	9.13	26.10	NaN	1.68	4.91	3.05	5.77	3.32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	2	-5	NaN	NaN	2	0	-3	-4	NaN
0001575879	Caesars Acquisition Co	Caesars	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	448.05	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
0001653653	Red Rock Resorts Inc	Red Roc	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	26	NaN	21	13	13	20	18	12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66.95	58.78	NaN	55.19	39.86	73.41	67.14	64.52	76.01	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN	-8	0	7	-2	-6	NaN
0001656239	Pinnacle Entertainment Inc	Pinnacl	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28.38	41.23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
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	NaN	69.12	77.47	66.09	32.28	47.30	81.03	77.70	76.96	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	0	8	0	-8	-1	-4	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	NaN	181.72	119.86	157.79	223.11	399.74	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-1	-3	0	NaN	NaN
0001747079	Bally s Corp	Bally s	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	12	22	28	24	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	78.89	52.34	50.44	32.46	40.33	31.01	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	10	6	-4	-3	NaN
0001819395	Sonder Holdings Inc	Sonder	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	29	26	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	119.72	31.28	13.81	13.44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22	-3	-4	NaN

PDF reports

All reports for 2025 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 0000789570 0001048286 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,457,700,000	33,276,422,000	49,648,557,444	66,013,418,000	67,832,140,000	0000316206	0001048286	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	0.118	0.168	0.624	1.08	1.13	0000316206	0001048286	0001048286
9	EconomicCapitalRatio	0.513	0.549	0.878	1.21	1.24	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.0725	-0.0633	0.0201	0.103	0.113	0001048286	0000316206	0000316206
1	AssetsNonCurrent	-0.00644	-0.00569	0.00106	0.00781	0.00856	0001048286	0000316206	0000316206
2	AssetsCurrent	-0.00378	-0.00345	-0.000411	0.00262	0.00296	0000316206	0001048286	0001048286
3	IntangibleAssets	-0.0304	-0.0276	-0.00220	0.0232	0.0260	0000316206	0001048286	0001048286
4	remainder_Assets	-0.0702	-0.0611	0.0212	0.103	0.113	0001048286	0000316206	0000316206
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0427	-0.0333	0.0512	0.136	0.145	0000316206	0001048286	0001048286
7	remainder_Liabilities	-0.254	-0.211	0.174	0.558	0.601	0000316206	0001048286	0001048286
8	GeneralAndAdministrativeExpense	-0.0403	-0.0374	-0.0119	0.0136	0.0165	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.965	-0.910	-0.414	0.0807	0.136	0001048286	0000316206	0000316206
13	remainder_Revenues	-0.308	-0.251	0.267	0.785	0.842	0000316206	0001048286	0001048286
14	remainder_NetIncome	-0.0921	-0.0765	0.0637	0.204	0.219	0000316206	0001048286	0001048286
15	remainder_ComprehensiveNetIncome	-0.0994	-0.0924	-0.0295	0.0334	0.0404	0001048286	0000316206	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.110	-0.0989	0.00481	0.109	0.120	0001048286	0000316206	0000316206
1	Liabilities	-0.302	-0.252	0.190	0.633	0.682	0000316206	0001048286	0001048286
2	Expenses	-1.02	-0.959	-0.439	0.0813	0.139	0001048286	0000316206	0000316206
3	Revenues	-0.308	-0.251	0.267	0.785	0.842	0000316206	0001048286	0001048286
4	StockholdersEquity	-0.0502	-0.0416	0.0351	0.112	0.120	0000316206	0001048286	0001048286
5	NetIncome	-0.103	-0.0855	0.0712	0.228	0.245	0000316206	0001048286	0001048286
6	ComprehensiveNetIncome	-0.0663	-0.0551	0.0462	0.147	0.159	0000316206	0001048286	0001048286
7	BaseVar	0	0	0	0	0	0000316206	0001048286	0000316206
8	EconomicCapitalRatiobeforeLimitedLiability	-0.383	-0.346	-0.0182	0.310	0.346	0000316206	0001048286	0001048286
9	EconomicCapitalRatio	-0.365	-0.328	0.0000729	0.328	0.365	0000316206	0001048286	0001048286

2010

Logs

warning	18 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000316206 0000356213 0000789570 0001048286 0001300514 0001361658 0000216877 0000858339 0000918543 0001005276 0001115836 0001180638 0001297735 0001479046 0001485589 0000921738 0001046311 0001174922
warning	9 × The stock price does not exist	industry.us_generic	0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001162556 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,065,758,120	3,720,582,487	25,355,298,984	55,432,966,754	61,428,620,000	0001046311	0001361658	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	0.314	0.329	0.626	1.25	1.28	0000921738	0001174922	0001048286
9	EconomicCapitalRatio	0.678	0.689	0.898	1.34	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.135	-0.129	-0.0130	0.298	0.376	0001046311	0001174922	0000789570
1	AssetsNonCurrent	-0.0229	-0.0215	-0.0103	0.0476	0.0736	0001174922	0000316206	0000789570
2	AssetsCurrent	-0.0585	-0.0455	-0.000478	0.0336	0.0414	0000921738	0001174922	0001115836
3	IntangibleAssets	-0.0361	-0.0361	-0.0104	0.135	0.215	0001174922	0001048286	0000921738
4	remainder_Assets	-0.0616	-0.0578	-0.0230	0.178	0.228	0000789570	0001046311	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0556	-0.0528	-0.00330	0.101	0.125	0000316206	0000921738	0000356213
7	remainder_Liabilities	-0.243	-0.230	-0.0759	0.645	0.762	0001300514	0000921738	0001048286
8	GeneralAndAdministrativeExpense	-0.316	-0.259	-0.00508	0.299	0.401	0000356213	0001361658	0001048286
9	DepreciationDepletionAndAmortization	-0.193	-0.150	-0.0245	0.269	0.357	0000356213	0001115836	0001048286
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	-0.534	-0.529	0.190	0.395	0.474	0001361658	0001174922	0001048286
12	remainder_Expenses	-3.38	-2.13	-0.117	0.501	0.517	0001048286	0001174922	0001115836
13	remainder_Revenues	-0.309	-0.288	-0.0390	0.912	1.000	0001115836	0000921738	0001048286
14	remainder_NetIncome	-0.310	-0.215	0.0474	0.174	0.188	0000789570	0001361658	0001048286
15	remainder_ComprehensiveNetIncome	-0.00924	-0.00499	0.000299	0.000595	0.000653	0001048286	0001174922	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.155	-0.142	-0.0193	0.269	0.302	0001046311	0000316206	0001115836
1	Liabilities	-0.265	-0.262	-0.0506	0.692	0.793	0001300514	0000921738	0001048286
2	Expenses	-1.65	-1.22	0.0523	0.209	0.239	0001048286	0000316206	0001300514
3	Revenues	-0.309	-0.288	-0.0390	0.912	1.000	0001115836	0000921738	0001048286
4	StockholdersEquity	-0.862	-0.649	-0.0949	0.479	0.565	0001046311	0001361658	0000789570
5	NetIncome	-0.587	-0.417	0.108	0.480	0.748	0000789570	0001048286	0001046311
6	ComprehensiveNetIncome	-0.587	-0.417	0.104	0.481	0.749	0000789570	0001300514	0001046311
7	BaseVar	0	0	0	0	0	0000316206	0001048286	0000316206
8	EconomicCapitalRatiobeforeLimitedLiability	-0.286	-0.274	-0.0655	0.373	0.393	0000921738	0001174922	0001048286
9	EconomicCapitalRatio	-0.289	-0.278	-0.0687	0.369	0.390	0000921738	0001174922	0001048286

2011

Logs

warning	12 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001180638 0001297735 0001485589 0001115836 0001479046 0001510130 0000216877 0000808377 0000858339 0000918543 0001005276 0001517007
warning	11 × The stock price does not exist	industry.us_generic	0001162556 0000834162 0000863015 0000316206 0000356213 0000912145 0001052595 0001342126 0000899647 0000858339 0001476246
warning	10 × Missing logo	subcommand.report	0000834162 0001180638 0000863015 0000316206 0000356213 0000912145 0001052595 0001297735 0001342126 0001485589
warning	5 × Similarly named company. Duplicate?	None	0000912145 0001174922 0001300514 0001468174 0001476246
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 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001180638

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	23,915,972	1,168,017,133	14,965,245,000	17,266,000,000	0000918543	0001048286	0000858339
1	AssetsNonCurrent	0	0	29,302,900	1,165,892,000	10,086,912,000	0000858339	0001046311	0000789570
2	AssetsCurrent	2,098,004	11,589,335	194,875,142	2,701,232,000	5,397,152,000	0000216877	0001046311	0001300514
3	IntangibleAssets	0	0	69,110,524	5,455,235,600	8,120,700,000	0000216877	0001342126	0000858339
4	remainder_Assets	-7,944,726,000	-4,982,304	44,472,134	2,615,000,000	4,441,000,000	0000789570	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	0	3,165,338	180,771,391	2,296,023,600	2,558,000,000	0001342126	0000912145	0001048286
7	remainder_Liabilities	0	0	565,603,861	8,274,959,000	25,859,400,000	0000789570	0000834162	0000858339
8	GeneralAndAdministrativeExpense	0	2,460,225	202,042,784	1,205,602,000	2,118,500,000	0000216877	0001005276	0000858339
9	DepreciationDepletionAndAmortization	0	0	46,053,614	761,642,400	817,146,000	0000216877	0001115836	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	1,039,800	6,271,000	0000216877	0000921738	0000834162
11	OperatingExpenses	0	0	0	264,225,200	1,781,000,000	0000216877	0000918543	0001361658
12	remainder_Expenses	5,196,497	33,623,797	630,251,003	6,399,713,200	11,361,000,000	0000216877	0000863015	0001048286
13	remainder_Revenues	0	2,370,228	639,623,631	9,180,247,000	12,317,000,000	0000907242	0001046311	0001048286
14	remainder_NetIncome	-1,134,421,000	-200,384,200	-6,997,200	113,110,738	940,275,000	0000789570	0001468174	0001295810
15	remainder_ComprehensiveNetIncome	-63,000,000	-38,400,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	47,570,873	1,950,790,976	25,557,414,800	28,515,600,000	0000918543	0000356213	0000858339
1	Liabilities	6,111,176	18,002,994	979,612,072	10,399,382,600	27,462,200,000	0000216877	0001115836	0000858339
2	Expenses	5,196,497	42,515,623	859,184,989	8,750,844,400	12,113,000,000	0000216877	0001295810	0001048286
3	Revenues	0	2,370,228	639,623,631	9,180,247,000	12,317,000,000	0000907242	0001046311	0001048286
4	StockholdersEquity	-223,770,000	-60,905,800	845,454,639	7,594,691,200	26,021,512,000	0001485589	0001297735	0000789570
5	NetIncome	-666,700,000	-96,447,400	5,359,887	1,459,916,600	3,234,944,000	0000858339	0001162556	0000789570
6	ComprehensiveNetIncome	-666,700,000	-96,447,400	4,703,730	1,459,916,600	3,234,944,000	0000858339	0001162556	0000789570
7	BaseVar	38,629,976	249,499,721	6,163,495,133	61,494,425,928	72,715,582,000	0000216877	0001485589	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-0.822	-0.293	0.723	1.49	2.47	0001342126	0001297735	0000789570
9	EconomicCapitalRatio	0.205	0.365	0.962	1.54	2.47	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.499	-0.283	-0.00818	0.243	0.383	0000918543	0000891482	0001297735
1	AssetsNonCurrent	-0.409	-0.0720	-0.0107	0.00665	0.0122	0000789570	0001174922	0001468174
2	AssetsCurrent	-0.107	-0.0663	-0.00474	0.0383	0.0482	0000918543	0001295810	0000316206
3	IntangibleAssets	-0.253	-0.125	-0.0129	0.0435	0.103	0000789570	0000912145	0000921738
4	remainder_Assets	-0.0391	-0.0319	-0.00571	0.182	0.305	0001162556	0000921738	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	-0.291	-0.139	0.00954	0.0787	0.121	0001005276	0000216877	0000912145
7	remainder_Liabilities	-0.560	-0.364	0.0549	0.679	0.718	0001485589	0001052595	0000912145
8	GeneralAndAdministrativeExpense	-1.04	-0.706	0.00332	0.481	0.633	0000907242	0001485589	0001048286
9	DepreciationDepletionAndAmortization	-0.182	-0.152	-0.00966	0.249	0.556	0000907242	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.0245	-0.00656	0.00196	0.00569	0.00650	0001052595	0001468174	0001048286
11	OperatingExpenses	-1.06	-0.646	0.105	0.230	0.366	0000834162	0000918543	0001048286
12	remainder_Expenses	-5.17	-3.05	-0.0635	0.558	1.00	0001048286	0000891482	0000789570
13	remainder_Revenues	-4.78	-1.20	0.201	0.973	1.22	0000907242	0001468174	0000891482
14	remainder_NetIncome	-0.523	-0.412	-0.142	0.485	1.26	0000912145	0001162556	0000907242
15	remainder_ComprehensiveNetIncome	-0.0291	-0.0183	0.00176	0.00409	0.0283	0001048286	0000921738	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.776	-0.493	-0.00828	0.200	0.235	0000789570	0000891482	0001297735
1	Liabilities	-0.526	-0.343	0.0490	0.685	0.769	0001485589	0001297735	0000912145
2	Expenses	-2.87	-1.25	-0.0203	0.224	0.992	0001048286	0000316206	0000789570
3	Revenues	-4.78	-1.20	0.201	0.973	1.22	0000907242	0001468174	0000891482
4	StockholdersEquity	-0.849	-0.775	-0.0681	0.463	1.02	0000918543	0001485589	0000789570
5	NetIncome	-0.275	-0.194	-0.0126	0.628	0.934	0001115836	0001485589	0000789570
6	ComprehensiveNetIncome	-0.273	-0.193	-0.0126	0.631	0.936	0001115836	0001485589	0000789570
7	BaseVar	0	0	0	0	0	0000216877	0001046311	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.725	-0.564	0.0320	0.607	1.54	0001342126	0001297735	0000789570
9	EconomicCapitalRatio	-0.751	-0.591	0.00540	0.580	1.52	0001342126	0001297735	0000789570

2012

Logs

error	2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001005276
warning	15 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001517007 0000356213 0001180638 0001297735 0001479046 0001485589 0001510130 0000918543 0001061937 0001115836 0000216877 0001005276 0001313536 0001527705 0000808377
warning	14 × Missing logo	subcommand.report	0000863015 0001517007 0000834162 0000316206 0000356213 0000899647 0000912145 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130
warning	12 × The stock price does not exist	industry.us_generic	0001162556 0000863015 0000834162 0000316206 0000356213 0000899647 0000912145 0001052595 0001342126 0001046311 0001115836 0000858339
warning	6 × Similarly named company. Duplicate?	None	0000912145 0001479046 0001174922 0000906553 0001300514 0001468174
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '33 of 33'}
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 × Ignoring company because Expenses is zero	pre-agg	0000808377

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	36,681,520	1,250,914,894	14,797,471,200	15,766,748,000	0000918543	0001517007	0001300514
1	AssetsNonCurrent	0	0	41,040,518	1,007,635,600	9,582,994,000	0000858339	0001485589	0000789570
2	AssetsCurrent	2,228,853	5,021,745	202,375,720	2,901,695,200	4,477,514,000	0000216877	0000863015	0001300514
3	IntangibleAssets	0	0	40,317,285	4,110,699,600	7,640,680,000	0000216877	0000891482	0000789570
4	remainder_Assets	-7,640,680,000	-52,424,600	35,214,736	1,484,720,000	4,458,000,000	0000789570	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	0	3,555,410	176,192,878	2,602,109,200	2,773,000,000	0001342126	0001046311	0001048286
7	remainder_Liabilities	0	0	331,305,674	7,977,737,800	25,741,400,000	0000789570	0001297735	0000858339
8	GeneralAndAdministrativeExpense	0	264,600	144,789,370	1,299,464,400	2,103,800,000	0000216877	0001485589	0000858339
9	DepreciationDepletionAndAmortization	0	0	43,998,070	786,118,400	927,697,000	0000316206	0001115836	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	331,200	7,374,000	0000216877	0000921738	0000834162
11	OperatingExpenses	-4,889,000	0	0	254,004,600	1,842,000,000	0001517007	0000316206	0001361658
12	remainder_Expenses	3,070,000	15,355,846	437,300,317	7,327,737,600	10,644,000,000	0001510130	0001046311	0001048286
13	remainder_Revenues	0	0	686,238,918	9,948,959,200	11,814,000,000	0000899647	0001517007	0001048286
14	remainder_NetIncome	-1,861,121,000	-291,894,400	-230,261	128,593,203	877,600,000	0000789570	0000911147	0001295810
15	remainder_ComprehensiveNetIncome	-223,326,000	-160,970,800	0	21,720,000	33,000,000	0001174922	0001517007	0001468174

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	12,990,627	72,831,528	1,892,610,190	23,812,086,400	27,998,100,000	0000918543	0001115836	0000858339
1	Liabilities	5,912,369	16,738,023	751,214,048	9,921,296,000	28,329,700,000	0000216877	0000906553	0000858339
2	Expenses	5,390,568	16,311,607	716,151,203	9,627,846,200	11,289,000,000	0000216877	0001485589	0001048286
3	Revenues	0	0	686,238,918	9,948,959,200	11,814,000,000	0000899647	0001517007	0001048286
4	StockholdersEquity	-548,904,000	-330,844,600	209,545,509	6,812,342,200	24,359,067,000	0001046311	0001005276	0000789570
5	NetIncome	-1,616,912,000	-1,150,725,000	508,537	634,079,600	1,881,813,000	0000789570	0000918543	0001300514
6	ComprehensiveNetIncome	-1,759,366,000	-1,134,696,200	610,957	573,200,000	1,693,067,000	0000789570	0000918543	0001300514
7	BaseVar	40,007,326	137,129,409	5,914,507,359	64,684,465,692	73,877,700,000	0000216877	0000863015	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-0.581	-0.283	0.594	1.54	1.72	0001342126	0000863015	0000891482
9	EconomicCapitalRatio	0.287	0.370	0.876	1.58	1.74	0001342126	0000863015	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.420	-0.279	-0.00389	0.284	0.383	0000918543	0000899647	0001479046
1	AssetsNonCurrent	-0.130	-0.0774	-0.0252	0.0856	0.466	0000918543	0000316206	0001510130
2	AssetsCurrent	-0.0999	-0.0728	-0.00339	0.0612	0.0972	0000906553	0001485589	0000899647
3	IntangibleAssets	-0.131	-0.0684	-0.00848	0.113	0.140	0000918543	0001510130	0000789570
4	remainder_Assets	-0.163	-0.0471	0.00989	0.111	0.356	0001510130	0001052595	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	-0.270	-0.0805	0.0181	0.151	0.232	0001510130	0001174922	0000891482
7	remainder_Liabilities	-0.498	-0.290	0.0603	0.670	0.932	0001485589	0000899647	0001048286
8	GeneralAndAdministrativeExpense	-0.705	-0.652	0.00460	0.444	0.594	0000907242	0000834162	0001048286
9	DepreciationDepletionAndAmortization	-0.166	-0.102	-0.0140	0.272	0.496	0001479046	0001180638	0001048286
10	CostOfGoodsAndServicesSold	-0.0264	-0.00600	0.00139	0.00336	0.00493	0000834162	0000789570	0001048286
11	OperatingExpenses	-1.37	-0.576	0.0915	0.199	0.298	0000834162	0000789570	0001048286
12	remainder_Expenses	-4.35	-2.67	-0.0136	0.540	0.616	0001048286	0000789570	0001115836
13	remainder_Revenues	-3.43	-1.69	0.219	0.997	1.32	0000907242	0001005276	0001048286
14	remainder_NetIncome	-0.768	-0.648	-0.251	0.795	1.06	0001517007	0000863015	0000907242
15	remainder_ComprehensiveNetIncome	-0.408	-0.0527	0.0117	0.0401	0.0698	0000863015	0001479046	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.495	-0.289	0.00214	0.253	0.320	0000918543	0000911147	0001510130
1	Liabilities	-0.630	-0.402	0.0780	0.732	0.930	0001510130	0000906553	0001048286
2	Expenses	-2.36	-1.10	-0.0428	0.238	0.557	0001048286	0000356213	0001510130
3	Revenues	-3.43	-1.69	0.219	0.997	1.32	0000907242	0001005276	0001048286
4	StockholdersEquity	-0.797	-0.775	-0.0251	0.488	0.601	0001046311	0001300514	0000789570
5	NetIncome	-0.940	-0.492	0.0688	0.379	0.908	0000906553	0001295810	0000891482
6	ComprehensiveNetIncome	-0.908	-0.497	0.0875	0.381	0.929	0000906553	0001468174	0000891482
7	BaseVar	0	0	0	0	0	0000216877	0001046311	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.545	-0.462	0.0445	0.746	0.910	0001342126	0000863015	0000891482
9	EconomicCapitalRatio	-0.558	-0.475	0.0311	0.732	0.897	0001342126	0000863015	0000891482

2013

Logs

error	4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001005276 0001005276
warning	15 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000356213 0001517007 0001180638 0001297735 0001479046 0001485589 0001510130 0001527705 0000918543 0001061937 0001610979 0000216877 0001005276 0001313536 0001517401
warning	13 × The stock price does not exist	industry.us_generic	0000863015 0000834162 0001476246 0001581164 0000316206 0001052595 0001342126 0000899647 0001046311 0001115836 0001594617 0000858339 0001162556
warning	13 × Missing logo	subcommand.report	0000863015 0000356213 0001517007 0000834162 0000316206 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130 0001527705
warning	2 × Similarly named company. Duplicate?	None	0001479046 0001061937
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001566897 0001517007
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '28 of 28'}

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	29,771,467	767,190,236	8,873,807,150	13,237,900,000	0000918543	0000863015	0000858339
1	AssetsNonCurrent	0	0	5,350,151	362,550,000	543,000,000	0000858339	0001527705	0000316206
2	AssetsCurrent	2,426,013	6,248,569	106,194,011	2,628,329,100	3,770,300,000	0000216877	0000834162	0000858339
3	IntangibleAssets	0	0	12,744,980	2,022,550,000	6,551,000,000	0000216877	0001052595	0000858339
4	remainder_Assets	-59,916,000	-21,879,000	19,781,326	1,147,445,000	4,277,000,000	0001510130	0001297735	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001052595	0000216877
6	LiabilitiesCurrent	0	0	67,524,535	2,318,420,000	2,675,000,000	0001061937	0001162556	0001048286
7	remainder_Liabilities	0	0	262,443,564	6,627,044,250	24,061,900,000	0000863015	0001297735	0000858339
8	GeneralAndAdministrativeExpense	0	1,526,204	85,651,860	1,210,250,000	2,168,600,000	0000216877	0001485589	0000858339
9	DepreciationDepletionAndAmortization	0	0	28,924,327	497,247,850	697,000,000	0000316206	0000834162	0001061937
10	CostOfGoodsAndServicesSold	0	0	0	347,750	8,309,000	0000216877	0001048286	0000834162
11	OperatingExpenses	0	0	0	338,161,850	2,161,000,000	0000216877	0000918543	0001361658
12	remainder_Expenses	-3,115,000	11,778,971	196,192,806	7,505,750,000	11,461,000,000	0001510130	0001342126	0001048286
13	remainder_Revenues	0	0	428,742,412	7,704,055,000	12,784,000,000	0000907242	0000834162	0001048286
14	remainder_NetIncome	-303,568,000	-221,533,200	-97,931	168,377,839	975,011,000	0001174922	0001162556	0001295810
15	remainder_ComprehensiveNetIncome	-276,769,000	-89,870,200	0	2,703,550	5,506,000	0001174922	0001180638	0000863015

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	13,399,348	41,704,153	1,248,435,990	11,738,450,000	24,688,900,000	0000918543	0001517007	0000858339
1	Liabilities	5,576,209	27,905,401	504,774,465	8,199,641,350	26,592,700,000	0000216877	0000834162	0000858339
2	Expenses	5,689,182	15,169,857	580,539,443	9,417,120,000	12,187,000,000	0000216877	0001115836	0001048286
3	Revenues	0	0	428,742,412	7,704,055,000	12,784,000,000	0000907242	0000834162	0001048286
4	StockholdersEquity	-1,903,800,000	-338,795,700	134,793,117	3,854,400,000	7,452,000,000	0000858339	0001052595	0001061937
5	NetIncome	-2,939,800,000	-563,003,700	-6,116,853	631,850,000	1,004,157,000	0000858339	0001527705	0001174922
6	ComprehensiveNetIncome	-2,939,800,000	-607,456,850	-6,116,853	633,800,000	727,388,000	0000858339	0001527705	0001174922
7	BaseVar	41,308,075	121,340,965	3,704,513,470	54,827,768,000	74,184,064,000	0000216877	0001517007	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-1.80	-0.588	0.375	1.25	1.34	0000921738	0001479046	0000907242
9	EconomicCapitalRatio	0.0160	0.284	0.723	1.34	1.41	0000921738	0001479046	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.501	-0.337	-0.0360	0.304	0.358	0000918543	0000907242	0001479046
1	AssetsNonCurrent	-0.148	-0.0600	-0.0251	0.0475	0.330	0000918543	0001061937	0001510130
2	AssetsCurrent	-0.0682	-0.0546	-0.00834	0.0444	0.0826	0001313536	0000907242	0001174922
3	IntangibleAssets	-0.132	-0.0657	-0.00577	0.0593	0.0775	0000918543	0001180638	0000858339
4	remainder_Assets	-0.268	-0.0721	0.0100	0.118	0.315	0001510130	0000863015	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001052595	0000216877
6	LiabilitiesCurrent	-0.210	-0.0809	0.00342	0.0912	0.112	0001162556	0000834162	0000891482
7	remainder_Liabilities	-0.439	-0.314	0.0185	0.636	1.02	0001485589	0001061937	0001048286
8	GeneralAndAdministrativeExpense	-0.732	-0.626	0.0159	0.526	0.775	0000891482	0000834162	0001048286
9	DepreciationDepletionAndAmortization	-0.137	-0.112	-0.000298	0.275	0.557	0001479046	0000356213	0001048286
10	CostOfGoodsAndServicesSold	-0.0112	-0.000906	0.00148	0.00441	0.00640	0001052595	0001361658	0001048286
11	OperatingExpenses	-1.28	-0.622	0.0558	0.261	0.553	0000834162	0001342126	0001048286
12	remainder_Expenses	-4.99	-3.07	-0.0508	0.468	0.577	0001048286	0001342126	0001361658
13	remainder_Revenues	-3.93	-2.55	0.131	0.850	1.40	0000907242	0001052595	0001048286
14	remainder_NetIncome	-0.944	-0.723	-0.196	0.663	1.41	0001517007	0001361658	0000907242
15	remainder_ComprehensiveNetIncome	-0.101	-0.0151	0.00732	0.0394	0.0701	0001174922	0001297735	0001162556

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.562	-0.349	-0.0203	0.244	0.325	0000918543	0000911147	0001479046
1	Liabilities	-0.394	-0.316	0.0725	0.663	1.02	0001485589	0001061937	0001048286
2	Expenses	-2.34	-1.12	-0.0322	0.245	0.367	0001048286	0000858339	0001174922
3	Revenues	-3.93	-2.55	0.131	0.850	1.40	0000907242	0001052595	0001048286
4	StockholdersEquity	-0.662	-0.491	-0.0646	0.444	0.560	0000918543	0001162556	0001517007
5	NetIncome	-0.396	-0.305	0.00114	0.488	0.774	0000921738	0001297735	0001048286
6	ComprehensiveNetIncome	-0.384	-0.297	0.00927	0.504	0.815	0000921738	0000834162	0001048286
7	BaseVar	0	0	0	0	0	0000216877	0001052595	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.671	-0.403	0.0365	0.651	0.721	0000921738	0001479046	0000907242
9	EconomicCapitalRatio	-0.718	-0.450	-0.0110	0.604	0.674	0000921738	0001479046	0000907242

2014

Logs

error	4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001046311 0001005276 0001005276
warning	23 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000863015 0000316206 0000356213 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001610979 0000858339 0001061937 0001115836 0001581164 0001594617 0000216877 0001005276 0001162556 0001313536 0001476246 0001517401 0000918543
warning	13 × The stock price does not exist	industry.us_generic	0000863015 0000316206 0000899647 0001052595 0001342126 0000858339 0001046311 0001115836 0001581164 0001594617 0000844887 0001162556 0001476246
warning	12 × Missing logo	subcommand.report	0000863015 0000316206 0000356213 0000899647 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001610979
warning	9 × Similarly named company. Duplicate?	None	0001479046 0001527705 0001610979 0001061937 0001174922 0001468174 0001590895 0001476246 0001517401
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '36 of 36'}
warning	1 × Negative minimum value	check_abs_values	{'var_name': 'OperatingExpenses', 'min_value': -1746000}

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	6,701,806	50,946,614	1,117,365,774	11,295,250,000	14,441,542,000	0000918543	0001115836	0000789570
1	AssetsNonCurrent	0	0	4,637,206	4,591,891,000	23,626,000,000	0000858339	0001527705	0001585689
2	AssetsCurrent	2,370,114	11,428,743	177,090,890	2,843,538,250	3,673,000,000	0000216877	0001594617	0000858339
3	IntangibleAssets	0	0	60,486,191	5,675,500,000	7,261,966,000	0000216877	0001590895	0000789570
4	remainder_Assets	-13,637,000,000	-4,069,732,000	24,086,796	986,000,000	4,380,000,000	0001585689	0001297735	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001162556	0000216877
6	LiabilitiesCurrent	0	0	120,308,482	3,146,981,250	18,280,000,000	0001061937	0001517007	0000858339
7	remainder_Liabilities	0	0	547,918,851	8,153,203,750	19,154,000,000	0000789570	0001115836	0001585689
8	GeneralAndAdministrativeExpense	0	0	104,083,312	1,378,311,750	2,306,000,000	0000216877	0001297735	0000858339
9	DepreciationDepletionAndAmortization	0	0	51,235,914	652,250,000	815,765,000	0000316206	0001115836	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	79,500	9,348,000	0000216877	0001115836	0001590895
11	OperatingExpenses	-1,746,000	0	0	494,197,000	2,262,000,000	0001517007	0000789570	0001361658
12	remainder_Expenses	-6,602,000	10,833,562	403,887,387	9,701,750,000	12,462,000,000	0001594617	0001517007	0000858339
13	remainder_Revenues	0	0	742,465,575	10,186,988,000	13,796,000,000	0000891482	0001476246	0001048286
14	remainder_NetIncome	-848,816,000	-307,562,000	0	279,250,000	1,145,688,000	0000789570	0001162556	0001295810
15	remainder_ComprehensiveNetIncome	-367,000,000	-242,764,250	-23,810	0	2,227,000	0001585689	0000918543	0000863015

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	13,394,558	71,892,479	1,483,777,887	24,182,500,000	26,702,511,000	0000918543	0001115836	0000789570
1	Liabilities	5,157,187	14,073,772	937,774,982	11,991,577,500	28,277,000,000	0000216877	0001590584	0000858339
2	Expenses	6,186,178	60,894,959	851,828,107	10,705,750,000	15,404,000,000	0000216877	0001295810	0000858339
3	Revenues	0	0	742,465,575	10,186,988,000	13,796,000,000	0000891482	0001476246	0001048286
4	StockholdersEquity	-4,742,000,000	-86,816,250	422,861,864	5,433,750,000	23,294,586,000	0000858339	0000921738	0000789570
5	NetIncome	-7,196,000,000	-351,305,250	699,936	748,500,000	962,644,000	0000858339	0000216877	0001174922
6	ComprehensiveNetIncome	-7,196,000,000	-356,568,000	438,063	700,000,000	731,146,000	0000858339	0000918543	0001174922
7	BaseVar	43,739,829	354,107,105	5,081,630,874	71,211,735,000	84,537,760,000	0000216877	0000863015	0000858339
8	EconomicCapitalRatiobeforeLimitedLiability	-1.49	-0.639	0.392	1.36	2.23	0000858339	0001174922	0001476246
9	EconomicCapitalRatio	0.0442	0.267	0.736	1.43	2.23	0000858339	0001174922	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.393	-0.250	-0.0286	0.282	0.412	0000918543	0000356213	0001479046
1	AssetsNonCurrent	-0.116	-0.0726	-0.0234	0.163	0.431	0000918543	0000858339	0001585689
2	AssetsCurrent	-0.0528	-0.0475	-0.00464	0.0531	0.0758	0000863015	0001610979	0001174922
3	IntangibleAssets	-0.109	-0.0598	-0.00690	0.0762	0.118	0000918543	0000911147	0001585689
4	remainder_Assets	-0.330	-0.114	0.00216	0.115	0.299	0001594617	0001180638	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001162556	0000216877
6	LiabilitiesCurrent	-0.276	-0.106	0.0167	0.0946	0.139	0000899647	0001342126	0001061937
7	remainder_Liabilities	-0.448	-0.395	0.0374	0.605	1.000	0001313536	0000899647	0001048286
8	GeneralAndAdministrativeExpense	-0.783	-0.637	0.00819	0.465	0.662	0000907242	0001342126	0001048286
9	DepreciationDepletionAndAmortization	-0.143	-0.129	-0.00354	0.321	0.558	0000907242	0000921738	0001048286
10	CostOfGoodsAndServicesSold	-0.0380	-0.00115	0.00130	0.00282	0.00521	0001590895	0001313536	0001048286
11	OperatingExpenses	-2.87	-0.716	0.110	0.311	0.520	0001517401	0001297735	0001048286
12	remainder_Expenses	-4.74	-2.19	-0.0343	0.501	1.26	0001048286	0001342126	0001517401
13	remainder_Revenues	-3.94	-3.25	0.130	0.950	1.39	0000907242	0001585689	0001048286
14	remainder_NetIncome	-1.19	-1.04	-0.246	0.747	1.36	0001517401	0001313536	0000907242
15	remainder_ComprehensiveNetIncome	-0.360	-0.0883	0.0278	0.0976	0.133	0001115836	0000891482	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.448	-0.279	-0.00466	0.204	0.274	0000918543	0001517007	0001581164
1	Liabilities	-0.361	-0.342	0.0681	0.644	0.997	0001180638	0000921738	0001048286
2	Expenses	-2.27	-1.22	0.0387	0.325	0.430	0001048286	0001594617	0001476246
3	Revenues	-3.94	-3.25	0.130	0.950	1.39	0000907242	0001585689	0001048286
4	StockholdersEquity	-0.769	-0.382	-0.00757	0.542	0.572	0001048286	0000899647	0001517401
5	NetIncome	-0.561	-0.354	0.0592	0.428	1.24	0000863015	0000789570	0001476246
6	ComprehensiveNetIncome	-0.466	-0.369	0.0753	0.491	1.29	0000863015	0001297735	0001476246
7	BaseVar	0	0	0	0	0	0000216877	0001162556	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.709	-0.486	-0.0173	0.675	1.48	0000858339	0001174922	0001476246
9	EconomicCapitalRatio	-0.756	-0.533	-0.0648	0.627	1.43	0000858339	0001174922	0001476246

2015

Logs

error	4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001052595 0001052595
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001611046
warning	24 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001611046 0000863015 0000316206 0000356213 0001180638 0001297735 0001342126 0001527705 0001610979 0000858339 0001061937 0001115836 0001575879 0001581164 0001594617 0001656239 0000918543 0001005276 0001052595 0001162556 0001313536 0001476246 0001517401 0000216877
warning	9 × Missing logo	subcommand.report	0000863015 0000316206 0000356213 0000844887 0001180638 0001297735 0001342126 0001527705 0001610979
warning	6 × Similarly named company. Duplicate?	None	0001180638 0001610979 0001061937 0001468174 0001590895 0001313536
warning	2 × The stock price does not exist	industry.us_generic	0000844887 0000789570
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0000789570

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,291,399	297,317,182	5,403,927,098	66,632,188,440	75,757,860,000	0000844887	0000863015	0001585689
8	EconomicCapitalRatiobeforeLimitedLiability	-1.27	-0.204	0.475	1.41	2.75	0001590584	0001585689	0000858339
9	EconomicCapitalRatio	0.0818	0.384	0.796	1.47	2.75	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.282	-0.203	-0.0138	0.246	0.304	0001046311	0001342126	0001581164
1	AssetsNonCurrent	-0.0599	-0.0549	-0.0241	0.239	0.506	0001046311	0001061937	0001594617
2	AssetsCurrent	-0.0500	-0.0389	-0.00191	0.0720	0.0878	0000356213	0001581164	0001174922
3	IntangibleAssets	-0.0507	-0.0462	-0.00833	0.0917	0.119	0001162556	0001476246	0001610979
4	remainder_Assets	-0.333	-0.137	-0.00130	0.214	0.323	0001594617	0000907242	0000844887
5	LongTermLiabilities	-0.720	0.00139	0.0261	0.0717	0.126	0001313536	0000316206	0001048286
6	LiabilitiesCurrent	-0.641	-0.167	0.0227	0.125	0.158	0000844887	0001610979	0000863015
7	remainder_Liabilities	-0.520	-0.398	0.0390	0.750	0.966	0001342126	0000316206	0001048286
8	GeneralAndAdministrativeExpense	-0.722	-0.691	0.00827	0.487	0.938	0000891482	0001342126	0001048286
9	DepreciationDepletionAndAmortization	-0.195	-0.132	-0.00242	0.255	0.610	0001590584	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.231	-0.0530	0.00766	0.0162	0.0330	0000911147	0001361658	0001048286
11	OperatingExpenses	-2.07	-1.39	0.168	0.429	0.936	0001590895	0001581164	0001048286
12	remainder_Expenses	-6.86	-1.87	-0.138	0.754	0.903	0001048286	0001590584	0001590895
13	remainder_Revenues	-3.93	-3.55	0.136	1.06	1.34	0000907242	0000356213	0001048286
14	remainder_NetIncome	-1.77	-1.00	-0.349	1.36	1.86	0001048286	0001594617	0000858339
15	remainder_ComprehensiveNetIncome	-0.281	-0.226	0.0335	0.109	0.206	0001590584	0001594617	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.256	-0.190	-0.00374	0.161	0.195	0001046311	0001590895	0001581164
1	Liabilities	-0.555	-0.366	-0.00416	0.765	0.974	0000844887	0000316206	0001048286
2	Expenses	-3.34	-1.35	0.00191	0.289	0.953	0001048286	0001361658	0000858339
3	Revenues	-3.93	-3.55	0.136	1.06	1.34	0000907242	0000356213	0001048286
4	StockholdersEquity	-0.755	-0.377	-0.0485	0.453	0.677	0001048286	0001585689	0000789570
5	NetIncome	-0.548	-0.334	-0.0336	0.300	2.03	0000789570	0001174922	0000858339
6	ComprehensiveNetIncome	-0.920	-0.304	-0.0259	0.311	2.05	0001590584	0001174922	0000858339
7	BaseVar	0	0	0	0	0	0000216877	0001174922	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.802	-0.499	-0.0880	0.586	1.86	0001590584	0001585689	0000858339
9	EconomicCapitalRatio	-0.829	-0.526	-0.115	0.559	1.84	0001590584	0001585689	0000858339

2016

Logs

error	3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001052595 0001005276
warning	17 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001575879 0001180638 0001610979 0001611046 0001052595 0001061937 0001115836 0001581164 0001594617 0001656239 0000918543 0001005276 0001162556 0001313536 0001476246 0001517401 0000858339
warning	6 × Similarly named company. Duplicate?	None	0001575879 0001300514 0001468174 0001590895 0001313536 0001517401
warning	5 × Missing logo	subcommand.report	0001575879 0000844887 0001180638 0001610979 0001611046
warning	4 × The stock price does not exist	industry.us_generic	0000844887 0000789570 0001617406 0001692412
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001692412
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001594617
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0000789570
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001617406

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	261,889	1,840,385,500	9,598,250,000	15,903,000,000	0000844887	0001048286	0001300514
1	AssetsNonCurrent	0	0	11,802,651	2,070,156,650	22,654,000,000	0000844887	0001115836	0001585689
2	AssetsCurrent	3,313	2,582,687	252,846,330	3,473,300,000	4,988,000,000	0001611046	0001656239	0000858339
3	IntangibleAssets	0	0	92,209,696	4,681,000,000	16,868,000,000	0000844887	0001046311	0001048286
4	remainder_Assets	-15,771,000,000	-1,448,841,989	11,453,138	1,450,570,000	4,677,000,000	0001585689	0001590895	0001361658
5	LongTermLiabilities	0	0	0	0	282,708,289	0000844887	0001180638	0001313536
6	LiabilitiesCurrent	0	0	154,261,690	4,093,550,000	7,748,000,000	0000844887	0001594617	0000858339
7	remainder_Liabilities	0	0	896,870,128	10,228,806,250	17,678,000,000	0001048286	0001046311	0001585689
8	GeneralAndAdministrativeExpense	0	6,374	165,840,768	1,230,900,000	1,543,000,000	0000918543	0001590895	0001361658
9	DepreciationDepletionAndAmortization	0	0	139,237,259	706,900,000	1,111,000,000	0000844887	0001594617	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	4,918,650	26,921,000	0000844887	0001180638	0001590895
11	OperatingExpenses	0	0	0	853,643,100	2,511,000,000	0000844887	0000918543	0001361658
12	remainder_Expenses	-305,480,000	-131,248,560	614,446,162	8,658,600,000	15,638,000,000	0001594617	0001653653	0001048286
13	remainder_Revenues	0	0	965,684,178	11,549,150,000	17,072,000,000	0000844887	0001594617	0001048286
14	remainder_NetIncome	-2,378,000,000	-327,298,700	-486,050	576,430,000	1,207,469,000	0000858339	0000844887	0001295810
15	remainder_ComprehensiveNetIncome	-824,000,000	-354,900,000	-23,948	1,945,450	16,000,000	0000858339	0000918543	0001061937

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	587,288	8,999,723	3,012,069,371	22,488,050,000	26,211,000,000	0001611046	0001180638	0001585689
1	Liabilities	553,680	9,928,743	1,724,023,124	14,809,450,000	20,362,000,000	0001611046	0001594617	0001585689
2	Expenses	112,253	12,161,617	998,844,396	10,452,450,000	16,342,000,000	0001611046	0001295810	0001048286
3	Revenues	0	0	965,684,178	11,549,150,000	17,072,000,000	0000844887	0001594617	0001048286
4	StockholdersEquity	-1,418,000,000	-466,622,000	387,735,363	7,361,900,000	18,993,000,000	0000858339	0001590584	0001048286
5	NetIncome	-2,747,000,000	-294,745,500	30,651,230	775,950,000	2,016,000,000	0000858339	0001115836	0001300514
6	ComprehensiveNetIncome	-3,571,000,000	-293,502,150	24,688,661	711,445,000	1,617,000,000	0000858339	0001590895	0001300514
7	BaseVar	1,159,507	68,155,188	7,741,107,219	74,373,045,000	96,354,800,000	0001611046	0001295810	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.18	-1.08	0.334	1.50	4.48	0000858339	0001361658	0001575879
9	EconomicCapitalRatio	0.101	0.126	0.692	1.55	4.48	0000858339	0001361658	0001575879

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.425	-0.239	-0.00644	0.286	0.723	0000918543	0000907242	0001575879
1	AssetsNonCurrent	-0.196	-0.0935	-0.0395	0.298	0.427	0000918543	0001517401	0001594617
2	AssetsCurrent	-0.0564	-0.0465	0.000413	0.0867	0.106	0000921738	0001468174	0001174922
3	IntangibleAssets	-0.150	-0.0573	-0.00825	0.192	0.260	0000918543	0001468174	0001048286
4	remainder_Assets	-16.5	-0.322	-0.0165	0.191	0.438	0001575879	0001295810	0001313536
5	LongTermLiabilities	-0.766	0.000863	0.0215	0.0783	0.0907	0001313536	0001585689	0001575879
6	LiabilitiesCurrent	-0.320	-0.0946	0.0391	0.226	0.432	0001517401	0001585689	0001575879
7	remainder_Liabilities	-0.331	-0.299	0.0206	0.790	1.25	0001610979	0001611046	0001575879
8	GeneralAndAdministrativeExpense	-0.838	-0.527	0.00290	0.437	0.529	0000907242	0001590584	0001162556
9	DepreciationDepletionAndAmortization	-0.492	-0.146	-0.0118	0.300	0.327	0001590584	0001656239	0001162556
10	CostOfGoodsAndServicesSold	-0.213	-0.0416	0.00641	0.0150	0.0237	0000911147	0001610979	0000918543
11	OperatingExpenses	-2.57	-1.12	0.116	0.412	0.497	0001590895	0001174922	0000907242
12	remainder_Expenses	-5.37	-2.73	-0.0808	0.593	0.676	0000918543	0001174922	0001590895
13	remainder_Revenues	-6.45	-3.07	0.170	0.928	1.02	0000918543	0001313536	0001162556
14	remainder_NetIncome	-0.571	-0.503	-0.231	1.43	3.54	0001162556	0001611046	0001575879
15	remainder_ComprehensiveNetIncome	-0.0690	-0.0650	0.00948	0.0538	0.0953	0001581164	0001361658	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.57	-0.401	-0.00107	0.139	0.164	0001575879	0001585689	0001581164
1	Liabilities	-0.280	-0.207	0.0301	0.850	1.58	0001174922	0001590584	0001575879
2	Expenses	-2.43	-1.38	-0.00896	0.243	1.35	0000918543	0001115836	0001575879
3	Revenues	-6.45	-3.07	0.170	0.928	1.02	0000918543	0001313536	0001162556
4	StockholdersEquity	-0.521	-0.383	-0.0254	0.435	1.12	0000918543	0001594617	0001575879
5	NetIncome	-0.507	-0.295	0.0588	0.442	2.99	0001590584	0001115836	0001575879
6	ComprehensiveNetIncome	-0.465	-0.298	0.0757	0.472	3.02	0001590584	0001590895	0001575879
7	BaseVar	0	0	0	0	0	0000844887	0001295810	0000844887
8	EconomicCapitalRatiobeforeLimitedLiability	-0.694	-0.668	-0.102	0.754	3.69	0000858339	0001361658	0001575879
9	EconomicCapitalRatio	-0.766	-0.741	-0.175	0.681	3.61	0000858339	0001361658	0001575879

2017

Logs

error	2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001052595
warning	16 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000907242 0000911147 0000921738 0001005276 0001048286 0001052595 0001061937 0001162556 0001295810 0001300514 0001468174 0001581164 0001590584 0001590895 0001674168 0001594617
warning	14 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000216877 0001005276 0001052595 0001061937 0001115836 0001162556 0001581164 0001313536 0001517401 0001723177 0001594617 0001656239 0000918543 0001476246
warning	4 × The stock price does not exist	industry.us_generic	0001585689 0000844887 0001617406 0001692412
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 0001295810 0001692412
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001585689 0001617406 0001617406
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Excluding company: variable exceeds outlier threshold	pre-agg	0001723177

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,621,467	441,648,227	8,245,680,986	67,839,492,430	127,329,920,000	0000844887	0001295810	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.22	0.0363	0.451	1.71	1.88	0000844887	0001115836	0000789570
9	EconomicCapitalRatio	0.0913	0.436	0.778	1.73	1.89	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.271	-0.222	-0.0169	0.257	0.371	0001046311	0001048286	0001581164
1	AssetsNonCurrent	-0.0734	-0.0600	-0.0247	0.183	0.537	0001590584	0001005276	0001594617
2	AssetsCurrent	-0.112	-0.0844	-0.0171	0.0712	0.182	0001656239	0001468174	0000918543
3	IntangibleAssets	-0.0791	-0.0640	-0.0187	0.0540	0.314	0001590584	0001616000	0001590895
4	remainder_Assets	-0.413	-0.174	-0.00914	0.131	0.457	0000891482	0001476246	0001313536
5	LongTermLiabilities	-0.809	-0.343	0.0454	0.143	0.184	0001313536	0000921738	0001048286
6	LiabilitiesCurrent	-0.161	-0.0200	0.0790	0.200	0.206	0000844887	0001590895	0000906553
7	remainder_Liabilities	-0.753	-0.292	0.0547	0.773	0.937	0000918543	0001674168	0001048286
8	GeneralAndAdministrativeExpense	-0.755	-0.687	0.00173	0.427	0.628	0000907242	0000789570	0001162556
9	DepreciationDepletionAndAmortization	-0.537	-0.127	-0.0108	0.309	0.418	0001590584	0001174922	0001048286
10	CostOfGoodsAndServicesSold	-1.02	-0.0946	0.0440	0.0982	0.123	0001616000	0001313536	0001048286
11	OperatingExpenses	-1.44	-1.01	0.187	0.417	0.539	0001590895	0001653653	0001048286
12	remainder_Expenses	-3.64	-2.50	-0.180	0.650	0.784	0001048286	0001295810	0001594617
13	remainder_Revenues	-3.85	-2.57	0.259	1.03	1.31	0000907242	0001590895	0001048286
14	remainder_NetIncome	-0.688	-0.532	-0.271	0.975	1.72	0000906553	0001656239	0000907242
15	remainder_ComprehensiveNetIncome	-0.0884	-0.0689	-0.00699	0.0994	0.135	0001581164	0001517401	0001115836

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.349	-0.259	-0.0322	0.120	0.290	0000891482	0001653653	0000918543
1	Liabilities	-0.630	-0.156	0.0401	0.897	1.03	0000918543	0001616000	0001048286
2	Expenses	-1.97	-1.31	0.0351	0.260	0.331	0001162556	0001295810	0000921738
3	Revenues	-3.85	-2.57	0.259	1.03	1.31	0000907242	0001590895	0001048286
4	StockholdersEquity	-0.451	-0.295	0.0119	0.561	0.780	0001046311	0001468174	0000789570
5	NetIncome	-0.727	-0.287	0.0651	0.417	0.540	0001590584	0001476246	0001300514
6	ComprehensiveNetIncome	-0.550	-0.305	0.0538	0.388	0.467	0001590584	0001468174	0001300514
7	BaseVar	0	0	0	0	0	0000789570	0001295810	0000789570
8	EconomicCapitalRatiobeforeLimitedLiability	-0.819	-0.474	-0.132	0.820	0.978	0000844887	0001115836	0000789570
9	EconomicCapitalRatio	-0.839	-0.494	-0.151	0.801	0.958	0000844887	0001115836	0000789570

2018

Logs

error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595
warning	32 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001653653 0000891482 0000789570 0000858339 0000907242 0000907242 0000911147 0000921738 0000921738 0001005276 0001005276 0001048286 0001048286 0001061937 0001061937 0001174922 0001295810 0001295810 0001300514 0001300514 0001468174 0001468174 0001581164 0001590584 0001590584 0001590895 0001590895 0001674168 0001674168 0001747079 0001052595 0001162556
warning	11 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000858339 0001005276 0001061937 0001581164 0000216877 0001313536 0001723177 0001052595 0001115836 0001162556 0001517401
warning	5 × The stock price does not exist	industry.us_generic	0000844887 0000911147 0001617406 0001692412 0001585689
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001295810 0001295810
warning	4 × Ignoring company because Expenses is zero	pre-agg	0000911147 0001617406 0001617406 0001585689
warning	2 × Excluding company: variable exceeds outlier threshold	pre-agg	0001723177 0001723177
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887

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,651,772	1,602,923,107	13,805,500,000	20,729,888,000	0000844887	0001692412	0000789570
1	AssetsNonCurrent	0	0	7,847,197	1,378,500,000	6,954,040,000	0000216877	0001115836	0000789570
2	AssetsCurrent	16,608	10,234,029	265,730,185	2,689,844,000	5,566,000,000	0000844887	0001581164	0001300514
3	IntangibleAssets	0	0	85,401,398	5,095,713,750	17,419,000,000	0000216877	0001692412	0001048286
4	remainder_Assets	-5,765,855,000	0	114,952,550	992,250,000	4,893,000,000	0000789570	0001692412	0001361658
5	LongTermLiabilities	0	0	0	544,207,211	989,387,000	0000216877	0001048286	0001692412
6	LiabilitiesCurrent	0	0	73,132,095	3,104,970,500	6,437,000,000	0001061937	0001590584	0001048286
7	remainder_Liabilities	0	0	933,233,617	9,512,401,500	12,645,000,000	0000789570	0001046311	0001300514
8	GeneralAndAdministrativeExpense	0	160,817	110,017,438	1,073,250,000	1,483,000,000	0000216877	0001692412	0001300514
9	DepreciationDepletionAndAmortization	0	0	103,927,642	845,649,000	1,111,000,000	0000789570	0001590584	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	223,240,114	689,762,000	0000789570	0001005276	0001616000
11	OperatingExpenses	0	0	0	375,270,000	1,642,000,000	0000216877	0001046311	0001361658
12	remainder_Expenses	21,570	2,862,884	737,680,055	9,919,809,000	18,017,000,000	0000844887	0001005276	0001048286
13	remainder_Revenues	0	39,268,026	1,222,905,938	13,237,524,000	20,758,000,000	0000844887	0001581164	0001048286
14	remainder_NetIncome	-687,790,000	-515,579,250	-1,313	642,750,000	932,000,000	0000789570	0001162556	0001061937
15	remainder_ComprehensiveNetIncome	-592,000,000	-332,887,000	-452,033	742,500	53,000,000	0001300514	0001162556	0001468174

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,492,785	54,559,248	2,962,586,218	23,408,750,000	30,210,706,000	0000844887	0001616000	0000789570
1	Liabilities	2,826,553	20,071,439	1,319,773,900	11,108,557,750	15,802,000,000	0000216877	0001046311	0001300514
2	Expenses	734,385	34,502,646	1,066,239,905	10,722,103,000	19,170,000,000	0000844887	0001581164	0001048286
3	Revenues	0	39,268,026	1,222,905,938	13,237,524,000	20,758,000,000	0000844887	0001581164	0001048286
4	StockholdersEquity	-569,000,000	-139,282,034	685,968,400	14,867,750,000	27,261,824,000	0001361658	0000921738	0000789570
5	NetIncome	-81,847,000	-21,341,039	123,369,400	1,718,000,000	2,951,000,000	0001590584	0001005276	0001300514
6	ComprehensiveNetIncome	-125,279,000	-50,195,250	113,260,975	1,424,500,000	2,359,000,000	0001590584	0000906553	0001300514
7	BaseVar	11,518,542	260,863,023	8,629,738,530	78,110,679,930	113,359,640,000	0000844887	0001295810	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-0.657	-0.157	0.695	1.73	1.94	0000844887	0001046311	0000216877
9	EconomicCapitalRatio	0.261	0.407	0.943	1.75	1.95	0000844887	0001046311	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.254	-0.194	-0.00565	0.259	0.339	0001313536	0001300514	0001692412
1	AssetsNonCurrent	-0.0186	-0.0159	-0.00513	0.0247	0.0324	0001162556	0001590895	0001468174
2	AssetsCurrent	-0.0533	-0.0380	-0.00646	0.0321	0.0963	0001361658	0001590584	0001674168
3	IntangibleAssets	-0.0802	-0.0671	-0.0125	0.110	0.216	0001162556	0000907242	0001590895
4	remainder_Assets	-0.0921	-0.0700	-0.0213	0.288	0.381	0001162556	0001048286	0001313536
5	LongTermLiabilities	-0.744	-0.404	0.0614	0.147	0.177	0001313536	0001616000	0001048286
6	LiabilitiesCurrent	-0.796	0.0252	0.116	0.208	0.290	0000844887	0001692412	0001061937
7	remainder_Liabilities	-0.533	-0.464	0.0158	0.656	0.706	0001361658	0000844887	0001048286
8	GeneralAndAdministrativeExpense	-0.777	-0.506	0.0363	0.393	0.497	0000911147	0001174922	0001162556
9	DepreciationDepletionAndAmortization	-0.311	-0.225	0.0136	0.261	0.369	0001590584	0001590895	0001162556
10	CostOfGoodsAndServicesSold	-1.20	-0.824	0.142	0.267	0.310	0001616000	0001361658	0001162556
11	OperatingExpenses	-1.23	-0.602	0.134	0.283	0.333	0001517401	0001115836	0001162556
12	remainder_Expenses	-4.17	-2.33	-0.131	0.505	0.808	0001162556	0001005276	0001616000
13	remainder_Revenues	-0.430	-0.247	0.0466	0.768	0.911	0000844887	0001468174	0001048286
14	remainder_NetIncome	-0.357	-0.237	-0.0441	0.365	0.551	0000906553	0001313536	0001295810
15	remainder_ComprehensiveNetIncome	-0.110	-0.0817	0.0236	0.0714	0.0784	0000911147	0001590895	0000216877

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.232	-0.132	-0.0103	0.107	0.175	0001162556	0000907242	0001692412
1	Liabilities	-0.472	-0.313	0.0515	0.763	0.809	0000844887	0001300514	0001048286
2	Expenses	-1.98	-0.933	0.0111	0.212	0.311	0001162556	0001313536	0001295810
3	Revenues	-0.430	-0.247	0.0466	0.768	0.911	0000844887	0001468174	0001048286
4	StockholdersEquity	-0.410	-0.259	0.0232	0.652	0.672	0001046311	0001581164	0000216877
5	NetIncome	-0.528	-0.453	0.0287	0.369	0.606	0001162556	0001174922	0001295810
6	ComprehensiveNetIncome	-0.674	-0.416	0.00159	0.433	0.633	0001590584	0001174922	0001295810
7	BaseVar	0	0	0	0	0	0000216877	0001115836	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.708	-0.562	-0.0255	0.780	0.979	0000844887	0001046311	0000216877
9	EconomicCapitalRatio	-0.734	-0.588	-0.0513	0.754	0.953	0000844887	0001046311	0000216877

2019

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001585689
warning	34 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001585689 0000789570 0000789570 0000891482 0000891482 0000906553 0000907242 0000907242 0000921738 0000921738 0001005276 0001005276 0001048286 0001048286 0001061937 0001061937 0001174922 0001174922 0001295810 0001300514 0001300514 0001468174 0001468174 0001590584 0001590584 0001590895 0001590895 0001653653 0001653653 0001674168 0001674168 0001747079 0001747079 0000858339
warning	8 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001581164 0000216877 0001005276 0001061937 0000844887 0001313536 0000858339 0001723177
warning	4 × The stock price does not exist	industry.us_generic	0001581164 0000911147 0001617406 0001692412
warning	3 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001295810
warning	3 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0001617406
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001581164
warning	1 × Excluding company: variable exceeds outlier threshold	pre-agg	0001723177

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	41,857,969	2,273,930,525	14,943,000,000	18,285,955,000	0001313536	0001590895	0000789570
1	AssetsNonCurrent	0	0	65,010,427	4,268,000,000	11,582,708,000	0000216877	0001005276	0000789570
2	AssetsCurrent	5,348,689	21,632,766	350,926,470	3,787,519,750	5,305,000,000	0000216877	0001361658	0001300514
3	IntangibleAssets	0	0	190,614,765	6,604,767,000	17,689,000,000	0000216877	0001590584	0001048286
4	remainder_Assets	-5,911,068,000	-9,660,000	196,312,938	927,750,000	5,305,000,000	0000789570	0001616000	0001361658
5	LongTermLiabilities	0	0	0	987,493,500	1,293,054,000	0000216877	0001005276	0001616000
6	LiabilitiesCurrent	0	0	193,432,890	3,215,855,750	6,677,000,000	0001061937	0001653653	0001048286
7	remainder_Liabilities	-5,516,000	0	1,028,602,860	12,960,250,000	21,071,000,000	0001712189	0001046311	0000858339
8	GeneralAndAdministrativeExpense	0	0	118,430,970	1,787,000,000	2,101,217,000	0000216877	0001692412	0000789570
9	DepreciationDepletionAndAmortization	0	0	76,575,742	1,129,000,000	1,304,649,000	0000906553	0001692412	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	401,481,500	772,857,000	0000891482	0001005276	0001616000
11	OperatingExpenses	0	0	0	368,037,500	1,648,000,000	0000789570	0000891482	0001361658
12	remainder_Expenses	637,380	20,545,839	957,794,950	7,823,250,000	18,613,000,000	0000216877	0001581164	0001048286
13	remainder_Revenues	8,507,134	170,521,033	1,614,527,975	13,529,168,000	20,972,000,000	0000216877	0001674168	0001048286
14	remainder_NetIncome	-973,969,000	-561,700,000	-131,833	560,000,000	902,000,000	0000789570	0000907242	0001468174
15	remainder_ComprehensiveNetIncome	-569,000,000	-183,362,000	-38,807	6,353,500	30,000,000	0001300514	0001313536	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	20,663,648	280,307,948	3,975,064,055	25,271,500,000	33,876,356,000	0000216877	0001581164	0000789570
1	Liabilities	2,915,974	183,848,500	2,441,918,592	15,604,650,000	23,134,000,000	0000216877	0001674168	0000858339
2	Expenses	7,124,539	114,614,000	1,439,112,557	10,725,830,750	19,892,000,000	0000216877	0001674168	0001048286
3	Revenues	8,507,134	170,521,033	1,614,527,975	13,529,168,000	20,972,000,000	0000216877	0001674168	0001048286
4	StockholdersEquity	-524,000,000	-13,196,332	964,223,015	15,647,250,000	30,684,933,000	0001361658	0001590895	0000789570
5	NetIncome	-1,198,000,000	-45,434,750	112,051,480	1,979,035,000	3,304,000,000	0000858339	0001295810	0001300514
6	ComprehensiveNetIncome	-1,232,000,000	-44,146,500	74,504,535	1,859,723,500	2,735,000,000	0000858339	0001590895	0001300514
7	BaseVar	50,038,673	1,084,614,360	10,197,766,198	81,155,610,205	115,294,540,000	0000216877	0001674168	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-0.173	0.0265	0.502	1.80	1.86	0000858339	0001674168	0000789570
9	EconomicCapitalRatio	0.389	0.426	0.814	1.81	1.87	0000858339	0001674168	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.242	-0.215	-0.0393	0.276	0.319	0001313536	0000789570	0001581164
1	AssetsNonCurrent	-0.0901	-0.0416	-0.0124	0.0360	0.128	0000789570	0000891482	0000921738
2	AssetsCurrent	-0.0535	-0.0522	-0.00818	0.0456	0.112	0001361658	0001581164	0001674168
3	IntangibleAssets	-0.0851	-0.0694	-0.0194	0.125	0.161	0001174922	0000789570	0001590895
4	remainder_Assets	-0.101	-0.0686	-0.0120	0.223	0.467	0000891482	0001061937	0001313536
5	LongTermLiabilities	-1.81	-0.472	0.0707	0.181	0.202	0001712189	0001174922	0001048286
6	LiabilitiesCurrent	-0.319	-0.122	-0.0137	0.0753	0.111	0001048286	0000906553	0001061937
7	remainder_Liabilities	-0.445	-0.359	0.0262	0.692	0.738	0001361658	0001061937	0001048286
8	GeneralAndAdministrativeExpense	-0.687	-0.397	0.0160	0.356	0.423	0000891482	0001300514	0000906553
9	DepreciationDepletionAndAmortization	-0.162	-0.140	-0.00357	0.185	0.207	0001061937	0000907242	0000906553
10	CostOfGoodsAndServicesSold	-1.18	-0.798	0.110	0.195	0.238	0001616000	0001747079	0001048286
11	OperatingExpenses	-2.03	-0.594	0.138	0.230	0.287	0000216877	0001747079	0001048286
12	remainder_Expenses	-2.54	-1.59	-0.0943	0.797	1.17	0001048286	0001590895	0000216877
13	remainder_Revenues	-0.247	-0.222	-0.0465	0.466	0.666	0001692412	0001361658	0001048286
14	remainder_NetIncome	-0.311	-0.245	0.0314	0.179	0.522	0001712189	0001616000	0001468174
15	remainder_ComprehensiveNetIncome	-0.0867	-0.0698	0.0157	0.0403	0.0718	0001581164	0001313536	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.306	-0.153	-0.0302	0.146	0.199	0000891482	0001653653	0001692412
1	Liabilities	-0.480	-0.266	-0.0644	0.729	0.756	0001712189	0001674168	0000906553
2	Expenses	-1.20	-0.533	-0.00233	0.216	0.894	0001048286	0000858339	0001712189
3	Revenues	-0.247	-0.222	-0.0465	0.466	0.666	0001692412	0001361658	0001048286
4	StockholdersEquity	-0.343	-0.301	-0.0874	0.627	0.748	0001046311	0000858339	0000789570
5	NetIncome	-0.527	-0.386	-0.0360	0.322	1.07	0001590584	0001747079	0001712189
6	ComprehensiveNetIncome	-0.471	-0.370	-0.0748	0.307	1.08	0001590584	0001581164	0001712189
7	BaseVar	0	0	0	0	0	0000216877	0001174922	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.551	-0.514	-0.126	0.872	0.932	0000858339	0001674168	0000789570
9	EconomicCapitalRatio	-0.560	-0.522	-0.135	0.864	0.923	0000858339	0001674168	0000789570

2020

Logs

warning	35 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000789570 0000789570 0000891482 0000891482 0000906553 0000906553 0000907242 0000907242 0000911147 0000921738 0000921738 0001005276 0001005276 0001048286 0001048286 0001061937 0001061937 0001174922 0001174922 0001300514 0001300514 0001468174 0001468174 0001585689 0001590584 0001590584 0001590895 0001590895 0001617406 0001653653 0001653653 0001674168 0001674168 0001747079 0001747079
warning	5 × The stock price does not exist	industry.us_generic	0001581164 0000844887 0000911147 0001692412 0001819395
warning	5 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000844887 0001005276 0001061937 0000216877 0001313536
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0001005276 0001048286 0001048286
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 "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	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,287,814	307,685,442	8,174,532,668	52,556,672,614	67,583,200,000	0000844887	0001005276	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.79	-0.660	-0.0916	1.36	1.52	0000844887	0000921738	0001581164
9	EconomicCapitalRatio	0.0168	0.259	0.397	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.233	-0.171	-0.0189	0.256	0.276	0001046311	0001712189	0001617406
1	AssetsNonCurrent	-0.0625	-0.0571	-0.0141	0.125	0.260	0001590584	0001361658	0001585689
2	AssetsCurrent	-0.0687	-0.0460	-0.00255	0.0633	0.0706	0001590584	0000921738	0001674168
3	IntangibleAssets	-0.0757	-0.0683	-0.0107	0.117	0.349	0001061937	0001295810	0001048286
4	remainder_Assets	-0.0821	-0.0602	-0.0108	0.0595	0.311	0000891482	0001712189	0001313536
5	LongTermLiabilities	-0.499	-0.0550	0.00536	0.0600	0.0670	0001616000	0001585689	0000216877
6	LiabilitiesCurrent	-0.0890	-0.0267	0.0210	0.110	0.151	0001048286	0001313536	0001581164
7	remainder_Liabilities	-0.658	-0.260	-0.0202	0.656	0.682	0001581164	0001046311	0001048286
8	GeneralAndAdministrativeExpense	-0.557	-0.222	-0.000609	0.163	0.298	0000891482	0001590895	0000216877
9	DepreciationDepletionAndAmortization	-0.152	-0.117	0.00445	0.134	0.137	0001061937	0000844887	0001712189
10	CostOfGoodsAndServicesSold	-0.481	-0.222	0.0173	0.0904	0.110	0001616000	0001585689	0000891482
11	OperatingExpenses	-1.69	-0.228	0.0304	0.148	0.191	0000216877	0001585689	0000891482
12	remainder_Expenses	-1.59	-1.05	-0.0112	0.365	0.802	0001590584	0001061937	0000216877
13	remainder_Revenues	-0.324	-0.265	0.000660	0.611	0.737	0001295810	0000921738	0001048286
14	remainder_NetIncome	-0.239	-0.107	0.0160	0.137	0.176	0001712189	0001585689	0001616000
15	remainder_ComprehensiveNetIncome	-0.0972	-0.0175	-0.00175	0.0337	0.0413	0001581164	0001617406	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.483	-0.271	-0.00130	0.164	0.169	0001590584	0001468174	0001616000
1	Liabilities	-0.348	-0.204	0.00380	0.677	0.751	0001581164	0001468174	0000906553
2	Expenses	-1.28	-0.512	-0.0145	0.383	0.729	0001590584	0001585689	0001581164
3	Revenues	-0.324	-0.265	0.000660	0.611	0.737	0001295810	0000921738	0001048286
4	StockholdersEquity	-0.276	-0.178	-0.0192	0.592	0.856	0001046311	0001300514	0000789570
5	NetIncome	-0.492	-0.244	-0.00504	0.713	1.16	0001295810	0001590895	0001581164
6	ComprehensiveNetIncome	-0.498	-0.249	-0.00178	0.708	1.10	0001295810	0000921738	0001581164
7	BaseVar	0	0	0	0	0	0000216877	0001295810	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.482	-0.239	-0.101	0.926	1.06	0000844887	0000921738	0001581164
9	EconomicCapitalRatio	-0.599	-0.356	-0.218	0.809	0.943	0000844887	0000921738	0001581164

2021

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	38 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001061937 0000789570 0000789570 0000891482 0000891482 0000906553 0000906553 0000907242 0000907242 0000911147 0000911147 0000921738 0000921738 0001005276 0001005276 0001046311 0001048286 0001048286 0001174922 0001174922 0001295810 0001300514 0001300514 0001468174 0001468174 0001590584 0001590584 0001590895 0001590895 0001617406 0001617406 0001653653 0001653653 0001674168 0001674168 0001747079 0001747079
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0000911147 0001005276 0001005276 0001048286 0001048286 0001712189
warning	4 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0001005276 0000216877 0001313536
warning	3 × The stock price does not exist	industry.us_generic	0001692412 0000844887 0001819395
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887

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,308,030	156,864,444	10,579,957,448	74,283,213,936	84,540,440,000	0000844887	0001722684	0001590895
8	EconomicCapitalRatiobeforeLimitedLiability	-1.46	-0.315	0.349	1.83	2.00	0000844887	0000911147	0000216877
9	EconomicCapitalRatio	0.0491	0.363	0.704	1.85	2.01	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.228	-0.185	-0.0179	0.344	0.360	0001585689	0000789570	0001295810
1	AssetsNonCurrent	-0.0790	-0.0728	-0.0147	0.114	0.247	0001590584	0000906553	0001585689
2	AssetsCurrent	-0.0935	-0.0531	-0.00705	0.0852	0.306	0000216877	0001295810	0000891482
3	IntangibleAssets	-0.0958	-0.0893	-0.0186	0.156	0.226	0001590584	0001819395	0001747079
4	remainder_Assets	-0.272	-0.166	-0.0458	0.207	1.18	0001585689	0001295810	0001819395
5	LongTermLiabilities	-0.541	-0.171	0.0296	0.0921	0.129	0001616000	0000921738	0000906553
6	LiabilitiesCurrent	-0.270	-0.176	0.000484	0.0784	0.0918	0001048286	0000844887	0001361658
7	remainder_Liabilities	-0.271	-0.193	-0.0200	0.868	1.14	0001361658	0001468174	0000906553
8	GeneralAndAdministrativeExpense	-0.355	-0.246	0.00157	0.186	0.397	0000907242	0001300514	0000216877
9	DepreciationDepletionAndAmortization	-0.259	-0.141	0.00342	0.143	0.180	0001590584	0001747079	0001048286
10	CostOfGoodsAndServicesSold	-0.592	-0.361	0.0612	0.146	0.163	0001313536	0001674168	0001590584
11	OperatingExpenses	-1.71	-0.799	0.105	0.276	0.367	0000216877	0001585689	0001590584
12	remainder_Expenses	-1.98	-1.46	-0.0418	0.402	0.824	0001590584	0001174922	0000216877
13	remainder_Revenues	-0.574	-0.277	0.0482	0.803	1.13	0001819395	0001585689	0000906553
14	remainder_NetIncome	-0.280	-0.239	0.0197	0.290	0.314	0001712189	0001313536	0001295810
15	remainder_ComprehensiveNetIncome	-0.124	-0.0995	0.00409	0.0304	0.0380	0001692412	0001061937	0001722684

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.355	-0.225	-0.0136	0.166	0.724	0001590584	0001712189	0001819395
1	Liabilities	-0.194	-0.183	-0.0179	0.839	1.19	0001585689	0001722684	0000906553
2	Expenses	-1.58	-0.701	-0.0111	0.222	0.528	0001590584	0001300514	0001712189
3	Revenues	-0.574	-0.277	0.0482	0.803	1.13	0001819395	0001585689	0000906553
4	StockholdersEquity	-0.371	-0.326	-0.0647	0.678	0.798	0001361658	0001468174	0001819395
5	NetIncome	-0.244	-0.216	0.0548	0.628	0.988	0001616000	0001674168	0001712189
6	ComprehensiveNetIncome	-0.238	-0.212	0.0589	0.639	0.996	0001617406	0000921738	0001712189
7	BaseVar	0	0	0	0	0	0000216877	0001295810	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.761	-0.447	-0.106	1.04	1.20	0000844887	0000911147	0000216877
9	EconomicCapitalRatio	-0.793	-0.479	-0.138	1.01	1.17	0000844887	0000911147	0000216877

2022

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	38 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001061937 0000789570 0000789570 0000891482 0000891482 0000906553 0000906553 0000907242 0000907242 0000911147 0000921738 0000921738 0001046311 0001046311 0001048286 0001048286 0001174922 0001174922 0001295810 0001295810 0001300514 0001300514 0001468174 0001468174 0001590584 0001590584 0001590895 0001590895 0001617406 0001617406 0001653653 0001653653 0001674168 0001674168 0001747079 0001747079 0001005276
warning	5 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000911147 0001048286 0001712189 0001712189 0001005276
warning	4 × The stock price does not exist	industry.us_generic	0001692412 0000844887 0000911147 0001819395
warning	4 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0000216877 0001005276 0001313536
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
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	0	1,370,304,448	10,684,650,000	14,598,000,000	0000844887	0001692412	0001590895
1	AssetsNonCurrent	0	0	187,182,946	9,786,390,000	32,313,586,000	0000216877	0001617406	0000789570
2	AssetsCurrent	55,885	16,198,251	413,452,887	5,522,514,150	8,154,692,000	0000844887	0000906553	0000789570
3	IntangibleAssets	0	0	181,110,696	11,606,153,800	17,619,000,000	0000216877	0001174922	0001048286
4	remainder_Assets	-6,580,564,000	-2,921,600,000	174,764,449	1,832,050,000	2,447,000,000	0000789570	0001692412	0001674168
5	LongTermLiabilities	0	0	0	786,007,750	2,651,000,000	0000216877	0001061937	0001674168
6	LiabilitiesCurrent	0	0	272,068,563	4,239,640,600	7,339,000,000	0000844887	0001653653	0001048286
7	remainder_Liabilities	0	0	1,458,596,811	13,924,368,900	27,108,000,000	0000789570	0001046311	0001590895
8	GeneralAndAdministrativeExpense	0	3,490,629	197,001,434	1,637,080,000	4,226,617,000	0000216877	0001046311	0000789570
9	DepreciationDepletionAndAmortization	0	0	127,387,719	1,188,350,000	3,482,050,000	0000844887	0001653653	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	448,464,900	672,275,000	0000844887	0000911147	0001616000
11	OperatingExpenses	0	0	0	723,563,500	1,603,000,000	0000789570	0000789570	0001361658
12	remainder_Expenses	724,700	920,260	736,485,749	6,220,600,000	17,386,000,000	0000216877	0001046311	0001048286
13	remainder_Revenues	0	79,161,543	1,627,360,998	12,089,566,750	20,773,000,000	0000844887	0001653653	0001048286
14	remainder_NetIncome	-2,690,000,000	-752,388,700	0	145,800,000	3,005,000,000	0001590895	0000844887	0001300514
15	remainder_ComprehensiveNetIncome	-387,000,000	-231,059,800	0	395,096,800	1,314,113,000	0001048286	0000216877	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,532,062	197,558,054	3,736,629,025	29,606,600,000	45,692,206,000	0000844887	0001722684	0000789570
1	Liabilities	3,547,796	78,934,416	3,212,203,266	17,585,150,000	29,776,000,000	0000216877	0001005276	0001590895
2	Expenses	1,855,705	72,474,946	1,250,648,112	10,792,182,400	18,470,000,000	0000844887	0001005276	0001048286
3	Revenues	0	79,161,543	1,627,360,998	12,089,566,750	20,773,000,000	0000844887	0001653653	0001048286
4	StockholdersEquity	-1,640,365,000	-1,010,700,000	602,273,133	12,707,350,000	41,176,314,000	0001174922	0001692412	0000789570
5	NetIncome	-910,000,000	-581,648,100	151,508,876	1,312,000,000	2,358,000,000	0001590895	0001617406	0001048286
6	ComprehensiveNetIncome	-843,000,000	-575,526,150	99,382,689	1,700,229,800	1,971,000,000	0001590895	0000921738	0001048286
7	BaseVar	16,020,306	603,283,929	10,883,383,855	89,101,783,462	112,114,700,000	0000844887	0001653653	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.61	-0.482	0.509	2.13	2.23	0000844887	0001674168	0001712189
9	EconomicCapitalRatio	0.0305	0.318	0.819	2.14	2.23	0000844887	0001674168	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.211	-0.189	-0.0374	0.371	0.451	0000891482	0001048286	0001617406
1	AssetsNonCurrent	-0.143	-0.0873	-0.0119	0.230	0.319	0001590584	0000844887	0001585689
2	AssetsCurrent	-0.0899	-0.0699	-0.0137	0.0614	0.114	0000216877	0001617406	0001361658
3	IntangibleAssets	-0.156	-0.0989	-0.0142	0.101	0.194	0000906553	0000844887	0001747079
4	remainder_Assets	-0.175	-0.115	-0.0141	0.108	0.464	0001585689	0001174922	0001313536
5	LongTermLiabilities	-0.667	-0.163	0.0245	0.0965	0.103	0001616000	0001653653	0000906553
6	LiabilitiesCurrent	-0.325	-0.241	-0.00158	0.0895	0.103	0001048286	0001005276	0001061937
7	remainder_Liabilities	-0.280	-0.192	-0.0262	1.05	1.23	0001361658	0001747079	0000906553
8	GeneralAndAdministrativeExpense	-0.464	-0.321	-0.00170	0.308	0.401	0000907242	0001590895	0000216877
9	DepreciationDepletionAndAmortization	-0.419	-0.218	0.00609	0.183	0.301	0000789570	0000844887	0001048286
10	CostOfGoodsAndServicesSold	-1.08	-0.715	0.0910	0.257	0.314	0001313536	0001295810	0001590584
11	OperatingExpenses	-1.86	-0.805	0.137	0.370	0.390	0000216877	0000911147	0001048286
12	remainder_Expenses	-2.81	-2.02	-0.00411	0.568	0.926	0001048286	0001174922	0000216877
13	remainder_Revenues	-0.583	-0.258	0.0632	1.07	1.10	0001300514	0001692412	0000907242
14	remainder_NetIncome	-0.312	-0.248	0.0119	0.252	0.480	0001590895	0001692412	0001300514
15	remainder_ComprehensiveNetIncome	-0.182	-0.146	0.0101	0.0732	0.233	0001653653	0001313536	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.409	-0.115	-0.00135	0.0986	0.166	0001590584	0000844887	0001617406
1	Liabilities	-0.203	-0.169	0.0165	1.02	1.27	0000891482	0000911147	0000906553
2	Expenses	-1.92	-0.929	-0.0200	0.232	0.841	0001590584	0001313536	0001712189
3	Revenues	-0.583	-0.258	0.0632	1.07	1.10	0001300514	0001692412	0000907242
4	StockholdersEquity	-0.260	-0.214	-0.0186	0.791	0.873	0001361658	0000921738	0000906553
5	NetIncome	-0.301	-0.246	0.0316	0.590	1.46	0001590584	0001674168	0001712189
6	ComprehensiveNetIncome	-0.479	-0.278	0.0436	0.612	1.47	0001590584	0001361658	0001712189
7	BaseVar	0	0	0	0	0	0000216877	0001295810	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.837	-0.549	-0.0487	1.27	1.36	0000844887	0001674168	0001712189
9	EconomicCapitalRatio	-0.894	-0.607	-0.106	1.21	1.31	0000844887	0001674168	0001712189

2023

Logs

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

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,657,163	605,457,568	19,061,281,058	94,031,917,468	124,608,860,000	0000844887	0001747079	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.40	-0.752	0.462	2.11	4.00	0000844887	0001617406	0001712189
9	EconomicCapitalRatio	0.0577	0.216	0.786	2.12	4.00	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.203	-0.171	-0.0460	0.339	0.429	0001585689	0000844887	0001616000
1	AssetsNonCurrent	-0.0923	-0.0788	-0.0145	0.172	0.249	0000921738	0000844887	0001585689
2	AssetsCurrent	-0.143	-0.0469	-0.0102	0.0890	0.159	0001712189	0001590584	0001361658
3	IntangibleAssets	-0.120	-0.0827	-0.0194	0.113	0.222	0000906553	0000844887	0001590895
4	remainder_Assets	-0.210	-0.0841	-0.00184	0.152	0.178	0001585689	0000216877	0000891482
5	LongTermLiabilities	-0.602	-0.463	0.0390	0.169	0.200	0001616000	0001300514	0001712189
6	LiabilitiesCurrent	-0.122	-0.0479	0.160	0.431	0.587	0000844887	0001361658	0001712189
7	remainder_Liabilities	-0.459	-0.336	-0.0186	0.935	1.05	0001361658	0001061937	0000906553
8	GeneralAndAdministrativeExpense	-0.514	-0.478	0.00733	0.321	0.455	0000907242	0001819395	0001048286
9	DepreciationDepletionAndAmortization	-0.332	-0.195	-0.00106	0.222	0.313	0001590584	0001653653	0001048286
10	CostOfGoodsAndServicesSold	-1.11	-0.193	0.0873	0.222	0.232	0001616000	0001653653	0001048286
11	OperatingExpenses	-2.04	-0.842	0.193	0.500	0.550	0000216877	0001616000	0001590584
12	remainder_Expenses	-2.95	-2.32	-0.156	0.533	1.03	0001590584	0000789570	0000216877
13	remainder_Revenues	-0.268	-0.258	0.0230	1.06	1.98	0001747079	0001300514	0001712189
14	remainder_NetIncome	-0.264	-0.188	0.0286	0.190	0.283	0001590895	0001692412	0001295810
15	remainder_ComprehensiveNetIncome	-0.147	-0.0208	0.00455	0.0356	0.0611	0001653653	0001747079	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.185	-0.140	0.00827	0.134	0.201	0001590584	0001653653	0001712189
1	Liabilities	-0.214	-0.182	-0.0106	1.17	1.25	0001174922	0001046311	0000906553
2	Expenses	-2.07	-0.985	-0.0634	0.257	1.32	0001590584	0001616000	0001712189
3	Revenues	-0.268	-0.258	0.0230	1.06	1.98	0001747079	0001300514	0001712189
4	StockholdersEquity	-0.264	-0.257	0.00212	0.809	0.868	0001585689	0001674168	0000906553
5	NetIncome	-0.312	-0.276	0.0472	0.493	2.92	0000921738	0001361658	0001712189
6	ComprehensiveNetIncome	-0.294	-0.266	0.0304	0.506	2.93	0000921738	0001653653	0001712189
7	BaseVar	0	0	0	0	0	0000216877	0001361658	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.888	-0.730	-0.160	1.17	3.05	0000844887	0001617406	0001712189
9	EconomicCapitalRatio	-0.969	-0.811	-0.240	1.09	2.97	0000844887	0001617406	0001712189

2024

Logs

error	9 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000216877 0000216877 0001295810 0001295810 0001712189 0001712189 0000891482 0000891482 0001807616
warning	27 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001061937 0000789570 0000789570 0000906553 0000906553 0000921738 0000921738 0001046311 0001046311 0001048286 0001048286 0001174922 0001174922 0001300514 0001300514 0001468174 0001468174 0001590895 0001590895 0001617406 0001617406 0001674168 0001674168 0000907242 0001653653 0001747079
warning	5 × The stock price does not exist	industry.us_generic	0000844887 0000911147 0001611046 0001692412 0001819395
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000216877 0001295810 0001712189 0000891482
warning	2 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000216877 0001061937
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
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,306,120	2,874,644,902	21,143,030,710	118,805,326,732	134,541,080,000	0000844887	0000906553	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-1.58	-0.995	0.425	1.73	2.11	0000844887	0001653653	0000906553
9	EconomicCapitalRatio	0.0332	0.152	0.760	1.75	2.12	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.365	-0.178	-0.0631	0.414	0.439	0001590584	0001046311	0001617406
1	AssetsNonCurrent	-0.289	-0.0948	-0.0227	0.161	0.239	0001590584	0001300514	0001585689
2	AssetsCurrent	-0.0471	-0.0337	-0.00626	0.135	0.145	0001590584	0000844887	0001674168
3	IntangibleAssets	-0.273	-0.109	-0.0151	0.115	0.140	0001590584	0000844887	0001747079
4	remainder_Assets	-0.266	-0.176	-0.00999	0.139	0.148	0001590584	0001692412	0001674168
5	LongTermLiabilities	-0.581	-0.291	0.0324	0.131	0.144	0001616000	0000789570	0000906553
6	LiabilitiesCurrent	-0.00457	0.00393	0.114	0.265	0.487	0000844887	0001174922	0000906553
7	remainder_Liabilities	-0.359	-0.290	-0.0517	0.916	1.10	0001361658	0001747079	0000906553
8	GeneralAndAdministrativeExpense	-0.474	-0.229	0.00921	0.234	0.415	0000907242	0001590895	0001048286
9	DepreciationDepletionAndAmortization	-0.353	-0.204	-0.0141	0.143	0.317	0001590584	0001617406	0001048286
10	CostOfGoodsAndServicesSold	-7.67	-1.01	0.142	0.395	0.400	0001590584	0001361658	0000906553
11	OperatingExpenses	-0.962	-0.693	0.119	0.366	0.387	0001692412	0001174922	0000906553
12	remainder_Expenses	-3.21	-1.21	-0.200	0.470	0.505	0001048286	0001617406	0001692412
13	remainder_Revenues	-0.235	-0.175	0.0891	0.992	1.02	0000844887	0001653653	0001048286
14	remainder_NetIncome	-0.266	-0.147	0.0421	0.158	0.590	0001590895	0001590584	0001468174
15	remainder_ComprehensiveNetIncome	-0.228	-0.0483	0.00984	0.0405	0.0455	0001590584	0001674168	0000907242

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.662	-0.112	0.00325	0.145	0.209	0001590584	0001692412	0001617406
1	Liabilities	-0.163	-0.120	-0.00173	1.04	1.28	0001722684	0001674168	0000906553
2	Expenses	-2.91	-1.13	-0.0375	0.227	0.319	0001590584	0001361658	0001653653
3	Revenues	-0.235	-0.175	0.0891	0.992	1.02	0000844887	0001653653	0001048286
4	StockholdersEquity	-0.232	-0.180	0.0509	0.649	1.02	0000844887	0001590895	0000906553
5	NetIncome	-0.486	-0.249	0.114	0.535	0.602	0001590584	0001174922	0000906553
6	ComprehensiveNetIncome	-0.673	-0.246	0.109	0.570	0.639	0001590584	0001174922	0000906553
7	BaseVar	0	0	0	0	0	0000789570	0001468174	0000789570
8	EconomicCapitalRatiobeforeLimitedLiability	-0.671	-0.553	0.0556	1.05	1.41	0000844887	0001653653	0000906553
9	EconomicCapitalRatio	-0.729	-0.611	-0.00245	0.989	1.35	0000844887	0001653653	0000906553

2025

Logs

error	8 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000907242 0000907242 0001295810 0001295810 0001712189 0001712189 0000891482 0000891482
warning	12 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0000789570 0000906553 0000921738 0001046311 0001048286 0001174922 0001300514 0001468174 0001590895 0001617406 0001674168
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000907242 0001295810 0001712189 0000891482
warning	2 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0000216877
warning	1 × The stock price does not exist	industry.us_generic	0001611046
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0001611046
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	44,940	15,760,847	1,766,216,300	11,807,250,000	14,358,000,000	0001611046	0001048286	0001590895
1	AssetsNonCurrent	0	0	594,129,200	14,281,662,700	23,851,254,000	0000216877	0001722684	0000789570
2	AssetsCurrent	616,427	13,274,771	967,806,390	4,357,402,800	4,832,000,000	0001611046	0000921738	0001300514
3	IntangibleAssets	0	0	1,281,030,964	14,666,850,000	19,243,000,000	0000216877	0001046311	0001048286
4	remainder_Assets	-5,765,000,000	-288,292,693	464,544,330	2,236,600,000	3,597,000,000	0001585689	0000789570	0001674168
5	LongTermLiabilities	0	0	0	1,578,986,950	4,545,000,000	0000216877	0001048286	0001674168
6	LiabilitiesCurrent	0	0	487,220,947	4,702,500,000	8,398,000,000	0001061937	0001722684	0001048286
7	remainder_Liabilities	0	0	5,089,763,200	26,144,268,050	34,585,361,000	0000906553	0001674168	0000789570
8	GeneralAndAdministrativeExpense	0	1,239,472	361,100,680	2,073,576,900	4,877,538,000	0000216877	0001585689	0000789570
9	DepreciationDepletionAndAmortization	0	0	225,182,400	1,419,350,000	1,464,000,000	0001048286	0001674168	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	566,533,300	748,578,000	0000906553	0000921738	0001616000
11	OperatingExpenses	0	0	0	1,066,850,000	1,824,000,000	0000789570	0001611046	0001361658
12	remainder_Expenses	-192,422,000	-9,621,100	3,745,198,994	10,645,500,000	22,777,000,000	0000911147	0001174922	0001048286
13	remainder_Revenues	1,294,549	9,642,627	4,571,309,021	17,970,098,850	26,186,000,000	0001611046	0001674168	0001048286
14	remainder_NetIncome	-2,306,000,000	-733,768,050	4,684,025	236,763,250	1,581,265,000	0001590895	0001046311	0000906553
15	remainder_ComprehensiveNetIncome	-110,000,000	-80,775,150	444,683	132,200,000	421,000,000	0001300514	0001046311	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	679,447	29,036,522	9,625,790,300	32,125,739,300	41,373,786,000	0001611046	0001674168	0000789570
1	Liabilities	729,388	4,341,869	7,032,207,500	28,460,223,400	38,097,468,000	0001611046	0001361658	0000789570
2	Expenses	2,531,493	9,216,175	4,406,341,331	16,729,852,400	23,647,000,000	0001611046	0001674168	0001048286
3	Revenues	1,294,549	9,642,627	4,571,309,021	17,970,098,850	26,186,000,000	0001611046	0001674168	0001048286
4	StockholdersEquity	-5,346,000,000	-1,247,015,050	1,312,255,780	7,352,500,000	19,142,000,000	0001585689	0001674168	0001048286
5	NetIncome	-845,300,000	-457,415,000	146,178,600	1,902,750,000	2,601,000,000	0000921738	0001722684	0001048286
6	ComprehensiveNetIncome	-781,400,000	-514,070,000	123,710,900	1,903,018,750	3,022,000,000	0000921738	0001722684	0001048286
7	BaseVar	10,043,725	63,251,111	31,028,786,465	124,329,665,852	139,733,720,000	0001611046	0001674168	0001048286
8	EconomicCapitalRatiobeforeLimitedLiability	-8.78	-0.684	0.224	1.76	3.55	0001611046	0001468174	0000906553
9	EconomicCapitalRatio	0.000000000000000000000000000000000234	0.356	0.605	1.78	3.55	0001611046	0001468174	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.199	-0.198	0.00878	0.321	0.455	0001585689	0001048286	0001616000
1	AssetsNonCurrent	-0.130	-0.0946	-0.00489	0.170	0.205	0001590584	0001611046	0001585689
2	AssetsCurrent	-0.0675	-0.0623	-0.00854	0.113	0.189	0001617406	0000921738	0000906553
3	IntangibleAssets	-0.241	-0.149	-0.0178	0.138	0.152	0000906553	0000911147	0001468174
4	remainder_Assets	-0.188	-0.102	0.000490	0.154	0.205	0001585689	0001468174	0001722684
5	LongTermLiabilities	-0.656	-0.320	0.0418	0.175	0.275	0001616000	0001174922	0000906553
6	LiabilitiesCurrent	-0.369	-0.117	0.000505	0.0828	0.105	0001048286	0000921738	0001061937
7	remainder_Liabilities	-0.378	-0.313	-0.0222	1.02	1.91	0001361658	0000921738	0000906553
8	GeneralAndAdministrativeExpense	-0.261	-0.201	0.116	0.340	0.524	0001361658	0001722684	0001048286
9	DepreciationDepletionAndAmortization	-0.311	-0.152	0.00161	0.147	0.335	0001590584	0000921738	0001048286
10	CostOfGoodsAndServicesSold	-4.84	-1.23	0.149	0.580	0.651	0001590584	0001585689	0000906553
11	OperatingExpenses	-1.82	-1.26	0.146	0.647	0.740	0000216877	0001617406	0000906553
12	remainder_Expenses	-3.34	-1.54	-0.210	0.662	0.892	0001048286	0001046311	0000216877
13	remainder_Revenues	-0.244	-0.226	0.000266	0.522	1.04	0001617406	0001174922	0001048286
14	remainder_NetIncome	-0.323	-0.201	0.000625	0.177	1.97	0001590895	0001361658	0000906553
15	remainder_ComprehensiveNetIncome	-0.0309	-0.0216	-0.00251	0.0951	0.135	0001174922	0001061937	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.385	-0.146	0.0127	0.187	0.277	0001590584	0001048286	0000906553
1	Liabilities	-0.292	-0.253	-0.0319	0.990	1.99	0001722684	0000911147	0000906553
2	Expenses	-1.29	-0.814	0.0777	0.236	0.278	0001590584	0001174922	0001722684
3	Revenues	-0.244	-0.226	0.000266	0.522	1.04	0001617406	0001174922	0001048286
4	StockholdersEquity	-0.332	-0.268	-0.0345	0.701	0.773	0001585689	0000911147	0000906553
5	NetIncome	-0.576	-0.302	0.0578	0.556	2.16	0001611046	0001616000	0000906553
6	ComprehensiveNetIncome	-0.592	-0.233	0.0505	0.626	2.16	0001611046	0001174922	0000906553
7	BaseVar	0	0	0	0	0	0000216877	0001174922	0000216877
8	EconomicCapitalRatiobeforeLimitedLiability	-0.484	-0.128	0.121	1.30	3.06	0001611046	0001468174	0000906553
9	EconomicCapitalRatio	-0.834	-0.478	-0.229	0.950	2.71	0001611046	0001468174	0000906553

Estimates

Parameter	Value	Min	Max
PresentValueFactor	4.84	1.0	15.0
BalanceFactor	0.8	0.5	5.0
OCIFactor	1.0	0.5	1.0
HiddenReservesFactor	0.0	0.0	1.0
LLPO_stddev	0.71	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
				2025	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
				2025	37.0300	1.0000	37.0300	273,506,440.0	10,127,943,473.20	0.2549
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	nan	2015	nan	nan	nan	36,297,576.0	nan	nan
				2016	nan	nan	nan	36,297,576.0	nan	nan
				2017	nan	nan	nan	36,297,576.0	nan	nan
				2018	nan	nan	nan	36,297,576.0	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	36,297,576.0	nan	nan
				2022	nan	nan	nan	36,297,576.0	nan	nan
				2023	nan	nan	nan	36,297,576.0	nan	nan
				2024	nan	nan	nan	39,052,472.0	nan	nan
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.3100	1.0000	6.3100	86,588,933.0	546,376,167.23	0.1543
				2017	33.0300	1.0000	33.0300	112,473,050.0	3,714,984,841.50	1.4670
				2018	19.5200	1.0000	19.5200	112,205,979.0	2,190,260,710.08	0.7035
				2019	29.0100	1.0000	29.0100	111,165,446.0	3,224,909,588.46	0.8949
				2020	40.7400	1.0000	40.7400	111,540,103.0	4,544,143,796.22	1.2832
				2021	61.8700	1.0000	61.8700	112,345,594.0	6,950,821,900.78	2.0499
				2022	53.2200	1.0000	53.2200	104,375,084.0	5,554,841,970.48	1.6106
				2023	60.8000	1.0000	60.8000	97,862,123.0	5,950,017,078.40	1.7322
				2024	71.0400	1.0000	71.0400	88,389,119.0	6,279,163,013.76	1.7904
				2025	85.5600	1.0000	85.5600	78,122,443.0	6,684,156,223.08	1.7698
0000907242	Monarch Casino Resort INC	Monarch	MCRI	2011	9.1800	1.0000	9.1800	16,138,158.0	148,148,290.44	1.2960
				2012	9.0500	1.0000	9.0500	16,141,492.0	146,080,502.60	0.8219
				2013	17.8100	1.0000	17.8100	16,476,435.0	293,445,307.35	1.8054
				2014	14.7900	1.0000	14.7900	16,803,129.0	248,518,277.91	1.5168
				2015	20.3500	1.0000	20.3500	16,981,355.0	345,570,574.25	1.9992
				2016	22.8100	1.0000	22.8100	17,368,559.0	396,176,830.79	2.2225
				2017	41.3500	1.0000	41.3500	17,700,513.0	731,916,212.55	3.6808
				2018	33.3800	1.0000	33.3800	17,894,057.0	597,303,622.66	1.9611
				2019	43.2000	1.0000	43.2000	18,082,135.0	781,148,232.00	1.7741
				2020	52.0100	1.0000	52.0100	18,263,405.0	949,879,694.05	1.9472
				2021	65.7000	1.0000	65.7000	18,736,377.0	1,230,979,968.90	2.6391
				2022	68.9400	1.0000	68.9400	18,961,643.0	1,307,215,668.42	3.0869
				2023	66.6900	1.0000	66.6900	19,067,522.0	1,271,613,042.18	2.9968
				2024	77.2500	1.0000	77.2500	18,389,057.0	1,420,554,653.25	3.2829
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
				2025	1.3400	1.0000	1.3400	29,445,056.0	39,456,375.04	0.0342
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
				2025	14.7200	1.0000	14.7200	133,249,972.0	1,961,439,587.84	0.1469
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.3700	1.0000	24.3700	nan	nan	nan
				2011	24.4800	1.0000	24.4800	59,166,765.0	1,448,402,407.20	3.1455
				2012	28.9500	1.0000	28.9500	58,053,476.0	1,680,648,130.20	2.1405
				2015	45.7800	1.0000	45.7800	56,622,700.0	2,592,187,206.00	2.8330
				2016	51.6300	1.0000	51.6300	56,096,987.0	2,896,287,438.81	2.8730
				2017	72.2500	1.0000	72.2500	56,593,820.0	4,088,903,495.00	3.9559
				2018	66.3600	1.0000	66.3600	55,980,838.0	3,714,888,409.68	3.0197
				2019	98.5600	1.0000	98.5600	55,730,708.0	5,492,818,580.48	3.9277
				2020	99.4100	1.0000	99.4100	55,458,082.0	5,513,087,931.62	3.4670
				2021	147.2900	1.0000	147.2900	55,629,330.0	8,193,644,015.70	4.5549
				2022	108.5500	1.0000	108.5500	53,299,203.0	5,785,628,485.65	2.8573
				2023	110.2600	1.0000	110.2600	49,798,586.0	5,490,792,092.36	2.3101
				2024	138.9200	1.0000	138.9200	46,907,321.0	6,516,365,033.32	2.5523
				2025	95.0500	1.0000	95.0500	46,272,618.0	4,398,212,340.90	1.5555
0001048286	Marriott International INC MD	Marriot	MAR	2009	22.2500	1.0610	23.6100	nan	nan	nan
				2010	33.4900	1.0610	35.5300	nan	nan	nan
				2011	25.0900	1.0000	25.0900	335,126,113.0	8,408,314,175.17	1.9856
				2012	32.4100	1.0000	32.4100	315,540,075.0	10,226,653,830.75	2.2438
				2013	42.9100	1.0000	42.9100	299,538,446.0	12,853,194,717.86	2.7149
				2014	70.1800	1.0000	70.1800	283,360,811.0	19,886,261,715.98	4.0073
				2015	61.9200	1.0000	61.9200	257,128,905.0	15,921,421,797.60	3.4183
				2016	77.5700	1.0000	77.5700	390,479,820.0	30,289,519,637.40	2.0684
				2017	125.0300	1.0000	125.0300	364,581,283.0	45,583,597,813.49	3.0433
				2018	100.6700	1.0000	100.6700	341,130,300.0	34,341,587,301.00	2.2793
				2019	145.0800	1.0000	145.0800	326,937,219.0	47,432,051,732.52	2.9900
				2020	123.9600	1.0000	123.9600	324,331,716.0	40,204,159,515.36	2.6404
				2021	158.8400	1.0000	158.8400	325,683,100.0	51,731,503,604.00	3.2373
				2022	143.9800	1.0000	143.9800	316,539,613.0	45,575,373,479.74	2.8348
				2023	217.6300	1.0000	217.6300	293,691,348.0	63,916,048,065.24	3.8232
				2024	280.3600	1.0000	280.3600	277,893,432.0	77,910,202,595.52	4.4736
				2025	313.2400	1.0000	313.2400	268,351,795.0	84,058,516,265.80	4.6780
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
				2025	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.4500	1.0000	71.4500	nan	nan	nan
				2011	79.0500	1.0000	79.0500	124,957,158.0	9,877,863,339.90	1.7068
				2012	89.3800	1.0000	89.3800	100,581,636.0	8,989,986,625.68	1.2444
				2013	155.7700	1.0000	155.7700	101,155,304.0	15,756,961,704.08	1.8960
				2014	128.6000	1.0000	128.6000	101,349,797.0	13,033,583,894.20	1.4551
				2015	60.1600	1.0000	60.1600	101,568,512.0	6,110,361,681.92	0.5813
				2016	79.3300	1.0000	79.3300	101,740,911.0	8,071,106,469.63	0.6826
				2017	153.9000	1.0000	153.9000	102,782,543.0	15,818,233,367.70	1.3027
				2018	91.5100	1.0000	91.5100	108,738,518.0	9,950,661,782.18	0.8084
				2019	134.0800	1.0000	134.0800	107,354,606.0	14,394,105,572.48	1.0988
				2020	110.9100	1.0000	110.9100	107,870,602.0	11,963,928,467.82	0.8402
				2021	83.4200	1.0000	83.4200	115,657,896.0	9,648,181,684.32	0.7451
				2022	79.5400	1.0000	79.5400	113,313,591.0	9,012,963,028.14	0.6332
				2023	88.6300	1.0000	88.6300	112,945,993.0	10,010,403,359.59	0.6882
				2024	87.6400	1.0000	87.6400	109,814,972.0	9,624,184,146.08	0.7149
				2025	124.7200	1.0000	124.7200	103,974,479.0	12,967,697,020.88	0.9518
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
0001295810	Sunstone Hotel Investors Inc	Sunston	SHO	2011	4.9000	1.0000	4.9000	118,672,242.0	581,493,985.80	0.2436
				2012	6.6700	1.0000	6.6700	136,777,430.0	912,305,458.10	0.3922
				2013	8.4800	1.0000	8.4800	182,870,062.0	1,550,738,125.76	0.6120
				2014	10.9600	1.0000	10.9600	205,396,771.0	2,251,148,610.16	0.8070
				2015	9.0800	1.0000	9.0800	208,590,736.0	1,894,003,882.88	0.7049
				2016	11.5400	1.0000	11.5400	216,509,093.0	2,498,514,933.22	1.0103
				2017	13.1200	1.0000	13.1200	225,321,660.0	2,956,220,179.20	1.1516
				2018	10.8600	1.0000	10.8600	228,247,062.0	2,478,763,093.32	0.9467
				2019	12.1200	1.0000	12.1200	224,855,351.0	2,725,246,854.12	1.0446
				2020	9.9300	1.0000	9.9300	215,635,550.0	2,141,261,011.50	1.1028
				2021	10.3500	1.0000	10.3500	219,333,783.0	2,270,104,654.05	1.1814
				2022	8.6300	1.0000	8.6300	210,399,520.0	1,815,747,857.60	0.8897
				2023	9.9100	1.0000	9.9100	205,444,026.0	2,035,950,297.66	0.9859
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	28.9700	1.0000	28.9700	nan	nan	nan
				2011	27.0800	1.0000	27.0800	732,718,517.0	19,842,017,440.36	1.1320
				2012	31.8200	1.0000	31.8200	823,449,212.0	26,202,153,925.84	1.4693
				2016	43.8400	1.0000	43.8400	794,793,918.0	34,843,765,365.12	2.0839
				2017	59.4000	1.0000	59.4000	790,480,010.0	46,954,512,594.00	2.7834
				2018	45.3100	1.0000	45.3100	783,554,277.0	35,502,844,290.87	1.8515
				2019	64.4800	1.0000	64.4800	768,036,535.0	49,522,995,776.80	2.4828
				2020	54.5100	1.0000	54.5100	763,828,127.0	41,636,271,202.77	2.1869
				2021	35.5400	1.0000	35.5400	763,989,752.0	27,152,195,786.08	1.4339
				2022	44.3600	1.0000	44.3600	764,166,260.0	33,898,415,293.60	1.6774
				2023	46.7600	1.0000	46.7600	764,490,874.0	35,747,593,268.24	1.8121
				2024	50.4100	1.0000	50.4100	725,026,178.0	36,548,569,632.98	1.9149
				2025	65.9100	1.0000	65.9100	676,134,487.0	44,564,024,038.17	2.1269
0001313536	Sotherly Hotels LP	Sotherl	SOHOB	2013	nan	1.0000	nan	nan	nan	nan
				2014	nan	1.0000	nan	nan	nan	nan
				2015	nan	1.0000	nan	nan	nan	nan
				2016	14.9600	1.0000	14.9600	nan	nan	nan
				2017	16.5200	1.0000	16.5200	nan	nan	nan
				2018	16.6200	1.0000	16.6200	nan	nan	nan
				2019	19.6300	1.0000	19.6300	nan	nan	nan
				2020	9.1200	1.0000	9.1200	nan	nan	nan
				2021	12.3800	1.0000	12.3800	nan	nan	nan
				2022	16.1800	1.0000	16.1800	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.5900	2.2150	19.0300	nan	nan	nan
				2011	10.6100	2.2150	23.5000	154,017,892.0	3,619,420,462.00	0.4578
				2012	15.4800	2.2150	34.2900	140,266,725.0	4,809,746,000.25	0.5659
				2013	21.7100	2.2150	48.0900	130,306,798.0	6,266,453,915.82	0.7019
				2014	25.9300	2.2150	57.4300	123,262,818.0	7,078,983,637.74	0.7823
				2015	22.5600	2.2150	49.9700	116,106,000.0	5,801,816,820.00	0.6278
				2016	24.6200	2.2150	54.5300	107,776,539.0	5,877,054,671.67	0.6213
				2017	37.1500	2.2150	82.2900	101,326,244.0	8,338,136,618.76	0.8370
				2018	26.9000	1.0000	26.9000	97,452,743.0	2,621,478,786.70	0.3522
				2019	40.2300	1.0000	40.2300	90,704,218.0	3,649,030,690.14	0.4730
				2020	35.2200	1.0000	35.2200	85,861,306.0	3,024,035,197.32	0.3735
				2021	45.5200	1.0000	45.5200	86,356,226.0	3,930,935,407.52	0.5628
				2022	31.2900	1.0000	31.2900	81,280,625.0	2,543,270,756.25	0.3528
				2023	36.5000	1.0000	36.5000	72,420,073.0	2,643,332,664.50	0.3673
				2024	48.2200	1.0000	48.2200	68,405,120.0	3,298,494,886.40	0.4597
				2025	71.2600	1.0000	71.2600	64,325,188.0	4,583,812,896.88	0.6322
0001468174	Hyatt Hotels Corp	Hyatt H	H	2011	36.3100	1.0000	36.3100	44,680,334.0	1,622,342,927.54	0.3186
				2012	37.0600	1.0000	37.0600	45,387,810.0	1,682,072,238.60	0.3219
				2014	58.1100	1.0000	58.1100	39,277,514.0	2,282,416,338.54	0.3917
				2015	46.5700	1.0000	46.5700	29,197,002.0	1,359,704,383.14	0.2429
				2016	54.5800	1.0000	54.5800	23,611,575.0	1,288,719,763.50	0.2224
				2017	70.4400	1.0000	70.4400	47,464,707.0	3,343,413,961.08	0.5666
				2018	65.2900	1.0000	65.2900	42,768,452.0	2,792,352,231.08	0.4810
				2019	88.2200	1.0000	88.2200	36,582,951.0	3,227,347,937.22	0.5016
				2020	71.9700	1.0000	71.9700	38,479,041.0	2,769,336,580.77	0.3682
				2021	93.0800	1.0000	93.0800	50,301,183.0	4,682,034,113.64	0.4327
				2022	89.6100	1.0000	89.6100	48,101,088.0	4,310,338,495.68	0.4120
				2023	129.3200	1.0000	129.3200	44,221,190.0	5,718,684,290.80	0.5176
				2024	157.0900	1.0000	157.0900	42,289,812.0	6,643,306,567.08	0.5822
				2025	164.5000	1.0000	164.5000	41,819,241.0	6,879,265,144.50	0.5636
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
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
0001575879	Caesars Acquisition Co	Caesars	nan	2016	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.6100	0.4870	24.6500	984,617,365.0	24,270,818,047.25	1.0211
				2015	42.4700	0.4870	20.6800	987,451,862.0	20,420,504,506.16	0.8980
				2016	54.2000	0.4870	26.4000	989,783,195.0	26,130,276,348.00	1.1219
				2020	105.3300	1.0000	105.3300	277,446,309.0	29,223,419,726.97	1.6701
				2021	152.8600	1.0000	152.8600	278,721,682.0	42,605,396,310.52	2.6879
				2022	125.2000	1.0000	125.2000	270,456,017.0	33,861,093,328.40	2.1082
				2023	180.3600	1.0000	180.3600	256,440,305.0	46,251,573,409.80	2.7905
				2024	248.9900	1.0000	248.9900	243,779,806.0	60,698,733,895.94	3.3049
				2025	292.1700	1.0000	292.1700	232,435,166.0	67,910,582,450.22	3.4920
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
				2025	23.1000	1.0000	23.1000	11,515,223.0	266,001,651.30	0.6817
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
				2025	24.2000	1.0000	24.2000	204,107,943.0	4,939,412,220.60	0.1658
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
0001611046	Modulink Inc	Modulin	MDLK	2016	nan	nan	nan	nan	nan	nan
0001611046	Modulink Inc	Modulin	MDLK	2025	nan	nan	nan	3,969,933,920.0	nan	nan
0001616000	Xenia Hotels Resorts Inc	Xenia H	XHR	2017	16.7800	1.0000	16.7800	106,729,984.0	1,790,929,131.52	0.7810
				2018	13.9000	1.0000	13.9000	112,559,248.0	1,564,573,547.20	0.6971
				2019	18.4200	1.0000	18.4200	112,641,568.0	2,074,857,682.56	0.8733
				2020	13.1500	1.0000	13.1500	113,730,716.0	1,495,558,915.40	0.6512
				2021	15.8100	1.0000	15.8100	114,209,134.0	1,805,646,408.54	0.7623
				2022	11.6300	1.0000	11.6300	113,847,779.0	1,324,049,669.77	0.5634
				2023	12.4600	1.0000	12.4600	105,201,059.0	1,310,805,195.14	0.5842
				2024	14.2200	1.0000	14.2200	101,816,814.0	1,447,835,095.08	0.6606
				2025	14.4600	1.0000	14.4600	94,805,748.0	1,370,891,116.08	0.6185
0001617406	Park Hotels Resorts Inc	Park Ho	PK	2020	11.7900	1.0000	11.7900	235,612,787.0	2,777,874,758.73	0.3401
				2021	13.0700	1.0000	13.0700	236,479,179.0	3,090,782,869.53	0.4097
				2022	8.1500	1.0000	8.1500	224,843,229.0	1,832,472,316.35	0.2415
				2023	12.2400	1.0000	12.2400	209,983,724.0	2,570,200,781.76	0.3412
				2024	12.6500	1.0000	12.6500	206,404,619.0	2,611,018,430.35	0.3547
				2025	10.3300	1.0000	10.3300	199,898,278.0	2,064,949,211.74	0.3351
0001653653	Red Rock Resorts Inc	Red Roc	RRR	2016	17.4600	1.0000	17.4600	41,468,746.0	724,044,305.16	0.2257
				2017	26.0600	1.0000	26.0600	68,728,266.0	1,791,058,611.96	0.5427
				2019	18.9400	1.0000	18.9400	70,321,959.0	1,331,897,903.46	0.3577
				2020	19.7200	1.0000	19.7200	71,216,902.0	1,404,397,307.44	0.4086
				2021	44.6000	1.0000	44.6000	68,696,282.0	3,063,854,177.20	0.9835
				2022	35.7100	1.0000	35.7100	58,000,419.0	2,071,194,962.49	0.6220
				2023	48.1600	1.0000	48.1600	58,398,749.0	2,812,483,751.84	0.7339
				2024	43.5100	1.0000	43.5100	59,633,233.0	2,594,641,967.83	0.6666
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
				2025	45.0700	1.0000	45.0700	85,543,093.0	3,855,427,201.51	0.3564
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	81.5000	1.0000	81.5000	93,177,853.0	7,593,995,019.50	2.0390
				2022	65.5400	1.0000	65.5400	88,324,241.0	5,788,770,755.14	1.5894
				2023	76.2500	1.0000	76.2500	82,961,907.0	6,325,845,408.75	1.7284
				2024	98.6400	1.0000	98.6400	77,789,308.0	7,673,137,341.12	1.9686
				2025	76.3200	1.0000	76.3200	75,551,945.0	5,766,124,442.40	1.4606
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	nan	2021	nan	nan	nan	45,000,000.0	nan	nan
				2022	nan	nan	nan	218,058,524.0	nan	nan
				2023	nan	nan	nan	11,064,738.0	nan	nan
				2024	nan	nan	nan	11,585,625.0	nan	nan

QA: us_hotels 2009-2025

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