QA: us_spacs 2016-2022

Table of Contents

Ranks across the years

name name_short 2016 2017 2018 2019 2020 2021 2022 2016-val 2017-val 2018-val 2019-val 2020-val 2021-val 2022-val 2016->2017 2017->2018 2018->2019 2019->2020 2020->2021 2021->2022
0001840353 Twin Ridge Capital Acquisition Corp. Twin Ri NaN NaN NaN NaN NaN 1 1 NaN NaN NaN NaN NaN 863.7990 961.085 NaN NaN NaN NaN NaN 0
0001113313 ARVANA INC ARVANA NaN 19 14 10 15 NaN 2 NaN -1014.2800 -991.2650 -987.7650 -1041.5000 NaN 411.772 NaN -5 -4 5 NaN NaN
0001599117 Mentor Capital Inc. Mentor NaN NaN 4 4 NaN 3 3 NaN NaN 651.1610 336.5320 NaN 270.5270 200.046 NaN NaN 0 NaN NaN 0
0001823086 Kingswood Acquisition Corp. Kingswo NaN NaN NaN NaN NaN 2 4 NaN NaN NaN NaN NaN 826.6590 -241.409 NaN NaN NaN NaN NaN 2
0001837774 Global Innovative Platforms Inc. Global NaN NaN NaN NaN NaN 21 5 NaN NaN NaN NaN NaN -1480.2700 -524.481 NaN NaN NaN NaN NaN -16
0000836937 UPD HOLDING CORP. UPD HOL NaN 12 NaN 22 6 7 6 NaN -545.0370 NaN -1320.6600 -889.7510 -286.3510 -569.486 NaN NaN NaN -16 1 -1
0001421636 C-Bond Systems Inc C-Bond 4 5 29 20 NaN NaN 7 857.4000 810.4160 -1904.6600 -1216.2300 NaN NaN -702.757 1 24 -9 NaN NaN NaN
0000812152 RIDGEFIELD ACQUISITION CORP RIDGEFI 14 NaN 24 11 14 17 8 -1000.8600 NaN -1035.4700 -995.2110 -1023.2100 -1045.8200 -716.339 NaN NaN -13 3 3 -9
0001709768 Sentinel Energy Services Inc. Sentine NaN NaN NaN NaN 4 9 9 NaN NaN NaN NaN -494.2930 -769.7630 -752.556 NaN NaN NaN NaN 5 0
0001130889 CANCER CAPITAL CORP CANCER 19 24 21 14 13 15 10 -1018.6700 -1019.7400 -1019.6700 -1018.0900 -1014.2500 -1019.5900 -921.844 5 -3 -7 -1 2 -5
0000730669 FCCC INC FCCC IN 1 2 2 1 1 6 11 950.3360 936.5460 751.4290 790.8400 687.6710 -95.0355 -942.735 1 0 -1 0 5 5
0001160945 NOVA STAR INNOVATIONS INC NOVA ST 17 21 20 13 11 12 12 -1012.0000 -1016.8800 -1019.2500 -1016.9200 -1006.2500 -1015.4700 -1014.840 4 -1 -7 -2 1 0
0001118072 SKINOVATION PHARMACEUTICAL INC SKINOVA 20 22 19 15 9 13 13 -1021.5500 -1017.0800 -1019.1500 -1018.4200 -997.4090 -1015.9900 -1015.600 2 -3 -4 -6 4 0
0001430319 C & C TOURS INC. C & C T 15 20 22 16 10 14 14 -1003.8000 -1016.4600 -1022.0700 -1031.8700 -1004.9200 -1017.6700 -1016.840 5 2 -6 -6 4 0
0001651932 Xenous Holdings Inc. Xenous NaN 27 26 18 NaN NaN 15 NaN -1076.0100 -1085.3800 -1058.2500 NaN NaN -1017.830 NaN -1 -8 NaN NaN NaN
0000894560 BIOETHICS LTD BIOETHI NaN NaN NaN 12 16 16 16 NaN NaN NaN -1004.7800 -1045.8900 -1034.0000 -1026.560 NaN NaN NaN 4 0 0
0001454510 LNPR GROUP INC. LNPR GR NaN NaN 16 NaN NaN NaN 17 NaN NaN -1017.7800 NaN NaN NaN -1050.850 NaN NaN NaN NaN NaN NaN
0001658521 MOUNTAIN TOP PROPERTIES INC. MOUNTAI NaN NaN NaN NaN NaN 10 18 NaN NaN NaN NaN NaN -836.1210 -1109.840 NaN NaN NaN NaN NaN 8
0000051011 INTERDYNE CO INTERDY 5 6 3 2 2 4 NaN 704.7400 808.7680 682.2080 529.1270 319.2240 65.8083 NaN 1 -3 -1 0 2 NaN
0000867028 FOMO WORLDWIDE INC. FOMO WO 12 16 28 NaN NaN 20 NaN -699.8580 -996.8900 -1205.6700 NaN NaN -1269.1200 NaN 4 12 NaN NaN NaN NaN
0000921560 Moregain Pictures Inc. Moregai 11 11 25 NaN NaN NaN NaN -624.1790 -389.2080 -1074.7500 NaN NaN NaN NaN 0 14 NaN NaN NaN NaN
0001118233 WORLDNET INC OF NEVADA WORLDNE 18 23 17 NaN NaN NaN NaN -1014.2700 -1017.9200 -1018.0600 NaN NaN NaN NaN 5 -6 NaN NaN NaN NaN
0001172318 Asia Interactive Media Inc. Asia In 8 10 11 NaN NaN NaN NaN 50.2244 -21.6191 -434.7400 NaN NaN NaN NaN 2 1 NaN NaN NaN NaN
0001263364 Idaho Copper Corp Idaho C 3 3 5 3 17 NaN NaN 902.5060 908.8480 643.1020 431.5350 -1196.9600 NaN NaN 0 2 -2 14 NaN NaN
0001351345 EDUCATION REALTY OPERATING PARTNERSHIP L P EDUCATI 6 7 NaN NaN NaN NaN NaN 583.1550 462.0280 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001418302 Renewable Energy Acquisition Corp. Renewab 22 17 NaN NaN NaN NaN NaN -1065.3200 -1001.8300 NaN NaN NaN NaN NaN -5 NaN NaN NaN NaN NaN
0001420031 EMI Holding Inc. EMI Hol 10 9 9 NaN NaN NaN NaN -514.9410 70.9587 -166.4820 NaN NaN NaN NaN -1 0 NaN NaN NaN NaN
0001422141 ZETA ACQUISITION CORP I ZETA AC 13 25 18 9 12 NaN NaN -983.2380 -1022.7100 -1018.5000 -870.1290 -1013.9300 NaN NaN 12 -7 -9 3 NaN NaN
0001499684 Qiansui International Group Co. Ltd. Qiansui 16 26 NaN NaN NaN 18 NaN -1004.4200 -1063.5000 NaN NaN NaN -1101.5400 NaN 10 NaN NaN NaN NaN NaN
0001500861 Dongxing International Inc. Dongxin 9 13 12 8 NaN NaN NaN -501.9000 -562.6720 -704.7020 -701.5000 NaN NaN NaN 4 -1 -4 NaN NaN NaN
0001504876 5V Inc. 5V Inc. 21 18 NaN NaN NaN NaN NaN -1028.2100 -1010.6600 NaN NaN NaN NaN NaN -3 NaN NaN NaN NaN NaN
0001507986 JetPay Corp JetPay 7 8 NaN NaN NaN NaN NaN 212.8070 188.6610 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001639669 Electrum Special Acquisition Corp Electru 2 4 NaN NaN NaN NaN NaN 934.0040 856.6360 NaN NaN NaN NaN NaN 2 NaN NaN NaN NaN NaN
0000710782 Liaoning Shuiyun Qinghe Rice Industry Co. Ltd. Liaonin NaN 1 1 21 NaN 19 NaN NaN 963.3470 966.4230 -1278.6300 NaN -1123.4300 NaN NaN 0 20 NaN NaN NaN
0001505367 HK Apollo Motors Corp HK Apol NaN 15 15 NaN NaN NaN NaN NaN -934.2030 -1006.0200 NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN
0001521466 APEX 2 INC. APEX 2 NaN 14 13 NaN NaN NaN NaN NaN -821.6140 -890.4600 NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN
0001591387 ATI Nationwide Holding Corp. ATI Nat NaN 28 27 NaN NaN NaN NaN NaN -1967.8900 -1156.8900 NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN
0001267612 GUOZI ZHONGYU CAPITAL HOLDINGS GUOZI Z NaN NaN 6 17 NaN NaN NaN NaN NaN 264.9570 -1038.1900 NaN NaN NaN NaN NaN 11 NaN NaN NaN
0001491829 ALPHA NETWORK ALLIANCE VENTURES INC. ALPHA N NaN NaN 23 NaN 8 NaN NaN NaN NaN -1022.2900 NaN -996.1390 NaN NaN NaN NaN NaN NaN NaN NaN
0001636509 Vitalibis Inc. Vitalib NaN NaN 8 19 NaN NaN NaN NaN NaN -74.1959 -1152.6200 NaN NaN NaN NaN NaN 11 NaN NaN NaN
0001650205 ANDES 7 INC. ANDES 7 NaN NaN 10 6 NaN NaN NaN NaN NaN -375.6460 -489.6780 NaN NaN NaN NaN NaN -4 NaN NaN NaN
0001652362 Infrastructure & Energy Alternatives Inc. Infrast NaN NaN 7 5 3 5 NaN NaN NaN -69.3725 -51.8954 -47.3771 11.6392 NaN NaN NaN -2 -2 2 NaN
0001365388 High Sierra Technologies Inc. High Si NaN NaN NaN 7 5 8 NaN NaN NaN NaN -613.5430 -601.6230 -681.4440 NaN NaN NaN NaN -2 3 NaN
0001698832 WALL STREET ACQUISITIONS Corp WALL ST NaN NaN NaN NaN 7 11 NaN NaN NaN NaN NaN -898.2420 -866.3900 NaN NaN NaN NaN NaN 4 NaN

