QA: us_hotels 2009-2023

Ranks across the years

	name	name_short	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	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	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
0001712189	Target Hospitality Corp	Target	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	3	3	1	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	226.657500	132.502570	193.337490	279.897630	495.685760	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	0	-2	0
0000906553	BOYD Gaming CORP	BOYD Ga	NaN	NaN	NaN	31	NaN	NaN	NaN	NaN	3	5	4	4	2	2	2	NaN	NaN	NaN	-46.284925	NaN	NaN	NaN	NaN	171.154510	146.939070	151.002060	100.631530	207.865030	237.398120	234.068150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-1	0	-2	0	0
0000907242	Monarch Casino Resort INC	Monarch	NaN	NaN	8	8	2	4	2	2	2	6	10	7	4	3	3	NaN	NaN	114.499900	89.354267	142.958630	133.224700	161.145830	182.353570	178.478580	142.511330	101.954160	85.557510	162.322140	222.640490	210.313300	NaN	NaN	0	-6	2	-2	0	0	4	4	-3	-3	-1	0
0001048286	Marriott International INC MD	Marriot	1	2	13	4	1	2	3	4	4	4	5	6	6	6	4	112.185730	130.858590	80.338214	136.398680	146.544510	147.974010	143.489210	115.225250	165.066430	147.688120	136.131240	89.155683	122.517770	156.343600	197.104680	1	11	-9	-3	1	1	1	0	0	1	1	0	0	-2
0000789570	MGM Resorts International	MGM Res	NaN	8	1	17	NaN	8	9	NaN	1	7	2	5	5	5	5	NaN	38.649151	266.416580	47.736284	NaN	106.719880	101.760120	NaN	193.612580	137.525220	190.162310	97.099256	158.858460	157.781760	160.516520	NaN	-7	16	NaN	NaN	1	NaN	NaN	6	-5	3	0	0	0
0000216877	Pismo Coast Village INC	Pismo C	NaN	NaN	10	6	3	5	5	NaN	NaN	1	3	2	1	4	6	NaN	NaN	94.144810	95.343894	110.929210	120.539540	138.306630	NaN	NaN	205.662810	184.474880	144.985740	214.551870	195.182560	155.800350	NaN	NaN	-4	-3	2	0	NaN	NaN	NaN	2	-1	-1	3	2
0001295810	Sunstone Hotel Investors Inc	Sunston	NaN	NaN	16	15	10	12	4	7	9	2	9	22	8	8	7	NaN	NaN	64.934559	64.059874	69.131330	75.562345	142.871000	104.747570	110.875040	200.364410	107.731960	-54.235760	95.892154	102.533680	139.388630	NaN	NaN	-1	-5	2	-8	3	2	-7	7	13	-14	0	-1
0001590584	Civeo Corp	Civeo C	NaN	NaN	NaN	NaN	NaN	35	33	26	30	25	23	26	13	20	8	NaN	NaN	NaN	NaN	NaN	-102.166420	-186.208180	-35.188262	-15.933479	-53.938894	5.753058	-86.772595	39.206665	24.244665	117.267120	NaN	NaN	NaN	NaN	NaN	-2	-7	4	-5	-2	3	-13	7	-12
0001061937	HOST Hotels Resorts L P	HOST Ho	NaN	NaN	NaN	NaN	7	7	8	3	10	3	6	12	11	9	9	NaN	NaN	NaN	NaN	80.312940	117.500390	103.201250	130.578820	109.927240	150.952080	131.217990	-0.136256	52.017648	101.967160	109.417670	NaN	NaN	NaN	NaN	0	1	-5	7	-7	3	6	-1	-2	0
0001046311	Choice Hotels International INC DE	Choice	NaN	1	3	18	NaN	NaN	17	11	16	11	11	8	7	7	10	NaN	143.466110	146.508590	47.559453	NaN	NaN	55.048108	64.432636	57.146756	99.155353	99.264187	29.469618	111.691310	108.394270	69.268898	NaN	2	15	NaN	NaN	NaN	-6	5	-5	0	-3	-1	0	3
0001722684	Wyndham Hotels Resorts INC	Wyndham	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	10	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	68.724661	89.634816	61.207104	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	1
0001300514	LAS Vegas Sands CORP	LAS Veg	NaN	5	9	7	NaN	NaN	NaN	8	5	10	8	20	27	11	12	NaN	65.761482	106.802010	95.058190	NaN	NaN	NaN	93.456372	142.449210	102.940730	109.929110	-40.960710	-24.897386	70.595418	55.142046	NaN	4	-2	NaN	NaN	NaN	NaN	-3	5	-2	12	7	-16	1
0001616000	Xenia Hotels Resorts Inc	Xenia H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	9	12	11	20	13	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	81.012949	115.067250	64.615528	2.455020	9.011724	61.389090	48.910720	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	3	-1	9	-7	0
0001692412	Playa Hotels Resorts N V	Playa H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	18	18	25	24	17	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.261678	42.752578	24.099909	-70.167313	-1.468770	52.656660	47.939916	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	0	7	-1	-7	-3
0001617406	Park Hotels Resorts Inc	Park Ho	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	23	15	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-67.529116	4.731022	54.706875	44.589250	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-8	0
0001674168	Hilton Grand Vacations Inc	Hilton	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	12	13	18	16	14	16	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	114.432940	94.933333	63.442377	-33.568375	36.448817	58.103630	44.200983	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	1	5	-2	-2	2
0001468174	Hyatt Hotels Corp	Hyatt H	NaN	NaN	11	9	NaN	9	16	10	12	8	7	17	21	16	17	NaN	NaN	82.888671	81.926117	NaN	85.168426	58.148968	66.243313	80.088283	135.177360	118.906820	-26.081627	8.097782	53.328554	39.877551	NaN	NaN	-2	NaN	NaN	7	-6	2	-4	-1	10	4	-5	1
0001653653	Red Rock Resorts Inc	Red Roc	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	25	NaN	21	13	12	19	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33.359869	20.435809	NaN	14.488573	-14.631384	50.047410	39.458076	33.485184	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN	-8	-1	7	-1
0001585689	Hilton Worldwide Holdings Inc	Hilton	NaN	NaN	NaN	NaN	NaN	22	18	19	NaN	NaN	NaN	21	19	18	19	NaN	NaN	NaN	NaN	NaN	22.801330	53.568171	21.868679	NaN	NaN	NaN	-43.776089	15.681587	46.935434	31.947691	NaN	NaN	NaN	NaN	NaN	-4	1	NaN	NaN	NaN	NaN	-2	-1	1
0001590895	Caesars Entertainment Inc	Caesars	NaN	NaN	NaN	NaN	NaN	27	15	17	21	21	17	15	26	26	20	NaN	NaN	NaN	NaN	NaN	0.865220	76.843300	32.636247	37.564741	24.993446	26.105173	-21.098441	-8.590008	-8.074846	27.133716	NaN	NaN	NaN	NaN	NaN	-12	2	4	0	-4	-2	11	0	-6
0001174922	WYNN Resorts LTD	WYNN Re	NaN	4	7	19	12	14	26	22	19	19	20	27	29	27	21	NaN	67.941484	117.572610	44.979656	56.126754	52.981201	11.734896	14.464045	44.954147	40.432958	14.498040	-94.726563	-41.252054	-27.393375	26.154454	NaN	3	12	-7	2	12	-4	-3	0	1	7	2	-2	-6
0001361658	Travel Leisure Co	Travel	NaN	7	19	16	13	17	20	14	14	16	16	16	18	22	22	NaN	56.670185	51.581637	47.850191	41.631741	40.045191	42.465610	43.512685	67.874417	48.337924	36.311601	-25.712733	16.516249	19.244833	26.040297	NaN	12	-3	-3	4	3	-6	0	2	0	0	2	4	0
0001747079	Bally s Corp	Bally s	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	10	22	28	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.339845	11.099025	5.406528	-63.967000	-2.639874	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	12	6	-5
0000921738	PENN Entertainment Inc	PENN En	NaN	9	12	13	28	32	30	23	17	23	22	14	17	21	24	NaN	25.476928	81.790636	65.922678	-246.642950	-54.621944	-9.332468	5.510276	55.776452	10.580917	12.266442	-16.985217	35.699107	21.033954	-3.072703	NaN	3	1	15	4	-2	-7	-6	6	-1	-8	3	4	3
0000891482	FULL House Resorts INC	FULL Ho	NaN	NaN	2	1	15	34	22	NaN	28	NaN	24	9	15	24	25	NaN	NaN	178.697170	202.786780	27.667585	-79.266807	28.810988	NaN	4.353151	NaN	2.394016	22.953084	37.317704	-3.689119	-15.329180	NaN	NaN	-1	14	19	-12	NaN	NaN	NaN	NaN	-15	6	9	1
0001819395	Sonder Holdings Inc	Sonder	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	29	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	89.612343	-64.392670	-127.650820	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	-3
0000844887	Diamondhead Casino CORP	Diamond	NaN	NaN	NaN	NaN	NaN	NaN	29	29	31	26	NaN	28	30	30	27	NaN	NaN	NaN	NaN	NaN	NaN	-9.113924	-135.816110	-140.679280	-63.949330	NaN	-204.940380	-159.402390	-177.024910	-148.982590	NaN	NaN	NaN	NaN	NaN	NaN	0	2	-5	NaN	NaN	2	0	-3
0000316206	Starwood Hotels Resorts Worldwide LLC	Starwoo	2	6	18	11	5	15	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8.049117	60.273995	59.633406	80.738272	91.259516	50.718683	39.566713	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	12	-7	-6	10	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000356213	Gold Merger Sub LLC	Gold Me	NaN	3	22	25	24	23	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	107.009870	21.480058	6.717812	-28.534618	10.342580	13.195592	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19	3	-1	-1	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001115836	Belmond Ltd	Belmond	NaN	10	24	20	14	29	28	13	20	24	NaN	NaN	NaN	NaN	NaN	NaN	24.367405	9.984856	38.804437	29.695285	-32.383993	2.489979	55.280157	41.995803	4.202599	NaN	NaN	NaN	NaN	NaN	NaN	14	-4	-6	15	-1	-15	7	4	NaN	NaN	NaN	NaN	NaN
0000834162	MTR Gaming Group INC	MTR Gam	NaN	NaN	28	27	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-48.734918	-3.801563	-7.941730	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000858339	Caesars Holdings INC	Caesars	NaN	NaN	26	30	27	36	1	30	NaN	NaN	26	NaN	NaN	NaN	NaN	NaN	NaN	-12.211605	-33.682224	-77.422382	-187.804140	350.297330	-150.362240	NaN	NaN	-25.260133	NaN	NaN	NaN	NaN	NaN	NaN	4	-3	9	-35	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000863015	ISLE OF Capri Casinos INC	ISLE OF	NaN	NaN	6	22	6	25	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	124.683150	26.524503	84.881218	6.784097	122.118150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	-16	19	-19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000911147	Century Casinos INC CO	Century	NaN	NaN	5	3	4	13	12	5	7	14	NaN	NaN	14	23	NaN	NaN	NaN	125.689600	143.046540	105.361840	65.369858	90.394117	107.374980	119.611090	55.690419	NaN	NaN	38.037932	13.324961	NaN	NaN	NaN	-2	1	9	-1	-7	2	7	NaN	NaN	NaN	9	NaN
0000912145	Ameristar Casinos INC	Amerist	NaN	NaN	4	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	125.819930	163.349230	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000918543	Castle Group INC	Castle	NaN	NaN	23	21	16	18	NaN	18	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11.462519	28.466660	12.107081	38.798417	NaN	27.906232	16.516958	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-5	2	NaN	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN
0001005276	Mohegan Tribal Gaming Authority	Mohegan	NaN	NaN	20	23	NaN	NaN	NaN	NaN	22	17	25	19	25	25	NaN	NaN	NaN	40.280866	25.004029	NaN	NaN	NaN	NaN	32.410188	47.320851	-1.096293	-37.389327	-2.480410	-7.222317	NaN	NaN	NaN	3	NaN	NaN	NaN	NaN	NaN	-5	8	-6	6	0	NaN
0001052595	Red Lion Hotels CORP	Red Lio	NaN	NaN	21	24	19	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34.569688	10.529769	-4.753065	76.501224	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-5	-8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001162556	Dover Downs Gaming Entertainment INC	Dover D	NaN	NaN	15	12	9	16	14	9	13	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69.812394	72.011311	73.086499	44.532790	84.761715	77.272475	73.132227	79.826468	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-3	7	-2	-5	4	0	NaN	NaN	NaN	NaN	NaN
0001180638	WYNN LAS Vegas LLC	WYNN LA	NaN	NaN	25	28	22	24	32	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3.879481	-25.334903	-17.315874	9.419917	-22.588669	-6.324036	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-6	2	8	-7	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001297735	American Casino Entertainment Properties LLC	America	NaN	NaN	17	14	11	10	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	61.255022	64.994709	65.004140	83.713758	92.905763	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-3	-1	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001342126	Morgans Hotel Group Co	Morgans	NaN	NaN	29	33	26	33	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-102.357400	-68.959621	-61.708634	-72.228274	-18.629494	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-7	7	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001476246	Tropicana Entertainment Inc	Tropica	NaN	NaN	14	NaN	NaN	1	7	6	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	76.845067	NaN	NaN	257.842290	103.796160	106.839990	132.653640	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	-1	0	NaN	NaN	NaN	NaN	NaN	NaN
0001485589	Nevada Property 1 LLC	Nevada	NaN	NaN	27	29	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-21.405666	-26.115549	-26.498145	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-6	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	-61.176126	NaN	-39.866616	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	26	17	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.946156	11.650469	28.843495	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001510130	Southern States SIGN Co	Souther	NaN	NaN	NaN	10	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	81.549135	-32.849850	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517007	Marina District Finance Company Inc	Marina	NaN	NaN	NaN	5	8	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	104.685850	74.222643	141.849060	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001313536	Sotherly Hotels LP	Sotherl	NaN	NaN	NaN	NaN	18	26	24	21	26	22	19	24	28	12	NaN	NaN	NaN	NaN	NaN	-2.399505	5.398896	21.483252	17.799543	18.996819	12.431805	18.649593	-67.606847	-39.079503	65.880305	NaN	NaN	NaN	NaN	NaN	8	-2	-3	5	-4	-3	5	4	-16	NaN
0001527705	ALST Casino Holdco LLC	ALST Ca	NaN	NaN	NaN	NaN	21	20	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-13.024764	34.256857	92.288806	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517401	Peak Resorts Inc	Peak Re	NaN	NaN	NaN	NaN	NaN	6	13	12	24	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	118.063620	88.670300	64.080316	26.969840	27.259756	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-1	12	-4	NaN	NaN	NaN	NaN	NaN
0001581164	Extended Stay America Inc	Extende	NaN	NaN	NaN	NaN	NaN	19	19	15	18	15	15	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34.311396	46.975808	41.935929	45.022259	50.912997	37.269057	186.938910	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-4	3	-3	0	-14	NaN	NaN	NaN
0001594617	La Quinta Holdings Inc	La Quin	NaN	NaN	NaN	NaN	NaN	31	23	20	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-54.087075	26.160475	18.677385	62.791429	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	-3	-5	NaN	NaN	NaN	NaN	NaN	NaN
0001610979	Caesars Entertainment Resort Properties LLC	Caesars	NaN	NaN	NaN	NaN	NaN	28	27	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-27.922802	11.549785	2.430107	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-3	NaN	NaN	NaN	NaN	NaN	NaN	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	527.525150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001611046	International Endeavors Corp	Interna	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-130.362740	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001656239	Pinnacle Entertainment Inc	Pinnacl	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-73.778844	3.933512	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	NaN	NaN	NaN	NaN	NaN	NaN
0001723177	Syndicated Resorts Association Inc	Syndica	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5250.860800	-8072.681300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN

