QA: us_recreation 2010-2023

Table of Contents

Ranks across the years

name name_short 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2010-val 2011-val 2012-val 2013-val 2014-val 2015-val 2016-val 2017-val 2018-val 2019-val 2020-val 2021-val 2022-val 2023-val 2010->2011 2011->2012 2012->2013 2013->2014 2014->2015 2015->2016 2016->2017 2017->2018 2018->2019 2019->2020 2020->2021 2021->2022 2022->2023
0001090396 Table TRAC INC Table T NaN 11 10 9 7 17 14 10 23 7 1 2 2 1 NaN 31.855447 90.651255 149.615890 109.909220 23.774171 76.419932 118.072100 -665.096790 150.235340 256.916410 300.038440 290.795250 309.740170 NaN -1 -1 -2 10 -3 -4 13 -16 -6 1 0 -1
0000811532 Cedar FAIR L P Cedar F NaN 1 2 NaN NaN NaN NaN NaN NaN NaN 25 5 1 2 NaN 243.090810 271.987740 NaN NaN NaN NaN NaN NaN NaN -206.344260 148.637440 423.552740 275.275390 NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN -20 -4 1
0001795250 Sphere Entertainment Co Sphere NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 15 8 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 163.707240 55.790381 114.523500 260.629500 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 9 -7 -5
0001744489 Walt Disney Co Walt Di NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 4 3 4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 175.505380 205.315890 216.367680 202.570810 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 -1 1
0001071255 Golden Entertainment INC Golden NaN 9 NaN 2 16 9 12 17 14 13 15 9 13 5 NaN 96.450725 NaN 327.097260 13.100687 144.968260 112.130570 35.039549 24.405438 10.402540 -33.632394 85.658588 65.927285 170.110380 NaN NaN NaN 14 -7 3 5 -3 -1 2 -6 4 -8
0001708341 Allied Gaming Entertainment Inc Allied NaN NaN NaN NaN NaN NaN NaN NaN NaN 17 NaN 1 NaN 6 NaN NaN NaN NaN NaN NaN NaN NaN NaN -61.173653 NaN 800.124380 NaN 157.510880 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001297937 Parks America INC Parks A NaN NaN NaN NaN NaN NaN NaN 7 6 2 3 3 4 7 NaN NaN NaN NaN NaN NaN NaN 220.088020 264.038920 271.437770 214.834010 241.987380 174.440270 132.310930 NaN NaN NaN NaN NaN NaN NaN -1 -4 1 0 1 3
0001335258 Live Nation Entertainment Inc Live Na NaN NaN NaN 13 10 11 11 13 10 9 12 14 9 8 NaN NaN NaN 105.993950 106.775130 116.411810 112.466560 96.538339 101.222370 121.334730 -5.568033 60.573912 99.132800 104.654570 NaN NaN NaN -3 1 0 2 -3 -1 3 2 -5 -1
0000015847 Butler National CORP Butler NaN NaN 7 15 9 10 9 8 9 4 7 10 6 9 NaN NaN 132.519210 91.691080 107.634590 127.379240 126.912910 168.373730 164.066570 230.782600 85.929626 80.876950 143.883370 91.998122 NaN NaN 8 -6 1 -1 -1 1 -5 3 3 -4 3
0001824403 Reservoir Media Inc Reservo NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 10 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 97.035887 76.266751 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0
0001698991 Accel Entertainment Inc Accel E NaN NaN NaN NaN NaN NaN NaN NaN NaN 12 11 11 11 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.953321 19.527773 68.143629 87.378084 57.501673 NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 0 0 0
0000812011 VAIL Resorts INC VAIL Re NaN 3 NaN NaN NaN 2 3 3 5 3 8 13 12 12 NaN 220.119500 NaN NaN NaN 224.802820 222.307820 246.710770 264.874010 239.138430 52.305181 64.496774 75.628229 56.599600 NaN NaN NaN NaN NaN 1 0 2 -2 5 5 -1 0
0001869198 Life Time Group Holdings Inc Life Ti NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 22 17 13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -6.199241 48.130637 55.734476 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -5 -4
0001793659 Rush Street Interactive Inc Rush St NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 20 8 21 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -76.111011 113.808620 15.014715 53.659908 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -12 13 -7
0001318568 Everi Holdings Inc Everi H NaN 10 11 14 14 23 22 21 17 14 14 12 16 15 NaN 55.801780 85.499786 97.503302 22.157930 -24.867061 -98.686006 -27.327131 -5.267372 10.034141 -29.378879 65.496253 49.104614 36.221801 NaN 1 3 0 9 -1 -1 -4 -3 0 -2 4 -1
0001319161 Warner Music Group Corp Warner NaN NaN 12 NaN 17 22 18 18 15 NaN 16 17 20 16 NaN NaN 13.393675 NaN -23.262719 -8.485634 2.547872 23.843278 20.603924 NaN -37.697007 24.168058 29.934401 34.901561 NaN NaN NaN NaN 5 -4 0 -3 NaN NaN 1 3 -4
0001840572 Lucky Strike Entertainment Corp Lucky S NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 23 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 7.567637 31.086955 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -6
0001952073 Madison Square Garden Entertainment Corp Madison NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 29 18 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -45.736957 21.152704 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -11
0001637207 Planet Fitness Inc Planet NaN NaN NaN NaN NaN 18 19 19 16 15 17 26 22 19 NaN NaN NaN NaN NaN 12.756932 -14.729606 0.100521 -1.953816 -14.252673 -44.599851 -25.727242 8.165247 18.729916 NaN NaN NaN NaN NaN 1 0 -3 -1 2 9 -4 -3
0000701374 Six Flags Entertainment Corp OLD Six Fla NaN 4 1 16 12 14 15 15 12 11 23 NaN 25 20 NaN 204.680510 358.842850 78.871346 49.946915 61.593764 42.462989 57.749602 50.006427 22.572060 -100.930130 NaN 5.107549 -9.401073 NaN -3 15 -4 2 1 0 -3 -1 12 NaN NaN -5
0001636519 Madison Square Garden Sports Corp Madison NaN NaN NaN NaN NaN 13 8 11 8 8 21 24 24 21 NaN NaN NaN NaN NaN 86.729264 127.393870 116.463910 166.263390 144.963650 -91.840917 -23.396172 6.047512 -12.346368 NaN NaN NaN NaN NaN -5 3 -3 0 13 3 0 -3
0001708176 Hall of Fame Resort Entertainment Co Hall of NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 18 29 26 22 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -61.505345 -93.155616 1.568904 -51.230253 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 -3 -4
0001703073 Vivic CORP Vivic C NaN NaN NaN NaN NaN NaN NaN NaN 22 NaN 29 NaN 33 23 NaN NaN NaN NaN NaN NaN NaN NaN -597.825580 NaN -590.076770 NaN -168.918970 -77.486240 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -10
0001883685 Draftkings Inc Draftki NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 32 24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -161.149420 -87.368926 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -8
0001816554 Eventiko INC Eventik NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 32 43 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -268.697800 -1925.204200 -291.509480 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 -18
0001674227 Scworx Corp Scworx NaN NaN NaN NaN NaN NaN 21 27 25 23 26 31 28 26 NaN NaN NaN NaN NaN NaN -55.945135 -907.806260 -1114.363700 -761.622800 -399.530540 -195.264760 -15.286491 -360.564070 NaN NaN NaN NaN NaN NaN 6 -2 -2 3 5 -3 -2
0001389518 Clubhouse Media Group Inc Clubhou NaN 14 17 20 18 24 23 NaN NaN NaN NaN 39 40 27 NaN -7.250852 -52.880713 -39.449403 -28.410314 -33.323003 -217.802190 NaN NaN NaN NaN -2083.284300 -960.311980 -488.483880 NaN 3 3 -2 6 -1 NaN NaN NaN NaN NaN 1 -13
0001584693 Healthcare Integrated Technologies Inc Healthc NaN NaN NaN NaN NaN NaN NaN NaN NaN 22 30 35 36 28 NaN NaN NaN NaN NaN NaN NaN NaN NaN -704.741410 -724.134810 -712.961100 -523.615870 -614.377390 NaN NaN NaN NaN NaN NaN NaN NaN NaN 8 5 1 -8
0001621672 Super League Enterprise Inc Super L NaN NaN NaN NaN NaN NaN NaN NaN NaN 26 36 18 44 29 NaN NaN NaN NaN NaN NaN NaN NaN NaN -1834.317300 -976.002820 16.747194 -2028.605700 -709.792950 NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 -18 26 -15
0000055234 Kenilworth Systems CORP Kenilwo NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 20 27 30 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.003630 0.164244 -892.130020 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 7 3
0001106213 Seafarer Exploration CORP Seafare NaN NaN NaN NaN 27 NaN NaN NaN NaN 24 37 NaN 41 31 NaN NaN NaN NaN -1552.245700 NaN NaN NaN NaN -1046.950200 -1465.095100 NaN -1417.524300 -1078.792500 NaN NaN NaN NaN NaN NaN NaN NaN NaN 13 NaN NaN -10
0001829966 EBET Inc EBET In NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 36 35 32 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -731.096540 -430.507620 -1231.441400 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 -3
0001803977 Limitless X Holdings Inc Limitle NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 33 37 34 33 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -860.028640 -805.724170 -396.625870 -1482.514500 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 -3 -1
0001001039 TWDC Enterprises 18 Corp TWDC En 1 2 3 3 2 1 2 2 4 NaN NaN NaN NaN NaN 238.27444 238.100270 240.806920 283.094430 257.604630 254.578550 251.333030 253.728250 293.384500 NaN NaN NaN NaN NaN 1 1 0 -1 -1 1 0 2 NaN NaN NaN NaN NaN
0001076195 LIFE TIME Fitness INC LIFE TI 2 7 8 11 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN 115.07740 118.664780 127.048310 119.516320 94.266911 NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 1 3 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000277058 Nevada GOLD Casinos INC Nevada NaN 8 15 12 5 4 10 9 NaN NaN NaN NaN NaN NaN NaN 107.412420 -16.955061 109.137200 125.897810 174.579720 125.034210 132.435950 NaN NaN NaN NaN NaN NaN NaN 7 -3 -7 -1 6 -1 NaN NaN NaN NaN NaN NaN
0000796764 Premier Exhibitions INC Premier NaN 15 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -185.933650 -6.253263 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000894847 Carlyle Gaming Entertainment Ltd Carlyle NaN 16 18 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -230.770950 -260.065280 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000896400 Everi Games Holding INC Everi G NaN 6 5 5 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 144.196740 232.380740 254.219360 247.971280 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 0 -2 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000914577 Trans World CORP Trans W NaN 5 4 6 6 8 4 6 NaN NaN NaN NaN NaN NaN NaN 167.381790 235.863570 212.036580 124.932350 147.584290 190.147890 230.970130 NaN NaN NaN NaN NaN NaN NaN -1 2 0 2 -4 2 NaN NaN NaN NaN NaN NaN
0001017673 Dover Motorsports LLC Dover M NaN 12 9 10 8 5 7 5 7 5 2 NaN NaN NaN NaN 7.998009 117.094220 120.760880 108.778390 168.276170 160.261480 235.256670 246.236630 215.213540 238.767550 NaN NaN NaN NaN -3 1 -2 -3 2 -2 2 -2 -3 NaN NaN NaN
0001114208 Nightculture Inc Nightcu NaN 17 NaN 1 23 26 NaN NaN NaN NaN NaN NaN NaN NaN NaN -400.635930 NaN 628.567990 -376.247270 -529.328180 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 22 3 NaN NaN NaN NaN NaN NaN NaN NaN
0001265848 US VR Global com Inc US VR G NaN 22 21 22 28 27 25 25 NaN NaN NaN NaN NaN NaN NaN -6880.552800 -1118.668800 -191.549060 -5524.114600 -804.537970 -683.167830 -726.283110 NaN NaN NaN NaN NaN NaN NaN -1 1 6 -1 -2 0 NaN NaN NaN NaN NaN NaN
0001281774 TOWN Sports International Holdings INC TOWN Sp NaN 13 13 18 22 21 20 20 NaN NaN NaN NaN NaN NaN NaN 7.380375 -2.126800 2.850768 -110.283930 -5.191318 -23.736230 -25.417104 NaN NaN NaN NaN NaN NaN NaN 0 5 4 -1 -1 0 NaN NaN NaN NaN NaN NaN
0001322952 TRUE BLUE Holdings INC TRUE BL NaN 19 NaN 24 NaN 12 5 NaN NaN NaN NaN NaN NaN NaN NaN -787.000190 NaN -438.230730 NaN 107.027970 183.050000 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -7 NaN NaN NaN NaN NaN NaN NaN
0001407704 Lingerie Fighting Championships INC Lingeri NaN 18 20 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -472.631190 -929.764850 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001444839 Bravo Multinational Inc Bravo M NaN 21 23 NaN NaN NaN 28 NaN 24 NaN NaN 34 38 NaN NaN -2290.382100 -1517.737900 NaN NaN NaN -949.158430 NaN -946.256060 NaN NaN -607.018120 -565.474780 NaN NaN 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 NaN
0001508332 Trophy Hunting Unlimited Inc Trophy NaN 20 19 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1638.544200 -755.508240 -605.265870 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 6 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000831489 Scores Holding CO INC Scores NaN NaN 16 7 1 7 24 26 NaN NaN NaN NaN NaN NaN NaN NaN -35.901027 185.283280 751.669610 155.461840 -502.897650 -822.209600 NaN NaN NaN NaN NaN NaN NaN NaN -9 -6 6 17 2 NaN NaN NaN NaN NaN NaN
0001418372 Salamander Innisbrook LLC Salaman NaN NaN 6 8 4 6 6 14 NaN NaN 10 6 7 NaN NaN NaN 154.930130 164.242040 137.530560 158.975340 167.784890 75.179069 NaN NaN 25.754988 128.055480 137.065590 NaN NaN NaN 2 -4 2 0 8 NaN NaN NaN -4 1 NaN
0001532158 Rebel Group Inc Rebel G NaN NaN 22 23 NaN NaN 27 12 27 27 NaN NaN NaN NaN NaN NaN -1353.899300 -353.097360 NaN NaN -940.817990 116.055430 -3895.880100 -2686.950600 NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN -15 15 0 NaN NaN NaN NaN
0000013573 BOWL America INC BOWL Am NaN NaN NaN 4 NaN NaN 1 4 3 1 NaN NaN NaN NaN NaN NaN NaN 265.446300 NaN NaN 252.326680 239.734790 293.905200 282.505910 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 -1 -2 NaN NaN NaN NaN
0001308569 Major League Football INC Major L NaN NaN NaN 27 NaN 29 NaN 29 19 20 28 33 NaN NaN NaN NaN NaN -877.883170 NaN -2456.023400 NaN -1496.297900 -365.123120 -429.211740 -565.516790 -282.190410 NaN NaN NaN NaN NaN NaN NaN NaN NaN -10 1 8 5 NaN NaN
0001326917 Sputnik Enterprises Inc Sputnik NaN NaN NaN 28 25 NaN 29 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1435.238700 -1098.506000 NaN -991.485230 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001445831 Newpoint Financial Corp Newpoin NaN NaN NaN 26 NaN NaN 31 NaN 21 21 NaN 21 37 NaN NaN NaN NaN -831.333170 NaN NaN -1536.335000 NaN -497.954180 -474.071020 NaN -1.138643 -529.236880 NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN 16 NaN
0001553588 SFX Entertainment INC SFX Ent NaN NaN NaN 19 20 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -36.134164 -81.773186 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001564902 United Parks Resorts Inc United NaN NaN NaN 17 13 15 16 22 13 10 19 16 18 NaN NaN NaN NaN 48.721248 46.471046 42.064115 24.325865 -32.736649 31.025735 32.505572 -66.628564 48.922376 37.261149 NaN NaN NaN NaN -4 2 1 6 -9 -3 9 -3 2 NaN
0001587755 Intrawest Resorts Holdings Inc Intrawe NaN NaN NaN 21 19 20 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -175.028780 -62.230632 5.074071 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 1 NaN NaN NaN NaN NaN NaN NaN NaN
0000013156 Galaxy Gaming Inc Galaxy NaN NaN NaN NaN 15 16 13 16 11 16 22 25 30 NaN NaN NaN NaN NaN 20.529950 32.804490 90.213479 42.320787 90.773227 -53.236628 -100.032190 -24.737565 -63.174789 NaN NaN NaN NaN NaN 1 -3 3 -5 5 6 3 5 NaN
0001551906 WEST Coast Ventures Group CORP WEST Co NaN NaN NaN NaN 26 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1216.756200 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001570279 Double Down Holdings Inc Double NaN NaN NaN NaN 21 25 26 24 20 19 NaN NaN NaN NaN NaN NaN NaN NaN -83.402263 -174.900330 -886.898080 -708.101090 -411.681820 -278.774500 NaN NaN NaN NaN NaN NaN NaN NaN 4 1 -2 -4 -1 NaN NaN NaN NaN
0001572384 Phoenix Rising Companies Phoenix NaN NaN NaN NaN 24 3 NaN NaN NaN 6 35 NaN NaN NaN NaN NaN NaN NaN -600.061860 216.787490 NaN NaN NaN 211.957560 -937.645590 NaN NaN NaN NaN NaN NaN NaN -21 NaN NaN NaN NaN 29 NaN NaN NaN
0001451448 Esports Entertainment Group INC Esports NaN NaN NaN NaN NaN 28 30 23 NaN NaN 27 28 39 NaN NaN NaN NaN NaN NaN -1408.328100 -1385.642700 -657.090640 NaN NaN -524.924860 -53.862641 -852.415770 NaN NaN NaN NaN NaN NaN 2 -7 NaN NaN NaN 1 11 NaN
0001577095 Clubcorp Holdings Inc Clubcor NaN NaN NaN NaN NaN 19 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 7.890630 10.519011 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 NaN NaN NaN NaN NaN NaN NaN
0001622996 ACRO Biomedical CO LTD ACRO Bi NaN NaN NaN NaN NaN NaN 32 NaN 2 18 9 40 45 NaN NaN NaN NaN NaN NaN NaN -2456.237300 NaN 436.760910 -126.799530 41.138251 -8890.873100 -18364.019000 NaN NaN NaN NaN NaN NaN NaN NaN NaN 16 -9 31 5 NaN
0001318482 Kidoz INC Kidoz I NaN NaN NaN NaN NaN NaN NaN 28 26 25 5 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN -1458.614600 -2919.900000 -1166.897400 175.404950 118.733110 NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 -1 -20 2 NaN NaN
0001592411 DKG Capital Inc DKG Cap NaN NaN NaN NaN NaN NaN NaN 1 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 592.210930 500.657030 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN
0001286459 ALL FOR ONE Media CORP ALL FOR NaN NaN NaN NaN NaN NaN NaN NaN 18 NaN 31 NaN 31 NaN NaN NaN NaN NaN NaN NaN NaN NaN -225.145120 NaN -769.973530 NaN -133.287780 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000725929 B2Digital Inc B2Digit NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 32 38 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -814.819700 -810.531440 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 NaN NaN
0001379043 Xtreme Fighting Championships INC Xtreme NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 34 23 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -888.920580 -22.704882 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -11 NaN NaN
0001758488 Onespaworld Holdings Ltd Onespaw NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 24 NaN 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -192.098800 NaN 144.727390 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001772757 Draftkings Holdings Inc Draftki NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 13 30 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -23.373404 -185.316460 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 17 NaN NaN
0001766363 Endeavor Group Holdings Inc Endeavo NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 19 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 8.265345 54.362483 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN
0001802156 Xponential Fitness Inc Xponent NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 27 19 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -47.456035 33.028486 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -8 NaN
0001839360 FaZe Holdings Inc FaZe Ho NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 42 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1853.895300 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001856031 Vivid Seats Inc Vivid S NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 62.686366 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

