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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00
In Millions of USD except Per Share |  | FY 2007 | FY 2008 | FY 2009 | FY 2010 | FY 2012 | FY 2013 | FY 2014 | FY 2015 | FY 2016 | FY 2017 | FY 2018 | FY 2019 | FY 2020 | FY 2021 | FY 2022 | FY 2023 | FY 2024 | Last 12M | FY 2025 Est | FY 2026 Est
12 Months Ending |  | 12/31/2007 | 12/31/2008 | 12/31/2009 | 12/31/2010 | 01/31/2012 | 01/31/2013 | 01/31/2014 | 01/31/2015 | 01/31/2016 | 01/31/2017 | 01/31/2018 | 01/31/2019 | 01/31/2020 | 01/31/2021 | 01/31/2022 | 01/31/2023 | 01/31/2024 | 01/31/2024 | 01/31/2025 | 01/31/2026
Revenue | SALES_REV_TURN | 0.455 | 6.398 | 25.245 | 68.055 | 134.427 | 273.657 | 468.938 | 787.86 | 1156.69 | 1574.44 | 2143.05 | 2822.18 | 3627.206 | 4317.996 | 5138.798 | 2 | 7259 | 7258.753 | 8404.371 | 9802.879
+ Sales & Services Revenue | IS_SALES_AND_SERVICES_REVENUES | — | — | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0.08 | 1 | 1
- Cost of Revenue | IS_COGS_TO_FE_AND_PP_AND_G | 10.3758241758242 | 1.76758361988121 | 0.812240047534165 | 0.585761516420542 | 0.486271359176356 | 0.425843300189653 | 0.377043447108147 | 0.336104130175412 | 0.323705573662779 | 0.30712189730952 | 0.293699633699634 | 0.295852851341871 | 0.293685553012429 | 0.277474087516524 | 0.277904482721446 | 0.275937615934057 | 0.24397299903568 | 0.244089308452843
+ Cost of Goods & Services | IS_COG_AND_SERVICES_SOLD | — | — | 0.812240047534165 | 0.585761516420542 | 0.486271359176356 | 0.425843300189653 | 0.377043447108147 | 0.336104130175412 | 0.323705573662779 | 0.30712189730952 | 0.293699633699634 | 0.295852851341871 | 0.293685553012429 | 0.277474087516524 | 0.277904482721446 | 0.275937615934057 | 0.24397299903568 | 0.244089308452843
Gross Profit | GROSS_PROFIT | -9.37582417582418 | -0.767583619881213 | 0.187759952465835 | 0.414238483579458 | 0.513728640823644 | 0.574156699810347 | 0.622956552891853 | 0.663895869824588 | 0.676294426337221 | 0.69287810269048 | 0.706300366300366 | 0.70414714865813 | 0.706314446987571 | 0.722525912483476 | 0.722095517278554 | 0.724062384065943 | 0.75602700096432 | 0.755910707556923 | 0.80161 | 0.8077
+ 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 | 46.167032967033 | 7.27446076899031 | 2.22360863537334 | 1.23799867754022 | 1.09727212539148 | 1.00485279017164 | 0.949827056028729 | 0.937678013860331 | 0.88190612869481 | 0.899939661085846 | 0.828941461935092 | 0.839560552480707 | 0.809813944948261 | 0.754395557568835 | 0.714837205120731 | 0.771956321758456 | 0.730816916930707 | 0.730656767078312
+ Selling, General & Admin | IS_SGA_EXPENSE | 21.156043956044 | 3.23835573616755 | 1.03347197464845 | 0.662361325398575 | 0.635951111011925 | 0.629693375283658 | 0.561468680294623 | 0.535489807833879 | 0.482870086194227 | 0.480699169228424 | 0.419073283404494 | 0.430106159068522 | 0.403866226511535 | 0.37172498538674 | 0.368345087703389 | 0.394506402857999 | 0.391376222620196 | 0.391222431731731
+ Selling & Marketing | IS_SELLING_EXPENSES | 17.6901098901099 | 2.58971553610503 | 0.826896415131709 | 0.536683564763794 | 0.523377000156219 | 0.451075616556492 | 0.42089359360939 | 0.400883405681212 | 0.356230277775376 | 0.356959934961002 | 0.316744826298966 | 0.308846352819452 | 0.304855583057593 | 0.277299006298292 | 0.275251916887957 | 0.2973209640308 | 0.29466868714699 | 0.294628981038479
+ General & Administrative | IS_GENERAL_AND_ADMINISTRATIVE | — | — | 0.206575559516736 | 0.125677760634781 | 0.112574110855706 | 0.178617758727166 | 0.140575086685233 | 0.134606402152667 | 0.12663980841885 | 0.123739234267422 | 0.102328457105527 | 0.12125980624907 | 0.0990106434539422 | 0.0944259790884475 | 0.0930931708154319 | 0.0971854388271986 | 0.0967075354732057 | 0.0965934506932527
+ Research & Development | IS_OPERATING_EXPENSES_RD | — | — | 1.1901366607249 | 0.57563735214165 | 0.461321014379552 | 0.37515941488798 | 0.388358375734106 | 0.402188206026451 | 0.400057923903552 | 0.420465689387973 | 0.414108863535615 | 0.42187316188195 | 0.418840837823934 | 0.392231720455508 | 0.359283435542709 | 0.365303488615658 | 0.339440694310511 | 0.339434335346581
+ Other Operating Expense | IS_OTHER_OPERATING_EXPENSES | — | — | 0 | 0 | 0 | 0 | 0 | 0 | -0.00102188140296882 | -0.00122519753055055 | -0.00424068500501621 | -0.0124187684697645 | -0.0128931193872088 | -0.00956114827341202 | -0.0127913181253671 | 0.0121464302847992 | 0 | 0
Operating Income (Loss) | IS_OPER_INC | -55.5428571428571 | -8.04204438887152 | -2.03584868290751 | -0.823760193960767 | -0.583543484567832 | -0.430696090361292 | -0.326870503136875 | -0.273782144035742 | -0.205611702357589 | -0.207061558395366 | -0.122641095634726 | -0.135413403822577 | -0.103499497960689 | -0.031869645085359 | 0.00725831215782368 | -0.0478939376925129 | 0.0252100840336134 | 0.0252539244688447 | 0.245554009931261 | 0.253213265205048
- Non-Operating (Income) Loss | IS_NONOP_INCOME_LOSS | — | — | -0.020479302832244 | 0.000837557857615164 | 0.00757288342371696 | 0.00439601398831384 | 0.0374228576059095 | 0.038420531566522 | 0.0209580786554738 | 0.0111099819618404 | 0.00540864655514337 | -0.0137879228114436 | -0.00545406023258673 | 0.00614521180658806 | -0.0258099267571911 | -0.0281481858059551 | -0.0264499242319879 | -0.0317628937091536
+ Interest Expense, Net | IS_NET_INTEREST_EXPENSE | — | — | -0.0175876411170529 | 0.00195430166776872 | 0.00675459543097741 | 0.00293433020167582 | 0.0375870584171042 | 0.0356662351179143 | 0.0234090378580259 | 0.0119407535377658 | 0.00900445626560276 | 0.00628875550106655 | 0.00480176753126235 | 0.0115836142506848 | 0.00214583254683294 | 0.000747126122418642 | -0.0257611241217799 | -0.0257620007183052
+ Interest Expense | IS_INT_EXPENSE | 0 | 0 | 0 | 0.00324737344794651 | 0.0072604461901255 | 0.00498068750296905 | 0.0418349547274906 | 0.0394232477851395 | 0.0276063595258885 | 0.0191198140291151 | 0.0207876624437134 | 0.0213342168111176 | 0.0161791196860614 | 0.015934706748223 | 0.00323071659948494 | 0.0164665374694047 | 0.0157046425127428 | 0.0157051769084855
- Interest Income | IS_INT_INC | — | — | 0.0175876411170529 | 0.0012930717801778 | 0.000505850759148088 | 0.00204635730129323 | 0.00424789631038645 | 0.00375701266722514 | 0.00419732166786261 | 0.00717906049134931 | 0.0117832061781106 | 0.0150454613100511 | 0.011377352154799 | 0.00435109249753821 | 0.001084884052652 | 0.015719411346986 | 0.0414657666345227 | 0.0414671776267907
+ 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
+ (Income) Loss from Affiliates | INCOME_LOSS_FROM_AFFILIATES | — | — | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Other Non-Op (Income) Loss | IS_OTHER_NON_OPERATING_INC_LOSS | — | — | -0.00289166171519113 | -0.00111674381015355 | 0.000818287992739554 | 0.00146168378663802 | -0.000164200811194657 | 0.00275429644860762 | -0.00245095920255211 | -0.000830771575925408 | -0.00359580971045939 | -0.0200766783125102 | -0.0102558277638491 | -0.00543840244409675 | -0.027955759304024 | -0.0288953119283737 | -0.000688800110208018 | -0.00600089299084843
Pretax Income (Loss), Adjusted | PRETAX_INC | -54.4637362637363 | -8.0423569865583 | -2.01536938007526 | -0.824597751818382 | -0.591116367991549 | -0.435092104349606 | -0.364293360742785 | -0.312202675602264 | -0.226569781013063 | -0.218171540357206 | -0.12804974218987 | -0.121625481011133 | -0.0980454377281025 | -0.0380148568919471 | 0.0330682389150148 | -0.0197457518865578 | 0.0516600082656013 | 0.057016818480704 | 0.264390160786572 | 0.271356098550232
- Abnormal Losses (Gains) | IS_ABNORMAL_ITEM | 0 | 0 | -0.0406813230342642 | 0 | 0 | 0 | 0 | 0 | 0.0103398490520364 | 0.0266856787175123 | 0.0188371713212478 | 0.0285251117930111 | 0.0349624476801152 | 0.0257031270987745 | 0.0299192534907969 | 0.0220749706635555 | 0.00261744041879047 | 0.00797754108774171
+ Sale of Investments | IS_GAIN_LOSS_ON_INVESTMENTS | — | — | -0.0406813230342642 | — | — | — | — | — | — | -4.12845202103605e-05 | -0.000335969762721355 | -0.000150947140154065 | — | — | — | 0.0220749706635555 | 0.00261744041879047 | 0.00797754104596203
+ Unrealized Investments | IS_UNREALIZED_INVESTMENTS | — | — | — | — | — | — | — | — | — | 0.00952719697162166 | 0.000322904271948858 | -6.87411858917574e-05 | — | — | — | — | —
+ Other Abnormal Items | IS_OTHER_ONE_TIME_ITEMS | — | — | — | — | — | — | — | — | 0.0103398490520364 | 0.017199766266101 | 0.0188502368120202 | 0.0287448001190569 | 0.0349624476801152 | 0.0257031270987745 | 0.0299192534907969 | — | —
Pretax Income (Loss), GAAP | PRETAX_INC | -54.4637362637363 | -8.0423569865583 | -1.974688057041 | -0.824597751818382 | -0.591116367991549 | -0.435092104349606 | -0.364293360742785 | -0.312202675602264 | -0.2369096300651 | -0.244857219074719 | -0.146886913511117 | -0.150150592804144 | -0.133007885408218 | -0.0637179839907216 | 0.00314898542421788 | -0.0418207225501133 | 0.0490425678468109 | 0.0490392761119813 | 0.264390160786572 | 0.271356098550232
- Income Tax Expense (Benefit) | IS_INC_TAX_EXP | 0 | 0.00500156298843389 | 0.00360467419290949 | 0.00142531775769598 | 0.00124230995261369 | 0.000453121973857785 | 0.00357829819720304 | 0.00255121468281167 | 0.000879232983772662 | -0.000517009222326668 | 0.00300319637899256 | -0.00194672203757379 | -0.000488805984551195 | 0.00168990429819759 | -0.00256694269749463 | 0.0171818093773016 | -0.141204022592644 | -0.141145593464883
+ Current Income Tax | IS_CURRENT_INCOME_TAX_BENEFIT | — | — | 0.00360467419290949 | 0.00142531775769598 | 0.00124230995261369 | 0.000453121973857785 | 0.00357829819720304 | 0.00294976264818623 | 0.00116366528629105 | 0.00241546200553848 | 0.00206621404073633 | 0.00243287104295261 | 0.00224553003055244 | 0.00249467577089001 | 0.00156904396709114 | 0.0178974030449411 | 0.00482160077145612
+ Deferred Income Tax | IS_DEFERRED_INCOME_TAX_BENEFIT | — | — | 0 | 0 | 0 | 0 | 0 | -0.000398547965374559 | -0.000284432302518393 | -0.00293247122786515 | 0.000936982338256224 | -0.0043795930805264 | -0.00273433601510364 | -0.000804771472692425 | -0.00413598666458577 | -0.000715593667639561 | -0.1460256233641
+ Tax Allowance/Credit | IS_TAX_VALN_ALLOWNCE_CREDITS | — | — | 0 | 0 | 0 | 0 | 0 | 0 | — | — | — | — | — | — | — | — | —
Income (Loss) from Cont Ops | IS_INC_BEF_XO_ITEM | -54.4637362637363 | -8.04735854954673 | -1.97829273123391 | -0.826023069576078 | -0.592358677944163 | -0.435545226323463 | -0.367871658939988 | -0.314753890285076 | -0.237788863048872 | -0.244340209852392 | -0.14989010989011 | -0.148203870766571 | -0.132519079423667 | -0.0654078882889192 | 0.00571592812171251 | -0.0590025319274149 | 0.190246590439454 | 0.190184870596919 | 0.0521519100001654 | 0.0701702020396253
- Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 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 | 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 | -54.4637362637363 | -8.04735854954673 | -1.97829273123391 | -0.826023069576078 | -0.592358677944163 | -0.435545226323463 | -0.367871658939988 | -0.314753890285076 | -0.237788863048872 | -0.244340209852392 | -0.14989010989011 | -0.148203870766571 | -0.132519079423667 | -0.0654078882889192 | 0.00571592812171251 | -0.0590025319274149 | 0.190246590439454 | 0.190184870596919
- Minority Interest | MIN_NONCONTROL_INTEREST_CREDITS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income, GAAP | NET_INCOME | -54.4637362637363 | -8.04735854954673 | -1.97829273123391 | -0.826023069576078 | -0.592358677944163 | -0.435545226323463 | -0.367871658939988 | -0.314753890285076 | -0.237788863048872 | -0.244340209852392 | -0.14989010989011 | -0.148203870766571 | -0.132519079423667 | -0.0654078882889192 | 0.00571592812171251 | -0.0590025319274149 | 0.190246590439454 | 0.190184870596919 | 0.0521519100001654 | 0.0701702020396253
- 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
- Other Adjustments | OTHER_ADJUSTMENTS | 0 | 0 | 0 | 0 | 0.00254413175924479 | 0.00207559097702598 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income Avail to Common, GAAP | EARN_FOR_COMMON | -54.4637362637363 | -8.04735854954673 | -1.97829273123391 | -0.826023069576078 | -0.594902809703408 | -0.437620817300489 | -0.367871658939988 | -0.314753890285076 | -0.237788863048872 | -0.244340209852392 | -0.14989010989011 | -0.148203870766571 | -0.132519079423667 | -0.0654078882889192 | 0.00571592812171251 | -0.0590025319274149 | 0.190246590439454 | 0.190184871051996 | 0.0521519100001654 | 0.0701702020396253
Net Abnormal Losses (Gains) | IS_NET_ABNORMAL_ITEMS | 0 | 0 | -0.0264428599722717 | 0 | 0 | 0 | 0 | 0 | 0.00672090188382367 | 0.017345691166383 | 0.0124645561232822 | 0.0225348383164788 | 0.027620333667291 | 0.0203054704080319 | 0.0236362102577295 | 0.0174392268242088 | 0.00206777793084447 | 0.00630225742631
Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Basic Weighted Avg Shares | IS_AVG_NUM_SH_FOR_EPS | 36.9978021978022 | 3.0559549859331 | 0.868369974252327 | 0.372742634633752 | 0.219286304090696 | 0.270451696832166 | 0.365287095522223 | 0.233165790876552 | 0.164275648618039 | 0.125894921368868 | 0.096952474277315 | 0.0768161492179804 | 0.0626336083475821 | 0.0548909725715355 | 0.0481141698895345 | 0.0409952479303609 | 0.0360027552004408 | 0.0362461706576873
Basic EPS, GAAP | IS_EPS | -3.23076923076923 | -0.41106595811191 | -0.0903149138443256 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00125357701717833 | -0.00123218414166307 | -0.000723268239191806 | -0.000683868498820061 | -0.000584471904821507 | -0.000275590806475967 | 2.33517643620162e-05 | -0.000231667014703455 | 0.000727372916379667 | 0.000723264726048675 | 0.000239994164941076 | 0.000318273845877318
Basic EPS from Cont Ops, GAAP | IS_EARN_BEF_XO_ITEMS_PER_SH | -3.23076923076923 | -0.41106595811191 | -0.0903149138443256 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00125357701717833 | -0.00123218414166307 | -0.000723268239191806 | -0.000683868498820061 | -0.000584471904821507 | -0.000275590806475967 | 2.33517643620162e-05 | -0.000231667014703455 | 0.000727372916379667 | 0.000723264726048675 | 0.000239994164941076 | 0.000318273845877318
Basic EPS from Cont Ops, Adjusted | IS_BASIC_EPS_CONT_OPS | -3.23076923076923 | -0.41106595811191 | -0.0914485640720935 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00121604492128401 | -0.00114519892787277 | -0.000661418538998157 | -0.000579683790544898 | -0.000461732804808991 | -0.000190290356915569 | 0.000118714921271472 | -0.000163109183698751 | 0.000735866786058686 | 0.00074765624343465 | 0.000795538416854753 | 0.000802519341511815
Diluted Weighted Avg Shares | IS_SH_FOR_DILUTED_EPS | 36.9978021978022 | 3.0559549859331 | 0.868369974252327 | 0.372742634633752 | 0.219286304090696 | 0.270451696832166 | 0.365287095522223 | 0.233165790876552 | 0.164275648618039 | 0.125894921368868 | 0.096952474277315 | 0.0768161492179804 | 0.0626336083475821 | 0.0548909725715355 | 0.0494341283700974 | 0.0409952479303609 | 0.0365456674473068 | 0.0370370778562103
Diluted EPS, GAAP | IS_DILUTED_EPS | -3.23076923076923 | -0.41106595811191 | -0.0903149138443256 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00125357701717833 | -0.00123218414166307 | -0.000723268239191806 | -0.000683868498820061 | -0.000584471904821507 | -0.000275590806475967 | 2.33517643620162e-05 | -0.000231667014703455 | 0.000717729714836754 | 0.000709488255076319 | 0.000239994164941076 | 0.000318273845877318
Diluted EPS from Cont Ops, GAAP | IS_DIL_EPS_BEF_XO | -3.23076923076923 | -0.41106595811191 | -0.0903149138443256 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00125357701717833 | -0.00123218414166307 | -0.000723268239191806 | -0.000683868498820061 | -0.000584471904821507 | -0.000275590806475967 | 2.33517643620162e-05 | -0.000231667014703455 | 0.000717729714836754 | 0.000709488255076319 | 0.000239994164941076 | 0.000318273845877318
Diluted EPS from Cont Ops, Adjusted | IS_DIL_EPS_CONT_OPS | -3.23076923076923 | -0.41106595811191 | -0.0915211328976035 | -0.0326206744544853 | -0.0201596405484017 | -0.00591981933588397 | -0.00215380284813771 | -0.00171350239890336 | -0.00121820712550467 | -0.00114519892787277 | -0.000663277105060544 | -0.000579920132663402 | -0.000462895407649855 | -0.000190290356915569 | 0.000116395896472288 | -0.000163229360962628 | 0.00072552431464389 | 0.000733495822216295 | 0.000795538416854753 | 0.000802519341511815
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
EBITDA | EBITDA | — | — | -1.77048920578332 | -0.673558151495114 | -0.461410282160578 | -0.324395136978042 | -0.226827427079912 | -0.174154037519356 | -0.100177229854153 | -0.133457610324941 | -0.0587256480250111 | -0.0652155425947317 | -0.00385475762887468 | 0.0579497989345057 | 0.0922525072983993 | 0.0266643907527537 | 0.0790742526518804 | 0.0748464646751308 | 0.283146353248803 | 0.286485735466081
EBITDA Margin (T12M) | EBITDA_MARGIN | — | — | -7.01322721330957 | -0.98972617735655 | -0.343242265318723 | -0.118540779150542 | -0.0483704519574016 | -0.022104693727312 | -0.0086606809084543 | -0.00847651291887909 | -0.00274028370779963 | -0.00231082142173781 | -0.000106273533954234 | 0.0013420531190858 | 0.00179521572943712 | 0.000428976363207546 | 0.00108932704229233 | 0.00103112014798039 | 0.0033690368172562 | 0.0029224652825571
EBITA | EBITA | — | — | -1.89328579916815 | -0.745558739255014 | -0.52761721975496 | -0.382497067496903 | -0.289309034456581 | -0.232540045185693 | -0.161559276902195 | -0.19189108508422 | -0.112387485126339 | -0.117302936028177 | -0.059269310869027 | 0.00445276003034741 | 0.0410732237383139 | -0.0175775738607533 | 0.0511089681774349 | 0.0533484194874795
EBIT | EBIT | -55.5428571428571 | -8.04204438887152 | -2.03584868290751 | -0.823760193960767 | -0.583543484567832 | -0.430696090361292 | -0.326870503136875 | -0.273782144035742 | -0.205611702357589 | -0.207061558395366 | -0.122641095634726 | -0.135413403822577 | -0.103499497960689 | -0.031869645085359 | 0.00725831215782368 | -0.0478939376925129 | 0.0252100840336134 | 0.0252539244688447 | 0.245554009931261 | 0.253213265205048
Gross Margin | [NAME] | -2060.6206989011 | -11.9972432010003 | 0.743751039809863 | 0.608681919036074 | 0.38216179785311 | 0.209808884844897 | 0.132844117985747 | 0.0842657159901505 | 0.0584680796064633 | 0.0440079075734864 | 0.0329577177387368 | 0.0249504691408769 | 0.0194726864148328 | 0.0167328990114859 | 0.014051837024923 | 0.0116487062523388 | 0.0104150296184047 | 0.0104137816997927 | 0.00953801301727399 | 0.00823941619599711
Operating Margin | OPER_MARGIN | -12207.2213494505 | -125.696223663645 | -8.06436395325807 | -1.21043301741239 | -0.434096929932231 | -0.157385372930347 | -0.0697044172150689 | -0.0347501002716219 | -0.0177758690746873 | -0.013151441782475 | -0.0057227362870675 | -0.00479818438228603 | -0.00285342216571102 | -0.000738065760135026 | 0.000141245287322055 | -0.00077051709042961 | 0.000347294117647059 | 0.000347909957383103 | 0.00292174167384163 | 0.00258304999179372
Profit Margin | PROF_MARGIN | -11970.0519252747 | -125.779283369803 | -7.94111938997821 | -1.21375809271912 | -0.440654541126411 | -0.159157350259632 | -0.0784478246591234 | -0.0399504848577158 | -0.0199766540732608 | -0.0144174766901247 | -0.00641261519796552 | -0.00445290626395198 | -0.00289199868990071 | -0.00104452204216956 | 0.000571186880667425 | -0.00066866999645099 | 0.00264932318501171 | 0.00270689921565356 | 0.00255628735575898 | 0.00221954743952761
Current Profit | CUR_PROFIT_JAPAN | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — |  | 0.257495891126177 | 0.264636031924907
Sales per Employee | ACTUAL_SALES_PER_EMPL | — | 3115.2647974367 | 2577.31958764112 | 1669.44908180148 | 912.408759125771 | 571.428571427005 | 384.615384615877 | 266.666666666667 | 192.30769230736 | 151.515151515459 | 121.951219512377 | 95.2380952380784 | 81.9672131147225 | 80 | 65.7894736841183 | 56.3570784490473 | 53.1236719082518 | 54.807869042608
Dividends per Share | EQY_DPS | 0 | 0 | 0 | 0 | 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 | 0 | 0 | 0 | 0
Depreciation Expense | IS_DEPR_EXP | — | — | 0.122796593384829 | 0.0720005877599001 | 0.0662069375943821 | 0.0581019305188612 | 0.0624816073766681 | 0.0583860076663367 | 0.0613820470480423 | 0.0584334747592795 | 0.0536618371013275 | 0.0520873934334451 | 0.0554145532401523 | 0.0534970389041583 | 0.0511792835600855 | 0.044241964613507 | 0.0279652844744455 | 0.0214980451876514
Rental Expense | BS_CURR_RENTAL_EXPENSE | — | — | — | 0.0308573947542429 | 0.0252925379574044 | 0.0200981520662727 | 0.0234572587420938 | 0.0380778310867413 | 0.0397686502001401 | 0.0457305454637839 | 0.0382632229765988 | 0.0350792649653814 | 0.0328790258948623 | 0.029280944215789 | 0.024407653307252 | 0.0237782058612398 | 0.0217660834825734 | 0.021766824136322
Source: Bloomberg |  | Right click to show data transparency (not supported for all values)