QA: us_finance_services 2009-2023

Ranks across the years

	name	name_short	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	2009-val	2010-val	2011-val	2012-val	2013-val	2014-val	2015-val	2016-val	2017-val	2018-val	2019-val	2020-val	2021-val	2022-val	2023-val	2009->2010	2010->2011	2011->2012	2012->2013	2013->2014	2014->2015	2015->2016	2016->2017	2017->2018	2018->2019	2019->2020	2020->2021	2021->2022	2022->2023
0001684682	CNL Strategic Capital LLC	CNL Str	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	351.46000	NaN	337.676000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001550453	Trilinc Global Impact Fund LLC	Trilinc	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	NaN	NaN	NaN	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	327.38800	NaN	NaN	NaN	313.258000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000754811	U S Global Investors INC	U S Glo	NaN	NaN	NaN	2	2	7	6	6	5	3	8	11	1	1	3	NaN	NaN	NaN	295.72100	296.20100	281.49800	203.93500	230.80700	295.51100	304.75000	214.86200	147.19600	545.30000	310.05500	295.555000	NaN	NaN	NaN	0	5	-1	0	-1	-2	5	3	-10	0	2
0001414767	Netcapital Inc	Netcapi	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	52	48	51	13	16	2	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-457.00000	-246.16700	12.66600	137.98900	162.71500	263.78200	273.782000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	3	-38	3	-14	2
0001005101	Marygold Companies Inc	Marygol	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	7	5	3	5	NaN	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	325.62500	221.58900	226.00600	242.09300	305.35100	NaN	263.123000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-2	-2	2	NaN	NaN
0000909108	Diamond Hill Investment Group INC	Diamond	NaN	NaN	9	6	8	6	3	3	6	4	4	NaN	NaN	NaN	6	NaN	NaN	236.08400	265.52500	250.38900	291.23200	292.50200	303.52800	292.99400	277.01700	293.83400	NaN	NaN	NaN	247.706000	NaN	NaN	-3	2	-2	-3	0	3	-2	0	NaN	NaN	NaN	NaN
0001591587	Assetmark Financial Holdings Inc	Assetma	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	7	11	4	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	184.17000	188.62700	194.25400	224.66300	242.680000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	4	-7	3
0001403528	Brookfield Oaktree Holdings LLC	Brookfi	NaN	NaN	NaN	4	7	NaN	NaN	29	32	30	35	34	36	NaN	8	NaN	NaN	NaN	288.04900	266.80800	NaN	NaN	63.68540	70.11660	71.43920	57.48640	51.31410	66.17310	NaN	241.430000	NaN	NaN	NaN	3	NaN	NaN	NaN	3	-2	5	-1	2	NaN	NaN
0001284812	Cohen Steers INC	Cohen S	NaN	NaN	4	1	1	1	2	2	3	2	3	NaN	4	3	9	NaN	NaN	308.47200	307.81100	336.31600	337.68900	306.14000	338.01000	313.29800	320.41600	296.62000	NaN	349.74000	247.77200	235.764000	NaN	NaN	-3	0	0	1	0	1	-1	1	NaN	NaN	-1	6
0001274173	Janus Henderson Group PLC	Janus H	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	10	7	5	8	7	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	218.61200	209.02500	215.22000	196.27400	216.39800	197.75200	225.755000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	-3	-2	3	-1	3
0000717720	Value Line INC	Value L	NaN	NaN	NaN	26	21	23	22	22	23	16	15	9	10	6	11	NaN	NaN	NaN	104.32400	105.94400	103.00000	107.16100	109.69800	132.46900	171.01600	161.15100	153.60100	195.19300	217.44600	208.085000	NaN	NaN	NaN	-5	2	-1	0	1	-7	-1	-6	1	-4	5
0001056288	Federated Hermes INC	Federat	NaN	4	14	16	13	14	11	7	8	8	6	4	13	13	12	NaN	144.4690	147.78900	159.74100	164.05700	167.53800	176.80200	189.05600	247.34500	219.35300	224.06100	229.44000	184.93100	155.38400	180.237000	NaN	10	2	-3	1	-3	-4	1	0	-2	-2	9	0	-1
0001279715	Wright Investors Service Holdings Inc	Wright	NaN	NaN	NaN	15	23	12	8	8	11	9	13	NaN	NaN	NaN	13	NaN	NaN	NaN	171.33400	101.01200	194.75700	185.53200	184.35700	209.47200	217.49600	171.70400	NaN	NaN	NaN	161.129000	NaN	NaN	NaN	8	-11	-4	0	3	-2	4	NaN	NaN	NaN	NaN
0001145255	Hennessy Advisors INC	Henness	NaN	NaN	11	12	22	19	20	16	17	6	9	2	7	11	14	NaN	NaN	221.80500	215.41500	102.64500	143.89400	110.50200	148.70700	171.68200	230.76000	210.59500	266.38000	260.17100	156.40600	152.955000	NaN	NaN	1	10	-3	1	-4	1	-11	3	-7	5	4	3
0001004434	Affiliated Managers Group INC	Affilia	NaN	5	16	17	11	15	13	12	13	NaN	NaN	23	20	9	15	NaN	129.8740	136.68100	141.79300	179.86100	163.64000	167.46500	165.92900	191.10700	NaN	NaN	119.93600	129.93300	157.24400	151.763000	NaN	11	1	-6	4	-2	-1	1	NaN	NaN	NaN	-3	-11	6
0001823945	Blue OWL Capital INC	Blue OW	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	29	14	16	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	88.33670	146.06600	148.778000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-15	2
0001109448	Alliancebernstein L P	Allianc	NaN	3	19	24	15	17	16	18	22	21	18	20	22	19	17	NaN	158.7190	105.18100	107.45700	150.45700	153.22900	150.98100	138.38700	135.52700	127.34400	138.96100	121.60500	128.31100	114.91700	133.320000	NaN	16	5	-9	2	-1	2	4	-1	-3	2	2	-3	-2
0000914208	Invesco Ltd	Invesco	2	8	18	20	NaN	NaN	NaN	NaN	31	32	32	25	19	16	18	182.848	107.5800	112.02300	130.91900	NaN	NaN	NaN	NaN	70.63420	63.31470	80.65650	93.56440	132.85800	130.96100	121.223000	6	10	2	NaN	NaN	NaN	NaN	NaN	1	0	-7	-6	-3	2
0001393818	Blackstone Inc	Blackst	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24	12	15	20	19	NaN	80.3878	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	120.28400	140.23100	168.10900	112.36600	106.236000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12	3	5	-1
0001497770	Walker Dunlop Inc	Walker	NaN	NaN	22	32	NaN	NaN	33	31	26	29	28	29	32	21	20	NaN	NaN	81.63890	44.03630	NaN	NaN	31.29750	47.64410	105.16800	81.99910	100.46200	64.40930	74.34280	105.37700	98.630500	NaN	NaN	10	NaN	NaN	NaN	-2	-5	3	-1	1	3	-11	-1
0001289419	Morningstar Inc	Morning	NaN	2	10	11	10	13	7	15	NaN	12	22	14	21	27	21	NaN	218.2790	221.92600	220.34300	210.87000	172.78700	186.06700	149.01100	NaN	196.29400	120.85500	134.56600	129.41300	69.15900	93.974300	NaN	8	1	-1	3	-6	8	NaN	NaN	10	-8	7	6	-6
0001818502	Oppfi Inc	Oppfi I	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24	NaN	22	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	117.47000	NaN	83.578300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001829311	Bitmine Immersion Technologies Inc	Bitmine	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	44	10	23	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	37.76250	157.18000	71.312600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-34	13
0000933136	Mr Cooper Group Inc	Mr Coop	NaN	NaN	NaN	NaN	NaN	NaN	14	1	1	NaN	NaN	45	31	23	24	NaN	NaN	NaN	NaN	NaN	NaN	156.02600	431.32000	330.52800	NaN	NaN	21.39050	74.84040	84.45980	68.972700	NaN	NaN	NaN	NaN	NaN	NaN	-13	0	NaN	NaN	NaN	-14	-8	1
0001854401	Bridge Investment Group Holdings Inc	Bridge	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15	25	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	135.36300	64.512800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10
0001777835	Perella Weinberg Partners	Perella	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	33	25	26	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	71.17350	78.18570	63.279100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-8	1
0000883237	Virtus Investment Partners Inc	Virtus	NaN	NaN	1	9	3	3	NaN	21	37	35	37	33	38	29	27	NaN	NaN	420.00400	241.11600	284.36300	299.95000	NaN	111.13600	47.72950	53.33760	52.23690	51.72530	62.26530	52.79140	60.642200	NaN	NaN	8	-6	0	NaN	NaN	16	-2	2	-4	5	-9	-2
0001748824	Brightsphere Investment Group Inc	Brights	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	24	6	34	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	68.89240	118.15300	302.73900	44.17900	45.475800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	-18	28	-6
0000318673	Security National Financial Corp	Securit	NaN	NaN	NaN	NaN	NaN	NaN	34	35	42	NaN	45	NaN	NaN	NaN	29	NaN	NaN	NaN	NaN	NaN	NaN	31.00760	31.53500	30.92350	NaN	31.25840	NaN	NaN	NaN	44.363200	NaN	NaN	NaN	NaN	NaN	NaN	1	7	NaN	NaN	NaN	NaN	NaN	NaN
0001527166	Carlyle Group Inc	Carlyle	NaN	NaN	NaN	28	24	26	28	37	36	37	41	37	28	24	30	NaN	NaN	NaN	89.55520	85.95380	71.51130	51.97520	25.80040	50.93670	42.78870	47.60250	40.60540	93.16560	78.86700	43.048000	NaN	NaN	NaN	-4	2	2	9	-1	1	4	-4	-9	-4	6
0001176948	Ares Management Corp	Ares Ma	NaN	NaN	NaN	NaN	NaN	27	29	30	40	44	53	39	39	33	31	NaN	NaN	NaN	NaN	NaN	68.31120	46.62130	58.56670	36.28000	1.26773	-6.21402	36.44020	54.60010	46.88980	42.647600	NaN	NaN	NaN	NaN	NaN	2	1	10	4	9	-14	0	-6	-2
0001404912	KKR Co Inc	KKR Co	NaN	NaN	5	3	5	10	10	25	27	23	23	21	NaN	NaN	32	NaN	NaN	296.10100	290.77900	276.44300	213.67700	176.83500	94.19340	102.70100	116.54100	120.63900	121.05800	NaN	NaN	37.327100	NaN	NaN	-2	2	5	0	15	2	-4	0	-2	NaN	NaN	NaN
0001386278	Green DOT Corp	Green D	NaN	NaN	NaN	22	20	24	26	26	30	25	30	36	41	39	33	NaN	NaN	NaN	117.56500	110.64700	87.02100	87.02450	87.64160	81.20450	98.32450	89.34430	47.40510	42.55780	15.07720	34.510200	NaN	NaN	NaN	-2	4	2	0	4	-5	5	6	5	-2	-6
0001601712	Synchrony Financial	Synchro	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41	38	43	42	45	35	34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	31.95190	31.55240	35.61120	27.25440	37.65120	29.43740	26.047400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	5	-1	3	-10	-1
0000804269	General Motors Financial Company Inc	General	NaN	NaN	NaN	30	NaN	NaN	NaN	NaN	NaN	40	47	43	46	36	35	NaN	NaN	NaN	59.87050	NaN	NaN	NaN	NaN	NaN	21.52010	24.09800	25.24760	30.58960	28.18870	25.571400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-4	3	-10	-1
0001711012	Senmiao Technology Ltd	Senmiao	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	50	50	54	12	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12.90750	-140.77600	-116.35300	156.31200	25.014800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	4	-42	24
0001647639	Upstart Holdings Inc	Upstart	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	23	31	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	118.36800	50.37600	23.207200	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	6
0000889609	Consumer Portfolio Services Inc	Consume	NaN	NaN	31	34	31	32	35	39	46	41	49	47	48	NaN	38	NaN	NaN	-7.83131	28.32830	15.58740	16.17640	17.02050	16.47470	13.28280	15.12210	14.14060	13.23850	21.83590	NaN	20.560000	NaN	NaN	3	-3	1	3	4	7	-5	8	-2	1	NaN	NaN
0001858681	Apollo Global Management Inc	Apollo	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	43	39	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-12.33920	19.472900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4
0000944130	Ministry Partners Investment Company LLC	Ministr	NaN	NaN	29	36	33	36	37	40	47	42	48	46	47	NaN	40	NaN	NaN	7.25422	10.30240	11.59240	5.26871	9.82369	11.04690	11.43330	11.15600	15.33810	19.53300	23.68700	NaN	17.551100	NaN	NaN	7	-3	3	1	3	7	-5	6	-2	1	NaN	NaN
0000820027	Ameriprise Financial INC	Ameripr	3	10	28	35	32	33	36	41	48	43	52	48	51	40	41	16.599	17.3308	15.91860	15.21550	12.15390	13.64390	11.88800	9.95560	9.55608	9.91234	10.65300	8.98369	8.64308	3.67567	9.613910	7	18	7	-3	1	3	5	7	-5	9	-4	3	-11	1
0001831631	Loandepot Inc	Loandep	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	43	NaN	42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39.27810	NaN	8.958600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001538716	Oportun Financial Corp	Oportun	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39	40	42	37	43	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49.09730	36.01310	42.00580	20.50990	5.567810	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1	2	-5	6
0001679788	Coinbase Global Inc	Coinbas	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	42	44	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	110.88900	2.05557	5.158230	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17	2
0001326141	Lazard Group LLC	Lazard	NaN	NaN	24	33	NaN	29	27	27	29	33	46	35	35	30	45	NaN	NaN	65.08480	38.44360	NaN	63.70660	74.08800	70.79880	81.53380	57.85220	25.89750	49.04070	67.63200	52.65750	-0.413552	NaN	NaN	9	NaN	NaN	-2	0	2	4	13	-11	0	-5	15
0001823144	Composecure Inc	Compose	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	55	46	46	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-131.79600	-32.98190	-14.401900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	0
0001819796	GCM Grosvenor Inc	GCM Gro	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	44	52	44	47	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	24.26460	-4.86134	-16.17460	-26.957300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	-8	3
0001409446	Nate S Food Co	Nate S	NaN	NaN	NaN	NaN	NaN	NaN	42	48	12	52	NaN	NaN	58	47	48	NaN	NaN	NaN	NaN	NaN	NaN	-1506.72000	-722.49900	200.97000	-699.82300	NaN	NaN	-334.09000	-227.04400	-356.031000	NaN	NaN	NaN	NaN	NaN	NaN	6	-36	40	NaN	NaN	NaN	-11	1
0000924095	Metavesco Inc	Metaves	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49	NaN	55	61	48	49	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-332.77000	NaN	-736.92500	-624.77800	-776.32600	-456.003000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	-13	1
0001605057	Vemanti Group Inc	Vemanti	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	62	NaN	50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-712.31000	NaN	-1853.090000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000038777	Franklin Resources INC	Frankli	1	1	12	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	265.982	241.5880	214.12800	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	11	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000350797	Mirror Merger Sub 2 LLC	Mirror	NaN	7	21	25	25	20	24	17	19	22	29	28	NaN	NaN	NaN	NaN	119.6990	96.42380	105.41900	84.71920	136.15300	96.07630	146.81500	167.06900	116.67800	98.34710	68.90410	NaN	NaN	NaN	NaN	14	4	0	-5	4	-7	2	3	7	-1	NaN	NaN	NaN
0001065865	Janus Capital Group INC	Janus C	NaN	6	15	19	17	18	15	14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	120.0560	142.61400	139.75300	139.59600	150.71000	155.93700	157.36100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	4	-2	1	-3	-1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000009235	BKF Capital Group INC	BKF Cap	NaN	NaN	3	10	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	322.72400	221.48900	NaN	231.81000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001068875	Avantax INC	Avantax	NaN	NaN	6	14	NaN	22	NaN	NaN	NaN	15	17	49	37	NaN	NaN	NaN	NaN	292.55900	195.06600	NaN	107.85300	NaN	NaN	NaN	171.33200	144.38900	-44.64490	64.09220	NaN	NaN	NaN	NaN	8	NaN	NaN	NaN	NaN	NaN	NaN	2	32	-12	NaN	NaN
0001165002	Westwood Holdings Group INC	Westwoo	NaN	NaN	7	7	6	4	5	4	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	279.88000	260.47300	267.03600	293.93700	246.17400	280.96500	275.23100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-1	-2	1	-1	3	NaN	NaN	NaN	NaN	NaN	NaN
0001313918	Cifc Corp	Cifc Co	NaN	NaN	30	37	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.58004	2.87615	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001360901	Evercore Inc	Evercor	NaN	NaN	20	NaN	18	21	21	19	21	18	20	16	NaN	NaN	NaN	NaN	NaN	103.86000	NaN	126.65900	126.21800	109.22700	119.80900	141.81600	163.21300	129.57700	129.89600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3	0	-2	2	-3	2	-4	NaN	NaN	NaN
0001377167	Financial Gravity Companies Inc	Financi	NaN	NaN	33	39	NaN	NaN	NaN	45	39	47	44	6	60	NaN	NaN	NaN	NaN	-538.99900	-1471.24000	NaN	NaN	NaN	-233.43600	39.72930	-183.50000	34.29590	195.29100	-498.32600	NaN	NaN	NaN	NaN	6	NaN	NaN	NaN	NaN	-6	8	-3	-38	54	NaN	NaN
0001380393	Fortress Investment Group LLC	Fortres	NaN	NaN	27	18	12	NaN	23	24	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34.34310	141.00800	169.83900	NaN	96.71600	96.95880	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-9	-6	NaN	NaN	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001386926	KKR Financial Holdings LLC	KKR Fin	NaN	NaN	26	31	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	45.85370	51.55230	67.73940	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	-3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001399249	Pzena Investment Management Inc	Pzena I	NaN	NaN	2	NaN	NaN	NaN	NaN	NaN	NaN	17	19	10	12	NaN	NaN	NaN	NaN	376.67900	NaN	NaN	NaN	NaN	NaN	NaN	163.26400	136.82700	150.25100	193.85000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-9	2	NaN	NaN
0001403256	Sculptor Capital Management Inc	Sculpto	NaN	NaN	32	29	26	30	31	NaN	33	31	42	27	30	26	NaN	NaN	NaN	-167.61700	83.11970	77.47460	49.21850	39.62160	NaN	67.06080	68.39280	44.56730	86.77300	78.96260	72.69600	NaN	NaN	NaN	-3	-3	4	1	NaN	NaN	-2	11	-15	3	-4	NaN
0001407161	Titanium Asset Management Corp	Titaniu	NaN	NaN	23	13	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	80.03270	206.16600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001411494	Apollo Asset Management Inc	Apollo	NaN	NaN	25	NaN	27	NaN	NaN	20	25	28	27	32	27	22	NaN	NaN	NaN	54.25210	NaN	68.27450	NaN	NaN	119.78700	115.86700	83.14610	102.55300	52.07940	99.51970	85.00480	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	3	-1	5	-5	-5	NaN
0001419178	Artio Global Investors Inc	Artio G	NaN	NaN	17	27	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	129.71800	92.74230	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001430592	Financial Engines LLC	Financi	NaN	NaN	8	5	4	5	4	5	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	275.34300	273.44500	281.57800	293.29900	276.76000	277.48900	298.44300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-3	-1	1	-1	1	-1	NaN	NaN	NaN	NaN	NaN	NaN
0001496623	Netspend Holdings Inc	Netspen	NaN	NaN	13	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	196.06300	126.16300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0000749038	Ccur Holdings Inc	Ccur Ho	NaN	NaN	NaN	23	16	8	17	42	NaN	1	10	1	NaN	NaN	NaN	NaN	NaN	NaN	109.40100	146.27500	270.74700	149.81200	8.08605	NaN	408.36400	207.78800	346.08500	NaN	NaN	NaN	NaN	NaN	NaN	-7	-8	9	25	NaN	NaN	9	-9	NaN	NaN	NaN
0001372183	Nextplay Technologies Inc	Nextpla	NaN	NaN	NaN	38	35	37	39	46	NaN	51	1	NaN	53	41	NaN	NaN	NaN	NaN	-786.99000	-284.36400	-646.16600	-53.24650	-417.07300	NaN	-474.91900	391.07400	NaN	-77.28650	2.12614	NaN	NaN	NaN	NaN	-3	2	2	7	NaN	NaN	-50	NaN	NaN	-12	NaN
0001498122	Arista Financial Corp	Arista	NaN	NaN	NaN	40	NaN	NaN	NaN	NaN	53	53	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-2700.31000	NaN	NaN	NaN	NaN	-655.88700	-867.47000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	NaN	NaN	NaN	NaN	NaN
0001524223	Manning Napier Inc	Manning	NaN	NaN	NaN	8	9	2	1	13	16	14	14	17	14	NaN	NaN	NaN	NaN	NaN	259.58200	246.54700	312.78900	325.54100	159.07700	172.87100	190.77600	163.65900	126.64300	173.58800	NaN	NaN	NaN	NaN	NaN	1	-7	-1	12	3	-2	0	3	-3	NaN	NaN
0001014111	Glassbridge Enterprises Inc	Glassbr	NaN	NaN	NaN	NaN	19	35	40	44	51	46	11	53	NaN	NaN	NaN	NaN	NaN	NaN	NaN	114.28100	7.26373	-325.46700	-207.19200	-114.17900	-104.42700	185.94700	-435.61000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16	5	4	7	-5	-35	42	NaN	NaN	NaN
0001411488	Blackhawk Network Holdings INC	Blackha	NaN	NaN	NaN	NaN	30	NaN	NaN	34	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27.20380	NaN	NaN	40.03210	20.07510	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	NaN	NaN	NaN	NaN	NaN	NaN
0001510832	Biopower Operations Corp	Biopowe	NaN	NaN	NaN	NaN	36	38	41	NaN	NaN	NaN	NaN	NaN	59	NaN	NaN	NaN	NaN	NaN	NaN	-1206.41000	-821.53200	-620.61500	NaN	NaN	NaN	NaN	NaN	-356.89200	NaN	NaN	NaN	NaN	NaN	NaN	2	3	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001517302	Artisan Partners Asset Management Inc	Artisan	NaN	NaN	NaN	NaN	29	31	30	33	35	24	31	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	54.90830	45.32770	45.80190	43.70920	54.88650	98.33220	84.86240	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2	-1	3	2	-11	7	NaN	NaN	NaN	NaN
0001549966	Silvercrest Asset Management Group Inc	Silverc	NaN	NaN	NaN	NaN	14	16	12	10	14	13	21	15	17	8	NaN	NaN	NaN	NaN	NaN	162.23900	157.29000	168.05900	169.57400	185.74500	196.04600	121.30700	132.75800	150.37000	191.85700	NaN	NaN	NaN	NaN	NaN	2	-4	-2	4	-1	8	-6	2	-9	NaN
0001580185	J G Wentworth Co	J G Wen	NaN	NaN	NaN	NaN	34	34	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6.10551	9.79302	-3.22945	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	4	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001558432	Capstone Financial Group INC	Capston	NaN	NaN	NaN	NaN	NaN	11	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	200.07600	36.80280	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	21	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001596967	Moelis Co	Moelis	NaN	NaN	NaN	NaN	NaN	25	19	23	24	20	26	19	18	18	NaN	NaN	NaN	NaN	NaN	NaN	72.65760	123.68500	107.93200	121.84000	134.60100	105.80700	122.93200	133.21300	115.34300	NaN	NaN	NaN	NaN	NaN	NaN	-6	4	1	-4	6	-7	-1	0	NaN
0001611702	Brightsphere Investment Group plc	Brights	NaN	NaN	NaN	NaN	NaN	28	NaN	32	44	36	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66.34340	NaN	45.71010	21.54850	44.56040	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12	-8	NaN	NaN	NaN	NaN	NaN
0001420811	On Deck Capital Inc	On Deck	NaN	NaN	NaN	NaN	NaN	NaN	25	38	38	34	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	91.10840	22.32630	46.78340	55.98700	50.67390	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	13	0	-4	4	NaN	NaN	NaN	NaN
0001626115	PJT Partners Inc	PJT Par	NaN	NaN	NaN	NaN	NaN	NaN	9	9	15	11	16	8	9	5	NaN	NaN	NaN	NaN	NaN	NaN	NaN	182.55000	179.14600	176.27300	202.24400	152.88200	173.79000	197.45000	219.42300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	6	-4	5	-8	1	-4	NaN
0001640384	Lm Funding America INC	Lm Fund	NaN	NaN	NaN	NaN	NaN	NaN	18	43	55	5	54	22	2	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	132.47500	5.89247	-1419.41000	260.12000	-54.66810	119.98800	356.99100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	25	12	-50	49	-32	-20	NaN	NaN
0001059142	Greystone Housing Impact Investors Lp	Greysto	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28	28	26	25	26	34	32	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	67.33660	97.61400	91.33970	111.01100	89.48540	70.56000	49.29330	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0	-2	-1	1	8	-2	NaN
0001302215	Houlihan Lokey INC	Houliha	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	167.01400	143.11100	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	NaN	NaN	NaN	NaN	NaN	NaN
0001562214	Zais Group Holdings Inc	Zais Gr	NaN	NaN	NaN	NaN	NaN	NaN	NaN	36	18	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28.90770	167.44500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-18	NaN	NaN	NaN	NaN	NaN	NaN
0001623590	Fintech Scion Ltd	Fintech	NaN	NaN	NaN	NaN	NaN	NaN	NaN	47	54	50	56	52	57	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-424.79800	-693.82300	-384.22400	-357.56000	-302.49000	-286.02300	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	7	-4	6	-4	5	NaN	NaN
0001483646	Blackstar Enterprise Group INC	Blackst	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	49	55	58	56	63	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-51.32830	-2316.07000	-1695.91000	-3795.30000	-809.45400	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	6	3	-2	7	NaN	NaN
0001570827	Victory Capital Holdings Inc	Victory	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34	19	33	18	26	17	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	66.08100	158.99800	75.70500	123.51900	108.51900	127.02500	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-15	14	-15	8	-9	NaN
0001651094	Elevate Credit Inc	Elevate	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	43	39	40	31	50	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	22.00500	31.45370	48.74060	54.30650	13.39780	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-4	1	-9	19	NaN	NaN
0001697412	Migom Global Corp	Migom G	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10	54	55	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	218.18800	-1043.12000	-269.29000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	44	1	NaN	NaN	NaN	NaN
0001706509	Cosmos Group Holdings Inc	Cosmos	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	50	45	57	54	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-101.64300	-67.86870	-670.49900	-482.48900	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-5	12	-3	NaN	NaN	NaN
0001651052	Focus Financial Partners Inc	Focus F	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	27	36	30	40	28	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	86.05590	56.73650	55.91680	44.88950	57.18140	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9	-6	10	-12	NaN
0001692376	Velocity Financial Inc	Velocit	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41	NaN	38	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	28.34050	NaN	19.86780	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
0001711291	Curo Group Holdings Corp	Curo Gr	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	38	49	45	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	39.38920	17.38180	-22.01690	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	11	-4	NaN
0001813793	Blockchain Of Things Inc	Blockch	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	51	56	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	-297.78800	-231.10600	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	NaN	NaN

