Ranks across the years
name | name_short | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2009-val | 2010-val | 2011-val | 2012-val | 2013-val | 2014-val | 2015-val | 2016-val | 2017-val | 2018-val | 2019-val | 2020-val | 2021-val | 2022-val | 2023-val | 2009->2010 | 2010->2011 | 2011->2012 | 2012->2013 | 2013->2014 | 2014->2015 | 2015->2016 | 2016->2017 | 2017->2018 | 2018->2019 | 2019->2020 | 2020->2021 | 2021->2022 | 2022->2023 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0000057515 | Lancaster Colony Corp | Lancast | NaN | 1 | 3 | 3 | 3 | 3 | 1 | 1 | 2 | 2 | 1 | 2 | 3 | 3 | 1 | NaN | 280.5050 | 276.3410 | 272.68100 | 278.4570 | 263.2970 | 273.85500 | 287.40500 | 280.8810 | 278.8020 | 269.4290 | 261.4530 | 245.1110 | 229.59000 | 236.9770 | NaN | 2 | 0 | 0 | 0 | -2 | 0 | 1 | 0 | -1 | 1 | 1 | 0 | -2 |
0000910329 | Medifast INC | Medifas | NaN | NaN | 8 | NaN | NaN | NaN | NaN | NaN | 1 | 4 | 7 | 6 | 8 | 6 | 2 | NaN | NaN | 200.9420 | NaN | NaN | NaN | NaN | NaN | 287.5970 | 230.6570 | 214.8750 | 217.1810 | 208.1080 | 214.01000 | 230.4540 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | 3 | -1 | 2 | -2 | -4 |
0000785956 | J J Snack Foods Corp | J J Sna | NaN | NaN | 5 | NaN | NaN | 8 | 3 | NaN | 5 | 3 | 3 | 7 | 5 | 4 | 3 | NaN | NaN | 242.8860 | NaN | NaN | 212.2660 | 242.76200 | NaN | 240.8950 | 251.5110 | 248.7530 | 216.6720 | 219.6940 | 215.34600 | 229.7080 | NaN | NaN | NaN | NaN | NaN | -5 | NaN | NaN | -2 | 0 | 4 | -2 | -1 | -1 |
0000814586 | Lifeway Foods Inc | Lifeway | NaN | NaN | 17 | 11 | 14 | 14 | 10 | 10 | 14 | 15 | 12 | 10 | NaN | 12 | 4 | NaN | NaN | 160.0570 | 192.84400 | 163.0140 | 157.4130 | 155.28100 | 175.37000 | 151.9490 | 143.8610 | 169.0200 | 192.3380 | NaN | 147.35800 | 205.9840 | NaN | NaN | -6 | 3 | 0 | -4 | 0 | 4 | 1 | -3 | -2 | NaN | NaN | -8 |
0000098677 | Tootsie Roll Industries INC | Tootsie | NaN | 4 | 14 | 12 | 11 | 10 | 9 | 7 | 9 | 11 | 9 | 9 | 10 | 8 | 5 | NaN | 194.5830 | 188.2310 | 190.91400 | 194.2930 | 189.6760 | 194.42800 | 196.40700 | 206.8170 | 199.1560 | 195.4110 | 192.6280 | 185.4920 | 194.11900 | 196.0440 | NaN | 10 | -2 | -1 | -1 | -1 | -2 | 2 | 2 | -2 | 0 | 1 | -2 | -3 |
0000880117 | Sanfilippo John B SON INC | Sanfili | NaN | NaN | NaN | 22 | NaN | 16 | NaN | NaN | NaN | NaN | 13 | 13 | 12 | 9 | 6 | NaN | NaN | NaN | 123.96100 | NaN | 129.1110 | NaN | NaN | NaN | NaN | 161.8910 | 150.3360 | 163.8560 | 167.43300 | 190.2860 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -1 | -3 | -3 |
0000100493 | Tyson Foods INC | Tyson F | NaN | 6 | 9 | 13 | NaN | NaN | NaN | 4 | 7 | 5 | 6 | 3 | 4 | 2 | 7 | NaN | 191.9290 | 198.7340 | 183.80600 | NaN | NaN | NaN | 242.04500 | 227.2050 | 228.5970 | 215.7080 | 235.5600 | 221.2650 | 234.93400 | 183.1470 | NaN | 3 | 4 | NaN | NaN | NaN | NaN | 3 | -2 | 1 | -3 | 1 | -2 | 5 |
0000014177 | Bridgford Foods Corp | Bridgfo | NaN | NaN | 33 | 41 | 16 | 35 | 13 | 19 | 15 | 14 | 18 | 18 | 21 | 1 | 8 | NaN | NaN | 73.7509 | 51.10130 | 132.4310 | 46.6837 | 131.47900 | 94.84120 | 149.1310 | 154.8950 | 108.4050 | 91.4394 | 84.2452 | 241.03500 | 179.1460 | NaN | NaN | 8 | -25 | 19 | -22 | 6 | -4 | -1 | 4 | 0 | 3 | -20 | 7 |
0000730349 | Tofutti Brands INC | Tofutti | NaN | NaN | 12 | 25 | 34 | 21 | NaN | 14 | 11 | 10 | 11 | NaN | NaN | 13 | 9 | NaN | NaN | 193.2650 | 111.48000 | 63.1220 | 102.7470 | NaN | 129.04400 | 182.1290 | 204.3000 | 172.5290 | NaN | NaN | 129.06700 | 161.5370 | NaN | NaN | 13 | 9 | -13 | NaN | NaN | -3 | -1 | 1 | NaN | NaN | NaN | -4 |
0000055067 | KELLANOVA | KELLANO | NaN | 2 | 15 | 17 | 9 | NaN | NaN | 11 | 12 | 13 | NaN | NaN | NaN | 11 | 10 | NaN | 217.1570 | 187.3050 | 168.35600 | 203.2070 | NaN | NaN | 160.34200 | 181.7180 | 186.2470 | NaN | NaN | NaN | 149.26500 | 154.7270 | NaN | 13 | 2 | -8 | NaN | NaN | NaN | 1 | 1 | NaN | NaN | NaN | NaN | -1 |
0001611647 | Freshpet Inc | Freshpe | NaN | NaN | NaN | NaN | NaN | 20 | 7 | 8 | 10 | 12 | 19 | 4 | 6 | 7 | 11 | NaN | NaN | NaN | NaN | NaN | 102.9790 | 218.60400 | 192.91400 | 199.0260 | 194.2290 | 102.9820 | 223.0920 | 215.9430 | 210.00900 | 123.9570 | NaN | NaN | NaN | NaN | NaN | -13 | 1 | 2 | 2 | 7 | -15 | 2 | 1 | 4 |
0000015357 | Chase General Corp | Chase G | NaN | NaN | NaN | 27 | 13 | 13 | 8 | 9 | 21 | 30 | 17 | 31 | 7 | 14 | 12 | NaN | NaN | NaN | 102.82300 | 176.3390 | 165.1050 | 208.20000 | 192.20900 | 117.7450 | 50.5144 | 129.3310 | 29.4886 | 212.2450 | 110.96000 | 123.3930 | NaN | NaN | NaN | -14 | 0 | -5 | 1 | 12 | 9 | -13 | 14 | -24 | 7 | -2 |
0001637459 | Kraft Heinz Co | Kraft H | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 17 | 17 | 16 | 13 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 92.3476 | 101.2660 | 106.44300 | 112.7150 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -1 | -3 |
0001046257 | Ingredion Inc | Ingredi | NaN | 7 | 11 | 9 | 8 | 9 | 6 | 6 | 6 | 9 | 5 | 16 | 19 | 18 | 14 | NaN | 188.5480 | 193.5060 | 198.34300 | 210.3110 | 209.8640 | 219.87500 | 224.25600 | 231.0090 | 218.8640 | 221.8160 | 92.8132 | 90.8559 | 89.73680 | 108.5390 | NaN | 4 | -2 | -1 | 1 | -3 | 0 | 0 | 3 | -4 | 11 | 3 | -1 | -4 |
0001007019 | Coffee Holding Co INC | Coffee | NaN | NaN | 25 | 20 | 19 | NaN | NaN | NaN | NaN | NaN | 16 | 12 | 15 | 22 | 15 | NaN | NaN | 113.7480 | 142.56400 | 126.1470 | NaN | NaN | NaN | NaN | NaN | 137.3640 | 150.4730 | 145.8620 | 78.15000 | 100.5660 | NaN | NaN | -5 | -1 | NaN | NaN | NaN | NaN | NaN | NaN | -4 | 3 | 7 | -7 |
0000047111 | Hershey Co | Hershey | 3 | 15 | 39 | 38 | 27 | 26 | 22 | 29 | 29 | 27 | 25 | 21 | 24 | 19 | 16 | 59.0401 | 61.5315 | 62.9127 | 66.35220 | 86.0017 | 78.7845 | 51.79010 | 51.37010 | 57.8695 | 61.7438 | 66.1644 | 70.7631 | 76.8212 | 85.18780 | 96.3127 | 12 | 24 | -1 | -11 | -1 | -4 | 7 | 0 | -2 | -2 | -4 | 3 | -5 | -3 |
0000091419 | J M Smucker Co | J M Smu | NaN | NaN | 20 | 23 | 18 | 18 | 20 | NaN | NaN | NaN | NaN | NaN | 16 | 17 | 17 | NaN | NaN | 144.4020 | 122.18600 | 126.1780 | 122.7440 | 77.18460 | NaN | NaN | NaN | NaN | NaN | 106.2990 | 103.74900 | 85.6929 | NaN | NaN | 3 | -5 | 0 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 0 |
0001103982 | Mondelez International Inc | Mondele | 2 | 13 | 36 | 34 | 25 | 30 | 16 | 24 | 26 | 22 | 23 | 20 | 20 | 24 | 18 | 81.7141 | 74.4091 | 68.8592 | 84.36360 | 92.7388 | 71.1842 | 103.55700 | 74.66740 | 85.9015 | 82.9356 | 89.8405 | 82.5808 | 89.9142 | 72.69840 | 85.5688 | 11 | 23 | -2 | -9 | 5 | -14 | 8 | 2 | -4 | 1 | -3 | 0 | 4 | -6 |
0000063754 | Mccormick Co INC | Mccormi | NaN | 9 | 27 | 30 | 23 | 24 | 19 | 23 | 31 | 26 | 24 | 22 | 27 | 25 | 19 | NaN | 102.7760 | 90.9926 | 95.45360 | 104.5410 | 90.5046 | 78.97120 | 81.05780 | 52.2044 | 71.7193 | 69.7099 | 68.7169 | 71.5049 | 72.03570 | 81.7830 | NaN | 18 | 3 | -7 | 1 | -5 | 4 | 8 | -5 | -2 | -2 | 5 | -2 | -6 |
0001856608 | Sovos Brands Inc | Sovos B | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 25 | 29 | 20 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 75.4899 | 58.35900 | 80.7355 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4 | -9 |
0000023217 | Conagra Brands INC | Conagra | NaN | 10 | 28 | 37 | 39 | 34 | 29 | 31 | 25 | 23 | 26 | 23 | 23 | 23 | 21 | NaN | 86.4864 | 90.3526 | 75.51260 | 50.9784 | 47.9109 | 36.36730 | 32.54820 | 87.1114 | 81.4562 | 62.5976 | 68.5879 | 81.5481 | 77.15200 | 75.7562 | NaN | 18 | 9 | 2 | -5 | -5 | 2 | -6 | -2 | 3 | -3 | 0 | 0 | -2 |
0000040704 | General Mills INC | General | NaN | 14 | 31 | 36 | 30 | 27 | 21 | 26 | 27 | 29 | 28 | 25 | 26 | 20 | 22 | NaN | 73.3053 | 83.0399 | 80.02260 | 80.9246 | 78.0378 | 52.39380 | 62.39070 | 60.5785 | 53.8304 | 54.5043 | 62.1036 | 73.3052 | 81.16500 | 75.3055 | NaN | 17 | 5 | -6 | -3 | -6 | 5 | 1 | 2 | -1 | -3 | 1 | -6 | 2 |
0001320695 | Treehouse Foods Inc | Treehou | NaN | 11 | 30 | 32 | 26 | 25 | 17 | 27 | 30 | 28 | NaN | 27 | 30 | 30 | 23 | NaN | 79.9076 | 88.1302 | 92.68890 | 90.9961 | 84.1789 | 97.62200 | 55.53310 | 54.2895 | 60.6395 | NaN | 56.8167 | 58.2341 | 57.34930 | 72.7923 | NaN | 19 | 2 | -6 | -1 | -8 | 10 | 3 | -2 | NaN | NaN | 3 | 0 | -7 |
0001679273 | Lamb Weston Holdings Inc | Lamb We | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 32 | 37 | 34 | 24 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 23.6579 | 35.1186 | 21.74860 | 69.0694 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | -3 | -10 |
0000910406 | Hain Celestial Group INC | Hain Ce | NaN | NaN | 21 | 21 | 21 | 19 | 14 | 17 | 20 | 18 | 22 | 15 | 13 | 21 | 25 | NaN | NaN | 143.7120 | 124.02000 | 111.5980 | 120.1770 | 119.78500 | 102.07900 | 117.8480 | 115.2400 | 89.8795 | 126.3710 | 161.9790 | 80.15720 | 67.5766 | NaN | NaN | 0 | 0 | -2 | -5 | 3 | 3 | -2 | 4 | -7 | -2 | 8 | 4 |
0000802481 | Pilgrims Pride Corp | Pilgrim | NaN | NaN | NaN | NaN | 17 | 7 | 15 | 21 | NaN | NaN | NaN | 26 | 35 | 26 | 26 | NaN | NaN | NaN | NaN | 131.6810 | 220.5470 | 114.23100 | 83.35300 | NaN | NaN | NaN | 60.7754 | 46.6778 | 65.48070 | 66.2971 | NaN | NaN | NaN | NaN | -10 | 8 | 6 | NaN | NaN | NaN | NaN | 9 | -9 | 0 |
0000016732 | Campbell Soup Co | Campbel | NaN | NaN | 40 | 42 | 41 | 33 | 27 | 30 | 28 | 32 | NaN | 24 | 29 | 28 | 27 | NaN | NaN | 50.1543 | 46.34170 | 36.5782 | 52.9894 | 39.80590 | 47.11270 | 60.0631 | 16.9198 | NaN | 64.0422 | 63.0100 | 59.76970 | 66.1953 | NaN | NaN | 2 | -1 | -8 | -6 | 3 | -2 | 4 | NaN | NaN | 5 | -1 | -1 |
0001530950 | Post Holdings Inc | Post Ho | NaN | NaN | NaN | 35 | 31 | 37 | 23 | 28 | 32 | 31 | 29 | 29 | 36 | 27 | 28 | NaN | NaN | NaN | 82.97980 | 76.4310 | 35.9983 | 48.36200 | 52.39090 | 37.3700 | 44.5847 | 40.0104 | 36.8122 | 42.5123 | 64.11340 | 61.7873 | NaN | NaN | NaN | -4 | 6 | -14 | 5 | 4 | -1 | -2 | 0 | 7 | -9 | 1 |
0001753706 | Whole Earth Brands Inc | Whole E | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 32 | 32 | 29 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 55.9286 | 33.57150 | 39.1314 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -3 |
0001278027 | B G Foods Inc | B G Foo | NaN | NaN | 41 | 40 | 40 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 33 | 30 | NaN | NaN | 38.3991 | 60.74160 | 48.9007 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 32.59590 | 33.1912 | NaN | NaN | -1 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -3 |
0001772016 | Bellring Brands INC | Bellrin | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 34 | 41 | 39 | 31 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -12.8776 | 7.7100 | -34.25520 | -10.8702 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 7 | -2 | -8 |
0001650696 | Laird Superfood Inc | Laird S | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11 | 2 | 46 | 32 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 191.0900 | 248.0770 | -285.47800 | -26.4864 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -9 | 44 | -14 |
0001830210 | Benson Hill Inc | Benson | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 40 | 36 | 33 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 18.8835 | -2.50683 | -50.9560 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -4 | -3 |
0001117057 | Planet Green Holdings Corp | Planet | NaN | NaN | 13 | 14 | 15 | 17 | NaN | 38 | 34 | 1 | 14 | NaN | 22 | 37 | 34 | NaN | NaN | 188.2750 | 182.56600 | 157.9830 | 127.0610 | NaN | -167.55000 | -239.2860 | 301.9710 | 153.3750 | NaN | 82.2280 | -5.65765 | -53.0345 | NaN | NaN | 1 | 1 | 2 | NaN | NaN | -4 | -33 | 13 | NaN | NaN | 15 | -3 |
0000034563 | Farmer Brothers Co | Farmer | NaN | NaN | NaN | 49 | NaN | 23 | 25 | 12 | 18 | 25 | 31 | 33 | 38 | 31 | 35 | NaN | NaN | NaN | -1.83584 | NaN | 94.6470 | 45.07430 | 155.84300 | 121.8290 | 75.5439 | 16.9501 | 18.1856 | 31.1909 | 39.37650 | -63.7533 | NaN | NaN | NaN | NaN | NaN | 2 | -13 | 6 | 7 | 6 | 2 | 5 | -7 | 4 |
0001005286 | Lifecore Biomedical INC De | Lifecor | NaN | NaN | NaN | NaN | NaN | NaN | 12 | 16 | 17 | 16 | 21 | 28 | 34 | 38 | 36 | NaN | NaN | NaN | NaN | NaN | NaN | 138.67300 | 111.53200 | 136.1690 | 142.3200 | 95.5882 | 54.3176 | 52.0736 | -23.21290 | -67.6820 | NaN | NaN | NaN | NaN | NaN | NaN | 4 | 1 | -1 | 5 | 7 | 6 | 4 | -2 |
0001800373 | Goldenwell Biotech INC | Goldenw | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 33 | NaN | 37 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 53.4754 | NaN | -69.5156 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001487197 | Barfresh Food Group INC | Barfres | NaN | NaN | NaN | 48 | 50 | 41 | 32 | 37 | 36 | 36 | 35 | 35 | 14 | 45 | 38 | NaN | NaN | NaN | 23.30900 | -586.9740 | -68.2546 | -20.29890 | -101.45100 | -386.7630 | -182.9910 | -192.7520 | -118.5270 | 150.4950 | -249.68400 | -70.2004 | NaN | NaN | NaN | 2 | -9 | -9 | 5 | -1 | 0 | -1 | 0 | -21 | 31 | -7 |
0001730773 | Blue Star Foods Corp | Blue St | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 33 | 32 | 36 | 31 | 47 | 39 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 10.4656 | -17.4615 | -118.7610 | 57.2453 | -316.82600 | -113.6390 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | 4 | -5 | 16 | -8 |
0001655210 | Beyond Meat INC | Beyond | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 10 | 14 | 42 | 40 | 40 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 190.9960 | 137.4190 | -15.4519 | -89.92020 | -136.2950 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4 | 28 | -2 | 0 |
0001409446 | Nate S Food Co | Nate S | NaN | NaN | NaN | NaN | NaN | NaN | 40 | 43 | 16 | 38 | NaN | NaN | 48 | 43 | 41 | NaN | NaN | NaN | NaN | NaN | NaN | -1190.52000 | -578.11000 | 140.5440 | -564.3340 | NaN | NaN | -278.3170 | -192.65900 | -292.1080 | NaN | NaN | NaN | NaN | NaN | NaN | 3 | -27 | 22 | NaN | NaN | NaN | -5 | -2 |
0001063537 | Ricebran Technologies | Ricebra | NaN | NaN | 44 | 50 | 44 | 42 | 33 | 36 | 24 | 24 | 27 | 30 | 39 | 35 | 42 | NaN | NaN | 22.9137 | -8.65764 | -44.8630 | -75.3732 | -38.38180 | -69.50350 | 90.3373 | 81.2018 | 56.9155 | 31.7747 | 29.2302 | 5.40086 | -376.8290 | NaN | NaN | 6 | -6 | -2 | -9 | 3 | -12 | 0 | 3 | 3 | 9 | -4 | 7 |
0001624517 | Yuenglings Ice Cream Corp | Yuengli | NaN | NaN | NaN | NaN | NaN | NaN | 39 | NaN | NaN | NaN | NaN | NaN | 47 | 50 | 43 | NaN | NaN | NaN | NaN | NaN | NaN | -827.63900 | NaN | NaN | NaN | NaN | NaN | -277.7340 | -343.74200 | -378.9470 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | -7 |
0001725911 | Netbrands Corp | Netbran | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 34 | 33 | 43 | 45 | 44 | 44 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -7.5842 | -106.1890 | -8645.0100 | -191.8020 | -242.38300 | -558.6870 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | 10 | 2 | -1 | 0 |
0001593001 | Nightfood Holdings Inc | Nightfo | NaN | NaN | NaN | NaN | NaN | NaN | 37 | 44 | 37 | 39 | 36 | 42 | 44 | 51 | 45 | NaN | NaN | NaN | NaN | NaN | NaN | -670.80500 | -811.81900 | -730.5420 | -981.3630 | -326.5220 | -482.7000 | -167.8110 | -690.83500 | -1088.9300 | NaN | NaN | NaN | NaN | NaN | NaN | 7 | -7 | 2 | -3 | 6 | 2 | 7 | -6 |
0000909954 | Keurig Green Mountain INC | Keurig | 1 | 3 | 7 | 4 | 6 | 6 | 4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 222.6890 | 212.1870 | 224.0750 | 241.59800 | 242.3980 | 233.5900 | 239.24900 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 4 | -3 | 2 | 0 | -2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000023666 | Hillshire Brands Co | Hillshi | NaN | 8 | 19 | 5 | 12 | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 162.9050 | 147.4570 | 239.15900 | 188.3650 | 171.6870 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11 | -14 | 7 | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000046640 | Kraft Heinz Foods Co | Kraft H | NaN | 16 | 34 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 49.3772 | 73.2839 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000931336 | Dean Foods Co | Dean Fo | NaN | 5 | 37 | 15 | 4 | 15 | 11 | 13 | 13 | 21 | 30 | NaN | NaN | NaN | NaN | NaN | 192.2680 | 67.9832 | 177.96700 | 254.4690 | 146.6650 | 144.92500 | 152.72100 | 165.7380 | 88.0134 | 30.9561 | NaN | NaN | NaN | NaN | NaN | 32 | -22 | -11 | 11 | -4 | 2 | 0 | 8 | 9 | NaN | NaN | NaN | NaN |
0001029506 | Ralcorp Holdings INC Mo | Ralcorp | NaN | 12 | 38 | 39 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 79.4780 | 63.1194 | 64.44070 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 26 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000042228 | Golden Enterprises INC | Golden | NaN | NaN | 26 | 26 | 24 | 22 | NaN | 15 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 106.0160 | 103.39600 | 98.2116 | 94.9068 | NaN | 124.03500 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -2 | -2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000057528 | Snyder S Lance INC | Snyder | NaN | NaN | 24 | 29 | 22 | NaN | NaN | 20 | 19 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 116.4130 | 100.07200 | 107.8290 | NaN | NaN | 88.49350 | 118.2630 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | -7 | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN | NaN | NaN |
0000076149 | Paradise INC | Paradis | NaN | NaN | 6 | NaN | 5 | 4 | 5 | 3 | 4 | 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 239.2700 | NaN | 251.3030 | 242.6290 | 232.34600 | 250.70400 | 245.9160 | 221.1170 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | 1 | -2 | 1 | 4 | NaN | NaN | NaN | NaN | NaN |
0000812128 | Sanderson Farms INC | Sanders | NaN | NaN | 16 | 6 | 7 | 2 | 2 | 2 | 3 | 6 | 4 | 5 | 1 | NaN | NaN | NaN | NaN | 163.7790 | 222.37600 | 241.3590 | 290.8970 | 273.81900 | 270.96300 | 276.5700 | 227.5960 | 224.2300 | 218.8940 | 280.3260 | NaN | NaN | NaN | NaN | -10 | 1 | -5 | 0 | 0 | 1 | 3 | -2 | 1 | -4 | NaN | NaN |
0000944508 | Inventure Foods INC | Inventu | NaN | NaN | 32 | 24 | 33 | 28 | 30 | 35 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 80.9590 | 120.99600 | 67.1997 | 75.3581 | 14.61630 | -18.27650 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -8 | 9 | -5 | 2 | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000949852 | Thanksgiving Coffee Co INC | Thanksg | NaN | NaN | 35 | NaN | NaN | NaN | NaN | 25 | 23 | 17 | 15 | NaN | NaN | NaN | NaN | NaN | NaN | 70.0485 | NaN | NaN | NaN | NaN | 73.79120 | 104.1840 | 116.9000 | 143.4780 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | -6 | -2 | NaN | NaN | NaN | NaN |
0001099977 | China Marine Food Group LTD | China M | NaN | NaN | 4 | 10 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 270.5010 | 197.97800 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001101020 | Overhill Farms INC | Overhil | NaN | NaN | 23 | 19 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 123.4980 | 149.97000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001128928 | Flowers Foods INC | Flowers | NaN | NaN | 18 | 18 | 1 | NaN | NaN | 5 | 8 | 7 | 8 | NaN | NaN | 5 | NaN | NaN | NaN | 153.9930 | 167.58600 | 695.9990 | NaN | NaN | 235.27700 | 222.2770 | 224.7540 | 213.2160 | NaN | NaN | 215.23100 | NaN | NaN | NaN | 0 | -17 | NaN | NaN | NaN | 3 | -1 | 1 | NaN | NaN | NaN | NaN |
0001273385 | Nutrastar International Inc | Nutrast | NaN | NaN | 1 | 2 | 2 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 338.0820 | 316.39400 | 328.9750 | 317.3050 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 0 | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001307701 | Cono Italiano Inc | Cono It | NaN | NaN | 47 | 52 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -843.1690 | -311.65700 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001331301 | Boulder Brands INC | Boulder | NaN | NaN | 22 | 31 | 29 | 40 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 126.4380 | 94.18950 | 84.2763 | 11.2856 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | -2 | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001368196 | Oriental Dragon Corp | Orienta | NaN | NaN | 2 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 327.4960 | 337.16100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001370544 | Smoky Market Foods INC | Smoky M | NaN | NaN | 46 | NaN | 48 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -462.1870 | NaN | -294.9900 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001420566 | Pinnacle Foods Finance LLC | Pinnacl | NaN | NaN | 43 | 46 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 26.1018 | 33.33060 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001421289 | Livewire Ergogenics Inc | Livewir | NaN | NaN | 45 | 54 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -378.8380 | -927.31100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001452011 | Tanke Biosciences Corp | Tanke B | NaN | NaN | 29 | 28 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 88.8508 | 102.04000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001452575 | Mead Johnson Nutrition Co | Mead Jo | NaN | NaN | 42 | 44 | 37 | 31 | 31 | 33 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 30.0347 | 40.35160 | 55.2050 | 65.3662 | 9.29929 | 9.99314 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | -7 | -6 | 0 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001467746 | Deyu Agriculture Corp | Deyu Ag | NaN | NaN | 10 | 8 | 36 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 193.8700 | 215.66500 | 61.1175 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | 28 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000088948 | Seneca Foods Corp | Seneca | NaN | NaN | NaN | 33 | NaN | NaN | 18 | 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 90.22310 | NaN | NaN | 79.23450 | 95.97450 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0000739608 | Penford Corp | Penford | NaN | NaN | NaN | 47 | 32 | 29 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 32.17370 | 70.8490 | 73.1967 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -15 | -3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001052257 | Agritech Worldwide Inc | Agritec | NaN | NaN | NaN | 53 | 51 | 44 | 41 | 41 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -389.68000 | -1040.5100 | -374.7740 | -1752.18000 | -411.40000 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | -7 | -3 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001058330 | Rogue One Inc | Rogue O | NaN | NaN | NaN | 55 | 49 | 45 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -3638.37000 | -528.7300 | -490.3810 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -6 | -4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001293593 | Synutra International Inc | Synutra | NaN | NaN | NaN | 43 | 43 | 38 | 24 | 32 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 42.98230 | -21.1908 | 28.6923 | 46.57520 | 30.86070 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -5 | -14 | 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001320947 | Diamond Foods Inc | Diamond | NaN | NaN | NaN | 16 | 20 | 12 | 26 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 170.46400 | 117.2900 | 168.5380 | 44.34430 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4 | -8 | 14 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001520358 | Mama S Creations Inc | Mama S | NaN | NaN | NaN | 51 | 42 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -48.03550 | -10.4605 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -9 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001545158 | Kraft Foods Group Inc | Kraft F | NaN | NaN | NaN | 45 | 35 | 36 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 37.98540 | 61.7202 | 38.7575 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -10 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001555365 | Whitewave Foods Co | Whitewa | NaN | NaN | NaN | 7 | 28 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 221.48800 | 85.1873 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 21 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001091983 | Forevergreen Worldwide Corp | Forever | NaN | NaN | NaN | NaN | 45 | 39 | 34 | 39 | 33 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -103.3050 | 14.2039 | -87.69660 | -236.21000 | -186.6970 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -6 | -5 | 5 | -6 | NaN | NaN | NaN | NaN | NaN | NaN |
0001431897 | Annie S Inc | Annie S | NaN | NaN | NaN | NaN | 10 | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 198.7950 | 240.9650 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001564822 | Pinnacle Foods INC | Pinnacl | NaN | NaN | NaN | NaN | 38 | 32 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 55.1140 | 64.8570 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001565383 | Lollipop Corp | Lollipo | NaN | NaN | NaN | NaN | 46 | 47 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -119.1920 | -1054.2100 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001568139 | Bio En Holdings Corp | Bio En | NaN | NaN | NaN | NaN | 47 | NaN | 35 | 40 | NaN | NaN | NaN | 40 | 49 | NaN | NaN | NaN | NaN | NaN | NaN | -225.0210 | NaN | -330.38100 | -310.14900 | NaN | NaN | NaN | -457.5700 | -289.4150 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN | 9 | NaN | NaN |
0001334586 | Jammin Java Corp | Jammin | NaN | NaN | NaN | NaN | NaN | 43 | 38 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -304.4220 | -719.46900 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001451433 | Nutranomics INC | Nutrano | NaN | NaN | NaN | NaN | NaN | 46 | 36 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -518.5440 | -384.53700 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -10 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001609989 | Blue Buffalo Pet Products Inc | Blue Bu | NaN | NaN | NaN | NaN | NaN | NaN | 28 | 22 | 22 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 39.26110 | 81.69720 | 115.9950 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -6 | 0 | NaN | NaN | NaN | NaN | NaN | NaN |
0000859747 | 1PM Industries | 1PM Ind | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 42 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -416.07500 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001137005 | Curative Biosciences INC | Curativ | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 45 | 35 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1375.36000 | -305.0590 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -10 | NaN | NaN | NaN | NaN | NaN | NaN |
0001669792 | Advancepierre Foods Holdings Inc | Advance | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 34 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -9.12327 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001563463 | Nutralife Biosciences INC | Nutrali | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 37 | NaN | 37 | 46 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -226.8250 | NaN | -123.5790 | -252.4980 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | NaN | NaN |
0001612188 | TEO Foods INC | TEO Foo | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 35 | 34 | 38 | 50 | 48 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -156.7430 | -113.0660 | -336.1670 | -332.6290 | -324.02300 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | 4 | 12 | -2 | NaN |
0001619055 | Coffeesmiths Collective INC | Coffees | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 19 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 110.2040 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001644406 | Hostess Brands Inc | Hostess | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 20 | 20 | 19 | 18 | 15 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 101.0780 | 99.3170 | 91.3948 | 99.6588 | 108.95300 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -1 | -1 | -3 | NaN |
0001572386 | Greenway Technologies INC | Greenwa | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 37 | 39 | 51 | 49 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -439.4250 | -391.0030 | -341.5620 | -329.19800 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 12 | -2 | NaN |
0001741231 | Tattooed Chef Inc | Tattooe | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 2 | 1 | 28 | 41 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 255.9650 | 308.6670 | 70.5274 | -107.18200 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | 27 | 13 | NaN |
0001563227 | Sipup Corp | Sipup C | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 41 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -465.9670 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001579733 | Vital Farms Inc | Vital F | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8 | 11 | 10 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 211.7950 | 185.0750 | 159.79800 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 3 | -1 | NaN |
0001616262 | Rocky Mountain Chocolate Factory Inc | Rocky M | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 187.3330 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001691936 | Stryve Foods INC | Stryve | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 43 | 42 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -155.8350 | -149.67400 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | NaN |
PDF reports
All reports for 2023 are collected in a single PDF for easier review.2009
Logs
warning | 1 × Missing logo | subcommand.report | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic |
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 | IntangibleAssets | 136,078,000 | 192,180,200 | 705,399,180 | 38,043,410,000 | 42,193,000,000 | 0000909954 | 0000047111 | 0001103982 |
1 | AssetsCurrent | 537,367,000 | 622,173,700 | 1,387,647,713 | 11,347,143,400 | 12,454,000,000 | 0000909954 | 0000047111 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 13,598,100 | 138,092,404 | 9,637,298,100 | 10,693,000,000 | 0000047111 | 0000909954 | 0001103982 |
3 | remainder_Assets | 3,979,000 | 140,981,100 | 1,374,043,699 | 1,570,647,300 | 1,592,497,000 | 0000909954 | 0001103982 | 0000047111 |
4 | LiabilitiesLongTerm | 0 | 200,406,400 | 2,007,695,587 | 18,346,206,400 | 20,162,000,000 | 0000909954 | 0000047111 | 0001103982 |
5 | LiabilitiesCurrent | 126,443,000 | 204,861,500 | 912,744,074 | 10,432,962,800 | 11,491,000,000 | 0000909954 | 0000047111 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 1,817,800 | 8,180,100,000 | 9,089,000,000 | 0000047111 | 0000909954 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 9,531 | 42,889,500 | 47,655,000 | 0000047111 | 0001103982 | 0000909954 |
8 | SellingAndMarketingExpense | 0 | 0 | 24,270 | 109,215,000 | 121,350,000 | 0000047111 | 0001103982 | 0000909954 |
9 | remainder_Expenses | 579,691,000 | 1,007,989,300 | 4,869,171,865 | 34,103,067,400 | 37,352,000,000 | 0000909954 | 0000047111 | 0001103982 |
10 | remainder_Revenues | 786,135,000 | 1,237,388,300 | 5,305,685,466 | 36,877,266,800 | 40,386,000,000 | 0000909954 | 0000047111 | 0001103982 |
11 | remainder_NetIncome | -6,000,000 | -5,400,000 | 3,400 | 15,300,000 | 17,000,000 | 0001103982 | 0000047111 | 0000909954 |
12 | remainder_ComprehensiveNetIncome | -1,451,000 | -1,305,900 | 414,600 | 1,865,700,000 | 2,073,000,000 | 0000909954 | 0000047111 | 0001103982 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 813,405,000 | 1,099,567,600 | 3,687,638,794 | 60,410,103,100 | 66,714,000,000 | 0000909954 | 0000047111 | 0001103982 |
1 | Liabilities | 126,443,000 | 405,267,900 | 2,922,257,462 | 36,959,269,200 | 40,742,000,000 | 0000909954 | 0000047111 | 0001103982 |
2 | Expenses | 748,696,000 | 1,160,093,800 | 4,869,171,865 | 34,103,067,400 | 37,352,000,000 | 0000909954 | 0000047111 | 0001103982 |
3 | Revenues | 786,135,000 | 1,237,388,300 | 5,305,685,466 | 36,877,266,800 | 40,386,000,000 | 0000909954 | 0000047111 | 0001103982 |
4 | StockholdersEquity | 686,962,000 | 694,299,700 | 765,381,332 | 23,450,833,900 | 25,972,000,000 | 0000909954 | 0000047111 | 0001103982 |
5 | NetIncome | 54,439,000 | 92,594,500 | 436,512,401 | 2,768,799,400 | 3,028,000,000 | 0000909954 | 0000047111 | 0001103982 |
6 | ComprehensiveNetIncome | 53,684,480 | 91,915,432 | 436,727,993 | 3,738,963,400 | 4,105,960,000 | 0000909954 | 0000047111 | 0001103982 |
7 | BaseVar | 2,093,103,690 | 3,275,139,710 | 13,938,108,550 | 124,814,434,889 | 137,136,765,000 | 0000909954 | 0000047111 | 0001103982 |
8 | EconomicCapitalRatio | 0.590 | 0.613 | 0.817 | 2.09 | 2.23 | 0000047111 | 0001103982 | 0000909954 |
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 | IntangibleAssets | -0.343 | -0.316 | -0.0712 | 0.456 | 0.514 | 0000047111 | 0000909954 | 0001103982 |
1 | AssetsCurrent | -0.201 | -0.194 | -0.132 | 0.127 | 0.156 | 0000047111 | 0001103982 | 0000909954 |
2 | PropertyPlantAndEquipment | -0.195 | -0.173 | 0.0198 | 0.0709 | 0.0766 | 0000047111 | 0000909954 | 0001103982 |
3 | remainder_Assets | -0.0749 | -0.0715 | -0.0405 | 0.341 | 0.384 | 0001103982 | 0000909954 | 0000047111 |
4 | LiabilitiesLongTerm | -0.365 | -0.352 | -0.241 | 0.767 | 0.879 | 0000047111 | 0001103982 | 0000909954 |
5 | LiabilitiesCurrent | -0.0639 | -0.0545 | 0.0307 | 0.0951 | 0.102 | 0001103982 | 0000047111 | 0000909954 |
6 | remainder_Liabilities | -0.211 | -0.175 | 0.148 | 0.224 | 0.232 | 0001103982 | 0000047111 | 0000909954 |
7 | GeneralAndAdministrativeExpense | -0.141 | -0.123 | 0.0405 | 0.0643 | 0.0670 | 0000909954 | 0001103982 | 0000047111 |
8 | SellingAndMarketingExpense | -0.360 | -0.314 | 0.103 | 0.164 | 0.171 | 0000909954 | 0001103982 | 0000047111 |
9 | remainder_Expenses | -0.440 | -0.382 | 0.145 | 0.204 | 0.211 | 0000047111 | 0001103982 | 0000909954 |
10 | remainder_Revenues | -0.298 | -0.244 | 0.235 | 0.266 | 0.269 | 0001103982 | 0000909954 | 0000047111 |
11 | remainder_NetIncome | -0.0238 | -0.0228 | -0.0146 | 0.0440 | 0.0505 | 0000047111 | 0001103982 | 0000909954 |
12 | remainder_ComprehensiveNetIncome | -0.0266 | -0.0262 | -0.0221 | 0.0235 | 0.0286 | 0000909954 | 0000047111 | 0001103982 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -0.418 | -0.375 | 0.01000 | 0.271 | 0.300 | 0000047111 | 0000909954 | 0001103982 |
1 | Liabilities | -0.566 | -0.524 | -0.149 | 0.976 | 1.10 | 0001103982 | 0000047111 | 0000909954 |
2 | Expenses | -0.290 | -0.281 | -0.203 | 0.240 | 0.289 | 0000909954 | 0000047111 | 0001103982 |
3 | Revenues | -0.298 | -0.244 | 0.235 | 0.266 | 0.269 | 0001103982 | 0000909954 | 0000047111 |
4 | StockholdersEquity | -0.782 | -0.704 | -0.00455 | 0.749 | 0.833 | 0000047111 | 0001103982 | 0000909954 |
5 | NetIncome | -0.0234 | -0.0215 | -0.00433 | 0.0382 | 0.0429 | 0001103982 | 0000909954 | 0000047111 |
6 | ComprehensiveNetIncome | -0.0310 | -0.0274 | 0.00515 | 0.0193 | 0.0208 | 0000909954 | 0001103982 | 0000047111 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000047111 | 0000909954 | 0000047111 |
8 | EconomicCapitalRatio | -0.621 | -0.598 | -0.394 | 0.874 | 1.02 | 0000047111 | 0001103982 | 0000909954 |
2010
Logs
warning | 9 × No stock price available | subcommand.plot | |
warning | 4 × Missing logo | subcommand.report | |
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic |
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 | IntangibleAssets | 73,237,000 | 85,689,250 | 1,912,441,000 | 23,685,600,000 | 63,819,000,000 | 0000098677 | 0000100493 | 0001103982 |
1 | AssetsCurrent | 237,591,000 | 297,447,000 | 1,911,000,002 | 7,518,750,000 | 16,221,000,000 | 0000098677 | 0000047111 | 0001103982 |
2 | PropertyPlantAndEquipment | 166,097,000 | 203,143,250 | 2,080,930,694 | 6,203,500,000 | 13,792,000,000 | 0000057515 | 0000046640 | 0001103982 |
3 | remainder_Assets | 9,961,000 | 12,328,000 | 367,631,906 | 1,633,218,000 | 2,161,872,000 | 0000909954 | 0000100493 | 0000046640 |
4 | LiabilitiesLongTerm | 0 | 0 | 509,025,008 | 13,109,150,000 | 30,275,000,000 | 0000023666 | 0001320695 | 0001103982 |
5 | LiabilitiesCurrent | 58,505,000 | 73,091,000 | 1,370,118,180 | 6,741,825,000 | 15,660,000,000 | 0000098677 | 0000931336 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 66,661,386 | 5,776,700,000 | 13,412,000,000 | 0000023666 | 0000098677 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 237,758,500 | 629,656,000 | 0000023217 | 0000098677 | 0000931336 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 615,945,000 | 1,904,526,000 | 0000023217 | 0000098677 | 0000931336 |
9 | remainder_Expenses | 476,092,000 | 825,956,500 | 7,218,008,440 | 32,160,500,000 | 46,706,000,000 | 0000098677 | 0000931336 | 0001103982 |
10 | remainder_Revenues | 521,448,000 | 922,818,000 | 8,090,231,961 | 33,624,250,000 | 49,207,000,000 | 0000098677 | 0000046640 | 0001103982 |
11 | remainder_NetIncome | -353,000,000 | -270,834,500 | 0 | 485,775,000 | 1,638,000,000 | 0000100493 | 0001046257 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -179,100,000 | -44,775,000 | 0 | 28,637,250 | 111,000,000 | 0000023217 | 0000100493 | 0001046257 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 586,453,000 | 791,900,500 | 7,382,511,150 | 37,081,425,000 | 95,289,000,000 | 0000057515 | 0000931336 | 0001103982 |
1 | Liabilities | 77,953,000 | 163,060,000 | 2,416,885,500 | 23,859,925,000 | 59,347,000,000 | 0000057515 | 0000100493 | 0001103982 |
2 | Expenses | 476,092,000 | 825,956,500 | 7,382,238,155 | 32,160,500,000 | 46,706,000,000 | 0000098677 | 0000046640 | 0001103982 |
3 | Revenues | 521,448,000 | 922,818,000 | 8,090,231,961 | 33,624,250,000 | 49,207,000,000 | 0000098677 | 0000046640 | 0001103982 |
4 | StockholdersEquity | 508,500,000 | 628,840,500 | 3,386,266,200 | 15,669,500,000 | 35,942,000,000 | 0000057515 | 0001046257 | 0001103982 |
5 | NetIncome | 53,714,000 | 73,058,000 | 440,208,898 | 2,186,000,000 | 4,139,000,000 | 0000098677 | 0000047111 | 0001103982 |
6 | ComprehensiveNetIncome | 54,329,160 | 73,305,390 | 440,208,898 | 2,186,000,000 | 4,139,000,000 | 0000098677 | 0000047111 | 0001103982 |
7 | BaseVar | 1,578,305,645 | 2,211,326,630 | 21,517,893,179 | 93,765,530,000 | 179,258,795,000 | 0000098677 | 0000023666 | 0001103982 |
8 | EconomicCapitalRatio | 0.494 | 0.585 | 1.33 | 2.33 | 2.81 | 0000046640 | 0000023666 | 0000057515 |
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 | IntangibleAssets | -0.360 | -0.307 | -0.0173 | 0.634 | 0.635 | 0000047111 | 0000055067 | 0001029506 |
1 | AssetsCurrent | -0.116 | -0.104 | -0.0117 | 0.0972 | 0.121 | 0000100493 | 0000057515 | 0000047111 |
2 | PropertyPlantAndEquipment | -0.0967 | -0.0909 | -0.0200 | 0.0943 | 0.180 | 0000100493 | 0001103982 | 0001046257 |
3 | remainder_Assets | -0.0871 | -0.0790 | -0.0279 | 0.193 | 0.288 | 0000100493 | 0001046257 | 0000098677 |
4 | LiabilitiesLongTerm | -0.661 | -0.644 | 0.321 | 1.19 | 1.23 | 0001320695 | 0000098677 | 0000100493 |
5 | LiabilitiesCurrent | -0.381 | -0.224 | -0.0357 | 0.529 | 0.579 | 0000023666 | 0000909954 | 0000057515 |
6 | remainder_Liabilities | -0.524 | -0.469 | 0.105 | 0.481 | 0.516 | 0000023217 | 0000063754 | 0000100493 |
7 | GeneralAndAdministrativeExpense | -0.223 | -0.222 | 0.0303 | 0.0708 | 0.0877 | 0000931336 | 0000063754 | 0000100493 |
8 | SellingAndMarketingExpense | -0.733 | -0.487 | 0.0609 | 0.142 | 0.176 | 0000931336 | 0000063754 | 0000100493 |
9 | remainder_Expenses | -1.93 | -1.23 | 0.0321 | 0.401 | 0.423 | 0000100493 | 0000046640 | 0000909954 |
10 | remainder_Revenues | -0.425 | -0.365 | -0.0301 | 1.22 | 1.50 | 0001103982 | 0001046257 | 0000100493 |
11 | remainder_NetIncome | -0.110 | -0.108 | 0.000297 | 0.0362 | 0.0444 | 0000100493 | 0000909954 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -0.0222 | -0.00787 | -0.00109 | 0.0105 | 0.0377 | 0000023217 | 0000909954 | 0001046257 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -0.399 | -0.327 | 0.0114 | 0.406 | 0.465 | 0000100493 | 0000909954 | 0001103982 |
1 | Liabilities | -0.835 | -0.723 | 0.00968 | 1.77 | 1.79 | 0001103982 | 0000098677 | 0000057515 |
2 | Expenses | -1.67 | -1.01 | -0.00761 | 0.312 | 0.371 | 0000100493 | 0000023217 | 0001103982 |
3 | Revenues | -0.425 | -0.365 | -0.0301 | 1.22 | 1.50 | 0001103982 | 0001046257 | 0000100493 |
4 | StockholdersEquity | -1.04 | -0.834 | 0.00188 | 0.742 | 0.899 | 0000100493 | 0001029506 | 0000098677 |
5 | NetIncome | -0.299 | -0.282 | -0.0181 | 0.180 | 0.340 | 0000931336 | 0001103982 | 0000057515 |
6 | ComprehensiveNetIncome | -0.301 | -0.285 | -0.0190 | 0.178 | 0.337 | 0000931336 | 0001103982 | 0000057515 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000023217 | 0000098677 | 0000023217 |
8 | EconomicCapitalRatio | -0.911 | -0.820 | -0.0753 | 0.925 | 1.40 | 0000046640 | 0000023666 | 0000057515 |
2011
Logs
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 26 × No stock price available | subcommand.plot | |
warning | 18 × Missing logo | subcommand.report | |
warning | 5 × Similarly named company. Duplicate? | None | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.5831259413120415}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic |
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 | IntangibleAssets | 0 | 0 | 122,475,315 | 5,550,029,200 | 62,483,000,000 | 0000014177 | 0000785956 | 0001103982 |
1 | AssetsCurrent | 32,937 | 315,731 | 260,187,392 | 4,379,400,000 | 16,202,000,000 | 0001307701 | 0000785956 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 5,779 | 124,928,907 | 3,326,430,000 | 13,813,000,000 | 0001467746 | 0000785956 | 0001103982 |
3 | remainder_Assets | 0 | 165 | 23,298,561 | 1,650,052,700 | 2,673,579,000 | 0001307701 | 0001320695 | 0000046640 |
4 | LiabilitiesLongTerm | 0 | 0 | 0 | 3,577,089,300 | 26,491,000,000 | 0000014177 | 0001467746 | 0001103982 |
5 | LiabilitiesCurrent | 37,138 | 730,466 | 75,849,417 | 3,983,160,000 | 18,445,000,000 | 0001421289 | 0000785956 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 8,671,718 | 1,179,153,800 | 13,573,000,000 | 0000023666 | 0000910329 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 161,456,300 | 612,000,000 | 0000014177 | 0000047111 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 455,798,800 | 1,963,748,000 | 0000014177 | 0000055067 | 0000931336 |
9 | remainder_Expenses | 260,858 | 2,460,907 | 545,529,372 | 12,820,750,000 | 50,818,000,000 | 0001421289 | 0000785956 | 0001103982 |
10 | remainder_Revenues | 0 | 144,498 | 745,662,025 | 14,375,540,000 | 54,365,000,000 | 0001467746 | 0000785956 | 0001103982 |
11 | remainder_NetIncome | -247,420,000 | -117,559,000 | 0 | 35,092,764 | 935,000,000 | 0000931336 | 0001103982 | 0000023666 |
12 | remainder_ComprehensiveNetIncome | -2,767,000,000 | -58,720,100 | 0 | 4,146,441 | 60,800,000 | 0001103982 | 0000910329 | 0000023217 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 37,274 | 494,722 | 858,273,059 | 12,131,751,500 | 93,837,000,000 | 0001370544 | 0000098677 | 0001103982 |
1 | Liabilities | 749,745 | 1,035,116 | 191,958,237 | 8,256,517,000 | 58,509,000,000 | 0000949852 | 0000098677 | 0001103982 |
2 | Expenses | 795,286 | 2,882,199 | 545,529,372 | 14,037,320,800 | 50,818,000,000 | 0001421289 | 0000785956 | 0001103982 |
3 | Revenues | 0 | 144,498 | 745,662,025 | 14,375,540,000 | 54,365,000,000 | 0001467746 | 0000785956 | 0001103982 |
4 | StockholdersEquity | -168,000,000 | -961,941 | 475,294,439 | 7,995,260,000 | 35,328,000,000 | 0001452575 | 0000785956 | 0001103982 |
5 | NetIncome | -1,592,171,000 | -103,028,100 | 21,142,087 | 1,478,520,800 | 3,547,000,000 | 0000931336 | 0001117057 | 0001103982 |
6 | ComprehensiveNetIncome | -1,592,171,000 | -103,028,100 | 24,231,087 | 1,478,520,800 | 2,108,160,000 | 0000931336 | 0001117057 | 0001103982 |
7 | BaseVar | 1,749,338 | 5,984,244 | 2,120,783,122 | 41,576,929,750 | 188,980,750,000 | 0001421289 | 0001278027 | 0001103982 |
8 | EconomicCapitalRatio | -8.43 | -2.58 | 1.16 | 2.75 | 3.38 | 0001307701 | 0000057528 | 0001273385 |
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 | IntangibleAssets | -1.96 | -0.682 | -0.0694 | 0.801 | 1.44 | 0001307701 | 0001467746 | 0001331301 |
1 | AssetsCurrent | -2.34 | -0.775 | -0.105 | 0.238 | 0.715 | 0001307701 | 0000814586 | 0001452011 |
2 | PropertyPlantAndEquipment | -0.647 | -0.427 | -0.000877 | 0.161 | 0.782 | 0001421289 | 0000076149 | 0001063537 |
3 | remainder_Assets | -0.644 | -0.248 | -0.0434 | 0.269 | 0.572 | 0001307701 | 0001331301 | 0001420566 |
4 | LiabilitiesLongTerm | -1.33 | -0.775 | 0.345 | 0.920 | 1.08 | 0001278027 | 0000098677 | 0000730349 |
5 | LiabilitiesCurrent | -0.949 | -0.373 | 0.0908 | 0.664 | 0.802 | 0000023666 | 0001278027 | 0000730349 |
6 | remainder_Liabilities | -0.898 | -0.149 | 0.362 | 2.24 | 8.76 | 0001467746 | 0000047111 | 0001307701 |
7 | GeneralAndAdministrativeExpense | -3.40 | -0.557 | 0.151 | 0.487 | 0.566 | 0001307701 | 0001063537 | 0001007019 |
8 | SellingAndMarketingExpense | -0.933 | -0.618 | 0.0821 | 0.277 | 0.322 | 0001307701 | 0000098677 | 0001007019 |
9 | remainder_Expenses | -2.92 | -2.36 | -0.0319 | 0.849 | 1.26 | 0001007019 | 0001029506 | 0001421289 |
10 | remainder_Revenues | -3.00 | -1.24 | 0.207 | 2.14 | 2.41 | 0001307701 | 0000909954 | 0001007019 |
11 | remainder_NetIncome | -1.01 | -0.185 | -0.0293 | 0.198 | 1.16 | 0000785956 | 0001307701 | 0001467746 |
12 | remainder_ComprehensiveNetIncome | -0.0864 | -0.0346 | -0.00306 | 0.0495 | 0.0780 | 0001128928 | 0000076149 | 0001273385 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -4.09 | -1.56 | 0.00565 | 0.573 | 0.640 | 0001307701 | 0001046257 | 0001278027 |
1 | Liabilities | -1.08 | -0.755 | 0.614 | 2.12 | 8.46 | 0001278027 | 0000014177 | 0001370544 |
2 | Expenses | -3.31 | -1.84 | 0.0320 | 0.634 | 0.883 | 0001307701 | 0000055067 | 0001273385 |
3 | Revenues | -3.00 | -1.24 | 0.207 | 2.14 | 2.41 | 0001307701 | 0000909954 | 0001007019 |
4 | StockholdersEquity | -3.08 | -2.47 | 0.0829 | 1.31 | 1.91 | 0001370544 | 0001029506 | 0001273385 |
5 | NetIncome | -6.33 | -1.33 | 0.274 | 0.764 | 1.04 | 0001307701 | 0000814586 | 0001368196 |
6 | ComprehensiveNetIncome | -6.34 | -1.34 | 0.272 | 0.759 | 1.04 | 0001307701 | 0000814586 | 0001368196 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000931336 | 0000014177 |
8 | EconomicCapitalRatio | -9.38 | -3.53 | 0.218 | 1.80 | 2.43 | 0001307701 | 0000057528 | 0001273385 |
2012
Logs
error | 3 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 30 × No stock price available | subcommand.plot |
0001331301
0001278027
0000944508
0000023666
0000042228
0000739608
0000909954
0001029506
0001052257
0001058330
0001099977
0001101020
0001273385
0001307701
0001320947
0001368196
0001420566
0001452011
0001467746
0001520358
0001545158
0001555365
0000055067
0000057528
0000931336
0001293593
0001452575
0000015357
0000088948
0000812128
|
warning | 23 × Missing logo | subcommand.report | |
warning | 5 × Similarly named company. Duplicate? | None | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.350636646357116}
|
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
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 | IntangibleAssets | 0 | 0 | 89,948,125 | 8,592,200,000 | 48,353,000,000 | 0000014177 | 0000057515 | 0001103982 |
1 | AssetsCurrent | 338 | 359,606 | 209,956,192 | 4,030,880,000 | 15,622,000,000 | 0001058330 | 0001530950 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 10,423 | 146,952,267 | 3,854,000,000 | 10,010,000,000 | 0000730349 | 0001320947 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 18,839,252 | 1,053,610,000 | 2,956,000,000 | 0000015357 | 0000814586 | 0001545158 |
4 | LiabilitiesLongTerm | 0 | 0 | 4,280 | 4,790,310,000 | 18,612,000,000 | 0000014177 | 0000100493 | 0001103982 |
5 | LiabilitiesCurrent | 0 | 147,684 | 118,176,311 | 3,677,160,000 | 14,873,000,000 | 0001307701 | 0000088948 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 7,990,503 | 1,703,930,400 | 9,638,000,000 | 0000023666 | 0000814586 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 183,019,500 | 611,000,000 | 0000014177 | 0000055067 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 510,331,000 | 1,912,588,000 | 0000014177 | 0000088948 | 0000931336 |
9 | remainder_Expenses | 2,181 | 1,713,885 | 604,274,452 | 15,631,300,000 | 33,555,000,000 | 0001487197 | 0000880117 | 0001103982 |
10 | remainder_Revenues | 0 | 140,519 | 701,969,955 | 17,162,230,000 | 35,015,000,000 | 0001487197 | 0000880117 | 0001103982 |
11 | remainder_NetIncome | -321,000,000 | -74,170,700 | 0 | 51,420,000 | 1,595,000,000 | 0000100493 | 0001530950 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -331,000,000 | -77,000,000 | 0 | 6,444,000 | 75,000,000 | 0001103982 | 0000057515 | 0000055067 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 2,866 | 538,181 | 738,622,985 | 16,957,840,000 | 75,478,000,000 | 0001058330 | 0000088948 | 0001103982 |
1 | Liabilities | 22,676 | 624,495 | 217,181,038 | 8,844,020,000 | 43,123,000,000 | 0001487197 | 0001320947 | 0001103982 |
2 | Expenses | 345,880 | 2,685,004 | 677,955,415 | 15,631,300,000 | 33,555,000,000 | 0001487197 | 0000880117 | 0001103982 |
3 | Revenues | 0 | 140,519 | 701,969,955 | 17,162,230,000 | 35,015,000,000 | 0001487197 | 0000880117 | 0001103982 |
4 | StockholdersEquity | -4,032,784 | -731,027 | 354,708,111 | 8,131,150,000 | 32,355,000,000 | 0001052257 | 0000088948 | 0001103982 |
5 | NetIncome | -86,336,000 | -10,049,429 | 45,987,847 | 1,142,890,000 | 3,055,000,000 | 0001320947 | 0001368196 | 0001103982 |
6 | ComprehensiveNetIncome | -86,336,000 | -11,527,004 | 39,020,568 | 1,170,190,000 | 2,882,880,000 | 0001320947 | 0001530950 | 0001103982 |
7 | BaseVar | 676,924 | 4,979,472 | 2,276,829,968 | 52,886,371,950 | 132,968,820,000 | 0001487197 | 0001278027 | 0001103982 |
8 | EconomicCapitalRatio | -36.4 | -3.35 | 1.02 | 2.51 | 3.37 | 0001058330 | 0001452011 | 0001368196 |
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 | IntangibleAssets | -18.7 | -0.873 | -0.167 | 0.861 | 1.25 | 0001058330 | 0001467746 | 0001331301 |
1 | AssetsCurrent | -21.0 | -0.539 | -0.105 | 0.464 | 2.86 | 0001058330 | 0001320695 | 0001487197 |
2 | PropertyPlantAndEquipment | -15.7 | -0.554 | -0.00127 | 0.323 | 0.844 | 0001058330 | 0000023217 | 0001063537 |
3 | remainder_Assets | -6.38 | -0.200 | -0.0262 | 0.147 | 0.586 | 0001058330 | 0001099977 | 0001420566 |
4 | LiabilitiesLongTerm | -11.4 | -0.908 | 0.319 | 0.988 | 1.23 | 0001058330 | 0001117057 | 0001007019 |
5 | LiabilitiesCurrent | -0.926 | -0.568 | 0.117 | 0.866 | 23.6 | 0001421289 | 0001273385 | 0001058330 |
6 | remainder_Liabilities | -9.86 | -0.254 | 0.228 | 0.982 | 29.1 | 0001058330 | 0001467746 | 0001421289 |
7 | GeneralAndAdministrativeExpense | -6.15 | -1.01 | 0.245 | 0.777 | 1.34 | 0001421289 | 0001063537 | 0001058330 |
8 | SellingAndMarketingExpense | -1.20 | -0.752 | 0.112 | 0.397 | 0.683 | 0000034563 | 0000040704 | 0001058330 |
9 | remainder_Expenses | -13.0 | -2.42 | -0.0551 | 0.895 | 2.63 | 0001058330 | 0000910406 | 0001421289 |
10 | remainder_Revenues | -12.5 | -1.56 | 0.204 | 2.16 | 3.44 | 0001058330 | 0000023217 | 0001007019 |
11 | remainder_NetIncome | -8.69 | -0.0599 | 0.0645 | 0.155 | 1.16 | 0001058330 | 0000098677 | 0000023666 |
12 | remainder_ComprehensiveNetIncome | -0.161 | -0.0350 | 0.00705 | 0.0205 | 0.0337 | 0000014177 | 0001421289 | 0001063537 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -29.2 | -0.869 | -0.0877 | 0.629 | 3.92 | 0001058330 | 0000023666 | 0001487197 |
1 | Liabilities | -11.5 | -0.933 | 0.436 | 1.90 | 6.73 | 0001058330 | 0000088948 | 0001421289 |
2 | Expenses | -11.0 | -2.08 | 0.00754 | 0.549 | 0.858 | 0001058330 | 0000023666 | 0001273385 |
3 | Revenues | -12.5 | -1.56 | 0.204 | 2.16 | 3.44 | 0001058330 | 0000023217 | 0001007019 |
4 | StockholdersEquity | -6.61 | -2.04 | -0.133 | 1.21 | 2.06 | 0001058330 | 0000023666 | 0001487197 |
5 | NetIncome | -32.2 | -2.33 | 0.459 | 1.20 | 1.62 | 0001058330 | 0000098677 | 0000023666 |
6 | ComprehensiveNetIncome | -32.2 | -2.33 | 0.470 | 1.22 | 1.60 | 0001058330 | 0000098677 | 0000023666 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001029506 | 0000014177 |
8 | EconomicCapitalRatio | -36.6 | -3.55 | 0.826 | 2.31 | 3.18 | 0001058330 | 0001452011 | 0001368196 |
2013
Logs
error | 6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 5 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 29 × No stock price available | subcommand.plot |
0001278027
0000944508
0000023666
0000042228
0000739608
0000909954
0001052257
0001058330
0001273385
0001320947
0001331301
0001370544
0001431897
0001467746
0001520358
0001545158
0001555365
0001564822
0001565383
0001568139
0000055067
0000057528
0000931336
0001293593
0001452575
0000015357
0000076149
0000812128
0001091983
|
warning | 20 × Missing logo | subcommand.report | |
warning | 5 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 4 × Similarly named company. Duplicate? | None | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -4.118597663247636}
|
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg | |
warning | 1 × Ignoring company because Assets is zero | pre-agg |
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 | IntangibleAssets | 0 | 0 | 73,305,020 | 11,688,900,000 | 47,591,000,000 | 0000014177 | 0000098677 | 0001103982 |
1 | AssetsCurrent | 0 | 17,232 | 240,342,720 | 4,339,350,000 | 13,216,000,000 | 0001565383 | 0000098677 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 132,512,350 | 3,868,650,000 | 10,247,000,000 | 0000730349 | 0001320947 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 22,286,385 | 1,218,000,000 | 2,620,000,000 | 0000015357 | 0000057528 | 0001545158 |
4 | LiabilitiesLongTerm | 0 | 0 | 935,006 | 5,599,500,000 | 16,973,000,000 | 0000014177 | 0001431897 | 0001103982 |
5 | LiabilitiesCurrent | 0 | 294,012 | 105,915,430 | 3,622,500,000 | 14,396,000,000 | 0001565383 | 0001278027 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 8,088,387 | 2,768,050,000 | 8,886,900,000 | 0000023666 | 0001117057 | 0000023217 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 245,627,500 | 677,000,000 | 0000014177 | 0000057515 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 602,765,000 | 1,337,745,000 | 0000014177 | 0000812128 | 0000931336 |
9 | remainder_Expenses | 0 | 139,330 | 495,397,375 | 15,122,900,000 | 31,418,000,000 | 0001370544 | 0000098677 | 0001103982 |
10 | remainder_Revenues | 0 | 1,643 | 725,668,195 | 16,632,750,000 | 35,299,000,000 | 0001565383 | 0001278027 | 0001103982 |
11 | remainder_NetIncome | -221,000,000 | -70,805,000 | 0 | 57,750,000 | 646,236,000 | 0000016732 | 0001128928 | 0000931336 |
12 | remainder_ComprehensiveNetIncome | -243,000,000 | -34,628,000 | 0 | 158,250,000 | 283,046,000 | 0001103982 | 0000076149 | 0001128928 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 1,128 | 33,254 | 888,590,180 | 21,531,650,000 | 72,557,000,000 | 0001370544 | 0000098677 | 0001103982 |
1 | Liabilities | 2,229 | 500,452 | 291,287,595 | 14,802,150,000 | 40,025,000,000 | 0001565383 | 0001320947 | 0001103982 |
2 | Expenses | 26,431 | 478,177 | 495,397,375 | 15,122,900,000 | 31,418,000,000 | 0001565383 | 0000098677 | 0001103982 |
3 | Revenues | 0 | 1,643 | 725,668,195 | 16,632,750,000 | 35,299,000,000 | 0001565383 | 0001278027 | 0001103982 |
4 | StockholdersEquity | -5,364,509 | -497,282 | 379,185,120 | 6,729,500,000 | 32,532,000,000 | 0001370544 | 0001278027 | 0001103982 |
5 | NetIncome | -163,232,000 | -21,991,968 | 22,321,233 | 2,285,100,000 | 3,935,000,000 | 0001320947 | 0001273385 | 0001103982 |
6 | ComprehensiveNetIncome | -163,213,800 | -21,053,803 | 23,952,503 | 2,316,144,000 | 3,808,640,000 | 0001320947 | 0001273385 | 0001103982 |
7 | BaseVar | 43,291 | 2,022,648 | 2,675,419,842 | 51,782,930,250 | 126,320,630,000 | 0001565383 | 0000057515 | 0001103982 |
8 | EconomicCapitalRatio | -10.4 | -4.12 | 0.910 | 2.66 | 6.96 | 0001052257 | 0001320695 | 0001128928 |
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 | IntangibleAssets | -3.98 | -1.04 | -0.0810 | 0.931 | 1.14 | 0001052257 | 0000944508 | 0001278027 |
1 | AssetsCurrent | -1.86 | -0.832 | -0.0613 | 0.360 | 0.829 | 0001052257 | 0001320695 | 0001520358 |
2 | PropertyPlantAndEquipment | -0.773 | -0.608 | -0.000603 | 0.453 | 1.55 | 0001091983 | 0000057515 | 0001052257 |
3 | remainder_Assets | -0.922 | -0.482 | -0.0819 | 0.415 | 24.8 | 0001052257 | 0001331301 | 0001565383 |
4 | LiabilitiesLongTerm | -1.59 | -0.977 | 0.0280 | 1.16 | 1.41 | 0001052257 | 0000023217 | 0000931336 |
5 | LiabilitiesCurrent | -1.40 | -0.336 | 0.261 | 1.21 | 15.8 | 0001052257 | 0000023666 | 0001058330 |
6 | remainder_Liabilities | -1.41 | -0.211 | 0.257 | 0.987 | 1.26 | 0001052257 | 0000944508 | 0000931336 |
7 | GeneralAndAdministrativeExpense | -4.82 | -1.14 | 0.171 | 0.530 | 0.862 | 0001487197 | 0000091419 | 0001007019 |
8 | SellingAndMarketingExpense | -3.33 | -0.842 | 0.0956 | 0.296 | 0.480 | 0001091983 | 0000091419 | 0001007019 |
9 | remainder_Expenses | -3.91 | -2.28 | 0.0216 | 1.45 | 3.71 | 0001007019 | 0000910406 | 0001091983 |
10 | remainder_Revenues | -4.44 | -1.85 | 0.262 | 2.54 | 3.47 | 0001052257 | 0000057528 | 0001007019 |
11 | remainder_NetIncome | -4.27 | -0.0707 | 0.0493 | 0.160 | 0.905 | 0001052257 | 0001128928 | 0000931336 |
12 | remainder_ComprehensiveNetIncome | -0.0575 | -0.0397 | -0.0126 | 0.0446 | 0.227 | 0001046257 | 0001320947 | 0000014177 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -4.77 | -1.69 | -0.0247 | 0.825 | 3.41 | 0001052257 | 0001046257 | 0001565383 |
1 | Liabilities | -3.19 | -0.777 | 0.493 | 2.38 | 6.71 | 0001052257 | 0001487197 | 0001058330 |
2 | Expenses | -2.86 | -2.45 | 0.0339 | 0.588 | 2.74 | 0001052257 | 0000944508 | 0001128928 |
3 | Revenues | -4.44 | -1.85 | 0.262 | 2.54 | 3.47 | 0001052257 | 0000057528 | 0001007019 |
4 | StockholdersEquity | -2.96 | -1.92 | 0.117 | 1.31 | 2.12 | 0001058330 | 0001564822 | 0001273385 |
5 | NetIncome | -11.6 | -3.22 | 0.456 | 1.38 | 5.32 | 0001052257 | 0001117057 | 0001128928 |
6 | ComprehensiveNetIncome | -11.6 | -3.23 | 0.455 | 1.35 | 5.51 | 0001052257 | 0000040704 | 0001128928 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001046257 | 0000014177 |
8 | EconomicCapitalRatio | -11.0 | -4.71 | 0.315 | 2.07 | 6.37 | 0001052257 | 0001320695 | 0001128928 |
2014
Logs
error | 7 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
warning | 16 × Missing logo | subcommand.report | |
warning | 5 × Ignoring company because Assets is zero | pre-agg | |
warning | 4 × Similarly named company. Duplicate? | None | |
warning | 4 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 3 × Ignoring company because Expenses is zero | pre-agg | |
warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -4.556990421949096}
|
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 26,806,373 | 12,859,290,000 | 43,724,000,000 | 0000014177 | 0000802481 | 0001103982 |
1 | AssetsCurrent | 0 | 629,141 | 249,444,136 | 4,344,690,000 | 11,750,000,000 | 0001565383 | 0000880117 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 19,549 | 130,460,610 | 3,902,900,000 | 9,827,000,000 | 0000785956 | 0000880117 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 14,787,738 | 916,584,100 | 2,159,770,000 | 0000015357 | 0000880117 | 0001564822 |
4 | LiabilitiesLongTerm | 0 | 0 | 4,163 | 6,850,560,000 | 16,005,000,000 | 0000014177 | 0000076149 | 0001103982 |
5 | LiabilitiesCurrent | 0 | 1,046,474 | 91,506,995 | 4,237,800,000 | 14,007,000,000 | 0001565383 | 0001117057 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 3,918,599 | 3,890,600,000 | 8,950,000,000 | 0000023666 | 0000042228 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 249,758,700 | 573,000,000 | 0000014177 | 0000076149 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 615,561,900 | 1,355,053,000 | 0000014177 | 0000057515 | 0000931336 |
9 | remainder_Expenses | 32,539 | 1,362,467 | 496,103,810 | 16,792,800,000 | 31,355,000,000 | 0001565383 | 0001331301 | 0001103982 |
10 | remainder_Revenues | 0 | 69,636 | 544,606,446 | 17,847,500,000 | 34,244,000,000 | 0001565383 | 0000098677 | 0001103982 |
11 | remainder_NetIncome | -688,000,000 | -83,373,600 | -100,094 | 28,904,910 | 118,200,000 | 0001103982 | 0000015357 | 0000040704 |
12 | remainder_ComprehensiveNetIncome | -4,446,000,000 | -170,200,000 | 0 | 42,360,000 | 245,000,000 | 0001103982 | 0001451433 | 0000040704 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 4,353 | 732,903 | 551,087,556 | 21,872,820,000 | 66,815,000,000 | 0001565383 | 0001293593 | 0001103982 |
1 | Liabilities | 10,008 | 1,332,601 | 147,651,919 | 14,812,700,000 | 38,962,000,000 | 0001565383 | 0000812128 | 0001103982 |
2 | Expenses | 32,539 | 2,813,464 | 625,517,948 | 16,792,800,000 | 31,355,000,000 | 0001565383 | 0001331301 | 0001103982 |
3 | Revenues | 0 | 69,636 | 544,606,446 | 17,847,500,000 | 34,244,000,000 | 0001565383 | 0000098677 | 0001103982 |
4 | StockholdersEquity | -1,620,752 | -355,666 | 226,892,927 | 5,257,520,000 | 27,853,000,000 | 0001058330 | 0000880117 | 0001103982 |
5 | NetIncome | -343,200,000 | -100,290,705 | 15,323,182 | 984,173,600 | 2,201,000,000 | 0001530950 | 0001431897 | 0001103982 |
6 | ComprehensiveNetIncome | -350,740,000 | -123,241,876 | 15,309,693 | 836,030,400 | 1,951,800,000 | 0001530950 | 0001431897 | 0000040704 |
7 | BaseVar | 41,184 | 6,051,668 | 1,741,930,378 | 54,648,003,950 | 126,804,485,000 | 0001565383 | 0001331301 | 0001103982 |
8 | EconomicCapitalRatio | -10.5 | -4.56 | 0.905 | 2.57 | 3.17 | 0001565383 | 0000063754 | 0001273385 |
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 | IntangibleAssets | -2.66 | -1.01 | -0.115 | 0.868 | 1.22 | 0001565383 | 0000047111 | 0001530950 |
1 | AssetsCurrent | -3.83 | -1.21 | -0.0971 | 0.321 | 2.28 | 0001565383 | 0000047111 | 0001487197 |
2 | PropertyPlantAndEquipment | -2.23 | -0.810 | -0.00292 | 0.376 | 0.816 | 0001565383 | 0001530950 | 0001063537 |
3 | remainder_Assets | -0.613 | -0.345 | -0.0422 | 0.419 | 4.02 | 0001451433 | 0000023666 | 0001565383 |
4 | LiabilitiesLongTerm | -1.06 | -0.831 | 0.0438 | 1.01 | 1.19 | 0001565383 | 0001117057 | 0000812128 |
5 | LiabilitiesCurrent | -1.53 | -0.283 | 0.277 | 0.940 | 10.0 | 0001565383 | 0000944508 | 0001058330 |
6 | remainder_Liabilities | -0.851 | -0.293 | 0.110 | 0.727 | 11.9 | 0000023217 | 0001052257 | 0001565383 |
7 | GeneralAndAdministrativeExpense | -2.98 | -0.835 | 0.150 | 0.440 | 0.504 | 0001091983 | 0000098677 | 0000812128 |
8 | SellingAndMarketingExpense | -7.15 | -0.943 | 0.118 | 0.374 | 0.428 | 0001091983 | 0000091419 | 0000812128 |
9 | remainder_Expenses | -5.54 | -1.72 | 0.0132 | 0.985 | 7.90 | 0001565383 | 0001334586 | 0001091983 |
10 | remainder_Revenues | -3.87 | -1.64 | 0.0566 | 2.83 | 4.39 | 0001565383 | 0000023217 | 0001091983 |
11 | remainder_NetIncome | -1.34 | -0.717 | 0.00619 | 0.0502 | 4.18 | 0001334586 | 0001058330 | 0000076149 |
12 | remainder_ComprehensiveNetIncome | -0.0885 | -0.0643 | 0.00491 | 0.0445 | 0.0842 | 0001103982 | 0000016732 | 0000034563 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -5.11 | -1.77 | -0.0383 | 0.659 | 2.45 | 0001565383 | 0001452575 | 0001487197 |
1 | Liabilities | -1.06 | -0.881 | 0.550 | 1.99 | 6.25 | 0001530950 | 0001451433 | 0001058330 |
2 | Expenses | -4.99 | -1.82 | 0.0717 | 0.580 | 0.904 | 0001565383 | 0001046257 | 0001273385 |
3 | Revenues | -3.87 | -1.64 | 0.0566 | 2.83 | 4.39 | 0001565383 | 0000023217 | 0001091983 |
4 | StockholdersEquity | -3.45 | -2.67 | -0.173 | 1.32 | 2.14 | 0001091983 | 0001063537 | 0001273385 |
5 | NetIncome | -8.85 | -3.15 | 0.592 | 1.85 | 2.05 | 0001565383 | 0000014177 | 0001091983 |
6 | ComprehensiveNetIncome | -8.84 | -3.14 | 0.584 | 1.86 | 2.01 | 0001565383 | 0000063754 | 0000785956 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000931336 | 0000014177 |
8 | EconomicCapitalRatio | -11.0 | -5.02 | 0.438 | 2.10 | 2.71 | 0001565383 | 0000063754 | 0001273385 |
2015
Logs
error | 6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
warning | 23 × No stock price available | subcommand.plot | |
warning | 7 × Missing logo | subcommand.report | |
warning | 6 × Ignoring company because Assets is zero | pre-agg | |
warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 5 × Ignoring company because Expenses is zero | pre-agg | |
warning | 3 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -8.276392467070648}
|
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | IntangibleAssets | 0 | 0 | 38,050,464 | 12,960,100,000 | 39,432,000,000 | 0000014177 | 0000944508 | 0001103982 |
1 | AssetsCurrent | 0 | 1,304 | 326,847,860 | 3,667,700,000 | 8,958,000,000 | 0001624517 | 0000785956 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 172,318,112 | 3,608,100,000 | 8,362,000,000 | 0001409446 | 0000057515 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 17,623,608 | 843,600,000 | 6,091,000,000 | 0000015357 | 0001320695 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 900 | 6,036,300,000 | 16,389,000,000 | 0000014177 | 0000076149 | 0001103982 |
5 | LiabilitiesCurrent | 8,290 | 165,625 | 97,150,924 | 3,310,200,000 | 10,922,000,000 | 0001624517 | 0000785956 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 3,290,280 | 3,122,100,000 | 7,432,000,000 | 0000057515 | 0001609989 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 287,591,000 | 593,000,000 | 0000014177 | 0000088948 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 641,800,000 | 1,379,317,000 | 0000014177 | 0000098677 | 0000931336 |
9 | remainder_Expenses | 15,000 | 434,799 | 791,338,988 | 16,230,000,000 | 27,376,000,000 | 0001624517 | 0000785956 | 0001103982 |
10 | remainder_Revenues | 0 | 3,996 | 864,613,364 | 15,832,400,000 | 29,636,000,000 | 0001568139 | 0001320947 | 0001103982 |
11 | remainder_NetIncome | -135,912,000 | -92,500,000 | -740 | 46,200,000 | 5,031,000,000 | 0000047111 | 0001593001 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -2,692,000,000 | -340,000,000 | -46,470 | 134,000 | 3,563,000 | 0001103982 | 0001091983 | 0000802481 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 2,172 | 102,609 | 715,055,964 | 17,542,200,000 | 62,843,000,000 | 0001624517 | 0000057515 | 0001103982 |
1 | Liabilities | 52,946 | 289,857 | 166,135,908 | 12,932,200,000 | 34,743,000,000 | 0001624517 | 0000944508 | 0001103982 |
2 | Expenses | 76,094 | 434,799 | 831,480,216 | 16,230,000,000 | 27,376,000,000 | 0001624517 | 0001320947 | 0001103982 |
3 | Revenues | 0 | 3,996 | 864,613,364 | 15,832,400,000 | 29,636,000,000 | 0001568139 | 0001320947 | 0001103982 |
4 | StockholdersEquity | -592,500,000 | -1,455,688 | 220,462,872 | 6,171,600,000 | 28,100,000,000 | 0001452575 | 0001005286 | 0001103982 |
5 | NetIncome | -240,800,000 | -23,976,431 | 13,731,868 | 691,000,000 | 7,291,000,000 | 0000023217 | 0001005286 | 0001103982 |
6 | ComprehensiveNetIncome | -348,440,000 | -23,976,431 | 12,967,385 | 647,814,760 | 5,891,160,000 | 0000023217 | 0000014177 | 0001103982 |
7 | BaseVar | 107,077 | 862,864 | 2,395,278,935 | 49,122,579,000 | 116,441,075,000 | 0001624517 | 0000785956 | 0001103982 |
8 | EconomicCapitalRatio | -17.5 | -8.28 | 0.525 | 2.43 | 2.74 | 0001052257 | 0000040704 | 0000057515 |
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 | IntangibleAssets | -6.04 | -3.07 | -0.140 | 0.919 | 1.59 | 0001052257 | 0000047111 | 0001568139 |
1 | AssetsCurrent | -6.24 | -2.51 | -0.0591 | 0.463 | 3.45 | 0001052257 | 0001320947 | 0001487197 |
2 | PropertyPlantAndEquipment | -4.10 | -2.29 | -0.00440 | 0.229 | 0.613 | 0001052257 | 0000076149 | 0001063537 |
3 | remainder_Assets | -1.98 | -0.547 | -0.0479 | 0.303 | 1.61 | 0001052257 | 0000910406 | 0001409446 |
4 | LiabilitiesLongTerm | -3.25 | -1.06 | -0.148 | 1.03 | 1.12 | 0001052257 | 0001451433 | 0000812128 |
5 | LiabilitiesCurrent | -0.850 | -0.164 | 0.339 | 2.10 | 10.8 | 0001293593 | 0001320695 | 0001409446 |
6 | remainder_Liabilities | -2.33 | -1.01 | 0.185 | 0.877 | 14.2 | 0001052257 | 0001063537 | 0001624517 |
7 | GeneralAndAdministrativeExpense | -4.34 | -1.44 | 0.241 | 0.531 | 0.729 | 0001624517 | 0000023217 | 0001052257 |
8 | SellingAndMarketingExpense | -6.67 | -1.31 | 0.128 | 0.309 | 0.424 | 0001091983 | 0000040704 | 0001052257 |
9 | remainder_Expenses | -5.98 | -1.52 | -0.0223 | 1.52 | 7.64 | 0001409446 | 0000023217 | 0001091983 |
10 | remainder_Revenues | -5.57 | -2.52 | 0.228 | 2.50 | 4.93 | 0001052257 | 0000063754 | 0001091983 |
11 | remainder_NetIncome | -12.5 | -0.471 | 0.182 | 0.346 | 0.590 | 0001052257 | 0000909954 | 0001091983 |
12 | remainder_ComprehensiveNetIncome | -0.143 | -0.0597 | 0.0213 | 0.0590 | 0.0919 | 0000034563 | 0001624517 | 0001091983 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -11.2 | -5.21 | 0.00128 | 0.775 | 2.97 | 0001052257 | 0000057515 | 0001487197 |
1 | Liabilities | -2.04 | -0.977 | 0.395 | 2.35 | 7.82 | 0001052257 | 0000098677 | 0001624517 |
2 | Expenses | -5.26 | -3.17 | 0.127 | 0.680 | 4.00 | 0001409446 | 0000944508 | 0001052257 |
3 | Revenues | -5.57 | -2.52 | 0.228 | 2.50 | 4.93 | 0001052257 | 0000063754 | 0001091983 |
4 | StockholdersEquity | -3.05 | -2.74 | 0.0188 | 1.39 | 1.60 | 0001624517 | 0000088948 | 0001611647 |
5 | NetIncome | -14.1 | -5.25 | 0.830 | 2.21 | 2.77 | 0001052257 | 0000910406 | 0001091983 |
6 | ComprehensiveNetIncome | -14.1 | -5.23 | 0.817 | 2.26 | 2.86 | 0001052257 | 0000098677 | 0001091983 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000944508 | 0000014177 |
8 | EconomicCapitalRatio | -17.0 | -7.73 | 1.07 | 2.98 | 3.29 | 0001052257 | 0000040704 | 0000057515 |
2016
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 19 × No stock price available | subcommand.plot | |
warning | 7 × Ignoring company because Expenses is zero | pre-agg | |
warning | 6 × Ignoring company because Assets is zero | pre-agg | |
warning | 5 × Missing logo | subcommand.report | |
warning | 4 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 3 × Similarly named company. Duplicate? | None | |
warning | 3 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -5.457029327494704}
|
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'LiabilitiesLongTerm', 'min_value': -38004}
|
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | IntangibleAssets | 0 | 0 | 12,628,938 | 10,909,400,000 | 38,377,000,000 | 0000014177 | 0001117057 | 0001103982 |
1 | AssetsCurrent | 0 | 10,964 | 299,575,867 | 3,865,100,000 | 8,480,000,000 | 0001137005 | 0000098677 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 1,023 | 169,644,764 | 3,708,680,000 | 8,229,000,000 | 0000859747 | 0000057515 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 16,999,799 | 1,003,940,000 | 6,452,000,000 | 0000015357 | 0001117057 | 0001103982 |
4 | LiabilitiesLongTerm | -38,004 | 0 | 0 | 4,663,800,000 | 14,789,000,000 | 0000949852 | 0000057515 | 0001103982 |
5 | LiabilitiesCurrent | 88,640 | 319,825 | 99,044,193 | 4,131,600,000 | 14,417,000,000 | 0000015357 | 0001609989 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 1,571,309 | 1,264,980,000 | 7,117,000,000 | 0000055067 | 0001063537 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 280,860,400 | 641,000,000 | 0000014177 | 0000812128 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 582,550,600 | 1,348,349,000 | 0000014177 | 0000040704 | 0000931336 |
9 | remainder_Expenses | 16,125 | 375,073 | 459,702,232 | 14,501,920,000 | 34,874,000,000 | 0001137005 | 0000098677 | 0000100493 |
10 | remainder_Revenues | 0 | 0 | 541,113,445 | 15,853,280,000 | 36,881,000,000 | 0000047111 | 0001005286 | 0000100493 |
11 | remainder_NetIncome | -1,321,900,000 | -262,440,000 | -77,687 | 33,339,600 | 1,099,481,000 | 0000023217 | 0001063537 | 0000047111 |
12 | remainder_ComprehensiveNetIncome | -1,146,000,000 | -186,096,000 | 0 | 25,663,400 | 64,000,000 | 0001103982 | 0000944508 | 0000016732 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 5,113 | 149,401 | 651,083,687 | 20,392,040,000 | 61,538,000,000 | 0001137005 | 0001609989 | 0001103982 |
1 | Liabilities | 244,547 | 338,283 | 186,494,530 | 8,947,040,000 | 36,323,000,000 | 0000015357 | 0000034563 | 0001103982 |
2 | Expenses | 187,725 | 452,471 | 459,702,232 | 14,501,920,000 | 34,874,000,000 | 0000859747 | 0000098677 | 0000100493 |
3 | Revenues | 0 | 0 | 541,113,445 | 15,853,280,000 | 36,881,000,000 | 0000047111 | 0001005286 | 0000100493 |
4 | StockholdersEquity | -472,100,000 | -7,363,666 | 146,497,526 | 9,740,140,000 | 25,215,000,000 | 0001452575 | 0001609989 | 0001103982 |
5 | NetIncome | -665,900,000 | -115,138,664 | 7,800,505 | 1,479,208,800 | 1,772,000,000 | 0000023217 | 0000014177 | 0000100493 |
6 | ComprehensiveNetIncome | -679,472,000 | -114,343,648 | 5,449,130 | 1,001,967,048 | 1,793,320,000 | 0000023217 | 0000014177 | 0000100493 |
7 | BaseVar | 393,513 | 1,230,673 | 1,599,514,451 | 49,140,886,200 | 102,563,035,000 | 0000859747 | 0000098677 | 0001103982 |
8 | EconomicCapitalRatio | -13.8 | -5.46 | 0.811 | 2.49 | 2.87 | 0001137005 | 0000063754 | 0000057515 |
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 | IntangibleAssets | -3.42 | -1.38 | -0.184 | 0.876 | 1.10 | 0001137005 | 0001005286 | 0001568139 |
1 | AssetsCurrent | -4.46 | -1.09 | -0.0587 | 0.463 | 5.14 | 0001137005 | 0000023217 | 0001487197 |
2 | PropertyPlantAndEquipment | -3.36 | -0.941 | -0.0249 | 0.409 | 0.797 | 0001137005 | 0000814586 | 0001611647 |
3 | remainder_Assets | -1.19 | -0.507 | -0.0390 | 0.231 | 0.311 | 0001137005 | 0000057528 | 0000098677 |
4 | LiabilitiesLongTerm | -1.87 | -1.09 | 0.0884 | 1.07 | 1.12 | 0001137005 | 0001091983 | 0000015357 |
5 | LiabilitiesCurrent | -0.507 | -0.319 | 0.591 | 4.24 | 14.8 | 0000944508 | 0001046257 | 0001137005 |
6 | remainder_Liabilities | -1.14 | -0.549 | 0.121 | 0.665 | 0.812 | 0001137005 | 0000042228 | 0000859747 |
7 | GeneralAndAdministrativeExpense | -10.4 | -1.95 | 0.271 | 0.694 | 0.851 | 0001137005 | 0000023217 | 0000042228 |
8 | SellingAndMarketingExpense | -3.40 | -0.958 | 0.103 | 0.264 | 0.324 | 0001091983 | 0000023217 | 0000042228 |
9 | remainder_Expenses | -4.16 | -2.18 | -0.202 | 1.61 | 4.17 | 0001593001 | 0000015357 | 0001137005 |
10 | remainder_Revenues | -4.17 | -1.82 | 0.342 | 2.74 | 2.79 | 0001137005 | 0000910406 | 0000931336 |
11 | remainder_NetIncome | -3.22 | -0.195 | 0.127 | 0.305 | 0.917 | 0001409446 | 0001063537 | 0000859747 |
12 | remainder_ComprehensiveNetIncome | -0.0675 | -0.0281 | 0.00370 | 0.0196 | 0.126 | 0000014177 | 0001593001 | 0001063537 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -8.10 | -2.67 | -0.0396 | 0.889 | 3.16 | 0001137005 | 0000100493 | 0001487197 |
1 | Liabilities | -1.47 | -0.770 | 0.696 | 2.46 | 3.75 | 0000047111 | 0000055067 | 0001137005 |
2 | Expenses | -6.03 | -1.58 | -0.00888 | 0.701 | 1.77 | 0001137005 | 0000014177 | 0001409446 |
3 | Revenues | -4.17 | -1.82 | 0.342 | 2.74 | 2.79 | 0001137005 | 0000910406 | 0000931336 |
4 | StockholdersEquity | -3.32 | -2.43 | 0.260 | 1.53 | 2.02 | 0001137005 | 0000014177 | 0001487197 |
5 | NetIncome | -10.00 | -3.18 | 0.716 | 1.87 | 1.99 | 0001137005 | 0001611647 | 0000057515 |
6 | ComprehensiveNetIncome | -9.99 | -3.18 | 0.720 | 1.87 | 1.99 | 0001137005 | 0001611647 | 0000057515 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000931336 | 0000014177 |
8 | EconomicCapitalRatio | -13.7 | -5.39 | 0.874 | 2.55 | 2.94 | 0001137005 | 0000063754 | 0000057515 |
2017
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 12 × Ignoring company because Expenses is zero | pre-agg | |
warning | 10 × No stock price available | subcommand.plot | |
warning | 8 × Ignoring company because Assets is zero | pre-agg | |
warning | 3 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.2139970669295574}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 54,845,449 | 13,735,480,000 | 39,724,000,000 | 0000014177 | 0001005286 | 0001103982 |
1 | AssetsCurrent | 0 | 91,397 | 301,436,470 | 4,500,720,000 | 7,520,000,000 | 0001137005 | 0000057515 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 1,812 | 180,839,876 | 4,086,400,000 | 8,677,000,000 | 0001409446 | 0000057515 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 52,585,846 | 1,000,600,000 | 7,188,000,000 | 0000015357 | 0000910406 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 0 | 7,814,720,000 | 15,661,000,000 | 0000014177 | 0000055067 | 0001103982 |
5 | LiabilitiesCurrent | 110,299 | 485,702 | 97,345,397 | 4,649,360,000 | 15,793,000,000 | 0000015357 | 0000034563 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 516,416 | 1,929,360,000 | 5,464,000,000 | 0000055067 | 0000730349 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 302,555,200 | 488,000,000 | 0000014177 | 0000063754 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 485,240,000 | 1,346,948,000 | 0000014177 | 0000076149 | 0000931336 |
9 | remainder_Expenses | 0 | 785,757 | 524,195,280 | 15,844,960,000 | 36,179,000,000 | 0001137005 | 0001005286 | 0000100493 |
10 | remainder_Revenues | 0 | 3,589 | 543,453,806 | 17,675,040,000 | 38,260,000,000 | 0000047111 | 0000034563 | 0000100493 |
11 | remainder_NetIncome | -303,000,000 | -116,940,000 | 0 | 118,000,000 | 1,110,668,000 | 0000100493 | 0001487197 | 0000047111 |
12 | remainder_ComprehensiveNetIncome | -23,368,000 | -603,200 | 1,419,089 | 253,700,000 | 1,110,000,000 | 0000910406 | 0001117057 | 0001103982 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 727 | 91,704 | 848,653,111 | 23,063,280,000 | 63,109,000,000 | 0001409446 | 0001609989 | 0001103982 |
1 | Liabilities | 221,634 | 499,252 | 177,671,348 | 10,512,920,000 | 36,918,000,000 | 0000015357 | 0000034563 | 0001103982 |
2 | Expenses | 53,195 | 788,221 | 524,667,734 | 15,844,960,000 | 36,179,000,000 | 0001137005 | 0001005286 | 0000100493 |
3 | Revenues | 0 | 3,589 | 543,453,806 | 17,675,040,000 | 38,260,000,000 | 0000047111 | 0000034563 | 0000100493 |
4 | StockholdersEquity | -10,791,296 | -2,175,853 | 640,120,479 | 14,303,600,000 | 26,191,000,000 | 0001117057 | 0000057515 | 0001103982 |
5 | NetIncome | -286,200,000 | -22,790,303 | 55,464,126 | 1,716,480,000 | 2,936,000,000 | 0001320695 | 0000910329 | 0001103982 |
6 | ComprehensiveNetIncome | -265,504,000 | -22,642,860 | 55,457,068 | 1,820,038,400 | 3,513,200,000 | 0001320695 | 0000910329 | 0001103982 |
7 | BaseVar | 373,254 | 2,255,207 | 2,692,584,786 | 59,138,992,600 | 102,863,330,000 | 0001137005 | 0000785956 | 0001103982 |
8 | EconomicCapitalRatio | -7.31 | -3.21 | 1.18 | 2.77 | 2.88 | 0001593001 | 0000057528 | 0000910329 |
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 | IntangibleAssets | -1.60 | -0.936 | -0.0428 | 0.807 | 1.00 | 0001593001 | 0000076149 | 0000063754 |
1 | AssetsCurrent | -0.961 | -0.458 | -0.0572 | 0.342 | 1.41 | 0001091983 | 0001117057 | 0001487197 |
2 | PropertyPlantAndEquipment | -1.44 | -0.391 | -0.00865 | 0.455 | 0.897 | 0001593001 | 0000814586 | 0001117057 |
3 | remainder_Assets | -0.443 | -0.319 | -0.0210 | 0.143 | 0.318 | 0001593001 | 0000100493 | 0000098677 |
4 | LiabilitiesLongTerm | -1.32 | -0.837 | 0.404 | 1.00 | 1.05 | 0001530950 | 0000055067 | 0000931336 |
5 | LiabilitiesCurrent | -3.01 | -0.190 | 0.575 | 2.02 | 6.89 | 0001409446 | 0001046257 | 0001593001 |
6 | remainder_Liabilities | -0.502 | -0.369 | 0.143 | 0.639 | 0.688 | 0000023217 | 0001320695 | 0000931336 |
7 | GeneralAndAdministrativeExpense | -5.54 | -1.03 | 0.259 | 0.626 | 0.842 | 0001487197 | 0000785956 | 0000949852 |
8 | SellingAndMarketingExpense | -1.79 | -1.06 | 0.0974 | 0.284 | 0.382 | 0001091983 | 0000098677 | 0000949852 |
9 | remainder_Expenses | -3.24 | -1.75 | -0.343 | 1.44 | 2.39 | 0000949852 | 0000785956 | 0001091983 |
10 | remainder_Revenues | -6.16 | -2.12 | 0.529 | 2.64 | 2.89 | 0001409446 | 0000076149 | 0000931336 |
11 | remainder_NetIncome | -1.27 | -1.08 | -0.0599 | 0.461 | 10.3 | 0001593001 | 0001005286 | 0001409446 |
12 | remainder_ComprehensiveNetIncome | -0.0477 | -0.0431 | -0.0135 | 0.0764 | 0.176 | 0000949852 | 0000785956 | 0001063537 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -3.14 | -1.11 | 0.0162 | 0.754 | 1.08 | 0001593001 | 0000057515 | 0000047111 |
1 | Liabilities | -1.51 | -0.853 | 0.956 | 2.27 | 3.43 | 0000047111 | 0001063537 | 0001593001 |
2 | Expenses | -3.13 | -2.02 | -0.118 | 0.520 | 0.817 | 0001487197 | 0000076149 | 0000047111 |
3 | Revenues | -6.16 | -2.12 | 0.529 | 2.64 | 2.89 | 0001409446 | 0000076149 | 0000931336 |
4 | StockholdersEquity | -4.10 | -2.50 | 0.306 | 1.34 | 1.73 | 0001409446 | 0000034563 | 0000076149 |
5 | NetIncome | -5.25 | -2.71 | 0.407 | 1.21 | 4.69 | 0001487197 | 0000814586 | 0001409446 |
6 | ComprehensiveNetIncome | -5.27 | -2.70 | 0.396 | 1.18 | 4.65 | 0001487197 | 0000949852 | 0001409446 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000910329 | 0000014177 |
8 | EconomicCapitalRatio | -8.11 | -4.01 | 0.383 | 1.97 | 2.08 | 0001593001 | 0000057528 | 0000910329 |
2018
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × Negative Expenses, ignoring company. | pre-agg | |
warning | 15 × Ignoring company because Expenses is zero | pre-agg | |
warning | 12 × No stock price available | subcommand.plot | |
warning | 9 × Ignoring company because Assets is zero | pre-agg | |
warning | 3 × Similarly named company. Duplicate? | None | |
warning | 3 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.605754480497841}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 11,683,769 | 16,999,210,000 | 38,727,000,000 | 0000014177 | 0001619055 | 0001103982 |
1 | AssetsCurrent | 0 | 140,075 | 173,992,526 | 4,280,130,000 | 7,604,000,000 | 0001612188 | 0000034563 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 186,102,854 | 4,259,380,000 | 8,482,000,000 | 0001409446 | 0000098677 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 15,756,128 | 1,145,840,000 | 7,916,000,000 | 0000015357 | 0000014177 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 0 | 9,111,270,000 | 15,155,000,000 | 0000014177 | 0001730773 | 0001103982 |
5 | LiabilitiesCurrent | 220,246 | 423,591 | 93,655,426 | 5,262,090,000 | 16,737,000,000 | 0000015357 | 0001005286 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 14,681 | 2,126,570,000 | 5,124,000,000 | 0000055067 | 0001563463 | 0001103982 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 277,893,100 | 654,000,000 | 0000014177 | 0000098677 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 430,760,000 | 1,403,178,000 | 0000014177 | 0000023217 | 0000931336 |
9 | remainder_Expenses | 9,119 | 1,110,523 | 446,767,932 | 14,630,790,000 | 36,715,000,000 | 0001612188 | 0000910329 | 0000100493 |
10 | remainder_Revenues | 0 | 2,930 | 518,940,167 | 16,760,160,000 | 40,052,000,000 | 0000047111 | 0000098677 | 0000100493 |
11 | remainder_NetIncome | -310,000,000 | -78,547,200 | 4,655 | 176,000,000 | 1,410,061,000 | 0000100493 | 0000949852 | 0000047111 |
12 | remainder_ComprehensiveNetIncome | -647,000,000 | -72,200,000 | 0 | 21,405,100 | 117,100,000 | 0001103982 | 0000015357 | 0000023217 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 7,020 | 359,411 | 476,781,048 | 29,260,500,000 | 62,729,000,000 | 0001409446 | 0000034563 | 0001103982 |
1 | Liabilities | 252,499 | 427,221 | 118,029,120 | 14,175,940,000 | 37,016,000,000 | 0000015357 | 0000785956 | 0001103982 |
2 | Expenses | 20,694 | 1,110,523 | 464,984,874 | 14,630,790,000 | 36,715,000,000 | 0001612188 | 0000098677 | 0000100493 |
3 | Revenues | 0 | 2,930 | 518,940,167 | 16,760,160,000 | 40,052,000,000 | 0000047111 | 0000098677 | 0000100493 |
4 | StockholdersEquity | -2,658,954 | -833,994 | 254,303,016 | 14,333,700,000 | 25,713,000,000 | 0001593001 | 0001005286 | 0001103982 |
5 | NetIncome | -327,358,000 | -22,592,000 | 9,721,121 | 2,249,400,000 | 3,395,000,000 | 0000931336 | 0000910406 | 0001103982 |
6 | ComprehensiveNetIncome | -328,861,840 | -24,698,728 | 14,859,658 | 2,299,793,200 | 3,058,560,000 | 0000931336 | 0001117057 | 0001103982 |
7 | BaseVar | 885,924 | 2,755,217 | 1,603,159,627 | 61,896,082,050 | 102,895,800,000 | 0001612188 | 0000098677 | 0001103982 |
8 | EconomicCapitalRatio | -9.81 | -2.61 | 1.01 | 2.54 | 3.02 | 0001593001 | 0001644406 | 0001117057 |
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 | IntangibleAssets | -2.84 | -1.13 | -0.0956 | 0.818 | 1.40 | 0001593001 | 0000076149 | 0001644406 |
1 | AssetsCurrent | -2.31 | -0.654 | -0.0580 | 0.471 | 0.565 | 0001593001 | 0000100493 | 0001725911 |
2 | PropertyPlantAndEquipment | -2.07 | -0.582 | -0.00656 | 0.325 | 0.721 | 0001593001 | 0000076149 | 0001063537 |
3 | remainder_Assets | -0.998 | -0.396 | -0.0315 | 0.135 | 1.09 | 0001593001 | 0000063754 | 0001612188 |
4 | LiabilitiesLongTerm | -1.20 | -0.932 | 0.400 | 0.981 | 1.10 | 0001530950 | 0000034563 | 0000910329 |
5 | LiabilitiesCurrent | -2.13 | -0.374 | 0.487 | 2.65 | 12.9 | 0001612188 | 0000910406 | 0001409446 |
6 | remainder_Liabilities | -0.645 | -0.413 | 0.0934 | 0.464 | 0.536 | 0000023217 | 0001320695 | 0000910329 |
7 | GeneralAndAdministrativeExpense | -2.68 | -1.41 | 0.128 | 0.383 | 0.497 | 0001563463 | 0000098677 | 0000949852 |
8 | SellingAndMarketingExpense | -1.77 | -0.826 | 0.0700 | 0.204 | 0.265 | 0000931336 | 0000023217 | 0000949852 |
9 | remainder_Expenses | -4.45 | -2.02 | -0.153 | 0.817 | 1.54 | 0001593001 | 0000910406 | 0001487197 |
10 | remainder_Revenues | -2.96 | -1.42 | 0.297 | 2.72 | 3.19 | 0001593001 | 0000055067 | 0000931336 |
11 | remainder_NetIncome | -2.15 | -0.192 | -0.0337 | 0.386 | 2.68 | 0001409446 | 0000076149 | 0001117057 |
12 | remainder_ComprehensiveNetIncome | -0.295 | -0.0118 | 0.00995 | 0.0281 | 0.0643 | 0001117057 | 0001128928 | 0000014177 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -5.59 | -2.15 | -0.0421 | 0.766 | 1.06 | 0001593001 | 0001320695 | 0000047111 |
1 | Liabilities | -2.28 | -0.874 | 0.586 | 2.51 | 7.20 | 0001612188 | 0000098677 | 0001409446 |
2 | Expenses | -4.10 | -2.80 | -0.315 | 0.834 | 1.52 | 0001593001 | 0000785956 | 0001117057 |
3 | Revenues | -2.96 | -1.42 | 0.297 | 2.72 | 3.19 | 0001593001 | 0000055067 | 0000931336 |
4 | StockholdersEquity | -3.25 | -1.83 | 0.130 | 1.24 | 1.62 | 0001593001 | 0000023217 | 0000076149 |
5 | NetIncome | -7.10 | -2.63 | 0.256 | 1.04 | 2.80 | 0001593001 | 0001103982 | 0001117057 |
6 | ComprehensiveNetIncome | -7.09 | -2.61 | 0.247 | 1.06 | 2.50 | 0001593001 | 0001103982 | 0001117057 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000931336 | 0000014177 |
8 | EconomicCapitalRatio | -10.5 | -3.25 | 0.367 | 1.90 | 2.38 | 0001593001 | 0001644406 | 0001117057 |
2019
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × Negative Expenses, ignoring company. | pre-agg | |
warning | 31 × No stock price available | subcommand.plot |
0001611647
0001117057
0000014177
0000023217
0000034563
0000047111
0000057515
0000098677
0000785956
0000910329
0000931336
0000949852
0001005286
0001046257
0001103982
0001530950
0001644406
0001725911
0001730773
0000015357
0000812128
0000730349
0000814586
0000880117
0001007019
0001487197
0001572386
0001593001
0001612188
0001655210
0001741231
|
warning | 12 × Ignoring company because Expenses is zero | pre-agg | |
warning | 9 × Ignoring company because Assets is zero | pre-agg | |
warning | 4 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 3 × Similarly named company. Duplicate? | None | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.195059481156614}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 9,661,351 | 18,537,320,000 | 39,373,000,000 | 0000014177 | 0000880117 | 0001103982 |
1 | AssetsCurrent | 337,509 | 471,912 | 160,143,555 | 4,783,000,000 | 7,630,000,000 | 0001725911 | 0000034563 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 126,323,777 | 2,673,680,000 | 7,282,000,000 | 0000949852 | 0000880117 | 0000100493 |
3 | remainder_Assets | 0 | 0 | 14,781,638 | 933,940,000 | 17,546,000,000 | 0000015357 | 0000814586 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 160,292 | 8,633,060,000 | 16,961,000,000 | 0000014177 | 0001487197 | 0001103982 |
5 | LiabilitiesCurrent | 0 | 309,850 | 79,559,703 | 5,827,820,000 | 15,322,000,000 | 0001117057 | 0000098677 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 1,449,030 | 2,607,800,000 | 10,655,700,000 | 0000057515 | 0001007019 | 0000023217 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 53,051,800 | 301,355,000 | 0000014177 | 0000098677 | 0000931336 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 105,071,800 | 1,327,922,000 | 0000014177 | 0000023217 | 0000931336 |
9 | remainder_Expenses | 441,320 | 1,193,053 | 462,497,059 | 16,499,000,000 | 39,974,000,000 | 0001572386 | 0000034563 | 0000100493 |
10 | remainder_Revenues | 0 | 0 | 557,697,179 | 18,665,760,000 | 42,405,000,000 | 0000098677 | 0001005286 | 0000100493 |
11 | remainder_NetIncome | -396,000,000 | -241,980,000 | -1,871 | 47,120,000 | 85,404,000 | 0000100493 | 0000015357 | 0000098677 |
12 | remainder_ComprehensiveNetIncome | -229,900,000 | -119,820,000 | 0 | 18,595,600 | 357,000,000 | 0000040704 | 0001725911 | 0001103982 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 371,531 | 471,912 | 424,708,327 | 30,708,360,000 | 64,549,000,000 | 0001725911 | 0000034563 | 0001103982 |
1 | Liabilities | 242,811 | 735,155 | 119,711,501 | 16,238,440,000 | 37,198,000,000 | 0000015357 | 0000057515 | 0001103982 |
2 | Expenses | 852,455 | 2,231,169 | 559,113,693 | 16,499,000,000 | 39,974,000,000 | 0001741231 | 0001005286 | 0000100493 |
3 | Revenues | 0 | 0 | 557,697,179 | 18,665,760,000 | 42,405,000,000 | 0000098677 | 0001005286 | 0000100493 |
4 | StockholdersEquity | -29,472,605 | -2,074,405 | 254,611,120 | 11,805,720,000 | 27,584,000,000 | 0001593001 | 0000880117 | 0000100493 |
5 | NetIncome | -500,804,000 | -95,538,800 | 459,830 | 1,835,960,000 | 3,885,000,000 | 0000931336 | 0000814586 | 0001103982 |
6 | ComprehensiveNetIncome | -493,364,880 | -100,485,872 | 459,830 | 1,728,361,600 | 4,070,640,000 | 0000931336 | 0000814586 | 0001103982 |
7 | BaseVar | 3,329,657 | 7,323,516 | 1,553,546,718 | 68,150,847,600 | 105,925,050,000 | 0001725911 | 0001005286 | 0000100493 |
8 | EconomicCapitalRatio | -4.39 | -2.20 | 1.03 | 2.50 | 2.69 | 0001572386 | 0001611647 | 0000057515 |
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 | IntangibleAssets | -1.04 | -0.812 | -0.143 | 0.931 | 1.27 | 0001725911 | 0000812128 | 0001644406 |
1 | AssetsCurrent | -0.656 | -0.407 | -0.0871 | 0.450 | 1.03 | 0000931336 | 0000812128 | 0001655210 |
2 | PropertyPlantAndEquipment | -0.846 | -0.521 | -0.0204 | 0.540 | 0.861 | 0001725911 | 0000023217 | 0001611647 |
3 | remainder_Assets | -0.940 | -0.710 | -0.156 | 0.194 | 1.67 | 0001725911 | 0001530950 | 0001741231 |
4 | LiabilitiesLongTerm | -1.38 | -0.899 | 0.223 | 0.836 | 0.914 | 0001530950 | 0001612188 | 0000910329 |
5 | LiabilitiesCurrent | -0.590 | -0.164 | 0.526 | 2.19 | 5.02 | 0001730773 | 0001655210 | 0001572386 |
6 | remainder_Liabilities | -1.11 | -0.526 | 0.177 | 0.639 | 0.832 | 0000023217 | 0001612188 | 0000910329 |
7 | GeneralAndAdministrativeExpense | -2.63 | -0.954 | 0.142 | 0.491 | 0.677 | 0001487197 | 0000040704 | 0000910329 |
8 | SellingAndMarketingExpense | -1.39 | -0.905 | 0.0617 | 0.215 | 0.294 | 0000931336 | 0000040704 | 0000910329 |
9 | remainder_Expenses | -2.74 | -2.10 | -0.418 | 0.986 | 1.30 | 0000910329 | 0000910406 | 0001487197 |
10 | remainder_Revenues | -1.30 | -0.882 | 0.390 | 2.50 | 3.34 | 0001572386 | 0001005286 | 0000910329 |
11 | remainder_NetIncome | -0.652 | -0.221 | 0.0371 | 0.261 | 0.489 | 0001117057 | 0000063754 | 0001612188 |
12 | remainder_ComprehensiveNetIncome | -0.0951 | -0.0535 | -0.0259 | 0.00949 | 0.491 | 0000014177 | 0001128928 | 0001117057 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -1.98 | -1.78 | -0.134 | 0.707 | 1.09 | 0001725911 | 0001611647 | 0000098677 |
1 | Liabilities | -0.790 | -0.717 | 0.581 | 2.36 | 4.56 | 0001530950 | 0001063537 | 0001572386 |
2 | Expenses | -2.52 | -2.05 | -0.415 | 0.714 | 1.02 | 0000015357 | 0000785956 | 0001117057 |
3 | Revenues | -1.30 | -0.882 | 0.390 | 2.50 | 3.34 | 0001572386 | 0001005286 | 0000910329 |
4 | StockholdersEquity | -2.95 | -2.50 | 0.00573 | 1.29 | 2.27 | 0001593001 | 0001005286 | 0001741231 |
5 | NetIncome | -1.88 | -1.16 | 0.257 | 0.847 | 1.69 | 0001572386 | 0000040704 | 0000910329 |
6 | ComprehensiveNetIncome | -1.89 | -1.18 | 0.236 | 0.810 | 1.64 | 0001572386 | 0000040704 | 0000910329 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0000949852 | 0000014177 |
8 | EconomicCapitalRatio | -5.23 | -3.03 | 0.191 | 1.66 | 1.85 | 0001572386 | 0001611647 | 0000057515 |
2020
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 2 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 10 × Ignoring company because Expenses is zero | pre-agg | |
warning | 8 × Similarly named company. Duplicate? | None | |
warning | 8 × Ignoring company because Assets is zero | pre-agg | |
warning | 7 × No stock price available | subcommand.plot | |
warning | 4 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Missing logo | subcommand.report | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -4.6512755458704}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | IntangibleAssets | 0 | 0 | 40,789,175 | 20,684,400,000 | 79,756,000,000 | 0000014177 | 0000812128 | 0001637459 |
1 | AssetsCurrent | 0 | 42,749 | 239,086,582 | 7,606,830,000 | 10,822,000,000 | 0001563227 | 0000880117 | 0001637459 |
2 | PropertyPlantAndEquipment | 0 | 0 | 165,724,119 | 6,546,460,000 | 9,026,000,000 | 0001563227 | 0000034563 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 17,499,781 | 1,557,750,000 | 7,790,000,000 | 0000015357 | 0001644406 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 7,099,638 | 11,982,480,000 | 29,821,000,000 | 0000057515 | 0001611647 | 0001637459 |
5 | LiabilitiesCurrent | 0 | 488,408 | 111,353,436 | 7,165,750,000 | 15,159,000,000 | 0001563227 | 0000910329 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 4,533,853 | 4,648,810,000 | 11,705,000,000 | 0000057515 | 0000814586 | 0001637459 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 87,830,900 | 622,000,000 | 0000014177 | 0000047111 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 118,831,100 | 947,000,000 | 0000014177 | 0000040704 | 0000016732 |
9 | remainder_Expenses | 30,000 | 304,568 | 625,772,204 | 22,983,290,000 | 40,691,000,000 | 0001572386 | 0001005286 | 0000100493 |
10 | remainder_Revenues | 0 | 24,167 | 591,582,849 | 25,329,160,000 | 43,185,000,000 | 0001563227 | 0001005286 | 0000100493 |
11 | remainder_NetIncome | -413,900,000 | -287,250,900 | 0 | 275,510,000 | 1,040,000,000 | 0000023217 | 0001730773 | 0000016732 |
12 | remainder_ComprehensiveNetIncome | -450,000,000 | -85,200,000 | 0 | 52,180,800 | 188,000,000 | 0001103982 | 0000015357 | 0000016732 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 7,200 | 51,087 | 468,313,889 | 34,347,570,000 | 99,830,000,000 | 0001563227 | 0001655210 | 0001637459 |
1 | Liabilities | 261,082 | 603,080 | 134,273,391 | 21,156,670,000 | 49,587,000,000 | 0001563227 | 0000785956 | 0001637459 |
2 | Expenses | 133,863 | 1,024,631 | 626,207,975 | 22,983,290,000 | 40,691,000,000 | 0001563227 | 0001005286 | 0000100493 |
3 | Revenues | 0 | 24,167 | 591,582,849 | 25,329,160,000 | 43,185,000,000 | 0001563227 | 0001005286 | 0000100493 |
4 | StockholdersEquity | -161,000,000 | -4,194,906 | 238,245,400 | 25,778,010,000 | 50,243,000,000 | 0001772016 | 0000880117 | 0001637459 |
5 | NetIncome | -80,407,000 | -38,080,600 | 13,818,921 | 2,097,800,000 | 3,569,000,000 | 0000910406 | 0001320695 | 0001103982 |
6 | ComprehensiveNetIncome | -52,528,760 | -43,139,180 | 16,983,955 | 2,013,191,200 | 3,335,000,000 | 0000910406 | 0000785956 | 0001103982 |
7 | BaseVar | 274,028 | 2,983,438 | 1,704,000,926 | 102,956,605,400 | 129,766,415,000 | 0001563227 | 0001005286 | 0001637459 |
8 | EconomicCapitalRatio | -86.5 | -4.65 | 0.687 | 2.34 | 3.09 | 0001725911 | 0000063754 | 0001741231 |
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 | IntangibleAssets | -66.3 | -0.791 | -0.137 | 0.865 | 1.37 | 0001725911 | 0001579733 | 0001637459 |
1 | AssetsCurrent | -65.8 | -0.619 | -0.0748 | 0.567 | 2.09 | 0001725911 | 0001530950 | 0001650696 |
2 | PropertyPlantAndEquipment | -58.3 | -0.668 | 0.00478 | 0.393 | 0.803 | 0001725911 | 0000057515 | 0001563463 |
3 | remainder_Assets | -33.5 | -0.210 | -0.0328 | 0.105 | 0.344 | 0001725911 | 0001644406 | 0000098677 |
4 | LiabilitiesLongTerm | -54.2 | -1.13 | 0.0738 | 0.930 | 1.30 | 0001725911 | 0001005286 | 0000910329 |
5 | LiabilitiesCurrent | -63.6 | -0.237 | 0.546 | 3.84 | 8.74 | 0001725911 | 0001655210 | 0001572386 |
6 | remainder_Liabilities | -45.7 | -0.628 | 0.172 | 0.794 | 23.5 | 0001725911 | 0001320695 | 0001563227 |
7 | GeneralAndAdministrativeExpense | -1.80 | -0.695 | 0.135 | 0.421 | 1.60 | 0001487197 | 0000098677 | 0001725911 |
8 | SellingAndMarketingExpense | -0.665 | -0.454 | 0.0551 | 0.170 | 1.05 | 0000034563 | 0001593001 | 0001725911 |
9 | remainder_Expenses | -57.3 | -1.59 | 0.0278 | 0.925 | 1.07 | 0001725911 | 0001772016 | 0001572386 |
10 | remainder_Revenues | -24.5 | -1.25 | 0.339 | 2.03 | 3.65 | 0001725911 | 0000047111 | 0000910329 |
11 | remainder_NetIncome | -0.530 | -0.0948 | 0.0415 | 0.140 | 0.688 | 0001572386 | 0001611647 | 0001725911 |
12 | remainder_ComprehensiveNetIncome | -0.112 | -0.0293 | 0.00623 | 0.0238 | 0.121 | 0001612188 | 0000098677 | 0001725911 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -79.5 | -1.78 | -0.0108 | 0.840 | 1.03 | 0001725911 | 0000057515 | 0001637459 |
1 | Liabilities | -72.1 | -0.459 | 0.717 | 3.58 | 4.46 | 0001725911 | 0000014177 | 0001563227 |
2 | Expenses | -54.6 | -1.10 | -0.0744 | 0.575 | 0.700 | 0001725911 | 0001005286 | 0001741231 |
3 | Revenues | -24.5 | -1.25 | 0.339 | 2.03 | 3.65 | 0001725911 | 0000047111 | 0000910329 |
4 | StockholdersEquity | -5.49 | -2.78 | 0.331 | 1.77 | 2.26 | 0001725911 | 0000014177 | 0001650696 |
5 | NetIncome | -78.4 | -1.81 | 0.526 | 1.46 | 2.74 | 0001725911 | 0000910406 | 0000910329 |
6 | ComprehensiveNetIncome | -78.3 | -1.81 | 0.538 | 1.46 | 2.76 | 0001725911 | 0000040704 | 0000910329 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001063537 | 0000014177 |
8 | EconomicCapitalRatio | -84.8 | -3.02 | 2.32 | 3.98 | 4.72 | 0001725911 | 0000063754 | 0001741231 |
2021
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 3 × Negative Expenses, ignoring company. | pre-agg | |
warning | 46 × No stock price available | subcommand.plot |
0001409446
0001568139
0000016732
0000023217
0000034563
0000040704
0000047111
0000057515
0000063754
0000091419
0000098677
0000100493
0000785956
0000802481
0000910329
0000910406
0001005286
0001046257
0001320695
0001530950
0001579733
0001616262
0001637459
0001644406
0001650696
0001655210
0001691936
0001725911
0001741231
0001753706
0001772016
0001800373
0001830210
0000015357
0000812128
0001563463
0000880117
0001007019
0001117057
0001487197
0001572386
0001593001
0001612188
0001624517
0001730773
0001856608
|
warning | 11 × Ignoring company because Expenses is zero | pre-agg | |
warning | 10 × Similarly named company. Duplicate? | None | |
warning | 8 × Ignoring company because Assets is zero | pre-agg | |
warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.838658336979612}
|
warning | 1 × Missing logo | subcommand.report | |
warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 26,822,115 | 19,140,500,000 | 74,838,000,000 | 0000014177 | 0001655210 | 0001637459 |
1 | AssetsCurrent | 0 | 38,119 | 225,382,670 | 7,374,250,000 | 10,342,000,000 | 0001800373 | 0000880117 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 126,917,445 | 5,206,400,000 | 8,658,000,000 | 0001117057 | 0001830210 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 13,659,260 | 1,730,500,000 | 7,210,000,000 | 0000015357 | 0000014177 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 6,649,950 | 9,261,000,000 | 22,603,000,000 | 0000057515 | 0001741231 | 0001637459 |
5 | LiabilitiesCurrent | 159,266 | 481,476 | 92,334,320 | 7,295,400,000 | 14,008,000,000 | 0001800373 | 0001856608 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 7,600,834 | 3,272,200,000 | 12,275,000,000 | 0000057515 | 0001772016 | 0001637459 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 71,059,000 | 598,000,000 | 0000014177 | 0000057515 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 91,737,000 | 817,000,000 | 0000014177 | 0000047111 | 0000016732 |
9 | remainder_Expenses | 22,890 | 146,117 | 524,269,680 | 20,473,600,000 | 43,634,000,000 | 0001409446 | 0000098677 | 0000100493 |
10 | remainder_Revenues | 0 | 2,604 | 494,223,940 | 22,084,500,000 | 47,049,000,000 | 0001568139 | 0001753706 | 0000100493 |
11 | remainder_NetIncome | -355,000,000 | -216,349,000 | -12,538 | 66,850,000 | 696,000,000 | 0000100493 | 0001725911 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -86,300,000 | -5,590,000 | 0 | 122,150,000 | 479,000,000 | 0001772016 | 0001007019 | 0000040704 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 615 | 99,114 | 535,705,015 | 34,075,450,000 | 93,394,000,000 | 0001409446 | 0001830210 | 0001637459 |
1 | Liabilities | 159,266 | 482,747 | 196,037,975 | 17,514,000,000 | 43,942,000,000 | 0001800373 | 0000910329 | 0001637459 |
2 | Expenses | 22,890 | 294,690 | 524,269,680 | 20,473,600,000 | 43,634,000,000 | 0001409446 | 0000098677 | 0000100493 |
3 | Revenues | 0 | 2,604 | 494,223,940 | 22,084,500,000 | 47,049,000,000 | 0001568139 | 0001753706 | 0000100493 |
4 | StockholdersEquity | -65,500,000 | -1,444,164 | 217,428,955 | 19,350,550,000 | 49,452,000,000 | 0001772016 | 0001741231 | 0001637459 |
5 | NetIncome | -182,105,000 | -64,527,500 | 366,253 | 1,914,409,500 | 4,314,000,000 | 0001655210 | 0000015357 | 0001103982 |
6 | ComprehensiveNetIncome | -183,301,520 | -59,945,001 | 868,095 | 2,060,675,100 | 4,341,040,000 | 0001655210 | 0001007019 | 0001103982 |
7 | BaseVar | 301,662 | 977,262 | 1,799,111,436 | 86,338,796,500 | 122,779,145,000 | 0001568139 | 0001753706 | 0001637459 |
8 | EconomicCapitalRatio | -3.42 | -2.84 | 0.733 | 2.33 | 2.80 | 0001572386 | 0000040704 | 0000812128 |
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 | IntangibleAssets | -1.29 | -0.563 | -0.144 | 0.943 | 1.30 | 0001725911 | 0001616262 | 0001637459 |
1 | AssetsCurrent | -0.532 | -0.385 | -0.0641 | 0.794 | 2.57 | 0001563463 | 0000910406 | 0001593001 |
2 | PropertyPlantAndEquipment | -0.892 | -0.322 | -0.0139 | 0.426 | 0.788 | 0001725911 | 0000023217 | 0001563463 |
3 | remainder_Assets | -0.631 | -0.289 | -0.0778 | 0.466 | 3.70 | 0001725911 | 0000091419 | 0001800373 |
4 | LiabilitiesLongTerm | -1.15 | -0.782 | 0.0780 | 0.831 | 1.23 | 0001679273 | 0000023217 | 0000910329 |
5 | LiabilitiesCurrent | -0.334 | 0.0153 | 0.675 | 2.19 | 3.82 | 0001800373 | 0001063537 | 0001572386 |
6 | remainder_Liabilities | -1.69 | -0.489 | 0.0855 | 0.544 | 0.798 | 0001655210 | 0001800373 | 0000910329 |
7 | GeneralAndAdministrativeExpense | -1.31 | -0.708 | 0.0928 | 0.255 | 0.450 | 0001487197 | 0000091419 | 0000910329 |
8 | SellingAndMarketingExpense | -1.81 | -0.595 | 0.0553 | 0.152 | 0.268 | 0001691936 | 0000091419 | 0000910329 |
9 | remainder_Expenses | -2.90 | -2.19 | 0.0314 | 0.628 | 1.59 | 0001593001 | 0001679273 | 0001650696 |
10 | remainder_Revenues | -2.02 | -0.872 | 0.225 | 2.42 | 4.32 | 0001593001 | 0000016732 | 0000910329 |
11 | remainder_NetIncome | -0.538 | -0.155 | 0.00566 | 0.286 | 2.01 | 0001563463 | 0001772016 | 0001593001 |
12 | remainder_ComprehensiveNetIncome | -0.160 | -0.0578 | -0.0169 | 0.0466 | 1.45 | 0001772016 | 0000016732 | 0001650696 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -1.96 | -1.18 | -0.00451 | 0.828 | 1.84 | 0001725911 | 0000785956 | 0001800373 |
1 | Liabilities | -0.529 | -0.146 | 0.552 | 2.44 | 3.02 | 0001655210 | 0001730773 | 0000812128 |
2 | Expenses | -2.51 | -1.77 | -0.124 | 0.449 | 0.634 | 0001593001 | 0000910406 | 0001409446 |
3 | Revenues | -2.02 | -0.872 | 0.225 | 2.42 | 4.32 | 0001593001 | 0000016732 | 0000910329 |
4 | StockholdersEquity | -2.80 | -2.49 | 0.546 | 1.66 | 2.06 | 0001409446 | 0001856608 | 0001611647 |
5 | NetIncome | -2.52 | -1.63 | 0.294 | 1.40 | 2.34 | 0001593001 | 0001644406 | 0000910329 |
6 | ComprehensiveNetIncome | -2.57 | -1.67 | 0.306 | 1.35 | 2.26 | 0001593001 | 0001320695 | 0000910329 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001409446 | 0000014177 |
8 | EconomicCapitalRatio | -3.88 | -3.31 | 0.266 | 1.86 | 2.34 | 0001572386 | 0000040704 | 0000812128 |
2022
Logs
error | 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 3 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × IME and Company effects mismatched for Other Expenses. IME Effects: 88.3, Company Effect: 88.2 | subcommand.report | |
warning | 35 × No stock price available | subcommand.plot |
0001278027
0000014177
0000023217
0000055067
0000057515
0000098677
0000785956
0000802481
0000910329
0001005286
0001046257
0001063537
0001103982
0001530950
0001644406
0001650696
0001655210
0001679273
0001753706
0001772016
0001830210
0001856608
0000015357
0000730349
0000814586
0000880117
0001007019
0001487197
0001572386
0001593001
0001611647
0001612188
0001624517
0001691936
0001730773
|
warning | 11 × Ignoring company because Expenses is zero | pre-agg | |
warning | 8 × Ignoring company because Assets is zero | pre-agg | |
warning | 5 × Similarly named company. Duplicate? | None | |
warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × equityII differs from equityI | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.2661044197010165}
|
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Missing logo | subcommand.report | |
warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × Ignoring company because ECR is too negative | pre-agg |
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 | IntangibleAssets | 0 | 0 | 43,990,600 | 19,071,700,000 | 73,482,000,000 | 0000014177 | 0000034563 | 0001637459 |
1 | AssetsCurrent | 23,688 | 71,953 | 309,107,030 | 6,493,400,000 | 10,091,000,000 | 0001409446 | 0000098677 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 132,599,890 | 5,264,500,000 | 9,020,000,000 | 0000730349 | 0000880117 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 19,635,125 | 1,883,500,000 | 8,230,000,000 | 0000015357 | 0000880117 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 15,609,945 | 8,143,700,000 | 23,453,000,000 | 0000055067 | 0001741231 | 0001103982 |
5 | LiabilitiesCurrent | 365,162 | 1,101,758 | 93,517,345 | 7,184,450,000 | 16,731,000,000 | 0000015357 | 0001741231 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 10,219,870 | 3,137,650,000 | 11,773,000,000 | 0000055067 | 0001005286 | 0001637459 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 87,321,000 | 617,000,000 | 0000014177 | 0000023217 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 105,286,500 | 734,000,000 | 0000014177 | 0000040704 | 0000016732 |
9 | remainder_Expenses | 54,275 | 300,970 | 761,796,325 | 20,546,694,500 | 49,772,000,000 | 0001572386 | 0001655210 | 0000100493 |
10 | remainder_Revenues | 0 | 42,880 | 687,927,005 | 22,738,900,000 | 53,282,000,000 | 0001409446 | 0000098677 | 0000100493 |
11 | remainder_NetIncome | -343,716,000 | -222,800,000 | -569,509 | 194,550,000 | 743,300,000 | 0000047111 | 0001572386 | 0001530950 |
12 | remainder_ComprehensiveNetIncome | -991,000,000 | -298,579,500 | -86,588 | 25,970,500 | 431,000,000 | 0001637459 | 0000910329 | 0000040704 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 27,542 | 102,242 | 849,851,880 | 33,955,550,000 | 90,513,000,000 | 0001572386 | 0001753706 | 0001637459 |
1 | Liabilities | 496,208 | 1,194,674 | 235,944,130 | 16,937,500,000 | 44,241,000,000 | 0000015357 | 0000098677 | 0001103982 |
2 | Expenses | 268,669 | 654,841 | 762,369,020 | 20,546,694,500 | 49,772,000,000 | 0001409446 | 0001655210 | 0000100493 |
3 | Revenues | 0 | 42,880 | 687,927,005 | 22,738,900,000 | 53,282,000,000 | 0001409446 | 0000098677 | 0000100493 |
4 | StockholdersEquity | -376,200,000 | -6,307,464 | 274,572,350 | 19,533,500,000 | 48,870,000,000 | 0001772016 | 0001753706 | 0001637459 |
5 | NetIncome | -366,137,000 | -134,694,000 | 925,530 | 2,547,000,000 | 3,249,000,000 | 0001655210 | 0000814586 | 0000100493 |
6 | ComprehensiveNetIncome | -368,346,480 | -136,509,320 | 573,442 | 2,203,020,000 | 3,178,280,000 | 0001655210 | 0001579733 | 0000100493 |
7 | BaseVar | 1,201,126 | 2,906,679 | 2,248,781,398 | 92,071,974,500 | 129,173,295,000 | 0001409446 | 0000880117 | 0000100493 |
8 | EconomicCapitalRatio | -6.91 | -3.27 | 0.655 | 2.22 | 2.41 | 0001593001 | 0000802481 | 0000014177 |
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 | IntangibleAssets | -2.63 | -1.52 | -0.268 | 0.818 | 1.31 | 0001593001 | 0000910329 | 0001637459 |
1 | AssetsCurrent | -0.452 | -0.346 | -0.0299 | 0.739 | 3.33 | 0001409446 | 0000910406 | 0001593001 |
2 | PropertyPlantAndEquipment | -1.57 | -0.857 | 0.00237 | 0.386 | 0.772 | 0001593001 | 0000023217 | 0001611647 |
3 | remainder_Assets | -0.698 | -0.328 | -0.0315 | 0.230 | 2.10 | 0001593001 | 0000785956 | 0001117057 |
4 | LiabilitiesLongTerm | -1.38 | -1.000 | -0.00492 | 0.978 | 1.64 | 0001772016 | 0001830210 | 0000910329 |
5 | LiabilitiesCurrent | -2.43 | -0.0357 | 0.418 | 2.19 | 4.74 | 0001409446 | 0001679273 | 0001572386 |
6 | remainder_Liabilities | -1.51 | -0.476 | 0.0515 | 0.474 | 0.931 | 0001655210 | 0001856608 | 0000910329 |
7 | GeneralAndAdministrativeExpense | -3.14 | -0.788 | 0.0980 | 0.237 | 0.524 | 0001650696 | 0001753706 | 0000910329 |
8 | SellingAndMarketingExpense | -1.56 | -1.08 | 0.0780 | 0.212 | 0.468 | 0001593001 | 0001530950 | 0000910329 |
9 | remainder_Expenses | -3.23 | -1.90 | 0.0113 | 0.579 | 1.33 | 0000910329 | 0001655210 | 0001650696 |
10 | remainder_Revenues | -2.44 | -0.869 | 0.0876 | 2.04 | 5.06 | 0001593001 | 0000016732 | 0000910329 |
11 | remainder_NetIncome | -0.976 | -0.247 | 0.00382 | 0.153 | 1.59 | 0001117057 | 0001007019 | 0001409446 |
12 | remainder_ComprehensiveNetIncome | -0.0743 | -0.0330 | 0.00499 | 0.0283 | 0.0714 | 0001117057 | 0000047111 | 0000014177 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -2.71 | -1.65 | -0.0428 | 0.710 | 1.04 | 0001593001 | 0000100493 | 0001637459 |
1 | Liabilities | -1.33 | -0.522 | 0.195 | 2.15 | 3.00 | 0001409446 | 0001691936 | 0000910329 |
2 | Expenses | -4.33 | -2.50 | 0.110 | 0.549 | 0.614 | 0001593001 | 0001046257 | 0001409446 |
3 | Revenues | -2.44 | -0.869 | 0.0876 | 2.04 | 5.06 | 0001593001 | 0000016732 | 0000910329 |
4 | StockholdersEquity | -2.80 | -2.54 | 0.426 | 1.54 | 2.06 | 0001572386 | 0000063754 | 0001611647 |
5 | NetIncome | -6.74 | -2.44 | 0.373 | 1.13 | 2.87 | 0001593001 | 0000091419 | 0000910329 |
6 | ComprehensiveNetIncome | -6.73 | -2.44 | 0.380 | 1.15 | 2.89 | 0001593001 | 0001644406 | 0000910329 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001117057 | 0000014177 |
8 | EconomicCapitalRatio | -7.03 | -3.39 | 0.533 | 2.10 | 2.29 | 0001593001 | 0000802481 | 0000014177 |
2023
Logs
warning | 10 × Similarly named company. Duplicate? | None | |
warning | 10 × No stock price available | subcommand.plot | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.78523652186074}
|
warning | 1 × Missing logo | subcommand.report |
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 | IntangibleAssets | 0 | 0 | 80,602,343 | 20,378,240,000 | 72,907,000,000 | 0000014177 | 0000098677 | 0001637459 |
1 | AssetsCurrent | 0 | 3,440 | 372,851,124 | 7,378,480,000 | 11,703,000,000 | 0001800373 | 0001655210 | 0001103982 |
2 | PropertyPlantAndEquipment | 0 | 0 | 135,738,686 | 6,424,840,000 | 9,694,000,000 | 0000730349 | 0000880117 | 0001103982 |
3 | remainder_Assets | 0 | 0 | 22,563,579 | 1,909,800,000 | 5,579,000,000 | 0000015357 | 0001117057 | 0001103982 |
4 | LiabilitiesLongTerm | 0 | 0 | 13,429,920 | 10,147,220,000 | 20,812,000,000 | 0000055067 | 0000880117 | 0001637459 |
5 | LiabilitiesCurrent | 0 | 853,395 | 98,968,059 | 7,328,360,000 | 19,013,000,000 | 0001800373 | 0001753706 | 0001103982 |
6 | remainder_Liabilities | 0 | 0 | 34,029,598 | 5,222,040,000 | 11,768,000,000 | 0000055067 | 0000880117 | 0001637459 |
7 | GeneralAndAdministrativeExpense | 0 | 0 | 0 | 69,260,800 | 654,000,000 | 0000014177 | 0000047111 | 0000016732 |
8 | SellingAndMarketingExpense | 0 | 0 | 0 | 108,836,600 | 811,000,000 | 0000014177 | 0000040704 | 0000016732 |
9 | remainder_Expenses | 0 | 426,152 | 811,188,737 | 22,615,700,000 | 53,247,000,000 | 0001409446 | 0000880117 | 0000100493 |
10 | remainder_Revenues | 0 | 28,563 | 999,777,234 | 25,330,840,000 | 52,881,000,000 | 0001409446 | 0000880117 | 0000100493 |
11 | remainder_NetIncome | -1,144,400,000 | -284,880,000 | -6,169 | 301,180,000 | 1,029,000,000 | 0000091419 | 0000015357 | 0001103982 |
12 | remainder_ComprehensiveNetIncome | -323,000,000 | -28,480,000 | 0 | 121,460,000 | 215,000,000 | 0000055067 | 0001800373 | 0001637459 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 20.0 | 158,433 | 826,835,254 | 35,291,140,000 | 90,339,000,000 | 0001624517 | 0001753706 | 0001637459 |
1 | Liabilities | 143,334 | 909,229 | 262,382,605 | 19,250,420,000 | 43,025,000,000 | 0001800373 | 0000098677 | 0001103982 |
2 | Expenses | 112,283 | 444,712 | 932,061,546 | 22,615,700,000 | 53,247,000,000 | 0001409446 | 0000880117 | 0000100493 |
3 | Revenues | 0 | 28,563 | 999,777,234 | 25,330,840,000 | 52,881,000,000 | 0001409446 | 0000880117 | 0000100493 |
4 | StockholdersEquity | -513,368,000 | -2,773,559 | 293,253,241 | 24,832,800,000 | 49,722,000,000 | 0001655210 | 0000880117 | 0001637459 |
5 | NetIncome | -649,000,000 | -116,292,000 | 171,761 | 2,460,037,400 | 4,968,000,000 | 0000100493 | 0000015357 | 0001103982 |
6 | ComprehensiveNetIncome | -629,240,000 | -109,844,040 | 171,157 | 2,328,358,320 | 4,963,840,000 | 0000100493 | 0000015357 | 0001103982 |
7 | BaseVar | 312,741 | 1,752,778 | 2,352,328,219 | 108,086,418,300 | 132,614,205,000 | 0001800373 | 0000910329 | 0000100493 |
8 | EconomicCapitalRatio | -10.9 | -3.79 | 0.728 | 2.25 | 2.37 | 0001593001 | 0001320695 | 0000057515 |
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 | IntangibleAssets | -3.47 | -1.44 | -0.200 | 0.730 | 1.30 | 0001593001 | 0001611647 | 0001637459 |
1 | AssetsCurrent | -1.62 | -0.790 | -0.0134 | 0.743 | 1.16 | 0001593001 | 0001320695 | 0001650696 |
2 | PropertyPlantAndEquipment | -2.19 | -0.608 | -0.0240 | 0.327 | 1.02 | 0001593001 | 0000063754 | 0001611647 |
3 | remainder_Assets | -1.43 | -0.565 | -0.0675 | 0.358 | 4.71 | 0001593001 | 0000100493 | 0001800373 |
4 | LiabilitiesLongTerm | -1.39 | -1.05 | 0.0476 | 0.988 | 1.33 | 0001593001 | 0001655210 | 0000910329 |
5 | LiabilitiesCurrent | -0.157 | -0.0517 | 0.347 | 2.40 | 9.47 | 0001117057 | 0001046257 | 0001624517 |
6 | remainder_Liabilities | -1.31 | -0.963 | 0.172 | 0.830 | 1.26 | 0001655210 | 0001753706 | 0000910329 |
7 | GeneralAndAdministrativeExpense | -1.34 | -1.12 | 0.130 | 0.337 | 0.570 | 0001650696 | 0000040704 | 0000910329 |
8 | SellingAndMarketingExpense | -1.84 | -1.01 | 0.0684 | 0.182 | 0.307 | 0001650696 | 0001530950 | 0000910329 |
9 | remainder_Expenses | -2.78 | -1.61 | 0.0640 | 0.816 | 1.03 | 0000910329 | 0001753706 | 0001800373 |
10 | remainder_Revenues | -3.42 | -1.01 | 0.130 | 2.09 | 3.62 | 0001593001 | 0000016732 | 0000910329 |
11 | remainder_NetIncome | -5.84 | -0.615 | 0.192 | 0.584 | 0.783 | 0001593001 | 0000016732 | 0000910329 |
12 | remainder_ComprehensiveNetIncome | -0.0365 | -0.0113 | -0.00193 | 0.0205 | 0.0320 | 0000055067 | 0001772016 | 0000034563 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -5.99 | -2.49 | 0.0385 | 0.629 | 1.72 | 0001593001 | 0001046257 | 0001800373 |
1 | Liabilities | -0.747 | -0.375 | 0.333 | 2.57 | 4.22 | 0001655210 | 0001611647 | 0001624517 |
2 | Expenses | -2.47 | -1.83 | 0.0377 | 0.598 | 0.939 | 0001650696 | 0001655210 | 0001593001 |
3 | Revenues | -3.42 | -1.01 | 0.130 | 2.09 | 3.62 | 0001593001 | 0000016732 | 0000910329 |
4 | StockholdersEquity | -3.04 | -2.33 | 0.394 | 1.34 | 1.56 | 0001725911 | 0001320695 | 0000785956 |
5 | NetIncome | -8.32 | -2.16 | 0.447 | 1.40 | 2.50 | 0001593001 | 0000063754 | 0000910329 |
6 | ComprehensiveNetIncome | -8.32 | -2.16 | 0.456 | 1.40 | 2.49 | 0001593001 | 0000063754 | 0000910329 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000014177 | 0001046257 | 0000014177 |
8 | EconomicCapitalRatio | -10.9 | -3.84 | 0.675 | 2.20 | 2.32 | 0001593001 | 0001320695 | 0000057515 |
Estimates
Parameter | Value | Min | Max |
---|---|---|---|
PresentValueFactor | 2.09 | 1.0 | 15.0 |
BalanceFactor | 1.36 | 0.5 | 5.0 |
OCIFactor | 0.52 | 0.5 | 1.0 |
HiddenReservesFactor | 0.0 | 0.0 | 0.0 |
LLPO_stddev | 1.24 | 0.2 | 10.0 |