QA: us_recreation 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
0000811532 CEDAR FAIR L P CEDAR F NaN NaN NaN NaN 25 5 1 NaN NaN NaN NaN -176.14300 156.391000 414.966000 NaN NaN NaN NaN -20 -4
0001090396 TABLE TRAC INC TABLE T 13 12 23 8 1 2 2 77.62960 117.40900 -617.83200 149.34400 260.15200 295.645000 288.404000 -1 11 -15 -7 1 0
0001744489 Walt Disney Co Walt Di NaN NaN NaN NaN 4 4 3 NaN NaN NaN NaN 182.84000 210.206000 220.959000 NaN NaN NaN NaN 0 -1
0001297937 PARKS AMERICA INC PARKS A NaN 7 6 2 3 3 4 NaN 218.54400 264.19500 271.88200 212.19000 240.113000 177.389000 NaN -1 -4 1 0 1
0000015847 BUTLER NATIONAL CORP BUTLER 8 8 9 4 8 10 5 129.60900 169.90200 167.02900 229.77000 86.48410 82.006800 141.347000 0 1 -5 4 2 -5
0001418372 Salamander Innisbrook LLC Salaman 5 14 NaN NaN 11 6 6 173.19000 78.15490 NaN NaN 31.13820 128.576000 138.041000 9 NaN NaN NaN -5 0
0001335258 Live Nation Entertainment Inc. Live Na 10 13 11 10 13 12 7 116.60300 99.03710 104.20800 124.70100 5.53256 65.169100 100.911000 3 -2 -1 3 -1 -5
0001698991 Accel Entertainment Inc. Accel E NaN NaN NaN 13 12 11 8 NaN NaN NaN 18.06360 21.33770 67.565900 84.952800 NaN NaN NaN -1 -1 -3
0000812011 VAIL RESORTS INC VAIL RE 3 3 5 3 9 13 9 224.52200 249.39600 266.54300 241.73400 53.17940 64.673200 75.157100 0 2 -2 6 4 -4
0001071255 GOLDEN ENTERTAINMENT INC. GOLDEN 11 17 15 14 16 9 10 113.24000 36.05130 25.96710 11.87200 -30.44960 83.202800 65.132600 6 -2 -1 2 -7 1
0001766363 Endeavor Group Holdings Inc. Endeavo NaN NaN NaN NaN NaN 19 11 NaN NaN NaN NaN NaN 10.377800 54.692100 NaN NaN NaN NaN NaN -8
0001869198 Life Time Group Holdings Inc. Life Ti NaN NaN NaN NaN NaN 22 12 NaN NaN NaN NaN NaN -1.259630 49.701100 NaN NaN NaN NaN NaN -10
0001318568 Everi Holdings Inc. Everi H 20 20 18 15 15 14 13 -93.81210 -26.74300 -5.73777 9.83759 -27.73830 62.989300 47.633500 0 -2 -3 0 -1 -1
0001795250 Sphere Entertainment Co. Sphere NaN NaN NaN NaN 7 15 14 NaN NaN NaN NaN 168.60200 51.828700 40.828400 NaN NaN NaN NaN 8 -1
0001802156 Xponential Fitness Inc. Xponent NaN NaN NaN NaN NaN 28 15 NaN NaN NaN NaN NaN -42.724900 33.753700 NaN NaN NaN NaN NaN -13
0001564902 SeaWorld Entertainment Inc. SeaWorl 15 22 14 11 20 16 16 25.36750 -29.15130 30.75520 31.71950 -63.23080 45.941700 33.140200 7 -8 -3 9 -4 0
0001319161 Warner Music Group Corp. Warner 16 18 16 NaN 17 18 17 2.85562 23.09420 18.74710 NaN -35.59360 22.841400 28.448300 2 -2 NaN NaN 1 -1
0001793659 Rush Street Interactive Inc. Rush St NaN NaN NaN NaN 21 8 18 NaN NaN NaN NaN -78.60240 120.996000 22.691200 NaN NaN NaN NaN -13 10
0001708176 Hall of Fame Resort & Entertainment Co Hall of NaN NaN NaN NaN 19 29 19 NaN NaN NaN NaN -48.33300 -77.824800 7.530290 NaN NaN NaN NaN 10 -10
0001637207 Planet Fitness Inc. Planet 17 19 17 16 18 26 20 -16.08700 -1.25153 -4.66872 -17.32750 -45.67350 -27.376100 6.876720 2 -2 -1 2 8 -6
0001636519 Madison Square Garden Sports Corp. Madison 7 11 8 7 22 24 21 133.13100 121.30800 169.03700 149.39600 -88.26050 -23.674200 4.490270 4 -3 -1 15 2 -3
0000055234 KENILWORTH SYSTEMS CORP KENILWO NaN NaN NaN NaN NaN 20 22 NaN NaN NaN NaN NaN -0.002876 0.171431 NaN NaN NaN NaN NaN 2
0001674227 SCWorx Corp. SCWorx 19 27 25 24 26 31 23 -30.78790 -838.90900 -1054.49000 -705.40900 -367.95900 -171.609000 -1.200480 8 -2 -1 2 5 -8
0000013156 Galaxy Gaming Inc. Galaxy 12 16 12 18 24 25 24 88.15030 43.67550 90.38920 -58.49680 -100.82500 -27.323400 -63.522200 4 -4 6 6 1 -1
0001286459 ALL FOR ONE MEDIA CORP. ALL FOR NaN NaN 19 NaN 30 NaN 25 NaN NaN -219.54900 NaN -748.18100 NaN -148.093000 NaN NaN NaN NaN NaN NaN
0001703073 VIVIC CORP. VIVIC C NaN NaN NaN 9 27 NaN 26 NaN NaN NaN 140.89700 -553.81100 NaN -162.324000 NaN NaN NaN 18 NaN NaN
0001803977 Limitless X Holdings Inc. Limitle NaN NaN NaN NaN 32 36 27 NaN NaN NaN NaN -790.35700 -754.699000 -378.893000 NaN NaN NaN NaN 4 -9
0001829966 EBET Inc. EBET In NaN NaN NaN NaN NaN 34 28 NaN NaN NaN NaN NaN -675.662000 -401.293000 NaN NaN NaN NaN NaN -6
0001308569 MAJOR LEAGUE FOOTBALL INC MAJOR L 29 29 20 21 28 32 29 -1886.18000 -2308.28000 -366.69300 -424.58900 -554.39400 -287.233000 -420.426000 0 -9 1 7 4 -3
0001584693 Healthcare Integrated Technologies Inc. Healthc NaN NaN NaN 23 29 35 30 NaN NaN NaN -686.34900 -701.61900 -686.358000 -507.574000 NaN NaN NaN 6 6 -5
0001445831 Newpoint Financial Corp Newpoin 28 NaN 22 22 NaN 21 31 -1447.09000 NaN -491.78200 -469.39900 NaN -1.094040 -508.455000 NaN NaN 0 NaN NaN 10
0001444839 Bravo Multinational Inc. Bravo M 26 NaN 24 NaN NaN 33 32 -914.02200 NaN -914.05700 NaN NaN -594.684000 -555.550000 NaN NaN NaN NaN NaN -1
0001451448 ESPORTS ENTERTAINMENT GROUP INC. ESPORTS 27 25 NaN NaN NaN 27 33 -1137.79000 -756.86900 NaN NaN NaN -40.377500 -803.701000 -2 NaN NaN NaN NaN 6
0001389518 Clubhouse Media Group Inc. Clubhou 21 NaN NaN NaN NaN 38 34 -211.33400 NaN NaN NaN NaN -1979.770000 -921.936000 NaN NaN NaN NaN NaN -4
0000725929 B2Digital Inc. B2Digit NaN NaN NaN NaN 31 37 35 NaN NaN NaN NaN -770.36000 -768.344000 -1065.950000 NaN NaN NaN NaN 6 -2
0001106213 SEAFARER EXPLORATION CORP SEAFARE NaN NaN NaN 25 36 NaN 36 NaN NaN NaN -988.33500 -1390.80000 NaN -1351.070000 NaN NaN NaN 11 NaN NaN
0001621672 Super League Gaming Inc. Super L NaN NaN NaN 27 35 17 37 NaN NaN NaN -1708.22000 -904.80000 35.894000 -1900.480000 NaN NaN NaN 8 -18 20
0001622996 ACRO BIOMEDICAL CO. LTD. ACRO BI 30 NaN 2 19 10 39 38 -2330.99000 NaN 427.91700 -103.69400 50.70450 -8359.230000 -17288.000000 NaN NaN 17 -9 29 -1
0000013573 BOWL AMERICA INC BOWL AM 1 4 3 1 5 NaN NaN 253.60800 242.04000 293.64900 282.76200 182.60100 NaN NaN 3 -1 -2 4 NaN NaN
0000277058 NEVADA GOLD & CASINOS INC NEVADA 9 9 10 NaN NaN NaN NaN 127.46000 135.84200 161.49600 NaN NaN NaN NaN 0 1 NaN NaN NaN NaN
0000701374 Six Flags Entertainment Corp Six Fla 14 15 13 12 23 NaN NaN 41.46520 54.35550 46.58830 20.54820 -97.43060 NaN NaN 1 -2 -1 11 NaN NaN
0000831489 SCORES HOLDING CO INC SCORES 22 26 NaN NaN NaN NaN NaN -465.09300 -779.81000 NaN NaN NaN NaN NaN 4 NaN NaN NaN NaN NaN
0000914577 TRANS WORLD CORP TRANS W 4 6 NaN NaN NaN NaN NaN 191.17600 229.30700 NaN NaN NaN NaN NaN 2 NaN NaN NaN NaN NaN
0001001039 TWDC Enterprises 18 Corp. TWDC En 2 2 4 NaN NaN NaN NaN 252.54100 254.10700 292.21800 NaN NaN NaN NaN 0 2 NaN NaN NaN NaN
0001017673 DOVER MOTORSPORTS LLC DOVER M 6 5 7 5 2 NaN NaN 162.27200 234.97100 247.08300 217.21200 239.79500 NaN NaN -1 2 -2 -3 NaN NaN
0001265848 US VR Global.com Inc. US VR G 23 24 NaN NaN NaN NaN NaN -664.36100 -706.68200 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001281774 TOWN SPORTS INTERNATIONAL HOLDINGS INC TOWN SP 18 21 NaN NaN NaN NaN NaN -25.86970 -27.17280 NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN
0001532158 Rebel Group Inc. Rebel G 25 10 27 28 NaN NaN NaN -871.63400 123.42000 -3682.78000 -2551.55000 NaN NaN NaN -15 17 1 NaN NaN NaN
0001570279 Double Down Holdings Inc. Double 24 23 21 20 NaN NaN NaN -856.65200 -689.33400 -410.10100 -262.67500 NaN NaN NaN -1 -2 -1 NaN NaN NaN
0001318482 KIDOZ INC. KIDOZ I NaN 28 26 26 6 7 NaN NaN -1376.80000 -2732.79000 -1082.13000 180.16200 123.394000 NaN NaN -2 0 -20 1 NaN
0001592411 DKG Capital Inc. DKG Cap NaN 1 1 NaN NaN NaN NaN NaN 568.25700 491.78600 NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN
0001572384 Phoenix Rising Companies Phoenix NaN NaN NaN 6 34 NaN NaN NaN NaN NaN 214.91300 -889.17800 NaN NaN NaN NaN NaN 28 NaN NaN
0001708341 Allied Gaming & Entertainment Inc. Allied NaN NaN NaN 17 NaN 1 NaN NaN NaN NaN -47.37490 NaN 773.719000 NaN NaN NaN NaN NaN NaN NaN
0001379043 XTREME FIGHTING CHAMPIONSHIPS INC. XTREME NaN NaN NaN NaN 33 23 NaN NaN NaN NaN NaN -817.31100 -3.530360 NaN NaN NaN NaN NaN -10 NaN
0001772757 DraftKings Holdings Inc. DraftKi NaN NaN NaN NaN 14 30 NaN NaN NaN NaN NaN -7.29962 -168.652000 NaN NaN NaN NaN NaN 16 NaN

