QA: us_consulting 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
0001304161 Pharma Bio Serv Inc Pharma NaN 1 1 1 2 3 1 1 NaN NaN 1 4 2 1 NaN 262.022480 291.685390 291.959050 277.891990 282.201340 262.713230 262.082010 NaN NaN 210.649250 186.956460 225.597700 232.189050 NaN 0 0 1 1 -2 0 NaN NaN NaN 3 -2 -1
0001084554 Lightbridge Corp Lightbr NaN 14 9 12 14 26 14 18 9 NaN 16 2 NaN 2 NaN 91.835589 101.509630 40.176394 49.166344 -290.894200 -7.468109 -25.128349 138.377610 NaN 50.047007 207.931020 NaN 231.431290 NaN -5 3 2 12 -12 4 -9 NaN NaN -14 NaN NaN
0001644378 RMR Group INC RMR Gro NaN NaN NaN NaN NaN NaN 2 3 2 2 NaN 3 4 3 NaN NaN NaN NaN NaN NaN 207.805840 218.290000 288.893890 235.165540 NaN 206.609580 195.627830 231.417100 NaN NaN NaN NaN NaN NaN 1 -1 0 NaN NaN 1 -1
0001437226 Mastech Digital Inc Mastech NaN 6 8 5 4 13 8 13 14 6 4 5 3 4 NaN 168.475630 108.211070 166.643290 186.114620 95.173358 113.405310 53.570045 84.746759 132.391080 150.245460 177.597580 224.545450 184.619920 NaN 2 -3 -1 9 -5 5 1 -8 -2 1 -2 1
0000887936 FTI Consulting INC FTI Con NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 9 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 122.272170 122.644010 153.484440 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 -4
0001013706 Wilhelmina International Inc Wilhelm NaN 11 5 3 7 6 9 9 8 9 10 8 7 6 NaN 126.630840 146.986910 170.664510 146.832200 155.022210 108.877660 140.117420 141.122390 103.036620 85.938103 147.735970 143.298850 138.447070 NaN -6 -2 4 -1 3 0 -1 1 1 -2 -1 -1
0001398659 Genpact LTD Genpact 1 8 NaN NaN 11 10 10 11 13 11 11 17 16 7 222.908590 151.754160 NaN NaN 110.482230 112.980440 108.834940 96.788910 85.460962 85.592242 84.447221 87.800573 85.834841 122.209910 7 NaN NaN NaN -1 0 1 2 -2 0 6 -1 -9
0001230524 Leopard Energy Inc Leopard NaN NaN 25 25 NaN NaN NaN NaN NaN 3 6 18 32 8 NaN NaN -685.781960 -1377.114500 NaN NaN NaN NaN NaN 234.213650 126.268770 81.751052 -576.486740 110.870710 NaN NaN 0 NaN NaN NaN NaN NaN NaN 3 12 14 -24
0001083446 Astrana Health Inc Astrana NaN 20 17 23 20 19 13 4 3 8 5 7 6 9 NaN 7.677973 -108.406910 -393.265620 -88.835701 -22.694742 11.947405 186.283320 236.826340 109.367500 148.580990 149.979620 143.768510 101.160290 NaN -3 6 -3 -1 -6 -9 -1 5 -3 2 -1 3
0001289848 Huron Consulting Group Inc Huron C NaN NaN 7 8 10 NaN NaN NaN NaN NaN 7 12 11 10 NaN NaN 134.521380 151.432880 124.610770 NaN NaN NaN NaN NaN 107.556340 120.646180 107.081130 94.812830 NaN NaN 1 2 NaN NaN NaN NaN NaN NaN 5 -1 -1
0001371489 Information Services Group Inc Informa NaN NaN 13 11 13 14 12 14 15 12 9 16 13 11 NaN NaN 53.131152 63.466405 63.251955 73.348848 39.671808 52.349243 74.661375 84.762463 86.941935 93.572286 95.507008 87.702166 NaN NaN -2 2 1 -2 2 1 -3 -3 7 -3 -2
0001847590 Bowman Consulting Group Ltd Bowman NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 12 12 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 126.417550 104.661120 77.876317 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 0
0001508348 Americann Inc America NaN NaN NaN NaN NaN NaN 18 16 16 NaN 15 20 17 13 NaN NaN NaN NaN NaN NaN -54.482098 -7.304624 74.094970 NaN 69.717943 61.082804 71.598176 72.661522 NaN NaN NaN NaN NaN NaN -2 0 NaN NaN 5 -3 -4
0001622879 Medicine Man Technologies Inc Medicin NaN NaN NaN NaN NaN 1 23 8 1 10 14 14 18 14 NaN NaN NaN NaN NaN 333.790920 -295.321190 161.838070 294.419570 94.077765 77.240200 106.890100 67.098772 46.875646 NaN NaN NaN NaN NaN 22 -15 -7 9 4 0 4 -4
0001443646 Booz Allen Hamilton Holding Corp Booz Al NaN 17 12 15 15 17 NaN NaN NaN NaN NaN NaN 20 15 NaN 60.773953 81.745768 21.824805 21.630452 21.982561 NaN NaN NaN NaN NaN NaN 43.466583 33.008333 NaN -5 3 0 2 NaN NaN NaN NaN NaN NaN NaN -5
0001320760 TSS Inc. TSS Inc NaN 13 16 16 18 20 16 NaN 12 13 17 22 22 16 NaN 97.284568 18.528133 7.426792 -25.469523 -30.983717 -40.342356 NaN 94.721012 29.401209 23.292283 8.994142 15.230769 24.131582 NaN 3 0 2 2 -4 NaN NaN 1 4 5 0 -6
0001877939 Castellum Inc Castell NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 21 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 26.396007 -21.342425 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4
0001419275 Ryvyl Inc Ryvyl I NaN 23 NaN 19 24 23 21 NaN NaN 17 20 21 25 18 NaN -242.276400 NaN -104.697570 -255.968150 -126.043700 -207.621780 NaN NaN -101.468220 -54.664754 31.168604 -74.992838 -33.400237 NaN NaN NaN 5 -1 -2 NaN NaN NaN 3 1 4 -7
0001630212 Avalon Globocare Corp Avalon NaN NaN NaN NaN NaN 35 NaN NaN NaN NaN NaN NaN NaN 19 NaN NaN NaN NaN NaN -1837.907500 NaN NaN NaN NaN NaN NaN NaN -73.194472 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001657045 Next Chemx Corporation Next Ch NaN NaN NaN NaN NaN NaN NaN NaN 21 16 2 23 24 20 NaN NaN NaN NaN NaN NaN NaN NaN -119.631130 -75.869816 198.292680 6.589211 -47.233108 -121.646540 NaN NaN NaN NaN NaN NaN NaN NaN -5 -14 21 1 -4
0001599407 1847 Holdings LLC 1847 Ho NaN NaN NaN NaN 26 28 26 17 19 15 21 24 23 21 NaN NaN NaN NaN -353.898380 -312.612160 -433.527870 -20.803504 -77.037618 -52.880815 -125.422420 -5.556364 -24.886405 -156.676240 NaN NaN NaN NaN 2 -2 -9 2 -4 6 3 -1 -2
0000723533 Longwen Group Corp Longwen NaN 26 NaN NaN 17 NaN NaN NaN NaN NaN NaN NaN 26 22 NaN -588.792860 NaN NaN -10.224756 NaN NaN NaN NaN NaN NaN NaN -235.256920 -181.107560 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4
0001777319 Ciso Global Inc Ciso Gl NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 12 26 10 23 NaN NaN NaN NaN NaN NaN NaN NaN NaN 169.319270 84.249275 -69.704213 112.322730 -205.341900 NaN NaN NaN NaN NaN NaN NaN NaN NaN 7 14 -16 13
0001632121 Balance Labs Inc Balance NaN NaN NaN NaN NaN 33 NaN 29 26 22 22 28 29 24 NaN NaN NaN NaN NaN -629.045370 NaN -543.311330 -312.006910 -348.850400 -140.751220 -241.987220 -307.713300 -311.883600 NaN NaN NaN NaN NaN NaN NaN -3 -4 0 6 1 -5
0001439264 Marvion Inc Marvion NaN 27 23 NaN NaN NaN NaN NaN NaN NaN NaN 29 28 25 NaN -786.511250 -341.586390 NaN NaN NaN NaN NaN NaN NaN NaN -477.505810 -303.116340 -365.041700 NaN -4 NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 -3
0001813603 Hestia Insight Inc Hestia NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 30 31 26 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -873.407250 -372.066120 -415.447050 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 -5
0001019737 Navigant Consulting INC Navigan 2 9 6 4 9 8 5 6 4 NaN NaN NaN NaN NaN 120.121980 141.660580 143.109220 169.008940 127.548220 142.419460 146.433040 164.197280 236.053440 NaN NaN NaN NaN NaN 7 -3 -2 5 -1 -3 1 -2 NaN NaN NaN NaN NaN
0001066104 CEB Inc. CEB Inc 3 18 14 14 16 18 15 NaN NaN NaN NaN NaN NaN NaN 40.491478 40.964945 21.804727 22.128392 10.672024 11.088082 -30.992602 NaN NaN NaN NaN NaN NaN NaN 15 -4 0 2 2 -3 NaN NaN NaN NaN NaN NaN NaN
0000851520 Exponent INC Exponen NaN 4 2 NaN 3 5 3 5 5 NaN NaN 6 5 NaN NaN 196.048490 192.104030 NaN 189.688060 183.244700 187.623930 176.484540 192.951990 NaN NaN 170.197750 153.662360 NaN NaN -2 NaN NaN 2 -2 2 0 NaN NaN NaN -1 NaN
0001057379 Hackett Group INC Hackett NaN 2 3 7 NaN 7 6 7 6 4 NaN 1 14 NaN NaN 233.076260 165.176470 155.013900 NaN 147.347380 140.352850 162.876290 190.642550 202.949300 NaN 211.812060 93.080306 NaN NaN 1 4 NaN NaN -1 1 -1 -2 NaN NaN 13 NaN
0001094238 Harris Interactive INC Harris NaN 19 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 38.690610 20.202989 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001094814 Cartesian Inc Cartesi NaN 5 NaN 6 NaN 9 19 19 NaN NaN NaN NaN NaN NaN NaN 179.746680 NaN 161.320460 NaN 141.542350 -63.790144 -41.249494 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 0 NaN NaN NaN NaN NaN NaN
0001098482 Innovaro Inc Innovar NaN 15 20 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 65.729823 -153.672260 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001179090 Bonds com Group Inc Bonds c NaN 22 18 20 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -238.075400 -145.496360 -148.794800 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001272550 Root9B Holdings Inc Root9B NaN 3 10 10 25 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN 197.053790 92.165652 112.261410 -300.602420 108.699890 NaN NaN NaN NaN NaN NaN NaN NaN NaN 7 0 15 -14 NaN NaN NaN NaN NaN NaN NaN NaN
0001362004 ICF International Inc ICF Int NaN 10 4 2 12 12 7 10 10 7 8 15 15 NaN NaN 135.538800 148.565380 174.791200 99.022805 107.299240 120.105900 134.206050 127.748660 118.852160 97.694728 95.618910 87.250749 NaN NaN -6 -2 10 0 -5 3 0 -3 1 7 0 NaN
0001366312 Juhl Energy Inc Juhl En NaN 16 NaN 13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 61.023441 NaN 23.387277 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001382219 6D Global Technologies Inc 6D Glob NaN 7 NaN 18 5 22 NaN NaN NaN NaN NaN NaN NaN NaN NaN 159.795660 NaN -29.752738 176.072100 -119.086410 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -13 17 NaN NaN NaN NaN NaN NaN NaN NaN
0001388982 Chuma Holdings INC Chuma H NaN 25 27 22 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -407.673940 -2182.863300 -370.562480 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 -5 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001400683 Stwc Holdings Inc Stwc Ho NaN 24 22 NaN NaN NaN NaN NaN 22 NaN NaN NaN NaN NaN NaN -349.323880 -305.730200 NaN NaN NaN NaN NaN -131.615750 NaN NaN NaN NaN NaN NaN -2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001438673 Evergreen Agra Global Investments Inc Evergre NaN 28 24 NaN NaN NaN 29 NaN NaN NaN NaN NaN NaN NaN NaN -1410.202800 -670.275430 NaN NaN NaN -580.274100 NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001470215 Towers Watson Co Towers NaN 12 11 9 8 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 116.429110 91.948483 123.677790 138.050790 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 -2 -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001502966 Hypha Labs Inc Hypha L NaN 21 21 21 6 NaN NaN 12 20 18 23 27 27 NaN NaN -3.011792 -184.182430 -254.218100 158.324810 NaN NaN 81.108003 -86.116298 -168.202200 -216.784040 -110.299360 -266.965150 NaN NaN 0 0 -15 NaN NaN NaN 8 -2 5 4 0 NaN
0001228386 Transatlantic Capital INC Transat NaN NaN 19 NaN NaN 29 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN -150.371900 NaN NaN -353.983880 -386.928680 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN NaN NaN NaN NaN NaN NaN
0001533106 Argentum 47 INC Argentu NaN NaN 26 24 27 16 11 28 24 20 NaN NaN NaN NaN NaN NaN -989.068240 -444.950000 -515.019170 46.636556 88.228165 -455.210660 -227.666930 -275.013650 NaN NaN NaN NaN NaN NaN -2 3 -11 -5 17 -4 -4 NaN NaN NaN NaN
0001286345 Hpil Holding Hpil Ho NaN NaN NaN 17 1 2 34 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -24.537493 300.177910 313.282500 -2789.692900 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -16 1 32 NaN NaN NaN NaN NaN NaN NaN
0001567503 Turnkey Capital Inc Turnkey NaN NaN NaN 26 NaN 27 31 26 30 25 NaN NaN NaN NaN NaN NaN NaN -1525.158400 NaN -297.633630 -604.197770 -421.946280 -435.669970 -397.938910 NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 -5 4 -5 NaN NaN NaN NaN
0001096132 Petrone Worldwide INC Petrone NaN NaN NaN NaN 28 NaN 32 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1828.379200 NaN -632.727900 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001501489 Af Ocean Investment Management Co Af Ocea NaN NaN NaN NaN 21 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -181.899440 59.457269 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -6 NaN NaN NaN NaN NaN NaN NaN NaN
0001537511 Progressive Green Solutions INC Progres NaN NaN NaN NaN 22 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -182.863550 -202.863970 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN NaN NaN NaN
0001590565 Asia Equity Exchange Group INC Asia Eq NaN NaN NaN NaN 23 34 NaN 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -207.424200 -937.074390 NaN 235.571280 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 NaN NaN NaN NaN NaN NaN NaN NaN
0001600347 Hapi Metaverse Inc Hapi Me NaN NaN NaN NaN 19 NaN 27 24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -35.533219 NaN -455.086520 -331.639420 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3 NaN NaN NaN NaN NaN NaN
0001104265 Grow Solutions Holdings INC Grow So NaN NaN NaN NaN NaN 21 24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -95.074499 -322.597210 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN NaN NaN
0001574910 Renavotio INC Renavot NaN NaN NaN NaN NaN 30 NaN 20 11 NaN 19 NaN NaN NaN NaN NaN NaN NaN NaN -432.105700 NaN -42.533334 103.761400 NaN -33.010940 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -9 NaN NaN NaN NaN NaN
0001602813 Frontera Group INC Fronter NaN NaN NaN NaN NaN 32 30 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -526.755290 -604.059900 -378.993560 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 -5 NaN NaN NaN NaN NaN NaN
0001604738 Ashford Inc Ashford NaN NaN NaN NaN NaN 4 4 15 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 219.089460 169.368460 31.750475 182.019580 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 11 -8 NaN NaN NaN NaN NaN
0001607450 ABV Consulting INC ABV Con NaN NaN NaN NaN NaN 31 33 30 27 23 26 NaN NaN NaN NaN NaN NaN NaN NaN -483.827740 -1074.497100 -570.052780 -340.911410 -363.289510 -342.114990 NaN NaN NaN NaN NaN NaN NaN NaN 2 -3 -3 -4 3 NaN NaN NaN
0001620749 Panamera Holdings Corp Panamer NaN NaN NaN NaN NaN 24 20 23 28 26 27 NaN 30 NaN NaN NaN NaN NaN NaN -182.285260 -139.733340 -306.831480 -407.228450 -408.945870 -378.084580 NaN -342.861600 NaN NaN NaN NaN NaN NaN -4 3 5 -2 1 NaN NaN NaN
0001560449 Phmc Inc Phmc In NaN NaN NaN NaN NaN NaN 28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -563.020040 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001592782 Nukkleus Inc Nukkleu NaN NaN NaN NaN NaN NaN 17 21 23 24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -52.262813 -53.268019 -204.509200 -365.753390 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 2 1 NaN NaN NaN NaN
0001629606 Driven Deliveries Inc Driven NaN NaN NaN NaN NaN NaN 22 27 31 19 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -242.149130 -429.632150 -2065.500400 -252.617180 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 4 -12 NaN NaN NaN NaN
0001100778 Rokk3R Inc Rokk3R NaN NaN NaN NaN NaN NaN NaN 32 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -6622.581600 63.010675 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -15 NaN NaN NaN NaN NaN
0001653099 Vigilant Diversified Holdings INC Nv Vigilan NaN NaN NaN NaN NaN NaN NaN 31 29 27 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -829.723160 -426.189830 -422.979760 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 -2 NaN NaN NaN NaN
0001661600 Sativus Tech Corp Sativus NaN NaN NaN NaN NaN NaN NaN 22 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -267.841430 -265.153800 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN NaN NaN
0001693687 Greenlit Ventures INC Greenli NaN NaN NaN NaN NaN NaN NaN NaN 18 14 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -61.028120 -21.381953 -260.026520 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 11 NaN NaN NaN
0001498291 Daniels Corporate Advisory Company Inc Daniels NaN NaN NaN NaN NaN NaN NaN NaN NaN 21 24 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -297.193900 -232.901860 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 NaN NaN NaN
0001751143 Atlas Technical Consultants INC Atlas T NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 18 25 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 286.588570 -3.373420 -57.156159 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 17 7 NaN NaN
0001643615 Montrose Environmental Group Inc Montros NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 13 13 8 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 82.573306 118.632690 124.408170 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 -5 NaN
0001654672 Pineapple INC Pineapp NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 9 33 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 169.893770 136.040420 -1957.304000 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 24 NaN
0001790625 Agilethought Inc Agileth NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 19 19 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 69.569322 55.525225 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN
0001640265 GPB Holdings Ii Lp GPB Hol NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 248.851930 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 1 × Negative Expenses, ignoring company. pre-agg
error 1 × Minimum and maximum are surprisingly similar check_abs_values
{'var_name': 'Liabilities', 'min_val': '408,314,000', 'max_val': '427,333,000'}
warning 15 × The stock price does not exist industry.us_generic
warning 6 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 4 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '3 of 3'}
{'var_name': 'LaborExpense', 'zeros': '3 of 3'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '3 of 3'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '3 of 3'}
warning 2 × Ignoring company because Expenses is zero pre-agg
warning 2 × 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 219,485,000 227,412,400 298,886,404 872,077,900 935,780,000 0001019737 0001066104 0001398659
1 IntangibleAssets 43,094,000 97,204,200 584,199,861 601,569,600 603,500,000 0001066104 0001019737 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0001019737 0001066104 0001019737
3 AssetsNoncurrent 65,354,000 70,210,800 113,962,649 296,844,300 317,169,000 0001019737 0001066104 0001398659
4 remainder_Assets 0 3,701,200 37,015,472 52,637,800 54,374,000 0001019737 0001398659 0001066104
5 LiabilitiesCurrent 155,579,000 172,275,900 322,552,362 342,177,000 344,358,000 0001019737 0001398659 0001066104
6 LiabilitiesNoncurrent 73,546,000 74,421,000 82,330,088 235,691,100 252,735,000 0001398659 0001066104 0001019737
7 remainder_Liabilities 0 67,900 682,089 14,580,400 16,125,000 0001019737 0001066104 0001398659
8 CostOfRevenue 155,769,000 182,044,400 418,597,000 751,522,100 788,522,000 0001066104 0001019737 0001398659
9 GeneralAndAdministrativeExpense 60,871,000 66,952,400 121,717,083 266,060,300 282,102,000 0001066104 0001019737 0001398659
10 LaborExpense 0 0 0 0 0 0001019737 0001066104 0001019737
11 remainder_Expenses 50,162,000 59,272,900 141,279,755 180,666,700 185,044,000 0001398659 0001019737 0001066104
12 RevenueFromContractWithCustomer 0 0 0 0 0 0001019737 0001066104 0001019737
13 RevenueFromReimbursement 0 0 0 0 0 0001019737 0001066104 0001019737
14 remainder_Revenues 438,907,000 465,382,300 703,771,061 1,203,432,700 1,258,963,000 0001066104 0001019737 0001398659
15 remainder_NetIncome 1,876,000 2,002,400 3,141,543 10,082,600 10,854,000 0001019737 0001066104 0001398659
16 remainder_ComprehensiveNetIncome 0 0 0 0 0 0001019737 0001066104 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 510,149,000 546,037,600 869,239,885 1,791,018,400 1,893,461,000 0001066104 0001019737 0001398659
1 Liabilities 408,314,000 408,704,500 412,222,023 425,821,600 427,333,000 0001019737 0001398659 0001066104
2 Expenses 401,684,000 429,663,500 681,566,861 1,076,855,300 1,120,786,000 0001066104 0001019737 0001398659
3 Revenues 438,907,000 465,382,300 703,771,061 1,203,432,700 1,258,963,000 0001066104 0001019737 0001398659
4 StockholdersEquity 82,816,000 120,606,500 460,925,104 1,379,189,900 1,481,242,000 0001066104 0001019737 0001398659
5 NetIncome 24,057,000 25,687,600 40,384,734 138,164,200 149,031,000 0001019737 0001066104 0001398659
6 ComprehensiveNetIncome 24,057,000 25,687,600 40,384,734 138,164,200 149,031,000 0001019737 0001066104 0001398659
7 BaseVar 1,076,227,320 1,132,337,118 1,637,572,650 2,750,399,274 2,874,074,160 0001066104 0001019737 0001398659
8 EconomicCapitalRatio 0.405 0.485 1.20 2.13 2.23 0001066104 0001019737 0001398659

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.248 -0.213 0.105 0.105 0.105 0001019737 0001398659 0001066104
1 IntangibleAssets -0.436 -0.391 0.00932 0.441 0.489 0001066104 0001398659 0001019737
2 OperatingLeaseAssets 0 0 0 0 0 0001019737 0001066104 0001019737
3 AssetsNoncurrent -0.109 -0.0950 0.0306 0.0632 0.0668 0001019737 0001398659 0001066104
4 remainder_Assets -0.0522 -0.0479 -0.00966 0.0862 0.0969 0001019737 0001398659 0001066104
5 LiabilitiesCurrent -0.711 -0.601 0.397 0.409 0.411 0001066104 0001398659 0001019737
6 LiabilitiesNoncurrent -0.424 -0.378 0.0367 0.342 0.376 0001019737 0001066104 0001398659
7 remainder_Liabilities -0.0239 -0.0209 0.00596 0.0111 0.0117 0001398659 0001066104 0001019737
8 CostOfRevenue -0.178 -0.171 -0.113 0.227 0.265 0001398659 0001019737 0001066104
9 GeneralAndAdministrativeExpense -0.0783 -0.0697 0.00749 0.0596 0.0654 0001398659 0001019737 0001066104
10 LaborExpense 0 0 0 0 0 0001019737 0001066104 0001019737
11 remainder_Expenses -0.265 -0.236 0.0208 0.243 0.267 0001066104 0001019737 0001398659
12 RevenueFromContractWithCustomer 0 0 0 0 0 0001019737 0001066104 0001019737
13 RevenueFromReimbursement 0 0 0 0 0 0001019737 0001066104 0001019737
14 remainder_Revenues -0.0575 -0.0501 0.0168 0.0431 0.0461 0001066104 0001019737 0001398659
15 remainder_NetIncome -0.00542 -0.00478 0.00101 0.00386 0.00418 0001019737 0001066104 0001398659
16 remainder_ComprehensiveNetIncome 0 0 0 0 0 0001019737 0001066104 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.235 -0.217 -0.0585 0.122 0.142 0001066104 0001019737 0001398659
1 Liabilities -0.650 -0.578 0.0769 0.640 0.703 0001066104 0001019737 0001398659
2 Expenses -0.0852 -0.0755 0.0114 0.0604 0.0658 0001019737 0001398659 0001066104
3 Revenues -0.0575 -0.0501 0.0168 0.0431 0.0461 0001066104 0001019737 0001398659
4 StockholdersEquity -0.782 -0.708 -0.0400 0.796 0.888 0001066104 0001019737 0001398659
5 NetIncome -0.0738 -0.0655 0.00934 0.0564 0.0616 0001019737 0001066104 0001398659
6 ComprehensiveNetIncome -0.0738 -0.0655 0.00934 0.0564 0.0616 0001019737 0001066104 0001398659
7 BaseVar nan nan nan nan nan 0001019737 0001066104 0001019737
8 EconomicCapitalRatio -0.873 -0.794 -0.0770 0.848 0.951 0001066104 0001019737 0001398659