PDF reports

All reports for 2023 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	38,484,900,000	40,876,274,000	62,403,422,748	83,921,006,000	86,312,380,000	0000316206	0001048286	0001048286
8	EconomicCapitalRatio	0.0805	0.133	0.601	1.07	1.12	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.0709	-0.0609	0.0297	0.120	0.130	0001048286	0000316206	0000316206
1	AssetsNonCurrent	-0.00675	-0.00595	0.00123	0.00840	0.00920	0001048286	0000316206	0000316206
2	AssetsCurrent	-0.00122	-0.00111	-0.000148	0.000813	0.000920	0000316206	0001048286	0001048286
3	IntangibleAssets	-0.0304	-0.0276	-0.00261	0.0224	0.0252	0000316206	0001048286	0001048286
4	remainder_Assets	-0.0689	-0.0592	0.0282	0.116	0.125	0001048286	0000316206	0000316206
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0454	-0.0327	0.0818	0.196	0.209	0000316206	0001048286	0001048286
7	remainder_Liabilities	-0.285	-0.229	0.276	0.781	0.837	0000316206	0001048286	0001048286
8	GeneralAndAdministrativeExpense	-0.0542	-0.0506	-0.0183	0.0140	0.0176	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	-1.19	-1.11	-0.401	0.308	0.387	0001048286	0000316206	0000316206
13	remainder_Revenues	-0.420	-0.334	0.435	1.20	1.29	0000316206	0001048286	0001048286
14	remainder_NetIncome	-0.137	-0.109	0.142	0.394	0.422	0000316206	0001048286	0001048286
15	remainder_ComprehensiveNetIncome	-0.173	-0.161	-0.0583	0.0448	0.0563	0001048286	0000316206	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.108	-0.0902	0.0704	0.231	0.249	0001048286	0000316206	0000316206
1	Liabilities	-0.349	-0.284	0.293	0.870	0.935	0000316206	0001048286	0001048286
2	Expenses	-1.24	-1.16	-0.420	0.322	0.405	0001048286	0000316206	0000316206
3	Revenues	-0.420	-0.334	0.435	1.20	1.29	0000316206	0001048286	0001048286
4	StockholdersEquity	-0.0463	-0.0369	0.0481	0.133	0.142	0000316206	0001048286	0001048286
5	NetIncome	-0.152	-0.121	0.158	0.437	0.468	0000316206	0001048286	0001048286
6	ComprehensiveNetIncome	-0.0959	-0.0763	0.0995	0.275	0.295	0000316206	0001048286	0001048286
7	BaseVar	nan	nan	nan	nan	nan	0000316206	0001048286	0000316206
8	EconomicCapitalRatio	-0.521	-0.469	0.000104	0.469	0.521	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,846,750,040	4,541,022,379	30,898,769,625	68,732,945,318	77,996,540,000	0001046311	0001361658	0001048286
8	EconomicCapitalRatio	0.244	0.249	0.630	1.38	1.43	0001115836	0001300514	0001046311

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.149	-0.127	0.0239	0.454	0.625	0001361658	0001174922	0000789570
1	AssetsNonCurrent	-0.0281	-0.0265	-0.00723	0.0831	0.135	0001174922	0000356213	0000789570
2	AssetsCurrent	-0.0738	-0.0653	0.00212	0.0444	0.0549	0000921738	0001174922	0001115836
3	IntangibleAssets	-0.0441	-0.0435	-0.0139	0.150	0.235	0001174922	0001048286	0000921738
4	remainder_Assets	-0.114	-0.0921	-0.0185	0.199	0.254	0000789570	0001048286	0001361658
5	LongTermLiabilities	0	0	0	0	0	0000316206	0001048286	0000316206
6	LiabilitiesCurrent	-0.0808	-0.0712	-0.00731	0.137	0.157	0000316206	0000921738	0000356213
7	remainder_Liabilities	-0.353	-0.334	-0.0952	0.879	1.05	0001300514	0000921738	0001048286
8	GeneralAndAdministrativeExpense	-0.469	-0.412	-0.0143	0.571	0.788	0000356213	0001361658	0001048286
9	DepreciationDepletionAndAmortization	-0.297	-0.248	-0.0518	0.508	0.669	0000356213	0001115836	0001048286
10	CostOfGoodsAndServicesSold	0	0	0	0	0	0000316206	0001048286	0000316206
11	OperatingExpenses	-0.986	-0.986	0.360	0.778	0.927	0001361658	0000921738	0001048286
12	remainder_Expenses	-4.30	-2.74	-0.228	1.35	1.53	0001048286	0001174922	0001115836
13	remainder_Revenues	-0.500	-0.494	-0.0546	1.59	1.75	0001115836	0000316206	0001048286
14	remainder_NetIncome	-0.579	-0.405	0.0883	0.310	0.334	0000789570	0001361658	0001048286
15	remainder_ComprehensiveNetIncome	-0.0150	-0.00808	0.000554	0.00108	0.00122	0001048286	0000921738	0000316206

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.0806	-0.0793	-0.0157	0.384	0.395	0001174922	0001046311	0000789570
1	Liabilities	-0.388	-0.383	-0.0584	0.943	1.10	0001300514	0000921738	0001048286
2	Expenses	-1.91	-1.46	0.0801	0.304	0.356	0001048286	0000316206	0001300514
3	Revenues	-0.500	-0.494	-0.0546	1.59	1.75	0001115836	0000316206	0001048286
4	StockholdersEquity	-0.918	-0.710	-0.121	0.648	0.791	0001046311	0001361658	0000789570
5	NetIncome	-1.02	-0.709	0.191	0.852	1.32	0000789570	0001361658	0001046311
6	ComprehensiveNetIncome	-1.02	-0.708	0.183	0.853	1.32	0000789570	0001361658	0001046311
7	BaseVar	nan	nan	nan	nan	nan	0000316206	0001048286	0000316206
8	EconomicCapitalRatio	-0.477	-0.472	-0.0902	0.657	0.714	0001115836	0001300514	0001046311

2011

Logs

warning	21 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001180638 0000316206 0000356213 0001297735 0001485589 0000216877 0000858339 0000918543 0001005276 0001115836 0000789570 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0001479046 0001510130 0000808377 0001517007
warning	17 × No stock price available	subcommand.plot	0000834162 0000863015 0001180638 0001162556 0000316206 0000356213 0000912145 0001052595 0001297735 0001342126 0001485589 0000216877 0000858339 0000918543 0001005276 0001115836 0001476246
warning	11 × The stock price does not exist	industry.us_generic	0000834162 0000863015 0001162556 0000316206 0000356213 0000912145 0001052595 0001342126 0000858339 0001476246 0000899647
warning	10 × Missing logo	subcommand.report	0000834162 0000863015 0001180638 0000316206 0000356213 0000912145 0001052595 0001297735 0001342126 0001485589
warning	5 × Similarly named company. Duplicate?	None	0000912145 0001476246 0001174922 0001300514 0001468174
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '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	46,803,258	311,739,326	6,924,630,724	76,948,900,776	86,022,694,000	0000216877	0001485589	0000858339
8	EconomicCapitalRatio	-1.02	-0.378	0.698	1.66	2.66	0001342126	0001162556	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.608	-0.383	-0.00355	0.449	0.619	0000918543	0000863015	0001485589
1	AssetsNonCurrent	-0.567	-0.0822	-0.0133	0.00494	0.0153	0000789570	0001115836	0001468174
2	AssetsCurrent	-0.116	-0.104	-0.0100	0.0449	0.0571	0000918543	0001297735	0000316206
3	IntangibleAssets	-0.352	-0.154	-0.0170	0.0915	0.193	0000789570	0001300514	0000858339
4	remainder_Assets	-0.0518	-0.0397	-0.00768	0.323	0.338	0001162556	0000356213	0000834162
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	-0.408	-0.181	0.0214	0.114	0.146	0001005276	0000858339	0000912145
7	remainder_Liabilities	-0.799	-0.451	0.0799	0.956	1.18	0001485589	0001052595	0001048286
8	GeneralAndAdministrativeExpense	-1.46	-0.948	0.00625	1.30	1.52	0000907242	0001485589	0000918543
9	DepreciationDepletionAndAmortization	-0.282	-0.232	-0.0394	0.633	1.02	0000907242	0001342126	0001048286
10	CostOfGoodsAndServicesSold	-0.0585	-0.0266	0.00359	0.00821	0.0132	0000834162	0000316206	0001048286
11	OperatingExpenses	-2.22	-1.18	0.196	0.446	0.717	0000834162	0000356213	0001048286
12	remainder_Expenses	-6.62	-4.24	-0.123	1.69	1.76	0001048286	0000356213	0000834162
13	remainder_Revenues	-6.46	-1.78	0.389	2.13	3.73	0000907242	0001005276	0001048286
14	remainder_NetIncome	-0.753	-0.610	-0.303	1.41	7.44	0000912145	0001115836	0000907242
15	remainder_ComprehensiveNetIncome	-0.0562	-0.0352	0.00317	0.00626	0.0388	0001048286	0001005276	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.10	-0.600	0.000157	0.331	0.531	0000789570	0000863015	0001485589
1	Liabilities	-0.760	-0.417	0.0685	1.01	1.17	0001485589	0000921738	0001048286
2	Expenses	-3.46	-1.79	-0.0701	0.419	1.29	0001048286	0001342126	0000789570
3	Revenues	-6.46	-1.78	0.389	2.13	3.73	0000907242	0001005276	0001048286
4	StockholdersEquity	-1.09	-0.899	-0.0944	0.579	0.990	0000918543	0001180638	0000789570
5	NetIncome	-1.02	-0.596	-0.0854	1.10	1.27	0001342126	0001162556	0000789570
6	ComprehensiveNetIncome	-1.02	-0.593	-0.105	1.11	1.27	0001342126	0001162556	0000789570
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001046311	0000216877
8	EconomicCapitalRatio	-1.70	-1.06	0.0201	0.980	1.99	0001342126	0001162556	0000789570

2012

Logs

