QA: us_air 2010-2023

Table of Contents

Ranks across the years

name name_short 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 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 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
0001128281 Saker Aviation Services Inc Saker A NaN NaN 8 NaN 11 6 2 6 2 1 NaN 1 1 1 NaN NaN 63.6616 NaN 38.04090 88.11700 103.6260 96.8369 95.04450 101.37600 NaN 122.476000 152.7960 163.45500 NaN NaN NaN NaN -5 -4 4 -4 -1 NaN NaN 0 0
0000092380 Southwest Airlines Co Southwe 2 8 7 6 7 7 3 2 NaN NaN NaN 4 4 2 91.06400 63.99790 70.6258 71.5704 70.00950 85.22140 99.7536 116.4660 NaN NaN NaN 73.860900 60.5280 52.84960 6 -1 -1 1 0 -4 -1 NaN NaN NaN NaN 0 -2
0001158463 Jetblue Airways Corp Jetblue 4 6 6 8 5 5 4 3 6 3 7 5 6 3 78.33210 72.00190 70.8508 69.1006 80.12060 92.14030 96.2232 109.5550 69.92780 83.93270 22.78680 54.369900 44.1098 49.23520 2 0 2 -3 0 -1 -1 3 -3 4 -2 1 -3
0001498710 Spirit Airlines Inc Spirit NaN 2 1 1 1 2 1 1 3 2 3 8 7 4 NaN 94.33950 101.0340 116.5830 122.54400 124.06700 108.6670 118.8100 85.74410 94.20020 49.47650 48.879600 43.5508 48.79920 NaN -1 0 0 1 -1 0 2 -1 1 5 -1 -3
0001743907 Sun Country Airlines Holdings Inc Sun Cou NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 10 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 39.321100 22.8032 32.68130 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 -5
0000027904 Delta AIR Lines INC Delta A 8 16 NaN 5 16 13 10 10 8 7 11 14 11 6 4.67069 3.46390 NaN 81.4750 6.59825 36.22970 37.8698 35.1998 31.79550 35.01460 -46.22670 7.323550 12.2691 25.73680 8 NaN NaN 11 -3 -3 0 -2 -1 4 3 -3 -5
0001670076 Frontier Group Holdings Inc Frontie NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15 12 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.002141 3.8438 4.71537 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3 -5
0001779128 Blade Air Mobility Inc Blade A NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 13 8 8 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 20.574000 37.4119 -15.19780 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -5 0
0001819516 Wheels Up Experience Inc Wheels NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 12 13 9 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 22.813000 -74.3703 -96.59350 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 -4
0000004515 American Airlines INC America 7 13 16 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 26.04300 6.24662 10.9953 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000006201 American Airlines Group Inc America 6 14 14 15 15 11 13 11 10 8 10 NaN NaN NaN 40.89220 5.33324 21.2760 -11.2619 12.24210 49.24360 17.0485 13.9157 5.67749 6.28399 -42.22220 NaN NaN NaN 8 0 1 0 -4 2 -2 -1 -2 2 NaN NaN NaN
0000073887 Bristow Group Inc Bristow 1 1 2 3 2 10 NaN NaN NaN NaN NaN NaN NaN NaN 109.78000 111.75700 95.4463 103.2010 104.52600 80.48020 NaN NaN NaN NaN NaN NaN NaN NaN 0 1 1 -1 8 NaN NaN NaN NaN NaN NaN NaN NaN
0000100517 United Airlines Holdings Inc United 5 12 NaN 10 9 1 9 8 5 5 8 9 NaN NaN 54.11950 24.72880 NaN 35.5107 52.84890 126.53000 75.6725 73.1825 75.12510 79.35250 12.20930 46.407900 NaN NaN 7 NaN NaN -1 -8 8 -1 -3 0 3 1 NaN NaN
0001048911 Fedex Corp Fedex C 3 4 5 4 3 9 6 5 1 6 1 3 2 NaN 80.05080 92.34000 81.8216 98.9967 103.24000 82.81180 86.2775 98.5236 106.75700 74.83870 82.30330 101.108000 90.4809 NaN 1 1 -1 -1 6 -3 -1 -4 5 -5 2 -1 NaN
0000230211 Federal Express Corp Federal NaN 5 4 7 4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 87.21510 83.3290 70.8472 80.74870 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 3 -3 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000350403 PHI Group Inc De PHI Gro NaN 3 3 2 NaN 3 7 7 11 NaN NaN NaN NaN NaN NaN 93.25650 85.0876 109.8790 NaN 99.22200 83.1703 92.0157 -4.38115 NaN NaN NaN NaN NaN NaN 0 -1 NaN NaN 4 0 4 NaN NaN NaN NaN NaN
0000701345 Us Airways Group INC Us Airw NaN 17 13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3.15145 22.7289 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000816159 AIR Methods Corp AIR Met NaN 11 11 11 10 12 11 NaN NaN NaN NaN NaN NaN NaN NaN 30.01730 40.5478 32.8700 43.45420 45.39430 36.0388 NaN NaN NaN NaN NaN NaN NaN NaN 0 0 -1 2 -1 NaN NaN NaN NaN NaN NaN NaN
0000914397 Great Lakes Aviation LTD Great L NaN 7 10 12 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 69.95220 41.8014 30.9951 -7.43113 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 2 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001135185 Atlas AIR Worldwide Holdings INC Atlas A NaN 10 12 13 13 14 12 9 7 9 4 6 5 NaN NaN 45.16010 39.2539 29.7938 28.97570 21.83940 24.9338 36.4360 38.69610 2.94880 42.30570 53.468400 47.6761 NaN NaN 2 1 0 1 -2 -3 -2 2 -5 2 -1 NaN
0001172222 Hawaiian Holdings INC Hawaiia NaN 9 9 NaN 8 8 5 4 4 4 9 7 9 NaN NaN 49.83340 57.9199 NaN 56.49060 83.99880 87.5017 105.0680 76.10500 80.59770 5.59189 49.628200 32.9146 NaN NaN 0 NaN NaN 0 -3 -1 0 0 5 -2 2 NaN
0001514226 Delta Tucker Holdings Inc Delta T NaN 15 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4.28605 11.8491 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 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 -2924.3900 -3024.9000 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000353184 AIR T INC AIR T I NaN NaN NaN 16 6 4 8 NaN 9 NaN 5 16 NaN NaN NaN NaN NaN -1141.0100 77.50470 92.54170 81.9628 NaN 22.88710 NaN 29.26250 -7.690410 NaN NaN NaN NaN NaN -10 -2 4 NaN NaN NaN NaN 11 NaN NaN
0001159154 Republic Airways Holdings INC Republi NaN NaN NaN 14 14 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11.6213 15.03240 6.92064 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 1 NaN NaN NaN NaN NaN NaN NaN NaN
0001525221 Bristow Group Inc Bristow NaN NaN NaN 9 12 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 35.9908 34.89570 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000899394 Harbor Diversified INC Harbor NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 2 2 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4.86936 59.05100 121.072000 86.1145 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -8 0 1 NaN
0000810332 Mesa AIR Group INC Mesa AI NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 23.61430 23.694900 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 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 -81.9842 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

PDF reports

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

2010

Logs

warning 10 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000092380 0001048911 0000004515 0000006201 0000027904 0000073887 0000100517 0001158463 0000230211 0001514226
warning 6 × The stock price does not exist industry.us_generic
0000073887 0000701345 0000816159 0000899394 0000914397 0001135185
warning 2 × Missing logo subcommand.report
0000004515 0000073887
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 4,320,314,335 7,402,544,068 73,410,075,926 115,267,146,000 120,646,695,000 0000073887 0000004515 0000027904
8 EconomicCapitalRatio 0.0467 0.122 0.662 1.03 1.10 0000027904 0001158463 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.181 -0.168 0.0189 0.241 0.276 0000004515 0001158463 0001048911
1 LiabilitiesNonCurrent -0.484 -0.288 0.0919 0.163 0.184 0000027904 0001158463 0001048911
2 remainder_Liabilities 0 0 0 0 0 0000004515 0000092380 0000004515
3 AssetsCurrent -0.0477 -0.0375 -0.00469 0.0227 0.0338 0000027904 0000073887 0000100517
4 AssetsNoncurrent -0.0114 -0.00972 0.000731 0.0196 0.0207 0000027904 0000073887 0000004515
5 PropertyPlantAndEquipmentNet -0.0954 -0.0910 -0.0373 0.0375 0.0547 0000004515 0000073887 0001158463
6 remainder_Assets -0.0439 -0.0406 -0.00914 0.0952 0.114 0000004515 0000092380 0000027904
7 OperatingExpenses -1.01 -0.938 -0.322 1.23 1.63 0001048911 0000100517 0000073887
8 DepreciationDepletionAndAmortization -0.105 -0.0803 -0.00981 0.0727 0.110 0001048911 0000004515 0000073887
9 remainder_Expenses -1.53 -1.17 0.310 0.548 0.588 0000073887 0001048911 0000006201
10 remainder_Revenues -1.68 -1.67 -0.0141 2.84 3.40 0000004515 0000073887 0001048911
11 remainder_NetIncome -2.59 -2.23 -0.143 1.75 1.76 0001048911 0000027904 0000004515
12 remainder_ComprehensiveNetIncome -0.0825 -0.0520 0.00556 0.00720 0.00723 0001048911 0001158463 0000004515
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.482 -0.340 0.0738 0.359 0.411 0000027904 0001158463 0001048911
1 Assets -0.122 -0.105 -0.0444 0.0516 0.0533 0000004515 0000073887 0000100517
2 Expenses -0.751 -0.574 0.0158 0.230 0.238 0001048911 0001158463 0000027904
3 Revenues -1.68 -1.67 -0.0141 2.84 3.40 0000004515 0000073887 0001048911
4 StockholdersEquity -0.368 -0.334 -0.0141 0.376 0.439 0000027904 0000092380 0000073887
5 NetIncome -0.163 -0.163 -0.0134 0.167 0.174 0000004515 0001158463 0000092380
6 ComprehensiveNetIncome -0.156 -0.156 -0.0190 0.174 0.181 0000004515 0000027904 0000092380
7 BaseVar nan nan nan nan nan 0000004515 0000092380 0000004515
8 EconomicCapitalRatio -0.559 -0.485 0.0562 0.426 0.492 0000027904 0001158463 0000073887

