Bore Family Office
Valuation Report — The Coca-Cola Company (KO) • March 6, 2026
3-Stage DDM (Ke) • Discount Rate: 7.50% • Current Price: $77.04
Prepared by Lurch • Bore Family Office • Data: Finnhub, StockAnalysis.com, S&P Global Market Intelligence
🏢 Business Overview
The Coca-Cola Company is the world's largest non-alcoholic beverage company, founded in 1886 in Atlanta, Georgia. From a single syrup recipe, it has grown into a global franchise operating in over 200 countries with more than 200 master brands. KO does not manufacture or distribute beverages directly at scale — it operates an asset-light concentrate and syrup model, selling concentrates to an independent network of 300+ bottling partners who handle production and distribution.
The company underwent a major transformation in 2017–2019, refranchising its bottling operations globally and refocusing on brand ownership, innovation, and marketing. This dramatically improved margins, returns on capital, and cash generation. Today KO earns roughly 60% gross margins on concentrate sales — among the highest in consumer staples.
| Segment |
What It Does |
% Revenue |
Revenue ($B) |
YoY Growth |
Op. Margin |
| North America | US/Canada sparkling + stills | ~35% | ~$16.8B | ~3% | ~35% |
| International (EMEA, LatAm, Asia) | Concentrate sales globally | ~55% | ~$26.4B | ~2% | ~40% |
| Bottling Investments | Consolidated bottler operations | ~10% | ~$4.8B | ~1% | ~5% |
Key 2025 highlights: Organic revenue growth ~5%. Volume growth slight. Price/mix drove most of the lift. Currency headwinds were a ~4% drag on reported revenue. FY2025 net income surged to $13.1B (+23%) largely on improved operating leverage and lower restructuring charges vs 2024.
📊 Financial Snapshot
| Metric | 2021 | 2022 | 2023 | 2024 | 2025 |
|---|
| Revenue ($M) | $38,655 | $43,004 | $45,754 | $47,061 | $47,941 |
| EBITDA ($M) | $11,760 | $12,169 | $12,439 | $11,067 | $14,812 |
| Operating Income ($M) | $10,308 | $10,909 | $11,311 | $9,992 | $13,762 |
| Net Income ($M) | $9,771 | $9,542 | $10,714 | $10,631 | $13,107 |
| EPS (diluted) | $2.25 | $2.19 | $2.47 | $2.46 | $3.04 |
| Free Cash Flow ($M) | $11,258 | $9,534 | $9,747 | $4,741 | $5,296 |
| Annual DPS | $1.680 | $1.760 | $1.840 | $1.940 | $2.040 |
| Total Debt ($M) | — | — | — | — | — |
| Rev YoY Growth | — | +11.3% | +6.4% | +2.9% | +1.9% |
⚙️ Ke (DDM)
| Input | Value | Notes |
|---|
| Risk-Free Rate (Rf) | 4.35% | 10-yr US Treasury yield |
| Beta (β) | 0.550 | Market beta (Finnhub) |
| Equity Risk Premium (ERP) | 5.5% | Damodaran US ERP |
| Cost of Equity (Ke) | 7.50% | Ke = Rf + β × ERP |
📈 DDM Scenarios