error	2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001046311
warning	24 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001517007 0000316206 0000356213 0001180638 0001297735 0001479046 0001485589 0001510130 0000216877 0000858339 0000918543 0001005276 0001115836 0000921738 0001046311 0001048286 0001061937 0001174922 0001361658 0001313536 0001527705 0000789570 0001300514 0000808377
warning	20 × No stock price available	subcommand.plot	0000834162 0001517007 0000863015 0001162556 0000316206 0000356213 0000899647 0000912145 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130 0000216877 0000858339 0000918543 0001005276 0001115836
warning	14 × Missing logo	subcommand.report	0000834162 0001517007 0000863015 0000316206 0000356213 0000899647 0000912145 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130
warning	13 × The stock price does not exist	industry.us_generic	0000834162 0000863015 0001162556 0000316206 0000356213 0000899647 0000912145 0001052595 0001342126 0000858339 0001115836 0001046311 0001476246
warning	6 × Similarly named company. Duplicate?	None	0000912145 0001479046 0001174922 0001300514 0000906553 0001468174
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
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}

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	48,579,411	159,731,390	7,415,167,441	79,347,953,928	87,478,500,000	0000216877	0000863015	0000858339
8	EconomicCapitalRatio	-0.690	-0.522	0.477	1.51	2.03	0001342126	0000789570	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.523	-0.301	-0.0272	0.475	0.963	0000918543	0000899647	0001479046
1	AssetsNonCurrent	-0.154	-0.115	-0.0381	0.154	0.455	0000918543	0000921738	0001510130
2	AssetsCurrent	-0.134	-0.109	-0.0145	0.0657	0.352	0000906553	0001048286	0000899647
3	IntangibleAssets	-0.147	-0.0884	-0.0216	0.207	0.425	0000918543	0001046311	0000906553
4	remainder_Assets	-0.207	-0.0714	0.0174	0.264	0.426	0000789570	0001052595	0001342126
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001046311	0000216877
6	LiabilitiesCurrent	-0.394	-0.149	0.0327	0.204	0.290	0001510130	0001479046	0000891482
7	remainder_Liabilities	-0.735	-0.473	0.122	0.876	1.41	0001485589	0000216877	0001048286
8	GeneralAndAdministrativeExpense	-1.12	-0.863	0.0264	1.09	1.26	0000907242	0001342126	0000918543
9	DepreciationDepletionAndAmortization	-0.302	-0.206	-0.0215	0.640	0.976	0001479046	0001174922	0001048286
10	CostOfGoodsAndServicesSold	-0.0660	-0.00949	0.00249	0.00553	0.00844	0000834162	0001005276	0001048286
11	OperatingExpenses	-2.30	-1.07	0.169	0.371	0.567	0000834162	0000356213	0001048286
12	remainder_Expenses	-5.44	-3.69	-0.0258	1.76	1.83	0001048286	0000789570	0001361658
13	remainder_Revenues	-4.74	-2.69	0.519	2.37	4.44	0000907242	0000891482	0001048286
14	remainder_NetIncome	-1.16	-1.03	-0.418	2.43	5.54	0000789570	0000911147	0000907242
15	remainder_ComprehensiveNetIncome	-0.765	-0.0960	0.0233	0.0736	0.106	0000863015	0001005276	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.620	-0.316	0.00135	0.372	0.589	0000918543	0001300514	0001479046
1	Liabilities	-0.867	-0.578	0.113	0.987	1.41	0001510130	0001297735	0001048286
2	Expenses	-2.69	-1.55	-0.0668	0.386	0.856	0001048286	0000356213	0001510130
3	Revenues	-4.74	-2.69	0.519	2.37	4.44	0000907242	0000891482	0001048286
4	StockholdersEquity	-1.02	-0.916	-0.0330	0.665	0.802	0001046311	0001300514	0000789570
5	NetIncome	-1.64	-1.03	0.134	0.857	1.54	0000906553	0001295810	0000891482
6	ComprehensiveNetIncome	-1.58	-1.01	0.170	0.927	1.58	0000906553	0001468174	0000891482
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001046311	0000216877
8	EconomicCapitalRatio	-1.17	-1.01	-0.00778	1.03	1.54	0001342126	0000789570	0000891482

2013

Logs

error	8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001046311 0001046311 0001005276 0001005276 0001005276 0001005276
warning	26 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001517007 0000356213 0000789570 0001300514 0000316206 0001180638 0001297735 0001479046 0001485589 0001510130 0001527705 0000216877 0000858339 0000918543 0001061937 0001115836 0001313536 0000921738 0001046311 0001048286 0001174922 0001361658 0001610979 0001005276 0001517401 0000808377
warning	20 × No stock price available	subcommand.plot	0000834162 0001517007 0000863015 0000356213 0000316206 0001052595 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130 0001527705 0000216877 0000858339 0000918543 0001061937 0001115836 0001162556 0001313536
warning	15 × The stock price does not exist	industry.us_generic	0000834162 0000863015 0000356213 0001581164 0001476246 0000316206 0001052595 0001342126 0000858339 0001115836 0001162556 0000899647 0001046311 0001594617 0000912145
warning	13 × Missing logo	subcommand.report	0000834162 0001517007 0000863015 0000356213 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	0001517007 0001566897
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
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	50,267,328	139,972,545	4,603,680,546	69,487,256,000	88,626,688,000	0000216877	0001517007	0000858339
8	EconomicCapitalRatio	-2.47	-0.719	0.287	1.32	1.47	0000921738	0001115836	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	-2.00	-0.536	-0.0122	0.457	0.734	0000921738	0000907242	0001479046
1	AssetsNonCurrent	-0.429	-0.148	-0.0465	0.0514	1.22	0000921738	0001174922	0001510130
2	AssetsCurrent	-0.335	-0.0999	-0.0148	0.0672	0.235	0000921738	0001295810	0001510130
3	IntangibleAssets	-0.141	-0.0825	-0.0149	0.228	0.507	0000918543	0000216877	0000921738
4	remainder_Assets	-0.472	-0.0937	0.0183	0.326	0.384	0001510130	0000863015	0001342126
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001052595	0000216877
6	LiabilitiesCurrent	-0.260	-0.163	0.0223	0.125	0.147	0001162556	0001485589	0001061937
7	remainder_Liabilities	-0.666	-0.397	0.0718	0.865	1.60	0001485589	0001297735	0001048286
8	GeneralAndAdministrativeExpense	-1.28	-0.906	0.0829	1.41	1.75	0000891482	0001342126	0000918543
9	DepreciationDepletionAndAmortization	-0.269	-0.235	0.00557	0.711	1.08	0000921738	0001527705	0001048286
10	CostOfGoodsAndServicesSold	-0.0767	-0.0106	0.00265	0.00743	0.0105	0000834162	0000216877	0001048286
11	OperatingExpenses	-2.21	-1.15	0.240	0.755	1.06	0000834162	0001479046	0001048286
12	remainder_Expenses	-6.27	-4.36	-0.0837	1.54	1.78	0001048286	0001517007	0001361658
13	remainder_Revenues	-5.29	-3.78	0.546	2.80	5.15	0000907242	0001361658	0001048286
14	remainder_NetIncome	-1.42	-1.28	-0.355	4.13	6.70	0001517007	0000356213	0000907242
15	remainder_ComprehensiveNetIncome	-0.190	-0.102	0.0164	0.0705	0.140	0001174922	0001052595	0001162556

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-2.03	-0.606	-0.0243	0.421	1.02	0000921738	0000911147	0001510130
1	Liabilities	-0.613	-0.460	0.176	0.848	1.59	0001485589	0001061937	0001048286
2	Expenses	-2.73	-2.29	-0.0695	0.489	0.583	0000921738	0001342126	0001174922
3	Revenues	-5.29	-3.78	0.546	2.80	5.15	0000907242	0001361658	0001048286
4	StockholdersEquity	-0.867	-0.618	-0.131	0.607	0.710	0000918543	0001162556	0001517007
5	NetIncome	-2.32	-0.611	0.00704	0.961	1.46	0000921738	0001297735	0001048286
6	ComprehensiveNetIncome	-2.28	-0.596	0.0217	0.938	1.53	0000921738	0001297735	0001048286
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001052595	0000216877
8	EconomicCapitalRatio	-2.72	-0.970	0.0356	1.07	1.21	0000921738	0001115836	0001048286

2014

Logs

error	8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001005276
warning	33 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000863015 0001300514 0000316206 0000356213 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001610979 0000216877 0000858339 0000918543 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0000789570 0000921738 0001046311 0001048286 0001174922 0001361658 0001005276 0001485589 0001510130 0000808377
warning	23 × No stock price available	subcommand.plot	0000863015 0000316206 0000356213 0000899647 0001052595 0001180638 0001297735 0001342126 0001479046 0001517007 0001527705 0001610979 0000216877 0000858339 0000918543 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617
warning	15 × The stock price does not exist	industry.us_generic	0000863015 0000316206 0000356213 0000899647 0001052595 0001342126 0000858339 0001115836 0001162556 0001476246 0001581164 0001594617 0001046311 0000834162 0000912145
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 0001476246 0001517401 0001174922 0001468174 0001590895
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Zero effects	check_effects	{'var_name': 'LongTermLiabilities', 'zeros': '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	53,451,879	442,036,145	6,297,174,337	89,380,645,000	101,981,920,000	0000216877	0000863015	0000858339
8	EconomicCapitalRatio	-1.88	-0.850	0.366	1.43	2.58	0000858339	0000918543	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.781	-0.473	-0.0189	0.448	0.621	0000921738	0000907242	0001479046
1	AssetsNonCurrent	-0.144	-0.144	-0.0399	0.352	1.93	0000858339	0001581164	0001594617
2	AssetsCurrent	-0.119	-0.0978	-0.00198	0.103	0.239	0000921738	0001297735	0000899647
3	IntangibleAssets	-0.130	-0.0804	-0.00965	0.174	0.229	0000918543	0001590895	0000858339
4	remainder_Assets	-0.691	-0.215	0.00223	0.347	0.448	0001594617	0001180638	0001590895
5	LongTermLiabilities	0	0	0	0	0	0000216877	0001162556	0000216877
6	LiabilitiesCurrent	-0.384	-0.143	0.0271	0.133	0.190	0000899647	0000891482	0001061937
7	remainder_Liabilities	-0.554	-0.486	0.0742	0.790	1.50	0001581164	0000891482	0001048286
8	GeneralAndAdministrativeExpense	-1.52	-1.10	0.0127	1.04	1.54	0000891482	0001342126	0000918543
9	DepreciationDepletionAndAmortization	-0.428	-0.234	-0.0135	0.663	1.07	0001590584	0001297735	0001048286
10	CostOfGoodsAndServicesSold	-0.0517	-0.00132	0.00230	0.00546	0.00885	0001590895	0000216877	0001048286
11	OperatingExpenses	-3.81	-1.39	0.233	0.594	0.994	0001517401	0001479046	0001048286
12	remainder_Expenses	-5.88	-3.07	-0.0753	1.99	3.12	0001048286	0000789570	0001517401
13	remainder_Revenues	-5.32	-4.97	0.327	2.60	5.34	0000891482	0001180638	0001048286
14	remainder_NetIncome	-1.69	-1.42	-0.503	5.55	6.43	0001048286	0001590895	0000907242
15	remainder_ComprehensiveNetIncome	-0.685	-0.242	0.0566	0.172	0.232	0001115836	0001180638	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.789	-0.576	0.00435	0.297	0.353	0000921738	0001180638	0001479046
1	Liabilities	-0.427	-0.407	0.130	0.843	1.49	0001180638	0000858339	0001048286
2	Expenses	-2.50	-1.73	0.114	0.582	0.627	0001048286	0001594617	0001174922
3	Revenues	-5.32	-4.97	0.327	2.60	5.34	0000891482	0001180638	0001048286
4	StockholdersEquity	-0.920	-0.602	-0.0348	0.665	0.732	0000918543	0001590584	0001517401
5	NetIncome	-1.70	-1.05	0.100	0.831	1.91	0000858339	0000356213	0001476246
6	ComprehensiveNetIncome	-1.64	-1.05	0.153	0.906	1.99	0000858339	0001297735	0001476246
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001162556	0000216877
8	EconomicCapitalRatio	-2.23	-1.20	0.0158	1.08	2.23	0000858339	0000918543	0001476246

2015

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001052595 0001052595 0001052595 0001052595
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001611046
warning	36 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001611046 0000863015 0001300514 0000316206 0000356213 0001180638 0001297735 0001342126 0001527705 0001610979 0000216877 0000858339 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0000789570 0000921738 0001046311 0001048286 0001174922 0001361658 0001575879 0001656239 0000918543 0001005276 0001052595 0001479046 0001485589 0001510130 0000808377 0001517007
warning	19 × No stock price available	subcommand.plot	0000863015 0000316206 0000356213 0000844887 0001180638 0001297735 0001342126 0001527705 0001610979 0000216877 0000858339 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617
warning	16 × The stock price does not exist	industry.us_generic	0000863015 0000316206 0000356213 0001342126 0000858339 0001115836 0001162556 0001476246 0001581164 0001594617 0000789570 0001046311 0001052595 0000834162 0000912145 0000899647
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 0001313536 0001468174 0001590895
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001479046 0000808377
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	16,543,179	371,500,513	6,807,349,466	82,552,598,280	93,780,120,000	0000844887	0000863015	0001048286
8	EconomicCapitalRatio	-1.86	-0.202	0.551	1.51	3.50	0001590584	0001046311	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.294	-0.256	-0.0151	0.328	0.342	0001046311	0001048286	0001594617
1	AssetsNonCurrent	-0.213	-0.0698	-0.0338	0.383	1.18	0001590584	0001590895	0001594617
2	AssetsCurrent	-0.128	-0.0521	-0.00135	0.0756	0.0966	0001590584	0001297735	0001174922
3	IntangibleAssets	-0.152	-0.0789	-0.00489	0.127	0.169	0001590584	0001594617	0000356213
4	remainder_Assets	-0.428	-0.173	0.0000982	0.264	1.05	0001594617	0001048286	0000844887
5	LongTermLiabilities	-0.941	0.00330	0.0336	0.0858	0.179	0001313536	0000316206	0001048286
6	LiabilitiesCurrent	-0.929	-0.183	0.0364	0.186	0.209	0000844887	0000858339	0001061937
7	remainder_Liabilities	-0.797	-0.494	0.0599	1.01	1.60	0001342126	0000316206	0001048286
8	GeneralAndAdministrativeExpense	-1.29	-0.976	0.0467	0.873	1.86	0000891482	0001342126	0001048286
9	DepreciationDepletionAndAmortization	-0.843	-0.231	-0.0181	0.454	1.19	0001590584	0001115836	0001048286
10	CostOfGoodsAndServicesSold	-0.407	-0.0829	0.0120	0.0290	0.0565	0000911147	0000356213	0001048286
11	OperatingExpenses	-3.03	-2.15	0.356	0.768	1.74	0001590895	0001180638	0001048286
12	remainder_Expenses	-8.67	-2.47	-0.379	2.09	3.41	0001048286	0000356213	0001590895
13	remainder_Revenues	-5.30	-5.08	0.448	2.54	6.24	0001527705	0001297735	0001048286
14	remainder_NetIncome	-2.50	-1.45	-0.657	5.80	6.32	0001048286	0001174922	0000907242
15	remainder_ComprehensiveNetIncome	-1.23	-0.387	0.0628	0.209	0.374	0001590584	0001313536	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.345	-0.273	0.00816	0.233	0.258	0001590584	0001295810	0001610979
1	Liabilities	-0.830	-0.504	-0.00842	1.03	1.64	0000844887	0000858339	0001048286
2	Expenses	-3.83	-1.69	-0.0151	0.442	1.27	0001048286	0001361658	0000858339
3	Revenues	-5.30	-5.08	0.448	2.54	6.24	0001527705	0001297735	0001048286
4	StockholdersEquity	-0.806	-0.543	-0.0593	0.591	0.875	0001048286	0001585689	0000789570
5	NetIncome	-1.44	-0.675	-0.0990	0.515	3.09	0001590584	0001048286	0000858339
6	ComprehensiveNetIncome	-2.66	-0.498	-0.0415	0.592	3.12	0001590584	0001313536	0000858339
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001174922	0000216877
8	EconomicCapitalRatio	-2.49	-0.826	-0.0731	0.882	2.88	0001590584	0001046311	0000858339

2016

Logs

error	11 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001052595 0001005276 0001005276 0001005276 0001005276
warning	36 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001575879 0000216877 0001180638 0001610979 0001611046 0000858339 0000918543 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0001656239 0000789570 0000921738 0001046311 0001048286 0001052595 0001174922 0001300514 0001361658 0001005276 0000316206 0000356213 0000863015 0001297735 0001342126 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705
warning	17 × The stock price does not exist	industry.us_generic	0000858339 0001115836 0001162556 0001476246 0001581164 0001594617 0000789570 0001046311 0001052595 0001617406 0000316206 0000356213 0000834162 0000863015 0000912145 0001342126 0000899647
warning	16 × No stock price available	subcommand.plot	0001575879 0000844887 0001180638 0001610979 0001611046 0000858339 0000918543 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0001656239
warning	6 × Similarly named company. Duplicate?	None	0001575879 0001313536 0001517401 0001300514 0001468174 0001590895
warning	5 × Missing logo	subcommand.report	0001575879 0000844887 0001180638 0001610979 0001611046
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001617406 0001479046 0000808377
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.3336209294995598}
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

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,334,754	85,616,959	9,295,030,201	90,451,365,000	120,665,600,000	0001611046	0001295810	0001048286
8	EconomicCapitalRatio	-1.50	-1.33	0.377	1.59	5.28	0000858339	0001581164	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.557	-0.288	-0.00738	0.736	1.34	0000918543	0000907242	0001611046
1	AssetsNonCurrent	-0.247	-0.156	-0.0584	0.972	2.45	0000918543	0001581164	0001611046
2	AssetsCurrent	-0.107	-0.0830	-0.00815	0.119	0.347	0001656239	0001048286	0000858339
3	IntangibleAssets	-0.182	-0.0822	-0.0106	0.215	0.275	0000918543	0001061937	0001048286
4	remainder_Assets	-21.5	-0.735	-0.0253	0.722	1.61	0001575879	0000911147	0000844887
5	LongTermLiabilities	-0.979	-0.0000323	0.0286	0.0900	0.102	0001313536	0001517401	0001575879
6	LiabilitiesCurrent	-0.408	-0.0746	0.0645	0.356	0.487	0001517401	0001115836	0001575879
7	remainder_Liabilities	-0.385	-0.370	0.0456	1.06	1.41	0001174922	0001590895	0001575879
8	GeneralAndAdministrativeExpense	-1.08	-0.843	0.0402	0.848	1.71	0000907242	0001590584	0000918543
9	DepreciationDepletionAndAmortization	-0.924	-0.246	-0.0281	0.573	0.852	0001590584	0001174922	0000918543
10	CostOfGoodsAndServicesSold	-0.360	-0.0710	0.0108	0.0259	0.0385	0000911147	0001585689	0000918543
11	OperatingExpenses	-3.79	-1.84	0.333	0.791	1.41	0001590895	0001313536	0000918543
12	remainder_Expenses	-7.21	-3.62	-0.147	1.92	3.84	0000918543	0000921738	0001590895
13	remainder_Revenues	-9.23	-4.06	0.443	1.98	3.14	0000918543	0001656239	0001162556
14	remainder_NetIncome	-1.24	-0.965	-0.420	6.03	12.5	0000858339	0001656239	0000918543
15	remainder_ComprehensiveNetIncome	-0.297	-0.123	0.0362	0.0926	0.154	0000858339	0001313536	0000918543

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-2.03	-0.540	-0.0196	0.430	0.665	0001575879	0001585689	0001611046
1	Liabilities	-0.330	-0.238	0.0785	1.16	1.78	0001174922	0001046311	0001575879
2	Expenses	-3.21	-1.76	-0.0324	0.525	1.74	0000918543	0001313536	0001575879
3	Revenues	-9.23	-4.06	0.443	1.98	3.14	0000918543	0001656239	0001162556
4	StockholdersEquity	-0.705	-0.516	-0.0272	0.519	1.03	0000918543	0001594617	0001575879
5	NetIncome	-1.37	-1.08	0.113	0.808	3.96	0001611046	0001174922	0001575879
6	ComprehensiveNetIncome	-1.43	-1.19	0.141	0.885	4.01	0000858339	0000921738	0001575879
7	BaseVar	nan	nan	nan	nan	nan	0000844887	0001295810	0000844887
8	EconomicCapitalRatio	-1.98	-1.81	-0.0978	1.12	4.80	0000858339	0001581164	0001575879

