Three-statement Excel model · 20 quarters and 5 fiscal years of history · 8 quarters and 5 fiscal years of projections
About the CSCO model
This three-statement Excel model covers Cisco Systems, Inc. (CSCO): its income statement, balance sheet and cash flow statement. It holds 20 quarters and 5 fiscal years of history and 8 quarters and 5 fiscal years of projections.
Projected revenue is built from KPI drivers: YoY growth % × product category (Networking / Security / Collaboration / Observability) plus Services; the four categories and a disclosed rounding residual sum to IS Product revenue, across 5 segments.
Beyond the income statement, the workbook has these sections: KPI Drivers, Balance Sheet and Cash Flow Statement.
Model thesis: FY27 guided +15% includes a 53rd week nobody mentioned, worth 1.9pts; AI infra $4B to $7.5B carries 5.5 more
On October 19, 2026, the model passed checks C13 (every subtotal reconciles to the reported figure at $0), C14 (every projected revenue cell traces to a KPI driver row) and C15 (each driver ends in a rate, a count or a historical anchor, never a typed-in projected dollar level). It was last updated September 27, 2026.
Income statement preview
Columns FY24–FY26 are actual results and FY27E–FY29E are our estimates. Figures were recalculated in Excel on September 27, 2026. Dollars in millions, except per share data.
| Income Statement | ||||||
|---|---|---|---|---|---|---|
| Actual | Estimate | |||||
| FY24 | FY25 | FY26 | FY27E | FY28E | FY29E | |
| Product | $39,253 | $41,608 | $48,295 | $57,698 | $60,933 | $65,059 |
| Services | 14,550 | 15,046 | 15,030 | 15,505 | 15,610 | 16,000 |
| Total Revenue | $53,803 | $56,654 | $63,325 | $73,203 | $76,543 | $81,058 |
| Less: Cost of Sales - Product | (14,339) | (15,121) | (17,781) | (22,053) | (23,002) | (24,137) |
| Less: Cost of Sales - Services | (4,636) | (4,743) | (4,684) | (4,725) | (4,722) | (4,800) |
| Total Cost of Sales | ($18,975) | ($19,864) | ($22,465) | ($26,779) | ($27,723) | ($28,937) |
| Gross Margin | $34,828 | $36,790 | $40,860 | $46,424 | $48,819 | $52,122 |
| Less: Research and Development | (7,983) | (9,300) | (9,563) | (10,506) | (10,931) | (11,587) |
| Less: Sales and Marketing | (10,364) | (10,966) | (11,559) | (12,409) | (12,725) | (13,298) |
| Less: General and Administrative | (2,813) | (2,992) | (2,761) | (2,949) | (3,011) | (3,131) |
| Less: Amortization of Purchased Intangible Assets | (698) | (1,028) | (916) | (769) | (592) | (488) |
| Less: Restructuring and Other Charges | (789) | (744) | (693) | (401) | (268) | (243) |
| Total Operating Expenses | ($22,647) | ($25,030) | ($25,492) | ($27,034) | ($27,526) | ($28,747) |
| Operating Income | $12,181 | $11,760 | $15,368 | $19,390 | $21,293 | $23,375 |
| Interest Income | $1,365 | $1,001 | $866 | $825 | $948 | $1,094 |
| Interest Expense | (1,006) | (1,593) | (1,470) | (1,456) | (1,392) | (1,384) |
| Other Income/(Loss), net | (306) | (68) | 1,245 | 73 | 77 | 81 |
| Interest and Other Income/(Loss), net | $53 | ($660) | $641 | ($558) | ($367) | ($209) |
| Income Before Provision for Income Taxes | $12,234 | $11,100 | $16,009 | $18,832 | $20,926 | $23,166 |
| Less: Provision for Income Taxes | ($1,914) | ($920) | ($2,742) | ($2,729) | ($3,139) | ($3,591) |
| Net Income | $10,320 | $10,180 | $13,267 | $16,103 | $17,787 | $19,575 |
| Ratios & Assumptions | ||||||
| YoY Product Revenue Growth | (9.0%) | 6.0% | 16.1% | 19.5% | 5.6% | 6.8% |
| YoY Services Revenue Growth | 5.0% | 3.4% | (0.1%) | 3.2% | 0.7% | 2.5% |
| YoY Total Revenue Growth | (5.6%) | 5.3% | 11.8% | 15.6% | 4.6% | 5.9% |
| Product Gross Margin | 63.5% | 63.7% | 63.2% | 61.8% | 62.3% | 62.9% |
| Services Gross Margin | 68.1% | 68.5% | 68.8% | 69.5% | 69.8% | 70.0% |
The full workbook adds 20 historical and 8 projected quarters, plus KPI Drivers · Balance Sheet · Cash Flow Statement — every subtotal a live formula, every projection traced to a driver.
Cisco Systems research
Aardvark Labs Capital Research has published 8 reports on Cisco Systems (CSCO). The latest is the Q1 FY27 Earnings Recap, published November 13, 2026, rated Outperform.
Cisco Raised the Year by $2.5 Billion and Lost 6%. The Market Is Already Selling Fiscal 2028.
Methodology
Every projected revenue cell traces to a KPI/driver row (C14). Terminal driver cells are rates, counts, or historical anchors — never typed-in projected dollar levels (C15). Every subtotal-vs-reported reconciliation row ties to $0 (C13). Each model is written per-ticker against its actual schema — no cloning, no level-input shortcuts.