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, 2024 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
Turnover Ratios
Inventory turnover 9.54 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
Payables turnover 3.46 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
Working capital turnover 55.79 43.32 39.93 53.59 77.32 24.33 31.50 19.23 69.81 60.82
Average No. Days
Average inventory processing period 38 41 40 37 40 43 46 43 43 47 50 46 44 42 33 35 37
Less: Average payables payment period 106 96 95 86 102 88 87 84 101 86 93 91 105 97 92 93 113

Based on: 10-K (reporting date: 2024-12-31), 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).

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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc. payables turnover ratio decreased from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Amazon.com Inc. working capital turnover ratio improved from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.
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 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Inventory Turnover

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

Microsoft Excel
Dec 31, 2024 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
Selected Financial Data (US$ in millions)
Cost of sales 98,893 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
Inventories 34,214 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
Short-term Activity Ratio
Inventory turnover1 9.54 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
Benchmarks
Inventory Turnover, Competitors2
Home Depot Inc. 4.85 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
Lowe’s Cos. Inc. 3.41 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
TJX Cos. Inc. 6.36 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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Q4 2024 Calculation
Inventory turnover = (Cost of salesQ4 2024 + Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024) ÷ Inventories
= (98,893 + 80,977 + 73,785 + 72,633) ÷ 34,214 = 9.54

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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Payables Turnover

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

Microsoft Excel
Dec 31, 2024 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
Selected Financial Data (US$ in millions)
Cost of sales 98,893 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
Accounts payable 94,363 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
Short-term Activity Ratio
Payables turnover1 3.46 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
Benchmarks
Payables Turnover, Competitors2
Home Depot Inc. 10.13 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
Lowe’s Cos. Inc. 6.61 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
TJX Cos. Inc. 9.83 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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Q4 2024 Calculation
Payables turnover = (Cost of salesQ4 2024 + Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024) ÷ Accounts payable
= (98,893 + 80,977 + 73,785 + 72,633) ÷ 94,363 = 3.46

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

Working Capital Turnover

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

Microsoft Excel
Dec 31, 2024 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
Selected Financial Data (US$ in millions)
Current assets 190,867 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
Less: Current liabilities 179,431 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
Working capital 11,436 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
 
Net sales 187,792 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
Short-term Activity Ratio
Working capital turnover1 55.79 43.32 39.93 53.59 77.32 24.33 31.50 19.23 69.81 60.82
Benchmarks
Working Capital Turnover, Competitors2
Home Depot Inc. 19.67 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
Lowe’s Cos. Inc. 24.66 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.50 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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Q4 2024 Calculation
Working capital turnover = (Net salesQ4 2024 + Net salesQ3 2024 + Net salesQ2 2024 + Net salesQ1 2024) ÷ Working capital
= (187,792 + 158,877 + 147,977 + 143,313) ÷ 11,436 = 55.79

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

Average Inventory Processing Period

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

Microsoft Excel
Dec 31, 2024 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
Selected Financial Data
Inventory turnover 9.54 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
Short-term Activity Ratio (no. days)
Average inventory processing period1 38 41 40 37 40 43 46 43 43 47 50 46 44 42 33 35 37
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Home Depot Inc. 75 81 82 89 87 90 92 91 80 77 72 75 70 71 63 74 73 78 74 78
Lowe’s Cos. Inc. 107 106 102 111 104 113 111 116 100 96 100 106 98 100 94 104 98 102 102 112
TJX Cos. Inc. 57 81 66 65 59 86 72 72 63 74 60 68 65 72 53 65 60 79 65 65

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Q4 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 9.54 = 38

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 Q2 2024 to Q3 2024 but then improved from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Average Payables Payment Period

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

Microsoft Excel
Dec 31, 2024 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
Selected Financial Data
Payables turnover 3.46 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
Short-term Activity Ratio (no. days)
Average payables payment period1 106 96 95 86 102 88 87 84 101 86 93 91 105 97 92 93 113
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Home Depot Inc. 36 41 43 45 40 43 51 55 49 50 49 57 49 57 54 50 39 46 48 52
Lowe’s Cos. Inc. 55 60 61 68 59 70 72 79 65 65 69 81 66 81 87 79 57 66 70 86
TJX Cos. Inc. 37 53 44 43 38 51 42 45 47 61 52 59 72 88 34 14 33 43 33 33

Based on: 10-K (reporting date: 2024-12-31), 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).

1 Q4 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.46 = 106

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