QA: us_advertising 2010-2023

Ranks across the years

	name	name_short	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	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	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
0001377630	National Cinemedia Inc	Nationa	NaN	11	12	16	NaN	15	13	14	16	15	18	23	21	1	NaN	-56.3651	-63.1872	-5.63274	NaN	-23.69280	-21.22960	0.996257	-65.6234	-56.34770	-117.3580	-146.481000	-178.96900	1271.27000	NaN	1	4	NaN	NaN	-2	1	2	-1	3	5	-2	-20
0001392694	Surgepays Inc	Surgepa	NaN	NaN	NaN	19	25	21	24	18	20	21	26	25	15	2	NaN	NaN	NaN	-506.54400	-493.3740	-299.45300	-907.47700	-344.687000	-253.3260	-464.59700	-653.2710	-384.834000	24.81780	635.23300	NaN	NaN	NaN	6	-4	3	-6	2	1	5	-1	-10	-13
0001088638	Mastermind INC	Masterm	NaN	NaN	NaN	NaN	32	NaN	NaN	NaN	NaN	NaN	6	3	NaN	3	NaN	NaN	NaN	NaN	-1551.0900	NaN	NaN	NaN	NaN	NaN	190.4560	489.282000	NaN	379.76000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	NaN	NaN
0001705110	Angi Inc	Angi In	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	3	1	1	6	5	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	269.257000	381.4850	358.79300	347.6900	288.446000	250.88700	300.45000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-2	0	5	-1	-1
0001495231	Izea Worldwide Inc	Izea Wo	NaN	15	19	20	2	18	18	16	17	16	12	7	6	5	NaN	-1126.5600	-1350.7900	-590.43500	337.4020	-229.18800	-185.11900	-176.165000	-86.2196	-67.92530	35.7079	265.611000	237.95100	215.80700	NaN	4	1	-18	16	0	-2	1	-1	-4	-5	-1	-1
0001588014	ADM Endeavors INC	ADM End	NaN	NaN	NaN	NaN	22	NaN	NaN	25	18	2	7	5	7	6	NaN	NaN	NaN	NaN	-377.9120	NaN	NaN	-2459.700000	-119.2080	358.18900	175.7600	397.234000	189.65600	186.84700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-7	-16	5	-2	2	-1
0001133311	TRAVELZOO	TRAVELZ	NaN	5	2	12	4	6	4	6	8	6	15	18	12	7	NaN	200.0650	312.5400	72.64500	304.7120	204.82200	211.88700	146.364000	165.2600	154.50100	-71.7561	7.358270	79.15520	177.48200	NaN	-3	10	-8	2	-2	2	2	-2	9	3	-6	-5
0000029989	Omnicom Group INC	Omnicom	2	7	7	8	10	9	9	7	10	7	8	10	8	8	149.627	147.1520	163.5540	151.97100	142.9200	114.00700	129.24300	145.940000	129.6140	144.07400	143.7170	150.711000	151.16200	151.20400	5	0	1	2	-1	0	-2	3	-3	1	2	-2	0
0001576427	Criteo S A	Criteo	NaN	NaN	NaN	NaN	NaN	NaN	6	2	6	4	4	8	9	9	NaN	NaN	NaN	NaN	NaN	NaN	182.18900	263.334000	224.2330	211.93300	249.6210	217.253000	114.73000	144.04200	NaN	NaN	NaN	NaN	NaN	NaN	-4	4	-2	0	4	1	0
0000051644	Interpublic Group Of Companies INC	Interpu	3	9	10	13	12	NaN	NaN	NaN	NaN	9	11	15	13	10	68.681	77.5760	64.7559	52.63900	56.6520	NaN	NaN	NaN	NaN	62.15940	52.7339	71.440000	75.75300	87.18980	6	1	3	-1	NaN	NaN	NaN	NaN	NaN	2	4	-2	-3
0000876883	Stagwell Inc	Stagwel	NaN	10	NaN	NaN	16	17	17	9	15	13	19	16	14	11	NaN	-27.3440	NaN	NaN	-29.0257	-56.71000	-69.86320	66.257300	-62.7033	-19.88530	-120.7950	57.116000	58.82030	53.59990	NaN	NaN	NaN	NaN	1	0	-8	6	-2	6	-3	-2	-3
0001696195	Kinetic Group INC	Kinetic	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	NaN	NaN	3	12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8696.92000	NaN	NaN	266.99800	47.27830	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9
0001346655	CMG Holdings Group INC	CMG Hol	NaN	NaN	NaN	NaN	30	20	NaN	NaN	NaN	NaN	14	4	11	13	NaN	NaN	NaN	NaN	-1336.6700	-268.71700	NaN	NaN	NaN	NaN	13.1299	414.610000	104.61800	36.58340	NaN	NaN	NaN	NaN	-10	NaN	NaN	NaN	NaN	NaN	-10	7	2
0000875355	Lendway INC	Lendway	NaN	NaN	4	2	6	2	10	3	4	14	16	22	1	14	NaN	NaN	256.4670	343.29300	293.1480	316.44100	120.83400	196.481000	269.7140	-27.01140	-75.3136	-143.473000	594.37000	-4.67093	NaN	NaN	-2	4	-4	8	-7	1	10	2	6	-21	13
0001490281	Groupon Inc	Groupon	NaN	NaN	NaN	NaN	11	NaN	16	11	11	10	17	12	20	15	NaN	NaN	NaN	NaN	69.4398	NaN	-29.88420	35.248700	52.8979	53.35510	-116.7080	101.460000	-160.81300	-75.15650	NaN	NaN	NaN	NaN	NaN	NaN	-5	0	-1	7	-5	8	-5
0000829323	Inuvo Inc	Inuvo I	NaN	12	NaN	NaN	NaN	7	NaN	10	14	12	10	13	19	16	NaN	-451.8350	NaN	NaN	NaN	156.75200	NaN	41.285900	-40.9808	6.46871	57.5064	100.091000	-112.81900	-89.61380	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-2	-2	3	6	-3
0001556739	Thryv Holdings Inc	Thryv H	NaN	NaN	NaN	NaN	13	NaN	NaN	NaN	NaN	NaN	9	11	10	17	NaN	NaN	NaN	NaN	41.7817	NaN	NaN	NaN	NaN	NaN	112.3750	104.458000	108.69900	-109.66500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-1	7
0001334978	Clear Channel Outdoor Holdings Inc	Clear C	NaN	2	1	3	3	4	NaN	NaN	NaN	NaN	20	21	18	18	NaN	347.7950	317.6420	331.15500	317.8900	286.43900	NaN	NaN	NaN	NaN	-129.8680	-133.261000	-110.19900	-131.63000	NaN	-1	2	0	1	NaN	NaN	NaN	NaN	NaN	1	-3	0
0001539850	Starco Brands Inc	Starco	NaN	NaN	NaN	NaN	34	30	26	22	24	20	3	28	2	19	NaN	NaN	NaN	NaN	-2188.7100	-3947.24000	-1383.37000	-825.602000	-906.0300	-451.82500	258.0110	-689.992000	304.81000	-290.98200	NaN	NaN	NaN	NaN	-4	-4	-4	2	-4	-17	25	-26	17
0001460329	Fluent Inc	Fluent	NaN	NaN	NaN	NaN	18	13	8	8	7	5	5	9	23	20	NaN	NaN	NaN	NaN	-60.8883	-18.70640	165.54700	87.407400	179.6890	207.68500	235.0730	188.310000	-358.07700	-296.56200	NaN	NaN	NaN	NaN	-5	-5	0	-1	-2	0	4	14	-3
0001752372	Ezagoo Ltd	Ezagoo	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	19	23	20	NaN	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-383.76400	-334.9100	-80.311900	NaN	-608.61000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	-3	NaN	NaN
0001084267	Mobiquity Technologies Inc	Mobiqui	NaN	NaN	NaN	25	33	28	25	26	28	27	28	30	27	22	NaN	NaN	NaN	-1391.22000	-1820.5200	-1249.99000	-1240.62000	-2592.650000	-3523.4500	-1823.45000	-983.3890	-2728.070000	-1710.42000	-1030.13000	NaN	NaN	NaN	8	-5	-3	1	2	-1	1	2	-3	-5
0001080034	Conversant INC	Convers	1	3	3	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	401.218	291.3720	306.5530	294.10700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	0	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000934796	Network Cn INC	Network	NaN	13	14	22	NaN	NaN	20	20	21	24	2	NaN	25	NaN	NaN	-615.2800	-410.8830	-746.92200	NaN	NaN	-513.83000	-491.948000	-493.1470	-496.84700	268.2540	NaN	-511.24900	NaN	NaN	1	8	NaN	NaN	NaN	0	1	3	-22	NaN	NaN	NaN
0001078099	Meet Group Inc	Meet Gr	NaN	6	NaN	7	5	1	1	13	5	3	NaN	NaN	NaN	NaN	NaN	193.6050	NaN	206.55300	304.3900	419.11000	602.65500	14.892700	248.9880	276.75200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	-4	0	12	-8	-2	NaN	NaN	NaN	NaN
0001083243	Nzch Corp	Nzch Co	NaN	4	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	249.8580	146.8520	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001091325	China Yida Holding Co	China Y	NaN	1	6	10	14	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	376.2670	246.6460	114.43100	38.1884	17.97960	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	4	4	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001297336	Reachlocal Inc	Reachlo	NaN	8	9	11	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	94.3711	114.7710	95.01910	-97.2803	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	2	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001419995	DNA Brands INC	DNA Bra	NaN	16	18	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1511.6300	-1304.1100	-1263.95000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	6	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001428397	Adaptive Medias Inc	Adaptiv	NaN	17	23	26	27	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-6366.9400	-3387.9600	-1552.81000	-1060.8600	-2550.96000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	3	1	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001534298	Zenovia Digital Exchange Corp	Zenovia	NaN	14	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-749.3840	-493.5660	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001084332	Salon Media Group INC	Salon M	NaN	NaN	16	21	26	25	19	24	25	25	NaN	NaN	NaN	NaN	NaN	NaN	-631.1940	-687.51100	-527.7910	-735.64300	-463.42500	-2135.060000	-943.5880	-772.91700	NaN	NaN	NaN	NaN	NaN	NaN	5	5	-1	-6	5	1	0	NaN	NaN	NaN	NaN
0001297965	Inolife Technologies INC	Inolife	NaN	NaN	21	28	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2053.4100	-2525.70000	-1388.4400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001329957	OSL Holdings Inc	OSL Hol	NaN	NaN	20	NaN	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2003.5200	NaN	-2649.9200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001372375	Millennial Media Inc	Millenn	NaN	NaN	5	5	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	251.3850	249.83500	-125.0590	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	16	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001431880	Potash America INC	Potash	NaN	NaN	17	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-834.6140	-1638.19000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001491778	Angie S List Inc	Angie S	NaN	NaN	13	18	19	10	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-304.4550	-195.07900	-69.3404	29.69910	-22.18210	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	1	-9	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001527190	National Cinemedia LLC	Nationa	NaN	NaN	11	14	NaN	12	12	12	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-50.6628	39.18760	NaN	-7.49959	7.07596	32.659700	25.9396	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	NaN	NaN	0	0	1	NaN	NaN	NaN	NaN	NaN
0001538217	Srax Inc	Srax In	NaN	NaN	22	17	17	16	15	15	2	23	21	27	NaN	NaN	NaN	NaN	-2437.4800	-135.32300	-49.1426	-26.32010	-22.21040	-8.753580	491.6670	-484.74800	-140.8100	-560.557000	NaN	NaN	NaN	NaN	-5	0	-1	-1	0	-13	21	-2	6	NaN	NaN
0001080627	V Media Corp	V Media	NaN	NaN	NaN	15	15	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1.67636	14.3197	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001375796	Telaria Inc	Telaria	NaN	NaN	NaN	9	9	14	11	5	12	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	151.00700	153.1980	-22.90700	42.10280	174.641000	40.2665	30.27340	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	5	-3	-6	7	-1	NaN	NaN	NaN	NaN
0001415624	Yume Inc	Yume In	NaN	NaN	NaN	6	8	8	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	246.43400	178.6020	127.01400	184.11300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	0	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001442376	Total Sports Media Inc	Total S	NaN	NaN	NaN	23	24	23	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-828.79900	-493.2410	-515.73300	-597.47400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	-1	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001475274	Retailmenot Inc	Retailm	NaN	NaN	NaN	1	1	3	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	369.48500	348.0100	303.31200	292.75700	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	2	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001115128	Quotient Technology Inc	Quotien	NaN	NaN	NaN	NaN	7	5	3	4	9	8	13	17	17	NaN	NaN	NaN	NaN	NaN	237.0010	218.57200	268.23900	177.574000	137.6640	88.93310	34.4420	47.128400	-19.48410	NaN	NaN	NaN	NaN	NaN	-2	-2	1	5	-1	5	4	0	NaN
0001509477	Nownews Digital Media Technology Co Ltd	Nownews	NaN	NaN	NaN	NaN	23	19	27	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-397.9320	-245.01900	-1517.25000	-1205.400000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	8	-4	NaN	NaN	NaN	NaN	NaN	NaN
0001516079	Us China Biomedical Technology Inc	Us Chin	NaN	NaN	NaN	NaN	37	NaN	29	27	27	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4722.8200	NaN	-2256.88000	-2655.990000	-1514.3700	-5181.21000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	0	1	NaN	NaN	NaN	NaN
0001559754	Wowio Inc	Wowio I	NaN	NaN	NaN	NaN	28	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1151.6300	-861.10200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001579717	Perk International Inc	Perk In	NaN	NaN	NaN	NaN	35	NaN	NaN	NaN	NaN	NaN	NaN	1	26	NaN	NaN	NaN	NaN	NaN	-2403.2800	NaN	NaN	NaN	NaN	NaN	NaN	1979.300000	-942.67400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	NaN
0001615780	Teardroppers Inc	Teardro	NaN	NaN	NaN	NaN	29	24	23	19	22	22	25	26	22	NaN	NaN	NaN	NaN	NaN	-1318.6600	-704.19600	-672.24700	-476.020000	-553.3290	-482.52000	-505.6380	-546.848000	-338.15500	NaN	NaN	NaN	NaN	NaN	-5	-1	-4	3	0	3	1	-4	NaN
0001343465	Sun Pacific Holding Corp	Sun Pac	NaN	NaN	NaN	NaN	NaN	22	21	NaN	26	17	22	2	24	NaN	NaN	NaN	NaN	NaN	NaN	-460.43300	-543.51100	NaN	-955.6190	-164.65700	-192.1200	606.728000	-472.62200	NaN	NaN	NaN	NaN	NaN	NaN	-1	NaN	NaN	-9	5	-20	22	NaN
0001580264	Mobile Lads Corp	Mobile	NaN	NaN	NaN	NaN	NaN	27	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-888.88800	-1757.48000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001609139	Innerscope Hearing Technologies INC	Innersc	NaN	NaN	NaN	NaN	NaN	NaN	7	21	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	166.33500	-617.030000	-779.9630	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	2	NaN	NaN	NaN	NaN	NaN
0001648365	Agri Fintech Holdings INC	Agri Fi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	19	18	27	19	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-262.129000	-162.1090	-317.79700	-689.7880	0.440475	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-1	9	-8	NaN	NaN
0001725516	Renewable Innovations INC	Renewab	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	26	29	NaN	16	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	557.6300	-899.40000	-1002.2800	NaN	4.66991	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	3	NaN	NaN	NaN
0001703625	Treasure Shipwreck Recovery Inc	Treasur	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24	24	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-414.6900	-335.733000	-2610.02000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	4	NaN
0001463833	IDW Media Holdings INC	IDW Med	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	91.424600	252.78300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	NaN
0001840102	Specificity INC	Specifi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	29	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-1562.930000	-2950.62000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN

PDF reports

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

2010

Logs

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	AssetsCurrent	302,525,000	1,117,622,500	8,453,848,120	10,020,040,000	10,194,100,000	0001080034	0000051644	0000029989
1	AssetsNonCurrent	50,618,000	78,786,200	332,392,440	748,280,000	794,500,000	0001080034	0000029989	0000051644
2	IntangibleAssets	183,218,000	501,746,200	3,369,443,760	7,615,420,000	8,087,300,000	0001080034	0000051644	0000029989
3	PropertyPlantAndEquipment	12,414,000	56,602,600	454,339,800	633,400,000	653,300,000	0001080034	0000051644	0000029989
4	remainder_Assets	0	6,479,200	64,838,862	275,669,200	299,100,000	0000051644	0001080034	0000029989
5	LiabilitiesCurrent	103,258,000	867,022,200	7,741,556,440	10,694,880,000	11,023,100,000	0001080034	0000051644	0000029989
6	LiabilitiesNonCurrent	0	0	494,360	2,224,620,000	2,471,800,000	0000029989	0001080034	0000051644
7	remainder_Liabilities	0	0	7,534	33,901,200	37,668,000	0000029989	0000051644	0001080034
8	CostOfGoodsAndServicesSold	0	0	23,360	105,121,800	116,802,000	0000029989	0000051644	0001080034
9	SellingAndMarketingExpense	0	0	22,456	101,053,800	112,282,000	0000029989	0000051644	0001080034
10	GeneralAndAdministrativeExpense	0	5,353,600	53,897,753	1,681,423,600	1,862,300,000	0000029989	0001080034	0000051644
11	remainder_Expenses	69,778,000	108,820,200	460,966,400	3,909,000,000	4,292,200,000	0001080034	0000029989	0000051644
12	remainder_Revenues	0	43,079,800	432,018,220	5,921,789,800	6,531,900,000	0000029989	0001080034	0000051644
13	remainder_NetIncome	-96,200,000	-85,369,000	12,384,358	1,246,721,000	1,383,900,000	0000051644	0001080034	0000029989
14	remainder_ComprehensiveNetIncome	-86,500,000	-77,850,000	11,900	53,550,000	59,500,000	0000029989	0001080034	0000051644

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	613,567,000	1,859,290,300	13,072,099,060	18,916,570,000	19,566,100,000	0001080034	0000051644	0000029989
1	Liabilities	140,926,000	1,148,103,400	10,212,862,080	10,942,060,000	11,023,100,000	0001080034	0000051644	0000029989
2	Expenses	352,398,000	363,178,200	461,338,860	5,585,070,000	6,154,500,000	0001080034	0000029989	0000051644
3	Revenues	0	43,079,800	432,018,220	5,921,789,800	6,531,900,000	0000029989	0001080034	0000051644
4	StockholdersEquity	472,641,000	711,186,900	2,859,236,980	7,974,510,000	8,543,000,000	0001080034	0000051644	0000029989
5	NetIncome	90,510,000	109,579,000	281,328,500	859,450,000	923,700,000	0001080034	0000051644	0000029989
6	ComprehensiveNetIncome	90,510,000	115,529,000	340,799,300	787,550,000	837,200,000	0001080034	0000051644	0000029989
7	BaseVar	2,604,103,300	4,413,720,970	20,705,659,870	44,909,695,000	47,599,630,000	0001080034	0000029989	0000051644
8	EconomicCapitalRatio	0.687	0.768	1.50	3.76	4.01	0000051644	0000029989	0001080034

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	AssetsCurrent	-0.526	-0.482	-0.0829	0.451	0.510	0000051644	0001080034	0000029989
1	AssetsNonCurrent	-0.00513	-0.00486	-0.00251	0.00133	0.00176	0000051644	0000029989	0001080034
2	IntangibleAssets	-0.639	-0.582	-0.0667	0.413	0.467	0000051644	0001080034	0000029989
3	PropertyPlantAndEquipment	-0.0415	-0.0382	-0.00868	0.0268	0.0308	0000051644	0001080034	0000029989
4	remainder_Assets	-0.0933	-0.0837	0.00251	0.00970	0.0105	0000051644	0000029989	0001080034
5	LiabilitiesCurrent	-1.39	-1.18	0.713	3.16	3.43	0000029989	0000051644	0001080034
6	LiabilitiesNonCurrent	-0.377	-0.332	0.0667	0.426	0.466	0000051644	0000029989	0001080034
7	remainder_Liabilities	-0.285	-0.254	0.0187	0.0453	0.0483	0001080034	0000029989	0000051644
8	CostOfGoodsAndServicesSold	-1.16	-1.03	0.113	0.319	0.342	0001080034	0000029989	0000051644
9	SellingAndMarketingExpense	-1.11	-0.989	0.109	0.307	0.329	0001080034	0000029989	0000051644
10	GeneralAndAdministrativeExpense	-0.440	-0.399	-0.0256	0.133	0.151	0000051644	0001080034	0000029989
11	remainder_Expenses	-1.00	-0.884	0.183	0.700	0.758	0000051644	0000029989	0001080034
12	remainder_Revenues	-0.765	-0.605	0.832	2.33	2.50	0000029989	0000051644	0001080034
13	remainder_NetIncome	-0.716	-0.702	-0.576	0.240	0.331	0001080034	0000051644	0000029989
14	remainder_ComprehensiveNetIncome	-0.0243	-0.0181	0.0377	0.0496	0.0510	0000029989	0001080034	0000051644

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-1.08	-0.979	-0.114	1.11	1.25	0000051644	0001080034	0000029989
1	Liabilities	-1.26	-1.09	0.480	3.20	3.50	0000029989	0000051644	0001080034
2	Expenses	-1.53	-1.46	-0.771	0.423	0.556	0001080034	0000051644	0000029989
3	Revenues	-0.765	-0.605	0.832	2.33	2.50	0000029989	0000051644	0001080034
4	StockholdersEquity	-1.38	-1.29	-0.538	0.451	0.561	0000051644	0001080034	0000029989
5	NetIncome	-0.516	-0.452	0.123	0.232	0.245	0000051644	0000029989	0001080034
6	ComprehensiveNetIncome	-0.465	-0.408	0.0985	0.264	0.282	0000051644	0000029989	0001080034
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0000051644	0000029989
8	EconomicCapitalRatio	-1.38	-1.30	-0.568	1.70	1.95	0000051644	0000029989	0001080034

2011

Logs

error	8 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001088638 0001088638 0001299967 0001299967 0001201135 0001201135 0001346655 0001346655
error	7 × Unusually strong effect	check_effects	{'var_name': 'IntangibleAssets', 'quantile_value': '-11.0', 'quantile': 0.05} {'var_name': 'remainder_Assets', 'quantile_value': '-13.0', 'quantile': 0.05} {'var_name': 'remainder_Expenses', 'quantile_value': '-12.3', 'quantile': 0.05} {'var_name': 'Assets', 'quantile_value': '-19.2', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-15.7', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-15.7', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-19.6', 'quantile': 0.05}
error	1 × Negative Expenses, ignoring company.	pre-agg	0000875355
warning	6 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001088638 0001299967 0001201135 0001346655 0001424822 0001490281
warning	2 × Missing logo	subcommand.report	0001083243 0001091325
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -24.826894134310656}

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	AssetsCurrent	0	16,038	20,305,868	8,713,740,000	10,421,500,000	0001083243	0001078099	0000029989
1	AssetsNonCurrent	0	0	538,123	646,100,000	685,700,000	0000934796	0001078099	0000051644
2	IntangibleAssets	0	0	2,214,846	4,540,380,000	8,924,700,000	0000934796	0000829323	0000029989
3	PropertyPlantAndEquipment	0	0	3,558,363	504,420,000	682,900,000	0001083243	0001133311	0000029989
4	remainder_Assets	-24,600,000	-6,653,235	21,163	1,072,756,000	4,626,980,000	0001377630	0001495231	0001334978
5	LiabilitiesCurrent	5,366	110,761	9,386,181	8,760,280,000	11,671,000,000	0001083243	0000829323	0000029989
6	LiabilitiesNonCurrent	0	0	0	1,261,780,000	2,103,300,000	0000029989	0001080034	0000051644
7	remainder_Liabilities	0	0	0	145,234,800	181,702,000	0000029989	0000829323	0001080034
8	CostOfGoodsAndServicesSold	0	0	0	200,897,000	242,249,000	0000029989	0001078099	0001080034
9	SellingAndMarketingExpense	0	0	834	80,782,600	139,929,000	0000029989	0001534298	0001297336
10	GeneralAndAdministrativeExpense	0	0	4,795,428	560,276,800	1,924,300,000	0000029989	0001091325	0000051644
11	remainder_Expenses	0	0	16,343,968	6,247,700,000	12,865,300,000	0001083243	0001297336	0000029989
12	remainder_Revenues	0	0	11,889,203	8,386,180,000	13,872,500,000	0000876883	0001078099	0000029989
13	remainder_NetIncome	-73,700,000	-18,969,600	16,490	287,738,800	898,782,000	0001377630	0001534298	0000876883
14	remainder_ComprehensiveNetIncome	-193,100,000	-93,580,000	0	1,269,810	5,679,100	0000029989	0001297336	0001091325

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	259,908	315,555	106,900,108	14,402,360,000	20,505,400,000	0001534298	0001078099	0000029989
1	Liabilities	5,366	110,761	30,612,715	10,442,920,000	11,671,000,000	0001083243	0001133311	0000029989
2	Expenses	179,171	310,532	41,668,552	7,787,140,000	12,865,300,000	0001083243	0000829323	0000029989
3	Revenues	0	0	11,889,203	8,386,180,000	13,872,500,000	0000876883	0001078099	0000029989
4	StockholdersEquity	-346,800,000	-73,405,134	37,816,267	6,860,641,600	8,834,400,000	0001377630	0001133311	0000029989
5	NetIncome	-76,920,000	-25,596,654	-312,134	653,280,000	1,060,400,000	0000876883	0001534298	0000029989
6	ComprehensiveNetIncome	-85,184,000	-27,614,333	-312,134	614,660,000	867,300,000	0000876883	0001534298	0000029989
7	BaseVar	1,083,880	1,214,228	335,206,581	57,967,944,000	91,643,680,000	0001083243	0001091325	0000029989
8	EconomicCapitalRatio	-63.7	-24.8	0.776	3.53	3.76	0001428397	0000051644	0001091325

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	AssetsCurrent	-27.4	-8.13	-0.0886	0.650	1.09	0001428397	0001083243	0000051644
1	AssetsNonCurrent	-12.6	-3.83	-0.0912	0.406	2.03	0001428397	0000876883	0001377630
2	IntangibleAssets	-34.2	-11.0	-0.458	1.20	3.21	0001428397	0001377630	0001078099
3	PropertyPlantAndEquipment	-25.7	-7.89	-0.219	2.52	11.1	0001428397	0000029989	0001534298
4	remainder_Assets	-39.3	-13.0	-0.879	4.20	19.2	0001428397	0001133311	0001083243
5	LiabilitiesCurrent	-24.0	-5.80	0.362	4.66	5.78	0001428397	0001078099	0001419995
6	LiabilitiesNonCurrent	-19.5	-6.61	-0.0988	1.13	1.22	0001428397	0000934796	0001133311
7	remainder_Liabilities	-8.81	-2.55	0.0671	0.649	0.919	0001428397	0001083243	0001419995
8	CostOfGoodsAndServicesSold	-7.82	-6.81	0.402	2.12	3.55	0000829323	0000934796	0001428397
9	SellingAndMarketingExpense	-5.81	-4.73	0.187	2.28	3.24	0001133311	0001083243	0001428397
10	GeneralAndAdministrativeExpense	-8.92	-6.31	0.681	5.57	6.24	0001495231	0000876883	0000829323
11	remainder_Expenses	-42.1	-12.3	0.628	7.83	8.03	0001428397	0001377630	0001495231
12	remainder_Revenues	-14.5	-8.92	0.687	7.82	8.33	0001428397	0001091325	0001297336
13	remainder_NetIncome	-3.87	-3.86	-0.520	6.14	13.5	0001428397	0001334978	0001133311
14	remainder_ComprehensiveNetIncome	-0.386	-0.145	0.00150	0.270	0.276	0001377630	0001534298	0001091325

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-54.1	-19.2	-0.966	3.16	5.47	0001428397	0000876883	0001083243
1	Liabilities	-34.0	-8.54	0.216	3.34	4.16	0001428397	0001091325	0001419995
2	Expenses	-29.9	-9.93	0.726	1.50	1.85	0001428397	0000876883	0001377630
3	Revenues	-14.5	-8.92	0.687	7.82	8.33	0001428397	0001091325	0001297336
4	StockholdersEquity	-10.9	-7.20	-1.48	2.68	3.72	0001428397	0000876883	0001083243
5	NetIncome	-48.3	-15.7	1.93	6.87	6.93	0001428397	0001377630	0001133311
6	ComprehensiveNetIncome	-48.3	-15.7	2.02	6.87	6.93	0001428397	0000051644	0001133311
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001091325	0000029989
8	EconomicCapitalRatio	-58.4	-19.6	6.03	8.79	9.01	0001428397	0000051644	0001091325

