Stock Analysis on Net

Costco Wholesale Corp. (NASDAQ:COST)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Costco Wholesale Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Feb 18, 2024 Nov 26, 2023 Sep 3, 2023 May 7, 2023 Feb 12, 2023 Nov 20, 2022 Aug 28, 2022 May 8, 2022 Feb 13, 2022 Nov 21, 2021 Aug 29, 2021 May 9, 2021 Feb 14, 2021 Nov 22, 2020 Aug 30, 2020 May 10, 2020 Feb 16, 2020 Nov 24, 2019 Sep 1, 2019 May 12, 2019 Feb 17, 2019 Nov 25, 2018 Sep 2, 2018 May 13, 2018 Feb 18, 2018 Nov 26, 2017
Net fixed asset turnover 8.84 8.87 8.91 8.91 8.94 9.02 9.04 8.84 8.57 8.34 8.18 7.89 7.77 7.60 7.48 7.31 7.21 7.12 7.15 7.15 7.15 7.12 7.03
Net fixed asset turnover (including operating lease, right-of-use asset) 8.04 8.08 8.09 8.04 8.05 8.12 8.12 7.94 7.67 7.43 7.28 7.02 6.88 6.75 6.64 6.48 6.43 6.35 7.15 7.15 7.15 7.12 7.03
Total asset turnover 3.68 3.27 3.45 3.46 3.44 3.43 3.47 3.34 3.27 3.10 3.24 3.19 3.19 2.81 2.94 3.04 3.18 2.94 3.29 3.34 3.36 3.23 3.39
Equity turnover 11.76 9.22 9.49 9.80 10.09 10.56 10.79 10.69 10.62 10.78 10.93 11.10 11.18 11.40 8.93 9.37 9.32 9.54 9.80 10.10 10.39 10.76 10.82

Based on: 10-Q (reporting date: 2024-02-18), 10-Q (reporting date: 2023-11-26), 10-K (reporting date: 2023-09-03), 10-Q (reporting date: 2023-05-07), 10-Q (reporting date: 2023-02-12), 10-Q (reporting date: 2022-11-20), 10-K (reporting date: 2022-08-28), 10-Q (reporting date: 2022-05-08), 10-Q (reporting date: 2022-02-13), 10-Q (reporting date: 2021-11-21), 10-K (reporting date: 2021-08-29), 10-Q (reporting date: 2021-05-09), 10-Q (reporting date: 2021-02-14), 10-Q (reporting date: 2020-11-22), 10-K (reporting date: 2020-08-30), 10-Q (reporting date: 2020-05-10), 10-Q (reporting date: 2020-02-16), 10-Q (reporting date: 2019-11-24), 10-K (reporting date: 2019-09-01), 10-Q (reporting date: 2019-05-12), 10-Q (reporting date: 2019-02-17), 10-Q (reporting date: 2018-11-25), 10-K (reporting date: 2018-09-02), 10-Q (reporting date: 2018-05-13), 10-Q (reporting date: 2018-02-18), 10-Q (reporting date: 2017-11-26).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Costco Wholesale Corp. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
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). Costco Wholesale Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Costco Wholesale Corp. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Costco Wholesale Corp. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.

Net Fixed Asset Turnover

Costco Wholesale Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Feb 18, 2024 Nov 26, 2023 Sep 3, 2023 May 7, 2023 Feb 12, 2023 Nov 20, 2022 Aug 28, 2022 May 8, 2022 Feb 13, 2022 Nov 21, 2021 Aug 29, 2021 May 9, 2021 Feb 14, 2021 Nov 22, 2020 Aug 30, 2020 May 10, 2020 Feb 16, 2020 Nov 24, 2019 Sep 1, 2019 May 12, 2019 Feb 17, 2019 Nov 25, 2018 Sep 2, 2018 May 13, 2018 Feb 18, 2018 Nov 26, 2017
Selected Financial Data (US$ in millions)
Net sales 57,331 56,717 77,430 52,604 54,239 53,437 70,764 51,612 50,937 49,417 61,441 44,376 43,888 42,347 52,277 36,451 38,256 36,236 46,448 33,964 34,628 34,311 43,414 31,624 32,279 31,117
Property and equipment, net 27,601 27,168 26,684 25,931 25,724 25,144 24,646 24,143 24,052 23,887 23,492 23,177 22,531 22,288 21,807 21,527 21,481 21,237 20,890 20,475 20,145 19,879 19,681 19,178 19,049 18,682
Long-term Activity Ratio
Net fixed asset turnover1 8.84 8.87 8.91 8.91 8.94 9.02 9.04 8.84 8.57 8.34 8.18 7.89 7.77 7.60 7.48 7.31 7.21 7.12 7.15 7.15 7.15 7.12 7.03
Benchmarks
Net Fixed Asset Turnover, Competitors2
Target Corp. 3.23 3.32 3.41 3.47 3.57 3.68 3.71 3.65 3.64 3.62 3.44 3.27 3.13 2.97 2.93 2.91 2.92 2.93 2.92
Walmart Inc. 5.67 5.74 5.73 5.82 5.79 5.75 5.74 5.88 5.87 5.88 5.77 5.08 5.08 4.98 4.74 4.77 4.73 4.72 4.58

