QA: us_hotels 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
0001712189 Target Hospitality Corp. Target NaN NaN NaN 1 3 3 1 NaN NaN NaN 213.285000 125.01700 181.996000 263.46100 NaN NaN NaN 2 0 -2
0000906553 BOYD GAMING CORP BOYD GA NaN 3 4 4 4 2 2 NaN 168.16000 145.47600 149.246000 102.14500 202.397000 229.99600 NaN 1 0 0 -2 0
0000907242 MONARCH CASINO & RESORT INC MONARCH 1 2 6 10 7 5 3 176.83900 173.34100 138.03300 99.063600 83.61610 156.449000 214.37700 1 4 4 -3 -2 -2
0000216877 PISMO COAST VILLAGE INC PISMO C NaN NaN 1 3 2 1 4 NaN NaN 199.47300 179.724000 142.32000 207.765000 189.85800 NaN NaN 2 -1 -1 3
0000789570 MGM Resorts International MGM Res NaN 1 7 2 5 4 5 NaN 188.79700 136.41100 185.748000 99.31360 156.596000 155.35800 NaN 6 -5 3 -1 1
0001048286 MARRIOTT INTERNATIONAL INC MD MARRIOT 3 4 5 5 6 6 6 113.91700 160.12100 143.60800 132.846000 89.26340 120.285000 151.44000 1 1 0 1 0 0
0001046311 CHOICE HOTELS INTERNATIONAL INC DE CHOICE 11 17 11 11 8 7 7 58.89270 52.55270 92.14520 92.863500 27.57580 105.264000 101.84500 6 -6 0 -3 -1 0
0001295810 Sunstone Hotel Investors Inc. Sunston 6 9 2 8 22 8 8 102.83500 108.49100 192.41900 105.542000 -45.77620 95.205200 100.75400 3 -7 6 14 -14 0
0001061937 HOST HOTELS & RESORTS L.P. HOST HO 2 11 3 6 12 11 9 126.54800 107.03600 145.67700 126.911000 2.96516 52.075000 99.09500 9 -8 3 6 -1 -2
0001722684 WYNDHAM HOTELS & RESORTS INC. WYNDHAM NaN NaN NaN NaN NaN 10 10 NaN NaN NaN NaN NaN 65.706800 85.15380 NaN NaN NaN NaN NaN 0
0001300514 LAS VEGAS SANDS CORP LAS VEG 7 5 10 9 20 27 11 89.58820 135.48000 98.01960 104.444000 -37.48770 -22.759500 66.94000 -2 5 -1 11 7 -16
0001313536 SOTHERLY HOTELS LP SOTHERL 20 26 22 20 24 28 12 17.70100 18.99360 12.48560 18.541900 -62.84490 -36.411000 62.31320 6 -4 -2 4 4 -16
0001616000 Xenia Hotels & Resorts Inc. Xenia H NaN 12 9 12 11 20 13 NaN 79.18910 111.57700 63.974600 5.47150 11.261100 60.36760 NaN -3 3 -1 9 -7
0001674168 Hilton Grand Vacations Inc. Hilton NaN 10 12 13 18 16 14 NaN 108.27800 90.05810 60.350000 -30.84020 35.445100 55.84630 NaN 2 1 5 -2 -2
0001617406 Park Hotels & Resorts Inc. Park Ho NaN NaN NaN NaN 23 22 15 NaN NaN NaN NaN -60.47010 7.144330 53.85260 NaN NaN NaN NaN -1 -7
0001468174 Hyatt Hotels Corp Hyatt H 9 13 8 7 16 21 16 65.15960 77.77700 129.51300 114.200000 -22.43370 9.114420 51.57730 4 -5 -1 9 5 -5
0001692412 Playa Hotels & Resorts N.V. Playa H NaN 24 18 19 25 24 17 NaN 30.27270 42.30610 24.665500 -64.24150 0.308428 51.08210 NaN -6 1 6 -1 -7
0001585689 Hilton Worldwide Holdings Inc. Hilton 18 NaN NaN NaN 21 19 18 21.64370 NaN NaN NaN -41.38270 14.442500 43.62800 NaN NaN NaN NaN -2 -1
0001653653 Red Rock Resorts Inc. Red Roc 15 25 NaN 21 13 12 19 32.15260 20.03180 NaN 14.543200 -12.88160 46.934400 36.98980 10 NaN NaN -8 -1 7
0001590584 Civeo Corp Civeo C 23 30 25 24 26 13 20 -29.65570 -11.32130 -47.11140 8.536460 -78.09060 40.146800 26.10860 7 -5 -1 2 -13 7
0000921738 PENN Entertainment Inc. PENN En 22 18 23 23 14 17 21 4.67776 52.15930 10.22790 12.134100 -14.97760 34.710400 20.75910 -4 5 0 -9 3 4
0001361658 Travel & Leisure Co. Travel 14 15 16 17 17 18 22 41.09410 63.96340 44.90360 33.683000 -24.63090 14.935700 17.43600 1 1 1 0 1 4
0000911147 CENTURY CASINOS INC CO CENTURY 4 8 14 NaN NaN 14 23 104.87400 116.79900 56.69980 NaN NaN 36.728100 13.36370 4 6 NaN NaN NaN 9
0000891482 FULL HOUSE RESORTS INC FULL HO NaN 28 NaN 25 9 15 24 NaN 5.71704 NaN 3.664590 22.92120 36.196100 -2.60345 NaN NaN NaN -16 6 9
0001590895 Caesars Entertainment Inc. Caesars 16 22 21 18 15 26 25 31.76970 36.60170 24.28820 25.464700 -19.06350 -7.452440 -7.00949 6 -1 -3 -3 11 -1
0001005276 MOHEGAN TRIBAL GAMING AUTHORITY MOHEGAN NaN 23 17 26 19 25 26 NaN 31.03660 44.88520 -0.764881 -35.12320 -2.543960 -7.07744 NaN -6 9 -7 6 1
0001174922 WYNN RESORTS LTD WYNN RE 21 20 19 22 27 29 27 13.64420 42.50380 38.54310 14.121700 -88.93380 -38.924800 -26.18440 -1 -1 3 5 2 -2
0001747079 Bally's Corp Bally's NaN NaN NaN 14 10 23 28 NaN NaN NaN 51.015300 11.25170 6.369830 -59.25700 NaN NaN NaN -4 13 5
0001819395 Sonder Holdings Inc. Sonder NaN NaN NaN NaN NaN 9 29 NaN NaN NaN NaN NaN 91.295000 -60.34980 NaN NaN NaN NaN NaN 20
0000844887 DIAMONDHEAD CASINO CORP DIAMOND 25 31 26 NaN 28 30 30 -129.35800 -134.40200 -63.09380 NaN -195.96300 -153.687000 -170.58700 6 -5 NaN NaN 2 0
0000858339 CAESARS HOLDINGS INC. CAESARS 26 NaN NaN 27 NaN NaN NaN -141.20800 NaN NaN -23.227100 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000918543 CASTLE GROUP INC CASTLE 17 27 NaN NaN NaN NaN NaN 26.96060 16.27080 NaN NaN NaN NaN NaN 10 NaN NaN NaN NaN NaN
0001115836 Belmond Ltd. Belmond 12 21 24 NaN NaN NaN NaN 54.46400 41.81230 6.13087 NaN NaN NaN NaN 9 3 NaN NaN NaN NaN
0001162556 DOVER DOWNS GAMING & ENTERTAINMENT INC DOVER D 8 14 13 NaN NaN NaN NaN 77.13230 73.58070 79.87670 NaN NaN NaN NaN 6 -1 NaN NaN NaN NaN
0001476246 Tropicana Entertainment Inc. Tropica 5 6 NaN NaN NaN NaN NaN 104.84500 129.96200 NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN
0001517401 Peak Resorts Inc Peak Re 10 7 20 15 NaN NaN NaN 64.69910 120.29400 27.05550 39.021500 NaN NaN NaN -3 13 -5 NaN NaN NaN
0001581164 Extended Stay America Inc. Extende 13 19 15 16 1 NaN NaN 41.09880 43.99340 49.53440 36.484000 176.53400 NaN NaN 6 -4 1 -15 NaN NaN
0001594617 La Quinta Holdings Inc. La Quin 19 16 NaN NaN NaN NaN NaN 18.68090 60.30890 NaN NaN NaN NaN NaN -3 NaN NaN NaN NaN NaN
0001656239 Pinnacle Entertainment Inc. Pinnacl 24 29 NaN NaN NaN NaN NaN -69.48620 3.31992 NaN NaN NaN NaN NaN 5 NaN NaN NaN NaN NaN
0001723177 Syndicated Resorts Association Inc. Syndica NaN NaN 27 28 NaN NaN NaN NaN NaN -4923.50000 -7563.130000 NaN NaN NaN NaN NaN 1 NaN NaN NaN

