Cisco Systems Equity Valuation (CSCO)
University of Edinburgh · Equity Valuation · June 2026This project values Cisco Systems (NASDAQ: CSCO) from the ground up and concludes the stock is materially overvalued — a base-case intrinsic value of $48.56 a share against a market price of about $120. The verdict comes from a full free-cash-flow-to-firm (FCFF) discounted cash flow model, cross-checked against peer trading multiples, a reverse DCF (working backwards from today's price to find what growth it would require to be fair), and a 50,000-trial Monte Carlo simulation — all built as a reproducible Python model with a formula-driven Excel audit workbook.
Snapshot
Verdict at valuation date: materially overvalued. The base-case intrinsic value is $48.56/share against a market price of ≈$120.16 — the market embeds AI-driven growth beyond even the bull case ($59.63). This is not a denial that AI networking demand is real; it is a finding about what is already priced in.
1 · Business overview
Cisco operates five segments — Networking, Security, Collaboration, Observability, Services — with the Splunk acquisition (March 2024), its largest ever, reshaping the mix. FY2025 revenue was $56.7B, with the Americas contributing 59%. Mid-year FY2026 guidance raised cumulative AI-infrastructure orders to $9.0B and AI-related revenue to $4.0B, with product-order growth running ≈35% YoY.
Segment revenue mix, FY2025
Security (+59% → $8.1B) and Observability (+26% → $1.1B) growth is largely Splunk-driven — the model isolates inorganic contribution before forecasting.
Geographic revenue mix, FY2025
Americas 59% / EMEA 26% / APJC 14% — the same weights blend the regional equity risk premia in §4.
2 · Industry and business risk
The central risk question: how much of the FY2026 order surge is durable? Cisco has been here before — FY2023's 10-K reported quarterly product-order growth "over 30%, the second highest rate in 20 years," and Networking revenue then collapsed from $34.6B (FY2023) to $29.2B (FY2024), a −15.5% reversal. Ex-hyperscaler order growth is ≈19% (about half the headline), and the CFO attributed 4–5pp of that to price increases while calling pull-forward "a very modest amount."
Competitors pressure every segment: Arista (AI fabric), Palo Alto and Fortinet (security), HPE/Juniper (enterprise networking), Broadcom (merchant silicon plus post-VMware virtualisation).
Revenue trajectories: bull / base / bear, TTM → year 10
The bear path embeds the FY2022–24 pull-forward reversal precedent (−20% to −28% product orders, Networking −15.5% YoY); the base case treats AI demand as structural but moderated.
3 · Financial analysis
FY2025 free cash flow was $13.3B on $56.7B revenue, with capex of only ≈1.6% of revenue — Cisco is a cash machine that returned ~94% of FCF ($6.4B dividends + $6.0B buybacks) while also repaying $2.8B of debt. On a TTM basis with R&D capitalised (3-year life), adjusted EBIT is ≈$15.2B on revenue of $60.7B.
Revenue and GAAP operating margin, FY2021–FY2025
Non-linear history: supply-chain surge, order reversal, then stabilisation — the reason the forecast is built segment-by-segment rather than trend-extrapolated.
4 · Capital structure and WACC
Every component is built bottom-up, no defaults:
- Risk-free 4.10% — 10-year UST 4.50% (28 May 2026) less a 0.40% sovereign default spread.
- Beta 1.067 — Damodaran sector betas, revenue-mix weighted and cash-corrected (unlevered 1.02), Hamada re-levered to Cisco's capital structure. No Blume adjustment.
- ERP 4.82% — GDP-weighted regional total ERPs blended by Cisco's revenue geography (Americas 4.44% / EMEA 5.20% / APJC 5.72% at 59/26/14).
- Cost of debt — observed 4.64% YTM on the CSCO 4.95% Feb-2032 note (G-spread ~41bp), tax glide 18.5% → 25%.
- Weights — market values: $478B equity vs $29.6B lease-inclusive debt → 94.2% / 5.8%.
WACC build: Ke 9.24% × 94.2% + after-tax Kd 3.78% × 5.8%
Equity weight ~94% means WACC ≈ cost of equity. Result: 8.93%.
5 · Growth forecast and assumptions
Ten-year explicit horizon from a TTM base of $60,746M, built segment by segment: Networking ~6% in year 1 mean-reverting to 4%; Security and Observability decelerating from mid-teens; Collaboration and Services at low single digits. Base-case revenue reaches $97.9B by year 10 (4.9% CAGR) — deliberately below the market-implied path.
Discipline choices that drive the answer: R&D capitalised over a 3-year amortising life, SBC treated as a real cost (no add-back), reinvestment = g ÷ ROIC (terminal reinvestment stays positive), and terminal growth = risk-free = 4.10%.
Base-case revenue and FCFF path, all ten years
Revenue $60.7B TTM → $97.9B by year 10 (4.9% CAGR), FCFF $12.7B → $17.6B — deliberately below the growth the market price implies.
6 · Intrinsic valuation — DCF
| Component ($M) | Bear | Base | Bull |
|---|---|---|---|
| PV of explicit FCFF (10 yr) | 75,869 | 95,452 | 110,469 |
| Enterprise value | 155,200 | 209,736 | 253,815 |
| Terminal value share of PV | 51.1% | 54.5% | 56.5% |
| (+) Cash & investments | 16,640 | 16,640 | 16,640 |
| (−) Gross debt + op leases | 33,001 | 33,001 | 33,001 |
| Equity value | 138,839 | 193,375 | 237,454 |
| Diluted shares (M) | 3,982 | 3,982 | 3,982 |
| Value per share | $34.87 | $48.56 | $59.63 |
The EV→equity bridge uses the Q3-FY2026 Form 10-Q balance sheet (quarter ended 25 Apr 2026): financial debt $31,303M plus $1,698M operating leases, against $16,640M cash and investments. Terminal value is a healthy but not dominant 54.5% of base-case PV.
Triangulation: DCF, multiples, and 52-week range vs market
Market $120.16 sits ~$61 above the bull DCF and at the top of its own 52-week range. Only the multiples band reaches the price — and §7 shows why it misleads.
7 · Relative valuation — multiples
Peers screened on business-mix overlap, revenue scale ($3B–$100B), and US listing — NVIDIA and Super Micro excluded as median-distorting. Aggregation is median-only; EV/EBITDA is cash-netted.
ANET
PANW
FTNT
HPE · Juniper
AVGO| Multiple | Peer median (NTM) | Cisco | Damodaran predicted (trailing) |
|---|---|---|---|
| EV/EBITDA | 30.3× | 29.6× | 22.6× |
| EV/Sales | 14.4× | 8.1× | 7.7× |
| P/E (NTM) | 39.1× | 25.4× | — |
| P/E (GAAP trailing) | — | 46.6× | 33.6× |
Naive peer medians imply ≈$123 (EV/EBITDA) to ≈$185 (P/E) per share — but Cisco's blended growth (~9%) is a fraction of peers like Arista (~24%), so peer medians import growth Cisco doesn't have. A Damodaran 2026 regression cross-check on fundamentals says Cisco trades 31–39% above what its own growth, margin, and payout justify. The forward-vs-trailing P/E gap (25.4× vs 46.6×) is SBC and acquired-intangible amortisation excluded from consensus EPS.
Cisco vs peer-median vs regression-predicted multiples
Peer medians import growth Cisco doesn't have (blended ~9% vs peers up to ~24%); the fundamentals-based Damodaran regression says Cisco trades 31–39% above what its own growth, margin, and payout justify.
8 · Synthesis, sensitivity, and reverse DCF
No credible parameter change bridges the gap: across WACC 8.2–9.7% and terminal growth 3.5–4.5%, base value stays below $63. The reverse DCF asks the sharper question — what must be true for $120.16 to be right? Either perpetual forward revenue growth of ≈17.8% (more than 3.5× the base CAGR, forever), or a WACC of 5.79% — 314bp below the bottom-up rate.
Sensitivity: intrinsic value per share, WACC × terminal growth
The exact 5×5 grid from the model. Outlined cell = base case ($48.56 at WACC 8.93%, g 4.10%). Even the most generous corner stays $41 below the market.
Implied growth vs base-case CAGR
The market prices 17.8% constant revenue growth vs the 4.9% base path.
Implied WACC vs bottom-up WACC
Alternatively: a 5.79% discount rate, 314bp below the bottom-up 8.93%.
Probabilistic valuation
Scenarios weighted base 45% / bull 30% / bear 25% give a probability-weighted intrinsic of $48.46. A seeded 50,000-trial Monte Carlo over the key drivers — with growth×margin correlated via a Gaussian copula (ρ = 0.5) — puts P(intrinsic > price) at 0%: the distribution's maximum (~$106) never reaches $120.
Monte Carlo intrinsic-value distribution, 50,000 trials
The model's actual histogram: median $48.74, mean $49.63, P5–P95 band $36.01–$66.44. The entire distribution sits below the $120.16 market price.
Scenario-weighted value bridge
Weighting the scenarios 45/30/25 lands at $48.46 — within a dime of the base case, so the verdict does not hinge on the scenario probabilities.
9 · Conclusion
Two independent routes reach the same place. The DCF says $48.56 under moderated-but-real AI demand; the reverse DCF says the market needs ~17.8% perpetual growth or a 5.79% discount rate. AI networking demand may be large and durable — but at ≈$120 the market has already priced it beyond the most optimistic credible scenario. (Presented as an analytical finding on market-implied expectations, not a trading recommendation.)
Under the hood
The number you see on any exhibit is computed, never typed — including on this page: every chart above renders the model's own output data. The pipeline is a Python package (model/) with a single assumptions module as the source of truth:
| Module | Role |
|---|---|
assumptions.py | Every tunable input in one place — no magic numbers anywhere else |
historicals.py | 5-year 10-K clean-up, segment crosswalk, Splunk-inorganic isolation |
wacc.py | CAPM Ke, Hamada re-levering, tax glide, market-value weights |
forecast.py | Segment-level 10-year FCFF engine → bull/base/bear array |
dcf.py | Discounting, Gordon terminal value, EV→equity bridge |
multiples.py | Median-only peer engine, cash-netted EV/EBITDA, GAAP P/E |
sensitivity.py | 5×5 grids, scenario table, reverse-DCF root-finders (brentq) |
probabilistic.py | Scenario weighting + seeded 50k Monte Carlo with Gaussian copula |
figures.py | Every report exhibit generated as a side-effect of computation |
export.py + writers/ | 15-sheet Excel workbook, one tested writer per sheet |
verify.py | Evaluates the workbook's formulas and asserts they equal the Python engine |
The Excel model is formula-driven, not a value dump. Fifteen sheets (Cover_Index → Checks): six raw terminal-export sheets (Bloomberg financials/estimates/bond, Refinitiv, PitchBook) feed an Inputs SSoT sheet with per-row source and pull-date provenance, and the WACC/Forecast/DCF/Multiples chains are live formulas in the blue-input/black-formula convention — change an input and the valuation recomputes in Excel. A Checks sheet runs 12 live integrity checks (weights sum to one, WACC > g, terminal-value share in band, bridge ties), and verify.py re-evaluates every formula cell against the Python engine on save. 159 tests cover the engines, the writers, and the report itself.
Built in three milestones: v1.0 the five-phase valuation (data → WACC/forecast → DCF/multiples → stress → report), v1.1 live-data refresh plus the probabilistic layer, v1.2 the fully wired Excel model. A structured self-audit then traced every headline number to a primary source — fetching the actual Q3-FY2026 10-Q, recomputing the ERP from Damodaran's country files, and switching to a cash-corrected beta — moving the base value from $50.14 to the final $48.56 and strengthening the thesis.
Assessment
Marked 73 (A band, before late penalty), with A — Excellent on 7 of 10 rubric criteria including clarity of analysis, logic of argument, critical thinking, structure, and use of figures. From the examiner:
"The scenario analysis, WACC/terminal-growth sensitivity and reverse-DCF are particularly effective because they test the market-implied assumptions directly rather than simply presenting mechanical ranges. […] a well-integrated and analytically logical valuation. Excellent work."
Stack
Python (uv, pandas, numpy, scipy, matplotlib) · openpyxl/xlsxwriter + formulas verification · Typst report · Bloomberg / LSEG Workspace / SEC filings / Damodaran datasets
Competencies
Equity research · FCFF DCF · bottom-up WACC · relative valuation · reverse DCF · scenario & sensitivity analysis · Monte Carlo · financial-model auditability