PDF reports

All reports for 2023 are collected in a single PDF for easier review.

2010

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 12 × The stock price does not exist industry.us_generic
warning 7 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 2 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '2 of 2'}
{'var_name': 'CostOfGoodsAndServicesSold', 'zeros': '2 of 2'}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Missing logo subcommand.report
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 1 × Ignoring company because 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 AssetsCurrent 76,904,000 684,308,800 6,152,166,810 11,617,595,200 12,225,000,000 0001076195 0001001039 0001001039
1 PropertyPlantAndEquipment 1,570,234,000 2,382,022,300 9,689,740,577 16,994,211,700 17,806,000,000 0001076195 0001001039 0001001039
2 LeaseAsset 0 0 0 0 0 0001001039 0001076195 0001001039
3 AssetsNonCurrent 0 125,650,000 1,256,751,300 2,387,350,000 2,513,000,000 0001076195 0001001039 0001001039
4 IntangibleAssets 13,322,000 1,471,705,900 14,600,077,768 27,722,616,100 29,181,000,000 0001076195 0001001039 0001001039
5 remainder_Assets 58,020,000 429,169,000 3,770,252,298 7,109,851,000 7,481,000,000 0001076195 0001001039 0001001039
6 LiabilitiesCurrent 133,417,000 676,746,150 5,567,795,158 10,456,670,850 11,000,000,000 0001076195 0001001039 0001001039
7 LiabilitiesNonCurrent 0 30,627,200 306,333,254 581,916,800 612,544,000 0001001039 0001076195 0001076195
8 remainder_Liabilities 0 6,597,050 65,983,694 125,343,950 131,941,000 0001001039 0001076195 0001076195
9 SellingGeneralAndAdministrativeExpense 0 1,354,900 13,551,710 25,743,100 27,098,000 0001001039 0001076195 0001076195
10 GeneralAndAdministrativeExpense 0 2,403,000 24,034,806 45,657,000 48,060,000 0001001039 0001076195 0001076195
11 CostOfGoodsAndServicesSold 0 0 0 0 0 0001001039 0001076195 0001001039
12 DepreciationAndAmortization 0 4,615,650 46,165,731 87,697,350 92,313,000 0001001039 0001076195 0001076195
13 OperatingExpenses 0 1,177,200 11,774,354 22,366,800 23,544,000 0001001039 0001076195 0001076195
14 remainder_Expenses 614,518,000 2,300,292,100 17,475,630,548 32,644,225,900 34,330,000,000 0001076195 0001001039 0001001039
15 remainder_Revenues 912,844,000 2,770,351,800 19,491,637,016 36,205,492,200 38,063,000,000 0001076195 0001001039 0001001039
16 remainder_NetIncome -26,619,000 3,711,950 276,751,162 549,669,050 580,000,000 0001076195 0001001039 0001001039
17 remainder_ComprehensiveNetIncome -249,000,000 -236,550,000 -124,475,100 -12,450,000 0 0001001039 0001076195 0001076195
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 1,718,480,000 5,092,856,000 35,468,988,752 65,831,624,000 69,206,000,000 0001076195 0001001039 0001001039
1 Liabilities 877,902,000 1,384,006,900 5,939,963,210 10,493,895,100 11,000,000,000 0001076195 0001001039 0001001039
2 Expenses 805,533,000 2,481,756,350 17,571,118,947 32,653,776,650 34,330,000,000 0001076195 0001001039 0001001039
3 Revenues 912,844,000 2,770,351,800 19,491,637,016 36,205,492,200 38,063,000,000 0001076195 0001001039 0001001039
4 StockholdersEquity 840,578,000 3,708,849,100 29,529,025,542 55,337,728,900 58,206,000,000 0001076195 0001001039 0001001039
5 NetIncome 80,692,000 292,307,400 2,197,269,231 4,101,384,600 4,313,000,000 0001076195 0001001039 0001001039
6 ComprehensiveNetIncome 80,692,000 279,857,400 2,072,744,331 3,864,834,600 4,064,000,000 0001076195 0001001039 0001001039
7 BaseVar 5,817,730,640 17,014,243,108 117,805,248,345 218,551,467,532 229,747,980,000 0001076195 0001001039 0001001039
8 EconomicCapitalRatio 1.15 1.21 1.77 2.32 2.38 0001076195 0001001039 0001001039

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 AssetsCurrent -0.0604 -0.0569 -0.0248 0.00721 0.0108 0001076195 0001001039 0001001039
1 PropertyPlantAndEquipment -0.0383 -0.0170 0.175 0.366 0.387 0001001039 0001076195 0001076195
2 LeaseAsset 0 0 0 0 0 0001001039 0001076195 0001001039
3 AssetsNonCurrent -0.0171 -0.0161 -0.00712 0.00183 0.00282 0001076195 0001001039 0001001039
4 IntangibleAssets -0.173 -0.162 -0.0671 0.0280 0.0386 0001076195 0001001039 0001001039
5 remainder_Assets -0.0348 -0.0327 -0.0144 0.00389 0.00593 0001076195 0001001039 0001001039
6 LiabilitiesCurrent -0.183 -0.169 -0.0411 0.0867 0.101 0001001039 0001076195 0001076195
7 LiabilitiesNonCurrent -0.496 -0.439 0.0758 0.590 0.648 0001076195 0001001039 0001001039
8 remainder_Liabilities -0.0967 -0.0841 0.0294 0.143 0.155 0001076195 0001001039 0001001039
9 SellingGeneralAndAdministrativeExpense -0.0541 -0.0479 0.00754 0.0630 0.0691 0001076195 0001001039 0001001039
10 GeneralAndAdministrativeExpense -0.0959 -0.0850 0.0134 0.112 0.123 0001076195 0001001039 0001001039
11 CostOfGoodsAndServicesSold 0 0 0 0 0 0001001039 0001076195 0001001039
12 DepreciationAndAmortization -0.184 -0.163 0.0257 0.214 0.235 0001076195 0001001039 0001001039
13 OperatingExpenses -0.0470 -0.0416 0.00655 0.0547 0.0600 0001076195 0001001039 0001001039
14 remainder_Expenses -0.650 -0.592 -0.0706 0.450 0.508 0001001039 0001076195 0001076195
15 remainder_Revenues -0.102 -0.0902 0.0142 0.118 0.130 0001076195 0001001039 0001001039
16 remainder_NetIncome -0.0824 -0.0730 0.0115 0.0960 0.105 0001076195 0001001039 0001001039
17 remainder_ComprehensiveNetIncome -0.0161 -0.0146 -0.00175 0.0111 0.0126 0001001039 0001076195 0001076195
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.00916 -0.00863 -0.00383 0.000962 0.00149 0001076195 0001001039 0001001039
1 Liabilities -0.484 -0.428 0.0758 0.580 0.636 0001076195 0001001039 0001001039
2 Expenses -0.163 -0.148 -0.0177 0.113 0.127 0001001039 0001076195 0001076195
3 Revenues -0.102 -0.0902 0.0142 0.118 0.130 0001076195 0001001039 0001001039
4 StockholdersEquity -0.312 -0.277 0.0435 0.364 0.399 0001076195 0001001039 0001001039
5 NetIncome -0.0569 -0.0504 0.00793 0.0663 0.0727 0001076195 0001001039 0001001039
6 ComprehensiveNetIncome -0.0443 -0.0393 0.00618 0.0516 0.0567 0001076195 0001001039 0001001039
7 BaseVar nan nan nan nan nan 0001001039 0001076195 0001001039
8 EconomicCapitalRatio -0.616 -0.554 0.000123 0.554 0.616 0001076195 0001001039 0001001039

2011

Logs

error 5 × Unusually strong effect check_effects
{'var_name': 'Assets', 'quantile_value': '-11.4', 'quantile': 0.05}
{'var_name': 'Expenses', 'quantile_value': '-10.2', 'quantile': 0.05}
{'var_name': 'NetIncome', 'quantile_value': '-17.6', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-17.5', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-17.5', 'quantile': 0.05}
error 4 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 16 × No stock price available subcommand.plot
warning 13 × The stock price does not exist industry.us_generic
warning 8 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 8 × Missing logo subcommand.report
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '22 of 22'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -22.57790220207131}
warning 1 × Similarly named company. Duplicate? None
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
warning 1 × 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 AssetsCurrent 0 492 5,095,262 306,333,750 13,757,000,000 0001318568 0000914577 0001001039
1 PropertyPlantAndEquipment 0 0 8,877,286 1,735,316,850 19,695,000,000 0000894847 0000796764 0001001039
2 LeaseAsset 0 0 0 0 0 0000277058 0001017673 0000277058
3 AssetsNonCurrent 0 0 0 0 2,435,000,000 0000277058 0001017673 0001001039
4 IntangibleAssets 0 0 4,559,577 989,614,000 29,266,000,000 0001017673 0000914577 0001001039
5 remainder_Assets 0 0 7,754,853 318,491,600 6,971,000,000 0001265848 0001389518 0001001039
6 LiabilitiesCurrent 0 4,337 7,265,903 242,110,350 12,088,000,000 0001318568 0000796764 0001001039
7 LiabilitiesNonCurrent 0 0 0 992,750 686,298,000 0000277058 0001001039 0001076195
8 remainder_Liabilities -1,045,000 0 865,877 335,401,250 369,209,000 0000812011 0001090396 0001318568
9 SellingGeneralAndAdministrativeExpense 0 0 0 35,110,600 42,042,000 0000701374 0000796764 0000896400
10 GeneralAndAdministrativeExpense 0 0 0 25,469,750 54,736,000 0000277058 0000896400 0001076195
11 CostOfGoodsAndServicesSold 0 0 0 19,290,714 33,459,000 0000277058 0000894847 0000796764
12 DepreciationAndAmortization 0 0 33,373 96,477,650 117,957,000 0000811532 0000894847 0000812011
13 OperatingExpenses 0 0 0 67,819,250 397,874,000 0000796764 0000894847 0000701374
14 remainder_Expenses -271,000 -217,713 16,954,848 1,003,864,300 36,295,000,000 0000796764 0000277058 0001001039
15 remainder_Revenues 0 0 31,412,987 1,160,117,300 40,893,000,000 0000894847 0000914577 0001001039
16 remainder_NetIncome -55,121,000 -18,132,950 13,055 123,633,600 660,000,000 0000701374 0000796764 0001001039
17 remainder_ComprehensiveNetIncome -739,000,000 -43,556,250 0 0 48,461 0001001039 0001090396 0001389518
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 465 19,675 49,748,486 2,619,496,950 72,124,000,000 0001508332 0000914577 0001001039
1 Liabilities 3,350 30,540 14,971,625 932,896,650 12,088,000,000 0001265848 0001071255 0001001039
2 Expenses 31,660 120,934 50,510,190 1,115,923,450 36,295,000,000 0001508332 0000796764 0001001039
3 Revenues 0 0 31,412,987 1,160,117,300 40,893,000,000 0000894847 0000914577 0001001039
4 StockholdersEquity -2,527,699 -1,574,370 25,127,407 2,398,663,250 60,036,000,000 0001407704 0000277058 0001001039
5 NetIncome -13,836,000 -12,499,800 -133,690 91,594,050 5,258,000,000 0001071255 0001322952 0001001039
6 ComprehensiveNetIncome -32,575,000 -13,778,100 -162,568 91,594,050 4,519,000,000 0000701374 0001265848 0001001039
7 BaseVar 93,775 424,163 272,249,974 7,019,661,168 245,646,330,000 0001508332 0000796764 0001001039
8 EconomicCapitalRatio -68.8 -22.6 0.200 2.37 2.43 0001265848 0001090396 0000811532

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 AssetsCurrent -3.71 -2.23 -0.0586 0.521 1.26 0001444839 0000277058 0001090396
1 PropertyPlantAndEquipment -44.3 -7.98 -0.258 1.01 1.94 0001265848 0001071255 0001017673
2 LeaseAsset 0 0 0 0 0 0000277058 0001017673 0000277058
3 AssetsNonCurrent -0.681 -0.0687 -0.00261 -0.000178 0.00508 0001265848 0000277058 0001001039
4 IntangibleAssets -29.6 -4.21 -0.0518 0.278 0.330 0001265848 0001322952 0000277058
5 remainder_Assets -39.5 -3.43 -0.0879 1.05 1.22 0001265848 0000701374 0001389518
6 LiabilitiesCurrent -47.1 -3.28 0.813 8.20 13.6 0001265848 0001407704 0001508332
7 LiabilitiesNonCurrent -6.22 -1.08 0.0344 0.0707 0.0717 0001265848 0001090396 0000914577
8 remainder_Liabilities -28.4 -3.51 -0.0922 0.457 0.483 0001265848 0001389518 0000812011
9 SellingGeneralAndAdministrativeExpense -4.39 -3.46 0.492 1.44 4.67 0001407704 0000701374 0001265848
10 GeneralAndAdministrativeExpense -5.76 -2.93 0.646 1.21 4.09 0001322952 0000811532 0001265848
11 CostOfGoodsAndServicesSold -6.72 -2.57 0.498 1.18 4.16 0000796764 0001071255 0001265848
12 DepreciationAndAmortization -0.751 -0.606 0.0862 0.418 1.48 0000796764 0000701374 0001265848
13 OperatingExpenses -64.0 -0.942 0.530 1.16 1.26 0001265848 0001090396 0000796764
14 remainder_Expenses -15.8 -7.95 -0.200 7.04 15.1 0001444839 0000896400 0001265848
15 remainder_Revenues -15.4 -6.19 1.13 2.61 3.94 0001265848 0000701374 0000796764
16 remainder_NetIncome -4.25 -1.30 -0.632 1.91 4.77 0001265848 0000812011 0000896400
17 remainder_ComprehensiveNetIncome -0.564 -0.324 0.0483 0.116 0.377 0001407704 0000811532 0001265848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -55.8 -11.4 0.0541 0.744 1.00 0001265848 0001001039 0001389518
1 Liabilities -50.9 -6.02 0.632 5.82 7.02 0001265848 0000896400 0001508332
2 Expenses -34.6 -10.2 0.883 1.33 1.44 0001265848 0000277058 0000914577
3 Revenues -15.4 -6.19 1.13 2.61 3.94 0001265848 0000701374 0000796764
4 StockholdersEquity -2.93 -2.31 0.423 1.77 1.88 0001508332 0001017673 0000701374
5 NetIncome -54.2 -17.6 1.67 2.88 3.31 0001265848 0000701374 0000914577
6 ComprehensiveNetIncome -53.8 -17.5 1.63 2.94 2.97 0001265848 0000701374 0000914577
7 BaseVar nan nan nan nan nan 0000277058 0001017673 0000277058
8 EconomicCapitalRatio -63.7 -17.5 5.31 7.49 7.54 0001265848 0001090396 0000811532