PDF reports

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

2016

Logs

error 2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001005276 0001052595
warning 4 × Similarly named company. Duplicate? None
0001468174 0001590895 0001313536 0001517401
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -1.1439009037108603}
warning 1 × Missing logo subcommand.report
0000844887
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000789570

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 PropertyPlantAndEquipment 0 5,524,919 1,839,987,500 9,841,250,000 15,903,000,000 0000844887 0001048286 0001300514
1 AssetsNonCurrent 0 0 11,801,320 2,326,577,250 22,654,000,000 0000844887 0001115836 0001585689
2 AssetsCurrent 17,958 11,031,017 252,843,940 3,510,500,000 4,988,000,000 0000844887 0001656239 0000858339
3 IntangibleAssets 0 0 98,842,392 5,641,000,000 16,868,000,000 0000844887 0001300514 0001048286
4 remainder_Assets -15,771,000,000 -1,975,339,250 26,889,640 1,039,500,000 4,677,000,000 0001585689 0001517401 0001361658
5 LongTermLiabilities 0 0 0 0 282,708,289 0000844887 0001162556 0001313536
6 LiabilitiesCurrent 0 0 154,240,905 4,561,750,000 7,748,000,000 0000844887 0001594617 0000858339
7 remainder_Liabilities 0 1,974,250 896,867,490 10,251,281,250 17,678,000,000 0001048286 0001046311 0001585689
8 GeneralAndAdministrativeExpense 0 1,627,458 165,836,800 1,254,500,000 1,543,000,000 0000918543 0001590895 0001361658
9 DepreciationDepletionAndAmortization 0 0 139,230,948 714,500,000 1,111,000,000 0000844887 0001594617 0001300514
10 CostOfGoodsAndServicesSold 0 0 0 6,707,250 26,921,000 0000844887 0001162556 0001590895
11 OperatingExpenses 0 0 0 875,419,500 2,511,000,000 0000844887 0000918543 0001361658
12 remainder_Expenses -305,480,000 -179,008,065 614,423,795 9,249,000,000 15,638,000,000 0001594617 0001653653 0001048286
13 remainder_Revenues 0 0 965,651,532 11,599,750,000 17,072,000,000 0000844887 0001594617 0001048286
14 remainder_NetIncome -2,378,000,000 -369,565,500 -486,113 262,604,000 1,207,469,000 0000858339 0000844887 0001295810
15 remainder_ComprehensiveNetIncome -824,000,000 -374,500,000 -256,325 2,333,250 16,000,000 0000858339 0000921738 0001061937
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,601,317 52,439,998 3,210,923,080 23,222,250,000 26,211,000,000 0000844887 0001653653 0001585689
1 Liabilities 9,057,686 21,904,526 1,723,612,210 15,477,250,000 20,362,000,000 0000844887 0001594617 0001585689
2 Expenses 775,349 41,727,874 998,788,272 10,824,250,000 16,342,000,000 0000844887 0001295810 0001048286
3 Revenues 0 0 965,651,532 11,599,750,000 17,072,000,000 0000844887 0001594617 0001048286
4 StockholdersEquity -1,418,000,000 -500,710,000 387,664,347 7,421,500,000 18,993,000,000 0000858339 0001590584 0001048286
5 NetIncome -2,747,000,000 -367,079,500 40,006,278 777,750,000 2,016,000,000 0000858339 0001476246 0001300514
6 ComprehensiveNetIncome -3,571,000,000 -366,408,750 34,219,855 733,250,000 1,617,000,000 0000858339 0001476246 0001300514
7 BaseVar 10,808,577 319,933,656 8,863,084,924 88,427,225,000 113,912,600,000 0000844887 0001295810 0001048286
8 EconomicCapitalRatio -1.41 -1.14 0.411 1.23 1.77 0000858339 0001581164 0000907242

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 PropertyPlantAndEquipment -0.533 -0.277 -0.0219 0.435 0.497 0000918543 0000911147 0001581164
1 AssetsNonCurrent -0.180 -0.106 -0.0380 0.726 1.14 0000918543 0001174922 0001594617
2 AssetsCurrent -0.117 -0.0704 -0.00761 0.103 0.320 0001656239 0001468174 0000858339
3 IntangibleAssets -0.187 -0.0845 -0.0130 0.203 0.284 0000918543 0001061937 0001048286
4 remainder_Assets -0.457 -0.300 -0.0263 0.870 1.55 0001594617 0001468174 0000844887
5 LongTermLiabilities -0.970 0.000742 0.0338 0.0969 0.104 0001313536 0001361658 0000907242
6 LiabilitiesCurrent -0.478 -0.113 0.0250 0.182 0.323 0001517401 0001656239 0000918543
7 remainder_Liabilities -0.375 -0.344 0.0857 0.976 1.11 0001174922 0001590584 0000907242
8 GeneralAndAdministrativeExpense -0.982 -0.852 0.0516 0.892 1.64 0000907242 0001590584 0000918543
9 DepreciationDepletionAndAmortization -0.854 -0.231 -0.0158 0.588 0.823 0001590584 0001174922 0000918543
10 CostOfGoodsAndServicesSold -0.334 -0.0902 0.0124 0.0295 0.0413 0000911147 0001361658 0000918543
11 OperatingExpenses -3.47 -1.69 0.362 0.849 1.51 0001590895 0001313536 0000918543
12 remainder_Expenses -6.76 -3.55 -0.283 1.95 3.61 0000918543 0001295810 0001590895
13 remainder_Revenues -8.99 -4.39 0.306 1.71 2.67 0000918543 0001653653 0001162556
14 remainder_NetIncome -1.11 -0.756 -0.320 5.61 11.9 0000858339 0001656239 0000918543
15 remainder_ComprehensiveNetIncome -0.273 -0.111 0.0345 0.103 0.165 0000858339 0001313536 0000918543
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.682 -0.282 0.00704 0.249 0.606 0000918543 0001061937 0000844887
1 Liabilities -0.360 -0.205 0.0996 0.980 1.20 0001174922 0001590584 0000907242
2 Expenses -2.74 -1.65 -0.000719 0.466 0.666 0000918543 0001361658 0000858339
3 Revenues -8.99 -4.39 0.306 1.71 2.67 0000918543 0001653653 0001162556
4 StockholdersEquity -0.644 -0.529 0.0310 0.526 0.537 0000918543 0001300514 0001295810
5 NetIncome -1.03 -0.916 0.182 0.800 0.829 0000858339 0001115836 0000907242
6 ComprehensiveNetIncome -1.30 -0.882 0.196 0.842 0.922 0000858339 0001590895 0000907242
7 BaseVar nan nan nan nan nan 0000844887 0001174922 0000844887
8 EconomicCapitalRatio -1.80 -1.54 0.0188 0.842 1.38 0000858339 0001581164 0000907242