2011

Logs

error 6 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 1 × Negative Expenses, ignoring company. pre-agg
warning 19 × The stock price does not exist industry.us_generic
warning 15 × No stock price available subcommand.plot
warning 11 × Missing logo subcommand.report
warning 7 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 5 × Ignoring company because Expenses is zero pre-agg
warning 5 × Ignoring company because Assets is zero pre-agg
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '28 of 28'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '28 of 28'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '28 of 28'}
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -7.1730981048240725}
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 1 × Ignoring company because ECR is too negative 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 1,118 19,984 15,598,973 1,229,079,600 1,650,551,000 0001400683 0001366312 0001470215
1 IntangibleAssets 0 0 3,173,970 1,237,401,550 2,638,496,000 0000723533 0001382219 0001470215
2 OperatingLeaseAssets 0 0 0 0 0 0000723533 0001272550 0000723533
3 AssetsNoncurrent 0 0 1,553,368 263,336,050 621,334,000 0000723533 0001094814 0001470215
4 remainder_Assets -3,749,731 -1,684,772 32,442 137,063,000 202,327,000 0001382219 0001083446 0001398659
5 LiabilitiesCurrent 0 0 6,690,275 794,627,550 1,178,194,000 0000723533 0001437226 0001470215
6 LiabilitiesNoncurrent 0 0 460,785 262,345,050 1,160,164,000 0000723533 0001094814 0001443646
7 remainder_Liabilities 0 0 255,464 64,572,600 1,124,037,000 0001013706 0001179090 0001470215
8 CostOfRevenue 0 0 0 501,805,050 1,004,899,000 0000723533 0001098482 0001398659
9 GeneralAndAdministrativeExpense 0 3,101 5,033,336 331,224,950 881,028,000 0000723533 0001272550 0001443646
10 LaborExpense 0 0 0 105,280,150 2,043,063,000 0000723533 0001094238 0001470215
11 remainder_Expenses -4,495,000 6,959 3,372,862 565,965,200 4,566,086,000 0001057379 0001438673 0001443646
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000723533 0001272550 0000723533
13 RevenueFromReimbursement 0 0 0 0 0 0000723533 0001272550 0000723533
14 remainder_Revenues 0 0 5,133,146 1,334,554,650 3,259,451,000 0001094238 0001084554 0001470215
15 remainder_NetIncome -4,970,000 -1,022,129 141,467 119,385,000 5,531,808,000 0001066104 0001083446 0001443646
16 remainder_ComprehensiveNetIncome -1,635,000 -13,000 0 247,000 1,997,899 0001443646 0001272550 0001382219
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 13,530 58,035 21,050,980 2,806,800,400 5,098,950,000 0001400683 0001320760 0001470215
1 Liabilities 66,113 301,410 11,293,555 1,714,598,850 2,496,280,000 0001400683 0001320760 0001470215
2 Expenses 39,560 149,088 18,969,669 2,516,362,150 5,447,114,000 0001400683 0001098482 0001443646
3 Revenues 0 0 5,133,146 1,334,554,650 3,259,451,000 0001094238 0001084554 0001470215
4 StockholdersEquity -5,235,722 -1,357,139 11,233,093 1,250,731,450 2,602,670,000 0001179090 0001366312 0001470215
5 NetIncome -14,457,558 -7,548,602 174,038 153,842,300 196,725,000 0001179090 0001272550 0001470215
6 ComprehensiveNetIncome -14,457,558 -7,548,602 649,479 153,270,050 196,725,000 0001179090 0001437226 0001470215
7 BaseVar 69,038 435,040 57,917,397 6,822,170,623 10,476,399,040 0001400683 0001094814 0001443646
8 EconomicCapitalRatio -14.1 -7.17 0.789 2.20 2.62 0001438673 0001084554 0001304161

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 -5.14 -3.17 -0.175 0.748 1.52 0001438673 0001272550 0001084554
1 IntangibleAssets -4.51 -1.55 -0.134 0.825 0.979 0001438673 0001320760 0001019737
2 OperatingLeaseAssets 0 0 0 0 0 0000723533 0001272550 0000723533
3 AssetsNoncurrent -3.35 -1.07 -0.131 0.365 1.10 0001438673 0001362004 0001366312
4 remainder_Assets -1.49 -0.217 -0.0473 0.817 2.43 0001438673 0001094814 0001439264
5 LiabilitiesCurrent -3.44 -1.47 0.267 1.73 3.00 0001438673 0001098482 0001388982
6 LiabilitiesNoncurrent -2.87 -2.07 0.210 1.05 1.76 0001438673 0001502966 0001437226
7 remainder_Liabilities -1.79 -1.32 0.167 4.38 8.66 0001083446 0001066104 0001439264
8 CostOfRevenue -6.35 -1.56 0.221 0.723 1.13 0001437226 0001419275 0001438673
9 GeneralAndAdministrativeExpense -2.85 -1.12 0.233 0.622 0.848 0001439264 0001382219 0000723533
10 LaborExpense -1.13 -0.700 0.128 0.370 0.538 0000851520 0001094814 0001437226
11 remainder_Expenses -7.02 -3.18 0.344 1.34 3.36 0001438673 0001304161 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000723533 0001272550 0000723533
13 RevenueFromReimbursement 0 0 0 0 0 0000723533 0001272550 0000723533
14 remainder_Revenues -3.21 -1.95 0.0910 2.03 5.62 0001438673 0001419275 0001437226
15 remainder_NetIncome -4.85 -0.879 -0.272 3.07 3.68 0001438673 0001066104 0001272550
16 remainder_ComprehensiveNetIncome -0.0213 -0.0147 -0.00598 0.0121 0.0820 0001437226 0001019737 0001382219
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -9.10 -3.92 -0.0555 0.848 0.917 0001438673 0001057379 0001366312
1 Liabilities -5.49 -1.16 0.571 2.02 2.95 0001438673 0001019737 0001437226
2 Expenses -4.80 -2.96 0.0172 0.720 0.932 0001438673 0001098482 0001304161
3 Revenues -3.21 -1.95 0.0910 2.03 5.62 0001438673 0001419275 0001437226
4 StockholdersEquity -3.06 -2.66 0.355 1.78 1.93 0001388982 0001437226 0001084554
5 NetIncome -12.9 -4.58 0.632 1.32 2.50 0001438673 0001066104 0001437226
6 ComprehensiveNetIncome -12.9 -4.59 0.628 1.31 2.47 0001438673 0001066104 0001437226
7 BaseVar nan nan nan nan nan 0000723533 0001272550 0000723533
8 EconomicCapitalRatio -13.6 -6.64 1.32 2.74 3.15 0001438673 0001084554 0001304161

2012

Logs

error 9 × No matching role found input.sec.calculation_linkbase.expand_agg
error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Negative Expenses, ignoring company. pre-agg
warning 20 × The stock price does not exist industry.us_generic
warning 11 × No stock price available subcommand.plot
warning 10 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 8 × Missing logo subcommand.report
warning 6 × Ignoring company because Expenses is zero pre-agg
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 4 × Ignoring company because ECR is too negative pre-agg
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '27 of 27'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '27 of 27'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '27 of 27'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -8.980823532184253}
warning 1 × Similarly named company. Duplicate? None
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 246 11,892,474 1,267,665,600 1,759,397,000 0001230524 0001013706 0001470215
1 IntangibleAssets 0 0 1,723,234 1,230,233,600 3,021,403,000 0001084554 0001179090 0001470215
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001289848 0000851520
3 AssetsNoncurrent 0 1,938 859,728 213,591,300 418,687,000 0001400683 0001013706 0001470215
4 remainder_Assets -14,309,446 0 2,283 32,818,700 157,491,000 0001272550 0001388982 0001470215
5 LiabilitiesCurrent 0 5,820 9,282,627 796,128,100 1,102,982,000 0001084554 0001320760 0001470215
6 LiabilitiesNoncurrent 0 0 137 510,068,300 1,159,878,000 0001057379 0001388982 0001443646
7 remainder_Liabilities 0 0 83,932 58,425,700 1,605,496,000 0001013706 0001304161 0001470215
8 CostOfRevenue 0 0 0 479,819,900 583,195,000 0000851520 0001094238 0001362004
9 GeneralAndAdministrativeExpense 0 334 3,843,989 278,659,200 903,721,000 0001304161 0001084554 0001443646
10 LaborExpense 0 0 0 123,311,600 2,067,689,000 0001019737 0001230524 0001470215
11 remainder_Expenses -59,000 2,392 2,645,918 657,482,300 4,720,062,000 0001057379 0001320760 0001443646
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001289848 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001289848 0000851520
14 remainder_Revenues 0 0 531,037 909,385,400 3,417,736,000 0001094238 0001098482 0001470215
15 remainder_NetIncome -10,048,000 -6,810,636 0 106,595,900 5,863,738,000 0001066104 0001502966 0001443646
16 remainder_ComprehensiveNetIncome -337,703,000 -2,791,300 0 3,121,300 26,888,000 0001470215 0001533106 0001066104
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 4,890 11,337 16,420,202 2,717,028,400 5,356,978,000 0001228386 0001437226 0001470215
1 Liabilities 87,809 234,293 9,533,762 1,852,748,300 2,899,661,000 0001400683 0001437226 0001470215
2 Expenses 23,032 121,159 15,015,215 2,490,532,300 5,623,783,000 0001400683 0001179090 0001443646
3 Revenues 0 0 531,037 909,385,400 3,417,736,000 0001094238 0001098482 0001470215
4 StockholdersEquity -1,827,643 -1,603,186 6,902,570 997,552,400 2,457,317,000 0001179090 0001437226 0001470215
5 NetIncome -9,999,599 -8,747,270 -22,621 182,458,200 260,476,000 0001098482 0001400683 0001470215
6 ComprehensiveNetIncome -77,227,000 -9,874,054 -324,904 60,464,100 236,693,000 0001470215 0001502966 0001443646
7 BaseVar 66,725 629,784 41,621,548 7,035,560,442 10,995,562,260 0001400683 0001272550 0001443646
8 EconomicCapitalRatio -21.8 -8.98 0.219 1.84 2.92 0001388982 0001066104 0001304161

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 -11.7 -3.79 -0.159 0.597 2.17 0001388982 0001320760 0001084554
1 IntangibleAssets -9.55 -3.16 -0.381 0.860 1.02 0001388982 0001084554 0001272550
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001289848 0000851520
3 AssetsNoncurrent -5.30 -1.57 -0.140 1.39 2.07 0001388982 0001013706 0001098482
4 remainder_Assets -1.16 -0.556 -0.0258 0.772 2.09 0001388982 0001362004 0001533106
5 LiabilitiesCurrent -5.07 -0.759 0.503 5.61 7.97 0001388982 0001228386 0001438673
6 LiabilitiesNoncurrent -6.23 -1.49 0.181 0.764 1.55 0001388982 0001272550 0001437226
7 remainder_Liabilities -11.0 -2.22 0.124 0.443 1.02 0001228386 0001439264 0001437226
8 CostOfRevenue -7.43 -2.63 0.294 0.994 1.53 0001437226 0001098482 0001388982
9 GeneralAndAdministrativeExpense -1.95 -1.28 0.196 0.575 1.69 0001533106 0001289848 0001388982
10 LaborExpense -1.05 -0.915 0.139 0.489 0.614 0001179090 0001019737 0001437226
11 remainder_Expenses -4.83 -2.36 0.282 2.90 3.77 0001533106 0001084554 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001289848 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001289848 0000851520
14 remainder_Revenues -3.92 -1.78 0.0852 2.62 6.84 0001388982 0001066104 0001437226
15 remainder_NetIncome -19.4 -0.740 -0.0839 2.44 3.96 0001388982 0001502966 0001094238
16 remainder_ComprehensiveNetIncome -0.114 -0.0298 0.00511 0.0212 0.0336 0001470215 0001230524 0001066104
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -16.1 -5.56 -0.256 1.04 1.72 0001388982 0001443646 0001371489
1 Liabilities -9.53 -2.21 0.709 2.88 3.40 0001388982 0001083446 0001438673
2 Expenses -5.36 -2.23 -0.0904 0.853 7.17 0001533106 0001439264 0001388982
3 Revenues -3.92 -1.78 0.0852 2.62 6.84 0001388982 0001066104 0001437226
4 StockholdersEquity -3.14 -3.04 0.517 2.08 2.79 0001438673 0001371489 0001084554
5 NetIncome -16.1 -5.52 0.773 2.36 3.99 0001388982 0001470215 0001437226
6 ComprehensiveNetIncome -16.1 -5.51 0.659 2.37 4.02 0001388982 0001470215 0001437226
7 BaseVar nan nan nan nan nan 0000851520 0001289848 0000851520
8 EconomicCapitalRatio -20.3 -7.46 1.74 3.36 4.44 0001388982 0001066104 0001304161

