QA: us_consulting 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
0001304161 Pharma-Bio Serv Inc. Pharma- 1 1 NaN NaN 1 4 1 176.74800 176.08300 NaN NaN 142.10200 125.36300 152.0930 0 NaN NaN NaN 3 -3
0001437226 Mastech Digital Inc. Mastech 8 12 14 6 4 5 2 76.57830 36.11030 57.2997 89.5937 101.52300 120.00700 151.4740 4 2 -8 -2 1 -3
0001644378 RMR GROUP INC. RMR GRO 2 2 2 2 NaN 2 3 140.38200 147.44700 195.4480 158.8280 NaN 139.81300 132.3190 0 0 0 NaN NaN 1
0000851520 EXPONENT INC EXPONEN 3 4 5 NaN NaN 6 4 126.79700 119.21100 130.5570 NaN NaN 115.19400 104.1390 1 1 NaN NaN NaN -2
0001083446 Apollo Medical Holdings Inc. Apollo 13 3 3 8 5 7 5 6.38607 125.80000 159.9760 73.6993 100.62500 101.18600 96.9800 -10 0 5 -3 2 -2
0001013706 Wilhelmina International Inc. Wilhelm 10 8 8 9 10 8 6 73.27460 94.31530 95.0470 68.7897 57.16070 99.92720 96.7453 -2 0 1 1 -2 -2
0001643615 Montrose Environmental Group Inc. Montros NaN NaN NaN NaN 13 13 7 NaN NaN NaN NaN 55.17720 79.70340 83.5449 NaN NaN NaN NaN 0 -6
0000887936 FTI CONSULTING INC FTI CON NaN NaN NaN NaN NaN 11 8 NaN NaN NaN NaN NaN 82.56860 82.7759 NaN NaN NaN NaN NaN -3
0001777319 CISO Global Inc. CISO Gl NaN NaN NaN 5 12 26 9 NaN NaN NaN 112.3080 55.49260 -52.13730 74.0609 NaN NaN NaN 7 14 -17
0001289848 Huron Consulting Group Inc. Huron C NaN NaN NaN NaN 7 12 10 NaN NaN NaN NaN 72.27890 81.43750 72.3185 NaN NaN NaN NaN 5 -2
0001847590 Bowman Consulting Group Ltd. Bowman NaN NaN NaN NaN NaN 10 11 NaN NaN NaN NaN NaN 85.08280 70.5212 NaN NaN NaN NaN NaN 1
0001371489 Information Services Group Inc. Informa 12 13 15 12 9 16 12 26.58070 35.22880 50.3177 57.1012 58.59320 63.18870 64.5447 1 2 -3 -3 7 -4
0001057379 HACKETT GROUP INC. HACKETT 6 6 6 4 NaN 1 13 94.92990 110.32300 128.8410 137.1730 NaN 143.46700 63.3615 0 0 -2 NaN NaN 12
0001362004 ICF International Inc. ICF Int 7 9 10 7 8 15 14 80.99730 90.57500 86.1608 80.1886 65.87100 64.50590 58.8407 2 1 -3 1 7 -1
0001398659 Genpact LTD Genpact 9 10 13 11 11 17 15 73.61070 65.42980 57.6510 57.8402 57.05990 59.36290 57.9101 1 3 -2 0 6 -2
0001508348 AmeriCann Inc. AmeriCa 17 15 16 NaN 15 20 16 -38.34660 -6.65852 47.5926 NaN 46.73310 40.88910 48.1397 -2 1 NaN NaN 5 -4
0001622879 Medicine Man Technologies Inc. Medicin 22 7 1 10 14 14 17 -203.68000 106.02000 198.4350 60.5366 50.77270 72.13820 44.8380 -15 -6 9 4 0 3
0001790625 AgileThought Inc. AgileTh NaN NaN NaN NaN NaN 19 18 NaN NaN NaN NaN NaN 46.45340 37.0025 NaN NaN NaN NaN NaN -1
0001320760 TSS Inc. TSS Inc 15 NaN 12 13 17 22 19 -27.48930 NaN 64.7013 19.8099 15.68570 5.83190 10.2421 NaN NaN 1 4 5 -3
0001599407 1847 Holdings LLC 1847 Ho 23 16 19 15 21 24 20 -294.23500 -14.24780 -52.5182 -36.0793 -87.72850 -3.97367 -17.5064 -7 3 -4 6 3 -4
0001657045 NEXT-ChemX Corporation. NEXT-Ch NaN NaN 21 16 2 23 21 NaN NaN -83.2380 -51.8102 141.95900 2.06192 -33.6773 NaN NaN -5 -14 21 -2
0001602813 FRONTERA GROUP INC. FRONTER 26 24 30 NaN NaN NaN 22 -419.02600 -259.83600 -363.7600 NaN NaN NaN -43.2036 -2 6 NaN NaN NaN NaN
0001419275 RYVYL Inc. RYVYL I 20 NaN NaN 17 20 21 23 -139.30400 NaN NaN -69.2463 -38.07070 20.23040 -52.0117 NaN NaN NaN 3 1 2
0001502966 Digipath Inc. Digipat NaN 11 20 18 23 27 24 NaN 50.78330 -63.6895 -118.0800 -148.94900 -75.10630 -182.1570 NaN 9 -2 5 4 -3
0001632121 Balance Labs Inc. Balance NaN 28 25 22 22 28 25 NaN -371.40500 -211.4070 -236.3750 -94.29620 -163.77100 -208.0250 NaN -3 -3 0 6 -3
0001439264 Bonanza Goldfields Corp. Bonanza NaN NaN NaN NaN NaN 29 26 NaN NaN NaN NaN NaN -326.21500 -209.3250 NaN NaN NaN NaN NaN -3
0001620749 Panamera Holdings Corp Panamer 19 22 27 26 27 NaN 27 -96.93570 -209.51300 -276.8040 -277.2570 -255.96800 NaN -233.6260 3 5 -1 1 NaN NaN
0001813603 Hestia Insight Inc. Hestia NaN NaN NaN NaN NaN 30 28 NaN NaN NaN NaN NaN -613.19600 -264.5880 NaN NaN NaN NaN NaN -2
0001230524 Cyber Apps World Cyber A NaN NaN NaN 3 6 18 29 NaN NaN NaN 157.5600 84.18150 53.64080 -402.6850 NaN NaN NaN 3 12 11
0001654672 PINEAPPLE INC. PINEAPP NaN NaN NaN NaN 3 9 30 NaN NaN NaN NaN 114.23600 91.00060 -1352.4300 NaN NaN NaN NaN 6 21
0001019737 NAVIGANT CONSULTING INC NAVIGAN 5 5 4 NaN NaN NaN NaN 98.75050 110.83800 159.5880 NaN NaN NaN NaN 0 -1 NaN NaN NaN NaN
0001084554 LIGHTBRIDGE Corp LIGHTBR 14 17 9 NaN 16 3 NaN -9.90547 -22.34050 89.5049 NaN 30.29610 137.65600 NaN 3 -8 NaN NaN -13 NaN
0001094814 Cartesian Inc. Cartesi 18 19 NaN NaN NaN NaN NaN -45.30580 -28.87230 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001533106 ARGENTUM 47 INC. ARGENTU 11 27 23 20 NaN NaN NaN 59.35400 -317.52300 -157.2950 -188.5970 NaN NaN NaN 16 -4 -3 NaN NaN NaN
0001567503 TurnKey Capital Inc. TurnKey 25 25 29 25 NaN NaN NaN -412.81300 -286.25000 -295.8010 -269.5440 NaN NaN NaN 0 4 -4 NaN NaN NaN
0001592782 Nukkleus Inc. Nukkleu 16 20 22 24 NaN NaN NaN -35.80610 -36.18500 -138.7430 -248.7940 NaN NaN NaN 4 2 2 NaN NaN NaN
0001600347 Hapi Metaverse Inc. Hapi Me 24 23 NaN NaN NaN NaN NaN -312.27200 -226.34400 NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN NaN
0001604738 Ashford Inc. Ashford 4 14 7 NaN NaN NaN NaN 113.88900 20.77560 122.6160 NaN NaN NaN NaN 10 -7 NaN NaN NaN NaN
0001607450 ABV CONSULTING INC. ABV CON 27 29 26 23 26 NaN NaN -740.23200 -389.05900 -230.7560 -245.6410 -230.88100 NaN NaN 2 -3 -3 3 NaN NaN
0001629606 Driven Deliveries Inc. Driven 21 26 31 19 NaN NaN NaN -166.20300 -291.83400 -1428.6500 -176.2890 NaN NaN NaN 5 5 -12 NaN NaN NaN
0001100778 Rokk3r Inc. Rokk3r NaN 31 17 NaN NaN NaN NaN NaN -4600.56000 37.7076 NaN NaN NaN NaN NaN -14 NaN NaN NaN NaN
0001574910 RENAVOTIO INC. RENAVOT NaN 18 11 NaN 19 NaN NaN NaN -28.20610 70.9839 NaN -23.47000 NaN NaN NaN -7 NaN NaN NaN NaN
0001653099 VIGILANT DIVERSIFIED HOLDINGS INC. NV VIGILAN NaN 30 28 27 NaN NaN NaN NaN -571.38000 -290.2490 -286.9860 NaN NaN NaN NaN -2 -1 NaN NaN NaN
0001661600 SATIVUS TECH CORP. SATIVUS NaN 21 24 NaN NaN NaN NaN NaN -182.78400 -181.7340 NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN
0001693687 MS YOUNG ADVENTURE ENTERPRISE INC. MS YOUN NaN NaN 18 14 25 NaN NaN NaN NaN -43.3451 -15.7408 -178.21300 NaN NaN NaN NaN -4 11 NaN NaN
0001498291 Daniels Corporate Advisory Company Inc. Daniels NaN NaN NaN 21 24 NaN NaN NaN NaN NaN -201.8690 -157.49500 NaN NaN NaN NaN NaN 3 NaN NaN
0001751143 ATLAS TECHNICAL CONSULTANTS INC. ATLAS T NaN NaN NaN 1 18 25 NaN NaN NaN NaN 192.8520 -2.50299 -38.64880 NaN NaN NaN NaN 17 7 NaN