2012

Logs

error	7 × Unusually strong effect	check_effects	{'var_name': 'remainder_Assets', 'quantile_value': '-10.3', 'quantile': 0.05} {'var_name': 'remainder_Expenses', 'quantile_value': '-15.1', 'quantile': 0.05} {'var_name': 'Assets', 'quantile_value': '-20.1', 'quantile': 0.05} {'var_name': 'Liabilities', 'quantile_value': '-10.7', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-11.6', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-11.6', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-18.3', 'quantile': 0.05}
error	4 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001299967 0001299967 0001539850 0001201135
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001509477
error	1 × Median ECR is negative	check_abs_values	{'median': -0.6318721553555173}
warning	5 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001299967 0001539850 0001538217 0001431880 0001424822
warning	3 × Missing logo	subcommand.report	0001083243 0001091325 0001297965
warning	2 × Similarly named company. Duplicate?	None	0001372375 0001527190
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -23.990757435686294}

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	AssetsCurrent	0	220	9,188,769	8,016,010,000	11,661,400,000	0001083243	0001091325	0000029989
1	AssetsNonCurrent	0	0	158,787	563,350,000	670,200,000	0000934796	0001084332	0000051644
2	IntangibleAssets	0	0	0	3,415,836,800	9,300,300,000	0000875355	0000875355	0000029989
3	PropertyPlantAndEquipment	0	0	260,285	468,612,829	723,800,000	0001083243	0000934796	0000029989
4	remainder_Assets	-25,700,000	-24,041,100	9,061	151,851,500	3,494,379,000	0001377630	0001495231	0001334978
5	LiabilitiesCurrent	0	7,201	4,383,476	7,012,670,500	11,875,800,000	0001491778	0000875355	0000029989
6	LiabilitiesNonCurrent	0	0	0	1,056,120,000	3,108,400,000	0000029989	0001084332	0000051644
7	remainder_Liabilities	0	0	0	82,221,000	159,546,000	0000029989	0000875355	0001080034
8	CostOfGoodsAndServicesSold	0	0	0	215,176,300	249,259,000	0000029989	0001133311	0001080034
9	SellingAndMarketingExpense	0	0	267,610	84,946,000	167,424,000	0000029989	0000934796	0001297336
10	GeneralAndAdministrativeExpense	0	0	2,095,031	76,992,100	1,886,000,000	0000029989	0000934796	0000051644
11	remainder_Expenses	0	8,500	5,176,513	4,444,448,800	13,122,000,000	0001083243	0001428397	0000029989
12	remainder_Revenues	0	0	4,987,722	6,555,274,400	14,219,400,000	0000934796	0001495231	0000029989
13	remainder_NetIncome	-108,466,000	-98,840,000	0	18,783,600	135,427,000	0001334978	0001491778	0001133311
14	remainder_ComprehensiveNetIncome	-80,200,000	-55,430,000	0	9,881,500	35,100,000	0000051644	0001329957	0001527190

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	2,202	84,962	31,847,951	12,855,088,200	22,151,900,000	0001329957	0000875355	0000029989
1	Liabilities	20,158	217,985	14,410,504	9,845,780,000	11,875,800,000	0001083243	0001084332	0000029989
2	Expenses	198,779	347,735	21,834,402	6,141,848,800	13,122,000,000	0001534298	0000875355	0000029989
3	Revenues	0	0	4,987,722	6,555,274,400	14,219,400,000	0000934796	0001495231	0000029989
4	StockholdersEquity	-524,200,000	-322,038,900	-19,717	5,933,319,300	10,276,100,000	0001527190	0001538217	0000029989
5	NetIncome	-159,210,000	-48,154,696	-1,258,753	428,311,600	1,117,500,000	0001334978	0001538217	0000029989
6	ComprehensiveNetIncome	-148,723,000	-48,154,696	-1,409,209	359,570,000	1,060,500,000	0001334978	0001431880	0000029989
7	BaseVar	965,641	1,532,392	136,492,436	47,121,023,150	93,785,650,000	0001534298	0000875355	0000029989
8	EconomicCapitalRatio	-33.9	-24.0	-0.632	3.12	3.18	0001428397	0001377630	0001334978

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	AssetsCurrent	-11.2	-7.44	-0.190	1.50	1.76	0001538217	0001083243	0001372375
1	AssetsNonCurrent	-7.27	-5.22	-0.113	1.69	3.25	0001538217	0000029989	0001431880
2	IntangibleAssets	-8.90	-6.61	-0.255	0.444	0.662	0001538217	0001297336	0000029989
3	PropertyPlantAndEquipment	-9.94	-7.81	-0.232	1.47	4.38	0001538217	0001527190	0001534298
4	remainder_Assets	-12.8	-10.3	-0.738	0.446	34.4	0001538217	0001431880	0001083243
5	LiabilitiesCurrent	-10.5	-2.47	0.463	9.04	22.1	0001538217	0001083243	0001329957
6	LiabilitiesNonCurrent	-8.38	-7.38	-0.196	1.34	1.50	0001538217	0001084332	0001297336
7	remainder_Liabilities	-5.42	-4.25	0.151	4.01	7.12	0001538217	0001091325	0001297965
8	CostOfGoodsAndServicesSold	-7.27	-5.93	0.600	1.64	2.36	0001538217	0001527190	0001428397
9	SellingAndMarketingExpense	-4.66	-4.26	0.210	1.59	3.37	0001297336	0001091325	0001538217
10	GeneralAndAdministrativeExpense	-11.5	-5.80	0.766	3.42	9.41	0001495231	0001377630	0001538217
11	remainder_Expenses	-21.2	-15.1	0.745	8.60	10.8	0001428397	0001091325	0001495231
12	remainder_Revenues	-8.21	-5.22	0.871	4.73	8.64	0001428397	0001377630	0001297336
13	remainder_NetIncome	-6.07	-1.56	-0.0989	3.00	10.6	0001329957	0001091325	0001133311
14	remainder_ComprehensiveNetIncome	-0.237	-0.0839	-0.00860	0.0616	0.277	0001377630	0001329957	0001527190

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-21.6	-20.1	-0.358	2.32	8.92	0001428397	0001431880	0001083243
1	Liabilities	-13.8	-10.7	0.793	6.69	7.49	0001538217	0001083243	0001419995
2	Expenses	-14.5	-9.73	0.273	2.08	2.40	0001428397	0000934796	0001527190
3	Revenues	-8.21	-5.22	0.871	4.73	8.64	0001428397	0001377630	0001297336
4	StockholdersEquity	-4.86	-4.42	-0.717	2.98	3.93	0001329957	0001534298	0001083243
5	NetIncome	-22.9	-11.6	1.15	7.17	10.1	0001428397	0001091325	0001297336
6	ComprehensiveNetIncome	-22.9	-11.6	1.21	7.20	10.1	0001428397	0001091325	0001297336
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001329957	0000029989
8	EconomicCapitalRatio	-28.2	-18.3	5.08	8.83	8.89	0001428397	0001377630	0001334978

2013

Logs

error	3 × Unusually strong effect	check_effects	{'var_name': 'NetIncome', 'quantile_value': '-10.9', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-10.9', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-12.7', 'quantile': 0.05}
error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001539850 0001299967 0001329957
warning	4 × Similarly named company. Duplicate?	None	0001442376 0001372375 0001527190 0001084332
warning	3 × Missing logo	subcommand.report	0001080627 0001091325 0001297965
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001539850 0001475274
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -16.083091092558057}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001201135
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001392694
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001392694

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	AssetsCurrent	726	21,792	21,990,253	5,688,049,800	11,652,300,000	0001392694	0000875355	0000029989
1	AssetsNonCurrent	0	0	120,453	749,370,000	1,920,425,000	0000934796	0001078099	0001334978
2	IntangibleAssets	0	0	0	3,030,120,950	9,302,000,000	0000875355	0001495231	0000029989
3	PropertyPlantAndEquipment	0	0	3,131,294	426,822,841	737,400,000	0001297965	0001375796	0000029989
4	remainder_Assets	-205,858,000	-43,731,100	250,203	126,467,750	1,682,622,000	0001372375	0001084267	0001334978
5	LiabilitiesCurrent	0	288,097	19,276,696	5,578,201,500	12,277,700,000	0001491778	0001080627	0000029989
6	LiabilitiesNonCurrent	0	0	0	1,009,835,000	2,239,800,000	0000029989	0001080627	0000051644
7	remainder_Liabilities	0	0	0	83,765,050	165,963,000	0000029989	0000875355	0001080034
8	CostOfGoodsAndServicesSold	0	0	373,988	173,304,200	256,450,000	0000029989	0001428397	0001297336
9	SellingAndMarketingExpense	0	0	256,616	87,886,650	182,854,000	0000029989	0001442376	0001297336
10	GeneralAndAdministrativeExpense	0	0	2,977,606	62,704,800	1,917,900,000	0000029989	0000875355	0000051644
11	remainder_Expenses	0	307,110	9,084,034	4,178,058,850	13,521,600,000	0001495231	0001091325	0000029989
12	remainder_Revenues	0	0	22,824,711	5,660,661,500	14,584,500,000	0000934796	0000875355	0000029989
13	remainder_NetIncome	-128,200,000	-47,240,000	-215,903	66,506,750	140,832,000	0000051644	0001442376	0001133311
14	remainder_ComprehensiveNetIncome	-182,600,000	-123,725,000	0	4,099,134	10,300,000	0000029989	0001442376	0001527190

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	2,794	21,792	100,636,800	10,754,037,200	22,098,700,000	0001392694	0001491778	0000029989
1	Liabilities	781,750	820,155	30,358,138	7,188,005,000	12,277,700,000	0001297965	0001375796	0000029989
2	Expenses	37,912	1,091,240	39,709,976	5,424,693,850	13,521,600,000	0001392694	0001078099	0000029989
3	Revenues	0	0	22,824,711	5,660,661,500	14,584,500,000	0000934796	0000875355	0000029989
4	StockholdersEquity	-299,200,000	-101,436,500	8,968,887	4,765,736,300	9,821,000,000	0001527190	0001080627	0000029989
5	NetIncome	-32,989,000	-21,535,939	-2,854,197	244,800,000	1,111,600,000	0001491778	0001442376	0000029989
6	ComprehensiveNetIncome	-49,433,000	-31,773,100	-3,210,780	163,225,000	929,000,000	0001334978	0001419995	0000029989
7	BaseVar	600,828	5,330,662	338,278,046	40,527,995,290	96,532,920,000	0001392694	0001091325	0000029989
8	EconomicCapitalRatio	-25.3	-16.1	0.189	3.39	3.69	0001297965	0001527190	0001475274

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	AssetsCurrent	-8.35	-4.60	-0.0943	0.771	1.08	0001297965	0000934796	0001375796
1	AssetsNonCurrent	-3.91	-3.01	-0.189	1.28	1.94	0001297965	0001392694	0001377630
2	IntangibleAssets	-5.85	-4.51	-0.274	0.530	2.44	0001297965	0001392694	0001078099
3	PropertyPlantAndEquipment	-6.03	-3.92	-0.337	1.24	2.96	0001297965	0001415624	0001091325
4	remainder_Assets	-1.20	-0.565	-0.0393	1.75	17.5	0001297965	0001297336	0001428397
5	LiabilitiesCurrent	-5.16	-4.18	1.30	4.65	6.09	0001084267	0001133311	0001392694
6	LiabilitiesNonCurrent	-3.89	-3.34	0.0919	0.964	1.36	0001527190	0001080627	0001297336
7	remainder_Liabilities	-1.91	-1.54	0.154	0.667	148	0001297965	0000051644	0001431880
8	CostOfGoodsAndServicesSold	-5.98	-3.32	0.423	2.03	2.53	0001297336	0000934796	0001491778
9	SellingAndMarketingExpense	-4.84	-3.29	0.150	1.20	1.80	0001297336	0001080627	0001084267
10	GeneralAndAdministrativeExpense	-7.88	-1.84	0.289	1.47	2.52	0001495231	0001377630	0001084267
11	remainder_Expenses	-14.8	-8.53	0.585	6.10	9.38	0001297965	0001527190	0001297336
12	remainder_Revenues	-6.41	-4.88	1.03	4.17	8.33	0001297965	0001078099	0001297336
13	remainder_NetIncome	-2.18	-1.39	0.131	0.566	8.87	0001431880	0001475274	0001133311
14	remainder_ComprehensiveNetIncome	-0.746	-0.275	0.0437	0.105	0.139	0001375796	0001431880	0001091325

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-15.4	-8.72	-0.597	2.35	3.69	0001297965	0001415624	0001080627
1	Liabilities	-5.93	-5.01	1.69	4.09	4.44	0001084267	0001133311	0001392694
2	Expenses	-10.6	-7.99	0.255	1.45	1.58	0001297965	0001415624	0001527190
3	Revenues	-6.41	-4.88	1.03	4.17	8.33	0001297965	0001078099	0001297336
4	StockholdersEquity	-4.19	-3.82	1.32	3.31	3.53	0001392694	0000029989	0001334978
5	NetIncome	-16.5	-10.9	1.64	4.33	8.69	0001297965	0001377630	0001297336
6	ComprehensiveNetIncome	-16.5	-10.9	1.46	4.39	8.73	0001297965	0001377630	0001297336
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001297965	0000029989
8	EconomicCapitalRatio	-21.9	-12.7	3.53	6.73	7.03	0001297965	0001527190	0001475274

