QA: us_air 2010-2025

Table of Contents

Ranks across the years

name name_short 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2010-val 2011-val 2012-val 2013-val 2014-val 2015-val 2016-val 2017-val 2018-val 2019-val 2020-val 2021-val 2022-val 2023-val 2024-val 2025-val 2010->2011 2011->2012 2012->2013 2013->2014 2014->2015 2015->2016 2016->2017 2017->2018 2018->2019 2019->2020 2020->2021 2021->2022 2022->2023 2023->2024 2024->2025
0001779128 Strata Critical Medical Inc Strata NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 8 4 5 2 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 87.28 91.80 72.94 90.04 123.50 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 1 -3 -1
0001128281 Saker Aviation Services Inc Saker A NaN NaN 9 NaN 10 10 5 6 2 2 NaN 1 1 1 1 2 NaN NaN 80.77 NaN 68.65 90.95 99.84 105.22 109.40 104.81 NaN 114.20 128.86 127.43 127.88 102.01 NaN NaN NaN NaN 0 -5 1 -4 0 NaN NaN 0 0 0 1
0001158463 Jetblue Airways CORP Jetblue 2 5 6 6 5 7 4 4 4 4 3 6 7 3 3 3 103.33 98.34 95.77 93.19 97.04 99.49 102.96 106.33 95.15 100.03 84.09 89.25 83.81 86.98 87.33 84.96 3 1 0 -1 2 -3 0 0 0 -1 3 1 -4 0 0
0000092380 Southwest Airlines CO Southwe 3 7 7 7 7 9 6 5 NaN NaN NaN 5 6 4 5 4 103.04 92.00 93.99 91.20 90.77 91.63 99.53 106.16 NaN NaN NaN 94.78 88.04 83.15 81.17 80.28 4 0 0 0 2 -3 -1 NaN NaN NaN NaN 1 -2 1 -1
0001525221 Bristow Group Inc Bristow NaN NaN NaN 10 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 5 NaN NaN NaN 67.02 66.58 NaN NaN NaN NaN NaN NaN NaN NaN NaN 65.99 71.67 NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1
0001743907 Sun Country Airlines Holdings Inc Sun Cou NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 10 6 7 6 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 63.30 56.65 59.58 60.68 62.16 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 -4 1 -1
0000027904 Delta AIR Lines INC Delta A 8 18 NaN 8 16 14 12 10 9 7 10 15 11 7 9 7 36.68 34.01 NaN 70.63 43.57 55.96 57.95 57.98 55.42 56.95 32.24 39.13 42.66 50.15 52.52 57.61 10 NaN NaN 8 -2 -2 -2 -1 -2 3 5 -4 -4 2 -2
0001362468 Allegiant Travel CO Allegia NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 8 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 44.11 49.24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2
0001670076 Frontier Group Holdings Inc Frontie NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14 12 8 11 9 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 39.28 40.28 40.13 41.67 36.09 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 -4 3 -2
0001819516 Wheels Up Experience Inc Wheels NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 12 13 9 12 10 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 58.93 30.87 27.76 27.12 24.28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 -4 3 -2
0000004515 American Airlines INC America 7 12 13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 66.33 61.74 61.06 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000006201 American Airlines Group Inc America 6 11 10 15 17 13 13 11 11 10 11 NaN NaN NaN NaN NaN 78.94 68.07 70.68 33.59 40.79 56.90 43.79 42.69 36.12 36.41 31.59 NaN NaN NaN NaN NaN 5 -1 5 2 -4 0 -2 0 -1 1 NaN NaN NaN NaN NaN
0000073887 Bristow Group Inc Bristow 1 1 1 2 1 4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 124.36 124.98 118.54 120.24 114.78 106.83 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 0 1 -1 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000100517 United Airlines Holdings Inc United 5 13 NaN 11 9 3 9 8 5 6 4 9 NaN NaN NaN NaN 84.54 58.45 NaN 63.22 83.21 107.21 91.54 91.26 92.13 94.12 80.05 85.73 NaN NaN NaN NaN 8 NaN NaN -2 -6 6 -1 -3 1 -2 5 NaN NaN NaN NaN
0001048911 Fedex CORP Fedex C 4 3 3 3 3 6 3 3 1 3 1 2 2 NaN NaN NaN 101.92 106.53 103.06 109.33 111.75 104.88 104.96 109.95 110.70 102.14 106.83 110.62 107.06 NaN NaN NaN -1 0 0 0 3 -3 0 -2 2 -2 1 0 NaN NaN NaN
0000230211 Federal Express CORP Federal NaN 4 4 5 4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 102.77 101.31 95.84 98.59 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 1 -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000350403 PHI Group Inc DE PHI Gro NaN 2 2 1 NaN 1 1 1 8 NaN NaN NaN NaN NaN NaN NaN NaN 120.73 109.29 123.01 NaN 122.25 118.35 119.32 58.44 NaN NaN NaN NaN NaN NaN NaN NaN 0 -1 NaN NaN 0 0 7 NaN NaN NaN NaN NaN NaN NaN
0000701345 US Airways Group INC US Airw NaN 17 16 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 35.93 46.36 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000816159 AIR Methods CORP AIR Met NaN 14 14 13 12 11 10 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 57.09 59.98 58.91 64.49 66.06 60.79 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 -1 -1 -1 -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000894081 Air Transport Services Group Inc Air Tra NaN 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 8 NaN NaN 54.31 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 60.35 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000914397 Great Lakes Aviation LTD Great L NaN 9 11 9 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 75.72 69.13 67.59 54.97 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 -2 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001135185 Atlas AIR Worldwide Holdings INC Atlas A NaN 10 12 12 13 12 11 9 7 8 7 10 9 NaN NaN NaN NaN 70.81 65.79 60.41 59.70 57.55 58.93 62.75 64.01 50.29 65.18 71.24 70.58 NaN NaN NaN NaN 2 0 1 -1 -1 -2 -2 1 -1 3 -1 NaN NaN NaN
0001172222 Hawaiian Holdings INC Hawaiia NaN 8 8 NaN 8 8 7 7 6 5 5 7 8 NaN NaN NaN NaN 82.75 83.68 NaN 85.48 93.92 94.97 99.88 91.09 96.17 75.38 88.66 81.79 NaN NaN NaN NaN 0 NaN NaN 0 -1 0 -1 -1 0 2 1 NaN NaN NaN
0001498710 Spirit Aviation Holdings Inc Spirit NaN 6 5 4 2 2 2 2 3 1 2 4 3 2 4 NaN NaN 97.15 99.41 105.47 111.99 116.52 112.78 117.48 105.95 109.03 94.97 95.70 92.04 93.27 82.34 NaN NaN -1 -1 -2 0 0 0 1 -2 1 2 -1 -1 2 NaN
0001514226 Delta Tucker Holdings Inc Delta T NaN 16 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 45.64 48.40 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000842722 Fuse Science Inc Fuse Sc NaN NaN 17 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.00 0.00 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000353184 AIR T INC AIR T I NaN NaN NaN 16 6 5 8 NaN 10 NaN 9 16 NaN NaN NaN NaN NaN NaN NaN 0.00 96.61 105.57 92.20 NaN 54.27 NaN 53.65 37.36 NaN NaN NaN NaN NaN NaN NaN -10 -1 3 NaN NaN NaN NaN 7 NaN NaN NaN NaN
0001159154 Republic Airways Holdings INC Republi NaN NaN NaN 14 15 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 45.73 47.40 43.84 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000899394 Harbor Diversified INC Harbor NaN NaN NaN NaN NaN NaN NaN NaN NaN 9 6 3 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 44.97 69.92 95.98 91.03 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3 -3 2 NaN NaN NaN
0000810332 Republic Airways Holdings INC Republi NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 8 13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 56.08 57.50 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 NaN NaN NaN NaN
0001846084 Global Crossing Airlines Group Inc Global NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 26.99 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

PDF reports

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

2010

Logs

warning 10 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 9 × The stock price does not exist industry.us_generic
warning 2 × Missing logo subcommand.report
warning 1 × Ignoring company because ECR is too negative 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 166,115,000 487,724,750 6,715,394,500 12,204,000,000 12,645,000,000 0000073887 0000006201 0000100517
1 LiabilitiesNonCurrent 0 0 0 20,088,900,000 30,906,000,000 0000004515 0000100517 0000027904
2 remainder_Liabilities 0 0 0 0 0 0000004515 0000092380 0000004515
3 AssetsCurrent 516,371,000 811,641,150 6,791,065,800 10,386,700,000 12,045,000,000 0000073887 0000006201 0000100517
4 AssetsNoncurrent 22,286,000 152,385,900 873,221,200 2,214,650,000 2,236,000,000 0000073887 0000027904 0000006201
5 PropertyPlantAndEquipmentNet 1,719,345,000 2,741,924,250 13,363,931,500 19,130,300,000 20,307,000,000 0000073887 0001048911 0000027904
6 remainder_Assets 0 69,300,000 1,169,509,100 12,915,500,000 14,543,000,000 0000092380 0000006201 0000027904
7 OperatingExpenses 0 1,066,450,000 18,042,766,800 25,157,350,000 26,032,000,000 0000073887 0000006201 0001048911
8 DepreciationDepletionAndAmortization 0 77,000,000 1,007,100,800 1,801,550,000 1,958,000,000 0000073887 0000100517 0001048911
9 remainder_Expenses 243,000,000 539,039,100 2,917,368,300 5,205,750,000 5,456,000,000 0001158463 0000004515 0001048911
10 remainder_Revenues 0 0 586,215,554 30,707,250,000 34,734,000,000 0000004515 0000073887 0001048911
11 remainder_NetIncome -723,000,000 -506,350,000 1,821,767,330 27,118,150,000 30,146,000,000 0000100517 0001158463 0000027904
12 remainder_ComprehensiveNetIncome -1,067,000,000 -693,550,000 0 0 0 0001048911 0000073887 0000004515
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 166,115,000 487,724,750 6,715,394,500 31,914,900,000 42,291,000,000 0000073887 0000006201 0000027904
1 Assets 2,494,620,000 3,929,053,000 23,663,736,000 41,931,500,000 43,188,000,000 0000073887 0001048911 0000027904
2 Expenses 1,088,826,000 1,936,236,900 21,895,595,900 32,083,450,000 33,446,000,000 0000073887 0000004515 0001048911
3 Revenues 0 0 586,215,554 30,707,250,000 34,734,000,000 0000004515 0000073887 0001048911
4 StockholdersEquity 897,000,000 1,398,026,750 11,683,665,000 24,609,400,000 26,953,000,000 0000027904 0000092380 0000100517
5 NetIncome -471,000,000 -470,300,000 183,345,154 1,100,350,000 1,184,000,000 0000006201 0000100517 0001048911
6 ComprehensiveNetIncome -471,000,000 -470,300,000 183,345,154 841,925,000 945,000,000 0000006201 0000100517 0000092380
7 BaseVar 2,601,954,085 4,417,397,405 40,919,181,026 67,959,246,000 75,872,445,000 0000073887 0000004515 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability 0.0286 0.155 0.787 1.10 1.20 0000027904 0001048911 0000073887
9 EconomicCapitalRatio 0.367 0.471 0.932 1.17 1.24 0000027904 0001048911 0000073887

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.169 -0.149 0.0256 0.182 0.184 0000004515 0000092380 0001048911
1 LiabilitiesNonCurrent -0.455 -0.274 0.0740 0.117 0.128 0000027904 0001158463 0001048911
2 remainder_Liabilities 0 0 0 0 0 0000004515 0000092380 0000004515
3 AssetsCurrent -0.0710 -0.0512 -0.000211 0.0191 0.0261 0000027904 0001158463 0000100517
4 AssetsNoncurrent -0.0171 -0.0133 -0.00102 0.0164 0.0178 0000027904 0000092380 0000004515
5 PropertyPlantAndEquipmentNet -0.123 -0.104 -0.0259 0.0434 0.0562 0000027904 0000006201 0001158463
6 remainder_Assets -0.0322 -0.0292 -0.0130 0.0455 0.0515 0000004515 0001158463 0000100517
7 OperatingExpenses -0.504 -0.413 -0.0726 0.393 0.531 0001048911 0000100517 0000073887
8 DepreciationDepletionAndAmortization -0.0411 -0.0301 -0.00332 0.0290 0.0416 0001048911 0000004515 0000073887
9 remainder_Expenses -0.596 -0.451 0.0501 0.157 0.163 0000073887 0001048911 0000006201
10 remainder_Revenues -0.524 -0.517 -0.0585 0.728 0.830 0000006201 0000100517 0001048911
11 remainder_NetIncome -0.856 -0.747 -0.174 0.439 0.467 0001048911 0000027904 0000006201
12 remainder_ComprehensiveNetIncome -0.0259 -0.0162 0.00225 0.00244 0.00246 0001048911 0000073887 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.431 -0.310 0.0570 0.267 0.278 0000027904 0001158463 0001048911
1 Assets -0.103 -0.0961 -0.0166 0.0435 0.0477 0000027904 0000092380 0001158463
2 Expenses -0.476 -0.341 0.00153 0.107 0.121 0001048911 0000027904 0000073887
3 Revenues -0.524 -0.517 -0.0585 0.728 0.830 0000006201 0000100517 0001048911
4 StockholdersEquity -0.397 -0.327 -0.0110 0.330 0.393 0000027904 0000100517 0000073887
5 NetIncome -0.0470 -0.0461 -0.00671 0.0542 0.0542 0000004515 0001158463 0000092380
6 ComprehensiveNetIncome -0.0447 -0.0439 -0.00485 0.0565 0.0566 0000004515 0001048911 0000092380
7 BaseVar 0 0 0 0 0 0000004515 0000092380 0000004515
8 EconomicCapitalRatiobeforeLimitedLiability -0.507 -0.403 0.0590 0.297 0.370 0000027904 0001048911 0000073887
9 EconomicCapitalRatio -0.507 -0.403 0.0585 0.296 0.370 0000027904 0001048911 0000073887