PDF reports

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

2016

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
0001630212 0001657045
error 1 × Median ECR is negative check_abs_values
{'median': -0.09905474726487339}
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '27 of 27'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '27 of 27'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '27 of 27'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.171623421607861}
warning 1 × Similarly named company. Duplicate? None
0001607450
warning 1 × Ignoring company because Assets is zero pre-agg
0001409253

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 369 1,362 5,412,235 299,604,900 1,227,037,000 0001599407 0001320760 0001398659
1 IntangibleAssets 0 0 9.64 706,994,600 1,141,457,000 0001084554 0001620749 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001437226 0000851520
3 AssetsNoncurrent 0 0 558,042 160,005,600 442,443,000 0001084554 0001437226 0001398659
4 remainder_Assets -3,708 0 601 68,532,000 83,319,000 0001622879 0001599407 0000851520
5 LiabilitiesCurrent 10,298 29,383 2,172,248 190,196,200 731,355,000 0001602813 0001304161 0001398659
6 LiabilitiesNoncurrent 0 0 161 261,296,900 860,942,000 0001057379 0001057379 0001398659
7 remainder_Liabilities 0 0 26,006 43,464,600 62,807,000 0001013706 0001437226 0001644378
8 CostOfRevenue 0 0 0 566,946,400 745,137,000 0000851520 0001398659 0001362004
9 GeneralAndAdministrativeExpense 0 0 629,543 136,892,100 328,048,000 0001304161 0001600347 0001362004
10 LaborExpense 0 0 0 41,173,100 193,397,000 0001019737 0001398659 0000851520
11 remainder_Expenses 26,348 40,937 1,501,180 77,121,900 119,684,000 0001602813 0001437226 0001644378
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001437226 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001437226 0000851520
14 remainder_Revenues 0 0 1,511,709 818,658,800 1,185,097,000 0001304161 0001533106 0001362004
15 remainder_NetIncome -9,166,000 -4,051,203 0 5,620,700 329,645,000 0001604738 0001602813 0001398659
16 remainder_ComprehensiveNetIncome -85,111,000 -7,125,300 0 46,065 10,007,000 0001644378 0001084554 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 375 1,362 8,604,575 1,076,338,800 2,885,880,000 0001599407 0001320760 0001398659
1 Liabilities 10,298 29,383 3,777,589 489,792,900 1,594,712,000 0001602813 0001508348 0001398659
2 Expenses 41,043 53,282 8,399,520 767,246,500 1,139,697,000 0001602813 0001084554 0001362004
3 Revenues 0 0 1,511,709 818,658,800 1,185,097,000 0001304161 0001533106 0001362004
4 StockholdersEquity -1,431,000 -653,074 5,558,303 613,935,100 1,291,168,000 0001320760 0001084554 0001398659
5 NetIncome -13,883,000 -11,134,117 -69,839 103,082,100 267,547,000 0001094814 0001607450 0001398659
6 ComprehensiveNetIncome -15,204,000 -8,051,472 -69,839 48,464,100 267,547,000 0001094814 0001607450 0001398659
7 BaseVar 31,170 61,558 13,314,846 1,901,409,500 2,436,167,500 0001602813 0001304161 0001398659
8 EconomicCapitalRatio -7.40 -4.17 -0.0986 1.36 1.77 0001607450 0001084554 0001304161

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.16 -1.45 -0.189 0.785 1.23 0001607450 0001057379 0001620749
1 IntangibleAssets -1.39 -0.823 -0.101 0.615 0.711 0001607450 0001533106 0001362004
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001437226 0000851520
3 AssetsNoncurrent -0.788 -0.431 -0.0935 0.0867 0.456 0001607450 0001083446 0001644378
4 remainder_Assets -1.33 -0.789 -0.177 1.44 2.08 0001607450 0001620749 0001508348
5 LiabilitiesCurrent -0.478 -0.280 0.430 3.00 4.15 0001620749 0001094814 0001567503
6 LiabilitiesNoncurrent -0.870 -0.805 0.0830 0.342 0.449 0001419275 0001508348 0001592782
7 remainder_Liabilities -0.561 -0.499 0.0266 0.134 0.226 0001592782 0001620749 0001437226
8 CostOfRevenue -3.11 -1.21 0.153 0.393 0.691 0001437226 0001604738 0001592782
9 GeneralAndAdministrativeExpense -2.12 -0.921 0.104 0.456 1.54 0001629606 0001362004 0001592782
10 LaborExpense -0.662 -0.489 0.0674 0.181 0.256 0000851520 0001600347 0001592782
11 remainder_Expenses -4.58 -2.30 0.0954 0.962 1.78 0001592782 0001533106 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001437226 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001437226 0000851520
14 remainder_Revenues -1.39 -0.961 0.0417 2.40 4.20 0001607450 0001604738 0001592782
15 remainder_NetIncome -0.317 -0.205 0.0220 0.139 0.342 0001622879 0001600347 0001084554
16 remainder_ComprehensiveNetIncome -0.385 -0.0300 0.0124 0.0464 0.130 0001644378 0001567503 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -4.56 -2.17 -0.169 0.832 0.867 0001607450 0001057379 0001371489
1 Liabilities -0.690 -0.450 0.464 1.79 2.52 0001371489 0001604738 0001567503
2 Expenses -3.08 -2.12 -0.0914 0.682 0.747 0001607450 0001013706 0001644378
3 Revenues -1.39 -0.961 0.0417 2.40 4.20 0001607450 0001604738 0001592782
4 StockholdersEquity -2.34 -2.28 0.135 1.17 1.68 0001567503 0001437226 0001304161
5 NetIncome -4.46 -2.64 0.433 1.53 2.19 0001607450 0001533106 0001592782
6 ComprehensiveNetIncome -4.44 -2.62 0.514 1.56 2.24 0001607450 0001604738 0001592782
7 BaseVar nan nan nan nan nan 0000851520 0001437226 0000851520
8 EconomicCapitalRatio -6.74 -3.51 0.566 2.03 2.43 0001607450 0001084554 0001304161

