QA: us_air 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
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
0001586300

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
0000766421
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000766421
warning 1 × Ignoring company because Assets is zero pre-agg
0000766421

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
0000766421

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
0000353184 0001819516
warning 1 × Ignoring company because Expenses is zero pre-agg
0000766421

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
0001135185
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000353184
warning 1 × Ignoring company because Expenses is zero pre-agg
0000766421

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