QA: us_food 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
0000057515	Lancaster Colony Corp	Lancast	NaN	1	3	3	3	3	1	1	2	2	1	2	3	3	1	NaN	280.5050	276.3410	272.68100	278.4570	263.2970	273.85500	287.40500	280.8810	278.8020	269.4290	261.4530	245.1110	229.59000	236.9770	NaN	2	0	0	0	-2	0	1	0	-1	1	1	0	-2
0000910329	Medifast INC	Medifas	NaN	NaN	8	NaN	NaN	NaN	NaN	NaN	1	4	7	6	8	6	2	NaN	NaN	200.9420	NaN	NaN	NaN	NaN	NaN	287.5970	230.6570	214.8750	217.1810	208.1080	214.01000	230.4540	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	3	-1	2	-2	-4
0000785956	J J Snack Foods Corp	J J Sna	NaN	NaN	5	NaN	NaN	8	3	NaN	5	3	3	7	5	4	3	NaN	NaN	242.8860	NaN	NaN	212.2660	242.76200	NaN	240.8950	251.5110	248.7530	216.6720	219.6940	215.34600	229.7080	NaN	NaN	NaN	NaN	NaN	-5	NaN	NaN	-2	0	4	-2	-1	-1
0000814586	Lifeway Foods Inc	Lifeway	NaN	NaN	17	11	14	14	10	10	14	15	12	10	NaN	12	4	NaN	NaN	160.0570	192.84400	163.0140	157.4130	155.28100	175.37000	151.9490	143.8610	169.0200	192.3380	NaN	147.35800	205.9840	NaN	NaN	-6	3	0	-4	0	4	1	-3	-2	NaN	NaN	-8
0000098677	Tootsie Roll Industries INC	Tootsie	NaN	4	14	12	11	10	9	7	9	11	9	9	10	8	5	NaN	194.5830	188.2310	190.91400	194.2930	189.6760	194.42800	196.40700	206.8170	199.1560	195.4110	192.6280	185.4920	194.11900	196.0440	NaN	10	-2	-1	-1	-1	-2	2	2	-2	0	1	-2	-3
0000880117	Sanfilippo John B SON INC	Sanfili	NaN	NaN	NaN	22	NaN	16	NaN	NaN	NaN	NaN	13	13	12	9	6	NaN	NaN	NaN	123.96100	NaN	129.1110	NaN	NaN	NaN	NaN	161.8910	150.3360	163.8560	167.43300	190.2860	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-1	-3	-3
0000100493	Tyson Foods INC	Tyson F	NaN	6	9	13	NaN	NaN	NaN	4	7	5	6	3	4	2	7	NaN	191.9290	198.7340	183.80600	NaN	NaN	NaN	242.04500	227.2050	228.5970	215.7080	235.5600	221.2650	234.93400	183.1470	NaN	3	4	NaN	NaN	NaN	NaN	3	-2	1	-3	1	-2	5
0000014177	Bridgford Foods Corp	Bridgfo	NaN	NaN	33	41	16	35	13	19	15	14	18	18	21	1	8	NaN	NaN	73.7509	51.10130	132.4310	46.6837	131.47900	94.84120	149.1310	154.8950	108.4050	91.4394	84.2452	241.03500	179.1460	NaN	NaN	8	-25	19	-22	6	-4	-1	4	0	3	-20	7
0000730349	Tofutti Brands INC	Tofutti	NaN	NaN	12	25	34	21	NaN	14	11	10	11	NaN	NaN	13	9	NaN	NaN	193.2650	111.48000	63.1220	102.7470	NaN	129.04400	182.1290	204.3000	172.5290	NaN	NaN	129.06700	161.5370	NaN	NaN	13	9	-13	NaN	NaN	-3	-1	1	NaN	NaN	NaN	-4
0000055067	KELLANOVA	KELLANO	NaN	2	15	17	9	NaN	NaN	11	12	13	NaN	NaN	NaN	11	10	NaN	217.1570	187.3050	168.35600	203.2070	NaN	NaN	160.34200	181.7180	186.2470	NaN	NaN	NaN	149.26500	154.7270	NaN	13	2	-8	NaN	NaN	NaN	1	1	NaN	NaN	NaN	NaN	-1
0001611647	Freshpet Inc	Freshpe	NaN	NaN	NaN	NaN	NaN	20	7	8	10	12	19	4	6	7	11	NaN	NaN	NaN	NaN	NaN	102.9790	218.60400	192.91400	199.0260	194.2290	102.9820	223.0920	215.9430	210.00900	123.9570	NaN	NaN	NaN	NaN	NaN	-13	1	2	2	7	-15	2	1	4
0000015357	Chase General Corp	Chase G	NaN	NaN	NaN	27	13	13	8	9	21	30	17	31	7	14	12	NaN	NaN	NaN	102.82300	176.3390	165.1050	208.20000	192.20900	117.7450	50.5144	129.3310	29.4886	212.2450	110.96000	123.3930	NaN	NaN	NaN	-14	0	-5	1	12	9	-13	14	-24	7	-2
0001637459	Kraft Heinz Co	Kraft H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	17	16	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	92.3476	101.2660	106.44300	112.7150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-1	-3
0001046257	Ingredion Inc	Ingredi	NaN	7	11	9	8	9	6	6	6	9	5	16	19	18	14	NaN	188.5480	193.5060	198.34300	210.3110	209.8640	219.87500	224.25600	231.0090	218.8640	221.8160	92.8132	90.8559	89.73680	108.5390	NaN	4	-2	-1	1	-3	0	0	3	-4	11	3	-1	-4
0001007019	Coffee Holding Co INC	Coffee	NaN	NaN	25	20	19	NaN	NaN	NaN	NaN	NaN	16	12	15	22	15	NaN	NaN	113.7480	142.56400	126.1470	NaN	NaN	NaN	NaN	NaN	137.3640	150.4730	145.8620	78.15000	100.5660	NaN	NaN	-5	-1	NaN	NaN	NaN	NaN	NaN	NaN	-4	3	7	-7
0000047111	Hershey Co	Hershey	3	15	39	38	27	26	22	29	29	27	25	21	24	19	16	59.0401	61.5315	62.9127	66.35220	86.0017	78.7845	51.79010	51.37010	57.8695	61.7438	66.1644	70.7631	76.8212	85.18780	96.3127	12	24	-1	-11	-1	-4	7	0	-2	-2	-4	3	-5	-3
0000091419	J M Smucker Co	J M Smu	NaN	NaN	20	23	18	18	20	NaN	NaN	NaN	NaN	NaN	16	17	17	NaN	NaN	144.4020	122.18600	126.1780	122.7440	77.18460	NaN	NaN	NaN	NaN	NaN	106.2990	103.74900	85.6929	NaN	NaN	3	-5	0	2	NaN	NaN	NaN	NaN	NaN	NaN	1	0
0001103982	Mondelez International Inc	Mondele	2	13	36	34	25	30	16	24	26	22	23	20	20	24	18	81.7141	74.4091	68.8592	84.36360	92.7388	71.1842	103.55700	74.66740	85.9015	82.9356	89.8405	82.5808	89.9142	72.69840	85.5688	11	23	-2	-9	5	-14	8	2	-4	1	-3	0	4	-6
0000063754	Mccormick Co INC	Mccormi	NaN	9	27	30	23	24	19	23	31	26	24	22	27	25	19	NaN	102.7760	90.9926	95.45360	104.5410	90.5046	78.97120	81.05780	52.2044	71.7193	69.7099	68.7169	71.5049	72.03570	81.7830	NaN	18	3	-7	1	-5	4	8	-5	-2	-2	5	-2	-6
0001856608	Sovos Brands Inc	Sovos B	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	29	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	75.4899	58.35900	80.7355	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-9
0000023217	Conagra Brands INC	Conagra	NaN	10	28	37	39	34	29	31	25	23	26	23	23	23	21	NaN	86.4864	90.3526	75.51260	50.9784	47.9109	36.36730	32.54820	87.1114	81.4562	62.5976	68.5879	81.5481	77.15200	75.7562	NaN	18	9	2	-5	-5	2	-6	-2	3	-3	0	0	-2
0000040704	General Mills INC	General	NaN	14	31	36	30	27	21	26	27	29	28	25	26	20	22	NaN	73.3053	83.0399	80.02260	80.9246	78.0378	52.39380	62.39070	60.5785	53.8304	54.5043	62.1036	73.3052	81.16500	75.3055	NaN	17	5	-6	-3	-6	5	1	2	-1	-3	1	-6	2
0001320695	Treehouse Foods Inc	Treehou	NaN	11	30	32	26	25	17	27	30	28	NaN	27	30	30	23	NaN	79.9076	88.1302	92.68890	90.9961	84.1789	97.62200	55.53310	54.2895	60.6395	NaN	56.8167	58.2341	57.34930	72.7923	NaN	19	2	-6	-1	-8	10	3	-2	NaN	NaN	3	0	-7
0001679273	Lamb Weston Holdings Inc	Lamb We	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32	37	34	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23.6579	35.1186	21.74860	69.0694	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-3	-10
0000910406	Hain Celestial Group INC	Hain Ce	NaN	NaN	21	21	21	19	14	17	20	18	22	15	13	21	25	NaN	NaN	143.7120	124.02000	111.5980	120.1770	119.78500	102.07900	117.8480	115.2400	89.8795	126.3710	161.9790	80.15720	67.5766	NaN	NaN	0	0	-2	-5	3	3	-2	4	-7	-2	8	4
0000802481	Pilgrims Pride Corp	Pilgrim	NaN	NaN	NaN	NaN	17	7	15	21	NaN	NaN	NaN	26	35	26	26	NaN	NaN	NaN	NaN	131.6810	220.5470	114.23100	83.35300	NaN	NaN	NaN	60.7754	46.6778	65.48070	66.2971	NaN	NaN	NaN	NaN	-10	8	6	NaN	NaN	NaN	NaN	9	-9	0
0000016732	Campbell Soup Co	Campbel	NaN	NaN	40	42	41	33	27	30	28	32	NaN	24	29	28	27	NaN	NaN	50.1543	46.34170	36.5782	52.9894	39.80590	47.11270	60.0631	16.9198	NaN	64.0422	63.0100	59.76970	66.1953	NaN	NaN	2	-1	-8	-6	3	-2	4	NaN	NaN	5	-1	-1
0001530950	Post Holdings Inc	Post Ho	NaN	NaN	NaN	35	31	37	23	28	32	31	29	29	36	27	28	NaN	NaN	NaN	82.97980	76.4310	35.9983	48.36200	52.39090	37.3700	44.5847	40.0104	36.8122	42.5123	64.11340	61.7873	NaN	NaN	NaN	-4	6	-14	5	4	-1	-2	0	7	-9	1
0001753706	Whole Earth Brands Inc	Whole E	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32	32	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	55.9286	33.57150	39.1314	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-3
0001278027	B G Foods Inc	B G Foo	NaN	NaN	41	40	40	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33	30	NaN	NaN	38.3991	60.74160	48.9007	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32.59590	33.1912	NaN	NaN	-1	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3
0001772016	Bellring Brands INC	Bellrin	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	41	39	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12.8776	7.7100	-34.25520	-10.8702	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-2	-8
0001650696	Laird Superfood Inc	Laird S	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	2	46	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	191.0900	248.0770	-285.47800	-26.4864	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	44	-14
0001830210	Benson Hill Inc	Benson	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	40	36	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18.8835	-2.50683	-50.9560	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	-3
0001117057	Planet Green Holdings Corp	Planet	NaN	NaN	13	14	15	17	NaN	38	34	1	14	NaN	22	37	34	NaN	NaN	188.2750	182.56600	157.9830	127.0610	NaN	-167.55000	-239.2860	301.9710	153.3750	NaN	82.2280	-5.65765	-53.0345	NaN	NaN	1	1	2	NaN	NaN	-4	-33	13	NaN	NaN	15	-3
0000034563	Farmer Brothers Co	Farmer	NaN	NaN	NaN	49	NaN	23	25	12	18	25	31	33	38	31	35	NaN	NaN	NaN	-1.83584	NaN	94.6470	45.07430	155.84300	121.8290	75.5439	16.9501	18.1856	31.1909	39.37650	-63.7533	NaN	NaN	NaN	NaN	NaN	2	-13	6	7	6	2	5	-7	4
0001005286	Lifecore Biomedical INC De	Lifecor	NaN	NaN	NaN	NaN	NaN	NaN	12	16	17	16	21	28	34	38	36	NaN	NaN	NaN	NaN	NaN	NaN	138.67300	111.53200	136.1690	142.3200	95.5882	54.3176	52.0736	-23.21290	-67.6820	NaN	NaN	NaN	NaN	NaN	NaN	4	1	-1	5	7	6	4	-2
0001800373	Goldenwell Biotech INC	Goldenw	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33	NaN	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	53.4754	NaN	-69.5156	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001487197	Barfresh Food Group INC	Barfres	NaN	NaN	NaN	48	50	41	32	37	36	36	35	35	14	45	38	NaN	NaN	NaN	23.30900	-586.9740	-68.2546	-20.29890	-101.45100	-386.7630	-182.9910	-192.7520	-118.5270	150.4950	-249.68400	-70.2004	NaN	NaN	NaN	2	-9	-9	5	-1	0	-1	0	-21	31	-7
0001730773	Blue Star Foods Corp	Blue St	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33	32	36	31	47	39	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10.4656	-17.4615	-118.7610	57.2453	-316.82600	-113.6390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	4	-5	16	-8
0001655210	Beyond Meat INC	Beyond	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	14	42	40	40	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	190.9960	137.4190	-15.4519	-89.92020	-136.2950	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	28	-2	0
0001409446	Nate S Food Co	Nate S	NaN	NaN	NaN	NaN	NaN	NaN	40	43	16	38	NaN	NaN	48	43	41	NaN	NaN	NaN	NaN	NaN	NaN	-1190.52000	-578.11000	140.5440	-564.3340	NaN	NaN	-278.3170	-192.65900	-292.1080	NaN	NaN	NaN	NaN	NaN	NaN	3	-27	22	NaN	NaN	NaN	-5	-2
0001063537	Ricebran Technologies	Ricebra	NaN	NaN	44	50	44	42	33	36	24	24	27	30	39	35	42	NaN	NaN	22.9137	-8.65764	-44.8630	-75.3732	-38.38180	-69.50350	90.3373	81.2018	56.9155	31.7747	29.2302	5.40086	-376.8290	NaN	NaN	6	-6	-2	-9	3	-12	0	3	3	9	-4	7
0001624517	Yuenglings Ice Cream Corp	Yuengli	NaN	NaN	NaN	NaN	NaN	NaN	39	NaN	NaN	NaN	NaN	NaN	47	50	43	NaN	NaN	NaN	NaN	NaN	NaN	-827.63900	NaN	NaN	NaN	NaN	NaN	-277.7340	-343.74200	-378.9470	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-7
0001725911	Netbrands Corp	Netbran	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	33	43	45	44	44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7.5842	-106.1890	-8645.0100	-191.8020	-242.38300	-558.6870	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	10	2	-1	0
0001593001	Nightfood Holdings Inc	Nightfo	NaN	NaN	NaN	NaN	NaN	NaN	37	44	37	39	36	42	44	51	45	NaN	NaN	NaN	NaN	NaN	NaN	-670.80500	-811.81900	-730.5420	-981.3630	-326.5220	-482.7000	-167.8110	-690.83500	-1088.9300	NaN	NaN	NaN	NaN	NaN	NaN	7	-7	2	-3	6	2	7	-6
0000909954	Keurig Green Mountain INC	Keurig	1	3	7	4	6	6	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	222.6890	212.1870	224.0750	241.59800	242.3980	233.5900	239.24900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	4	-3	2	0	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000023666	Hillshire Brands Co	Hillshi	NaN	8	19	5	12	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	162.9050	147.4570	239.15900	188.3650	171.6870	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	-14	7	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000046640	Kraft Heinz Foods Co	Kraft H	NaN	16	34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49.3772	73.2839	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000931336	Dean Foods Co	Dean Fo	NaN	5	37	15	4	15	11	13	13	21	30	NaN	NaN	NaN	NaN	NaN	192.2680	67.9832	177.96700	254.4690	146.6650	144.92500	152.72100	165.7380	88.0134	30.9561	NaN	NaN	NaN	NaN	NaN	32	-22	-11	11	-4	2	0	8	9	NaN	NaN	NaN	NaN
0001029506	Ralcorp Holdings INC Mo	Ralcorp	NaN	12	38	39	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	79.4780	63.1194	64.44070	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	26	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000042228	Golden Enterprises INC	Golden	NaN	NaN	26	26	24	22	NaN	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	106.0160	103.39600	98.2116	94.9068	NaN	124.03500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-2	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000057528	Snyder S Lance INC	Snyder	NaN	NaN	24	29	22	NaN	NaN	20	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	116.4130	100.07200	107.8290	NaN	NaN	88.49350	118.2630	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-7	NaN	NaN	NaN	-1	NaN	NaN	NaN	NaN	NaN	NaN
0000076149	Paradise INC	Paradis	NaN	NaN	6	NaN	5	4	5	3	4	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	239.2700	NaN	251.3030	242.6290	232.34600	250.70400	245.9160	221.1170	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	1	-2	1	4	NaN	NaN	NaN	NaN	NaN
0000812128	Sanderson Farms INC	Sanders	NaN	NaN	16	6	7	2	2	2	3	6	4	5	1	NaN	NaN	NaN	NaN	163.7790	222.37600	241.3590	290.8970	273.81900	270.96300	276.5700	227.5960	224.2300	218.8940	280.3260	NaN	NaN	NaN	NaN	-10	1	-5	0	0	1	3	-2	1	-4	NaN	NaN
0000944508	Inventure Foods INC	Inventu	NaN	NaN	32	24	33	28	30	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	80.9590	120.99600	67.1997	75.3581	14.61630	-18.27650	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	9	-5	2	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000949852	Thanksgiving Coffee Co INC	Thanksg	NaN	NaN	35	NaN	NaN	NaN	NaN	25	23	17	15	NaN	NaN	NaN	NaN	NaN	NaN	70.0485	NaN	NaN	NaN	NaN	73.79120	104.1840	116.9000	143.4780	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-6	-2	NaN	NaN	NaN	NaN
0001099977	China Marine Food Group LTD	China M	NaN	NaN	4	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	270.5010	197.97800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001101020	Overhill Farms INC	Overhil	NaN	NaN	23	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	123.4980	149.97000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001128928	Flowers Foods INC	Flowers	NaN	NaN	18	18	1	NaN	NaN	5	8	7	8	NaN	NaN	5	NaN	NaN	NaN	153.9930	167.58600	695.9990	NaN	NaN	235.27700	222.2770	224.7540	213.2160	NaN	NaN	215.23100	NaN	NaN	NaN	0	-17	NaN	NaN	NaN	3	-1	1	NaN	NaN	NaN	NaN
0001273385	Nutrastar International Inc	Nutrast	NaN	NaN	1	2	2	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	338.0820	316.39400	328.9750	317.3050	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	0	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001307701	Cono Italiano Inc	Cono It	NaN	NaN	47	52	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-843.1690	-311.65700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001331301	Boulder Brands INC	Boulder	NaN	NaN	22	31	29	40	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	126.4380	94.18950	84.2763	11.2856	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	-2	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001368196	Oriental Dragon Corp	Orienta	NaN	NaN	2	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	327.4960	337.16100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001370544	Smoky Market Foods INC	Smoky M	NaN	NaN	46	NaN	48	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-462.1870	NaN	-294.9900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001420566	Pinnacle Foods Finance LLC	Pinnacl	NaN	NaN	43	46	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	26.1018	33.33060	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001421289	Livewire Ergogenics Inc	Livewir	NaN	NaN	45	54	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-378.8380	-927.31100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001452011	Tanke Biosciences Corp	Tanke B	NaN	NaN	29	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	88.8508	102.04000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001452575	Mead Johnson Nutrition Co	Mead Jo	NaN	NaN	42	44	37	31	31	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	30.0347	40.35160	55.2050	65.3662	9.29929	9.99314	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-7	-6	0	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001467746	Deyu Agriculture Corp	Deyu Ag	NaN	NaN	10	8	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	193.8700	215.66500	61.1175	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000088948	Seneca Foods Corp	Seneca	NaN	NaN	NaN	33	NaN	NaN	18	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	90.22310	NaN	NaN	79.23450	95.97450	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000739608	Penford Corp	Penford	NaN	NaN	NaN	47	32	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	32.17370	70.8490	73.1967	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-15	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001052257	Agritech Worldwide Inc	Agritec	NaN	NaN	NaN	53	51	44	41	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-389.68000	-1040.5100	-374.7740	-1752.18000	-411.40000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-7	-3	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001058330	Rogue One Inc	Rogue O	NaN	NaN	NaN	55	49	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3638.37000	-528.7300	-490.3810	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	-4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001293593	Synutra International Inc	Synutra	NaN	NaN	NaN	43	43	38	24	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42.98230	-21.1908	28.6923	46.57520	30.86070	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-5	-14	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001320947	Diamond Foods Inc	Diamond	NaN	NaN	NaN	16	20	12	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	170.46400	117.2900	168.5380	44.34430	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-8	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001520358	Mama S Creations Inc	Mama S	NaN	NaN	NaN	51	42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-48.03550	-10.4605	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001545158	Kraft Foods Group Inc	Kraft F	NaN	NaN	NaN	45	35	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37.98540	61.7202	38.7575	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001555365	Whitewave Foods Co	Whitewa	NaN	NaN	NaN	7	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	221.48800	85.1873	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001091983	Forevergreen Worldwide Corp	Forever	NaN	NaN	NaN	NaN	45	39	34	39	33	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-103.3050	14.2039	-87.69660	-236.21000	-186.6970	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	-5	5	-6	NaN	NaN	NaN	NaN	NaN	NaN
0001431897	Annie S Inc	Annie S	NaN	NaN	NaN	NaN	10	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	198.7950	240.9650	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001564822	Pinnacle Foods INC	Pinnacl	NaN	NaN	NaN	NaN	38	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	55.1140	64.8570	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001565383	Lollipop Corp	Lollipo	NaN	NaN	NaN	NaN	46	47	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-119.1920	-1054.2100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001568139	Bio En Holdings Corp	Bio En	NaN	NaN	NaN	NaN	47	NaN	35	40	NaN	NaN	NaN	40	49	NaN	NaN	NaN	NaN	NaN	NaN	-225.0210	NaN	-330.38100	-310.14900	NaN	NaN	NaN	-457.5700	-289.4150	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	NaN	NaN	NaN	NaN	9	NaN	NaN
0001334586	Jammin Java Corp	Jammin	NaN	NaN	NaN	NaN	NaN	43	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-304.4220	-719.46900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001451433	Nutranomics INC	Nutrano	NaN	NaN	NaN	NaN	NaN	46	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-518.5440	-384.53700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001609989	Blue Buffalo Pet Products Inc	Blue Bu	NaN	NaN	NaN	NaN	NaN	NaN	28	22	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39.26110	81.69720	115.9950	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6	0	NaN	NaN	NaN	NaN	NaN	NaN
0000859747	1PM Industries	1PM Ind	NaN	NaN	NaN	NaN	NaN	NaN	NaN	42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-416.07500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001137005	Curative Biosciences INC	Curativ	NaN	NaN	NaN	NaN	NaN	NaN	NaN	45	35	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1375.36000	-305.0590	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	NaN	NaN	NaN	NaN	NaN	NaN
0001669792	Advancepierre Foods Holdings Inc	Advance	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9.12327	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001563463	Nutralife Biosciences INC	Nutrali	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37	NaN	37	46	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-226.8250	NaN	-123.5790	-252.4980	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN
0001612188	TEO Foods INC	TEO Foo	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	35	34	38	50	48	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-156.7430	-113.0660	-336.1670	-332.6290	-324.02300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	4	12	-2	NaN
0001619055	Coffeesmiths Collective INC	Coffees	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	110.2040	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001644406	Hostess Brands Inc	Hostess	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20	20	19	18	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	101.0780	99.3170	91.3948	99.6588	108.95300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-1	-1	-3	NaN
0001572386	Greenway Technologies INC	Greenwa	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37	39	51	49	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-439.4250	-391.0030	-341.5620	-329.19800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	12	-2	NaN
0001741231	Tattooed Chef Inc	Tattooe	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	1	28	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	255.9650	308.6670	70.5274	-107.18200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	27	13	NaN
0001563227	Sipup Corp	Sipup C	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-465.9670	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001579733	Vital Farms Inc	Vital F	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	11	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	211.7950	185.0750	159.79800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	-1	NaN
0001616262	Rocky Mountain Chocolate Factory Inc	Rocky M	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	187.3330	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001691936	Stryve Foods INC	Stryve	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	43	42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-155.8350	-149.67400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1	NaN

