QA: us_advertising 2010-2024

Table of Contents

Ranks across the years

name name_short 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 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 2024-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 2023->2024
0001705110 Angi Inc Angi In NaN NaN NaN NaN NaN NaN NaN 1 1 1 1 3 4 4 1 NaN NaN NaN NaN NaN NaN NaN 162.83 176.51 173.80 173.63 163.35 158.04 164.63 171.57 NaN NaN NaN NaN NaN NaN NaN 0 0 0 2 1 0 -3
0001576427 Criteo S A Criteo NaN NaN NaN NaN NaN NaN 7 2 7 5 3 8 9 10 2 NaN NaN NaN NaN NaN NaN 126.11 141.46 137.58 134.42 141.80 136.56 114.17 118.23 121.86 NaN NaN NaN NaN NaN NaN -5 5 -2 -2 5 1 1 -8
0001872525 Stran Company Inc Stran C NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 136.89 120.50 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3
0001495231 IZEA Worldwide Inc IZEA Wo NaN 15 18 19 7 15 15 16 15 12 7 5 5 5 4 NaN 15.21 9.30 48.17 142.47 73.90 73.87 73.59 73.91 93.01 119.03 157.56 153.90 151.37 120.06 NaN 3 1 -12 8 0 1 -1 -3 -5 -2 0 0 -1
0000029989 Omnicom Group INC Omnicom 2 7 8 9 11 10 10 7 10 6 8 11 8 11 5 117.95 117.29 121.37 118.69 117.19 108.63 112.84 115.22 112.10 115.42 117.20 117.71 118.48 117.35 119.59 5 1 1 2 -1 0 -3 3 -4 2 3 -3 3 -6
0001588014 ADM Endeavors INC ADM End NaN NaN NaN NaN 22 NaN NaN 25 17 3 4 4 7 8 6 NaN NaN NaN NaN 49.90 NaN NaN 0.04 73.63 150.87 130.89 162.81 129.98 129.82 115.36 NaN NaN NaN NaN NaN NaN NaN -8 -14 1 0 3 1 -2
0001133311 TRAVELZOO TRAVELZ NaN 6 7 12 6 7 6 9 9 7 16 20 15 12 7 NaN 131.26 145.87 103.78 147.38 123.98 126.99 113.21 117.45 114.70 73.69 75.37 92.84 109.42 102.98 NaN 1 5 -6 1 -1 3 0 -2 9 4 -5 -3 -5
0000051644 Interpublic Group OF Companies INC Interpu 3 9 10 14 16 NaN NaN NaN NaN 13 12 16 13 13 8 94.94 96.11 93.41 91.19 91.63 NaN NaN NaN NaN 91.63 90.07 93.70 95.19 97.53 94.72 6 1 4 2 NaN NaN NaN NaN NaN -1 4 -3 0 -5
0000829323 Inuvo Inc Inuvo I NaN 12 NaN NaN NaN 8 NaN 11 14 10 6 9 16 16 9 NaN 60.13 NaN NaN NaN 116.16 NaN 97.95 85.34 94.58 122.76 130.64 88.49 85.99 91.82 NaN NaN NaN NaN NaN NaN NaN 3 -4 -4 3 7 0 -7
0000876883 Stagwell Inc Stagwel NaN 10 NaN NaN 19 18 18 13 19 15 20 17 14 15 10 NaN 73.91 NaN NaN 73.74 73.10 72.83 83.42 73.38 73.82 71.93 93.47 94.63 92.64 90.46 NaN NaN NaN NaN -1 0 -5 6 -4 5 -3 -3 1 -5
0001556739 Thryv Holdings Inc Thryv H NaN NaN NaN NaN 10 NaN NaN NaN NaN NaN 11 13 11 17 11 NaN NaN NaN NaN 124.24 NaN NaN NaN NaN NaN 99.45 101.69 106.23 73.65 86.52 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 -2 6 -6
0001490281 Groupon Inc Groupon NaN NaN NaN NaN 14 NaN 13 12 13 11 18 15 19 18 12 NaN NaN NaN NaN 101.09 NaN 75.07 86.34 93.04 93.87 73.24 98.56 72.21 73.35 75.49 NaN NaN NaN NaN NaN NaN -1 1 -2 7 -3 4 -1 -6
0001460329 Fluent Inc Fluent NaN NaN NaN NaN 12 9 5 6 6 4 2 7 20 20 13 NaN NaN NaN NaN 107.59 111.24 138.55 126.00 138.27 139.13 144.83 136.98 71.09 70.80 73.59 NaN NaN NaN NaN -3 -4 1 0 -2 -2 5 13 0 -7
0001539850 Starco Brands Inc Starco NaN NaN NaN NaN 31 29 27 22 26 23 9 28 3 19 14 NaN NaN NaN NaN 0.99 0.00 3.41 28.44 15.06 41.18 106.82 33.97 160.26 70.96 71.05 NaN NaN NaN NaN -2 -2 -5 4 -3 -14 19 -25 16 -5
0001334978 Clear Channel Outdoor Holdings Inc Clear C NaN 1 1 2 1 2 NaN NaN NaN NaN 22 24 21 21 15 NaN 173.38 168.76 170.33 168.90 162.52 NaN NaN NaN NaN 70.74 70.15 70.69 69.69 69.49 NaN 0 1 -1 1 NaN NaN NaN NaN NaN 2 -3 0 -6
0001847064 PSQ Holdings Inc PSQ Hol NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 24 16 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.77 66.60 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -8
0001084267 Mobiquity Technologies Inc Mobiqui NaN NaN NaN 24 30 27 26 26 29 26 28 30 27 22 17 NaN NaN NaN 21.50 2.68 11.33 6.04 0.02 0.01 6.38 34.71 0.12 4.86 36.56 47.33 NaN NaN NaN 6 -3 -1 0 3 -3 2 2 -3 -5 -5
0001392694 Surgepays Inc Surgepa NaN NaN 20 20 NaN 20 23 17 20 21 27 25 18 2 18 NaN NaN 3.46 31.89 NaN 66.14 27.48 68.10 66.34 55.81 38.22 66.38 84.59 191.29 20.90 NaN NaN 0 NaN NaN 3 -6 3 1 6 -2 -7 -16 16
0001080034 Conversant INC Convers 1 5 5 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 169.72 148.11 151.00 147.13 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 0 2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0000934796 Network CN INC Network NaN 14 15 22 NaN NaN 21 21 24 25 19 NaN 26 NaN NaN NaN 32.66 49.84 24.92 NaN NaN 31.83 33.03 33.00 32.69 72.01 NaN 34.85 NaN NaN NaN 1 7 NaN NaN NaN 0 3 1 -6 NaN NaN NaN NaN
0001078099 Meet Group Inc Meet Gr NaN 4 NaN 5 3 1 1 8 4 2 NaN NaN NaN NaN NaN NaN 150.79 NaN 152.97 167.88 183.77 206.85 113.26 149.09 151.61 NaN NaN NaN NaN NaN NaN NaN NaN -2 -2 0 7 -4 -2 NaN NaN NaN NaN NaN
0001083243 NZCH Corp NZCH Co NaN 2 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 171.09 157.19 NaN 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
0001091325 China YIDA Holding CO China Y NaN 3 6 10 13 12 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 169.75 148.06 116.99 103.58 94.42 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 4 3 -1 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001297336 Reachlocal Inc Reachlo NaN 8 9 11 18 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 113.11 113.12 109.12 73.89 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 2 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001377630 National Cinemedia Inc Nationa NaN 11 11 16 NaN 16 17 15 18 16 21 23 22 1 NaN NaN 72.68 72.50 73.83 NaN 73.69 73.69 74.04 73.44 73.48 71.81 70.32 68.70 284.52 NaN NaN 0 5 NaN NaN 1 -2 3 -2 5 2 -1 -21 NaN
0001419995 DNA Brands INC DNA Bra NaN 16 19 26 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2.75 5.06 7.23 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 7 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001428397 Adaptive Medias Inc Adaptiv NaN 17 24 25 25 28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.00 0.00 11.25 37.07 0.05 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 7 1 0 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001534298 Zenovia Digital Exchange Corp Zenovia NaN 13 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 52.25 56.78 NaN 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
0000875355 Lendway INC Lendway NaN NaN 2 3 4 4 8 3 5 9 13 21 1 7 NaN NaN NaN 157.37 167.18 159.37 160.31 119.34 138.94 148.00 108.58 89.97 73.62 184.18 133.23 NaN NaN NaN 1 1 0 4 -5 2 4 4 8 -20 6 NaN
0001084332 Salon Media Group INC Salon M NaN NaN 16 21 23 24 20 NaN 25 NaN NaN NaN NaN NaN NaN NaN NaN 29.67 26.90 45.86 27.21 43.00 NaN 18.25 NaN NaN NaN NaN NaN NaN NaN NaN 5 2 1 -4 NaN NaN NaN NaN NaN NaN NaN NaN
0001297965 Inolife Technologies INC Inolife NaN NaN 21 27 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.36 6.09 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 6 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001329957 OSL Holdings Inc OSL Hol NaN NaN 22 NaN 32 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.28 NaN 0.01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001372375 Millennial Media Inc Millenn NaN NaN 4 4 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 152.92 153.76 95.72 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 11 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001431880 Potash America INC Potash NaN NaN 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 23.65 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001491778 Angie s List Inc Angie s NaN NaN 13 18 20 13 14 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 68.29 70.33 73.23 78.62 73.89 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5 2 -7 1 NaN NaN NaN NaN NaN NaN NaN NaN
0001527190 National Cinemedia LLC Nationa NaN NaN 12 17 NaN 17 16 14 16 NaN NaN NaN NaN NaN NaN NaN NaN 70.71 73.80 NaN 73.55 73.70 75.06 73.91 NaN NaN NaN NaN NaN NaN NaN NaN 5 NaN NaN -1 -2 2 NaN NaN NaN NaN NaN NaN
0001538217 SRAX Inc SRAX In NaN NaN 23 13 17 14 12 10 2 19 14 26 NaN NaN NaN NaN NaN 0.27 100.45 74.21 75.03 85.33 112.98 170.48 68.55 74.89 62.68 NaN NaN NaN NaN NaN -10 4 -3 -2 -2 -8 17 -5 12 NaN NaN NaN
0001080627 V Media Corp V Media NaN NaN NaN 15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 90.10 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001375796 Telaria Inc Telaria NaN NaN NaN 8 8 11 11 5 12 14 NaN NaN NaN NaN NaN NaN NaN NaN 143.45 140.64 102.38 106.16 127.86 94.81 88.74 NaN NaN NaN NaN NaN NaN NaN NaN 0 3 0 -6 7 2 NaN NaN NaN NaN NaN
0001415624 YuMe Inc YuMe In NaN NaN NaN 6 9 6 4 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 148.26 137.43 130.06 138.94 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 3 -3 -2 NaN NaN NaN NaN NaN NaN NaN NaN
0001442376 Total Sports Media Inc Total S NaN NaN NaN 23 24 23 22 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 23.80 42.76 39.68 30.74 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 -1 -1 NaN NaN NaN NaN NaN NaN NaN NaN
0001475274 Retailmenot Inc Retailm NaN NaN NaN 1 2 3 3 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 171.31 168.80 160.94 160.28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 1 1 0 NaN NaN NaN NaN NaN NaN NaN NaN
0001088638 Mastermind INC Masterm NaN NaN NaN NaN 27 NaN NaN NaN NaN NaN 5 2 NaN 3 NaN NaN NaN NaN NaN 5.86 NaN NaN NaN NaN NaN 127.44 177.34 NaN 169.45 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -3 NaN NaN NaN
0001115128 Quotient Technology Inc Quotien NaN NaN NaN NaN 5 5 2 4 8 8 10 14 12 NaN NaN NaN NaN NaN NaN 154.92 152.07 160.70 133.11 124.03 111.58 99.76 98.93 95.26 NaN NaN NaN NaN NaN NaN 0 -3 2 4 0 2 4 -2 NaN NaN
0001346655 CMG Holdings Group INC CMG Hol NaN NaN NaN NaN 29 21 NaN NaN NaN NaN 15 6 10 14 NaN NaN NaN NaN NaN 4.91 55.78 NaN NaN NaN NaN 73.90 151.13 108.14 94.00 NaN NaN NaN NaN NaN -8 NaN NaN NaN NaN NaN -9 4 4 NaN
0001509477 Nownews Digital Media Technology Co Ltd Nownews NaN NaN NaN NaN 21 19 25 23 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 52.70 67.74 6.17 13.15 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -2 6 -2 NaN NaN NaN NaN NaN NaN NaN
0001516079 US China Biomedical Technology Inc US Chin NaN NaN NaN NaN 33 NaN 28 24 28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.00 NaN 0.12 0.04 3.70 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 4 NaN NaN NaN NaN NaN NaN
0001559754 Wowio Inc Wowio I NaN NaN NaN NaN 26 26 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 9.64 16.18 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0 NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001615780 Teardroppers Inc Teardro NaN NaN NaN NaN 28 25 24 19 22 22 26 27 23 NaN NaN NaN NaN NaN NaN 5.54 26.28 25.27 43.19 40.40 43.90 40.05 34.21 55.98 NaN NaN NaN NaN NaN NaN -3 -1 -5 3 0 4 1 -4 NaN NaN
0001343465 Sun Pacific Holding Corp Sun Pac NaN NaN NaN NaN NaN 22 19 NaN 27 18 23 12 25 NaN NaN NaN NaN NaN NaN NaN 45.40 48.64 NaN 14.54 69.87 67.86 111.94 36.34 NaN NaN NaN NaN NaN NaN NaN -3 NaN NaN -9 5 -11 13 NaN NaN
0001609139 Innerscope Hearing Technologies INC Innersc NaN NaN NaN NaN NaN NaN 9 20 23 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 116.53 42.97 35.74 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11 3 NaN NaN NaN NaN NaN NaN
0001648365 AGRI Fintech Holdings INC AGRI Fi NaN NaN NaN NaN NaN NaN NaN 18 11 17 25 18 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 67.29 110.50 70.49 41.85 83.73 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -7 6 8 -7 NaN NaN NaN
0001703625 NAPC Defense Inc NAPC De NaN NaN NaN NaN NaN NaN NaN NaN 21 NaN 17 19 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 44.35 NaN 73.34 76.54 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 2 NaN NaN NaN
0001725516 Renewable Innovations INC Renewab NaN NaN NaN NaN NaN NaN NaN NaN 3 24 29 NaN 17 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 161.85 38.84 11.31 NaN 87.38 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 21 5 NaN NaN NaN NaN
0001696195 Kinetic Group INC Kinetic NaN NaN NaN NaN NaN NaN NaN NaN NaN 27 NaN NaN 2 9 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.00 NaN NaN 165.97 121.70 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 7 NaN
0001752372 Ezagoo Ltd Ezagoo NaN NaN NaN NaN NaN NaN NaN NaN NaN 20 24 22 24 23 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 59.28 59.38 70.44 36.36 30.26 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 4 -2 2 -1 NaN
0001463833 IDW Media Holdings INC IDW Med NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 10 6 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 127.61 153.33 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -4 NaN NaN
0001579717 Perk International Inc Perk In 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 NaN 304.45 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
0001840102 Specificity INC Specifi NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 29 28 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 5.77 0.01 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -1 NaN NaN

PDF reports

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

2010

Logs