2011

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
0001374135 0001374135
warning 13 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000100517 0000230211 0001048911 0000004515 0000073887 0000816159 0001514226 0000350403 0000092380 0001158463 0001498710 0000027904
warning 10 × No stock price available subcommand.plot
0000100517 0000230211 0000004515 0000073887 0000701345 0000816159 0000914397 0001135185 0001514226 0000350403
warning 7 × The stock price does not exist industry.us_generic
0000100517 0000073887 0000701345 0000816159 0000899394 0000914397 0001135185
warning 7 × Missing logo subcommand.report
0000230211 0000004515 0000073887 0000701345 0000816159 0000914397 0001514226
warning 3 × Similarly named company. Duplicate? None
0000006201 0001514226 0001158463
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001374135
warning 1 × Ignoring company because Expenses is zero pre-agg
0000100517
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 39,748,263 1,414,796,800 11,655,400,000 12,701,000,000 0000914397 0001158463 0000027904
1 LiabilitiesNonCurrent 0 0 0 17,130,000,000 32,194,000,000 0000004515 0001498710 0000027904
2 remainder_Liabilities 0 0 0 606,290,600 896,045,000 0000004515 0000100517 0001514226
3 AssetsCurrent 26,859,735 209,947,147 1,630,273,600 8,827,400,000 10,997,000,000 0000914397 0001158463 0000100517
4 AssetsNoncurrent 0 0 228,400,000 3,627,200,000 10,572,000,000 0001135185 0000701345 0000100517
5 PropertyPlantAndEquipmentNet 23,210,000 23,909,200 4,151,136,000 17,179,800,000 20,223,000,000 0001498710 0000701345 0000027904
6 remainder_Assets 0 0 259,909,606 4,769,800,000 14,545,000,000 0000100517 0001172222 0000027904
7 OperatingExpenses 0 0 3,763,062,400 29,694,800,000 31,714,000,000 0000073887 0001158463 0000100517
8 DepreciationDepletionAndAmortization 0 0 233,006,400 1,632,200,000 1,973,000,000 0000073887 0001158463 0001048911
9 remainder_Expenses 14,667,785 83,870,357 894,390,813 5,724,800,000 6,576,000,000 0000914397 0001135185 0001048911
10 remainder_Revenues 0 0 1,398,619,589 37,548,800,000 39,304,000,000 0000004515 0001135185 0001048911
11 remainder_NetIncome -1,206,000,000 -1,022,800,000 9,422 23,193,200,000 23,278,000,000 0000027904 0000350403 0000004515
12 remainder_ComprehensiveNetIncome -1,209,000,000 -885,000,000 0 22,600,000 113,000,000 0000006201 0000816159 0000230211
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities 46,748,000 47,461,968 1,559,744,102 28,785,400,000 44,895,000,000 0000350403 0001514226 0000027904
1 Assets 83,777,500 613,405,900 7,073,022,400 39,090,200,000 43,499,000,000 0000914397 0001158463 0000027904
2 Expenses 124,755,662 453,204,732 4,254,451,200 35,782,200,000 37,739,000,000 0000914397 0001158463 0001048911
3 Revenues 0 0 1,398,619,589 37,548,800,000 39,304,000,000 0000004515 0001135185 0001048911
4 StockholdersEquity -1,396,000,000 -250,290,368 1,143,541,296 16,675,000,000 22,503,000,000 0000027904 0001135185 0001048911
5 NetIncome -1,979,000,000 -1,967,800,000 76,463,283 973,600,000 1,452,000,000 0000006201 0001498710 0001048911
6 ComprehensiveNetIncome -2,583,500,000 -2,088,700,000 76,463,283 962,600,000 1,397,000,000 0000006201 0001498710 0001048911
7 BaseVar 405,269,448 1,608,213,274 15,465,649,048 129,493,032,000 134,732,680,000 0000914397 0001158463 0000027904
8 EconomicCapitalRatio 0.0315 0.0340 0.499 0.978 1.12 0000701345 0001172222 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.199 -0.123 -0.00531 0.184 0.193 0000004515 0001498710 0000914397
1 LiabilitiesNonCurrent -0.454 -0.402 0.114 0.233 0.238 0000027904 0001158463 0001048911
2 remainder_Liabilities -0.481 -0.447 0.0550 0.140 0.142 0000816159 0000701345 0001048911
3 AssetsCurrent -0.0458 -0.0430 -0.00982 0.0103 0.0108 0000027904 0000073887 0001498710
4 AssetsNoncurrent -0.0314 -0.0273 -0.00157 0.0372 0.118 0001514226 0001048911 0000100517
5 PropertyPlantAndEquipmentNet -0.354 -0.208 -0.0245 0.100 0.147 0001514226 0000006201 0001135185
6 remainder_Assets -0.0504 -0.0447 -0.00420 0.134 0.190 0000100517 0000350403 0001514226
7 OperatingExpenses -1.50 -1.43 -0.680 2.07 3.11 0001498710 0000100517 0001514226
8 DepreciationDepletionAndAmortization -0.137 -0.127 -0.0187 0.108 0.134 0000816159 0000100517 0001498710
9 remainder_Expenses -3.85 -2.23 0.742 1.09 1.12 0001514226 0001048911 0000701345
10 remainder_Revenues -3.00 -2.84 0.628 1.98 1.99 0000006201 0000100517 0001048911
11 remainder_NetIncome -1.26 -1.25 -0.642 2.74 2.88 0000230211 0000350403 0000006201
12 remainder_ComprehensiveNetIncome -0.0893 -0.0394 0.00597 0.0136 0.0265 0000006201 0000350403 0000230211
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.460 -0.400 0.0698 0.449 0.472 0000027904 0000914397 0001048911
1 Assets -0.314 -0.253 -0.0331 0.0964 0.120 0001514226 0000230211 0001135185
2 Expenses -0.655 -0.638 -0.135 0.352 0.361 0000230211 0000701345 0000816159
3 Revenues -3.00 -2.84 0.628 1.98 1.99 0000006201 0000100517 0001048911
4 StockholdersEquity -0.498 -0.487 -0.0393 0.548 0.568 0001514226 0000230211 0000073887
5 NetIncome -0.402 -0.380 -0.00120 0.303 0.320 0000006201 0000027904 0000914397
6 ComprehensiveNetIncome -0.492 -0.392 -0.00292 0.314 0.330 0000006201 0001158463 0000914397
7 BaseVar nan nan nan nan nan 0000004515 0000701345 0000004515
8 EconomicCapitalRatio -0.473 -0.470 -0.00561 0.474 0.613 0000701345 0001172222 0000073887