PDF reports

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

2016

Logs

error 3 × Unusually strong effect check_effects
{'var_name': 'NetIncome', 'quantile_value': '-12.7', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-12.2', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-13.9', 'quantile': 0.05}
error 2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001318482 0000811532
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001584693
warning 2 × Similarly named company. Duplicate? None
0001451448 0001564902
warning 2 × Missing logo subcommand.report
0001570279 0000914577
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '30 of 30'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -16.88589358377347}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001451448
warning 1 × Ignoring company because Assets is zero pre-agg
0001592411

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 2,533 4,687 11,669,593 2,192,186,900 16,966,000,000 0001622996 0000277058 0001001039
1 PropertyPlantAndEquipment 0 0 12,525,822 1,530,464,550 27,349,000,000 0000013156 0000277058 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001281774 0000013156
3 AssetsNonCurrent 0 0 0 6,805,359 4,280,000,000 0000013156 0001265848 0001001039
4 IntangibleAssets 0 0 626,269 3,257,003,550 34,759,000,000 0000013156 0001281774 0001001039
5 remainder_Assets 0 0 3,471,448 937,615,200 8,679,000,000 0000831489 0000277058 0001001039
6 LiabilitiesCurrent 0 13,189 6,724,974 2,182,089,200 16,842,000,000 0001444839 0001418372 0001001039
7 LiabilitiesNonCurrent 0 0 0 10,801,600 53,317,000 0000013573 0001265848 0001335258
8 remainder_Liabilities -53,317,000 -8,453,500 2,132,013 1,774,058,500 3,317,000,000 0001335258 0000013573 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 1,338,547,500 8,754,000,000 0000013573 0000831489 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 14,657,249 24,702,000 0000013156 0000914577 0001281774
11 CostOfGoodsAndServicesSold 0 0 0 80,177,200 1,707,000,000 0000013573 0001636519 0001319161
12 DepreciationAndAmortization 0 0 1,030,953 331,358,050 2,527,000,000 0000013573 0000013156 0001001039
13 OperatingExpenses 0 0 0 85,167,350 736,842,000 0000013156 0001017673 0001564902
14 remainder_Expenses -6,643,000 -40,982 3,633,700 4,069,769,350 35,227,000,000 0000015847 0001308569 0001001039
15 remainder_Revenues 0 0 42,997,404 6,055,913,700 55,632,000,000 0001265848 0000015847 0001001039
16 remainder_NetIncome -178,000,000 -72,679,800 -31,060 21,689,600 666,000,000 0001319161 0001570279 0001001039
17 remainder_ComprehensiveNetIncome -1,957,000,000 -68,272,750 0 453,284 3,663,000 0001001039 0001444839 0000812011
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,533 4,687 45,058,546 6,136,396,300 92,033,000,000 0001622996 0001418372 0001001039
1 Liabilities 9,805 40,488 15,568,747 3,944,604,800 16,842,000,000 0001445831 0000015847 0001001039
2 Expenses 29,482 36,772 41,563,016 5,931,272,750 46,508,000,000 0001445831 0001017673 0001001039
3 Revenues 0 0 42,997,404 6,055,913,700 55,632,000,000 0001265848 0000015847 0001001039
4 StockholdersEquity -214,755,000 -97,837,650 12,123,370 3,531,046,550 75,191,000,000 0001637207 0001674227 0001001039
5 NetIncome -249,479,000 -48,148,450 57,184 153,454,150 9,790,000,000 0001318568 0001090396 0001001039
6 ComprehensiveNetIncome -251,906,000 -75,018,700 -37,342 137,168,550 7,833,000,000 0001318568 0001265848 0001001039
7 BaseVar 81,857 114,009 238,731,186 34,570,323,542 310,059,220,000 0001445831 0000015847 0001001039
8 EconomicCapitalRatio -23.3 -16.9 0.142 2.40 2.54 0001622996 0001564902 0000013573

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.87 -2.37 -0.135 3.29 5.36 0001622996 0001318568 0001451448
1 PropertyPlantAndEquipment -6.32 -4.03 -0.173 0.646 0.908 0001622996 0001389518 0001564902
2 LeaseAsset 0 0 0 0 0 0000013156 0001281774 0000013156
3 AssetsNonCurrent -1.21 -0.838 -0.0436 -0.000378 30.8 0001622996 0001319161 0001532158
4 IntangibleAssets -5.62 -3.62 -0.108 0.719 3.86 0001622996 0001017673 0001674227
5 remainder_Assets -3.99 -2.60 -0.0979 0.732 1.52 0001622996 0001418372 0001318568
6 LiabilitiesCurrent -1.58 -1.15 0.525 8.18 16.6 0001444839 0001281774 0001265848
7 LiabilitiesNonCurrent -0.550 -0.172 0.00583 0.0301 0.0310 0000015847 0001318568 0000013573
8 remainder_Liabilities -5.93 -3.47 -0.278 0.976 15.3 0001622996 0001017673 0001444839
9 SellingGeneralAndAdministrativeExpense -2.88 -1.44 0.288 0.931 2.85 0001090396 0001265848 0000831489
10 GeneralAndAdministrativeExpense -26.2 -8.32 0.734 1.70 2.05 0000831489 0001318568 0001622996
11 CostOfGoodsAndServicesSold -2.91 -1.29 0.292 0.516 1.39 0000914577 0001532158 0000831489
12 DepreciationAndAmortization -0.489 -0.345 0.0414 0.354 0.956 0001281774 0001674227 0000831489
13 OperatingExpenses -6.78 -2.09 0.346 0.646 1.75 0000015847 0000812011 0000831489
14 remainder_Expenses -14.8 -6.88 -0.0564 4.92 15.3 0001622996 0000701374 0000831489
15 remainder_Revenues -6.79 -5.24 0.677 3.05 8.42 0001622996 0001564902 0000831489
16 remainder_NetIncome -3.67 -0.606 0.188 0.862 0.976 0001308569 0000914577 0000831489
17 remainder_ComprehensiveNetIncome -9.94 0.0185 0.351 0.624 1.69 0001532158 0000812011 0000831489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -13.7 -7.77 -0.00910 1.45 6.20 0001622996 0000013573 0001674227
1 Liabilities -2.03 -1.87 0.341 2.85 9.14 0001451448 0001090396 0001265848
2 Expenses -10.5 -6.30 0.629 1.20 5.65 0001622996 0001090396 0001532158
3 Revenues -6.79 -5.24 0.677 3.05 8.42 0001622996 0001564902 0000831489
4 StockholdersEquity -3.02 -2.71 0.178 1.43 2.36 0001570279 0001090396 0001674227
5 NetIncome -16.9 -12.7 1.94 3.74 5.51 0001622996 0000013156 0000831489
6 ComprehensiveNetIncome -16.3 -12.2 1.78 4.24 7.20 0001622996 0000701374 0000831489
7 BaseVar nan nan nan nan nan 0000013156 0001281774 0000013156
8 EconomicCapitalRatio -20.4 -13.9 3.09 5.35 5.48 0001622996 0001564902 0000013573