error 1 × Negative Expenses, ignoring company. pre-agg
warning 9 × The stock price does not exist industry.us_generic
warning 4 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 302,525,000 1,117,622,500 8,453,848,120 10,020,040,000 10,194,100,000 0001080034 0000051644 0000029989
1 AssetsNonCurrent 50,618,000 78,786,200 332,392,440 748,280,000 794,500,000 0001080034 0000029989 0000051644
2 IntangibleAssets 183,218,000 501,746,200 3,369,443,760 7,615,420,000 8,087,300,000 0001080034 0000051644 0000029989
3 PropertyPlantAndEquipment 12,414,000 56,602,600 454,339,800 633,400,000 653,300,000 0001080034 0000051644 0000029989
4 remainder_Assets 0 6,479,200 64,838,862 275,669,200 299,100,000 0000051644 0001080034 0000029989
5 LiabilitiesCurrent 103,258,000 867,022,200 7,741,556,440 10,694,880,000 11,023,100,000 0001080034 0000051644 0000029989
6 LiabilitiesNonCurrent 0 0 494,360 2,224,620,000 2,471,800,000 0000029989 0001080034 0000051644
7 remainder_Liabilities 0 0 7,534 33,901,200 37,668,000 0000029989 0000051644 0001080034
8 CostOfGoodsAndServicesSold 0 0 23,360 105,121,800 116,802,000 0000029989 0000051644 0001080034
9 SellingAndMarketingExpense 0 0 22,456 101,053,800 112,282,000 0000029989 0000051644 0001080034
10 GeneralAndAdministrativeExpense 0 5,353,600 53,897,753 1,681,423,600 1,862,300,000 0000029989 0001080034 0000051644
11 remainder_Expenses 69,778,000 108,820,200 460,966,400 3,909,000,000 4,292,200,000 0001080034 0000029989 0000051644
12 remainder_Revenues 0 43,079,800 432,018,220 5,921,789,800 6,531,900,000 0000029989 0001080034 0000051644
13 remainder_NetIncome -96,200,000 -85,369,000 12,384,358 1,246,721,000 1,383,900,000 0000051644 0001080034 0000029989
14 remainder_ComprehensiveNetIncome -86,500,000 -77,850,000 11,900 53,550,000 59,500,000 0000029989 0001080034 0000051644
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 613,567,000 1,859,290,300 13,072,099,060 18,916,570,000 19,566,100,000 0001080034 0000051644 0000029989
1 Liabilities 140,926,000 1,148,103,400 10,212,862,080 10,942,060,000 11,023,100,000 0001080034 0000051644 0000029989
2 Expenses 352,398,000 363,178,200 461,338,860 5,585,070,000 6,154,500,000 0001080034 0000029989 0000051644
3 Revenues 0 43,079,800 432,018,220 5,921,789,800 6,531,900,000 0000029989 0001080034 0000051644
4 StockholdersEquity 472,641,000 711,186,900 2,859,236,980 7,974,510,000 8,543,000,000 0001080034 0000051644 0000029989
5 NetIncome 90,510,000 109,579,000 281,328,500 859,450,000 923,700,000 0001080034 0000051644 0000029989
6 ComprehensiveNetIncome 90,510,000 115,529,000 340,799,300 787,550,000 837,200,000 0001080034 0000051644 0000029989
7 BaseVar 774,899,500 2,323,399,550 16,260,260,580 17,882,510,000 18,062,800,000 0001080034 0000029989 0000051644
8 EconomicCapitalRatiobeforeLimitedLiability 0.221 0.248 0.491 1.14 1.22 0000051644 0000029989 0001080034
9 EconomicCapitalRatio 0.949 0.972 1.18 1.65 1.70 0000051644 0000029989 0001080034

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.0248 -0.0246 -0.0219 0.0571 0.0659 0000051644 0001080034 0000029989
1 AssetsNonCurrent -0.0103 -0.00917 0.000696 0.00479 0.00525 0000029989 0000051644 0001080034
2 IntangibleAssets -0.101 -0.0924 -0.0152 0.0880 0.0994 0000051644 0001080034 0000029989
3 PropertyPlantAndEquipment -0.00255 -0.00248 -0.00185 0.00523 0.00602 0001080034 0000051644 0000029989
4 remainder_Assets -0.0309 -0.0286 -0.00705 0.0102 0.0121 0000051644 0000029989 0001080034
5 LiabilitiesCurrent -0.252 -0.229 -0.0192 0.389 0.434 0000029989 0000051644 0001080034
6 LiabilitiesNonCurrent -0.119 -0.103 0.0394 0.0781 0.0824 0000051644 0000029989 0001080034
7 remainder_Liabilities -0.0630 -0.0552 0.0141 0.0195 0.0201 0001080034 0000029989 0000051644
8 CostOfGoodsAndServicesSold -0.136 -0.118 0.0434 0.0691 0.0719 0001080034 0000029989 0000051644
9 SellingAndMarketingExpense -0.131 -0.113 0.0417 0.0663 0.0691 0001080034 0000029989 0000051644
10 GeneralAndAdministrativeExpense -0.0632 -0.0585 -0.0158 0.0431 0.0497 0000051644 0001080034 0000029989
11 remainder_Expenses -0.160 -0.141 0.0389 0.0748 0.0788 0000051644 0001080034 0000029989
12 remainder_Revenues -0.245 -0.212 0.0800 0.326 0.354 0000029989 0000051644 0001080034
13 remainder_NetIncome -0.0515 -0.0486 -0.0219 0.0393 0.0461 0000051644 0001080034 0000029989
14 remainder_ComprehensiveNetIncome -0.00396 -0.00347 0.000916 0.00512 0.00559 0000029989 0001080034 0000051644
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.145 -0.133 -0.0237 0.149 0.168 0000051644 0001080034 0000029989
1 Liabilities -0.189 -0.182 -0.118 0.394 0.451 0000029989 0000051644 0001080034
2 Expenses -0.245 -0.229 -0.0908 0.192 0.223 0001080034 0000051644 0000029989
3 Revenues -0.245 -0.212 0.0800 0.326 0.354 0000029989 0000051644 0001080034
4 StockholdersEquity -0.278 -0.244 0.0638 0.179 0.192 0000051644 0000029989 0001080034
5 NetIncome -0.0657 -0.0596 -0.00531 0.0653 0.0731 0000051644 0000029989 0001080034
6 ComprehensiveNetIncome -0.0603 -0.0552 -0.00926 0.0657 0.0741 0000051644 0000029989 0001080034
7 BaseVar nan nan nan nan nan 0000029989 0000051644 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.349 -0.326 -0.118 0.347 0.399 0000051644 0000029989 0001080034
9 EconomicCapitalRatio -0.326 -0.303 -0.0958 0.370 0.422 0000051644 0000029989 0001080034

2011

Logs

error 8 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Negative Expenses, ignoring company. pre-agg
warning 13 × The stock price does not exist industry.us_generic
warning 10 × No stock price available subcommand.plot
warning 7 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 6 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 2 × Missing logo subcommand.report

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 16,038 20,305,868 8,713,740,000 10,421,500,000 0001083243 0001078099 0000029989
1 AssetsNonCurrent 0 0 538,123 646,100,000 685,700,000 0000934796 0001078099 0000051644
2 IntangibleAssets 0 0 2,214,846 4,540,380,000 8,924,700,000 0000934796 0000829323 0000029989
3 PropertyPlantAndEquipment 0 0 3,558,363 504,420,000 682,900,000 0001083243 0001133311 0000029989
4 remainder_Assets -24,600,000 -6,653,235 21,163 1,072,756,000 4,626,980,000 0001377630 0001495231 0001334978
5 LiabilitiesCurrent 5,366 110,761 9,386,181 8,760,280,000 11,671,000,000 0001083243 0000829323 0000029989
6 LiabilitiesNonCurrent 0 0 0 1,261,780,000 2,103,300,000 0000029989 0001080034 0000051644
7 remainder_Liabilities 0 0 0 145,234,800 181,702,000 0000029989 0000829323 0001080034
8 CostOfGoodsAndServicesSold 0 0 0 200,897,000 242,249,000 0000029989 0001078099 0001080034
9 SellingAndMarketingExpense 0 0 834 80,782,600 139,929,000 0000029989 0001534298 0001297336
10 GeneralAndAdministrativeExpense 0 0 4,795,428 560,276,800 1,924,300,000 0000029989 0001091325 0000051644
11 remainder_Expenses 0 0 16,343,968 6,247,700,000 12,865,300,000 0001083243 0001297336 0000029989
12 remainder_Revenues 0 0 11,889,203 8,386,180,000 13,872,500,000 0000876883 0001078099 0000029989
13 remainder_NetIncome -73,700,000 -18,969,600 16,490 287,738,800 898,782,000 0001377630 0001534298 0000876883
14 remainder_ComprehensiveNetIncome -193,100,000 -93,580,000 0 1,269,810 5,679,100 0000029989 0001297336 0001091325
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 259,908 315,555 106,900,108 14,402,360,000 20,505,400,000 0001534298 0001078099 0000029989
1 Liabilities 5,366 110,761 30,612,715 10,442,920,000 11,671,000,000 0001083243 0001133311 0000029989
2 Expenses 179,171 310,532 41,668,552 7,787,140,000 12,865,300,000 0001083243 0000829323 0000029989
3 Revenues 0 0 11,889,203 8,386,180,000 13,872,500,000 0000876883 0001078099 0000029989
4 StockholdersEquity -346,800,000 -73,405,134 37,816,267 6,860,641,600 8,834,400,000 0001377630 0001133311 0000029989
5 NetIncome -76,920,000 -25,596,654 -312,134 653,280,000 1,060,400,000 0000876883 0001534298 0000029989
6 ComprehensiveNetIncome -85,184,000 -27,614,333 -312,134 614,660,000 867,300,000 0000876883 0001534298 0000029989
7 BaseVar 385,706 612,592 154,767,167 20,555,730,000 29,580,250,000 0001534298 0001091325 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -11.8 -5.04 0.234 1.24 1.27 0001428397 0000051644 0001334978
9 EconomicCapitalRatio 0.00000000000000000210 0.0220 0.961 1.72 1.73 0001428397 0000051644 0001334978

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.0883 -0.0825 -0.00496 0.238 0.284 0001534298 0001377630 0001133311
1 AssetsNonCurrent -0.0573 -0.0554 -0.00788 0.0426 0.172 0001495231 0001078099 0001377630
2 IntangibleAssets -0.242 -0.167 -0.0116 0.235 0.633 0001495231 0001377630 0001078099
3 PropertyPlantAndEquipment -0.134 -0.125 -0.0317 0.231 0.512 0001495231 0001080034 0001534298
4 remainder_Assets -0.262 -0.207 -0.106 0.402 1.39 0001495231 0000029989 0001083243
5 LiabilitiesCurrent -0.231 -0.203 0.0380 0.303 0.331 0000051644 0000829323 0001297336
6 LiabilitiesNonCurrent -0.795 -0.319 0.0103 0.219 0.231 0001377630 0000829323 0001297336
7 remainder_Liabilities -0.228 -0.123 0.0146 0.0875 0.0969 0001080034 0000829323 0001133311
8 CostOfGoodsAndServicesSold -0.849 -0.708 0.0135 0.139 0.225 0001297336 0001377630 0001133311
9 SellingAndMarketingExpense -0.732 -0.631 0.0101 0.0990 0.102 0001133311 0001080034 0000029989
10 GeneralAndAdministrativeExpense -0.543 -0.281 0.0298 0.288 0.373 0001495231 0001377630 0001297336
11 remainder_Expenses -0.189 -0.160 0.0724 0.404 0.478 0000029989 0000051644 0001297336
12 remainder_Revenues -0.692 -0.512 0.00000788 0.555 0.729 0001133311 0001428397 0001297336
13 remainder_NetIncome -0.262 -0.154 -0.0549 0.296 1.02 0001297336 0001083243 0001133311
14 remainder_ComprehensiveNetIncome -0.00956 -0.00907 0.000308 0.0188 0.0329 0001334978 0001534298 0001091325
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.541 -0.455 -0.00544 0.383 0.398 0001495231 0001377630 0001078099
1 Liabilities -0.353 -0.263 0.0482 0.427 0.543 0001377630 0000934796 0001133311
2 Expenses -0.418 -0.409 0.0467 0.315 0.388 0001297336 0000934796 0001091325
3 Revenues -0.692 -0.512 0.00000788 0.555 0.729 0001133311 0001428397 0001297336
4 StockholdersEquity -0.413 -0.401 -0.0909 0.780 0.973 0001495231 0001133311 0001083243
5 NetIncome -0.216 -0.213 0.0926 0.531 0.603 0001534298 0001078099 0001133311
6 ComprehensiveNetIncome -0.216 -0.213 0.0877 0.528 0.603 0001534298 0001078099 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001091325 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.607 -0.585 0.354 1.11 1.13 0001428397 0000051644 0001334978
9 EconomicCapitalRatio -0.930 -0.908 0.0317 0.786 0.804 0001428397 0000051644 0001334978

2012

Logs

error 4 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × No NetIncome node found, ignoring company. input.sec.calculation_linkbase.edgar_model_mapping
error 1 × Negative Expenses, ignoring company. pre-agg
warning 17 × The stock price does not exist industry.us_generic
warning 16 × No stock price available subcommand.plot
warning 11 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 3 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 3 × Missing logo subcommand.report
warning 2 × Similarly named company. Duplicate? None

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 911 5,335,027 7,654,865,000 11,661,400,000 0001083243 0001091325 0000029989
1 AssetsNonCurrent 0 0 96,918 550,125,000 670,200,000 0000934796 0001084332 0000051644
2 IntangibleAssets 0 0 0 3,333,455,200 9,300,300,000 0000875355 0000934796 0000029989
3 PropertyPlantAndEquipment 0 0 205,724 450,519,243 723,800,000 0001083243 0000934796 0000029989
4 remainder_Assets -25,700,000 -23,211,650 0 150,177,250 3,494,379,000 0001377630 0001534298 0001334978
5 LiabilitiesCurrent 0 7,921 4,357,007 6,668,155,750 11,875,800,000 0001491778 0000875355 0000029989
6 LiabilitiesNonCurrent 0 0 0 1,046,280,000 3,108,400,000 0000029989 0001084332 0000051644
7 remainder_Liabilities 0 0 0 77,876,500 159,546,000 0000029989 0000875355 0001080034
8 CostOfGoodsAndServicesSold 0 0 0 209,096,450 249,259,000 0000029989 0001083243 0001080034
9 SellingAndMarketingExpense 0 0 134,413 84,684,000 167,424,000 0000029989 0000934796 0001297336
10 GeneralAndAdministrativeExpense 0 0 1,866,135 74,963,150 1,886,000,000 0000029989 0000934796 0000051644
11 remainder_Expenses 0 191 4,793,174 4,364,073,200 13,122,000,000 0001083243 0001428397 0000029989
12 remainder_Revenues 0 0 4,219,017 6,354,811,600 14,219,400,000 0000934796 0001495231 0000029989
13 remainder_NetIncome -108,466,000 -98,360,000 0 18,125,400 135,427,000 0001334978 0001491778 0001133311
14 remainder_ComprehensiveNetIncome -80,200,000 -54,645,000 0 9,578,750 35,100,000 0000051644 0001329957 0001527190
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,202 13,672 16,791,698 12,535,682,300 22,151,900,000 0001329957 0000875355 0000029989
1 Liabilities 20,158 222,656 10,078,641 9,363,620,000 11,875,800,000 0001083243 0001084332 0000029989
2 Expenses 198,779 296,078 15,650,880 5,967,173,200 13,122,000,000 0001534298 0000875355 0000029989
3 Revenues 0 0 4,219,017 6,354,811,600 14,219,400,000 0000934796 0001495231 0000029989
4 StockholdersEquity -524,200,000 -304,858,350 -27,678 5,752,790,450 10,276,100,000 0001527190 0001538217 0000029989
5 NetIncome -159,210,000 -45,785,044 -1,234,633 410,167,400 1,117,500,000 0001334978 0000934796 0000029989
6 ComprehensiveNetIncome -148,723,000 -45,785,044 -1,333,853 347,155,000 1,060,500,000 0001334978 0001538217 0000029989
7 BaseVar 330,043 628,780 26,564,148 17,127,157,900 30,723,100,000 0001534298 0000875355 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -6.38 -4.38 -0.455 1.03 1.20 0001428397 0001527190 0001334978
9 EconomicCapitalRatio 0.00000527 0.00275 0.695 1.57 1.69 0001428397 0001527190 0001334978

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.103 -0.0983 -0.0221 0.356 0.540 0001495231 0001527190 0001372375
1 AssetsNonCurrent -0.0816 -0.0725 -0.0164 0.136 0.189 0001495231 0000051644 0001431880
2 IntangibleAssets -0.103 -0.0557 -0.0183 0.176 0.234 0001495231 0001083243 0000029989
3 PropertyPlantAndEquipment -0.0906 -0.0829 -0.0204 0.342 0.457 0001495231 0001080034 0001091325
4 remainder_Assets -0.152 -0.105 -0.0388 0.114 1.57 0001495231 0001491778 0001083243
5 LiabilitiesCurrent -0.0895 -0.0722 0.0373 0.365 0.394 0000051644 0001527190 0001297336
6 LiabilitiesNonCurrent -0.872 -0.685 -0.00334 0.212 0.301 0001527190 0001329957 0001297336
7 remainder_Liabilities -0.177 -0.0969 0.00945 0.153 0.200 0001491778 0001527190 0001297336
8 CostOfGoodsAndServicesSold -0.846 -0.403 0.0148 0.129 0.178 0001297336 0001091325 0001133311
9 SellingAndMarketingExpense -0.639 -0.480 0.00202 0.0882 0.0912 0001297336 0001527190 0000029989
10 GeneralAndAdministrativeExpense -0.602 -0.213 0.0356 0.279 0.393 0001495231 0001377630 0001297336
11 remainder_Expenses -0.668 -0.264 0.0461 0.501 0.590 0001538217 0001527190 0001133311
12 remainder_Revenues -0.516 -0.216 0.00128 0.541 0.768 0001133311 0001538217 0001297336
13 remainder_NetIncome -0.0336 -0.0316 -0.00979 0.166 0.916 0001419995 0001377630 0001133311
14 remainder_ComprehensiveNetIncome -0.0118 -0.00624 -0.000205 0.00754 0.00841 0001297336 0001431880 0001527190
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.504 -0.464 -0.0243 0.469 0.836 0001538217 0001527190 0001083243
1 Liabilities -0.133 -0.102 0.0406 0.560 0.601 0001377630 0001419995 0001372375
2 Expenses -0.614 -0.433 0.0613 0.342 0.465 0001538217 0000934796 0001091325
3 Revenues -0.516 -0.216 0.00128 0.541 0.768 0001133311 0001538217 0001297336
4 StockholdersEquity -0.380 -0.274 0.000242 0.876 0.950 0001084332 0001538217 0001334978
5 NetIncome -0.288 -0.206 0.119 0.735 0.757 0001431880 0001377630 0001133311
6 ComprehensiveNetIncome -0.289 -0.206 0.112 0.740 0.758 0001431880 0001377630 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001297965 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.507 -0.504 0.188 1.07 1.18 0001428397 0001527190 0001334978
9 EconomicCapitalRatio -0.750 -0.747 -0.0547 0.824 0.938 0001428397 0001527190 0001334978