2012

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0001374135
warning 13 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000004515 0000006201 0000073887 0000092380 0000100517 0000230211 0000350403 0001048911 0001158463 0001514226 0000816159 0001498710 0000027904
warning 10 × No stock price available subcommand.plot
0000004515 0000073887 0000230211 0000350403 0000701345 0001135185 0001514226 0000816159 0000914397 0001498710
warning 9 × The stock price does not exist industry.us_generic
0000073887 0000100517 0000701345 0001135185 0001172222 0000816159 0000914397 0001159154 0000899394
warning 8 × Missing logo subcommand.report
0000004515 0000073887 0000230211 0000701345 0000842722 0001514226 0000816159 0000914397
warning 2 × Similarly named company. Duplicate? None
0000006201 0001158463
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -5.760808162903748}
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because Expenses is zero pre-agg
0000100517
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 15,596,104 42,715,750 6,646,729,104 94,106,647,000 129,517,455,000 0000842722 0001135185 0001048911
8 EconomicCapitalRatio -29.2 -5.76 0.579 0.966 1.01 0000842722 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.229 -0.164 0.0357 0.446 1.55 0000004515 0001135185 0000842722
1 LiabilitiesNonCurrent -4.06 -1.24 0.0676 0.132 0.132 0000842722 0001158463 0001048911
2 remainder_Liabilities -4.20 -1.31 0.0654 0.136 0.137 0000842722 0000006201 0001048911
3 AssetsCurrent -8.65 -1.76 -0.0112 0.0136 0.0222 0000842722 0001048911 0000350403
4 AssetsNoncurrent -0.0183 -0.0152 -0.000223 0.243 1.08 0001514226 0000350403 0000842722
5 PropertyPlantAndEquipmentNet -16.8 -3.62 -0.00682 0.133 0.173 0000842722 0000230211 0001135185
6 remainder_Assets -6.76 -1.39 -0.00778 0.0690 0.160 0000842722 0001048911 0001514226
7 OperatingExpenses -2.06 -1.97 -1.10 3.95 6.40 0001498710 0000004515 0000842722
8 DepreciationDepletionAndAmortization -0.145 -0.137 -0.0306 0.235 0.381 0000816159 0000004515 0000842722
9 remainder_Expenses -14.0 -6.05 1.23 1.89 1.96 0000842722 0001158463 0000914397
10 remainder_Revenues -8.14 -3.80 1.28 2.57 2.98 0000842722 0000092380 0001128281
11 remainder_NetIncome -12.3 -3.66 -0.936 2.81 2.99 0000842722 0000701345 0000006201
12 remainder_ComprehensiveNetIncome -0.176 -0.0551 0.00157 0.0756 0.0797 0001048911 0001135185 0000006201
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -6.36 -1.63 0.0371 0.356 0.378 0000842722 0001172222 0001048911
1 Assets -19.8 -4.20 -0.0286 0.115 0.191 0000842722 0000006201 0001135185
2 Expenses -7.21 -1.86 -0.0612 0.490 0.549 0000842722 0000004515 0001135185
3 Revenues -8.14 -3.80 1.28 2.57 2.98 0000842722 0000092380 0001128281
4 StockholdersEquity -1.62 -0.733 -0.0318 0.484 0.561 0000842722 0000006201 0000073887
5 NetIncome -27.7 -5.42 0.530 0.976 1.05 0000842722 0000816159 0001498710
6 ComprehensiveNetIncome -27.7 -5.36 0.531 0.978 1.05 0000842722 0000816159 0001498710
7 BaseVar nan nan nan nan nan 0000004515 0000842722 0000004515
8 EconomicCapitalRatio -28.1 -4.57 1.77 2.16 2.20 0000842722 0001172222 0001498710

2013

Logs

error 3 × Unusually strong effect check_effects
{'var_name': 'NetIncome', 'quantile_value': '-14.1', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-14.2', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-13.2', 'quantile': 0.05}
error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 14 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000073887 0000092380 0000100517 0000230211 0000842722 0001048911 0001158463 0000350403 0000816159 0001514226 0001498710 0000004515
warning 10 × The stock price does not exist industry.us_generic
0000073887 0000100517 0001135185 0001159154 0001172222 0000816159 0000914397 0001586300 0000701345 0000899394
warning 7 × No stock price available subcommand.plot
0000073887 0000230211 0001135185 0001159154 0000350403 0000816159 0000914397
warning 7 × Missing logo subcommand.report
0000073887 0000230211 0000842722 0001159154 0001525221 0000816159 0000914397
warning 2 × Similarly named company. Duplicate? None
0001159154 0001525221
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000842722 0000350403
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 2 × Ignoring company because Assets is zero pre-agg
0001586300 0001514226
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -15.177888606249597}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001172222
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 30,547,334 129,535,408 6,479,859,384 134,903,557,000 135,761,665,000 0000842722 0001159154 0000027904
8 EconomicCapitalRatio -30.2 -15.2 0.360 1.11 1.17 0000842722 0001525221 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.604 -0.354 -0.00585 0.152 0.162 0000353184 0001498710 0001048911
1 LiabilitiesNonCurrent -8.39 -2.89 0.0823 0.286 0.292 0000842722 0000816159 0001498710
2 remainder_Liabilities -8.95 -3.11 0.131 0.309 0.316 0000842722 0000027904 0001498710
3 AssetsCurrent -8.46 -1.72 -0.00928 1.52 7.40 0000842722 0000092380 0000353184
4 AssetsNoncurrent -1.41 -0.693 -0.000964 0.0293 0.105 0000842722 0000230211 0000100517
5 PropertyPlantAndEquipmentNet -19.8 -7.95 -0.0117 0.235 0.309 0000842722 0000816159 0001525221
6 remainder_Assets -7.70 -2.26 -0.00733 0.0338 0.0348 0000842722 0001525221 0000027904
7 OperatingExpenses -2.28 -2.15 -0.231 3.16 5.85 0000914397 0000006201 0000842722
8 DepreciationDepletionAndAmortization -0.159 -0.146 0.00944 0.156 0.380 0001048911 0000006201 0000842722
9 remainder_Expenses -9.37 -7.28 0.542 1.84 2.04 0000353184 0000006201 0000914397
10 remainder_Revenues -8.14 -4.55 0.556 2.33 2.37 0000842722 0000816159 0001498710
11 remainder_NetIncome -18.6 -4.17 -0.219 2.86 3.23 0000842722 0000027904 0000350403
12 remainder_ComprehensiveNetIncome -0.0650 -0.0503 -0.0123 0.0611 0.0854 0000842722 0000816159 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -13.5 -5.16 -0.0117 0.545 0.606 0000842722 0000100517 0001048911
1 Assets -22.2 -7.39 -0.00262 0.191 0.260 0000842722 0001048911 0001525221
2 Expenses -6.78 -1.88 0.0628 0.564 0.712 0000353184 0000100517 0000027904
3 Revenues -8.14 -4.55 0.556 2.33 2.37 0000842722 0000816159 0001498710
4 StockholdersEquity -1.62 -0.541 -0.000761 0.473 0.537 0000842722 0001135185 0000073887
5 NetIncome -27.3 -14.1 0.806 1.45 1.71 0000842722 0000073887 0001498710
6 ComprehensiveNetIncome -27.4 -14.2 0.763 1.49 1.69 0000842722 0001158463 0001498710
7 BaseVar nan nan nan nan nan 0000006201 0000816159 0000006201
8 EconomicCapitalRatio -28.3 -13.2 2.29 3.04 3.09 0000842722 0001525221 0001498710

2014

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000073887 0000092380 0000100517 0000230211 0000350403 0000842722 0001048911 0001158463 0001159154 0001498710 0001514226 0001586300 0000816159 0000004515
warning 10 × The stock price does not exist industry.us_generic
0000073887 0000100517 0001135185 0001159154 0001172222 0001586300 0000816159 0000914397 0000701345 0000899394
warning 6 × No stock price available subcommand.plot
0000073887 0000230211 0001135185 0001159154 0000816159 0000914397
warning 6 × Missing logo subcommand.report
0000073887 0000230211 0001159154 0001525221 0000816159 0000914397
warning 5 × Ignoring company because Assets is zero pre-agg
0001514226 0001586300 0001586300 0001586300 0001586300
warning 2 × Similarly named company. Duplicate? None
0001159154 0001525221
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000350403 0000842722
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 52,667,397 180,653,620 7,767,958,079 152,134,830,000 157,045,530,000 0001128281 0001172222 0000027904
8 EconomicCapitalRatio -0.0743 0.0379 0.529 1.08 1.23 0000914397 0000100517 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.149 -0.135 0.00962 0.210 0.318 0001172222 0001135185 0000353184
1 LiabilitiesNonCurrent -0.500 -0.422 0.125 0.260 0.338 0001135185 0001172222 0000353184
2 remainder_Liabilities -0.528 -0.479 0.185 0.375 0.474 0001159154 0001172222 0000353184
3 AssetsCurrent -0.0473 -0.0380 -0.00379 0.0325 0.0486 0001128281 0001135185 0000353184
4 AssetsNoncurrent -0.0366 -0.0194 -0.00237 0.0247 0.0928 0001128281 0001525221 0000100517
5 PropertyPlantAndEquipmentNet -0.298 -0.160 -0.0136 0.250 0.308 0001128281 0000073887 0001525221
6 remainder_Assets -0.0762 -0.0582 -0.00898 0.0464 0.143 0000914397 0000230211 0000027904
7 OperatingExpenses -1.63 -1.60 -0.757 4.14 4.75 0000230211 0000006201 0000353184
8 DepreciationDepletionAndAmortization -0.207 -0.156 -0.0128 0.284 0.305 0000914397 0001172222 0001128281
9 remainder_Expenses -7.52 -6.18 0.794 1.23 1.31 0000353184 0001048911 0000100517
10 remainder_Revenues -2.70 -2.42 0.272 2.64 3.21 0001158463 0000914397 0000353184
11 remainder_NetIncome -1.21 -1.00 -0.393 2.38 2.85 0001128281 0000914397 0001158463
12 remainder_ComprehensiveNetIncome -0.0635 -0.0607 0.0136 0.0520 0.0594 0000100517 0001135185 0000353184
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.441 -0.350 0.218 0.658 0.798 0001159154 0001158463 0000353184
1 Assets -0.329 -0.168 -0.0111 0.203 0.262 0001128281 0000092380 0001525221
2 Expenses -2.49 -1.74 -0.0594 0.434 0.464 0000353184 0001158463 0001525221
3 Revenues -2.70 -2.42 0.272 2.64 3.21 0001158463 0000914397 0000353184
4 StockholdersEquity -0.627 -0.535 0.0331 0.279 0.466 0001128281 0000100517 0000073887
5 NetIncome -0.536 -0.318 -0.0101 0.202 0.411 0000914397 0001525221 0001498710
6 ComprehensiveNetIncome -0.515 -0.273 0.00253 0.243 0.438 0000914397 0000006201 0001498710
7 BaseVar nan nan nan nan nan 0000006201 0000914397 0000006201
8 EconomicCapitalRatio -0.615 -0.503 -0.0125 0.540 0.684 0000914397 0000100517 0001498710

