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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0001128281 | Saker Aviation Services Inc. | Saker A | 2 | 6 | 2 | 1 | NaN | 1 | 1 | 97.6277 | 93.09810 | 92.411600 | 96.74460 | NaN | 115.796000 | 143.18700 | 4 | -4 | -1 | NaN | NaN | 0 |
0001048911 | FEDEX CORP | FEDEX C | 7 | 5 | 1 | 6 | 1 | 3 | 2 | 83.6876 | 94.86720 | 101.961000 | 73.93060 | 81.01920 | 98.106900 | 87.80430 | -2 | -4 | 5 | -5 | 2 | -1 |
0000899394 | HARBOR DIVERSIFIED INC. | HARBOR | NaN | NaN | NaN | 11 | 2 | 2 | 3 | NaN | NaN | NaN | -2.32251 | 54.73480 | 111.171000 | 81.45940 | NaN | NaN | NaN | -9 | 0 | 1 |
0000092380 | SOUTHWEST AIRLINES CO | SOUTHWE | 3 | 2 | NaN | NaN | NaN | 4 | 4 | 97.1656 | 110.59100 | NaN | NaN | NaN | 73.476500 | 59.71670 | -1 | NaN | NaN | NaN | NaN | 0 |
0001498710 | Spirit Airlines Inc. | Spirit | 1 | 1 | 3 | 2 | 3 | 7 | 5 | 104.2140 | 113.36800 | 84.135900 | 91.65370 | 52.20560 | 51.866500 | 46.73700 | 0 | 2 | -1 | 1 | 4 | -2 |
0001135185 | ATLAS AIR WORLDWIDE HOLDINGS INC | ATLAS A | 11 | 9 | 7 | 10 | 4 | 8 | 6 | 24.5546 | 34.74030 | 36.843100 | 4.98221 | 40.03340 | 50.444800 | 45.54420 | -2 | -2 | 3 | -6 | 4 | -2 |
0001158463 | JETBLUE AIRWAYS CORP | JETBLUE | 4 | 3 | 6 | 3 | 5 | 5 | 7 | 92.3194 | 103.62500 | 69.000700 | 81.54210 | 28.00750 | 55.031400 | 45.44630 | -1 | 3 | -3 | 2 | 0 | 2 |
0001779128 | Blade Air Mobility Inc. | Blade A | NaN | NaN | NaN | NaN | NaN | 11 | 8 | NaN | NaN | NaN | NaN | NaN | 26.788700 | 42.62460 | NaN | NaN | NaN | NaN | NaN | -3 |
0001172222 | HAWAIIAN HOLDINGS INC | HAWAIIA | 8 | 4 | 4 | 5 | 8 | 6 | 9 | 83.2767 | 99.68380 | 77.204200 | 74.90470 | 7.63298 | 51.943200 | 35.53160 | -4 | 0 | 1 | 3 | -2 | 3 |
0000353184 | AIR T INC | AIR T I | 5 | 12 | NaN | 8 | NaN | 16 | 10 | 85.2658 | 6.15239 | NaN | 18.34810 | NaN | -5.385110 | 23.68320 | 7 | NaN | NaN | NaN | NaN | -6 |
0001743907 | Sun Country Airlines Holdings Inc. | Sun Cou | NaN | NaN | NaN | NaN | NaN | 10 | 11 | NaN | NaN | NaN | NaN | NaN | 37.201900 | 22.34790 | NaN | NaN | NaN | NaN | NaN | 1 |
0000027904 | DELTA AIR LINES INC. | DELTA A | 10 | 10 | 8 | 7 | 10 | 14 | 12 | 34.5291 | 32.82040 | 29.435100 | 32.29420 | -41.45510 | 8.336890 | 12.48590 | 0 | -2 | -1 | 3 | 4 | -2 |
0001670076 | Frontier Group Holdings Inc. | Frontie | NaN | NaN | NaN | NaN | NaN | 15 | 13 | NaN | NaN | NaN | NaN | NaN | 0.809194 | 4.15361 | NaN | NaN | NaN | NaN | NaN | -2 |
0001819516 | Wheels Up Experience Inc. | Wheels | NaN | NaN | NaN | NaN | NaN | 13 | 14 | NaN | NaN | NaN | NaN | NaN | 22.814100 | -65.01390 | NaN | NaN | NaN | NaN | NaN | 1 |
0000006201 | American Airlines Group Inc. | America | 12 | 11 | 9 | 9 | 9 | NaN | NaN | 15.0701 | 12.65190 | 4.872870 | 5.10944 | -38.39630 | NaN | NaN | -1 | -2 | 0 | 0 | NaN | NaN |
0000100517 | United Airlines Holdings Inc. | United | 9 | 8 | 5 | 4 | 7 | 9 | NaN | 72.9995 | 70.47490 | 73.338900 | 76.69640 | 17.93210 | 48.007300 | NaN | -1 | -3 | -1 | 3 | 2 | NaN |
0000350403 | PHI Group Inc. DE | PHI Gro | 6 | 7 | 10 | NaN | NaN | NaN | NaN | 84.2690 | 91.71160 | 0.176157 | NaN | NaN | NaN | NaN | 1 | 3 | NaN | NaN | NaN | NaN |
0000810332 | MESA AIR GROUP INC | MESA AI | NaN | NaN | NaN | NaN | 6 | 12 | NaN | NaN | NaN | NaN | NaN | 22.94550 | 23.270800 | NaN | NaN | NaN | NaN | NaN | 6 | NaN |
PDF reports
All reports for 2022 are collected in a single PDF for easier review.2016
Logs
warning | 1 × Ignoring company because Assets is zero | pre-agg |
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 | LiabilitiesCurrent | 1,675,426 | 9,398,372 | 1,528,090,172 | 14,487,150,000 | 15,239,000,000 | 0001128281 | 0001158463 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 28,181,900,000 | 33,617,000,000 | 0000092380 | 0001158463 | 0000006201 |
2 | remainder_Liabilities | 0 | 0 | 0 | 205,875 | 457,500 | 0000006201 | 0001048911 | 0001128281 |
3 | AssetsCurrent | 4,487,155 | 23,446,963 | 1,272,072,770 | 11,073,250,000 | 11,989,000,000 | 0001128281 | 0001158463 | 0001048911 |
4 | AssetsNoncurrent | 0 | 0 | 304,036,955 | 9,638,100,000 | 9,791,000,000 | 0001128281 | 0001158463 | 0000006201 |
5 | PropertyPlantAndEquipmentNet | 1,074,397 | 3,001,254 | 5,409,944,350 | 27,427,800,000 | 31,159,000,000 | 0001128281 | 0001158463 | 0000006201 |
6 | remainder_Assets | 0 | 0 | 204,013,178 | 11,676,750,000 | 17,702,000,000 | 0000006201 | 0001172222 | 0000027904 |
7 | OperatingExpenses | 0 | 0 | 3,156,909,728 | 32,173,300,000 | 33,193,000,000 | 0000350403 | 0001158463 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 250,877,359 | 2,271,300,000 | 2,631,000,000 | 0000350403 | 0001158463 | 0001048911 |
9 | remainder_Expenses | 13,782,928 | 85,718,967 | 894,692,761 | 8,870,050,000 | 12,384,000,000 | 0001128281 | 0001135185 | 0001048911 |
10 | remainder_Revenues | 0 | 0 | 2,386,409,486 | 44,763,250,000 | 50,365,000,000 | 0000350403 | 0001172222 | 0001048911 |
11 | remainder_NetIncome | -985,000,000 | -728,700,000 | -51,487,837 | 3,276,824,300 | 6,536,000,000 | 0000006201 | 0001498710 | 0001158463 |
12 | remainder_ComprehensiveNetIncome | -361,000,000 | -355,500,000 | 0 | 336,400,000 | 728,000,000 | 0000027904 | 0001128281 | 0000092380 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 2,132,926 | 9,604,247 | 2,477,078,245 | 42,805,750,000 | 47,489,000,000 | 0001128281 | 0001135185 | 0000006201 |
1 | Assets | 6,966,803 | 31,820,175 | 6,872,953,083 | 51,266,850,000 | 51,274,000,000 | 0001128281 | 0001158463 | 0000006201 |
2 | Expenses | 13,782,928 | 85,718,967 | 3,992,010,635 | 41,779,050,000 | 48,208,000,000 | 0001128281 | 0001158463 | 0001048911 |
3 | Revenues | 0 | 0 | 2,386,409,486 | 44,763,250,000 | 50,365,000,000 | 0000350403 | 0001172222 | 0001048911 |
4 | StockholdersEquity | 4,833,877 | 22,215,928 | 3,203,770,025 | 32,444,900,000 | 38,056,000,000 | 0001128281 | 0000006201 | 0001048911 |
5 | NetIncome | -26,680,000 | -11,521,763 | 512,483,033 | 3,439,650,000 | 4,373,000,000 | 0000350403 | 0001158463 | 0000027904 |
6 | ComprehensiveNetIncome | -26,680,000 | -11,521,763 | 518,571,442 | 3,380,512,500 | 4,102,250,000 | 0000350403 | 0001158463 | 0000027904 |
7 | BaseVar | 37,325,874 | 221,486,961 | 13,865,712,819 | 140,045,555,000 | 141,174,650,000 | 0001128281 | 0001158463 | 0001048911 |
8 | EconomicCapitalRatio | 0.151 | 0.203 | 0.840 | 1.01 | 1.04 | 0000006201 | 0000350403 | 0001498710 |
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 | LiabilitiesCurrent | -0.134 | -0.132 | -0.00812 | 0.297 | 0.336 | 0001172222 | 0001135185 | 0000353184 |
1 | LiabilitiesNonCurrent | -0.406 | -0.402 | 0.190 | 0.414 | 0.451 | 0001135185 | 0001172222 | 0000353184 |
2 | remainder_Liabilities | -0.0955 | -0.0422 | 0.00349 | 0.00733 | 0.0103 | 0001128281 | 0000100517 | 0000353184 |
3 | AssetsCurrent | -0.0418 | -0.0403 | -0.00317 | 0.0201 | 0.0396 | 0001135185 | 0001158463 | 0000350403 |
4 | AssetsNoncurrent | -0.0171 | -0.0157 | -0.00117 | 0.0524 | 0.0634 | 0001135185 | 0000092380 | 0000006201 |
5 | PropertyPlantAndEquipmentNet | -0.0808 | -0.0602 | -0.00491 | 0.144 | 0.252 | 0000353184 | 0001172222 | 0001135185 |
6 | remainder_Assets | -0.0417 | -0.0292 | -0.00238 | 0.0530 | 0.109 | 0000006201 | 0000092380 | 0000027904 |
7 | OperatingExpenses | -0.938 | -0.895 | -0.471 | 3.55 | 4.12 | 0000100517 | 0000006201 | 0000353184 |
8 | DepreciationDepletionAndAmortization | -0.0916 | -0.0880 | -0.0274 | 0.239 | 0.278 | 0001048911 | 0000027904 | 0000353184 |
9 | remainder_Expenses | -6.54 | -5.43 | 0.552 | 0.949 | 0.991 | 0000353184 | 0000027904 | 0000092380 |
10 | remainder_Revenues | -2.19 | -2.01 | 0.535 | 2.56 | 3.03 | 0001158463 | 0000092380 | 0000353184 |
11 | remainder_NetIncome | -1.19 | -1.03 | -0.449 | 1.84 | 2.19 | 0000353184 | 0001498710 | 0001158463 |
12 | remainder_ComprehensiveNetIncome | -0.0277 | -0.0219 | -0.00428 | 0.0623 | 0.0788 | 0001048911 | 0001498710 | 0000092380 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.448 | -0.416 | 0.103 | 0.577 | 0.656 | 0000006201 | 0000092380 | 0000353184 |
1 | Assets | -0.0854 | -0.0530 | -0.00499 | 0.130 | 0.164 | 0000353184 | 0001172222 | 0001135185 |
2 | Expenses | -2.14 | -1.64 | 0.0624 | 0.329 | 0.404 | 0000353184 | 0001498710 | 0001135185 |
3 | Revenues | -2.19 | -2.01 | 0.535 | 2.56 | 3.03 | 0001158463 | 0000092380 | 0000353184 |
4 | StockholdersEquity | -0.829 | -0.643 | 0.0239 | 0.388 | 0.562 | 0000353184 | 0001172222 | 0000350403 |
5 | NetIncome | -0.292 | -0.256 | 0.0151 | 0.144 | 0.145 | 0000353184 | 0001128281 | 0001498710 |
6 | ComprehensiveNetIncome | -0.243 | -0.236 | 0.00820 | 0.177 | 0.222 | 0000353184 | 0001128281 | 0000092380 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
8 | EconomicCapitalRatio | -0.578 | -0.526 | 0.111 | 0.277 | 0.313 | 0000006201 | 0000350403 | 0001498710 |
2017
Logs
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 | LiabilitiesCurrent | 1,259,378 | 11,714,654 | 1,645,113,388 | 16,588,050,000 | 18,573,000,000 | 0001128281 | 0001158463 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 26,072,650,000 | 32,506,000,000 | 0000092380 | 0001172222 | 0000006201 |
2 | remainder_Liabilities | 0 | 0 | 0 | 8,351,109 | 18,420,521 | 0000006201 | 0001135185 | 0000353184 |
3 | AssetsCurrent | 4,627,988 | 28,955,088 | 1,243,211,686 | 10,712,900,000 | 12,628,000,000 | 0001128281 | 0001498710 | 0001048911 |
4 | AssetsNoncurrent | 0 | 0 | 294,883,197 | 8,503,950,000 | 9,005,000,000 | 0001128281 | 0001158463 | 0000100517 |
5 | PropertyPlantAndEquipmentNet | 669,957 | 3,229,949 | 6,030,500,989 | 29,979,850,000 | 34,156,000,000 | 0001128281 | 0001158463 | 0000006201 |
6 | remainder_Assets | 0 | 0 | 204,848,431 | 10,943,900,000 | 15,576,000,000 | 0000006201 | 0001172222 | 0000027904 |
7 | OperatingExpenses | 0 | 0 | 3,648,822,011 | 36,248,350,000 | 38,681,000,000 | 0000350403 | 0001158463 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 293,412,433 | 2,577,000,000 | 2,995,000,000 | 0000350403 | 0001158463 | 0001048911 |
9 | remainder_Expenses | -237,000,000 | -100,321,267 | 442,331,558 | 10,158,250,000 | 15,188,000,000 | 0000092380 | 0000350403 | 0001048911 |
10 | remainder_Revenues | 0 | 0 | 2,671,716,721 | 50,357,400,000 | 60,319,000,000 | 0000350403 | 0001172222 | 0001048911 |
11 | remainder_NetIncome | -974,000,000 | -712,750,000 | -86,313,125 | 3,423,393,650 | 6,936,000,000 | 0000006201 | 0001172222 | 0001158463 |
12 | remainder_ComprehensiveNetIncome | -246,000,000 | -220,700,000 | 99,218 | 166,275,950 | 335,000,000 | 0001048911 | 0000350403 | 0000092380 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 1,371,878 | 23,568,237 | 2,781,150,667 | 43,021,600,000 | 47,470,000,000 | 0001128281 | 0001135185 | 0000006201 |
1 | Assets | 6,548,662 | 38,881,252 | 7,373,539,092 | 52,249,200,000 | 53,292,000,000 | 0001128281 | 0001158463 | 0000027904 |
2 | Expenses | 11,506,788 | 88,941,642 | 4,027,568,693 | 47,211,500,000 | 56,864,000,000 | 0001128281 | 0001158463 | 0001048911 |
3 | Revenues | 0 | 0 | 2,671,716,721 | 50,357,400,000 | 60,319,000,000 | 0000350403 | 0001172222 | 0001048911 |
4 | StockholdersEquity | 5,176,784 | 15,313,015 | 3,711,933,984 | 34,592,800,000 | 40,634,000,000 | 0001128281 | 0000006201 | 0001048911 |
5 | NetIncome | -4,944,186 | -1,962,188 | 784,618,996 | 3,528,050,000 | 3,577,000,000 | 0000353184 | 0001158463 | 0000027904 |
6 | ComprehensiveNetIncome | -3,699,848 | -1,402,236 | 779,688,744 | 3,656,200,000 | 3,739,250,000 | 0000353184 | 0001158463 | 0000092380 |
7 | BaseVar | 31,047,869 | 235,407,402 | 14,763,793,392 | 153,123,417,500 | 163,805,050,000 | 0001128281 | 0001158463 | 0001048911 |
8 | EconomicCapitalRatio | 0.0615 | 0.0973 | 0.924 | 1.12 | 1.13 | 0000353184 | 0001128281 | 0001498710 |
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 | LiabilitiesCurrent | -0.127 | -0.119 | -0.0124 | 0.241 | 0.296 | 0001172222 | 0001135185 | 0001128281 |
1 | LiabilitiesNonCurrent | -0.424 | -0.395 | 0.173 | 0.302 | 0.343 | 0001135185 | 0001158463 | 0001128281 |
2 | remainder_Liabilities | -0.197 | -0.0866 | 0.0124 | 0.0195 | 0.0230 | 0000353184 | 0001158463 | 0001048911 |
3 | AssetsCurrent | -0.0409 | -0.0389 | -0.00141 | 0.0524 | 0.0948 | 0000006201 | 0001172222 | 0000353184 |
4 | AssetsNoncurrent | -0.0611 | -0.0349 | -0.000157 | 0.0452 | 0.0493 | 0000353184 | 0001172222 | 0000006201 |
5 | PropertyPlantAndEquipmentNet | -0.442 | -0.227 | -0.0110 | 0.104 | 0.187 | 0000353184 | 0001048911 | 0001135185 |
6 | remainder_Assets | -0.0440 | -0.0376 | 0.00111 | 0.0412 | 0.0868 | 0000006201 | 0001048911 | 0000027904 |
7 | OperatingExpenses | -0.955 | -0.909 | -0.521 | 3.01 | 3.08 | 0000100517 | 0000006201 | 0001128281 |
8 | DepreciationDepletionAndAmortization | -0.0891 | -0.0828 | -0.0307 | 0.205 | 0.209 | 0001048911 | 0001172222 | 0001128281 |
9 | remainder_Expenses | -4.61 | -4.58 | 0.548 | 0.954 | 1.04 | 0001128281 | 0000006201 | 0000092380 |
10 | remainder_Revenues | -2.17 | -1.92 | 0.484 | 1.76 | 1.98 | 0001158463 | 0000100517 | 0001128281 |
11 | remainder_NetIncome | -0.859 | -0.856 | -0.419 | 1.79 | 2.26 | 0001128281 | 0001498710 | 0001158463 |
12 | remainder_ComprehensiveNetIncome | -0.0227 | -0.0201 | -0.00392 | 0.0367 | 0.0435 | 0001048911 | 0000027904 | 0000353184 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.410 | -0.409 | 0.120 | 0.484 | 0.551 | 0000006201 | 0000092380 | 0001128281 |
1 | Assets | -0.446 | -0.231 | -0.0129 | 0.0934 | 0.139 | 0000353184 | 0001048911 | 0001135185 |
2 | Expenses | -1.40 | -1.36 | 0.123 | 0.295 | 0.437 | 0000353184 | 0001158463 | 0001135185 |
3 | Revenues | -2.17 | -1.92 | 0.484 | 1.76 | 1.98 | 0001158463 | 0000100517 | 0001128281 |
4 | StockholdersEquity | -0.745 | -0.529 | -0.0134 | 0.412 | 0.547 | 0000353184 | 0001172222 | 0000350403 |
5 | NetIncome | -0.676 | -0.417 | -0.0395 | 0.243 | 0.266 | 0000353184 | 0001135185 | 0000092380 |
6 | ComprehensiveNetIncome | -0.632 | -0.403 | -0.0497 | 0.252 | 0.297 | 0000353184 | 0001135185 | 0000092380 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
8 | EconomicCapitalRatio | -0.658 | -0.623 | 0.204 | 0.399 | 0.414 | 0000353184 | 0001128281 | 0001498710 |
2018
Logs
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 | LiabilitiesCurrent | 821,486 | 268,346,267 | 1,713,337,180 | 18,361,100,000 | 18,578,000,000 | 0001128281 | 0001158463 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 36,059,600,000 | 42,653,000,000 | 0000100517 | 0001172222 | 0000006201 |
2 | remainder_Liabilities | 0 | 0 | 0 | 95,369 | 173,399 | 0000006201 | 0001135185 | 0001128281 |
3 | AssetsCurrent | 4,693,802 | 145,068,691 | 1,409,848,681 | 11,224,200,000 | 13,341,000,000 | 0001128281 | 0001158463 | 0001048911 |
4 | AssetsNoncurrent | 0 | 0 | 327,673,990 | 37,689,550,000 | 53,926,000,000 | 0001128281 | 0001158463 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | 388,072 | 406,331,690 | 6,392,084,988 | 31,504,650,000 | 34,098,000,000 | 0001128281 | 0001158463 | 0000006201 |
6 | remainder_Assets | -28,335,000,000 | -15,584,250,000 | 43,396,047 | 4,116,185,350 | 6,973,000,000 | 0000027904 | 0001158463 | 0001048911 |
7 | OperatingExpenses | 0 | 0 | 4,358,156,135 | 40,090,250,000 | 42,014,000,000 | 0000350403 | 0001158463 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 334,146,346 | 2,750,300,000 | 3,095,000,000 | 0000350403 | 0001158463 | 0001048911 |
9 | remainder_Expenses | 10,823,269 | 134,099,298 | 1,162,632,179 | 10,924,800,000 | 15,252,000,000 | 0001128281 | 0001135185 | 0001048911 |
10 | remainder_Revenues | 11,118,452 | 309,605,499 | 5,494,401,500 | 56,040,950,000 | 65,450,000,000 | 0001128281 | 0001158463 | 0001048911 |
11 | remainder_NetIncome | -772,000,000 | -709,900,000 | -90,960,400 | 14,170,959 | 25,752,000 | 0000006201 | 0001158463 | 0001135185 |
12 | remainder_ComprehensiveNetIncome | -163,000,000 | -143,650,000 | -3,335,395 | 186,408,950 | 338,000,000 | 0001048911 | 0001158463 | 0000100517 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 994,885 | 268,441,637 | 2,943,357,945 | 54,372,500,000 | 60,749,000,000 | 0001128281 | 0001135185 | 0000006201 |
1 | Assets | 6,341,386 | 571,489,462 | 7,984,798,087 | 60,438,700,000 | 60,580,000,000 | 0001128281 | 0001158463 | 0000006201 |
2 | Expenses | 10,823,269 | 357,659,298 | 5,215,115,188 | 52,259,200,000 | 60,361,000,000 | 0001128281 | 0001158463 | 0001048911 |
3 | Revenues | 11,118,452 | 309,605,499 | 5,494,401,500 | 56,040,950,000 | 65,450,000,000 | 0001128281 | 0001158463 | 0001048911 |
4 | StockholdersEquity | -169,000,000 | -90,544,075 | 3,262,643,868 | 37,697,650,000 | 42,703,000,000 | 0000006201 | 0001498710 | 0001048911 |
5 | NetIncome | -141,514,000 | -77,692,509 | 251,917,130 | 4,285,350,000 | 4,572,000,000 | 0000350403 | 0001135185 | 0001048911 |
6 | ComprehensiveNetIncome | -144,268,000 | -79,207,209 | 250,333,391 | 4,185,037,500 | 4,449,750,000 | 0000350403 | 0001135185 | 0001048911 |
7 | BaseVar | 28,919,921 | 1,207,015,591 | 17,155,415,363 | 169,774,082,500 | 176,443,150,000 | 0001128281 | 0001158463 | 0001048911 |
8 | EconomicCapitalRatio | 0.00176 | 0.0229 | 0.712 | 0.977 | 1.02 | 0000350403 | 0000100517 | 0001048911 |
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 | LiabilitiesCurrent | -0.210 | -0.144 | -0.00372 | 0.351 | 0.438 | 0000350403 | 0001158463 | 0001128281 |
1 | LiabilitiesNonCurrent | -0.370 | -0.368 | 0.198 | 0.381 | 0.418 | 0001135185 | 0001498710 | 0001128281 |
2 | remainder_Liabilities | -0.0418 | -0.0226 | 0.00149 | 0.00288 | 0.00344 | 0001128281 | 0001158463 | 0001048911 |
3 | AssetsCurrent | -0.0403 | -0.0393 | -0.00638 | 0.0438 | 0.0523 | 0000027904 | 0001172222 | 0000350403 |
4 | AssetsNoncurrent | -0.0706 | -0.0574 | -0.0140 | 0.311 | 0.509 | 0000350403 | 0001498710 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | -0.0559 | -0.0509 | 0.00502 | 0.160 | 0.167 | 0000027904 | 0001172222 | 0001135185 |
6 | remainder_Assets | -0.151 | -0.0856 | 0.00278 | 0.0235 | 0.0289 | 0000027904 | 0000350403 | 0001135185 |
7 | OperatingExpenses | -0.937 | -0.859 | -0.425 | 2.32 | 3.26 | 0000100517 | 0000006201 | 0001128281 |
8 | DepreciationDepletionAndAmortization | -0.0766 | -0.0764 | -0.0329 | 0.151 | 0.212 | 0001048911 | 0000027904 | 0001128281 |
9 | remainder_Expenses | -4.82 | -3.20 | 0.512 | 0.759 | 0.846 | 0001128281 | 0000006201 | 0000100517 |
10 | remainder_Revenues | -0.397 | -0.358 | 0.0347 | 1.02 | 1.25 | 0000350403 | 0001158463 | 0001128281 |
11 | remainder_NetIncome | -0.0782 | -0.0689 | 0.0139 | 0.0635 | 0.0864 | 0001498710 | 0001048911 | 0001128281 |
12 | remainder_ComprehensiveNetIncome | -0.00754 | -0.00687 | -0.00110 | 0.0126 | 0.0212 | 0001048911 | 0001158463 | 0000100517 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.386 | -0.351 | 0.186 | 0.607 | 0.683 | 0000006201 | 0001158463 | 0001128281 |
1 | Assets | -0.0314 | -0.0300 | 0.00254 | 0.122 | 0.127 | 0001128281 | 0001048911 | 0000350403 |
2 | Expenses | -1.35 | -0.989 | -0.0292 | 0.298 | 0.352 | 0001128281 | 0000350403 | 0001135185 |
3 | Revenues | -0.397 | -0.358 | 0.0347 | 1.02 | 1.25 | 0000350403 | 0001158463 | 0001128281 |
4 | StockholdersEquity | -0.299 | -0.250 | 0.0460 | 0.276 | 0.332 | 0000006201 | 0001048911 | 0001498710 |
5 | NetIncome | -0.424 | -0.246 | 0.0450 | 0.175 | 0.193 | 0000350403 | 0000100517 | 0001048911 |
6 | ComprehensiveNetIncome | -0.430 | -0.249 | 0.0552 | 0.169 | 0.185 | 0000350403 | 0001135185 | 0001048911 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001128281 | 0000006201 |
8 | EconomicCapitalRatio | -0.568 | -0.546 | 0.142 | 0.407 | 0.450 | 0000350403 | 0000100517 | 0001048911 |
2019
Logs
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Ignoring company because Assets is zero | pre-agg |
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 | LiabilitiesCurrent | 1,281,340 | 27,037,675 | 1,113,594,956 | 19,257,500,000 | 20,204,000,000 | 0001128281 | 0001498710 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 399,930 | 35,386,000,000 | 41,802,000,000 | 0000100517 | 0001128281 | 0000006201 |
2 | remainder_Liabilities | 0 | 0 | 0 | 16,458,882 | 32,917,765 | 0000006201 | 0001128281 | 0000353184 |
3 | AssetsCurrent | 5,210,212 | 38,279,162 | 1,385,843,557 | 10,667,500,000 | 13,086,000,000 | 0001128281 | 0001498710 | 0001048911 |
4 | AssetsNoncurrent | 491,328 | 493,352 | 1,406,501,548 | 36,538,500,000 | 56,283,000,000 | 0000353184 | 0001498710 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | 323,316 | 2,570,614 | 4,057,786,774 | 33,152,500,000 | 34,995,000,000 | 0001128281 | 0001135185 | 0000006201 |
6 | remainder_Assets | -31,310,000,000 | -15,655,000,000 | 1,265,768 | 511,908,000 | 721,215,000 | 0000027904 | 0001128281 | 0001498710 |
7 | OperatingExpenses | 0 | 0 | 2,935,911,621 | 41,692,000,000 | 44,900,000,000 | 0000353184 | 0001498710 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 225,563,736 | 2,976,500,000 | 3,353,000,000 | 0001128281 | 0001498710 | 0001048911 |
9 | remainder_Expenses | 10,919,163 | 31,451,582 | 504,401,735 | 11,694,000,000 | 17,089,000,000 | 0001128281 | 0001158463 | 0001048911 |
10 | remainder_Revenues | 11,567,725 | 130,701,102 | 3,834,763,500 | 58,350,000,000 | 69,693,000,000 | 0001128281 | 0001498710 | 0001048911 |
11 | remainder_NetIncome | -3,811,000,000 | -2,310,000,000 | -31,990,481 | 994,541 | 1,970,000 | 0001048911 | 0001158463 | 0000899394 |
12 | remainder_ComprehensiveNetIncome | -435,000,000 | -361,000,000 | 0 | 45,000,000 | 85,000,000 | 0000006201 | 0000899394 | 0000100517 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 1,681,073 | 43,994,723 | 2,663,930,462 | 54,643,500,000 | 60,113,000,000 | 0001128281 | 0001158463 | 0000006201 |
1 | Assets | 7,257,417 | 61,199,777 | 7,048,286,588 | 62,263,500,000 | 64,532,000,000 | 0001128281 | 0001498710 | 0000027904 |
2 | Expenses | 10,919,163 | 127,095,560 | 3,434,722,340 | 54,307,500,000 | 65,342,000,000 | 0001128281 | 0001498710 | 0001048911 |
3 | Revenues | 11,567,725 | 130,701,102 | 3,834,763,500 | 58,350,000,000 | 69,693,000,000 | 0001128281 | 0001498710 | 0001048911 |
4 | StockholdersEquity | -118,000,000 | -56,211,828 | 3,054,287,960 | 41,531,500,000 | 45,390,000,000 | 0000006201 | 0001172222 | 0001048911 |
5 | NetIncome | -293,113,000 | -156,163,500 | 335,423,781 | 3,888,000,000 | 4,767,000,000 | 0001135185 | 0001498710 | 0000027904 |
6 | ComprehensiveNetIncome | -292,352,500 | -155,783,250 | 324,760,774 | 3,858,375,000 | 4,644,000,000 | 0001135185 | 0001048911 | 0000027904 |
7 | BaseVar | 30,351,110 | 352,106,388 | 12,515,598,307 | 177,796,350,000 | 191,710,950,000 | 0001128281 | 0001498710 | 0001048911 |
8 | EconomicCapitalRatio | -0.0232 | 0.0133 | 0.739 | 0.942 | 0.967 | 0000899394 | 0001048911 | 0001128281 |
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 | LiabilitiesCurrent | -0.0951 | -0.0896 | -0.00971 | 0.244 | 0.281 | 0001172222 | 0001135185 | 0001128281 |
1 | LiabilitiesNonCurrent | -0.341 | -0.289 | 0.199 | 0.333 | 0.344 | 0000006201 | 0001498710 | 0001128281 |
2 | remainder_Liabilities | -0.206 | -0.100 | 0.0130 | 0.0261 | 0.0292 | 0000353184 | 0001498710 | 0001128281 |
3 | AssetsCurrent | -0.0444 | -0.0387 | -0.00476 | 0.0408 | 0.0581 | 0000006201 | 0001158463 | 0000353184 |
4 | AssetsNoncurrent | -0.186 | -0.134 | -0.00708 | 0.208 | 0.398 | 0000353184 | 0001172222 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | -0.324 | -0.188 | 0.0114 | 0.147 | 0.236 | 0000353184 | 0001498710 | 0001135185 |
6 | remainder_Assets | -0.146 | -0.0737 | 0.000642 | 0.103 | 0.191 | 0000027904 | 0001158463 | 0000353184 |
7 | OperatingExpenses | -0.755 | -0.738 | -0.368 | 2.83 | 2.85 | 0000100517 | 0001498710 | 0001128281 |
8 | DepreciationDepletionAndAmortization | -0.124 | -0.0864 | -0.0240 | 0.156 | 0.228 | 0000899394 | 0001498710 | 0001128281 |
9 | remainder_Expenses | -3.93 | -3.82 | 0.445 | 0.736 | 0.768 | 0001128281 | 0000027904 | 0000100517 |
10 | remainder_Revenues | -0.419 | -0.336 | -0.0207 | 0.873 | 0.960 | 0001135185 | 0001172222 | 0001128281 |
11 | remainder_NetIncome | -0.223 | -0.120 | 0.00800 | 0.0613 | 0.0702 | 0001048911 | 0000027904 | 0001128281 |
12 | remainder_ComprehensiveNetIncome | -0.0241 | -0.0165 | 0.00360 | 0.00906 | 0.00932 | 0000353184 | 0001135185 | 0000100517 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.382 | -0.348 | 0.150 | 0.515 | 0.556 | 0000006201 | 0000353184 | 0001128281 |
1 | Assets | -0.335 | -0.222 | 0.0122 | 0.0931 | 0.142 | 0000353184 | 0000100517 | 0001135185 |
2 | Expenses | -0.857 | -0.854 | 0.0688 | 0.270 | 0.280 | 0000353184 | 0001158463 | 0000027904 |
3 | Revenues | -0.419 | -0.336 | -0.0207 | 0.873 | 0.960 | 0001135185 | 0001172222 | 0001128281 |
4 | StockholdersEquity | -0.552 | -0.418 | -0.0578 | 0.342 | 0.409 | 0000353184 | 0001135185 | 0001498710 |
5 | NetIncome | -0.278 | -0.244 | 0.0876 | 0.152 | 0.180 | 0000899394 | 0001172222 | 0001128281 |
6 | ComprehensiveNetIncome | -0.274 | -0.240 | 0.0849 | 0.156 | 0.189 | 0000899394 | 0001172222 | 0001128281 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
8 | EconomicCapitalRatio | -0.527 | -0.490 | 0.236 | 0.438 | 0.464 | 0000899394 | 0001048911 | 0001128281 |
2020
Logs
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
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 | LiabilitiesCurrent | 70,442,000 | 197,739,800 | 2,009,209,780 | 16,280,100,000 | 16,569,000,000 | 0000899394 | 0001158463 | 0000006201 |
1 | LiabilitiesNonCurrent | 0 | 0 | 75,278,257 | 53,531,950,000 | 54,535,000,000 | 0000100517 | 0000899394 | 0000027904 |
2 | remainder_Liabilities | 0 | 0 | 0 | 0 | 0 | 0000006201 | 0001048911 | 0000006201 |
3 | AssetsCurrent | 147,850,000 | 151,333,450 | 2,851,380,118 | 16,944,550,000 | 17,404,000,000 | 0000899394 | 0001158463 | 0000027904 |
4 | AssetsNoncurrent | 53,212,000 | 85,085,500 | 1,401,070,355 | 40,621,300,000 | 54,592,000,000 | 0000899394 | 0001498710 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | 149,391,000 | 627,751,800 | 6,258,656,565 | 32,748,950,000 | 33,608,000,000 | 0000899394 | 0001158463 | 0001048911 |
6 | remainder_Assets | -26,500,000,000 | -14,575,000,000 | 4,949,894 | 616,810,450 | 757,327,000 | 0000027904 | 0000810332 | 0001498710 |
7 | OperatingExpenses | 146,214,000 | 189,136,350 | 3,283,686,392 | 46,150,400,000 | 62,750,000,000 | 0000899394 | 0001158463 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 12,249,900 | 407,024,771 | 3,099,600,000 | 3,600,000,000 | 0001135185 | 0001158463 | 0001048911 |
9 | remainder_Expenses | -3,910,000,000 | -3,385,300,000 | 35,579,916 | 1,944,318,250 | 2,188,000,000 | 0000100517 | 0001172222 | 0000027904 |
10 | remainder_Revenues | 185,949,000 | 347,553,450 | 3,084,286,704 | 45,871,000,000 | 69,217,000,000 | 0000899394 | 0001135185 | 0001048911 |
11 | remainder_NetIncome | -3,118,000,000 | -2,823,250,000 | -145,651,080 | 578,550 | 1,974,000 | 0000027904 | 0001498710 | 0001135185 |
12 | remainder_ComprehensiveNetIncome | -1,049,000,000 | -924,350,000 | -5,312,420 | 578,750 | 914,000 | 0000027904 | 0000810332 | 0001135185 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 220,728,000 | 573,447,000 | 3,221,808,784 | 69,747,850,000 | 70,462,000,000 | 0000899394 | 0001135185 | 0000027904 |
1 | Assets | 350,453,000 | 868,617,650 | 10,906,918,957 | 72,843,550,000 | 73,537,000,000 | 0000899394 | 0001158463 | 0001048911 |
2 | Expenses | 145,059,000 | 293,277,750 | 3,493,553,276 | 48,813,550,000 | 67,183,000,000 | 0000899394 | 0001158463 | 0001048911 |
3 | Revenues | 185,949,000 | 347,553,450 | 3,084,286,704 | 45,871,000,000 | 69,217,000,000 | 0000899394 | 0001135185 | 0001048911 |
4 | StockholdersEquity | -6,867,000,000 | -3,718,473,750 | 2,618,151,249 | 55,826,500,000 | 63,193,000,000 | 0000006201 | 0001172222 | 0001048911 |
5 | NetIncome | -12,385,000,000 | -10,795,600,000 | -492,120,677 | 869,428,700 | 1,286,000,000 | 0000027904 | 0001498710 | 0001048911 |
6 | ComprehensiveNetIncome | -13,171,750,000 | -11,488,862,500 | -496,041,503 | 732,374,675 | 1,036,250,000 | 0000027904 | 0001498710 | 0001048911 |
7 | BaseVar | 667,545,750 | 1,489,935,218 | 14,140,794,507 | 166,722,477,500 | 200,043,650,000 | 0000899394 | 0001158463 | 0001048911 |
8 | EconomicCapitalRatio | -0.415 | -0.401 | 0.255 | 0.692 | 0.810 | 0000027904 | 0001158463 | 0001048911 |
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 | LiabilitiesCurrent | -0.0794 | -0.0620 | -0.00792 | 0.188 | 0.294 | 0001172222 | 0000006201 | 0001048911 |
1 | LiabilitiesNonCurrent | -0.213 | -0.201 | 0.0196 | 0.369 | 0.501 | 0000006201 | 0001172222 | 0001048911 |
2 | remainder_Liabilities | 0 | 0 | 0 | 0 | 0 | 0000006201 | 0001048911 | 0000006201 |
3 | AssetsCurrent | -0.0711 | -0.0683 | 0.00235 | 0.0582 | 0.0676 | 0000006201 | 0000100517 | 0001172222 |
4 | AssetsNoncurrent | -0.0749 | -0.0692 | -0.0108 | 0.288 | 0.497 | 0001135185 | 0001048911 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | -0.149 | -0.119 | 0.0155 | 0.138 | 0.150 | 0000027904 | 0001498710 | 0001158463 |
6 | remainder_Assets | -0.218 | -0.119 | 0.00587 | 0.0379 | 0.0427 | 0000027904 | 0000810332 | 0001498710 |
7 | OperatingExpenses | -1.13 | -0.753 | -0.0470 | 0.564 | 0.607 | 0001048911 | 0000899394 | 0001135185 |
8 | DepreciationDepletionAndAmortization | -0.0843 | -0.0624 | -0.0216 | 0.112 | 0.140 | 0000899394 | 0001498710 | 0001135185 |
9 | remainder_Expenses | -0.751 | -0.528 | 0.0551 | 0.260 | 0.269 | 0001135185 | 0000006201 | 0000100517 |
10 | remainder_Revenues | -0.311 | -0.287 | -0.101 | 0.969 | 1.47 | 0000027904 | 0001498710 | 0001048911 |
11 | remainder_NetIncome | -0.0955 | -0.0758 | 0.00603 | 0.0805 | 0.0908 | 0000100517 | 0001172222 | 0001048911 |
12 | remainder_ComprehensiveNetIncome | -0.0182 | -0.0159 | 0.00682 | 0.00986 | 0.0102 | 0000027904 | 0000810332 | 0001135185 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.223 | -0.203 | 0.0245 | 0.453 | 0.662 | 0000006201 | 0001172222 | 0001048911 |
1 | Assets | -0.115 | -0.0993 | -0.0377 | 0.174 | 0.181 | 0000006201 | 0000810332 | 0001172222 |
2 | Expenses | -1.06 | -0.627 | 0.0347 | 0.178 | 0.223 | 0001048911 | 0001498710 | 0000810332 |
3 | Revenues | -0.311 | -0.287 | -0.101 | 0.969 | 1.47 | 0000027904 | 0001498710 | 0001048911 |
4 | StockholdersEquity | -0.356 | -0.327 | -0.108 | 0.358 | 0.391 | 0000006201 | 0001048911 | 0001498710 |
5 | NetIncome | -0.332 | -0.294 | -0.0873 | 0.519 | 0.532 | 0001172222 | 0001498710 | 0000899394 |
6 | ComprehensiveNetIncome | -0.331 | -0.298 | -0.0898 | 0.527 | 0.542 | 0001172222 | 0001498710 | 0000899394 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
8 | EconomicCapitalRatio | -0.639 | -0.625 | 0.0302 | 0.467 | 0.586 | 0000027904 | 0001158463 | 0001048911 |
2021
Logs
warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
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 | LiabilitiesCurrent | 752,684 | 7,336,421 | 1,205,530,348 | 18,969,500,000 | 20,966,000,000 | 0001128281 | 0001498710 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 4,579,976 | 13,561,886,750 | 47,606,000,000 | 0000092380 | 0000353184 | 0000027904 |
2 | remainder_Liabilities | 0 | 0 | 0 | 143,839,000 | 328,000,000 | 0000027904 | 0001172222 | 0001670076 |
3 | AssetsCurrent | 4,194,715 | 80,379,179 | 1,181,944,533 | 20,893,500,000 | 21,834,000,000 | 0001128281 | 0001135185 | 0000100517 |
4 | AssetsNoncurrent | 387,860 | 752,465 | 340,490,258 | 33,963,500,000 | 56,519,000,000 | 0001128281 | 0001172222 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | 269,261 | 1,535,815 | 1,577,217,664 | 32,993,500,000 | 35,752,000,000 | 0001128281 | 0001172222 | 0001048911 |
6 | remainder_Assets | -28,749,000,000 | -7,187,250,000 | 53,670,419 | 882,286,750 | 970,000,000 | 0000027904 | 0001172222 | 0000092380 |
7 | OperatingExpenses | 0 | 0 | 1,547,895,427 | 40,095,000,000 | 74,193,000,000 | 0000353184 | 0001172222 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 68,974,742 | 2,813,750,000 | 3,800,000,000 | 0001128281 | 0000810332 | 0001048911 |
9 | remainder_Expenses | -3,283,000,000 | -2,769,250,000 | 2,506,409 | 1,677,225,750 | 2,052,903,000 | 0000100517 | 0001128281 | 0001135185 |
10 | remainder_Revenues | 0 | 4,036,924 | 1,830,690,000 | 43,414,000,000 | 83,959,000,000 | 0001819516 | 0001670076 | 0001048911 |
11 | remainder_NetIncome | -1,535,000,000 | -1,499,750,000 | -33,869,330 | 213,908,500 | 817,000,000 | 0000100517 | 0001670076 | 0001048911 |
12 | remainder_ComprehensiveNetIncome | -297,000 | -74,250 | 518,293 | 861,750,000 | 1,908,000,000 | 0001779128 | 0000353184 | 0000027904 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 1,137,927 | 39,408,232 | 1,260,265,149 | 30,871,000,000 | 68,572,000,000 | 0001128281 | 0001498710 | 0000027904 |
1 | Assets | 5,601,836 | 106,962,959 | 4,433,654,180 | 75,038,500,000 | 82,777,000,000 | 0001128281 | 0001172222 | 0001048911 |
2 | Expenses | 58,000 | 3,719,628 | 1,887,543,603 | 40,984,500,000 | 79,545,000,000 | 0001819516 | 0001670076 | 0001048911 |
3 | Revenues | 0 | 4,036,924 | 1,830,690,000 | 43,414,000,000 | 83,959,000,000 | 0001819516 | 0001670076 | 0001048911 |
4 | StockholdersEquity | 4,463,909 | 17,099,977 | 1,775,892,164 | 54,682,500,000 | 69,117,000,000 | 0001128281 | 0001135185 | 0001048911 |
5 | NetIncome | -1,964,000,000 | -845,408,000 | 335,268 | 2,040,500,000 | 5,231,000,000 | 0000100517 | 0001128281 | 0001048911 |
6 | ComprehensiveNetIncome | -1,816,250,000 | -808,422,125 | 335,268 | 2,668,812,500 | 5,542,250,000 | 0000100517 | 0001128281 | 0001048911 |
7 | BaseVar | 15,567,386 | 274,184,834 | 7,791,946,798 | 165,282,775,000 | 237,664,900,000 | 0001128281 | 0001670076 | 0001048911 |
8 | EconomicCapitalRatio | -0.0539 | -0.00739 | 0.492 | 1.12 | 1.16 | 0000353184 | 0001135185 | 0001128281 |
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 | LiabilitiesCurrent | -0.472 | -0.159 | 0.0476 | 0.374 | 0.406 | 0001819516 | 0001743907 | 0001128281 |
1 | LiabilitiesNonCurrent | -0.351 | -0.323 | 0.114 | 0.322 | 0.369 | 0000027904 | 0000353184 | 0001048911 |
2 | remainder_Liabilities | -0.358 | -0.182 | 0.0353 | 0.0838 | 0.0949 | 0000353184 | 0001172222 | 0001048911 |
3 | AssetsCurrent | -0.122 | -0.115 | -0.0355 | 0.362 | 0.981 | 0001670076 | 0000100517 | 0001779128 |
4 | AssetsNoncurrent | -0.138 | -0.0799 | -0.00827 | 0.306 | 0.392 | 0000353184 | 0001819516 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | -0.305 | -0.206 | 0.0149 | 0.176 | 0.284 | 0000353184 | 0000092380 | 0000810332 |
6 | remainder_Assets | -0.180 | -0.0765 | -0.00525 | 0.0988 | 0.149 | 0000027904 | 0001128281 | 0001819516 |
7 | OperatingExpenses | -1.68 | -0.928 | -0.252 | 1.62 | 1.74 | 0001048911 | 0000027904 | 0001128281 |
8 | DepreciationDepletionAndAmortization | -0.116 | -0.0955 | -0.0178 | 0.113 | 0.163 | 0000899394 | 0001048911 | 0001128281 |
9 | remainder_Expenses | -2.79 | -2.66 | 0.313 | 0.565 | 0.619 | 0001128281 | 0000027904 | 0000899394 |
10 | remainder_Revenues | -0.567 | -0.477 | 0.0246 | 1.09 | 1.21 | 0001819516 | 0001498710 | 0001048911 |
11 | remainder_NetIncome | -0.191 | -0.170 | 0.0166 | 0.190 | 0.288 | 0001779128 | 0001819516 | 0001128281 |
12 | remainder_ComprehensiveNetIncome | -0.0159 | -0.0109 | -0.00695 | 0.0325 | 0.0398 | 0001128281 | 0000810332 | 0000027904 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.420 | -0.340 | 0.103 | 0.657 | 0.663 | 0001819516 | 0001779128 | 0001048911 |
1 | Assets | -0.435 | -0.194 | 0.0101 | 0.354 | 0.357 | 0000353184 | 0000899394 | 0001819516 |
2 | Expenses | -1.14 | -0.995 | -0.0517 | 0.283 | 0.539 | 0001048911 | 0001172222 | 0001819516 |
3 | Revenues | -0.567 | -0.477 | 0.0246 | 1.09 | 1.21 | 0001819516 | 0001498710 | 0001048911 |
4 | StockholdersEquity | -0.616 | -0.384 | -0.0900 | 0.334 | 0.432 | 0000353184 | 0000899394 | 0001779128 |
5 | NetIncome | -0.481 | -0.302 | -0.00775 | 0.522 | 0.712 | 0001779128 | 0000027904 | 0000899394 |
6 | ComprehensiveNetIncome | -0.490 | -0.311 | -0.00136 | 0.507 | 0.703 | 0001779128 | 0000810332 | 0000899394 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001135185 | 0000027904 |
8 | EconomicCapitalRatio | -0.535 | -0.488 | 0.0112 | 0.642 | 0.677 | 0000353184 | 0001135185 | 0001128281 |
2022
Logs
error | 1 × IME and Company effects mismatched for Operating Expenses. IME Effects: 46.4, Company Effect: 46.5 | subcommand.report | |
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
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 | LiabilitiesCurrent | 1,130,400 | 17,690,190 | 1,257,976,318 | 18,357,100,000 | 25,940,000,000 | 0001128281 | 0001819516 | 0000027904 |
1 | LiabilitiesNonCurrent | 0 | 0 | 11,531,962 | 15,517,267,050 | 39,766,000,000 | 0000092380 | 0001779128 | 0000027904 |
2 | remainder_Liabilities | 0 | 0 | 0 | 262,926,500 | 304,000,000 | 0000027904 | 0001172222 | 0001670076 |
3 | AssetsCurrent | 6,870,063 | 85,762,472 | 1,072,595,393 | 16,752,950,000 | 20,365,000,000 | 0001128281 | 0001135185 | 0001048911 |
4 | AssetsNoncurrent | 0 | 6,750,250 | 322,366,507 | 38,646,650,000 | 59,277,000,000 | 0001128281 | 0001172222 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | 42,862 | 1,339,052 | 1,331,424,790 | 34,852,700,000 | 38,091,000,000 | 0001128281 | 0001172222 | 0001048911 |
6 | remainder_Assets | -33,109,000,000 | -11,588,150,000 | 237,280,819 | 780,136,300 | 970,000,000 | 0000027904 | 0001135185 | 0000092380 |
7 | OperatingExpenses | 0 | 0 | 2,006,365,706 | 55,726,800,000 | 83,019,000,000 | 0000353184 | 0001172222 | 0001048911 |
8 | DepreciationDepletionAndAmortization | 0 | 0 | 66,790,716 | 2,759,050,000 | 3,970,000,000 | 0001128281 | 0001743907 | 0001048911 |
9 | remainder_Expenses | 7,166,183 | 16,641,764 | 215,194,816 | 3,191,384,350 | 4,379,000,000 | 0001128281 | 0001172222 | 0000027904 |
10 | remainder_Revenues | 7,598,597 | 97,637,509 | 2,984,523,653 | 65,607,500,000 | 93,512,000,000 | 0001128281 | 0001670076 | 0001048911 |
11 | remainder_NetIncome | -1,747,000,000 | -1,488,300,000 | -46,204,258 | 11,940,600 | 25,497,000 | 0000027904 | 0001743907 | 0001779128 |
12 | remainder_ComprehensiveNetIncome | -371,000,000 | -158,450,000 | -31,917 | 467,750,000 | 1,329,000,000 | 0001048911 | 0000899394 | 0000027904 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 1,130,400 | 33,244,040 | 1,634,040,141 | 32,275,200,000 | 65,706,000,000 | 0001128281 | 0001819516 | 0000027904 |
1 | Assets | 6,912,925 | 137,358,874 | 4,319,778,690 | 77,085,100,000 | 85,994,000,000 | 0001128281 | 0001670076 | 0001048911 |
2 | Expenses | 7,166,183 | 112,677,314 | 3,081,011,581 | 61,804,000,000 | 88,337,000,000 | 0001128281 | 0001670076 | 0001048911 |
3 | Revenues | 7,598,597 | 97,637,509 | 2,984,523,653 | 65,607,500,000 | 93,512,000,000 | 0001128281 | 0001670076 | 0001048911 |
4 | StockholdersEquity | 5,782,525 | 25,734,584 | 1,767,412,889 | 41,346,150,000 | 71,720,000,000 | 0001128281 | 0001172222 | 0001048911 |
5 | NetIncome | -555,547,000 | -554,638,950 | 6,751,085 | 2,195,800,000 | 3,826,000,000 | 0001819516 | 0000353184 | 0001048911 |
6 | ComprehensiveNetIncome | -562,796,500 | -557,207,475 | 6,420,979 | 2,746,300,000 | 3,547,750,000 | 0001819516 | 0000353184 | 0001048911 |
7 | BaseVar | 21,937,498 | 393,947,157 | 10,472,707,660 | 211,909,785,000 | 261,238,350,000 | 0001128281 | 0001670076 | 0001048911 |
8 | EconomicCapitalRatio | -0.650 | -0.201 | 0.440 | 1.07 | 1.43 | 0001819516 | 0001158463 | 0001128281 |
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 | LiabilitiesCurrent | -0.0916 | -0.0890 | 0.00536 | 0.239 | 0.297 | 0000092380 | 0001498710 | 0001128281 |
1 | LiabilitiesNonCurrent | -0.286 | -0.268 | 0.0880 | 0.299 | 0.359 | 0000027904 | 0000353184 | 0001128281 |
2 | remainder_Liabilities | -0.569 | -0.206 | 0.0465 | 0.112 | 0.135 | 0000353184 | 0001172222 | 0001128281 |
3 | AssetsCurrent | -0.300 | -0.168 | -0.0478 | 0.136 | 0.261 | 0001128281 | 0001498710 | 0001779128 |
4 | AssetsNoncurrent | -0.118 | -0.0828 | -0.0269 | 0.322 | 0.427 | 0001819516 | 0001172222 | 0000027904 |
5 | PropertyPlantAndEquipmentNet | -0.207 | -0.169 | 0.0472 | 0.208 | 0.211 | 0001819516 | 0000092380 | 0001158463 |
6 | remainder_Assets | -0.190 | -0.0759 | 0.00281 | 0.148 | 0.181 | 0000027904 | 0001498710 | 0001819516 |
7 | OperatingExpenses | -1.74 | -1.20 | -0.343 | 1.63 | 2.16 | 0001048911 | 0000027904 | 0001128281 |
8 | DepreciationDepletionAndAmortization | -0.143 | -0.0913 | -0.0118 | 0.110 | 0.148 | 0000899394 | 0000027904 | 0001128281 |
9 | remainder_Expenses | -2.64 | -2.06 | 0.615 | 1.04 | 1.33 | 0001128281 | 0001670076 | 0001048911 |
10 | remainder_Revenues | -0.447 | -0.341 | -0.000174 | 0.674 | 0.746 | 0001779128 | 0000353184 | 0001048911 |
11 | remainder_NetIncome | -0.0920 | -0.0910 | -0.0453 | 0.344 | 0.436 | 0001172222 | 0001135185 | 0001128281 |
12 | remainder_ComprehensiveNetIncome | -0.0166 | -0.0134 | -0.00279 | 0.0284 | 0.0313 | 0001048911 | 0001158463 | 0000027904 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.325 | -0.290 | 0.104 | 0.544 | 0.658 | 0000027904 | 0000092380 | 0001128281 |
1 | Assets | -0.239 | -0.131 | 0.0206 | 0.115 | 0.127 | 0001819516 | 0001158463 | 0001779128 |
2 | Expenses | -0.456 | -0.419 | -0.0352 | 0.270 | 0.270 | 0001048911 | 0000092380 | 0000027904 |
3 | Revenues | -0.447 | -0.341 | -0.000174 | 0.674 | 0.746 | 0001779128 | 0000353184 | 0001048911 |
4 | StockholdersEquity | -0.317 | -0.281 | 0.0938 | 0.338 | 0.355 | 0001819516 | 0001128281 | 0001779128 |
5 | NetIncome | -0.695 | -0.450 | 0.0502 | 0.493 | 0.738 | 0001819516 | 0000027904 | 0001128281 |
6 | ComprehensiveNetIncome | -0.707 | -0.437 | 0.0525 | 0.490 | 0.734 | 0001819516 | 0000092380 | 0001128281 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001158463 | 0000027904 |
8 | EconomicCapitalRatio | -1.07 | -0.619 | 0.0220 | 0.654 | 1.01 | 0001819516 | 0001158463 | 0001128281 |
Estimates
Parameter | Value | Min | Max |
---|---|---|---|
PresentValueFactor | 2.3 | 1.0 | 15.0 |
BalanceFactor | 0.5 | 0.5 | 5.0 |
OCIFactor | 0.75 | 0.5 | 1.0 |
HiddenReservesFactor | 0.0 | 0.0 | 0.0 |
LLPO_stddev | 0.38 | 0.2 | 10.0 |