📋 Full 10-Year Projection Tables
Bear Scenario
| Period | Stage | DPS / Dist. | PV of DPS | Cumulative IV |
|---|
| Year 1 | Stage 1 | $3.162 | $2.941 | $2.94 |
| Year 2 | Stage 1 | $3.288 | $2.845 | $5.79 |
| Year 3 | Stage 1 | $3.420 | $2.753 | $8.54 |
| Year 4 | Stage 1 | $3.556 | $2.663 | $11.20 |
| Year 5 | Stage 1 | $3.699 | $2.576 | $13.78 |
| Year 6 | Stage 2 | $3.810 | $2.468 | $16.25 |
| Year 7 | Stage 2 | $3.924 | $2.365 | $18.61 |
| Year 8 | Stage 2 | $4.042 | $2.266 | $20.88 |
| Year 9 | Stage 2 | $4.163 | $2.171 | $23.05 |
| Year 10 | Stage 2 | $4.288 | $2.080 | $25.13 |
| Terminal | — | TV=$79.52 | PV(TV)=$38.58 (61% of IV) | |
Base Scenario
| Period | Stage | DPS / Dist. | PV of DPS | Cumulative IV |
|---|
| Year 1 | Stage 1 | $3.253 | $3.026 | $3.03 |
| Year 2 | Stage 1 | $3.480 | $3.012 | $6.04 |
| Year 3 | Stage 1 | $3.724 | $2.998 | $9.04 |
| Year 4 | Stage 1 | $3.985 | $2.984 | $12.02 |
| Year 5 | Stage 1 | $4.264 | $2.970 | $14.99 |
| Year 6 | Stage 2 | $4.477 | $2.901 | $17.89 |
| Year 7 | Stage 2 | $4.701 | $2.833 | $20.72 |
| Year 8 | Stage 2 | $4.936 | $2.768 | $23.49 |
| Year 9 | Stage 2 | $5.183 | $2.703 | $26.19 |
| Year 10 | Stage 2 | $5.442 | $2.640 | $28.83 |
| Terminal | — | TV=$111.56 | PV(TV)=$54.13 (65% of IV) | |
Bull Scenario
| Period | Stage | DPS / Dist. | PV of DPS | Cumulative IV |
|---|
| Year 1 | Stage 1 | $3.344 | $3.111 | $3.11 |
| Year 2 | Stage 1 | $3.678 | $3.183 | $6.29 |
| Year 3 | Stage 1 | $4.046 | $3.257 | $9.55 |
| Year 4 | Stage 1 | $4.451 | $3.333 | $12.88 |
| Year 5 | Stage 1 | $4.896 | $3.410 | $16.29 |
| Year 6 | Stage 2 | $5.214 | $3.379 | $19.67 |
| Year 7 | Stage 2 | $5.553 | $3.347 | $23.02 |
| Year 8 | Stage 2 | $5.914 | $3.316 | $26.34 |
| Year 9 | Stage 2 | $6.298 | $3.285 | $29.62 |
| Year 10 | Stage 2 | $6.708 | $3.255 | $32.88 |
| Terminal | — | TV=$153.54 | PV(TV)=$74.49 (69% of IV) | |
🔲 Sensitivity Table
| Ke \ gT | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|
| 5.5% | $113 | $125 | $141 | $163 | $197 |
| 6.0% | $100 | $109 | $120 | $135 | $157 |
| 6.5% | $89 | $96 | $105 | $116 | $130 |
| 7.0% | $81 | $86 | $93 | $101 | $111 |
| 7.5% | $73 | $78 | $83 | $89 | $97 |
| 8.0% | $67 | $71 | $75 | $80 | $86 |
| 8.5% | $62 | $65 | $69 | $73 | $77 |
| 9.0% | $58 | $60 | $63 | $66 | $70 |
| 9.5% | $54 | $56 | $58 | $61 | $64 |
Green = >10% above current price. Red = >10% below. Gold = within ±10%.
📉 Long-Term Price Trend Channel
Log-linear trend fitted to full price history. ±1.5σ bands. Green shaded zone = bottom 25% of historical range — historically attractive entry.

🏦 Comparable Valuation
| Company | P/E | EV/EBITDA | Div Yield | DPS Growth 5Y | Growth Years |
|---|
| KO (Current) | 25.3x | 21.0x | 2.75% | 4.7% | 64 yrs |
| PEP (PepsiCo) | 20.4x | 14.5x | 3.50% | 7.0% | 52 yrs |
| MDLZ (Mondelez) | 18.5x | 13.2x | 3.00% | 13% | 5 yrs |
| HSY (Hershey) | 23.1x | 16.0x | 2.80% | 10% | 14 yrs |
| GIS (Gen Mills) | 14.8x | 11.5x | 4.20% | 4.5% | 8 yrs |
💰 Dividend / Distribution Analysis
| Metric | Value |
|---|
| Annual DPS | $2.120 |
| Current Yield | 2.75% |
| Consecutive Growth Years | 64 |
| 1-yr DPS CAGR | +5.2% |
| 3-yr DPS CAGR | +4.9% |
| 5-yr DPS CAGR | +4.7% |
| 10-yr DPS CAGR | +5.2% |
| Payout Ratio (DPS/EPS) | 67.8% |
| FCF Payout Ratio | 70.0% |
| Sustainability Verdict | ✅ Safe |
64-year Dividend King. Payout ratio 67.76% on EPS basis — healthy. FY2025 FCF was compressed ($5.3B) due to working capital build, not earnings impairment. Operating cash flow remains robust at $11.6B+. Dividend is well-covered and growth trajectory intact. Next ex-div: Mar 13, 2026 ($0.530/share). Annual DPS $2.12 on 3,418 shares = ~$7,247/yr portfolio income.