2013

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
warning 21 × The stock price does not exist industry.us_generic
warning 18 × No stock price available subcommand.plot
warning 16 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 4 × Similarly named company. Duplicate? None
warning 3 × Missing logo subcommand.report
warning 2 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × NetIncome node detected by IncomeLoss name heuristic input.sec.calculation_linkbase.edgar_model_mapping

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 726 155,533 27,006,211 6,030,328,400 11,652,300,000 0001392694 0000875355 0000029989
1 AssetsNonCurrent 0 0 107,257 756,860,000 1,920,425,000 0000934796 0001084332 0001334978
2 IntangibleAssets 0 0 2,977 3,115,675,100 9,302,000,000 0000875355 0001527190 0000029989
3 PropertyPlantAndEquipment 0 0 3,396,377 442,991,006 737,400,000 0001297965 0001375796 0000029989
4 remainder_Assets -205,858,000 -45,125,800 302,063 127,229,500 1,682,622,000 0001372375 0001084267 0001334978
5 LiabilitiesCurrent 0 819,105 27,168,500 5,947,787,000 12,277,700,000 0001491778 0001080627 0000029989
6 LiabilitiesNonCurrent 0 0 0 1,020,130,000 2,239,800,000 0000029989 0001080627 0000051644
7 remainder_Liabilities 0 0 0 89,531,900 165,963,000 0000029989 0001080627 0001080034
8 CostOfGoodsAndServicesSold 0 0 746,453 174,729,600 256,450,000 0000029989 0001428397 0001297336
9 SellingAndMarketingExpense 0 0 338,413 87,917,700 182,854,000 0000029989 0001442376 0001297336
10 GeneralAndAdministrativeExpense 0 0 3,994,429 62,767,400 1,917,900,000 0000029989 0000875355 0000051644
11 remainder_Expenses 0 263,421 11,367,546 4,265,093,300 13,521,600,000 0001495231 0001091325 0000029989
12 remainder_Revenues 0 0 27,787,820 5,869,467,000 14,584,500,000 0000934796 0000875355 0000029989
13 remainder_NetIncome -128,200,000 -47,920,000 -205,024 67,876,500 140,832,000 0000051644 0001442376 0001133311
14 remainder_ComprehensiveNetIncome -182,600,000 -126,650,000 0 4,184,914 10,300,000 0000029989 0001475274 0001527190
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,794 194,702 105,666,813 11,061,317,600 22,098,700,000 0001392694 0001491778 0000029989
1 Liabilities 812,809 879,261 33,543,324 7,647,590,000 12,277,700,000 0001538217 0001375796 0000029989
2 Expenses 37,912 1,098,288 50,684,483 5,607,623,300 13,521,600,000 0001392694 0001078099 0000029989
3 Revenues 0 0 27,787,820 5,869,467,000 14,584,500,000 0000934796 0000875355 0000029989
4 StockholdersEquity -299,200,000 -107,817,000 14,809,549 4,940,031,400 9,821,000,000 0001527190 0001080627 0000029989
5 NetIncome -32,989,000 -21,934,519 -3,099,488 251,100,000 1,111,600,000 0001491778 0001419995 0000029989
6 ComprehensiveNetIncome -49,433,000 -31,946,800 -3,321,417 164,650,000 929,000,000 0001334978 0001495231 0000029989
7 BaseVar 450,890 2,557,135 234,330,356 15,137,547,750 31,356,900,000 0001392694 0001091325 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -2.93 -2.74 0.180 1.21 1.24 0001297965 0000051644 0001475274
9 EconomicCapitalRatio 0.0609 0.0844 0.912 1.69 1.71 0001297965 0000051644 0001475274

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.183 -0.175 -0.0154 0.243 0.299 0001442376 0001491778 0001133311
1 AssetsNonCurrent -0.130 -0.115 -0.0405 0.108 0.207 0001084267 0001392694 0001372375
2 IntangibleAssets -0.219 -0.156 -0.0591 0.159 0.518 0001084267 0001297965 0001078099
3 PropertyPlantAndEquipment -0.112 -0.0978 -0.0350 0.140 0.488 0001297336 0001297965 0001091325
4 remainder_Assets -0.118 -0.0822 -0.00422 0.0954 0.287 0001372375 0001475274 0001538217
5 LiabilitiesCurrent -0.322 -0.0526 0.127 0.449 0.523 0001080627 0000934796 0000875355
6 LiabilitiesNonCurrent -0.940 -0.670 0.0255 0.169 0.266 0001527190 0001491778 0001297336
7 remainder_Liabilities -0.646 -0.167 0.0147 0.0612 0.0778 0001491778 0001475274 0001297336
8 CostOfGoodsAndServicesSold -0.832 -0.449 0.0154 0.187 0.299 0001297336 0001428397 0001133311
9 SellingAndMarketingExpense -0.673 -0.404 0.0113 0.104 0.178 0001297336 0001297965 0001538217
10 GeneralAndAdministrativeExpense -0.510 -0.162 0.00527 0.123 0.224 0001495231 0001527190 0001538217
11 remainder_Expenses -0.575 -0.437 0.0165 0.411 0.503 0001084267 0000051644 0001415624
12 remainder_Revenues -0.643 -0.292 0.0560 0.547 0.729 0001133311 0000051644 0001297336
13 remainder_NetIncome -0.122 -0.0460 -0.00142 0.0159 0.555 0001080627 0001475274 0001133311
14 remainder_ComprehensiveNetIncome -0.0927 -0.00799 0.00227 0.0106 0.0223 0001375796 0001491778 0001091325
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.343 -0.333 0.00903 0.235 0.434 0001297336 0001377630 0001091325
1 Liabilities -0.330 -0.246 0.101 0.603 0.652 0001527190 0000934796 0000875355
2 Expenses -0.724 -0.566 -0.0240 0.205 0.431 0001297336 0001375796 0001091325
3 Revenues -0.643 -0.292 0.0560 0.547 0.729 0001133311 0000051644 0001297336
4 StockholdersEquity -0.418 -0.402 0.165 0.806 0.909 0001392694 0001080627 0001334978
5 NetIncome -0.622 -0.469 0.0914 0.417 0.449 0001428397 0001491778 0001080034
6 ComprehensiveNetIncome -0.622 -0.458 0.0952 0.426 0.460 0001428397 0001491778 0001080034
7 BaseVar nan nan nan nan nan 0000029989 0001334978 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.654 -0.631 0.197 0.979 0.998 0001297965 0000051644 0001475274
9 EconomicCapitalRatio -0.830 -0.806 0.0216 0.803 0.823 0001297965 0000051644 0001475274

2014

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
warning 21 × The stock price does not exist industry.us_generic
warning 20 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 20 × No stock price available subcommand.plot
warning 2 × Missing logo subcommand.report
warning 1 × Similarly named company. Duplicate? None
warning 1 × NetIncome node detected by IncomeLoss name heuristic 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 20,679 8,984,972 3,964,877,400 11,190,500,000 0001516079 0001495231 0000029989
1 AssetsNonCurrent 0 0 96,775 468,680,000 1,747,280,000 0001088638 0001084332 0001334978
2 IntangibleAssets 0 0 29,121 2,597,996,000 9,211,600,000 0000875355 0001509477 0000029989
3 PropertyPlantAndEquipment 0 0 1,467,112 328,765,000 708,000,000 0001088638 0000875355 0000029989
4 remainder_Assets -199,892,000 -21,239,200 171,615 424,520,000 1,651,322,000 0001372375 0001442376 0001334978
5 LiabilitiesCurrent 0 0 5,273,230 3,780,677,600 12,061,100,000 0001460329 0000875355 0000029989
6 LiabilitiesNonCurrent 0 0 0 397,152,000 2,875,300,000 0000029989 0001088638 0000051644
7 remainder_Liabilities 0 0 2,094 78,663,600 192,561,000 0000029989 0001084332 0000876883
8 CostOfGoodsAndServicesSold 0 0 1,820,793 382,032,600 1,642,502,000 0000029989 0001509477 0001490281
9 SellingAndMarketingExpense 0 0 128 217,249,200 436,000,000 0000029989 0000876883 0001556739
10 GeneralAndAdministrativeExpense 0 0 2,934,312 214,429,200 1,928,100,000 0000029989 0001460329 0000051644
11 remainder_Expenses -2,744,000 -16,400 6,591,063 3,833,171,200 14,144,000,000 0001133311 0001415624 0000029989
12 remainder_Revenues 0 0 7,813,058 4,929,852,800 15,317,800,000 0000876883 0001346655 0000029989
13 remainder_NetIncome -354,000,000 -46,611,800 -29,395 101,515,200 1,131,018,000 0001556739 0001509477 0000876883
14 remainder_ComprehensiveNetIncome -555,700,000 -194,214,000 0 105,225 1,762,000 0000029989 0001559754 0001490281
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 197 36,074 30,718,875 8,916,326,600 21,559,700,000 0001516079 0000875355 0000029989
1 Liabilities 48,177 158,268 10,993,610 5,216,951,400 12,061,100,000 0001088638 0001078099 0000029989
2 Expenses 102,293 314,439 26,137,762 4,719,432,400 14,144,000,000 0001088638 0000875355 0000029989
3 Revenues 0 0 7,813,058 4,929,852,800 15,317,800,000 0000876883 0001346655 0000029989
4 StockholdersEquity -153,629,000 -11,125,676 7,473,120 3,702,992,800 9,498,600,000 0000876883 0001460329 0000029989
5 NetIncome -371,000,000 -97,986,200 -3,528,690 218,339,000 1,233,100,000 0001556739 0001460329 0000029989
6 ComprehensiveNetIncome -422,000,000 -142,168,200 -3,825,528 114,731,000 677,400,000 0001556739 0001559754 0000029989
7 BaseVar 90,506 366,514 44,679,223 11,575,565,900 31,848,800,000 0001088638 0000875355 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -15.1 -4.51 0.00355 1.19 1.20 0001516079 0001538217 0001334978
9 EconomicCapitalRatio 0.0000000000000000000000000000118 0.00600 0.743 1.68 1.69 0001516079 0001538217 0001334978

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.680 -0.252 -0.00581 0.279 0.339 0001346655 0001491778 0001460329
1 AssetsNonCurrent -0.162 -0.0669 -0.0213 0.197 0.338 0001346655 0001084267 0001460329
2 IntangibleAssets -0.402 -0.123 -0.0358 0.212 0.285 0001346655 0000875355 0001078099
3 PropertyPlantAndEquipment -0.234 -0.0747 -0.0180 0.0574 0.427 0001346655 0001415624 0001091325
4 remainder_Assets -0.358 -0.139 -0.0151 0.277 0.440 0001372375 0000875355 0001556739
5 LiabilitiesCurrent -0.200 -0.130 0.0178 0.292 0.329 0000029989 0001297336 0001460329
6 LiabilitiesNonCurrent -0.397 -0.203 0.00408 0.0828 0.0838 0001091325 0001297336 0001133311
7 remainder_Liabilities -0.701 -0.280 0.0163 0.169 0.174 0001491778 0001509477 0001133311
8 CostOfGoodsAndServicesSold -0.882 -0.404 0.0000955 0.194 0.285 0001297336 0001329957 0001133311
9 SellingAndMarketingExpense -0.753 -0.417 0.0105 0.0949 0.109 0001297336 0001084267 0000029989
10 GeneralAndAdministrativeExpense -0.385 -0.313 0.0608 0.311 0.368 0001088638 0001588014 0001556739
11 remainder_Expenses -2.30 -0.396 0.0565 0.651 0.712 0001346655 0001559754 0001133311
12 remainder_Revenues -0.699 -0.353 0.0524 0.458 0.630 0001133311 0000051644 0001415624
13 remainder_NetIncome -0.256 -0.0997 -0.00883 0.339 0.939 0001556739 0000875355 0001133311
14 remainder_ComprehensiveNetIncome -0.0333 -0.0251 0.000437 0.00386 0.0493 0001556739 0001559754 0001509477
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -1.09 -0.322 0.00866 0.265 0.360 0001346655 0000876883 0001460329
1 Liabilities -0.367 -0.268 0.0256 0.431 0.484 0001538217 0001088638 0001556739
2 Expenses -1.41 -0.350 0.0662 0.336 0.422 0001346655 0000876883 0000029989
3 Revenues -0.699 -0.353 0.0524 0.458 0.630 0001133311 0000051644 0001415624
4 StockholdersEquity -0.619 -0.323 0.0157 0.773 0.851 0001346655 0000051644 0001078099
5 NetIncome -0.581 -0.423 0.190 0.676 0.753 0001539850 0001091325 0001133311
6 ComprehensiveNetIncome -0.579 -0.422 0.199 0.677 0.749 0001539850 0001491778 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001375796 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.534 -0.528 0.208 1.15 1.15 0001516079 0001538217 0001334978
9 EconomicCapitalRatio -0.813 -0.807 -0.0701 0.870 0.876 0001516079 0001538217 0001334978

2015

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
warning 21 × The stock price does not exist industry.us_generic
warning 21 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 15 × No stock price available subcommand.plot
warning 1 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Missing logo subcommand.report

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 46,899 148,019 15,769,031 1,149,824,600 11,980,500,000 0001615780 0001495231 0000029989
1 AssetsNonCurrent 0 0 178,608 773,940,000 1,540,317,000 0001091325 0001078099 0001334978
2 IntangibleAssets 0 0 1,146,307 1,415,014,400 9,021,200,000 0000875355 0001491778 0000029989
3 PropertyPlantAndEquipment 0 5,769 1,063,462 131,359,776 692,700,000 0001334978 0001460329 0000029989
4 remainder_Assets -32,344,000 -25,100,000 14,098 116,938,000 1,509,769,000 0001375796 0001509477 0001334978
5 LiabilitiesCurrent 0 0 8,159,608 917,417,400 14,219,600,000 0001428397 0001084332 0000029989
6 LiabilitiesNonCurrent 0 0 5,202 875,977,200 1,130,800,000 0000029989 0001115128 0001377630
7 remainder_Liabilities 0 0 63,557 111,781,600 309,285,000 0000029989 0001559754 0000876883
8 CostOfGoodsAndServicesSold 0 0 670,001 93,898,000 99,266,000 0000029989 0001442376 0001375796
9 SellingAndMarketingExpense 0 0 289 87,089,200 99,380,000 0000029989 0000876883 0001475274
10 GeneralAndAdministrativeExpense 0 0 4,088,013 47,313,600 322,207,000 0000029989 0000875355 0000876883
11 remainder_Expenses -5,489,000 71,243 11,475,208 2,142,776,200 13,979,000,000 0001460329 0001415624 0000029989
12 remainder_Revenues 0 0 14,525,809 1,862,322,400 15,134,400,000 0000876883 0001091325 0000029989
13 remainder_NetIncome -66,500,000 -55,190,800 -15,094 100,475,200 1,231,507,000 0001377630 0001392694 0000876883
14 remainder_ComprehensiveNetIncome -506,700,000 -100,306,400 0 1,037,999 4,955,000 0000029989 0001460329 0000876883
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 85,637 238,713 31,817,222 4,450,419,400 22,110,700,000 0001615780 0000875355 0000029989
1 Liabilities 706,901 1,366,121 17,791,342 1,707,111,200 14,219,600,000 0001615780 0000829323 0000029989
2 Expenses 215,700 889,671 29,277,593 2,271,659,000 13,979,000,000 0001615780 0001538217 0000029989
3 Revenues 0 0 14,525,809 1,862,322,400 15,134,400,000 0000876883 0001091325 0000029989
4 StockholdersEquity -417,602,000 -228,580,000 -314,904 3,458,507,200 7,891,100,000 0000876883 0001509477 0000029989
5 NetIncome -84,535,000 -60,076,800 -1,335,321 77,980,000 1,203,400,000 0001460329 0001392694 0000029989
6 ComprehensiveNetIncome -206,552,000 -68,074,200 -1,335,321 59,780,000 696,700,000 0001334978 0001392694 0000029989
7 BaseVar 527,270 1,806,713 92,580,884 5,189,134,200 32,999,200,000 0001615780 0000829323 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -7.24 -4.01 -0.0167 1.10 1.43 0001539850 0001495231 0001078099
9 EconomicCapitalRatio 0.000000171 0.0456 0.739 1.62 1.84 0001539850 0001495231 0001078099

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.139 -0.136 -0.00528 0.278 0.310 0000829323 0000876883 0001415624
1 AssetsNonCurrent -0.110 -0.0973 -0.0349 0.152 0.254 0001491778 0001442376 0000829323
2 IntangibleAssets -0.219 -0.147 -0.0354 0.195 0.383 0001491778 0001377630 0001460329
3 PropertyPlantAndEquipment -0.0893 -0.0689 -0.0142 0.0747 0.338 0001538217 0001415624 0001091325
4 remainder_Assets -0.227 -0.110 -0.0121 0.0943 0.288 0000829323 0001115128 0001460329
5 LiabilitiesCurrent -0.151 -0.0874 0.0600 0.398 0.424 0000029989 0001084332 0000829323
6 LiabilitiesNonCurrent -0.781 -0.677 0.00648 0.237 0.267 0001527190 0001392694 0001133311
7 remainder_Liabilities -0.949 -0.254 0.00861 0.115 0.149 0001491778 0001392694 0000829323
8 CostOfGoodsAndServicesSold -0.430 -0.415 0.0138 0.185 0.334 0001495231 0001377630 0001133311
9 SellingAndMarketingExpense -0.849 -0.312 0.0151 0.0949 0.226 0001133311 0001538217 0000829323
10 GeneralAndAdministrativeExpense -0.217 -0.135 0.0102 0.142 0.346 0001495231 0001615780 0000829323
11 remainder_Expenses -0.561 -0.430 0.0184 0.448 0.562 0000829323 0001377630 0001415624
12 remainder_Revenues -0.773 -0.352 0.0379 0.509 0.653 0001133311 0001495231 0000829323
13 remainder_NetIncome -0.274 -0.211 -0.0121 0.0913 0.897 0001495231 0000029989 0001133311
14 remainder_ComprehensiveNetIncome -0.0240 -0.0217 0.000876 0.00577 0.0411 0001091325 0001084267 0001509477
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.335 -0.265 -0.00768 0.246 0.436 0001084332 0001538217 0001460329
1 Liabilities -0.253 -0.215 0.0538 0.586 0.600 0001527190 0001509477 0001115128
2 Expenses -0.473 -0.275 0.00740 0.233 0.376 0000829323 0001346655 0001460329
3 Revenues -0.773 -0.352 0.0379 0.509 0.653 0001133311 0001495231 0000829323
4 StockholdersEquity -0.443 -0.369 0.0000374 0.871 1.00 0001559754 0001539850 0001078099
5 NetIncome -0.408 -0.328 0.0480 0.442 0.516 0001084267 0000876883 0001133311
6 ComprehensiveNetIncome -0.406 -0.325 0.0526 0.444 0.514 0001084267 0001527190 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001377630 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.665 -0.620 0.0739 0.954 1.17 0001539850 0001495231 0001078099
9 EconomicCapitalRatio -0.831 -0.785 -0.0920 0.788 1.01 0001539850 0001495231 0001078099

