Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Cisco Systems Inc., long-term (investment) activity ratios (quarterly data)
Based on: 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 improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Cisco Systems Inc. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Cisco Systems Inc. equity turnover ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
Net Fixed Asset Turnover
Cisco Systems Inc., net fixed asset turnover calculation (quarterly data)
| 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 | 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,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 | 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.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. | — | — | 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 | 61.06 | 57.60 | 54.76 | 28.55 | — | — | — | ||||||||
| Enphase Energy Inc. | — | — | 15.68 | 18.44 | 19.63 | 20.93 | 21.99 | 20.00 | 17.89 | 16.82 | 16.80 | 16.79 | 16.23 | 18.02 | 20.45 | 21.87 | 23.93 | 21.58 | 21.53 | 18.79 | 17.16 | 15.06 | — | — | — | ||||||||
| Super Micro Computer Inc. | 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: 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 Q1 2024 Calculation
Net fixed asset turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Property and equipment, net
= (14,668 + 15,203 + 14,571 + 13,592)
÷ 2,004 = 28.96
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 improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |
Total Asset Turnover
Cisco Systems Inc., total asset turnover calculation (quarterly data)
| 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 | 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 | 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.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.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.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 | 0.68 | 0.69 | 0.68 | 0.70 | — | — | — | ||||||||
| Enphase Energy Inc. | — | — | 0.76 | 0.81 | 0.77 | 0.76 | 0.75 | 0.71 | 0.67 | 0.66 | 0.55 | 0.51 | 0.40 | 0.65 | 0.66 | 0.72 | 0.71 | 0.88 | 0.97 | 0.84 | 1.08 | 0.93 | — | — | — | ||||||||
| Super Micro Computer Inc. | 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: 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 Q1 2024 Calculation
Total asset turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Total assets
= (14,668 + 15,203 + 14,571 + 13,592)
÷ 98,782 = 0.59
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 Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 exceeding Q3 2023 level. |
Equity Turnover
Cisco Systems Inc., equity turnover calculation (quarterly data)
| 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 | 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,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.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. | — | 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.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 | 0.92 | 0.94 | 0.95 | 1.00 | — | — | — | ||||||||
| Enphase Energy Inc. | — | — | 2.67 | 2.88 | 2.70 | 2.82 | 3.31 | 3.85 | 4.60 | 3.21 | 1.91 | 1.82 | 1.19 | 1.60 | 1.73 | 1.95 | 2.31 | 2.29 | 3.33 | 3.45 | 24.52 | 40.66 | — | — | — | ||||||||
| Super Micro Computer Inc. | 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: 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 Q1 2024 Calculation
Equity turnover
= (RevenueQ1 2024
+ RevenueQ4 2023
+ RevenueQ3 2023
+ RevenueQ2 2023)
÷ Total equity
= (14,668 + 15,203 + 14,571 + 13,592)
÷ 45,210 = 1.28
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 Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024. |