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

Amazon.com Inc.

Sector: Consumer Cyclical   

Industry: Specialty Retail

183.13
 
USD
  
-0.02
  
(-0.01%)
Optionable: Yes  Market Cap: 1,905,974 M  90-day average vol: 39,383,439

Previous close: 183.15  Open: 183.88  Bid: 183.16  Ask: 183.27
52 week range    
114.31   
   191.70
Peers   
GOOGL / 
EBAY / 
TSLA / 
NFLX / 
MSFT / 
Last updated: Thursday 23rd May 2024
40
MarketXLS Rank
20
Value
38
Technical
63
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 ($)

EBAY

0.012338 B3.358.7

GOOGL

1,827 B26.12784.02

IBM

0.047899 B21137.24

MSFT

0.00812,315 B33.1300.95

NFLX

203 B38402.1

TSLA

935 B303.1907.34
Financials

AMZN Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Amortization of intangibles-559 M3,759 M3,784 M13,350 M14,548 M14,754 M15,017 M15,371 M20,288 M22,789 M
Basic EPS from continuing operations-0.030.060.250.321.031.172.133.3-0.272.95
Basic EPS total-0.030.060.250.321.031.172.133.3-0.272.95
Basic weighted shares outstanding9,240 M9,340 M9,480 M9,600 M9,740 M9,880 M10,000 M10,120 M10,189 M10,304 M
Cost of sales62,752 M71,651 M88,265 M111,934 M139,156 M165,536 M233,307 M272,344 M288,831 M304,739 M
Depreciation3,616 M4,949 M6,400 M8,831 M12,138 M21,789 M16,239 M34,433 M24,924 M30,225 M
DepreciationAndAmortization3,616 M4,949 M6,400 M8,831 M12,138 M21,789 M16,239 M34,433 M24,924 M30,225 M
Diluted EPS total-0.030.060.250.311.011.152.093.24-0.272.9
Diluted normalized net income/share-0.030.060.250.311.011.152.093.24-0.272.9
Diluted weighted shares outstanding9,240 M9,540 M9,680 M9,860 M10,000 M10,080 M10,200 M10,300 M10,189 M10,492 M
Earnings from equity interest37 M-22 M-96 M-4 M9 M-14 M16 M4 M-3 M-12 M
EarningsFromEquityInterestNetOfTax37 M-22 M-96 M-4 M9 M-14 M16 M4 M-3 M-12 M
GainOnSaleOfSecurity8 M2 M3 M18 M145 M231 M92 M85 M43 M2 M
GeneralAndAdministrativeExpense1,552 M1,747 M2,432 M3,674 M4,336 M5,203 M6,668 M8,823 M11,891 M11,816 M
Gross operating profit26,236 M35,355 M47,722 M65,932 M93,731 M114,986 M152,757 M197,478 M225,152 M270,046 M
ImpairmentOfCapitalAssets641 M642 M634 M545 M1,100 M
Income before tax-111 M1,568 M3,892 M3,806 M11,261 M13,976 M24,178 M38,151 M-5,936 M37,557 M
Income restructuring and M&A311 M-576 M720 M
Income taxes167 M950 M1,425 M769 M1,197 M2,374 M2,863 M4,791 M-3,217 M7,120 M
Interest income39 M50 M100 M202 M440 M832 M555 M448 M989 M2,949 M
InterestExpenseNonOperating210 M459 M484 M848 M1,417 M1,600 M1,647 M1,809 M2,367 M3,182 M
MarketingExpense4,332 M5,254 M7,233 M10,069 M13,814 M18,878 M22,008 M32,551 M42,238 M44,370 M
MiscOtherSpecialCharges-118 M-256 M90 M346 M-183 M203 M2,371 M14,633 M-16,806 M938 M
Net income from total operations-241 M596 M2,371 M3,033 M10,073 M11,588 M21,331 M33,364 M-2,722 M30,425 M
NetIncomeCommonStockholders39,841 M52,496 M69,779 M98,771 M135,801 M163,914 M223,845 M295,690 M312,302 M30,425 M
NetIncomeContinuousOperations-241 M596 M2,371 M3,033 M10,073 M11,588 M21,331 M33,364 M-2,722 M30,425 M
NetNonOperatingInterestIncomeExpense-171 M-409 M-384 M-646 M-977 M-768 M-1,092 M-1,361 M-1,378 M-233 M
Normalized income31,270 M
Operating income178 M2,233 M4,186 M4,106 M12,421 M14,541 M22,899 M24,879 M12,248 M36,852 M
Operating income before depreciation (EBITDA)4,845 M8,308 M12,492 M16,132 M28,019 M37,365 M51,076 M74,393 M38,352 M89,402 M
OperatingExpense6,017 M7,172 M9,832 M13,957 M18,446 M24,282 M28,601 M41,436 M55,392 M56,953 M
Other income net81 M278 M6 M-342 M174 M-189 M-2,387 M-14,637 M16,809 M-926 M
OtherGandA1,552 M1,747 M2,432 M3,674 M4,336 M5,203 M6,668 M8,823 M11,891 M11,816 M
OtherOperatingExpenses133 M171 M167 M214 M296 M201 M-75 M62 M1,263 M767 M
OtherWriteOff188 M290 M403 M515 M731 M793 M1,000 M1,100 M1,300 M1,600 M
PromotionAndAdvertising6,300 M8,200 M11,000 M10,900 M16,900 M20,600 M20,300 M
RentAndLandingFees961 M1,100 M1,400 M2,200 M3,400 M
RestructringAndMnAIncome311 M-576 M720 M
Revenue per share941 M6,459 M3,784 M13,350 M14,548 M24,848 M23,469 M25,228 M26,385 M28,688 M
SalariesAndWages1,497 M114 M-907 M-860 M-1,100 M-1,400 M-1,900 M-2,700 M-4,300 M-5,400 M
Selling Gen & administrative expense5,884 M7,001 M9,665 M13,743 M18,150 M24,081 M28,676 M41,374 M54,129 M56,186 M
SellingAndMarketingExpense4,332 M5,254 M7,233 M10,069 M13,814 M18,878 M22,008 M32,551 M42,238 M44,370 M
Special income/charges-952 M-642 M-634 M-545 M-1,820 M
Total Income available for interest expense (EBIT)99 M2,027 M4,376 M4,654 M12,678 M15,576 M25,825 M39,960 M-3,569 M40,739 M
Total common shares outstanding9,288 M9,417 M9,543 M9,682 M9,824 M9,956 M10,071 M10,177 M10,247 M10,387 M
Total net income-241 M596 M2,371 M3,033 M10,073 M11,588 M21,331 M33,364 M-2,722 M30,425 M
Total ordinary shares10,407 M10,407 M10,407 M10,407 M10,407 M10,407 M10,407 M10,407 M10,407 M10,407 M
Total revenues88,988 M107,006 M135,987 M177,866 M232,887 M280,522 M386,064 M469,822 M513,983 M574,785 M
TotalExpenses68,769 M78,823 M98,097 M125,891 M157,602 M189,818 M261,908 M313,780 M344,223 M361,692 M
TotalRevenue88,988 M107,006 M135,987 M177,866 M232,887 M280,522 M386,064 M469,822 M513,983 M574,785 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