2015

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000073887 0000092380 0000100517 0001048911 0001158463 0001159154 0001498710 0001586300 0000350403 0000816159 0001514226 0000004515 0000230211 0000842722
warning 10 × The stock price does not exist industry.us_generic
0000073887 0000100517 0001135185 0001159154 0001172222 0001586300 0000816159 0000701345 0000899394 0000914397
warning 5 × No stock price available subcommand.plot
0000073887 0001135185 0001159154 0000350403 0000816159
warning 4 × Ignoring company because Assets is zero pre-agg
0001586300 0001586300 0001586300 0001514226
warning 3 × Missing logo subcommand.report
0000073887 0001159154 0000816159
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000350403 0000842722
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 1 × Similarly named company. Duplicate? None
0001159154
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 45,068,884 234,418,251 7,481,696,361 145,339,112,000 148,086,990,000 0001128281 0001172222 0000027904
8 EconomicCapitalRatio 0.0692 0.174 0.840 1.25 1.27 0001159154 0001172222 0000100517

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.470 -0.209 0.0379 0.472 0.563 0001159154 0001135185 0000353184
1 LiabilitiesNonCurrent -0.506 -0.457 0.146 0.360 0.397 0000006201 0001158463 0000353184
2 remainder_Liabilities -0.602 -0.207 0.0633 0.131 0.191 0000816159 0000350403 0000353184
3 AssetsCurrent -0.0378 -0.0370 -0.00685 0.0187 0.0238 0001498710 0001128281 0000816159
4 AssetsNoncurrent -0.0563 -0.0290 -0.00643 0.0177 0.0508 0000100517 0001172222 0000006201
5 PropertyPlantAndEquipmentNet -0.0589 -0.0584 0.00178 0.238 0.271 0001128281 0000350403 0001159154
6 remainder_Assets -0.0330 -0.0274 -0.00382 0.0549 0.116 0001498710 0001048911 0000027904
7 OperatingExpenses -1.70 -1.51 -0.455 3.63 4.02 0001048911 0000027904 0000353184
8 DepreciationDepletionAndAmortization -0.142 -0.105 -0.0187 0.290 0.321 0001048911 0000027904 0000353184
9 remainder_Expenses -6.99 -6.01 0.674 1.35 1.60 0000353184 0000027904 0000100517
10 remainder_Revenues -2.58 -2.48 0.255 2.85 3.17 0001158463 0000006201 0000353184
11 remainder_NetIncome -1.10 -1.06 -0.394 2.47 2.67 0001128281 0001498710 0001158463
12 remainder_ComprehensiveNetIncome -0.0784 -0.0385 0.00574 0.0221 0.0259 0000073887 0000350403 0001172222
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.447 -0.441 0.194 0.716 0.846 0001159154 0001172222 0000353184
1 Assets -0.0646 -0.0523 -0.00564 0.170 0.188 0001128281 0000027904 0001159154
2 Expenses -2.65 -2.09 -0.0187 0.356 0.373 0000353184 0001158463 0001135185
3 Revenues -2.58 -2.48 0.255 2.85 3.17 0001158463 0000006201 0000353184
4 StockholdersEquity -0.648 -0.616 0.00660 0.419 0.516 0001128281 0001048911 0000350403
5 NetIncome -0.521 -0.366 0.00230 0.323 0.443 0000353184 0001172222 0000100517
6 ComprehensiveNetIncome -0.508 -0.369 0.0282 0.333 0.462 0000353184 0001172222 0000100517
7 BaseVar nan nan nan nan nan 0000006201 0000816159 0000006201
8 EconomicCapitalRatio -0.674 -0.570 0.0968 0.505 0.522 0001159154 0001172222 0000100517

2016

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000092380 0000100517 0001048911 0001158463 0001498710 0000350403 0000816159 0001514226 0000004515 0000073887 0000230211 0000842722 0001159154 0001586300
warning 10 × The stock price does not exist industry.us_generic
0000100517 0001135185 0001172222 0000816159 0000073887 0000701345 0000899394 0000914397 0001159154 0001586300
warning 3 × No stock price available subcommand.plot
0001135185 0000350403 0000816159
warning 3 × Ignoring company because Assets is zero pre-agg
0001514226 0001586300 0001586300
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000350403 0000842722
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 1 × Missing logo subcommand.report
0000816159
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 41,743,510 267,266,087 8,251,013,480 153,332,727,000 156,506,055,000 0001128281 0001135185 0001048911
8 EconomicCapitalRatio 0.170 0.218 0.832 1.06 1.09 0000006201 0000350403 0001498710

Effect quantiles (final effects with respect to final var and normalized if applicable)

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -0.148 -0.145 0.00600 0.286 0.319 0001172222 0001135185 0000353184
1 LiabilitiesNonCurrent -0.418 -0.418 0.180 0.395 0.415 0000006201 0000100517 0000353184
2 remainder_Liabilities -0.618 -0.231 0.0695 0.127 0.173 0000816159 0001128281 0000353184
3 AssetsCurrent -0.0410 -0.0389 -0.00269 0.0269 0.0422 0001135185 0001128281 0000350403
4 AssetsNoncurrent -0.0171 -0.0162 -0.0000339 0.0494 0.0639 0000353184 0000092380 0000006201
5 PropertyPlantAndEquipmentNet -0.0991 -0.0633 -0.000621 0.140 0.259 0000353184 0001172222 0001135185
6 remainder_Assets -0.0454 -0.0297 -0.00146 0.0714 0.0978 0000006201 0001172222 0000027904
7 OperatingExpenses -1.19 -1.15 -0.557 3.71 4.34 0000100517 0000006201 0000353184
8 DepreciationDepletionAndAmortization -0.0900 -0.0879 -0.0270 0.293 0.343 0001048911 0001498710 0000353184
9 remainder_Expenses -6.98 -5.74 0.695 1.16 1.21 0000353184 0001048911 0000092380
10 remainder_Revenues -2.48 -2.25 0.578 2.70 3.21 0001158463 0001498710 0000353184
11 remainder_NetIncome -1.26 -1.09 -0.463 2.08 2.52 0000353184 0001498710 0001158463
12 remainder_ComprehensiveNetIncome -0.0198 -0.0153 -0.00221 0.0348 0.0605 0001048911 0001498710 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.420 -0.384 0.140 0.635 0.691 0000006201 0000100517 0000353184
1 Assets -0.106 -0.0586 -0.00330 0.132 0.168 0000353184 0000027904 0001135185
2 Expenses -2.30 -1.73 0.0479 0.313 0.399 0000353184 0001498710 0001135185
3 Revenues -2.48 -2.25 0.578 2.70 3.21 0001158463 0001498710 0000353184
4 StockholdersEquity -0.815 -0.611 0.0350 0.388 0.578 0000353184 0000100517 0000350403
5 NetIncome -0.344 -0.291 0.0169 0.161 0.162 0000353184 0000816159 0001498710
6 ComprehensiveNetIncome -0.326 -0.285 0.0152 0.184 0.221 0000353184 0000816159 0000092380
7 BaseVar nan nan nan nan nan 0000006201 0000816159 0000006201
8 EconomicCapitalRatio -0.552 -0.504 0.110 0.334 0.365 0000006201 0000350403 0001498710