2014

Logs

error	6 × Unusually strong effect	check_effects	{'var_name': 'GeneralAndAdministrativeExpense', 'quantile_value': '-10.5', 'quantile': 0.05} {'var_name': 'remainder_Expenses', 'quantile_value': '-12.3', 'quantile': 0.05} {'var_name': 'Assets', 'quantile_value': '-15.1', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-15.3', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-15.3', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-18.7', 'quantile': 0.05}
error	1 × Negative Expenses, ignoring company.	pre-agg	0001591877
error	1 × Median ECR is negative	check_abs_values	{'median': -0.6934038943396227}
warning	4 × Similarly named company. Duplicate?	None	0001442376 0001372375 0001084332 0001509477
warning	4 × Missing logo	subcommand.report	0001080627 0001091325 0001297965 0001516079
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -24.52608089660138}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001201135
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001392694
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001392694

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	AssetsCurrent	0	2.40	6,268,617	2,683,103,200	11,190,500,000	0001516079	0001460329	0000029989
1	AssetsNonCurrent	0	0	33,785	385,040,000	1,747,280,000	0001080627	0001084267	0001334978
2	IntangibleAssets	0	0	105	2,240,928,000	9,211,600,000	0000875355	0001579717	0000029989
3	PropertyPlantAndEquipment	0	0	592,080	255,620,000	708,000,000	0001088638	0001495231	0000029989
4	remainder_Assets	-199,892,000	-11,370,600	94,604	286,360,000	1,651,322,000	0001372375	0001084267	0001334978
5	LiabilitiesCurrent	0	0	5,001,932	2,553,136,800	12,061,100,000	0001460329	0001084332	0000029989
6	LiabilitiesNonCurrent	0	0	0	266,718,000	2,875,300,000	0000029989	0001084332	0000051644
7	remainder_Liabilities	0	0	0	45,980,800	192,561,000	0000029989	0001080627	0000876883
8	CostOfGoodsAndServicesSold	0	0	71,789	317,376,800	1,642,502,000	0000029989	0001588014	0001490281
9	SellingAndMarketingExpense	0	0	0	199,984,600	436,000,000	0000029989	0000876883	0001556739
10	GeneralAndAdministrativeExpense	0	0	2,399,841	189,214,600	1,928,100,000	0000029989	0001559754	0000051644
11	remainder_Expenses	-2,744,000	-8,200	6,121,343	3,431,861,600	14,144,000,000	0001133311	0000875355	0000029989
12	remainder_Revenues	0	0	5,123,524	4,060,770,400	15,317,800,000	0000876883	0001538217	0000029989
13	remainder_NetIncome	-354,000,000	-39,982,400	-6,127	93,963,600	1,131,018,000	0001556739	0001392694	0000876883
14	remainder_ComprehensiveNetIncome	-555,700,000	-174,352,000	0	55,113	1,762,000	0000029989	0000875355	0001490281

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	3.00	2,118	28,223,292	7,639,368,800	21,559,700,000	0001297965	0001538217	0000029989
1	Liabilities	26,107	130,088	5,985,960	3,509,735,200	12,061,100,000	0001579717	0000875355	0000029989
2	Expenses	51,353	94,095	13,229,308	3,970,843,200	14,144,000,000	0001392694	0001084267	0000029989
3	Revenues	0	0	5,123,524	4,060,770,400	15,317,800,000	0000876883	0001538217	0000029989
4	StockholdersEquity	-153,629,000	-7,442,902	5,758,601	3,055,796,400	9,498,600,000	0000876883	0001538217	0000029989
5	NetIncome	-371,000,000	-80,952,600	-2,451,085	122,652,000	1,233,100,000	0001556739	0001297965	0000029989
6	ComprehensiveNetIncome	-422,000,000	-139,769,600	-3,523,735	69,108,000	677,400,000	0001556739	0001080627	0000029989
7	BaseVar	187,719	554,895	89,513,022	27,402,609,120	101,025,440,000	0001579717	0001495231	0000029989
8	EconomicCapitalRatio	-47.2	-24.5	-0.693	3.22	3.48	0001516079	0001491778	0001475274

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	AssetsCurrent	-22.6	-9.98	-0.209	1.41	2.22	0001516079	0001091325	0001460329
1	AssetsNonCurrent	-5.60	-2.57	-0.180	0.860	3.51	0001516079	0001490281	0001372375
2	IntangibleAssets	-13.4	-5.93	-0.319	1.17	1.55	0001516079	0001415624	0001372375
3	PropertyPlantAndEquipment	-15.4	-6.62	-0.378	0.499	3.52	0001516079	0001375796	0001091325
4	remainder_Assets	-7.74	-3.52	-0.156	3.05	9.79	0001516079	0000876883	0001428397
5	LiabilitiesCurrent	-15.2	-6.58	0.971	6.68	12.7	0001516079	0001460329	0001297965
6	LiabilitiesNonCurrent	-5.71	-2.02	0.0388	0.442	0.542	0001516079	0001080627	0001495231
7	remainder_Liabilities	-8.47	-2.86	0.0606	1.42	30.4	0001516079	0001588014	0001559754
8	CostOfGoodsAndServicesSold	-6.03	-3.48	0.236	2.68	12.5	0001297336	0001080627	0001346655
9	SellingAndMarketingExpense	-5.15	-3.06	0.239	1.24	6.27	0001297336	0001538217	0001346655
10	GeneralAndAdministrativeExpense	-16.0	-10.5	0.755	3.35	4.38	0001516079	0001538217	0001084267
11	remainder_Expenses	-18.1	-12.3	0.625	5.65	8.09	0001346655	0001392694	0001297336
12	remainder_Revenues	-11.1	-5.68	0.699	5.75	26.6	0001516079	0001442376	0001346655
13	remainder_NetIncome	-5.55	-3.45	0.0562	4.07	11.0	0001539850	0001088638	0001133311
14	remainder_ComprehensiveNetIncome	-0.224	-0.184	0.0319	0.122	0.839	0001556739	0001088638	0001509477

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-33.5	-15.1	-0.799	2.96	3.88	0001516079	0001490281	0001091325
1	Liabilities	-20.9	-7.03	0.791	4.98	8.15	0001516079	0000029989	0001297965
2	Expenses	-19.9	-6.99	0.765	2.18	2.43	0001516079	0001392694	0001495231
3	Revenues	-11.1	-5.68	0.699	5.75	26.6	0001516079	0001442376	0001346655
4	StockholdersEquity	-4.21	-3.95	0.534	3.24	3.53	0001392694	0001539850	0001078099
5	NetIncome	-30.8	-15.3	2.64	8.49	27.6	0001516079	0001078099	0001346655
6	ComprehensiveNetIncome	-30.7	-15.3	2.63	8.53	27.8	0001516079	0000051644	0001346655
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001375796	0000029989
8	EconomicCapitalRatio	-41.4	-18.7	5.11	9.02	9.28	0001516079	0001491778	0001475274

2015

Logs

error	4 × Unusually strong effect	check_effects	{'var_name': 'Assets', 'quantile_value': '-11.9', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-12.1', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-12.0', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-16.0', 'quantile': 0.05}
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001211211 0001201135
error	1 × Median ECR is negative	check_abs_values	{'median': -0.25006426064927784}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -19.655227249244177}
warning	1 × Similarly named company. Duplicate?	None	0001527190
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001211211
warning	1 × Missing logo	subcommand.report	0001091325

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	AssetsCurrent	0	81,756	13,690,503	1,096,401,300	11,980,500,000	0001580264	0001495231	0000029989
1	AssetsNonCurrent	0	0	117,791	761,370,000	1,540,317,000	0001091325	0001078099	0001334978
2	IntangibleAssets	0	0	722,666	1,375,653,450	9,021,200,000	0000875355	0001491778	0000029989
3	PropertyPlantAndEquipment	0	0	862,649	126,882,711	692,700,000	0001334978	0001460329	0000029989
4	remainder_Assets	-32,344,000	-25,100,000	15,611	114,480,250	1,509,769,000	0001375796	0001428397	0001334978
5	LiabilitiesCurrent	0	0	7,862,156	917,017,950	14,219,600,000	0001428397	0001084332	0000029989
6	LiabilitiesNonCurrent	0	0	2,515	868,474,350	1,130,800,000	0000029989	0001115128	0001377630
7	remainder_Liabilities	0	0	39,760	103,597,550	309,285,000	0000029989	0001559754	0000876883
8	CostOfGoodsAndServicesSold	0	0	337,884	93,756,750	99,266,000	0000029989	0001442376	0001375796
9	SellingAndMarketingExpense	0	0	0	86,418,600	99,380,000	0000029989	0000876883	0001475274
10	GeneralAndAdministrativeExpense	0	0	2,956,092	47,076,800	322,207,000	0000029989	0000875355	0000876883
11	remainder_Expenses	-5,489,000	64,374	10,507,419	2,042,345,100	13,979,000,000	0001460329	0001415624	0000029989
12	remainder_Revenues	0	0	14,301,275	1,744,337,200	15,134,400,000	0000876883	0001091325	0000029989
13	remainder_NetIncome	-66,500,000	-54,999,900	-7,524	97,828,350	1,231,507,000	0001377630	0001580264	0000876883
14	remainder_ComprehensiveNetIncome	-506,700,000	-95,939,200	0	967,749	4,955,000	0000029989	0001442376	0000876883

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	85,637	162,788	30,231,909	4,212,071,950	22,110,700,000	0001615780	0000875355	0000029989
1	Liabilities	284,711	998,476	13,322,157	1,669,518,600	14,219,600,000	0001580264	0000829323	0000029989
2	Expenses	215,700	494,735	28,470,688	2,187,338,250	13,979,000,000	0001615780	0001538217	0000029989
3	Revenues	0	0	14,301,275	1,744,337,200	15,134,400,000	0000876883	0001091325	0000029989
4	StockholdersEquity	-417,602,000	-223,840,000	-232,230	3,211,247,350	7,891,100,000	0000876883	0001580264	0000029989
5	NetIncome	-84,535,000	-58,672,900	-1,195,601	76,790,000	1,203,400,000	0001460329	0001442376	0000029989
6	ComprehensiveNetIncome	-206,552,000	-66,016,600	-1,195,601	56,115,000	696,700,000	0001334978	0001442376	0000029989
7	BaseVar	1,024,130	2,477,753	267,296,843	15,129,108,410	101,235,830,000	0001580264	0001091325	0000029989
8	EconomicCapitalRatio	-39.5	-19.7	-0.250	3.11	4.19	0001539850	0001377630	0001078099

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	AssetsCurrent	-16.9	-5.62	-0.131	1.23	1.48	0001539850	0001527190	0001495231
1	AssetsNonCurrent	-10.7	-3.33	-0.310	1.24	2.33	0001539850	0001442376	0001377630
2	IntangibleAssets	-17.7	-5.79	-0.515	1.49	2.66	0001539850	0001133311	0001460329
3	PropertyPlantAndEquipment	-12.1	-3.88	-0.225	0.538	3.28	0001539850	0000876883	0001091325
4	remainder_Assets	-7.95	-2.39	-0.163	1.55	5.73	0001539850	0001133311	0001580264
5	LiabilitiesCurrent	-19.6	-6.53	0.812	5.12	13.0	0001539850	0001442376	0001559754
6	LiabilitiesNonCurrent	-15.1	-5.04	0.125	1.35	1.52	0001539850	0001475274	0001133311
7	remainder_Liabilities	-5.63	-2.10	0.0758	0.699	41.8	0001539850	0001377630	0001428397
8	CostOfGoodsAndServicesSold	-4.29	-3.22	0.508	2.28	5.61	0001509477	0001615780	0001539850
9	SellingAndMarketingExpense	-6.80	-2.16	0.308	1.80	3.03	0001133311	0001559754	0001539850
10	GeneralAndAdministrativeExpense	-3.32	-2.78	0.456	1.62	3.34	0001346655	0000875355	0000829323
11	remainder_Expenses	-28.7	-8.01	0.398	4.98	5.29	0001539850	0001538217	0001133311
12	remainder_Revenues	-7.22	-5.65	0.961	4.01	7.10	0001133311	0001392694	0000829323
13	remainder_NetIncome	-1.77	-1.61	0.0255	2.35	12.5	0001559754	0001580264	0001133311
14	remainder_ComprehensiveNetIncome	-0.211	-0.164	0.0404	0.151	1.00	0001377630	0000876883	0001509477

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-30.2	-11.9	-0.752	2.38	5.34	0001539850	0001133311	0001460329
1	Liabilities	-24.2	-6.24	0.776	4.06	8.35	0001539850	0001509477	0001559754
2	Expenses	-18.8	-8.11	0.254	1.34	1.40	0001539850	0001559754	0001377630
3	Revenues	-7.22	-5.65	0.961	4.01	7.10	0001133311	0001392694	0000829323
4	StockholdersEquity	-3.89	-3.04	0.0346	3.28	3.79	0001559754	0001491778	0001078099
5	NetIncome	-26.6	-12.1	1.84	5.57	7.42	0001539850	0001527190	0000829323
6	ComprehensiveNetIncome	-26.4	-12.0	1.87	5.57	7.52	0001539850	0001334978	0000829323
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001375796	0000029989
8	EconomicCapitalRatio	-35.8	-16.0	3.39	6.74	7.83	0001539850	0001377630	0001078099

