Stock Analysis on Net

Amazon.com Inc. (NASDAQ:AMZN)

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Turnover Ratios
Inventory turnover 9.54 9.15 8.40 8.34 9.80
Receivables turnover 18.60 16.86 19.32 23.26 26.09
Payables turnover 3.46 3.59 3.63 3.46 3.22
Working capital turnover 55.79 77.32 24.33 60.82
Average No. Days
Average inventory processing period 38 40 43 44 37
Add: Average receivable collection period 20 22 19 16 14
Operating cycle 58 62 62 60 51
Less: Average payables payment period 106 102 101 105 113
Cash conversion cycle -48 -40 -39 -45 -62

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-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 2022 to 2023 and from 2023 to 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Amazon.com Inc. receivables turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc. payables turnover ratio decreased from 2022 to 2023 and from 2023 to 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 improved from 2022 to 2023 and from 2023 to 2024.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Amazon.com Inc. number of days of receivables outstanding deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.
Operating cycle Equal to average inventory processing period plus average receivables collection period.
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 2022 to 2023 and from 2023 to 2024.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Amazon.com Inc. cash conversion cycle improved from 2022 to 2023 and from 2023 to 2024.

Inventory Turnover

Amazon.com Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of sales 326,288 304,739 288,831 272,344 233,307
Inventories 34,214 33,318 34,405 32,640 23,795
Short-term Activity Ratio
Inventory turnover1 9.54 9.15 8.40 8.34 9.80
Benchmarks
Inventory Turnover, Competitors2
Home Depot Inc. 4.85 4.20 4.55 5.25 5.00
Lowe’s Cos. Inc. 3.41 3.50 3.65 3.71 3.73
TJX Cos. Inc. 6.36 6.21 5.82 5.66 6.13
Inventory Turnover, Sector
Consumer Discretionary Distribution & Retail 6.18 6.10 6.36 6.83
Inventory Turnover, Industry
Consumer Discretionary 6.99 6.67 7.04 7.48

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Inventory turnover = Cost of sales ÷ Inventories
= 326,288 ÷ 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 improved from 2022 to 2023 and from 2023 to 2024.

Receivables Turnover

Amazon.com Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Net sales 637,959 574,785 513,983 469,822 386,064
Customer receivables, net 34,300 34,100 26,600 20,200 14,800
Short-term Activity Ratio
Receivables turnover1 18.60 16.86 19.32 23.26 26.09
Benchmarks
Receivables Turnover, Competitors2
Home Depot Inc. 45.87 47.45 44.12 44.15 52.34
Lowe’s Cos. Inc.
TJX Cos. Inc. 102.49 88.70 93.79 69.69 108.00
Receivables Turnover, Sector
Consumer Discretionary Distribution & Retail 23.15 26.52 30.59 35.28
Receivables Turnover, Industry
Consumer Discretionary 17.84 17.95 21.21 21.81

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Receivables turnover = Net sales ÷ Customer receivables, net
= 637,959 ÷ 34,300 = 18.60

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Amazon.com Inc. receivables turnover ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.

Payables Turnover

Amazon.com Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Cost of sales 326,288 304,739 288,831 272,344 233,307
Accounts payable 94,363 84,981 79,600 78,664 72,539
Short-term Activity Ratio
Payables turnover1 3.46 3.59 3.63 3.46 3.22
Benchmarks
Payables Turnover, Competitors2
Home Depot Inc. 10.13 9.14 7.45 7.52 9.33
Lowe’s Cos. Inc. 6.61 6.16 5.65 5.51 6.42
TJX Cos. Inc. 9.83 9.53 7.77 5.09 11.17
Payables Turnover, Sector
Consumer Discretionary Distribution & Retail 4.61 4.48 4.19 4.25
Payables Turnover, Industry
Consumer Discretionary 5.18 4.80 4.66 4.74

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Payables turnover = Cost of sales ÷ Accounts payable
= 326,288 ÷ 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 2022 to 2023 and from 2023 to 2024.

Working Capital Turnover

Amazon.com Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Current assets 190,867 172,351 146,791 161,580 132,733
Less: Current liabilities 179,431 164,917 155,393 142,266 126,385
Working capital 11,436 7,434 (8,602) 19,314 6,348
 