PDF reports

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

2009

Logs

warning	1 × Missing logo	subcommand.report	0000909954
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111

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	IntangibleAssets	136,078,000	192,180,200	705,399,180	38,043,410,000	42,193,000,000	0000909954	0000047111	0001103982
1	AssetsCurrent	537,367,000	622,173,700	1,387,647,713	11,347,143,400	12,454,000,000	0000909954	0000047111	0001103982
2	PropertyPlantAndEquipment	0	13,598,100	138,092,404	9,637,298,100	10,693,000,000	0000047111	0000909954	0001103982
3	remainder_Assets	3,979,000	140,981,100	1,374,043,699	1,570,647,300	1,592,497,000	0000909954	0001103982	0000047111
4	LiabilitiesLongTerm	0	200,406,400	2,007,695,587	18,346,206,400	20,162,000,000	0000909954	0000047111	0001103982
5	LiabilitiesCurrent	126,443,000	204,861,500	912,744,074	10,432,962,800	11,491,000,000	0000909954	0000047111	0001103982
6	remainder_Liabilities	0	0	1,817,800	8,180,100,000	9,089,000,000	0000047111	0000909954	0001103982
7	GeneralAndAdministrativeExpense	0	0	9,531	42,889,500	47,655,000	0000047111	0001103982	0000909954
8	SellingAndMarketingExpense	0	0	24,270	109,215,000	121,350,000	0000047111	0001103982	0000909954
9	remainder_Expenses	579,691,000	1,007,989,300	4,869,171,865	34,103,067,400	37,352,000,000	0000909954	0000047111	0001103982
10	remainder_Revenues	786,135,000	1,237,388,300	5,305,685,466	36,877,266,800	40,386,000,000	0000909954	0000047111	0001103982
11	remainder_NetIncome	-6,000,000	-5,400,000	3,400	15,300,000	17,000,000	0001103982	0000047111	0000909954
12	remainder_ComprehensiveNetIncome	-1,451,000	-1,305,900	414,600	1,865,700,000	2,073,000,000	0000909954	0000047111	0001103982

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	813,405,000	1,099,567,600	3,687,638,794	60,410,103,100	66,714,000,000	0000909954	0000047111	0001103982
1	Liabilities	126,443,000	405,267,900	2,922,257,462	36,959,269,200	40,742,000,000	0000909954	0000047111	0001103982
2	Expenses	748,696,000	1,160,093,800	4,869,171,865	34,103,067,400	37,352,000,000	0000909954	0000047111	0001103982
3	Revenues	786,135,000	1,237,388,300	5,305,685,466	36,877,266,800	40,386,000,000	0000909954	0000047111	0001103982
4	StockholdersEquity	686,962,000	694,299,700	765,381,332	23,450,833,900	25,972,000,000	0000909954	0000047111	0001103982
5	NetIncome	54,439,000	92,594,500	436,512,401	2,768,799,400	3,028,000,000	0000909954	0000047111	0001103982
6	ComprehensiveNetIncome	53,684,480	91,915,432	436,727,993	3,738,963,400	4,105,960,000	0000909954	0000047111	0001103982
7	BaseVar	2,093,103,690	3,275,139,710	13,938,108,550	124,814,434,889	137,136,765,000	0000909954	0000047111	0001103982
8	EconomicCapitalRatio	0.590	0.613	0.817	2.09	2.23	0000047111	0001103982	0000909954

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	IntangibleAssets	-0.343	-0.316	-0.0712	0.456	0.514	0000047111	0000909954	0001103982
1	AssetsCurrent	-0.201	-0.194	-0.132	0.127	0.156	0000047111	0001103982	0000909954
2	PropertyPlantAndEquipment	-0.195	-0.173	0.0198	0.0709	0.0766	0000047111	0000909954	0001103982
3	remainder_Assets	-0.0749	-0.0715	-0.0405	0.341	0.384	0001103982	0000909954	0000047111
4	LiabilitiesLongTerm	-0.365	-0.352	-0.241	0.767	0.879	0000047111	0001103982	0000909954
5	LiabilitiesCurrent	-0.0639	-0.0545	0.0307	0.0951	0.102	0001103982	0000047111	0000909954
6	remainder_Liabilities	-0.211	-0.175	0.148	0.224	0.232	0001103982	0000047111	0000909954
7	GeneralAndAdministrativeExpense	-0.141	-0.123	0.0405	0.0643	0.0670	0000909954	0001103982	0000047111
8	SellingAndMarketingExpense	-0.360	-0.314	0.103	0.164	0.171	0000909954	0001103982	0000047111
9	remainder_Expenses	-0.440	-0.382	0.145	0.204	0.211	0000047111	0001103982	0000909954
10	remainder_Revenues	-0.298	-0.244	0.235	0.266	0.269	0001103982	0000909954	0000047111
11	remainder_NetIncome	-0.0238	-0.0228	-0.0146	0.0440	0.0505	0000047111	0001103982	0000909954
12	remainder_ComprehensiveNetIncome	-0.0266	-0.0262	-0.0221	0.0235	0.0286	0000909954	0000047111	0001103982

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.418	-0.375	0.01000	0.271	0.300	0000047111	0000909954	0001103982
1	Liabilities	-0.566	-0.524	-0.149	0.976	1.10	0001103982	0000047111	0000909954
2	Expenses	-0.290	-0.281	-0.203	0.240	0.289	0000909954	0000047111	0001103982
3	Revenues	-0.298	-0.244	0.235	0.266	0.269	0001103982	0000909954	0000047111
4	StockholdersEquity	-0.782	-0.704	-0.00455	0.749	0.833	0000047111	0001103982	0000909954
5	NetIncome	-0.0234	-0.0215	-0.00433	0.0382	0.0429	0001103982	0000909954	0000047111
6	ComprehensiveNetIncome	-0.0310	-0.0274	0.00515	0.0193	0.0208	0000909954	0001103982	0000047111
7	BaseVar	nan	nan	nan	nan	nan	0000047111	0000909954	0000047111
8	EconomicCapitalRatio	-0.621	-0.598	-0.394	0.874	1.02	0000047111	0001103982	0000909954

