# Cisco (CSCO) Financial Model Free Excel 3-statement financial model and company analysis for Cisco. - Canonical: https://finamodel.com/companies/cisco - Industry: Hardware - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/CSCO.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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 1. **Assumptions**: Hardcoded drivers for macroeconomic inputs, segment growth rates, margin targets, and capital allocation policies. 2. **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. 3. **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. 4. **Balance Sheet**: Standard asset and liability line items, with specific callouts for Deferred Revenue (short-term and long-term) and Goodwill/Intangibles. 5. **Cash Flow Statement**: Indirect method starting from Net Income, adding back D&A, SBC, and changes in Deferred Revenue. 6. **Working Capital & Deferred Revenue**: Detailed roll-forward of the deferred revenue balance (Beginning Balance + Billings - Recognised Revenue = Ending Balance). 7. **Debt Schedule**: Tranche-by-tranche breakdown of senior notes, calculating interest expense and tracking maturities. 8. **Valuation (DCF)**: Unlevered free cash flow build, WACC calculation, and terminal value based on a perpetual growth rate. ## Key Financial Relationships 1. Total Revenue = Networking Revenue + Security Revenue + Collaboration Revenue + Observability Revenue + Services Revenue 2. Total Subscription Revenue = Total Revenue x Subscription Mix % (Targeting >54%) 3. Deferred Revenue Ending Balance = Deferred Revenue Beginning Balance + Total Billings - Total Recognised Revenue 4. Non-GAAP Gross Margin = (Total Revenue - GAAP COGS + SBC in COGS + Amortisation in COGS) / Total Revenue 5. Non-GAAP Operating Income = GAAP Operating Income + SBC + Amortisation of Intangibles + Restructuring Charges + Acquisition-related costs 6. Services Revenue = Prior Year Total Installed Base x Services Attach Rate 7. Networking Revenue = Prior Year Networking Revenue x (1 + Networking Growth Rate) 8. Security Revenue = Organic Security Revenue + Splunk Security Contribution 9. Free Cash Flow = Operating Cash Flow - Capital Expenditures 10. 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 * Cisco Systems, Inc. FY24 Annual Report (Form 10-K) * Cisco Systems, Inc. Q4 FY24 Earnings Release * Cisco Systems, Inc. Q4 FY25 Earnings Release and FY25 Full Year Results * Cisco Systems, Inc. Q1 FY25 Earnings Release * SEC EDGAR Database for historical filings --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/cisco/forecast)