2017

Logs

error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001052595
warning 3 × Similarly named company. Duplicate? None
0001590895 0001656239 0001476246
warning 1 × Missing logo subcommand.report
0000844887
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001692412
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001594617
warning 1 × Ignoring company because Expenses is zero pre-agg
0001617406

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 PropertyPlantAndEquipment 0 3,015,362 1,466,435,473 12,604,000,000 19,635,459,000 0000844887 0001692412 0000789570
1 AssetsNonCurrent 0 0 22,338,486 2,053,671,500 7,149,092,000 0000844887 0001295810 0000789570
2 AssetsCurrent 435 16,218,184 251,079,388 3,085,500,000 3,423,784,000 0000844887 0001590895 0001174922
3 IntangibleAssets 0 0 89,018,441 3,714,206,500 18,012,000,000 0000844887 0001300514 0001048286
4 remainder_Assets -5,684,491,000 -1,414,392,500 98,852,806 1,031,500,000 4,642,000,000 0000789570 0001476246 0001361658
5 LongTermLiabilities 0 0 0 389,659,408 898,215,000 0000789570 0001115836 0001692412
6 LiabilitiesCurrent 0 0 134,655,870 3,020,191,000 6,010,000,000 0000918543 0001115836 0001048286
7 remainder_Liabilities 0 0 845,775,589 8,327,049,500 10,104,000,000 0000789570 0001046311 0001300514
8 GeneralAndAdministrativeExpense 0 2,920,630 145,104,981 1,418,000,000 1,559,915,000 0000918543 0001476246 0000789570
9 DepreciationDepletionAndAmortization 0 0 105,952,656 872,240,000 1,171,000,000 0000844887 0001590895 0001300514
10 CostOfGoodsAndServicesSold 0 0 0 191,452,500 603,253,000 0000844887 0001115836 0001616000
11 OperatingExpenses 0 0 0 1,068,759,500 2,194,000,000 0000789570 0000921738 0001361658
12 remainder_Expenses -480,034,000 -222,976,446 631,278,132 6,056,734,000 21,393,000,000 0001590895 0001476246 0001048286
13 remainder_Revenues 0 0 1,008,190,984 11,827,952,000 22,894,000,000 0000844887 0001046311 0001048286
14 remainder_NetIncome -605,748,000 -483,027,000 -475,206 880,857,500 1,245,288,000 0000789570 0000844887 0001295810
15 remainder_ComprehensiveNetIncome -322,000,000 -150,147,500 0 96,500,000 480,000,000 0001300514 0001313536 0001048286
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,476,612 88,681,387 2,953,582,636 22,317,500,000 29,159,178,000 0000844887 0001594617 0000789570
1 Liabilities 9,919,588 24,749,700 1,471,409,334 10,561,694,500 13,052,000,000 0000844887 0001616000 0001300514
2 Expenses 122,469 55,330,184 1,096,702,432 8,804,869,000 22,287,000,000 0000918543 0001295810 0001048286
3 Revenues 0 0 1,008,190,984 11,827,952,000 22,894,000,000 0000844887 0001046311 0001048286
4 StockholdersEquity -320,971,000 -142,624,000 637,475,635 12,786,500,000 26,066,796,000 0001656239 0001653653 0000789570
5 NetIncome -105,254,000 -24,988,000 76,490,197 1,734,209,000 3,261,000,000 0001590584 0001005276 0001300514
6 ComprehensiveNetIncome -70,996,000 -3,118,002 74,047,563 1,896,762,500 2,939,000,000 0001590584 0001590895 0001300514
7 BaseVar 11,249,629 457,468,428 9,466,265,998 78,871,626,010 151,471,440,000 0000844887 0001295810 0001048286
8 EconomicCapitalRatio -1.34 -0.0400 0.603 1.71 1.89 0000844887 0001594617 0000789570

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 PropertyPlantAndEquipment -0.316 -0.304 0.00173 0.308 0.396 0001046311 0000907242 0001581164
1 AssetsNonCurrent -0.0880 -0.0802 -0.0247 0.442 1.02 0000789570 0001616000 0000891482
2 AssetsCurrent -0.118 -0.107 -0.0244 0.0624 0.386 0000891482 0001061937 0000918543
3 IntangibleAssets -0.117 -0.0945 -0.0177 0.0772 0.324 0001048286 0000918543 0001590895
4 remainder_Assets -0.527 -0.214 -0.00808 0.654 1.41 0000891482 0001653653 0000844887
5 LongTermLiabilities -1.03 -0.457 0.0613 0.168 0.216 0001313536 0000921738 0001048286
6 LiabilitiesCurrent -0.166 -0.0177 0.106 0.272 0.298 0000844887 0000921738 0001674168
7 remainder_Liabilities -1.01 -0.434 0.0950 0.950 1.24 0000918543 0001300514 0001048286
8 GeneralAndAdministrativeExpense -1.25 -0.886 0.00634 0.727 1.09 0000891482 0000789570 0001162556
9 DepreciationDepletionAndAmortization -0.866 -0.215 -0.0141 0.495 0.705 0001590584 0001656239 0001162556
10 CostOfGoodsAndServicesSold -1.49 -0.138 0.0749 0.159 0.194 0001616000 0000921738 0001162556
11 OperatingExpenses -2.43 -1.91 0.342 0.679 0.893 0001517401 0001174922 0001048286
12 remainder_Expenses -4.41 -3.12 -0.305 1.85 2.40 0001162556 0001295810 0001590895
13 remainder_Revenues -4.80 -3.47 0.545 2.20 2.84 0000907242 0001174922 0001162556
14 remainder_NetIncome -0.897 -0.876 -0.429 3.97 6.20 0001005276 0001300514 0000907242
15 remainder_ComprehensiveNetIncome -0.155 -0.104 -0.0106 0.189 0.312 0001581164 0001295810 0001590584
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.458 -0.333 -0.0133 0.283 0.794 0000891482 0001300514 0000918543
1 Liabilities -0.871 -0.238 0.162 1.14 1.37 0000918543 0001046311 0001048286
2 Expenses -2.41 -1.51 -0.0845 0.467 0.694 0001162556 0001313536 0000918543
3 Revenues -4.80 -3.47 0.545 2.20 2.84 0000907242 0001174922 0001162556
4 StockholdersEquity -0.641 -0.472 0.000655 0.767 0.829 0001046311 0001594617 0000789570
5 NetIncome -1.20 -0.718 0.106 0.655 0.955 0001590584 0001476246 0001300514
6 ComprehensiveNetIncome -0.980 -0.693 0.106 0.613 0.829 0000844887 0001468174 0001300514
7 BaseVar nan nan nan nan nan 0000789570 0001295810 0000789570
8 EconomicCapitalRatio -2.03 -0.724 -0.0810 1.02 1.20 0000844887 0001594617 0000789570