2011

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 11 × The stock price does not exist industry.us_generic
warning 8 × Missing logo subcommand.report
warning 7 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 3 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Ignoring company because Expenses is zero pre-agg
warning 1 × Ignoring company because ECR is too negative 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 11,749,314 41,498,197 1,023,953,360 11,590,050,000 12,701,000,000 0000914397 0001158463 0000027904
1 LiabilitiesNonCurrent 0 0 0 16,188,500,000 32,194,000,000 0000004515 0001048911 0000027904
2 remainder_Liabilities 0 0 0 588,180,950 896,045,000 0000004515 0000092380 0001514226
3 AssetsCurrent 26,859,735 116,952,310 1,276,504,661 8,691,800,000 10,997,000,000 0000914397 0001158463 0000100517
4 AssetsNoncurrent 0 0 148,187,289 3,193,150,000 10,572,000,000 0001135185 0000701345 0000100517
5 PropertyPlantAndEquipmentNet 23,210,000 23,952,900 2,962,990,601 16,989,600,000 20,223,000,000 0001498710 0000701345 0000027904
6 remainder_Assets 0 0 253,916,403 4,158,850,000 14,545,000,000 0000100517 0001172222 0000027904
7 OperatingExpenses 0 0 2,536,831,844 29,568,600,000 31,714,000,000 0000073887 0001158463 0000100517
8 DepreciationDepletionAndAmortization 0 0 162,272,793 1,610,900,000 1,973,000,000 0000073887 0001158463 0001048911
9 remainder_Expenses 14,667,785 88,195,518 720,103,337 5,671,600,000 6,576,000,000 0000914397 0001135185 0001048911
10 remainder_Revenues 0 0 1,313,685,385 37,439,100,000 39,304,000,000 0000004515 0001135185 0001048911
11 remainder_NetIncome -1,206,000,000 -1,011,350,000 -10,646,180 23,187,900,000 23,278,000,000 0000027904 0000350403 0000004515
12 remainder_ComprehensiveNetIncome -1,209,000,000 -864,750,000 0 16,950,000 113,000,000 0000006201 0000701345 0000230211
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 46,748,000 47,506,591 1,484,714,391 27,778,550,000 44,895,000,000 0000350403 0001514226 0000027904
1 Assets 83,777,500 646,507,675 4,880,649,598 38,814,650,000 43,499,000,000 0000914397 0001158463 0000027904
2 Expenses 124,755,662 473,732,799 4,017,059,495 35,659,900,000 37,739,000,000 0000914397 0001158463 0001048911
3 Revenues 0 0 1,313,685,385 37,439,100,000 39,304,000,000 0000004515 0001135185 0001048911
4 StockholdersEquity -1,396,000,000 -178,683,516 1,070,284,532 16,310,750,000 22,503,000,000 0000027904 0001135185 0001048911
5 NetIncome -1,979,000,000 -1,967,100,000 73,733,262 943,700,000 1,452,000,000 0000006201 0001498710 0001048911
6 ComprehensiveNetIncome -2,583,500,000 -2,057,775,000 73,733,262 935,450,000 1,397,000,000 0000006201 0001498710 0001048911
7 BaseVar 210,119,754 968,502,484 7,484,518,382 74,068,454,000 82,700,680,000 0000914397 0001158463 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability 0.00155 0.0181 0.491 1.16 1.20 0000027904 0000914397 0000073887
9 EconomicCapitalRatio 0.340 0.356 0.733 1.21 1.25 0000027904 0000914397 0000073887

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.211 -0.137 -0.00458 0.125 0.155 0000004515 0000816159 0000350403
1 LiabilitiesNonCurrent -0.407 -0.363 0.120 0.197 0.203 0000027904 0000006201 0001048911
2 remainder_Liabilities -0.382 -0.342 0.0563 0.101 0.105 0000816159 0001158463 0001048911
3 AssetsCurrent -0.0685 -0.0573 -0.00457 0.0203 0.0674 0000027904 0001514226 0001498710
4 AssetsNoncurrent -0.0294 -0.0276 -0.00282 0.0291 0.126 0000701345 0000092380 0000100517
5 PropertyPlantAndEquipmentNet -0.298 -0.200 -0.0151 0.122 0.128 0001514226 0000004515 0001135185
6 remainder_Assets -0.0487 -0.0400 -0.00709 0.0508 0.124 0000100517 0000350403 0001514226
7 OperatingExpenses -0.619 -0.607 -0.175 0.529 0.579 0000230211 0000004515 0000350403
8 DepreciationDepletionAndAmortization -0.0569 -0.0423 -0.00373 0.0410 0.0413 0000894081 0000004515 0001498710
9 remainder_Expenses -1.39 -0.829 0.154 0.259 0.290 0001514226 0001172222 0000092380
10 remainder_Revenues -1.01 -0.936 0.113 0.696 0.727 0000006201 0000350403 0001048911
11 remainder_NetIncome -0.373 -0.367 -0.219 0.570 0.645 0001048911 0000100517 0001158463
12 remainder_ComprehensiveNetIncome -0.0262 -0.0114 0.00194 0.00407 0.00778 0000006201 0000092380 0000230211
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.395 -0.283 0.0493 0.326 0.347 0000027904 0000006201 0001048911
1 Assets -0.247 -0.239 -0.0310 0.0800 0.0855 0001514226 0001172222 0001135185
2 Expenses -0.415 -0.412 -0.0575 0.209 0.232 0000230211 0000092380 0000816159
3 Revenues -1.01 -0.936 0.113 0.696 0.727 0000006201 0000350403 0001048911
4 StockholdersEquity -0.437 -0.398 -0.00734 0.492 0.506 0000701345 0001135185 0000073887
5 NetIncome -0.114 -0.111 -0.00125 0.0908 0.0949 0000006201 0000100517 0000914397
6 ComprehensiveNetIncome -0.139 -0.113 -0.000997 0.0934 0.0975 0000006201 0000027904 0000914397
7 BaseVar 0 0 0 0 0 0000004515 0000350403 0000004515
8 EconomicCapitalRatiobeforeLimitedLiability -0.436 -0.420 -0.0438 0.437 0.473 0000027904 0000914397 0000073887
9 EconomicCapitalRatio -0.430 -0.414 -0.0378 0.443 0.479 0000027904 0000914397 0000073887

2012

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 9 × The stock price does not exist industry.us_generic
warning 8 × Missing logo subcommand.report
warning 6 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 1 × Ignoring company because Liabilities is zero pre-agg
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,184,615 2,206,958 653,834,118 9,826,800,000 11,918,000,000 0000842722 0001172222 0000004515
1 LiabilitiesNonCurrent 0 0 0 2,289,852,000 5,303,000,000 0000004515 0000350403 0000701345
2 remainder_Liabilities 0 0 0 680,677,400 832,575,000 0000004515 0000230211 0001514226
3 AssetsCurrent 573,979 2,814,988 736,863,075 7,468,800,000 9,056,000,000 0000842722 0000073887 0001048911
4 AssetsNoncurrent 0 0 46,376,822 2,134,200,000 2,167,000,000 0001128281 0000073887 0000006201
5 PropertyPlantAndEquipmentNet 93,880 1,766,262 1,723,557,022 13,944,800,000 17,248,000,000 0000842722 0000073887 0001048911
6 remainder_Assets -93,880 -18,776 308,208,557 1,401,400,000 2,387,000,000 0000842722 0001135185 0001048911
7 OperatingExpenses 0 0 1,080,686,782 23,282,400,000 30,912,000,000 0000073887 0001498710 0001048911
8 DepreciationDepletionAndAmortization 0 0 82,528,920 1,542,600,000 2,113,000,000 0000073887 0000816159 0001048911
9 remainder_Expenses 7,495,221 9,544,720 598,694,731 5,294,000,000 7,578,000,000 0000842722 0000350403 0001048911
10 remainder_Revenues 0 0 1,318,427,458 29,148,800,000 42,680,000,000 0000004515 0001498710 0001048911
11 remainder_NetIncome -219,000,000 -79,800,000 -79,274 24,476,600,000 24,511,000,000 0000701345 0001128281 0000006201
12 remainder_ComprehensiveNetIncome -2,403,000,000 -631,000,000 0 984,600,000 987,000,000 0001048911 0000842722 0000004515
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 1,184,615 3,137,411 1,525,094,861 9,826,800,000 11,918,000,000 0000842722 0001514226 0000004515
1 Assets 799,615 6,908,239 2,741,022,715 24,788,600,000 29,903,000,000 0000842722 0000073887 0001048911
2 Expenses 7,495,221 14,537,611 1,869,000,933 29,235,800,000 40,603,000,000 0000842722 0001172222 0001048911
3 Revenues 0 0 1,318,427,458 29,148,800,000 42,680,000,000 0000004515 0001498710 0001048911
4 StockholdersEquity -385,000 3,770,828 1,212,155,712 16,270,600,000 24,529,000,000 0000842722 0001172222 0001048911
5 NetIncome -1,926,000,000 -1,886,000,000 65,285,658 1,052,800,000 2,032,000,000 0000004515 0000073887 0001048911
6 ComprehensiveNetIncome -1,432,500,000 -1,393,700,000 50,747,955 737,300,000 830,500,000 0000004515 0000073887 0001048911
7 BaseVar 7,203,007 21,053,149 4,267,813,372 50,137,597,000 65,219,205,000 0000842722 0001135185 0001048911
8 EconomicCapitalRatiobeforeLimitedLiability -12.6 -2.41 0.604 1.03 1.13 0000842722 0001128281 0000073887
9 EconomicCapitalRatio 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000607 0.371 0.808 1.11 1.19 0000842722 0001128281 0000073887

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.219 -0.152 0.0346 0.124 0.131 0000004515 0000350403 0000914397
1 LiabilitiesNonCurrent -0.432 -0.355 0.0597 0.0928 0.0955 0001135185 0000350403 0001048911
2 remainder_Liabilities -0.446 -0.298 0.0621 0.104 0.106 0000816159 0000006201 0001048911
3 AssetsCurrent -0.0301 -0.0290 -0.00606 0.0328 0.0627 0000914397 0001135185 0001498710
4 AssetsNoncurrent -0.0176 -0.0162 -0.000611 0.0239 0.0263 0001514226 0000350403 0000004515
5 PropertyPlantAndEquipmentNet -0.277 -0.158 0.00000891 0.128 0.160 0001514226 0000842722 0001135185
6 remainder_Assets -0.0482 -0.0316 -0.00846 0.0808 0.147 0000914397 0000350403 0001514226
7 OperatingExpenses -0.806 -0.769 -0.305 0.497 0.641 0001498710 0000004515 0001128281
8 DepreciationDepletionAndAmortization -0.0469 -0.0434 -0.00950 0.0354 0.0510 0001048911 0000004515 0001128281
9 remainder_Expenses -1.61 -1.26 0.284 0.531 0.548 0001128281 0000004515 0001498710
10 remainder_Revenues -0.926 -0.862 0.204 0.699 0.708 0000006201 0000701345 0001048911
11 remainder_NetIncome -0.390 -0.383 -0.245 0.593 0.626 0001048911 0000092380 0001158463
12 remainder_ComprehensiveNetIncome -0.0560 -0.0181 0.000471 0.0235 0.0239 0001048911 0000350403 0000004515
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.311 -0.280 0.0209 0.251 0.273 0000816159 0001172222 0001048911
1 Assets -0.229 -0.158 -0.00603 0.109 0.147 0001514226 0000006201 0001135185
2 Expenses -0.291 -0.240 0.00787 0.274 0.320 0001128281 0000004515 0001135185
3 Revenues -0.926 -0.862 0.204 0.699 0.708 0000006201 0000701345 0001048911
4 StockholdersEquity -0.405 -0.366 -0.00484 0.407 0.482 0001514226 0001498710 0000073887
5 NetIncome -0.122 0.0343 0.168 0.322 0.326 0000842722 0000073887 0001498710
6 ComprehensiveNetIncome -0.122 0.0544 0.161 0.323 0.327 0000842722 0000073887 0001498710
7 BaseVar 0 0 0 0 0 0000004515 0000842722 0000004515
8 EconomicCapitalRatiobeforeLimitedLiability -0.327 0.0440 0.481 0.785 0.859 0000842722 0001128281 0000073887
9 EconomicCapitalRatio -0.769 -0.398 0.0388 0.342 0.416 0000842722 0001128281 0000073887

2013

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
warning 8 × The stock price does not exist industry.us_generic
warning 7 × Missing logo subcommand.report
warning 4 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Ignoring company because Assets is zero pre-agg
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Ignoring company because Liabilities is zero pre-agg
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 2,055,136 6,700,124 417,227,808 13,875,200,000 14,152,000,000 0000842722 0001135185 0000027904
1 LiabilitiesNonCurrent 0 0 0 27,406,200,000 31,203,000,000 0000073887 0001498710 0000006201
2 remainder_Liabilities 0 0 0 1,005,874,400 2,251,700,000 0000006201 0001498710 0001159154
3 AssetsCurrent 1,423,730 21,881,792 649,117,693 11,883,800,000 14,323,000,000 0000842722 0001498710 0000006201
4 AssetsNoncurrent 0 0 51,637,930 3,851,800,000 10,063,000,000 0001135185 0001498710 0000100517
5 PropertyPlantAndEquipmentNet 143,447 2,806,721 2,564,024,584 19,778,000,000 21,854,000,000 0000842722 0001159154 0000027904
6 remainder_Assets -143,447 -28,689 253,467,106 9,006,400,000 19,444,000,000 0000842722 0001159154 0000027904
7 OperatingExpenses 0 0 498,304,842 31,820,600,000 33,431,000,000 0000073887 0001135185 0000100517
8 DepreciationDepletionAndAmortization 0 0 32,023,333 1,828,400,000 2,386,000,000 0000073887 0001498710 0001048911
9 remainder_Expenses -4,740,000,000 -942,938,284 741,082,968 7,646,800,000 8,826,000,000 0000027904 0000816159 0001048911
10 remainder_Revenues 0 0 1,346,757,754 39,480,600,000 44,287,000,000 0000006201 0001159154 0001048911
11 remainder_NetIncome -873,000,000 -742,600,000 -4,310,842 9,397,400,000 25,819,000,000 0000027904 0000914397 0000006201
12 remainder_ComprehensiveNetIncome -40,444,000 -8,170,400 2,401,654 2,012,600,000 3,447,000,000 0000073887 0001159154 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 2,055,136 6,700,124 1,874,835,414 41,489,000,000 45,009,000,000 0000842722 0001158463 0000006201
1 Assets 1,645,875 29,172,847 3,272,015,134 44,272,800,000 52,252,000,000 0000842722 0001159154 0000027904
2 Expenses 9,160,912 82,949,151 1,477,611,173 38,124,400,000 42,630,000,000 0000842722 0001498710 0001048911
3 Revenues 0 0 1,346,757,754 39,480,600,000 44,287,000,000 0000006201 0001159154 0001048911
4 StockholdersEquity -2,731,000,000 -546,527,409 1,082,302,331 17,297,000,000 27,817,000,000 0000006201 0000350403 0001048911
5 NetIncome -1,834,000,000 -447,915,503 94,049,298 3,356,800,000 10,540,000,000 0000006201 0001135185 0000027904
6 ComprehensiveNetIncome -1,360,000,000 -353,115,503 95,731,195 4,154,700,000 12,263,500,000 0000006201 0001135185 0000027904
7 BaseVar 14,054,904 65,398,096 4,477,668,930 75,961,663,000 84,421,915,000 0000842722 0001159154 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -13.0 -6.04 0.407 1.15 1.18 0000842722 0000914397 0000350403
9 EconomicCapitalRatio 0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000185 0.00000000000156 0.676 1.21 1.23 0000842722 0000914397 0000350403

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.113 -0.107 0.0000231 0.108 0.136 0000092380 0000842722 0000350403
1 LiabilitiesNonCurrent -0.382 -0.354 0.0727 0.179 0.192 0001135185 0000816159 0001048911
2 remainder_Liabilities -0.460 -0.441 0.0812 0.184 0.199 0001159154 0000027904 0001048911
3 AssetsCurrent -0.0422 -0.0358 -0.00909 0.0134 0.0426 0001159154 0000092380 0001498710
4 AssetsNoncurrent -0.0168 -0.0135 -0.000881 0.0296 0.115 0001159154 0001498710 0000100517
5 PropertyPlantAndEquipmentNet -0.0826 -0.0780 -0.000167 0.198 0.284 0001498710 0000353184 0001525221
6 remainder_Assets -0.0503 -0.0447 -0.00145 0.0644 0.106 0000914397 0001159154 0000027904
7 OperatingExpenses -0.873 -0.845 -0.00179 0.416 0.478 0001498710 0000006201 0000350403
8 DepreciationDepletionAndAmortization -0.0575 -0.0491 0.00000000000000110 0.0306 0.0357 0001048911 0000842722 0000350403
9 remainder_Expenses -0.636 -0.405 0.0830 0.481 0.496 0000350403 0001159154 0000092380
10 remainder_Revenues -0.896 -0.772 0.142 0.738 0.763 0000350403 0000027904 0001048911
11 remainder_NetIncome -0.120 -0.0939 -0.0447 0.716 0.915 0000914397 0001159154 0000350403
12 remainder_ComprehensiveNetIncome -0.0165 -0.00894 -0.00290 0.0189 0.0247 0000073887 0001135185 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.336 -0.330 0.000197 0.381 0.395 0001159154 0000842722 0001048911
1 Assets -0.131 -0.0776 0.00550 0.133 0.186 0000914397 0000092380 0001525221
2 Expenses -0.358 -0.340 0.0243 0.332 0.335 0000230211 0000100517 0000027904
3 Revenues -0.896 -0.772 0.142 0.738 0.763 0000350403 0000027904 0001048911
4 StockholdersEquity -0.267 -0.178 0.0000476 0.439 0.473 0000006201 0000353184 0000073887
5 NetIncome -0.558 -0.134 0.296 0.463 0.549 0000353184 0000100517 0001498710
6 ComprehensiveNetIncome -0.566 -0.138 0.293 0.474 0.541 0000353184 0000073887 0001498710
7 BaseVar 0 0 0 0 0 0000006201 0000816159 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.242 -0.242 0.434 0.966 0.988 0000842722 0000914397 0000350403
9 EconomicCapitalRatio -0.709 -0.709 -0.0331 0.499 0.521 0000842722 0000914397 0000350403