2017

Logs

error	12 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595 0001052595 0001052595
warning	37 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000216877 0000918543 0001005276 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0001656239 0000789570 0000921738 0001046311 0001048286 0001052595 0001174922 0001300514 0001361658 0001723177 0000316206 0000356213 0000858339 0000863015 0001180638 0001297735 0001342126 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001610979 0001575879 0001611046
warning	18 × The stock price does not exist	industry.us_generic	0001585689 0001115836 0001162556 0001476246 0001581164 0001594617 0000789570 0001046311 0001052595 0001617406 0000316206 0000356213 0000834162 0000858339 0000863015 0000912145 0001342126 0000899647
warning	16 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001005276 0001061937 0001162556 0001581164 0001594617 0000907242 0000911147 0000921738 0001048286 0001052595 0001295810 0001300514 0001468174 0001590584 0001590895 0001674168
warning	12 × No stock price available	subcommand.plot	0000844887 0000918543 0001005276 0001061937 0001115836 0001162556 0001313536 0001476246 0001517401 0001581164 0001594617 0001656239
warning	7 × Ignoring company because Expenses is zero	pre-agg	0001585689 0001617406 0001617406 0001617406 0001617406 0001479046 0000808377
warning	3 × Similarly named company. Duplicate?	None	0001476246 0001656239 0001590895
warning	3 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001295810 0001692412
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Missing logo	subcommand.report	0000844887
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	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	11,491,229	530,073,505	9,935,721,772	83,114,754,310	160,756,640,000	0000844887	0001295810	0001048286
8	EconomicCapitalRatio	-1.41	-0.0600	0.572	1.75	1.94	0000844887	0001046311	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.311	-0.298	0.00117	0.307	0.395	0000844887	0001300514	0001581164
1	AssetsNonCurrent	-0.0978	-0.0822	-0.0280	0.431	1.03	0000789570	0001005276	0000891482
2	AssetsCurrent	-0.122	-0.109	-0.0230	0.0545	0.387	0000891482	0001061937	0000918543
3	IntangibleAssets	-0.157	-0.0964	-0.0179	0.0758	0.322	0001048286	0001295810	0001590895
4	remainder_Assets	-0.533	-0.212	-0.00895	0.648	1.44	0000891482	0001653653	0000844887
5	LongTermLiabilities	-1.03	-0.459	0.0597	0.171	0.222	0001313536	0001361658	0001048286
6	LiabilitiesCurrent	-0.0764	-0.0159	0.110	0.281	0.309	0000844887	0000921738	0001674168
7	remainder_Liabilities	-1.01	-0.406	0.126	1.01	1.31	0000918543	0001674168	0001048286
8	GeneralAndAdministrativeExpense	-1.33	-0.940	0.00769	0.783	1.18	0000891482	0000789570	0001162556
9	DepreciationDepletionAndAmortization	-0.924	-0.230	-0.0147	0.532	0.760	0001590584	0001656239	0001162556
10	CostOfGoodsAndServicesSold	-1.59	-0.147	0.0730	0.172	0.209	0001616000	0001174922	0001162556
11	OperatingExpenses	-2.32	-1.72	0.358	0.717	0.945	0001590895	0001174922	0001048286
12	remainder_Expenses	-4.68	-3.32	-0.335	1.86	2.56	0001162556	0001295810	0001590895
13	remainder_Revenues	-5.14	-3.70	0.592	2.34	3.00	0000907242	0001361658	0001162556
14	remainder_NetIncome	-0.958	-0.939	-0.459	4.23	6.62	0001005276	0001300514	0000907242
15	remainder_ComprehensiveNetIncome	-0.166	-0.111	-0.0109	0.202	0.333	0001581164	0000918543	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.468	-0.329	-0.00509	0.299	0.816	0000891482	0001061937	0000918543
1	Liabilities	-0.875	-0.208	0.0768	1.20	1.44	0000918543	0001616000	0001048286
2	Expenses	-2.54	-1.59	0.0239	0.474	0.702	0001162556	0001295810	0000918543
3	Revenues	-5.14	-3.70	0.592	2.34	3.00	0000907242	0001361658	0001162556
4	StockholdersEquity	-0.608	-0.454	0.0138	0.631	0.854	0001046311	0001468174	0000789570
5	NetIncome	-1.28	-0.764	0.116	0.702	1.02	0001590584	0001476246	0001300514
6	ComprehensiveNetIncome	-1.04	-0.737	0.117	0.657	0.888	0000844887	0001468174	0001300514
7	BaseVar	nan	nan	nan	nan	nan	0000789570	0001295810	0000789570
8	EconomicCapitalRatio	-2.08	-0.732	-0.100	1.08	1.26	0000844887	0001046311	0000789570

2018

Logs

