← The Coca-Cola Company

KO · Forward model

Revenue by vertical, 20 quarters out

Model as of

Each segment is projected from its own operating driver, rolled up into consolidated cash flow, and discounted back to a fair value per share. The assumptions below are editable — change them and every number on this page moves with them.

Six verticals on third-party (external) segment revenue. That choice is deliberate: third-party segment revenue sums to consolidated net operating revenues exactly, whereas total segment revenue would need a -$252M eliminations plug. Segment EBITDA margins are therefore struck on third-party revenue so that revenue times margin returns the right EBITDA dollars, and the check holds at the basis quarter - segment EBITDA of $5,178M less the $240M Corporate EBITDA drag is $4,938M, which is reported operating income of $4,672M plus $266M of depreciation and amortisation. History runs ten quarters, 2024 Q1 to 2026 Q2. Eight of those are the two complete calendar-year windows the seasonal factors are fitted on; the 2024 Q4 and 2025 Q4 points in every vertical are derived as full year less nine months and are flagged estimated. Twelve quarters do not exist and never will: Global Ventures was sunset on 1 January 2025 and only 2024 was recast, so the 2023 quarters survive only on the superseded six-segment basis. Two disclosed facts drive the near path and both are modelled explicitly. Coca-Cola's quarters end on a Friday while its year ends on 31 December, so 2026 Q1 carried six more days than 2025 Q1 and 2026 Q4 will carry six fewer than 2025 Q4; every seasonal factor here was fitted on revenue per day for that reason, which also means a fixed four-factor vector cannot track a day count that rotates year to year and about 1.5% of unmodelled quarterly error remains. And the African bottling operations, under definitive agreement to Coca-Cola HBC with closing expected by the end of 2026, are carried as a -74% level step on Bottling Investments dated to the second projected quarter, removing about $1,127M a quarter. Coca-Cola does not disclose that business's standalone revenue; that figure is the average of two independent derivations bounding it between $1.0bn and $1.4bn, it is assumed, and the bear and bull cases sit at the two ends of that range. What is deliberately absent: the IRS litigation, whose potential impact the company puts at $14.0bn with $6.0bn already on deposit and a $529M recorded estimate, is a contingency rather than an operating driver and is not modelled as a margin or growth effect anywhere in this spec. Free cash flow here is EBITDA less capital expenditure less tax on that difference, the engine's uniform definition; it carries no interest expense and no working capital, so it is not comparable with the company's approximately $12.4bn free cash flow guidance and should not be read against it. One tension is worth stating rather than tuning away. Every driver here is the segment's own 2024 Q2 to 2026 Q2 compound quarterly rate, not a guided quarter, so the base path puts 2026 Q3 at $13.39bn, up 7.5% year over year - ahead of what the company's own third-quarter considerations (about a point of currency tailwind against about a point of acquisitions-and-divestitures headwind, on top of organic growth) would imply. The two-year rate was kept because one guided quarter is a worse estimator of a five-year path than eight quarters of segment history; the gap is real and it is the first thing the 2026 Q3 print will test.

KO REVENUE MODEL

Latest: $14.63B (2031Q2E)

Period Value
2024Q1 $11.30B
2024Q2 $12.36B
2024Q3 $11.85B
2024Q4 $11.54B
2025Q1 $11.13B
2025Q2 $12.54B
2025Q3 $12.46B
2025Q4 $11.82B
2026Q1 $12.47B
2026Q2 $13.38B
2026Q3E $13.38B
2026Q4E $11.15B
2027Q1E $11.54B
2027Q2E $12.77B
2027Q3E $12.76B
2027Q4E $11.59B
2028Q1E $11.98B
2028Q2E $13.24B
2028Q3E $13.23B
2028Q4E $12.01B
2029Q1E $12.40B
2029Q2E $13.70B
2029Q3E $13.69B
2029Q4E $12.42B
2030Q1E $12.82B
2030Q2E $14.16B
2030Q3E $14.14B
2030Q4E $12.84B
2031Q1E $13.24B
2031Q2E $14.63B
Scenarios

Where each case comes from

Bear case — primary sources

The primary sources this case is built from — filings, calls and posts. Where they are claims by an interested party rather than disclosures, every number in the Bear column is what happens if they are taken at face value.

Braun case — primary sources

The primary sources this case is built from — filings, calls and posts. Where they are claims by an interested party rather than disclosures, every number in the Braun column is what happens if they are taken at face value.

Valuation

From cash flow to fair value

The published model, discounted at 8.0% a year with an exit multiple of 21.0x on EBITDA. The horizon and sliders above do not change this walk.

Present value of free cash flow, 20 quarters$61.68B
Terminal-year revenue$54.85B
Terminal-year EBITDA$21.73B
Exit multiple, on EBITDA21.0x
Terminal value$456.35B
Discounted at 8.0% a year, terminal value becomes$310.58B
Share of enterprise value from the terminal83%
Enterprise value$372.27B
Net cash−$27.17B
Equity value$345.09B
Shares4.30B
Fair value per share$80.21
Against the deployed price of $86.08, as of −7%

At $90.08 and $27.17bn of net debt the enterprise is worth $414.7bn, which is 24.2 times trailing EBITDA once the $1,274M African bottling charge is added back, and 26.1 times without that adjustment. The 21.0x exit is three turns below the adjusted figure: a mature staple should not be assumed to hold a peak multiple five years out. PepsiCo's 12.5x is not the target - that is a business-model gap between a concentrate licensor and a consolidated snacks and bottling group, not a mispricing - and the answer here is more sensitive to this multiple than to any operating assumption in the spec.

