QA: us_motor 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
0001456189 Leatt Corp Leatt C 20 19 4 6 3 2 1 141.7690 187.1750 303.7950 242.385000 330.94900 433.12200 458.9410 -1 -15 2 -3 -1 -1
0000355811 GENTEX CORP GENTEX 2 1 1 1 1 1 2 443.1670 504.3990 571.3820 552.822000 506.44200 525.94100 458.8240 -1 0 0 0 0 1
0001424929 FOX FACTORY HOLDING CORP FOX FAC 8 10 3 NaN NaN 12 3 244.5250 255.9350 385.1300 NaN NaN 211.82200 341.0740 2 -7 NaN NaN NaN -9
0000095552 SUPERIOR INDUSTRIES INTERNATIONAL INC SUPERIO 6 5 6 13 39 15 4 300.7750 300.4790 285.3560 172.626000 -41.37260 199.63800 305.8120 -1 1 7 26 -24 -11
0001318605 Tesla Inc. Tesla I 31 40 37 32 18 14 5 26.5213 -16.9865 13.1737 25.266400 125.23100 205.40900 290.9340 9 -3 -5 -14 -4 -9
0000868780 Dorman Products Inc. Dorman 1 2 2 2 4 9 6 459.9260 447.8950 452.3590 330.377000 310.41000 236.52500 254.7490 1 0 0 2 5 -3
0000793952 HARLEY-DAVIDSON INC. HARLEY- 7 11 12 5 15 6 7 282.8180 251.1390 229.3600 245.830000 182.88700 283.07800 251.7610 4 1 -7 10 -9 1
0000933034 STRATTEC SECURITY CORP STRATTE 15 8 8 NaN 14 4 8 197.4190 266.1780 271.5100 NaN 191.74400 320.69700 229.3360 -7 0 NaN NaN -10 4
0000775158 OSHKOSH CORP OSHKOSH 9 12 7 3 7 8 9 244.3930 241.4650 284.3260 287.121000 269.13600 275.60700 215.9290 3 -5 -4 4 1 1
0000277509 FEDERAL SIGNAL CORP DE FEDERAL 11 21 13 7 11 10 10 224.9650 181.7600 207.3340 238.611000 227.16000 233.87300 215.5430 10 -8 -6 4 -1 0
0000763744 LCI INDUSTRIES LCI IND 3 4 9 12 16 20 11 381.3620 348.2410 261.8100 174.386000 154.42300 147.60100 214.2390 1 5 3 4 4 -9
0001111335 VISTEON CORP VISTEON 16 6 11 11 19 11 12 172.2910 285.4890 233.7650 179.242000 120.19200 215.21600 204.3130 -10 5 0 8 -8 1
0001802749 Lightning eMotors Inc. Lightni NaN NaN NaN NaN NaN 58 13 NaN NaN NaN NaN NaN -356.15500 181.4150 NaN NaN NaN NaN NaN -45
0000076605 PATRICK INDUSTRIES INC PATRICK NaN NaN NaN NaN NaN 22 14 NaN NaN NaN NaN NaN 136.00900 181.2150 NaN NaN NaN NaN NaN -8
0000924822 MILLER INDUSTRIES INC TN MILLER 10 7 10 4 5 13 15 236.8210 277.1230 255.4830 283.723000 289.80200 209.45700 180.7010 -3 3 -6 1 8 2
0000093389 STANDARD MOTOR PRODUCTS INC. STANDAR 12 15 16 9 13 16 16 219.2560 203.5660 182.0790 202.350000 209.65300 196.35900 157.1510 3 1 -7 4 3 0
0000903129 GENTHERM Inc GENTHER 13 9 17 8 10 7 17 205.7860 265.9280 181.3400 223.437000 232.19400 278.79500 144.1680 -4 8 -9 2 -3 10
0001411207 Allison Transmission Holdings Inc Allison 25 25 22 16 26 28 18 95.1913 139.4020 150.2600 142.152000 80.83920 110.51900 140.1810 0 -3 -6 10 2 -10
0001316517 Kandi Technologies Group Inc. Kandi T 28 31 31 23 NaN 3 19 76.0169 87.3071 80.3092 118.294000 NaN 343.29500 137.7820 3 0 -8 NaN NaN 16
0001157762 CHINA AUTOMOTIVE SYSTEMS INC CHINA A 23 30 28 21 25 26 20 118.1420 95.2095 100.3820 120.877000 89.26300 123.74000 135.8390 7 -2 -7 4 1 -6
0000908255 BORGWARNER INC BORGWAR NaN NaN NaN NaN 9 21 21 NaN NaN NaN NaN 261.81400 136.40900 135.6230 NaN NaN NaN NaN 12 0
0001822928 Holley Inc. Holley NaN NaN NaN NaN NaN 18 22 NaN NaN NaN NaN NaN 168.34900 123.5900 NaN NaN NaN NaN NaN 4
0001521332 Aptiv PLC Aptiv P 22 20 24 19 12 23 23 119.1150 181.9080 120.8050 126.105000 217.12500 135.82500 113.5020 -2 4 -5 -7 11 0
0001735707 Garrett Motion Inc. Garrett NaN NaN NaN NaN 42 24 24 NaN NaN NaN NaN -83.48020 130.83100 112.6860 NaN NaN NaN NaN -18 0
0001034670 AUTOLIV INC AUTOLIV 18 17 34 20 23 27 25 160.1270 196.3790 64.9321 123.338000 93.11680 121.10700 108.9250 -1 17 -14 3 4 -2
0001467858 General Motors Co General 29 39 35 30 31 29 26 61.8281 23.0910 62.6989 56.638000 45.64230 109.06500 96.8040 10 -4 -5 1 -2 -3
0000842162 LEAR CORP LEAR CO NaN 14 20 18 24 31 27 NaN 207.7760 162.8980 128.766000 90.65310 99.00460 94.7963 NaN 6 -2 6 7 -4
0001687221 REV Group Inc. REV Gro NaN 26 29 28 29 25 28 NaN 129.0760 90.1841 73.019600 55.54120 128.23700 82.8765 NaN 3 -1 1 -4 3
0000918251 MOTORCAR PARTS OF AMERICA INC MOTORCA 21 13 18 26 28 30 29 141.3060 225.7690 175.0400 87.436000 67.12000 99.30780 73.8110 -8 5 8 2 2 -1
0001043337 STONERIDGE INC STONERI 4 16 15 10 22 32 30 314.3910 203.2900 187.9240 202.205000 101.23800 95.43420 67.4614 12 -1 -5 12 10 -2
0000813762 ICAHN ENTERPRISES L.P. ICAHN E NaN 23 14 29 33 37 31 NaN 151.7300 199.1600 57.887900 19.22410 54.90520 67.2920 NaN -9 15 4 4 -6
0001062231 AMERICAN AXLE & MANUFACTURING HOLDINGS INC AMERICA 27 NaN NaN 36 41 38 32 78.6467 NaN NaN -35.756100 -69.62590 25.20880 44.0134 NaN NaN NaN 5 -3 -6
0001290900 Commercial Vehicle Group Inc. Commerc 32 36 23 24 38 33 33 25.7540 50.9534 136.4960 96.330500 -25.36840 94.99780 31.4212 4 -13 1 14 -5 0
0000037996 FORD MOTOR CO FORD MO NaN NaN NaN NaN 32 34 34 NaN NaN NaN NaN 20.92900 94.94790 23.0170 NaN NaN NaN NaN 2 0
0001670541 Adient plc Adient NaN 27 39 34 37 19 35 NaN 127.7870 -92.2906 -0.258729 -21.69720 149.22600 21.8279 NaN 12 -5 3 -18 16
0000026780 DANA INC DANA IN 19 37 26 17 30 35 36 146.1320 48.4762 112.9430 135.075000 47.56540 86.17720 18.8876 18 -11 -9 13 5 1
0001811210 Lucid Group Inc. Lucid G NaN NaN NaN NaN NaN 55 37 NaN NaN NaN NaN NaN -208.86100 -38.9860 NaN NaN NaN NaN NaN -18
0001320461 Cooper-Standard Holdings Inc. Cooper- 24 29 27 25 36 48 38 100.2720 124.9930 104.7170 91.045800 -9.32684 -76.73460 -77.4193 5 -2 -2 11 12 -10
0001589526 Blue Bird Corp Blue Bi 34 34 NaN 35 35 41 39 -48.4141 69.7748 NaN -17.646300 -5.59673 11.43730 -87.8356 0 NaN NaN 0 6 -2
0001820630 Proterra Inc Proterr NaN NaN NaN NaN NaN 49 40 NaN NaN NaN NaN NaN -98.87410 -151.0200 NaN NaN NaN NaN NaN -9
0001759631 Hyliion Holdings Corp. Hyliion NaN NaN NaN NaN NaN 36 41 NaN NaN NaN NaN NaN 84.98920 -173.0480 NaN NaN NaN NaN NaN 5
0001404804 Omnitek Engineering Corp Omnitek 38 44 41 42 50 47 42 -326.6600 -501.4580 -240.1440 -465.703000 -370.59700 -70.98100 -201.0130 6 -3 1 8 -3 -5
0001759424 Evil Empire Designs Inc. Evil Em NaN NaN NaN NaN 54 56 43 NaN NaN NaN NaN -559.05900 -234.91300 -212.9810 NaN NaN NaN NaN 2 -13
0001874178 Rivian Automotive Inc. DE Rivian NaN NaN NaN NaN NaN 45 44 NaN NaN NaN NaN NaN -6.44285 -241.4330 NaN NaN NaN NaN NaN -1
0001096275 Worksport Ltd Workspo 42 50 52 44 52 42 45 -1232.8300 -3473.9000 -1999.8000 -512.224000 -476.20900 4.97371 -250.2790 8 2 -8 8 -10 3
0001789029 Aeva Technologies Inc. Aeva Te NaN NaN NaN NaN 2 40 46 NaN NaN NaN NaN 343.39400 14.21290 -286.8440 NaN NaN NaN NaN 38 6
0001758057 Luminar Technologies Inc. DE Luminar NaN NaN NaN NaN 55 52 47 NaN NaN NaN NaN -566.12400 -184.95900 -490.2200 NaN NaN NaN NaN -3 -5
0001731289 Nikola Corp Nikola NaN NaN NaN NaN 47 63 48 NaN NaN NaN NaN -205.38300 -618.61700 -512.7990 NaN NaN NaN NaN 16 -15
0001425287 Workhorse Group Inc. Workhor 43 49 NaN 45 6 65 49 -1688.7500 -2446.5500 NaN -560.354000 281.79200 -1937.25000 -530.5400 6 NaN NaN -39 59 -16
0001759546 Lordstown Motors Corp. Lordsto NaN NaN NaN NaN 17 61 50 NaN NaN NaN NaN 134.03100 -510.54200 -556.1240 NaN NaN NaN NaN 44 -11
0001818644 AEye Inc. AEye In NaN NaN NaN NaN NaN 54 51 NaN NaN NaN NaN NaN -191.03300 -677.0570 NaN NaN NaN NaN NaN -3
0001750153 Canoo Inc. Canoo I NaN NaN NaN NaN 27 62 52 NaN NaN NaN NaN 71.60950 -571.41700 -861.6090 NaN NaN NaN NaN 35 -10
0001861449 Bird Global Inc. Bird Gl NaN NaN NaN NaN NaN 44 53 NaN NaN NaN NaN NaN -4.52034 -882.0960 NaN NaN NaN NaN NaN 9
0001558583 Arcimoto Inc Arcimot NaN 38 46 47 46 64 54 NaN 31.8772 -686.9250 -808.552000 -177.59800 -747.10100 -1027.8500 NaN 8 1 -1 18 -10
0000837852 IDEANOMICS INC. IDEANOM 40 41 40 46 48 60 55 -579.0110 -26.3362 -187.3230 -653.375000 -277.34200 -441.94200 -1034.6300 1 -1 6 2 12 -5
0001829794 Volcon Inc. Volcon NaN NaN NaN NaN NaN 66 56 NaN NaN NaN NaN NaN -2539.93000 -1146.9600 NaN NaN NaN NaN NaN -10
0001703157 Securetech Innovations Inc. Securet NaN NaN 48 39 49 57 57 NaN NaN -942.5260 -332.566000 -346.29500 -292.27700 -2926.4400 NaN NaN -9 10 8 0
0000060977 LYDALL INC DE LYDALL 5 3 5 14 20 NaN NaN 308.4740 420.3740 286.3930 165.005000 112.60600 NaN NaN -2 2 9 6 NaN NaN
0000714284 SORL Auto Parts Inc. SORL Au 17 28 36 27 NaN NaN NaN 163.7080 126.8660 58.2264 81.516100 NaN NaN NaN 11 8 -9 NaN NaN NaN
0000743238 SHYFT GROUP INC. SHYFT G 14 18 19 NaN NaN NaN NaN 201.1720 192.5910 169.7290 NaN NaN NaN NaN 4 1 NaN NaN NaN NaN
0000808450 NAVISTAR INTERNATIONAL CORP NAVISTA 35 42 38 38 45 NaN NaN -125.2370 -91.2049 -45.4074 -54.194800 -108.16100 NaN NaN 7 -4 0 7 NaN NaN
0001019787 PURADYN FILTER TECHNOLOGIES INC PURADYN 39 43 42 41 NaN NaN NaN -455.3260 -429.8330 -275.8630 -417.302000 NaN NaN NaN 4 -1 -1 NaN NaN NaN
0001063197 CurAegis Technologies Inc. CurAegi 44 48 51 48 NaN NaN NaN -1738.9500 -1201.8800 -1425.4500 -847.546000 NaN NaN NaN 4 3 -3 NaN NaN NaN
0001168663 AMANASU TECHNO HOLDINGS CORP AMANASU 41 45 45 43 53 59 NaN -632.7840 -594.6340 -578.2420 -493.099000 -488.81800 -433.91100 NaN 4 0 -2 10 6 NaN
0001390844 WABCO Holdings Inc. WABCO H 26 22 21 22 NaN NaN NaN 94.1593 162.2000 153.3250 119.634000 NaN NaN NaN -4 -1 1 NaN NaN NaN
0001398529 GREENKRAFT INC. GREENKR 36 NaN 43 NaN NaN NaN NaN -281.8140 NaN -298.9160 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001485469 Tower International Inc. Tower I 30 32 32 NaN NaN NaN NaN 61.3668 84.8058 80.2684 NaN NaN NaN NaN 2 0 NaN NaN NaN NaN
0001569083 MAKINGORG INC. MAKINGO 37 46 47 NaN 51 53 NaN -291.6610 -603.2950 -781.9870 NaN -468.26400 -190.75400 NaN 9 1 NaN NaN 2 NaN
0001637655 Horizon Global Corp Horizon 33 35 44 15 40 46 NaN -19.7468 60.9482 -302.3220 149.227000 -62.63080 -66.06070 NaN 2 9 -29 25 6 NaN
0001381871 bowmo Inc. bowmo I NaN 47 50 NaN NaN NaN NaN NaN -712.3880 -1329.1700 NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN
0001563568 Envirotech Vehicles Inc. Envirot NaN 51 49 40 56 17 NaN NaN -3877.8100 -993.3560 -380.872000 -645.79900 189.47000 NaN NaN -2 -9 16 -39 NaN
0001617669 Unique Fabricating Inc. Unique NaN 24 25 33 34 43 NaN NaN 142.7330 115.7590 1.427760 17.91840 3.07203 NaN NaN 1 8 1 9 NaN
0001707092 Delphi Technologies PLC Delphi NaN 33 30 31 NaN NaN NaN NaN 84.7838 86.1579 34.237000 NaN NaN NaN NaN -3 1 NaN NaN NaN
0001733186 Arriver Holdco Inc. Arriver NaN NaN 33 37 43 50 NaN NaN NaN 74.5980 -40.383900 -94.51420 -112.66400 NaN NaN NaN 4 6 7 NaN
0001024725 TENNECO INC TENNECO NaN NaN NaN NaN 44 39 NaN NaN NaN NaN NaN -96.04380 19.76840 NaN NaN NaN NaN NaN -5 NaN
0001720990 Fisker Inc. DE Fisker NaN NaN NaN NaN 8 51 NaN NaN NaN NaN NaN 265.68100 -179.20900 NaN NaN NaN NaN NaN 43 NaN
0001757932 Romeo Power Inc. Romeo P NaN NaN NaN NaN 21 5 NaN NaN NaN NaN NaN 111.91400 289.46200 NaN NaN NaN NaN NaN -16 NaN