2012

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
error 3 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
error 3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Unusually strong effect check_effects
{'var_name': 'remainder_Expenses', 'quantile_value': '-12.8', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.6', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
warning 17 × No stock price available subcommand.plot
warning 16 × The stock price does not exist industry.us_generic
warning 14 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 6 × Missing logo subcommand.report
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '23 of 23'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -13.30376222988588}
warning 1 × Similarly named company. Duplicate? None
warning 1 × Large missing amount for aggregate "Revenues" 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 AssetsCurrent 0 1,190 4,778,512 921,447,400 13,709,000,000 0001318568 0001418372 0001001039
1 PropertyPlantAndEquipment 0 0 11,359,998 1,828,002,300 21,512,000,000 0000831489 0000796764 0001001039
2 LeaseAsset 0 0 0 0 0 0000015847 0001076195 0000015847
3 AssetsNonCurrent 0 0 0 0 2,723,000,000 0000015847 0001076195 0001001039
4 IntangibleAssets 0 0 5,404,618 3,591,781,300 30,125,000,000 0000831489 0001418372 0001001039
5 remainder_Assets 0 0 8,185,657 322,687,100 6,829,000,000 0000894847 0000015847 0001001039
6 LiabilitiesCurrent 0 200 6,541,131 1,463,586,300 12,813,000,000 0001318568 0001418372 0001001039
7 LiabilitiesNonCurrent 0 0 0 11,191,500 704,470,000 0000277058 0000914577 0001076195
8 remainder_Liabilities -3,757,000 0 1,467,348 369,923,900 2,728,000,000 0000015847 0001090396 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 129,444,700 1,019,000,000 0000701374 0001265848 0001319161
10 GeneralAndAdministrativeExpense 0 0 3.47 23,513,213 55,715,000 0000015847 0001090396 0001076195
11 CostOfGoodsAndServicesSold 0 0 0 19,148,600 1,459,000,000 0000015847 0000896400 0001319161
12 DepreciationAndAmortization 0 0 211,127 126,106,700 193,000,000 0000831489 0000894847 0001319161
13 OperatingExpenses 0 0 0 447,430,600 528,504,000 0000796764 0001418372 0001318568
14 remainder_Expenses -6,594,000 0 3,396,062 695,223,500 36,971,000,000 0000015847 0001389518 0001001039
15 remainder_Revenues 0 0 36,044,597 2,614,694,700 42,278,000,000 0000894847 0000914577 0001001039
16 remainder_NetIncome -23,993,000 -14,243,400 0 58,553,200 866,000,000 0001076195 0001532158 0001001039
17 remainder_ComprehensiveNetIncome -1,127,000,000 -290,200 0 479,000 20,224,000 0001001039 0001076195 0000701374
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 526 8,179 49,173,031 5,055,839,100 74,898,000,000 0001508332 0000277058 0001001039
1 Liabilities 2,000 7,517 17,964,794 4,000,525,700 12,813,000,000 0001532158 0000015847 0001001039
2 Expenses 22,544 30,379 37,746,582 2,706,441,600 36,971,000,000 0001508332 0000796764 0001001039
3 Revenues 0 0 36,044,597 2,614,694,700 42,278,000,000 0000894847 0000914577 0001001039
4 StockholdersEquity -55,496,000 -2,130,528 22,614,521 2,776,017,200 62,085,000,000 0001281774 0000015847 0001001039
5 NetIncome -109,000,000 -7,737,726 24,706 363,155,500 6,173,000,000 0001319161 0001090396 0001001039
6 ComprehensiveNetIncome -109,000,000 -7,716,826 24,706 381,357,100 5,046,000,000 0001319161 0001090396 0001001039
7 BaseVar 81,498 95,675 214,686,227 18,285,576,754 254,272,280,000 0001508332 0001418372 0001001039
8 EconomicCapitalRatio -15.2 -13.3 0.136 2.69 3.59 0001444839 0001319161 0000701374

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 AssetsCurrent -4.53 -2.88 -0.0749 0.709 31.8 0001444839 0001389518 0001532158
1 PropertyPlantAndEquipment -8.06 -6.05 -0.299 0.933 1.31 0001265848 0001319161 0001017673
2 LeaseAsset 0 0 0 0 0 0000015847 0001076195 0000015847
3 AssetsNonCurrent -0.117 -0.0559 -0.00298 0.000891 0.00465 0001265848 0001318568 0001001039
4 IntangibleAssets -5.93 -3.86 -0.111 0.788 1.14 0001265848 0001017673 0001319161
5 remainder_Assets -5.54 -2.08 -0.0608 0.507 1.59 0001265848 0000015847 0001389518
6 LiabilitiesCurrent -5.23 -2.64 0.578 1.04 21.4 0001265848 0001076195 0001508332
7 LiabilitiesNonCurrent -1.05 -0.869 0.0473 0.0934 0.100 0001076195 0001017673 0000914577
8 remainder_Liabilities -4.09 -3.13 -0.00235 0.916 15.3 0001265848 0000894847 0001407704
9 SellingGeneralAndAdministrativeExpense -4.19 -1.53 0.323 1.25 3.37 0001090396 0001508332 0001265848
10 GeneralAndAdministrativeExpense -9.53 -4.30 0.676 1.86 3.74 0001532158 0001281774 0001265848
11 CostOfGoodsAndServicesSold -2.85 -2.25 0.379 0.906 2.41 0000914577 0001001039 0001265848
12 DepreciationAndAmortization -0.396 -0.391 0.0767 0.493 1.33 0000811532 0001389518 0001265848
13 OperatingExpenses -7.48 -4.91 0.590 1.00 1.60 0000015847 0001407704 0001444839
14 remainder_Expenses -17.8 -12.8 -0.210 3.20 5.69 0001265848 0000896400 0000015847
15 remainder_Revenues -8.88 -5.27 1.37 2.99 6.75 0001444839 0001001039 0001265848
16 remainder_NetIncome -7.21 -0.369 0.0651 0.924 6.39 0001407704 0001418372 0001444839
17 remainder_ComprehensiveNetIncome -0.150 -0.102 -0.0191 0.0493 0.396 0001001039 0000831489 0001407704
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -10.4 -9.12 -0.177 0.406 1.08 0001265848 0001090396 0001389518
1 Liabilities -6.20 -3.96 0.557 4.46 12.5 0001265848 0001318568 0001508332
2 Expenses -9.43 -7.80 0.420 1.14 3.82 0001265848 0000015847 0001407704
3 Revenues -8.88 -5.27 1.37 2.99 6.75 0001444839 0001001039 0001265848
4 StockholdersEquity -2.74 -2.20 0.339 1.80 2.00 0001508332 0000277058 0000701374
5 NetIncome -13.2 -9.78 1.60 2.58 3.12 0001532158 0001076195 0000015847
6 ComprehensiveNetIncome -13.3 -9.77 1.59 2.56 3.09 0001532158 0001076195 0000015847
7 BaseVar nan nan nan nan nan 0000015847 0001076195 0000015847
8 EconomicCapitalRatio -13.4 -11.6 1.87 4.42 5.32 0001444839 0001319161 0000701374

2013

Logs

error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '12.0', 'quantile': 0.95}
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 21 × No stock price available subcommand.plot
warning 20 × The stock price does not exist industry.us_generic
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 8 × Missing logo subcommand.report
warning 4 × Similarly named company. Duplicate? None
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '28 of 28'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -8.615906699279662}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
warning 1 × Ignoring company because Liabilities is zero pre-agg

Diagrams

Calculation Linkbase Overview

Edges which exists for less than five companies (and the corresponding nodes) are not included.

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 432 5,392,178 1,527,917,900 14,109,000,000 0001318568 0000013573 0001001039
1 PropertyPlantAndEquipment 0 0 17,087,310 1,988,325,050 22,380,000,000 0000831489 0001318568 0001001039
2 LeaseAsset 0 0 0 0 0 0000013573 0001114208 0000013573
3 AssetsNonCurrent 0 0 0 0 2,849,000,000 0000013573 0001114208 0001001039
4 IntangibleAssets 0 0 2,061,125 1,740,631,900 34,694,000,000 0000013573 0000015847 0001001039
5 remainder_Assets 0 0 5,645,162 552,070,100 7,209,000,000 0001265848 0000277058 0001001039
6 LiabilitiesCurrent 0 1,050 4,978,632 1,554,529,600 11,704,000,000 0001318568 0000914577 0001001039
7 LiabilitiesNonCurrent 0 0 0 186,109,050 848,598,000 0000013573 0001090396 0001076195
8 remainder_Liabilities -278,403,000 -2,958,150 1,636,642 1,642,074,850 2,021,957,000 0001335258 0001532158 0001587755
9 SellingGeneralAndAdministrativeExpense 0 0 0 156,877,400 1,226,892,000 0000013573 0000831489 0001335258
10 GeneralAndAdministrativeExpense 0 0 0 24,820,839 58,986,000 0000015847 0001318568 0001076195
11 CostOfGoodsAndServicesSold 0 0 0 13,939,174 140,100,000 0000013573 0001076195 0001553588
12 DepreciationAndAmortization 0 0 108,757 149,596,100 368,923,000 0000013573 0001389518 0001335258
13 OperatingExpenses 0 0 0 492,759,800 739,989,000 0000013573 0001017673 0001564902
14 remainder_Expenses -8,315,000 -5,253 8,663,120 3,471,716,600 39,024,000,000 0000015847 0001318568 0001001039
15 remainder_Revenues 0 0 38,342,535 4,722,143,050 45,041,000,000 0001326917 0001071255 0001001039
16 remainder_NetIncome -32,188,000 -19,359,800 0 5,199,650 619,000,000 0001564902 0001322952 0001001039
17 remainder_ComprehensiveNetIncome -21,917,000 -3,648,200 0 4,023,028 1,579,000,000 0000701374 0001071255 0001001039
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 287 1,013 46,797,336 4,607,023,550 81,241,000,000 0001326917 0001418372 0001001039
1 Liabilities 3,000 54,714 16,520,237 2,216,649,100 11,704,000,000 0001265848 0001389518 0001001039
2 Expenses 25,779 36,568 35,287,984 4,719,948,350 39,024,000,000 0001508332 0001418372 0001001039
3 Revenues 0 0 38,342,535 4,722,143,050 45,041,000,000 0001326917 0001071255 0001001039
4 StockholdersEquity -1,018,746,000 -29,125,555 25,651,526 2,630,012,100 69,537,000,000 0001587755 0000277058 0001001039
5 NetIncome -296,714,000 -89,839,550 119,199 144,566,650 6,636,000,000 0001587755 0000831489 0001001039
6 ComprehensiveNetIncome -300,750,000 -86,000,150 119,199 130,320,600 8,215,000,000 0001587755 0000831489 0001001039
7 BaseVar 103,833 172,162 243,633,687 27,864,329,841 269,893,670,000 0001508332 0001071255 0001001039
8 EconomicCapitalRatio -14.4 -8.62 0.946 3.12 6.29 0001326917 0001318568 0001114208

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 AssetsCurrent -2.84 -1.84 -0.0716 1.00 1.71 0001326917 0000914577 0001532158
1 PropertyPlantAndEquipment -3.38 -2.59 -0.0917 1.25 1.52 0001326917 0001071255 0001114208
2 LeaseAsset 0 0 0 0 0 0000013573 0001114208 0000013573
3 AssetsNonCurrent -0.0368 -0.0196 -0.00229 0.000329 0.0134 0001265848 0001553588 0001114208
4 IntangibleAssets -1.98 -1.67 -0.0646 0.757 2.70 0001265848 0001418372 0001553588
5 remainder_Assets -1.95 -1.63 -0.0855 0.639 1.74 0001265848 0001076195 0001389518
6 LiabilitiesCurrent -1.20 -0.106 0.932 12.0 15.4 0001389518 0000015847 0001326917
7 LiabilitiesNonCurrent -1.11 -0.657 0.0446 0.118 0.484 0001076195 0001281774 0001114208
8 remainder_Liabilities -2.26 -1.13 0.259 1.08 3.33 0001326917 0001071255 0001114208
9 SellingGeneralAndAdministrativeExpense -2.79 -2.02 0.409 1.87 5.38 0001532158 0000015847 0001265848
10 GeneralAndAdministrativeExpense -8.16 -3.98 0.600 1.74 3.22 0001445831 0001553588 0001265848
11 CostOfGoodsAndServicesSold -7.05 -2.74 0.274 0.619 2.53 0001114208 0001308569 0001265848
12 DepreciationAndAmortization -0.388 -0.330 0.0374 0.380 1.32 0001281774 0000701374 0001265848
13 OperatingExpenses -6.92 -4.30 0.463 1.41 3.83 0000015847 0001001039 0001265848
14 remainder_Expenses -21.6 -6.64 0.116 4.56 8.21 0001265848 0000701374 0001114208
15 remainder_Revenues -4.45 -2.48 1.00 3.02 13.3 0001326917 0001001039 0001265848
16 remainder_NetIncome -2.29 -0.612 -0.105 0.647 7.09 0001308569 0001326917 0001114208
17 remainder_ComprehensiveNetIncome -0.573 -0.0976 -0.00323 0.138 0.415 0000914577 0001335258 0000013573
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -6.95 -4.25 -0.0627 1.27 2.37 0001326917 0000013573 0001114208
1 Liabilities -1.15 -0.355 1.19 5.06 8.12 0001389518 0000015847 0001508332
2 Expenses -5.69 -4.42 0.359 1.22 2.72 0001326917 0000015847 0001114208
3 Revenues -4.45 -2.48 1.00 3.02 13.3 0001326917 0001001039 0001265848
4 StockholdersEquity -2.58 -2.50 0.545 1.94 2.07 0001326917 0001318568 0001071255
5 NetIncome -10.3 -5.18 1.63 6.20 12.1 0001326917 0001418372 0001114208
6 ComprehensiveNetIncome -10.3 -5.26 1.63 6.19 12.1 0001326917 0001418372 0001114208
7 BaseVar nan nan nan nan nan 0000013573 0001114208 0000013573
8 EconomicCapitalRatio -13.7 -7.99 1.57 3.74 6.91 0001326917 0001318568 0001114208

2014

Logs

error 6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '10.5', 'quantile': 0.95}
{'var_name': 'NetIncome', 'quantile_value': '-10.0', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.3', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 22 × The stock price does not exist industry.us_generic
warning 22 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 20 × No stock price available subcommand.plot
warning 7 × Missing logo subcommand.report
warning 4 × Similarly named company. Duplicate? None
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Ignoring company because Liabilities is zero pre-agg
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '28 of 28'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -14.348243609182147}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 54.0 2,101 13,773,478 1,747,699,150 15,176,000,000 0001326917 0000015847 0001001039
1 PropertyPlantAndEquipment 0 0 24,547,972 2,182,276,000 23,332,000,000 0000013156 0001071255 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001106213 0000013156
3 AssetsNonCurrent 0 0 0 0 2,696,000,000 0000013156 0001106213 0001001039
4 IntangibleAssets 0 0 4,828,679 3,710,862,500 35,315,000,000 0000831489 0000914577 0001001039
5 remainder_Assets 0 0 6,557,403 701,328,950 7,667,000,000 0000831489 0000277058 0001001039
6 LiabilitiesCurrent 3,275 7,683 7,009,505 1,966,757,650 13,292,000,000 0001265848 0001017673 0001001039
7 LiabilitiesNonCurrent 0 0 0 34,620,050 1,200,910,000 0000013156 0001090396 0001076195
8 remainder_Liabilities -47,485,000 -2,540,200 2,992,023 1,641,837,900 3,679,000,000 0001335258 0000914577 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 1,440,617 1,274,804,000 8,565,000,000 0000831489 0001090396 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 27,130,622 63,112,000 0000013156 0000701374 0001076195
11 CostOfGoodsAndServicesSold 0 0 0 179,027,800 1,570,000,000 0000015847 0001570279 0001319161
12 DepreciationAndAmortization 0 0 1,933,669 332,392,950 2,288,000,000 0000831489 0001418372 0001001039
13 OperatingExpenses 0 0 0 386,983,150 727,659,000 0000013156 0001017673 0001564902
14 remainder_Expenses -26,000,000 -5,036,200 5,293,258 3,716,339,350 30,802,000,000 0001319161 0001318568 0001001039
15 remainder_Revenues 0 0 46,476,812 5,522,976,600 48,813,000,000 0001106213 0000015847 0001001039
16 remainder_NetIncome -348,000,000 -38,102,600 -17,627 4,475,900 846,000,000 0001319161 0001570279 0001001039
17 remainder_ComprehensiveNetIncome -1,284,000,000 -61,112,550 0 33,270 250,012 0001001039 0001418372 0000013156
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 54.0 2,101 47,159,450 5,976,334,650 84,186,000,000 0001326917 0000914577 0001001039
1 Liabilities 3,275 13,912 17,471,040 4,320,373,350 13,292,000,000 0001265848 0000013156 0001001039
2 Expenses 27,596 44,713 43,744,396 5,577,603,400 41,655,000,000 0001572384 0000015847 0001001039
3 Revenues 0 0 46,476,812 5,522,976,600 48,813,000,000 0001106213 0000015847 0001001039
4 StockholdersEquity -118,084,000 -2,356,971 32,344,409 2,972,220,400 70,894,000,000 0001281774 0001418372 0001001039
5 NetIncome -303,000,000 -168,543,950 -28,414 114,252,400 8,004,000,000 0001319161 0001572384 0001001039
6 ComprehensiveNetIncome -355,000,000 -181,394,600 -29,770 91,812,150 6,720,000,000 0001319161 0001551906 0001001039
7 BaseVar 89,968 165,833 285,200,170 33,825,811,636 288,567,820,000 0001572384 0001017673 0001001039
8 EconomicCapitalRatio -55.2 -14.3 0.213 2.54 7.52 0001265848 0001318568 0000831489

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 AssetsCurrent -38.1 -3.64 -0.187 2.12 16.3 0001265848 0001076195 0001572384
1 PropertyPlantAndEquipment -38.1 -3.27 -0.111 1.12 1.30 0001265848 0000015847 0001076195
2 LeaseAsset 0 0 0 0 0 0000013156 0001106213 0000013156
3 AssetsNonCurrent -0.600 -0.0247 -0.00177 -0.000210 0.00912 0001265848 0000914577 0000831489
4 IntangibleAssets -35.5 -3.03 -0.124 1.17 1.42 0001265848 0001076195 0001553588
5 remainder_Assets -28.5 -2.00 -0.0802 0.571 1.85 0001265848 0001076195 0001389518
6 LiabilitiesCurrent -34.5 -1.11 0.331 10.5 19.5 0001265848 0001076195 0001106213
7 LiabilitiesNonCurrent -8.91 -1.07 0.0293 0.126 0.348 0001265848 0001281774 0000831489
8 remainder_Liabilities -37.2 -2.87 -0.232 1.05 2.99 0001265848 0001553588 0000831489
9 SellingGeneralAndAdministrativeExpense -3.13 -1.28 0.350 2.22 7.65 0001090396 0001318568 0001265848
10 GeneralAndAdministrativeExpense -7.75 -5.39 0.447 1.29 2.82 0001551906 0001319161 0001265848
11 CostOfGoodsAndServicesSold -11.9 -2.67 0.353 0.843 4.65 0001114208 0001572384 0001265848
12 DepreciationAndAmortization -0.298 -0.284 -0.0110 0.510 2.29 0000013156 0000914577 0001265848
13 OperatingExpenses -7.31 -1.56 0.352 1.27 4.39 0000015847 0001326917 0001265848
14 remainder_Expenses -55.0 -5.57 0.00381 5.57 9.73 0001265848 0001551906 0001114208
15 remainder_Revenues -6.66 -5.60 0.475 4.23 5.62 0001551906 0001076195 0001114208
16 remainder_NetIncome -6.14 -0.292 0.0221 1.15 4.46 0001106213 0001326917 0001551906
17 remainder_ComprehensiveNetIncome -1.07 -0.157 0.0493 0.191 0.651 0000914577 0001572384 0001265848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -50.0 -7.70 0.187 1.44 3.78 0001265848 0001564902 0001572384
1 Liabilities -43.1 -1.24 0.122 4.63 11.6 0001265848 0001017673 0001326917
2 Expenses -33.2 -4.63 0.259 1.02 3.01 0001265848 0000015847 0000831489
3 Revenues -6.66 -5.60 0.475 4.23 5.62 0001551906 0001076195 0001114208
4 StockholdersEquity -4.95 -3.21 0.178 1.41 1.55 0001265848 0001553588 0001071255
5 NetIncome -38.9 -10.0 1.08 3.37 9.21 0001265848 0001564902 0000831489
6 ComprehensiveNetIncome -38.3 -9.93 1.09 3.56 9.33 0001265848 0000701374 0000831489
7 BaseVar nan nan nan nan nan 0000013156 0001106213 0000013156
8 EconomicCapitalRatio -52.2 -11.3 3.22 5.55 10.5 0001265848 0001318568 0000831489

