QA: us_data_processing 2016-2022

Table of Contents

Ranks across the years

name name_short 2016 2017 2018 2019 2020 2021 2022 2016-val 2017-val 2018-val 2019-val 2020-val 2021-val 2022-val 2016->2017 2017->2018 2018->2019 2019->2020 2020->2021 2021->2022
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
0001597846
error 1 × Negative Expenses, ignoring company. pre-agg
0001635965
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001584423
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001433714 0001635748
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
0001131903

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
0001597846
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001584423
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
0001433714
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
0001131903
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001433714
warning 1 × Ignoring company because Expenses is zero pre-agg
0001682325

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
0001353499
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001683252
warning 2 × Ignoring company because Expenses is zero pre-agg
0001682325 0001683606
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.822121060927299}
warning 1 × Similarly named company. Duplicate? None
0001597846
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001353499
warning 1 × Ignoring company because Assets is zero pre-agg
0001353499

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
0001353499 0001753373 0001740797 0001659183 0001622231
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001735092
warning 5 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001353499 0001753373 0001740797 0001659183 0001622231
warning 2 × Similarly named company. Duplicate? None
0001755101 0001597846
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
0001365038
warning 1 × Ignoring company because Expenses is zero pre-agg
0001683606
warning 1 × Ignoring company because Assets is zero pre-agg
0001353499

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
0001753373 0001740797
error 1 × Negative Expenses, ignoring company. pre-agg
0001688126
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001753373 0001740797
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001365038 0001688126
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.2988000749640487}
warning 1 × Similarly named company. Duplicate? None
0001597846
warning 1 × Negative minimum value check_abs_values
{'var_name': 'GeneralAndAdministrativeExpense', 'min_value': -720000000}
warning 1 × Missing logo subcommand.report
0001784440
warning 1 × Ignoring company because Expenses is zero pre-agg
0001507605

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
0001755101 0001597846
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.3841409654730956}
warning 1 × Missing logo subcommand.report
0001784440
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001784440
warning 1 × Ignoring company because Expenses is zero pre-agg
0001393548
warning 1 × Ignoring company because Assets is zero pre-agg
0001353499
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001784440

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
0001784970
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001683252 0001784440
warning 2 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001683252 0001784440
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.8987004315940763}
warning 1 × Similarly named company. Duplicate? None
0001597846
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001753373
warning 1 × Negative minimum value check_abs_values
{'var_name': 'GeneralAndAdministrativeExpense', 'min_value': -354200000}
warning 1 × Missing logo subcommand.report
0001784440

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