Name: Cisco Systems Inc. (NASDAQ:CSCO) | Common-Size Income Statement
Creator: Stock Analysis on Net

Common-Size Income Statement

Cisco Systems Inc., common-size consolidated income statement

12 months ended:	Jul 27, 2024	Jul 29, 2023	Jul 30, 2022	Jul 31, 2021	Jul 25, 2020	Jul 27, 2019
Product	72.96%	75.69%	73.74%	72.29%	72.98%	75.15%
Services	27.04%	24.31%	26.26%	27.71%	27.02%	24.85%
Revenue	100.00%	100.00%	100.00%	100.00%	100.00%	100.00%
Product	-26.65%	-29.11%	-28.73%	-26.70%	-26.77%	-28.64%
Services	-8.62%	-8.17%	-8.72%	-9.28%	-8.96%	-8.43%
Cost of sales	-35.27%	-37.27%	-37.45%	-35.98%	-35.74%	-37.06%
Gross margin	64.73%	62.73%	62.55%	64.02%	64.26%	62.94%
Research and development	-14.84%	-13.25%	-13.14%	-13.15%	-12.87%	-12.67%
Sales and marketing	-19.26%	-17.33%	-17.62%	-18.59%	-18.60%	-18.44%
General and administrative	-5.23%	-4.35%	-4.08%	-4.32%	-3.90%	-3.52%
Amortization of purchased intangible assets	-1.30%	-0.49%	-0.61%	-0.43%	-0.29%	-0.29%
Restructuring and other charges	-1.47%	-0.93%	-0.01%	-1.78%	-0.98%	-0.62%
Operating expenses	-42.09%	-36.36%	-35.45%	-38.26%	-36.64%	-35.54%
Operating income	22.64%	26.37%	27.09%	25.76%	27.63%	27.39%
Interest income	2.54%	1.69%	0.92%	1.24%	1.87%	2.52%
Interest expense	-1.87%	-0.75%	-0.70%	-0.87%	-1.19%	-1.65%
Other income (loss), net	-0.57%	-0.44%	0.76%	0.49%	0.03%	-0.19%
Interest and other income (loss), net	0.10%	0.50%	0.99%	0.86%	0.71%	0.68%
Income before provision for income taxes	22.74%	26.87%	28.08%	26.62%	28.34%	28.07%
Provision for income taxes	-3.56%	-4.75%	-5.17%	-5.36%	-5.59%	-5.68%
Net income	19.18%	22.13%	22.91%	21.26%	22.75%	22.39%

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).

Revenue Composition: Over the six-year period, the product segment consistently represented the majority of revenue, fluctuating between approximately 72.29% and 75.69%. The service segment complemented this, ranging from 24.31% to 27.71%. Notably, the product revenue proportion dipped in 2021 and rose again in 2023 but declined in 2024, while services showed a reverse trend, increasing in 2021 and 2024.
Cost of Sales: The cost of sales as a percentage of revenue decreased from 37.06% in 2019 to 35.27% in 2024, indicating an overall improvement in cost management or efficiency. Both product and service costs followed a similar downward trend, with product costs dropping from -28.64% to -26.65% and service costs fluctuating around the -8% range, ending at -8.62%.
Gross Margin: Gross margin remained relatively stable, hovering around 62% to 64%, with a noticeable increase to 64.73% in 2024. This stability suggests consistent profitability at the gross level, supported by improved cost control.
Operating Expenses: Operating expenses as a percentage of revenue exhibited a gradual increase overall. Research and development expenses rose from -12.67% to -14.84%, reflecting heightened investment in innovation or product development. Sales and marketing expenses decreased slightly until 2023 but increased again in 2024, reaching -19.26%, the highest within the period. General and administrative costs increased steadily from -3.52% to -5.23%, indicating growth in overhead or administrative functions.
Amortization and Restructuring Charges: The amortization of purchased intangible assets increased notably in 2024 to -1.3%, up from a low of -0.29%, suggesting recent acquisitions or intangible asset capitalization. Restructuring and other charges varied considerably, peaking at -1.78% in 2021, dropping almost to zero in 2022, then rising again to -1.47% in 2024, indicating episodic restructuring activities.
Total Operating Expenses and Operating Income: Overall operating expenses rose from -35.54% in 2019 to a peak of -42.09% in 2024, reflecting the combined growth in individual expense categories. Correspondingly, operating income declined from 27.39% to 22.64% over the same period, signaling compression of operational profitability.
Interest and Other Income/Expense: Interest income saw a decreasing trend until 2022 but recovered by 2024. Interest expense declined initially but increased nearly to 2019 levels by 2024, possibly suggesting changes in debt structure or interest rates. Other income (loss) displayed variability with no clear trend, ultimately resulting in a slight net loss impact in 2024. Overall, net interest and other income contributions decreased, diminishing from 0.68% in 2019 to 0.1% in 2024.
Income Before Taxes and Net Income: Income before provision for income taxes followed a declining trajectory from 28.07% in 2019 to 22.74% in 2024, mirroring decreases in operating income and changes in interest expense. Provision for income taxes as a percentage of revenue steadily decreased from -5.68% to -3.56%, which may point to tax efficiency improvements or changes in tax rates. Net income consequently declined from 22.39% to 19.18%, indicating reduced bottom-line profitability despite lower tax burdens.
Summary of Trends: The overall analysis reveals stable revenue distribution between products and services, improved cost of sales efficiency, and sustained gross margin percentage. However, increasing operating expenses, particularly in R&D, sales, general and administrative categories, coupled with rising amortization and restructuring charges, have exerted pressure on operating income and net profitability. Interest expense increases and volatile other income components further constrained income before taxes. The consistent reduction in tax provision partially offset profitability declines, but net income margins still narrowed over the six-year period.

Download chart