Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

A Stock Annual Income Statement. Download in Excel

Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: Healthcare   

Industry: Diagnostics & Research

132.06
 
USD
  
3.49
  
(2.71%)
Previous close: 128.57  Open: 129.71  Bid: 132.06  Ask: 133.0
52 week range    
123.48   
   155.35
Mkt Cap: 36,114 M  Avg Vol (90 Days): 1,564,468
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Friday 22nd November 2024

Stock Rankings

49
MarketXLS Rank
70
Value
30
Technical
47
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Financials

A Income Statement

Annual
Oct-14Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22Oct-23
AcquisitionExpense11 M13 M41 M30 M23 M48 M41 M41 M25 M
Amortization of intangibles2,507 M2,366 M2,517 M2,607 M2,973 M3,593 M3,602 M3,975 M3,952 M-13 M
Basic EPS from continuing operations0.71.321.422.120.983.412.333.984.194.22
Basic EPS total1.651.21.422.120.983.412.333.984.194.22
Basic weighted shares outstanding333 M333 M326 M322 M321 M314 M309 M304 M299 M294 M
BasicDiscontinuousOperations0.95-0.12
Cost of sales2,072 M1,997 M2,005 M2,063 M2,234 M2,358 M2,502 M2,912 M3,126 M3,368 M
Depreciation120 M98 M95 M94 M102 M111 M119 M122 M120 M128 M
DepreciationAndAmortization120 M98 M95 M94 M102 M111 M119 M122 M120 M128 M
Diluted EPS total1.621.21.42.10.973.372.33.944.184.19
Diluted normalized net income/share0.691.311.42.10.973.372.33.944.184.19
Diluted weighted shares outstanding338 M335 M329 M326 M325 M318 M312 M307 M300 M296 M
DilutedDiscontinuousOperations0.93-0.11
Dividends paid per share0.530.40.460.530.60.660.720.780.840.96
Earnings from equity interest7 M-9 M-10 M
EarningsFromEquityInterestNetOfTax7 M-9 M-10 M
GainOnSaleOfBusiness43 M
GainOnSaleOfPPE48 M68 M
GainOnSaleOfSecurity-1000000.018 M-3 M1000000.0-4 M-8 M27 M98 M11 M-41 M
GainsLossOnDisposalOfDiscontinuedOperations412 M-39 M
GeneralAndAdministrativeExpense1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M1,634 M
Gross operating profit1,976 M2,041 M2,197 M2,409 M2,680 M2,805 M2,837 M3,407 M3,722 M3,465 M
Income before tax229 M480 M544 M803 M946 M919 M842 M1,360 M1,504 M1,339 M
Income restructuring and M&A68 M12 M11 M-210 M-1,012 M2 M5 M7 M46 M
Income taxes-3 M42 M82 M119 M630 M-152 M123 M150 M250 M99 M
Interest income9 M7 M11 M22 M38 M36 M8 M2 M9 M51 M
InterestExpenseNonOperating110 M66 M72 M79 M75 M74 M78 M81 M84 M95 M
InterestExpenseOperating-142 M-71 M1000000.01000000.0
MinorityInterests5,304 M4,170 M4,246 M4,835 M4,571 M4,748 M4,873 M
MiscOtherSpecialCharges-89 M17 M-10 M19 M79 M16 M66 M92 M-39 M33 M
Net income from total operations549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M1,240 M
NetIncomeCommonStockholders1,053 M902 M1,003 M684 M316 M1,071 M719 M1,210 M1,254 M1,240 M
NetIncomeContinuousOperations549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M1,240 M
NetIncomeDiscontinuousOperations317 M-37 M
NetNonOperatingInterestIncomeExpense-101 M-59 M-61 M-57 M-37 M-38 M-70 M-79 M-75 M-44 M
NonRecurringOperationExpense6 M11 M
Normalized income309 M337 M413 M552 M-4,552 M708 M
Operating income419 M522 M615 M841 M904 M941 M846 M1,347 M1,618 M1,350 M
Operating income before depreciation (EBITDA)559 M728 M862 M1,094 M1,232 M1,231 M1,228 M1,762 M1,905 M1,705 M
OperatingExpense1,557 M1,519 M1,582 M1,568 M1,776 M1,864 M1,991 M2,060 M2,104 M2,115 M
Other income net89 M-17 M10 M-19 M-79 M-16 M-66 M-92 M-39 M33 M
OtherGainLossFromDispositionOfDiscontinuedOperations317 M-37 M
OtherGandA1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M1,634 M
OtherImpairmentOfCapitalAssets4 M3 M
OtherOperatingExpenses-45 M-33 M-31 M-32 M-27 M-7 M-6 M-6 M-412 M-5 M
OtherWriteOff7 M
PromotionAndAdvertising31 M25 M30 M38 M41 M36 M48 M63 M66 M54 M
RentAndLandingFees55 M65 M61 M57 M64 M75 M
Research & development expense358 M330 M329 M339 M387 M404 M495 M441 M467 M481 M
ResearchExpense358 M330 M329 M339 M387 M404 M495 M441 M467 M481 M
RestructringAndMnAIncome68 M12 M11 M-210 M-1,012 M2 M5 M7 M46 M
Revenue per share2,507 M2,366 M2,517 M2,724 M3,078 M3,718 M3,786 M4,169 M3,952 M-13 M
SalariesAndWages-1000000.054 M58 M60 M70 M72 M83 M110 M125 M
Selling Gen & administrative expense1,199 M1,189 M1,253 M1,229 M1,389 M1,460 M1,496 M1,619 M1,637 M1,634 M
SellingAndMarketingExpense31 M25 M30 M38 M41 M36 M48 M63 M66 M54 M
Special income/charges-68 M-12 M-11 M210 M1,012 M-2 M-11 M-18 M-46 M
Total Income available for interest expense (EBIT)197 M475 M616 M882 M1,022 M993 M920 M1,441 M1,588 M1,434 M
Total common shares outstanding335 M332 M322 M323 M319 M310 M307 M302 M296 M293 M
Total net income549 M401 M462 M684 M316 M1,071 M719 M1,210 M1,254 M1,240 M
Total ordinary shares287 M287 M287 M287 M287 M287 M287 M287 M287 M287 M
Total revenues4,048 M4,038 M4,202 M4,472 M4,914 M5,163 M5,339 M6,319 M6,848 M6,833 M
TotalExpenses3,629 M3,516 M3,587 M3,631 M4,010 M4,222 M4,493 M4,972 M5,230 M5,483 M
TotalRevenue4,048 M4,038 M4,202 M4,472 M4,914 M5,163 M5,339 M6,319 M6,848 M6,833 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