PDF reports

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

2016

Logs

error 4 × No matching role found input.sec.calculation_linkbase.expand_agg
0001552743 0001113313 0001653882 0001505367
error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '12.4', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '12.6', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -6.620188539889264}
warning 10 × Missing logo subcommand.report
0001504876 0001118072 0001118233 0001160945 0001430319 0001499684 0001500861 0001639669 0000812152 0001130889
warning 6 × Ignoring company because Assets is zero pre-agg
0001062506 0001365388 0001411168 0001432271 0001644889 0001662645
warning 4 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001062506 0001552743 0001650204 0001650203
warning 4 × Ignoring company because Expenses is zero pre-agg
0000894560 0001099568 0000086115 0001454510
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '22 of 22'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '22 of 22'}
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 9.324287116092382}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -10.278784638122955}
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000892832
warning 1 × Ignoring company because ECR is too negative pre-agg
0001636509
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001172318

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 3,146 12,177,947 109,633,000 0000812152 0001499684 0001507986
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001172318 0000051011
2 remainder_Assets 0 0 1,550 194,653,260 2,506,185,000 0000051011 0000812152 0001351345
3 LiabilitiesCurrent 0 0 221,412 17,985,056 104,615,000 0001351345 0001422141 0001507986
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001172318 0000051011
5 remainder_Liabilities 0 0 0 15,347,652 665,795,000 0000051011 0000921560 0001351345
6 GeneralAndAdministrativeExpense 0 0 14,485 8,954,312 11,603,000 0000921560 0001118233 0001351345
7 ProfessionalFees 0 0 0 21,391 112,000 0000730669 0001130889 0000921560
8 remainder_Expenses 0 0 14,839 61,457,908 228,983,000 0000812152 0001118233 0001351345
9 remainder_Revenues 0 0 0 53,735,005 288,968,000 0000051011 0000921560 0001351345
10 remainder_NetIncome -9,646,652 -3,495,425 0 15,401 753,239 0001420031 0001160945 0001639669
11 remainder_ComprehensiveNetIncome -3,132,422 -425,922 0 14,995 2,131,000 0001420031 0001130889 0001351345
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 195 294 70,080 200,425,636 2,506,185,000 0001418302 0000921560 0001351345
1 Liabilities 3,000 14,690 234,509 115,676,874 665,795,000 0000730669 0001160945 0001351345
2 Expenses 9,735 14,544 41,729 61,925,039 240,586,000 0001422141 0000730669 0001351345
3 Revenues 0 0 0 53,735,005 288,968,000 0000051011 0000921560 0001351345
4 StockholdersEquity -17,561,900 -376,758 -140,614 187,891,925 1,840,390,000 0001420031 0000812152 0001351345
5 NetIncome -21,178,847 -7,855,906 -30,063 59,615 44,704,000 0001420031 0000812152 0001351345
6 ComprehensiveNetIncome -24,311,269 -7,855,906 -30,943 57,183 46,835,000 0001420031 0001118233 0001351345
7 BaseVar 51,934 56,189 156,225 208,658,471 1,853,671,500 0001418302 0001504876 0001351345
8 EconomicCapitalRatio -10.7 -10.3 -6.62 9.32 9.50 0001418302 0000921560 0000730669

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -3.11 -2.84 -1.62 2.88 7.50 0000867028 0000921560 0000051011
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001172318 0000051011
2 remainder_Assets -3.36 -3.32 -2.71 4.87 6.85 0001418302 0000812152 0001351345
3 LiabilitiesCurrent -0.244 -0.236 0.335 6.41 9.28 0001418302 0001500861 0001263364
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001172318 0000051011
5 remainder_Liabilities -2.72 -1.03 0.0856 2.08 7.85 0001351345 0001421636 0001418302
6 GeneralAndAdministrativeExpense -2.02 -1.28 0.0622 0.248 0.287 0001172318 0001118233 0001500861
7 ProfessionalFees -0.430 -0.372 0.0507 0.101 0.160 0001418302 0000730669 0001172318
8 remainder_Expenses -1.01 -0.482 0.0580 0.211 0.554 0001500861 0001160945 0001172318
9 remainder_Revenues -0.188 -0.133 -0.0959 0.991 2.32 0000867028 0001430319 0001172318
10 remainder_NetIncome -0.388 -0.146 0.0398 0.124 0.183 0001420031 0000730669 0000051011
11 remainder_ComprehensiveNetIncome -0.136 -0.111 0.00576 0.0173 0.0795 0001420031 0000051011 0001500861
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -5.41 -4.91 -3.41 3.50 3.92 0001418302 0001172318 0001351345
1 Liabilities -0.122 0.00580 0.324 6.91 9.86 0001422141 0001420031 0001263364
2 Expenses -1.60 -1.27 0.0963 0.317 0.351 0000867028 0000730669 0001639669
3 Revenues -0.188 -0.133 -0.0959 0.991 2.32 0000867028 0001430319 0001172318
4 StockholdersEquity -7.41 -7.38 -0.919 12.4 14.4 0001118072 0001420031 0001263364
5 NetIncome -1.77 -0.681 0.0777 0.695 1.14 0000867028 0001430319 0001172318
6 ComprehensiveNetIncome -1.76 -0.681 0.0832 0.584 1.16 0000867028 0001430319 0001172318
7 BaseVar nan nan nan nan nan 0000051011 0001172318 0000051011
8 EconomicCapitalRatio -7.34 -6.96 -3.30 12.6 12.8 0001418302 0000921560 0000730669