2013

Logs

error 5 × No matching role found input.sec.calculation_linkbase.expand_agg
error 4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Unusually strong effect check_effects
{'var_name': 'EconomicCapitalRatio', 'quantile_value': '-10.4', 'quantile': 0.05}
warning 22 × The stock price does not exist industry.us_generic
warning 15 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 12 × No stock price available subcommand.plot
warning 8 × Ignoring company because Expenses is zero pre-agg
warning 7 × Missing logo subcommand.report
warning 7 × Ignoring company because Assets is zero pre-agg
warning 4 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '26 of 26'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '26 of 26'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '26 of 26'}
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Ignoring company because ECR is too negative pre-agg
warning 2 × Similarly named company. Duplicate? None
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -11.440733590393952}
warning 1 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 1 × Ignoring company because Liabilities is zero pre-agg

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 5,003 13,370,795 1,183,806,250 1,712,221,000 0001230524 0001320760 0001470215
1 IntangibleAssets 0 0 1,981,490 1,323,308,500 2,906,693,000 0001084554 0001320760 0001470215
2 OperatingLeaseAssets 0 0 0 0 0 0001013706 0001289848 0001013706
3 AssetsNoncurrent 0 50.2 1,082,601 214,118,500 626,850,000 0001084554 0001013706 0001470215
4 remainder_Assets -10,660,139 -3,121,544 1,099 9,696,250 86,313,000 0001272550 0001388982 0001470215
5 LiabilitiesCurrent 0 13,953 7,212,362 867,085,000 1,112,873,000 0001084554 0001437226 0001470215
6 LiabilitiesNoncurrent 0 0 167,737 522,421,000 1,929,071,000 0001057379 0001533106 0001443646
7 remainder_Liabilities 0 0 0 54,901,750 1,247,620,000 0001013706 0001272550 0001470215
8 CostOfRevenue 0 0 0 507,454,250 591,516,000 0001013706 0001083446 0001362004
9 GeneralAndAdministrativeExpense 0 0 3,129,736 295,700,750 833,986,000 0001094814 0001083446 0001443646
10 LaborExpense 0 0 0 10,700,248 2,085,188,000 0001019737 0001272550 0001470215
11 remainder_Expenses 1,281 12,400 4,997,151 661,508,500 4,697,376,000 0001388982 0001179090 0001443646
12 RevenueFromContractWithCustomer 0 0 0 0 0 0001013706 0001289848 0001013706
13 RevenueFromReimbursement 0 0 0 0 0 0001013706 0001289848 0001013706
14 remainder_Revenues 0 0 1,811,593 920,873,500 3,432,515,000 0001094814 0001084554 0001470215
15 remainder_NetIncome -30,275,000 -6,689,958 -35,880 30,764,106 5,750,420,000 0001066104 0001362004 0001443646
16 remainder_ComprehensiveNetIncome -5,072,000 -564,000 0 11,966,889 54,441,000 0001443646 0001179090 0001470215
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,178 7,352 22,933,640 2,729,064,750 5,332,077,000 0001567503 0001272550 0001470215
1 Liabilities 2,204 156,058 9,294,865 2,251,415,500 2,950,735,000 0001567503 0001094814 0001443646
2 Expenses 29,647 96,058 16,796,808 2,589,823,000 5,531,362,000 0001567503 0001366312 0001443646
3 Revenues 0 0 1,811,593 920,873,500 3,432,515,000 0001094814 0001084554 0001470215
4 StockholdersEquity -1,420,967 -935,905 9,341,897 580,372,250 2,744,834,000 0001533106 0001437226 0001470215
5 NetIncome -16,431,320 -8,210,036 -108,046 180,901,750 315,652,000 0001382219 0001567503 0001470215
6 ComprehensiveNetIncome -15,429,764 -8,210,036 -108,046 177,238,250 370,093,000 0001382219 0001567503 0001470215
7 BaseVar 28,195 782,272 49,629,992 7,192,081,640 11,190,666,380 0001567503 0001366312 0001443646
8 EconomicCapitalRatio -15.3 -11.4 0.228 1.74 2.92 0001567503 0001366312 0001304161

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.62 -6.32 -0.292 1.07 2.13 0001567503 0001057379 0001084554
1 IntangibleAssets -8.03 -4.16 -0.193 0.651 0.770 0001567503 0001382219 0001019737
2 OperatingLeaseAssets 0 0 0 0 0 0001013706 0001289848 0001013706
3 AssetsNoncurrent -6.02 -2.85 -0.162 1.47 3.03 0001567503 0001057379 0001286345
4 remainder_Assets -0.507 -0.192 0.0202 0.301 0.371 0001272550 0001320760 0001084554
5 LiabilitiesCurrent -5.79 -0.684 0.595 2.34 3.33 0001567503 0001179090 0001230524
6 LiabilitiesNoncurrent -3.89 -1.90 0.0790 0.600 1.60 0001567503 0001094814 0001437226
7 remainder_Liabilities -1.45 -0.704 0.0703 0.218 0.598 0001567503 0001362004 0001437226
8 CostOfRevenue -8.05 -2.24 0.216 1.32 2.02 0001437226 0001304161 0001567503
9 GeneralAndAdministrativeExpense -9.90 -1.22 0.224 1.01 1.04 0001567503 0001371489 0001437226
10 LaborExpense -4.41 -0.609 0.119 0.475 0.557 0001179090 0001019737 0001437226
11 remainder_Expenses -4.07 -2.89 0.0658 1.32 3.44 0001230524 0001066104 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0001013706 0001289848 0001013706
13 RevenueFromReimbursement 0 0 0 0 0 0001013706 0001289848 0001013706
14 remainder_Revenues -3.35 -1.90 -0.0901 2.12 7.49 0001179090 0001366312 0001437226
15 remainder_NetIncome -4.93 -2.47 -0.119 2.46 6.72 0001230524 0001362004 0001179090
16 remainder_ComprehensiveNetIncome -0.0283 -0.0260 -0.00743 0.0145 0.0528 0001437226 0001371489 0001382219
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -12.9 -8.44 -0.181 1.71 1.96 0001567503 0001362004 0001286345
1 Liabilities -7.31 -1.10 0.566 1.72 3.12 0001567503 0001289848 0001437226
2 Expenses -10.7 -2.95 -0.139 0.714 0.836 0001567503 0001443646 0001304161
3 Revenues -3.35 -1.90 -0.0901 2.12 7.49 0001179090 0001366312 0001437226
4 StockholdersEquity -4.47 -3.22 0.128 2.08 2.36 0001230524 0001382219 0001286345
5 NetIncome -11.7 -7.17 0.481 1.98 4.12 0001567503 0001066104 0001437226
6 ComprehensiveNetIncome -11.7 -7.18 0.484 1.97 4.10 0001567503 0001066104 0001437226
7 BaseVar nan nan nan nan nan 0001013706 0001289848 0001013706
8 EconomicCapitalRatio -14.2 -10.4 1.31 2.82 4.00 0001567503 0001366312 0001304161

2014

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
error 3 × Negative Expenses, ignoring company. pre-agg
error 3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 25 × The stock price does not exist industry.us_generic
warning 20 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 14 × No stock price available subcommand.plot
warning 10 × Ignoring company because Expenses is zero pre-agg
warning 7 × Missing logo subcommand.report
warning 6 × Ignoring company because Assets is zero pre-agg
warning 4 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '28 of 28'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '28 of 28'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '28 of 28'}
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.586268942599746}
warning 1 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
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 41,984 6,681,697 1,232,362,850 1,808,498,000 0000723533 0001320760 0001470215
1 IntangibleAssets 0 0 161,982 1,381,654,700 2,970,351,000 0000723533 0001501489 0001470215
2 OperatingLeaseAssets 0 0 0 0 0 0000723533 0001320760 0000723533
3 AssetsNoncurrent 0 0 731,162 276,275,050 769,834,000 0000723533 0001320760 0001470215
4 remainder_Assets -4,503,800 -191,225 19,269 57,869,900 79,103,000 0001272550 0000723533 0001470215
5 LiabilitiesCurrent 0 0 2,550,995 814,365,350 1,034,599,000 0000723533 0001304161 0001470215
6 LiabilitiesNoncurrent 0 0 336,283 751,463,050 1,786,441,000 0000723533 0001419275 0001443646
7 remainder_Liabilities 0 0 0 59,423,100 1,193,983,000 0001013706 0001371489 0001470215
8 CostOfRevenue 0 0 0 629,735,150 1,378,088,000 0000723533 0001272550 0001398659
9 GeneralAndAdministrativeExpense 0 0 3,424,151 491,776,700 742,527,000 0001304161 0001084554 0001443646
10 LaborExpense 0 0 0 124,216,850 2,106,431,000 0000723533 0001304161 0001470215
11 remainder_Expenses 2,610 29,672 3,941,617 609,474,400 4,502,184,000 0000723533 0001371489 0001443646
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000723533 0001320760 0000723533
13 RevenueFromReimbursement 0 0 0 0 0 0000723533 0001320760 0000723533
14 remainder_Revenues 0 0 2,045,648 1,849,181,600 3,481,912,000 0000723533 0001537511 0001470215
15 remainder_NetIncome -37,571,000 -6,080,450 0 16,069,700 5,476,899,000 0001398659 0001502966 0001443646
16 remainder_ComprehensiveNetIncome -48,876,000 -2,573,950 0 4,773,800 102,748,000 0001066104 0000723533 0001470215
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 35,363 47,155 9,951,704 2,871,419,650 5,627,786,000 0000723533 0001320760 0001470215
1 Liabilities 17,085 44,113 5,906,876 2,146,034,400 2,769,182,000 0000723533 0001437226 0001443646
2 Expenses 22,044 158,127 8,647,793 2,754,938,200 5,244,711,000 0000723533 0001382219 0001443646
3 Revenues 0 0 2,045,648 1,849,181,600 3,481,912,000 0000723533 0001537511 0001470215
4 StockholdersEquity -5,480,525 -2,402,131 5,443,469 1,045,560,300 3,110,949,000 0001272550 0001502966 0001470215
5 NetIncome -36,398,000 -17,569,733 -37,523 218,182,050 366,314,000 0001019737 0000723533 0001470215
6 ComprehensiveNetIncome -39,141,000 -17,569,733 -37,523 222,830,200 469,062,000 0001019737 0000723533 0001470215
7 BaseVar 42,096 240,300 24,966,525 7,635,986,525 10,579,707,920 0000723533 0001083446 0001443646
8 EconomicCapitalRatio -18.3 -4.59 0.355 2.47 3.00 0001096132 0001084554 0001286345

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.7 -2.81 -0.261 1.60 3.19 0001096132 0001398659 0001502966
1 IntangibleAssets -8.05 -1.45 -0.133 0.812 0.991 0001096132 0001502966 0001362004
2 OperatingLeaseAssets 0 0 0 0 0 0000723533 0001320760 0000723533
3 AssetsNoncurrent -7.61 -1.30 -0.196 0.598 1.36 0001096132 0001362004 0001286345
4 remainder_Assets -1.04 -0.764 -0.0936 2.38 5.94 0001272550 0001289848 0000723533
5 LiabilitiesCurrent -7.26 -1.56 0.339 2.10 2.81 0001096132 0001398659 0001533106
6 LiabilitiesNoncurrent -5.00 -0.852 0.101 0.653 1.72 0001096132 0001600347 0001437226
7 remainder_Liabilities -2.34 -1.07 0.0576 0.263 0.319 0001096132 0001371489 0001382219
8 CostOfRevenue -8.37 -1.48 0.216 0.824 1.38 0001437226 0001502966 0001096132
9 GeneralAndAdministrativeExpense -2.41 -1.08 0.239 0.899 1.14 0001096132 0001590565 0001437226
10 LaborExpense -1.08 -0.606 0.0811 0.345 0.408 0000851520 0001533106 0001437226
11 remainder_Expenses -11.9 -3.05 0.272 0.861 4.33 0001096132 0001600347 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000723533 0001320760 0000723533
13 RevenueFromReimbursement 0 0 0 0 0 0000723533 0001320760 0000723533
14 remainder_Revenues -4.72 -1.26 0.262 3.36 7.09 0001096132 0001599407 0001437226
15 remainder_NetIncome -1.36 -0.666 -0.0662 0.755 2.67 0001533106 0001501489 0001443646
16 remainder_ComprehensiveNetIncome -0.0504 -0.0192 0.00408 0.0182 0.0398 0001066104 0001084554 0001470215
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -15.3 -3.66 -0.185 1.09 1.35 0001096132 0001362004 0001502966
1 Liabilities -9.30 -1.47 0.186 2.37 3.14 0001096132 0001362004 0001437226
2 Expenses -12.5 -2.30 -0.0470 0.689 0.797 0001096132 0001083446 0001304161
3 Revenues -4.72 -1.26 0.262 3.36 7.09 0001096132 0001599407 0001437226
4 StockholdersEquity -5.62 -3.67 -0.225 2.20 2.73 0001419275 0001501489 0001286345
5 NetIncome -16.2 -1.75 0.524 2.22 4.27 0001096132 0001304161 0001437226
6 ComprehensiveNetIncome -16.2 -1.75 0.502 2.23 4.28 0001096132 0001066104 0001437226
7 BaseVar nan nan nan nan nan 0000723533 0001320760 0000723533
8 EconomicCapitalRatio -17.6 -3.94 1.000 3.12 3.65 0001096132 0001084554 0001286345

2015

Logs