2015

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Unusually strong effect check_effects
{'var_name': 'NetIncome', 'quantile_value': '-10.5', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-10.4', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-10.6', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 26 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 25 × The stock price does not exist industry.us_generic
warning 19 × No stock price available subcommand.plot
warning 4 × Missing logo subcommand.report
warning 3 × Similarly named company. Duplicate? None
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Ignoring company because Liabilities is zero pre-agg
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '29 of 29'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.668120568731753}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
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 AssetsCurrent 10,217 86,346 15,072,910 1,724,589,000 16,758,000,000 0001265848 0000015847 0001001039
1 PropertyPlantAndEquipment 0 0 37,129,957 1,645,205,600 25,179,000,000 0000013156 0000914577 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001308569 0000013156
3 AssetsNonCurrent 0 0 0 210,000 2,643,000,000 0000013156 0001265848 0001001039
4 IntangibleAssets 0 0 5,018,372 3,440,431,200 34,998,000,000 0000831489 0000914577 0001001039
5 remainder_Assets 0 0 8,734,198 1,093,995,600 8,604,000,000 0000831489 0001281774 0001001039
6 LiabilitiesCurrent 0 11,982 9,351,406 2,003,523,600 16,334,000,000 0001572384 0000015847 0001001039
7 LiabilitiesNonCurrent 0 0 0 29,472,800 1,112,734,000 0000013156 0001114208 0001577095
8 remainder_Liabilities -42,352,000 -7,057,200 2,929,585 1,680,947,000 3,575,000,000 0001335258 0001090396 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 9,502 1,267,944,800 8,523,000,000 0000812011 0001322952 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 14,795,668 30,683,000 0000013156 0000812011 0001281774
11 CostOfGoodsAndServicesSold 0 0 0 76,794,000 1,511,000,000 0000015847 0001001039 0001319161
12 DepreciationAndAmortization 0 0 2,380,768 340,344,600 2,354,000,000 0000831489 0001418372 0001001039
13 OperatingExpenses 0 0 0 79,018,400 708,745,000 0000013156 0001114208 0001564902
14 remainder_Expenses -7,070,000 -164,400 17,047,946 3,722,317,200 33,433,000,000 0000015847 0001418372 0001001039
15 remainder_Revenues 0 0 47,110,405 5,533,838,600 52,465,000,000 0001265848 0000015847 0001001039
16 remainder_NetIncome -202,000,000 -82,949,400 0 12,566,600 697,000,000 0001319161 0001265848 0001001039
17 remainder_ComprehensiveNetIncome -923,000,000 -60,554,400 0 171,242 267,195 0001001039 0001418372 0000013156
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 10,217 182,298 55,315,185 5,962,144,600 88,182,000,000 0001265848 0000914577 0001001039
1 Liabilities 7,416 23,571 19,800,860 4,099,682,400 16,334,000,000 0001572384 0001389518 0001001039
2 Expenses 33,981 136,070 45,927,982 5,483,910,200 44,310,000,000 0001265848 0000015847 0001001039
3 Revenues 0 0 47,110,405 5,533,838,600 52,465,000,000 0001265848 0000015847 0001001039
4 StockholdersEquity -96,245,000 -3,282,522 30,448,748 3,269,410,600 71,848,000,000 0001281774 0000277058 0001001039
5 NetIncome -104,972,000 -69,073,600 -58,998 161,557,000 8,852,000,000 0001318568 0001572384 0001001039
6 ComprehensiveNetIncome -150,000,000 -93,395,800 -58,998 132,672,600 7,929,000,000 0001319161 0001572384 0001001039
7 BaseVar 115,332 928,529 297,857,734 33,633,754,918 307,101,050,000 0001265848 0001017673 0001001039
8 EconomicCapitalRatio -24.6 -11.7 0.421 2.22 2.55 0001308569 0001564902 0001001039

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 AssetsCurrent -12.0 -2.80 -0.336 0.942 9.77 0001308569 0000701374 0001322952
1 PropertyPlantAndEquipment -7.98 -3.18 -0.101 0.742 0.829 0001308569 0001389518 0001577095
2 LeaseAsset 0 0 0 0 0 0000013156 0001308569 0000013156
3 AssetsNonCurrent -2.03 -0.811 -0.0601 -0.00452 0.100 0001308569 0000013156 0001572384
4 IntangibleAssets -6.13 -2.51 -0.0458 0.952 1.09 0001308569 0001322952 0000013156
5 remainder_Assets -5.41 -1.44 -0.121 1.11 1.80 0001308569 0001319161 0001389518
6 LiabilitiesCurrent -2.57 -1.12 0.288 6.71 14.2 0001451448 0001564902 0001308569
7 LiabilitiesNonCurrent -0.907 -0.746 0.0378 0.121 0.169 0001577095 0000701374 0000277058
8 remainder_Liabilities -7.12 -1.69 -0.190 1.09 1.14 0001308569 0000013156 0000831489
9 SellingGeneralAndAdministrativeExpense -2.67 -1.79 0.188 1.30 1.66 0001090396 0001577095 0001114208
10 GeneralAndAdministrativeExpense -7.61 -2.61 0.473 1.22 1.61 0000831489 0000701374 0000277058
11 CostOfGoodsAndServicesSold -10.2 -2.08 0.298 0.831 0.895 0001114208 0001071255 0000277058
12 DepreciationAndAmortization -0.393 -0.285 0.000129 0.439 0.538 0001281774 0001389518 0001308569
13 OperatingExpenses -7.75 -0.971 0.223 0.593 0.730 0000015847 0001636519 0001114208
14 remainder_Expenses -14.7 -7.40 -0.0100 5.22 7.17 0001308569 0001570279 0001114208
15 remainder_Revenues -8.07 -4.51 0.578 2.98 3.81 0001308569 0000013156 0000277058
16 remainder_NetIncome -0.417 -0.295 -0.0329 0.358 0.623 0001318568 0001587755 0001389518
17 remainder_ComprehensiveNetIncome -0.499 -0.207 0.0329 0.110 0.119 0000914577 0001564902 0001114208
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -17.5 -5.70 -0.222 1.32 4.04 0001308569 0001090396 0001322952
1 Liabilities -3.94 -2.08 0.0184 1.68 5.13 0001451448 0001281774 0001265848
2 Expenses -12.1 -6.04 0.401 0.775 0.923 0001308569 0001636519 0001637207
3 Revenues -8.07 -4.51 0.578 2.98 3.81 0001308569 0000013156 0000277058
4 StockholdersEquity -4.75 -3.58 -0.531 1.62 2.31 0001114208 0001389518 0001572384
5 NetIncome -19.9 -10.5 0.996 2.66 3.09 0001308569 0000013156 0000277058
6 ComprehensiveNetIncome -19.8 -10.4 0.885 2.74 3.19 0001308569 0001636519 0000277058
7 BaseVar nan nan nan nan nan 0000013156 0001308569 0000013156
8 EconomicCapitalRatio -23.5 -10.6 1.52 3.31 3.64 0001308569 0001564902 0001001039

2016

Logs

error 9 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 4 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '10.2', 'quantile': 0.95}
{'var_name': 'NetIncome', 'quantile_value': '-11.9', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-11.5', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.9', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 26 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 25 × The stock price does not exist industry.us_generic
warning 22 × No stock price available subcommand.plot
warning 3 × Similarly named company. Duplicate? None
warning 3 × Missing logo subcommand.report
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Ignoring company because Liabilities is zero pre-agg
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '32 of 32'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -14.534542603236506}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
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 AssetsCurrent 2,533 5,004 11,671,139 2,085,217,100 16,966,000,000 0001622996 0000277058 0001001039
1 PropertyPlantAndEquipment 0 0 12,526,877 1,604,426,850 27,349,000,000 0000013156 0000277058 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001318568 0000013156
3 AssetsNonCurrent 0 0 0 5,568,021 4,280,000,000 0000013156 0001281774 0001001039
4 IntangibleAssets 0 0 2,746,380 3,130,115,450 34,759,000,000 0000013156 0001418372 0001001039
5 remainder_Assets 0 0 3,471,688 908,968,800 8,679,000,000 0000831489 0000277058 0001001039
6 LiabilitiesCurrent 0 13,942 6,725,394 2,120,254,800 16,842,000,000 0001444839 0001418372 0001001039
7 LiabilitiesNonCurrent 0 0 0 31,337,350 1,086,493,000 0000013573 0000013573 0001577095
8 remainder_Liabilities -53,317,000 -6,009,300 2,586,979 1,752,219,500 3,317,000,000 0001335258 0001090396 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 531 1,291,902,500 8,754,000,000 0000013573 0001622996 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 13,337,568 24,702,000 0000013156 0000812011 0001281774
11 CostOfGoodsAndServicesSold 0 0 0 70,812,800 1,707,000,000 0000013573 0001017673 0001319161
12 DepreciationAndAmortization 0 0 1,124,010 315,292,950 2,527,000,000 0000013573 0000013156 0001001039
13 OperatingExpenses 0 0 0 77,713,650 736,842,000 0000013156 0000013573 0001564902
14 remainder_Expenses -6,643,000 -33,530 2,832,026 3,564,761,650 35,227,000,000 0000015847 0001322952 0001001039
15 remainder_Revenues 0 0 42,998,127 5,545,020,300 55,632,000,000 0001265848 0000015847 0001001039
16 remainder_NetIncome -178,000,000 -66,780,200 -31,051 18,088,400 666,000,000 0001319161 0001570279 0001001039
17 remainder_ComprehensiveNetIncome -1,957,000,000 -65,132,250 0 435,415 3,663,000 0001001039 0001445831 0000812011
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,533 5,004 45,059,485 5,996,869,700 92,033,000,000 0001622996 0001418372 0001001039
1 Liabilities 9,805 45,636 15,569,162 3,674,739,200 16,842,000,000 0001445831 0000015847 0001001039
2 Expenses 29,482 37,982 41,563,150 5,406,132,250 46,508,000,000 0001445831 0001017673 0001001039
3 Revenues 0 0 42,998,127 5,545,020,300 55,632,000,000 0001265848 0000015847 0001001039
4 StockholdersEquity -214,755,000 -95,625,350 14,264,273 3,359,296,450 75,191,000,000 0001637207 0001322952 0001001039
5 NetIncome -249,479,000 -41,672,550 57,219 152,726,850 9,790,000,000 0001318568 0001090396 0001001039
6 ComprehensiveNetIncome -251,906,000 -72,671,300 -37,339 133,624,450 7,833,000,000 0001318568 0001265848 0001001039
7 BaseVar 86,279 120,049 251,623,328 33,803,366,278 325,773,670,000 0001445831 0000015847 0001001039
8 EconomicCapitalRatio -24.6 -14.5 0.175 2.35 2.52 0001622996 0001564902 0000013573

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 AssetsCurrent -6.38 -2.42 -0.141 2.98 5.72 0001622996 0001637207 0001451448
1 PropertyPlantAndEquipment -7.10 -3.59 -0.152 0.734 0.911 0001622996 0001637207 0001577095
2 LeaseAsset 0 0 0 0 0 0000013156 0001318568 0000013156
3 AssetsNonCurrent -1.20 -0.668 -0.0378 -0.000193 32.8 0001622996 0001564902 0001532158
4 IntangibleAssets -6.41 -3.27 -0.109 0.611 3.97 0001622996 0001418372 0001674227
5 remainder_Assets -4.01 -2.12 -0.0895 0.666 1.53 0001622996 0001418372 0001318568
6 LiabilitiesCurrent -1.74 -1.55 0.533 10.2 17.2 0001451448 0000812011 0001265848
7 LiabilitiesNonCurrent -0.914 -0.446 0.0275 0.0898 0.0942 0001577095 0000701374 0000013573
8 remainder_Liabilities -6.28 -2.24 -0.155 0.879 16.5 0001622996 0001090396 0001444839
9 SellingGeneralAndAdministrativeExpense -3.02 -1.47 0.251 0.961 3.23 0001090396 0001674227 0000831489
10 GeneralAndAdministrativeExpense -28.2 -7.81 0.707 1.63 1.98 0000831489 0001318568 0001622996
11 CostOfGoodsAndServicesSold -3.11 -1.36 0.251 0.506 1.40 0000914577 0001001039 0000831489
12 DepreciationAndAmortization -0.494 -0.349 0.00132 0.384 1.11 0001281774 0000277058 0000831489
13 OperatingExpenses -7.22 -2.12 0.310 0.631 1.75 0000015847 0001071255 0000831489
14 remainder_Expenses -15.5 -6.79 -0.00391 5.22 16.8 0001622996 0000701374 0000831489
15 remainder_Revenues -7.35 -5.07 0.674 3.12 8.53 0001622996 0001319161 0000831489
16 remainder_NetIncome -0.865 -0.402 0.0925 0.467 0.882 0001444839 0001326917 0001281774
17 remainder_ComprehensiveNetIncome -10.6 0.0266 0.268 0.605 1.69 0001532158 0001326917 0000831489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -14.7 -5.60 0.00217 1.13 6.21 0001622996 0000914577 0001674227
1 Liabilities -2.93 -2.47 0.397 4.64 9.42 0001451448 0001090396 0001265848
2 Expenses -11.1 -6.90 0.646 1.24 5.99 0001622996 0001389518 0001532158
3 Revenues -7.35 -5.07 0.674 3.12 8.53 0001622996 0001319161 0000831489
4 StockholdersEquity -2.99 -2.69 0.142 1.63 2.27 0001570279 0001090396 0001674227
5 NetIncome -18.2 -11.9 1.63 3.76 5.29 0001622996 0000701374 0000831489
6 ComprehensiveNetIncome -17.5 -11.5 1.73 4.26 6.98 0001622996 0001564902 0000831489
7 BaseVar nan nan nan nan nan 0000013156 0001318568 0000013156
8 EconomicCapitalRatio -21.9 -11.9 2.82 5.00 5.17 0001622996 0001564902 0000013573

2017

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '24.1', 'quantile': 0.95}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-11.1', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 27 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 26 × The stock price does not exist industry.us_generic
warning 15 × No stock price available subcommand.plot
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Similarly named company. Duplicate? None
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Ignoring company because Liabilities is zero pre-agg
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 2 × Ignoring company because Assets is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '29 of 29'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -12.382912429621447}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 0 5,427 6,784,298 2,471,536,800 15,889,000,000 0001265848 0000013156 0001001039
1 PropertyPlantAndEquipment 0 0 18,909,134 1,698,588,800 28,406,000,000 0000831489 0000013573 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001297937 0000013156
3 AssetsNonCurrent 0 0 0 8,988,210 3,202,000,000 0000013156 0001265848 0001001039
4 IntangibleAssets 0 0 6,355,300 3,258,541,600 38,421,000,000 0000013156 0000015847 0001001039
5 remainder_Assets 0 0 5,676,221 775,715,000 9,871,000,000 0000831489 0001281774 0001001039
6 LiabilitiesCurrent 93,660 120,392 8,809,608 2,986,200,000 19,595,000,000 0001451448 0000914577 0001001039
7 LiabilitiesNonCurrent 0 0 0 23,516,515 347,593,000 0000013573 0001265848 0001335258
8 remainder_Liabilities -347,593,000 -23,038,200 3,348,352 1,919,648,600 3,310,000,000 0001335258 0000015847 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 1,633,433,800 8,176,000,000 0000013573 0001318482 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 22,340,259 236,799,000 0000013156 0000277058 0000812011
11 CostOfGoodsAndServicesSold 0 0 0 154,200,800 1,931,000,000 0000013573 0000914577 0001319161
12 DepreciationAndAmortization 0 0 36,137 353,720,400 2,782,000,000 0000013573 0001532158 0001001039
13 OperatingExpenses 0 0 0 468,840,600 891,135,000 0000013156 0001017673 0000812011
14 remainder_Expenses -151,000,000 -99,600 5,408,010 5,128,465,000 34,826,000,000 0001319161 0001674227 0001001039
15 remainder_Revenues 0 0 46,752,856 7,632,868,800 55,137,000,000 0001265848 0001017673 0001001039
16 remainder_NetIncome -230,000,000 -108,567,600 0 19,370,800 281,645,000 0001319161 0001674227 0001637207
17 remainder_ComprehensiveNetIncome -35,907,000 -13,124,640 0 47,425,600 65,000,000 0000701374 0000831489 0001001039
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 781 6,425 47,204,544 6,789,757,800 95,789,000,000 0001265848 0001418372 0001001039
1 Liabilities 97,126 232,656 18,313,458 4,676,800,000 19,595,000,000 0001265848 0000277058 0001001039
2 Expenses 44,830 245,474 43,528,029 7,483,152,800 45,784,000,000 0001265848 0001418372 0001001039
3 Revenues 0 0 46,752,856 7,632,868,800 55,137,000,000 0001265848 0001017673 0001001039
4 StockholdersEquity -140,633,000 -113,345,000 8,159,149 3,758,822,200 76,194,000,000 0001318568 0001674227 0001001039
5 NetIncome -202,386,000 -66,834,600 583,561 280,502,800 9,366,000,000 0001564902 0001090396 0001001039
6 ComprehensiveNetIncome -193,768,000 -58,555,000 583,561 268,870,600 9,431,000,000 0001564902 0001090396 0001001039
7 BaseVar 165,063 1,391,999 271,132,039 45,072,331,504 319,279,410,000 0001265848 0001017673 0001001039
8 EconomicCapitalRatio -15.0 -12.4 0.578 2.51 5.92 0001308569 0000701374 0001592411

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 AssetsCurrent -4.24 -3.69 -0.0255 2.50 4.35 0001592411 0001335258 0001451448
1 PropertyPlantAndEquipment -5.92 -3.67 -0.112 0.732 1.10 0000831489 0000015847 0001564902
2 LeaseAsset 0 0 0 0 0 0000013156 0001297937 0000013156
3 AssetsNonCurrent -3.04 -1.41 -0.109 0.123 1.56 0000831489 0001637207 0001532158
4 IntangibleAssets -5.33 -3.13 -0.0288 0.662 11.7 0000831489 0000013573 0001674227
5 remainder_Assets -3.12 -1.46 -0.0272 0.324 0.937 0000831489 0001532158 0000013156
6 LiabilitiesCurrent -2.93 -1.93 0.332 24.1 27.1 0000831489 0001001039 0001308569
7 LiabilitiesNonCurrent -0.106 -0.0901 0.00396 0.0168 0.0192 0000013156 0001637207 0001592411
8 remainder_Liabilities -3.12 -2.28 -0.106 1.03 1.54 0000831489 0001297937 0001592411
9 SellingGeneralAndAdministrativeExpense -2.76 -2.03 0.371 1.12 4.00 0001090396 0001265848 0000831489
10 GeneralAndAdministrativeExpense -34.4 -4.51 0.544 1.38 1.57 0000831489 0001637207 0000277058
11 CostOfGoodsAndServicesSold -2.04 -1.53 0.209 0.452 1.44 0001674227 0001297937 0000831489
12 DepreciationAndAmortization -0.538 -0.368 0.0906 0.273 0.976 0001281774 0001265848 0000831489
13 OperatingExpenses -7.79 -1.99 0.393 0.819 2.67 0000015847 0001017673 0000831489
14 remainder_Expenses -10.3 -5.16 0.191 4.54 18.9 0001318482 0001637207 0000831489
15 remainder_Revenues -5.02 -4.25 0.550 2.98 3.49 0001318482 0001319161 0001592411
16 remainder_NetIncome -1.25 -0.612 -0.00800 1.11 7.41 0001308569 0001281774 0000831489
17 remainder_ComprehensiveNetIncome -0.423 -0.204 -0.0671 0.232 0.748 0000831489 0001017673 0000914577
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -8.45 -7.07 -0.00476 0.647 2.22 0000831489 0000013573 0001532158
1 Liabilities -3.96 -2.26 0.440 9.51 12.1 0000831489 0001090396 0001265848
2 Expenses -6.91 -6.00 0.629 1.09 2.79 0001318482 0001532158 0001592411
3 Revenues -5.02 -4.25 0.550 2.98 3.49 0001318482 0001319161 0001592411
4 StockholdersEquity -3.37 -2.97 0.220 1.37 1.52 0000831489 0001090396 0000812011
5 NetIncome -12.0 -9.69 1.52 3.01 6.28 0001318482 0000831489 0001592411
6 ComprehensiveNetIncome -12.1 -9.79 1.37 2.88 6.21 0001318482 0000013156 0001592411
7 BaseVar nan nan nan nan nan 0000013156 0001297937 0000013156
8 EconomicCapitalRatio -13.6 -11.1 1.91 3.84 7.25 0001308569 0000701374 0001592411

