QA: us_medicinal_products 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
0001374328 FITLIFE BRANDS INC. FITLIFE 14 40 18 8 1 NaN 1 91.689100 -140.27900 52.622700 118.984000 176.09800 NaN 150.59500 26 -22 -10 -7 NaN NaN
0000885462 GULF RESOURCES INC. GULF RE 1 2 8 3 3 2 2 167.994000 168.00900 112.446000 132.253000 152.40100 147.968000 145.88700 1 6 -5 0 -1 0
0000711377 NEOGEN CORP NEOGEN 2 3 1 2 2 1 3 151.957000 151.52200 159.226000 159.623000 154.59100 155.873000 144.63200 1 -2 1 0 -1 2
0001141240 LIQUIDMETAL TECHNOLOGIES INC LIQUIDM 16 6 4 7 4 3 4 82.023000 119.95300 124.555000 121.610000 145.15300 139.128000 142.77800 -10 -2 3 -3 -1 1
0000794172 MERIDIAN BIOSCIENCE INC MERIDIA 10 12 10 16 13 4 5 102.106000 101.21500 105.542000 80.830200 91.75040 123.084000 125.40400 2 -2 6 -3 -9 1
0000896264 USANA HEALTH SCIENCES INC USANA H 5 7 3 4 NaN NaN 6 124.253000 117.80400 132.733000 129.390000 NaN NaN 120.89300 2 -4 1 NaN NaN NaN
0001656472 Cronos Group Inc. Cronos NaN NaN NaN 1 5 10 7 NaN NaN NaN 219.715000 129.27600 101.411000 120.73500 NaN NaN NaN 4 5 -3
0000907654 ARCA biopharma Inc. ARCA bi 24 39 41 30 7 19 8 17.820000 -134.87000 -73.636100 20.851800 109.70400 81.845300 114.59700 15 2 -11 -23 12 -11
0001742924 Livent Corp. Livent NaN NaN NaN 13 17 18 9 NaN NaN NaN 87.312800 70.95580 84.212200 110.59400 NaN NaN NaN 4 1 -9
0001731348 Tilray Brands Inc. Tilray NaN NaN 29 32 33 17 10 NaN NaN 17.967600 15.173600 6.05852 92.815300 100.12300 NaN NaN 3 1 -16 -7
0000037785 FMC CORP FMC COR 9 8 12 9 8 14 11 110.743000 115.69200 98.803400 103.374000 105.56300 95.313300 92.68510 -1 4 -3 -1 6 -3
0001054905 INNOSPEC INC. INNOSPE 4 5 6 6 6 6 12 135.171000 129.43700 120.529000 124.511000 122.50000 120.310000 89.35760 1 1 0 0 0 6
0001038133 HESKA CORP HESKA C 11 9 7 17 12 16 13 97.554600 111.19500 115.410000 77.698200 92.17170 94.462400 88.92600 -2 -2 10 -5 4 -3
0000744218 Celldex Therapeutics Inc. Celldex 21 19 37 25 19 5 14 37.906700 54.64670 -48.756700 38.279900 67.27570 121.616000 86.81580 -2 18 -12 -6 -14 9
0001652130 Intellia Therapeutics Inc. Intelli 6 10 13 15 10 9 15 119.120000 110.69900 90.425600 83.512300 104.21500 101.980000 85.98280 4 3 2 -5 -1 6
0000787253 Natural Alternatives International Inc. Natural 7 4 5 5 18 11 16 116.791000 140.58600 123.770000 129.215000 69.04090 98.641600 85.59210 -3 1 0 13 -7 5
0000899923 MYRIAD GENETICS INC MYRIAD 3 15 2 11 20 15 17 150.051000 81.96650 137.630000 91.275700 61.44580 94.888900 84.55010 12 -13 9 9 -5 2
0000768408 CYANOTECH CORP CYANOTE 19 17 14 24 24 22 18 48.391100 61.85280 79.482700 40.938400 58.06280 68.899300 83.93130 -2 -3 10 0 -2 -4
0000811641 IMMUCELL CORP DE IMMUCEL 8 14 15 10 14 12 19 116.509000 88.43500 74.004600 96.337300 87.83060 97.994400 78.62740 6 1 -5 4 -2 7
0000009326 BALCHEM CORP BALCHEM 17 13 11 12 9 8 20 72.369700 94.17390 104.708000 90.681700 105.55600 110.011000 78.05530 -4 -2 1 -3 -1 12
0001813814 Mind Medicine (MindMed) Inc. Mind Me NaN NaN NaN NaN NaN 27 21 NaN NaN NaN NaN NaN 41.124400 75.39460 NaN NaN NaN NaN NaN -6
0001307954 Huntsman CORP Huntsma NaN NaN 19 23 21 21 22 NaN NaN 41.554300 42.919800 60.78750 70.596100 59.09520 NaN NaN 4 -2 0 1
0001754195 Trulieve Cannabis Corp. Truliev NaN NaN NaN NaN NaN 20 23 NaN NaN NaN NaN NaN 78.843200 56.90800 NaN NaN NaN NaN NaN 3
0000074303 OLIN Corp OLIN Co 22 25 24 29 35 26 24 24.155200 35.11140 33.079000 24.656800 4.24134 50.781700 51.45900 3 -1 5 6 -9 -2
0000874716 IDEXX LABORATORIES INC DE IDEXX L 27 29 28 27 25 23 25 8.182330 12.68330 23.770300 33.076600 56.42170 63.636300 48.49170 2 -1 -1 -2 -2 2
0001708035 Ecovyst Inc. Ecovyst NaN 22 20 22 30 29 26 NaN 40.95640 41.534500 46.916500 31.18590 32.002000 44.46510 NaN -2 2 8 -1 -3
0001850902 Alpha Teknova Inc. Alpha T NaN NaN NaN NaN NaN 7 27 NaN NaN NaN NaN NaN 117.919000 36.58600 NaN NaN NaN NaN NaN 20
0000073290 BIOMERICA INC BIOMERI 12 11 16 28 11 32 28 94.246100 104.78300 72.096400 30.279700 95.93270 19.012100 35.10820 -1 5 12 -17 21 -4
0001653477 Ingevity Corp Ingevit 23 21 21 26 27 28 29 19.981700 47.53870 40.175000 34.175200 36.35720 32.598400 32.47140 -2 0 5 1 1 1
0001627223 Chemours Co Chemour 28 28 27 34 32 31 30 1.246670 22.58220 26.291600 9.351710 13.95240 21.411000 21.58260 0 -1 7 -2 -1 -1
0001386570 ChromaDex Corp. ChromaD NaN NaN NaN 40 36 34 31 NaN NaN NaN -49.189000 -19.78570 -0.381285 19.71550 NaN NaN NaN -4 -2 -3
0001056358 MANNATECH INC MANNATE 18 18 23 20 26 24 32 63.851400 61.46100 33.946800 53.067800 55.46070 61.553800 14.97650 0 5 -3 6 -2 8
0001756390 Ascend Wellness Holdings Inc. Ascend NaN NaN NaN NaN NaN 33 33 NaN NaN NaN NaN NaN 4.305500 7.33804 NaN NaN NaN NaN NaN 0
0001134765 Charlie's Holdings Inc. Charlie 36 43 45 41 45 13 34 -121.119000 -225.12900 -189.395000 -52.465100 -128.98900 97.225500 -2.36677 7 2 -4 4 -32 21
0001321834 MyMD Pharmaceuticals Inc. MyMD Ph NaN NaN 42 18 23 44 35 NaN NaN -88.195500 63.954700 60.40980 -75.361400 -26.55430 NaN NaN -24 5 21 -9
0001642380 Oncocyte Corp Oncocyt 33 42 NaN 31 NaN 35 36 -30.867000 -196.51200 NaN 15.492200 NaN -6.808780 -48.87800 9 NaN NaN NaN NaN 1
0001552189 PANACEA LIFE SCIENCES HOLDINGS INC. PANACEA 32 48 50 43 50 NaN 37 -23.844700 -448.57500 -419.807000 -89.150800 -587.67200 NaN -53.32940 16 2 -7 7 NaN NaN
0001138608 BLOOMIOS INC. BLOOMIO NaN NaN NaN NaN NaN 43 38 NaN NaN NaN NaN NaN -69.809600 -55.85380 NaN NaN NaN NaN NaN -5
0001596946 Quotient Ltd Quotien NaN NaN NaN NaN 39 40 39 NaN NaN NaN NaN -46.94330 -57.149100 -91.49400 NaN NaN NaN NaN 1 -1
0001586554 Target Group Inc. Target 41 46 30 37 42 36 40 -323.281000 -338.98900 17.895700 -18.910300 -68.96820 -10.780700 -92.57230 5 -16 7 5 -6 4
0000949858 ACHIEVE LIFE SCIENCES INC. ACHIEVE 31 35 34 36 15 38 41 -22.260000 -65.28100 6.654740 -8.732270 78.33340 -27.814000 -136.68900 4 -1 2 -21 23 3
0001590695 TwinLab Consolidated Holdings Inc. TwinLab 29 33 38 46 44 47 42 0.888703 -60.69980 -61.934700 -160.363000 -117.65800 -137.228000 -137.29800 4 5 8 -2 3 -5
0000926617 Aspira Women's Health Inc. Aspira 39 38 40 42 40 37 43 -191.761000 -131.20000 -67.566400 -82.563700 -65.40200 -23.143900 -153.12300 -1 2 2 -2 -3 6
0000093314 VOLITIONRX LTD VOLITIO 20 34 39 NaN 38 42 44 42.692900 -65.03620 -65.793100 NaN -36.37940 -64.017400 -167.46600 14 5 NaN NaN 4 2
0001086303 Heyu Biological Technology Corp Heyu Bi NaN NaN 47 NaN NaN 48 45 NaN NaN -253.926000 NaN NaN -173.235000 -184.60800 NaN NaN NaN NaN NaN -3
0000810509 Navidea Biopharmaceuticals Inc. Navidea 37 1 46 49 46 49 46 -155.148000 577.24600 -241.814000 -254.752000 -133.36900 -176.865000 -261.73500 -36 45 3 -3 3 -3
0001709542 Electronic Servitor Publication Network Inc. Electro NaN NaN 26 50 51 NaN 47 NaN NaN 29.560900 -294.009000 -1004.20000 NaN -662.71900 NaN NaN 24 1 NaN NaN
0001598308 Global Wholehealth Partners Corp Global NaN NaN NaN NaN 52 51 48 NaN NaN NaN NaN -2049.53000 -1981.450000 -799.84400 NaN NaN NaN NaN -1 -3
0000722830 IMMUNOMEDICS INC IMMUNOM 34 36 31 38 NaN NaN NaN -65.698300 -83.59140 14.180800 -24.199200 NaN NaN NaN 2 -5 7 NaN NaN NaN
0001028215 KMG CHEMICALS INC KMG CHE 15 27 17 NaN NaN NaN NaN 84.139900 24.44240 68.511300 NaN NaN NaN NaN 12 -10 NaN NaN NaN NaN
0001045309 W R GRACE & CO W R GRA 25 30 32 33 34 NaN NaN 15.027500 7.97575 13.735000 12.697800 4.73720 NaN NaN 5 2 1 1 NaN NaN
0001119643 NUTRA PHARMA CORP NUTRA P 40 44 NaN NaN 47 50 NaN -295.713000 -278.78300 NaN NaN -174.23500 -274.908000 NaN 4 NaN NaN NaN 3 NaN
0001142790 TAURIGA SCIENCES INC. TAURIGA 43 47 25 48 NaN NaN NaN -390.608000 -353.46000 32.549600 -248.871000 NaN NaN NaN 4 -22 23 NaN NaN NaN
0001310630 China Foods Holdings Ltd. China F 38 41 NaN 47 31 NaN NaN -183.184000 -183.71900 NaN -234.557000 24.19960 NaN NaN 3 NaN NaN -16 NaN NaN
0001351573 Pure Harvest Corporate Group Inc. Pure Ha 13 24 NaN 19 37 NaN NaN 93.856500 35.60190 NaN 62.495700 -32.44640 NaN NaN 11 NaN NaN 18 NaN NaN
0001498380 SAVICELL Corp SAVICEL 42 45 48 NaN NaN NaN NaN -344.790000 -320.90300 -359.475000 NaN NaN NaN NaN 3 3 NaN NaN NaN NaN
0001504678 Loop Industries Inc. Loop In 35 NaN NaN NaN NaN 39 NaN -91.803300 NaN NaN NaN NaN -30.577100 NaN NaN NaN NaN NaN NaN NaN
0001578932 OCI Partners LP OCI Par 26 26 NaN NaN NaN NaN NaN 13.576600 25.95060 NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN
0001581545 GL Brands Inc. GL Bran 44 37 36 NaN NaN NaN NaN -2028.470000 -83.73240 -29.913200 NaN NaN NaN NaN -7 -1 NaN NaN NaN NaN
0001644440 GCP Applied Technologies Inc. GCP App 30 16 22 21 22 25 NaN -4.726990 68.82640 39.127000 49.240000 60.49100 52.493100 NaN -14 6 -1 1 3 NaN
0001078799 Marijuana Co of America Inc. Marijua NaN 49 49 51 48 46 NaN NaN -671.22200 -394.621000 -452.974000 -347.05200 -127.465000 NaN NaN 0 2 -3 -2 NaN
0001522767 MARIMED INC. MARIMED NaN 20 9 45 29 NaN NaN NaN 47.93150 105.795000 -130.979000 33.56920 NaN NaN NaN -11 36 -16 NaN NaN
0001606645 Foamix Pharmaceuticals Ltd. Foamix NaN 31 33 44 NaN NaN NaN NaN -16.11230 7.272210 -110.871000 NaN NaN NaN NaN 2 11 NaN NaN NaN
0001632275 CAT9 Group Inc. CAT9 Gr NaN 32 44 35 43 NaN NaN NaN -56.66430 -162.866000 0.990247 -112.19900 NaN NaN NaN 12 -9 8 NaN NaN
0001697834 Stem Holdings Inc. Stem Ho NaN 23 35 39 28 45 NaN NaN 35.88510 -0.977248 -46.269900 35.80330 -88.610500 NaN NaN 12 4 -11 17 NaN
0001493212 Phoenix Life Sciences International Limited. Phoenix NaN NaN 43 14 NaN NaN NaN NaN NaN -134.587000 85.381400 NaN NaN NaN NaN NaN -29 NaN NaN NaN
0001691430 QUANTA INC QUANTA NaN NaN NaN 52 49 NaN NaN NaN NaN NaN -490.279000 -507.74000 NaN NaN NaN NaN NaN -3 NaN NaN
0001421819 Hanjiao Group Inc. Hanjiao NaN NaN NaN NaN 41 41 NaN NaN NaN NaN NaN -68.29720 -62.085300 NaN NaN NaN NaN NaN 0 NaN
0001737927 Canopy Growth Corp Canopy NaN NaN NaN NaN 16 30 NaN NaN NaN NaN NaN 74.03020 24.799800 NaN NaN NaN NaN NaN 14 NaN

