QA: us_construction 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
0000906163	NVR INC	NVR INC	NaN	1	4	11	14	12	11	11	6	1	1	2	1	1	1	NaN	171.191240	166.768250	109.051730	103.989880	100.434870	111.184370	113.337080	128.195300	632.547950	581.385750	388.306180	425.431200	550.132750	477.034940	NaN	3	7	3	-2	-1	0	-5	-5	0	1	-1	0	0
0001682265	Reliant Holdings Inc	Reliant	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42	10	4	1	47	16	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-121.337350	112.213710	157.160560	642.541870	-175.909210	100.338020	410.530890	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-32	-6	-3	46	-31	-14
0000822416	Pultegroup INC Mi	Pultegr	NaN	14	36	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	4	4	3	NaN	8.416378	31.786935	51.439509	NaN	NaN	NaN	NaN	NaN	NaN	NaN	275.036270	310.649280	337.165070	334.520260	NaN	22	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	0	-1
0000773141	M D C Holdings INC	M D C H	NaN	12	26	24	NaN	NaN	NaN	22	22	NaN	NaN	3	3	3	4	NaN	49.988377	58.651443	68.320790	NaN	NaN	NaN	77.563718	74.964988	NaN	NaN	325.453010	323.484040	341.429570	299.950640	NaN	14	-2	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	0	0	1
0001561680	Tri Pointe Homes Inc	Tri Poi	NaN	NaN	NaN	NaN	NaN	17	15	NaN	NaN	NaN	NaN	5	5	5	5	NaN	NaN	NaN	NaN	NaN	85.216959	101.140760	NaN	NaN	NaN	NaN	258.636950	285.732950	299.491290	287.303510	NaN	NaN	NaN	NaN	NaN	-2	NaN	NaN	NaN	NaN	NaN	0	0	0
0001576940	Century Communities Inc	Century	NaN	NaN	NaN	NaN	NaN	13	23	20	24	25	17	20	2	2	6	NaN	NaN	NaN	NaN	NaN	92.966791	76.409817	82.535942	68.808157	63.886240	72.586341	83.746479	323.683810	345.030210	281.023790	NaN	NaN	NaN	NaN	NaN	10	-3	4	1	-8	3	-18	0	4
0001373670	Green Brick Partners Inc	Green B	NaN	NaN	34	37	NaN	11	3	4	5	8	8	11	11	7	7	NaN	NaN	39.180726	-7.688811	NaN	102.579590	165.326630	154.970910	138.089310	127.790740	124.977600	148.343790	146.279460	167.278750	171.933850	NaN	NaN	3	NaN	NaN	-8	1	1	3	0	3	0	-4	0
0000882184	Horton D R INC De	Horton	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	6	12	10	8	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	138.242180	141.263940	141.825810	152.277530	162.616620	167.661970	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	6	-2	-2	0
0000052988	Jacobs Engineering Group Inc	Jacobs	NaN	3	8	6	5	4	4	5	4	5	NaN	9	9	9	9	NaN	147.259380	129.637200	152.379610	152.465730	141.132370	147.389410	146.870360	146.088310	141.602610	NaN	154.202000	158.788880	159.302250	158.544570	NaN	5	-2	-1	-1	0	1	-1	1	NaN	NaN	0	0	0
0001488139	Ameresco Inc	Ameresc	NaN	NaN	NaN	28	8	3	6	6	3	3	5	8	7	10	10	NaN	NaN	NaN	61.680546	150.989320	148.010940	138.721090	146.484910	162.952120	166.886940	149.196220	157.634560	160.412700	139.158060	146.199380	NaN	NaN	NaN	-20	-5	3	0	-3	0	2	3	-1	3	0
0000799292	M I Homes INC	M I Hom	NaN	NaN	31	27	16	21	29	26	27	20	12	17	14	11	11	NaN	NaN	48.843571	62.155279	96.858813	76.683882	70.045836	70.238311	66.594647	74.066120	86.498476	93.354170	106.211960	121.687850	135.096880	NaN	NaN	-4	-11	5	8	-3	1	-7	-8	5	-3	-3	0
0000794170	Toll Brothers Inc	Toll Br	NaN	6	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	20	17	12	NaN	76.118028	81.857530	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	75.520481	86.393435	99.901494	113.013680	NaN	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	-3	-5
0000861459	Granite Construction INC	Granite	NaN	4	NaN	NaN	NaN	NaN	5	7	8	7	NaN	19	18	13	13	NaN	117.808550	NaN	NaN	NaN	NaN	140.134280	132.984480	121.795740	137.550900	NaN	83.781874	93.490722	117.018730	111.003200	NaN	NaN	NaN	NaN	NaN	NaN	2	1	-1	NaN	NaN	-1	-5	0
0000920760	Lennar Corp NEW	Lennar	NaN	11	30	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	NaN	55.184939	51.724388	71.360019	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	110.438210	NaN	19	-8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000100591	Argan INC	Argan I	NaN	NaN	5	16	15	10	16	12	12	4	2	14	17	14	15	NaN	NaN	155.253890	85.813886	100.727780	105.914400	91.858727	111.284180	94.036356	149.517160	195.676480	101.551980	94.178448	112.899640	110.244400	NaN	NaN	11	-1	-5	6	-4	0	-8	-2	12	3	-3	1
0001048268	IES Holdings Inc	IES Hol	NaN	NaN	37	NaN	NaN	26	18	3	11	19	9	15	16	26	16	NaN	NaN	5.671356	NaN	NaN	70.877738	83.284654	167.772060	99.180149	75.749696	108.601980	96.099529	94.610637	70.764807	106.541460	NaN	NaN	NaN	NaN	NaN	-8	-15	8	8	-10	6	1	10	-10
0001633931	Topbuild Corp	Topbuil	NaN	NaN	NaN	NaN	NaN	NaN	14	14	9	18	15	18	26	19	17	NaN	NaN	NaN	NaN	NaN	NaN	101.356010	104.267120	114.497470	77.115640	82.445240	93.274060	71.490201	87.811197	104.486160	NaN	NaN	NaN	NaN	NaN	NaN	0	-5	9	-3	3	8	-7	-2
0001580670	LGI Homes Inc	LGI Hom	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19	14	12	10	10	12	15	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	85.307881	91.800637	96.734701	103.978180	150.253490	143.358340	107.512870	100.879400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	-2	-2	0	2	3	3
0000833079	Meritage Homes Corp	Meritag	NaN	NaN	28	19	21	15	19	17	18	32	20	30	27	22	19	NaN	NaN	54.272748	80.533454	75.431422	87.199651	81.786253	87.726378	84.447573	51.029591	63.133245	65.582466	70.318302	83.291345	98.446834	NaN	NaN	-9	2	-6	4	-2	1	14	-12	10	-3	-5	-3
0001124198	Fluor Corp	Fluor C	2	5	13	13	10	9	10	15	NaN	11	31	27	36	18	20	110.305640	99.082929	105.044430	97.653788	118.872090	112.667680	118.656350	103.453900	NaN	105.074120	35.843460	66.198451	57.048724	88.069003	93.680446	3	8	0	-3	-1	1	5	NaN	NaN	20	-4	9	-18	2
0001785493	Phoenix Plus Corp	Phoenix	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	8	21	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	62.017677	160.327730	83.645820	89.684835	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-26	13	0
0001825088	Dream Finders Homes Inc	Dream F	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39	25	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.783108	70.953134	88.557375	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-14	-3
0000915840	Beazer Homes USA INC	Beazer	NaN	NaN	38	NaN	38	NaN	NaN	33	34	NaN	NaN	40	34	23	23	NaN	NaN	-6.835082	NaN	11.606945	NaN	NaN	40.640333	45.206722	NaN	NaN	45.559435	61.432175	82.802401	83.717983	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	-6	-11	0
0001035983	Comfort Systems USA INC	Comfort	NaN	NaN	25	18	17	20	13	13	16	13	18	23	32	24	24	NaN	NaN	58.850792	81.313692	93.126861	83.726601	102.913880	105.738870	86.520027	95.301312	72.504837	75.975454	65.628303	75.819090	76.808618	NaN	NaN	-7	-1	3	-7	0	3	-3	5	5	9	-8	0
0001721386	Landsea Homes Corp	Landsea	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	23	20	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	187.374800	85.167870	87.777780	75.386788	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	-3	5
0000105634	Emcor Group Inc	Emcor G	NaN	10	20	20	22	23	25	28	21	17	16	31	25	29	26	NaN	55.388087	70.176410	75.387542	71.511412	72.624436	72.120583	66.585631	74.983927	78.369920	77.722529	64.325519	76.650052	65.945203	74.073771	NaN	10	0	2	1	2	3	-7	-4	-1	15	-6	4	-3
0000700923	MYR Group INC	MYR Gro	NaN	NaN	15	12	12	8	9	23	20	21	23	22	19	27	27	NaN	NaN	92.641453	104.836510	107.132750	122.101970	119.596490	77.460855	80.410019	73.493173	59.013548	76.959465	87.175604	70.621607	73.155486	NaN	NaN	-3	0	-4	1	14	-3	1	2	-1	-3	8	0
0001580905	Installed Building Products Inc	Install	NaN	NaN	NaN	NaN	NaN	27	33	29	32	34	29	36	43	31	28	NaN	NaN	NaN	NaN	NaN	69.573564	56.560014	63.846318	49.985809	41.240815	41.401367	52.427754	48.369834	65.210669	72.774990	NaN	NaN	NaN	NaN	NaN	6	-4	3	2	-5	7	7	-12	-3
0001606163	Limbach Holdings Inc	Limbach	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	35	36	34	45	41	37	29	NaN	NaN	NaN	NaN	NaN	NaN	226.891500	NaN	35.869302	21.938872	21.522596	30.809240	50.825196	49.673251	72.374709	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	-2	11	-4	-4	-8
0001718227	Construction Partners Inc	Constru	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	7	13	24	28	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	125.900430	131.258780	118.519030	84.629264	67.044452	71.347310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	6	11	4	2
0000067215	Dycom Industries INC	Dycom I	NaN	NaN	NaN	15	27	29	27	30	26	NaN	21	33	33	33	31	NaN	NaN	NaN	91.138856	61.549450	67.565081	70.558844	60.488381	67.429298	NaN	61.507104	62.090072	65.077047	55.488337	66.881820	NaN	NaN	NaN	12	2	-2	3	-4	NaN	NaN	12	0	0	-2
0000874238	Sterling Infrastructure Inc	Sterlin	NaN	NaN	11	5	37	30	35	32	31	27	30	39	42	32	32	NaN	NaN	110.952630	159.102240	15.243146	65.537517	36.957579	45.368596	50.552850	63.443320	38.403634	46.663510	50.696314	61.698559	65.948526	NaN	NaN	-6	32	-7	5	-3	-1	-4	3	9	3	-10	0
0001050915	Quanta Services INC	Quanta	1	2	6	7	6	5	12	10	10	16	13	16	31	30	33	152.027060	157.194880	139.267680	151.716650	152.345760	141.005000	108.608360	115.304940	109.480870	87.723021	86.425038	93.799602	65.916271	65.734242	65.834690	1	4	1	-1	-1	7	-2	0	6	-3	3	15	-1	3
0001703956	Concrete Pumping Holdings Inc	Concret	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	43	45	35	34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38.492430	47.921468	53.298260	60.368310	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-10	-1
0001796209	APi Group Corp	APi Gro	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	38	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	69.773108	49.569543	55.450049	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	-3
0001361538	Primoris Services Corp	Primori	NaN	NaN	19	26	24	25	28	27	19	24	25	32	30	36	36	NaN	NaN	71.309165	63.777616	69.631388	72.129321	70.277208	68.025079	80.708048	65.681976	57.843689	62.873893	65.940921	50.713643	51.605698	NaN	NaN	7	-2	1	3	-1	-8	5	1	7	-2	6	0
0000357294	Hovnanian Enterprises INC	Hovnani	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37	44	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	56.750094	35.391060	47.010132	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-7
0001357971	Energy Services Of America Corp	Energy	NaN	NaN	23	39	29	18	24	25	33	22	NaN	24	15	34	38	NaN	NaN	65.177132	-136.980160	54.555278	84.361791	74.280947	70.455990	49.516497	72.946498	NaN	75.608159	106.142010	54.774615	42.387780	NaN	NaN	16	-10	-11	6	1	8	-11	NaN	NaN	-9	19	4
0000015615	Mastec INC	Mastec	NaN	NaN	21	29	28	NaN	NaN	NaN	25	30	19	26	35	43	39	NaN	NaN	67.229079	60.134832	59.130042	NaN	NaN	NaN	67.871099	55.330088	67.131665	68.104922	60.502623	41.185092	38.310650	NaN	NaN	8	-1	NaN	NaN	NaN	NaN	5	-11	7	9	8	-4
0000077543	Tutor Perini Corp	Tutor P	NaN	NaN	12	17	NaN	NaN	34	31	28	26	33	38	38	45	40	NaN	NaN	108.894860	85.093994	NaN	NaN	51.803002	60.278595	65.801256	63.830835	26.731465	47.118083	55.093303	34.472331	32.584607	NaN	NaN	5	NaN	NaN	NaN	-3	-3	-2	7	5	0	7	-5
0001402829	Orion Group Holdings Inc	Orion G	NaN	NaN	NaN	10	9	7	26	24	17	37	28	29	40	41	41	NaN	NaN	NaN	117.493060	137.721480	122.520570	71.107129	76.533634	84.673970	-0.413050	46.053194	65.787989	53.076305	46.194364	30.781428	NaN	NaN	NaN	-1	-2	19	-2	-7	20	-9	1	11	1	0
0001357615	KBR INC.	KBR INC	3	7	18	23	19	40	32	37	23	28	26	44	46	39	42	91.391122	74.397798	81.513252	70.071152	80.193197	-31.807584	56.655232	15.234655	74.938306	60.437901	55.154323	34.176411	40.916332	46.873579	23.169988	4	11	5	-4	21	-8	5	-14	5	-2	18	2	-7	3
0001784567	Harbor Custom Development Inc	Harbor	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	46	13	46	43	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.819341	109.483380	29.251196	-67.840537	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-33	33	-3
0001374881	Kingfish Holding Corp	Kingfis	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51	44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-359.944500	-336.305660	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7
0001130385	Foster Wheeler Ag	Foster	4	9	29	33	30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	59.796341	61.679958	52.241792	47.040099	49.235710	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	20	4	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000085974	Ryland Group INC	Ryland	NaN	13	35	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36.631309	35.337047	40.722395	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001027884	Chicago Bridge Iron Co N V	Chicago	NaN	8	22	30	31	34	38	35	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	67.735514	66.790089	58.548565	45.944184	53.433027	20.497322	17.544235	-37.525382	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	8	1	3	4	-3	6	NaN	NaN	NaN	NaN	NaN	NaN
0000042316	Goldfield Corp	Goldfie	NaN	NaN	14	9	26	33	22	9	7	14	11	NaN	NaN	NaN	NaN	NaN	NaN	101.950570	120.980760	68.777179	54.373654	76.731700	117.183520	122.582350	94.193184	91.948464	NaN	NaN	NaN	NaN	NaN	NaN	-5	17	7	-11	-13	-2	7	-3	NaN	NaN	NaN	NaN
0000054441	Furmanite Corp	Furmani	NaN	NaN	2	4	3	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	184.578690	162.043050	162.179550	164.215060	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-1	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000080035	Preformed Line Products Co	Preform	NaN	NaN	1	1	2	1	2	2	2	2	3	7	6	6	NaN	NaN	NaN	186.144440	190.649600	185.905380	172.822540	165.408910	179.135610	177.605640	173.478920	175.522520	166.077430	168.559250	179.466140	NaN	NaN	NaN	0	1	-1	1	0	0	0	1	4	-1	0	NaN
0000866273	Matrix Service Co	Matrix	NaN	NaN	7	8	11	14	20	16	15	15	NaN	NaN	22	40	NaN	NaN	NaN	134.429620	131.166610	109.250330	91.327771	80.686357	101.392110	87.701147	87.727463	NaN	NaN	85.595996	46.206096	NaN	NaN	NaN	1	3	3	6	-4	-1	0	NaN	NaN	NaN	18	NaN
0000888504	Layne Christensen Co	Layne C	NaN	NaN	10	21	25	37	40	36	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	113.098770	73.844311	69.069588	20.711484	4.007884	16.022760	1.517088	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	4	12	3	-4	2	NaN	NaN	NaN	NaN	NaN	NaN
0001065860	Lime Energy Co	Lime En	NaN	NaN	32	38	40	31	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41.667433	-62.205406	-59.382902	64.233714	25.788344	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	2	-9	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001082198	Pernix Group Inc	Pernix	NaN	NaN	33	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41.077874	91.406861	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001317577	Pike Corp	Pike Co	NaN	NaN	3	2	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	169.199320	178.625090	192.280780	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001372020	Great Lakes Dredge Dock Corp	Great L	NaN	NaN	27	34	35	35	36	34	37	35	27	28	29	42	NaN	NaN	NaN	57.542364	45.174011	30.081013	41.124329	36.180932	35.597790	28.128077	37.727294	54.632938	66.064816	68.734353	46.040258	NaN	NaN	NaN	7	1	0	1	-2	3	-2	-8	1	1	13	NaN
0001392363	China Advanced Construction Materials Group Inc	China A	NaN	NaN	9	25	36	39	NaN	40	39	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	125.254990	66.128933	21.746402	13.630097	NaN	-6.567228	-10.994312	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	11	3	NaN	NaN	-1	NaN	NaN	NaN	NaN	NaN	NaN
0001425565	Real Goods Solar Inc	Real Go	NaN	NaN	16	40	39	41	42	42	43	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	86.692795	-193.472630	-37.980139	-280.993760	-114.243820	-324.381690	-213.176200	-562.516150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24	-1	2	1	0	1	-2	NaN	NaN	NaN	NaN	NaN
0001501162	Annec Green Refractories Corp	Annec G	NaN	NaN	24	31	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	60.048962	57.727492	32.718880	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000039677	Av Homes Inc	Av Home	NaN	NaN	NaN	36	13	32	31	8	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22.268480	106.228830	62.650309	62.733056	126.925170	58.262539	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-23	19	-1	-23	21	NaN	NaN	NaN	NaN	NaN	NaN
0001136294	Nos4 1 Inc	Nos4 1	NaN	NaN	NaN	3	7	6	NaN	39	40	38	32	41	44	47	NaN	NaN	NaN	NaN	164.488530	152.089090	134.161750	NaN	12.201593	-36.360040	-29.827699	29.324144	44.338429	47.979520	4.252178	NaN	NaN	NaN	NaN	4	-1	NaN	NaN	1	-2	-6	9	3	3	NaN
0001172069	P2 Solar Inc	P2 Sola	NaN	NaN	NaN	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49	NaN	NaN	NaN	NaN	-10356.274000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-251.736800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000353020	Aegion Corp	Aegion	NaN	NaN	NaN	NaN	18	28	30	21	30	23	22	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	91.083324	67.967359	68.191708	78.935688	56.820099	70.776629	61.192465	60.487039	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	2	-9	9	-7	-1	13	NaN	NaN	NaN
0001303330	China Housing Land Development Inc	China H	NaN	NaN	NaN	NaN	32	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33.693437	15.866743	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001408356	Solarcity Corp	Solarci	NaN	NaN	NaN	NaN	34	36	39	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.164184	23.001105	10.384292	15.055920	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	3	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001510832	Biopower Operations Corp	Biopowe	NaN	NaN	NaN	NaN	41	44	43	NaN	NaN	NaN	NaN	NaN	49	50	NaN	NaN	NaN	NaN	NaN	-808.905280	-555.977960	-424.803450	NaN	NaN	NaN	NaN	NaN	-251.619760	-277.387970	NaN	NaN	NaN	NaN	NaN	3	-1	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN
0001562476	Taylor Morrison Home Corp	Taylor	NaN	NaN	NaN	NaN	23	24	21	18	13	NaN	14	21	21	12	NaN	NaN	NaN	NaN	NaN	70.196468	72.352882	80.434928	87.003349	93.775855	NaN	85.528925	81.143774	85.804446	117.701920	NaN	NaN	NaN	NaN	NaN	1	-3	-3	-5	NaN	NaN	7	0	-9	NaN
0001571274	Continental Cement Company L L C	Contine	NaN	NaN	NaN	NaN	20	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	77.131281	73.282002	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001572684	UCP Inc.	UCP Inc	NaN	NaN	NaN	NaN	4	16	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	155.937110	86.066927	84.329657	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001300938	Abco Energy Inc	Abco En	NaN	NaN	NaN	NaN	NaN	42	41	44	46	39	35	47	48	48	NaN	NaN	NaN	NaN	NaN	NaN	-323.771480	-107.253110	-547.690240	-343.683860	-238.194550	-278.978780	-171.554700	-194.563990	-113.771200	NaN	NaN	NaN	NaN	NaN	NaN	-1	3	2	-7	-4	12	1	0	NaN
0001539551	Sports Field Holdings INC	Sports	NaN	NaN	NaN	NaN	NaN	45	44	43	45	40	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1051.576900	-529.964590	-425.849360	-265.326670	-323.990220	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	-1	2	-5	NaN	NaN	NaN	NaN	NaN
0001566265	Axiom Corp	Axiom C	NaN	NaN	NaN	NaN	NaN	43	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-451.442130	-541.088500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001574596	New Home Co Inc	New Hom	NaN	NaN	NaN	NaN	NaN	19	8	NaN	NaN	NaN	NaN	42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	84.347250	122.526490	NaN	NaN	NaN	NaN	43.204402	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000814046	ALP Liquidating Trust	ALP Liq	NaN	NaN	NaN	NaN	NaN	NaN	7	1	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	122.936650	181.357880	197.605660	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	0	NaN	NaN	NaN	NaN	NaN	NaN
0001634424	Powercomm Holdings Inc	Powerco	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41	36	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-142.487850	34.346559	52.905842	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	-5	NaN	NaN	NaN	NaN	NaN
0001561257	Helpful Alliance Co	Helpful	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-260.540260	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001095996	William Lyon Homes	William	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	56.883703	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001723866	Select Interior Concepts Inc	Select	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33	24	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49.215695	58.680505	49.287176	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	13	NaN	NaN	NaN
0001534155	Ameri Metro Inc Formerly Yellowwood	Ameri M	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36	48	50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-305.568000	-289.095480	-268.375230	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	2	NaN	NaN
0000894501	Gold Rock Holdings INC	Gold Ro	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2854.161000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

PDF reports

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

2009

Logs