error 3 × Negative Expenses, ignoring company. pre-agg
error 3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 26 × The stock price does not exist industry.us_generic
warning 23 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 22 × No stock price available subcommand.plot
warning 8 × Ignoring company because Expenses is zero pre-agg
warning 6 × Missing logo subcommand.report
warning 6 × Ignoring company because Assets is zero pre-agg
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '35 of 35'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '35 of 35'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '35 of 35'}
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -7.214540794702365}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
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 194 3,965 1,712,299 659,259,100 1,195,069,000 0001630212 0001104265 0001398659
1 IntangibleAssets 0 0 294,919 863,496,200 1,523,613,000 0001084554 0001501489 0001443646
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001398659 0000851520
3 AssetsNoncurrent 0 0 656,371 168,720,100 355,401,000 0001084554 0001437226 0001398659
4 remainder_Assets -21,077,793 -7,989,607 0.0204 42,050,600 106,072,000 0001272550 0001567503 0001398659
5 LiabilitiesCurrent 4,648 7,718 2,286,913 597,034,800 848,994,000 0001607450 0001533106 0001443646
6 LiabilitiesNoncurrent 0 0 84,120 732,575,000 1,770,046,000 0001057379 0001537511 0001443646
7 remainder_Liabilities 0 0 0 31,840,400 58,444,000 0001013706 0001094814 0001443646
8 CostOfRevenue 0 0 0 426,351,500 694,436,000 0000851520 0001371489 0001362004
9 GeneralAndAdministrativeExpense 0 0 582,522 201,971,100 752,912,000 0001304161 0001501489 0001443646
10 LaborExpense 0 0 0 23,037,600 183,533,000 0001019737 0001371489 0000851520
11 remainder_Expenses -294,236 0 1,672,797 159,949,400 4,288,217,000 0001286345 0001437226 0001443646
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001398659 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001398659 0000851520
14 remainder_Revenues 0 0 836,031 922,170,400 1,132,232,000 0001228386 0001622879 0001362004
15 remainder_NetIncome -21,630,000 -8,800,954 0 112,956,406 5,273,698,000 0001066104 0001590565 0001443646
16 remainder_ComprehensiveNetIncome -39,367,000 -8,163,900 0 45,469 10,854,000 0001066104 0001567503 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 194 4,222 6,832,200 1,775,033,100 2,863,982,000 0001630212 0001286345 0001443646
1 Liabilities 5,600 9,994 3,706,814 1,353,152,400 2,677,484,000 0001630212 0001084554 0001443646
2 Expenses 21,857 42,013 3,938,231 927,315,000 5,041,129,000 0001228386 0001104265 0001443646
3 Revenues 0 0 836,031 922,170,400 1,132,232,000 0001228386 0001622879 0001362004
4 StockholdersEquity -1,631,600 -1,142,849 455,268 544,354,600 1,304,356,000 0001537511 0001622879 0001398659
5 NetIncome -17,111,290 -9,449,818 -46,721 134,540,300 239,817,000 0001382219 0001607450 0001398659
6 ComprehensiveNetIncome -17,111,290 -5,482,844 -46,721 104,222,100 239,817,000 0001382219 0001607450 0001398659
7 BaseVar 25,221 53,395 11,701,100 2,483,652,382 10,208,585,000 0001630212 0001537511 0001443646
8 EconomicCapitalRatio -18.4 -7.21 0.111 2.92 3.34 0001630212 0001066104 0001622879

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 -10.7 -2.29 -0.339 0.956 1.10 0001630212 0001013706 0001304161
1 IntangibleAssets -8.49 -2.36 -0.420 0.607 0.735 0001630212 0001437226 0001272550
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001398659 0000851520
3 AssetsNoncurrent -6.48 -1.70 -0.372 0.854 1.78 0001630212 0001228386 0001272550
4 remainder_Assets -0.705 -0.474 0.369 2.68 6.28 0001382219 0001599407 0001630212
5 LiabilitiesCurrent -2.70 -0.459 0.490 2.10 2.95 0001630212 0001419275 0001632121
6 LiabilitiesNoncurrent -4.18 -1.02 0.0179 0.891 2.76 0001630212 0001567503 0001607450
7 remainder_Liabilities -0.795 -0.333 0.0279 0.153 0.226 0001630212 0001537511 0001622879
8 CostOfRevenue -4.19 -1.35 0.165 0.432 0.647 0001437226 0001620749 0001630212
9 GeneralAndAdministrativeExpense -12.8 -1.38 0.272 1.19 1.53 0001630212 0001320760 0001590565
10 LaborExpense -1.02 -0.572 0.0677 0.154 0.210 0000851520 0001533106 0001630212
11 remainder_Expenses -6.64 -1.78 0.0575 1.61 2.91 0001590565 0001622879 0001630212
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001398659 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001398659 0000851520
14 remainder_Revenues -3.17 -1.51 -0.0975 2.93 3.36 0001630212 0001501489 0001437226
15 remainder_NetIncome -0.820 -0.546 -0.154 1.29 2.55 0001533106 0001362004 0001443646
16 remainder_ComprehensiveNetIncome -0.0558 -0.0392 0.000748 0.00541 0.159 0001622879 0001567503 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -14.0 -4.14 -0.471 1.13 1.47 0001630212 0001620749 0001371489
1 Liabilities -5.99 -1.09 0.593 1.90 3.27 0001630212 0001083446 0001622879
2 Expenses -8.98 -2.57 -0.0966 0.792 1.01 0001630212 0001083446 0001533106
3 Revenues -3.17 -1.51 -0.0975 2.93 3.36 0001630212 0001501489 0001437226
4 StockholdersEquity -3.78 -3.06 -0.236 2.43 3.08 0001630212 0001443646 0001286345
5 NetIncome -12.6 -3.83 0.481 2.32 2.69 0001630212 0001604738 0001419275
6 ComprehensiveNetIncome -12.6 -3.83 0.525 2.28 2.70 0001630212 0001398659 0001419275
7 BaseVar nan nan nan nan nan 0000851520 0001398659 0000851520
8 EconomicCapitalRatio -17.1 -5.98 1.35 4.15 4.57 0001630212 0001066104 0001622879

2016

Logs

error 3 × Negative Expenses, ignoring company. pre-agg
error 3 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Median ECR is negative check_abs_values
{'median': -0.5337245516094372}
warning 26 × The stock price does not exist industry.us_generic
warning 25 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 20 × No stock price available subcommand.plot
warning 7 × Ignoring company because Expenses is zero pre-agg
warning 6 × Ignoring company because Assets is zero pre-agg
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '34 of 34'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '34 of 34'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '34 of 34'}
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × Similarly named company. Duplicate? None
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -7.873471320697618}
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 5.00 65.6 1,333,602 358,675,200 1,227,037,000 0001228386 0001104265 0001398659
1 IntangibleAssets 0 0 0 736,604,800 1,141,457,000 0001084554 0001620749 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001371489 0000851520
3 AssetsNoncurrent 0 0 53,434 187,463,100 442,443,000 0001084554 0001419275 0001398659
4 remainder_Assets -3,708 0 0 61,052,500 83,319,000 0001622879 0001104265 0000851520
5 LiabilitiesCurrent 10,298 28,148 1,987,771 337,009,450 731,355,000 0001602813 0001304161 0001398659
6 LiabilitiesNoncurrent 0 0 0 475,616,150 976,574,000 0001057379 0001096132 0001066104
7 remainder_Liabilities 0 0 0 30,340,300 62,807,000 0001013706 0001104265 0001644378
8 CostOfRevenue 0 0 0 478,510,350 745,137,000 0000851520 0001013706 0001362004
9 GeneralAndAdministrativeExpense 0 0 483,854 135,640,200 328,048,000 0001304161 0001508348 0001362004
10 LaborExpense 0 0 0 28,033,050 193,397,000 0001019737 0001362004 0000851520
11 remainder_Expenses 0 26,276 1,450,779 94,974,250 498,911,000 0001228386 0001437226 0001066104
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001371489 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001371489 0000851520
14 remainder_Revenues 0 0 696,443 979,434,100 1,185,097,000 0001228386 0001084554 0001362004
15 remainder_NetIncome -23,491,000 -6,956,116 -173 3,765,350 329,645,000 0001066104 0001602813 0001398659
16 remainder_ComprehensiveNetIncome -95,042,000 -35,408,750 0 29,033 10,007,000 0001066104 0001560449 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 5.00 65.6 3,803,172 1,200,028,350 2,885,880,000 0001228386 0001508348 0001398659
1 Liabilities 10,298 28,148 2,979,639 893,351,250 1,594,712,000 0001602813 0001508348 0001398659
2 Expenses 26,143 42,830 4,652,320 967,026,850 1,139,697,000 0001560449 0001286345 0001362004
3 Revenues 0 0 696,443 979,434,100 1,185,097,000 0001228386 0001084554 0001362004
4 StockholdersEquity -174,930,000 -3,140,735 -1,552 589,969,550 1,291,168,000 0001066104 0001602813 0001398659
5 NetIncome -34,658,000 -12,921,000 -258,409 80,590,050 267,547,000 0001066104 0001304161 0001398659
6 ComprehensiveNetIncome -129,700,000 -10,634,103 -227,876 47,311,550 267,547,000 0001066104 0001304161 0001398659
7 BaseVar 34,142 56,994 12,438,631 2,494,056,122 2,961,144,360 0001560449 0001304161 0001066104
8 EconomicCapitalRatio -27.9 -7.87 -0.534 1.95 2.63 0001286345 0001592782 0001304161

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 -17.7 -2.90 -0.353 1.35 2.17 0001286345 0001083446 0001620749
1 IntangibleAssets -9.84 -1.59 -0.269 0.919 1.06 0001286345 0001620749 0001362004
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001371489 0000851520
3 AssetsNoncurrent -5.54 -0.794 -0.151 0.136 0.698 0001286345 0001084554 0001644378
4 remainder_Assets -8.61 -1.36 -0.332 1.50 3.23 0001286345 0001599407 0001508348
5 LiabilitiesCurrent -13.9 -0.440 0.863 3.85 4.31 0001286345 0001604738 0001438673
6 LiabilitiesNoncurrent -7.55 -1.21 -0.0298 0.529 0.752 0001286345 0001228386 0001592782
7 remainder_Liabilities -3.11 -0.831 -0.00414 0.174 0.308 0001286345 0001104265 0001437226
8 CostOfRevenue -4.53 -1.49 0.171 0.654 1.02 0001437226 0001438673 0001286345
9 GeneralAndAdministrativeExpense -3.06 -1.38 0.153 1.20 2.59 0001629606 0001057379 0001286345
10 LaborExpense -0.969 -0.589 0.0785 0.287 0.385 0000851520 0001084554 0001286345
11 remainder_Expenses -18.5 -4.06 0.147 1.71 3.18 0001286345 0001533106 0001437226
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001371489 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001371489 0000851520
14 remainder_Revenues -5.14 -1.45 -0.0196 3.67 6.42 0001286345 0001533106 0001592782
15 remainder_NetIncome -2.86 -0.338 0.130 0.442 0.587 0001096132 0001019737 0001084554
16 remainder_ComprehensiveNetIncome -0.554 -0.0609 0.0170 0.0833 0.187 0001644378 0001567503 0001604738
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -21.9 -4.32 -0.856 1.60 1.74 0001286345 0001437226 0001371489
1 Liabilities -16.1 -0.961 1.01 2.55 2.87 0001286345 0001320760 0001438673
2 Expenses -14.5 -3.33 -0.161 0.914 1.61 0001286345 0001620749 0001096132
3 Revenues -5.14 -1.45 -0.0196 3.67 6.42 0001286345 0001533106 0001592782
4 StockholdersEquity -3.07 -3.01 0.275 2.18 2.73 0001228386 0001508348 0001304161
5 NetIncome -19.3 -4.60 0.538 3.15 4.99 0001286345 0001398659 0001592782
6 ComprehensiveNetIncome -19.2 -4.57 0.548 3.20 5.07 0001286345 0001398659 0001592782
7 BaseVar nan nan nan nan nan 0000851520 0001371489 0000851520
8 EconomicCapitalRatio -25.6 -5.56 1.78 4.26 4.94 0001286345 0001592782 0001304161

2017

Logs

error 4 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Median ECR is negative check_abs_values
{'median': -0.1405406424724935}
warning 26 × The stock price does not exist industry.us_generic
warning 26 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 18 × No stock price available subcommand.plot
warning 9 × Ignoring company because Expenses is zero pre-agg
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '32 of 32'}
{'var_name': 'RevenueFromContractWithCustomer', 'zeros': '32 of 32'}
{'var_name': 'RevenueFromReimbursement', 'zeros': '32 of 32'}
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -6.8690445186354685}
warning 1 × Similarly named company. Duplicate? None
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 0 1,951,377 322,677,050 1,433,895,000 0001100778 0001533106 0001398659
1 IntangibleAssets 0 0 0 686,722,400 1,468,712,000 0001084554 0001304161 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001508348 0000851520
3 AssetsNoncurrent 0 0 1,445,583 252,302,354 469,199,000 0001100778 0001084554 0001398659
4 remainder_Assets -293,380,760 -4,226,408 68.4 70,906,450 79,113,000 0001083446 0001533106 0000851520
5 LiabilitiesCurrent 0 25,635 1,594,804 192,641,050 838,784,000 0001653099 0001632121 0001398659
6 LiabilitiesNoncurrent 0 0 0 223,573,800 1,175,296,000 0001057379 0001100778 0001398659
7 remainder_Liabilities 0 0 0 39,667,800 60,091,000 0001013706 0001084554 0001644378
8 CostOfRevenue 0 0 0 440,180,400 771,725,000 0000851520 0001371489 0001362004
9 GeneralAndAdministrativeExpense 0 0 848,813 111,497,650 346,440,000 0001304161 0001590565 0001362004
10 LaborExpense 0 0 0 35,307,000 210,289,000 0001019737 0001437226 0000851520
11 remainder_Expenses 0 13,455 1,636,757 95,511,150 300,050,626 0001574910 0001502966 0001083446
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001508348 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001508348 0000851520
14 remainder_Revenues 0 0 236,330 661,308,225 1,229,162,000 0001100778 0001600347 0001362004
15 remainder_NetIncome -6,189,924 -1,258,119 0 7,709,316 320,583,000 0001533106 0001602813 0001398659
16 remainder_ComprehensiveNetIncome -66,375,000 -445,160 0 3,742,450 6,028,000 0001644378 0001629606 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 299 1,406 7,518,753 1,093,759,950 3,449,621,000 0001607450 0001599407 0001398659
1 Liabilities 22,913 33,288 1,624,516 438,512,750 2,020,827,000 0001602813 0001632121 0001398659
2 Expenses 3,866 24,507 3,704,767 610,128,975 1,166,407,000 0001304161 0001371489 0001362004
3 Revenues 0 0 236,330 661,308,225 1,229,162,000 0001100778 0001600347 0001362004
4 StockholdersEquity -1,524,646 -609,523 1,848,488 648,116,800 1,428,794,000 0001632121 0001508348 0001398659
5 NetIncome -37,898,285 -13,168,033 -114,816 90,124,650 260,841,000 0001100778 0001653099 0001398659
6 ComprehensiveNetIncome -37,898,285 -12,226,843 -60,948 73,553,350 260,841,000 0001100778 0001661600 0001398659
7 BaseVar 32,498 70,604 13,971,420 2,334,139,714 3,009,058,000 0001602813 0001622879 0001398659
8 EconomicCapitalRatio -66.2 -6.87 -0.140 2.26 2.62 0001100778 0001508348 0001304161

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 -57.6 -3.79 -0.282 1.42 1.62 0001100778 0001622879 0001084554
1 IntangibleAssets -45.0 -1.95 -0.286 0.786 3.42 0001100778 0001592782 0001622879
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001508348 0000851520
3 AssetsNoncurrent -43.2 -1.73 -0.208 1.26 3.91 0001100778 0001508348 0001622879
4 remainder_Assets -0.711 -0.413 -0.0452 3.19 32.5 0001622879 0001362004 0001100778
5 LiabilitiesCurrent -52.1 -1.29 0.464 2.69 4.24 0001100778 0001304161 0001607450
6 LiabilitiesNoncurrent -28.7 -1.10 -0.00124 0.338 0.438 0001100778 0001620749 0001502966
7 remainder_Liabilities -32.9 -1.07 0.0626 0.547 14.1 0001100778 0001057379 0001653099
8 CostOfRevenue -1.74 -1.43 0.161 0.445 2.98 0001057379 0001602813 0001100778
9 GeneralAndAdministrativeExpense -1.15 -1.10 0.148 0.939 5.60 0001084554 0001604738 0001100778
10 LaborExpense -0.947 -0.676 0.0704 0.188 1.10 0000851520 0001567503 0001100778
11 remainder_Expenses -53.6 -3.43 0.204 1.28 1.56 0001100778 0001632121 0001057379
12 RevenueFromContractWithCustomer 0 0 0 0 0 0000851520 0001508348 0000851520
13 RevenueFromReimbursement 0 0 0 0 0 0000851520 0001508348 0000851520
14 remainder_Revenues -13.0 -1.46 -0.0178 2.11 2.99 0001100778 0001567503 0001629606
15 remainder_NetIncome -5.00 -0.259 0.0904 0.481 3.55 0001533106 0001607450 0001100778
16 remainder_ComprehensiveNetIncome -1.29 -0.164 0.0372 0.289 1.05 0001632121 0001607450 0001533106
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -61.7 -4.86 -0.375 1.34 1.55 0001100778 0001057379 0001084554
1 Liabilities -54.8 -1.05 0.580 2.01 2.40 0001100778 0001084554 0001607450
2 Expenses -43.9 -2.50 0.0124 0.751 2.08 0001100778 0001362004 0001533106
3 Revenues -13.0 -1.46 -0.0178 2.11 2.99 0001100778 0001567503 0001629606
4 StockholdersEquity -4.35 -3.75 0.146 2.27 2.61 0001100778 0001604738 0001622879
5 NetIncome -53.4 -4.49 0.367 1.63 1.78 0001100778 0001592782 0001057379
6 ComprehensiveNetIncome -52.8 -3.88 0.393 1.67 1.87 0001100778 0001371489 0001057379
7 BaseVar nan nan nan nan nan 0000851520 0001508348 0000851520
8 EconomicCapitalRatio -63.4 -4.00 2.73 5.13 5.49 0001100778 0001508348 0001304161

2018

Logs

