CISCO SYSTEMS, INC. (CSCO) valuation

0 · TTM reconstruction (anchor: Q22026, 2026-01-24)

The latest filing is a 10-Q, so "base year" revenue / EBIT / OCF / CapEx are reconstructed as trailing-twelve-month values. Per-quarter facts (typical for income-statement items) get summed across four quarters; YTD-cumulative facts (typical for cash-flow items) use prior FY + YTD_now − YTD_{prior year same quarter}.

Revenue

Sum of the four most recent per-quarter values

• Q2 FY26 (2026-01-24): $15.35B
• Q1 FY26 (2025-10-25): $14.88B
• Q4 FY25 (2025-07-26): $14.67B
• Q3 FY25 (2025-04-26): $14.15B
• = $59.05B

EBIT

Sum of the four most recent per-quarter values

• Q2 FY26 (2026-01-24): $3.78B
• Q1 FY26 (2025-10-25): $3.36B
• Q4 FY25 (2025-07-26): $3.09B
• Q3 FY25 (2025-04-26): $3.20B
• = $13.43B

OCF

Prior FY + current-quarter YTD − same-quarter-prior-year YTD

• FY FY25 (2025-07-26): +$14.19B
• Q2 FY26 (2026-01-24) YTD: +$5.03B
• Q2 FY25 (2025-01-25) YTD: −$5.90B
• = $13.32B

CapEx

Prior FY + current-quarter YTD − same-quarter-prior-year YTD

• FY FY25 (2025-07-26): +$905.0M
• Q2 FY26 (2026-01-24) YTD: +$606.0M
• Q2 FY25 (2025-01-25) YTD: −$427.0M
• = $1.08B

Prior-year TTM revenue (growth-calc baseline)

Sum of the four most recent per-quarter values

• Q2 FY25 (2025-01-25): $13.99B
• Q1 FY25 (2024-10-26): $13.84B
• Q4 FY24 (2024-07-27): $13.64B
• Q3 FY24 (2024-04-27): $12.70B
• = $54.18B

1 · Enterprise-value target (what the DCF must match)

Market cap   = price × diluted shares
             = $89.01 × 3.95B
             = $351.50B

EV target    = market cap + total debt − cash & equivalents
             = $351.50B + $26.27B − $7.46B
             = $370.31B
            

2 · Starting NOPAT (base year 0)

GAAP EBIT          = $13.43B   (22.7% of revenue)
× (1 − tax rate)  = × (1 − 15.6%) = × 0.8436
= NOPAT₀            = $11.33B
            

3 · Invested capital & starting ROIC

Invested capital = total debt + book equity − cash
                 = $26.27B + $47.72B − $7.46B
                 = $66.54B

Raw ROIC₀        = NOPAT₀ / Invested capital
                 = $11.33B / $66.54B
                 = 17.0%
(no cap applied; raw value is within the 40.0% ceiling)
            

4 · Growth path construction

Source       = analyst consensus (absolute forecast, TTM-anchored): Y1 = 4.3%, Y2 = 5.5%
Clamp        = [2.5%, 60%] (no sub-terminal or 60%+ starts)
Plateau rate = 5.5% (Y2 — held from year 2 through end of plateau)
Tier         = 3 years (rule: plateau rate < 15% → 3y, < 25% → 5y, else 7y)
Solver ext.  = 5 years (solver extended to reconcile the DCF with the current price)
Plateau      = 5 years
Fade         = linear from effective Y2 to terminal 2.5% across the remaining 5 years

Effective Y1 growth after solver bumps = 24.3%
Effective Y2 growth after solver bumps = 25.5%
Growth by year:
  Y1 = 24.3%
  Y2 = 25.5%
  Y3 = 25.5%
  Y4 = 25.5%
  Y5 = 25.5%
  Y6 = 20.9%
  Y7 = 16.3%
  Y8 = 11.7%
  Y9 = 7.1%
  Y10 = 2.5%
            

5 · Margin path construction

Starting margin (Y0) = 22.7%   (source: latest FY EBIT margin (GAAP))
Target margin (Y10)  = 30.3%   (solver output, normal band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 23.5%
  Y2 = 24.3%
  Y3 = 25.0%
  Y4 = 25.8%
  Y5 = 26.5%
  Y6 = 27.3%
  Y7 = 28.1%
  Y8 = 28.8%
  Y9 = 29.6%
  Y10 = 30.3%
            

6 · ROIC path construction

The capex heuristic compares latest-period CapEx ($1.08B) against the Normalized CapEx (3-yr mean) of $808.0M — mean of the last three annual CapEx values. When the latest is above 1.4× that mean and CapEx is at least 5% of revenue, we treat the filer as capital-intensive and mid-investment, hold ROIC flat for a 5-year harvest phase, and only then fade to terminal ROIC. The 3-yr mean does not feed the DCF directly — it only gates this flag.

Capex-heuristic inactive (latest CapEx 1.34× the 3-yr mean of $808.0M — below the 1.4× / 5%-of-revenue gates).
Fade from Y1: ROIC_t = ROIC₀ + (ROIC_terminal − ROIC₀) × (t / 10)
ROIC₀ = 17.0%; ROIC_terminal = 11.0%

ROIC by year:
  Y1 = 16.4%
  Y2 = 15.8%
  Y3 = 15.2%
  Y4 = 14.6%
  Y5 = 14.0%
  Y6 = 13.4%
  Y7 = 12.8%
  Y8 = 12.2%
  Y9 = 11.6%
  Y10 = 11.0%
            

7 · Solver iterations

Each row is one bisection attempt. The solver sweeps Y1 growth bumps 0pp → +20pp across the plateau ladder inside the normal margin bracket, then — if nothing reconciles — repeats the same sweep in a widened margin band ([-10%, 80%]). The first feasible attempt is the one the page uses. If no combination reconciles, the page shows the attempt whose PV sits closest to the target EV so both levers are balanced.

8 · Terminal value derivation

NOPAT_{N+1}         = NOPAT_{10} × (1 + g_terminal)
                    = $80.37B × (1 + 2.5%)
                    = $82.38B

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $2.01B
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $2.01B / 11.0%
                    = $18.27B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $82.38B − $18.27B
                    = $64.12B

Terminal value (TV) = FCF_{N+1} / (WACC − g_terminal)
                    = $64.12B / (9.0% − 2.5%)
                    = $986.39B

PV(TV)              = TV / (1 + WACC)^10
                    = $986.39B / 2.367
                    = $416.66B
            

9 · Reconciliation check (DCF PV vs. the market)

This isn't a fair value — it's the inverse check. The solver built the scenario so that DCF PV reproduces the current enterprise value; if the normal bracket worked the delta below is ~0 by construction. A non-zero delta only appears when the solver fell through to the widened margin band.

Σ PV(FCF_1..10) = -$47.69B
+ PV(TV)          = $416.66B
= Enterprise value = $368.97B   (≈ EV target $370.31B by construction)
− Total debt      = $26.27B
+ Cash            = $7.46B
= Equity value    = $350.16B
÷ Diluted shares  = 3.95B
= DCF PV / share  = $88.67

Market price      = $89.01
Reconciliation Δ  = −0.4%   (≈ 0 by construction — the solver anchored on this price)