QA: us_programming 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
0000836690 INNOVATIVE SOLUTIONS & SUPPORT INC INNOVAT 3 2 5 1 15 3 1 432.2630 460.3570 401.70300 465.23200 272.71800 470.9790 445.24000 -1 3 -4 14 -12 -2
0000891103 Match Group Inc. Match G NaN NaN NaN 2 7 21 2 NaN NaN NaN 417.02300 379.10700 331.8260 411.98800 NaN NaN NaN 5 14 -19
0001800392 MicroAlgo Inc. MicroAl NaN NaN NaN NaN NaN 5 3 NaN NaN NaN NaN NaN 464.7920 405.08700 NaN NaN NaN NaN NaN -2
0001800227 IAC Inc. IAC Inc NaN NaN NaN NaN 2 7 4 NaN NaN NaN NaN 441.65200 420.5830 388.07800 NaN NaN NaN NaN 5 -3
0001838672 AdTheorent Holding Company Inc. AdTheor NaN NaN NaN NaN NaN 34 5 NaN NaN NaN NaN NaN 203.1900 386.36700 NaN NaN NaN NaN NaN -29
0001819928 DoubleVerify Holdings Inc. DoubleV NaN NaN NaN NaN NaN 6 6 NaN NaN NaN NaN NaN 422.6470 383.38200 NaN NaN NaN NaN NaN 0
0001506293 PINTEREST INC. PINTERE NaN NaN NaN 16 9 9 7 NaN NaN NaN 244.14800 374.41000 406.0650 371.79900 NaN NaN NaN -7 0 -2
0001846069 Nextdoor Holdings Inc. Nextdoo NaN NaN NaN NaN NaN 12 8 NaN NaN NaN NaN NaN 380.8300 349.89600 NaN NaN NaN NaN NaN -4
0001173489 CEVA INC CEVA IN 2 3 2 5 8 13 9 437.7860 449.1300 437.55000 375.99000 376.88100 371.9690 348.62400 1 -1 3 3 5 -4
0001597033 Sabre Corp Sabre C 11 9 7 6 10 16 10 347.0500 372.7810 371.49800 361.24700 366.93800 351.2320 348.09700 -2 -2 -1 4 6 -6
0001352010 EPAM Systems Inc. EPAM Sy 6 10 8 11 12 24 11 397.8780 343.3900 359.00000 307.49700 319.07600 307.2890 326.63500 4 -2 3 1 12 -13
0001095565 HEALTHSTREAM INC HEALTHS 14 14 11 9 11 19 12 315.9690 315.1260 328.24600 337.95900 320.69700 339.6700 321.58100 0 -3 -2 2 8 -7
0001652044 Alphabet Inc. Alphabe 10 11 9 10 13 23 13 388.9970 337.9940 343.10100 321.27500 300.34500 317.9730 306.73000 1 -2 1 3 10 -10
0001058290 COGNIZANT TECHNOLOGY SOLUTIONS CORP COGNIZA 13 16 12 15 17 25 14 331.7430 298.9700 311.69900 287.73300 258.91700 282.0570 291.60000 3 -4 3 2 8 -11
0001326801 Meta Platforms Inc. Meta Pl 1 4 1 8 6 14 15 465.9980 448.0490 441.65800 342.36200 387.79700 357.2250 283.96400 3 -3 7 -2 8 1
0001854445 Glimpse Group Inc. Glimpse NaN NaN NaN NaN NaN 69 16 NaN NaN NaN NaN NaN -291.6180 274.44700 NaN NaN NaN NaN NaN -53
0000098338 TSR INC TSR INC 20 25 19 28 40 57 17 265.7040 190.3430 237.14500 176.07400 83.61730 68.5705 272.21700 5 -6 9 12 17 -40
0001874097 Cyngn Inc. Cyngn I NaN NaN NaN NaN NaN 17 18 NaN NaN NaN NaN NaN 346.3920 268.89500 NaN NaN NaN NaN NaN 1
0001828791 Viant Technology Inc. Viant T NaN NaN NaN NaN NaN 26 19 NaN NaN NaN NaN NaN 271.6910 251.59600 NaN NaN NaN NaN NaN -7
0001830043 Bumble Inc. Bumble NaN NaN NaN NaN NaN 27 20 NaN NaN NaN NaN NaN 265.9190 250.20400 NaN NaN NaN NaN NaN -7
0001640428 EverQuote Inc. EverQuo NaN NaN 21 25 23 36 21 NaN NaN 208.83500 188.35800 178.29000 190.1100 236.11500 NaN NaN 4 -2 13 -15
0001327318 TrueCar Inc. TrueCar 17 12 10 13 4 15 22 285.1680 332.0090 342.98200 296.37900 405.64200 356.0850 227.05500 -5 -2 3 -9 11 7
0000023111 COMPUTER TASK GROUP INC COMPUTE 28 19 28 34 27 37 23 174.7140 233.7500 173.28400 135.22200 159.65200 182.7780 219.44400 -9 9 6 -7 10 -14
0001662574 Grom Social Enterprises Inc. Grom So 47 37 37 37 35 32 24 -586.1450 65.4936 70.53650 105.13800 111.42900 214.9020 208.61100 -10 0 0 -2 -3 -8
0001837686 Vimeo Inc. Vimeo I NaN NaN NaN NaN NaN 33 25 NaN NaN NaN NaN NaN 205.3240 202.21900 NaN NaN NaN NaN NaN -8
0001169445 COMPUTER PROGRAMS & SYSTEMS INC COMPUTE 29 33 26 23 20 30 26 157.4710 129.9970 174.49600 201.74600 234.65000 218.4400 194.94400 4 -7 -3 -3 10 -4
0001841209 MicroCloud Hologram Inc. MicroCl NaN NaN NaN NaN NaN 4 27 NaN NaN NaN NaN NaN 470.1050 173.88300 NaN NaN NaN NaN NaN 23
0001422930 PubMatic Inc. PubMati NaN NaN NaN NaN NaN 40 28 NaN NaN NaN NaN NaN 173.9970 172.27900 NaN NaN NaN NaN NaN -12
0001866550 Thoughtworks Holding Inc. Thought NaN NaN NaN NaN NaN 43 29 NaN NaN NaN NaN NaN 156.6490 169.13200 NaN NaN NaN NaN NaN -14
0001636422 Health Catalyst Inc. Health NaN NaN NaN 22 31 35 30 NaN NaN NaN 214.72100 125.95800 198.3430 167.56900 NaN NaN NaN 9 4 -5
0001671933 Trade Desk Inc. Trade D 32 35 33 35 29 45 31 98.3856 103.2450 122.45600 120.35900 129.76600 145.4720 165.09900 3 -2 2 -6 16 -14
0001085869 PERFICIENT INC PERFICI 12 15 18 18 16 46 32 341.8130 305.1100 238.01700 227.71700 265.63400 141.4370 148.35600 3 3 0 -2 30 -14
0001376321 ZW Data Action Technologies Inc. ZW Data NaN 32 42 21 26 NaN 33 NaN 131.1350 8.50631 214.82600 169.87600 NaN 137.79400 NaN 10 -21 5 NaN NaN
0001013237 Factset Research Systems Inc Factset 23 29 31 27 25 38 34 229.1390 160.6830 145.20500 176.34800 173.53300 182.5390 114.79300 6 2 -4 -2 13 -4
0001131554 SYNCHRONOSS TECHNOLOGIES INC SYNCHRO 7 13 23 17 14 48 35 395.7180 320.9910 185.17600 241.12200 298.57900 113.9020 109.99600 6 10 -6 -3 34 -13
0001526520 TripAdvisor Inc. TripAdv 19 22 16 20 30 54 36 268.0630 220.7210 271.70500 223.61300 125.97400 94.6814 102.69700 3 -6 4 10 24 -18
0001118417 MODEL N INC. MODEL N 30 38 41 40 34 55 37 156.9030 35.1015 43.74720 76.42350 116.65900 91.6020 93.84560 8 3 -1 -6 21 -18
0001739936 MOMENTIVE GLOBAL INC. MOMENTI NaN NaN 38 38 36 53 38 NaN NaN 62.39010 103.27100 109.61400 96.6525 91.40190 NaN NaN 0 -2 17 -15
0001595974 MAGNITE INC. MAGNITE 27 36 36 41 33 52 39 200.6390 71.6692 72.91930 74.58460 120.91800 99.2093 79.86110 9 0 5 -8 19 -13
0001454938 Outbrain Inc. Outbrai NaN NaN NaN NaN NaN 51 40 NaN NaN NaN NaN NaN 100.6320 76.99540 NaN NaN NaN NaN NaN -11
0001564408 Snap Inc Snap In NaN 28 17 33 32 42 41 NaN 161.0040 271.47000 152.92300 122.71200 160.1210 69.43300 NaN -11 16 -1 10 -1
0001475115 Eventbrite Inc. Eventbr NaN NaN 30 31 41 63 42 NaN NaN 155.37700 167.80800 79.79150 30.5574 43.43300 NaN NaN 1 10 22 -21
0001546296 Professional Diversity Network Inc. Profess NaN 41 48 46 45 60 43 NaN -23.3520 -396.51600 28.42610 44.39620 52.6072 42.70150 NaN 7 -2 -1 15 -17
0001563190 Compass Inc. Compass NaN NaN NaN NaN NaN 49 44 NaN NaN NaN NaN NaN 109.8710 41.87760 NaN NaN NaN NaN NaN -5
0001713683 Zscaler Inc. Zscaler NaN NaN 27 32 42 61 45 NaN NaN 173.98700 167.22500 68.40270 50.3713 35.94100 NaN NaN 5 10 19 -16
0001617553 ZIPRECRUITER INC. ZIPRECR NaN NaN NaN NaN NaN 31 46 NaN NaN NaN NaN NaN 215.6640 22.07180 NaN NaN NaN NaN NaN 15
0001596961 RumbleOn Inc. RumbleO 16 20 NaN NaN NaN 47 47 293.8190 231.3110 NaN NaN NaN 134.5040 19.43150 4 NaN NaN NaN NaN 0
0001794905 Cyxtera Technologies Inc. Cyxtera NaN NaN NaN NaN NaN 62 48 NaN NaN NaN NaN NaN 45.5633 16.98220 NaN NaN NaN NaN NaN -14
0001810019 Rackspace Technology Inc. Rackspa NaN NaN NaN NaN 43 59 49 NaN NaN NaN NaN 55.83340 55.4584 12.19230 NaN NaN NaN NaN 16 -10
0001582961 DigitalOcean Holdings Inc. Digital NaN NaN NaN NaN NaN 56 50 NaN NaN NaN NaN NaN 80.2515 5.37699 NaN NaN NaN NaN NaN -6
0001752474 KLDiscovery Inc. KLDisco NaN NaN NaN 44 44 64 51 NaN NaN NaN 64.04410 50.04270 18.8870 3.25259 NaN NaN NaN 0 20 -13
0001820144 Grindr Inc. Grindr NaN NaN NaN NaN NaN 8 52 NaN NaN NaN NaN NaN 414.9430 2.63421 NaN NaN NaN NaN NaN 44
0001567900 BLACKBOXSTOCKS INC. BLACKBO NaN 50 53 59 53 NaN 53 NaN -578.3870 -570.40400 -644.07400 -244.11100 NaN -10.34810 NaN 3 6 -6 NaN NaN
0001529113 INPIXON INPIXON NaN NaN NaN NaN 21 28 54 NaN NaN NaN NaN 208.00900 252.8220 -11.10530 NaN NaN NaN NaN 7 26
0001666071 Cardlytics Inc. Cardlyt NaN NaN 40 19 38 41 55 NaN NaN 49.88570 224.69100 94.98720 171.7230 -12.00710 NaN NaN -21 19 3 14
0001392972 PROS Holdings Inc. PROS Ho 37 NaN NaN NaN 46 66 56 -47.7521 NaN NaN NaN 41.09740 -20.3913 -42.70090 NaN NaN NaN NaN 20 -10
0001462223 Recruiter.com Group Inc. Recruit 44 49 14 52 NaN 50 57 -540.7360 -553.6440 292.90000 -227.35100 NaN 106.6870 -76.85650 5 -35 38 NaN NaN 7
0001746278 GoLogiq Inc. GoLogiq NaN NaN NaN NaN NaN 76 58 NaN NaN NaN NaN NaN -674.3420 -105.56500 NaN NaN NaN NaN NaN -18
0001014473 VERISIGN INC CA VERISIG 38 42 44 50 49 67 59 -84.7311 -73.2914 -106.31700 -115.42800 -100.53900 -83.5166 -123.40200 4 2 6 -1 18 -8
0001568385 Bright Mountain Media Inc. Bright 34 43 39 7 54 68 60 21.4955 -87.4938 54.71360 360.22500 -253.72800 -96.5710 -128.86500 9 -4 -32 47 14 -8
0001799332 GAN Ltd GAN Ltd NaN NaN NaN NaN NaN 18 61 NaN NaN NaN NaN NaN 342.9580 -246.42000 NaN NaN NaN NaN NaN 43
0001616156 WEWARDS INC. WEWARDS 41 46 46 53 55 71 62 -352.8770 -201.6670 -157.56300 -247.60100 -255.02300 -327.3220 -465.58800 5 0 7 2 16 -9
0001730732 3FORCES INC. 3FORCES NaN NaN NaN 54 58 72 63 NaN NaN NaN -314.91200 -394.31100 -385.7260 -478.41700 NaN NaN NaN 4 14 -9
0000746210 Oblong Inc. Oblong NaN 6 25 24 18 20 64 NaN 420.5830 174.87000 189.23400 257.23000 335.6840 -517.11900 NaN 19 -1 -6 2 44
0001811999 FARMHOUSE INC. NV FARMHOU NaN NaN NaN NaN 62 75 65 NaN NaN NaN NaN -750.02700 -670.4390 -541.33300 NaN NaN NaN NaN 13 -10
0001686515 Ecco Auto World Corp Ecco Au NaN NaN NaN 48 56 65 66 NaN NaN NaN -49.39050 -297.04700 -12.4521 -603.27100 NaN NaN NaN 8 9 1
0001082733 VISIUM TECHNOLOGIES INC. VISIUM 42 52 55 60 60 77 67 -474.1300 -606.4110 -590.93800 -648.65500 -622.22500 -734.7460 -916.62300 10 3 5 0 17 -10
0001815632 Tego Cyber Inc. Tego Cy NaN NaN NaN NaN NaN 44 68 NaN NaN NaN NaN NaN 155.2450 -1007.96000 NaN NaN NaN NaN NaN 24
0001715433 Leader Capital Holdings Corp. Leader NaN NaN 13 47 51 73 69 NaN NaN 297.00700 -7.74599 -169.23300 -397.4750 -1142.25000 NaN NaN 34 4 22 -4
0001514056 TRAQIQ INC. TRAQIQ 45 51 52 51 52 NaN 70 -546.4490 -591.1300 -566.37600 -164.82000 -230.91500 NaN -1867.87000 6 1 -1 1 NaN NaN
0000929940 ASPENTECH Corp ASPENTE 33 44 45 12 5 2 NaN 34.7435 -97.1148 -106.87800 300.49400 388.16300 476.8700 NaN 11 1 -33 -7 -3 NaN
0000945384 CICERO INC CICERO 46 47 51 57 NaN NaN NaN -563.6550 -545.1570 -548.16400 -522.78400 NaN NaN NaN 1 4 6 NaN NaN NaN
0001017968 EDGEWATER TECHNOLOGY INC DE EDGEWAT 18 23 NaN NaN NaN NaN NaN 284.1950 196.1890 NaN NaN NaN NaN NaN 5 NaN NaN NaN NaN NaN
0001023364 AutoWeb Inc. AutoWeb 15 31 35 39 37 22 NaN 295.1820 144.1870 84.04910 98.23960 99.34920 324.4800 NaN 16 4 4 -2 -15 NaN
0001035748 CALLIDUS SOFTWARE INC CALLIDU 25 26 NaN NaN NaN NaN NaN 215.0960 186.3440 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001046327 REALNETWORKS INC REALNET 26 21 20 NaN NaN NaN NaN 203.4630 224.3790 212.30800 NaN NaN NaN NaN -5 -1 NaN NaN NaN NaN
0001052054 Symbolic Logic Inc. Symboli 21 18 34 43 24 1 NaN 255.6140 236.0740 105.95600 69.03680 177.59300 645.4230 NaN -3 16 9 -19 -23 NaN
0001056386 Internap Corp Interna 35 39 43 49 NaN NaN NaN -40.1700 -10.6849 -11.09330 -78.62020 NaN NaN NaN 4 4 6 NaN NaN NaN
0001085621 Actua Corp Actua C 9 1 NaN NaN NaN NaN NaN 389.3980 536.1760 NaN NaN NaN NaN NaN -8 NaN NaN NaN NaN NaN
0001366246 GLU MOBILE INC GLU MOB 24 34 22 30 19 NaN NaN 215.2200 118.6220 193.27800 167.97500 245.88000 NaN NaN 10 -12 8 -11 NaN NaN
0001385292 Monotype Imaging Holdings Inc. Monotyp 4 7 3 NaN NaN NaN NaN 430.9550 415.7340 413.78800 NaN NaN NaN NaN 3 -4 NaN NaN NaN NaN
0001408278 Synacor Inc. Synacor 31 30 24 29 28 NaN NaN 118.5080 154.5250 182.96600 171.49600 151.10300 NaN NaN -1 -6 5 -1 NaN NaN
0001418091 TWITTER INC. TWITTER 22 17 15 14 22 39 NaN 244.0840 262.3770 280.79200 290.08500 201.18000 176.2830 NaN -5 -2 -1 8 17 NaN
0001419582 BLUE SPHERE CORP. BLUE SP 36 40 NaN NaN NaN NaN NaN -45.6240 -21.6250 NaN NaN NaN NaN NaN 4 NaN NaN NaN NaN NaN
0001448558 GROW CAPITAL INC. GROW CA 39 45 47 42 50 NaN NaN -185.1780 -172.0640 -186.84900 71.63860 -163.86600 NaN NaN 6 2 -5 8 NaN NaN
0001516805 Moxian Inc. Moxian 40 57 57 NaN 57 NaN NaN -307.3230 -910.0220 -688.27000 NaN -324.80600 NaN NaN 17 0 NaN NaN NaN NaN
0001568969 APPYEA INC APPYEA 51 54 59 NaN NaN NaN NaN -5360.4900 -689.5770 -754.35600 NaN NaN NaN NaN 3 5 NaN NaN NaN NaN
0001575189 Match Group Holdings II LLC Match G 8 5 4 3 NaN NaN NaN 391.3990 423.6990 413.07700 411.52700 NaN NaN NaN -3 -1 -1 NaN NaN NaN
0001593773 AMJ Global Technology AMJ Glo 49 24 NaN NaN NaN NaN NaN -831.4990 194.2690 NaN NaN NaN NaN NaN -25 NaN NaN NaN NaN NaN
0001598014 IHS Markit Ltd. IHS Mar 5 8 6 4 3 11 NaN 416.1300 405.8770 387.58500 408.27900 415.18000 386.5730 NaN 3 -2 -2 -1 8 NaN
0001627611 12 Retech Corp 12 Rete 43 NaN 60 58 61 74 NaN -526.9640 NaN -1092.31000 -643.56100 -669.31000 -543.1810 NaN NaN NaN -2 3 13 NaN
0001628104 XSport Global Inc. XSport 50 53 49 NaN NaN NaN NaN -900.5110 -611.7760 -420.09600 NaN NaN NaN NaN 3 -4 NaN NaN NaN NaN
0001653979 JACC STUDIOS INC. JACC ST 48 55 56 55 NaN NaN NaN -629.1900 -701.0580 -642.38500 -356.63600 NaN NaN NaN 7 1 -1 NaN NaN NaN
0001378125 Toga Ltd Toga Lt NaN 56 58 26 NaN NaN NaN NaN -727.9230 -694.35500 187.42400 NaN NaN NaN NaN 2 -32 NaN NaN NaN
0001381871 bowmo Inc. bowmo I NaN 48 54 NaN NaN NaN NaN NaN -550.0880 -586.45900 NaN NaN NaN NaN NaN 6 NaN NaN NaN NaN
0001710583 Switch Inc. Switch NaN 27 29 36 39 58 NaN NaN 176.8090 164.47300 110.87100 87.60460 61.2091 NaN NaN 2 7 3 19 NaN
0001725579 Pluralsight Inc. Plurals NaN NaN 32 45 47 NaN NaN NaN NaN 123.15800 52.88840 33.05720 NaN NaN NaN NaN 13 2 NaN NaN
0001737372 Sysorex Inc. Sysorex NaN NaN 50 56 59 70 NaN NaN NaN -463.46800 -446.72300 -425.77200 -310.6530 NaN NaN NaN 6 3 11 NaN
0001753931 Shengda Network Technology Inc. Shengda NaN NaN NaN NaN 48 10 NaN NaN NaN NaN NaN -8.67542 391.9040 NaN NaN NaN NaN NaN -38 NaN
0001774155 BTRS Holdings Inc. BTRS Ho NaN NaN NaN NaN 1 29 NaN NaN NaN NaN NaN 458.56000 224.6600 NaN NaN NaN NaN NaN 28 NaN