2017

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001657045
error 1 × Median ECR is negative check_abs_values
{'median': -0.14247798380507293}
error 1 × IME and Company effects mismatched for Liabilities, Non-Current. IME Effects: 64.4, Company Effect: 64.3 subcommand.report
0001398659
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '31 of 31'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '31 of 31'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '31 of 31'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.8021907455187955}
warning 1 × Similarly named company. Duplicate? None
0001607450
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001100778
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001100778

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 0 1,823,997 323,473,500 1,433,895,000 0001100778 0001599407 0001398659
1 IntangibleAssets 0 0 0 689,876,000 1,468,712,000 0001084554 0001100778 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001533106 0000851520
3 AssetsNoncurrent 0 0 1,859,080 260,863,616 469,199,000 0001100778 0001084554 0001398659
4 remainder_Assets -293,380,760 -4,696,009 0.408 71,534,500 79,113,000 0001083446 0001567503 0000851520
5 LiabilitiesCurrent 0 25,388 1,543,229 195,525,500 838,784,000 0001653099 0001304161 0001398659
6 LiabilitiesNoncurrent 0 0 0 223,817,000 1,175,296,000 0001057379 0001100778 0001398659
7 remainder_Liabilities 0 0 0 40,468,000 60,091,000 0001013706 0001083446 0001644378
8 CostOfRevenue 0 0 0 468,098,000 771,725,000 0000851520 0001371489 0001362004
9 GeneralAndAdministrativeExpense 0 0 670,266 116,683,500 346,440,000 0001304161 0001600347 0001362004
10 LaborExpense 0 0 0 37,663,000 210,289,000 0001019737 0001437226 0000851520
11 remainder_Expenses 0 12,583 1,948,641 99,485,500 300,050,626 0001574910 0001502966 0001083446
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001533106 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001533106 0000851520
14 remainder_Revenues 0 0 224,596 695,037,205 1,229,162,000 0001100778 0001533106 0001362004
15 remainder_NetIncome -6,189,924 -1,272,022 0 8,332,573 320,583,000 0001533106 0001607450 0001398659
16 remainder_ComprehensiveNetIncome -66,375,000 -478,486 0 3,820,500 6,028,000 0001644378 0001629606 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 299 1,338 6,949,408 1,095,259,500 3,449,621,000 0001607450 0001084554 0001398659
1 Liabilities 22,913 32,794 1,602,845 443,577,500 2,020,827,000 0001602813 0001304161 0001398659
2 Expenses 3,866 24,442 4,205,529 641,644,614 1,166,407,000 0001304161 0001371489 0001362004
3 Revenues 0 0 224,596 695,037,205 1,229,162,000 0001100778 0001533106 0001362004
4 StockholdersEquity -1,524,646 -623,338 1,409,869 651,682,000 1,428,794,000 0001632121 0001502966 0001398659
5 NetIncome -37,898,285 -13,806,757 -136,720 91,810,500 260,841,000 0001100778 0001592782 0001398659
6 ComprehensiveNetIncome -37,898,285 -12,795,948 -92,862 74,228,500 260,841,000 0001100778 0001653099 0001398659
7 BaseVar 27,264 55,280 11,985,511 1,868,423,750 2,925,386,500 0001602813 0001622879 0001398659
8 EconomicCapitalRatio -46.0 -4.80 -0.142 1.37 1.76 0001100778 0001599407 0001304161

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 -37.3 -2.19 -0.133 0.848 1.40 0001100778 0001622879 0001084554
1 IntangibleAssets -29.4 -1.24 -0.221 0.523 2.38 0001100778 0001599407 0001622879
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001533106 0000851520
3 AssetsNoncurrent -28.4 -1.12 -0.147 0.881 2.69 0001100778 0001508348 0001622879
4 remainder_Assets -0.491 -0.249 -0.0267 2.28 31.4 0001622879 0001604738 0001100778
5 LiabilitiesCurrent -35.0 -0.910 0.370 1.94 3.05 0001100778 0001602813 0001607450
6 LiabilitiesNoncurrent -17.6 -0.736 -0.00574 0.198 0.253 0001100778 0001600347 0001502966
7 remainder_Liabilities -21.2 -0.727 0.0252 0.341 10.2 0001100778 0001661600 0001653099
8 CostOfRevenue -1.21 -1.00 0.131 0.305 1.91 0001057379 0001602813 0001100778
9 GeneralAndAdministrativeExpense -0.834 -0.763 0.116 0.622 3.35 0001502966 0001604738 0001100778
10 LaborExpense -0.656 -0.480 0.0516 0.126 0.689 0000851520 0001567503 0001100778
11 remainder_Expenses -38.1 -2.44 0.171 0.920 1.09 0001100778 0001644378 0001057379
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001533106 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001533106 0000851520
14 remainder_Revenues -8.09 -0.988 -0.0377 1.52 2.18 0001100778 0001622879 0001629606
15 remainder_NetIncome -3.47 -0.181 0.0714 0.348 2.45 0001533106 0001607450 0001100778
16 remainder_ComprehensiveNetIncome -0.895 -0.127 0.0259 0.187 0.728 0001632121 0001607450 0001533106
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -41.3 -3.00 -0.175 0.852 1.34 0001100778 0001013706 0001084554
1 Liabilities -37.2 -0.591 0.443 1.35 1.76 0001100778 0001084554 0001607450
2 Expenses -32.1 -1.87 0.0288 0.651 1.40 0001100778 0001620749 0001533106
3 Revenues -8.09 -0.988 -0.0377 1.52 2.18 0001100778 0001622879 0001629606
4 StockholdersEquity -2.36 -2.25 0.223 1.64 1.87 0001629606 0001533106 0001622879
5 NetIncome -37.8 -3.12 0.328 1.16 1.25 0001100778 0001592782 0001057379
6 ComprehensiveNetIncome -37.4 -2.73 0.344 1.16 1.31 0001100778 0001592782 0001057379
7 BaseVar nan nan nan nan nan 0000851520 0001533106 0000851520
8 EconomicCapitalRatio -43.9 -2.69 1.97 3.48 3.88 0001100778 0001599407 0001304161