PDF reports

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

2016

Logs

error 6 × No matching role found input.sec.calculation_linkbase.expand_agg
0001632275 0001145460 0001145460 0001672690 0001086303 0001620070
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001607679
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001632275 0001145460
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.4156322401030046}
warning 1 × Similarly named company. Duplicate? None
0001581545
warning 1 × Missing logo subcommand.report
0001310630
warning 1 × Ignoring company because Assets is zero pre-agg
0001304741

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 LiabilitiesNoncurrent 0 0 0 1,881,980,000 4,534,500,000 0000037785 0000787253 0000074303
1 LiabilitiesCurrent 3,276 186,248 17,330,541 932,772,800 1,771,000,000 0001351573 0000787253 0001627223
2 remainder_Liabilities 0 0 40,762 127,214,250 1,032,500,000 0000037785 0001119643 0000074303
3 AssetsCurrent 0 26,762 46,593,163 1,441,107,600 2,849,200,000 0001310630 0001056358 0000037785
4 AssetsNoncurrent 0 0 731,301 540,895,000 685,120,000 0000093314 0000907654 0000874716
5 PropertyPlantAndEquipmentNet 0 0 6,933,000 961,225,000 3,704,900,000 0001056358 0000811641 0000074303
6 Goodwill 0 0 433,316 651,899,250 2,747,600,000 0000722830 0001141240 0000074303
7 remainder_Assets -581,805,000 -115,960,357 19,288 162,425,000 709,400,000 0000874716 0001498380 0001045309
8 GeneralAndAdministrativeExpense 0 16,432 14,222,423 1,313,252,700 5,246,900,000 0000810509 0000926617 0000074303
9 ResearchAndDevelopmentExpense 0 0 1,024,904 97,953,700 141,500,000 0000074303 0000811641 0000037785
10 remainder_Expenses 0 0 9,662,631 655,746,300 4,655,000,000 0000907654 0000885462 0001627223
11 remainder_Revenues 0 0 23,656,032 3,056,901,850 5,561,200,000 0000093314 0001374328 0000074303
12 remainder_NetIncome -32,600,000 -10,617,723 0 11,657,650 276,000,000 0000037785 0001119643 0001627223
13 remainder_ComprehensiveNetIncome -41,000,000 -23,280,000 0 121,387 4,620,000 0001627223 0001586554 0000744218
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 3,276 333,080 18,357,719 2,404,327,550 6,489,600,000 0001351573 0000787253 0000074303
1 Assets 10,164 47,583 66,319,730 5,587,770,000 8,762,600,000 0001142790 0001056358 0000074303
2 Expenses 48,949 1,666,883 55,712,989 2,815,938,750 5,669,000,000 0001310630 0000722830 0001627223
3 Revenues 0 0 23,656,032 3,056,901,850 5,561,200,000 0000093314 0001374328 0000074303
4 StockholdersEquity -139,000,000 -58,187,815 21,688,936 960,770,000 4,701,100,000 0001644440 0000907654 0000037785
5 NetIncome -132,916,000 -57,848,309 -1,088,386 121,511,150 222,054,000 0000744218 0001590695 0000874716
6 ComprehensiveNetIncome -130,606,000 -57,794,065 -1,551,253 119,858,325 221,655,500 0000744218 0000073290 0000874716
7 BaseVar 167,630 1,794,155 117,113,517 6,572,307,500 13,241,750,000 0001310630 0000787253 0000074303
8 EconomicCapitalRatio -20.3 -3.42 0.221 1.48 1.68 0001581545 0000074303 0000885462

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 LiabilitiesNoncurrent -1.45 -0.676 0.0270 0.347 0.445 0001581545 0001134765 0000896264
1 LiabilitiesCurrent -8.25 -0.212 0.244 2.06 6.27 0001581545 0000074303 0001142790
2 remainder_Liabilities -2.90 -0.105 0.0385 0.145 1.46 0001581545 0001028215 0001498380
3 AssetsCurrent -15.1 -1.34 -0.147 1.35 1.53 0001581545 0000896264 0001552189
4 AssetsNoncurrent -3.44 -0.185 -0.0274 0.0567 0.360 0001581545 0001028215 0000874716
5 PropertyPlantAndEquipmentNet -8.88 -0.592 -0.0300 0.376 1.22 0001581545 0000794172 0001578932
6 Goodwill -7.60 -0.515 -0.0542 0.486 0.599 0001581545 0001642380 0001134765
7 remainder_Assets -0.269 -0.0340 0.00399 0.197 0.232 0001586554 0000794172 0001310630
8 GeneralAndAdministrativeExpense -14.2 -1.04 0.135 0.686 0.793 0001581545 0001141240 0001498380
9 ResearchAndDevelopmentExpense -1.54 -0.722 0.166 0.431 1.19 0001498380 0000810509 0001581545
10 remainder_Expenses -1.68 -1.25 0.101 0.450 2.28 0001586554 0001134765 0001581545
11 remainder_Revenues -2.80 -0.715 0.107 1.37 2.05 0001581545 0000811641 0001056358
12 remainder_NetIncome -1.90 -0.245 -0.0159 0.319 0.476 0001581545 0000009326 0001351573
13 remainder_ComprehensiveNetIncome -0.0624 -0.00725 0.00235 0.0106 0.0186 0000885462 0001578932 0001056358
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -9.60 -0.358 0.301 1.28 3.51 0001581545 0001141240 0001142790
1 Assets -17.2 -1.85 -0.00276 0.803 0.943 0001581545 0000885462 0000907654
2 Expenses -10.7 -1.15 0.111 0.455 0.508 0001581545 0001038133 0000885462
3 Revenues -2.80 -0.715 0.107 1.37 2.05 0001581545 0000811641 0001056358
4 StockholdersEquity -4.24 -1.97 0.102 1.08 1.20 0001581545 0000787253 0001351573
5 NetIncome -15.4 -1.63 0.452 1.19 1.58 0001581545 0001045309 0000896264
6 ComprehensiveNetIncome -15.4 -1.63 0.455 1.20 1.58 0001581545 0001045309 0000896264
7 BaseVar nan nan nan nan nan 0000009326 0001028215 0000009326
8 EconomicCapitalRatio -19.8 -2.95 0.691 1.95 2.15 0001581545 0000074303 0000885462