2014

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
warning 8 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 7 × The stock price does not exist industry.us_generic
warning 6 × Missing logo subcommand.report
warning 3 × Ignoring company because Assets is zero pre-agg
warning 2 × Similarly named company. Duplicate? None
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 2,558,719 3,959,187 485,334,106 14,123,800,000 16,879,000,000 0001128281 0001135185 0000027904
1 LiabilitiesNonCurrent 0 0 0 28,337,800,000 28,429,000,000 0000073887 0000353184 0000027904
2 remainder_Liabilities 0 0 0 1,029,330,400 2,402,300,000 0000006201 0001498710 0001159154
3 AssetsCurrent 3,405,126 14,403,172 721,622,254 12,182,600,000 12,465,000,000 0001128281 0000073887 0000027904
4 AssetsNoncurrent 0 0 67,363,040 3,744,800,000 9,748,000,000 0001128281 0001498710 0000100517
5 PropertyPlantAndEquipmentNet 2,086,794 3,606,298 2,861,398,123 22,160,000,000 23,084,000,000 0001128281 0001159154 0000006201
6 remainder_Assets 0 0 273,972,632 8,808,200,000 18,717,000,000 0000100517 0001159154 0000027904
7 OperatingExpenses 0 0 1,451,912,568 33,378,800,000 34,762,000,000 0000073887 0001498710 0000006201
8 DepreciationDepletionAndAmortization 0 0 95,977,635 1,934,200,000 2,587,000,000 0001128281 0000073887 0001048911
9 remainder_Expenses 4,920,842 14,865,629 826,120,659 5,651,200,000 9,360,000,000 0000914397 0000816159 0001048911
10 remainder_Revenues 0 0 1,667,101,693 41,403,000,000 45,567,000,000 0000006201 0000073887 0001048911
11 remainder_NetIncome -1,245,000,000 -1,156,200,000 -2,797,154 13,062,600,000 41,613,000,000 0000100517 0000816159 0000006201
12 remainder_ComprehensiveNetIncome -2,527,000,000 -2,250,200,000 -862,768 12,935,000 42,135,000 0000006201 0000816159 0000073887
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 3,515,698 7,918,012 1,937,196,520 42,461,600,000 45,308,000,000 0001128281 0001158463 0000027904
1 Assets 6,705,944 31,117,706 3,494,972,192 45,841,000,000 54,121,000,000 0001128281 0001159154 0000027904
2 Expenses 17,351,826 55,893,793 1,704,503,674 39,602,000,000 43,086,000,000 0001128281 0001498710 0001048911
3 Revenues 0 0 1,667,101,693 41,403,000,000 45,567,000,000 0000006201 0000073887 0001048911
4 StockholdersEquity 3,190,246 23,199,695 1,783,045,338 25,427,600,000 27,758,000,000 0001128281 0001172222 0001048911
5 NetIncome -7,370,862 -1,367,175 187,839,296 2,435,600,000 2,882,000,000 0000914397 0000073887 0000006201
6 ComprehensiveNetIncome -431,500,000 -92,196,690 105,210,583 1,749,500,000 2,273,500,000 0000027904 0001135185 0001048911
7 BaseVar 25,336,032 99,779,410 4,697,537,036 90,075,330,000 95,361,030,000 0001128281 0001159154 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability 0.0718 0.0960 0.641 1.05 1.08 0000006201 0000100517 0000073887
9 EconomicCapitalRatio 0.408 0.430 0.832 1.13 1.15 0000006201 0000100517 0000073887

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.133 -0.126 0.0144 0.130 0.182 0001172222 0000230211 0000353184
1 LiabilitiesNonCurrent -0.407 -0.378 0.0947 0.176 0.212 0001135185 0001158463 0000353184
2 remainder_Liabilities -0.450 -0.395 0.135 0.244 0.294 0001159154 0001158463 0000353184
3 AssetsCurrent -0.0444 -0.0256 -0.00804 0.0438 0.0995 0001159154 0000006201 0000353184
4 AssetsNoncurrent -0.0295 -0.0195 -0.00261 0.0210 0.0810 0001128281 0000092380 0000100517
5 PropertyPlantAndEquipmentNet -0.230 -0.169 -0.0147 0.197 0.279 0001128281 0000230211 0001525221
6 remainder_Assets -0.0537 -0.0388 -0.00571 0.0536 0.0996 0000914397 0001048911 0000027904
7 OperatingExpenses -0.669 -0.662 -0.233 0.661 0.853 0001048911 0000006201 0000353184
8 DepreciationDepletionAndAmortization -0.0671 -0.0573 -0.00380 0.0686 0.0803 0000914397 0001172222 0001128281
9 remainder_Expenses -3.30 -2.58 0.120 0.358 0.393 0000353184 0000027904 0000100517
10 remainder_Revenues -1.05 -0.836 0.0886 0.662 0.889 0001158463 0000914397 0000353184
11 remainder_NetIncome -0.308 -0.264 -0.120 0.374 0.690 0001128281 0000914397 0001158463
12 remainder_ComprehensiveNetIncome -0.0232 -0.0192 0.00483 0.0149 0.0154 0000006201 0000816159 0000073887
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.344 -0.291 0.135 0.441 0.568 0001159154 0000100517 0000353184
1 Assets -0.250 -0.169 -0.0133 0.144 0.186 0001128281 0001498710 0001525221
2 Expenses -1.48 -0.954 -0.00551 0.267 0.300 0000353184 0001172222 0001525221
3 Revenues -1.05 -0.836 0.0886 0.662 0.889 0001158463 0000914397 0000353184
4 StockholdersEquity -0.419 -0.335 0.0494 0.239 0.399 0001128281 0000100517 0000073887
5 NetIncome -0.165 -0.0814 -0.00316 0.0656 0.135 0000914397 0001135185 0001498710
6 ComprehensiveNetIncome -0.159 -0.0705 -0.0000388 0.0790 0.143 0000914397 0000006201 0001498710
7 BaseVar 0 0 0 0 0 0000006201 0000914397 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.383 -0.360 0.0415 0.335 0.357 0000006201 0000100517 0000073887
9 EconomicCapitalRatio -0.378 -0.356 0.0460 0.339 0.362 0000006201 0000100517 0000073887

2015

Logs

warning 5 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 3 × Missing logo subcommand.report
warning 2 × The stock price does not exist industry.us_generic
warning 2 × Similarly named company. Duplicate? None
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,670,964 6,272,901 771,907,280 14,781,300,000 17,526,000,000 0001128281 0001172222 0000027904
1 LiabilitiesNonCurrent 0 0 0 26,083,100,000 29,175,000,000 0000073887 0001158463 0000006201
2 remainder_Liabilities 0 0 0 486,419,700 812,899,000 0000006201 0001048911 0000816159
3 AssetsCurrent 3,657,961 28,166,404 741,383,498 10,090,000,000 10,335,000,000 0001128281 0001172222 0001048911
4 AssetsNoncurrent 0 0 77,631,715 11,079,900,000 11,453,000,000 0001128281 0001498710 0000100517
5 PropertyPlantAndEquipmentNet 1,496,656 2,249,046 3,006,760,454 24,380,300,000 27,510,000,000 0001128281 0001159154 0000006201
6 remainder_Assets 0 0 216,021,402 8,550,300,000 19,611,000,000 0000006201 0001172222 0000027904
7 OperatingExpenses 0 0 1,469,690,611 31,291,700,000 32,026,000,000 0000073887 0001498710 0001048911
8 DepreciationDepletionAndAmortization 0 0 105,593,197 2,067,800,000 2,611,000,000 0000350403 0001172222 0001048911
9 remainder_Expenses -1,453,000,000 -820,200,000 750,006,861 8,147,800,000 11,526,000,000 0000100517 0000350403 0001048911
10 remainder_Revenues 0 0 1,859,064,912 42,928,900,000 47,453,000,000 0000350403 0000073887 0001048911
11 remainder_NetIncome -1,588,000,000 -1,139,300,000 -71,929,577 2,432,809,600 6,297,000,000 0000006201 0000073887 0001158463
12 remainder_ComprehensiveNetIncome -334,000,000 -319,300,000 0 116,400,000 248,000,000 0001048911 0000350403 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 2,323,464 6,468,651 2,275,609,308 42,432,800,000 42,780,000,000 0001128281 0001158463 0000006201
1 Assets 6,242,914 32,292,342 3,614,371,124 49,830,700,000 53,134,000,000 0001128281 0001159154 0000027904
2 Expenses 14,963,203 81,275,779 1,817,785,635 38,722,000,000 46,163,000,000 0001128281 0001498710 0001048911
3 Revenues 0 0 1,859,064,912 42,928,900,000 47,453,000,000 0000350403 0000073887 0001048911
4 StockholdersEquity 3,919,450 25,823,690 2,065,328,973 29,085,400,000 30,575,000,000 0001128281 0001498710 0001048911
5 NetIncome -27,100,000 -7,643,354 182,834,404 7,421,000,000 7,610,000,000 0001159154 0001172222 0000006201
6 ComprehensiveNetIncome -27,100,000 -7,643,354 194,584,850 7,481,850,000 7,523,500,000 0001159154 0001172222 0000006201
7 BaseVar 21,628,829 110,833,335 4,823,097,124 87,997,752,500 90,398,490,000 0001128281 0001159154 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability 0.105 0.206 0.800 1.12 1.17 0001159154 0001172222 0000350403
9 EconomicCapitalRatio 0.438 0.523 0.939 1.18 1.22 0001159154 0001172222 0000350403

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.406 -0.192 0.0513 0.259 0.342 0001159154 0001135185 0000353184
1 LiabilitiesNonCurrent -0.370 -0.362 0.108 0.211 0.250 0001135185 0001172222 0000353184
2 remainder_Liabilities -0.476 -0.170 0.0474 0.0913 0.124 0000816159 0001158463 0000353184
3 AssetsCurrent -0.0613 -0.0495 -0.00917 0.0388 0.0816 0001159154 0001048911 0000353184
4 AssetsNoncurrent -0.0257 -0.0241 -0.00475 0.0548 0.0797 0001128281 0000092380 0000006201
5 PropertyPlantAndEquipmentNet -0.155 -0.129 -0.00878 0.139 0.203 0001128281 0000100517 0001135185
6 remainder_Assets -0.0390 -0.0293 -0.00491 0.0684 0.155 0000006201 0001159154 0000027904
7 OperatingExpenses -0.732 -0.599 -0.119 0.706 0.801 0001048911 0000027904 0000353184
8 DepreciationDepletionAndAmortization -0.0519 -0.0329 -0.00495 0.0713 0.0826 0001048911 0001498710 0000353184
9 remainder_Expenses -3.12 -2.63 0.206 0.403 0.479 0000353184 0001048911 0000100517
10 remainder_Revenues -1.03 -1.02 0.0290 0.827 0.951 0000350403 0000073887 0000353184
11 remainder_NetIncome -0.300 -0.300 -0.135 0.701 0.734 0001128281 0001498710 0000350403
12 remainder_ComprehensiveNetIncome -0.0254 -0.0120 0.00208 0.00661 0.00752 0000073887 0000027904 0001172222
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.375 -0.329 0.106 0.435 0.572 0001159154 0001172222 0000353184
1 Assets -0.165 -0.129 0.00221 0.100 0.101 0001128281 0000100517 0001135185
2 Expenses -1.59 -1.23 0.0158 0.209 0.237 0000353184 0001158463 0001135185
3 Revenues -1.03 -1.02 0.0290 0.827 0.951 0000350403 0000073887 0000353184
4 StockholdersEquity -0.474 -0.430 0.0248 0.361 0.460 0001128281 0000092380 0000350403
5 NetIncome -0.131 -0.0984 0.00285 0.106 0.137 0000353184 0001172222 0000100517
6 ComprehensiveNetIncome -0.128 -0.1000 0.00488 0.109 0.143 0000353184 0000816159 0000100517
7 BaseVar 0 0 0 0 0 0000006201 0000816159 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.439 -0.354 0.0624 0.305 0.346 0001159154 0001172222 0000350403
9 EconomicCapitalRatio -0.441 -0.356 0.0596 0.303 0.343 0001159154 0001172222 0000350403

2016

Logs