2017

Logs

error 5 × No matching role found input.sec.calculation_linkbase.expand_agg
0001666487 0001666487 0001582586 0001582586 0001580485
error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '12.5', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '13.4', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -8.779087434671114}
warning 10 × Missing logo subcommand.report
0001504876 0001118072 0001118233 0001160945 0001430319 0001499684 0001500861 0001521466 0001639669 0001130889
warning 7 × Ignoring company because Assets is zero pre-agg
0001062506 0001411168 0001432271 0001499573 0001636509 0001644889 0001650205
warning 4 × Ignoring company because Expenses is zero pre-agg
0000894560 0001099568 0000086115 0001365388
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001062506 0001666487 0001582586
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '28 of 28'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '28 of 28'}
warning 2 × Ignoring company because Liabilities is zero pre-agg
0000892832 0001284196
warning 2 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001172318 0001284196
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 9.268517849980633}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -10.716298353234356}

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 2,629 76,615,201 123,495,869 0001113313 0001499684 0001420031
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001263364 0000051011
2 remainder_Assets 0 0 0 113,461,881 3,015,164,000 0000051011 0000836937 0001351345
3 LiabilitiesCurrent 0 0 178,408 33,389,029 116,170,000 0001351345 0001430319 0001507986
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001263364 0000051011
5 remainder_Liabilities 0 0 0 44,320,379 1,116,356,000 0000051011 0000730669 0001351345
6 GeneralAndAdministrativeExpense 0 0 12,523 9,923,073 15,071,360 0000710782 0001118072 0001420031
7 ProfessionalFees 0 0 0 35,534 44,132 0000710782 0001130889 0001591387
8 remainder_Expenses -7,971,158 0 19,425 52,258,752 254,320,000 0001420031 0000710782 0001351345
9 remainder_Revenues 0 0 0 50,590,408 331,066,000 0000051011 0001118233 0001351345
10 remainder_NetIncome -26,784,327 -10,533,130 0 21,931 1,261,058 0001420031 0001505367 0001639669
11 remainder_ComprehensiveNetIncome 0 0 0 2,810,848 44,726,531 0000051011 0001160945 0001420031
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 8.00 180 16,704 172,233,866 3,015,164,000 0001651932 0001521466 0001351345
1 Liabilities 2,125 6,316 249,543 123,602,728 1,116,356,000 0000710782 0001422141 0001351345
2 Expenses 11,145 13,666 43,106 53,938,421 268,689,000 0001422141 0000730669 0001351345
3 Revenues 0 0 0 50,590,408 331,066,000 0000051011 0001118233 0001351345
4 StockholdersEquity -2,477,275 -984,518 -75,390 101,874,665 1,898,808,000 0001113313 0001651932 0001351345
5 NetIncome -33,371,082 -2,455,867 -38,247 -7,979 46,237,000 0001420031 0001504876 0001351345
6 ComprehensiveNetIncome -3,105,000 -938,291 -34,433 7,380,453 50,344,000 0001507986 0001422141 0001351345
7 BaseVar 33,672 41,416 154,787 210,468,560 2,375,761,000 0001499684 0001421636 0001351345
8 EconomicCapitalRatio -19.7 -10.7 -8.78 9.27 9.63 0001591387 0001521466 0000710782

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -13.7 -4.14 -1.63 3.99 5.68 0001591387 0001521466 0000051011
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001263364 0000051011
2 remainder_Assets -11.2 -4.07 -2.01 7.32 8.47 0001591387 0001113313 0001351345
3 LiabilitiesCurrent -5.47 -0.988 0.232 5.95 8.53 0001591387 0001118233 0001263364
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001263364 0000051011
5 remainder_Liabilities -3.58 -2.29 0.117 2.39 3.40 0001591387 0001113313 0001263364
6 GeneralAndAdministrativeExpense -3.31 -1.78 0.0720 0.184 0.426 0001591387 0001521466 0000921560
7 ProfessionalFees -5.29 -0.996 0.0918 0.168 0.296 0001591387 0001504876 0001172318
8 remainder_Expenses -3.48 -0.668 0.122 0.693 1.26 0000921560 0001351345 0001591387
9 remainder_Revenues -0.354 -0.188 -0.0670 0.702 2.32 0001591387 0001504876 0001172318
10 remainder_NetIncome -0.269 -0.177 0.0300 0.136 0.159 0001499684 0001504876 0001591387
11 remainder_ComprehensiveNetIncome -0.0738 -0.0441 -0.0141 0.0587 0.367 0001591387 0001430319 0001420031
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -17.6 -6.45 -3.44 3.18 4.29 0001591387 0000921560 0001351345
1 Liabilities -6.33 -0.508 0.160 6.94 9.66 0001591387 0001130889 0001263364
2 Expenses -7.34 -2.83 0.133 0.402 0.502 0001591387 0001507986 0001420031
3 Revenues -0.354 -0.188 -0.0670 0.702 2.32 0001591387 0001504876 0001172318
4 StockholdersEquity -7.36 -7.34 -1.36 12.5 14.4 0001113313 0001499684 0001263364
5 NetIncome -7.53 -3.06 0.196 0.592 1.27 0001591387 0001504876 0001172318
6 ComprehensiveNetIncome -7.60 -3.10 0.182 0.670 1.22 0001591387 0001504876 0001172318
7 BaseVar nan nan nan nan nan 0000051011 0001263364 0000051011
8 EconomicCapitalRatio -15.6 -6.61 -4.67 13.4 13.7 0001591387 0001521466 0000710782