PDF reports

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

2016

Logs

error 1 × Unusually strong effect check_effects
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.1', 'quantile': 0.05}
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001526726
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.428250283299938}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001024725
warning 1 × Missing logo subcommand.report
0001569083
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362
warning 1 × Ignoring company because Expenses is zero pre-agg
0000842162

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 82,654 456,531 135,192,281 4,006,250,000 85,181,000,000 0001569083 0000714284 0001467858
1 LiabilitiesNoncurrent 0 0 2,355,492 5,281,850,000 92,434,000,000 0000060977 0000743238 0001467858
2 remainder_Liabilities 0 0 0 2,036,455,000 3,171,664,000 0000060977 0000868780 0001318605
3 AssetsCurrent 5,018 298,396 275,102,411 5,227,285,000 76,203,000,000 0001168663 0001637655 0001467858
4 AssetsNoncurrent 0 0 11,278,739 4,211,945,001 145,487,000,000 0000277509 0000763744 0001467858
5 PropertyPlantAndEquipmentNet 0 32,953 89,981,175 3,236,465,000 35,820,000,000 0001168663 0001043337 0001467858
6 Goodwill 0 0 22,783,732 1,823,645,000 3,183,400,000 0000095552 0001290900 0001411207
7 remainder_Assets -35,820,000,000 -537,019,718 9,939,859 588,330,000 9,828,427,000 0001467858 0000093389 0001318605
8 CostOfGoodsAndServicesSold 0 0 0 535,034,000 136,333,000,000 0000026780 0000060977 0001467858
9 SellingGeneralAndAdministrativeExpense 0 0 93,312,032 1,206,573,150 11,710,000,000 0000714284 0001589526 0001467858
10 ResearchAndDevelopmentExpense 0 0 0 129,055,705 834,408,000 0000026780 0000095552 0001318605
11 remainder_Expenses 11,351 574,546 495,077,193 8,733,465,000 13,967,000,000 0001168663 0000743238 0001521332
12 remainder_Revenues 0 76,268 701,989,769 9,779,210,000 166,380,000,000 0001168663 0000277509 0001467858
13 remainder_NetIncome -223,000,000 -30,684,500 0 23,388,983 2,711,000,000 0001521332 0000918251 0001467858
14 remainder_ComprehensiveNetIncome -1,135,000,000 -236,075,000 -3,843,816 525,803 77,948,000 0001467858 0001485469 0001318605
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 250,273 761,500 242,921,100 10,733,450,000 177,615,000,000 0001569083 0000277509 0001467858
1 Assets 5,018 514,753 578,366,640 11,931,736,000 221,690,000,000 0001168663 0001637655 0001467858
2 Expenses 51,232 858,497 663,004,449 9,295,500,000 161,931,000,000 0001569083 0000277509 0001467858
3 Revenues 0 76,268 701,989,769 9,779,210,000 166,380,000,000 0001168663 0000277509 0001467858
4 StockholdersEquity -5,293,000,000 -6,962,254 223,222,390 5,615,782,650 44,075,000,000 0000808450 0001316517 0001467858
5 NetIncome -773,046,000 -26,255,427 29,380,601 989,545,600 7,160,000,000 0001318605 0001424929 0001467858
6 ComprehensiveNetIncome -695,098,000 -26,286,736 18,263,304 710,189,800 6,025,000,000 0001318605 0000924822 0001467858
7 BaseVar 461,671 8,609,705 5,627,049,534 80,068,007,636 1,451,884,390,000 0001569083 0000277509 0001467858
8 EconomicCapitalRatio -17.4 -11.4 1.19 3.71 4.60 0001063197 0001521332 0000868780

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -3.17 -0.784 1.03 3.08 24.8 0001425287 0001320461 0001168663
1 LiabilitiesNoncurrent -1.75 -0.859 0.0113 1.09 1.16 0001411207 0001569083 0000743238
2 remainder_Liabilities -1.66 -0.367 0.324 0.969 1.26 0001062231 0000355811 0001063197
3 AssetsCurrent -4.47 -1.35 -0.155 2.67 8.36 0001425287 0000277509 0001063197
4 AssetsNoncurrent -2.05 -0.542 -0.106 0.682 1.33 0001425287 0000775158 0001467858
5 PropertyPlantAndEquipmentNet -1.30 -0.574 -0.0233 0.281 5.45 0001063197 0001390844 0001425287
6 Goodwill -2.01 -0.896 -0.120 0.430 1.74 0001425287 0000918251 0001411207
7 remainder_Assets -1.77 -0.630 -0.0685 1.11 7.66 0001063197 0001485469 0000837852
8 CostOfGoodsAndServicesSold -17.2 -5.53 1.30 2.78 3.38 0000924822 0001063197 0000743238
9 SellingGeneralAndAdministrativeExpense -3.79 -2.04 0.410 1.50 2.42 0001425287 0001398529 0000933034
10 ResearchAndDevelopmentExpense -5.14 -0.710 0.229 0.608 0.666 0001425287 0001637655 0000763744
11 remainder_Expenses -11.4 -5.02 -0.841 6.04 14.9 0001063197 0000837852 0000924822
12 remainder_Revenues -8.34 -4.12 1.76 4.07 5.09 0001063197 0000903129 0000763744
13 remainder_NetIncome -6.73 -0.446 0.259 0.649 0.703 0001096275 0001062231 0001316517
14 remainder_ComprehensiveNetIncome -0.573 -0.308 0.0349 0.266 0.288 0000933034 0001398529 0001456189
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -4.22 -1.06 1.04 3.61 16.5 0001425287 0001485469 0001168663
1 Assets -5.34 -1.88 -0.155 1.82 6.70 0001425287 0001043337 0000837852
2 Expenses -8.94 -3.32 0.479 1.23 2.20 0001425287 0000095552 0001096275
3 Revenues -8.34 -4.12 1.76 4.07 5.09 0001063197 0000903129 0000763744
4 StockholdersEquity -3.52 -2.22 0.890 2.13 2.24 0001168663 0001157762 0000355811
5 NetIncome -17.4 -8.48 2.50 4.73 5.90 0001063197 0001456189 0000763744
6 ComprehensiveNetIncome -17.3 -8.37 2.47 4.98 6.15 0001063197 0001320461 0000763744
7 BaseVar nan nan nan nan nan 0000026780 0001043337 0000026780
8 EconomicCapitalRatio -17.1 -11.1 1.50 4.03 4.91 0001063197 0001521332 0000868780