PDF reports

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

2016

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001543272
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001567900
warning 4 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '51 of 51'}
{'var_name': 'IntangibleAssets', 'zeros': '51 of 51'}
{'var_name': 'LeaseAssets', 'zeros': '51 of 51'}
{'var_name': 'LeaseLiability', 'zeros': '51 of 51'}
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.316088140522744}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -7.3034459717585225}
warning 1 × Similarly named company. Duplicate? None
0001169445
warning 1 × Missing logo subcommand.report
0001366246
warning 1 × Ignoring company because Expenses is zero pre-agg
0001611019

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 23.0 980 92,896,340 6,626,098,000 105,408,000,000 0001627611 0001118417 0001652044
1 AssetsNonCurrent 0 0 1,196,875 516,079,500 5,878,000,000 0000945384 0000929940 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001366246 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001366246 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001366246 0000023111
5 remainder_Assets 0 0 57,222,980 9,147,800,000 56,211,000,000 0001082733 0000929940 0001652044
6 LiabilitiesCurrent 0 24,019 38,691,585 1,969,974,500 16,756,000,000 0000098338 0001046327 0001652044
7 LiabilitiesNonCurrent 0 0 426 1,486,109,000 6,600,000,000 0000098338 0001597033 0001652044
8 LeaseLiability 0 0 0 0 0 0000023111 0001366246 0000023111
9 remainder_Liabilities 0 0 42,129 229,354,000 5,105,000,000 0000929940 0001595974 0001652044
10 CostOfGoodsAndServicesSold 0 0 615,946 1,662,681,000 35,138,000,000 0000023111 0001662574 0001652044
11 GeneralAndAdministrativeExpense 0 0 106,053 236,199,000 6,985,000,000 0000023111 0001662574 0001652044
12 SellingExpense 0 0 32,288,430 1,844,414,500 10,485,000,000 0000023111 0001118417 0001652044
13 ResearchAndDevelopmentExpense 0 0 0 410,081,500 13,948,000,000 0000023111 0001056386 0001652044
14 remainder_Expenses 0 522 5,860,525 1,455,293,500 9,272,000,000 0001082733 0001516805 0001058290
15 remainder_Revenues 0 0 126,526,255 8,430,193,500 90,272,000,000 0000023111 0001017968 0001652044
16 remainder_NetIncome -125,988,000 -32,339,000 0 104,237,000 434,000,000 0001597033 0001616156 0001652044
17 remainder_ComprehensiveNetIncome -528,000,000 -143,863,000 0 914,500 7,027,000 0001652044 0001593773 0001131554
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 154 3,864 227,728,205 14,099,300,000 167,497,000,000 0001514056 0001392972 0001652044
1 Liabilities 9,489 51,614 48,512,320 3,534,583,500 28,461,000,000 0001653979 0001385292 0001652044
2 Expenses 8,690 37,055 153,397,965 7,507,917,000 71,228,000,000 0001514056 0001023364 0001652044
3 Revenues 0 0 126,526,255 8,430,193,500 90,272,000,000 0000023111 0001017968 0001652044
4 StockholdersEquity -1,200,595,000 -7,816,028 75,789,225 11,626,100,000 139,036,000,000 0001014473 0001017968 0001652044
5 NetIncome -456,873,000 -81,332,500 -29,483 996,822,500 19,478,000,000 0001418091 0001653979 0001652044
6 ComprehensiveNetIncome -480,560,000 -90,954,500 -77,293 993,092,500 18,950,000,000 0001418091 0001616156 0001652044
7 BaseVar 27,381 73,002 312,892,093 18,637,440,500 206,016,230,000 0001653979 0001023364 0001652044
8 EconomicCapitalRatio -53.6 -7.30 2.04 4.32 4.66 0001568969 0001046327 0001326801

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 -46.7 -3.71 -0.0424 1.24 3.75 0001568969 0001327318 0001596961
1 AssetsNonCurrent -9.21 -0.277 -0.0347 0.0789 0.686 0001568969 0001052054 0000023111
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001366246 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001366246 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001366246 0000023111
5 remainder_Assets -44.3 -3.88 -0.115 1.46 1.86 0001568969 0001058290 0001598014
6 LiabilitiesCurrent -38.3 -1.32 0.944 2.49 5.59 0001568969 0001598014 0001593773
7 LiabilitiesNonCurrent -24.4 -1.66 0.390 0.871 1.96 0001568969 0001035748 0000098338
8 LeaseLiability 0 0 0 0 0 0000023111 0001366246 0000023111
9 remainder_Liabilities -16.8 -1.13 0.0939 0.403 21.8 0001568969 0001085621 0001628104
10 CostOfGoodsAndServicesSold -6.03 -1.27 0.136 0.418 3.70 0000098338 0000929940 0001568969
11 GeneralAndAdministrativeExpense -4.69 -0.493 0.136 0.424 2.22 0001653979 0001462223 0001568969
12 SellingExpense -1.50 -0.558 0.0298 0.439 3.55 0001568385 0001598014 0001568969
13 ResearchAndDevelopmentExpense -0.464 -0.313 0.0583 0.215 1.32 0001516805 0000023111 0001568969
14 remainder_Expenses -31.5 -0.978 0.230 0.629 1.82 0001568969 0001575189 0000098338
15 remainder_Revenues -11.1 -1.16 0.201 1.10 4.94 0001568969 0001385292 0000098338
16 remainder_NetIncome -17.2 -0.344 0.0248 0.456 0.818 0001568969 0001326801 0001082733
17 remainder_ComprehensiveNetIncome -0.174 -0.0337 0.00717 0.0313 0.115 0001052054 0001595974 0001568969
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -51.5 -5.92 -0.0563 0.969 2.21 0001568969 0001448558 0001596961
1 Liabilities -40.8 -1.41 1.24 3.04 4.79 0001568969 0001526520 0000098338
2 Expenses -20.7 -2.73 0.145 0.533 0.763 0001568969 0001095565 0000023111
3 Revenues -11.1 -1.16 0.201 1.10 4.94 0001568969 0001385292 0000098338
4 StockholdersEquity -9.40 -5.67 1.25 3.51 3.58 0001568969 0001595974 0001598014
5 NetIncome -49.1 -3.31 0.416 1.05 2.32 0001568969 0001671933 0000098338
6 ComprehensiveNetIncome -49.0 -3.30 0.422 1.05 2.36 0001568969 0001671933 0000098338
7 BaseVar nan nan nan nan nan 0000023111 0001366246 0000023111
8 EconomicCapitalRatio -53.1 -6.81 2.53 4.81 5.15 0001568969 0001046327 0001326801