2017

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000092380 0000100517 0000350403 0001048911 0001158463 0001498710 0001514226 0000004515 0000073887 0000230211 0000816159 0000842722 0001159154 0001586300
warning 10 × The stock price does not exist industry.us_generic
0000100517 0001135185 0001172222 0000073887 0000701345 0000816159 0000899394 0000914397 0001159154 0001586300
warning 3 × Ignoring company because Assets is zero pre-agg
0001514226 0001586300 0001586300
warning 2 × No stock price available subcommand.plot
0000350403 0001135185
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000350403 0000842722
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 34,698,806 1,099,807,583 22,755,528,055 169,629,582,500 182,077,535,000 0001128281 0001158463 0001048911
8 EconomicCapitalRatio 0.139 0.246 0.968 1.18 1.19 0000006201 0001128281 0001498710

Effect quantiles (final effects with respect to final var and normalized if applicable)

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -0.113 -0.106 -0.0240 0.275 0.330 0001172222 0000006201 0001128281
1 LiabilitiesNonCurrent -0.420 -0.391 0.195 0.340 0.382 0001135185 0001158463 0001128281
2 remainder_Liabilities -0.0257 -0.0126 0.00115 0.00162 0.00188 0001128281 0000100517 0001048911
3 AssetsCurrent -0.0369 -0.0352 -0.000768 0.00912 0.0101 0000006201 0001048911 0000350403
4 AssetsNoncurrent -0.0139 -0.00817 0.00186 0.0416 0.0465 0001135185 0001498710 0000006201
5 PropertyPlantAndEquipmentNet -0.0664 -0.0537 -0.0100 0.0972 0.164 0000027904 0000092380 0001135185
6 remainder_Assets -0.0441 -0.0315 0.000292 0.0447 0.0828 0000006201 0001128281 0000027904
7 OperatingExpenses -0.910 -0.865 -0.505 2.59 3.89 0000100517 0001172222 0001128281
8 DepreciationDepletionAndAmortization -0.0828 -0.0809 -0.0289 0.176 0.264 0001048911 0000027904 0001128281
9 remainder_Expenses -5.69 -3.49 0.498 0.865 0.943 0001128281 0001172222 0000092380
10 remainder_Revenues -2.38 -2.13 0.549 1.89 2.32 0001158463 0001498710 0001128281
11 remainder_NetIncome -1.09 -0.962 -0.485 2.05 2.52 0001128281 0001498710 0001158463
12 remainder_ComprehensiveNetIncome -0.0149 -0.0134 -0.00206 0.0211 0.0250 0001048911 0001498710 0000092380
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.409 -0.406 0.139 0.526 0.591 0001135185 0001172222 0001128281
1 Assets -0.0766 -0.0555 -0.00818 0.0852 0.122 0000006201 0001158463 0001135185
2 Expenses -1.55 -1.18 0.0890 0.274 0.417 0001128281 0001158463 0001135185
3 Revenues -2.38 -2.13 0.549 1.89 2.32 0001158463 0001498710 0001128281
4 StockholdersEquity -0.446 -0.402 -0.0421 0.399 0.526 0001128281 0001172222 0000350403
5 NetIncome -0.318 -0.253 -0.0312 0.244 0.266 0001128281 0000027904 0000092380
6 ComprehensiveNetIncome -0.323 -0.263 -0.0326 0.254 0.291 0001128281 0000027904 0000092380
7 BaseVar nan nan nan nan nan 0000006201 0001048911 0000006201
8 EconomicCapitalRatio -0.675 -0.569 0.154 0.362 0.374 0000006201 0001128281 0001498710

2018

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 17 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000100517 0000350403 0001048911 0001158463 0001498710 0000092380 0001514226 0000899394 0000004515 0000073887 0000230211 0000816159 0000842722 0001159154 0001586300
warning 11 × The stock price does not exist industry.us_generic
0000100517 0001135185 0001172222 0000766421 0000899394 0000073887 0000701345 0000816159 0000914397 0001159154 0001586300
warning 4 × Ignoring company because Assets is zero pre-agg
0000766421 0001514226 0001586300 0001586300
warning 2 × No stock price available subcommand.plot
0000350403 0001135185
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000350403 0000842722
warning 2 × Ignoring company because Expenses is zero pre-agg
0000100517 0000350403
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 32,323,422 310,569,957 11,484,913,689 185,745,557,500 196,260,665,000 0001128281 0001498710 0001048911
8 EconomicCapitalRatio -0.0438 0.00648 0.699 1.01 1.07 0000350403 0001158463 0001048911

Effect quantiles (final effects with respect to final var and normalized if applicable)

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent -0.210 -0.143 -0.00619 0.338 0.435 0000350403 0001158463 0001128281
1 LiabilitiesNonCurrent -0.392 -0.388 0.189 0.365 0.404 0001135185 0001498710 0001128281
2 remainder_Liabilities -0.325 -0.158 0.0131 0.0339 0.0417 0000353184 0000027904 0001048911
3 AssetsCurrent -0.0405 -0.0401 -0.00138 0.0629 0.0743 0000027904 0001172222 0000353184
4 AssetsNoncurrent -0.121 -0.0959 -0.0117 0.284 0.498 0000353184 0001498710 0000027904
5 PropertyPlantAndEquipmentNet -0.317 -0.176 0.0114 0.198 0.206 0000353184 0001048911 0000350403
6 remainder_Assets -0.146 -0.0766 0.00559 0.0888 0.150 0000027904 0000350403 0000353184
7 OperatingExpenses -1.23 -1.17 -0.497 3.08 3.44 0000100517 0000006201 0001128281
8 DepreciationDepletionAndAmortization -0.0944 -0.0935 -0.0330 0.170 0.231 0001048911 0000027904 0001128281
9 remainder_Expenses -4.97 -4.32 0.679 1.08 1.21 0001128281 0000027904 0000100517
10 remainder_Revenues -0.458 -0.398 0.0179 0.970 1.22 0000350403 0001158463 0001128281
11 remainder_NetIncome -0.0925 -0.0805 0.0137 0.0776 0.0912 0001498710 0000353184 0001128281
12 remainder_ComprehensiveNetIncome -0.00549 -0.00498 -0.00172 0.00907 0.0162 0001048911 0000027904 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.401 -0.364 0.162 0.610 0.695 0000006201 0001172222 0001128281
1 Assets -0.299 -0.159 0.0136 0.157 0.175 0000353184 0001048911 0000350403
2 Expenses -1.30 -1.06 -0.0487 0.336 0.397 0001128281 0001158463 0001135185
3 Revenues -0.458 -0.398 0.0179 0.970 1.22 0000350403 0001158463 0001128281
4 StockholdersEquity -0.508 -0.391 0.0655 0.299 0.360 0000353184 0000350403 0001498710
5 NetIncome -0.473 -0.283 0.0430 0.185 0.232 0000350403 0001498710 0001048911
6 ComprehensiveNetIncome -0.477 -0.286 0.0439 0.181 0.226 0000350403 0001498710 0001048911
7 BaseVar nan nan nan nan nan 0000006201 0001048911 0000006201
8 EconomicCapitalRatio -0.592 -0.542 0.151 0.460 0.519 0000350403 0001158463 0001048911

2019

Logs

