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

110.73
 
USD
  
-1.21
  
(-1.08%)
Optionable: Yes  Market Cap: 32,860 M  90-day average vol: 1,881,897

Previous close: 111.94  Open: 110.88  Bid: 110.8  Ask: 113.0
52 week range    
109.00   
   160.27
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Wednesday 27th September 2023
57
MarketXLS Rank
80
Value
15
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
Amortization199 M189 M156 M154 M237 M215 M253 M370 M389 M383 M
Amortization of intangibles199 M189 M156 M154 M120 M110 M128 M186 M195 M192 M
Basic EPS from continuing operations1.081.321.422.120.983.412.333.984.19
Basic EPS total1.521.081.21.422.120.983.412.333.984.19
Basic weighted shares outstanding477 M466 M333 M326 M322 M321 M314 M309 M304 M299 M
BasicDiscontinuousOperations1.08-0.12
Cost of sales2,576 M1,568 M1,496 M1,464 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 total1.51.071.21.42.10.973.372.33.944.18
Diluted normalized net income/share1.071.311.42.10.973.372.33.944.18
Diluted weighted shares outstanding482 M473 M335 M329 M326 M325 M318 M312 M307 M300 M
DilutedDiscontinuousOperations1.07-0.11
Dividends paid per share0.330.380.40.460.530.60.660.720.780.84
Earnings from equity interest7 M-9 M-10 M
EarningsFromEquityInterestNetOfTax7 M-9 M-10 M
GainOnSaleOfBusiness2 M2 M1000000.032 M5 M
GainOnSaleOfSecurity8 M20 M2 M16 M4 M-4 M-8 M27 M98 M-67 M
GainsLossOnDisposalOfDiscontinuedOperations317 M-37 M
GeneralAndAdministrativeExpense1,880 M1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M
Gross operating profit4,206 M2,480 M2,542 M2,738 M2,409 M2,680 M2,805 M2,837 M3,407 M3,722 M
ImpairmentOfCapitalAssets-3 M
Income before tax1,530 M733 M981 M1,085 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
MinorityInterests4 M
MiscOtherSpecialCharges8 M-89 M17 M-10 M19 M79 M16 M66 M92 M-39 M
Net income from total operations1,395 M1,053 M902 M1,003 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
NetIncomeContinuousOperations1,395 M1,053 M902 M1,003 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 income1,078 M813 M663 M763 M520 M-4,552 M-5,505 M708 M1,126 M1,231 M
Operating income1,622 M923 M1,023 M1,156 M841 M904 M941 M846 M1,347 M1,618 M
Operating income before depreciation (EBITDA)1,897 M1,063 M728 M1,403 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
OtherGainLossFromDispositionOfDiscontinuedOperations417 M-39 M
OtherGandA1,880 M1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M
OtherImpairmentOfCapitalAssets1000000.04 M-3 M-18 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
RealizedCapitalGain-5 M6 M13 M121 M52 M262 M35 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
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
SellingExpense1,880 M2,043 M1,189 M1,253 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)1,525 M701 M475 M1,157 M882 M1,022 M994 M920 M1,441 M1,588 M
Total common shares outstanding464 M469 M332 M322 M323 M319 M310 M307 M302 M296 M
Total net income1,395 M1,053 M902 M1,003 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,160 M3,125 M3,015 M3,046 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/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today