2017

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001543272
warning 4 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '57 of 57'}
{'var_name': 'IntangibleAssets', 'zeros': '57 of 57'}
{'var_name': 'LeaseAssets', 'zeros': '57 of 57'}
{'var_name': 'LeaseLiability', 'zeros': '57 of 57'}
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.48265491881333}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.918733322324813}
warning 1 × Similarly named company. Duplicate? None
0001169445
warning 1 × Missing logo subcommand.report
0001366246
warning 1 × Ignoring company because Assets is zero pre-agg
0001657249

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 100 2,247 58,827,104 6,079,707,200 124,988,000,000 0001378125 0001408278 0001652044
1 AssetsNonCurrent 0 0 219,108 476,788,400 10,485,000,000 0000945384 0001017968 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001378125 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001378125 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001378125 0000023111
5 remainder_Assets 0 0 39,965,988 7,230,640,000 61,822,000,000 0001082733 0001023364 0001652044
6 LiabilitiesCurrent 0 103,910 32,765,355 2,092,680,000 24,613,000,000 0000098338 0000023111 0001652044
7 LiabilitiesNonCurrent 0 0 63,728 1,698,586,200 7,028,000,000 0000098338 0001408278 0001652044
8 LeaseLiability 0 0 0 0 0 0000023111 0001378125 0000023111
9 remainder_Liabilities -24,866,000 0 0 320,762,600 13,152,000,000 0001419582 0001017968 0001652044
10 CostOfGoodsAndServicesSold 0 0 2,234,760 1,581,491,400 45,583,000,000 0000023111 0001419582 0001652044
11 GeneralAndAdministrativeExpense 0 0 1,114,265 534,229,400 6,872,000,000 0000023111 0001567900 0001652044
12 SellingExpense 0 0 22,964,133 1,430,600,000 12,893,000,000 0000023111 0001046327 0001652044
13 ResearchAndDevelopmentExpense 0 0 0 740,580,600 16,625,000,000 0000023111 0001085869 0001652044
14 remainder_Expenses -14,886,000 -530,400 5,035,032 1,454,106,400 17,267,000,000 0001564408 0001516805 0001652044
15 remainder_Revenues 0 0 87,642,778 5,841,760,000 110,855,000,000 0000023111 0001173489 0001652044
16 remainder_NetIncome -157,100,000 -39,140,400 0 220,870,800 1,047,000,000 0001598014 0001567900 0001652044
17 remainder_ComprehensiveNetIncome -5,824,000 -143,200 0 217,940,000 1,410,000,000 0001710583 0000945384 0001652044
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 100 2,247 127,883,086 14,687,720,000 197,295,000,000 0001378125 0000023111 0001652044
1 Liabilities 15,888 385,866 42,564,305 4,271,567,200 44,793,000,000 0001653979 0001419582 0001652044
2 Expenses 12,136 95,433 140,649,731 6,132,911,200 99,240,000,000 0001653979 0001017968 0001652044
3 Revenues 0 0 87,642,778 5,841,760,000 110,855,000,000 0000023111 0001173489 0001652044
4 StockholdersEquity -1,260,271,000 -5,267,388 52,990,627 11,064,860,000 152,502,000,000 0001014473 0001017968 0001652044
5 NetIncome -3,445,066,000 -110,196,200 -1,258,600 666,598,400 15,934,000,000 0001564408 0001567900 0001326801
6 ComprehensiveNetIncome -3,428,852,000 -91,933,200 -700,482 954,160,000 16,410,000,000 0001564408 0001381871 0001326801
7 BaseVar 16,107 633,707 277,074,702 16,168,621,200 262,391,080,000 0001653979 0001408278 0001652044
8 EconomicCapitalRatio -9.10 -6.92 1.61 4.48 5.36 0001516805 0001013237 0001085621

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.06 -2.67 -0.216 1.31 2.29 0001516805 0001597033 0001671933
1 AssetsNonCurrent -0.246 -0.0934 -0.0170 0.0667 0.137 0001567900 0001596961 0001419582
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001378125 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001378125 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001378125 0000023111
5 remainder_Assets -4.84 -2.52 -0.121 1.75 1.87 0001567900 0001327318 0001448558
6 LiabilitiesCurrent -1.84 -0.698 1.22 3.35 5.32 0000929940 0001546296 0001378125
7 LiabilitiesNonCurrent -4.14 -1.46 0.420 1.05 1.81 0001419582 0001595974 0000098338
8 LeaseLiability 0 0 0 0 0 0000023111 0001378125 0000023111
9 remainder_Liabilities -4.15 -0.933 0.313 0.783 1.23 0001616156 0001595974 0001419582
10 CostOfGoodsAndServicesSold -5.46 -1.17 0.0979 0.479 0.601 0000098338 0001514056 0001023364
11 GeneralAndAdministrativeExpense -3.17 -1.45 0.138 0.477 1.15 0001567900 0000929940 0000098338
12 SellingExpense -2.53 -0.726 0.0625 0.356 0.874 0001516805 0000836690 0001567900
13 ResearchAndDevelopmentExpense -0.896 -0.412 0.0873 0.266 0.519 0001564408 0001448558 0000098338
14 remainder_Expenses -3.24 -1.50 0.161 0.416 1.39 0001023364 0001598014 0000098338
15 remainder_Revenues -1.54 -0.814 0.135 1.36 4.54 0001516805 0001173489 0000098338
16 remainder_NetIncome -0.736 -0.261 -0.0386 0.330 3.21 0001568969 0001526520 0000746210
17 remainder_ComprehensiveNetIncome -0.0453 -0.0271 -0.00849 0.0492 0.0576 0000098338 0001593773 0001575189
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -6.74 -4.32 0.0826 1.15 2.14 0001516805 0001616156 0000023111
1 Liabilities -1.96 -1.40 1.45 2.92 4.20 0001014473 0001046327 0000098338
2 Expenses -3.89 -1.86 0.00864 0.561 0.800 0001567900 0001169445 0001085621
3 Revenues -1.54 -0.814 0.135 1.36 4.54 0001516805 0001173489 0000098338
4 StockholdersEquity -5.77 -5.57 0.826 3.48 4.06 0001378125 0001366246 0001085621
5 NetIncome -5.46 -1.93 0.283 1.15 2.00 0001516805 0001046327 0000098338
6 ComprehensiveNetIncome -5.50 -1.94 0.304 1.15 1.96 0001516805 0001046327 0000098338
7 BaseVar nan nan nan nan nan 0000023111 0001378125 0000023111
8 EconomicCapitalRatio -9.46 -7.28 1.25 4.12 5.00 0001516805 0001013237 0001085621