error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0000766421
error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 17 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000100517 0001048911 0001158463 0001498710 0000899394 0000092380 0000004515 0000073887 0000230211 0000816159 0001514226 0000350403 0000842722 0001159154 0001586300
warning 11 × The stock price does not exist industry.us_generic
0000100517 0000766421 0001135185 0001172222 0000899394 0000073887 0000701345 0000816159 0000914397 0001159154 0001586300
warning 4 × Ignoring company because Assets is zero pre-agg
0000766421 0001514226 0001586300 0001586300
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000353184 0000350403 0000842722
warning 3 × Ignoring company because Expenses is zero pre-agg
0000100517 0000766421 0000350403
warning 2 × No stock price available subcommand.plot
0001135185 0000899394
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000766421
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 33,839,536 447,055,179 20,671,771,741 197,346,277,000 213,276,565,000 0001128281 0001158463 0001048911
8 EconomicCapitalRatio -0.0487 -0.0135 0.771 0.981 1.01 0000899394 0000100517 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.0921 -0.0860 -0.0194 0.265 0.303 0001172222 0001135185 0001128281
1 LiabilitiesNonCurrent -0.327 -0.278 0.223 0.378 0.395 0000006201 0001172222 0001128281
2 remainder_Liabilities 0 0 0 0 0 0000006201 0001128281 0000006201
3 AssetsCurrent -0.0403 -0.0356 -0.00686 0.0178 0.0282 0000006201 0001128281 0000899394
4 AssetsNoncurrent -0.0934 -0.0873 -0.00283 0.209 0.371 0000899394 0001498710 0000027904
5 PropertyPlantAndEquipmentNet -0.0892 -0.0685 0.00438 0.134 0.210 0000899394 0001498710 0001135185
6 remainder_Assets -0.139 -0.0776 0.00212 0.0366 0.0562 0000027904 0000006201 0001135185
7 OperatingExpenses -1.72 -1.20 -0.204 2.38 3.77 0001048911 0001172222 0001128281
8 DepreciationDepletionAndAmortization -0.137 -0.0993 -0.0260 0.191 0.269 0000899394 0001498710 0001128281
9 remainder_Expenses -5.02 -3.04 0.351 0.887 1.17 0001128281 0000006201 0001048911
10 remainder_Revenues -0.413 -0.330 -0.00376 0.912 1.09 0001135185 0001172222 0001128281
11 remainder_NetIncome -0.254 -0.145 0.00929 0.0694 0.0785 0001048911 0001172222 0001128281
12 remainder_ComprehensiveNetIncome -0.00754 -0.00751 0.00216 0.00551 0.00602 0000006201 0001498710 0000100517
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.377 -0.347 0.173 0.553 0.597 0000006201 0000100517 0001128281
1 Assets -0.145 -0.110 0.00579 0.0773 0.121 0000899394 0000027904 0001135185
2 Expenses -0.979 -0.801 0.0458 0.245 0.256 0001128281 0001172222 0000027904
3 Revenues -0.413 -0.330 -0.00376 0.912 1.09 0001135185 0001172222 0001128281
4 StockholdersEquity -0.304 -0.280 -0.0226 0.323 0.386 0000006201 0001048911 0001498710
5 NetIncome -0.325 -0.288 0.109 0.163 0.185 0000899394 0000100517 0001128281
6 ComprehensiveNetIncome -0.322 -0.286 0.112 0.165 0.189 0000899394 0001172222 0001128281
7 BaseVar nan nan nan nan nan 0000006201 0001128281 0000006201
8 EconomicCapitalRatio -0.602 -0.567 0.217 0.428 0.460 0000899394 0000100517 0001128281

2020

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 17 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000006201 0000027904 0000100517 0001048911 0001498710 0000092380 0001158463 0000004515 0000073887 0000230211 0000816159 0000899394 0001514226 0000350403 0000842722 0001159154 0001586300
warning 11 × The stock price does not exist industry.us_generic
0000100517 0000766421 0001135185 0001172222 0000073887 0000701345 0000816159 0000899394 0000914397 0001159154 0001586300
warning 7 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000353184 0000353184 0000353184 0000353184 0001819516 0000350403 0000842722
warning 6 × Ignoring company because Expenses is zero pre-agg
0000100517 0000766421 0000766421 0000766421 0000766421 0000350403
warning 4 × Ignoring company because Assets is zero pre-agg
0000766421 0001514226 0001586300 0001586300
warning 1 × No stock price available subcommand.plot
0001135185
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 719,026,675 736,113,992 12,820,312,077 177,365,762,500 221,353,205,000 0000899394 0001135185 0001048911
8 EconomicCapitalRatio -0.462 -0.442 0.236 0.707 0.823 0000027904 0000810332 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.0808 -0.0623 -0.00740 0.200 0.299 0001172222 0000006201 0001048911
1 LiabilitiesNonCurrent -0.213 -0.198 0.137 0.411 0.487 0000006201 0001172222 0001048911
2 remainder_Liabilities -0.221 -0.109 0.00700 0.0178 0.0250 0000353184 0000100517 0001048911
3 AssetsCurrent -0.0692 -0.0660 -0.0186 0.0603 0.0697 0000006201 0000027904 0001172222
4 AssetsNoncurrent -0.161 -0.114 -0.00602 0.297 0.544 0000353184 0001048911 0000027904
5 PropertyPlantAndEquipmentNet -0.312 -0.215 0.0228 0.178 0.198 0000353184 0001135185 0001158463
6 remainder_Assets -0.230 -0.116 0.00234 0.0764 0.111 0000027904 0000810332 0000353184
7 OperatingExpenses -1.45 -0.946 -0.156 1.57 2.58 0001048911 0000006201 0000353184
8 DepreciationDepletionAndAmortization -0.104 -0.0767 -0.0297 0.179 0.209 0000899394 0001498710 0000353184
9 remainder_Expenses -3.85 -2.26 0.257 0.464 0.470 0000353184 0000006201 0000100517
10 remainder_Revenues -0.392 -0.363 -0.164 1.48 1.53 0000027904 0001498710 0000353184
11 remainder_NetIncome -0.117 -0.0916 0.000344 0.148 0.207 0000100517 0001172222 0000353184
12 remainder_ComprehensiveNetIncome -0.0194 -0.0162 0.00684 0.00853 0.00881 0000353184 0000810332 0001135185
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.222 -0.207 0.0814 0.477 0.665 0000006201 0001172222 0001048911
1 Assets -0.351 -0.210 -0.0227 0.230 0.233 0000353184 0000027904 0001172222
2 Expenses -1.07 -1.04 0.0517 0.235 0.282 0000353184 0001135185 0000810332
3 Revenues -0.392 -0.363 -0.164 1.48 1.53 0000027904 0001498710 0000353184
4 StockholdersEquity -0.696 -0.512 -0.126 0.384 0.420 0000353184 0000810332 0001498710
5 NetIncome -0.357 -0.336 -0.0577 0.622 0.672 0001172222 0001498710 0000353184
6 ComprehensiveNetIncome -0.356 -0.339 -0.0508 0.616 0.653 0001172222 0001498710 0000353184
7 BaseVar nan nan nan nan nan 0000006201 0000899394 0000006201
8 EconomicCapitalRatio -0.679 -0.659 0.0197 0.490 0.607 0000027904 0000810332 0001048911

2021

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
warning 18 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000027904 0000092380 0000100517 0001048911 0001158463 0001498710 0001846084 0000004515 0000006201 0000073887 0000230211 0000816159 0000899394 0001514226 0000350403 0000842722 0001159154 0001586300
warning 11 × The stock price does not exist industry.us_generic
0000100517 0000766421 0001135185 0001172222 0000073887 0000701345 0000816159 0000899394 0000914397 0001159154 0001586300
warning 7 × Ignoring company because Expenses is zero pre-agg
0000100517 0000766421 0000766421 0000766421 0000766421 0000766421 0000350403
warning 6 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000353184 0000353184 0000353184 0001819516 0000350403 0000842722
warning 4 × Ignoring company because Assets is zero pre-agg
0000766421 0001514226 0001586300 0001586300
warning 1 × No stock price available subcommand.plot
0001135185
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 17,211,398 291,033,703 8,378,692,992 178,807,067,500 263,198,980,000 0001128281 0001670076 0001048911
8 EconomicCapitalRatio -0.0769 -0.0192 0.476 1.21 1.22 0000353184 0001498710 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.481 -0.156 0.0507 0.405 0.442 0001819516 0001743907 0001128281
1 LiabilitiesNonCurrent -0.348 -0.324 0.112 0.342 0.385 0000027904 0000353184 0001048911
2 remainder_Liabilities -0.347 -0.175 0.0348 0.0886 0.0988 0000353184 0001172222 0001048911
3 AssetsCurrent -0.125 -0.118 -0.0379 0.390 1.07 0001670076 0000100517 0001779128
4 AssetsNoncurrent -0.151 -0.0862 -0.00723 0.309 0.398 0000353184 0001819516 0000027904
5 PropertyPlantAndEquipmentNet -0.318 -0.210 0.0145 0.176 0.286 0000353184 0000092380 0000810332
6 remainder_Assets -0.183 -0.0783 -0.00549 0.0955 0.150 0000027904 0001128281 0001819516
7 OperatingExpenses -1.85 -1.04 -0.291 1.87 2.02 0001048911 0000027904 0001128281
8 DepreciationDepletionAndAmortization -0.131 -0.109 -0.0176 0.129 0.189 0000899394 0001048911 0001128281
9 remainder_Expenses -3.16 -3.01 0.350 0.647 0.700 0001128281 0000027904 0000899394
10 remainder_Revenues -0.594 -0.509 0.0364 1.18 1.30 0001819516 0001743907 0001048911
11 remainder_NetIncome -0.217 -0.193 0.0185 0.217 0.331 0001779128 0001819516 0001128281
12 remainder_ComprehensiveNetIncome -0.0123 -0.00839 -0.00522 0.0246 0.0301 0001128281 0000810332 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.437 -0.340 0.110 0.698 0.701 0001819516 0001779128 0001128281
1 Assets -0.459 -0.203 0.0124 0.389 0.389 0000353184 0000810332 0001779128
2 Expenses -1.23 -1.08 -0.0678 0.294 0.564 0001048911 0001172222 0001819516
3 Revenues -0.594 -0.509 0.0364 1.18 1.30 0001819516 0001743907 0001048911
4 StockholdersEquity -0.636 -0.388 -0.0996 0.332 0.435 0000353184 0000899394 0001779128
5 NetIncome -0.544 -0.341 -0.00733 0.594 0.810 0001779128 0000027904 0000899394
6 ComprehensiveNetIncome -0.551 -0.348 0.00195 0.583 0.803 0001779128 0000810332 0000899394
7 BaseVar nan nan nan nan nan 0000027904 0001135185 0000027904
8 EconomicCapitalRatio -0.563 -0.505 -0.00934 0.728 0.739 0000353184 0001498710 0001128281