2016

Logs

error	3 × Unusually strong effect	check_effects	{'var_name': 'NetIncome', 'quantile_value': '-12.0', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-11.7', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-13.2', 'quantile': 0.05}
error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001211211 0001663641 0000829323
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001648365
error	1 × Median ECR is negative	check_abs_values	{'median': -0.22210402403237842}
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001211211 0001334978 0001495231
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -16.613841947381413}
warning	1 × Similarly named company. Duplicate?	None	0001527190
warning	1 × Missing logo	subcommand.report	0001516079

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	AssetsCurrent	0	23,415	23,988,662	952,195,200	12,722,000,000	0001516079	0000875355	0000029989
1	AssetsNonCurrent	0	0	43,521	552,000,800	836,300,000	0000934796	0001084267	0001377630
2	IntangibleAssets	0	0	1,084,148	688,648,800	9,403,500,000	0000875355	0001392694	0000029989
3	PropertyPlantAndEquipment	0	0	1,353,024	146,036,000	674,800,000	0001516079	0001460329	0000029989
4	remainder_Assets	-420,943,000	-29,600,000	5,144	111,652,400	147,113,000	0001576427	0001609139	0001490281
5	LiabilitiesCurrent	0	93,262	13,262,496	1,048,959,000	14,010,900,000	0001491778	0001084267	0000029989
6	LiabilitiesNonCurrent	0	0	0	965,052,000	1,118,000,000	0000029989	0001133311	0001377630
7	remainder_Liabilities	-686,000	0	0	114,177,600	231,633,000	0001576427	0001078099	0000876883
8	CostOfGoodsAndServicesSold	0	0	219,695	105,117,200	1,786,451,000	0000029989	0001343465	0001490281
9	SellingAndMarketingExpense	0	0	1,191,350	208,995,400	362,951,000	0000029989	0000875355	0001490281
10	GeneralAndAdministrativeExpense	0	0	1,868,292	92,119,000	306,251,000	0000029989	0001084332	0000876883
11	remainder_Expenses	0	69,016	8,963,084	1,227,036,600	14,218,200,000	0001495231	0001084267	0000029989
12	remainder_Revenues	0	0	3,307,001	2,605,670,800	15,416,900,000	0000876883	0001392694	0000029989
13	remainder_NetIncome	-87,371,000	-6,424,013	-23,933	354,140,000	1,287,329,000	0001490281	0000875355	0000876883
14	remainder_ComprehensiveNetIncome	-438,700,000	-20,025,000	0	147,989	6,846,000	0000029989	0001495231	0001490281

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	2,855	26,632	28,298,846	1,687,777,400	23,165,400,000	0001516079	0000875355	0000029989
1	Liabilities	30,666	388,468	14,411,182	1,814,530,400	14,010,900,000	0001516079	0001078099	0000029989
2	Expenses	56,969	506,881	34,803,071	2,634,850,400	14,218,200,000	0001516079	0001495231	0000029989
3	Revenues	0	0	3,307,001	2,605,670,800	15,416,900,000	0000876883	0001392694	0000029989
4	StockholdersEquity	-449,296,000	-226,620,000	1,286,388	556,169,800	9,154,500,000	0000876883	0001580264	0000029989
5	NetIncome	-194,587,000	-36,007,000	-1,857,892	100,530,000	1,246,700,000	0001490281	0001343465	0000029989
6	ComprehensiveNetIncome	-187,741,000	-43,986,400	-1,857,892	90,726,400	808,000,000	0001490281	0001343465	0000029989
7	BaseVar	176,274	2,685,356	238,126,776	16,199,560,600	102,929,190,000	0001516079	0001538217	0000029989
8	EconomicCapitalRatio	-22.6	-16.6	-0.222	2.83	6.03	0001516079	0001538217	0001078099

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	AssetsCurrent	-6.36	-4.66	-0.213	1.24	1.61	0001516079	0001460329	0000875355
1	AssetsNonCurrent	-3.63	-2.59	-0.295	1.21	2.28	0001509477	0001133311	0001377630
2	IntangibleAssets	-5.32	-4.02	-0.380	1.07	2.63	0001509477	0000875355	0001343465
3	PropertyPlantAndEquipment	-1.05	-0.860	-0.00977	0.369	1.24	0001516079	0000029989	0001491778
4	remainder_Assets	-2.27	-0.977	-0.147	1.33	49.2	0001509477	0000876883	0001580264
5	LiabilitiesCurrent	-5.93	-3.74	1.49	5.51	7.30	0001580264	0001490281	0001615780
6	LiabilitiesNonCurrent	-3.51	-3.15	0.460	1.30	1.67	0001527190	0001343465	0001609139
7	remainder_Liabilities	-3.35	-0.757	0.0300	0.333	0.786	0001491778	0001377630	0001580264
8	CostOfGoodsAndServicesSold	-4.53	-3.90	0.289	2.43	3.10	0001509477	0000934796	0001133311
9	SellingAndMarketingExpense	-7.76	-2.54	0.282	1.95	2.37	0001133311	0001615780	0001509477
10	GeneralAndAdministrativeExpense	-16.9	-1.72	0.301	2.02	3.69	0001516079	0001491778	0001609139
11	remainder_Expenses	-13.5	-5.64	0.159	5.35	7.11	0001580264	0000934796	0001495231
12	remainder_Revenues	-8.52	-5.84	1.58	4.77	8.48	0001133311	0001475274	0001609139
13	remainder_NetIncome	-3.22	-2.21	-0.650	3.08	14.3	0001392694	0001516079	0001133311
14	remainder_ComprehensiveNetIncome	-0.141	-0.0934	0.00483	0.0329	0.680	0001576427	0001415624	0001509477

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-10.4	-9.27	-0.660	1.27	1.85	0001516079	0001133311	0001377630
1	Liabilities	-6.60	-4.91	1.80	4.24	5.56	0001509477	0000875355	0001615780
2	Expenses	-9.37	-8.11	0.388	1.14	2.05	0001580264	0001115128	0001078099
3	Revenues	-8.52	-5.84	1.58	4.77	8.48	0001133311	0001475274	0001609139
4	StockholdersEquity	-3.96	-3.32	1.91	4.27	4.46	0000934796	0001509477	0001115128
5	NetIncome	-16.2	-12.0	1.76	5.93	8.35	0001580264	0001527190	0001609139
6	ComprehensiveNetIncome	-16.2	-11.7	1.76	5.89	8.37	0001580264	0001527190	0001609139
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001442376	0000029989
8	EconomicCapitalRatio	-19.2	-13.2	3.17	6.22	9.42	0001516079	0001538217	0001078099

2017

Logs

error	4 × Unusually strong effect	check_effects	{'var_name': 'Assets', 'quantile_value': '-14.8', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-15.1', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-15.1', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-20.9', 'quantile': 0.05}
error	3 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001211211 0001663641 0001088638
error	1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company.	pre-agg	0001343465
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001696195 0001084332
warning	2 × Missing logo	subcommand.report	0001516079 0001705110
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -25.527632881860264}
warning	1 × Similarly named company. Duplicate?	None	0001527190

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	AssetsCurrent	0	18,557	15,250,343	1,048,243,700	14,116,000,000	0001516079	0000829323	0000029989
1	AssetsNonCurrent	0	0	35,530	692,669,900	935,500,000	0000934796	0001084332	0001377630
2	IntangibleAssets	0	0	24,262	1,041,119,900	9,705,900,000	0000875355	0001509477	0000029989
3	PropertyPlantAndEquipment	0	0	1,779,374	158,560,100	690,900,000	0001084267	0001460329	0000029989
4	remainder_Assets	-494,787,000	-30,700,000	6,051	111,122,100	135,189,000	0001576427	0001516079	0001490281
5	LiabilitiesCurrent	14,151	510,581	11,575,529	1,026,138,300	15,108,900,000	0001516079	0000934796	0000029989
6	LiabilitiesNonCurrent	0	0	136	933,461,200	1,039,600,000	0000029989	0001084267	0001377630
7	remainder_Liabilities	-2,497,000	-1,632,330	0	43,727,100	78,973,000	0001576427	0001084267	0000876883
8	CostOfGoodsAndServicesSold	0	0	27,848	109,527,263	1,510,016,000	0000029989	0001588014	0001490281
9	SellingAndMarketingExpense	0	0	2,283	394,837,300	464,040,000	0000029989	0001516079	0001705110
10	GeneralAndAdministrativeExpense	0	0	2,198,836	248,426,200	310,455,000	0000029989	0001084332	0000876883
11	remainder_Expenses	800	196,130	12,351,620	1,451,256,700	14,134,600,000	0001516079	0001133311	0000029989
12	remainder_Revenues	0	0	3,753,024	2,679,721,500	15,273,600,000	0000876883	0001509477	0000029989
13	remainder_NetIncome	-10,688,000	-9,029,100	3.40	394,880,000	1,470,979,000	0001460329	0001538217	0000876883
14	remainder_ComprehensiveNetIncome	-15,505,000	-8,854,961	0	51,243,500	289,200,000	0000876883	0001084332	0000029989

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	6,041	44,500	23,643,769	1,692,475,900	24,931,200,000	0001516079	0001538217	0000029989
1	Liabilities	14,151	517,811	11,576,638	1,681,761,300	15,108,900,000	0001516079	0000934796	0000029989
2	Expenses	44,799	326,082	30,097,773	2,632,539,900	14,134,600,000	0001516079	0001538217	0000029989
3	Revenues	0	0	3,753,024	2,679,721,500	15,273,600,000	0000876883	0001509477	0000029989
4	StockholdersEquity	-116,000,000	-68,269,126	619,238	1,176,664,100	9,822,300,000	0001527190	0001392694	0000029989
5	NetIncome	-104,527,000	-61,176,009	-728,298	210,626,100	1,192,200,000	0001705110	0001539850	0000029989
6	ComprehensiveNetIncome	-99,165,000	-61,963,186	-728,298	219,472,400	1,481,400,000	0001705110	0001539850	0000029989
7	BaseVar	135,533	1,862,026	165,375,504	16,391,982,650	103,321,730,000	0001516079	0001538217	0000029989
8	EconomicCapitalRatio	-26.6	-25.5	0.0103	2.43	2.69	0001516079	0001377630	0001705110

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	AssetsCurrent	-10.4	-9.92	-0.251	2.14	3.48	0001588014	0001078099	0001648365
1	AssetsNonCurrent	-5.03	-4.79	-0.271	1.64	2.49	0001084332	0001078099	0001377630
2	IntangibleAssets	-6.32	-5.96	-0.289	1.72	2.03	0001084332	0001648365	0001705110
3	PropertyPlantAndEquipment	-2.14	-1.97	-0.0650	0.0506	1.52	0001516079	0001648365	0001615780
4	remainder_Assets	-3.21	-2.88	-0.137	3.35	7.78	0001084332	0001527190	0001516079
5	LiabilitiesCurrent	-8.26	-6.73	0.934	2.98	4.39	0001084332	0000876883	0000934796
6	LiabilitiesNonCurrent	-4.62	-4.47	0.0324	1.13	1.28	0001588014	0001615780	0001576427
7	remainder_Liabilities	-0.862	-0.796	0.0376	0.332	0.501	0001516079	0001377630	0001609139
8	CostOfGoodsAndServicesSold	-5.49	-5.43	0.434	2.03	2.30	0001509477	0001527190	0001133311
9	SellingAndMarketingExpense	-7.00	-2.47	0.253	1.63	1.89	0001133311	0001084332	0001509477
10	GeneralAndAdministrativeExpense	-21.3	-5.65	0.496	2.83	3.57	0001516079	0001377630	0000829323
11	remainder_Expenses	-12.0	-4.09	-0.227	6.28	6.67	0001588014	0000876883	0001495231
12	remainder_Revenues	-6.65	-5.61	0.308	6.10	7.38	0001133311	0001375796	0000829323
13	remainder_NetIncome	-11.5	-1.91	-0.728	3.60	13.1	0001084267	0001539850	0001133311
14	remainder_ComprehensiveNetIncome	-0.101	-0.0949	-0.0394	0.228	2.13	0001490281	0001460329	0001509477

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-15.9	-14.8	-0.292	1.68	2.05	0001588014	0000875355	0001648365
1	Liabilities	-9.79	-9.25	0.846	3.35	3.57	0001084332	0000029989	0001576427
2	Expenses	-11.6	-9.09	0.486	1.29	1.36	0001516079	0001084267	0000876883
3	Revenues	-6.65	-5.61	0.308	6.10	7.38	0001133311	0001375796	0000829323
4	StockholdersEquity	-4.01	-2.53	1.16	3.64	4.13	0000934796	0001392694	0001705110
5	NetIncome	-18.6	-15.1	1.90	6.66	7.54	0001516079	0001527190	0001133311
6	ComprehensiveNetIncome	-18.6	-15.1	1.89	6.76	7.50	0001516079	0001527190	0001133311
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001460329	0000029989
8	EconomicCapitalRatio	-21.9	-20.9	4.68	7.10	7.36	0001516079	0001377630	0001705110