2018

Logs

error 1 × IME and Company effects mismatched for Economic Capital Ratio. IME Effects: 63.1, Company Effect: 63.0 subcommand.report
0001590584
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001052595
warning 15 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000907242 0000911147 0000921738 0001005276 0001048286 0001052595 0001061937 0001162556 0001295810 0001300514 0001468174 0001581164 0001590584 0001590895 0001674168
warning 2 × Missing logo subcommand.report
0001723177 0000844887
warning 2 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001048286 0001295810
warning 2 × Ignoring company because Expenses is zero pre-agg
0001585689 0001617406
warning 1 × Similarly named company. Duplicate? None
0001590895

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 PropertyPlantAndEquipment 0 0 1,396,442,912 13,535,800,000 20,729,888,000 0000844887 0001005276 0000789570
1 AssetsNonCurrent 0 0 2,308,805 1,376,800,000 6,954,040,000 0000216877 0000907242 0000789570
2 AssetsCurrent 1,797 1,348,337 243,897,552 2,686,612,800 5,566,000,000 0001723177 0001046311 0001300514
3 IntangibleAssets 0 0 81,022,773 4,961,685,500 17,419,000,000 0000216877 0001674168 0001048286
4 remainder_Assets -5,765,855,000 0 109,243,692 985,100,000 4,893,000,000 0000789570 0001581164 0001361658
5 LongTermLiabilities 0 0 0 532,248,653 989,387,000 0000216877 0001048286 0001692412
6 LiabilitiesCurrent 0 0 59,515,819 3,094,564,600 6,437,000,000 0001061937 0000907242 0001048286
7 remainder_Liabilities 0 0 862,424,282 9,510,998,400 12,645,000,000 0000789570 0001115836 0001300514
8 GeneralAndAdministrativeExpense 0 2,888 104,031,135 1,063,500,000 1,483,000,000 0000216877 0001061937 0001300514
9 DepreciationDepletionAndAmortization 0 0 81,903,548 825,978,800 1,111,000,000 0000789570 0001005276 0001300514
10 CostOfGoodsAndServicesSold 0 0 0 217,056,737 689,762,000 0000789570 0001048286 0001616000
11 OperatingExpenses 0 0 0 372,924,000 1,642,000,000 0000216877 0001046311 0001361658
12 remainder_Expenses 21,570 1,798,046 686,679,257 9,805,488,400 18,017,000,000 0000844887 0001295810 0001048286
13 remainder_Revenues 0 2,541,011 1,169,829,055 13,139,228,800 20,758,000,000 0000844887 0001295810 0001048286
14 remainder_NetIncome -687,790,000 -509,860,900 0.0780 627,300,000 932,000,000 0000789570 0001162556 0001061937
15 remainder_ComprehensiveNetIncome -592,000,000 -325,464,400 -159,787 704,200 53,000,000 0001300514 0001162556 0001468174
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 1,797 9,597,149 2,754,084,426 23,351,300,000 30,210,706,000 0001723177 0001674168 0000789570
1 Liabilities 13,320 5,370,063 1,317,394,376 11,049,973,300 15,802,000,000 0001723177 0001616000 0001300514
2 Expenses 61,889 2,567,028 1,025,067,141 10,706,723,600 19,170,000,000 0001723177 0001295810 0001048286
3 Revenues 0 2,541,011 1,169,829,055 13,139,228,800 20,758,000,000 0000844887 0001295810 0001048286
4 StockholdersEquity -569,000,000 -130,384,040 640,497,496 14,389,500,000 27,261,824,000 0001361658 0001115836 0000789570
5 NetIncome -81,847,000 -19,958,847 115,091,056 1,680,200,000 2,951,000,000 0001590584 0000906553 0001300514
6 ComprehensiveNetIncome -125,279,000 -47,163,700 112,666,094 1,402,000,000 2,359,000,000 0001590584 0001581164 0001300514
7 BaseVar 189,600 25,409,701 9,764,717,890 90,479,037,012 134,480,480,000 0001723177 0001005276 0001048286
8 EconomicCapitalRatio -49.2 -0.583 0.568 1.78 1.99 0001723177 0000911147 0000216877

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 PropertyPlantAndEquipment -34.0 -0.267 -0.000191 0.322 0.396 0001723177 0000906553 0001692412
1 AssetsNonCurrent -4.21 -0.0314 -0.00579 0.0151 0.0227 0001723177 0001005276 0000789570
2 AssetsCurrent -12.4 -0.0644 -0.00378 0.0372 0.103 0001723177 0001590895 0001674168
3 IntangibleAssets -15.1 -0.0953 -0.00339 0.145 0.242 0001723177 0001468174 0001590895
4 remainder_Assets -17.7 -0.174 -0.0165 0.708 1.04 0001723177 0001616000 0001313536
5 LongTermLiabilities -8.63 -0.863 0.0725 0.187 0.211 0001723177 0001005276 0001048286
6 LiabilitiesCurrent -19.8 -0.938 0.136 0.296 0.374 0001723177 0001313536 0001061937
7 remainder_Liabilities -16.1 -0.721 0.0309 0.800 0.958 0001723177 0001590584 0001048286
8 GeneralAndAdministrativeExpense -4.64 -1.02 0.0962 0.630 0.973 0001723177 0001300514 0001162556
9 DepreciationDepletionAndAmortization -0.719 -0.330 0.0108 0.555 1.38 0001590584 0000907242 0001723177
10 CostOfGoodsAndServicesSold -1.62 -1.35 0.224 0.525 1.25 0001616000 0001005276 0001723177
11 OperatingExpenses -1.94 -1.05 0.217 0.562 1.34 0001517401 0001174922 0001723177
12 remainder_Expenses -28.9 -4.11 -0.0255 1.51 1.53 0001723177 0001005276 0001616000
13 remainder_Revenues -18.2 -0.797 0.154 1.44 2.07 0001723177 0001061937 0001162556
14 remainder_NetIncome -0.470 -0.376 -0.0825 0.620 0.781 0000906553 0000216877 0001295810
15 remainder_ComprehensiveNetIncome -0.291 -0.186 0.0347 0.117 0.274 0001590584 0001616000 0001723177
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -39.2 -0.244 -0.00761 0.215 0.293 0001723177 0001048286 0000844887
1 Liabilities -28.2 -0.802 0.0856 0.987 1.10 0001723177 0001300514 0001048286
2 Expenses -29.6 -1.60 0.140 0.561 0.577 0001723177 0001313536 0001295810
3 Revenues -18.2 -0.797 0.154 1.44 2.07 0001723177 0001061937 0001162556
4 StockholdersEquity -2.88 -0.573 0.0484 0.797 0.842 0001723177 0001468174 0000789570
5 NetIncome -48.2 -0.502 0.349 0.988 1.16 0001723177 0001005276 0001295810
6 ComprehensiveNetIncome -47.9 -0.742 0.271 1.05 1.21 0001723177 0000906553 0001295810
7 BaseVar nan nan nan nan nan 0000216877 0001174922 0000216877
8 EconomicCapitalRatio -48.1 0.519 1.67 2.89 3.10 0001723177 0000911147 0000216877