2017

Logs

error 3 × Unusually strong effect check_effects
{'var_name': 'NetIncome', 'quantile_value': '-15.3', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-15.4', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-17.0', 'quantile': 0.05}
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362 0001318605
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -18.242165800626307}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001024725
warning 1 × Missing logo subcommand.report
0001569083
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 510,108 171,368,490 4,591,150,000 76,890,000,000 0000813762 0000903129 0001467858
1 LiabilitiesNoncurrent 0 0 30,744,594 8,156,000,000 99,392,000,000 0000060977 0001316517 0001467858
2 remainder_Liabilities 0 0 0 1,719,900,000 9,233,000,000 0000060977 0000763744 0000813762
3 AssetsCurrent 5,014 425,372 417,080,520 6,105,760,000 68,744,000,000 0001168663 0000763744 0001467858
4 AssetsNoncurrent 0 0 11,520,660 5,134,106,500 143,738,000,000 0000277509 0001637655 0001467858
5 PropertyPlantAndEquipmentNet 0 3,626 111,598,145 6,252,500,000 36,253,000,000 0001168663 0000933034 0001467858
6 Goodwill 0 0 69,718,105 2,734,000,000 3,163,000,000 0000714284 0000903129 0001521332
7 remainder_Assets -36,253,000,000 -2,629,350,000 4,303,428 1,238,150,000 18,008,000,000 0001467858 0001637655 0000813762
8 CostOfGoodsAndServicesSold 0 0 0 1,487,890,000 114,869,000,000 0000026780 0000095552 0001467858
9 SellingGeneralAndAdministrativeExpense 0 0 97,737,130 1,829,070,500 9,575,000,000 0000714284 0000060977 0001467858
10 ResearchAndDevelopmentExpense 0 0 0 126,000,000 1,378,073,000 0000026780 0000277509 0001318605
11 remainder_Expenses 12,635 583,892 589,744,705 13,733,500,000 23,236,000,000 0001168663 0001043337 0001467858
12 remainder_Revenues 0 19,500 898,523,605 18,340,000,000 145,588,000,000 0001168663 0000277509 0001467858
13 remainder_NetIncome -1,790,000,000 -57,123,000 -273,179 136,700,000 390,000,000 0001467858 0001019787 0001670541
14 remainder_ComprehensiveNetIncome -304,172,000 -33,500,000 1,175,612 297,133,000 1,337,000,000 0000793952 0000837852 0001467858
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 357,061 842,772 315,037,830 15,571,000,000 176,282,000,000 0001569083 0001043337 0001467858
1 Assets 5,014 521,954 717,611,775 20,912,686,000 212,482,000,000 0001168663 0001157762 0001467858
2 Expenses 80,396 1,113,168 833,268,250 17,391,450,000 147,680,000,000 0001381871 0000277509 0001467858
3 Revenues 0 19,500 898,523,605 18,340,000,000 145,588,000,000 0001168663 0000277509 0001467858
4 StockholdersEquity -4,574,000,000 -6,150,552 248,786,955 6,223,447,000 36,200,000,000 0000808450 0000918251 0001467858
5 NetIncome -3,882,000,000 -35,293,352 31,390,280 1,171,450,000 2,591,000,000 0001467858 0001687221 0000813762
6 ComprehensiveNetIncome -2,545,000,000 -32,071,116 35,028,165 1,195,800,000 2,587,000,000 0001467858 0000918251 0000813762
7 BaseVar 550,073 8,716,889 7,363,248,380 146,707,769,000 1,311,791,150,000 0001168663 0000277509 0001467858
8 EconomicCapitalRatio -38.8 -18.2 1.29 3.84 5.04 0001563568 0001687221 0000355811

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -11.1 -3.60 1.17 2.79 24.0 0001563568 0001034670 0001168663
1 LiabilitiesNoncurrent -5.88 -2.33 -0.0366 1.07 1.18 0001096275 0001316517 0000924822
2 remainder_Liabilities -5.30 -1.93 0.369 1.12 5.77 0001563568 0000918251 0001063197
3 AssetsCurrent -8.77 -3.61 -0.177 1.37 7.94 0001096275 0001034670 0001558583
4 AssetsNoncurrent -5.49 -2.09 -0.107 0.525 1.56 0001096275 0000775158 0001467858
5 PropertyPlantAndEquipmentNet -6.58 -0.762 -0.0448 0.328 0.627 0001096275 0000808450 0001318605
6 Goodwill -5.77 -2.15 -0.0933 0.292 1.24 0001563568 0000924822 0001411207
7 remainder_Assets -1.58 -0.439 -0.00641 0.987 2.56 0001563568 0001290900 0001096275
8 CostOfGoodsAndServicesSold -18.0 -8.31 1.57 3.53 4.09 0000837852 0000355811 0000763744
9 SellingGeneralAndAdministrativeExpense -4.18 -1.48 0.311 2.07 2.34 0001425287 0001467858 0001096275
10 ResearchAndDevelopmentExpense -9.99 -0.770 0.458 1.05 1.19 0001425287 0001521332 0000763744
11 remainder_Expenses -26.4 -5.78 -1.19 8.32 15.0 0001563568 0000808450 0000837852
12 remainder_Revenues -16.0 -6.98 1.70 4.53 5.77 0001563568 0001707092 0000763744
13 remainder_NetIncome -15.9 -0.773 0.534 1.15 1.29 0001096275 0000918251 0000763744
14 remainder_ComprehensiveNetIncome -0.413 -0.230 -0.0288 0.318 0.486 0000793952 0001569083 0000903129
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -15.9 -5.08 1.36 4.46 15.8 0001563568 0001290900 0001168663
1 Assets -17.1 -6.07 -0.278 1.09 11.3 0001563568 0001670541 0001558583
2 Expenses -19.9 -2.90 0.452 1.21 2.25 0001563568 0001043337 0001381871
3 Revenues -16.0 -6.98 1.70 4.53 5.77 0001563568 0001707092 0000763744
4 StockholdersEquity -3.52 -2.25 0.595 2.39 2.98 0001168663 0001617669 0001558583
5 NetIncome -35.3 -15.3 3.05 5.52 7.01 0001563568 0001034670 0000763744
6 ComprehensiveNetIncome -35.5 -15.4 2.93 5.46 6.77 0001563568 0001670541 0000763744
7 BaseVar nan nan nan nan nan 0000026780 0001111335 0000026780
8 EconomicCapitalRatio -37.5 -17.0 2.58 5.14 6.34 0001563568 0001687221 0000355811