2010

Logs

warning	9 × No stock price available	subcommand.plot	0000023666 0000046640 0000909954 0001029506 0000047111 0000055067 0000057515 0000931336 0001320695
warning	4 × Missing logo	subcommand.report	0000023666 0000046640 0000909954 0001029506
warning	1 × Similarly named company. Duplicate?	None	0000023666
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111

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	IntangibleAssets	73,237,000	85,689,250	1,912,441,000	23,685,600,000	63,819,000,000	0000098677	0000100493	0001103982
1	AssetsCurrent	237,591,000	297,447,000	1,911,000,002	7,518,750,000	16,221,000,000	0000098677	0000047111	0001103982
2	PropertyPlantAndEquipment	166,097,000	203,143,250	2,080,930,694	6,203,500,000	13,792,000,000	0000057515	0000046640	0001103982
3	remainder_Assets	9,961,000	12,328,000	367,631,906	1,633,218,000	2,161,872,000	0000909954	0000100493	0000046640
4	LiabilitiesLongTerm	0	0	509,025,008	13,109,150,000	30,275,000,000	0000023666	0001320695	0001103982
5	LiabilitiesCurrent	58,505,000	73,091,000	1,370,118,180	6,741,825,000	15,660,000,000	0000098677	0000931336	0001103982
6	remainder_Liabilities	0	0	66,661,386	5,776,700,000	13,412,000,000	0000023666	0000098677	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	237,758,500	629,656,000	0000023217	0000098677	0000931336
8	SellingAndMarketingExpense	0	0	0	615,945,000	1,904,526,000	0000023217	0000098677	0000931336
9	remainder_Expenses	476,092,000	825,956,500	7,218,008,440	32,160,500,000	46,706,000,000	0000098677	0000931336	0001103982
10	remainder_Revenues	521,448,000	922,818,000	8,090,231,961	33,624,250,000	49,207,000,000	0000098677	0000046640	0001103982
11	remainder_NetIncome	-353,000,000	-270,834,500	0	485,775,000	1,638,000,000	0000100493	0001046257	0001103982
12	remainder_ComprehensiveNetIncome	-179,100,000	-44,775,000	0	28,637,250	111,000,000	0000023217	0000100493	0001046257

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	586,453,000	791,900,500	7,382,511,150	37,081,425,000	95,289,000,000	0000057515	0000931336	0001103982
1	Liabilities	77,953,000	163,060,000	2,416,885,500	23,859,925,000	59,347,000,000	0000057515	0000100493	0001103982
2	Expenses	476,092,000	825,956,500	7,382,238,155	32,160,500,000	46,706,000,000	0000098677	0000046640	0001103982
3	Revenues	521,448,000	922,818,000	8,090,231,961	33,624,250,000	49,207,000,000	0000098677	0000046640	0001103982
4	StockholdersEquity	508,500,000	628,840,500	3,386,266,200	15,669,500,000	35,942,000,000	0000057515	0001046257	0001103982
5	NetIncome	53,714,000	73,058,000	440,208,898	2,186,000,000	4,139,000,000	0000098677	0000047111	0001103982
6	ComprehensiveNetIncome	54,329,160	73,305,390	440,208,898	2,186,000,000	4,139,000,000	0000098677	0000047111	0001103982
7	BaseVar	1,578,305,645	2,211,326,630	21,517,893,179	93,765,530,000	179,258,795,000	0000098677	0000023666	0001103982
8	EconomicCapitalRatio	0.494	0.585	1.33	2.33	2.81	0000046640	0000023666	0000057515

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	IntangibleAssets	-0.360	-0.307	-0.0173	0.634	0.635	0000047111	0000055067	0001029506
1	AssetsCurrent	-0.116	-0.104	-0.0117	0.0972	0.121	0000100493	0000057515	0000047111
2	PropertyPlantAndEquipment	-0.0967	-0.0909	-0.0200	0.0943	0.180	0000100493	0001103982	0001046257
3	remainder_Assets	-0.0871	-0.0790	-0.0279	0.193	0.288	0000100493	0001046257	0000098677
4	LiabilitiesLongTerm	-0.661	-0.644	0.321	1.19	1.23	0001320695	0000098677	0000100493
5	LiabilitiesCurrent	-0.381	-0.224	-0.0357	0.529	0.579	0000023666	0000909954	0000057515
6	remainder_Liabilities	-0.524	-0.469	0.105	0.481	0.516	0000023217	0000063754	0000100493
7	GeneralAndAdministrativeExpense	-0.223	-0.222	0.0303	0.0708	0.0877	0000931336	0000063754	0000100493
8	SellingAndMarketingExpense	-0.733	-0.487	0.0609	0.142	0.176	0000931336	0000063754	0000100493
9	remainder_Expenses	-1.93	-1.23	0.0321	0.401	0.423	0000100493	0000046640	0000909954
10	remainder_Revenues	-0.425	-0.365	-0.0301	1.22	1.50	0001103982	0001046257	0000100493
11	remainder_NetIncome	-0.110	-0.108	0.000297	0.0362	0.0444	0000100493	0000909954	0001103982
12	remainder_ComprehensiveNetIncome	-0.0222	-0.00787	-0.00109	0.0105	0.0377	0000023217	0000909954	0001046257

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-0.399	-0.327	0.0114	0.406	0.465	0000100493	0000909954	0001103982
1	Liabilities	-0.835	-0.723	0.00968	1.77	1.79	0001103982	0000098677	0000057515
2	Expenses	-1.67	-1.01	-0.00761	0.312	0.371	0000100493	0000023217	0001103982
3	Revenues	-0.425	-0.365	-0.0301	1.22	1.50	0001103982	0001046257	0000100493
4	StockholdersEquity	-1.04	-0.834	0.00188	0.742	0.899	0000100493	0001029506	0000098677
5	NetIncome	-0.299	-0.282	-0.0181	0.180	0.340	0000931336	0001103982	0000057515
6	ComprehensiveNetIncome	-0.301	-0.285	-0.0190	0.178	0.337	0000931336	0001103982	0000057515
7	BaseVar	nan	nan	nan	nan	nan	0000023217	0000098677	0000023217
8	EconomicCapitalRatio	-0.911	-0.820	-0.0753	0.925	1.40	0000046640	0000023666	0000057515

2011

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001167905 0001167905
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001058330
warning	26 × No stock price available	subcommand.plot	0001278027 0000944508 0000023666 0000042228 0000046640 0000909954 0001029506 0001099977 0001101020 0001273385 0001307701 0001331301 0001368196 0001370544 0001420566 0001452011 0001467746 0000057528 0000076149 0000047111 0000055067 0000057515 0000812128 0000931336 0000949852 0001452575
warning	18 × Missing logo	subcommand.report	0001278027 0000944508 0000023666 0000042228 0000046640 0000909954 0001029506 0001099977 0001101020 0001273385 0001307701 0001331301 0001368196 0001370544 0001420566 0001421289 0001452011 0001467746
warning	5 × Similarly named company. Duplicate?	None	0000023666 0001101020 0001331301 0001007019 0000730349
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.5831259413120415}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001167905
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111

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	IntangibleAssets	0	0	122,475,315	5,550,029,200	62,483,000,000	0000014177	0000785956	0001103982
1	AssetsCurrent	32,937	315,731	260,187,392	4,379,400,000	16,202,000,000	0001307701	0000785956	0001103982
2	PropertyPlantAndEquipment	0	5,779	124,928,907	3,326,430,000	13,813,000,000	0001467746	0000785956	0001103982
3	remainder_Assets	0	165	23,298,561	1,650,052,700	2,673,579,000	0001307701	0001320695	0000046640
4	LiabilitiesLongTerm	0	0	0	3,577,089,300	26,491,000,000	0000014177	0001467746	0001103982
5	LiabilitiesCurrent	37,138	730,466	75,849,417	3,983,160,000	18,445,000,000	0001421289	0000785956	0001103982
6	remainder_Liabilities	0	0	8,671,718	1,179,153,800	13,573,000,000	0000023666	0000910329	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	161,456,300	612,000,000	0000014177	0000047111	0000016732
8	SellingAndMarketingExpense	0	0	0	455,798,800	1,963,748,000	0000014177	0000055067	0000931336
9	remainder_Expenses	260,858	2,460,907	545,529,372	12,820,750,000	50,818,000,000	0001421289	0000785956	0001103982
10	remainder_Revenues	0	144,498	745,662,025	14,375,540,000	54,365,000,000	0001467746	0000785956	0001103982
11	remainder_NetIncome	-247,420,000	-117,559,000	0	35,092,764	935,000,000	0000931336	0001103982	0000023666
12	remainder_ComprehensiveNetIncome	-2,767,000,000	-58,720,100	0	4,146,441	60,800,000	0001103982	0000910329	0000023217

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	37,274	494,722	858,273,059	12,131,751,500	93,837,000,000	0001370544	0000098677	0001103982
1	Liabilities	749,745	1,035,116	191,958,237	8,256,517,000	58,509,000,000	0000949852	0000098677	0001103982
2	Expenses	795,286	2,882,199	545,529,372	14,037,320,800	50,818,000,000	0001421289	0000785956	0001103982
3	Revenues	0	144,498	745,662,025	14,375,540,000	54,365,000,000	0001467746	0000785956	0001103982
4	StockholdersEquity	-168,000,000	-961,941	475,294,439	7,995,260,000	35,328,000,000	0001452575	0000785956	0001103982
5	NetIncome	-1,592,171,000	-103,028,100	21,142,087	1,478,520,800	3,547,000,000	0000931336	0001117057	0001103982
6	ComprehensiveNetIncome	-1,592,171,000	-103,028,100	24,231,087	1,478,520,800	2,108,160,000	0000931336	0001117057	0001103982
7	BaseVar	1,749,338	5,984,244	2,120,783,122	41,576,929,750	188,980,750,000	0001421289	0001278027	0001103982
8	EconomicCapitalRatio	-8.43	-2.58	1.16	2.75	3.38	0001307701	0000057528	0001273385

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	IntangibleAssets	-1.96	-0.682	-0.0694	0.801	1.44	0001307701	0001467746	0001331301
1	AssetsCurrent	-2.34	-0.775	-0.105	0.238	0.715	0001307701	0000814586	0001452011
2	PropertyPlantAndEquipment	-0.647	-0.427	-0.000877	0.161	0.782	0001421289	0000076149	0001063537
3	remainder_Assets	-0.644	-0.248	-0.0434	0.269	0.572	0001307701	0001331301	0001420566
4	LiabilitiesLongTerm	-1.33	-0.775	0.345	0.920	1.08	0001278027	0000098677	0000730349
5	LiabilitiesCurrent	-0.949	-0.373	0.0908	0.664	0.802	0000023666	0001278027	0000730349
6	remainder_Liabilities	-0.898	-0.149	0.362	2.24	8.76	0001467746	0000047111	0001307701
7	GeneralAndAdministrativeExpense	-3.40	-0.557	0.151	0.487	0.566	0001307701	0001063537	0001007019
8	SellingAndMarketingExpense	-0.933	-0.618	0.0821	0.277	0.322	0001307701	0000098677	0001007019
9	remainder_Expenses	-2.92	-2.36	-0.0319	0.849	1.26	0001007019	0001029506	0001421289
10	remainder_Revenues	-3.00	-1.24	0.207	2.14	2.41	0001307701	0000909954	0001007019
11	remainder_NetIncome	-1.01	-0.185	-0.0293	0.198	1.16	0000785956	0001307701	0001467746
12	remainder_ComprehensiveNetIncome	-0.0864	-0.0346	-0.00306	0.0495	0.0780	0001128928	0000076149	0001273385

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-4.09	-1.56	0.00565	0.573	0.640	0001307701	0001046257	0001278027
1	Liabilities	-1.08	-0.755	0.614	2.12	8.46	0001278027	0000014177	0001370544
2	Expenses	-3.31	-1.84	0.0320	0.634	0.883	0001307701	0000055067	0001273385
3	Revenues	-3.00	-1.24	0.207	2.14	2.41	0001307701	0000909954	0001007019
4	StockholdersEquity	-3.08	-2.47	0.0829	1.31	1.91	0001370544	0001029506	0001273385
5	NetIncome	-6.33	-1.33	0.274	0.764	1.04	0001307701	0000814586	0001368196
6	ComprehensiveNetIncome	-6.34	-1.34	0.272	0.759	1.04	0001307701	0000814586	0001368196
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000931336	0000014177
8	EconomicCapitalRatio	-9.38	-3.53	0.218	1.80	2.43	0001307701	0000057528	0001273385

2012

Logs