2018

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
0001498291 0001678848
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001697730
warning 1 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '31 of 31'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.2978068152336264}
warning 1 × Similarly named company. Duplicate? None
0001607450
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001678848
warning 1 × Missing logo subcommand.report
0001693687
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001604738
warning 1 × Ignoring company because Expenses is zero pre-agg
0001230524

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 0 3,217,871 400,730,500 1,355,057,000 0001653099 0001100778 0001398659
1 IntangibleAssets 0 0 2,959 593,830,500 1,570,919,000 0001084554 0001632121 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001567503 0000851520
3 AssetsNoncurrent 0 0 1,019,480 252,642,128 367,874,000 0001574910 0001100778 0001398659
4 remainder_Assets -272,681,763 -6,430,558 386 63,668,000 235,595,000 0001083446 0001599407 0001398659
5 LiabilitiesCurrent 0 0 1,458,061 211,937,500 976,312,000 0001632121 0001574910 0001398659
6 LiabilitiesNoncurrent 0 0 0 157,494,000 1,140,871,000 0001057379 0001057379 0001398659
7 remainder_Liabilities 0 0 80,141 43,690,000 55,303,000 0001013706 0001657045 0001604738
8 CostOfRevenue 0 0 0 704,000,000 1,921,768,000 0000851520 0001100778 0001398659
9 GeneralAndAdministrativeExpense 0 0 1,438,255 249,779,000 693,865,000 0001607450 0001508348 0001398659
10 LaborExpense 0 0 0 101,060,500 215,052,000 0001019737 0001019737 0000851520
11 remainder_Expenses 17,050 41,664 1,407,947 96,820,500 174,815,000 0001602813 0001437226 0001371489
12 RevenueFromContractWithCustomer 0 0 0 846,306,000 3,000,790,000 0001019737 0001019737 0001398659
13 RevenueFromReimbursement 0 0 0 0 24,884,000 0001013706 0001693687 0000851520
14 remainder_Revenues -4,778,712 -477,517 0 464,716,376 743,614,000 0001084554 0001013706 0001019737
15 remainder_NetIncome -5,805,031 -4,199,500 0 19,923,000 104,589,000 0001083446 0001629606 0001019737
16 remainder_ComprehensiveNetIncome -153,734,000 -64,035,000 0 1,006,236 12,260,000 0001398659 0001607450 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 216 4,692 6,061,452 1,065,704,500 3,529,445,000 0001602813 0001599407 0001398659
1 Liabilities 26,286 71,954 2,627,465 379,219,500 2,125,263,000 0001602813 0001508348 0001398659
2 Expenses 20,307 45,066 5,676,298 1,001,505,000 2,735,246,000 0001602813 0001100778 0001398659
3 Revenues -4,778,712 -32,517 2,303,553 1,040,793,500 3,000,790,000 0001084554 0001100778 0001398659
4 StockholdersEquity -3,394,000 -2,070,088 2,485,493 686,485,000 1,404,182,000 0001661600 0001320760 0001398659
5 NetIncome -15,676,108 -4,790,358 -30,273 169,228,500 281,258,000 0001084554 0001620749 0001398659
6 ComprehensiveNetIncome -15,676,108 -4,790,358 -30,273 111,781,500 133,291,000 0001084554 0001620749 0001019737
7 BaseVar 23,404 67,889 8,279,377 1,774,678,000 5,780,096,000 0001602813 0001508348 0001398659
8 EconomicCapitalRatio -14.3 -3.30 0.476 1.78 1.98 0001629606 0001508348 0001622879

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 -7.58 -0.886 -0.0497 0.954 3.42 0001629606 0001604738 0001084554
1 IntangibleAssets -4.73 -0.573 -0.130 0.411 0.658 0001629606 0001574910 0001604738
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001567503 0000851520
3 AssetsNoncurrent -3.66 -0.398 -0.101 0.567 1.12 0001629606 0001508348 0001502966
4 remainder_Assets -2.30 -0.379 -0.0705 1.91 2.96 0001629606 0001362004 0001693687
5 LiabilitiesCurrent -2.09 -0.378 0.561 2.01 3.80 0001629606 0001604738 0001602813
6 LiabilitiesNoncurrent -1.53 -0.625 -0.00452 0.147 0.212 0001629606 0001607450 0001057379
7 remainder_Liabilities -4.28 -0.768 0.337 0.631 3.07 0001629606 0001574910 0001653099
8 CostOfRevenue -1.66 -1.38 0.183 0.416 0.905 0001502966 0001620749 0001629606
9 GeneralAndAdministrativeExpense -1.01 -0.472 0.0586 0.188 0.224 0001502966 0001629606 0001013706
10 LaborExpense -0.621 -0.351 0.0540 0.145 0.233 0000851520 0001657045 0001629606
11 remainder_Expenses -9.18 -0.839 0.224 0.963 1.04 0001629606 0001084554 0001013706
12 RevenueFromContractWithCustomer -1.32 -0.556 -0.281 2.04 2.23 0001629606 0001661600 0001502966
13 RevenueFromReimbursement -0.00884 -0.00550 -0.00219 -0.00159 0.0772 0001629606 0001604738 0000851520
14 remainder_Revenues -1.35 -0.666 -0.218 1.20 1.87 0001629606 0001661600 0001437226
15 remainder_NetIncome -0.968 -0.568 0.0762 0.293 0.573 0001661600 0001083446 0001592782
16 remainder_ComprehensiveNetIncome -0.408 -0.0331 0.0109 0.0420 0.0680 0001644378 0001592782 0001657045
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -10.4 -1.57 -0.0340 0.992 1.79 0001629606 0001371489 0001084554
1 Liabilities -5.74 -0.240 0.753 1.29 1.82 0001629606 0000851520 0001602813
2 Expenses -7.98 -1.52 0.0325 0.537 0.847 0001629606 0001083446 0001661600
3 Revenues -2.68 -0.726 0.216 1.44 1.60 0001629606 0001604738 0001320760
4 StockholdersEquity -2.10 -1.98 0.497 1.91 2.07 0001567503 0001371489 0001084554
5 NetIncome -10.4 -0.923 0.130 1.28 1.44 0001629606 0001592782 0001644378
6 ComprehensiveNetIncome -10.3 -0.909 0.141 1.12 1.43 0001629606 0001592782 0001320760
7 BaseVar nan nan nan nan nan 0000851520 0001567503 0000851520
8 EconomicCapitalRatio -13.6 -2.63 1.14 2.44 2.65 0001629606 0001508348 0001622879

