Ranks across the years
name | name_short | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2016-val | 2017-val | 2018-val | 2019-val | 2020-val | 2021-val | 2022-val | 2016->2017 | 2017->2018 | 2018->2019 | 2019->2020 | 2020->2021 | 2021->2022 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0000906163 | NVR INC | NVR INC | 11 | 6 | 1 | 1 | 2 | 1 | 1 | 100.31000 | 113.49400 | 574.28600 | 527.0660 | 351.30900 | 385.4620 | 498.44000 | -5 | -5 | 0 | 1 | -1 | 0 |
0001576940 | Century Communities Inc. | Century | 19 | 23 | 24 | 18 | 18 | 2 | 2 | 72.35360 | 60.19120 | 56.02840 | 63.6380 | 73.63060 | 292.5270 | 311.42700 | 4 | 1 | -6 | 0 | -16 | 0 |
0000773141 | M.D.C. HOLDINGS INC. | M.D.C. | 22 | 22 | NaN | NaN | 3 | 3 | 3 | 67.35360 | 65.08450 | NaN | NaN | 293.73500 | 292.1730 | 308.06800 | 0 | NaN | NaN | NaN | 0 | 0 |
0000822416 | PULTEGROUP INC MI | PULTEGR | NaN | NaN | NaN | NaN | 4 | 4 | 4 | NaN | NaN | NaN | NaN | 247.73700 | 280.0800 | 303.90500 | NaN | NaN | NaN | NaN | 0 | 0 |
0001561680 | Tri Pointe Homes Inc. | Tri Poi | NaN | NaN | NaN | NaN | 5 | 5 | 5 | NaN | NaN | NaN | NaN | 232.58200 | 257.2650 | 269.47600 | NaN | NaN | NaN | NaN | 0 | 0 |
0000080035 | Preformed Line Products Co | Preform | 2 | 2 | 2 | 2 | 7 | 6 | 6 | 156.44500 | 155.42600 | 151.59600 | 153.5770 | 145.47600 | 147.5110 | 157.30300 | 0 | 0 | 0 | 5 | -1 | 0 |
0001373670 | Green Brick Partners Inc. | Green B | 4 | 5 | 7 | 7 | 11 | 11 | 7 | 135.72000 | 120.71900 | 112.18300 | 109.6340 | 130.52900 | 128.9770 | 147.82600 | 1 | 2 | 0 | 4 | 0 | -4 |
0000882184 | HORTON D R INC DE | HORTON | NaN | NaN | 5 | 5 | 12 | 10 | 8 | NaN | NaN | 121.53500 | 124.1780 | 124.89900 | 134.5350 | 143.78700 | NaN | NaN | 0 | 7 | -2 | -2 |
0000052988 | Jacobs Engineering Group Inc. | Jacobs | 5 | 4 | 4 | NaN | 9 | 8 | 9 | 128.00700 | 127.61400 | 123.31500 | NaN | 134.74000 | 138.7700 | 139.11500 | -1 | 0 | NaN | NaN | -1 | 1 |
0001488139 | Ameresco Inc. | Ameresc | 6 | 3 | 3 | 4 | 8 | 7 | 10 | 127.70900 | 142.32300 | 145.72200 | 130.2840 | 137.62700 | 140.0860 | 121.56700 | -3 | 0 | 1 | 4 | -1 | 3 |
0000799292 | M I HOMES INC. | M I HOM | 25 | 26 | 19 | 12 | 16 | 15 | 11 | 61.50940 | 58.35210 | 65.00390 | 75.9202 | 82.19130 | 93.7248 | 107.34900 | 1 | -7 | -7 | 4 | -1 | -4 |
0001562476 | Taylor Morrison Home Corp | Taylor | 17 | 12 | NaN | 14 | 20 | 20 | 12 | 75.91090 | 81.88710 | NaN | 74.9562 | 71.12520 | 75.4630 | 103.78800 | -5 | NaN | NaN | 6 | 0 | -8 |
0000861459 | GRANITE CONSTRUCTION INC | GRANITE | 7 | 8 | 6 | NaN | 19 | 17 | 13 | 116.77000 | 106.84700 | 119.96800 | NaN | 72.26380 | 81.4486 | 102.33300 | 1 | -2 | NaN | NaN | -2 | -4 |
0001580670 | LGI Homes Inc. | LGI Hom | 18 | 13 | 11 | 9 | 10 | 12 | 14 | 75.17550 | 80.96520 | 85.33570 | 91.6285 | 132.79100 | 126.8020 | 94.69190 | -5 | -2 | -2 | 1 | 2 | 2 |
0001682265 | Reliant Holdings Inc. | Reliant | NaN | 40 | 9 | 3 | 1 | 44 | 15 | NaN | -108.69600 | 101.23300 | 140.2750 | 589.25300 | -158.8320 | 91.00090 | NaN | -31 | -6 | -2 | 43 | -29 |
0000794170 | Toll Brothers Inc. | Toll Br | NaN | NaN | NaN | NaN | 24 | 19 | 16 | NaN | NaN | NaN | NaN | 66.14990 | 75.9457 | 88.06870 | NaN | NaN | NaN | NaN | -5 | -3 |
0001633931 | TopBuild Corp | TopBuil | 13 | 9 | 17 | 15 | 17 | 24 | 17 | 91.24440 | 100.65600 | 67.67970 | 72.5029 | 82.09310 | 62.9508 | 77.59160 | -4 | 8 | -2 | 2 | 7 | -7 |
0001721386 | Landsea Homes Corp | Landsea | NaN | NaN | NaN | NaN | 6 | 21 | 18 | NaN | NaN | NaN | NaN | 162.87800 | 74.5766 | 76.94420 | NaN | NaN | NaN | NaN | 15 | -3 |
0001124198 | FLUOR CORP | FLUOR C | 14 | NaN | 10 | 30 | 28 | 34 | 19 | 90.34130 | NaN | 91.61110 | 29.4463 | 56.98820 | 49.1354 | 76.86890 | NaN | NaN | 20 | -2 | 6 | -15 |
0000915840 | BEAZER HOMES USA INC | BEAZER | 32 | 33 | NaN | NaN | 38 | 31 | 20 | 35.40960 | 39.49110 | NaN | NaN | 39.90100 | 54.0307 | 73.03990 | 1 | NaN | NaN | NaN | -7 | -11 |
0000833079 | Meritage Homes CORP | Meritag | 16 | 16 | 30 | 20 | 30 | 27 | 21 | 76.90630 | 73.97140 | 43.18190 | 53.5818 | 55.54790 | 59.6048 | 70.89210 | 0 | 14 | -10 | 10 | -3 | -6 |
0001785493 | Phoenix Plus Corp. | Phoenix | NaN | NaN | NaN | NaN | 33 | 9 | 22 | NaN | NaN | NaN | NaN | 47.24860 | 137.3900 | 67.17140 | NaN | NaN | NaN | NaN | -24 | 13 |
0001035983 | COMFORT SYSTEMS USA INC | COMFORT | 12 | 15 | 12 | 17 | 22 | 30 | 23 | 93.01680 | 75.95950 | 84.03670 | 63.8486 | 66.96390 | 57.7474 | 66.90950 | 3 | -3 | 5 | 5 | 8 | -7 |
0001825088 | Dream Finders Homes Inc. | Dream F | NaN | NaN | NaN | NaN | NaN | 36 | 24 | NaN | NaN | NaN | NaN | NaN | 47.4054 | 62.79740 | NaN | NaN | NaN | NaN | NaN | -12 |
0001048268 | IES Holdings Inc. | IES Hol | 3 | 11 | 18 | 8 | 14 | 16 | 25 | 149.34800 | 86.69180 | 65.60700 | 95.3556 | 84.41270 | 83.2778 | 62.02880 | 8 | 7 | -10 | 6 | 2 | 9 |
0000700923 | MYR GROUP INC. | MYR GRO | 21 | 19 | 20 | 22 | 21 | 18 | 26 | 67.80560 | 70.36490 | 64.39560 | 51.7275 | 67.58590 | 76.6569 | 62.01750 | -2 | 1 | 2 | -1 | -3 | 8 |
0001718227 | Construction Partners Inc. | Constru | NaN | NaN | 8 | 6 | 13 | 22 | 27 | NaN | NaN | 110.73900 | 115.1820 | 103.88700 | 73.9412 | 58.70550 | NaN | NaN | -2 | 7 | 9 | 5 |
0000105634 | EMCOR Group Inc. | EMCOR G | 27 | 21 | 16 | 16 | 29 | 23 | 28 | 58.36410 | 65.85850 | 68.92230 | 68.3217 | 56.22410 | 67.4583 | 58.08540 | -6 | -5 | 0 | 13 | -6 | 5 |
0001580905 | Installed Building Products Inc. | Install | 28 | 31 | 32 | 28 | 34 | 40 | 29 | 56.35180 | 44.02320 | 36.45990 | 36.5331 | 46.35880 | 42.7837 | 58.07750 | 3 | 1 | -4 | 6 | 6 | -11 |
0001050915 | QUANTA SERVICES INC. | QUANTA | 10 | 10 | 14 | 13 | 15 | 29 | 30 | 100.85000 | 95.95330 | 76.69430 | 75.7856 | 82.22710 | 57.7498 | 57.53580 | 0 | 4 | -1 | 2 | 14 | 1 |
0000874238 | Sterling Infrastructure Inc. | Sterlin | 31 | 30 | 25 | 29 | 37 | 38 | 31 | 39.27370 | 44.32510 | 55.80790 | 33.7941 | 40.98100 | 44.6206 | 54.40570 | -1 | -5 | 4 | 8 | 1 | -7 |
0001357971 | Energy Services of America Corp | Energy | 24 | 32 | 21 | NaN | 23 | 14 | 32 | 61.89320 | 43.05200 | 63.95850 | NaN | 66.24140 | 93.7299 | 48.00600 | 8 | -11 | NaN | NaN | -9 | 18 |
0001703956 | Concrete Pumping Holdings Inc. | Concret | NaN | NaN | NaN | NaN | 40 | 42 | 33 | NaN | NaN | NaN | NaN | 32.76940 | 41.5937 | 46.58070 | NaN | NaN | NaN | NaN | 2 | -9 |
0001361538 | Primoris Services Corp | Primori | 26 | 18 | 23 | 24 | 31 | 28 | 34 | 59.45830 | 70.87320 | 57.64640 | 50.7836 | 55.24430 | 57.8438 | 44.48750 | -8 | 5 | 1 | 7 | -3 | 6 |
0001606163 | Limbach Holdings Inc. | Limbach | NaN | 34 | 34 | 33 | 42 | 39 | 35 | NaN | 31.26040 | 19.04090 | 18.6826 | 27.01360 | 44.4821 | 43.46010 | NaN | 0 | -1 | 9 | -3 | -4 |
0001796209 | APi Group Corp | APi Gro | NaN | NaN | NaN | NaN | NaN | 25 | 36 | NaN | NaN | NaN | NaN | NaN | 60.8650 | 42.96120 | NaN | NaN | NaN | NaN | NaN | 11 |
0001357615 | KBR INC. | KBR INC | 35 | 20 | 27 | 25 | 41 | 43 | 37 | 12.73560 | 66.62580 | 53.15030 | 48.2489 | 29.51020 | 35.9169 | 41.11630 | -15 | 7 | -2 | 16 | 2 | -6 |
0001402829 | Orion Group Holdings Inc | Orion G | 23 | 17 | 35 | 27 | 27 | 37 | 38 | 66.55450 | 73.73440 | -3.33544 | 39.9561 | 57.73320 | 45.8442 | 39.89830 | -6 | 18 | -8 | 0 | 10 | 1 |
0001372020 | Great Lakes Dredge & Dock Corp | Great L | 33 | 36 | 33 | 26 | 26 | 26 | 39 | 30.92120 | 24.17150 | 32.72870 | 48.1030 | 58.17070 | 60.3115 | 39.75810 | 3 | -3 | -7 | 0 | 0 | 13 |
0000866273 | MATRIX SERVICE CO | MATRIX | 15 | 14 | 15 | 10 | NaN | NaN | 40 | 88.80100 | 76.34980 | 76.16210 | 87.4402 | NaN | NaN | 38.70940 | -1 | 1 | -5 | NaN | NaN | NaN |
0000015615 | MASTEC INC | MASTEC | NaN | 24 | 28 | 19 | 25 | 32 | 41 | NaN | 59.89010 | 48.71030 | 59.1549 | 59.85510 | 53.1233 | 35.91620 | NaN | 4 | -9 | 6 | 7 | 9 |
0000357294 | HOVNANIAN ENTERPRISES INC | HOVNANI | NaN | NaN | NaN | NaN | NaN | 33 | 42 | NaN | NaN | NaN | NaN | NaN | 51.4886 | 31.54040 | NaN | NaN | NaN | NaN | NaN | 9 |
0000077543 | TUTOR PERINI CORP | TUTOR P | 30 | 27 | 26 | 32 | 36 | 35 | 43 | 52.70110 | 57.63090 | 55.75610 | 22.5011 | 41.21740 | 48.1618 | 29.59200 | -3 | -1 | 6 | 4 | -1 | 8 |
0001784567 | Harbor Custom Development Inc. | Harbor | NaN | NaN | NaN | NaN | 43 | 13 | 44 | NaN | NaN | NaN | NaN | 1.51095 | 95.8899 | 24.81790 | NaN | NaN | NaN | NaN | -30 | 31 |
0001136294 | Williams Industrial Services Group Inc. | William | 36 | 39 | 37 | 31 | 39 | 41 | 45 | 8.79561 | -34.83470 | -28.44590 | 25.7121 | 38.72140 | 41.9802 | 2.59618 | 3 | -2 | -6 | 8 | 2 | 4 |
0001300938 | ABCO Energy Inc. | ABCO En | 40 | 43 | 38 | 34 | 44 | 45 | 46 | -495.14400 | -305.99100 | -213.28100 | -249.9880 | -151.86300 | -172.8090 | -99.73550 | 3 | -5 | -4 | 10 | 1 | 1 |
0000039677 | AV Homes Inc. | AV Home | 8 | 28 | NaN | NaN | NaN | NaN | NaN | 112.33800 | 50.51790 | NaN | NaN | NaN | NaN | NaN | 20 | NaN | NaN | NaN | NaN | NaN |
0000042316 | GOLDFIELD CORP | GOLDFIE | 9 | 7 | 13 | 11 | NaN | NaN | NaN | 103.50700 | 107.70000 | 82.47660 | 80.5916 | NaN | NaN | NaN | -2 | 6 | -2 | NaN | NaN | NaN |
0000067215 | DYCOM INDUSTRIES INC | DYCOM I | 29 | 25 | NaN | NaN | NaN | NaN | NaN | 53.34780 | 59.47770 | NaN | NaN | NaN | NaN | NaN | -4 | NaN | NaN | NaN | NaN | NaN |
0000353020 | Aegion Corp | Aegion | 20 | 29 | 22 | 21 | 32 | NaN | NaN | 68.93300 | 49.02780 | 61.49880 | 53.1444 | 52.34680 | NaN | NaN | 9 | -7 | -1 | 11 | NaN | NaN |
0000814046 | ALP LIQUIDATING TRUST | ALP LIQ | 1 | 1 | NaN | NaN | NaN | NaN | NaN | 156.69100 | 170.82600 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN | NaN |
0001027884 | CHICAGO BRIDGE & IRON CO N V | CHICAGO | 34 | 38 | NaN | NaN | NaN | NaN | NaN | 14.84250 | -34.47250 | NaN | NaN | NaN | NaN | NaN | 4 | NaN | NaN | NaN | NaN | NaN |
0001425565 | Real Goods Solar Inc. | Real Go | 38 | 41 | 40 | NaN | NaN | NaN | NaN | -298.69600 | -197.69400 | -519.31700 | NaN | NaN | NaN | NaN | 3 | -1 | NaN | NaN | NaN | NaN |
0001539551 | SPORTS FIELD HOLDINGS INC. | SPORTS | 39 | 42 | 39 | NaN | NaN | NaN | NaN | -382.10700 | -235.06200 | -287.66800 | NaN | NaN | NaN | NaN | 3 | -3 | NaN | NaN | NaN | NaN |
0001634424 | PowerComm Holdings Inc. | PowerCo | 37 | 35 | 29 | NaN | NaN | NaN | NaN | -127.92100 | 30.96790 | 47.32570 | NaN | NaN | NaN | NaN | -2 | -6 | NaN | NaN | NaN | NaN |
0001392363 | China Advanced Construction Materials Group Inc | China A | NaN | 37 | 36 | NaN | NaN | NaN | NaN | NaN | -6.39101 | -3.60858 | NaN | NaN | NaN | NaN | NaN | -1 | NaN | NaN | NaN | NaN |
0001723866 | Select Interior Concepts Inc. | Select | NaN | NaN | 31 | 23 | 35 | NaN | NaN | NaN | NaN | 42.79630 | 51.2494 | 42.68460 | NaN | NaN | NaN | NaN | -8 | 12 | NaN | NaN |
0001534155 | Ameri Metro Inc. (formerly Yellowwood) | Ameri M | NaN | NaN | NaN | 35 | 45 | 46 | NaN | NaN | NaN | NaN | -269.2660 | -254.22600 | -235.2590 | NaN | NaN | NaN | NaN | 10 | 1 | NaN |
PDF reports
All reports for 2022 are collected in a single PDF for easier review.2016
Logs
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 3 × Ignoring company because Assets is zero | pre-agg | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -3.0286646049001087}
|
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Liabilities 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 | 0 | 0 | 130,025,493 | 2,041,336,850 | 4,982,853,000 | 0000039677 | 0001048268 | 0001027884 |
1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 729,691,900 | 1,287,923,000 | 0000042316 | 0000042316 | 0001027884 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 373,934,100 | 1,387,969,000 | 0000039677 | 0000042316 | 0001562476 |
3 | remainder_Liabilities | 0 | 0 | 23,982,499 | 1,215,068,150 | 1,570,305,000 | 0000052988 | 0000042316 | 0000915840 |
4 | AssetsCurrent | 0 | 0 | 190,761,808 | 2,839,091,700 | 5,610,270,000 | 0000039677 | 0001580905 | 0001124198 |
5 | AssetsNonCurrent | 0 | 0 | 1,892,377 | 522,792,200 | 4,175,879,000 | 0000039677 | 0001361538 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 1,611,918,200 | 3,017,219,000 | 0000042316 | 0000052988 | 0001562476 |
7 | Goodwill | 0 | 0 | 59,813,349 | 1,852,852,900 | 3,416,550,000 | 0000773141 | 0001136294 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 34,477,343 | 541,985,800 | 1,850,436,000 | 0000042316 | 0001373670 | 0001124198 |
9 | remainder_Assets | -3,752,593,000 | -470,060,000 | 95,725,009 | 1,379,363,600 | 2,247,324,000 | 0000052988 | 0001576940 | 0000906163 |
10 | remainder_Expenses | 1,326,160 | 3,389,006 | 885,953,825 | 10,710,722,250 | 18,709,076,000 | 0000814046 | 0001576940 | 0001124198 |
11 | remainder_Revenues | 0 | 346,616 | 929,696,360 | 10,693,787,950 | 19,036,525,000 | 0000773141 | 0001576940 | 0001124198 |
12 | remainder_NetIncome | -51,875,000 | -37,768,250 | -130,474 | 40,766,450 | 661,697,000 | 0000052988 | 0001580670 | 0000906163 |
13 | remainder_ComprehensiveNetIncome | -229,000,000 | -154,988,150 | 0 | 2,604,450 | 21,301,000 | 0001357615 | 0001576940 | 0001050915 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 591,611 | 1,413,857 | 494,898,922 | 3,419,851,450 | 6,278,083,000 | 0000814046 | 0000861459 | 0001027884 |
1 | Assets | 358,232 | 876,537 | 867,118,584 | 7,383,991,900 | 9,216,417,000 | 0001300938 | 0001372020 | 0001124198 |
2 | Expenses | 1,326,160 | 3,389,006 | 885,953,825 | 10,710,722,250 | 18,709,076,000 | 0000814046 | 0001576940 | 0001124198 |
3 | Revenues | 0 | 346,616 | 929,696,360 | 10,693,787,950 | 19,036,525,000 | 0000773141 | 0001576940 | 0001124198 |
4 | StockholdersEquity | -3,557,458 | -554,703 | 462,310,533 | 3,445,586,300 | 5,577,336,000 | 0001539551 | 0001576940 | 0000052988 |
5 | NetIncome | -239,823,000 | -50,062,350 | 28,448,096 | 220,161,700 | 425,262,000 | 0001027884 | 0000353020 | 0000906163 |
6 | ComprehensiveNetIncome | -330,782,440 | -52,876,486 | 27,260,472 | 214,129,752 | 425,262,000 | 0001027884 | 0001361538 | 0000906163 |
7 | BaseVar | 3,632,130 | 7,328,694 | 2,291,150,437 | 22,186,075,155 | 36,800,657,400 | 0001300938 | 0001576940 | 0001124198 |
8 | EconomicCapitalRatio | -4.95 | -3.03 | 0.684 | 1.50 | 1.57 | 0001300938 | 0000353020 | 0000814046 |
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.569 | -0.337 | -0.0153 | 0.333 | 3.83 | 0001027884 | 0000353020 | 0001539551 |
1 | LiabilitiesNonCurrent | -1.03 | -0.598 | 0.0566 | 0.223 | 0.238 | 0001580670 | 0000906163 | 0000866273 |
2 | NotesAndLoansPayable | -0.856 | -0.381 | 0.0471 | 0.0854 | 0.0891 | 0000833079 | 0001633931 | 0000866273 |
3 | remainder_Liabilities | -1.17 | -1.05 | 0.270 | 0.579 | 4.20 | 0000906163 | 0001027884 | 0001300938 |
4 | AssetsCurrent | -0.557 | -0.362 | 0.0758 | 0.366 | 0.764 | 0001634424 | 0001050915 | 0001425565 |
5 | AssetsNonCurrent | -0.202 | -0.193 | -0.0306 | 0.454 | 0.548 | 0001425565 | 0000042316 | 0000067215 |
6 | Inventory | -0.968 | -0.771 | -0.140 | 0.995 | 1.06 | 0001300938 | 0001050915 | 0001580670 |
7 | Goodwill | -0.656 | -0.373 | -0.0228 | 0.296 | 0.623 | 0001300938 | 0001361538 | 0001633931 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.854 | -0.506 | -0.111 | 0.0594 | 4.37 | 0001300938 | 0000105634 | 0000814046 |
9 | remainder_Assets | -1.19 | -0.952 | -0.107 | 0.410 | 1.66 | 0001300938 | 0001576940 | 0000773141 |
10 | remainder_Expenses | -2.28 | -1.07 | -0.0715 | 0.505 | 0.753 | 0001425565 | 0001048268 | 0000906163 |
11 | remainder_Revenues | -1.40 | -0.913 | 0.154 | 1.08 | 1.22 | 0001300938 | 0000077543 | 0001357971 |
12 | remainder_NetIncome | -2.20 | -0.0691 | 0.0191 | 0.0634 | 0.540 | 0001300938 | 0000799292 | 0000906163 |
13 | remainder_ComprehensiveNetIncome | -0.0466 | -0.0216 | 0.00426 | 0.00873 | 0.0131 | 0001357615 | 0000833079 | 0000866273 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.750 | -0.445 | 0.176 | 0.793 | 1.32 | 0000773141 | 0001136294 | 0001300938 |
1 | Assets | -2.85 | -1.55 | -0.107 | 0.667 | 1.19 | 0001300938 | 0000042316 | 0000773141 |
2 | Expenses | -2.28 | -1.07 | -0.0715 | 0.505 | 0.753 | 0001425565 | 0001048268 | 0000906163 |
3 | Revenues | -1.40 | -0.913 | 0.154 | 1.08 | 1.22 | 0001300938 | 0000077543 | 0001357971 |
4 | StockholdersEquity | -2.30 | -1.58 | -0.141 | 0.650 | 1.58 | 0001539551 | 0001048268 | 0000814046 |
5 | NetIncome | -3.68 | -2.28 | 0.206 | 0.445 | 0.843 | 0001300938 | 0001633931 | 0001048268 |
6 | ComprehensiveNetIncome | -3.67 | -2.27 | 0.210 | 0.451 | 0.849 | 0001300938 | 0001633931 | 0001048268 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000039677 | 0001027884 | 0000039677 |
8 | EconomicCapitalRatio | -5.34 | -3.42 | 0.293 | 1.11 | 1.18 | 0001300938 | 0000353020 | 0000814046 |
2017
Logs
error | 3 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 3 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 2 × Ignoring company because Assets is zero | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.8879446203928472}
|
warning | 1 × Similarly named company. Duplicate? | None | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.Absolute xval/yval quantiles
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | LiabilitiesCurrent | 0 | 0 | 125,610,276 | 1,917,046,600 | 5,689,447,000 | 0000039677 | 0001402829 | 0001027884 |
1 | LiabilitiesNonCurrent | 0 | 0 | 0 | 734,991,300 | 1,280,706,000 | 0000042316 | 0000042316 | 0000015615 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 703,122,900 | 1,379,240,000 | 0000015615 | 0000039677 | 0001562476 |
3 | remainder_Liabilities | 0 | 0 | 21,463,697 | 1,347,451,800 | 1,538,555,000 | 0000052988 | 0000042316 | 0000915840 |
4 | AssetsCurrent | 0 | 0 | 191,853,432 | 2,811,367,200 | 3,074,392,000 | 0000039677 | 0001402829 | 0000077543 |
5 | AssetsNonCurrent | 0 | 0 | 580,161 | 475,984,000 | 4,034,768,000 | 0000039677 | 0001136294 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 1,529,983,700 | 2,959,236,000 | 0000015615 | 0000042316 | 0001562476 |
7 | Goodwill | 0 | 0 | 53,815,997 | 2,064,594,000 | 3,342,746,000 | 0000773141 | 0000861459 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 40,340,612 | 567,075,300 | 774,151,000 | 0000042316 | 0000015615 | 0000052988 |
9 | remainder_Assets | -3,766,986,000 | -384,559,800 | 93,485,385 | 1,107,725,700 | 2,321,416,000 | 0000052988 | 0001580670 | 0000906163 |
10 | remainder_Expenses | 901,130 | 2,495,926 | 1,090,955,239 | 8,044,887,900 | 9,736,361,000 | 0000814046 | 0001580905 | 0000052988 |
11 | remainder_Revenues | 0 | 7,035 | 1,133,198,244 | 7,585,632,100 | 10,022,788,000 | 0000773141 | 0001580905 | 0000052988 |
12 | remainder_NetIncome | -48,422,000 | -37,690,500 | -366 | 52,960,300 | 846,911,000 | 0001372020 | 0001682265 | 0000906163 |
13 | remainder_ComprehensiveNetIncome | -85,409,000 | -16,617,800 | 0 | 42,712,900 | 121,000,000 | 0001562476 | 0000799292 | 0001357615 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 101,692 | 1,323,564 | 578,223,862 | 2,625,835,000 | 5,753,218,000 | 0001682265 | 0000039677 | 0001027884 |
1 | Assets | 64,799 | 1,047,363 | 984,061,011 | 5,807,013,100 | 7,380,859,000 | 0001682265 | 0001488139 | 0000052988 |
2 | Expenses | 901,130 | 2,495,926 | 1,090,955,239 | 8,044,887,900 | 9,736,361,000 | 0000814046 | 0001580905 | 0000052988 |
3 | Revenues | 0 | 7,035 | 1,133,198,244 | 7,585,632,100 | 10,022,788,000 | 0000773141 | 0001580905 | 0000052988 |
4 | StockholdersEquity | -5,233,687 | -13,772 | 431,974,486 | 2,282,368,500 | 5,454,632,000 | 0001539551 | 0000039677 | 0000052988 |
5 | NetIncome | -1,424,561,000 | -54,292,100 | 21,171,018 | 345,821,500 | 537,521,000 | 0001027884 | 0000700923 | 0000906163 |
6 | ComprehensiveNetIncome | -1,400,913,480 | -50,780,124 | 21,240,406 | 351,778,420 | 537,521,000 | 0001027884 | 0000700923 | 0000906163 |
7 | BaseVar | 1,994,743 | 6,731,980 | 2,414,823,289 | 17,486,699,910 | 20,490,875,000 | 0001682265 | 0001580905 | 0000052988 |
8 | EconomicCapitalRatio | -3.06 | -1.89 | 0.651 | 1.41 | 1.71 | 0001300938 | 0000773141 | 0000814046 |
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 | -1.13 | -0.338 | 0.0253 | 0.369 | 0.405 | 0001392363 | 0001372020 | 0001539551 |
1 | LiabilitiesNonCurrent | -0.830 | -0.575 | 0.0715 | 0.247 | 0.284 | 0000039677 | 0001392363 | 0001682265 |
2 | NotesAndLoansPayable | -0.953 | -0.642 | 0.0593 | 0.0944 | 0.125 | 0001576940 | 0001580905 | 0001682265 |
3 | remainder_Liabilities | -1.15 | -1.09 | 0.213 | 0.444 | 2.79 | 0000906163 | 0000067215 | 0001300938 |
4 | AssetsCurrent | -1.70 | -0.554 | 0.0575 | 0.476 | 1.32 | 0001682265 | 0001357615 | 0001425565 |
5 | AssetsNonCurrent | -0.459 | -0.126 | -0.0278 | 0.380 | 0.549 | 0001682265 | 0000833079 | 0000067215 |
6 | Inventory | -1.35 | -0.534 | -0.136 | 0.967 | 1.08 | 0001682265 | 0001372020 | 0000833079 |
7 | Goodwill | -1.13 | -0.415 | -0.0190 | 0.292 | 0.579 | 0001682265 | 0001361538 | 0001633931 |
8 | CashAndCashEquivalentsAtCarryingValue | -1.42 | -0.457 | -0.112 | 0.100 | 4.90 | 0001682265 | 0000077543 | 0000814046 |
9 | remainder_Assets | -1.48 | -0.803 | -0.0964 | 0.446 | 1.38 | 0001682265 | 0001048268 | 0000773141 |
10 | remainder_Expenses | -6.75 | -0.798 | -0.127 | 0.491 | 0.755 | 0001682265 | 0001580905 | 0000906163 |
11 | remainder_Revenues | -1.50 | -0.737 | 0.223 | 0.993 | 6.76 | 0001425565 | 0001580670 | 0001682265 |
12 | remainder_NetIncome | -0.710 | -0.128 | 0.00782 | 0.0497 | 0.623 | 0001425565 | 0000799292 | 0000906163 |
13 | remainder_ComprehensiveNetIncome | -0.0245 | -0.00937 | -0.00266 | 0.0291 | 0.0662 | 0001562476 | 0001402829 | 0001136294 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.745 | -0.603 | 0.204 | 0.614 | 0.737 | 0000773141 | 0001539551 | 0000080035 |
1 | Assets | -2.54 | -1.83 | -0.122 | 0.839 | 1.14 | 0001682265 | 0000353020 | 0000773141 |
2 | Expenses | -6.75 | -0.798 | -0.127 | 0.491 | 0.755 | 0001682265 | 0001580905 | 0000906163 |
3 | Revenues | -1.50 | -0.737 | 0.223 | 0.993 | 6.76 | 0001425565 | 0001580670 | 0001682265 |
4 | StockholdersEquity | -5.13 | -2.28 | -0.144 | 0.656 | 1.74 | 0001682265 | 0000915840 | 0000814046 |
5 | NetIncome | -2.47 | -0.708 | 0.176 | 0.322 | 0.435 | 0001425565 | 0001562476 | 0000906163 |
6 | ComprehensiveNetIncome | -2.47 | -0.705 | 0.175 | 0.349 | 0.434 | 0001425565 | 0001488139 | 0000906163 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001048268 | 0000015615 |
8 | EconomicCapitalRatio | -3.49 | -2.32 | 0.219 | 0.976 | 1.28 | 0001300938 | 0000773141 | 0000814046 |
2018
Logs
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 4 × Ignoring company because Assets is zero | pre-agg | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.1699999722832217}
|
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Liabilities 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 | 0 | 0 | 154,426,424 | 2,257,437,300 | 3,552,513,000 | 0000799292 | 0001048268 | 0001124198 |
1 | LiabilitiesNonCurrent | 0 | 0 | 3,268,805 | 1,054,716,550 | 1,476,000,000 | 0000042316 | 0001357971 | 0001357615 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 1,002,677,350 | 3,203,500,000 | 0000015615 | 0001050915 | 0000882184 |
3 | remainder_Liabilities | 0 | 0 | 8,627,563 | 1,064,302,650 | 1,752,200,000 | 0000052988 | 0001718227 | 0000882184 |
4 | AssetsCurrent | 0 | 0 | 210,510,004 | 3,387,628,000 | 5,440,893,000 | 0000799292 | 0000080035 | 0001124198 |
5 | AssetsNonCurrent | 0 | 0 | 3,704,396 | 320,371,700 | 7,631,505,000 | 0000042316 | 0000866273 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 1,892,961,900 | 10,395,000,000 | 0000015615 | 0000042316 | 0000882184 |
7 | Goodwill | 0 | 0 | 68,519,336 | 1,800,952,950 | 6,759,957,000 | 0000833079 | 0001372020 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 44,622,343 | 827,345,100 | 1,764,746,000 | 0000799292 | 0001035983 | 0001124198 |
9 | remainder_Assets | -7,095,609,000 | -233,164,000 | 117,088,550 | 1,244,342,750 | 2,433,685,000 | 0000052988 | 0001580670 | 0000906163 |
10 | remainder_Expenses | 1,417,902 | 9,750,221 | 690,007,316 | 11,032,585,700 | 14,718,238,000 | 0001682265 | 0001488139 | 0000052988 |
11 | remainder_Revenues | 0 | 0 | 832,332,791 | 11,362,084,150 | 16,068,000,000 | 0000833079 | 0001048268 | 0000882184 |
12 | remainder_NetIncome | -93,266,000 | -56,949,600 | -292,795 | 131,153,500 | 481,800,000 | 0000052988 | 0001539551 | 0001124198 |
13 | remainder_ComprehensiveNetIncome | -208,361,000 | -89,193,300 | 0 | 512,042 | 6,492,000 | 0001124198 | 0001539551 | 0000105634 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 165,098 | 4,056,773 | 470,172,103 | 3,474,442,950 | 4,955,700,000 | 0001682265 | 0001372020 | 0000882184 |
1 | Assets | 216,483 | 775,205 | 809,539,465 | 9,100,244,900 | 14,114,600,000 | 0001682265 | 0001580905 | 0000882184 |
2 | Expenses | 1,417,902 | 9,750,221 | 690,007,316 | 11,032,585,700 | 14,718,238,000 | 0001682265 | 0001488139 | 0000052988 |
3 | Revenues | 0 | 0 | 832,332,791 | 11,362,084,150 | 16,068,000,000 | 0000833079 | 0001048268 | 0000882184 |
4 | StockholdersEquity | -8,665,727 | 11,922 | 397,893,820 | 5,551,012,800 | 9,500,102,000 | 0001539551 | 0000353020 | 0000052988 |
5 | NetIncome | -410,133,000 | -44,700,900 | 34,460,004 | 367,615,000 | 6,976,058,000 | 0000833079 | 0001488139 | 0000906163 |
6 | ComprehensiveNetIncome | -410,133,000 | -44,700,900 | 34,455,959 | 357,189,000 | 6,976,058,000 | 0000833079 | 0001488139 | 0000906163 |
7 | BaseVar | 2,531,096 | 18,041,073 | 2,094,937,619 | 23,422,992,955 | 34,182,750,000 | 0001682265 | 0000866273 | 0000882184 |
8 | EconomicCapitalRatio | -5.19 | -2.17 | 0.642 | 1.46 | 5.74 | 0001425565 | 0000700923 | 0000906163 |
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.906 | -0.412 | 0.0772 | 0.681 | 1.54 | 0001392363 | 0001633931 | 0001539551 |
1 | LiabilitiesNonCurrent | -0.922 | -0.611 | 0.0599 | 0.286 | 0.639 | 0001580670 | 0001124198 | 0001682265 |
2 | NotesAndLoansPayable | -0.889 | -0.458 | 0.125 | 0.206 | 0.458 | 0001576940 | 0001488139 | 0001682265 |
3 | remainder_Liabilities | -2.23 | -0.842 | 0.112 | 0.285 | 0.635 | 0000906163 | 0000015615 | 0001682265 |
4 | AssetsCurrent | -0.903 | -0.366 | 0.00572 | 0.790 | 1.54 | 0001300938 | 0000105634 | 0001425565 |
5 | AssetsNonCurrent | -0.209 | -0.124 | -0.0288 | 0.109 | 0.657 | 0001425565 | 0000105634 | 0000052988 |
6 | Inventory | -1.09 | -0.662 | -0.193 | 0.948 | 1.58 | 0001425565 | 0001050915 | 0000833079 |
7 | Goodwill | -0.679 | -0.411 | -0.0163 | 0.393 | 0.532 | 0001425565 | 0001488139 | 0001633931 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.435 | -0.269 | -0.0306 | 0.0810 | 1.81 | 0000906163 | 0000105634 | 0001425565 |
9 | remainder_Assets | -2.79 | -0.798 | -0.0296 | 0.414 | 0.544 | 0000906163 | 0001580905 | 0001372020 |
10 | remainder_Expenses | -2.79 | -1.08 | -0.157 | 0.707 | 2.34 | 0001682265 | 0000015615 | 0000906163 |
11 | remainder_Revenues | -2.78 | -0.768 | 0.249 | 0.991 | 3.49 | 0001425565 | 0000052988 | 0001682265 |
12 | remainder_NetIncome | -0.816 | -0.376 | 0.0254 | 0.110 | 0.132 | 0001300938 | 0000833079 | 0001124198 |
13 | remainder_ComprehensiveNetIncome | -0.0416 | -0.0140 | 0.00479 | 0.00953 | 0.0180 | 0000080035 | 0000906163 | 0001682265 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.945 | -0.588 | 0.217 | 0.773 | 1.50 | 0001576940 | 0001361538 | 0001682265 |
1 | Assets | -2.18 | -0.752 | -0.0869 | 1.02 | 1.30 | 0001300938 | 0001718227 | 0000833079 |
2 | Expenses | -2.79 | -1.08 | -0.157 | 0.707 | 2.34 | 0001682265 | 0000015615 | 0000906163 |
3 | Revenues | -2.78 | -0.768 | 0.249 | 0.991 | 3.49 | 0001425565 | 0000052988 | 0001682265 |
4 | StockholdersEquity | -2.34 | -2.05 | -0.0956 | 0.652 | 0.886 | 0001539551 | 0001357615 | 0001488139 |
5 | NetIncome | -6.18 | -1.16 | 0.107 | 0.312 | 4.95 | 0001425565 | 0001050915 | 0000906163 |
6 | ComprehensiveNetIncome | -6.17 | -1.15 | 0.107 | 0.320 | 4.95 | 0001425565 | 0000700923 | 0000906163 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001124198 | 0000015615 |
8 | EconomicCapitalRatio | -5.69 | -2.67 | 0.140 | 0.958 | 5.24 | 0001425565 | 0000700923 | 0000906163 |
2019
Logs
error | 2 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 4 × Ignoring company because Assets is zero | pre-agg | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × NetIncome node detected by IncomeLoss name heuristic | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.Absolute xval/yval quantiles
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | LiabilitiesCurrent | 0 | 0 | 170,273,779 | 2,388,707,600 | 3,932,061,000 | 0000799292 | 0001402829 | 0001124198 |
1 | LiabilitiesNonCurrent | 0 | 0 | 32,691,320 | 1,474,622,900 | 1,652,000,000 | 0000042316 | 0001136294 | 0001357615 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 1,242,535,200 | 3,399,400,000 | 0000015615 | 0000042316 | 0000882184 |
3 | remainder_Liabilities | 0 | 0 | 35,750,600 | 1,165,853,200 | 1,912,100,000 | 0000080035 | 0001372020 | 0000882184 |
4 | AssetsCurrent | 0 | 0 | 280,022,063 | 3,606,986,000 | 5,516,272,000 | 0000799292 | 0001718227 | 0001124198 |
5 | AssetsNonCurrent | 0 | 0 | 4,939,465 | 296,297,900 | 478,616,000 | 0000799292 | 0001048268 | 0001124198 |
6 | Inventory | 0 | 0 | 0 | 3,117,015,900 | 11,282,000,000 | 0000015615 | 0000077543 | 0000882184 |
7 | Goodwill | 0 | 0 | 77,321,650 | 1,700,748,500 | 2,436,409,000 | 0000833079 | 0001048268 | 0001050915 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 50,803,803 | 946,690,000 | 1,997,199,000 | 0000906163 | 0001035983 | 0001124198 |
9 | remainder_Assets | -475,815,000 | -2,316,159 | 129,177,227 | 1,854,397,500 | 3,809,815,000 | 0001124198 | 0001723866 | 0000906163 |
10 | remainder_Expenses | 1,719,143 | 7,379,608 | 1,067,644,044 | 13,061,395,900 | 16,065,700,000 | 0001682265 | 0000874238 | 0001124198 |
11 | remainder_Revenues | 0 | 0 | 1,214,624,333 | 12,782,912,500 | 17,592,900,000 | 0000833079 | 0000353020 | 0000882184 |
12 | remainder_NetIncome | -63,704,000 | -34,995,300 | -64,796 | 99,850,500 | 164,558,000 | 0000015615 | 0001534155 | 0001124198 |
13 | remainder_ComprehensiveNetIncome | -84,000,000 | -19,116,600 | 0 | 16,144,100 | 194,618,000 | 0001357615 | 0001300938 | 0001124198 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 151,464 | 31,940,157 | 741,001,656 | 4,035,798,000 | 5,311,500,000 | 0001682265 | 0000874238 | 0000882184 |
1 | Assets | 7,396 | 610,147 | 1,100,412,416 | 8,076,165,200 | 15,606,600,000 | 0001534155 | 0001580905 | 0000882184 |
2 | Expenses | 1,719,143 | 7,379,608 | 1,067,644,044 | 13,061,395,900 | 16,065,700,000 | 0001682265 | 0000874238 | 0001124198 |
3 | Revenues | 0 | 0 | 1,214,624,333 | 12,782,912,500 | 17,592,900,000 | 0000833079 | 0000353020 | 0000882184 |
4 | StockholdersEquity | -44,663,807 | -340,071 | 550,126,013 | 4,040,367,200 | 10,295,100,000 | 0001534155 | 0001373670 | 0000882184 |
5 | NetIncome | -1,553,124,000 | -383,733,300 | 40,700,420 | 770,350,500 | 7,216,028,000 | 0001124198 | 0000874238 | 0000906163 |
6 | ComprehensiveNetIncome | -1,451,922,640 | -392,511,524 | 41,639,615 | 784,713,576 | 7,216,028,000 | 0001124198 | 0001488139 | 0000906163 |
7 | BaseVar | 3,062,153 | 22,808,804 | 2,740,901,618 | 27,022,937,840 | 37,450,090,000 | 0001682265 | 0000353020 | 0000882184 |
8 | EconomicCapitalRatio | -2.69 | -0.619 | 0.636 | 1.44 | 5.27 | 0001534155 | 0001576940 | 0000906163 |
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.344 | -0.139 | 0.120 | 1.09 | 5.80 | 0000077543 | 0000866273 | 0001534155 |
1 | LiabilitiesNonCurrent | -0.726 | -0.594 | 0.0408 | 0.439 | 0.843 | 0001580670 | 0000700923 | 0001682265 |
2 | NotesAndLoansPayable | -0.785 | -0.600 | 0.147 | 0.301 | 0.605 | 0001576940 | 0000015615 | 0001682265 |
3 | remainder_Liabilities | -1.75 | -0.583 | 0.181 | 0.460 | 0.879 | 0000906163 | 0001580905 | 0001682265 |
4 | AssetsCurrent | -0.497 | -0.250 | 0.0849 | 0.392 | 0.739 | 0001300938 | 0001361538 | 0000077543 |
5 | AssetsNonCurrent | -0.0290 | -0.0171 | -0.00577 | 0.0385 | 0.0568 | 0001300938 | 0001718227 | 0001136294 |
6 | Inventory | -0.832 | -0.367 | -0.235 | 0.926 | 1.53 | 0001300938 | 0000015615 | 0000833079 |
7 | Goodwill | -0.414 | -0.145 | -0.0235 | 0.302 | 0.471 | 0001300938 | 0001576940 | 0001633931 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.210 | -0.0916 | -0.0188 | 0.137 | 0.201 | 0001300938 | 0000874238 | 0001124198 |
9 | remainder_Assets | -4.71 | -0.299 | -0.0649 | 0.155 | 0.434 | 0000906163 | 0001633931 | 0001488139 |
10 | remainder_Expenses | -3.18 | -0.983 | -0.159 | 0.530 | 2.07 | 0001682265 | 0000015615 | 0000906163 |
11 | remainder_Revenues | -0.930 | -0.759 | 0.191 | 1.35 | 3.43 | 0001534155 | 0000080035 | 0001682265 |
12 | remainder_NetIncome | -0.964 | -0.0380 | 0.0188 | 0.0739 | 0.114 | 0001300938 | 0000906163 | 0001576940 |
13 | remainder_ComprehensiveNetIncome | -0.0160 | -0.00572 | -0.000340 | 0.00642 | 0.0268 | 0001357615 | 0001723866 | 0001124198 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.807 | -0.336 | 0.313 | 1.26 | 3.37 | 0001576940 | 0001373670 | 0001534155 |
1 | Assets | -1.62 | -0.615 | -0.119 | 0.548 | 1.40 | 0001300938 | 0001050915 | 0000833079 |
2 | Expenses | -3.18 | -0.983 | -0.159 | 0.530 | 2.07 | 0001682265 | 0000015615 | 0000906163 |
3 | Revenues | -0.930 | -0.759 | 0.191 | 1.35 | 3.43 | 0001534155 | 0000080035 | 0001682265 |
4 | StockholdersEquity | -2.19 | -1.22 | 0.0144 | 0.739 | 0.901 | 0001534155 | 0001124198 | 0000080035 |
5 | NetIncome | -1.61 | -0.611 | -0.00322 | 0.199 | 4.28 | 0001300938 | 0000042316 | 0000906163 |
6 | ComprehensiveNetIncome | -1.61 | -0.592 | -0.00366 | 0.199 | 4.28 | 0001300938 | 0000105634 | 0000906163 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001136294 | 0000015615 |
8 | EconomicCapitalRatio | -3.34 | -1.26 | -0.00748 | 0.799 | 4.63 | 0001534155 | 0001576940 | 0000906163 |
2020
Logs
warning | 4 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 2 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 2 × Ignoring company because Liabilities is zero | pre-agg | |
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
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 | 0 | 0 | 101,443,300 | 2,542,447,400 | 3,572,037,000 | 0000773141 | 0001723866 | 0001124198 |
1 | LiabilitiesNonCurrent | 0 | 0 | 2,078 | 1,204,365,800 | 2,151,000,000 | 0000052988 | 0001784567 | 0001357615 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 3,091,519,600 | 4,283,300,000 | 0000015615 | 0000052988 | 0000882184 |
3 | remainder_Liabilities | 0 | 0 | 51,312,774 | 2,442,825,600 | 2,674,067,000 | 0000052988 | 0000874238 | 0000906163 |
4 | AssetsCurrent | 0 | 0 | 191,859,400 | 3,982,043,400 | 5,034,009,000 | 0000773141 | 0001723866 | 0001124198 |
5 | AssetsNonCurrent | 0 | 0 | 1,753,136 | 405,141,600 | 7,495,383,000 | 0000773141 | 0001703956 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 7,193,610,000 | 12,237,400,000 | 0000015615 | 0000077543 | 0000882184 |
7 | Goodwill | 0 | 0 | 59,715,514 | 2,242,135,200 | 6,297,431,000 | 0000773141 | 0001488139 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 95,083,259 | 2,545,544,200 | 3,018,500,000 | 0000773141 | 0000353020 | 0000882184 |
9 | remainder_Assets | -6,840,484,000 | -402,109,610 | 162,271,801 | 2,781,063,800 | 3,864,920,000 | 0000052988 | 0001402829 | 0000773141 |
10 | remainder_Expenses | 120,449 | 1,034,117 | 879,292,927 | 12,622,458,400 | 18,023,500,000 | 0001721386 | 0001373670 | 0000882184 |
11 | remainder_Revenues | 0 | 0 | 1,428,405,577 | 13,094,114,400 | 20,311,100,000 | 0000794170 | 0000874238 | 0000882184 |
12 | remainder_NetIncome | -141,147,000 | -33,782,400 | -1,916 | 84,120,000 | 586,901,000 | 0001124198 | 0001682265 | 0000794170 |
13 | remainder_ComprehensiveNetIncome | -117,000,000 | -48,520,600 | 0 | 2,234,800 | 18,674,000 | 0001357615 | 0001723866 | 0000861459 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 58,875 | 3,905,875 | 868,822,953 | 5,337,256,200 | 6,790,800,000 | 0001785493 | 0001580905 | 0000882184 |
1 | Assets | 63,647 | 1,000,084 | 1,757,657,421 | 11,977,545,000 | 18,912,300,000 | 0001534155 | 0001035983 | 0000882184 |
2 | Expenses | 120,449 | 1,034,117 | 879,292,927 | 12,622,458,400 | 18,023,500,000 | 0001721386 | 0001373670 | 0000882184 |
3 | Revenues | 0 | 0 | 1,428,405,577 | 13,094,114,400 | 20,311,100,000 | 0000794170 | 0000874238 | 0000882184 |
4 | StockholdersEquity | -53,318,024 | 220,006 | 696,509,797 | 6,241,486,400 | 12,121,500,000 | 0001534155 | 0001035983 | 0000882184 |
5 | NetIncome | -548,031,000 | -145,142,800 | 56,930,083 | 3,611,935,800 | 9,664,769,000 | 0000833079 | 0001488139 | 0000822416 |
6 | ComprehensiveNetIncome | -548,031,000 | -147,544,416 | 54,525,866 | 3,611,935,800 | 9,664,821,000 | 0000833079 | 0001488139 | 0000822416 |
7 | BaseVar | 1,678,973 | 10,280,614 | 3,599,993,498 | 27,997,943,120 | 43,593,550,000 | 0001785493 | 0001580905 | 0000882184 |
8 | EconomicCapitalRatio | -2.54 | 0.0661 | 0.662 | 2.85 | 5.89 | 0001534155 | 0001357971 | 0001682265 |
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 | -1.79 | -0.236 | 0.0873 | 0.537 | 6.92 | 0001682265 | 0001723866 | 0001534155 |
1 | LiabilitiesNonCurrent | -0.720 | -0.564 | 0.0757 | 0.279 | 0.937 | 0001703956 | 0001402829 | 0001682265 |
2 | NotesAndLoansPayable | -1.02 | -0.658 | 0.166 | 0.272 | 0.876 | 0001561680 | 0000015615 | 0001682265 |
3 | remainder_Liabilities | -1.58 | -1.01 | 0.218 | 0.453 | 0.998 | 0000906163 | 0000015615 | 0001682265 |
4 | AssetsCurrent | -0.379 | -0.243 | 0.0531 | 0.281 | 6.62 | 0001784567 | 0000822416 | 0001785493 |
5 | AssetsNonCurrent | -0.0456 | -0.0413 | -0.0146 | 0.114 | 0.593 | 0001606163 | 0000882184 | 0000052988 |
6 | Inventory | -0.442 | -0.384 | -0.204 | 0.824 | 1.18 | 0001300938 | 0000822416 | 0000833079 |
7 | Goodwill | -0.202 | -0.154 | -0.0217 | 0.403 | 0.656 | 0001300938 | 0001488139 | 0001703956 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.491 | -0.217 | -0.0700 | 0.0796 | 3.92 | 0000906163 | 0001357971 | 0001785493 |
9 | remainder_Assets | -1.25 | -0.487 | -0.0761 | 0.832 | 2.45 | 0000773141 | 0001050915 | 0001721386 |
10 | remainder_Expenses | -1.39 | -1.27 | -0.306 | 1.14 | 1.55 | 0001124198 | 0000799292 | 0001682265 |
11 | remainder_Revenues | -1.13 | -0.771 | 0.270 | 0.952 | 4.18 | 0001785493 | 0000080035 | 0001682265 |
12 | remainder_NetIncome | -0.159 | -0.0921 | -0.0115 | 0.0684 | 0.193 | 0000353020 | 0000105634 | 0001576940 |
13 | remainder_ComprehensiveNetIncome | -0.0189 | -0.00768 | 0.000804 | 0.00252 | 0.0109 | 0001357615 | 0001300938 | 0000861459 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.739 | -0.377 | 0.245 | 0.804 | 2.41 | 0000794170 | 0000799292 | 0001534155 |
1 | Assets | -1.10 | -0.711 | -0.170 | 1.09 | 1.98 | 0001534155 | 0000077543 | 0001682265 |
2 | Expenses | -1.39 | -1.27 | -0.306 | 1.14 | 1.55 | 0001124198 | 0000799292 | 0001682265 |
3 | Revenues | -1.13 | -0.771 | 0.270 | 0.952 | 4.18 | 0001785493 | 0000080035 | 0001682265 |
4 | StockholdersEquity | -2.30 | -1.39 | -0.101 | 0.729 | 1.49 | 0001534155 | 0000861459 | 0001785493 |
5 | NetIncome | -1.58 | -0.640 | -0.216 | 1.90 | 5.70 | 0001785493 | 0000915840 | 0001682265 |
6 | ComprehensiveNetIncome | -1.58 | -0.643 | -0.217 | 1.90 | 5.70 | 0001785493 | 0000077543 | 0001682265 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001300938 | 0000015615 |
8 | EconomicCapitalRatio | -3.44 | -0.831 | -0.235 | 1.95 | 5.00 | 0001534155 | 0001357971 | 0001682265 |
2021
Logs
warning | 4 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 3 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 2 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.101445015523092}
|
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Liabilities 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 | 0 | 0 | 45,481,542 | 3,087,960,750 | 3,904,060,000 | 0000357294 | 0001703956 | 0001124198 |
1 | LiabilitiesNonCurrent | 0 | 0 | 4,796,513 | 1,980,958,250 | 3,894,901,000 | 0000052988 | 0001357971 | 0001050915 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 2,829,969,250 | 5,412,400,000 | 0000015615 | 0001035983 | 0000882184 |
3 | remainder_Liabilities | 0 | 0 | 73,232,512 | 2,819,540,750 | 3,387,300,000 | 0000052988 | 0000700923 | 0000882184 |
4 | AssetsCurrent | 0 | 0 | 64,778,298 | 4,184,544,250 | 5,562,642,000 | 0000357294 | 0001703956 | 0001124198 |
5 | AssetsNonCurrent | 0 | 0 | 1,222,091 | 564,204,750 | 9,987,597,000 | 0000357294 | 0001703956 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 5,058,242,750 | 9,047,569,000 | 0000015615 | 0000080035 | 0000822416 |
7 | Goodwill | 0 | 0 | 65,248,374 | 2,623,713,750 | 8,762,758,000 | 0000357294 | 0001372020 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 111,195,092 | 1,784,797,250 | 3,210,400,000 | 0000357294 | 0001633931 | 0000882184 |
9 | remainder_Assets | -9,423,890,000 | -618,125,250 | 222,488,540 | 4,303,789,500 | 20,642,000,000 | 0000052988 | 0000077543 | 0000882184 |
10 | remainder_Expenses | 467,296 | 3,155,851 | 1,639,865,536 | 12,605,270,750 | 23,620,500,000 | 0001785493 | 0000822416 | 0000882184 |
11 | remainder_Revenues | 0 | 392,803 | 2,641,853,556 | 13,690,214,750 | 27,774,200,000 | 0000833079 | 0000357294 | 0000882184 |
12 | remainder_NetIncome | -254,878,000 | -63,233,250 | 0 | 35,424,000 | 79,438,000 | 0001124198 | 0000906163 | 0000794170 |
13 | remainder_ComprehensiveNetIncome | -39,119,000 | -12,775,738 | 0 | 44,750,750 | 194,000,000 | 0000077543 | 0000357294 | 0001357615 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 106,265 | 10,570,819 | 1,345,967,450 | 6,113,825,250 | 8,799,700,000 | 0001785493 | 0000915840 | 0000882184 |
1 | Assets | 4,848 | 1,117,871 | 2,273,095,092 | 13,228,270,500 | 24,015,900,000 | 0001534155 | 0000357294 | 0000882184 |
2 | Expenses | 467,296 | 3,155,851 | 1,639,865,536 | 12,605,270,750 | 23,620,500,000 | 0001785493 | 0000822416 | 0000882184 |
3 | Revenues | 0 | 392,803 | 2,641,853,556 | 13,690,214,750 | 27,774,200,000 | 0000833079 | 0000357294 | 0000882184 |
4 | StockholdersEquity | -59,094,972 | 358,023 | 950,665,723 | 6,952,250,000 | 15,216,200,000 | 0001534155 | 0001361538 | 0000882184 |
5 | NetIncome | -697,884,000 | -14,944,750 | 100,510,798 | 4,837,595,000 | 12,090,780,000 | 0000833079 | 0001361538 | 0000822416 |
6 | ComprehensiveNetIncome | -697,884,000 | -13,650,980 | 114,680,461 | 4,837,595,000 | 12,090,832,000 | 0000833079 | 0001361538 | 0000822416 |
7 | BaseVar | 1,647,109 | 12,674,537 | 5,629,319,805 | 29,567,023,450 | 57,553,560,000 | 0001785493 | 0001580670 | 0000882184 |
8 | EconomicCapitalRatio | -2.35 | -1.10 | 0.652 | 2.89 | 3.85 | 0001534155 | 0000105634 | 0000906163 |
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.626 | -0.538 | -0.0645 | 0.352 | 0.476 | 0001124198 | 0001136294 | 0000906163 |
1 | LiabilitiesNonCurrent | -0.732 | -0.602 | 0.147 | 0.343 | 0.438 | 0001703956 | 0001784567 | 0000906163 |
2 | NotesAndLoansPayable | -1.05 | -0.596 | 0.0977 | 0.182 | 0.206 | 0001561680 | 0001357615 | 0000906163 |
3 | remainder_Liabilities | -1.23 | -0.819 | 0.304 | 0.603 | 4.73 | 0000773141 | 0000015615 | 0001534155 |
4 | AssetsCurrent | -0.687 | -0.237 | 0.0582 | 0.444 | 3.62 | 0001682265 | 0001050915 | 0001785493 |
5 | AssetsNonCurrent | -0.189 | -0.0396 | -0.0138 | 0.0268 | 0.739 | 0001682265 | 0001373670 | 0000052988 |
6 | Inventory | -1.06 | -0.452 | -0.186 | 0.610 | 1.49 | 0001682265 | 0001050915 | 0000833079 |
7 | Goodwill | -0.726 | -0.152 | -0.0264 | 0.369 | 0.523 | 0001682265 | 0001372020 | 0001703956 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.275 | -0.167 | -0.0621 | 0.125 | 2.19 | 0001300938 | 0000799292 | 0001785493 |
9 | remainder_Assets | -2.26 | -1.05 | -0.0612 | 0.730 | 1.13 | 0000906163 | 0001050915 | 0001784567 |
10 | remainder_Expenses | -1.42 | -1.03 | -0.225 | 1.09 | 1.43 | 0001136294 | 0001050915 | 0000906163 |
11 | remainder_Revenues | -0.887 | -0.732 | 0.0818 | 0.864 | 1.41 | 0001785493 | 0000052988 | 0000906163 |
12 | remainder_NetIncome | -2.86 | -0.0360 | 0.0224 | 0.0721 | 0.338 | 0001682265 | 0001300938 | 0001357971 |
13 | remainder_ComprehensiveNetIncome | -0.0209 | -0.00695 | -0.000669 | 0.00614 | 0.0294 | 0000080035 | 0000357294 | 0001357615 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.438 | -0.292 | 0.115 | 0.765 | 1.84 | 0001703956 | 0001682265 | 0001534155 |
1 | Assets | -2.25 | -0.844 | -0.123 | 0.426 | 1.27 | 0001682265 | 0000015615 | 0000833079 |
2 | Expenses | -1.42 | -1.03 | -0.225 | 1.09 | 1.43 | 0001136294 | 0001050915 | 0000906163 |
3 | Revenues | -0.887 | -0.732 | 0.0818 | 0.864 | 1.41 | 0001785493 | 0000052988 | 0000906163 |
4 | StockholdersEquity | -2.23 | -1.33 | 0.0388 | 0.704 | 1.58 | 0001534155 | 0001718227 | 0001785493 |
5 | NetIncome | -2.17 | -0.617 | -0.243 | 1.92 | 2.86 | 0001682265 | 0001050915 | 0000906163 |
6 | ComprehensiveNetIncome | -2.17 | -0.613 | -0.243 | 1.92 | 2.86 | 0001682265 | 0000015615 | 0000906163 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001136294 | 0000015615 |
8 | EconomicCapitalRatio | -3.18 | -1.93 | -0.175 | 2.06 | 3.03 | 0001534155 | 0000105634 | 0000906163 |
2022
Logs
warning | 4 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 3 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 1 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Liabilities 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 | 0 | 0 | 112,830,248 | 3,186,481,750 | 3,973,713,000 | 0000357294 | 0000080035 | 0001050915 |
1 | LiabilitiesNonCurrent | 0 | 0 | 13,134,345 | 2,362,250,000 | 3,863,944,000 | 0000052988 | 0001357971 | 0001050915 |
2 | NotesAndLoansPayable | 0 | 0 | 0 | 2,144,723,500 | 6,066,900,000 | 0000015615 | 0000077543 | 0000882184 |
3 | remainder_Liabilities | 0 | 0 | 90,479,288 | 2,882,618,000 | 4,498,600,000 | 0000052988 | 0000700923 | 0000882184 |
4 | AssetsCurrent | 0 | 0 | 132,654,283 | 4,506,277,250 | 5,536,070,000 | 0000357294 | 0001372020 | 0001050915 |
5 | AssetsNonCurrent | 0 | 0 | 2,097,639 | 569,341,250 | 9,591,749,000 | 0000357294 | 0001402829 | 0000052988 |
6 | Inventory | 0 | 0 | 0 | 5,117,722,750 | 11,326,017,000 | 0000015615 | 0000874238 | 0000822416 |
7 | Goodwill | 0 | 0 | 74,521,804 | 3,872,335,000 | 8,578,710,000 | 0000357294 | 0001488139 | 0000052988 |
8 | CashAndCashEquivalentsAtCarryingValue | 0 | 0 | 119,620,450 | 1,295,185,250 | 2,540,500,000 | 0000357294 | 0001721386 | 0000882184 |
9 | remainder_Assets | -9,372,513,000 | -23,302,216 | 413,576,400 | 4,662,961,500 | 27,647,100,000 | 0000052988 | 0001357615 | 0000882184 |
10 | remainder_Expenses | 642,581 | 19,415,713 | 2,052,245,920 | 14,053,908,500 | 27,643,700,000 | 0001785493 | 0000915840 | 0000882184 |
11 | remainder_Revenues | 0 | 2,639,479 | 2,965,774,900 | 15,902,452,500 | 33,480,000,000 | 0000833079 | 0000700923 | 0000882184 |
12 | remainder_NetIncome | -82,061,000 | -56,116,500 | 0 | 53,820,750 | 195,100,000 | 0000015615 | 0000799292 | 0000794170 |
13 | remainder_ComprehensiveNetIncome | -267,000,000 | -75,831,500 | 0 | 24,876,000 | 40,787,000 | 0001796209 | 0001682265 | 0001580905 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 66,680 | 20,663,004 | 1,526,826,126 | 6,480,772,500 | 10,565,500,000 | 0001785493 | 0001825088 | 0000882184 |
1 | Assets | 751,246 | 28,311,466 | 2,579,913,516 | 14,361,398,500 | 30,351,100,000 | 0001682265 | 0001035983 | 0000882184 |
2 | Expenses | 642,581 | 19,415,713 | 2,052,245,920 | 14,053,908,500 | 27,643,700,000 | 0001785493 | 0000915840 | 0000882184 |
3 | Revenues | 0 | 2,639,479 | 2,965,774,900 | 15,902,452,500 | 33,480,000,000 | 0000833079 | 0000700923 | 0000882184 |
4 | StockholdersEquity | -1,656,310 | 7,236,456 | 1,110,460,472 | 8,191,033,500 | 19,785,600,000 | 0001300938 | 0001373670 | 0000882184 |
5 | NetIncome | -810,703,000 | -56,438,750 | 119,860,520 | 5,771,299,250 | 14,011,814,000 | 0000833079 | 0001361538 | 0000822416 |
6 | ComprehensiveNetIncome | -810,703,000 | -65,540,380 | 119,434,024 | 5,771,299,250 | 14,011,837,400 | 0000833079 | 0001361538 | 0000822416 |
7 | BaseVar | 1,366,803 | 81,011,814 | 6,297,652,117 | 31,122,278,400 | 69,404,700,000 | 0001785493 | 0000861459 | 0000882184 |
8 | EconomicCapitalRatio | -0.997 | 0.260 | 0.649 | 3.07 | 4.98 | 0001300938 | 0001035983 | 0000906163 |
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.985 | -0.478 | -0.0474 | 0.432 | 0.794 | 0001300938 | 0001372020 | 0000906163 |
1 | LiabilitiesNonCurrent | -0.678 | -0.570 | 0.154 | 0.362 | 0.697 | 0001703956 | 0001048268 | 0001682265 |
2 | NotesAndLoansPayable | -1.04 | -0.488 | 0.100 | 0.176 | 0.359 | 0001561680 | 0000874238 | 0001682265 |
3 | remainder_Liabilities | -1.47 | -1.03 | 0.143 | 0.408 | 0.770 | 0000773141 | 0001633931 | 0001682265 |
4 | AssetsCurrent | -0.259 | -0.199 | 0.0696 | 0.471 | 7.10 | 0000357294 | 0000874238 | 0001785493 |
5 | AssetsNonCurrent | -0.0677 | -0.0410 | -0.0141 | 0.0484 | 0.665 | 0001682265 | 0001372020 | 0000052988 |
6 | Inventory | -0.724 | -0.426 | -0.220 | 0.629 | 1.36 | 0000822416 | 0000077543 | 0000833079 |
7 | Goodwill | -0.250 | -0.163 | -0.0371 | 0.389 | 0.520 | 0001682265 | 0001488139 | 0001796209 |
8 | CashAndCashEquivalentsAtCarryingValue | -0.244 | -0.181 | -0.0572 | 0.130 | 10.7 | 0001136294 | 0001561680 | 0001785493 |
9 | remainder_Assets | -4.08 | -0.638 | -0.0710 | 0.786 | 1.80 | 0000906163 | 0001580670 | 0001784567 |
10 | remainder_Expenses | -1.19 | -1.09 | -0.160 | 1.16 | 1.75 | 0001048268 | 0000015615 | 0000906163 |
11 | remainder_Revenues | -1.13 | -0.599 | 0.0382 | 0.836 | 2.51 | 0001785493 | 0000052988 | 0001682265 |
12 | remainder_NetIncome | -2.10 | -0.0335 | 0.0151 | 0.0707 | 0.184 | 0001682265 | 0001357971 | 0000866273 |
13 | remainder_ComprehensiveNetIncome | -0.0318 | -0.0166 | 0.00154 | 0.00759 | 0.0245 | 0001796209 | 0000822416 | 0001580905 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.711 | -0.523 | 0.0271 | 0.624 | 1.29 | 0001300938 | 0001718227 | 0001682265 |
1 | Assets | -0.729 | -0.659 | -0.156 | 0.569 | 1.99 | 0001682265 | 0000357294 | 0001785493 |
2 | Expenses | -1.19 | -1.09 | -0.160 | 1.16 | 1.75 | 0001048268 | 0000015615 | 0000906163 |
3 | Revenues | -1.13 | -0.599 | 0.0382 | 0.836 | 2.51 | 0001785493 | 0000052988 | 0001682265 |
4 | StockholdersEquity | -2.27 | -0.823 | -0.126 | 0.560 | 1.50 | 0001682265 | 0001796209 | 0001785493 |
5 | NetIncome | -1.37 | -0.755 | -0.271 | 1.98 | 3.72 | 0001785493 | 0001796209 | 0000906163 |
6 | ComprehensiveNetIncome | -1.37 | -0.753 | -0.288 | 1.99 | 3.72 | 0001785493 | 0001357615 | 0000906163 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000015615 | 0001124198 | 0000015615 |
8 | EconomicCapitalRatio | -1.95 | -0.692 | -0.304 | 2.12 | 4.03 | 0001300938 | 0001035983 | 0000906163 |
Estimates
Parameter | Value | Min | Max |
---|---|---|---|
PresentValueFactor | 1.6 | 1.0 | 15.0 |
BalanceFactor | 1.01 | 0.5 | 5.0 |
OCIFactor | 0.52 | 0.5 | 1.0 |
HiddenReservesFactor | 0.0 | 0.0 | 0.0 |
LLPO_stddev | 0.43 | 0.2 | 10.0 |