Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

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

Microsoft Excel

Long-term Activity Ratios (Summary)

Cisco Systems Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Apr 27, 2024 Jan 27, 2024 Oct 28, 2023 Jul 29, 2023 Apr 29, 2023 Jan 28, 2023 Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 23, 2021 Oct 24, 2020 Jul 25, 2020 Apr 25, 2020 Jan 25, 2020 Oct 26, 2019 Jul 27, 2019 Apr 27, 2019 Jan 26, 2019 Oct 27, 2018 Jul 28, 2018 Apr 28, 2018 Jan 27, 2018 Oct 28, 2017
Net fixed asset turnover 27.68 28.55 28.96 27.34 26.82 27.07 26.52 25.82 25.21 24.09 22.69 21.31 20.64 20.13 19.93 20.10 19.95 19.67 19.48 18.61 18.11 17.34 17.00 16.41
Total asset turnover 0.45 0.57 0.59 0.56 0.56 0.55 0.56 0.55 0.56 0.55 0.53 0.51 0.52 0.50 0.51 0.52 0.55 0.57 0.56 0.53 0.53 0.50 0.48 0.45
Equity turnover 1.21 1.24 1.28 1.29 1.30 1.28 1.30 1.30 1.28 1.31 1.19 1.21 1.21 1.23 1.26 1.30 1.42 1.45 1.51 1.55 1.39 1.25 1.15 1.14