error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001477472 0001477472 0000785956
error	2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000034563 0000100493
warning	30 × No stock price available	subcommand.plot	0001331301 0001278027 0000944508 0000023666 0000042228 0000739608 0000909954 0001029506 0001052257 0001058330 0001099977 0001101020 0001273385 0001307701 0001320947 0001368196 0001420566 0001452011 0001467746 0001520358 0001545158 0001555365 0000055067 0000057528 0000931336 0001293593 0001452575 0000015357 0000088948 0000812128
warning	23 × Missing logo	subcommand.report	0001331301 0001278027 0000944508 0000023666 0000042228 0000739608 0000909954 0001029506 0001052257 0001058330 0001099977 0001101020 0001273385 0001307701 0001320947 0001368196 0001420566 0001421289 0001452011 0001467746 0001520358 0001545158 0001555365
warning	5 × Similarly named company. Duplicate?	None	0001331301 0000023666 0001101020 0001487197 0000730349
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001477472 0000040704
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.350636646357116}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because Expenses is zero	pre-agg	0000880117

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	IntangibleAssets	0	0	89,948,125	8,592,200,000	48,353,000,000	0000014177	0000057515	0001103982
1	AssetsCurrent	338	359,606	209,956,192	4,030,880,000	15,622,000,000	0001058330	0001530950	0001103982
2	PropertyPlantAndEquipment	0	10,423	146,952,267	3,854,000,000	10,010,000,000	0000730349	0001320947	0001103982
3	remainder_Assets	0	0	18,839,252	1,053,610,000	2,956,000,000	0000015357	0000814586	0001545158
4	LiabilitiesLongTerm	0	0	4,280	4,790,310,000	18,612,000,000	0000014177	0000100493	0001103982
5	LiabilitiesCurrent	0	147,684	118,176,311	3,677,160,000	14,873,000,000	0001307701	0000088948	0001103982
6	remainder_Liabilities	0	0	7,990,503	1,703,930,400	9,638,000,000	0000023666	0000814586	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	183,019,500	611,000,000	0000014177	0000055067	0000016732
8	SellingAndMarketingExpense	0	0	0	510,331,000	1,912,588,000	0000014177	0000088948	0000931336
9	remainder_Expenses	2,181	1,713,885	604,274,452	15,631,300,000	33,555,000,000	0001487197	0000880117	0001103982
10	remainder_Revenues	0	140,519	701,969,955	17,162,230,000	35,015,000,000	0001487197	0000880117	0001103982
11	remainder_NetIncome	-321,000,000	-74,170,700	0	51,420,000	1,595,000,000	0000100493	0001530950	0001103982
12	remainder_ComprehensiveNetIncome	-331,000,000	-77,000,000	0	6,444,000	75,000,000	0001103982	0000057515	0000055067

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	2,866	538,181	738,622,985	16,957,840,000	75,478,000,000	0001058330	0000088948	0001103982
1	Liabilities	22,676	624,495	217,181,038	8,844,020,000	43,123,000,000	0001487197	0001320947	0001103982
2	Expenses	345,880	2,685,004	677,955,415	15,631,300,000	33,555,000,000	0001487197	0000880117	0001103982
3	Revenues	0	140,519	701,969,955	17,162,230,000	35,015,000,000	0001487197	0000880117	0001103982
4	StockholdersEquity	-4,032,784	-731,027	354,708,111	8,131,150,000	32,355,000,000	0001052257	0000088948	0001103982
5	NetIncome	-86,336,000	-10,049,429	45,987,847	1,142,890,000	3,055,000,000	0001320947	0001368196	0001103982
6	ComprehensiveNetIncome	-86,336,000	-11,527,004	39,020,568	1,170,190,000	2,882,880,000	0001320947	0001530950	0001103982
7	BaseVar	676,924	4,979,472	2,276,829,968	52,886,371,950	132,968,820,000	0001487197	0001278027	0001103982
8	EconomicCapitalRatio	-36.4	-3.35	1.02	2.51	3.37	0001058330	0001452011	0001368196

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	IntangibleAssets	-18.7	-0.873	-0.167	0.861	1.25	0001058330	0001467746	0001331301
1	AssetsCurrent	-21.0	-0.539	-0.105	0.464	2.86	0001058330	0001320695	0001487197
2	PropertyPlantAndEquipment	-15.7	-0.554	-0.00127	0.323	0.844	0001058330	0000023217	0001063537
3	remainder_Assets	-6.38	-0.200	-0.0262	0.147	0.586	0001058330	0001099977	0001420566
4	LiabilitiesLongTerm	-11.4	-0.908	0.319	0.988	1.23	0001058330	0001117057	0001007019
5	LiabilitiesCurrent	-0.926	-0.568	0.117	0.866	23.6	0001421289	0001273385	0001058330
6	remainder_Liabilities	-9.86	-0.254	0.228	0.982	29.1	0001058330	0001467746	0001421289
7	GeneralAndAdministrativeExpense	-6.15	-1.01	0.245	0.777	1.34	0001421289	0001063537	0001058330
8	SellingAndMarketingExpense	-1.20	-0.752	0.112	0.397	0.683	0000034563	0000040704	0001058330
9	remainder_Expenses	-13.0	-2.42	-0.0551	0.895	2.63	0001058330	0000910406	0001421289
10	remainder_Revenues	-12.5	-1.56	0.204	2.16	3.44	0001058330	0000023217	0001007019
11	remainder_NetIncome	-8.69	-0.0599	0.0645	0.155	1.16	0001058330	0000098677	0000023666
12	remainder_ComprehensiveNetIncome	-0.161	-0.0350	0.00705	0.0205	0.0337	0000014177	0001421289	0001063537

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-29.2	-0.869	-0.0877	0.629	3.92	0001058330	0000023666	0001487197
1	Liabilities	-11.5	-0.933	0.436	1.90	6.73	0001058330	0000088948	0001421289
2	Expenses	-11.0	-2.08	0.00754	0.549	0.858	0001058330	0000023666	0001273385
3	Revenues	-12.5	-1.56	0.204	2.16	3.44	0001058330	0000023217	0001007019
4	StockholdersEquity	-6.61	-2.04	-0.133	1.21	2.06	0001058330	0000023666	0001487197
5	NetIncome	-32.2	-2.33	0.459	1.20	1.62	0001058330	0000098677	0000023666
6	ComprehensiveNetIncome	-32.2	-2.33	0.470	1.22	1.60	0001058330	0000098677	0000023666
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001029506	0000014177
8	EconomicCapitalRatio	-36.6	-3.55	0.826	2.31	3.18	0001058330	0001452011	0001368196

2013

Logs

error	6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001572386 0000034563 0000100493 0000100493 0000100493 0000100493
error	5 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001572386 0001167905 0001477472 0001563463 0001137005
warning	29 × No stock price available	subcommand.plot	0001278027 0000944508 0000023666 0000042228 0000739608 0000909954 0001052257 0001058330 0001273385 0001320947 0001331301 0001370544 0001431897 0001467746 0001520358 0001545158 0001555365 0001564822 0001565383 0001568139 0000055067 0000057528 0000931336 0001293593 0001452575 0000015357 0000076149 0000812128 0001091983
warning	20 × Missing logo	subcommand.report	0001278027 0000944508 0000023666 0000042228 0000739608 0000909954 0001052257 0001058330 0001273385 0001320947 0001331301 0001370544 0001431897 0001467746 0001520358 0001545158 0001555365 0001564822 0001565383 0001568139
warning	5 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001572386 0001167905 0001563463 0001137005 0000040704
warning	4 × Similarly named company. Duplicate?	None	0000023666 0001331301 0001091983 0000730349
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.118597663247636}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because Expenses is zero	pre-agg	0000880117
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005
warning	1 × Ignoring company because Assets is zero	pre-agg	0001555365

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	IntangibleAssets	0	0	73,305,020	11,688,900,000	47,591,000,000	0000014177	0000098677	0001103982
1	AssetsCurrent	0	17,232	240,342,720	4,339,350,000	13,216,000,000	0001565383	0000098677	0001103982
2	PropertyPlantAndEquipment	0	0	132,512,350	3,868,650,000	10,247,000,000	0000730349	0001320947	0001103982
3	remainder_Assets	0	0	22,286,385	1,218,000,000	2,620,000,000	0000015357	0000057528	0001545158
4	LiabilitiesLongTerm	0	0	935,006	5,599,500,000	16,973,000,000	0000014177	0001431897	0001103982
5	LiabilitiesCurrent	0	294,012	105,915,430	3,622,500,000	14,396,000,000	0001565383	0001278027	0001103982
6	remainder_Liabilities	0	0	8,088,387	2,768,050,000	8,886,900,000	0000023666	0001117057	0000023217
7	GeneralAndAdministrativeExpense	0	0	0	245,627,500	677,000,000	0000014177	0000057515	0000016732
8	SellingAndMarketingExpense	0	0	0	602,765,000	1,337,745,000	0000014177	0000812128	0000931336
9	remainder_Expenses	0	139,330	495,397,375	15,122,900,000	31,418,000,000	0001370544	0000098677	0001103982
10	remainder_Revenues	0	1,643	725,668,195	16,632,750,000	35,299,000,000	0001565383	0001278027	0001103982
11	remainder_NetIncome	-221,000,000	-70,805,000	0	57,750,000	646,236,000	0000016732	0001128928	0000931336
12	remainder_ComprehensiveNetIncome	-243,000,000	-34,628,000	0	158,250,000	283,046,000	0001103982	0000076149	0001128928

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	1,128	33,254	888,590,180	21,531,650,000	72,557,000,000	0001370544	0000098677	0001103982
1	Liabilities	2,229	500,452	291,287,595	14,802,150,000	40,025,000,000	0001565383	0001320947	0001103982
2	Expenses	26,431	478,177	495,397,375	15,122,900,000	31,418,000,000	0001565383	0000098677	0001103982
3	Revenues	0	1,643	725,668,195	16,632,750,000	35,299,000,000	0001565383	0001278027	0001103982
4	StockholdersEquity	-5,364,509	-497,282	379,185,120	6,729,500,000	32,532,000,000	0001370544	0001278027	0001103982
5	NetIncome	-163,232,000	-21,991,968	22,321,233	2,285,100,000	3,935,000,000	0001320947	0001273385	0001103982
6	ComprehensiveNetIncome	-163,213,800	-21,053,803	23,952,503	2,316,144,000	3,808,640,000	0001320947	0001273385	0001103982
7	BaseVar	43,291	2,022,648	2,675,419,842	51,782,930,250	126,320,630,000	0001565383	0000057515	0001103982
8	EconomicCapitalRatio	-10.4	-4.12	0.910	2.66	6.96	0001052257	0001320695	0001128928

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	IntangibleAssets	-3.98	-1.04	-0.0810	0.931	1.14	0001052257	0000944508	0001278027
1	AssetsCurrent	-1.86	-0.832	-0.0613	0.360	0.829	0001052257	0001320695	0001520358
2	PropertyPlantAndEquipment	-0.773	-0.608	-0.000603	0.453	1.55	0001091983	0000057515	0001052257
3	remainder_Assets	-0.922	-0.482	-0.0819	0.415	24.8	0001052257	0001331301	0001565383
4	LiabilitiesLongTerm	-1.59	-0.977	0.0280	1.16	1.41	0001052257	0000023217	0000931336
5	LiabilitiesCurrent	-1.40	-0.336	0.261	1.21	15.8	0001052257	0000023666	0001058330
6	remainder_Liabilities	-1.41	-0.211	0.257	0.987	1.26	0001052257	0000944508	0000931336
7	GeneralAndAdministrativeExpense	-4.82	-1.14	0.171	0.530	0.862	0001487197	0000091419	0001007019
8	SellingAndMarketingExpense	-3.33	-0.842	0.0956	0.296	0.480	0001091983	0000091419	0001007019
9	remainder_Expenses	-3.91	-2.28	0.0216	1.45	3.71	0001007019	0000910406	0001091983
10	remainder_Revenues	-4.44	-1.85	0.262	2.54	3.47	0001052257	0000057528	0001007019
11	remainder_NetIncome	-4.27	-0.0707	0.0493	0.160	0.905	0001052257	0001128928	0000931336
12	remainder_ComprehensiveNetIncome	-0.0575	-0.0397	-0.0126	0.0446	0.227	0001046257	0001320947	0000014177

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-4.77	-1.69	-0.0247	0.825	3.41	0001052257	0001046257	0001565383
1	Liabilities	-3.19	-0.777	0.493	2.38	6.71	0001052257	0001487197	0001058330
2	Expenses	-2.86	-2.45	0.0339	0.588	2.74	0001052257	0000944508	0001128928
3	Revenues	-4.44	-1.85	0.262	2.54	3.47	0001052257	0000057528	0001007019
4	StockholdersEquity	-2.96	-1.92	0.117	1.31	2.12	0001058330	0001564822	0001273385
5	NetIncome	-11.6	-3.22	0.456	1.38	5.32	0001052257	0001117057	0001128928
6	ComprehensiveNetIncome	-11.6	-3.23	0.455	1.35	5.51	0001052257	0000040704	0001128928
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001046257	0000014177
8	EconomicCapitalRatio	-11.0	-4.71	0.315	2.07	6.37	0001052257	0001320695	0001128928

2014

Logs

error	7 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001572386 0000034563 0000100493 0000100493 0000100493 0000100493 0000100493
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001563463
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001593001
error	1 × Negative Expenses, ignoring company.	pre-agg	0001137005
warning	16 × Missing logo	subcommand.report	0000944508 0000023666 0000042228 0000739608 0000909954 0001052257 0001058330 0001273385 0001320947 0001331301 0001334586 0001431897 0001451433 0001545158 0001564822 0001565383
warning	5 × Ignoring company because Assets is zero	pre-agg	0000042228 0001555365 0001555365 0001555365 0001555365
warning	4 × Similarly named company. Duplicate?	None	0000023666 0001331301 0001091983 0000730349
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001563463 0000785956 0000040704 0001593001
warning	3 × Ignoring company because Expenses is zero	pre-agg	0000880117 0000880117 0000880117
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001137005 0001568139
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.556990421949096}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	26,806,373	12,859,290,000	43,724,000,000	0000014177	0000802481	0001103982
1	AssetsCurrent	0	629,141	249,444,136	4,344,690,000	11,750,000,000	0001565383	0000880117	0001103982
2	PropertyPlantAndEquipment	0	19,549	130,460,610	3,902,900,000	9,827,000,000	0000785956	0000880117	0001103982
3	remainder_Assets	0	0	14,787,738	916,584,100	2,159,770,000	0000015357	0000880117	0001564822
4	LiabilitiesLongTerm	0	0	4,163	6,850,560,000	16,005,000,000	0000014177	0000076149	0001103982
5	LiabilitiesCurrent	0	1,046,474	91,506,995	4,237,800,000	14,007,000,000	0001565383	0001117057	0001103982
6	remainder_Liabilities	0	0	3,918,599	3,890,600,000	8,950,000,000	0000023666	0000042228	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	249,758,700	573,000,000	0000014177	0000076149	0000016732
8	SellingAndMarketingExpense	0	0	0	615,561,900	1,355,053,000	0000014177	0000057515	0000931336
9	remainder_Expenses	32,539	1,362,467	496,103,810	16,792,800,000	31,355,000,000	0001565383	0001331301	0001103982
10	remainder_Revenues	0	69,636	544,606,446	17,847,500,000	34,244,000,000	0001565383	0000098677	0001103982
11	remainder_NetIncome	-688,000,000	-83,373,600	-100,094	28,904,910	118,200,000	0001103982	0000015357	0000040704
12	remainder_ComprehensiveNetIncome	-4,446,000,000	-170,200,000	0	42,360,000	245,000,000	0001103982	0001451433	0000040704

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	4,353	732,903	551,087,556	21,872,820,000	66,815,000,000	0001565383	0001293593	0001103982
1	Liabilities	10,008	1,332,601	147,651,919	14,812,700,000	38,962,000,000	0001565383	0000812128	0001103982
2	Expenses	32,539	2,813,464	625,517,948	16,792,800,000	31,355,000,000	0001565383	0001331301	0001103982
3	Revenues	0	69,636	544,606,446	17,847,500,000	34,244,000,000	0001565383	0000098677	0001103982
4	StockholdersEquity	-1,620,752	-355,666	226,892,927	5,257,520,000	27,853,000,000	0001058330	0000880117	0001103982
5	NetIncome	-343,200,000	-100,290,705	15,323,182	984,173,600	2,201,000,000	0001530950	0001431897	0001103982
6	ComprehensiveNetIncome	-350,740,000	-123,241,876	15,309,693	836,030,400	1,951,800,000	0001530950	0001431897	0000040704
7	BaseVar	41,184	6,051,668	1,741,930,378	54,648,003,950	126,804,485,000	0001565383	0001331301	0001103982
8	EconomicCapitalRatio	-10.5	-4.56	0.905	2.57	3.17	0001565383	0000063754	0001273385

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	IntangibleAssets	-2.66	-1.01	-0.115	0.868	1.22	0001565383	0000047111	0001530950
1	AssetsCurrent	-3.83	-1.21	-0.0971	0.321	2.28	0001565383	0000047111	0001487197
2	PropertyPlantAndEquipment	-2.23	-0.810	-0.00292	0.376	0.816	0001565383	0001530950	0001063537
3	remainder_Assets	-0.613	-0.345	-0.0422	0.419	4.02	0001451433	0000023666	0001565383
4	LiabilitiesLongTerm	-1.06	-0.831	0.0438	1.01	1.19	0001565383	0001117057	0000812128
5	LiabilitiesCurrent	-1.53	-0.283	0.277	0.940	10.0	0001565383	0000944508	0001058330
6	remainder_Liabilities	-0.851	-0.293	0.110	0.727	11.9	0000023217	0001052257	0001565383
7	GeneralAndAdministrativeExpense	-2.98	-0.835	0.150	0.440	0.504	0001091983	0000098677	0000812128
8	SellingAndMarketingExpense	-7.15	-0.943	0.118	0.374	0.428	0001091983	0000091419	0000812128
9	remainder_Expenses	-5.54	-1.72	0.0132	0.985	7.90	0001565383	0001334586	0001091983
10	remainder_Revenues	-3.87	-1.64	0.0566	2.83	4.39	0001565383	0000023217	0001091983
11	remainder_NetIncome	-1.34	-0.717	0.00619	0.0502	4.18	0001334586	0001058330	0000076149
12	remainder_ComprehensiveNetIncome	-0.0885	-0.0643	0.00491	0.0445	0.0842	0001103982	0000016732	0000034563

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-5.11	-1.77	-0.0383	0.659	2.45	0001565383	0001452575	0001487197
1	Liabilities	-1.06	-0.881	0.550	1.99	6.25	0001530950	0001451433	0001058330
2	Expenses	-4.99	-1.82	0.0717	0.580	0.904	0001565383	0001046257	0001273385
3	Revenues	-3.87	-1.64	0.0566	2.83	4.39	0001565383	0000023217	0001091983
4	StockholdersEquity	-3.45	-2.67	-0.173	1.32	2.14	0001091983	0001063537	0001273385
5	NetIncome	-8.85	-3.15	0.592	1.85	2.05	0001565383	0000014177	0001091983
6	ComprehensiveNetIncome	-8.84	-3.14	0.584	1.86	2.01	0001565383	0000063754	0000785956
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000931336	0000014177
8	EconomicCapitalRatio	-11.0	-5.02	0.438	2.10	2.71	0001565383	0000063754	0001273385