2018

Logs

error 2 × Unusually strong effect check_effects
{'var_name': 'remainder_Expenses', 'quantile_value': '-11.0', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-10.8', 'quantile': 0.05}
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001425287
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.444733215872446}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001024725
warning 1 × Missing logo subcommand.report
0001569083
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000075362
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001318605
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 520,350 172,310,258 4,330,870,000 82,237,000,000 0000813762 0000903129 0001467858
1 LiabilitiesNoncurrent 0 0 21,798,831 6,173,600,000 102,325,000,000 0000060977 0000714284 0001467858
2 remainder_Liabilities 0 0 0 735,240,000 3,191,000,000 0000060977 0000743238 0000813762
3 AssetsCurrent 1,544 145,578 407,118,535 5,651,025,000 75,293,000,000 0001168663 0000903129 0001467858
4 AssetsNoncurrent 0 0 13,273,082 5,188,407,900 152,046,000,000 0000277509 0001687221 0001467858
5 PropertyPlantAndEquipmentNet 0 0 114,399,578 3,864,800,000 38,758,000,000 0001168663 0000933034 0001467858
6 Goodwill 0 0 55,180,841 2,001,415,000 3,904,000,000 0000714284 0000903129 0001521332
7 remainder_Assets -38,758,000,000 -2,638,080,000 4,477,044 1,008,950,000 15,289,000,000 0001467858 0000868780 0000813762
8 CostOfGoodsAndServicesSold 0 0 399,388,283 9,110,000,000 120,656,000,000 0000775158 0001424929 0001467858
9 SellingGeneralAndAdministrativeExpense 0 0 96,563,043 1,315,653,900 9,650,000,000 0000714284 0000060977 0001467858
10 ResearchAndDevelopmentExpense 0 0 0 155,030,000 1,460,370,000 0000026780 0000775158 0001318605
11 remainder_Expenses 13,793 472,574 44,090,927 11,602,100,000 18,275,388,000 0001168663 0000933034 0001318605
12 remainder_Revenues 0 0 936,108,437 19,108,275,000 147,049,000,000 0001168663 0000868780 0001467858
13 remainder_NetIncome -412,400,000 -82,554,150 -3,959 34,629,550 4,689,000,000 0001034670 0001168663 0001467858
14 remainder_ComprehensiveNetIncome -921,000,000 -274,835,000 -1,906,128 958,521 44,925,000 0001467858 0001637655 0001318605
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 100 685,229 313,323,306 10,790,250,000 184,562,000,000 0001703157 0000903129 0001467858
1 Assets 1,544 175,245 823,293,934 17,392,200,000 227,339,000,000 0001168663 0000093389 0001467858
2 Expenses 85,456 565,646 924,558,518 19,336,330,000 143,733,000,000 0001168663 0000903129 0001467858
3 Revenues 0 0 936,108,437 19,108,275,000 147,049,000,000 0001168663 0000868780 0001467858
4 StockholdersEquity -3,926,000,000 -8,727,240 320,313,366 6,653,111,000 42,777,000,000 0000808450 0001424929 0001467858
5 NetIncome -1,601,000,000 -245,895,000 29,893,203 1,169,865,000 8,005,000,000 0001670541 0000924822 0001467858
6 ComprehensiveNetIncome -1,819,000,000 -242,873,500 16,687,417 895,030,000 7,084,000,000 0001670541 0000918251 0001467858
7 BaseVar 607,073 5,503,039 7,549,606,659 155,685,468,400 1,323,348,340,000 0001168663 0001637655 0001467858
8 EconomicCapitalRatio -20.0 -11.4 1.09 3.40 5.71 0001096275 0000026780 0000355811

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -1.21 -0.768 0.992 6.15 27.0 0001703157 0001320461 0001168663
1 LiabilitiesNoncurrent -2.87 -0.829 0.0735 1.22 1.51 0001096275 0001687221 0001456189
2 remainder_Liabilities -1.55 -0.777 0.190 0.707 26.4 0001096275 0000093389 0001063197
3 AssetsCurrent -2.98 -1.96 -0.144 2.43 42.3 0001096275 0000095552 0001703157
4 AssetsNoncurrent -2.69 -0.788 -0.149 0.733 1.70 0001096275 0001318605 0001316517
5 PropertyPlantAndEquipmentNet -2.82 -1.15 -0.0386 0.262 3.20 0001096275 0001111335 0001558583
6 Goodwill -2.35 -0.877 -0.0978 0.254 1.08 0001096275 0000918251 0001411207
7 remainder_Assets -0.594 -0.388 -0.00474 0.801 1.39 0001521332 0001424929 0000918251
8 CostOfGoodsAndServicesSold -9.85 -7.21 -2.15 8.11 18.8 0000743238 0001390844 0000837852
9 SellingGeneralAndAdministrativeExpense -1.70 -1.39 0.338 1.49 2.12 0001168663 0001316517 0001456189
10 ResearchAndDevelopmentExpense -2.70 -0.616 0.328 0.614 1.10 0001558583 0001521332 0000837852
11 remainder_Expenses -24.5 -11.0 1.96 6.67 8.78 0000837852 0000793952 0000743238
12 remainder_Revenues -7.49 -4.92 1.70 4.44 6.81 0001096275 0001670541 0000837852
13 remainder_NetIncome -6.80 -1.63 0.508 1.16 1.92 0001381871 0001320461 0000837852
14 remainder_ComprehensiveNetIncome -0.296 -0.194 0.0370 0.150 0.579 0001316517 0001558583 0001096275
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -3.88 -1.27 1.09 9.74 18.6 0001096275 0000837852 0001063197
1 Assets -8.10 -3.38 -0.188 1.62 17.5 0001096275 0000093389 0001703157
2 Expenses -5.99 -3.56 0.457 1.29 2.42 0001703157 0001617669 0001381871
3 Revenues -7.49 -4.92 1.70 4.44 6.81 0001096275 0001670541 0000837852
4 StockholdersEquity -3.54 -2.69 0.697 2.57 3.46 0001168663 0001617669 0001703157
5 NetIncome -16.5 -9.40 2.91 5.44 5.83 0001096275 0001707092 0001456189
6 ComprehensiveNetIncome -15.9 -9.33 2.88 5.61 5.89 0001096275 0001390844 0001456189
7 BaseVar nan nan nan nan nan 0000026780 0001096275 0000026780
8 EconomicCapitalRatio -19.4 -10.8 1.72 4.04 6.35 0001096275 0000026780 0000355811

