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

186.88
 
USD
  
-4.02
  
(-2.11%)
Optionable: Yes  Market Cap: 2,949,511 M  90-day average vol: 63,056,202

Previous close: 190.9  Open: 190.98  Bid: 186.91  Ask: 186.95
52 week range    
164.08   
   199.62
Peers   
MSFT / 
HPQ / 
GOOG / 
AMZN / 
Last updated: Friday 24th May 2024
52
MarketXLS Rank
40
Value
69
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 Income Statement

Annual
Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22Sep-23
Amortization of intangibles4,142 M3,893 M3,206 M2,298 M
Basic EPS from continuing operations1.622.322.092.323.02.993.315.676.156.16
Basic EPS total1.622.322.092.323.02.993.315.676.156.16
Basic weighted shares outstanding24,342 M23,014 M21,883 M20,869 M19,822 M18,471 M17,352 M16,701 M16,216 M15,744 M
Cost of sales112,258 M140,089 M131,376 M141,048 M163,756 M161,782 M169,559 M212,981 M223,546 M214,137 M
Depreciation6,900 M9,200 M8,300 M8,200 M9,300 M11,300 M9,700 M9,500 M8,700 M8,500 M
DepreciationAndAmortization6,900 M9,200 M8,300 M8,200 M9,300 M11,300 M9,700 M9,500 M8,700 M8,500 M
Diluted EPS total1.612.312.082.32.982.973.285.616.116.13
Diluted normalized net income/share1.612.312.082.32.982.973.285.616.116.13
Diluted weighted shares outstanding24,491 M23,172 M22,001 M21,007 M20,000 M18,596 M17,528 M16,865 M16,326 M15,813 M
Dividends paid per share0.460.50.550.60.680.750.80.850.90.94
Earnings from equity interest-12,188 M-12,803 M-13,735 M
EarningsFromEquityInterestNetOfTax-12,188 M-12,803 M-13,735 M
GeneralAndAdministrativeExpense11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M24,932 M
Gross operating profit70,537 M93,626 M84,263 M88,186 M101,839 M98,392 M104,956 M152,836 M170,782 M169,148 M
Income before tax53,483 M72,515 M61,372 M64,089 M72,903 M65,737 M67,091 M109,207 M119,103 M113,736 M
Income restructuring and M&A-9,571 M
Income taxes13,973 M19,121 M15,685 M15,738 M13,372 M10,481 M9,680 M14,527 M19,300 M16,741 M
InterestExpenseNonOperating384 M733 M1,456 M2,323 M3,240 M3,576 M2,873 M2,645 M2,931 M3,933 M
InterestExpenseOperating3,000 M3,200 M2,800 M2,600 M2,800 M3,700 M
MiscOtherSpecialCharges980 M1,285 M1,348 M2,745 M2,005 M1,807 M803 M258 M-334 M-565 M
Net income from total operations39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M96,995 M
NetIncomeCommonStockholders39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M96,995 M
NetIncomeContinuousOperations39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M96,995 M
NetNonOperatingInterestIncomeExpense-384 M-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
Operating income52,503 M71,230 M60,024 M61,344 M70,898 M63,930 M66,288 M108,949 M119,437 M114,301 M
Operating income before depreciation (EBITDA)53,867 M73,248 M62,828 M76,569 M90,046 M85,060 M81,020 M125,736 M135,938 M132,888 M
OperatingExpense18,034 M22,396 M24,239 M26,842 M30,941 M34,462 M38,668 M43,887 M51,345 M54,847 M
Other income net-980 M-1,285 M-1,348 M-2,745 M-2,005 M-1,807 M-803 M-258 M334 M565 M
OtherGandA11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M24,932 M
OtherOperatingExpenses-882 M-1,278 M-1,578 M-1,880 M-1,824 M-1,697 M-1,347 M-1,607 M-1,936 M-2,628 M
PromotionAndAdvertising1,200 M1,800 M
RentAndLandingFees717 M794 M939 M1,100 M1,200 M1,300 M
Research & development expense6,041 M8,067 M10,045 M11,581 M14,236 M16,217 M18,752 M21,914 M26,251 M29,915 M
ResearchExpense6,041 M8,067 M10,045 M11,581 M14,236 M16,217 M18,752 M21,914 M26,251 M29,915 M
RestructringAndMnAIncome-9,571 M
Revenue per share4,142 M3,893 M3,206 M2,298 M
SalariesAndWages-1,400 M-1,600 M-1,893 M-1,967 M-2,476 M-4,056 M-4,002 M-3,421 M
Selling Gen & administrative expense11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M24,932 M
SellingAndMarketingExpense1,200 M1,800 M
Special income/charges9,571 M
Total Income available for interest expense (EBIT)53,867 M73,248 M62,828 M66,412 M79,143 M72,513 M69,964 M114,452 M124,834 M121,369 M
Total common shares outstanding23,459 M22,301 M21,329 M20,537 M18,982 M17,773 M17,002 M16,406 M15,908 M15,553 M
Total net income39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M96,995 M
Total ordinary shares15,334 M15,334 M15,334 M15,334 M15,334 M15,334 M15,334 M15,334 M15,334 M15,334 M
Total revenues182,795 M233,715 M215,639 M229,234 M265,595 M260,174 M274,515 M365,817 M394,328 M383,285 M
TotalExpenses130,292 M162,485 M155,615 M167,890 M194,697 M196,244 M208,227 M256,868 M274,891 M268,984 M
TotalRevenue182,795 M233,715 M215,639 M229,234 M265,595 M260,174 M274,515 M365,817 M394,328 M383,285 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