Cisco Financial Model
Hardware Company Financials Example (Free Excel Download)
Cisco Systems, Inc. is a global leader in networking, cybersecurity, collaboration, and observability solutions that power enterprise IT infrastructure.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates Cisco's equity valuation and cash flow generation capacity, focusing specifically on the financial impact of its transition from legacy hardware sales to recurring software subscriptions following the transformational $28 billion acquisition of Splunk.
Cisco Systems, Inc. is a global leader in networking, cybersecurity, collaboration, and observability solutions that power enterprise IT infrastructure. The company designs and sells a broad range of technologies, increasingly embedding artificial intelligence into its product portfolios to help customers manage and secure their digital operations.
Business segments include:
- Networking (approx. 45-50% of revenue)
- Services (approx. 25% of revenue)
- Security (approx. 10-15% of revenue, growing rapidly)
- Collaboration (approx. 7% of revenue)
- Observability (approx. 3-5% of revenue)
Key geographies are the Americas (59%), EMEA (26%), and APJC (14%). Cisco operates a hybrid business model, transitioning from an asset-light hardware vendor (relying on outsourced manufacturing) to a software and subscription-based platform, with subscriptions now accounting for over 54% of total revenue. The company holds a dominant market share in enterprise networking but faces intense competition in cybersecurity and cloud infrastructure. The most significant recent event is the $28 billion acquisition of Splunk, which closed in March 2024, fundamentally altering Cisco's growth trajectory in the Security and Observability segments and adding massive intangible assets to the balance sheet.
The downloadable Cisco financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsCisco financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
|---|---|---|---|---|---|
| Revenue | $51.56B | $57.00B | $53.80B | $56.65B | $63.33B |
| Gross profit | $32.25B | $35.75B | $34.83B | $36.79B | $40.86B |
| Operating income | $13.97B | $15.03B | $12.18B | $11.76B | $15.37B |
| Net income | $11.81B | $12.61B | $10.32B | $10.18B | $13.27B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Cisco
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Networking
- Segment name: Networking
- Revenue driver formula: Enterprise IT Capex Spend x Cisco Market Share
- Historical growth rate: -10% to +8% (highly cyclical based on enterprise hardware refresh cycles and inventory digestion)
- Key growth levers and headwinds: Driven by AI infrastructure orders from webscale customers (exceeding $2 billion in FY25) and industrial IoT, offset by enterprise hardware inventory digestion.
- Pricing dynamics: Highly competitive, subject to discounting for large enterprise volume purchases.
- Revenue recognition notes: Primarily recognised upfront upon delivery of hardware.
- Seasonality: Fiscal Q4 (ending July) is typically the strongest quarter due to enterprise budget exhaustion and year-end sales pushes.
Security
- Segment name: Security
- Revenue driver formula: Active Licences x Average Revenue Per User (ARPU)
- Historical growth rate: 50% to 100%+ (heavily distorted by the Splunk acquisition; organic growth is mid-single digits)
- Key growth levers and headwinds: Integration of Splunk, cross-selling to the existing networking installed base, and adoption of new AI-driven products like Hypershield.
- Pricing dynamics: Subscription-based, highly sticky, contractual pricing.
- Revenue recognition notes: Recognised rateably over the contract term, creating significant deferred revenue.
Collaboration
- Segment name: Collaboration
- Revenue driver formula: Paid Seats x Subscription Price
- Historical growth rate: Flat to low single digits (-3% to +2%)
- Key growth levers and headwinds: Device sales and Webex subscriptions, facing intense competition from Microsoft Teams and Zoom.
- Pricing dynamics: Subscription and hardware bundling.
- Revenue recognition notes: Mix of upfront (devices) and over time (software).
Observability
- Segment name: Observability
- Revenue driver formula: Enterprise Deployments x Contract Value
- Historical growth rate: 25% to 40%+ (boosted by Splunk and ThousandEyes)
- Key growth levers and headwinds: Enterprise shift to multi-cloud environments requiring complex monitoring.
- Pricing dynamics: Subscription-based.
- Revenue recognition notes: Recognised rateably over time.
Services
- Segment name: Services
- Revenue driver formula: Installed Hardware Base x Service Attach Rate
- Historical growth rate: 2% to 6%
- Key growth levers and headwinds: Highly predictable, driven by the sheer size of Cisco's active equipment globally.
- Pricing dynamics: Contractual maintenance and support agreements.
- Revenue recognition notes: Recognised rateably over the service period.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Hardware component costs, outsourced manufacturing fees, freight and logistics, cloud hosting costs for software, and customer support personnel costs.
- Gross margin range: 62% to 65% on a GAAP basis; 65% to 68% on a Non-GAAP basis.
- Key input costs and commodity exposures: Semiconductor pricing, contract manufacturing labour rates, and global shipping freight rates.
- How COGS scales with revenue: Hardware COGS scales linearly with volume; software and services COGS exhibit high operating leverage.
Operating Expenses
- R&D: Approximately 13-15% of revenue. Covers hardware engineering, software development, and AI integration.
- SG&A: Approximately 25-28% of revenue. Heavily driven by global enterprise sales force commissions and marketing.
- Depreciation & Amortisation: Significantly elevated (approx. 5-7% of revenue) due to the amortisation of purchased intangible assets from the Splunk acquisition.
- Stock-Based Compensation: Approximately 4-6% of revenue, used heavily to retain software engineering talent.
- Restructuring / one-time charges: Frequent in recent years, including major layoff announcements in FY24 and FY25 to realign focus toward AI and cybersecurity.
Margin Profile
- Gross margin: 64.9% (FY25 GAAP).
- Operating margin: 19-22% (GAAP) vs 32-34% (Non-GAAP). The massive gap is driven by Splunk amortisation and stock-based compensation.
- Margin trend: Non-GAAP margins are expanding slightly due to the mix shift toward higher-margin software (Splunk) and restructuring cost savings.
Balance Sheet Structure
- Total assets: Approximately $100 billion scale.
- Key asset categories: Cash and short-term investments, Goodwill, and Purchased Intangible Assets.
- Goodwill & intangibles as % of total assets: Extremely high (40-50%+) following the $28 billion Splunk acquisition.
- Working capital profile:
- Days Sales Outstanding (DSO): 35-45 days.
- Days Inventory Outstanding (DIO): 15-25 days (asset-light outsourced manufacturing keeps this low).
- Days Payable Outstanding (DPO): 45-55 days.
- Net working capital as % of revenue: Negative.
- Is working capital positive or negative? Negative. Cisco benefits from massive deferred revenue balances (over $27 billion), meaning customers fund the company's growth upfront.
- PP&E: Relatively small (approx. 3-5% of assets) due to outsourced manufacturing.
- Right-of-use assets / operating leases: Material but manageable, primarily global office real estate.
Capital Expenditure & Investment
- Capex as % of revenue: 1.5% to 2.5% (highly capital efficient).
- Maintenance capex vs. growth capex: 60% maintenance (IT systems, lab equipment) vs 40% growth.
- Major capex programmes underway or planned: Investments in AI data centre designs and secure AI factories.
- Capitalised software / development costs: Material, but a fraction of total R&D.
- M&A pattern: Serial acquirer with occasional transformational deals (Splunk).
- Typical acquisition multiple paid: High revenue multiples for software/security assets (Splunk was acquired for approx. 7x forward revenue).
Debt & Capital Structure
- Total debt: Issued significant new debt in early 2024 to fund the Splunk acquisition.
- Debt/EBITDA ratio: Currently elevated compared to historical norms but highly manageable (approx. 1.5x to 2.0x).
- Credit rating: AA- / A1 (investment grade).
- Key debt instruments: Senior unsecured notes across various maturities.
- Maturity profile: Well-laddered over the next 10-30 years.
- Interest rate profile: Primarily fixed-rate bonds.
- Covenants: Standard investment-grade covenants; no restrictive financial maintenance covenants.
- Share repurchase programme: Highly active. Cisco returned $12.4 billion to shareholders in FY25 (94% of free cash flow) via buybacks and dividends.
- Dividend policy: Quarterly dividend of $0.40 per share (approx. 3% yield), growing slowly.
Cash Flow Characteristics
- Operating cash flow conversion: Very strong. OCF was $14.2 billion in FY25.
- Free cash flow margin: 20% to 25% of revenue.
- Major non-cash items that bridge net income to OCF: Depreciation, massive amortisation of Splunk intangibles, stock-based compensation, and increases in deferred revenue.
- Working capital cash flow impact: Deferred revenue growth is a major source of operating cash flow.
- Capex intensity: Very low, resulting in FCF closely mirroring OCF.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are typically lower than the GAAP rate due to the timing of deductions and R&D capitalisation rules.
Sheet Structure
- Assumptions: Hardcoded drivers for macroeconomic inputs, segment growth rates, margin targets, and capital allocation policies.
- Revenue Build: Detailed buildup of Networking, Security, Collaboration, Observability, and Services revenue. Must include a schedule for Annualised Recurring Revenue (ARR) and software subscription mix.
- Income Statement: GAAP and Non-GAAP views. Must explicitly break out Amortisation of Purchased Intangibles and Stock-Based Compensation to bridge GAAP to Non-GAAP operating income.
- Balance Sheet: Standard asset and liability line items, with specific callouts for Deferred Revenue (short-term and long-term) and Goodwill/Intangibles.
- Cash Flow Statement: Indirect method starting from Net Income, adding back D&A, SBC, and changes in Deferred Revenue.
- Working Capital & Deferred Revenue: Detailed roll-forward of the deferred revenue balance (Beginning Balance + Billings - Recognised Revenue = Ending Balance).
- Debt Schedule: Tranche-by-tranche breakdown of senior notes, calculating interest expense and tracking maturities.
- Valuation (DCF): Unlevered free cash flow build, WACC calculation, and terminal value based on a perpetual growth rate.
Key Financial Relationships
- Total Revenue = Networking Revenue + Security Revenue + Collaboration Revenue + Observability Revenue + Services Revenue
- Total Subscription Revenue = Total Revenue x Subscription Mix % (Targeting >54%)
- Deferred Revenue Ending Balance = Deferred Revenue Beginning Balance + Total Billings - Total Recognised Revenue
- Non-GAAP Gross Margin = (Total Revenue - GAAP COGS + SBC in COGS + Amortisation in COGS) / Total Revenue
- Non-GAAP Operating Income = GAAP Operating Income + SBC + Amortisation of Intangibles + Restructuring Charges + Acquisition-related costs
- Services Revenue = Prior Year Total Installed Base x Services Attach Rate
- Networking Revenue = Prior Year Networking Revenue x (1 + Networking Growth Rate)
- Security Revenue = Organic Security Revenue + Splunk Security Contribution
- Free Cash Flow = Operating Cash Flow - Capital Expenditures
- Total Capital Returned to Shareholders = Dividends Paid + Share Repurchases (Targeting ~90-95% of FCF)
Cross-Sheet Dependencies
- The Revenue Build sheet dictates the top line of the Income Statement and drives the Billings calculation in the Working Capital & Deferred Revenue sheet.
- The Working Capital & Deferred Revenue sheet calculates the change in deferred revenue, which is a critical positive adjustment in the Cash Flow Statement.
- The Debt Schedule calculates interest expense, which feeds into the Income Statement and reduces Net Income, thereby impacting the starting point of the Cash Flow Statement.
- The Cash Flow Statement determines the ending cash balance, which feeds the Balance Sheet to ensure Total Assets equal Total Liabilities plus Equity. Circularity risk exists if interest income on cash balances is dynamically linked to the average cash balance; use a beginning-balance switch to break the loop if necessary.
Sign Convention
- Revenue, Assets, and Equity are entered as positive numbers.
- Expenses on the Income Statement are entered as positive numbers and subtracted in subtotal formulas (e.g., Gross Profit = Revenue - COGS).
- Liabilities are entered as positive numbers.
- On the Cash Flow Statement, cash inflows are positive, and cash outflows (including Capex, Dividends, and Share Repurchases) are negative.
Things Most Likely to Go Wrong
- Splunk Integration Distortion: Failing to separate organic security growth from the inorganic Splunk contribution will result in wildly inaccurate forward growth projections.
- GAAP vs Non-GAAP Confusion: Cisco's GAAP operating margins are depressed by massive amortisation from the Splunk deal. The model must explicitly bridge GAAP to Non-GAAP to reflect true cash-generating power.
- Deferred Revenue Disconnect: If the model grows software revenue without simultaneously growing the deferred revenue liability and the corresponding operating cash flow benefit, the cash flow forecast will be severely understated.
- Stock-Based Compensation: Excluding SBC from free cash flow calculations flatters the valuation. The model must treat SBC as a real economic cost in the DCF, even though it is a non-cash add-back on the cash flow statement.
- Hardware Cyclicality: Extrapolating peak networking growth rates into perpetuity ignores the natural inventory digestion cycles of enterprise hardware customers.
- Interest Expense Drag: Forgetting to model the interest expense from the debt issued to acquire Splunk will overstate net income.
- Share Count Reduction: Cisco buys back billions in stock annually. Failing to reduce the diluted share count over the forecast period will understate EPS.
- Restructuring Charges: Treating restructuring charges as "one-time" when Cisco has reported them almost annually in recent years will artificially inflate long-term margin assumptions.
Validation Checks
- "Non-GAAP Gross margin should be in the 65-68% range based on the last 3 years; flag if outside this band."
- "Subscription revenue as a percentage of total revenue must exceed 50% and trend upward."
- "OCF/Net Income conversion should be >1.2x due to high deferred revenue and amortisation add-backs."
- "Capex as a % of revenue should remain between 1.5% and 2.5%."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Total Capital Returned to Shareholders (Dividends + Buybacks) should not exceed 100% of Free Cash Flow over a 3-year average."
- "Non-GAAP effective tax rate should be approximately 19%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Networking Revenue Growth | 3.0 | % | Normalised growth post-inventory digestion, aided by AI infrastructure. |
| Security Revenue Growth | 15.0 | % | Reflects full integration of Splunk and cross-selling synergies. |
| Collaboration Revenue Growth | 1.0 | % | Mature market with intense competition from Microsoft/Zoom. |
| Observability Revenue Growth | 20.0 | % | High growth driven by Splunk and ThousandEyes enterprise adoption. |
| Services Revenue Growth | 4.0 | % | Steady growth tied to the expanding installed base. |
| GAAP Gross Margin | 64.9 | % | Based on FY25 actuals. |
| Non-GAAP Gross Margin | 67.5 | % | Based on FY24/FY25 actuals, adjusting for amortisation. |
| R&D as % of Revenue | 14.0 | % | Historical average required to maintain product competitiveness. |
| SG&A as % of Revenue | 26.0 | % | Historical average, reflecting high enterprise sales costs. |
| Capex as % of Revenue | 2.0 | % | Asset-light manufacturing model keeps capex low. |
| Non-GAAP Tax Rate | 19.0 | % | Management guidance for FY25. |
| Dividend per Share (Annual) | 1.60 | $ | Based on $0.40 quarterly dividend declared in late 2024. |
| Share Repurchases | 8.0 | $B | Historical run-rate to return excess FCF to shareholders. |
| WACC | 8.5 | % | Standard discount rate for a mature, large-cap tech company. |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term global GDP and IT spend growth. |
Data Sources & Benchmarks
- Filings: SEC EDGAR (Cisco Systems Inc. Form 10-K for FY24 and FY25).
- Investor Relations: Cisco Investor Relations website for quarterly earnings presentations and Non-GAAP reconciliations.
- Key Peers for Benchmarking: Juniper Networks (JNPR), Palo Alto Networks (PANW), Arista Networks (ANET), Fortinet (FTNT), and Microsoft (MSFT) for collaboration.
- Industry Data: Gartner Magic Quadrant for Enterprise Wired and Wireless LAN Infrastructure; IDC reports on cybersecurity market share.
Sources
Do more with the Cisco model
Frequently asked
What does Cisco Systems, Inc. do?+
Cisco Systems, Inc. is a global leader in networking, cybersecurity, collaboration, and observability solutions that power enterprise IT infrastructure. The company designs and sells a broad range of technologies, increasingly embedding artificial intelligence into its product portfolios to help customers manage and secure their digital operations.
How does Cisco generate revenue, and what are its main business segments?+
Cisco generates revenue through its Networking, Services, Security, Collaboration, and Observability segments, with Networking contributing approximately 45-50% of total revenue. The company is transitioning to a software and subscription-based platform, with subscriptions now accounting for over 54% of its total revenue.
What is Cisco's capital expenditure strategy given its business model?+
Cisco maintains a highly capital-efficient model, with capital expenditure typically ranging from 1.5% to 2.5% of revenue due to its asset-light outsourced manufacturing approach. Investments are primarily directed towards maintenance (IT systems, lab equipment) and growth areas such as AI data center designs and secure AI factories.
How has the Splunk acquisition impacted Cisco's financial structure and growth trajectory?+
The $28 billion acquisition of Splunk, which closed in March 2024, fundamentally altered Cisco's growth trajectory and significantly increased its goodwill and purchased intangible assets. This strategic move supports Cisco's transition towards a software and subscription-based platform, enhancing its cybersecurity and observability offerings.
What are the key assumptions used in the Cisco financial model for forecasting?+
The Cisco financial model incorporates key assumptions such as a revenue growth rate of approximately 2.37% and COGS as 36.7% of revenue. Other significant inputs include R&D as 13.02% of revenue, SGA as 4.03% of revenue, and a tax rate of about 19.24%.
Can I download an Excel financial model for Cisco (CSCO)?+
Yes, an Excel financial model for Cisco (CSCO) is available for download, which evaluates the company's equity valuation and cash flow generation capacity. This model specifically focuses on the financial impact of Cisco's transition from legacy hardware sales to recurring software subscriptions following the transformational Splunk acquisition.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Hardware Company Financial Models
Browse another company in the same sector.
Apple
Apple designs, manufactures, and markets smartphones, personal computers, tablets, and wearables, alongside a growing suite of subscription and transaction-based services.
Arista Networks
Arista Networks provides cloud networking solutions, data centre switches, and routing platforms powered by its proprietary Extensible Operating System (EOS) software.
Ciena
Ciena Corporation is a global leader in networking systems, components, automation software, and services, primarily focused on optical transport and routing/switching solutions.
Dell Technologies
Dell Technologies is a premier provider of IT hardware, software, and service solutions globally.
Garmin
Garmin designs, develops, manufactures, and markets a diverse portfolio of hand-held, wearable, portable, and fixed-mount GPS-enabled products for fitness, outdoor, marine, aviation, and automotive markets.
Hewlett Packard Enterprise
Hewlett Packard Enterprise is a global edge-to-cloud company that provides hardware, software, and financial services to enterprise customers.
HP
HP is a global provider of personal computing and other access devices, imaging and printing products, and related technologies, operating through Personal Systems and Printing segments.
NetApp
NetApp is an intelligent data infrastructure company providing unified data storage, integrated data services, and CloudOps solutions across on-premises environments and major public clouds (AWS, Azure, Google Cloud).
Explore more Tech & Software financial model templates.