2018

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
0001582586 0001582586 0001739208
error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '17.1', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '12.9', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -10.060167192675864}
warning 10 × Missing logo subcommand.report
0001454510 0001118072 0001118233 0001160945 0001267612 0001430319 0001500861 0001521466 0000812152 0001130889
warning 3 × Ignoring company because Expenses is zero pre-agg
0000894560 0000086115 0001681309
warning 3 × Ignoring company because Assets is zero pre-agg
0001411168 0001432271 0001499573
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '29 of 29'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '29 of 29'}
warning 2 × Similarly named company. Duplicate? None
0001599117 0001422141
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 7.237404901444257}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.861622482382082}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001582586
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000892832

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 19,691 45,179,860 356,662,000 0000812152 0001521466 0001652362
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001420031 0000051011
2 remainder_Assets 0 0 0 4,886,644 282,566,000 0000051011 0001118233 0001652362
3 LiabilitiesCurrent 0 0 284,593 23,673,372 364,563,000 0001422141 0001118072 0001652362
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001420031 0000051011
5 remainder_Liabilities 0 0 0 32,279,234 370,878,000 0000051011 0001118072 0001652362
6 GeneralAndAdministrativeExpense 0 0 14,000 1,150,907 17,876,527 0000710782 0001430319 0001420031
7 ProfessionalFees 0 0 0 112,844 1,006,939 0000710782 0000812152 0001421636
8 remainder_Expenses 0 0 26,404 7,821,503 807,137,000 0000730669 0001505367 0001652362
9 remainder_Revenues 0 0 0 11,158,706 779,343,000 0000051011 0001130889 0001652362
10 remainder_NetIncome -47,937,386 -1,220,528 0 194,160 32,038,000 0001420031 0001636509 0001652362
11 remainder_ComprehensiveNetIncome -268,722 0 0 16,688 163,138 0001263364 0001652362 0001420031
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 1.00 120 19,694 47,970,177 639,228,000 0000867028 0001521466 0001652362
1 Liabilities 1,500 16,467 285,627 55,426,980 735,441,000 0000710782 0001651932 0001652362
2 Expenses 12,898 13,468 70,309 18,969,755 807,137,000 0001422141 0001521466 0001652362
3 Revenues 0 0 0 11,158,706 779,343,000 0000051011 0001130889 0001652362
4 StockholdersEquity -96,213,000 -10,676,607 -271,932 2,703,040 6,433,840 0001652362 0001130889 0001599117
5 NetIncome -58,043,259 -6,834,279 -55,609 53,054 4,244,000 0001420031 0000812152 0001652362
6 ComprehensiveNetIncome -57,880,121 -6,834,279 -55,609 53,054 4,244,000 0001420031 0000812152 0001652362
7 BaseVar 39,648 71,034 166,602 80,230,936 1,496,593,500 0001172318 0001505367 0001652362
8 EconomicCapitalRatio -19.0 -11.9 -10.1 7.24 9.66 0001421636 0001505367 0000710782

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -14.1 -4.54 -2.60 6.72 7.34 0001421636 0001118233 0000051011
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001420031 0000051011
2 remainder_Assets -5.87 -1.83 -0.768 3.83 6.11 0001421636 0001118233 0001263364
3 LiabilitiesCurrent -6.60 -1.17 0.246 6.26 7.57 0001421636 0001430319 0001599117
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001420031 0000051011
5 remainder_Liabilities -3.94 -1.34 -0.0167 1.90 2.42 0001421636 0001118233 0001263364
6 GeneralAndAdministrativeExpense -3.67 -0.454 0.0628 0.526 0.586 0000921560 0001118072 0001636509
7 ProfessionalFees -0.965 -0.774 0.0702 0.214 0.257 0001651932 0001422141 0001636509
8 remainder_Expenses -8.93 -3.81 0.210 0.471 0.812 0001421636 0001422141 0000921560
9 remainder_Revenues -0.249 -0.184 -0.0914 0.937 2.01 0000921560 0001422141 0001172318
10 remainder_NetIncome -1.62 -0.445 0.0716 0.229 0.243 0000867028 0000051011 0001636509
11 remainder_ComprehensiveNetIncome -0.0896 -0.00236 -0.000447 0.000703 0.0841 0001263364 0000812152 0001500861
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -15.8 -5.60 -3.20 5.40 6.01 0001421636 0001118072 0000051011
1 Liabilities -7.02 -0.501 0.147 7.19 8.01 0001421636 0001118072 0001599117
2 Expenses -9.25 -3.55 0.149 0.441 0.640 0001421636 0000051011 0000867028
3 Revenues -0.249 -0.184 -0.0914 0.937 2.01 0000921560 0001422141 0001172318
4 StockholdersEquity -6.24 -6.23 -3.07 17.1 22.7 0001118233 0000867028 0001421636
5 NetIncome -9.78 -3.55 0.231 0.917 0.983 0001421636 0001454510 0001652362
6 ComprehensiveNetIncome -9.79 -3.55 0.230 0.916 0.982 0001421636 0001454510 0001652362
7 BaseVar nan nan nan nan nan 0000051011 0001420031 0000051011
8 EconomicCapitalRatio -13.4 -6.22 -4.41 12.9 15.3 0001421636 0001505367 0000710782