2018

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 6 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '-12.4', 'quantile': 0.05}
{'var_name': 'Assets', 'quantile_value': '-11.2', 'quantile': 0.05}
{'var_name': 'Liabilities', 'quantile_value': '-13.6', 'quantile': 0.05}
{'var_name': 'NetIncome', 'quantile_value': '-11.9', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-19.1', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-20.6', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 29 × The stock price does not exist industry.us_generic
warning 28 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 14 × No stock price available subcommand.plot
warning 8 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 6 × Ignoring company because Assets is zero pre-agg
warning 2 × Similarly named company. Duplicate? None
warning 2 × Ignoring company because Liabilities is zero pre-agg
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'LeaseAsset', 'zeros': '27 of 27'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -23.782391385532524}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 231 5,483 6,242,300 3,118,352,500 16,825,000,000 0001445831 0001017673 0001001039
1 PropertyPlantAndEquipment 0 0 6,625,776 1,672,588,100 29,540,000,000 0001286459 0001297937 0001001039
2 LeaseAsset 0 0 0 0 0 0000013156 0001318568 0000013156
3 AssetsNonCurrent 0 0 0 1,073,262 2,899,000,000 0000013156 0001297937 0001001039
4 IntangibleAssets 0 0 3.64 3,225,418,200 38,081,000,000 0000013156 0001286459 0001001039
5 remainder_Assets 0 0 3,221,316 981,631,700 11,253,000,000 0001308569 0001286459 0001001039
6 LiabilitiesCurrent 10,078 67,843 6,593,127 3,336,806,200 17,860,000,000 0001703073 0001286459 0001001039
7 LiabilitiesNonCurrent 0 0 0 27,359,814 82,142,000 0000013573 0001308569 0001335258
8 remainder_Liabilities -82,142,000 -26,918,500 281,365 1,946,395,000 3,291,000,000 0001335258 0001532158 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 1,821,219,600 8,860,000,000 0000013573 0001286459 0001001039
10 GeneralAndAdministrativeExpense 0 0 0 6,672,994 251,806,000 0000013156 0000015847 0000812011
11 CostOfGoodsAndServicesSold 0 0 0 170,667,300 2,171,000,000 0000013573 0001636519 0001319161
12 DepreciationAndAmortization 0 0 0 332,370,300 3,011,000,000 0000013573 0000015847 0001001039
13 OperatingExpenses 0 0 0 536,857,200 966,566,000 0000013156 0001297937 0000812011
14 remainder_Expenses 0 8,105 2,696,561 6,112,973,500 34,422,000,000 0001703073 0001318482 0001001039
15 remainder_Revenues 0 0 18,576,815 8,752,960,000 59,434,000,000 0001090396 0000013156 0001001039
16 remainder_NetIncome -83,167,000 -71,172,600 -142,325 7,676,500 220,000,000 0001318568 0001297937 0001319161
17 remainder_ComprehensiveNetIncome -67,954,000 -58,201,500 0 108,500 8,454,000 0000812011 0001445831 0001564902
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 231 5,483 21,213,785 7,551,020,200 98,598,000,000 0001445831 0000013156 0001001039
1 Liabilities 10,078 67,843 8,580,227 5,089,759,800 17,860,000,000 0001703073 0001674227 0001001039
2 Expenses 15,567 31,478 14,802,736 8,654,315,500 46,293,000,000 0001445831 0000013156 0001001039
3 Revenues 0 0 18,576,815 8,752,960,000 59,434,000,000 0001090396 0000013156 0001001039
4 StockholdersEquity -382,789,000 -259,346,600 1,077,295 4,364,323,200 80,738,000,000 0001637207 0001592411 0001001039
5 NetIncome -20,914,000 -14,310,776 1,011,729 375,661,900 13,066,000,000 0001071255 0001297937 0001001039
6 ComprehensiveNetIncome -24,445,614 -19,017,474 1,011,729 322,693,200 13,029,000,000 0001532158 0001297937 0001001039
7 BaseVar 73,402 200,368 110,527,128 51,345,515,720 332,352,010,000 0001445831 0000013156 0001001039
8 EconomicCapitalRatio -39.0 -23.8 0.244 3.94 5.01 0001532158 0001071255 0001592411

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 AssetsCurrent -15.8 -1.24 -0.00674 4.85 14.5 0001532158 0001297937 0001318482
1 PropertyPlantAndEquipment -14.7 -7.78 -0.189 0.902 1.03 0001532158 0000013573 0001622996
2 LeaseAsset 0 0 0 0 0 0000013156 0001318568 0000013156
3 AssetsNonCurrent -1.47 -0.868 -0.0203 0.118 7.57 0001592411 0001308569 0001532158
4 IntangibleAssets -11.2 -6.10 -0.0603 0.795 0.860 0001532158 0000015847 0001622996
5 remainder_Assets -10.4 -5.54 -0.0624 0.788 2.01 0001532158 0000015847 0001286459
6 LiabilitiesCurrent -21.0 -12.4 1.18 7.27 7.87 0001532158 0000013156 0001445831
7 LiabilitiesNonCurrent -0.241 -0.154 0.00207 0.0206 0.108 0001532158 0001318568 0001622996
8 remainder_Liabilities -13.0 -7.10 -0.0703 1.42 4.07 0001532158 0000013156 0001622996
9 SellingGeneralAndAdministrativeExpense -4.22 -2.37 0.222 2.38 3.94 0001090396 0001570279 0001622996
10 GeneralAndAdministrativeExpense -7.93 -4.90 0.489 2.05 6.28 0001703073 0001444839 0001622996
11 CostOfGoodsAndServicesSold -38.8 -2.31 0.409 1.43 1.84 0001622996 0001444839 0001532158
12 DepreciationAndAmortization -0.408 -0.337 0.0544 0.360 1.04 0000013156 0001318568 0001622996
13 OperatingExpenses -2.01 -1.84 0.209 0.678 2.07 0001532158 0001319161 0001622996
14 remainder_Expenses -25.6 -4.64 0.204 6.51 17.7 0001318482 0001318568 0001622996
15 remainder_Revenues -10.9 -7.15 0.967 4.17 21.3 0001532158 0001636519 0001622996
16 remainder_NetIncome -7.51 -6.10 0.647 2.16 6.81 0001532158 0001564902 0001622996
17 remainder_ComprehensiveNetIncome -15.9 0.0285 0.162 0.529 1.62 0001532158 0000013573 0001622996
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -26.2 -11.2 -0.0285 1.30 2.61 0001532158 0001297937 0001090396
1 Liabilities -24.0 -13.6 1.09 5.27 5.98 0001532158 0000013156 0001622996
2 Expenses -18.3 -6.76 0.270 1.96 4.97 0001318482 0001636519 0001532158
3 Revenues -10.9 -7.15 0.967 4.17 21.3 0001532158 0001636519 0001622996
4 StockholdersEquity -2.40 -2.32 1.16 3.59 6.52 0001308569 0000013156 0001622996
5 NetIncome -24.5 -11.9 1.81 5.60 20.4 0001318482 0001564902 0001622996
6 ComprehensiveNetIncome -29.4 -19.1 1.98 5.87 22.0 0001532158 0001564902 0001622996
7 BaseVar nan nan nan nan nan 0000013156 0001318568 0000013156
8 EconomicCapitalRatio -35.7 -20.6 3.47 7.16 8.23 0001532158 0001071255 0001592411

2019

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 4 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '11.0', 'quantile': 0.95}
{'var_name': 'NetIncome', 'quantile_value': '-13.5', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-13.5', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-13.5', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 32 × The stock price does not exist industry.us_generic
warning 31 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 12 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 11 × No stock price available subcommand.plot
warning 7 × Ignoring company because Assets is zero pre-agg
warning 3 × Similarly named company. Duplicate? None
warning 3 × Ignoring company because Liabilities is zero pre-agg
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'AssetsNonCurrent', 'zeros': '27 of 27'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -16.34091299175766}
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 78.0 16,895 9,659,130 1,151,385,000 4,192,899,000 0001445831 0001621672 0001335258
1 PropertyPlantAndEquipment 0 0 6,641,701 1,598,622,200 1,842,500,000 0001308569 0001297937 0000812011
2 LeaseAsset 0 0 0 202,810,100 1,402,019,000 0000015847 0001445831 0001335258
3 AssetsNonCurrent 0 0 0 0 0 0000013156 0001335258 0000013156
4 IntangibleAssets 0 0 4,553,055 1,641,514,300 2,868,639,000 0000013573 0001621672 0001335258
5 remainder_Assets -1,163,106 0 3,293,914 1,100,147,000 2,085,902,000 0000013573 0001090396 0001636519
6 LiabilitiesCurrent 22,141 117,111 4,470,595 773,270,300 4,107,599,000 0001570279 0000013573 0001335258
7 LiabilitiesNonCurrent 0 0 0 45,299,700 1,138,871,000 0000013156 0001318482 0001071255
8 remainder_Liabilities -48,516,000 -26,456,500 228,320 2,100,934,800 2,482,547,000 0000812011 0001570279 0000701374
9 SellingGeneralAndAdministrativeExpense 0 0 0 307,719,000 2,145,486,000 0000013573 0000013573 0001335258
10 GeneralAndAdministrativeExpense 0 0 13,788 58,078,600 274,415,000 0000013156 0001445831 0000812011
11 CostOfGoodsAndServicesSold 0 0 8,334 193,127,500 271,999,000 0000013573 0001570279 0001698991
12 DepreciationAndAmortization 0 0 0 200,849,000 443,991,000 0000015847 0000015847 0001335258
13 OperatingExpenses 0 0 0 503,415,100 1,101,670,000 0000013156 0001106213 0000812011
14 remainder_Expenses -73,071 0 15,421,788 816,745,700 8,860,434,000 0001622996 0001318482 0001335258
15 remainder_Revenues 0 630 24,422,925 2,036,377,400 11,547,969,000 0001445831 0000013573 0001335258
16 remainder_NetIncome -87,538,000 -72,587,900 -17,983 15,492,600 47,429,000 0001071255 0001564902 0001636519
17 remainder_ComprehensiveNetIncome -51,833,000 -47,353,000 0 836,026 8,969,000 0000812011 0000013156 0001636519
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 78.0 76,939 23,994,437 4,227,390,900 10,975,615,000 0001445831 0000013156 0001335258
1 Liabilities 83,390 211,469 4,495,017 2,876,063,200 4,107,599,000 0001445831 0000013573 0001335258
2 Expenses 17,608 281,099 22,121,837 1,757,758,000 11,449,911,000 0001445831 0000013573 0001335258
3 Revenues 0 630 24,422,925 2,036,377,400 11,547,969,000 0001445831 0000013573 0001335258
4 StockholdersEquity -707,754,000 -139,091,787 8,927,557 3,406,776,900 6,868,016,000 0001637207 0001297937 0001335258
5 NetIncome -39,545,000 -26,496,919 -15,837 194,496,500 323,493,000 0001071255 0001445831 0000812011
6 ComprehensiveNetIncome -39,545,000 -26,496,919 600,805 158,468,300 271,660,000 0001071255 0001572384 0000812011
7 BaseVar 87,339 1,395,806 140,570,716 12,620,535,679 67,284,720,010 0001445831 0000013156 0001335258
8 EconomicCapitalRatio -26.9 -16.3 0.100 2.62 2.83 0001532158 0001318568 0000013573

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 AssetsCurrent -9.80 -2.14 -0.0461 2.15 4.32 0001532158 0001017673 0001621672
1 PropertyPlantAndEquipment -7.58 -4.33 -0.147 0.584 0.898 0001532158 0001090396 0001564902
2 LeaseAsset -0.623 -0.406 -0.0228 0.0970 0.137 0001621672 0001572384 0001071255
3 AssetsNonCurrent 0 0 0 0 0 0000013156 0001335258 0000013156
4 IntangibleAssets -6.42 -1.32 -0.00983 4.32 7.84 0001532158 0001636519 0001674227
5 remainder_Assets -5.44 -3.13 -0.0707 0.326 0.705 0001532158 0001335258 0001636519
6 LiabilitiesCurrent -6.87 -3.17 0.571 11.0 14.4 0001621672 0001622996 0001584693
7 LiabilitiesNonCurrent -1.39 -0.756 0.0287 0.154 0.303 0001071255 0001708341 0001572384
8 remainder_Liabilities -8.58 -4.45 -0.129 1.33 2.14 0001532158 0001308569 0001572384
9 SellingGeneralAndAdministrativeExpense -3.74 -2.71 0.403 2.02 3.28 0001584693 0001570279 0001572384
10 GeneralAndAdministrativeExpense -8.61 -7.28 0.457 2.14 3.18 0001674227 0001318568 0001572384
11 CostOfGoodsAndServicesSold -16.5 -6.40 0.355 1.34 1.81 0001572384 0001636519 0001532158
12 DepreciationAndAmortization -0.599 -0.299 0.0663 0.322 0.526 0001708341 0001318568 0001572384
13 OperatingExpenses -1.99 -1.29 0.150 0.572 0.933 0000812011 0000701374 0001572384
14 remainder_Expenses -9.75 -5.79 0.315 5.58 7.78 0001318482 0001445831 0001572384
15 remainder_Revenues -7.44 -5.28 0.645 3.60 8.29 0001532158 0000701374 0001572384
16 remainder_NetIncome -12.0 -4.19 0.311 1.22 1.88 0001532158 0001636519 0001572384
17 remainder_ComprehensiveNetIncome -0.0930 -0.0599 0.00962 0.0283 0.111 0000812011 0001318568 0001532158
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -17.0 -4.67 -0.0600 1.09 1.55 0001532158 0000015847 0001570279
1 Liabilities -9.11 -7.73 0.384 6.24 7.43 0001532158 0001708341 0001584693
2 Expenses -6.98 -4.30 0.424 1.01 1.09 0001318482 0001532158 0001637207
3 Revenues -7.44 -5.28 0.645 3.60 8.29 0001532158 0000701374 0001572384
4 StockholdersEquity -2.51 -2.38 1.02 2.19 2.49 0001445831 0001090396 0001621672
5 NetIncome -19.0 -13.5 1.62 5.00 9.32 0001532158 0001071255 0001572384
6 ComprehensiveNetIncome -18.9 -13.5 1.63 5.02 9.33 0001532158 0001071255 0001572384
7 BaseVar nan nan nan nan nan 0000013156 0001335258 0000013156
8 EconomicCapitalRatio -24.0 -13.5 2.94 5.46 5.67 0001532158 0001318568 0000013573

2020

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Unusually strong effect check_effects
{'var_name': 'LiabilitiesCurrent', 'quantile_value': '12.5', 'quantile': 0.95}
error 1 × Median ECR is negative check_abs_values
{'median': -0.6662856429460311}
warning 34 × The stock price does not exist industry.us_generic
warning 31 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 20 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 14 × No stock price available subcommand.plot
warning 6 × Ignoring company because Assets is zero pre-agg
warning 3 × Ignoring company because Liabilities is zero pre-agg
warning 3 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -9.453170390961118}
warning 1 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Missing logo subcommand.report
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 0 47,057 13,143,635 2,485,397,600 35,251,000,000 0001708176 0001451448 0001744489
1 PropertyPlantAndEquipment 0 0 13,667,044 1,880,120,600 32,078,000,000 0000015847 0001297937 0001744489
2 LeaseAsset 0 0 24,762 362,010,200 1,424,223,000 0000015847 0001622996 0001335258
3 AssetsNonCurrent 0 0 0 0 3,903,000,000 0000013156 0001335258 0001744489
4 IntangibleAssets 0 0 6,489,780 3,084,642,400 96,862,000,000 0001017673 0000015847 0001744489
5 remainder_Assets 0 0 3,930,657 801,019,000 33,455,000,000 0000725929 0001758488 0001744489
6 LiabilitiesCurrent 17,126 543,600 17,612,933 3,065,713,800 26,628,000,000 0001803977 0001286459 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,245,774,800 2,450,799,000 0000013156 0001090396 0000812011
8 remainder_Liabilities -53,415,000 0 4,128,031 2,442,139,600 3,572,000,000 0001335258 0001017673 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 0 1,653,273,600 12,369,000,000 0000725929 0001017673 0001744489
10 GeneralAndAdministrativeExpense 0 0 491 185,696,600 447,374,000 0000013156 0001071255 0001772757
11 CostOfGoodsAndServicesSold 0 0 0 238,186,600 2,333,000,000 0000015847 0000015847 0001319161
12 DepreciationAndAmortization 0 0 566,246 296,662,600 5,345,000,000 0001017673 0001318482 0001744489
13 OperatingExpenses 0 0 0 355,920,200 1,019,437,000 0000013156 0001319161 0000812011
14 remainder_Expenses -97,000 -40,262 23,017,256 871,053,800 50,314,000,000 0001090396 0001319161 0001744489
15 remainder_Revenues 0 0 22,428,547 2,463,563,200 65,388,000,000 0001308569 0001418372 0001744489
16 remainder_NetIncome -595,724,000 -116,554,400 -275,211 51,484,800 293,198,000 0000811532 0001564902 0001795250
17 remainder_ComprehensiveNetIncome -2,095,000,000 -40,879,600 0 74,274,000 132,726,000 0001744489 0001090396 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 10,103 154,544 87,572,050 7,245,860,600 201,549,000,000 0001286459 0001017673 0001744489
1 Liabilities 17,126 550,751 55,377,342 4,328,255,200 26,628,000,000 0001803977 0000013156 0001744489
2 Expenses 296,531 539,610 36,061,179 3,912,459,200 68,028,000,000 0001803977 0001017673 0001744489
3 Revenues 0 0 22,428,547 2,463,563,200 65,388,000,000 0001308569 0001418372 0001744489
4 StockholdersEquity -705,673,000 -340,897,400 5,744,586 3,658,098,800 174,921,000,000 0001637207 0001674227 0001744489
5 NetIncome -2,474,000,000 -1,309,946,800 -12,974,523 4,093,200 109,055,000 0001744489 0001698991 0000812011
6 ComprehensiveNetIncome -4,569,000,000 -1,301,272,600 -8,738,473 8,091,600 73,726,000 0001744489 0001286459 0000812011
7 BaseVar 954,987 4,382,974 259,935,950 23,663,607,624 465,491,930,000 0001803977 0001017673 0001744489
8 EconomicCapitalRatio -14.7 -9.45 -0.666 2.20 2.57 0001106213 0001564902 0001090396

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 AssetsCurrent -3.08 -2.75 -0.0839 1.80 15.7 0001106213 0000015847 0001451448
1 PropertyPlantAndEquipment -3.43 -3.00 -0.304 1.71 5.80 0001572384 0000015847 0001803977
2 LeaseAsset -0.655 -0.511 -0.0408 0.141 1.14 0001572384 0001318568 0001636519
3 AssetsNonCurrent -0.0156 -0.0116 -0.00120 -0.0000744 0.0136 0001106213 0001071255 0001744489
4 IntangibleAssets -3.79 -2.35 -0.112 3.00 25.7 0001106213 0001071255 0001379043
5 remainder_Assets -1.87 -1.38 -0.0964 0.670 1.54 0001106213 0000701374 0001708176
6 LiabilitiesCurrent -1.81 -1.53 0.165 12.5 20.5 0001621672 0001637207 0001286459
7 LiabilitiesNonCurrent -1.19 -1.01 0.0374 0.246 0.456 0001637207 0000013156 0001090396
8 remainder_Liabilities -3.10 -1.70 -0.325 0.798 1.52 0001106213 0001308569 0001090396
9 SellingGeneralAndAdministrativeExpense -5.06 -1.90 0.380 1.17 1.44 0001090396 0001308569 0001572384
10 GeneralAndAdministrativeExpense -9.02 -6.91 0.506 1.49 2.01 0001379043 0000013156 0001090396
11 CostOfGoodsAndServicesSold -3.52 -2.56 0.316 0.715 0.829 0001572384 0001335258 0001106213
12 DepreciationAndAmortization -0.633 -0.305 0.0880 0.340 0.409 0001379043 0001636519 0001572384
13 OperatingExpenses -1.17 -1.04 0.165 0.374 0.431 0001418372 0001758488 0001572384
14 remainder_Expenses -9.97 -5.12 0.259 2.87 3.13 0001106213 0001637207 0001090396
15 remainder_Revenues -3.54 -2.51 0.0992 2.39 4.30 0001106213 0001572384 0001090396
16 remainder_NetIncome -5.83 -3.87 0.504 1.21 1.48 0001572384 0001319161 0001090396
17 remainder_ComprehensiveNetIncome -0.574 -0.120 -0.0297 0.163 1.51 0001572384 0001418372 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -8.04 -4.94 0.00288 2.25 2.73 0001106213 0001090396 0000811532
1 Liabilities -2.98 -2.58 0.00101 5.61 7.78 0001621672 0001793659 0001286459
2 Expenses -6.84 -5.55 0.395 1.49 3.02 0001106213 0001564902 0001572384
3 Revenues -3.54 -2.51 0.0992 2.39 4.30 0001106213 0001572384 0001090396
4 StockholdersEquity -2.85 -2.51 0.192 1.64 1.74 0001286459 0000015847 0000811532
5 NetIncome -9.04 -7.06 0.584 3.50 5.75 0001106213 0001564902 0001090396
6 ComprehensiveNetIncome -9.10 -7.11 0.572 3.45 5.69 0001106213 0001564902 0001090396
7 BaseVar nan nan nan nan nan 0000013156 0001418372 0000013156
8 EconomicCapitalRatio -12.2 -6.98 1.80 4.67 5.04 0001106213 0001564902 0001090396