Based on: 10-Q (reporting date: 2024-02-18), 10-Q (reporting date: 2023-11-26), 10-K (reporting date: 2023-09-03), 10-Q (reporting date: 2023-05-07), 10-Q (reporting date: 2023-02-12), 10-Q (reporting date: 2022-11-20), 10-K (reporting date: 2022-08-28), 10-Q (reporting date: 2022-05-08), 10-Q (reporting date: 2022-02-13), 10-Q (reporting date: 2021-11-21), 10-K (reporting date: 2021-08-29), 10-Q (reporting date: 2021-05-09), 10-Q (reporting date: 2021-02-14), 10-Q (reporting date: 2020-11-22), 10-K (reporting date: 2020-08-30), 10-Q (reporting date: 2020-05-10), 10-Q (reporting date: 2020-02-16), 10-Q (reporting date: 2019-11-24), 10-K (reporting date: 2019-09-01), 10-Q (reporting date: 2019-05-12), 10-Q (reporting date: 2019-02-17), 10-Q (reporting date: 2018-11-25), 10-K (reporting date: 2018-09-02), 10-Q (reporting date: 2018-05-13), 10-Q (reporting date: 2018-02-18), 10-Q (reporting date: 2017-11-26).

1 Q2 2024 Calculation
Net fixed asset turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Property and equipment, net
= (57,331 + 56,717 + 77,430 + 52,604) ÷ 27,601 = 8.84

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. Costco Wholesale Corp. net fixed asset turnover ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

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

Costco Wholesale Corp., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
Feb 18, 2024 Nov 26, 2023 Sep 3, 2023 May 7, 2023 Feb 12, 2023 Nov 20, 2022 Aug 28, 2022 May 8, 2022 Feb 13, 2022 Nov 21, 2021 Aug 29, 2021 May 9, 2021 Feb 14, 2021 Nov 22, 2020 Aug 30, 2020 May 10, 2020 Feb 16, 2020 Nov 24, 2019 Sep 1, 2019 May 12, 2019 Feb 17, 2019 Nov 25, 2018 Sep 2, 2018 May 13, 2018 Feb 18, 2018 Nov 26, 2017
Selected Financial Data (US$ in millions)
Net sales 57,331 56,717 77,430 52,604 54,239 53,437 70,764 51,612 50,937 49,417 61,441 44,376 43,888 42,347 52,277 36,451 38,256 36,236 46,448 33,964 34,628 34,311 43,414 31,624 32,279 31,117
 
Property and equipment, net 27,601 27,168 26,684 25,931 25,724 25,144 24,646 24,143 24,052 23,887 23,492 23,177 22,531 22,288 21,807 21,527 21,481 21,237 20,890 20,475 20,145 19,879 19,681 19,178 19,049 18,682
Operating lease right-of-use assets 2,740 2,672 2,713 2,806 2,859 2,787 2,774 2,731 2,840 2,903 2,890 2,875 2,887 2,785 2,788 2,749 2,596 2,597
Property and equipment, net (including operating lease, right-of-use asset) 30,341 29,840 29,397 28,737 28,583 27,931 27,420 26,874 26,892 26,790 26,382 26,052 25,418 25,073 24,595 24,276 24,077 23,834 20,890 20,475 20,145 19,879 19,681 19,178 19,049 18,682
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 8.04 8.08 8.09 8.04 8.05 8.12 8.12 7.94 7.67 7.43 7.28 7.02 6.88 6.75 6.64 6.48 6.43 6.35 7.15 7.15 7.15 7.12 7.03
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Target Corp. 2.97 3.07 3.15 3.20 3.29 3.38 3.40 3.35 3.33 3.32 3.17 3.02 2.89 2.74 2.70 2.69 2.70 2.72 2.71
Walmart Inc. 5.04 5.09 5.08 5.15 5.09 5.04 5.04 5.14 5.13 5.14 5.05 4.38 4.38 4.30 4.09 4.12 4.08 4.09 4.58