PDF reports

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

2009

Logs

warning

4 × Zero effects

check_effects

{'var_name': 'LoansPayable', 'zeros': '3 of 3'}
{'var_name': 'InvestmentIncome', 'zeros': '3 of 3'}
{'var_name': 'LoansIncome', 'zeros': '3 of 3'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '3 of 3'}

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	DepositsAndPayablesToCustomers	0	128,300,000	1,294,369,200	52,444,400,000	58,129,000,000	0000038777	0000914208	0000820027
1	Debt	0	74,570,000	746,000,660	2,098,670,000	2,249,000,000	0000038777	0000914208	0000820027
2	LoansPayable	0	0	0	0	0	0000038777	0000820027	0000038777
3	OperatingAndEmployeeLiabilities	0	72,554,000	725,854,572	2,141,114,000	2,298,400,000	0000820027	0000038777	0000914208
4	remainder_Liabilities	-1,038,300,000	-830,133,800	1,051,857,328	39,272,336,200	43,520,000,000	0000914208	0000038777	0000820027
5	Investments	310,504,000	476,253,600	1,986,627,000	85,789,500,000	95,103,000,000	0000038777	0000914208	0000820027
6	CashAndCurrentAssets	3,097,000,000	3,099,400,000	3,121,424,684	5,032,078,000	5,244,420,000	0000820027	0000914208	0000038777
7	IntangibleAssets	0	200,460,000	2,005,520,420	6,146,490,000	6,606,700,000	0000820027	0000038777	0000914208
8	remainder_Assets	-786,100,000	-516,596,100	1,911,672,012	14,207,493,900	15,574,000,000	0000914208	0000038777	0000820027
9	LaborExpense	0	95,080,000	950,801,542	957,739,900	958,511,000	0000820027	0000914208	0000038777
10	SellingAndGeneralAdministrativeExpense	116,129,000	121,196,100	167,269,440	2,279,280,000	2,514,000,000	0000038777	0000914208	0000820027
11	CostOfGoodsSold	0	69,340,000	693,617,720	1,673,140,000	1,782,000,000	0000038777	0000914208	0000820027
12	OperatingExpenses	0	214,300,000	2,143,169,699	2,906,643,700	2,991,493,000	0000820027	0000914208	0000038777
13	DepreciationInterestAndFeesExpenses	0	6,450,000	64,936,100	2,026,950,000	2,245,000,000	0000038777	0000914208	0000820027
14	remainder_Expenses	-1,662,800,000	-1,565,552,600	-690,054,335	532,167,400	668,000,000	0000914208	0000038777	0000820027
15	InvestmentIncome	0	0	0	0	0	0000038777	0000820027	0000038777
16	LoansIncome	0	0	0	0	0	0000038777	0000820027	0000038777
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000038777	0000820027	0000038777
18	remainder_Revenues	2,627,300,000	2,783,978,700	4,194,837,383	7,570,808,700	7,946,000,000	0000914208	0000038777	0000820027
19	remainder_NetIncome	-62,300,000	-56,070,000	15,700	70,648,200	78,498,000	0000914208	0000820027	0000038777
20	remainder_ComprehensiveNetIncome	0	0	0	0	0	0000038777	0000820027	0000038777

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,768,902,000	1,920,891,800	3,308,921,840	93,837,080,000	103,898,000,000	0000038777	0000914208	0000820027
1	Assets	9,468,463,000	9,612,576,700	10,930,172,880	103,487,560,000	113,774,000,000	0000038777	0000914208	0000820027
2	Expenses	2,355,700,000	2,457,710,700	3,376,573,639	6,825,680,700	7,209,000,000	0000914208	0000038777	0000820027
3	Revenues	2,627,300,000	2,783,978,700	4,194,837,383	7,570,808,700	7,946,000,000	0000914208	0000038777	0000820027
4	StockholdersEquity	7,620,800,000	7,628,676,100	7,699,996,288	9,658,356,100	9,876,000,000	0000914208	0000038777	0000820027
5	NetIncome	209,300,000	262,070,000	737,031,956	880,800,200	896,778,000	0000914208	0000820027	0000038777
6	ComprehensiveNetIncome	209,300,000	262,070,000	737,031,956	880,800,200	896,778,000	0000914208	0000820027	0000038777
7	BaseVar	13,834,675,500	14,034,136,532	15,851,933,548	117,744,061,082	129,067,925,000	0000914208	0000038777	0000820027
8	EconomicCapitalRatio	0.166	0.332	1.83	2.58	2.66	0000820027	0000914208	0000038777

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	DepositsAndPayablesToCustomers	-0.651	-0.546	0.403	1.12	1.20	0000820027	0000914208	0000038777
1	Debt	-0.154	-0.137	0.0129	0.174	0.192	0000914208	0000820027	0000038777
2	LoansPayable	0	0	0	0	0	0000038777	0000820027	0000038777
3	OperatingAndEmployeeLiabilities	-0.522	-0.456	0.138	0.194	0.200	0000914208	0000820027	0000038777
4	remainder_Liabilities	-0.535	-0.447	0.341	0.732	0.775	0000820027	0000038777	0000914208
5	Investments	-0.190	-0.188	-0.169	0.958	1.08	0000914208	0000038777	0000820027
6	CashAndCurrentAssets	-0.283	-0.250	0.0460	0.135	0.144	0000820027	0000914208	0000038777
7	IntangibleAssets	-0.330	-0.303	-0.0571	0.469	0.527	0000820027	0000038777	0000914208
8	remainder_Assets	-0.148	-0.128	0.0545	0.107	0.113	0000914208	0000038777	0000820027
9	LaborExpense	-0.133	-0.133	-0.131	0.110	0.136	0000914208	0000038777	0000820027
10	SellingAndGeneralAdministrativeExpense	-0.0206	-0.0181	0.00469	0.0385	0.0423	0000820027	0000914208	0000038777
11	CostOfGoodsSold	-0.150	-0.133	0.0238	0.147	0.160	0000914208	0000820027	0000038777
12	OperatingExpenses	-0.559	-0.524	-0.209	0.306	0.363	0000038777	0000914208	0000820027
13	DepreciationInterestAndFeesExpenses	-0.0318	-0.0272	0.0140	0.0512	0.0553	0000820027	0000914208	0000038777
14	remainder_Expenses	-0.184	-0.172	-0.0696	0.308	0.350	0000820027	0000038777	0000914208
15	InvestmentIncome	0	0	0	0	0	0000038777	0000820027	0000038777
16	LoansIncome	0	0	0	0	0	0000038777	0000820027	0000038777
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000038777	0000820027	0000038777
18	remainder_Revenues	-0.350	-0.306	0.0926	0.638	0.698	0000820027	0000914208	0000038777
19	remainder_NetIncome	-0.0242	-0.0218	-0.000474	0.0325	0.0362	0000914208	0000820027	0000038777
20	remainder_ComprehensiveNetIncome	0	0	0	0	0	0000038777	0000820027	0000038777

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.14	-0.959	0.638	1.54	1.64	0000820027	0000914208	0000038777
1	Assets	-0.109	-0.0936	0.0468	0.228	0.249	0000038777	0000914208	0000820027
2	Expenses	-0.502	-0.465	-0.124	0.246	0.287	0000038777	0000914208	0000820027
3	Revenues	-0.350	-0.306	0.0926	0.638	0.698	0000820027	0000914208	0000038777
4	StockholdersEquity	-0.570	-0.460	0.529	0.566	0.570	0000820027	0000038777	0000914208
5	NetIncome	-0.0637	-0.0629	-0.0556	0.203	0.232	0000820027	0000914208	0000038777
6	ComprehensiveNetIncome	-0.0637	-0.0629	-0.0556	0.203	0.232	0000820027	0000914208	0000038777
7	BaseVar	nan	nan	nan	nan	nan	0000038777	0000820027	0000038777
8	EconomicCapitalRatio	-1.39	-1.22	0.277	1.03	1.11	0000820027	0000914208	0000038777

2010

Logs