error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 28 × The stock price does not exist industry.us_generic
warning 27 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 14 × No stock price available subcommand.plot
warning 9 × Ignoring company because Expenses is zero pre-agg
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × Missing logo subcommand.report
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Zero effects check_effects
{'var_name': 'OperatingLeaseAssets', 'zeros': '31 of 31'}
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.3092990032688405}
warning 1 × Similarly named company. Duplicate? None
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 0 3,217,871 400,730,500 1,355,057,000 0001653099 0001100778 0001398659
1 IntangibleAssets 0 0 8,128 593,830,500 1,570,919,000 0001084554 0001400683 0001398659
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001533106 0000851520
3 AssetsNoncurrent 0 0 1,019,480 252,642,128 367,874,000 0001574910 0001100778 0001398659
4 remainder_Assets -272,681,763 -6,430,558 3,936 63,668,000 235,595,000 0001083446 0001629606 0001398659
5 LiabilitiesCurrent 0 0 1,458,061 211,937,500 976,312,000 0001632121 0001574910 0001398659
6 LiabilitiesNoncurrent 0 0 0 157,494,000 1,140,871,000 0001057379 0001657045 0001398659
7 remainder_Liabilities 0 0 80,141 43,690,000 55,303,000 0001013706 0001657045 0001604738
8 CostOfRevenue 0 0 0.0930 704,000,000 1,921,768,000 0000851520 0001320760 0001398659
9 GeneralAndAdministrativeExpense 0 0 1,438,255 249,779,000 693,865,000 0001607450 0001508348 0001398659
10 LaborExpense 0 0 0 101,060,500 215,052,000 0001019737 0001019737 0000851520
11 remainder_Expenses -523,805 41,664 1,407,947 96,820,500 174,815,000 0001400683 0001437226 0001371489
12 RevenueFromContractWithCustomer 0 0 0 846,306,000 3,000,790,000 0001019737 0001019737 0001398659
13 RevenueFromReimbursement 0 0 0 0 24,884,000 0001013706 0001693687 0000851520
14 remainder_Revenues -4,778,712 -477,517 0 464,716,376 743,614,000 0001084554 0001604738 0001019737
15 remainder_NetIncome -5,805,031 -4,199,500 0 19,923,000 104,589,000 0001083446 0001629606 0001019737
16 remainder_ComprehensiveNetIncome -153,734,000 -64,035,000 0 1,006,236 12,260,000 0001398659 0001607450 0001019737
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 4,180 7,152 6,061,452 1,065,704,500 3,529,445,000 0001620749 0001599407 0001398659
1 Liabilities 63,834 91,147 2,627,465 379,219,500 2,125,263,000 0001620749 0001508348 0001398659
2 Expenses 28,212 74,110 5,676,298 1,001,505,000 2,735,246,000 0001620749 0001100778 0001398659
3 Revenues -4,778,712 -32,517 2,303,553 1,040,793,500 3,000,790,000 0001084554 0001100778 0001398659
4 StockholdersEquity -3,394,000 -2,070,088 2,485,493 686,485,000 1,404,182,000 0001661600 0001320760 0001398659
5 NetIncome -15,676,108 -4,790,358 -29,044 169,228,500 281,258,000 0001084554 0001620749 0001398659
6 ComprehensiveNetIncome -15,676,108 -4,790,358 -29,044 111,781,500 133,291,000 0001084554 0001620749 0001019737
7 BaseVar 55,825 131,136 9,262,347 2,237,653,040 7,079,302,480 0001620749 0001508348 0001398659
8 EconomicCapitalRatio -20.7 -4.31 0.741 2.63 2.94 0001629606 0001508348 0001622879

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 -11.8 -1.29 -0.0985 1.35 5.13 0001629606 0001371489 0001084554
1 IntangibleAssets -7.39 -0.872 -0.187 0.607 0.994 0001629606 0001574910 0001604738
2 OperatingLeaseAssets 0 0 0 0 0 0000851520 0001533106 0000851520
3 AssetsNoncurrent -5.87 -0.582 -0.143 0.841 1.45 0001629606 0001362004 0001502966
4 remainder_Assets -4.15 -0.613 -0.111 2.78 4.33 0001629606 0001057379 0001693687
5 LiabilitiesCurrent -4.07 -0.763 0.775 1.97 3.97 0001629606 0001604738 0001567503
6 LiabilitiesNoncurrent -2.39 -0.929 0.00130 0.227 0.328 0001629606 0001632121 0001057379
7 remainder_Liabilities -6.94 -1.15 0.519 1.05 4.32 0001629606 0001574910 0001653099
8 CostOfRevenue -2.31 -1.95 0.232 0.626 1.44 0001502966 0001693687 0001629606
9 GeneralAndAdministrativeExpense -1.97 -1.05 0.115 0.330 0.423 0001400683 0001604738 0001013706
10 LaborExpense -1.07 -0.677 0.0847 0.278 0.460 0001400683 0001084554 0001629606
11 remainder_Expenses -13.2 -1.21 0.251 1.40 2.80 0001629606 0001604738 0001400683
12 RevenueFromContractWithCustomer -2.06 -0.932 -0.365 2.90 3.12 0001629606 0001661600 0001502966
13 RevenueFromReimbursement -0.0143 -0.00863 -0.00333 -0.00206 0.111 0001629606 0001622879 0000851520
14 remainder_Revenues -2.14 -1.03 -0.278 1.71 2.65 0001629606 0001620749 0001437226
15 remainder_NetIncome -1.44 -0.860 0.0517 0.557 3.67 0001661600 0001100778 0001400683
16 remainder_ComprehensiveNetIncome -0.587 -0.0485 0.0149 0.0644 0.0971 0001644378 0001592782 0001657045
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -15.8 -2.03 -0.121 1.62 2.75 0001629606 0001371489 0001084554
1 Liabilities -9.23 -0.404 1.10 1.95 1.99 0001629606 0001362004 0001057379
2 Expenses -10.9 -1.99 0.0634 0.724 1.11 0001629606 0001083446 0001661600
3 Revenues -4.22 -1.17 0.348 1.93 2.20 0001629606 0001604738 0001320760
4 StockholdersEquity -3.14 -2.79 0.706 2.80 3.06 0001567503 0001371489 0001084554
5 NetIncome -14.9 -1.20 0.504 1.99 2.41 0001629606 0001599407 0001400683
6 ComprehensiveNetIncome -14.8 -1.18 0.523 1.82 2.45 0001629606 0001599407 0001400683
7 BaseVar nan nan nan nan nan 0000851520 0001533106 0000851520
8 EconomicCapitalRatio -19.8 -3.49 1.56 3.45 3.77 0001629606 0001508348 0001622879

2019

Logs

error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Median ECR is negative check_abs_values
{'median': -0.2138195319184878}
warning 30 × The stock price does not exist industry.us_generic
warning 27 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 10 × No stock price available subcommand.plot
warning 9 × Ignoring company because Expenses is zero pre-agg
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.056437800029429}
warning 1 × Missing logo subcommand.report
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 0 1,101,497 455,815,000 1,551,676,000 0001653099 0001629606 0001398659
1 IntangibleAssets 0 0 454,449 624,489,216 1,805,327,000 0001230524 0001533106 0001398659
2 OperatingLeaseAssets 0 0 128 98,049,818 330,854,000 0001230524 0001230524 0001398659
3 AssetsNoncurrent 0 0 532,763 326,409,250 471,114,000 0001592782 0001533106 0001398659
4 remainder_Assets -355,764,780 -8,866,252 0 156,618,057 295,213,000 0001083446 0001230524 0001398659
5 LiabilitiesCurrent 0 0 4,419,222 273,695,409 910,211,000 0001653099 0001498291 0001398659
6 LiabilitiesNoncurrent 0 0 66,828 293,613,009 1,850,812,000 0001230524 0001622879 0001398659
7 remainder_Liabilities -18,269,448 -507,500 118,462 24,253,900 37,621,000 0001083446 0001693687 0001362004
8 CostOfRevenue 0 0 3,484,589 807,572,370 2,294,688,000 0001230524 0001498291 0001398659
9 GeneralAndAdministrativeExpense 0 0 752,480 304,789,500 794,901,000 0001592782 0001419275 0001398659
10 LaborExpense 0 0 0 10,831,060 130,619,000 0001057379 0001498291 0001644378
11 remainder_Expenses -1,995,000 0 1,057,204 52,669,600 127,148,000 0001437226 0001592782 0001398659
12 RevenueFromContractWithCustomer 0 0 2,368 1,203,152,929 3,520,543,000 0001230524 0001657045 0001398659
13 RevenueFromReimbursement 0 0 0 0 34,668,113 0001013706 0001502966 0001599407
14 remainder_Revenues 0 0 0 139,222,086 722,138,000 0001013706 0001362004 0001644378
15 remainder_NetIncome -6,580,039 -3,317,100 -3,496 1,030,576 4,054,156 0001083446 0001620749 0001751143
16 remainder_ComprehensiveNetIncome -94,471,000 -17,218,900 0 313,400 844,000 0001644378 0001592782 0001057379
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 671 1,417 7,264,050 1,196,665,904 4,454,184,000 0001620749 0001629606 0001398659
1 Liabilities 90,642 128,386 5,628,367 588,162,284 2,765,013,000 0001620749 0001629606 0001398659
2 Expenses 14,129 36,079 15,566,406 1,151,094,100 3,216,737,000 0001230524 0001629606 0001398659
3 Revenues 0 0 3,852,852 1,251,608,900 3,520,543,000 0001230524 0001498291 0001398659
4 StockholdersEquity -5,367,339 -3,853,810 1,168,400 658,896,200 1,689,171,000 0001419275 0001230524 0001398659
5 NetIncome -16,975,742 -10,597,522 -176,433 139,012,200 304,881,000 0001622879 0001657045 0001398659
6 ComprehensiveNetIncome -16,975,742 -10,569,022 -143,693 73,004,600 280,385,000 0001622879 0001657045 0001398659
7 BaseVar 67,485 142,291 29,073,770 2,600,634,824 8,478,851,220 0001620749 0001592782 0001398659
8 EconomicCapitalRatio -4.23 -4.06 -0.212 2.35 2.87 0001653099 0001693687 0001751143

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 -0.614 -0.0454 0.760 1.49 0001592782 0001230524 0001419275
1 IntangibleAssets -4.06 -0.877 -0.104 0.616 1.68 0001592782 0001644378 0001629606
2 OperatingLeaseAssets -0.863 -0.0903 -0.0153 0.103 0.171 0001592782 0001777319 0001599407
3 AssetsNoncurrent -4.48 -0.805 -0.318 0.843 3.61 0001592782 0001371489 0001230524
4 remainder_Assets -4.35 -1.17 -0.375 2.58 3.09 0001592782 0001437226 0001693687
5 LiabilitiesCurrent -0.598 -0.340 0.814 2.41 2.77 0001419275 0001751143 0001620749
6 LiabilitiesNoncurrent -1.04 -0.930 0.0151 0.327 0.343 0001398659 0001498291 0001057379
7 remainder_Liabilities -2.34 -1.14 0.285 1.01 9.93 0001657045 0001599407 0001653099
8 CostOfRevenue -22.0 -1.57 -0.225 0.482 0.563 0001592782 0001398659 0001533106
9 GeneralAndAdministrativeExpense -1.54 -0.393 0.0600 0.257 3.59 0001502966 0001533106 0001592782
10 LaborExpense -0.673 -0.355 0.0316 0.0872 0.564 0001013706 0001533106 0001592782
11 remainder_Expenses -2.00 -0.700 0.250 0.999 5.36 0001629606 0001419275 0001592782
12 RevenueFromContractWithCustomer -1.40 -1.05 -0.346 2.49 23.0 0001437226 0001657045 0001592782
13 RevenueFromReimbursement -0.764 -0.120 -0.0547 -0.0229 2.26 0001592782 0001083446 0001599407
14 remainder_Revenues -3.65 -0.572 -0.158 1.76 3.60 0001592782 0001620749 0001437226
15 remainder_NetIncome -1.01 -0.465 0.0883 0.230 1.32 0001533106 0001398659 0001592782
16 remainder_ComprehensiveNetIncome -0.332 -0.0112 0.00406 0.0447 0.0820 0001644378 0001083446 0001657045
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -6.01 -2.13 -0.470 0.905 1.59 0001592782 0001533106 0001230524
1 Liabilities -0.843 -0.329 0.953 2.18 2.28 0001657045 0001607450 0001057379
2 Expenses -12.5 -1.98 -0.0770 0.589 0.606 0001592782 0001419275 0001230524
3 Revenues -0.685 -0.631 0.0786 2.05 18.6 0001533106 0001777319 0001592782
4 StockholdersEquity -3.04 -3.00 0.676 2.61 2.96 0001567503 0001629606 0001751143
5 NetIncome -2.14 -1.07 0.128 1.50 7.43 0001629606 0001419275 0001592782
6 ComprehensiveNetIncome -2.14 -1.07 0.131 1.46 7.49 0001629606 0001419275 0001592782
7 BaseVar nan nan nan nan nan 0001013706 0001567503 0001013706
8 EconomicCapitalRatio -3.61 -3.44 0.405 2.97 3.48 0001653099 0001693687 0001751143

2020

Logs

error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
warning 30 × The stock price does not exist industry.us_generic
warning 27 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 12 × Ignoring company because Expenses is zero pre-agg
warning 6 × No stock price available subcommand.plot
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 4 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 2 × Ignoring company because ECR is too negative pre-agg
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.174884459057807}
warning 1 × Similarly named company. Duplicate? None
warning 1 × Missing logo subcommand.report
warning 1 × Large missing amount for aggregate "Liabilities" 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 1,440 6,360,724 434,545,600 1,748,868,000 0001654672 0001777319 0001398659
1 IntangibleAssets 0 0 1,382,260 863,276,000 1,932,420,000 0001304161 0001230524 0001398659
2 OperatingLeaseAssets 0 0 13,697 100,800,400 304,714,000 0001084554 0001777319 0001398659
3 AssetsNoncurrent 0 0 885,565 383,893,600 554,940,000 0001084554 0001502966 0001398659
4 remainder_Assets -344,612,000 -41,130,805 0 9,247,531 332,571,000 0001083446 0001362004 0001398659
5 LiabilitiesCurrent 123,327 155,583 4,764,596 381,089,300 1,204,152,000 0001620749 0001498291 0001398659
6 LiabilitiesNoncurrent 0 0 728,497 414,929,600 1,835,132,000 0001084554 0001574910 0001398659
7 remainder_Liabilities -10,959,000 -1,142,700 0 18,609,800 25,451,000 0001083446 0001398659 0001643615
8 CostOfRevenue 0 0 4,366,762 868,097,800 2,418,137,000 0001084554 0001777319 0001398659
9 GeneralAndAdministrativeExpense 0 517 3,837,028 339,334,200 789,849,000 0001693687 0001419275 0001398659
10 LaborExpense 0 0 0 6,403,370 9,142,000 0001083446 0001437226 0001013706
11 remainder_Expenses -1,317,576 0 2,772,465 123,174,700 250,150,000 0001508348 0001437226 0001751143
12 RevenueFromContractWithCustomer 0 0 83.2 1,308,050,600 3,709,377,000 0001084554 0001084554 0001398659
13 RevenueFromReimbursement 0 0 0 5,337,655 26,887,000 0001013706 0001437226 0001289848
14 remainder_Revenues 0 0 0 143,070,956 468,217,000 0001013706 0001230524 0001751143
15 remainder_NetIncome -57,571,000 -26,116,263 0 1,969,648 97,924,000 0001398659 0001751143 0001083446
16 remainder_ComprehensiveNetIncome -13,384,000 -1,935,900 0 101,400 2,467,000 0001398659 0001574910 0001371489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,232 16,428 19,246,569 1,484,345,800 4,873,513,000 0001620749 0001599407 0001398659
1 Liabilities 123,327 155,583 9,000,486 795,890,500 3,039,284,000 0001620749 0001508348 0001398659
2 Expenses 26,318 61,153 14,586,864 1,282,873,700 3,343,530,000 0001620749 0001084554 0001398659
3 Revenues 0 0 8,543,015 1,316,116,700 3,709,377,000 0001084554 0001419275 0001398659
4 StockholdersEquity -3,849,003 -2,137,895 6,732,228 688,455,300 1,834,229,000 0001498291 0001654672 0001398659
5 NetIncome -57,949,000 -26,504,900 -232,907 102,111,700 308,276,000 0001643615 0001230524 0001398659
6 ComprehensiveNetIncome -57,838,000 -27,067,400 -232,907 101,523,100 294,892,000 0001643615 0001230524 0001398659
7 BaseVar 85,189 207,450 28,143,450 3,014,170,150 9,085,579,140 0001620749 0001419275 0001398659
8 EconomicCapitalRatio -3.78 -3.17 0.773 1.90 2.11 0001620749 0001622879 0001304161

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.895 -0.778 -0.132 1.48 5.36 0001502966 0001654672 0001084554
1 IntangibleAssets -1.19 -1.08 -0.132 1.34 3.61 0001502966 0001654672 0001230524
2 OperatingLeaseAssets -0.232 -0.166 -0.0743 0.249 0.936 0001498291 0001437226 0001508348
3 AssetsNoncurrent -0.450 -0.342 -0.172 0.866 3.21 0001693687 0001657045 0001622879
4 remainder_Assets -0.931 -0.402 -0.110 0.956 4.45 0001622879 0001362004 0001654672
5 LiabilitiesCurrent -1.28 -0.438 0.669 1.66 1.89 0001632121 0001320760 0001620749
6 LiabilitiesNoncurrent -1.45 -0.765 -0.0130 0.554 0.934 0001508348 0001607450 0001657045
7 remainder_Liabilities -0.701 -0.268 0.0193 0.156 0.233 0001574910 0001632121 0001013706
8 CostOfRevenue -1.61 -1.30 -0.129 0.689 1.14 0001437226 0001643615 0001657045
9 GeneralAndAdministrativeExpense -0.699 -0.565 0.0530 0.327 0.442 0001657045 0001304161 0001751143
10 LaborExpense -0.536 -0.205 0.0332 0.0574 0.0642 0001013706 0001777319 0001437226
11 remainder_Expenses -1.50 -1.13 0.173 0.646 0.680 0001693687 0001654672 0001437226
12 RevenueFromContractWithCustomer -1.26 -1.05 -0.291 1.50 1.88 0001437226 0001508348 0001320760
13 RevenueFromReimbursement -0.0396 -0.0354 -0.0193 0.0167 0.598 0001437226 0001419275 0001599407
14 remainder_Revenues -0.594 -0.529 -0.244 1.41 3.22 0001657045 0001084554 0001437226
15 remainder_NetIncome -0.722 -0.196 -0.101 0.120 5.22 0001599407 0001371489 0001657045
16 remainder_ComprehensiveNetIncome -0.0437 -0.00385 0.000549 0.00482 0.0194 0001657045 0001693687 0001371489
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -1.97 -1.65 -0.225 1.60 1.67 0001498291 0001419275 0001230524
1 Liabilities -1.32 -0.451 0.561 1.45 2.03 0001632121 0001622879 0001437226
2 Expenses -1.03 -0.855 -0.143 0.608 1.18 0001502966 0001622879 0001657045
3 Revenues -1.79 -0.680 0.183 1.25 1.92 0001657045 0001777319 0001437226
4 StockholdersEquity -3.20 -2.91 0.614 1.72 1.94 0001607450 0001371489 0001084554
5 NetIncome -1.33 -1.18 0.108 0.796 4.61 0001084554 0001643615 0001657045
6 ComprehensiveNetIncome -1.33 -1.18 0.109 0.794 4.57 0001084554 0001643615 0001657045
7 BaseVar nan nan nan nan nan 0001013706 0001502966 0001013706
8 EconomicCapitalRatio -3.81 -3.20 0.748 1.87 2.08 0001620749 0001622879 0001304161