2017

Logs

error 3 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '21.5', 'quantile': 0.95}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-10.1', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-10.1', 'quantile': 0.05}
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001584693
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0000811532
warning 2 × Missing logo subcommand.report
0001570279 0000914577
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001308569 0001318568
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '29 of 29'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.616451458330094}
warning 1 × Similarly named company. Duplicate? None
0001297937
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001451448
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001308569

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 5,427 6,784,298 2,471,536,800 15,889,000,000 0001265848 0000013156 0001001039
1 PropertyPlantAndEquipment 0 0 18,909,134 1,698,588,800 28,406,000,000 0000831489 0000013573 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001297937 0000013156
3 AssetsNonCurrent 0 0 0 8,988,210 3,202,000,000 0000013156 0001265848 0001001039
4 IntangibleAssets 0 0 6,355,300 3,258,541,600 38,421,000,000 0000013156 0000015847 0001001039
5 remainder_Assets 0 0 5,676,221 775,715,000 9,871,000,000 0000831489 0001281774 0001001039
6 LiabilitiesCurrent 56,859 120,392 8,809,608 2,986,200,000 19,595,000,000 0001451448 0000914577 0001001039
7 LiabilitiesNonCurrent 0 0 0 23,516,515 347,593,000 0000013573 0001265848 0001335258
8 remainder_Liabilities -347,593,000 -23,038,200 3,348,352 1,919,648,600 3,310,000,000 0001335258 0000015847 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 8,629 1,633,433,800 8,176,000,000 0000013573 0001308569 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 22,340,259 236,799,000 0000013156 0000277058 0000812011
11 CostOfGoodsAndServicesSold 0 0 0 154,200,800 1,931,000,000 0000013573 0000914577 0001319161
12 DepreciationAndAmortization 0 0 1,767,153 353,720,400 2,782,000,000 0000013573 0000013156 0001001039
13 OperatingExpenses 0 0 0 468,840,600 891,135,000 0000013156 0001017673 0000812011
14 remainder_Expenses -151,000,000 -3,362,200 7,639,911 5,128,465,000 34,826,000,000 0001319161 0001308569 0001001039
15 remainder_Revenues 0 0 46,752,856 7,632,868,800 55,137,000,000 0001265848 0001017673 0001001039
16 remainder_NetIncome -230,000,000 -108,567,600 0 19,370,800 281,645,000 0001319161 0001592411 0001637207
17 remainder_ComprehensiveNetIncome -35,907,000 -13,124,640 0 47,425,600 65,000,000 0000701374 0000831489 0001001039
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 781 6,425 47,204,544 6,789,757,800 95,789,000,000 0001265848 0001418372 0001001039
1 Liabilities 87,105 134,692 18,313,458 4,676,800,000 19,595,000,000 0001451448 0000277058 0001001039
2 Expenses 44,830 245,474 43,528,029 7,483,152,800 45,784,000,000 0001265848 0001418372 0001001039
3 Revenues 0 0 46,752,856 7,632,868,800 55,137,000,000 0001265848 0001017673 0001001039
4 StockholdersEquity -140,633,000 -113,345,000 8,159,149 3,758,822,200 76,194,000,000 0001318568 0001674227 0001001039
5 NetIncome -202,386,000 -66,834,600 583,561 280,502,800 9,366,000,000 0001564902 0001090396 0001001039
6 ComprehensiveNetIncome -193,768,000 -58,555,000 583,561 268,870,600 9,431,000,000 0001564902 0001090396 0001001039
7 BaseVar 158,339 1,306,196 258,360,335 42,783,392,164 304,129,560,000 0001265848 0001017673 0001001039
8 EconomicCapitalRatio -23.1 -11.6 0.544 2.52 5.68 0001308569 0000701374 0001592411

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.58 -4.00 -0.0434 2.27 12.8 0001308569 0001335258 0001451448
1 PropertyPlantAndEquipment -7.26 -4.89 -0.118 0.754 1.12 0001308569 0000015847 0001564902
2 LeaseAsset 0 0 0 0 0 0000013156 0001297937 0000013156
3 AssetsNonCurrent -2.88 -2.27 -0.111 0.108 1.56 0000831489 0001637207 0001532158
4 IntangibleAssets -6.05 -4.27 -0.0378 0.697 11.5 0001308569 0000013573 0001674227
5 remainder_Assets -3.14 -2.49 -0.0232 0.578 0.951 0001308569 0001319161 0000013156
6 LiabilitiesCurrent -2.55 -1.63 0.283 21.5 25.6 0000831489 0001637207 0001265848
7 LiabilitiesNonCurrent -0.109 -0.0976 0.00414 0.0172 0.0189 0000013156 0001564902 0001592411
8 remainder_Liabilities -6.02 -2.27 -0.206 1.04 1.46 0001308569 0001532158 0001592411
9 SellingGeneralAndAdministrativeExpense -2.58 -1.90 0.324 1.19 3.83 0001090396 0000015847 0000831489
10 GeneralAndAdministrativeExpense -32.4 -4.25 0.513 1.29 1.47 0000831489 0001637207 0000277058
11 CostOfGoodsAndServicesSold -1.93 -1.44 0.196 0.441 1.35 0001674227 0001297937 0000831489
12 DepreciationAndAmortization -0.498 -0.340 0.0369 0.296 0.953 0001281774 0001532158 0000831489
13 OperatingExpenses -7.34 -1.87 0.372 0.803 2.50 0000015847 0001017673 0000831489
14 remainder_Expenses -11.7 -7.38 0.202 4.93 17.8 0001308569 0001637207 0000831489
15 remainder_Revenues -7.22 -4.33 0.641 2.84 3.29 0001308569 0000831489 0001592411
16 remainder_NetIncome -1.09 -0.768 0.0287 0.808 7.29 0001308569 0001017673 0000831489
17 remainder_ComprehensiveNetIncome -0.389 -0.191 -0.0648 0.218 0.706 0000831489 0001592411 0000914577
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -14.6 -7.22 -0.00684 1.58 2.82 0001308569 0000013573 0001451448
1 Liabilities -3.52 -1.88 0.376 6.78 12.0 0000831489 0001090396 0001265848
2 Expenses -9.18 -6.30 0.640 1.06 2.67 0001308569 0001532158 0001592411
3 Revenues -7.22 -4.33 0.641 2.84 3.29 0001308569 0000831489 0001592411
4 StockholdersEquity -3.87 -3.38 0.156 1.49 1.54 0000831489 0001090396 0001451448
5 NetIncome -17.5 -9.98 1.53 2.99 6.00 0001308569 0000701374 0001592411
6 ComprehensiveNetIncome -17.6 -10.1 1.42 2.87 5.94 0001308569 0000701374 0001592411
7 BaseVar nan nan nan nan nan 0000013156 0001297937 0000013156
8 EconomicCapitalRatio -21.5 -10.1 2.11 4.09 7.25 0001308569 0000701374 0001592411

