COCA COLA CO (KO) valuation

0 · TTM reconstruction (anchor: Q12026, 2026-04-03)

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

• Q1 FY26 (2026-04-03): $12.47B
• Q4 FY25 (2025-12-31): $11.82B
• Q3 FY25 (2025-09-26): $12.46B
• Q2 FY25 (2025-06-27): $12.54B
• = $49.28B

EBIT

Sum of the four most recent per-quarter values

• Q1 FY26 (2026-04-03): $4.36B
• Q4 FY25 (2025-12-31): $1.84B
• Q3 FY25 (2025-09-26): $3.98B
• Q2 FY25 (2025-06-27): $4.28B
• = $14.46B

OCF

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

• FY FY25 (2025-12-31): +$7.41B
• Q1 FY26 (2026-04-03) YTD: +$2.02B
• Q1 FY25 (2025-03-28) YTD: −-$5.20B
• = $14.63B

CapEx

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

• FY FY25 (2025-12-31): +$2.11B
• Q1 FY26 (2026-04-03) YTD: +$266.0M
• Q1 FY25 (2025-03-28) YTD: −$309.0M
• = $2.07B

Stock-based compensation

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

• FY FY25 (2025-12-31): +$279.0M
• Q1 FY26 (2026-04-03) YTD: +$56.0M
• Q1 FY25 (2025-03-28) YTD: −$63.0M
• = $272.0M

Prior-year TTM revenue (growth-calc baseline)

Sum of the four most recent per-quarter values

• Q1 FY25 (2025-03-28): $11.13B
• Q4 FY24 (2024-12-31): $11.54B
• Q3 FY24 (2024-09-27): $11.85B
• Q2 FY24 (2024-06-28): $12.36B
• = $46.89B

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