warning	2 × Zero effects	check_effects	{'var_name': 'LoansIncome', 'zeros': '10 of 10'} {'var_name': 'RevenueFromContractWithCustomer', 'zeros': '10 of 10'}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000038777
warning	1 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000820027
warning	1 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027

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	DepositsAndPayablesToCustomers	0	0	0	1,757,089,500	1,762,287,000	0000038777	0001065865	0001393818
1	Debt	0	0	0	4,354,111,350	7,181,100,000	0000820027	0001393818	0000914208
2	LoansPayable	0	0	0	4,530,174,750	7,890,705,000	0000038777	0001056288	0001393818
3	OperatingAndEmployeeLiabilities	0	0	332,863,510	2,248,463,900	3,264,500,000	0000820027	0001004434	0000914208
4	remainder_Liabilities	-657,800,000	-341,660,600	449,375,577	66,891,673,800	119,907,000,000	0000914208	0001065865	0000820027
5	Investments	0	0	0	10,411,589,600	11,974,472,000	0000350797	0001109448	0001393818
6	CashAndCurrentAssets	0	167,926,500	831,476,483	5,423,061,150	6,362,793,000	0000820027	0001065865	0000038777
7	IntangibleAssets	0	93,961,800	1,884,434,846	6,174,458,600	8,317,400,000	0000820027	0000038777	0000914208
8	remainder_Assets	-649,200,000	-324,795,000	769,857,553	73,359,022,850	131,192,000,000	0000914208	0001004434	0000820027
9	LaborExpense	0	0	471,912,530	2,580,738,850	3,610,189,000	0000820027	0001004434	0001393818
10	SellingAndGeneralAdministrativeExpense	0	4,549,500	225,324,496	1,809,547,800	2,868,000,000	0000350797	0000914208	0000820027
11	CostOfGoodsSold	0	0	0	1,774,765,000	2,431,000,000	0000038777	0001109448	0000820027
12	OperatingExpenses	0	0	22,934,207	3,445,885,450	3,894,319,000	0000820027	0001056288	0000038777
13	DepreciationInterestAndFeesExpenses	0	8,541,000	40,447,908	1,512,335,000	2,666,000,000	0000038777	0001393818	0000820027
14	remainder_Expenses	-2,034,200,000	-1,500,240,800	180,099,866	752,360,600	821,000,000	0000914208	0001289419	0000820027
15	InvestmentIncome	0	0	0	318,944,450	561,161,000	0000038777	0001056288	0001393818
16	LoansIncome	0	0	0	0	0	0000038777	0001056288	0000038777
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000038777	0001056288	0000038777
18	remainder_Revenues	0	249,907,950	1,841,213,868	8,159,149,550	10,046,000,000	0001004434	0001393818	0000820027
19	remainder_NetIncome	-8,671,000	-4,769,050	17,393,601	975,580,850	1,363,061,000	0001056288	0001065865	0001004434
20	remainder_ComprehensiveNetIncome	-94,189,000	-63,489,550	0	2,834,700	5,154,000	0001004434	0001056288	0001289419

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	304,877,000	464,587,400	2,730,774,939	70,936,290,000	119,907,000,000	0001289419	0000038777	0000820027
1	Assets	1,086,302,000	1,116,542,900	6,437,360,355	81,355,445,000	131,192,000,000	0001289419	0001109448	0000820027
2	Expenses	477,048,000	601,725,450	1,805,059,930	6,862,983,950	8,786,000,000	0001289419	0001109448	0000820027
3	Revenues	0	249,907,950	2,038,530,400	8,159,149,550	10,046,000,000	0001004434	0001109448	0000820027
4	StockholdersEquity	477,874,000	485,002,450	3,642,406,601	10,419,155,000	11,285,000,000	0000350797	0001109448	0000820027
5	NetIncome	-607,323,000	-295,122,000	244,353,993	1,365,322,800	1,451,496,000	0001393818	0001004434	0000038777
6	ComprehensiveNetIncome	-607,323,000	-292,802,700	191,154,578	1,365,322,800	1,451,496,000	0001393818	0001004434	0000038777
7	BaseVar	2,091,608,345	2,588,495,357	9,975,473,013	94,287,129,100	150,690,220,000	0001289419	0001109448	0000820027
8	EconomicCapitalRatio	0.173	0.457	1.25	2.31	2.42	0000820027	0001004434	0000038777

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	DepositsAndPayablesToCustomers	-0.746	-0.482	0.116	0.211	0.216	0001109448	0001065865	0000038777
1	Debt	-0.957	-0.834	0.161	0.439	0.439	0000914208	0001393818	0001289419
2	LoansPayable	-1.27	-0.696	0.154	0.278	0.285	0001393818	0001065865	0000038777
3	OperatingAndEmployeeLiabilities	-0.536	-0.407	-0.0138	0.235	0.328	0001289419	0001004434	0001109448
4	remainder_Liabilities	-2.20	-1.52	0.414	0.861	0.880	0000820027	0001393818	0000350797
5	Investments	-0.272	-0.254	-0.144	0.934	1.24	0000350797	0001004434	0001393818
6	CashAndCurrentAssets	-0.251	-0.203	-0.0395	0.228	0.268	0000820027	0001109448	0000038777
7	IntangibleAssets	-0.463	-0.412	-0.00441	0.585	0.681	0000350797	0001289419	0001004434
8	remainder_Assets	-0.313	-0.303	-0.104	1.30	2.27	0001056288	0000038777	0000820027
9	LaborExpense	-0.353	-0.306	-0.0437	0.387	0.530	0001393818	0001065865	0001289419
10	SellingAndGeneralAdministrativeExpense	-0.509	-0.320	0.0308	0.243	0.261	0001289419	0001393818	0000350797
11	CostOfGoodsSold	-0.141	-0.0931	0.0334	0.0525	0.0534	0000914208	0001109448	0000350797
12	OperatingExpenses	-1.33	-1.18	0.254	0.503	0.523	0000350797	0001393818	0001289419
13	DepreciationInterestAndFeesExpenses	-0.0820	-0.0804	0.0145	0.0585	0.0712	0001289419	0001056288	0000038777
14	remainder_Expenses	-1.20	-1.05	0.0177	0.647	0.663	0001056288	0001393818	0000350797
15	InvestmentIncome	-0.0236	-0.0232	-0.0131	0.0482	0.0908	0000350797	0001004434	0001393818
16	LoansIncome	0	0	0	0	0	0000038777	0001056288	0000038777
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000038777	0001056288	0000038777
18	remainder_Revenues	-0.944	-0.700	0.219	1.02	1.02	0001004434	0001109448	0001056288
19	remainder_NetIncome	-0.250	-0.234	-0.128	0.440	0.815	0001056288	0001065865	0001004434
20	remainder_ComprehensiveNetIncome	-0.0559	-0.0531	0.00907	0.0258	0.0336	0001004434	0001065865	0001289419

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.35	-0.933	0.245	1.20	1.24	0000820027	0001109448	0000038777
1	Assets	-0.686	-0.624	-0.0308	0.508	0.581	0000350797	0001109448	0000820027
2	Expenses	-0.601	-0.562	-0.0775	0.318	0.395	0000350797	0001065865	0000820027
3	Revenues	-0.956	-0.706	0.210	0.998	0.999	0001004434	0001109448	0001056288
4	StockholdersEquity	-0.932	-0.839	0.181	0.455	0.455	0000350797	0000914208	0001289419
5	NetIncome	-0.266	-0.184	0.0194	0.265	0.289	0001393818	0001004434	0000038777
6	ComprehensiveNetIncome	-0.258	-0.177	0.0154	0.280	0.303	0001393818	0001065865	0000038777
7	BaseVar	nan	nan	nan	nan	nan	0000038777	0001056288	0000038777
8	EconomicCapitalRatio	-1.16	-0.881	-0.0882	0.973	1.08	0000820027	0001004434	0000038777

2011

Logs

error	8 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001095146 0001095146 0001183082 0001183082 0001508594 0001508594 0000318673 0000318673
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001393818
error	1 × Negative Expenses, ignoring company.	pre-agg	0001353174
warning	6 × Similarly named company. Duplicate?	None	0001386926 0001380393 0001411494 0001430592 0001065865 0001404912
warning	6 × Missing logo	subcommand.report	0000009235 0001313918 0001386926 0001407161 0001419178 0001496623
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001095146 0001183082 0001508594 0000318673
warning	4 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001313918 0001386926 0000820027 0001411494
warning	3 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001313918 0000820027 0001411494
warning	1 × Zero effects	check_effects	{'var_name': 'LoansIncome', 'zeros': '33 of 33'}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000883237
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001498122
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001279715

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	DepositsAndPayablesToCustomers	0	0	0	952,833,600	1,895,972,000	0000009235	0000038777	0001109448
1	Debt	0	0	0	844,862,000	6,582,500,000	0000009235	0000820027	0000914208
2	LoansPayable	0	0	0	118,170,200	368,049,000	0000009235	0001056288	0001109448
3	OperatingAndEmployeeLiabilities	0	0	32,825,682	845,432,000	2,974,400,000	0000009235	0001430592	0000914208
4	remainder_Liabilities	-591,000,000	24,600	161,660,680	7,299,603,200	123,025,000,000	0000914208	0001403256	0000820027
5	Investments	0	0	0	7,052,313,800	37,495,360,000	0000009235	0000883237	0001404912
6	CashAndCurrentAssets	0	4,976,269	195,560,918	3,202,240,000	7,616,768,000	0000944130	0001430592	0000038777
7	IntangibleAssets	0	0	15,894,998	3,261,957,400	8,230,700,000	0000009235	0001165002	0000914208
8	remainder_Assets	-590,300,000	1,343,400	142,297,690	6,355,719,000	131,205,000,000	0000914208	0001056288	0000820027
9	LaborExpense	0	0	51,167,037	1,247,118,800	1,340,778,000	0000820027	0001497770	0001411494
10	SellingAndGeneralAdministrativeExpense	0	0	13,415,614	1,498,083,600	2,965,000,000	0000009235	0001056288	0000820027
11	CostOfGoodsSold	0	0	0	622,279,200	2,497,000,000	0000009235	0001145255	0000820027
12	OperatingExpenses	0	0	40,448,057	2,450,584,800	4,480,212,000	0000009235	0001407161	0000038777
13	DepreciationInterestAndFeesExpenses	0	0	6,693,312	98,670,800	2,410,000,000	0000009235	0001407161	0000820027
14	remainder_Expenses	-3,372,632,000	-1,843,120,400	-719,835	1,229,579,600	1,767,718,000	0000038777	0001068875	0001403256
15	InvestmentIncome	0	0	0	4,616,000	21,499,000	0000009235	0000914208	0001109448
16	LoansIncome	0	0	0	0	0	0000009235	0001284812	0000009235
17	RevenueFromContractWithCustomer	0	0	0	0	102,712,000	0000009235	0001284812	0001497770
18	remainder_Revenues	0	0	204,729,315	5,311,335,600	10,239,000,000	0000944130	0000883237	0000820027
19	remainder_NetIncome	-60,000,000	-31,050,800	0	581,942,200	1,671,400,000	0000820027	0001145255	0001004434
20	remainder_ComprehensiveNetIncome	-245,200,000	-6,436,600	0	274,548,200	1,039,005,000	0001004434	0001497770	0001411494

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	41,000	1,484,600	555,665,957	8,895,325,600	123,025,000,000	0000009235	0001360901	0000820027
1	Assets	2,673	23,964,600	1,043,935,245	27,759,258,000	133,986,000,000	0001377167	0001360901	0000820027
2	Expenses	16,000	293,036	197,338,141	4,350,854,400	9,209,000,000	0000944130	0001068875	0000820027
3	Revenues	0	0	204,729,315	5,311,335,600	10,239,000,000	0000944130	0000883237	0000820027
4	StockholdersEquity	-14,207,000	5,658,269	423,523,286	9,866,960,000	37,684,650,000	0000889609	0001313918	0001404912
5	NetIncome	-1,470,805,000	-1,192,081,200	33,243,010	913,891,600	1,820,776,000	0001403256	0001399249	0000038777
6	ComprehensiveNetIncome	-1,470,805,000	-331,622,000	33,243,010	913,891,600	1,820,776,000	0001403256	0001399249	0000038777
7	BaseVar	114,879	25,931,071	2,233,946,105	25,678,110,468	154,548,680,000	0001377167	0001360901	0000820027
8	EconomicCapitalRatio	-5.39	-0.717	1.30	3.44	4.20	0001377167	0001419178	0000883237

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	DepositsAndPayablesToCustomers	-0.765	-0.343	0.0700	0.199	0.232	0001109448	0001065865	0001399249
1	Debt	-1.34	-1.05	0.216	0.763	0.890	0000944130	0000009235	0001399249
2	LoansPayable	-1.27	-0.173	0.0435	0.138	0.151	0001497770	0000009235	0001284812
3	OperatingAndEmployeeLiabilities	-0.595	-0.461	0.102	0.827	16.3	0001289419	0001065865	0001377167
4	remainder_Liabilities	-2.13	-2.03	0.330	1.48	1.50	0001313918	0001360901	0001399249
5	Investments	-1.39	-0.563	-0.183	1.33	2.21	0001377167	0000909108	0000944130
6	CashAndCurrentAssets	-1.61	-0.597	-0.127	0.229	0.292	0001377167	0001004434	0001430592
7	IntangibleAssets	-0.956	-0.464	-0.0357	1.07	1.77	0001377167	0000883237	0001407161
8	remainder_Assets	-2.21	-0.551	-0.0835	1.70	2.02	0001377167	0001430592	0001313918
9	LaborExpense	-1.93	-1.07	0.0478	0.646	0.835	0000909108	0001145255	0001407161
10	SellingAndGeneralAdministrativeExpense	-2.84	-1.10	0.114	0.353	0.379	0001377167	0000944130	0001496623
11	CostOfGoodsSold	-1.80	-0.338	0.0766	0.140	0.172	0001068875	0001360901	0000909108
12	OperatingExpenses	-3.29	-2.09	-0.0296	1.08	1.55	0001407161	0001497770	0001496623
13	DepreciationInterestAndFeesExpenses	-0.652	-0.145	0.0282	0.136	0.167	0001407161	0001386926	0000909108
14	remainder_Expenses	-3.59	-2.42	-0.130	2.68	3.08	0001496623	0000350797	0000883237
15	InvestmentIncome	-0.00154	-0.00125	-0.000688	0.00426	0.00951	0000909108	0000038777	0001109448
16	LoansIncome	0	0	0	0	0	0000009235	0001284812	0000009235
17	RevenueFromContractWithCustomer	-0.0651	-0.0528	-0.0292	-0.0105	0.603	0000909108	0001326141	0001497770
18	remainder_Revenues	-1.64	-1.16	0.188	2.27	3.01	0001430592	0001109448	0000909108
19	remainder_NetIncome	-0.362	-0.329	-0.147	0.825	2.47	0001399249	0001403256	0001430592
20	remainder_ComprehensiveNetIncome	-0.208	-0.106	-0.0437	0.200	1.03	0001004434	0001326141	0001380393

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.65	-1.54	0.570	2.17	2.49	0000944130	0001145255	0001399249
1	Assets	-4.06	-1.12	-0.0606	0.810	0.831	0001377167	0001068875	0001386926
2	Expenses	-2.30	-1.64	-0.183	0.540	0.662	0001407161	0001109448	0000883237
3	Revenues	-1.68	-1.19	0.173	2.22	2.94	0001430592	0001109448	0000909108
4	StockholdersEquity	-4.53	-1.48	-0.177	1.58	2.64	0001377167	0001386926	0000009235
5	NetIncome	-2.40	-2.24	0.169	1.52	2.14	0001377167	0001326141	0000883237
6	ComprehensiveNetIncome	-2.45	-2.31	0.103	1.43	2.10	0001377167	0001145255	0000883237
7	BaseVar	nan	nan	nan	nan	nan	0000009235	0001284812	0000009235
8	EconomicCapitalRatio	-6.70	-2.02	-0.00943	2.14	2.89	0001377167	0001419178	0000883237

2012

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000318673 0000318673
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001005101
warning	8 × Similarly named company. Duplicate?	None	0001386926 0001419178 0001065865 0001279715 0001380393 0001404912 0001430592 0001498122
warning	6 × Missing logo	subcommand.report	0000009235 0001313918 0001386926 0001407161 0001419178 0001496623
warning	4 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0000318673 0000038777 0001403256 0001326141
warning	3 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001313918 0001386926 0001403528
warning	3 × Ignoring company because Assets is zero	pre-agg	0000038777 0001095146 0001411494
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0001313918 0000820027
warning	2 × Ignoring company because Expenses is zero	pre-agg	0001360901 0001510832
warning	1 × Zero effects	check_effects	{'var_name': 'LoansIncome', 'zeros': '40 of 40'}
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -8.212022171521527}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001386926

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	DepositsAndPayablesToCustomers	0	0	0	1,231,907,000	72,397,000,000	0000009235	0000717720	0000820027
1	Debt	0	0	0	624,044,900	5,085,400,000	0000009235	0000717720	0000914208
2	LoansPayable	0	0	0	528,349,150	14,758,000,000	0000009235	0000804269	0001527166
3	OperatingAndEmployeeLiabilities	0	0	23,037,596	526,877,550	2,713,000,000	0000009235	0000717720	0000914208
4	remainder_Liabilities	-508,600,000	0	55,495,269	10,234,908,400	52,620,000,000	0000914208	0001289419	0000820027
5	Investments	0	0	0	13,350,928,950	40,697,848,000	0000009235	0000820027	0001404912
6	CashAndCurrentAssets	0	1,501	163,664,630	2,188,132,600	3,907,600,000	0000944130	0000883237	0000914208
7	IntangibleAssets	0	0	0	3,164,393,250	8,335,900,000	0000009235	0000909108	0000914208
8	remainder_Assets	-455,300,000	1,214	119,442,998	11,989,458,800	132,358,000,000	0000914208	0001419178	0000820027
9	LaborExpense	0	0	19,003,982	1,175,097,750	1,351,076,000	0000749038	0001313918	0001326141
10	SellingAndGeneralAdministrativeExpense	0	0	8,176,741	373,973,200	3,042,000,000	0000009235	0001372183	0000820027
11	CostOfGoodsSold	0	0	0	319,668,450	2,698,000,000	0000009235	0001145255	0000820027
12	OperatingExpenses	0	0	8,773,537	933,064,000	3,305,500,000	0000009235	0001372183	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	3,125,179	204,162,500	2,677,000,000	0000009235	0001165002	0000820027
14	remainder_Expenses	-2,476,200,000	-344,404,750	352,275	854,235,300	1,603,287,000	0000914208	0000009235	0001403256
15	InvestmentIncome	0	0	0	29,409,550	954,400,000	0000009235	0000754811	0001527166
16	LoansIncome	0	0	0	0	0	0000009235	0001165002	0000009235
17	RevenueFromContractWithCustomer	0	0	0	0	186,543,000	0000009235	0001145255	0001497770
18	remainder_Revenues	0	0	134,718,691	2,791,589,350	10,259,000,000	0000944130	0001403528	0000820027
19	remainder_NetIncome	-178,742,000	-2,540,150	370,160	2,172,729,750	8,071,649,000	0001313918	0000944130	0001404912
20	remainder_ComprehensiveNetIncome	-7,469,319,000	-2,590,838,550	0	250,061,450	571,000,000	0001404912	0000944130	0000820027

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	24,201	97,194	243,016,335	12,126,141,800	125,017,000,000	0001498122	0001289419	0000820027
1	Assets	1,278	439,594	656,058,196	43,897,815,750	134,729,000,000	0001498122	0001386278	0000820027
2	Expenses	16,000	220,965	254,947,054	2,613,705,100	9,356,000,000	0000944130	0001524223	0000820027
3	Revenues	0	0	166,260,177	3,033,295,000	10,259,000,000	0000944130	0000889609	0000820027
4	StockholdersEquity	-14,233,450	-26,721	266,601,890	14,956,896,200	41,405,454,000	0001372183	0001284812	0001404912
5	NetIncome	-624,006,000	-55,330,700	35,788,104	2,613,145,850	8,028,244,000	0001403256	0000883237	0001404912
6	ComprehensiveNetIncome	-315,777,000	-15,248,213	28,040,061	572,693,750	1,472,000,000	0001403256	0001497770	0000820027
7	BaseVar	166,263	7,234,253	1,424,344,339	43,268,511,430	156,823,980,000	0001498122	0001068875	0000820027
8	EconomicCapitalRatio	-27.0	-8.21	1.29	2.91	3.08	0001498122	0000914208	0001284812

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	DepositsAndPayablesToCustomers	-3.20	-1.05	0.115	0.312	0.411	0001498122	0001403528	0000909108
1	Debt	-5.46	-1.62	0.194	0.572	0.740	0001498122	0001109448	0000909108
2	LoansPayable	-3.29	-1.63	0.125	0.298	0.412	0001498122	0001326141	0001524223
3	OperatingAndEmployeeLiabilities	-6.54	-0.655	0.101	2.15	40.2	0001498122	0001524223	0001377167
4	remainder_Liabilities	-3.63	-2.05	0.354	1.23	2.50	0001377167	0001109448	0001498122
5	Investments	-13.8	-2.42	-0.189	1.56	2.16	0001498122	0001524223	0000944130
6	CashAndCurrentAssets	-15.2	-2.78	-0.0865	0.558	1.60	0001498122	0000350797	0001279715
7	IntangibleAssets	-10.1	-1.58	-0.0819	0.682	1.09	0001498122	0001145255	0001065865
8	remainder_Assets	-17.0	-3.28	-0.145	1.58	2.05	0001498122	0000883237	0001313918
9	LaborExpense	-2.13	-1.44	0.0312	0.763	1.77	0000909108	0000009235	0001498122
10	SellingAndGeneralAdministrativeExpense	-10.7	-2.11	0.174	0.622	0.963	0001377167	0001386926	0001524223
11	CostOfGoodsSold	-1.80	-0.251	0.0613	0.152	0.298	0001068875	0000350797	0001498122
12	OperatingExpenses	-9.62	-2.62	0.206	1.23	4.12	0001377167	0000944130	0001498122
13	DepreciationInterestAndFeesExpenses	-1.18	-0.109	0.0350	0.150	0.169	0001407161	0001145255	0001498122
14	remainder_Expenses	-21.2	-1.98	-0.0920	2.34	11.4	0001498122	0001313918	0001377167
15	InvestmentIncome	-0.0425	-0.0217	-0.00932	0.00517	0.0979	0001498122	0000350797	0001527166
16	LoansIncome	0	0	0	0	0	0000009235	0001165002	0000009235
17	RevenueFromContractWithCustomer	-0.0755	-0.0386	-0.0167	-0.00613	0.321	0001498122	0001326141	0001497770
18	remainder_Revenues	-5.30	-2.52	0.0825	2.19	3.31	0001498122	0000914208	0000909108
19	remainder_NetIncome	-1.36	-0.588	-0.177	2.16	5.16	0001498122	0000009235	0001524223
20	remainder_ComprehensiveNetIncome	-0.774	-0.530	0.0905	0.259	0.462	0001404912	0000754811	0001498122

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-11.2	-1.73	0.459	2.12	3.17	0001498122	0001380393	0001372183
1	Assets	-23.7	-6.11	-0.125	0.971	1.45	0001498122	0001430592	0001279715
2	Expenses	-16.5	-3.29	-0.0870	0.646	1.09	0001498122	0001279715	0001404912
3	Revenues	-5.42	-2.58	0.0611	2.14	3.25	0001498122	0000914208	0000909108
4	StockholdersEquity	-8.90	-4.95	-0.126	1.99	2.53	0001498122	0000804269	0000009235
5	NetIncome	-23.3	-4.89	0.280	1.19	1.88	0001498122	0001065865	0000909108
6	ComprehensiveNetIncome	-22.8	-4.74	0.324	1.35	2.10	0001498122	0001004434	0000909108
7	BaseVar	nan	nan	nan	nan	nan	0000009235	0001165002	0000009235
8	EconomicCapitalRatio	-27.2	-8.38	1.12	2.75	2.91	0001498122	0000914208	0001284812