Based on: 10-Q (reporting date: 2024-04-27), 10-Q (reporting date: 2024-01-27), 10-Q (reporting date: 2023-10-28), 10-K (reporting date: 2023-07-29), 10-Q (reporting date: 2023-04-29), 10-Q (reporting date: 2023-01-28), 10-Q (reporting date: 2022-10-29), 10-K (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-Q (reporting date: 2021-01-23), 10-Q (reporting date: 2020-10-24), 10-K (reporting date: 2020-07-25), 10-Q (reporting date: 2020-04-25), 10-Q (reporting date: 2020-01-25), 10-Q (reporting date: 2019-10-26), 10-K (reporting date: 2019-07-27), 10-Q (reporting date: 2019-04-27), 10-Q (reporting date: 2019-01-26), 10-Q (reporting date: 2018-10-27), 10-K (reporting date: 2018-07-28), 10-Q (reporting date: 2018-04-28), 10-Q (reporting date: 2018-01-27), 10-Q (reporting date: 2017-10-28).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Cisco Systems Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Cisco Systems Inc. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Cisco Systems Inc. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Net Fixed Asset Turnover

Cisco Systems Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Apr 27, 2024 Jan 27, 2024 Oct 28, 2023 Jul 29, 2023 Apr 29, 2023 Jan 28, 2023 Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 23, 2021 Oct 24, 2020 Jul 25, 2020 Apr 25, 2020 Jan 25, 2020 Oct 26, 2019 Jul 27, 2019 Apr 27, 2019 Jan 26, 2019 Oct 27, 2018 Jul 28, 2018 Apr 28, 2018 Jan 27, 2018 Oct 28, 2017
Selected Financial Data (US$ in millions)
Revenue 12,702 12,791 14,668 15,203 14,571 13,592 13,632 13,102 12,835 12,720 12,900 13,126 12,803 11,960 11,929 12,154 11,983 12,005 13,159 13,428 12,958 12,446 13,072 12,844 12,463 11,887 12,136
Property and equipment, net 2,000 2,005 2,004 2,085 2,047 1,964 1,972 1,997 2,046 2,140 2,238 2,338 2,367 2,386 2,412 2,453 2,535 2,621 2,669 2,789 2,834 2,931 2,956 3,006 3,082 3,113 3,202
Long-term Activity Ratio
Net fixed asset turnover1 27.68 28.55 28.96 27.34 26.82 27.07 26.52 25.82 25.21 24.09 22.69 21.31 20.64 20.13 19.93 20.10 19.95 19.67 19.48 18.61 18.11 17.34 17.00 16.41
Benchmarks
Net Fixed Asset Turnover, Competitors2
Apple Inc. 8.76 8.83 8.77 8.82 8.87 9.02 9.36 9.61 9.82 9.64 9.28 8.99 8.61 7.75 7.47 7.67 7.47 7.23 6.96 6.88 6.67 6.61 6.43
Arista Networks Inc. 62.08 57.69 54.54 51.74 49.98 46.11 40.75 38.14 36.13 37.49 36.78 81.23 75.84 71.90 68.00 64.39 61.85 61.38
Super Micro Computer Inc. 30.65 31.14 25.34 24.54 22.67 22.98 20.69 18.17 16.40 14.88 13.47 12.95 12.74 12.77 13.65 14.28 14.31 14.82 15.67 16.88

Based on: 10-Q (reporting date: 2024-04-27), 10-Q (reporting date: 2024-01-27), 10-Q (reporting date: 2023-10-28), 10-K (reporting date: 2023-07-29), 10-Q (reporting date: 2023-04-29), 10-Q (reporting date: 2023-01-28), 10-Q (reporting date: 2022-10-29), 10-K (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-Q (reporting date: 2021-01-23), 10-Q (reporting date: 2020-10-24), 10-K (reporting date: 2020-07-25), 10-Q (reporting date: 2020-04-25), 10-Q (reporting date: 2020-01-25), 10-Q (reporting date: 2019-10-26), 10-K (reporting date: 2019-07-27), 10-Q (reporting date: 2019-04-27), 10-Q (reporting date: 2019-01-26), 10-Q (reporting date: 2018-10-27), 10-K (reporting date: 2018-07-28), 10-Q (reporting date: 2018-04-28), 10-Q (reporting date: 2018-01-27), 10-Q (reporting date: 2017-10-28).

1 Q3 2024 Calculation
Net fixed asset turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Property and equipment, net
= (12,702 + 12,791 + 14,668 + 15,203) ÷ 2,000 = 27.68

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. Cisco Systems Inc. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Total Asset Turnover

Cisco Systems Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Apr 27, 2024 Jan 27, 2024 Oct 28, 2023 Jul 29, 2023 Apr 29, 2023 Jan 28, 2023 Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 23, 2021 Oct 24, 2020 Jul 25, 2020 Apr 25, 2020 Jan 25, 2020 Oct 26, 2019 Jul 27, 2019 Apr 27, 2019 Jan 26, 2019 Oct 27, 2018 Jul 28, 2018 Apr 28, 2018 Jan 27, 2018 Oct 28, 2017
Selected Financial Data (US$ in millions)
Revenue 12,702 12,791 14,668 15,203 14,571 13,592 13,632 13,102 12,835 12,720 12,900 13,126 12,803 11,960 11,929 12,154 11,983 12,005 13,159 13,428 12,958 12,446 13,072 12,844 12,463 11,887 12,136
Total assets 122,998 101,174 98,782 101,852 97,529 95,840 93,054 94,002 92,797 94,262 95,981 97,497 93,896 95,601 95,003 94,853 91,394 90,426 92,492 97,793 97,287 102,462 105,429 108,784 114,008 131,510 130,522
Long-term Activity Ratio
Total asset turnover1 0.45 0.57 0.59 0.56 0.56 0.55 0.56 0.55 0.56 0.55 0.53 0.51 0.52 0.50 0.51 0.52 0.55 0.57 0.56 0.53 0.53 0.50 0.48 0.45
Benchmarks
Total Asset Turnover, Competitors2
Apple Inc. 1.13 1.09 1.09 1.15 1.16 1.12 1.12 1.15 1.10 0.99 1.04 1.05 0.97 0.83 0.85 0.86 0.84 0.79 0.77 0.80 0.76 0.70 0.73
Arista Networks Inc. 0.58 0.59 0.62 0.64 0.64 0.65 0.64 0.60 0.52 0.51 0.51 0.50 0.50 0.49 0.50 0.52 0.57 0.58
Super Micro Computer Inc. 1.33 1.71 1.80 1.94 2.06 2.16 1.82 1.62 1.51 1.56 1.58 1.59 1.69 1.72 1.82 1.74 1.68 1.81 1.96 2.08

Based on: 10-Q (reporting date: 2024-04-27), 10-Q (reporting date: 2024-01-27), 10-Q (reporting date: 2023-10-28), 10-K (reporting date: 2023-07-29), 10-Q (reporting date: 2023-04-29), 10-Q (reporting date: 2023-01-28), 10-Q (reporting date: 2022-10-29), 10-K (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-Q (reporting date: 2021-01-23), 10-Q (reporting date: 2020-10-24), 10-K (reporting date: 2020-07-25), 10-Q (reporting date: 2020-04-25), 10-Q (reporting date: 2020-01-25), 10-Q (reporting date: 2019-10-26), 10-K (reporting date: 2019-07-27), 10-Q (reporting date: 2019-04-27), 10-Q (reporting date: 2019-01-26), 10-Q (reporting date: 2018-10-27), 10-K (reporting date: 2018-07-28), 10-Q (reporting date: 2018-04-28), 10-Q (reporting date: 2018-01-27), 10-Q (reporting date: 2017-10-28).

1 Q3 2024 Calculation
Total asset turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Total assets
= (12,702 + 12,791 + 14,668 + 15,203) ÷ 122,998 = 0.45

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. Cisco Systems Inc. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Equity Turnover

Cisco Systems Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Apr 27, 2024 Jan 27, 2024 Oct 28, 2023 Jul 29, 2023 Apr 29, 2023 Jan 28, 2023 Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 23, 2021 Oct 24, 2020 Jul 25, 2020 Apr 25, 2020 Jan 25, 2020 Oct 26, 2019 Jul 27, 2019 Apr 27, 2019 Jan 26, 2019 Oct 27, 2018 Jul 28, 2018 Apr 28, 2018 Jan 27, 2018 Oct 28, 2017
Selected Financial Data (US$ in millions)
Revenue 12,702 12,791 14,668 15,203 14,571 13,592 13,632 13,102 12,835 12,720 12,900 13,126 12,803 11,960 11,929 12,154 11,983 12,005 13,159 13,428 12,958 12,446 13,072 12,844 12,463 11,887 12,136
Total equity 45,768 46,251 45,210 44,353 42,295 41,474 40,272 39,773 40,400 39,496 42,701 41,275 40,205 39,121 38,157 37,920 35,708 35,533 34,423 33,571 36,804 40,789 43,848 43,204 46,661 51,982 65,550
Long-term Activity Ratio
Equity turnover1 1.21 1.24 1.28 1.29 1.30 1.28 1.30 1.30 1.28 1.31 1.19 1.21 1.21 1.23 1.26 1.30 1.42 1.45 1.51 1.55 1.39 1.25 1.15 1.14
Benchmarks
Equity Turnover, Competitors2
Apple Inc. 5.14 5.21 6.17 6.37 6.20 6.83 7.78 6.67 5.73 5.26 5.80 5.40 4.70 4.44 4.20 3.79 3.42 2.99 2.88 2.69 2.44 2.22 2.48
Arista Networks Inc. 0.77 0.81 0.86 0.90 0.91 0.90 0.90 0.87 0.76 0.74 0.72 0.71 0.71 0.70 0.72 0.75 0.82 0.83
Super Micro Computer Inc. 2.32 3.01 3.41 3.61 3.72 3.65 3.70 3.64 3.63 3.51 3.38 3.25 3.21 3.06 3.08 3.13 3.18 3.26 3.43 3.72

Based on: 10-Q (reporting date: 2024-04-27), 10-Q (reporting date: 2024-01-27), 10-Q (reporting date: 2023-10-28), 10-K (reporting date: 2023-07-29), 10-Q (reporting date: 2023-04-29), 10-Q (reporting date: 2023-01-28), 10-Q (reporting date: 2022-10-29), 10-K (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-K (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-Q (reporting date: 2021-01-23), 10-Q (reporting date: 2020-10-24), 10-K (reporting date: 2020-07-25), 10-Q (reporting date: 2020-04-25), 10-Q (reporting date: 2020-01-25), 10-Q (reporting date: 2019-10-26), 10-K (reporting date: 2019-07-27), 10-Q (reporting date: 2019-04-27), 10-Q (reporting date: 2019-01-26), 10-Q (reporting date: 2018-10-27), 10-K (reporting date: 2018-07-28), 10-Q (reporting date: 2018-04-28), 10-Q (reporting date: 2018-01-27), 10-Q (reporting date: 2017-10-28).

1 Q3 2024 Calculation
Equity turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Total equity
= (12,702 + 12,791 + 14,668 + 15,203) ÷ 45,768 = 1.21

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. Cisco Systems Inc. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.