Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

$24.99

Analysis of Long-term (Investment) Activity Ratios

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).


Net Fixed Asset Turnover
The net fixed asset turnover ratio exhibits a generally upward trend from 18.61 in 2019 to a peak of 27.34 in 2023, followed by a slight decline to 25.74 in 2024. This indicates an increasing efficiency in generating sales from the company's fixed assets over the majority of the examined period, with a minor decrease in the latest year.
Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
This adjusted measure starts at the same point as the net fixed asset turnover in 2019 but then diverges, showing a decrease from 18.61 to around 14.5 by 2021. It subsequently rises to 18.65 in 2023 before dipping again to 17.05 in 2024. The fluctuations suggest volatility in the impact of operating lease assets on asset efficiency, with a generally lower turnover compared to the traditional fixed asset turnover metric.
Total Asset Turnover
The total asset turnover is relatively stable, fluctuating narrowly between 0.51 and 0.56 from 2019 to 2023. However, in 2024, it declines noticeably to 0.43. This pattern reflects consistent asset utilization efficiency in most years, with a marked decrease in the most recent period, potentially signaling less effective utilization of the overall asset base.
Equity Turnover
The equity turnover ratio declines steadily from 1.55 in 2019 to 1.18 in 2024, indicating a gradual reduction in sales generated per unit of equity. This suggests a trend of diminishing efficiency in leveraging shareholder equity to produce revenue over the analyzed timeframe.

Net Fixed Asset Turnover

Cisco Systems Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Revenue
Property and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Apple Inc.
Arista Networks Inc.
Dell Technologies Inc.
Super Micro Computer Inc.
Net Fixed Asset Turnover, Sector
Technology Hardware & Equipment
Net Fixed Asset Turnover, Industry
Information Technology

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Net fixed asset turnover = Revenue ÷ Property and equipment, net
= ÷ =

2 Click competitor name to see calculations.


The analysis of the financial data over the six-year period reveals several noteworthy trends and variations in key performance indicators.

Revenue
Revenue exhibited a fluctuating trend from 2019 through 2024. It initially declined from approximately $51.9 billion in 2019 to about $49.3 billion in 2020, followed by a modest increase in 2021. The upward trend was more pronounced in 2023, reaching nearly $57.0 billion, the highest level in the period. However, in 2024 there was a decline to roughly $53.8 billion, indicating some volatility in sales performance.
Property and Equipment, Net
The net value of property and equipment steadily decreased from $2.8 billion in 2019 to a low of around $2.0 billion by 2022. Thereafter, it stabilized, showing a slight increase and leveling off near $2.1 billion in both 2023 and 2024. This decline followed by stabilization may suggest asset depreciation and controlled investment or maintenance spending in property and equipment.
Net Fixed Asset Turnover
The net fixed asset turnover ratio demonstrated a consistently positive trend throughout the period. Beginning at 18.61 in 2019, the ratio rose steadily each year, peaking at 27.34 in 2023 before a slight decrease to 25.74 in 2024. This increasing trend implies improved efficiency in utilizing fixed assets to generate revenue, indicating enhanced operational productivity despite fluctuations in asset base and revenue.

Overall, the data suggest the company faced some variability in revenue but managed to enhance asset efficiency significantly. The reduction and stabilization of net property and equipment combined with the rising fixed asset turnover indicate effective asset management, which likely contributed to revenue generation even during periods of sales decline. Future observations could benefit from understanding factors underlying revenue fluctuations to sustain growth momentum.


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

Cisco Systems Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Revenue
 