2019

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001585689
error 1 × IME and Company effects mismatched for Economic Capital Ratio. IME Effects: 389.0, Company Effect: 388.0 subcommand.report
0000789570
warning 17 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000789570 0000858339 0000891482 0000907242 0000921738 0001005276 0001048286 0001061937 0001174922 0001295810 0001300514 0001468174 0001590584 0001590895 0001653653 0001674168 0001747079
warning 2 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001048286 0001295810
warning 2 × Ignoring company because Expenses is zero pre-agg
0000911147 0001617406
warning 1 × Similarly named company. Duplicate? None
0001590895
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001581164
warning 1 × Missing logo subcommand.report
0001723177

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 PropertyPlantAndEquipment 0 5,360,236 1,917,026,968 14,929,800,000 18,285,955,000 0001313536 0001692412 0000789570
1 AssetsNonCurrent 0 0 43,167,390 4,062,400,000 11,582,708,000 0000216877 0001674168 0000789570
2 AssetsCurrent 1,669 10,802,498 314,396,991 3,699,450,450 5,305,000,000 0001723177 0001581164 0001300514
3 IntangibleAssets 0 0 152,692,723 6,512,273,800 17,689,000,000 0000216877 0001712189 0001048286
4 remainder_Assets -5,911,068,000 -8,372,000 177,695,918 927,250,000 5,305,000,000 0000789570 0001005276 0001361658
5 LongTermLiabilities 0 0 0 966,227,700 1,293,054,000 0000216877 0001046311 0001616000
6 LiabilitiesCurrent 0 0 99,966,691 3,212,598,050 6,677,000,000 0001061937 0001590584 0001048286
7 remainder_Liabilities -5,516,000 0 847,200,979 12,757,150,000 21,071,000,000 0001712189 0001295810 0000858339
8 GeneralAndAdministrativeExpense 0 0 109,010,800 1,749,000,000 2,101,217,000 0000216877 0001674168 0000789570
9 DepreciationDepletionAndAmortization 0 0 41,746,242 1,114,600,000 1,304,649,000 0000906553 0001674168 0000789570
10 CostOfGoodsAndServicesSold 0 0 0 376,217,300 772,857,000 0000891482 0001046311 0001616000
11 OperatingExpenses 0 0 0 367,632,500 1,648,000,000 0000789570 0000921738 0001361658
12 remainder_Expenses 29,527 3,787,597 792,699,996 7,593,750,000 18,613,000,000 0001723177 0001005276 0001048286
13 remainder_Revenues 0 63,430,837 1,303,991,009 13,445,235,200 20,972,000,000 0001723177 0001005276 0001048286
14 remainder_NetIncome -973,969,000 -551,580,000 -133,317 532,400,000 902,000,000 0000789570 0001723177 0001468174
15 remainder_ComprehensiveNetIncome -569,000,000 -181,458,000 0 5,727,300 30,000,000 0001300514 0001723177 0001048286
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 1,669 87,398,621 3,592,761,114 25,242,100,000 33,876,356,000 0001723177 0001295810 0000789570
1 Liabilities 4,989 56,229,033 1,933,398,550 15,169,710,000 23,134,000,000 0001723177 0001005276 0000858339
2 Expenses 40,348 39,532,950 1,172,914,357 10,590,563,050 19,892,000,000 0001723177 0001005276 0001048286
3 Revenues 0 63,430,837 1,303,991,009 13,445,235,200 20,972,000,000 0001723177 0001005276 0001048286
4 StockholdersEquity -524,000,000 -15,283,312 796,197,046 14,556,550,000 30,684,933,000 0001361658 0001692412 0000789570
5 NetIncome -1,198,000,000 -40,275,050 69,186,147 1,884,897,000 3,304,000,000 0000858339 0001590895 0001300514
6 ComprehensiveNetIncome -1,232,000,000 -41,639,100 60,441,167 1,785,493,700 2,735,000,000 0000858339 0001581164 0001300514
7 BaseVar 128,006 448,467,678 10,539,714,017 93,582,260,659 136,659,780,000 0001723177 0001005276 0001048286
8 EconomicCapitalRatio -75.6 -0.154 0.451 1.84 2.13 0001723177 0001747079 0001712189

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 PropertyPlantAndEquipment -58.4 -0.271 -0.0491 0.379 0.481 0001723177 0000789570 0001692412
1 AssetsNonCurrent -19.7 -0.112 -0.0177 0.0311 0.237 0001723177 0001174922 0000921738
2 AssetsCurrent -24.8 -0.0594 -0.00764 0.0530 0.129 0001723177 0001046311 0001674168
3 IntangibleAssets -32.2 -0.0822 -0.0228 0.126 0.173 0001723177 0000907242 0001590895
4 remainder_Assets -25.6 -0.102 -0.0120 0.337 1.20 0001723177 0001048286 0001313536
5 LongTermLiabilities -22.0 -1.49 0.0766 0.183 0.241 0001723177 0001517401 0001048286
6 LiabilitiesCurrent -23.0 -0.273 -0.0263 0.1000 0.142 0001723177 0001590584 0001061937
7 remainder_Liabilities -47.1 -0.589 -0.0330 0.829 0.997 0001723177 0001674168 0001048286
8 GeneralAndAdministrativeExpense -14.7 -0.927 0.0819 0.644 0.724 0001723177 0001300514 0000906553
9 DepreciationDepletionAndAmortization -0.243 -0.200 -0.00780 0.293 1.81 0001061937 0000907242 0001723177
10 CostOfGoodsAndServicesSold -1.75 -1.14 0.168 0.331 1.63 0001616000 0001517401 0001723177
11 OperatingExpenses -2.41 -1.47 0.268 0.544 2.67 0000216877 0001590895 0001723177
12 remainder_Expenses -34.5 -2.69 -0.0640 1.59 1.96 0001723177 0001005276 0000216877
13 remainder_Revenues -29.2 -0.336 0.0325 0.793 1.23 0001723177 0001517401 0001048286
14 remainder_NetIncome -2.85 -0.354 0.0577 0.319 0.948 0001723177 0001581164 0001468174
15 remainder_ComprehensiveNetIncome -0.148 -0.111 0.0217 0.0858 0.232 0001581164 0001061937 0001723177
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -64.6 -0.278 -0.0310 0.187 0.253 0001723177 0001747079 0001692412
1 Liabilities -53.6 -0.495 -0.128 0.904 0.979 0001723177 0001046311 0001048286
2 Expenses -43.0 -0.926 0.134 0.420 1.50 0001723177 0001361658 0001712189
3 Revenues -29.2 -0.336 0.0325 0.793 1.23 0001723177 0001517401 0001048286
4 StockholdersEquity -3.73 -0.399 -0.107 0.732 0.836 0001723177 0001313536 0000789570
5 NetIncome -75.1 -0.433 0.247 0.937 1.95 0001723177 0001581164 0001712189
6 ComprehensiveNetIncome -74.9 -0.365 0.210 0.900 1.97 0001723177 0000906553 0001712189
7 BaseVar nan nan nan nan nan 0000216877 0001295810 0000216877
8 EconomicCapitalRatio -73.6 1.87 2.48 3.86 4.16 0001723177 0001747079 0001712189