2021

Logs

error 5 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
warning 33 × The stock price does not exist industry.us_generic
warning 28 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 13 × Ignoring company because Expenses is zero pre-agg
warning 7 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 7 × Ignoring company because Assets is zero pre-agg
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × No stock price available subcommand.plot
warning 3 × Ignoring company because ECR is too negative pre-agg
warning 2 × Similarly named company. Duplicate? None
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.715224461172421}
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
warning 1 × Ignoring company because Liabilities is zero pre-agg
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 57,391 55,577,142 957,257,750 1,921,641,000 0001654672 0001790625 0001398659
1 IntangibleAssets 0 0 18,508,033 1,202,511,800 1,900,662,000 0001084554 0001777319 0001398659
2 OperatingLeaseAssets 0 0 2,473,000 198,634,900 270,603,000 0001084554 0001599407 0001398659
3 AssetsNoncurrent 0 0 3,830,068 337,924,700 537,247,000 0001084554 0001371489 0001398659
4 remainder_Assets -351,287,000 -114,875,857 43,094 65,107,150 345,116,000 0001083446 0001599407 0001398659
5 LiabilitiesCurrent 22,661 195,042 26,968,535 677,145,200 1,312,743,000 0001813603 0001437226 0001398659
6 LiabilitiesNoncurrent 0 0 10,259,573 628,257,000 1,765,393,000 0001084554 0001437226 0001398659
7 remainder_Liabilities -12,273,000 -5,941,450 0 23,100,650 33,187,000 0001289848 0001057379 0001643615
8 CostOfRevenue 0 0 30,937,020 1,494,335,350 2,590,252,000 0000851520 0001013706 0001398659
9 GeneralAndAdministrativeExpense 0 127,727 9,513,156 489,571,600 865,715,000 0001751143 0001777319 0001398659
10 LaborExpense 0 0 0 101,642,250 278,047,000 0000887936 0001320760 0000851520
11 remainder_Expenses -54,746,000 0 7,670,243 127,882,750 284,502,000 0001847590 0001622879 0001751143
12 RevenueFromContractWithCustomer 0 0 8,859,832 1,261,714,400 4,022,211,000 0000887936 0001777319 0001398659
13 RevenueFromReimbursement 0 0 0 17,458,379 31,419,000 0000887936 0001398659 0000851520
14 remainder_Revenues -31,419,000 0 0 396,244,850 2,776,222,000 0000851520 0001320760 0000887936
15 remainder_NetIncome -24,667,000 -17,609,500 -3,480 19,331,650 27,197,000 0001398659 0001751143 0001289848
16 remainder_ComprehensiveNetIncome -22,405,000 -6,935,424 0 1,689,050 3,779,000 0000887936 0001751143 0001289848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 285,109 1,371,028 123,242,429 2,537,790,250 4,975,269,000 0001439264 0001419275 0001398659
1 Liabilities 29,560 396,452 52,644,728 1,305,402,200 3,078,136,000 0001813603 0001847590 0001398659
2 Expenses 247,217 467,678 76,867,882 2,056,530,150 3,628,096,000 0001813603 0001622879 0001398659
3 Revenues 0 0 82,766,280 2,225,793,700 4,022,211,000 0001084554 0001622879 0001398659
4 StockholdersEquity -151,490,000 -2,821,336 35,460,415 1,232,388,050 1,897,133,000 0001751143 0001419275 0001398659
5 NetIncome -39,145,650 -28,241,830 -747,597 174,772,200 369,448,000 0001777319 0001502966 0001398659
6 ComprehensiveNetIncome -39,145,650 -28,241,830 -747,597 162,426,500 360,435,000 0001777319 0001502966 0001398659
7 BaseVar 1,635,184 3,441,265 241,203,868 5,020,513,233 9,559,173,140 0001230524 0001847590 0001398659
8 EconomicCapitalRatio -8.73 -3.72 0.946 2.07 2.12 0001813603 0001362004 0001057379

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 -1.47 -0.541 -0.147 2.27 4.57 0001439264 0001320760 0001084554
1 IntangibleAssets -4.24 -0.897 -0.0457 1.01 3.85 0001813603 0001790625 0001657045
2 OperatingLeaseAssets -1.14 -0.242 -0.0444 0.275 0.899 0001813603 0001289848 0001508348
3 AssetsNoncurrent -3.09 -0.672 -0.130 1.11 2.29 0001813603 0001398659 0001230524
4 remainder_Assets -1.42 -0.554 -0.0940 0.588 4.95 0001813603 0001289848 0001654672
5 LiabilitiesCurrent -2.12 -0.937 0.307 0.994 3.27 0001813603 0001362004 0001439264
6 LiabilitiesNoncurrent -1.62 -1.31 -0.0135 0.850 0.953 0001813603 0001632121 0001057379
7 remainder_Liabilities -0.808 -0.290 0.0511 0.204 0.332 0001230524 0001502966 0001013706
8 CostOfRevenue -1.70 -0.968 -0.244 0.596 1.86 0001437226 0001847590 0001813603
9 GeneralAndAdministrativeExpense -1.99 -0.650 0.151 0.617 1.10 0001439264 0001398659 0001813603
10 LaborExpense -0.765 -0.635 0.0796 0.149 0.231 0000851520 0001790625 0001813603
11 remainder_Expenses -1.73 -0.617 0.109 0.454 1.04 0001777319 0001289848 0001847590
12 RevenueFromContractWithCustomer -2.31 -1.43 0.00832 1.59 1.71 0001813603 0001622879 0001057379
13 RevenueFromReimbursement -0.0583 -0.0390 -0.0209 0.0484 0.380 0001813603 0001439264 0001599407
14 remainder_Revenues -0.755 -0.430 -0.258 1.55 3.63 0001813603 0001643615 0001437226
15 remainder_NetIncome -11.1 -0.244 0.157 0.356 0.414 0001813603 0001622879 0001013706
16 remainder_ComprehensiveNetIncome -0.0271 -0.0126 0.00196 0.00692 0.00945 0001622879 0001304161 0001289848
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -5.81 -2.14 -0.136 1.32 1.42 0001813603 0001362004 0001654672
1 Liabilities -2.90 -0.970 0.225 1.52 1.76 0001813603 0001643615 0001437226
2 Expenses -1.55 -1.08 -0.0721 0.584 3.72 0001777319 0001083446 0001813603
3 Revenues -3.12 -0.760 0.312 1.24 1.89 0001813603 0001398659 0001437226
4 StockholdersEquity -3.45 -2.21 0.0870 1.08 2.52 0001439264 0001289848 0001084554
5 NetIncome -10.5 -1.81 0.415 1.11 1.19 0001813603 0001304161 0001437226
6 ComprehensiveNetIncome -10.5 -1.81 0.417 1.10 1.20 0001813603 0001304161 0001437226
7 BaseVar nan nan nan nan nan 0000851520 0001419275 0000851520
8 EconomicCapitalRatio -9.03 -4.01 0.649 1.78 1.82 0001813603 0001362004 0001057379

2022

Logs

error 6 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
error 3 × Negative Expenses, ignoring company. pre-agg
warning 34 × The stock price does not exist industry.us_generic
warning 28 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 14 × Ignoring company because Expenses is zero pre-agg
warning 10 × Ignoring company because Assets is zero pre-agg
warning 9 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 5 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 4 × Missing logo subcommand.report
warning 4 × Ignoring company because ECR is too negative pre-agg
warning 2 × Similarly named company. Duplicate? None
warning 2 × No stock price available subcommand.plot
warning 2 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -4.538343665768269}
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 10,732 53,182,531 1,618,158,000 2,445,676,000 0001654672 0001437226 0001443646
1 IntangibleAssets 0 0 29,450,371 1,513,225,400 2,668,613,000 0001230524 0001599407 0001443646
2 OperatingLeaseAssets 0 0 3,888,659 200,525,200 227,231,000 0000723533 0001437226 0001443646
3 AssetsNoncurrent 0 0 2,585,256 502,442,000 651,727,000 0001508348 0001371489 0001443646
4 remainder_Assets -372,980,000 -180,254,367 0 66,722,800 352,153,000 0001083446 0001362004 0001398659
5 LiabilitiesCurrent 34,106 94,736 24,203,236 1,002,117,800 1,773,556,000 0001813603 0001320760 0001443646
6 LiabilitiesNoncurrent 0 0 7,755,043 1,105,404,200 3,126,122,000 0000723533 0001877939 0001443646
7 remainder_Liabilities -32,146,000 -3,438,400 0 38,683,000 79,176,000 0001289848 0000851520 0001443646
8 CostOfRevenue 0 0 24,654,865 2,373,495,800 3,899,622,000 0000723533 0001877939 0001443646
9 GeneralAndAdministrativeExpense 13,001 22,547 23,126,585 759,996,000 1,158,987,000 0001620749 0001777319 0001443646
10 LaborExpense 0 0 0 116,574,800 264,235,000 0000887936 0000887936 0000851520
11 remainder_Expenses -91,176,000 -306,693 13,796,802 119,978,000 2,849,728,000 0001847590 0001057379 0001443646
12 RevenueFromContractWithCustomer 0 0 30,687,920 3,565,813,600 8,363,700,000 0000723533 0001320760 0001443646
13 RevenueFromReimbursement 0 0 0 10,602,400 49,473,000 0000723533 0001443646 0000851520
14 remainder_Revenues -49,473,000 0 0 44,886,035 242,238,000 0000851520 0001230524 0001437226
15 remainder_NetIncome -90,110,000 -20,502,200 -635,774 7,812,600 11,214,000 0001398659 0001777319 0001443646
16 remainder_ComprehensiveNetIncome -178,772,000 -23,834,485 0 1,928,200 38,519,000 0001398659 0001502966 0001443646
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,358 248,425 104,510,838 3,780,369,800 6,025,575,000 0001654672 0001777319 0001443646
1 Liabilities 34,106 104,898 42,658,264 2,040,874,000 4,978,854,000 0001813603 0001599407 0001443646
2 Expenses 75,710 326,095 79,948,763 3,243,422,200 7,908,337,000 0001620749 0001777319 0001443646
3 Revenues 0 0 49,282,564 3,565,813,600 8,363,700,000 0001230524 0001599407 0001443646
4 StockholdersEquity -4,161,312 -2,163,196 58,336,135 1,300,721,000 1,826,158,000 0001632121 0001057379 0001398659
5 NetIncome -49,235,698 -32,601,473 -172,923 282,670,000 466,577,000 0001419275 0001508348 0001443646
6 ComprehensiveNetIncome -49,235,698 -32,193,374 -172,923 179,832,000 505,096,000 0001419275 0001508348 0001443646
7 BaseVar 120,890 1,184,484 182,187,277 7,914,042,444 17,253,888,900 0001620749 0001419275 0001443646
8 EconomicCapitalRatio -19.6 -4.54 0.716 2.25 2.49 0001654672 0001508348 0001640265

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 -10.5 -1.57 -0.142 0.764 3.50 0001654672 0001437226 0001813603
1 IntangibleAssets -9.44 -1.95 -0.0204 1.18 2.88 0001654672 0001013706 0001657045
2 OperatingLeaseAssets -2.68 -0.473 -0.0497 0.115 0.830 0001654672 0001790625 0001508348
3 AssetsNoncurrent -6.67 -0.944 -0.139 2.26 7.58 0001654672 0001777319 0001230524
4 remainder_Assets -0.740 -0.465 0.0526 0.710 1.20 0001622879 0001599407 0001654672
5 LiabilitiesCurrent -1.15 -0.563 0.336 1.28 2.14 0001657045 0001622879 0001654672
6 LiabilitiesNoncurrent -5.08 -1.12 -0.00220 0.672 1.21 0001654672 0001502966 0001437226
7 remainder_Liabilities -1.12 -0.643 0.0266 0.137 0.219 0001599407 0001657045 0001437226
8 CostOfRevenue -2.18 -1.08 -0.225 1.22 2.57 0001437226 0001643615 0001654672
9 GeneralAndAdministrativeExpense -5.87 -1.20 0.202 0.673 2.00 0001230524 0001790625 0001654672
10 LaborExpense -2.08 -0.641 0.155 0.320 0.532 0000723533 0001398659 0001654672
11 remainder_Expenses -1.19 -0.618 0.0762 0.411 0.910 0001599407 0001643615 0001847590
12 RevenueFromContractWithCustomer -3.26 -1.96 0.197 1.32 1.86 0001654672 0001622879 0001644378
13 RevenueFromReimbursement -0.0223 -0.0134 -0.00674 0.0120 0.161 0001654672 0001599407 0000851520
14 remainder_Revenues -1.14 -0.530 -0.308 2.09 4.52 0001654672 0001320760 0001437226
15 remainder_NetIncome -14.4 -2.09 0.257 0.498 0.669 0001654672 0001643615 0001437226
16 remainder_ComprehensiveNetIncome -0.0638 -0.0352 0.00645 0.0243 0.0386 0001398659 0001599407 0000723533
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -15.3 -2.50 -0.000606 0.908 1.22 0001654672 0001847590 0001508348
1 Liabilities -4.66 -0.823 0.119 1.38 2.36 0001654672 0001620749 0001437226
2 Expenses -4.02 -2.09 0.0431 0.986 4.90 0001230524 0001599407 0001654672
3 Revenues -4.42 -2.07 0.266 1.14 2.31 0001654672 0001599407 0001437226
4 StockholdersEquity -5.32 -2.90 0.227 1.57 2.14 0001654672 0001362004 0001640265
5 NetIncome -14.0 -5.54 0.524 1.36 1.84 0001654672 0001790625 0001437226
6 ComprehensiveNetIncome -13.9 -5.53 0.527 1.35 1.84 0001654672 0001790625 0001437226
7 BaseVar nan nan nan nan nan 0000723533 0001443646 0000723533
8 EconomicCapitalRatio -19.0 -3.94 1.31 2.84 3.08 0001654672 0001508348 0001640265

2023

Logs

error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 4 × The stock price does not exist industry.us_generic
warning 4 × Missing logo subcommand.report
warning 2 × Similarly named company. Duplicate? None
warning 2 × Large missing amount for aggregate "Assets" added to remainder. industry.us_generic
warning 1 × Too many companies have an ECR < -100% check_abs_values
{'quantile_095_val': -3.5175217293806273}
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 1 × No stock price available subcommand.plot
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
warning 1 × Ignoring company because Expenses is zero pre-agg
warning 1 × Ignoring company because ECR is too negative pre-agg
warning 1 × Ignoring company because Assets is zero pre-agg

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 3.00 146,969 20,416,098 1,807,495,000 2,288,058,000 0001230524 0001013706 0001443646
1 IntangibleAssets 0 0 11,182,931 1,615,821,000 3,024,014,000 0001230524 0001599407 0001443646
2 OperatingLeaseAssets 0 0 3,940,858 187,390,250 208,910,000 0000723533 0001320760 0000887936
3 AssetsNoncurrent 0 0 1,672,959 475,715,000 489,763,000 0001084554 0001599407 0001398659
4 remainder_Assets -387,875,000 -209,947,914 77,252 394,955,750 573,780,000 0001083446 0001599407 0001443646
5 LiabilitiesCurrent 16,214 155,778 19,758,910 1,255,664,750 1,897,054,000 0001813603 0001437226 0001443646
6 LiabilitiesNoncurrent 0 0 4,322,281 1,027,431,000 3,108,973,000 0000723533 0001013706 0001443646
7 remainder_Liabilities -28,160,000 -3,357,750 0 26,268,623 552,623,000 0001289848 0001371489 0001443646
8 CostOfRevenue 0 0 41,785,602 2,768,221,250 4,304,810,000 0001013706 0001320760 0001443646
9 GeneralAndAdministrativeExpense 0 127,479 22,243,831 872,622,250 1,532,912,000 0001632121 0001777319 0001443646
10 LaborExpense 0 0 0 101,941,588 150,845,000 0000887936 0001289848 0001644378
11 remainder_Expenses -109,472,000 -33,748,224 1,198,075 93,386,000 3,190,925,000 0001847590 0001084554 0001443646
12 RevenueFromContractWithCustomer 0 0 0 4,229,976,500 9,258,911,000 0000723533 0001877939 0001443646
13 RevenueFromReimbursement 0 0 0 0 36,695,000 0000723533 0001419275 0001289848
14 remainder_Revenues 0 0 0 67,978,614 201,098,000 0000887936 0001013706 0001437226
15 remainder_NetIncome -41,453,000 -36,361,750 -306,596 20,234,000 40,951,000 0001289848 0001632121 0001443646
16 remainder_ComprehensiveNetIncome -89,000 -25,562 0 18,636,750 26,262,000 0001437226 0001877939 0000887936
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 194,338 287,716 40,522,341 4,435,754,250 6,550,652,000 0001813603 0001013706 0001443646
1 Liabilities 16,214 299,991 22,921,330 2,254,105,250 5,558,650,000 0001813603 0001437226 0001443646
2 Expenses 74,029 190,990 69,602,271 3,665,075,000 9,028,647,000 0001230524 0001419275 0001443646
3 Revenues 0 0 55,735,528 4,229,976,500 9,258,911,000 0001230524 0001777319 0001443646
4 StockholdersEquity -20,040,689 -8,780,144 19,833,604 1,734,065,500 2,248,392,000 0001599407 0001419275 0001398659
5 NetIncome -80,231,083 -48,463,086 -440,691 273,972,750 631,255,000 0001777319 0001632121 0001398659
6 ComprehensiveNetIncome -79,973,153 -48,430,086 -440,691 299,000,250 641,830,000 0001777319 0001632121 0001398659
7 BaseVar 465,568 766,452 136,749,777 9,056,175,310 19,266,530,760 0001813603 0001599407 0001443646
8 EconomicCapitalRatio -4.15 -3.52 0.598 2.31 2.32 0001813603 0001508348 0001304161

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 -1.35 -0.777 -0.199 2.52 3.39 0001777319 0001083446 0001084554
1 IntangibleAssets -1.52 -1.06 0.00477 1.02 2.35 0001813603 0001419275 0001657045
2 OperatingLeaseAssets -0.493 -0.365 -0.0680 0.0680 0.830 0001813603 0001437226 0001508348
3 AssetsNoncurrent -1.20 -0.886 -0.179 2.73 3.55 0001439264 0001289848 0001630212
4 remainder_Assets -0.845 -0.479 -0.00935 0.287 0.984 0001622879 0001230524 0001508348
5 LiabilitiesCurrent -1.12 -0.509 0.411 1.53 1.73 0001657045 0001847590 0001437226
6 LiabilitiesNoncurrent -1.10 -0.889 0.0103 0.768 0.939 0001230524 0001877939 0001437226
7 remainder_Liabilities -0.583 -0.214 0.0279 0.133 0.145 0001599407 0001230524 0001437226
8 CostOfRevenue -1.82 -1.41 -0.105 0.508 1.21 0001437226 0001847590 0001813603
9 GeneralAndAdministrativeExpense -4.46 -1.95 0.275 0.758 1.14 0001813603 0001777319 0001644378
10 LaborExpense -0.842 -0.461 0.148 0.232 0.294 0000723533 0001289848 0001437226
11 remainder_Expenses -1.70 -0.775 0.0527 0.492 1.45 0001777319 0001230524 0001599407
12 RevenueFromContractWithCustomer -1.64 -1.30 -0.343 1.93 2.37 0001437226 0001632121 0001644378
13 RevenueFromReimbursement -0.00382 -0.00313 -0.00195 -0.000779 0.0510 0001437226 0001398659 0001289848
14 remainder_Revenues -0.621 -0.607 -0.243 2.04 3.71 0001813603 0000723533 0001437226
15 remainder_NetIncome -0.994 -0.659 0.0703 0.275 0.355 0001813603 0001013706 0001230524
16 remainder_ComprehensiveNetIncome -0.0109 -0.00468 -0.000759 0.00725 0.0148 0000723533 0001084554 0000887936
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -2.55 -1.61 -0.152 1.11 1.36 0001439264 0000887936 0001084554
1 Liabilities -0.810 -0.716 0.275 1.90 2.21 0001508348 0001777319 0001437226
2 Expenses -2.83 -1.68 0.000496 0.555 0.647 0001813603 0000887936 0001632121
3 Revenues -1.93 -0.758 0.241 1.68 2.06 0001813603 0001847590 0001437226
4 StockholdersEquity -3.16 -1.87 0.158 1.58 2.72 0001632121 0001622879 0001084554
5 NetIncome -5.75 -1.62 0.319 1.18 1.64 0001813603 0001230524 0001644378
6 ComprehensiveNetIncome -5.76 -1.62 0.318 1.17 1.64 0001813603 0001230524 0001644378
7 BaseVar nan nan nan nan nan 0000723533 0001419275 0000723533
8 EconomicCapitalRatio -4.18 -3.54 0.576 2.29 2.30 0001813603 0001508348 0001304161

