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

Analog Devices Inc.

Sector: Technology   

Industry: Semiconductors

Optionable: Yes  Market Cap: 120,744 M  90-day average vol: 3,133,812

Previous close: 238.99  Open: 240.3  Bid: 231.0  Ask: 231.5
52 week range    
Last updated: Monday 22nd July 2024
MarketXLS Rank

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



StockDividendMarket Cap (B)PEPrice ($)

ADI Income Statement

AcquisitionExpense41 M48 M
Amortization of intangibles1,642 M-92 M1,679 M12,217 M12,253 M12,257 M12,278 M26,918 M26,913 M26,913 M
Basic EPS from continuing operations2.012.232.792.094.053.683.313.55.296.6
Basic EPS total2.010.312.792.094.053.683.313.55.296.6
Basic weighted shares outstanding313 M313 M309 M346 M370 M369 M369 M397 M519 M502 M
Cost of sales1,035 M1,176 M1,194 M2,046 M1,974 M1,977 M1,913 M2,793 M4,481 M4,428 M
Depreciation114 M-130 M8 M13 M229 M241 M
Depreciation unreconciled8 M13 M
DepreciationAndAmortization114 M-130 M8 M13 M229 M241 M
DevelopmentExpense51 M
Diluted EPS total1.980.32.762.074.03.653.283.465.256.55
Diluted normalized net income/share1.982.22.762.074.03.653.283.465.256.55
Diluted weighted shares outstanding318 M317 M312 M350 M375 M373 M372 M401 M523 M506 M
Dividends paid per share1.451.661.771.892.42.692.973.34
GainOnSaleOfBusiness-227 M
GainOnSaleOfPPE14 M
GainOnSaleOfSecurity-6 M-5 M-7 M
GeneralAndAdministrativeExpense475 M224 M461 M691 M696 M648 M660 M915 M1,266 M1,274 M
Gross operating profit1,830 M2,259 M2,227 M3,062 M4,250 M4,014 M3,690 M4,525 M7,532 M7,877 M
ImpairmentOfCapitalAssets13 M3 M92 M
Income before tax729 M810 M957 M828 M1,655 M1,486 M1,312 M1,329 M3,099 M3,608 M
Income restructuring and M&A37 M-700000.014 M49 M61 M96 M52 M84 M275 M161 M
Income taxes100 M-165 M95 M101 M148 M123 M91 M-62 M350 M293 M
InsuranceAndClaims29 M
Interest income12 M9 M21 M30 M9 M10 M4 M1 M7 M41 M
InterestExpenseNonOperating35 M27 M89 M251 M254 M229 M193 M185 M200 M265 M
InterestExpenseOperating-26 M
MarketingExpense40 M
MiscOtherSpecialCharges-528000.0-2 M-4 M-6 M-69000.0-6 M2 M-180 M14 M8 M
Net income from total operations629 M697 M862 M727 M1,507 M1,363 M1,221 M1,390 M2,749 M3,315 M
NetIncomeCommonStockholders631 M741 M938 M1,218 M2,365 M2,221 M2,080 M2,464 M2,749 M3,315 M
NetIncomeContinuousOperations629 M697 M862 M727 M1,507 M1,363 M1,221 M1,390 M2,749 M3,315 M
NetIncomeDiscontinuousOperations-27 M
NetNonOperatingInterestIncomeExpense-23 M-18 M-68 M-221 M-244 M-219 M-189 M-184 M-194 M-223 M
Normalized income-2,523 M664 M635 M1,369 M3,011 M
Operating income752 M762 M1,028 M1,055 M1,900 M1,711 M1,498 M1,692 M3,279 M3,823 M
Operating income before depreciation (EBITDA)906 M1,034 M1,255 M1,663 M2,708 M2,526 M2,316 M2,588 M5,597 M6,166 M
OperatingExpense1,078 M1,428 M1,199 M2,006 M2,351 M2,303 M2,192 M2,833 M4,254 M4,054 M
Other income net24 M2 M4 M6 M69000.06 M-2 M180 M-14 M-8 M
OtherGainLossFromDispositionOfDiscontinuedOperations-27 M
OtherGandA475 M224 M461 M691 M696 M648 M660 M915 M1,266 M1,274 M
OtherImpairmentOfCapitalAssets7 M500000.0
OtherOperatingExpenses-26 M88 M-70 M-297 M-429 M-429 M-429 M-537 M-1,013 M-960 M
OtherTaxes7 M51 M
PromotionAndAdvertising3 M-3 M6 M12 M10 M
RentAndLandingFees51 M-52 M59 M59 M85 M92 M
Research & development expense560 M637 M654 M1,020 M1,165 M1,130 M1,051 M1,296 M1,701 M1,660 M
ResearchExpense560 M637 M654 M969 M1,165 M1,130 M1,051 M1,296 M1,701 M1,660 M
RestructringAndMnAIncome37 M-700000.014 M49 M61 M96 M52 M84 M275 M161 M
Revenue per share1,647 M-85 M1,680 M12,219 M12,254 M12,258 M12,281 M26,921 M26,915 M26,914 M
SalariesAndWages30 M69 M27 M-176000.036 M36 M38 M46 M51 M55 M
SecuritiesAmortization21 M
Selling Gen & administrative expense475 M703 M461 M691 M696 M648 M660 M915 M1,266 M1,274 M
SellingAndMarketingExpense3 M479 M6 M12 M10 M
SellingExpense23 M479 M
Special income/charges-37 M700000.0-42 M-49 M-61 M-96 M-52 M-84 M-275 M-161 M
Total Income available for interest expense (EBIT)764 M812 M1,046 M1,079 M1,909 M1,715 M1,505 M1,514 M3,299 M3,873 M
Total common shares outstanding311 M312 M308 M369 M370 M368 M369 M525 M509 M496 M
Total net income629 M697 M862 M727 M1,507 M1,363 M1,221 M1,390 M2,749 M3,315 M
Total ordinary shares496 M496 M496 M496 M496 M496 M496 M496 M496 M496 M
Total revenues2,865 M3,435 M3,421 M5,108 M6,225 M5,991 M5,603 M7,318 M12,014 M12,306 M
TotalExpenses2,112 M2,604 M2,393 M4,052 M4,325 M4,280 M4,105 M5,626 M8,735 M8,482 M
TotalRevenue2,865 M3,435 M3,421 M5,108 M6,225 M5,991 M5,603 M7,318 M12,014 M12,306 M
WriteDown29 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


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.


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