2018

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001703625 0001663641
error	1 × Unusually strong effect	check_effects	{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-10.5', 'quantile': 0.05}
error	1 × Median ECR is negative	check_abs_values	{'median': -0.518420454430493}
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001703625 0001696195 0001084332
warning	2 × Missing logo	subcommand.report	0001516079 0001705110
warning	1 × equityII differs from equityI	pre-agg	0001588014
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 4.531031319250838}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -13.188099958817597}
warning	1 × Similarly named company. Duplicate?	None	0001527190
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001377630
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	44,199	67,389	8,416,171	975,956,700	13,726,900,000	0001539850	0001495231	0000029989
1	AssetsNonCurrent	0	0	44,612	704,569,400	910,900,000	0000934796	0001538217	0001377630
2	IntangibleAssets	0	0	347,741	1,062,404,600	9,767,100,000	0000875355	0001588014	0000029989
3	PropertyPlantAndEquipment	0	0	872,257	169,699,400	694,400,000	0001516079	0001460329	0000029989
4	remainder_Assets	-608,930,000	-33,600,000	0	92,686,950	120,900,000	0001576427	0001084332	0000029989
5	LiabilitiesCurrent	18,153	139,517	13,834,848	882,050,700	15,270,200,000	0001516079	0001495231	0000029989
6	LiabilitiesNonCurrent	0	0	3,020	979,150,300	1,120,500,000	0000029989	0001588014	0001377630
7	remainder_Liabilities	-10,770,000	-1,520,891	0	44,567,750	56,096,000	0001576427	0001084332	0000876883
8	CostOfGoodsAndServicesSold	0	0	2,664,094	1,327,967,850	12,437,300,000	0000934796	0001538217	0000029989
9	SellingAndMarketingExpense	0	0	62,662	387,676,500	541,469,000	0000029989	0001588014	0001705110
10	GeneralAndAdministrativeExpense	0	0	985,522	257,555,950	349,056,000	0000029989	0001588014	0000876883
11	remainder_Expenses	0	34,073	13,225,262	690,417,050	1,478,500,000	0001588014	0001375796	0000029989
12	remainder_Revenues	0	10,567	26,703,316	2,518,994,800	15,290,200,000	0000934796	0000875355	0000029989
13	remainder_NetIncome	-101,000,000	-77,951,650	-128,675	19,551,434	66,100,000	0001377630	0001615780	0000029989
14	remainder_ComprehensiveNetIncome	-379,600,000	-15,549,750	0	0	3,332	0000029989	0001527190	0001648365

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	47,699	95,896	23,538,000	1,749,967,250	24,617,000,000	0001539850	0000875355	0000029989
1	Liabilities	113,092	245,937	13,834,848	1,615,381,950	15,270,200,000	0001648365	0001495231	0000029989
2	Expenses	906	369,950	28,715,596	2,447,910,350	13,915,800,000	0001516079	0000875355	0000029989
3	Revenues	0	10,567	26,703,316	2,518,994,800	15,290,200,000	0000934796	0000875355	0000029989
4	StockholdersEquity	-195,421,000	-122,610,000	4,331,374	1,383,175,350	9,346,800,000	0000876883	0001495231	0000029989
5	NetIncome	-111,948,000	-91,351,681	-629,322	97,517,650	1,440,500,000	0000876883	0001516079	0000029989
6	ComprehensiveNetIncome	-117,059,000	-91,351,681	-796,448	91,117,900	1,060,900,000	0000876883	0001648365	0000029989
7	BaseVar	1,566,589	2,199,159	200,221,634	15,378,426,050	102,968,360,000	0001516079	0001084267	0000029989
8	EconomicCapitalRatio	-35.2	-13.2	-0.518	4.53	5.58	0001084267	0000829323	0001725516

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	AssetsCurrent	-15.3	-3.49	-0.264	2.01	20.2	0001084267	0000876883	0001648365
1	AssetsNonCurrent	-7.45	-1.66	-0.191	1.75	2.61	0001084267	0001115128	0001377630
2	IntangibleAssets	-10.7	-2.55	-0.238	0.875	0.990	0001084267	0000934796	0001495231
3	PropertyPlantAndEquipment	-3.62	-0.615	-0.0237	0.338	1.67	0001084267	0000029989	0001615780
4	remainder_Assets	-1.51	-0.562	-0.0574	3.23	71.6	0000829323	0001115128	0001084267
5	LiabilitiesCurrent	-18.0	-2.58	1.43	4.97	5.92	0001084267	0001588014	0001539850
6	LiabilitiesNonCurrent	-7.59	-3.10	0.266	1.28	1.63	0001084267	0001490281	0001725516
7	remainder_Liabilities	-3.42	-0.511	0.116	0.655	29.3	0001084267	0001495231	0001516079
8	CostOfGoodsAndServicesSold	-6.08	-5.06	0.424	2.17	4.22	0001588014	0001375796	0001084267
9	SellingAndMarketingExpense	-7.64	-1.94	0.316	1.76	1.94	0001133311	0001648365	0001084267
10	GeneralAndAdministrativeExpense	-4.41	-2.65	0.223	2.79	3.06	0001588014	0001115128	0001084267
11	remainder_Expenses	-4.33	-3.53	0.464	4.52	7.50	0000829323	0001375796	0001588014
12	remainder_Revenues	-11.7	-3.71	1.16	6.05	6.72	0001084267	0000029989	0001133311
13	remainder_NetIncome	-26.3	-8.38	0.668	6.06	8.66	0001084267	0001115128	0001725516
14	remainder_ComprehensiveNetIncome	-0.0973	-0.0682	0.00939	0.0349	0.0379	0000029989	0001539850	0001084267

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-16.2	-5.93	0.0189	1.83	10.2	0001084267	0001615780	0001648365
1	Liabilities	-20.0	-1.61	1.79	3.81	4.25	0001084267	0001490281	0001725516
2	Expenses	-4.49	-2.59	-0.188	4.55	7.19	0001084332	0001115128	0001084267
3	Revenues	-11.7	-3.71	1.16	6.05	6.72	0001084267	0000029989	0001133311
4	StockholdersEquity	-4.06	-3.27	1.41	3.98	4.84	0000934796	0001490281	0001084267
5	NetIncome	-30.9	-8.18	1.78	7.12	9.67	0001084267	0000876883	0001725516
6	ComprehensiveNetIncome	-30.8	-8.17	1.78	7.08	9.69	0001084267	0000876883	0001725516
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001377630	0000029989
8	EconomicCapitalRatio	-32.5	-10.5	2.18	7.23	8.27	0001084267	0000829323	0001725516

2019

Logs

error	8 × Unusually strong effect	check_effects	{'var_name': 'AssetsCurrent', 'quantile_value': '-16.8', 'quantile': 0.05} {'var_name': 'IntangibleAssets', 'quantile_value': '-15.4', 'quantile': 0.05} {'var_name': 'LiabilitiesCurrent', 'quantile_value': '-22.8', 'quantile': 0.05} {'var_name': 'Assets', 'quantile_value': '-24.9', 'quantile': 0.05} {'var_name': 'Liabilities', 'quantile_value': '-23.8', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-29.1', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-29.1', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-31.9', 'quantile': 0.05}
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001663641
error	1 × Median ECR is negative	check_abs_values	{'median': -0.5634772383672099}
warning	3 × Missing logo	subcommand.report	0001516079 0001705110 0001752372
warning	2 × Ignoring company because Assets is zero	pre-agg	0001334978 0001703625
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -38.38106427033412}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001377630
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	19.0	56,038	8,157,548	5,662,604,400	14,584,700,000	0001696195	0000829323	0000029989
1	AssetsNonCurrent	0	0	118,650	761,953,800	875,700,000	0000934796	0001538217	0001377630
2	IntangibleAssets	0	0	5,855,225	4,984,631,200	11,177,000,000	0000934796	0001392694	0000029989
3	PropertyPlantAndEquipment	0	0	549,276	475,704,400	778,100,000	0001084332	0000875355	0000051644
4	remainder_Assets	-740,191,000	-36,520,400	3,544	93,112,400	184,966,000	0001576427	0001539850	0001490281
5	LiabilitiesCurrent	5,022	90,739	10,187,856	5,980,858,800	15,980,900,000	0001696195	0001495231	0000029989
6	LiabilitiesNonCurrent	0	0	352,972	1,130,370,800	5,341,200,000	0000029989	0001538217	0000051644
7	remainder_Liabilities	-9,272,000	-1,211,520	0	24,794,400	44,098,000	0001576427	0001133311	0001460329
8	CostOfGoodsAndServicesSold	0	0	7,300,977	5,763,438,800	12,194,000,000	0000934796	0001084267	0000029989
9	SellingAndMarketingExpense	0	0	293	361,028,200	733,223,000	0000029989	0001752372	0001705110
10	GeneralAndAdministrativeExpense	0	0	848,498	340,283,800	1,564,100,000	0000029989	0001752372	0000051644
11	remainder_Expenses	-953,100,000	10,420	11,682,984	616,490,200	1,386,100,000	0000051644	0001133311	0000029989
12	remainder_Revenues	0	0	21,964,609	7,037,386,400	14,953,700,000	0000934796	0000875355	0000029989
13	remainder_NetIncome	-207,300,000	-90,976,400	0	5,995,200	62,300,000	0000051644	0001725516	0000029989
14	remainder_ComprehensiveNetIncome	-43,600,000	-18,933,400	0	18,932	762,000	0000029989	0001615780	0001133311

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	19.0	88,871	20,244,389	11,419,784,400	26,783,400,000	0001696195	0001538217	0000029989
1	Liabilities	5,022	123,428	13,487,085	9,649,723,200	15,980,900,000	0001696195	0001343465	0000029989
2	Expenses	800	183,781	27,134,903	6,476,011,200	13,580,100,000	0001516079	0000875355	0000029989
3	Revenues	0	0	21,964,609	7,037,386,400	14,953,700,000	0000934796	0000875355	0000029989
4	StockholdersEquity	-142,416,000	-77,777,109	10,923,549	2,476,842,800	10,802,500,000	0000876883	0001084267	0000029989
5	NetIncome	-73,700,000	-41,239,431	-893,578	442,727,600	1,435,900,000	0001377630	0000934796	0000029989
6	ComprehensiveNetIncome	-73,700,000	-41,268,231	-1,051,250	434,801,200	1,392,300,000	0001377630	0001648365	0000029989
7	BaseVar	164,755	2,079,323	180,175,748	48,522,993,360	101,573,310,000	0001696195	0001392694	0000029989
8	EconomicCapitalRatio	-87.0	-38.4	-0.563	3.26	3.59	0001696195	0001377630	0001705110

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	AssetsCurrent	-66.4	-16.8	-0.206	2.97	3.84	0001696195	0000876883	0001648365
1	AssetsNonCurrent	-30.8	-6.80	-0.170	0.712	2.51	0001696195	0001615780	0001377630
2	IntangibleAssets	-55.9	-15.4	-0.213	0.681	8.96	0001696195	0001539850	0001538217
3	PropertyPlantAndEquipment	-22.4	-4.62	-0.0632	0.0939	1.76	0001696195	0000934796	0001615780
4	remainder_Assets	-28.3	-2.22	-0.149	1.18	12.7	0001696195	0001115128	0001084267
5	LiabilitiesCurrent	-68.5	-22.8	0.715	4.28	4.84	0001696195	0001377630	0001588014
6	LiabilitiesNonCurrent	-39.7	-8.98	-0.00452	0.916	1.56	0001696195	0001539850	0001588014
7	remainder_Liabilities	-32.2	-1.70	0.125	1.09	4.86	0001696195	0001375796	0001516079
8	CostOfGoodsAndServicesSold	-5.63	-4.49	0.341	6.03	6.71	0001392694	0000934796	0001696195
9	SellingAndMarketingExpense	-6.14	-2.53	0.235	2.17	6.26	0001133311	0001615780	0001696195
10	GeneralAndAdministrativeExpense	-26.6	-3.32	0.443	3.56	6.00	0001696195	0000051644	0001516079
11	remainder_Expenses	-32.6	-4.88	0.205	3.20	9.28	0001696195	0001490281	0001516079
12	remainder_Revenues	-15.1	-9.89	1.05	5.40	8.55	0001516079	0000051644	0001588014
13	remainder_NetIncome	-49.0	-7.52	0.739	2.65	6.66	0001516079	0001078099	0001696195
14	remainder_ComprehensiveNetIncome	-0.0763	-0.0416	-0.00453	0.0525	0.120	0000876883	0000051644	0001648365

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-77.3	-24.9	-0.0566	2.24	3.33	0001696195	0001495231	0001648365
1	Liabilities	-71.5	-23.8	0.617	3.54	5.28	0001696195	0001615780	0001588014
2	Expenses	-46.2	-3.95	0.168	2.54	24.5	0001696195	0001115128	0001516079
3	Revenues	-15.1	-9.89	1.05	5.40	8.55	0001516079	0000051644	0001588014
4	StockholdersEquity	-4.02	-2.67	1.80	4.00	4.34	0000934796	0001490281	0001705110
5	NetIncome	-53.2	-29.1	1.41	6.84	11.5	0001696195	0001495231	0001588014
6	ComprehensiveNetIncome	-53.2	-29.1	1.41	6.89	11.5	0001696195	0001495231	0001588014
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001392694	0000029989
8	EconomicCapitalRatio	-80.5	-31.9	5.93	9.75	10.1	0001696195	0001377630	0001705110