2019

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001569083
warning 2 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000075362 0000793952
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000808450 0001318605
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.20817752369246}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001569083
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 234,766 205,946,619 4,451,930,000 84,905,000,000 0000813762 0000868780 0001467858
1 LiabilitiesNoncurrent 0 0 14,517,222 7,217,900,000 97,175,000,000 0000060977 0001316517 0001467858
2 remainder_Liabilities 0 0 13,028 1,760,385,000 5,497,000,000 0000060977 0001404804 0000813762
3 AssetsCurrent 8,215 176,289 495,807,860 6,026,005,000 74,992,000,000 0001168663 0000093389 0001467858
4 AssetsNoncurrent 0 0 59,975,182 5,917,901,600 153,045,000,000 0000813762 0001411207 0001467858
5 PropertyPlantAndEquipmentNet 0 14,476 150,615,790 4,109,800,000 38,750,000,000 0001168663 0000903129 0001467858
6 Goodwill 0 0 69,100,673 2,225,755,000 3,593,000,000 0000714284 0001589526 0001521332
7 remainder_Assets -38,750,000,000 -3,356,175,000 8,367,532 1,176,050,000 15,591,000,000 0001467858 0001425287 0000813762
8 CostOfGoodsAndServicesSold 0 0 498,043,939 10,233,300,000 110,651,000,000 0000808450 0001637655 0001467858
9 SellingGeneralAndAdministrativeExpense 0 0 140,425,024 1,314,069,600 8,491,000,000 0000714284 0001637655 0001467858
10 ResearchAndDevelopmentExpense 0 0 0 179,480,000 1,343,000,000 0000026780 0000093389 0001318605
11 remainder_Expenses 52,281 785,822 82,432,602 12,622,900,000 21,453,000,000 0001703157 0000918251 0001318605
12 remainder_Revenues 0 141,547 1,078,952,983 18,660,795,000 137,237,000,000 0001168663 0000093389 0001467858
13 remainder_NetIncome -253,000,000 -50,040,000 0 119,573,950 2,737,000,000 0000026780 0000793952 0001467858
14 remainder_ComprehensiveNetIncome -2,052,000,000 -118,900,000 0 18,847,100 694,000,000 0001467858 0001019787 0000813762
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 100 1,427,478 410,489,509 12,627,050,000 182,080,000,000 0001703157 0001637655 0001467858
1 Assets 33,299 331,608 977,504,207 20,726,000,000 228,037,000,000 0001168663 0000868780 0001467858
2 Expenses 61,286 1,937,193 1,033,825,965 18,295,280,000 133,307,000,000 0001703157 0000093389 0001467858
3 Revenues 0 141,547 1,078,952,983 18,660,795,000 137,237,000,000 0001168663 0000093389 0001467858
4 StockholdersEquity -3,723,000,000 -11,663,956 488,587,417 7,837,485,450 45,957,000,000 0000808450 0000093389 0001467858
5 NetIncome -1,791,000,000 -508,735,000 20,055,279 751,355,000 6,667,000,000 0000813762 0001589526 0001467858
6 ComprehensiveNetIncome -1,097,000,000 -527,600,000 12,856,698 656,705,000 4,615,000,000 0000813762 0001290900 0001467858
7 BaseVar 298,405 13,788,788 8,549,375,458 149,931,895,950 1,243,063,910,000 0001703157 0000093389 0001467858
8 EconomicCapitalRatio -8.48 -6.21 0.937 2.86 5.53 0001063197 0001290900 0000355811

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -0.879 -0.247 0.781 2.00 9.86 0000714284 0001390844 0001168663
1 LiabilitiesNoncurrent -2.07 -0.870 -0.0377 0.900 1.19 0001411207 0001563568 0000924822
2 remainder_Liabilities -1.15 -0.394 0.374 1.09 6.78 0001062231 0000026780 0001063197
3 AssetsCurrent -2.91 -1.19 -0.169 1.23 40.8 0001096275 0001043337 0001703157
4 AssetsNoncurrent -1.15 -0.628 -0.157 0.797 1.37 0001096275 0001062231 0001467858
5 PropertyPlantAndEquipmentNet -1.20 -0.583 -0.0386 0.386 1.60 0001096275 0001043337 0001558583
6 Goodwill -1.20 -0.542 -0.0990 0.344 4.87 0001096275 0000842162 0000837852
7 remainder_Assets -0.617 -0.419 -0.0100 1.02 1.96 0001707092 0000868780 0000813762
8 CostOfGoodsAndServicesSold -9.49 -5.75 -1.93 8.24 9.46 0000924822 0001733186 0001589526
9 SellingGeneralAndAdministrativeExpense -1.78 -1.39 0.0976 1.04 1.63 0000868780 0001521332 0001096275
10 ResearchAndDevelopmentExpense -3.35 -0.827 0.383 0.782 0.951 0001558583 0001733186 0000924822
11 remainder_Expenses -10.5 -9.73 1.73 5.12 7.87 0001563568 0000793952 0000924822
12 remainder_Revenues -4.93 -3.31 1.25 3.35 4.75 0001425287 0001320461 0000924822
13 remainder_NetIncome -2.17 -0.355 0.0865 1.25 3.47 0001063197 0000808450 0001637655
14 remainder_ComprehensiveNetIncome -0.320 -0.160 0.00189 0.208 0.459 0001589526 0001019787 0000026780
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.882 -0.397 0.943 3.24 18.0 0001411207 0001034670 0001063197
1 Assets -4.28 -1.65 -0.249 1.60 18.0 0001096275 0000903129 0001703157
2 Expenses -3.97 -2.23 0.395 0.927 1.61 0001558583 0001707092 0000355811
3 Revenues -4.93 -3.31 1.25 3.35 4.75 0001425287 0001320461 0000924822
4 StockholdersEquity -3.49 -2.45 0.433 2.21 3.42 0001063197 0001617669 0001703157
5 NetIncome -8.15 -5.64 1.83 4.07 4.99 0001558583 0000808450 0000924822
6 ComprehensiveNetIncome -8.15 -5.64 1.81 4.02 4.99 0001558583 0001390844 0000924822
7 BaseVar nan nan nan nan nan 0000026780 0001063197 0000026780
8 EconomicCapitalRatio -8.40 -6.13 1.01 2.93 5.60 0001063197 0001290900 0000355811