2018

Logs

error 1 × IME and Company effects mismatched for Other Assets. IME Effects: 209.0, Company Effect: 210.0 subcommand.report
0001462223
warning 4 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '60 of 60'}
{'var_name': 'IntangibleAssets', 'zeros': '60 of 60'}
{'var_name': 'LeaseAssets', 'zeros': '60 of 60'}
{'var_name': 'LeaseLiability', 'zeros': '60 of 60'}
warning 2 × Similarly named company. Duplicate? None
0001169445 0001715433
warning 1 × equityII differs from equityI pre-agg
0001013237
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.131127074289552}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.885739973023433}
warning 1 × Missing logo subcommand.report
0001366246
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001567900
warning 1 × Ignoring company because Expenses is zero pre-agg
0001596961

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 113 45,527 79,613,338 7,189,334,200 136,413,000,000 0001653979 0001118417 0001652044
1 AssetsNonCurrent 0 0 1,029,907 614,587,450 16,552,000,000 0000945384 0001725579 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001408278 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001408278 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001408278 0000023111
5 remainder_Assets 0 0 39,195,215 6,965,400,000 79,827,000,000 0001082733 0001408278 0001652044
6 LiabilitiesCurrent 31,984 395,704 42,762,375 2,343,135,000 35,884,000,000 0001653979 0001169445 0001652044
7 LiabilitiesNonCurrent 0 0 37,477 1,511,269,400 18,884,000,000 0000098338 0001737372 0001652044
8 LeaseLiability 0 0 0 0 0 0000023111 0001408278 0000023111
9 remainder_Liabilities -51,922,000 0 0 270,528,750 1,773,165,000 0001666071 0000098338 0001418091
10 CostOfGoodsAndServicesSold 0 0 9,164,148 1,560,485,700 59,549,000,000 0000023111 0001052054 0001652044
11 GeneralAndAdministrativeExpense 0 0 5,053,662 307,728,200 8,126,000,000 0000023111 0001376321 0001652044
12 SellingExpense 0 0 35,591,274 1,284,460,000 16,333,000,000 0001378125 0001095565 0001652044
13 ResearchAndDevelopmentExpense 0 0 127,817 564,774,350 21,419,000,000 0000023111 0001737372 0001652044
14 remainder_Expenses -649,446,000 0 7,889,898 692,930,000 10,996,000,000 0001418091 0001376321 0001058290
15 remainder_Revenues 0 0 152,681,293 4,614,990,000 136,819,000,000 0001082733 0001118417 0001652044
16 remainder_NetIncome -223,100,000 -68,265,250 -322,265 78,261,800 8,592,000,000 0001598014 0001739936 0001652044
17 remainder_ComprehensiveNetIncome -1,216,000,000 -184,095,000 0 202,820 44,855,000 0001652044 0000836690 0001725579
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 113 52,462 160,031,101 15,920,465,000 232,792,000,000 0001653979 0001118417 0001652044
1 Liabilities 31,984 395,704 58,170,073 3,413,579,100 55,164,000,000 0001653979 0000023111 0001652044
2 Expenses 16,168 555,045 183,022,695 3,895,410,400 114,675,000,000 0001653979 0001595974 0001652044
3 Revenues 0 0 152,681,293 4,614,990,000 136,819,000,000 0001082733 0001118417 0001652044
4 StockholdersEquity -1,385,474,000 -10,595,580 47,224,623 11,539,900,000 177,628,000,000 0001014473 0001408278 0001652044
5 NetIncome -1,255,911,000 -129,891,800 -2,611,787 1,250,366,200 30,736,000,000 0001564408 0001448558 0001652044
6 ComprehensiveNetIncome -1,266,921,000 -87,294,850 -2,611,787 1,209,170,800 29,520,000,000 0001564408 0001448558 0001652044
7 BaseVar 26,800 1,326,646 367,615,731 15,104,754,175 317,743,830,000 0001653979 0001118417 0001652044
8 EconomicCapitalRatio -10.9 -6.89 1.50 4.13 4.42 0001627611 0001475115 0001326801

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.70 -2.49 -0.165 1.84 4.40 0001627611 0001598014 0001715433
1 AssetsNonCurrent -0.309 -0.134 -0.0201 0.0639 0.123 0001378125 0001366246 0001597033
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001408278 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001408278 0000023111
4 LeaseAssets 0 0 0 0 0 0000023111 0001408278 0000023111
5 remainder_Assets -4.84 -2.67 -0.276 2.01 2.52 0001627611 0001352010 0001710583
6 LiabilitiesCurrent -1.71 -0.972 1.20 3.48 4.14 0000929940 0001715433 0001568969
7 LiabilitiesNonCurrent -2.86 -1.63 0.202 0.854 1.52 0001014473 0001564408 0000098338
8 LeaseLiability 0 0 0 0 0 0000023111 0001408278 0000023111
9 remainder_Liabilities -4.27 -0.820 0.293 0.787 1.42 0001616156 0001118417 0000098338
10 CostOfGoodsAndServicesSold -6.31 -1.17 0.0878 0.649 1.00 0000098338 0001326801 0001378125
11 GeneralAndAdministrativeExpense -1.27 -1.14 0.103 0.410 1.26 0001546296 0000929940 0000098338
12 SellingExpense -3.35 -0.856 0.0685 0.635 1.07 0001640428 0001737372 0001378125
13 ResearchAndDevelopmentExpense -0.616 -0.384 0.0804 0.331 0.573 0001046327 0001710583 0000098338
14 remainder_Expenses -3.52 -1.10 0.160 0.405 1.21 0000023111 0001628104 0000098338
15 remainder_Revenues -2.14 -0.834 -0.0256 2.34 4.99 0001378125 0001014473 0000098338
16 remainder_NetIncome -9.76 -1.13 0.154 0.480 0.806 0001378125 0001169445 0000098338
17 remainder_ComprehensiveNetIncome -3.27 -0.00819 0.0256 0.0858 0.205 0001627611 0001564408 0001725579
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -8.02 -4.27 0.0742 1.41 2.24 0001627611 0001058290 0001462223
1 Liabilities -2.17 -1.12 1.37 3.20 4.72 0001616156 0001085869 0000098338
2 Expenses -3.14 -2.26 0.0687 0.539 2.98 0000098338 0001526520 0001378125
3 Revenues -2.14 -0.834 -0.0256 2.34 4.99 0001378125 0001014473 0000098338
4 StockholdersEquity -5.56 -5.50 0.883 3.68 3.88 0001653979 0001725579 0001173489
5 NetIncome -8.93 -2.13 0.276 1.16 2.65 0001378125 0001475115 0000098338
6 ComprehensiveNetIncome -8.87 -2.10 0.301 1.20 2.79 0001378125 0001475115 0000098338
7 BaseVar nan nan nan nan nan 0000023111 0001408278 0000023111
8 EconomicCapitalRatio -11.1 -7.02 1.37 4.00 4.28 0001627611 0001475115 0001326801