2019

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
0001574910 0001084554 0001678848
error 1 × Median ECR is negative check_abs_values
{'median': -0.15740766719426522}
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001508348
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001574910 0001084554 0001678848
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -2.7494315600712955}
warning 1 × Missing logo subcommand.report
0001693687

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 0 1,101,497 455,815,000 1,551,676,000 0001653099 0001629606 0001398659
1 IntangibleAssets 0 0 454,449 624,489,216 1,805,327,000 0001230524 0001533106 0001398659
2 OperatingLeaseAssets 0 0 128 98,049,818 330,854,000 0001230524 0001230524 0001398659
3 AssetsNoncurrent 0 0 532,763 326,409,250 471,114,000 0001592782 0001533106 0001398659
4 remainder_Assets -355,764,780 -8,866,252 0 156,618,057 295,213,000 0001083446 0001230524 0001398659
5 LiabilitiesCurrent 0 0 4,419,222 273,695,409 910,211,000 0001653099 0001498291 0001398659
6 LiabilitiesNoncurrent 0 0 66,828 293,613,009 1,850,812,000 0001230524 0001622879 0001398659
7 remainder_Liabilities -18,269,448 -507,500 118,462 24,253,900 37,621,000 0001083446 0001693687 0001362004
8 CostOfRevenue 0 0 3,484,589 807,572,370 2,294,688,000 0001230524 0001498291 0001398659
9 GeneralAndAdministrativeExpense 0 0 752,480 304,789,500 794,901,000 0001592782 0001419275 0001398659
10 LaborExpense 0 0 0 10,831,060 130,619,000 0001057379 0001498291 0001644378
11 remainder_Expenses -1,995,000 0 1,057,204 52,669,600 127,148,000 0001437226 0001592782 0001398659
12 RevenueFromContractWithCustomer 0 0 2,368 1,203,152,929 3,520,543,000 0001230524 0001657045 0001398659
13 RevenueFromReimbursement 0 0 0 0 34,668,113 0001013706 0001502966 0001599407
14 remainder_Revenues 0 0 0 139,222,086 722,138,000 0001013706 0001362004 0001644378
15 remainder_NetIncome -6,580,039 -3,317,100 -3,496 1,030,576 4,054,156 0001083446 0001620749 0001751143
16 remainder_ComprehensiveNetIncome -94,471,000 -17,218,900 0 313,400 844,000 0001644378 0001592782 0001057379
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 671 1,417 7,264,050 1,196,665,904 4,454,184,000 0001620749 0001629606 0001398659
1 Liabilities 90,642 128,386 5,628,367 588,162,284 2,765,013,000 0001620749 0001629606 0001398659
2 Expenses 14,129 36,079 15,566,406 1,151,094,100 3,216,737,000 0001230524 0001629606 0001398659
3 Revenues 0 0 3,852,852 1,251,608,900 3,520,543,000 0001230524 0001498291 0001398659
4 StockholdersEquity -5,367,339 -3,853,810 1,168,400 658,896,200 1,689,171,000 0001419275 0001230524 0001398659
5 NetIncome -16,975,742 -10,597,522 -176,433 139,012,200 304,881,000 0001622879 0001657045 0001398659
6 ComprehensiveNetIncome -16,975,742 -10,569,022 -143,693 73,004,600 280,385,000 0001622879 0001657045 0001398659
7 BaseVar 60,815 129,516 20,461,075 2,068,930,176 6,991,024,000 0001620749 0001592782 0001398659
8 EconomicCapitalRatio -2.87 -2.75 -0.156 1.58 1.93 0001653099 0001693687 0001751143

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.92 -0.460 -0.0177 0.514 0.985 0001592782 0001437226 0001419275
1 IntangibleAssets -2.60 -0.571 -0.0680 0.418 1.16 0001592782 0001644378 0001629606
2 OperatingLeaseAssets -0.524 -0.0599 -0.0108 0.0690 0.116 0001592782 0001777319 0001599407
3 AssetsNoncurrent -2.76 -0.480 -0.195 0.617 2.34 0001592782 0001693687 0001230524
4 remainder_Assets -2.59 -0.732 -0.205 1.73 2.17 0001592782 0001437226 0001693687
5 LiabilitiesCurrent -0.446 -0.237 0.515 1.56 1.85 0001419275 0001398659 0001620749
6 LiabilitiesNoncurrent -0.696 -0.628 0.00845 0.205 0.217 0001398659 0001498291 0001644378
7 remainder_Liabilities -1.54 -0.767 0.158 0.595 6.92 0001657045 0001419275 0001653099
8 CostOfRevenue -15.9 -1.12 -0.125 0.362 0.431 0001592782 0001398659 0001533106
9 GeneralAndAdministrativeExpense -1.10 -0.278 0.0490 0.164 2.16 0001502966 0001533106 0001592782
10 LaborExpense -0.470 -0.246 0.0239 0.0580 0.351 0001013706 0001533106 0001592782
11 remainder_Expenses -1.42 -0.483 0.172 0.621 2.87 0001629606 0001230524 0001592782
12 RevenueFromContractWithCustomer -0.948 -0.730 -0.292 1.75 16.6 0001437226 0001657045 0001592782
13 RevenueFromReimbursement -0.483 -0.0808 -0.0403 -0.0204 1.57 0001592782 0001083446 0001599407
14 remainder_Revenues -2.26 -0.377 -0.125 1.22 2.51 0001592782 0001620749 0001437226
15 remainder_NetIncome -0.704 -0.327 0.0600 0.147 0.772 0001533106 0001398659 0001592782
16 remainder_ComprehensiveNetIncome -0.229 -0.00704 0.00357 0.0337 0.0576 0001644378 0001083446 0001657045
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -3.95 -1.37 -0.180 0.712 0.925 0001592782 0001629606 0001230524
1 Liabilities -0.501 -0.239 0.604 1.34 1.39 0001657045 0001607450 0001057379
2 Expenses -10.5 -1.49 -0.0238 0.495 0.525 0001592782 0001419275 0001230524
3 Revenues -0.529 -0.497 0.0183 1.47 13.8 0001533106 0001777319 0001592782
4 StockholdersEquity -2.05 -2.03 0.421 1.74 2.00 0001567503 0001629606 0001751143
5 NetIncome -1.53 -0.778 0.0753 0.964 4.08 0001629606 0001419275 0001592782
6 ComprehensiveNetIncome -1.52 -0.782 0.0786 0.917 4.12 0001629606 0001419275 0001592782
7 BaseVar nan nan nan nan nan 0001013706 0001567503 0001013706
8 EconomicCapitalRatio -2.44 -2.32 0.272 2.01 2.36 0001653099 0001693687 0001751143

