Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

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

Microsoft Excel

Short-term Activity Ratios (Summary)

Cisco Systems Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Turnover Ratios
Inventory turnover 5.91 5.63 6.28 6.38 6.30 5.83 6.01 6.45 7.41 7.52 8.52 9.19 10.06 11.50 11.15 11.98 13.25 13.74 14.85 13.73 14.14 13.91
Receivables turnover 11.89 8.05 10.80 11.72 12.01 9.74 10.76 10.15 9.61 7.79 8.92 8.59 9.57 8.64 11.04 11.15 12.08 9.01 11.07 11.91 10.66 9.45
Payables turnover 9.31 8.24 9.53 11.08 10.11 9.19 8.55 8.69 8.53 8.47 8.31 9.00 8.15 7.59 7.22 9.22 7.53 7.94 7.52 9.60 9.43 9.34
Working capital turnover 5.08 4.60 4.73 4.89 4.72 4.65 4.65 4.36 4.74 3.54 3.88 3.82 2.89 3.00 2.70 3.29 2.87 3.04 3.24
Average No. Days
Average inventory processing period 62 65 58 57 58 63 61 57 49 49 43 40 36 32 33 30 28 27 25 27 26 26
Add: Average receivable collection period 31 45 34 31 30 37 34 36 38 47 41 43 38 42 33 33 30 41 33 31 34 39
Operating cycle 93 110 92 88 88 100 95 93 87 96 84 83 74 74 66 63 58 68 58 58 60 65
Less: Average payables payment period 39 44 38 33 36 40 43 42 43 43 44 41 45 48 51 40 48 46 49 38 39 39
Cash conversion cycle 54 66 54 55 52 60 52 51 44 53 40 42 29 26 15 23 10 22 9 20 21 26

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Cisco Systems Inc. inventory turnover ratio deteriorated from Q3 2024 to Q4 2024 but then slightly improved from Q4 2024 to Q1 2025.
Receivables turnover An activity ratio equal to revenue divided by receivables. Cisco Systems Inc. receivables turnover ratio deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 exceeding Q3 2024 level.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Cisco Systems Inc. payables turnover ratio decreased from Q3 2024 to Q4 2024 but then increased from Q4 2024 to Q1 2025 not reaching Q3 2024 level.

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. Cisco Systems Inc. number of days of inventory outstanding deteriorated from Q3 2024 to Q4 2024 but then slightly improved from Q4 2024 to Q1 2025.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Cisco Systems Inc. number of days of receivables outstanding deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 exceeding Q3 2024 level.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Cisco Systems Inc. operating cycle deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 not reaching Q3 2024 level.
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. Cisco Systems Inc. number of days of payables outstanding increased from Q3 2024 to Q4 2024 but then slightly decreased from Q4 2024 to Q1 2025 not reaching Q3 2024 level.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period.

Inventory Turnover

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

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data (US$ in millions)
Cost of sales 4,720 4,861 4,429 4,574 5,111 5,455 5,339 5,165 5,286 5,077 4,714 4,671 4,847 4,782 4,618 4,176 4,348 4,470 4,212 4,241 4,695 4,854 4,785 4,673 4,926
Inventories 3,143 3,373 3,118 3,209 3,342 3,644 3,474 3,140 2,664 2,568 2,231 2,059 1,832 1,559 1,579 1,436 1,303 1,282 1,212 1,353 1,344 1,383 1,513 1,701 1,572
Short-term Activity Ratio
Inventory turnover1 5.91 5.63 6.28 6.38 6.30 5.83 6.01 6.45 7.41 7.52 8.52 9.19 10.06 11.50 11.15 11.98 13.25 13.74 14.85 13.73 14.14 13.91
Benchmarks
Inventory Turnover, Competitors2
Apple Inc. 28.87 33.80 33.32 32.57 33.82 29.54 29.24 32.36 45.20 40.43 40.07 36.69 32.37 39.55 37.48 36.21 41.75 42.55 49.75 40.54 39.40
Arista Networks Inc. 1.33 1.23 1.11 1.15 1.16 1.12 1.15 1.32 1.36 1.53 1.65 1.64 1.74 1.75 1.85 1.74 1.82 2.49 3.19 3.55
Super Micro Computer Inc. 2.41 3.14 2.97 4.04 3.49 3.84 2.88 2.84 2.50 2.58 2.77 2.90 3.18 3.39 3.59 3.30 3.19 3.91 4.12 4.48

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Inventory turnover = (Cost of salesQ1 2025 + Cost of salesQ4 2024 + Cost of salesQ3 2024 + Cost of salesQ2 2024) ÷ Inventories
= (4,720 + 4,861 + 4,429 + 4,574) ÷ 3,143 = 5.91

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. Cisco Systems Inc. inventory turnover ratio deteriorated from Q3 2024 to Q4 2024 but then slightly improved from Q4 2024 to Q1 2025.