Diluted shares = point-in-time basic × 1.0028× (filer's TSM dilution multiplier from WeightedAverageNumberOfDilutedSharesOutstanding ÷ WeightedAverageNumberOfSharesOutstandingBasic , period ending 2026-04-03 ). See the diluted-shares methodology.

Noncontrolling interest = book NCI on the consolidated BS ( MinorityInterest $2.10B ). Subtracted from the equity bridge so per-share fair value reflects the common-shareholder claim only. See the NCI methodology.

Cash is split into the operating floor an operating business needs (2% of revenue, Damodaran heuristic) and the distributable surplus that flows to equity holders. Only excess cash is netted against debt because the DCF values the operating business, and the operating cash stays inside it. Banks, insurers, and REITs are exempt — their cash backs deposits / regulatory reserves / investment portfolios rather than working capital. See the methodology.

Market cap     = price × diluted shares
               = $76.72 × 4.31B
               = $331.01B

Total cash     = $10.57B
Operating cash = 2% × revenue = $985.7M
Excess cash    = max(0, total − operating) = $9.59B

EV target      = market cap + total debt + NCI − excess cash
               = $331.01B + $43.81B + $2.10B − $9.59B
               = $367.33B
            

2 · Starting NOPAT (base year 0)

Tax rate source: 3-year median of EffectiveTaxRate. See the tax-rate methodology for the precedence ladder.

Tax rate fades from 17.9% at year 0 to 21.0% at year 10 (US federal statutory floor). The current effective rate is the most honest reading of this filer's recent economics, but holding it as the perpetuity rate would compound a one-off NOL benefit / R&D credit / foreign-mix tilt across the whole horizon. WACC's after-tax cost of debt uses the terminal rate so the discount rate is consistent with the long-run cash flows it discounts.

GAAP EBIT          = $14.46B   (29.3% of revenue)
× (1 − tax rate)  = × (1 − 17.9%) = × 0.8212
= NOPAT₀            = $11.88B
            

3 · Invested capital & starting ROIC

Net deferred-tax position (-$1.47B net DTL) stripped from IC. DTAs (NOL / credit carryforwards, post valuation allowance) and DTLs (timing differences from accelerated depreciation) are tax-accounting artifacts, not capital deployed in operations — equity-based IC inadvertently absorbs them via E = Assets − Liabilities, so we back them out so ROIC reflects operating returns on operating capital.

Invested capital = total debt + book equity − excess cash − net deferred tax (−DTL)
                 = $43.81B + $33.63B − $9.59B − -$1.47B
                 = $69.33B

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

4 · WACC derivation

Cost of equity from CAPM , after-tax cost of debt from a synthetic credit rating built off interest coverage , weighted by market values of equity and debt. Inputs: Rf is FRED DGS10's 90-day mean (latest 2026-05-29); β is the 5-yr weekly regression vs VOO, floored at 0.65 (Consumer Staples sector floor) for the cost-of-equity step (the empirical security market line is much flatter than CAPM predicts — Frazzini-Pedersen 2014, "Betting Against Beta" — so unfloored CAPM systematically under-estimates required return for low-β filers); ERP is the latest Damodaran US total ERP (2026-01-01). The synthetic rating is a Damodaran coverage-table heuristic, not an empirical S&P / Moody's letter. It maps EBIT-÷-interest into a letter-grade bucket and reads the spread out of a lookup table; an actual agency rating considers qualitative factors (governance, market position, jurisdiction, off-balance-sheet exposure) the coverage ratio can't capture. For most filers the gap is small; for capital-light, high-coverage names — software, IT services, consumer brands — this method tends to print AAA/AA where actual agency ratings sit at A/BBB+, and the resulting cost of debt is a few tens of bps light. WACC is more sensitive to β and weights than to credit, so the headline barely moves; flagged here so readers don't read the rating as an empirical agency assessment.

Cost of equity        = Rf + β × ERP
                      = 4.3% + 0.65 × 4.5%   (β floored from raw 0.37 to 0.65 — Consumer Staples sector floor)
                      = 7.2%

Cost of debt (pretax) = Rf + credit spread
                      = 4.3% + 0.9%   (synthetic A+, EBIT ÷ interest = 8.8×)
                      = 5.2%
× (1 − tax rate)      = × (1 − 17.9%)
= Cost of debt (a/t)  = 4.1%

Weights               E/V = 88.3%, D/V = 11.7%

WACC (raw)            = E/V × cost_e + D/V × cost_d_after_tax
                      = 88.3% × 7.2% + 11.7% × 4.1%
                      = 6.9%

Sensitivity: without β floor
WACC                  = 88.3% × 6.0% + 11.7% × 4.1%
                      = 5.8%   (β = raw 0.37; +112 bps vs headline — what unfloored CAPM would print)
                

5 · Growth path construction

Source       = analyst consensus (absolute forecast, TTM-anchored): Y1 = -0.4%, Y2 = 1.9%

Detailed derivation:
  Current-FY analyst avg revenue forecast = $49.09B   (FY-over-FY vs FY2025 actual = 2.4%)
  Next-FY analyst avg revenue forecast    = $50.04B   (FY-over-FY vs current-FY forecast = 1.9%)
  Base revenue (TTM) = $49.28B
  Latest completed FY revenue (FY2025) = $47.94B   (denominator for the FY-over-FY check above)

  Y1 = current-FY forecast / TTM base revenue − 1
     = $49.09B / $49.28B − 1
     = -0.4%

  Y2 = next-FY forecast / current-FY forecast − 1
     = $50.04B / $49.09B − 1
     = 1.9%

  Note: the absolute analyst forecast is re-anchored
  against TTM (rather than the FY-over-FY consensus
  rate above) because the TTM base spans the current
  FY only partway. Re-anchoring keeps the growth rate
  consistent with the projection's starting revenue
  level.
Clamp        = [2.5%, 60%] (no sub-terminal or 60%+ starts)
Plateau rate = 1.9% (Y2 — held from year 2 through end of plateau)
Tier         = 3 years (rule: plateau rate < 15% → 3y, < 25% → 5y, else 7y)
Plateau      = 3 years
Fade         = linear from effective Y2 to terminal 2.5% across the remaining 7 years

Effective Y1 growth after solver bumps = 11.6%
Effective Y2 growth after solver bumps = 13.9%
Growth by year:
  Y1 = 11.6%
  Y2 = 13.9%
  Y3 = 13.9%
  Y4 = 12.3%
  Y5 = 10.7%
  Y6 = 9.0%
  Y7 = 7.4%
  Y8 = 5.8%
  Y9 = 4.1%
  Y10 = 2.5%
                

6 · Margin path construction

Starting margin (Y0) = 28.3%   (source: 77% TTM + 23% 3-yr mean (gap 4.5pp falls in 4–6pp transition band))
Target margin (Y10)  = 31.8%   (solver output, normal band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 28.7%
  Y2 = 29.0%
  Y3 = 29.4%
  Y4 = 29.7%
  Y5 = 30.1%
  Y6 = 30.4%
  Y7 = 30.8%
  Y8 = 31.1%
  Y9 = 31.5%
  Y10 = 31.8%

Filer-history margin distribution (10 FY, trimmed-10-90):
  p25 = 23.9%, p50 = 26.0%, p75 = 26.8%
  raw min = 20.7%, raw max = 28.7%
Path-stretch sub-counts:
  10 of 10 years above filer p75 (26.8%)
  9 of 10 years above filer max-ever (28.7%)
  Terminal/start ratio = 112%
Binding trigger = unprecedented-margin (drives the page badge)
            

7 · ROIC path construction

The capex heuristic compares latest-period CapEx ($2.07B) against the Normalized CapEx (3-yr mean) of $2.01B — 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.03× the 3-yr mean of $2.01B — below the 1.4× / 5%-of-revenue gates).
Fade from Y1: ROIC_t = ROIC₀ + (ROIC_terminal − ROIC₀) × (t / 10)
ROIC₀ = 17.1%; ROIC_terminal = 6.9%

ROIC by year:
  Y1 = 16.1%
  Y2 = 15.1%
  Y3 = 14.1%
  Y4 = 13.0%
  Y5 = 12.0%
  Y6 = 11.0%
  Y7 = 10.0%
  Y8 = 8.9%
  Y9 = 7.9%
  Y10 = 6.9%
            

7a · Reinvestment formula

The Damodaran growth-firm closure Reinvestment_t = ΔRevenue_t ÷ salesToCapital collapses to noise whenever EITHER the 3-year revenue change OR the 3-year net reinvestment is small relative to the revenue base. The model picks the most-honest formula via a 3-tier ladder: tier-1 standard sales-to-capital fires only when both signals carry magnitude AND the resulting ratio sits inside the typical 0.5–8 band; tier-2 substitutes a TTM (CapEx − D&A) ÷ Revenue ratio applied to each projection year's revenue (not its delta); tier-3 falls through to the ΔNOPAT ÷ ROIC closure when neither signal is usable.

Inputs:
  ΔRev_3y                          = $6.28B
  netReinvest_3y (CapEx − D&A)     = $2.77B
  avgRevenue_3y                    = $46.14B
  TTM CapEx − D&A                  = $1.02B
  TTM Revenue                      = $49.28B

Tier-1 gates (all three must clear):
  |ΔRev_3y| / avgRev_3y > 1.0%     13.61%         ✓ pass
  netReinv_3y / avgRev_3y > 1.5%   6.01%          ✓ pass
  0.5 ≤ s2c candidate ≤ 8          2.263          ✓ pass

Tier-1 fires.
  salesToCapital = ΔRev_3y ÷ netReinvest_3y = $6.28B ÷ $2.77B = 2.263
  Reinvestment_t = ΔRevenue_t ÷ 2.263
            

8 · Solver iterations

Each row is one configuration in the solver ladder; the "Solved margin" column is the result of bisecting the EBIT margin (up to 80 inner iterations) to match the EV target for that row's plateau / Y1 bump / phase. 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 row is the one the page uses. If no combination reconciles, the page shows the row whose PV sits closest to the target EV so both levers are balanced.

9 · Terminal value derivation

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

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $737.3M
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $737.3M / 6.9%
                    = $10.72B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $30.23B − $10.72B
                    = $19.51B

Terminal value (TV) = FCF_{N+1} / (WACC − g_terminal)
                    = $19.51B / (6.9% − 2.5%)
                    = $445.73B

PV(TV)              = TV / (1 + WACC)^(10 − 0.5)
                    = $445.73B / 1.881
                    = $236.96B

10 · 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) = $130.36B
+ PV(TV)          = $236.96B
= Enterprise value = $367.33B   (≈ EV target $367.33B by construction)
− Total debt      = $43.81B
+ Excess cash     = $9.59B   (total $10.57B − operating $985.7M)
− NCI             = $2.10B
= Equity value    = $331.01B
÷ Diluted shares  = 4.31B
= DCF PV / share  = $76.72

Market price      = $76.72
Reconciliation Δ  = +0.0%   (≈ 0 by construction — the solver anchored on this price)