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

 |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00
In Millions of USD except Per Share |  | 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 |  | 12/31/2015 | 12/31/2016 | 12/31/2017 | 12/31/2018 | 12/31/2019 | 12/31/2020 | 12/31/2021 | 12/31/2022 | 12/31/2023 | 12/31/2023 | 12/31/2024 | 12/31/2025
Revenue | SALES_REV_TURN | 693.9 | 704.2 | 676.2 | 740.7 | 824.1 | 842.5 | 1024.2 | 1246.2 | 1 | 1513.7 | 1727.111 | 1973.389
+ Sales & Services Revenue | IS_SALES_AND_SERVICES_REVENUES | 0.924628909064707 | 0.907838682192559 | 0.848713398402839 | 0.843796408802484 | 0.825263924281034 | 0.819228486646884 | 0.830599492286663 | 0.840635532017333 | 0.07 | 0.857039043403581
+ Other Revenue | IS_OTHER_REVENUE | 0.0753710909352933 | 0.0921613178074411 | 0.151286601597161 | 0.156203591197516 | 0.174736075718966 | 0.180771513353116 | 0.169400507713337 | 0.159364467982667 | 0.142960956596419 | 0.142960956596419
- Cost of Revenue | IS_COGS_TO_FE_AND_PP_AND_G | 0.595330739299611 | 0.632348764555524 | 0.601449275362319 | 0.571621439179155 | 0.549933260526635 | 0.589910979228487 | 0.623999218902558 | 0.620285668432033 | 0.572900839003766 | 0.572900839003766
+ Cost of Goods & Services | IS_COG_AND_SERVICES_SOLD | 0.568525724167747 | 0.598267537631355 | 0.490683229813665 | 0.44565951127312 | 0.423370950127412 | 0.442492581602374 | 0.443468072642062 | 0.439817043813192 | 0.39010371936315 | 0.427363414150757
+ Depreciation & Amortization | IS_DA_COST_OF_REVENUE_GAAP | 0.0268050151318634 | 0.0340812269241693 | 0.0462880804495711 | 0.0463075469150803 | 0.0441693969178498 | 0.0480712166172107 | 0.0496973247412615 | 0.0441341678703258 | 0.0441302768051794 | 0.0441302768051794
+ Research & Development | IS_RESEARCH_AND_DEVELOPMENT | — | — | 0.0644779650990831 | 0.0796543809909545 | 0.0823929134813736 | 0.0993471810089021 | 0.130833821519235 | 0.136334456748515 | 0.138666842835436
Gross Profit | GROSS_PROFIT | 0.404669260700389 | 0.367651235444476 | 0.398550724637681 | 0.428378560820845 | 0.450066739473365 | 0.410089020771513 | 0.376000781097442 | 0.379714331567967 | 0.427099160996234 | 0.427099158980143 | 0.45204 | 0.46704
+ Other Operating Income | IS_OTHER_OPER_INC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Operating Expenses | IS_OPERATING_EXPN | 0.393860786856896 | 0.373473445044022 | 0.316622301094351 | 0.310112056163089 | 0.334789467297658 | 0.360237388724036 | 0.397871509470806 | 0.362622372010913 | 0.333157164563652 | 0.325361696505252
+ Selling, General & Admin | IS_SGA_EXPENSE | 0.353797377143681 | 0.354728770235728 | 0.316622301094351 | 0.317672471985959 | 0.334789467297658 | 0.360237388724036 | 0.405389572349151 | 0.400417268496228 | 0.339168923829028 | 0.339168923829028
+ Selling & Marketing | IS_SELLING_EXPENSES | — | — | 0.161638568470867 | 0.165654110976104 | 0.18201674554059 | 0.196557863501484 | 0.213337238820543 | 0.198603755416466 | 0.165290348153531 | 0.124661425645769
+ General & Administrative | IS_GENERAL_AND_ADMINISTRATIVE | — | — | 0.154983732623484 | 0.183745105980829 | 0.17704162116248 | 0.199287833827893 | 0.194590900214802 | 0.201813513079762 | 0.173878575675497 | 0.130937438065667
+ Research & Development | IS_OPERATING_EXPENSES_RD | 0 | 0 | 0 | 0 | — | — | — | — | —
+ Other Operating Expense | IS_OTHER_OPERATING_EXPENSES | 0.0400634097132152 | 0.0187446748082931 | 0 | -0.00756041582287026 | 0 | 0 | -0.00751806287834407 | -0.0377948964853154 | -0.00601175926537623 | -0.0138072273237762
Operating Income (Loss) | IS_OPER_INC | 0.0108084738434933 | -0.00582220959954558 | 0.0819284235433304 | 0.118266504657756 | 0.115277272175707 | 0.0498516320474777 | -0.0218707283733646 | 0.0170919595570534 | 0.0939419964325824 | 0.101737464490982 | 0.225926417005045 | 0.238168957058137
- Non-Operating (Income) Loss | IS_NONOP_INCOME_LOSS | 0.126531200461162 | 0.12411246804885 | 0.141821946169772 | 0.11205616308897 | 0.0461109088702827 | 0.0329970326409496 | 0.0530169888693614 | 0.0297705023270743 | 0.0245094800819185 | 0.0245094800819185
+ Interest Expense, Net | IS_NET_INTEREST_EXPENSE | 0.126531200461162 | 0.12411246804885 | 0.128808044957113 | 0.112326177939787 | 0.0393156170367674 | 0.0297922848664688 | 0.0350517477055263 | 0.0229497672925694 | 0.0238488471956134 | 0.0238488471956134
+ Interest Expense | IS_INT_EXPENSE | 0.126531200461162 | 0.12411246804885 | 0.128808044957113 | 0.112326177939787 | 0.0393156170367674 | 0.0297922848664688 | 0.0350517477055263 | 0.0229497672925694 | 0.0238488471956134 | 0.0238488471956134
- Interest Income | IS_INT_INC | 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.0092755321226323 | 0.00280853795538437 | 0.000396379731783048
+ Other Non-Op (Income) Loss | IS_OTHER_NON_OPERATING_INC_LOSS | 0 | 0 | 0.013013901212659 | -0.000270014850816795 | 0.00679529183351535 | 0.00320474777448071 | 0.00868970904120289 | 0.00401219707912053 | 0.000264253154522032 | -0.00323710114289489
Pretax Income (Loss), Adjusted | PRETAX_INC | -0.115722726617668 | -0.129934677648395 | -0.0598935226264419 | 0.00621034156878628 | 0.0691663633054241 | 0.0168545994065282 | -0.074887717242726 | -0.0126785427700209 | 0.0694325163506639 | 0.077227983905041 | 0.202959161281469 | 0.219890249717618
- Abnormal Losses (Gains) | IS_ABNORMAL_ITEM | 0 | 0 | 0 | 0.0425273390036452 | 0.0275452008251426 | 0.040593471810089 | 0.0132786565123999 | 0.0377948964853154 | 0.00601175926537623 | 0.0138072272922747
+ Merger/Acquisition Expense | IS_MERGER_ACQUISITION_EXPENSE | — | — | — | 0.00499527474011071 | — | — | 0.000585823081429408 | 0.00369122131279088 | 0.00284072141111185 | 0.0127502147056881
+ Disposal of Assets | IS_GAIN_LOSS_DISPOSAL_ASSETS | — | — | — | — | — | — | -0.0186487014255028 | — | —
+ Asset Write-Down | IS_IMPAIRMENT_ASSETS | — | — | — | — | — | — | 0.000488185901191174 | — | —
+ Restructuring | IS_RESTRUCTURING_EXPENSES | — | — | — | 0.0137707573916565 | 0.00752335881567771 | 0.011513353115727 | 0.00722515133762937 | 0.0270422083132724 | 0.00310497456563388 | 0.000858822752196604
+ Other Abnormal Items | IS_OTHER_ONE_TIME_ITEMS | — | — | — | 0.023761306871878 | 0.0200218420094649 | 0.029080118694362 | 0.0236281976176528 | 0.00706146685925213 | 6.6063288630508e-05 | 0.000198189865891524
Pretax Income (Loss), GAAP | PRETAX_INC | -0.115722726617668 | -0.129934677648395 | -0.0598935226264419 | -0.0363169974348589 | 0.0416211624802815 | -0.0237388724035608 | -0.0881663737551259 | -0.0504734392553362 | 0.0634207570852877 | 0.0634207570852877 | 0.202959161281469 | 0.219890249717618
- Income Tax Expense (Benefit) | IS_INC_TAX_EXP | 0.0123937166738723 | 0.0252769099687589 | -0.0717243419106773 | 0.0113406237343054 | -0.0538769566800146 | -0.0189910979228487 | -0.014547939855497 | 0.0084256138661531 | 0.0272180749157693 | 0.0272180749157693
+ Current Income Tax | IS_CURRENT_INCOME_TAX_BENEFIT | 0.0237786424556853 | 0.0153365521158762 | 0.0204081632653061 | 0.0330768192250574 | 0.030336124256765 | -0.0106824925816024 | 0.0230423745362234 | 0.00978976087305408 | 0.0245094800819185
+ Deferred Income Tax | IS_DEFERRED_INCOME_TAX_BENEFIT | -0.0113849257818129 | 0.0099403578528827 | -0.0921325051759834 | -0.021736195490752 | -0.0842130809367795 | -0.00830860534124629 | -0.0375903143917204 | -0.00136414700690098 | 0.00270859483385083
Income (Loss) from Cont Ops | IS_INC_BEF_XO_ITEM | -0.128116443291541 | -0.155211587617154 | 0.0118308192842354 | -0.0476576211691643 | 0.0954981191602961 | -0.00474777448071217 | -0.073618433899629 | -0.0588990531214893 | 0.0362026821695184 | 0.0362026821695184 | 0.0630243221194237 | 0.0833398787567986
- Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0.0227698515636259 | -0.0234308435103664 | 0.00887311446317657 | 0.0348319157553665 | 0 | 0 | 0 | 0 | 0 | 0
+ Discontinued Operations | IS_DISCONTINUED_OPERATIONS | 0.0227698515636259 | -0.0234308435103664 | 0.00887311446317657 | 0.0348319157553665 | 0 | 0 | 0 | 0 | 0 | 0
+ XO & Accounting Changes | EXTRAORD_ITEMS_ACCOUNTING_CHANGS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Income (Loss) Incl. MI | NI_INCLUDING_MINORITY_INT_RATIO | -0.150886294855166 | -0.131780744106788 | 0.00295770482105886 | -0.0824895369245308 | 0.0954981191602961 | -0.00474777448071217 | -0.073618433899629 | -0.0588990531214893 | 0.0362026821695184 | 0.0362026821695184
- Minority Interest | MIN_NONCONTROL_INTEREST_CREDITS | 0 | 0.000142005112184039 | -0.00192250813368826 | -0.000675037127041987 | 0 | 0 | 0 | 0 | 0 | 0
Net Income, GAAP | NET_INCOME | -0.150886294855166 | -0.131922749218972 | 0.00488021295474712 | -0.0818144997974889 | 0.0954981191602961 | -0.00474777448071217 | -0.073618433899629 | -0.0588990531214893 | 0.0362026821695184 | 0.0362026821695184 | 0.0630243221194237 | 0.0833398787567986
- Preferred Dividends | IS_TOT_CASH_PFD_DVD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
- Other Adjustments | OTHER_ADJUSTMENTS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Income Avail to Common, GAAP | EARN_FOR_COMMON | -0.150886294855166 | -0.131922749218972 | 0.00488021295474712 | -0.0818144997974889 | 0.0954981191602961 | -0.00474777448071217 | -0.073618433899629 | -0.0588990531214893 | 0.0362026821695184 | 0.0362026818860055 | 0.0630243221194237 | 0.0833398787567986
Net Abnormal Losses (Gains) | IS_NET_ABNORMAL_ITEMS | 0 | 0 | 0 | 0.0406721493182125 | -0.0525391736439752 | 0.0306538362017804 | 0.0110107488771724 | 0.0298579682233991 | 0.00489984409063883 | 0.0107689237685585
Net Extraordinary Losses (Gains) | XO_GL_NET_OF_TAX | 0.0227698515636259 | -0.0234308435103664 | 0.00887311446317657 | 0.0348319157553665 | 0 | 0 | 0 | 0 | 0 | 0
Basic Weighted Avg Shares | IS_AVG_NUM_SH_FOR_EPS | 0.0935651318633809 | 0.0922867622834422 | 0.096428512274475 | 0.153975539354665 | 0.172368780487805 | 0.174213021958457 | 0.146848585237258 | 0.122692986679506 | 0.102596287243179 | 0.103190856840854
Basic EPS, GAAP | IS_EPS | -0.00233463035019455 | -0.00202994603805737 | 7.48447204968944e-05 | -0.000715539354664507 | 0.000667394733648829 | -3.56083086053412e-05 | -0.000488185901191174 | -0.00038517091959557 | 0.000231221510206778 | 0.000231221510206778 | 0.000435988190683749 | 0.000492046930432875
Basic EPS from Cont Ops, GAAP | IS_EARN_BEF_XO_ITEMS_PER_SH | -0.00195993659028678 | -0.00239048281738143 | 0.000138349600709849 | -0.000445093830160659 | 0.000667394733648829 | -3.56083086053412e-05 | -0.000488185901191174 | -0.00038517091959557 | 0.000231221510206778 | 0.000231221510206778 | 0.000435988190683749 | 0.000492046930432875
Basic EPS from Cont Ops, Adjusted | IS_BASIC_EPS_CONT_OPS | -0.00195993659028678 | -0.00239048281738143 | 0.000138349600709849 | -5.53300931551235e-05 | 0.00030242324960563 | 0.000176502077151335 | -0.000416268306971295 | -0.000189935002407318 | 0.000264665389443086 | 0.000301556451080135 | 0.000976775667574348 | 0.00103274113720103
Diluted Weighted Avg Shares | IS_SH_FOR_DILUTED_EPS | 0.0935651318633809 | 0.0922867622834422 | 0.096428512274475 | 0.153975539354665 | 0.180507938356996 | 0.174213021958457 | 0.146848585237258 | 0.122692986679506 | 0.104710312479355 | 0.105172755499769
Diluted EPS, GAAP | IS_DILUTED_EPS | -0.00233463035019455 | -0.00202994603805737 | 7.48447204968944e-05 | -0.000715539354664507 | 0.000643125834243417 | -3.56083086053412e-05 | -0.000488185901191174 | -0.00038517091959557 | 0.000231221510206778 | 0.000231221510206778 | 0.000435988190683749 | 0.000492046930432875
Diluted EPS from Cont Ops, GAAP | IS_DIL_EPS_BEF_XO | -0.00195993659028678 | -0.00239048565748367 | 0.000138349600709849 | -0.000445093830160659 | 0.000643125834243417 | -3.56083086053412e-05 | -0.000488185901191174 | -0.00038517091959557 | 0.000231221510206778 | 0.000231221510206778 | 0.000435988190683749 | 0.000492046930432875
Diluted EPS from Cont Ops, Adjusted | IS_DIL_EPS_CONT_OPS | -0.00195993659028678 | -0.00239048281738143 | 0.000138349600709849 | -8.84757661671392e-05 | 0.000289936900861546 | 0.000173241543026706 | -0.000416268306971295 | -0.000189935002407318 | 0.000262135165488538 | 0.000296521107220717 | 0.000976775667574348 | 0.00103274113720103
Reference Items
Accounting Standard | ACCOUNTING_STANDARD | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP
EBITDA | EBITDA | 0.0915117452082433 | 0.0755467196819085 | 0.167553978112984 | 0.194680707438909 | 0.194757917728431 | 0.117270029673591 | 0.0576059363405585 | 0.095971754132563 | 0.187025170112968 | 0.199246878509612 | 0.283097612139579 | 0.295810912090824
EBITDA Margin (T12M) | EBITDA_MARGIN | 0.0131880314166306 | 0.0107280204487362 | 0.02477876072168 | 0.0262833414337789 | 0.0236328018444363 | 0.0139192913946588 | 0.00562448154657294 | 0.00770115150056171 | 0.0123554977868798 | 0.0131629040437083 | 0.0163913965077855 | 0.0149899949827847
EBITA | EBITA | — | — | — | 0.14324287835831 | 0.145128018444364 | 0.0602967359050445 | 0.00527240773286467 | 0.0493500240731825 | 0.142894893307789 | 0.152408006870582
EBIT | EBIT | 0.0108084738434933 | -0.00582220959954558 | 0.0819284235433304 | 0.118266504657756 | 0.115277272175707 | 0.0498516320474777 | -0.0218707283733646 | 0.0170919595570534 | 0.0939419964325824 | 0.101737464490982 | 0.225926417005045 | 0.238168957058137
Gross Margin | [NAME] | 0.0583180948263439 | 0.0522083555808009 | 0.058939769299024 | 0.0578342864857567 | 0.0546131221939085 | 0.0486752545994065 | 0.0367116559265768 | 0.0304697745145242 | 0.0282155750809275 | 0.028215575146742 | 0.026173187478975 | 0.0236668999371133
Operating Margin | OPER_MARGIN | 0.00155764087044243 | -0.000826783584209032 | 0.0121160041407867 | 0.0159668556770622 | 0.0139882623468026 | 0.00591710741839763 | -0.00213539640695177 | 0.0013715262397689 | 0.00620611746052719 | 0.00672111148120383 | 0.0130811752692818 | 0.0120690323630129
Profit Margin | PROF_MARGIN | -0.018463242542153 | -0.0220610039761431 | 0.00203391452233067 | -0.000851954907519914 | 0.00521283218056061 | 0.00307490326409496 | -0.00611283733645772 | -0.00233037072701011 | 0.00271536830283412 | 0.00310309876052566 | 0.00865439425753689 | 0.00848586504839569
Sales per Employee | ACTUAL_SALES_PER_EMPL | — | — | — | 225.022502250574 | 199.560965875501 | 167.392032138872 | 134.012329133958 | 117.288294628471 | 110.083663584594 | 29.0681378969772
Dividends per Share | EQY_DPS | 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
Depreciation Expense | IS_DEPR_EXP | — | — | — | 0.0514378290805994 | 0.0496298992840675 | 0.056973293768546 | 0.0523335286076938 | 0.0466217300593805 | 0.0441302768051794 | 0.0468388716390302
Rental Expense | BS_CURR_RENTAL_EXPENSE | — | — | — | 0.023761306871878 | 0.010192937750273 | 0.00593471810089021 | 0.00380785002929115 | 0.00746268656716418 | 0.00554931624496267 | 0.00997555658320671
Source: Bloomberg |  | Right click to show data transparency (not supported for all values)
+ Common Stock | BS_COMMON_STOCK |  | 0.00020550110654442 | 0.000104013432591866 | 0.000266778459544952 | 0.000230047488374386 | 0.00022383716592303 | 0.000209315955457565 | 0.000177231641755775 | 0.000177562729583061
+ Additional Paid in Capital | BS_ADD_PAID_IN_CAP |  | 0.244419854568448 | 0.23260375339901 | 0.443157132512672 | 0.402435216984077 | 0.388954381985585 | 0.399095755072423 | 0.350386955751167 | 0.349698698243239
- Treasury Stock | BS_AMT_OF_TSY_STOCK |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
+ Retained Earnings | BS_PURE_RETAINED_EARNINGS |  | -0.0503477711033829 | -0.051739253183554 | -0.0716300163878197 | -0.0556057643327801 | -0.0411860385298375 | -0.0431469956183193 | -0.0440243398121345 | -0.0352683971634354
+ Other Equity | OTHER_EQUITY_RATIO |  | -0.0674517862788492 | -0.0463751318741735 | -0.0639506078737757 | -0.0377606520203099 | -0.0348887529285363 | -0.045323881555078 | -0.0573048975010339 | -0.0484635275055766
Equity Before Minority Interest | EQTY_BEF_MINORITY_INT_DETAILED |  | 0.152892823269048 | 0.16214208234892 | 0.307843286710622 | 0.309298848119362 | 0.313103427693134 | 0.310834193854484 | 0.249234950079754 | 0.26614433630381
+ Minority/Non Controlling Interest | MINORITY_NONCONTROLLING_INTEREST |  | 0.00611760986405311 | 0.00561672535996077 | 0 | 0 | 0 | 0 | 0 | 0
Total Equity | TOTAL_EQUITY |  | 0.159010433133101 | 0.167758807708881 | 0.307843286710622 | 0.309298848119362 | 0.313103427693134 | 0.310834193854484 | 0.249234950079754 | 0.26614433630381
Total Liabilities & Equity | TOT_LIAB_AND_EQY |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Reference Items
Accounting Standard | ACCOUNTING_STANDARD |  | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP | US GAAP
Shares Outstanding | BS_SH_OUT |  | 0.0102752190957951 | 0.00970088143954591 | 0.0265737470940204 | 0.0237255563041228 | 0.0221705358661752 | 0.0212099900923781 | 0.0184675370709517 | 0.0173456591461452
Number of Treasury Shares | BS_NUM_OF_TSY_SH |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pension Obligations | BS_PENSION_RSRV |  | — | 0.0226452101814291 | 0.0292122413201723 | 0.0192582611696272 | 0.00364108456568128 | 0.00288856018531439 | 0.00209133337271814 | 0.00307405475590674
Future Minimum Operating Lease Obligations | BS_FUTURE_MIN_OPER_LEASE_OBLIG |  | 0 | 0 | 0.0106901939860513 | — | — | — | — | —
Capital Leases - Total | BS_TOTAL_CAPITAL_LEASES |  | 0 | 0 | 0 | 0.00203756346845885 | 0.00131317804008178 | 0.00133962211492841 | 0.000992497193832339 | 0.000810129953722714
Options Granted During Period | BS_OPTIONS_GRANTED |  | — | — | 0.000997758489271695 | 0.000706159028542321 | 0.000611980063569755 | 0.000105931456001786 | 9.58764104684823e-06 | 7.35468155234216e-05
Options Outstanding at Period End | BS_OPTIONS_OUTSTANDING |  | — | — | 0.00265180570905903 | 0.00217119115303088 | 0.00191415889454285 | 0.00143631478328821 | 0.00107006841141372 | 0.000775951569765506
Net Debt | NET_DEBT |  | 0.159769206449573 | 0.152394537808883 | 0.0862266092457792 | 0.0714297451402468 | 0.0782087057735066 | 0.113128296726298 | 0.097359248537839 | 0.0748093975074632
Net Debt to Equity | NET_DEBT_TO_SHRHLDR_EQTY |  | 0.0158832097692065 | 0.0134981876402324 | 0.00533745645794428 | 0.00379481193617825 | 0.00372741900825213 | 0.0050787114509782 | 0.004615494889821 | 0.0031193977294166
Tangible Common Equity Ratio | TCE_RATIO |  | -0.00583169127410686 | -0.00410917026998915 | -0.00303755897709516 | -0.00112392066648044 | -0.000428881560294271 | -0.00132610239736541 | -0.0009052920186684 | -0.000215390804470142
Current Ratio | CUR_RATIO |  | 0.000160767467594056 | 0.000154668568626577 | 0.000201874118678303 | 0.000176600884039634 | 0.000159215823795383 | 0.000154542993497251 | 0.000126539493117505 | 0.000123880189548214
Number of Employees | NUM_OF_EMPLOYEES |  | — | — | 44.44 | 50.11 | 59.74 | 74.62 | 85.26 | 90.84
In Millions of USD except Per Share |  | 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 |  | 12/31/2015 | 12/31/2016 | 12/31/2017 | 12/31/2018 | 12/31/2019 | 12/31/2020 | 12/31/2021 | 12/31/2022 | 12/31/2023 | 12/31/2023 | 12/31/2024 | 12/31/2025
Revenue | SALES_REV_TURN |  |  |  |  |  |  |  |  |  | 1513.7 | 1727.111 | 1973.389
In Millions of USD except Per Share
12 Months Ending
Cash Flow
Cash From Operating Activities
Net Income - CF
Depreciation And Amortization - CF
Deferred Income Taxes - CF
Provision For Doubtful Accounts - CF
Disposal/Sale of Assets
Stock Based Compensation
Discontinued Operations (Operating)
Other Non-Cash Items
Change in Prepaid Expenses
Change in Accrued Expenses
Change in Deferred/Unearned Revenue -ST
Change in Accounts Payable & Accrued Expenses
Change in Other Current Liabilities
Impairments
Pension/Postretirement Benefits
Change in Accrued Compensation/Payroll Expense
Change in Other Assets
Total Cash Flows From Operations
Amortization of Debt Discount
Change In Other Assets And Liabilities
Gain/(Loss) On Early Extinguishment of Debt
Increase/Decrease In Trade & Other Receivables
Cash From Investing Activities
Disposal of Fixed Assets
Capital Expenditures
Proceeds From Investments
Purchases of Investments
Acquisition of Business
Other Investing Activities
Discontinued Operations (Investing)
Purchase of Intangibles
Incr In Marketable & Investment  Securities
Decr In Marketable & Investment  Securities
Total Cash Flows From Investing
Cash from Financing Activities
Decrease In Long-Term Borrowings
Issuance of Common Stock
Repurchase of Common Stock
Effect of Exchange Rates On Cash
Debt Financing/Issuance Costs
Other Financing Activities
Cash Paid For Taxes
Cash Paid For Interest
Exercise of Stock Options
Net Change In Cash
Cash and Cash Equivalents (End of Period)
Discontinued Operations (Financing)
Cash and Cash Equivalents (Beg of Period)
Interest Received
Change In Non-Cash Working Capital - Financing
Decrease In Borrowings
Proceeds Of issuance Of Convertible Bonds
Payments Of Redemption Convertible Bonds
Total Cash Flows From Financing