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

197.79
 
USD
  
4.46
  
(2.31%)
Optionable: Yes  Market Cap: 93,707 M  90-day average vol: 3,433,683

Previous close: 193.33  Open: 194.04  Bid: 186.0  Ask: 197.71
52 week range    
154.99   
   202.77
Peers   
TXN / 
SLAB / 
CRUS / 
MCHP / 
STM / 
Last updated: Friday 29th March 2024
61
MarketXLS Rank
60
Value
61
Technical
63
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

ADI Balance Sheet

Annual
Oct-14Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22Oct-23
"""debtc"""375 M300 M67 M300 M517 M1,046 M
Accounts payable139 M174 M171 M237 M261 M225 M227 M443 M582 M493 M
Accounts receivable397 M467 M478 M689 M640 M635 M738 M1,459 M1,800 M1,470 M
Accrued expenses431 M439 M431 M822 M985 M1,209 M1,365 M2,254 M2,443 M2,155 M
Accumulated depreciation & depletion-1,856 M-1,958 M-2,041 M-2,197 M-2,373 M-2,591 M-2,765 M-2,956 M-3,148 M-3,425 M
Additional paid in capital643 M634 M402 M5,251 M5,282 M4,936 M4,950 M30,574 M27,857 M25,314 M
Cash and equivalents569 M884 M921 M1,048 M817 M648 M1,056 M1,978 M1,471 M958 M
CashCashEquivalentsAndShortTermInvestments2,866 M3,029 M4,056 M1,048 M817 M648 M1,056 M1,978 M1,471 M958 M
CashEquivalents2,900 M
CommercialPaper547 M
Common par52 M52 M51 M61 M62 M61 M62 M88 M85 M83 M
Common stock equity4,758 M5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M
CommonStock52 M52 M51 M61 M62 M61 M62 M88 M85 M83 M
Cost in excess1,642 M1,637 M1,679 M12,217 M12,253 M12,257 M12,278 M26,918 M26,913 M26,913 M
CurrentAccruedExpenses229 M250 M256 M499 M630 M796 M956 M1,478 M1,595 M1,353 M
CurrentCapitalLeaseObligation23 M22 M34 M42 M39 M80 M40 M53 M54 M65 M
CurrentDeferredAssets150 M153 M26 M33 M40 M47 M
CurrentDeferredTaxesAssets129 M129 M242 M341 M188 M1,799 M1,797 M2,445 M2,435 M2,660 M
CurrentDeferredTaxesLiabilities-313 M65 M-316 M-1,984 M-1,169 M-2,305 M-2,214 M-4,116 M-3,793 M-3,565 M
DefinedPensionBenefit455 M107 M130 M140 M124 M170 M187 M243 M158 M168 M
EmployeeBenefits3 M3 M2 M
Finished goods104 M129 M124 M139 M180 M174 M131 M270 M384 M388 M
Float term debt873 M495 M1,732 M7,551 M6,266 M5,192 M5,709 M7,148 M6,549 M5,902 M
GoodwillAndOtherIntangibleAssets2,314 M2,220 M2,228 M17,537 M17,031 M16,474 M15,929 M42,186 M40,179 M38,225 M
Gross fixed assets (Plant Property & Equipment)2,478 M2,602 M2,677 M3,304 M3,528 M3,811 M3,886 M4,935 M5,550 M6,644 M
IncomeTaxPayable63 M15 M4 M87 M94 M188 M182 M333 M266 M309 M
Intangibles671 M584 M549 M5,319 M4,778 M4,217 M3,650 M15,267 M13,265 M11,312 M
InterestPayable35 M27 M89 M251 M254 M229 M193 M185 M200 M265 M
Inventories368 M412 M377 M551 M587 M610 M608 M1,201 M1,400 M1,642 M
Invested capital6,503 M5,568 M8,630 M25,264 M23,800 M22,094 M22,852 M51,393 M49,563 M47,370 M
Land & improvements51 M56 M60 M75 M
Leases51 M60 M75 M100 M160 M158 M168 M119 M177 M
LongTermCapitalLeaseObligation288 M393 M337 M495 M
LongTermDebtAndCapitalLeaseObligation873 M495 M1,732 M7,551 M6,266 M5,192 M5,145 M6,253 M6,549 M5,902 M
Machinery furniture & equipment1,932 M1,987 M2,053 M2,435 M2,554 M2,695 M2,753 M3,211 M3,648 M4,378 M
Net fixed assets (net PP&E)622 M644 M636 M1,107 M1,154 M1,220 M1,121 M1,979 M2,401 M3,219 M
NetOtherUnrealizedGainLoss-407000.0584000.0-294000.02000.0
Non-current deferred income taxes236 M227 M110 M1,675 M990 M2,088 M1,920 M3,939 M3,623 M3,128 M
NonCurrentAccruedExpenses811 M708 M417 M
NonCurrentDeferredAssets27 M33 M36 M32 M10 M1,582 M1,503 M2,267 M2,265 M2,223 M
NonCurrentDeferredLiabilities257 M251 M136 M1,707 M1,030 M2,088 M1,920 M3,939 M3,623 M3,128 M
NonCurrentDeferredTaxesAssets27 M33 M36 M32 M10 M1,582 M1,503 M2,267 M2,265 M2,223 M
NonCurrentPensionAndOtherPostretirementBenefitPlans-185 M39 M-59 M-59 M-45 M-69 M-78 M-113 M-72 M-76 M
Number of employees24450.024450.024450.024450.024450.024450.024450.024450.024450.024450.0
Other current assets65 M72 M69 M38 M13 M54 M312 M384 M165 M187 M
Other equity adjustments-169 M-51 M-74 M-61 M
Other fixed assets496 M560 M564 M794 M873 M956 M975 M1,979 M2,401 M3,219 M
Other non-current assets50 M41 M47 M56 M63 M54 M384 M520 M743 M
Other non-current liabilities541 M426 M505 M599 M823 M894 M1,041 M556 M515 M581 M
Other receivable6,225 M5,991 M5,603 M7,318 M12,014 M12,306 M
OtherCurrentBorrowings375 M67 M517 M
OtherCurrentLiabilities101 M3 M112 M271 M255 M168 M66 M811 M466 M706 M
OtherInventories368 M377 M551 M587 M610 M608 M1,201 M1,400 M1,642 M
OtherPayable1,946 M7 M83 M
Payables202 M189 M176 M324 M355 M413 M409 M776 M848 M802 M
Preferred securities of subsidiary trust471934.0471934.0471934.0471934.0
PreferredStock471934.0471934.0471934.0471934.0
Prepaid expenses52 M43 M65 M64 M69 M92 M116 M741 M267 M314 M
Raw materials47 M22 M20 M35 M31 M35 M34 M72 M111 M128 M
RecievablesAdjustmentsAllowances-3 M-5 M-2 M-8 M-4 M-3 M-5 M-3 M
Retained earnings4,063 M4,437 M4,712 M4,850 M5,924 M6,711 M6,987 M7,331 M8,523 M10,168 M
Short term debt375 M300 M67 M300 M517 M1,046 M
Total assets6,860 M7,059 M7,970 M21,141 M20,438 M21,393 M21,469 M52,322 M50,302 M48,794 M
Total current assets3,833 M4,103 M5,001 M2,384 M2,152 M2,039 M2,830 M5,378 M4,938 M4,384 M
Total current liabilities431 M813 M431 M1,122 M1,052 M1,509 M1,365 M2,770 M2,443 M3,201 M
Total equity4,758 M5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M
Total liabilities2,105 M1,989 M2,805 M10,980 M9,170 M9,683 M9,471 M14,330 M13,837 M13,229 M
Total non-current assets3,027 M2,955 M2,969 M18,757 M18,286 M19,354 M18,639 M46,944 M45,364 M44,410 M
Total non-current liabilities1,674 M1,175 M2,373 M9,857 M8,118 M8,175 M8,106 M11,559 M11,394 M10,028 M
TotalEquityGrossMinority4,758 M5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M
TotalEquityGrossMinorityInterest4,758 M5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest6,863 M7,062 M7,970 M21,141 M20,438 M21,393 M21,469 M52,322 M50,302 M48,794 M
TotalNonCurrentLiabilitiesNetMinorityInteres1,674 M1,175 M2,373 M9,857 M8,118 M8,175 M8,106 M11,559 M11,394 M10,028 M
TotalTaxPayable63 M15 M4 M87 M94 M188 M182 M333 M266 M309 M
UnearnedPremiums18 M49 M42 M33 M30 M7 M28 M116 M
Work in progress217 M262 M232 M376 M376 M400 M444 M859 M905 M1,126 M
Working capital3,402 M3,290 M4,570 M1,262 M1,100 M530 M1,465 M2,608 M2,495 M1,183 M
ltinv13 M17 M22 M25 M29 M77 M87 M128 M122 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