warning	15 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0001050915 0001124198 0001130385 0001357615 0000052988 0000105634 0000822416 0000861459 0000906163 0000920760 0001027884 0000085974 0000773141 0000794170 0000795266
warning	2 × Zero effects	check_effects	{'var_name': 'NotesAndLoansPayable', 'zeros': '4 of 4'} {'var_name': 'Inventory', 'zeros': '4 of 4'}
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000906163 0000920760
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001130385 0000920760
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000920760
warning	1 × Missing logo	subcommand.report	0001130385
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0000795266

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	LiabilitiesCurrent	712,210,000	823,389,850	1,925,487,577	3,165,738,300	3,301,398,000	0001050915	0001357615	0001124198
1	LiabilitiesNonCurrent	0	0	0	378,912,150	445,779,000	0001050915	0001357615	0001130385
2	NotesAndLoansPayable	0	0	0	0	0	0001050915	0001130385	0001050915
3	remainder_Liabilities	0	44,127,450	354,874,393	601,223,950	634,000,000	0001124198	0001130385	0001357615
4	AssetsCurrent	1,582,792,000	1,636,606,450	2,791,787,334	4,899,924,800	5,122,088,000	0001050915	0001357615	0001124198
5	AssetsNonCurrent	45,345,000	50,693,250	82,246,247	87,137,500	87,781,000	0001050915	0001124198	0001130385
6	Inventory	0	0	0	0	0	0001050915	0001130385	0001050915
7	Goodwill	88,056,000	99,107,250	455,541,681	1,501,573,000	1,634,380,000	0001124198	0001357615	0001050915
8	CashAndCashEquivalentsAtCarryingValue	699,629,000	735,834,650	969,095,847	1,583,547,500	1,687,028,000	0001050915	0001130385	0001124198
9	remainder_Assets	-85,000,000	-72,323,050	77,207,088	191,368,200	197,820,000	0001357615	0001050915	0001124198
10	remainder_Expenses	93,762,000	553,317,900	7,281,707,060	19,778,958,700	21,257,422,000	0001130385	0001357615	0001124198
11	remainder_Revenues	0	497,718,900	7,714,199,062	20,507,502,450	21,990,297,000	0001130385	0001357615	0001124198
12	remainder_NetIncome	-4,000,000	-3,400,000	1,439,363	387,283,550	455,120,000	0001357615	0001050915	0001130385
13	remainder_ComprehensiveNetIncome	-79,000,000	-67,150,000	0	0	0	0001357615	0001124198	0001050915

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,006,393,000	1,202,636,200	2,673,055,396	3,260,838,300	3,301,398,000	0001050915	0001357615	0001124198
1	Assets	3,187,738,000	3,327,120,400	4,722,340,014	6,900,760,550	7,178,483,000	0001130385	0001357615	0001124198
2	Expenses	93,762,000	553,317,900	7,281,707,060	19,778,958,700	21,257,422,000	0001130385	0001357615	0001124198
3	Revenues	0	497,718,900	7,714,199,062	20,507,502,450	21,990,297,000	0001130385	0001357615	0001124198
4	StockholdersEquity	873,057,000	1,086,498,450	2,703,524,868	3,762,106,400	3,877,085,000	0001130385	0001050915	0001124198
5	NetIncome	163,535,000	193,208,450	530,780,593	727,943,750	732,875,000	0001050915	0001357615	0001124198
6	ComprehensiveNetIncome	163,535,000	193,208,450	511,018,743	722,018,750	732,875,000	0001050915	0001357615	0001124198
7	BaseVar	3,231,481,250	3,981,309,406	16,529,832,024	40,342,346,681	43,081,694,625	0001130385	0001357615	0001124198
8	EconomicCapitalRatio	0.598	0.645	1.01	1.46	1.52	0001130385	0001124198	0001050915

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	LiabilitiesCurrent	-0.556	-0.399	0.557	0.946	1.00	0001130385	0001357615	0001124198
1	LiabilitiesNonCurrent	-0.189	-0.130	0.251	0.406	0.425	0001130385	0001357615	0001124198
2	NotesAndLoansPayable	0	0	0	0	0	0001050915	0001130385	0001050915
3	remainder_Liabilities	-0.146	-0.113	0.134	0.505	0.559	0001130385	0001357615	0001124198
4	AssetsCurrent	-0.456	-0.442	-0.224	0.348	0.424	0001124198	0001050915	0001130385
5	AssetsNonCurrent	-0.0365	-0.0349	-0.0152	0.0146	0.0181	0001124198	0001050915	0001130385
6	Inventory	0	0	0	0	0	0001050915	0001130385	0001050915
7	Goodwill	-0.266	-0.249	-0.0847	0.174	0.208	0001124198	0001130385	0001050915
8	CashAndCashEquivalentsAtCarryingValue	-0.297	-0.293	-0.154	0.179	0.217	0001124198	0001050915	0001130385
9	remainder_Assets	-0.0341	-0.0298	-0.00348	0.0152	0.0182	0001357615	0001124198	0001050915
10	remainder_Expenses	-2.19	-2.04	-0.732	0.510	0.642	0001124198	0001050915	0001130385
11	remainder_Revenues	-0.720	-0.568	0.863	2.17	2.30	0001130385	0001357615	0001124198
12	remainder_NetIncome	-0.507	-0.486	-0.282	0.155	0.217	0001124198	0001050915	0001130385
13	remainder_ComprehensiveNetIncome	-0.0124	-0.0104	0.00153	0.00520	0.00572	0001357615	0001050915	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.07	-0.806	0.815	1.39	1.47	0001130385	0001357615	0001124198
1	Assets	-0.672	-0.662	-0.278	0.649	0.756	0001124198	0001050915	0001130385
2	Expenses	-2.19	-2.04	-0.732	0.510	0.642	0001124198	0001050915	0001130385
3	Revenues	-0.720	-0.568	0.863	2.17	2.30	0001130385	0001357615	0001124198
4	StockholdersEquity	-1.12	-1.07	-0.354	0.552	0.635	0001124198	0001130385	0001050915
5	NetIncome	-0.392	-0.358	-0.152	0.0976	0.139	0001124198	0001050915	0001130385
6	ComprehensiveNetIncome	-0.386	-0.355	-0.157	0.0986	0.140	0001124198	0001050915	0001130385
7	BaseVar	nan	nan	nan	nan	nan	0001050915	0001130385	0001050915
8	EconomicCapitalRatio	-0.436	-0.388	-0.0253	0.424	0.486	0001130385	0001124198	0001050915

2010

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001436624 0001436624
error	1 × Negative Expenses, ignoring company.	pre-agg	0000882184
warning	18 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000822416 0000861459 0000906163 0000920760 0001027884 0001050915 0001124198 0001130385 0001357615 0000085974 0000773141 0000794170 0000795266 0001501162 0000814046 0001392363
warning	14 × The stock price does not exist	industry.us_generic	0001027884 0001130385 0000085974 0000773141 0000795266 0000042316 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001425565 0000357294
warning	9 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000882184
warning	9 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000882184
warning	6 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0000920760 0001130385 0000882184
warning	5 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000814046
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0000920760
warning	3 × Missing logo	subcommand.report	0000920760 0001130385 0000085974
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000920760 0001436624
warning	1 × Ignoring company because Assets is zero	pre-agg	0000357294

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	LiabilitiesCurrent	0	0	600,855,311	2,844,534,050	3,523,383,000	0000085974	0001050915	0001124198
1	LiabilitiesNonCurrent	0	0	0	111,627,600	318,936,000	0000052988	0000906163	0001130385
2	NotesAndLoansPayable	0	0	0	2,190,755,300	3,391,668,000	0000052988	0001050915	0000822416
3	remainder_Liabilities	0	0	347,132,566	3,369,865,450	5,593,468,000	0000052988	0001130385	0000920760
4	AssetsCurrent	0	0	1,058,546,219	4,067,288,750	5,562,825,000	0000085974	0001027884	0001124198
5	AssetsNonCurrent	0	0	48,366,615	305,522,950	582,954,000	0000085974	0001027884	0000052988
6	Inventory	0	0	0	3,780,755,800	4,781,813,000	0000052988	0001050915	0000822416
7	Goodwill	0	0	121,505,279	1,341,605,550	1,755,222,000	0000085974	0001130385	0001050915
8	CashAndCashEquivalentsAtCarryingValue	226,647,000	243,140,750	862,619,695	1,703,155,200	2,134,997,000	0000085974	0000052988	0001124198
9	remainder_Assets	-723,810,000	-653,740,000	324,497,081	3,871,904,200	7,393,716,000	0000052988	0001050915	0000920760
10	remainder_Expenses	116,388,000	723,640,100	3,613,637,287	13,435,543,450	20,408,267,000	0000906163	0001050915	0001124198
11	remainder_Revenues	0	0	3,787,143,570	13,861,622,150	20,849,349,000	0000794170	0001050915	0001124198
12	remainder_NetIncome	-729,943,000	-270,430,050	5,314,281	752,707,500	1,551,863,000	0000822416	0000105634	0000794170
13	remainder_ComprehensiveNetIncome	-74,539,000	-54,038,650	0	255,500	730,000	0000052988	0000861459	0000822416

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	438,777,000	491,368,500	1,709,495,890	5,574,449,650	5,593,468,000	0000861459	0001027884	0000920760
1	Assets	1,535,533,000	1,611,693,500	3,714,010,475	8,080,342,250	8,787,851,000	0000861459	0001050915	0000920760
2	Expenses	116,388,000	723,640,100	3,613,637,287	13,435,543,450	20,408,267,000	0000906163	0001050915	0001124198
3	Revenues	0	0	3,787,143,570	13,861,622,150	20,849,349,000	0000794170	0001050915	0001124198
4	StockholdersEquity	561,662,000	835,975,650	1,938,283,731	3,670,940,600	4,091,540,000	0000085974	0000822416	0001124198
5	NetIncome	-1,096,729,000	-439,195,500	152,836,093	411,128,700	441,082,000	0000822416	0001050915	0001124198
6	ComprehensiveNetIncome	-1,096,364,000	-439,067,750	152,836,093	397,153,700	441,082,000	0000822416	0001050915	0001124198
7	BaseVar	1,773,807,375	2,771,149,338	9,508,954,374	28,676,510,950	41,669,567,000	0000906163	0001130385	0001124198
8	EconomicCapitalRatio	0.0842	0.268	0.711	1.62	1.71	0000822416	0001357615	0000906163

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	LiabilitiesCurrent	-0.931	-0.690	-0.0318	0.180	0.196	0001027884	0000052988	0000085974
1	LiabilitiesNonCurrent	-0.179	-0.0589	0.0103	0.0295	0.0303	0001130385	0001027884	0000052988
2	NotesAndLoansPayable	-0.943	-0.698	0.275	0.580	0.601	0000773141	0001130385	0000052988
3	remainder_Liabilities	-1.18	-1.03	0.403	1.01	1.05	0000920760	0001027884	0000052988
4	AssetsCurrent	-0.225	-0.210	0.128	0.455	0.468	0000822416	0000052988	0000105634
5	AssetsNonCurrent	-0.0159	-0.0159	-0.00832	0.0471	0.0714	0000105634	0000794170	0000052988
6	Inventory	-0.289	-0.286	-0.136	0.845	0.852	0001124198	0000773141	0000794170
7	Goodwill	-0.149	-0.105	-0.0351	0.259	0.272	0001124198	0000822416	0001050915
8	CashAndCashEquivalentsAtCarryingValue	-0.285	-0.284	-0.101	0.144	0.328	0001357615	0001050915	0000906163
9	remainder_Assets	-0.614	-0.538	-0.187	0.990	1.10	0000105634	0000861459	0000920760
10	remainder_Expenses	-1.74	-1.55	-0.274	0.468	0.651	0001124198	0001050915	0000906163
11	remainder_Revenues	-1.00	-0.839	0.525	1.95	2.14	0000794170	0001027884	0001124198
12	remainder_NetIncome	-0.361	-0.343	-0.165	0.439	0.616	0001124198	0001027884	0000794170
13	remainder_ComprehensiveNetIncome	-0.0183	-0.0116	0.00117	0.00328	0.00411	0000052988	0000085974	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.651	-0.577	0.120	1.27	1.41	0000920760	0001027884	0000052988
1	Assets	-0.708	-0.689	-0.129	0.554	0.613	0001124198	0001050915	0000906163
2	Expenses	-1.74	-1.55	-0.274	0.468	0.651	0001124198	0001050915	0000906163
3	Revenues	-1.00	-0.839	0.525	1.95	2.14	0000794170	0001027884	0001124198
4	StockholdersEquity	-1.33	-1.04	-0.269	0.664	1.08	0001124198	0000085974	0000906163
5	NetIncome	-0.318	-0.217	0.0309	0.158	0.244	0000822416	0001124198	0000906163
6	ComprehensiveNetIncome	-0.317	-0.215	0.0299	0.159	0.244	0000822416	0000052988	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000052988	0000906163	0000052988
8	EconomicCapitalRatio	-0.757	-0.574	-0.131	0.779	0.870	0000822416	0001357615	0000906163

2011

Logs

error	4 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000357294 0001172069 0001172069 0000878560
error	4 × Negative Expenses, ignoring company.	pre-agg	0000882184 0000882184 0000882184 0000882184
warning	21 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000906163 0000920760 0001027884 0001050915 0001124198 0001130385 0001317577 0001357615 0001501162 0000085974 0000773141 0000795266 0000814046 0001392363 0000822416 0000039677 0001172069 0000861459 0000794170
warning	18 × The stock price does not exist	industry.us_generic	0000042316 0000054441 0000882184 0000888504 0001027884 0001065860 0001082198 0001130385 0001317577 0001425565 0001501162 0000085974 0000357294 0000773141 0000795266 0001392363 0000915840 0001510832
warning	13 × No stock price available	subcommand.plot	0000042316 0000054441 0000888504 0001027884 0001065860 0001082198 0001130385 0001317577 0001425565 0001501162 0000085974 0000773141 0001392363
warning	12 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000882184 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141
warning	11 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000882184 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760
warning	10 × Missing logo	subcommand.report	0000054441 0000100591 0000888504 0000920760 0001065860 0001082198 0001130385 0001317577 0001501162 0000085974
warning	7 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000882184 0000920760 0000920760 0000920760 0000920760 0000920760 0001130385
warning	6 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000920760 0000357294 0000814046 0001172069 0000878560 0001353386
warning	6 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000814046
warning	5 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0000920760 0000920760
warning	5 × Ignoring company because Assets is zero	pre-agg	0000357294 0000357294 0000357294 0000357294 0000915840
warning	1 × Similarly named company. Duplicate?	None	0001357971
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001510832

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	LiabilitiesCurrent	0	0	65,586,572	2,117,288,250	3,840,111,000	0000085974	0000874238	0001124198
1	LiabilitiesNonCurrent	0	0	0	330,477,800	823,827,000	0000042316	0000794170	0000085974
2	NotesAndLoansPayable	0	0	0	1,489,147,900	3,088,344,000	0000015615	0000042316	0000822416
3	remainder_Liabilities	0	0	30,454,541	1,104,763,700	5,851,146,000	0000052988	0000888504	0000920760
4	AssetsCurrent	0	0	127,190,945	3,200,050,050	5,880,623,000	0000077543	0000054441	0001124198
5	AssetsNonCurrent	0	0	1,706,043	171,085,850	861,734,000	0000015615	0001317577	0000052988
6	Inventory	0	0	0	1,536,021,500	4,636,468,000	0000015615	0000105634	0000822416
7	Goodwill	0	0	28,751,620	1,188,867,050	1,808,434,000	0000042316	0000866273	0001050915
8	CashAndCashEquivalentsAtCarryingValue	0	0	59,576,613	1,095,150,950	2,161,411,000	0000042316	0000799292	0001124198
9	remainder_Assets	-621,000,000	-176,694,050	67,816,569	1,632,981,700	7,991,067,000	0000052988	0001130385	0000920760
10	remainder_Expenses	31,851,528	76,480,071	821,034,804	8,906,727,900	22,683,312,000	0000042316	0000915840	0001124198
11	remainder_Revenues	0	27,906,582	698,069,528	9,429,099,600	23,381,399,000	0000794170	0000915840	0001124198
12	remainder_NetIncome	-284,751,000	-43,362,950	0	91,086,050	1,494,263,000	0000822416	0001124198	0000794170
13	remainder_ComprehensiveNetIncome	-170,000,000	-9,550,050	0	1,336,854	44,011,000	0001357615	0000906163	0000052988

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	11,278,737	36,060,102	397,960,639	4,006,145,100	5,851,146,000	0000042316	0000906163	0000920760
1	Assets	26,610,937	83,332,581	758,658,674	7,093,318,400	9,154,671,000	0000042316	0001372020	0000920760
2	Expenses	31,851,528	76,480,071	821,034,804	8,906,727,900	22,683,312,000	0000042316	0000915840	0001124198
3	Revenues	0	27,906,582	698,069,528	9,429,099,600	23,381,399,000	0000794170	0000915840	0001124198
4	StockholdersEquity	11,487,910	33,756,975	287,856,395	3,479,581,000	4,430,165,000	0001082198	0001372020	0001124198
5	NetIncome	-210,388,000	-114,360,350	17,158,809	365,937,850	698,087,000	0000822416	0001372020	0001124198
6	ComprehensiveNetIncome	-210,388,000	-114,360,350	17,778,374	371,892,525	698,087,000	0000822416	0000700923	0001124198
7	BaseVar	75,635,056	242,875,516	2,043,326,265	20,579,775,962	46,361,815,625	0000042316	0000888504	0001124198
8	EconomicCapitalRatio	-0.0684	0.279	0.707	1.72	1.86	0000915840	0001361538	0000080035

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	LiabilitiesCurrent	-1.15	-0.762	0.0140	0.298	0.440	0001501162	0000042316	0001373670
1	LiabilitiesNonCurrent	-1.12	-0.171	0.0685	0.128	0.147	0000085974	0001425565	0001124198
2	NotesAndLoansPayable	-1.25	-0.816	0.261	0.443	0.493	0000915840	0001425565	0001124198
3	remainder_Liabilities	-1.50	-0.687	0.223	0.499	0.552	0000920760	0000888504	0001124198
4	AssetsCurrent	-0.398	-0.268	0.0546	0.572	0.759	0001373670	0000874238	0001501162
5	AssetsNonCurrent	-0.0192	-0.0157	-0.00809	0.0300	0.106	0001361538	0000105634	0000052988
6	Inventory	-0.369	-0.250	-0.124	0.985	1.03	0001048268	0001372020	0000794170
7	Goodwill	-0.246	-0.165	-0.0198	0.273	0.400	0001048268	0000700923	0000015615
8	CashAndCashEquivalentsAtCarryingValue	-0.199	-0.153	-0.0362	0.129	0.479	0001373670	0000799292	0000100591
9	remainder_Assets	-0.722	-0.430	-0.0910	0.804	1.41	0001048268	0001501162	0000920760
10	remainder_Expenses	-1.34	-0.997	-0.239	0.478	0.727	0001048268	0000888504	0000906163
11	remainder_Revenues	-1.16	-0.583	0.280	0.903	1.49	0000794170	0000042316	0001124198
12	remainder_NetIncome	-0.124	-0.120	-0.0731	0.139	0.669	0000100591	0000105634	0000794170
13	remainder_ComprehensiveNetIncome	-0.0325	-0.0146	0.000802	0.00613	0.0310	0001357615	0000042316	0001392363

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.956	-0.669	0.240	1.00	1.09	0000915840	0001357615	0000054441
1	Assets	-0.973	-0.597	-0.107	0.683	0.871	0001048268	0000042316	0000906163
2	Expenses	-1.34	-0.997	-0.239	0.478	0.727	0001048268	0000888504	0000906163
3	Revenues	-1.16	-0.583	0.280	0.903	1.49	0000794170	0000042316	0001124198
4	StockholdersEquity	-1.09	-0.844	-0.0998	0.519	1.18	0001048268	0001372020	0000906163
5	NetIncome	-0.518	-0.315	0.0426	0.234	0.282	0001048268	0000105634	0000054441
6	ComprehensiveNetIncome	-0.517	-0.314	0.0435	0.235	0.285	0001048268	0000105634	0001392363
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0000888504	0000015615
8	EconomicCapitalRatio	-0.922	-0.575	-0.146	0.861	1.01	0000915840	0001361538	0000080035

2012

Logs

error	4 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000357294 0000878560 0001539551 0001539551
error	4 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184 0000882184
warning	26 × The stock price does not exist	industry.us_generic	0000042316 0000054441 0000085974 0000773141 0000822416 0000882184 0000888504 0001027884 0001065860 0001082198 0001130385 0001317577 0001373670 0001425565 0001501162 0000039677 0000357294 0000795266 0000915840 0001392363 0001510832 0000353020 0000878560 0001303330 0001408356 0001572684
warning	23 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000085974 0000105634 0000773141 0000822416 0000906163 0000920760 0001027884 0001050915 0001124198 0001130385 0001317577 0001357615 0001501162 0000039677 0000795266 0001172069 0001392363 0001531744 0001571274 0000861459 0000794170 0000814046
warning	16 × No stock price available	subcommand.plot	0000042316 0000054441 0000085974 0000773141 0000888504 0001027884 0001050915 0001065860 0001082198 0001130385 0001317577 0001425565 0001501162 0000039677 0001172069 0001392363
warning	15 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000882184 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760
warning	13 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000773141 0000882184 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000795266
warning	11 × Missing logo	subcommand.report	0000054441 0000085974 0000100591 0000888504 0000920760 0001065860 0001082198 0001130385 0001317577 0001501162 0001172069
warning	8 × Ignoring company because Assets is zero	pre-agg	0000822416 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840 0000878560
warning	7 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000814046
warning	6 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000882184 0000920760 0000920760 0000920760 0000920760 0001130385
warning	5 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001082198 0000357294 0000878560 0000814046 0001539551
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0000920760
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001373670 0001510832 0001531744
warning	2 × Similarly named company. Duplicate?	None	0001357971 0001425565
warning	2 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001065860 0000915840
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.369801631877447}

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	LiabilitiesCurrent	0	0	79,326,615	2,044,965,000	3,887,114,000	0000039677	0001317577	0001124198
1	LiabilitiesNonCurrent	0	0	0	301,379,000	1,134,468,000	0000039677	0000052988	0000085974
2	NotesAndLoansPayable	0	0	0	722,797,000	2,509,613,000	0000015615	0000888504	0000822416
3	remainder_Liabilities	0	0	18,653,552	888,400,000	6,360,998,000	0000052988	0001402829	0000920760
4	AssetsCurrent	0	0	164,821,276	3,612,077,000	6,094,137,000	0000039677	0000874238	0001124198
5	AssetsNonCurrent	0	0	1,625,120	377,629,162	885,885,000	0000015615	0001317577	0000052988
6	Inventory	0	0	0	1,077,418,000	4,214,046,000	0000015615	0000920760	0000822416
7	Goodwill	0	0	35,180,060	957,441,000	2,010,340,000	0000039677	0000866273	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	43,121,988	1,310,743,000	2,154,541,000	0000042316	0001402829	0001124198
9	remainder_Assets	-701,326,000	-329,776,000	51,137,252	1,785,346,000	9,051,463,000	0000052988	0001357615	0000920760
10	remainder_Expenses	2,392,000	63,577,000	670,776,816	7,708,000,000	27,006,068,000	0000773141	0001372020	0001124198
11	remainder_Revenues	0	0	687,789,848	7,921,000,000	27,577,135,000	0000773141	0001372020	0001124198
12	remainder_NetIncome	-57,326,000	-20,351,000	-330,755	34,272,000	275,077,000	0000822416	0000866273	0000906163
13	remainder_ComprehensiveNetIncome	-173,295,000	-56,349,000	0	2,455,000	12,078,000	0001124198	0001402829	0000773141

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	343,202	29,825,098	354,056,228	3,887,114,000	6,360,998,000	0001172069	0000888504	0000920760
1	Assets	12,093	42,308,000	675,858,887	6,839,433,000	10,362,206,000	0001172069	0001488139	0000920760
2	Expenses	2,392,000	63,577,000	670,776,816	7,708,000,000	27,006,068,000	0000773141	0001372020	0001124198
3	Revenues	0	0	687,789,848	7,921,000,000	27,577,135,000	0000773141	0001372020	0001124198
4	StockholdersEquity	-331,109	6,441,365	287,487,328	4,001,208,000	5,092,381,000	0001172069	0001035983	0000052988
5	NetIncome	-265,400,000	-53,182,000	17,188,456	390,954,000	757,394,000	0000077543	0000866273	0000920760
6	ComprehensiveNetIncome	-265,379,500	-54,835,500	16,857,286	362,779,500	757,394,000	0000077543	0000866273	0000920760
7	BaseVar	9,184,436	175,856,806	1,896,462,789	18,301,500,000	53,993,514,250	0001172069	0001372020	0001124198
8	EconomicCapitalRatio	-104	-1.37	0.739	1.64	1.91	0001172069	0000888504	0000080035

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	LiabilitiesCurrent	-71.4	-0.885	0.0251	0.358	0.376	0001172069	0000015615	0000874238
1	LiabilitiesNonCurrent	-30.5	-0.561	0.0715	0.199	0.227	0001172069	0000799292	0001124198
2	NotesAndLoansPayable	-51.2	-0.885	0.224	0.439	0.492	0001172069	0001357615	0001124198
3	remainder_Liabilities	-21.3	-0.442	0.131	0.517	0.576	0001172069	0001402829	0001124198
4	AssetsCurrent	-82.6	-0.333	0.0435	0.822	1.00	0001172069	0000888504	0000100591
5	AssetsNonCurrent	-26.8	-0.154	-0.0257	0.0580	0.828	0001172069	0000833079	0001488139
6	Inventory	-52.1	-0.408	-0.0916	0.925	1.03	0001172069	0001372020	0000833079
7	Goodwill	-49.8	-0.378	-0.0209	0.189	0.350	0001172069	0000054441	0000015615
8	CashAndCashEquivalentsAtCarryingValue	-63.4	-0.254	-0.0526	0.236	1.11	0001172069	0000105634	0000100591
9	remainder_Assets	-76.4	-0.594	-0.103	0.631	1.94	0001172069	0001136294	0000773141
10	remainder_Expenses	-14.0	-1.63	-0.229	0.562	0.744	0001172069	0001361538	0000906163
11	remainder_Revenues	-34.9	-0.681	0.289	1.33	1.94	0001172069	0000888504	0001124198
12	remainder_NetIncome	-49.7	-0.0128	0.0784	0.180	0.281	0001172069	0001027884	0000906163
13	remainder_ComprehensiveNetIncome	-0.156	-0.0193	0.00208	0.0159	0.0329	0001082198	0001372020	0001172069

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-81.4	-0.785	0.110	1.10	1.19	0001172069	0001357615	0000874238
1	Assets	-96.1	-1.57	-0.120	0.842	1.36	0001172069	0000077543	0000773141
2	Expenses	-14.0	-1.63	-0.229	0.562	0.744	0001172069	0001361538	0000906163
3	Revenues	-34.9	-0.681	0.289	1.33	1.94	0001172069	0000888504	0001124198
4	StockholdersEquity	-13.3	-1.19	-0.0858	0.595	0.683	0001172069	0001488139	0001317577
5	NetIncome	-98.6	-1.14	0.292	0.645	0.825	0001172069	0000833079	0001082198
6	ComprehensiveNetIncome	-98.6	-1.14	0.277	0.625	0.703	0001172069	0001357615	0000042316
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0000920760	0000015615
8	EconomicCapitalRatio	-102	0.436	2.54	3.45	3.71	0001172069	0000888504	0000080035