2019

Logs

error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '14.0', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '12.0', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -9.999956564684126}
warning 8 × Missing logo subcommand.report
0001118072 0001160945 0001267612 0001430319 0001500861 0000812152 0000894560 0001130889
warning 4 × Ignoring company because Assets is zero pre-agg
0001172318 0001411168 0001432271 0001499684
warning 3 × Ignoring company because Expenses is zero pre-agg
0000086115 0001753648 0001763731
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '22 of 22'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '22 of 22'}
warning 2 × Similarly named company. Duplicate? None
0001422141 0001599117
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 5.242478090131815}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -12.755055915135612}
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000892832

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 7,108 1,615,927 547,062,000 0000812152 0000836937 0001652362
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
2 remainder_Assets 0 0 1,889 3,799,464 277,859,000 0000051011 0001113313 0001652362
3 LiabilitiesCurrent 0 8,942 411,494 2,646,780 486,277,000 0001422141 0001365388 0001652362
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
5 remainder_Liabilities 0 0 0 1,355,770 430,264,000 0000051011 0000812152 0001652362
6 GeneralAndAdministrativeExpense 0 0 13,879 446,324 1,178,974 0000710782 0001160945 0001263364
7 ProfessionalFees 0 0 0 223,941 986,445 0000710782 0000710782 0001421636
8 remainder_Expenses 0 0 54,905 6,968,576 1,421,311,000 0000730669 0001267612 0001652362
9 remainder_Revenues 0 0 0 4,140,607 1,459,763,000 0000051011 0000710782 0001652362
10 remainder_NetIncome -32,221,000 -1,619,074 -14,210 38,637 91,648 0001652362 0001430319 0001636509
11 remainder_ComprehensiveNetIncome -62,796 -46,592 0 0 0 0001650205 0001160945 0000051011
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 77.0 223 55,834 4,948,657 824,921,000 0001118072 0000836937 0001652362
1 Liabilities 8,000 27,078 411,494 2,847,990 916,541,000 0000730669 0001365388 0001652362
2 Expenses 13,550 13,587 112,780 7,226,812 1,421,311,000 0001130889 0001113313 0001652362
3 Revenues 0 0 0 4,140,607 1,459,763,000 0000051011 0000710782 0001652362
4 StockholdersEquity -91,620,000 -2,494,176 -321,331 2,815,916 3,012,684 0001652362 0001118072 0001599117
5 NetIncome -7,240,740 -6,674,578 -62,572 105,165 6,231,000 0001421636 0000730669 0001652362
6 ComprehensiveNetIncome -7,240,740 -6,674,578 -62,572 105,165 6,231,000 0001421636 0000730669 0001652362
7 BaseVar 42,774 59,415 305,004 9,313,711 2,327,378,500 0000710782 0001651932 0001652362
8 EconomicCapitalRatio -13.2 -12.8 -10.00 5.24 7.91 0000836937 0000812152 0000730669

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -5.13 -4.02 -1.69 8.97 10.2 0000836937 0001160945 0000051011
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
2 remainder_Assets -3.54 -3.03 -1.12 3.75 6.57 0001636509 0001118072 0001263364
3 LiabilitiesCurrent -1.34 -1.19 0.185 6.43 7.09 0001650205 0001130889 0001599117
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
5 remainder_Liabilities -7.28 -0.645 -0.0183 1.25 1.60 0001422141 0001118072 0000730669
6 GeneralAndAdministrativeExpense -0.265 -0.262 0.0147 0.220 0.355 0001263364 0001651932 0001636509
7 ProfessionalFees -0.630 -0.415 0.0825 0.193 0.198 0001651932 0001430319 0001599117
8 remainder_Expenses -4.50 -3.15 0.378 0.577 0.583 0001636509 0001263364 0000730669
9 remainder_Revenues -0.217 -0.214 -0.0891 0.985 1.46 0000836937 0001130889 0001652362
10 remainder_NetIncome -0.374 -0.338 0.0405 0.196 0.290 0001421636 0001263364 0001636509
11 remainder_ComprehensiveNetIncome -0.0550 -0.0110 0.00375 0.0100 0.0124 0001650205 0001500861 0001636509
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -6.60 -6.11 -2.63 6.72 7.59 0000836937 0000894560 0000051011
1 Liabilities -1.46 -1.05 0.0783 6.94 7.20 0000836937 0001160945 0000730669
2 Expenses -4.03 -2.87 0.211 0.535 0.545 0001636509 0001263364 0001422141
3 Revenues -0.217 -0.214 -0.0891 0.985 1.46 0000836937 0001130889 0001652362
4 StockholdersEquity -5.91 -5.90 0.0434 14.0 14.6 0001118072 0000710782 0001599117
5 NetIncome -3.83 -2.94 0.251 0.727 1.41 0001636509 0001430319 0001652362
6 ComprehensiveNetIncome -3.81 -2.93 0.254 0.730 1.42 0001636509 0001430319 0001652362
7 BaseVar nan nan nan nan nan 0000051011 0001160945 0000051011
8 EconomicCapitalRatio -6.49 -6.04 -3.28 12.0 14.6 0000836937 0000812152 0000730669