Estimates

Parameter Value Min Max
PresentValueFactor 1.44 1.0 15.0
BalanceFactor 1.59 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 0.0
LLPO_stddev 1.49 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            
0000723533 Longwen Group Corp Longwen LWLW 2011 nan 0.0010 nan 129,114,138.0 nan nan
2014 2.6200 0.0010 0.0000 nan nan nan
2022 0.5400 1.0000 0.5400 69,529,707.0 37,546,041.78 138.9650
2023 0.1100 1.0000 0.1100 79,825,094.0 8,780,760.34 9.9562
0000851520 Exponent INC Exponen EXPO 2011 11.8000 4.0000 47.2000 13,243,065.0 625,072,668.00 3.5635
2012 13.3700 4.0000 53.4800 13,223,806.0 707,209,144.88 3.4138
2014 20.6300 4.0000 82.5200 12,866,600.0 1,061,751,832.00 4.6854
2015 25.2800 2.0000 50.5600 25,746,928.0 1,301,764,679.68 5.3542
2016 30.4300 2.0000 60.8600 25,592,534.0 1,557,561,619.24 5.8311
2017 35.8800 2.0000 71.7600 25,810,749.0 1,852,179,348.24 6.2767
2018 49.0900 1.0000 49.0900 52,012,151.0 2,553,276,492.59 8.1849
2021 116.8200 1.0000 116.8200 52,111,508.0 6,087,666,364.56 12.8106
2022 100.1600 1.0000 100.1600 50,638,229.0 5,071,925,016.64 11.8979
0000887936 FTI Consulting INC FTI Con FCN 2021 152.0600 1.0000 152.0600 34,288,467.0 5,213,904,292.02 2.2578
2022 156.3100 1.0000 156.3100 34,423,110.0 5,380,676,324.10 2.2414
2023 199.5400 1.0000 199.5400 35,509,721.0 7,085,609,728.34 3.0343
0001013706 Wilhelmina International Inc Wilhelm WHLM 2011 4.0000 0.0500 0.2000 129,440,752.0 25,888,150.40 0.8741
2012 2.4000 0.0500 0.1200 121,440,752.0 14,572,890.24 0.5861
2013 4.0000 0.0500 0.2000 117,813,925.0 23,562,785.00 0.8957
2014 5.4200 1.0000 5.4200 5,870,115.0 31,816,023.30 1.0641
2015 6.7500 1.0000 6.7500 5,789,528.0 39,079,314.00 1.3079
2016 8.8000 1.0000 8.8000 5,381,668.0 47,358,678.40 1.2744
2017 6.4700 1.0000 6.4700 5,381,668.0 34,819,391.96 1.1641
2018 5.8300 1.0000 5.8300 5,265,768.0 30,699,427.44 1.0161
2019 4.2600 1.0000 4.2600 5,170,121.0 22,024,715.46 0.8326
2020 4.2100 1.0000 4.2100 5,157,344.0 21,712,418.24 0.9697
2021 5.0600 1.0000 5.0600 5,157,344.0 26,096,160.64 0.9695
2022 3.6300 1.0000 3.6300 5,157,344.0 18,721,158.72 0.6264
2023 4.5400 1.0000 4.5400 5,157,344.0 23,414,341.76 0.8014
0001019737 Navigant Consulting INC Navigan nan 2010 nan nan nan nan nan nan
2011 nan nan nan 52,284,486.0 nan nan
2012 nan nan nan 52,029,167.0 nan nan
2013 nan nan nan 49,472,038.0 nan nan
2014 nan nan nan 48,494,296.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
0001057379 Hackett Group INC Hackett HCKT 2011 3.7800 1.0000 3.7800 40,396,171.0 152,697,526.38 1.4926
2012 4.2600 1.0000 4.2600 30,482,872.0 129,857,034.72 1.2187
2013 6.1800 1.0000 6.1800 30,687,903.0 189,651,240.54 1.8298
2015 16.2400 1.0000 16.2400 29,382,893.0 477,178,182.32 4.5588
2016 17.7300 1.0000 17.7300 28,553,558.0 506,254,583.34 4.3593
2017 15.6200 1.0000 15.6200 28,656,338.0 447,611,999.56 3.4026
2018 16.0600 1.0000 16.0600 29,518,236.0 474,062,870.16 3.9839
2019 15.8900 1.0000 15.8900 29,896,607.0 475,057,085.23 3.8026
2021 20.6000 1.0000 20.6000 29,792,171.0 613,718,722.60 4.5244
2022 20.1000 1.0000 20.1000 31,703,102.0 637,232,350.20 4.0886
0001066104 CEB Inc. CEB Inc nan 2010 nan nan nan nan nan nan
2011 nan nan nan 33,294,413.0 nan nan
2012 nan nan nan 33,317,950.0 nan nan
2013 nan nan nan 33,609,569.0 nan nan
2014 nan nan nan 33,640,195.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001083446 Astrana Health Inc Astrana ASTH 2011 1.1000 0.1000 0.1100 29,335,774.0 3,226,935.14 2.4828
2012 9.9000 0.1000 0.9900 34,843,441.0 34,495,006.59 21.9063
2013 6.5000 0.1000 0.6500 37,977,607.0 24,685,444.55 7.2206
2014 4.2000 0.1000 0.4200 48,634,549.0 20,426,510.58 1.9841
2015 5.2500 1.0000 5.2500 4,863,389.0 25,532,792.25 1.6483
2016 5.9700 1.0000 5.9700 5,956,877.0 35,562,555.69 2.3277
2017 22.9300 1.0000 22.9300 6,033,495.0 138,348,040.35 0.4290
2018 17.9200 1.0000 17.9200 34,084,641.0 610,796,766.72 1.9730
2019 18.6900 1.0000 18.6900 34,892,506.0 652,140,937.14 1.1896
2020 17.6300 1.0000 17.6300 54,265,602.0 956,702,563.26 1.6086
2021 71.1100 1.0000 71.1100 55,549,053.0 3,950,093,158.83 6.6459
2022 29.6500 1.0000 29.6500 56,723,447.0 1,681,850,203.55 2.4753
2023 37.6800 1.0000 37.6800 58,283,589.0 2,196,125,633.52 3.0168
0001084554 Lightbridge Corp Lightbr LTBR 2011 126.3000 0.0170 2.1500 12,424,778.0 26,713,272.70 4.3736
2012 84.6000 0.0170 1.4400 12,524,716.0 18,035,591.04 5.5180
2013 90.6000 0.0170 1.5400 15,057,243.0 23,188,154.22 7.5612
2014 105.9000 0.0170 1.8000 18,082,874.0 32,549,173.20 9.7078
2015 59.4000 0.0170 1.0100 18,623,387.0 18,809,620.87 6.3599
2016 13.5000 0.0830 1.1200 5,265,123.0 5,896,937.76 1.4662
2017 12.5400 0.0830 1.0400 11,497,153.0 11,957,039.12 2.9557
2018 7.0200 0.0830 0.5800 31,184,228.0 18,086,852.24 1.3549
2020 3.5900 1.0000 3.5900 5,631,561.0 20,217,303.99 1.5311
2021 7.2400 1.0000 7.2400 7,628,542.0 55,230,644.08 4.3979
2023 3.3600 1.0000 3.3600 12,962,771.0 43,554,910.56 2.9150
0001094238 Harris Interactive INC Harris nan 2011 nan nan nan 55,652,399.0 nan nan
2012 nan nan nan 57,392,195.0 nan nan
0001094814 Cartesian Inc Cartesi nan 2011 nan nan nan 7,093,872.0 nan nan
2013 nan nan nan 8,051,382.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
0001096132 Petrone Worldwide INC Petrone nan 2014 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001098482 Innovaro Inc Innovar INNI 2011 0.8800 1.0000 0.8800 15,021,274.0 13,218,721.12 0.8603
2012 0.2400 1.0000 0.2400 15,064,544.0 3,615,490.56 0.4812
0001100778 Rokk3R Inc Rokk3R nan 2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
0001104265 Grow Solutions Holdings INC Grow So nan 2015 nan nan nan 54,596,612.0 nan nan
2016 nan nan nan 46,716,612.0 nan nan
0001179090 Bonds com Group Inc Bonds c nan 2011 nan nan nan 104,354,190.0 nan nan
2012 nan nan nan 104,354,190.0 nan nan
2013 nan nan nan nan nan nan
0001228386 Transatlantic Capital INC Transat nan 2012 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001230524 Leopard Energy Inc Leopard LEEN 2012 10748.8800 1.0000 10748.8800 491,907,316.0 5,287,452,710,806.08 10247495.8911
2013 8032.5800 1.0000 8032.5800 9,838,721.0 79,030,313,530.18 263525.8647
2019 60.9000 0.0050 0.3000 42,603,032.0 12,780,909.60 16.5531
2020 408.2400 0.0010 0.4100 170,912,128.0 70,073,972.48 76.6229
2021 12.4300 0.0010 0.0100 321,510,839.0 3,215,108.39 3.2259
2022 0.0700 1.0000 0.0700 1,059,663.0 74,176.41 0.2415
2023 0.2700 1.0000 0.2700 1,272,917.0 343,687.59 0.9581
0001272550 Root9B Holdings Inc Root9B nan 2011 nan nan nan 8,106,325.0 nan nan
2012 nan nan nan 15,782,071.0 nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan 32,761,465.0 nan nan
2015 nan nan nan nan nan nan
0001286345 Hpil Holding Hpil Ho 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
0001289848 Huron Consulting Group Inc Huron C HURN 2012 33.4900 1.0000 33.4900 22,952,487.0 768,678,789.63 1.3598
2013 62.6300 1.0000 62.6300 23,243,551.0 1,455,743,599.13 2.3464
2014 69.1200 1.0000 69.1200 22,868,714.0 1,580,685,511.68 1.8476
2020 57.5000 1.0000 57.5000 22,871,243.0 1,315,096,472.50 1.6828
2021 49.8800 1.0000 49.8800 21,917,598.0 1,093,249,788.24 1.3117
2022 72.5600 1.0000 72.5600 19,933,479.0 1,446,373,236.24 1.5669
2023 100.2200 1.0000 100.2200 18,747,865.0 1,878,911,030.30 1.8869
0001304161 Pharma Bio Serv Inc Pharma PBSV 2011 0.7000 1.0000 0.7000 20,758,695.0 14,531,086.50 2.1579
2012 0.7100 1.0000 0.7100 20,758,695.0 14,738,673.45 1.5853
2013 2.0200 1.0000 2.0200 22,702,186.0 45,858,415.72 3.7507
2014 1.2500 1.0000 1.2500 23,047,462.0 28,809,327.50 2.2237
2015 0.9500 1.0000 0.9500 23,062,250.0 21,909,137.50 1.6652
2016 0.8700 1.0000 0.8700 23,009,316.0 20,018,104.92 1.5290
2017 0.5200 1.0000 0.5200 23,101,931.0 12,013,004.12 1.0031
2020 1.4100 1.0000 1.4100 23,001,627.0 32,432,294.07 1.7474
2021 0.9700 1.0000 0.9700 23,029,215.0 22,338,338.55 1.5524
2022 0.7300 1.0000 0.7300 22,944,286.0 16,749,328.78 1.3538
2023 1.0000 1.0000 1.0000 22,963,451.0 22,963,451.00 1.9397
0001320760 TSS Inc. TSS Inc TSSI 2011 0.8000 1.0000 0.8000 14,626,162.0 11,700,929.60 0.6894
2012 0.4500 1.0000 0.4500 14,729,520.0 6,628,284.00 0.4770
2013 0.4500 1.0000 0.4500 14,572,002.0 6,557,400.90 0.4258
2014 0.4800 1.0000 0.4800 15,199,668.0 7,295,840.64 0.7338
2015 0.1300 1.0000 0.1300 15,632,004.0 2,032,160.52 0.1525
2016 0.0500 1.0000 0.0500 15,645,824.0 782,291.20 0.0842
2018 0.8400 1.0000 0.8400 16,304,107.0 13,695,449.88 1.7403
2019 1.4700 1.0000 1.4700 17,559,057.0 25,811,813.79 1.6000
2020 0.6000 1.0000 0.6000 18,945,135.0 11,367,081.00 0.5117
2021 0.4800 1.0000 0.4800 18,596,793.0 8,926,460.64 0.4961
2022 0.5600 1.0000 0.5600 21,343,306.0 11,952,251.36 0.3992
2023 0.3100 1.0000 0.3100 21,606,626.0 6,698,054.06 0.2766
0001362004 ICF International Inc ICF Int ICFI 2011 25.5300 1.0000 25.5300 19,766,104.0 504,628,635.12 1.0131
2012 23.4300 1.0000 23.4300 19,529,536.0 457,577,028.48 0.9236
2013 34.4300 1.0000 34.4300 19,891,239.0 684,855,358.77 1.4764
2014 41.5000 1.0000 41.5000 19,398,743.0 805,047,834.50 0.9361
2015 35.3300 1.0000 35.3300 19,223,827.0 679,177,807.91 0.8267
2016 54.9500 1.0000 54.9500 18,957,609.0 1,041,720,614.55 1.2980
2017 52.6500 1.0000 52.6500 18,642,406.0 981,522,675.90 1.2235
2018 64.2100 1.0000 64.2100 18,847,336.0 1,210,187,444.56 1.3695
2019 92.0300 1.0000 92.0300 18,811,087.0 1,731,184,336.61 1.6647
2020 74.7700 1.0000 74.7700 18,863,066.0 1,410,391,444.82 1.0902
2021 101.8300 1.0000 101.8300 18,875,187.0 1,922,060,292.21 1.3275
2022 99.0700 1.0000 99.0700 18,843,895.0 1,866,864,677.65 1.1207
0001366312 Juhl Energy Inc Juhl En nan 2011 nan nan nan 22,059,803.0 nan nan
2013 nan nan nan 23,924,789.0 nan nan
0001371489 Information Services Group Inc Informa III 2012 1.1100 1.0000 1.1100 36,163,424.0 40,141,400.64 0.3436
2013 4.0700 1.0000 4.0700 37,088,639.0 150,950,760.73 1.2765
2014 4.1600 1.0000 4.1600 36,706,834.0 152,700,429.44 1.3477
2015 3.4000 1.0000 3.4000 37,182,112.0 126,419,180.80 1.1711
2016 3.7500 1.0000 3.7500 35,788,875.0 134,208,281.25 0.6526
2017 4.2700 1.0000 4.2700 43,400,494.0 185,320,109.38 0.9603
2018 4.2100 1.0000 4.2100 45,186,419.0 190,234,823.99 1.0856
2019 2.3700 1.0000 2.3700 47,535,463.0 112,659,047.31 0.6478
2020 3.1300 1.0000 3.1300 48,019,773.0 150,301,889.49 0.7925
2021 7.6300 1.0000 7.6300 48,992,958.0 373,816,269.54 1.9927
2022 4.5000 1.0000 4.5000 47,999,741.0 215,998,834.50 1.1203
2023 4.7500 1.0000 4.7500 48,873,566.0 232,149,438.50 1.1826
0001382219 6D Global Technologies Inc 6D Glob nan 2011 nan nan nan 24,982,222.0 nan nan
2013 nan nan nan 24,982,822.0 nan nan
2014 nan nan nan 77,067,083.0 nan nan
2015 nan nan nan nan nan nan
0001388982 Chuma Holdings INC Chuma H nan 2011 nan nan nan nan nan nan
2012 nan nan nan 30,155,789.0 nan nan
2013 nan nan nan nan nan nan
0001398659 Genpact LTD Genpact G 2010 15.2200 1.0000 15.2200 nan nan nan
2011 14.7700 1.0000 14.7700 222,021,263.0 3,279,254,054.51 1.9455
2014 19.0600 1.0000 19.0600 216,589,934.0 4,128,204,142.04 1.9658
2015 24.7300 1.0000 24.7300 212,690,181.0 5,259,828,176.13 2.4564
2016 24.0900 1.0000 24.0900 200,756,607.0 4,836,226,662.63 2.1583
2017 32.2800 1.0000 32.2800 193,042,398.0 6,231,408,607.44 2.2786
2018 26.8600 1.0000 26.8600 190,088,587.0 5,105,779,446.82 1.8059
2019 42.2600 1.0000 42.2600 189,956,225.0 8,027,550,068.50 2.2242
2020 41.7500 1.0000 41.7500 189,347,684.0 7,905,265,807.00 1.9983
2021 52.7900 1.0000 52.7900 188,060,328.0 9,927,704,715.12 2.4652
2022 45.7900 1.0000 45.7900 183,258,135.0 8,391,390,001.65 2.2829
2023 34.6100 1.0000 34.6100 181,412,399.0 6,278,683,129.39 1.7057
0001400683 Stwc Holdings Inc Stwc Ho nan 2011 nan nan nan 2,345,000.0 nan nan
2012 nan nan nan 2,345,000.0 nan nan
2018 nan nan nan 33,350,089.0 nan nan
0001419275 Ryvyl Inc Ryvyl I RVYL 2011 0.6000 0.0170 0.0100 8,704,669.0 87,046.69 0.0822
2013 1.8000 0.0170 0.0300 14,445,363.0 433,360.89 0.6120
2014 3.0000 0.0170 0.0500 14,445,363.0 722,268.15 1.3189
2015 1.8000 0.0170 0.0300 14,445,363.0 433,360.89 0.8040
2016 1.2000 0.0170 0.0200 14,445,363.0 288,907.26 0.6854
2019 6.0000 0.0170 0.1000 166,390,363.0 16,639,036.30 1.1270
2020 52.8000 0.0170 0.9000 181,050,238.0 162,945,214.20 13.4639
2021 45.7000 0.1000 4.5700 43,179,241.0 197,329,131.37 1.7952
2022 4.9000 0.1000 0.4900 49,647,531.0 24,327,290.19 0.2467
2023 4.5800 1.0000 4.5800 5,386,141.0 24,668,525.78 0.2108
0001437226 Mastech Digital Inc Mastech MHH 2011 1.5000 2.5000 3.7500 3,633,043.0 13,623,911.25 1.0244
2012 2.5000 2.5000 6.2500 3,190,664.0 19,941,650.00 1.5355
2013 7.3800 2.0000 14.7600 3,359,546.0 49,586,898.96 4.0219
2014 5.6000 2.0000 11.2000 4,306,798.0 48,236,137.60 3.5426
2015 3.6700 2.0000 7.3400 4,353,189.0 31,952,407.26 1.0465
2016 3.4500 2.0000 6.9000 4,470,965.0 30,849,658.50 1.0299
2017 4.8500 2.0000 9.7000 5,454,952.0 52,913,034.40 0.6217
2018 6.3000 1.0000 6.3000 10,983,736.0 69,197,536.80 0.9172
2019 10.9400 1.0000 10.9400 11,033,165.0 120,702,825.10 1.7905
2020 16.6300 1.0000 16.6300 11,379,749.0 189,245,225.87 2.6182
2021 16.7000 1.0000 16.7000 11,438,013.0 191,014,817.10 2.4973
2022 12.4700 1.0000 12.4700 11,617,709.0 144,872,831.23 2.1982
2023 8.2400 1.0000 8.2400 11,599,138.0 95,576,897.12 1.4808
0001438673 Evergreen Agra Global Investments Inc Evergre nan 2011 nan nan nan 2,159,999.0 nan nan
2012 nan nan nan 42,279,999.0 nan nan
2016 nan nan nan nan nan nan
0001439264 Marvion Inc Marvion MVNC 2011 27.0000 1.0000 27.0000 nan nan nan
2012 55.2000 1.0000 55.2000 331,656,125.0 18,307,418,100.00 14352.6254
2021 18.4500 1.0000 18.4500 nan nan nan
2022 5.0200 1.0000 5.0200 1,942,681,876.0 9,752,263,017.52 1676.0638
2023 2.4000 1.0000 2.4000 143,146,265,860.0 343,551,038,064.00 23612.7112
0001443646 Booz Allen Hamilton Holding Corp Booz Al BAH 2011 17.3500 1.0000 17.3500 128,417,006.0 2,228,035,054.10 0.8666
2012 14.0800 1.0000 14.0800 132,045,531.0 1,859,201,076.48 0.6830
2013 18.5700 1.0000 18.5700 142,260,354.0 2,641,774,773.78 0.8624
2014 26.7500 1.0000 26.7500 148,805,550.0 3,980,548,462.50 1.3945
2015 30.8400 1.0000 30.8400 148,448,758.0 4,578,159,696.72 1.6521
2022 104.0800 1.0000 104.0800 132,226,183.0 13,762,101,126.64 2.5012
2023 126.3800 1.0000 126.3800 130,381,202.0 16,477,576,308.76 2.7216
0001470215 Towers Watson Co Towers nan 2011 nan nan nan 53,115,332.0 nan nan
2012 nan nan nan 58,787,228.0 nan nan
2013 nan nan nan 65,562,296.0 nan nan
2014 nan nan nan 69,936,264.0 nan nan
0001498291 Daniels Corporate Advisory Company Inc Daniels DCAC 2019 0.0100 1.0000 0.0100 25,546,452.0 255,464.52 0.1105
2020 0.0000 1.0000 0.0000 34,754,735.0 0.00 0.0415
0001501489 Af Ocean Investment Management Co Af Ocea nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
0001502966 Hypha Labs Inc Hypha L FUNI 2011 nan 0.1000 nan 5,426,750.0 nan nan
2012 7.0000 0.1000 0.7000 5,526,400.0 3,868,480.00 7.9890
2013 10.0000 0.1000 1.0000 5,536,400.0 5,536,400.00 10.4698
2014 0.3800 0.1000 0.0400 81,997,290.0 3,279,891.60 1.0619
2017 0.2600 1.0000 0.2600 37,285,676.0 9,694,275.76 11.2336
2018 0.1300 1.0000 0.1300 43,257,277.0 5,623,446.01 6.1909
2019 0.1000 1.0000 0.1000 48,532,666.0 4,853,266.60 4.2461
2020 0.0200 1.0000 0.0200 57,612,672.0 1,152,253.44 0.5495
2021 0.0300 1.0000 0.0300 72,730,153.0 2,181,904.59 1.0181
2022 0.0100 1.0000 0.0100 75,146,820.0 751,468.20 0.1993
0001508348 Americann Inc America ACAN 2016 1.6500 1.0000 1.6500 19,131,000.0 31,566,150.00 7.7684
2017 3.0300 1.0000 3.0300 19,366,000.0 58,678,980.00 11.9232
2018 2.0100 1.0000 2.0100 21,963,017.0 44,145,664.17 7.3243
2020 0.9300 1.0000 0.9300 23,696,310.0 22,037,568.30 1.8473
2021 0.4400 1.0000 0.4400 24,196,310.0 10,646,376.40 0.8747
2022 0.1100 1.0000 0.1100 24,391,961.0 2,683,115.71 0.2043
2023 0.0800 1.0000 0.0800 24,391,961.0 1,951,356.88 0.1636
0001533106 Argentum 47 INC Argentu nan 2012 nan nan nan 29,325,700.0 nan nan
2013 nan nan nan 30,784,202.0 nan nan
2014 nan nan nan 33,751,752.0 nan nan
2015 nan nan nan 772,523,183.0 nan nan
2016 nan nan nan 819,499,228.0 nan nan
2017 nan nan nan 473,090,573.0 nan nan
2018 nan nan nan 525,534,409.0 nan nan
2019 nan nan nan 590,989,409.0 nan nan
0001537511 Progressive Green Solutions INC Progres nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
0001560449 Phmc Inc Phmc In nan 2016 nan nan nan nan nan nan
0001567503 Turnkey Capital Inc Turnkey nan 2013 nan nan nan 3,880,000.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
0001574910 Renavotio INC Renavot nan 2015 nan nan nan 10,360,000.0 nan nan
2017 nan nan nan 10,360,000.0 nan nan
2018 nan nan nan 75,000,000.0 nan nan
2020 nan nan nan 107,688,241.0 nan nan
0001590565 Asia Equity Exchange Group INC Asia Eq nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
0001592782 Nukkleus Inc Nukkleu nan 2016 nan nan nan 254,641,100.0 nan nan
2017 nan nan nan 230,485,100.0 nan nan
2018 nan nan nan 230,485,100.0 nan nan
2019 nan nan nan 230,485,100.0 nan nan
0001599407 1847 Holdings LLC 1847 Ho EFSH 2014 nan 1.0000 nan 77,887,500.0 nan nan
2015 nan 1.0000 nan 77,887,500.0 nan nan
2016 nan 1.0000 nan 77,887,500.0 nan nan
2017 nan 1.0000 nan 3,115,500.0 nan nan
2018 214500.2200 1.0000 214500.2200 3,115,625.0 668,302,247,937.50 94582.5047
2019 117000.1200 1.0000 117000.1200 3,165,625.0 370,378,504,875.00 17444.8547
2020 124800.1200 1.0000 124800.1200 4,444,013.0 554,613,355,681.56 31481.9565
2021 191100.1900 1.0000 191100.1900 4,842,851.0 925,469,746,241.69 20019.6752
2022 40169.9600 1.0000 40169.9600 4,079,137.0 163,858,770,124.52 3720.6990
2023 405.4800 0.0010 0.4100 3,167,149.0 1,298,531.09 0.0260
0001600347 Hapi Metaverse Inc Hapi Me nan 2014 nan nan nan 5,132,000.0 nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
0001602813 Frontera Group INC Fronter nan 2015 nan nan nan 7,280,000.0 nan nan
2016 nan nan nan 307,280,000.0 nan nan
2017 nan nan nan 307,280,000.0 nan nan
0001604738 Ashford Inc Ashford nan 2015 nan nan nan 2,010,104.0 nan nan
2016 nan nan nan 2,015,599.0 nan nan
2017 nan nan nan 2,092,721.0 nan nan
2018 nan nan nan 2,390,705.0 nan nan
0001607450 ABV Consulting INC ABV Con 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 5,533,000.0 nan nan
0001620749 Panamera Holdings Corp Panamer PHCI 2015 nan 1.0000 nan 17,990,000.0 nan nan
2016 nan 1.0000 nan 17,990,000.0 nan nan
2017 nan 1.0000 nan 17,990,000.0 nan nan
2018 nan 1.0000 nan 17,990,000.0 nan nan
2019 nan 1.0000 nan 17,990,000.0 nan nan
2020 nan 1.0000 nan 17,990,000.0 nan nan
2022 1.9500 1.0000 1.9500 33,210,000.0 64,759,500.00 1780.1342
0001622879 Medicine Man Technologies Inc Medicin SHWZ 2015 nan 1.0000 nan 9,972,500.0 nan nan
2016 nan 1.0000 nan 10,092,500.0 nan nan
2017 nan 1.0000 nan 21,875,011.0 nan nan
2018 1.2400 1.0000 1.2400 27,578,310.0 34,197,104.40 3.5168
2019 2.8900 1.0000 2.8900 39,952,628.0 115,463,094.92 6.1072
2020 1.5400 1.0000 1.5400 41,933,086.0 64,576,952.44 1.2969
2021 1.8800 1.0000 1.8800 44,400,853.0 83,473,603.64 0.3815
2022 1.4200 1.0000 1.4200 54,741,506.0 77,732,938.52 0.3033
2023 0.5600 1.0000 0.5600 72,591,605.0 40,651,298.80 0.1372
0001629606 Driven Deliveries Inc Driven 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
0001630212 Avalon Globocare Corp Avalon ALBT 2015 nan 0.0070 nan 6,000,000.0 nan nan
2023 7.2900 0.0670 0.4900 10,999,534.0 5,389,771.66 0.3179
0001632121 Balance Labs Inc Balance BLNC 2015 nan 1.0000 nan 20,620,000.0 nan nan
2017 1.5000 1.0000 1.5000 21,620,000.0 32,430,000.00 36.6969
2018 1.3500 1.0000 1.3500 21,620,000.0 29,187,000.00 21.2823
2019 1.0000 1.0000 1.0000 21,674,000.0 21,674,000.00 12.7014
2020 0.3300 1.0000 0.3300 21,674,000.0 7,152,420.00 2.7895
2021 0.7200 1.0000 0.7200 21,674,000.0 15,605,280.00 5.7562
2022 0.2300 1.0000 0.2300 21,674,000.0 4,985,020.00 2.0294
2023 0.2300 1.0000 0.2300 21,674,000.0 4,985,020.00 2.0438
0001640265 GPB Holdings Ii Lp GPB Hol nan 2022 nan nan nan nan nan nan
0001643615 Montrose Environmental Group Inc Montros MEG 2020 31.6100 1.0000 31.6100 24,961,680.0 789,038,704.80 1.7237
2021 70.7300 1.0000 70.7300 29,491,400.0 2,085,926,722.00 3.4860
2022 43.0700 1.0000 43.0700 29,711,566.0 1,279,677,147.62 2.2901
0001644378 RMR Group INC RMR Gro RMR 2016 39.6700 1.0000 39.6700 15,082,432.0 598,320,077.44 2.7919
2017 60.8200 1.0000 60.8200 15,164,066.0 922,278,494.12 3.8610
2018 55.2100 1.0000 55.2100 15,229,957.0 840,845,925.97 2.9288
2019 45.6500 1.0000 45.6500 15,302,320.0 698,550,908.00 1.7317
2021 34.0900 1.0000 34.0900 15,485,011.0 527,884,024.99 1.6290
2022 28.2800 1.0000 28.2800 15,605,741.0 441,330,355.48 1.2344
2023 27.5200 1.0000 27.5200 15,711,047.0 432,368,013.44 1.1669
0001653099 Vigilant Diversified Holdings INC Nv Vigilan nan 2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
2019 nan nan nan nan nan nan
0001654672 Pineapple INC Pineapp PNPL 2020 0.1100 1.0000 0.1100 87,446,200.0 9,619,082.00 1.5669
2021 0.0100 1.0000 0.0100 89,471,569.0 894,715.69 0.1436
2022 0.0100 1.0000 0.0100 91,163,569.0 911,635.69 1.1500
0001657045 Next Chemx Corporation Next Ch CHMX 2018 nan 1.0000 nan 8,620,000.0 nan nan
2019 4.0000 1.0000 4.0000 8,952,060.0 35,808,240.00 60.5584
2020 4.9000 1.0000 4.9000 8,958,989.0 43,899,046.10 354.1245
2021 9.0200 1.0000 9.0200 27,385,437.0 247,016,641.74 106.1335
2022 11.0000 1.0000 11.0000 28,058,535.0 308,643,885.00 108.1951
2023 9.0000 1.0000 9.0000 28,546,834.0 256,921,506.00 71.0171
0001661600 Sativus Tech Corp Sativus SATT 2017 nan 0.1000 nan 2,926,500.0 nan nan
2018 35.0000 0.1000 3.5000 16,250,148.0 56,875,518.00 11.7730
0001693687 Greenlit Ventures INC Greenli GLVT 2018 nan 0.0010 nan 6,000,000.0 nan nan
2019 nan 0.0010 nan 6,731,667.0 nan nan
2020 nan 0.0010 nan 6,731,667.0 nan nan
0001751143 Atlas Technical Consultants INC Atlas T nan 2019 nan nan nan 20,250,000.0 nan nan
2020 nan nan nan 5,838,929.0 nan nan
2021 nan nan nan 33,616,212.0 nan nan
0001777319 Ciso Global Inc Ciso Gl CISO 2019 nan 0.0670 nan nan nan nan
2020 nan 0.0670 nan 115,034,771.0 nan nan
2021 nan 0.0670 nan 117,789,789.0 nan nan
2022 41.0200 0.0670 2.7500 146,253,545.0 402,197,248.75 6.0658
2023 1.3800 0.0670 0.0900 180,176,477.0 16,215,882.93 0.3822
0001790625 Agilethought Inc Agileth AGILQ 2021 5.7200 1.0000 5.7200 41,970,915.0 240,073,633.80 1.3792
2022 4.2000 1.0000 4.2000 48,243,382.0 202,622,204.40 1.1558
0001813603 Hestia Insight Inc Hestia HSTA 2021 3.9600 1.0000 3.9600 27,916,200.0 110,548,152.00 93.0295
2022 0.5300 1.0000 0.5300 27,939,260.0 14,807,807.80 39.6598
2023 0.2300 1.0000 0.2300 27,939,260.0 6,426,029.80 59.9783
0001847590 Bowman Consulting Group Ltd Bowman BWMN 2021 21.5000 1.0000 21.5000 11,311,488.0 243,196,992.00 2.4572
2022 20.8400 1.0000 20.8400 13,518,842.0 281,732,667.28 1.4494
2023 34.3200 1.0000 34.3200 14,648,595.0 502,739,780.40 1.5655
0001877939 Castellum Inc Castell CTM 2022 nan nan nan 41,539,342.0 nan nan
2023 nan nan nan 47,642,427.0 nan nan