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

172.40
 
USD
  
-1.35
  
(-0.78%)
Optionable: Yes  Market Cap: 2,688,463 M  90-day average vol: 58,423,514

Previous close: 173.75  Open: 172.255  Bid: 172.15  Ask: 172.23
52 week range    
124.17   
   198.23
Peers   
MSFT / 
HPQ / 
GOOG / 
AMZN / 
Last updated: Wednesday 4th October 2023
43
MarketXLS Rank
40
Value
23
Technical
68
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

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

AMZN

1,534 B58.53158.71

GOOG

1,830 B25.72778.76

HPQ

0.026741 B6.937.49

MSFT

0.00812,315 B33.1300.95

NFLX

203 B38402.1
Financials

AAPL Income Statement

Annual
Sep-13Sep-14Sep-15Sep-16Sep-17Sep-18Sep-19Sep-20Sep-21Sep-22
Amortization-960 M-1,100 M-1,300 M-1,500 M-1,200 M
Amortization of intangibles-960 M-1,100 M-1,300 M-1,500 M-1,200 M
Basic EPS total10.011.622.322.092.323.02.990.835.676.15
Basic weighted shares outstanding3,701 M24,342 M23,014 M21,883 M20,869 M19,822 M18,471 M69,408 M16,701 M16,216 M
Cost of sales106,606 M112,258 M140,089 M131,376 M141,048 M163,756 M161,782 M169,559 M212,981 M223,546 M
Depreciation-5,800 M-8,300 M-8,200 M-9,300 M-11,300 M-9,700 M-9,500 M-8,700 M
Depreciation unreconciled-6,757 M-9,200 M-8,300 M
DepreciationAndAmortization-6,757 M-9,200 M-8,300 M-8,200 M-9,300 M-11,300 M-9,700 M-9,500 M-8,700 M
Diluted EPS total9.941.612.312.082.32.982.970.825.616.11
Diluted weighted shares outstanding3,727 M24,491 M23,172 M22,001 M21,007 M20,000 M18,596 M70,113 M16,865 M16,326 M
Dividends paid per share2.850.460.50.550.60.680.750.20.850.9
Earnings from equity interest12,188 M12,803 M13,735 M
EarningsFromEquityInterestNetOfTax12,188 M12,803 M13,735 M
GainOnSaleOfSecurity670 M
GeneralAndAdministrativeExpense-645 M-794 M-939 M-1,100 M-1,200 M-1,300 M
Gross operating profit64,304 M70,537 M93,626 M84,263 M88,186 M101,839 M98,392 M104,956 M152,836 M170,782 M
Income before tax50,155 M53,483 M72,515 M61,372 M64,089 M72,903 M65,737 M67,091 M109,207 M119,103 M
Income restructuring and M&A-8,165 M
Income taxes13,118 M13,973 M19,121 M15,685 M15,738 M13,372 M10,481 M9,680 M14,527 M19,300 M
Interest income1,156 M980 M1,285 M1,348 M2,745 M2,005 M1,807 M803 M258 M-334 M
InterestExpenseNonOperating-136 M-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
InterestExpenseOperating-3,000 M-3,200 M-2,800 M-2,600 M-2,800 M
MiscOtherSpecialCharges1,616 M1,795 M2,921 M3,999 M5,201 M5,800 M5,900 M5,000 M6,700 M7,500 M
Net income from total operations37,037 M39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M
NetIncomeCommonStockholders37,037 M39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M
NetIncomeContinuousOperations37,037 M39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M
NetNonOperatingInterestIncomeExpense1,156 M980 M1,285 M1,348 M2,745 M2,005 M1,807 M803 M258 M-334 M
Operating income48,999 M52,503 M71,230 M60,024 M61,344 M70,898 M63,930 M66,288 M108,949 M119,437 M
Operating income before depreciation (EBITDA)43,262 M53,099 M62,582 M59,916 M71,923 M77,566 M71,508 M72,474 M115,246 M124,476 M
OperatingExpense15,305 M18,034 M22,396 M24,239 M26,842 M30,941 M34,462 M38,668 M43,887 M51,345 M
Other income net-1,616 M-1,795 M-2,921 M-16,187 M-18,004 M-5,800 M-5,900 M-5,000 M-6,700 M-7,500 M
OtherGandA-645 M-794 M-939 M-1,100 M-1,200 M-1,300 M
OtherOperatingExpenses-626 M-882 M-1,278 M-1,578 M-1,880 M-1,824 M-1,697 M-1,500 M-1,700 M-1,936 M
PromotionAndAdvertising-1,100 M
RentAndLandingFees-645 M-794 M-939 M-1,100 M-1,200 M-1,300 M
Research & development expense4,475 M6,041 M8,067 M10,045 M11,581 M14,236 M16,217 M18,752 M21,914 M26,251 M
ResearchExpense4,475 M6,041 M8,067 M10,045 M11,581 M14,236 M16,217 M18,752 M21,914 M26,251 M
RestructringAndMnAIncome-8,165 M
SalariesAndWages-2,253 M-2,863 M-3,586 M-4,210 M-4,840 M-5,340 M-6,068 M-6,829 M-7,906 M-9,038 M
Selling Gen & administrative expense10,830 M11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M
SellingAndMarketingExpense10,830 M11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M
SellingExpense10,830 M11,993 M14,329 M14,194 M15,261 M16,705 M18,245 M19,916 M21,973 M25,094 M
Special income/charges8,165 M
Total Income available for interest expense (EBIT)50,019 M53,099 M71,782 M59,916 M61,766 M66,663 M58,961 M61,418 M103,962 M113,372 M
Total common shares outstanding25,193 M23,459 M22,301 M21,329 M20,537 M18,982 M17,773 M17,002 M16,406 M15,908 M
Total net income37,037 M39,510 M53,394 M45,687 M48,351 M59,531 M55,256 M57,411 M94,680 M99,803 M
Total ordinary shares15,634 M15,634 M15,634 M15,634 M15,634 M15,634 M15,634 M15,634 M15,634 M15,634 M
Total revenues170,910 M182,795 M233,715 M215,639 M229,234 M265,595 M260,174 M274,515 M365,817 M394,328 M
TotalExpenses121,911 M130,292 M162,485 M155,615 M167,890 M194,697 M196,244 M208,227 M256,868 M274,891 M
TotalRevenue170,910 M182,795 M233,715 M215,639 M229,234 M265,595 M260,174 M274,515 M365,817 M394,328 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and Templates.
Get started today