2020

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001316517
error 1 × Negative Expenses, ignoring company. pre-agg
0001760683
warning 2 × Similarly named company. Duplicate? None
0000093389 0001759546
warning 2 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000075362 0000793952
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000808450 0001318605
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362 0001425287
warning 2 × Ignoring company because Assets is zero pre-agg
0001284454 0001541165
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -5.0637870745482925}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001759424
warning 1 × Missing logo subcommand.report
0001569083
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000037996
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362
warning 1 × Ignoring company because Expenses is zero pre-agg
0001759631

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 507,903 186,289,400 7,369,525,000 97,192,000,000 0000813762 0000060977 0000037996
1 LiabilitiesNoncurrent 0 0 4,060,662 9,617,500,000 105,607,000,000 0000060977 0001720990 0001467858
2 remainder_Liabilities 0 0 688,133 2,859,950,000 110,588,000,000 0000060977 0001759546 0000037996
3 AssetsCurrent 6,954 73,556 649,085,114 12,278,000,000 116,744,000,000 0001759424 0001759546 0000037996
4 AssetsNoncurrent 0 0 38,398,628 7,330,675,000 154,270,000,000 0000813762 0001687221 0001467858
5 PropertyPlantAndEquipmentNet 0 0 113,180,332 6,630,000,000 37,632,000,000 0001168663 0001043337 0001467858
6 Goodwill 0 0 59,835,019 2,631,750,000 3,723,000,000 0000037996 0001637655 0000908255
7 remainder_Assets -37,632,000,000 -1,519,236,095 14,730,803 3,317,500,000 47,032,000,000 0001467858 0000837852 0000037996
8 CostOfGoodsAndServicesSold 0 0 390,166,248 14,035,650,000 112,752,000,000 0000808450 0000918251 0000037996
9 SellingGeneralAndAdministrativeExpense 0 0 120,003,928 1,679,500,000 10,193,000,000 0000918251 0001637655 0000037996
10 ResearchAndDevelopmentExpense 0 0 0 207,464,250 1,491,000,000 0000026780 0000868780 0001318605
11 remainder_Expenses -941,000,000 -578,366 56,669,237 9,706,500,000 25,946,000,000 0001521332 0001758057 0001318605
12 remainder_Revenues 0 9,598 896,345,823 20,668,125,000 127,144,000,000 0001168663 0000903129 0000037996
13 remainder_NetIncome -275,423,000 -116,250,000 -36,998 171,048,736 4,941,000,000 0001758057 0001759424 0000037996
14 remainder_ComprehensiveNetIncome -2,226,000,000 -109,750,000 0 114,450,000 814,000,000 0001467858 0001789029 0000813762
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 2,830 746,848 379,238,500 18,902,000,000 236,450,000,000 0001703157 0001157762 0000037996
1 Assets 23,216 189,650 1,038,445,807 31,777,250,000 267,261,000,000 0001168663 0001731289 0000037996
2 Expenses 80,178 190,179 858,511,380 20,353,500,000 131,758,000,000 0001168663 0001589526 0000037996
3 Revenues 0 9,598 896,345,823 20,668,125,000 127,144,000,000 0001168663 0000903129 0000037996
4 StockholdersEquity -3,822,000,000 -31,195,000 511,696,648 15,096,750,000 49,677,000,000 0000808450 0000093389 0001467858
5 NetIncome -2,468,000,000 -548,275,000 -2,769,219 640,750,000 3,298,000,000 0000813762 0001096275 0001467858
6 ComprehensiveNetIncome -1,654,000,000 -623,275,000 -5,040,718 700,000,000 1,978,000,000 0000813762 0001563568 0001521332
7 BaseVar 466,562 2,449,907 7,232,070,574 172,868,207,250 1,248,688,740,000 0001703157 0000903129 0000037996
8 EconomicCapitalRatio -6.46 -5.06 0.614 3.16 5.06 0001563568 0000918251 0000355811

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -0.491 -0.218 0.497 1.93 13.5 0000793952 0001637655 0001168663
1 LiabilitiesNoncurrent -1.88 -0.741 -0.0125 0.877 1.13 0001411207 0001404804 0000924822
2 remainder_Liabilities -1.56 -0.868 0.229 1.02 1.14 0001757932 0001733186 0000924822
3 AssetsCurrent -2.10 -1.67 -0.488 4.85 7.44 0001569083 0000918251 0001703157
4 AssetsNoncurrent -0.526 -0.381 -0.0953 0.617 1.45 0001589526 0000277509 0001467858
5 PropertyPlantAndEquipmentNet -0.587 -0.508 -0.0264 0.360 1.10 0001563568 0001617669 0000095552
6 Goodwill -0.483 -0.350 -0.0577 0.348 1.37 0001563568 0000793952 0001411207
7 remainder_Assets -1.30 -1.01 -0.431 0.805 3.36 0001563568 0001558583 0001789029
8 CostOfGoodsAndServicesSold -8.52 -5.57 -1.25 6.31 8.51 0000924822 0001467858 0001589526
9 SellingGeneralAndAdministrativeExpense -2.12 -1.25 0.171 0.795 1.87 0001731289 0001687221 0000933034
10 ResearchAndDevelopmentExpense -2.29 -0.727 0.351 1.000 1.18 0001731289 0001569083 0001589526
11 remainder_Expenses -10.8 -8.04 1.05 4.11 6.21 0001589526 0000793952 0000924822
12 remainder_Revenues -3.97 -2.48 1.45 5.24 6.02 0001425287 0000808450 0000924822
13 remainder_NetIncome -4.75 -0.637 0.00943 0.352 5.62 0001758057 0001637655 0001425287
14 remainder_ComprehensiveNetIncome -0.332 -0.138 -0.0232 0.185 0.517 0000933034 0000763744 0000837852
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -1.06 -0.919 0.399 2.72 9.01 0001411207 0001637655 0001168663
1 Assets -2.94 -2.19 -0.510 3.93 5.70 0001569083 0000277509 0001731289
2 Expenses -3.84 -1.99 0.0299 1.02 2.20 0001563568 0000026780 0001758057
3 Revenues -3.97 -2.48 1.45 5.24 6.02 0001425287 0000808450 0000924822
4 StockholdersEquity -4.95 -3.25 -0.982 2.41 3.25 0001589526 0000060977 0001789029
5 NetIncome -7.03 -4.76 1.68 4.78 5.65 0001563568 0001735707 0001456189
6 ComprehensiveNetIncome -7.06 -4.56 1.65 4.75 5.59 0001563568 0001735707 0000924822
7 BaseVar nan nan nan nan nan 0000026780 0001157762 0000026780
8 EconomicCapitalRatio -6.54 -5.15 0.528 3.07 4.98 0001563568 0000918251 0000355811

