Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Cisco Systems Inc., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 1.37 1.47 1.38 1.39 1.41 1.45 1.43 1.49 1.42 1.62 1.49 1.53 1.61 1.59 1.72 1.59 1.81 1.70 1.51 1.69 1.80 2.11 2.29 2.34 2.43 2.87
Quick ratio 1.10 1.18 1.13 1.11 1.13 1.16 1.16 1.23 1.20 1.41 1.32 1.35 1.46 1.45 1.58 1.46 1.64 1.54 1.39 1.56 1.67 1.97 2.11 2.22 2.33 2.76
Cash ratio 0.83 0.87 0.84 0.81 0.81 0.79 0.75 0.83 0.81 1.00 0.93 0.97 1.12 1.11 1.16 1.10 1.23 1.14 1.05 1.24 1.37 1.61 1.72 1.90 2.08 2.44

Based on: 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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Cisco Systems Inc. current ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Cisco Systems Inc. quick ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Cisco Systems Inc. cash ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.

Current Ratio

Cisco Systems Inc., current ratio calculation (quarterly data)

Microsoft Excel
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)
Current assets 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 61,837 67,141 86,050 84,080
Current liabilities 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 27,035 28,642 35,364 29,284
Liquidity Ratio
Current ratio1 1.37 1.47 1.38 1.39 1.41 1.45 1.43 1.49 1.42 1.62 1.49 1.53 1.61 1.59 1.72 1.59 1.81 1.70 1.51 1.69 1.80 2.11 2.29 2.34 2.43 2.87
Benchmarks
Current Ratio, Competitors2
Apple Inc. 1.07 0.99 0.98 0.94 0.94 0.88 0.86 0.93 1.04 1.07 1.06 1.14 1.16 1.36 1.47 1.50 1.60 1.54 1.50 1.32 1.30 1.12 1.31 1.46 1.24
Arista Networks Inc. 4.39 4.15 4.14 3.96 4.29 4.01 3.70 3.73 4.34 5.06 5.03 5.09 4.99 5.50 5.59 5.82 5.81 5.91 5.77 5.34
Super Micro Computer Inc. 2.43 2.23 2.31 2.49 2.89 2.13 1.91 1.79 1.91 1.85 1.93 2.10 2.29 2.51 2.25 2.10 2.26 2.41 2.35 2.40 2.10 2.02

Based on: 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 Q2 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 42,127 ÷ 30,851 = 1.37

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Cisco Systems Inc. current ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.

Quick Ratio

Cisco Systems Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 13,715 9,602 10,123 8,044 9,009 7,292 7,079 6,952 6,731 7,619 9,175 7,350 11,793 10,822 11,809 10,366 8,475 8,587 11,750 10,251 9,835 8,410 8,934 6,719 17,624 11,043
Investments 11,956 13,921 16,023 15,244 13,052 12,492 12,188 13,156 14,382 15,727 15,343 16,229 18,795 19,190 17,610 18,208 18,587 19,448 21,663 24,392 30,548 34,183 37,614 47,712 56,059 60,545
Accounts receivable, net of allowance 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 5,554 4,274 3,963 4,206
Financing receivables, net 3,476 3,414 3,352 3,402 3,557 3,683 3,905 3,804 3,997 4,070 4,380 4,648 5,027 5,105 5,051 4,703 4,827 5,026 5,095 5,029 5,057 4,851 4,949 4,868 4,925 5,038
Total quick assets 34,031 31,770 35,352 31,794 30,855 28,906 29,794 29,695 31,113 32,722 34,664 32,652 39,922 39,097 39,942 37,846 36,219 37,939 43,999 43,467 49,185 51,980 57,051 63,573 82,571 80,832
 
Current liabilities 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 27,035 28,642 35,364 29,284
Liquidity Ratio
Quick ratio1 1.10 1.18 1.13 1.11 1.13 1.16 1.16 1.23 1.20 1.41 1.32 1.35 1.46 1.45 1.58 1.46 1.64 1.54 1.39 1.56 1.67 1.97 2.11 2.22 2.33 2.76
Benchmarks
Quick Ratio, Competitors2
Apple Inc. 0.92 0.84 0.81 0.76 0.77 0.71 0.70 0.76 0.88 0.91 0.89 0.97 1.02 1.22 1.31 1.30 1.44 1.38 1.35 1.13 1.14 0.99 1.10 1.24 1.11
Arista Networks Inc. 3.16 2.86 2.73 2.65 3.05 2.89 2.73 2.97 3.54 4.23 4.24 4.33 4.25 4.73 4.94 5.22 5.22 5.28 4.95 4.46
Super Micro Computer Inc. 1.12 0.87 1.16 0.95 1.17 0.72 0.75 0.62 0.62 0.66 0.72 0.75 0.95 1.06 0.87 0.81 1.00 1.01 1.06 0.88 0.76 0.75

Based on: 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 Q2 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 34,031 ÷ 30,851 = 1.10

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Cisco Systems Inc. quick ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.

Cash Ratio

Cisco Systems Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and cash equivalents 13,715 9,602 10,123 8,044 9,009 7,292 7,079 6,952 6,731 7,619 9,175 7,350 11,793 10,822 11,809 10,366 8,475 8,587 11,750 10,251 9,835 8,410 8,934 6,719 17,624 11,043
Investments 11,956 13,921 16,023 15,244 13,052 12,492 12,188 13,156 14,382 15,727 15,343 16,229 18,795 19,190 17,610 18,208 18,587 19,448 21,663 24,392 30,548 34,183 37,614 47,712 56,059 60,545
Total cash assets 25,671 23,523 26,146 23,288 22,061 19,784 19,267 20,108 21,113 23,346 24,518 23,579 30,588 30,012 29,419 28,574 27,062 28,035 33,413 34,643 40,383 42,593 46,548 54,431 73,683 71,588
 
Current liabilities 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 27,035 28,642 35,364 29,284
Liquidity Ratio
Cash ratio1 0.83 0.87 0.84 0.81 0.81 0.79 0.75 0.83 0.81 1.00 0.93 0.97 1.12 1.11 1.16 1.10 1.23 1.14 1.05 1.24 1.37 1.61 1.72 1.90 2.08 2.44
Benchmarks
Cash Ratio, Competitors2
Apple Inc. 0.55 0.42 0.50 0.47 0.37 0.31 0.37 0.40 0.43 0.50 0.57 0.66 0.58 0.86 0.98 0.98 1.05 0.95 1.05 0.85 0.80 0.57 0.80 0.98 0.67
Arista Networks Inc. 2.62 2.41 2.26 2.10 2.34 2.37 2.27 2.50 3.07 3.79 3.82 3.85 3.74 4.28 4.35 4.60 4.56 4.46 4.30 3.96
Super Micro Computer Inc. 0.36 0.34 0.32 0.33 0.33 0.18 0.18 0.17 0.21 0.25 0.24 0.23 0.47 0.51 0.30 0.38 0.46 0.41 0.41 0.30 0.16 0.14

Based on: 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 Q2 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 25,671 ÷ 30,851 = 0.83

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Cisco Systems Inc. cash ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.