2019

Logs

error 5 × No matching role found input.sec.calculation_linkbase.expand_agg
0001753931 0001753391 0001746278 0001765048 0001568969
warning 5 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001753931 0001753391 0001746278 0001765048 0001568969
warning 3 × Similarly named company. Duplicate? None
0001575189 0001715433 0001169445
warning 2 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '60 of 60'}
{'var_name': 'IntangibleAssets', 'zeros': '60 of 60'}
warning 2 × Ignoring company because Expenses is zero pre-agg
0001046327 0001596961
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.08441748947295}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -5.288226321739389}
warning 1 × Missing logo subcommand.report
0001366246
warning 1 × Ignoring company because Assets is zero pre-agg
0001658520

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 16,581 76,419 145,606,600 7,706,858,050 153,299,000,000 0001653979 0001752474 0001652044
1 AssetsNonCurrent 0 0 1,468,064 673,399,750 15,420,000,000 0000945384 0001725579 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001448558 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001448558 0000023111
4 LeaseAssets 0 0 1,041,531 708,540,250 10,941,000,000 0000098338 0001052054 0001652044
5 remainder_Assets -6,097,000 0 71,881,998 7,318,515,000 96,249,000,000 0001376321 0001568385 0001652044
6 LiabilitiesCurrent 21,580 294,063 55,914,716 2,019,890,000 46,922,000,000 0001686515 0000023111 0001652044
7 LiabilitiesNonCurrent 0 0 507,272 1,445,147,150 16,973,000,000 0000098338 0000023111 0001652044
8 LeaseLiability 0 0 100,486 616,227,500 10,214,000,000 0000098338 0001462223 0001652044
9 remainder_Liabilities -78,401,000 -512,160 0 253,064,900 2,532,970,000 0001666071 0001082733 0001418091
10 CostOfGoodsAndServicesSold 0 0 13,038,702 1,725,900,150 71,896,000,000 0000023111 0001640428 0001652044
11 GeneralAndAdministrativeExpense 0 0 5,579,360 596,318,650 10,465,000,000 0000023111 0001376321 0001326801
12 SellingExpense 0 0 45,613,225 1,696,741,850 18,464,000,000 0001378125 0001014473 0001652044
13 ResearchAndDevelopmentExpense 0 0 633,676 899,686,500 26,018,000,000 0000023111 0001378125 0001652044
14 remainder_Expenses -937,340,000 -586,700 5,872,207 1,075,210,000 12,001,000,000 0001418091 0001671933 0001058290
15 remainder_Revenues 0 0 251,492,776 5,358,352,250 161,857,000,000 0001082733 0001095565 0001652044
16 remainder_NetIncome -261,500,000 -44,107,900 24,492 98,399,550 5,394,000,000 0001598014 0001715433 0001652044
17 remainder_ComprehensiveNetIncome -23,821,000 -5,988,650 0 52,427,650 1,104,000,000 0001013237 0000746210 0001652044
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 16,581 270,666 321,194,151 16,093,040,000 275,909,000,000 0001653979 0001169445 0001652044
1 Liabilities 21,580 1,244,381 103,470,967 4,058,152,850 74,467,000,000 0001686515 0001095565 0001652044
2 Expenses 40,154 926,010 248,261,909 4,814,627,200 132,908,000,000 0001653979 0001169445 0001652044
3 Revenues 0 0 251,492,776 5,358,352,250 161,857,000,000 0001082733 0001095565 0001652044
4 StockholdersEquity -1,490,100,000 -11,408,872 127,786,353 11,176,800,000 201,442,000,000 0001014473 0001666071 0001652044
5 NetIncome -1,361,371,000 -139,439,500 -1,682,587 1,484,476,050 34,343,000,000 0001506293 0000945384 0001652044
6 ComprehensiveNetIncome -1,359,303,000 -113,667,200 -1,682,587 1,483,314,200 35,447,000,000 0001506293 0000945384 0001652044
7 BaseVar 46,971 1,761,438 582,262,660 15,458,918,200 375,527,895,000 0001653979 0001169445 0001652044
8 EconomicCapitalRatio -6.49 -5.29 1.68 4.08 4.65 0001082733 0001366246 0000836690

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.26 -2.20 -0.152 1.48 2.68 0001567900 0001598014 0001686515
1 AssetsNonCurrent -0.115 -0.0959 -0.0159 0.0550 0.150 0001567900 0001713683 0001597033
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001448558 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001448558 0000023111
4 LeaseAssets -0.373 -0.264 -0.0198 0.160 1.83 0001567900 0001598014 0001376321
5 remainder_Assets -2.80 -2.07 -0.218 1.67 2.73 0001082733 0001118417 0001568385
6 LiabilitiesCurrent -2.45 -0.932 0.553 2.18 3.30 0001514056 0001598014 0001082733
7 LiabilitiesNonCurrent -2.83 -1.58 0.272 0.919 1.66 0001752474 0001475115 0000098338
8 LeaseLiability -0.860 -0.309 0.0453 0.238 0.622 0001056386 0001725579 0000098338
9 remainder_Liabilities -4.12 -1.03 0.359 0.976 1.85 0001730732 0001636422 0001666071
10 CostOfGoodsAndServicesSold -6.19 -0.980 0.0502 0.474 0.822 0000098338 0001418091 0000023111
11 GeneralAndAdministrativeExpense -3.36 -1.12 0.117 0.408 1.40 0001686515 0001408278 0000098338
12 SellingExpense -3.35 -0.420 0.0373 0.352 0.845 0001640428 0001418091 0001376321
13 ResearchAndDevelopmentExpense -0.995 -0.314 0.0757 0.312 0.622 0001506293 0001730732 0000098338
14 remainder_Expenses -2.81 -0.857 0.173 0.367 1.28 0000023111 0001671933 0000098338
15 remainder_Revenues -1.16 -0.803 -0.0502 1.90 4.68 0001082733 0001014473 0000098338
16 remainder_NetIncome -1.75 -0.129 0.0323 0.129 0.928 0001627611 0001352010 0001082733
17 remainder_ComprehensiveNetIncome -0.0463 -0.0179 -0.00168 0.0147 0.0734 0000023111 0001475115 0001725579
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -4.90 -3.65 0.0332 1.05 1.57 0001082733 0001378125 0001568385
1 Liabilities -2.60 -2.20 0.872 2.48 4.17 0001616156 0001526520 0000098338
2 Expenses -3.30 -1.62 0.0748 0.492 0.598 0000098338 0001526520 0001627611
3 Revenues -1.16 -0.803 -0.0502 1.90 4.68 0001082733 0001014473 0000098338
4 StockholdersEquity -6.47 -5.43 0.371 2.84 3.40 0001082733 0001662574 0000836690
5 NetIncome -3.01 -1.95 0.209 0.913 1.51 0001686515 0001118417 0000098338
6 ComprehensiveNetIncome -2.97 -1.95 0.207 0.908 1.50 0001686515 0001118417 0000098338
7 BaseVar nan nan nan nan nan 0000023111 0001448558 0000023111
8 EconomicCapitalRatio -7.40 -6.20 0.768 3.17 3.74 0001082733 0001366246 0000836690