2021

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0001760683
warning 4 × Similarly named company. Duplicate? None
0000093389 0001759546 0001861449 0001874178
warning 3 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000075362 0000793952 0001318605
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.068168995202946}
warning 1 × Missing logo subcommand.report
0001569083
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000037996
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001318605
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362
warning 1 × Ignoring company because Assets is zero pre-agg
0001284454

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 783,103 167,927,072 4,742,675,000 90,727,000,000 0000813762 0000277509 0000037996
1 LiabilitiesNoncurrent 0 0 29,711,125 7,084,750,000 104,495,000,000 0000093389 0000903129 0001467858
2 remainder_Liabilities -4,530,000,000 0 6,302,367 1,419,722,750 89,981,000,000 0001318605 0001731289 0000037996
3 AssetsCurrent 10,369 391,432 513,206,269 16,028,250,000 108,996,000,000 0001759424 0001731289 0000037996
4 AssetsNoncurrent 0 0 32,135,151 6,261,582,250 162,615,000,000 0000813762 0001820630 0001467858
5 PropertyPlantAndEquipmentNet 0 13,318 121,376,071 4,317,500,000 41,115,000,000 0001168663 0001157762 0001467858
6 Goodwill 0 0 55,286,387 2,489,725,000 4,370,000,000 0000037996 0000837852 0000908255
7 remainder_Assets -41,115,000,000 -494,184,220 1,952,600 1,219,000,000 20,455,000,000 0001467858 0001818644 0000813762
8 CostOfGoodsAndServicesSold 0 0 175,736,077 15,044,250,000 114,651,000,000 0001168663 0001820630 0000037996
9 SellingGeneralAndAdministrativeExpense 0 0 100,971,143 1,405,500,000 11,915,000,000 0000918251 0000903129 0000037996
10 ResearchAndDevelopmentExpense 0 0 0 366,487,750 2,593,000,000 0000026780 0000076605 0001318605
11 remainder_Expenses -21,847,089 12,250 55,280,856 5,726,800,000 41,260,000,000 0001425287 0000355811 0001318605
12 remainder_Revenues 0 0 705,321,589 18,956,075,000 136,341,000,000 0001168663 0000924822 0000037996
13 remainder_NetIncome -1,049,266,000 -360,815,810 -11,260 180,750,000 15,060,000,000 0001811210 0001456189 0000037996
14 remainder_ComprehensiveNetIncome -434,000,000 -57,500,000 0 79,850,000 4,293,000,000 0001318605 0001617669 0001467858
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 3,497 1,046,208 434,511,211 16,586,000,000 208,413,000,000 0001703157 0001637655 0000037996
1 Assets 64,519 585,704 985,904,558 26,383,000,000 257,035,000,000 0001168663 0001731289 0000037996
2 Expenses 54,823 763,909 792,030,465 18,634,150,000 133,491,000,000 0001759424 0001043337 0000037996
3 Revenues 0 0 705,321,589 18,956,075,000 136,341,000,000 0001168663 0000924822 0000037996
4 StockholdersEquity -468,000,000 -808,255 472,589,800 16,971,250,000 65,815,000,000 0001735707 0001024725 0001467858
5 NetIncome -4,688,000,000 -492,835,250 7,992,352 1,055,006,000 17,910,000,000 0001874178 0001757932 0000037996
6 ComprehensiveNetIncome -4,688,000,000 -502,585,250 11,552,542 1,082,630,500 17,892,000,000 0001874178 0001456189 0000037996
7 BaseVar 770,227 6,739,677 6,523,442,084 153,467,902,000 1,306,834,700,000 0001168663 0001043337 0000037996
8 EconomicCapitalRatio -25.4 -6.07 0.950 3.13 5.26 0001829794 0001290900 0000355811

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -3.47 -1.13 0.380 1.52 5.19 0001425287 0001320461 0001168663
1 LiabilitiesNoncurrent -3.72 -1.34 0.00109 1.15 1.45 0001829794 0001802749 0000933034
2 remainder_Liabilities -1.08 -0.670 0.176 0.761 0.982 0001758057 0001024725 0000933034
3 AssetsCurrent -10.2 -1.54 -0.441 7.26 8.73 0001829794 0001861449 0001818644
4 AssetsNoncurrent -2.05 -0.475 -0.107 0.505 1.21 0001425287 0001759424 0001467858
5 PropertyPlantAndEquipmentNet -3.87 -0.608 -0.0736 1.13 5.65 0001829794 0001759424 0001759546
6 Goodwill -4.72 -0.630 -0.158 0.424 2.97 0001829794 0001758057 0001563568
7 remainder_Assets -2.48 -0.570 -0.0789 0.948 2.27 0001829794 0001062231 0001759424
8 CostOfGoodsAndServicesSold -8.93 -6.61 -0.794 5.74 7.64 0000924822 0001820630 0001687221
9 SellingGeneralAndAdministrativeExpense -4.16 -1.19 0.276 1.13 2.06 0001731289 0001096275 0000933034
10 ResearchAndDevelopmentExpense -4.57 -1.82 0.718 2.02 2.25 0001759546 0000793952 0000933034
11 remainder_Expenses -14.7 -8.12 1.38 4.17 5.63 0001829794 0000037996 0000924822
12 remainder_Revenues -8.85 -3.44 1.94 6.02 6.62 0001829794 0001062231 0000933034
13 remainder_NetIncome -19.4 -1.24 0.387 1.09 5.18 0001425287 0001467858 0001757932
14 remainder_ComprehensiveNetIncome -0.350 -0.133 -0.0152 0.235 0.298 0000095552 0000813762 0001735707
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -6.63 -1.05 0.516 2.82 4.22 0001829794 0001316517 0001168663
1 Assets -14.4 -2.13 -0.338 5.67 6.60 0001829794 0000918251 0001759631
2 Expenses -12.7 -2.83 0.434 1.19 9.29 0001829794 0001062231 0001425287
3 Revenues -8.85 -3.44 1.94 6.02 6.62 0001829794 0001062231 0000933034
4 StockholdersEquity -4.08 -3.03 -0.762 2.52 2.94 0001569083 0001411207 0001563568
5 NetIncome -21.5 -6.25 2.80 6.65 8.09 0001829794 0001157762 0001456189
6 ComprehensiveNetIncome -21.5 -6.26 2.83 6.62 8.01 0001829794 0001062231 0001456189
7 BaseVar nan nan nan nan nan 0000026780 0001404804 0000026780
8 EconomicCapitalRatio -24.9 -5.61 1.41 3.59 5.72 0001829794 0001290900 0000355811