2016

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 23 × The stock price does not exist industry.us_generic
warning 22 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 15 × No stock price available subcommand.plot
warning 4 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Similarly named company. Duplicate? None
warning 1 × Missing logo subcommand.report

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 21,313 33,569,245 969,662,800 12,722,000,000 0001516079 0001460329 0000029989
1 AssetsNonCurrent 0 0 77,294 558,950,700 836,300,000 0000934796 0001078099 0001377630
2 IntangibleAssets 0 0 1,114,653 718,796,450 9,403,500,000 0000875355 0001491778 0000029989
3 PropertyPlantAndEquipment 0 314 1,892,916 149,157,250 674,800,000 0001516079 0000875355 0000029989
4 remainder_Assets -420,943,000 -29,600,000 4,317 112,745,850 147,113,000 0001576427 0001609139 0001490281
5 LiabilitiesCurrent 0 166,731 13,833,180 1,069,470,500 14,010,900,000 0001491778 0001078099 0000029989
6 LiabilitiesNonCurrent 0 0 0 968,448,000 1,118,000,000 0000029989 0001078099 0001377630
7 remainder_Liabilities -686,000 0 0 119,017,150 231,633,000 0001576427 0001084267 0000876883
8 CostOfGoodsAndServicesSold 0 0 293,356 106,336,300 1,786,451,000 0000029989 0001442376 0001490281
9 SellingAndMarketingExpense 0 0 1,432,301 218,227,600 362,951,000 0000029989 0001084332 0001490281
10 GeneralAndAdministrativeExpense 0 0 2,991,567 95,287,750 306,251,000 0000029989 0000875355 0000876883
11 remainder_Expenses 0 60,489 11,210,888 1,237,525,650 14,218,200,000 0001495231 0001415624 0000029989
12 remainder_Revenues 0 0 5,137,762 2,672,881,200 15,416,900,000 0000876883 0001084332 0000029989
13 remainder_NetIncome -87,371,000 -6,757,261 -11,935 357,885,000 1,287,329,000 0001490281 0001084332 0000876883
14 remainder_ComprehensiveNetIncome -438,700,000 -20,585,500 0 150,238 6,846,000 0000029989 0001495231 0001490281
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 2,855 24,565 40,947,315 1,696,977,350 23,165,400,000 0001516079 0001133311 0000029989
1 Liabilities 30,666 552,281 16,247,803 1,841,048,350 14,010,900,000 0001516079 0001538217 0000029989
2 Expenses 56,969 470,942 37,681,872 2,711,815,350 14,218,200,000 0001516079 0001538217 0000029989
3 Revenues 0 0 5,137,762 2,672,881,200 15,416,900,000 0000876883 0001084332 0000029989
4 StockholdersEquity -449,296,000 -230,405,000 2,379,771 562,883,200 9,154,500,000 0000876883 0001491778 0000029989
5 NetIncome -194,587,000 -36,583,750 -1,571,201 101,626,250 1,246,700,000 0001490281 0000875355 0000029989
6 ComprehensiveNetIncome -187,741,000 -45,228,100 -1,571,201 93,048,100 808,000,000 0001490281 0000875355 0000029989
7 BaseVar 45,245 837,026 106,938,265 4,258,105,975 33,649,050,000 0001516079 0001133311 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -4.69 -3.14 -0.0359 1.08 1.77 0001516079 0001491778 0001078099
9 EconomicCapitalRatio 0.00121 0.0433 0.739 1.61 2.07 0001516079 0001491778 0001078099

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.158 -0.146 -0.00747 0.336 0.455 0001539850 0000876883 0000875355
1 AssetsNonCurrent -0.101 -0.0921 -0.0311 0.147 0.171 0001490281 0001539850 0001576427
2 IntangibleAssets -0.196 -0.171 -0.0652 0.208 0.275 0001491778 0001375796 0001460329
3 PropertyPlantAndEquipment -0.0481 -0.0415 -0.000341 0.0394 0.0497 0001609139 0001377630 0001491778
4 remainder_Assets -0.152 -0.101 -0.0130 0.128 0.174 0001576427 0001084267 0001538217
5 LiabilitiesCurrent -0.0446 -0.0231 0.0783 0.528 0.550 0001509477 0001491778 0001115128
6 LiabilitiesNonCurrent -0.855 -0.569 0.00813 0.233 0.306 0001527190 0001491778 0001609139
7 remainder_Liabilities -0.996 -0.146 0.000948 0.0592 0.0781 0001491778 0001527190 0001609139
8 CostOfGoodsAndServicesSold -0.586 -0.564 0.0147 0.299 0.433 0001490281 0001527190 0001133311
9 SellingAndMarketingExpense -0.985 -0.386 0.00797 0.116 0.304 0001133311 0001539850 0001609139
10 GeneralAndAdministrativeExpense -0.353 -0.252 0.0275 0.172 0.427 0001495231 0001490281 0001609139
11 remainder_Expenses -0.622 -0.473 -0.000278 0.446 0.531 0001609139 0001516079 0001133311
12 remainder_Revenues -0.921 -0.379 0.0963 0.610 0.740 0001133311 0001084332 0001609139
13 remainder_NetIncome -0.181 -0.140 -0.0507 0.105 1.04 0001392694 0000029989 0001133311
14 remainder_ComprehensiveNetIncome -0.0202 -0.0143 0.0000638 0.00408 0.0115 0001576427 0001615780 0001509477
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.416 -0.338 -0.0665 0.307 0.358 0001509477 0001495231 0001460329
1 Liabilities -0.271 -0.196 0.0863 0.615 0.686 0001527190 0000934796 0001115128
2 Expenses -0.595 -0.578 -0.0352 0.234 0.404 0001495231 0001084267 0001078099
3 Revenues -0.921 -0.379 0.0963 0.610 0.740 0001133311 0001084332 0001609139
4 StockholdersEquity -0.408 -0.393 0.0299 0.880 1.06 0001615780 0001490281 0001078099
5 NetIncome -0.444 -0.295 0.0473 0.507 0.542 0001509477 0001490281 0001133311
6 ComprehensiveNetIncome -0.404 -0.294 0.0470 0.507 0.542 0001509477 0001490281 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.675 -0.633 0.0629 0.930 1.39 0001516079 0001491778 0001078099
9 EconomicCapitalRatio -0.807 -0.765 -0.0699 0.797 1.26 0001516079 0001491778 0001078099

2017

Logs

error 3 × No matching role found input.sec.calculation_linkbase.expand_agg
error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 24 × The stock price does not exist industry.us_generic
warning 22 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 12 × No stock price available subcommand.plot
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI pre-agg
warning 1 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
warning 1 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 6,041 17,024 16,445,541 1,052,277,750 14,116,000,000 0001516079 0000875355 0000029989
1 AssetsNonCurrent 0 0 519,743 703,608,250 935,500,000 0000934796 0001115128 0001377630
2 IntangibleAssets 0 0 497,619 1,050,732,750 9,705,900,000 0000875355 0001392694 0000029989
3 PropertyPlantAndEquipment 0 0 2,043,460 159,089,750 690,900,000 0001084267 0000829323 0000029989
4 remainder_Assets -494,787,000 -30,700,000 6,746 112,651,750 135,189,000 0001576427 0001084267 0001490281
5 LiabilitiesCurrent 14,151 483,017 17,669,277 1,044,031,750 15,108,900,000 0001516079 0000829323 0000029989
6 LiabilitiesNonCurrent 0 0 26,224 934,037,000 1,039,600,000 0000029989 0001392694 0001377630
7 remainder_Liabilities -2,497,000 -1,748,925 0 46,474,750 78,973,000 0001576427 0001084267 0000876883
8 CostOfGoodsAndServicesSold 0 0 23,158 114,731,386 1,510,016,000 0000029989 0001588014 0001490281
9 SellingAndMarketingExpense 0 0 0 395,850,750 464,040,000 0000029989 0001516079 0001705110
10 GeneralAndAdministrativeExpense 0 0 2,206,566 257,094,000 310,455,000 0000029989 0000875355 0000876883
11 remainder_Expenses 800 185,132 12,663,058 1,489,842,750 14,134,600,000 0001516079 0001375796 0000029989
12 remainder_Revenues 0 0 2,596,186 2,707,080,750 15,273,600,000 0000876883 0001509477 0000029989
13 remainder_NetIncome -10,688,000 -9,113,250 656 396,350,000 1,470,979,000 0001460329 0001509477 0000876883
14 remainder_ComprehensiveNetIncome -15,505,000 -9,407,134 0 54,520,750 289,200,000 0000876883 0001084267 0000029989
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 6,041 39,839 30,963,373 1,693,545,250 24,931,200,000 0001516079 0000829323 0000029989
1 Liabilities 14,151 490,763 17,883,706 1,700,054,250 15,108,900,000 0001516079 0000829323 0000029989
2 Expenses 800 307,695 47,436,007 2,664,114,250 14,134,600,000 0001516079 0001375796 0000029989
3 Revenues 0 0 2,596,186 2,707,080,750 15,273,600,000 0000876883 0001509477 0000029989
4 StockholdersEquity -116,000,000 -72,328,772 2,962,035 1,196,590,250 9,822,300,000 0001527190 0001495231 0000029989
5 NetIncome -104,527,000 -61,745,295 -708,183 218,392,250 1,192,200,000 0001705110 0001588014 0000029989
6 ComprehensiveNetIncome -99,165,000 -62,588,699 -708,183 223,180,000 1,481,400,000 0001705110 0001588014 0000029989
7 BaseVar 32,496 735,788 77,240,860 4,137,459,375 34,895,350,000 0001516079 0000829323 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -5.39 -5.11 0.0545 0.793 1.11 0001084267 0000876883 0001705110
9 EconomicCapitalRatio 0.000154 0.000372 0.793 1.41 1.63 0001084267 0000876883 0001705110

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.201 -0.151 -0.0280 0.365 0.544 0001509477 0001705110 0001375796
1 AssetsNonCurrent -0.110 -0.104 -0.0297 0.148 0.243 0001509477 0000875355 0000829323
2 IntangibleAssets -0.191 -0.138 -0.0206 0.374 0.403 0001509477 0001576427 0001705110
3 PropertyPlantAndEquipment -0.0307 -0.0228 -0.00308 0.0282 0.152 0001538217 0001495231 0001615780
4 remainder_Assets -0.311 -0.106 -0.0236 0.254 0.447 0000829323 0000934796 0001538217
5 LiabilitiesCurrent -0.0629 -0.0540 0.0639 0.508 0.536 0001615780 0001375796 0000875355
6 LiabilitiesNonCurrent -0.864 -0.698 0.00859 0.201 0.237 0001527190 0001648365 0001133311
7 remainder_Liabilities -0.227 -0.0169 0.00204 0.0516 0.110 0001460329 0001648365 0000829323
8 CostOfGoodsAndServicesSold -0.660 -0.608 0.0127 0.218 0.309 0000875355 0001527190 0001133311
9 SellingAndMarketingExpense -0.908 -0.317 0.0155 0.137 0.216 0001133311 0001648365 0000829323
10 GeneralAndAdministrativeExpense -0.488 -0.322 0.00176 0.207 0.242 0001509477 0001377630 0000829323
11 remainder_Expenses -0.451 -0.411 -0.00111 0.393 0.478 0001576427 0001516079 0000875355
12 remainder_Revenues -0.713 -0.418 -0.000752 0.627 0.713 0001133311 0001588014 0001576427
13 remainder_NetIncome -0.625 -0.0762 0.0208 0.207 0.944 0001516079 0001705110 0001133311
14 remainder_ComprehensiveNetIncome -0.0190 -0.0154 -0.00272 0.0294 0.0579 0001490281 0001609139 0001509477
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.474 -0.222 0.00104 0.334 0.394 0001509477 0001377630 0001078099
1 Liabilities -0.328 -0.216 0.0754 0.631 0.675 0001527190 0000934796 0001576427
2 Expenses -0.619 -0.534 -0.00852 0.187 0.222 0001495231 0001084267 0001375796
3 Revenues -0.713 -0.418 -0.000752 0.627 0.713 0001133311 0001588014 0001576427
4 StockholdersEquity -0.403 -0.255 0.0618 0.643 0.896 0000934796 0001495231 0001705110
5 NetIncome -0.386 -0.310 0.0926 0.576 0.679 0001516079 0001078099 0001576427
6 ComprehensiveNetIncome -0.391 -0.233 0.0847 0.566 0.682 0001516079 0001078099 0001576427
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.636 -0.636 0.156 0.772 0.992 0001084267 0000876883 0001705110
9 EconomicCapitalRatio -0.797 -0.796 -0.00415 0.612 0.832 0001084267 0000876883 0001705110

2018

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × IME and Company effects mismatched for Other Assets. IME Effects: 0.0, Company Effect: 0.00589 subcommand.report
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 27 × The stock price does not exist industry.us_generic
warning 22 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 12 × No stock price available subcommand.plot
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Missing logo subcommand.report
warning 2 × Ignoring company because Assets is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × Similarly named company. Duplicate? None
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
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 8,207 51,082 7,218,724 972,717,800 13,726,900,000 0001703625 0000829323 0000029989
1 AssetsNonCurrent 0 0 143 701,393,600 910,900,000 0000934796 0001495231 0001377630
2 IntangibleAssets 0 0 23,155 1,042,890,400 9,767,100,000 0000875355 0001703625 0000029989
3 PropertyPlantAndEquipment 0 0 275,341 167,654,600 694,400,000 0001084332 0001495231 0000029989
4 remainder_Assets -608,930,000 -33,600,000 9.80 90,425,800 120,900,000 0001576427 0001648365 0000029989
5 LiabilitiesCurrent 26,063 61,628 11,960,184 871,318,800 15,270,200,000 0001703625 0000934796 0000029989
6 LiabilitiesNonCurrent 0 0 16.8 974,977,200 1,120,500,000 0000029989 0001133311 0001377630
7 remainder_Liabilities -10,770,000 -1,403,899 0 43,510,000 56,096,000 0001576427 0001377630 0000876883
8 CostOfGoodsAndServicesSold 0 0 1,046,758 1,327,058,400 12,437,300,000 0000934796 0001084267 0000029989
9 SellingAndMarketingExpense 0 0 79.2 386,525,000 541,469,000 0000029989 0001516079 0001705110
10 GeneralAndAdministrativeExpense 0 0 482,398 248,140,800 349,056,000 0000029989 0001343465 0000876883
11 remainder_Expenses 0 362 12,621,382 664,781,200 1,478,500,000 0001588014 0001133311 0000029989
12 remainder_Revenues 0 0 20,136,477 2,502,173,200 15,290,200,000 0000934796 0001495231 0000029989
13 remainder_NetIncome -101,000,000 -76,224,600 -221,680 19,421,246 66,100,000 0001377630 0001588014 0000029989
14 remainder_ComprehensiveNetIncome -379,600,000 -15,159,000 0 0 3,332 0000029989 0001703625 0001648365
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 29,493 60,870 23,120,830 1,741,673,000 24,617,000,000 0001703625 0001538217 0000029989
1 Liabilities 26,063 143,292 11,960,184 1,588,008,800 15,270,200,000 0001703625 0000934796 0000029989
2 Expenses 906 177,951 25,526,607 2,428,790,400 13,915,800,000 0001516079 0001495231 0000029989
3 Revenues 0 0 20,136,477 2,502,173,200 15,290,200,000 0000934796 0001495231 0000029989
4 StockholdersEquity -195,421,000 -120,040,000 1,429,339 1,351,230,400 9,346,800,000 0000876883 0001648365 0000029989
5 NetIncome -111,948,000 -89,387,635 -482,051 97,391,600 1,440,500,000 0000876883 0001516079 0000029989
6 ComprehensiveNetIncome -117,059,000 -89,387,635 -773,926 90,077,600 1,060,900,000 0000876883 0001648365 0000029989
7 BaseVar 62,706 545,154 43,985,678 3,804,976,700 34,769,450,000 0001703625 0001084267 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -5.69 -2.87 -0.00422 1.18 1.32 0001084267 0001495231 0001705110
9 EconomicCapitalRatio 0.0000589 0.0803 0.739 1.67 1.77 0001084267 0001495231 0001705110

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.324 -0.240 -0.0257 0.278 1.05 0000829323 0001078099 0001648365
1 AssetsNonCurrent -0.0887 -0.0845 -0.0358 0.164 0.195 0001133311 0001460329 0001377630
2 IntangibleAssets -0.175 -0.113 -0.0519 0.216 0.266 0001133311 0001725516 0001703625
3 PropertyPlantAndEquipment -0.0468 -0.0405 -0.0140 0.0974 0.370 0001495231 0001115128 0001703625
4 remainder_Assets -0.383 -0.198 -0.00639 0.0933 0.287 0000829323 0001725516 0001609139
5 LiabilitiesCurrent -0.204 -0.0679 0.114 0.487 0.534 0001375796 0001084332 0000875355
6 LiabilitiesNonCurrent -0.896 -0.530 0.00649 0.185 0.239 0001527190 0001490281 0001133311
7 remainder_Liabilities -0.167 -0.00484 0.00399 0.109 0.120 0001460329 0001392694 0001133311
8 CostOfGoodsAndServicesSold -0.936 -0.589 0.0160 0.194 0.249 0001588014 0001516079 0001460329
9 SellingAndMarketingExpense -1.00 -0.252 0.0120 0.0885 0.117 0001133311 0001588014 0000829323
10 GeneralAndAdministrativeExpense -0.631 -0.418 0.0148 0.195 0.218 0001703625 0001516079 0001538217
11 remainder_Expenses -0.908 -0.456 0.0218 0.286 0.436 0000829323 0001516079 0001133311
12 remainder_Revenues -0.395 -0.208 0.0128 0.668 0.743 0001648365 0001495231 0000875355
13 remainder_NetIncome -0.580 -0.335 0.0533 0.648 0.977 0001084267 0001703625 0001538217
14 remainder_ComprehensiveNetIncome -0.0142 -0.0102 0.000354 0.00345 0.00474 0000029989 0000934796 0001648365
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.376 -0.337 -0.00214 0.282 0.597 0001588014 0001703625 0001648365
1 Liabilities -0.324 -0.122 0.0876 0.615 0.681 0001527190 0001588014 0000875355
2 Expenses -0.868 -0.682 -0.0176 0.165 0.210 0000829323 0001725516 0001375796
3 Revenues -0.395 -0.208 0.0128 0.668 0.743 0001648365 0001495231 0000875355
4 StockholdersEquity -0.413 -0.390 0.0461 0.733 0.989 0001539850 0001703625 0001705110
5 NetIncome -0.848 -0.409 0.124 0.791 0.936 0001084267 0001588014 0001725516
6 ComprehensiveNetIncome -0.844 -0.406 0.125 0.794 0.937 0001084267 0001588014 0001725516
7 BaseVar nan nan nan nan nan 0000029989 0001460329 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.694 -0.614 0.0454 0.976 1.07 0001084267 0001495231 0001705110
9 EconomicCapitalRatio -0.848 -0.767 -0.108 0.822 0.917 0001084267 0001495231 0001705110