2020

Logs

warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -2.1508050063732695}
warning 1 × Similarly named company. Duplicate? None
0001607450
warning 1 × Missing logo subcommand.report
0001693687
warning 1 × Ignoring company because Expenses is zero pre-agg
0001661600

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 1,440 6,360,724 434,545,600 1,748,868,000 0001654672 0001777319 0001398659
1 IntangibleAssets 0 0 1,382,260 863,276,000 1,932,420,000 0001304161 0001230524 0001398659
2 OperatingLeaseAssets 0 0 13,697 100,800,400 304,714,000 0001084554 0001777319 0001398659
3 AssetsNoncurrent 0 0 885,565 383,893,600 554,940,000 0001084554 0001502966 0001398659
4 remainder_Assets -344,612,000 -41,130,805 0 9,247,531 332,571,000 0001083446 0001362004 0001398659
5 LiabilitiesCurrent 123,327 155,583 4,764,596 381,089,300 1,204,152,000 0001620749 0001498291 0001398659
6 LiabilitiesNoncurrent 0 0 728,497 414,929,600 1,835,132,000 0001084554 0001574910 0001398659
7 remainder_Liabilities -10,959,000 -1,142,700 0 18,609,800 25,451,000 0001083446 0001398659 0001643615
8 CostOfRevenue 0 0 4,366,762 868,097,800 2,418,137,000 0001084554 0001777319 0001398659
9 GeneralAndAdministrativeExpense 0 517 3,837,028 339,334,200 789,849,000 0001693687 0001419275 0001398659
10 LaborExpense 0 0 0 6,403,370 9,142,000 0001083446 0001437226 0001013706
11 remainder_Expenses -1,317,576 0 2,772,465 123,174,700 250,150,000 0001508348 0001437226 0001751143
12 RevenueFromContractWithCustomer 0 0 83.2 1,308,050,600 3,709,377,000 0001084554 0001084554 0001398659
13 RevenueFromReimbursement 0 0 0 5,337,655 26,887,000 0001013706 0001437226 0001289848
14 remainder_Revenues 0 0 0 143,070,956 468,217,000 0001013706 0001230524 0001751143
15 remainder_NetIncome -57,571,000 -26,116,263 0 1,969,648 97,924,000 0001398659 0001751143 0001083446
16 remainder_ComprehensiveNetIncome -13,384,000 -1,935,900 0 101,400 2,467,000 0001398659 0001574910 0001371489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,232 16,428 19,246,569 1,484,345,800 4,873,513,000 0001620749 0001599407 0001398659
1 Liabilities 123,327 155,583 9,000,486 795,890,500 3,039,284,000 0001620749 0001508348 0001398659
2 Expenses 26,318 61,153 14,586,864 1,282,873,700 3,343,530,000 0001620749 0001084554 0001398659
3 Revenues 0 0 8,543,015 1,316,116,700 3,709,377,000 0001084554 0001419275 0001398659
4 StockholdersEquity -3,849,003 -2,137,895 6,732,228 688,455,300 1,834,229,000 0001498291 0001654672 0001398659
5 NetIncome -57,949,000 -26,504,900 -232,907 102,111,700 308,276,000 0001643615 0001230524 0001398659
6 ComprehensiveNetIncome -57,838,000 -27,067,400 -232,907 101,523,100 294,892,000 0001643615 0001230524 0001398659
7 BaseVar 78,342 187,873 23,237,311 2,441,543,150 7,518,329,500 0001620749 0001419275 0001398659
8 EconomicCapitalRatio -2.56 -2.15 0.508 1.34 1.42 0001620749 0001622879 0001304161

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 -0.578 -0.526 -0.0969 0.997 3.54 0001502966 0001289848 0001084554
1 IntangibleAssets -0.762 -0.701 -0.100 0.913 2.31 0001502966 0001654672 0001230524
2 OperatingLeaseAssets -0.138 -0.106 -0.0438 0.189 0.627 0001498291 0001643615 0001508348
3 AssetsNoncurrent -0.297 -0.236 -0.0939 0.575 2.18 0001693687 0001657045 0001622879
4 remainder_Assets -0.626 -0.250 -0.0595 0.667 3.02 0001622879 0001777319 0001654672
5 LiabilitiesCurrent -0.838 -0.620 0.392 1.01 1.24 0001632121 0001508348 0001620749
6 LiabilitiesNoncurrent -0.935 -0.534 -0.0103 0.348 0.593 0001508348 0001607450 0001657045
7 remainder_Liabilities -0.469 -0.181 0.0143 0.101 0.152 0001574910 0001632121 0001013706
8 CostOfRevenue -1.16 -0.927 -0.0712 0.484 0.754 0001437226 0001643615 0001657045
9 GeneralAndAdministrativeExpense -0.523 -0.393 0.0320 0.225 0.295 0001657045 0001654672 0001751143
10 LaborExpense -0.374 -0.142 0.0234 0.0378 0.0418 0001013706 0001777319 0001437226
11 remainder_Expenses -1.04 -0.798 0.140 0.409 0.432 0001693687 0001654672 0001657045
12 RevenueFromContractWithCustomer -0.821 -0.698 -0.243 1.06 1.34 0001437226 0001508348 0001320760
13 RevenueFromReimbursement -0.0262 -0.0236 -0.0139 0.0110 0.415 0001437226 0001419275 0001599407
14 remainder_Revenues -0.393 -0.354 -0.182 0.977 2.26 0001657045 0001084554 0001437226
15 remainder_NetIncome -0.506 -0.143 -0.0752 0.0769 3.63 0001599407 0001371489 0001657045
16 remainder_ComprehensiveNetIncome -0.0303 -0.00264 0.000421 0.00337 0.0135 0001657045 0001693687 0001371489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -1.25 -1.15 -0.108 0.945 1.12 0001498291 0001419275 0001084554
1 Liabilities -0.841 -0.246 0.280 0.895 1.23 0001632121 0001643615 0001437226
2 Expenses -0.764 -0.714 -0.0891 0.491 0.702 0001502966 0001289848 0001657045
3 Revenues -1.18 -0.515 0.116 0.915 1.41 0001657045 0001777319 0001437226
4 StockholdersEquity -2.17 -1.97 0.406 1.15 1.29 0001607450 0001371489 0001084554
5 NetIncome -0.924 -0.834 0.0664 0.504 3.15 0001084554 0001643615 0001657045
6 ComprehensiveNetIncome -0.924 -0.834 0.0671 0.503 3.12 0001084554 0001643615 0001657045
7 BaseVar nan nan nan nan nan 0001013706 0001502966 0001013706
8 EconomicCapitalRatio -2.57 -2.16 0.496 1.32 1.41 0001620749 0001622879 0001304161