2020

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001765048
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001516805 0001765048 0001753391
warning 2 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '62 of 62'}
{'var_name': 'IntangibleAssets', 'zeros': '62 of 62'}
warning 2 × Similarly named company. Duplicate? None
0001715433 0001169445
warning 2 × Missing logo subcommand.report
0001366246 0001753931
warning 2 × Ignoring company because Assets is zero pre-agg
0001593773 0001658520
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.0476804240188295}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.241991355820466}
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001516805
warning 1 × Ignoring company because Expenses is zero pre-agg
0001596961

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 3,906 206,504 160,942,922 7,137,162,500 175,380,000,000 0001811999 0001173489 0001652044
1 AssetsNonCurrent 0 0 2,747,982 613,022,600 24,656,000,000 0001023364 0001169445 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001514056 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001514056 0000023111
4 LeaseAssets 0 0 3,240,135 898,472,050 12,211,000,000 0000836690 0001118417 0001652044
5 remainder_Assets -1,894,884 63.6 108,507,450 7,644,200,000 107,369,000,000 0001516805 0001173489 0001652044
6 LiabilitiesCurrent 0 1,048,952 70,580,017 1,977,501,300 60,395,000,000 0001753931 0001118417 0001652044
7 LiabilitiesNonCurrent 0 0 919,095 2,146,976,400 25,050,000,000 0000098338 0001715433 0001652044
8 LeaseLiability 0 0 1,036,100 802,575,600 11,146,000,000 0000836690 0001408278 0001652044
9 remainder_Liabilities -5,772,000 -118,958 0 474,962,150 2,600,335,000 0001173489 0001169445 0001418091
10 CostOfGoodsAndServicesSold 0 0 16,125,806 1,716,065,000 84,732,000,000 0000023111 0001640428 0001652044
11 GeneralAndAdministrativeExpense 0 0 6,578,519 560,768,600 11,052,000,000 0000023111 0000746210 0001652044
12 SellingExpense 0 0 42,181,601 1,262,589,350 17,946,000,000 0001448558 0001666071 0001652044
13 ResearchAndDevelopmentExpense 0 0 0 859,670,150 27,573,000,000 0000023111 0000098338 0001652044
14 remainder_Expenses -98,414,000 -293,438 8,760,106 1,231,527,250 12,142,000,000 0001671933 0001408278 0001058290
15 remainder_Revenues 0 4,291 233,368,508 4,259,227,450 182,527,000,000 0001082733 0001095565 0001652044
16 remainder_NetIncome -350,209,000 -257,035,400 59,785 93,877,250 6,858,000,000 0000891103 0001752474 0001652044
17 remainder_ComprehensiveNetIncome -30,600,000 -1,474,400 0 142,438,050 1,865,000,000 0001810019 0001023364 0001652044
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,178 329,148 440,515,696 15,997,394,500 319,616,000,000 0001811999 0001327318 0001652044
1 Liabilities 211,549 1,896,205 125,703,027 5,388,262,600 97,072,000,000 0001686515 0001169445 0001652044
2 Expenses 132,737 454,126 262,437,856 4,859,752,050 149,116,000,000 0001686515 0001595974 0001652044
3 Revenues 0 4,291 233,368,508 4,259,227,450 182,527,000,000 0001082733 0001095565 0001652044
4 StockholdersEquity -1,390,198,000 -7,696,387 178,857,129 10,713,430,600 222,544,000,000 0001014473 0001169445 0001652044
5 NetIncome -1,271,544,000 -286,840,000 -2,362,680 866,674,400 40,269,000,000 0001597033 0001448558 0001652044
6 ComprehensiveNetIncome -1,259,395,000 -275,580,000 -2,168,731 1,013,917,650 42,134,000,000 0001597033 0001173489 0001652044
7 BaseVar 298,716 2,377,677 629,588,251 15,149,542,650 434,687,390,000 0001686515 0001666071 0001652044
8 EconomicCapitalRatio -7.50 -4.24 1.24 4.05 4.59 0001811999 0001636422 0001774155

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.26 -2.11 -0.178 1.66 17.7 0001811999 0001598014 0001516805
1 AssetsNonCurrent -0.140 -0.109 -0.0153 0.0612 0.136 0001567900 0001169445 0001597033
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001514056 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001514056 0000023111
4 LeaseAssets -0.314 -0.230 -0.00529 0.115 0.193 0001567900 0001023364 0001013237
5 remainder_Assets -4.36 -2.25 -0.149 1.55 2.38 0001516805 0001327318 0001774155
6 LiabilitiesCurrent -2.73 -1.44 0.583 2.07 6.80 0001516805 0001598014 0001811999
7 LiabilitiesNonCurrent -2.85 -1.80 0.267 0.911 1.11 0001752474 0001713683 0001640428
8 LeaseLiability -0.465 -0.287 0.0199 0.177 0.293 0001013237 0001666071 0001376321
9 remainder_Liabilities -4.21 -1.58 0.445 1.000 1.49 0001753931 0001526520 0001640428
10 CostOfGoodsAndServicesSold -3.34 -0.924 0.0757 0.363 0.622 0000098338 0001753931 0000023111
11 GeneralAndAdministrativeExpense -2.81 -0.940 0.0716 0.339 0.675 0001715433 0000891103 0000098338
12 SellingExpense -3.34 -0.489 0.0240 0.306 0.538 0001640428 0001529113 0001376321
13 ResearchAndDevelopmentExpense -0.429 -0.252 0.0573 0.177 0.260 0001506293 0001752474 0000098338
14 remainder_Expenses -2.32 -1.06 0.131 0.300 0.755 0000023111 0001595974 0000098338
15 remainder_Revenues -1.09 -0.667 0.00794 1.50 2.42 0001715433 0001564408 0000098338
16 remainder_NetIncome -1.53 -0.212 0.0372 0.253 0.833 0001627611 0001739936 0001567900
17 remainder_ComprehensiveNetIncome -0.0486 -0.0207 -0.00437 0.0224 0.113 0001376321 0001475115 0001686515
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -5.05 -3.59 0.134 0.968 1.05 0001811999 0001506293 0001753931
1 Liabilities -2.76 -1.68 0.633 2.65 3.29 0001616156 0001448558 0001640428
2 Expenses -1.93 -1.78 0.0636 0.496 0.766 0001640428 0001739936 0001627611
3 Revenues -1.09 -0.667 0.00794 1.50 2.42 0001715433 0001564408 0000098338
4 StockholdersEquity -6.17 -4.97 0.354 3.22 4.13 0001811999 0001739936 0001774155
5 NetIncome -2.80 -1.50 0.131 0.668 1.17 0001715433 0001376321 0001085869
6 ComprehensiveNetIncome -2.81 -1.49 0.110 0.674 1.18 0001715433 0001752474 0001085869
7 BaseVar nan nan nan nan nan 0000023111 0001514056 0000023111
8 EconomicCapitalRatio -8.30 -5.05 0.440 3.24 3.78 0001811999 0001636422 0001774155