Receivables Turnover

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

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data (US$ in millions)
Revenue 13,841 13,642 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
Accounts receivable, net of allowance 4,457 6,685 5,127 4,884 4,833 5,854 5,104 5,237 5,439 6,622 5,783 6,003 5,306 5,766 4,425 4,307 3,980 5,472 4,569 4,330 4,878 5,491 3,795 3,745 4,536
Short-term Activity Ratio
Receivables turnover1 11.89 8.05 10.80 11.72 12.01 9.74 10.76 10.15 9.61 7.79 8.92 8.59 9.57 8.64 11.04 11.15 12.08 9.01 11.07 11.91 10.66 9.45
Benchmarks
Receivables Turnover, Competitors2
Apple Inc. 11.70 16.92 17.48 16.63 12.99 19.64 21.47 16.32 13.99 17.77 18.55 12.52 13.92 19.87 17.59 10.85 17.03 15.31 17.04 12.77 11.35
Arista Networks Inc. 5.85 5.14 5.58 5.72 6.71 6.75 5.63 4.75 6.03 5.98 4.87 5.71 7.01 7.22 6.47 5.95 7.40 5.92 6.64 6.15
Super Micro Computer Inc. 7.16 6.16 8.74 6.20 9.78 8.65 8.17 6.23 6.81 8.38 8.36 7.67 8.31 10.10 10.23 8.27 9.90 9.07 9.35 8.89

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Receivables turnover = (RevenueQ1 2025 + RevenueQ4 2024 + RevenueQ3 2024 + RevenueQ2 2024) ÷ Accounts receivable, net of allowance
= (13,841 + 13,642 + 12,702 + 12,791) ÷ 4,457 = 11.89

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Cisco Systems Inc. receivables turnover ratio deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 exceeding Q3 2024 level.

Payables Turnover

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

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data (US$ in millions)
Cost of sales 4,720 4,861 4,429 4,574 5,111 5,455 5,339 5,165 5,286 5,077 4,714 4,671 4,847 4,782 4,618 4,176 4,348 4,470 4,212 4,241 4,695 4,854 4,785 4,673 4,926
Accounts payable 1,996 2,304 2,054 1,848 2,084 2,313 2,442 2,329 2,316 2,281 2,289 2,101 2,261 2,362 2,440 1,867 2,294 2,218 2,393 1,935 2,016 2,059 2,022 1,655 1,805
Short-term Activity Ratio
Payables turnover1 9.31 8.24 9.53 11.08 10.11 9.19 8.55 8.69 8.53 8.47 8.31 9.00 8.15 7.59 7.22 9.22 7.53 7.94 7.52 9.60 9.43 9.34
Benchmarks
Payables Turnover, Competitors2
Apple Inc. 3.05 4.38 4.54 3.65 3.42 4.65 5.10 3.81 3.49 4.54 4.15 2.90 3.89 5.07 4.88 2.82 4.01 4.79 5.12 3.68 3.50
Arista Networks Inc. 8.14 7.63 10.09 5.13 8.16 5.95 5.84 7.33 5.39 4.74 5.61 5.27 7.39 6.54 6.52 6.23 4.89 6.63 9.86 9.41
Super Micro Computer Inc. 9.09 6.13 5.63 7.52 8.38 9.76 6.38 6.71 5.09 5.18 5.82 4.94 6.18 6.91 8.33 6.74 5.97 7.02 8.51 8.34

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Payables turnover = (Cost of salesQ1 2025 + Cost of salesQ4 2024 + Cost of salesQ3 2024 + Cost of salesQ2 2024) ÷ Accounts payable
= (4,720 + 4,861 + 4,429 + 4,574) ÷ 1,996 = 9.31

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. Cisco Systems Inc. payables turnover ratio decreased from Q3 2024 to Q4 2024 but then increased from Q4 2024 to Q1 2025 not reaching Q3 2024 level.