Read the other way round: at $86.08 the market is paying 22.7x terminal-year EBITDA, holding every other assumption on this page fixed. That is the number to argue about.

Capital programmes

Capex outside the verticals

Each vertical's capex is a share of its own revenue, which is the right shape for capacity that scales with sales. These are not that: fixed-size programmes with their own schedule that spend whether or not any segment grows. They are added on top, and they are why free cash flow dips in the years below.

Corporate capital expenditure

2026 Q3 → 2031 Q2
Programme total$2.02B
Cash out$101M/qtr

The $101M of capital expenditure disclosed against the Corporate reconciling line in 2026 Q2, held flat across the horizon. It is carried here rather than inside a vertical because it belongs to none of them: as a percentage of the $37M of Corporate third-party revenue it would be 273%, an artefact of the denominator. This is not an invented programme - it is a disclosed quarterly outlay given a shape the engine can carry.

Quarter by quarter

The projected path

The published model's 20 quarters. The horizon and sliders above do not change this table.

Quarter Europe, Middle East & AfricaLatin AmericaNorth AmericaAsia PacificBottling InvestmentsCorporate Revenue YoY EBITDA Capex FCF R40 PV of FCF
2026 Q3E $2.84B$1.86B$5.69B$1.43B$1.52B$37M $13.38B +7% $4.92B $424M $3.60B +34 $3.53B
2026 Q4E $2.52B$1.89B$5.16B$1.15B$396M$38M $11.15B −6% $4.40B $334M $3.25B +23 $3.13B
2027 Q1E $2.74B$1.91B$5.03B$1.43B$396M$38M $11.54B −7% $4.58B $333M $3.40B +22 $3.21B
2027 Q2E $3.19B$1.93B$5.68B$1.53B$395M$38M $12.77B −5% $5.04B $361M $3.75B +25 $3.47B
2027 Q3E $2.94B$1.96B$5.96B$1.47B$395M$38M $12.76B −5% $5.01B $367M $3.72B +24 $3.38B
2027 Q4E $2.59B$1.98B$5.40B$1.19B$395M$38M $11.59B +4% $4.58B $343M $3.39B +33 $3.02B
2028 Q1E $2.82B$2.00B$5.26B$1.47B$395M$39M $11.98B +4% $4.76B $341M $3.54B +33 $3.10B
2028 Q2E $3.29B$2.02B$5.92B$1.58B$395M$39M $13.24B +4% $5.23B $371M $3.89B +33 $3.34B
2028 Q3E $3.02B$2.04B$6.22B$1.52B$395M$39M $13.23B +4% $5.20B $376M $3.86B +33 $3.25B
2028 Q4E $2.67B$2.06B$5.63B$1.23B$395M$39M $12.01B +4% $4.75B $351M $3.52B +33 $2.91B
2029 Q1E $2.90B$2.08B$5.47B$1.52B$395M$40M $12.40B +4% $4.94B $350M $3.68B +33 $2.97B
2029 Q2E $3.37B$2.10B$6.16B$1.64B$395M$40M $13.70B +3% $5.42B $380M $4.04B +33 $3.20B
2029 Q3E $3.10B$2.12B$6.46B$1.57B$395M$40M $13.69B +3% $5.39B $386M $4.00B +33 $3.12B
2029 Q4E $2.74B$2.14B$5.85B$1.27B$395M$40M $12.42B +3% $4.92B $360M $3.65B +33 $2.79B
2030 Q1E $2.97B$2.16B$5.68B$1.57B$395M$40M $12.82B +3% $5.11B $358M $3.81B +33 $2.85B
2030 Q2E $3.46B$2.18B$6.40B$1.69B$395M$41M $14.16B +3% $5.61B $389M $4.18B +33 $3.07B
2030 Q3E $3.18B$2.20B$6.71B$1.62B$395M$41M $14.14B +3% $5.57B $395M $4.15B +33 $2.99B
2030 Q4E $2.81B$2.22B$6.07B$1.31B$395M$41M $12.84B +3% $5.09B $368M $3.78B +33 $2.67B
2031 Q1E $3.05B$2.24B$5.90B$1.62B$395M$41M $13.24B +3% $5.28B $366M $3.94B +33 $2.73B
2031 Q2E $3.55B$2.26B$6.64B$1.74B$395M$41M $14.63B +3% $5.79B $398M $4.32B +33 $2.94B

Every row is projected. A year-over-year change is shown only where the quarter it compares against exists — an em dash means there is no comparable quarter, not a flat year.

Track record

Model revisions

Assumptions are marked to reality as each quarter prints. Every change is appended here, with the fair value the model produced at the time, so the model's own history stays visible.

DateFair value thenNote
2026-08-27 $80.21 First published model, built from the verified 2026 Q2 research brief. Six third-party revenue lines - the five reportable segments plus the Corporate reconciling line - which sum to reported consolidated revenue in all ten historical quarters with no elimination plug. Day-normalised seasonality on EMEA, North America and Asia Pacific; the other three verticals left aseasonal on the evidence. The African bottling deconsolidation is a dated level step on Bottling Investments rather than a growth rate.