QA: us_petrol 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
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
0001514994 0000855787
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001621434
warning 6 × Ignoring company because Assets is zero pre-agg
0000006769 0001359699 0001510949 0001588238 0001624644 0001433270
warning 4 × Similarly named company. Duplicate? None
0001353722 0001353748 0001436942 0001462103
warning 3 × Ignoring company because Expenses is zero pre-agg
0000033213 0000056868 0001422295
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
0001333519 0000868082
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001490054 0001621434
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
0000855787
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
0001621434
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0000319200

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
0000895126 0001621434
error 1 × Negative Expenses, ignoring company. pre-agg
0001282648
error 1 × IME and Company effects mismatched for Oil and Gas Property. IME Effects: 35.3, Company Effect: 35.2 subcommand.report
0001353722
warning 5 × Similarly named company. Duplicate? None
0001658566 0001353722 0001353748 0001436942 0001462103
warning 3 × Ignoring company because Expenses is zero pre-agg
0000006769 0000033213 0001108827
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
0001333519 0000868082
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
0001609253
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
0001108827
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001621434
warning 1 × Ignoring company because Assets is zero pre-agg
0001433270
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0000319200

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
0001621434 0001657788 0001705873 0001172358
warning 12 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000056868 0000874499 0001104485 0001362705 0001527709 0001555082 0001572702 0001584952 0001594466 0001657788 0001705873 0001725526
warning 8 × Similarly named company. Duplicate? None
0001503458 0001555082 0001594466 0001658566 0000727538 0001353722 0001436942 0001462103
warning 7 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000007332 0000895126 0000945764 0001038357 0001528129 0001539838 0001705873
warning 2 × Missing logo subcommand.report
0001594466 0000868082
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
0001621434 0001657788
warning 2 × Ignoring company because Expenses is zero pre-agg
0001090012 0001108827
warning 2 × Ignoring company because Assets is zero pre-agg
0001486159 0001433270
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
0000928022
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping
0001358071

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
0001539838 0001657788 0001172358
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
0000887396
warning 10 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000056868 0000077159 0000874499 0001104485 0001527709 0001539838 0001555082 0001594466 0001657788 0001725526
warning 7 × Similarly named company. Duplicate? None
0001555082 0001594466 0001658566 0001745797 0000727538 0001436942 0001462103
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000010048 0000895126 0000945764 0001038357 0001705873
warning 5 × Ignoring company because Assets is zero pre-agg
0000874499 0001486159 0001705873 0001761534 0001433270
warning 2 × Missing logo subcommand.report
0001594466 0000868082
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
0000887396
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
0001022646
warning 1 × Ignoring company because Expenses is zero pre-agg
0000869495

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
0001342936
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
0001434737
warning 12 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000006769 0000056868 0000077159 0000352955 0000867665 0000874499 0001070412 0001104485 0001572702 0001657788 0001724965 0001725526
warning 6 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000010048 0000315852 0000844965 0000858470 0001038357 0001433270
warning 3 × Similarly named company. Duplicate? None
0001658566 0001745797 0000727538
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
0001761534 0000868082
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
0001342936
error 1 × Negative Expenses, ignoring company. pre-agg
0000352955
warning 10 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000007332 0000010048 0000315852 0000844965 0001038357 0001090012 0001433270 0001486159 0001528129 0001705873
warning 8 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000056868 0000077159 0000352955 0000867665 0001070412 0001104485 0001657788 0001724965
warning 3 × Similarly named company. Duplicate? None
0001658566 0001745797 0000727538
warning 3 × Missing logo subcommand.report
0001434737 0001557798 0001761534
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
0001495648

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
0001367408
error 1 × IME and Company effects mismatched for Revenue from Contract with Customer. IME Effects: 126.0, Company Effect: 125.0 subcommand.report
0000798949
warning 9 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
0000056868 0000077159 0000352955 0000867665 0000874499 0001070412 0001462103 0001657788 0001724965
warning 9 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
0000007332 0000010048 0000315852 0000844965 0001038357 0001090012 0001433270 0001486159 0001705873
warning 2 × Similarly named company. Duplicate? None
0001658566 0000727538
warning 2 × Missing logo subcommand.report
0001434737 0001557798
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
0000855787
warning 1 × Ignoring company because Expenses is zero pre-agg
0001445109

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