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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0001172358 | DORCHESTER MINERALS L.P. | DORCHES | NaN | NaN | NaN | NaN | 1 | 1 | 1 | NaN | NaN | NaN | NaN | 251.348000 | 301.90900 | 354.75000 | NaN | NaN | NaN | NaN | 0 | 0 |
0001621434 | Black Stone Minerals L.P. | Black S | NaN | NaN | NaN | 32 | 8 | 6 | 2 | NaN | NaN | NaN | 143.641000 | 181.565000 | 190.28100 | 273.10700 | NaN | NaN | NaN | -24 | -2 | -4 |
0000867665 | ABRAXAS PETROLEUM CORP | ABRAXAS | NaN | NaN | 67 | 75 | 84 | 77 | 3 | NaN | NaN | 70.8180 | 16.594500 | -136.691000 | -92.16490 | 263.11700 | NaN | NaN | 8 | 9 | -7 | -74 |
0000732834 | CONTINENTAL RESOURCES INC | CONTINE | 7 | 13 | 12 | 6 | 7 | 4 | 4 | 188.54300 | 194.14200 | 196.9260 | 196.323000 | 189.628000 | 205.38300 | 232.39800 | 6 | -1 | -6 | 1 | -3 | 0 |
0001696088 | ENERGY RESOURCES 12 L.P. | ENERGY | NaN | 17 | 41 | 2 | 2 | 2 | 5 | NaN | 183.76700 | 138.4020 | 218.975000 | 212.166000 | 230.29800 | 231.13200 | NaN | 24 | -39 | 0 | 0 | 3 |
0000066418 | MEXCO ENERGY CORP | MEXCO E | NaN | NaN | 39 | 16 | 18 | 20 | 6 | NaN | NaN | 145.2260 | 178.491000 | 155.986000 | 155.00800 | 229.00000 | NaN | NaN | -23 | 2 | 2 | -14 |
0000727538 | Apache Offshore Investment Partnership | Apache | 29 | 22 | 11 | 11 | 12 | 19 | 7 | 85.39230 | 177.08300 | 205.7600 | 186.655000 | 178.860000 | 157.58600 | 222.35100 | -7 | -11 | 0 | 1 | 7 | -12 |
0000798949 | UNIT CORP | UNIT CO | 10 | 12 | 27 | 55 | NaN | 21 | 8 | 184.05000 | 201.29700 | 186.2430 | 68.360600 | NaN | 151.57400 | 218.67600 | 2 | 15 | 28 | NaN | NaN | -13 |
0001038357 | Pioneer Natural Resources Co | Pioneer | 13 | 19 | 21 | 17 | 10 | 8 | 9 | 177.25600 | 181.32100 | 190.9570 | 177.617000 | 180.067000 | 188.12800 | 218.04200 | 6 | 2 | -4 | -7 | -2 | 1 |
0001349436 | SANDRIDGE ENERGY INC | SANDRID | NaN | NaN | NaN | 82 | 71 | 16 | 10 | NaN | NaN | NaN | -0.635551 | -68.699400 | 168.96600 | 216.99400 | NaN | NaN | NaN | -11 | -55 | -6 |
0001090012 | DEVON ENERGY CORP DE | DEVON E | NaN | NaN | NaN | 29 | 25 | 7 | 11 | NaN | NaN | NaN | 148.119000 | 118.321000 | 188.44700 | 215.57300 | NaN | NaN | NaN | -4 | -18 | 4 |
0000797468 | OCCIDENTAL PETROLEUM CORP DE | OCCIDEN | 20 | 27 | 31 | 20 | 20 | 12 | 12 | 162.74700 | 160.86200 | 174.4850 | 167.441000 | 146.897000 | 183.42700 | 213.25600 | 7 | 4 | -11 | 0 | -8 | 0 |
0001726126 | Epsilon Energy Ltd. | Epsilon | NaN | NaN | NaN | 23 | 19 | 17 | 13 | NaN | NaN | NaN | 157.131000 | 148.557000 | 166.48200 | 210.51500 | NaN | NaN | NaN | -4 | -2 | -4 |
0001581552 | Energy 11 L.P. | Energy | NaN | NaN | 8 | 19 | 15 | 5 | 14 | NaN | NaN | 210.1060 | 173.125000 | 160.916000 | 193.41800 | 201.94000 | NaN | NaN | 11 | -4 | -10 | 9 |
0000352955 | CKX LANDS INC. | CKX LAN | 1 | 8 | 5 | 3 | 3 | NaN | 15 | 211.40100 | 216.93400 | 224.7130 | 213.749000 | 212.064000 | NaN | 200.71500 | 7 | -3 | -2 | 0 | NaN | NaN |
0001462103 | MEWBOURNE ENERGY PARTNERS 09-A L.P. | MEWBOUR | 5 | 5 | 34 | 33 | 62 | 25 | 16 | 191.01400 | 242.28700 | 165.5000 | 135.366000 | -33.858900 | 136.86900 | 195.89700 | 0 | 29 | -1 | 29 | -37 | -9 |
0001156041 | HOUSTON AMERICAN ENERGY CORP | HOUSTON | NaN | NaN | 10 | NaN | 30 | 9 | 17 | NaN | NaN | 207.5850 | NaN | 85.847200 | 186.89400 | 194.59800 | NaN | NaN | NaN | NaN | -21 | 8 |
0001705873 | Berry Corp (bry) | Berry C | NaN | NaN | NaN | NaN | 22 | 15 | 18 | NaN | NaN | NaN | NaN | 140.241000 | 169.55300 | 193.07400 | NaN | NaN | NaN | NaN | -7 | 3 |
0001602065 | Viper Energy Partners LP | Viper E | NaN | NaN | 35 | 24 | 24 | 22 | 19 | NaN | NaN | 157.9840 | 156.359000 | 122.284000 | 142.63200 | 183.67100 | NaN | NaN | -11 | 0 | -2 | -3 |
0000077159 | Ranger Oil Corp | Ranger | NaN | NaN | NaN | 9 | 28 | 18 | 20 | NaN | NaN | NaN | 189.861000 | 100.805000 | 161.67000 | 177.46600 | NaN | NaN | NaN | 19 | -10 | 2 |
0000083350 | RESERVE PETROLEUM CO | RESERVE | NaN | NaN | 26 | 14 | 13 | 10 | 21 | NaN | NaN | 186.9520 | 180.027000 | 175.659000 | 186.09400 | 177.15500 | NaN | NaN | -12 | -1 | -3 | 11 |
0001698990 | Magnolia Oil & Gas Corp | Magnoli | NaN | NaN | NaN | 29 | 78 | 23 | 22 | NaN | NaN | NaN | 148.119000 | -90.666200 | 140.50500 | 175.14700 | NaN | NaN | NaN | 49 | -55 | -1 |
0001486159 | Chord Energy Corp | Chord E | NaN | NaN | NaN | NaN | NaN | 47 | 23 | NaN | NaN | NaN | NaN | NaN | 69.35210 | 164.30800 | NaN | NaN | NaN | NaN | NaN | -24 |
0001609253 | California Resources Corp | Califor | 9 | 71 | 13 | 15 | NaN | 14 | 24 | 184.38100 | -90.10530 | 196.1780 | 179.768000 | NaN | 170.77100 | 162.27200 | 62 | -58 | 2 | NaN | NaN | 10 |
0001657788 | Kimbell Royalty Partners LP | Kimbell | NaN | NaN | NaN | NaN | 42 | 38 | 25 | NaN | NaN | NaN | NaN | 43.629900 | 100.60900 | 153.71600 | NaN | NaN | NaN | NaN | -4 | -13 |
0000315131 | PHX MINERALS INC. | PHX MIN | 2 | 7 | 6 | 28 | 17 | 35 | 26 | 202.04200 | 217.88900 | 223.7880 | 148.588000 | 157.219000 | 104.49800 | 142.01300 | 5 | -1 | 22 | -11 | 18 | -9 |
0001001614 | Riley Exploration Permian Inc. | Riley E | 53 | 36 | 37 | 36 | 59 | 48 | 27 | -8.12321 | 93.70640 | 148.8460 | 115.001000 | -15.805400 | 65.03930 | 140.03900 | -17 | 1 | -1 | 23 | -11 | -21 |
0000945764 | DENBURY INC | DENBURY | 54 | 60 | 78 | 66 | NaN | NaN | 28 | -11.29110 | 21.28210 | 38.2934 | 44.773800 | NaN | NaN | 139.72400 | 6 | 18 | -12 | NaN | NaN | NaN |
0001509589 | CIVITAS RESOURCES INC. | CIVITAS | NaN | NaN | NaN | 27 | 6 | 28 | 29 | NaN | NaN | NaN | 149.977000 | 191.424000 | 121.12700 | 136.49800 | NaN | NaN | NaN | -21 | 22 | 1 |
0000858470 | Coterra Energy Inc. | Coterra | 33 | 42 | 55 | 40 | 33 | 37 | 30 | 63.41510 | 83.77180 | 91.2049 | 89.876700 | 77.906100 | 101.68300 | 131.27400 | 9 | 13 | -15 | -7 | 4 | -7 |
0001520006 | Matador Resources Co | Matador | 36 | 35 | 58 | 51 | 45 | 40 | 31 | 59.88220 | 100.31800 | 88.6773 | 74.849600 | 38.416500 | 93.85880 | 127.52400 | -1 | 23 | -7 | -6 | -5 | -9 |
0001658566 | Permian Resources Corp | Permian | NaN | 24 | 40 | 35 | 29 | 26 | 32 | NaN | 161.63800 | 144.5530 | 119.455000 | 87.319200 | 131.37800 | 124.07800 | NaN | 16 | -5 | -6 | -3 | 6 |
0001539838 | Diamondback Energy Inc. | Diamond | NaN | NaN | 47 | NaN | 41 | 36 | 33 | NaN | NaN | 114.8620 | NaN | 48.835700 | 104.31600 | 118.68300 | NaN | NaN | NaN | NaN | -5 | -3 |
0001141197 | PEDEVCO CORP | PEDEVCO | NaN | NaN | 44 | 26 | 23 | 11 | 34 | NaN | NaN | 122.7090 | 151.123000 | 122.804000 | 184.14300 | 117.67700 | NaN | NaN | -18 | -3 | -12 | 23 |
0000010254 | EARTHSTONE ENERGY INC | EARTHST | 27 | 25 | 32 | 34 | 21 | 31 | 35 | 109.03700 | 161.34600 | 171.3220 | 131.314000 | 146.582000 | 118.35200 | 116.39000 | -2 | 7 | 2 | -13 | 10 | 4 |
0000056868 | PrimeEnergy Resources Corp | PrimeEn | NaN | 44 | 70 | 57 | 35 | 46 | 36 | NaN | 79.62610 | 65.4927 | 66.630800 | 70.247700 | 69.47890 | 115.53800 | NaN | 26 | -13 | -22 | 11 | -10 |
0001282648 | BATTALION OIL CORP | BATTALI | NaN | NaN | 19 | NaN | 47 | 34 | 37 | NaN | NaN | 194.1110 | NaN | 29.128800 | 105.45700 | 115.04300 | NaN | NaN | NaN | NaN | -13 | 3 |
0000101778 | MARATHON OIL CORP | MARATHO | 31 | 55 | 52 | 39 | 31 | 32 | 38 | 77.86640 | 45.14100 | 96.2383 | 98.894200 | 80.783500 | 110.00300 | 114.36100 | 24 | -3 | -13 | -8 | 1 | 6 |
0000893538 | SM Energy Co | SM Ener | 43 | 52 | NaN | NaN | 46 | NaN | 39 | 39.12420 | 50.16470 | NaN | NaN | 37.126800 | NaN | 108.71000 | 9 | NaN | NaN | NaN | NaN | NaN |
0000101594 | US ENERGY CORP | US ENER | NaN | NaN | 42 | 25 | NaN | 30 | 40 | NaN | NaN | 134.1940 | 151.273000 | NaN | 120.07500 | 108.67700 | NaN | NaN | -17 | NaN | NaN | 10 |
0001792580 | Ovintiv Inc. | Ovintiv | NaN | NaN | NaN | 54 | 58 | 51 | 41 | NaN | NaN | NaN | 68.419700 | -14.405200 | 61.33130 | 107.66400 | NaN | NaN | NaN | 4 | -7 | -10 |
0001006655 | EVOLUTION PETROLEUM CORP | EVOLUTI | 8 | 28 | 20 | 10 | 16 | 42 | 42 | 184.47600 | 155.54300 | 191.5920 | 187.287000 | 160.205000 | 89.38240 | 105.58400 | 20 | -8 | -10 | 6 | 26 | 0 |
0000867038 | SPINDLETOP OIL & GAS CO | SPINDLE | 23 | 31 | 45 | 38 | 27 | 33 | 43 | 119.61100 | 122.20300 | 121.7710 | 112.755000 | 109.568000 | 109.05300 | 102.99400 | 8 | 14 | -7 | -11 | 6 | 10 |
0000077877 | PDC ENERGY INC. | PDC ENE | 30 | 41 | 60 | 49 | 38 | 39 | 44 | 83.96150 | 83.88920 | 85.5485 | 77.287300 | 55.440600 | 96.68030 | 101.96100 | 11 | 19 | -11 | -11 | 1 | 5 |
0000010048 | BARNWELL INDUSTRIES INC | BARNWEL | 42 | 34 | 65 | 91 | 61 | 41 | 45 | 39.85600 | 101.20200 | 72.2286 | -75.644600 | -33.677800 | 92.84240 | 101.48100 | -8 | 31 | 26 | -30 | -20 | 4 |
0000928022 | Callon Petroleum Co | Callon | NaN | NaN | 49 | 58 | 65 | 57 | 46 | NaN | NaN | 109.3580 | 65.299700 | -43.530000 | 52.79210 | 100.67900 | NaN | NaN | 9 | 7 | -8 | -11 |
0001384195 | RING ENERGY INC. | RING EN | NaN | NaN | 36 | 43 | 51 | 49 | 47 | NaN | NaN | 155.6100 | 85.847700 | 14.296100 | 63.12990 | 92.96840 | NaN | NaN | 7 | 8 | -2 | -2 |
0001433270 | ANTERO RESOURCES Corp | ANTERO | NaN | NaN | NaN | NaN | 40 | 52 | 48 | NaN | NaN | NaN | NaN | 54.422600 | 60.56300 | 92.51190 | NaN | NaN | NaN | NaN | 12 | -4 |
0000894627 | VAALCO ENERGY INC DE | VAALCO | NaN | NaN | 28 | 45 | 50 | 27 | 49 | NaN | NaN | 184.9370 | 79.368500 | 18.132900 | 126.74300 | 91.62480 | NaN | NaN | 17 | 5 | -23 | 22 |
0000717423 | MURPHY OIL CORP | MURPHY | 21 | 15 | 15 | 42 | 43 | 55 | 50 | 162.07500 | 184.64200 | 195.0000 | 87.702700 | 42.592400 | 58.88660 | 86.28020 | -6 | 0 | 27 | 1 | 12 | -5 |
0001528129 | Vital Energy Inc. | Vital E | 51 | 40 | 57 | 71 | 68 | 60 | 51 | -3.56388 | 85.26470 | 88.8064 | 32.114000 | -61.787300 | 31.16880 | 85.88960 | -11 | 17 | 14 | -3 | -8 | -9 |
0000315852 | RANGE RESOURCES CORP | RANGE R | 32 | 45 | 79 | 76 | 49 | 58 | 52 | 63.90610 | 76.24380 | 35.9469 | 16.351200 | 20.800300 | 48.54660 | 84.36250 | 13 | 34 | -3 | -27 | 9 | -6 |
0000033213 | EQT Corp | EQT Cor | NaN | NaN | 71 | 53 | 36 | 53 | 53 | NaN | NaN | 65.0510 | 69.462800 | 69.086500 | 60.27180 | 83.33330 | NaN | NaN | -18 | -17 | 17 | 0 |
0001288403 | W&T OFFSHORE INC | W&T OFF | 28 | 23 | 22 | 21 | 9 | 29 | 54 | 86.48980 | 167.37100 | 190.1700 | 163.756000 | 180.789000 | 120.61600 | 81.83170 | -5 | -1 | -1 | -12 | 20 | 25 |
0000023194 | COMSTOCK RESOURCES INC | COMSTOC | NaN | NaN | NaN | 65 | 44 | 64 | 55 | NaN | NaN | NaN | 45.869200 | 39.659600 | 26.42660 | 80.56490 | NaN | NaN | NaN | -21 | 20 | -9 |
0000874499 | GULFPORT ENERGY CORP | GULFPOR | 40 | 37 | 54 | NaN | 72 | NaN | 56 | 46.19730 | 91.39100 | 93.6575 | NaN | -72.667900 | NaN | 70.33500 | -3 | 17 | NaN | NaN | NaN | NaN |
0001724965 | TALOS ENERGY INC. | TALOS E | NaN | NaN | 69 | 60 | 48 | 62 | 57 | NaN | NaN | 67.7985 | 61.239300 | 23.739500 | 27.71320 | 67.68230 | NaN | NaN | -9 | -12 | 14 | -5 |
0000006769 | APACHE CORP | APACHE | NaN | NaN | 29 | 31 | 26 | 44 | 58 | NaN | NaN | 181.2460 | 145.263000 | 111.487000 | 79.22060 | 64.58680 | NaN | NaN | 2 | -5 | 18 | 14 |
0001104485 | NORTHERN OIL & GAS INC. | NORTHER | 62 | 70 | 75 | 68 | 81 | 66 | 59 | -123.59000 | -63.12440 | 48.1751 | 33.439600 | -117.298000 | 17.32220 | 63.95390 | 8 | 5 | -7 | 13 | -15 | -7 |
0000061398 | TELLURIAN INC. DE | TELLURI | NaN | 61 | 48 | 78 | 64 | 43 | 60 | NaN | 10.34430 | 113.0110 | 10.966400 | -37.578600 | 84.71380 | 63.89450 | NaN | -13 | 30 | -14 | -21 | 17 |
0000007332 | SOUTHWESTERN ENERGY CO | SOUTHWE | 57 | 53 | 68 | NaN | 67 | 63 | 61 | -24.42210 | 49.57040 | 68.6053 | NaN | -52.231100 | 26.62230 | 62.05540 | -4 | 15 | NaN | NaN | -4 | -2 |
0001437491 | BitNile Metaverse Inc. | BitNile | 64 | NaN | 100 | 97 | 60 | 70 | 62 | -181.36800 | NaN | -398.8530 | -394.937000 | -26.121500 | -7.07285 | 56.26240 | NaN | NaN | -3 | -37 | 10 | -8 |
0000887396 | EMPIRE PETROLEUM CORP | EMPIRE | NaN | NaN | 92 | NaN | 85 | 65 | 63 | NaN | NaN | -57.1248 | NaN | -182.241000 | 25.19830 | 54.85990 | NaN | NaN | NaN | NaN | -20 | -2 |
0001273441 | GRAN TIERRA ENERGY INC. | GRAN TI | NaN | NaN | 73 | 48 | 66 | 59 | 64 | NaN | NaN | 54.4205 | 77.526800 | -45.903700 | 36.39350 | 53.47110 | NaN | NaN | -25 | 18 | -7 | 5 |
0001841666 | APA Corp | APA Cor | NaN | NaN | NaN | NaN | NaN | 45 | 65 | NaN | NaN | NaN | NaN | NaN | 70.20050 | 49.14910 | NaN | NaN | NaN | NaN | NaN | 20 |
0001070412 | CNX Resources Corp | CNX Res | NaN | NaN | NaN | NaN | 34 | 56 | 66 | NaN | NaN | NaN | NaN | 75.851400 | 57.74350 | 44.61230 | NaN | NaN | NaN | NaN | 22 | 10 |
0000821483 | PAR PACIFIC HOLDINGS INC. | PAR PAC | NaN | NaN | NaN | 72 | 57 | 69 | 67 | NaN | NaN | NaN | 31.907700 | -6.964950 | 9.02084 | 36.68400 | NaN | NaN | NaN | -15 | 12 | -2 |
0000844965 | TETRA TECHNOLOGIES INC | TETRA T | 45 | NaN | NaN | NaN | 55 | 54 | 68 | 24.64880 | NaN | NaN | NaN | -1.605950 | 59.63440 | 32.48140 | NaN | NaN | NaN | NaN | -1 | 14 |
0001509991 | Kosmos Energy Ltd. | Kosmos | 44 | 59 | 81 | 73 | 52 | 68 | 69 | 32.71670 | 28.17020 | 26.2906 | 22.546900 | 2.110610 | 10.89850 | 26.30300 | 15 | 22 | -8 | -21 | 16 | 1 |
0001789832 | Hess Midstream LP | Hess Mi | NaN | NaN | NaN | 61 | 39 | 61 | 70 | NaN | NaN | NaN | 59.293200 | 55.167300 | 28.37980 | 20.19110 | NaN | NaN | NaN | -22 | 22 | 9 |
0001533924 | Amplify Energy Corp. | Amplify | NaN | 33 | 16 | 56 | 82 | 72 | 71 | NaN | 101.92900 | 194.5410 | 67.648200 | -124.861000 | -21.34140 | 11.43620 | NaN | -17 | 40 | 26 | -10 | -1 |
0001102432 | VIKING ENERGY GROUP INC. | VIKING | NaN | NaN | NaN | NaN | NaN | 67 | 72 | NaN | NaN | NaN | NaN | NaN | 11.02600 | 3.50062 | NaN | NaN | NaN | NaN | NaN | 5 |
0001368637 | Petrolia Energy Corp | Petroli | 35 | 32 | 99 | NaN | NaN | NaN | 73 | 60.67070 | 121.84100 | -335.1060 | NaN | NaN | NaN | -47.67750 | -3 | 67 | NaN | NaN | NaN | NaN |
0001309082 | CAMBER ENERGY INC. | CAMBER | NaN | NaN | NaN | NaN | 32 | NaN | 74 | NaN | NaN | NaN | NaN | 78.316400 | NaN | -54.06980 | NaN | NaN | NaN | NaN | NaN | NaN |
0001694617 | Royale Energy Inc. | Royale | NaN | NaN | 96 | 79 | 75 | 76 | 75 | NaN | NaN | -103.9880 | 7.602240 | -82.585000 | -92.14900 | -64.79240 | NaN | NaN | -17 | -4 | 1 | -1 |
0001165320 | GB SCIENCES INC | GB SCIE | 68 | 66 | 86 | 87 | 80 | 73 | 76 | -270.84500 | -8.56271 | -35.7771 | -26.286100 | -91.753900 | -46.44440 | -72.93270 | -2 | 20 | 1 | -7 | -7 | 3 |
0001442492 | Laredo Oil Inc. | Laredo | 65 | 74 | 97 | 93 | 76 | 75 | 77 | -193.50900 | -231.43100 | -156.3410 | -168.463000 | -87.625600 | -73.30370 | -78.44800 | 9 | 23 | -4 | -17 | -1 | 2 |
0001500305 | Sustainable Projects Group Inc. | Sustain | NaN | 21 | 33 | 62 | NaN | NaN | 78 | NaN | 177.86400 | 170.2510 | 56.231700 | NaN | NaN | -84.46620 | NaN | 12 | 29 | NaN | NaN | NaN |
0001362705 | Evolve Transition Infrastructure LP | Evolve | NaN | NaN | 51 | 85 | 70 | 78 | 79 | NaN | NaN | 96.5813 | -21.020500 | -67.223300 | -108.34900 | -87.43890 | NaN | NaN | 34 | -15 | 8 | 1 |
0000855787 | TRULEUM INC. | TRULEUM | NaN | 77 | 102 | 96 | 89 | 83 | 80 | NaN | -404.23500 | -450.1590 | -364.266000 | -367.782000 | -268.99500 | -124.70200 | NaN | 25 | -6 | -7 | -6 | -3 |
0001164256 | DAYBREAK OIL & GAS INC. | DAYBREA | NaN | NaN | NaN | NaN | 86 | NaN | 81 | NaN | NaN | NaN | NaN | -182.389000 | NaN | -155.28000 | NaN | NaN | NaN | NaN | NaN | NaN |
0000700764 | VICTORY OILFIELD TECH INC. | VICTORY | 66 | NaN | NaN | NaN | NaN | 80 | 82 | -219.16200 | NaN | NaN | NaN | NaN | -163.51400 | -174.14900 | NaN | NaN | NaN | NaN | NaN | 2 |
0001434737 | SPIRITS TIME INTERNATIONAL INC. | SPIRITS | NaN | NaN | NaN | NaN | NaN | 79 | 83 | NaN | NaN | NaN | NaN | NaN | -137.00600 | -179.67500 | NaN | NaN | NaN | NaN | NaN | 4 |
0001341726 | GULFSLOPE ENERGY INC. | GULFSLO | 63 | NaN | NaN | NaN | 54 | 71 | 84 | -156.34400 | NaN | NaN | NaN | -0.548838 | -15.80200 | -186.55700 | NaN | NaN | NaN | NaN | 17 | 13 |
0001603793 | Norris Industries Inc. | Norris | NaN | 73 | 90 | 83 | 87 | 81 | 85 | NaN | -131.39800 | -45.9703 | -10.071200 | -273.385000 | -231.22800 | -206.19500 | NaN | 17 | -7 | 4 | -6 | 4 |
0001495648 | Power Americas Resource Group Ltd. | Power A | NaN | 79 | NaN | NaN | NaN | NaN | 86 | NaN | -1539.93000 | NaN | NaN | NaN | NaN | -224.27600 | NaN | NaN | NaN | NaN | NaN | NaN |
0001342936 | Advanced Voice Recognition Systems Inc | Advance | NaN | NaN | 98 | 94 | NaN | NaN | 87 | NaN | NaN | -180.2890 | -220.852000 | NaN | NaN | -250.08200 | NaN | NaN | -4 | NaN | NaN | NaN |
0001557798 | Tianci International Inc. | Tianci | NaN | NaN | NaN | NaN | NaN | 82 | 88 | NaN | NaN | NaN | NaN | NaN | -241.13100 | -370.22200 | NaN | NaN | NaN | NaN | NaN | 6 |
0000072207 | NOBLE ENERGY INC | NOBLE E | 37 | 50 | 64 | 63 | NaN | NaN | NaN | 59.58920 | 66.00740 | 73.8917 | 54.372200 | NaN | NaN | NaN | 13 | 14 | -1 | NaN | NaN | NaN |
0000086264 | Carbon Energy Corp | Carbon | 52 | 54 | 80 | 70 | NaN | NaN | NaN | -7.47922 | 47.73780 | 35.6128 | 32.137800 | NaN | NaN | NaN | 2 | 26 | -10 | NaN | NaN | NaN |
0000277595 | ENERGEN CORP | ENERGEN | 26 | 29 | NaN | NaN | NaN | NaN | NaN | 109.20600 | 124.37100 | NaN | NaN | NaN | NaN | NaN | 3 | NaN | NaN | NaN | NaN | NaN |
0000316736 | FIELDPOINT PETROLEUM CORP | FIELDPO | 58 | 48 | 94 | NaN | NaN | NaN | NaN | -39.15750 | 68.50700 | -89.8451 | NaN | NaN | NaN | NaN | -10 | 46 | NaN | NaN | NaN | NaN |
0000319200 | REGENT TECHNOLOGIES INC | REGENT | 3 | 10 | NaN | NaN | NaN | NaN | NaN | 199.17500 | 205.50800 | NaN | NaN | NaN | NaN | NaN | 7 | NaN | NaN | NaN | NaN | NaN |
0000719209 | ISRAMCO INC | ISRAMCO | 18 | 43 | 43 | NaN | NaN | NaN | NaN | 168.12500 | 83.14120 | 125.2020 | NaN | NaN | NaN | NaN | 25 | 0 | NaN | NaN | NaN | NaN |
0000773910 | ANADARKO PETROLEUM CORP | ANADARK | 12 | 18 | 30 | NaN | NaN | NaN | NaN | 179.18300 | 182.54000 | 178.8200 | NaN | NaN | NaN | NaN | 6 | 12 | NaN | NaN | NaN | NaN |
0000793306 | BLUE DOLPHIN ENERGY CO | BLUE DO | 50 | 68 | 1 | 77 | 63 | 74 | NaN | 4.13854 | -36.40130 | 444.2750 | 16.112300 | -35.385500 | -50.00730 | NaN | 18 | -67 | 76 | -14 | 11 | NaN |
0000864839 | ROYALE ENERGY FUNDS INC | ROYALE | 61 | 72 | NaN | NaN | NaN | NaN | NaN | -86.04310 | -105.07500 | NaN | NaN | NaN | NaN | NaN | 11 | NaN | NaN | NaN | NaN | NaN |
0000868082 | EVERFLOW EASTERN PARTNERS LP | EVERFLO | 22 | 14 | 7 | 5 | 11 | NaN | NaN | 153.35700 | 192.30400 | 212.2880 | 197.633000 | 179.268000 | NaN | NaN | -8 | -7 | -2 | 6 | NaN | NaN |
0000895126 | CHESAPEAKE ENERGY CORP | CHESAPE | 59 | NaN | 83 | 69 | NaN | NaN | NaN | -42.06560 | NaN | 13.3044 | 32.961300 | NaN | NaN | NaN | NaN | NaN | -14 | NaN | NaN | NaN |
0001157806 | ENCANA CORP | ENCANA | 39 | 49 | 61 | NaN | NaN | NaN | NaN | 48.97200 | 68.27760 | 79.9550 | NaN | NaN | NaN | NaN | 10 | 12 | NaN | NaN | NaN | NaN |
0001168054 | CIMAREX ENERGY CO | CIMAREX | 34 | 38 | 50 | 52 | 56 | NaN | NaN | 62.51680 | 89.03480 | 102.0300 | 74.084600 | -5.286230 | NaN | NaN | 4 | 12 | 2 | 4 | NaN | NaN |
0001172139 | BILL BARRETT CORP | BILL BA | 16 | 26 | NaN | NaN | NaN | NaN | NaN | 173.15200 | 161.09500 | NaN | NaN | NaN | NaN | NaN | 10 | NaN | NaN | NaN | NaN | NaN |
0001282723 | MEWBOURNE ENERGY PARTNERS 05-A LP | MEWBOUR | 15 | 2 | 18 | 22 | NaN | NaN | NaN | 173.46000 | 246.84400 | 194.1510 | 161.676000 | NaN | NaN | NaN | -13 | 16 | 4 | NaN | NaN | NaN |
0001333519 | Baying Ecological Holding Group Inc. | Baying | 70 | 76 | NaN | NaN | NaN | NaN | NaN | -283.94700 | -257.52400 | NaN | NaN | NaN | NaN | NaN | 6 | NaN | NaN | NaN | NaN | NaN |
0001353406 | RedHawk Holdings Corp. | RedHawk | 49 | 56 | 87 | 90 | 83 | NaN | NaN | 4.41954 | 43.79250 | -36.5141 | -73.873200 | -135.427000 | NaN | NaN | 7 | 31 | 3 | -7 | NaN | NaN |
0001353722 | Mewbourne Energy Partners 06-A L.P. | Mewbour | 19 | 4 | 14 | NaN | NaN | NaN | NaN | 167.76200 | 242.49800 | 195.0320 | NaN | NaN | NaN | NaN | -15 | 10 | NaN | NaN | NaN | NaN |
0001353748 | Mewbourne Energy Partners 07-A L.P. | Mewbour | 11 | 3 | NaN | NaN | NaN | NaN | NaN | 182.05100 | 243.53500 | NaN | NaN | NaN | NaN | NaN | -8 | NaN | NaN | NaN | NaN | NaN |
0001361937 | Harvest Oil & Gas Corp. | Harvest | 14 | 46 | NaN | 67 | NaN | NaN | NaN | 177.06900 | 70.64850 | NaN | 34.193900 | NaN | NaN | NaN | 32 | NaN | NaN | NaN | NaN | NaN |
0001386018 | Tiger Oil & Energy Inc. | Tiger O | 67 | 75 | 103 | NaN | NaN | NaN | NaN | -242.90000 | -232.86800 | -461.0990 | NaN | NaN | NaN | NaN | 8 | 28 | NaN | NaN | NaN | NaN |
0001397516 | REX ENERGY CORP | REX ENE | 56 | 67 | NaN | NaN | NaN | NaN | NaN | -18.60510 | -12.76640 | NaN | NaN | NaN | NaN | NaN | 11 | NaN | NaN | NaN | NaN | NaN |
0001436942 | MEWBOURNE ENERGY PARTNERS 08-A LP | MEWBOUR | 4 | 1 | 38 | 44 | NaN | NaN | NaN | 191.13900 | 250.69800 | 145.2540 | 80.511000 | NaN | NaN | NaN | -3 | 37 | 6 | NaN | NaN | NaN |
0001482075 | Citadel Exploration Inc. | Citadel | 60 | NaN | 85 | NaN | NaN | NaN | NaN | -68.51090 | NaN | -23.6107 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
0001490054 | VERDE BIO HOLDINGS INC. | VERDE B | 69 | 78 | 101 | 95 | NaN | NaN | NaN | -273.27900 | -458.13100 | -405.4900 | -269.158000 | NaN | NaN | NaN | 9 | 23 | -6 | NaN | NaN | NaN |
0001506742 | Texas South Energy Inc. | Texas S | 24 | 51 | 77 | NaN | NaN | NaN | NaN | 119.04800 | 53.45270 | 43.6317 | NaN | NaN | NaN | NaN | 27 | 26 | NaN | NaN | NaN | NaN |
0001518403 | Alta Mesa Holdings LP | Alta Me | 55 | 62 | NaN | NaN | NaN | NaN | NaN | -16.58830 | 9.30126 | NaN | NaN | NaN | NaN | NaN | 7 | NaN | NaN | NaN | NaN | NaN |
0001518832 | WPX ENERGY INC. | WPX ENE | 17 | 20 | 23 | 12 | NaN | NaN | NaN | 169.01100 | 180.46600 | 189.7890 | 184.677000 | NaN | NaN | NaN | 3 | 3 | -11 | NaN | NaN | NaN |
0001527709 | Mid-Con Energy Partners LP | Mid-Con | 6 | 16 | 17 | 4 | NaN | NaN | NaN | 190.38500 | 183.84000 | 194.4570 | 199.794000 | NaN | NaN | NaN | 10 | 1 | -13 | NaN | NaN | NaN |
0001555082 | EP Energy LLC | EP Ener | 47 | 64 | 88 | 74 | NaN | NaN | NaN | 14.52470 | 4.72667 | -37.2255 | 20.258800 | NaN | NaN | NaN | 17 | 24 | -14 | NaN | NaN | NaN |
0001572702 | Atlas Growth Partners L.P. | Atlas G | 38 | 11 | 95 | 89 | 69 | NaN | NaN | 50.26040 | 203.63000 | -96.9958 | -37.490600 | -65.663500 | NaN | NaN | -27 | 84 | -6 | -20 | NaN | NaN |
0001584952 | EP Energy Corp | EP Ener | 48 | 63 | 88 | NaN | NaN | NaN | NaN | 14.48320 | 5.12585 | -37.2255 | NaN | NaN | NaN | NaN | 15 | 25 | NaN | NaN | NaN | NaN |
0001588216 | RSP Permian Inc. | RSP Per | 25 | 30 | NaN | NaN | NaN | NaN | NaN | 114.58800 | 122.41300 | NaN | NaN | NaN | NaN | NaN | 5 | NaN | NaN | NaN | NaN | NaN |
0001600470 | Montage Resources Corp | Montage | 41 | 47 | 66 | 47 | NaN | NaN | NaN | 43.59640 | 68.68700 | 71.7355 | 78.376800 | NaN | NaN | NaN | 6 | 19 | -19 | NaN | NaN | NaN |
0001661920 | Lonestar Resources US Inc. | Lonesta | 46 | 58 | 72 | 81 | NaN | NaN | NaN | 24.03850 | 40.14430 | 55.2394 | 4.719660 | NaN | NaN | NaN | 12 | 14 | 9 | NaN | NaN | NaN |
0000869495 | DEEP WELL OIL & GAS INC | DEEP WE | NaN | 9 | 9 | NaN | NaN | NaN | NaN | NaN | 207.16600 | 208.9400 | NaN | NaN | NaN | NaN | NaN | 0 | NaN | NaN | NaN | NaN |
0001503458 | FOOTHILLS EXPLORATION INC. | FOOTHIL | NaN | 69 | 93 | NaN | NaN | NaN | NaN | NaN | -42.42480 | -74.3134 | NaN | NaN | NaN | NaN | NaN | 24 | NaN | NaN | NaN | NaN |
0001619739 | Hess Midstream Operations LP | Hess Mi | NaN | 6 | 4 | NaN | NaN | NaN | NaN | NaN | 229.93000 | 230.9300 | NaN | NaN | NaN | NaN | NaN | -2 | NaN | NaN | NaN | NaN |
0001648636 | Trillion Energy International Inc. | Trillio | NaN | 65 | 84 | 80 | 73 | NaN | NaN | NaN | -7.34093 | 11.2270 | 4.914680 | -73.711200 | NaN | NaN | NaN | 19 | -4 | -7 | NaN | NaN |
0001659122 | Rosehill Resources Inc. | Rosehil | NaN | 39 | 59 | 59 | NaN | NaN | NaN | NaN | 86.72350 | 86.9787 | 62.230700 | NaN | NaN | NaN | NaN | 20 | 0 | NaN | NaN | NaN |
0001685715 | Jagged Peak Energy Inc. | Jagged | NaN | 57 | 53 | NaN | NaN | NaN | NaN | NaN | 43.02970 | 94.1629 | NaN | NaN | NaN | NaN | NaN | -4 | NaN | NaN | NaN | NaN |
0000775057 | ALTEX INDUSTRIES INC | ALTEX I | NaN | NaN | 62 | 46 | 37 | 50 | NaN | NaN | NaN | 78.6080 | 79.116700 | 62.847700 | 62.01070 | NaN | NaN | NaN | -16 | -9 | 13 | NaN |
0000943861 | GOODRICH PETROLEUM CORP | GOODRIC | NaN | NaN | 76 | 64 | 53 | NaN | NaN | NaN | NaN | 47.1024 | 54.103400 | 1.086160 | NaN | NaN | NaN | NaN | -12 | -11 | NaN | NaN |
0001022646 | ULTRA PETROLEUM CORP | ULTRA P | NaN | NaN | 91 | 88 | NaN | NaN | NaN | NaN | NaN | -47.7837 | -37.081000 | NaN | NaN | NaN | NaN | NaN | -3 | NaN | NaN | NaN |
0001071993 | CONTANGO OIL & GAS CO | CONTANG | NaN | NaN | 82 | 84 | 79 | NaN | NaN | NaN | NaN | 18.3290 | -10.477000 | -91.124700 | NaN | NaN | NaN | NaN | 2 | -5 | NaN | NaN |
0001255474 | Whiting Holdings LLC | Whiting | NaN | NaN | 56 | 50 | NaN | 24 | NaN | NaN | NaN | 90.3657 | 75.148900 | NaN | 139.87500 | NaN | NaN | NaN | -6 | NaN | NaN | NaN |
0001346980 | Chaparral Energy Inc. | Chaparr | NaN | NaN | 24 | 41 | NaN | NaN | NaN | NaN | NaN | 187.9090 | 88.569600 | NaN | NaN | NaN | NaN | NaN | 17 | NaN | NaN | NaN |
0001358071 | CONCHO RESOURCES INC | CONCHO | NaN | NaN | 3 | 7 | NaN | NaN | NaN | NaN | NaN | 232.8690 | 196.307000 | NaN | NaN | NaN | NaN | NaN | 4 | NaN | NaN | NaN |
0001437557 | LILIS ENERGY INC. | LILIS E | NaN | NaN | 74 | 92 | NaN | NaN | NaN | NaN | NaN | 52.3003 | -103.540000 | NaN | NaN | NaN | NaN | NaN | 18 | NaN | NaN | NaN |
0001594466 | Pioneer PE Holding LLC | Pioneer | NaN | NaN | 46 | 37 | NaN | NaN | NaN | NaN | NaN | 119.7280 | 112.975000 | NaN | NaN | NaN | NaN | NaN | -9 | NaN | NaN | NaN |
0001655020 | Extraction Oil & Gas Inc. | Extract | NaN | NaN | 63 | 86 | 77 | NaN | NaN | NaN | NaN | 76.5221 | -24.286700 | -90.417600 | NaN | NaN | NaN | NaN | 23 | -9 | NaN | NaN |
0001703785 | STR Sub Inc. | STR Sub | NaN | NaN | 2 | 13 | 14 | 13 | NaN | NaN | NaN | 256.1040 | 180.625000 | 164.541000 | 171.48900 | NaN | NaN | NaN | 11 | 1 | -1 | NaN |
0001725526 | HighPoint Resources Corp | HighPoi | NaN | NaN | 25 | 18 | 74 | NaN | NaN | NaN | NaN | 187.6290 | 177.017000 | -74.624700 | NaN | NaN | NaN | NaN | -7 | 56 | NaN | NaN |
0001108827 | QEP RESOURCES INC. | QEP RES | NaN | NaN | NaN | 8 | 5 | NaN | NaN | NaN | NaN | NaN | 192.905000 | 197.536000 | NaN | NaN | NaN | NaN | NaN | -3 | NaN | NaN |
0001745797 | MNRL Sub Inc. | MNRL Su | NaN | NaN | NaN | 1 | 4 | 3 | NaN | NaN | NaN | NaN | 221.004000 | 200.067000 | 226.73800 | NaN | NaN | NaN | NaN | 3 | -1 | NaN |
0001761534 | Golden Royal Development Inc. | Golden | NaN | NaN | NaN | NaN | 88 | 84 | NaN | NaN | NaN | NaN | NaN | -297.965000 | -276.94300 | NaN | NaN | NaN | NaN | NaN | -4 | 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 | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 6 × Ignoring company because Assets is zero | pre-agg | |
warning | 4 × Similarly named company. Duplicate? | None | |
warning | 3 × Ignoring company because Expenses is zero | pre-agg | |
warning | 2 × Zero effects | check_effects |
{'var_name': 'DeferredIncomeTaxLiabilitiesNet', 'zeros': '70 of 70'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '70 of 70'} |
warning | 2 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -275000000}
{'var_name': 'OperatingExpenses', 'min_value': -233000} |
warning | 2 × Missing logo | subcommand.report | |
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': -2.3221768796539375}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | LongTermDebt | 0 | 0 | 542,858 | 6,084,400,000 | 10,583,000,000 | 0000315131 | 0000086264 | 0000895126 |
1 | LiabilitiesCurrent | 39,166 | 103,552 | 54,038,473 | 2,838,400,000 | 6,362,000,000 | 0001282723 | 0001361937 | 0000797468 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 0 | 0 | 0000007332 | 0001038357 | 0000007332 |
3 | remainder_Liabilities | 0 | 0 | 0 | 1,293,087,700 | 3,239,488,000 | 0000315131 | 0000797468 | 0000893538 |
4 | PropertyPlantAndEquipment | 0 | 0 | 45,655,752 | 15,997,952,150 | 32,337,000,000 | 0000077877 | 0000719209 | 0000797468 |
5 | AssetsCurrent | 0 | 125,477 | 38,403,655 | 2,777,800,000 | 8,428,000,000 | 0001333519 | 0000719209 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 4,057,756,450 | 10,841,000,000 | 0000007332 | 0000719209 | 0001038357 |
7 | remainder_Assets | -4,004,323,000 | -823,234,300 | 2,304,740 | 1,719,883,600 | 8,130,000,000 | 0000277595 | 0001527709 | 0000773910 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 0 | 0 | 0 | 0000007332 | 0001038357 | 0000007332 |
9 | GainLossOnDerivatives | -275,000,000 | -191,827,700 | 0 | 0 | 9,286,000 | 0001157806 | 0001588216 | 0001520006 |
10 | remainder_Revenues | 0 | 0 | 149,512,481 | 4,350,750,000 | 10,196,000,000 | 0000319200 | 0001104485 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 1,782,387 | 2,086,184,800 | 4,301,000,000 | 0000007332 | 0000086264 | 0000773910 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 0 | 1,083,000,000 | 0000007332 | 0001038357 | 0000072207 |
13 | GeneralAndAdministrativeExpense | 0 | 0 | 7,902,750 | 317,800,000 | 1,440,000,000 | 0000797468 | 0000086264 | 0000773910 |
14 | Taxes | 0 | 0 | 0 | 140,400,000 | 536,000,000 | 0000010048 | 0000719209 | 0000773910 |
15 | OperatingExpenses | -233,000 | 0 | 427,237 | 1,971,050,000 | 4,799,000,000 | 0001172139 | 0001361937 | 0001157806 |
16 | remainder_Expenses | -4,723,000,000 | -659,494,800 | 9,054,367 | 2,790,450,000 | 9,924,000,000 | 0000072207 | 0000086264 | 0000895126 |
17 | remainder_NetIncome | -1,230,000,000 | -340,456,000 | -1,121 | 270,133,350 | 835,000,000 | 0000773910 | 0001482075 | 0001609253 |
18 | remainder_ComprehensiveNetIncome | -271,000,000 | -1,921,250 | 0 | 26,600,000 | 76,330,000 | 0000773910 | 0001462103 | 0000717423 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 39,166 | 110,403 | 80,105,245 | 7,552,750,000 | 14,231,000,000 | 0001282723 | 0001172139 | 0000895126 |
1 | Assets | 472 | 640,680 | 445,511,255 | 18,962,600,000 | 45,564,000,000 | 0001386018 | 0001661920 | 0000773910 |
2 | Revenues | 0 | 0 | 142,000,865 | 4,278,300,000 | 10,196,000,000 | 0000319200 | 0001104485 | 0000797468 |
3 | Expenses | 47,288 | 501,463 | 224,212,096 | 5,660,750,000 | 12,093,000,000 | 0001333519 | 0001518403 | 0000895126 |
4 | StockholdersEquity | -1,203,000,000 | -3,924,787 | 142,681,821 | 13,986,872,350 | 42,236,000,000 | 0000895126 | 0001661920 | 0000773910 |
5 | NetIncome | -4,399,000,000 | -1,620,250,000 | -26,102,787 | 72,591 | 279,000,000 | 0000895126 | 0001437491 | 0001609253 |
6 | ComprehensiveNetIncome | -4,398,000,000 | -1,654,200,000 | -26,102,787 | 72,591 | 280,000,000 | 0000895126 | 0001437491 | 0001609253 |
7 | BaseVar | 92,892 | 2,143,195 | 727,324,890 | 22,125,825,000 | 36,050,000,000 | 0001333519 | 0001104485 | 0000797468 |
8 | EconomicCapitalRatio | -2.84 | -2.32 | 0.603 | 1.91 | 2.11 | 0001333519 | 0001368637 | 0000352955 |
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 | LongTermDebt | -1.17 | -0.882 | 0.108 | 0.517 | 0.550 | 0001555082 | 0001482075 | 0001353748 |
1 | LiabilitiesCurrent | -1.22 | -0.608 | 0.210 | 0.638 | 3.29 | 0001482075 | 0001661920 | 0001333519 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 0 | 0 | 0000007332 | 0001038357 | 0000007332 |
3 | remainder_Liabilities | -0.973 | -0.331 | 0.0979 | 0.241 | 0.959 | 0001397516 | 0000895126 | 0001490054 |
4 | PropertyPlantAndEquipment | -2.94 | -1.17 | -0.0120 | 0.741 | 1.13 | 0001442492 | 0000868082 | 0001572702 |
5 | AssetsCurrent | -1.67 | -0.451 | -0.0267 | 0.629 | 0.875 | 0001442492 | 0000798949 | 0000727538 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -2.71 | -0.987 | -0.117 | 0.965 | 1.51 | 0001442492 | 0000797468 | 0001506742 |
7 | remainder_Assets | -0.720 | -0.431 | 0.0136 | 0.323 | 2.21 | 0001518403 | 0001104485 | 0000319200 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 0 | 0 | 0 | 0000007332 | 0001038357 | 0000007332 |
9 | GainLossOnDerivatives | -0.0776 | -0.0442 | 0.00765 | 0.0145 | 0.0627 | 0001527709 | 0000010254 | 0001442492 |
10 | remainder_Revenues | -0.427 | -0.268 | -0.0403 | 0.412 | 7.46 | 0001165320 | 0000893538 | 0001442492 |
11 | DepreciationDepletionAndAmortization | -0.583 | -0.146 | 0.00561 | 0.134 | 0.726 | 0000727538 | 0001528129 | 0001442492 |
12 | CostOfGoodsAndServicesSold | -0.0659 | 0.000853 | 0.00105 | 0.00166 | 0.00849 | 0000072207 | 0000086264 | 0001442492 |
13 | GeneralAndAdministrativeExpense | -1.90 | -0.140 | 0.0463 | 0.107 | 0.279 | 0001165320 | 0001600470 | 0001442492 |
14 | Taxes | -0.0420 | -0.0320 | 0.00564 | 0.00982 | 0.0532 | 0001282723 | 0001509991 | 0001442492 |
15 | OperatingExpenses | -2.26 | -0.385 | 0.107 | 0.192 | 0.341 | 0001437491 | 0001506742 | 0000793306 |
16 | remainder_Expenses | -7.44 | -0.649 | 0.0483 | 0.424 | 0.493 | 0001442492 | 0000101778 | 0000867038 |
17 | remainder_NetIncome | -0.656 | -0.0953 | 0.00131 | 0.185 | 0.553 | 0000727538 | 0001482075 | 0001006655 |
18 | remainder_ComprehensiveNetIncome | -0.103 | -0.00592 | 0.000516 | 0.00345 | 0.0632 | 0000010048 | 0001528129 | 0000844965 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.807 | -0.554 | 0.116 | 1.16 | 1.38 | 0001482075 | 0001165320 | 0001333519 |
1 | Assets | -3.46 | -1.88 | 0.0323 | 0.273 | 0.437 | 0001442492 | 0001520006 | 0001506742 |
2 | Revenues | -0.415 | -0.261 | -0.0377 | 0.424 | 7.53 | 0001165320 | 0000945764 | 0001442492 |
3 | Expenses | -6.12 | -1.16 | 0.0797 | 0.250 | 0.332 | 0001442492 | 0000797468 | 0001588216 |
4 | StockholdersEquity | -7.42 | -2.56 | 0.0327 | 1.31 | 1.53 | 0001442492 | 0000315852 | 0000319200 |
5 | NetIncome | -1.75 | -0.807 | 0.0694 | 0.365 | 1.40 | 0001437491 | 0001518832 | 0001442492 |
6 | ComprehensiveNetIncome | -1.75 | -0.807 | 0.0698 | 0.376 | 1.40 | 0001437491 | 0001518832 | 0001442492 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000007332 | 0001038357 | 0000007332 |
8 | EconomicCapitalRatio | -3.32 | -2.80 | 0.122 | 1.43 | 1.63 | 0001333519 | 0001368637 | 0000352955 |
2017
Logs
error | 2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
error | 1 × IME and Company effects mismatched for Oil and Gas Property. IME Effects: 35.3, Company Effect: 35.2 | subcommand.report | |
warning | 5 × Similarly named company. Duplicate? | None | |
warning | 3 × Ignoring company because Expenses is zero | pre-agg | |
warning | 2 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -100000000}
{'var_name': 'OperatingExpenses', 'min_value': -1431000} |
warning | 2 × Missing logo | subcommand.report | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -2.353332540140159}
|
warning | 1 × 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 "Assets" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Assets is zero | pre-agg | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | LongTermDebt | 0 | 0 | 497,389 | 4,124,400,000 | 7,991,000,000 | 0000315131 | 0001353406 | 0000072207 |
1 | LiabilitiesCurrent | 0 | 59,559 | 63,994,243 | 1,984,000,000 | 7,400,000,000 | 0001500305 | 0001661920 | 0000797468 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 62,310,500 | 833,000,000 | 0000007332 | 0000717423 | 0000101778 |
3 | remainder_Liabilities | 0 | 0 | 0 | 415,123,700 | 3,103,154,000 | 0000061398 | 0000717423 | 0000893538 |
4 | PropertyPlantAndEquipment | 0 | 0 | 14,839,129 | 13,390,610,100 | 31,174,000,000 | 0000077877 | 0000315852 | 0000797468 |
5 | AssetsCurrent | 0 | 10,751 | 46,550,111 | 2,300,500,000 | 8,270,000,000 | 0001333519 | 0000719209 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 4,849,437,200 | 11,766,000,000 | 0000007332 | 0000732834 | 0001038357 |
7 | remainder_Assets | -5,983,777,000 | -1,080,220,600 | 2,095,792 | 1,861,100,000 | 7,873,000,000 | 0001588216 | 0001600470 | 0000773910 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 0 | 0 | 3,883,059 | 0000007332 | 0001165320 | 0001648636 |
9 | GainLossOnDerivatives | -100,000,000 | -5,355,565 | 0 | 46,064,700 | 482,000,000 | 0001038357 | 0001165320 | 0001157806 |
10 | remainder_Revenues | 0 | 0 | 94,177,278 | 4,306,900,000 | 12,607,000,000 | 0000319200 | 0001661920 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 1,213,460 | 1,712,710,900 | 4,279,000,000 | 0000007332 | 0000010048 | 0000773910 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 0 | 1,141,000,000 | 0000007332 | 0001165320 | 0000072207 |
13 | GeneralAndAdministrativeExpense | 0 | 9,793 | 8,937,751 | 333,400,000 | 1,075,000,000 | 0000797468 | 0001165320 | 0000773910 |
14 | Taxes | 0 | 0 | 0 | 140,700,000 | 582,000,000 | 0000010048 | 0001603793 | 0000773910 |
15 | OperatingExpenses | -1,431,000 | 0 | 3,095,501 | 1,890,227,900 | 6,058,000,000 | 0001172139 | 0001368637 | 0000072207 |
16 | remainder_Expenses | -4,750,000,000 | -488,995,600 | 871,297 | 1,555,400,000 | 7,925,000,000 | 0000072207 | 0001462103 | 0000797468 |
17 | remainder_NetIncome | -5,214,000,000 | -254,895,000 | -29,700 | 26,626,500 | 1,024,000,000 | 0000101778 | 0001386018 | 0000797468 |
18 | remainder_ComprehensiveNetIncome | -192,000,000 | -5,792,400 | 0 | 2,347,100 | 165,969,000 | 0000773910 | 0001518403 | 0000717423 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 57,558 | 115,630 | 108,963,000 | 6,099,112,100 | 10,857,000,000 | 0001353722 | 0000010254 | 0000072207 |
1 | Assets | 2,263 | 53,177 | 477,028,940 | 17,450,300,000 | 42,086,000,000 | 0001333519 | 0001659122 | 0000773910 |
2 | Revenues | 0 | 0 | 94,177,278 | 4,475,200,000 | 12,607,000,000 | 0000319200 | 0001661920 | 0000797468 |
3 | Expenses | 36,145 | 104,905 | 147,281,811 | 4,651,500,000 | 12,320,000,000 | 0001333519 | 0001104485 | 0000797468 |
4 | StockholdersEquity | -490,840,550 | -4,954,731 | 154,825,337 | 11,824,140,900 | 38,180,000,000 | 0001104485 | 0001518403 | 0000773910 |
5 | NetIncome | -5,723,000,000 | -266,978,900 | -292,860 | 793,202,300 | 1,311,000,000 | 0000101778 | 0000869495 | 0000797468 |
6 | ComprehensiveNetIncome | -5,702,000,000 | -284,200,000 | -292,860 | 672,101,400 | 1,319,000,000 | 0000101778 | 0000869495 | 0000797468 |
7 | BaseVar | 105,678 | 1,577,944 | 419,455,505 | 16,512,900,000 | 37,692,500,000 | 0001333519 | 0001659122 | 0000797468 |
8 | EconomicCapitalRatio | -15.4 | -2.35 | 0.853 | 2.42 | 2.51 | 0001495648 | 0001528129 | 0001436942 |
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 | LongTermDebt | -5.12 | -1.03 | 0.129 | 0.484 | 0.588 | 0001495648 | 0001503458 | 0001282723 |
1 | LiabilitiesCurrent | -1.20 | -0.672 | 0.185 | 0.663 | 4.36 | 0001397516 | 0000893538 | 0000855787 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.231 | -0.0652 | 0.00743 | 0.0138 | 0.0170 | 0001509991 | 0000061398 | 0001282723 |
3 | remainder_Liabilities | -1.92 | -0.469 | 0.0740 | 0.141 | 0.755 | 0001495648 | 0001353406 | 0001490054 |
4 | PropertyPlantAndEquipment | -11.8 | -1.62 | 0.0555 | 0.764 | 1.40 | 0001495648 | 0001353722 | 0001368637 |
5 | AssetsCurrent | -6.01 | -0.617 | -0.0219 | 0.465 | 0.809 | 0001495648 | 0001001614 | 0000010048 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -10.7 | -1.40 | -0.132 | 0.963 | 1.17 | 0001495648 | 0001288403 | 0001685715 |
7 | remainder_Assets | -2.08 | -0.529 | -0.00309 | 0.644 | 3.53 | 0001495648 | 0001572702 | 0001696088 |
8 | RevenueFromContractWithCustomer | -0.0392 | -0.0111 | -0.00608 | -0.00448 | 0.633 | 0001495648 | 0000864839 | 0001648636 |
9 | GainLossOnDerivatives | -0.152 | -0.00931 | -0.00122 | 0.0106 | 0.0491 | 0001609253 | 0001172139 | 0000874499 |
10 | remainder_Revenues | -1.42 | -0.411 | -0.0315 | 0.565 | 5.22 | 0001495648 | 0000077877 | 0001442492 |
11 | DepreciationDepletionAndAmortization | -0.650 | -0.107 | -0.00526 | 0.107 | 0.482 | 0001609253 | 0001588216 | 0001495648 |
12 | CostOfGoodsAndServicesSold | -0.0827 | 0.00143 | 0.00195 | 0.00355 | 0.0125 | 0001353406 | 0000864839 | 0001495648 |
13 | GeneralAndAdministrativeExpense | -0.906 | -0.374 | 0.0586 | 0.0863 | 0.327 | 0001165320 | 0000056868 | 0001442492 |
14 | Taxes | -0.195 | -0.0404 | 0.00755 | 0.0144 | 0.0560 | 0001609253 | 0001368637 | 0001495648 |
15 | OperatingExpenses | -13.5 | -0.801 | 0.148 | 0.267 | 0.784 | 0001495648 | 0001696088 | 0001442492 |
16 | remainder_Expenses | -6.91 | -0.391 | -0.00883 | 0.504 | 1.93 | 0001442492 | 0000077877 | 0001495648 |
17 | remainder_NetIncome | -1.95 | -0.0658 | 0.0282 | 0.195 | 0.574 | 0001490054 | 0001333519 | 0000316736 |
18 | remainder_ComprehensiveNetIncome | -0.0286 | -0.0150 | -0.000654 | 0.00412 | 0.210 | 0000056868 | 0001518403 | 0001495648 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -6.32 | -0.707 | 0.140 | 1.15 | 2.83 | 0001495648 | 0001685715 | 0000855787 |
1 | Assets | -14.3 | -2.13 | -0.0310 | 0.228 | 0.378 | 0001495648 | 0001157806 | 0001368637 |
2 | Revenues | -1.47 | -0.399 | -0.0267 | 0.555 | 5.17 | 0001495648 | 0000315852 | 0001442492 |
3 | Expenses | -11.9 | -1.73 | 0.0810 | 0.277 | 0.309 | 0001495648 | 0000056868 | 0000319200 |
4 | StockholdersEquity | -7.38 | -3.46 | -0.00726 | 1.23 | 1.43 | 0001495648 | 0001361937 | 0000319200 |
5 | NetIncome | -13.3 | -1.28 | 0.0876 | 0.483 | 0.600 | 0001495648 | 0001001614 | 0001282723 |
6 | ComprehensiveNetIncome | -13.1 | -1.28 | 0.106 | 0.482 | 0.599 | 0001495648 | 0001442492 | 0001282723 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000007332 | 0001172139 | 0000007332 |
8 | EconomicCapitalRatio | -15.9 | -2.90 | 0.304 | 1.87 | 1.96 | 0001495648 | 0001528129 | 0001436942 |
2018
Logs
error | 4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 12 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 8 × Similarly named company. Duplicate? | None | |
warning | 7 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Missing logo | subcommand.report | |
warning | 2 × Large missing amount for aggregate "Assets" added to remainder. | industry.us_generic | |
warning | 2 × Ignoring company because Expenses is zero | pre-agg | |
warning | 2 × Ignoring company because Assets is zero | pre-agg | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.77894031971633}
|
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -292000000}
|
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Expenses in unusual place in relation to revenue | input.sec.calculation_linkbase.edgar_model_mapping |
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 | LongTermDebt | 0 | 0 | 1,294,372 | 4,340,000,000 | 7,739,000,000 | 0000006769 | 0001581552 | 0000072207 |
1 | LiabilitiesCurrent | 0 | 56,988 | 47,389,588 | 2,182,500,000 | 7,412,000,000 | 0000061398 | 0000894627 | 0000797468 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 22,426,000 | 477,179,000 | 0000006769 | 0000775057 | 0001509991 |
3 | remainder_Liabilities | 0 | 0 | 0 | 950,586,000 | 1,933,440,000 | 0000006769 | 0000894627 | 0000033213 |
4 | PropertyPlantAndEquipment | 0 | 0 | 53,550,130 | 17,333,656,300 | 31,437,000,000 | 0000006769 | 0000894627 | 0000797468 |
5 | AssetsCurrent | 0 | 183,545 | 44,605,147 | 2,518,966,400 | 9,932,000,000 | 0001490054 | 0000894627 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 6,939,686,200 | 22,005,000,000 | 0000007332 | 0000867038 | 0001358071 |
7 | remainder_Assets | -19,433,000,000 | -1,094,250,100 | 4,087,690 | 1,433,900,000 | 7,966,000,000 | 0001358071 | 0001500305 | 0000773910 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 0 | 5,409,900,000 | 17,824,000,000 | 0000010048 | 0000793306 | 0000797468 |
9 | GainLossOnDerivatives | -292,000,000 | -23,237,000 | 0 | 40,556,200 | 415,000,000 | 0001038357 | 0001282648 | 0001157806 |
10 | remainder_Revenues | -662,000,000 | 0 | 2,512,278 | 1,387,479,800 | 10,231,000,000 | 0000773910 | 0001165320 | 0000895126 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 501,284 | 1,830,298,100 | 4,254,000,000 | 0000083350 | 0000867038 | 0000773910 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 51,586,299 | 1,697,001,000 | 0000007332 | 0000793306 | 0000033213 |
13 | GeneralAndAdministrativeExpense | 0 | 0 | 11,399,040 | 309,800,000 | 1,084,000,000 | 0000101594 | 0000894627 | 0000773910 |
14 | Taxes | 0 | 0 | 0 | 148,800,000 | 826,000,000 | 0000006769 | 0000793306 | 0000773910 |
15 | OperatingExpenses | 0 | 0 | 23,498,193 | 1,901,500,000 | 4,635,000,000 | 0000010048 | 0001527709 | 0000072207 |
16 | remainder_Expenses | -3,390,000,000 | -380,585,900 | 96,997 | 2,523,200,000 | 10,608,000,000 | 0000072207 | 0000727538 | 0000797468 |
17 | remainder_NetIncome | -1,134,000,000 | -209,990,100 | 0 | 73,000,000 | 1,632,000,000 | 0000773910 | 0001368637 | 0001358071 |
18 | remainder_ComprehensiveNetIncome | -246,000,000 | -41,148,700 | 0 | 625,800 | 144,000,000 | 0000006769 | 0001527709 | 0000797468 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 116,693 | 427,420 | 128,034,556 | 7,427,682,500 | 10,526,000,000 | 0001500305 | 0001346980 | 0000072207 |
1 | Assets | 10,240 | 1,562,155 | 480,833,302 | 21,289,900,000 | 43,854,000,000 | 0000855787 | 0001437557 | 0000797468 |
2 | Revenues | 0 | 17,811 | 118,120,047 | 6,517,700,000 | 17,960,000,000 | 0000869495 | 0000056868 | 0000797468 |
3 | Expenses | 58,338 | 675,433 | 103,551,957 | 6,769,509,200 | 15,134,000,000 | 0001342936 | 0001384195 | 0000797468 |
4 | StockholdersEquity | -1,048,622,000 | -1,564,876 | 216,356,851 | 14,140,679,600 | 36,442,000,000 | 0001022646 | 0001527709 | 0000797468 |
5 | NetIncome | -2,007,158,000 | -125,327,300 | 14,006,484 | 971,989,500 | 4,513,000,000 | 0000033213 | 0000072207 | 0001358071 |
6 | ComprehensiveNetIncome | -2,248,419,000 | -125,327,300 | 14,006,484 | 971,989,500 | 4,513,000,000 | 0000033213 | 0000072207 | 0001358071 |
7 | BaseVar | 196,820 | 1,946,133 | 451,452,326 | 20,398,450,000 | 42,904,500,000 | 0001342936 | 0001384195 | 0000797468 |
8 | EconomicCapitalRatio | -4.61 | -1.78 | 0.962 | 2.23 | 4.44 | 0001386018 | 0000101778 | 0000793306 |
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 | LongTermDebt | -1.33 | -0.744 | 0.134 | 0.454 | 1.35 | 0001022646 | 0000315852 | 0000793306 |
1 | LiabilitiesCurrent | -2.15 | -0.553 | 0.145 | 0.473 | 9.47 | 0000793306 | 0000072207 | 0001386018 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.170 | -0.0231 | 0.00654 | 0.0113 | 0.0342 | 0001509991 | 0001600470 | 0000793306 |
3 | remainder_Liabilities | -1.50 | -0.633 | 0.107 | 0.214 | 0.922 | 0001141197 | 0001572702 | 0001490054 |
4 | PropertyPlantAndEquipment | -2.64 | -0.866 | -0.0129 | 0.649 | 0.843 | 0001442492 | 0000352955 | 0001539838 |
5 | AssetsCurrent | -1.51 | -0.322 | -0.0305 | 0.297 | 1.92 | 0001442492 | 0001696088 | 0000775057 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -2.40 | -1.57 | -0.0785 | 0.871 | 1.07 | 0001437491 | 0001288403 | 0001603793 |
7 | remainder_Assets | -0.617 | -0.464 | 0.00757 | 0.654 | 2.75 | 0001509991 | 0001038357 | 0001658566 |
8 | RevenueFromContractWithCustomer | -1.23 | -0.277 | -0.152 | 0.446 | 0.887 | 0001442492 | 0001362705 | 0001288403 |
9 | GainLossOnDerivatives | -0.0320 | -0.0124 | -0.00185 | 0.0164 | 0.142 | 0001038357 | 0001168054 | 0001104485 |
10 | remainder_Revenues | -0.509 | -0.282 | -0.178 | 0.649 | 7.34 | 0001437491 | 0001506742 | 0001442492 |
11 | DepreciationDepletionAndAmortization | -0.165 | -0.113 | 0.00444 | 0.101 | 0.464 | 0001288403 | 0001282723 | 0001442492 |
12 | CostOfGoodsAndServicesSold | -0.151 | -0.0727 | 0.00994 | 0.0157 | 0.0693 | 0001533924 | 0000867038 | 0001442492 |
13 | GeneralAndAdministrativeExpense | -1.10 | -0.261 | 0.0382 | 0.0892 | 0.276 | 0001165320 | 0001384195 | 0001442492 |
14 | Taxes | -0.0734 | -0.0271 | 0.00804 | 0.0142 | 0.0629 | 0001282723 | 0001509991 | 0001442492 |
15 | OperatingExpenses | -4.14 | -0.516 | 0.0792 | 0.302 | 1.14 | 0001437491 | 0000056868 | 0001442492 |
16 | remainder_Expenses | -7.68 | -0.646 | 0.0402 | 0.442 | 0.614 | 0001442492 | 0000869495 | 0001603793 |
17 | remainder_NetIncome | -1.29 | -0.368 | 0.0243 | 0.115 | 1.09 | 0001490054 | 0000867038 | 0001141197 |
18 | remainder_ComprehensiveNetIncome | -0.0241 | -0.00340 | 0.000659 | 0.00255 | 0.00893 | 0000717423 | 0000867038 | 0000010048 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.973 | -0.613 | 0.0286 | 0.873 | 3.25 | 0001022646 | 0000894627 | 0000855787 |
1 | Assets | -3.55 | -2.47 | -0.00817 | 0.245 | 1.20 | 0001386018 | 0000315131 | 0000793306 |
2 | Revenues | -0.966 | -0.402 | -0.0111 | 0.487 | 6.10 | 0001437491 | 0001255474 | 0001442492 |
3 | Expenses | -5.68 | -0.963 | 0.0629 | 0.306 | 0.999 | 0001442492 | 0001462103 | 0000793306 |
4 | StockholdersEquity | -8.21 | -2.12 | -0.0675 | 1.17 | 1.43 | 0001442492 | 0001506742 | 0000869495 |
5 | NetIncome | -4.95 | -1.75 | 0.123 | 0.602 | 4.70 | 0001437491 | 0001539838 | 0000793306 |
6 | ComprehensiveNetIncome | -4.94 | -1.75 | 0.119 | 0.606 | 4.70 | 0001437491 | 0000717423 | 0000793306 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006769 | 0001255474 | 0000006769 |
8 | EconomicCapitalRatio | -5.40 | -2.57 | 0.170 | 1.43 | 3.65 | 0001386018 | 0000101778 | 0000793306 |
2019
Logs
error | 3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
warning | 10 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 7 × Similarly named company. Duplicate? | None | |
warning | 5 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 5 × Ignoring company because Assets is zero | pre-agg | |
warning | 2 × Missing logo | subcommand.report | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.1652473172780535}
|
warning | 1 × No LiabilitiesAndStockholdersEquity node found | input.sec.calculation_linkbase.edgar_model_mapping | |
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -361000000}
|
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.Absolute xval/yval quantiles
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | LongTermDebt | 0 | 0 | 3,648,933 | 4,484,082,800 | 9,400,000,000 | 0000006769 | 0001648636 | 0000895126 |
1 | LiabilitiesCurrent | 0 | 153,238 | 100,201,978 | 2,400,000,000 | 14,949,000,000 | 0001703785 | 0000010254 | 0000797468 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 190,239,600 | 702,104,000 | 0000006769 | 0001108827 | 0000858470 |
3 | remainder_Liabilities | -4,078,258,000 | 0 | 0 | 411,584,000 | 2,590,223,000 | 0001022646 | 0000798949 | 0000033213 |
4 | PropertyPlantAndEquipment | 0 | 0 | 155,548,400 | 15,383,898,000 | 80,469,000,000 | 0000077877 | 0001362705 | 0000797468 |
5 | AssetsCurrent | 0 | 242,941 | 69,785,898 | 1,887,400,000 | 18,681,000,000 | 0000855787 | 0000894627 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 6,846,894,400 | 20,890,000,000 | 0000006769 | 0000066418 | 0001358071 |
7 | remainder_Assets | -18,540,000,000 | -1,493,651,600 | 5,951,944 | 1,254,800,000 | 10,180,000,000 | 0001358071 | 0001346980 | 0000797468 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 3,940,522 | 4,686,200,000 | 9,671,000,000 | 0000010048 | 0001648636 | 0001038357 |
9 | GainLossOnDerivatives | -361,000,000 | -61,600,000 | 0 | 14,385,600 | 616,634,000 | 0001792580 | 0001659122 | 0000033213 |
10 | remainder_Revenues | -401,000,000 | 0 | 701,068 | 1,591,295,600 | 20,610,000,000 | 0001038357 | 0001789832 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 10,631,032 | 2,053,306,400 | 5,981,000,000 | 0000083350 | 0001527709 | 0000797468 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 601,513,600 | 4,803,589,000 | 0000010048 | 0001141197 | 0000821483 |
13 | GeneralAndAdministrativeExpense | 0 | 0 | 20,786,405 | 332,000,000 | 489,000,000 | 0000101594 | 0000943861 | 0001792580 |
14 | Taxes | 0 | 0 | 0 | 187,200,000 | 707,000,000 | 0000006769 | 0000868082 | 0000797468 |
15 | OperatingExpenses | 0 | 0 | 36,692,658 | 1,587,635,200 | 5,757,000,000 | 0000010048 | 0000315852 | 0000072207 |
16 | remainder_Expenses | -4,524,000,000 | -294,358,800 | 8,290,632 | 2,853,652,200 | 7,328,000,000 | 0000072207 | 0001442492 | 0000797468 |
17 | remainder_NetIncome | -608,000,000 | -249,491,000 | -32,888 | 76,035,200 | 1,213,000,000 | 0000895126 | 0001572702 | 0000797468 |
18 | remainder_ComprehensiveNetIncome | -1,148,000,000 | -23,736,200 | 0 | 8,440,000 | 141,000,000 | 0001090012 | 0001555082 | 0000006769 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 238,622 | 733,878 | 251,310,701 | 8,274,727,800 | 14,949,000,000 | 0001342936 | 0001437557 | 0000797468 |
1 | Assets | 10,000 | 1,248,917 | 878,455,485 | 19,302,600,000 | 109,330,000,000 | 0000855787 | 0001533924 | 0000797468 |
2 | Revenues | 0 | 117,946 | 236,637,800 | 6,258,200,000 | 20,610,000,000 | 0000798949 | 0001346980 | 0000797468 |
3 | Expenses | 37,081 | 766,943 | 252,717,842 | 6,337,600,000 | 22,345,000,000 | 0001490054 | 0001621434 | 0000797468 |
4 | StockholdersEquity | -844,814,000 | -872,622 | 435,064,308 | 12,600,776,200 | 94,381,000,000 | 0001022646 | 0001533924 | 0000797468 |
5 | NetIncome | -3,682,000,000 | -1,223,048,400 | -265,605 | 350,160,000 | 1,253,302,000 | 0000006769 | 0000083350 | 0000717423 |
6 | ComprehensiveNetIncome | -3,541,000,000 | -1,259,908,000 | -347,599 | 330,000,000 | 1,288,928,000 | 0000006769 | 0001694617 | 0000717423 |
7 | BaseVar | 174,760 | 1,859,092 | 907,444,475 | 19,253,100,000 | 84,320,500,000 | 0001342936 | 0001661920 | 0000797468 |
8 | EconomicCapitalRatio | -3.95 | -1.17 | 0.773 | 1.97 | 2.21 | 0001437491 | 0000077877 | 0001745797 |
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 | LongTermDebt | -12.6 | -0.682 | 0.0514 | 0.524 | 0.759 | 0001022646 | 0001655020 | 0000793306 |
1 | LiabilitiesCurrent | -1.31 | -0.387 | 0.132 | 0.389 | 1.73 | 0001022646 | 0001168054 | 0001437491 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.429 | -0.0738 | 0.0165 | 0.0296 | 0.0514 | 0001006655 | 0001724965 | 0000793306 |
3 | remainder_Liabilities | -1.22 | -0.490 | 0.0792 | 0.143 | 0.895 | 0001603793 | 0001724965 | 0001022646 |
4 | PropertyPlantAndEquipment | -2.56 | -0.948 | 0.0370 | 0.613 | 1.37 | 0001442492 | 0000352955 | 0000798949 |
5 | AssetsCurrent | -1.23 | -0.277 | -0.0528 | 0.297 | 1.99 | 0001442492 | 0001462103 | 0000775057 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -2.26 | -0.865 | -0.0959 | 0.940 | 1.28 | 0001442492 | 0001609253 | 0001346980 |
7 | remainder_Assets | -0.961 | -0.453 | 0.0554 | 0.756 | 3.32 | 0001437557 | 0001001614 | 0001658566 |
8 | RevenueFromContractWithCustomer | -1.22 | -0.365 | 0.000261 | 0.400 | 1.78 | 0001442492 | 0001603793 | 0000821483 |
9 | GainLossOnDerivatives | -0.0940 | -0.0144 | 0.00196 | 0.00748 | 0.0462 | 0001527709 | 0001659122 | 0000033213 |
10 | remainder_Revenues | -0.423 | -0.277 | -0.163 | 0.570 | 5.97 | 0000821483 | 0001490054 | 0001442492 |
11 | DepreciationDepletionAndAmortization | -0.234 | -0.153 | -0.00276 | 0.154 | 0.465 | 0001349436 | 0000023194 | 0001442492 |
12 | CostOfGoodsAndServicesSold | -4.14 | -0.0953 | 0.0344 | 0.0605 | 0.201 | 0000793306 | 0001509589 | 0001442492 |
13 | GeneralAndAdministrativeExpense | -1.87 | -0.198 | 0.0369 | 0.106 | 0.324 | 0000855787 | 0001658566 | 0001442492 |
14 | Taxes | -0.0609 | -0.0306 | 0.00998 | 0.0224 | 0.0639 | 0001282723 | 0001490054 | 0001442492 |
15 | OperatingExpenses | -2.71 | -0.653 | 0.104 | 0.282 | 0.953 | 0001437491 | 0001602065 | 0001442492 |
16 | remainder_Expenses | -6.22 | -0.754 | 0.0451 | 0.418 | 2.24 | 0001442492 | 0001527709 | 0000855787 |
17 | remainder_NetIncome | -0.478 | -0.106 | 0.00684 | 0.0967 | 1.51 | 0001490054 | 0000727538 | 0000855787 |
18 | remainder_ComprehensiveNetIncome | -0.152 | -0.00533 | 0.00470 | 0.00963 | 0.0264 | 0000077159 | 0001659122 | 0001442492 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.968 | -0.541 | 0.0896 | 0.811 | 1.39 | 0001022646 | 0000867038 | 0001490054 |
1 | Assets | -3.52 | -1.39 | 0.00575 | 0.231 | 0.329 | 0000855787 | 0001600470 | 0000798949 |
2 | Revenues | -0.893 | -0.353 | -0.00584 | 0.371 | 4.77 | 0000855787 | 0001273441 | 0001442492 |
3 | Expenses | -4.22 | -1.57 | 0.105 | 0.294 | 0.420 | 0001442492 | 0000033213 | 0001490054 |
4 | StockholdersEquity | -6.52 | -2.50 | -0.0529 | 1.09 | 1.43 | 0001442492 | 0000033213 | 0000352955 |
5 | NetIncome | -2.69 | -0.926 | 0.114 | 0.354 | 0.607 | 0001437491 | 0000797468 | 0001442492 |
6 | ComprehensiveNetIncome | -2.68 | -0.920 | 0.116 | 0.341 | 0.633 | 0001437491 | 0001509991 | 0001442492 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006769 | 0001273441 | 0000006769 |
8 | EconomicCapitalRatio | -4.65 | -1.87 | 0.0697 | 1.26 | 1.51 | 0001437491 | 0000077877 | 0001745797 |
2020
Logs
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
error | 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. | pre-agg | |
warning | 12 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 6 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 3 × Similarly named company. Duplicate? | None | |
warning | 2 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -281000000}
{'var_name': 'Taxes', 'min_value': -630000} |
warning | 2 × Missing logo | subcommand.report | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.640212268224008}
|
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 | LongTermDebt | 0 | 0 | 3,052,758 | 4,640,425,800 | 8,189,000,000 | 0000006769 | 0001726126 | 0001792580 |
1 | LiabilitiesCurrent | 52,948 | 247,472 | 74,513,542 | 1,719,600,000 | 8,223,000,000 | 0001761534 | 0001509589 | 0000797468 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 444,652,600 | 1,371,967,000 | 0000006769 | 0000056868 | 0000033213 |
3 | remainder_Liabilities | 0 | 0 | 0 | 356,751,750 | 2,293,480,000 | 0000006769 | 0000727538 | 0000874499 |
4 | PropertyPlantAndEquipment | 0 | 0 | 66,545,777 | 12,101,150,400 | 65,889,000,000 | 0000077877 | 0001006655 | 0000797468 |
5 | AssetsCurrent | 0 | 291,967 | 50,840,002 | 1,466,000,000 | 8,819,000,000 | 0001761534 | 0001349436 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 3,944,114,400 | 14,439,000,000 | 0000006769 | 0001792580 | 0001038357 |
7 | remainder_Assets | -3,177,000,000 | -587,275,200 | 10,302,318 | 1,148,414,800 | 5,356,000,000 | 0001090012 | 0000867038 | 0000797468 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 3,826,051 | 3,113,722,000 | 7,024,000,000 | 0000006769 | 0000868082 | 0001038357 |
9 | GainLossOnDerivatives | -281,000,000 | 0 | 0 | 184,734,600 | 507,000,000 | 0001038357 | 0000793306 | 0001792580 |
10 | remainder_Revenues | -127,000,000 | 0 | 485,845 | 802,920,200 | 17,927,000,000 | 0000101778 | 0000893538 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 11,929,200 | 1,718,800,000 | 8,097,000,000 | 0000083350 | 0001172358 | 0000797468 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 183,734,400 | 2,947,697,000 | 0000006769 | 0000007332 | 0000821483 |
13 | GeneralAndAdministrativeExpense | 0 | 5,387 | 18,456,792 | 262,000,000 | 864,000,000 | 0001070412 | 0001282648 | 0000797468 |
14 | Taxes | -630,000 | 0 | 0 | 89,120,200 | 622,000,000 | 0001725526 | 0000010048 | 0000797468 |
15 | OperatingExpenses | 0 | 0 | 25,940,831 | 1,943,297,600 | 5,681,000,000 | 0000010048 | 0001006655 | 0000797468 |
16 | remainder_Expenses | -2,246,721,000 | -194,649,600 | 27,735,032 | 4,778,400,000 | 12,069,000,000 | 0000732834 | 0000315131 | 0000797468 |
17 | remainder_NetIncome | -3,017,000,000 | -272,495,200 | 0 | 89,450,600 | 276,137,000 | 0000797468 | 0001462103 | 0000893538 |
18 | remainder_ComprehensiveNetIncome | -460,900,000 | -30,068,800 | 0 | 1,265,400 | 42,000,000 | 0001789832 | 0001572702 | 0000006769 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 106,552 | 1,227,180 | 163,610,831 | 7,261,229,600 | 10,632,000,000 | 0001761534 | 0000943861 | 0001792580 |
1 | Assets | 25.0 | 1,761,252 | 565,503,827 | 16,424,639,200 | 80,064,000,000 | 0001761534 | 0001657788 | 0000797468 |
2 | Revenues | 0 | 459,209 | 144,556,141 | 3,981,479,600 | 17,927,000,000 | 0001341726 | 0000010254 | 0000797468 |
3 | Expenses | 40,536 | 1,279,640 | 309,236,701 | 7,065,000,000 | 29,741,000,000 | 0001761534 | 0001071993 | 0000797468 |
4 | StockholdersEquity | -847,291,000 | -57,275,000 | 128,663,805 | 10,258,200,000 | 71,841,000,000 | 0001655020 | 0001349436 | 0000797468 |
5 | NetIncome | -14,831,000,000 | -2,935,600,000 | -48,176,125 | 31,420,800 | 484,900,000 | 0000797468 | 0000894627 | 0001789832 |
6 | ComprehensiveNetIncome | -14,898,000,000 | -2,945,400,000 | -52,379,723 | 23,146,800 | 201,588,000 | 0000797468 | 0000023194 | 0000858470 |
7 | BaseVar | 73,556 | 4,092,421 | 595,702,227 | 16,815,964,800 | 69,519,500,000 | 0001761534 | 0001657788 | 0000797468 |
8 | EconomicCapitalRatio | -3.68 | -1.64 | 0.384 | 1.95 | 2.51 | 0000855787 | 0001520006 | 0001172358 |
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 | LongTermDebt | -0.904 | -0.673 | 0.0495 | 0.453 | 0.500 | 0001789832 | 0000887396 | 0001172358 |
1 | LiabilitiesCurrent | -1.24 | -0.626 | 0.154 | 0.422 | 3.87 | 0001362705 | 0000893538 | 0000855787 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.391 | -0.122 | 0.0179 | 0.0338 | 0.0432 | 0001006655 | 0001349436 | 0001172358 |
3 | remainder_Liabilities | -0.893 | -0.364 | 0.111 | 0.207 | 0.868 | 0000874499 | 0000943861 | 0001603793 |
4 | PropertyPlantAndEquipment | -1.57 | -0.946 | -0.0835 | 0.800 | 1.18 | 0000855787 | 0000727538 | 0001602065 |
5 | AssetsCurrent | -0.697 | -0.355 | -0.0816 | 0.382 | 1.76 | 0000855787 | 0000033213 | 0000775057 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -1.91 | -0.997 | -0.262 | 0.988 | 1.34 | 0001309082 | 0000101778 | 0001658566 |
7 | remainder_Assets | -1.12 | -0.442 | 0.122 | 0.688 | 1.76 | 0001309082 | 0001539838 | 0001341726 |
8 | RevenueFromContractWithCustomer | -0.573 | -0.319 | 0.00883 | 0.403 | 1.19 | 0001442492 | 0000868082 | 0000821483 |
9 | GainLossOnDerivatives | -0.0416 | -0.0144 | -0.00740 | 0.0327 | 0.222 | 0000006769 | 0000066418 | 0001104485 |
10 | remainder_Revenues | -0.237 | -0.186 | -0.115 | 0.458 | 2.81 | 0000821483 | 0000717423 | 0001442492 |
11 | DepreciationDepletionAndAmortization | -0.275 | -0.149 | -0.00105 | 0.118 | 0.252 | 0001603793 | 0001433270 | 0001442492 |
12 | CostOfGoodsAndServicesSold | -2.29 | -0.0899 | 0.0319 | 0.0538 | 0.0958 | 0000793306 | 0001694617 | 0001442492 |
13 | GeneralAndAdministrativeExpense | -0.738 | -0.250 | 0.0543 | 0.0990 | 0.227 | 0001309082 | 0001658566 | 0001442492 |
14 | Taxes | -0.0539 | -0.0238 | 0.00632 | 0.0119 | 0.0211 | 0001621434 | 0000033213 | 0001442492 |
15 | OperatingExpenses | -1.97 | -0.979 | 0.139 | 0.373 | 0.590 | 0001698990 | 0000717423 | 0001442492 |
16 | remainder_Expenses | -2.51 | -0.989 | 0.0427 | 0.701 | 1.06 | 0001442492 | 0000717423 | 0001309082 |
17 | remainder_NetIncome | -0.348 | -0.127 | 0.00404 | 0.153 | 0.204 | 0001353406 | 0000315852 | 0001309082 |
18 | remainder_ComprehensiveNetIncome | -0.168 | -0.00199 | 0.00241 | 0.00506 | 0.0906 | 0001789832 | 0001384195 | 0000010048 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.739 | -0.541 | 0.0952 | 0.896 | 1.99 | 0001362705 | 0001462103 | 0000855787 |
1 | Assets | -2.51 | -1.34 | 0.0129 | 0.318 | 0.400 | 0000855787 | 0001384195 | 0000775057 |
2 | Revenues | -0.418 | -0.260 | -0.0252 | 0.506 | 2.22 | 0000855787 | 0001520006 | 0001442492 |
3 | Expenses | -1.89 | -0.904 | 0.110 | 0.360 | 0.446 | 0001725526 | 0001288403 | 0001789832 |
4 | StockholdersEquity | -2.93 | -2.10 | -0.0901 | 1.31 | 1.56 | 0000855787 | 0001384195 | 0000352955 |
5 | NetIncome | -1.87 | -0.957 | 0.0900 | 0.480 | 0.905 | 0001725526 | 0001694617 | 0001442492 |
6 | ComprehensiveNetIncome | -1.87 | -0.954 | 0.0924 | 0.466 | 0.912 | 0001725526 | 0001705873 | 0001442492 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006769 | 0001156041 | 0000006769 |
8 | EconomicCapitalRatio | -3.97 | -1.93 | 0.0899 | 1.66 | 2.22 | 0000855787 | 0001520006 | 0001172358 |
2021
Logs
error | 1 × No NetIncome node found, ignoring company. | input.sec.calculation_linkbase.edgar_model_mapping | |
error | 1 × Negative Expenses, ignoring company. | pre-agg | |
warning | 10 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 8 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 3 × Similarly named company. Duplicate? | None | |
warning | 3 × Missing logo | subcommand.report | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.595381260318886}
|
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -3775042000}
|
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 | LongTermDebt | 0 | 0 | 5,416,306 | 4,581,287,100 | 6,877,000,000 | 0000006769 | 0000010048 | 0001539838 |
1 | LiabilitiesCurrent | 55,757 | 352,363 | 109,575,018 | 3,081,750,000 | 9,515,953,000 | 0001761534 | 0001282648 | 0000033213 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 327,029,750 | 3,101,000,000 | 0000006769 | 0000066418 | 0000858470 |
3 | remainder_Liabilities | 0 | 0 | 0 | 137,294,650 | 563,890,000 | 0000006769 | 0000928022 | 0000315852 |
4 | PropertyPlantAndEquipment | 0 | 0 | 59,236,340 | 16,680,345,250 | 59,930,000,000 | 0000006769 | 0000793306 | 0000797468 |
5 | AssetsCurrent | 0 | 203,864 | 95,157,150 | 2,366,014,900 | 10,211,000,000 | 0001761534 | 0001273441 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 4,719,233,700 | 28,182,000,000 | 0000006769 | 0001841666 | 0001038357 |
7 | remainder_Assets | -11,768,000,000 | -791,765,050 | 11,175,587 | 3,325,286,100 | 11,998,000,000 | 0001090012 | 0001698990 | 0000006769 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 35,267,587 | 6,735,000,000 | 17,870,000,000 | 0000006769 | 0000315131 | 0001038357 |
9 | GainLossOnDerivatives | -3,775,042,000 | -1,619,423,050 | 0 | 0 | 0 | 0000033213 | 0001657788 | 0000006769 |
10 | remainder_Revenues | -1,044,000,000 | 0 | 173 | 1,219,611,650 | 26,122,000,000 | 0001038357 | 0000727538 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 17,966,002 | 1,864,875,000 | 8,447,000,000 | 0000083350 | 0001362705 | 0000797468 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 280,542,650 | 4,338,474,000 | 0000006769 | 0000101778 | 0000821483 |
13 | GeneralAndAdministrativeExpense | 0 | 93.6 | 22,589,368 | 347,250,000 | 863,000,000 | 0000101594 | 0001789832 | 0000797468 |
14 | Taxes | 0 | 0 | 0 | 278,736,500 | 1,005,000,000 | 0000006769 | 0000033213 | 0000797468 |
15 | OperatingExpenses | 0 | 0 | 35,532,377 | 1,391,800,000 | 5,896,000,000 | 0000010048 | 0001349436 | 0000797468 |
16 | remainder_Expenses | -1,611,980,000 | -268,224,050 | 5,398,666 | 3,804,916,550 | 9,084,000,000 | 0000732834 | 0000315131 | 0001038357 |
17 | remainder_NetIncome | -2,524,000,000 | -470,379,750 | -1,394,946 | 115,451,800 | 477,000,000 | 0000007332 | 0001696088 | 0000797468 |
18 | remainder_ComprehensiveNetIncome | -571,400,000 | -44,184,500 | 0 | 11,916,350 | 80,000,000 | 0001789832 | 0001288403 | 0000797468 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 134,423 | 1,091,662 | 249,896,792 | 8,292,200,000 | 11,561,625,000 | 0001761534 | 0001657788 | 0000033213 |
1 | Assets | 97.0 | 466,876 | 625,705,169 | 20,856,250,000 | 75,036,000,000 | 0001761534 | 0000798949 | 0000797468 |
2 | Revenues | 0 | 0 | 242,854,879 | 6,777,500,000 | 26,122,000,000 | 0000006769 | 0001282648 | 0000797468 |
3 | Expenses | 37,170 | 942,454 | 195,643,495 | 7,047,650,000 | 24,277,000,000 | 0001761534 | 0001362705 | 0000797468 |
4 | StockholdersEquity | -225,120,000 | -8,809,576 | 301,364,187 | 13,082,550,000 | 66,712,000,000 | 0001362705 | 0001273441 | 0000797468 |
5 | NetIncome | -6,672,000,000 | -232,909,050 | 1,262,322 | 1,628,846,800 | 2,833,000,000 | 0001841666 | 0001462103 | 0001090012 |
6 | ComprehensiveNetIncome | -7,004,000,000 | -232,909,050 | 1,145,926 | 1,626,622,800 | 2,808,000,000 | 0001841666 | 0000083350 | 0001090012 |
7 | BaseVar | 85,845 | 2,147,259 | 769,616,174 | 20,183,086,950 | 67,158,000,000 | 0001761534 | 0000844965 | 0000797468 |
8 | EconomicCapitalRatio | -2.77 | -1.60 | 0.871 | 1.93 | 3.02 | 0001761534 | 0001006655 | 0001172358 |
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 | LongTermDebt | -1.12 | -0.686 | 0.0604 | 0.456 | 0.604 | 0001789832 | 0000700764 | 0000798949 |
1 | LiabilitiesCurrent | -1.33 | -0.741 | 0.214 | 0.627 | 1.20 | 0001434737 | 0001433270 | 0000855787 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.379 | -0.109 | 0.0194 | 0.0347 | 0.0460 | 0000858470 | 0000887396 | 0000798949 |
3 | remainder_Liabilities | -0.961 | -0.241 | 0.106 | 0.191 | 0.676 | 0001384195 | 0000315131 | 0001761534 |
4 | PropertyPlantAndEquipment | -0.973 | -0.815 | -0.0253 | 0.810 | 0.950 | 0000855787 | 0000083350 | 0001602065 |
5 | AssetsCurrent | -0.803 | -0.319 | -0.0472 | 0.437 | 1.66 | 0000793306 | 0000066418 | 0000775057 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -1.15 | -0.670 | -0.190 | 0.941 | 1.10 | 0000793306 | 0000867038 | 0001658566 |
7 | remainder_Assets | -0.650 | -0.497 | -0.00602 | 1.07 | 3.30 | 0001509991 | 0001581552 | 0000006769 |
8 | RevenueFromContractWithCustomer | -1.08 | -0.420 | 0.0310 | 0.629 | 1.28 | 0000793306 | 0000717423 | 0000821483 |
9 | GainLossOnDerivatives | -0.308 | -0.178 | 0.0308 | 0.0516 | 0.111 | 0001104485 | 0000010254 | 0000793306 |
10 | remainder_Revenues | -0.342 | -0.241 | -0.153 | 0.688 | 3.28 | 0000821483 | 0000061398 | 0000793306 |
11 | DepreciationDepletionAndAmortization | -0.129 | -0.0990 | -0.0000631 | 0.0878 | 0.225 | 0000797468 | 0001509589 | 0000793306 |
12 | CostOfGoodsAndServicesSold | -3.71 | -0.104 | 0.0368 | 0.0542 | 0.0691 | 0000793306 | 0001789832 | 0000798949 |
13 | GeneralAndAdministrativeExpense | -0.423 | -0.195 | 0.0379 | 0.0836 | 0.210 | 0000855787 | 0000077877 | 0000793306 |
14 | Taxes | -0.0707 | -0.0408 | 0.0112 | 0.0224 | 0.0481 | 0001462103 | 0001165320 | 0000793306 |
15 | OperatingExpenses | -0.865 | -0.454 | 0.0624 | 0.223 | 0.616 | 0001006655 | 0001486159 | 0000793306 |
16 | remainder_Expenses | -1.12 | -0.407 | 0.0216 | 0.314 | 0.533 | 0001442492 | 0000077159 | 0000855787 |
17 | remainder_NetIncome | -0.442 | -0.234 | 0.0376 | 0.109 | 0.426 | 0001282648 | 0001621434 | 0000844965 |
18 | remainder_ComprehensiveNetIncome | -0.181 | -0.00782 | 0.00325 | 0.00920 | 0.0378 | 0001789832 | 0001520006 | 0000798949 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.824 | -0.583 | 0.203 | 0.968 | 1.44 | 0001434737 | 0001001614 | 0001172358 |
1 | Assets | -1.79 | -1.48 | -0.00327 | 0.318 | 0.413 | 0001761534 | 0000056868 | 0000006769 |
2 | Revenues | -0.471 | -0.376 | 0.0117 | 0.649 | 2.31 | 0001841666 | 0001703785 | 0000793306 |
3 | Expenses | -2.48 | -0.476 | 0.0351 | 0.215 | 0.279 | 0000793306 | 0001726126 | 0001602065 |
4 | StockholdersEquity | -2.81 | -2.40 | 0.142 | 1.28 | 1.50 | 0001761534 | 0001282648 | 0001745797 |
5 | NetIncome | -0.840 | -0.529 | 0.0376 | 0.450 | 0.957 | 0001841666 | 0000056868 | 0001172358 |
6 | ComprehensiveNetIncome | -0.880 | -0.526 | 0.0410 | 0.458 | 0.962 | 0001841666 | 0000056868 | 0001172358 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006769 | 0001141197 | 0000006769 |
8 | EconomicCapitalRatio | -3.46 | -2.28 | 0.181 | 1.24 | 2.33 | 0001761534 | 0001006655 | 0001172358 |
2022
Logs
error | 1 × No matching role found | input.sec.calculation_linkbase.expand_agg | |
error | 1 × IME and Company effects mismatched for Revenue from Contract with Customer. IME Effects: 126.0, Company Effect: 125.0 | subcommand.report | |
warning | 9 × Large missing amount for aggregate "Revenues" added to remainder. | industry.us_generic | |
warning | 9 × Large missing amount for aggregate "Expenses" added to remainder. | industry.us_generic | |
warning | 2 × Similarly named company. Duplicate? | None | |
warning | 2 × Missing logo | subcommand.report | |
warning | 1 × Too many companies have an ECR < -100% | check_abs_values |
{'quantile_095_val': -1.8414808801365223}
|
warning | 1 × Negative minimum value | check_abs_values |
{'var_name': 'GainLossOnDerivatives', 'min_value': -4642932000}
|
warning | 1 × Large missing amount for aggregate "Liabilities" added to remainder. | industry.us_generic | |
warning | 1 × Ignoring company because Expenses is zero | pre-agg |
Diagrams
Calculation Linkbase Overview
Edges which exists for less than five companies (and the corresponding nodes) are not included.Absolute xval/yval quantiles
xvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | LongTermDebt | 0 | 0 | 9,194,573 | 4,268,340,300 | 6,734,000,000 | 0000006769 | 0001362705 | 0001539838 |
1 | LiabilitiesCurrent | 0 | 251,819 | 132,195,089 | 3,097,881,700 | 8,900,069,000 | 0000874499 | 0001533924 | 0000033213 |
2 | DeferredIncomeTaxLiabilitiesNet | 0 | 0 | 0 | 493,949,700 | 3,339,000,000 | 0000006769 | 0000077159 | 0000858470 |
3 | remainder_Liabilities | 0 | 0 | 0 | 357,122,500 | 1,653,349,000 | 0000006769 | 0000732834 | 0000874499 |
4 | PropertyPlantAndEquipment | 0 | 0 | 44,660,606 | 17,886,550,000 | 58,384,000,000 | 0000006769 | 0000887396 | 0000797468 |
5 | AssetsCurrent | 138 | 79,044 | 150,759,197 | 2,670,900,000 | 8,886,000,000 | 0001342936 | 0001273441 | 0000797468 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | 0 | 0 | 0 | 5,835,980,750 | 29,630,000,000 | 0000006769 | 0000867038 | 0001038357 |
7 | remainder_Assets | -14,843,000,000 | -714,672,500 | 23,394,644 | 2,787,625,350 | 11,653,000,000 | 0001090012 | 0001384195 | 0000006769 |
8 | RevenueFromContractWithCustomer | 0 | 0 | 48,937,185 | 11,400,345,450 | 24,384,000,000 | 0000006769 | 0000887396 | 0001038357 |
9 | GainLossOnDerivatives | -4,642,932,000 | -1,122,440,350 | 0 | 0 | 0 | 0000033213 | 0001602065 | 0000006769 |
10 | remainder_Revenues | -1,000 | 0 | 187,991 | 2,052,553,300 | 36,787,000,000 | 0001104485 | 0000855787 | 0000797468 |
11 | DepreciationDepletionAndAmortization | 0 | 0 | 18,804,433 | 1,722,536,700 | 6,926,000,000 | 0000083350 | 0001172358 | 0000797468 |
12 | CostOfGoodsAndServicesSold | 0 | 0 | 0 | 368,817,800 | 6,376,014,000 | 0000006769 | 0000077159 | 0000821483 |
13 | GeneralAndAdministrativeExpense | 0 | 0 | 23,885,433 | 399,608,150 | 945,000,000 | 0001001614 | 0000798949 | 0000797468 |
14 | Taxes | 0 | 0 | 0 | 459,850,000 | 1,548,000,000 | 0000006769 | 0000867038 | 0000797468 |
15 | OperatingExpenses | 0 | 0 | 39,477,214 | 1,786,932,700 | 6,990,000,000 | 0000010048 | 0000101594 | 0000797468 |
16 | remainder_Expenses | -1,996,344,000 | -242,311,200 | 8,892,696 | 4,653,650,000 | 12,620,000,000 | 0000732834 | 0000056868 | 0001038357 |
17 | remainder_NetIncome | -5,270,000,000 | -391,339,250 | -26,260 | 171,079,450 | 3,760,853,000 | 0000007332 | 0000066418 | 0000732834 |
18 | remainder_ComprehensiveNetIncome | -694,000,000 | -182,176,450 | 0 | 8,653,500 | 403,000,000 | 0000006769 | 0001603793 | 0000797468 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | 245,387 | 448,143 | 330,803,985 | 7,661,450,000 | 11,456,598,000 | 0001557798 | 0000077159 | 0000033213 |
1 | Assets | 138 | 318,800 | 968,117,266 | 22,042,874,400 | 72,609,000,000 | 0001342936 | 0001657788 | 0000797468 |
2 | Revenues | 0 | 0 | 356,736,221 | 11,476,650,000 | 36,787,000,000 | 0000006769 | 0001282648 | 0000797468 |
3 | Expenses | 46,635 | 944,513 | 231,131,946 | 8,093,600,000 | 24,901,000,000 | 0001342936 | 0000894627 | 0000797468 |
4 | StockholdersEquity | -222,109,000 | -4,292,231 | 477,203,308 | 14,633,000,000 | 64,852,000,000 | 0001362705 | 0001349436 | 0000797468 |
5 | NetIncome | -6,993,000,000 | -41,893,000 | 88,466,183 | 4,388,050,000 | 13,304,000,000 | 0001841666 | 0001001614 | 0000797468 |
6 | ComprehensiveNetIncome | -7,409,000,000 | -41,893,000 | 71,113,917 | 4,273,300,000 | 13,707,000,000 | 0001841666 | 0001789832 | 0000797468 |
7 | BaseVar | 196,229 | 2,028,432 | 941,717,033 | 24,443,181,000 | 71,937,500,000 | 0001342936 | 0000894627 | 0000797468 |
8 | EconomicCapitalRatio | -3.70 | -1.84 | 1.02 | 2.30 | 3.55 | 0001557798 | 0000077877 | 0001172358 |
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 | LongTermDebt | -1.30 | -0.732 | 0.0615 | 0.493 | 0.669 | 0001789832 | 0001362705 | 0001172358 |
1 | LiabilitiesCurrent | -1.29 | -0.686 | 0.323 | 0.848 | 3.02 | 0001362705 | 0000056868 | 0001557798 |
2 | DeferredIncomeTaxLiabilitiesNet | -0.439 | -0.165 | 0.0274 | 0.0625 | 0.0832 | 0000858470 | 0001141197 | 0001172358 |
3 | remainder_Liabilities | -1.62 | -0.465 | 0.108 | 0.209 | 0.297 | 0000874499 | 0000717423 | 0001172358 |
4 | PropertyPlantAndEquipment | -1.49 | -0.818 | -0.00485 | 0.591 | 0.870 | 0001557798 | 0000798949 | 0001384195 |
5 | AssetsCurrent | -0.554 | -0.388 | -0.0377 | 0.217 | 0.542 | 0001500305 | 0001282648 | 0001694617 |
6 | OilAndGasPropertySuccessfulEffortMethodNet | -1.14 | -0.681 | -0.156 | 0.857 | 1.11 | 0001557798 | 0001539838 | 0001658566 |
7 | remainder_Assets | -0.620 | -0.435 | 0.000131 | 1.29 | 3.03 | 0001442492 | 0000066418 | 0000006769 |
8 | RevenueFromContractWithCustomer | -0.937 | -0.563 | 0.0605 | 0.759 | 1.52 | 0001500305 | 0001602065 | 0000821483 |
9 | GainLossOnDerivatives | -0.446 | -0.171 | 0.0311 | 0.0517 | 0.0719 | 0000874499 | 0000010254 | 0000821483 |
10 | remainder_Revenues | -0.393 | -0.262 | -0.161 | 0.783 | 1.85 | 0000821483 | 0001495648 | 0001462103 |
11 | DepreciationDepletionAndAmortization | -0.129 | -0.0962 | -0.00379 | 0.0914 | 0.140 | 0000077159 | 0001621434 | 0001500305 |
12 | CostOfGoodsAndServicesSold | -2.09 | -0.122 | 0.0294 | 0.0470 | 0.0655 | 0000821483 | 0000867038 | 0001500305 |
13 | GeneralAndAdministrativeExpense | -1.19 | -0.246 | 0.0569 | 0.105 | 0.201 | 0001557798 | 0001273441 | 0001500305 |
14 | Taxes | -0.131 | -0.0476 | 0.0148 | 0.0290 | 0.0420 | 0001462103 | 0001141197 | 0000821483 |
15 | OperatingExpenses | -1.59 | -0.518 | 0.0723 | 0.265 | 0.352 | 0001557798 | 0001602065 | 0000821483 |
16 | remainder_Expenses | -1.38 | -0.501 | 0.00697 | 0.394 | 1.39 | 0001500305 | 0001657788 | 0001557798 |
17 | remainder_NetIncome | -0.486 | -0.192 | -0.00639 | 0.305 | 0.564 | 0000007332 | 0000887396 | 0001437491 |
18 | remainder_ComprehensiveNetIncome | -0.219 | -0.0326 | -0.00694 | -0.00430 | 2.32 | 0000077159 | 0001273441 | 0001500305 |
yvar | min | 5% | median | 95% | max | min_company | median_company | max_company | |
---|---|---|---|---|---|---|---|---|---|
0 | Liabilities | -0.948 | -0.635 | 0.248 | 1.20 | 1.81 | 0001309082 | 0001006655 | 0001172358 |
1 | Assets | -2.41 | -1.36 | -0.00420 | 0.273 | 0.624 | 0001557798 | 0000727538 | 0001141197 |
2 | Revenues | -1.25 | -0.549 | 0.0524 | 0.580 | 1.21 | 0001500305 | 0000056868 | 0001462103 |
3 | Expenses | -1.27 | -0.585 | 0.0358 | 0.247 | 0.363 | 0001500305 | 0000083350 | 0001349436 |
4 | StockholdersEquity | -2.76 | -2.23 | 0.181 | 1.33 | 1.69 | 0001495648 | 0000033213 | 0000352955 |
5 | NetIncome | -2.53 | -0.833 | 0.107 | 0.576 | 1.32 | 0001500305 | 0000010048 | 0001172358 |
6 | ComprehensiveNetIncome | -1.97 | -0.703 | 0.0880 | 0.569 | 1.31 | 0001557798 | 0001433270 | 0001172358 |
7 | BaseVar | nan | nan | nan | nan | nan | 0000006769 | 0001141197 | 0000006769 |
8 | EconomicCapitalRatio | -4.49 | -2.63 | 0.227 | 1.51 | 2.76 | 0001557798 | 0000077877 | 0001172358 |
Estimates
Parameter | Value | Min | Max |
---|---|---|---|
PresentValueFactor | 1.0 | 1.0 | 15.0 |
BalanceFactor | 1.11 | 0.5 | 5.0 |
OCIFactor | 1.0 | 0.5 | 1.0 |
HiddenReservesFactor | 0.0 | 0.0 | 0.0 |
LLPO_stddev | 0.31 | 0.2 | 10.0 |