error	10 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595
warning	55 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001653653 0000891482 0001005276 0001005276 0001005276 0001005276 0001061937 0001061937 0001061937 0001061937 0001162556 0001581164 0000789570 0000858339 0000907242 0000907242 0000907242 0000907242 0000911147 0000921738 0000921738 0000921738 0000921738 0001048286 0001048286 0001048286 0001048286 0001174922 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001674168 0001674168 0001674168 0001674168 0001747079 0001052595 0001594617
warning	37 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001723177 0000216877 0001005276 0001061937 0001115836 0001162556 0001313536 0001517401 0001581164 0000789570 0000858339 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0000316206 0000356213 0000863015 0000918543 0001052595 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001594617 0001610979 0001575879 0001611046 0001656239
warning	19 × The stock price does not exist	industry.us_generic	0001115836 0001162556 0001581164 0000789570 0000858339 0000911147 0001046311 0001617406 0000316206 0000356213 0000834162 0000863015 0000912145 0001052595 0001342126 0001476246 0000899647 0001585689 0001594617
warning	10 × No stock price available	subcommand.plot	0000844887 0001723177 0000216877 0001005276 0001061937 0001115836 0001162556 0001313536 0001517401 0001581164
warning	9 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001295810 0001295810 0001692412
warning	9 × Ignoring company because Expenses is zero	pre-agg	0000911147 0001617406 0001617406 0001617406 0001617406 0001617406 0001479046 0000808377 0001585689
warning	2 × Missing logo	subcommand.report	0000844887 0001723177
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
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	0	1,396,442,912	13,535,800,000	20,729,888,000	0000844887	0001005276	0000789570
1	AssetsNonCurrent	0	0	2,308,805	1,376,800,000	6,954,040,000	0000216877	0000907242	0000789570
2	AssetsCurrent	1,797	1,348,337	243,897,552	2,686,612,800	5,566,000,000	0001723177	0001046311	0001300514
3	IntangibleAssets	0	0	81,022,773	4,961,685,500	17,419,000,000	0000216877	0001674168	0001048286
4	remainder_Assets	-5,765,855,000	0	109,243,692	985,100,000	4,893,000,000	0000789570	0001581164	0001361658
5	LongTermLiabilities	0	0	0	532,248,653	989,387,000	0000216877	0001048286	0001692412
6	LiabilitiesCurrent	0	0	59,515,819	3,094,564,600	6,437,000,000	0001061937	0000907242	0001048286
7	remainder_Liabilities	0	0	862,424,282	9,510,998,400	12,645,000,000	0000789570	0001115836	0001300514
8	GeneralAndAdministrativeExpense	0	2,888	104,031,135	1,063,500,000	1,483,000,000	0000216877	0001061937	0001300514
9	DepreciationDepletionAndAmortization	0	0	81,903,548	825,978,800	1,111,000,000	0000789570	0001005276	0001300514
10	CostOfGoodsAndServicesSold	0	0	0	217,056,737	689,762,000	0000789570	0001048286	0001616000
11	OperatingExpenses	0	0	0	372,924,000	1,642,000,000	0000216877	0001046311	0001361658
12	remainder_Expenses	21,570	594,585	686,679,257	9,805,488,400	18,017,000,000	0000844887	0001295810	0001048286
13	remainder_Revenues	0	2,541,011	1,169,829,055	13,139,228,800	20,758,000,000	0000844887	0001295810	0001048286
14	remainder_NetIncome	-687,790,000	-509,860,900	0.0780	627,300,000	932,000,000	0000789570	0001162556	0001061937
15	remainder_ComprehensiveNetIncome	-592,000,000	-325,464,400	-159,787	704,200	53,000,000	0001300514	0001162556	0001468174

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	1,797	9,597,149	2,754,084,426	23,351,300,000	30,210,706,000	0001723177	0001674168	0000789570
1	Liabilities	13,320	5,370,063	1,317,394,376	11,049,973,300	15,802,000,000	0001723177	0001616000	0001300514
2	Expenses	61,889	2,567,028	1,025,067,141	10,706,723,600	19,170,000,000	0001723177	0001295810	0001048286
3	Revenues	0	2,541,011	1,169,829,055	13,139,228,800	20,758,000,000	0000844887	0001295810	0001048286
4	StockholdersEquity	-569,000,000	-130,384,040	640,497,496	14,389,500,000	27,261,824,000	0001361658	0001115836	0000789570
5	NetIncome	-81,847,000	-19,958,847	115,091,056	1,680,200,000	2,951,000,000	0001590584	0000906553	0001300514
6	ComprehensiveNetIncome	-125,279,000	-47,163,700	112,666,094	1,402,000,000	2,359,000,000	0001590584	0001581164	0001300514
7	BaseVar	201,984	26,513,812	10,280,830,170	95,382,638,972	142,603,880,000	0001723177	0001005276	0001048286
8	EconomicCapitalRatio	-52.5	-0.609	0.558	1.86	2.06	0001723177	0000911147	0000216877

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

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-36.3	-0.264	0.000364	0.321	0.397	0001723177	0000906553	0001692412
1	AssetsNonCurrent	-4.52	-0.0323	-0.00562	0.0112	0.0201	0001723177	0001005276	0000789570
2	AssetsCurrent	-13.3	-0.0720	-0.00334	0.0368	0.0935	0001723177	0001590895	0001674168
3	IntangibleAssets	-16.2	-0.0958	-0.0125	0.149	0.241	0001723177	0001048286	0001590895
4	remainder_Assets	-19.2	-0.181	-0.0151	0.708	1.03	0001723177	0001616000	0001313536
5	LongTermLiabilities	-9.35	-0.863	0.0737	0.190	0.216	0001723177	0001005276	0001048286
6	LiabilitiesCurrent	-21.5	-0.929	0.137	0.309	0.388	0001723177	0001313536	0001061937
7	remainder_Liabilities	-17.6	-0.731	0.0298	0.806	0.978	0001723177	0001590584	0001048286
8	GeneralAndAdministrativeExpense	-4.91	-1.09	0.105	0.681	1.05	0001723177	0001300514	0001162556
9	DepreciationDepletionAndAmortization	-0.751	-0.338	0.0132	0.630	1.57	0001590584	0001590895	0001723177
10	CostOfGoodsAndServicesSold	-1.73	-1.44	0.240	0.568	1.35	0001616000	0001005276	0001723177
11	OperatingExpenses	-2.07	-1.12	0.232	0.607	1.45	0001517401	0001174922	0001723177
12	remainder_Expenses	-30.8	-4.40	-0.0471	1.60	1.89	0001723177	0001005276	0001517401
13	remainder_Revenues	-19.7	-0.824	0.157	1.50	2.14	0001723177	0001061937	0001162556
14	remainder_NetIncome	-0.504	-0.410	-0.0898	0.660	0.833	0000906553	0000216877	0001295810
15	remainder_ComprehensiveNetIncome	-0.310	-0.198	0.0369	0.125	0.297	0001590584	0001590895	0001723177

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-41.9	-0.253	-0.00100	0.216	0.310	0001723177	0000906553	0000844887
1	Liabilities	-30.5	-0.804	0.0957	0.998	1.13	0001723177	0001300514	0001048286
2	Expenses	-31.4	-1.64	0.143	0.574	0.606	0001723177	0000216877	0001295810
3	Revenues	-19.7	-0.824	0.157	1.50	2.14	0001723177	0001061937	0001162556
4	StockholdersEquity	-2.89	-0.570	0.0495	0.798	0.843	0001723177	0001468174	0000789570
5	NetIncome	-51.5	-0.540	0.370	1.05	1.24	0001723177	0001005276	0001295810
6	ComprehensiveNetIncome	-51.2	-0.796	0.285	1.11	1.28	0001723177	0000906553	0001295810
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001174922	0000216877
8	EconomicCapitalRatio	-51.3	0.592	1.76	3.06	3.26	0001723177	0000911147	0000216877

2019

Logs

error	10 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001052595 0001052595 0001052595 0001052595 0001005276 0001005276 0001005276 0001005276 0001046311 0001046311
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001585689
warning	80 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001581164 0001585689 0001052595 0000858339 0001005276 0001005276 0001005276 0001005276 0001005276 0001061937 0001061937 0001061937 0001061937 0001061937 0001747079 0001747079 0001747079 0001747079 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0001048286 0001048286 0001048286 0001048286 0001048286 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001162556 0001594617
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001581164 0001052595 0001723177 0000216877 0000858339 0001005276 0001061937 0001313536 0000789570 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0000844887 0000316206 0000356213 0001115836 0000863015 0000918543 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001594617 0001610979 0001517401 0001575879 0001611046 0001656239
warning	19 × The stock price does not exist	industry.us_generic	0001581164 0001585689 0001052595 0000858339 0000789570 0000911147 0001046311 0001617406 0000316206 0000356213 0001115836 0000834162 0000863015 0000912145 0001162556 0001342126 0001476246 0000899647 0001594617
warning	10 × Ignoring company because Expenses is zero	pre-agg	0001585689 0000911147 0000911147 0000911147 0000911147 0001617406 0001617406 0001617406 0001479046 0000808377
warning	8 × No stock price available	subcommand.plot	0001581164 0001723177 0000216877 0000858339 0001005276 0001061937 0001313536 0001747079
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001581164
warning	1 × Missing logo	subcommand.report	0001723177
warning	1 × 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	4,594,488	1,931,693,986	14,936,400,000	18,285,955,000	0001313536	0001692412	0000789570
1	AssetsNonCurrent	0	0	60,025,925	4,165,200,000	11,582,708,000	0000216877	0001674168	0000789570
2	AssetsCurrent	1,669	10,023,382	346,833,289	3,743,485,100	5,305,000,000	0001723177	0001581164	0001300514
3	IntangibleAssets	0	0	159,068,076	6,558,520,400	17,689,000,000	0000216877	0001712189	0001048286
4	remainder_Assets	-5,911,068,000	-9,016,000	195,825,535	927,500,000	5,305,000,000	0000789570	0001005276	0001361658
5	LongTermLiabilities	0	0	0	976,860,600	1,293,054,000	0000216877	0001046311	0001616000
6	LiabilitiesCurrent	0	0	110,471,486	3,214,226,900	6,677,000,000	0001061937	0001590584	0001048286
7	remainder_Liabilities	-5,516,000	0	972,642,054	12,858,700,000	21,071,000,000	0001712189	0001295810	0000858339
8	GeneralAndAdministrativeExpense	0	0	111,038,449	1,768,000,000	2,101,217,000	0000216877	0001674168	0000789570
9	DepreciationDepletionAndAmortization	0	0	51,132,332	1,121,800,000	1,304,649,000	0000906553	0001674168	0000789570
10	CostOfGoodsAndServicesSold	0	0	0	388,849,400	772,857,000	0000891482	0001046311	0001616000
11	OperatingExpenses	0	0	0	367,835,000	1,648,000,000	0000789570	0001046311	0001361658
12	remainder_Expenses	29,527	6,338,902	861,624,188	7,708,500,000	18,613,000,000	0001723177	0001005276	0001048286
13	remainder_Revenues	0	55,584,594	1,389,977,894	13,487,201,600	20,972,000,000	0001723177	0001005276	0001048286
14	remainder_NetIncome	-973,969,000	-556,640,000	-2,051	546,200,000	902,000,000	0000789570	0001723177	0001468174
15	remainder_ComprehensiveNetIncome	-569,000,000	-182,410,000	0	6,040,400	30,000,000	0001300514	0001295810	0001048286

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	1,669	77,865,054	3,919,264,217	25,256,800,000	33,876,356,000	0001723177	0001295810	0000789570
1	Liabilities	4,989	48,612,882	2,374,513,576	15,387,180,000	23,134,000,000	0001723177	0001005276	0000858339
2	Expenses	40,348	34,903,177	1,254,338,020	10,658,196,900	19,892,000,000	0001723177	0001005276	0001048286
3	Revenues	0	55,584,594	1,389,977,894	13,487,201,600	20,972,000,000	0001723177	0001005276	0001048286
4	StockholdersEquity	-524,000,000	-16,458,696	810,450,776	15,101,900,000	30,684,933,000	0001361658	0001692412	0000789570
5	NetIncome	-1,198,000,000	-42,854,900	81,161,659	1,931,966,000	3,304,000,000	0000858339	0001590895	0001300514
6	ComprehensiveNetIncome	-1,232,000,000	-42,892,800	67,598,916	1,822,608,600	2,735,000,000	0000858339	0001581164	0001300514
7	BaseVar	136,487	415,137,262	11,234,494,852	99,048,526,182	144,877,180,000	0001723177	0001005276	0001048286
8	EconomicCapitalRatio	-80.7	-0.180	0.534	1.88	2.27	0001723177	0001747079	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	-62.4	-0.268	-0.0494	0.384	0.491	0001723177	0001468174	0001692412
1	AssetsNonCurrent	-21.8	-0.128	-0.0139	0.0289	0.235	0001723177	0001174922	0000921738
2	AssetsCurrent	-26.7	-0.0605	-0.00833	0.0522	0.125	0001723177	0000789570	0001674168
3	IntangibleAssets	-35.1	-0.0839	-0.0203	0.129	0.169	0001723177	0000907242	0001590895
4	remainder_Assets	-27.5	-0.104	-0.0121	0.347	1.20	0001723177	0001468174	0001313536
5	LongTermLiabilities	-24.4	-1.60	0.0792	0.193	0.255	0001723177	0001361658	0001048286
6	LiabilitiesCurrent	-24.3	-0.294	-0.0187	0.0994	0.140	0001723177	0001590584	0001061937
7	remainder_Liabilities	-50.4	-0.612	-0.00686	0.835	1.01	0001723177	0001674168	0001048286
8	GeneralAndAdministrativeExpense	-15.5	-0.994	0.0633	0.713	0.793	0001723177	0001174922	0000906553
9	DepreciationDepletionAndAmortization	-0.265	-0.220	-0.0108	0.306	1.91	0001061937	0000907242	0001723177
10	CostOfGoodsAndServicesSold	-1.87	-1.30	0.185	0.376	1.83	0001616000	0001174922	0001723177
11	OperatingExpenses	-2.66	-1.11	0.225	0.458	2.23	0000216877	0001590895	0001723177
12	remainder_Expenses	-35.9	-2.76	0.00175	1.57	2.17	0001723177	0001005276	0000216877
13	remainder_Revenues	-31.6	-0.349	0.0299	0.857	1.27	0001723177	0001005276	0001048286
14	remainder_NetIncome	-3.10	-0.389	0.0609	0.335	1.00	0001723177	0001581164	0001468174
15	remainder_ComprehensiveNetIncome	-0.158	-0.122	0.0235	0.0954	0.261	0001581164	0001313536	0001723177

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-69.0	-0.295	-0.0298	0.192	0.259	0001723177	0001048286	0001692412
1	Liabilities	-57.4	-0.533	-0.129	0.916	0.992	0001723177	0001046311	0001048286
2	Expenses	-45.5	-0.956	0.133	0.454	1.59	0001723177	0000858339	0001712189
3	Revenues	-31.6	-0.349	0.0299	0.857	1.27	0001723177	0001005276	0001048286
4	StockholdersEquity	-3.80	-0.406	-0.109	0.728	0.832	0001723177	0001712189	0000789570
5	NetIncome	-80.2	-0.472	0.286	1.00	2.08	0001723177	0001581164	0001712189
6	ComprehensiveNetIncome	-79.9	-0.393	0.287	0.971	2.11	0001723177	0000906553	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001300514	0000216877
8	EconomicCapitalRatio	-78.4	2.10	2.82	4.17	4.55	0001723177	0001747079	0001712189

2020

Logs