Based on: 10-Q (reporting date: 2024-02-18), 10-Q (reporting date: 2023-11-26), 10-K (reporting date: 2023-09-03), 10-Q (reporting date: 2023-05-07), 10-Q (reporting date: 2023-02-12), 10-Q (reporting date: 2022-11-20), 10-K (reporting date: 2022-08-28), 10-Q (reporting date: 2022-05-08), 10-Q (reporting date: 2022-02-13), 10-Q (reporting date: 2021-11-21), 10-K (reporting date: 2021-08-29), 10-Q (reporting date: 2021-05-09), 10-Q (reporting date: 2021-02-14), 10-Q (reporting date: 2020-11-22), 10-K (reporting date: 2020-08-30), 10-Q (reporting date: 2020-05-10), 10-Q (reporting date: 2020-02-16), 10-Q (reporting date: 2019-11-24), 10-K (reporting date: 2019-09-01), 10-Q (reporting date: 2019-05-12), 10-Q (reporting date: 2019-02-17), 10-Q (reporting date: 2018-11-25), 10-K (reporting date: 2018-09-02), 10-Q (reporting date: 2018-05-13), 10-Q (reporting date: 2018-02-18), 10-Q (reporting date: 2017-11-26).

1 Q2 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (57,331 + 56,717 + 77,430 + 52,604) ÷ 30,341 = 8.04

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). Costco Wholesale Corp. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Total Asset Turnover

Costco Wholesale Corp., total asset turnover calculation (quarterly data)

Microsoft Excel
Feb 18, 2024 Nov 26, 2023 Sep 3, 2023 May 7, 2023 Feb 12, 2023 Nov 20, 2022 Aug 28, 2022 May 8, 2022 Feb 13, 2022 Nov 21, 2021 Aug 29, 2021 May 9, 2021 Feb 14, 2021 Nov 22, 2020 Aug 30, 2020 May 10, 2020 Feb 16, 2020 Nov 24, 2019 Sep 1, 2019 May 12, 2019 Feb 17, 2019 Nov 25, 2018 Sep 2, 2018 May 13, 2018 Feb 18, 2018 Nov 26, 2017
Selected Financial Data (US$ in millions)
Net sales 57,331 56,717 77,430 52,604 54,239 53,437 70,764 51,612 50,937 49,417 61,441 44,376 43,888 42,347 52,277 36,451 38,256 36,236 46,448 33,964 34,628 34,311 43,414 31,624 32,279 31,117
Total assets 66,323 73,723 68,994 66,752 66,848 66,027 64,166 63,852 63,078 64,149 59,268 57,274 54,918 60,217 55,556 51,732 48,782 51,431 45,400 43,752 42,799 43,814 40,830 39,605 38,703 39,378
Long-term Activity Ratio
Total asset turnover1 3.68 3.27 3.45 3.46 3.44 3.43 3.47 3.34 3.27 3.10 3.24 3.19 3.19 2.81 2.94 3.04 3.18 2.94 3.29 3.34 3.36 3.23 3.39
Benchmarks
Total Asset Turnover, Competitors2
Target Corp. 2.00 2.07 2.02 1.93 2.03 2.08 1.94 1.87 1.93 1.92 1.80 1.73 1.74 1.77 1.80 1.75 1.83 1.85 1.80
Walmart Inc. 2.45 2.52 2.49 2.40 2.36 2.32 2.32 2.32 2.35 2.36 2.20 2.17 2.27 2.28 2.20 2.16 2.19 2.18 2.33