2013

Logs

error	6 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001539551 0001539551 0001082198 0001172069 0001548953 0001403433
error	3 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0000077543
warning	29 × The stock price does not exist	industry.us_generic	0000042316 0000054441 0000353020 0000773141 0000795266 0000822416 0000878560 0000888504 0001027884 0001065860 0001130385 0001303330 0001317577 0001373670 0001408356 0001425565 0001501162 0001510832 0001572684 0000039677 0000357294 0001392363 0000920760 0001539551 0001574596 0000085974 0000882184 0001082198 0000915840
warning	24 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000773141 0000795266 0000822416 0000906163 0001027884 0001050915 0001124198 0001130385 0001317577 0001357615 0001501162 0001531744 0001571274 0000039677 0001392363 0000920760 0001566265 0000861459 0000085974 0000794170 0000814046 0001172069
warning	18 × No stock price available	subcommand.plot	0000042316 0000054441 0000353020 0000888504 0001027884 0001050915 0001065860 0001130385 0001303330 0001317577 0001408356 0001425565 0001501162 0001510832 0001571274 0001572684 0000039677 0001392363
warning	16 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	15 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000773141 0000795266 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	15 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000878560 0000878560 0000878560 0000878560 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840
warning	10 × Missing logo	subcommand.report	0000054441 0000100591 0000888504 0001065860 0001130385 0001303330 0001317577 0001501162 0001571274 0001572684
warning	7 × Ignoring company because Expenses is zero	pre-agg	0001373670 0001510832 0001531744 0001531744 0001531744 0001531744 0000920760
warning	6 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000773141 0001408356 0001531744 0001539551 0001403433 0001434477
warning	6 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000814046
warning	5 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001130385 0000920760 0000920760 0000920760 0000882184
warning	3 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000795266 0000915840 0001434477
warning	3 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760
warning	1 × Similarly named company. Duplicate?	None	0001357971

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	LiabilitiesCurrent	0	0	75,974,408	2,173,000,000	5,185,179,000	0000039677	0001501162	0001027884
1	LiabilitiesNonCurrent	0	0	0	366,616,000	765,425,000	0000039677	0000080035	0000015615
2	NotesAndLoansPayable	0	0	0	250,000,000	1,340,190,000	0000015615	0000915840	0001562476
3	remainder_Liabilities	0	0	23,725,693	1,383,592,000	1,746,239,000	0000052988	0000700923	0000915840
4	AssetsCurrent	0	0	196,724,652	3,389,565,000	6,003,683,000	0000039677	0000054441	0001124198
5	AssetsNonCurrent	0	0	1,746,364	573,836,000	832,459,000	0000039677	0000700923	0000052988
6	Inventory	0	0	0	1,313,818,000	2,262,339,000	0000015615	0001027884	0001562476
7	Goodwill	0	0	34,007,372	1,988,594,000	4,226,468,000	0000039677	0001402829	0001027884
8	CashAndCashEquivalentsAtCarryingValue	0	0	52,100,784	1,099,000,000	2,283,582,000	0000042316	0001035983	0001124198
9	remainder_Assets	-877,109,000	-314,860,000	81,960,800	1,207,914,000	1,619,895,000	0000052988	0000039677	0000906163
10	remainder_Expenses	3,587,165	60,701,000	710,257,784	10,610,698,000	26,528,547,000	0001510832	0001372020	0001124198
11	remainder_Revenues	0	41,539,221	732,062,624	11,094,527,000	27,351,573,000	0000906163	0001372020	0001124198
12	remainder_NetIncome	-223,472,000	-56,789,000	0	114,989,000	418,696,000	0001562476	0001124198	0000906163
13	remainder_ComprehensiveNetIncome	-228,000,000	-77,371,000	0	6,546,790	54,346,000	0001357615	0001408356	0001130385

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,825,095	35,754,212	288,237,420	2,921,000,000	6,882,155,000	0001510832	0001035983	0001027884
1	Assets	188,284	43,768,000	619,510,211	7,274,144,000	9,389,593,000	0001510832	0001303330	0001027884
2	Expenses	3,587,165	60,701,000	710,257,784	10,610,698,000	26,528,547,000	0001510832	0001372020	0001124198
3	Revenues	0	41,539,221	732,062,624	11,094,527,000	27,351,573,000	0000906163	0001372020	0001124198
4	StockholdersEquity	-1,636,811	7,774,000	301,783,152	4,241,319,000	5,386,525,000	0001510832	0000039677	0000052988
5	NetIncome	-151,758,000	-36,023,000	20,591,920	440,182,000	823,026,000	0001408356	0000080035	0001124198
6	ComprehensiveNetIncome	-151,758,000	-36,471,500	18,580,996	420,517,500	725,193,000	0001408356	0000080035	0001124198
7	BaseVar	4,178,534	177,043,362	1,932,526,828	24,912,293,125	53,181,817,750	0001510832	0001317577	0001124198
8	EconomicCapitalRatio	-8.09	-0.380	0.754	1.62	1.92	0001510832	0000833079	0001317577

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	LiabilitiesCurrent	-1.13	-0.570	0.0965	0.544	13.4	0001501162	0001050915	0001510832
1	LiabilitiesNonCurrent	-1.08	-0.373	0.0971	0.222	0.319	0001571274	0000833079	0001124198
2	NotesAndLoansPayable	-1.07	-0.594	0.108	0.195	0.282	0000833079	0000067215	0001124198
3	remainder_Liabilities	-1.58	-1.30	0.260	0.697	0.946	0001303330	0001065860	0001124198
4	AssetsCurrent	-1.96	-0.309	0.0166	0.596	1.17	0001510832	0000888504	0001392363
5	AssetsNonCurrent	-0.325	-0.0956	-0.0294	0.187	0.714	0001510832	0001402829	0000067215
6	Inventory	-1.04	-0.304	-0.117	0.900	0.912	0001510832	0000100591	0000915840
7	Goodwill	-0.801	-0.172	-0.0250	0.312	0.444	0001510832	0000080035	0001027884
8	CashAndCashEquivalentsAtCarryingValue	-1.11	-0.176	-0.0526	0.270	0.854	0001510832	0001317577	0000100591
9	remainder_Assets	-1.64	-0.673	-0.107	0.762	1.45	0001510832	0001392363	0001303330
10	remainder_Expenses	-3.38	-1.18	-0.153	0.549	0.729	0001510832	0001357615	0000906163
11	remainder_Revenues	-2.72	-0.650	0.364	1.22	2.22	0001510832	0001357615	0001124198
12	remainder_NetIncome	-0.373	-0.139	-0.00534	0.0496	0.393	0001065860	0001361538	0000906163
13	remainder_ComprehensiveNetIncome	-0.0483	-0.0225	-0.00109	0.0134	0.0318	0001357615	0001402829	0001510832

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.02	-0.782	0.244	1.38	4.62	0001408356	0000100591	0001510832
1	Assets	-4.51	-0.801	-0.112	0.736	1.07	0001510832	0001136294	0001408356
2	Expenses	-3.38	-1.18	-0.153	0.549	0.729	0001510832	0001357615	0000906163
3	Revenues	-2.72	-0.650	0.364	1.22	2.22	0001510832	0001357615	0001124198
4	StockholdersEquity	-2.81	-1.04	-0.0643	0.666	1.14	0001510832	0001303330	0001572684
5	NetIncome	-6.11	-0.407	0.214	0.345	0.525	0001510832	0000042316	0001124198
6	ComprehensiveNetIncome	-6.08	-0.409	0.208	0.344	0.494	0001510832	0000067215	0001124198
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001050915	0000015615
8	EconomicCapitalRatio	-8.70	-0.987	0.147	1.01	1.32	0001510832	0000833079	0001317577

2014

Logs

error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0001082198 0001434477
error	3 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0000077543
warning	33 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000042316 0000052988 0000105634 0000353020 0000822416 0000878560 0000888504 0000906163 0000920760 0001027884 0001050915 0001065860 0001124198 0001357615 0001392363 0001408356 0001531744 0001571274 0001572684 0000039677 0001539551 0001566265 0001574596 0000861459 0000814046 0001130385 0000085974 0000773141 0000794170 0000795266 0001317577 0001501162 0001172069
warning	30 × The stock price does not exist	industry.us_generic	0000042316 0000054441 0000353020 0000822416 0000878560 0000888504 0000920760 0001027884 0001065860 0001392363 0001408356 0001425565 0001510832 0001572684 0000039677 0000357294 0001303330 0001539551 0001574596 0001374881 0001130385 0000085974 0000773141 0000795266 0000882184 0001082198 0001317577 0001373670 0001501162 0000915840
warning	18 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000795266 0000882184
warning	18 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000773141 0000882184
warning	18 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000822416 0000878560 0000878560 0000878560 0000878560 0000878560 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840
warning	17 × No stock price available	subcommand.plot	0000042316 0000054441 0000353020 0000888504 0001027884 0001065860 0001392363 0001408356 0001425565 0001510832 0001571274 0001572684 0000039677 0001303330 0001539551 0001566265 0001574596
warning	10 × Ignoring company because Expenses is zero	pre-agg	0000920760 0000920760 0000920760 0000920760 0001510832 0001531744 0001531744 0001531744 0001374881 0001373670
warning	9 × Missing logo	subcommand.report	0000054441 0000100591 0000888504 0001065860 0001571274 0001572684 0001303330 0001566265 0001574596
warning	6 × Ignoring company because Liabilities is zero	pre-agg	0001392363 0000814046 0000795266 0000795266 0000795266 0000795266
warning	5 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0001130385 0000882184
warning	3 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760
warning	2 × Similarly named company. Duplicate?	None	0001300938 0001357971
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.259079999743979}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000794170
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000795266

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	LiabilitiesCurrent	0	0	55,330,256	2,330,476,800	4,772,856,000	0000039677	0000080035	0001027884
1	LiabilitiesNonCurrent	0	0	0	278,253,200	502,000,000	0000039677	0000105634	0001357615
2	NotesAndLoansPayable	0	0	0	769,992,800	1,576,356,000	0000042316	0000052988	0001562476
3	remainder_Liabilities	0	0	24,740,110	1,137,583,200	2,386,334,000	0000052988	0000700923	0001408356
4	AssetsCurrent	0	0	151,159,696	3,335,162,400	5,758,047,000	0000039677	0001402829	0001124198
5	AssetsNonCurrent	0	0	401,940	432,208,800	638,250,000	0000039677	0001361538	0000052988
6	Inventory	0	0	0	1,685,863,400	2,518,321,000	0000042316	0000052988	0001562476
7	Goodwill	0	0	18,505,099	2,020,894,800	4,195,231,000	0000067215	0001048268	0001027884
8	CashAndCashEquivalentsAtCarryingValue	0	0	33,775,616	695,201,400	1,993,125,000	0000042316	0000054441	0001124198
9	remainder_Assets	-482,048,000	-274,285,200	71,076,601	1,339,315,400	3,079,429,000	0000353020	0000700923	0001408356
10	remainder_Expenses	53,685	1,966,478	517,786,181	11,435,914,400	20,679,483,000	0001566265	0000054441	0001124198
11	remainder_Revenues	0	0	518,069,179	11,726,375,600	21,531,577,000	0000906163	0001580905	0001124198
12	remainder_NetIncome	-204,551,000	-30,828,000	0	57,348,400	453,546,000	0001124198	0001539551	0000906163
13	remainder_ComprehensiveNetIncome	-322,645,000	-203,873,600	0	0	2,728,000	0001124198	0001561680	0001572684

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	83,065	835,128	219,026,852	3,259,967,800	6,504,728,000	0001566265	0001373670	0001027884
1	Assets	822	409,946	569,185,428	7,817,948,000	9,381,031,000	0001566265	0000866273	0001027884
2	Expenses	53,685	1,966,478	517,786,181	11,435,914,400	20,679,483,000	0001566265	0000054441	0001124198
3	Revenues	0	0	518,069,179	11,726,375,600	21,531,577,000	0000906163	0001580905	0001124198
4	StockholdersEquity	-5,301,000	-168,969	282,302,611	4,195,692,600	6,103,813,000	0001425565	0000866273	0000052988
5	NetIncome	-1,198,000,000	-113,863,000	10,386,375	344,706,000	647,543,000	0001357615	0001488139	0001124198
6	ComprehensiveNetIncome	-1,298,000,000	-118,117,400	7,520,388	304,645,200	518,634,000	0001357615	0001488139	0001027884
7	BaseVar	88,918	3,832,510	1,192,651,868	25,447,789,600	43,158,615,000	0001566265	0001136294	0001124198
8	EconomicCapitalRatio	-10.5	-4.26	0.726	1.47	1.73	0001539551	0000105634	0000080035

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	LiabilitiesCurrent	-1.22	-0.813	0.142	0.519	17.9	0001392363	0001050915	0001510832
1	LiabilitiesNonCurrent	-1.01	-0.931	0.0934	0.237	0.306	0001571274	0001561680	0001124198
2	NotesAndLoansPayable	-1.04	-0.877	0.138	0.263	0.333	0001539551	0000888504	0001124198
3	remainder_Liabilities	-2.73	-1.28	0.199	0.890	3.57	0001539551	0000833079	0001566265
4	AssetsCurrent	-1.07	-0.901	0.0557	0.397	1.50	0001510832	0000105634	0001392363
5	AssetsNonCurrent	-0.815	-0.0873	-0.0249	0.304	0.654	0001539551	0001357615	0000067215
6	Inventory	-3.92	-0.964	-0.208	1.05	1.42	0001539551	0001372020	0001572684
7	Goodwill	-1.82	-0.345	-0.0273	0.325	0.452	0001539551	0000906163	0001027884
8	CashAndCashEquivalentsAtCarryingValue	-2.41	-0.459	-0.0421	0.164	1.26	0001539551	0001488139	0000100591
9	remainder_Assets	-3.58	-1.04	-0.157	1.05	1.61	0001539551	0000700923	0001303330
10	remainder_Expenses	-7.62	-1.28	-0.157	0.582	0.822	0001539551	0000080035	0001373670
11	remainder_Revenues	-2.72	-1.21	0.290	1.47	1.92	0001539551	0000888504	0001124198
12	remainder_NetIncome	-1.53	-0.110	-0.0323	0.0548	0.434	0001425565	0000052988	0000906163
13	remainder_ComprehensiveNetIncome	-0.0641	-0.0353	0.00542	0.0157	0.0244	0000080035	0001574596	0001539551

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-3.95	-0.898	0.270	1.51	5.83	0001539551	0000353020	0001510832
1	Assets	-7.41	-2.53	-0.167	0.844	1.11	0001539551	0000052988	0001408356
2	Expenses	-7.62	-1.28	-0.157	0.582	0.822	0001539551	0000080035	0001373670
3	Revenues	-2.72	-1.21	0.290	1.47	1.92	0001539551	0000888504	0001124198
4	StockholdersEquity	-2.67	-1.73	0.0528	0.549	0.955	0001510832	0001392363	0000080035
5	NetIncome	-10.4	-2.18	0.350	0.632	0.790	0001539551	0000799292	0001124198
6	ComprehensiveNetIncome	-10.4	-2.16	0.357	0.642	0.759	0001539551	0000799292	0001124198
7	BaseVar	nan	nan	nan	nan	nan	0000039677	0001136294	0000039677
8	EconomicCapitalRatio	-10.7	-4.40	0.587	1.33	1.59	0001539551	0000105634	0000080035

2015

Logs

error	3 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0001534155
warning	35 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000039677 0000052988 0000105634 0000353020 0000822416 0000861459 0000878560 0000888504 0000906163 0000920760 0001027884 0001050915 0001065860 0001124198 0001357615 0001392363 0001408356 0001539551 0001566265 0001572684 0000042316 0000814046 0001574596 0000773141 0001136294 0001634424 0001130385 0000085974 0000794170 0000795266 0001317577 0001501162 0001172069 0001531744 0001571274
warning	30 × The stock price does not exist	industry.us_generic	0000039677 0000353020 0000822416 0000878560 0000888504 0000920760 0001027884 0001065860 0001392363 0001408356 0001425565 0001510832 0001539551 0001572684 0000042316 0000357294 0001374881 0001574596 0000773141 0000915840 0001130385 0000085974 0000795266 0000054441 0000882184 0001082198 0001317577 0001373670 0001501162 0001303330
warning	21 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000878560 0000878560 0000878560 0000878560 0000878560 0000878560 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840
warning	20 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000773141 0000773141 0000795266 0000882184
warning	20 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000773141 0000773141 0000773141 0000882184
warning	14 × No stock price available	subcommand.plot	0000039677 0000353020 0000888504 0001027884 0001065860 0001408356 0001425565 0001510832 0001539551 0001566265 0001572684 0000042316 0000814046 0001574596
warning	8 × Ignoring company because Expenses is zero	pre-agg	0000920760 0000920760 0000920760 0001510832 0001374881 0001373670 0001531744 0001531744
warning	6 × Missing logo	subcommand.report	0000100591 0000888504 0001065860 0001566265 0001572684 0001574596
warning	6 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0001136294 0001130385 0000882184
warning	6 × Ignoring company because Liabilities is zero	pre-agg	0001392363 0000814046 0000795266 0000795266 0000795266 0000795266
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000878560 0000794170 0000795266 0001534155
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0001136294
warning	2 × Similarly named company. Duplicate?	None	0001300938 0001357971
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.626915221276269}

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	LiabilitiesCurrent	0	0	104,692,826	1,938,202,600	5,228,528,000	0000039677	0000874238	0001027884
1	LiabilitiesNonCurrent	0	0	0	682,697,600	1,800,000,000	0000039677	0001576940	0001027884
2	NotesAndLoansPayable	0	0	0	950,839,800	1,499,824,000	0000042316	0000042316	0001562476
3	remainder_Liabilities	0	0	19,520,584	814,289,000	3,352,598,000	0000052988	0001402829	0001408356
4	AssetsCurrent	0	0	188,499,389	3,153,429,800	5,278,287,000	0000039677	0000080035	0001124198
5	AssetsNonCurrent	0	0	2,245,656	415,414,200	719,515,000	0000039677	0001633931	0000052988
6	Inventory	0	0	0	1,901,050,000	3,126,787,000	0000042316	0000052988	0001562476
7	Goodwill	0	0	20,328,264	1,669,386,400	3,711,506,000	0000067215	0000100591	0001027884
8	CashAndCashEquivalentsAtCarryingValue	0	256	39,855,598	537,543,000	1,949,886,000	0000042316	0001572684	0001124198
9	remainder_Assets	-487,658,000	-277,662,600	78,183,328	1,182,832,000	5,761,174,000	0000353020	0000080035	0001408356
10	remainder_Expenses	390,974	1,995,900	696,769,294	10,904,533,800	17,633,384,000	0001606163	0001576940	0001124198
11	remainder_Revenues	0	21,950	662,973,536	11,206,352,800	18,114,048,000	0000906163	0001580905	0001124198
12	remainder_NetIncome	-117,706,000	-28,378,800	0	160,525,800	603,212,000	0001408356	0000814046	0000906163
13	remainder_ComprehensiveNetIncome	-182,316,000	-122,920,200	0	4,839,000	22,000,000	0001050915	0001576940	0001357615

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	255,283	1,000,165	326,737,254	2,872,724,400	7,038,767,000	0001606163	0001035983	0001027884
1	Assets	31,802	408,020	691,757,456	7,562,628,400	9,202,357,000	0001510832	0001035983	0001027884
2	Expenses	390,974	1,995,900	696,769,294	10,904,533,800	17,633,384,000	0001606163	0001576940	0001124198
3	Revenues	0	21,950	662,973,536	11,206,352,800	18,114,048,000	0000906163	0001580905	0001124198
4	StockholdersEquity	-3,874,188	-968,064	330,034,550	2,902,970,000	5,804,760,000	0001510832	0000700923	0000052988
5	NetIncome	-768,822,000	-90,898,800	16,559,296	327,470,400	475,006,000	0001408356	0001048268	0001124198
6	ComprehensiveNetIncome	-768,822,000	-91,990,900	16,560,292	259,655,200	469,477,500	0001408356	0001048268	0001124198
7	BaseVar	1,658,870	5,155,066	1,967,609,579	24,152,674,150	36,577,057,625	0001566265	0001576940	0001124198
8	EconomicCapitalRatio	-5.41	-3.63	0.764	1.62	2.27	0001566265	0001576940	0001606163

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	LiabilitiesCurrent	-0.793	-0.330	0.144	0.612	15.3	0001539551	0001050915	0001510832
1	LiabilitiesNonCurrent	-0.520	-0.363	0.0649	0.159	0.187	0000353020	0001572684	0001124198
2	NotesAndLoansPayable	-0.965	-0.937	0.115	0.232	0.265	0000039677	0000077543	0001124198
3	remainder_Liabilities	-1.39	-0.911	0.192	0.594	5.28	0000906163	0001425565	0001539551
4	AssetsCurrent	-1.54	-0.504	0.0812	0.340	1.08	0001539551	0001050915	0000100591
5	AssetsNonCurrent	-0.310	-0.0913	-0.0242	0.234	0.610	0001539551	0001562476	0000067215
6	Inventory	-1.55	-0.727	-0.192	1.11	1.43	0001539551	0001372020	0001572684
7	Goodwill	-0.805	-0.357	-0.0277	0.311	0.818	0001539551	0000906163	0001633931
8	CashAndCashEquivalentsAtCarryingValue	-1.27	-0.495	-0.0969	0.0791	6.67	0001539551	0001576940	0000814046
9	remainder_Assets	-2.14	-0.937	-0.193	0.664	1.37	0001539551	0000052988	0001408356
10	remainder_Expenses	-2.69	-1.48	-0.116	0.536	0.783	0001539551	0000080035	0000906163
11	remainder_Revenues	-1.83	-0.890	0.256	1.33	1.50	0001566265	0000077543	0001124198
12	remainder_NetIncome	-0.237	-0.162	-0.0266	0.0721	0.550	0001510832	0000080035	0000906163
13	remainder_ComprehensiveNetIncome	-0.0831	-0.0375	0.00391	0.0113	0.0569	0000080035	0000799292	0001566265

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.05	-0.337	0.245	1.09	6.80	0001408356	0001300938	0001510832
1	Assets	-4.25	-1.83	-0.174	0.672	1.95	0001539551	0000052988	0000814046
2	Expenses	-2.69	-1.48	-0.116	0.536	0.783	0001539551	0000080035	0000906163
3	Revenues	-1.83	-0.890	0.256	1.33	1.50	0001566265	0000077543	0001124198
4	StockholdersEquity	-3.25	-2.39	-0.245	0.884	2.08	0001539551	0000700923	0001606163
5	NetIncome	-3.48	-1.62	0.297	0.548	0.576	0001566265	0000833079	0001035983
6	ComprehensiveNetIncome	-3.42	-1.62	0.275	0.556	0.584	0001566265	0000799292	0001035983
7	BaseVar	nan	nan	nan	nan	nan	0000039677	0001065860	0000039677
8	EconomicCapitalRatio	-5.81	-4.02	0.367	1.22	1.87	0001566265	0001576940	0001606163