2020

Logs

error 3 × Unusually strong effect check_effects
{'var_name': 'AssetsCurrent', 'quantile_value': '10.3', 'quantile': 0.95}
{'var_name': 'StockholdersEquity', 'quantile_value': '17.2', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '11.1', 'quantile': 0.95}
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001599117
error 1 × Median ECR is negative check_abs_values
{'median': -9.974091969816548}
warning 7 × Missing logo subcommand.report
0001698832 0001118072 0001160945 0001430319 0000812152 0000894560 0001130889
warning 4 × Ignoring company because Expenses is zero pre-agg
0000086115 0001753648 0001763731 0001796303
warning 4 × Ignoring company because Assets is zero pre-agg
0001411168 0001432271 0001499684 0001651932
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '17 of 17'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '17 of 17'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -10.761058349668524}
warning 1 × Similarly named company. Duplicate? None
0001422141
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000892832
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001709768

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 2,015 98,569,056 492,369,000 0000812152 0001160945 0001652362
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
2 remainder_Assets 0 0 0.362 47,488,172 236,771,000 0000051011 0000730669 0001652362
3 LiabilitiesCurrent 0 0 348,715 81,347,434 389,553,000 0001422141 0001118072 0001652362
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
5 remainder_Liabilities 0 0 0 83,403,675 412,265,000 0000051011 0000836937 0001652362
6 GeneralAndAdministrativeExpense 0 0 13,520 89,873 148,800 0001263364 0001130889 0001709768
7 ProfessionalFees 0 0 0 71,244 140,394 0000812152 0000894560 0000836937
8 remainder_Expenses 0 0 8.04 338,627,377 1,690,059,000 0000730669 0000894560 0001652362
9 remainder_Revenues 0 0 0 350,694,494 1,752,905,000 0000051011 0001113313 0001652362
10 remainder_NetIncome -62,118,000 -14,104,868 -17,228 56,039 280,196 0001652362 0001130889 0000836937
11 remainder_ComprehensiveNetIncome 0 0 0 33,083 165,413 0000051011 0001118072 0001263364
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 698 854 18,550 145,961,972 729,140,000 0001130889 0001698832 0001652362
1 Liabilities 6,000 30,034 362,114 163,800,434 801,818,000 0000730669 0001160945 0001652362
2 Expenses 13,520 13,524 59,005 338,641,737 1,690,059,000 0001130889 0001698832 0001652362
3 Revenues 0 0 0 350,694,494 1,752,905,000 0000051011 0001113313 0001652362
4 StockholdersEquity -72,678,000 -17,914,043 -352,416 46,462 61,000 0001652362 0001365388 0000730669
5 NetIncome -2,324,192 -981,282 -53,984 250,350 728,000 0001263364 0000730669 0001652362
6 ComprehensiveNetIncome -2,158,779 -948,199 -53,984 250,350 728,000 0001263364 0000730669 0001652362
7 BaseVar 63,500 70,954 212,382 505,723,328 2,518,020,000 0000730669 0001422141 0001652362
8 EconomicCapitalRatio -12.0 -10.8 -9.97 3.93 6.88 0001263364 0001118072 0000730669

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -2.71 -1.91 -1.47 10.3 11.7 0001263364 0001130889 0000730669
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
2 remainder_Assets -2.09 -1.14 -0.626 4.19 4.86 0001263364 0001118072 0001709768
3 LiabilitiesCurrent -0.939 -0.318 0.0500 5.96 7.50 0001263364 0001160945 0000730669
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001160945 0000051011
5 remainder_Liabilities -3.25 -1.15 0.00566 2.15 3.16 0001698832 0001491829 0000730669
6 GeneralAndAdministrativeExpense -0.492 -0.478 0.0395 0.351 0.371 0001709768 0001160945 0001263364
7 ProfessionalFees -0.685 -0.407 0.0867 0.262 0.277 0000730669 0001430319 0001263364
8 remainder_Expenses -1.83 -0.945 0.125 0.194 0.200 0001652362 0001160945 0000730669
9 remainder_Revenues -0.156 -0.0925 -0.0543 0.438 2.14 0001263364 0001113313 0001652362
10 remainder_NetIncome -3.91 -0.950 0.0137 0.420 1.07 0001263364 0001160945 0000836937
11 remainder_ComprehensiveNetIncome -0.0184 -0.0115 -0.00690 0.0585 0.317 0001652362 0001113313 0001263364
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -4.33 -2.73 -1.94 8.54 8.76 0001263364 0001160945 0000730669
1 Liabilities -1.14 -0.355 0.0679 6.38 8.56 0001263364 0000812152 0000730669
2 Expenses -1.23 -1.01 0.0596 0.320 0.601 0001652362 0000894560 0001263364
3 Revenues -0.156 -0.0925 -0.0543 0.438 2.14 0001263364 0001113313 0001652362
4 StockholdersEquity -4.11 -4.08 -3.17 17.2 17.7 0001130889 0001491829 0000730669
5 NetIncome -3.47 -1.38 0.0328 1.05 1.18 0001263364 0000812152 0001652362
6 ComprehensiveNetIncome -3.15 -1.32 0.0261 1.04 1.16 0001263364 0000812152 0001652362
7 BaseVar nan nan nan nan nan 0000051011 0001160945 0000051011
8 EconomicCapitalRatio -4.75 -3.55 -2.76 11.1 14.1 0001263364 0001118072 0000730669

2021

Logs