2018

Logs

error 6 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '-11.2', 'quantile': 0.05}
{'var_name': 'Assets', 'quantile_value': '-10.5', 'quantile': 0.05}
{'var_name': 'Liabilities', 'quantile_value': '-12.4', 'quantile': 0.05}
{'var_name': 'NetIncome', 'quantile_value': '-11.7', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-18.4', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-19.6', 'quantile': 0.05}
warning 2 × Similarly named company. Duplicate? None
0001564902 0001297937
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '27 of 27'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -22.29296271632569}
warning 1 × Missing logo subcommand.report
0001570279
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001071255
warning 1 × Ignoring company because Assets is zero pre-agg
0001389518

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 231 5,483 6,244,329 3,118,352,500 16,825,000,000 0001445831 0001017673 0001001039
1 PropertyPlantAndEquipment 0 0 10,282,595 1,672,588,100 29,540,000,000 0001286459 0000015847 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001318482 0000013156
3 AssetsNonCurrent 0 0 0 1,073,262 2,899,000,000 0000013156 0001286459 0001001039
4 IntangibleAssets 0 0 1,614 3,225,418,200 38,081,000,000 0000013156 0001297937 0001001039
5 remainder_Assets 0 0 5,601,323 981,631,700 11,253,000,000 0001308569 0000013573 0001001039
6 LiabilitiesCurrent 65,935 77,849 6,593,127 3,336,806,200 17,860,000,000 0001445831 0001286459 0001001039
7 LiabilitiesNonCurrent 0 0 0 27,359,814 82,142,000 0000013573 0001297937 0001335258
8 remainder_Liabilities -82,142,000 -26,918,500 1,329,212 1,946,395,000 3,291,000,000 0001335258 0000013573 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 826 1,821,219,600 8,860,000,000 0000013573 0000812011 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 6,672,994 251,806,000 0000013156 0000015847 0000812011
11 CostOfGoodsAndServicesSold 0 0 0 170,667,300 2,171,000,000 0000013573 0001017673 0001319161
12 DepreciationAndAmortization 0 0 14.6 332,370,300 3,011,000,000 0000013573 0001318568 0001001039
13 OperatingExpenses 0 0 0 536,857,200 966,566,000 0000013156 0001090396 0000812011
14 remainder_Expenses 3,000 21,231 2,696,561 6,112,973,500 34,422,000,000 0001445831 0001318482 0001001039
15 remainder_Revenues 0 0 24,828,721 8,752,960,000 59,434,000,000 0001090396 0000013573 0001001039
16 remainder_NetIncome -83,167,000 -71,172,600 -142,325 10,603,200 220,000,000 0001318568 0001297937 0001319161
17 remainder_ComprehensiveNetIncome -67,954,000 -58,201,500 0 108,500 8,454,000 0000812011 0001570279 0001564902
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 231 5,483 28,941,683 7,551,020,200 98,598,000,000 0001445831 0000013573 0001001039
1 Liabilities 65,935 77,849 12,169,086 5,089,759,800 17,860,000,000 0001445831 0000015847 0001001039
2 Expenses 15,567 113,663 21,424,158 8,654,315,500 46,293,000,000 0001445831 0000013573 0001001039
3 Revenues 0 0 24,828,721 8,752,960,000 59,434,000,000 0001090396 0000013573 0001001039
4 StockholdersEquity -382,789,000 -259,346,600 1,248,801 4,364,323,200 80,738,000,000 0001637207 0001622996 0001001039
5 NetIncome -20,914,000 -14,310,776 1,217,978 375,661,900 13,066,000,000 0001071255 0000013156 0001001039
6 ComprehensiveNetIncome -24,445,614 -19,017,474 1,217,978 322,693,200 13,029,000,000 0001532158 0000013156 0001001039
7 BaseVar 71,066 976,844 131,444,909 48,715,711,520 316,476,160,000 0001445831 0000013573 0001001039
8 EconomicCapitalRatio -36.8 -22.3 0.308 3.88 4.92 0001532158 0001564902 0001592411

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 -14.4 -1.17 -0.000187 4.86 16.2 0001532158 0001297937 0001318482
1 PropertyPlantAndEquipment -13.9 -7.30 -0.136 0.876 1.01 0001532158 0000277058 0001564902
2 LeaseAsset 0 0 0 0 0 0000013156 0001318482 0000013156
3 AssetsNonCurrent -1.37 -0.818 -0.0213 0.106 7.21 0001592411 0001308569 0001532158
4 IntangibleAssets -10.9 -5.92 -0.0180 0.770 0.849 0001532158 0001017673 0001318568
5 remainder_Assets -10.1 -5.34 -0.0614 0.724 2.01 0001532158 0000015847 0001286459
6 LiabilitiesCurrent -19.3 -11.2 1.49 6.99 7.63 0001532158 0000812011 0001444839
7 LiabilitiesNonCurrent -0.225 -0.147 0.00241 0.0215 0.107 0001532158 0001637207 0001622996
8 remainder_Liabilities -12.2 -6.63 -0.0467 1.43 4.06 0001532158 0001308569 0001622996
9 SellingGeneralAndAdministrativeExpense -3.93 -2.18 0.218 2.40 4.09 0001090396 0001286459 0001622996
10 GeneralAndAdministrativeExpense -5.68 -3.29 0.388 1.50 4.33 0001532158 0001636519 0001622996
11 CostOfGoodsAndServicesSold -37.1 -1.93 0.342 1.23 1.50 0001622996 0001564902 0001532158
12 DepreciationAndAmortization -0.378 -0.313 0.0484 0.355 1.02 0000013156 0001445831 0001622996
13 OperatingExpenses -7.68 -1.59 0.320 1.16 3.39 0000015847 0001444839 0001622996
14 remainder_Expenses -24.3 -3.30 0.180 5.90 16.1 0001318482 0001318568 0001622996
15 remainder_Revenues -10.5 -6.86 0.892 4.28 19.7 0001532158 0001071255 0001622996
16 remainder_NetIncome -7.11 -5.76 0.608 2.12 6.31 0001532158 0001564902 0001622996
17 remainder_ComprehensiveNetIncome -15.0 0.0283 0.154 0.525 1.52 0001532158 0000013573 0001622996
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -24.8 -10.5 -0.0157 1.20 2.53 0001532158 0000812011 0001090396
1 Liabilities -22.2 -12.4 1.86 5.02 5.95 0001532158 0001335258 0001622996
2 Expenses -17.5 -6.85 0.237 1.77 4.32 0001318482 0001297937 0001532158
3 Revenues -10.5 -6.86 0.892 4.28 19.7 0001532158 0001071255 0001622996
4 StockholdersEquity -2.48 -2.40 1.17 3.61 6.42 0001308569 0000013156 0001622996
5 NetIncome -23.6 -11.7 1.65 5.22 17.8 0001318482 0001636519 0001622996
6 ComprehensiveNetIncome -28.3 -18.4 1.77 5.55 19.3 0001532158 0001636519 0001622996
7 BaseVar nan nan nan nan nan 0000013156 0001318482 0000013156
8 EconomicCapitalRatio -34.1 -19.6 3.05 6.62 7.66 0001532158 0001564902 0001592411