2015

Logs

error	6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001572386 0000034563 0000100493 0000100493 0000100493 0000100493
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000042228 0001489902
error	1 × Negative Expenses, ignoring company.	pre-agg	0001137005
warning	23 × No stock price available	subcommand.plot	0000040704 0001568139 0000944508 0000909954 0001052257 0001320947 0001334586 0001451433 0000016732 0000063754 0000910406 0000931336 0001063537 0001293593 0001452575 0001609989 0000015357 0000076149 0000088948 0000812128 0001091983 0001409446 0001611647
warning	7 × Missing logo	subcommand.report	0001568139 0000944508 0000909954 0001052257 0001320947 0001334586 0001451433
warning	6 × Ignoring company because Assets is zero	pre-agg	0000042228 0001555365 0001555365 0001555365 0001555365 0001555365
warning	5 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001568139 0001568139 0001568139 0001568139 0001137005
warning	5 × Ignoring company because Expenses is zero	pre-agg	0000880117 0000880117 0000880117 0000880117 0000880117
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000042228 0001624982 0000040704
warning	2 × Similarly named company. Duplicate?	None	0001091983 0001487197
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -8.276392467070648}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001568139

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	IntangibleAssets	0	0	38,050,464	12,960,100,000	39,432,000,000	0000014177	0000944508	0001103982
1	AssetsCurrent	0	1,304	326,847,860	3,667,700,000	8,958,000,000	0001624517	0000785956	0001103982
2	PropertyPlantAndEquipment	0	0	172,318,112	3,608,100,000	8,362,000,000	0001409446	0000057515	0001103982
3	remainder_Assets	0	0	17,623,608	843,600,000	6,091,000,000	0000015357	0001320695	0001103982
4	LiabilitiesLongTerm	0	0	900	6,036,300,000	16,389,000,000	0000014177	0000076149	0001103982
5	LiabilitiesCurrent	8,290	165,625	97,150,924	3,310,200,000	10,922,000,000	0001624517	0000785956	0001103982
6	remainder_Liabilities	0	0	3,290,280	3,122,100,000	7,432,000,000	0000057515	0001609989	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	287,591,000	593,000,000	0000014177	0000088948	0000016732
8	SellingAndMarketingExpense	0	0	0	641,800,000	1,379,317,000	0000014177	0000098677	0000931336
9	remainder_Expenses	15,000	434,799	791,338,988	16,230,000,000	27,376,000,000	0001624517	0000785956	0001103982
10	remainder_Revenues	0	3,996	864,613,364	15,832,400,000	29,636,000,000	0001568139	0001320947	0001103982
11	remainder_NetIncome	-135,912,000	-92,500,000	-740	46,200,000	5,031,000,000	0000047111	0001593001	0001103982
12	remainder_ComprehensiveNetIncome	-2,692,000,000	-340,000,000	-46,470	134,000	3,563,000	0001103982	0001091983	0000802481

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	2,172	102,609	715,055,964	17,542,200,000	62,843,000,000	0001624517	0000057515	0001103982
1	Liabilities	52,946	289,857	166,135,908	12,932,200,000	34,743,000,000	0001624517	0000944508	0001103982
2	Expenses	76,094	434,799	831,480,216	16,230,000,000	27,376,000,000	0001624517	0001320947	0001103982
3	Revenues	0	3,996	864,613,364	15,832,400,000	29,636,000,000	0001568139	0001320947	0001103982
4	StockholdersEquity	-592,500,000	-1,455,688	220,462,872	6,171,600,000	28,100,000,000	0001452575	0001005286	0001103982
5	NetIncome	-240,800,000	-23,976,431	13,731,868	691,000,000	7,291,000,000	0000023217	0001005286	0001103982
6	ComprehensiveNetIncome	-348,440,000	-23,976,431	12,967,385	647,814,760	5,891,160,000	0000023217	0000014177	0001103982
7	BaseVar	107,077	862,864	2,395,278,935	49,122,579,000	116,441,075,000	0001624517	0000785956	0001103982
8	EconomicCapitalRatio	-17.5	-8.28	0.525	2.43	2.74	0001052257	0000040704	0000057515

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	IntangibleAssets	-6.04	-3.07	-0.140	0.919	1.59	0001052257	0000047111	0001568139
1	AssetsCurrent	-6.24	-2.51	-0.0591	0.463	3.45	0001052257	0001320947	0001487197
2	PropertyPlantAndEquipment	-4.10	-2.29	-0.00440	0.229	0.613	0001052257	0000076149	0001063537
3	remainder_Assets	-1.98	-0.547	-0.0479	0.303	1.61	0001052257	0000910406	0001409446
4	LiabilitiesLongTerm	-3.25	-1.06	-0.148	1.03	1.12	0001052257	0001451433	0000812128
5	LiabilitiesCurrent	-0.850	-0.164	0.339	2.10	10.8	0001293593	0001320695	0001409446
6	remainder_Liabilities	-2.33	-1.01	0.185	0.877	14.2	0001052257	0001063537	0001624517
7	GeneralAndAdministrativeExpense	-4.34	-1.44	0.241	0.531	0.729	0001624517	0000023217	0001052257
8	SellingAndMarketingExpense	-6.67	-1.31	0.128	0.309	0.424	0001091983	0000040704	0001052257
9	remainder_Expenses	-5.98	-1.52	-0.0223	1.52	7.64	0001409446	0000023217	0001091983
10	remainder_Revenues	-5.57	-2.52	0.228	2.50	4.93	0001052257	0000063754	0001091983
11	remainder_NetIncome	-12.5	-0.471	0.182	0.346	0.590	0001052257	0000909954	0001091983
12	remainder_ComprehensiveNetIncome	-0.143	-0.0597	0.0213	0.0590	0.0919	0000034563	0001624517	0001091983

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-11.2	-5.21	0.00128	0.775	2.97	0001052257	0000057515	0001487197
1	Liabilities	-2.04	-0.977	0.395	2.35	7.82	0001052257	0000098677	0001624517
2	Expenses	-5.26	-3.17	0.127	0.680	4.00	0001409446	0000944508	0001052257
3	Revenues	-5.57	-2.52	0.228	2.50	4.93	0001052257	0000063754	0001091983
4	StockholdersEquity	-3.05	-2.74	0.0188	1.39	1.60	0001624517	0000088948	0001611647
5	NetIncome	-14.1	-5.25	0.830	2.21	2.77	0001052257	0000910406	0001091983
6	ComprehensiveNetIncome	-14.1	-5.23	0.817	2.26	2.86	0001052257	0000098677	0001091983
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000944508	0000014177
8	EconomicCapitalRatio	-17.0	-7.73	1.07	2.98	3.29	0001052257	0000040704	0000057515

2016

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001572386 0000034563 0000100493 0000100493 0000100493
error	2 × Negative Expenses, ignoring company.	pre-agg	0001568139 0001137005
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001278027
warning	19 × No stock price available	subcommand.plot	0001568139 0000944508 0000042228 0000859747 0001052257 0000055067 0000057528 0000931336 0001293593 0001452575 0001609989 0001669792 0000015357 0000076149 0000088948 0000812128 0000949852 0001091983 0001137005
warning	7 × Ignoring company because Expenses is zero	pre-agg	0000802481 0000880117 0000880117 0000880117 0000880117 0000880117 0000880117
warning	6 × Ignoring company because Assets is zero	pre-agg	0001278027 0001555365 0001555365 0001555365 0001555365 0000042228
warning	5 × Missing logo	subcommand.report	0001568139 0000944508 0000042228 0000859747 0001052257
warning	4 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001568139 0001568139 0001568139 0001137005
warning	3 × Similarly named company. Duplicate?	None	0001091983 0001487197 0000730349
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001278027 0001637459 0001572386
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -5.457029327494704}
warning	1 × Negative minimum value	check_abs_values	{'var_name': 'LiabilitiesLongTerm', 'min_value': -38004}
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001568139

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	IntangibleAssets	0	0	12,628,938	10,909,400,000	38,377,000,000	0000014177	0001117057	0001103982
1	AssetsCurrent	0	10,964	299,575,867	3,865,100,000	8,480,000,000	0001137005	0000098677	0001103982
2	PropertyPlantAndEquipment	0	1,023	169,644,764	3,708,680,000	8,229,000,000	0000859747	0000057515	0001103982
3	remainder_Assets	0	0	16,999,799	1,003,940,000	6,452,000,000	0000015357	0001117057	0001103982
4	LiabilitiesLongTerm	-38,004	0	0	4,663,800,000	14,789,000,000	0000949852	0000057515	0001103982
5	LiabilitiesCurrent	88,640	319,825	99,044,193	4,131,600,000	14,417,000,000	0000015357	0001609989	0001103982
6	remainder_Liabilities	0	0	1,571,309	1,264,980,000	7,117,000,000	0000055067	0001063537	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	280,860,400	641,000,000	0000014177	0000812128	0000016732
8	SellingAndMarketingExpense	0	0	0	582,550,600	1,348,349,000	0000014177	0000040704	0000931336
9	remainder_Expenses	16,125	375,073	459,702,232	14,501,920,000	34,874,000,000	0001137005	0000098677	0000100493
10	remainder_Revenues	0	0	541,113,445	15,853,280,000	36,881,000,000	0000047111	0001005286	0000100493
11	remainder_NetIncome	-1,321,900,000	-262,440,000	-77,687	33,339,600	1,099,481,000	0000023217	0001063537	0000047111
12	remainder_ComprehensiveNetIncome	-1,146,000,000	-186,096,000	0	25,663,400	64,000,000	0001103982	0000944508	0000016732

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	5,113	149,401	651,083,687	20,392,040,000	61,538,000,000	0001137005	0001609989	0001103982
1	Liabilities	244,547	338,283	186,494,530	8,947,040,000	36,323,000,000	0000015357	0000034563	0001103982
2	Expenses	187,725	452,471	459,702,232	14,501,920,000	34,874,000,000	0000859747	0000098677	0000100493
3	Revenues	0	0	541,113,445	15,853,280,000	36,881,000,000	0000047111	0001005286	0000100493
4	StockholdersEquity	-472,100,000	-7,363,666	146,497,526	9,740,140,000	25,215,000,000	0001452575	0001609989	0001103982
5	NetIncome	-665,900,000	-115,138,664	7,800,505	1,479,208,800	1,772,000,000	0000023217	0000014177	0000100493
6	ComprehensiveNetIncome	-679,472,000	-114,343,648	5,449,130	1,001,967,048	1,793,320,000	0000023217	0000014177	0000100493
7	BaseVar	393,513	1,230,673	1,599,514,451	49,140,886,200	102,563,035,000	0000859747	0000098677	0001103982
8	EconomicCapitalRatio	-13.8	-5.46	0.811	2.49	2.87	0001137005	0000063754	0000057515

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	IntangibleAssets	-3.42	-1.38	-0.184	0.876	1.10	0001137005	0001005286	0001568139
1	AssetsCurrent	-4.46	-1.09	-0.0587	0.463	5.14	0001137005	0000023217	0001487197
2	PropertyPlantAndEquipment	-3.36	-0.941	-0.0249	0.409	0.797	0001137005	0000814586	0001611647
3	remainder_Assets	-1.19	-0.507	-0.0390	0.231	0.311	0001137005	0000057528	0000098677
4	LiabilitiesLongTerm	-1.87	-1.09	0.0884	1.07	1.12	0001137005	0001091983	0000015357
5	LiabilitiesCurrent	-0.507	-0.319	0.591	4.24	14.8	0000944508	0001046257	0001137005
6	remainder_Liabilities	-1.14	-0.549	0.121	0.665	0.812	0001137005	0000042228	0000859747
7	GeneralAndAdministrativeExpense	-10.4	-1.95	0.271	0.694	0.851	0001137005	0000023217	0000042228
8	SellingAndMarketingExpense	-3.40	-0.958	0.103	0.264	0.324	0001091983	0000023217	0000042228
9	remainder_Expenses	-4.16	-2.18	-0.202	1.61	4.17	0001593001	0000015357	0001137005
10	remainder_Revenues	-4.17	-1.82	0.342	2.74	2.79	0001137005	0000910406	0000931336
11	remainder_NetIncome	-3.22	-0.195	0.127	0.305	0.917	0001409446	0001063537	0000859747
12	remainder_ComprehensiveNetIncome	-0.0675	-0.0281	0.00370	0.0196	0.126	0000014177	0001593001	0001063537

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-8.10	-2.67	-0.0396	0.889	3.16	0001137005	0000100493	0001487197
1	Liabilities	-1.47	-0.770	0.696	2.46	3.75	0000047111	0000055067	0001137005
2	Expenses	-6.03	-1.58	-0.00888	0.701	1.77	0001137005	0000014177	0001409446
3	Revenues	-4.17	-1.82	0.342	2.74	2.79	0001137005	0000910406	0000931336
4	StockholdersEquity	-3.32	-2.43	0.260	1.53	2.02	0001137005	0000014177	0001487197
5	NetIncome	-10.00	-3.18	0.716	1.87	1.99	0001137005	0001611647	0000057515
6	ComprehensiveNetIncome	-9.99	-3.18	0.720	1.87	1.99	0001137005	0001611647	0000057515
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000931336	0000014177
8	EconomicCapitalRatio	-13.7	-5.39	0.874	2.55	2.94	0001137005	0000063754	0000057515

