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
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 8.86 9.21 9.94 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.78 3.84 4.24 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 43.32 39.93 53.59 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 41 40 37 40 43 46 43 43 47 50 46 44 42 33 35 37 42 37 39 45
Less: Average payables payment period 96 95 86 102 88 87 84 101 86 93 91 105 97 92 93 113 102 97 83 104

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc. payables turnover ratio decreased from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Amazon.com Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024.

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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Inventory Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 80,977 73,785 72,633 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 36,103 34,109 31,147 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 8.86 9.21 9.94 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.49 4.43 4.08 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.43 3.57 3.28 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. 4.48 5.56 5.64 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

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Inventory turnover = (Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024 + Cost of salesQ4 2023) ÷ Inventories
= (80,977 + 73,785 + 72,633 + 92,553) ÷ 36,103 = 8.86

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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Payables Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 80,977 73,785 72,633 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,570 81,817 73,068 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.78 3.84 4.24 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. 8.92 8.51 8.20 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.07 6.02 5.39 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. 6.85 8.26 8.43 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

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Payables turnover = (Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024 + Cost of salesQ4 2023) ÷ Accounts payable
= (80,977 + 73,785 + 72,633 + 92,553) ÷ 84,570 = 3.78

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Working Capital Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 175,792 173,307 163,989 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 161,477 158,172 152,965 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 14,315 15,135 11,024 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 158,877 147,977 143,313 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 43.32 39.93 53.59 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. 21.62 20.37 22.32 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. 25.98 20.16 20.34 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. 24.16 25.35 24.41 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

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Working capital turnover = (Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023) ÷ Working capital
= (158,877 + 147,977 + 143,313 + 169,961) ÷ 14,315 = 43.32

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Amazon.com Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 but then slightly improved from Q2 2024 to Q3 2024.

Average Inventory Processing Period

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 8.86 9.21 9.94 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 41 40 37 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. 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78 72
Lowe’s Cos. Inc. 106 102 111 104 113 111 116 100 96 100 106 98 100 94 104 98 102 102 112 95
TJX Cos. Inc. 81 66 65 59 86 72 72 63 74 60 68 65 72 53 65 60 79 65 65 60

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 8.86 = 41

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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Payables Payment Period

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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.78 3.84 4.24 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 96 95 86 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. 41 43 45 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52 40
Lowe’s Cos. Inc. 60 61 68 59 70 72 79 65 65 69 81 66 81 87 79 57 66 70 86 62
TJX Cos. Inc. 53 44 43 38 51 42 45 47 61 52 59 72 88 34 14 33 43 33 33 35

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.78 = 96

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 Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.