2020

Logs

error	1 × Median ECR is negative	check_abs_values	{'median': -0.7175612708018154}
warning	2 × Missing logo	subcommand.report	0001705110 0001752372
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -8.659484872647267}
warning	1 × Ignoring company because Assets is zero	pre-agg	0001552358
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	4,124	44,777	13,795,068	6,154,464,000	15,590,100,000	0001725516	0000875355	0000029989
1	AssetsNonCurrent	0	0	21,000	745,993,600	788,860,000	0000934796	0000829323	0001576427
2	IntangibleAssets	0	0	4,524,627	5,739,672,000	11,131,600,000	0000934796	0001495231	0000029989
3	PropertyPlantAndEquipment	0	0	239,284	426,922,000	690,300,000	0001334978	0001392694	0000051644
4	remainder_Assets	-709,066,000	-16,543,328	168,985	105,051,600	199,877,000	0001576427	0001615780	0001334978
5	LiabilitiesCurrent	125,080	307,459	12,470,483	6,326,890,000	15,525,100,000	0001725516	0001495231	0000029989
6	LiabilitiesNonCurrent	0	0	1,163,575	3,724,116,800	7,091,400,000	0000029989	0000829323	0001334978
7	remainder_Liabilities	-5,297,000	-347,600	0	25,973,000	33,283,000	0001576427	0001334978	0001460329
8	CostOfGoodsAndServicesSold	0	0	4,370,835	5,124,668,400	10,989,200,000	0000934796	0001084267	0000029989
9	SellingAndMarketingExpense	0	0	0	303,373,400	762,590,000	0000029989	0001752372	0001705110
10	GeneralAndAdministrativeExpense	0	0	634,975	361,083,600	1,367,900,000	0000029989	0001346655	0000051644
11	remainder_Expenses	-596,700,000	-61,740	5,970,780	1,028,901,600	2,502,889,000	0000051644	0001495231	0001334978
12	remainder_Revenues	0	2,038	18,403,224	6,265,646,800	13,171,100,000	0000934796	0001495231	0000029989
13	remainder_NetIncome	-226,200,000	-33,565,400	0	39,033,000	157,800,000	0000051644	0001460329	0001377630
14	remainder_ComprehensiveNetIncome	-91,700,000	-28,540,200	0	28,528,800	56,132,000	0000029989	0001725516	0001576427

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	4,124	213,467	35,192,299	13,127,729,200	27,647,200,000	0001725516	0000829323	0000029989
1	Liabilities	125,080	349,779	15,109,967	12,418,570,000	15,525,100,000	0001725516	0001343465	0000029989
2	Expenses	153,429	512,357	28,630,809	6,089,515,600	12,175,800,000	0001725516	0001495231	0000029989
3	Revenues	0	2,038	18,403,224	6,265,646,800	13,171,100,000	0000934796	0001495231	0000029989
4	StockholdersEquity	-2,782,602,000	-336,503,800	1,555,248	2,676,001,600	12,122,100,000	0001334978	0001588014	0000029989
5	NetIncome	-600,226,000	-254,586,800	-1,194,486	272,208,400	1,020,800,000	0001334978	0001648365	0000029989
6	ComprehensiveNetIncome	-598,954,000	-283,127,000	-1,050,753	300,228,400	929,100,000	0001334978	0001648365	0000029989
7	BaseVar	728,877	2,412,591	160,587,839	47,637,152,480	92,885,630,000	0001725516	0001495231	0000029989
8	EconomicCapitalRatio	-10.0	-8.66	-0.715	2.64	3.48	0001725516	0001133311	0001705110

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	AssetsCurrent	-5.66	-3.94	-0.0772	1.71	2.99	0001392694	0001377630	0001495231
1	AssetsNonCurrent	-2.00	-1.20	-0.179	1.65	2.49	0001392694	0001133311	0001377630
2	IntangibleAssets	-3.41	-2.71	-0.214	1.06	2.98	0001392694	0001495231	0001538217
3	PropertyPlantAndEquipment	-1.43	-0.866	-0.0707	0.520	1.29	0001392694	0001539850	0001703625
4	remainder_Assets	-2.78	-1.59	-0.210	3.10	14.5	0001392694	0001538217	0001703625
5	LiabilitiesCurrent	-7.88	-1.56	0.414	2.40	2.77	0000934796	0001377630	0001588014
6	LiabilitiesNonCurrent	-2.78	-1.89	0.159	1.20	1.80	0001377630	0001490281	0001588014
7	remainder_Liabilities	-1.34	-0.527	0.171	0.565	0.816	0001343465	0000051644	0001588014
8	CostOfGoodsAndServicesSold	-15.8	-4.33	0.390	1.74	4.42	0001392694	0001343465	0001588014
9	SellingAndMarketingExpense	-2.78	-1.21	0.276	0.889	1.88	0001705110	0000051644	0001392694
10	GeneralAndAdministrativeExpense	-5.43	-3.41	0.339	2.43	5.47	0001088638	0000051644	0001392694
11	remainder_Expenses	-6.26	-5.28	0.856	3.79	4.89	0000829323	0001495231	0001088638
12	remainder_Revenues	-3.22	-2.99	0.752	5.31	8.21	0000934796	0000051644	0001392694
13	remainder_NetIncome	-3.30	-1.62	-0.467	3.27	7.61	0001084267	0001133311	0000934796
14	remainder_ComprehensiveNetIncome	-0.287	-0.123	-0.0113	0.142	0.819	0001752372	0001115128	0001648365

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-7.52	-6.01	-0.293	2.07	6.25	0001392694	0000876883	0001703625
1	Liabilities	-5.04	-2.16	0.410	3.04	3.55	0000934796	0000029989	0001588014
2	Expenses	-4.09	-3.19	-0.0114	1.36	3.81	0001392694	0001460329	0000934796
3	Revenues	-3.22	-2.99	0.752	5.31	8.21	0000934796	0000051644	0001392694
4	StockholdersEquity	-3.97	-3.32	0.516	3.05	3.72	0000934796	0000051644	0001705110
5	NetIncome	-7.98	-5.91	0.674	4.63	8.20	0001084267	0001490281	0000934796
6	ComprehensiveNetIncome	-7.99	-5.59	0.573	4.61	8.20	0001084267	0000876883	0000934796
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001392694	0000029989
8	EconomicCapitalRatio	-8.86	-7.50	0.448	3.81	4.64	0001725516	0001133311	0001705110

2021

Logs

error	1 × Unusually strong effect	check_effects	{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.1', 'quantile': 0.05}
warning	2 × Missing logo	subcommand.report	0001705110 0001752372
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 5.538772271337976}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -11.701069700302234}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001377630
warning	1 × Ignoring company because Assets is zero	pre-agg	0001552358
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	0	129,878	25,715,682	7,049,972,156	15,909,500,000	0001579717	0001463833	0000029989
1	AssetsNonCurrent	0	0	17,964	712,950,650	800,897,041	0000875355	0000829323	0001648365
2	IntangibleAssets	0	0	2,957,876	5,480,208,700	11,239,500,000	0001343465	0001495231	0000029989
3	PropertyPlantAndEquipment	0	0	274,149	472,382,952	992,100,000	0001334978	0001463833	0000029989
4	remainder_Assets	-672,544,000	-133,573,171	105,969	167,691,250	230,444,000	0001576427	0001615780	0001490281
5	LiabilitiesCurrent	94,934	126,966	13,363,663	6,636,385,350	16,226,200,000	0001840102	0001495231	0000029989
6	LiabilitiesNonCurrent	0	0	349,113	3,694,085,100	7,055,802,000	0000029989	0000829323	0001334978
7	remainder_Liabilities	-10,798,000	-2,656,118	0	22,764,645	144,423,000	0001556739	0001133311	0000876883
8	CostOfGoodsAndServicesSold	0	0	12,933,765	5,213,338,000	11,499,700,000	0001334978	0001495231	0000029989
9	SellingAndMarketingExpense	0	0	0	343,324,350	883,643,000	0000029989	0000876883	0001705110
10	GeneralAndAdministrativeExpense	0	0	1,079,841	415,839,450	1,279,600,000	0000029989	0001840102	0000051644
11	remainder_Expenses	-611,100,000	-290	10,323,005	959,899,078	2,573,870,000	0000051644	0001392694	0001334978
12	remainder_Revenues	0	7,121	41,796,838	6,646,790,750	14,289,400,000	0001579717	0001392694	0000029989
13	remainder_NetIncome	-211,600,000	-73,773,450	10,142	28,095,000	92,680,000	0000051644	0001703625	0001490281
14	remainder_ComprehensiveNetIncome	-138,300,000	-50,446,382	0	173,300	6,875,000	0000029989	0001538217	0001334978

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	28,934	260,865	43,837,468	13,334,769,750	28,421,800,000	0001579717	0000829323	0000029989
1	Liabilities	105,920	420,395	15,959,470	12,746,406,250	16,304,400,000	0001703625	0001495231	0000051644
2	Expenses	57,664	443,908	49,127,814	6,139,206,500	12,816,600,000	0001579717	0001392694	0000029989
3	Revenues	0	7,121	41,796,838	6,646,790,750	14,289,400,000	0001579717	0001392694	0000029989
4	StockholdersEquity	-3,193,970,000	-212,222,540	3,373,200	2,762,774,400	12,195,600,000	0001334978	0001392694	0000029989
5	NetIncome	-433,120,000	-155,323,697	-1,449,388	596,981,150	1,507,600,000	0001334978	0001703625	0000029989
6	ComprehensiveNetIncome	-426,245,000	-179,104,025	-1,449,388	566,175,700	1,369,300,000	0001334978	0001703625	0000029989
7	BaseVar	1,444,245	2,423,708	320,049,856	49,359,708,060	98,705,480,000	0001579717	0001392694	0000029989
8	EconomicCapitalRatio	-27.3	-11.7	0.643	5.54	19.8	0001084267	0000051644	0001579717

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	AssetsCurrent	-8.63	-3.34	-0.0509	1.90	6.56	0001084267	0001490281	0001579717
1	AssetsNonCurrent	-4.22	-1.68	-0.133	1.36	2.55	0001084267	0001556739	0001377630
2	IntangibleAssets	-6.79	-3.19	-0.0329	1.53	3.97	0001084267	0001346655	0001579717
3	PropertyPlantAndEquipment	-1.73	-0.381	-0.000414	0.160	0.807	0001084267	0001556739	0001579717
4	remainder_Assets	-1.64	-0.868	-0.0885	0.274	12.5	0001840102	0000876883	0001703625
5	LiabilitiesCurrent	-10.3	-7.49	0.238	3.48	4.01	0001343465	0001490281	0001615780
6	LiabilitiesNonCurrent	-4.35	-2.83	0.307	2.24	6.71	0001084267	0001752372	0001579717
7	remainder_Liabilities	-1.35	-0.234	0.112	1.05	11.6	0001084267	0001115128	0001840102
8	CostOfGoodsAndServicesSold	-8.43	-5.27	0.241	2.91	4.75	0001392694	0001615780	0001579717
9	SellingAndMarketingExpense	-5.31	-2.62	0.368	1.68	1.94	0000829323	0000051644	0001392694
10	GeneralAndAdministrativeExpense	-5.83	-3.62	0.205	2.36	2.88	0001840102	0000051644	0001392694
11	remainder_Expenses	-8.51	-5.19	1.13	3.67	4.44	0001084267	0001538217	0001588014
12	remainder_Revenues	-9.86	-6.23	0.634	3.92	5.85	0001579717	0000051644	0001588014
13	remainder_NetIncome	-16.4	-5.79	-0.346	6.80	25.2	0001084267	0000051644	0001579717
14	remainder_ComprehensiveNetIncome	-0.197	-0.100	0.0215	0.0538	0.0597	0001576427	0001343465	0001392694

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-14.9	-6.56	0.0283	4.84	8.54	0001084267	0001115128	0001579717
1	Liabilities	-11.8	-4.15	0.414	4.49	7.90	0001084267	0001556739	0001579717
2	Expenses	-8.19	-2.85	-0.0144	3.89	9.74	0001840102	0001495231	0001579717
3	Revenues	-9.86	-6.23	0.634	3.92	5.85	0001579717	0000051644	0001588014
4	StockholdersEquity	-3.65	-3.32	0.523	3.02	3.27	0001343465	0000875355	0001703625
5	NetIncome	-25.6	-9.73	0.546	7.97	25.1	0001084267	0000829323	0001579717
6	ComprehensiveNetIncome	-25.5	-9.71	0.583	8.01	25.1	0001084267	0000829323	0001579717
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001392694	0000029989
8	EconomicCapitalRatio	-26.7	-11.1	1.22	6.12	20.4	0001084267	0000051644	0001579717

2022

Logs

