QA: us_construction 2016-2022

Table of Contents

Ranks across the years

name name_short 2016 2017 2018 2019 2020 2021 2022 2016-val 2017-val 2018-val 2019-val 2020-val 2021-val 2022-val 2016->2017 2017->2018 2018->2019 2019->2020 2020->2021 2021->2022
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
0000794170 0001534155
warning 3 × Ignoring company because Assets is zero pre-agg
0000822416 0000878560 0000357294
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000794170 0000795266
warning 2 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000773141 0000906163
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000773141 0000906163
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.0286646049001087}
warning 1 × Similarly named company. Duplicate? None
0001357971
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
0000915840
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001136294
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001136294
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001392363

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
0000794170 0000794170 0001534155
warning 3 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000773141 0000799292 0000906163
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000794170 0000795266
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000773141 0000906163
warning 2 × Ignoring company because Assets is zero pre-agg
0000822416 0000357294
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -1.8879446203928472}
warning 1 × Similarly named company. Duplicate? None
0001357971
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
0000915840
warning 1 × Ignoring company because Expenses is zero pre-agg
0001532383

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
0000794170 0000794170
warning 4 × Ignoring company because Assets is zero pre-agg
0000822416 0000357294 0000819690 0000915840
warning 2 × Similarly named company. Duplicate? None
0001357971 0001718227
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000794170 0000795266
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
0000915840
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000822416
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000906163
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000906163
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001532383

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
0000794170 0000794170
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001357971
warning 4 × Ignoring company because Assets is zero pre-agg
0000822416 0000357294 0000795266 0000915840
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000795266 0000794170
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
0000915840
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000822416
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0000906163
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000042316
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000906163
warning 1 × Ignoring company because Liabilities is zero pre-agg
0001532383
warning 1 × Ignoring company because Expenses is zero pre-agg
0001748621

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
0000773141 0000795266 0000906163 0000920760
warning 2 × Similarly named company. Duplicate? None
0001357971 0001718227
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000920760 0001682265
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000773141 0000906163
warning 2 × Ignoring company because Liabilities is zero pre-agg
0000795266 0001532383
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0000866273
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0001561680
warning 1 × Ignoring company because Expenses is zero pre-agg
0001748621
warning 1 × Ignoring company because Assets is zero pre-agg
0000920760

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
0000357294 0000773141 0000795266 0000906163
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000357294 0000773141 0000906163
warning 2 × Similarly named company. Duplicate? None
0001357971 0001718227
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
0001357971 0000866273
warning 2 × Ignoring company because Expenses is zero pre-agg
0001748621 0001839412
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
0001721386
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000795266

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
0000357294 0000773141 0000795266 0000906163
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0000357294 0000773141 0000906163
warning 2 × Similarly named company. Duplicate? None
0001357971 0001718227
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0001721386
warning 1 × Ignoring company because Liabilities is zero pre-agg
0000795266
warning 1 × Ignoring company because Assets is zero pre-agg
0001043150

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