2019

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 27 × The stock price does not exist industry.us_generic
warning 23 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 10 × No stock price available subcommand.plot
warning 3 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 3 × Ignoring company because Assets is zero pre-agg
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI 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 19.0 55,726 12,044,589 6,439,628,300 14,584,700,000 0001696195 0001495231 0000029989
1 AssetsNonCurrent 0 0 350,205 768,946,100 875,700,000 0000934796 0001648365 0001377630
2 IntangibleAssets 0 0 8,888,710 5,609,248,400 11,177,000,000 0000934796 0001133311 0000029989
3 PropertyPlantAndEquipment 0 0 649,396 522,628,300 778,100,000 0001539850 0001343465 0000051644
4 remainder_Assets -740,191,000 -37,073,800 9.10 96,534,300 184,966,000 0001576427 0001538217 0001490281
5 LiabilitiesCurrent 5,022 302,436 12,761,587 6,840,744,100 15,980,900,000 0001696195 0000934796 0000029989
6 LiabilitiesNonCurrent 0 0 700,398 1,130,703,100 5,341,200,000 0000029989 0000875355 0000051644
7 remainder_Liabilities -9,272,000 -1,413,440 0 27,067,300 44,098,000 0001576427 0001375796 0001460329
8 CostOfGoodsAndServicesSold 0 0 8,530,109 6,504,854,100 12,194,000,000 0000934796 0001495231 0000029989
9 SellingAndMarketingExpense 0 0 104,928 364,640,400 733,223,000 0000029989 0001725516 0001705110
10 GeneralAndAdministrativeExpense 0 0 848,395 342,274,600 1,564,100,000 0000029989 0001752372 0000051644
11 remainder_Expenses -953,100,000 29,322 13,102,269 664,301,900 1,386,100,000 0000051644 0001375796 0000029989
12 remainder_Revenues 0 3,105 25,835,975 7,833,364,800 14,953,700,000 0000934796 0001392694 0000029989
13 remainder_NetIncome -207,300,000 -96,432,300 0 6,123,900 62,300,000 0000051644 0001725516 0000029989
14 remainder_ComprehensiveNetIncome -43,600,000 -20,486,300 0 22,087 762,000 0000029989 0001696195 0001133311
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 19.0 118,110 23,961,902 13,002,813,300 26,783,400,000 0001696195 0001495231 0000029989
1 Liabilities 5,022 334,264 14,694,993 10,927,692,400 15,980,900,000 0001696195 0001392694 0000029989
2 Expenses 47,591 393,216 33,603,056 7,192,033,400 13,580,100,000 0001696195 0001392694 0000029989
3 Revenues 0 3,105 25,835,975 7,833,364,800 14,953,700,000 0000934796 0001392694 0000029989
4 StockholdersEquity -142,416,000 -88,632,832 11,795,851 2,605,207,100 10,802,500,000 0000876883 0000875355 0000029989
5 NetIncome -73,700,000 -41,936,503 -893,587 500,520,700 1,435,900,000 0001377630 0000934796 0000029989
6 ComprehensiveNetIncome -73,700,000 -41,958,103 -1,051,281 492,875,900 1,392,300,000 0001377630 0001648365 0000029989
7 BaseVar 31,491 674,710 44,099,833 19,386,275,200 35,702,000,000 0001696195 0001084267 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -16.3 -2.53 0.153 0.944 1.28 0001696195 0001375796 0001705110
9 EconomicCapitalRatio 0.000000000000000000000000000000000142 0.143 0.887 1.51 1.74 0001696195 0001375796 0001705110

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.257 -0.153 -0.00704 0.276 0.354 0000829323 0001705110 0000875355
1 AssetsNonCurrent -0.0711 -0.0611 -0.0261 0.155 0.224 0000829323 0001460329 0001576427
2 IntangibleAssets -0.197 -0.171 -0.0180 0.172 0.556 0000875355 0001588014 0001538217
3 PropertyPlantAndEquipment -0.0315 -0.0249 -0.00724 0.0235 0.176 0001725516 0001078099 0001615780
4 remainder_Assets -0.152 -0.103 -0.0111 0.0643 0.161 0001576427 0001538217 0001343465
5 LiabilitiesCurrent -0.221 -0.0934 0.0309 0.482 0.770 0001375796 0000051644 0001588014
6 LiabilitiesNonCurrent -0.736 -0.297 0.00225 0.195 0.212 0001377630 0001725516 0001588014
7 remainder_Liabilities -0.231 -0.0898 0.00697 0.116 0.158 0001343465 0001538217 0000829323
8 CostOfGoodsAndServicesSold -0.724 -0.384 0.000508 0.270 0.606 0000875355 0001084267 0001588014
9 SellingAndMarketingExpense -0.784 -0.309 0.00607 0.109 0.207 0001133311 0000876883 0000829323
10 GeneralAndAdministrativeExpense -0.529 -0.217 0.0200 0.187 0.214 0001588014 0001460329 0000829323
11 remainder_Expenses -0.794 -0.552 0.0365 0.302 0.409 0000829323 0000876883 0001133311
12 remainder_Revenues -0.192 -0.168 0.0110 0.577 0.938 0001375796 0000051644 0001588014
13 remainder_NetIncome -0.623 -0.00509 0.0282 0.151 0.207 0001084267 0000051644 0000829323
14 remainder_ComprehensiveNetIncome -0.00593 -0.00371 -0.000263 0.00255 0.0135 0001576427 0001705110 0001133311
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.279 -0.221 0.00244 0.176 0.237 0000829323 0000876883 0000029989
1 Liabilities -0.179 -0.146 0.0415 0.609 0.778 0001375796 0001538217 0001588014
2 Expenses -0.563 -0.526 0.0130 0.176 0.267 0000829323 0001084267 0000029989
3 Revenues -0.192 -0.168 0.0110 0.577 0.938 0001375796 0000051644 0001588014
4 StockholdersEquity -0.409 -0.303 0.149 0.676 0.943 0000934796 0001375796 0001705110
5 NetIncome -0.675 -0.334 0.0505 0.512 0.799 0001084267 0001495231 0001588014
6 ComprehensiveNetIncome -0.675 -0.334 0.0501 0.507 0.799 0001084267 0001495231 0001588014
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.617 -0.474 0.270 0.897 1.12 0001696195 0001375796 0001705110
9 EconomicCapitalRatio -0.850 -0.708 0.0370 0.663 0.888 0001696195 0001375796 0001705110

2020

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 29 × The stock price does not exist industry.us_generic
warning 24 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 6 × Ignoring company because Assets is zero pre-agg
warning 5 × No stock price available subcommand.plot
warning 4 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI 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 4,124 44,777 13,795,068 6,154,464,000 15,590,100,000 0001725516 0000875355 0000029989
1 AssetsNonCurrent 0 0 21,000 745,993,600 788,860,000 0000934796 0000829323 0001576427
2 IntangibleAssets 0 0 4,524,627 5,739,672,000 11,131,600,000 0000934796 0001495231 0000029989
3 PropertyPlantAndEquipment 0 0 239,284 426,922,000 690,300,000 0001334978 0001392694 0000051644
4 remainder_Assets -709,066,000 -16,543,328 168,985 105,051,600 199,877,000 0001576427 0001615780 0001334978
5 LiabilitiesCurrent 125,080 307,459 12,470,483 6,326,890,000 15,525,100,000 0001725516 0001495231 0000029989
6 LiabilitiesNonCurrent 0 0 1,163,575 3,724,116,800 7,091,400,000 0000029989 0000829323 0001334978
7 remainder_Liabilities -5,297,000 -347,600 0 25,973,000 33,283,000 0001576427 0001334978 0001460329
8 CostOfGoodsAndServicesSold 0 0 4,370,835 5,124,668,400 10,989,200,000 0000934796 0001084267 0000029989
9 SellingAndMarketingExpense 0 0 0 303,373,400 762,590,000 0000029989 0001752372 0001705110
10 GeneralAndAdministrativeExpense 0 0 634,975 361,083,600 1,367,900,000 0000029989 0001346655 0000051644
11 remainder_Expenses -596,700,000 -61,740 5,970,780 1,028,901,600 2,502,889,000 0000051644 0001495231 0001334978
12 remainder_Revenues 0 2,038 18,403,224 6,265,646,800 13,171,100,000 0000934796 0001495231 0000029989
13 remainder_NetIncome -226,200,000 -33,565,400 0 39,033,000 157,800,000 0000051644 0001460329 0001377630
14 remainder_ComprehensiveNetIncome -91,700,000 -28,540,200 0 28,528,800 56,132,000 0000029989 0001725516 0001576427
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 4,124 213,467 35,192,299 13,127,729,200 27,647,200,000 0001725516 0000829323 0000029989
1 Liabilities 125,080 349,779 15,109,967 12,418,570,000 15,525,100,000 0001725516 0001343465 0000029989
2 Expenses 153,429 512,357 28,630,809 6,089,515,600 12,175,800,000 0001725516 0001495231 0000029989
3 Revenues 0 2,038 18,403,224 6,265,646,800 13,171,100,000 0000934796 0001495231 0000029989
4 StockholdersEquity -2,782,602,000 -336,503,800 1,555,248 2,676,001,600 12,122,100,000 0001334978 0001588014 0000029989
5 NetIncome -600,226,000 -254,586,800 -1,194,486 272,208,400 1,020,800,000 0001334978 0001648365 0000029989
6 ComprehensiveNetIncome -598,954,000 -283,127,000 -1,050,753 300,228,400 929,100,000 0001334978 0001648365 0000029989
7 BaseVar 183,222 1,013,511 52,367,377 18,998,864,400 34,318,200,000 0001725516 0001495231 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -2.54 -1.57 -0.0216 0.832 1.28 0001725516 0001346655 0001705110
9 EconomicCapitalRatio 0.113 0.361 0.739 1.44 1.74 0001725516 0001346655 0001705110

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.342 -0.229 -0.0127 0.208 0.472 0001392694 0001377630 0001495231
1 AssetsNonCurrent -0.111 -0.0631 -0.0237 0.198 0.216 0001392694 0001460329 0001377630
2 IntangibleAssets -0.215 -0.182 -0.0160 0.185 0.207 0000875355 0001377630 0001556739
3 PropertyPlantAndEquipment -0.0799 -0.0496 -0.00613 0.0312 0.238 0001392694 0001334978 0001588014
4 remainder_Assets -0.137 -0.122 -0.0254 0.238 0.703 0001576427 0001752372 0001703625
5 LiabilitiesCurrent -1.11 -0.278 0.0202 0.514 0.559 0000934796 0000876883 0001588014
6 LiabilitiesNonCurrent -0.661 -0.453 0.00523 0.242 0.349 0001377630 0001648365 0001588014
7 remainder_Liabilities -0.0960 -0.0737 0.00375 0.0768 0.0943 0001343465 0001334978 0001588014
8 CostOfGoodsAndServicesSold -1.60 -0.610 0.0124 0.254 0.548 0001392694 0001133311 0001588014
9 SellingAndMarketingExpense -0.337 -0.139 0.00995 0.0857 0.100 0001705110 0000934796 0000829323
10 GeneralAndAdministrativeExpense -0.732 -0.539 0.0176 0.175 0.305 0001088638 0001343465 0000829323
11 remainder_Expenses -0.917 -0.607 0.0394 0.243 0.536 0000829323 0000934796 0001088638
12 remainder_Revenues -0.478 -0.375 0.00983 0.565 0.681 0001346655 0000876883 0001588014
13 remainder_NetIncome -0.191 -0.132 -0.0535 0.103 0.387 0001084267 0001705110 0000934796
14 remainder_ComprehensiveNetIncome -0.0154 -0.00485 -0.00204 0.0175 0.0489 0001752372 0001705110 0001648365
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.539 -0.416 -0.00521 0.296 0.382 0001392694 0001490281 0001495231
1 Liabilities -0.872 -0.0937 0.00953 0.582 0.645 0000934796 0001490281 0001705110
2 Expenses -0.899 -0.556 -0.00598 0.205 0.224 0001392694 0001490281 0001539850
3 Revenues -0.478 -0.375 0.00983 0.565 0.681 0001346655 0000876883 0001588014
4 StockholdersEquity -0.996 -0.381 0.0575 0.614 0.970 0000934796 0001538217 0001705110
5 NetIncome -0.769 -0.351 0.0130 0.380 0.414 0001703625 0001334978 0000934796
6 ComprehensiveNetIncome -0.771 -0.352 0.0118 0.376 0.413 0001703625 0000876883 0000934796
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.620 -0.372 0.00555 0.703 1.00 0001725516 0001346655 0001705110
9 EconomicCapitalRatio -0.753 -0.505 -0.127 0.570 0.870 0001725516 0001346655 0001705110

2021

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 29 × The stock price does not exist industry.us_generic
warning 24 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 6 × No stock price available subcommand.plot
warning 6 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 5 × Ignoring company because Assets is zero pre-agg
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI pre-agg
warning 1 × No LiabilitiesAndStockholdersEquity node found input.sec.calculation_linkbase.edgar_model_mapping
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 129,878 25,715,682 7,049,972,156 15,909,500,000 0001579717 0001463833 0000029989
1 AssetsNonCurrent 0 0 35,861 712,950,650 800,897,041 0000875355 0001538217 0001648365
2 IntangibleAssets 0 0 2,957,876 5,480,208,700 11,239,500,000 0001343465 0001495231 0000029989
3 PropertyPlantAndEquipment 0 0 274,149 472,382,952 992,100,000 0001334978 0001463833 0000029989
4 remainder_Assets -672,544,000 -133,573,171 62,480 167,691,250 230,444,000 0001576427 0001539850 0001490281
5 LiabilitiesCurrent 94,934 126,966 13,363,663 6,636,385,350 16,226,200,000 0001840102 0001495231 0000029989
6 LiabilitiesNonCurrent 0 0 349,113 3,694,085,100 7,055,802,000 0000029989 0000829323 0001334978
7 remainder_Liabilities -10,798,000 -2,656,118 0 22,764,645 144,423,000 0001556739 0001133311 0000876883
8 CostOfGoodsAndServicesSold 0 0 12,933,765 5,213,338,000 11,499,700,000 0001334978 0001495231 0000029989
9 SellingAndMarketingExpense 0 0 0 343,324,350 883,643,000 0000029989 0000876883 0001705110
10 GeneralAndAdministrativeExpense 0 0 1,079,841 415,839,450 1,279,600,000 0000029989 0001840102 0000051644
11 remainder_Expenses -611,100,000 -290 10,323,005 959,899,078 2,573,870,000 0000051644 0001392694 0001334978
12 remainder_Revenues 0 7,121 41,796,838 6,646,790,750 14,289,400,000 0001579717 0001392694 0000029989
13 remainder_NetIncome -211,600,000 -73,773,450 10,142 28,095,000 92,680,000 0000051644 0001703625 0001490281
14 remainder_ComprehensiveNetIncome -138,300,000 -50,446,382 0 173,300 6,875,000 0000029989 0001538217 0001334978
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 28,934 260,865 43,837,468 13,334,769,750 28,421,800,000 0001579717 0000829323 0000029989
1 Liabilities 105,920 420,395 15,959,470 12,746,406,250 16,304,400,000 0001703625 0001495231 0000051644
2 Expenses 57,664 443,908 49,127,814 6,139,206,500 12,816,600,000 0001579717 0001392694 0000029989
3 Revenues 0 7,121 41,796,838 6,646,790,750 14,289,400,000 0001579717 0001392694 0000029989
4 StockholdersEquity -3,193,970,000 -212,222,540 3,373,200 2,762,774,400 12,195,600,000 0001334978 0001392694 0000029989
5 NetIncome -433,120,000 -155,323,697 -1,449,388 596,981,150 1,507,600,000 0001334978 0001703625 0000029989
6 ComprehensiveNetIncome -426,245,000 -179,104,025 -1,449,388 566,175,700 1,369,300,000 0001334978 0001703625 0000029989
7 BaseVar 332,496 1,126,718 83,926,949 19,543,809,975 35,963,550,000 0001579717 0001495231 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -4.70 -2.36 0.234 1.24 2.99 0001084267 0001490281 0001579717
9 EconomicCapitalRatio 0.00117 0.185 0.961 1.71 3.04 0001084267 0001490281 0001579717

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.184 -0.124 -0.0112 0.375 0.504 0001343465 0001084267 0001495231
1 AssetsNonCurrent -0.0780 -0.0633 -0.0393 0.183 0.598 0001133311 0000029989 0001703625
2 IntangibleAssets -0.181 -0.135 -0.0140 0.238 0.278 0000875355 0001752372 0001556739
3 PropertyPlantAndEquipment -0.0222 -0.0186 -0.000567 0.0471 0.107 0001133311 0001115128 0001588014
4 remainder_Assets -0.204 -0.0993 -0.00381 0.0415 0.127 0001579717 0001088638 0001490281
5 LiabilitiesCurrent -2.02 -1.05 0.0253 0.491 0.534 0001343465 0001377630 0001088638
6 LiabilitiesNonCurrent -0.642 -0.403 0.0219 0.286 0.650 0001377630 0001538217 0001579717
7 remainder_Liabilities -0.111 -0.00268 0.0291 0.0789 0.175 0001460329 0000051644 0001579717
8 CostOfGoodsAndServicesSold -0.963 -0.775 0.0194 0.259 0.594 0001392694 0001133311 0001579717
9 SellingAndMarketingExpense -0.679 -0.314 0.0199 0.139 0.198 0000829323 0001615780 0001579717
10 GeneralAndAdministrativeExpense -0.728 -0.231 0.0210 0.194 0.244 0001088638 0001334978 0000829323
11 remainder_Expenses -0.726 -0.284 0.0415 0.347 0.394 0001703625 0000875355 0001588014
12 remainder_Revenues -1.35 -0.498 0.00423 0.601 0.911 0001579717 0000029989 0001588014
13 remainder_NetIncome -0.636 -0.205 -0.0393 0.582 2.67 0001538217 0001133311 0001579717
14 remainder_ComprehensiveNetIncome -0.0264 -0.0104 0.00101 0.00560 0.00602 0001576427 0001538217 0001463833
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.290 -0.281 0.0160 0.295 0.542 0001840102 0001133311 0001579717
1 Liabilities -1.09 -0.214 0.0259 0.686 0.784 0001343465 0001615780 0001588014
2 Expenses -0.680 -0.509 0.00477 0.319 0.977 0000875355 0001752372 0001579717
3 Revenues -1.35 -0.498 0.00423 0.601 0.911 0001579717 0000029989 0001588014
4 StockholdersEquity -1.23 -0.720 0.0946 0.696 0.811 0001579717 0001648365 0001705110
5 NetIncome -0.850 -0.696 0.0542 0.666 2.61 0001703625 0001752372 0001579717
6 ComprehensiveNetIncome -0.848 -0.692 0.0526 0.668 2.61 0001703625 0001752372 0001579717
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.738 -0.555 0.222 0.971 2.31 0001084267 0001490281 0001579717
9 EconomicCapitalRatio -1.03 -0.845 -0.0678 0.681 2.02 0001084267 0001490281 0001579717