Net sales 637,959 574,785 513,983 469,822 386,064
Short-term Activity Ratio
Working capital turnover1 55.79 77.32 24.33 60.82
Benchmarks
Working Capital Turnover, Competitors2
Home Depot Inc. 19.67 16.81 417.56 24.87 76.81
Lowe’s Cos. Inc. 24.66 50.26 245.54 24.92 530.50
TJX Cos. Inc. 24.50 23.22 17.40 6.51 23.97
Working Capital Turnover, Sector
Consumer Discretionary Distribution & Retail 42.11 21.83 63.17
Working Capital Turnover, Industry
Consumer Discretionary 14.99 18.57 11.02 13.68

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Working capital turnover = Net sales ÷ Working capital
= 637,959 ÷ 11,436 = 55.79

2 Click competitor name to see calculations.


Average Inventory Processing Period

Amazon.com Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Inventory turnover 9.54 9.15 8.40 8.34 9.80
Short-term Activity Ratio (no. days)
Average inventory processing period1 38 40 43 44 37
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Home Depot Inc. 75 87 80 70 73
Lowe’s Cos. Inc. 107 104 100 98 98
TJX Cos. Inc. 57 59 63 65 60
Average Inventory Processing Period, Sector
Consumer Discretionary Distribution & Retail 59 60 57 53
Average Inventory Processing Period, Industry
Consumer Discretionary 52 55 52 49

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 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 improved from 2022 to 2023 and from 2023 to 2024.

Average Receivable Collection Period

Amazon.com Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Receivables turnover 18.60 16.86 19.32 23.26 26.09
Short-term Activity Ratio (no. days)
Average receivable collection period1 20 22 19 16 14
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Home Depot Inc. 8 8 8 8 7
Lowe’s Cos. Inc.
TJX Cos. Inc. 4 4 4 5 3
Average Receivable Collection Period, Sector
Consumer Discretionary Distribution & Retail 16 14 12 10
Average Receivable Collection Period, Industry
Consumer Discretionary 20 20 17 17

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 18.60 = 20

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Amazon.com Inc. number of days of receivables outstanding deteriorated from 2022 to 2023 but then improved from 2023 to 2024 not reaching 2022 level.

Operating Cycle

Amazon.com Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 38 40 43 44 37
Average receivable collection period 20 22 19 16 14
Short-term Activity Ratio
Operating cycle1 58 62 62 60 51
Benchmarks
Operating Cycle, Competitors2
Home Depot Inc. 83 95 88 78 80
Lowe’s Cos. Inc.
TJX Cos. Inc. 61 63 67 70 63
Operating Cycle, Sector
Consumer Discretionary Distribution & Retail 75 74 69 63
Operating Cycle, Industry
Consumer Discretionary 72 75 69 66

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 38 + 20 = 58

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period.

Average Payables Payment Period

Amazon.com Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Payables turnover 3.46 3.59 3.63 3.46 3.22
Short-term Activity Ratio (no. days)
Average payables payment period1 106 102 101 105 113
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Home Depot Inc. 36 40 49 49 39
Lowe’s Cos. Inc. 55 59 65 66 57
TJX Cos. Inc. 37 38 47 72 33
Average Payables Payment Period, Sector
Consumer Discretionary Distribution & Retail 79 81 87 86
Average Payables Payment Period, Industry
Consumer Discretionary 70 76 78 77

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 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 2022 to 2023 and from 2023 to 2024.

Cash Conversion Cycle

Amazon.com Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Average inventory processing period 38 40 43 44 37
Average receivable collection period 20 22 19 16 14
Average payables payment period 106 102 101 105 113
Short-term Activity Ratio
Cash conversion cycle1 -48 -40 -39 -45 -62
Benchmarks
Cash Conversion Cycle, Competitors2
Home Depot Inc. 47 55 39 29 41
Lowe’s Cos. Inc.
TJX Cos. Inc. 24 25 20 -2 30
Cash Conversion Cycle, Sector
Consumer Discretionary Distribution & Retail -4 -7 -18 -23
Cash Conversion Cycle, Industry
Consumer Discretionary 2 -1 -9 -11

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 38 + 20106 = -48

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Amazon.com Inc. cash conversion cycle improved from 2022 to 2023 and from 2023 to 2024.