2021

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Median ECR is negative check_abs_values
{'median': -0.005711364882383042}
warning 38 × The stock price does not exist industry.us_generic
warning 32 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 28 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 9 × No stock price available subcommand.plot
warning 6 × Ignoring company because Assets is zero pre-agg
warning 3 × Similarly named company. Duplicate? None
warning 3 × Ignoring company because Liabilities is zero pre-agg
warning 3 × Ignoring company because Expenses is zero pre-agg
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -8.74169079031194}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic

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 AssetsCurrent 0 5,558 26,822,881 3,900,264,300 33,657,000,000 0001708176 0001451448 0001744489
1 PropertyPlantAndEquipment 0 0 836,821 2,188,050,600 32,624,000,000 0000015847 0000725929 0001744489
2 LeaseAsset 0 0 58,007 745,290,500 1,864,528,000 0000015847 0001318482 0001869198
3 AssetsNonCurrent 0 0 0 0 3,935,000,000 0000013156 0001444839 0001744489
4 IntangibleAssets 0 0 9,366,922 3,960,561,900 95,186,000,000 0000055234 0001379043 0001744489
5 remainder_Assets 0 0 11,871,318 867,708,900 38,207,000,000 0001379043 0001793659 0001744489
6 LiabilitiesCurrent 0 87,495 16,022,305 3,531,936,100 31,077,000,000 0001444839 0000015847 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,044,213,350 2,850,292,000 0000013156 0000015847 0000812011
8 remainder_Liabilities -585,254,000 0 4,229,049 3,709,027,100 5,995,282,000 0001335258 0001297937 0001766363
9 SellingGeneralAndAdministrativeExpense 0 0 642,288 1,781,258,800 13,517,000,000 0000055234 0001584693 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 120,126,750 828,325,000 0000013156 0001335258 0001772757
11 CostOfGoodsAndServicesSold 0 0 0 509,038,500 2,742,000,000 0000015847 0000015847 0001319161
12 DepreciationAndAmortization 0 0 635,318 289,552,700 5,111,000,000 0000055234 0001297937 0001744489
13 OperatingExpenses 0 0 0 711,352,550 2,597,178,000 0000013156 0000015847 0001766363
14 remainder_Expenses 0 0 9,726,273 1,392,509,850 45,810,000,000 0001379043 0001389518 0001744489
15 remainder_Revenues 0 0 18,396,628 5,349,372,350 67,418,000,000 0000055234 0000013156 0001744489
16 remainder_NetIncome -473,000,000 -159,426,250 -200,104 30,413,161 90,242,000 0001744489 0001584693 0001335258
17 remainder_ComprehensiveNetIncome -47,046,000 -3,848,500 0 56,889,900 1,370,000,000 0001772757 0001445831 0001744489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 133 136,993 112,823,688 11,582,907,050 203,609,000,000 0001444839 0001451448 0001744489
1 Liabilities 8,524 122,013 59,151,495 7,261,909,550 31,077,000,000 0001816554 0000015847 0001744489
2 Expenses 5,635 83,351 36,830,181 5,524,058,300 64,438,000,000 0000055234 0001451448 0001744489
3 Revenues 0 0 18,396,628 5,349,372,350 67,418,000,000 0000055234 0000013156 0001744489
4 StockholdersEquity -642,845,000 -42,313,500 19,887,627 2,592,089,500 172,532,000,000 0001637207 0001418372 0001744489
5 NetIncome -1,523,195,000 -580,839,850 -334,074 258,887,350 2,507,000,000 0001772757 0001803977 0001744489
6 ComprehensiveNetIncome -1,570,241,000 -581,290,200 -334,074 259,887,350 3,877,000,000 0001772757 0001803977 0001744489
7 BaseVar 42,231 2,539,467 313,467,842 38,287,896,329 463,623,410,000 0001816554 0001708341 0001744489
8 EconomicCapitalRatio -88.9 -8.74 -0.00567 2.45 8.00 0001622996 0000055234 0001708341

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 AssetsCurrent -60.3 -7.33 -0.126 1.46 7.21 0001622996 0001564902 0001816554
1 PropertyPlantAndEquipment -55.8 -2.36 -0.171 0.674 1.69 0001622996 0001637207 0001708176
2 LeaseAsset -26.3 -1.26 -0.0437 0.513 2.15 0001622996 0000811532 0000725929
3 AssetsNonCurrent -0.584 -0.0198 -0.000897 0.000476 0.00842 0001622996 0000013156 0001744489
4 IntangibleAssets -65.5 -4.59 -0.0776 3.35 7.03 0001622996 0001636519 0001379043
5 remainder_Assets -64.4 -4.45 -0.223 1.18 2.19 0001622996 0001802156 0001445831
6 LiabilitiesCurrent -67.3 -2.01 0.221 1.76 6.78 0001622996 0001802156 0001584693
7 LiabilitiesNonCurrent -29.3 -1.54 0.0490 0.313 0.493 0001622996 0001636519 0001708341
8 remainder_Liabilities -67.4 -2.99 0.00583 1.64 12.7 0001622996 0001772757 0001444839
9 SellingGeneralAndAdministrativeExpense -22.2 -2.26 0.178 1.21 2.58 0001622996 0001564902 0001803977
10 GeneralAndAdministrativeExpense -4.03 -3.36 0.409 1.95 8.30 0001674227 0000013156 0001622996
11 CostOfGoodsAndServicesSold -7.59 -4.61 0.258 0.666 0.721 0001803977 0001636519 0001674227
12 DepreciationAndAmortization -1.52 -0.200 0.0325 0.572 2.43 0001379043 0000055234 0001622996
13 OperatingExpenses -2.33 -1.16 0.194 0.791 3.37 0000811532 0001071255 0001622996
14 remainder_Expenses -44.1 -3.40 0.187 1.84 3.75 0001622996 0001637207 0001793659
15 remainder_Revenues -16.4 -2.72 0.300 3.11 3.51 0001622996 0001802156 0001793659
16 remainder_NetIncome -6.08 -2.28 0.0393 0.996 7.34 0001389518 0001379043 0001708341
17 remainder_ComprehensiveNetIncome -0.195 -0.0561 -0.0120 0.0492 0.997 0001622996 0001564902 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -82.2 -7.64 -0.114 1.64 1.93 0001622996 0001766363 0001708176
1 Liabilities -76.3 -3.76 0.146 2.48 4.25 0001622996 0001451448 0001708341
2 Expenses -56.8 -4.19 0.200 0.805 2.70 0001622996 0001802156 0001708341
3 Revenues -16.4 -2.72 0.300 3.11 3.51 0001622996 0001802156 0001793659
4 StockholdersEquity -3.16 -2.88 0.225 1.67 1.98 0001622996 0000015847 0001621672
5 NetIncome -71.8 -7.46 0.610 2.84 7.58 0001622996 0001636519 0001708341
6 ComprehensiveNetIncome -72.0 -7.44 0.630 3.54 7.56 0001622996 0001636519 0001708341
7 BaseVar nan nan nan nan nan 0000013156 0001445831 0000013156
8 EconomicCapitalRatio -85.6 -5.43 3.30 5.76 11.3 0001622996 0000055234 0001708341

2022

Logs

error 8 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 5 × Unusually strong effect check_effects
{'var_name': 'Assets', 'quantile_value': '-13.5', 'quantile': 0.05}
{'var_name': 'Liabilities', 'quantile_value': '-10.1', 'quantile': 0.05}
{'var_name': 'NetIncome', 'quantile_value': '-14.6', 'quantile': 0.05}
{'var_name': 'ComprehensiveNetIncome', 'quantile_value': '-14.5', 'quantile': 0.05}
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-12.9', 'quantile': 0.05}
error 2 × Negative Expenses, ignoring company. pre-agg
warning 39 × The stock price does not exist industry.us_generic
warning 32 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 32 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 16 × No stock price available subcommand.plot
warning 9 × Missing logo subcommand.report
warning 7 × Ignoring company because Assets is zero pre-agg
warning 4 × Similarly named company. Duplicate? None
warning 3 × Ignoring company because Liabilities is zero pre-agg
warning 3 × Ignoring company because Expenses is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -19.109424097229486}
warning 1 × Large missing amount for aggregate "Revenues" added to remainder. industry.us_generic
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic

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 AssetsCurrent 0 9,053 59,557,803 2,457,188,800 29,098,000,000 0001708176 0001824403 0001744489
1 PropertyPlantAndEquipment 0 0 10,448,978 2,149,672,000 33,596,000,000 0000055234 0001856031 0001744489
2 LeaseAsset 0 0 165,133 618,813,000 2,116,761,000 0000015847 0001451448 0001869198
3 AssetsNonCurrent 0 0 0 0 3,218,000,000 0000013156 0001584693 0001744489
4 IntangibleAssets 0 0 66,290,087 4,043,200,400 92,734,000,000 0000055234 0001564902 0001744489
5 remainder_Assets 0 0 11,086,288 1,568,350,000 44,985,000,000 0001106213 0000701374 0001744489
6 LiabilitiesCurrent 0 201,487 69,577,137 3,353,308,000 29,073,000,000 0001444839 0001758488 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,279,887,800 2,734,049,000 0000013156 0000015847 0000812011
8 remainder_Liabilities -620,032,000 0 15,662,445 3,770,781,000 5,408,125,000 0001335258 0001793659 0001766363
9 SellingGeneralAndAdministrativeExpense 0 0 514,897 2,259,569,600 16,388,000,000 0000055234 0001389518 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 130,265,800 763,720,000 0000013156 0001297937 0001883685
11 CostOfGoodsAndServicesSold 0 0 0 658,715,000 3,080,000,000 0000015847 0000055234 0001319161
12 DepreciationAndAmortization 0 0 3,445 266,020,000 5,163,000,000 0000015847 0001674227 0001744489
13 OperatingExpenses 0 0 0 838,580,600 2,065,777,000 0000013156 0000015847 0001766363
14 remainder_Expenses -43,234,000 -173,177 37,656,342 1,330,175,200 56,370,000,000 0001795250 0001829966 0001744489
15 remainder_Revenues 0 0 71,676,822 5,788,827,400 82,722,000,000 0000055234 0000015847 0001744489
16 remainder_NetIncome -1,296,000,000 -118,537,800 -412,841 76,892,000 311,323,000 0001744489 0001636519 0000811532
17 remainder_ComprehensiveNetIncome -145,000,000 -35,121,800 0 11,411,600 1,961,000,000 0001319161 0001584693 0001744489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 73.0 153,057 456,413,095 11,568,673,600 203,631,000,000 0001444839 0001708176 0001744489
1 Liabilities 10,448 1,781,846 300,221,570 8,174,652,000 29,073,000,000 0001816554 0000055234 0001744489
2 Expenses 13,358 529,219 104,494,744 5,351,624,000 77,921,000,000 0000055234 0001621672 0001744489
3 Revenues 0 0 71,676,822 5,788,827,400 82,722,000,000 0000055234 0000015847 0001744489
4 StockholdersEquity -460,133,000 -198,324,200 21,791,511 3,077,172,800 174,558,000,000 0000701374 0001829966 0001744489
5 NetIncome -1,377,987,000 -135,826,400 -10,098 534,969,000 3,505,000,000 0001883685 0000055234 0001744489
6 ComprehensiveNetIncome -1,377,987,000 -129,370,207 -10,098 440,011,200 5,466,000,000 0001883685 0000055234 0001744489
7 BaseVar 60,128 5,195,991 933,495,157 38,381,309,888 540,853,000,000 0001816554 0001856031 0001744489
8 EconomicCapitalRatio -184 -19.1 0.0757 2.08 4.24 0001622996 0001840572 0000811532

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 AssetsCurrent -136 -3.23 -0.0836 0.544 1.71 0001622996 0000055234 0001445831
1 PropertyPlantAndEquipment -137 -6.64 -0.177 0.554 1.10 0001622996 0001802156 0001708176
2 LeaseAsset -72.1 -1.72 -0.0369 0.203 0.720 0001622996 0000015847 0001636519
3 AssetsNonCurrent -1.24 -0.0229 -0.000614 0.000144 0.00543 0001622996 0001840572 0001744489
4 IntangibleAssets -153 -6.26 -0.167 1.17 2.32 0001622996 0001708176 0001674227
5 remainder_Assets -136 -6.27 -0.156 0.405 2.30 0001622996 0001418372 0000055234
6 LiabilitiesCurrent -157 -7.92 0.295 2.67 6.57 0001622996 0000701374 0001106213
7 LiabilitiesNonCurrent -73.1 -1.71 0.0357 0.240 0.353 0001622996 0001795250 0000811532
8 remainder_Liabilities -156 -8.22 -0.227 2.24 16.3 0001622996 0001952073 0001444839
9 SellingGeneralAndAdministrativeExpense -54.1 -2.60 0.215 1.45 2.85 0001622996 0001795250 0001839360
10 GeneralAndAdministrativeExpense -16.2 -2.60 0.381 1.47 13.7 0001816554 0001584693 0001622996
11 CostOfGoodsAndServicesSold -6.65 -3.77 0.253 0.938 5.64 0001793659 0001803977 0001622996
12 DepreciationAndAmortization -0.375 -0.191 0.0516 0.521 2.82 0000811532 0001703073 0001622996
13 OperatingExpenses -3.03 -1.24 0.171 0.853 4.61 0000811532 0001840572 0001622996
14 remainder_Expenses -84.4 -6.38 0.327 3.19 5.77 0001622996 0000055234 0001839360
15 remainder_Revenues -47.7 -4.13 0.486 3.44 7.48 0001622996 0001674227 0001803977
16 remainder_NetIncome -13.4 -1.05 0.102 1.41 4.06 0001839360 0001444839 0001622996
17 remainder_ComprehensiveNetIncome -1.07 -0.0786 0.00838 0.0948 1.95 0001829966 0001297937 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -173 -13.5 -0.208 1.36 1.85 0001622996 0001758488 0001856031
1 Liabilities -169 -10.1 0.0442 2.67 5.86 0001622996 0001636519 0001444839
2 Expenses -112 -8.91 0.263 1.05 1.35 0001622996 0001319161 0001839360
3 Revenues -47.7 -4.13 0.486 3.44 7.48 0001622996 0001674227 0001803977
4 StockholdersEquity -2.59 -2.03 0.251 1.50 1.87 0001444839 0001802156 0001744489
5 NetIncome -155 -14.6 0.973 3.08 4.81 0001622996 0001795250 0000811532
6 ComprehensiveNetIncome -155 -14.5 0.949 3.61 4.85 0001622996 0001795250 0000811532
7 BaseVar nan nan nan nan nan 0000013156 0001622996 0000013156
8 EconomicCapitalRatio -177 -12.9 6.30 8.30 10.5 0001622996 0001840572 0000811532

2023

Logs