2020

Logs

error 1 × Median ECR is negative check_abs_values
{'median': -0.17020555965477896}
warning 17 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000789570 0000891482 0000906553 0000907242 0000921738 0001005276 0001048286 0001061937 0001174922 0001300514 0001468174 0001585689 0001590584 0001590895 0001653653 0001674168 0001747079
warning 1 × Similarly named company. Duplicate? None
0001590895
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001581164
warning 1 × Missing logo subcommand.report
0000844887
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001048286
warning 1 × Ignoring company because Expenses is zero pre-agg
0000911147

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 PropertyPlantAndEquipment 0 5,438,018 1,621,267,634 14,527,409,150 15,109,000,000 0000844887 0001692412 0001300514
1 AssetsNonCurrent 0 0 62,294,291 9,949,910,000 15,912,184,000 0000216877 0001653653 0000789570
2 AssetsCurrent 88,711 13,379,011 434,035,524 5,338,628,350 6,667,000,000 0000844887 0001295810 0001590895
3 IntangibleAssets 0 0 126,414,839 11,096,200,000 18,164,000,000 0000216877 0001712189 0001048286
4 remainder_Assets -6,094,000,000 -3,732,895,800 143,068,751 1,004,200,000 2,174,000,000 0001585689 0001692412 0001361658
5 LongTermLiabilities 0 0 0 753,350,000 1,374,480,000 0000216877 0001061937 0001616000
6 LiabilitiesCurrent 0 0 113,124,267 2,531,100,000 5,752,000,000 0001061937 0001590584 0001048286
7 remainder_Liabilities 0 0 1,494,983,558 15,512,500,000 28,766,000,000 0000789570 0001692412 0001590895
8 GeneralAndAdministrativeExpense 0 0 98,126,908 1,117,570,000 2,122,333,000 0000216877 0001692412 0000789570
9 DepreciationDepletionAndAmortization 0 0 117,579,219 1,007,925,700 1,210,556,000 0000844887 0001361658 0000789570
10 CostOfGoodsAndServicesSold 0 0 0 277,496,450 460,148,000 0000844887 0001046311 0000789570
11 OperatingExpenses 0 0 0 296,600,000 1,130,000,000 0000789570 0000921738 0001361658
12 remainder_Expenses 395,700 8,755,833 647,827,495 4,274,950,000 9,625,000,000 0000216877 0001005276 0001048286
13 remainder_Revenues 0 29,855,892 968,562,475 4,862,803,300 10,571,000,000 0000844887 0001581164 0001048286
14 remainder_NetIncome -1,195,000,000 -722,550,050 -5,767,506 97,007,500 178,000,000 0001590895 0001692412 0001061937
15 remainder_ComprehensiveNetIncome -73,578,000 -12,900,000 0 262,667,700 490,000,000 0001581164 0000844887 0001300514
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,564,888 89,039,568 3,438,613,076 32,295,600,000 36,494,934,000 0000844887 0001653653 0000789570
1 Liabilities 3,871,882 63,840,359 2,310,730,726 17,900,800,000 31,351,000,000 0000216877 0001674168 0001590895
2 Expenses 1,593,703 37,599,169 1,122,346,410 5,748,258,700 10,733,000,000 0000844887 0001005276 0001048286
3 Revenues 0 29,855,892 968,562,475 4,862,803,300 10,571,000,000 0000844887 0001581164 0001048286
4 StockholdersEquity -1,486,000,000 -887,260,950 472,267,003 14,568,750,000 34,638,351,000 0001585689 0001692412 0000789570
5 NetIncome -2,326,946,000 -2,008,250,000 -187,700,066 85,242,950 989,297,000 0001174922 0001653653 0001581164
6 ComprehensiveNetIncome -2,061,962,000 -1,698,500,000 -164,180,778 85,289,950 915,719,000 0001174922 0001005276 0001581164
7 BaseVar 16,444,058 358,099,221 9,320,036,182 57,677,374,148 78,833,400,000 0000844887 0001005276 0001048286
8 EconomicCapitalRatio -1.96 -0.851 -0.170 1.36 1.77 0000844887 0000921738 0001581164

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 PropertyPlantAndEquipment -0.639 -0.490 -0.0543 0.857 1.04 0001590584 0001747079 0001295810
1 AssetsNonCurrent -0.266 -0.108 -0.0394 0.256 0.819 0001590584 0001048286 0001585689
2 AssetsCurrent -0.309 -0.160 -0.00810 0.213 0.270 0001590584 0001616000 0001674168
3 IntangibleAssets -0.231 -0.143 -0.0600 0.302 0.468 0001590584 0001468174 0001048286
4 remainder_Assets -0.340 -0.212 -0.0351 0.820 1.74 0001585689 0000906553 0001313536
5 LongTermLiabilities -0.597 -0.163 0.0233 0.0765 0.0783 0001616000 0000921738 0001048286
6 LiabilitiesCurrent -0.0921 -0.0331 0.0528 0.172 1.02 0001048286 0000216877 0000844887
7 remainder_Liabilities -0.740 -0.366 -0.0872 0.859 0.867 0001581164 0000844887 0001048286
8 GeneralAndAdministrativeExpense -0.952 -0.364 0.00998 0.337 0.466 0000891482 0001590895 0000216877
9 DepreciationDepletionAndAmortization -0.451 -0.226 0.0277 0.241 0.257 0001590584 0001590895 0001048286
10 CostOfGoodsAndServicesSold -0.900 -0.563 0.0841 0.166 0.247 0001313536 0001585689 0001590584
11 OperatingExpenses -2.11 -0.634 0.131 0.275 0.410 0000216877 0001616000 0001590584
12 remainder_Expenses -2.79 -1.45 -0.0229 0.657 1.37 0001590584 0000891482 0000216877
13 remainder_Revenues -0.932 -0.611 0.0224 1.19 1.35 0000844887 0000921738 0001590584
14 remainder_NetIncome -0.371 -0.267 0.0709 0.328 0.471 0001712189 0001692412 0001590584
15 remainder_ComprehensiveNetIncome -0.132 -0.0294 -0.0117 0.101 0.140 0001581164 0001295810 0001300514
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -1.09 -0.394 -0.0272 0.431 0.557 0001590584 0001712189 0001295810
1 Liabilities -0.409 -0.283 0.0253 0.897 0.958 0001581164 0001005276 0000906553
2 Expenses -2.29 -0.682 -0.0723 0.752 1.17 0001590584 0001616000 0001581164
3 Revenues -0.932 -0.611 0.0224 1.19 1.35 0000844887 0000921738 0001590584
4 StockholdersEquity -0.794 -0.349 -0.0866 0.751 1.06 0000844887 0001747079 0000789570
5 NetIncome -1.11 -0.874 -0.0270 1.28 1.91 0000844887 0001585689 0001581164
6 ComprehensiveNetIncome -1.12 -0.883 -0.0144 1.27 1.78 0000844887 0000789570 0001581164
7 BaseVar nan nan nan nan nan 0000216877 0001295810 0000216877
8 EconomicCapitalRatio -1.98 -0.870 -0.189 1.34 1.75 0000844887 0000921738 0001581164