warning 2 × The stock price does not exist industry.us_generic
warning 2 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 1 × Similarly named company. Duplicate? None
warning 1 × Missing logo subcommand.report

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 10,100,458 831,787,461 14,418,800,000 15,239,000,000 0001128281 0001172222 0000027904
1 LiabilitiesNonCurrent 0 0 0 27,687,800,000 33,617,000,000 0000092380 0001172222 0000006201
2 remainder_Liabilities 0 0 0 409,036,101 1,021,764,000 0000006201 0001135185 0000816159
3 AssetsCurrent 4,487,155 25,170,582 976,554,386 10,990,000,000 11,989,000,000 0001128281 0001498710 0001048911
4 AssetsNoncurrent 0 0 110,687,132 9,624,200,000 9,791,000,000 0001128281 0001498710 0000006201
5 PropertyPlantAndEquipmentNet 1,074,397 3,176,423 3,545,158,382 27,088,600,000 31,159,000,000 0001128281 0001135185 0000006201
6 remainder_Assets 0 0 255,909,395 11,129,000,000 17,702,000,000 0000006201 0001172222 0000027904
7 OperatingExpenses 0 0 1,642,790,613 32,080,600,000 33,193,000,000 0000350403 0001498710 0001048911
8 DepreciationDepletionAndAmortization 0 0 108,469,846 2,238,600,000 2,631,000,000 0000350403 0001172222 0001048911
9 remainder_Expenses 13,782,928 92,258,607 981,301,691 8,550,600,000 12,384,000,000 0001128281 0000816159 0001048911
10 remainder_Revenues 0 0 2,322,110,349 44,254,000,000 50,365,000,000 0000350403 0001498710 0001048911
11 remainder_NetIncome -985,000,000 -705,400,000 -24,191,156 2,980,535,600 6,536,000,000 0000006201 0001498710 0001158463
12 remainder_ComprehensiveNetIncome -361,000,000 -355,000,000 0 300,800,000 728,000,000 0000027904 0000350403 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 2,132,926 10,983,104 2,223,608,449 42,380,000,000 47,489,000,000 0001128281 0001158463 0000006201
1 Assets 6,966,803 34,079,572 4,253,666,545 51,266,200,000 51,274,000,000 0001128281 0001135185 0000006201
2 Expenses 13,782,928 92,258,607 2,203,443,420 41,194,600,000 48,208,000,000 0001128281 0001172222 0001048911
3 Revenues 0 0 2,322,110,349 44,254,000,000 50,365,000,000 0000350403 0001498710 0001048911
4 StockholdersEquity 4,833,877 23,096,469 2,621,375,028 31,892,800,000 37,951,000,000 0001128281 0001498710 0001048911
5 NetIncome -26,680,000 -10,143,742 265,471,945 3,354,800,000 4,373,000,000 0000350403 0001498710 0000027904
6 ComprehensiveNetIncome -26,680,000 -10,143,742 265,581,925 3,241,800,000 4,192,500,000 0000350403 0001498710 0000027904
7 BaseVar 20,367,852 126,613,932 5,515,689,381 89,210,448,000 92,690,925,000 0001128281 0001135185 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability 0.104 0.207 0.815 1.08 1.13 0000006201 0001172222 0000350403
9 EconomicCapitalRatio 0.438 0.523 0.950 1.15 1.18 0000006201 0001172222 0000350403

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.124 0.00626 0.152 0.163 0001172222 0001498710 0000353184
1 LiabilitiesNonCurrent -0.366 -0.355 0.125 0.229 0.244 0000006201 0001172222 0000353184
2 remainder_Liabilities -0.496 -0.182 0.0506 0.0828 0.0999 0000816159 0001158463 0000353184
3 AssetsCurrent -0.0520 -0.0517 -0.00606 0.0361 0.0385 0001135185 0001048911 0001128281
4 AssetsNoncurrent -0.0263 -0.0213 -0.00347 0.0656 0.0815 0000353184 0000092380 0000006201
5 PropertyPlantAndEquipmentNet -0.173 -0.138 -0.00325 0.140 0.242 0000353184 0001498710 0001135185
6 remainder_Assets -0.0586 -0.0389 -0.00262 0.0845 0.125 0000006201 0001172222 0000027904
7 OperatingExpenses -0.470 -0.435 -0.165 0.730 0.769 0001048911 0000006201 0000353184
8 DepreciationDepletionAndAmortization -0.0333 -0.0300 -0.00952 0.0721 0.0808 0001048911 0001498710 0000353184
9 remainder_Expenses -3.04 -2.48 0.187 0.345 0.359 0000353184 0001048911 0000092380
10 remainder_Revenues -1.00 -0.951 0.164 0.783 0.856 0001158463 0001498710 0000353184
11 remainder_NetIncome -0.325 -0.293 -0.143 0.601 0.701 0000353184 0001172222 0001158463
12 remainder_ComprehensiveNetIncome -0.00634 -0.00516 -0.000791 0.0105 0.0183 0001048911 0000100517 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.353 -0.304 0.0894 0.374 0.437 0000006201 0000092380 0000353184
1 Assets -0.178 -0.136 -0.000271 0.0793 0.105 0000353184 0001172222 0001135185
2 Expenses -1.39 -1.05 0.0291 0.199 0.251 0000353184 0001498710 0001135185
3 Revenues -1.00 -0.951 0.164 0.783 0.856 0001158463 0001498710 0000353184
4 StockholdersEquity -0.608 -0.442 0.0434 0.343 0.495 0000353184 0000100517 0000350403
5 NetIncome -0.0964 -0.0820 0.000390 0.0506 0.0531 0000350403 0000816159 0001498710
6 ComprehensiveNetIncome -0.0972 -0.0791 -0.000283 0.0580 0.0665 0000350403 0000816159 0000092380
7 BaseVar 0 0 0 0 0 0000006201 0000816159 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.437 -0.352 0.0753 0.276 0.309 0000006201 0001172222 0000350403
9 EconomicCapitalRatio -0.438 -0.353 0.0739 0.274 0.308 0000006201 0001172222 0000350403

2017

Logs

warning 2 × The stock price does not exist industry.us_generic
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic

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 40,147,689 2,399,510,000 16,768,500,000 18,573,000,000 0001128281 0001158463 0000027904
1 LiabilitiesNonCurrent 0 0 0 26,657,500,000 32,506,000,000 0000092380 0001158463 0000006201
2 remainder_Liabilities 0 0 0 56,250 112,500 0000006201 0001048911 0001128281
3 AssetsCurrent 4,627,988 178,620,494 1,283,794,740 10,887,000,000 12,628,000,000 0001128281 0001498710 0001048911
4 AssetsNoncurrent 0 0 468,318,000 8,549,500,000 9,005,000,000 0001128281 0001158463 0000100517
5 PropertyPlantAndEquipmentNet 669,957 473,717,478 8,059,490,000 30,359,500,000 34,156,000,000 0001128281 0001158463 0000006201
6 remainder_Assets 0 0 315,531,293 11,365,000,000 15,576,000,000 0000006201 0001172222 0000027904
7 OperatingExpenses 0 0 5,313,136,000 36,469,500,000 38,681,000,000 0000350403 0001158463 0001048911
8 DepreciationDepletionAndAmortization 0 0 446,772,000 2,615,000,000 2,995,000,000 0000350403 0001158463 0001048911
9 remainder_Expenses -237,000,000 -112,746,606 542,461,573 10,615,500,000 15,188,000,000 0000092380 0000350403 0001048911
10 remainder_Revenues 0 0 2,714,103,372 51,263,000,000 60,319,000,000 0000350403 0001172222 0001048911
11 remainder_NetIncome -974,000,000 -736,500,000 -99,440,750 3,742,721,500 6,936,000,000 0000006201 0001135185 0001158463
12 remainder_ComprehensiveNetIncome -246,000,000 -223,000,000 198 181,614,500 335,000,000 0001048911 0001128281 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 1,371,878 40,203,939 3,169,345,394 43,426,000,000 47,470,000,000 0001128281 0001135185 0000006201
1 Assets 6,548,662 704,197,331 9,796,329,000 52,344,000,000 53,292,000,000 0001128281 0001158463 0000027904
2 Expenses 11,506,788 276,708,894 5,800,630,000 48,089,000,000 56,864,000,000 0001128281 0001158463 0001048911
3 Revenues 0 0 2,714,103,372 51,263,000,000 60,319,000,000 0000350403 0001172222 0001048911
4 StockholdersEquity 5,176,784 663,993,392 3,929,460,000 35,142,000,000 40,634,000,000 0001128281 0000006201 0001048911
5 NetIncome 477,628 4,004,814 1,147,772,000 3,532,500,000 3,577,000,000 0001128281 0001158463 0000027904
6 ComprehensiveNetIncome 477,628 4,054,314 1,141,243,000 3,620,000,000 3,655,500,000 0001128281 0001158463 0000092380
7 BaseVar 17,032,981 681,642,670 13,182,189,805 94,459,707,500 95,257,130,000 0001128281 0001158463 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability 0.0923 0.184 0.957 1.13 1.14 0000006201 0001128281 0000350403
9 EconomicCapitalRatio 0.427 0.503 1.05 1.18 1.19 0000006201 0001128281 0000350403

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.103 -0.0949 -0.0177 0.172 0.198 0001172222 0000006201 0001128281
1 LiabilitiesNonCurrent -0.333 -0.329 0.138 0.224 0.241 0000006201 0000350403 0001128281
2 remainder_Liabilities -0.0219 -0.0107 0.00108 0.00149 0.00175 0001128281 0000350403 0001048911
3 AssetsCurrent -0.0528 -0.0482 -0.00606 0.0452 0.0766 0000006201 0000092380 0001128281
4 AssetsNoncurrent -0.0170 -0.0162 -0.00123 0.0519 0.0573 0001135185 0001498710 0000006201
5 PropertyPlantAndEquipmentNet -0.106 -0.0923 -0.00878 0.0996 0.144 0001128281 0001172222 0001135185
6 remainder_Assets -0.0554 -0.0393 0.00101 0.0536 0.0999 0000006201 0000350403 0000027904
7 OperatingExpenses -0.364 -0.338 -0.186 0.615 0.801 0001048911 0001172222 0001128281
8 DepreciationDepletionAndAmortization -0.0335 -0.0291 -0.00767 0.0521 0.0708 0001048911 0001172222 0001128281
9 remainder_Expenses -2.42 -1.44 0.143 0.261 0.279 0001128281 0001172222 0000092380
10 remainder_Revenues -0.957 -0.891 0.151 0.648 0.761 0001158463 0001498710 0001128281
11 remainder_NetIncome -0.316 -0.286 -0.170 0.602 0.730 0001128281 0000100517 0001158463
12 remainder_ComprehensiveNetIncome -0.00479 -0.00411 -0.000727 0.00663 0.00800 0001048911 0001498710 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.355 -0.322 0.0801 0.339 0.368 0000006201 0001158463 0001128281
1 Assets -0.108 -0.0978 -0.0170 0.0614 0.0708 0000006201 0001172222 0001135185
2 Expenses -0.906 -0.679 0.0466 0.179 0.256 0001128281 0001158463 0001135185
3 Revenues -0.957 -0.891 0.151 0.648 0.761 0001158463 0001498710 0001128281
4 StockholdersEquity -0.359 -0.325 -0.00144 0.349 0.448 0000006201 0001048911 0000350403
5 NetIncome -0.0744 -0.0734 -0.0163 0.0764 0.0842 0001128281 0001135185 0000092380
6 ComprehensiveNetIncome -0.0758 -0.0744 -0.0167 0.0794 0.0917 0001128281 0001135185 0000092380
7 BaseVar 0 0 0 0 0 0000006201 0001048911 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.495 -0.419 0.130 0.262 0.271 0000006201 0001128281 0000350403
9 EconomicCapitalRatio -0.500 -0.423 0.126 0.258 0.267 0000006201 0001128281 0000350403

2018

Logs

warning 2 × The stock price does not exist industry.us_generic
warning 2 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic

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 15,999,646 1,007,544,867 18,337,000,000 18,578,000,000 0001128281 0001172222 0000027904
1 LiabilitiesNonCurrent 0 0 0 35,327,000,000 42,653,000,000 0000100517 0001172222 0000006201
2 remainder_Liabilities 0 0 0 19,560,330 38,947,260 0000006201 0001135185 0000353184
3 AssetsCurrent 4,693,802 33,182,455 1,345,594,534 10,989,000,000 13,341,000,000 0001128281 0001498710 0001048911
4 AssetsNoncurrent 0 0 79,951,544 35,885,500,000 53,926,000,000 0001128281 0001498710 0000027904
5 PropertyPlantAndEquipmentNet 388,072 2,498,318 4,466,087,765 31,216,500,000 34,098,000,000 0001128281 0001135185 0000006201
6 remainder_Assets -28,335,000,000 -14,167,500,000 24,730,721 533,624,500 624,523,000 0000027904 0000350403 0001498710
7 OperatingExpenses 0 0 2,563,481,109 40,170,500,000 42,602,000,000 0000350403 0001498710 0001048911
8 DepreciationDepletionAndAmortization 0 0 177,041,273 2,712,000,000 3,095,000,000 0000350403 0001498710 0001048911
9 remainder_Expenses 10,823,269 99,431,680 782,330,755 10,449,000,000 15,262,000,000 0001128281 0000350403 0001048911
10 remainder_Revenues 11,118,452 102,818,898 3,327,368,966 54,995,500,000 65,450,000,000 0001128281 0001498710 0001048911
11 remainder_NetIncome -772,000,000 -703,000,000 -34,345,843 53,376,000 81,000,000 0000006201 0000350403 0001048911
12 remainder_ComprehensiveNetIncome -163,000,000 -141,500,000 -2,997,228 169,565,500 338,000,000 0001048911 0001158463 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 994,885 35,952,874 2,419,048,828 53,664,000,000 60,749,000,000 0001128281 0001158463 0000006201
1 Assets 6,341,386 51,744,136 5,539,683,208 60,423,000,000 60,580,000,000 0001128281 0001135185 0000006201
2 Expenses 10,823,269 100,646,046 3,025,726,653 51,658,000,000 60,959,000,000 0001128281 0001498710 0001048911
3 Revenues 11,118,452 102,818,898 3,327,368,966 54,995,500,000 65,450,000,000 0001128281 0001498710 0001048911
4 StockholdersEquity -169,000,000 -81,826,750 2,192,653,409 37,141,500,000 42,703,000,000 0000006201 0001172222 0001048911
5 NetIncome -141,514,000 -70,601,232 195,863,778 4,253,500,000 4,572,000,000 0000350403 0001172222 0001048911
6 ComprehensiveNetIncome -143,350,000 -71,519,232 193,184,026 4,188,250,000 4,490,500,000 0000350403 0001172222 0001048911
7 BaseVar 15,854,867 157,281,766 7,359,598,954 105,329,432,500 109,387,950,000 0001128281 0001135185 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability 0.0230 0.125 0.759 1.02 1.03 0000006201 0001172222 0001048911
9 EconomicCapitalRatio 0.361 0.452 0.911 1.10 1.11 0000006201 0001172222 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.223 -0.148 -0.0106 0.223 0.292 0000350403 0000006201 0001128281
1 LiabilitiesNonCurrent -0.372 -0.337 0.137 0.244 0.269 0000006201 0001172222 0001128281
2 remainder_Liabilities -0.276 -0.134 0.0145 0.0297 0.0362 0000353184 0000006201 0001048911
3 AssetsCurrent -0.0646 -0.0598 -0.00345 0.101 0.111 0000006201 0001048911 0000353184
4 AssetsNoncurrent -0.106 -0.0787 -0.0176 0.169 0.313 0000353184 0001498710 0000027904
5 PropertyPlantAndEquipmentNet -0.272 -0.177 0.0137 0.167 0.189 0000353184 0000100517 0001135185
6 remainder_Assets -0.160 -0.0864 0.00143 0.103 0.173 0000027904 0000350403 0000353184
7 OperatingExpenses -0.511 -0.473 -0.151 0.593 0.782 0001048911 0000006201 0001128281
8 DepreciationDepletionAndAmortization -0.0363 -0.0319 -0.00870 0.0479 0.0645 0001048911 0000027904 0001128281
9 remainder_Expenses -2.14 -1.73 0.180 0.326 0.357 0001128281 0001048911 0000100517
10 remainder_Revenues -0.200 -0.199 -0.00631 0.470 0.621 0000350403 0001158463 0001128281
11 remainder_NetIncome -0.0300 -0.0257 0.00234 0.0223 0.0257 0001498710 0001158463 0001128281
12 remainder_ComprehensiveNetIncome -0.00189 -0.00167 -0.000577 0.00259 0.00468 0001048911 0000027904 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.367 -0.306 0.0991 0.409 0.475 0000006201 0001172222 0001128281
1 Assets -0.240 -0.149 0.00339 0.0998 0.101 0000353184 0000100517 0000350403
2 Expenses -0.809 -0.596 -0.00329 0.212 0.249 0001128281 0001158463 0001135185
3 Revenues -0.200 -0.199 -0.00631 0.470 0.621 0000350403 0001158463 0001128281
4 StockholdersEquity -0.385 -0.350 0.0405 0.252 0.305 0000353184 0000350403 0001498710
5 NetIncome -0.145 -0.0859 0.0124 0.0585 0.0778 0000350403 0001498710 0001048911
6 ComprehensiveNetIncome -0.146 -0.0869 0.0127 0.0572 0.0760 0000350403 0001498710 0001048911
7 BaseVar 0 0 0 0 0 0000006201 0001048911 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.437 -0.347 0.112 0.302 0.308 0000006201 0001172222 0001048911
9 EconomicCapitalRatio -0.432 -0.341 0.118 0.307 0.314 0000006201 0001172222 0001048911