2016

Logs

error	3 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0001534155
warning	36 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000353020 0000773141 0000822416 0000861459 0000878560 0000888504 0000906163 0001027884 0001050915 0001124198 0001136294 0001357615 0001392363 0001408356 0001539551 0000039677 0000042316 0000814046 0001634424 0001561257 0001130385 0000920760 0000085974 0000794170 0000795266 0001065860 0001317577 0001501162 0001172069 0001531744 0001571274 0001572684 0001566265 0001574596
warning	31 × The stock price does not exist	industry.us_generic	0000353020 0000773141 0000822416 0000878560 0000888504 0000915840 0001027884 0001392363 0001408356 0001425565 0001539551 0000039677 0000042316 0000357294 0001532383 0001130385 0000920760 0000085974 0000795266 0000054441 0000882184 0001065860 0001082198 0001317577 0001373670 0001501162 0001510832 0001303330 0001572684 0001574596 0001374881
warning	23 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000773141 0000799292 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000795266 0000882184
warning	22 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	22 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000878560 0000878560 0000878560 0000878560 0000878560 0000915840 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294
warning	13 × No stock price available	subcommand.plot	0000353020 0000773141 0000888504 0001027884 0001136294 0001392363 0001408356 0001425565 0001539551 0000039677 0000042316 0000814046 0001634424
warning	8 × Ignoring company because Expenses is zero	pre-agg	0001532383 0000920760 0000920760 0001373670 0001510832 0001531744 0001531744 0001374881
warning	6 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001136294 0001130385 0000920760 0000920760 0000920760 0000882184
warning	6 × Ignoring company because Liabilities is zero	pre-agg	0001392363 0000814046 0000795266 0000795266 0000795266 0000795266
warning	4 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001136294 0000920760 0000920760 0000920760
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000794170 0000795266
warning	2 × Missing logo	subcommand.report	0000100591 0000888504
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.970976144109823}
warning	1 × Similarly named company. Duplicate?	None	0001357971
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000915840

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	LiabilitiesCurrent	0	0	143,266,349	1,923,145,100	4,982,853,000	0000039677	0000874238	0001027884
1	LiabilitiesNonCurrent	0	0	0	1,034,492,400	1,287,923,000	0000042316	0000042316	0001027884
2	NotesAndLoansPayable	0	0	0	287,222,650	1,387,969,000	0000039677	0000042316	0001562476
3	remainder_Liabilities	0	0	22,974,165	1,319,854,550	4,243,970,000	0000052988	0000353020	0001408356
4	AssetsCurrent	0	0	193,761,183	2,793,355,400	5,610,270,000	0000039677	0001402829	0001124198
5	AssetsNonCurrent	0	0	1,892,468	491,208,400	4,175,879,000	0000039677	0001361538	0000052988
6	Inventory	0	0	0	1,516,277,250	3,017,219,000	0000042316	0000874238	0001562476
7	Goodwill	0	0	54,313,890	1,741,717,100	3,416,550,000	0000773141	0000874238	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	39,003,800	531,373,400	1,850,436,000	0000042316	0000874238	0001124198
9	remainder_Assets	-3,752,593,000	-445,521,650	95,292,064	2,108,893,200	7,801,976,000	0000052988	0001373670	0001408356
10	remainder_Expenses	1,326,160	3,918,436	795,138,301	10,210,997,800	18,709,076,000	0000814046	0001580905	0001124198
11	remainder_Revenues	0	54,729	810,176,229	10,225,322,150	19,036,525,000	0000100591	0001580670	0001124198
12	remainder_NetIncome	-51,875,000	-37,202,300	0	69,803,750	661,697,000	0000052988	0001408356	0000906163
13	remainder_ComprehensiveNetIncome	-229,000,000	-153,330,450	0	2,171,650	21,301,000	0001357615	0001425565	0001050915

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	591,611	1,848,716	424,670,014	3,753,474,650	6,855,703,000	0000814046	0001580670	0001408356
1	Assets	358,232	2,473,597	827,484,092	7,767,510,300	9,216,417,000	0001300938	0000039677	0001124198
2	Expenses	1,326,160	3,918,436	795,138,301	10,210,997,800	18,709,076,000	0000814046	0001580905	0001124198
3	Revenues	0	54,729	810,176,229	10,225,322,150	19,036,525,000	0000100591	0001580670	0001124198
4	StockholdersEquity	-3,557,458	290,177	426,358,085	3,182,554,650	5,577,336,000	0001539551	0000039677	0000052988
5	NetIncome	-820,347,000	-50,851,950	26,640,408	213,322,200	425,262,000	0001408356	0001361538	0000906163
6	ComprehensiveNetIncome	-820,347,000	-147,700,250	26,623,515	204,586,575	425,262,000	0001408356	0000866273	0000906163
7	BaseVar	3,897,366	8,088,420	2,275,164,990	22,684,546,200	39,639,823,125	0001300938	0000700923	0001124198
8	EconomicCapitalRatio	-5.48	-2.97	0.775	1.66	1.81	0001300938	0000773141	0000814046

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	LiabilitiesCurrent	-1.14	-0.587	0.0610	0.453	3.42	0000100591	0001050915	0001539551
1	LiabilitiesNonCurrent	-1.16	-0.638	0.0703	0.275	0.295	0001580670	0001634424	0000866273
2	NotesAndLoansPayable	-0.990	-0.369	0.0459	0.0901	0.0945	0000833079	0000077543	0000866273
3	remainder_Liabilities	-1.34	-1.14	0.277	0.694	4.31	0000906163	0000888504	0001300938
4	AssetsCurrent	-0.891	-0.744	0.0145	0.413	1.50	0001539551	0001050915	0001392363
5	AssetsNonCurrent	-0.234	-0.218	-0.0350	0.464	0.628	0001425565	0001562476	0000067215
6	Inventory	-1.01	-0.765	-0.148	1.17	1.28	0001300938	0001050915	0001580670
7	Goodwill	-0.719	-0.393	-0.0280	0.338	0.726	0001300938	0000874238	0001633931
8	CashAndCashEquivalentsAtCarryingValue	-1.06	-0.579	-0.139	0.0654	4.74	0001300938	0001361538	0000814046
9	remainder_Assets	-1.39	-1.01	-0.151	1.07	1.91	0001300938	0001580670	0000773141
10	remainder_Expenses	-2.60	-1.26	-0.164	0.635	0.767	0001425565	0000080035	0000100591
11	remainder_Revenues	-1.39	-0.899	0.255	1.33	1.51	0001300938	0000039677	0001357971
12	remainder_NetIncome	-2.45	-0.0870	-0.0126	0.0570	0.578	0001300938	0001580905	0000906163
13	remainder_ComprehensiveNetIncome	-0.0461	-0.0342	0.00723	0.0153	0.0201	0001357615	0001576940	0000866273

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.03	-0.772	0.271	1.01	1.10	0001408356	0001402829	0001539551
1	Assets	-3.40	-1.88	-0.179	0.972	1.35	0001300938	0000052988	0000773141
2	Expenses	-2.60	-1.26	-0.164	0.635	0.767	0001425565	0000080035	0000100591
3	Revenues	-1.39	-0.899	0.255	1.33	1.51	0001300938	0000039677	0001357971
4	StockholdersEquity	-2.69	-1.72	-0.198	0.715	1.81	0001539551	0001048268	0000814046
5	NetIncome	-4.03	-2.18	0.218	0.475	0.918	0001300938	0001576940	0001048268
6	ComprehensiveNetIncome	-4.02	-2.17	0.227	0.485	0.929	0001300938	0001576940	0001048268
7	BaseVar	nan	nan	nan	nan	nan	0000039677	0001027884	0000039677
8	EconomicCapitalRatio	-5.93	-3.42	0.327	1.21	1.37	0001300938	0000773141	0000814046

2017

Logs

error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0000794170 0001534155
error	3 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000353020 0000773141 0000822416 0000861459 0000888504 0000906163 0001027884 0001050915 0001136294 0001357615 0001392363 0001539551 0001561257 0001634424 0000039677 0000042316 0000814046 0001095996 0001124198 0001723866 0001130385 0000920760 0000085974 0000794170 0000795266 0001065860 0001317577 0001501162 0001172069 0000878560 0001408356 0001531744 0001571274 0001572684 0001566265 0001574596
warning	31 × The stock price does not exist	industry.us_generic	0000353020 0000773141 0000822416 0000888504 0000915840 0001027884 0001392363 0001425565 0001532383 0001539551 0000039677 0000042316 0000357294 0001130385 0000920760 0000085974 0000795266 0000054441 0000882184 0001065860 0001082198 0001317577 0001373670 0001501162 0001510832 0000878560 0001303330 0001408356 0001572684 0001574596 0001374881
warning	25 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000915840 0000915840 0000915840 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000878560 0000878560 0000878560 0000878560
warning	23 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000799292 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000795266 0000882184
warning	22 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	14 × No stock price available	subcommand.plot	0000353020 0000773141 0000888504 0001027884 0001050915 0001392363 0001425565 0001539551 0001561257 0001634424 0000039677 0000042316 0000814046 0001682265
warning	8 × Ignoring company because Expenses is zero	pre-agg	0001532383 0000920760 0000920760 0001373670 0001510832 0001531744 0001531744 0001374881
warning	7 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001136294 0001095996 0001130385 0000920760 0000920760 0000920760 0000882184
warning	7 × Ignoring company because Liabilities is zero	pre-agg	0001392363 0001532383 0000814046 0000795266 0000795266 0000795266 0000795266
warning	5 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0001136294 0000920760 0000920760 0000920760
warning	3 × Missing logo	subcommand.report	0000100591 0000888504 0001561257
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000794170 0000795266
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.486992471829087}
warning	1 × Similarly named company. Duplicate?	None	0001357971
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000915840

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	LiabilitiesCurrent	0	0	131,003,510	1,903,276,000	5,689,447,000	0000039677	0001606163	0001027884
1	LiabilitiesNonCurrent	0	0	0	730,080,750	1,280,706,000	0000042316	0000042316	0000015615
2	NotesAndLoansPayable	0	0	0	593,382,750	1,379,240,000	0000015615	0000039677	0001562476
3	remainder_Liabilities	0	0	16,833,856	1,309,122,000	1,538,555,000	0000052988	0000888504	0000915840
4	AssetsCurrent	0	0	199,528,534	2,723,557,500	3,074,392,000	0000039677	0000080035	0000077543
5	AssetsNonCurrent	0	0	519,486	465,152,500	4,034,768,000	0000039677	0001136294	0000052988
6	Inventory	0	0	0	1,510,748,750	2,959,236,000	0000015615	0000052988	0001562476
7	Goodwill	0	0	45,518,627	1,963,816,500	3,342,746,000	0000773141	0001136294	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	42,081,156	556,800,750	774,151,000	0000042316	0000866273	0000052988
9	remainder_Assets	-3,766,986,000	-376,794,000	82,301,385	1,043,838,750	2,321,416,000	0000052988	0001048268	0000906163
10	remainder_Expenses	901,130	1,404,725	896,440,757	7,947,392,250	9,736,361,000	0000814046	0000874238	0000052988
11	remainder_Revenues	0	0	901,121,672	7,433,581,750	10,022,788,000	0000100591	0000874238	0000052988
12	remainder_NetIncome	-48,422,000	-35,990,250	0	74,242,250	846,911,000	0001372020	0000039677	0000906163
13	remainder_ComprehensiveNetIncome	-85,409,000	-15,383,000	0	38,568,250	121,000,000	0001562476	0001682265	0001357615

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	101,692	1,256,313	495,989,194	2,614,753,000	5,753,218,000	0001682265	0001580905	0001027884
1	Assets	64,799	319,994	856,957,934	5,560,159,750	7,380,859,000	0001682265	0001035983	0000052988
2	Expenses	901,130	1,404,725	896,440,757	7,947,392,250	9,736,361,000	0000814046	0000874238	0000052988
3	Revenues	0	0	901,121,672	7,433,581,750	10,022,788,000	0000100591	0000874238	0000052988
4	StockholdersEquity	-5,233,687	-837,326	370,309,612	2,186,103,750	5,454,632,000	0001539551	0001035983	0000052988
5	NetIncome	-1,424,561,000	-55,451,250	18,509,516	341,227,750	537,521,000	0001027884	0000700923	0000906163
6	ComprehensiveNetIncome	-1,401,823,000	-51,601,750	19,435,961	350,355,750	537,521,000	0001027884	0000700923	0000906163
7	BaseVar	2,173,946	4,305,110	2,406,240,974	18,233,263,688	21,975,624,875	0001682265	0000866273	0000052988
8	EconomicCapitalRatio	-3.44	-2.49	0.719	1.59	1.98	0001300938	0001357615	0000814046

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	LiabilitiesCurrent	-1.28	-0.722	0.168	0.518	0.886	0000100591	0001633931	0001561257
1	LiabilitiesNonCurrent	-0.952	-0.642	0.0722	0.289	0.346	0000039677	0000700923	0001682265
2	NotesAndLoansPayable	-1.10	-0.629	0.0599	0.102	0.144	0001576940	0000353020	0001682265
3	remainder_Liabilities	-1.34	-1.25	0.166	0.494	3.09	0000906163	0001027884	0001300938
4	AssetsCurrent	-2.09	-0.852	0.00634	1.12	1.41	0001682265	0000052988	0000100591
5	AssetsNonCurrent	-0.575	-0.152	-0.0342	0.409	0.624	0001682265	0001576940	0000067215
6	Inventory	-1.50	-0.563	-0.150	1.14	1.27	0001682265	0001372020	0000833079
7	Goodwill	-1.28	-0.448	-0.0220	0.333	0.679	0001682265	0001361538	0001633931
8	CashAndCashEquivalentsAtCarryingValue	-1.69	-0.574	-0.139	0.137	5.33	0001682265	0001634424	0000814046
9	remainder_Assets	-1.60	-0.808	-0.0901	0.530	1.63	0001682265	0001048268	0000773141
10	remainder_Expenses	-7.31	-0.908	-0.185	0.626	0.769	0001682265	0001580905	0000906163
11	remainder_Revenues	-1.59	-0.923	0.266	1.21	7.76	0001561257	0001539551	0001682265
12	remainder_NetIncome	-0.816	-0.340	-0.0663	0.296	1.42	0001425565	0000052988	0001561257
13	remainder_ComprehensiveNetIncome	-0.0250	-0.0103	-0.00166	0.0291	0.0707	0001562476	0000042316	0001136294

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.888	-0.670	0.249	0.806	0.944	0000100591	0001633931	0000080035
1	Assets	-2.91	-2.16	-0.159	0.925	1.34	0001682265	0000888504	0000773141
2	Expenses	-7.31	-0.908	-0.185	0.626	0.769	0001682265	0001580905	0000906163
3	Revenues	-1.59	-0.923	0.266	1.21	7.76	0001561257	0001539551	0001682265
4	StockholdersEquity	-5.74	-2.71	-0.163	0.773	2.02	0001682265	0000915840	0000814046
5	NetIncome	-2.70	-0.770	0.190	0.348	0.473	0001425565	0001562476	0000906163
6	ComprehensiveNetIncome	-2.70	-0.753	0.184	0.373	0.473	0001425565	0001488139	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001027884	0000015615
8	EconomicCapitalRatio	-3.87	-2.92	0.288	1.16	1.54	0001300938	0001357615	0000814046

2018

Logs

error	4 × Negative Expenses, ignoring company.	pre-agg	0001574596 0000773141 0000882184 0000882184
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0000794170
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001357971
warning	38 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000042316 0000052988 0000105634 0000353020 0000822416 0000861459 0000906163 0001050915 0001095996 0001124198 0001136294 0001357615 0001539551 0001634424 0001723866 0000795266 0001574596 0001130385 0000920760 0001027884 0000085974 0000773141 0000794170 0000888504 0001065860 0001317577 0001501162 0000814046 0001392363 0000039677 0001172069 0000878560 0001408356 0001531744 0001571274 0001572684 0001566265 0001561257
warning	34 × The stock price does not exist	industry.us_generic	0000042316 0000353020 0000822416 0001357971 0001425565 0001532383 0001539551 0000357294 0000915840 0000795266 0001748621 0001534155 0001574596 0001130385 0000920760 0001027884 0000085974 0000773141 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001373670 0001501162 0001392363 0000039677 0001510832 0000878560 0001303330 0001408356 0001572684 0001374881
warning	30 × Ignoring company because Assets is zero	pre-agg	0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840 0000915840 0000915840 0000915840 0000915840 0000795266 0000878560 0000878560 0000878560 0000878560
warning	23 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000799292 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000795266 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000773141 0000773141 0000882184
warning	22 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000773141 0000773141 0000773141 0000773141 0000882184
warning	10 × Ignoring company because Liabilities is zero	pre-agg	0001532383 0001532383 0001532383 0001532383 0000795266 0000795266 0000795266 0000795266 0000814046 0001392363
warning	9 × No stock price available	subcommand.plot	0000042316 0000353020 0001050915 0001095996 0001425565 0001539551 0001634424 0001723866 0001682265
warning	9 × Ignoring company because Expenses is zero	pre-agg	0001532383 0001748621 0000920760 0000920760 0001373670 0001510832 0001531744 0001531744 0001374881
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0000822416 0000822416 0000822416 0001136294 0000920760 0000920760 0000920760
warning	8 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000042316 0001095996 0001136294 0001130385 0000920760 0000920760 0000920760 0000882184
warning	2 × Similarly named company. Duplicate?	None	0001357971 0001718227
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000795266 0000794170
warning	2 × Missing logo	subcommand.report	0000100591 0001095996
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.3819454845874706}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000915840

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	LiabilitiesCurrent	0	0	168,797,440	2,210,687,000	3,552,513,000	0000799292	0001048268	0001124198
1	LiabilitiesNonCurrent	0	0	44,470	1,040,532,000	1,476,000,000	0000042316	0001300938	0001357615
2	NotesAndLoansPayable	0	0	0	987,277,000	3,203,500,000	0000015615	0001050915	0000882184
3	remainder_Liabilities	0	0	8,896,516	1,357,371,000	1,915,447,000	0000052988	0001718227	0001095996
4	AssetsCurrent	0	0	214,456,720	3,326,104,000	5,440,893,000	0000799292	0000080035	0001124198
5	AssetsNonCurrent	0	0	2,884,560	315,997,000	7,631,505,000	0000042316	0000700923	0000052988
6	Inventory	0	0	0	2,333,207,000	10,395,000,000	0000015615	0000042316	0000882184
7	Goodwill	0	0	76,594,864	1,781,000,000	6,759,957,000	0000833079	0001372020	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	45,624,016	793,358,000	1,764,746,000	0000799292	0001035983	0001124198
9	remainder_Assets	-7,095,609,000	-226,657,000	120,629,644	1,197,345,000	2,433,685,000	0000052988	0001580670	0000906163
10	remainder_Expenses	1,417,902	10,102,485	826,376,476	10,841,006,000	14,718,238,000	0001682265	0000100591	0000052988
11	remainder_Revenues	0	0	893,394,408	11,171,423,000	16,068,000,000	0000833079	0000100591	0000882184
12	remainder_NetIncome	-93,266,000	-56,936,000	-647	128,530,000	481,800,000	0000052988	0001682265	0001124198
13	remainder_ComprehensiveNetIncome	-208,361,000	-85,314,000	0	1,849,000	6,492,000	0001124198	0001539551	0000105634

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	165,098	4,207,198	515,370,548	3,470,334,000	4,955,700,000	0001682265	0001372020	0000882184
1	Assets	216,483	791,752	835,289,036	8,913,637,000	14,114,600,000	0001682265	0001580905	0000882184
2	Expenses	1,417,902	10,102,485	826,376,476	10,841,006,000	14,718,238,000	0001682265	0000100591	0000052988
3	Revenues	0	0	893,394,408	11,171,423,000	16,068,000,000	0000833079	0000100591	0000882184
4	StockholdersEquity	-8,665,727	51,385	470,282,904	5,361,124,000	9,500,102,000	0001539551	0000353020	0000052988
5	NetIncome	-410,133,000	-42,084,000	50,843,636	310,000,000	6,976,058,000	0000833079	0001718227	0000906163
6	ComprehensiveNetIncome	-410,133,000	-42,084,000	47,397,792	299,500,000	6,976,058,000	0000833079	0000861459	0000906163
7	BaseVar	2,750,500	19,949,182	2,322,941,821	24,638,694,375	36,493,462,500	0001682265	0000866273	0000882184
8	EconomicCapitalRatio	-5.63	-2.38	0.735	1.67	6.33	0001425565	0000700923	0000906163

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	LiabilitiesCurrent	-1.03	-0.351	0.0630	0.653	1.76	0001124198	0000874238	0001539551
1	LiabilitiesNonCurrent	-1.06	-0.707	0.0683	0.331	0.722	0001580670	0001124198	0001682265
2	NotesAndLoansPayable	-1.02	-0.499	0.147	0.238	0.539	0001576940	0000015615	0001682265
3	remainder_Liabilities	-2.29	-1.01	0.170	0.385	0.838	0000906163	0000077543	0001682265
4	AssetsCurrent	-0.980	-0.384	0.0201	0.720	1.83	0001300938	0001357971	0001425565
5	AssetsNonCurrent	-0.226	-0.136	-0.0285	0.0967	0.756	0001425565	0001580670	0000052988
6	Inventory	-1.33	-0.817	-0.246	1.04	1.78	0001425565	0001723866	0000833079
7	Goodwill	-0.751	-0.455	-0.0227	0.444	0.615	0001425565	0000861459	0001633931
8	CashAndCashEquivalentsAtCarryingValue	-0.454	-0.318	-0.0398	0.0853	1.95	0000906163	0001580670	0001425565
9	remainder_Assets	-3.02	-0.896	-0.0265	0.477	0.631	0000906163	0001580905	0001372020
10	remainder_Expenses	-2.99	-1.03	-0.183	0.725	2.55	0001425565	0001718227	0000906163
11	remainder_Revenues	-3.06	-0.795	0.263	0.938	3.62	0001425565	0000052988	0001682265
12	remainder_NetIncome	-0.908	-0.405	0.0210	0.111	0.141	0001300938	0000906163	0001124198
13	remainder_ComprehensiveNetIncome	-0.0436	-0.0139	0.00507	0.0106	0.0198	0000080035	0000882184	0001682265

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.12	-0.704	0.296	0.875	1.73	0001576940	0001361538	0001682265
1	Assets	-2.50	-0.814	-0.137	1.22	1.53	0001300938	0000100591	0000833079
2	Expenses	-2.99	-1.03	-0.183	0.725	2.55	0001425565	0001718227	0000906163
3	Revenues	-3.06	-0.795	0.263	0.938	3.62	0001425565	0000052988	0001682265
4	StockholdersEquity	-2.72	-2.48	-0.113	0.718	1.00	0001539551	0001050915	0001488139
5	NetIncome	-6.78	-1.28	0.0940	0.344	5.39	0001425565	0001050915	0000906163
6	ComprehensiveNetIncome	-6.77	-1.28	0.0965	0.355	5.40	0001425565	0001488139	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001124198	0000015615
8	EconomicCapitalRatio	-6.24	-3.00	0.119	1.05	5.71	0001425565	0000700923	0000906163