2022

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × IME and Company effects mismatched for Other Liabilities. IME Effects: 0.0, Company Effect: 0.00554 subcommand.report
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 29 × The stock price does not exist industry.us_generic
warning 24 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 7 × No stock price available subcommand.plot
warning 7 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 4 × Ignoring company because Assets is zero pre-agg
warning 2 × Missing logo subcommand.report
warning 1 × equityII differs from equityI 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 120,765 25,523,470 7,152,728,600 14,613,000,000 0001696195 0001392694 0000029989
1 AssetsNonCurrent 0 0 27,146 698,820,000 1,087,898,000 0000875355 0001463833 0001576427
2 IntangibleAssets 0 0 4,560,617 5,606,848,200 11,212,700,000 0001343465 0001392694 0000029989
3 PropertyPlantAndEquipment 0 0 691,184 468,159,250 900,100,000 0001334978 0001463833 0000029989
4 remainder_Assets -924,506,000 -8,513,925 65,484 141,130,850 1,205,418,000 0001576427 0001539850 0001334978
5 LiabilitiesCurrent 0 544,120 14,529,217 6,975,548,850 15,052,800,000 0001696195 0001495231 0000029989
6 LiabilitiesNonCurrent 0 0 1,015,762 3,868,362,600 6,983,609,000 0000029989 0001588014 0001334978
7 remainder_Liabilities -3,463,000 -370,900 0 23,486,100 71,140,000 0001576427 0001334978 0000876883
8 CostOfGoodsAndServicesSold 0 0 6,909,436 6,489,766,600 11,607,900,000 0000875355 0001133311 0000029989
9 SellingAndMarketingExpense 0 0 0 372,548,600 913,022,000 0000029989 0000876883 0001705110
10 GeneralAndAdministrativeExpense 0 0 1,254,060 556,971,900 1,346,400,000 0000029989 0001588014 0000051644
11 remainder_Expenses -564,500,000 0 5,632,166 1,083,981,300 2,538,057,000 0000051644 0001539850 0001334978
12 remainder_Revenues 0 37,274 55,927,127 8,043,797,200 14,289,100,000 0001615780 0001133311 0000029989
13 remainder_NetIncome -124,379,000 -82,467,750 -25,135 16,965,750 75,900,000 0000876883 0001460329 0000029989
14 remainder_ComprehensiveNetIncome -272,900,000 -72,853,600 0 3,006,224 13,545,000 0000029989 0001539850 0001334978
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 177,390 430,530 38,388,597 14,029,353,850 27,002,500,000 0001343465 0001539850 0000029989
1 Liabilities 43,902 1,280,514 14,612,791 12,706,405,950 15,100,700,000 0001696195 0001495231 0000051644
2 Expenses 52,857 409,827 56,572,279 7,300,569,950 12,961,200,000 0001696195 0001133311 0000029989
3 Revenues 0 37,274 55,927,127 8,043,797,200 14,289,100,000 0001615780 0001133311 0000029989
4 StockholdersEquity -3,262,806,000 -303,818,214 8,854,519 3,002,892,900 11,949,700,000 0001334978 0001490281 0000029989
5 NetIncome -234,380,000 -142,878,700 -650,088 640,486,800 1,403,800,000 0001490281 0001392694 0000029989
6 ComprehensiveNetIncome -229,854,000 -142,878,700 -934,555 582,816,900 1,130,900,000 0001490281 0000934796 0000029989
7 BaseVar 330,212 1,998,522 101,197,674 21,090,467,575 34,827,200,000 0001696195 0000829323 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -5.71 -2.55 0.208 1.13 1.44 0001840102 0000876883 0000875355
9 EconomicCapitalRatio 0.0000554 0.154 0.937 1.64 1.84 0001840102 0000876883 0000875355

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.235 -0.182 -0.0184 0.183 0.353 0001084267 0001615780 0001346655
1 AssetsNonCurrent -0.109 -0.0759 -0.0173 0.164 0.356 0001392694 0001615780 0001576427
2 IntangibleAssets -0.325 -0.142 -0.0113 0.189 0.443 0001392694 0000875355 0001539850
3 PropertyPlantAndEquipment -0.0840 -0.0402 -0.00824 0.0963 0.531 0001392694 0000051644 0001588014
4 remainder_Assets -0.224 -0.204 -0.0441 0.108 1.36 0001576427 0001556739 0001696195
5 LiabilitiesCurrent -0.116 -0.1000 0.101 0.524 0.589 0001377630 0000875355 0001463833
6 LiabilitiesNonCurrent -0.495 -0.243 0.00911 0.239 0.262 0001334978 0001377630 0001705110
7 remainder_Liabilities -0.121 -0.0120 0.0203 0.0538 0.0622 0001696195 0000051644 0001392694
8 CostOfGoodsAndServicesSold -1.86 -0.612 -0.00329 0.176 0.222 0001392694 0001840102 0000875355
9 SellingAndMarketingExpense -0.931 -0.410 0.0199 0.117 0.127 0000829323 0001615780 0001463833
10 GeneralAndAdministrativeExpense -0.684 -0.323 0.0380 0.205 0.345 0001084267 0001334978 0001463833
11 remainder_Expenses -0.569 -0.302 0.0317 0.217 0.237 0001463833 0001576427 0001346655
12 remainder_Revenues -0.450 -0.230 0.0317 0.578 0.753 0000875355 0000029989 0001463833
13 remainder_NetIncome -0.117 -0.0887 -0.0141 0.0436 0.746 0001725516 0001556739 0000875355
14 remainder_ComprehensiveNetIncome -0.0243 -0.0152 -0.00101 0.000421 0.0325 0001576427 0001725516 0001752372
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.547 -0.420 -0.0161 0.259 0.466 0001392694 0001490281 0001696195
1 Liabilities -0.128 -0.0859 0.106 0.665 0.785 0001615780 0001460329 0001463833
2 Expenses -1.01 -0.967 0.0115 0.268 0.336 0001392694 0001133311 0000875355
3 Revenues -0.450 -0.230 0.0317 0.578 0.753 0000875355 0000029989 0001463833
4 StockholdersEquity -0.383 -0.356 0.127 0.809 0.924 0000934796 0001725516 0001696195
5 NetIncome -0.642 -0.329 0.0729 0.295 0.631 0001084267 0001495231 0000875355
6 ComprehensiveNetIncome -0.643 -0.318 0.0666 0.291 0.630 0001084267 0001495231 0000875355
7 BaseVar nan nan nan nan nan 0000029989 0001377630 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.730 -0.576 0.207 0.910 1.11 0001840102 0000876883 0000875355
9 EconomicCapitalRatio -0.944 -0.790 -0.00624 0.696 0.898 0001840102 0000876883 0000875355

2023

Logs

error 2 × Negative Expenses, ignoring company. pre-agg
error 1 × No matching role found input.sec.calculation_linkbase.expand_agg
error 1 × Assets != LiabilitiesAndStockholdersEquity, ignoring company. pre-agg
warning 29 × The stock price does not exist industry.us_generic
warning 25 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 6 × Large missing amount for aggregate "Expenses" added to remainder. industry.us_generic
warning 4 × Missing logo subcommand.report
warning 4 × Ignoring company because Assets is zero pre-agg
warning 1 × equityII differs from equityI pre-agg
warning 1 × No stock price available subcommand.plot
warning 1 × Large missing amount for aggregate "Liabilities" added to remainder. industry.us_generic
warning 1 × Expenses in unusual place in relation to revenue input.sec.calculation_linkbase.edgar_model_mapping

Diagrams

Calculation Linkbase Overview

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

Absolute xval/yval quantiles

  xvar min 5% median 95% max min_company median_company max_company
0 AssetsCurrent 0 359,771 41,262,213 9,510,724,300 15,384,200,000 0001696195 0001872525 0000029989
1 AssetsNonCurrent 0 0 37,548 427,470,000 1,079,357,000 0001084267 0000829323 0001576427
2 IntangibleAssets 0 0 8,231,975 6,324,731,950 11,495,600,000 0001088638 0001872525 0000029989
3 PropertyPlantAndEquipment 0 0 584,530 560,169,100 874,900,000 0001334978 0001460329 0000029989
4 remainder_Assets -944,066,000 -15,079,270 561,388 247,477,450 1,571,218,000 0001576427 0000829323 0001334978
5 LiabilitiesCurrent 0 785,332 25,469,142 8,993,490,700 16,246,000,000 0001696195 0001133311 0000029989
6 LiabilitiesNonCurrent 0 0 838,240 4,379,061,000 7,058,009,000 0000029989 0000829323 0001334978
7 remainder_Liabilities -1,083,000 -82,453 0 23,283,300 34,105,000 0001576427 0001088638 0000876883
8 CostOfGoodsAndServicesSold 0 0 16,302,304 7,957,011,100 11,982,700,000 0000875355 0001495231 0000029989
9 SellingAndMarketingExpense 0 0 0 390,190,900 765,205,000 0000029989 0001088638 0001705110
10 GeneralAndAdministrativeExpense 0 0 6,653,609 615,970,850 1,342,500,000 0000029989 0000829323 0000051644
11 remainder_Expenses -719,700,000 4,717 24,099,893 1,209,260,250 2,282,698,000 0000051644 0001847064 0001334978
12 remainder_Revenues 0 24,959 80,205,177 9,634,981,550 14,692,200,000 0000875355 0001133311 0000029989
13 remainder_NetIncome -153,258,000 -69,780,400 10,568 96,339,450 732,500,000 0001334978 0001088638 0001377630
14 remainder_ComprehensiveNetIncome -11,065,000 0 0 26,405,000 105,739,000 0001490281 0000875355 0001334978
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 319,122 766,064 70,554,491 17,085,576,250 28,044,600,000 0001752372 0001495231 0000029989
1 Liabilities 152,026 818,683 34,331,730 14,164,002,700 16,246,000,000 0001696195 0001133311 0000029989
2 Expenses 121,776 1,249,114 97,553,682 8,614,796,050 13,330,900,000 0001696195 0001539850 0000029989
3 Revenues 0 24,959 80,205,177 9,634,981,550 14,692,200,000 0000875355 0001133311 0000029989
4 StockholdersEquity -3,450,743,000 -34,734,968 21,347,645 3,678,819,000 11,798,600,000 0001334978 0001539850 0000029989
5 NetIncome -308,816,000 -177,414,650 -513,017 1,044,930,000 1,473,200,000 0001334978 0001346655 0000029989
6 ComprehensiveNetIncome -203,077,000 -176,622,300 -488,290 1,068,560,000 1,491,700,000 0001334978 0001346655 0000029989
7 BaseVar 411,958 2,730,392 142,991,683 24,767,479,600 36,222,050,000 0001696195 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -2.26 -1.72 0.318 1.49 2.77 0001847064 0001133311 0001377630
9 EconomicCapitalRatio 0.168 0.312 1.04 1.88 2.85 0001847064 0001133311 0001377630

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.325 -0.195 -0.0163 0.238 0.965 0000829323 0001490281 0000875355
1 AssetsNonCurrent -1.42 -0.0937 -0.0183 0.0424 0.306 0001377630 0001696195 0001576427
2 IntangibleAssets -0.167 -0.0932 0.00204 0.166 0.204 0001346655 0001490281 0000876883
3 PropertyPlantAndEquipment -0.0354 -0.0294 -0.00864 0.0117 0.560 0001346655 0001539850 0001588014
4 remainder_Assets -0.203 -0.171 -0.0293 0.230 1.06 0001576427 0001088638 0001696195
5 LiabilitiesCurrent -0.311 -0.226 0.0342 0.601 0.661 0000029989 0001460329 0001377630
6 LiabilitiesNonCurrent -0.580 -0.243 0.0451 0.203 0.376 0001334978 0001133311 0001392694
7 remainder_Liabilities -0.378 -0.0163 0.0361 0.126 0.147 0001696195 0000029989 0001392694
8 CostOfGoodsAndServicesSold -2.16 -0.796 -0.00453 0.284 0.447 0001392694 0001556739 0001377630
9 SellingAndMarketingExpense -0.442 -0.358 0.0449 0.127 0.217 0001133311 0000875355 0001392694
10 GeneralAndAdministrativeExpense -0.367 -0.168 0.0325 0.182 0.499 0001084267 0000876883 0001392694
11 remainder_Expenses -1.46 -0.353 0.0542 0.348 0.406 0000829323 0001084267 0001872525
12 remainder_Revenues -0.606 -0.400 0.00557 0.553 1.37 0001377630 0000876883 0001392694
13 remainder_NetIncome -0.152 -0.125 -0.0300 0.00999 1.46 0001084267 0001696195 0001377630
14 remainder_ComprehensiveNetIncome -0.00542 -0.00332 -0.00129 0.00540 0.00749 0001392694 0000029989 0001752372
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.456 -0.410 -0.0151 0.443 0.607 0000829323 0001334978 0000875355
1 Liabilities -0.296 -0.273 0.00557 0.713 0.963 0001334978 0001576427 0001392694
2 Expenses -0.813 -0.748 0.00820 0.289 0.613 0000829323 0001490281 0001377630
3 Revenues -0.606 -0.400 0.00557 0.553 1.37 0001377630 0000876883 0001392694
4 StockholdersEquity -0.428 -0.271 -0.0211 0.565 0.628 0001752372 0001539850 0000875355
5 NetIncome -0.658 -0.596 0.114 0.933 1.54 0001847064 0001705110 0001377630
6 ComprehensiveNetIncome -0.662 -0.599 0.112 0.926 1.54 0001847064 0001705110 0001377630
7 BaseVar nan nan nan nan nan 0000029989 0001377630 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.782 -0.638 0.0849 0.930 1.90 0001847064 0001133311 0001377630
9 EconomicCapitalRatio -0.932 -0.788 -0.0650 0.780 1.75 0001847064 0001133311 0001377630

2024

Logs

error 2 × No matching role found input.sec.calculation_linkbase.expand_agg
warning 3 × Missing logo subcommand.report
warning 1 × The EntityCommonStockSharesOutstanding does not exist industry.us_generic
warning 1 × No stock price available subcommand.plot
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

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,270,836 1,870,626 63,002,592 11,448,550,000 16,223,000,000 0001588014 0001460329 0000029989
1 AssetsNonCurrent 0 0 2,041,323 595,545,250 1,042,335,000 0001084267 0001460329 0001576427
2 IntangibleAssets 0 585,461 34,295,816 7,265,485,000 12,243,000,000 0001495231 0001539850 0000029989
3 PropertyPlantAndEquipment 0 3,754 1,747,108 605,485,000 824,700,000 0001334978 0000829323 0000029989
4 remainder_Assets -880,262,000 -132,039,300 3,808,897 408,583,550 1,311,757,000 0001576427 0001133311 0001334978
5 LiabilitiesCurrent 909,523 2,885,213 50,636,916 10,739,345,000 16,300,300,000 0001588014 0001460329 0000029989
6 LiabilitiesNonCurrent 0 0 3,071,473 5,001,583,100 6,950,254,000 0000029989 0001588014 0001334978
7 remainder_Liabilities -4,067,000 -692,726 0 40,898,525 50,209,000 0001576427 0001392694 0000876883
8 CostOfGoodsAndServicesSold 0 0 52,560,603 9,455,905,000 12,764,700,000 0001334978 0001872525 0000029989
9 SellingAndMarketingExpense 0 0 0 319,869,800 601,638,000 0000029989 0000051644 0001705110
10 GeneralAndAdministrativeExpense 0 0 12,775,935 806,497,550 1,343,100,000 0000029989 0001495231 0000051644
11 remainder_Expenses -392,700,000 -58,900,750 34,658,956 1,483,454,450 1,626,563,000 0000051644 0001539850 0001334978
12 remainder_Revenues 0 1,772,650 169,552,726 11,441,310,000 15,689,100,000 0001539850 0001460329 0000029989
13 remainder_NetIncome -153,600,000 -123,022,950 -736,798 31,776,850 107,800,000 0000051644 0001084267 0000029989
14 remainder_ComprehensiveNetIncome -231,700,000 -198,465,000 0 5,382,696 33,868,000 0000029989 0001460329 0001490281
  yvar min 5% median 95% max min_company median_company max_company