2019

Logs

warning 3 × The stock price does not exist industry.us_generic
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic

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,758,737 1,888,917,860 19,352,150,000 20,204,000,000 0001128281 0001158463 0000027904
1 LiabilitiesNonCurrent 0 0 200,226 36,027,600,000 41,802,000,000 0000100517 0001128281 0000006201
2 remainder_Liabilities 0 0 0 0 0 0000006201 0001128281 0000006201
3 AssetsCurrent 5,210,212 41,124,617 1,586,082,001 10,909,350,000 13,086,000,000 0001128281 0001158463 0001048911
4 AssetsNoncurrent 495,377 16,640,757 1,431,270,593 38,512,950,000 56,283,000,000 0001128281 0001158463 0000027904
5 PropertyPlantAndEquipmentNet 323,316 68,234,924 6,337,717,697 33,336,750,000 34,995,000,000 0001128281 0001158463 0000006201
6 remainder_Assets -31,310,000,000 -17,220,500,000 615,362 607,606,200 721,215,000 0000027904 0001128281 0001498710
7 OperatingExpenses 0 93,405,150 4,701,873,351 51,172,500,000 61,554,000,000 0001128281 0001158463 0001048911
8 DepreciationDepletionAndAmortization 0 0 375,401,762 3,005,600,000 3,353,000,000 0001128281 0001158463 0001048911
9 remainder_Expenses 10,919,163 29,398,340 469,061,200 4,738,050,000 6,318,000,000 0001128281 0001158463 0000027904
10 remainder_Revenues 11,567,725 124,984,499 5,966,105,118 59,484,300,000 69,693,000,000 0001128281 0001158463 0001048911
11 remainder_NetIncome -3,811,000,000 -2,460,100,000 -48,281,141 1,092,087 1,970,000 0001048911 0001158463 0000899394
12 remainder_ComprehensiveNetIncome -435,000,000 -368,400,000 0 49,000,000 85,000,000 0000006201 0001128281 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 1,681,073 88,724,540 3,129,068,416 55,190,450,000 60,113,000,000 0001128281 0001135185 0000006201
1 Assets 7,257,417 126,675,979 9,485,093,129 62,490,350,000 64,532,000,000 0001128281 0001158463 0000027904
2 Expenses 10,919,163 134,160,590 5,465,486,106 55,410,950,000 65,342,000,000 0001128281 0001158463 0001048911
3 Revenues 11,567,725 124,984,499 5,966,105,118 59,484,300,000 69,693,000,000 0001128281 0001158463 0001048911
4 StockholdersEquity -118,000,000 -62,390,645 4,493,979,964 41,917,350,000 45,390,000,000 0000006201 0001498710 0001048911
5 NetIncome -293,113,000 -169,858,450 437,811,770 3,975,900,000 4,767,000,000 0001135185 0001048911 0000027904
6 ComprehensiveNetIncome -292,606,000 -169,579,600 366,033,938 3,949,925,000 4,685,000,000 0001135185 0001048911 0000027904
7 BaseVar 16,960,058 252,023,616 12,059,837,117 109,606,263,000 110,162,175,000 0001128281 0001158463 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability 0.0259 0.0672 0.818 0.983 1.01 0000006201 0001172222 0001498710
9 EconomicCapitalRatio 0.364 0.403 0.952 1.07 1.09 0000006201 0001172222 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.0793 -0.0776 -0.0112 0.165 0.180 0001172222 0001135185 0001128281
1 LiabilitiesNonCurrent -0.319 -0.274 0.172 0.254 0.261 0000006201 0001158463 0001048911
2 remainder_Liabilities 0 0 0 0 0 0000006201 0001128281 0000006201
3 AssetsCurrent -0.0622 -0.0519 -0.00677 0.0705 0.106 0000006201 0001048911 0001128281
4 AssetsNoncurrent -0.0809 -0.0798 -0.0130 0.154 0.270 0000899394 0001172222 0000027904
5 PropertyPlantAndEquipmentNet -0.0912 -0.0819 -0.00785 0.122 0.165 0001128281 0000100517 0001135185
6 remainder_Assets -0.154 -0.0844 0.00165 0.0457 0.0528 0000027904 0000899394 0001135185
7 OperatingExpenses -0.788 -0.523 -0.0528 0.515 0.791 0001048911 0001498710 0001128281
8 DepreciationDepletionAndAmortization -0.0512 -0.0371 -0.00719 0.0573 0.0725 0000899394 0001498710 0001128281
9 remainder_Expenses -2.09 -1.23 0.103 0.242 0.311 0001128281 0000027904 0001048911
10 remainder_Revenues -0.210 -0.189 -0.0183 0.447 0.525 0001135185 0001172222 0001128281
11 remainder_NetIncome -0.0828 -0.0469 0.00364 0.0227 0.0228 0001048911 0001172222 0001128281
12 remainder_ComprehensiveNetIncome -0.00308 -0.00281 0.000773 0.00155 0.00174 0000006201 0001135185 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.349 -0.297 0.118 0.365 0.370 0000006201 0000100517 0001128281
1 Assets -0.118 -0.102 -0.00250 0.0601 0.0613 0000899394 0000100517 0001135185
2 Expenses -0.603 -0.501 0.0258 0.152 0.153 0001128281 0001172222 0000027904
3 Revenues -0.210 -0.189 -0.0183 0.447 0.525 0001135185 0001172222 0001128281
4 StockholdersEquity -0.336 -0.293 0.0176 0.271 0.323 0000006201 0001048911 0001498710
5 NetIncome -0.115 -0.102 0.0320 0.0548 0.0641 0000899394 0000100517 0001128281
6 ComprehensiveNetIncome -0.115 -0.101 0.0327 0.0553 0.0653 0000899394 0001172222 0001128281
7 BaseVar 0 0 0 0 0 0000006201 0001128281 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.440 -0.402 0.147 0.267 0.286 0000006201 0001172222 0001498710
9 EconomicCapitalRatio -0.431 -0.392 0.157 0.276 0.295 0000006201 0001172222 0001498710

2020

Logs

warning 3 × The stock price does not exist industry.us_generic
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic

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 67,746,000 69,094,000 1,343,353,978 16,248,000,000 16,569,000,000 0000353184 0001498710 0000006201
1 LiabilitiesNonCurrent 0 0 9,016,411 53,420,500,000 54,535,000,000 0000100517 0000353184 0000027904
2 remainder_Liabilities 0 0 0 21,857,500 43,715,000 0000006201 0001048911 0000353184
3 AssetsCurrent 98,486,000 123,168,000 2,356,969,020 16,893,500,000 17,404,000,000 0000353184 0001498710 0000027904
4 AssetsNoncurrent 10,289,000 31,750,500 1,348,105,950 39,069,000,000 54,592,000,000 0000353184 0001158463 0000027904
5 PropertyPlantAndEquipmentNet 5,272,000 77,331,500 4,114,882,406 32,653,500,000 33,608,000,000 0000353184 0001135185 0001048911
6 remainder_Assets -26,529,000,000 -13,264,500,000 9,958,449 601,197,500 757,327,000 0000027904 0000810332 0001498710
7 OperatingExpenses 0 73,107,000 2,256,688,366 44,306,000,000 62,750,000,000 0000353184 0001498710 0001048911
8 DepreciationDepletionAndAmortization 0 2,840,500 278,844,412 3,051,500,000 3,615,000,000 0001135185 0001498710 0001048911
9 remainder_Expenses -3,910,000,000 -3,311,000,000 99,358,234 1,911,242,500 2,176,000,000 0000100517 0001172222 0000027904
10 remainder_Revenues 185,949,000 211,367,000 2,957,254,116 43,277,000,000 69,217,000,000 0000899394 0001158463 0001048911
11 remainder_NetIncome -3,118,000,000 -2,790,500,000 -112,362,019 2,686,000 3,398,000 0000027904 0001498710 0000353184
12 remainder_ComprehensiveNetIncome -1,049,000,000 -910,500,000 -3,905,091 541,500 914,000 0000027904 0000353184 0001135185
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 120,336,000 170,532,000 2,675,093,649 69,668,500,000 70,462,000,000 0000353184 0001158463 0000027904
1 Assets 151,427,000 250,940,000 8,403,832,175 72,766,500,000 73,537,000,000 0000353184 0001498710 0001048911
2 Expenses 145,059,000 187,004,500 2,854,083,196 46,772,500,000 67,183,000,000 0000899394 0001135185 0001048911
3 Revenues 185,949,000 211,367,000 2,957,254,116 43,277,000,000 69,217,000,000 0000899394 0001158463 0001048911
4 StockholdersEquity -6,867,000,000 -3,417,954,500 2,262,250,943 55,008,000,000 63,193,000,000 0000006201 0001135185 0001048911
5 NetIncome -12,385,000,000 -10,635,000,000 -428,260,067 823,143,000 1,286,000,000 0000027904 0001498710 0001048911
6 ComprehensiveNetIncome -12,909,500,000 -11,090,250,000 -428,177,606 740,121,500 1,119,500,000 0000027904 0001498710 0001048911
7 BaseVar 398,419,810 434,172,618 8,269,305,183 107,951,387,500 118,242,455,000 0000353184 0001135185 0001048911
8 EconomicCapitalRatiobeforeLimitedLiability -0.223 -0.205 0.441 0.897 0.979 0000006201 0000899394 0001048911
9 EconomicCapitalRatio 0.316 0.319 0.699 1.01 1.07 0000006201 0000899394 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.0843 -0.0629 -0.000492 0.112 0.184 0001172222 0000006201 0001048911
1 LiabilitiesNonCurrent -0.169 -0.165 0.160 0.268 0.335 0000027904 0001172222 0001048911
2 remainder_Liabilities -0.185 -0.0918 0.00939 0.0169 0.0233 0000353184 0001158463 0001048911
3 AssetsCurrent -0.0683 -0.0517 0.0144 0.0437 0.0492 0000810332 0000100517 0000899394
4 AssetsNoncurrent -0.139 -0.103 -0.00226 0.0867 0.153 0000353184 0001172222 0000027904
5 PropertyPlantAndEquipmentNet -0.278 -0.162 0.0264 0.134 0.168 0000353184 0001498710 0000810332
6 remainder_Assets -0.0583 -0.0303 0.000286 0.0818 0.136 0000027904 0000810332 0000353184
7 OperatingExpenses -0.733 -0.428 -0.0154 0.274 0.350 0001048911 0001172222 0000353184
8 DepreciationDepletionAndAmortization -0.0310 -0.0227 -0.00715 0.0474 0.0501 0000899394 0001498710 0000353184
9 remainder_Expenses -1.33 -0.753 0.0331 0.153 0.157 0000353184 0001172222 0000899394
10 remainder_Revenues -0.111 -0.103 -0.0451 0.457 0.568 0001172222 0000810332 0001048911
11 remainder_NetIncome -0.0336 -0.0226 -0.0000921 0.0402 0.0613 0000100517 0001172222 0000353184
12 remainder_ComprehensiveNetIncome -0.00783 -0.00494 0.00119 0.00253 0.00262 0000353184 0001048911 0001135185
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.158 -0.156 0.0981 0.318 0.460 0000810332 0001172222 0001048911
1 Assets -0.290 -0.169 -0.0123 0.110 0.111 0000353184 0000810332 0001172222
2 Expenses -0.576 -0.533 0.0176 0.104 0.143 0001048911 0001158463 0000810332
3 Revenues -0.111 -0.103 -0.0451 0.457 0.568 0001172222 0000810332 0001048911
4 StockholdersEquity -0.466 -0.345 -0.113 0.321 0.345 0000353184 0000899394 0001498710
5 NetIncome -0.103 -0.0981 -0.0136 0.186 0.198 0001172222 0000006201 0000353184
6 ComprehensiveNetIncome -0.102 -0.0989 -0.0141 0.187 0.198 0001172222 0000006201 0000353184
7 BaseVar 0 0 0 0 0 0000006201 0000899394 0000006201
8 EconomicCapitalRatiobeforeLimitedLiability -0.357 -0.354 0.0259 0.336 0.395 0000006201 0000899394 0001048911
9 EconomicCapitalRatio -0.366 -0.363 0.0175 0.327 0.387 0000006201 0000899394 0001048911

2021

Logs

