Ranks across the years
name | name_short | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2016-val | 2017-val | 2018-val | 2019-val | 2020-val | 2021-val | 2022-val | 2016->2017 | 2017->2018 | 2018->2019 | 2019->2020 | 2020->2021 | 2021->2022 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0000050471 | PARK CITY GROUP INC | PARK CI | 3 | 3 | 2 | 2 | 4 | 2 | 1 | 110.02600 | 117.82300 | 122.1620 | 125.5600 | 113.60400 | 126.655000 | 140.59300 | 0 | -1 | 0 | 2 | -2 | -1 |
0001494259 | CarGurus Inc. | CarGuru | NaN | 5 | 1 | 3 | 2 | 4 | 2 | NaN | 104.01100 | 130.9220 | 95.1547 | 122.38300 | 112.256000 | 132.18100 | NaN | -4 | 2 | -1 | 2 | -2 |
0001625278 | NERDWALLET INC. | NERDWAL | NaN | NaN | NaN | NaN | NaN | 7 | 3 | NaN | NaN | NaN | NaN | NaN | 71.666800 | 105.39300 | NaN | NaN | NaN | NaN | NaN | -4 |
0000909494 | TUCOWS INC PA | TUCOWS | 15 | 15 | 14 | 6 | 7 | 5 | 4 | 62.52030 | 61.73010 | 63.0561 | 81.4203 | 79.55110 | 84.516600 | 85.26960 | 0 | -1 | -8 | 1 | -2 | -1 |
0001419951 | Data Storage Corp | Data St | 30 | NaN | NaN | NaN | NaN | 3 | 5 | 10.55790 | NaN | NaN | NaN | NaN | 125.130000 | 76.15210 | NaN | NaN | NaN | NaN | NaN | 2 |
0001559865 | EVERTEC Inc. | EVERTEC | 27 | 28 | 24 | 18 | 19 | 11 | 6 | 19.11200 | 21.46930 | 30.5222 | 36.5330 | 40.71410 | 60.121800 | 73.78830 | 1 | -4 | -6 | 1 | -8 | -5 |
0001549346 | Shutterstock Inc. | Shutter | 12 | 10 | 12 | 9 | 6 | 6 | 7 | 71.73140 | 68.53790 | 73.8984 | 62.0526 | 80.25800 | 76.591900 | 66.68060 | -2 | 2 | -3 | -3 | 0 | 1 |
0001829864 | TaskUs Inc. | TaskUs | NaN | NaN | NaN | NaN | NaN | 21 | 8 | NaN | NaN | NaN | NaN | NaN | 44.004100 | 60.15060 | NaN | NaN | NaN | NaN | NaN | -13 |
0001645070 | Sterling Check Corp. | Sterlin | NaN | NaN | NaN | NaN | NaN | 13 | 9 | NaN | NaN | NaN | NaN | NaN | 55.275700 | 59.52800 | NaN | NaN | NaN | NaN | NaN | -4 |
0001606745 | Liberty TripAdvisor Holdings Inc. | Liberty | 6 | 22 | 7 | 5 | 13 | 15 | 10 | 98.35190 | 41.48190 | 91.0167 | 84.2406 | 52.54140 | 53.800500 | 54.20130 | 16 | -15 | -2 | 8 | 2 | -5 |
0001809519 | GoodRx Holdings Inc. | GoodRx | NaN | NaN | NaN | NaN | 26 | 14 | 11 | NaN | NaN | NaN | NaN | 25.99450 | 55.104200 | 53.06720 | NaN | NaN | NaN | NaN | -12 | -3 |
0001650164 | Toast Inc. | Toast I | NaN | NaN | NaN | NaN | NaN | 25 | 12 | NaN | NaN | NaN | NaN | NaN | 34.184100 | 51.51490 | NaN | NaN | NaN | NaN | NaN | -13 |
0001236275 | SilverSun Technologies Inc. | SilverS | NaN | NaN | NaN | NaN | NaN | 12 | 13 | NaN | NaN | NaN | NaN | NaN | 56.591300 | 45.31790 | NaN | NaN | NaN | NaN | NaN | 1 |
0001313275 | BRIGHTCOVE INC | BRIGHTC | 19 | 25 | 17 | 21 | 18 | 16 | 14 | 55.33030 | 37.76000 | 44.6027 | 28.7506 | 40.85500 | 49.814200 | 41.88110 | 6 | -8 | 4 | -3 | -2 | -2 |
0001597846 | Greenpro Capital Corp. | Greenpr | NaN | NaN | 31 | 23 | 23 | 33 | 15 | NaN | NaN | -57.7593 | 19.1010 | 30.10800 | 9.568000 | 40.26950 | NaN | NaN | -8 | 0 | 10 | -18 |
0001683606 | Cars.com Inc. | Cars.co | NaN | 7 | NaN | NaN | NaN | 23 | 16 | NaN | 95.80330 | NaN | NaN | NaN | 38.046900 | 40.16560 | NaN | NaN | NaN | NaN | NaN | -7 |
0001442145 | Verisk Analytics Inc. | Verisk | 23 | 19 | 18 | 16 | 15 | 19 | 17 | 32.15560 | 46.90820 | 43.5291 | 40.6555 | 48.87450 | 46.629400 | 34.01070 | -4 | -1 | -2 | -1 | 4 | -2 |
0001389002 | MARIN SOFTWARE INC | MARIN S | 8 | 21 | 30 | 28 | 33 | 8 | 18 | 85.69590 | 42.70320 | -54.5552 | 15.1157 | -3.71699 | 68.226700 | 33.72910 | 13 | 9 | -2 | 5 | -25 | 10 |
0001723648 | LiveVox Holdings Inc. | LiveVox | NaN | NaN | NaN | NaN | NaN | 37 | 19 | NaN | NaN | NaN | NaN | NaN | -0.669865 | 31.29500 | NaN | NaN | NaN | NaN | NaN | -18 |
0001005757 | CSG SYSTEMS INTERNATIONAL INC | CSG SYS | 22 | 18 | 19 | 17 | 21 | 24 | 20 | 37.87860 | 48.96140 | 37.2712 | 37.9336 | 36.88780 | 36.513000 | 26.89220 | -4 | 1 | -2 | 4 | 3 | -4 |
0001286139 | LEGALZOOM.COM INC. | LEGALZO | NaN | NaN | NaN | NaN | NaN | 28 | 21 | NaN | NaN | NaN | NaN | NaN | 19.672500 | 21.33600 | NaN | NaN | NaN | NaN | NaN | -7 |
0001288847 | Five9 Inc. | Five9 I | 28 | 27 | 20 | 15 | 27 | 32 | 22 | 14.44240 | 28.09600 | 36.1096 | 40.9247 | 20.18520 | 10.990300 | 14.42130 | -1 | -7 | -5 | 12 | 5 | -10 |
0001627475 | UPWORK INC | UPWORK | NaN | NaN | 13 | 10 | 11 | 29 | 23 | NaN | NaN | 66.7273 | 61.9162 | 58.63640 | 16.457900 | 11.68010 | NaN | NaN | -3 | 1 | 18 | -6 |
0001615165 | Veritone Inc. | Veriton | NaN | 34 | 28 | 35 | 29 | 38 | 24 | NaN | -16.35100 | -13.1670 | -27.3000 | 18.32750 | -1.009390 | 10.38100 | NaN | -6 | 7 | -6 | 9 | -14 |
0000903651 | INNODATA INC | INNODAT | 11 | 9 | 9 | 7 | 14 | 22 | 25 | 75.22390 | 71.14550 | 83.4741 | 79.4170 | 50.13480 | 40.693900 | 7.55201 | -2 | 0 | -2 | 7 | 8 | 3 |
0001764046 | CLARIVATE Plc | CLARIVA | NaN | NaN | NaN | 22 | 8 | 9 | 26 | NaN | NaN | NaN | 28.7456 | 79.50830 | 65.704000 | 6.01073 | NaN | NaN | NaN | -14 | 1 | 17 |
0000008670 | AUTOMATIC DATA PROCESSING INC | AUTOMAT | 29 | 29 | 26 | 24 | NaN | 31 | 27 | 12.58270 | 13.72620 | 11.8736 | 18.2282 | NaN | 15.833200 | 5.84056 | 0 | -3 | -2 | NaN | NaN | -4 |
0001719489 | Kaleyra Inc. | Kaleyra | NaN | NaN | NaN | 34 | 36 | 30 | 28 | NaN | NaN | NaN | -27.2413 | -29.29370 | 16.190300 | -19.22710 | NaN | NaN | NaN | 2 | -6 | -2 |
0001013857 | PEGASYSTEMS INC | PEGASYS | 16 | 13 | 11 | 13 | 24 | 27 | 29 | 61.39710 | 63.53440 | 76.4610 | 49.1606 | 29.51510 | 19.784500 | -19.68450 | -3 | -2 | 2 | 11 | 3 | 2 |
0001691077 | EVmo Inc. | EVmo In | NaN | NaN | NaN | 32 | 38 | 43 | 30 | NaN | NaN | NaN | -18.5888 | -43.10510 | -116.711000 | -20.79550 | NaN | NaN | NaN | 6 | 5 | -13 |
0001829280 | Forian Inc. | Forian | NaN | NaN | NaN | NaN | 10 | 39 | 31 | NaN | NaN | NaN | NaN | 61.53710 | -13.355400 | -39.41760 | NaN | NaN | NaN | NaN | 29 | -8 |
0001801661 | Skillz Inc. | Skillz | NaN | NaN | NaN | NaN | 17 | 20 | 32 | NaN | NaN | NaN | NaN | 42.60140 | 46.388300 | -43.95430 | NaN | NaN | NaN | NaN | 3 | 12 |
0001384905 | RingCentral Inc. | RingCen | 21 | 16 | 23 | 12 | 30 | 35 | 33 | 42.39390 | 52.64400 | 31.7413 | 51.7293 | 8.77032 | 2.558160 | -50.59870 | -5 | 7 | -11 | 18 | 5 | -2 |
0001853825 | THUMZUP MEDIA Corp | THUMZUP | NaN | NaN | NaN | NaN | NaN | 52 | 34 | NaN | NaN | NaN | NaN | NaN | -209.951000 | -55.07680 | NaN | NaN | NaN | NaN | NaN | -18 |
0001014052 | Digerati Technologies Inc. | Digerat | NaN | NaN | NaN | NaN | NaN | 45 | 35 | NaN | NaN | NaN | NaN | NaN | -123.603000 | -55.91230 | NaN | NaN | NaN | NaN | NaN | -10 |
0001022505 | SideChannel Inc. | SideCha | 41 | 45 | 5 | 33 | 50 | 26 | 36 | -396.46600 | -856.25300 | 98.9192 | -21.3026 | -373.11700 | 29.458400 | -67.07220 | 4 | -40 | 28 | 17 | -24 | 10 |
0001665300 | Phunware Inc. | Phunwar | NaN | NaN | NaN | NaN | NaN | 36 | 37 | NaN | NaN | NaN | NaN | NaN | -0.013292 | -72.20650 | NaN | NaN | NaN | NaN | NaN | 1 |
0001482554 | Hartford Great Health Corp. | Hartfor | 44 | 40 | 45 | 29 | 40 | 41 | 38 | -1192.85000 | -285.39100 | -2184.9000 | 14.2281 | -61.56170 | -79.173200 | -85.58870 | -4 | 5 | -16 | 11 | 1 | -3 |
0001554818 | AUDDIA INC. | AUDDIA | NaN | NaN | NaN | NaN | 42 | 44 | 39 | NaN | NaN | NaN | NaN | -166.93300 | -116.890000 | -89.34410 | NaN | NaN | NaN | NaN | 2 | -5 |
0001386049 | Beyond Commerce Inc. | Beyond | NaN | NaN | 35 | 38 | 43 | 48 | 40 | NaN | NaN | -206.4630 | -73.8036 | -185.09000 | -172.882000 | -92.74650 | NaN | NaN | 3 | 5 | 5 | -8 |
0001566469 | NantHealth Inc. | NantHea | 24 | 33 | 33 | 36 | 39 | 40 | 41 | 32.05890 | -4.73795 | -66.6968 | -37.1065 | -57.66830 | -68.550900 | -92.93580 | 9 | 0 | 3 | 3 | 1 | 1 |
0001735092 | Gofba Inc. | Gofba I | NaN | NaN | NaN | NaN | 44 | 49 | 42 | NaN | NaN | NaN | NaN | -186.10400 | -173.128000 | -139.15000 | NaN | NaN | NaN | NaN | 5 | -7 |
0001683252 | TOKEN COMMUNITIES LTD. | TOKEN C | NaN | NaN | NaN | NaN | NaN | 54 | 43 | NaN | NaN | NaN | NaN | NaN | -337.831000 | -212.81600 | NaN | NaN | NaN | NaN | NaN | -11 |
0001688126 | Crypto Co | Crypto | NaN | NaN | 37 | 44 | NaN | 42 | 44 | NaN | NaN | -238.6350 | -348.9610 | NaN | -79.822200 | -264.77400 | NaN | NaN | 7 | NaN | NaN | 2 |
0001499961 | MULLEN AUTOMOTIVE INC. | MULLEN | 34 | 32 | 27 | 31 | 35 | NaN | 45 | -52.06070 | 3.18554 | 11.2318 | -15.1602 | -15.20910 | NaN | -272.90300 | -2 | -5 | 4 | 4 | NaN | NaN |
0001131903 | SPECTRAL CAPITAL Corp | SPECTRA | NaN | NaN | 36 | 39 | 45 | 51 | 46 | NaN | NaN | -211.6390 | -202.4460 | -194.73500 | -191.204000 | -302.64500 | NaN | NaN | 3 | 6 | 6 | -5 |
0001864448 | Wejo Group Ltd | Wejo Gr | NaN | NaN | NaN | NaN | NaN | 46 | 47 | NaN | NaN | NaN | NaN | NaN | -149.059000 | -309.90300 | NaN | NaN | NaN | NaN | NaN | 1 |
0001884164 | KwikClick Inc. | KwikCli | NaN | NaN | NaN | NaN | NaN | 50 | 48 | NaN | NaN | NaN | NaN | NaN | -186.020000 | -356.65100 | NaN | NaN | NaN | NaN | NaN | -2 |
0001435617 | POWERDYNE INTERNATIONAL INC. | POWERDY | 37 | NaN | NaN | NaN | 46 | 47 | 49 | -206.87800 | NaN | NaN | NaN | -204.75800 | -160.730000 | -423.09000 | NaN | NaN | NaN | NaN | 1 | 2 |
0001755101 | APPlife Digital Solutions Inc | APPlife | NaN | NaN | NaN | 41 | 51 | 57 | 50 | NaN | NaN | NaN | -282.4610 | -576.72400 | -529.042000 | -627.89700 | NaN | NaN | NaN | 10 | 6 | -7 |
0001784440 | Nowtransit Inc | Nowtran | NaN | NaN | NaN | NaN | 28 | 56 | 51 | NaN | NaN | NaN | NaN | 19.89280 | -485.519000 | -1803.42000 | NaN | NaN | NaN | NaN | 28 | -5 |
0000714603 | DST SYSTEMS INC | DST SYS | 17 | 14 | NaN | NaN | NaN | NaN | NaN | 60.53550 | 62.74090 | NaN | NaN | NaN | NaN | NaN | -3 | NaN | NaN | NaN | NaN | NaN |
0000855612 | ZIX CORP | ZIX COR | 10 | 20 | 8 | 20 | 25 | NaN | NaN | 79.68180 | 46.39850 | 88.1861 | 31.5156 | 29.06790 | NaN | NaN | 10 | -12 | 12 | 5 | NaN | NaN |
0001053374 | IPASS INC | IPASS I | 25 | 36 | NaN | NaN | NaN | NaN | NaN | 31.46100 | -110.54500 | NaN | NaN | NaN | NaN | NaN | 11 | NaN | NaN | NaN | NaN | NaN |
0001083301 | TERAWULF INC. | TERAWUL | 7 | 6 | 4 | 4 | 5 | NaN | NaN | 94.85610 | 99.56050 | 100.2470 | 85.9154 | 97.40660 | NaN | NaN | -1 | -2 | 0 | 1 | NaN | NaN |
0001095277 | INTERSECTIONS INC | INTERSE | 33 | 35 | NaN | NaN | NaN | NaN | NaN | -49.67730 | -29.96170 | NaN | NaN | NaN | NaN | NaN | 2 | NaN | NaN | NaN | NaN | NaN |
0001104188 | SOHU COM INC | SOHU CO | 18 | 23 | NaN | NaN | NaN | NaN | NaN | 56.38970 | 39.12730 | NaN | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN | NaN |
0001212458 | PROOFPOINT INC | PROOFPO | 32 | 30 | 22 | 26 | 31 | NaN | NaN | -9.54252 | 12.44660 | 32.4065 | 17.4201 | 8.71090 | NaN | NaN | -2 | -8 | 4 | 5 | NaN | NaN |
0001340127 | Carbonite Inc | Carboni | 31 | 31 | 16 | NaN | NaN | NaN | NaN | 1.38314 | 8.38966 | 50.7522 | NaN | NaN | NaN | NaN | 0 | -15 | NaN | NaN | NaN | NaN |
0001353499 | Max Sound Corp | Max Sou | 40 | 39 | NaN | NaN | NaN | NaN | NaN | -351.13200 | -263.83400 | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN | NaN |
0001365038 | LEAF GROUP LTD. | LEAF GR | 4 | 26 | 15 | 25 | 12 | NaN | NaN | 103.23600 | 31.39640 | 50.9212 | 17.5368 | 54.37990 | NaN | NaN | 22 | -11 | 10 | -13 | NaN | NaN |
0001402453 | Her Imports | Her Imp | 2 | 1 | 32 | NaN | NaN | NaN | NaN | 110.12400 | 149.92400 | -64.5991 | NaN | NaN | NaN | NaN | -1 | 31 | NaN | NaN | NaN | NaN |
0001433714 | CASTLIGHT HEALTH INC. | CASTLIG | 26 | 17 | 10 | 8 | 20 | NaN | NaN | 23.67550 | 51.32670 | 76.8007 | 65.0839 | 37.56690 | NaN | NaN | -9 | -7 | -2 | 12 | NaN | NaN |
0001439404 | ZYNGA INC | ZYNGA I | 5 | 2 | 6 | 11 | 16 | 17 | NaN | 99.65470 | 121.48400 | 96.3911 | 61.8909 | 43.45310 | 49.785200 | NaN | -3 | 4 | 5 | 5 | 1 | NaN |
0001458962 | MINDBODY Inc. | MINDBOD | 14 | 4 | NaN | NaN | NaN | NaN | NaN | 65.11150 | 109.49100 | NaN | NaN | NaN | NaN | NaN | -10 | NaN | NaN | NaN | NaN | NaN |
0001463172 | Zendesk Inc. | Zendesk | 20 | 24 | 25 | 27 | 32 | 34 | NaN | 42.62050 | 39.04330 | 20.1511 | 16.5066 | 7.13599 | 7.493320 | NaN | 4 | 1 | 2 | 5 | 2 | NaN |
0001487931 | FISION Corp | FISION | 39 | 42 | 38 | 43 | 48 | NaN | NaN | -303.72100 | -399.28900 | -252.6220 | -347.6890 | -227.25800 | NaN | NaN | 3 | -4 | 5 | 5 | NaN | NaN |
0001507605 | MARATHON DIGITAL HOLDINGS INC. | MARATHO | 36 | 37 | 41 | 30 | NaN | 18 | NaN | -157.31300 | -217.04800 | -272.4120 | -10.9666 | NaN | 47.338000 | NaN | 1 | 4 | -11 | NaN | NaN | NaN |
0001510247 | LGBTQ Loyalty Holdings Inc. | LGBTQ L | 38 | 38 | 42 | 45 | 49 | 55 | NaN | -241.56200 | -229.68400 | -357.1780 | -459.5380 | -294.50400 | -340.745000 | NaN | 0 | 4 | 3 | 4 | 6 | NaN |
0001563699 | Covisint Corp | Covisin | 13 | 11 | NaN | NaN | NaN | NaN | NaN | 65.43460 | 66.84040 | NaN | NaN | NaN | NaN | NaN | -2 | NaN | NaN | NaN | NaN | NaN |
0001603494 | PeerLogix Inc. | PeerLog | 42 | 43 | NaN | NaN | NaN | NaN | NaN | -458.19800 | -441.72700 | NaN | NaN | NaN | NaN | NaN | 1 | NaN | NaN | NaN | NaN | NaN |
0001619954 | Inovalon Holdings Inc. | Inovalo | 9 | 8 | 21 | 19 | 22 | NaN | NaN | 82.72570 | 83.42020 | 32.5478 | 35.2863 | 36.03200 | NaN | NaN | -1 | 13 | -2 | 3 | NaN | NaN |
0001621697 | NATURAL HEALTH FARM HOLDINGS INC | NATURAL | 43 | NaN | 43 | NaN | NaN | NaN | NaN | -759.57900 | NaN | -763.4710 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001659183 | nDivision Inc. | nDivisi | 35 | 44 | 34 | NaN | 37 | NaN | NaN | -86.48710 | -606.36100 | -107.9230 | NaN | -37.00020 | NaN | NaN | 9 | -10 | NaN | NaN | NaN | NaN |
0001667489 | Liberated Syndication Inc. | Liberat | 1 | 12 | 3 | NaN | NaN | NaN | NaN | 177.61000 | 63.84690 | 100.3280 | NaN | NaN | NaN | NaN | 11 | -9 | NaN | NaN | NaN | NaN |
0000869531 | Advantego Corp | Advante | NaN | 41 | 40 | NaN | NaN | NaN | NaN | NaN | -307.51600 | -264.7700 | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN |
0001584423 | APX Group Holdings Inc. | APX Gro | NaN | NaN | 29 | 37 | NaN | NaN | NaN | NaN | NaN | -50.1225 | -53.2975 | NaN | NaN | NaN | NaN | NaN | 8 | NaN | NaN | NaN |
0001635748 | Zoompass Holdings Inc. | Zoompas | NaN | NaN | 44 | 42 | 52 | NaN | NaN | NaN | NaN | -1882.2400 | -291.7090 | -1072.56000 | NaN | NaN | NaN | NaN | -2 | 10 | NaN | NaN |
0001721056 | HOOPS SCOUTING USA | HOOPS S | NaN | NaN | 39 | 40 | 47 | NaN | NaN | NaN | NaN | -264.3410 | -270.0580 | -225.60400 | NaN | NaN | NaN | NaN | 1 | 7 | NaN | NaN |
0001104855 | Support.com Inc. | Support | NaN | NaN | NaN | 1 | 1 | NaN | NaN | NaN | NaN | NaN | 145.2700 | 129.91900 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN |
0001688568 | DXC Technology Co | DXC Tec | NaN | NaN | NaN | 14 | 34 | NaN | NaN | NaN | NaN | NaN | 44.5754 | -6.49370 | NaN | NaN | NaN | NaN | NaN | 20 | NaN | NaN |
0001622231 | BOATIM INC. | BOATIM | NaN | NaN | NaN | NaN | 41 | 53 | NaN | NaN | NaN | NaN | NaN | -124.28200 | -283.942000 | NaN | NaN | NaN | NaN | NaN | 12 | NaN |
0001682325 | GTY Technology Holdings Inc. | GTY Tec | NaN | NaN | NaN | NaN | 9 | 10 | NaN | NaN | NaN | NaN | NaN | 75.54140 | 63.107400 | NaN | NaN | NaN | NaN | NaN | 1 | NaN |
0001784970 | WeTrade Group Inc. | WeTrade | NaN | NaN | NaN | NaN | 3 | 1 | NaN | NaN | NaN | NaN | NaN | 115.95200 | 142.632000 | NaN | NaN | NaN | NaN | NaN | -2 | NaN |
PDF reports
All reports for 2022 are collected in a single PDF for easier review.2016
Logs
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -4.489383286377033}
|
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | 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 | AssetsCurrent | 72.0 | 941 | 61,309,313 | 1,101,970,000 | 39,500,400,000 | 0001435617 | 0001313275 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 12,864,331 | 480,061,150 | 1,918,500,000 | 0001510247 | 0001365038 | 0000008670 |
2 | IntangibleAssets | 0 | 0 | 12,888,530 | 1,984,285,750 | 5,963,000,000 | 0001022505 | 0001499961 | 0001606745 |
3 | remainder_Assets | -201,094,000 | -11,304,092 | 0 | 121,085,800 | 708,600,000 | 0001005757 | 0001621697 | 0000714603 |
4 | LiabilitiesCurrent | 0 | 80,109 | 28,628,885 | 942,141,300 | 36,228,500,000 | 0001621697 | 0001095277 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 1,695,439 | 688,341,450 | 2,340,700,000 | 0000050471 | 0001365038 | 0001442145 |
6 | remainder_Liabilities | -6,694,000 | -850,000 | 0 | 264,798,750 | 2,258,800,000 | 0001005757 | 0001083301 | 0000008670 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 229,135,450 | 859,800,000 | 0000008670 | 0001095277 | 0001104188 |
8 | SellingExpense | 0 | 0 | 26,867,823 | 414,803,000 | 2,637,000,000 | 0000714603 | 0001619954 | 0000008670 |
9 | GeneralAndAdministrativeExpense | 0 | 0 | 3,041,686 | 115,741,200 | 369,000,000 | 0000008670 | 0000050471 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 701,577 | 138,518,250 | 353,144,000 | 0000008670 | 0001022505 | 0001104188 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 90,535,050 | 222,000,000 | 0000008670 | 0001013857 | 0001606745 |
12 | remainder_Expenses | -15,554,000 | 0 | 1,394,063 | 1,023,679,400 | 7,637,800,000 | 0001566469 | 0001389002 | 0000008670 |
13 | remainder_Revenues | 0 | 0 | 57,240,615 | 1,552,995,000 | 11,667,800,000 | 0000909494 | 0000855612 | 0000008670 |
14 | remainder_NetIncome | -45,412,000 | -24,507,050 | 0 | 280,062,550 | 2,141,000,000 | 0001566469 | 0001621697 | 0001442145 |
15 | remainder_ComprehensiveNetIncome | -408,800,000 | -68,520,100 | 0 | 1,266,741 | 45,500,000 | 0001442145 | 0001482554 | 0000008670 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 696 | 6,883 | 103,655,734 | 4,352,290,000 | 43,670,000,000 | 0001621697 | 0001288847 | 0000008670 |
1 | Liabilities | 3,120 | 92,751 | 37,610,355 | 1,824,595,000 | 39,188,400,000 | 0001482554 | 0001458962 | 0000008670 |
2 | Expenses | 22,192 | 58,580 | 121,711,236 | 1,543,530,000 | 10,274,800,000 | 0001621697 | 0001433714 | 0000008670 |
3 | Revenues | 0 | 0 | 57,240,615 | 1,552,995,000 | 11,667,800,000 | 0000909494 | 0000855612 | 0000008670 |
4 | StockholdersEquity | -10,637,063 | -922,642 | 47,014,332 | 1,577,233,650 | 5,424,000,000 | 0001353499 | 0000855612 | 0001606745 |
5 | NetIncome | -184,102,000 | -110,752,750 | -1,928,732 | 373,708,900 | 1,492,500,000 | 0001566469 | 0001603494 | 0000008670 |
6 | ComprehensiveNetIncome | -270,952,000 | -173,165,500 | -1,939,142 | 165,574,050 | 1,538,000,000 | 0001104188 | 0001603494 | 0000008670 |
7 | BaseVar | 15,293 | 95,233 | 189,211,016 | 5,692,022,500 | 52,473,000,000 | 0001621697 | 0001433714 | 0000008670 |
8 | EconomicCapitalRatio | -11.9 | -4.49 | 0.350 | 1.09 | 1.78 | 0001482554 | 0001005757 | 0001667489 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -6.44 | -1.36 | -0.00235 | 0.582 | 1.55 | 0001482554 | 0000714603 | 0001659183 |
1 | AssetsNonCurrent | -1.62 | -0.570 | -0.0374 | 0.380 | 0.898 | 0001621697 | 0001563699 | 0001419951 |
2 | IntangibleAssets | -4.85 | -1.11 | -0.108 | 0.578 | 0.778 | 0001482554 | 0000855612 | 0001606745 |
3 | remainder_Assets | -0.728 | -0.440 | -0.0126 | 0.355 | 1.10 | 0001507605 | 0001365038 | 0001402453 |
4 | LiabilitiesCurrent | -2.66 | -0.565 | 0.214 | 2.56 | 3.99 | 0001482554 | 0001566469 | 0001353499 |
5 | LiabilitiesNonCurrent | -1.75 | -0.740 | 0.0681 | 0.225 | 0.294 | 0001482554 | 0001389002 | 0001022505 |
6 | remainder_Liabilities | -0.950 | -0.371 | 0.0448 | 0.129 | 27.0 | 0001482554 | 0000909494 | 0001621697 |
7 | CostOfGoodsAndServicesSold | -0.580 | -0.456 | 0.108 | 0.361 | 0.525 | 0001507605 | 0001510247 | 0001482554 |
8 | SellingExpense | -0.636 | -0.309 | 0.00874 | 0.584 | 0.848 | 0001384905 | 0001104188 | 0001482554 |
9 | GeneralAndAdministrativeExpense | -1.09 | -0.887 | 0.0499 | 0.309 | 0.459 | 0001022505 | 0001606745 | 0001621697 |
10 | ResearchAndDevelopment | -3.18 | -0.254 | 0.0647 | 0.259 | 0.332 | 0001482554 | 0001619954 | 0001095277 |
11 | DepreciationDepletionAndAmortization | -0.323 | -0.121 | 0.0163 | 0.0306 | 0.0397 | 0001482554 | 0001104188 | 0001095277 |
12 | remainder_Expenses | -5.79 | -1.47 | 0.290 | 0.623 | 0.734 | 0001621697 | 0001510247 | 0001384905 |
13 | remainder_Revenues | -2.28 | -0.974 | 0.0673 | 1.07 | 1.92 | 0001482554 | 0001439404 | 0001095277 |
14 | remainder_NetIncome | -1.34 | -0.365 | -0.0886 | 0.896 | 2.50 | 0001353499 | 0001659183 | 0001053374 |
15 | remainder_ComprehensiveNetIncome | -0.0966 | -0.0549 | 0.00831 | 0.0244 | 0.0299 | 0001442145 | 0001419951 | 0001507605 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -8.15 | -2.38 | 0.0475 | 0.373 | 0.638 | 0001482554 | 0001549346 | 0001566469 |
1 | Liabilities | -4.07 | -0.433 | 0.252 | 1.86 | 2.70 | 0001482554 | 0001487931 | 0001353499 |
2 | Expenses | -7.35 | -1.63 | 0.0389 | 0.526 | 0.542 | 0001482554 | 0001510247 | 0001442145 |
3 | Revenues | -2.28 | -0.974 | 0.0673 | 1.07 | 1.92 | 0001482554 | 0001439404 | 0001095277 |
4 | StockholdersEquity | -1.97 | -1.81 | 0.190 | 0.902 | 1.20 | 0001621697 | 0001013857 | 0001667489 |
5 | NetIncome | -9.88 | -2.58 | 0.401 | 0.657 | 0.810 | 0001482554 | 0000050471 | 0001365038 |
6 | ComprehensiveNetIncome | -9.85 | -2.57 | 0.389 | 0.657 | 0.825 | 0001482554 | 0001458962 | 0001365038 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001389002 | 0000008670 |
8 | EconomicCapitalRatio | -11.4 | -3.96 | 0.884 | 1.62 | 2.31 | 0001482554 | 0001005757 | 0001667489 |
2017
Logs
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -4.3323929136260055}
|
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 "Expenses" 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 | AssetsCurrent | 0 | 2,016 | 81,901,413 | 1,043,540,000 | 32,658,700,000 | 0000869531 | 0001566469 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 16,723,500 | 560,828,800 | 2,132,100,000 | 0000869531 | 0001494259 | 0000008670 |
2 | IntangibleAssets | 0 | 0 | 21,246,045 | 2,352,481,400 | 4,714,000,000 | 0000869531 | 0001389002 | 0001442145 |
3 | remainder_Assets | -210,080,000 | 0 | 38,184 | 148,958,200 | 293,700,000 | 0001005757 | 0000869531 | 0000714603 |
4 | LiabilitiesCurrent | 15,632 | 673,991 | 36,615,826 | 1,118,581,600 | 30,207,300,000 | 0001659183 | 0000855612 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 2,275,601 | 969,952,400 | 2,832,600,000 | 0000050471 | 0000855612 | 0000008670 |
6 | remainder_Liabilities | -12,346,000 | -106,894 | 0 | 158,070,200 | 332,000,000 | 0001005757 | 0001022505 | 0001606745 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 3,520 | 247,306,800 | 1,035,166,000 | 0000008670 | 0000869531 | 0001104188 |
8 | SellingExpense | 0 | 0 | 28,301,954 | 394,996,000 | 2,783,200,000 | 0000714603 | 0001365038 | 0000008670 |
9 | GeneralAndAdministrativeExpense | 0 | 0 | 11,482,066 | 120,029,800 | 329,000,000 | 0000008670 | 0001053374 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 7,260,779 | 156,269,400 | 412,173,000 | 0000008670 | 0000909494 | 0001104188 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 120,127,800 | 213,000,000 | 0000008670 | 0000855612 | 0001606745 |
12 | remainder_Expenses | -19,171,000 | -8,263,600 | 4,168,702 | 1,483,380,000 | 8,147,500,000 | 0001683606 | 0001013857 | 0000008670 |
13 | remainder_Revenues | 0 | 0 | 70,263,891 | 1,802,569,600 | 12,379,800,000 | 0000909494 | 0001563699 | 0000008670 |
14 | remainder_NetIncome | -109,514,000 | -23,458,400 | 0 | 283,040,000 | 2,154,400,000 | 0001566469 | 0001659183 | 0001442145 |
15 | remainder_ComprehensiveNetIncome | -164,100,000 | -13,187,200 | 0 | 15,940,800 | 238,500,000 | 0000008670 | 0001288847 | 0001442145 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 1,829 | 8,598 | 127,617,556 | 5,065,047,800 | 37,180,000,000 | 0001510247 | 0001313275 | 0000008670 |
1 | Liabilities | 15,632 | 673,991 | 49,377,845 | 1,724,200,000 | 33,203,000,000 | 0001659183 | 0001458962 | 0000008670 |
2 | Expenses | 19,615 | 323,404 | 152,407,874 | 2,286,720,800 | 10,930,700,000 | 0001482554 | 0001566469 | 0000008670 |
3 | Revenues | 0 | 0 | 70,263,891 | 1,802,569,600 | 12,379,800,000 | 0000909494 | 0001563699 | 0000008670 |
4 | StockholdersEquity | -13,390,872 | -2,309,849 | 61,308,516 | 1,903,767,400 | 3,977,000,000 | 0001353499 | 0001615165 | 0000008670 |
5 | NetIncome | -1,581,000,000 | -162,296,400 | -4,993,567 | 406,568,600 | 1,733,400,000 | 0001606745 | 0001603494 | 0000008670 |
6 | ComprehensiveNetIncome | -1,581,000,000 | -161,731,400 | -4,993,567 | 393,928,600 | 1,569,300,000 | 0001606745 | 0001603494 | 0000008670 |
7 | BaseVar | 22,959 | 543,005 | 260,709,568 | 5,697,152,100 | 47,070,950,000 | 0001482554 | 0001313275 | 0000008670 |
8 | EconomicCapitalRatio | -8.56 | -4.33 | 0.391 | 1.16 | 1.50 | 0001022505 | 0001104188 | 0001402453 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -3.78 | -1.45 | 0.0147 | 0.554 | 1.79 | 0001022505 | 0000855612 | 0001507605 |
1 | AssetsNonCurrent | -1.58 | -0.494 | -0.0243 | 0.198 | 0.343 | 0001022505 | 0001340127 | 0000050471 |
2 | IntangibleAssets | -3.63 | -1.14 | -0.127 | 0.642 | 0.885 | 0001022505 | 0001083301 | 0001683606 |
3 | remainder_Assets | -0.327 | -0.150 | -0.00931 | 0.283 | 0.481 | 0001022505 | 0001212458 | 0001566469 |
4 | LiabilitiesCurrent | -0.738 | -0.478 | 0.291 | 2.67 | 4.47 | 0001659183 | 0001667489 | 0001603494 |
5 | LiabilitiesNonCurrent | -1.01 | -0.744 | 0.0556 | 0.200 | 0.304 | 0001022505 | 0001053374 | 0001402453 |
6 | remainder_Liabilities | -0.441 | -0.361 | 0.0305 | 0.0823 | 0.123 | 0001619954 | 0001615165 | 0001402453 |
7 | CostOfGoodsAndServicesSold | -0.589 | -0.440 | 0.0926 | 0.304 | 0.474 | 0001288847 | 0001510247 | 0001659183 |
8 | SellingExpense | -2.81 | -0.687 | 0.0439 | 0.430 | 0.618 | 0001659183 | 0001053374 | 0001095277 |
9 | GeneralAndAdministrativeExpense | -4.84 | -0.779 | 0.0888 | 0.284 | 0.761 | 0001022505 | 0000909494 | 0001659183 |
10 | ResearchAndDevelopment | -1.54 | -0.223 | 0.0246 | 0.208 | 0.409 | 0001022505 | 0001494259 | 0001659183 |
11 | DepreciationDepletionAndAmortization | -0.0716 | -0.0647 | 0.0139 | 0.0350 | 0.0522 | 0001499961 | 0001340127 | 0001659183 |
12 | remainder_Expenses | -3.17 | -1.44 | 0.227 | 0.597 | 0.963 | 0001659183 | 0000909494 | 0001022505 |
13 | remainder_Revenues | -1.62 | -0.844 | 0.0921 | 1.24 | 1.83 | 0001053374 | 0001104188 | 0001095277 |
14 | remainder_NetIncome | -1.69 | -0.809 | 0.00669 | 0.511 | 3.02 | 0001603494 | 0001013857 | 0001053374 |
15 | remainder_ComprehensiveNetIncome | -0.0246 | -0.0141 | -0.00443 | 0.0382 | 0.0475 | 0001104188 | 0001482554 | 0001507605 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -5.88 | -2.37 | 0.0345 | 0.471 | 0.669 | 0001022505 | 0001549346 | 0001615165 |
1 | Liabilities | -1.74 | -0.442 | 0.304 | 1.91 | 2.92 | 0001022505 | 0001549346 | 0001603494 |
2 | Expenses | -5.06 | -1.36 | 0.0286 | 0.494 | 0.531 | 0001022505 | 0000855612 | 0001683606 |
3 | Revenues | -1.62 | -0.844 | 0.0921 | 1.24 | 1.83 | 0001053374 | 0001104188 | 0001095277 |
4 | StockholdersEquity | -2.12 | -1.81 | 0.230 | 0.886 | 0.928 | 0001659183 | 0001013857 | 0001439404 |
5 | NetIncome | -6.31 | -2.23 | 0.376 | 0.752 | 0.997 | 0001022505 | 0000855612 | 0001494259 |
6 | ComprehensiveNetIncome | -6.33 | -2.23 | 0.370 | 0.741 | 0.990 | 0001022505 | 0000855612 | 0001494259 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001402453 | 0000008670 |
8 | EconomicCapitalRatio | -8.15 | -3.92 | 0.806 | 1.58 | 1.91 | 0001022505 | 0001104188 | 0001402453 |
2018
Logs
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -6.822121060927299}
|
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
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 | AssetsCurrent | 0 | 815 | 33,499,272 | 739,324,400 | 32,050,000,000 | 0001433714 | 0000855612 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 11,471,023 | 475,009,000 | 1,883,300,000 | 0000869531 | 0001627475 | 0000008670 |
2 | IntangibleAssets | 0 | 0 | 21,814,119 | 2,802,194,400 | 4,589,300,000 | 0000869531 | 0000050471 | 0001442145 |
3 | remainder_Assets | -357,672,000 | -915,804 | 1,580 | 148,875,200 | 1,237,652,000 | 0001005757 | 0001721056 | 0001584423 |
4 | LiabilitiesCurrent | 0 | 25,572 | 38,982,526 | 611,305,400 | 30,791,400,000 | 0001635748 | 0001566469 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 1,391,144 | 547,791,200 | 2,730,400,000 | 0000050471 | 0001615165 | 0000008670 |
6 | remainder_Liabilities | -17,527,000 | 0 | 42.2 | 289,091,200 | 3,457,556,000 | 0001005757 | 0001688126 | 0001584423 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 6,479,477 | 304,079,400 | 886,200,000 | 0000008670 | 0001615165 | 0001442145 |
8 | SellingExpense | 0 | 0 | 23,466,215 | 377,659,000 | 2,971,500,000 | 0000869531 | 0001389002 | 0000008670 |
9 | GeneralAndAdministrativeExpense | 0 | 0 | 4,289,428 | 184,327,000 | 361,000,000 | 0000008670 | 0001597846 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 6,350 | 177,420,000 | 270,323,000 | 0000008670 | 0001482554 | 0001439404 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 147,345,000 | 514,082,000 | 0000008670 | 0001384905 | 0001584423 |
12 | remainder_Expenses | -22,160,000 | -13,007,000 | 1,317,954 | 324,267,200 | 8,495,600,000 | 0001013857 | 0001313275 | 0000008670 |
13 | remainder_Revenues | 0 | 0 | 70,561,538 | 1,502,088,200 | 13,325,800,000 | 0001131903 | 0000855612 | 0000008670 |
14 | remainder_NetIncome | -237,900,000 | -69,192,600 | 0 | 17,258,400 | 33,661,000 | 0000008670 | 0001621697 | 0001549346 |
15 | remainder_ComprehensiveNetIncome | -259,300,000 | -22,776,200 | 0 | 334,901 | 6,513,890 | 0000008670 | 0001659183 | 0001688126 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 658 | 9,461 | 104,697,702 | 4,684,098,200 | 37,088,700,000 | 0001131903 | 0000855612 | 0000008670 |
1 | Liabilities | 832 | 156,650 | 43,753,623 | 3,361,360,000 | 33,629,100,000 | 0001482554 | 0000855612 | 0000008670 |
2 | Expenses | 7,923 | 310,171 | 101,622,106 | 1,542,420,600 | 11,467,100,000 | 0001721056 | 0001389002 | 0000008670 |
3 | Revenues | 0 | 0 | 70,561,538 | 1,502,088,200 | 13,325,800,000 | 0001131903 | 0000855612 | 0000008670 |
4 | StockholdersEquity | -1,396,601,000 | -2,640,674 | 39,794,872 | 1,975,802,000 | 3,736,000,000 | 0001584423 | 0000050471 | 0001606745 |
5 | NetIncome | -467,914,000 | -125,617,000 | -2,388,604 | 82,481,200 | 1,620,800,000 | 0001584423 | 0001659183 | 0000008670 |
6 | ComprehensiveNetIncome | -470,132,000 | -128,298,200 | -3,985,809 | 71,665,800 | 1,361,500,000 | 0001584423 | 0001487931 | 0000008670 |
7 | BaseVar | 9,486 | 526,917 | 146,550,427 | 4,885,609,300 | 48,003,950,000 | 0001721056 | 0001615165 | 0000008670 |
8 | EconomicCapitalRatio | -21.8 | -6.82 | 0.317 | 1.00 | 1.31 | 0001482554 | 0001384905 | 0001494259 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -11.6 | -2.70 | -0.0327 | 0.568 | 2.83 | 0001482554 | 0001313275 | 0001022505 |
1 | AssetsNonCurrent | -7.05 | -1.10 | -0.0277 | 0.297 | 0.978 | 0001482554 | 0000855612 | 0001507605 |
2 | IntangibleAssets | -12.4 | -2.39 | -0.0722 | 0.590 | 0.705 | 0001482554 | 0001549346 | 0001619954 |
3 | remainder_Assets | -4.28 | -0.656 | -0.0275 | 0.476 | 0.601 | 0001482554 | 0001549346 | 0001433714 |
4 | LiabilitiesCurrent | -11.7 | -0.491 | 0.186 | 1.63 | 3.68 | 0001482554 | 0001013857 | 0001510247 |
5 | LiabilitiesNonCurrent | -5.64 | -0.761 | 0.0486 | 0.202 | 0.281 | 0001482554 | 0001659183 | 0001494259 |
6 | remainder_Liabilities | -6.35 | -0.856 | 0.104 | 0.269 | 23.8 | 0001482554 | 0001463172 | 0001635748 |
7 | CostOfGoodsAndServicesSold | -1.20 | -0.700 | 0.0225 | 0.446 | 1.33 | 0001402453 | 0001566469 | 0001482554 |
8 | SellingExpense | -2.56 | -0.310 | 0.0301 | 0.571 | 1.45 | 0001659183 | 0001439404 | 0001482554 |
9 | GeneralAndAdministrativeExpense | -1.67 | -0.746 | 0.0727 | 0.475 | 1.02 | 0001510247 | 0001463172 | 0001635748 |
10 | ResearchAndDevelopment | -2.37 | -0.268 | 0.0629 | 0.221 | 0.475 | 0001482554 | 0001386049 | 0001635748 |
11 | DepreciationDepletionAndAmortization | -0.417 | -0.134 | 0.0213 | 0.0531 | 0.115 | 0001389002 | 0001288847 | 0001635748 |
12 | remainder_Expenses | -15.9 | -5.07 | 0.317 | 0.742 | 0.870 | 0001482554 | 0001606745 | 0001494259 |
13 | remainder_Revenues | -4.33 | -1.29 | 0.0800 | 1.27 | 1.58 | 0001482554 | 0001439404 | 0001499961 |
14 | remainder_NetIncome | -1.89 | -0.659 | 0.0855 | 0.228 | 0.823 | 0001688126 | 0001721056 | 0001482554 |
15 | remainder_ComprehensiveNetIncome | -0.0796 | -0.0473 | -0.0135 | -0.00828 | 1.34 | 0001482554 | 0001384905 | 0001688126 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -17.2 | -4.21 | 0.0481 | 0.429 | 1.06 | 0001482554 | 0001083301 | 0001022505 |
1 | Liabilities | -14.0 | -0.678 | 0.286 | 1.03 | 2.05 | 0001482554 | 0001627475 | 0001510247 |
2 | Expenses | -14.9 | -3.61 | 0.175 | 0.520 | 0.558 | 0001482554 | 0001597846 | 0001386049 |
3 | Revenues | -4.33 | -1.29 | 0.0800 | 1.27 | 1.58 | 0001482554 | 0001439404 | 0001499961 |
4 | StockholdersEquity | -2.45 | -1.67 | 0.245 | 0.800 | 1.47 | 0001635748 | 0001212458 | 0001022505 |
5 | NetIncome | -18.4 | -4.65 | 0.457 | 0.959 | 1.48 | 0001482554 | 0001212458 | 0001494259 |
6 | ComprehensiveNetIncome | -18.5 | -4.59 | 0.446 | 0.930 | 1.45 | 0001482554 | 0001212458 | 0001494259 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001442145 | 0000008670 |
8 | EconomicCapitalRatio | -20.6 | -5.58 | 1.56 | 2.25 | 2.56 | 0001482554 | 0001384905 | 0001494259 |
2019
Logs
error | 5 × 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 | 5 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.364929129295501}
|
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GeneralAndAdministrativeExpense', 'min_value': -306000000}
|
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | 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 | AssetsCurrent | 0 | 7,697 | 65,891,267 | 1,506,532,800 | 34,342,300,000 | 0001721056 | 0001313275 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 26,396,478 | 952,629,600 | 6,608,000,000 | 0001131903 | 0000050471 | 0001688568 |
2 | IntangibleAssets | 0 | 0 | 26,310,510 | 3,706,100,000 | 13,545,000,000 | 0001022505 | 0001719489 | 0001688568 |
3 | remainder_Assets | -291,690,000 | -1,066,866 | 517,576 | 554,248,800 | 1,866,170,000 | 0001005757 | 0001755101 | 0001764046 |
4 | LiabilitiesCurrent | 0 | 65,351 | 59,763,526 | 1,680,638,000 | 33,027,000,000 | 0001510247 | 0001615165 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 11,155,799 | 2,412,554,000 | 6,166,000,000 | 0000050471 | 0001365038 | 0001688568 |
6 | remainder_Liabilities | -18,552,000 | 0 | 285,267 | 1,497,907,800 | 3,312,093,000 | 0001005757 | 0001494259 | 0001584423 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 17,313,438 | 524,915,400 | 8,086,600,000 | 0000903651 | 0001615165 | 0000008670 |
8 | SellingExpense | 0 | 0 | 31,730,224 | 819,900,000 | 3,064,200,000 | 0001131903 | 0001365038 | 0000008670 |
9 | GeneralAndAdministrativeExpense | -306,000,000 | 0 | 4,026,786 | 182,016,600 | 388,000,000 | 0001688568 | 0001691077 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 874,125 | 207,080,400 | 505,889,000 | 0000008670 | 0001083301 | 0001439404 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 182,360,000 | 1,968,000,000 | 0000008670 | 0001288847 | 0001688568 |
12 | remainder_Expenses | -44,413,000 | -3,419,400 | 2,029,673 | 754,170,800 | 15,905,000,000 | 0001013857 | 0001507605 | 0001688568 |
13 | remainder_Revenues | 0 | 47.8 | 143,359,251 | 2,397,680,000 | 20,753,000,000 | 0001635748 | 0001433714 | 0001688568 |
14 | remainder_NetIncome | -32,104,000 | -18,561,800 | 8,164 | 33,400,000 | 336,506,000 | 0001566469 | 0001022505 | 0001439404 |
15 | remainder_ComprehensiveNetIncome | -307,000,000 | -9,688,800 | 0 | 5,738,400 | 422,500,000 | 0001688568 | 0001635748 | 0000008670 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 302 | 7,697 | 173,174,635 | 6,589,360,000 | 41,887,700,000 | 0001721056 | 0001313275 | 0000008670 |
1 | Liabilities | 19,383 | 826,939 | 98,911,306 | 4,713,032,000 | 36,487,800,000 | 0001721056 | 0001313275 | 0000008670 |
2 | Expenses | 10,934 | 639,943 | 178,108,635 | 2,065,000,000 | 19,526,000,000 | 0001721056 | 0000855612 | 0001688568 |
3 | Revenues | 0 | 47.8 | 143,359,251 | 2,397,680,000 | 20,753,000,000 | 0001635748 | 0001433714 | 0001688568 |
4 | StockholdersEquity | -1,789,322,000 | -32,557,192 | 47,412,756 | 3,092,960,000 | 11,725,000,000 | 0001584423 | 0001615165 | 0001688568 |
5 | NetIncome | -395,756,000 | -161,775,400 | -3,928,403 | 380,660,000 | 2,292,800,000 | 0001584423 | 0001691077 | 0000008670 |
6 | ComprehensiveNetIncome | -394,385,000 | -156,721,800 | -3,930,013 | 463,369,800 | 2,715,300,000 | 0001584423 | 0001691077 | 0000008670 |
7 | BaseVar | 15,310 | 838,214 | 321,038,331 | 7,658,586,300 | 52,538,900,000 | 0001721056 | 0001433714 | 0000008670 |
8 | EconomicCapitalRatio | -4.60 | -3.36 | 0.191 | 0.933 | 1.45 | 0001510247 | 0001597846 | 0001104855 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -1.42 | -0.935 | -0.0434 | 0.507 | 3.80 | 0001510247 | 0001559865 | 0001022505 |
1 | AssetsNonCurrent | -0.815 | -0.566 | -0.0453 | 0.257 | 1.33 | 0001510247 | 0001627475 | 0001507605 |
2 | IntangibleAssets | -1.13 | -0.850 | -0.0930 | 0.611 | 0.709 | 0001510247 | 0001549346 | 0001606745 |
3 | remainder_Assets | -0.299 | -0.217 | -0.0334 | 0.496 | 4.76 | 0001510247 | 0001688568 | 0001755101 |
4 | LiabilitiesCurrent | -0.747 | -0.337 | 0.105 | 1.76 | 4.30 | 0001510247 | 0001549346 | 0001688126 |
5 | LiabilitiesNonCurrent | -0.667 | -0.486 | 0.0505 | 0.224 | 0.284 | 0001559865 | 0000008670 | 0000903651 |
6 | remainder_Liabilities | -0.691 | -0.381 | 0.176 | 6.06 | 10.1 | 0001584423 | 0000855612 | 0001510247 |
7 | CostOfGoodsAndServicesSold | -0.832 | -0.556 | 0.0325 | 0.311 | 0.491 | 0001083301 | 0001566469 | 0001499961 |
8 | SellingExpense | -1.16 | -0.290 | 0.0194 | 0.227 | 0.441 | 0001494259 | 0001764046 | 0001499961 |
9 | GeneralAndAdministrativeExpense | -1.59 | -0.475 | 0.0809 | 0.270 | 0.436 | 0001688126 | 0001507605 | 0001499961 |
10 | ResearchAndDevelopment | -0.427 | -0.266 | 0.0519 | 0.119 | 0.196 | 0001389002 | 0001482554 | 0001499961 |
11 | DepreciationDepletionAndAmortization | -0.141 | -0.0637 | 0.0175 | 0.0274 | 0.0347 | 0001584423 | 0001463172 | 0001365038 |
12 | remainder_Expenses | -2.80 | -1.55 | 0.218 | 0.425 | 0.503 | 0001755101 | 0001559865 | 0001494259 |
13 | remainder_Revenues | -0.882 | -0.598 | 0.000171 | 1.01 | 1.65 | 0001755101 | 0000855612 | 0001499961 |
14 | remainder_NetIncome | -1.29 | -0.251 | 0.0235 | 0.170 | 0.791 | 0001487931 | 0001688126 | 0001104855 |
15 | remainder_ComprehensiveNetIncome | -0.0283 | -0.0122 | -0.000627 | 0.00929 | 0.0224 | 0000903651 | 0001386049 | 0001482554 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -2.60 | -1.79 | 0.0811 | 0.352 | 1.09 | 0001510247 | 0000909494 | 0001022505 |
1 | Liabilities | -0.451 | -0.288 | 0.309 | 1.52 | 1.95 | 0001584423 | 0001606745 | 0001688126 |
2 | Expenses | -1.82 | -0.896 | 0.0756 | 0.377 | 0.401 | 0001755101 | 0001597846 | 0000008670 |
3 | Revenues | -0.882 | -0.598 | 0.000171 | 1.01 | 1.65 | 0001755101 | 0000855612 | 0001499961 |
4 | StockholdersEquity | -1.82 | -1.72 | 0.229 | 0.931 | 1.17 | 0001688126 | 0001482554 | 0001022505 |
5 | NetIncome | -2.73 | -1.59 | 0.281 | 0.538 | 0.815 | 0001755101 | 0001606745 | 0001494259 |
6 | ComprehensiveNetIncome | -2.74 | -1.59 | 0.280 | 0.543 | 0.812 | 0001755101 | 0001606745 | 0001494259 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001482554 | 0000008670 |
8 | EconomicCapitalRatio | -4.37 | -3.14 | 0.413 | 1.15 | 1.67 | 0001510247 | 0001597846 | 0001104855 |
2020
Logs
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.2988000749640487}
|
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GeneralAndAdministrativeExpense', 'min_value': -720000000}
|
warning | 1 × Missing logo | subcommand.report | |
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 | AssetsCurrent | 0 | 3,241 | 36,505,898 | 1,299,387,400 | 8,987,000,000 | 0001721056 | 0001104855 | 0001688568 |
1 | AssetsNonCurrent | 0 | 0 | 9,722,086 | 739,859,950 | 5,459,000,000 | 0001131903 | 0001682325 | 0001688568 |
2 | IntangibleAssets | 0 | 0 | 14,494,751 | 4,671,200,000 | 13,622,986,000 | 0001022505 | 0001615165 | 0001764046 |
3 | remainder_Assets | -298,775,000 | 0 | 774,724 | 188,391,350 | 3,812,000,000 | 0001005757 | 0001735092 | 0001688568 |
4 | LiabilitiesCurrent | 0 | 0 | 40,901,019 | 1,620,900,000 | 7,895,000,000 | 0001510247 | 0001801661 | 0001688568 |
5 | LiabilitiesNonCurrent | 0 | 0 | 3,408,413 | 1,604,705,650 | 10,329,000,000 | 0000909494 | 0001389002 | 0001688568 |
6 | remainder_Liabilities | -22,384,000 | 0 | 0 | 511,017,450 | 3,499,299,000 | 0001005757 | 0001365038 | 0001764046 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 13,989,248 | 659,888,350 | 14,901,000,000 | 0000903651 | 0001615165 | 0001688568 |
8 | SellingExpense | 0 | 0 | 17,418,811 | 567,263,650 | 2,050,000,000 | 0001131903 | 0000903651 | 0001688568 |
9 | GeneralAndAdministrativeExpense | -720,000,000 | -8,730,000 | 3,370,257 | 207,498,400 | 461,451,000 | 0001688568 | 0001597846 | 0001809519 |
10 | ResearchAndDevelopment | 0 | 0 | 1,185,666 | 245,272,300 | 713,700,000 | 0000050471 | 0001022505 | 0001439404 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 138,808,750 | 8,736,000,000 | 0000855612 | 0001801661 | 0001688568 |
12 | remainder_Expenses | -44,160,000 | -5,771,300 | 1,530,212 | 238,516,500 | 459,860,000 | 0001013857 | 0001510247 | 0001764046 |
13 | remainder_Revenues | 0 | 86.5 | 62,010,633 | 1,578,385,850 | 19,577,000,000 | 0001721056 | 0001499961 | 0001688568 |
14 | remainder_NetIncome | -140,600,000 | -43,186,000 | -18,196 | 11,920,750 | 37,994,000 | 0001442145 | 0001688568 | 0001013857 |
15 | remainder_ComprehensiveNetIncome | -370,000,000 | -12,597,900 | 0 | 39,494,000 | 508,400,000 | 0001688568 | 0001829280 | 0001764046 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 148 | 17,896 | 129,828,867 | 6,816,385,000 | 26,006,000,000 | 0001721056 | 0001365038 | 0001688568 |
1 | Liabilities | 7,811 | 591,414 | 45,177,424 | 3,984,370,000 | 20,877,000,000 | 0001784440 | 0001801661 | 0001688568 |
2 | Expenses | 7,682 | 119,006 | 94,205,043 | 1,630,285,000 | 24,935,000,000 | 0001784440 | 0001566469 | 0001688568 |
3 | Revenues | 0 | 86.5 | 62,010,633 | 1,578,385,850 | 19,577,000,000 | 0001721056 | 0001499961 | 0001688568 |
4 | StockholdersEquity | -111,400,000 | -7,592,898 | 38,551,268 | 2,852,125,000 | 9,593,971,000 | 0001566469 | 0000050471 | 0001764046 |
5 | NetIncome | -5,358,000,000 | -354,722,650 | -4,540,025 | 74,370,150 | 712,700,000 | 0001688568 | 0001510247 | 0001442145 |
6 | ComprehensiveNetIncome | -5,728,000,000 | -320,882,650 | -4,079,695 | 82,666,600 | 823,900,000 | 0001688568 | 0001554818 | 0001442145 |
7 | BaseVar | 18,061 | 392,971 | 249,571,751 | 7,743,015,000 | 45,882,500,000 | 0001784440 | 0001433714 | 0001688568 |
8 | EconomicCapitalRatio | -10.7 | -3.30 | 0.231 | 1.15 | 1.30 | 0001635748 | 0001809519 | 0001104855 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -5.12 | -0.702 | -0.0543 | 0.689 | 2.48 | 0001635748 | 0001313275 | 0001829280 |
1 | AssetsNonCurrent | -2.78 | -0.327 | -0.0362 | 0.251 | 0.943 | 0001635748 | 0001559865 | 0001482554 |
2 | IntangibleAssets | -4.47 | -0.813 | -0.119 | 0.761 | 1.23 | 0001635748 | 0001829280 | 0001682325 |
3 | remainder_Assets | -1.90 | -0.307 | -0.0414 | 0.590 | 3.18 | 0001635748 | 0001829280 | 0001784440 |
4 | LiabilitiesCurrent | -1.84 | -0.190 | 0.189 | 0.744 | 1.62 | 0001635748 | 0001549346 | 0001487931 |
5 | LiabilitiesNonCurrent | -1.56 | -0.650 | -0.00666 | 0.259 | 0.346 | 0001635748 | 0001554818 | 0001083301 |
6 | remainder_Liabilities | -2.41 | -0.597 | 0.154 | 0.364 | 7.94 | 0001635748 | 0001615165 | 0001510247 |
7 | CostOfGoodsAndServicesSold | -1.78 | -0.649 | 0.0653 | 0.327 | 0.396 | 0001499961 | 0001682325 | 0001755101 |
8 | SellingExpense | -1.24 | -0.400 | 0.0159 | 0.172 | 0.641 | 0001801661 | 0001615165 | 0001635748 |
9 | GeneralAndAdministrativeExpense | -2.11 | -0.454 | 0.0769 | 0.329 | 0.650 | 0001022505 | 0001494259 | 0001635748 |
10 | ResearchAndDevelopment | -0.761 | -0.315 | 0.0445 | 0.142 | 0.281 | 0001022505 | 0001083301 | 0001635748 |
11 | DepreciationDepletionAndAmortization | -0.435 | -0.156 | 0.0243 | 0.0465 | 0.0606 | 0001433714 | 0001439404 | 0001755101 |
12 | remainder_Expenses | -4.91 | -0.746 | 0.143 | 0.280 | 0.298 | 0001755101 | 0001005757 | 0001022505 |
13 | remainder_Revenues | -1.39 | -0.644 | 0.0272 | 0.844 | 1.49 | 0001635748 | 0001288847 | 0001499961 |
14 | remainder_NetIncome | -7.83 | -0.481 | 0.0652 | 0.236 | 0.751 | 0001635748 | 0001735092 | 0001104855 |
15 | remainder_ComprehensiveNetIncome | -0.0307 | -0.0246 | -0.00475 | 0.0280 | 0.125 | 0001719489 | 0001288847 | 0001482554 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -7.86 | -1.50 | 0.0220 | 0.574 | 0.906 | 0001635748 | 0001549346 | 0001829280 |
1 | Liabilities | -4.10 | -0.367 | 0.200 | 0.974 | 1.29 | 0001635748 | 0001691077 | 0001510247 |
2 | Expenses | -3.53 | -0.852 | 0.0650 | 0.361 | 1.08 | 0001755101 | 0001784440 | 0001635748 |
3 | Revenues | -1.39 | -0.644 | 0.0272 | 0.844 | 1.49 | 0001635748 | 0001288847 | 0001499961 |
4 | StockholdersEquity | -1.71 | -1.65 | 0.232 | 1.00 | 1.25 | 0001131903 | 0000855612 | 0001829280 |
5 | NetIncome | -8.13 | -1.92 | 0.235 | 0.657 | 0.857 | 0001635748 | 0001659183 | 0001494259 |
6 | ComprehensiveNetIncome | -8.15 | -1.93 | 0.220 | 0.647 | 0.856 | 0001635748 | 0001659183 | 0001494259 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000050471 | 0001494259 | 0000050471 |
8 | EconomicCapitalRatio | -10.3 | -2.84 | 0.691 | 1.61 | 1.76 | 0001635748 | 0001809519 | 0001104855 |
2021
Logs
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.3841409654730956}
|
warning | 1 × Missing logo | subcommand.report | |
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg | |
warning | 1 × Ignoring company because Assets is zero | 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 | AssetsCurrent | 0 | 5,114 | 83,573,015 | 1,515,447,600 | 40,741,800,000 | 0001755101 | 0001723648 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 8,773,497 | 797,226,786 | 4,470,700,000 | 0001022505 | 0001682325 | 0000008670 |
2 | IntangibleAssets | 0 | 0 | 36,647,737 | 3,739,120,000 | 18,297,217,000 | 0001022505 | 0001665300 | 0001764046 |
3 | remainder_Assets | -417,183,000 | -35,127,589 | 855,761 | 218,009,200 | 829,303,000 | 0001829864 | 0001615165 | 0001463172 |
4 | LiabilitiesCurrent | 0 | 215,620 | 36,804,062 | 1,782,166,800 | 38,940,100,000 | 0001510247 | 0001864448 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 6,834,236 | 1,801,980,000 | 5,692,987,000 | 0000909494 | 0001014052 | 0001764046 |
6 | remainder_Liabilities | -40,235,000 | -23,886,777 | 0 | 215,267,800 | 297,000,000 | 0001829864 | 0001022505 | 0001606745 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 12,936,766 | 1,023,480,000 | 8,640,300,000 | 0000903651 | 0001389002 | 0000008670 |
8 | SellingExpense | 0 | 0 | 22,947,955 | 714,672,000 | 3,040,500,000 | 0001131903 | 0001864448 | 0000008670 |
9 | GeneralAndAdministrativeExpense | 0 | 0 | 8,402,356 | 190,910,800 | 286,000,000 | 0000008670 | 0001691077 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 1,119 | 270,451,800 | 545,900,000 | 0000008670 | 0000050471 | 0001439404 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 86,037,600 | 206,900,000 | 0000008670 | 0001022505 | 0001442145 |
12 | remainder_Expenses | -105,696,000 | -17,628,000 | 2,530,175 | 282,244,586 | 850,742,000 | 0001801661 | 0001384905 | 0001764046 |
13 | remainder_Revenues | 0 | 0 | 70,010,080 | 2,061,615,200 | 15,005,400,000 | 0001131903 | 0000903651 | 0000008670 |
14 | remainder_NetIncome | -153,000,000 | -54,454,400 | -597,631 | 26,421,189 | 180,000,000 | 0001650164 | 0001615165 | 0001606745 |
15 | remainder_ComprehensiveNetIncome | -165,627,000 | -13,529,600 | 0 | 2,993,200 | 25,400,000 | 0001764046 | 0001683252 | 0000008670 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 264 | 24,020 | 209,281,471 | 6,648,740,000 | 48,772,500,000 | 0001131903 | 0001723648 | 0000008670 |
1 | Liabilities | 19,106 | 244,090 | 106,576,765 | 3,590,720,000 | 43,102,400,000 | 0001784440 | 0001625278 | 0000008670 |
2 | Expenses | 51,220 | 708,218 | 171,355,518 | 2,159,313,600 | 12,503,200,000 | 0001784440 | 0001864448 | 0000008670 |
3 | Revenues | 0 | 0 | 70,010,080 | 2,061,615,200 | 15,005,400,000 | 0001131903 | 0000903651 | 0000008670 |
4 | StockholdersEquity | -161,992,000 | -7,560,509 | 80,666,814 | 2,896,380,000 | 11,925,869,000 | 0001566469 | 0001615165 | 0001764046 |
5 | NetIncome | -487,000,000 | -233,004,800 | -9,166,671 | 120,527,000 | 2,598,500,000 | 0001650164 | 0001386049 | 0000008670 |
6 | ComprehensiveNetIncome | -488,000,000 | -265,127,200 | -9,166,671 | 117,821,000 | 2,623,900,000 | 0001650164 | 0001386049 | 0000008670 |
7 | BaseVar | 38,320 | 758,793 | 348,990,683 | 7,959,360,000 | 59,752,600,000 | 0001784440 | 0001682325 | 0000008670 |
8 | EconomicCapitalRatio | -5.29 | -3.38 | 0.165 | 1.15 | 1.43 | 0001755101 | 0001627475 | 0001784970 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -2.25 | -1.11 | -0.0562 | 1.10 | 1.58 | 0001755101 | 0001606745 | 0001022505 |
1 | AssetsNonCurrent | -0.838 | -0.398 | -0.0594 | 0.508 | 0.841 | 0001755101 | 0001439404 | 0001554818 |
2 | IntangibleAssets | -1.69 | -0.823 | -0.0646 | 0.582 | 1.20 | 0001755101 | 0001005757 | 0001682325 |
3 | remainder_Assets | -0.349 | -0.171 | -0.0227 | 0.723 | 1.25 | 0001829864 | 0001507605 | 0001597846 |
4 | LiabilitiesCurrent | -0.989 | -0.357 | 0.177 | 0.665 | 3.69 | 0001784440 | 0001719489 | 0001683252 |
5 | LiabilitiesNonCurrent | -0.747 | -0.575 | -0.00657 | 0.277 | 0.415 | 0001507605 | 0001735092 | 0001236275 |
6 | remainder_Liabilities | -0.492 | -0.141 | 0.0946 | 0.494 | 18.4 | 0001719489 | 0001463172 | 0001510247 |
7 | CostOfGoodsAndServicesSold | -1.40 | -0.449 | 0.0602 | 0.256 | 0.332 | 0001236275 | 0001386049 | 0001755101 |
8 | SellingExpense | -1.67 | -0.470 | 0.0670 | 0.242 | 0.365 | 0001784440 | 0001389002 | 0001755101 |
9 | GeneralAndAdministrativeExpense | -1.78 | -0.562 | 0.105 | 0.295 | 0.380 | 0001683252 | 0001288847 | 0001755101 |
10 | ResearchAndDevelopment | -2.00 | -0.143 | 0.0573 | 0.146 | 0.207 | 0001853825 | 0001764046 | 0001236275 |
11 | DepreciationDepletionAndAmortization | -0.109 | -0.0574 | 0.0137 | 0.0242 | 0.0343 | 0001683606 | 0001435617 | 0001236275 |
12 | remainder_Expenses | -3.92 | -0.831 | 0.148 | 0.236 | 0.320 | 0001755101 | 0001829280 | 0001801661 |
13 | remainder_Revenues | -0.912 | -0.665 | 0.0569 | 0.835 | 1.92 | 0001755101 | 0001442145 | 0001236275 |
14 | remainder_NetIncome | -1.48 | -0.777 | 0.0811 | 0.228 | 0.685 | 0001554818 | 0001005757 | 0001688126 |
15 | remainder_ComprehensiveNetIncome | -0.0269 | -0.0124 | -0.00196 | 0.0261 | 0.0534 | 0000903651 | 0001419951 | 0001622231 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -3.13 | -1.89 | 0.00939 | 0.583 | 0.856 | 0001755101 | 0001005757 | 0001554818 |
1 | Liabilities | -0.441 | -0.255 | 0.143 | 0.826 | 1.82 | 0001566469 | 0001735092 | 0001510247 |
2 | Expenses | -2.66 | -1.12 | 0.0677 | 0.381 | 0.458 | 0001755101 | 0000909494 | 0001597846 |
3 | Revenues | -0.912 | -0.665 | 0.0569 | 0.835 | 1.92 | 0001755101 | 0001442145 | 0001236275 |
4 | StockholdersEquity | -1.87 | -1.53 | 0.187 | 0.968 | 1.31 | 0001683252 | 0001853825 | 0001554818 |
5 | NetIncome | -3.35 | -1.96 | 0.292 | 0.756 | 1.10 | 0001755101 | 0001507605 | 0001236275 |
6 | ComprehensiveNetIncome | -3.35 | -1.97 | 0.291 | 0.749 | 1.10 | 0001755101 | 0001507605 | 0001236275 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001566469 | 0000008670 |
8 | EconomicCapitalRatio | -4.94 | -3.03 | 0.519 | 1.50 | 1.78 | 0001755101 | 0001627475 | 0001784970 |
2022
Logs
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.8987004315940763}
|
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GeneralAndAdministrativeExpense', 'min_value': -354200000}
|
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 | AssetsCurrent | 0 | 29,792 | 77,365,069 | 1,349,100,000 | 54,804,900,000 | 0001755101 | 0001313275 | 0000008670 |
1 | AssetsNonCurrent | 0 | 0 | 17,596,700 | 636,649,500 | 4,620,600,000 | 0001022505 | 0001566469 | 0000008670 |
2 | IntangibleAssets | 0 | 0 | 64,222,315 | 2,609,400,000 | 12,314,200,000 | 0001131903 | 0001723648 | 0001764046 |
3 | remainder_Assets | -430,375,000 | -78,441,943 | 404,285 | 99,403,000 | 216,986,000 | 0001829864 | 0001665300 | 0001288847 |
4 | LiabilitiesCurrent | 0 | 272,047 | 49,548,880 | 1,264,950,000 | 55,560,700,000 | 0001784440 | 0001801661 | 0000008670 |
5 | LiabilitiesNonCurrent | 0 | 0 | 11,606,630 | 2,127,720,500 | 5,197,000,000 | 0000909494 | 0001625278 | 0001764046 |
6 | remainder_Liabilities | -36,858,503 | -11,054,000 | 0 | 192,604,500 | 260,000,000 | 0001499961 | 0000909494 | 0001606745 |
7 | CostOfGoodsAndServicesSold | 0 | 0 | 16,769,533 | 975,741,000 | 9,461,900,000 | 0000903651 | 0001665300 | 0000008670 |
8 | SellingExpense | 0 | 0 | 38,007,025 | 849,450,000 | 3,233,200,000 | 0001131903 | 0000903651 | 0000008670 |
9 | GeneralAndAdministrativeExpense | -354,200,000 | 0 | 4,724,805 | 227,958,000 | 338,000,000 | 0001442145 | 0000050471 | 0001606745 |
10 | ResearchAndDevelopment | 0 | 0 | 244,612 | 218,276,500 | 362,256,000 | 0000008670 | 0001691077 | 0001384905 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 0 | 166,125,500 | 5,159,600,000 | 0000008670 | 0001288847 | 0001764046 |
12 | remainder_Expenses | -97,000,000 | -1,550,000 | 4,391,625 | 254,010,000 | 937,100,000 | 0001650164 | 0001288847 | 0000008670 |
13 | remainder_Revenues | 0 | 0 | 79,286,120 | 2,578,400,000 | 16,498,300,000 | 0001499961 | 0000903651 | 0000008670 |
14 | remainder_NetIncome | -231,900,000 | -44,030,000 | -172,606 | 13,373,500 | 110,452,000 | 0001442145 | 0001554818 | 0001559865 |
15 | remainder_ComprehensiveNetIncome | -2,004,300,000 | -178,688,000 | 0 | 3,742,000 | 31,777,000 | 0000008670 | 0001784440 | 0001559865 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | 16,253 | 156,310 | 178,403,290 | 5,799,550,000 | 63,068,200,000 | 0001784440 | 0001723648 | 0000008670 |
1 | Liabilities | 1,860 | 272,047 | 100,023,850 | 3,784,700,000 | 59,842,900,000 | 0001784440 | 0001864448 | 0000008670 |
2 | Expenses | 183,842 | 925,082 | 170,149,910 | 2,830,459,000 | 13,632,200,000 | 0001784440 | 0001723648 | 0000008670 |
3 | Revenues | 0 | 0 | 79,286,120 | 2,578,400,000 | 16,498,300,000 | 0001499961 | 0000903651 | 0000008670 |
4 | StockholdersEquity | -283,338,000 | -47,290,500 | 42,216,450 | 2,014,850,000 | 6,812,500,000 | 0001384905 | 0001719489 | 0001764046 |
5 | NetIncome | -3,960,200,000 | -589,599,876 | -6,894,270 | 158,911,500 | 2,948,900,000 | 0001764046 | 0001554818 | 0000008670 |
6 | ComprehensiveNetIncome | -4,952,800,000 | -590,257,376 | -6,895,703 | 176,896,000 | 944,600,000 | 0001764046 | 0001554818 | 0000008670 |
7 | BaseVar | 105,334 | 1,330,268 | 373,442,372 | 6,623,275,000 | 77,564,350,000 | 0001784440 | 0001566469 | 0000008670 |
8 | EconomicCapitalRatio | -18.0 | -3.90 | 0.0602 | 0.953 | 1.41 | 0001784440 | 0001764046 | 0000050471 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | AssetsCurrent | -6.98 | -1.57 | -0.0569 | 0.705 | 4.63 | 0001784440 | 0001236275 | 0001853825 |
1 | AssetsNonCurrent | -7.42 | -1.04 | -0.0758 | 0.423 | 1.96 | 0001784440 | 0001683606 | 0001554818 |
2 | IntangibleAssets | -10.3 | -1.49 | -0.0423 | 0.834 | 1.26 | 0001784440 | 0001419951 | 0001764046 |
3 | remainder_Assets | -1.74 | -0.219 | -0.0163 | 0.574 | 1.56 | 0001784440 | 0000008670 | 0001755101 |
4 | LiabilitiesCurrent | -9.97 | -0.579 | 0.168 | 1.17 | 1.94 | 0001784440 | 0001764046 | 0001683252 |
5 | LiabilitiesNonCurrent | -6.91 | -0.688 | -0.0660 | 0.341 | 0.488 | 0001784440 | 0001499961 | 0001494259 |
6 | remainder_Liabilities | -2.33 | -0.472 | 0.0531 | 0.175 | 0.440 | 0001784440 | 0001801661 | 0001864448 |
7 | CostOfGoodsAndServicesSold | -1.56 | -1.19 | 0.0838 | 0.408 | 1.62 | 0001435617 | 0001482554 | 0001784440 |
8 | SellingExpense | -8.59 | -0.471 | 0.0352 | 0.417 | 0.928 | 0001784440 | 0001389002 | 0001435617 |
9 | GeneralAndAdministrativeExpense | -1.21 | -0.523 | 0.0507 | 0.355 | 1.20 | 0001131903 | 0001606745 | 0001784440 |
10 | ResearchAndDevelopment | -1.02 | -0.361 | 0.0638 | 0.200 | 0.629 | 0001884164 | 0000909494 | 0001784440 |
11 | DepreciationDepletionAndAmortization | -0.853 | -0.232 | 0.0536 | 0.116 | 0.366 | 0001022505 | 0001627475 | 0001784440 |
12 | remainder_Expenses | -8.25 | -3.40 | 0.245 | 0.537 | 0.631 | 0001784440 | 0001559865 | 0001650164 |
13 | remainder_Revenues | -3.94 | -0.798 | 0.00161 | 1.28 | 1.70 | 0001784440 | 0001389002 | 0001494259 |
14 | remainder_NetIncome | -0.475 | -0.274 | 0.0292 | 0.142 | 1.18 | 0001597846 | 0001419951 | 0001784440 |
15 | remainder_ComprehensiveNetIncome | -0.0925 | -0.0300 | 0.00185 | 0.0253 | 0.195 | 0001764046 | 0001691077 | 0001864448 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Assets | -13.8 | -2.61 | 0.0297 | 0.590 | 1.31 | 0001784440 | 0001313275 | 0001853825 |
1 | Liabilities | -11.6 | -0.574 | 0.0683 | 0.826 | 1.25 | 0001784440 | 0001809519 | 0001494259 |
2 | Expenses | -13.0 | -2.59 | 0.120 | 0.525 | 0.635 | 0001784440 | 0001384905 | 0001442145 |
3 | Revenues | -3.94 | -0.798 | 0.00161 | 1.28 | 1.70 | 0001784440 | 0001389002 | 0001494259 |
4 | StockholdersEquity | -1.69 | -1.27 | 0.104 | 0.963 | 1.20 | 0001683252 | 0001442145 | 0001853825 |
5 | NetIncome | -15.8 | -2.66 | 0.365 | 0.862 | 1.37 | 0001784440 | 0001719489 | 0001494259 |
6 | ComprehensiveNetIncome | -15.8 | -2.66 | 0.358 | 0.870 | 1.38 | 0001784440 | 0001719489 | 0001494259 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000008670 | 0001566469 | 0000008670 |
8 | EconomicCapitalRatio | -17.2 | -3.08 | 0.881 | 1.77 | 2.23 | 0001784440 | 0001764046 | 0000050471 |
Estimates
Parameter | Value | Min | Max |
---|---|---|---|
PresentValueFactor | 1.0 | 1.0 | 15.0 |
BalanceFactor | 0.82 | 0.5 | 5.0 |
OCIFactor | 1.0 | 0.5 | 1.0 |
HiddenReservesFactor | 0.0 | 0.0 | 0.0 |
LLPO_stddev | 2.98 | 0.2 | 10.0 |