2022

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
0000842722
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001172222
warning 18 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
0000027904 0000092380 0001048911 0001498710 0001846084 0000004515 0000006201 0000073887 0000100517 0001158463 0000230211 0000816159 0000899394 0001514226 0000350403 0000842722 0001159154 0001586300
warning 11 × The stock price does not exist industry.us_generic
0000766421 0001135185 0001172222 0000073887 0000100517 0000701345 0000816159 0000899394 0000914397 0001159154 0001586300
warning 8 × Ignoring company because Expenses is zero pre-agg
0000766421 0000766421 0000766421 0000766421 0000766421 0000766421 0000100517 0000350403
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001819516 0000350403 0000842722 0000353184 0000353184
warning 4 × Ignoring company because Assets is zero pre-agg
0000766421 0001514226 0001586300 0001586300
warning 2 × No stock price available subcommand.plot
0001135185 0001846084
warning 1 × Missing logo subcommand.report
0001846084
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001172222
warning 1 × Ignoring company because ECR is too negative pre-agg
0000899394

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 24,352,241 222,305,582 11,420,683,889 232,061,784,500 289,691,545,000 0001128281 0001670076 0001048911
8 EconomicCapitalRatio -0.820 -0.770 0.405 1.12 1.53 0001846084 0001498710 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.0828 -0.0694 -0.00446 0.265 0.332 0000092380 0001846084 0001128281
1 LiabilitiesNonCurrent -0.272 -0.254 0.0594 0.337 0.411 0000027904 0001779128 0001128281
2 remainder_Liabilities -0.0298 -0.0236 0.0125 0.0320 0.0392 0001670076 0001172222 0001128281
3 AssetsCurrent -0.425 -0.417 -0.0435 0.139 0.314 0001846084 0001743907 0001779128
4 AssetsNoncurrent -0.139 -0.0909 -0.0216 0.312 0.415 0001819516 0000899394 0000027904
5 PropertyPlantAndEquipmentNet -0.504 -0.316 0.0494 0.208 0.219 0001846084 0000092380 0001158463
6 remainder_Assets -0.188 -0.0729 0.00633 0.167 0.205 0000027904 0001498710 0001819516
7 OperatingExpenses -1.93 -1.34 -0.386 2.36 2.51 0001048911 0000027904 0001128281
8 DepreciationDepletionAndAmortization -0.163 -0.104 -0.0142 0.150 0.169 0000899394 0000027904 0001128281
9 remainder_Expenses -3.20 -3.02 0.722 1.23 1.59 0001846084 0001670076 0001048911
10 remainder_Revenues -0.520 -0.402 -0.00666 0.683 0.770 0001779128 0001135185 0001048911
11 remainder_NetIncome -0.228 -0.138 -0.0443 0.408 0.518 0001846084 0000092380 0001128281
12 remainder_ComprehensiveNetIncome -0.0133 -0.0108 -0.00255 0.0210 0.0233 0001048911 0001158463 0000027904
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.344 -0.307 0.0896 0.546 0.671 0000027904 0000092380 0001128281
1 Assets -0.710 -0.395 0.0329 0.142 0.159 0001846084 0001158463 0001779128
2 Expenses -0.789 -0.539 -0.0535 0.322 0.325 0001846084 0001172222 0000027904
3 Revenues -0.520 -0.402 -0.00666 0.683 0.770 0001779128 0001135185 0001048911
4 StockholdersEquity -0.675 -0.435 0.104 0.349 0.366 0001846084 0001128281 0001779128
5 NetIncome -0.742 -0.682 0.0578 0.616 0.915 0001819516 0001743907 0001128281
6 ComprehensiveNetIncome -0.752 -0.687 0.0562 0.613 0.911 0001819516 0001743907 0001128281
7 BaseVar nan nan nan nan nan 0000027904 0001172222 0000027904
8 EconomicCapitalRatio -1.16 -1.11 0.0634 0.781 1.19 0001846084 0001498710 0001128281

2023

Logs

error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001172222
warning 2 × The stock price does not exist industry.us_generic
0000766421 0001172222
warning 1 × Ignoring company because Expenses is zero pre-agg
0000766421

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 LiabilitiesCurrent 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 27,474,624 363,875,260 14,218,529,199 165,671,353,000 213,866,525,000 0001128281 0001670076 0000027904
8 EconomicCapitalRatio -0.966 -0.640 0.327 1.19 1.63 0001819516 0001743907 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.0740 -0.0576 0.00350 0.123 0.127 0000092380 0001158463 0001128281
1 LiabilitiesNonCurrent -0.256 -0.255 0.0741 0.249 0.307 0001743907 0001779128 0001128281
2 remainder_Liabilities -0.0158 -0.0107 0.0156 0.0356 0.0440 0001670076 0000027904 0001128281
3 AssetsCurrent -0.750 -0.518 -0.0589 0.253 0.410 0001128281 0001158463 0001779128
4 AssetsNoncurrent -0.210 -0.189 -0.0481 0.309 0.348 0001819516 0001158463 0000027904
5 PropertyPlantAndEquipmentNet -0.271 -0.254 0.0461 0.185 0.218 0001779128 0001498710 0001158463
6 remainder_Assets -0.167 -0.103 0.0246 0.205 0.232 0000027904 0001128281 0001819516
7 OperatingExpenses -1.07 -1.06 -0.422 1.86 1.96 0000092380 0000027904 0001779128
8 DepreciationDepletionAndAmortization -0.0848 -0.0805 -0.00437 0.132 0.139 0001743907 0001819516 0001779128
9 remainder_Expenses -2.83 -2.56 0.653 1.08 1.12 0001779128 0000027904 0000092380
10 remainder_Revenues -0.303 -0.239 -0.0391 0.382 0.568 0001819516 0001498710 0001128281
11 remainder_NetIncome -0.103 -0.0914 -0.00830 0.152 0.162 0001819516 0000027904 0001128281
12 remainder_ComprehensiveNetIncome -0.0173 -0.0104 0.00110 0.00883 0.0137 0000092380 0001158463 0001779128
  yvar min 5% median 95% max min_company median_company max_company
0 Liabilities -0.278 -0.277 0.123 0.349 0.438 0000027904 0000092380 0001128281
1 Assets -0.380 -0.261 -0.0204 0.0792 0.109 0001819516 0001128281 0001498710
2 Expenses -0.735 -0.654 -0.00419 0.330 0.330 0001779128 0000092380 0001128281
3 Revenues -0.303 -0.239 -0.0391 0.382 0.568 0001819516 0001498710 0001128281
4 StockholdersEquity -0.358 -0.310 0.125 0.300 0.345 0001819516 0000092380 0001498710
5 NetIncome -0.937 -0.859 0.0438 0.728 1.06 0001819516 0001670076 0001128281
6 ComprehensiveNetIncome -0.936 -0.853 0.0444 0.729 1.06 0001819516 0001670076 0001128281
7 BaseVar nan nan nan nan nan 0000027904 0001498710 0000027904
8 EconomicCapitalRatio -1.26 -0.936 0.0317 0.897 1.34 0001819516 0001743907 0001128281

Estimates

