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

AAPL Stock Annual Balance Sheet. Download in Excel

Apple Inc. logo

Apple Inc.

Sector: Technology   

Industry: Consumer Electronics

255.59
 
USD
  
-3.43
  
(-1.32%)
Previous close: 259.02  Open: 257.83  Bid: 254.72  Ask: 254.9
52 week range    
164.08   
   260.10
Mkt Cap: 3,902,905 M  Avg Vol (90 Days): 41,636,506
Peers   
MSFT / 
HPQ / 
GOOG / 
AMZN / 
Last updated: Monday 30th December 2024

Stock Rankings

62
MarketXLS Rank
45
Value
92
Technical
50
Quality
How are these ranks calculated?
Search for a stock

Financials

AAPL Balance Sheet

Annual
Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23Sep-24
Accounts payable35,490 M37,294 M44,242 M55,888 M46,236 M42,296 M54,763 M64,115 M62,611 M68,960 M
Accounts receivable16,849 M15,754 M17,874 M23,186 M22,926 M16,120 M26,278 M28,184 M29,508 M33,410 M
Accrued expenses60,671 M59,321 M44,242 M55,888 M46,236 M42,296 M54,763 M64,115 M62,611 M68,960 M
Accumulated depreciation & depletion-26,786 M-34,235 M-41,293 M-49,099 M-58,579 M-66,760 M-70,283 M-72,340 M-70,884 M-73,448 M
Cash and equivalents21,120 M20,484 M20,289 M25,913 M48,844 M38,016 M34,940 M23,646 M29,965 M29,943 M
CashCashEquivalentsAndShortTermInvestments41,601 M67,155 M74,181 M66,301 M100,557 M90,943 M62,639 M48,304 M61,555 M65,171 M
CashEquivalents21,120 M20,484 M20,289 M25,913 M48,844 M38,016 M34,940 M
CommercialPaper8,500 M8,105 M11,977 M12,000 M6,000 M4,996 M6,000 M9,982 M5,985 M9,967 M
Common par27,416 M31,251 M35,867 M40,201 M45,174 M50,779 M57,365 M64,849 M73,812 M83,276 M
Common stock equity119,355 M128,249 M134,047 M107,147 M90,488 M65,339 M63,090 M50,672 M62,146 M56,950 M
CommonStock27,416 M31,251 M35,867 M40,201 M45,174 M50,779 M57,365 M64,849 M73,812 M83,276 M
Cost in excess5,116 M5,414 M5,717 M
CurrentAccruedExpenses25,181 M22,027 M25,744 M
CurrentCapitalLeaseObligation772 M929 M1,223 M1,298 M1,306 M1,436 M1,449 M1,534 M1,410 M1,488 M
CurrentDeferredRevenue8,940 M8,080 M7,548 M5,966 M5,522 M6,643 M7,612 M7,912 M8,061 M8,249 M
CurrentDeferredTaxesAssets10,911 M10,015 M8,974 M6,610 M19,640 M18,295 M20,326 M21,676 M24,369 M26,007 M
CurrentDeferredTaxesLiabilities27,171 M31,921 M36,562 M5,834 M11,595 M10,138 M13,073 M14,537 M17,251 M19,202 M
Deferred revenues8,940 M8,080 M7,548 M5,966 M5,522 M6,643 M7,612 M7,912 M8,061 M8,249 M
Float term debt53,329 M75,427 M97,207 M93,735 M91,807 M98,667 M109,106 M98,959 M95,281 M85,750 M
GoodwillAndOtherIntangibleAssets9,009 M8,620 M8,015 M
Gross fixed assets (Plant Property & Equipment)49,257 M61,245 M75,076 M90,403 M95,957 M103,526 M109,723 M114,457 M114,599 M119,128 M
IncomeTaxPayable6,552 M8,819 M26,601 M
Intangibles3,893 M3,206 M2,298 M
InterestPayable-733 M-1,456 M-2,323 M-3,240 M-3,576 M-2,873 M-2,645 M-2,931 M-3,933 M
Inventories2,349 M2,132 M4,855 M3,956 M4,106 M4,061 M6,580 M4,946 M6,331 M7,286 M
Invested capital226,013 M279,103 M328,461 M294,617 M274,102 M262,673 M281,302 M248,590 M252,708 M228,450 M
Leases629 M861 M952 M1,015 M1,069 M
LongTermCapitalLeaseObligation7,745 M9,506 M9,936 M10,408 M13,518 M
LongTermDebtAndCapitalLeaseObligation53,329 M75,427 M97,207 M93,735 M91,807 M98,667 M109,106 M98,959 M95,281 M85,750 M
Net fixed assets (net PP&E)22,471 M27,010 M33,783 M41,304 M37,378 M36,766 M39,440 M42,117 M43,715 M45,680 M
NetOtherUnrealizedGainLoss-1,328 M-411 M-782 M4,289 M
Non-current deferred income taxes24,062 M26,019 M31,504 M501 M600 M705 M565 M1,582 M1,998 M2,551 M
NonCurrentAccruedExpenses9,365 M10,055 M8,654 M33,589 M29,545 M28,170 M28,636 M32,485 M34,391 M36,634 M
NonCurrentDeferredLiabilities3,624 M2,930 M2,836 M2,797 M
NonCurrentDeferredRevenue3,624 M2,930 M2,836 M2,797 M20,958 M26,320 M28,636 M
NonCurrentDeferredTaxesAssets721 M788 M834 M797 M20,387 M19,336 M25,229 M29,206 M32,743 M34,873 M
NotesReceivable13,494 M13,545 M17,799 M25,809 M22,878 M21,325 M25,228 M
Other current assets15,085 M8,283 M13,936 M12,087 M12,352 M11,264 M14,111 M21,223 M14,695 M14,287 M
Other equity adjustments-345 M634 M-150 M-3,454 M-584 M-406 M163 M
Other fixed assets22,471 M27,010 M33,783 M41,304 M37,378 M36,766 M39,440 M42,117 M43,715 M45,680 M
Other non-current assets5,422 M8,757 M18,177 M22,283 M32,978 M42,522 M48,849 M54,428 M64,758 M74,834 M
Other non-current liabilities33,427 M36,074 M40,415 M48,914 M50,503 M54,490 M53,325 M49,142 M49,848 M45,888 M
Other receivable13,494 M13,545 M17,799 M25,809 M22,878 M21,325 M25,228 M32,748 M31,477 M32,833 M
OtherCurrentLiabilities30,551 M33,327 M37,720 M42,684 M47,493 M60,845 M58,829 M78,304 M
OtherInventories2,349 M2,132 M4,855 M3,956 M4,106 M4,061 M6,580 M4,946 M6,331 M7,286 M
OtherPayable343 M27,286 M20,736 M11,226 M
Payables35,490 M37,294 M44,242 M55,888 M46,236 M42,296 M54,763 M64,115 M62,611 M68,960 M
RecievablesAdjustmentsAllowances-63 M-53 M-58 M
Restricted cash25,913 M50,224 M
Retained earnings91,939 M96,998 M98,180 M66,946 M45,314 M14,560 M5,725 M-14,177 M-11,666 M-26,326 M
Short term debt11,000 M11,605 M18,473 M20,784 M16,260 M13,769 M15,613 M21,110 M15,807 M20,879 M
Total assets290,345 M321,686 M375,319 M365,725 M338,516 M323,888 M351,002 M352,755 M352,583 M364,980 M
Total current assets89,378 M106,869 M128,645 M131,339 M162,819 M143,713 M134,836 M135,405 M143,566 M152,987 M
Total current liabilities80,611 M79,006 M100,814 M115,965 M105,738 M105,392 M125,481 M153,982 M145,308 M176,392 M
Total equity119,355 M128,249 M134,047 M107,147 M90,488 M65,339 M63,090 M50,672 M62,146 M56,950 M
Total liabilities170,991 M193,437 M241,272 M258,614 M248,048 M258,549 M287,912 M302,083 M290,437 M308,030 M
Total non-current assets200,967 M214,817 M246,674 M234,386 M175,697 M180,175 M216,166 M217,350 M209,017 M211,993 M
Total non-current liabilities90,380 M114,431 M140,458 M142,649 M142,310 M153,157 M162,431 M148,101 M145,129 M131,638 M
TotalEquityGrossMinority119,355 M128,249 M134,047 M107,147 M90,488 M65,339 M63,090 M50,672 M62,146 M56,950 M
TotalEquityGrossMinorityInterest119,355 M128,249 M134,047 M107,147 M90,488 M65,339 M63,090 M50,672 M62,146 M56,950 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest290,345 M321,686 M375,319 M365,725 M338,516 M323,888 M351,002 M352,755 M352,583 M364,980 M
TotalNonCurrentLiabilitiesNetMinorityInteres90,380 M114,431 M140,458 M142,649 M142,310 M153,157 M162,431 M148,101 M145,129 M131,638 M
UnearnedPremiums-248 M-174 M-225 M-218 M-224 M-314 M-380 M-374 M-356 M-321 M
Working capital8,767 M27,863 M27,831 M15,374 M57,081 M38,321 M9,355 M-18,577 M-1,742 M-23,405 M
debtc11,000 M11,605 M18,473 M20,784 M16,260 M13,769 M15,613 M21,110 M15,807 M20,879 M
ltinv164,065 M170,430 M194,714 M170,799 M105,341 M100,887 M127,877 M120,805 M100,544 M91,479 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