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

Apple Inc.

Sector: Technology   

Industry: Consumer Electronics

165.00
 
USD
  
-2.04
  
(-1.22%)
Optionable: Yes  Market Cap: 2,615,546 M  90-day average vol: 61,526,826

Previous close: 167.04  Open: 166.21  Bid: 164.4  Ask: 164.64
52 week range    
162.80   
   199.62
Peers   
MSFT / 
HPQ / 
GOOG / 
AMZN / 
Last updated: Monday 22nd April 2024
40
MarketXLS Rank
45
Value
30
Technical
47
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

AAPL Cash Flow

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
(Increase) Decrease in inventories-76 M-238 M217 M-2,723 M828 M-289 M-127 M-2,642 M1,484 M-1,618 M
(Increase) Decrease in other current assets167 M-179 M1,090 M-5,318 M-423 M873 M-9,588 M
(Increase) Decrease in other current liabilities7,470 M9,788 M-3,587 M499 M38,446 M-5,325 M10,997 M7,475 M6,110 M3,031 M
(Increase) Decrease in other working capital167 M-179 M1,055 M-5,318 M-423 M873 M-9,588 M-8,042 M-6,499 M-5,684 M
(Increase) Decrease in payables5,938 M5,400 M1,837 M8,966 M9,175 M-1,923 M-4,062 M12,326 M9,448 M-1,889 M
(Increase) Decrease in receivables-4,232 M-3,124 M476 M-6,347 M-13,332 M3,176 M8,470 M-14,028 M-9,343 M-417 M
Acquisitions-3,765 M-343 M-297 M-329 M-721 M-624 M-1,524 M-33 M-306 M
CapitalExpenditureReported9,813 M11,488 M13,548 M12,451 M13,313 M10,495 M7,309 M11,085 M10,708 M10,959 M
Cash at beginning of period14,259 M13,844 M21,120 M20,484 M20,289 M25,913 M50,224 M39,789 M35,929 M24,977 M
Cash at end of period13,844 M21,120 M20,484 M20,289 M25,913 M50,224 M39,789 M35,929 M24,977 M30,737 M
Cash flow59,713 M81,266 M65,824 M64,225 M77,434 M69,391 M80,674 M104,038 M122,151 M110,543 M
CashFlowFromContinuingInvestingActivities-22,579 M-56,274 M-45,977 M-46,446 M16,066 M45,896 M-4,289 M-14,545 M-22,354 M3,705 M
ChangeInAccountPayable5,938 M5,400 M1,837 M8,966 M9,175 M-1,923 M-4,062 M12,326 M9,448 M-1,889 M
ChangeInPayablesAndAccruedExpense5,938 M5,400 M1,837 M8,966 M9,175 M-1,923 M-4,062 M12,326 M9,448 M-1,889 M
ChangeInWorkingCapital9,267 M11,647 M-2 M-4,923 M34,694 M-3,488 M5,690 M-4,911 M1,200 M-6,577 M
ChangesInAccountReceivables-4,232 M611 M527 M-2,093 M-5,322 M245 M6,917 M-10,125 M-1,823 M-1,688 M
CommonStockDividendPaid-12,150 M-12,769 M-13,712 M-14,119 M-14,081 M-14,467 M-14,841 M-15,025 M
CommonStockPayments-45,000 M-35,253 M-29,722 M-32,900 M-72,738 M-66,897 M-72,358 M-85,971 M-89,402 M-77,550 M
Current deferred income taxes2,347 M1,382 M4,938 M5,966 M-32,590 M-340 M-215 M-4,774 M895 M
Deferred income taxes2,347 M1,382 M4,938 M5,966 M-32,590 M-340 M-215 M-4,774 M895 M
Depreciation10,157 M10,903 M12,547 M11,056 M11,284 M11,104 M11,519 M
Depreciation unreconciled10,157 M10,903 M12,547 M11,056 M11,284 M11,104 M11,519 M
DepreciationAndAmortization10,157 M10,903 M12,547 M11,056 M11,284 M11,104 M11,519 M
FinancingCashFlow-37,549 M-17,716 M-20,483 M-17,974 M-87,876 M-90,976 M-86,820 M-93,353 M-110,749 M-108,488 M
Free cash flow49,900 M69,778 M52,276 M51,774 M64,121 M58,896 M73,365 M92,953 M111,443 M99,584 M
IncomeTaxPaidSupplementalData10,026 M13,252 M10,444 M11,591 M10,417 M15,263 M9,501 M25,385 M19,573 M18,679 M
InterestPaidSupplementalData339 M514 M1,316 M2,092 M3,022 M3,423 M3,002 M2,687 M2,865 M3,803 M
Issuance of capital stock730 M543 M495 M555 M669 M781 M880 M1,105 M
Issuance of debt6,306 M2,191 M-397 M3,852 M-37 M-5,977 M-963 M1,022 M3,955 M-3,978 M
IssuanceOfCapitalStock730 M543 M495 M555 M669 M781 M880 M1,105 M
IssuanceOfDebt18,266 M29,305 M22,057 M29,014 M432 M-7,819 M2,499 M12,665 M-123 M-9,901 M
Net cash from financing activities-37,549 M-17,716 M-20,483 M-17,974 M-87,876 M-90,976 M-86,820 M-93,353 M-110,749 M-108,488 M
Net cash from investing activities-22,579 M-56,274 M-45,977 M-46,446 M16,066 M45,896 M-4,289 M-14,545 M-22,354 M3,705 M
Net cash from operating activities59,713 M81,266 M65,824 M64,225 M77,434 M69,391 M80,674 M104,038 M122,151 M110,543 M
Net change in cash & cash equivalents-415 M7,276 M-636 M-195 M5,624 M24,311 M-10,435 M-3,860 M-10,952 M5,760 M
Net income from continuing operations39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M96,995 M
NetBusinessPurchaseAndSale-3,765 M-343 M-297 M-329 M-721 M-624 M-1,524 M-33 M-306 M
NetCommonStockIssuance-44,270 M-34,710 M-29,227 M-32,345 M-72,069 M-66,116 M-71,478 M-85,971 M-89,402 M-77,550 M
NetIntangiblesPurchaseAndSale-242 M-241 M-814 M-344 M
NetInvestmentPropertiesPurchaseAndSale-9,001 M-44,443 M-32,132 M-33,666 M30,100 M57,015 M4,544 M-3,427 M-11,646 M14,664 M
NetInvestmentPurchaseAndSale-9,001 M-44,443 M-32,132 M-33,666 M30,100 M57,015 M4,544 M-3,427 M-11,646 M14,664 M
NetIssuancePaymentsOfDebt18,266 M29,305 M22,057 M29,014 M432 M-7,819 M2,499 M12,665 M-123 M-9,901 M
NetLongTermDebtIssuance11,960 M27,114 M22,454 M25,162 M469 M-1,842 M3,462 M11,643 M-4,078 M-5,923 M
NetPPEPurchaseAndSale-9,571 M-11,247 M-12,734 M-12,451 M-13,313 M-10,495 M-7,309 M-11,085 M-10,708 M-10,959 M
Other financing charges net-11,545 M-12,311 M-1,163 M-1,874 M-2,527 M-2,922 M-3,760 M-5,580 M-6,383 M-6,012 M
Other investing changes net16 M-26 M-110 M-124 M-745 M-1,078 M-791 M-352 M-2,086 M-1,337 M
Other non-cash items8,589 M14,843 M15,201 M4,674 M4,896 M5,416 M6,732 M7,759 M10,044 M8,606 M
Payment of cash dividends12,150 M12,769 M13,712 M14,119 M14,081 M14,467 M14,841 M15,025 M
Purchase of Float term investments-217,128 M-166,402 M-142,428 M-159,486 M-71,356 M-39,630 M-114,938 M-109,558 M-76,923 M-29,513 M
Purchase of property plant & equipment-9,813 M-11,488 M-13,548 M-12,451 M-13,313 M-10,495 M-7,309 M-11,085 M-10,708 M-10,959 M
Purchase of short term investments11,960 M27,114 M24,954 M28,662 M6,969 M6,963 M16,091 M20,393 M5,465 M5,228 M
PurchaseOfIntangibles-242 M-241 M-814 M-344 M
PurchaseOfInvestment-217,128 M-166,402 M-143,816 M-160,007 M-73,227 M-40,631 M-115,148 M-109,558 M-76,923 M-29,513 M
PurchaseOfLongTermInvestments-1,388 M-521 M-1,871 M-1,001 M-210 M-131 M
PurchaseOfPPE-9,571 M-11,247 M-12,734 M-12,451 M-13,313 M-10,495 M-7,309 M-11,085 M-10,708 M-10,959 M
Repayment of debt-2,500 M-3,500 M-6,500 M-8,805 M-12,629 M-8,750 M-9,543 M-11,151 M
RepaymentOfDebt-2,500 M-3,500 M-6,500 M-8,805 M-12,629 M-8,750 M-9,543 M-11,151 M
Repurchase of capital stock-45,000 M-35,253 M-29,722 M-32,900 M-72,738 M-66,897 M-72,358 M-85,971 M-89,402 M-77,550 M
Sale of Float term investments126 M353 M1,634 M92 M387 M
Sale of short term investments208,111 M121,985 M111,794 M126,339 M103,719 M97,090 M120,391 M106,483 M67,363 M45,514 M
SaleOfInvestment208,111 M121,985 M111,794 M126,465 M104,072 M98,724 M120,483 M106,483 M67,363 M45,514 M
ShortTermDebtIssuance6,306 M2,191 M-397 M3,852 M-37 M-5,977 M-963 M1,022 M3,955 M-3,978 M
StockBasedCompensation2,863 M3,586 M4,210 M4,840 M5,340 M6,068 M6,829 M7,906 M9,038 M10,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