2013

Logs

error	2 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001183082 0001558432
error	2 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0000009235 0000318673
warning	6 × Similarly named company. Duplicate?	None	0001279715 0001380393 0001404912 0001517302 0001549966 0001430592
warning	3 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001558432 0001313918 0000038777
warning	3 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001386926 0001403528 0001411494
warning	3 × Ignoring company because Assets is zero	pre-agg	0000038777 0001095146 0001498122
warning	2 × Missing logo	subcommand.report	0001386926 0001580185
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0001411494
warning	1 × Zero effects	check_effects	{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '36 of 36'}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001005101
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001386926
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001326141

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	DepositsAndPayablesToCustomers	0	0	0	1,044,868,750	81,223,000,000	0000350797	0000749038	0000820027
1	Debt	0	0	0	622,098,000	1,177,559,000	0000717720	0001109448	0000889609
2	LoansPayable	0	0	0	518,276,000	15,528,200,000	0000717720	0000944130	0001527166
3	OperatingAndEmployeeLiabilities	0	0	26,132,393	759,069,500	2,253,000,000	0000820027	0000717720	0001527166
4	remainder_Liabilities	0	27,706	55,152,237	8,283,798,000	54,121,000,000	0000754811	0001289419	0000820027
5	Investments	0	0	0	10,369,238,500	47,383,697,000	0000717720	0000754811	0001404912
6	CashAndCurrentAssets	0	262,830	206,465,380	1,512,310,250	2,632,000,000	0000944130	0001517302	0000820027
7	IntangibleAssets	0	0	419,919	2,077,578,500	3,802,400,000	0000717720	0000749038	0001004434
8	remainder_Assets	0	556,754	162,303,782	25,084,072,250	141,944,000,000	0001372183	0001411488	0000820027
9	LaborExpense	0	0	35,623,715	1,307,567,000	2,244,100,000	0000749038	0000909108	0001527166
10	SellingAndGeneralAdministrativeExpense	0	0	14,152,139	444,500,000	2,945,000,000	0000350797	0001056288	0000820027
11	CostOfGoodsSold	0	0	0	371,602,750	3,036,000,000	0000350797	0000944130	0000820027
12	OperatingExpenses	0	0	25,457,549	1,179,760,750	1,941,715,000	0000820027	0000717720	0001411494
13	DepreciationInterestAndFeesExpenses	0	0	1,590,412	116,550,250	2,760,000,000	0000350797	0001014111	0000820027
14	remainder_Expenses	-1,697,535,000	-949,676,000	-8,012,241	799,059,000	1,011,000,000	0001411494	0001145255	0000820027
15	InvestmentIncome	0	0	0	54,240,000	1,073,800,000	0000350797	0000717720	0001527166
16	LoansIncome	0	0	0	0	231,330,000	0000350797	0001279715	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000350797	0001279715	0000350797
18	remainder_Revenues	0	0	246,677,268	3,458,942,750	11,230,000,000	0000754811	0001284812	0000820027
19	remainder_NetIncome	-78,685,000	-7,250,000	4,200,408	3,601,076,000	7,892,154,000	0000350797	0000909108	0001404912
20	remainder_ComprehensiveNetIncome	-7,163,795,000	-2,670,565,500	-75,965	22,193,500	259,317,000	0001404912	0001524223	0001517302

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	1,825,095	2,579,543	461,240,483	17,065,169,250	135,344,000,000	0001510832	0001386278	0000820027
1	Assets	188,284	17,227,444	953,614,179	46,804,240,750	144,576,000,000	0001510832	0001289419	0000820027
2	Expenses	16,000	5,259,742	400,693,496	2,740,436,750	9,752,000,000	0000944130	0001386926	0000820027
3	Revenues	0	0	276,890,783	3,910,478,250	11,230,000,000	0000754811	0001284812	0000820027
4	StockholdersEquity	-9,119,274	7,048,047	347,722,599	21,182,852,250	46,584,818,000	0001372183	0001014111	0001404912
5	NetIncome	-234,132,000	-16,181,250	62,541,530	3,333,178,500	7,854,228,000	0001517302	0001284812	0001404912
6	ComprehensiveNetIncome	-33,000,000	-5,868,250	51,250,708	701,574,750	809,276,000	0001014111	0001360901	0001411494
7	BaseVar	5,846,018	32,227,142	2,622,461,045	45,298,525,691	168,962,875,000	0001510832	0001014111	0000820027
8	EconomicCapitalRatio	-12.1	-0.665	1.21	2.87	3.36	0001510832	0001360901	0001284812

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	DepositsAndPayablesToCustomers	-1.30	-0.589	0.113	0.297	0.360	0000820027	0000717720	0001284812
1	Debt	-2.29	-1.16	0.246	0.619	0.750	0000889609	0001109448	0001284812
2	LoansPayable	-1.46	-0.258	0.0817	0.247	0.305	0001527166	0001403528	0001284812
3	OperatingAndEmployeeLiabilities	-1.93	-0.868	0.177	1.02	17.6	0001411488	0001386926	0001510832
4	remainder_Liabilities	-2.44	-1.85	0.169	1.19	1.24	0001510832	0000889609	0001524223
5	Investments	-3.25	-0.553	-0.166	1.63	2.38	0001510832	0001065865	0000944130
6	CashAndCurrentAssets	-3.70	-0.517	-0.0484	0.865	1.21	0001510832	0001404912	0001279715
7	IntangibleAssets	-2.48	-0.315	-0.0774	0.867	1.21	0001510832	0001411488	0001372183
8	remainder_Assets	-6.22	-0.947	-0.132	1.65	1.91	0001510832	0001403256	0001386926
9	LaborExpense	-3.43	-1.41	0.0348	0.939	1.03	0001517302	0001411494	0001014111
10	SellingAndGeneralAdministrativeExpense	-7.77	-1.06	0.158	0.618	0.906	0001510832	0000889609	0001517302
11	CostOfGoodsSold	-3.77	-0.259	0.0700	0.160	0.167	0001014111	0001411488	0001517302
12	OperatingExpenses	-3.00	-1.70	-0.150	1.12	1.81	0001517302	0001145255	0001510832
13	DepreciationInterestAndFeesExpenses	-0.144	-0.114	0.0230	0.0747	0.0821	0001510832	0001403528	0001517302
14	remainder_Expenses	-2.23	-1.48	-0.0282	1.75	3.47	0001430592	0001145255	0001517302
15	InvestmentIncome	-0.0210	-0.0204	-0.00885	0.0146	0.0965	0001014111	0001411488	0001527166
16	LoansIncome	-0.0532	-0.0518	-0.0237	-0.00990	0.445	0001014111	0000350797	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000350797	0001279715	0000350797
18	remainder_Revenues	-2.59	-1.84	0.254	2.36	2.56	0001524223	0001065865	0001284812
19	remainder_NetIncome	-1.01	-0.770	-0.258	2.16	4.85	0001279715	0001145255	0001524223
20	remainder_ComprehensiveNetIncome	-0.624	-0.446	0.0815	0.273	1.54	0001404912	0001372183	0001517302

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.68	-1.42	0.465	2.07	2.63	0000944130	0001386278	0001284812
1	Assets	-9.10	-1.41	-0.0456	0.790	1.03	0001510832	0000883237	0000944130
2	Expenses	-6.43	-1.82	-0.114	0.662	0.908	0001510832	0001549966	0001404912
3	Revenues	-2.66	-1.89	0.230	2.29	2.49	0001524223	0001065865	0001284812
4	StockholdersEquity	-4.87	-2.05	-0.0892	1.70	2.04	0001510832	0001549966	0001404912
5	NetIncome	-9.72	-1.47	0.159	0.868	0.950	0001510832	0000717720	0000909108
6	ComprehensiveNetIncome	-9.43	-1.29	0.136	1.11	1.13	0001510832	0001065865	0001524223
7	BaseVar	nan	nan	nan	nan	nan	0000350797	0001279715	0000350797
8	EconomicCapitalRatio	-13.0	-1.64	0.230	1.90	2.39	0001510832	0001360901	0001284812

2014

Logs

error	3 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001380393 0000318673
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001183082
warning	5 × Similarly named company. Duplicate?	None	0001558432 0001065865 0001279715 0001549966 0001611702
warning	5 × Ignoring company because Assets is zero	pre-agg	0000038777 0001403528 0001411494 0000804269 0001498122
warning	3 × Missing logo	subcommand.report	0000009235 0001558432 0001580185
warning	3 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0001176948 0001611702
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001313918 0001550453
warning	2 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001176948 0001611702
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001176948 0001611702
warning	1 × Zero effects	check_effects	{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '38 of 38'}
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001562214

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	DepositsAndPayablesToCustomers	0	0	0	843,823,100	83,256,000,000	0000009235	0000350797	0000820027
1	Debt	0	0	0	615,856,750	1,598,496,000	0000009235	0000909108	0000889609
2	LoansPayable	0	0	0	492,850,550	16,488,600,000	0000009235	0000749038	0001527166
3	OperatingAndEmployeeLiabilities	0	0	18,419,886	640,694,750	2,312,500,000	0000009235	0001549966	0001527166
4	remainder_Liabilities	0	44,200	89,350,384	14,275,663,400	56,249,000,000	0000754811	0000889609	0000820027
5	Investments	0	0	0	10,381,773,900	60,167,626,000	0000009235	0000820027	0001404912
6	CashAndCurrentAssets	0	0	194,180,387	1,452,954,500	2,638,000,000	0000944130	0001524223	0000820027
7	IntangibleAssets	0	0	282,443	1,984,467,100	4,431,200,000	0000009235	0000749038	0001004434
8	remainder_Assets	32,427	435,858	115,820,482	9,675,348,550	146,172,000,000	0001510832	0001056288	0000820027
9	LaborExpense	0	0	28,401,133	1,272,846,900	2,005,900,000	0000749038	0001549966	0001527166
10	SellingAndGeneralAdministrativeExpense	0	0	6,017,686	491,695,000	3,095,000,000	0000009235	0001372183	0000820027
11	CostOfGoodsSold	0	0	0	361,087,450	3,236,000,000	0000009235	0001145255	0000820027
12	OperatingExpenses	0	0	27,154,765	959,396,450	1,695,700,000	0000820027	0000717720	0001004434
13	DepreciationInterestAndFeesExpenses	0	0	231,083	119,553,950	2,695,000,000	0000009235	0001558432	0000820027
14	remainder_Expenses	-1,410,300,000	-494,563,050	-2,411,869	799,008,950	1,268,000,000	0001004434	0000009235	0000820027
15	InvestmentIncome	0	0	0	3,348,300	969,400,000	0000009235	0001145255	0001527166
16	LoansIncome	0	0	0	0	286,734,000	0000009235	0001165002	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000009235	0001165002	0000009235
18	remainder_Revenues	0	0	108,932,007	2,922,085,500	12,296,000,000	0000754811	0001165002	0000820027
19	remainder_NetIncome	-19,324,000	-12,400,450	1,588,865	1,160,330,000	5,458,689,000	0001517302	0001549966	0001404912
20	remainder_ComprehensiveNetIncome	-4,931,609,000	-610,241,950	-226,350	813,372	96,200,000	0001404912	0001386278	0001611702

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	52,000	2,143,429	327,651,070	16,120,343,000	139,505,000,000	0000009235	0001289419	0000820027
1	Assets	48,363	5,701,685	774,670,012	40,476,066,750	148,810,000,000	0001510832	0001517302	0000820027
2	Expenses	12,000	1,762,853	378,637,583	2,649,240,050	10,294,000,000	0000944130	0001580185	0000820027
3	Revenues	0	0	207,440,455	3,138,668,200	12,296,000,000	0000754811	0000889609	0000820027
4	StockholdersEquity	-9,413,084	4,669,279	247,264,989	9,837,650,000	51,704,061,000	0001372183	0001580185	0001404912
5	NetIncome	-114,700,000	-36,784,950	39,843,742	1,077,835,000	5,395,020,000	0001014111	0001386278	0001404912
6	ComprehensiveNetIncome	-136,700,000	-19,538,442	39,841,223	581,652,700	1,686,000,000	0001014111	0001386278	0000820027
7	BaseVar	3,890,117	27,758,059	2,371,884,910	43,967,370,017	174,737,010,000	0001510832	0001014111	0000820027
8	EconomicCapitalRatio	-8.22	-0.924	1.40	3.02	3.38	0001510832	0001145255	0001284812

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	DepositsAndPayablesToCustomers	-1.30	-0.293	0.114	0.275	0.344	0000820027	0001558432	0001524223
1	Debt	-2.46	-0.883	0.247	0.638	0.791	0000889609	0001109448	0001524223
2	LoansPayable	-1.45	-0.167	0.0670	0.250	0.314	0001527166	0000009235	0001524223
3	OperatingAndEmployeeLiabilities	-1.41	-0.547	0.114	0.749	34.1	0001386278	0000820027	0001510832
4	remainder_Liabilities	-1.81	-1.59	0.408	1.51	2.22	0001176948	0001386278	0001372183
5	Investments	-1.69	-0.906	-0.156	1.76	2.46	0001372183	0001004434	0001404912
6	CashAndCurrentAssets	-2.30	-0.651	-0.0903	0.644	0.696	0001510832	0001404912	0001386278
7	IntangibleAssets	-1.16	-0.297	-0.0445	0.820	1.05	0001510832	0000909108	0001065865
8	remainder_Assets	-3.34	-1.62	-0.102	1.68	2.09	0001510832	0001165002	0001176948
9	LaborExpense	-1.85	-0.980	0.0754	0.783	1.17	0001596967	0001145255	0001014111
10	SellingAndGeneralAdministrativeExpense	-4.51	-0.923	0.124	0.446	0.702	0001510832	0000909108	0001524223
11	CostOfGoodsSold	-3.93	-1.11	0.0938	0.182	0.219	0001014111	0001558432	0001524223
12	OperatingExpenses	-2.17	-1.54	0.0733	1.12	1.15	0001524223	0000009235	0001430592
13	DepreciationInterestAndFeesExpenses	-0.161	-0.101	0.0172	0.0685	0.0787	0001289419	0001109448	0001524223
14	remainder_Expenses	-2.25	-1.08	-0.0901	1.47	2.18	0001430592	0000009235	0001596967
15	InvestmentIncome	-0.0115	-0.00965	-0.00513	-0.000440	0.0851	0001014111	0001279715	0001527166
16	LoansIncome	-0.0527	-0.0442	-0.0235	-0.00911	0.421	0001014111	0001279715	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	0	0000009235	0001165002	0000009235
18	remainder_Revenues	-2.51	-1.66	0.266	2.40	2.76	0001524223	0000717720	0001284812
19	remainder_NetIncome	-3.42	-0.781	-0.259	2.71	5.25	0001372183	0001065865	0001524223
20	remainder_ComprehensiveNetIncome	-0.504	-0.196	0.0363	0.0860	0.592	0001517302	0001004434	0001372183

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.66	-1.44	0.452	2.45	3.98	0000944130	0000350797	0001510832
1	Assets	-5.57	-2.15	-0.0395	0.979	1.34	0001510832	0000883237	0000009235
2	Expenses	-3.06	-1.20	-0.217	0.512	0.703	0001510832	0001326141	0001404912
3	Revenues	-2.57	-1.70	0.239	2.33	2.71	0001524223	0000717720	0001284812
4	StockholdersEquity	-4.53	-1.87	-0.167	1.60	2.61	0001510832	0001403256	0000009235
5	NetIncome	-5.38	-1.55	0.214	1.14	1.71	0001372183	0000717720	0001524223
6	ComprehensiveNetIncome	-5.09	-1.53	0.193	1.20	1.81	0001510832	0001360901	0001524223
7	BaseVar	nan	nan	nan	nan	nan	0000009235	0001165002	0000009235
8	EconomicCapitalRatio	-9.24	-1.95	0.371	1.99	2.35	0001510832	0001145255	0001284812