error	10 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595
error	1 × Median ECR is negative	check_abs_values	{'median': -0.19041828866324545}
warning	101 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001581164 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001747079 0001747079 0001747079 0001747079 0001747079 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0000858339 0001052595 0001162556 0001594617
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001581164 0000844887 0000216877 0001005276 0001061937 0001313536 0000789570 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001594617 0001610979 0001517401 0001575879 0001611046 0001656239 0001723177
warning	19 × The stock price does not exist	industry.us_generic	0001581164 0000789570 0000911147 0001046311 0001585689 0001617406 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001342126 0001476246 0000899647 0001594617
warning	11 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001005276 0000911147 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001692412
warning	8 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	7 × No stock price available	subcommand.plot	0001581164 0000844887 0000216877 0001005276 0001061937 0001313536 0001747079
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001581164
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684
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	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	16,888,767	377,489,136	9,760,614,457	59,646,874,738	83,160,400,000	0000844887	0001005276	0001048286
8	EconomicCapitalRatio	-2.05	-0.919	-0.190	1.41	1.87	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.680	-0.498	-0.0557	0.890	1.09	0001590584	0001747079	0001295810
1	AssetsNonCurrent	-0.280	-0.109	-0.0396	0.265	0.830	0001590584	0001048286	0001585689
2	AssetsCurrent	-0.328	-0.163	-0.00568	0.215	0.274	0001590584	0001616000	0001674168
3	IntangibleAssets	-0.246	-0.146	-0.0614	0.306	0.466	0001590584	0001468174	0001048286
4	remainder_Assets	-0.345	-0.223	-0.0365	0.841	1.78	0001585689	0001048286	0001313536
5	LongTermLiabilities	-0.585	-0.159	0.0229	0.0775	0.0792	0001616000	0000921738	0001048286
6	LiabilitiesCurrent	-0.0850	-0.0320	0.0549	0.177	1.20	0001048286	0000921738	0000844887
7	remainder_Liabilities	-0.770	-0.364	-0.0917	0.865	0.874	0001581164	0001653653	0001048286
8	GeneralAndAdministrativeExpense	-1.01	-0.388	0.00869	0.365	0.501	0000891482	0001590895	0000216877
9	DepreciationDepletionAndAmortization	-0.472	-0.242	0.0290	0.258	0.280	0001590584	0001590895	0001048286
10	CostOfGoodsAndServicesSold	-0.962	-0.601	0.0900	0.180	0.269	0001313536	0001585689	0001590584
11	OperatingExpenses	-2.26	-0.677	0.140	0.297	0.444	0000216877	0001616000	0001590584
12	remainder_Expenses	-2.94	-1.54	-0.0183	0.699	1.48	0001590584	0000891482	0000216877
13	remainder_Revenues	-0.978	-0.645	0.0271	1.24	1.38	0000844887	0000921738	0001590584
14	remainder_NetIncome	-0.396	-0.285	0.0755	0.350	0.508	0001712189	0001692412	0001590584
15	remainder_ComprehensiveNetIncome	-0.141	-0.0313	-0.0124	0.107	0.150	0001581164	0001295810	0001300514

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.15	-0.402	-0.0259	0.453	0.583	0001590584	0001468174	0001295810
1	Liabilities	-0.429	-0.283	0.0291	0.912	0.960	0001581164	0001005276	0000906553
2	Expenses	-2.38	-0.706	-0.0823	0.801	1.24	0001590584	0001616000	0001581164
3	Revenues	-0.978	-0.645	0.0271	1.24	1.38	0000844887	0000921738	0001590584
4	StockholdersEquity	-0.791	-0.350	-0.0851	0.748	1.06	0000844887	0001747079	0000789570
5	NetIncome	-1.19	-0.932	-0.0268	1.38	2.04	0000844887	0001585689	0001581164
6	ComprehensiveNetIncome	-1.20	-0.943	-0.0136	1.36	1.90	0000844887	0000789570	0001581164
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001295810	0000216877
8	EconomicCapitalRatio	-2.05	-0.918	-0.189	1.41	1.87	0000844887	0000921738	0001581164

2021

Logs

error	10 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	125 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001005276 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001046311 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001617406 0001617406 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0000858339 0001052595 0001162556 0001581164 0001594617
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0000844887 0000216877 0001005276 0001313536 0000789570 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001581164 0001594617 0001610979 0001517401 0001575879 0001611046 0001656239 0001723177
warning	19 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001585689 0001617406 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001342126 0001476246 0000899647 0001581164 0001594617
warning	19 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001692412 0001005276 0001005276 0001005276 0001005276 0000911147 0000911147 0000911147 0000911147 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001712189
warning	8 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	5 × No stock price available	subcommand.plot	0001061937 0000216877 0001005276 0001313536 0001747079
warning	4 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684 0001722684 0001722684
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × 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	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	15,401,786	167,538,262	12,709,694,410	90,169,608,512	100,201,080,000	0000844887	0001722684	0001048286
8	EconomicCapitalRatio	-1.59	-0.403	0.369	2.01	2.15	0000844887	0000891482	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.346	-0.271	-0.0409	0.525	0.914	0001313536	0000907242	0001617406
1	AssetsNonCurrent	-0.117	-0.0875	-0.0209	0.121	0.680	0001590584	0000906553	0001585689
2	AssetsCurrent	-0.159	-0.121	-0.00676	0.123	0.316	0000216877	0000789570	0000891482
3	IntangibleAssets	-0.156	-0.142	-0.0365	0.239	0.680	0001313536	0001361658	0001747079
4	remainder_Assets	-0.307	-0.262	-0.0879	0.907	3.10	0001585689	0001061937	0001819395
5	LongTermLiabilities	-0.659	-0.235	0.0359	0.105	0.139	0001616000	0000921738	0000906553
6	LiabilitiesCurrent	-0.290	-0.220	0.00472	0.0969	0.102	0001048286	0001722684	0000906553
7	remainder_Liabilities	-0.298	-0.223	0.00808	1.12	1.44	0001361658	0001061937	0000906553
8	GeneralAndAdministrativeExpense	-0.496	-0.443	0.0107	0.341	0.565	0000891482	0001300514	0000216877
9	DepreciationDepletionAndAmortization	-0.474	-0.268	0.00889	0.236	0.331	0001590584	0001005276	0001048286
10	CostOfGoodsAndServicesSold	-1.31	-0.644	0.106	0.224	0.301	0001313536	0001174922	0001590584
11	OperatingExpenses	-2.22	-1.34	0.211	0.438	0.609	0000216877	0001468174	0001590584
12	remainder_Expenses	-2.85	-1.89	-0.170	1.11	1.27	0001590584	0001005276	0000216877
13	remainder_Revenues	-0.971	-0.607	0.168	1.55	1.68	0000844887	0000921738	0001590584
14	remainder_NetIncome	-0.411	-0.387	0.0807	0.455	0.609	0000844887	0001616000	0001295810
15	remainder_ComprehensiveNetIncome	-0.214	-0.168	0.00911	0.0857	0.135	0001653653	0001674168	0001174922

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.536	-0.281	-0.0288	0.273	1.20	0001590584	0001468174	0001819395
1	Liabilities	-0.208	-0.201	0.00306	1.09	1.53	0001585689	0001616000	0000906553
2	Expenses	-2.20	-0.866	-0.0741	0.480	0.913	0001590584	0001174922	0001712189
3	Revenues	-0.971	-0.607	0.168	1.55	1.68	0000844887	0000921738	0001590584
4	StockholdersEquity	-0.841	-0.432	-0.135	0.743	1.05	0000844887	0001722684	0001819395
5	NetIncome	-0.909	-0.483	0.109	1.00	1.75	0000844887	0001674168	0001712189
6	ComprehensiveNetIncome	-0.904	-0.414	0.117	1.02	1.76	0000844887	0000921738	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001295810	0000216877
8	EconomicCapitalRatio	-2.09	-0.902	-0.130	1.51	1.65	0000844887	0000891482	0000216877

2022

Logs

error	10 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001005276 0001005276 0001005276 0001005276 0001046311 0001046311 0001052595 0001052595 0001052595 0001052595
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	142 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001061937 0001005276 0001005276 0001005276 0001005276 0001005276 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0001747079 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000789570 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000891482 0000906553 0000906553 0000906553 0000906553 0000906553 0000906553 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000907242 0000911147 0000911147 0000911147 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0000921738 0001046311 0001046311 0001046311 0001046311 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001048286 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001174922 0001295810 0001295810 0001295810 0001295810 0001295810 0001295810 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001300514 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001468174 0001585689 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590584 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001590895 0001617406 0001617406 0001617406 0001617406 0001617406 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001653653 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0001674168 0000858339 0001052595 0001162556 0001581164 0001594617
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0000844887 0000216877 0001005276 0001313536 0000789570 0000921738 0001046311 0001048286 0001174922 0001300514 0001361658 0000316206 0000356213 0001115836 0000858339 0000863015 0000918543 0001052595 0001162556 0001180638 0001297735 0001342126 0001476246 0001479046 0001485589 0001510130 0000808377 0001517007 0001527705 0001581164 0001594617 0001610979 0001517401 0001575879 0001611046 0001656239 0001723177
warning	19 × The stock price does not exist	industry.us_generic	0000789570 0000911147 0001046311 0001585689 0001617406 0000316206 0000356213 0001115836 0000834162 0000858339 0000863015 0000912145 0001052595 0001162556 0001342126 0001476246 0000899647 0001581164 0001594617
warning	16 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001692412 0001005276 0001005276 0000911147 0000911147 0001048286 0001048286 0001048286 0001048286 0001048286 0001295810 0001295810 0001712189 0001712189 0001712189 0001712189
warning	10 × Ignoring company because Expenses is zero	pre-agg	0000911147 0000911147 0000911147 0000911147 0001585689 0001617406 0001617406 0001617406 0001479046 0000808377
warning	5 × No stock price available	subcommand.plot	0001061937 0000216877 0001005276 0001313536 0001747079
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001722684 0001722684 0001722684 0001722684 0001722684
warning	1 × equityII differs from equityI	pre-agg	0000356213
warning	1 × Similarly named company. Duplicate?	None	0001590895
warning	1 × Missing logo	subcommand.report	0000844887
warning	1 × 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	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	17,356,414	729,326,584	13,156,754,269	107,265,830,854	140,687,900,000	0000844887	0001005276	0001048286
8	EconomicCapitalRatio	-1.77	-0.642	0.540	2.31	2.80	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.348	-0.278	-0.0364	0.424	0.532	0001819395	0001712189	0001617406
1	AssetsNonCurrent	-0.209	-0.123	-0.0251	0.330	0.967	0001590584	0001061937	0001819395
2	AssetsCurrent	-0.171	-0.115	-0.0159	0.138	0.189	0000216877	0001585689	0000891482
3	IntangibleAssets	-0.226	-0.168	-0.0443	0.237	0.618	0000906553	0001061937	0001747079
4	remainder_Assets	-0.233	-0.174	-0.0180	0.557	0.845	0001590584	0001046311	0000844887
5	LongTermLiabilities	-0.841	-0.236	0.0315	0.108	0.112	0001616000	0001722684	0000907242
6	LiabilitiesCurrent	-0.359	-0.276	-0.00704	0.120	0.147	0001712189	0000844887	0001061937
7	remainder_Liabilities	-0.319	-0.261	-0.0283	1.40	1.49	0001361658	0000911147	0000906553
8	GeneralAndAdministrativeExpense	-0.574	-0.468	-0.0266	0.516	0.679	0000907242	0001712189	0001048286
9	DepreciationDepletionAndAmortization	-0.575	-0.548	0.0163	0.273	0.511	0000789570	0001653653	0001048286
10	CostOfGoodsAndServicesSold	-1.78	-1.38	0.184	0.399	0.577	0001313536	0001747079	0001590584
11	OperatingExpenses	-2.42	-1.36	0.280	0.613	0.914	0000216877	0001616000	0001590584
12	remainder_Expenses	-3.87	-2.60	-0.0221	1.33	1.52	0001590584	0001174922	0000216877
13	remainder_Revenues	-1.11	-0.934	0.135	1.63	1.87	0000844887	0000911147	0001590584
14	remainder_NetIncome	-0.512	-0.374	0.0223	0.548	0.954	0001590895	0001692412	0001300514
15	remainder_ComprehensiveNetIncome	-0.333	-0.302	0.0193	0.153	0.350	0001590584	0001712189	0000789570

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.618	-0.150	0.0256	0.179	0.212	0001590584	0001061937	0001617406
1	Liabilities	-0.312	-0.241	0.0616	1.38	1.56	0001174922	0001692412	0000906553
2	Expenses	-2.59	-1.05	-0.0497	0.452	1.20	0001590584	0001313536	0001712189
3	Revenues	-1.11	-0.934	0.135	1.63	1.87	0000844887	0000911147	0001590584
4	StockholdersEquity	-0.834	-0.275	-0.0101	0.870	0.979	0000844887	0000921738	0000789570
5	NetIncome	-1.10	-0.774	0.0713	0.832	2.33	0000844887	0001674168	0001712189
6	ComprehensiveNetIncome	-1.09	-0.919	0.0820	0.865	2.35	0000844887	0001295810	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001295810	0000216877
8	EconomicCapitalRatio	-2.40	-1.27	-0.0868	1.68	2.17	0000844887	0001617406	0001712189

2023

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001807616
warning	18 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001061937 0001747079 0000789570 0000891482 0000906553 0000907242 0000921738 0001046311 0001048286 0001174922 0001295810 0001300514 0001468174 0001590584 0001590895 0001617406 0001653653 0001674168
warning	3 × No stock price available	subcommand.plot	0001061937 0000216877 0001747079
warning	2 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001061937 0000216877
warning	1 × The stock price does not exist	industry.us_generic	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
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	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	16,672,238	724,444,713	22,788,080,506	114,503,422,156	156,708,620,000	0000844887	0001747079	0001048286
8	EconomicCapitalRatio	-1.49	-0.940	0.479	2.27	4.96	0000844887	0001692412	0001712189

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

	xvar	min	5%	median	95%	max	min_company	median_company	max_company
