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

145.51
 
USD
  
-1.86
  
(-1.26%)
Optionable: Yes  Market Cap: 42,320 M  90-day average vol: 1,650,928

Previous close: 147.37  Open: 147.54  Bid: 142.92  Ask: 147.1
52 week range    
96.80   
   151.58
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Friday 29th March 2024
75
MarketXLS Rank
55
Value
92
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 Income Statement

Annual
Oct-13Oct-14Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22
AcquisitionExpense29 M11 M13 M41 M30 M23 M48 M41 M41 M25 M
Amortization of intangibles3,047 M2,507 M2,366 M2,517 M2,607 M2,973 M3,593 M3,602 M3,975 M3,952 M
Basic EPS from continuing operations2.120.71.321.422.120.983.412.333.984.19
Basic EPS total2.121.651.21.422.120.983.412.333.984.19
Basic weighted shares outstanding341 M333 M333 M326 M322 M321 M314 M309 M304 M299 M
BasicDiscontinuousOperations0.95-0.12
Cost of sales3,247 M2,072 M1,997 M2,005 M2,063 M2,234 M2,358 M2,502 M2,912 M3,126 M
Depreciation181 M120 M98 M95 M94 M102 M111 M119 M122 M120 M
DepreciationAndAmortization181 M120 M98 M95 M94 M102 M111 M119 M122 M120 M
Diluted EPS total2.11.621.21.42.10.973.372.33.944.18
Diluted normalized net income/share2.10.691.311.42.10.973.372.33.944.18
Diluted weighted shares outstanding345 M338 M335 M329 M326 M325 M318 M312 M307 M300 M
DilutedDiscontinuousOperations0.93-0.11
Dividends paid per share0.460.530.40.460.530.60.660.720.780.84
Earnings from equity interest7 M-9 M-10 M
EarningsFromEquityInterestNetOfTax7 M-9 M-10 M
GainOnSaleOfSecurity13 M-1000000.018 M-3 M1000000.0-4 M-8 M27 M98 M11 M
GainsLossOnDisposalOfDiscontinuedOperations412 M-39 M
GeneralAndAdministrativeExpense1,880 M1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M
Gross operating profit3,535 M1,976 M2,041 M2,197 M2,409 M2,680 M2,805 M2,837 M3,407 M3,722 M
Income before tax859 M229 M480 M544 M803 M946 M919 M842 M1,360 M1,504 M
Income restructuring and M&A53 M68 M12 M11 M-210 M-1,012 M2 M5 M7 M
Income taxes135 M-3 M42 M82 M119 M630 M-152 M123 M150 M250 M
Interest income7 M9 M7 M11 M22 M38 M36 M8 M2 M9 M
InterestExpenseNonOperating107 M110 M66 M72 M79 M75 M74 M78 M81 M84 M
InterestExpenseOperating-112 M-142 M-71 M1000000.01000000.0
MinorityInterests5,289 M5,304 M4,170 M4,246 M4,835 M4,571 M4,748 M4,873 M5,389 M
MiscOtherSpecialCharges8 M-89 M17 M-10 M19 M79 M16 M66 M92 M-39 M
Net income from total operations724 M549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M
NetIncomeCommonStockholders1,395 M1,053 M902 M1,003 M684 M316 M1,071 M719 M1,210 M1,254 M
NetIncomeContinuousOperations724 M549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M
NetIncomeDiscontinuousOperations317 M-37 M
NetNonOperatingInterestIncomeExpense-100 M-101 M-59 M-61 M-57 M-37 M-38 M-70 M-79 M-75 M
NonRecurringOperationExpense6 M11 M
Normalized income641 M309 M337 M413 M552 M-4,552 M-5,505 M708 M1,126 M1,231 M
Operating income951 M419 M522 M615 M841 M904 M941 M846 M1,347 M1,618 M
Operating income before depreciation (EBITDA)1,226 M559 M728 M862 M1,094 M1,232 M1,232 M1,228 M1,762 M1,905 M
OperatingExpense2,584 M1,557 M1,519 M1,582 M1,568 M1,776 M1,864 M1,991 M2,060 M2,104 M
Other income net-8 M89 M-17 M10 M-19 M-79 M-16 M-66 M-92 M39 M
OtherGainLossFromDispositionOfDiscontinuedOperations317 M-37 M
OtherGandA1,880 M1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M
OtherImpairmentOfCapitalAssets1000000.04 M3 M
OtherOperatingExpenses-53 M-45 M-33 M-31 M-32 M-27 M-7 M-6 M-6 M-412 M
OtherWriteOff7 M
PromotionAndAdvertising44 M31 M25 M30 M38 M41 M36 M48 M63 M66 M
RentAndLandingFees90 M55 M65 M61 M57 M64 M75 M
Research & development expense704 M358 M330 M329 M339 M387 M404 M495 M441 M467 M
ResearchExpense704 M358 M330 M329 M339 M387 M404 M495 M441 M467 M
RestructringAndMnAIncome53 M68 M12 M11 M-210 M-1,012 M2 M5 M7 M
Revenue per share3,047 M2,507 M2,366 M2,517 M2,724 M3,078 M3,718 M3,786 M4,169 M4,143 M
SalariesAndWages-2 M-1000000.054 M58 M60 M70 M72 M83 M110 M125 M
Selling Gen & administrative expense1,880 M1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M
SellingAndMarketingExpense44 M31 M25 M30 M38 M41 M36 M48 M63 M66 M
Special income/charges-53 M-68 M-12 M-11 M210 M1,012 M-2 M-11 M-18 M
Total Income available for interest expense (EBIT)854 M197 M475 M616 M882 M1,022 M994 M920 M1,441 M1,588 M
Total common shares outstanding464 M335 M332 M322 M323 M319 M310 M307 M302 M296 M
Total net income724 M549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M
Total ordinary shares293 M293 M293 M293 M293 M293 M293 M293 M293 M293 M
Total revenues6,782 M4,048 M4,038 M4,202 M4,472 M4,914 M5,163 M5,339 M6,319 M6,848 M
TotalExpenses5,831 M3,629 M3,516 M3,587 M3,631 M4,010 M4,222 M4,493 M4,972 M5,230 M
TotalRevenue6,782 M4,048 M4,038 M4,202 M4,472 M4,914 M5,163 M5,339 M6,319 M6,848 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