Working Capital Turnover

Cisco Systems Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data (US$ in millions)
Current assets 35,752 36,862 35,886 42,127 39,659 43,348 39,950 38,515 36,141 36,717 35,981 36,799 37,588 39,112 37,060 43,911 42,989 43,573 41,307 40,053 41,716 47,755 47,311 53,117 55,686
Less: Current liabilities 40,542 40,584 40,108 30,851 27,035 31,309 28,719 27,252 24,896 25,640 24,150 25,915 23,238 26,257 24,262 27,268 26,991 25,331 25,937 22,088 24,597 31,712 27,913 29,479 26,414
Working capital (4,790) (3,722) (4,222) 11,276 12,624 12,039 11,231 11,263 11,245 11,077 11,831 10,884 14,350 12,855 12,798 16,643 15,998 18,242 15,370 17,965 17,119 16,043 19,398 23,638 29,272
 
Revenue 13,841 13,642 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
Short-term Activity Ratio
Working capital turnover1 5.08 4.60 4.73 4.89 4.72 4.65 4.65 4.36 4.74 3.54 3.88 3.82 2.89 3.00 2.70 3.29 2.87 3.04 3.24
Benchmarks
Working Capital Turnover, Competitors2
Apple Inc. 83.07 39.69 67.80 39.10 52.06 21.58 13.62 7.16 6.12 5.62 4.38 4.56
Arista Networks Inc. 0.78 0.82 0.85 0.90 0.96 1.01 1.04 1.03 1.04 1.01 0.85 0.80 0.76 0.76 0.77 0.76 0.74 0.77 0.85 0.84
Super Micro Computer Inc. 1.86 3.25 3.76 3.95 4.05 3.84 3.94 3.89 3.91 3.81 4.09 3.96 3.95 3.74 3.71 3.77 3.82 3.85 4.00 4.29

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Working capital turnover = (RevenueQ1 2025 + RevenueQ4 2024 + RevenueQ3 2024 + RevenueQ2 2024) ÷ Working capital
= (13,841 + 13,642 + 12,702 + 12,791) ÷ -4,790 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

Cisco Systems Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data
Inventory turnover 5.91 5.63 6.28 6.38 6.30 5.83 6.01 6.45 7.41 7.52 8.52 9.19 10.06 11.50 11.15 11.98 13.25 13.74 14.85 13.73 14.14 13.91
Short-term Activity Ratio (no. days)
Average inventory processing period1 62 65 58 57 58 63 61 57 49 49 43 40 36 32 33 30 28 27 25 27 26 26
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Apple Inc. 13 11 11 11 11 12 12 11 8 9 9 10 11 9 10 10 9 9 7 9 9
Arista Networks Inc. 274 298 328 318 315 325 318 276 268 239 221 222 210 209 197 210 200 147 114 103
Super Micro Computer Inc. 152 116 123 90 105 95 127 128 146 141 132 126 115 108 102 110 114 93 89 81

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 5.91 = 62

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. Cisco Systems Inc. number of days of inventory outstanding deteriorated from Q3 2024 to Q4 2024 but then slightly improved from Q4 2024 to Q1 2025.

Average Receivable Collection Period

