Ranks across the years
| name | name_short | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2010-val | 2011-val | 2012-val | 2013-val | 2014-val | 2015-val | 2016-val | 2017-val | 2018-val | 2019-val | 2020-val | 2021-val | 2022-val | 2023-val | 2024-val | 2010->2011 | 2011->2012 | 2012->2013 | 2013->2014 | 2014->2015 | 2015->2016 | 2016->2017 | 2017->2018 | 2018->2019 | 2019->2020 | 2020->2021 | 2021->2022 | 2022->2023 | 2023->2024 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0001128281 | Saker Aviation Services Inc | Saker A | NaN | NaN | 9 | NaN | 10 | 10 | 5 | 5 | 2 | 2 | NaN | 1 | 1 | 1 | 1 | NaN | NaN | 78.43 | NaN | 66.66 | 88.38 | 97.49 | 104.07 | 109.01 | 103.30 | NaN | 112.63 | 127.13 | 124.72 | 127.42 | NaN | NaN | NaN | NaN | 0 | -5 | 0 | -3 | 0 | NaN | NaN | 0 | 0 | 0 |
| 0001779128 | Blade Air Mobility Inc | Blade A | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 7 | 3 | 5 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 88.15 | 92.35 | 74.24 | 91.04 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -4 | 2 | -3 |
| 0001158463 | Jetblue Airways CORP | Jetblue | 2 | 5 | 6 | 6 | 5 | 7 | 4 | 4 | 4 | 4 | 3 | 6 | 7 | 3 | 3 | 103.10 | 97.75 | 94.88 | 92.03 | 95.76 | 97.82 | 101.52 | 104.51 | 94.23 | 98.95 | 84.41 | 88.43 | 82.89 | 86.16 | 86.94 | 3 | 1 | 0 | -1 | 2 | -3 | 0 | 0 | 0 | -1 | 3 | 1 | -4 | 0 |
| 0001498710 | Spirit Aviation Holdings Inc | Spirit | NaN | 7 | 5 | 4 | 3 | 2 | 2 | 2 | 3 | 1 | 2 | 3 | 4 | 2 | 4 | NaN | 95.01 | 97.17 | 103.06 | 110.10 | 115.17 | 111.96 | 116.65 | 105.65 | 108.64 | 95.26 | 96.14 | 92.25 | 93.35 | 83.04 | NaN | -2 | -1 | -1 | -1 | 0 | 0 | 1 | -2 | 1 | 1 | 1 | -2 | 2 |
| 0000092380 | Southwest Airlines CO | Southwe | 3 | 8 | 7 | 7 | 7 | 9 | 6 | 6 | NaN | NaN | NaN | 4 | 6 | 4 | 5 | 101.94 | 90.98 | 92.86 | 89.63 | 89.23 | 89.31 | 97.38 | 103.86 | NaN | NaN | NaN | 93.56 | 86.70 | 81.66 | 79.53 | 5 | -1 | 0 | 0 | 2 | -3 | 0 | NaN | NaN | NaN | NaN | 2 | -2 | 1 |
| 0001525221 | Bristow Group Inc | Bristow | NaN | NaN | NaN | 10 | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 6 | NaN | NaN | NaN | 65.02 | 64.61 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 63.77 | NaN | NaN | NaN | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001743907 | Sun Country Airlines Holdings Inc | Sun Cou | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11 | 10 | 6 | 7 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 60.82 | 54.68 | 57.21 | 58.47 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | -4 | 1 |
| 0000894081 | Air Transport Services Group Inc | Air Tra | NaN | 16 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8 | NaN | 52.16 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 58.45 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000027904 | Delta AIR Lines INC | Delta A | 9 | 19 | NaN | 8 | 16 | 15 | 12 | 10 | 9 | 7 | 10 | 15 | 11 | 7 | 9 | 34.31 | 31.59 | NaN | 66.33 | 41.68 | 53.06 | 55.12 | 55.32 | 52.77 | 54.21 | 30.22 | 36.78 | 40.26 | 47.45 | 49.98 | 10 | NaN | NaN | 8 | -1 | -3 | -2 | -1 | -2 | 3 | 5 | -4 | -4 | 2 |
| 0001670076 | Frontier Group Holdings Inc | Frontie | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 14 | 12 | 8 | 10 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 37.53 | 38.32 | 38.08 | 39.43 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | -4 | 2 |
| 0001819516 | Wheels Up Experience Inc | Wheels | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 12 | 13 | 9 | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 57.12 | 29.23 | 26.45 | 25.32 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | -4 | 2 |
| 0000004515 | American Airlines INC | America | 8 | 13 | 13 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 64.84 | 61.12 | 60.12 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000006201 | American Airlines Group Inc | America | 7 | 12 | 10 | 15 | 17 | 14 | 13 | 11 | 11 | 10 | 11 | NaN | NaN | NaN | NaN | 77.68 | 67.88 | 69.78 | 31.34 | 38.22 | 53.24 | 41.14 | 40.16 | 33.62 | 33.89 | 29.45 | NaN | NaN | NaN | NaN | 5 | -2 | 5 | 2 | -3 | -1 | -2 | 0 | -1 | 1 | NaN | NaN | NaN | NaN |
| 0000073887 | Bristow Group Inc | Bristow | 1 | 1 | 1 | 2 | 1 | 3 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 125.21 | 125.78 | 119.55 | 120.95 | 114.56 | 107.02 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 0 | 1 | -1 | 2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000100517 | United Airlines Holdings Inc | United | 6 | 14 | NaN | 11 | 9 | 6 | 9 | 8 | 5 | 6 | 4 | 9 | NaN | NaN | NaN | 83.14 | 56.49 | NaN | 60.96 | 81.73 | 104.39 | 89.77 | 89.60 | 90.47 | 92.48 | 80.50 | 84.91 | NaN | NaN | NaN | 8 | NaN | NaN | -2 | -3 | 3 | -1 | -3 | 1 | -2 | 5 | NaN | NaN | NaN |
| 0000948846 | Airtran Holdings INC | Airtran | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 88.14 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001048911 | Fedex CORP | Fedex C | 4 | 3 | 3 | 3 | 2 | 5 | 3 | 3 | 1 | 3 | 1 | 2 | 2 | NaN | NaN | 101.36 | 105.88 | 102.57 | 108.66 | 111.15 | 104.60 | 104.47 | 109.41 | 109.71 | 101.95 | 106.90 | 110.00 | 106.61 | NaN | NaN | -1 | 0 | 0 | -1 | 3 | -2 | 0 | -2 | 2 | -2 | 1 | 0 | NaN | NaN |
| 0000230211 | Federal Express CORP | Federal | NaN | 4 | 4 | 5 | 4 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 101.88 | 100.45 | 94.96 | 97.50 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | 1 | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000350403 | PHI Group Inc DE | PHI Gro | NaN | 2 | 2 | 1 | NaN | 1 | 1 | 1 | 8 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 122.25 | 109.56 | 123.65 | NaN | 123.56 | 120.22 | 120.70 | 58.28 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 | -1 | NaN | NaN | 0 | 0 | 7 | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000701345 | US Airways Group INC | US Airw | NaN | 18 | 16 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 33.61 | 43.52 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000816159 | AIR Methods CORP | AIR Met | NaN | 15 | 14 | 13 | 12 | 12 | 10 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 54.69 | 57.16 | 56.47 | 61.85 | 63.43 | 58.30 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | -1 | -1 | 0 | -2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000914397 | Great Lakes Aviation LTD | Great L | NaN | 10 | 11 | 9 | 14 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 72.54 | 66.96 | 65.92 | 54.83 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | -2 | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001135185 | Atlas AIR Worldwide Holdings INC | Atlas A | NaN | 11 | 12 | 12 | 13 | 13 | 11 | 9 | 7 | 8 | 7 | 10 | 9 | NaN | NaN | NaN | 68.58 | 63.50 | 58.28 | 57.56 | 55.70 | 57.00 | 60.40 | 61.62 | 49.18 | 62.66 | 68.58 | 68.20 | NaN | NaN | NaN | 1 | 0 | 1 | 0 | -2 | -2 | -2 | 1 | -1 | 3 | -1 | NaN | NaN |
| 0001166291 | Pinnacle Airlines CORP | Pinnacl | NaN | 6 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 96.50 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001172222 | Hawaiian Holdings INC | Hawaiia | NaN | 9 | 8 | NaN | 8 | 8 | 7 | 7 | 6 | 5 | 5 | 8 | 8 | NaN | NaN | NaN | 81.39 | 81.97 | NaN | 84.06 | 91.98 | 92.96 | 97.45 | 89.24 | 94.74 | 75.73 | 88.04 | 81.27 | NaN | NaN | NaN | -1 | NaN | NaN | 0 | -1 | 0 | -1 | -1 | 0 | 3 | 0 | NaN | NaN |
| 0001514226 | Delta Tucker Holdings Inc | Delta T | NaN | 17 | 15 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 44.09 | 46.53 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -2 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000842722 | Fuse Science Inc | Fuse Sc | NaN | NaN | 18 | 17 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.00 | 0.00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001539429 | CHC Helicopter S A | CHC Hel | NaN | NaN | 17 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 43.06 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 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 | 10 | NaN | 9 | 16 | NaN | NaN | NaN | NaN | NaN | NaN | 0.00 | 95.43 | 104.75 | 90.15 | NaN | 52.10 | NaN | 51.01 | 36.05 | NaN | NaN | NaN | NaN | NaN | NaN | -10 | -2 | 4 | NaN | NaN | NaN | NaN | 7 | NaN | NaN | NaN |
| 0001159154 | Republic Airways Holdings INC | Republi | NaN | NaN | NaN | 14 | 15 | 16 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 43.65 | 45.22 | 41.95 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1 | 1 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000869187 | Baltia AIR Lines INC | Baltia | NaN | NaN | NaN | NaN | 18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0.00 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0001614436 | Virgin America Inc | Virgin | NaN | NaN | NaN | NaN | NaN | 11 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 87.43 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 0000899394 | Harbor Diversified INC | Harbor | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 9 | 6 | 5 | 5 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 44.04 | 66.83 | 92.08 | 88.59 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | -3 | -1 | 0 | NaN | NaN |
| 0000810332 | MESA AIR Group INC | MESA AI | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 8 | 13 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 54.01 | 55.53 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN |
PDF reports
All reports for 2024 are collected in a single PDF for easier review.2010
Logs
| warning | 12 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 9 × The stock price does not exist | industry.us_generic | |
| warning | 3 × Missing logo | subcommand.report | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 166,115,000 | 346,624,200 | 4,648,308,000 | 12,141,000,000 | 12,645,000,000 | 0000073887 | 0001048911 | 0000100517 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 18,543,600,000 | 30,906,000,000 | 0000004515 | 0000100517 | 0000027904 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 0 | 0 | 0000004515 | 0000092380 | 0000004515 |
| 3 | AssetsCurrent | 516,371,000 | 581,943,000 | 6,744,075,200 | 10,149,800,000 | 12,045,000,000 | 0000073887 | 0000004515 | 0000100517 |
| 4 | AssetsNoncurrent | 22,286,000 | 50,010,000 | 715,252,800 | 2,211,600,000 | 2,236,000,000 | 0000073887 | 0000100517 | 0000006201 |
| 5 | PropertyPlantAndEquipmentNet | 1,294,020,000 | 1,464,150,000 | 12,341,636,000 | 18,962,200,000 | 20,307,000,000 | 0000948846 | 0000004515 | 0000027904 |
| 6 | remainder_Assets | 0 | 45,372,400 | 1,163,010,400 | 12,683,000,000 | 14,543,000,000 | 0000092380 | 0000004515 | 0000027904 |
| 7 | OperatingExpenses | 0 | 904,718,000 | 16,781,019,200 | 25,032,400,000 | 26,032,000,000 | 0000073887 | 0000004515 | 0001048911 |
| 8 | DepreciationDepletionAndAmortization | 0 | 23,983,200 | 935,115,200 | 1,779,200,000 | 1,958,000,000 | 0000073887 | 0000004515 | 0001048911 |
| 9 | remainder_Expenses | 190,529,000 | 211,517,400 | 1,583,135,200 | 5,170,000,000 | 5,456,000,000 | 0000948846 | 0000100517 | 0001048911 |
| 10 | remainder_Revenues | 0 | 0 | 1,171,950,704 | 30,132,000,000 | 34,734,000,000 | 0000004515 | 0000073887 | 0001048911 |
| 11 | remainder_NetIncome | -723,000,000 | -475,400,000 | 34,389,377 | 26,685,600,000 | 30,146,000,000 | 0000100517 | 0000073887 | 0000027904 |
| 12 | remainder_ComprehensiveNetIncome | -1,067,000,000 | -640,200,000 | 0 | 0 | 0 | 0001048911 | 0000073887 | 0000004515 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | 166,115,000 | 346,624,200 | 4,648,308,000 | 30,432,600,000 | 42,291,000,000 | 0000073887 | 0001048911 | 0000027904 |
| 1 | Assets | 2,179,348,000 | 2,305,456,800 | 22,423,984,000 | 41,752,000,000 | 43,188,000,000 | 0000948846 | 0000004515 | 0000027904 |
| 2 | Expenses | 1,088,826,000 | 1,658,208,400 | 21,827,109,600 | 31,888,800,000 | 33,446,000,000 | 0000073887 | 0000006201 | 0001048911 |
| 3 | Revenues | 0 | 0 | 1,171,950,704 | 30,132,000,000 | 34,734,000,000 | 0000004515 | 0000073887 | 0001048911 |
| 4 | StockholdersEquity | 897,000,000 | 1,162,984,000 | 11,208,760,000 | 24,274,600,000 | 26,953,000,000 | 0000027904 | 0000004515 | 0000100517 |
| 5 | NetIncome | -471,000,000 | -470,200,000 | 113,606,604 | 1,088,400,000 | 1,184,000,000 | 0000006201 | 0000073887 | 0001048911 |
| 6 | ComprehensiveNetIncome | -471,000,000 | -470,200,000 | 113,606,604 | 827,200,000 | 945,000,000 | 0000006201 | 0000073887 | 0000092380 |
| 7 | BaseVar | 2,475,941,000 | 3,084,872,000 | 38,525,517,600 | 63,333,000,000 | 72,589,000,000 | 0000073887 | 0000006201 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.0275 | 0.179 | 0.754 | 1.12 | 1.22 | 0000027904 | 0000948846 | 0000073887 |
| 9 | EconomicCapitalRatio | 0.343 | 0.465 | 0.881 | 1.16 | 1.25 | 0000027904 | 0000948846 | 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.179 | -0.155 | 0.0318 | 0.188 | 0.189 | 0000004515 | 0000092380 | 0000073887 |
| 1 | LiabilitiesNonCurrent | -0.472 | -0.261 | 0.0743 | 0.109 | 0.120 | 0000027904 | 0001158463 | 0001048911 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 0 | 0 | 0000004515 | 0000092380 | 0000004515 |
| 3 | AssetsCurrent | -0.0739 | -0.0499 | -0.000671 | 0.0193 | 0.0274 | 0000027904 | 0000006201 | 0000100517 |
| 4 | AssetsNoncurrent | -0.0171 | -0.0128 | -0.00136 | 0.0171 | 0.0187 | 0000027904 | 0000073887 | 0000004515 |
| 5 | PropertyPlantAndEquipmentNet | -0.121 | -0.0971 | -0.0273 | 0.0500 | 0.0654 | 0000027904 | 0000100517 | 0001158463 |
| 6 | remainder_Assets | -0.0284 | -0.0262 | -0.0128 | 0.0479 | 0.0565 | 0000004515 | 0001048911 | 0000100517 |
| 7 | OperatingExpenses | -0.418 | -0.417 | -0.0440 | 0.385 | 0.533 | 0000948846 | 0001158463 | 0000073887 |
| 8 | DepreciationDepletionAndAmortization | -0.0426 | -0.0300 | -0.00158 | 0.0293 | 0.0380 | 0001048911 | 0000004515 | 0000073887 |
| 9 | remainder_Expenses | -0.565 | -0.414 | 0.0299 | 0.136 | 0.142 | 0000073887 | 0000027904 | 0000948846 |
| 10 | remainder_Revenues | -0.569 | -0.562 | 0.190 | 0.685 | 0.752 | 0000006201 | 0000100517 | 0001048911 |
| 11 | remainder_NetIncome | -0.674 | -0.631 | -0.336 | 0.441 | 0.473 | 0001048911 | 0000100517 | 0000006201 |
| 12 | remainder_ComprehensiveNetIncome | -0.0248 | -0.0143 | 0.00189 | 0.00226 | 0.00237 | 0001048911 | 0000004515 | 0000948846 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.448 | -0.309 | 0.110 | 0.266 | 0.271 | 0000027904 | 0001158463 | 0001048911 |
| 1 | Assets | -0.0966 | -0.0868 | -0.0248 | 0.0529 | 0.0584 | 0000027904 | 0000006201 | 0001158463 |
| 2 | Expenses | -0.431 | -0.345 | -0.0148 | 0.122 | 0.140 | 0001048911 | 0000092380 | 0000073887 |
| 3 | Revenues | -0.569 | -0.562 | 0.190 | 0.685 | 0.752 | 0000006201 | 0000100517 | 0001048911 |
| 4 | StockholdersEquity | -0.399 | -0.315 | -0.0569 | 0.351 | 0.429 | 0000027904 | 0000006201 | 0000073887 |
| 5 | NetIncome | -0.0405 | -0.0401 | -0.00864 | 0.0520 | 0.0521 | 0000004515 | 0000948846 | 0000092380 |
| 6 | ComprehensiveNetIncome | -0.0387 | -0.0383 | -0.00625 | 0.0540 | 0.0541 | 0000004515 | 0000948846 | 0000092380 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000004515 | 0000092380 | 0000004515 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.519 | -0.396 | 0.0199 | 0.302 | 0.391 | 0000027904 | 0000948846 | 0000073887 |
| 9 | EconomicCapitalRatio | -0.523 | -0.401 | 0.0151 | 0.297 | 0.386 | 0000027904 | 0000948846 | 0000073887 |
2011
Logs
| error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
| warning | 16 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × No stock price available | subcommand.plot | |
| warning | 11 × The stock price does not exist | industry.us_generic | |
| warning | 9 × Missing logo | subcommand.report | |
| warning | 3 × Similarly named company. Duplicate? | None | |
| warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
| warning | 1 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 11,749,314 | 43,248,131 | 634,660,734 | 11,524,700,000 | 12,701,000,000 | 0000914397 | 0001514226 | 0000027904 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 15,247,000,000 | 32,194,000,000 | 0000004515 | 0001498710 | 0000027904 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 570,071,300 | 896,045,000 | 0000004515 | 0000092380 | 0001514226 |
| 3 | AssetsCurrent | 26,859,735 | 122,251,874 | 923,880,700 | 8,556,200,000 | 10,997,000,000 | 0000914397 | 0001514226 | 0000100517 |
| 4 | AssetsNoncurrent | 0 | 0 | 228,070,578 | 2,759,100,000 | 10,572,000,000 | 0001135185 | 0000701345 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | 23,210,000 | 23,996,600 | 1,772,169,812 | 16,799,400,000 | 20,223,000,000 | 0001498710 | 0000073887 | 0000027904 |
| 6 | remainder_Assets | 0 | 0 | 248,945,897 | 3,547,900,000 | 14,545,000,000 | 0000100517 | 0001135185 | 0000027904 |
| 7 | OperatingExpenses | 0 | 0 | 1,319,768,305 | 29,442,400,000 | 31,714,000,000 | 0000073887 | 0001172222 | 0000100517 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 91,318,487 | 1,589,600,000 | 1,973,000,000 | 0000073887 | 0000894081 | 0001048911 |
| 9 | remainder_Expenses | 14,667,785 | 92,520,678 | 545,627,240 | 5,618,400,000 | 6,576,000,000 | 0000914397 | 0000816159 | 0001048911 |
| 10 | remainder_Revenues | 0 | 0 | 1,232,663,532 | 37,329,400,000 | 39,304,000,000 | 0000004515 | 0001166291 | 0001048911 |
| 11 | remainder_NetIncome | -1,206,000,000 | -999,900,000 | -21,326,543 | 23,182,600,000 | 23,278,000,000 | 0000027904 | 0001172222 | 0000004515 |
| 12 | remainder_ComprehensiveNetIncome | -1,209,000,000 | -844,500,000 | 0 | 11,300,000 | 113,000,000 | 0000006201 | 0000894081 | 0000230211 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | 46,748,000 | 47,551,214 | 1,412,260,885 | 26,771,700,000 | 44,895,000,000 | 0000350403 | 0001158463 | 0000027904 |
| 1 | Assets | 83,777,500 | 679,609,450 | 2,683,266,163 | 38,539,100,000 | 43,499,000,000 | 0000914397 | 0000073887 | 0000027904 |
| 2 | Expenses | 124,755,662 | 494,260,866 | 3,792,399,936 | 35,537,600,000 | 37,739,000,000 | 0000914397 | 0001514226 | 0001048911 |
| 3 | Revenues | 0 | 0 | 1,232,663,532 | 37,329,400,000 | 39,304,000,000 | 0000004515 | 0001166291 | 0001048911 |
| 4 | StockholdersEquity | -1,396,000,000 | -107,076,664 | 1,141,503,120 | 15,946,500,000 | 22,503,000,000 | 0000027904 | 0001135185 | 0001048911 |
| 5 | NetIncome | -1,979,000,000 | -1,966,400,000 | 71,009,806 | 913,800,000 | 1,452,000,000 | 0000006201 | 0000701345 | 0001048911 |
| 6 | ComprehensiveNetIncome | -2,583,500,000 | -2,026,850,000 | 71,009,806 | 908,300,000 | 1,397,000,000 | 0000006201 | 0000701345 | 0001048911 |
| 7 | BaseVar | 195,808,776 | 958,445,578 | 5,553,470,300 | 69,507,000,000 | 78,885,000,000 | 0000914397 | 0001514226 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.00121 | 0.0182 | 0.520 | 1.19 | 1.23 | 0000027904 | 0000914397 | 0000073887 |
| 9 | EconomicCapitalRatio | 0.316 | 0.334 | 0.726 | 1.23 | 1.26 | 0000027904 | 0000914397 | 0000073887 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.218 | -0.138 | 0.0132 | 0.123 | 0.169 | 0000004515 | 0001166291 | 0000350403 |
| 1 | LiabilitiesNonCurrent | -0.419 | -0.375 | 0.125 | 0.195 | 0.203 | 0000027904 | 0000092380 | 0001048911 |
| 2 | remainder_Liabilities | -0.396 | -0.361 | 0.0548 | 0.101 | 0.106 | 0000816159 | 0000006201 | 0001048911 |
| 3 | AssetsCurrent | -0.0671 | -0.0557 | -0.00129 | 0.0224 | 0.0802 | 0000027904 | 0000004515 | 0001498710 |
| 4 | AssetsNoncurrent | -0.0376 | -0.0346 | -0.00500 | 0.0472 | 0.121 | 0000701345 | 0000092380 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | -0.300 | -0.201 | -0.0176 | 0.114 | 0.122 | 0001514226 | 0000230211 | 0001135185 |
| 6 | remainder_Assets | -0.0477 | -0.0396 | -0.00843 | 0.0524 | 0.133 | 0000100517 | 0001048911 | 0001514226 |
| 7 | OperatingExpenses | -0.573 | -0.556 | -0.143 | 0.508 | 0.550 | 0000230211 | 0000004515 | 0000350403 |
| 8 | DepreciationDepletionAndAmortization | -0.0499 | -0.0393 | -0.00341 | 0.0382 | 0.0394 | 0000894081 | 0001166291 | 0000350403 |
| 9 | remainder_Expenses | -1.26 | -0.735 | 0.128 | 0.250 | 0.255 | 0001514226 | 0001048911 | 0000092380 |
| 10 | remainder_Revenues | -0.936 | -0.860 | 0.103 | 0.634 | 0.638 | 0000006201 | 0000350403 | 0000230211 |
| 11 | remainder_NetIncome | -0.318 | -0.313 | -0.193 | 0.542 | 0.584 | 0001048911 | 0000027904 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.0231 | -0.00934 | 0.00176 | 0.00327 | 0.00716 | 0000006201 | 0000092380 | 0000230211 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.407 | -0.286 | 0.0571 | 0.341 | 0.346 | 0000027904 | 0000006201 | 0001048911 |
| 1 | Assets | -0.246 | -0.242 | -0.0278 | 0.0793 | 0.0819 | 0001514226 | 0001172222 | 0001158463 |
| 2 | Expenses | -0.405 | -0.403 | -0.0365 | 0.199 | 0.225 | 0000230211 | 0001166291 | 0000816159 |
| 3 | Revenues | -0.936 | -0.860 | 0.103 | 0.634 | 0.638 | 0000006201 | 0000350403 | 0000230211 |
| 4 | StockholdersEquity | -0.455 | -0.411 | -0.00408 | 0.513 | 0.527 | 0000701345 | 0001135185 | 0000073887 |
| 5 | NetIncome | -0.0987 | -0.0952 | 0.00000425 | 0.0871 | 0.0877 | 0000006201 | 0000027904 | 0000914397 |
| 6 | ComprehensiveNetIncome | -0.122 | -0.0960 | 0.00000491 | 0.0894 | 0.0898 | 0000006201 | 0000027904 | 0000914397 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000004515 | 0000816159 | 0000004515 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.453 | -0.434 | -0.0431 | 0.457 | 0.489 | 0000027904 | 0000914397 | 0000073887 |
| 9 | EconomicCapitalRatio | -0.453 | -0.434 | -0.0430 | 0.458 | 0.489 | 0000027904 | 0000914397 | 0000073887 |
2012
Logs
| error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
| warning | 16 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 13 × No stock price available | subcommand.plot | |
| warning | 12 × The stock price does not exist | industry.us_generic | |
| warning | 9 × Missing logo | subcommand.report | |
| warning | 4 × Similarly named company. Duplicate? | None | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 1,184,615 | 2,270,855 | 591,620,099 | 9,696,100,000 | 11,918,000,000 | 0000842722 | 0001172222 | 0000004515 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 2,101,530,250 | 5,303,000,000 | 0000004515 | 0000230211 | 0000701345 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 671,183,800 | 832,575,000 | 0000004515 | 0000092380 | 0001514226 |
| 3 | AssetsCurrent | 573,979 | 2,955,051 | 684,909,913 | 7,369,600,000 | 9,056,000,000 | 0000842722 | 0000073887 | 0001048911 |
| 4 | AssetsNoncurrent | 0 | 0 | 48,196,686 | 2,132,150,000 | 2,167,000,000 | 0001128281 | 0001514226 | 0000006201 |
| 5 | PropertyPlantAndEquipmentNet | 93,880 | 1,870,786 | 1,396,858,397 | 13,738,350,000 | 17,248,000,000 | 0000842722 | 0000073887 | 0001048911 |
| 6 | remainder_Assets | -93,880 | -14,082 | 326,198,654 | 1,339,800,000 | 2,387,000,000 | 0000842722 | 0001498710 | 0001048911 |
| 7 | OperatingExpenses | 0 | 0 | 773,682,424 | 22,805,550,000 | 30,912,000,000 | 0000073887 | 0001498710 | 0001048911 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 66,446,849 | 1,506,950,000 | 2,113,000,000 | 0000073887 | 0000816159 | 0001048911 |
| 9 | remainder_Expenses | 7,495,221 | 9,672,814 | 638,618,714 | 5,151,250,000 | 7,578,000,000 | 0000842722 | 0000816159 | 0001048911 |
| 10 | remainder_Revenues | 0 | 0 | 1,330,760,424 | 28,303,100,000 | 42,680,000,000 | 0000004515 | 0000073887 | 0001048911 |
| 11 | remainder_NetIncome | -219,000,000 | -71,100,000 | -1,844,855 | 24,474,450,000 | 24,511,000,000 | 0000701345 | 0001128281 | 0000006201 |
| 12 | remainder_ComprehensiveNetIncome | -2,403,000,000 | -520,250,000 | 0 | 984,450,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,259,461 | 1,566,622,165 | 9,696,100,000 | 11,918,000,000 | 0000842722 | 0001158463 | 0000004515 |
| 1 | Assets | 799,615 | 7,290,028 | 2,728,213,948 | 24,468,950,000 | 29,903,000,000 | 0000842722 | 0000073887 | 0001048911 |
| 2 | Expenses | 7,495,221 | 14,977,761 | 1,819,522,371 | 28,525,350,000 | 40,603,000,000 | 0000842722 | 0001172222 | 0001048911 |
| 3 | Revenues | 0 | 0 | 1,330,760,424 | 28,303,100,000 | 42,680,000,000 | 0000004515 | 0000073887 | 0001048911 |
| 4 | StockholdersEquity | -385,000 | 4,030,567 | 1,108,581,937 | 15,754,450,000 | 24,529,000,000 | 0000842722 | 0001172222 | 0001048911 |
| 5 | NetIncome | -1,926,000,000 | -1,883,500,000 | 59,259,407 | 991,600,000 | 2,032,000,000 | 0000004515 | 0000073887 | 0001048911 |
| 6 | ComprehensiveNetIncome | -1,432,500,000 | -1,391,275,000 | 49,035,610 | 731,475,000 | 830,500,000 | 0000004515 | 0000073887 | 0001048911 |
| 7 | BaseVar | 6,587,513 | 20,269,374 | 4,130,144,663 | 46,063,775,000 | 60,504,000,000 | 0000842722 | 0001539429 | 0001048911 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -11.4 | -1.60 | 0.544 | 1.06 | 1.16 | 0000842722 | 0001128281 | 0000073887 |
| 9 | EconomicCapitalRatio | 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000614 | 0.366 | 0.741 | 1.11 | 1.20 | 0000842722 | 0001128281 | 0000073887 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.225 | -0.154 | 0.0252 | 0.127 | 0.130 | 0000004515 | 0001514226 | 0000914397 |
| 1 | LiabilitiesNonCurrent | -0.416 | -0.368 | 0.0883 | 0.136 | 0.141 | 0001135185 | 0000350403 | 0001048911 |
| 2 | remainder_Liabilities | -0.463 | -0.304 | 0.0615 | 0.106 | 0.109 | 0000816159 | 0001158463 | 0001048911 |
| 3 | AssetsCurrent | -0.0414 | -0.0317 | -0.00604 | 0.0351 | 0.0740 | 0001539429 | 0000004515 | 0001498710 |
| 4 | AssetsNoncurrent | -0.0231 | -0.0201 | -0.00159 | 0.0285 | 0.0631 | 0001514226 | 0000350403 | 0001539429 |
| 5 | PropertyPlantAndEquipmentNet | -0.275 | -0.155 | 0.000851 | 0.135 | 0.162 | 0001514226 | 0000006201 | 0001135185 |
| 6 | remainder_Assets | -0.0547 | -0.0380 | -0.00547 | 0.120 | 0.150 | 0000914397 | 0000842722 | 0001514226 |
| 7 | OperatingExpenses | -0.796 | -0.771 | -0.285 | 0.442 | 0.572 | 0001498710 | 0001158463 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0477 | -0.0401 | -0.00500 | 0.0303 | 0.0428 | 0001048911 | 0000842722 | 0001128281 |
| 9 | remainder_Expenses | -1.44 | -1.09 | 0.265 | 0.482 | 0.501 | 0001128281 | 0000004515 | 0001498710 |
| 10 | remainder_Revenues | -0.846 | -0.780 | 0.149 | 0.696 | 0.712 | 0000006201 | 0000701345 | 0001048911 |
| 11 | remainder_NetIncome | -0.332 | -0.323 | -0.208 | 0.572 | 0.633 | 0001048911 | 0000073887 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.0514 | -0.0205 | 0.00129 | 0.0216 | 0.0219 | 0001048911 | 0000350403 | 0000004515 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.308 | -0.291 | 0.0319 | 0.284 | 0.309 | 0001539429 | 0001172222 | 0001048911 |
| 1 | Assets | -0.229 | -0.159 | -0.00391 | 0.109 | 0.136 | 0001514226 | 0000842722 | 0001135185 |
| 2 | Expenses | -0.317 | -0.256 | 0.0157 | 0.265 | 0.319 | 0001128281 | 0000092380 | 0001135185 |
| 3 | Revenues | -0.846 | -0.780 | 0.149 | 0.696 | 0.712 | 0000006201 | 0000701345 | 0001048911 |
| 4 | StockholdersEquity | -0.391 | -0.358 | 0.000700 | 0.432 | 0.518 | 0001514226 | 0000006201 | 0000073887 |
| 5 | NetIncome | -0.119 | 0.0352 | 0.157 | 0.277 | 0.293 | 0000842722 | 0000092380 | 0001498710 |
| 6 | ComprehensiveNetIncome | -0.117 | 0.0472 | 0.155 | 0.279 | 0.295 | 0000842722 | 0000073887 | 0001498710 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000004515 | 0000816159 | 0000004515 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.314 | 0.0520 | 0.427 | 0.797 | 0.882 | 0000842722 | 0001128281 | 0000073887 |
| 9 | EconomicCapitalRatio | -0.738 | -0.372 | 0.00336 | 0.373 | 0.458 | 0000842722 | 0001128281 | 0000073887 |
2013
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 17 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × The stock price does not exist | industry.us_generic | |
| warning | 9 × No stock price available | subcommand.plot | |
| warning | 7 × Missing logo | subcommand.report | |
| warning | 2 × Similarly named company. Duplicate? | None | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 2 × Ignoring company because Assets is zero | pre-agg | |
| warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 12,845,459 | 60,694,693 | 4,330,841,630 | 72,814,200,000 | 80,657,000,000 | 0000842722 | 0001159154 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -11.7 | -5.36 | 0.421 | 1.18 | 1.21 | 0000842722 | 0000914397 | 0000350403 |
| 9 | EconomicCapitalRatio | 0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000720 | 0.0000000000311 | 0.659 | 1.21 | 1.24 | 0000842722 | 0000914397 | 0000350403 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.122 | -0.114 | 0.0000283 | 0.113 | 0.146 | 0000092380 | 0000842722 | 0000350403 |
| 1 | LiabilitiesNonCurrent | -0.394 | -0.364 | 0.0731 | 0.183 | 0.200 | 0001135185 | 0000816159 | 0001048911 |
| 2 | remainder_Liabilities | -0.470 | -0.461 | 0.0812 | 0.188 | 0.206 | 0001159154 | 0000027904 | 0001048911 |
| 3 | AssetsCurrent | -0.0458 | -0.0381 | -0.00968 | 0.0164 | 0.0515 | 0001159154 | 0000092380 | 0001498710 |
| 4 | AssetsNoncurrent | -0.0176 | -0.0140 | -0.00110 | 0.0306 | 0.118 | 0001159154 | 0000350403 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | -0.0970 | -0.0777 | -0.000492 | 0.197 | 0.282 | 0001498710 | 0000353184 | 0001525221 |
| 6 | remainder_Assets | -0.0500 | -0.0450 | -0.00233 | 0.0744 | 0.115 | 0000914397 | 0001159154 | 0000027904 |
| 7 | OperatingExpenses | -0.805 | -0.786 | -0.00131 | 0.398 | 0.454 | 0001498710 | 0000006201 | 0000350403 |
| 8 | DepreciationDepletionAndAmortization | -0.0547 | -0.0467 | 0.0000000000000199 | 0.0293 | 0.0338 | 0001048911 | 0000842722 | 0000350403 |
| 9 | remainder_Expenses | -0.583 | -0.370 | 0.0851 | 0.426 | 0.432 | 0000350403 | 0001159154 | 0000092380 |
| 10 | remainder_Revenues | -0.819 | -0.712 | 0.121 | 0.729 | 0.771 | 0000350403 | 0000027904 | 0001048911 |
| 11 | remainder_NetIncome | -0.102 | -0.0805 | -0.0381 | 0.698 | 0.923 | 0000914397 | 0001159154 | 0000350403 |
| 12 | remainder_ComprehensiveNetIncome | -0.0156 | -0.00830 | -0.00261 | 0.0173 | 0.0222 | 0000073887 | 0001135185 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.335 | -0.335 | 0.000182 | 0.400 | 0.403 | 0000006201 | 0000842722 | 0001048911 |
| 1 | Assets | -0.127 | -0.0760 | 0.00837 | 0.126 | 0.177 | 0000914397 | 0000092380 | 0001525221 |
| 2 | Expenses | -0.352 | -0.335 | 0.0238 | 0.314 | 0.316 | 0000230211 | 0000100517 | 0001525221 |
| 3 | Revenues | -0.819 | -0.712 | 0.121 | 0.729 | 0.771 | 0000350403 | 0000027904 | 0001048911 |
| 4 | StockholdersEquity | -0.279 | -0.181 | 0.0000620 | 0.469 | 0.502 | 0000006201 | 0000353184 | 0000073887 |
| 5 | NetIncome | -0.589 | -0.141 | 0.291 | 0.428 | 0.496 | 0000353184 | 0000092380 | 0001498710 |
| 6 | ComprehensiveNetIncome | -0.596 | -0.144 | 0.288 | 0.437 | 0.489 | 0000353184 | 0000073887 | 0001498710 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0000816159 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.252 | -0.252 | 0.407 | 0.963 | 0.985 | 0000353184 | 0000914397 | 0000350403 |
| 9 | EconomicCapitalRatio | -0.695 | -0.695 | -0.0355 | 0.520 | 0.542 | 0000353184 | 0000914397 | 0000350403 |
2014
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 20 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × The stock price does not exist | industry.us_generic | |
| warning | 9 × No stock price available | subcommand.plot | |
| warning | 7 × Missing logo | subcommand.report | |
| warning | 6 × Similarly named company. Duplicate? | None | |
| warning | 5 × Ignoring company because Assets is zero | pre-agg | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 2,558,719 | 3,050,674 | 478,022,117 | 13,951,600,000 | 16,879,000,000 | 0001128281 | 0001135185 | 0000027904 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 28,332,100,000 | 28,429,000,000 | 0000073887 | 0000914397 | 0000027904 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 943,519,800 | 2,402,300,000 | 0000006201 | 0000092380 | 0001159154 |
| 3 | AssetsCurrent | 210,521 | 2,925,935 | 713,255,492 | 12,164,950,000 | 12,465,000,000 | 0000869187 | 0000073887 | 0000027904 |
| 4 | AssetsNoncurrent | 0 | 0 | 48,010,407 | 3,369,600,000 | 9,748,000,000 | 0000869187 | 0001498710 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | 2,086,794 | 2,281,650 | 2,565,832,153 | 22,102,250,000 | 23,084,000,000 | 0001128281 | 0001159154 | 0000006201 |
| 6 | remainder_Assets | 0 | 0 | 249,128,510 | 8,188,900,000 | 18,717,000,000 | 0000100517 | 0001159154 | 0000027904 |
| 7 | OperatingExpenses | 0 | 0 | 1,006,453,717 | 33,292,350,000 | 34,762,000,000 | 0000073887 | 0001498710 | 0000006201 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 88,298,197 | 1,893,400,000 | 2,587,000,000 | 0000869187 | 0000073887 | 0001048911 |
| 9 | remainder_Expenses | 4,920,842 | 13,175,795 | 816,002,895 | 5,419,400,000 | 9,360,000,000 | 0000914397 | 0000816159 | 0001048911 |
| 10 | remainder_Revenues | 0 | 0 | 1,521,640,533 | 41,142,750,000 | 45,567,000,000 | 0000006201 | 0000073887 | 0001048911 |
| 11 | remainder_NetIncome | -1,245,000,000 | -1,150,650,000 | -2,532,601 | 11,278,200,000 | 41,613,000,000 | 0000100517 | 0001498710 | 0000006201 |
| 12 | remainder_ComprehensiveNetIncome | -2,527,000,000 | -2,232,900,000 | -790,254 | 11,110,000 | 42,135,000 | 0000006201 | 0001498710 | 0000073887 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | 3,515,698 | 4,456,916 | 1,410,998,594 | 42,283,700,000 | 45,308,000,000 | 0001128281 | 0001158463 | 0000027904 |
| 1 | Assets | 2,845,240 | 6,126,838 | 3,446,291,263 | 45,323,500,000 | 54,121,000,000 | 0000869187 | 0001159154 | 0000027904 |
| 2 | Expenses | 15,426,433 | 17,063,017 | 1,657,356,108 | 39,384,250,000 | 43,086,000,000 | 0000869187 | 0001498710 | 0001048911 |
| 3 | Revenues | 0 | 0 | 1,521,640,533 | 41,142,750,000 | 45,567,000,000 | 0000006201 | 0000073887 | 0001048911 |
| 4 | StockholdersEquity | -1,777,773 | 2,445,043 | 1,600,849,777 | 25,281,950,000 | 27,758,000,000 | 0000869187 | 0001172222 | 0001048911 |
| 5 | NetIncome | -15,426,433 | -8,579,198 | 145,148,438 | 2,407,700,000 | 2,882,000,000 | 0000869187 | 0000073887 | 0000006201 |
| 6 | ComprehensiveNetIncome | -431,500,000 | -77,837,468 | 100,058,510 | 1,716,750,000 | 2,273,500,000 | 0000027904 | 0001135185 | 0001048911 |
| 7 | BaseVar | 11,447,343 | 21,549,073 | 4,290,012,872 | 85,192,225,000 | 90,837,500,000 | 0000869187 | 0001159154 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -4.44 | -0.608 | 0.546 | 1.06 | 1.10 | 0000869187 | 0000100517 | 0000073887 |
| 9 | EconomicCapitalRatio | 0.00000000000000700 | 0.325 | 0.742 | 1.12 | 1.15 | 0000869187 | 0000100517 | 0000073887 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.126 | -0.118 | 0.0191 | 0.151 | 0.205 | 0001172222 | 0001159154 | 0000353184 |
| 1 | LiabilitiesNonCurrent | -0.414 | -0.377 | 0.100 | 0.189 | 0.224 | 0001135185 | 0000100517 | 0000353184 |
| 2 | remainder_Liabilities | -0.467 | -0.416 | 0.124 | 0.237 | 0.281 | 0001159154 | 0001172222 | 0000353184 |
| 3 | AssetsCurrent | -0.0433 | -0.0235 | -0.000683 | 0.0531 | 0.125 | 0001159154 | 0000869187 | 0000353184 |
| 4 | AssetsNoncurrent | -0.0279 | -0.0188 | -0.00202 | 0.0188 | 0.0850 | 0001128281 | 0001048911 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | -0.229 | -0.174 | -0.00413 | 0.201 | 0.287 | 0001128281 | 0000869187 | 0001525221 |
| 6 | remainder_Assets | -0.0503 | -0.0380 | -0.00427 | 0.0606 | 0.104 | 0000914397 | 0001172222 | 0000027904 |
| 7 | OperatingExpenses | -0.666 | -0.654 | -0.172 | 0.590 | 0.776 | 0001048911 | 0000027904 | 0000353184 |
| 8 | DepreciationDepletionAndAmortization | -0.0601 | -0.0565 | -0.00271 | 0.0564 | 0.0650 | 0000914397 | 0000869187 | 0001128281 |
| 9 | remainder_Expenses | -2.70 | -2.03 | 0.142 | 0.429 | 0.475 | 0000353184 | 0000027904 | 0000100517 |
| 10 | remainder_Revenues | -0.913 | -0.704 | 0.0768 | 0.652 | 0.897 | 0001158463 | 0000914397 | 0000353184 |
| 11 | remainder_NetIncome | -0.263 | -0.222 | -0.0985 | 0.329 | 0.669 | 0001128281 | 0000027904 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.0212 | -0.0176 | 0.00410 | 0.0130 | 0.0143 | 0000006201 | 0001159154 | 0000073887 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.335 | -0.282 | 0.132 | 0.451 | 0.575 | 0001159154 | 0000100517 | 0000353184 |
| 1 | Assets | -0.244 | -0.166 | -0.00304 | 0.147 | 0.195 | 0001128281 | 0000869187 | 0001525221 |
| 2 | Expenses | -1.17 | -0.683 | 0.0552 | 0.273 | 0.330 | 0000353184 | 0001172222 | 0001525221 |
| 3 | Revenues | -0.913 | -0.704 | 0.0768 | 0.652 | 0.897 | 0001158463 | 0000914397 | 0000353184 |
| 4 | StockholdersEquity | -0.359 | -0.298 | 0.0336 | 0.266 | 0.443 | 0001128281 | 0001525221 | 0000073887 |
| 5 | NetIncome | -0.221 | -0.0520 | 0.129 | 0.243 | 0.280 | 0000869187 | 0001158463 | 0001498710 |
| 6 | ComprehensiveNetIncome | -0.218 | -0.0467 | 0.118 | 0.254 | 0.286 | 0000869187 | 0000092380 | 0001498710 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0000816159 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.581 | -0.256 | 0.161 | 0.536 | 0.565 | 0000869187 | 0000100517 | 0000073887 |
| 9 | EconomicCapitalRatio | -0.728 | -0.403 | 0.0143 | 0.389 | 0.418 | 0000869187 | 0000100517 | 0000073887 |
2015
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 20 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × The stock price does not exist | industry.us_generic | |
| warning | 8 × No stock price available | subcommand.plot | |
| warning | 4 × Missing logo | subcommand.report | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 2 × Similarly named company. Duplicate? | None | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 1,670,964 | 6,601,611 | 659,345,860 | 14,585,250,000 | 17,526,000,000 | 0001128281 | 0001172222 | 0000027904 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 25,862,250,000 | 29,175,000,000 | 0000073887 | 0001159154 | 0000006201 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 463,099,750 | 812,899,000 | 0000006201 | 0001135185 | 0000816159 |
| 3 | AssetsCurrent | 3,657,961 | 29,917,008 | 696,594,070 | 10,072,500,000 | 10,335,000,000 | 0001128281 | 0001172222 | 0001048911 |
| 4 | AssetsNoncurrent | 0 | 0 | 110,750,838 | 11,053,250,000 | 11,453,000,000 | 0001128281 | 0000073887 | 0000100517 |
| 5 | PropertyPlantAndEquipmentNet | 1,496,656 | 2,302,788 | 2,582,974,298 | 24,156,750,000 | 27,510,000,000 | 0001128281 | 0001159154 | 0000006201 |
| 6 | remainder_Assets | 0 | 0 | 196,685,071 | 7,760,250,000 | 19,611,000,000 | 0000006201 | 0001172222 | 0000027904 |
| 7 | OperatingExpenses | 0 | 0 | 1,339,649,464 | 31,239,250,000 | 32,026,000,000 | 0000073887 | 0001498710 | 0001048911 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 94,500,840 | 2,029,000,000 | 2,611,000,000 | 0000350403 | 0001172222 | 0001048911 |
| 9 | remainder_Expenses | -1,453,000,000 | -775,000,000 | 717,000,706 | 7,906,500,000 | 11,526,000,000 | 0000100517 | 0000350403 | 0001048911 |
| 10 | remainder_Revenues | 0 | 0 | 1,840,718,015 | 42,605,750,000 | 47,453,000,000 | 0000350403 | 0000073887 | 0001048911 |
| 11 | remainder_NetIncome | -1,588,000,000 | -1,107,250,000 | -40,460,602 | 2,156,796,000 | 6,297,000,000 | 0000006201 | 0001614436 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -334,000,000 | -318,250,000 | -63,376 | 107,000,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,764,736 | 1,626,878,216 | 42,408,000,000 | 42,780,000,000 | 0001128281 | 0001158463 | 0000006201 |
| 1 | Assets | 6,242,914 | 34,153,015 | 3,422,734,320 | 49,594,750,000 | 53,134,000,000 | 0001128281 | 0001159154 | 0000027904 |
| 2 | Expenses | 14,963,203 | 86,012,392 | 1,757,911,874 | 38,190,500,000 | 46,163,000,000 | 0001128281 | 0001498710 | 0001048911 |
| 3 | Revenues | 0 | 0 | 1,840,718,015 | 42,605,750,000 | 47,453,000,000 | 0000350403 | 0000073887 | 0001048911 |
| 4 | StockholdersEquity | 3,919,450 | 27,388,279 | 1,902,594,092 | 28,979,000,000 | 30,575,000,000 | 0001128281 | 0001498710 | 0001048911 |
| 5 | NetIncome | -27,100,000 | -6,253,594 | 250,134,861 | 7,407,500,000 | 7,610,000,000 | 0001159154 | 0001498710 | 0000006201 |
| 6 | ComprehensiveNetIncome | -27,100,000 | -6,253,594 | 255,793,339 | 7,478,875,000 | 7,523,500,000 | 0001159154 | 0001498710 | 0000006201 |
| 7 | BaseVar | 19,909,892 | 107,617,623 | 4,276,375,800 | 83,693,750,000 | 86,168,000,000 | 0001128281 | 0001159154 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.110 | 0.210 | 0.789 | 1.13 | 1.20 | 0001159154 | 0001172222 | 0000350403 |
| 9 | EconomicCapitalRatio | 0.419 | 0.503 | 0.906 | 1.17 | 1.24 | 0001159154 | 0001172222 | 0000350403 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.409 | -0.184 | 0.0271 | 0.248 | 0.344 | 0001159154 | 0001135185 | 0000353184 |
| 1 | LiabilitiesNonCurrent | -0.385 | -0.373 | 0.106 | 0.203 | 0.249 | 0001135185 | 0001172222 | 0000353184 |
| 2 | remainder_Liabilities | -0.487 | -0.209 | 0.0562 | 0.105 | 0.144 | 0000816159 | 0001158463 | 0000353184 |
| 3 | AssetsCurrent | -0.0664 | -0.0530 | -0.00560 | 0.0428 | 0.0945 | 0001159154 | 0000073887 | 0000353184 |
| 4 | AssetsNoncurrent | -0.0373 | -0.0342 | -0.0100 | 0.0784 | 0.0984 | 0001128281 | 0001048911 | 0001614436 |
| 5 | PropertyPlantAndEquipmentNet | -0.165 | -0.137 | -0.0108 | 0.142 | 0.216 | 0001128281 | 0000100517 | 0001135185 |
| 6 | remainder_Assets | -0.0389 | -0.0287 | -0.00350 | 0.0673 | 0.166 | 0000006201 | 0001159154 | 0000027904 |
| 7 | OperatingExpenses | -0.639 | -0.508 | -0.123 | 0.676 | 0.786 | 0001048911 | 0000027904 | 0000353184 |
| 8 | DepreciationDepletionAndAmortization | -0.0518 | -0.0299 | -0.00532 | 0.0613 | 0.0732 | 0001048911 | 0000027904 | 0000353184 |
| 9 | remainder_Expenses | -2.94 | -2.45 | 0.184 | 0.387 | 0.408 | 0000353184 | 0000027904 | 0000100517 |
| 10 | remainder_Revenues | -0.966 | -0.954 | 0.0833 | 0.776 | 0.915 | 0000350403 | 0000092380 | 0000353184 |
| 11 | remainder_NetIncome | -0.255 | -0.253 | -0.108 | 0.672 | 0.673 | 0001128281 | 0000006201 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.0243 | -0.0105 | 0.00168 | 0.00601 | 0.00687 | 0000073887 | 0000027904 | 0001172222 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.372 | -0.325 | 0.107 | 0.420 | 0.575 | 0001159154 | 0001172222 | 0000353184 |
| 1 | Assets | -0.178 | -0.138 | 0.000538 | 0.0968 | 0.102 | 0001128281 | 0000100517 | 0001159154 |
| 2 | Expenses | -1.53 | -1.16 | 0.0213 | 0.198 | 0.241 | 0000353184 | 0000100517 | 0001135185 |
| 3 | Revenues | -0.966 | -0.954 | 0.0833 | 0.776 | 0.915 | 0000350403 | 0000092380 | 0000353184 |
| 4 | StockholdersEquity | -0.469 | -0.412 | -0.0177 | 0.380 | 0.495 | 0001128281 | 0000092380 | 0000350403 |
| 5 | NetIncome | -0.143 | -0.105 | -0.00546 | 0.120 | 0.122 | 0000353184 | 0000816159 | 0001614436 |
| 6 | ComprehensiveNetIncome | -0.141 | -0.108 | -0.00153 | 0.123 | 0.124 | 0000353184 | 0001172222 | 0000100517 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.437 | -0.354 | 0.0500 | 0.316 | 0.379 | 0001159154 | 0001172222 | 0000350403 |
| 9 | EconomicCapitalRatio | -0.444 | -0.361 | 0.0428 | 0.309 | 0.372 | 0001159154 | 0001172222 | 0000350403 |
2016
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 20 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × The stock price does not exist | industry.us_generic | |
| warning | 5 × No stock price available | subcommand.plot | |
| warning | 3 × Ignoring company because Assets is zero | pre-agg | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Similarly named company. Duplicate? | None | |
| warning | 1 × Missing logo | subcommand.report | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 18,800,304 | 116,299,441 | 5,315,098,947 | 85,009,900,000 | 88,399,000,000 | 0001128281 | 0001135185 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.100 | 0.202 | 0.822 | 1.11 | 1.17 | 0000006201 | 0001172222 | 0000350403 |
| 9 | EconomicCapitalRatio | 0.411 | 0.495 | 0.930 | 1.15 | 1.20 | 0000006201 | 0001172222 | 0000350403 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.136 | -0.133 | 0.00663 | 0.159 | 0.160 | 0001172222 | 0001498710 | 0000350403 |
| 1 | LiabilitiesNonCurrent | -0.372 | -0.363 | 0.129 | 0.229 | 0.242 | 0000006201 | 0001158463 | 0000353184 |
| 2 | remainder_Liabilities | -0.516 | -0.191 | 0.0535 | 0.0854 | 0.100 | 0000816159 | 0001172222 | 0000353184 |
| 3 | AssetsCurrent | -0.0543 | -0.0542 | -0.00621 | 0.0445 | 0.0467 | 0001135185 | 0001048911 | 0001128281 |
| 4 | AssetsNoncurrent | -0.0282 | -0.0233 | -0.00390 | 0.0695 | 0.0843 | 0000353184 | 0000092380 | 0000006201 |
| 5 | PropertyPlantAndEquipmentNet | -0.189 | -0.153 | -0.00349 | 0.144 | 0.240 | 0000353184 | 0001498710 | 0001135185 |
| 6 | remainder_Assets | -0.0609 | -0.0411 | -0.00280 | 0.0868 | 0.129 | 0000006201 | 0001172222 | 0000027904 |
| 7 | OperatingExpenses | -0.445 | -0.408 | -0.146 | 0.688 | 0.710 | 0001048911 | 0000006201 | 0000353184 |
| 8 | DepreciationDepletionAndAmortization | -0.0321 | -0.0285 | -0.00902 | 0.0652 | 0.0724 | 0001048911 | 0001498710 | 0000353184 |
| 9 | remainder_Expenses | -2.78 | -2.27 | 0.175 | 0.311 | 0.327 | 0000353184 | 0001048911 | 0000092380 |
| 10 | remainder_Revenues | -0.924 | -0.883 | 0.152 | 0.756 | 0.827 | 0001158463 | 0001498710 | 0000353184 |
| 11 | remainder_NetIncome | -0.290 | -0.262 | -0.132 | 0.580 | 0.700 | 0000353184 | 0001172222 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.00601 | -0.00477 | -0.000742 | 0.00975 | 0.0170 | 0001048911 | 0000100517 | 0000092380 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.356 | -0.306 | 0.0906 | 0.368 | 0.426 | 0000006201 | 0000092380 | 0000353184 |
| 1 | Assets | -0.193 | -0.149 | 0.00107 | 0.0772 | 0.0964 | 0000353184 | 0001172222 | 0001135185 |
| 2 | Expenses | -1.33 | -1.00 | 0.0306 | 0.196 | 0.254 | 0000353184 | 0001498710 | 0001135185 |
| 3 | Revenues | -0.924 | -0.883 | 0.152 | 0.756 | 0.827 | 0001158463 | 0001498710 | 0000353184 |
| 4 | StockholdersEquity | -0.615 | -0.446 | 0.0474 | 0.366 | 0.525 | 0000353184 | 0000100517 | 0000350403 |
| 5 | NetIncome | -0.0920 | -0.0749 | -0.000307 | 0.0474 | 0.0501 | 0000350403 | 0000816159 | 0001498710 |
| 6 | ComprehensiveNetIncome | -0.0928 | -0.0722 | -0.000918 | 0.0544 | 0.0620 | 0000350403 | 0000816159 | 0000092380 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0000816159 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.442 | -0.358 | 0.0759 | 0.299 | 0.348 | 0000006201 | 0001172222 | 0000350403 |
| 9 | EconomicCapitalRatio | -0.448 | -0.364 | 0.0700 | 0.293 | 0.343 | 0000006201 | 0001172222 | 0000350403 |
2017
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 20 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 14 × The stock price does not exist | industry.us_generic | |
| warning | 4 × No stock price available | subcommand.plot | |
| warning | 3 × Ignoring company because Assets is zero | pre-agg | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 15,737,487 | 650,977,244 | 12,480,145,000 | 88,947,250,000 | 90,716,000,000 | 0001128281 | 0001158463 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.0897 | 0.181 | 0.968 | 1.15 | 1.17 | 0000006201 | 0000092380 | 0000350403 |
| 9 | EconomicCapitalRatio | 0.402 | 0.477 | 1.04 | 1.19 | 1.21 | 0000006201 | 0000092380 | 0000350403 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.110 | -0.102 | -0.0169 | 0.176 | 0.202 | 0001172222 | 0000006201 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.338 | -0.336 | 0.148 | 0.231 | 0.247 | 0000006201 | 0001172222 | 0001128281 |
| 2 | remainder_Liabilities | -0.0234 | -0.0114 | 0.00119 | 0.00162 | 0.00190 | 0001128281 | 0001158463 | 0001048911 |
| 3 | AssetsCurrent | -0.0556 | -0.0506 | -0.00719 | 0.0536 | 0.0898 | 0000006201 | 0000092380 | 0001128281 |
| 4 | AssetsNoncurrent | -0.0177 | -0.0174 | -0.00157 | 0.0547 | 0.0590 | 0001135185 | 0001498710 | 0000006201 |
| 5 | PropertyPlantAndEquipmentNet | -0.119 | -0.100 | -0.00878 | 0.103 | 0.141 | 0001128281 | 0001172222 | 0001135185 |
| 6 | remainder_Assets | -0.0574 | -0.0413 | 0.00105 | 0.0560 | 0.103 | 0000006201 | 0000350403 | 0000027904 |
| 7 | OperatingExpenses | -0.353 | -0.323 | -0.172 | 0.587 | 0.762 | 0001048911 | 0001498710 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0324 | -0.0277 | -0.00726 | 0.0488 | 0.0654 | 0001048911 | 0001172222 | 0001128281 |
| 9 | remainder_Expenses | -2.21 | -1.32 | 0.133 | 0.245 | 0.260 | 0001128281 | 0000027904 | 0000092380 |
| 10 | remainder_Revenues | -0.880 | -0.825 | 0.139 | 0.623 | 0.749 | 0001158463 | 0001498710 | 0001128281 |
| 11 | remainder_NetIncome | -0.286 | -0.260 | -0.156 | 0.586 | 0.724 | 0001128281 | 0000100517 | 0001158463 |
| 12 | remainder_ComprehensiveNetIncome | -0.00452 | -0.00385 | -0.000685 | 0.00619 | 0.00748 | 0001048911 | 0001498710 | 0000092380 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.359 | -0.325 | 0.0835 | 0.345 | 0.371 | 0000006201 | 0001158463 | 0001128281 |
| 1 | Assets | -0.113 | -0.105 | -0.0177 | 0.0599 | 0.0639 | 0000006201 | 0000100517 | 0001135185 |
| 2 | Expenses | -0.871 | -0.655 | 0.0470 | 0.173 | 0.240 | 0001128281 | 0001158463 | 0001135185 |
| 3 | Revenues | -0.880 | -0.825 | 0.139 | 0.623 | 0.749 | 0001158463 | 0001498710 | 0001128281 |
| 4 | StockholdersEquity | -0.367 | -0.328 | 0.00160 | 0.372 | 0.475 | 0000006201 | 0000100517 | 0000350403 |
| 5 | NetIncome | -0.0694 | -0.0678 | -0.0155 | 0.0715 | 0.0789 | 0000350403 | 0001135185 | 0000092380 |
| 6 | ComprehensiveNetIncome | -0.0699 | -0.0687 | -0.0159 | 0.0743 | 0.0859 | 0000350403 | 0001135185 | 0000092380 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.500 | -0.424 | 0.137 | 0.285 | 0.305 | 0000006201 | 0000092380 | 0000350403 |
| 9 | EconomicCapitalRatio | -0.509 | -0.434 | 0.128 | 0.276 | 0.296 | 0000006201 | 0000092380 | 0000350403 |
2018
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 15 × The stock price does not exist | industry.us_generic | |
| warning | 4 × No stock price available | subcommand.plot | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 14,647,172 | 146,040,632 | 7,076,485,932 | 100,250,750,000 | 104,559,500,000 | 0001128281 | 0001135185 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.0205 | 0.126 | 0.769 | 1.04 | 1.04 | 0000006201 | 0001172222 | 0001048911 |
| 9 | EconomicCapitalRatio | 0.336 | 0.429 | 0.892 | 1.09 | 1.10 | 0000006201 | 0001172222 | 0001048911 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.226 | -0.153 | -0.00902 | 0.229 | 0.302 | 0000350403 | 0000006201 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.377 | -0.344 | 0.142 | 0.253 | 0.278 | 0000006201 | 0001158463 | 0001128281 |
| 2 | remainder_Liabilities | -0.280 | -0.136 | 0.0154 | 0.0321 | 0.0388 | 0000353184 | 0000006201 | 0001048911 |
| 3 | AssetsCurrent | -0.0689 | -0.0634 | -0.00361 | 0.111 | 0.117 | 0000006201 | 0001048911 | 0000353184 |
| 4 | AssetsNoncurrent | -0.106 | -0.0777 | -0.0195 | 0.174 | 0.325 | 0000353184 | 0001498710 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.274 | -0.183 | 0.0164 | 0.164 | 0.189 | 0000353184 | 0000100517 | 0001135185 |
| 6 | remainder_Assets | -0.164 | -0.0891 | 0.000991 | 0.107 | 0.177 | 0000027904 | 0000350403 | 0000353184 |
| 7 | OperatingExpenses | -0.484 | -0.445 | -0.132 | 0.574 | 0.777 | 0001048911 | 0000006201 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0348 | -0.0303 | -0.00745 | 0.0434 | 0.0599 | 0001048911 | 0000027904 | 0001128281 |
| 9 | remainder_Expenses | -1.96 | -1.57 | 0.167 | 0.299 | 0.318 | 0001128281 | 0001048911 | 0000100517 |
| 10 | remainder_Revenues | -0.191 | -0.188 | -0.00851 | 0.449 | 0.586 | 0000006201 | 0001158463 | 0001128281 |
| 11 | remainder_NetIncome | -0.0284 | -0.0235 | 0.00217 | 0.0207 | 0.0238 | 0001498710 | 0001158463 | 0001128281 |
| 12 | remainder_ComprehensiveNetIncome | -0.00178 | -0.00152 | -0.000513 | 0.00240 | 0.00434 | 0001048911 | 0000027904 | 0000100517 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.369 | -0.308 | 0.100 | 0.418 | 0.483 | 0000006201 | 0001172222 | 0001128281 |
| 1 | Assets | -0.238 | -0.151 | 0.00535 | 0.0928 | 0.0931 | 0000353184 | 0000100517 | 0001135185 |
| 2 | Expenses | -0.783 | -0.571 | -0.000612 | 0.200 | 0.234 | 0001128281 | 0001158463 | 0001135185 |
| 3 | Revenues | -0.191 | -0.188 | -0.00851 | 0.449 | 0.586 | 0000006201 | 0001158463 | 0001128281 |
| 4 | StockholdersEquity | -0.388 | -0.356 | 0.0364 | 0.265 | 0.322 | 0000353184 | 0000350403 | 0001498710 |
| 5 | NetIncome | -0.127 | -0.0752 | 0.0116 | 0.0550 | 0.0739 | 0000350403 | 0001498710 | 0001048911 |
| 6 | ComprehensiveNetIncome | -0.128 | -0.0761 | 0.0118 | 0.0538 | 0.0722 | 0000350403 | 0001498710 | 0001048911 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001048911 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.443 | -0.351 | 0.113 | 0.314 | 0.318 | 0000006201 | 0001172222 | 0001048911 |
| 9 | EconomicCapitalRatio | -0.443 | -0.350 | 0.114 | 0.315 | 0.318 | 0000006201 | 0001172222 | 0001048911 |
2019
Logs
| error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 15 × The stock price does not exist | industry.us_generic | |
| warning | 4 × No stock price available | subcommand.plot | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 3 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 3 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 15,722,230 | 237,721,302 | 11,428,295,244 | 103,559,400,000 | 105,196,500,000 | 0001128281 | 0001158463 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.0232 | 0.0727 | 0.831 | 0.997 | 1.03 | 0000006201 | 0001172222 | 0001498710 |
| 9 | EconomicCapitalRatio | 0.339 | 0.385 | 0.936 | 1.06 | 1.09 | 0000006201 | 0001172222 | 0001498710 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.0850 | -0.0837 | -0.00996 | 0.169 | 0.183 | 0001172222 | 0001135185 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.323 | -0.277 | 0.179 | 0.262 | 0.271 | 0000006201 | 0000100517 | 0001048911 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 0 | 0 | 0000006201 | 0001128281 | 0000006201 |
| 3 | AssetsCurrent | -0.0659 | -0.0549 | -0.00715 | 0.0797 | 0.124 | 0000006201 | 0001048911 | 0001128281 |
| 4 | AssetsNoncurrent | -0.0796 | -0.0792 | -0.0143 | 0.157 | 0.274 | 0000899394 | 0001172222 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.104 | -0.0879 | -0.00681 | 0.131 | 0.176 | 0001128281 | 0000100517 | 0001135185 |
| 6 | remainder_Assets | -0.158 | -0.0868 | 0.00152 | 0.0478 | 0.0524 | 0000027904 | 0001158463 | 0001135185 |
| 7 | OperatingExpenses | -0.746 | -0.495 | -0.0477 | 0.497 | 0.753 | 0001048911 | 0001498710 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0451 | -0.0337 | -0.00662 | 0.0523 | 0.0669 | 0000899394 | 0001498710 | 0001128281 |
| 9 | remainder_Expenses | -1.90 | -1.12 | 0.0958 | 0.223 | 0.285 | 0001128281 | 0000027904 | 0001048911 |
| 10 | remainder_Revenues | -0.195 | -0.177 | -0.0177 | 0.425 | 0.495 | 0001135185 | 0001172222 | 0001128281 |
| 11 | remainder_NetIncome | -0.0786 | -0.0444 | 0.00343 | 0.0206 | 0.0211 | 0001048911 | 0001172222 | 0001128281 |
| 12 | remainder_ComprehensiveNetIncome | -0.00277 | -0.00260 | 0.000710 | 0.00144 | 0.00162 | 0000006201 | 0001498710 | 0000100517 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.352 | -0.299 | 0.122 | 0.370 | 0.372 | 0000006201 | 0000100517 | 0001128281 |
| 1 | Assets | -0.116 | -0.104 | -0.00336 | 0.0601 | 0.0654 | 0000899394 | 0000100517 | 0001498710 |
| 2 | Expenses | -0.587 | -0.492 | 0.0263 | 0.144 | 0.145 | 0001128281 | 0000006201 | 0001135185 |
| 3 | Revenues | -0.195 | -0.177 | -0.0177 | 0.425 | 0.495 | 0001135185 | 0001172222 | 0001128281 |
| 4 | StockholdersEquity | -0.345 | -0.298 | 0.0298 | 0.286 | 0.341 | 0000006201 | 0001048911 | 0001498710 |
| 5 | NetIncome | -0.102 | -0.0901 | 0.0299 | 0.0508 | 0.0611 | 0000899394 | 0000100517 | 0001128281 |
| 6 | ComprehensiveNetIncome | -0.101 | -0.0894 | 0.0305 | 0.0512 | 0.0622 | 0000899394 | 0001172222 | 0001128281 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0001128281 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.446 | -0.400 | 0.151 | 0.277 | 0.301 | 0000006201 | 0001172222 | 0001498710 |
| 9 | EconomicCapitalRatio | -0.443 | -0.397 | 0.155 | 0.281 | 0.305 | 0000006201 | 0001172222 | 0001498710 |
2020
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 15 × The stock price does not exist | industry.us_generic | |
| warning | 7 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 6 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 3 × No stock price available | subcommand.plot | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 372,402,500 | 412,030,250 | 7,935,564,677 | 102,861,000,000 | 110,681,000,000 | 0000353184 | 0001135185 | 0001048911 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.210 | -0.189 | 0.435 | 0.930 | 1.01 | 0000006201 | 0000899394 | 0001048911 |
| 9 | EconomicCapitalRatio | 0.295 | 0.298 | 0.668 | 1.01 | 1.07 | 0000006201 | 0000899394 | 0001048911 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.0882 | -0.0662 | -0.000240 | 0.114 | 0.189 | 0001172222 | 0000006201 | 0001048911 |
| 1 | LiabilitiesNonCurrent | -0.198 | -0.191 | 0.162 | 0.271 | 0.345 | 0000027904 | 0001172222 | 0001048911 |
| 2 | remainder_Liabilities | -0.187 | -0.0926 | 0.00984 | 0.0185 | 0.0253 | 0000353184 | 0000899394 | 0001048911 |
| 3 | AssetsCurrent | -0.0698 | -0.0528 | 0.0141 | 0.0498 | 0.0515 | 0000810332 | 0000100517 | 0000899394 |
| 4 | AssetsNoncurrent | -0.138 | -0.103 | -0.00236 | 0.0873 | 0.154 | 0000353184 | 0001172222 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.281 | -0.164 | 0.0272 | 0.134 | 0.170 | 0000353184 | 0001498710 | 0000810332 |
| 6 | remainder_Assets | -0.0784 | -0.0405 | 0.00000818 | 0.0843 | 0.141 | 0000027904 | 0000810332 | 0000353184 |
| 7 | OperatingExpenses | -0.697 | -0.405 | -0.0121 | 0.246 | 0.315 | 0001048911 | 0001172222 | 0000353184 |
| 8 | DepreciationDepletionAndAmortization | -0.0278 | -0.0201 | -0.00656 | 0.0408 | 0.0422 | 0000899394 | 0001498710 | 0000353184 |
| 9 | remainder_Expenses | -1.19 | -0.674 | 0.0312 | 0.137 | 0.140 | 0000353184 | 0001172222 | 0000899394 |
| 10 | remainder_Revenues | -0.105 | -0.0987 | -0.0446 | 0.424 | 0.522 | 0001172222 | 0000810332 | 0001048911 |
| 11 | remainder_NetIncome | -0.0308 | -0.0205 | -0.000100 | 0.0350 | 0.0533 | 0000100517 | 0001172222 | 0000353184 |
| 12 | remainder_ComprehensiveNetIncome | -0.00709 | -0.00447 | 0.00103 | 0.00224 | 0.00232 | 0000353184 | 0001048911 | 0001135185 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.175 | -0.170 | 0.101 | 0.328 | 0.467 | 0000006201 | 0001172222 | 0001048911 |
| 1 | Assets | -0.289 | -0.169 | -0.0150 | 0.106 | 0.107 | 0000353184 | 0000810332 | 0001498710 |
| 2 | Expenses | -0.556 | -0.508 | 0.0198 | 0.0989 | 0.131 | 0001048911 | 0001158463 | 0000810332 |
| 3 | Revenues | -0.105 | -0.0987 | -0.0446 | 0.424 | 0.522 | 0001172222 | 0000810332 | 0001048911 |
| 4 | StockholdersEquity | -0.465 | -0.356 | -0.116 | 0.326 | 0.355 | 0000353184 | 0000899394 | 0001498710 |
| 5 | NetIncome | -0.0938 | -0.0902 | -0.0123 | 0.167 | 0.182 | 0001172222 | 0000027904 | 0000353184 |
| 6 | ComprehensiveNetIncome | -0.0933 | -0.0909 | -0.0125 | 0.164 | 0.173 | 0001172222 | 0000027904 | 0000353184 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000006201 | 0000899394 | 0000006201 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.367 | -0.363 | 0.00670 | 0.349 | 0.407 | 0000006201 | 0000899394 | 0001048911 |
| 9 | EconomicCapitalRatio | -0.375 | -0.372 | -0.00158 | 0.341 | 0.399 | 0000006201 | 0000899394 | 0001048911 |
2021
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 15 × The stock price does not exist | industry.us_generic | |
| warning | 7 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 6 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 3 × No stock price available | subcommand.plot | |
| warning | 1 × Similarly named company. Duplicate? | None | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 8,673,144 | 203,528,286 | 5,321,227,680 | 108,568,000,000 | 130,586,500,000 | 0001128281 | 0001670076 | 0001048911 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | 0.0456 | 0.0514 | 0.729 | 1.05 | 1.08 | 0000353184 | 0001172222 | 0001128281 |
| 9 | EconomicCapitalRatio | 0.361 | 0.366 | 0.865 | 1.11 | 1.13 | 0000353184 | 0001172222 | 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.365 | -0.147 | 0.0318 | 0.214 | 0.234 | 0001819516 | 0001743907 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.335 | -0.284 | 0.0818 | 0.216 | 0.264 | 0000027904 | 0001779128 | 0001048911 |
| 2 | remainder_Liabilities | -0.396 | -0.205 | 0.0323 | 0.0636 | 0.0757 | 0000353184 | 0000100517 | 0001048911 |
| 3 | AssetsCurrent | -0.132 | -0.130 | -0.0211 | 0.203 | 0.504 | 0000027904 | 0000353184 | 0001779128 |
| 4 | AssetsNoncurrent | -0.122 | -0.0738 | -0.0208 | 0.109 | 0.145 | 0000353184 | 0001158463 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.258 | -0.202 | 0.00119 | 0.160 | 0.242 | 0000353184 | 0001743907 | 0000810332 |
| 6 | remainder_Assets | -0.202 | -0.0665 | -0.00706 | 0.111 | 0.151 | 0000027904 | 0001172222 | 0001819516 |
| 7 | OperatingExpenses | -0.804 | -0.370 | -0.0739 | 0.286 | 0.461 | 0001048911 | 0000027904 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0371 | -0.0292 | -0.00875 | 0.0349 | 0.0486 | 0000899394 | 0001172222 | 0001128281 |
| 9 | remainder_Expenses | -1.18 | -0.945 | 0.0695 | 0.171 | 0.189 | 0001128281 | 0001819516 | 0000899394 |
| 10 | remainder_Revenues | -0.262 | -0.216 | -0.0124 | 0.447 | 0.491 | 0001819516 | 0001498710 | 0001048911 |
| 11 | remainder_NetIncome | -0.0583 | -0.0560 | 0.00417 | 0.0579 | 0.0931 | 0001779128 | 0001135185 | 0001128281 |
| 12 | remainder_ComprehensiveNetIncome | -0.00319 | -0.00232 | -0.00159 | 0.00744 | 0.0108 | 0001128281 | 0000810332 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.306 | -0.283 | 0.0551 | 0.407 | 0.434 | 0000027904 | 0000100517 | 0001048911 |
| 1 | Assets | -0.320 | -0.170 | -0.0110 | 0.157 | 0.189 | 0000353184 | 0000810332 | 0001819516 |
| 2 | Expenses | -0.607 | -0.512 | 0.00465 | 0.154 | 0.258 | 0001048911 | 0001172222 | 0001819516 |
| 3 | Revenues | -0.262 | -0.216 | -0.0124 | 0.447 | 0.491 | 0001819516 | 0001498710 | 0001048911 |
| 4 | StockholdersEquity | -0.485 | -0.368 | 0.00724 | 0.302 | 0.361 | 0000353184 | 0001128281 | 0001779128 |
| 5 | NetIncome | -0.157 | -0.102 | -0.00627 | 0.167 | 0.206 | 0001779128 | 0001819516 | 0000899394 |
| 6 | ComprehensiveNetIncome | -0.159 | -0.104 | -0.00318 | 0.164 | 0.204 | 0001779128 | 0000810332 | 0000899394 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001135185 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.398 | -0.393 | 0.106 | 0.348 | 0.367 | 0000353184 | 0001172222 | 0001128281 |
| 9 | EconomicCapitalRatio | -0.393 | -0.388 | 0.111 | 0.353 | 0.372 | 0000353184 | 0001172222 | 0001128281 |
2022
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 15 × The stock price does not exist | industry.us_generic | |
| warning | 8 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 4 × Ignoring company because Assets is zero | pre-agg | |
| warning | 3 × No stock price available | subcommand.plot | |
| warning | 1 × Similarly named company. Duplicate? | None | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 1,130,400 | 16,416,360 | 1,344,472,936 | 18,940,400,000 | 25,940,000,000 | 0001128281 | 0001819516 | 0000027904 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 15,038,627 | 17,382,554,200 | 39,766,000,000 | 0000092380 | 0001779128 | 0000027904 |
| 2 | remainder_Liabilities | 0 | 0 | 0 | 266,086,000 | 304,000,000 | 0000027904 | 0001158463 | 0001670076 |
| 3 | AssetsCurrent | 6,870,063 | 133,623,625 | 1,125,582,067 | 17,030,800,000 | 20,365,000,000 | 0001128281 | 0001135185 | 0001048911 |
| 4 | AssetsNoncurrent | 0 | 11,197,200 | 460,216,246 | 40,233,600,000 | 59,277,000,000 | 0001128281 | 0001172222 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | 42,862 | 1,239,345 | 1,876,602,175 | 35,101,800,000 | 38,091,000,000 | 0001128281 | 0001172222 | 0001048911 |
| 6 | remainder_Assets | -33,109,000,000 | -13,243,600,000 | 346,176,838 | 794,741,200 | 970,000,000 | 0000027904 | 0001135185 | 0000092380 |
| 7 | OperatingExpenses | 0 | 0 | 2,430,822,453 | 57,826,200,000 | 83,019,000,000 | 0001128281 | 0001172222 | 0001048911 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 67,723,234 | 2,852,200,000 | 3,970,000,000 | 0001128281 | 0001743907 | 0001048911 |
| 9 | remainder_Expenses | 7,166,183 | 15,912,873 | 231,542,686 | 3,282,739,400 | 4,379,000,000 | 0001128281 | 0001172222 | 0000027904 |
| 10 | remainder_Revenues | 7,598,597 | 90,711,439 | 3,327,467,725 | 67,754,000,000 | 93,512,000,000 | 0001128281 | 0001670076 | 0001048911 |
| 11 | remainder_NetIncome | -1,747,000,000 | -1,508,200,000 | -60,723,162 | 12,976,800 | 25,497,000 | 0000027904 | 0001135185 | 0001779128 |
| 12 | remainder_ComprehensiveNetIncome | -371,000,000 | -174,800,000 | 0 | 534,000,000 | 1,329,000,000 | 0001048911 | 0000899394 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | 1,130,400 | 30,773,760 | 1,673,657,282 | 34,846,800,000 | 65,706,000,000 | 0001128281 | 0001819516 | 0000027904 |
| 1 | Assets | 6,912,925 | 197,780,170 | 4,501,636,779 | 77,770,400,000 | 85,994,000,000 | 0001128281 | 0001670076 | 0001048911 |
| 2 | Expenses | 7,166,183 | 122,192,673 | 3,363,923,359 | 63,845,000,000 | 88,337,000,000 | 0001128281 | 0001670076 | 0001048911 |
| 3 | Revenues | 7,598,597 | 90,711,439 | 3,327,467,725 | 67,754,000,000 | 93,512,000,000 | 0001128281 | 0001670076 | 0001048911 |
| 4 | StockholdersEquity | 5,782,525 | 148,956,610 | 3,019,353,572 | 43,682,600,000 | 71,720,000,000 | 0001128281 | 0001172222 | 0001048911 |
| 5 | NetIncome | -555,547,000 | -554,708,800 | 1,266,336 | 2,321,200,000 | 3,826,000,000 | 0001819516 | 0001128281 | 0001048911 |
| 6 | ComprehensiveNetIncome | -560,380,000 | -556,661,200 | 1,265,852 | 2,645,700,000 | 3,640,500,000 | 0001819516 | 0001128281 | 0001048911 |
| 7 | BaseVar | 11,811,156 | 229,496,462 | 7,593,333,243 | 128,518,100,000 | 141,918,500,000 | 0001128281 | 0001670076 | 0001048911 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.221 | -0.0465 | 0.677 | 1.10 | 1.24 | 0001819516 | 0001158463 | 0001128281 |
| 9 | EconomicCapitalRatio | 0.292 | 0.347 | 0.829 | 1.15 | 1.27 | 0001819516 | 0001158463 | 0001128281 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.0747 | -0.0688 | 0.000452 | 0.187 | 0.223 | 0000092380 | 0001743907 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.263 | -0.235 | 0.0902 | 0.245 | 0.283 | 0000027904 | 0001779128 | 0001128281 |
| 2 | remainder_Liabilities | -0.0345 | -0.0267 | 0.0132 | 0.0282 | 0.0326 | 0001670076 | 0001172222 | 0001128281 |
| 3 | AssetsCurrent | -0.123 | -0.117 | -0.0262 | 0.124 | 0.152 | 0000027904 | 0001498710 | 0001779128 |
| 4 | AssetsNoncurrent | -0.0677 | -0.0603 | -0.0192 | 0.131 | 0.180 | 0001743907 | 0001172222 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.175 | -0.113 | 0.0170 | 0.178 | 0.215 | 0001670076 | 0000027904 | 0001135185 |
| 6 | remainder_Assets | -0.208 | -0.0917 | -0.00193 | 0.0886 | 0.102 | 0000027904 | 0001158463 | 0001743907 |
| 7 | OperatingExpenses | -0.726 | -0.449 | -0.0877 | 0.522 | 0.666 | 0001048911 | 0000899394 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0422 | -0.0275 | -0.00634 | 0.0388 | 0.0534 | 0000899394 | 0001172222 | 0001128281 |
| 9 | remainder_Expenses | -1.24 | -0.862 | 0.140 | 0.271 | 0.331 | 0001128281 | 0001743907 | 0001048911 |
| 10 | remainder_Revenues | -0.155 | -0.124 | -0.0190 | 0.342 | 0.356 | 0001779128 | 0001819516 | 0001128281 |
| 11 | remainder_NetIncome | -0.0305 | -0.0294 | -0.0142 | 0.119 | 0.164 | 0001048911 | 0000092380 | 0001128281 |
| 12 | remainder_ComprehensiveNetIncome | -0.00392 | -0.00293 | -0.000614 | 0.00651 | 0.00812 | 0001048911 | 0001498710 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.305 | -0.293 | 0.0868 | 0.383 | 0.441 | 0000027904 | 0000092380 | 0001128281 |
| 1 | Assets | -0.0912 | -0.0825 | 0.00609 | 0.0668 | 0.0703 | 0001670076 | 0001743907 | 0001779128 |
| 2 | Expenses | -0.295 | -0.291 | -0.0176 | 0.118 | 0.158 | 0001048911 | 0001498710 | 0001743907 |
| 3 | Revenues | -0.155 | -0.124 | -0.0190 | 0.342 | 0.356 | 0001779128 | 0001819516 | 0001128281 |
| 4 | StockholdersEquity | -0.304 | -0.301 | 0.108 | 0.272 | 0.287 | 0001670076 | 0001158463 | 0001779128 |
| 5 | NetIncome | -0.0998 | -0.0987 | 0.0177 | 0.173 | 0.270 | 0001779128 | 0001743907 | 0001128281 |
| 6 | ComprehensiveNetIncome | -0.101 | -0.0969 | 0.0169 | 0.172 | 0.269 | 0001819516 | 0001743907 | 0001128281 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001158463 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.463 | -0.408 | 0.0736 | 0.393 | 0.516 | 0001819516 | 0001158463 | 0001128281 |
| 9 | EconomicCapitalRatio | -0.468 | -0.414 | 0.0686 | 0.388 | 0.511 | 0001819516 | 0001158463 | 0001128281 |
2023
Logs
| error | 1 × Negative Expenses, ignoring company. | pre-agg | |
| error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
| warning | 21 × The EntityCommonStockSharesOutstanding does not exist | industry.us_generic | |
| warning | 16 × The stock price does not exist | industry.us_generic | |
| warning | 9 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
| warning | 5 × Ignoring company because Assets is zero | pre-agg | |
| warning | 1 × No stock price available | subcommand.plot | |
| warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
| warning | 1 × Ignoring company because ECR is too negative | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 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 | 14,506,124 | 185,671,474 | 8,371,709,168 | 94,690,800,000 | 123,944,000,000 | 0001128281 | 0001670076 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.334 | -0.174 | 0.546 | 1.06 | 1.22 | 0001819516 | 0001779128 | 0001128281 |
| 9 | EconomicCapitalRatio | 0.264 | 0.311 | 0.742 | 1.12 | 1.25 | 0001819516 | 0001779128 | 0001128281 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.0698 | -0.0570 | -0.00373 | 0.127 | 0.155 | 0000092380 | 0001158463 | 0001779128 |
| 1 | LiabilitiesNonCurrent | -0.238 | -0.230 | 0.0877 | 0.190 | 0.223 | 0001670076 | 0001779128 | 0001128281 |
| 2 | remainder_Liabilities | -0.0219 | -0.0202 | 0.0163 | 0.0303 | 0.0358 | 0001819516 | 0000027904 | 0001128281 |
| 3 | AssetsCurrent | -0.117 | -0.114 | -0.0332 | 0.156 | 0.203 | 0001670076 | 0001498710 | 0001779128 |
| 4 | AssetsNoncurrent | -0.0839 | -0.0739 | -0.0348 | 0.166 | 0.214 | 0001743907 | 0001158463 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.153 | -0.136 | 0.0313 | 0.161 | 0.170 | 0001670076 | 0001498710 | 0001158463 |
| 6 | remainder_Assets | -0.190 | -0.117 | 0.0125 | 0.0814 | 0.0872 | 0000027904 | 0001498710 | 0001743907 |
| 7 | OperatingExpenses | -0.322 | -0.322 | -0.115 | 0.454 | 0.466 | 0001158463 | 0000027904 | 0001128281 |
| 8 | DepreciationDepletionAndAmortization | -0.0223 | -0.0216 | -0.00103 | 0.0358 | 0.0384 | 0001743907 | 0001819516 | 0001128281 |
| 9 | remainder_Expenses | -0.913 | -0.767 | 0.165 | 0.292 | 0.307 | 0001779128 | 0000027904 | 0000092380 |
| 10 | remainder_Revenues | -0.0976 | -0.0838 | -0.0143 | 0.148 | 0.220 | 0001670076 | 0001498710 | 0001128281 |
| 11 | remainder_NetIncome | -0.0216 | -0.0179 | -0.00340 | 0.0461 | 0.0538 | 0001743907 | 0000027904 | 0001128281 |
| 12 | remainder_ComprehensiveNetIncome | -0.00446 | -0.00267 | 0.000268 | 0.00222 | 0.00341 | 0000092380 | 0001158463 | 0001779128 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.264 | -0.249 | 0.0916 | 0.277 | 0.304 | 0001670076 | 0000092380 | 0001128281 |
| 1 | Assets | -0.0700 | -0.0663 | 0.00510 | 0.0552 | 0.0696 | 0001670076 | 0001128281 | 0001498710 |
| 2 | Expenses | -0.263 | -0.176 | -0.00680 | 0.144 | 0.157 | 0001779128 | 0000092380 | 0001743907 |
| 3 | Revenues | -0.0976 | -0.0838 | -0.0143 | 0.148 | 0.220 | 0001670076 | 0001498710 | 0001128281 |
| 4 | StockholdersEquity | -0.271 | -0.255 | 0.106 | 0.281 | 0.297 | 0001670076 | 0000092380 | 0001498710 |
| 5 | NetIncome | -0.192 | -0.145 | 0.0193 | 0.228 | 0.327 | 0001779128 | 0001670076 | 0001128281 |
| 6 | ComprehensiveNetIncome | -0.189 | -0.143 | 0.0195 | 0.228 | 0.327 | 0001779128 | 0001670076 | 0001128281 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001498710 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.424 | -0.377 | 0.0541 | 0.433 | 0.559 | 0001819516 | 0001779128 | 0001128281 |
| 9 | EconomicCapitalRatio | -0.435 | -0.388 | 0.0432 | 0.422 | 0.548 | 0001819516 | 0001779128 | 0001128281 |
2024
Logs
| warning | 3 × The stock price does not exist | industry.us_generic | |
| warning | 2 × No stock price available | subcommand.plot | |
| warning | 2 × Missing logo | subcommand.report | |
| warning | 1 × Ignoring company because Expenses is zero | pre-agg | |
| warning | 1 × Ignoring company because Assets is zero | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.
Absolute xval/yval quantiles
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | 1,208,149 | 11,967,074 | 918,136,081 | 19,473,000,000 | 26,670,000,000 | 0001128281 | 0001819516 | 0000027904 |
| 1 | LiabilitiesNonCurrent | 0 | 0 | 51,431,559 | 18,417,000,000 | 33,409,000,000 | 0000092380 | 0001819516 | 0000027904 |
| 2 | remainder_Liabilities | 0 | 0 | 5,993 | 1,286,406,500 | 1,862,625,000 | 0000027904 | 0001743907 | 0000894081 |
| 3 | AssetsCurrent | 10,781,872 | 85,761,936 | 619,828,542 | 10,559,000,000 | 11,274,000,000 | 0001128281 | 0001525221 | 0000092380 |
| 4 | AssetsNoncurrent | 0 | 5,156,000 | 407,700,857 | 35,083,342,500 | 65,528,000,000 | 0001128281 | 0001525221 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | 102,073 | 15,510,036 | 1,077,637,563 | 28,325,500,000 | 37,595,000,000 | 0001128281 | 0001525221 | 0000027904 |
| 6 | remainder_Assets | -37,595,000,000 | -18,797,500,000 | 354,594,023 | 966,000,000 | 970,000,000 | 0000027904 | 0001498710 | 0000092380 |
| 7 | OperatingExpenses | 0 | 0 | 1,276,983,258 | 36,489,000,000 | 47,473,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 8 | DepreciationDepletionAndAmortization | 0 | 0 | 95,219,284 | 2,085,000,000 | 2,513,000,000 | 0001128281 | 0001743907 | 0000027904 |
| 9 | remainder_Expenses | 7,268,620 | 68,634,310 | 199,264,183 | 3,929,287,500 | 6,863,000,000 | 0001128281 | 0001743907 | 0000027904 |
| 10 | remainder_Revenues | 9,169,459 | 128,931,230 | 1,963,784,029 | 44,563,000,000 | 61,643,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 11 | remainder_NetIncome | -1,337,000,000 | -775,000,000 | -36,403,061 | 152,500,000 | 277,000,000 | 0000027904 | 0001743907 | 0000092380 |
| 12 | remainder_ComprehensiveNetIncome | -39,099,000 | -32,049,500 | 0 | 433,500,000 | 866,000,000 | 0001525221 | 0000894081 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | 1,208,149 | 17,972,574 | 1,770,005,334 | 36,177,500,000 | 60,079,000,000 | 0001128281 | 0001498710 | 0000027904 |
| 1 | Assets | 10,883,945 | 133,779,472 | 3,895,970,289 | 54,561,000,000 | 75,372,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 2 | Expenses | 7,268,620 | 144,816,310 | 1,850,943,925 | 42,072,000,000 | 56,849,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 3 | Revenues | 9,169,459 | 128,931,230 | 1,963,784,029 | 44,563,000,000 | 61,643,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 4 | StockholdersEquity | -196,228,000 | -93,276,102 | 891,864,740 | 18,383,500,000 | 21,474,000,000 | 0001819516 | 0001525221 | 0000092380 |
| 5 | NetIncome | -1,229,495,000 | -1,012,247,500 | 27,459,469 | 1,961,000,000 | 3,457,000,000 | 0001498710 | 0000894081 | 0000027904 |
| 6 | ComprehensiveNetIncome | -1,229,367,500 | -1,012,183,750 | 27,459,454 | 2,171,250,000 | 3,890,000,000 | 0001498710 | 0000894081 | 0000027904 |
| 7 | BaseVar | 14,588,094 | 215,055,047 | 5,104,471,041 | 89,313,000,000 | 128,073,000,000 | 0001128281 | 0000894081 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.373 | -0.145 | 0.390 | 1.02 | 1.25 | 0001819516 | 0001525221 | 0001128281 |
| 9 | EconomicCapitalRatio | 0.253 | 0.324 | 0.638 | 1.09 | 1.27 | 0001819516 | 0001525221 | 0001128281 |
Effect quantiles (final effects with respect to final var and normalized if applicable)
| xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | LiabilitiesCurrent | -0.109 | -0.0824 | -0.00388 | 0.207 | 0.211 | 0000092380 | 0001743907 | 0001128281 |
| 1 | LiabilitiesNonCurrent | -0.293 | -0.249 | 0.0528 | 0.180 | 0.217 | 0001670076 | 0000894081 | 0001128281 |
| 2 | remainder_Liabilities | -0.338 | -0.264 | 0.0836 | 0.145 | 0.179 | 0000894081 | 0000027904 | 0001128281 |
| 3 | AssetsCurrent | -0.101 | -0.0984 | -0.0142 | 0.0900 | 0.105 | 0000027904 | 0001498710 | 0001779128 |
| 4 | AssetsNoncurrent | -0.0791 | -0.0704 | -0.0353 | 0.188 | 0.238 | 0001743907 | 0001819516 | 0000027904 |
| 5 | PropertyPlantAndEquipmentNet | -0.163 | -0.122 | 0.0182 | 0.176 | 0.226 | 0001670076 | 0000027904 | 0000894081 |
| 6 | remainder_Assets | -0.189 | -0.103 | 0.00401 | 0.0744 | 0.0849 | 0000027904 | 0001158463 | 0001743907 |
| 7 | OperatingExpenses | -0.380 | -0.329 | -0.0822 | 0.540 | 0.578 | 0000092380 | 0001525221 | 0001779128 |
| 8 | DepreciationDepletionAndAmortization | -0.0568 | -0.0373 | 0.000204 | 0.0532 | 0.0552 | 0000894081 | 0001819516 | 0001128281 |
| 9 | remainder_Expenses | -1.32 | -1.03 | 0.163 | 0.226 | 0.266 | 0001779128 | 0001525221 | 0000092380 |
| 10 | remainder_Revenues | -0.113 | -0.106 | -0.0140 | 0.275 | 0.309 | 0001670076 | 0001525221 | 0001128281 |
| 11 | remainder_NetIncome | -0.0701 | -0.0411 | 0.00217 | 0.0402 | 0.0546 | 0001128281 | 0001158463 | 0001779128 |
| 12 | remainder_ComprehensiveNetIncome | -0.00731 | -0.00577 | 0.000734 | 0.00365 | 0.00606 | 0001525221 | 0001743907 | 0000027904 |
| yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | Liabilities | -0.262 | -0.208 | -0.0593 | 0.426 | 0.466 | 0001670076 | 0001819516 | 0001128281 |
| 1 | Assets | -0.0755 | -0.0633 | -0.00722 | 0.0714 | 0.0792 | 0000027904 | 0001743907 | 0001498710 |
| 2 | Expenses | -0.479 | -0.287 | 0.00135 | 0.118 | 0.147 | 0001779128 | 0001819516 | 0000894081 |
| 3 | Revenues | -0.113 | -0.106 | -0.0140 | 0.275 | 0.309 | 0001670076 | 0001525221 | 0001128281 |
| 4 | StockholdersEquity | -0.245 | -0.225 | -0.0462 | 0.347 | 0.388 | 0001670076 | 0000894081 | 0001128281 |
| 5 | NetIncome | -0.129 | -0.117 | 0.0369 | 0.139 | 0.209 | 0001498710 | 0000092380 | 0001128281 |
| 6 | ComprehensiveNetIncome | -0.128 | -0.118 | 0.0373 | 0.143 | 0.210 | 0001498710 | 0000092380 | 0001128281 |
| 7 | BaseVar | nan | nan | nan | nan | nan | 0000027904 | 0001498710 | 0000027904 |
| 8 | EconomicCapitalRatiobeforeLimitedLiability | -0.430 | -0.359 | -0.0449 | 0.409 | 0.591 | 0001819516 | 0001525221 | 0001128281 |
| 9 | EconomicCapitalRatio | -0.441 | -0.370 | -0.0561 | 0.398 | 0.580 | 0001819516 | 0001525221 | 0001128281 |
Estimates
| Parameter | Value | Min | Max |
|---|---|---|---|
| PresentValueFactor | 1.0 | 1.0 | 15.0 |
| BalanceFactor | 0.65 | 0.5 | 5.0 |
| OCIFactor | 0.5 | 0.5 | 1.0 |
| HiddenReservesFactor | 0.0 | 0.0 | 1.0 |
| LLPO_stddev | 0.56 | 0.02 | 10.0 |
Stock Table
| Adjusted stock price | Split | Original stock price (Adjusted stock price * Split) |
Outstanding shares | Market cap (Original stock price * Outstanding shares) |
obs_EconomicCapitalRatio | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | Name | Name_short | Identifier | Year | ||||||
| 0000004515 | American Airlines INC | America | nan | 2010 | nan | nan | nan | nan | nan | nan |
| 2011 | nan | nan | nan | nan | nan | nan | ||||
| 2012 | nan | nan | nan | nan | nan | nan | ||||
| 0000006201 | American Airlines Group Inc | America | AAL | 2010 | 9.5200 | 1.0000 | 9.5200 | nan | nan | nan |
| 2011 | 5.3400 | 1.0000 | 5.3400 | 335,227,024.0 | 1,790,112,308.16 | 0.1102 | ||||
| 2012 | 12.5200 | 1.0000 | 12.5200 | 335,271,557.0 | 4,197,599,893.64 | 0.2558 | ||||
| 2013 | 24.6300 | 1.0000 | 24.6300 | 335,598,131.0 | 8,265,781,966.53 | 0.1894 | ||||
| 2014 | 48.4500 | 1.0000 | 48.4500 | 717,263,563.0 | 34,751,419,627.35 | 0.8127 | ||||
| 2015 | 40.9500 | 1.0000 | 40.9500 | 630,325,539.0 | 25,811,830,822.05 | 0.5661 | ||||
| 2016 | 46.9000 | 1.0000 | 46.9000 | 518,125,156.0 | 24,300,069,816.40 | 0.4920 | ||||
| 2017 | 50.8900 | 1.0000 | 50.8900 | 478,499,073.0 | 24,350,817,824.97 | 0.4926 | ||||
| 2018 | 31.5300 | 1.0000 | 31.5300 | 460,581,463.0 | 14,522,133,528.39 | 0.2394 | ||||
| 2019 | 28.5100 | 1.0000 | 28.5100 | 438,057,971.0 | 12,489,032,753.21 | 0.2080 | ||||
| 2020 | 15.9700 | 1.0000 | 15.9700 | 508,631,777.0 | 8,122,849,478.69 | 0.1242 | ||||
| 0000027904 | Delta AIR Lines INC | Delta A | DAL | 2010 | 10.8600 | 1.0000 | 10.8600 | nan | nan | nan |
| 2011 | 7.2600 | 1.0000 | 7.2600 | 847,144,480.0 | 6,150,268,924.80 | 0.1391 | ||||
| 2013 | 24.0300 | 1.0000 | 24.0300 | 855,545,884.0 | 20,558,767,592.52 | 0.4429 | ||||
| 2014 | 42.0700 | 1.0000 | 42.0700 | 836,941,362.0 | 35,210,123,099.34 | 0.7083 | ||||
| 2015 | 45.9200 | 1.0000 | 45.9200 | 786,473,621.0 | 36,114,868,676.32 | 0.7570 | ||||
| 2016 | 45.2600 | 1.0000 | 45.2600 | 736,384,650.0 | 33,328,769,259.00 | 0.7387 | ||||
| 2017 | 51.8000 | 1.0000 | 51.8000 | 712,973,139.0 | 36,932,008,600.20 | 0.7971 | ||||
| 2018 | 47.7700 | 1.0000 | 47.7700 | 685,618,701.0 | 32,752,005,346.77 | 0.6131 | ||||
| 2019 | 57.4000 | 1.0000 | 57.4000 | 646,742,854.0 | 37,123,039,819.60 | 0.6530 | ||||
| 2020 | 39.3500 | 1.0000 | 39.3500 | 637,734,301.0 | 25,094,844,744.35 | 0.3523 | ||||
| 2021 | 38.2500 | 1.0000 | 38.2500 | 640,013,818.0 | 24,480,528,538.50 | 0.3472 | ||||
| 2022 | 32.2300 | 1.0000 | 32.2300 | 641,188,362.0 | 20,665,500,907.26 | 0.2995 | ||||
| 2023 | 40.2900 | 1.0000 | 40.2900 | 643,463,433.0 | 25,925,141,715.57 | 0.3807 | ||||
| 2024 | 60.5400 | 1.0000 | 60.5400 | 645,281,221.0 | 39,065,325,119.34 | 0.5769 | ||||
| 0000073887 | Bristow Group Inc | Bristow | nan | 2010 | nan | nan | nan | nan | nan | nan |
| 2011 | nan | nan | nan | 36,161,521.0 | nan | nan | ||||
| 2012 | nan | nan | nan | 35,766,934.0 | nan | nan | ||||
| 2013 | nan | nan | nan | 36,622,619.0 | nan | nan | ||||
| 2014 | nan | nan | nan | 35,158,196.0 | nan | nan | ||||
| 2015 | nan | nan | nan | nan | nan | nan | ||||
| 0000092380 | Southwest Airlines CO | Southwe | LUV | 2010 | 11.3300 | 1.0000 | 11.3300 | nan | nan | nan |
| 2011 | 7.4300 | 1.0000 | 7.4300 | 772,906,217.0 | 5,742,693,192.31 | 0.5080 | ||||
| 2012 | 9.1200 | 1.0000 | 9.1200 | 728,096,579.0 | 6,640,240,800.48 | 0.5715 | ||||
| 2013 | 16.6800 | 1.0000 | 16.6800 | 696,720,541.0 | 11,621,298,623.88 | 0.9287 | ||||
| 2014 | 36.9800 | 1.0000 | 36.9800 | 678,744,363.0 | 25,099,966,543.74 | 1.9217 | ||||
| 2015 | 39.0400 | 1.0000 | 39.0400 | 650,355,108.0 | 25,389,863,416.32 | 1.7682 | ||||
| 2016 | 45.5800 | 1.0000 | 45.5800 | 615,597,738.0 | 28,058,944,898.04 | 1.8625 | ||||
| 2017 | 60.2400 | 1.0000 | 60.2400 | 593,387,660.0 | 35,745,672,638.40 | 2.2331 | ||||
| 2021 | 39.2900 | 1.0000 | 39.2900 | 591,919,907.0 | 23,256,533,146.03 | 1.0227 | ||||
| 2022 | 33.6200 | 1.0000 | 33.6200 | 593,752,004.0 | 19,961,942,374.48 | 0.8726 | ||||
| 2023 | 28.1900 | 1.0000 | 28.1900 | 595,633,723.0 | 16,790,914,651.37 | 0.6889 | ||||
| 2024 | 33.2000 | 1.0000 | 33.2000 | 598,456,459.0 | 19,868,754,438.80 | 0.8634 | ||||
| 0000100517 | United Airlines Holdings Inc | United | UAL | 2010 | 23.9100 | 1.0000 | 23.9100 | nan | nan | nan |
| 2011 | 20.0600 | 1.0000 | 20.0600 | nan | nan | nan | ||||
| 2013 | 37.3100 | 1.0000 | 37.3100 | 361,871,592.0 | 13,501,429,097.52 | 0.4521 | ||||
| 2014 | 64.5900 | 1.0000 | 64.5900 | 369,070,761.0 | 23,838,280,452.99 | 0.9562 | ||||
| 2015 | 58.0200 | 1.0000 | 58.0200 | 372,810,266.0 | 21,630,451,633.32 | 0.8121 | ||||
| 2016 | 74.4500 | 1.0000 | 74.4500 | 317,285,583.0 | 23,621,911,654.35 | 0.9012 | ||||
| 2017 | 67.1900 | 1.0000 | 67.1900 | 296,252,435.0 | 19,905,201,107.65 | 0.7237 | ||||
| 2018 | 83.7700 | 1.0000 | 83.7700 | 272,464,412.0 | 22,824,343,793.24 | 0.7869 | ||||
| 2019 | 89.1900 | 1.0000 | 89.1900 | 253,043,650.0 | 22,568,963,143.50 | 0.6682 | ||||
| 2020 | 43.9900 | 1.0000 | 43.9900 | 290,990,973.0 | 12,800,692,902.27 | 0.3542 | ||||
| 2021 | 44.2800 | 1.0000 | 44.2800 | 323,806,517.0 | 14,338,152,572.76 | 0.3316 | ||||
| 0000230211 | Federal Express CORP | Federal | nan | 2011 | nan | nan | nan | nan | nan | nan |
| 2012 | nan | nan | nan | nan | nan | nan | ||||
| 2013 | nan | nan | nan | nan | nan | nan | ||||
| 2014 | nan | nan | nan | nan | nan | nan | ||||
| 0000350403 | PHI Group Inc DE | PHI Gro | nan | 2011 | nan | nan | nan | 2,852,616.0 | nan | nan |
| 2012 | nan | nan | nan | nan | nan | nan | ||||
| 2013 | nan | nan | nan | nan | nan | nan | ||||
| 2015 | nan | nan | nan | nan | nan | nan | ||||
| 2016 | nan | nan | nan | nan | nan | nan | ||||
| 2017 | nan | nan | nan | nan | nan | nan | ||||
| 2018 | nan | nan | nan | nan | nan | nan | ||||
| 0000353184 | AIR T INC | AIR T I | AIRT | 2013 | 7.6400 | 1.5000 | 11.4600 | 2,446,286.0 | 28,034,437.56 | 1.2762 |
| 2014 | 16.5500 | 1.5000 | 24.8300 | 2,355,028.0 | 58,475,345.24 | 2.5282 | ||||
| 2015 | 15.7200 | 1.5000 | 23.5800 | 2,372,527.0 | 55,944,186.66 | 2.1637 | ||||
| 2016 | 15.2400 | 1.5000 | 22.8600 | 2,042,789.0 | 46,698,156.54 | 1.3531 | ||||
| 2018 | 17.8000 | 1.5000 | 26.7000 | 2,029,614.0 | 54,190,693.80 | 0.6450 | ||||
| 2020 | 15.1500 | 1.0000 | 15.1500 | 2,881,853.0 | 43,660,072.95 | 0.3213 | ||||
| 2021 | 24.4900 | 1.0000 | 24.4900 | 2,881,853.0 | 70,576,579.97 | 0.5426 | ||||
| 0000701345 | US Airways Group INC | US Airw | nan | 2011 | nan | nan | nan | 162,112,185.0 | nan | nan |
| 2012 | nan | nan | nan | 162,136,198.0 | nan | nan | ||||
| 0000810332 | 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 | nan | 2012 | nan | nan | nan | 126,202,256.0 | nan | nan |
| 2013 | nan | nan | nan | 273,763,024.0 | nan | nan | ||||
| 0000869187 | Baltia AIR Lines INC | Baltia | nan | 2014 | nan | nan | nan | 5,244,875,520.0 | nan | nan |
| 0000894081 | Air Transport Services Group Inc | Air Tra | ATSG | 2011 | nan | nan | nan | 64,069,154.0 | nan | nan |
| 2024 | nan | nan | nan | 65,759,904.0 | nan | nan | ||||
| 0000899394 | Harbor Diversified INC | Harbor | 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 | ||||
| 0000948846 | Airtran Holdings INC | Airtran | nan | 2010 | nan | nan | nan | nan | nan | nan |
| 0001048911 | Fedex CORP | Fedex C | FDX | 2010 | 78.3300 | 1.0000 | 78.3300 | nan | nan | nan |
| 2011 | 71.4000 | 1.0000 | 71.4000 | 314,484,094.0 | 22,454,164,311.60 | 1.3917 | ||||
| 2012 | 78.5300 | 1.0000 | 78.5300 | 314,461,506.0 | 24,694,662,066.18 | 1.4000 | ||||
| 2013 | 122.1000 | 1.0000 | 122.1000 | 312,228,182.0 | 38,123,061,022.20 | 1.9392 | ||||
| 2014 | 150.9600 | 1.0000 | 150.9600 | 283,312,620.0 | 42,768,873,115.20 | 2.2286 | ||||
| 2015 | 129.1800 | 1.0000 | 129.1800 | 275,615,246.0 | 35,603,977,478.28 | 1.6760 | ||||
| 2016 | 167.2700 | 1.0000 | 167.2700 | 266,509,290.0 | 44,579,008,938.30 | 1.6521 | ||||
| 2017 | 220.1000 | 1.0000 | 220.1000 | 267,889,623.0 | 58,962,506,022.30 | 2.0883 | ||||
| 2018 | 143.0900 | 1.0000 | 143.0900 | 261,043,625.0 | 37,352,732,301.25 | 1.2058 | ||||
| 2019 | 136.6900 | 1.0000 | 136.6900 | 261,119,074.0 | 35,692,366,225.06 | 1.1257 | ||||
| 2020 | 247.8800 | 1.0000 | 247.8800 | 265,070,592.0 | 65,705,698,344.96 | 1.5666 | ||||
| 2021 | 236.9300 | 1.0000 | 236.9300 | 264,969,342.0 | 62,779,186,200.06 | 1.3020 | ||||
| 2022 | 164.1900 | 1.0000 | 164.1900 | 252,397,140.0 | 41,441,086,416.60 | 0.8266 | ||||
| 0001128281 | Saker Aviation Services Inc | Saker A | SKAS | 2012 | 2.1300 | 0.0330 | 0.0700 | 33,040,422.0 | 2,312,829.54 | 0.3849 |
| 2014 | 2.2000 | 0.0330 | 0.0700 | 33,107,610.0 | 2,317,532.70 | 0.4693 | ||||
| 2015 | 1.6000 | 0.0330 | 0.0500 | 33,107,610.0 | 1,655,380.50 | 0.4073 | ||||
| 2016 | 3.1800 | 0.0330 | 0.1000 | 33,157,610.0 | 3,315,761.00 | 0.7648 | ||||
| 2017 | 3.0600 | 0.0330 | 0.1000 | 33,422,995.0 | 3,342,299.50 | 0.8524 | ||||
| 2018 | 2.2100 | 0.0330 | 0.0700 | 30,195,034.0 | 2,113,652.38 | 0.6000 | ||||
| 2019 | 5.6800 | 1.0000 | 5.6800 | 1,013,033.0 | 5,754,027.44 | 1.2865 | ||||
| 2021 | 2.5500 | 1.0000 | 2.5500 | 1,028,863.0 | 2,623,600.65 | 0.7793 | ||||
| 2022 | 5.6000 | 1.0000 | 5.6000 | 976,330.0 | 5,467,448.00 | 1.3595 | ||||
| 2023 | 7.8200 | 1.0000 | 7.8200 | 976,330.0 | 7,634,900.60 | 1.1835 | ||||
| 2024 | 7.7900 | 1.0000 | 7.7900 | 989,994.0 | 7,712,053.26 | 1.2756 | ||||
| 0001135185 | Atlas AIR Worldwide Holdings INC | Atlas A | nan | 2011 | nan | nan | nan | 26,302,167.0 | nan | nan |
| 2012 | nan | nan | nan | 26,443,441.0 | nan | nan | ||||
| 2013 | nan | nan | nan | 25,038,629.0 | nan | nan | ||||
| 2014 | nan | nan | nan | 24,805,297.0 | nan | nan | ||||
| 2015 | nan | nan | nan | 24,631,001.0 | nan | nan | ||||
| 2016 | nan | nan | nan | 25,009,609.0 | nan | nan | ||||
| 2017 | nan | nan | nan | 25,283,100.0 | nan | nan | ||||
| 2018 | nan | nan | nan | 25,590,293.0 | nan | nan | ||||
| 2019 | nan | nan | nan | 25,870,876.0 | nan | nan | ||||
| 2020 | nan | nan | nan | 27,517,297.0 | nan | nan | ||||
| 2021 | nan | nan | nan | 29,028,291.0 | nan | nan | ||||
| 2022 | nan | nan | nan | 28,364,198.0 | nan | nan | ||||
| 0001158463 | Jetblue Airways CORP | Jetblue | JBLU | 2010 | 6.6300 | 1.0000 | 6.6300 | nan | nan | nan |
| 2011 | 5.3100 | 1.0000 | 5.3100 | 297,160,580.0 | 1,577,922,679.80 | 0.3717 | ||||
| 2012 | 5.7400 | 1.0000 | 5.7400 | 284,298,140.0 | 1,631,871,323.60 | 0.3761 | ||||
| 2013 | 8.5500 | 1.0000 | 8.5500 | 282,338,879.0 | 2,413,997,415.45 | 0.5231 | ||||
| 2014 | 15.4500 | 1.0000 | 15.4500 | 291,811,585.0 | 4,508,488,988.25 | 0.9225 | ||||
| 2015 | 23.3000 | 1.0000 | 23.3000 | 315,060,521.0 | 7,340,910,139.30 | 1.3426 | ||||
| 2016 | 22.2800 | 1.0000 | 22.2800 | 323,732,696.0 | 7,212,764,466.88 | 1.2316 | ||||
| 2017 | 22.3900 | 1.0000 | 22.3900 | 320,646,948.0 | 7,179,285,165.72 | 1.1790 | ||||
| 2018 | 16.0600 | 1.0000 | 16.0600 | 304,786,233.0 | 4,894,866,901.98 | 0.7624 | ||||
| 2019 | 18.9300 | 1.0000 | 18.9300 | 288,694,046.0 | 5,464,978,290.78 | 0.7496 | ||||
| 2020 | 14.4500 | 1.0000 | 14.4500 | 272,483,649.0 | 3,937,388,728.05 | 0.4897 | ||||
| 2021 | 14.4500 | 1.0000 | 14.4500 | 318,030,520.0 | 4,595,541,014.00 | 0.5388 | ||||
| 2022 | 6.4600 | 1.0000 | 6.4600 | 323,877,614.0 | 2,092,249,386.44 | 0.2494 | ||||
| 2023 | 5.7100 | 1.0000 | 5.7100 | 333,289,326.0 | 1,903,082,051.46 | 0.2177 | ||||
| 2024 | 7.7400 | 1.0000 | 7.7400 | 346,876,706.0 | 2,684,825,704.44 | 0.2591 | ||||
| 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 | ||||
| 0001166291 | Pinnacle Airlines CORP | Pinnacl | nan | 2011 | nan | nan | nan | nan | nan | nan |
| 0001172222 | Hawaiian Holdings INC | Hawaiia | nan | 2011 | nan | nan | nan | 50,712,907.0 | nan | nan |
| 2012 | nan | nan | nan | 51,388,041.0 | nan | nan | ||||
| 2014 | nan | nan | nan | 54,023,742.0 | nan | nan | ||||
| 2015 | nan | nan | nan | 53,214,218.0 | nan | nan | ||||
| 2016 | nan | nan | nan | 53,426,475.0 | nan | nan | ||||
| 2017 | nan | nan | nan | 52,471,736.0 | nan | nan | ||||
| 2018 | nan | nan | nan | 49,403,496.0 | nan | nan | ||||
| 2019 | nan | nan | nan | 46,591,737.0 | nan | nan | ||||
| 2020 | nan | nan | nan | 46,003,751.0 | nan | nan | ||||
| 2021 | nan | nan | nan | 51,212,761.0 | nan | nan | ||||
| 2022 | nan | nan | nan | 51,411,336.0 | nan | nan | ||||
| 0001498710 | Spirit Aviation Holdings Inc | Spirit | FLYY | 2011 | nan | 1.0000 | nan | 72,530,256.0 | nan | nan |
| 2012 | nan | 1.0000 | nan | nan | nan | nan | ||||
| 2013 | nan | 1.0000 | nan | 72,647,167.0 | nan | nan | ||||
| 2014 | nan | 1.0000 | nan | 72,766,894.0 | nan | nan | ||||
| 2015 | nan | 1.0000 | nan | 71,539,630.0 | nan | nan | ||||
| 2016 | nan | 1.0000 | nan | 69,322,496.0 | nan | nan | ||||
| 2017 | nan | 1.0000 | nan | 69,373,154.0 | nan | nan | ||||
| 2018 | nan | 1.0000 | nan | 68,264,513.0 | nan | nan | ||||
| 2019 | nan | 1.0000 | nan | 68,448,433.0 | nan | nan | ||||
| 2020 | nan | 1.0000 | nan | 97,678,265.0 | nan | nan | ||||
| 2021 | nan | 1.0000 | nan | 108,405,182.0 | nan | nan | ||||
| 2022 | nan | 1.0000 | nan | 108,857,162.0 | nan | nan | ||||
| 2023 | nan | 1.0000 | nan | 109,167,560.0 | nan | nan | ||||
| 2024 | nan | 1.0000 | nan | 109,523,815.0 | nan | nan | ||||
| 0001514226 | Delta Tucker Holdings Inc | Delta T | nan | 2011 | nan | nan | nan | nan | nan | nan |
| 2012 | nan | nan | nan | nan | nan | nan | ||||
| 0001525221 | Bristow Group Inc | Bristow | VTOL | 2013 | 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 | ||||
| 2024 | 33.3600 | 1.0000 | 33.3600 | 28,628,000.0 | 955,030,080.00 | 0.5686 | ||||
| 0001539429 | CHC Helicopter S A | CHC Hel | nan | 2012 | nan | nan | nan | nan | nan | nan |
| 0001614436 | Virgin America Inc | Virgin | nan | 2015 | nan | nan | nan | nan | nan | nan |
| 0001670076 | Frontier Group Holdings Inc | Frontie | ULCC | 2021 | 13.9200 | 1.0000 | 13.9200 | 216,012,632.0 | 3,006,895,837.44 | 0.7574 |
| 2022 | 10.5700 | 1.0000 | 10.5700 | 217,763,933.0 | 2,301,764,771.81 | 0.5423 | ||||
| 2023 | 5.4400 | 1.0000 | 5.4400 | 221,063,721.0 | 1,202,586,642.24 | 0.2537 | ||||
| 2024 | 7.1100 | 1.0000 | 7.1100 | 225,372,311.0 | 1,602,397,131.21 | 0.2737 | ||||
| 0001743907 | Sun Country Airlines Holdings Inc | Sun Cou | SNCY | 2021 | 27.0800 | 1.0000 | 27.0800 | 57,872,452.0 | 1,567,186,000.16 | 1.3832 |
| 2022 | 16.0900 | 1.0000 | 16.0900 | 57,325,238.0 | 922,363,079.42 | 0.7217 | ||||
| 2023 | 16.0700 | 1.0000 | 16.0700 | 53,291,001.0 | 856,386,386.07 | 0.6267 | ||||
| 2024 | 14.9200 | 1.0000 | 14.9200 | 53,157,964.0 | 793,116,822.88 | 0.5897 | ||||
| 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 | ||||
| 2024 | 4.1000 | 1.0000 | 4.1000 | 78,314,023.0 | 321,087,494.30 | 2.2037 | ||||
| 0001819516 | Wheels Up Experience Inc | Wheels | UP | 2021 | 44.7000 | 0.1000 | 4.4700 | 245,740,164.0 | 1,098,458,533.08 | 0.6810 |
| 2022 | 10.3500 | 0.1000 | 1.0300 | 247,502,983.0 | 254,928,072.49 | 0.1425 | ||||
| 2023 | 2.9600 | 1.0000 | 2.9600 | 166,812,505.0 | 493,765,014.80 | 0.3900 | ||||
| 2024 | 1.7500 | 1.0000 | 1.7500 | 697,811,664.0 | 1,221,170,412.00 | 0.9722 |