2019

Logs

error	4 × Negative Expenses, ignoring company.	pre-agg	0001574596 0000773141 0000882184 0000882184
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000794170 0000794170
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001357971
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000042316 0000105634 0000353020 0000795266 0000822416 0000906163 0001050915 0001124198 0001136294 0001357615 0001723866 0001574596 0000052988 0000773141 0000861459 0000920760 0001510832 0001130385 0001027884 0000085974 0000794170 0000888504 0001065860 0001317577 0001501162 0000814046 0001392363 0000039677 0001172069 0000878560 0001408356 0001531744 0001571274 0001572684 0001539551 0001566265 0001634424 0001561257 0001095996
warning	36 × The stock price does not exist	industry.us_generic	0000042316 0000353020 0000795266 0000822416 0001357971 0001532383 0001723866 0001748621 0000357294 0000915840 0001534155 0001574596 0000773141 0000920760 0001510832 0001784567 0001130385 0001027884 0000085974 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001373670 0001425565 0001501162 0001392363 0000039677 0000878560 0001303330 0001408356 0001572684 0001539551 0001374881
warning	30 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000795266 0000795266 0000795266 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000773141 0000773141 0000773141 0000773141 0000773141 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184 0000799292
warning	29 × Ignoring company because Assets is zero	pre-agg	0000795266 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840 0000915840 0000915840 0000915840 0000920760 0001510832 0000878560 0000878560 0000878560 0000878560
warning	25 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	13 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0001532383 0001532383 0001532383 0001532383 0001532383 0000814046 0001392363
warning	12 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000042316 0001136294 0001682265 0001574596 0000920760 0000920760 0000920760 0000920760 0000920760 0001130385 0000882184 0001095996
warning	12 × Ignoring company because Expenses is zero	pre-agg	0001532383 0001748621 0001748621 0001748621 0001748621 0000920760 0000920760 0001510832 0001373670 0001531744 0001531744 0001374881
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0000822416 0000822416 0001136294 0000920760 0000920760 0000920760 0001561680
warning	6 × No stock price available	subcommand.plot	0000042316 0000353020 0001050915 0001682265 0001723866 0001534155
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000795266 0000794170 0000866273
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000915840
warning	1 × Missing logo	subcommand.report	0000100591

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	LiabilitiesCurrent	0	0	163,953,946	2,375,447,000	3,932,061,000	0000799292	0001402829	0001124198
1	LiabilitiesNonCurrent	0	0	37,592,300	1,473,616,250	1,652,000,000	0000042316	0001718227	0001357615
2	NotesAndLoansPayable	0	0	0	1,201,463,500	3,399,400,000	0000015615	0000042316	0000882184
3	remainder_Liabilities	0	0	37,309,740	1,144,230,500	1,912,100,000	0000080035	0000042316	0000882184
4	AssetsCurrent	0	0	288,268,212	3,590,986,000	5,516,272,000	0000799292	0001048268	0001124198
5	AssetsNonCurrent	0	0	4,316,878	414,602,000	1,001,063,000	0000100591	0001048268	0000067215
6	Inventory	0	0	0	3,054,906,750	11,282,000,000	0000015615	0000067215	0000882184
7	Goodwill	0	0	76,912,842	1,696,516,250	2,436,409,000	0000833079	0001048268	0001050915
8	CashAndCashEquivalentsAtCarryingValue	0	0	53,128,268	907,575,000	1,997,199,000	0000906163	0001576940	0001124198
9	remainder_Assets	-615,216,000	-226,198,500	128,603,682	1,796,368,750	3,809,815,000	0000067215	0001723866	0000906163
10	remainder_Expenses	1,719,143	7,705,669	1,055,469,411	12,847,202,750	16,065,700,000	0001682265	0000874238	0001124198
11	remainder_Revenues	0	0	1,170,413,300	12,671,119,250	17,592,900,000	0000833079	0000353020	0000882184
12	remainder_NetIncome	-63,704,000	-34,941,750	-116,644	97,508,750	164,558,000	0000015615	0001534155	0001124198
13	remainder_ComprehensiveNetIncome	-84,000,000	-18,759,500	0	14,478,750	194,618,000	0001357615	0001300938	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	151,464	34,061,998	781,106,175	4,018,508,500	5,311,500,000	0001682265	0001580670	0000882184
1	Assets	7,396	631,882	1,237,706,869	8,057,914,000	15,606,600,000	0001534155	0001488139	0000882184
2	Expenses	1,719,143	7,705,669	1,055,469,411	12,847,202,750	16,065,700,000	0001682265	0000874238	0001124198
3	Revenues	0	0	1,170,413,300	12,671,119,250	17,592,900,000	0000833079	0000353020	0000882184
4	StockholdersEquity	-44,663,807	-257,660	567,778,543	4,039,405,500	10,295,100,000	0001534155	0001035983	0000882184
5	NetIncome	-1,553,124,000	-379,815,250	45,838,675	709,761,250	7,216,028,000	0001124198	0001372020	0000906163
6	ComprehensiveNetIncome	-1,455,815,000	-388,858,750	46,709,478	724,558,375	7,216,028,000	0001124198	0000100591	0000906163
7	BaseVar	3,327,792	24,626,926	2,874,142,643	28,696,663,688	39,980,500,000	0001682265	0000353020	0000882184
8	EconomicCapitalRatio	-3.06	-0.536	0.698	1.81	5.81	0001534155	0001035983	0000906163

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	LiabilitiesCurrent	-0.405	-0.163	0.163	1.24	6.61	0000077543	0001580905	0001534155
1	LiabilitiesNonCurrent	-0.812	-0.666	0.0349	0.514	1.01	0001580670	0000700923	0001682265
2	NotesAndLoansPayable	-0.904	-0.692	0.171	0.342	0.706	0001576940	0001723866	0001682265
3	remainder_Liabilities	-1.96	-0.649	0.189	0.497	1.01	0000906163	0001580905	0001682265
4	AssetsCurrent	-0.636	-0.293	0.0767	0.439	0.799	0001300938	0000105634	0000077543
5	AssetsNonCurrent	-0.0741	-0.0385	-0.0138	0.0456	0.659	0001300938	0001373670	0000067215
6	Inventory	-0.946	-0.422	-0.270	1.06	1.76	0001300938	0000353020	0000833079
7	Goodwill	-0.476	-0.166	-0.0232	0.336	0.542	0001300938	0001488139	0001633931
8	CashAndCashEquivalentsAtCarryingValue	-0.274	-0.124	-0.0320	0.160	0.204	0001300938	0000874238	0001124198
9	remainder_Assets	-5.35	-0.373	-0.0609	0.208	0.525	0000906163	0001633931	0001488139
10	remainder_Expenses	-3.33	-1.02	-0.181	0.521	2.25	0001682265	0000015615	0000906163
11	remainder_Revenues	-0.973	-0.778	0.220	1.39	3.60	0001534155	0000882184	0001682265
12	remainder_NetIncome	-1.06	-0.0415	0.0187	0.0769	0.124	0001300938	0000906163	0001576940
13	remainder_ComprehensiveNetIncome	-0.0167	-0.00587	-0.000208	0.00687	0.0283	0001357615	0001723866	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.961	-0.387	0.354	1.41	3.84	0001576940	0001373670	0001534155
1	Assets	-1.88	-0.695	-0.140	0.591	1.64	0001300938	0000042316	0000833079
2	Expenses	-3.33	-1.02	-0.181	0.521	2.25	0001682265	0000015615	0000906163
3	Revenues	-0.973	-0.778	0.220	1.39	3.60	0001534155	0000882184	0001682265
4	StockholdersEquity	-2.52	-1.49	-0.00972	1.00	1.06	0001534155	0001357615	0000100591
5	NetIncome	-1.76	-0.664	-0.00728	0.240	4.68	0001300938	0000042316	0000906163
6	ComprehensiveNetIncome	-1.77	-0.643	-0.00770	0.236	4.68	0001300938	0000042316	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001050915	0000015615
8	EconomicCapitalRatio	-3.81	-1.29	-0.0565	1.05	5.06	0001534155	0001035983	0000906163

2020

Logs

error	4 × Negative Expenses, ignoring company.	pre-agg	0000773141 0001574596 0000882184 0000882184
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001357971
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000353020 0000773141 0000795266 0000822416 0000861459 0000906163 0000920760 0001050915 0001124198 0001136294 0001357615 0001574596 0001723866 0001510832 0001130385 0001027884 0000085974 0000794170 0000042316 0000888504 0001065860 0001317577 0001501162 0000814046 0001392363 0000039677 0001172069 0000878560 0001408356 0001531744 0001571274 0001572684 0001539551 0001566265 0001634424 0001561257 0001095996
warning	38 × The stock price does not exist	industry.us_generic	0000353020 0000773141 0000795266 0000822416 0000920760 0001357971 0001532383 0001574596 0001723866 0001748621 0001510832 0001534155 0001784567 0000357294 0000894501 0001374881 0001839412 0001130385 0001027884 0000085974 0000042316 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001373670 0001425565 0001501162 0001392363 0000039677 0000915840 0000878560 0001303330 0001408356 0001572684 0001539551
warning	36 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000795266 0000795266 0000795266 0000795266 0000795266 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000357294 0000799292 0000882184
warning	29 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000357294 0000882184
warning	26 × Ignoring company because Assets is zero	pre-agg	0000795266 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000920760 0001510832 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000915840 0000915840 0000915840 0000878560 0000878560 0000878560 0000878560
warning	16 × Ignoring company because Expenses is zero	pre-agg	0000920760 0000920760 0001532383 0001748621 0001748621 0001748621 0001748621 0001748621 0001510832 0001374881 0001374881 0001374881 0001839412 0001373670 0001531744 0001531744
warning	14 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0001532383 0001532383 0001532383 0001532383 0000814046 0001392363
warning	13 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000920760 0000920760 0000920760 0000920760 0000920760 0001136294 0001574596 0001682265 0001721386 0001130385 0000042316 0000882184 0001095996
warning	8 × No stock price available	subcommand.plot	0000353020 0000773141 0000861459 0001574596 0001723866 0001785493 0001534155 0001784567
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0000822416 0000920760 0000920760 0000920760 0001136294 0001561680
warning	2 × Similarly named company. Duplicate?	None	0001357971 0001718227
warning	2 × Missing logo	subcommand.report	0000100591 0001574596
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000866273

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	LiabilitiesCurrent	0	0	102,614,503	2,540,071,700	3,572,037,000	0000773141	0000080035	0001124198
1	LiabilitiesNonCurrent	0	0	0	1,152,036,650	2,151,000,000	0000052988	0001373670	0001357615
2	NotesAndLoansPayable	0	0	0	3,037,067,050	4,283,300,000	0000015615	0000067215	0000882184
3	remainder_Liabilities	0	0	52,350,879	2,421,405,300	2,674,067,000	0000052988	0001574596	0000906163
4	AssetsCurrent	0	0	195,657,178	3,908,233,200	5,034,009,000	0000773141	0001606163	0001124198
5	AssetsNonCurrent	0	0	1,078,897	382,213,050	7,495,383,000	0000100591	0001703956	0000052988
6	Inventory	0	0	0	6,844,638,000	12,237,400,000	0000015615	0000700923	0000882184
7	Goodwill	0	0	54,653,824	2,090,736,600	6,297,431,000	0000773141	0001488139	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	101,121,926	2,480,526,100	3,018,500,000	0000773141	0001574596	0000882184
9	remainder_Assets	-6,840,484,000	-373,567,950	152,627,998	2,641,342,400	3,864,920,000	0000052988	0001402829	0000773141
10	remainder_Expenses	120,449	1,146,102	825,991,392	12,274,560,700	18,023,500,000	0001721386	0001373670	0000882184
11	remainder_Revenues	0	0	1,310,245,813	12,739,468,950	20,311,100,000	0000794170	0000874238	0000882184
12	remainder_NetIncome	-141,147,000	-37,509,150	-6,915	77,535,000	586,901,000	0001124198	0001682265	0000794170
13	remainder_ComprehensiveNetIncome	-117,000,000	-48,473,050	0	2,067,400	18,674,000	0001357615	0001576940	0000861459

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	58,875	5,036,406	778,640,636	5,113,566,600	6,790,800,000	0001785493	0001580905	0000882184
1	Assets	63,647	1,139,367	1,753,836,389	11,806,580,250	18,912,300,000	0001534155	0001035983	0000882184
2	Expenses	120,449	1,146,102	825,991,392	12,274,560,700	18,023,500,000	0001721386	0001373670	0000882184
3	Revenues	0	0	1,310,245,813	12,739,468,950	20,311,100,000	0000794170	0000874238	0000882184
4	StockholdersEquity	-53,318,024	494,515	679,847,842	5,995,109,450	12,121,500,000	0001534155	0001035983	0000882184
5	NetIncome	-548,031,000	-129,364,150	54,596,071	3,462,426,900	9,664,769,000	0000833079	0001488139	0000822416
6	ComprehensiveNetIncome	-548,031,000	-140,273,600	53,423,653	3,462,426,900	9,664,819,000	0000833079	0001488139	0000822416
7	BaseVar	1,751,917	15,516,905	3,563,237,124	29,094,556,494	46,475,612,500	0001785493	0001580905	0000882184
8	EconomicCapitalRatio	-2.89	0.126	0.756	3.08	6.43	0001534155	0001357971	0001682265

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	LiabilitiesCurrent	-1.94	-0.367	0.0999	0.602	7.90	0001682265	0001723866	0001534155
1	LiabilitiesNonCurrent	-0.834	-0.634	0.0879	0.310	1.05	0001703956	0001402829	0001682265
2	NotesAndLoansPayable	-1.13	-0.769	0.203	0.335	1.04	0001561680	0000015615	0001682265
3	remainder_Liabilities	-1.81	-1.16	0.247	0.506	1.08	0000906163	0000077543	0001682265
4	AssetsCurrent	-0.457	-0.316	0.0521	0.578	7.04	0001784567	0000822416	0001785493
5	AssetsNonCurrent	-0.0501	-0.0447	-0.0159	0.106	0.688	0001606163	0000353020	0000052988
6	Inventory	-0.504	-0.443	-0.209	0.947	1.36	0001300938	0001372020	0000833079
7	Goodwill	-0.225	-0.173	-0.0235	0.461	0.757	0001300938	0000080035	0001703956
8	CashAndCashEquivalentsAtCarryingValue	-0.504	-0.257	-0.0772	0.149	4.27	0000906163	0000799292	0001785493
9	remainder_Assets	-1.31	-0.531	-0.0961	0.897	2.93	0000773141	0001718227	0001721386
10	remainder_Expenses	-1.44	-1.31	-0.299	1.21	1.78	0001124198	0000882184	0001682265
11	remainder_Revenues	-1.20	-0.795	0.285	0.998	4.53	0001785493	0000080035	0001682265
12	remainder_NetIncome	-0.173	-0.114	-0.0112	0.0702	0.212	0000353020	0000105634	0001576940
13	remainder_ComprehensiveNetIncome	-0.0197	-0.00803	0.000961	0.00280	0.0116	0001357615	0000906163	0000861459

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.886	-0.462	0.282	0.932	2.76	0000794170	0000799292	0001534155
1	Assets	-1.23	-0.825	-0.206	1.25	2.14	0001534155	0000773141	0001682265
2	Expenses	-1.44	-1.31	-0.299	1.21	1.78	0001124198	0000882184	0001682265
3	Revenues	-1.20	-0.795	0.285	0.998	4.53	0001785493	0000080035	0001682265
4	StockholdersEquity	-2.64	-1.52	-0.161	0.810	1.70	0001534155	0000861459	0001785493
5	NetIncome	-1.71	-0.669	-0.216	2.02	6.29	0001785493	0001050915	0001682265
6	ComprehensiveNetIncome	-1.71	-0.673	-0.217	2.02	6.29	0001785493	0001050915	0001682265
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001124198	0000015615
8	EconomicCapitalRatio	-3.88	-0.866	-0.237	2.09	5.43	0001534155	0001357971	0001682265

2021

Logs

error	4 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184 0001574596
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001357971
warning	41 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000357294 0000357294 0000357294 0000357294 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000799292 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	39 × The stock price does not exist	industry.us_generic	0000357294 0000773141 0000795266 0000822416 0001357971 0001534155 0001748621 0000894501 0001374881 0001510832 0001784567 0001839412 0001043150 0001130385 0000920760 0001027884 0000085974 0000042316 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001373670 0001425565 0001501162 0001392363 0000039677 0000915840 0000353020 0000878560 0001303330 0001408356 0001572684 0001539551 0001574596 0001532383 0001723866
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000773141 0000795266 0000822416 0000861459 0000906163 0001050915 0001124198 0001136294 0001357615 0001510832 0001172069 0001130385 0000920760 0001027884 0000085974 0000794170 0000042316 0000888504 0001065860 0001317577 0001501162 0000814046 0001392363 0000039677 0000353020 0000878560 0001408356 0001531744 0001571274 0001572684 0001539551 0001566265 0001574596 0001634424 0001561257 0001095996 0001723866
warning	34 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000357294 0000357294 0000357294 0000357294 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	27 × Ignoring company because Assets is zero	pre-agg	0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000795266 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0001510832 0001043150 0000920760 0000915840 0000915840 0000915840 0000878560 0000878560 0000878560 0000878560
warning	15 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001136294 0001682265 0001721386 0001721386 0001721386 0001721386 0001130385 0000920760 0000920760 0000920760 0000920760 0000042316 0000882184 0001574596 0001095996
warning	15 × Ignoring company because Expenses is zero	pre-agg	0001748621 0001748621 0001748621 0001748621 0001374881 0001374881 0001374881 0001510832 0001839412 0000920760 0000920760 0001373670 0001531744 0001531744 0001532383
warning	14 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000814046 0001392363 0001532383 0001532383 0001532383
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0000822416 0001136294 0000920760 0000920760 0000920760 0001561680
warning	6 × No stock price available	subcommand.plot	0000773141 0001534155 0001785493 0000894501 0001510832 0001784567
warning	2 × Similarly named company. Duplicate?	None	0001357971 0001718227
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.230918710468262}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001357971
warning	1 × Missing logo	subcommand.report	0000100591

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	LiabilitiesCurrent	0	0	48,525,480	2,965,997,500	3,904,060,000	0000357294	0001703956	0001124198
1	LiabilitiesNonCurrent	0	0	538,151	1,909,305,500	3,894,901,000	0000052988	0001300938	0001050915
2	NotesAndLoansPayable	0	0	0	2,771,701,500	5,412,400,000	0000015615	0000357294	0000882184
3	remainder_Liabilities	0	0	69,967,434	2,806,984,500	3,387,300,000	0000052988	0001784567	0000882184
4	AssetsCurrent	0	0	68,245,435	4,077,193,500	5,562,642,000	0000357294	0001703956	0001124198
5	AssetsNonCurrent	0	0	268,545	496,165,500	9,987,597,000	0000100591	0001606163	0000052988
6	Inventory	0	0	0	4,616,964,500	9,047,569,000	0000015615	0001035983	0000822416
7	Goodwill	0	0	53,782,675	2,479,427,500	8,762,758,000	0000357294	0000861459	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	82,100,930	1,736,029,500	3,210,400,000	0000357294	0000700923	0000882184
9	remainder_Assets	-9,423,890,000	-548,250,500	216,909,660	3,644,051,000	20,642,000,000	0000052988	0001373670	0000882184
10	remainder_Expenses	92,044	1,254,806	1,468,334,770	12,590,370,500	23,620,500,000	0000894501	0001048268	0000882184
11	remainder_Revenues	0	33,134	2,142,092,930	13,453,547,500	27,774,200,000	0000833079	0000915840	0000882184
12	remainder_NetIncome	-254,878,000	-62,587,500	0	33,348,000	79,438,000	0001124198	0001606163	0000794170
13	remainder_ComprehensiveNetIncome	-39,119,000	-12,090,158	0	38,334,500	194,000,000	0000077543	0001048268	0001357615

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	10,285	1,475,982	1,133,374,525	6,030,255,500	8,799,700,000	0000894501	0000067215	0000882184
1	Assets	1,700	283,224	2,079,461,520	13,103,910,000	24,015,900,000	0000894501	0000915840	0000882184
2	Expenses	92,044	1,254,806	1,468,334,770	12,590,370,500	23,620,500,000	0000894501	0001048268	0000882184
3	Revenues	0	33,134	2,142,092,930	13,453,547,500	27,774,200,000	0000833079	0000915840	0000882184
4	StockholdersEquity	-59,094,972	-867,826	805,694,210	6,414,985,000	15,216,200,000	0001534155	0001035983	0000882184
5	NetIncome	-697,884,000	-23,148,500	68,733,575	4,622,130,000	12,090,780,000	0000833079	0001048268	0000822416
6	ComprehensiveNetIncome	-697,884,000	-22,177,500	76,678,235	4,622,130,000	12,090,830,000	0000833079	0001488139	0000822416
7	BaseVar	86,531	3,990,462	5,164,882,517	30,250,179,938	61,410,975,000	0000894501	0000700923	0000882184
8	EconomicCapitalRatio	-28.5	-2.23	0.715	3.17	4.25	0000894501	0001633931	0000906163

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	LiabilitiesCurrent	-0.798	-0.359	0.0674	0.709	5.15	0000100591	0001633931	0000894501
1	LiabilitiesNonCurrent	-7.16	-0.758	0.142	0.363	0.460	0000894501	0001785493	0000906163
2	NotesAndLoansPayable	-3.73	-0.886	0.103	0.194	0.211	0000894501	0001580905	0000906163
3	remainder_Liabilities	-10.9	-1.25	0.325	0.650	5.91	0000894501	0000015615	0001534155
4	AssetsCurrent	-13.4	-0.348	0.0605	0.636	3.98	0000894501	0001488139	0001785493
5	AssetsNonCurrent	-2.16	-0.0519	-0.0149	0.0263	0.860	0000894501	0001373670	0000052988
6	Inventory	-11.7	-0.498	-0.204	0.753	1.74	0000894501	0000077543	0000833079
7	Goodwill	-8.06	-0.230	-0.0298	0.426	0.612	0000894501	0001562476	0001703956
8	CashAndCashEquivalentsAtCarryingValue	-9.64	-0.259	-0.0885	0.153	2.41	0000894501	0001580670	0001785493
9	remainder_Assets	-10.4	-1.46	-0.0673	0.881	1.39	0000894501	0001361538	0001784567
10	remainder_Expenses	-17.9	-1.08	-0.176	1.23	1.63	0000894501	0001580905	0000906163
11	remainder_Revenues	-9.95	-0.815	0.168	1.03	1.62	0000894501	0000874238	0000906163
12	remainder_NetIncome	-3.12	-0.0628	0.0274	0.0939	0.373	0001682265	0001561680	0001357971
13	remainder_ComprehensiveNetIncome	-0.0220	-0.00660	-0.000684	0.00609	0.0309	0000080035	0000357294	0001357615

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-13.6	-0.317	0.240	0.978	1.92	0000894501	0001682265	0001534155
1	Assets	-22.7	-1.04	-0.123	0.551	1.57	0000894501	0000861459	0000833079
2	Expenses	-17.9	-1.08	-0.176	1.23	1.63	0000894501	0001580905	0000906163
3	Revenues	-9.95	-0.815	0.168	1.03	1.62	0000894501	0000874238	0000906163
4	StockholdersEquity	-3.90	-2.22	0.135	0.898	1.89	0000894501	0001633931	0001785493
5	NetIncome	-27.7	-0.773	-0.1000	2.17	3.28	0000894501	0000874238	0000906163
6	ComprehensiveNetIncome	-27.7	-0.773	-0.0999	2.17	3.28	0000894501	0000874238	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001136294	0000015615
8	EconomicCapitalRatio	-28.8	-2.51	0.433	2.89	3.97	0000894501	0001633931	0000906163

