Spreadsheet: 866141d1713093323-vlookup-and-indirect-and-match-formula-animal-sample
Sheet: COW

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00
In Millions of USD except Per Share |  | FY 2011 | FY 2012 | FY 2013 | FY 2014 | FY 2015 | FY 2016 | FY 2017 | FY 2018 | FY 2019 | FY 2020 | FY 2021 | FY 2022 | FY 2023 | Last 12M | FY 2024 Est | FY 2025 Est
12 Months Ending |  | 06/29/2011 | 06/30/2012 | 06/30/2013 | 06/30/2014 | 06/30/2015 | 06/30/2016 | 06/30/2017 | 06/30/2018 | 06/30/2019 | 06/30/2020 | 06/30/2021 | 06/30/2022 | 06/30/2023 | 12/31/2023 | 06/30/2024 | 06/30/2025
Revenue | SALES_REV_TURN | 39.484 | 55.096 | 77.294 | 108.687 | 152.698 | 230.701 | 300.01 | 377.527 | 467.633 | 561.329 | 635.627 | 852.651 | 4 | 1292.257 | 1386.938 | 1577.438
+ Sales & Services Revenue | IS_SALES_AND_SERVICES_REVENUES | — | — | — | — | — | 0.942414640595403 | 0.949358354721509 | 0.938825567442858 | 0.934397273075253 | 0.973069269537116 | 0.993861179591175 | 0.994186366989542 | 0.934818550687129 | 0.918003926463544
+ Other Revenue | IS_OTHER_REVENUE | 1 | 1 | 1 | 1 | 1 | 0.0575853594045973 | 0.0506416452784907 | 0.0611744325571416 | 0.0656027269247465 | 0.0269307304628836 | 0.00613882040882467 | 0.00581363301045797 | 0.0651814493128713 | 0.081996073536456
- Cost of Revenue | IS_COGS_TO_FE_AND_PP_AND_G | 0.550729409381015 | 0.528060113256861 | 0.513183429502937 | 0.506905149649912 | 0.464288988722839 | 0.425160705848696 | 0.413276224125862 | 0.395195575415798 | 0.32899945042373 | 0.324248346335215 | 0.345010517174381 | 0.336599616959342 | 0.312464349505107 | 0.31053110952388
+ Cost of Goods & Services | IS_COG_AND_SERVICES_SOLD | 0.550729409381015 | 0.528060113256861 | 0.513183429502937 | 0.506905149649912 | 0.464288988722839 | 0.425160705848696 | 0.413276224125862 | 0.395195575415798 | 0.32899945042373 | 0.324248346335215 | 0.345010517174381 | 0.336599616959342 | 0.312464349505107 | 0.31053110952388
Gross Profit | GROSS_PROFIT | 0.449270590618985 | 0.471939886743139 | 0.486816570497063 | 0.493094850350088 | 0.535711011277161 | 0.574839294151304 | 0.586723775874137 | 0.604804424584202 | 0.67100054957627 | 0.675751653664785 | 0.65498948282562 | 0.663400383040658 | 0.687535650494893 | 0.689468892554304 | 0.73182 | 0.73489
+ Other Operating Income | IS_OTHER_OPER_INC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Operating Expenses | IS_OPERATING_EXPN | 0.448941343328943 | 0.421700304922317 | 0.486415504437602 | 0.557665590180978 | 0.625201377883142 | 0.587140931335365 | 0.561561281290624 | 0.561451233951479 | 0.549798666903319 | 0.550600450003474 | 0.559704040262607 | 0.561025554417927 | 0.555173770089852 | 0.520304397654646
+ Selling, General & Admin | IS_SGA_EXPENSE | 0.409305034950866 | 0.389247858283723 | 0.398116283282014 | 0.46239200640371 | 0.496791051618227 | 0.474336912280398 | 0.465414486183794 | 0.462843717138112 | 0.443144517174793 | 0.446052136982055 | 0.44121316432436 | 0.442363874551253 | 0.41589633219195 | 0.386327177952992
+ Selling & Marketing | IS_SELLING_EXPENSES | 0.235361158950461 | 0.232829969507768 | 0.24184283385515 | 0.260159908728735 | 0.281830803284915 | 0.268017910628909 | 0.258344721842605 | 0.252919658726396 | 0.240784974542002 | 0.258554252497199 | 0.25456439075118 | 0.251515567330596 | 0.252591950607782 | 0.239997926109125
+ General & Administrative | IS_GENERAL_AND_ADMINISTRATIVE | 0.173943876000405 | 0.156417888775955 | 0.156273449426864 | 0.202232097674975 | 0.214960248333311 | 0.206319001651488 | 0.207069764341189 | 0.209924058411716 | 0.202359542632791 | 0.187497884484856 | 0.18664877357318 | 0.190848307220657 | 0.163304381584168 | 0.146329251843867
+ Research & Development | IS_OPERATING_EXPENSES_RD | 0.0396363083780772 | 0.0324524466385945 | 0.0882992211555878 | 0.0952735837772687 | 0.130086838072535 | 0.115890264888319 | 0.096990100329989 | 0.0997147223907165 | 0.107624996525053 | 0.111816777682963 | 0.119485169761511 | 0.119648015424834 | 0.139277437897902 | 0.134049186810364
+ Other Operating Expense | IS_OTHER_OPERATING_EXPENSES | 0 | 0 | 0 | 0 | -0.00167651180762027 | -0.00308624583335139 | -0.000843305223159228 | -0.00110720557734943 | -0.000970846796526336 | -0.0072684646615443 | -0.000994293823264273 | -0.0009863355581592 | 0 | -7.19671087098e-05
Operating Income (Loss) | IS_OPER_INC | 0.000329247290041536 | 0.0502395818208218 | 0.000401066059461278 | -0.0645707398308905 | -0.0894903666059804 | -0.0123016371840608 | 0.0251624945835139 | 0.043353190632723 | 0.121201882672951 | 0.125151203661311 | 0.0952854425630126 | 0.102374828622731 | 0.132361880405041 | 0.169164492821474 | 0.290909903687115 | 0.297351147873958
- Non-Operating (Income) Loss | IS_NONOP_INCOME_LOSS | 0.00453348191672576 | 0.00355742703644548 | 0.000207001837141305 | -0.00149971937766246 | -0.000353639209419901 | 0.000537492251875805 | -0.000243325222492584 | -0.00212435137089533 | -0.00389621776050878 | -0.0016870676555104 | 0.00147728148741322 | 0.00116929435372738 | -0.0030546621056736 | -0.0083427677311866
+ Interest Expense, Net | IS_NET_INTEREST_EXPENSE | 0.00602775807922196 | 0.00473718600261362 | 0.00248402204569566 | 0.00061644906934592 | 0 | 0 | 0 | 0 | 0 | 0.00123813307347385 | 0.00157639621979557 | 0.000584060770467636 | 0.000640219036640621 | 0.0005834752684644
+ Interest Expense | IS_INT_EXPENSE | 0.00602775807922196 | 0.00473718600261362 | 0.00248402204569566 | 0.00061644906934592 | 0 | 0 | 0 | 0 | 0 | 0.00123813307347385 | 0.00157639621979557 | 0.000584060770467636 | 0.000640219036640621 | 0.0005834752684644
- Interest Income | IS_INT_INC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Foreign Exch (Gain) Loss | IS_FOREIGN_EXCH_LOSS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ (Income) Loss from Affiliates | INCOME_LOSS_FROM_AFFILIATES | 0 | 0 | 0 | 0 | — | — | — | — | — | — | — | — | —
+ Other Non-Op (Income) Loss | IS_OTHER_NON_OPERATING_INC_LOSS | -0.0014942761624962 | -0.00117975896616814 | -0.00227702020855435 | -0.00211616844700838 | -0.000353639209419901 | 0.000537492251875805 | -0.000243325222492584 | -0.00212435137089533 | -0.00389621776050878 | -0.00292520072898425 | -9.91147323823563e-05 | 0.000585233583259739 | -0.00369488114231422 | -0.008926242999651
Pretax Income (Loss), Adjusted | PRETAX_INC | -0.00420423462668423 | 0.0466821547843764 | 0.000194064222319973 | -0.0630710204532281 | -0.0891367273965605 | -0.0128391294359366 | 0.0254058198060065 | 0.0454775420036183 | 0.12509810043346 | 0.126838271316821 | 0.0938081610755994 | 0.101205534269003 | 0.135416542510714 | 0.177507261119438 | 0.296652049334577 | 0.300487245774477
- Abnormal Losses (Gains) | IS_ABNORMAL_ITEM | 0 | 0 | 0 | 0 | 0.00167651180762027 | 0.00308624583335139 | 0.000843305223159228 | 0.00110720557734943 | 0.000970846796526336 | 0.0072684646615443 | 0.00396930904445532 | 0.00316190328751154 | 0.000379704375454411 | -0.00156315659642238
+ Merger/Acquisition Expense | IS_MERGER_ACQUISITION_EXPENSE | — | — | — | — | — | — | — | 0.000505924079602254 | — | — | — | — | —
+ Disposal of Assets | IS_GAIN_LOSS_DISPOSAL_ASSETS | — | — | — | — | 0.00167651180762027 | 0.00308624583335139 | 0.000843305223159228 | 0.000601281497747181 | 0.000970846796526336 | 0.000703687142477941 | 0.000994293823264273 | 0.000372954467888972 | —
+ Other Abnormal Items | IS_OTHER_ONE_TIME_ITEMS | — | — | — | — | — | — | — | — | — | 0.00656477751906636 | 0.00297501522119104 | 0.00278894881962257 | 0.000379704375454411 | -0.0016351236634818
Pretax Income (Loss), GAAP | PRETAX_INC | -0.00420423462668423 | 0.0466821547843764 | 0.000194064222319973 | -0.0630710204532281 | -0.0908132392041808 | -0.015925375269288 | 0.0245625145828472 | 0.0443703364262689 | 0.124127253636933 | 0.119569806655277 | 0.0898388520311441 | 0.0980436309814918 | 0.13503683813526 | 0.179070418713302 | 0.296652049334577 | 0.300487245774477
- Income Tax Expense (Benefit) | IS_INC_TAX_EXP | -0.000911761726268868 | 0.0160447219398867 | -0.00778844412244159 | 0.00234618675646581 | 0.000687631796094251 | 0.000767226843403366 | 0.0021699276690777 | -0.0578687087281175 | 0.00903058595094871 | 0.00474409838080698 | -0.0215771199146669 | -0.00842079584730447 | 0.0151473099732845 | 0.0494499159222972
+ Current Income Tax | IS_CURRENT_INCOME_TAX_BENEFIT | 0.000151960287711478 | 0.000834906345288224 | 0.00284627526069294 | -0.000791262984533569 | 9.16842394792335e-05 | 0.000117034603231022 | 0.0016666111129629 | 0.00174292169831562 | 0.000192458616051476 | -0.000163896752172077 | — | — | —
+ Deferred Income Tax | IS_DEFERRED_INCOME_TAX_BENEFIT | -0.00106372201398035 | 0.0152098155945985 | -0.0106347193831345 | 0.00313744974099938 | 0.000595947556615018 | 0.000650192240172344 | 0.000503316556114796 | -0.0596116304264331 | 0.00883812733489724 | 0.00490799513297905 | — | — | —
+ Tax Allowance/Credit | IS_TAX_VALN_ALLOWNCE_CREDITS | 0 | 0 | 0 | 0 | — | — | — | — | — | — | — | — | —
Income (Loss) from Cont Ops | IS_INC_BEF_XO_ITEM | -0.00329247290041536 | 0.0306374328444896 | 0.00798250834476156 | -0.0654172072096939 | -0.091500871000275 | -0.0166926021126913 | 0.0223925869137695 | 0.102239045154386 | 0.115096667685985 | 0.11482570827447 | 0.111415971945811 | 0.106464426828796 | 0.119889528161975 | 0.129620501185136 | 0.131368525485638 | 0.14128415823633
- Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Discontinued Operations | IS_DISCONTINUED_OPERATIONS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ XO & Accounting Changes | EXTRAORD_ITEMS_ACCOUNTING_CHANGS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income (Loss) Incl. MI | NI_INCLUDING_MINORITY_INT_RATIO | -0.00329247290041536 | 0.0306374328444896 | 0.00798250834476156 | -0.0654172072096939 | -0.091500871000275 | -0.0166926021126913 | 0.0223925869137695 | 0.102239045154386 | 0.115096667685985 | 0.11482570827447 | 0.111415971945811 | 0.106464426828796 | 0.119889528161975 | 0.129620501185136
- Minority Interest | MIN_NONCONTROL_INTEREST_CREDITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income, GAAP | NET_INCOME | -0.00329247290041536 | 0.0306374328444896 | 0.00798250834476156 | -0.0654172072096939 | -0.091500871000275 | -0.0166926021126913 | 0.0223925869137695 | 0.102239045154386 | 0.115096667685985 | 0.11482570827447 | 0.111415971945811 | 0.106464426828796 | 0.119889528161975 | 0.129620501185136 | 0.131368525485638 | 0.14128415823633
- Preferred Dividends | IS_TOT_CASH_PFD_DVD | 0.0163104042143653 | 0.0125235951793234 | 0.0376225839004321 | 0.0209960712872745 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Other Adjustments | OTHER_ADJUSTMENTS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income Avail to Common, GAAP | EARN_FOR_COMMON | -0.0196028771147807 | 0.0181138376651663 | -0.0296400755556706 | -0.0864132784969684 | -0.091500871000275 | -0.0166926021126913 | 0.0223925869137695 | 0.102239045154386 | 0.115096667685985 | 0.11482570827447 | 0.111415971945811 | 0.106464426828796 | 0.119889528161975 | 0.12962050198807 | 0.131368525485638 | 0.14128415823633
Net Abnormal Losses (Gains) | IS_NET_ABNORMAL_ITEMS | 0 | 0 | 0 | 0 | 0.00108973267495318 | 0.00200605979167841 | 0.000548148395053498 | 0.00101036482158892 | 0.0160986713940205 | 0.00521886451617501 | 0.00274632921508998 | 0.00260157555670491 | 0.000345365818773742 | -0.00105700487827963
Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Basic Weighted Avg Shares | IS_AVG_NUM_SH_FOR_EPS | 1.42610931010029 | 1.19445150283142 | 0.62077263435713 | 0.337731283410159 | 0.328275419455396 | 0.220688250159297 | 0.171377620745975 | 0.138864240173551 | 0.113152835663865 | 0.095393254223459 | 0.0854557783102354 | 0.0645469248262185 | 0.0474255873073171 | 0.0435238501319784
Basic EPS, GAAP | IS_EPS | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00183368478958467 | -0.000346769194758584 | 0.000433318889370354 | 0.0019601247063124 | 0.0021811976485834 | 0.00213778372398362 | 0.00204522463646132 | 0.00193514110697108 | 0.00215392840784677 | 0.0023215196358 | 0.00225388589828817 | 0.00229422646088151
Basic EPS from Cont Ops, GAAP | IS_EARN_BEF_XO_ITEMS_PER_SH | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00183368478958467 | -0.000346769194758584 | 0.000433318889370354 | 0.0019601247063124 | 0.0021811976485834 | 0.00213778372398362 | 0.00204522463646132 | 0.00193514110697108 | 0.00215392840784677 | 0.0023215196358 | 0.00225388589828817 | 0.00229422646088151
Basic EPS from Cont Ops, Adjusted | IS_BASIC_EPS_CONT_OPS | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00180363855453248 | -0.000288464289274862 | 0.000446188460384654 | 0.0019694697332906 | 0.00247940799729703 | 0.00224185459864001 | 0.00210174048616563 | 0.00198172053982227 | 0.00215838354909509 | 0.00230003010237128 | 0.00441980823944545 | 0.00426197416316838
Diluted Weighted Avg Shares | IS_SH_FOR_DILUTED_EPS | 1.42610931010029 | 1.20653949470016 | 0.62077263435713 | 0.337731283410159 | 0.328275419455396 | 0.220688250159297 | 0.180183993866871 | 0.145385628047795 | 0.118498908331961 | 0.0994194135702948 | 0.0885818255045805 | 0.0661994180502926 | 0.048183293348022 | 0.043996666297803
Diluted EPS, GAAP | IS_DILUTED_EPS | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00183368478958467 | -0.000346769194758584 | 0.000399986667111096 | 0.0018541720194847 | 0.00207427619522147 | 0.00204870940215097 | 0.00198229464764713 | 0.00188822859528693 | 0.00211987420377014 | 0.002290566040656 | 0.00225388589828817 | 0.00229422646088151
Diluted EPS from Cont Ops, GAAP | IS_DIL_EPS_BEF_XO | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00183368478958467 | -0.000346769194758584 | 0.000399986667111096 | 0.0018541720194847 | 0.00207427619522147 | 0.00204870940215097 | 0.00198229464764713 | 0.00188822859528693 | 0.00211987420377014 | 0.002290566040656 | 0.00225388589828817 | 0.00229422646088151
Diluted EPS from Cont Ops, Adjusted | IS_DIL_EPS_CONT_OPS | -0.000337681086009523 | 0.000241995789167998 | -0.000603759670867079 | -0.0023921904183573 | -0.00181194252707959 | -0.00030736754500414 | 0.000410126329122363 | 0.00187258129882101 | 0.00236479247615117 | 0.00214222496967019 | 0.00203107010872729 | 0.00193431896520382 | 0.00212597671714067 | 0.00227197453757263 | 0.00441980823944545 | 0.00426197416316838
Reference Items
Accounting Standard | ACCOUNTING_STANDARD | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP
EBITDA | EBITDA | 0.0960389018336541 | 0.134165819660229 | 0.0724765182290993 | -0.00627489948199877 | -0.0331111082005003 | 0.0478324758020121 | 0.0952501583280557 | 0.123352766821976 | 0.195114544952987 | 0.209948176559558 | 0.177269058740425 | 0.1700777926725 | 0.191730277082031 | 0.221223022974532 | 0.343961301802964 | 0.341788393585041
EBITDA Margin (T12M) | EBITDA_MARGIN | 0.243234981258231 | 0.243512813997386 | 0.0937673299350532 | -0.00577336756005778 | -0.0216840495618803 | 0.0207335382161326 | 0.0317489950334989 | 0.0326738935228474 | 0.0417238603776894 | 0.0374019835069986 | 0.0278888499072569 | 0.0199469407764724 | 0.0163230552069729 | 0.0171191197242137 | 0.0248000488704588 | 0.0216673107649899
EBITA | EBITA | 0.0566305338871442 | 0.0997350079860607 | 0.0400807307164851 | -0.0436390736702642 | -0.0664055848799591 | 0.0179019596794119 | 0.0615846138462051 | 0.0857607535355087 | 0.16219984475005 | 0.181214581822781 | 0.152246521938181 | 0.15116149514866 | 0.175998937508833 | 0.205998497202956
EBIT | EBIT | 0.000329247290041536 | 0.0502395818208218 | 0.000401066059461278 | -0.0645707398308905 | -0.0894903666059804 | -0.0123016371840608 | 0.0251624945835139 | 0.043353190632723 | 0.121201882672951 | 0.125151203661311 | 0.0952854425630126 | 0.102374828622731 | 0.132361880405041 | 0.169164492821474 | 0.290909903687115 | 0.297351147873958
Gross Margin | [NAME] | 1.13785480194509 | 0.856577410338319 | 0.629824527130178 | 0.453683375196666 | 0.350830403803586 | 0.24917069713612 | 0.19556807439752 | 0.160201633260667 | 0.14348870802531 | 0.12038423990209 | 0.103046201624538 | 0.0778044451950446 | 0.058533698337644 | 0.0533538522504518 | 0.0527651560487924 | 0.0465875679424484
Operating Margin | OPER_MARGIN | 0.000833882078816736 | 0.0911855307100334 | 0.000518888917639144 | -0.0594098098208617 | -0.058606117958323 | -0.00533228724626248 | 0.00838721709276358 | 0.0114834674076291 | 0.0259181623195968 | 0.0222955165330849 | 0.014990779183389 | 0.012006651021344 | 0.0112686961837156 | 0.01309062305884 | 0.0209749753548547 | 0.0188502589562289
Profit Margin | PROF_MARGIN | -0.0083387448080235 | 0.0556073580659213 | 0.0103274639687427 | -0.0601886242144875 | -0.0592091186525036 | -0.00636604956198716 | 0.00764665844471851 | 0.0273488810071862 | 0.0280551928542254 | 0.0213857773248843 | 0.0179605806550068 | 0.0127913999983581 | 0.0102362587029775 | 0.00994875603744891 | 0.0181015044799923 | 0.0155145420028273
Sales per Employee | ACTUAL_SALES_PER_EMPL | — | — | — | 1033.05785124256 | 757.575757573773 | 555.555555554592 | 472.813238772041 | 384.6153846162 | 327.868852459086 | 277.777777777382 | 240.963855421497 | 188.67924528324 | 163.934426229229
Dividends per Share | EQY_DPS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Common Dividends | IS_TOT_CASH_COM_DVD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Capitalized Interest Expense | IS_CAP_INT_EXP | — | — | — | — | 0 | 0 | 0 | 0 | 0 | — | — | — | —
Depreciation Expense | IS_DEPR_EXP | 0.03940836794651 | 0.0344308116741687 | 0.0323957875126142 | 0.0373641741882654 | 0.0332944766794588 | 0.0299305161226002 | 0.0336655444818506 | 0.0375920132864669 | 0.0329147002029369 | 0.0287335947367765 | 0.0250225368022441 | 0.0189162975238404 | 0.0157313395731987 | 0.0152245257715764
Rental Expense | BS_CURR_RENTAL_EXPENSE | 0.0334312632965252 | 0.0275700595324524 | 0.0303645819856651 | 0.0279242227681323 | 0.0277541290652137 | 0.0242565051733629 | 0.0285690476984101 | 0.032561909479322 | 0.0292922013630347 | 0.0229687046277673 | 0.0220412285821716 | 0.0145815814442251 | 0.0123676355655297
Source: Bloomberg |  | Right click to show data transparency (not supported for all values)
Reference Items
Accounting Standard | ACCOUNTING_STANDARD | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP
Shares Outstanding | BS_SH_OUT | 0.177914449654336 | 0.168391573051452 | 0.126964722319246 | 0.0938443740521177 | 0.0703672760176976 | 0.0367673865256718 | 0.045486315334158 | 0.0349947167648692 | 0.0292459675787623 | 0.0270904007155347 | 0.0226072877176346 | 0.0114763650095425 | 0.0151290154991774
Number of Treasury Shares | BS_NUM_OF_TSY_SH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pension Obligations | BS_PENSION_RSRV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Future Minimum Operating Lease Obligations | BS_FUTURE_MIN_OPER_LEASE_OBLIG | 0 | 0 | 0.0468490352353433 | 0.0328504537528093 | 0.0230741047091936 | 0.0800761349230489 | 0.103159636411911 | 0.0746120155293284 | 0.0599675931751648 | 0.0501206658984875 | 0.0372721682398955 | 0.0189005480125448 | 0.0219967637890727
Capital Leases - Total | BS_TOTAL_CAPITAL_LEASES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Options Granted During Period | BS_OPTIONS_GRANTED | 0.0021706709806251 | 0 | 0.00367541993458864 | 0.00488875340574949 | 0.000446882095294137 | 0.000107141136515785 | 0 | 0 | 0 | — | — | — | —
Options Outstanding at Period End | BS_OPTIONS_OUTSTANDING | 0.00536980397608786 | 0.00508522757183016 | 0.00737862382116661 | 0.00830823003269898 | 0.00549026574218512 | 0.00249085165698442 | 0.00241858698605027 | 0.00126492522215788 | 0.000845371328663188 | 0.000632035486652216 | 0.000316785271348325 | 0.000113952673042748 | 7.79288250064941e-05
Net Debt | NET_DEBT | -0.0141867724934595 | -0.0205058555570763 | -0.0159585728045386 | -0.14929063847271 | -0.112772500929848 | -0.0621965083494584 | -0.0909655973364772 | -0.0910009889897778 | -0.0896869686979785 | -0.0564591508666189 | -0.057784118084298 | -0.0146884579666435 | -0.0612325742488527
Net Debt to Equity | NET_DEBT_TO_SHRHLDR_EQTY | -0.200236732682027 | -0.229706011377714 | -0.159889517776437 | -0.163814426177362 | -0.104826641667176 | -0.0520159474907761 | -0.0616243805173191 | -0.0427587999196073 | -0.0291225494625379 | -0.0143695599622894 | -0.0121158489948797 | -0.00239435110814816 | -0.00726483110009525
Tangible Common Equity Ratio | TCE_RATIO | -0.00501385817019072 | -0.0391343356390576 | -0.0205918775600927 | 0.0282647973780226 | 0.016424303446821 | 0.0048395320592886 | 0.00917314392570692 | 0.00766372821950665 | 0.00821158674258194 | 0.00845592119046276 | 0.0068666441673206 | 0.00182668151933016 | 0.00483175166681098
Current Ratio | CUR_RATIO | 0.00320623586062207 | 0.00354551261129419 | 0.00266282718911081 | 0.00218688405399214 | 0.00154562360869782 | 0.00075824429473448 | 0.000958568400470881 | 0.000719360386946396 | 0.000607696149707779 | 0.000594480492010669 | 0.000450887309333571 | 0.000213551884024459 | 0.000297270597021387
Number of Employees | NUM_OF_EMPLOYEES | — | — | — | 9.68 | 13.2 | 18 | 21.15 | 26 | 30.5 | 36 | 41.5 | 53 | 61
In Millions of USD except Per Share |  | FY 2011 | FY 2012 | FY 2013 | FY 2014 | FY 2015 | FY 2016 | FY 2017 | FY 2018 | FY 2019 | FY 2020 | FY 2021 | FY 2022 | FY 2023
12 Months Ending |  | 06/29/2011 | 06/30/2012 | 06/30/2013 | 06/30/2014 | 06/30/2015 | 06/30/2016 | 06/30/2017 | 06/30/2018 | 06/30/2019 | 06/30/2020 | 06/30/2021 | 06/30/2022 | 06/30/2023
Income Statement
Revenues
Other Revenue | ARD_OTHER_REV | 3.041 | 3.885 | 5.985 | 8.325 | 10.53 | 13.285 | 15.193 | 23.095 | 30.678 | 15.117 | 3.902 | 4.957 | 76.562
Service Revenue | ARD_SERVICE_REVENUE | — | — | — | — | — | 217.416 | 284.817 | 354.432 | 436.955 | 546.212 | 631.725 | 847.694 | 1098.036
License/Contract/Fee Revenue | [NAME] | 36.443 | 51.211 | 71.309 | 100.362 | 142.168 | — | — | — | — | — | — | — | —
Total Revenue | ARD_TOTAL_REVENUES | 39.484 | 55.096 | 77.294 | 108.687 | 152.698 | 230.701 | 300.01 | 377.527 | 467.633 | 561.329 | 635.627 | 852.651 | 1174.598
In Millions of USD except Per Share |  | FY 2011 | FY 2012 | FY 2013 | FY 2014 | FY 2015 | FY 2016 | FY 2017 | FY 2018 | FY 2019 | FY 2020 | FY 2021 | FY 2022 | FY 2023
12 Months Ending |  | 06/29/2011 | 06/30/2012 | 06/30/2013 | 06/30/2014 | 06/30/2015 | 06/30/2016 | 06/30/2017 | 06/30/2018 | 06/30/2019 | 06/30/2020 | 06/30/2021 | 06/30/2022 | 06/30/2023
Cash Flow
Cash From Operating Activities
Net Income - CF | [NAME]
Depreciation And Amortization - CF | ARD_DEPRECIATION_AND_AMORT_CF
Deferred Income Taxes - CF | ARD_DEFERRED_INCOME_TAXES_CF
Provision For Doubtful Accounts - CF | ARD_PROVISION_DOUBTFUL_ACCT_CF
Disposal/Sale of Assets | ARD_DISPOSAL_SALE_OF_ASSETS
Stock Based Compensation | ARD_STOCK_BASED_COMPENSATION
Other Non-Cash Items | ARD_OTHER_NON_CASH_ITEMS
Change in Accounts Payable | ARD_CHANGE_IN_ACCOUNTS_PAYABLE
Change in Accounts Receivable | ARD_CHG_IN_ACCOUNTS_RECEIVABLE
Change in Prepaid Expenses | ARD_CHANGE_IN_PREPAID_EXP
Change in Accrued Expenses | ARD_CHANGE_IN_ACCRUED_EXP
Change in Other Assets | ARD_CHANGE_IN_OTHER_ASSETS
Change In Other Liabilites | ARD_CHG_IN_OTHER_LIABILITES
Total Cash Flows From Operations | ARD_TOT_CASH_FLOWS_FROM_OPS
Amortization of Debt Discount | ARD_AMORT_OF_DEBT_DISCOUNT
Cash From Investing Activities
Capital Expenditures | ARD_CAPITAL_EXPENDITURES
Acquisition of Business | ARD_ACQUISITION_OF_BUSINESS
Other Investing Activities | ARD_OTHER_INVESTING_ACTIVITIES
Proceeds From Long-Term Marketable Securities | ARD_PROCEEDS_FROM_LT_MKT_SEC
Purchases of Long-Term Marketable Securities | ARD_PURCHASES_OF_LT_MKT_SEC
Acquisition Of Properties/Equipment | ARD_ACQ_PROPERTIES_EQUIP
Development Costs | ARD_DEV_COSTS
Total Cash Flows From Investing | ARD_TOT_CASHFLOWS_FROM_INVESTING
Cash from Financing Activities
Increase In Short-Term Borrowings | ARD_INCR_IN_ST_BORROW
Increase In Long-Term Borrowings | ARD_INCR_IN_LT_BORROW
Decrease In Long-Term Borrowings | ARD_DECR_IN_LT_BORROW
Issuance of Common Stock | ARD_ISSUANCE_OF_COMMON_STOCK
Repurchase of Common Stock | ARD_REPURCHASE_OF_COMMON_STOCK
Debt Financing/Issuance Costs | ARD_DEBT_FIN_ISSUANCE_COSTS
Other Financing Activities | ARD_OTHER_FINANCING_ACTIVITIES
Cash Paid For Taxes | ARD_CASH_PAID_FOR_TAXES
Cash Paid For Interest | ARD_CASH_PAID_FOR_INTEREST
Exercise of Stock Options | ARD_EXERCISE_OF_STOCK_OPTIONS
Net Change In Cash | ARD_NET_CHANGE_IN_CASH
Cash and Cash Equivalents (End of Period) | ARD_CASH_CASH_EQUIV_END_OF_PER
Repurchase of Preferred Stock | ARD_REPURCHASE_PREFERRED_STK
Cash and Cash Equivalents (Beg of Period) | ARD_CASH_CASH_EQUIV_BEG_OF_PER
Change In Non-Cash Working Capital - Financing | ARD_CHNG_NON_CASH_WORK_CAP_FIN
Tax Benefit From Stock Options - Financing | ARD_TAX_BEN_STOCK_OPTIONS_FIN
Total Cash Flows From Financing | ARD_TOT_CASHFLOWS_FROM_FINANCING