2019

Logs

error 4 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '10.0', 'quantile': 0.95}
{'var_name': 'NetIncome', 'quantile_value': '-12.7', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-12.7', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-12.4', 'quantile': 0.05}
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001286459
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001319161
warning 2 × Similarly named company. Duplicate? None
0001708341 0001297937
warning 2 × Ignoring company because Assets is zero pre-agg
0001379043 0001389518
warning 1 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '28 of 28'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -14.890902220195215}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001286459
warning 1 × Missing logo subcommand.report
0001570279
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001071255

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 78.0 19,647 9,546,614 1,107,569,150 4,192,899,000 0001445831 0001621672 0001335258
1 PropertyPlantAndEquipment 0 0 3,559,977 1,609,887,500 1,842,500,000 0001445831 0001297937 0000812011
2 LeaseAsset 0 0 0 202,689,950 1,402,019,000 0000013573 0000015847 0001335258
3 AssetsNonCurrent 0 0 0 0 0 0000013156 0001318568 0000013156
4 IntangibleAssets 0 0 3,877,940 1,596,036,850 2,868,639,000 0000013573 0001621672 0001335258
5 remainder_Assets 0 0 2,059,411 394,118,250 1,394,126,000 0001445831 0001090396 0001335258
6 LiabilitiesCurrent 22,141 95,550 3,926,654 745,556,150 4,107,599,000 0001570279 0001532158 0001335258
7 LiabilitiesNonCurrent 0 0 0 44,763,650 1,138,871,000 0000013156 0001318482 0001071255
8 remainder_Liabilities -48,516,000 -24,566,750 692,466 2,071,365,600 2,482,547,000 0000812011 0001297937 0000701374
9 SellingGeneralAndAdministrativeExpense 0 0 0 435,232,150 2,145,486,000 0000013573 0000013573 0001335258
10 GeneralAndAdministrativeExpense 0 0 6,909 55,253,700 274,415,000 0000013156 0001445831 0000812011
11 CostOfGoodsAndServicesSold 0 0 4,116 192,907,250 271,999,000 0000013573 0001570279 0001698991
12 DepreciationAndAmortization 0 0 0 197,971,000 443,991,000 0000013573 0000015847 0001335258
13 OperatingExpenses 0 0 0 479,041,450 1,101,670,000 0000013156 0001106213 0000812011
14 remainder_Expenses -73,071 0 12,231,937 986,369,000 8,860,434,000 0001622996 0001318482 0001335258
15 remainder_Revenues 0 735 22,868,229 2,047,397,550 11,547,969,000 0001445831 0000013573 0001335258
16 remainder_NetIncome -87,538,000 -71,682,050 -14,736 14,715,700 32,515,000 0001071255 0001570279 0001636519
17 remainder_ComprehensiveNetIncome -51,833,000 -47,111,000 0 778,864 8,969,000 0000812011 0000013156 0001636519
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 78.0 74,548 19,240,738 4,194,192,900 10,975,615,000 0001445831 0000013156 0001335258
1 Liabilities 83,390 145,314 4,453,851 2,843,840,400 4,107,599,000 0001445831 0000013573 0001335258
2 Expenses 17,608 94,620 21,979,061 1,850,968,500 11,449,911,000 0001445831 0000013573 0001335258
3 Revenues 0 735 22,868,229 2,047,397,550 11,547,969,000 0001445831 0000013573 0001335258
4 StockholdersEquity -707,754,000 -131,130,418 8,667,336 3,356,749,050 6,868,016,000 0001637207 0001297937 0001335258
5 NetIncome -39,545,000 -25,799,905 4,371 190,276,250 323,493,000 0001071255 0001703073 0000812011
6 ComprehensiveNetIncome -39,545,000 -25,799,905 314,729 155,570,850 271,660,000 0001071255 0001572384 0000812011
7 BaseVar 84,698 593,281 133,156,017 12,148,809,299 63,824,694,160 0001445831 0000013156 0001335258
8 EconomicCapitalRatio -25.5 -14.9 0.109 2.61 2.83 0001532158 0001071255 0000013573

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 -9.72 -2.18 -0.0399 1.96 3.37 0001532158 0000812011 0001621672
1 PropertyPlantAndEquipment -7.58 -4.21 -0.141 0.556 0.899 0001532158 0001703073 0001564902
2 LeaseAsset -0.505 -0.276 -0.0185 0.104 0.145 0001621672 0001318568 0001071255
3 AssetsNonCurrent 0 0 0 0 0 0000013156 0001318568 0000013156
4 IntangibleAssets -6.00 -1.21 -0.0145 4.03 7.65 0001532158 0001335258 0001674227
5 remainder_Assets -3.50 -1.93 -0.0451 0.355 0.424 0001532158 0001318568 0001570279
6 LiabilitiesCurrent -6.21 -2.70 0.626 10.0 13.7 0001621672 0001698991 0001584693
7 LiabilitiesNonCurrent -1.44 -0.659 0.0305 0.149 0.296 0001071255 0001708341 0001572384
8 remainder_Liabilities -7.81 -3.82 -0.120 1.19 2.12 0001532158 0001308569 0001572384
9 SellingGeneralAndAdministrativeExpense -3.54 -2.60 0.373 1.80 2.93 0001584693 0001318568 0001572384
10 GeneralAndAdministrativeExpense -7.99 -6.64 0.517 2.13 3.23 0001674227 0001584693 0001572384
11 CostOfGoodsAndServicesSold -15.7 -5.81 0.408 1.20 1.64 0001572384 0000013156 0001532158
12 DepreciationAndAmortization -0.568 -0.284 0.0734 0.290 0.475 0001708341 0001584693 0001572384
13 OperatingExpenses -1.88 -1.22 0.153 0.512 0.838 0000812011 0001703073 0001572384
14 remainder_Expenses -9.26 -5.44 0.382 5.13 7.17 0001318482 0001318568 0001572384
15 remainder_Revenues -7.17 -4.98 0.674 3.23 7.57 0001532158 0000013156 0001572384
16 remainder_NetIncome -11.3 -3.73 0.296 1.12 1.72 0001532158 0001564902 0001572384
17 remainder_ComprehensiveNetIncome -0.0875 -0.0548 0.00892 0.0276 0.105 0000812011 0001318568 0001532158
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -16.0 -3.92 -0.0527 0.964 1.57 0001532158 0001297937 0001570279
1 Liabilities -8.14 -6.76 0.417 5.77 7.18 0001532158 0001698991 0001584693
2 Expenses -6.69 -4.12 0.342 0.985 1.04 0001318482 0001698991 0001637207
3 Revenues -7.17 -4.98 0.674 3.23 7.57 0001532158 0000013156 0001572384
4 StockholdersEquity -2.59 -2.44 0.852 2.26 2.57 0001445831 0001090396 0001621672
5 NetIncome -18.2 -12.7 1.66 4.44 8.24 0001532158 0001636519 0001572384
6 ComprehensiveNetIncome -18.1 -12.7 1.64 4.46 8.25 0001532158 0001636519 0001572384
7 BaseVar nan nan nan nan nan 0000013156 0001318568 0000013156
8 EconomicCapitalRatio -23.0 -12.4 2.61 5.11 5.32 0001532158 0001071255 0000013573

