Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: Healthcare   

Industry: Diagnostics & Research

147.37
 
USD
  
2.96
  
(2.05%)
Optionable: Yes  Market Cap: 42,320 M  90-day average vol: 1,632,072

Previous close: 144.41  Open: 145.65  Bid: 143.04  Ask: 147.98
52 week range    
96.80   
   151.58
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Thursday 28th March 2024
67
MarketXLS Rank
55
Value
69
Technical
78
Quality

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

A Balance Sheet

Annual
Oct-13Oct-14Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22
"""debtc"""210 M616 M75 M36 M
Accounts payable432 M302 M279 M257 M305 M340 M354 M354 M446 M580 M
Accounts receivable899 M626 M606 M631 M724 M776 M930 M1,038 M1,172 M1,405 M
Accrued expenses432 M302 M279 M257 M305 M340 M354 M354 M446 M580 M
Accumulated depreciation & depletion-1,744 M-738 M-730 M-767 M-843 M-838 M-925 M-1,029 M-1,122 M-1,148 M
Additional paid in capital8,723 M8,967 M9,045 M9,159 M5,300 M5,308 M5,277 M5,311 M5,320 M5,325 M
Building & improvements1,330 M714 M705 M757 M886 M952 M1,012 M1,055 M1,147 M1,255 M
Cash and equivalents2,675 M2,218 M2,003 M2,289 M2,678 M2,247 M1,382 M1,441 M1,484 M1,053 M
CashCashEquivalentsAndShortTermInvestments2,675 M2,218 M2,003 M2,289 M2,678 M2,247 M1,382 M1,441 M1,575 M1,053 M
CashEquivalents2,675 M3,028 M2,245 M2,289 M
Common par6 M6 M6 M6 M3 M3 M3 M3 M3 M3 M
Common stock equity5,286 M5,301 M4,167 M4,243 M4,831 M4,567 M4,748 M4,873 M5,389 M5,305 M
CommonStock6 M6 M6 M6 M3 M3 M3 M3 M3 M3 M
Cost in excess3,047 M2,507 M2,366 M2,517 M2,607 M2,973 M3,593 M3,602 M3,975 M3,952 M
CurrentAccruedExpenses401 M395 M221 M235 M276 M304 M334 M367 M493 M
CurrentCapitalLeaseObligation56 M57 M35 M38 M42 M42 M52 M-51 M-52 M-51 M
CurrentDeferredRevenue439 M260 M258 M269 M291 M324 M336 M386 M441 M461 M
CurrentDeferredTaxesAssets493 M290 M286 M466 M419 M229 M402 M424 M280 M259 M
CurrentDeferredTaxesLiabilities331 M189 M158 M321 M256 M-133 M379 M356 M206 M188 M
Deferred revenues439 M260 M258 M269 M291 M324 M336 M386 M441 M461 M
DividendsPayable-156 M-176 M-133 M-150 M-170 M-191 M-206 M-222 M-236 M-250 M
EmployeeBenefits294 M209 M264 M360 M234 M239 M360 M389 M220 M97 M
Finished goods552 M366 M362 M339 M363 M386 M416 M417 M463 M555 M
Float term debt2,699 M1,663 M1,655 M1,904 M1,801 M1,799 M1,791 M2,284 M2,729 M2,733 M
GoodwillAndOtherIntangibleAssets3,963 M3,156 M2,811 M2,933 M2,968 M3,464 M4,700 M4,433 M4,956 M4,773 M
Gross fixed assets (Plant Property & Equipment)2,878 M1,369 M1,334 M1,406 M1,600 M1,660 M1,775 M1,874 M2,067 M2,248 M
IncomeTaxPayable-48 M-100 M-62 M49 M55 M71 M292 M63 M-47 M-51 M
Intangibles916 M649 M445 M416 M361 M491 M1,107 M831 M981 M821 M
InterestPayable-79 M-75 M-74 M-78 M-81 M-84 M
Inventories1,066 M574 M541 M533 M575 M638 M679 M720 M830 M1,038 M
InventoriesAdjustmentsAllowances-48 M-79 M-30 M-20 M-24 M-26 M-19 M-28 M-29 M-24 M
Invested capital10,684 M8,627 M7,477 M8,051 M8,433 M8,165 M8,330 M9,441 M10,847 M10,771 M
Land & improvements131 M58 M53 M53 M56 M55 M57 M58 M61 M59 M
Leases38 M29 M
LineOfCredit110 M40 M43 M46 M37 M
LongTermCapitalLeaseObligation5 M127 M130 M167 M
LongTermDebtAndCapitalLeaseObligation2,699 M1,663 M1,655 M1,904 M1,801 M1,799 M1,791 M2,284 M2,729 M2,733 M
Machinery furniture & equipment1,019 M443 M405 M420 M470 M512 M546 M579 M638 M674 M
Minority interest3 M3 M3 M3 M4 M4 M
Net fixed assets (net PP&E)1,134 M631 M604 M639 M757 M822 M850 M845 M945 M1,100 M
NetOtherUnrealizedGainLoss-341 M-516 M-204 M-305 M-188 M-201 M-306 M-317 M3 M20 M
NetUnrealizedGainLossForeignCurrency425 M156 M-189 M-197 M-156 M-214 M-204 M-194 M-185 M-335 M
NetUnrealizedGainLossInvestments7 M17 M
Non-current deferred income taxes-213 M-125 M-96 M-65 M-77 M-69 M-16 M-19 M-26 M-11 M
NonCurrentAccruedExpenses-341 M-285 M-227 M190 M131 M607 M328 M323 M-241 M-216 M
NonCurrentDeferredTaxesAssets578 M424 M417 M595 M557 M364 M536 M556 M400 M384 M
NonCurrentPensionAndOtherPostretirementBenefitPlans294 M209 M264 M360 M234 M239 M360 M389 M220 M97 M
NotesReceivable4 M8 M11 M15 M27 M32 M37 M
Number of employees17700.017700.017700.017700.017700.017700.017700.017700.017700.017700.0
Other current assets343 M2,091 M294 M182 M192 M187 M198 M216 M222 M282 M
Other equity adjustments91 M-334 M-391 M-503 M
Other fixed assets1,134 M631 M604 M639 M757 M822 M850 M845 M945 M1,100 M
Other non-current assets467 M1,423 M292 M452 M394 M339 M611 M776 M820 M686 M
Other non-current liabilities802 M513 M414 M339 M293 M761 M473 M614 M659 M536 M
Other receivable4,472 M4,914 M5,163 M5,339 M6,319 M6,848 M
OtherCurrentBorrowings210 M616 M75 M36 M
OtherCurrentLiabilities731 M1,130 M439 M419 M457 M507 M774 M652 M821 M784 M
OtherEquityInterest425 M516 M204 M305 M-188 M-201 M-306 M-317 M-185 M
OtherInventories1,066 M574 M541 M533 M575 M638 M679 M720 M830 M1,038 M
OtherPayable195 M205 M98 M139 M176 M177 M155 M119 M188 M291 M
Payables432 M302 M279 M257 M305 M340 M354 M354 M446 M580 M
Restricted cash242 M2,254 M1,388 M1,447 M1,490 M1,056 M
Retained earnings6,164 M6,135 M5,190 M5,586 M-472 M-744 M-532 M-441 M66 M-23 M
SecuritySoldNotYetRepurchased900 M200 M267 M434 M194 M422 M
Short term debt210 M616 M75 M36 M
TaxesReceivable-50 M82 M104 M83 M77 M59 M68 M89 M66 M87 M
Total assets10,686 M10,815 M7,479 M7,794 M8,426 M8,541 M9,452 M9,627 M10,705 M10,532 M
Total current assets4,983 M5,509 M3,686 M3,635 M4,169 M3,848 M3,189 M3,415 M3,799 M3,778 M
Total current liabilities1,602 M1,692 M976 M945 M1,263 M1,171 M2,080 M1,467 M1,708 M1,861 M
Total equity5,286 M5,301 M4,167 M4,243 M4,831 M4,567 M4,748 M4,873 M5,389 M5,305 M
Total liabilities5,397 M5,511 M3,309 M3,548 M3,591 M3,970 M4,704 M4,754 M5,316 M5,227 M
Total non-current assets5,703 M5,306 M3,793 M4,159 M4,257 M4,693 M6,263 M6,212 M6,906 M6,754 M
Total non-current liabilities3,795 M3,819 M2,333 M2,603 M2,328 M2,799 M2,624 M3,287 M3,608 M3,366 M
TotalEquityGrossMinority5,289 M5,304 M4,170 M4,246 M4,835 M4,571 M4,748 M4,873 M5,389 M5,305 M
TotalEquityGrossMinorityInterest5,289 M5,304 M4,170 M4,246 M4,835 M4,571 M4,748 M4,873 M5,389 M5,305 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest10,686 M10,815 M7,479 M7,794 M8,426 M8,541 M9,452 M9,627 M10,705 M10,532 M
TotalNonCurrentLiabilitiesNetMinorityInteres3,795 M3,819 M2,333 M2,603 M2,328 M2,799 M2,624 M3,287 M3,608 M3,366 M
Treasury stock-9,607 M-9,807 M-10,074 M-10,508 M
UnearnedPremiums1,786 M2,284 M2,729 M
Work in progress514 M208 M179 M194 M212 M252 M263 M303 M367 M483 M
Working capital3,381 M3,817 M2,710 M2,690 M2,906 M2,677 M1,109 M1,948 M2,091 M1,917 M
ltinv139 M96 M86 M135 M138 M68 M102 M158 M185 M195 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