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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00
In Millions of USD except Per Share |  | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | 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/30/2006 | 06/30/2007 | 06/30/2008 | 06/30/2009 | 06/30/2010 | 06/30/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 | 6835.6 | 7800 | 8776.5 | 8838.4 | 8927.7 | 9833 | 10595.4 | 9442 | 10226.4 | 10938.5 | 11667.8 | 12379.8 | 13327.7 | 14110.2 | 14589.8 | 15005.4 | 16498.3 | 6 | 18586 | 19148.5 | 20278.5
+ Sales & Services Revenue | IS_SALES_AND_SERVICES_REVENUES | — | — | — | 0.79784802679218 | 0.79277977530607 | 0.789077595850707 | 0.787313362402552 | 0.747818258843465 | 0.742724712508801 | 0.724806874800018 | 0.705702874577898 | 0.688064427535178 | 0.674039781807814 | 0.664469674419923 | 0.653751250873898 | 0.651005637970331 | 0.636732269385331 | 0.623022173859939 | 0.62493274507694
+ Other Revenue | IS_OTHER_REVENUE | — | — | — | 0.20215197320782 | 0.20722022469393 | 0.210922404149293 | 0.212686637597448 | 0.252181741156535 | 0.257275287491199 | 0.275193125199982 | 0.294297125422102 | 0.311935572464822 | 0.325960218192186 | 0.335530325580077 | 0.346248749126102 | 0.348994362029669 | 0.363267730614669 | 0.376977826140061 | 0.37506725492306
- Cost of Revenue | IS_COGS_TO_FE_AND_PP_AND_G | 0.434563169290187 | 0.434910256410256 | 0.446157352019598 | 0.545653059377263 | 0.56235088544642 | 0.580534933387572 | 0.585527681824188 | 0.590351620419403 | 0.590725964171165 | 0.587612561137267 | 0.58625447813641 | 0.587230811483223 | 0.586065112510035 | 0.568496548596051 | 0.578835899052763 | 0.575812707425327 | 0.573507573507574 | 0.552592131999423 | 0.548057677822017
+ Cost of Goods & Services | IS_COG_AND_SERVICES_SOLD | — | — | — | 0.518792994207096 | 0.535625077007516 | 0.555130682396013 | 0.561366253279725 | 0.569815717009108 | 0.571266525854651 | 0.568697719065685 | 0.568119097002006 | 0.568959110809545 | 0.565468910614735 | 0.546923502147383 | 0.553688193121222 | 0.548955709277993 | 0.548614099634508 | 0.527542443454992 | 0.522732163994404
+ COGS ex R&D (doesn't include D&A)
+ Research & Development |  |  |  |  |  |  |  |  | 0.05785095 | 0.05882112 | 0.0544316 | 0.05174069000000001 | 0.05068741 | 0.04729172 | 0.04488825 | 0.04620351 | 0.04775614 | 0.04840498 | 0.04690155
+ Depreciation & Amortization | IS_DA_COST_OF_REVENUE_GAAP | — | — | — | 0.0268600651701665 | 0.0267258084389036 | 0.025404250991559 | 0.0241614285444627 | 0.0205359034102944 | 0.0194594383165141 | 0.018914842071582 | 0.0181353811344041 | 0.0182717006736781 | 0.0205962018953008 | 0.0215730464486683 | 0.0251477059315412 | 0.0268569981473336 | 0.0248934738730657 | 0.025049688544431 | 0.0253255138276122
Gross Profit | GROSS_PROFIT | 0.565436830709813 | 0.565089743589744 | 0.553842647980402 | 0.454346940622737 | 0.43764911455358 | 0.419465066612428 | 0.414472318175812 | 0.409648379580597 | 0.409274035828835 | 0.412387438862732 | 0.41374552186359 | 0.412769188516777 | 0.413934887489964 | 0.431503451403949 | 0.421164100947237 | 0.424187292574673 | 0.426492426492426 | 0.447407868000577 | 0.451942323491556 | 0.46829 | 0.46863
+ Other Operating Income | IS_OTHER_OPER_INC | — | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Operating Expenses | IS_OPERATING_EXPN | 0.375519339926268 | 0.371948717948718 | 0.357181108642397 | 0.247816346850109 | 0.237530382965377 | 0.235391030204414 | 0.231506125299658 | 0.23304384664266 | 0.231782445435344 | 0.228267129862413 | 0.221875589228475 | 0.217951824746765 | 0.189177427463103 | 0.208473303000666 | 0.199036313040617 | 0.203806629613339 | 0.194820072371093 | 0.196500149898402 | 0.198213709243517
+ Selling, General & Admin | IS_SGA_EXPENSE | 0.28288665223243 | — | 0.270084885774512 | 0.247816346850109 | 0.237530382965377 | 0.235391030204414 | 0.231506125299658 | 0.23304384664266 | 0.231782445435344 | 0.228267129862413 | 0.216536107920945 | 0.217547941000662 | 0.220510665756282 | 0.217162052982948 | 0.205828729660448 | 0.202627054260466 | 0.195971706175788 | 0.197166365019265 | 0.198966964381793
+ R&D | IS_OPERATING_EXPENSES_RD | — | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Other Operating Expense | IS_OTHER_OPERATING_EXPENSES | — | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00533948130753012 | 0.000403883746102522 | -0.0313332382931789 | -0.00868874998228232 | -0.00679241661983029 | 0.00117957535287297 | -0.00115163380469503 | -0.000666215120862527 | -0.000753255138276122
Operating Income (Loss) | IS_OPER_INC | 0.189917490783545 | 0.193141025641026 | 0.196661539338005 | 0.206530593772629 | 0.200118731588203 | 0.184074036408014 | 0.182966192876154 | 0.176604532937937 | 0.177491590393491 | 0.18412030900032 | 0.191869932635115 | 0.194817363770012 | 0.224757460026861 | 0.223030148403283 | 0.22212778790662 | 0.220380662961334 | 0.231672354121334 | 0.250907718102175 | 0.253728612934467 | 0.257820455910385 | 0.262060211554109
- Non-Operating (Income) Loss | IS_NONOP_INCOME_LOSS | — | — | — | -0.011676321506155 | -0.0103610112346965 | -0.00849181328180616 | -0.00761651282632086 | -0.00577208218597755 | -0.00465461941641242 | -0.00460757873565845 | -0.000531376951953239 | 0.000266563272427664 | 0.0204836543439603 | 0.0023812561125994 | -0.00190544078739942 | -0.00168605968518 | -0.000321245219204403 | 0.00305903776329377 | 0.00570859786936404
+ Interest Expense, Net | IS_NET_INTEREST_EXPENSE | -0.00988940253964538 | -0.00898717948717949 | -0.00786190394804307 | -0.0114160934105721 | -0.0101033860904824 | -0.00123055018814197 | -0.00731449496951507 | -0.00569794535056132 | -0.00465461941641242 | -0.00460757873565845 | -0.000531376951953239 | 0.000266563272427664 | 0.00144060865715765 | 0.00228912417967144 | 0.001549027402706 | 0.00154611006704253 | 0.00247904329536983 | 0.00576276079546085 | 0.00793608092112343
+ Interest Expense | IS_INT_EXPENSE | 0.0106501258119258 | 0.0121666666666667 | 0.00917222127271691 | 0.00376765025343954 | 0.000963294017496107 | 0.000874605918844707 | 0.000726730467938917 | 0.00096377886041093 | 0.000596495345380584 | 0.000594231384559126 | 0.00481667495157613 | 0.00646213993764035 | 0.00770575568177555 | 0.00920610622103159 | 0.00734074490397401 | 0.00397856771562238 | 0.00496414782129068 | 0.0140626908428732 | 0.0183848057677822
- Interest Income | IS_INT_INC | 0.0205395283515712 | 0.0211538461538462 | 0.01703412522076 | 0.0151837436640116 | 0.0110666801079785 | 0.00210515610698668 | 0.00804122543745399 | 0.00666172421097225 | 0.00525111476179301 | 0.00520181012021758 | 0.00534805190352937 | 0.00619557666521269 | 0.0062651470246179 | 0.00691698204136015 | 0.00579171750126801 | 0.00243245764857984 | 0.00248510452592085 | 0.00829993004741231 | 0.0104487248466588
+ Foreign Exch (Gain) Loss | IS_FOREIGN_EXCH_LOSS | 0 | 0 | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | — | —
+ Other Non-Op (Income) Loss | IS_OTHER_NON_OPERATING_INC_LOSS | — | — | — | -0.000260228095582911 | -0.000257625144214075 | -0.00726126309366419 | -0.000302017856805784 | -7.41368354162254e-05 | 0 | 0 | 0 | 0 | 0.0190430456868027 | 9.21319329279528e-05 | -0.00345446819010542 | -0.00323216975222253 | -0.00280028851457423 | -0.00270372303216709 | -0.00222748305175939
Pretax Income (Loss), Adjusted | PRETAX_INC | 0.199133945813096 | 0.208141025641026 | 0.206460434113827 | 0.218206915278783 | 0.210479742822899 | 0.19256584968982 | 0.190582705702475 | 0.182376615123914 | 0.182146209809904 | 0.188727887735978 | 0.192401309587069 | 0.194550800497585 | 0.204273805682901 | 0.220648892290683 | 0.224033228694019 | 0.222066722646514 | 0.231993599340538 | 0.247848680338881 | 0.248020017035462 | 0.254049507794344 | 0.259532904307518
- Abnormal Losses (Gains) | IS_ABNORMAL_ITEM | — | -0.00214576923076923 | -0.00505896427961032 | 0.00322456553222303 | 0.00178097382304513 | -0.00249160988508085 | -0.00777695981274893 | 0.00126032620207583 | -0.00161347101619338 | -0.000575947341957307 | 0.00087420079192307 | -0.00990322945443384 | 0.0330064452231068 | 0.0076398633612564 | 0.00589452905454496 | -0.00193263758380316 | 0.00141832794894019 | 0.00148232864391912 | 0.00019369416302043
+ Disposal of Assets | IS_GAIN_LOSS_DISPOSAL_ASSETS | — | — | — | -0.000248913830557567 | 0.000257625144214075 | -0.00018305705278145 | -0.00622911829661929 | -0.000233001482736708 | — | — | -0.00119131284389516 | — | -5.25221906255393e-05 | -0.00111267026689912 | -1.37082071035929e-05 | -0.000653098217974862 | -0.000454592291326985 | — | -0.000860863015172711
+ Asset Write-Down | IS_IMPAIRMENT_ASSETS | — | — | — | — | — | 0.00118987084307943 | 0.000207637276553976 | — | — | — | — | — | — | — | — | 0.00132618923854079 | 0.00139408302673609 | 0.000116587646150942
+ Impairment of Goodwill | IS_IMPAIRMENT_GOODWILL_INTANGIBL | — | — | — | — | — | — | — | 0.00452234696038975 | — | — | — | — | — | — | — | — | — | —
+ Impairment of Intangibles | IS_IMPAIR_OF_INTANG_ASSETS | — | — | — | — | 0.000761674339415527 | — | — | — | — | — | — | — | — | — | 0.00204937696198714 | — | — | —
+ Gain/Loss on Sale/Acquisition of Business | IS_SALE_OF_BUSINESS | — | — | — | — | — | — | — | — | — | — | -0.00249404343578052 | -0.0165915442898916 | — | — | 0.00199454413357277 | — | — | —
+ Legal Settlement | IS_LEGAL_LITIGATION_SETTLEMENT | — | — | — | — | 0.0010305005768563 | — | — | — | — | — | — | — | 0.0024985556397578 | — | 0.00171352588794912 | -0.00204593013181921 | — | 6.66215120862526e-05
+ Restructuring | IS_RESTRUCTURING_EXPENSES | — | — | — | — | — | — | — | — | — | — | 0.00413102727163647 | 0.00686602368374287 | 0.0303728325217404 | 0.0023812561125994 | 0.0017409423021563 | 0.000193263758380316 | — | — | 0.000521898202948456
+ Sale of Investments | IS_GAIN_LOSS_ON_INVESTMENTS | — | — | — | 0.00347347936278059 | -0.000268826237440774 | -0.00349842367537883 | -0.0023028861581441 | -0.00302901927557721 | -0.00161347101619338 | -0.000447959043744572 | 0.000428529799962289 | -0.00017770884828511 | 0.000187579252234069 | -0.00104888662102592 | -0.000897887565285336 | -0.000753062230930199 | 0.000266694144245165 | 0.000816113523056595 | 0.000301302055310449
+ Other Abnormal Items | IS_OTHER_ONE_TIME_ITEMS | — | — | — | — | — | — | 0.000547407365460483 | — | — | -0.000127988298212735 | — | — | — | 0.00742016413658205 | -0.000692264458731443 | — | 0.000212143069285926 | 0.000483005962625332
Pretax Income (Loss), GAAP | PRETAX_INC | 0.199133945813096 | 0.208141025641026 | 0.206460434113827 | 0.21498234974656 | 0.208698768999854 | 0.195057459574901 | 0.198359665515224 | 0.181116288921839 | 0.183759680826097 | 0.189303835077936 | 0.191527108795146 | 0.204454029952019 | 0.171267360459794 | 0.213009028929427 | 0.218138699639474 | 0.223999360230317 | 0.230575271391598 | 0.246366351694962 | 0.247826323513834 | 0.254049507794344 | 0.259532904307518
- Income Tax Expense (Benefit) | IS_INC_TAX_EXP | 0.0759699221721575 | 0.0772179487179487 | 0.0740955961943827 | 0.0650570238957277 | 0.0734679704739182 | 0.0684429980677311 | 0.0685674915529381 | 0.0622643507731413 | 0.0622506453884065 | 0.0634639118709147 | 0.063533828142409 | 0.0644356128531964 | 0.0298401074453957 | 0.0505166475315729 | 0.0490822355344145 | 0.0508283684540232 | 0.0518356436723784 | 0.0569391856630506 | 0.0564134294630367
+ Current Income Tax | IS_CURRENT_INCOME_TAX_BENEFIT | — | — | — | 0.0704765568428675 | 0.0627037198830606 | 0.0577341604800163 | 0.0651603526058478 | 0.0586951916966744 | 0.0659567394195416 | 0.0648626411299538 | 0.0634738339704143 | 0.0637813211845103 | 0.0412449259812271 | 0.0498575498575499 | 0.0473001686109474 | 0.0675623442227465 | 0.0496172332907027 | 0.061386171594808
+ Deferred Income Tax | IS_DEFERRED_INCOME_TAX_BENEFIT | — | — | — | -0.00541953294713975 | 0.0107642505908577 | 0.0107088375877148 | 0.00340713894709025 | 0.00356915907646685 | -0.0037060940311351 | -0.00139872925903917 | 5.99941719947205e-05 | 0.000654291668686085 | -0.0114048185358314 | 0.000659097674023047 | 0.00178206692346708 | -0.0167339757687233 | 0.00221841038167569 | -0.00444698593175736
+ Tax Allowance/Credit | IS_TAX_VALN_ALLOWNCE_CREDITS | — | — | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | — | —
Income (Loss) from Cont Ops | IS_INC_BEF_XO_ITEM | 0.123164023640939 | 0.130923076923077 | 0.132364837919444 | 0.149925325850833 | 0.135230798525936 | 0.12661446150717 | 0.129792173962286 | 0.118851938148697 | 0.121509035437691 | 0.125839923207021 | 0.127993280652737 | 0.140018417098822 | 0.141427253014399 | 0.162492381397854 | 0.16905646410506 | 0.173170991776294 | 0.17873962771922 | 0.189427166031912 | 0.191412891423652 | 0.196035511919994 | 0.200458613802796
- Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | -0.104175200421324 | -0.0150641025641026 | -0.00843160713268387 | -0.000848569876900797 | -0.000459244822294656 | -0.000935624936438523 | -0.00125526171734904 | -0.0300360093200593 | -0.026724947195494 | -0.00694793618869132 | 7.71353639932121e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Discontinued Operations | IS_DISCONTINUED_OPERATIONS | — | — | — | -0.000848569876900797 | -0.000459244822294656 | -0.000935624936438523 | -0.00125526171734904 | -0.0300360093200593 | -0.026724947195494 | -0.00694793618869132 | 7.71353639932121e-05 | 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 | 0 | 0
Income (Loss) Incl. MI | NI_INCLUDING_MINORITY_INT_RATIO | 0.227339224062262 | 0.145987179487179 | 0.140796445052128 | 0.150773895727734 | 0.135690043348231 | 0.127550086443608 | 0.131047435679635 | 0.148887947468757 | 0.148233982633185 | 0.132787859395712 | 0.127916145288743 | 0.140018417098822 | 0.141427253014399 | 0.162492381397854 | 0.16905646410506 | 0.173170991776294 | 0.17873962771922 | 0.189427166031912 | 0.191412891423652
- Minority Interest | MIN_NONCONTROL_INTEREST_CREDITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income, GAAP | NET_INCOME | 0.227339224062262 | 0.145987179487179 | 0.140796445052128 | 0.150773895727734 | 0.135690043348231 | 0.127550086443608 | 0.131047435679635 | 0.148887947468757 | 0.148233982633185 | 0.132787859395712 | 0.127916145288743 | 0.140018417098822 | 0.141427253014399 | 0.162492381397854 | 0.16905646410506 | 0.173170991776294 | 0.17873962771922 | 0.189427166031912 | 0.191412891423652 | 0.196035511919994 | 0.200458613802796
- Preferred Dividends | IS_TOT_CASH_PFD_DVD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0 | 0
Net Income Avail to Common, GAAP | EARN_FOR_COMMON | 0.227339224062262 | 0.145987179487179 | 0.140796445052128 | 0.150773895727734 | 0.135690043348231 | 0.127550086443608 | 0.131047435679635 | 0.148887947468757 | 0.148233982633185 | 0.132787859395712 | 0.127916145288743 | 0.140018417098822 | 0.141427253014399 | 0.162492381397854 | 0.16905646410506 | 0.173170991776294 | 0.17873962771922 | 0.189427166031912 | 0.191412892080439 | 0.196035511919994 | 0.200458613802796
Net Abnormal Losses (Gains) | IS_NET_ABNORMAL_ITEMS | — | -0.00214576923076923 | -0.00442089671281262 | -0.0114811504344678 | -0.000208900388677935 | -0.00161954642530255 | -0.0050550238782868 | 0.0024020334674857 | -0.0010487561605257 | -0.000374365772272249 | 0.000568230514749996 | -0.00643709914538199 | 0.00928112127373815 | 0.00565605023316466 | 0.00390855255041193 | -0.00144934490250177 | 0.00111653927980459 | 0.00116432195956074 | 0.00027601420423975
Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | -0.104175200421324 | -0.0150641025641026 | -0.00843160713268387 | -0.000848569876900797 | -0.000459244822294656 | -0.000935624936438523 | -0.00125526171734904 | -0.0300360093200593 | -0.026724947195494 | -0.00694793618869132 | 7.71353639932121e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Basic Weighted Avg Shares | IS_AVG_NUM_SH_FOR_EPS | 0.0840891801743812 | 0.070474358974359 | 0.0594200421580357 | 0.0569333816075308 | 0.0560614715996281 | 0.0501881419709143 | 0.0459916567567057 | 0.0511226435077314 | 0.0468297739184855 | 0.0432051926680989 | 0.0391676237165533 | 0.0361718283009419 | 0.0330589674137323 | 0.0308287621720458 | 0.0295274781011392 | 0.0284097724819065 | 0.0253844335476989 | 0.0229677662917356 | 0.0221187990960938
Basic EPS, GAAP | IS_EPS | 0.000394990929837907 | 0.000265384615384615 | 0.00027003930951974 | 0.000299828023171615 | 0.000271066456086114 | 0.000258313841147158 | 0.000268925571474413 | 0.000308197415801737 | 0.000309982007353516 | 0.000280660053937926 | 0.000280258489175337 | 0.000312606019483352 | 0.000321135679824726 | 0.000373488681946393 | 0.000392740133517937 | 0.0004065203193517 | 0.000426710630792263 | 0.000458022895592987 | 0.000464327988808781 | 0.000476486408857091 | 0.000493379687846734
Basic EPS from Cont Ops, GAAP | IS_EARN_BEF_XO_ITEMS_PER_SH | 0.000213587687986424 | 0.000238461538461538 | 0.000254087620349798 | 0.000297565170166546 | 0.000269946346763444 | 0.00025627987389403 | 0.000266153236310097 | 0.000245710654522347 | 0.000253266056481264 | 0.00026603281985647 | 0.000280258489175337 | 0.000312606019483352 | 0.000321135679824726 | 0.000373488681946393 | 0.000392740133517937 | 0.0004065203193517 | 0.000426710630792263 | 0.000458022895592987 | 0.000464327988808781 | 0.000476486408857091 | 0.000493379687846734
Basic EPS from Cont Ops, Adjusted | IS_BASIC_EPS_CONT_OPS | 0.000213587687986424 | 0.000234615384615385 | 0.000246111775764827 | 0.000275127511766836 | 0.000269774073949617 | 0.000253282518051459 | 0.000255976083960964 | 0.00025119942808727 | 0.000251535339904561 | 0.000265479361886913 | 0.000281316186427604 | 0.000298305788461849 | 0.000342052567209646 | 0.00038654809995606 | 0.00040149727892089 | 0.000402818785237315 | 0.000429456004558045 | 0.000460699747948613 | 0.000464935058646293 | 0.000476538632268846 | 0.000493429001158863
Diluted Weighted Avg Shares | IS_SH_FOR_DILUTED_EPS | 0.0848937913277547 | 0.071525641025641 | 0.0600695037885262 | 0.0572275524981897 | 0.0564199065828825 | 0.0506762941116648 | 0.0464541215999396 | 0.0515886464732048 | 0.0472404756316984 | 0.043497737349728 | 0.0393476062325374 | 0.0363737701739931 | 0.0332615530061451 | 0.0310130260379017 | 0.0296577060686233 | 0.0285297292974529 | 0.0255238418503725 | 0.0230788021452127 | 0.0221941246099214
Diluted EPS, GAAP | IS_DILUTED_EPS | 0.000392065071098367 | 0.000261538461538462 | 0.000266621090411895 | 0.000297565170166546 | 0.000268826237440774 | 0.00025627987389403 | 0.000255797799044869 | 0.00030607922050413 | 0.00030704842368771 | 0.000278831649677744 | 0.000278544369975488 | 0.000310990484498942 | 0.000318884728797917 | 0.000371362560417287 | 0.000390683902452398 | 0.000404521039092593 | 0.000424286138571853 | 0.000455802178523445 | 0.000462175831270849 | 0.000476486408857091 | 0.000493379687846734
Diluted EPS from Cont Ops, GAAP | IS_DIL_EPS_BEF_XO | 0.000212124758616654 | 0.000234615384615385 | 0.000250669401241953 | 0.000296433743664012 | 0.000268826237440774 | 0.000254245906640903 | 0.000263321818902543 | 0.000243592459224741 | 0.000251310334037393 | 0.000264204415596288 | 0.000278544369975488 | 0.000310990484498942 | 0.000318884728797917 | 0.000371362560417287 | 0.000390683902452398 | 0.000404521039092593 | 0.000424286138571853 | 0.000455802178523445 | 0.000462175831270849 | 0.000476486408857091 | 0.000493379687846734
Diluted EPS from Cont Ops, Adjusted | IS_DIL_EPS_CONT_OPS | 0.000212124758616654 | 0.000230769230769231 | 0.000242693556656982 | 0.000273734725742216 | 0.00026841146095859 | 0.000250995728668768 | 0.000253051512920701 | 0.000248523723787333 | 0.000249139482124697 | 0.000263417561822919 | 0.000279782049743739 | 0.00029669534241264 | 0.00033982119945677 | 0.000384287749287749 | 0.000399716856982275 | 0.000401135524544497 | 0.000426937623876399 | 0.000458603057927405 | 0.000462839287635855 | 0.000476538632268846 | 0.000493429001158863
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 | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP
EBITDA | EBITDA | 0.236936040727954 | 0.235358974358974 | 0.237885261778613 | 0.247940803765387 | 0.241170738264055 | 0.221519373538086 | 0.218764746965664 | 0.211607710230883 | 0.212792380505359 | 0.209525986195548 | 0.216604672688939 | 0.220350894198614 | 0.253089430284295 | 0.252016271916769 | 0.266247652469534 | 0.264931291401762 | 0.271664353297006 | 0.288909738954708 | 0.290993220703756 | 0.285501684205029 | 0.288648420741179
EBITDA Margin (T12M) | EBITDA_MARGIN | 0.00346620691673006 | 0.00301742269230769 | 0.0027104798040221 | 0.0028052679217958 | 0.00270137594229197 | 0.00225281572256687 | 0.00206471440436416 | 0.00224113228129634 | 0.00208081416725338 | 0.00191549106367418 | 0.00185643111811995 | 0.00177992285820449 | 0.00189897304110987 | 0.00178605739110714 | 0.00182488896352246 | 0.00176557299372226 | 0.00164662025784475 | 0.00160396697793718 | 0.00156565813356158 | 0.00149098720111251 | 0.00142342096674399
EBITA | EBITA | — | — | — | 0.230313178855902 | 0.224077870000112 | 0.20664090308146 | 0.204909677784699 | 0.199555178987503 | 0.200657122741141 | 0.197897335100791 | 0.204982944513961 | 0.208452479038434 | 0.232493228388994 | 0.230443225468101 | 0.241099946537992 | 0.238074293254428 | 0.246770879423941 | 0.279110824885355 | 0.285946411277306
EBIT | EBIT | 0.189917490783545 | 0.193141025641026 | 0.196661539338005 | 0.206530593772629 | 0.200118731588203 | 0.184074036408014 | 0.182966192876154 | 0.176604532937937 | 0.177491590393491 | 0.18412030900032 | 0.191869932635115 | 0.194817363770012 | 0.224757460026861 | 0.223030148403283 | 0.22212778790662 | 0.220380662961334 | 0.231672354121334 | 0.250907718102175 | 0.253728612934467 | 0.257820455910385 | 0.262060211554109
Gross Margin | [NAME] | 0.00827194145356662 | 0.00724474025641026 | 0.00631051842989802 | 0.00514060169261405 | 0.00490214848169181 | 0.00426589108105359 | 0.00391181380599128 | 0.00433857636094048 | 0.00400213212860831 | 0.00377005476070759 | 0.00354604569841787 | 0.00333421533465807 | 0.00310582388559166 | 0.00305809591642925 | 0.00288670235369916 | 0.00282689758353659 | 0.00258506894649752 | 0.0024839157348908 | 0.00243162768846435 | 0.00244557014909784 | 0.00231096974628301
Operating Margin | OPER_MARGIN | 0.00277835873954005 | 0.00247616705128205 | 0.00224077411268729 | 0.00233674183110065 | 0.00224154855113859 | 0.00187200284755415 | 0.00172684551786624 | 0.00187041442490998 | 0.00173562143080654 | 0.00168323179595008 | 0.00164443965443357 | 0.00157367130325207 | 0.00168639345123315 | 0.00158063067851625 | 0.0015224868743917 | 0.00146867567675637 | 0.0014042195256481 | 0.00139298764170951 | 0.00136515986728972 | 0.00134642638279962 | 0.00129230570088571
Profit Margin | PROF_MARGIN | 0.0033258122183861 | 0.00187163051282051 | 0.00160424371902239 | 0.00156639414373642 | 0.00151239288954602 | 0.00127117787043629 | 0.00117727645959567 | 0.00128419794535056 | 0.00117793436595478 | 0.00114700882205056 | 0.001101848763263 | 0.00107902647861839 | 0.00113079053400062 | 0.00119167999036158 | 0.00118552015791855 | 0.00114439901635411 | 0.00109014971239461 | 0.00105812443788099 | 0.0010313618079624 | 0.0010237716894384 | 0.00098703833994629
Sales per Employee | ACTUAL_SALES_PER_EMPL | 21.7391304347826 | 21.7391304347436 | 21.276595744659 | 22.2222222222348 | 21.2765957447047 | 19.6078431372928 | 17.543859649093 | 16.666666666702 | 16.3934426229172 | 18.1818181818348 | 17.5438596491198 | 17.2413793103281 | 17.5438596491518 | 17.241379310357 | 17.2413793103401 | 17.8571428571714 | 16.6666666666869 | 15.8730158730194
Dividends per Share | EQY_DPS | 0.000103867985253672 | 0.000112179487179487 | 0.000125334700620976 | 0.000144822592324403 | 0.000151214758560435 | 0.000144411674972033 | 0.000145817996489042 | 0.000180046600296547 | 0.000183837909723852 | 0.000178269415367738 | 0.000178268396784312 | 0.00018093991825393 | 0.000189079886251941 | 0.000216864395968874 | 0.000241264445023235 | 0.000246577898623162 | 0.000245479837316572 | 0.000265930869077625 | 0.000277090283008716 | 0.000262944878188892 | 0.000267475404985576
Total Cash Common Dividends | IS_TOT_CASH_COM_DVD | 0.0597752940488033 | 0.0616282051282051 | 0.0652538027687575 | 0.0728747284576394 | 0.0757193902124847 | 0.0712671615986983 | 0.0710571096891104 | 0.0869084939631434 | 0.0880399749667527 | 0.0842501257027929 | 0.0814686573304308 | 0.0810248953941098 | 0.0833085978826054 | 0.09433601224646 | 0.10393672291601 | 0.105116158183054 | 0.10280695586818 | 0.110015600537414 | 0.114214462498655
Capitalized Interest Expense | IS_CAP_INT_EXP | — | — | — | — | — | — | 0 | — | — | — | — | — | — | — | — | — | — | —
Depreciation Expense | IS_DEPR_EXP | — | — | — | 0.0176276249094859 | 0.0170928682639426 | 0.0148784704566257 | 0.0138550691809653 | 0.0120525312433806 | 0.0121352577642181 | 0.0116286510947571 | 0.0116217281749773 | 0.0118984151601803 | 0.0205962018953008 | 0.0215730464486683 | 0.0251477059315412 | 0.0268569981473336 | 0.0248934738730657 | 0.00979891406935299 | 0.00504680942645002
Rental Expense | BS_CURR_RENTAL_EXPENSE | 0.0478377903914799 | 0.036025641025641 | 0.0281889135760269 | 0.021972302679218 | 0.0196467175196299 | 0.0161903793348927 | 0.0238405345716066 | 0.028606227494175 | 0.0299225533912227 | 0.021748868674864 | 0.0232520269459538 | 0.0189421476922083 | 0.0176249465399131 | 0.0191421808337231 | 0.0120974927689208 | 0.011109333973103 | 0.00953431565676464 | 0.00851089816901878 | 0.00823738297643387
Source: Bloomberg |  | Right click to show data transparency (not supported for all values)