Stock Analysis on Net

Amazon.com Inc. (NASDAQ:AMZN)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Amazon.com Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Turnover Ratios
Inventory turnover 9.15 8.41 8.01 8.49 8.40 7.80 7.30 7.90 8.34 8.69 10.90 10.54 9.80 8.76 9.81 9.33 8.08
Payables turnover 3.59 4.14 4.22 4.34 3.63 4.22 3.91 4.03 3.46 3.76 3.98 3.93 3.22 3.57 3.77 4.39 3.51
Working capital turnover 77.32 24.33 31.50 19.23 69.81 60.82 31.47 18.92 47.22 32.92
Average No. Days
Average inventory processing period 40 43 46 43 43 47 50 46 44 42 33 35 37 42 37 39 45
Less: Average payables payment period 102 88 87 84 101 86 93 91 105 97 92 93 113 102 97 83 104

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Amazon.com Inc. inventory turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc. payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Amazon.com Inc. number of days of inventory outstanding improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Amazon.com Inc. number of days of payables outstanding increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Inventory Turnover

Amazon.com Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Cost of sales 92,553 75,022 69,373 67,791 85,640 70,268 66,424 66,499 82,835 62,930 64,176 62,403 79,284 57,106 52,660 44,257 53,977 41,302 36,337 33,920
Inventories 33,318 35,406 36,587 34,170 34,405 36,647 38,153 34,987 32,640 30,933 24,119 23,849 23,795 23,735 19,599 18,857 20,497 18,766 18,580 16,432
Short-term Activity Ratio
Inventory turnover1 9.15 8.41 8.01 8.49 8.40 7.80 7.30 7.90 8.34 8.69 10.90 10.54 9.80 8.76 9.81 9.33 8.08
Benchmarks
Inventory Turnover, Competitors2
Home Depot Inc. 4.20 4.07 3.96 4.01 4.55 4.76 5.06 4.87 5.25 5.13 5.83 4.93 5.00 4.65 4.91 4.65 5.10
Lowe’s Cos. Inc. 3.50 3.23 3.29 3.14 3.65 3.82 3.66 3.44 3.71 3.64 3.90 3.52 3.73 3.57 3.58 3.26 3.85
TJX Cos. Inc. 6.21 4.26 5.04 5.10 5.82 4.90 6.04 5.35 5.66 5.08 6.88 5.59 6.13 4.64 5.64 5.59 6.08 4.99 5.96 5.98

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Inventory turnover = (Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023 + Cost of salesQ1 2023) ÷ Inventories
= (92,553 + 75,022 + 69,373 + 67,791) ÷ 33,318 = 9.15

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Amazon.com Inc. inventory turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Payables Turnover

Amazon.com Inc., payables turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Cost of sales 92,553 75,022 69,373 67,791 85,640 70,268 66,424 66,499 82,835 62,930 64,176 62,403 79,284 57,106 52,660 44,257 53,977 41,302 36,337 33,920
Accounts payable 84,981 72,004 69,481 66,907 79,600 67,760 71,219 68,547 78,664 71,474 66,090 63,926 72,539 58,334 51,036 40,056 47,183 35,794 36,063 31,809
Short-term Activity Ratio
Payables turnover1 3.59 4.14 4.22 4.34 3.63 4.22 3.91 4.03 3.46 3.76 3.98 3.93 3.22 3.57 3.77 4.39 3.51
Benchmarks
Payables Turnover, Competitors2
Home Depot Inc. 9.14 8.43 7.19 6.59 7.45 7.32 7.47 6.44 7.52 6.42 6.73 7.35 9.33 7.91 7.62 6.99 9.16
Lowe’s Cos. Inc. 6.16 5.22 5.03 4.59 5.65 5.62 5.28 4.52 5.51 4.48 4.18 4.63 6.42 5.54 5.18 4.26 5.85
TJX Cos. Inc. 9.53 7.11 8.74 8.16 7.77 5.97 6.96 6.17 5.09 4.13 10.64 25.79 11.17 8.45 11.00 10.97 10.53 8.28 9.99 10.42

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Payables turnover = (Cost of salesQ4 2023 + Cost of salesQ3 2023 + Cost of salesQ2 2023 + Cost of salesQ1 2023) ÷ Accounts payable
= (92,553 + 75,022 + 69,373 + 67,791) ÷ 84,981 = 3.59

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc. payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Working Capital Turnover

