WTW Stock Annual Balance Sheet. Download in Excel

	Dec-14	Dec-15	Dec-16	Dec-17	Dec-18	Dec-19	Dec-20	Dec-21	Dec-22	Dec-23
Accounts payable	131 M	75 M	117 M	772 M	691 M	856 M	862 M
Accounts receivable	1,044 M	1,258 M	2,080 M	2,246 M	2,379 M	2,621 M	2,408 M	2,370 M	2,387 M	2,572 M
Accrued expenses	50 M	56 M
Accumulated depreciation & depletion	-497 M	-528 M	-642 M	-877 M	-768 M	-896 M	-1,121 M	-1,241 M		-1,351 M
Additional paid in capital	1,533 M	1,672 M	10,596 M	10,538 M	10,615 M	10,687 M	10,748 M	10,804 M	10,876 M	10,910 M
Cash and equivalents	635 M	532 M	870 M	1,030 M	1,033 M	887 M	2,039 M	4,486 M	1,262 M	1,424 M
CashCashEquivalentsAndShortTermInvestments	635 M	532 M	870 M	1,030 M	1,033 M	887 M	2,039 M	4,486 M	1,262 M	1,424 M
CashEquivalents			870 M	1,030 M	1,033 M	8 M	6,301 M
Common stock equity	1,985 M	2,229 M	10,065 M	10,126 M	9,852 M	10,249 M	10,820 M	13,260 M	10,016 M	9,520 M
Cost in excess	2,937 M	3,737 M	10,413 M	10,519 M	10,465 M	11,194 M	10,392 M	10,183 M	10,173 M	10,195 M
CurrentCapitalLeaseObligation	11 M	141 M	54 M	48 M	197 M	164 M	152 M	150 M	126 M	125 M
CurrentDeferredAssets	12 M
CurrentDeferredRevenue	619 M	752 M	1,481 M	1,711 M	1,647 M	1,784 M	2,098 M	1,926 M	1,915 M	2,104 M
CurrentDeferredTaxesAssets	146 M	299 M	894 M	592 M	607 M	885 M	875 M
CurrentDeferredTaxesLiabilities	149 M	289 M	1,431 M	929 M	825 M	865 M	788 M	845 M	748 M	542 M
Deferred revenues	619 M	752 M	1,481 M	1,711 M	1,647 M	1,784 M	2,098 M	2,771 M	2,663 M	2,646 M
DefinedPensionBenefit	314 M	623 M	488 M	764 M	773 M	868 M	971 M
DerivativeProductLiabilities	9 M	27 M	51 M	5 M			2 M
DividendsPayable	17 M	11 M			313 M	100 M	354 M			103 M
EmployeeBenefits		279 M	1,321 M	1,259 M	1,170 M	1,324 M	1,403 M
Float term debt	2,130 M	2,278 M	3,357 M	4,450 M	4,389 M	5,301 M	4,664 M	734 M	620 M	592 M
GoodwillAndOtherIntangibleAssets	3,387 M	4,852 M	14,781 M	14,401 M	13,783 M	14,672 M	13,381 M	12,738 M	12,446 M	12,211 M
Gross fixed assets (Plant Property & Equipment)	980 M	1,091 M	1,481 M	1,862 M	1,710 M	2,910 M	3,035 M	2,812 M	1,304 M	2,636 M
IncomeTaxPayable	33 M	45 M	91 M	90 M	129 M	138 M	102 M			50 M
Intangibles	450 M	1,115 M	4,368 M	3,882 M	3,318 M	3,478 M	2,989 M	2,555 M	2,273 M	2,016 M
InterestPayable	135 M	142 M	184 M	188 M	208 M	234 M	244 M			50 M
Invested capital	4,115 M	4,673 M	15,323 M	15,310 M	14,411 M	16,545 M	15,484 M	17,968 M	15,107 M	19,246 M
Leases		32 M	32 M	31 M	31 M
LongTermCapitalLeaseObligation					1,149 M	964 M	917 M	734 M	620 M	592 M
LongTermDebtAndCapitalLeaseObligation	2,130 M	2,278 M	3,357 M	4,450 M	4,389 M	6,265 M	5,581 M	734 M	620 M	592 M
LongTermProvisions	4 M	5 M
Minority interest	81 M	184 M	169 M	151 M	145 M	120 M	112 M	48 M	77 M	73 M
Net fixed assets (net PP&E)	483 M	563 M	839 M	985 M	942 M	2,014 M	1,914 M	1,571 M	1,304 M	1,285 M
Non-current deferred income taxes	147 M	240 M	864 M	615 M	559 M	526 M	561 M
NonCurrentAccountsReceivable	29 M	30 M	27 M	33 M	20 M	30 M	35 M
NonCurrentAccruedExpenses	171 M	175 M
NonCurrentDeferredAssets	19 M	76 M
NonCurrentDeferredLiabilities	431 M	240 M	864 M	615 M	559 M	526 M	561 M
NonCurrentDeferredRevenue		90 M	67 M	84 M	85 M	81 M	82 M
NonCurrentDeferredTaxesAssets	19 M	486 M	1,028 M	754 M	688 M	961 M	959 M
NonCurrentPensionAndOtherPostretirementBenefitPlans	284 M	279 M	1,321 M	1,259 M	1,170 M	1,324 M	1,403 M
NonCurrentPrepaidAssets	14 M	23 M
Notes payable		300 M
Other current assets	425 M	40 M	56 M	12,155 M	12,604 M	13,004 M	15,375 M
Other equity adjustments	194 M	-1,037 M	-1,884 M	558 M	-1,961 M	-2,227 M	-2,359 M
Other fixed assets						2,014 M	1,914 M	1,571 M	1,304 M	1,285 M
Other non-current assets	9,304 M	10,756 M	10,858 M	447 M	467 M	835 M	1,964 M
Other non-current liabilities	143 M	533 M	532 M	544 M	969 M	13,876 M	696 M	1,391 M	1,058 M	1,166 M
Other receivable	101 M	105 M			8,413 M	8,941 M	25 M	1000000.0
OtherCurrentBorrowings	167 M	988 M	508 M	85 M	186 M
OtherCurrentLiabilities	9,405 M	11,356 M	11,956 M	12,959 M	13,468 M	802 M	16,111 M	12,029 M	12,488 M	9,751 M
OtherEquityInterest	893 M	713 M
OtherPayable	241 M	857 M	-476 M	13 M	36 M	1,329 M
Payables	50 M	56 M
Preferred securities of subsidiary trust					1,000 M
PreferredStock					1,000 M
Prepaid expenses		255 M	337 M	430 M	404 M	525 M	479 M	612 M	414 M	364 M
RecievablesAdjustmentsAllowances	-12 M	-22 M			-40 M	-37 M	-41 M			-34 M
Retained earnings	1,530 M	1,597 M	1,452 M	1,104 M	1,201 M	1,792 M	2,434 M	2,459 M	-857 M	-1,390 M
SecuritySoldNotYetRepurchased	213 M	82 M	396 M	532 M	602 M	150 M
Short term debt	167 M	988 M	508 M	85 M	186 M	316 M	971 M	613 M	250 M	650 M
TaxesReceivable	30 M	66 M	97 M	170 M	61 M	56 M	82 M	82 M		87 M
Total assets	15,421 M	18,839 M	30,253 M	32,458 M	32,385 M	35,426 M	38,531 M	34,970 M	31,769 M	29,090 M
Total current assets	10,839 M	2,045 M	3,287 M	15,861 M	16,420 M	17,037 M	20,301 M
Total current liabilities	10,211 M	13,096 M	13,945 M	14,755 M	15,301 M	3,066 M	19,332 M	14,724 M	14,779 M	12,630 M
Total equity	1,985 M	2,229 M	10,065 M	10,126 M	9,852 M	10,249 M	10,820 M	13,260 M	10,016 M	9,520 M
Total liabilities	13,355 M	16,426 M	20,019 M	22,181 M	22,388 M	25,057 M	27,599 M	21,662 M	21,676 M	19,497 M
Total non-current assets	4,582 M	16,794 M	26,966 M	16,597 M	15,965 M	18,389 M	18,230 M
Total non-current liabilities	3,144 M	3,330 M	6,074 M	7,426 M	7,087 M	21,991 M	8,267 M	6,938 M	6,897 M	6,867 M
TotalEquityGrossMinority	2,007 M	2,413 M	10,234 M	10,249 M	9,997 M	10,369 M	10,932 M	13,308 M	10,093 M	9,593 M
TotalEquityGrossMinorityInterest	2,007 M	2,413 M	10,234 M	10,249 M	9,997 M	10,369 M	10,932 M	13,308 M	10,093 M	9,593 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest	15,421 M	18,839 M	30,253 M	32,458 M	32,385 M	35,426 M	38,531 M	34,970 M	31,769 M	29,090 M
TotalNonCurrentLiabilitiesNetMinorityInteres	3,144 M	3,330 M	6,074 M	7,426 M	7,087 M	21,991 M	8,267 M	6,938 M	6,897 M	6,867 M
TotalTaxPayable	33 M	45 M
Treasury stock	-3 M	-3 M	-99 M	-3 M	-3 M	-3 M	-3 M	-3 M	-3 M
UnrealizedGainLoss	194 M	295 M		558 M	540 M
Working capital	628 M	-11,051 M	-10,658 M	1,106 M	1,119 M	13,971 M	969 M			803 M
debtc	167 M	988 M	508 M	85 M	186 M	480 M	1,123 M	763 M	376 M	775 M
ltinv	169 M	42 M	30 M	26 M	7 M	23 M	70 M

Call: 1-877-778-8358

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.

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