2017

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001086303
warning 2 × Missing logo subcommand.report
0001310630 0001632275
warning 2 × Ignoring company because Assets is zero pre-agg
0001304741 0001580836
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.476716811421271}
warning 1 × Similarly named company. Duplicate? None
0001581545
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001086303
warning 1 × Ignoring company because Expenses is zero pre-agg
0001691430

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 LiabilitiesNoncurrent 0 0 76,718 2,261,674,600 4,999,100,000 0000037785 0000810509 0000074303
1 LiabilitiesCurrent 0 169,170 10,271,476 1,281,126,800 2,209,400,000 0001141240 0000787253 0000037785
2 remainder_Liabilities 0 0 0 160,400,000 229,100,000 0000037785 0000073290 0000899923
3 AssetsCurrent 0 48,798 42,233,653 1,464,800,000 3,652,700,000 0001310630 0001141240 0000037785
4 AssetsNoncurrent 0 0 580,520 593,201,200 1,208,400,000 0000093314 0001522767 0000074303
5 PropertyPlantAndEquipmentNet 0 0 10,382,046 1,148,310,400 3,575,800,000 0001056358 0000744218 0000074303
6 Goodwill 0 0 249,155 1,578,340,000 3,830,700,000 0000722830 0000811641 0000037785
7 remainder_Assets -622,815,000 -75,510,448 88.7 148,600,000 556,500,000 0000874716 0000907654 0001045309
8 GeneralAndAdministrativeExpense 0 56,850 15,801,379 1,410,428,800 5,890,300,000 0001498380 0001578932 0000074303
9 ResearchAndDevelopmentExpense 0 0 1,131,317 89,702,600 141,500,000 0000074303 0000073290 0000037785
10 remainder_Expenses -14,900,000 -3,655,703 5,139,001 872,208,800 4,866,000,000 0000074303 0000811641 0001627223
11 remainder_Revenues 0 0 10,462,415 2,516,884,800 6,271,700,000 0000093314 0000811641 0000074303
12 remainder_NetIncome -49,094,000 -8,386,200 0 101,104,150 664,300,000 0001708035 0001045309 0001644440
13 remainder_ComprehensiveNetIncome -25,700,000 -2,155,800 0 77,180,000 235,500,000 0001045309 0000926617 0000037785
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 33,643 328,863 11,657,325 2,727,601,600 6,464,600,000 0001351573 0001606645 0000074303
1 Assets 56.0 78,925 72,613,314 6,141,982,000 9,218,300,000 0001586554 0000787253 0000074303
2 Expenses 54,918 728,946 70,568,080 2,462,157,200 5,875,400,000 0001310630 0001606645 0000074303
3 Revenues 0 0 10,462,415 2,516,884,800 6,271,700,000 0000093314 0000811641 0000074303
4 StockholdersEquity -53,842,000 -8,354,729 23,674,841 1,438,591,400 6,996,900,000 0000874716 0000811641 0000037785
5 NetIncome -153,266,286 -66,811,800 -192,818 483,000,000 747,000,000 0000722830 0001632275 0001627223
6 ComprehensiveNetIncome -153,321,358 -66,811,800 -192,762 515,800,000 814,000,000 0000722830 0001632275 0001627223
7 BaseVar 197,213 1,228,731 83,914,251 7,462,958,400 13,929,500,000 0001351573 0001606645 0000074303
8 EconomicCapitalRatio -6.71 -3.48 0.351 1.47 5.77 0001078799 0000074303 0000810509

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 LiabilitiesNoncurrent -0.867 -0.695 0.0135 0.410 1.21 0001028215 0000093314 0000810509
1 LiabilitiesCurrent -0.392 -0.263 0.262 3.61 5.32 0001590695 0001028215 0001142790
2 remainder_Liabilities -0.344 -0.278 0.0424 0.201 1.16 0001578932 0000711377 0001498380
3 AssetsCurrent -3.08 -1.24 -0.0800 1.09 2.67 0001078799 0001627223 0000907654
4 AssetsNoncurrent -0.492 -0.199 -0.0240 0.0862 0.341 0001078799 0000073290 0000874716
5 PropertyPlantAndEquipmentNet -1.78 -0.700 -0.0642 0.862 1.95 0001078799 0000874716 0001697834
6 Goodwill -1.39 -0.543 -0.0771 0.574 0.731 0001078799 0001522767 0000810509
7 remainder_Assets -0.743 -0.0442 -0.00280 0.185 0.571 0000810509 0000009326 0001581545
8 GeneralAndAdministrativeExpense -2.28 -1.11 0.111 0.551 0.757 0001078799 0001141240 0000787253
9 ResearchAndDevelopmentExpense -1.71 -0.851 0.146 0.404 0.459 0000907654 0000874716 0001374328
10 remainder_Expenses -2.22 -1.29 0.135 0.672 1.09 0001374328 0000885462 0000810509
11 remainder_Revenues -1.15 -0.703 0.0383 1.64 1.97 0000810509 0000037785 0000896264
12 remainder_NetIncome -1.58 -0.662 -0.00345 0.375 5.73 0001078799 0001119643 0000810509
13 remainder_ComprehensiveNetIncome -0.0194 -0.0108 -0.00365 0.0236 0.0572 0001642380 0001119643 0000885462
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.388 -0.306 0.250 2.47 2.99 0001522767 0000899923 0001142790
1 Assets -4.32 -1.93 0.0151 0.784 1.61 0001078799 0001054905 0000810509
2 Expenses -1.60 -1.15 0.0546 0.489 1.77 0001374328 0001590695 0000810509
3 Revenues -1.15 -0.703 0.0383 1.64 1.97 0000810509 0000037785 0000896264
4 StockholdersEquity -2.12 -2.03 0.0294 1.21 1.29 0001078799 0001642380 0000885462
5 NetIncome -4.24 -1.83 0.425 1.26 6.35 0001078799 0000811641 0000810509
6 ComprehensiveNetIncome -4.25 -1.84 0.423 1.27 6.34 0001078799 0000811641 0000810509
7 BaseVar nan nan nan nan nan 0000009326 0001056358 0000009326
8 EconomicCapitalRatio -6.50 -3.26 0.567 1.69 5.99 0001078799 0000074303 0000810509

