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

ADI Stock Annual Balance Sheet. Download in Excel

Analog Devices Inc. logo

Analog Devices Inc.

Sector: Technology   

Industry: Semiconductors

211.78
 
USD
  
4.00
  
(1.93%)
Previous close: 207.78  Open: 206.28  Bid: 212.01  Ask: 215.82
52 week range    
181.81   
   244.14
Mkt Cap: 106,118 M  Avg Vol (90 Days): 2,792,438
Peers   
TXN / 
SLAB / 
CRUS / 
MCHP / 
STM / 
Last updated: Sunday 22nd December 2024

Stock Rankings

52
MarketXLS Rank
75
Value
38
Technical
44
Quality
How are these ranks calculated?
Search for a stock

Financials

ADI Balance Sheet

Annual
Oct-15Oct-16Oct-17Oct-18Oct-19Oct-20Oct-21Oct-22Oct-23Oct-24
Accounts payable174 M171 M237 M261 M225 M227 M443 M582 M493 M487 M
Accounts receivable467 M478 M689 M640 M635 M738 M1,459 M1,800 M1,470 M1,336 M
Accrued expenses439 M431 M822 M985 M1,209 M1,365 M2,254 M2,443 M2,155 M2,041 M
Accumulated depreciation & depletion-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-3,772 M
Additional paid in capital634 M402 M5,251 M5,282 M4,936 M4,950 M30,574 M27,857 M25,314 M25,082 M
Cash and equivalents884 M921 M1,048 M817 M648 M1,056 M1,978 M1,471 M958 M1,991 M
CashCashEquivalentsAndShortTermInvestments3,029 M4,056 M1,048 M817 M648 M1,056 M1,978 M1,471 M958 M2,363 M
CashEquivalents642 M1,399 M
CommercialPaper547 M548 M
Common par52 M51 M61 M62 M61 M62 M88 M85 M83 M83 M
Common stock equity5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M35,176 M
CommonStock52 M51 M61 M62 M61 M62 M88 M85 M83 M83 M
Cost in excess1,637 M1,679 M12,217 M12,253 M12,257 M12,278 M26,918 M26,913 M26,913 M26,910 M
CurrentAccruedExpenses250 M256 M499 M630 M796 M956 M1,478 M1,595 M1,353 M1,106 M
CurrentCapitalLeaseObligation22 M34 M42 M39 M80 M40 M53 M54 M65 M68 M
CurrentDeferredAssets153 M26 M33 M40 M47 M
CurrentDeferredTaxesAssets129 M242 M341 M188 M1,799 M1,797 M2,445 M2,435 M2,660 M2,759 M
CurrentDeferredTaxesLiabilities-301 M-316 M-1,984 M-1,169 M-2,305 M-2,214 M-4,116 M-3,793 M-3,565 M-3,299 M
DefinedPensionBenefit107 M130 M140 M124 M170 M187 M243 M158 M168 M203 M
EmployeeBenefits3 M2 M
Finished goods129 M124 M139 M180 M174 M131 M270 M384 M388 M307 M
Float term debt495 M1,732 M7,551 M6,266 M5,192 M5,145 M6,253 M6,549 M5,902 M6,634 M
GoodwillAndOtherIntangibleAssets2,220 M2,228 M17,537 M17,031 M16,474 M15,929 M42,186 M40,179 M38,225 M36,495 M
Gross fixed assets (Plant Property & Equipment)2,602 M2,677 M3,304 M3,528 M3,811 M3,886 M4,935 M5,550 M6,644 M7,188 M
IncomeTaxPayable15 M4 M87 M94 M188 M182 M333 M266 M309 M447 M
Intangibles584 M549 M5,319 M4,778 M4,217 M3,650 M15,267 M13,265 M11,312 M9,585 M
InterestPayable27 M89 M251 M254 M229 M193 M185 M200 M265 M
Inventories412 M377 M551 M587 M610 M608 M1,201 M1,400 M1,642 M1,448 M
Invested capital6,064 M8,630 M25,264 M23,800 M22,094 M22,288 M50,499 M49,563 M47,370 M48,445 M
Land & improvements56 M60 M75 M
Leases56 M60 M75 M100 M160 M158 M168 M119 M177 M191 M
LongTermCapitalLeaseObligation288 M296 M337 M360 M435 M
LongTermDebtAndCapitalLeaseObligation495 M1,732 M7,551 M6,266 M5,192 M5,145 M6,253 M6,549 M5,902 M6,634 M
Machinery furniture & equipment1,987 M2,053 M2,435 M2,554 M2,695 M2,753 M3,211 M3,648 M4,356 M4,457 M
Net fixed assets (net PP&E)644 M636 M1,107 M1,154 M1,220 M1,121 M1,979 M2,401 M3,219 M3,416 M
NetOtherUnrealizedGainLoss-584000.0-294000.02000.0
NetUnrealizedGainLossForeignCurrency14 M16 M
Non-current deferred income taxes227 M110 M1,675 M990 M2,088 M1,920 M3,939 M3,623 M3,128 M2,624 M
NonCurrentAccruedExpenses811 M708 M417 M260 M
NonCurrentDeferredAssets33 M36 M32 M10 M1,582 M1,503 M2,267 M2,265 M2,223 M2,084 M
NonCurrentDeferredLiabilities251 M136 M1,707 M1,030 M2,088 M1,920 M3,939 M3,623 M3,128 M2,624 M
NonCurrentDeferredTaxesAssets33 M36 M32 M10 M1,582 M1,503 M2,267 M2,265 M2,223 M2,084 M
NonCurrentPensionAndOtherPostretirementBenefitPlans-39 M-59 M-59 M-45 M-69 M-78 M-113 M-72 M-76 M-107 M
Other current assets72 M69 M38 M13 M54 M312 M133 M165 M187 M163 M
Other equity adjustments-51 M-74 M-61 M
Other fixed assets560 M564 M794 M873 M956 M975 M1,979 M2,401 M3,219 M3,416 M
Other non-current assets41 M47 M56 M63 M54 M384 M520 M743 M749 M
Other non-current liabilities126 M505 M599 M823 M894 M1,041 M556 M515 M581 M544 M
Other receivable6,225 M5,991 M5,603 M7,318 M12,014 M12,306 M9,427 M
OtherCurrentBorrowings375 M67 M517 M
OtherCurrentLiabilities300 M112 M271 M255 M168 M204 M382 M466 M308 M220 M
OtherInventories412 M377 M551 M587 M610 M608 M1,201 M1,400 M1,642 M1,448 M
OtherPayable7 M83 M
Payables189 M176 M324 M355 M413 M409 M776 M848 M802 M935 M
Preferred securities of subsidiary trust471934.0471934.0471934.0
PreferredStock471934.0471934.0471934.0
Prepaid expenses43 M65 M64 M69 M92 M116 M741 M267 M314 M337 M
Raw materials22 M20 M35 M31 M35 M34 M72 M111 M128 M94 M
RecievablesAdjustmentsAllowances-2 M-5 M-2 M-8 M-4 M-3 M-5 M-3 M-7 M
Retained earnings4,386 M4,712 M4,850 M5,924 M6,711 M6,987 M7,331 M8,523 M10,168 M10,011 M
Short term debt375 M300 M67 M300 M517 M1,046 M947 M
Total assets7,059 M7,970 M21,141 M20,438 M21,393 M21,469 M52,322 M50,302 M48,794 M48,228 M
Total current assets4,103 M5,001 M2,384 M2,152 M2,039 M2,830 M5,378 M4,938 M4,384 M5,485 M
Total current liabilities1,114 M431 M1,122 M1,052 M1,509 M1,365 M2,770 M2,443 M3,201 M2,988 M
Total equity5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M35,176 M
Total liabilities1,989 M2,805 M10,980 M9,170 M9,683 M9,471 M14,330 M13,837 M13,229 M13,052 M
Total non-current assets2,955 M2,969 M18,757 M18,286 M19,354 M18,639 M46,944 M45,364 M44,410 M42,744 M
Total non-current liabilities875 M2,373 M9,857 M8,118 M8,175 M8,106 M11,559 M11,394 M10,028 M10,064 M
TotalEquityGrossMinority5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M35,176 M
TotalEquityGrossMinorityInterest5,073 M5,166 M10,162 M11,268 M11,709 M11,998 M37,993 M36,465 M35,565 M35,176 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest7,059 M7,970 M21,141 M20,438 M21,393 M21,469 M52,322 M50,302 M48,794 M48,228 M
TotalNonCurrentLiabilitiesNetMinorityInteres875 M2,373 M9,857 M8,118 M8,175 M8,106 M11,559 M11,394 M10,028 M10,064 M
TotalTaxPayable15 M4 M87 M94 M188 M182 M333 M266 M309 M447 M
UnearnedPremiums18 M49 M42 M33 M30 M7 M28 M116 M83 M
Work in progress262 M232 M376 M376 M400 M444 M859 M905 M1,126 M1,047 M
Working capital2,990 M4,570 M1,262 M1,100 M530 M1,465 M2,608 M2,495 M1,183 M2,496 M
debtc375 M300 M67 M300 M517 M1,046 M947 M
ltinv17 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.

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