Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
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
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
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
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
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
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. |