Cisco Systems Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data
Receivables turnover 11.89 8.05 10.80 11.72 12.01 9.74 10.76 10.15 9.61 7.79 8.92 8.59 9.57 8.64 11.04 11.15 12.08 9.01 11.07 11.91 10.66 9.45
Short-term Activity Ratio (no. days)
Average receivable collection period1 31 45 34 31 30 37 34 36 38 47 41 43 38 42 33 33 30 41 33 31 34 39
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Apple Inc. 31 22 21 22 28 19 17 22 26 21 20 29 26 18 21 34 21 24 21 29 32
Arista Networks Inc. 62 71 65 64 54 54 65 77 61 61 75 64 52 51 56 61 49 62 55 59
Super Micro Computer Inc. 51 59 42 59 37 42 45 59 54 44 44 48 44 36 36 44 37 40 39 41

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 11.89 = 31

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Cisco Systems Inc. number of days of receivables outstanding deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 exceeding Q3 2024 level.

Operating Cycle

Cisco Systems Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data
Average inventory processing period 62 65 58 57 58 63 61 57 49 49 43 40 36 32 33 30 28 27 25 27 26 26
Average receivable collection period 31 45 34 31 30 37 34 36 38 47 41 43 38 42 33 33 30 41 33 31 34 39
Short-term Activity Ratio
Operating cycle1 93 110 92 88 88 100 95 93 87 96 84 83 74 74 66 63 58 68 58 58 60 65
Benchmarks
Operating Cycle, Competitors2
Apple Inc. 44 33 32 33 39 31 29 33 34 30 29 39 37 27 31 44 30 33 28 38 41
Arista Networks Inc. 336 369 393 382 369 379 383 353 329 300 296 286 262 260 253 271 249 209 169 162
Super Micro Computer Inc. 203 175 165 149 142 137 172 187 200 185 176 174 159 144 138 154 151 133 128 122

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 62 + 31 = 93

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Cisco Systems Inc. operating cycle deteriorated from Q3 2024 to Q4 2024 but then improved from Q4 2024 to Q1 2025 not reaching Q3 2024 level.

Average Payables Payment Period

Cisco Systems Inc., average payables payment period calculation (quarterly data)

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data
Payables turnover 9.31 8.24 9.53 11.08 10.11 9.19 8.55 8.69 8.53 8.47 8.31 9.00 8.15 7.59 7.22 9.22 7.53 7.94 7.52 9.60 9.43 9.34
Short-term Activity Ratio (no. days)
Average payables payment period1 39 44 38 33 36 40 43 42 43 43 44 41 45 48 51 40 48 46 49 38 39 39
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Apple Inc. 120 83 80 100 107 79 72 96 105 80 88 126 94 72 75 129 91 76 71 99 104
Arista Networks Inc. 45 48 36 71 45 61 62 50 68 77 65 69 49 56 56 59 75 55 37 39
Super Micro Computer Inc. 40 60 65 49 44 37 57 54 72 70 63 74 59 53 44 54 61 52 43 44

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 9.31 = 39

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. Cisco Systems Inc. number of days of payables outstanding increased from Q3 2024 to Q4 2024 but then slightly decreased from Q4 2024 to Q1 2025 not reaching Q3 2024 level.

Cash Conversion Cycle

Cisco Systems Inc., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
Oct 26, 2024 Jul 27, 2024 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
Selected Financial Data
Average inventory processing period 62 65 58 57 58 63 61 57 49 49 43 40 36 32 33 30 28 27 25 27 26 26
Average receivable collection period 31 45 34 31 30 37 34 36 38 47 41 43 38 42 33 33 30 41 33 31 34 39
Average payables payment period 39 44 38 33 36 40 43 42 43 43 44 41 45 48 51 40 48 46 49 38 39 39
Short-term Activity Ratio
Cash conversion cycle1 54 66 54 55 52 60 52 51 44 53 40 42 29 26 15 23 10 22 9 20 21 26
Benchmarks
Cash Conversion Cycle, Competitors2
Apple Inc. -76 -50 -48 -67 -68 -48 -43 -63 -71 -50 -59 -87 -57 -45 -44 -85 -61 -43 -43 -61 -63
Arista Networks Inc. 291 321 357 311 324 318 321 303 261 223 231 217 213 204 197 212 174 154 132 123
Super Micro Computer Inc. 163 115 100 100 98 100 115 133 128 115 113 100 100 91 94 100 90 81 85 78

Based on: 10-Q (reporting date: 2024-10-26), 10-K (reporting date: 2024-07-27), 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).

1 Q1 2025 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 62 + 3139 = 54

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period.