2017

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001572386 0000034563 0000100493 0000100493 0000100493
error	2 × Negative Expenses, ignoring company.	pre-agg	0001137005 0001568139
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001572386
warning	12 × Ignoring company because Expenses is zero	pre-agg	0000802481 0000802481 0000802481 0000802481 0000880117 0000880117 0000880117 0000880117 0000880117 0000880117 0000880117 0001568139
warning	10 × No stock price available	subcommand.plot	0000055067 0000057528 0000931336 0001609989 0000015357 0000076149 0000812128 0000949852 0001091983 0001137005
warning	8 × Ignoring company because Assets is zero	pre-agg	0001278027 0001278027 0001278027 0001278027 0000042228 0001555365 0001555365 0001555365
warning	3 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001137005 0001568139 0001568139
warning	2 × Similarly named company. Duplicate?	None	0001487197 0000730349
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.2139970669295574}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	54,845,449	13,735,480,000	39,724,000,000	0000014177	0001005286	0001103982
1	AssetsCurrent	0	91,397	301,436,470	4,500,720,000	7,520,000,000	0001137005	0000057515	0001103982
2	PropertyPlantAndEquipment	0	1,812	180,839,876	4,086,400,000	8,677,000,000	0001409446	0000057515	0001103982
3	remainder_Assets	0	0	52,585,846	1,000,600,000	7,188,000,000	0000015357	0000910406	0001103982
4	LiabilitiesLongTerm	0	0	0	7,814,720,000	15,661,000,000	0000014177	0000055067	0001103982
5	LiabilitiesCurrent	110,299	485,702	97,345,397	4,649,360,000	15,793,000,000	0000015357	0000034563	0001103982
6	remainder_Liabilities	0	0	516,416	1,929,360,000	5,464,000,000	0000055067	0000730349	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	302,555,200	488,000,000	0000014177	0000063754	0000016732
8	SellingAndMarketingExpense	0	0	0	485,240,000	1,346,948,000	0000014177	0000076149	0000931336
9	remainder_Expenses	0	785,757	524,195,280	15,844,960,000	36,179,000,000	0001137005	0001005286	0000100493
10	remainder_Revenues	0	3,589	543,453,806	17,675,040,000	38,260,000,000	0000047111	0000034563	0000100493
11	remainder_NetIncome	-303,000,000	-116,940,000	0	118,000,000	1,110,668,000	0000100493	0001487197	0000047111
12	remainder_ComprehensiveNetIncome	-23,368,000	-603,200	1,419,089	253,700,000	1,110,000,000	0000910406	0001117057	0001103982

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	727	91,704	848,653,111	23,063,280,000	63,109,000,000	0001409446	0001609989	0001103982
1	Liabilities	221,634	499,252	177,671,348	10,512,920,000	36,918,000,000	0000015357	0000034563	0001103982
2	Expenses	53,195	788,221	524,667,734	15,844,960,000	36,179,000,000	0001137005	0001005286	0000100493
3	Revenues	0	3,589	543,453,806	17,675,040,000	38,260,000,000	0000047111	0000034563	0000100493
4	StockholdersEquity	-10,791,296	-2,175,853	640,120,479	14,303,600,000	26,191,000,000	0001117057	0000057515	0001103982
5	NetIncome	-286,200,000	-22,790,303	55,464,126	1,716,480,000	2,936,000,000	0001320695	0000910329	0001103982
6	ComprehensiveNetIncome	-265,504,000	-22,642,860	55,457,068	1,820,038,400	3,513,200,000	0001320695	0000910329	0001103982
7	BaseVar	373,254	2,255,207	2,692,584,786	59,138,992,600	102,863,330,000	0001137005	0000785956	0001103982
8	EconomicCapitalRatio	-7.31	-3.21	1.18	2.77	2.88	0001593001	0000057528	0000910329

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	IntangibleAssets	-1.60	-0.936	-0.0428	0.807	1.00	0001593001	0000076149	0000063754
1	AssetsCurrent	-0.961	-0.458	-0.0572	0.342	1.41	0001091983	0001117057	0001487197
2	PropertyPlantAndEquipment	-1.44	-0.391	-0.00865	0.455	0.897	0001593001	0000814586	0001117057
3	remainder_Assets	-0.443	-0.319	-0.0210	0.143	0.318	0001593001	0000100493	0000098677
4	LiabilitiesLongTerm	-1.32	-0.837	0.404	1.00	1.05	0001530950	0000055067	0000931336
5	LiabilitiesCurrent	-3.01	-0.190	0.575	2.02	6.89	0001409446	0001046257	0001593001
6	remainder_Liabilities	-0.502	-0.369	0.143	0.639	0.688	0000023217	0001320695	0000931336
7	GeneralAndAdministrativeExpense	-5.54	-1.03	0.259	0.626	0.842	0001487197	0000785956	0000949852
8	SellingAndMarketingExpense	-1.79	-1.06	0.0974	0.284	0.382	0001091983	0000098677	0000949852
9	remainder_Expenses	-3.24	-1.75	-0.343	1.44	2.39	0000949852	0000785956	0001091983
10	remainder_Revenues	-6.16	-2.12	0.529	2.64	2.89	0001409446	0000076149	0000931336
11	remainder_NetIncome	-1.27	-1.08	-0.0599	0.461	10.3	0001593001	0001005286	0001409446
12	remainder_ComprehensiveNetIncome	-0.0477	-0.0431	-0.0135	0.0764	0.176	0000949852	0000785956	0001063537

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-3.14	-1.11	0.0162	0.754	1.08	0001593001	0000057515	0000047111
1	Liabilities	-1.51	-0.853	0.956	2.27	3.43	0000047111	0001063537	0001593001
2	Expenses	-3.13	-2.02	-0.118	0.520	0.817	0001487197	0000076149	0000047111
3	Revenues	-6.16	-2.12	0.529	2.64	2.89	0001409446	0000076149	0000931336
4	StockholdersEquity	-4.10	-2.50	0.306	1.34	1.73	0001409446	0000034563	0000076149
5	NetIncome	-5.25	-2.71	0.407	1.21	4.69	0001487197	0000814586	0001409446
6	ComprehensiveNetIncome	-5.27	-2.70	0.396	1.18	4.65	0001487197	0000949852	0001409446
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000910329	0000014177
8	EconomicCapitalRatio	-8.11	-4.01	0.383	1.97	2.08	0001593001	0000057528	0000910329

2018

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000034563 0000100493 0000100493 0000100493 0001572386
error	2 × Negative Expenses, ignoring company.	pre-agg	0001568139 0001137005
warning	15 × Ignoring company because Expenses is zero	pre-agg	0000802481 0000802481 0000802481 0000802481 0000802481 0000880117 0000880117 0000880117 0000880117 0000880117 0000880117 0001568139 0001568139 0001568139 0001568139
warning	12 × No stock price available	subcommand.plot	0000055067 0000931336 0001644406 0001730773 0000015357 0000076149 0000812128 0000949852 0001563463 0001612188 0001619055 0001725911
warning	9 × Ignoring company because Assets is zero	pre-agg	0001278027 0001278027 0001278027 0001278027 0001278027 0000042228 0001555365 0001555365 0001555365
warning	3 × Similarly named company. Duplicate?	None	0001487197 0001644406 0000730349
warning	3 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001568139 0001568139 0001137005
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111 0000949852
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.605754480497841}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	11,683,769	16,999,210,000	38,727,000,000	0000014177	0001619055	0001103982
1	AssetsCurrent	0	140,075	173,992,526	4,280,130,000	7,604,000,000	0001612188	0000034563	0001103982
2	PropertyPlantAndEquipment	0	0	186,102,854	4,259,380,000	8,482,000,000	0001409446	0000098677	0001103982
3	remainder_Assets	0	0	15,756,128	1,145,840,000	7,916,000,000	0000015357	0000014177	0001103982
4	LiabilitiesLongTerm	0	0	0	9,111,270,000	15,155,000,000	0000014177	0001730773	0001103982
5	LiabilitiesCurrent	220,246	423,591	93,655,426	5,262,090,000	16,737,000,000	0000015357	0001005286	0001103982
6	remainder_Liabilities	0	0	14,681	2,126,570,000	5,124,000,000	0000055067	0001563463	0001103982
7	GeneralAndAdministrativeExpense	0	0	0	277,893,100	654,000,000	0000014177	0000098677	0000016732
8	SellingAndMarketingExpense	0	0	0	430,760,000	1,403,178,000	0000014177	0000023217	0000931336
9	remainder_Expenses	9,119	1,110,523	446,767,932	14,630,790,000	36,715,000,000	0001612188	0000910329	0000100493
10	remainder_Revenues	0	2,930	518,940,167	16,760,160,000	40,052,000,000	0000047111	0000098677	0000100493
11	remainder_NetIncome	-310,000,000	-78,547,200	4,655	176,000,000	1,410,061,000	0000100493	0000949852	0000047111
12	remainder_ComprehensiveNetIncome	-647,000,000	-72,200,000	0	21,405,100	117,100,000	0001103982	0000015357	0000023217

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	7,020	359,411	476,781,048	29,260,500,000	62,729,000,000	0001409446	0000034563	0001103982
1	Liabilities	252,499	427,221	118,029,120	14,175,940,000	37,016,000,000	0000015357	0000785956	0001103982
2	Expenses	20,694	1,110,523	464,984,874	14,630,790,000	36,715,000,000	0001612188	0000098677	0000100493
3	Revenues	0	2,930	518,940,167	16,760,160,000	40,052,000,000	0000047111	0000098677	0000100493
4	StockholdersEquity	-2,658,954	-833,994	254,303,016	14,333,700,000	25,713,000,000	0001593001	0001005286	0001103982
5	NetIncome	-327,358,000	-22,592,000	9,721,121	2,249,400,000	3,395,000,000	0000931336	0000910406	0001103982
6	ComprehensiveNetIncome	-328,861,840	-24,698,728	14,859,658	2,299,793,200	3,058,560,000	0000931336	0001117057	0001103982
7	BaseVar	885,924	2,755,217	1,603,159,627	61,896,082,050	102,895,800,000	0001612188	0000098677	0001103982
8	EconomicCapitalRatio	-9.81	-2.61	1.01	2.54	3.02	0001593001	0001644406	0001117057

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	IntangibleAssets	-2.84	-1.13	-0.0956	0.818	1.40	0001593001	0000076149	0001644406
1	AssetsCurrent	-2.31	-0.654	-0.0580	0.471	0.565	0001593001	0000100493	0001725911
2	PropertyPlantAndEquipment	-2.07	-0.582	-0.00656	0.325	0.721	0001593001	0000076149	0001063537
3	remainder_Assets	-0.998	-0.396	-0.0315	0.135	1.09	0001593001	0000063754	0001612188
4	LiabilitiesLongTerm	-1.20	-0.932	0.400	0.981	1.10	0001530950	0000034563	0000910329
5	LiabilitiesCurrent	-2.13	-0.374	0.487	2.65	12.9	0001612188	0000910406	0001409446
6	remainder_Liabilities	-0.645	-0.413	0.0934	0.464	0.536	0000023217	0001320695	0000910329
7	GeneralAndAdministrativeExpense	-2.68	-1.41	0.128	0.383	0.497	0001563463	0000098677	0000949852
8	SellingAndMarketingExpense	-1.77	-0.826	0.0700	0.204	0.265	0000931336	0000023217	0000949852
9	remainder_Expenses	-4.45	-2.02	-0.153	0.817	1.54	0001593001	0000910406	0001487197
10	remainder_Revenues	-2.96	-1.42	0.297	2.72	3.19	0001593001	0000055067	0000931336
11	remainder_NetIncome	-2.15	-0.192	-0.0337	0.386	2.68	0001409446	0000076149	0001117057
12	remainder_ComprehensiveNetIncome	-0.295	-0.0118	0.00995	0.0281	0.0643	0001117057	0001128928	0000014177

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-5.59	-2.15	-0.0421	0.766	1.06	0001593001	0001320695	0000047111
1	Liabilities	-2.28	-0.874	0.586	2.51	7.20	0001612188	0000098677	0001409446
2	Expenses	-4.10	-2.80	-0.315	0.834	1.52	0001593001	0000785956	0001117057
3	Revenues	-2.96	-1.42	0.297	2.72	3.19	0001593001	0000055067	0000931336
4	StockholdersEquity	-3.25	-1.83	0.130	1.24	1.62	0001593001	0000023217	0000076149
5	NetIncome	-7.10	-2.63	0.256	1.04	2.80	0001593001	0001103982	0001117057
6	ComprehensiveNetIncome	-7.09	-2.61	0.247	1.06	2.50	0001593001	0001103982	0001117057
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000931336	0000014177
8	EconomicCapitalRatio	-10.5	-3.25	0.367	1.90	2.38	0001593001	0001644406	0001117057