warning 7 × The stock price does not exist industry.us_generic
warning 7 × No stock price available subcommand.plot
warning 6 × Missing logo subcommand.report
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.398520795843963}
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
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 AssetsCurrent 0 22,914 149,313,931 5,272,301,600 32,763,000,000 0001708176 0001636519 0001744489
1 PropertyPlantAndEquipment 0 0 3,869,636 3,225,834,000 34,941,000,000 0000055234 0001708341 0001744489
2 LeaseAsset 0 0 1,289,247 1,071,725,400 2,202,601,000 0000015847 0001793659 0001869198
3 AssetsNonCurrent 0 0 0 0 3,080,000,000 0000015847 0001621672 0001744489
4 IntangibleAssets 0 0 75,076,835 4,050,252,200 90,128,000,000 0000055234 0001793659 0001744489
5 remainder_Assets 0 0 61,622,048 1,566,196,000 44,667,000,000 0000055234 0001698991 0001744489
6 LiabilitiesCurrent 0 21,009 137,740,062 6,236,961,200 31,139,000,000 0001584693 0001793659 0001744489
7 LiabilitiesNonCurrent 0 0 0 1,465,781,200 2,819,835,000 0000015847 0001952073 0000812011
8 remainder_Liabilities -1,134,386,000 0 14,844,368 3,087,217,800 4,360,000,000 0001335258 0001793659 0001319161
9 SellingGeneralAndAdministrativeExpense 0 0 689,592 2,518,466,800 15,336,000,000 0000055234 0001584693 0001744489
10 GeneralAndAdministrativeExpense 0 0 0 263,934,800 606,569,000 0000015847 0001952073 0001883685
11 CostOfGoodsAndServicesSold 0 0 3,109 1,407,187,000 3,177,000,000 0000015847 0000811532 0001319161
12 DepreciationAndAmortization 0 0 156 367,819,400 5,369,000,000 0000015847 0001708341 0001744489
13 OperatingExpenses 0 0 0 509,134,800 1,454,324,000 0000015847 0000055234 0000812011
14 remainder_Expenses -80,556,000 -483,282 56,831,745 8,229,081,200 64,472,000,000 0001840572 0001829966 0001744489
15 remainder_Revenues 0 6,810 574,206,456 12,721,829,200 88,898,000,000 0001584693 0001795250 0001744489
16 remainder_NetIncome -331,000,000 -170,598,000 -685,505 156,665,000 870,540,000 0001744489 0001297937 0001795250
17 remainder_ComprehensiveNetIncome -209,000,000 -48,993,600 0 13,274,800 43,401,000 0001744489 0001674227 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 16,530 211,918 754,591,121 12,756,618,000 205,579,000,000 0001816554 0001824403 0001744489
1 Liabilities 35,015 1,012,709 402,731,422 8,852,961,200 31,139,000,000 0001816554 0000811532 0001744489
2 Expenses 21,286 246,805 236,018,573 12,157,707,200 85,177,000,000 0001816554 0001795250 0001744489
3 Revenues 0 6,810 574,206,456 12,721,829,200 88,898,000,000 0001584693 0001795250 0001744489
4 StockholdersEquity -376,961,000 -206,288,200 46,930,207 5,195,975,800 174,440,000,000 0000701374 0000015847 0001744489
5 NetIncome -802,142,000 -74,949,833 2,785,189 924,457,800 3,390,000,000 0001883685 0001824403 0001744489
6 ComprehensiveNetIncome -802,142,000 -73,851,470 1,622,295 893,938,400 3,181,000,000 0001883685 0001090396 0001744489
7 BaseVar 110,300 3,030,978 4,103,451,223 75,768,064,704 570,611,850,000 0001816554 0001793659 0001744489
8 EconomicCapitalRatio -14.8 -11.4 0.311 2.66 3.10 0001803977 0001840572 0001090396

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 AssetsCurrent -8.20 -2.63 -0.134 0.756 1.06 0001803977 0001952073 0001708341
1 PropertyPlantAndEquipment -7.56 -3.37 -0.148 0.604 1.99 0001803977 0001703073 0001708176
2 LeaseAsset -2.69 -1.03 -0.0363 0.241 0.706 0001803977 0001703073 0001636519
3 AssetsNonCurrent -0.0321 -0.0114 -0.000762 0.000215 0.00683 0001803977 0000701374 0001744489
4 IntangibleAssets -7.75 -2.62 -0.0930 1.89 3.94 0001803977 0001071255 0001674227
5 remainder_Assets -5.63 -2.36 -0.105 0.371 0.897 0001803977 0001869198 0001703073
6 LiabilitiesCurrent -1.91 -0.741 0.245 5.17 5.61 0001803977 0001637207 0001106213
7 LiabilitiesNonCurrent -1.80 -1.26 0.0633 0.312 0.362 0001803977 0001840572 0001793659
8 remainder_Liabilities -6.67 -2.56 -0.295 1.61 2.79 0001803977 0001318568 0001584693
9 SellingGeneralAndAdministrativeExpense -11.8 -2.60 0.186 1.33 1.63 0001803977 0001703073 0001829966
10 GeneralAndAdministrativeExpense -6.29 -2.62 0.380 1.11 2.12 0000055234 0001869198 0001803977
11 CostOfGoodsAndServicesSold -7.72 -3.01 0.289 0.972 1.31 0001793659 0001708341 0001335258
12 DepreciationAndAmortization -0.397 -0.236 0.0550 0.325 0.620 0000811532 0001708341 0001803977
13 OperatingExpenses -2.91 -1.85 0.229 0.799 1.28 0000811532 0001952073 0001803977
14 remainder_Expenses -6.30 -4.28 0.124 2.70 4.85 0001106213 0001637207 0001793659
15 remainder_Revenues -3.44 -2.43 0.300 2.59 4.78 0001106213 0001318568 0001793659
16 remainder_NetIncome -2.61 -1.75 0.142 1.03 1.34 0001674227 0001319161 0001795250
17 remainder_ComprehensiveNetIncome -0.0877 -0.0417 -0.00802 0.153 0.927 0000701374 0001071255 0001793659
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -13.2 -6.47 -0.139 1.38 1.53 0001803977 0000015847 0001708176
1 Liabilities -7.45 -2.66 0.0845 2.06 2.41 0001803977 0001319161 0001090396
2 Expenses -9.34 -4.92 0.159 0.829 1.39 0001803977 0000015847 0001795250
3 Revenues -3.44 -2.43 0.300 2.59 4.78 0001106213 0001318568 0001793659
4 StockholdersEquity -4.05 -2.40 -0.157 1.40 1.69 0001803977 0001703073 0001708341
5 NetIncome -8.24 -7.44 0.904 2.88 3.12 0001829966 0001637207 0001090396
6 ComprehensiveNetIncome -8.17 -7.35 0.885 2.99 3.79 0001106213 0001637207 0001793659
7 BaseVar nan nan nan nan nan 0000015847 0001637207 0000015847
8 EconomicCapitalRatio -13.2 -9.81 1.90 4.25 4.69 0001803977 0001840572 0001090396

Estimates

Parameter Value Min Max
PresentValueFactor 5.18 1.0 15.0
BalanceFactor 1.28 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 1.87 0.02 10.0

Stock Table

          Adjusted stock price Split Original stock price