2022

Logs

error	4 × Negative Expenses, ignoring company.	pre-agg	0000773141 0000882184 0000882184 0001574596
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001357971
warning	48 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000357294 0000357294 0000357294 0000357294 0000357294 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0001784567 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184 0000799292
warning	39 × The stock price does not exist	industry.us_generic	0000357294 0000773141 0000795266 0000822416 0001357971 0001043150 0001374881 0001510832 0001784567 0000920760 0001532383 0001130385 0001027884 0000085974 0000042316 0000054441 0000882184 0000888504 0001065860 0001082198 0001317577 0001373670 0001425565 0001501162 0001392363 0000039677 0000915840 0000353020 0000878560 0001303330 0001408356 0001572684 0001539551 0001574596 0001723866 0001748621 0001534155 0000894501 0001839412
warning	39 × The EntityCommonStockSharesOutstanding does not exist	industry.us_generic	0000052988 0000105634 0000773141 0000795266 0000822416 0000861459 0000906163 0001050915 0001124198 0001136294 0001172069 0001357615 0001510832 0000920760 0001130385 0001027884 0000085974 0000794170 0000042316 0000888504 0001065860 0001317577 0001501162 0000814046 0001392363 0000039677 0000353020 0000878560 0001408356 0001531744 0001571274 0001572684 0001539551 0001566265 0001574596 0001634424 0001561257 0001095996 0001723866
warning	39 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000357294 0000357294 0000357294 0000357294 0000357294 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000773141 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000906163 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000920760 0000882184
warning	27 × Ignoring company because Assets is zero	pre-agg	0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000357294 0000795266 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0000822416 0001043150 0001510832 0000920760 0000915840 0000915840 0000915840 0000878560 0000878560 0000878560 0000878560
warning	18 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001136294 0001682265 0001682265 0001682265 0001721386 0001721386 0001721386 0001721386 0001721386 0000920760 0000920760 0000920760 0000920760 0001130385 0000042316 0000882184 0001574596 0001095996
warning	17 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0000795266 0001532383 0001532383 0001532383 0001532383 0001532383 0000814046 0001392363
warning	13 × Ignoring company because Expenses is zero	pre-agg	0001374881 0001374881 0001510832 0000920760 0000920760 0001532383 0001373670 0001531744 0001531744 0001748621 0001748621 0001748621 0001839412
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000822416 0000822416 0001136294 0000920760 0000920760 0000920760 0001561680
warning	5 × No stock price available	subcommand.plot	0000773141 0001172069 0001374881 0001510832 0001784567
warning	3 × Missing logo	subcommand.report	0000100591 0001172069 0001374881
warning	2 × Similarly named company. Duplicate?	None	0001357971 0001718227
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -1.8275400263939108}

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	LiabilitiesCurrent	0	0	110,305,275	3,156,963,500	3,973,713,000	0000357294	0001703956	0001050915
1	LiabilitiesNonCurrent	0	0	510,441	2,101,500,000	3,863,944,000	0000052988	0001300938	0001050915
2	NotesAndLoansPayable	0	0	0	2,111,658,000	6,066,900,000	0000015615	0000906163	0000882184
3	remainder_Liabilities	-529,344	0	73,296,830	2,678,908,000	4,498,600,000	0001172069	0000874238	0000882184
4	AssetsCurrent	0	0	82,062,425	4,290,560,500	5,536,070,000	0000357294	0001703956	0001050915
5	AssetsNonCurrent	0	0	522,555	515,946,500	9,591,749,000	0000100591	0001606163	0000052988
6	Inventory	0	0	0	4,864,569,500	11,326,017,000	0000015615	0000700923	0000822416
7	Goodwill	0	0	68,664,320	3,578,670,000	8,578,710,000	0000357294	0001721386	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	115,574,500	1,243,616,500	2,540,500,000	0000357294	0001488139	0000882184
9	remainder_Assets	-9,372,513,000	-183,041,500	250,998,400	3,962,651,000	27,647,100,000	0000052988	0000700923	0000882184
10	remainder_Expenses	93,214	903,032	1,700,136,485	13,941,939,000	27,643,700,000	0001172069	0001488139	0000882184
11	remainder_Revenues	0	16,482	2,671,105,935	15,575,910,000	33,480,000,000	0000833079	0001580905	0000882184
12	remainder_NetIncome	-82,061,000	-55,754,000	0	48,341,500	195,100,000	0000015615	0001606163	0000794170
13	remainder_ComprehensiveNetIncome	-267,000,000	-58,221,000	0	22,465,000	40,787,000	0001796209	0001606163	0001580905

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	66,680	1,155,658	1,312,912,015	6,409,473,000	10,565,500,000	0001785493	0000915840	0000882184
1	Assets	246	387,097	2,252,558,870	14,062,378,000	30,351,100,000	0001374881	0000915840	0000882184
2	Expenses	93,214	903,032	1,700,136,485	13,941,939,000	27,643,700,000	0001172069	0001488139	0000882184
3	Revenues	0	16,482	2,671,105,935	15,575,910,000	33,480,000,000	0000833079	0001580905	0000882184
4	StockholdersEquity	-5,939,743	-1,081,660	939,589,185	7,467,969,000	19,785,600,000	0001510832	0000915840	0000882184
5	NetIncome	-810,703,000	-48,977,500	83,456,840	5,646,998,500	14,011,814,000	0000833079	0000700923	0000822416
6	ComprehensiveNetIncome	-810,703,000	-62,556,500	83,227,462	5,646,998,500	14,011,836,500	0000833079	0000861459	0000822416
7	BaseVar	430,453	3,047,746	6,100,817,328	31,920,071,812	73,993,425,000	0001374881	0001580670	0000882184
8	EconomicCapitalRatio	-3.60	-1.83	0.708	3.39	5.50	0001374881	0001048268	0000906163

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	LiabilitiesCurrent	-0.755	-0.147	0.349	1.43	3.47	0001300938	0001785493	0001510832
1	LiabilitiesNonCurrent	-0.795	-0.653	0.107	0.396	0.771	0001703956	0001357971	0001682265
2	NotesAndLoansPayable	-1.03	-0.449	0.199	0.427	0.656	0001561680	0001721386	0001682265
3	remainder_Liabilities	-1.90	-1.34	0.0970	0.367	0.712	0000906163	0000015615	0001682265
4	AssetsCurrent	-0.516	-0.298	0.0749	0.731	7.91	0001374881	0001796209	0001785493
5	AssetsNonCurrent	-0.0745	-0.0445	-0.0164	0.0447	0.775	0001682265	0001580670	0000052988
6	Inventory	-0.786	-0.447	-0.240	0.772	1.60	0000822416	0000874238	0000833079
7	Goodwill	-0.286	-0.199	-0.0393	0.455	0.612	0001682265	0000833079	0001796209
8	CashAndCashEquivalentsAtCarryingValue	-0.293	-0.226	-0.0734	0.205	11.6	0001136294	0001633931	0001785493
9	remainder_Assets	-4.80	-0.666	-0.0610	0.936	2.16	0000906163	0001721386	0001784567
10	remainder_Expenses	-1.29	-1.18	-0.192	1.23	1.89	0001048268	0000015615	0000906163
11	remainder_Revenues	-1.15	-0.813	0.156	1.01	3.05	0001374881	0001050915	0001682265
12	remainder_NetIncome	-2.27	-0.0710	0.0203	0.0851	0.212	0001682265	0000052988	0000866273
13	remainder_ComprehensiveNetIncome	-0.0331	-0.0159	0.00202	0.00901	0.0263	0001796209	0001580670	0001580905

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.593	-0.327	0.423	1.48	4.26	0001784567	0001562476	0001374881
1	Assets	-1.43	-0.841	-0.153	0.677	2.47	0001374881	0000906163	0001785493
2	Expenses	-1.29	-1.18	-0.192	1.23	1.89	0001048268	0000015615	0000906163
3	Revenues	-1.15	-0.813	0.156	1.01	3.05	0001374881	0001050915	0001682265
4	StockholdersEquity	-2.52	-1.88	0.161	1.00	1.92	0001374881	0000866273	0001785493
5	NetIncome	-1.43	-0.712	-0.193	2.23	4.19	0001785493	0001357615	0000906163
6	ComprehensiveNetIncome	-1.43	-0.712	-0.191	2.23	4.19	0001785493	0001357615	0000906163
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001172069	0000015615
8	EconomicCapitalRatio	-4.43	-2.66	-0.121	2.56	4.67	0001374881	0001048268	0000906163

2023

Logs

warning	6 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000357294 0000773141 0000795266 0000906163 0000920760 0001784567
warning	5 × The stock price does not exist	industry.us_generic	0000773141 0000795266 0001784567 0001374881 0001532383
warning	4 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000357294 0000773141 0000906163 0000920760
warning	3 × No stock price available	subcommand.plot	0000773141 0001784567 0001374881
warning	3 × Missing logo	subcommand.report	0000100591 0000920760 0001374881
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001682265 0001721386
warning	2 × Ignoring company because Liabilities is zero	pre-agg	0000795266 0001532383
warning	1 × Similarly named company. Duplicate?	None	0001718227

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	LiabilitiesCurrent	0	0	123,200,873	3,383,626,850	5,849,366,000	0000357294	0001606163	0001050915
1	LiabilitiesNonCurrent	0	0	29,051	2,312,750,000	3,850,500,000	0000052988	0001785493	0001050915
2	NotesAndLoansPayable	0	0	0	1,875,273,200	5,094,500,000	0000015615	0000052988	0000882184
3	remainder_Liabilities	0	0	126,971,631	3,623,349,800	12,532,337,000	0000052988	0001784567	0000920760
4	AssetsCurrent	0	0	156,615,106	4,653,845,700	7,676,897,000	0000357294	0001606163	0001050915
5	AssetsNonCurrent	0	0	214,270	543,554,000	9,569,724,000	0000100591	0001606163	0000052988
6	Inventory	0	0	0	4,513,719,800	11,795,370,000	0000015615	0000874238	0000822416
7	Goodwill	0	0	104,015,854	3,913,943,900	8,615,469,000	0000357294	0000822416	0000052988
8	CashAndCashEquivalentsAtCarryingValue	0	0	211,518,300	1,766,810,650	3,873,600,000	0000357294	0001361538	0000882184
9	remainder_Assets	-9,185,019,000	-280,494,900	365,804,917	6,456,156,200	39,234,303,000	0000052988	0001373670	0000920760
10	remainder_Expenses	259,421	18,372,128	2,173,816,254	15,472,104,300	30,878,300,000	0001374881	0001580670	0000882184
11	remainder_Revenues	0	14,990	3,577,100,998	16,308,788,600	35,460,400,000	0000833079	0000700923	0000882184
12	remainder_NetIncome	-536,000,000	-154,540,000	0	110,548,900	213,100,000	0001357615	0000906163	0000882184
13	remainder_ComprehensiveNetIncome	-207,000,000	-33,908,150	0	20,587,950	97,000,000	0001796209	0000357294	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	127,766	16,870,480	1,528,859,672	9,025,662,500	12,532,337,000	0001785493	0001580670	0000920760
1	Assets	1,395	22,439,466	3,357,154,770	16,214,698,750	39,234,303,000	0001374881	0001580670	0000920760
2	Expenses	259,421	18,372,128	2,173,816,254	15,472,104,300	30,878,300,000	0001374881	0001580670	0000882184
3	Revenues	0	14,990	3,577,100,998	16,308,788,600	35,460,400,000	0000833079	0000700923	0000882184
4	StockholdersEquity	-801,494	2,226,193	1,319,331,519	11,072,854,350	26,701,966,000	0001374881	0001373670	0000920760
5	NetIncome	-1,355,106,000	-240,989,550	138,828,984	4,753,584,900	13,944,465,000	0000920760	0001124198	0000822416
6	ComprehensiveNetIncome	-1,365,260,500	-259,437,650	132,907,854	4,753,588,725	13,944,465,000	0000920760	0000874238	0000822416
7	BaseVar	644,782	51,991,826	7,221,410,954	36,353,646,069	79,246,275,000	0001374881	0000700923	0000882184
8	EconomicCapitalRatio	-3.36	0.243	0.862	3.29	4.77	0001374881	0001825088	0000906163

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	LiabilitiesCurrent	-1.61	-0.586	0.0734	0.568	1.51	0001682265	0001785493	0001374881
1	LiabilitiesNonCurrent	-0.833	-0.675	0.129	0.391	0.597	0001703956	0001035983	0001682265
2	NotesAndLoansPayable	-1.14	-0.457	0.108	0.232	0.329	0001561680	0000015615	0001682265
3	remainder_Liabilities	-1.34	-0.930	0.273	0.662	0.880	0000773141	0000077543	0001682265
4	AssetsCurrent	-0.499	-0.318	0.0678	0.763	3.89	0001374881	0000773141	0001785493
5	AssetsNonCurrent	-0.0575	-0.0519	-0.0196	0.0839	0.752	0001357971	0000799292	0000052988
6	Inventory	-0.701	-0.418	-0.261	0.787	1.44	0000822416	0000874238	0000833079
7	Goodwill	-0.199	-0.153	-0.0283	0.449	0.636	0001374881	0000920760	0001796209
8	CashAndCashEquivalentsAtCarryingValue	-0.249	-0.200	-0.0515	0.185	4.31	0001374881	0000052988	0001785493
9	remainder_Assets	-3.55	-0.650	-0.162	1.17	2.88	0000906163	0001633931	0000920760
10	remainder_Expenses	-1.55	-1.33	-0.209	1.12	1.61	0001124198	0001785493	0000906163
11	remainder_Revenues	-1.14	-0.834	0.151	0.987	2.29	0001374881	0001718227	0001682265
12	remainder_NetIncome	-0.187	-0.0343	0.00363	0.0538	0.0803	0001357615	0001580670	0001374881
13	remainder_ComprehensiveNetIncome	-0.0284	-0.00716	0.00101	0.00713	0.0188	0001796209	0000357294	0001124198

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-0.543	-0.428	0.198	0.988	4.39	0001784567	0001361538	0001374881
1	Assets	-1.51	-0.663	-0.210	1.22	1.49	0001374881	0001561680	0001785493
2	Expenses	-1.55	-1.33	-0.209	1.12	1.61	0001124198	0001785493	0000906163
3	Revenues	-1.14	-0.834	0.151	0.987	2.29	0001374881	0001718227	0001682265
4	StockholdersEquity	-2.71	-0.896	-0.255	0.933	1.45	0001374881	0001796209	0001785493
5	NetIncome	-1.23	-0.923	-0.278	1.93	3.30	0001374881	0001035983	0001682265
6	ComprehensiveNetIncome	-1.23	-0.920	-0.277	1.93	3.31	0001374881	0001035983	0001682265
7	BaseVar	nan	nan	nan	nan	nan	0000015615	0001048268	0000015615
8	EconomicCapitalRatio	-4.45	-0.842	-0.223	2.21	3.69	0001374881	0001825088	0000906163

Estimates

Parameter	Value	Min	Max
PresentValueFactor	1.75	1.0	15.0
BalanceFactor	1.16	0.5	5.0
OCIFactor	0.5	0.5	1.0
HiddenReservesFactor	0.0	0.0	0.0
LLPO_stddev	0.42	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
0000015615	Mastec INC	Mastec	MTZ	2011	17.1600	1.0000	17.1600	84,669,233.0	1,452,924,038.28	0.8669
				2012	24.4700	1.0000	24.4700	75,974,952.0	1,859,107,075.44	0.9404
				2013	31.4900	1.0000	31.4900	77,242,037.0	2,432,351,745.13	1.0096
				2017	49.3000	1.0000	49.3000	82,760,624.0	4,080,098,763.20	1.2180
				2018	39.3400	1.0000	39.3400	78,678,759.0	3,095,222,379.06	0.8267
				2019	64.2000	1.0000	64.2000	76,332,198.0	4,900,527,111.60	1.1949
				2020	68.4800	1.0000	68.4800	73,866,947.0	5,058,408,530.56	1.1972
				2021	91.5700	1.0000	91.5700	74,303,674.0	6,803,987,428.18	1.1632
				2022	85.1700	1.0000	85.1700	78,234,262.0	6,663,212,094.54	0.8410
				2023	73.2900	1.0000	73.2900	78,823,118.0	5,776,946,318.22	0.7210
0000039677	Av Homes Inc	Av Home	nan	2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	22,001,939.0	nan	nan
				2014	nan	nan	nan	22,096,612.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0000042316	Goldfield Corp	Goldfie	nan	2011	nan	nan	nan	25,451,354.0	nan	nan
				2012	nan	nan	nan	25,451,354.0	nan	nan
				2013	nan	nan	nan	25,451,354.0	nan	nan
				2014	nan	nan	nan	25,451,354.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
0000052988	Jacobs Engineering Group Inc	Jacobs	J	2010	45.8300	1.0000	45.8300	nan	nan	nan
				2011	40.4200	1.0000	40.4200	128,134,615.0	5,179,201,138.30	1.2776
				2012	42.5900	1.0000	42.5900	130,076,572.0	5,539,961,201.48	1.2904
				2013	61.3400	1.0000	61.3400	131,713,475.0	8,079,304,556.50	1.7636
				2014	44.4900	1.0000	44.4900	130,552,640.0	5,808,286,953.60	1.0753
				2015	42.2000	1.0000	42.2000	122,557,955.0	5,171,945,701.00	1.0591
				2016	58.4000	1.0000	58.4000	120,750,218.0	7,051,812,731.20	1.5427
				2017	66.3300	1.0000	66.3300	120,466,122.0	7,990,517,872.26	1.7172
				2018	57.6400	1.0000	57.6400	142,263,898.0	8,200,091,080.72	1.0385
				2020	106.9200	1.0000	106.9200	129,623,428.0	13,859,336,921.76	1.8122
				2021	137.8000	1.0000	137.8000	128,948,685.0	17,769,128,793.00	1.9918
				2022	119.9700	1.0000	119.9700	126,332,274.0	15,156,082,911.78	1.6924
				2023	128.1200	1.0000	128.1200	126,024,433.0	16,146,250,355.96	1.7902
0000054441	Furmanite Corp	Furmani	nan	2011	nan	nan	nan	37,092,575.0	nan	nan
				2012	nan	nan	nan	37,202,575.0	nan	nan
				2013	nan	nan	nan	37,490,166.0	nan	nan
				2014	nan	nan	nan	37,675,010.0	nan	nan
0000067215	Dycom Industries INC	Dycom I	DY	2012	19.6200	1.0000	19.6200	32,597,712.0	639,567,109.44	1.1106
				2013	27.3800	1.0000	27.3800	33,755,060.0	924,213,542.80	0.9830
				2014	33.4800	1.0000	33.4800	34,058,785.0	1,140,288,121.80	1.1755
				2015	73.0100	1.0000	73.0100	32,480,713.0	2,371,416,856.13	2.1456
				2016	81.1300	1.0000	81.1300	31,465,914.0	2,552,829,602.82	1.7715
				2017	112.6300	1.0000	112.6300	30,938,786.0	3,484,635,467.18	2.2287
				2019	47.2200	1.0000	47.2200	31,523,782.0	1,488,552,986.04	0.8781
				2020	73.8600	1.0000	73.8600	31,913,183.0	2,357,107,696.38	1.3218
				2021	92.0900	1.0000	92.0900	30,180,688.0	2,779,339,557.92	1.8065
				2022	91.9900	1.0000	91.9900	29,556,659.0	2,718,917,061.41	1.5635
				2023	114.3800	1.0000	114.3800	29,338,337.0	3,355,718,986.06	1.7861
0000077543	Tutor Perini Corp	Tutor P	TPC	2011	12.6600	1.0000	12.6600	47,329,275.0	599,188,621.50	0.2393
				2012	13.7500	1.0000	13.7500	47,556,056.0	653,895,770.00	0.2888
				2015	16.9200	1.0000	16.9200	49,072,710.0	830,310,253.20	0.2492
				2016	28.4500	1.0000	28.4500	49,202,055.0	1,399,798,464.75	0.4291
				2017	26.0200	1.0000	26.0200	49,781,010.0	1,295,301,880.20	0.3797
				2018	15.9000	1.0000	15.9000	50,025,996.0	795,413,336.40	0.2277
				2019	13.1200	1.0000	13.1200	50,278,816.0	659,658,065.92	0.1749
				2020	13.3800	1.0000	13.3800	50,827,205.0	680,068,002.90	0.1591
				2021	12.4000	1.0000	12.4000	51,072,432.0	633,298,156.80	0.1629
				2022	7.6100	1.0000	7.6100	51,485,216.0	391,802,493.76	0.1025
				2023	8.8300	1.0000	8.8300	52,022,169.0	459,355,752.27	0.1213
0000080035	Preformed Line Products Co	Preform	PLPC	2011	59.6100	1.0000	59.6100	5,248,396.0	312,856,885.56	1.6079
				2012	61.2500	1.0000	61.2500	5,312,589.0	325,396,076.25	1.6631
				2013	73.2100	1.0000	73.2100	5,358,655.0	392,307,132.55	2.0398
				2014	52.2400	1.0000	52.2400	5,354,460.0	279,716,990.40	1.3668
				2015	42.1600	1.0000	42.1600	5,272,030.0	222,268,784.80	1.1810
				2016	58.6800	1.0000	58.6800	5,120,394.0	300,464,719.92	1.5160
				2017	74.4200	1.0000	74.4200	5,091,381.0	378,900,574.02	1.7932
				2018	53.3400	1.0000	53.3400	5,012,109.0	267,345,894.06	1.2486
				2019	60.5500	1.0000	60.5500	5,008,398.0	303,258,498.90	1.1784
				2020	65.7700	1.0000	65.7700	4,914,543.0	323,229,493.11	1.1445
				2021	61.4000	1.0000	61.4000	4,899,945.0	300,856,623.00	1.0120
				2022	83.5900	1.0000	83.5900	4,919,841.0	411,249,509.19	1.2027
0000085974	Ryland Group INC	Ryland	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	44,413,594.0	nan	nan
				2012	nan	nan	nan	44,434,070.0	nan	nan
0000100591	Argan INC	Argan I	AGX	2011	16.5700	1.0000	16.5700	13,635,728.0	225,944,012.96	2.7640
				2012	17.9700	1.0000	17.9700	13,937,365.0	250,454,449.05	1.6187
				2013	26.9100	1.0000	26.9100	14,197,051.0	382,042,642.41	2.1814
				2014	33.7200	1.0000	33.7200	14,531,201.0	489,992,097.72	2.0044
				2015	32.4900	1.0000	32.4900	14,826,469.0	481,711,977.81	1.5858
				2016	72.3300	1.0000	72.3300	15,306,069.0	1,107,087,970.77	3.7041
				2017	45.4500	1.0000	45.4500	15,548,719.0	706,689,278.55	1.4185
				2018	37.8400	1.0000	37.8400	15,570,719.0	589,196,006.96	1.6206
				2019	40.3000	1.0000	40.3000	15,633,302.0	630,022,070.60	2.2541
				2020	44.5800	1.0000	44.5800	15,689,969.0	699,458,818.02	2.2063
				2021	38.2300	1.0000	38.2300	15,714,745.0	600,774,701.35	1.3610
				2022	36.2400	1.0000	36.2400	13,576,285.0	492,004,568.40	1.2590
				2023	47.0900	1.0000	47.0900	13,327,866.0	627,609,209.94	1.7981
