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

180.38
 
USD
  
0.55
  
(0.31%)
Optionable: Yes  Market Cap: 1,852,070 M  90-day average vol: 44,121,410

Previous close: 179.83  Open: 180.17  Bid: 179.99  Ask: 180.01
52 week range    
97.71   
   181.70
Peers   
GOOGL / 
EBAY / 
TSLA / 
NFLX / 
MSFT / 
Last updated: Friday 29th March 2024
53
MarketXLS Rank
20
Value
76
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

Financials

AMZN Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
Accounts payable16,459 M20,397 M25,309 M34,616 M38,192 M47,183 M72,539 M78,664 M79,600 M84,981 M
Accounts receivable5,612 M5,654 M8,339 M13,164 M16,677 M20,816 M24,542 M32,891 M42,360 M52,253 M
Accrued expenses26,266 M30,769 M25,309 M34,616 M61,855 M79,622 M116,677 M130,439 M142,166 M149,690 M
Accumulated depreciation & depletion-5,763 M-8,215 M-13,327 M-23,790 M-33,973 M-46,975 M-60,434 M-78,519 M-97,015 M-120,111 M
Additional paid in capital11,135 M13,394 M17,186 M21,389 M26,791 M33,658 M42,865 M55,437 M75,066 M99,025 M
Cash and equivalents14,557 M15,890 M19,334 M20,522 M31,750 M36,092 M42,122 M36,220 M53,888 M73,387 M
CashCashEquivalentsAndShortTermInvestments17,416 M19,808 M25,981 M30,986 M41,250 M55,021 M84,396 M96,049 M70,026 M86,780 M
CashEquivalents14,557 M15,890 M19,334 M20,522 M31,750 M36,092 M42,122 M
Common par5 M5 M5 M5 M5 M5 M5 M106 M108 M109 M
Common stock equity10,741 M13,384 M19,285 M27,709 M43,549 M62,060 M93,404 M138,245 M146,043 M201,875 M
CommonStock5 M5 M5 M5 M5 M5 M5 M106 M108 M109 M
Construction in progress467 M378 M714 M
Cost in excess3,319 M3,759 M3,784 M13,350 M14,548 M14,754 M15,017 M15,371 M20,288 M22,789 M
CurrentAccruedExpenses9,807 M10,372 M13,739 M23,663 M32,439 M44,138 M51,775 M62,566 M64,709 M
CurrentCapitalLeaseObligation5,182 M-3,000 M-4,000 M-5,800 M7,720 M28,875 M30,437 M25,866 M18,019 M14,106 M
CurrentDeferredRevenue1,823 M3,118 M4,768 M5,097 M6,536 M8,190 M9,708 M11,827 M13,227 M15,227 M
CurrentDeferredTaxesAssets2,106 M2,343 M3,074 M2,960 M3,784 M11,157 M15,643 M22,177 M34,509 M45,788 M
CurrentDeferredTaxesLiabilities271 M-203 M454 M-531 M-544 M-1,321 M-866 M-494 M7,513 M13,197 M
Deferred revenues1,823 M3,118 M4,768 M5,097 M6,536 M8,190 M9,708 M11,827 M13,227 M15,227 M
Float term debt8,265 M8,227 M7,694 M24,743 M23,495 M23,414 M31,816 M48,744 M67,150 M58,314 M
GoodwillAndOtherIntangibleAssets3,319 M3,759 M3,784 M13,350 M14,548 M14,754 M15,017 M15,371 M20,288 M22,789 M
Gross fixed assets (Plant Property & Equipment)22,730 M30,053 M42,441 M72,656 M95,770 M144,821 M211,101 M294,882 M349,853 M396,801 M
Intangibles1,534 M1,847 M1,900 M4,422 M5,350 M5,298 M6,476 M6,933 M8,282 M10,082 M
Inventories8,299 M10,243 M11,461 M16,047 M17,174 M20,497 M23,795 M32,640 M34,405 M33,318 M
InventoriesAdjustmentsAllowances-1,600 M-2,300 M-2,600 M-2,800 M-3,000 M
Invested capital27,271 M29,838 M34,673 M77,195 M90,539 M108,888 M157,036 M235,733 M280,343 M318,503 M
Leases7,900 M12,000 M17,000 M26,400 M36,100 M57,400 M
LongTermCapitalLeaseObligation3,026 M4,212 M5,100 M8,438 M9,600 M31,963 M44,833 M66,269 M81,273 M90,777 M
LongTermDebtAndCapitalLeaseObligation8,265 M8,227 M7,694 M24,743 M23,495 M23,414 M31,816 M48,744 M67,150 M58,314 M
LongTermProvisions225 M289 M451 M626 M878 M1,000 M1,400 M1,000 M1,600 M1,900 M
Net fixed assets (net PP&E)16,967 M21,838 M29,114 M48,866 M61,797 M97,846 M150,667 M216,363 M252,838 M276,690 M
NetOtherUnrealizedGainLoss525 M11,526 M-13,870 M984 M
Non-current deferred income taxes-1,609 M-1,970 M-2,332 M-2,568 M-3,579 M-5,507 M-5,508 M-4,019 M-9,039 M-12,454 M
NonCurrentDeferredRevenue1,188 M244 M499 M1,000 M1,400 M2,000 M1,900 M2,200 M2,900 M5,700 M
NonCurrentDeferredTaxesAssets3,007 M3,412 M4,086 M5,498 M8,734 M16,911 M21,446 M25,773 M38,883 M50,599 M
Number of employees2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M
Other current assets710 M1,181 M1,710 M2,309 M3,414 M3,923 M2,820 M3,242 M4,002 M5,200 M
Other equity adjustments-511 M-723 M-985 M-484 M-1,035 M-986 M-180 M
Other fixed assets16,967 M21,838 M29,114 M48,866 M61,797 M97,846 M150,667 M216,363 M252,838 M276,690 M
Other non-current assets2,892 M3,445 M4,723 M8,897 M11,202 M16,314 M22,778 M27,235 M42,758 M56,024 M
Other non-current liabilities7,410 M9,249 M12,607 M20,975 M27,213 M51,962 M69,590 M23,643 M21,121 M102,748 M
Other receivable177,866 M232,887 M280,522 M386,064 M469,822 M513,983 M574,785 M
OtherCurrentLiabilities31,126 M33,616 M13,739 M18,170 M23,663 M39,791 M7,600 M67,651 M72,968 M7,700 M
OtherInventories8,299 M10,243 M11,461 M16,047 M17,174 M20,497 M23,795 M32,640 M34,405 M33,318 M
OtherPayable13,972 M2,186 M2,461 M34,902 M34,776 M35,484 M
Payables16,459 M20,397 M25,309 M34,616 M38,192 M47,183 M72,539 M78,664 M79,600 M84,981 M
Preferred securities of subsidiary trust500 M500 M500 M500 M500 M500 M500 M
PreferredStock500 M500 M500 M500 M500 M500 M500 M
Prepaid expenses4,500 M5,400 M
RecievablesAdjustmentsAllowances-190 M-189 M-237 M-348 M-495 M-718 M-1,100 M-1,100 M-1,400 M-1,700 M
Restricted cash-285 M21,856 M32,173 M36,410 M42,377 M36,477 M54,253 M73,890 M
Retained earnings1,438 M1,822 M3,931 M8,152 M18,590 M30,234 M52,371 M84,539 M78,706 M110,578 M
Total assets54,505 M64,747 M83,402 M131,310 M162,648 M225,248 M321,195 M420,549 M462,675 M527,854 M
Total current assets31,327 M35,705 M45,781 M60,197 M75,101 M96,334 M132,733 M161,580 M146,791 M172,351 M
Total current liabilities28,089 M33,887 M43,816 M57,883 M68,391 M87,812 M126,385 M142,266 M155,393 M164,917 M
Total equity10,741 M13,384 M19,285 M27,709 M43,549 M62,060 M93,404 M138,245 M146,043 M201,875 M
Total liabilities43,764 M51,363 M64,117 M103,601 M119,099 M163,188 M227,791 M282,304 M316,632 M325,979 M
Total non-current assets23,178 M29,042 M37,621 M71,113 M87,547 M128,914 M188,462 M258,969 M315,884 M355,503 M
Total non-current liabilities15,675 M17,476 M20,301 M45,718 M50,708 M75,376 M101,406 M72,387 M88,271 M161,062 M
TotalEquityGrossMinority10,741 M13,384 M19,285 M27,709 M43,549 M62,060 M93,404 M138,245 M146,043 M201,875 M
TotalEquityGrossMinorityInterest10,741 M13,384 M19,285 M27,709 M43,549 M62,060 M93,404 M138,245 M146,043 M201,875 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest54,505 M64,747 M83,402 M131,310 M162,648 M225,248 M321,195 M420,549 M462,675 M527,854 M
TotalNonCurrentLiabilitiesNetMinorityInteres15,675 M17,476 M20,301 M45,718 M50,708 M75,376 M101,406 M72,387 M88,271 M161,062 M
Treasury stock-1,837 M-1,837 M-1,837 M-1,837 M-1,837 M-1,837 M-1,837 M-1,837 M-7,837 M-7,837 M
UnearnedPremiums97 M90 M
Working capital3,238 M1,818 M1,965 M2,314 M6,710 M8,522 M6,348 M19,314 M-8,602 M7,434 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.

We respect your privacy and will never share your email.
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