2019

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000034563 0000100493 0000100493 0000100493 0001572386
error	2 × Negative Expenses, ignoring company.	pre-agg	0001568139 0001137005
warning	31 × No stock price available	subcommand.plot	0001611647 0001117057 0000014177 0000023217 0000034563 0000047111 0000057515 0000098677 0000785956 0000910329 0000931336 0000949852 0001005286 0001046257 0001103982 0001530950 0001644406 0001725911 0001730773 0000015357 0000812128 0000730349 0000814586 0000880117 0001007019 0001487197 0001572386 0001593001 0001612188 0001655210 0001741231
warning	12 × Ignoring company because Expenses is zero	pre-agg	0000802481 0000802481 0000802481 0000802481 0001568139 0001568139 0001568139 0000880117 0000880117 0000880117 0000880117 0000880117
warning	9 × Ignoring company because Assets is zero	pre-agg	0001278027 0001278027 0001278027 0001278027 0001117057 0000042228 0001555365 0001555365 0001555365
warning	4 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001568139 0001568139 0001563227 0001137005
warning	3 × Similarly named company. Duplicate?	None	0001644406 0000730349 0001007019
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111 0000949852
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.195059481156614}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001800373
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	9,661,351	18,537,320,000	39,373,000,000	0000014177	0000880117	0001103982
1	AssetsCurrent	337,509	471,912	160,143,555	4,783,000,000	7,630,000,000	0001725911	0000034563	0001103982
2	PropertyPlantAndEquipment	0	0	126,323,777	2,673,680,000	7,282,000,000	0000949852	0000880117	0000100493
3	remainder_Assets	0	0	14,781,638	933,940,000	17,546,000,000	0000015357	0000814586	0001103982
4	LiabilitiesLongTerm	0	0	160,292	8,633,060,000	16,961,000,000	0000014177	0001487197	0001103982
5	LiabilitiesCurrent	0	309,850	79,559,703	5,827,820,000	15,322,000,000	0001117057	0000098677	0001103982
6	remainder_Liabilities	0	0	1,449,030	2,607,800,000	10,655,700,000	0000057515	0001007019	0000023217
7	GeneralAndAdministrativeExpense	0	0	0	53,051,800	301,355,000	0000014177	0000098677	0000931336
8	SellingAndMarketingExpense	0	0	0	105,071,800	1,327,922,000	0000014177	0000023217	0000931336
9	remainder_Expenses	441,320	1,193,053	462,497,059	16,499,000,000	39,974,000,000	0001572386	0000034563	0000100493
10	remainder_Revenues	0	0	557,697,179	18,665,760,000	42,405,000,000	0000098677	0001005286	0000100493
11	remainder_NetIncome	-396,000,000	-241,980,000	-1,871	47,120,000	85,404,000	0000100493	0000015357	0000098677
12	remainder_ComprehensiveNetIncome	-229,900,000	-119,820,000	0	18,595,600	357,000,000	0000040704	0001725911	0001103982

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	371,531	471,912	424,708,327	30,708,360,000	64,549,000,000	0001725911	0000034563	0001103982
1	Liabilities	242,811	735,155	119,711,501	16,238,440,000	37,198,000,000	0000015357	0000057515	0001103982
2	Expenses	852,455	2,231,169	559,113,693	16,499,000,000	39,974,000,000	0001741231	0001005286	0000100493
3	Revenues	0	0	557,697,179	18,665,760,000	42,405,000,000	0000098677	0001005286	0000100493
4	StockholdersEquity	-29,472,605	-2,074,405	254,611,120	11,805,720,000	27,584,000,000	0001593001	0000880117	0000100493
5	NetIncome	-500,804,000	-95,538,800	459,830	1,835,960,000	3,885,000,000	0000931336	0000814586	0001103982
6	ComprehensiveNetIncome	-493,364,880	-100,485,872	459,830	1,728,361,600	4,070,640,000	0000931336	0000814586	0001103982
7	BaseVar	3,329,657	7,323,516	1,553,546,718	68,150,847,600	105,925,050,000	0001725911	0001005286	0000100493
8	EconomicCapitalRatio	-4.39	-2.20	1.03	2.50	2.69	0001572386	0001611647	0000057515

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	IntangibleAssets	-1.04	-0.812	-0.143	0.931	1.27	0001725911	0000812128	0001644406
1	AssetsCurrent	-0.656	-0.407	-0.0871	0.450	1.03	0000931336	0000812128	0001655210
2	PropertyPlantAndEquipment	-0.846	-0.521	-0.0204	0.540	0.861	0001725911	0000023217	0001611647
3	remainder_Assets	-0.940	-0.710	-0.156	0.194	1.67	0001725911	0001530950	0001741231
4	LiabilitiesLongTerm	-1.38	-0.899	0.223	0.836	0.914	0001530950	0001612188	0000910329
5	LiabilitiesCurrent	-0.590	-0.164	0.526	2.19	5.02	0001730773	0001655210	0001572386
6	remainder_Liabilities	-1.11	-0.526	0.177	0.639	0.832	0000023217	0001612188	0000910329
7	GeneralAndAdministrativeExpense	-2.63	-0.954	0.142	0.491	0.677	0001487197	0000040704	0000910329
8	SellingAndMarketingExpense	-1.39	-0.905	0.0617	0.215	0.294	0000931336	0000040704	0000910329
9	remainder_Expenses	-2.74	-2.10	-0.418	0.986	1.30	0000910329	0000910406	0001487197
10	remainder_Revenues	-1.30	-0.882	0.390	2.50	3.34	0001572386	0001005286	0000910329
11	remainder_NetIncome	-0.652	-0.221	0.0371	0.261	0.489	0001117057	0000063754	0001612188
12	remainder_ComprehensiveNetIncome	-0.0951	-0.0535	-0.0259	0.00949	0.491	0000014177	0001128928	0001117057

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.98	-1.78	-0.134	0.707	1.09	0001725911	0001611647	0000098677
1	Liabilities	-0.790	-0.717	0.581	2.36	4.56	0001530950	0001063537	0001572386
2	Expenses	-2.52	-2.05	-0.415	0.714	1.02	0000015357	0000785956	0001117057
3	Revenues	-1.30	-0.882	0.390	2.50	3.34	0001572386	0001005286	0000910329
4	StockholdersEquity	-2.95	-2.50	0.00573	1.29	2.27	0001593001	0001005286	0001741231
5	NetIncome	-1.88	-1.16	0.257	0.847	1.69	0001572386	0000040704	0000910329
6	ComprehensiveNetIncome	-1.89	-1.18	0.236	0.810	1.64	0001572386	0000040704	0000910329
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0000949852	0000014177
8	EconomicCapitalRatio	-5.23	-3.03	0.191	1.66	1.85	0001572386	0001611647	0000057515

2020

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000034563 0000100493 0000100493 0000100493 0001572386
error	2 × Negative Expenses, ignoring company.	pre-agg	0001568139 0001137005
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001117057
warning	10 × Ignoring company because Expenses is zero	pre-agg	0001568139 0001568139 0000802481 0000802481 0000802481 0000880117 0000880117 0000880117 0000880117 0000880117
warning	8 × Similarly named company. Duplicate?	None	0000100493 0000785956 0001320695 0001579733 0001612188 0001644406 0001772016 0000814586
warning	8 × Ignoring company because Assets is zero	pre-agg	0001117057 0001278027 0001278027 0001278027 0000042228 0001555365 0001555365 0001555365
warning	7 × No stock price available	subcommand.plot	0001563227 0001568139 0001612188 0001644406 0000015357 0000812128 0001563463
warning	4 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001563227 0001568139 0001568139 0001137005
warning	2 × Missing logo	subcommand.report	0001563227 0001568139
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111 0000949852
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.6512755458704}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001117057
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001800373
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001563227

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	IntangibleAssets	0	0	40,789,175	20,684,400,000	79,756,000,000	0000014177	0000812128	0001637459
1	AssetsCurrent	0	42,749	239,086,582	7,606,830,000	10,822,000,000	0001563227	0000880117	0001637459
2	PropertyPlantAndEquipment	0	0	165,724,119	6,546,460,000	9,026,000,000	0001563227	0000034563	0001103982
3	remainder_Assets	0	0	17,499,781	1,557,750,000	7,790,000,000	0000015357	0001644406	0001103982
4	LiabilitiesLongTerm	0	0	7,099,638	11,982,480,000	29,821,000,000	0000057515	0001611647	0001637459
5	LiabilitiesCurrent	0	488,408	111,353,436	7,165,750,000	15,159,000,000	0001563227	0000910329	0001103982
6	remainder_Liabilities	0	0	4,533,853	4,648,810,000	11,705,000,000	0000057515	0000814586	0001637459
7	GeneralAndAdministrativeExpense	0	0	0	87,830,900	622,000,000	0000014177	0000047111	0000016732
8	SellingAndMarketingExpense	0	0	0	118,831,100	947,000,000	0000014177	0000040704	0000016732
9	remainder_Expenses	30,000	304,568	625,772,204	22,983,290,000	40,691,000,000	0001572386	0001005286	0000100493
10	remainder_Revenues	0	24,167	591,582,849	25,329,160,000	43,185,000,000	0001563227	0001005286	0000100493
11	remainder_NetIncome	-413,900,000	-287,250,900	0	275,510,000	1,040,000,000	0000023217	0001730773	0000016732
12	remainder_ComprehensiveNetIncome	-450,000,000	-85,200,000	0	52,180,800	188,000,000	0001103982	0000015357	0000016732

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	7,200	51,087	468,313,889	34,347,570,000	99,830,000,000	0001563227	0001655210	0001637459
1	Liabilities	261,082	603,080	134,273,391	21,156,670,000	49,587,000,000	0001563227	0000785956	0001637459
2	Expenses	133,863	1,024,631	626,207,975	22,983,290,000	40,691,000,000	0001563227	0001005286	0000100493
3	Revenues	0	24,167	591,582,849	25,329,160,000	43,185,000,000	0001563227	0001005286	0000100493
4	StockholdersEquity	-161,000,000	-4,194,906	238,245,400	25,778,010,000	50,243,000,000	0001772016	0000880117	0001637459
5	NetIncome	-80,407,000	-38,080,600	13,818,921	2,097,800,000	3,569,000,000	0000910406	0001320695	0001103982
6	ComprehensiveNetIncome	-52,528,760	-43,139,180	16,983,955	2,013,191,200	3,335,000,000	0000910406	0000785956	0001103982
7	BaseVar	274,028	2,983,438	1,704,000,926	102,956,605,400	129,766,415,000	0001563227	0001005286	0001637459
8	EconomicCapitalRatio	-86.5	-4.65	0.687	2.34	3.09	0001725911	0000063754	0001741231

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	IntangibleAssets	-66.3	-0.791	-0.137	0.865	1.37	0001725911	0001579733	0001637459
1	AssetsCurrent	-65.8	-0.619	-0.0748	0.567	2.09	0001725911	0001530950	0001650696
2	PropertyPlantAndEquipment	-58.3	-0.668	0.00478	0.393	0.803	0001725911	0000057515	0001563463
3	remainder_Assets	-33.5	-0.210	-0.0328	0.105	0.344	0001725911	0001644406	0000098677
4	LiabilitiesLongTerm	-54.2	-1.13	0.0738	0.930	1.30	0001725911	0001005286	0000910329
5	LiabilitiesCurrent	-63.6	-0.237	0.546	3.84	8.74	0001725911	0001655210	0001572386
6	remainder_Liabilities	-45.7	-0.628	0.172	0.794	23.5	0001725911	0001320695	0001563227
7	GeneralAndAdministrativeExpense	-1.80	-0.695	0.135	0.421	1.60	0001487197	0000098677	0001725911
8	SellingAndMarketingExpense	-0.665	-0.454	0.0551	0.170	1.05	0000034563	0001593001	0001725911
9	remainder_Expenses	-57.3	-1.59	0.0278	0.925	1.07	0001725911	0001772016	0001572386
10	remainder_Revenues	-24.5	-1.25	0.339	2.03	3.65	0001725911	0000047111	0000910329
11	remainder_NetIncome	-0.530	-0.0948	0.0415	0.140	0.688	0001572386	0001611647	0001725911
12	remainder_ComprehensiveNetIncome	-0.112	-0.0293	0.00623	0.0238	0.121	0001612188	0000098677	0001725911

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-79.5	-1.78	-0.0108	0.840	1.03	0001725911	0000057515	0001637459
1	Liabilities	-72.1	-0.459	0.717	3.58	4.46	0001725911	0000014177	0001563227
2	Expenses	-54.6	-1.10	-0.0744	0.575	0.700	0001725911	0001005286	0001741231
3	Revenues	-24.5	-1.25	0.339	2.03	3.65	0001725911	0000047111	0000910329
4	StockholdersEquity	-5.49	-2.78	0.331	1.77	2.26	0001725911	0000014177	0001650696
5	NetIncome	-78.4	-1.81	0.526	1.46	2.74	0001725911	0000910406	0000910329
6	ComprehensiveNetIncome	-78.3	-1.81	0.538	1.46	2.76	0001725911	0000040704	0000910329
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001063537	0000014177
8	EconomicCapitalRatio	-84.8	-3.02	2.32	3.98	4.72	0001725911	0000063754	0001741231

2021

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000034563 0000100493 0000100493 0000100493 0001572386
error	3 × Negative Expenses, ignoring company.	pre-agg	0001568139 0001800373 0001137005
warning	46 × No stock price available	subcommand.plot	0001409446 0001568139 0000016732 0000023217 0000034563 0000040704 0000047111 0000057515 0000063754 0000091419 0000098677 0000100493 0000785956 0000802481 0000910329 0000910406 0001005286 0001046257 0001320695 0001530950 0001579733 0001616262 0001637459 0001644406 0001650696 0001655210 0001691936 0001725911 0001741231 0001753706 0001772016 0001800373 0001830210 0000015357 0000812128 0001563463 0000880117 0001007019 0001117057 0001487197 0001572386 0001593001 0001612188 0001624517 0001730773 0001856608
warning	11 × Ignoring company because Expenses is zero	pre-agg	0001568139 0001568139 0000802481 0000802481 0000802481 0000880117 0000880117 0000880117 0000880117 0000880117 0001741603
warning	10 × Similarly named company. Duplicate?	None	0000100493 0000785956 0001320695 0001579733 0001644406 0001691936 0001772016 0001487197 0001612188 0001856608
warning	8 × Ignoring company because Assets is zero	pre-agg	0001117057 0001278027 0001278027 0001278027 0000042228 0001555365 0001555365 0001555365
warning	5 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001568139 0001568139 0001800373 0001137005 0001563227
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111 0000949852
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.838658336979612}
warning	1 × Missing logo	subcommand.report	0001568139
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001800373
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	26,822,115	19,140,500,000	74,838,000,000	0000014177	0001655210	0001637459
1	AssetsCurrent	0	38,119	225,382,670	7,374,250,000	10,342,000,000	0001800373	0000880117	0001103982
2	PropertyPlantAndEquipment	0	0	126,917,445	5,206,400,000	8,658,000,000	0001117057	0001830210	0001103982
3	remainder_Assets	0	0	13,659,260	1,730,500,000	7,210,000,000	0000015357	0000014177	0001103982
4	LiabilitiesLongTerm	0	0	6,649,950	9,261,000,000	22,603,000,000	0000057515	0001741231	0001637459
5	LiabilitiesCurrent	159,266	481,476	92,334,320	7,295,400,000	14,008,000,000	0001800373	0001856608	0001103982
6	remainder_Liabilities	0	0	7,600,834	3,272,200,000	12,275,000,000	0000057515	0001772016	0001637459
7	GeneralAndAdministrativeExpense	0	0	0	71,059,000	598,000,000	0000014177	0000057515	0000016732
8	SellingAndMarketingExpense	0	0	0	91,737,000	817,000,000	0000014177	0000047111	0000016732
9	remainder_Expenses	22,890	146,117	524,269,680	20,473,600,000	43,634,000,000	0001409446	0000098677	0000100493
10	remainder_Revenues	0	2,604	494,223,940	22,084,500,000	47,049,000,000	0001568139	0001753706	0000100493
11	remainder_NetIncome	-355,000,000	-216,349,000	-12,538	66,850,000	696,000,000	0000100493	0001725911	0001103982
12	remainder_ComprehensiveNetIncome	-86,300,000	-5,590,000	0	122,150,000	479,000,000	0001772016	0001007019	0000040704

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	615	99,114	535,705,015	34,075,450,000	93,394,000,000	0001409446	0001830210	0001637459
1	Liabilities	159,266	482,747	196,037,975	17,514,000,000	43,942,000,000	0001800373	0000910329	0001637459
2	Expenses	22,890	294,690	524,269,680	20,473,600,000	43,634,000,000	0001409446	0000098677	0000100493
3	Revenues	0	2,604	494,223,940	22,084,500,000	47,049,000,000	0001568139	0001753706	0000100493
4	StockholdersEquity	-65,500,000	-1,444,164	217,428,955	19,350,550,000	49,452,000,000	0001772016	0001741231	0001637459
5	NetIncome	-182,105,000	-64,527,500	366,253	1,914,409,500	4,314,000,000	0001655210	0000015357	0001103982
6	ComprehensiveNetIncome	-183,301,520	-59,945,001	868,095	2,060,675,100	4,341,040,000	0001655210	0001007019	0001103982
7	BaseVar	301,662	977,262	1,799,111,436	86,338,796,500	122,779,145,000	0001568139	0001753706	0001637459
8	EconomicCapitalRatio	-3.42	-2.84	0.733	2.33	2.80	0001572386	0000040704	0000812128

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	IntangibleAssets	-1.29	-0.563	-0.144	0.943	1.30	0001725911	0001616262	0001637459
1	AssetsCurrent	-0.532	-0.385	-0.0641	0.794	2.57	0001563463	0000910406	0001593001
2	PropertyPlantAndEquipment	-0.892	-0.322	-0.0139	0.426	0.788	0001725911	0000023217	0001563463
3	remainder_Assets	-0.631	-0.289	-0.0778	0.466	3.70	0001725911	0000091419	0001800373
4	LiabilitiesLongTerm	-1.15	-0.782	0.0780	0.831	1.23	0001679273	0000023217	0000910329
5	LiabilitiesCurrent	-0.334	0.0153	0.675	2.19	3.82	0001800373	0001063537	0001572386
6	remainder_Liabilities	-1.69	-0.489	0.0855	0.544	0.798	0001655210	0001800373	0000910329
7	GeneralAndAdministrativeExpense	-1.31	-0.708	0.0928	0.255	0.450	0001487197	0000091419	0000910329
8	SellingAndMarketingExpense	-1.81	-0.595	0.0553	0.152	0.268	0001691936	0000091419	0000910329
9	remainder_Expenses	-2.90	-2.19	0.0314	0.628	1.59	0001593001	0001679273	0001650696
10	remainder_Revenues	-2.02	-0.872	0.225	2.42	4.32	0001593001	0000016732	0000910329
11	remainder_NetIncome	-0.538	-0.155	0.00566	0.286	2.01	0001563463	0001772016	0001593001
12	remainder_ComprehensiveNetIncome	-0.160	-0.0578	-0.0169	0.0466	1.45	0001772016	0000016732	0001650696

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.96	-1.18	-0.00451	0.828	1.84	0001725911	0000785956	0001800373
1	Liabilities	-0.529	-0.146	0.552	2.44	3.02	0001655210	0001730773	0000812128
2	Expenses	-2.51	-1.77	-0.124	0.449	0.634	0001593001	0000910406	0001409446
3	Revenues	-2.02	-0.872	0.225	2.42	4.32	0001593001	0000016732	0000910329
4	StockholdersEquity	-2.80	-2.49	0.546	1.66	2.06	0001409446	0001856608	0001611647
5	NetIncome	-2.52	-1.63	0.294	1.40	2.34	0001593001	0001644406	0000910329
6	ComprehensiveNetIncome	-2.57	-1.67	0.306	1.35	2.26	0001593001	0001320695	0000910329
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001409446	0000014177
8	EconomicCapitalRatio	-3.88	-3.31	0.266	1.86	2.34	0001572386	0000040704	0000812128