Based on: 10-Q (reporting date: 2024-02-18), 10-Q (reporting date: 2023-11-26), 10-K (reporting date: 2023-09-03), 10-Q (reporting date: 2023-05-07), 10-Q (reporting date: 2023-02-12), 10-Q (reporting date: 2022-11-20), 10-K (reporting date: 2022-08-28), 10-Q (reporting date: 2022-05-08), 10-Q (reporting date: 2022-02-13), 10-Q (reporting date: 2021-11-21), 10-K (reporting date: 2021-08-29), 10-Q (reporting date: 2021-05-09), 10-Q (reporting date: 2021-02-14), 10-Q (reporting date: 2020-11-22), 10-K (reporting date: 2020-08-30), 10-Q (reporting date: 2020-05-10), 10-Q (reporting date: 2020-02-16), 10-Q (reporting date: 2019-11-24), 10-K (reporting date: 2019-09-01), 10-Q (reporting date: 2019-05-12), 10-Q (reporting date: 2019-02-17), 10-Q (reporting date: 2018-11-25), 10-K (reporting date: 2018-09-02), 10-Q (reporting date: 2018-05-13), 10-Q (reporting date: 2018-02-18), 10-Q (reporting date: 2017-11-26).

1 Q2 2024 Calculation
Total asset turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Total assets
= (57,331 + 56,717 + 77,430 + 52,604) ÷ 66,323 = 3.68

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. Costco Wholesale Corp. total asset turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.

Equity Turnover

Costco Wholesale Corp., equity turnover calculation (quarterly data)

Microsoft Excel
Feb 18, 2024 Nov 26, 2023 Sep 3, 2023 May 7, 2023 Feb 12, 2023 Nov 20, 2022 Aug 28, 2022 May 8, 2022 Feb 13, 2022 Nov 21, 2021 Aug 29, 2021 May 9, 2021 Feb 14, 2021 Nov 22, 2020 Aug 30, 2020 May 10, 2020 Feb 16, 2020 Nov 24, 2019 Sep 1, 2019 May 12, 2019 Feb 17, 2019 Nov 25, 2018 Sep 2, 2018 May 13, 2018 Feb 18, 2018 Nov 26, 2017
Selected Financial Data (US$ in millions)
Net sales 57,331 56,717 77,430 52,604 54,239 53,437 70,764 51,612 50,937 49,417 61,441 44,376 43,888 42,347 52,277 36,451 38,256 36,236 46,448 33,964 34,628 34,311 43,414 31,624 32,279 31,117
Total Costco stockholders’ equity 20,760 26,147 25,058 23,568 22,794 21,471 20,642 19,968 19,418 18,463 17,564 16,482 15,652 14,860 18,284 16,802 16,614 15,861 15,243 14,486 13,858 13,167 12,799 12,143 11,754 11,078
Long-term Activity Ratio
Equity turnover1 11.76 9.22 9.49 9.80 10.09 10.56 10.79 10.69 10.62 10.78 10.93 11.10 11.18 11.40 8.93 9.37 9.32 9.54 9.80 10.10 10.39 10.76 10.82
Benchmarks
Equity Turnover, Competitors2
Target Corp. 8.88 9.28 9.58 9.73 10.04 9.80 8.16 7.39 6.66 6.48 6.40 6.57 6.65 7.08 6.52 6.65 6.41 6.77 6.59
Walmart Inc. 7.86 8.52 7.90 8.23 7.51 7.42 6.82 6.89 6.98 7.13 6.86 6.69 7.14 7.78 6.96 7.22 7.31 7.50 7.04

Based on: 10-Q (reporting date: 2024-02-18), 10-Q (reporting date: 2023-11-26), 10-K (reporting date: 2023-09-03), 10-Q (reporting date: 2023-05-07), 10-Q (reporting date: 2023-02-12), 10-Q (reporting date: 2022-11-20), 10-K (reporting date: 2022-08-28), 10-Q (reporting date: 2022-05-08), 10-Q (reporting date: 2022-02-13), 10-Q (reporting date: 2021-11-21), 10-K (reporting date: 2021-08-29), 10-Q (reporting date: 2021-05-09), 10-Q (reporting date: 2021-02-14), 10-Q (reporting date: 2020-11-22), 10-K (reporting date: 2020-08-30), 10-Q (reporting date: 2020-05-10), 10-Q (reporting date: 2020-02-16), 10-Q (reporting date: 2019-11-24), 10-K (reporting date: 2019-09-01), 10-Q (reporting date: 2019-05-12), 10-Q (reporting date: 2019-02-17), 10-Q (reporting date: 2018-11-25), 10-K (reporting date: 2018-09-02), 10-Q (reporting date: 2018-05-13), 10-Q (reporting date: 2018-02-18), 10-Q (reporting date: 2017-11-26).

1 Q2 2024 Calculation
Equity turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Total Costco stockholders’ equity
= (57,331 + 56,717 + 77,430 + 52,604) ÷ 20,760 = 11.76

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. Costco Wholesale Corp. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.