warning 3 × The stock price does not exist industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic

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,580,219 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,555,965,598 32,993,500,000 35,752,000,000 0001128281 0001172222 0001048911
6 remainder_Assets -28,749,000,000 -7,187,250,000 74,922,484 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,812,000,000 3,793,000,000 0001128281 0000810332 0001048911
9 remainder_Expenses -3,283,000,000 -2,767,750,000 2,506,409 1,682,475,750 2,052,903,000 0000100517 0001128281 0001135185
10 remainder_Revenues 0 4,036,924 1,828,987,124 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,828,987,124 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,426,750 335,268 2,040,500,000 5,231,000,000 0000100517 0001128281 0001048911
6 ComprehensiveNetIncome -1,865,500,000 -820,769,500 335,268 2,285,125,000 5,438,500,000 0000100517 0001128281 0001048911
7 BaseVar 9,256,503 209,506,917 5,530,122,826 113,366,942,500 139,646,980,000 0001128281 0001670076 0001048911
8 EconomicCapitalRatiobeforeLimitedLiability 0.0357 0.0495 0.690 1.04 1.07 0000353184 0001779128 0001128281
9 EconomicCapitalRatio 0.374 0.387 0.865 1.12 1.14 0000353184 0001779128 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.360 -0.141 0.0330 0.212 0.232 0001819516 0001743907 0001128281
1 LiabilitiesNonCurrent -0.331 -0.280 0.0751 0.211 0.255 0000027904 0001779128 0001048911
2 remainder_Liabilities -0.390 -0.194 0.0312 0.0611 0.0719 0000353184 0001135185 0001048911
3 AssetsCurrent -0.128 -0.128 -0.0261 0.215 0.534 0000027904 0000353184 0001779128
4 AssetsNoncurrent -0.124 -0.0730 -0.0186 0.101 0.136 0000353184 0001128281 0000027904
5 PropertyPlantAndEquipmentNet -0.262 -0.202 0.00111 0.155 0.239 0000353184 0001743907 0000810332
6 remainder_Assets -0.198 -0.0655 -0.00679 0.109 0.150 0000027904 0000092380 0001819516
7 OperatingExpenses -0.859 -0.395 -0.0821 0.317 0.513 0001048911 0000027904 0001128281
8 DepreciationDepletionAndAmortization -0.0404 -0.0329 -0.00979 0.0395 0.0529 0000899394 0001172222 0001128281
9 remainder_Expenses -1.30 -1.05 0.0711 0.185 0.207 0001128281 0001819516 0000899394
10 remainder_Revenues -0.279 -0.222 -0.0107 0.472 0.524 0001819516 0001498710 0001048911
11 remainder_NetIncome -0.0620 -0.0589 0.00481 0.0629 0.0999 0001779128 0001743907 0001128281
12 remainder_ComprehensiveNetIncome -0.00348 -0.00256 -0.00179 0.00808 0.0121 0001128281 0000810332 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.303 -0.286 0.0559 0.403 0.428 0000027904 0000100517 0001048911
1 Assets -0.330 -0.170 -0.00871 0.166 0.209 0000353184 0000810332 0001819516
2 Expenses -0.637 -0.537 0.00185 0.160 0.255 0001048911 0001172222 0001819516
3 Revenues -0.279 -0.222 -0.0107 0.472 0.524 0001819516 0001498710 0001048911
4 StockholdersEquity -0.489 -0.363 0.00320 0.292 0.361 0000353184 0001128281 0001779128
5 NetIncome -0.165 -0.107 -0.00650 0.179 0.228 0001779128 0001819516 0000899394
6 ComprehensiveNetIncome -0.167 -0.109 -0.00309 0.177 0.226 0001779128 0000810332 0000899394
7 BaseVar 0 0 0 0 0 0000027904 0001135185 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.403 -0.390 0.0880 0.338 0.365 0000353184 0001779128 0001128281
9 EconomicCapitalRatio -0.395 -0.381 0.0970 0.347 0.374 0000353184 0001779128 0001128281

2022

Logs

error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 3 × The stock price does not exist industry.us_generic
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 1 × Similarly named company. Duplicate? None
warning 1 × Missing logo subcommand.report

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 22,782,269 15,517,267,050 39,766,000,000 0000092380 0001846084 0000027904
2 remainder_Liabilities 0 0 0 262,926,500 304,000,000 0000027904 0001172222 0001670076
3 AssetsCurrent 6,870,063 10,025,316 1,072,595,393 16,752,950,000 20,365,000,000 0001128281 0001135185 0001048911
4 AssetsNoncurrent 0 12,130,300 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 0001128281 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 65,781,142 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,933,450 25,497,000 0000027904 0001743907 0001779128
12 remainder_ComprehensiveNetIncome -371,000,000 -158,450,000 0 467,750,000 1,329,000,000 0001048911 0001128281 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 35,676,106 4,319,778,690 77,085,100,000 85,994,000,000 0001128281 0001670076 0001048911
2 Expenses 7,166,183 72,933,550 3,081,011,581 61,804,000,000 88,337,000,000 0001128281 0001670076 0001048911
3 Revenues 7,598,597 65,781,142 2,984,523,653 65,607,500,000 93,512,000,000 0001128281 0001670076 0001048911
4 StockholdersEquity -7,255,668 1,219,157 1,767,412,889 41,346,150,000 71,720,000,000 0001846084 0001172222 0001048911
5 NetIncome -555,547,000 -554,638,950 -7,265,000 2,195,800,000 3,826,000,000 0001819516 0001128281 0001048911
6 ComprehensiveNetIncome -560,380,000 -556,351,300 -7,265,000 2,562,800,000 3,640,500,000 0001819516 0001128281 0001048911
7 BaseVar 12,668,000 115,820,912 6,833,702,134 134,552,109,500 152,014,795,000 0001128281 0001670076 0001048911
8 EconomicCapitalRatiobeforeLimitedLiability -0.404 -0.309 0.634 1.08 1.25 0001846084 0001158463 0001128281
9 EconomicCapitalRatio 0.270 0.295 0.828 1.15 1.29 0001846084 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.0701 -0.0575 -0.000138 0.179 0.219 0000092380 0001846084 0001128281
1 LiabilitiesNonCurrent -0.253 -0.223 0.0560 0.242 0.286 0000027904 0001779128 0001128281
2 remainder_Liabilities -0.0346 -0.0255 0.0108 0.0247 0.0295 0001670076 0001172222 0001128281
3 AssetsCurrent -0.109 -0.103 -0.0250 0.124 0.160 0000027904 0001498710 0001779128
4 AssetsNoncurrent -0.0680 -0.0594 -0.0204 0.118 0.169 0001743907 0001172222 0000027904
5 PropertyPlantAndEquipmentNet -0.162 -0.111 0.0214 0.188 0.231 0001670076 0000027904 0001135185
6 remainder_Assets -0.204 -0.0802 -0.00121 0.0849 0.0999 0000027904 0001128281 0001743907
7 OperatingExpenses -0.837 -0.502 -0.113 0.536 0.690 0001048911 0000027904 0001128281
8 DepreciationDepletionAndAmortization -0.0476 -0.0303 -0.00400 0.0381 0.0549 0000899394 0001819516 0001128281
9 remainder_Expenses -1.25 -0.973 0.164 0.357 0.434 0001128281 0001743907 0001048911
10 remainder_Revenues -0.175 -0.138 -0.0205 0.334 0.344 0001779128 0001172222 0001128281
11 remainder_NetIncome -0.0279 -0.0275 -0.0131 0.127 0.181 0000027904 0000092380 0001128281
12 remainder_ComprehensiveNetIncome -0.00409 -0.00303 -0.000620 0.00696 0.00912 0001048911 0001498710 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.297 -0.284 0.0655 0.374 0.438 0000027904 0000092380 0001128281
1 Assets -0.223 -0.120 0.0217 0.0774 0.0817 0001846084 0000899394 0001779128
2 Expenses -0.263 -0.256 -0.00454 0.141 0.192 0001048911 0001498710 0001743907
3 Revenues -0.175 -0.138 -0.0205 0.334 0.344 0001779128 0001172222 0001128281
4 StockholdersEquity -0.383 -0.312 0.108 0.292 0.308 0001846084 0001158463 0001779128
5 NetIncome -0.0945 -0.0891 0.0217 0.190 0.303 0001779128 0001743907 0001128281
6 ComprehensiveNetIncome -0.0899 -0.0889 0.0211 0.189 0.302 0001819516 0001743907 0001128281
7 BaseVar 0 0 0 0 0 0000027904 0001172222 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.456 -0.431 0.102 0.421 0.563 0001846084 0001158463 0001128281
9 EconomicCapitalRatio -0.468 -0.442 0.0905 0.409 0.551 0001846084 0001158463 0001128281

2023

Logs

error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 4 × The stock price does not exist industry.us_generic
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 2,291,671 15,571,403 1,658,010,874 20,753,200,000 26,418,000,000 0001128281 0001670076 0000027904
1 LiabilitiesNonCurrent 0 0 19,771,761 22,702,200,000 36,121,000,000 0000092380 0001779128 0000027904
2 remainder_Liabilities 0 0 0 251,098,400 254,000,000 0000027904 0001498710 0001670076
3 AssetsCurrent 10,561,198 88,841,119 871,512,902 12,480,600,000 13,955,000,000 0001128281 0001670076 0000092380
4 AssetsNoncurrent 0 9,312,800 1,355,665,600 39,461,704,000 63,375,000,000 0001128281 0001158463 0000027904
5 PropertyPlantAndEquipmentNet 49,440 1,189,264 971,021,118 29,041,600,000 35,486,000,000 0001128281 0001743907 0000027904
6 remainder_Assets -35,486,000,000 -21,291,600,000 365,013,288 899,688,800 970,000,000 0000027904 0001819516 0000092380
7 OperatingExpenses 0 0 3,378,492,832 36,051,000,000 43,855,000,000 0001128281 0001670076 0000027904
8 DepreciationDepletionAndAmortization 0 0 88,337,177 2,013,400,000 2,341,000,000 0001128281 0001743907 0000027904
9 remainder_Expenses 6,831,747 71,299,048 208,067,065 5,053,889,600 7,330,000,000 0001128281 0001670076 0000027904
10 remainder_Revenues 8,837,614 95,374,568 3,590,418,839 45,265,200,000 58,048,000,000 0001128281 0001670076 0000027904
11 remainder_NetIncome -104,000,000 -87,535,200 448,685 280,200,000 409,000,000 0001158463 0001128281 0000092380
12 remainder_ComprehensiveNetIncome -344,000,000 -224,000,000 0 1,304,200 1,677,000 0000092380 0001128281 0001779128
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 2,291,671 25,630,203 1,673,157,126 42,425,800,000 62,539,000,000 0001128281 0001498710 0000027904
1 Assets 10,610,638 124,341,583 4,996,539,390 58,781,200,000 73,644,000,000 0001128281 0001670076 0000027904
2 Expenses 6,831,747 120,831,448 3,636,689,740 42,529,600,000 53,526,000,000 0001128281 0001670076 0000027904
3 Revenues 8,837,614 95,374,568 3,590,418,839 45,265,200,000 58,048,000,000 0001128281 0001670076 0000027904
4 StockholdersEquity 8,318,967 44,940,580 520,187,994 18,980,600,000 24,231,000,000 0001128281 0001743907 0000092380
5 NetIncome -487,387,000 -471,417,800 -10,989,243 2,951,400,000 4,609,000,000 0001819516 0001670076 0000027904
6 ComprehensiveNetIncome -487,712,500 -471,507,300 -11,488,843 2,869,400,000 4,587,000,000 0001819516 0001670076 0000027904
7 BaseVar 15,392,170 197,846,888 8,771,181,344 99,540,403,000 130,087,775,000 0001128281 0001670076 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.378 -0.201 0.486 1.06 1.23 0001819516 0001779128 0001128281
9 EconomicCapitalRatio 0.278 0.327 0.730 1.14 1.27 0001819516 0001779128 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.0657 -0.0545 -0.00279 0.127 0.156 0000092380 0001158463 0001779128
1 LiabilitiesNonCurrent -0.235 -0.228 0.0882 0.183 0.217 0001670076 0001779128 0001128281
2 remainder_Liabilities -0.0212 -0.0197 0.0159 0.0288 0.0346 0001819516 0000027904 0001128281
3 AssetsCurrent -0.113 -0.110 -0.0352 0.142 0.218 0001670076 0001819516 0001779128
4 AssetsNoncurrent -0.0820 -0.0739 -0.0333 0.161 0.209 0001743907 0001158463 0000027904
5 PropertyPlantAndEquipmentNet -0.150 -0.135 0.0297 0.157 0.166 0001670076 0001498710 0001158463
6 remainder_Assets -0.185 -0.114 0.0120 0.0822 0.0856 0000027904 0001498710 0001743907
7 OperatingExpenses -0.344 -0.343 -0.129 0.472 0.503 0000092380 0000027904 0001128281
8 DepreciationDepletionAndAmortization -0.0254 -0.0240 -0.00112 0.0398 0.0417 0001743907 0001819516 0001128281
9 remainder_Expenses -0.986 -0.831 0.171 0.334 0.353 0001779128 0000027904 0000092380
10 remainder_Revenues -0.103 -0.0876 -0.0145 0.155 0.231 0001670076 0001498710 0001128281
11 remainder_NetIncome -0.0243 -0.0199 -0.00370 0.0505 0.0580 0001743907 0000027904 0001128281
12 remainder_ComprehensiveNetIncome -0.00488 -0.00292 0.000293 0.00252 0.00387 0000092380 0001158463 0001779128
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.263 -0.248 0.0902 0.273 0.296 0001670076 0000092380 0001128281
1 Assets -0.0645 -0.0617 0.00151 0.0526 0.0667 0001670076 0001128281 0001498710
2 Expenses -0.276 -0.187 -0.00691 0.155 0.170 0001779128 0000092380 0001743907
3 Revenues -0.103 -0.0876 -0.0145 0.155 0.231 0001670076 0001498710 0001128281
4 StockholdersEquity -0.265 -0.249 0.103 0.269 0.288 0001670076 0000092380 0001498710
5 NetIncome -0.210 -0.158 0.0211 0.245 0.349 0001779128 0001670076 0001128281
6 ComprehensiveNetIncome -0.206 -0.155 0.0213 0.245 0.349 0001779128 0001670076 0001128281
7 BaseVar 0 0 0 0 0 0000027904 0001498710 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.425 -0.375 0.0272 0.435 0.572 0001819516 0001779128 0001128281
9 EconomicCapitalRatio -0.435 -0.386 0.0169 0.425 0.562 0001819516 0001779128 0001128281

2024

Logs