2020

Logs

error 1 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '11.6', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -0.47003209846328964}
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000013573 0001071255 0001744489
warning 2 × Ignoring company because Assets is zero pre-agg
0001445831 0001585149
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -8.930832564719314}
warning 1 × Similarly named company. Duplicate? None
0001297937
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000055234
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000055234

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 44,748 10,851,037 2,558,170,750 35,251,000,000 0001708176 0000013156 0001744489
1 PropertyPlantAndEquipment 0 0 25,547,378 1,899,655,500 32,078,000,000 0001286459 0001418372 0001744489
2 LeaseAsset 0 0 44,417 384,262,750 1,424,223,000 0000015847 0001090396 0001335258
3 AssetsNonCurrent 0 0 0 0 3,903,000,000 0000013156 0001318568 0001744489
4 IntangibleAssets 0 0 6,020,971 3,109,602,250 96,862,000,000 0000013573 0000015847 0001744489
5 remainder_Assets 0 0 3,812,455 840,273,750 33,455,000,000 0000725929 0000015847 0001744489
6 LiabilitiesCurrent 17,126 529,137 16,011,434 3,111,392,250 26,628,000,000 0001803977 0001286459 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,272,690,500 2,450,799,000 0000013156 0001318568 0000812011
8 remainder_Liabilities -53,415,000 0 3,650,509 2,467,857,500 3,572,000,000 0001335258 0001017673 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 1,685,506,500 12,369,000,000 0000013573 0000013573 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 191,509,000 447,374,000 0000013156 0001090396 0001772757
11 CostOfGoodsAndServicesSold 0 0 0 244,961,750 2,333,000,000 0000013573 0000013573 0001319161
12 DepreciationAndAmortization 0 0 315,441 308,435,250 5,345,000,000 0000015847 0001318482 0001744489
13 OperatingExpenses 0 0 0 357,954,750 1,019,437,000 0000013156 0000013573 0000812011
14 remainder_Expenses -97,000 -41,666 19,240,692 923,016,500 50,314,000,000 0001090396 0001319161 0001744489
15 remainder_Revenues 0 7,322 20,091,696 2,588,528,000 65,388,000,000 0001308569 0001418372 0001744489
16 remainder_NetIncome -595,724,000 -123,207,250 -50,435 58,642,000 293,198,000 0000811532 0001379043 0001795250
17 remainder_ComprehensiveNetIncome -2,095,000,000 -42,267,250 0 74,852,750 132,726,000 0001744489 0001106213 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 10,103 152,825 68,104,352 7,454,825,750 201,549,000,000 0001286459 0001017673 0001744489
1 Liabilities 17,126 535,841 40,782,527 4,461,176,750 26,628,000,000 0001803977 0000013156 0001744489
2 Expenses 296,531 529,256 30,871,507 3,962,618,000 68,028,000,000 0001803977 0001017673 0001744489
3 Revenues 0 7,322 20,091,696 2,588,528,000 65,388,000,000 0001308569 0001418372 0001744489
4 StockholdersEquity -705,673,000 -359,289,500 5,217,396 3,854,013,500 174,921,000,000 0001637207 0001674227 0001744489
5 NetIncome -2,474,000,000 -1,342,312,000 -10,848,808 4,305,000 109,055,000 0001744489 0001286459 0000812011
6 ComprehensiveNetIncome -4,569,000,000 -1,329,682,500 -5,531,335 8,267,500 73,726,000 0001744489 0001418372 0000812011
7 BaseVar 907,320 4,140,290 201,720,770 23,120,522,110 445,140,380,000 0001803977 0001017673 0001744489
8 EconomicCapitalRatio -13.9 -8.93 -0.470 2.19 2.60 0001106213 0001637207 0001090396

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.62 -2.44 -0.0367 1.61 3.14 0001106213 0001744489 0001621672
1 PropertyPlantAndEquipment -3.57 -3.15 -0.176 1.67 4.70 0001572384 0001637207 0001803977
2 LeaseAsset -0.664 -0.519 -0.0379 0.143 1.14 0001572384 0001418372 0001636519
3 AssetsNonCurrent -0.0153 -0.0114 -0.00122 -0.000114 0.0137 0001106213 0001418372 0001744489
4 IntangibleAssets -3.33 -2.05 -0.0690 1.37 27.4 0001106213 0001297937 0001379043
5 remainder_Assets -1.62 -1.20 -0.0740 0.399 1.54 0001106213 0001318482 0001708176
6 LiabilitiesCurrent -1.63 -1.35 0.238 11.6 18.9 0001621672 0000812011 0001286459
7 LiabilitiesNonCurrent -1.22 -1.05 0.0455 0.278 0.470 0001637207 0001708176 0001090396
8 remainder_Liabilities -2.85 -1.63 -0.230 0.814 1.53 0001106213 0000015847 0001090396
9 SellingGeneralAndAdministrativeExpense -4.76 -1.92 0.358 1.12 1.37 0001090396 0001308569 0001572384
10 GeneralAndAdministrativeExpense -8.57 -6.58 0.473 1.34 1.80 0001379043 0001318568 0001090396
11 CostOfGoodsAndServicesSold -3.29 -2.45 0.308 0.691 0.800 0001572384 0001335258 0001106213
12 DepreciationAndAmortization -0.602 -0.294 0.0887 0.317 0.377 0001379043 0001318568 0001572384
13 OperatingExpenses -1.10 -0.976 0.165 0.359 0.411 0001418372 0001744489 0001572384
14 remainder_Expenses -9.38 -4.88 0.235 2.72 2.96 0001106213 0001637207 0001090396
15 remainder_Revenues -3.51 -2.54 0.0826 2.23 3.85 0001106213 0000013156 0001090396
16 remainder_NetIncome -5.73 -2.24 0.386 1.03 1.17 0001572384 0001772757 0001090396
17 remainder_ComprehensiveNetIncome -0.547 -0.115 -0.0308 0.151 1.42 0001572384 0001698991 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -7.56 -4.72 -0.0530 1.48 2.73 0001106213 0000013573 0000811532
1 Liabilities -2.65 -2.25 0.0362 5.25 7.24 0001621672 0001319161 0001286459
2 Expenses -6.48 -5.27 0.355 1.41 2.79 0001106213 0001564902 0001572384
3 Revenues -3.51 -2.54 0.0826 2.23 3.85 0001106213 0000013156 0001090396
4 StockholdersEquity -2.91 -2.56 0.230 1.77 1.83 0001286459 0000015847 0000811532
5 NetIncome -8.92 -7.05 0.903 3.10 4.94 0001106213 0001637207 0001090396
6 ComprehensiveNetIncome -8.98 -7.11 0.889 3.06 4.87 0001106213 0001318568 0001090396
7 BaseVar nan nan nan nan nan 0000013156 0001319161 0000013156
8 EconomicCapitalRatio -11.8 -6.82 1.64 4.31 4.72 0001106213 0001637207 0001090396

