Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Metrics

Valuation

Returns

Risk

Ranks

Dividends

Analyst Estimates

Financial Health

Technicals

Growth

Profitability

Peers

StockDividendMarket Cap (B)PEPrice ($)
Financials

WTW Income Statement

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Amortization of intangibles55 M54 M76 M591 M581 M534 M489 M461 M369 M312 M
Basic EPS from continuing operations2.075.45.498.055.6916.689.36
Basic EPS total2.075.45.493.074.215.298.057.6832.889.0
Basic weighted shares outstanding176 M67 M68 M137 M135 M131 M130 M130 M128 M118 M
BasicDiscontinuousOperations1.9916.2-0.36
Cost of sales203 M410 M253 M417 M-525 M436 M
Depreciation94 M92 M95 M-178 M-252 M-213 M-240 M-308 M
Depreciation unreconciled149 M146 M171 M591 M581 M534 M489 M461 M369 M312 M
DepreciationAndAmortization149 M146 M171 M591 M581 M534 M489 M461 M369 M312 M
Diluted EPS total2.045.325.413.044.185.278.027.6532.788.98
Diluted normalized net income/share2.045.325.418.025.6716.639.34
Diluted weighted shares outstanding179 M68 M69 M138 M136 M132 M130 M130 M129 M118 M
DilutedDiscontinuousOperations1.9816.15-0.36
Dividends paid per share1.123.183.281.923.282.62.753.02
Earnings from equity interest14 M11 M2 M3 M21 M6 M
EarningsFromEquityInterestNetOfTax14 M11 M2 M3 M21 M6 M
Fees3,633 M3,767 M3,809 M
GainOnSaleOfBusiness-2 M81 M2,679 M
GainOnSaleOfSecurity2 M12 M25 M2 M13 M-9 M-2 M81 M
GainsLossOnDisposalOfDiscontinuedOperations258 M2,080 M-40 M
GeneralAndAdministrativeExpense-141 M-134 M-142 M-302 M-302 M-243 M-233 M-219 M-229 M
Gross operating profit3,633 M3,767 M3,829 M7,887 M7,999 M8,103 M8,786 M8,198 M9,523 M8,430 M
Income before tax499 M518 M340 M340 M492 M851 M1,322 M1,011 M2,692 M1,258 M
Income restructuring and M&A-32 M36 M126 M193 M132 M-268 M24 M26 M99 M
Income taxes122 M159 M-33 M-96 M-100 M136 M249 M249 M536 M194 M
Interest income3 M100 M98 M61 M172 M
InterestExpenseNonOperating126 M135 M142 M184 M188 M208 M234 M244 M211 M208 M
InterestExpenseOperating-117 M-123 M-126 M-143 M-169 M-176 M-210 M-229 M-212 M
LossAndLossAdjustmentExpectedIncurred-70 M-50 M-11 M
MinorityInterests-12 M-11 M-11 M-18 M-24 M-20 M-29 M-24 M-14 M-15 M
MiscOtherSpecialCharges-16 M41 M55 M-27 M164 M250 M227 M396 M701 M288 M
Net income from total operations377 M373 M384 M438 M592 M715 M1,044 M996 M4,222 M1,064 M
NetIncomeCommonStockholders365 M721 M373 M858 M568 M695 M1,044 M996 M4,222 M1,009 M
NetIncomeContinuousOperations377 M373 M384 M438 M592 M715 M1,044 M996 M4,222 M1,064 M
NetIncomeDiscontinuousOperations50 M41 M47 M36 M82 M313 M132 M258 M2,080 M-40 M
NetIncomeExtraordinary377 M438 M592 M
NetNonOperatingInterestIncomeExpense-126 M224 M-142 M-184 M-188 M-208 M-234 M-244 M-211 M-208 M
Normalized income2,153 M1,093 M
Operating income641 M648 M637 M921 M917 M809 M1,329 M883 M2,228 M1,277 M
Operating income before depreciation (EBITDA)663 M686 M527 M1,150 M1,344 M1,630 M2,223 M2,550 M3,501 M2,153 M
OperatingExpense2,992 M3,155 M3,402 M7,336 M7,082 M7,294 M7,457 M7,315 M7,295 M7,153 M
Other income net16 M-55 M18 M202 M105 M-250 M-227 M-396 M-701 M-288 M
OtherGandA-141 M-134 M-142 M-302 M-302 M-243 M-233 M-219 M-229 M
OtherImpairmentOfCapitalAssets-1000000.0-1000000.0
OtherOperatingExpenses636 M659 M718 M1,729 M1,534 M1,637 M1,719 M1,697 M1,673 M1,776 M
OtherWriteDown-2 M
ProvisionForGainLossOnDisposal50 M41 M47 M36 M82 M313 M132 M78 M208 M
RentAndLandingFees-141 M-134 M-142 M-302 M-302 M-243 M
RestructringAndMnAIncome-32 M36 M126 M193 M132 M-268 M24 M26 M99 M
Revenue per share55 M54 M76 M591 M581 M534 M489 M461 M369 M312 M
SalariesAndWages2,207 M2,314 M2,303 M4,646 M4,967 M5,123 M5,249 M5,157 M5,253 M5,065 M
Special income/charges46 M-36 M-126 M-193 M-132 M5 M6 M-24 M-26 M-99 M
Total Income available for interest expense (EBIT)508 M530 M356 M381 M511 M883 M1,346 M1,026 M2,691 M1,466 M
Total common shares outstanding179 M179 M138 M136 M132 M129 M129 M129 M118 M107 M
Total net income377 M373 M384 M438 M592 M715 M1,044 M996 M4,222 M1,064 M
Total ordinary shares102 M102 M102 M102 M102 M102 M102 M102 M102 M102 M
Total revenues3,655 M3,802 M3,829 M7,887 M8,202 M8,513 M9,039 M8,615 M8,998 M8,866 M
TotalExpenses2,992 M3,155 M3,402 M7,336 M7,285 M7,704 M7,710 M7,732 M6,770 M7,589 M
TotalRevenue3,655 M3,802 M3,829 M7,887 M8,202 M8,513 M9,039 M8,615 M8,998 M8,866 M
WriteDown-14 M-48 M-13 M-5 M-63 M-5 M-6 M-130 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University