(Adjusted stock price * Split)
Outstanding shares Market cap
(Original stock price * Outstanding shares)
obs_EconomicCapitalRatio
Company Name Name_short Identifier Year            
0000013156 Galaxy Gaming Inc Galaxy GLXZ 2014 0.3500 1.0000 0.3500 38,560,591.0 13,496,206.85 0.7326
2015 0.1800 1.0000 0.1800 39,065,591.0 7,031,806.38 0.4199
2016 0.5700 1.0000 0.5700 39,315,591.0 22,409,886.87 1.3514
2017 1.2000 1.0000 1.2000 39,565,591.0 47,478,709.20 2.8981
2018 1.4300 1.0000 1.4300 39,882,591.0 57,032,105.13 3.2541
2019 1.6600 1.0000 1.6600 17,910,344.0 29,731,171.04 0.7870
2020 1.8200 1.0000 1.8200 21,582,638.0 39,280,401.16 0.9166
2021 3.8000 1.0000 3.8000 22,354,804.0 84,948,255.20 1.7325
2022 2.4300 1.0000 2.4300 24,253,124.0 58,935,091.32 1.1567
0000013573 BOWL America INC BOWL Am nan 2013 nan nan nan 3,746,454.0 nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
2019 nan nan nan nan nan nan
0000015847 Butler National CORP Butler BUKS 2012 0.2000 1.0000 0.2000 58,142,914.0 11,628,582.80 0.4074
2013 0.1400 1.0000 0.1400 61,493,092.0 8,609,032.88 0.2684
2014 0.1500 1.0000 0.1500 61,493,092.0 9,223,963.80 0.3127
2015 0.1900 1.0000 0.1900 nan nan nan
2016 0.2100 1.0000 0.2100 nan nan nan
2017 0.3000 1.0000 0.3000 64,534,943.0 19,360,482.90 0.6762
2018 0.3500 1.0000 0.3500 64,237,185.0 22,483,014.75 0.8390
2019 0.7100 1.0000 0.7100 67,954,200.0 48,247,482.00 1.5206
2020 0.5100 1.0000 0.5100 74,033,347.0 37,757,006.97 0.4976
2021 0.8200 1.0000 0.8200 75,360,459.0 61,795,576.38 0.7654
2022 0.6800 1.0000 0.6800 76,781,357.0 52,211,322.76 0.6495
2023 0.7300 1.0000 0.7300 69,025,600.0 50,388,688.00 0.5567
0000055234 Kenilworth Systems CORP Kenilwo KENS 2021 0.5300 1.0000 0.5300 49,504,185.0 26,237,218.05 0.0883
2022 0.0800 1.0000 0.0800 49,504,185.0 3,960,334.80 0.0132
2023 0.1900 1.0000 0.1900 52,004,185.0 9,880,795.15 78.8803
0000277058 Nevada GOLD Casinos INC Nevada nan 2011 nan nan nan 15,820,033.0 nan nan
2012 nan nan nan 15,960,174.0 nan nan
2013 nan nan nan 16,134,110.0 nan nan
2014 nan nan nan 16,221,453.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan 17,798,356.0 nan nan
2017 nan nan nan nan nan nan
0000701374 Six Flags Entertainment Corp OLD Six Fla nan 2011 nan nan nan 55,022,377.0 nan nan
2012 nan nan nan 53,329,366.0 nan nan
2013 nan nan nan 95,132,273.0 nan nan
2014 nan nan nan 93,615,293.0 nan nan
2015 nan nan nan 91,837,217.0 nan nan
2016 nan nan nan 92,056,977.0 nan nan
2017 nan nan nan 83,785,748.0 nan nan
2018 nan nan nan 84,419,385.0 nan nan
2019 nan nan nan 84,524,441.0 nan nan
2020 nan nan nan 84,977,079.0 nan nan
2022 nan nan nan 83,156,504.0 nan nan
2023 nan nan nan 83,537,017.0 nan nan
0000725929 B2Digital Inc B2Digit nan 2020 nan nan nan 707,413,262.0 nan nan
2021 nan nan nan 1,496,740,840.0 nan nan
0000796764 Premier Exhibitions INC Premier nan 2011 nan nan nan 47,423,513.0 nan nan
2012 nan nan nan 47,955,918.0 nan nan
0000811532 Cedar FAIR L P Cedar F nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
2020 nan nan nan 56,706,338.0 nan nan
2021 nan nan nan 56,842,303.0 nan nan
2022 nan nan nan 54,382,518.0 nan nan
2023 nan nan nan 51,015,226.0 nan nan
0000812011 VAIL Resorts INC VAIL Re MTN 2011 43.2600 1.0000 43.2600 36,002,268.0 1,557,458,113.68 1.4227
2015 128.0100 1.0000 128.0100 36,240,129.0 4,639,098,913.29 3.2124
2016 161.7400 1.0000 161.7400 39,955,039.0 6,462,328,007.86 4.3248
2017 215.4000 1.0000 215.4000 40,407,160.0 8,703,702,264.00 3.6917
2018 210.8100 1.0000 210.8100 40,349,123.0 8,505,998,619.63 3.6517
2019 244.6300 1.0000 244.6300 40,257,530.0 9,848,199,563.90 3.8281
2020 274.3800 1.0000 274.3800 40,251,595.0 11,044,232,636.10 2.4662
2021 329.9100 1.0000 329.9100 40,451,209.0 13,345,258,361.19 2.5007
2022 241.4000 1.0000 241.4000 40,323,914.0 9,734,192,839.60 1.8046
2023 221.8500 1.0000 221.8500 37,966,630.0 8,422,896,865.50 1.5953
0000831489 Scores Holding CO INC Scores nan 2012 nan nan nan 165,186,124.0 nan nan
2013 nan nan nan 165,186,124.0 nan nan
2014 nan nan nan 165,186,124.0 nan nan
2015 nan nan nan 165,186,144.0 nan nan
2016 nan nan nan 165,186,144.0 nan nan
2017 nan nan nan 165,186,144.0 nan nan
0000894847 Carlyle Gaming Entertainment Ltd Carlyle nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
0000896400 Everi Games Holding INC Everi G nan 2011 nan nan nan 26,829,212.0 nan nan
2012 nan nan nan 28,299,595.0 nan nan
2013 nan nan nan 29,591,077.0 nan nan
2014 nan nan nan 29,733,192.0 nan nan
0000914577 Trans World CORP Trans W nan 2011 nan nan nan 8,871,640.0 nan nan
2012 nan nan nan 8,871,635.0 nan nan
2013 nan nan nan 8,825,335.0 nan nan
2014 nan nan nan 8,820,905.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
0001001039 TWDC Enterprises 18 Corp TWDC En nan 2010 nan nan nan nan nan nan
2011 nan nan nan 1,796,513,187.0 nan nan
2012 nan nan nan 1,772,122,139.0 nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
0001017673 Dover Motorsports LLC Dover M nan 2011 nan nan nan 18,510,975.0 nan nan
2012 nan nan nan 18,510,975.0 nan nan
2013 nan nan nan 18,510,975.0 nan nan
2014 nan nan nan 18,510,975.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
2019 nan nan nan nan nan nan
2020 nan nan nan nan nan nan
0001071255 Golden Entertainment INC Golden GDEN 2011 3.6700 0.5000 1.8400 26,405,679.0 48,586,449.36 0.6762
2013 7.9400 0.5000 3.9700 26,539,853.0 105,363,216.41 1.2972
2014 6.7800 1.0000 6.7800 13,389,078.0 90,777,948.84 1.3306
2015 9.9000 1.0000 9.9000 21,631,486.0 214,151,711.40 0.7829
2016 12.4700 1.0000 12.4700 22,229,646.0 277,203,685.62 0.8818
2017 33.4000 1.0000 33.4000 26,371,614.0 880,811,907.60 0.7310
2018 15.6500 1.0000 15.6500 27,991,425.0 438,065,801.25 0.3625
2019 19.2000 1.0000 19.2000 27,813,192.0 534,013,286.40 0.3346
2020 19.7400 1.0000 19.7400 28,180,521.0 556,283,484.54 0.3734
2021 50.3400 1.0000 50.3400 29,056,728.0 1,462,715,687.52 1.0047
2022 37.6800 1.0000 37.6800 28,505,387.0 1,074,082,982.16 0.8062
2023 40.4000 1.0000 40.4000 28,616,599.0 1,156,110,599.60 0.9768
0001076195 LIFE TIME Fitness INC LIFE TI nan 2010 nan nan nan nan nan nan
2011 nan nan nan 42,341,575.0 nan nan
2012 nan nan nan 42,504,948.0 nan nan
2013 nan nan nan 42,639,353.0 nan nan
2014 nan nan nan 39,122,768.0 nan nan
0001090396 Table TRAC INC Table T TBTC 2011 1.0000 1.0000 1.0000 4,704,305.0 4,704,305.00 1.4189
2012 0.9900 1.0000 0.9900 4,744,305.0 4,696,861.95 1.2240
2013 1.1300 1.0000 1.1300 4,767,305.0 5,387,054.65 1.1331
2014 0.7100 1.0000 0.7100 4,782,305.0 3,395,436.55 0.8739
2015 0.9000 1.0000 0.9000 4,546,065.0 4,091,458.50 0.7409
2016 1.4000 1.0000 1.4000 4,504,465.0 6,306,251.00 1.1264
2017 2.5000 1.0000 2.5000 4,511,965.0 11,279,912.50 1.8232
2018 2.8100 1.0000 2.8100 4,518,602.0 12,697,271.62 2.5613
2019 3.0000 1.0000 3.0000 4,503,669.0 13,511,007.00 2.0024
2020 2.7500 1.0000 2.7500 4,506,788.0 12,393,667.00 4.1911
2021 3.2700 1.0000 3.2700 4,521,988.0 14,786,900.76 2.5810
2022 5.2400 1.0000 5.2400 4,621,988.0 24,219,217.12 3.7088
2023 3.8500 1.0000 3.8500 4,634,865.0 17,844,230.25 2.6286
0001106213 Seafarer Exploration CORP Seafare SFRX 2014 0.0100 1.0000 0.0100 nan nan nan
2019 0.0100 1.0000 0.0100 nan nan nan
2020 0.0100 1.0000 0.0100 5,063,196,777.0 50,631,967.77 34.5298
2022 0.0000 1.0000 0.0000 nan nan nan
2023 0.0000 1.0000 0.0000 7,794,509,444.0 0.00 18.1057
0001114208 Nightculture Inc Nightcu nan 2011 nan nan nan 46,453,152.0 nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
0001265848 US VR Global com Inc US VR G nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
0001281774 TOWN Sports International Holdings INC TOWN Sp nan 2011 nan nan nan 22,848,730.0 nan nan
2012 nan nan nan 23,631,630.0 nan nan
2013 nan nan nan 24,106,139.0 nan nan
2014 nan nan nan 24,296,658.0 nan nan
2015 nan nan nan 24,879,897.0 nan nan
2016 nan nan nan 25,613,547.0 nan nan
2017 nan nan nan 26,681,090.0 nan nan
0001286459 ALL FOR ONE Media CORP ALL FOR nan 2018 nan nan nan 49,973,865.0 nan nan
2020 nan nan nan 1,118,473,025.0 nan nan
2022 nan nan nan 8,135,737,831.0 nan nan
0001297937 Parks America INC Parks A PRKA 2017 0.2300 1.0000 0.2300 74,671,537.0 17,174,453.51 2.5379
2018 0.1600 1.0000 0.1600 74,721,537.0 11,955,445.92 2.0721
2019 0.1800 1.0000 0.1800 74,821,537.0 13,467,876.66 2.1374
2020 0.4400 1.0000 0.4400 75,021,537.0 33,009,476.28 2.3892
2021 0.6200 1.0000 0.6200 75,124,087.0 46,576,933.94 3.4279
2022 0.4000 1.0000 0.4000 75,227,058.0 30,090,823.20 2.2411
2023 0.3200 1.0000 0.3200 75,517,763.0 24,165,684.16 1.9174
0001308569 Major League Football INC Major L nan 2013 nan nan nan nan nan nan
2015 nan nan nan 43,047,003.0 nan nan
2017 nan nan nan 59,499,488.0 nan nan
2018 nan nan nan 58,819,160.0 nan nan
2019 nan nan nan 110,971,909.0 nan nan
2020 nan nan nan 403,708,770.0 nan nan
2021 nan nan nan 469,860,029.0 nan nan
0001318482 Kidoz INC Kidoz I KDOZF 2017 0.3900 1.0000 0.3900 65,048,592.0 25,368,950.88 40.6839
2018 0.3900 1.0000 0.3900 73,674,703.0 28,733,134.17 66.7872
2019 0.2700 1.0000 0.2700 131,124,989.0 35,403,747.03 6.3414
2020 0.4000 1.0000 0.4000 131,124,989.0 52,449,995.60 7.9062
2021 0.5000 1.0000 0.5000 131,424,989.0 65,712,494.50 7.1039
0001318568 Everi Holdings Inc Everi H EVRI 2011 4.5400 1.0000 4.5400 64,821,010.0 294,287,385.40 0.6552
2012 7.7700 1.0000 7.7700 66,596,777.0 517,456,957.29 1.1385
2013 9.6100 1.0000 9.6100 65,468,305.0 629,150,411.05 1.5043
2014 7.0000 1.0000 7.0000 65,551,453.0 458,860,171.00 0.2883
2015 4.0900 1.0000 4.0900 65,956,802.0 269,763,320.18 0.1790
2016 2.4000 1.0000 2.4000 66,054,044.0 158,529,705.60 0.1084
2017 7.4900 1.0000 7.4900 67,366,979.0 504,578,672.71 0.3139
2018 5.1500 1.0000 5.1500 70,193,655.0 361,497,323.25 0.2256
2019 13.4500 1.0000 13.4500 72,297,697.0 972,404,024.65 0.6071
2020 13.6800 1.0000 13.6800 85,928,252.0 1,175,498,487.36 0.7937
2021 21.2300 1.0000 21.2300 90,978,626.0 1,931,476,229.98 1.2474
2022 14.0400 1.0000 14.0400 89,466,734.0 1,256,112,945.36 0.6942
2023 11.2000 1.0000 11.2000 85,566,565.0 958,345,528.00 0.4766
0001319161 Warner Music Group Corp Warner WMG 2012 nan 1.0000 nan 1,000.0 nan nan
2014 nan 1.0000 nan 1,055.0 nan nan
2015 nan 1.0000 nan 1,055.0 nan nan
2016 nan 1.0000 nan 1,055.0 nan nan
2017 nan 1.0000 nan 1,055.0 nan nan
2018 nan 1.0000 nan 1,052.0 nan nan
2020 37.4900 1.0000 37.4900 88,580,914.0 3,320,898,465.86 0.5162
2021 43.2400 1.0000 43.2400 123,074,992.0 5,321,762,654.08 0.7404
2022 35.2900 1.0000 35.2900 137,203,473.0 4,841,910,562.17 0.6252
2023 35.2200 1.0000 35.2200 138,345,391.0 4,872,524,671.02 0.5849
0001322952 TRUE BLUE Holdings INC TRUE BL nan 2011 nan nan nan 2,390,218.0 nan nan
2013 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001326917 Sputnik Enterprises Inc Sputnik nan 2013 nan nan nan 295,278.0 nan nan
2014 nan nan nan 295,278.0 nan nan
2016 nan nan nan nan nan nan
0001335258 Live Nation Entertainment Inc Live Na LYV 2013 19.6500 1.0000 19.6500 199,291,639.0 3,916,080,706.35 0.9865
2014 26.3500 1.0000 26.3500 200,659,004.0 5,287,364,755.40 1.3217
2015 24.9000 1.0000 24.9000 202,350,355.0 5,038,523,839.50 1.2204
2016 26.9900 1.0000 26.9900 203,436,945.0 5,490,763,145.55 1.1902
2017 42.6200 1.0000 42.6200 206,799,926.0 8,813,812,846.12 1.5908
2018 49.0300 1.0000 49.0300 209,545,061.0 10,273,994,340.83 1.6780
2019 70.9100 1.0000 70.9100 213,715,534.0 15,154,568,515.94 2.0095
2020 73.4600 1.0000 73.4600 217,117,403.0 15,949,444,424.38 2.2172
2021 119.1200 1.0000 119.1200 224,659,997.0 26,761,498,842.64 2.5177
2022 69.6600 1.0000 69.6600 230,879,879.0 16,083,092,371.14 1.2990
2023 92.9900 1.0000 92.9900 230,325,360.0 21,417,955,226.40 1.4754
0001379043 Xtreme Fighting Championships INC Xtreme nan 2020 nan nan nan 99,244,216.0 nan nan
2021 nan nan nan 120,595,979.0 nan nan
0001389518 Clubhouse Media Group Inc Clubhou CMGR 2011 0.2400 1.0000 0.2400 15,812,191.0 3,794,925.84 0.3107
2012 0.2400 1.0000 0.2400 15,812,191.0 3,794,925.84 0.2570
2013 0.2400 1.0000 0.2400 15,812,191.0 3,794,925.84 0.2253
2014 0.2400 1.0000 0.2400 15,812,191.0 3,794,925.84 0.2071
2015 0.1000 1.0000 0.1000 15,812,191.0 1,581,219.10 0.0862
2016 0.0900 1.0000 0.0900 15,812,191.0 1,423,097.19 0.1223
2021 0.2000 1.0000 0.2000 96,687,499.0 19,337,499.80 3.0941
2022 0.0000 1.0000 0.0000 1,861,137,402.0 0.00 0.1098
2023 0.0000 1.0000 0.0000 15,111,256,929.0 0.00 0.6873
0001407704 Lingerie Fighting Championships INC Lingeri BOTY 2011 22.4000 0.0010 0.0200 nan nan nan
2012 1.2000 0.0010 0.0000 104,757,357.0 0.00 0.0943
0001418372 Salamander Innisbrook LLC Salaman nan 2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2020 nan nan nan nan nan nan
2021 nan nan nan nan nan nan
2022 nan nan nan nan nan nan
0001444839 Bravo Multinational Inc Bravo M BRVO 2011 114.0000 1.0000 114.0000 239,315,456.0 27,281,961,984.00 56687.1408
2012 46.5000 1.0000 46.5000 276,573,740.0 12,860,678,910.00 15543.0147
2016 1.6500 0.0030 0.0000 nan nan nan
2018 0.5100 1.0000 0.5100 nan nan nan
2021 0.0400 1.0000 0.0400 47,641,010.0 1,905,640.40 3.4200
2022 0.0500 1.0000 0.0500 47,641,010.0 2,382,050.50 2.6952
0001445831 Newpoint Financial Corp Newpoin nan 2013 nan nan nan 15,825,726.0 nan nan
2016 nan nan nan 69,322,426.0 nan nan
2018 nan nan nan 69,322,426.0 nan nan
2019 nan nan nan 69,322,426.0 nan nan
2021 nan nan nan 19,153,923.0 nan nan
2022 nan nan nan 19,153,923.0 nan nan
0001451448 Esports Entertainment Group INC Esports GMBL 2015 nan 1.0000 nan 68,812,168.0 nan nan
2016 nan 1.0000 nan 70,922,194.0 nan nan
2017 549000.0000 1.0000 549000.0000 82,631,425.0 45,364,652,325,000.00 95178719.4257
2020 272400.0000 1.0000 272400.0000 12,895,412.0 3,512,710,228,800.00 472362.9075
2021 162600.0000 1.0000 162600.0000 22,390,453.0 3,640,687,657,800.00 44214.0401
2022 3520.0000 1.0000 3520.0000 70,922,944.0 249,648,762,880.00 3738.7005
0001508332 Trophy Hunting Unlimited Inc Trophy nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
0001532158 Rebel Group Inc Rebel G nan 2012 nan nan nan 11,500,000.0 nan nan
2013 nan nan nan 230,000,000.0 nan nan
2016 nan nan nan 23,000,118.0 nan nan
2017 nan nan nan 30,507,608.0 nan nan
2018 nan nan nan 48,009,941.0 nan nan
2019 nan nan nan 52,437,271.0 nan nan
0001551906 WEST Coast Ventures Group CORP WEST Co nan 2014 nan nan nan 2,947,500.0 nan nan
0001553588 SFX Entertainment INC SFX Ent nan 2013 nan nan nan nan nan nan
2014 nan nan nan 90,567,175.0 nan nan
0001564902 United Parks Resorts Inc United PRKS 2013 28.9300 1.0000 28.9300 93,285,743.0 2,698,756,544.99 1.1967
2014 17.4700 1.0000 17.4700 89,997,624.0 1,572,258,491.28 0.7302
2015 19.7400 1.0000 19.7400 89,627,620.0 1,769,249,218.80 0.8273
2016 19.1900 1.0000 19.1900 88,971,588.0 1,707,364,773.72 0.7950
2017 13.5700 1.0000 13.5700 90,436,452.0 1,227,222,653.64 0.6317
2018 22.7000 1.0000 22.7000 87,781,171.0 1,992,632,581.70 1.0051
2019 32.3600 1.0000 32.3600 78,723,283.0 2,547,485,437.88 1.1605
2020 30.8400 1.0000 30.8400 78,381,807.0 2,417,294,927.88 0.9229
2021 65.4000 1.0000 65.4000 77,272,923.0 5,053,649,164.20 1.9234
2022 52.8300 1.0000 52.8300 63,886,518.0 3,375,124,745.94 1.3263
0001570279 Double Down Holdings Inc Double nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
2019 nan nan nan nan nan nan
0001572384 Phoenix Rising Companies Phoenix nan 2014 nan nan nan 38,437,000.0 nan nan
2015 nan nan nan 70,176,241.0 nan nan
2019 nan nan nan 5,209,881.0 nan nan
2020 nan nan nan 120,669,368.0 nan nan
0001577095 Clubcorp Holdings Inc Clubcor nan 2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001584693 Healthcare Integrated Technologies Inc Healthc HITC 2019 nan 1.0000 nan nan nan nan
2020 nan 1.0000 nan 39,759,585.0 nan nan
2021 0.1300 1.0000 0.1300 42,034,673.0 5,464,507.49 4.1277
2022 0.0900 1.0000 0.0900 42,459,335.0 3,821,340.15 2.0793
2023 0.0700 1.0000 0.0700 69,725,011.0 4,880,750.77 3.9461
0001587755 Intrawest Resorts Holdings Inc Intrawe nan 2013 nan nan nan nan nan nan
2014 nan nan nan 45,051,124.0 nan nan
2015 nan nan nan nan nan nan
0001592411 DKG Capital Inc DKG Cap nan 2017 nan nan nan 14,893,714.0 nan nan
2018 nan nan nan 14,893,714.0 nan nan
0001621672 Super League Enterprise Inc Super L SLE 2019 50.4000 0.0500 2.5200 8,569,922.0 21,596,203.44 2.7954
2020 59.7000 0.0500 2.9900 15,483,010.0 46,294,199.90 5.4328
2021 48.9000 0.0500 2.4500 35,778,259.0 87,656,734.55 1.7000
2022 7.4500 0.0500 0.3700 37,570,973.0 13,901,260.01 0.6791
2023 1.7400 1.0000 1.7400 4,234,998.0 7,368,896.52 0.3614
0001622996 ACRO Biomedical CO LTD ACRO Bi nan 2016 nan nan nan 15,720,000.0 nan nan
2018 nan nan nan 47,760,000.0 nan nan
2019 nan nan nan 47,760,000.0 nan nan
2020 nan nan nan 47,760,000.0 nan nan
2021 nan nan nan 60,042,000.0 nan nan
2022 nan nan nan 60,042,000.0 nan nan
0001636519 Madison Square Garden Sports Corp Madison MSGS 2015 114.8900 1.4020 161.0800 20,446,042.0 3,293,448,445.36 2.1424
2016 124.3700 1.4020 174.3700 19,432,739.0 3,388,486,699.43 1.5054
2017 151.5500 1.4020 212.4700 19,030,926.0 4,043,500,847.22 1.6421
2018 183.8700 1.4020 257.7900 19,222,045.0 4,955,250,980.55 2.0469
2019 209.8600 1.4020 294.2200 19,353,383.0 5,694,152,346.26 2.3622
2020 178.0300 1.0000 178.0300 19,582,001.0 3,486,183,638.03 2.6104
2021 173.3300 1.0000 173.3300 19,688,624.0 3,412,629,197.92 2.4188
2022 178.3400 1.0000 178.3400 19,802,683.0 3,531,610,486.22 2.5690
2023 179.0600 1.0000 179.0600 19,404,363.0 3,474,545,238.78 2.3419
0001637207 Planet Fitness Inc Planet PLNT 2015 15.6300 1.0000 15.6300 36,597,985.0 572,026,505.55 0.8175
2016 20.0500 1.0000 20.0500 50,049,305.0 1,003,488,565.25 0.9048
2017 34.6300 1.0000 34.6300 85,783,274.0 2,970,674,778.62 2.5589
2018 52.9000 1.0000 52.9000 88,169,242.0 4,664,152,901.80 3.0190
2019 74.1800 1.0000 74.1800 81,792,537.0 6,067,370,394.66 2.9296
2020 76.7200 1.0000 76.7200 81,815,125.0 6,276,856,390.00 2.8498
2021 90.7200 1.0000 90.7200 83,344,564.0 7,561,018,846.08 3.2348
2022 77.7800 1.0000 77.7800 83,415,699.0 6,488,073,068.22 2.1918
2023 72.8100 1.0000 72.8100 85,438,502.0 6,220,777,330.62 2.0535
0001674227 Scworx Corp Scworx WORX 2016 1016.0200 0.0040 4.0600 nan nan nan
2017 360.3800 0.0040 1.4400 12,662,974.0 18,234,682.56 3.2092
2018 50.3000 0.0040 0.2000 17,494,852.0 3,498,970.40 0.4946
2019 43.5700 0.0670 2.9200 7,099,471.0 20,730,455.32 3.1741
2020 22.9500 0.0670 1.5400 9,861,731.0 15,187,065.74 1.9540
2021 19.3500 0.0670 1.3000 11,240,805.0 14,613,046.50 2.4615
2022 6.1500 0.0670 0.4100 13,010,409.0 5,334,267.69 0.9150
2023 1.7600 1.0000 1.7600 1,211,035.0 2,131,421.60 0.4898
0001698991 Accel Entertainment Inc Accel E ACEL 2019 12.4200 1.0000 12.4200 41,752,733.0 518,568,943.86 1.1119
2020 10.4100 1.0000 10.4100 93,280,747.0 971,052,576.27 1.9566
2021 13.0200 1.0000 13.0200 94,067,179.0 1,224,754,670.58 2.2814
2022 7.5800 1.0000 7.5800 87,467,078.0 663,000,451.24 0.8572
2023 10.2700 1.0000 10.2700 84,803,284.0 870,929,726.68 1.0703
0001703073 Vivic CORP Vivic C VIVC 2018 nan 1.0000 nan 5,340,000.0 nan nan
2020 nan 1.0000 nan nan nan nan
2022 nan 1.0000 nan 25,546,810.0 nan nan
2023 nan 1.0000 nan 26,657,921.0 nan nan
0001708176 Hall of Fame Resort Entertainment Co Hall of HOFV 2020 28.4900 0.0450 1.2800 32,741,778.0 41,909,475.84 0.1919
2021 36.6300 0.0450 1.6500 95,444,809.0 157,483,934.85 0.6695
2022 10.4100 1.0000 10.4100 121,305,086.0 1,262,785,945.26 3.4999
2023 3.2200 1.0000 3.2200 6,435,197.0 20,721,334.34 0.0547
0001708341 Allied Gaming Entertainment Inc Allied AGAE 2019 2.6300 1.0000 2.6300 23,176,146.0 60,953,263.98 1.2398
2021 1.8300 1.0000 1.8300 39,141,907.0 71,629,689.81 1.2682
2023 1.3700 1.0000 1.3700 36,842,663.0 50,474,448.31 0.7728
0001744489 Walt Disney Co Walt Di DIS 2020 173.6400 1.0000 173.6400 1,810,485,037.0 314,372,621,824.68 2.7555
2021 153.2200 1.0000 153.2200 1,817,655,948.0 278,501,244,352.56 2.3733
2022 86.9000 1.0000 86.9000 1,823,591,988.0 158,470,143,757.20 1.3620
2023 91.1400 1.0000 91.1400 1,830,315,921.0 166,814,993,039.94 1.4095
0001758488 Onespaworld Holdings Ltd Onespaw OSW 2020 nan nan nan nan nan nan
2022 nan nan nan nan nan nan
0001766363 Endeavor Group Holdings Inc Endeavo EDR 2021 33.3100 1.0000 33.3100 264,109,869.0 8,797,499,736.39 0.8567
2022 20.7400 1.0000 20.7400 289,423,865.0 6,002,650,960.10 0.5533
0001772757 Draftkings Holdings Inc Draftki nan 2020 nan nan nan 391,713,826.0 nan nan
2021 nan nan nan 406,453,020.0 nan nan
0001793659 Rush Street Interactive Inc Rush St RSI 2020 21.6000 1.0000 21.6000 23,000,000.0 496,800,000.00 1.1237
2021 16.6200 1.0000 16.6200 59,255,080.0 984,819,429.60 3.8650
2022 3.1900 1.0000 3.1900 64,130,715.0 204,576,980.85 0.8013
2023 4.3800 1.0000 4.3800 71,615,525.0 313,675,999.50 1.3334
0001795250 Sphere Entertainment Co Sphere SPHR 2020 40.7600 2.1650 88.2500 19,613,212.0 1,730,865,959.00 0.7584
2021 32.0300 2.1650 69.3400 27,324,977.0 1,894,713,905.18 0.4587
2022 19.7900 2.1650 42.8500 27,683,119.0 1,186,221,649.15 0.2671
2023 34.1100 1.0000 34.1100 28,243,621.0 963,389,912.31 0.2617
0001802156 Xponential Fitness Inc Xponent XPOF 2021 20.2300 1.0000 20.2300 23,898,042.0 483,457,389.66 1.2645
2022 22.3600 1.0000 22.3600 27,566,312.0 616,382,736.32 1.4249
0001803977 Limitless X Holdings Inc Limitle LIMX 2020 6.0000 0.0330 0.2000 10,753,504.0 2,150,700.80 16.1386
2021 36.0000 0.0330 1.1900 10,753,504.0 12,796,669.76 84.5282
2022 7.4600 1.0000 7.4600 117,893,460.0 879,485,211.60 57.2030
2023 0.6000 1.0000 0.6000 3,976,998.0 2,386,198.80 0.3539
0001816554 Eventiko INC Eventik EVTK 2021 nan nan nan 4,192,500.0 nan nan
2022 nan nan nan 4,192,500.0 nan nan
2023 nan nan nan 4,192,500.0 nan nan
0001824403 Reservoir Media Inc Reservo RSVR 2022 nan nan nan 64,373,904.0 nan nan
2023 nan nan nan 64,810,835.0 nan nan
0001829966 EBET Inc EBET In EBET 2021 541.3500 0.0330 17.8600 14,171,739.0 253,107,258.54 28.3302
2022 15.5000 0.0330 0.5100 16,447,163.0 8,388,053.13 0.1450
2023 0.0600 1.0000 0.0600 300,183,243.0 18,010,994.58 0.4497
0001839360 FaZe Holdings Inc FaZe Ho nan 2022 nan nan nan 72,506,849.0 nan nan
0001840572 Lucky Strike Entertainment Corp Lucky S LUCK 2022 nan nan nan 109,787,558.0 nan nan
2023 nan nan nan 92,768,345.0 nan nan
0001856031 Vivid Seats Inc Vivid S SEAT 2022 nan nan nan 81,296,366.0 nan nan
0001869198 Life Time Group Holdings Inc Life Ti LTH 2021 17.4400 1.0000 17.4400 193,059,950.0 3,366,965,528.00 0.6463
2022 12.0700 1.0000 12.0700 194,188,729.0 2,343,857,959.03 0.4211
2023 15.0900 1.0000 15.0900 196,408,901.0 2,963,810,316.09 0.5017
0001883685 Draftkings Inc Draftki DKNG 2022 nan nan nan 448,848,235.0 nan nan
2023 nan nan nan 466,241,933.0 nan nan
0001952073 Madison Square Garden Entertainment Corp Madison MSGE 2022 nan 1.0000 nan nan nan nan
2023 31.6200 1.0000 31.6200 41,103,124.0 1,299,680,780.88 0.9050