Amazon.com Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Current assets 172,351 142,995 140,482 136,221 146,791 131,463 133,667 133,876 161,580 138,531 140,848 121,408 132,733 112,969 110,908 85,985 96,334 79,054 76,790 69,431
Less: Current liabilities 164,917 145,214 148,238 147,570 155,393 140,363 140,291 139,508 142,266 123,994 117,792 115,404 126,385 101,912 93,896 79,711 87,812 72,136 69,678 63,695
Working capital 7,434 (2,219) (7,756) (11,349) (8,602) (8,900) (6,624) (5,632) 19,314 14,537 23,056 6,004 6,348 11,057 17,012 6,274 8,522 6,918 7,112 5,736
 
Net sales 169,961 143,083 134,383 127,358 149,204 127,101 121,234 116,444 137,412 110,812 113,080 108,518 125,555 96,145 88,912 75,452 87,437 69,981 63,404 59,700
Short-term Activity Ratio
Working capital turnover1 77.32 24.33 31.50 19.23 69.81 60.82 31.47 18.92 47.22 32.92
Benchmarks
Working Capital Turnover, Competitors2
Home Depot Inc. 16.81 16.73 30.40 43.84 417.56 41.45 90.49 48.51 24.87 13.79 16.66 28.53 76.81 68.95 57.87 124.59 59.68
Lowe’s Cos. Inc. 50.26 23.32 41.46 25.26 245.54 23.72 27.67 24.04 24.92 11.60 12.67 20.57 530.50 119.81 74.71 46.13
TJX Cos. Inc. 23.22 28.07 29.41 20.26 17.40 14.05 12.91 7.40 6.51 6.91 8.72 6.55 23.97 24.08 23.99 26.62 13.27 11.75 11.43 10.67

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Working capital turnover = (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023) ÷ Working capital
= (169,961 + 143,083 + 134,383 + 127,358) ÷ 7,434 = 77.32

2 Click competitor name to see calculations.


Average Inventory Processing Period

Amazon.com Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Inventory turnover 9.15 8.41 8.01 8.49 8.40 7.80 7.30 7.90 8.34 8.69 10.90 10.54 9.80 8.76 9.81 9.33 8.08
Short-term Activity Ratio (no. days)
Average inventory processing period1 40 43 46 43 43 47 50 46 44 42 33 35 37 42 37 39 45
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Home Depot Inc. 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Lowe’s Cos. Inc. 104 113 111 116 100 96 100 106 98 100 94 104 98 102 102 112 95
TJX Cos. Inc. 59 86 72 72 63 74 60 68 65 72 53 65 60 79 65 65 60 73 61 61

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 9.15 = 40

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Amazon.com Inc. number of days of inventory outstanding improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Average Payables Payment Period

Amazon.com Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Payables turnover 3.59 4.14 4.22 4.34 3.63 4.22 3.91 4.03 3.46 3.76 3.98 3.93 3.22 3.57 3.77 4.39 3.51
Short-term Activity Ratio (no. days)
Average payables payment period1 102 88 87 84 101 86 93 91 105 97 92 93 113 102 97 83 104
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Home Depot Inc. 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52 40
Lowe’s Cos. Inc. 59 70 72 79 65 65 69 81 66 81 87 79 57 66 70 86 62
TJX Cos. Inc. 38 51 42 45 47 61 52 59 72 88 34 14 33 43 33 33 35 44 37 35

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.59 = 102

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Amazon.com Inc. number of days of payables outstanding increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.