2015

Logs

error	2 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001377167
error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001183082
warning	6 × Ignoring company because Assets is zero	pre-agg	0000038777 0000883237 0001403528 0001411494 0001611702 0000804269
warning	5 × Similarly named company. Duplicate?	None	0001558432 0001279715 0001380393 0001420811 0001549966
warning	2 × Missing logo	subcommand.report	0001558432 0001580185
warning	2 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000318673 0001176948
warning	2 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0001176948
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.118556966159155}
warning	1 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000318673
warning	1 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001176948
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001558432
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001498122

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	DepositsAndPayablesToCustomers	0	0	0	610,649,600	80,349,000,000	0000318673	0000717720	0000820027
1	Debt	0	0	0	567,564,550	1,731,598,000	0000318673	0000717720	0000889609
2	LoansPayable	0	0	0	721,051,200	17,567,200,000	0000318673	0000754811	0001527166
3	OperatingAndEmployeeLiabilities	0	0	7,111,567	562,291,000	1,953,200,000	0000318673	0001145255	0001527166
4	remainder_Liabilities	0	490	138,242,804	7,252,562,550	56,588,000,000	0000754811	0001386278	0000820027
5	Investments	0	0	0	8,754,866,550	65,305,931,000	0000318673	0000820027	0001404912
6	CashAndCurrentAssets	0	0	160,331,141	1,187,486,850	2,357,000,000	0000944130	0001497770	0000820027
7	IntangibleAssets	0	0	0	1,890,500,750	4,354,800,000	0000717720	0001596967	0001004434
8	remainder_Assets	17,813	1,095,066	125,105,003	4,839,834,450	142,985,000,000	0001510832	0001056288	0000820027
9	LaborExpense	0	0	12,867,859	1,255,914,700	1,521,100,000	0000318673	0000717720	0001527166
10	SellingAndGeneralAdministrativeExpense	0	0	5,104,480	443,191,750	3,082,000,000	0000318673	0001145255	0000820027
11	CostOfGoodsSold	0	0	0	313,595,000	3,276,000,000	0000318673	0001284812	0000820027
12	OperatingExpenses	0	0	18,991,061	1,050,389,900	1,649,500,000	0000318673	0001145255	0001004434
13	DepreciationInterestAndFeesExpenses	0	0	1,364,131	105,516,500	2,929,000,000	0000318673	0001640384	0000820027
14	remainder_Expenses	-1,330,000,000	-372,738,550	-2,057,958	698,981,300	1,226,000,000	0001004434	0001640384	0000820027
15	InvestmentIncome	0	0	0	24,290,350	1,009,300,000	0000318673	0000350797	0001527166
16	LoansIncome	0	0	0	0	349,912,000	0000318673	0001279715	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	290,466,000	0000318673	0001279715	0001497770
18	remainder_Revenues	0	0	99,984,074	2,384,747,950	12,200,000,000	0000944130	0000909108	0000820027
19	remainder_NetIncome	-69,504,000	-40,410,400	0	849,101,200	5,341,668,000	0001403256	0000889609	0001404912
20	remainder_ComprehensiveNetIncome	-4,793,816,000	-433,949,250	-69,922	566,700	101,828,000	0001404912	0001558432	0001580185

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	415,676	2,042,100	335,657,564	20,941,595,500	136,937,000,000	0001409446	0001289419	0000820027
1	Assets	31,802	7,413,331	717,419,187	31,116,022,800	145,342,000,000	0001510832	0001420811	0000820027
2	Expenses	21,000	1,252,889	304,403,106	2,407,310,650	10,513,000,000	0000944130	0000889609	0000820027
3	Revenues	0	0	193,359,207	2,976,148,050	12,200,000,000	0000944130	0001420811	0000820027
4	StockholdersEquity	-6,034,746	-812	250,322,663	8,203,830,000	49,467,585,000	0001372183	0001596967	0001404912
5	NetIncome	-197,156,000	-59,050,100	35,887,562	821,663,850	5,275,032,000	0001580185	0000909108	0001404912
6	ComprehensiveNetIncome	-205,300,000	-61,231,350	30,175,915	566,598,200	1,153,000,000	0001014111	0001430592	0000820027
7	BaseVar	1,878,033	15,115,135	1,639,985,887	36,871,924,571	172,174,245,000	0001409446	0001014111	0000820027
8	EconomicCapitalRatio	-15.1	-3.12	1.08	2.92	3.26	0001409446	0001360901	0001524223

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	DepositsAndPayablesToCustomers	-1.27	-0.779	0.0954	0.236	0.318	0000820027	0001004434	0001524223
1	Debt	-2.20	-1.36	0.164	0.467	0.627	0000889609	0001420811	0001524223
2	LoansPayable	-2.23	-1.20	0.138	0.372	0.504	0001497770	0001420811	0001524223
3	OperatingAndEmployeeLiabilities	-3.22	-0.449	0.172	1.02	26.4	0001372183	0000889609	0001510832
4	remainder_Liabilities	-4.42	-1.63	0.224	1.34	1.54	0001409446	0001065865	0001524223
5	Investments	-5.43	-1.14	-0.219	1.85	2.56	0001409446	0001279715	0001404912
6	CashAndCurrentAssets	-5.53	-1.03	-0.0395	0.686	1.14	0001409446	0000717720	0000754811
7	IntangibleAssets	-2.90	-0.545	-0.0891	0.615	1.26	0001409446	0001580185	0001065865
8	remainder_Assets	-8.04	-2.18	-0.160	1.70	3.03	0001409446	0001404912	0001558432
9	LaborExpense	-2.07	-1.21	0.0753	0.870	1.94	0001626115	0001527166	0001014111
10	SellingAndGeneralAdministrativeExpense	-9.38	-0.768	0.149	0.627	0.738	0001409446	0000909108	0001524223
11	CostOfGoodsSold	-7.03	-0.0301	0.0599	0.126	0.178	0001014111	0000717720	0001409446
12	OperatingExpenses	-9.17	-1.50	-0.0829	1.12	1.23	0001409446	0001420811	0001430592
13	DepreciationInterestAndFeesExpenses	-0.306	-0.157	0.0274	0.114	0.195	0001640384	0001404912	0001014111
14	remainder_Expenses	-2.26	-1.25	-0.127	1.35	8.34	0001430592	0000944130	0001409446
15	InvestmentIncome	-0.140	-0.0636	-0.0309	-0.00924	0.865	0001014111	0000717720	0001420811
16	LoansIncome	-0.119	-0.0543	-0.0280	-0.0103	0.438	0001014111	0001145255	0000889609
17	RevenueFromContractWithCustomer	-0.0494	-0.0225	-0.0116	-0.00511	0.232	0001014111	0001145255	0001497770
18	remainder_Revenues	-2.98	-1.81	0.295	2.17	4.28	0001409446	0000717720	0001014111
19	remainder_NetIncome	-1.06	-0.693	-0.214	2.60	4.77	0001014111	0001109448	0001524223
20	remainder_ComprehensiveNetIncome	-0.504	-0.255	0.0214	0.0869	0.494	0001596967	0001109448	0001372183

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-3.40	-1.34	0.182	2.37	4.02	0001409446	0001004434	0001510832
1	Assets	-11.8	-3.64	-0.0444	1.09	1.52	0001409446	0000318673	0000933136
2	Expenses	-8.86	-1.40	-0.0528	0.547	0.703	0001409446	0001386278	0001404912
3	Revenues	-3.18	-1.93	0.249	2.03	3.98	0001409446	0000717720	0001014111
4	StockholdersEquity	-4.62	-3.55	-0.0598	1.51	1.92	0001409446	0000717720	0000754811
5	NetIncome	-12.7	-2.83	0.190	1.07	2.05	0001409446	0001360901	0001524223
6	ComprehensiveNetIncome	-12.6	-2.80	0.217	1.10	2.12	0001409446	0001360901	0001524223
7	BaseVar	nan	nan	nan	nan	nan	0000318673	0001284812	0000318673
8	EconomicCapitalRatio	-15.6	-3.68	0.523	2.36	2.70	0001409446	0001360901	0001524223

2016

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001183082
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001550453
warning	6 × Similarly named company. Duplicate?	None	0001279715 0001380393 0001420811 0001517302 0001549966 0001611702
warning	6 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000318673 0000883237 0001176948 0001403528 0001562214 0001611702
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528 0001562214
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001377167
warning	2 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001176948 0001611702
warning	2 × Ignoring company because Assets is zero	pre-agg	0000038777 0000804269
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -3.5279997132553422}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000318673
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001498122

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	DepositsAndPayablesToCustomers	0	0	0	601,395,250	80,210,000,000	0000318673	0000717720	0000820027
1	Debt	0	0	0	830,772,700	1,352,447,000	0000318673	0000749038	0001411494
2	LoansPayable	0	0	0	624,744,150	5,501,300,000	0000318673	0000889609	0001527166
3	OperatingAndEmployeeLiabilities	0	0	2,845,034	813,499,100	2,168,833,000	0000318673	0001372183	0001411488
4	remainder_Liabilities	0	0	145,820,934	5,081,287,300	53,319,000,000	0000754811	0001626115	0000820027
5	Investments	0	0	0	1,874,338,150	31,409,765,000	0000318673	0000820027	0001404912
6	CashAndCurrentAssets	0	0	117,273,762	2,014,738,850	2,759,354,000	0000944130	0000883237	0001404912
7	IntangibleAssets	0	0	0	1,583,789,050	4,125,500,000	0000717720	0000933136	0001004434
8	remainder_Assets	56,000	454,977	247,226,547	5,387,714,500	137,503,000,000	0001372183	0001596967	0000820027
9	LaborExpense	0	0	8,463,517	1,125,658,650	1,338,819,000	0000318673	0001145255	0001326141
10	SellingAndGeneralAdministrativeExpense	0	0	4,776,271	416,330,550	2,977,000,000	0000318673	0001145255	0000820027
11	CostOfGoodsSold	0	0	0	16,484,398	3,202,000,000	0000318673	0001284812	0000820027
12	OperatingExpenses	0	0	34,502,281	1,174,342,000	1,876,529,000	0000318673	0001626115	0001411488
13	DepreciationInterestAndFeesExpenses	0	0	754,035	105,405,700	3,269,000,000	0000318673	0001145255	0000820027
14	remainder_Expenses	-1,205,100,000	-694,571,650	-3,012,844	337,260,000	973,000,000	0001004434	0001377167	0000820027
15	InvestmentIncome	0	0	0	33,775,300	351,300,000	0000318673	0000350797	0001527166
16	LoansIncome	0	0	0	0	408,996,000	0000318673	0001284812	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	367,185,000	0000318673	0001284812	0001497770
18	remainder_Revenues	0	0	101,842,467	2,238,975,050	11,735,000,000	0000754811	0001165002	0000820027
19	remainder_NetIncome	-90,100,000	-3,691,859	2,546,422	667,082,050	2,463,900,000	0001014111	0000350797	0001004434
20	remainder_ComprehensiveNetIncome	-660,920,000	-103,119,250	-169,888	497,200	75,500,000	0001404912	0001549966	0001014111

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	375,807	1,509,022	496,998,806	7,434,312,200	133,529,000,000	0001377167	0001056288	0000820027
1	Assets	413,216	2,379,487	895,471,494	9,544,635,000	139,821,000,000	0001409446	0001517302	0000820027
2	Expenses	22,000	3,306,066	384,966,560	2,145,813,350	10,421,000,000	0000944130	0000889609	0000820027
3	Revenues	0	0	214,439,543	2,345,345,650	11,735,000,000	0000754811	0001420811	0000820027
4	StockholdersEquity	-25,300,000	-741,451	294,049,449	4,876,401,800	17,118,083,000	0001014111	0001059142	0001404912
5	NetIncome	-125,200,000	-8,816,119	44,120,538	876,581,600	1,314,000,000	0001014111	0000909108	0000820027
6	ComprehensiveNetIncome	-82,965,000	-9,241,219	33,557,649	708,064,900	1,255,000,000	0001420811	0001596967	0000820027
7	BaseVar	5,619,024	10,829,782	1,769,557,892	14,788,025,677	166,332,025,000	0001409446	0001420811	0000820027
8	EconomicCapitalRatio	-7.22	-3.53	0.956	2.96	4.31	0001409446	0001380393	0000933136

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	DepositsAndPayablesToCustomers	-1.32	-0.317	0.0869	0.207	0.303	0000820027	0001386278	0001284812
1	Debt	-2.05	-0.818	0.137	0.415	0.600	0001420811	0001377167	0001284812
2	LoansPayable	-1.96	-0.356	0.0849	0.270	0.399	0001497770	0000318673	0001284812
3	OperatingAndEmployeeLiabilities	-1.51	-0.460	0.154	0.850	9.29	0001386278	0000889609	0001409446
4	remainder_Liabilities	-1.89	-1.60	0.399	1.24	1.41	0000889609	0001109448	0001165002
5	Investments	-1.84	-1.19	-0.173	1.76	2.40	0001623590	0001279715	0000944130
6	CashAndCurrentAssets	-1.91	-1.47	-0.0383	0.680	0.994	0001623590	0001403528	0000754811
7	IntangibleAssets	-1.49	-0.584	-0.0968	0.871	3.69	0001623590	0001360901	0001372183
8	remainder_Assets	-3.63	-2.64	-0.126	1.53	1.92	0001623590	0001497770	0001059142
9	LaborExpense	-2.11	-1.24	0.0262	0.900	1.39	0001377167	0001562214	0001623590
10	SellingAndGeneralAdministrativeExpense	-3.95	-1.03	0.0511	0.408	0.494	0001623590	0000820027	0001524223
11	CostOfGoodsSold	-3.30	-0.454	0.0487	0.101	0.178	0001623590	0000754811	0001377167
12	OperatingExpenses	-7.25	-1.78	-0.0429	1.13	1.34	0001377167	0001004434	0001626115
13	DepreciationInterestAndFeesExpenses	-0.847	-0.109	0.0266	0.112	0.162	0001640384	0001109448	0001623590
14	remainder_Expenses	-1.98	-1.17	0.0289	1.50	3.68	0000749038	0001497770	0001377167
15	InvestmentIncome	-0.0925	-0.0600	-0.0268	0.00982	0.739	0001377167	0001411488	0001420811
16	LoansIncome	-0.0658	-0.0427	-0.0194	-0.00734	0.461	0001377167	0001380393	0000889609
17	RevenueFromContractWithCustomer	-0.0458	-0.0297	-0.0135	-0.00556	0.350	0001377167	0001380393	0001497770
18	remainder_Revenues	-2.25	-1.43	0.303	1.97	2.47	0001524223	0001109448	0001284812
19	remainder_NetIncome	-4.48	-1.01	-0.150	2.22	3.97	0001409446	0000318673	0001524223
20	remainder_ComprehensiveNetIncome	-1.23	-0.230	0.0148	0.0888	2.45	0001524223	0000933136	0001014111

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.63	-1.19	0.150	1.84	2.61	0000944130	0001380393	0001284812
1	Assets	-4.87	-3.17	-0.0590	0.947	1.31	0001623590	0001165002	0001404912
2	Expenses	-5.66	-2.16	-0.0573	0.552	1.20	0001377167	0001420811	0001409446
3	Revenues	-2.36	-1.50	0.258	1.77	2.35	0001524223	0001640384	0001284812
4	StockholdersEquity	-4.49	-1.98	-0.103	1.48	2.35	0001623590	0001176948	0000933136
5	NetIncome	-4.77	-4.03	0.191	1.18	1.46	0001409446	0001065865	0001524223
6	ComprehensiveNetIncome	-4.74	-3.44	0.178	0.947	1.41	0001409446	0001380393	0000933136
7	BaseVar	nan	nan	nan	nan	nan	0000318673	0001289419	0000318673
8	EconomicCapitalRatio	-7.90	-4.21	0.278	2.28	3.63	0001409446	0001380393	0000933136