🔮 Analyst Forecast Section
(a) EPS Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|
| 2021 | $2.25 | — | — | — | Actual |
| 2022 | $2.19 | — | — | — | Actual |
| 2023 | $2.47 | — | — | — | Actual |
| 2024 | $2.46 | — | — | — | Actual |
| 2025 | $3.04 | — | — | — | Actual |
| 2026 | $3.15 | $3.33 | $3.42 | 30 | Estimate |
| 2027 | $3.31 | $3.57 | $3.68 | 29 | Estimate |
(b) Revenue Consensus
| Year | Low / Actual | Avg | High | # Analysts | Type |
|---|
| 2021 | $0.0B | — | — | — | Actual |
| 2022 | $0.0B | — | — | — | Actual |
| 2023 | $0.0B | — | — | — | Actual |
| 2024 | $0.0B | — | — | — | Actual |
| 2025 | $0.0B | — | — | — | Actual |
| 2026 | $0.0B | $0.1B | $0.1B | 30 | Estimate |
| 2027 | $0.0B | $0.1B | $0.1B | 29 | Estimate |
(c) Individual Analyst Price Targets
Consensus: Avg $82.92 | Range $70–$87
| Analyst | Firm | Rating | PT | Upside |
|---|
| Filippo Falorni | Citigroup | Strong Buy | $87 | +12.9% |
| Peter Grom | UBS | Strong Buy | $87 | +12.9% |
| Nik Modi | RBC Capital | Buy | $87 | +12.9% |
| Andrea Teixeira | JP Morgan | Buy | $83 | +7.7% |
| Lauren Lieberman | Barclays | Buy | $70 | -9.1% |
(d) Earnings Surprise History
| Quarter | EPS Act vs Est | EPS Beat/Miss | Rev Act vs Est | Rev Beat/Miss | Guidance |
|---|
| Q4 2025 | $0.55 vs $0.52 | +$0.03 ✅ | $0.0B vs $0.0B | +$0.0B ✅ | Maintained |
| Q3 2025 | $0.77 vs $0.74 | +$0.03 ✅ | $0.0B vs $0.0B | +$0.0B ✅ | Raised |
| Q2 2025 | $0.87 vs $0.84 | +$0.03 ✅ | $0.0B vs $0.0B | +$0.0B ✅ | Maintained |
| Q1 2025 | $0.73 vs $0.71 | +$0.02 ✅ | $0.0B vs $0.0B | +$0.0B ✅ | Raised |
(e) Confidence Band Commentary
KO has beaten EPS estimates in all 4 recent quarters, averaging a ~3-4% beat. Analyst estimate range is tight ($3.15–$3.42 for FY2026) — low uncertainty for such a large company, reflecting the predictable nature of the concentrate model. Currency remains the primary wildcard for estimate variability.


💡 Investment Thesis
Bull case: KO is the ultimate defensive compounder — 64 consecutive years of dividend growth, 60%+ gross margins, pricing power across all geographies, and an asset-light model that generates north of $11B in operating cash flow annually. As long-duration rates stabilize or decline, KO's dividend grows in value. Emerging market penetration (India, Africa, Southeast Asia) provides a multi-decade volume growth runway. The 2026 consensus implies ~9% EPS growth — execution on that trajectory justifies $83–87 prices.
Bear case: At $77, KO trades at 25x 2025 EPS — a premium to consumer staples peers. If US consumer softens, volumes disappoint, or the USD strengthens further (translating international profits back at worse rates), estimates compress. The real risk is not a dividend cut (extremely unlikely with 64 years of growth) — it's multiple compression. At 20x earnings, KO is worth ~$65. Currency is always a wildcard for a company earning 55%+ revenue internationally.
Key assumptions — Base case: DPS grows at 5% annually (consistent with 5-year CAGR), payout ratio stays ~65–70% as EPS grows ~9%, Ke of 7.65% (beta 0.60, standard CAPM). This produces a Base IV of ~$80–85, consistent with analyst consensus of $82.92.
Position view: At $77.04, KO trades at a modest ~7% discount to our Base IV and at the low end of analyst targets. It's fairly valued for its quality. The income investor is well-served at current prices — 2.75% yield on a 64-year grower is a premium income stream. Don't pay up, but don't sell either. Accumulate on any weakness below $72.
⚖️ DDM Verdict: Hold — The Coca-Cola Company (KO)
Current price: $77.04 | Analyst Avg PT: $82.92
| Tier | Price | Action |
|---|
| Tier 1 — Starter | ≤$72 | Begin position |
| Tier 2 — Add | ≤$68 | Add on weakness |
| Tier 3 — Full | ≤$64 | Full allocation |
| Sell Alert | ≥$88 | Above fair value — consider trimming |
Hold at current levels. Accumulate aggressively below $72.
- Current price $77.04 is ~7% below Base IV ($82.7) — modest discount, not a screaming buy
- Yield of 2.75% on a 64-year Dividend King is premium income — dividend is Safe
- Starter position: $72 (10% margin of safety to Base IV)
- Full conviction add: $68 (midpoint Bear/Base)
- Trim/reduce: Above $88 (near Bull IV, multiple looks stretched)
- Thesis breaks if: Dividend growth streak interrupted (extremely unlikely), or organic volume turns negative for 2+ consecutive years
KO is a portfolio anchor — a defensive, income-generating compounder that belongs in a high-yield family office. Don't trade around it. Let the dividend grow.
📂 Current Position Summary
| Metric | Value |
|---|
| Shares Held | 3,418.19 |
| Average Cost Basis | $62.29 |
| Current Market Value | $263,337 |
| Unrealized P&L | $+50,418 (+23.7%) |
| Annual Dividend Income | $7,247/yr |
| Yield on Cost | 3.40% |
| vs Target Position (~$200K) | $263,337 vs $200,000 (132% of target) |
Bore Family Office • Analysis generated by Lurch • Not investment advice.