2021

Logs

error 1 × Median ECR is negative check_abs_values
{'median': -2.8761105322800064e-05}
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000015847 0001071255 0001744489 0001869198
warning 2 × Similarly named company. Duplicate? None
0001802156 0001708341
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -8.894865945818921}
warning 1 × Missing logo subcommand.report
0000055234

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 5,272 29,728,322 4,046,781,600 33,657,000,000 0001708176 0001451448 0001744489
1 PropertyPlantAndEquipment 0 0 964,728 2,168,558,700 32,624,000,000 0000015847 0000725929 0001744489
2 LeaseAsset 0 0 65,872 787,060,000 1,864,528,000 0000015847 0001318482 0001869198
3 AssetsNonCurrent 0 0 0 0 3,935,000,000 0000013156 0001444839 0001744489
4 IntangibleAssets 0 0 10,515,398 4,074,123,800 95,186,000,000 0000055234 0001379043 0001744489
5 remainder_Assets 0 0 12,047,231 899,417,800 38,207,000,000 0001379043 0001793659 0001744489
6 LiabilitiesCurrent 0 98,941 17,975,020 3,706,872,200 31,077,000,000 0001444839 0000015847 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,076,900,700 2,850,292,000 0000013156 0001418372 0000812011
8 remainder_Liabilities -585,254,000 0 5,006,296 3,714,236,200 5,995,282,000 0001335258 0001297937 0001766363
9 SellingGeneralAndAdministrativeExpense 0 0 1,279,612 1,807,695,600 13,517,000,000 0000055234 0001584693 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 129,435,500 828,325,000 0000013156 0001090396 0001772757
11 CostOfGoodsAndServicesSold 0 0 0 524,045,000 2,742,000,000 0000015847 0001308569 0001319161
12 DepreciationAndAmortization 0 0 708,585 296,222,400 5,111,000,000 0000055234 0001297937 0001744489
13 OperatingExpenses 0 0 0 724,463,100 2,597,178,000 0000013156 0000015847 0001766363
14 remainder_Expenses -186,063 0 12,947,706 1,571,660,700 45,810,000,000 0000725929 0001389518 0001744489
15 remainder_Revenues 0 0 20,039,952 5,397,744,700 67,418,000,000 0000055234 0000013156 0001744489
16 remainder_NetIncome -473,000,000 -162,852,500 -219,976 48,793,122 90,242,000 0001744489 0001318482 0001335258
17 remainder_ComprehensiveNetIncome -47,046,000 -4,334,000 0 58,528,800 1,370,000,000 0001772757 0001444839 0001744489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 133 176,322 120,420,214 11,731,297,100 203,609,000,000 0001444839 0001451448 0001744489
1 Liabilities 117,370 1,127,901 60,695,854 7,358,819,100 31,077,000,000 0001622996 0000015847 0001744489
2 Expenses 5,635 356,285 38,730,959 5,600,027,600 64,438,000,000 0000055234 0001451448 0001744489
3 Revenues 0 0 20,039,952 5,397,744,700 67,418,000,000 0000055234 0000013156 0001744489
4 StockholdersEquity -642,845,000 -50,711,000 25,185,154 3,092,480,700 172,532,000,000 0001637207 0001418372 0001744489
5 NetIncome -1,523,195,000 -582,310,700 -419,477 261,261,700 2,507,000,000 0001772757 0001444839 0001744489
6 ComprehensiveNetIncome -1,570,241,000 -583,425,400 -419,477 263,261,700 3,877,000,000 0001772757 0001444839 0001744489
7 BaseVar 2,169,657 3,571,429 311,271,923 37,008,875,004 443,568,560,000 0001444839 0001708341 0001744489
8 EconomicCapitalRatio -83.6 -8.89 0.000366 2.46 7.74 0001622996 0000055234 0001708341

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 -53.5 -7.38 -0.110 0.514 4.67 0001622996 0001636519 0001829966
1 PropertyPlantAndEquipment -54.1 -2.70 -0.177 0.905 1.60 0001622996 0001637207 0001708176
2 LeaseAsset -25.5 -1.30 -0.0466 0.533 2.05 0001622996 0001318568 0000725929
3 AssetsNonCurrent -0.556 -0.0200 -0.000956 0.000533 0.00893 0001622996 0000015847 0001744489
4 IntangibleAssets -61.8 -4.60 -0.0793 3.18 6.67 0001622996 0001636519 0001379043
5 remainder_Assets -60.5 -4.44 -0.219 1.21 2.24 0001622996 0001802156 0001445831
6 LiabilitiesCurrent -62.4 -1.81 0.229 1.62 6.43 0001622996 0001802156 0001584693
7 LiabilitiesNonCurrent -27.5 -1.57 0.0524 0.322 0.491 0001622996 0001636519 0001708341
8 remainder_Liabilities -63.0 -2.91 0.0412 1.70 11.9 0001622996 0001772757 0001444839
9 SellingGeneralAndAdministrativeExpense -20.7 -2.19 0.157 1.18 2.49 0001622996 0001445831 0001803977
10 GeneralAndAdministrativeExpense -3.84 -3.26 0.368 1.76 7.40 0001674227 0001318568 0001622996
11 CostOfGoodsAndServicesSold -7.09 -4.20 0.238 0.655 0.708 0001803977 0000725929 0001674227
12 DepreciationAndAmortization -1.43 -0.186 0.0318 0.565 2.37 0001379043 0001319161 0001622996
13 OperatingExpenses -2.20 -1.14 0.193 0.748 3.14 0000811532 0001444839 0001622996
14 remainder_Expenses -42.8 -3.58 0.211 1.67 3.28 0001622996 0001637207 0001793659
15 remainder_Revenues -15.4 -2.62 0.318 2.93 3.29 0001622996 0001802156 0001793659
16 remainder_NetIncome -5.73 -2.21 0.0301 0.952 6.91 0001389518 0001766363 0001708341
17 remainder_ComprehensiveNetIncome -0.214 -0.0625 -0.0134 0.0649 0.932 0001622996 0001584693 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -77.3 -7.69 -0.136 1.57 1.87 0001622996 0000811532 0001708176
1 Liabilities -71.3 -3.59 0.197 2.42 4.14 0001622996 0001451448 0001708341
2 Expenses -54.7 -4.29 0.173 0.785 2.46 0001622996 0001802156 0001708341
3 Revenues -15.4 -2.62 0.318 2.93 3.29 0001622996 0001802156 0001793659
4 StockholdersEquity -3.23 -2.98 0.205 1.73 2.04 0001622996 0000812011 0001621672
5 NetIncome -68.9 -7.48 0.666 2.58 7.04 0001622996 0001636519 0001708341
6 ComprehensiveNetIncome -69.1 -7.48 0.664 3.11 7.02 0001622996 0001636519 0001708341
7 BaseVar nan nan nan nan nan 0000013156 0001451448 0000013156
8 EconomicCapitalRatio -80.5 -5.81 3.09 5.55 10.8 0001622996 0000055234 0001708341