2018

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001678746
warning 2 × Similarly named company. Duplicate? None
0001581545 0001731348
warning 2 × Ignoring company because Expenses is zero pre-agg
0001742924 0001691430
warning 2 × Ignoring company because Assets is zero pre-agg
0001310630 0001580836
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.119777026066146}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001678746
warning 1 × Missing logo subcommand.report
0001632275

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 LiabilitiesNoncurrent 0 0 220,267 2,839,710,000 4,528,000,000 0000037785 0001522767 0000074303
1 LiabilitiesCurrent 0 306,227 10,181,282 1,676,690,000 2,993,400,000 0001141240 0001606645 0000037785
2 remainder_Liabilities -29,267,000 0 0 217,968,442 433,100,000 0000874716 0000037785 0001045309
3 AssetsCurrent 0 55,600 39,100,031 2,395,230,000 4,030,200,000 0001709542 0001056358 0000037785
4 AssetsNoncurrent 0 0 1,219,949 754,397,350 1,150,400,000 0000093314 0001697834 0000074303
5 PropertyPlantAndEquipmentNet 0 0 13,769,433 2,229,240,550 3,482,100,000 0001056358 0000722830 0000074303
6 Goodwill 0 0 375,768 1,494,455,750 4,172,400,000 0000722830 0000810509 0000037785
7 remainder_Assets -693,584,000 -80,242,946 0 231,710,000 529,400,000 0000874716 0001552189 0001045309
8 GeneralAndAdministrativeExpense 0 15,750 17,826,279 4,499,645,000 8,184,000,000 0001086303 0000744218 0001307954
9 ResearchAndDevelopmentExpense 0 0 1,918,734 109,501,943 291,500,000 0000074303 0001141240 0000037785
10 remainder_Expenses -2,133,000 -70,850 1,417,980 352,510,000 590,412,000 0001038133 0001321834 0000896264
11 remainder_Revenues 0 0 12,949,106 5,778,410,000 9,379,000,000 0000093314 0000744218 0001307954
12 remainder_NetIncome -229,000,000 -19,585,100 0 13,909,338 167,000,000 0001307954 0001045309 0001627223
13 remainder_ComprehensiveNetIncome -506,000,000 -79,375,000 0 341,297 26,600,000 0001307954 0001632275 0001045309
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 170,023 573,323 14,305,759 4,314,935,000 6,342,000,000 0001709542 0000787253 0001627223
1 Assets 14,290 219,398 77,157,743 7,687,050,000 9,974,300,000 0001552189 0001522767 0000037785
2 Expenses 458 925,723 75,906,941 5,028,430,000 8,500,000,000 0001493212 0001606645 0001307954
3 Revenues 0 0 12,949,106 5,778,410,000 9,379,000,000 0000093314 0000744218 0001307954
4 StockholdersEquity -43,887,000 -6,027,966 35,518,941 2,260,815,250 6,980,900,000 0001590695 0001141240 0000037785
5 NetIncome -273,886,970 -80,312,000 -479,542 450,996,150 996,000,000 0000722830 0001086303 0001627223
6 ComprehensiveNetIncome -273,886,972 -82,624,370 -1,089,737 386,820,325 934,500,000 0000722830 0001632275 0001627223
7 BaseVar 302,669 1,237,188 138,347,615 12,218,980,000 15,885,500,000 0001086303 0001590695 0001307954
8 EconomicCapitalRatio -4.20 -3.12 0.311 1.29 1.59 0001552189 0001142790 0000711377

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 LiabilitiesNoncurrent -0.716 -0.648 0.0124 0.360 0.469 0001708035 0001493212 0000896264
1 LiabilitiesCurrent -0.531 -0.165 0.171 1.13 6.70 0001590695 0001708035 0001552189
2 remainder_Liabilities -1.01 -0.216 0.0864 0.296 4.85 0001731348 0000949858 0001498380
3 AssetsCurrent -1.73 -1.24 -0.111 1.20 2.45 0001552189 0000009326 0000907654
4 AssetsNoncurrent -0.438 -0.319 -0.0477 0.217 2.03 0001078799 0000811641 0001586554
5 PropertyPlantAndEquipmentNet -0.817 -0.573 -0.0341 0.491 0.942 0001078799 0001038133 0000811641
6 Goodwill -0.718 -0.481 -0.0694 0.364 0.611 0001078799 0001134765 0001586554
7 remainder_Assets -0.395 -0.123 0.00407 0.332 1.72 0001586554 0000074303 0001709542
8 GeneralAndAdministrativeExpense -1.83 -1.25 -0.0249 0.503 0.823 0001142790 0000949858 0001498380
9 ResearchAndDevelopmentExpense -1.40 -0.856 0.136 0.425 0.466 0001498380 0001708035 0001709542
10 remainder_Expenses -1.79 -0.983 0.107 0.268 0.402 0001056358 0000037785 0001374328
11 remainder_Revenues -1.42 -0.686 -0.0165 2.08 2.44 0001142790 0001708035 0001709542
12 remainder_NetIncome -2.05 -0.569 0.0266 0.185 3.57 0001078799 0000074303 0001142790
13 remainder_ComprehensiveNetIncome -0.0593 -0.0150 0.00252 0.00867 0.0509 0000885462 0000949858 0001498380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.753 -0.418 0.197 1.03 3.47 0001493212 0000037785 0001552189
1 Assets -2.54 -1.87 -0.00928 0.643 0.778 0001552189 0001045309 0000949858
2 Expenses -1.04 -0.992 0.101 0.437 0.594 0001709542 0001644440 0001493212
3 Revenues -1.42 -0.686 -0.0165 2.08 2.44 0001142790 0001708035 0001709542
4 StockholdersEquity -2.27 -1.79 0.100 0.950 1.31 0001552189 0001028215 0000885462
5 NetIncome -2.45 -1.76 0.342 1.28 1.52 0001078799 0000073290 0000896264
6 ComprehensiveNetIncome -2.45 -1.74 0.345 1.28 1.51 0001078799 0000073290 0000896264
7 BaseVar nan nan nan nan nan 0000009326 0001054905 0000009326
8 EconomicCapitalRatio -4.14 -3.06 0.370 1.35 1.65 0001552189 0001142790 0000711377