0000105634	Emcor Group Inc	Emcor G	EME	2010	29.5700	1.0000	29.5700	nan	nan	nan
				2011	26.5100	1.0000	26.5100	66,711,018.0	1,768,509,087.18	0.7395
				2012	34.4200	1.0000	34.4200	66,539,947.0	2,290,304,975.74	0.9432
				2013	41.5600	1.0000	41.5600	67,131,672.0	2,789,992,288.32	1.0234
				2014	44.5200	1.0000	44.5200	64,747,535.0	2,882,560,258.20	1.0779
				2015	48.0100	1.0000	48.0100	62,723,966.0	3,011,377,607.66	1.0729
				2016	71.7900	1.0000	71.7900	60,646,476.0	4,353,810,512.04	1.3932
				2017	82.5600	1.0000	82.5600	58,813,795.0	4,855,666,915.20	1.5520
				2018	59.9600	1.0000	59.9600	57,560,139.0	3,451,305,934.44	1.0725
				2019	87.5000	1.0000	87.5000	56,153,125.0	4,913,398,437.50	1.2925
				2020	91.2400	1.0000	91.2400	54,930,617.0	5,011,869,495.08	1.2415
				2021	126.4700	1.0000	126.4700	53,374,384.0	6,750,258,344.48	1.5644
				2022	148.6200	1.0000	148.6200	47,655,251.0	7,082,523,403.62	1.5610
				2023	216.2100	1.0000	216.2100	47,044,440.0	10,171,478,372.40	1.8926
0000353020	Aegion Corp	Aegion	nan	2013	nan	nan	nan	38,374,118.0	nan	nan
				2014	nan	nan	nan	37,381,538.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	30,772,852.0	nan	nan
0000357294	Hovnanian Enterprises INC	Hovnani	HOV	2021	127.1100	1.0000	127.1100	5,595,734.0	711,273,748.74	0.3186
				2022	45.8300	1.0000	45.8300	5,258,507.0	240,997,375.81	0.1017
				2023	154.2100	1.0000	154.2100	5,345,992.0	824,405,426.32	0.3744
0000700923	MYR Group INC	MYR Gro	MYRG	2011	19.1400	1.0000	19.1400	20,401,734.0	390,489,188.76	1.2816
				2012	21.5600	1.0000	21.5600	20,669,372.0	445,631,660.32	1.3142
				2013	25.1900	1.0000	25.1900	21,159,233.0	533,001,079.27	1.4127
				2014	27.4100	1.0000	27.4100	20,779,219.0	569,558,392.79	1.5876
				2015	20.6200	1.0000	20.6200	20,616,702.0	425,116,395.24	1.1812
				2016	38.3900	1.0000	38.3900	16,064,682.0	616,723,141.98	1.3956
				2017	35.7400	1.0000	35.7400	16,462,023.0	588,352,702.02	1.2781
				2018	27.6100	1.0000	27.6100	16,564,744.0	457,352,581.84	0.7796
				2019	32.9700	1.0000	32.9700	16,647,724.0	548,875,460.28	0.6648
				2020	59.8600	1.0000	59.8600	16,727,116.0	1,001,285,163.76	1.2817
				2021	107.2200	1.0000	107.2200	16,869,947.0	1,808,795,717.34	2.0996
				2022	89.6300	1.0000	89.6300	16,600,754.0	1,487,925,581.02	1.3300
				2023	145.6700	1.0000	145.6700	16,709,534.0	2,434,077,817.78	1.9424
0000773141	M D C Holdings INC	M D C H	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	47,957,196.0	nan	nan
				2012	nan	nan	nan	48,698,757.0	nan	nan
				2016	nan	nan	nan	51,485,090.0	nan	nan
				2017	nan	nan	nan	56,123,228.0	nan	nan
				2020	nan	nan	nan	64,851,126.0	nan	nan
				2021	nan	nan	nan	70,668,093.0	nan	nan
				2022	nan	nan	nan	72,585,596.0	nan	nan
				2023	nan	nan	nan	74,661,479.0	nan	nan
0000794170	Toll Brothers Inc	Toll Br	TOL	2010	19.2000	1.0000	19.2000	nan	nan	nan
				2011	20.2700	1.0000	20.2700	166,366,000.0	3,372,238,820.00	0.8973
				2020	45.3900	1.0000	45.3900	124,838,000.0	5,666,396,820.00	0.6587
				2021	71.1700	1.0000	71.1700	120,360,000.0	8,566,021,200.00	0.9661
				2022	50.4800	1.0000	50.4800	110,727,000.0	5,589,498,960.00	0.6025
				2023	103.3500	1.0000	103.3500	104,110,000.0	10,759,768,500.00	1.1797
0000799292	M I Homes INC	M I Hom	MHO	2011	10.0000	1.0000	10.0000	18,736,357.0	187,363,570.00	0.3550
				2012	25.4500	1.0000	25.4500	21,437,727.0	545,590,152.15	0.8222
				2013	24.8600	1.0000	24.8600	24,357,943.0	605,538,462.98	0.7010
				2014	22.3100	1.0000	22.3100	24,474,139.0	546,018,041.09	0.5812
				2015	21.9100	1.0000	21.9100	24,648,864.0	540,056,610.24	0.4834
				2016	25.8900	1.0000	25.8900	24,668,833.0	638,676,086.37	0.5228
				2017	34.2500	1.0000	34.2500	27,520,632.0	942,581,646.00	0.6320
				2018	21.6700	1.0000	21.6700	27,923,936.0	605,111,693.12	0.3796
				2019	40.2200	1.0000	40.2200	28,142,916.0	1,131,908,081.52	0.7057
				2020	46.8500	1.0000	46.8500	28,745,649.0	1,346,733,655.65	0.6688
				2021	60.9800	1.0000	60.9800	29,099,630.0	1,774,495,437.40	0.7309
				2022	46.3600	1.0000	46.3600	27,428,983.0	1,271,607,651.88	0.4746
				2023	132.5000	1.0000	132.5000	27,848,522.0	3,689,929,165.00	1.3351
0000814046	ALP Liquidating Trust	ALP Liq	nan	2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0000822416	Pultegroup INC Mi	Pultegr	PHM	2010	7.3800	1.0000	7.3800	nan	nan	nan
				2011	6.1200	1.0000	6.1200	382,780,762.0	2,342,618,263.44	0.3963
				2012	18.1500	1.0000	18.1500	386,317,678.0	7,011,665,855.70	1.2436
				2020	44.6100	1.0000	44.6100	268,093,742.0	11,959,661,830.62	1.3407
				2021	55.0200	1.0000	55.0200	253,185,667.0	13,930,275,398.34	1.4497
				2022	45.7700	1.0000	45.7700	227,819,724.0	10,427,308,767.48	1.0086
				2023	102.7200	1.0000	102.7200	215,594,980.0	22,145,916,345.60	2.0325
0000833079	Meritage Homes Corp	Meritag	MTH	2011	22.7400	1.0000	22.7400	32,433,571.0	737,539,404.54	0.7551
				2012	37.1500	1.0000	37.1500	35,590,401.0	1,322,183,397.15	1.0764
				2013	46.3200	1.0000	46.3200	36,241,671.0	1,678,714,200.72	1.0606
				2014	35.1100	1.0000	35.1100	39,125,006.0	1,373,678,960.66	0.7800
				2015	34.4500	1.0000	34.4500	39,665,797.0	1,366,486,706.65	0.6630
				2016	36.1000	1.0000	36.1000	40,024,984.0	1,444,901,922.40	0.6634
				2017	50.7700	1.0000	50.7700	40,326,062.0	2,047,354,167.74	0.8314
				2018	36.6200	1.0000	36.6200	39,966,166.0	1,463,560,998.92	0.5843
				2019	61.8700	1.0000	61.8700	38,299,111.0	2,369,565,997.57	0.9827
				2020	86.0800	1.0000	86.0800	37,612,127.0	3,237,651,892.16	1.2033
				2021	117.9100	1.0000	117.9100	37,311,125.0	4,399,354,748.75	1.3391
				2022	92.1300	1.0000	92.1300	36,571,393.0	3,369,322,437.09	0.8873
				2023	174.3000	1.0000	174.3000	36,449,906.0	6,353,218,615.80	1.5698
0000861459	Granite Construction INC	Granite	GVA	2010	27.7800	1.0000	27.7800	nan	nan	nan
				2015	43.0600	1.0000	43.0600	39,382,715.0	1,695,819,707.90	1.6198
				2016	56.7600	1.0000	56.7600	39,603,632.0	2,247,902,152.32	1.9865
				2017	64.1000	1.0000	64.1000	39,850,783.0	2,554,435,190.30	2.0214
				2018	40.1400	1.0000	40.1400	46,897,218.0	1,882,454,330.52	1.1934
				2020	26.8700	1.0000	26.8700	nan	nan	nan
				2021	38.3400	1.0000	38.3400	45,826,735.0	1,756,997,019.90	0.9858
				2022	35.2300	1.0000	35.2300	43,730,055.0	1,540,609,837.65	1.0390
				2023	50.9600	1.0000	50.9600	43,933,314.0	2,238,841,681.44	1.1650
0000866273	Matrix Service Co	Matrix	MTRX	2011	9.4400	1.0000	9.4400	25,877,241.0	244,281,155.04	1.2022
				2012	11.4100	1.0000	11.4100	25,910,013.0	295,633,248.33	1.3785
				2013	23.9400	1.0000	23.9400	26,193,467.0	627,071,599.98	2.1556
				2014	21.7700	1.0000	21.7700	26,533,988.0	577,644,918.76	1.3506
				2015	20.6600	1.0000	20.6600	26,538,320.0	548,281,691.20	1.3073
				2016	22.5700	1.0000	22.5700	26,533,332.0	598,857,303.24	1.4711
				2017	17.8200	1.0000	17.8200	26,748,394.0	476,656,381.08	1.1215
				2018	16.9400	1.0000	16.9400	27,071,755.0	458,595,529.70	1.1501
				2021	7.0500	1.0000	7.0500	26,765,025.0	188,693,426.25	0.5810
				2022	6.3000	1.0000	6.3000	27,027,323.0	170,272,134.90	0.5204
0000874238	Sterling Infrastructure Inc	Sterlin	STRL	2011	10.9700	1.0000	10.9700	16,321,112.0	179,042,598.64	0.9528
				2012	9.6400	1.0000	9.6400	16,495,216.0	159,013,882.24	0.7784
				2013	11.7600	1.0000	11.7600	16,662,824.0	195,954,810.24	0.9488
				2014	6.4100	1.0000	6.4100	18,802,779.0	120,525,813.39	0.5110
				2015	6.2900	1.0000	6.2900	19,588,170.0	123,209,589.30	0.5616
				2016	8.5400	1.0000	8.5400	25,002,964.0	213,525,312.56	0.8618
				2017	16.8300	1.0000	16.8300	27,051,143.0	455,270,736.69	1.1668
				2018	10.2400	1.0000	10.2400	27,068,353.0	277,179,934.72	0.6995
				2019	14.6400	1.0000	14.6400	27,719,238.0	405,809,644.32	0.4767
				2020	19.1400	1.0000	19.1400	28,101,317.0	537,859,207.38	0.6574
				2021	26.1100	1.0000	26.1100	28,794,510.0	751,824,656.10	0.7154
				2022	32.2000	1.0000	32.2000	30,329,659.0	976,615,019.80	0.8120
				2023	84.9600	1.0000	84.9600	30,838,207.0	2,620,014,066.72	1.7880
0000882184	Horton D R INC De	Horton	DHI	2018	34.6200	1.0000	34.6200	376,274,635.0	13,026,627,863.70	1.3664
				2019	52.8500	1.0000	52.8500	368,493,204.0	19,474,865,831.40	1.8622
				2020	71.3000	1.0000	71.3000	364,390,995.0	25,981,077,943.50	2.0216
				2021	105.9000	1.0000	105.9000	356,529,507.0	37,756,474,791.30	2.3010
				2022	89.2200	1.0000	89.2200	344,341,227.0	30,722,124,272.94	1.5018
				2023	150.2900	1.0000	150.2900	333,184,374.0	50,074,279,568.46	2.3829
0000888504	Layne Christensen Co	Layne C	nan	2011	nan	nan	nan	19,755,711.0	nan	nan
				2012	nan	nan	nan	19,845,876.0	nan	nan
				2013	nan	nan	nan	19,887,366.0	nan	nan
				2014	nan	nan	nan	19,739,583.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0000894501	Gold Rock Holdings INC	Gold Ro	GRHI	2021	nan	nan	nan	87,360,547.0	nan	nan
0000906163	NVR INC	NVR INC	NVR	2010	690.0500	1.0000	690.0500	nan	nan	nan
				2011	673.6300	1.0000	673.6300	4,976,408.0	3,352,257,721.04	3.0696
				2012	940.7300	1.0000	940.7300	4,889,104.0	4,599,326,805.92	2.4667
				2013	1022.5800	1.0000	1022.5800	4,548,037.0	4,650,731,675.46	2.5065
				2014	1239.5200	1.0000	1239.5200	4,096,322.0	5,077,473,045.44	2.8378
				2015	1651.9900	1.0000	1651.9900	3,912,711.0	6,463,759,444.89	3.4100
				2016	1667.2500	1.0000	1667.2500	3,790,395.0	6,319,536,063.75	3.1729
				2017	3466.5000	1.0000	3466.5000	3,739,858.0	12,964,217,757.00	5.9291
				2018	2438.9900	1.0000	2438.9900	3,614,947.0	8,816,819,583.53	3.8984
				2019	3813.4600	1.0000	3813.4600	3,694,905.0	14,090,372,421.30	5.3389
				2020	4179.4500	1.0000	4179.4500	3,720,432.0	15,549,359,522.40	3.6798
				2021	5816.7200	1.0000	5816.7200	3,482,747.0	20,258,164,129.84	4.6750
				2022	4650.9600	1.0000	4650.9600	3,195,887.0	14,863,942,601.52	3.8039
				2023	6960.0700	1.0000	6960.0700	3,179,030.0	22,126,271,332.10	5.0066
0000915840	Beazer Homes USA INC	Beazer	BZH	2011	12.2000	0.2000	2.4400	75,548,949.0	184,339,435.56	0.0981
				2013	23.6000	1.0000	23.6000	25,245,034.0	595,782,802.40	0.3191
				2016	13.7300	1.0000	13.7300	33,071,331.0	454,069,374.63	0.2399
				2017	19.0700	1.0000	19.0700	33,512,585.0	639,084,995.95	0.3401
				2020	15.9500	1.0000	15.9500	31,012,826.0	494,654,574.70	0.2892
				2021	22.9800	1.0000	22.9800	31,294,498.0	719,147,564.04	0.4191
				2022	13.0300	1.0000	13.0300	30,880,138.0	402,368,198.14	0.2258
				2023	33.4400	1.0000	33.4400	31,322,989.0	1,047,440,752.16	0.5633
0000920760	Lennar Corp NEW	Lennar	LEN	2010	18.2100	1.0170	18.5200	nan	nan	nan
				2011	19.1500	1.0170	19.4800	157,422,897.0	3,066,598,033.56	0.4086
				2012	37.9200	1.0170	38.5600	160,676,634.0	6,195,691,007.04	0.7411
				2023	148.4200	1.0000	148.4200	247,163,402.0	36,683,992,124.84	1.4173
0001027884	Chicago Bridge Iron Co N V	Chicago	nan	2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	98,505,617.0	nan	nan
				2012	nan	nan	nan	97,743,730.0	nan	nan
				2013	nan	nan	nan	107,507,353.0	nan	nan
				2014	nan	nan	nan	108,291,910.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
0001035983	Comfort Systems USA INC	Comfort	FIX	2011	10.7400	1.0000	10.7400	37,455,699.0	402,274,207.26	0.8953
				2012	11.8100	1.0000	11.8100	37,279,210.0	440,267,470.10	1.0072
				2013	19.3200	1.0000	19.3200	37,355,508.0	721,708,414.56	1.6225
				2014	17.1200	1.0000	17.1200	37,255,464.0	637,813,543.68	1.2632
				2015	28.6800	1.0000	28.6800	37,449,352.0	1,074,047,415.36	2.1094
				2016	34.0200	1.0000	34.0200	37,209,358.0	1,265,862,359.16	2.4320
				2017	43.8800	1.0000	43.8800	37,134,226.0	1,629,449,836.88	2.4240
				2018	43.0800	1.0000	43.0800	37,149,822.0	1,600,414,331.76	1.9672
				2019	50.2100	1.0000	50.2100	36,675,927.0	1,841,498,294.67	1.5189
				2020	53.3800	1.0000	53.3800	36,394,751.0	1,942,751,808.38	1.3785
				2021	98.5900	1.0000	98.5900	36,041,288.0	3,553,310,583.92	1.9672
				2022	116.7900	1.0000	116.7900	35,760,816.0	4,176,505,700.64	1.9913
				2023	206.8100	1.0000	206.8100	35,714,815.0	7,386,180,890.15	2.7698
0001048268	IES Holdings Inc	IES Hol	IESC	2011	2.0000	1.0000	2.0000	14,938,071.0	29,876,142.00	0.2012
				2014	7.7100	1.0000	7.7100	21,754,913.0	167,730,379.23	1.0682
				2015	10.6300	1.0000	10.6300	21,468,742.0	228,212,727.46	1.2973
				2016	19.7000	1.0000	19.7000	21,456,523.0	422,693,503.10	1.5003
				2017	17.3200	1.0000	17.3200	21,337,245.0	369,561,083.40	1.2140
				2018	15.5100	1.0000	15.5100	21,205,536.0	328,897,863.36	1.0607
				2019	25.6400	1.0000	25.6400	21,158,207.0	542,496,427.48	1.6927
				2020	47.8100	1.0000	47.8100	20,745,974.0	991,865,016.94	2.3733
				2021	50.5500	1.0000	50.5500	20,702,565.0	1,046,514,660.75	1.8000
				2022	34.0300	1.0000	34.0300	20,224,557.0	688,241,674.71	0.9309
				2023	82.2600	1.0000	82.2600	20,194,218.0	1,661,176,372.68	2.2705
0001050915	Quanta Services INC	Quanta	PWR	2009	21.4000	1.0000	21.4000	nan	nan	nan
				2010	19.7900	1.0000	19.7900	nan	nan	nan
				2011	21.4900	1.0000	21.4900	206,224,437.0	4,431,763,151.13	1.4747
				2012	27.2300	1.0000	27.2300	nan	nan	nan
				2013	31.0800	1.0000	31.0800	nan	nan	nan
				2014	28.0700	1.0000	28.0700	212,463,762.0	5,963,857,799.34	1.4731
				2015	20.3900	1.0000	20.3900	152,882,049.0	3,117,264,979.11	0.8493
				2016	34.9400	1.0000	34.9400	144,676,041.0	5,054,980,872.54	1.3726
				2017	39.2200	1.0000	39.2200	nan	nan	nan
				2018	29.2800	1.0000	29.2800	nan	nan	nan
				2019	40.9500	1.0000	40.9500	nan	nan	nan
				2020	70.6700	1.0000	70.6700	138,860,900.0	9,813,299,803.00	1.5766
				2021	112.3500	1.0000	112.3500	142,499,280.0	16,009,794,108.00	1.5549
				2022	142.6800	1.0000	142.6800	142,901,156.0	20,389,136,938.08	1.8940
				2023	215.0100	1.0000	215.0100	145,284,890.0	31,237,704,198.90	2.3854
0001065860	Lime Energy Co	Lime En	nan	2011	nan	nan	nan	23,842,616.0	nan	nan
				2012	nan	nan	nan	23,975,651.0	nan	nan
				2013	nan	nan	nan	3,593,422.0	nan	nan
				2014	nan	nan	nan	3,771,002.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001082198	Pernix Group Inc	Pernix	nan	2011	nan	nan	nan	9,403,697.0	nan	nan
0001082198	Pernix Group Inc	Pernix	nan	2012	nan	nan	nan	9,403,697.0	nan	nan
0001095996	William Lyon Homes	William	nan	2018	nan	nan	nan	nan	nan	nan
0001124198	Fluor Corp	Fluor C	FLR	2009	44.9700	1.0000	44.9700	nan	nan	nan
				2010	66.0200	1.0000	66.0200	nan	nan	nan
				2011	49.9700	1.0000	49.9700	169,664,281.0	8,478,124,121.57	1.4000
				2012	58.6400	1.0000	58.6400	166,509,480.0	9,764,115,907.20	1.6054
				2013	79.3200	1.0000	79.3200	163,352,559.0	12,957,124,979.88	2.2090
				2014	60.4100	1.0000	60.4100	156,220,578.0	9,437,285,116.98	1.6378
				2015	47.5000	1.0000	47.5000	141,612,486.0	6,726,593,085.00	1.2730
				2016	53.7200	1.0000	53.7200	139,250,204.0	7,480,520,958.88	1.1479
				2018	32.0500	1.0000	32.0500	140,668,441.0	4,508,423,534.05	0.7232
				2019	18.4100	1.0000	18.4100	140,174,400.0	2,580,610,704.00	0.4339
				2020	16.3200	1.0000	16.3200	140,715,205.0	2,296,472,145.60	0.4221
				2021	24.5900	1.0000	24.5900	141,411,916.0	3,477,319,014.44	0.6217
				2022	34.7700	1.0000	34.7700	142,088,313.0	4,940,410,643.01	0.9839
				2023	39.4400	1.0000	39.4400	170,375,090.0	6,719,593,549.60	1.3259
0001130385	Foster Wheeler Ag	Foster	nan	2009	nan	nan	nan	nan	nan	nan
				2010	nan	nan	nan	nan	nan	nan
				2011	nan	nan	nan	116,924,823.0	nan	nan
				2012	nan	nan	nan	107,749,674.0	nan	nan
				2013	nan	nan	nan	98,393,359.0	nan	nan
0001136294	Nos4 1 Inc	Nos4 1	WLMSQ	2012	17.0300	1.0000	17.0300	16,995,322.0	289,430,333.66	1.3794
				2013	19.3200	1.0000	19.3200	17,027,335.0	328,968,112.20	1.4454
				2014	13.9100	1.0000	13.9100	17,123,608.0	238,189,387.28	0.9380
				2016	4.6100	1.0000	4.6100	nan	nan	nan
				2017	3.5500	1.0000	3.5500	17,926,019.0	63,637,367.45	0.5546
				2018	2.2700	1.0000	2.2700	18,514,945.0	42,028,925.15	0.5361
				2019	1.6100	1.0000	1.6100	19,057,195.0	30,682,083.95	0.3029
				2020	2.4700	1.0000	2.4700	25,336,442.0	62,581,011.74	0.7007
				2021	3.0300	1.0000	3.0300	25,915,502.0	78,523,971.06	0.8019
				2022	0.9200	1.0000	0.9200	26,422,761.0	24,308,940.12	0.2532