0	PropertyPlantAndEquipment	-0.448	-0.246	-0.0691	0.384	0.571	0001819395	0001590584	0001616000
1	AssetsNonCurrent	-0.224	-0.0902	-0.0186	0.426	1.30	0000789570	0001061937	0001819395
2	AssetsCurrent	-0.200	-0.0763	-0.0143	0.0943	0.143	0001712189	0000891482	0001361658
3	IntangibleAssets	-0.233	-0.213	-0.0139	0.210	0.386	0001048286	0000891482	0001747079
4	remainder_Assets	-0.232	-0.159	-0.00158	0.531	0.707	0001585689	0001653653	0000844887
5	LongTermLiabilities	-0.779	-0.529	0.0450	0.198	0.234	0001616000	0001361658	0001712189
6	LiabilitiesCurrent	-0.0694	0.00301	0.207	0.579	0.762	0001046311	0001617406	0001712189
7	remainder_Liabilities	-0.617	-0.455	-0.0164	1.19	1.30	0001361658	0001061937	0001048286
8	GeneralAndAdministrativeExpense	-0.673	-0.654	0.0338	0.538	0.727	0000789570	0001819395	0001048286
9	DepreciationDepletionAndAmortization	-0.503	-0.269	-0.00410	0.300	0.471	0001590584	0001653653	0001048286
10	CostOfGoodsAndServicesSold	-1.83	-0.927	0.146	0.328	0.457	0001616000	0000921738	0001590584
11	OperatingExpenses	-2.69	-1.47	0.321	0.762	1.08	0000216877	0001653653	0001590584
12	remainder_Expenses	-3.80	-2.93	-0.202	1.31	1.79	0001590584	0000789570	0000216877
13	remainder_Revenues	-1.05	-0.617	0.0535	1.75	2.52	0000844887	0001674168	0001712189
14	remainder_NetIncome	-0.472	-0.250	0.0533	0.354	0.490	0001590895	0001692412	0001295810
15	remainder_ComprehensiveNetIncome	-0.256	-0.0391	0.0106	0.0805	0.111	0001653653	0001295810	0001590584

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.186	-0.163	0.0161	0.179	0.345	0001819395	0001295810	0001712189
1	Liabilities	-0.259	-0.244	0.0269	1.50	1.55	0001722684	0001674168	0000906553
2	Expenses	-2.48	-1.09	-0.124	0.606	1.78	0001590584	0001674168	0001712189
3	Revenues	-1.05	-0.617	0.0535	1.75	2.52	0000844887	0001674168	0001712189
4	StockholdersEquity	-0.828	-0.324	0.0161	0.917	1.02	0000844887	0001674168	0000789570
5	NetIncome	-1.33	-0.706	0.0839	0.708	4.05	0001819395	0001361658	0001712189
6	ComprehensiveNetIncome	-1.35	-0.700	0.0641	0.728	4.06	0001819395	0001653653	0001712189
7	BaseVar	nan	nan	nan	nan	nan	0000216877	0001361658	0000216877
8	EconomicCapitalRatio	-2.26	-1.71	-0.290	1.50	4.19	0000844887	0001692412	0001712189

Estimates

Parameter	Value	Min	Max
PresentValueFactor	6.28	1.0	15.0
BalanceFactor	0.73	0.5	5.0
OCIFactor	1.0	0.5	1.0
HiddenReservesFactor	0.0	0.0	0.0
LLPO_stddev	0.72	0.02	10.0

Stock Table

					Adjusted stock price	Split	Original stock price (Adjusted stock price * Split)	Outstanding shares	Market cap (Original stock price * Outstanding shares)	obs_EconomicCapitalRatio
Company	Name	Name_short	Identifier	Year
0000216877	Pismo Coast Village INC	Pismo C	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
				2023	nan	nan	nan	nan	nan	nan
0000316206	Starwood Hotels Resorts Worldwide LLC	Starwoo	nan	2009	nan	nan	nan	nan	nan	nan
				2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	195,332,051.0	nan	nan
				2012	nan	nan	nan	196,106,079.0	nan	nan
				2013	nan	nan	nan	191,511,857.0	nan	nan
				2014	nan	nan	nan	178,575,327.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0000356213	Gold Merger Sub LLC	Gold Me	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	62,134,794.0	nan	nan
				2012	nan	nan	nan	62,149,308.0	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0000789570	MGM Resorts International	MGM Res	MGM	2010	14.8000	1.0000	14.8000	nan	nan	nan
				2011	9.7200	1.0000	9.7200	488,830,987.0	4,751,437,193.64	0.3220
				2012	11.6400	1.0000	11.6400	489,201,152.0	5,694,301,409.28	0.4035
				2014	20.8600	1.0000	20.8600	491,120,180.0	10,244,766,954.80	0.6803
				2015	22.5100	1.0000	22.5100	563,465,386.0	12,683,605,838.86	0.9238
				2017	33.3400	1.0000	33.3400	566,138,245.0	18,875,049,088.30	1.1707
				2018	23.7300	1.0000	23.7300	527,197,958.0	12,510,407,543.34	0.7547
				2019	33.3100	1.0000	33.3100	514,984,359.0	17,154,128,998.29	0.9256
				2020	31.0500	1.0000	31.0500	493,939,099.0	15,336,809,023.95	0.7998
				2021	44.7800	1.0000	44.7800	468,959,843.0	21,000,021,769.54	0.9473
				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
0000834162	MTR Gaming Group INC	MTR Gam	nan	2011	nan	nan	nan	27,637,686.0	nan	nan
				2012	nan	nan	nan	27,668,839.0	nan	nan
				2013	nan	nan	nan	27,928,641.0	nan	nan
0000844887	Diamondhead Casino CORP	Diamond	DHCC	2015	nan	1.0000	nan	36,297,576.0	nan	nan
				2016	nan	1.0000	nan	36,297,576.0	nan	nan
				2017	nan	1.0000	nan	36,297,576.0	nan	nan
				2018	nan	1.0000	nan	36,297,576.0	nan	nan
				2020	nan	1.0000	nan	nan	nan	nan
				2021	0.2700	1.0000	0.2700	36,297,576.0	9,800,345.52	0.9218
				2022	0.3500	1.0000	0.3500	36,297,576.0	12,704,151.60	1.0924
				2023	0.2100	1.0000	0.2100	36,297,576.0	7,622,490.96	0.6373
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.7400	1.0000	6.7400	86,588,933.0	583,609,408.42	0.1649
				2017	35.1700	1.0000	35.1700	112,473,050.0	3,955,677,168.50	1.5621
				2018	20.6200	1.0000	20.6200	112,205,979.0	2,313,687,286.98	0.7430
				2019	30.3600	1.0000	30.3600	111,165,446.0	3,374,982,940.56	0.9366
				2020	42.5700	1.0000	42.5700	111,540,103.0	4,748,262,184.71	1.3408
				2021	64.6400	1.0000	64.6400	112,345,594.0	7,262,019,196.16	2.1418
				2022	55.0000	1.0000	55.0000	104,375,084.0	5,740,629,620.00	1.6645
				2023	62.1900	1.0000	62.1900	97,862,123.0	6,086,045,429.37	1.7721
0000907242	Monarch Casino Resort INC	Monarch	MCRI	2011	10.2700	1.0000	10.2700	16,138,158.0	165,738,882.66	1.4495
				2012	10.1200	1.0000	10.1200	16,141,492.0	163,351,899.04	0.9193
				2013	19.9300	1.0000	19.9300	16,476,435.0	328,375,349.55	2.0192
				2014	16.5400	1.0000	16.5400	16,803,129.0	277,923,753.66	1.6965
				2015	22.7600	1.0000	22.7600	16,981,355.0	386,495,639.80	2.2360
				2016	25.5100	1.0000	25.5100	17,368,559.0	443,071,940.09	2.4858
				2017	46.2500	1.0000	46.2500	17,700,513.0	818,648,726.25	4.1169
				2018	37.3300	1.0000	37.3300	17,894,057.0	667,985,147.81	2.1935
				2019	48.3200	1.0000	48.3200	18,082,135.0	873,728,763.20	1.9843
				2020	58.1700	1.0000	58.1700	18,263,405.0	1,062,382,268.85	2.1779
				2021	73.4800	1.0000	73.4800	18,736,377.0	1,376,748,981.96	2.9517
				2022	77.1000	1.0000	77.1000	18,961,643.0	1,461,942,675.30	3.4526
				2023	68.8800	1.0000	68.8800	19,067,522.0	1,313,370,915.36	3.0956
0000911147	Century Casinos INC CO	Century	CNTY	2011	2.4100	1.0000	2.4100	23,877,362.0	57,544,442.42	0.7152
				2012	2.8000	1.0000	2.8000	24,117,362.0	67,528,613.60	0.8644
				2013	5.2300	1.0000	5.2300	24,377,761.0	127,495,690.03	1.0137
				2014	5.0100	1.0000	5.0100	24,381,057.0	122,149,095.57	0.9675
				2015	7.2200	1.0000	7.2200	24,404,263.0	176,198,778.86	1.4273
				2016	7.8900	1.0000	7.8900	24,444,571.0	192,867,665.19	1.2984
				2017	9.5900	1.0000	9.5900	24,472,320.0	234,689,548.80	1.2951
				2018	6.7600	1.0000	6.7600	29,439,179.0	199,008,850.04	1.0642
				2021	12.2300	1.0000	12.2300	29,614,814.0	362,189,175.22	0.5766
				2022	6.9700	1.0000	6.9700	29,864,047.0	208,152,407.59	0.2577
0000912145	Ameristar Casinos INC	Amerist	nan	2011	nan	nan	nan	32,632,793.0	nan	nan
0000912145	Ameristar Casinos INC	Amerist	nan	2012	nan	nan	nan	32,867,902.0	nan	nan
0000918543	Castle Group INC	Castle	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0000921738	PENN Entertainment Inc	PENN En	PENN	2010	7.8500	4.4230	34.7200	nan	nan	nan
				2011	8.5300	4.4230	37.7300	78,233,972.0	2,951,767,763.56	0.8150
				2012	11.0600	4.4230	48.9200	76,690,695.0	3,751,708,799.40	0.8300
				2013	14.3400	1.0000	14.3400	77,346,817.0	1,109,153,355.78	0.6143
				2014	13.6200	1.0000	13.6200	78,703,844.0	1,071,946,355.28	0.5469
				2015	16.0200	1.0000	16.0200	80,185,538.0	1,284,572,318.76	0.2344
				2016	14.3200	1.0000	14.3200	83,522,580.0	1,196,043,345.60	0.2279
				2017	30.8300	1.0000	30.8300	91,095,622.0	2,808,478,026.26	0.5328
				2018	18.8700	1.0000	18.8700	118,855,917.0	2,242,811,153.79	0.2117
				2019	25.6800	1.0000	25.6800	115,912,626.0	2,976,636,235.68	0.2243
				2020	91.7400	1.0000	91.7400	155,324,295.0	14,249,450,823.30	1.0682
				2021	50.7400	1.0000	50.7400	169,514,408.0	8,601,161,061.92	0.5802
				2022	30.4600	1.0000	30.4600	155,117,678.0	4,724,884,471.88	0.3009
				2023	25.2400	1.0000	25.2400	151,758,888.0	3,830,394,333.12	0.2648
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	38.9400	1.0000	38.9400	nan	nan	nan
				2011	38.2100	1.0000	38.2100	59,166,765.0	2,260,762,090.65	4.9097
				2012	33.5000	1.0000	33.5000	58,053,476.0	1,944,791,446.00	2.4771
				2015	50.6500	1.0000	50.6500	56,622,700.0	2,867,939,755.00	3.1348
				2016	56.2500	1.0000	56.2500	56,096,987.0	3,155,455,518.75	3.1300
				2017	77.6200	1.0000	77.6200	56,593,820.0	4,392,812,308.40	4.2500
				2018	70.5700	1.0000	70.5700	55,980,838.0	3,950,567,737.66	3.2112
				2019	103.5800	1.0000	103.5800	55,730,708.0	5,772,586,734.64	4.1279
				2020	103.9900	1.0000	103.9900	55,458,082.0	5,767,085,947.18	3.6264
				2021	153.5100	1.0000	153.5100	55,629,330.0	8,539,658,448.30	4.7470
				2022	112.2900	1.0000	112.2900	53,299,203.0	5,984,967,504.87	2.9558
				2023	112.9900	1.0000	112.9900	49,798,586.0	5,626,742,232.14	2.3673