2019

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
0001678746 0000093314
warning 3 × Missing logo subcommand.report
0001310630 0001632275 0001691430
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001678746 0000093314
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -2.72417924699132}
warning 1 × Similarly named company. Duplicate? None
0001731348

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 LiabilitiesNoncurrent 0 0 985,306 2,802,575,000 5,233,600,000 0000037785 0000926617 0000074303
1 LiabilitiesCurrent 0 593,753 14,660,646 1,538,635,000 2,723,900,000 0001310630 0001386570 0000037785
2 remainder_Liabilities -33,024,000 0 0 337,722,950 519,800,000 0000874716 0000073290 0001045309
3 AssetsCurrent 0 325,510 37,311,806 2,192,350,000 4,074,800,000 0001709542 0001056358 0000037785
4 AssetsNoncurrent 0 0 4,135,778 930,176,200 1,546,900,000 0001078799 0001606645 0000074303
5 PropertyPlantAndEquipmentNet 0 0 14,729,235 1,725,073,500 3,559,000,000 0001056358 0000768408 0001627223
6 Goodwill 0 0 312,953 1,477,330,500 4,096,500,000 0000711377 0000810509 0000037785
7 remainder_Assets -832,037,000 -71,036,138 23,619 211,530,000 517,600,000 0000874716 0001691430 0001045309
8 GeneralAndAdministrativeExpense 89,482 641,828 38,450,373 4,080,455,000 6,201,000,000 0001310630 0001652130 0001307954
9 ResearchAndDevelopmentExpense 0 0 1,756,834 134,906,150 298,100,000 0000074303 0000907654 0000037785
10 remainder_Expenses -48,000,000 0 2,305,545 298,330,000 509,448,000 0001307954 0001493212 0000896264
11 remainder_Revenues 0 0 23,250,151 5,022,090,000 6,797,000,000 0000949858 0001656472 0001307954
12 remainder_NetIncome -264,000,000 -35,958,799 0 29,644,400 1,287,058,000 0001627223 0001141240 0001656472
13 remainder_ComprehensiveNetIncome -152,400,000 -32,907,567 0 16,484,950 215,000,000 0000074303 0001632275 0001627223
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 130,805 715,121 24,400,935 4,414,920,000 6,770,300,000 0001310630 0000744218 0000074303
1 Assets 23,364 994,265 62,254,262 7,735,900,000 9,872,700,000 0001310630 0001056358 0000037785
2 Expenses 89,482 1,133,248 82,445,917 4,628,810,000 6,290,000,000 0001310630 0001522767 0001307954
3 Revenues 0 0 23,250,151 5,022,090,000 6,797,000,000 0000949858 0001656472 0001307954
4 StockholdersEquity -87,760,000 -697,295 29,924,057 2,069,799,900 7,148,800,000 0001590695 0001642380 0000037785
5 NetIncome -357,319,000 -97,137,750 -2,751,433 451,375,600 1,165,574,000 0000722830 0000073290 0001656472
6 ComprehensiveNetIncome -357,363,000 -97,072,725 -2,294,421 429,493,275 1,184,894,000 0000722830 0001142790 0001656472
7 BaseVar 121,826 2,833,799 133,630,793 11,549,145,000 14,199,800,000 0001310630 0001522767 0000074303
8 EconomicCapitalRatio -4.90 -2.72 0.336 1.31 2.20 0001691430 0001653477 0001656472

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 LiabilitiesNoncurrent -0.773 -0.663 0.0741 0.356 0.457 0001653477 0001731348 0001374328
1 LiabilitiesCurrent -0.291 -0.198 0.0710 0.358 6.19 0001351573 0001627223 0001078799
2 remainder_Liabilities -0.768 -0.357 0.0860 0.292 2.57 0001731348 0000744218 0001310630
3 AssetsCurrent -2.53 -1.37 -0.0957 1.10 2.18 0001709542 0000896264 0000907654
4 AssetsNoncurrent -1.06 -0.445 -0.0546 0.337 3.33 0001709542 0000787253 0001586554
5 PropertyPlantAndEquipmentNet -1.36 -0.732 -0.0506 0.586 0.779 0001709542 0000794172 0001522767
6 Goodwill -1.54 -0.753 -0.0771 0.471 1.29 0001691430 0000787253 0001493212
7 remainder_Assets -0.780 -0.163 0.0130 0.453 3.36 0001586554 0001386570 0001709542
8 GeneralAndAdministrativeExpense -2.55 -1.60 0.0245 0.491 0.617 0001691430 0001627223 0001656472
9 ResearchAndDevelopmentExpense -0.992 -0.524 0.107 0.329 0.465 0000810509 0001586554 0001709542
10 remainder_Expenses -1.83 -0.981 0.108 0.236 0.381 0001709542 0000744218 0001374328
11 remainder_Revenues -0.765 -0.574 0.0462 1.97 2.91 0001142790 0000811641 0001632275
12 remainder_NetIncome -2.05 -0.527 0.0465 0.175 1.10 0001078799 0001038133 0001656472
13 remainder_ComprehensiveNetIncome -0.0214 -0.00775 0.000719 0.00625 0.0164 0001586554 0001590695 0001656472
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.740 -0.434 0.0948 0.911 2.71 0001691430 0000768408 0001078799
1 Assets -3.50 -2.01 -0.0560 0.630 0.694 0001691430 0001054905 0000907654
2 Expenses -3.29 -1.23 0.0611 0.420 0.804 0001691430 0001652130 0001656472
3 Revenues -0.765 -0.574 0.0462 1.97 2.91 0001142790 0000811641 0001632275
4 StockholdersEquity -2.53 -1.97 -0.0541 0.871 1.13 0001709542 0000722830 0001141240
5 NetIncome -3.81 -2.02 0.173 1.43 1.95 0001691430 0001731348 0001374328
6 ComprehensiveNetIncome -3.81 -2.01 0.167 1.44 1.95 0001691430 0001731348 0001374328
7 BaseVar nan nan nan nan nan 0000009326 0001134765 0000009326
8 EconomicCapitalRatio -4.86 -2.68 0.379 1.35 2.24 0001691430 0001653477 0001656472

