Deal Lab · Buyout model 1.0
The Coca-Cola Company Buyout Model
A buyout of The Coca-Cola Company on its published figures for the last 4 quarters to Q3 FY2026, in US dollars: revenue flat, the margin and the shares of revenue of that period, entry and exit at 10.0x EBITDA, exit after 5 years.
Returns
Internal rate of return
5.1%
Multiple of money
1.28x
Sponsor's equity
$87.7bn
Enterprise value
$168bn
Proceeds at exit
$112bn
Sources and Uses
| Uses | Amount |
|---|---|
| Equity price | $136bn |
| Borrowings refinanced | $41.5bn |
| Transaction costs | $3.4bn |
| Financing fees | $1.6bn |
| Minimum cash | $1.0bn |
| Uses | $183bn |
| Sources | Amount |
|---|---|
| Senior loan | $61.6bn |
| Subordinated notes | $20.5bn |
| Cash of the company | $13.5bn |
| Sponsor's equity | $87.7bn |
| Sources | $183bn |
Projection
| Closing | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
|---|---|---|---|---|---|---|
| Revenue | $51.1bn | $51.1bn | $51.1bn | $51.1bn | $51.1bn | $51.1bn |
| EBITDA of the case | $16.8bn | $16.8bn | $16.8bn | $16.8bn | $16.8bn | $16.8bn |
| Cash cost of leases | $405m | $405m | $405m | $405m | $405m | $405m |
| Depreciation and amortisation | $1.0bn | $1.0bn | $1.0bn | $1.0bn | $1.0bn | |
| Capital expenditure | $2.2bn | $2.2bn | $2.2bn | $2.2bn | $2.2bn | |
| Increase in working capital | $0 | $0 | $0 | $0 | $0 | |
| Interest | $6.6bn | $6.2bn | $5.8bn | $5.3bn | $4.9bn | |
| Tax | $2.2bn | $2.3bn | $2.4bn | $2.6bn | $2.7bn | |
| Cash available for debt service | $11.9bn | $11.8bn | $11.7bn | $11.6bn | $11.4bn |
Debt Schedule
| Closing | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
|---|---|---|---|---|---|---|
| Senior loan | $61.6bn | $56.3bn | $50.6bn | $44.7bn | $38.5bn | $31.9bn |
| Subordinated notes | $20.5bn | $20.5bn | $20.5bn | $20.5bn | $20.5bn | $20.5bn |
| Revolving facility | $0 | $0 | $0 | $0 | $0 | $0 |
| Cash | $1.0bn | $1.0bn | $1.0bn | $1.0bn | $1.0bn | $1.0bn |
| Debt to EBITDA | 5.00x | 4.68x | 4.35x | 4.00x | 3.62x | 3.23x |
| EBITDA to interest | 2.55x | 2.71x | 2.91x | 3.15x | 3.44x |
Covenants and the Credit View
| Closing | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
|---|---|---|---|---|---|---|
| Limit of debt to EBITDA | 6.50x | |||||
| Lease-adjusted debt to EBITDA | 5.00x | 4.68x | 4.35x | 4.00x | 3.62x | 3.23x |
| Band of debt to EBITDA | Highly leveraged | Aggressive | Aggressive | Significant | Significant | Significant |
Return Bridge
| Amount | |
|---|---|
| Sponsor's equity | $87.7bn |
| EBITDA growth | $0 |
| Change of multiple | $0 |
| Net debt repaid | +$29.6bn |
| Non-controlling interests | $0 |
| Costs at closing | −$5.0bn |
| Management and limited liability | $0 |
| Proceeds at exit | $112bn |
Sensitivity Tables
| Entry by exit | 8.00x | 9.00x | 10.0x | 11.0x | 12.0x |
|---|---|---|---|---|---|
| 8.00x | 8.0% | 12.0% | 15.5% | 18.7% | 21.5% |
| 9.00x | 2.2% | 6.2% | 9.7% | 12.8% | 15.6% |
| 10.0x | −2.1% | 1.7% | 5.1% | 8.0% | 10.7% |
| 11.0x | −5.5% | −1.8% | 1.4% | 4.3% | 6.8% |
| 12.0x | −8.4% | −4.7% | −1.6% | 1.2% | 3.7% |
| Debt by growth | −4.0% | −2.0% | 0.0% | 2.0% | 4.0% |
|---|---|---|---|---|---|
| 4.00x | −1.5% | 2.0% | 5.3% | 8.4% | 11.5% |
| 4.50x | −2.4% | 1.6% | 5.2% | 8.6% | 11.9% |
| 5.00x | −3.3% | 1.1% | 5.1% | 8.8% | 12.3% |
| 5.50x | −4.6% | 0.4% | 4.9% | 9.1% | 12.9% |
| 6.00x | −6.2% | −0.3% | 4.8% | 9.4% | 13.6% |
Solvers
Highest entry multiple for a return of 20.0%
4.03x
The target return
Revenue growth a year for a return of 20.0%
8.7%
The target return
Debt capacity at closing, times EBITDA
6.00x
The loan to value limit
Assumptions and Their Origins
| Group | Assumption | Value | Origin |
|---|---|---|---|
| Transaction | Entry multiple | 10.0x | Convention of buyout 1.0 |
| Transaction | Years to exit | 5 years | Convention of buyout 1.0 |
| Transaction | Transaction costs | 2.0% | Convention of buyout 1.0 |
| Transaction | Financing fees | 2.0% | Convention of buyout 1.0 |
| Transaction | Minimum cash, of revenue | 2.0% | Convention of buyout 1.0 |
| Financing | Debt at closing, times EBITDA | 5.00x | Convention of buyout 1.0 |
| Financing | Debt at most, of the enterprise value | 60.0% | Convention of buyout 1.0 |
| Financing | Senior loan, of the new debt | 75.0% | Convention of buyout 1.0 |
| Financing | Senior loan repaid each year | 1.0% | Convention of buyout 1.0 |
| Financing | Cash sweep | 100% | Convention of buyout 1.0 |
| Financing | Revolving facility, times EBITDA | 1.00x | Convention of buyout 1.0 |
| Financing | Base rate | 3.9% | Policy rate of the United States, BIS central bank policy rates, 27 October 2026 |
| Financing | Senior loan spread | 3.5% | Convention of buyout 1.0 |
| Financing | Subordinated notes spread | 6.0% | Convention of buyout 1.0 |
| Financing | Revolving facility spread | 3.0% | Convention of buyout 1.0 |
| Financing | Covenant headroom on debt to EBITDA | 30.0% | Convention of buyout 1.0 |
| Financing | Minimum EBITDA to interest | 2.00x | Convention of buyout 1.0 |
| Operations | Revenue growth a year | 0.0% | Convention of buyout 1.0 |
| Operations | EBITDA margin | 32.8% | EBITDA over revenue, last 4 quarters to FY2026 Q3 |
| Operations | Cash cost of leases, of revenue | 0.8% | Cash cost of leases over revenue, last 4 quarters to FY2026 Q3 |
| Operations | Depreciation and amortisation, of revenue | 2.0% | Depreciation and amortisation over revenue, last 4 quarters to FY2026 Q3 |
| Operations | Capital expenditure, of revenue | 4.4% | Median capital expenditure over revenue, fiscal 2023 to 2025 |
| Operations | Working capital, of revenue | −15.0% | Working capital over revenue, end of the last 4 quarters to FY2026 Q3 |
| Operations | Leases as debt | Yes | Leases as debt, the basis of the credit metrics |
| Operations | Share-based pay added back | No | Convention of buyout 1.0 |
| Taxes | Tax rate | 25.5% | Combined statutory rate of corporate income tax of the United States, OECD Corporate Tax Statistics, 2026 |
| Taxes | Interest deducted up to 30% of EBITDA | No | Convention of buyout 1.0 |
| Exit | Exit multiple | 10.0x | Convention of buyout 1.0 |
| Exit | Management share of the proceeds | 0.0% | Convention of buyout 1.0 |
| Exit | Target return | 20.0% | Convention of buyout 1.0 |
Inputs and Their Documents
Published figures of the last 4 quarters to Q3 FY2026, each with the documents it comes from.
| Input | Value | Method | Documents |
|---|---|---|---|
| Adjusted EBITDA | $17.0bn est. | Adjusted EBITDA of the company page | 10-K 2025-12, 10-Q 2025-09, 10-Q 2026-04, 10-Q 2026-07, 10-Q 2026-10 |
| Share-based pay | $269m | Share-based pay that adjusted EBITDA adds back | 10-K 2025-12, 10-Q 2025-09, 10-Q 2026-04, 10-Q 2026-07, 10-Q 2026-10 |
| EBITDA after share-based pay | $16.8bn est. | Adjusted EBITDA less share-based pay | 10-K 2025-12, 10-Q 2025-09, 10-Q 2026-04, 10-Q 2026-07, 10-Q 2026-10 |
| Depreciation and amortisation | $1.0bn | Depreciation and amortisation of adjusted EBITDA | 10-K 2025-12, 10-Q 2025-09, 10-Q 2026-04, 10-Q 2026-07, 10-Q 2026-10 |
| Revenue | $51.1bn | Revenue of the base period | 10-K 2025-12, 10-Q 2025-09, 10-Q 2026-04, 10-Q 2026-07, 10-Q 2026-10 |
| Operating lease cost | $405m est. | Operating lease cost | 10-K 2025-12 |
| Borrowings | $41.5bn | Total debt less lease liabilities | 10-K 2025-12, 10-Q 2026-10 |
| Lease liabilities | $1.7bn est. | Lease liabilities | 10-K 2025-12 |
| Cash and short-term investments | $13.5bn | Cash and short-term investments | 10-Q 2026-10 |
| Non-controlling interests | $2.2bn | Non-controlling interests | 10-Q 2026-10 |
| Receivables | $3.6bn | Receivables | 10-Q 2026-10 |
| Payables | $15.6bn | Payables | 10-Q 2026-10 |
| Inventories | $4.4bn | Inventories | 10-Q 2026-10 |
| Capital expenditure | $2.1bn | Capital expenditure of the latest fiscal year | 10-K 2025-12 |
Checks of the Model
- Sources equal uses
- The equity price is above nil
- The sponsor's equity is above nil
- Each balance of debt stays between nil and its amount at closing
- Cash is the cash of the year before and the cash flow of the year
- Cash stays at the minimum unless a shortfall is stated
- The 6 parts of the bridge add up to the proceeds less the sponsor's equity
- The cash flows at the internal rate of return have a present value of nil
Deal Lab computes arithmetic on published figures and on the assumptions of the user. It values no company, recommends no transaction and forecasts no result.