warning 3 × The stock price does not exist industry.us_generic
warning 3 × Missing logo subcommand.report
warning 2 × Ignoring company because Assets is zero pre-agg
warning 1 × Similarly named company. Duplicate? None

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,208,149 13,042,967 1,097,740,132 18,753,300,000 26,670,000,000 0001128281 0001362468 0000027904
1 LiabilitiesNonCurrent 0 0 119,724,715 16,917,800,000 33,409,000,000 0000092380 0000894081 0000027904
2 remainder_Liabilities 0 0 3,003,092 1,228,784,650 1,862,625,000 0000027904 0001779128 0000894081
3 AssetsCurrent 10,781,872 93,259,942 805,136,596 10,487,500,000 11,274,000,000 0001128281 0001670076 0000092380
4 AssetsNoncurrent 0 5,671,600 302,200,882 32,038,876,750 65,528,000,000 0001128281 0001525221 0000027904
5 PropertyPlantAndEquipmentNet 102,073 17,050,833 1,786,060,719 27,398,550,000 37,595,000,000 0001128281 0001498710 0000027904
6 remainder_Assets -37,595,000,000 -16,917,750,000 349,300,656 965,600,000 970,000,000 0000027904 0001498710 0000092380
7 OperatingExpenses 0 0 1,185,403,977 35,390,600,000 47,473,000,000 0001128281 0000894081 0000027904
8 DepreciationDepletionAndAmortization 0 0 176,799,588 2,042,200,000 2,513,000,000 0001128281 0001362468 0000027904
9 remainder_Expenses 7,268,620 74,770,879 240,864,001 3,820,086,500 6,863,000,000 0001128281 0001779128 0000027904
10 remainder_Revenues 9,169,459 140,907,407 2,237,885,680 42,855,000,000 61,643,000,000 0001128281 0001362468 0000027904
11 remainder_NetIncome -1,337,000,000 -718,800,000 -52,407,732 140,050,000 277,000,000 0000027904 0001743907 0000092380
12 remainder_ComprehensiveNetIncome -39,099,000 -31,344,550 -14,967 390,250,000 866,000,000 0001525221 0000894081 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 1,208,149 19,649,017 2,090,236,367 33,787,350,000 60,079,000,000 0001128281 0000894081 0000027904
1 Assets 10,883,945 146,069,025 4,162,371,756 52,479,900,000 75,372,000,000 0001128281 0001362468 0000027904
2 Expenses 7,268,620 158,571,079 2,267,632,806 40,594,300,000 56,849,000,000 0001128281 0001362468 0000027904
3 Revenues 9,169,459 140,907,407 2,237,885,680 42,855,000,000 61,643,000,000 0001128281 0001362468 0000027904
4 StockholdersEquity -196,228,000 -82,980,912 990,549,932 18,074,450,000 21,474,000,000 0001819516 0001362468 0000092380
5 NetIncome -1,229,495,000 -990,522,750 14,373,209 1,811,400,000 3,457,000,000 0001498710 0000894081 0000027904
6 ComprehensiveNetIncome -1,229,367,500 -990,465,375 14,373,209 1,999,375,000 3,890,000,000 0001498710 0000894081 0000027904
7 BaseVar 15,527,719 251,848,442 6,062,519,106 90,090,371,250 134,711,225,000 0001128281 0001362468 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.399 -0.135 0.348 0.966 1.24 0001819516 0001525221 0001128281
9 EconomicCapitalRatio 0.271 0.351 0.633 1.07 1.28 0001819516 0001525221 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.0985 -0.0741 -0.0111 0.202 0.207 0000092380 0001743907 0001128281
1 LiabilitiesNonCurrent -0.273 -0.224 0.0547 0.192 0.233 0001670076 0000894081 0001128281
2 remainder_Liabilities -0.331 -0.252 0.0773 0.133 0.167 0000894081 0000027904 0001128281
3 AssetsCurrent -0.0951 -0.0908 -0.0185 0.0648 0.106 0000027904 0001498710 0001779128
4 AssetsNoncurrent -0.0930 -0.0817 -0.0324 0.190 0.239 0001362468 0001819516 0000027904
5 PropertyPlantAndEquipmentNet -0.167 -0.122 0.0205 0.154 0.206 0001670076 0001525221 0000894081
6 remainder_Assets -0.185 -0.0923 0.00156 0.0725 0.0836 0000027904 0001158463 0001743907
7 OperatingExpenses -0.426 -0.361 -0.0708 0.544 0.567 0000092380 0001743907 0001779128
8 DepreciationDepletionAndAmortization -0.0631 -0.0400 -0.000900 0.0601 0.0622 0000894081 0001819516 0001128281
9 remainder_Expenses -1.42 -1.08 0.170 0.256 0.311 0001779128 0001525221 0000092380
10 remainder_Revenues -0.118 -0.113 -0.0113 0.296 0.330 0001362468 0001525221 0001128281
11 remainder_NetIncome -0.0752 -0.0413 0.00238 0.0419 0.0584 0001128281 0001362468 0001779128
12 remainder_ComprehensiveNetIncome -0.00834 -0.00626 0.000751 0.00369 0.00672 0001525221 0001743907 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.244 -0.205 -0.0546 0.430 0.464 0001670076 0001525221 0001128281
1 Assets -0.0728 -0.0610 -0.00510 0.0702 0.0803 0000027904 0001743907 0001498710
2 Expenses -0.502 -0.285 0.0217 0.121 0.151 0001779128 0000027904 0000894081
3 Revenues -0.118 -0.113 -0.0113 0.296 0.330 0001362468 0001525221 0001128281
4 StockholdersEquity -0.227 -0.206 -0.0335 0.346 0.376 0001670076 0000894081 0001128281
5 NetIncome -0.135 -0.118 0.0378 0.146 0.225 0001498710 0000092380 0001128281
6 ComprehensiveNetIncome -0.135 -0.121 0.0384 0.150 0.226 0001498710 0000092380 0001128281
7 BaseVar 0 0 0 0 0 0000027904 0001498710 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.407 -0.327 -0.0446 0.393 0.601 0001819516 0001525221 0001128281
9 EconomicCapitalRatio -0.413 -0.333 -0.0509 0.386 0.594 0001819516 0001525221 0001128281

2025

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 2 × The stock price does not exist industry.us_generic
warning 2 × Missing logo subcommand.report
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 328,281 9,087,855 963,108,815 20,107,650,000 27,624,000,000 0001128281 0001362468 0000027904
1 LiabilitiesNonCurrent 0 0 162,900,774 19,983,050,000 32,840,000,000 0000092380 0001525221 0000027904
2 remainder_Liabilities 0 0 940,690 540,195,100 690,082,000 0000027904 0001779128 0001525221
3 AssetsCurrent 9,055,526 61,766,939 826,381,341 8,572,650,000 10,968,000,000 0001128281 0001670076 0000027904
4 AssetsNoncurrent 0 12,205,800 312,533,171 41,075,600,000 70,349,000,000 0001128281 0001525221 0000027904
5 PropertyPlantAndEquipmentNet 0 16,399,800 1,040,047,582 30,968,900,000 39,743,000,000 0001128281 0001525221 0000027904
6 remainder_Assets -39,743,000,000 -21,858,650,000 248,573,322 976,600,000 982,000,000 0000027904 0001819516 0001158463
7 OperatingExpenses 0 0 1,105,801,329 38,915,850,000 49,422,000,000 0001128281 0001362468 0000027904
8 DepreciationDepletionAndAmortization 0 0 94,946,090 2,045,650,000 2,443,000,000 0001128281 0001743907 0000027904
9 remainder_Expenses 2,638,247 56,351,036 204,747,343 4,311,682,550 6,857,000,000 0001128281 0001743907 0000027904
10 remainder_Revenues 1,265,756 89,409,616 2,049,549,960 47,478,550,000 63,364,000,000 0001128281 0001362468 0000027904
11 remainder_NetIncome -406,000,000 -264,718,450 3,844,150 260,400,000 363,000,000 0001158463 0001525221 0000027904
12 remainder_ComprehensiveNetIncome -3,000,000 -2,438,850 847,774 480,204,700 844,000,000 0001158463 0000092380 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 328,281 21,060,555 2,260,435,728 38,169,650,000 60,464,000,000 0001128281 0001362468 0000027904
1 Assets 9,055,526 151,442,939 3,262,039,326 57,801,800,000 81,317,000,000 0001128281 0001362468 0000027904
2 Expenses 2,638,247 100,223,336 1,964,928,181 44,787,750,000 58,722,000,000 0001128281 0001362468 0000027904
3 Revenues 1,265,756 89,409,616 2,049,549,960 47,478,550,000 63,364,000,000 0001128281 0001362468 0000027904
4 StockholdersEquity -392,101,000 -211,728,290 839,301,269 19,632,150,000 20,853,000,000 0001819516 0001362468 0000027904
5 NetIncome -602,000,000 -463,497,650 20,166,698 2,951,200,000 5,005,000,000 0001158463 0001779128 0000027904
6 ComprehensiveNetIncome -603,500,000 -462,741,125 19,727,659 3,183,525,000 5,427,000,000 0001158463 0001779128 0000027904
7 BaseVar 7,015,413 207,931,155 4,999,683,046 99,595,924,250 139,318,115,000 0001128281 0001362468 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.489 -0.259 0.399 1.06 1.19 0001819516 0001525221 0001779128
9 EconomicCapitalRatio 0.243 0.296 0.669 1.14 1.23 0001819516 0001525221 0001779128

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.0648 -0.0637 -0.00499 0.205 0.263 0001819516 0001743907 0001779128
1 LiabilitiesNonCurrent -0.273 -0.223 0.0461 0.173 0.180 0001670076 0001525221 0000092380
2 remainder_Liabilities -0.205 -0.125 0.0490 0.0809 0.0935 0001525221 0001128281 0001779128
3 AssetsCurrent -0.139 -0.125 -0.0633 0.390 0.709 0001670076 0001819516 0001128281
4 AssetsNoncurrent -0.0865 -0.0786 -0.0249 0.196 0.274 0001362468 0001128281 0000027904
5 PropertyPlantAndEquipmentNet -0.162 -0.118 0.0329 0.153 0.155 0001670076 0001525221 0001362468
6 remainder_Assets -0.171 -0.102 -0.00543 0.0643 0.0659 0000027904 0001670076 0001743907
7 OperatingExpenses -0.595 -0.445 -0.0958 0.376 0.465 0000092380 0001743907 0001779128
8 DepreciationDepletionAndAmortization -0.0271 -0.0264 -0.00185 0.0381 0.0482 0001362468 0001525221 0001779128
9 remainder_Expenses -0.812 -0.572 0.0952 0.295 0.342 0001779128 0001743907 0000092380
10 remainder_Revenues -0.293 -0.211 0.0529 0.213 0.307 0001128281 0001743907 0000092380
11 remainder_NetIncome -0.0440 -0.0422 -0.0150 0.165 0.271 0001158463 0000092380 0001779128
12 remainder_ComprehensiveNetIncome -0.00625 -0.00410 -0.00124 0.00518 0.00635 0001779128 0001743907 0001525221
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.272 -0.215 -0.0436 0.352 0.416 0001670076 0001525221 0001779128
1 Assets -0.0839 -0.0803 -0.0405 0.121 0.187 0001819516 0001743907 0001128281
2 Expenses -0.232 -0.190 0.0172 0.0618 0.0650 0000092380 0001670076 0001362468
3 Revenues -0.293 -0.211 0.0529 0.213 0.307 0001128281 0001743907 0000092380
4 StockholdersEquity -0.263 -0.244 -0.0623 0.474 0.610 0001670076 0001525221 0001128281
5 NetIncome -0.182 -0.132 0.0284 0.164 0.224 0001128281 0000092380 0001779128
6 ComprehensiveNetIncome -0.183 -0.132 0.0270 0.163 0.219 0001128281 0000092380 0001779128
7 BaseVar 0 0 0 0 0 0000027904 0001525221 0000027904
8 EconomicCapitalRatiobeforeLimitedLiability -0.437 -0.384 -0.0110 0.458 0.555 0001819516 0001525221 0001779128
9 EconomicCapitalRatio -0.449 -0.396 -0.0226 0.446 0.543 0001819516 0001525221 0001779128

Estimates

Parameter Value Min Max
PresentValueFactor 1.11 1.0 15.0
BalanceFactor 0.63 0.5 5.0
OCIFactor 0.5 0.5 1.0
HiddenReservesFactor 0.0 0.0 1.0
LLPO_stddev 0.6 0.02 10.0

Stock Table

          Adjusted stock price Split Original stock price