0001048286	Marriott International INC MD	Marriot	MAR	2009	26.3300	1.0610	27.9400	nan	nan	nan
				2010	39.4000	1.0610	41.8000	nan	nan	nan
				2011	29.1600	1.0000	29.1600	335,126,113.0	9,772,277,455.08	2.3080
				2012	37.1700	1.0000	37.1700	315,540,075.0	11,728,624,587.75	2.5735
				2013	48.4700	1.0000	48.4700	299,538,446.0	14,518,628,477.62	3.0669
				2014	78.3300	1.0000	78.3300	283,360,811.0	22,195,652,325.63	4.4724
				2015	68.2500	1.0000	68.2500	257,128,905.0	17,549,047,766.25	3.7682
				2016	84.1100	1.0000	84.1100	390,479,820.0	32,843,257,660.20	2.2430
				2017	133.8900	1.0000	133.8900	364,581,283.0	48,813,787,980.87	3.2589
				2018	106.5100	1.0000	106.5100	341,130,300.0	36,333,788,253.00	2.4116
				2019	151.3300	1.0000	151.3300	326,937,219.0	49,475,409,351.27	3.1188
				2020	128.7900	1.0000	128.7900	324,331,716.0	41,770,681,703.64	2.7432
				2021	165.0300	1.0000	165.0300	325,683,100.0	53,747,481,993.00	3.3633
				2022	148.6700	1.0000	148.6700	316,539,613.0	47,059,944,264.71	2.9271
				2023	222.3700	1.0000	222.3700	293,691,348.0	65,308,145,054.76	3.9065
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
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	103.4200	1.0000	103.4200	nan	nan	nan
				2011	108.6300	1.0000	108.6300	124,957,158.0	13,574,096,073.54	2.3453
				2012	113.0100	1.0000	113.0100	100,581,636.0	11,366,730,684.36	1.5734
				2013	187.9600	1.0000	187.9600	101,155,304.0	19,013,150,939.84	2.2877
				2014	150.2400	1.0000	150.2400	101,349,797.0	15,226,793,501.28	1.6999
				2015	68.4900	1.0000	68.4900	101,568,512.0	6,956,427,386.88	0.6618
				2016	88.2800	1.0000	88.2800	101,740,911.0	8,981,687,623.08	0.7596
				2017	168.4900	1.0000	168.4900	102,782,543.0	17,317,830,670.07	1.4263
				2018	98.2600	1.0000	98.2600	108,738,518.0	10,684,646,778.68	0.8680
				2019	139.4100	1.0000	139.4100	107,354,606.0	14,966,305,622.46	1.1424
				2020	114.3500	1.0000	114.3500	107,870,602.0	12,335,003,338.70	0.8663
				2021	86.0100	1.0000	86.0100	115,657,896.0	9,947,735,634.96	0.7682
				2022	82.0100	1.0000	82.0100	113,313,591.0	9,292,847,597.91	0.6528
				2023	90.6700	1.0000	90.6700	112,945,993.0	10,240,813,185.31	0.7040
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	7.8200	1.0000	7.8200	118,672,242.0	928,016,932.44	0.3883
				2012	10.6400	1.0000	10.6400	136,777,430.0	1,455,311,855.20	0.6251
				2013	13.4200	1.0000	13.4200	182,870,062.0	2,454,116,232.04	0.9690
				2014	16.8900	1.0000	16.8900	205,396,771.0	3,469,151,462.19	1.2432
				2015	13.6100	1.0000	13.6100	208,590,736.0	2,838,919,916.96	1.0563
				2016	15.6400	1.0000	15.6400	216,509,093.0	3,386,202,214.52	1.3687
				2017	17.0500	1.0000	17.0500	225,321,660.0	3,841,734,303.00	1.4972
				2018	13.3400	1.0000	13.3400	228,247,062.0	3,044,815,807.08	1.1634
				2019	14.3200	1.0000	14.3200	224,855,351.0	3,219,928,626.32	1.2340
				2020	11.2000	1.0000	11.2000	215,635,550.0	2,415,118,160.00	1.2442
				2021	11.6800	1.0000	11.6800	219,333,783.0	2,561,818,585.44	1.3329
				2022	9.6600	1.0000	9.6600	210,399,520.0	2,032,459,363.20	0.9961
				2023	10.8100	1.0000	10.8100	205,444,026.0	2,220,849,921.06	1.0745
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	45.7400	1.0000	45.7400	nan	nan	nan
				2011	42.7400	1.0000	42.7400	732,718,517.0	31,316,389,416.58	1.7870
				2012	46.2200	1.0000	46.2200	823,449,212.0	38,059,822,578.64	2.1341
				2016	54.2400	1.0000	54.2400	794,793,918.0	43,109,622,112.32	2.5779
				2017	70.4000	1.0000	70.4000	790,480,010.0	55,649,792,704.00	3.2988
				2018	51.1800	1.0000	51.1800	783,554,277.0	40,102,307,896.86	2.0914
				2019	69.2400	1.0000	69.2400	768,036,535.0	53,178,849,683.40	2.6660
				2020	57.3900	1.0000	57.3900	763,828,127.0	43,836,096,208.53	2.3024
				2021	37.4100	1.0000	37.4100	763,989,752.0	28,580,856,622.32	1.5096
				2022	46.7000	1.0000	46.7000	764,166,260.0	35,686,564,342.00	1.7659
				2023	48.8500	1.0000	48.8500	764,490,874.0	37,345,379,194.90	1.8934
0001313536	Sotherly Hotels LP	Sotherl	nan	2013	nan	nan	nan	nan	nan	nan
				2014	nan	nan	nan	nan	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	nan	nan	nan
				2021	nan	nan	nan	nan	nan	nan
				2022	nan	nan	nan	nan	nan	nan
0001342126	Morgans Hotel Group Co	Morgans	nan	2011	nan	nan	nan	30,731,457.0	nan	nan
				2012	nan	nan	nan	30,792,328.0	nan	nan
				2013	nan	nan	nan	33,569,047.0	nan	nan
				2014	nan	nan	nan	34,377,788.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001361658	Travel Leisure Co	Travel	TNL	2010	13.7700	2.2150	30.5000	nan	nan	nan
				2011	16.6800	2.2150	36.9500	154,017,892.0	5,690,961,109.40	0.7198
				2012	23.8800	2.2150	52.8900	140,266,725.0	7,418,707,085.25	0.8730
				2013	32.8800	2.2150	72.8300	130,306,798.0	9,490,244,098.34	1.0631
				2014	38.5600	2.2150	85.4100	123,262,818.0	10,527,877,285.38	1.1634
				2015	32.8500	2.2150	72.7600	116,106,000.0	8,447,872,560.00	0.9144
				2016	34.8700	2.2150	77.2400	107,776,539.0	8,324,659,872.36	0.8799
				2017	51.3500	2.2150	113.7400	101,326,244.0	11,524,846,992.56	1.1570
				2018	35.9000	1.0000	35.9000	97,452,743.0	3,498,553,473.70	0.4701
				2019	51.5900	1.0000	51.5900	90,704,218.0	4,679,430,606.62	0.6065
				2020	42.8800	1.0000	42.8800	85,861,306.0	3,681,732,801.28	0.4548
				2021	54.2200	1.0000	54.2200	86,356,226.0	4,682,234,573.72	0.6703
				2022	35.9200	1.0000	35.9200	81,280,625.0	2,919,600,050.00	0.4050
				2023	39.9900	1.0000	39.9900	72,420,073.0	2,896,078,719.27	0.4024
0001468174	Hyatt Hotels Corp	Hyatt H	H	2011	37.5500	1.0000	37.5500	44,680,334.0	1,677,746,541.70	0.3294
				2012	38.3100	1.0000	38.3100	45,387,810.0	1,738,807,001.10	0.3329
				2014	60.0800	1.0000	60.0800	39,277,514.0	2,359,793,041.12	0.4050
				2015	48.1600	1.0000	48.1600	29,197,002.0	1,406,127,616.32	0.2511
				2016	56.4300	1.0000	56.4300	23,611,575.0	1,332,401,177.25	0.2299
				2017	72.8300	1.0000	72.8300	47,464,707.0	3,456,854,610.81	0.5858
				2018	66.9900	1.0000	66.9900	42,768,452.0	2,865,058,599.48	0.4936
				2019	89.6000	1.0000	89.6000	36,582,951.0	3,277,832,409.60	0.5095
				2020	72.9300	1.0000	72.9300	38,479,041.0	2,806,276,460.13	0.3731
				2021	94.3200	1.0000	94.3200	50,301,183.0	4,744,407,580.56	0.4385
				2022	90.7900	1.0000	90.7900	48,101,088.0	4,367,097,779.52	0.4175
				2023	130.5100	1.0000	130.5100	44,221,190.0	5,771,307,506.90	0.5223
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	53.5500	0.4870	26.0800	984,617,365.0	25,678,820,879.20	1.0803
				2015	44.6700	0.4870	21.7500	987,451,862.0	21,477,077,998.50	0.9447
				2016	56.3100	0.4870	27.4200	989,783,195.0	27,139,855,206.90	1.1655
				2020	106.7000	1.0000	106.7000	277,446,309.0	29,603,521,170.30	1.6918
				2021	154.8500	1.0000	154.8500	278,721,682.0	43,160,052,457.70	2.7229
				2022	126.4000	1.0000	126.4000	270,456,017.0	34,185,640,548.80	2.1284
				2023	181.3600	1.0000	181.3600	256,440,305.0	46,508,013,714.80	2.8060
0001590584	Civeo Corp	Civeo C	CVEO	2014	96.4200	0.0830	8.0000	106,733,659.0	853,869,272.00	0.6105
				2015	18.1800	0.0830	1.5100	107,465,397.0	162,272,749.47	0.2054
				2016	27.5400	0.0830	2.2900	108,098,786.0	247,546,219.94	0.3675
				2017	28.3200	0.0830	2.3500	132,259,000.0	310,808,650.00	0.5049
				2018	15.9000	0.0830	1.3200	167,970,631.0	221,721,232.92	0.3020
				2019	15.8400	0.0830	1.3100	169,549,135.0	222,109,366.85	0.3077
				2020	15.2800	1.0000	15.2800	170,582,021.0	2,606,493,280.88	4.7119
				2021	18.7600	1.0000	18.7600	14,250,180.0	267,333,376.80	0.5441
				2022	30.5900	1.0000	30.5900	13,712,661.0	419,470,299.99	1.0124
				2023	22.9100	1.0000	22.9100	14,745,906.0	337,828,706.46	0.8742
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
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	International Endeavors Corp	Interna	nan	2016	nan	nan	nan	nan	nan	nan
0001616000	Xenia Hotels Resorts Inc	Xenia H	XHR	2017	22.1100	1.0000	22.1100	106,729,984.0	2,359,799,946.24	1.0290
				2018	17.2400	1.0000	17.2400	112,559,248.0	1,940,521,435.52	0.8646
				2019	21.8000	1.0000	21.8000	112,641,568.0	2,455,586,182.40	1.0340
				2020	15.0000	1.0000	15.0000	113,730,716.0	1,705,960,740.00	0.7430
				2021	18.0300	1.0000	18.0300	114,209,134.0	2,059,190,686.02	0.8697
				2022	13.1400	1.0000	13.1400	113,847,779.0	1,495,959,816.06	0.6363
				2023	13.6100	1.0000	13.6100	105,201,059.0	1,431,786,412.99	0.6384
0001617406	Park Hotels Resorts Inc	Park Ho	PK	2020	17.1500	1.0000	17.1500	235,612,787.0	4,040,759,297.05	0.4950
				2021	19.0100	1.0000	19.0100	236,479,179.0	4,495,469,192.79	0.5963
				2022	11.7200	1.0000	11.7200	224,843,229.0	2,635,162,643.88	0.3472
				2023	16.3900	1.0000	16.3900	209,983,724.0	3,441,633,236.36	0.4568
0001653653	Red Rock Resorts Inc	Red Roc	RRR	2016	23.1900	1.0000	23.1900	41,468,746.0	961,660,219.74	0.2996
				2017	34.0200	1.0000	34.0200	68,728,266.0	2,338,135,609.32	0.7083
				2019	23.9700	1.0000	23.9700	70,321,959.0	1,685,617,357.23	0.4528
				2020	24.7500	1.0000	24.7500	71,216,902.0	1,762,618,324.50	0.5126
				2021	52.6500	1.0000	52.6500	68,696,282.0	3,616,859,247.30	1.1610
				2022	40.1900	1.0000	40.1900	58,000,419.0	2,331,036,839.61	0.7001
				2023	53.0200	1.0000	53.0200	58,398,749.0	3,096,301,671.98	0.8080
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
0001692412	Playa Hotels Resorts N V	Playa H	PLYA	2017	10.8200	1.0000	10.8200	110,305,064.0	1,193,500,792.48	0.8296
				2018	6.9700	1.0000	6.9700	130,478,993.0	909,438,581.21	0.5306
				2019	8.0300	1.0000	8.0300	129,351,389.0	1,038,691,653.67	0.5792
				2020	5.4300	1.0000	5.4300	134,496,340.0	730,315,126.20	0.4031
				2021	7.6400	1.0000	7.6400	164,220,739.0	1,254,646,445.96	0.7206
				2022	6.1100	1.0000	6.1100	162,387,308.0	992,186,451.88	0.5711
				2023	8.6000	1.0000	8.6000	138,454,910.0	1,190,712,226.00	0.7185
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	88.3200	1.0000	88.3200	93,177,853.0	8,229,467,976.96	2.2097
				2022	69.7900	1.0000	69.7900	88,324,241.0	6,164,148,779.39	1.6926
				2023	79.6700	1.0000	79.6700	82,961,907.0	6,609,575,130.69	1.8058
0001723177	Syndicated Resorts Association Inc	Syndica	nan	2018	nan	nan	nan	nan	nan	nan
0001723177	Syndicated Resorts Association Inc	Syndica	nan	2019	nan	nan	nan	nan	nan	nan
0001747079	Bally s Corp	Bally s	BALY	2019	nan	1.0000	nan	34,233,501.0	nan	nan
				2020	nan	1.0000	nan	30,476,057.0	nan	nan
				2021	nan	1.0000	nan	54,363,371.0	nan	nan
				2022	nan	1.0000	nan	47,261,307.0	nan	nan
				2023	nan	1.0000	nan	45,622,485.0	nan	nan
0001819395	Sonder Holdings Inc	Sonder	SOND	2021	199.0000	0.0500	9.9500	45,000,000.0	447,750,000.00	1.7805
				2022	24.4000	0.0500	1.2200	218,058,524.0	266,031,399.28	0.1680
				2023	3.4500	1.0000	3.4500	11,064,738.0	38,173,346.10	0.0223

QA: us_hotels 2009-2023

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