2020

Logs

warning 4 × Missing logo subcommand.report
0001310630 0001632275 0001691430 0001421819
warning 2 × Ignoring company because Assets is zero pre-agg
0001138608 0001346526
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -5.437094930534009}
warning 1 × Similarly named company. Duplicate? None
0001731348
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001737927
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001138608
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001138608

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 LiabilitiesNoncurrent 0 0 4,153,228 2,559,535,000 5,178,000,000 0000009326 0001731348 0000074303
1 LiabilitiesCurrent 241,443 473,988 19,885,734 1,551,845,000 2,829,000,000 0001598308 0001522767 0000037785
2 remainder_Liabilities -11,707,000 0 0 292,341,900 649,000,000 0000874716 0000074303 0001045309
3 AssetsCurrent 0 113,391 39,754,060 2,595,255,150 4,375,600,000 0001709542 0001056358 0000037785
4 AssetsNoncurrent 0 0 5,399,549 998,720,350 1,552,000,000 0001078799 0001590695 0000074303
5 PropertyPlantAndEquipmentNet 0 0 14,507,295 1,965,891,650 3,474,000,000 0001056358 0001652130 0001627223
6 Goodwill 0 0 622,645 1,503,042,550 4,094,100,000 0000711377 0001596946 0000037785
7 remainder_Assets -851,057,000 -73,329,659 126,899 238,443,850 567,100,000 0000874716 0000073290 0001045309
8 GeneralAndAdministrativeExpense 161,462 1,311,789 29,970,576 3,818,940,000 5,796,600,000 0001586554 0000768408 0000074303
9 ResearchAndDevelopmentExpense 0 0 3,540,642 137,812,050 287,900,000 0000074303 0001742924 0000037785
10 remainder_Expenses -197,000,000 -2,087,967 2,258,571 386,433,650 932,500,000 0001307954 0001709542 0000074303
11 remainder_Revenues 0 21,445 32,281,361 4,789,205,000 6,018,000,000 0000949858 0001596946 0001307954
12 remainder_NetIncome -99,923,000 -15,158,338 0 59,540,800 679,000,000 0001708035 0000874716 0001307954
13 remainder_ComprehensiveNetIncome -59,810,000 -13,557,450 0 72,525,000 292,918,000 0000744218 0000949858 0001737927
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 241,443 994,458 28,968,701 4,210,050,000 6,820,100,000 0001598308 0001421819 0000074303
1 Assets 71,268 281,846 57,958,526 7,617,005,000 10,186,400,000 0001552189 0001056358 0000037785
2 Expenses 976,844 1,940,115 54,177,256 4,382,215,000 6,729,100,000 0001119643 0000744218 0000074303
3 Revenues 0 21,445 32,281,361 4,789,205,000 6,018,000,000 0000949858 0001596946 0001307954
4 StockholdersEquity -102,149,000 -5,738,050 35,946,536 2,592,342,400 7,357,400,000 0001590695 0000949858 0000037785
5 NetIncome -1,387,440,000 -275,856,950 -7,129,859 368,220,000 1,066,000,000 0001737927 0001586554 0001307954
6 ComprehensiveNetIncome -1,240,981,000 -278,874,075 -7,199,777 391,381,650 1,058,000,000 0001737927 0001134765 0001307954
7 BaseVar 2,401,778 2,903,215 137,369,751 11,225,892,500 13,846,400,000 0001310630 0001590695 0000074303
8 EconomicCapitalRatio -20.5 -5.44 0.460 1.48 1.76 0001598308 0001056358 0001374328

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 LiabilitiesNoncurrent -7.76 -0.661 0.0510 0.301 0.433 0001598308 0000073290 0001374328
1 LiabilitiesCurrent -8.55 -0.661 0.182 0.701 4.16 0001598308 0000907654 0001552189
2 remainder_Liabilities -3.29 -0.415 0.0449 0.106 0.173 0001598308 0001708035 0001691430
3 AssetsCurrent -14.9 -2.99 -0.107 1.05 2.05 0001598308 0001731348 0001321834
4 AssetsNoncurrent -7.70 -0.753 -0.0408 0.256 1.35 0001598308 0001038133 0001586554
5 PropertyPlantAndEquipmentNet -10.3 -1.37 -0.0317 0.421 0.537 0001598308 0001351573 0000811641
6 Goodwill -8.99 -1.22 -0.0492 0.321 0.706 0001598308 0001652130 0000899923
7 remainder_Assets -0.668 -0.157 0.000474 0.456 8.85 0001586554 0000949858 0001709542
8 GeneralAndAdministrativeExpense -13.9 -0.963 0.0942 0.426 0.531 0001598308 0000794172 0001078799
9 ResearchAndDevelopmentExpense -1.66 -0.452 0.0802 0.223 0.609 0001598308 0001421819 0001709542
10 remainder_Expenses -9.28 -0.881 0.0981 0.238 0.619 0001709542 0001596946 0001598308
11 remainder_Revenues -2.54 -0.492 0.0649 0.942 1.73 0001598308 0000811641 0001056358
12 remainder_NetIncome -1.43 -0.271 0.0610 0.213 0.427 0001078799 0001627223 0001632275
13 remainder_ComprehensiveNetIncome -0.227 -0.00723 0.00141 0.0281 0.0649 0000744218 0000768408 0000885462
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -12.0 -0.463 0.150 0.726 1.37 0001598308 0000794172 0001552189
1 Assets -17.9 -4.00 -0.0204 0.540 0.743 0001598308 0001644440 0001321834
2 Expenses -14.9 -2.03 0.140 0.404 0.540 0001598308 0001374328 0001586554
3 Revenues -2.54 -0.492 0.0649 0.942 1.73 0001598308 0000811641 0001056358
4 StockholdersEquity -4.04 -2.49 -0.0386 1.07 1.22 0001598308 0001708035 0001141240
5 NetIncome -17.2 -3.16 0.223 0.742 1.47 0001598308 0001656472 0001374328
6 ComprehensiveNetIncome -17.2 -3.16 0.228 0.748 1.47 0001598308 0001656472 0001374328
7 BaseVar nan nan nan nan nan 0000009326 0001134765 0000009326
8 EconomicCapitalRatio -19.9 -4.89 1.01 2.04 2.31 0001598308 0001056358 0001374328

