Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Amazon.com Inc. (NASDAQ:AMZN)

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

Beginner level

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)

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Turnover Ratios
Inventory turnover 10.54 9.80 8.76 9.81 9.33 8.08 8.33 7.97 8.66 8.10 8.38 8.59 8.69 6.98 7.47 8.35 8.66 7.70 — — —
Payables turnover 3.93 3.22 3.57 3.77 4.39 3.51 4.37 4.11 4.47 3.64 4.30 4.61 4.78 3.23 3.93 4.48 4.86 3.49 — — —
Working capital turnover 69.81 60.82 31.47 18.92 47.22 32.92 38.37 35.44 42.11 34.71 48.44 56.56 69.39 76.87 107.01 308.26 69.18 69.20 — — —
Average No. Days
Average inventory processing period 35 37 42 37 39 45 44 46 42 45 44 42 42 52 49 44 42 47 — — —
Less: Average payables payment period 93 113 102 97 83 104 84 89 82 100 85 79 76 113 93 81 75 105 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Amazon.com Inc.’s inventory turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Amazon.com Inc.’s payables turnover ratio decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Amazon.com Inc.’s working capital turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
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.’s number of days of inventory outstanding improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.
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.’s number of days of payables outstanding increased from Q3 2020 to Q4 2020 but then decreased significantly from Q4 2020 to Q1 2021.

Inventory Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cost of sales 62,403  79,284  57,106  52,660  44,257  53,977  41,302  36,337  33,920  44,786  33,003  30,632  30,735  38,494  27,549  23,451  22,440  28,959  21,260  19,180  18,866 
Inventories 23,849  23,795  23,735  19,599  18,857  20,497  18,766  18,580  16,432  17,174  15,862  14,824  13,840  16,047  13,711  11,510  10,600  11,461  10,696  9,588  9,582 
Short-term Activity Ratio
Inventory turnover1 10.54 9.80 8.76 9.81 9.33 8.08 8.33 7.97 8.66 8.10 8.38 8.59 8.69 6.98 7.47 8.35 8.66 7.70 — — —
Benchmarks
Inventory Turnover, Competitors2
Home Depot Inc. 4.93 5.00 4.65 4.91 4.65 5.10 4.70 4.88 4.65 5.22 4.87 4.98 4.63 4.96 4.64 4.92 4.50 4.93 — — —
Lowe’s Cos. Inc. 3.52 3.73 3.57 3.58 3.26 3.85 3.88 3.95 3.47 3.97 3.65 3.91 3.57 4.07 3.72 3.76 3.55 4.07 — — —
Target Corp. 6.65 6.10 4.80 5.95 5.95 5.61 4.30 5.75 5.97 5.91 4.66 5.95 6.11 5.88 4.91 5.83 6.06 6.05 — — —
TJX Cos. Inc. 5.59 6.13 4.64 5.64 5.59 6.08 4.99 5.96 5.98 6.09 5.17 6.24 6.35 6.47 5.28 5.90 5.76 5.96 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q1 2021 Calculation
Inventory turnover = (Cost of salesQ1 2021 + Cost of salesQ4 2020 + Cost of salesQ3 2020 + Cost of salesQ2 2020) ÷ Inventories
= (62,403 + 79,284 + 57,106 + 52,660) ÷ 23,849 = 10.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.’s inventory turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Payables Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Cost of sales 62,403  79,284  57,106  52,660  44,257  53,977  41,302  36,337  33,920  44,786  33,003  30,632  30,735  38,494  27,549  23,451  22,440  28,959  21,260  19,180  18,866 
Accounts payable 63,926  72,539  58,334  51,036  40,056  47,183  35,794  36,063  31,809  38,192  30,904  27,657  25,172  34,616  26,075  21,439  18,891  25,309  18,801  16,123  14,990 
Short-term Activity Ratio
Payables turnover1 3.93 3.22 3.57 3.77 4.39 3.51 4.37 4.11 4.47 3.64 4.30 4.61 4.78 3.23 3.93 4.48 4.86 3.49 — — —
Benchmarks
Payables Turnover, Competitors2
Booking Holdings Inc. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.03 0.09 0.20 0.38 0.36 0.55 0.94 1.02 — — —
Home Depot Inc. 7.35 9.33 7.91 7.62 6.99 9.16 7.66 7.29 6.90 9.19 7.63 7.51 6.90 8.90 7.63 7.32 6.83 8.87 — — —
Lowe’s Cos. Inc. 4.63 6.42 5.54 5.18 4.26 5.85 5.16 5.22 4.53 6.86 5.09 5.15 4.41 6.40 5.21 5.18 4.45 6.84 — — —
Target Corp. 5.94 5.53 4.86 5.93 6.45 5.46 4.45 5.75 6.35 5.89 4.94 6.48 7.47 6.74 5.98 7.39 8.02 7.01 — — —
TJX Cos. Inc. 25.79 11.17 8.45 11.00 10.97 10.53 8.28 9.99 10.42 10.25 8.18 10.28 10.91 10.56 8.62 10.11 10.52 10.00 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q1 2021 Calculation
Payables turnover = (Cost of salesQ1 2021 + Cost of salesQ4 2020 + Cost of salesQ3 2020 + Cost of salesQ2 2020) ÷ Accounts payable
= (62,403 + 79,284 + 57,106 + 52,660) ÷ 63,926 = 3.93

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.’s payables turnover ratio decreased from Q3 2020 to Q4 2020 but then increased from Q4 2020 to Q1 2021 exceeding Q3 2020 level.