0 Assets 6,518,315 7,284,571 84,287,250 20,020,035,000 29,620,700,000 0001084267 0001460329 0000029989
1 Liabilities 3,233,864 4,200,392 59,546,598 14,698,390,000 16,300,300,000 0001084267 0001460329 0000029989
2 Expenses 5,434,265 9,495,520 194,513,770 10,482,475,000 14,222,900,000 0001588014 0001460329 0000029989
3 Revenues 0 1,772,650 169,552,726 11,441,310,000 15,689,100,000 0001539850 0001460329 0000029989
4 StockholdersEquity -3,639,783,000 -543,375,939 29,440,412 5,321,645,000 13,320,400,000 0001334978 0001872525 0000029989
5 NetIncome -175,878,000 -89,465,300 -7,172,678 844,445,000 1,574,000,000 0001334978 0000829323 0000029989
6 ComprehensiveNetIncome -209,747,000 -94,333,150 -8,519,842 645,980,000 1,342,300,000 0001334978 0000876883 0000029989
7 BaseVar 11,258,152 11,458,349 240,851,489 28,493,702,500 38,086,250,000 0001084267 0001460329 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -2.08 -1.36 0.179 0.645 1.25 0001392694 0000829323 0001705110
9 EconomicCapitalRatio 0.209 0.434 0.911 1.29 1.72 0001392694 0000829323 0001705110

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.274 -0.266 -0.0134 0.193 0.509 0000829323 0001705110 0001495231
1 AssetsNonCurrent -0.0611 -0.0553 -0.00957 0.0501 0.340 0001392694 0001847064 0001576427
2 IntangibleAssets -0.363 -0.356 -0.0307 0.180 0.232 0001392694 0001556739 0001539850
3 PropertyPlantAndEquipment -0.0929 -0.0636 -0.0161 0.0658 0.442 0001392694 0001847064 0001588014
4 remainder_Assets -0.173 -0.106 -0.00766 0.145 0.327 0001576427 0001539850 0001084267
5 LiabilitiesCurrent -0.318 -0.222 0.000341 0.207 0.209 0000029989 0001334978 0001588014
6 LiabilitiesNonCurrent -0.441 -0.343 0.0193 0.224 0.264 0001334978 0001847064 0001872525
7 remainder_Liabilities -0.0777 -0.0673 0.0256 0.0618 0.0811 0001133311 0000051644 0000829323
8 CostOfGoodsAndServicesSold -1.43 -1.07 0.0212 0.291 0.291 0001392694 0001490281 0001705110
9 SellingAndMarketingExpense -0.384 -0.306 0.0349 0.178 0.182 0001133311 0001084267 0000829323
10 GeneralAndAdministrativeExpense -0.497 -0.290 0.0199 0.200 0.244 0001084267 0001490281 0001576427
11 remainder_Expenses -1.55 -0.469 0.104 0.287 0.446 0000829323 0001705110 0001872525
12 remainder_Revenues -0.290 -0.205 0.0284 0.408 0.470 0001539850 0001588014 0001872525
13 remainder_NetIncome -0.0474 -0.0284 0.00520 0.0387 0.0394 0001490281 0000051644 0001872525
14 remainder_ComprehensiveNetIncome -0.0123 -0.0122 -0.000218 0.00858 0.0161 0001576427 0001392694 0001490281
  yvar min 5% median 95% max min_company median_company max_company
0 Assets -0.518 -0.494 0.0261 0.182 0.203 0001392694 0001847064 0001495231
1 Liabilities -0.333 -0.264 -0.0142 0.401 0.424 0001334978 0001847064 0001705110
2 Expenses -1.17 -0.775 0.0203 0.227 0.310 0001392694 0001490281 0000029989
3 Revenues -0.290 -0.205 0.0284 0.408 0.470 0001539850 0001588014 0001872525
4 StockholdersEquity -0.326 -0.285 -0.0324 0.488 0.620 0001460329 0001847064 0001705110
5 NetIncome -0.525 -0.463 0.148 0.311 0.313 0001392694 0000876883 0001576427
6 ComprehensiveNetIncome -0.525 -0.463 0.148 0.301 0.309 0001392694 0000876883 0001133311
7 BaseVar nan nan nan nan nan 0000029989 0001392694 0000029989
8 EconomicCapitalRatiobeforeLimitedLiability -0.530 -0.305 0.172 0.554 0.977 0001392694 0000829323 0001705110
9 EconomicCapitalRatio -0.713 -0.489 -0.0108 0.371 0.794 0001392694 0000829323 0001705110

Estimates