2021

Logs

warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -1.7504988385194875}
warning 1 × Missing logo subcommand.report
0001421819
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001737927
warning 1 × Ignoring company because Expenses is zero pre-agg
0001415397

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 LiabilitiesNoncurrent 0 0 5,049,740 2,150,688,000 4,561,000,000 0000037785 0001056358 0001627223
1 LiabilitiesCurrent 414,000 1,170,043 22,112,145 2,059,500,000 3,520,300,000 0001141240 0000787253 0000037785
2 remainder_Liabilities -8,935,000 0 0 115,515,000 1,215,575,000 0000874716 0000744218 0001737927
3 AssetsCurrent 37,377 559,024 101,275,154 3,091,597,000 4,937,600,000 0001086303 0001850902 0000037785
4 AssetsNoncurrent 0 0 6,793,195 1,162,274,000 1,563,000,000 0001078799 0001590695 0001307954
5 PropertyPlantAndEquipmentNet 0 0 12,651,790 1,825,268,500 3,154,000,000 0000949858 0001697834 0001627223
6 Goodwill 0 0 3,716,318 2,040,430,500 4,438,712,000 0000768408 0001586554 0001731348
7 remainder_Assets -1,046,047,000 -86,590,776 214,180 202,513,500 708,167,000 0000874716 0000787253 0001737927
8 GeneralAndAdministrativeExpense 0 1,065,038 63,601,435 4,571,800,000 7,529,000,000 0001586554 0001056358 0001307954
9 ResearchAndDevelopmentExpense 0 0 4,169,235 155,504,500 304,700,000 0000074303 0000811641 0000037785
10 remainder_Expenses -1,686,000 -562,500 11,147,275 410,274,000 721,886,000 0001850902 0001590695 0001737927
11 remainder_Revenues 0 0 43,437,258 5,695,100,000 8,912,000,000 0000949858 0001596946 0000074303
12 remainder_NetIncome -440,505,000 -110,493,000 0 148,179,500 518,000,000 0001737927 0000907654 0001307954
13 remainder_ComprehensiveNetIncome -329,239,000 -25,100,000 0 51,493,000 201,900,000 0001737927 0001386570 0000074303
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 508,649 1,608,200 35,237,925 4,176,650,000 6,468,000,000 0001598308 0001056358 0001627223
1 Assets 93,549 2,393,744 164,014,545 8,033,850,000 10,581,300,000 0001086303 0001813814 0000037785
2 Expenses 259,314 3,479,090 94,622,280 5,082,500,000 7,867,000,000 0001086303 0001386570 0001307954
3 Revenues 0 0 43,437,258 5,695,100,000 8,912,000,000 0000949858 0001596946 0000074303
4 StockholdersEquity -117,089,000 -16,646,404 80,398,600 4,043,566,500 7,061,000,000 0001590695 0000787253 0000037785
5 NetIncome -1,670,820,000 -301,911,000 -6,875,259 739,422,000 1,296,700,000 0001737927 0001421819 0000074303
6 ComprehensiveNetIncome -1,835,439,500 -272,214,750 -6,980,929 731,705,000 1,397,650,000 0001737927 0001421819 0000074303
7 BaseVar 1,204,776 13,524,554 203,775,844 12,503,250,000 15,573,500,000 0001086303 0001056358 0001307954
8 EconomicCapitalRatio -19.8 -1.75 0.508 1.31 1.56 0001598308 0000074303 0000711377

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 LiabilitiesNoncurrent -6.68 -0.618 0.0660 0.316 0.409 0001598308 0001421819 0001134765
1 LiabilitiesCurrent -7.09 -0.394 0.166 0.362 3.46 0001598308 0000074303 0001119643
2 remainder_Liabilities -2.96 -0.355 0.0486 0.122 0.182 0001598308 0000926617 0001134765
3 AssetsCurrent -13.9 -0.768 -0.0615 1.09 1.63 0001598308 0001054905 0000907654
4 AssetsNoncurrent -7.75 -0.287 -0.0470 0.287 1.36 0001598308 0001038133 0001321834
5 PropertyPlantAndEquipmentNet -8.80 -0.358 -0.0335 0.274 0.423 0001598308 0001656472 0000811641
6 Goodwill -9.52 -0.379 -0.0599 0.579 0.898 0001598308 0001756390 0001642380
7 remainder_Assets -0.695 -0.162 0.0182 0.335 1.18 0001321834 0001652130 0001421819
8 GeneralAndAdministrativeExpense -1.24 -0.752 0.00625 0.350 3.00 0001386570 0001742924 0001598308
9 ResearchAndDevelopmentExpense -0.694 -0.581 0.105 0.280 0.803 0000093314 0000885462 0001598308
10 remainder_Expenses -17.9 -1.04 0.148 0.270 0.354 0001598308 0001742924 0001386570
11 remainder_Revenues -3.06 -0.513 -0.00145 1.11 2.13 0001598308 0001754195 0001056358
12 remainder_NetIncome -0.963 -0.0762 0.0280 0.187 0.665 0001119643 0001504678 0001134765
13 remainder_ComprehensiveNetIncome -0.0324 -0.0196 0.000710 0.0119 0.0227 0001737927 0000926617 0000885462
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -10.6 -0.558 0.136 0.673 2.20 0001598308 0001504678 0001119643
1 Assets -17.1 -1.11 0.00312 0.482 0.633 0001598308 0000794172 0001813814
2 Expenses -14.1 -1.03 0.107 0.416 0.634 0001598308 0001642380 0001119643
3 Revenues -3.06 -0.513 -0.00145 1.11 2.13 0001598308 0001754195 0001056358
4 StockholdersEquity -4.09 -1.93 0.145 0.989 1.16 0001598308 0001737927 0001141240
5 NetIncome -17.0 -1.18 0.247 0.916 1.62 0001598308 0001850902 0001134765
6 ComprehensiveNetIncome -17.0 -1.18 0.247 0.919 1.62 0001598308 0001850902 0001134765
7 BaseVar nan nan nan nan nan 0000009326 0001138608 0000009326
8 EconomicCapitalRatio -19.7 -1.62 0.643 1.45 1.69 0001598308 0000074303 0000711377