(Adjusted stock price * Split)
Outstanding shares Market cap
(Original stock price * Outstanding shares)
obs_EconomicCapitalRatio
Company Name Name_short Identifier Year            
0000004515 American Airlines INC America nan 2010 nan nan nan nan nan nan
2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
0000006201 American Airlines Group Inc America AAL 2010 9.5200 1.0000 9.5200 nan nan nan
2011 5.3400 1.0000 5.3400 335,227,024.0 1,790,112,308.16 0.1102
2012 12.5200 1.0000 12.5200 335,271,557.0 4,197,599,893.64 0.2558
2013 24.6300 1.0000 24.6300 335,598,131.0 8,265,781,966.53 0.1894
2014 48.4500 1.0000 48.4500 717,263,563.0 34,751,419,627.35 0.8127
2015 40.9500 1.0000 40.9500 630,325,539.0 25,811,830,822.05 0.5661
2016 46.9000 1.0000 46.9000 518,125,156.0 24,300,069,816.40 0.4920
2017 50.8900 1.0000 50.8900 478,499,073.0 24,350,817,824.97 0.4926
2018 31.5300 1.0000 31.5300 460,581,463.0 14,522,133,528.39 0.2394
2019 28.5100 1.0000 28.5100 438,057,971.0 12,489,032,753.21 0.2080
2020 15.9700 1.0000 15.9700 508,631,777.0 8,122,849,478.69 0.1242
0000027904 Delta AIR Lines INC Delta A DAL 2010 10.7600 1.0000 10.7600 nan nan nan
2011 7.1900 1.0000 7.1900 847,144,480.0 6,090,968,811.20 0.1378
2013 23.8100 1.0000 23.8100 855,545,884.0 20,370,547,498.04 0.4388
2014 41.6800 1.0000 41.6800 836,941,362.0 34,883,715,968.16 0.7017
2015 45.5000 1.0000 45.5000 786,473,621.0 35,784,549,755.50 0.7500
2016 44.8400 1.0000 44.8400 736,384,650.0 33,019,487,706.00 0.7319
2017 51.3300 1.0000 51.3300 712,973,139.0 36,596,911,224.87 0.7897
2018 47.3300 1.0000 47.3300 685,618,701.0 32,450,333,118.33 0.6074
2019 56.8700 1.0000 56.8700 646,742,854.0 36,780,266,106.98 0.6470
2020 38.9800 1.0000 38.9800 637,734,301.0 24,858,883,052.98 0.3490
2021 37.9000 1.0000 37.9000 640,013,818.0 24,256,523,702.20 0.3440
2022 31.9300 1.0000 31.9300 641,188,362.0 20,473,144,398.66 0.2967
2023 39.9100 1.0000 39.9100 643,463,433.0 25,680,625,611.03 0.3772
2024 59.9800 1.0000 59.9800 645,281,221.0 38,703,967,635.58 0.5715
2025 70.1300 1.0000 70.1300 652,962,768.0 45,792,278,919.84 0.6460
0000073887 Bristow Group Inc Bristow nan 2010 nan nan nan nan nan nan
2011 nan nan nan 36,161,521.0 nan nan
2012 nan nan nan 35,766,934.0 nan nan
2013 nan nan nan 36,622,619.0 nan nan
2014 nan nan nan 35,158,196.0 nan nan
2015 nan nan nan nan nan nan
0000092380 Southwest Airlines CO Southwe LUV 2010 11.1700 1.0000 11.1700 nan nan nan
2011 7.3200 1.0000 7.3200 772,906,217.0 5,657,673,508.44 0.5008
2012 8.9900 1.0000 8.9900 728,096,579.0 6,545,588,245.21 0.5634
2013 16.4400 1.0000 16.4400 696,720,541.0 11,454,085,694.04 0.9155
2014 36.4600 1.0000 36.4600 678,744,363.0 24,747,019,474.98 1.8945
2015 38.4900 1.0000 38.4900 650,355,108.0 25,032,168,106.92 1.7432
2016 44.9300 1.0000 44.9300 615,597,738.0 27,658,806,368.34 1.8361
2017 59.3900 1.0000 59.3900 593,387,660.0 35,241,293,127.40 2.2015
2021 38.7400 1.0000 38.7400 591,919,907.0 22,930,977,197.18 1.0082
2022 33.1400 1.0000 33.1400 593,752,004.0 19,676,941,412.56 0.8603
2023 27.7900 1.0000 27.7900 595,633,723.0 16,552,661,162.17 0.6792
2024 32.7300 1.0000 32.7300 598,456,459.0 19,587,479,903.07 0.8512
2025 41.1000 1.0000 41.1000 517,155,080.0 21,255,073,788.00 1.0632
0000100517 United Airlines Holdings Inc United UAL 2010 23.9100 1.0000 23.9100 nan nan nan
2011 20.0600 1.0000 20.0600 nan nan nan
2013 37.3100 1.0000 37.3100 361,871,592.0 13,501,429,097.52 0.4521
2014 64.5900 1.0000 64.5900 369,070,761.0 23,838,280,452.99 0.9562
2015 58.0200 1.0000 58.0200 372,810,266.0 21,630,451,633.32 0.8121
2016 74.4500 1.0000 74.4500 317,285,583.0 23,621,911,654.35 0.9012
2017 67.1900 1.0000 67.1900 296,252,435.0 19,905,201,107.65 0.7237
2018 83.7700 1.0000 83.7700 272,464,412.0 22,824,343,793.24 0.7869
2019 89.1900 1.0000 89.1900 253,043,650.0 22,568,963,143.50 0.6682
2020 43.9900 1.0000 43.9900 290,990,973.0 12,800,692,902.27 0.3542
2021 44.2800 1.0000 44.2800 323,806,517.0 14,338,152,572.76 0.3316
0000230211 Federal Express CORP Federal nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
0000350403 PHI Group Inc DE PHI Gro nan 2011 nan nan nan 2,852,616.0 nan nan
2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
0000353184 AIR T INC AIR T I AIRT 2013 7.6400 1.5000 11.4600 2,446,286.0 28,034,437.56 1.2762
2014 16.5500 1.5000 24.8300 2,355,028.0 58,475,345.24 2.5282
2015 15.7200 1.5000 23.5800 2,372,527.0 55,944,186.66 2.1637
2016 15.2400 1.5000 22.8600 2,042,789.0 46,698,156.54 1.3531
2018 17.8000 1.5000 26.7000 2,029,614.0 54,190,693.80 0.6450
2020 15.1500 1.0000 15.1500 2,881,853.0 43,660,072.95 0.3213
2021 24.4900 1.0000 24.4900 2,881,853.0 70,576,579.97 0.5426
0000701345 US Airways Group INC US Airw nan 2011 nan nan nan 162,112,185.0 nan nan
2012 nan nan nan 162,136,198.0 nan nan
0000810332 Republic Airways Holdings INC Republi RJET 2020 96.0000 0.0670 6.4300 35,526,918.0 228,438,082.74 0.1795
2021 84.4500 0.0670 5.6600 35,958,759.0 203,526,575.94 0.1678
0000816159 AIR Methods CORP AIR Met nan 2011 nan nan nan 12,708,185.0 nan nan
2012 nan nan nan nan nan nan
2013 nan nan nan 39,039,989.0 nan nan
2014 nan nan nan 39,205,446.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0000842722 Fuse Science Inc Fuse Sc nan 2012 nan nan nan 126,202,256.0 nan nan
2013 nan nan nan 273,763,024.0 nan nan
0000894081 Air Transport Services Group Inc Air Tra nan 2011 nan nan nan 64,069,154.0 nan nan
2024 nan nan nan 65,759,904.0 nan nan
0000899394 Harbor Diversified INC Harbor nan 2019 nan nan nan nan nan nan
2020 nan nan nan 54,863,305.0 nan nan
2021 nan nan nan 54,139,833.0 nan nan
2022 nan nan nan 45,652,266.0 nan nan
0000914397 Great Lakes Aviation LTD Great L nan 2011 nan nan nan 14,291,970.0 nan nan
2012 nan nan nan 8,919,990.0 nan nan
2013 nan nan nan 8,974,990.0 nan nan
2014 nan nan nan 8,974,990.0 nan nan
0001048911 Fedex CORP Fedex C FDX 2010 77.1200 1.0000 77.1200 nan nan nan
2011 70.3000 1.0000 70.3000 314,484,094.0 22,108,231,808.20 1.3703
2012 77.3200 1.0000 77.3200 314,461,506.0 24,314,163,643.92 1.3784
2013 120.2100 1.0000 120.2100 312,228,182.0 37,532,949,758.22 1.9093
2014 148.6300 1.0000 148.6300 283,312,620.0 42,108,754,710.60 2.1943
2015 127.1900 1.0000 127.1900 275,615,246.0 35,055,503,138.74 1.6501
2016 164.6900 1.0000 164.6900 266,509,290.0 43,891,414,970.10 1.6266
2017 216.7100 1.0000 216.7100 267,889,623.0 58,054,360,200.33 2.0561
2018 140.8900 1.0000 140.8900 261,043,625.0 36,778,436,326.25 1.1872
2019 134.5800 1.0000 134.5800 261,119,074.0 35,141,404,978.92 1.1083
2020 244.0600 1.0000 244.0600 265,070,592.0 64,693,128,683.52 1.5425
2021 233.2700 1.0000 233.2700 264,969,342.0 61,809,398,408.34 1.2819
2022 161.6500 1.0000 161.6500 252,397,140.0 40,799,997,681.00 0.8138
0001128281 Saker Aviation Services Inc Saker A SKAS 2012 2.1300 0.0330 0.0700 33,040,422.0 2,312,829.54 0.3849
2014 2.2000 0.0330 0.0700 33,107,610.0 2,317,532.70 0.4693
2015 1.6000 0.0330 0.0500 33,107,610.0 1,655,380.50 0.4073
2016 3.1800 0.0330 0.1000 33,157,610.0 3,315,761.00 0.7648
2017 3.0600 0.0330 0.1000 33,422,995.0 3,342,299.50 0.8524
2018 2.2100 0.0330 0.0700 30,195,034.0 2,113,652.38 0.6000
2019 5.6800 1.0000 5.6800 1,013,033.0 5,754,027.44 1.2865
2021 2.5500 1.0000 2.5500 1,028,863.0 2,623,600.65 0.7793
2022 5.6000 1.0000 5.6000 976,330.0 5,467,448.00 1.3595
2023 7.8200 1.0000 7.8200 976,330.0 7,634,900.60 1.1835
2024 7.7900 1.0000 7.7900 989,994.0 7,712,053.26 1.2756
2025 6.6000 1.0000 6.6000 997,182.0 6,581,401.20 1.4027
0001135185 Atlas AIR Worldwide Holdings INC Atlas A nan 2011 nan nan nan 26,302,167.0 nan nan
2012 nan nan nan 26,443,441.0 nan nan
2013 nan nan nan 25,038,629.0 nan nan
2014 nan nan nan 24,805,297.0 nan nan
2015 nan nan nan 24,631,001.0 nan nan
2016 nan nan nan 25,009,609.0 nan nan
2017 nan nan nan 25,283,100.0 nan nan
2018 nan nan nan 25,590,293.0 nan nan
2019 nan nan nan 25,870,876.0 nan nan
2020 nan nan nan 27,517,297.0 nan nan
2021 nan nan nan 29,028,291.0 nan nan
2022 nan nan nan 28,364,198.0 nan nan
0001158463 Jetblue Airways CORP Jetblue JBLU 2010 6.6300 1.0000 6.6300 nan nan nan
2011 5.3100 1.0000 5.3100 297,160,580.0 1,577,922,679.80 0.3717
2012 5.7400 1.0000 5.7400 284,298,140.0 1,631,871,323.60 0.3761
2013 8.5500 1.0000 8.5500 282,338,879.0 2,413,997,415.45 0.5231
2014 15.4500 1.0000 15.4500 291,811,585.0 4,508,488,988.25 0.9225
2015 23.3000 1.0000 23.3000 315,060,521.0 7,340,910,139.30 1.3426
2016 22.2800 1.0000 22.2800 323,732,696.0 7,212,764,466.88 1.2316
2017 22.3900 1.0000 22.3900 320,646,948.0 7,179,285,165.72 1.1790
2018 16.0600 1.0000 16.0600 304,786,233.0 4,894,866,901.98 0.7624
2019 18.9300 1.0000 18.9300 288,694,046.0 5,464,978,290.78 0.7496
2020 14.4500 1.0000 14.4500 272,483,649.0 3,937,388,728.05 0.4897
2021 14.4500 1.0000 14.4500 318,030,520.0 4,595,541,014.00 0.5388
2022 6.4600 1.0000 6.4600 323,877,614.0 2,092,249,386.44 0.2494
2023 5.7100 1.0000 5.7100 333,289,326.0 1,903,082,051.46 0.2177
2024 7.7400 1.0000 7.7400 346,876,706.0 2,684,825,704.44 0.2591
2025 4.7300 1.0000 4.7300 363,710,720.0 1,720,351,705.60 0.1642
0001159154 Republic Airways Holdings INC Republi nan 2013 nan nan nan 48,558,312.0 nan nan
2014 nan nan nan 49,786,619.0 nan nan
2015 nan nan nan nan nan nan
0001172222 Hawaiian Holdings INC Hawaiia nan 2011 nan nan nan 50,712,907.0 nan nan
2012 nan nan nan 51,388,041.0 nan nan
2014 nan nan nan 54,023,742.0 nan nan
2015 nan nan nan 53,214,218.0 nan nan
2016 nan nan nan 53,426,475.0 nan nan
2017 nan nan nan 52,471,736.0 nan nan
2018 nan nan nan 49,403,496.0 nan nan
2019 nan nan nan 46,591,737.0 nan nan
2020 nan nan nan 46,003,751.0 nan nan
2021 nan nan nan 51,212,761.0 nan nan
2022 nan nan nan 51,411,336.0 nan nan
0001362468 Allegiant Travel CO Allegia ALGT 2024 nan nan nan 18,343,946.0 nan nan
2025 nan nan nan 18,313,574.0 nan nan
0001498710 Spirit Aviation Holdings Inc Spirit FLYYQ 2011 nan 1.0000 nan 72,530,256.0 nan nan
2012 nan 1.0000 nan nan nan nan
2013 nan 1.0000 nan 72,647,167.0 nan nan
2014 nan 1.0000 nan 72,766,894.0 nan nan
2015 nan 1.0000 nan 71,539,630.0 nan nan
2016 nan 1.0000 nan 69,322,496.0 nan nan
2017 nan 1.0000 nan 69,373,154.0 nan nan
2018 nan 1.0000 nan 68,264,513.0 nan nan
2019 nan 1.0000 nan 68,448,433.0 nan nan
2020 nan 1.0000 nan 97,678,265.0 nan nan
2021 nan 1.0000 nan 108,405,182.0 nan nan
2022 nan 1.0000 nan 108,857,162.0 nan nan
2023 nan 1.0000 nan 109,167,560.0 nan nan
2024 nan 1.0000 nan 109,523,815.0 nan nan
0001514226 Delta Tucker Holdings Inc Delta T nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
0001525221 Bristow Group Inc Bristow VTOL 2013 61.9900 0.5000 31.0000 20,189,222.0 625,865,882.00 0.8450
2014 42.3700 0.5000 21.1800 20,371,872.0 431,476,248.96 0.5483
2024 33.2600 1.0000 33.2600 28,628,000.0 952,167,280.00 0.5669
2025 36.3100 1.0000 36.3100 28,920,000.0 1,050,085,200.00 0.5895
0001670076 Frontier Group Holdings Inc Frontie ULCC 2021 13.9200 1.0000 13.9200 216,012,632.0 3,006,895,837.44 0.7574
2022 10.5700 1.0000 10.5700 217,763,933.0 2,301,764,771.81 0.5423
2023 5.4400 1.0000 5.4400 221,063,721.0 1,202,586,642.24 0.2537
2024 7.1100 1.0000 7.1100 225,372,311.0 1,602,397,131.21 0.2737
2025 4.8400 1.0000 4.8400 228,950,914.0 1,108,122,423.76 0.1589
0001743907 Sun Country Airlines Holdings Inc Sun Cou SNCY 2021 27.0800 1.0000 27.0800 57,872,452.0 1,567,186,000.16 1.3832
2022 16.0900 1.0000 16.0900 57,325,238.0 922,363,079.42 0.7217
2023 16.0700 1.0000 16.0700 53,291,001.0 856,386,386.07 0.6267
2024 14.9200 1.0000 14.9200 53,157,964.0 793,116,822.88 0.5897
2025 14.5600 1.0000 14.5600 53,223,302.0 774,931,277.12 0.5665
0001779128 Strata Critical Medical Inc Strata SRTA 2021 8.8900 1.0000 8.8900 70,552,827.0 627,214,632.03 3.1713
2022 3.6300 1.0000 3.6300 71,653,281.0 260,101,410.03 1.3870
2023 3.4400 1.0000 3.4400 74,633,754.0 256,740,113.76 1.4441
2024 4.1000 1.0000 4.1000 78,314,023.0 321,087,494.30 2.2037
2025 5.0200 1.0000 5.0200 86,366,526.0 433,559,960.52 2.3294
0001819516 Wheels Up Experience Inc Wheels UP 2021 44.7000 0.1000 4.4700 245,740,164.0 1,098,458,533.08 0.6810
2022 10.3500 0.1000 1.0300 247,502,983.0 254,928,072.49 0.1425
2023 2.9600 1.0000 2.9600 166,812,505.0 493,765,014.80 0.3900
2024 1.7500 1.0000 1.7500 697,811,664.0 1,221,170,412.00 0.9722
2025 0.6300 1.0000 0.6300 721,707,858.0 454,675,950.54 0.3928
0001846084 Global Crossing Airlines Group Inc Global JETMF 2022 nan nan nan nan nan nan