2022

Logs

error 2 × Unusually strong effect check_effects
{'var_name': 'NetIncome', 'quantile_value': '-10.2', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-10.2', 'quantile': 0.05}
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000015847 0001071255 0001744489 0001869198
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -14.334833968197417}
warning 1 × Similarly named company. Duplicate? None
0001802156
warning 1 × Missing logo subcommand.report
0000055234

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 32,028 10,900,996 3,380,153,900 29,098,000,000 0001708176 0001803977 0001744489
1 PropertyPlantAndEquipment 0 0 218,493 2,906,913,500 33,596,000,000 0000015847 0001703073 0001744489
2 LeaseAsset 0 0 93,613 819,473,950 2,116,761,000 0000015847 0001418372 0001869198
3 AssetsNonCurrent 0 0 0 0 3,218,000,000 0000013156 0001418372 0001744489
4 IntangibleAssets 0 0 14,259,522 4,658,692,000 92,734,000,000 0000055234 0001621672 0001744489
5 remainder_Assets 0 0 9,865,762 1,468,216,750 44,985,000,000 0001106213 0001793659 0001744489
6 LiabilitiesCurrent 0 202,694 27,505,122 4,295,297,250 29,073,000,000 0001444839 0001829966 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,465,133,900 2,734,049,000 0000013156 0000015847 0000812011
8 remainder_Liabilities -620,032,000 0 3,593,847 4,012,757,550 5,408,125,000 0001335258 0001297937 0001766363
9 SellingGeneralAndAdministrativeExpense 0 0 3,048,230 2,448,500,300 16,388,000,000 0000055234 0001090396 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 79,318,150 347,493,000 0000013156 0001319161 0000812011
11 CostOfGoodsAndServicesSold 0 0 0 453,099,550 3,080,000,000 0000015847 0001286459 0001319161
12 DepreciationAndAmortization 0 0 232,711 294,255,150 5,163,000,000 0000055234 0000725929 0001744489
13 OperatingExpenses 0 0 0 911,802,850 2,065,777,000 0000013156 0001335258 0001766363
14 remainder_Expenses -216,471 0 45,132,994 2,812,088,050 56,370,000,000 0001703073 0000015847 0001744489
15 remainder_Revenues 0 0 58,475,041 7,533,338,100 82,722,000,000 0000055234 0001829966 0001744489
16 remainder_NetIncome -1,296,000,000 -110,647,050 -394,795 109,056,950 311,323,000 0001744489 0001445831 0000811532
17 remainder_ComprehensiveNetIncome -145,000,000 -39,994,350 0 24,587,250 1,961,000,000 0001319161 0001621672 0001744489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 73.0 307,698 84,973,165 13,097,391,850 203,631,000,000 0001444839 0000015847 0001744489
1 Liabilities 201,116 1,828,349 64,361,844 8,437,408,250 29,073,000,000 0001622996 0001451448 0001744489
2 Expenses 13,358 532,994 79,929,992 7,034,893,250 77,921,000,000 0000055234 0001829966 0001744489
3 Revenues 0 0 58,475,041 7,533,338,100 82,722,000,000 0000055234 0001829966 0001744489
4 StockholdersEquity -437,664,000 -155,304,600 11,841,009 4,034,215,100 174,558,000,000 0001564902 0001297937 0001744489
5 NetIncome -190,147,000 -107,047,076 -268,804 560,650,400 3,505,000,000 0001795250 0000055234 0001744489
6 ComprehensiveNetIncome -212,478,000 -88,974,205 -268,804 438,400,300 5,466,000,000 0001795250 0000055234 0001744489
7 BaseVar 2,172,267 5,210,836 442,153,899 45,451,787,648 516,268,000,000 0001444839 0001829966 0001744489
8 EconomicCapitalRatio -173 -14.3 0.0721 2.31 4.15 0001622996 0001708176 0000811532

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 -121 -2.88 -0.0936 0.670 1.84 0001622996 0000055234 0001445831
1 PropertyPlantAndEquipment -125 -3.07 -0.195 0.705 1.13 0001622996 0001335258 0001708176
2 LeaseAsset -69.4 -1.04 -0.0440 0.198 0.742 0001622996 0000015847 0001636519
3 AssetsNonCurrent -1.36 -0.0137 -0.000812 0.000293 0.00587 0001622996 0001071255 0001744489
4 IntangibleAssets -129 -2.73 -0.0867 1.63 3.33 0001622996 0000055234 0001674227
5 remainder_Assets -131 -3.45 -0.166 0.472 2.34 0001622996 0001703073 0000055234
6 LiabilitiesCurrent -150 -6.21 0.404 2.62 4.57 0001622996 0001869198 0001106213
7 LiabilitiesNonCurrent -73.9 -1.47 0.0271 0.309 0.399 0001622996 0001708176 0000811532
8 remainder_Liabilities -143 -3.71 -0.100 2.31 18.5 0001622996 0000015847 0001444839
9 SellingGeneralAndAdministrativeExpense -49.0 -3.75 0.280 1.41 2.67 0001622996 0001564902 0001621672
10 GeneralAndAdministrativeExpense -2.89 -2.45 0.265 1.05 8.91 0001451448 0001318568 0001622996
11 CostOfGoodsAndServicesSold -6.54 -3.60 0.255 0.728 3.48 0001793659 0001584693 0001622996
12 DepreciationAndAmortization -0.368 -0.196 0.0430 0.428 2.46 0000811532 0001703073 0001622996
13 OperatingExpenses -2.78 -1.32 0.191 0.911 5.23 0000811532 0001071255 0001622996
14 remainder_Expenses -73.8 -7.42 0.388 3.17 5.45 0001622996 0001637207 0001793659
15 remainder_Revenues -43.7 -3.65 0.515 3.57 7.29 0001622996 0001318568 0001803977
16 remainder_NetIncome -3.95 -1.11 0.112 1.47 3.84 0001389518 0001744489 0001622996
17 remainder_ComprehensiveNetIncome -1.01 -0.144 0.00531 0.0946 1.83 0001829966 0001564902 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -161 -7.42 -0.0917 1.19 2.04 0001622996 0001071255 0001708176
1 Liabilities -158 -4.22 0.138 2.92 5.40 0001622996 0001795250 0001444839
2 Expenses -103 -6.17 0.194 0.863 1.23 0001622996 0001297937 0001286459
3 Revenues -43.7 -3.65 0.515 3.57 7.29 0001622996 0001318568 0001803977
4 StockholdersEquity -2.52 -1.85 0.533 2.21 6.22 0001444839 0001766363 0001622996
5 NetIncome -143 -10.2 1.14 3.91 4.86 0001622996 0001802156 0000811532
6 ComprehensiveNetIncome -143 -10.2 1.13 4.09 4.90 0001622996 0001802156 0000811532
7 BaseVar nan nan nan nan nan 0000013156 0001444839 0000013156
8 EconomicCapitalRatio -166 -7.90 6.50 8.74 10.6 0001622996 0001708176 0000811532

Estimates

Parameter Value Min Max
PresentValueFactor 4.88 1.0 15.0
BalanceFactor 1.32 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 1.89 0.2 10.0