2017

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0001183082
error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001550453
warning	7 × Similarly named company. Duplicate?	None	0001601712 0001279715 0001517302 0001549966 0001570827 0001611702 0001498122
warning	7 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000318673 0000883237 0001176948 0001403528 0001420811 0001562214 0001611702
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528 0001562214
warning	3 × Ignoring company because Assets is zero	pre-agg	0000038777 0000804269 0000924095
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001377167
warning	2 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0000318673 0001601712
warning	2 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001176948 0001611702
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -5.16666355440711}
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001697412

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	DepositsAndPayablesToCustomers	0	0	0	2,904,736,600	87,368,000,000	0000318673	0000717720	0000820027
1	Debt	0	0	0	1,241,988,700	20,799,000,000	0000318673	0000883237	0001601712
2	LoansPayable	0	0	0	833,750,000	6,232,500,000	0000318673	0000944130	0001527166
3	OperatingAndEmployeeLiabilities	0	0	547,598	1,104,362,800	2,780,787,000	0000318673	0001706509	0001411488
4	remainder_Liabilities	0	0	136,710,903	12,523,836,700	56,488,000,000	0000754811	0001626115	0001601712
5	Investments	0	0	0	9,944,150,000	76,373,000,000	0000318673	0001109448	0001601712
6	CashAndCurrentAssets	0	0	69,607,226	2,487,801,700	11,602,000,000	0000820027	0001059142	0001601712
7	IntangibleAssets	0	0	0	3,477,708,800	8,149,400,000	0000717720	0001059142	0000914208
8	remainder_Assets	0	14,690	163,409,701	6,681,699,300	147,470,000,000	0001409446	0001284812	0000820027
9	LaborExpense	0	0	17,512,348	1,371,999,600	1,961,300,000	0000318673	0000717720	0001527166
10	SellingAndGeneralAdministrativeExpense	0	0	3,500,271	394,251,200	3,051,000,000	0000318673	0000754811	0000820027
11	CostOfGoodsSold	0	0	0	5,991,419	3,399,000,000	0000318673	0001360901	0000820027
12	OperatingExpenses	0	0	35,251,073	1,500,937,400	3,883,200,000	0000318673	0000717720	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	234,747	111,085,300	2,889,000,000	0000318673	0001562214	0000820027
14	remainder_Expenses	-3,121,200,000	-844,450,400	-403,049	561,773,900	1,431,000,000	0000914208	0001409446	0001601712
15	InvestmentIncome	0	0	0	26,017,600	446,400,000	0000318673	0001326141	0001527166
16	LoansIncome	0	0	0	0	424,174,000	0000318673	0001360901	0000889609
17	RevenueFromContractWithCustomer	0	0	0	0	439,370,000	0000318673	0001360901	0001497770
18	remainder_Revenues	0	0	91,587,106	3,236,617,200	12,075,000,000	0000754811	0001549966	0000820027
19	remainder_NetIncome	-67,848,000	-1,703,300	5,655,307	1,379,398,800	6,783,000,000	0001651094	0001284812	0001601712
20	remainder_ComprehensiveNetIncome	-1,518,179,000	-764,626,300	0	46,436,485	384,400,000	0001404912	0000944130	0000914208

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	4,980	498,647	561,600,719	23,280,575,700	141,472,000,000	0001697412	0001570827	0000820027
1	Assets	727	99,373	837,634,234	35,918,575,700	147,470,000,000	0001409446	0001517302	0000820027
2	Expenses	7,711	333,360	365,525,942	3,054,140,000	10,595,000,000	0001697412	0001420811	0000820027
3	Revenues	0	0	145,913,041	3,429,440,200	12,075,000,000	0000754811	0000909108	0000820027
4	StockholdersEquity	-26,700,000	-942,278	266,365,285	6,958,240,000	20,662,800,000	0001014111	0001420811	0001404912
5	NetIncome	-155,768,000	-15,621,500	25,907,817	1,454,547,300	3,324,000,000	0001411488	0000933136	0001601712
6	ComprehensiveNetIncome	-122,940,000	-9,401,125	25,884,943	1,182,004,100	1,924,000,000	0001411488	0000933136	0001601712
7	BaseVar	37,805	1,931,517	1,737,530,725	40,792,912,436	174,774,165,000	0001697412	0001570827	0000820027
8	EconomicCapitalRatio	-14.2	-5.17	0.976	3.03	3.31	0001640384	0001059142	0000933136

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	DepositsAndPayablesToCustomers	-1.68	-0.858	0.1000	0.315	0.610	0001640384	0001386278	0001409446
1	Debt	-2.64	-1.26	0.147	0.529	0.985	0001640384	0001014111	0001409446
2	LoansPayable	-1.42	-0.175	0.0632	0.255	0.455	0001527166	0001014111	0001409446
3	OperatingAndEmployeeLiabilities	-6.50	-1.36	0.230	0.877	16.7	0001409446	0000318673	0001414767
4	remainder_Liabilities	-5.76	-1.68	0.380	1.41	2.56	0001640384	0001527166	0001409446
5	Investments	-7.56	-1.01	-0.170	1.77	2.36	0001640384	0000820027	0000944130
6	CashAndCurrentAssets	-9.01	-0.737	-0.0670	0.602	2.25	0001640384	0001403256	0001697412
7	IntangibleAssets	-5.71	-0.684	-0.102	0.465	2.00	0001640384	0001176948	0001570827
8	remainder_Assets	-9.83	-1.85	-0.160	1.63	2.74	0001640384	0001404912	0001483646
9	LaborExpense	-2.29	-1.22	0.0261	0.787	2.71	0001377167	0000883237	0001640384
10	SellingAndGeneralAdministrativeExpense	-5.46	-1.12	0.113	0.517	0.574	0001623590	0000889609	0001596967
11	CostOfGoodsSold	-0.957	-0.0549	0.0200	0.0616	0.127	0001014111	0001570827	0001640384
12	OperatingExpenses	-8.48	-4.34	-0.0388	1.13	2.48	0001640384	0001004434	0001005101
13	DepreciationInterestAndFeesExpenses	-4.88	-0.303	0.0496	0.169	0.379	0001640384	0001403256	0001409446
14	remainder_Expenses	-4.08	-2.10	-0.0406	2.07	5.56	0001005101	0000933136	0001623590
15	InvestmentIncome	-0.180	-0.0873	-0.0297	0.0155	1.01	0001640384	0001145255	0001420811
16	LoansIncome	-0.0973	-0.0471	-0.0160	-0.00670	0.477	0001640384	0001145255	0000889609
17	RevenueFromContractWithCustomer	-0.102	-0.0493	-0.0167	-0.00736	0.640	0001640384	0001145255	0001497770
18	remainder_Revenues	-4.70	-1.60	0.0834	2.04	4.08	0001409446	0000318673	0001005101
19	remainder_NetIncome	-1.85	-0.987	-0.200	2.62	12.0	0001640384	0001274173	0001409446
20	remainder_ComprehensiveNetIncome	-0.835	-0.330	0.0241	0.115	0.633	0001524223	0001145255	0001014111

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-7.52	-1.38	0.291	2.32	3.40	0001640384	0001274173	0001414767
1	Assets	-13.7	-2.92	-0.0331	0.950	1.15	0001640384	0001145255	0001404912
2	Expenses	-13.7	-2.25	-0.0982	0.561	0.645	0001640384	0001403256	0001404912
3	Revenues	-4.98	-1.69	0.187	1.93	3.91	0001409446	0001014111	0001005101
4	StockholdersEquity	-7.24	-3.37	-0.0813	1.72	2.68	0001409446	0001386278	0000933136
5	NetIncome	-14.7	-3.45	0.183	1.09	5.55	0001640384	0001386278	0001409446
6	ComprehensiveNetIncome	-14.6	-3.42	0.191	1.10	5.66	0001640384	0001570827	0001409446
7	BaseVar	nan	nan	nan	nan	nan	0000318673	0001386278	0000318673
8	EconomicCapitalRatio	-14.7	-5.70	0.443	2.50	2.77	0001640384	0001059142	0000933136

2018

Logs

error	1 × No NetIncome node found, ignoring company.	input.sec.calculation_linkbase.edgar_model_mapping	0001550453
warning	8 × Similarly named company. Duplicate?	None	0001601712 0001279715 0001498122 0001517302 0001549966 0001570827 0001611702 0001651052
warning	5 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001326141 0001360901 0001403256 0001411494 0001527166
warning	4 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000883237 0001176948 0001403528 0001611702
warning	4 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001377167
warning	2 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000749038 0001697412
warning	2 × Ignoring company because Assets is zero	pre-agg	0000038777 0001711291
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -7.501167679149943}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001601712
warning	1 × Negative minimum value	check_abs_values	{'var_name': 'InvestmentIncome', 'min_value': -395183000}
warning	1 × Ignoring company because Liabilities is zero	pre-agg	0001000209
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001393818

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	DepositsAndPayablesToCustomers	0	0	0	3,753,200,000	77,925,000,000	0000350797	0000883237	0000820027
1	Debt	0	0	0	3,294,422,000	90,988,000,000	0000717720	0000820027	0000804269
2	LoansPayable	0	0	0	1,109,454,600	6,832,700,000	0000717720	0000749038	0001527166
3	OperatingAndEmployeeLiabilities	0	0	655,164	734,787,300	2,222,300,000	0000804269	0001377167	0001527166
4	remainder_Liabilities	0	0	77,155,648	13,740,475,500	64,019,000,000	0000924095	0001570827	0001601712
5	Investments	0	0	0	26,220,654,600	96,071,000,000	0000717720	0000883237	0000804269
6	CashAndCurrentAssets	0	0	70,724,726	2,135,912,800	9,396,000,000	0000820027	0001399249	0001601712
7	IntangibleAssets	0	0	0	2,456,530,000	9,333,200,000	0000717720	0000754811	0000914208
8	remainder_Assets	-8,646,000	210	90,471,183	8,823,796,800	137,216,000,000	0000749038	0001056288	0000820027
9	LaborExpense	0	0	13,064,446	1,393,267,700	1,508,813,000	0000749038	0001145255	0001326141
10	SellingAndGeneralAdministrativeExpense	0	0	3,871,196	447,388,800	3,171,000,000	0000350797	0000754811	0000820027
11	CostOfGoodsSold	0	0	0	136,052,500	3,637,000,000	0000350797	0001360901	0000820027
12	OperatingExpenses	0	0	8,301,345	1,259,532,900	4,109,200,000	0000820027	0001014111	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	114,906	473,817,800	3,225,000,000	0000350797	0001377167	0000804269
14	remainder_Expenses	-3,172,000,000	-619,893,600	-759,588	825,179,200	7,882,000,000	0000914208	0001279715	0000804269
15	InvestmentIncome	-395,183,000	0	0	29,467,800	383,579,000	0001411494	0001326141	0001420811
16	LoansIncome	0	0	0	0	3,629,000,000	0000350797	0001377167	0000804269
17	RevenueFromContractWithCustomer	0	0	0	1,210,797,600	5,314,100,000	0000350797	0000804269	0000914208
18	remainder_Revenues	0	0	3,890,406	3,011,700,000	12,924,000,000	0000749038	0001377167	0000820027
19	remainder_NetIncome	-84,854,000	-46,695,500	0	397,353,300	7,474,000,000	0001411494	0000889609	0001601712
20	remainder_ComprehensiveNetIncome	-1,337,576,000	-394,330,000	0	1,631,500	38,673,000	0001404912	0001498122	0001651052

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	7,474	236,843	504,130,275	45,386,736,200	131,628,000,000	0001697412	0001056288	0000820027
1	Assets	4,624	7,271	805,604,549	67,557,962,500	137,216,000,000	0000924095	0001517302	0000820027
2	Expenses	20,000	161,957	375,437,794	4,209,210,000	12,629,000,000	0000944130	0000889609	0000804269
3	Revenues	0	0	381,157,786	3,988,062,000	14,016,000,000	0000749038	0001284812	0000804269
4	StockholdersEquity	-19,200,000	-2,284,614	304,464,765	10,030,380,000	25,382,609,000	0001014111	0001420811	0001404912
5	NetIncome	-806,322,000	-19,352,099	25,355,695	1,728,400,000	3,644,000,000	0001176948	0001420811	0001601712
6	ComprehensiveNetIncome	-806,322,000	-10,843,799	20,635,945	1,160,959,000	2,792,000,000	0001176948	0001145255	0001601712
7	BaseVar	61,769	1,641,614	2,040,571,232	68,635,929,510	166,821,115,000	0001697412	0001420811	0000820027
8	EconomicCapitalRatio	-23.2	-7.50	0.832	2.85	4.08	0001483646	0001411494	0000749038

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	DepositsAndPayablesToCustomers	-2.42	-1.03	0.0864	0.296	0.385	0001483646	0001497770	0001005101
1	Debt	-5.08	-1.62	0.144	0.669	0.864	0001483646	0000889609	0001005101
2	LoansPayable	-1.89	-0.811	0.0453	0.218	0.297	0001483646	0000889609	0001005101
3	OperatingAndEmployeeLiabilities	-1.24	-0.141	0.363	1.39	18.0	0001386278	0001497770	0001409446
4	remainder_Liabilities	-9.39	-1.94	0.420	1.14	1.71	0001483646	0001274173	0001005101
5	Investments	-11.1	-2.22	-0.237	1.74	2.19	0001483646	0000820027	0000944130
6	CashAndCurrentAssets	-10.3	-1.87	-0.111	0.477	5.83	0001483646	0000883237	0001279715
7	IntangibleAssets	-6.75	-1.16	-0.0898	1.17	1.95	0001483646	0001411494	0001651052
8	remainder_Assets	-13.3	-2.53	-0.177	2.00	2.40	0001483646	0001601712	0001176948
9	LaborExpense	-4.50	-1.27	0.0631	0.838	1.92	0001377167	0001386278	0001706509
10	SellingAndGeneralAdministrativeExpense	-4.10	-0.953	0.0826	0.459	0.513	0001697412	0001145255	0001626115
11	CostOfGoodsSold	-1.08	-0.0859	0.0254	0.0943	0.126	0001289419	0001386278	0001706509
12	OperatingExpenses	-9.71	-3.11	0.0647	1.28	3.94	0001697412	0001411494	0001483646
13	DepreciationInterestAndFeesExpenses	-7.17	-0.699	0.0821	0.326	0.646	0001697412	0001056288	0001706509
14	remainder_Expenses	-17.3	-2.54	0.0705	1.69	11.6	0001483646	0000350797	0001697412
15	InvestmentIncome	-0.234	-0.0873	-0.0208	0.000979	0.999	0001411494	0000754811	0001420811
16	LoansIncome	-0.0820	-0.0612	-0.0174	-0.00685	0.416	0001706509	0001145255	0000889609
17	RevenueFromContractWithCustomer	-1.99	-1.49	-0.328	2.40	2.86	0001706509	0001420811	0001626115
18	remainder_Revenues	-2.98	-1.10	-0.299	2.98	6.46	0001483646	0001404912	0001706509
19	remainder_NetIncome	-2.93	-1.09	-0.0579	1.24	3.18	0001483646	0001109448	0001596967
20	remainder_ComprehensiveNetIncome	-1.13	-0.221	0.0272	0.172	0.301	0001399249	0001497770	0000754811

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-10.7	-1.23	0.446	2.48	2.94	0001483646	0001623590	0001409446
1	Assets	-19.3	-4.73	-0.0348	1.08	1.13	0001483646	0001640384	0000944130
2	Expenses	-11.6	-4.86	0.0147	0.530	0.667	0001483646	0001570827	0000749038
3	Revenues	-4.95	-1.63	0.157	2.12	4.29	0001483646	0001420811	0001706509
4	StockholdersEquity	-5.08	-3.46	0.290	2.16	2.73	0001483646	0001497770	0001279715
5	NetIncome	-19.5	-5.12	0.310	1.28	1.80	0001483646	0001497770	0001399249
6	ComprehensiveNetIncome	-19.3	-5.06	0.389	1.05	1.53	0001483646	0001386278	0000749038
7	BaseVar	nan	nan	nan	nan	nan	0000350797	0001377167	0000350797
8	EconomicCapitalRatio	-23.0	-7.35	0.981	3.00	4.23	0001483646	0001411494	0000749038

2019

Logs

warning	9 × Similarly named company. Duplicate?	None	0001279715 0001517302 0001549966 0001570827 0001591587 0001601712 0001651052 0001748824 0001538716
warning	6 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001326141 0001360901 0001393818 0001403256 0001411494 0001527166
warning	5 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0001014111 0000883237 0001176948 0001403528 0001748824
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528 0001748824
warning	3 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000754811 0000933136 0001411494
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001377167
warning	2 × Ignoring company because Assets is zero	pre-agg	0000038777 0000933136
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.825303839610399}
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001000209
warning	1 × Ignoring company because ECR is too negative	pre-agg	0000924095

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	DepositsAndPayablesToCustomers	0	0	0	3,808,500,000	87,488,000,000	0000318673	0000909108	0000820027
1	Debt	0	0	0	3,500,245,000	88,938,000,000	0000318673	0000889609	0000804269
2	LoansPayable	0	0	0	1,911,350,000	11,886,882,000	0000318673	0000820027	0001393818
3	OperatingAndEmployeeLiabilities	0	0	4,023,915	1,279,180,400	4,339,038,000	0000318673	0001640384	0001393818
4	remainder_Liabilities	0	0	192,662,167	13,191,800,050	65,154,000,000	0001279715	0001403256	0001601712
5	Investments	0	0	19,603,109	27,580,270,050	95,573,000,000	0000717720	0000749038	0000804269
6	CashAndCurrentAssets	0	32,146	73,166,632	3,101,145,200	12,147,000,000	0000820027	0000883237	0001601712
7	IntangibleAssets	0	0	0	2,461,393,800	15,867,700,000	0000717720	0001403256	0000914208
8	remainder_Assets	-12,322,000	52,888	218,227,496	9,155,712,400	151,828,000,000	0000749038	0001289419	0000820027
9	LaborExpense	0	0	14,396,034	1,577,188,750	3,067,857,000	0000318673	0000717720	0001393818
10	SellingAndGeneralAdministrativeExpense	0	0	4,928,504	522,151,200	3,287,000,000	0000318673	0001145255	0000820027
11	CostOfGoodsSold	0	0	0	116,055,550	3,810,000,000	0000350797	0000350797	0000820027
12	OperatingExpenses	0	0	13,633,648	1,565,048,050	5,309,200,000	0000318673	0001005101	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	1,554,537	235,013,650	3,641,000,000	0000350797	0001640384	0000804269
14	remainder_Expenses	-3,771,400,000	-657,625,100	-2,445,823	908,800,000	7,948,000,000	0000914208	0001640384	0000804269
15	InvestmentIncome	0	0	0	133,232,850	3,473,813,000	0000318673	0000350797	0001393818
16	LoansIncome	0	0	0	270,264,750	4,071,000,000	0000318673	0000350797	0000804269
17	RevenueFromContractWithCustomer	0	0	0	1,234,623,950	6,117,400,000	0000318673	0000944130	0000914208
18	remainder_Revenues	0	0	3,769,053	3,530,202,150	13,103,000,000	0000883237	0001377167	0000820027
19	remainder_NetIncome	-97,237,000	-47,391,150	257,479	494,661,000	4,887,000,000	0001538716	0001623590	0001601712
20	remainder_ComprehensiveNetIncome	-2,635,549,000	-709,973,650	0	20,195,000	553,000,000	0001404912	0001176948	0000820027

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	52,295	461,329	652,774,412	39,298,103,250	146,099,000,000	0001697412	0001596967	0000820027
1	Assets	37,819	177,787	1,163,558,912	67,488,321,150	151,828,000,000	0001697412	0001591587	0000820027
2	Expenses	19,000	391,125	457,697,680	4,181,194,150	13,153,000,000	0000944130	0000883237	0000804269
3	Revenues	0	0	378,685,671	6,300,530,500	14,554,000,000	0000944130	0001284812	0000804269
4	StockholdersEquity	-4,668,067	-257,605	338,379,786	14,759,730,000	30,502,374,000	0001623590	0001403256	0001404912
5	NetIncome	-1,392,634,000	-5,664,896	38,905,270	2,171,100,000	4,639,540,000	0001176948	0001399249	0001404912
6	ComprehensiveNetIncome	-1,392,634,000	-5,868,197	31,796,473	2,012,041,500	3,764,000,000	0001176948	0001651094	0001601712
7	BaseVar	120,626	3,078,991	2,663,480,072	70,659,612,722	182,159,610,000	0001697412	0001068875	0000820027
8	EconomicCapitalRatio	-17.0	-2.83	0.939	2.94	3.91	0001483646	0000350797	0001372183

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	DepositsAndPayablesToCustomers	-1.31	-0.769	0.0938	0.307	0.400	0000820027	0001414767	0001377167
1	Debt	-2.57	-1.61	0.153	0.726	0.869	0001483646	0000318673	0001377167
2	LoansPayable	-1.52	-0.993	0.107	0.415	0.529	0001483646	0001640384	0001377167
3	OperatingAndEmployeeLiabilities	-1.55	-0.573	0.205	1.13	15.2	0001386278	0001403528	0001483646
4	remainder_Liabilities	-5.63	-1.72	0.364	1.10	1.93	0001483646	0000717720	0001372183
5	Investments	-7.50	-1.00	-0.196	1.67	2.06	0001483646	0001279715	0001404912
6	CashAndCurrentAssets	-5.97	-0.726	-0.119	1.63	8.22	0001483646	0001404912	0001279715
7	IntangibleAssets	-5.07	-0.501	-0.112	1.06	2.06	0001483646	0001404912	0001570827
8	remainder_Assets	-9.68	-1.38	-0.194	1.89	2.30	0001483646	0001274173	0001176948
9	LaborExpense	-6.50	-1.01	0.0587	0.478	1.34	0001377167	0000914208	0001706509
10	SellingAndGeneralAdministrativeExpense	-4.84	-0.839	0.0763	0.348	0.382	0001706509	0001411494	0001626115
11	CostOfGoodsSold	-4.00	-0.135	0.0387	0.0897	0.206	0001706509	0000350797	0001377167
12	OperatingExpenses	-7.07	-1.84	0.0181	0.859	2.73	0001377167	0001411494	0001483646
13	DepreciationInterestAndFeesExpenses	-1.28	-0.314	0.0432	0.180	0.302	0001697412	0001176948	0001706509
14	remainder_Expenses	-6.91	-0.827	-0.0124	1.45	8.32	0001483646	0001279715	0001377167
15	InvestmentIncome	-0.0991	-0.0598	-0.0205	0.0267	0.448	0001377167	0001403256	0001411494
16	LoansIncome	-0.184	-0.111	-0.0381	0.115	0.714	0001377167	0001403256	0001538716
17	RevenueFromContractWithCustomer	-1.84	-0.801	-0.274	2.04	3.54	0001377167	0001527166	0001706509
18	remainder_Revenues	-2.17	-0.934	-0.244	2.04	6.73	0001706509	0001404912	0001377167
19	remainder_NetIncome	-8.67	-0.444	-0.0898	0.469	3.88	0001483646	0001527166	0001372183
20	remainder_ComprehensiveNetIncome	-0.634	-0.229	0.0224	0.109	0.539	0001399249	0001279715	0001014111

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-5.24	-1.34	0.148	2.30	2.80	0001483646	0001386278	0001005101
1	Assets	-14.0	-2.12	-0.0246	0.815	1.18	0001483646	0001550453	0001279715
2	Expenses	-5.68	-2.26	-0.0946	0.494	0.663	0001706509	0000717720	0001014111
3	Revenues	-3.69	-0.859	0.185	1.35	4.61	0001483646	0001570827	0001377167
4	StockholdersEquity	-5.35	-2.50	-0.104	1.76	2.53	0001483646	0001420811	0001550453
5	NetIncome	-14.6	-1.61	0.139	0.997	1.84	0001483646	0001068875	0001372183
6	ComprehensiveNetIncome	-14.5	-1.62	0.145	1.09	1.89	0001483646	0001626115	0001372183
7	BaseVar	nan	nan	nan	nan	nan	0000318673	0001377167	0000318673
8	EconomicCapitalRatio	-17.5	-3.37	0.396	2.40	3.37	0001483646	0000350797	0001372183