2022

Logs

error 1 × Unusually strong effect check_effects
{'var_name': 'remainder_Expenses', 'quantile_value': '-10.0', 'quantile': 0.05}
warning 4 × Similarly named company. Duplicate? None
0000093389 0001861449 0001874178 0001759546
warning 2 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000075362 0001318605
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001318605 0001467858
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -10.292067673012355}
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000037996
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000075362
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000075362

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 0 1,355,365 251,372,330 9,492,440,000 96,866,000,000 0000813762 0000095552 0000037996
1 LiabilitiesNoncurrent 0 0 63,450,919 8,286,200,000 100,579,000,000 0000095552 0001802749 0001467858
2 remainder_Liabilities 0 0 10,114,977 665,288,800 90,354,000,000 0000095552 0001802749 0000037996
3 AssetsCurrent 20,582 12,990,117 555,208,350 18,687,400,000 116,476,000,000 0001759424 0001758057 0000037996
4 AssetsNoncurrent 0 141,048 58,169,253 8,235,120,000 163,586,000,000 0000813762 0001424929 0001467858
5 PropertyPlantAndEquipmentNet 4,470 483,238 179,381,088 8,201,600,000 45,248,000,000 0001703157 0000277509 0001467858
6 Goodwill 0 0 51,556,321 2,609,800,000 7,691,000,000 0000037996 0000095552 0001521332
7 remainder_Assets -45,248,000,000 -1,329,454,723 12,327,818 6,790,384,800 20,718,000,000 0001467858 0001290900 0000813762
8 CostOfGoodsAndServicesSold 0 0 333,707,206 13,130,800,000 134,397,000,000 0001290900 0001820630 0000037996
9 SellingGeneralAndAdministrativeExpense 0 0 133,300,598 1,645,800,000 10,888,000,000 0000918251 0001820630 0000037996
10 ResearchAndDevelopmentExpense 0 0 372 476,302,400 3,075,000,000 0000026780 0000775158 0001318605
11 remainder_Expenses -3,868,000 0 100,041,189 8,197,400,000 148,309,000,000 0001731289 0000918251 0001467858
12 remainder_Revenues 0 48,825 982,802,377 33,005,600,000 158,057,000,000 0001425287 0001290900 0000037996
13 remainder_NetIncome -8,033,000,000 -139,200,000 -13,474 219,600,000 2,269,000,000 0000037996 0001456189 0001467858
14 remainder_ComprehensiveNetIncome -829,000,000 -319,800,000 0 51,400,000 1,595,000,000 0000037996 0001750153 0001467858
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 25,591 7,336,531 634,056,250 21,972,800,000 212,717,000,000 0001703157 0000093389 0000037996
1 Assets 201,011 18,403,108 1,239,357,915 38,798,800,000 264,037,000,000 0001703157 0000903129 0001467858
2 Expenses 60,332 10,561,375 1,171,036,626 30,201,400,000 152,176,000,000 0001759424 0000903129 0000037996
3 Revenues 0 48,825 982,802,377 33,005,600,000 158,057,000,000 0001425287 0001290900 0000037996
4 StockholdersEquity -116,000,000 -522,134 456,639,125 19,672,600,000 72,285,000,000 0001735707 0001687221 0001467858
5 NetIncome -6,752,000,000 -888,282,400 7,369,394 796,571,200 12,587,000,000 0001874178 0000918251 0001318605
6 ComprehensiveNetIncome -6,754,000,000 -891,700,000 5,197,125 623,279,600 12,290,000,000 0001874178 0000933034 0001467858
7 BaseVar 1,079,577 58,598,288 9,936,720,114 260,163,937,200 1,437,288,650,000 0001759424 0000903129 0000037996
8 EconomicCapitalRatio -29.3 -10.3 0.739 3.13 4.59 0001703157 0000918251 0001456189

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

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -7.47 -0.675 0.345 1.43 2.67 0001703157 0001521332 0001829794
1 LiabilitiesNoncurrent -5.02 -1.24 -0.0564 0.967 1.45 0001703157 0001758057 0001456189
2 remainder_Liabilities -3.09 -0.412 0.151 0.654 1.01 0001703157 0001316517 0001758057
3 AssetsCurrent -5.13 -2.31 -0.258 4.58 13.1 0001861449 0000903129 0001789029
4 AssetsNoncurrent -4.66 -0.653 -0.0867 0.634 1.22 0001703157 0001789029 0001521332
5 PropertyPlantAndEquipmentNet -7.26 -0.745 -0.0831 2.10 5.66 0001703157 0000868780 0001750153
6 Goodwill -4.68 -0.667 -0.112 0.706 2.75 0001703157 0001043337 0000837852
7 remainder_Assets -3.91 -0.667 -0.0963 1.10 2.01 0001703157 0000775158 0001759424
8 CostOfGoodsAndServicesSold -8.11 -7.17 -0.922 7.86 8.38 0000924822 0001829794 0001290900
9 SellingGeneralAndAdministrativeExpense -5.12 -2.55 0.592 2.18 2.45 0000837852 0001320461 0001703157
10 ResearchAndDevelopmentExpense -5.20 -2.69 0.821 2.32 2.48 0001750153 0001861449 0001703157
11 remainder_Expenses -27.7 -10.0 1.50 4.95 6.09 0001703157 0001731289 0000095552
12 remainder_Revenues -10.2 -4.12 1.76 5.25 6.27 0001703157 0001157762 0001456189
13 remainder_NetIncome -1.29 -0.794 -0.194 1.90 5.61 0001425287 0001404804 0001802749
14 remainder_ComprehensiveNetIncome -0.741 -0.200 0.0179 0.189 0.719 0001316517 0001822928 0000837852
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -11.3 -1.36 0.316 2.21 3.15 0001703157 0000793952 0001456189
1 Assets -15.0 -2.71 -0.141 4.68 9.13 0001703157 0001157762 0001759631
2 Expenses -14.8 -3.99 1.26 2.07 2.38 0001703157 0001043337 0001456189
3 Revenues -10.2 -4.12 1.76 5.25 6.27 0001703157 0001157762 0001456189
4 StockholdersEquity -2.59 -2.07 -0.315 1.62 2.66 0001589526 0000918251 0001759631
5 NetIncome -25.3 -8.52 3.08 6.55 8.39 0001703157 0001521332 0001456189
6 ComprehensiveNetIncome -25.2 -7.94 3.06 6.61 8.39 0001703157 0001521332 0001456189
7 BaseVar nan nan nan nan nan 0000026780 0001320461 0000026780
8 EconomicCapitalRatio -28.1 -9.16 1.87 4.26 5.72 0001703157 0000918251 0001456189

Estimates

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