error	5 × Unusually strong effect	check_effects	{'var_name': 'GeneralAndAdministrativeExpense', 'quantile_value': '-10.4', 'quantile': 0.05} {'var_name': 'Assets', 'quantile_value': '-15.1', 'quantile': 0.05} {'var_name': 'NetIncome', 'quantile_value': '-16.0', 'quantile': 0.05} {'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-16.0', 'quantile': 0.05} {'var_name': 'EconomicCapitalRatio', 'quantile_value': '-19.9', 'quantile': 0.05}
error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001822372 0001627469
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -22.50183673690512}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001822372
warning	1 × Missing logo	subcommand.report	0001705110
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001377630
warning	1 × Ignoring company because ECR is too negative	pre-agg	0001552358
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	0	18,801	23,472,488	6,699,518,400	14,613,000,000	0001579717	0001463833	0000029989
1	AssetsNonCurrent	0	0	30.8	693,480,000	1,087,898,000	0000875355	0001495231	0001576427
2	IntangibleAssets	0	0	4,241,464	5,386,940,800	11,212,700,000	0001343465	0001725516	0000029989
3	PropertyPlantAndEquipment	0	0	657,190	443,982,000	900,100,000	0001334978	0001133311	0000029989
4	remainder_Assets	-924,506,000	-7,800,000	35,170	140,512,400	1,205,418,000	0001576427	0001725516	0001334978
5	LiabilitiesCurrent	0	248,575	13,707,389	6,545,884,400	15,052,800,000	0001696195	0000829323	0000029989
6	LiabilitiesNonCurrent	0	0	911,584	3,689,914,400	6,983,609,000	0000029989	0001463833	0001334978
7	remainder_Liabilities	-3,463,000	-350,600	0	21,756,400	71,140,000	0001576427	0001133311	0000876883
8	CostOfGoodsAndServicesSold	0	0	3,799,698	6,119,290,400	11,607,900,000	0000875355	0001588014	0000029989
9	SellingAndMarketingExpense	0	0	0	371,770,400	913,022,000	0000029989	0001334978	0001705110
10	GeneralAndAdministrativeExpense	0	0	685,278	550,605,600	1,346,400,000	0000029989	0001346655	0000051644
11	remainder_Expenses	-564,500,000	0	5,335,661	1,045,507,200	2,538,057,000	0000051644	0001133311	0001334978
12	remainder_Revenues	0	0	41,178,546	7,631,796,800	14,289,100,000	0001579717	0001495231	0000029989
13	remainder_NetIncome	-124,379,000	-79,006,000	-18,412	16,849,000	75,900,000	0000876883	0001579717	0000029989
14	remainder_ComprehensiveNetIncome	-272,900,000	-71,218,400	0	2,715,998	13,545,000	0000029989	0001579717	0001334978

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	21,413	118,744	35,573,080	13,341,404,400	27,002,500,000	0001579717	0000829323	0000029989
1	Liabilities	43,902	571,073	13,812,477	12,371,206,800	15,100,700,000	0001696195	0000829323	0000051644
2	Expenses	52,857	225,709	46,781,637	6,934,222,800	12,961,200,000	0001696195	0001495231	0000029989
3	Revenues	0	0	41,178,546	7,631,796,800	14,289,100,000	0001579717	0001495231	0000029989
4	StockholdersEquity	-3,262,806,000	-280,935,102	8,851,020	2,896,977,600	11,949,700,000	0001334978	0001133311	0000029989
5	NetIncome	-234,380,000	-141,732,800	-552,871	595,399,200	1,403,800,000	0001490281	0001392694	0000029989
6	ComprehensiveNetIncome	-229,854,000	-141,732,800	-923,790	541,533,600	1,130,900,000	0001490281	0000934796	0000029989
7	BaseVar	451,783	1,553,146	302,314,780	53,802,084,720	98,305,130,000	0001696195	0001495231	0000029989
8	EconomicCapitalRatio	-29.5	-22.5	0.249	2.90	5.94	0001840102	0001392694	0000875355

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	AssetsCurrent	-13.3	-8.30	-0.161	0.671	1.34	0001840102	0001334978	0001346655
1	AssetsNonCurrent	-4.17	-2.15	-0.113	0.692	2.45	0001840102	0000934796	0001377630
2	IntangibleAssets	-12.7	-5.99	-0.223	0.985	1.75	0001840102	0001495231	0001539850
3	PropertyPlantAndEquipment	-2.03	-1.43	-0.0485	0.439	1.53	0001840102	0001556739	0001588014
4	remainder_Assets	-12.9	-7.64	-0.475	0.635	12.3	0001840102	0000934796	0001696195
5	LiabilitiesCurrent	-14.9	-4.30	0.743	2.72	3.11	0001840102	0001133311	0001463833
6	LiabilitiesNonCurrent	-9.69	-5.18	0.362	1.72	2.54	0001840102	0001115128	0001579717
7	remainder_Liabilities	-0.779	-0.607	0.0667	0.277	24.5	0001703625	0000051644	0001840102
8	CostOfGoodsAndServicesSold	-12.7	-4.80	0.417	2.15	3.55	0001392694	0000934796	0001703625
9	SellingAndMarketingExpense	-6.70	-3.17	0.200	1.74	1.94	0000829323	0001343465	0001392694
10	GeneralAndAdministrativeExpense	-22.7	-10.4	0.410	4.38	5.85	0001840102	0001705110	0001392694
11	remainder_Expenses	-3.73	-2.99	0.592	2.93	4.20	0001463833	0001576427	0001084267
12	remainder_Revenues	-7.25	-4.60	0.965	5.00	8.22	0001703625	0000051644	0001392694
13	remainder_NetIncome	-15.0	-0.853	0.0867	0.665	6.13	0001703625	0001343465	0000875355
14	remainder_ComprehensiveNetIncome	-0.139	-0.0751	0.0104	0.0573	0.0637	0001576427	0001725516	0001392694

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-22.8	-15.1	-0.589	1.29	5.34	0001840102	0001115128	0001696195
1	Liabilities	-15.4	-7.11	1.06	3.65	5.61	0001840102	0001343465	0001579717
2	Expenses	-15.3	-6.77	0.0717	1.66	3.38	0001840102	0001576427	0001703625
3	Revenues	-7.25	-4.60	0.965	5.00	8.22	0001703625	0000051644	0001392694
4	StockholdersEquity	-3.80	-3.68	0.733	3.17	3.66	0001343465	0001725516	0001696195
5	NetIncome	-20.8	-16.0	1.00	4.70	6.56	0001840102	0001539850	0001392694
6	ComprehensiveNetIncome	-20.7	-16.0	1.01	4.73	6.63	0001840102	0001539850	0001392694
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001460329	0000029989
8	EconomicCapitalRatio	-26.9	-19.9	2.89	5.54	8.58	0001840102	0001392694	0000875355

2023

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001627469
warning	2 × Missing logo	subcommand.report	0001705110 0001752372
warning	1 × Too many companies have an ECR > 400%	check_abs_values	{'quantile_005_val': 6.224590253656373}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -5.9300721221470525}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001377630
warning	1 × Expenses in unusual place in relation to revenue	input.sec.calculation_linkbase.edgar_model_mapping	0001377630

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	AssetsCurrent	0	318,270	46,915,700	10,470,508,100	15,384,200,000	0001696195	0001495231	0000029989
1	AssetsNonCurrent	0	0	37,541	427,890,000	1,079,357,000	0001084267	0000829323	0001576427
2	IntangibleAssets	0	0	10,404,347	6,766,310,650	11,495,600,000	0001088638	0000829323	0000029989
3	PropertyPlantAndEquipment	0	0	584,527	611,189,700	874,900,000	0001334978	0001460329	0000029989
4	remainder_Assets	-944,066,000	-15,011,080	1,314,336	259,159,150	1,571,218,000	0001576427	0001084267	0001334978
5	LiabilitiesCurrent	0	769,647	41,733,550	9,885,096,900	16,246,000,000	0001696195	0001460329	0000029989
6	LiabilitiesNonCurrent	0	0	838,231	4,719,887,000	7,058,009,000	0000029989	0000829323	0001334978
7	remainder_Liabilities	-1,083,000	-86,976	0	24,447,650	34,105,000	0001576427	0001088638	0000876883
8	CostOfGoodsAndServicesSold	0	0	16,300,166	8,702,403,700	11,982,700,000	0000875355	0001495231	0000029989
9	SellingAndMarketingExpense	0	0	0	400,738,300	765,205,000	0000029989	0001088638	0001705110
10	GeneralAndAdministrativeExpense	0	0	4,287,240	646,156,950	1,342,500,000	0000029989	0001084267	0000051644
11	remainder_Expenses	-719,700,000	1,776	40,260,567	1,301,886,750	2,282,698,000	0000051644	0000829323	0001334978
12	remainder_Revenues	0	8,320	110,920,012	10,471,193,850	14,692,200,000	0000875355	0001392694	0000029989
13	remainder_NetIncome	-153,258,000	-72,126,800	949	106,713,150	732,500,000	0001334978	0001752372	0001377630
14	remainder_ComprehensiveNetIncome	-11,065,000	0	0	27,335,000	105,739,000	0001490281	0001392694	0001334978

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	319,122	622,097	81,393,729	18,540,058,750	28,044,600,000	0001752372	0001539850	0000029989
1	Liabilities	152,026	780,764	52,109,166	14,868,800,900	16,246,000,000	0001696195	0001539850	0000029989
2	Expenses	121,776	1,133,313	113,349,144	9,336,865,350	13,330,900,000	0001696195	0001392694	0000029989
3	Revenues	0	8,320	110,920,012	10,471,193,850	14,692,200,000	0000875355	0001392694	0000029989
4	StockholdersEquity	-3,450,743,000	-38,452,989	21,345,906	3,923,673,000	11,798,600,000	0001334978	0001539850	0000029989
5	NetIncome	-308,816,000	-190,849,550	-513,174	1,093,710,000	1,473,200,000	0001334978	0001346655	0000029989
6	ComprehensiveNetIncome	-203,077,000	-189,872,100	-488,437	1,120,120,000	1,491,700,000	0001334978	0001346655	0000029989
7	BaseVar	692,042	5,923,572	652,127,199	72,388,944,725	100,975,100,000	0001696195	0001392694	0000029989
8	EconomicCapitalRatio	-10.3	-5.93	0.505	6.22	12.7	0001084267	0000876883	0001377630

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	AssetsCurrent	-3.31	-2.61	-0.333	1.88	15.1	0001084267	0001696195	0000875355
1	AssetsNonCurrent	-10.3	-0.670	-0.0859	0.247	0.948	0001377630	0000875355	0001576427
2	IntangibleAssets	-2.27	-0.629	0.0858	1.63	2.06	0001460329	0001490281	0001539850
3	PropertyPlantAndEquipment	-0.514	-0.436	-0.0369	0.183	1.77	0001460329	0000876883	0001588014
4	remainder_Assets	-1.80	-1.55	-0.310	2.27	10.7	0001460329	0000875355	0001696195
5	LiabilitiesCurrent	-1.18	-0.620	0.436	5.07	6.82	0000029989	0001460329	0001752372
6	LiabilitiesNonCurrent	-2.91	-0.748	0.260	1.32	3.16	0001334978	0001460329	0001392694
7	remainder_Liabilities	-1.23	-0.258	0.131	0.893	1.36	0001696195	0000029989	0001392694
8	CostOfGoodsAndServicesSold	-12.1	-6.35	-0.132	3.21	3.72	0001392694	0001556739	0000829323
9	SellingAndMarketingExpense	-3.34	-3.23	0.379	1.63	2.26	0001705110	0000029989	0001392694
10	GeneralAndAdministrativeExpense	-7.66	-1.44	0.400	2.33	5.74	0001084267	0000051644	0001392694
11	remainder_Expenses	-9.73	-3.39	0.745	2.65	4.82	0000829323	0001460329	0001392694
12	remainder_Revenues	-4.26	-4.01	0.735	4.22	9.89	0001377630	0001490281	0001392694
13	remainder_NetIncome	-2.50	-1.29	-0.305	0.172	11.2	0001084267	0001588014	0001377630
14	remainder_ComprehensiveNetIncome	-0.129	-0.103	-0.0290	0.0780	0.136	0001490281	0001556739	0001752372

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Assets	-4.39	-2.94	-0.139	5.02	6.53	0001460329	0001088638	0000875355
1	Liabilities	-2.27	-1.13	0.531	5.50	6.36	0001334978	0000875355	0001392694
2	Expenses	-3.58	-2.73	0.185	0.806	5.08	0001084267	0001588014	0001377630
3	Revenues	-4.26	-4.01	0.735	4.22	9.89	0001377630	0001490281	0001392694
4	StockholdersEquity	-4.02	-2.59	-0.273	2.08	3.19	0001752372	0000051644	0000875355
5	NetIncome	-10.2	-3.09	1.09	9.00	12.1	0001084267	0001346655	0001377630
6	ComprehensiveNetIncome	-10.2	-3.11	1.07	8.90	12.0	0001084267	0001346655	0001377630
7	BaseVar	nan	nan	nan	nan	nan	0000029989	0001346655	0000029989
8	EconomicCapitalRatio	-10.8	-6.41	0.0274	5.75	12.2	0001084267	0000876883	0001377630

Estimates

Parameter	Value	Min	Max
PresentValueFactor	5.6	1.0	15.0
BalanceFactor	2.13	0.5	5.0
OCIFactor	1.0	0.5	1.0
HiddenReservesFactor	0.0	0.0	0.0
LLPO_stddev	1.17	0.2	10.0

QA: us_advertising 2010-2023

Table of Contents

Ranks across the years

PDF reports

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

Absolute xval/yval quantiles

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

2022

Logs

Diagrams

Calculation Linkbase Overview