Parameter Value Min Max
PresentValueFactor 2.61 1.0 15.0
BalanceFactor 0.5 0.5 5.0
OCIFactor 0.5 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 0.4 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 10.1000 1.0000 10.1000 nan nan nan
2011 5.6600 1.0000 5.6600 335,227,024.0 1,897,384,955.84 0.1168
2012 13.2800 1.0000 13.2800 335,271,557.0 4,452,406,276.96 0.2714
2013 26.1200 1.0000 26.1200 335,598,131.0 8,765,823,181.72 0.2009
2014 51.1400 1.0000 51.1400 717,263,563.0 36,680,858,611.82 0.8577
2015 42.8500 1.0000 42.8500 630,325,539.0 27,009,449,346.15 0.5923
2016 48.5300 1.0000 48.5300 518,125,156.0 25,144,613,820.68 0.5092
2017 52.2200 1.0000 52.2200 478,499,073.0 24,987,221,592.06 0.5054
2018 32.0400 1.0000 32.0400 460,581,463.0 14,757,030,074.52 0.2433
2019 28.6100 1.0000 28.6100 438,057,971.0 12,532,838,550.31 0.2087
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 12.4800 1.0000 12.4800 nan nan nan
2011 8.3400 1.0000 8.3400 847,144,480.0 7,065,184,963.20 0.1600
2013 27.4900 1.0000 27.4900 855,545,884.0 23,518,956,351.16 0.5065
2014 47.7300 1.0000 47.7300 836,941,362.0 39,947,211,208.26 0.8035
2015 51.6000 1.0000 51.6000 786,473,621.0 40,582,038,843.60 0.8506
2016 50.0200 1.0000 50.0200 736,384,650.0 36,833,960,193.00 0.8165
2017 56.0800 1.0000 56.0800 712,973,139.0 39,983,533,635.12 0.8630
2018 50.4500 1.0000 50.4500 685,618,701.0 34,589,463,465.45 0.6475
2019 59.0300 1.0000 59.0300 646,742,854.0 38,177,230,671.62 0.6715
2020 40.1800 1.0000 40.1800 637,734,301.0 25,624,164,214.18 0.3597
2021 39.0600 1.0000 39.0600 640,013,818.0 24,998,939,731.08 0.3545
2022 32.9100 1.0000 32.9100 641,188,362.0 21,101,508,993.42 0.3058
2023 40.9400 1.0000 40.9400 643,463,433.0 26,343,392,947.02 0.3869
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 12.9800 1.0000 12.9800 nan nan nan
2011 8.4900 1.0000 8.4900 772,906,217.0 6,561,973,782.33 0.5810
2012 10.3900 1.0000 10.3900 728,096,579.0 7,564,923,455.81 0.6512
2013 18.8400 1.0000 18.8400 696,720,541.0 13,126,214,992.44 1.0489
2014 41.4600 1.0000 41.4600 678,744,363.0 28,140,741,289.98 2.1545
2015 43.4700 1.0000 43.4700 650,355,108.0 28,270,936,544.76 1.9691
2016 50.3000 1.0000 50.3000 615,597,738.0 30,964,566,221.40 2.0554
2017 65.9400 1.0000 65.9400 593,387,660.0 39,127,982,300.40 2.4444
2021 41.8100 1.0000 41.8100 591,919,907.0 24,748,171,311.67 1.0883
2022 35.7700 1.0000 35.7700 593,752,004.0 21,238,509,183.08 0.9287
2023 29.1800 1.0000 29.1800 595,633,723.0 17,380,592,037.14 0.7132
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 1.0000 nan 2,852,616.0 nan nan
2012 nan 1.0000 nan nan nan nan
2013 nan 1.0000 nan nan nan nan
2015 nan 1.0000 nan nan nan nan
2016 nan 1.0000 nan nan nan nan
2017 nan 1.0000 nan nan nan nan
2018 nan 1.0000 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 Mesa AIR Group INC Mesa AI MESA 2020 6.4000 1.0000 6.4000 35,526,918.0 227,372,275.20 0.1786
2021 5.6300 1.0000 5.6300 35,958,759.0 202,447,813.17 0.1670
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 DROP 2012 380.0000 1.0000 380.0000 126,202,256.0 47,956,857,280.00 48338.0024
2013 46.0000 1.0000 46.0000 273,763,024.0 12,593,099,104.00 6805.2211
0000899394 Harbor Diversified INC Harbor HRBR 2019 0.0300 1.0000 0.0300 nan nan nan
2020 0.3000 1.0000 0.3000 54,863,305.0 16,458,991.50 0.0576
2021 2.1000 1.0000 2.1000 54,139,833.0 113,693,649.30 0.3920
2022 2.1500 1.0000 2.1500 45,652,266.0 98,152,371.90 0.3769
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 93.0200 1.0000 93.0200 nan nan nan
2011 84.2700 1.0000 84.2700 314,484,094.0 26,501,574,601.38 1.6427
2012 92.1000 1.0000 92.1000 314,461,506.0 28,961,904,702.60 1.6421
2013 142.4500 1.0000 142.4500 312,228,182.0 44,476,904,525.90 2.2625
2014 175.2600 1.0000 175.2600 283,312,620.0 49,653,369,781.20 2.5873
2015 149.0800 1.0000 149.0800 275,615,246.0 41,088,720,873.68 1.9342
2016 191.3800 1.0000 191.3800 266,509,290.0 51,004,547,920.20 1.8902
2017 249.5900 1.0000 249.5900 267,889,623.0 66,862,571,004.57 2.3681
2018 160.5800 1.0000 160.5800 261,043,625.0 41,918,385,302.50 1.3532
2019 151.0000 1.0000 151.0000 261,119,074.0 39,428,980,174.00 1.2435
2020 269.7600 1.0000 269.7600 265,070,592.0 71,505,442,897.92 1.7050
2021 255.0400 1.0000 255.0400 264,969,342.0 67,577,780,983.68 1.4015
2022 173.1200 1.0000 173.1200 252,397,140.0 43,694,992,876.80 0.8716
0001128281 Saker Aviation Services Inc Saker A SKAS 2012 2.4000 0.0330 0.0800 33,040,422.0 2,643,233.76 0.4339
2014 2.4800 0.0330 0.0800 33,107,610.0 2,648,608.80 0.5291
2015 1.8000 0.0330 0.0600 33,107,610.0 1,986,456.60 0.4591
2016 3.5900 0.0330 0.1200 33,157,610.0 3,978,913.20 0.8622
2017 3.4500 0.0330 0.1100 33,422,995.0 3,676,529.45 0.9608
2018 2.4900 0.0330 0.0800 30,195,034.0 2,415,602.72 0.6764
2019 6.2500 1.0000 6.2500 1,013,033.0 6,331,456.25 1.4167
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
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
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 HA 2011 6.0100 1.0000 6.0100 50,712,907.0 304,784,571.07 0.3084
2012 6.5800 1.0000 6.5800 51,388,041.0 338,133,309.78 0.2684
2014 24.3500 1.0000 24.3500 54,023,742.0 1,315,478,117.70 0.7686
2015 37.2400 1.0000 37.2400 53,214,218.0 1,981,697,478.32 1.2085
2016 58.7700 1.0000 58.7700 53,426,475.0 3,139,873,935.75 1.7747
2017 40.6800 1.0000 40.6800 52,471,736.0 2,134,550,220.48 1.1378
2018 26.3500 1.0000 26.3500 49,403,496.0 1,301,782,119.60 0.6196
2019 30.3900 1.0000 30.3900 46,591,737.0 1,415,922,887.43 0.5443
2020 18.0400 1.0000 18.0400 46,003,751.0 829,907,668.04 0.3331
2021 18.8600 1.0000 18.8600 51,212,761.0 965,872,672.46 0.3365
2022 10.2000 1.0000 10.2000 51,411,336.0 524,395,627.20 0.1995
0001498710 Spirit Airlines Inc Spirit SAVE 2011 15.4800 1.0000 15.4800 72,530,256.0 1,122,768,362.88 2.3081
2012 17.2500 1.0000 17.2500 nan nan nan
2013 45.2800 1.0000 45.2800 72,647,167.0 3,289,463,721.76 4.3375
2014 75.6300 1.0000 75.6300 72,766,894.0 5,503,360,193.22 5.5911
2015 41.6700 1.0000 41.6700 71,539,630.0 2,981,056,382.10 1.9895
2016 58.1800 1.0000 58.1800 69,322,496.0 4,033,182,817.28 2.1898
2017 44.9300 1.0000 44.9300 69,373,154.0 3,116,935,809.22 1.3012
2018 57.6400 1.0000 57.6400 68,264,513.0 3,934,766,529.32 1.3116
2019 40.9900 1.0000 40.9900 68,448,433.0 2,805,701,268.67 0.6881
2020 24.7800 1.0000 24.7800 97,678,265.0 2,420,467,406.70 0.4969
2021 22.3000 1.0000 22.3000 108,405,182.0 2,417,435,558.60 0.4925
2022 19.5500 1.0000 19.5500 108,857,162.0 2,128,157,517.10 0.3949
2023 16.3900 1.0000 16.3900 109,167,560.0 1,789,256,308.40 0.3228
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 62.1700 0.5000 31.0800 20,189,222.0 627,481,019.76 0.8475
2014 42.4900 0.5000 21.2400 20,371,872.0 432,698,561.28 0.5499
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
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
0001779128 Blade Air Mobility Inc Blade A BLDE 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
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
0001846084 Global Crossing Airlines Group Inc Global JETMF 2022 nan nan nan nan nan nan