2022

Logs

warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -2.347405174812561}
warning 1 × Similarly named company. Duplicate? None
0001731348
warning 1 × Ignoring company because Expenses is zero pre-agg
0001415397

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 LiabilitiesNoncurrent 0 0 6,122,228 2,148,720,000 4,581,000,000 0000037785 0001586554 0001627223
1 LiabilitiesCurrent 152,578 1,294,411 25,844,111 1,951,650,000 3,799,600,000 0001709542 0001138608 0000037785
2 remainder_Liabilities -8,150,000 0 0 163,592,550 908,933,000 0000874716 0000744218 0001754195
3 AssetsCurrent 0 339,558 89,367,538 2,798,990,000 5,438,600,000 0001709542 0001596946 0000037785
4 AssetsNoncurrent 0 0 10,305,987 1,276,325,000 1,645,288,000 0001086303 0001321834 0000874716
5 PropertyPlantAndEquipmentNet 0 0 28,183,810 1,883,955,000 3,171,000,000 0000949858 0000811641 0001627223
6 Goodwill 0 0 6,513,088 1,765,836,650 4,097,400,000 0000768408 0001321834 0000037785
7 remainder_Assets -1,108,941,000 -101,120,387 116,129 177,225,000 215,000,000 0000874716 0000073290 0001627223
8 GeneralAndAdministrativeExpense 0 58,289 60,965,556 5,314,945,000 7,588,200,000 0001586554 0001850902 0000074303
9 ResearchAndDevelopmentExpense 0 0 4,787,862 209,383,000 419,979,000 0000074303 0001386570 0001652130
10 remainder_Expenses -12,239,000 -1,218,100 7,601,210 447,686,600 521,431,000 0001642380 0000744218 0001731348
11 remainder_Revenues 0 0 52,354,676 6,446,905,000 9,392,500,000 0000949858 0001590695 0000074303
12 remainder_NetIncome -123,314,000 -46,776,250 0 35,064,150 169,727,000 0001754195 0000744218 0001731348
13 remainder_ComprehensiveNetIncome -216,101,000 -117,605,000 0 6,255,550 21,000,000 0001731348 0001756390 0001627223
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 152,578 1,476,411 54,953,503 4,176,860,000 6,533,000,000 0001709542 0000787253 0001627223
1 Assets 17,139 1,551,125 161,210,340 7,902,730,000 11,171,300,000 0001709542 0001813814 0000037785
2 Expenses 344,732 2,007,934 104,260,991 5,863,460,000 8,067,800,000 0001086303 0000744218 0000074303
3 Revenues 0 0 52,354,676 6,446,905,000 9,392,500,000 0000949858 0001590695 0000074303
4 StockholdersEquity -144,098,000 -7,589,090 94,255,916 3,386,260,000 7,371,700,000 0001596946 0001850902 0000037785
5 NetIncome -474,186,000 -223,329,450 -4,525,502 643,707,850 1,326,900,000 0001652130 0001586554 0000074303
6 ComprehensiveNetIncome -542,182,500 -232,195,300 -4,846,622 639,481,450 1,322,950,000 0001731348 0000073290 0000074303
7 BaseVar 308,484 6,809,473 206,810,351 13,472,392,500 15,507,600,000 0001709542 0000885462 0000074303
8 EconomicCapitalRatio -8.00 -2.35 0.500 1.44 1.51 0001598308 0000074303 0001374328

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 LiabilitiesNoncurrent -1.13 -0.683 0.0512 0.313 0.463 0001598308 0000787253 0000896264
1 LiabilitiesCurrent -0.625 -0.268 0.239 0.676 6.31 0001590695 0001056358 0001598308
2 remainder_Liabilities -0.471 -0.443 0.0627 0.154 0.191 0001598308 0001653477 0000896264
3 AssetsCurrent -4.21 -0.631 -0.107 0.921 1.47 0001598308 0000073290 0000907654
4 AssetsNoncurrent -1.69 -0.358 -0.0418 0.304 2.02 0001598308 0000811641 0001321834
5 PropertyPlantAndEquipmentNet -2.08 -0.446 -0.0357 0.242 0.562 0001598308 0001374328 0001586554
6 Goodwill -2.24 -0.495 -0.0518 0.804 1.25 0001598308 0000907654 0001321834
7 remainder_Assets -0.651 -0.170 0.0361 0.209 1.38 0001321834 0000074303 0001709542
8 GeneralAndAdministrativeExpense -1.71 -0.995 -0.00623 0.425 1.22 0000073290 0001756390 0001598308
9 ResearchAndDevelopmentExpense -1.01 -0.569 0.110 0.315 0.363 0000949858 0001731348 0001056358
10 remainder_Expenses -4.54 -1.78 0.146 0.354 0.697 0001709542 0000907654 0000926617
11 remainder_Revenues -1.34 -0.596 0.0285 1.47 2.53 0001598308 0001708035 0001134765
12 remainder_NetIncome -1.06 -0.255 0.0525 0.137 0.180 0001598308 0001653477 0001134765
13 remainder_ComprehensiveNetIncome -0.0756 -0.0338 0.00402 0.0167 0.0639 0000885462 0001754195 0001086303
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.570 -0.444 0.242 0.924 1.59 0001586554 0001038133 0001598308
1 Assets -5.82 -1.23 -0.0353 0.597 0.677 0001598308 0001756390 0000744218
2 Expenses -3.28 -1.50 0.0935 0.413 0.540 0001709542 0001652130 0001642380
3 Revenues -1.34 -0.596 0.0285 1.47 2.53 0001598308 0001708035 0001134765
4 StockholdersEquity -2.89 -1.94 -0.0461 1.10 1.23 0001598308 0000896264 0001141240
5 NetIncome -5.36 -1.34 0.308 0.950 1.05 0001598308 0000073290 0000896264
6 ComprehensiveNetIncome -5.34 -1.33 0.313 0.948 1.05 0001598308 0000811641 0001134765
7 BaseVar nan nan nan nan nan 0000009326 0001086303 0000009326
8 EconomicCapitalRatio -7.95 -2.30 0.550 1.49 1.56 0001598308 0000074303 0001374328

Estimates

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