2021

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0001842718
warning 2 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '77 of 77'}
{'var_name': 'IntangibleAssets', 'zeros': '77 of 77'}
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001753391 0001765048
warning 2 × Ignoring company because Assets is zero pre-agg
0001593773 0001658520
warning 1 × Too many companies have an ECR > 400% check_abs_values
{'quantile_005_val': 4.65854476418494}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.266160962440816}
warning 1 × Similarly named company. Duplicate? None
0001169445
warning 1 × Missing logo subcommand.report
0001753931
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001820144
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001874097
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001874097

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 122,761 270,041,292 5,432,401,600 189,427,000,000 0001746278 0001327318 0001652044
1 AssetsNonCurrent 0 0 4,318,360 520,539,200 34,910,000,000 0001052054 0001327318 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001598014 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001598014 0000023111
4 LeaseAssets 0 0 901,960 574,360,000 12,959,000,000 0000836690 0000098338 0001652044
5 remainder_Assets 0 349 137,537,233 8,245,845,600 121,972,000,000 0001082733 0001774155 0001652044
6 LiabilitiesCurrent 0 253,343 93,051,851 1,985,104,000 69,511,000,000 0001746278 0001636422 0001652044
7 LiabilitiesNonCurrent 0 0 2,049,851 2,250,002,200 26,198,000,000 0000098338 0001799332 0001652044
8 LeaseLiability 0 0 130,957 543,000,000 12,746,000,000 0000836690 0001616156 0001326801
9 remainder_Liabilities -125,142,000 -178,393 0 544,585,800 4,293,710,000 0001596961 0001169445 0001418091
10 CostOfGoodsAndServicesSold 0 0 54,405,699 2,154,899,400 110,939,000,000 0000023111 0001819928 0001652044
11 GeneralAndAdministrativeExpense 0 0 14,319,010 609,596,800 13,510,000,000 0000023111 0001173489 0001652044
12 SellingExpense 0 0 58,212,303 1,217,260,000 22,912,000,000 0001052054 0001422930 0001652044
13 ResearchAndDevelopmentExpense 0 0 603,945 873,552,000 31,562,000,000 0000023111 0001715433 0001652044
14 remainder_Expenses -223,098,000 -13,446,000 8,768,463 967,324,200 14,701,000,000 0001830043 0001837686 0001652044
15 remainder_Revenues 0 0 256,791,070 5,346,185,600 257,637,000,000 0001052054 0001095565 0001652044
16 remainder_NetIncome -464,529,000 -87,220,000 -99,949 155,324,400 12,020,000,000 0000891103 0001794905 0001652044
17 remainder_ComprehensiveNetIncome -2,256,000,000 -33,201,200 0 15,275,000 53,508,000 0001652044 0001737372 0001597033
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 350 342,870 486,811,748 14,630,392,800 359,268,000,000 0001746278 0001095565 0001652044
1 Liabilities 42,993 626,103 161,035,034 5,173,240,000 107,633,000,000 0001746278 0001774155 0001652044
2 Expenses 27,800 716,543 298,911,989 5,728,142,400 193,624,000,000 0001746278 0001131554 0001652044
3 Revenues 0 0 256,791,070 5,346,185,600 257,637,000,000 0001052054 0001095565 0001652044
4 StockholdersEquity -1,260,519,000 -7,270,530 256,778,078 11,135,072,000 251,635,000,000 0001014473 0001454938 0001652044
5 NetIncome -926,307,000 -258,725,800 -2,707,381 869,064,000 76,033,000,000 0001597033 0001753931 0001652044
6 ComprehensiveNetIncome -872,799,000 -265,567,000 -1,853,696 865,240,800 73,777,000,000 0001597033 0001753931 0001652044
7 BaseVar 40,158 1,450,111 754,713,370 15,678,596,359 543,032,605,000 0001746278 0001131554 0001652044
8 EconomicCapitalRatio -7.35 -4.27 1.76 4.66 6.45 0001082733 0001418091 0001052054

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.71 -2.46 -0.108 1.61 3.41 0001082733 0001597033 0001874097
1 AssetsNonCurrent -0.180 -0.117 -0.00968 0.0666 0.132 0001082733 0001506293 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001598014 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001598014 0000023111
4 LeaseAssets -0.321 -0.186 -0.00925 0.156 0.504 0001082733 0001820144 0001563190
5 remainder_Assets -4.09 -2.63 -0.227 1.67 2.35 0001082733 0001837686 0001820144
6 LiabilitiesCurrent -4.00 -1.10 0.486 1.78 8.27 0001686515 0001866550 0001811999
7 LiabilitiesNonCurrent -3.21 -1.79 0.393 1.09 1.38 0001582961 0001820144 0001563190
8 LeaseLiability -0.852 -0.375 0.0444 0.154 0.261 0001563190 0001662574 0001753931
9 remainder_Liabilities -2.85 -1.07 0.442 1.18 17.3 0001616156 0001422930 0001746278
10 CostOfGoodsAndServicesSold -4.13 -1.06 0.0773 0.432 0.839 0001563190 0001475115 0001686515
11 GeneralAndAdministrativeExpense -3.11 -0.600 0.0537 0.314 0.582 0001715433 0001666071 0000098338
12 SellingExpense -3.88 -0.503 0.0475 0.315 0.885 0001640428 0001830043 0001563190
13 ResearchAndDevelopmentExpense -0.943 -0.308 0.0529 0.178 0.321 0001854445 0001800392 0001686515
14 remainder_Expenses -2.36 -0.759 0.131 0.448 0.765 0000023111 0001475115 0001640428
15 remainder_Revenues -2.46 -0.865 0.0169 1.89 3.25 0001686515 0001598014 0001563190
16 remainder_NetIncome -1.55 -0.275 -0.0186 0.206 7.52 0001737372 0001595974 0001686515
17 remainder_ComprehensiveNetIncome -0.628 -0.0224 -0.00391 0.0135 0.662 0001686515 0001737372 0001052054
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -6.08 -3.35 -0.0403 0.871 1.06 0001082733 0001739936 0001830043
1 Liabilities -2.73 -1.43 0.699 3.07 3.50 0001616156 0001837686 0001753931
2 Expenses -2.82 -1.82 0.0295 0.490 0.976 0001563190 0001392972 0001686515
3 Revenues -2.46 -0.865 0.0169 1.89 3.25 0001686515 0001598014 0001563190
4 StockholdersEquity -9.86 -5.97 -0.0385 2.98 3.91 0001686515 0001595974 0001841209
5 NetIncome -3.77 -1.76 0.136 0.768 6.03 0001715433 0001582961 0001686515
6 ComprehensiveNetIncome -3.83 -1.76 0.132 0.777 5.40 0001715433 0001131554 0001686515
7 BaseVar nan nan nan nan nan 0000023111 0001598014 0000023111
8 EconomicCapitalRatio -8.74 -5.65 0.375 3.27 5.07 0001082733 0001418091 0001052054