error 13 × Negative Expenses, ignoring company. pre-agg
0001805508 0001817153 0001822219 0001822835 0001824677 0001825497 0001825739 0001825962 0001826059 0001831964 0001836129 0001838207 0001838614
error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '20.4', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '14.3', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -8.663903339620903}
error 1 × IME and Company effects mismatched for Other Assets. IME Effects: 253.0, Company Effect: 254.0 subcommand.report
0001430319
warning 37 × Ignoring company because Expenses is zero pre-agg
0001823481 0001831992 0001832505 0001840920 0000086115 0001809353 0001812667 0001816176 0001818212 0001818873 0001818876 0001818880 0001821329 0001822027 0001822929 0001823033 0001823034 0001823143 0001825413 0001825473 0001826729 0001826814 0001827328 0001828914 0001828985 0001828989 0001833909 0001834226 0001834628 0001835236 0001835636 0001837067 0001838431 0001839434 0001840792 0001841004 0001841993
warning 9 × Missing logo subcommand.report
0001698832 0000894560 0001118072 0001160945 0001430319 0001499684 0001837774 0000812152 0001130889
warning 5 × Ignoring company because Assets is zero pre-agg
0001295514 0001411168 0001415813 0001432271 0001883389
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '21 of 21'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '21 of 21'}
warning 2 × Similarly named company. Duplicate? None
0001823086 0001599117
warning 2 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001831992 0001832505
warning 2 × Ignoring company because Liabilities is zero pre-agg
0000853464 0000892832
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 8.266586354372082}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -12.691163681538209}
warning 1 × Ignoring company because ECR is too negative pre-agg
0001113313

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 787 2,054,619 661,799,000 0000812152 0000710782 0001652362
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001365388 0000051011
2 remainder_Assets 0 0 3,679 213,159,186 237,954,000 0000051011 0001658521 0001652362
3 LiabilitiesCurrent 0 0 369,211 1,572,698 490,976,000 0000730669 0001130889 0001652362
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001365388 0000051011
5 remainder_Liabilities 0 0 0 14,822,399 371,520,000 0000051011 0001499684 0001652362
6 GeneralAndAdministrativeExpense 0 0 13,835 268,051 5,987,666 0000710782 0001118072 0000867028
7 ProfessionalFees 0 0 0 46,407 208,688 0000812152 0000894560 0000836937
8 remainder_Expenses 0 0 2,499 6,424,554 2,056,448,000 0000812152 0001698832 0001652362
9 remainder_Revenues 0 0 0 6,010,438 2,078,420,000 0000051011 0001118072 0001652362
10 remainder_NetIncome -105,701,000 -1,359,544 0 762,922 8,557,786 0001652362 0001709768 0001840353
11 remainder_ComprehensiveNetIncome 0 0 0 0 0 0000051011 0001365388 0000051011
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 62.0 222 18,738 215,213,805 899,753,000 0001130889 0001698832 0001652362
1 Liabilities 3,760 17,155 369,211 16,395,097 862,496,000 0000812152 0001130889 0001652362
2 Expenses 13,800 13,800 62,002 11,880,092 2,056,448,000 0001160945 0000730669 0001652362
3 Revenues 0 0 0 6,010,438 2,078,420,000 0000051011 0001118072 0001652362
4 StockholdersEquity -585,913 -436,265 -115,874 107,604,880 198,818,708 0000894560 0001499684 0001840353
5 NetIncome -83,729,000 -12,582,500 -61,993 -19,682 6,224,020 0001652362 0000730669 0001840353
6 ComprehensiveNetIncome -83,729,000 -12,582,500 -61,993 -19,682 6,224,020 0001652362 0000730669 0001840353
7 BaseVar 20,256 33,966 205,259 121,250,227 3,001,409,000 0001658521 0001118072 0001652362
8 EconomicCapitalRatio -14.8 -12.7 -8.66 8.27 8.64 0001837774 0001698832 0001840353

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -5.47 -4.95 -1.04 8.05 9.30 0000812152 0001118072 0000051011
1 AssetsNonCurrent 0 0 0 0 0 0000051011 0001365388 0000051011
2 remainder_Assets -8.53 -7.77 -2.34 4.93 5.92 0000867028 0001652362 0001823086
3 LiabilitiesCurrent -1.89 -1.44 0.242 5.50 6.24 0000867028 0001130889 0001599117
4 LiabilitiesNonCurrent 0 0 0 0 0 0000051011 0001365388 0000051011
5 remainder_Liabilities -7.17 -5.88 -0.0281 0.614 0.983 0001698832 0000894560 0000051011
6 GeneralAndAdministrativeExpense -8.67 -4.01 0.206 0.744 0.946 0000812152 0001130889 0001652362
7 ProfessionalFees -1.36 -0.568 0.139 0.927 0.929 0001658521 0001118072 0000867028
8 remainder_Expenses -4.29 -1.86 0.149 0.481 0.996 0000867028 0000836937 0000812152
9 remainder_Revenues -0.472 -0.228 -0.0773 1.43 2.14 0000812152 0000894560 0001652362
10 remainder_NetIncome -1.41 -0.843 0.0576 0.182 0.182 0000812152 0001652362 0001837774
11 remainder_ComprehensiveNetIncome 0 0 0 0 0 0000051011 0001365388 0000051011
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -10.6 -9.52 -2.75 4.49 4.68 0000867028 0001658521 0001823086
1 Liabilities -2.01 -1.97 0.173 5.65 6.13 0000867028 0001130889 0001599117
2 Expenses -6.74 -6.73 0.0608 0.533 0.549 0000812152 0000051011 0001840353
3 Revenues -0.472 -0.228 -0.0773 1.43 2.14 0000812152 0000894560 0001652362
4 StockholdersEquity -6.72 -6.71 -0.602 20.4 23.8 0001160945 0001658521 0000812152
5 NetIncome -8.62 -7.46 0.111 1.35 1.71 0000812152 0001709768 0001652362
6 ComprehensiveNetIncome -8.62 -7.46 0.111 1.35 1.71 0000812152 0001709768 0001652362
7 BaseVar nan nan nan nan nan 0000051011 0001365388 0000051011
8 EconomicCapitalRatio -8.79 -6.68 -2.65 14.3 14.6 0001837774 0001698832 0001840353

2022

Logs