2020

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000909108
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0001005101 0001326141 0001360901 0001386278 0001393818 0001403256 0001411494 0001527166
warning	8 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000350797 0000804269 0000820027 0000883237 0001176948 0001403528 0001411494 0001748824
warning	7 × Similarly named company. Duplicate?	None	0001549966 0001591587 0001601712 0001651052 0001748824 0001692376 0001538716
warning	6 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000350797 0000883237 0001176948 0001403528 0001411494 0001748824
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001550453 0001000209 0001284812
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001813793 0001550453
warning	2 × Ignoring company because Assets is zero	pre-agg	0000038777 0001510832
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.473294947447972}
warning	1 × Missing logo	subcommand.report	0001711291
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0000749038

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	DepositsAndPayablesToCustomers	0	0	0	3,801,862,000	92,611,000,000	0000350797	0001711012	0000820027
1	Debt	0	0	0	8,806,775,000	92,425,000,000	0000749038	0000924095	0000804269
2	LoansPayable	0	0	0	3,478,306,250	7,820,200,000	0000717720	0001711291	0001527166
3	OperatingAndEmployeeLiabilities	0	0	12,518,183	1,773,862,000	4,054,104,000	0000804269	0001813793	0001393818
4	remainder_Liabilities	0	0	282,001,680	19,534,511,500	67,405,000,000	0000924095	0001626115	0000820027
5	Investments	0	0	25,497,725	26,836,675,000	71,607,000,000	0000717720	0001591587	0001601712
6	CashAndCurrentAssets	0	0	116,119,091	5,319,039,250	11,524,000,000	0000820027	0001591587	0001601712
7	IntangibleAssets	0	0	1,187,925	3,273,005,500	16,221,900,000	0000717720	0000749038	0000914208
8	remainder_Assets	-8,584,000	11,969	231,580,512	16,967,075,000	165,883,000,000	0000749038	0001289419	0000820027
9	LaborExpense	0	0	65,466,594	1,752,250,000	2,588,758,000	0000749038	0001399249	0001393818
10	SellingAndGeneralAdministrativeExpense	0	0	6,316,447	713,736,500	3,120,000,000	0000350797	0001005101	0000820027
11	CostOfGoodsSold	0	0	0	904,200,000	5,882,000,000	0000350797	0000717720	0000804269
12	OperatingExpenses	0	0	8,205,170	1,617,841,000	5,225,200,000	0000820027	0001711012	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	1,150,195	251,072,750	3,023,000,000	0000350797	0001640384	0000804269
14	remainder_Expenses	-3,974,700,000	-1,366,100,250	10,110	849,754,250	1,574,000,000	0000914208	0000944130	0000804269
15	InvestmentIncome	0	0	0	335,345,250	1,998,628,000	0000350797	0000717720	0001393818
16	LoansIncome	0	0	0	405,662,250	3,996,000,000	0000350797	0000717720	0000804269
17	RevenueFromContractWithCustomer	0	0	0	2,011,968,250	9,530,000,000	0000350797	0000717720	0000804269
18	remainder_Revenues	-288,811,000	-235	682,761	2,902,812,750	11,958,000,000	0001711291	0001640384	0000820027
19	remainder_NetIncome	-503,000,000	-198,301,250	0	445,420,000	4,428,936,000	0000933136	0001145255	0001404912
20	remainder_ComprehensiveNetIncome	-3,090,530,000	-237,645,250	0	76,557,250	367,000,000	0001404912	0001813793	0000820027

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	129,062	804,740	1,009,150,134	50,066,689,500	160,016,000,000	0001483646	0001570827	0000820027
1	Assets	12,625	204,664	1,482,310,373	83,841,876,500	165,883,000,000	0000924095	0001403256	0000820027
2	Expenses	20,000	205,503	457,130,092	4,280,710,000	11,969,000,000	0000944130	0001819796	0000804269
3	Revenues	0	0	512,478,314	6,112,845,250	13,831,000,000	0000924095	0001711291	0000804269
4	StockholdersEquity	-11,728,183	-1,661,656	449,387,228	13,846,127,250	40,799,916,000	0001813793	0001059142	0001404912
5	NetIncome	-342,755,000	-49,711,500	50,265,651	1,652,750,000	5,117,598,000	0001068875	0001399249	0001404912
6	ComprehensiveNetIncome	-342,483,000	-17,314,024	33,908,823	1,498,750,000	2,027,068,000	0001068875	0001059142	0001404912
7	BaseVar	244,959	3,911,568	3,324,662,898	83,005,574,732	193,319,415,000	0000924095	0001748824	0000820027
8	EconomicCapitalRatio	-38.0	-4.47	0.667	2.33	3.46	0001483646	0000350797	0000749038

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	DepositsAndPayablesToCustomers	-6.22	-0.695	0.0722	0.189	0.339	0001483646	0001538716	0001005101
1	Debt	-13.1	-1.49	0.144	0.498	0.848	0001483646	0001059142	0001005101
2	LoansPayable	-9.00	-0.854	0.103	0.266	0.525	0001483646	0001404912	0001005101
3	OperatingAndEmployeeLiabilities	-13.8	-1.29	0.264	0.838	9.77	0001483646	0000883237	0000924095
4	remainder_Liabilities	-22.2	-1.85	0.397	0.962	1.79	0001483646	0001109448	0001005101
5	Investments	-24.2	-1.46	-0.221	1.68	2.25	0001483646	0001377167	0001692376
6	CashAndCurrentAssets	-18.9	-1.24	-0.109	0.698	7.11	0001483646	0001377167	0001640384
7	IntangibleAssets	-18.1	-0.751	-0.131	1.45	2.13	0001483646	0001411494	0001377167
8	remainder_Assets	-28.3	-1.65	-0.220	1.90	2.15	0001483646	0001404912	0001403528
9	LaborExpense	-1.57	-1.05	0.0760	0.602	2.97	0001626115	0001651094	0001483646
10	SellingAndGeneralAdministrativeExpense	-1.80	-0.594	0.0711	0.312	0.380	0000924095	0001527166	0001626115
11	CostOfGoodsSold	-1.08	-0.272	0.0466	0.113	0.462	0001068875	0000350797	0001483646
12	OperatingExpenses	-3.76	-1.57	0.0951	0.993	5.37	0000924095	0001651094	0001483646
13	DepreciationInterestAndFeesExpenses	-2.45	-0.166	0.0477	0.181	0.740	0000924095	0000933136	0001483646
14	remainder_Expenses	-6.64	-1.35	-0.142	1.38	4.24	0001483646	0001692376	0000924095
15	InvestmentIncome	-0.402	-0.0985	-0.0474	0.0256	1.98	0001483646	0001570827	0001711291
16	LoansIncome	-0.401	-0.0982	-0.0473	0.213	0.781	0001483646	0001570827	0001538716
17	RevenueFromContractWithCustomer	-3.63	-0.722	-0.229	1.98	2.60	0001483646	0001059142	0001626115
18	remainder_Revenues	-3.82	-0.936	-0.229	1.76	3.70	0001483646	0001813793	0001005101
19	remainder_NetIncome	-31.4	-0.746	0.0535	0.623	2.69	0001483646	0001109448	0001596967
20	remainder_ComprehensiveNetIncome	-0.845	-0.146	0.000686	0.124	1.89	0001399249	0001145255	0001014111

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-27.2	-1.14	0.355	1.74	2.89	0001483646	0001109448	0001005101
1	Assets	-34.6	-3.44	-0.0316	0.910	0.977	0001483646	0000350797	0001692376
2	Expenses	-3.18	-1.76	-0.0227	0.449	3.25	0000924095	0000350797	0001483646
3	Revenues	-8.26	-1.40	0.118	1.30	2.41	0001483646	0001386278	0001005101
4	StockholdersEquity	-5.31	-3.41	0.0454	1.76	2.27	0001483646	0000883237	0001640384
5	NetIncome	-36.4	-2.41	0.166	0.920	1.22	0001483646	0001651052	0001399249
6	ComprehensiveNetIncome	-36.4	-2.22	0.169	0.818	0.995	0001483646	0000914208	0000749038
7	BaseVar	nan	nan	nan	nan	nan	0000350797	0001386278	0000350797
8	EconomicCapitalRatio	-37.7	-4.26	0.883	2.54	3.68	0001483646	0000350797	0000749038

2021

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000909108
error	1 × Negative Expenses, ignoring company.	pre-agg	0001834755
warning	7 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000820027 0001005101 0001109448 0001326141 0001403256 0001411494 0001748824
warning	6 × Similarly named company. Duplicate?	None	0001549966 0001591587 0001601712 0001651052 0001748824 0001538716
warning	6 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528 0001411494 0001748824
warning	5 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000883237 0001176948 0001403528 0001411494 0001748824
warning	3 × Ignoring company because Expenses is zero	pre-agg	0001692376 0001550453 0001000209
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001550453 0001684682
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -4.841822685539279}
warning	1 × Missing logo	subcommand.report	0001711291

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	DepositsAndPayablesToCustomers	0	0	0	2,486,509,800	133,241,000,000	0000717720	0000933136	0000820027
1	Debt	0	0	0	7,238,779,500	92,561,000,000	0000717720	0000924095	0000804269
2	LoansPayable	0	0	0	2,366,300,000	8,685,332,000	0000717720	0001377167	0001393818
3	OperatingAndEmployeeLiabilities	0	0	12,304,793	3,430,868,700	11,419,035,000	0000804269	0001813793	0001679788
4	remainder_Liabilities	-20,000	0	180,239,450	12,988,842,800	62,270,000,000	0001813793	0001626115	0001601712
5	Investments	0	0	20,478,419	28,294,040,600	100,908,000,000	0000717720	0001068875	0000804269
6	CashAndCurrentAssets	0	0	85,037,619	3,838,110,000	18,373,863,000	0000924095	0001651094	0001679788
7	IntangibleAssets	0	0	3,178,060	3,876,003,400	16,110,500,000	0000717720	0001377167	0000914208
8	remainder_Assets	0	2,444	291,385,720	13,850,864,100	75,693,000,000	0001409446	0001289419	0000820027
9	LaborExpense	0	0	19,197,934	1,927,906,800	8,350,126,000	0000804269	0000717720	0001393818
10	SellingAndGeneralAdministrativeExpense	0	0	16,406,590	809,315,500	3,435,000,000	0000804269	0001399249	0000820027
11	CostOfGoodsSold	0	0	0	676,545,100	5,015,000,000	0000717720	0000754811	0000820027
12	OperatingExpenses	0	0	10,394,888	3,235,274,700	5,106,300,000	0000820027	0001711012	0000914208
13	DepreciationInterestAndFeesExpenses	0	0	1,349,409	632,381,300	2,546,000,000	0000717720	0001684682	0000804269
14	remainder_Expenses	-4,016,500,000	-2,078,688,600	-307,808	1,147,125,000	1,495,000,000	0000914208	0001570827	0000804269
15	InvestmentIncome	0	0	0	770,448,700	16,788,721,000	0000717720	0000754811	0001393818
16	LoansIncome	0	0	0	428,039,200	4,103,000,000	0000717720	0001403528	0000804269
17	RevenueFromContractWithCustomer	0	0	0	2,350,955,100	9,026,000,000	0000717720	0001831631	0000804269
18	remainder_Revenues	-245,668,000	0	2,007	5,650,239,700	11,487,000,000	0001711291	0001145255	0000820027
19	remainder_NetIncome	-940,210,000	-55,218,300	579,176	1,503,606,300	5,503,000,000	0001823945	0001524223	0001601712
20	remainder_ComprehensiveNetIncome	-6,521,393,000	-502,675,100	0	6,129,039	36,000,000	0001393818	0001813793	0000804269

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	208,368	835,631	733,073,122	19,395,075,200	170,294,000,000	0000924095	0001748824	0000820027
1	Assets	44.0	227,552	1,385,916,009	40,345,327,200	175,979,000,000	0000924095	0001059142	0000820027
2	Expenses	20,000	149,734	514,447,618	5,738,670,000	10,683,000,000	0000944130	0001711291	0000820027
3	Revenues	0	0	530,307,017	8,687,834,400	22,577,148,000	0000924095	0001591587	0001393818
4	StockholdersEquity	-407,650,000	-9,560,239	466,941,411	13,485,940,000	21,706,046,000	0001823144	0001059142	0001393818
5	NetIncome	-1,802,266,000	-12,172,905	59,373,754	3,772,512,000	12,374,995,000	0001823945	0001711291	0001393818
6	ComprehensiveNetIncome	-1,802,266,000	-10,690,448	43,012,947	3,546,612,100	5,853,602,000	0001823945	0001684682	0001393818
7	BaseVar	259,950	3,207,576	3,001,625,579	80,235,181,306	206,180,420,000	0000924095	0001403256	0000820027
8	EconomicCapitalRatio	-8.09	-4.84	0.743	3.45	5.45	0001483646	0001497770	0000754811

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	DepositsAndPayablesToCustomers	-1.99	-0.217	0.0617	0.249	0.363	0000820027	0000933136	0001005101
1	Debt	-2.33	-1.15	0.131	0.701	0.978	0000804269	0001059142	0001005101
2	LoansPayable	-1.07	-0.526	0.0621	0.291	0.417	0001527166	0001711012	0001005101
3	OperatingAndEmployeeLiabilities	-2.57	-0.799	0.453	1.85	10.7	0001813793	0001538716	0000924095
4	remainder_Liabilities	-2.11	-1.72	0.290	0.996	1.99	0000889609	0000804269	0001005101
5	Investments	-2.71	-1.08	-0.168	1.36	1.99	0001377167	0001056288	0000804269
6	CashAndCurrentAssets	-2.36	-0.385	-0.0849	0.669	1.45	0001377167	0001818502	0001679788
7	IntangibleAssets	-1.84	-0.457	-0.120	0.985	2.97	0001605057	0000944130	0001823945
8	remainder_Assets	-4.35	-2.08	-0.277	1.49	1.93	0001377167	0001399249	0001059142
9	LaborExpense	-2.06	-1.00	0.0458	0.628	1.39	0001777835	0000914208	0001377167
10	SellingAndGeneralAdministrativeExpense	-7.19	-0.941	0.125	0.472	0.583	0001605057	0000944130	0001626115
11	CostOfGoodsSold	-1.34	-0.189	0.0433	0.117	0.215	0001068875	0001386278	0001377167
12	OperatingExpenses	-6.45	-2.08	0.0454	0.933	1.29	0001605057	0001411494	0001483646
13	DepreciationInterestAndFeesExpenses	-1.11	-0.136	0.0345	0.127	0.165	0000924095	0001813793	0001005101
14	remainder_Expenses	-2.25	-0.704	-0.136	1.32	7.03	0001483646	0000944130	0001605057
15	InvestmentIncome	-0.206	-0.112	-0.0433	0.00461	1.42	0001377167	0001004434	0001393818
16	LoansIncome	-0.175	-0.0949	-0.0397	0.223	0.552	0001377167	0001651052	0001538716
17	RevenueFromContractWithCustomer	-1.88	-1.02	-0.261	1.89	2.99	0001377167	0001813793	0001626115
18	remainder_Revenues	-0.842	-0.660	-0.247	2.27	4.57	0001483646	0001605057	0001005101
19	remainder_NetIncome	-5.92	-0.545	-0.0901	1.03	3.03	0001377167	0001386278	0001596967
20	remainder_ComprehensiveNetIncome	-1.28	-0.263	0.0234	0.141	0.560	0001399249	0001176948	0000754811

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-1.65	-1.16	0.277	2.53	3.68	0001483646	0001409446	0000754811
1	Assets	-5.41	-3.64	0.0410	0.901	1.25	0001377167	0001527166	0001829311
2	Expenses	-5.57	-1.73	0.0667	0.424	0.574	0001605057	0001831631	0001818502
3	Revenues	-2.02	-1.02	0.0614	1.73	3.07	0001483646	0000883237	0001005101
4	StockholdersEquity	-3.71	-3.22	0.230	1.77	2.82	0000924095	0001679788	0001684682
5	NetIncome	-7.86	-2.98	0.202	1.54	3.27	0001483646	0000914208	0001748824
6	ComprehensiveNetIncome	-7.79	-2.94	0.172	0.896	3.10	0001483646	0001497770	0001748824
7	BaseVar	nan	nan	nan	nan	nan	0000717720	0001414767	0000717720
8	EconomicCapitalRatio	-8.50	-5.25	0.337	3.05	5.05	0001483646	0001497770	0000754811