0001172069	P2 Solar Inc	P2 Sola	PTOS	2012	0.0100	1.0000	0.0100	nan	nan	nan
0001172069	P2 Solar Inc	P2 Sola	PTOS	2022	0.0100	1.0000	0.0100	nan	nan	nan
0001300938	Abco Energy Inc	Abco En	ABCE	2014	20401.2200	1.0000	20401.2200	22,448,527.0	457,977,338,002.94	1109687.4464
				2015	2210.1300	1.0000	2210.1300	29,073,565.0	64,256,358,213.45	123030.7391
				2016	40.8000	1.0000	40.8000	217,866,385.0	8,888,948,508.00	11071.0762
				2017	9.8400	1.0000	9.8400	141,134,900.0	1,388,767,416.00	2048.6281
				2018	1.4500	1.0000	1.4500	499,854,239.0	724,788,646.55	871.5694
				2019	0.2600	1.0000	0.2600	63,392,630.0	16,482,083.80	11.2304
				2020	0.0600	1.0000	0.0600	2,687,999,095.0	161,279,945.70	99.5645
				2021	0.0100	1.0000	0.0100	70,462,489.0	704,624.89	0.3317
				2022	0.0000	1.0000	0.0000	260,515,166.0	0.00	0.2132
0001303330	China Housing Land Development Inc	China H	nan	2013	nan	nan	nan	35,849,204.0	nan	nan
0001303330	China Housing Land Development Inc	China H	nan	2014	nan	nan	nan	34,800,558.0	nan	nan
0001317577	Pike Corp	Pike Co	nan	2011	nan	nan	nan	34,738,456.0	nan	nan
				2012	nan	nan	nan	nan	nan	nan
				2013	nan	nan	nan	31,797,605.0	nan	nan
0001357615	KBR INC.	KBR INC	KBR	2009	19.1900	1.0000	19.1900	nan	nan	nan
				2010	29.7700	1.0000	29.7700	nan	nan	nan
				2011	27.4400	1.0000	27.4400	148,855,919.0	4,084,606,417.36	0.9175
				2012	29.7900	1.0000	29.7900	147,553,868.0	4,395,629,727.72	0.9743
				2013	30.4400	1.0000	30.4400	148,129,997.0	4,509,077,108.68	1.0689
				2014	16.9800	1.0000	16.9800	145,078,983.0	2,463,441,131.34	0.6600
				2015	17.0700	1.0000	17.0700	144,262,730.0	2,462,564,801.10	0.8533
				2016	17.2300	1.0000	17.2300	142,668,161.0	2,458,172,414.03	0.6520
				2017	19.5300	1.0000	19.5300	140,079,609.0	2,735,754,763.77	0.8930
				2018	15.0300	1.0000	15.0300	140,877,868.0	2,117,394,356.04	0.5036
				2019	30.5300	1.0000	30.5300	141,714,130.0	4,326,532,388.90	0.9756
				2020	29.6700	1.0000	29.6700	142,527,053.0	4,228,777,662.51	0.8629
				2021	46.8200	1.0000	46.8200	140,285,318.0	6,568,158,588.76	1.2280
				2022	52.1700	1.0000	52.1700	137,196,219.0	7,157,526,745.23	1.5070
				2023	54.3000	1.0000	54.3000	135,004,384.0	7,330,738,051.20	1.5059
0001357971	Energy Services Of America Corp	Energy	ESOA	2011	2.8800	1.0000	2.8800	14,446,836.0	41,606,887.68	0.4970
				2012	0.6000	1.0000	0.6000	14,458,836.0	8,675,301.60	0.1534
				2013	1.2800	1.0000	1.2800	14,514,836.0	18,578,990.08	0.4298
				2014	1.3800	1.0000	1.3800	14,239,836.0	19,650,973.68	0.5923
				2015	1.2400	1.0000	1.2400	14,239,836.0	17,657,396.64	0.4816
				2016	1.3600	1.0000	1.3600	14,239,836.0	19,366,176.96	0.4291
				2017	0.8900	1.0000	0.8900	14,239,836.0	12,673,454.04	0.2633
				2018	1.1900	1.0000	1.1900	14,086,849.0	16,763,350.31	0.3895
				2020	1.1400	1.0000	1.1400	13,621,406.0	15,528,402.84	0.3447
				2021	3.2500	1.0000	3.2500	16,247,898.0	52,805,668.50	0.9991
				2022	2.6900	1.0000	2.6900	16,667,185.0	44,834,727.65	0.4797
				2023	5.4000	1.0000	5.4000	16,567,185.0	89,462,799.00	0.7151
0001361538	Primoris Services Corp	Primori	PRIM	2011	15.0700	1.0000	15.0700	51,059,132.0	769,461,119.24	1.3016
				2012	14.8900	1.0000	14.8900	51,388,406.0	765,173,365.34	1.0004
				2013	30.4100	1.0000	30.4100	51,571,394.0	1,568,286,091.54	1.8422
				2014	23.0100	1.0000	23.0100	51,561,396.0	1,186,427,721.96	1.3414
				2015	22.1800	1.0000	22.1800	51,675,569.0	1,146,164,120.42	1.2871
				2016	23.9600	1.0000	23.9600	51,784,242.0	1,240,750,438.32	1.3467
				2017	27.8500	1.0000	27.8500	51,448,753.0	1,432,847,771.05	1.4699
				2018	19.0700	1.0000	19.0700	51,204,959.0	976,478,568.13	0.7566
				2019	22.4500	1.0000	22.4500	50,982,098.0	1,144,548,100.10	0.7551
				2020	27.6600	1.0000	27.6600	48,096,318.0	1,330,344,155.88	0.8252
				2021	24.0100	1.0000	24.0100	53,820,801.0	1,292,237,432.01	0.6308
				2022	21.6200	1.0000	21.6200	53,111,107.0	1,148,262,133.34	0.3842
				2023	33.1900	1.0000	33.1900	53,360,411.0	1,771,032,041.09	0.5518
0001372020	Great Lakes Dredge Dock Corp	Great L	GLDD	2011	5.5600	1.0000	5.5600	58,960,444.0	327,820,068.64	0.5105
				2012	8.9300	1.0000	8.9300	59,279,750.0	529,368,167.50	0.7671
				2013	9.1100	1.0000	9.1100	59,625,043.0	543,184,141.73	0.7421
				2014	8.3800	1.0000	8.3800	60,236,620.0	504,782,875.60	0.6596
				2015	4.0200	1.0000	4.0200	60,446,628.0	242,995,444.56	0.3129
				2016	4.5000	1.0000	4.5000	60,940,829.0	274,233,730.50	0.3563
				2017	5.4000	1.0000	5.4000	61,675,785.0	333,049,239.00	0.4615
				2018	6.5500	1.0000	6.5500	62,479,490.0	409,240,659.50	0.6576
				2019	11.4600	1.0000	11.4600	63,919,970.0	732,522,856.20	0.9670
				2020	12.5800	1.0000	12.5800	64,970,532.0	817,329,292.56	1.0416
				2021	15.6900	1.0000	15.6900	65,736,524.0	1,031,406,061.56	1.2922
				2022	5.9300	1.0000	5.9300	66,169,959.0	392,387,856.87	0.4923
0001373670	Green Brick Partners Inc	Green B	GRBK	2011	7.7700	0.0770	0.6000	104,292,060.0	62,575,236.00	0.2499
				2012	2.6900	1.5320	4.1200	5,443,292.0	22,426,363.04	0.1006
				2014	8.3800	1.0000	8.3800	5,456,625.0	45,726,517.50	0.1476
				2015	7.3700	1.0000	7.3700	48,813,889.0	359,758,361.93	1.2494
				2016	10.0800	1.0000	10.0800	48,937,084.0	493,285,806.72	1.4491
				2017	11.2800	1.0000	11.2800	50,584,501.0	570,593,171.28	1.4413
				2018	7.2300	1.0000	7.2300	50,719,884.0	366,704,761.32	0.6829
				2019	11.3400	1.0000	11.3400	50,488,010.0	572,534,033.40	0.9534
				2020	23.5400	1.0000	23.5400	50,661,919.0	1,192,581,573.26	1.8142
				2021	29.9900	1.0000	29.9900	50,759,972.0	1,522,291,560.28	1.5749
				2022	24.2500	1.0000	24.2500	46,037,649.0	1,116,412,988.25	1.0152
				2023	52.4900	1.0000	52.4900	45,378,364.0	2,381,910,326.36	1.9430
0001374881	Kingfish Holding Corp	Kingfis	nan	2022	nan	nan	nan	120,942,987.0	nan	nan
0001374881	Kingfish Holding Corp	Kingfis	nan	2023	nan	nan	nan	120,942,987.0	nan	nan
0001392363	China Advanced Construction Materials Group Inc	China A	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	17,839,464.0	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
0001402829	Orion Group Holdings Inc	Orion G	ORN	2012	7.3500	1.0000	7.3500	27,154,930.0	199,588,735.50	0.9744
				2013	12.0400	1.0000	12.0400	27,348,097.0	329,271,087.88	1.7123
				2014	10.7600	1.0000	10.7600	27,520,648.0	296,122,172.48	1.2658
				2015	4.6000	1.0000	4.6000	27,281,359.0	125,494,251.40	0.3565
				2016	9.9300	1.0000	9.9300	27,680,643.0	274,868,784.99	0.8220
				2017	7.7900	1.0000	7.7900	28,199,558.0	219,674,556.82	0.6911
				2018	4.2400	1.0000	4.2400	28,966,619.0	122,818,464.56	0.5074
				2019	5.0600	1.0000	5.0600	29,550,353.0	149,524,786.18	0.4584
				2020	4.9600	1.0000	4.9600	30,415,095.0	150,858,871.20	0.4515
				2021	3.7600	1.0000	3.7600	31,059,311.0	116,783,009.36	0.4205
				2022	2.3400	1.0000	2.3400	32,054,885.0	75,008,430.90	0.2515
				2023	4.8800	1.0000	4.8800	32,491,110.0	158,556,616.80	0.4452
0001408356	Solarcity Corp	Solarci	nan	2013	nan	nan	nan	83,129,286.0	nan	nan
				2014	nan	nan	nan	96,000,871.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2016	nan	nan	nan	nan	nan	nan
0001425565	Real Goods Solar Inc	Real Go	nan	2011	nan	nan	nan	15,801,403.0	nan	nan
				2012	nan	nan	nan	26,683,828.0	nan	nan
				2013	nan	nan	nan	30,435,214.0	nan	nan
				2014	nan	nan	nan	52,025,684.0	nan	nan
				2015	nan	nan	nan	12,294,407.0	nan	nan
				2016	nan	nan	nan	8,048,414.0	nan	nan
				2017	nan	nan	nan	8,151,845.0	nan	nan
				2018	nan	nan	nan	77,090,149.0	nan	nan
0001488139	Ameresco Inc	Ameresc	AMRC	2012	9.7200	1.0000	9.7200	27,081,880.0	263,235,873.60	0.4836
				2013	9.5300	1.0000	9.5300	27,827,717.0	265,198,143.01	0.7208
				2014	7.1200	1.0000	7.1200	28,349,792.0	201,850,519.04	0.5208
				2015	6.0100	1.0000	6.0100	28,517,892.0	171,392,530.92	0.3776
				2016	6.1000	1.0000	6.1000	27,849,019.0	169,879,015.90	0.3439
				2017	8.5500	1.0000	8.5500	27,503,502.0	235,154,942.10	0.3965
				2018	14.1500	1.0000	14.1500	27,976,565.0	395,868,394.75	0.5720
				2019	16.9100	1.0000	16.9100	29,033,114.0	490,949,957.74	0.5742
				2020	51.3300	1.0000	51.3300	29,866,075.0	1,533,025,629.75	1.4373
				2021	78.6300	1.0000	78.6300	33,559,460.0	2,638,780,339.80	1.9553
				2022	56.6100	1.0000	56.6100	33,914,193.0	1,919,882,465.73	1.0410
				2023	32.1700	1.0000	32.1700	34,234,525.0	1,101,324,669.25	0.4773
0001501162	Annec Green Refractories Corp	Annec G	nan	2011	nan	nan	nan	nan	nan	nan
				2012	nan	nan	nan	19,995,701.0	nan	nan
				2013	nan	nan	nan	nan	nan	nan
0001510832	Biopower Operations Corp	Biopowe	nan	2013	nan	nan	nan	90,280,000.0	nan	nan
				2014	nan	nan	nan	30,781,180.0	nan	nan
				2015	nan	nan	nan	42,107,680.0	nan	nan
				2021	nan	nan	nan	45,000,000.0	nan	nan
				2022	nan	nan	nan	45,625,000.0	nan	nan
0001534155	Ameri Metro Inc Formerly Yellowwood	Ameri M	nan	2019	nan	nan	nan	1,600,000.0	nan	nan
				2020	nan	nan	nan	1,684,000.0	nan	nan
				2021	nan	nan	nan	3,284,000.0	nan	nan
0001539551	Sports Field Holdings INC	Sports	nan	2014	nan	nan	nan	13,495,275.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
0001561257	Helpful Alliance Co	Helpful	nan	2017	nan	nan	nan	nan	nan	nan
0001561680	Tri Pointe Homes Inc	Tri Poi	TPH	2014	14.6100	1.0000	14.6100	161,338,746.0	2,357,159,079.06	1.0830
				2015	12.8000	1.0000	12.8000	161,813,750.0	2,071,216,000.00	0.9029
				2020	17.5200	1.0000	17.5200	126,825,194.0	2,221,977,398.88	0.7647
				2021	27.0900	1.0000	27.0900	111,138,337.0	3,010,737,549.33	0.9675
				2022	18.6500	1.0000	18.6500	100,913,958.0	1,882,045,316.70	0.5699
				2023	35.1500	1.0000	35.1500	97,052,155.0	3,411,383,248.25	1.0012
0001562476	Taylor Morrison Home Corp	Taylor	TMHC	2013	22.0200	1.0000	22.0200	32,857,800.0	723,528,756.00	0.2714
				2014	18.2000	1.0000	18.2000	33,059,687.0	601,686,303.40	0.1854
				2015	16.2400	1.0000	16.2400	33,158,855.0	538,499,805.20	0.1708
				2016	19.7500	1.0000	19.7500	30,415,653.0	600,709,146.75	0.1913
				2017	24.2700	1.0000	24.2700	72,364,924.0	1,756,296,705.48	0.5570
				2019	21.9100	1.0000	21.9100	105,840,502.0	2,318,965,398.82	0.5838
				2020	26.7000	1.0000	26.7000	129,943,094.0	3,469,480,609.80	0.5841
				2021	33.9800	1.0000	33.9800	122,890,811.0	4,175,829,757.78	0.6193
				2022	30.6800	1.0000	30.6800	108,346,617.0	3,324,074,209.56	0.5406
0001566265	Axiom Corp	Axiom C	nan	2014	nan	nan	nan	nan	nan	nan
0001566265	Axiom Corp	Axiom C	nan	2015	nan	nan	nan	nan	nan	nan
0001571274	Continental Cement Company L L C	Contine	nan	2013	nan	nan	nan	nan	nan	nan
0001571274	Continental Cement Company L L C	Contine	nan	2014	nan	nan	nan	nan	nan	nan
0001572684	UCP Inc.	UCP Inc	nan	2013	nan	nan	nan	7,750,000.0	nan	nan
				2014	nan	nan	nan	7,922,216.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
0001574596	New Home Co Inc	New Hom	nan	2014	nan	nan	nan	16,448,750.0	nan	nan
				2015	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	18,231,954.0	nan	nan
0001576940	Century Communities Inc	Century	CCS	2014	16.7300	1.0000	16.7300	21,483,528.0	359,419,423.44	0.7283
				2015	17.6700	1.0000	17.6700	21,304,139.0	376,444,136.13	0.5280
				2016	21.0000	1.0000	21.0000	21,042,312.0	441,888,552.00	0.5734
				2017	30.1800	1.0000	30.1800	27,573,183.0	832,158,662.94	0.6085
				2018	17.3100	1.0000	17.3100	30,758,852.0	532,435,728.12	0.2917
				2019	27.3900	1.0000	27.3900	31,347,379.0	858,604,710.81	0.4360
				2020	46.6100	1.0000	46.6100	33,350,633.0	1,554,473,004.13	0.7051
				2021	80.4900	1.0000	80.4900	33,760,940.0	2,717,418,060.60	1.0393
				2022	51.1800	1.0000	51.1800	31,772,335.0	1,626,108,105.30	0.6026
				2023	88.6700	1.0000	88.6700	31,774,615.0	2,817,455,112.05	0.9563
0001580670	LGI Homes Inc	LGI Hom	LGIH	2016	28.9500	1.0000	28.9500	21,282,514.0	616,128,780.30	0.9675
				2017	74.0300	1.0000	74.0300	21,737,859.0	1,609,253,701.77	1.9273
				2018	43.8200	1.0000	43.8200	22,717,096.0	995,463,146.72	0.9325
				2019	70.6400	1.0000	70.6400	22,949,956.0	1,621,184,891.84	1.3036
				2020	111.5500	1.0000	111.5500	25,100,426.0	2,799,952,520.30	2.2282
				2021	151.2700	1.0000	151.2700	24,273,191.0	3,671,805,602.57	2.2200
				2022	95.1000	1.0000	95.1000	23,290,286.0	2,214,906,198.60	0.9615
				2023	132.4500	1.0000	132.4500	23,563,868.0	3,121,034,316.60	1.2586
0001580905	Installed Building Products Inc	Install	IBP	2014	18.0500	1.0000	18.0500	31,839,087.0	574,695,520.35	3.0532
				2015	24.6200	1.0000	24.6200	31,366,328.0	772,238,995.36	2.4378
				2016	41.2700	1.0000	41.2700	31,485,525.0	1,299,407,616.75	3.3746
				2017	74.9700	1.0000	74.9700	31,862,561.0	2,388,736,198.17	3.7711
				2018	33.0700	1.0000	33.0700	31,224,974.0	1,032,609,890.18	1.3888
				2019	69.7400	1.0000	69.7400	30,016,749.0	2,093,368,075.26	2.1484
				2020	106.8900	1.0000	106.8900	29,800,535.0	3,185,379,186.15	3.0984
				2021	138.9000	1.0000	138.9000	29,707,155.0	4,126,323,829.50	2.8561
				2022	87.2200	1.0000	87.2200	28,603,412.0	2,494,789,594.64	1.6284
				2023	184.5900	1.0000	184.5900	28,409,079.0	5,244,031,892.61	3.1856
0001606163	Limbach Holdings Inc	Limbach	LMB	2015	9.8200	1.0000	9.8200	5,948,000.0	58,409,360.00	2.5147
				2017	13.2100	1.0000	13.2100	7,455,298.0	98,484,486.58	0.5323
				2018	3.9200	1.0000	3.9200	7,590,778.0	29,755,849.76	0.1291
				2019	3.0600	1.0000	3.0600	7,688,958.0	23,528,211.48	0.0989
				2020	12.9400	1.0000	12.9400	7,926,137.0	102,564,212.78	0.4359
				2021	8.9200	1.0000	8.9200	10,304,242.0	91,913,838.64	0.4110
				2022	10.9900	1.0000	10.9900	10,471,410.0	115,080,795.90	0.4664
				2023	44.5600	1.0000	44.5600	11,003,424.0	490,312,573.44	2.0096
0001633931	Topbuild Corp	Topbuil	BLD	2015	30.7700	1.0000	30.7700	37,681,765.0	1,159,467,909.05	0.9790
				2016	36.2100	1.0000	36.2100	38,042,282.0	1,377,511,031.22	1.1443
				2017	74.7500	1.0000	74.7500	35,579,350.0	2,659,556,412.50	2.1255
				2018	44.5000	1.0000	44.5000	35,384,990.0	1,574,632,055.00	0.8207
				2019	102.9500	1.0000	102.9500	33,947,722.0	3,494,917,979.90	1.7237
				2020	193.7400	1.0000	193.7400	33,024,441.0	6,398,155,199.34	2.9886
				2021	274.4600	1.0000	274.4600	32,925,108.0	9,036,625,141.68	2.6267
				2022	157.4300	1.0000	157.4300	31,972,332.0	5,033,404,226.76	1.3821
				2023	375.8900	1.0000	375.8900	31,773,944.0	11,943,507,810.16	3.0774
0001634424	Powercomm Holdings Inc	Powerco	nan	2016	nan	nan	nan	nan	nan	nan
				2017	nan	nan	nan	nan	nan	nan
				2018	nan	nan	nan	nan	nan	nan
0001682265	Reliant Holdings Inc	Reliant	RELT	2017	nan	1.0000	nan	14,585,000.0	nan	nan
				2018	nan	1.0000	nan	14,585,000.0	nan	nan
				2019	nan	1.0000	nan	14,585,000.0	nan	nan
				2020	0.1800	1.0000	0.1800	14,585,000.0	2,625,300.00	6.4395
				2021	0.3200	1.0000	0.3200	16,385,000.0	5,243,200.00	8.9412
				2022	0.1100	1.0000	0.1100	16,385,000.0	1,802,350.00	2.5739
				2023	0.1900	1.0000	0.1900	16,785,000.0	3,189,150.00	4.1651
0001703956	Concrete Pumping Holdings Inc	Concret	BBCP	2020	3.7100	1.0000	3.7100	58,200,084.0	215,922,311.64	0.3455
				2021	8.1900	1.0000	8.1900	56,593,944.0	463,504,401.36	0.7143
				2022	5.9200	1.0000	5.9200	56,599,833.0	335,071,011.36	0.4557
				2023	8.2600	1.0000	8.2600	54,709,742.0	451,902,468.92	0.6124
0001718227	Construction Partners Inc	Constru	ROAD	2018	8.5600	1.0000	8.5600	11,950,000.0	102,292,000.00	0.2952
				2019	17.4200	1.0000	17.4200	32,705,418.0	569,728,381.56	1.5826
				2020	27.8400	1.0000	27.8400	33,875,884.0	943,104,610.56	2.1651
				2021	29.4700	1.0000	29.4700	40,738,074.0	1,200,551,040.78	1.9934
				2022	26.7200	1.0000	26.7200	41,338,192.0	1,104,556,490.24	1.2729
				2023	43.9300	1.0000	43.9300	43,711,058.0	1,920,226,777.94	1.9971
0001721386	Landsea Homes Corp	Landsea	LSEA	2020	10.5700	1.0000	10.5700	12,219,363.0	129,158,666.91	2.1582
				2021	7.3300	1.0000	7.3300	46,281,091.0	339,240,397.03	0.3553
				2022	5.4500	1.0000	5.4500	40,950,043.0	223,177,734.35	0.2056
				2023	12.9600	1.0000	12.9600	37,795,191.0	489,825,675.36	0.4344
0001723866	Select Interior Concepts Inc	Select	nan	2018	nan	nan	nan	nan	nan	nan
				2019	nan	nan	nan	nan	nan	nan
				2020	nan	nan	nan	25,453,995.0	nan	nan
0001784567	Harbor Custom Development Inc	Harbor	nan	2020	nan	nan	nan	5,628,048.0	nan	nan
				2021	nan	nan	nan	14,922,094.0	nan	nan
				2022	nan	nan	nan	14,376,372.0	nan	nan
				2023	nan	nan	nan	2,329,322.0	nan	nan
0001785493	Phoenix Plus Corp	Phoenix	PXPC	2020	nan	1.0000	nan	331,917,500.0	nan	nan
				2021	nan	1.0000	nan	332,699,500.0	nan	nan
				2022	1.3500	1.0000	1.3500	332,699,500.0	449,144,325.00	544.6478
				2023	0.3000	1.0000	0.3000	332,699,500.0	99,809,850.00	144.8130
0001796209	APi Group Corp	APi Gro	APG	2021	25.1800	1.0000	25.1800	224,625,193.0	5,656,062,359.74	1.4152
				2022	18.5700	1.0000	18.5700	233,906,920.0	4,343,651,504.40	0.6554
				2023	34.1700	1.0000	34.1700	235,559,170.0	8,049,056,838.90	1.3075
0001825088	Dream Finders Homes Inc	Dream F	DFH	2021	19.1900	1.0000	19.1900	32,295,329.0	619,747,363.51	0.3835
				2022	9.1000	1.0000	9.1000	32,380,013.0	294,658,118.30	0.1494
				2023	35.5900	1.0000	35.5900	32,882,124.0	1,170,274,793.16	0.5795

QA: us_construction 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