error 6 × Negative Expenses, ignoring company. pre-agg
0001817153 0001847241 0001848756 0001854795 0001854863 0001857518
error 2 × Unusually strong effect check_effects
{'var_name': 'StockholdersEquity', 'quantile_value': '14.8', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '11.1', 'quantile': 0.95}
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001870143
error 1 × Median ECR is negative check_abs_values
{'median': -8.371998745070991}
warning 25 × Ignoring company because Expenses is zero pre-agg
0000086115 0001809353 0001821329 0001822792 0001822929 0001840920 0001841004 0001842644 0001847112 0001850699 0001852019 0001852889 0001853397 0001853580 0001856161 0001856696 0001856961 0001858007 0001858503 0001865111 0001879297 0001880441 0001880968 0001889112 0001903464
warning 8 × Missing logo subcommand.report
0001454510 0001118072 0001160945 0001430319 0001837774 0000812152 0000894560 0001130889
warning 7 × Ignoring company because Assets is zero pre-agg
0001062506 0001283789 0001411168 0001415813 0001874440 0001875746 0001883389
warning 2 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '18 of 18'}
{'var_name': 'LiabilitiesNonCurrent', 'zeros': '18 of 18'}
warning 2 × Similarly named company. Duplicate? None
0001823086 0001599117
warning 2 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001062506 0001709768
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.94169351749564}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -10.596966887502074}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001062506
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000892832

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 0 11,226 1,210,123 1,720,030 0000812152 0001130889 0001599117
1 AssetsNonCurrent 0 0 0 0 0 0000730669 0001160945 0000730669
2 remainder_Assets 0 0 1,019 37,097,724 216,069,362 0000730669 0001454510 0001840353
3 LiabilitiesCurrent 0 32,190 419,703 4,919,906 5,232,097 0000730669 0001160945 0001823086
4 LiabilitiesNonCurrent 0 0 0 0 0 0000730669 0001160945 0000730669
5 remainder_Liabilities 0 0 0 2,617,058 4,697,978 0000812152 0001709768 0001823086
6 GeneralAndAdministrativeExpense 0 0 34,200 859,282 1,136,209 0001599117 0000894560 0000836937
7 ProfessionalFees 0 0 0 291,512 815,542 0000812152 0001454510 0001421636
8 remainder_Expenses 0 0 1,505 5,499,906 9,345,396 0000812152 0000730669 0001599117
9 remainder_Revenues 0 0 0 3,053,606 7,705,715 0000730669 0001130889 0001599117
10 remainder_NetIncome -1,963,984 -333,613 0 6,767,309 10,132,089 0001421636 0001651932 0001840353
11 remainder_ComprehensiveNetIncome 0 0 0 0 0 0000730669 0001160945 0000730669
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 72.0 149 23,533 37,551,049 217,189,502 0001651932 0000730669 0001840353
1 Liabilities 37,870 51,805 419,703 6,448,220 9,930,075 0001113313 0001160945 0001823086
2 Expenses 14,000 14,000 72,269 6,013,178 9,345,396 0001160945 0001454510 0001599117
3 Revenues 0 0 0 3,053,606 7,705,715 0000730669 0001130889 0001599117
4 StockholdersEquity -4,209,737 -4,099,400 -293,590 33,302,992 212,238,717 0001421636 0001454510 0001840353
5 NetIncome -5,156,478 -1,879,001 -64,305 2,092,195 6,285,309 0001421636 0000812152 0001840353
6 ComprehensiveNetIncome -5,156,478 -1,879,001 -64,305 2,092,195 6,285,309 0001421636 0000812152 0001840353
7 BaseVar 47,524 78,665 236,825 29,088,327 118,059,578 0001658521 0001709768 0001840353
8 EconomicCapitalRatio -11.1 -10.6 -8.37 4.94 9.61 0001658521 0001709768 0001840353

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

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent -0.959 -0.767 -0.427 1.70 4.60 0001658521 0001823086 0001837774
1 AssetsNonCurrent 0 0 0 0 0 0000730669 0001160945 0000730669
2 remainder_Assets -3.27 -3.21 -2.04 3.09 7.56 0000730669 0001837774 0001113313
3 LiabilitiesCurrent -0.559 -0.485 0.135 6.94 7.33 0001709768 0000812152 0001599117
4 LiabilitiesNonCurrent 0 0 0 0 0 0000730669 0001160945 0000730669
5 remainder_Liabilities -2.32 -2.07 -0.00799 1.02 1.31 0000730669 0001160945 0001113313
6 GeneralAndAdministrativeExpense -0.797 -0.617 0.135 0.395 0.661 0000812152 0001430319 0001599117
7 ProfessionalFees -0.990 -0.751 0.115 0.204 0.340 0001658521 0001130889 0001599117
8 remainder_Expenses -1.89 -0.921 0.127 0.184 0.189 0001599117 0001118072 0000812152
9 remainder_Revenues -0.0955 -0.0867 -0.0533 0.673 1.71 0001113313 0001430319 0001599117
10 remainder_NetIncome -0.532 -0.197 -0.00341 0.373 0.779 0001421636 0001837774 0001823086
11 remainder_ComprehensiveNetIncome 0 0 0 0 0 0000730669 0001160945 0000730669
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -3.89 -3.23 -1.74 2.50 6.05 0001658521 0001421636 0001113313
1 Liabilities -0.369 -0.341 0.122 7.15 7.29 0001130889 0000894560 0001840353
2 Expenses -0.984 -0.899 -0.0114 0.401 0.421 0001113313 0001709768 0001840353
3 Revenues -0.0955 -0.0867 -0.0533 0.673 1.71 0001113313 0001430319 0001599117
4 StockholdersEquity -5.28 -5.28 -0.786 14.8 16.1 0001160945 0000730669 0001599117
5 NetIncome -0.923 -0.895 0.0523 0.860 1.13 0001113313 0000894560 0001599117
6 ComprehensiveNetIncome -0.923 -0.895 0.0523 0.860 1.13 0001113313 0000894560 0001599117
7 BaseVar nan nan nan nan nan 0000730669 0001160945 0000730669
8 EconomicCapitalRatio -4.96 -4.46 -2.23 11.1 15.8 0001658521 0001709768 0001840353

Estimates

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