2021

Logs

error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
0001600347
warning 2 × Similarly named company. Duplicate? None
0001289848 0001847590
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001620749 0001796297
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -2.531149463151096}
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001230524
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001508348
warning 1 × Ignoring company because Expenses is zero pre-agg
0001661600
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001084554

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 57,391 55,577,142 957,257,750 1,921,641,000 0001654672 0001790625 0001398659
1 IntangibleAssets 0 0 18,508,033 1,202,511,800 1,900,662,000 0001084554 0001777319 0001398659
2 OperatingLeaseAssets 0 0 2,473,000 198,634,900 270,603,000 0001084554 0001599407 0001398659
3 AssetsNoncurrent 0 0 3,830,068 337,924,700 537,247,000 0001084554 0001371489 0001398659
4 remainder_Assets -351,287,000 -114,875,857 43,094 65,107,150 345,116,000 0001083446 0001599407 0001398659
5 LiabilitiesCurrent 22,661 195,042 26,968,535 677,145,200 1,312,743,000 0001813603 0001437226 0001398659
6 LiabilitiesNoncurrent 0 0 10,259,573 628,257,000 1,765,393,000 0001084554 0001437226 0001398659
7 remainder_Liabilities -12,273,000 -5,941,450 0 23,100,650 33,187,000 0001289848 0001057379 0001643615
8 CostOfRevenue 0 0 30,937,020 1,494,335,350 2,590,252,000 0000851520 0001013706 0001398659
9 GeneralAndAdministrativeExpense 0 127,727 9,513,156 489,571,600 865,715,000 0001751143 0001777319 0001398659
10 LaborExpense 0 0 0 101,642,250 278,047,000 0000887936 0001320760 0000851520
11 remainder_Expenses -54,746,000 0 7,670,243 127,882,750 284,502,000 0001847590 0001622879 0001751143
12 RevenueFromContractWithCustomer 0 0 8,859,832 1,261,714,400 4,022,211,000 0000887936 0001777319 0001398659
13 RevenueFromReimbursement 0 0 0 17,458,379 31,419,000 0000887936 0001398659 0000851520
14 remainder_Revenues -31,419,000 0 0 396,244,850 2,776,222,000 0000851520 0001320760 0000887936
15 remainder_NetIncome -24,667,000 -17,609,500 -3,480 19,331,650 27,197,000 0001398659 0001751143 0001289848
16 remainder_ComprehensiveNetIncome -22,405,000 -6,935,424 0 1,689,050 3,779,000 0000887936 0001751143 0001289848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 285,109 1,371,028 123,242,429 2,537,790,250 4,975,269,000 0001439264 0001419275 0001398659
1 Liabilities 29,560 396,452 52,644,728 1,305,402,200 3,078,136,000 0001813603 0001847590 0001398659
2 Expenses 247,217 467,678 76,867,882 2,056,530,150 3,628,096,000 0001813603 0001622879 0001398659
3 Revenues 0 0 82,766,280 2,225,793,700 4,022,211,000 0001084554 0001622879 0001398659
4 StockholdersEquity -151,490,000 -2,821,336 35,460,415 1,232,388,050 1,897,133,000 0001751143 0001419275 0001398659
5 NetIncome -39,145,650 -28,241,830 -747,597 174,772,200 369,448,000 0001777319 0001502966 0001398659
6 ComprehensiveNetIncome -39,145,650 -28,241,830 -747,597 162,426,500 360,435,000 0001777319 0001502966 0001398659
7 BaseVar 1,514,142 2,936,069 199,405,752 4,073,621,925 7,868,696,000 0001230524 0001847590 0001398659
8 EconomicCapitalRatio -6.13 -2.53 0.639 1.39 1.43 0001813603 0001362004 0001057379

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 -0.985 -0.363 -0.0663 2.06 3.19 0001439264 0001320760 0001813603
1 IntangibleAssets -2.72 -0.594 -0.0137 0.719 2.53 0001813603 0001790625 0001657045
2 OperatingLeaseAssets -0.670 -0.153 -0.0263 0.197 0.600 0001813603 0001654672 0001508348
3 AssetsNoncurrent -1.92 -0.434 -0.0883 0.755 1.52 0001813603 0001654672 0001230524
4 remainder_Assets -0.737 -0.360 -0.0524 0.411 3.37 0001813603 0001289848 0001654672
5 LiabilitiesCurrent -1.39 -0.584 0.185 0.585 2.38 0001813603 0001362004 0001439264
6 LiabilitiesNoncurrent -1.05 -0.868 -0.0139 0.514 0.596 0001813603 0001632121 0001057379
7 remainder_Liabilities -0.538 -0.185 0.0349 0.121 0.211 0001230524 0001654672 0001013706
8 CostOfRevenue -1.23 -0.696 -0.165 0.428 1.19 0001437226 0001643615 0001813603
9 GeneralAndAdministrativeExpense -1.39 -0.438 0.0705 0.387 0.649 0001439264 0001790625 0001813603
10 LaborExpense -0.530 -0.443 0.0564 0.0981 0.147 0000851520 0001790625 0001813603
11 remainder_Expenses -1.21 -0.430 0.0748 0.280 0.715 0001777319 0001371489 0001847590
12 RevenueFromContractWithCustomer -1.47 -0.943 -0.00467 1.14 1.22 0001813603 0001622879 0001057379
13 RevenueFromReimbursement -0.0356 -0.0245 -0.0141 0.0340 0.264 0001813603 0001439264 0001599407
14 remainder_Revenues -0.484 -0.288 -0.184 1.08 2.54 0001813603 0001643615 0001437226
15 remainder_NetIncome -7.73 -0.157 0.117 0.254 0.292 0001813603 0001320760 0001013706
16 remainder_ComprehensiveNetIncome -0.0187 -0.00885 0.00133 0.00446 0.00651 0001622879 0001084554 0001289848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -3.41 -1.42 -0.0538 0.788 0.838 0001813603 0000887936 0001084554
1 Liabilities -1.95 -0.587 0.118 0.966 1.19 0001813603 0001643615 0001439264
2 Expenses -1.12 -0.823 -0.0565 0.473 2.32 0001777319 0001790625 0001813603
3 Revenues -1.99 -0.559 0.205 0.905 1.41 0001813603 0000851520 0001437226
4 StockholdersEquity -2.30 -1.48 0.0884 0.690 1.68 0001439264 0001289848 0001084554
5 NetIncome -7.40 -1.27 0.275 0.739 0.771 0001813603 0001751143 0001057379
6 ComprehensiveNetIncome -7.40 -1.27 0.276 0.738 0.773 0001813603 0001751143 0001437226
7 BaseVar nan nan nan nan nan 0000851520 0001419275 0000851520
8 EconomicCapitalRatio -6.32 -2.72 0.453 1.20 1.25 0001813603 0001362004 0001057379