Property and equipment, net
Operating lease right-of-use assets (recorded in Other assets)
Property and equipment, net (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Apple Inc.
Arista Networks Inc.
Dell Technologies Inc.
Super Micro Computer Inc.
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Technology Hardware & Equipment
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Information Technology

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Revenue ÷ Property and equipment, net (including operating lease, right-of-use asset)
= ÷ =

2 Click competitor name to see calculations.


Revenue Trends
The revenue experienced a decline from 51,904 million US dollars in 2019 to 49,301 million in 2020. Subsequently, revenue remained relatively stable in 2021 at 49,818 million, followed by a gradual increase to 51,557 million in 2022 and a more significant rise to 56,998 million in 2023. However, in 2024, revenue declined again to 53,803 million. Overall, the trend shows fluctuations with a notable dip in 2020 and a peak in 2023 before a slight decrease.
Property and Equipment, Net
The net value of property and equipment, including operating lease and right-of-use assets, increased from 2,789 million US dollars in 2019 to 3,374 million in 2020. The value remained relatively stable in 2021 at 3,433 million, then decreased to 3,000 million in 2022. It slightly increased again to 3,056 million in 2023 and further to 3,156 million in 2024. This indicates a general growth trend with some variability, including a notable reduction in 2022.
Net Fixed Asset Turnover Ratio
The net fixed asset turnover ratio dropped significantly from 18.61 in 2019 to 14.61 in 2020, and it remained relatively stable in 2021 at 14.51. There was a strong recovery in 2022 with the ratio improving to 17.19, reaching its highest point at 18.65 in 2023, followed by a slight decline to 17.05 in 2024. This ratio trend reflects changes in the efficiency of fixed asset utilization, with lower efficiency observed during 2020 and 2021 and improved efficiency in subsequent years.

Total Asset Turnover

Cisco Systems Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Revenue
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Apple Inc.
Arista Networks Inc.
Dell Technologies Inc.
Super Micro Computer Inc.
Total Asset Turnover, Sector
Technology Hardware & Equipment
Total Asset Turnover, Industry
Information Technology

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Total asset turnover = Revenue ÷ Total assets
= ÷ =

2 Click competitor name to see calculations.


Revenue Trends
Over the observed periods, revenue exhibited fluctuations with an initial decline from 51,904 million US dollars in 2019 to 49,301 million in 2020, followed by minor growth to 49,818 million in 2021. Revenue increased more substantially in 2022 and 2023, reaching a peak of 56,998 million, before declining to 53,803 million in 2024. This indicates variable revenue performance with a peak in 2023 but a setback in the most recent year.
Total Assets Trends
Total assets demonstrated a general upward trajectory over the six-year period. Beginning at 97,793 million in 2019, assets slightly declined through 2020 and 2022, reaching a low of 94,002 million. From 2022 onwards, total assets grew significantly, culminating at 124,413 million by 2024. The notable increase in recent years suggests substantial asset accumulation or investment activities.
Total Asset Turnover Trends
Total asset turnover ratio, which measures efficiency of asset use to generate revenue, remained relatively stable around 0.51 to 0.56 from 2019 through 2023. The ratio peaked at 0.56 in 2023, coinciding with the highest revenue level. However, a marked decline to 0.43 occurred in 2024, indicating reduced efficiency in asset utilization despite higher asset levels.
Insights and Observations
The simultaneous peak in revenue and asset turnover ratio in 2023 suggests optimal operational efficiency during that year. The decline in revenue in 2024, despite a significant increase in total assets, points to diminished asset productivity or possible changes in asset composition affecting revenue generation. The considerable asset growth paired with a sharp drop in asset turnover indicates that the company might be investing heavily in assets that have yet to contribute proportionally to income.

Equity Turnover

Cisco Systems Inc., equity turnover calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Revenue
Equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Apple Inc.
Arista Networks Inc.
Dell Technologies Inc.
Super Micro Computer Inc.
Equity Turnover, Sector
Technology Hardware & Equipment
Equity Turnover, Industry
Information Technology

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

1 2024 Calculation
Equity turnover = Revenue ÷ Equity
= ÷ =

2 Click competitor name to see calculations.


Revenue Trends
Revenue experienced a decline from 51,904 million US dollars in 2019 to 49,301 million in 2020, followed by a slight recovery to 49,818 million in 2021. The upward trend continued in 2022, with revenue increasing to 51,557 million, and further reaching a peak of 56,998 million in 2023. However, in 2024, revenue decreased to 53,803 million, suggesting some volatility after a period of growth.
Equity Evolution
Equity showed a consistent upward trajectory over the six years. Starting at 33,571 million US dollars in 2019, it increased steadily each year except for a slight decline from 41,275 million in 2021 to 39,773 million in 2022. After this dip, equity resumed growth, reaching 44,353 million in 2023 and further increasing to 45,457 million in 2024.
Equity Turnover Ratio Patterns
The equity turnover ratio started at 1.55 in 2019 and generally trended downward over the analyzed period. It fell to 1.30 in 2020, then continued to decline to 1.21 in 2021. There was a minor recovery to 1.30 in 2022, followed by a slightly lower 1.29 in 2023, and a further drop to 1.18 in 2024. This pattern indicates a reduced efficiency in generating revenue from equity over the years, despite the overall growth in equity values.
Overall Insights
The data reflects a company experiencing moderate revenue fluctuations with a notable peak in 2023. Equity has generally increased, reflecting potential reinvestment or accumulation of retained earnings. The declining equity turnover ratio suggests that while equity has increased, the relative efficiency of utilizing this equity to generate revenue has diminished. This could be indicative of changing operational dynamics or shifts in capital structure and asset utilization.