Stock Analysis on Net

Amazon.com Inc. (NASDAQ:AMZN)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Amazon.com Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
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
Net fixed asset turnover 2.82 2.82 2.78 2.75 2.75 2.83 2.80 2.84 2.93 3.11 3.32 3.45 3.41 3.48 3.72 3.81 3.86
Net fixed asset turnover (including operating lease, right-of-use asset) 2.08 2.07 2.04 2.03 2.03 2.10 2.09 2.13 2.17 2.30 2.51 2.61 2.56 2.59 2.80 2.85 2.87
Total asset turnover 1.09 1.14 1.13 1.13 1.11 1.17 1.16 1.16 1.12 1.20 1.23 1.30 1.20 1.23 1.25 1.34 1.25
Equity turnover 2.85 3.03 3.19 3.40 3.52 3.65 3.70 3.57 3.40 3.80 3.86 4.06 4.13 4.20 4.36 4.54 4.52

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Amazon.com Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Amazon.com Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Amazon.com Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Amazon.com Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

Amazon.com Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
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)
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
Property and equipment, net 204,177 196,468 193,784 190,754 186,715 177,195 173,706 168,468 160,281 147,152 133,502 121,461 113,114 99,981 86,517 77,779 72,705 67,662 64,723 61,048
Long-term Activity Ratio
Net fixed asset turnover1 2.82 2.82 2.78 2.75 2.75 2.83 2.80 2.84 2.93 3.11 3.32 3.45 3.41 3.48 3.72 3.81 3.86
Benchmarks
Net Fixed Asset Turnover, Competitors2
Home Depot Inc. 6.14 6.23 6.15 6.06 6.00 5.92 5.83 5.73 5.35 5.27 5.10 4.94 4.84 4.94 4.91 4.92 4.84
Lowe’s Cos. Inc. 5.53 5.55 5.10 5.05 5.05 5.03 4.97 4.95 4.68 4.57 4.32 4.00 3.86 3.91 3.94 3.95 3.87
TJX Cos. Inc. 8.63 8.84 9.21 9.43 9.21 8.84 8.46 7.46 6.38 6.67 6.61 7.08 7.83 7.74 7.94 7.88 7.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
Net fixed asset turnover = (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023) ÷ Property and equipment, net
= (169,961 + 143,083 + 134,383 + 127,358) ÷ 204,177 = 2.82

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Amazon.com Inc. net fixed asset turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Amazon.com Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
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)
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
 
Property and equipment, net 204,177 196,468 193,784 190,754 186,715 177,195 173,706 168,468 160,281 147,152 133,502 121,461 113,114 99,981 86,517 77,779 72,705 67,662 64,723 61,048
Operating leases 72,513 70,758 70,332 68,262 66,123 62,033 58,430 56,161 56,082 52,151 43,346 39,328 37,553 34,119 28,537 26,279 25,141 23,114 21,649 20,132
Property and equipment, net (including operating lease, right-of-use asset) 276,690 267,226 264,116 259,016 252,838 239,228 232,136 224,629 216,363 199,303 176,848 160,789 150,667 134,100 115,054 104,058 97,846 90,776 86,372 81,180
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 2.08 2.07 2.04 2.03 2.03 2.10 2.09 2.13 2.17 2.30 2.51 2.61 2.56 2.59 2.80 2.85 2.87
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Home Depot Inc. 4.83 4.95 4.95 4.90 4.85 4.79 4.70 4.63 4.31 4.29 4.14 3.96 3.89 3.95 3.90 3.93 4.84
Lowe’s Cos. Inc. 4.60 4.62 4.17 4.15 4.15 4.12 4.14 4.11 3.90 3.79 3.59 3.31 3.20 3.23 3.24 3.25 3.87
TJX Cos. Inc. 3.36 3.38 3.45 3.47 3.44 3.19 3.02 2.66 2.29 2.38 2.38 2.58 2.90 2.84 2.86 2.86 7.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
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (169,961 + 143,083 + 134,383 + 127,358) ÷ 276,690 = 2.08

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Amazon.com Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Total Asset Turnover

Amazon.com Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
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)
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
Total assets 527,854 486,883 477,607 464,378 462,675 428,362 419,728 410,767 420,549 382,406 360,319 323,077 321,195 282,179 258,314 221,238 225,248 199,099 191,351 178,102
Long-term Activity Ratio
Total asset turnover1 1.09 1.14 1.13 1.13 1.11 1.17 1.16 1.16 1.12 1.20 1.23 1.30 1.20 1.23 1.25 1.34 1.25
Benchmarks
Total Asset Turnover, Competitors2
Home Depot Inc. 2.06 2.05 2.05 1.99 2.10 2.02 2.04 1.95 1.87 1.88 1.88 1.91 2.15 2.12 2.12 2.13 2.46
Lowe’s Cos. Inc. 2.22 2.04 2.04 1.92 2.16 1.93 1.92 1.84 1.92 1.68 1.55 1.62 1.83 1.80 1.76 1.66 2.07
TJX Cos. Inc. 1.76 1.73 1.83 1.80 1.71 1.52 1.50 1.25 1.04 1.06 1.27 1.45 1.73 1.67 1.75 1.76 2.72

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
Total asset turnover = (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023) ÷ Total assets
= (169,961 + 143,083 + 134,383 + 127,358) ÷ 527,854 = 1.09

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Amazon.com Inc. total asset turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Equity Turnover

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

Microsoft Excel
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)
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
Stockholders’ equity 201,875 182,973 168,602 154,526 146,043 137,489 131,402 134,001 138,245 120,564 114,803 103,320 93,404 82,775 73,728 65,272 62,060 56,508 53,061 48,410
Long-term Activity Ratio
Equity turnover1 2.85 3.03 3.19 3.40 3.52 3.65 3.70 3.57 3.40 3.80 3.86 4.06 4.13 4.20 4.36 4.54 4.52
Benchmarks
Equity Turnover, Competitors2
Home Depot Inc. 100.77 121.18 655.02 142.70 69.80 80.86 40.05 81.84
Lowe’s Cos. Inc. 212.01 62.35 20.95 18.46 43.17 36.59 29.20 27.19 22.15 19.57
TJX Cos. Inc. 7.85 8.70 9.20 8.91 8.09 7.08 6.75 6.16 5.51 6.00 7.24 7.78 7.01 7.33 7.55 7.71 7.72

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
Equity turnover = (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023) ÷ Stockholders’ equity
= (169,961 + 143,083 + 134,383 + 127,358) ÷ 201,875 = 2.85

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Amazon.com Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.