2022

Logs

error	5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0000100493 0000100493 0000100493 0000034563 0001572386
error	3 × Negative Expenses, ignoring company.	pre-agg	0001800373 0001568139 0001137005
error	1 × IME and Company effects mismatched for Other Expenses. IME Effects: 88.3, Company Effect: 88.2	subcommand.report	0000100493
warning	35 × No stock price available	subcommand.plot	0001278027 0000014177 0000023217 0000055067 0000057515 0000098677 0000785956 0000802481 0000910329 0001005286 0001046257 0001063537 0001103982 0001530950 0001644406 0001650696 0001655210 0001679273 0001753706 0001772016 0001830210 0001856608 0000015357 0000730349 0000814586 0000880117 0001007019 0001487197 0001572386 0001593001 0001611647 0001612188 0001624517 0001691936 0001730773
warning	11 × Ignoring company because Expenses is zero	pre-agg	0000802481 0000802481 0000802481 0001741603 0000880117 0000880117 0000880117 0000880117 0000880117 0001568139 0001568139
warning	8 × Ignoring company because Assets is zero	pre-agg	0001278027 0001278027 0001278027 0001117057 0000042228 0001555365 0001555365 0001555365
warning	5 × Similarly named company. Duplicate?	None	0001644406 0001772016 0001856608 0000730349 0001487197
warning	5 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001800373 0001568139 0001568139 0001137005 0001563227
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000047111 0000949852
warning	1 × equityII differs from equityI	pre-agg	0000814586
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.2661044197010165}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001278027
warning	1 × Missing logo	subcommand.report	0001278027
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001800373
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001137005

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	IntangibleAssets	0	0	43,990,600	19,071,700,000	73,482,000,000	0000014177	0000034563	0001637459
1	AssetsCurrent	23,688	71,953	309,107,030	6,493,400,000	10,091,000,000	0001409446	0000098677	0001103982
2	PropertyPlantAndEquipment	0	0	132,599,890	5,264,500,000	9,020,000,000	0000730349	0000880117	0001103982
3	remainder_Assets	0	0	19,635,125	1,883,500,000	8,230,000,000	0000015357	0000880117	0001103982
4	LiabilitiesLongTerm	0	0	15,609,945	8,143,700,000	23,453,000,000	0000055067	0001741231	0001103982
5	LiabilitiesCurrent	365,162	1,101,758	93,517,345	7,184,450,000	16,731,000,000	0000015357	0001741231	0001103982
6	remainder_Liabilities	0	0	10,219,870	3,137,650,000	11,773,000,000	0000055067	0001005286	0001637459
7	GeneralAndAdministrativeExpense	0	0	0	87,321,000	617,000,000	0000014177	0000023217	0000016732
8	SellingAndMarketingExpense	0	0	0	105,286,500	734,000,000	0000014177	0000040704	0000016732
9	remainder_Expenses	54,275	300,970	761,796,325	20,546,694,500	49,772,000,000	0001572386	0001655210	0000100493
10	remainder_Revenues	0	42,880	687,927,005	22,738,900,000	53,282,000,000	0001409446	0000098677	0000100493
11	remainder_NetIncome	-343,716,000	-222,800,000	-569,509	194,550,000	743,300,000	0000047111	0001572386	0001530950
12	remainder_ComprehensiveNetIncome	-991,000,000	-298,579,500	-86,588	25,970,500	431,000,000	0001637459	0000910329	0000040704

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	27,542	102,242	849,851,880	33,955,550,000	90,513,000,000	0001572386	0001753706	0001637459
1	Liabilities	496,208	1,194,674	235,944,130	16,937,500,000	44,241,000,000	0000015357	0000098677	0001103982
2	Expenses	268,669	654,841	762,369,020	20,546,694,500	49,772,000,000	0001409446	0001655210	0000100493
3	Revenues	0	42,880	687,927,005	22,738,900,000	53,282,000,000	0001409446	0000098677	0000100493
4	StockholdersEquity	-376,200,000	-6,307,464	274,572,350	19,533,500,000	48,870,000,000	0001772016	0001753706	0001637459
5	NetIncome	-366,137,000	-134,694,000	925,530	2,547,000,000	3,249,000,000	0001655210	0000814586	0000100493
6	ComprehensiveNetIncome	-368,346,480	-136,509,320	573,442	2,203,020,000	3,178,280,000	0001655210	0001579733	0000100493
7	BaseVar	1,201,126	2,906,679	2,248,781,398	92,071,974,500	129,173,295,000	0001409446	0000880117	0000100493
8	EconomicCapitalRatio	-6.91	-3.27	0.655	2.22	2.41	0001593001	0000802481	0000014177

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	IntangibleAssets	-2.63	-1.52	-0.268	0.818	1.31	0001593001	0000910329	0001637459
1	AssetsCurrent	-0.452	-0.346	-0.0299	0.739	3.33	0001409446	0000910406	0001593001
2	PropertyPlantAndEquipment	-1.57	-0.857	0.00237	0.386	0.772	0001593001	0000023217	0001611647
3	remainder_Assets	-0.698	-0.328	-0.0315	0.230	2.10	0001593001	0000785956	0001117057
4	LiabilitiesLongTerm	-1.38	-1.000	-0.00492	0.978	1.64	0001772016	0001830210	0000910329
5	LiabilitiesCurrent	-2.43	-0.0357	0.418	2.19	4.74	0001409446	0001679273	0001572386
6	remainder_Liabilities	-1.51	-0.476	0.0515	0.474	0.931	0001655210	0001856608	0000910329
7	GeneralAndAdministrativeExpense	-3.14	-0.788	0.0980	0.237	0.524	0001650696	0001753706	0000910329
8	SellingAndMarketingExpense	-1.56	-1.08	0.0780	0.212	0.468	0001593001	0001530950	0000910329
9	remainder_Expenses	-3.23	-1.90	0.0113	0.579	1.33	0000910329	0001655210	0001650696
10	remainder_Revenues	-2.44	-0.869	0.0876	2.04	5.06	0001593001	0000016732	0000910329
11	remainder_NetIncome	-0.976	-0.247	0.00382	0.153	1.59	0001117057	0001007019	0001409446
12	remainder_ComprehensiveNetIncome	-0.0743	-0.0330	0.00499	0.0283	0.0714	0001117057	0000047111	0000014177

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-2.71	-1.65	-0.0428	0.710	1.04	0001593001	0000100493	0001637459
1	Liabilities	-1.33	-0.522	0.195	2.15	3.00	0001409446	0001691936	0000910329
2	Expenses	-4.33	-2.50	0.110	0.549	0.614	0001593001	0001046257	0001409446
3	Revenues	-2.44	-0.869	0.0876	2.04	5.06	0001593001	0000016732	0000910329
4	StockholdersEquity	-2.80	-2.54	0.426	1.54	2.06	0001572386	0000063754	0001611647
5	NetIncome	-6.74	-2.44	0.373	1.13	2.87	0001593001	0000091419	0000910329
6	ComprehensiveNetIncome	-6.73	-2.44	0.380	1.15	2.89	0001593001	0001644406	0000910329
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001117057	0000014177
8	EconomicCapitalRatio	-7.03	-3.39	0.533	2.10	2.29	0001593001	0000802481	0000014177

2023

Logs

warning	10 × Similarly named company. Duplicate?	None	0001278027 0000100493 0000785956 0001320695 0001730773 0001772016 0001856608 0001487197 0000814586 0000730349
warning	10 × No stock price available	subcommand.plot	0001278027 0000055067 0000802481 0001005286 0001753706 0001800373 0001856608 0000015357 0001117057 0001007019
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.78523652186074}
warning	1 × Missing logo	subcommand.report	0001278027

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	IntangibleAssets	0	0	80,602,343	20,378,240,000	72,907,000,000	0000014177	0000098677	0001637459
1	AssetsCurrent	0	3,440	372,851,124	7,378,480,000	11,703,000,000	0001800373	0001655210	0001103982
2	PropertyPlantAndEquipment	0	0	135,738,686	6,424,840,000	9,694,000,000	0000730349	0000880117	0001103982
3	remainder_Assets	0	0	22,563,579	1,909,800,000	5,579,000,000	0000015357	0001117057	0001103982
4	LiabilitiesLongTerm	0	0	13,429,920	10,147,220,000	20,812,000,000	0000055067	0000880117	0001637459
5	LiabilitiesCurrent	0	853,395	98,968,059	7,328,360,000	19,013,000,000	0001800373	0001753706	0001103982
6	remainder_Liabilities	0	0	34,029,598	5,222,040,000	11,768,000,000	0000055067	0000880117	0001637459
7	GeneralAndAdministrativeExpense	0	0	0	69,260,800	654,000,000	0000014177	0000047111	0000016732
8	SellingAndMarketingExpense	0	0	0	108,836,600	811,000,000	0000014177	0000040704	0000016732
9	remainder_Expenses	0	426,152	811,188,737	22,615,700,000	53,247,000,000	0001409446	0000880117	0000100493
10	remainder_Revenues	0	28,563	999,777,234	25,330,840,000	52,881,000,000	0001409446	0000880117	0000100493
11	remainder_NetIncome	-1,144,400,000	-284,880,000	-6,169	301,180,000	1,029,000,000	0000091419	0000015357	0001103982
12	remainder_ComprehensiveNetIncome	-323,000,000	-28,480,000	0	121,460,000	215,000,000	0000055067	0001800373	0001637459

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	20.0	158,433	826,835,254	35,291,140,000	90,339,000,000	0001624517	0001753706	0001637459
1	Liabilities	143,334	909,229	262,382,605	19,250,420,000	43,025,000,000	0001800373	0000098677	0001103982
2	Expenses	112,283	444,712	932,061,546	22,615,700,000	53,247,000,000	0001409446	0000880117	0000100493
3	Revenues	0	28,563	999,777,234	25,330,840,000	52,881,000,000	0001409446	0000880117	0000100493
4	StockholdersEquity	-513,368,000	-2,773,559	293,253,241	24,832,800,000	49,722,000,000	0001655210	0000880117	0001637459
5	NetIncome	-649,000,000	-116,292,000	171,761	2,460,037,400	4,968,000,000	0000100493	0000015357	0001103982
6	ComprehensiveNetIncome	-629,240,000	-109,844,040	171,157	2,328,358,320	4,963,840,000	0000100493	0000015357	0001103982
7	BaseVar	312,741	1,752,778	2,352,328,219	108,086,418,300	132,614,205,000	0001800373	0000910329	0000100493
8	EconomicCapitalRatio	-10.9	-3.79	0.728	2.25	2.37	0001593001	0001320695	0000057515

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	IntangibleAssets	-3.47	-1.44	-0.200	0.730	1.30	0001593001	0001611647	0001637459
1	AssetsCurrent	-1.62	-0.790	-0.0134	0.743	1.16	0001593001	0001320695	0001650696
2	PropertyPlantAndEquipment	-2.19	-0.608	-0.0240	0.327	1.02	0001593001	0000063754	0001611647
3	remainder_Assets	-1.43	-0.565	-0.0675	0.358	4.71	0001593001	0000100493	0001800373
4	LiabilitiesLongTerm	-1.39	-1.05	0.0476	0.988	1.33	0001593001	0001655210	0000910329
5	LiabilitiesCurrent	-0.157	-0.0517	0.347	2.40	9.47	0001117057	0001046257	0001624517
6	remainder_Liabilities	-1.31	-0.963	0.172	0.830	1.26	0001655210	0001753706	0000910329
7	GeneralAndAdministrativeExpense	-1.34	-1.12	0.130	0.337	0.570	0001650696	0000040704	0000910329
8	SellingAndMarketingExpense	-1.84	-1.01	0.0684	0.182	0.307	0001650696	0001530950	0000910329
9	remainder_Expenses	-2.78	-1.61	0.0640	0.816	1.03	0000910329	0001753706	0001800373
10	remainder_Revenues	-3.42	-1.01	0.130	2.09	3.62	0001593001	0000016732	0000910329
11	remainder_NetIncome	-5.84	-0.615	0.192	0.584	0.783	0001593001	0000016732	0000910329
12	remainder_ComprehensiveNetIncome	-0.0365	-0.0113	-0.00193	0.0205	0.0320	0000055067	0001772016	0000034563

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-5.99	-2.49	0.0385	0.629	1.72	0001593001	0001046257	0001800373
1	Liabilities	-0.747	-0.375	0.333	2.57	4.22	0001655210	0001611647	0001624517
2	Expenses	-2.47	-1.83	0.0377	0.598	0.939	0001650696	0001655210	0001593001
3	Revenues	-3.42	-1.01	0.130	2.09	3.62	0001593001	0000016732	0000910329
4	StockholdersEquity	-3.04	-2.33	0.394	1.34	1.56	0001725911	0001320695	0000785956
5	NetIncome	-8.32	-2.16	0.447	1.40	2.50	0001593001	0000063754	0000910329
6	ComprehensiveNetIncome	-8.32	-2.16	0.456	1.40	2.49	0001593001	0000063754	0000910329
7	BaseVar	nan	nan	nan	nan	nan	0000014177	0001046257	0000014177
8	EconomicCapitalRatio	-10.9	-3.84	0.675	2.20	2.32	0001593001	0001320695	0000057515

Estimates

Parameter	Value	Min	Max
PresentValueFactor	2.09	1.0	15.0
BalanceFactor	1.36	0.5	5.0
OCIFactor	0.52	0.5	1.0
HiddenReservesFactor	0.0	0.0	0.0
LLPO_stddev	1.24	0.2	10.0

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