Working Capital Turnover

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data (US$ in millions)
Current assets 121,408  132,733  112,969  110,908  85,985  96,334  79,054  76,790  69,431  75,101  59,885  54,481  50,829  60,197  48,578  41,007  39,460  45,781  35,609  32,220  30,513 
Less: Current liabilities 115,404  126,385  101,912  93,896  79,711  87,812  72,136  69,678  63,695  68,391  55,324  50,801  48,045  57,883  47,072  40,520  37,399  43,816  33,498  29,587  28,187 
Working capital 6,004  6,348  11,057  17,012  6,274  8,522  6,918  7,112  5,736  6,710  4,561  3,680  2,784  2,314  1,506  487  2,061  1,965  2,111  2,633  2,326 
 
Net sales 108,518  125,555  96,145  88,912  75,452  87,437  69,981  63,404  59,700  72,383  56,576  52,886  51,042  60,453  43,744  37,955  35,714  43,741  32,714  30,404  29,128 
Short-term Activity Ratio
Working capital turnover1 69.81 60.82 31.47 18.92 47.22 32.92 38.37 35.44 42.11 34.71 48.44 56.56 69.39 76.87 107.01 308.26 69.18 69.20 — — —
Benchmarks
Working Capital Turnover, Competitors2
Booking Holdings Inc. 0.74 0.77 1.03 1.50 2.83 3.37 3.30 4.02 9.62 2.99 2.55 2.85 2.61 2.29 2.22 2.54 2.95 4.22 — — —
Home Depot Inc. 28.53 76.81 68.95 57.87 124.59 59.68 65.46 43.91 33.09 36.84 26.96 20.77 27.68 26.34 18.99 20.84 23.41 19.82 — — —
Lowe’s Cos. Inc. 20.57 530.50 119.81 74.71 46.13 — 1,031.26 78.17 266.87 101.51 254.28 166.37 112.95 2,500.65 657.58 363.64 25.59 856.14 — — —
Target Corp. 389.66 — — — — — — — — — — — — — 352.16 143.21 37.77 48.93 — — —
TJX Cos. Inc. 6.55 23.97 24.08 23.99 26.62 13.27 11.75 11.43 10.67 10.67 11.76 11.64 11.36 11.09 10.72 12.87 12.25 13.06 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q1 2021 Calculation
Working capital turnover = (Net salesQ1 2021 + Net salesQ4 2020 + Net salesQ3 2020 + Net salesQ2 2020) ÷ Working capital
= (108,518 + 125,555 + 96,145 + 88,912) ÷ 6,004 = 69.81

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.’s working capital turnover ratio improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Average Inventory Processing Period

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Inventory turnover 10.54 9.80 8.76 9.81 9.33 8.08 8.33 7.97 8.66 8.10 8.38 8.59 8.69 6.98 7.47 8.35 8.66 7.70 — — —
Short-term Activity Ratio (no. days)
Average inventory processing period1 35 37 42 37 39 45 44 46 42 45 44 42 42 52 49 44 42 47 — — —
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Home Depot Inc. 74 73 78 74 78 72 78 75 78 70 75 73 79 74 79 74 81 74 — — —
Lowe’s Cos. Inc. 104 98 102 102 112 95 94 92 105 92 100 93 102 90 98 97 103 90 — — —
Target Corp. 55 60 76 61 61 65 85 63 61 62 78 61 60 62 74 63 60 60 — — —
TJX Cos. Inc. 65 60 79 65 65 60 73 61 61 60 71 58 57 56 69 62 63 61 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q1 2021 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 10.54 = 35

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.’s number of days of inventory outstanding improved from Q3 2020 to Q4 2020 and from Q4 2020 to Q1 2021.

Average Payables Payment Period

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016
Selected Financial Data
Payables turnover 3.93 3.22 3.57 3.77 4.39 3.51 4.37 4.11 4.47 3.64 4.30 4.61 4.78 3.23 3.93 4.48 4.86 3.49 — — —
Short-term Activity Ratio (no. days)
Average payables payment period1 93 113 102 97 83 104 84 89 82 100 85 79 76 113 93 81 75 105 — — —
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Booking Holdings Inc. — — — — — — — — — — 12,933 4,151 1,857 972 1,016 659 387 357 — — —
Home Depot Inc. 50 39 46 48 52 40 48 50 53 40 48 49 53 41 48 50 53 41 — — —
Lowe’s Cos. Inc. 79 57 66 70 86 62 71 70 81 53 72 71 83 57 70 70 82 53 — — —
Target Corp. 61 66 75 62 57 67 82 63 57 62 74 56 49 54 61 49 45 52 — — —
TJX Cos. Inc. 14 33 43 33 33 35 44 37 35 36 45 35 33 35 42 36 35 36 — — —

Based on: 10-Q (filing date: 2021-04-30), 10-K (filing date: 2021-02-03), 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-01), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-28), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-10), 10-Q (filing date: 2016-10-28), 10-Q (filing date: 2016-07-29), 10-Q (filing date: 2016-04-29).

1 Q1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.93 = 93

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.’s number of days of payables outstanding increased from Q3 2020 to Q4 2020 but then decreased significantly from Q4 2020 to Q1 2021.