2022

Logs

error	1 × No matching role found	input.sec.calculation_linkbase.expand_agg	0000909108
warning	9 × Similarly named company. Duplicate?	None	0001692376 0001601712 0001549966 0001591587 0001651052 0001748824 0001854401 0001858681 0001538716
warning	8 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000820027 0001109448 0001326141 0001393818 0001403256 0001411494 0001527166 0001748824
warning	5 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001748824 0001858681
warning	4 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000883237 0001176948 0001748824 0001858681
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001601712
warning	1 × Missing logo	subcommand.report	0001711291
warning	1 × Ignoring company because Expenses is zero	pre-agg	0001000209

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	DepositsAndPayablesToCustomers	0	0	0	3,052,176,100	110,029,000,000	0000717720	0000754811	0000820027
1	Debt	0	0	0	7,515,900,000	96,854,000,000	0000717720	0001748824	0000804269
2	LoansPayable	0	0	0	2,704,500,000	13,507,655,000	0000717720	0001326141	0001393818
3	OperatingAndEmployeeLiabilities	0	0	36,329,895	4,522,054,850	80,815,293,000	0000804269	0001823144	0001679788
4	remainder_Liabilities	0	131,213	477,357,232	33,597,117,900	244,634,000,000	0000924095	0001570827	0001858681
5	Investments	0	0	59,918,068	58,032,881,200	107,215,000,000	0000717720	0001679788	0000804269
6	CashAndCurrentAssets	0	8,291	213,586,174	8,938,564,900	86,448,215,000	0001176948	0001777835	0001679788
7	IntangibleAssets	0	0	60,518,889	4,453,755,000	15,698,900,000	0000717720	0001854401	0000914208
8	remainder_Assets	0	6,004,664	781,785,997	17,210,395,950	246,031,000,000	0000924095	0001591587	0001858681
9	LaborExpense	0	0	187,780,255	1,855,620,000	3,532,454,000	0000804269	0001284812	0001393818
10	SellingAndGeneralAdministrativeExpense	0	0	46,774,624	982,396,150	3,723,000,000	0000804269	0001570827	0000820027
11	CostOfGoodsSold	0	0	0	1,498,785,000	4,923,000,000	0000717720	0001403256	0000820027
12	OperatingExpenses	0	0	151,005,385	4,037,459,750	17,480,000,000	0000820027	0001538716	0001858681
13	DepreciationInterestAndFeesExpenses	0	0	18,271,615	818,059,850	2,881,000,000	0000717720	0001596967	0000804269
14	remainder_Expenses	-3,733,100,000	-2,536,843,150	-10,294,604	1,048,649,300	1,645,000,000	0000914208	0001823945	0000804269
15	InvestmentIncome	0	0	0	676,502,100	1,474,000,000	0000717720	0000924095	0000820027
16	LoansIncome	0	0	0	389,350,000	4,521,000,000	0000717720	0001403256	0000804269
17	RevenueFromContractWithCustomer	0	0	50,498	2,801,397,950	7,811,000,000	0000717720	0000924095	0000804269
18	remainder_Revenues	-400,325,000	-685,100	2,978,001	6,134,170,100	11,462,000,000	0001711291	0001414767	0000820027
19	remainder_NetIncome	-265,473,000	-182,830,850	0	1,053,625,950	7,919,000,000	0001679788	0001145255	0001601712
20	remainder_ComprehensiveNetIncome	-10,788,000,000	-1,184,829,200	-1,391,813	17,019,400	44,833,000	0001858681	0001372183	0001777835

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	139,310	2,100,026	1,559,173,812	101,989,600,000	252,104,000,000	0000924095	0001274173	0001858681
1	Assets	57,490	12,140,572	2,666,212,982	116,251,650,000	259,333,000,000	0001409446	0001711291	0001858681
2	Expenses	268,669	3,861,798	814,166,324	8,350,189,400	16,411,000,000	0001409446	0001596967	0001858681
3	Revenues	0	35,020	848,680,073	10,110,385,550	14,347,000,000	0001409446	0001570827	0000820027
4	StockholdersEquity	-291,998,000	-42,747,100	770,622,538	14,262,050,000	19,681,067,000	0001823144	0001386278	0001393818
5	NetIncome	-5,443,000,000	-158,597,350	101,943,007	2,838,440,850	3,962,000,000	0001858681	0001591587	0001601712
6	ComprehensiveNetIncome	-16,231,000,000	-218,374,550	31,664,112	1,533,463,300	2,982,000,000	0001858681	0001692376	0000804269
7	BaseVar	1,391,834	20,189,519	4,383,262,612	135,360,984,500	306,671,445,000	0001409446	0001711291	0001858681
8	EconomicCapitalRatio	-7.76	-0.291	0.785	2.40	3.10	0000924095	0001527166	0000754811

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	DepositsAndPayablesToCustomers	-1.67	-0.305	0.0780	0.233	0.260	0000820027	0001372183	0001711012
1	Debt	-2.16	-1.08	0.166	0.630	0.771	0000804269	0001176948	0001626115
2	LoansPayable	-1.13	-0.640	0.0702	0.239	0.300	0001527166	0001538716	0001626115
3	OperatingAndEmployeeLiabilities	-4.64	-1.50	0.190	0.487	0.846	0001409446	0001748824	0001284812
4	remainder_Liabilities	-2.11	-1.68	0.416	1.24	1.47	0001692376	0000717720	0001711012
5	Investments	-3.37	-0.604	-0.178	1.69	2.32	0000924095	0001626115	0001692376
6	CashAndCurrentAssets	-0.626	-0.327	-0.0898	0.491	7.56	0001409446	0001497770	0000924095
7	IntangibleAssets	-2.81	-0.535	-0.150	1.45	1.76	0000924095	0001829311	0001570827
8	remainder_Assets	-5.07	-0.946	-0.185	1.57	2.39	0000924095	0001326141	0001829311
9	LaborExpense	-1.90	-1.04	0.00672	0.555	1.04	0001626115	0001176948	0000924095
10	SellingAndGeneralAdministrativeExpense	-1.51	-0.634	0.0323	0.265	0.423	0001711012	0001679788	0001626115
11	CostOfGoodsSold	-1.30	-0.154	0.0369	0.0857	0.122	0001823144	0001411494	0000924095
12	OperatingExpenses	-2.04	-1.19	-0.0569	0.664	1.03	0001777835	0001176948	0001626115
13	DepreciationInterestAndFeesExpenses	-0.483	-0.120	0.0287	0.0871	0.137	0001829311	0001679788	0001711012
14	remainder_Expenses	-1.00	-0.545	-0.0872	1.15	2.21	0001626115	0001679788	0001777835
15	InvestmentIncome	-0.0420	-0.0294	-0.0124	0.0785	0.172	0000924095	0001497770	0001411494
16	LoansIncome	-0.0792	-0.0554	-0.0257	0.0541	0.679	0000924095	0001109448	0001538716
17	RevenueFromContractWithCustomer	-0.872	-0.646	-0.258	1.91	2.99	0001284812	0001679788	0001626115
18	remainder_Revenues	-1.28	-0.898	-0.253	1.43	2.54	0000924095	0000804269	0001284812
19	remainder_NetIncome	-7.08	-0.370	-0.0531	1.49	2.74	0000924095	0001403256	0001711012
20	remainder_ComprehensiveNetIncome	-0.709	-0.189	0.0365	0.180	0.318	0001854401	0001176948	0001777835

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-2.32	-1.16	0.121	1.95	2.30	0000924095	0001748824	0001626115
1	Assets	-6.08	-1.52	0.0110	0.691	0.956	0000924095	0001591587	0001829311
2	Expenses	-1.36	-1.06	-0.0352	0.372	0.427	0001777835	0001414767	0001692376
3	Revenues	-2.03	-1.16	-0.00104	1.41	1.95	0000924095	0001004434	0001626115
4	StockholdersEquity	-3.86	-1.30	-0.0417	1.24	2.15	0001409446	0001056288	0001829311
5	NetIncome	-9.79	-0.958	0.106	0.697	1.00	0000924095	0001497770	0001823144
6	ComprehensiveNetIncome	-9.61	-0.894	0.0751	0.665	1.18	0000924095	0000883237	0001823144
7	BaseVar	nan	nan	nan	nan	nan	0000717720	0001409446	0000717720
8	EconomicCapitalRatio	-8.49	-1.02	0.0564	1.67	2.37	0000924095	0001527166	0000754811

2023

Logs

error	1 × IME and Company effects mismatched for Other Liabilities. IME Effects: 60.3, Company Effect: 60.4	subcommand.report	0001684682
warning	9 × Large missing amount for aggregate "Revenues" added to remainder.	industry.us_generic	0000820027 0001005101 0001109448 0001326141 0001393818 0001404912 0001527166 0001748824 0001858681
warning	7 × Similarly named company. Duplicate?	None	0001601712 0001279715 0001538716 0001591587 0001748824 0001854401 0001858681
warning	7 × Large missing amount for aggregate "Assets" added to remainder.	industry.us_generic	0000820027 0000883237 0001176948 0001403528 0001404912 0001748824 0001858681
warning	5 × Large missing amount for aggregate "Liabilities" added to remainder.	industry.us_generic	0000883237 0001176948 0001403528 0001404912 0001748824
warning	2 × No LiabilitiesAndStockholdersEquity node found	input.sec.calculation_linkbase.edgar_model_mapping	0001684682 0001550453
warning	1 × Too many companies have an ECR < -100%	check_abs_values	{'quantile_095_val': -2.079476762783903}
warning	1 × NetIncome node detected by IncomeLoss name heuristic	input.sec.calculation_linkbase.edgar_model_mapping	0001601712
warning	1 × Large missing amount for aggregate "Expenses" added to remainder.	industry.us_generic	0001404912

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	DepositsAndPayablesToCustomers	0	0	0	3,249,225,750	115,002,000,000	0000318673	0000804269	0000820027
1	Debt	0	0	0	8,377,615,000	105,327,000,000	0000318673	0001145255	0000804269
2	LoansPayable	0	0	0	2,789,450,000	13,581,317,000	0000318673	0001279715	0001393818
3	OperatingAndEmployeeLiabilities	0	0	4,682,582	4,754,600,500	197,714,131,000	0000318673	0001414767	0001679788
4	remainder_Liabilities	0	130,401	379,308,590	68,478,650,000	280,151,000,000	0001279715	0001818502	0001858681
5	Investments	0	0	12,461,229	54,745,918,050	115,219,000,000	0000717720	0001679788	0000804269
6	CashAndCurrentAssets	0	0	103,126,231	4,322,253,950	203,466,531,000	0001176948	0001823945	0001679788
7	IntangibleAssets	0	0	0	4,332,850,000	14,539,600,000	0000717720	0000717720	0000914208
8	remainder_Assets	0	194,434	751,936,214	63,256,573,050	313,187,194,000	0001605057	0001854401	0001404912
9	LaborExpense	0	0	8,898,397	1,915,522,000	3,312,970,000	0000318673	0001005101	0001393818
10	SellingAndGeneralAdministrativeExpense	0	0	14,952,279	965,337,750	3,871,000,000	0000318673	0001777835	0000820027
11	CostOfGoodsSold	0	0	0	1,383,435,000	5,078,000,000	0000717720	0001326141	0000820027
12	OperatingExpenses	0	0	26,482,668	3,057,560,850	27,331,000,000	0000318673	0000717720	0001858681
13	DepreciationInterestAndFeesExpenses	0	0	759,843	657,440,600	4,685,000,000	0000717720	0001829311	0000804269
14	remainder_Expenses	-4,231,100,000	-1,391,824,800	-1,017,468	1,455,850,000	13,556,128,000	0000914208	0001829311	0001404912
15	InvestmentIncome	0	0	0	217,812,450	3,206,000,000	0000717720	0000754811	0000820027
16	LoansIncome	0	0	0	342,848,550	6,204,000,000	0000318673	0001326141	0000804269
17	RevenueFromContractWithCustomer	0	0	0	2,923,546,200	7,266,000,000	0000318673	0000889609	0000804269
18	remainder_Revenues	0	0	11,816,235	9,748,549,550	32,644,000,000	0000883237	0000754811	0001858681
19	remainder_NetIncome	-596,839,000	-64,712,600	558,766	774,302,100	7,373,000,000	0001538716	0000924095	0001601712
20	remainder_ComprehensiveNetIncome	-1,045,031,000	-515,901,300	0	134,253,750	780,000,000	0001393818	0000944130	0000820027

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	83,000	745,824	1,251,020,304	187,093,617,200	288,243,000,000	0001279715	0001647639	0001858681
1	Assets	141,027	1,703,279	2,059,887,246	192,676,574,150	317,294,194,000	0001409446	0001056288	0001404912
2	Expenses	20,000	1,211,352	604,582,830	12,899,650,000	26,408,000,000	0000944130	0001538716	0001858681
3	Revenues	0	0	467,536,726	14,375,421,600	32,644,000,000	0000944130	0001284812	0001858681
4	StockholdersEquity	-205,773,000	-689,781	590,767,289	17,103,567,700	58,378,912,000	0001823144	0001647639	0001404912
5	NetIncome	-496,700,000	-210,509,550	41,299,946	2,747,400,000	6,236,000,000	0001527166	0000909108	0001858681
6	ComprehensiveNetIncome	-583,500,000	-216,426,600	42,777,324	2,919,300,000	6,531,000,000	0001527166	0000909108	0001858681
7	BaseVar	1,032,205	3,217,767	3,541,554,157	213,000,568,073	380,093,745,000	0001409446	0000889609	0001858681
8	EconomicCapitalRatio	-18.5	-2.08	0.639	2.86	3.38	0001605057	0001854401	0001684682

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	DepositsAndPayablesToCustomers	-1.60	-0.430	0.0562	0.149	0.258	0000820027	0001854401	0001005101
1	Debt	-4.56	-1.77	0.227	0.601	1.04	0001605057	0001538716	0001005101
2	LoansPayable	-1.75	-0.889	0.0723	0.193	0.362	0001605057	0001538716	0001005101
3	OperatingAndEmployeeLiabilities	-2.59	-0.494	0.209	0.753	3.64	0001679788	0001748824	0001605057
4	remainder_Liabilities	-7.94	-1.79	0.381	1.05	2.04	0001605057	0000933136	0001005101
5	Investments	-8.34	-0.590	-0.138	1.58	1.93	0001605057	0000717720	0000804269
6	CashAndCurrentAssets	-6.15	-0.552	-0.0970	0.406	8.79	0001605057	0001818502	0001279715
7	IntangibleAssets	-5.98	-0.370	-0.0978	0.733	1.48	0001605057	0001284812	0001823945
8	remainder_Assets	-14.7	-1.26	-0.217	1.26	1.44	0001605057	0001109448	0001829311
9	LaborExpense	-2.04	-0.857	0.0617	0.544	1.44	0001777835	0001403528	0001605057
10	SellingAndGeneralAdministrativeExpense	-13.4	-0.953	0.0745	0.270	0.369	0001605057	0001176948	0001777835
11	CostOfGoodsSold	-1.52	-0.137	0.0333	0.0959	0.211	0001823144	0001854401	0001605057
12	OperatingExpenses	-14.7	-1.79	0.113	0.724	1.21	0001605057	0000889609	0001823144
13	DepreciationInterestAndFeesExpenses	-0.563	-0.129	0.0263	0.103	0.274	0000924095	0001818502	0001605057
14	remainder_Expenses	-0.835	-0.640	-0.122	1.91	12.8	0000318673	0001854401	0001605057
15	InvestmentIncome	-0.0360	-0.0163	-0.00588	0.0316	0.109	0001605057	0001854401	0001527166
16	LoansIncome	-0.180	-0.0818	-0.0295	0.0872	0.770	0001605057	0001854401	0001538716
17	RevenueFromContractWithCustomer	-1.69	-0.485	-0.204	2.01	2.83	0001605057	0000889609	0001823144
18	remainder_Revenues	-1.84	-0.889	-0.234	1.37	3.47	0000924095	0001818502	0001005101
19	remainder_NetIncome	-0.757	-0.403	-0.0533	0.427	4.14	0001605057	0001274173	0000924095
20	remainder_ComprehensiveNetIncome	-0.204	-0.0839	0.00122	0.0516	0.415	0000754811	0001854401	0001777835

	yvar	min	5%	median	95%	max	min_company	median_company	max_company
0	Liabilities	-9.25	-1.18	0.202	1.75	2.94	0001605057	0001326141	0001005101
1	Assets	-16.9	-1.86	0.0302	0.592	0.698	0001605057	0000754811	0000944130
2	Expenses	-13.4	-1.92	0.0727	0.443	0.492	0001605057	0000318673	0001818502
3	Revenues	-2.80	-0.569	0.0442	1.41	2.51	0001605057	0000914208	0001005101
4	StockholdersEquity	-6.32	-3.12	-0.236	1.99	2.53	0001605057	0001404912	0001550453
5	NetIncome	-17.0	-1.38	0.100	0.757	1.11	0001605057	0001601712	0001823144
6	ComprehensiveNetIncome	-17.0	-1.34	0.101	0.762	1.08	0001605057	0001176948	0001823144
7	BaseVar	nan	nan	nan	nan	nan	0000318673	0001386278	0000318673
8	EconomicCapitalRatio	-19.0	-2.55	0.165	2.38	2.90	0001605057	0001854401	0001684682

Estimates

Parameter	Value	Min	Max
PresentValueFactor	2.67	1.0	15.0
BalanceFactor	1.63	0.5	5.0
OCIFactor	1.0	0.5	1.0
HiddenReservesFactor	0.0	0.0	0.0
LLPO_stddev	0.2	0.2	10.0

QA: us_finance_services 2009-2023

Table of Contents

Ranks across the years

PDF reports

2009

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2010

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2011

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2012

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2013

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2014

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2015

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2016

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2017

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2018

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2019

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2020

Logs

Diagrams

Calculation Linkbase Overview

Absolute xval/yval quantiles

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

2021

Logs

Diagrams

Calculation Linkbase Overview