Parameter Value Min Max
PresentValueFactor 1.0 1.0 15.0
BalanceFactor 0.78 0.5 5.0
OCIFactor 1.0 0.5 1.0
HiddenReservesFactor 0.0 0.0 1.0
LLPO_stddev 1.31 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            
0000029989 Omnicom Group INC Omnicom OMC 2010 29.6000 1.0000 29.6000 nan nan nan
2011 28.4200 1.0000 28.4200 275,874,000.0 7,840,339,080.00 0.4873
2012 33.5300 1.0000 33.5300 264,180,600.0 8,857,975,518.00 0.5206
2013 49.6900 1.0000 49.6900 257,360,875.0 12,788,261,878.75 0.7440
2014 54.6700 1.0000 54.6700 248,179,673.0 13,567,982,722.91 0.8071
2015 55.0600 1.0000 55.0600 242,255,205.0 13,338,571,587.30 0.7343
2016 64.0700 1.0000 64.0700 235,880,835.0 15,112,885,098.45 0.8131
2017 56.3600 1.0000 56.3600 230,532,661.0 12,992,820,773.96 0.6490
2018 57.2500 1.0000 57.2500 224,105,675.0 12,830,049,893.75 0.6433
2019 66.1900 1.0000 66.1900 217,732,035.0 14,411,683,396.65 0.6741
2020 52.8300 1.0000 52.8300 214,973,478.0 11,357,048,842.74 0.5261
2021 64.4700 1.0000 64.4700 212,558,522.0 13,703,647,913.34 0.6138
2022 73.4700 1.0000 73.4700 203,916,128.0 14,981,717,924.16 0.7125
2023 82.2100 1.0000 82.2100 197,934,170.0 16,272,168,115.70 0.7348
2024 85.3200 1.0000 85.3200 195,093,092.0 16,645,342,609.44 0.7250
0000051644 Interpublic Group OF Companies INC Interpu IPG 2010 6.6600 1.0000 6.6600 nan nan nan
2011 6.0600 1.0000 6.0600 461,172,626.0 2,794,706,113.56 0.2429
2012 7.1900 1.0000 7.1900 431,388,142.0 3,101,680,740.98 0.2552
2013 11.3900 1.0000 11.3900 416,241,739.0 4,740,993,407.21 0.4067
2014 13.9500 1.0000 13.9500 418,229,032.0 5,834,294,996.40 0.5055
2019 18.3900 1.0000 18.3900 387,732,100.0 7,130,393,319.00 0.4385
2020 19.7700 1.0000 19.7700 390,034,693.0 7,710,985,880.61 0.4666
2021 32.3400 1.0000 32.3400 393,755,260.0 12,734,045,108.40 0.7032
2022 29.6500 1.0000 29.6500 385,107,739.0 11,418,444,461.35 0.6727
2023 30.7300 1.0000 30.7300 383,004,131.0 11,769,716,945.63 0.6826
2024 27.7900 1.0000 27.7900 372,508,618.0 10,352,014,494.22 0.6324
0000829323 Inuvo Inc Inuvo I INUV 2011 8.1000 0.1000 0.8100 10,035,791.0 8,128,990.71 0.7007
2015 27.3000 0.1000 2.7300 24,375,881.0 66,546,155.13 2.8619
2017 8.1500 0.1000 0.8200 28,480,659.0 23,354,140.38 0.7439
2018 10.7000 0.1000 1.0700 32,435,446.0 34,705,927.22 1.4992
2019 2.8000 0.1000 0.2800 49,013,375.0 13,723,745.00 0.5620
2020 4.4000 0.1000 0.4400 97,617,529.0 42,951,712.76 1.9058
2021 5.2500 0.1000 0.5200 118,747,447.0 61,748,672.44 2.2593
2022 2.4000 0.1000 0.2400 120,134,884.0 28,832,372.16 1.1681
2023 3.5000 0.1000 0.3500 137,981,678.0 48,293,587.30 2.0221
2024 4.1500 0.1000 0.4200 140,499,799.0 59,009,915.58 2.2903
0000875355 Lendway INC Lendway LDWY 2012 8.7400 0.1430 1.2500 13,602,280.0 17,002,850.00 0.9215
2013 13.8900 0.1430 1.9900 12,741,970.0 25,356,520.30 1.3685
2014 18.7700 0.1430 2.6800 12,295,000.0 32,950,600.00 1.8089
2015 14.5900 0.1430 2.0900 11,638,403.0 24,324,262.27 1.2547
2016 12.1500 0.1430 1.7400 11,727,803.0 20,406,377.22 0.9853
2017 8.5100 0.1430 1.2200 11,914,676.0 14,535,904.72 1.0157
2018 10.6400 0.1430 1.5200 11,839,774.0 17,996,456.48 1.1407
2019 5.3200 0.1430 0.7600 12,074,218.0 9,176,405.68 0.8281
2020 6.1200 0.1430 0.8800 12,235,140.0 10,766,923.20 1.0493
2021 14.8900 1.0000 14.8900 1,768,114.0 26,327,217.46 2.9089
2022 8.4700 1.0000 8.4700 1,796,506.0 15,216,405.82 1.0665
2023 4.6200 1.0000 4.6200 1,745,736.0 8,065,300.32 0.9055
0000876883 Stagwell Inc Stagwel STGW 2011 7.3100 1.5000 10.9600 30,137,032.0 330,301,870.72 0.3276
2014 21.0300 1.0000 21.0300 50,439,696.0 1,060,746,806.88 0.6147
2015 21.0500 1.0000 21.0500 50,794,578.0 1,069,225,866.90 0.5944
2016 6.3800 1.0000 6.3800 54,063,007.0 344,921,984.66 0.1913
2017 10.2000 1.0000 10.2000 58,357,062.0 595,242,032.40 0.3411
2018 2.6400 1.0000 2.6400 59,809,581.0 157,897,293.84 0.0924
2019 2.5500 1.0000 2.5500 145,000,000.0 369,750,000.00 0.1935
2020 2.5400 1.0000 2.5400 73,528,105.0 186,761,386.70 0.1099
2021 8.6800 1.0000 8.6800 113,198,517.0 982,563,127.56 0.2734
2022 6.3200 1.0000 6.3200 130,785,623.0 826,565,137.36 0.2361
2023 6.3700 1.0000 6.3700 120,634,327.0 768,440,662.99 0.2293
2024 6.7300 1.0000 6.7300 111,549,222.0 750,726,264.06 0.2135
0000934796 Network CN INC Network nan 2011 nan nan nan 96,504,467.0 nan nan
2012 nan nan nan 96,904,467.0 nan nan
2013 nan nan nan 106,419,467.0 nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan 8,041,995.0 nan nan
2018 nan nan nan 8,575,395.0 nan nan
2019 nan nan nan 8,774,263.0 nan nan
2020 nan nan nan 8,774,263.0 nan nan
2022 nan nan nan 20,749,018.0 nan nan
0001078099 Meet Group Inc Meet Gr nan 2011 nan nan nan 33,668,224.0 nan nan
2013 nan nan nan 38,477,359.0 nan nan
2014 nan nan nan 44,879,034.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
0001080034 Conversant INC Convers nan 2010 nan nan nan nan nan nan
2011 nan nan nan 82,583,842.0 nan nan
2012 nan nan nan 80,336,851.0 nan nan
2013 nan nan nan 66,756,592.0 nan nan
0001080627 V Media Corp V Media nan 2013 nan nan nan 27,590,701.0 nan nan
0001083243 NZCH Corp NZCH Co nan 2011 nan nan nan 50,004,474.0 nan nan
2012 nan nan nan 50,004,474.0 nan nan
0001084267 Mobiquity Technologies Inc Mobiqui MOBQ 2013 6.7500 0.0670 0.4500 46,499,632.0 20,924,834.40 9.9811
2014 5.2500 0.0670 0.3500 64,032,118.0 22,411,241.30 6.7141
2015 2.4000 0.0670 0.1600 78,651,757.0 12,584,281.12 2.3490
2016 0.6000 0.0670 0.0400 97,300,103.0 3,892,004.12 0.5594
2017 0.3000 0.0670 0.0200 194,570,601.0 3,891,412.02 1.5106
2018 2.1000 0.0670 0.1400 400,443,266.0 56,062,057.24 5.8755
2019 1.2800 0.0670 0.0900 811,193,190.0 73,007,387.10 5.6588
2020 99.0000 0.0670 6.6300 2,780,517.0 18,434,827.71 2.3243
2021 35.2500 0.0670 2.3600 3,685,689.0 8,698,226.04 1.2532
2022 7.8000 0.0670 0.5200 9,311,639.0 4,842,052.28 1.8426
2023 0.2600 1.0000 0.2600 2,738,333.0 711,966.58 0.2300
2024 3.4300 1.0000 3.4300 17,149,356.0 58,822,291.08 12.0458
0001084332 Salon Media Group INC Salon M nan 2012 nan nan nan 3,282,576.0 nan nan
2013 nan nan nan 76,245,442.0 nan nan
2014 nan nan nan 76,245,442.0 nan nan
2015 nan nan nan 76,245,442.0 nan nan
2016 nan nan nan 76,273,983.0 nan nan
2018 nan nan nan 151,056,477.0 nan nan
0001088638 Mastermind INC Masterm MMND 2014 4.0000 1.0000 4.0000 3,179,428.0 12,717,712.00 323.2152
2020 0.5000 1.0000 0.5000 33,870,520.0 16,935,260.00 9.7948
2021 0.0900 1.0000 0.0900 34,505,520.0 3,105,496.80 1.6692
2023 0.1000 1.0000 0.1000 34,505,520.0 3,450,552.00 1.4979
0001091325 China YIDA Holding CO China Y nan 2011 nan nan nan 19,551,785.0 nan nan
2012 nan nan nan 19,551,785.0 nan nan
2013 nan nan nan 3,914,580.0 nan nan
2014 nan nan nan 3,914,580.0 nan nan
2015 nan nan nan nan nan nan
0001115128 Quotient Technology Inc Quotien nan 2014 nan nan nan 79,943,811.0 nan nan
2015 nan nan nan 89,452,684.0 nan nan
2016 nan nan nan 88,022,983.0 nan nan
2017 nan nan nan 92,784,396.0 nan nan
2018 nan nan nan 95,189,382.0 nan nan
2019 nan nan nan 88,989,087.0 nan nan
2020 nan nan nan 91,005,558.0 nan nan
2021 nan nan nan 94,421,658.0 nan nan
2022 nan nan nan 96,699,554.0 nan nan
0001133311 TRAVELZOO TRAVELZ TZOO 2011 26.1200 1.0000 26.1200 15,961,553.0 416,915,764.36 8.4251
2012 19.0700 1.0000 19.0700 15,800,755.0 301,320,397.85 4.2590
2013 21.3200 1.0000 21.3200 15,361,873.0 327,515,132.36 3.5346
2014 13.0200 1.0000 13.0200 14,730,454.0 191,790,511.08 3.0242
2015 8.4300 1.0000 8.4300 14,730,454.0 124,177,727.22 2.2661
2016 10.4300 1.0000 10.4300 13,825,353.0 144,198,431.79 3.4583
2017 6.5000 1.0000 6.5000 12,461,553.0 81,000,094.50 2.1524
2018 8.3100 1.0000 8.3100 12,110,821.0 100,640,922.51 2.8659
2019 11.0100 1.0000 11.0100 11,679,033.0 128,586,153.33 2.8711
2020 9.3200 1.0000 9.3200 11,310,431.0 105,413,216.92 1.0632
2021 10.0100 1.0000 10.0100 12,258,624.0 122,708,826.24 1.2321
2022 4.3500 1.0000 4.3500 12,399,709.0 53,938,734.15 0.8582
2023 9.6400 1.0000 9.6400 13,971,776.0 134,687,920.64 2.6427
2024 19.9600 1.0000 19.9600 11,804,410.0 235,616,023.60 4.4840
0001297336 Reachlocal Inc Reachlo nan 2011 nan nan nan 29,392,406.0 nan nan
2012 nan nan nan 28,370,996.0 nan nan
2013 nan nan nan 27,783,154.0 nan nan
2014 nan nan nan 29,165,755.0 nan nan
0001297965 Inolife Technologies INC Inolife nan 2012 nan nan nan 5,549,281.0 nan nan
2013 nan nan nan nan nan nan
0001329957 OSL Holdings Inc OSL Hol nan 2012 nan nan nan 117,121,248.0 nan nan
2014 nan nan nan nan nan nan
0001334978 Clear Channel Outdoor Holdings Inc Clear C CCO 2011 3.2200 1.0000 3.2200 40,984,143.0 131,968,940.46 0.0338
2012 3.2400 1.0000 3.2400 42,220,486.0 136,794,374.64 0.0345
2013 4.9100 1.0000 4.9100 43,556,018.0 213,860,048.38 0.0568
2014 5.2000 1.0000 5.2000 44,936,373.0 233,669,139.60 0.0660
2015 2.8700 1.0000 2.8700 46,392,713.0 133,147,086.31 0.0366
2020 1.6500 1.0000 1.6500 467,275,942.0 771,005,304.30 0.1079
2021 3.3200 1.0000 3.3200 470,703,669.0 1,562,736,181.08 0.2269
2022 1.0300 1.0000 1.0300 476,055,413.0 490,337,075.39 0.0730
2023 1.8300 1.0000 1.8300 483,009,818.0 883,907,966.94 0.1367
2024 1.3800 1.0000 1.3800 489,078,425.0 674,928,226.50 0.1019
0001343465 Sun Pacific Holding Corp Sun Pac SNPW 2015 734000.0000 1.0000 734000.0000 78,420,404.0 57,560,576,536,000.00 49241707.1508
2016 4100.0000 1.0000 4100.0000 82,252,455.0 337,235,065,500.00 136692.1845
2018 46.0000 1.0000 46.0000 62,506,697.0 2,875,308,062.00 1752.4769
2019 12.0000 1.0000 12.0000 597,310,180.0 7,167,722,160.00 628.0513
2020 8.0000 1.0000 8.0000 966,501,700.0 7,732,013,600.00 639.1194
2021 48.0000 1.0000 48.0000 974,953,335.0 46,797,760,080.00 27075.5111
2022 26.0000 1.0000 26.0000 974,953,335.0 25,348,786,710.00 14689.2519
0001346655 CMG Holdings Group INC CMG Hol CMGO 2014 0.0100 1.0000 0.0100 290,679,190.0 2,906,791.90 4.4065
2015 0.0000 1.0000 0.0000 289,500,000.0 0.00 1.5687
2020 0.0100 1.0000 0.0100 440,350,000.0 4,403,500.00 4.1185
2021 0.0100 1.0000 0.0100 438,672,016.0 4,386,720.16 2.5694
2022 0.0000 1.0000 0.0000 438,672,016.0 0.00 1.0839
2023 0.0000 1.0000 0.0000 438,672,016.0 0.00 0.4689
0001372375 Millennial Media Inc Millenn nan 2012 nan nan nan nan nan nan
2013 nan nan nan 81,495,152.0 nan nan
2014 nan nan nan 107,820,598.0 nan nan
0001375796 Telaria Inc Telaria nan 2013 nan nan nan 49,657,777.0 nan nan
2014 nan nan nan 51,080,730.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
0001377630 National Cinemedia Inc Nationa NCMI 2011 52.2300 0.1000 5.2200 55,176,488.0 288,021,267.36 0.2901
2012 64.3300 0.1000 6.4300 56,177,983.0 361,224,430.69 0.3655
2013 94.8400 0.1000 9.4800 60,295,948.0 571,605,587.04 0.5015
2015 85.6500 0.1000 8.5700 61,496,385.0 527,024,019.45 0.4501
2016 86.3000 0.1000 8.6300 62,401,177.0 538,522,157.51 0.4691
2017 45.7100 0.1000 4.5700 78,501,468.0 358,751,708.76 0.3124
2018 46.8700 0.1000 4.6900 78,958,816.0 370,316,847.04 0.3119
2019 58.1000 0.1000 5.8100 79,751,489.0 463,356,151.09 0.3892
2020 33.1500 0.1000 3.3200 79,580,626.0 264,207,678.32 0.2585
2021 25.6400 0.1000 2.5600 81,136,701.0 207,709,954.56 0.2061
2022 2.7200 0.1000 0.2700 82,000,152.0 22,140,041.04 0.0218
2023 4.0400 1.0000 4.0400 96,784,962.0 391,011,246.48 1.1156
0001392694 Surgepays Inc Surgepa SURG 2012 nan 0.0200 nan 21,554,945.0 nan nan
2013 nan 0.0200 nan 21,554,945.0 nan nan
2015 nan 0.0200 nan 36,130,432.0 nan nan
2016 nan 0.0200 nan 50,985,376.0 nan nan
2017 nan 0.0200 nan 85,057,035.0 nan nan
2018 19.2500 0.0200 0.3800 86,338,372.0 32,808,581.36 6.5454
2019 15.0000 0.0200 0.3000 100,995,459.0 30,298,637.70 2.4561
2020 6.0500 0.0200 0.1200 118,937,711.0 14,272,525.32 1.1343
2021 2.1800 1.0000 2.1800 12,046,528.0 26,261,431.04 1.4782
2022 6.6100 1.0000 6.6100 12,530,928.0 82,829,434.08 2.6342
2023 5.7200 1.0000 5.7200 14,228,202.0 81,385,315.44 2.9356
2024 1.7800 1.0000 1.7800 20,161,547.0 35,887,553.66 2.2018
0001415624 YuMe Inc YuMe In nan 2013 nan nan nan 31,930,819.0 nan nan
2014 nan nan nan 33,044,651.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001419995 DNA Brands INC DNA Bra nan 2011 nan nan nan 44,282,872.0 nan nan
2012 nan nan nan 57,896,866.0 nan nan
2013 nan nan nan 105,065,568.0 nan nan
0001428397 Adaptive Medias Inc Adaptiv nan 2011 nan nan nan 42,070,700.0 nan nan
2012 nan nan nan 46,924,985.0 nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
0001431880 Potash America INC Potash nan 2012 nan nan nan 148,665,000.0 nan nan
0001442376 Total Sports Media Inc Total S 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
0001460329 Fluent Inc Fluent FLNT 2014 23.7000 0.0330 0.7800 nan nan nan
2015 44.2200 0.1670 7.3800 15,603,286.0 115,152,250.68 0.6187
2016 21.4500 0.1670 3.5800 50,663,171.0 181,374,152.18 0.9208
2017 24.4500 0.1670 4.0800 59,677,382.0 243,483,718.56 1.1887
2018 20.7900 0.1670 3.4700 75,291,330.0 261,260,915.10 1.3781
2019 14.9700 0.1670 2.5000 76,809,530.0 192,023,825.00 0.9074
2020 30.4200 0.1670 5.0800 76,334,834.0 387,780,956.72 1.9219
2021 13.0200 0.1670 2.1700 78,945,304.0 171,311,309.68 0.8117
2022 6.2400 0.1670 1.0400 79,951,143.0 83,149,188.72 0.6082
2023 4.1700 0.1670 0.7000 81,237,158.0 56,866,010.60 0.5976
2024 2.6800 1.0000 2.6800 16,876,774.0 45,229,754.32 0.5564
0001463833 IDW Media Holdings INC IDW Med IDWM 2021 2.0000 1.0000 2.0000 nan nan nan
2022 0.9900 1.0000 0.9900 nan nan nan
0001475274 Retailmenot Inc Retailm nan 2013 nan nan nan nan nan nan
2014 nan nan nan 54,066,673.0 nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001490281 Groupon Inc Groupon GRPN 2014 159.8000 0.0500 7.9900 668,957,164.0 5,344,967,740.36 2.8968
2016 71.1000 0.0500 3.5600 571,162,037.0 2,033,336,851.72 1.2466
2017 104.8000 0.0500 5.2400 558,403,052.0 2,926,031,992.48 1.8858
2018 61.1000 0.0500 3.0600 570,780,015.0 1,746,586,845.90 1.2019
2019 46.9000 0.0500 2.3500 564,733,867.0 1,327,124,587.45 0.9533
2020 38.3300 1.0000 38.3300 28,812,655.0 1,104,389,066.15 0.8133
2021 24.3000 1.0000 24.3000 29,560,392.0 718,317,525.60 0.6822
2022 7.2200 1.0000 7.2200 30,437,380.0 219,757,883.60 0.2788
2023 12.2600 1.0000 12.2600 31,853,378.0 390,522,414.28 0.6609
2024 11.7000 1.0000 11.7000 39,767,842.0 465,283,751.40 0.7861
0001491778 Angie s List Inc Angie s nan 2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
0001495231 IZEA Worldwide Inc IZEA Wo IZEA 2011 nan 1.0000 nan 38,645,095.0 nan nan
2012 15.4000 0.0120 0.1800 5,114,280.0 920,570.40 0.4592
2013 25.6000 0.0120 0.3100 22,389,331.0 6,940,692.61 1.8720
2014 19.2000 0.0120 0.2300 57,497,631.0 13,224,455.13 1.6614
2015 29.1200 0.0120 0.3500 104,002,308.0 36,400,807.80 2.5158
2016 17.8800 0.2500 4.4700 5,450,005.0 24,361,522.35 1.9445
2017 15.7800 0.2500 3.9400 5,726,336.0 22,561,763.84 2.0573
2018 4.0400 0.2500 1.0100 12,073,031.0 12,193,761.31 0.6315
2019 0.9400 0.2500 0.2400 34,553,143.0 8,292,754.32 0.4732
2020 6.6200 0.2500 1.6600 48,459,607.0 80,442,947.62 2.7791
2021 5.4400 0.2500 1.3600 62,000,000.0 84,320,000.00 1.5795
2022 2.5800 0.2500 0.6400 62,325,085.0 39,888,054.40 0.7954
2023 2.1200 1.0000 2.1200 15,454,166.0 32,762,831.92 0.7022
2024 2.4900 1.0000 2.4900 16,966,709.0 42,247,105.41 1.1145
0001509477 Nownews Digital Media Technology Co Ltd Nownews nan 2014 nan nan nan 2,412,000.0 nan nan
2015 nan nan nan 22,412,000.0 nan nan
2016 nan nan nan 23,072,000.0 nan nan
2017 nan nan nan 23,072,000.0 nan nan
0001516079 US China Biomedical Technology Inc US Chin nan 2014 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
0001527190 National Cinemedia LLC Nationa nan 2012 nan nan nan nan nan nan
2013 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
0001534298 Zenovia Digital Exchange Corp Zenovia nan 2011 nan nan nan nan nan nan
2012 nan nan nan nan nan nan
0001538217 SRAX Inc SRAX In SRAX 2012 5.0000 0.2000 1.0000 3,912,129.0 3,912,129.00 13.4379
2013 16.8500 0.2000 3.3700 19,891,794.0 67,035,345.78 28.4027
2014 6.2500 0.2000 1.2500 26,079,749.0 32,599,686.25 1.2866
2015 7.3800 0.2000 1.4800 27,250,229.0 40,330,338.92 1.5117
2016 6.0100 1.0000 6.0100 6,941,077.0 41,715,872.77 1.8536
2017 5.6700 1.0000 5.6700 8,675,427.0 49,189,671.09 3.2467
2018 1.8500 1.0000 1.8500 10,133,330.0 18,746,660.50 1.1699
2019 1.4400 1.0000 1.4400 13,997,452.0 20,156,330.88 1.4417
2020 2.7100 1.0000 2.7100 16,026,690.0 43,432,329.90 1.4773
2021 4.5500 1.0000 4.5500 26,149,032.0 118,978,095.60 3.5687
0001539850 Starco Brands Inc Starco STCB 2014 105.0000 0.0330 3.4700 9,992,863.0 34,675,234.61 79.6703
2015 7.5000 0.0330 0.2500 26,300,868.0 6,575,217.00 5.8403
2016 5.5200 0.0330 0.1800 26,296,868.0 4,733,436.24 11.8406
2017 6.0000 0.0330 0.2000 36,263,534.0 7,252,706.80 11.3784
2018 3.5000 1.0000 3.5000 159,090,914.0 556,818,199.00 1176.5911
2019 1.2000 1.0000 1.2000 159,090,914.0 190,909,096.80 308.6058
2020 2.0000 1.0000 2.0000 159,140,665.0 318,281,330.00 328.3475
2021 0.4000 1.0000 0.4000 159,640,665.0 63,856,266.00 23.3482
2022 0.1800 1.0000 0.1800 221,647,203.0 39,896,496.54 1.6114
2023 0.1700 1.0000 0.1700 469,631,464.0 79,837,348.88 1.1456
2024 0.0700 1.0000 0.0700 647,431,696.0 45,320,218.72 1.0532
0001556739 Thryv Holdings Inc Thryv H THRY 2014 nan 1.0000 nan 17,629,011.0 nan nan
2020 11.6400 1.0000 11.6400 31,028,554.0 361,172,368.56 0.3235
2021 40.4300 1.0000 40.4300 33,966,497.0 1,373,265,473.71 1.2013
2022 18.3400 1.0000 18.3400 34,475,189.0 632,274,966.26 0.6408
2023 20.4300 1.0000 20.4300 35,165,017.0 718,421,297.31 1.0164
2024 14.7400 1.0000 14.7400 42,044,826.0 619,740,735.24 1.0095
0001559754 Wowio Inc Wowio I nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
0001576427 Criteo S A Criteo CRTO 2016 41.1100 1.0000 41.1100 63,761,455.0 2,621,233,415.05 2.8921
2017 25.0800 1.0000 25.0800 65,993,182.0 1,655,109,004.56 1.5290
2018 23.0900 1.0000 23.0900 67,361,360.0 1,555,373,802.40 1.3969
2019 17.2200 1.0000 17.2200 64,077,759.0 1,103,419,009.98 0.8681
2020 20.4000 1.0000 20.4000 60,241,537.0 1,228,927,354.80 0.9621
2021 37.9500 1.0000 37.9500 60,722,263.0 2,304,409,880.85 1.6645
2022 25.6400 1.0000 25.6400 60,210,797.0 1,543,804,835.08 0.8535
2023 24.9300 1.0000 24.9300 56,420,382.0 1,406,560,123.26 0.7497
2024 41.6100 1.0000 41.6100 55,182,166.0 2,296,129,927.26 1.3306
0001579717 Perk International Inc Perk In nan 2021 nan nan nan 227,203,331.0 nan nan
0001588014 ADM Endeavors INC ADM End ADMQ 2014 nan 1.0000 nan 117,795,000.0 nan nan
2017 nan 1.0000 nan 128,744,997.0 nan nan
2018 nan 1.0000 nan 128,020,000.0 nan nan
2019 nan 1.0000 nan 131,770,000.0 nan nan
2020 0.0800 1.0000 0.0800 163,652,143.0 13,092,171.44 7.4144
2021 0.0800 1.0000 0.0800 163,652,143.0 13,092,171.44 5.5789
2022 0.0500 1.0000 0.0500 153,652,143.0 7,682,607.15 2.4152
2023 0.0300 1.0000 0.0300 156,537,143.0 4,696,114.29 1.4839
2024 0.0400 1.0000 0.0400 156,637,143.0 6,265,485.72 1.0628
0001609139 Innerscope Hearing Technologies INC Innersc INND 2016 nan 1.0000 nan 60,906,000.0 nan nan
2017 221.8800 1.0000 221.8800 61,539,334.0 13,654,347,427.92 6080.5353
2018 62.6200 1.0000 62.6200 117,418,476.0 7,352,744,967.12 1949.3159
0001615780 Teardroppers Inc Teardro nan 2014 nan nan nan nan nan nan
2015 nan nan nan nan nan nan
2016 nan nan nan nan nan nan
2017 nan nan nan nan nan nan
2018 nan nan nan nan nan nan
2019 nan nan nan nan nan nan
2020 nan nan nan nan nan nan
2021 nan nan nan nan nan nan
2022 nan nan nan nan nan nan
0001648365 AGRI Fintech Holdings INC AGRI Fi nan 2017 nan nan nan 75,000,000.0 nan nan
2018 nan nan nan 40,197,751.0 nan nan
2019 nan nan nan 40,197,751.0 nan nan
2020 nan nan nan 40,306,211.0 nan nan
2021 nan nan nan 1,205,016,211.0 nan nan
0001696195 Kinetic Group INC Kinetic nan 2019 nan nan nan 29,060,000.0 nan nan
2022 nan nan nan 26,320,200.0 nan nan
2023 nan nan nan 26,320,200.0 nan nan
0001703625 NAPC Defense Inc NAPC De BLIS 2018 nan 1.0000 nan 5,035,000.0 nan nan
2020 0.1700 1.0000 0.1700 7,396,502.0 1,257,405.34 2.7392
2021 0.1200 1.0000 0.1200 9,296,502.0 1,115,580.24 2.3792
0001705110 Angi Inc Angi In ANGI 2017 108.0500 0.1000 10.8000 nan nan nan
2018 156.8000 0.1000 15.6800 74,873,502.0 1,174,016,511.36 1.1686
2019 84.5000 0.1000 8.4500 81,230,434.0 686,397,167.30 0.6425
2020 129.5000 0.1000 12.9500 77,938,213.0 1,009,299,858.35 0.7758
2021 93.1000 0.1000 9.3100 80,373,715.0 748,279,286.65 0.6545
2022 21.3000 0.1000 2.1300 82,452,237.0 175,623,264.81 0.1604
2023 24.9500 0.1000 2.5000 85,136,000.0 212,840,000.00 0.2009
2024 16.5000 0.1000 1.6500 75,249,787.0 124,162,148.55 0.1204
0001725516 Renewable Innovations INC Renewab nan 2018 nan nan nan 1,262,378.0 nan nan
2019 nan nan nan 1,673,237.0 nan nan
2020 nan nan nan 1,673,237.0 nan nan
2022 nan nan nan 6,090,580.0 nan nan
0001752372 Ezagoo Ltd Ezagoo EZOO 2019 nan 1.0000 nan 119,956,826.0 nan nan
2020 3.4500 1.0000 3.4500 119,956,826.0 413,851,049.70 176.6644
2021 3.8300 1.0000 3.8300 119,956,826.0 459,434,643.58 234.3722
2022 0.9900 1.0000 0.9900 119,956,826.0 118,757,257.74 64.8061
2023 1.0300 1.0000 1.0300 119,956,826.0 123,555,530.78 65.5461
0001840102 Specificity INC Specifi SPTY 2021 nan 1.0000 nan 7,971,667.0 nan nan
2022 nan 1.0000 nan 9,867,183.0 nan nan
0001847064 PSQ Holdings Inc PSQ Hol PSQH 2023 5.3900 1.0000 5.3900 24,395,075.0 131,489,454.25 6.5648
2024 4.0000 1.0000 4.0000 31,548,544.0 126,194,176.00 2.0530
0001872525 Stran Company Inc Stran C SWAG 2023 1.5100 1.0000 1.5100 18,573,091.0 28,045,367.41 0.6705
2024 0.9500 1.0000 0.9500 nan nan nan