2022

Logs

warning 2 × Similarly named company. Duplicate? None
0001289848 0001847590
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.4054164399313125}
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001508348
warning 1 × Ignoring company because Expenses is zero pre-agg
0001661600
warning 1 × Ignoring company because ECR is too negative pre-agg
0001673504
warning 1 × Ignoring company because Assets is zero pre-agg
0001693687

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 10,042 38,875,416 1,040,854,200 1,779,492,000 0001654672 0001437226 0001398659
1 IntangibleAssets 0 0 19,082,608 1,300,587,400 1,773,911,000 0001230524 0001599407 0001398659
2 OperatingLeaseAssets 0 0 3,726,431 176,181,000 203,764,000 0001230524 0001437226 0000887936
3 AssetsNoncurrent 0 0 2,277,993 379,707,065 528,767,000 0001508348 0001371489 0001083446
4 remainder_Assets -372,980,000 -151,809,930 0 70,752,100 352,153,000 0001083446 0001304161 0001398659
5 LiabilitiesCurrent 34,106 86,099 23,907,350 730,339,250 1,107,497,000 0001813603 0001320760 0001398659
6 LiabilitiesNoncurrent 0 0 4,344,706 688,915,000 1,655,159,000 0001439264 0001013706 0001398659
7 remainder_Liabilities -32,146,000 -2,116,350 0 31,891,976 41,701,000 0001289848 0000887936 0001790625
8 CostOfRevenue 0 0 19,235,921 1,646,777,250 2,834,774,000 0000851520 0001320760 0001398659
9 GeneralAndAdministrativeExpense 13,001 22,219 17,993,577 571,676,850 938,385,000 0001620749 0001777319 0001398659
10 LaborExpense 0 0 0 122,761,850 264,235,000 0000887936 0001362004 0000851520
11 remainder_Expenses -91,176,000 -420,269 8,293,766 89,428,300 154,499,000 0001847590 0001777319 0001398659
12 RevenueFromContractWithCustomer 0 0 24,245,785 2,466,883,200 4,371,172,000 0001230524 0001320760 0001398659
13 RevenueFromReimbursement 0 0 0 14,578,300 49,473,000 0000887936 0001437226 0000851520
14 remainder_Revenues -49,473,000 0 0 41,720,119 242,238,000 0000851520 0001013706 0001437226
15 remainder_NetIncome -90,110,000 -21,572,150 -803,620 4,930,304 8,817,000 0001398659 0001632121 0001289848
16 remainder_ComprehensiveNetIncome -178,772,000 -29,846,364 0 1,181,461 2,902,000 0001398659 0001508348 0001362004
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,358 197,141 101,096,814 2,724,289,950 4,588,814,000 0001654672 0001777319 0001398659
1 Liabilities 34,106 126,057 35,574,389 1,415,398,450 2,762,656,000 0001813603 0001599407 0001398659
2 Expenses 75,710 312,155 75,238,872 2,293,918,300 3,927,658,000 0001620749 0001777319 0001398659
3 Revenues 0 0 47,746,271 2,466,883,200 4,371,172,000 0001230524 0001599407 0001398659
4 StockholdersEquity -4,161,312 -2,224,715 41,343,294 1,308,891,500 1,826,158,000 0001632121 0001057379 0001398659
5 NetIncome -49,235,698 -32,894,900 -122,831 175,581,200 353,404,000 0001419275 0001320760 0001398659
6 ComprehensiveNetIncome -49,235,698 -32,323,264 -122,831 141,374,300 187,632,000 0001419275 0001320760 0000887936
7 BaseVar 95,067 1,145,493 143,269,209 4,471,326,875 7,959,591,000 0001620749 0001419275 0001398659
8 EconomicCapitalRatio -13.5 -3.41 0.531 1.43 1.52 0001654672 0001398659 0001304161

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.52 -1.11 -0.0564 0.612 3.07 0001654672 0001437226 0001813603
1 IntangibleAssets -5.88 -1.29 -0.0197 0.917 1.91 0001654672 0001013706 0001657045
2 OperatingLeaseAssets -1.69 -0.318 -0.0323 0.0819 0.550 0001654672 0001437226 0001508348
3 AssetsNoncurrent -3.81 -0.551 -0.0776 1.08 6.06 0001654672 0000887936 0001230524
4 remainder_Assets -0.862 -0.478 -0.0265 0.411 1.78 0001654672 0001289848 0001602813
5 LiabilitiesCurrent -0.739 -0.530 0.259 0.956 1.56 0001602813 0000887936 0001654672
6 LiabilitiesNoncurrent -3.20 -0.797 -0.00751 0.420 0.737 0001654672 0001502966 0001437226
7 remainder_Liabilities -0.846 -0.514 0.0151 0.114 0.189 0001654672 0001644378 0001437226
8 CostOfRevenue -1.59 -0.779 -0.154 0.818 1.63 0001437226 0001643615 0001654672
9 GeneralAndAdministrativeExpense -4.12 -0.968 0.136 0.457 1.23 0001230524 0001790625 0001654672
10 LaborExpense -0.549 -0.380 0.0724 0.145 0.227 0000851520 0001398659 0001654672
11 remainder_Expenses -0.855 -0.417 0.0649 0.207 0.599 0001599407 0001602813 0001847590
12 RevenueFromContractWithCustomer -2.03 -1.29 0.120 0.973 1.35 0001654672 0001013706 0001644378
13 RevenueFromReimbursement -0.0153 -0.00975 -0.00501 0.0118 0.111 0001654672 0001398659 0000851520
14 remainder_Revenues -0.689 -0.340 -0.210 1.46 3.20 0001654672 0001320760 0001437226
15 remainder_NetIncome -9.97 -1.88 0.216 0.399 0.515 0001654672 0001643615 0001437226
16 remainder_ComprehensiveNetIncome -0.0436 -0.0244 0.00463 0.0146 0.0206 0001398659 0001320760 0001777319
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -10.1 -1.60 0.0644 0.578 0.692 0001654672 0001289848 0001508348
1 Liabilities -2.96 -0.647 0.0890 0.975 1.58 0001654672 0001790625 0001437226
2 Expenses -3.00 -1.45 -0.0131 0.666 2.80 0001230524 0000887936 0001654672
3 Revenues -2.73 -1.35 0.177 0.899 1.79 0001654672 0001320760 0001437226
4 StockholdersEquity -3.13 -1.88 0.237 1.00 1.45 0001654672 0001362004 0001813603
5 NetIncome -9.89 -3.93 0.374 0.913 1.17 0001654672 0001643615 0001437226
6 ComprehensiveNetIncome -9.88 -3.93 0.377 0.907 1.16 0001654672 0001643615 0001437226
7 BaseVar nan nan nan nan nan 0000851520 0001437226 0000851520
8 EconomicCapitalRatio -13.0 -2.91 1.03 1.93 2.02 0001654672 0001398659 0001304161

Estimates

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