2022

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001781629
error 1 × Negative Expenses, ignoring company. pre-agg
0001568969
warning 4 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001781629 0001842563 0001758699 0001753391
warning 2 × Zero effects check_effects
{'var_name': 'PropertyPlantAndEquipment', 'zeros': '70 of 70'}
{'var_name': 'IntangibleAssets', 'zeros': '70 of 70'}
warning 2 × Ignoring company because Assets is zero pre-agg
0001593773 0001658520
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -7.756148731279094}
warning 1 × Similarly named company. Duplicate? None
0001169445
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001568385

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 88,308 224,298,728 4,663,996,100 170,056,000,000 0001686515 0001666071 0001652044
1 AssetsNonCurrent 0 0 3,814,432 505,425,550 37,115,000,000 0001082733 0001327318 0001652044
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001582961 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001582961 0000023111
4 LeaseAssets 0 0 8,943,740 432,688,400 14,381,000,000 0000836690 0001173489 0001652044
5 remainder_Assets -5,575 0 166,574,040 5,772,429,300 143,712,000,000 0001800392 0001671933 0001652044
6 LiabilitiesCurrent 0 852,304 82,159,899 1,663,147,200 69,814,000,000 0001686515 0001636422 0001652044
7 LiabilitiesNonCurrent 0 0 4,252,691 2,851,020,000 26,206,000,000 0000098338 0001327318 0001652044
8 LeaseLiability 0 0 3,580,583 611,625,000 15,301,000,000 0000836690 0001820144 0001326801
9 remainder_Liabilities -126,695,000 -9,350 0 372,028,300 1,066,048,000 0001596961 0001326801 0001713683
10 CostOfGoodsAndServicesSold 0 0 53,956,287 2,827,105,650 126,203,000,000 0000023111 0001800392 0001652044
11 GeneralAndAdministrativeExpense 0 0 12,695,047 760,620,900 15,724,000,000 0000023111 0001173489 0001652044
12 SellingExpense 0 0 69,672,642 1,562,598,200 26,567,000,000 0001514056 0001131554 0001652044
13 ResearchAndDevelopmentExpense 0 0 7,842,790 684,074,000 39,500,000,000 0000023111 0001874097 0001652044
14 remainder_Expenses -4,135,000 -550 19,665,483 1,105,223,350 13,747,000,000 0001640428 0001746278 0001058290
15 remainder_Revenues 0 712 271,545,746 5,665,776,000 282,836,000,000 0001082733 0001392972 0001652044
16 remainder_NetIncome -3,514,000,000 -145,928,600 0 15,009,600 52,000,000 0001652044 0001686515 0001058290
17 remainder_ComprehensiveNetIncome -5,980,000,000 -56,682,850 0 4,946,400 64,500,000 0001652044 0001686515 0001810019
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 1,544 185,436 475,655,544 9,329,791,350 365,264,000,000 0001686515 0001095565 0001652044
1 Liabilities 66,066 1,664,580 241,152,094 5,169,102,000 109,120,000,000 0001815632 0001131554 0001652044
2 Expenses 37,488 1,606,228 328,652,014 6,356,960,600 219,350,000,000 0001686515 0001799332 0001652044
3 Revenues 0 712 271,545,746 5,665,776,000 282,836,000,000 0001082733 0001392972 0001652044
4 StockholdersEquity -1,562,200,000 -7,771,238 161,066,797 6,988,792,650 256,144,000,000 0001014473 0001475115 0001652044
5 NetIncome -1,429,653,000 -540,193,800 -14,165,966 559,327,200 59,972,000,000 0001564408 0001715433 0001652044
6 ComprehensiveNetIncome -1,449,148,000 -537,893,400 -16,471,303 540,880,900 53,992,000,000 0001564408 0001662574 0001652044
7 BaseVar 70,896 3,562,034 759,992,818 13,687,726,709 577,459,200,000 0001686515 0001846069 0001652044
8 EconomicCapitalRatio -18.7 -7.76 1.06 3.87 4.45 0001514056 0001131554 0000836690

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 -12.0 -3.20 -0.128 1.43 3.97 0001514056 0001841209 0001874097
1 AssetsNonCurrent -0.963 -0.275 -0.0191 0.0775 0.527 0001514056 0001095565 0001546296
2 PropertyPlantAndEquipment 0 0 0 0 0 0000023111 0001582961 0000023111
3 IntangibleAssets 0 0 0 0 0 0000023111 0001582961 0000023111
4 LeaseAssets -1.56 -0.349 -0.0158 0.158 0.660 0001514056 0001085869 0001563190
5 remainder_Assets -11.2 -3.26 -0.232 1.72 3.49 0001514056 0001118417 0001746278
6 LiabilitiesCurrent -1.86 -0.851 0.346 2.04 10.00 0001815632 0001564408 0001082733
7 LiabilitiesNonCurrent -3.61 -2.29 0.425 1.36 2.24 0001514056 0001652044 0000098338
8 LeaseLiability -1.51 -0.432 0.0123 0.261 0.509 0001794905 0001173489 0000098338
9 remainder_Liabilities -3.19 -1.15 0.461 1.26 11.1 0001514056 0001529113 0001686515
10 CostOfGoodsAndServicesSold -4.84 -1.48 0.0925 0.883 1.36 0000098338 0001837686 0001815632
11 GeneralAndAdministrativeExpense -4.70 -1.13 0.0684 0.492 1.01 0001815632 0001666071 0000098338
12 SellingExpense -3.67 -0.437 0.0548 0.563 1.06 0001640428 0000891103 0001514056
13 ResearchAndDevelopmentExpense -2.08 -0.365 0.0636 0.330 0.654 0001841209 0001640428 0000098338
14 remainder_Expenses -6.06 -3.02 0.231 0.527 1.47 0001815632 0001013237 0000098338
15 remainder_Revenues -3.51 -1.25 0.0586 1.42 3.71 0001815632 0001014473 0000098338
16 remainder_NetIncome -11.6 -0.156 0.0524 0.259 0.737 0001514056 0001326801 0000098338
17 remainder_ComprehensiveNetIncome -0.197 -0.0374 0.00246 0.0276 0.399 0001799332 0001422930 0001715433
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -15.9 -5.79 0.167 1.21 1.86 0001514056 0001327318 0001874097
1 Liabilities -3.74 -1.64 0.645 2.74 4.27 0001514056 0001799332 0000098338
2 Expenses -8.50 -2.41 0.183 0.502 3.12 0001815632 0001617553 0001514056
3 Revenues -3.51 -1.25 0.0586 1.42 3.71 0001815632 0001014473 0000098338
4 StockholdersEquity -8.41 -5.63 0.204 2.83 3.67 0001514056 0001131554 0001874097
5 NetIncome -12.1 -4.94 0.317 1.12 2.70 0001815632 0001739936 0000098338
6 ComprehensiveNetIncome -12.1 -4.93 0.313 1.13 2.71 0001815632 0001739936 0000098338
7 BaseVar nan nan nan nan nan 0000023111 0001582961 0000023111
8 EconomicCapitalRatio -18.9 -8.01 0.807 3.62 4.20 0001514056 0001131554 0000836690

Estimates

Parameter Value Min Max
PresentValueFactor 1.33 1.0 15.0
BalanceFactor 2.56 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 1.86 0.2 10.0