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

Financials

XYL Balance Sheet

Annual
Dec-13Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22
Accounts payable332 M338 M338 M457 M549 M586 M597 M569 M639 M723 M
Accounts receivable817 M771 M749 M843 M956 M1,031 M1,036 M923 M953 M1,096 M
Accrued expenses811 M814 M745 M978 M1,100 M1,132 M1,225 M1,356 M1,391 M1,590 M
Accumulated depreciation & depletion-816 M-804 M-800 M-822 M-933 M-976 M-1,044 M-1,157 M-1,182 M
Additional paid in capital1,753 M1,796 M1,834 M1,876 M1,912 M1,950 M1,991 M2,037 M2,089 M2,134 M
Cash and equivalents533 M663 M680 M308 M414 M296 M724 M1,875 M1,349 M944 M
CashCashEquivalentsAndShortTermInvestments533 M663 M680 M308 M414 M296 M724 M1,875 M1,349 M944 M
CashEquivalents533 M663 M680 M308 M414 M296 M724 M1,875 M1,349 M944 M
CommercialPaper600 M600 M
Common par2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Common stock equity2,241 M2,127 M2,084 M2,190 M2,503 M2,768 M2,957 M2,968 M3,218 M3,494 M
CommonStock2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Cost in excess1,718 M1,635 M1,584 M2,632 M2,768 M2,976 M2,839 M2,854 M2,792 M2,719 M
CurrentAccruedExpenses479 M476 M407 M521 M551 M546 M628 M787 M752 M867 M
CurrentCapitalLeaseObligation63 M63 M55 M65 M65 M76 M61 M63 M69 M
CurrentDeferredAssets41 M38 M
CurrentDeferredTaxesAssets41 M187 M177 M261 M243 M190 M247 M326 M279 M
CurrentDeferredTaxesLiabilities256 M173 M168 M434 M300 M247 M160 M138 M155 M
DefinedPensionBenefit840 M930 M840 M918 M1,005 M914 M1,008 M1,199 M1,085 M
DividendsPayable465600.0
EmployeeBenefits348 M388 M335 M408 M442 M400 M445 M519 M438 M286 M
Finished goods189 M194 M188 M220 M223 M248 M212 M221 M236 M
Float term debt1,241 M1,284 M1,274 M2,368 M2,200 M2,308 M2,316 M3,084 M2,440 M1,880 M
GoodwillAndOtherIntangibleAssets2,206 M2,105 M2,019 M3,833 M3,936 M4,208 M4,013 M3,947 M3,808 M3,649 M
Gross fixed assets (Plant Property & Equipment)1,304 M1,265 M1,239 M1,438 M1,576 M1,632 M1,702 M1,814 M1,826 M630 M
IncomeTaxPayable45 M77 M64 M63 M75 M85 M79 M103 M86 M
Intangibles488 M470 M435 M1,201 M1,168 M1,232 M1,174 M1,093 M1,016 M930 M
InterestPayable55 M54 M55 M70 M82 M82 M67 M77 M76 M
Inventories475 M486 M433 M522 M524 M595 M539 M558 M700 M799 M
Invested capital3,482 M3,411 M3,358 M4,558 M4,703 M5,076 M5,273 M6,052 M5,658 M5,374 M
LongTermCapitalLeaseObligation185 M216 M328 M315 M
LongTermDebtAndCapitalLeaseObligation1,241 M1,284 M1,274 M2,368 M2,200 M2,308 M2,316 M3,084 M2,440 M1,880 M
Minority interest17 M16 M14 M10 M8 M8 M9 M
Net fixed assets (net PP&E)488 M461 M439 M616 M643 M656 M658 M657 M644 M630 M
Non-current deferred income taxes191 M136 M118 M352 M252 M303 M310 M242 M287 M222 M
NonCurrentDeferredLiabilities255 M220 M219 M513 M599 M600 M757 M815 M781 M693 M
NonCurrentDeferredRevenue64 M84 M101 M161 M347 M297 M447 M573 M494 M471 M
NonCurrentDeferredTaxesAssets515 M614 M425 M572 M593 M424 M438 M543 M480 M
NonCurrentPensionAndOtherPostretirementBenefitPlans348 M388 M335 M408 M442 M400 M445 M519 M438 M286 M
Number of employees17800.017800.017800.017800.017800.017800.017800.017800.017800.017800.0
Other current assets1000000.01000000.01000000.02 M4 M7 M256 M241 M251 M
Other equity adjustments167 M-99 M-238 M-318 M-210 M-336 M-375 M-413 M-371 M-226 M
Other non-current assets193 M203 M194 M186 M210 M264 M589 M623 M664 M661 M
Other non-current liabilities17 M9 M6 M11 M107 M275 M340 M378 M415 M
Other receivable4,963 M5,002 M4,681 M4,998 M
OtherCurrentBorrowings89 M78 M260 M257 M276 M600 M
OtherPayable81 M18 M1,782 M33 M433 M18 M
Payables332 M338 M338 M457 M549 M586 M597 M569 M639 M723 M
Prepaid expenses143 M144 M143 M166 M177 M172 M151 M167 M158 M173 M
Raw materials255 M250 M213 M260 M259 M302 M280 M288 M406 M
RecievablesAdjustmentsAllowances-35 M-35 M
Retained earnings405 M648 M885 M1,033 M1,227 M1,639 M1,866 M1,930 M2,154 M2,292 M
Total assets4,896 M4,833 M4,657 M6,474 M6,860 M7,222 M7,710 M8,750 M8,276 M7,952 M
Total current assets2,009 M2,064 M2,005 M1,839 M2,071 M2,094 M2,450 M3,523 M3,160 M3,012 M
Total current liabilities811 M814 M745 M978 M1,100 M1,132 M1,225 M1,356 M1,391 M1,590 M
Total equity2,241 M2,127 M2,084 M2,190 M2,503 M2,768 M2,957 M2,968 M3,218 M3,494 M
Total liabilities2,655 M2,706 M2,573 M4,267 M4,341 M4,440 M4,743 M5,774 M5,050 M4,449 M
Total non-current assets2,887 M2,769 M2,652 M4,635 M4,789 M5,128 M5,260 M5,227 M5,116 M4,940 M
Total non-current liabilities1,844 M1,892 M1,828 M3,289 M3,241 M3,308 M3,518 M4,418 M3,659 M2,859 M
TotalEquityGrossMinority2,241 M2,127 M2,084 M2,207 M2,519 M2,782 M2,967 M2,976 M3,226 M3,503 M
TotalEquityGrossMinorityInterest2,241 M2,127 M2,084 M2,207 M2,519 M2,782 M2,967 M2,976 M3,226 M3,503 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest4,896 M4,833 M4,657 M6,474 M6,860 M7,222 M7,710 M8,750 M8,276 M7,952 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,844 M1,892 M1,828 M3,289 M3,241 M3,308 M3,518 M4,418 M3,659 M2,859 M
Treasury stock-86 M-220 M-399 M-403 M-428 M-487 M-527 M-588 M-656 M-708 M
UnearnedPremiums4 M24 M22 M19 M17 M28 M24 M
Work in progress31 M42 M32 M42 M42 M45 M47 M49 M58 M
Working capital1,198 M1,250 M1,260 M861 M971 M962 M1,225 M2,167 M1,769 M1,422 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.

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