2021

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001807616
warning 18 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000789570 0000891482 0000906553 0000907242 0000911147 0000921738 0001005276 0001048286 0001061937 0001174922 0001300514 0001468174 0001590584 0001590895 0001617406 0001653653 0001674168 0001747079
warning 3 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000911147 0001005276 0001048286
warning 1 × Similarly named company. Duplicate? None
0001590895
warning 1 × Missing logo subcommand.report
0000844887
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001722684

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 PropertyPlantAndEquipment 0 0 1,172,752,112 13,272,021,150 14,601,000,000 0000844887 0001048286 0001590895
1 AssetsNonCurrent 0 0 108,802,351 9,215,745,000 20,047,441,000 0000216877 0001046311 0000789570
2 AssetsCurrent 82,091 4,967,256 542,426,449 5,759,700,000 6,416,182,000 0000844887 0001747079 0000789570
3 IntangibleAssets 0 0 206,630,143 11,991,621,900 17,999,000,000 0000216877 0001653653 0001048286
4 remainder_Assets -7,097,382,000 -2,956,800,000 145,884,679 1,876,300,000 2,185,000,000 0000789570 0001590895 0001674168
5 LongTermLiabilities 0 0 0 821,827,050 2,913,000,000 0000216877 0001061937 0001674168
6 LiabilitiesCurrent 0 0 158,568,282 4,462,368,800 6,407,000,000 0000844887 0001295810 0001048286
7 remainder_Liabilities 0 0 1,262,154,676 14,343,750,000 28,193,000,000 0000789570 0001692412 0001590895
8 GeneralAndAdministrativeExpense 0 299,605 132,833,611 1,588,905,000 2,507,239,000 0000216877 0001046311 0000789570
9 DepreciationDepletionAndAmortization 0 0 127,348,778 1,087,750,000 1,150,610,000 0000844887 0001295810 0000789570
10 CostOfGoodsAndServicesSold 0 0 0 400,377,350 446,047,000 0000844887 0000844887 0001616000
11 OperatingExpenses 0 0 0 762,590,550 1,359,000,000 0000789570 0000891482 0001361658
12 remainder_Expenses -24,000,000 475,740 560,553,007 4,619,250,000 11,565,000,000 0001722684 0001747079 0001048286
13 remainder_Revenues 0 4,414,908 1,342,336,215 9,630,577,000 13,857,000,000 0000844887 0001617406 0001048286
14 remainder_NetIncome -2,759,000,000 -680,278,350 -16,994,200 253,805,800 466,000,000 0001590895 0001674168 0001468174
15 remainder_ComprehensiveNetIncome -207,000,000 -91,760,150 -13,919 180,032,200 264,000,000 0001048286 0001674168 0001300514
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,558,268 209,831,189 3,707,939,634 32,415,900,000 40,899,116,000 0000844887 0001722684 0000789570
1 Liabilities 3,702,663 31,867,885 2,977,368,325 17,113,050,000 33,490,000,000 0000216877 0001653653 0001590895
2 Expenses 735,497 8,374,494 1,186,102,081 7,787,705,550 12,608,000,000 0000844887 0001747079 0001048286
3 Revenues 0 4,414,908 1,342,336,215 9,630,577,000 13,857,000,000 0000844887 0001617406 0001048286
4 StockholdersEquity -836,215,000 -807,750,000 539,954,178 13,487,700,000 37,456,852,000 0001174922 0001692412 0000789570
5 NetIncome -1,276,000,000 -1,014,195,500 9,542,124 813,180,700 1,208,389,000 0001300514 0000891482 0000789570
6 ComprehensiveNetIncome -1,017,000,000 -895,623,700 8,095,563 711,550,000 1,254,222,000 0001590895 0000891482 0000789570
7 BaseVar 15,097,965 164,573,313 12,118,100,809 86,212,573,352 95,022,080,000 0000844887 0001722684 0001590895
8 EconomicCapitalRatio -1.54 -0.378 0.358 1.93 2.08 0000844887 0000891482 0000216877

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 PropertyPlantAndEquipment -0.341 -0.273 -0.0344 0.521 0.893 0001313536 0000907242 0001617406
1 AssetsNonCurrent -0.114 -0.0835 -0.0211 0.121 0.686 0001590584 0001295810 0001585689
2 AssetsCurrent -0.144 -0.120 -0.00637 0.123 0.320 0000216877 0000789570 0000891482
3 IntangibleAssets -0.154 -0.140 -0.0369 0.237 0.674 0001313536 0001361658 0001747079
4 remainder_Assets -0.307 -0.252 -0.0856 0.901 3.00 0001585689 0001061937 0001819395
5 LongTermLiabilities -0.669 -0.234 0.0355 0.102 0.135 0001616000 0000921738 0000906553
6 LiabilitiesCurrent -0.292 -0.217 0.00410 0.0938 0.0998 0001048286 0001590584 0001061937
7 remainder_Liabilities -0.301 -0.228 0.00564 1.09 1.41 0001361658 0001061937 0000906553
8 GeneralAndAdministrativeExpense -0.465 -0.419 0.0112 0.316 0.525 0000891482 0001300514 0000216877
9 DepreciationDepletionAndAmortization -0.451 -0.251 0.00866 0.220 0.306 0001590584 0001005276 0001048286
10 CostOfGoodsAndServicesSold -1.23 -0.604 0.0994 0.207 0.278 0001313536 0001174922 0001590584
11 OperatingExpenses -2.08 -1.26 0.198 0.406 0.564 0000216877 0001468174 0001590584
12 remainder_Expenses -2.70 -1.79 -0.159 1.04 1.18 0001590584 0001005276 0000216877
13 remainder_Revenues -0.934 -0.592 0.152 1.48 1.63 0000844887 0000921738 0001590584
14 remainder_NetIncome -0.384 -0.364 0.0754 0.421 0.570 0000844887 0001616000 0001295810
15 remainder_ComprehensiveNetIncome -0.200 -0.158 0.00860 0.0803 0.127 0001653653 0001674168 0001174922
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.523 -0.277 -0.0239 0.264 1.13 0001590584 0001468174 0001819395
1 Liabilities -0.210 -0.203 0.000185 1.07 1.49 0001585689 0001616000 0000906553
2 Expenses -2.12 -0.841 -0.0653 0.475 0.849 0001590584 0001174922 0001712189
3 Revenues -0.934 -0.592 0.152 1.48 1.63 0000844887 0000921738 0001590584
4 StockholdersEquity -0.844 -0.428 -0.132 0.748 1.04 0000844887 0001722684 0001819395
5 NetIncome -0.853 -0.456 0.0987 0.935 1.63 0000844887 0001674168 0001712189
6 ComprehensiveNetIncome -0.848 -0.390 0.106 0.949 1.65 0000844887 0000921738 0001712189
7 BaseVar nan nan nan nan nan 0000216877 0001295810 0000216877
8 EconomicCapitalRatio -2.03 -0.867 -0.131 1.44 1.59 0000844887 0000891482 0000216877

2022

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001807616
warning 20 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000789570 0000891482 0000906553 0000907242 0000911147 0000921738 0001005276 0001046311 0001048286 0001061937 0001174922 0001295810 0001300514 0001468174 0001590584 0001590895 0001617406 0001653653 0001674168 0001747079
warning 4 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000911147 0001005276 0001048286 0001712189
warning 1 × Similarly named company. Duplicate? None
0001590895
warning 1 × Missing logo subcommand.report
0000844887
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001722684

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 PropertyPlantAndEquipment 0 0 1,370,304,448 10,684,650,000 14,598,000,000 0000844887 0001692412 0001590895
1 AssetsNonCurrent 0 0 187,182,946 9,786,390,000 32,313,586,000 0000216877 0001617406 0000789570
2 AssetsCurrent 55,885 16,198,251 413,452,887 5,522,514,150 8,154,692,000 0000844887 0000906553 0000789570
3 IntangibleAssets 0 0 181,110,696 11,606,153,800 17,619,000,000 0000216877 0001174922 0001048286
4 remainder_Assets -6,580,564,000 -2,921,600,000 174,764,449 1,832,050,000 2,447,000,000 0000789570 0001692412 0001674168
5 LongTermLiabilities 0 0 0 786,007,750 2,651,000,000 0000216877 0001061937 0001674168
6 LiabilitiesCurrent 0 0 272,068,563 4,239,640,600 7,339,000,000 0000844887 0001653653 0001048286
7 remainder_Liabilities 0 0 1,458,596,811 13,924,368,900 27,108,000,000 0000789570 0001046311 0001590895
8 GeneralAndAdministrativeExpense 0 3,490,629 197,001,434 1,637,080,000 4,226,617,000 0000216877 0001046311 0000789570
9 DepreciationDepletionAndAmortization 0 0 127,387,719 1,188,350,000 3,482,050,000 0000844887 0001653653 0000789570
10 CostOfGoodsAndServicesSold 0 0 0 448,464,900 672,275,000 0000844887 0000911147 0001616000
11 OperatingExpenses 0 0 0 723,563,500 1,603,000,000 0000789570 0000789570 0001361658
12 remainder_Expenses 724,700 920,260 736,485,749 6,220,600,000 17,386,000,000 0000216877 0001046311 0001048286
13 remainder_Revenues 0 79,161,543 1,627,360,998 12,089,566,750 20,773,000,000 0000844887 0001653653 0001048286
14 remainder_NetIncome -2,690,000,000 -752,388,700 0 145,800,000 3,005,000,000 0001590895 0000844887 0001300514
15 remainder_ComprehensiveNetIncome -387,000,000 -231,059,800 0 395,096,800 1,314,113,000 0001048286 0000216877 0000789570
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5,532,062 197,558,054 3,736,629,025 29,606,600,000 45,692,206,000 0000844887 0001722684 0000789570
1 Liabilities 3,547,796 78,934,416 3,212,203,266 17,585,150,000 29,776,000,000 0000216877 0001005276 0001590895
2 Expenses 1,855,705 72,474,946 1,250,648,112 10,792,182,400 18,470,000,000 0000844887 0001005276 0001048286
3 Revenues 0 79,161,543 1,627,360,998 12,089,566,750 20,773,000,000 0000844887 0001653653 0001048286
4 StockholdersEquity -1,640,365,000 -1,010,700,000 602,273,133 12,707,350,000 41,176,314,000 0001174922 0001692412 0000789570
5 NetIncome -910,000,000 -581,648,100 151,508,876 1,312,000,000 2,358,000,000 0001590895 0001617406 0001048286
6 ComprehensiveNetIncome -843,000,000 -575,526,150 99,382,689 1,700,229,800 1,971,000,000 0001590895 0000921738 0001048286
7 BaseVar 16,985,273 694,314,735 12,525,256,773 102,220,262,134 132,750,900,000 0000844887 0001005276 0001048286
8 EconomicCapitalRatio -1.71 -0.599 0.527 2.23 2.63 0000844887 0001617406 0001712189

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 PropertyPlantAndEquipment -0.342 -0.270 -0.0402 0.434 0.535 0001819395 0001712189 0001617406
1 AssetsNonCurrent -0.204 -0.107 -0.0264 0.338 0.948 0001590584 0001061937 0001819395
2 AssetsCurrent -0.153 -0.113 -0.0162 0.139 0.187 0000216877 0001585689 0000891482
3 IntangibleAssets -0.209 -0.164 -0.0392 0.237 0.604 0000906553 0001295810 0001747079
4 remainder_Assets -0.226 -0.175 -0.0196 0.571 0.825 0001590584 0001046311 0000844887
5 LongTermLiabilities -0.837 -0.233 0.0310 0.105 0.109 0001616000 0001722684 0000907242
6 LiabilitiesCurrent -0.346 -0.274 -0.00659 0.118 0.145 0001712189 0000844887 0001061937
7 remainder_Liabilities -0.321 -0.264 -0.0331 1.36 1.45 0001361658 0000911147 0000906553
8 GeneralAndAdministrativeExpense -0.546 -0.440 -0.0252 0.480 0.625 0000907242 0001712189 0001048286
9 DepreciationDepletionAndAmortization -0.538 -0.516 0.0156 0.255 0.474 0000789570 0001653653 0001048286
10 CostOfGoodsAndServicesSold -1.66 -1.29 0.172 0.370 0.534 0001313536 0001747079 0001590584
11 OperatingExpenses -2.27 -1.27 0.262 0.569 0.846 0000216877 0001616000 0001590584
12 remainder_Expenses -3.67 -2.46 -0.0140 1.25 1.42 0001590584 0001174922 0000216877
13 remainder_Revenues -1.07 -0.885 0.122 1.57 1.83 0000844887 0000911147 0001590584
14 remainder_NetIncome -0.480 -0.350 0.0210 0.513 0.893 0001590895 0001692412 0001300514
15 remainder_ComprehensiveNetIncome -0.312 -0.283 0.0182 0.144 0.327 0001590584 0001712189 0000789570
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.602 -0.149 0.0183 0.166 0.212 0001590584 0001692412 0001617406
1 Liabilities -0.315 -0.239 0.0571 1.34 1.51 0001174922 0001692412 0000906553
2 Expenses -2.51 -1.03 -0.0484 0.427 1.12 0001590584 0001313536 0001712189
3 Revenues -1.07 -0.885 0.122 1.57 1.83 0000844887 0000911147 0001590584
4 StockholdersEquity -0.837 -0.277 -0.0126 0.869 0.977 0000844887 0000921738 0000789570
5 NetIncome -1.03 -0.728 0.0637 0.777 2.18 0000844887 0001674168 0001712189
6 ComprehensiveNetIncome -1.02 -0.863 0.0738 0.808 2.20 0000844887 0001295810 0001712189
7 BaseVar nan nan nan nan nan 0000216877 0001295810 0000216877
8 EconomicCapitalRatio -2.31 -1.20 -0.0790 1.62 2.03 0000844887 0001617406 0001712189

Estimates

Parameter Value Min Max
PresentValueFactor 5.88 1.0 15.0
BalanceFactor 0.73 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 0.72 0.2 10.0