# Molson Coors Beverage (TAP) Financial Model Free Excel 3-statement financial model and company analysis for Molson Coors Beverage. - Canonical: https://finamodel.com/companies/molson-coors-beverage - Industry: Beverages - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/TAP.xlsx ## Model Purpose This model provides a comprehensive equity valuation and scenario planning tool for an analyst covering Molson Coors Beverage Company, focusing on the impact of portfolio premiumisation, structural volume declines, and cost-saving initiatives on free cash flow generation and capital allocation. ## Company Overview Molson Coors Beverage Company is a leading global brewer that manufactures, markets, and sells beer and other malt beverage products under brands such as Coors Light, Miller Lite, Molson Canadian, Carling, and Staropramen. The company is actively expanding its "Beyond Beer" portfolio with ready-to-drink cocktails, energy drinks, and non-alcoholic options to offset secular declines in traditional beer consumption. The business operates through two primary reporting segments: Americas (approximately 80% of net sales) and EMEA&APAC (approximately 20% of net sales). The Americas segment is heavily concentrated in the United States and Canada, while the EMEA&APAC segment is driven by the UK and Central Europe. Molson Coors operates an asset-heavy business model, owning massive brewing facilities and distribution infrastructure. Its competitive position is strong as part of a global oligopoly, ranking as the second-largest brewer in the US behind Anheuser-Busch InBev and competing closely with Constellation Brands and Heineken. Recent major events include a massive $3.65 billion non-cash partial goodwill impairment charge in 2025, the strategic wind-down of a major US contract brewing arrangement, and the announcement of a new $450 million three-year cost savings programme beginning in 2026. ## Revenue Deep Dive ### Americas - **Segment name**: Americas - **Revenue driver formula**: Americas Financial Volume (Hectolitres) x Americas Net Sales per Hectolitre - **Historical growth rate**: Declining low-to-mid single digits (-2% to -6% annually) - **Key growth levers and headwinds**: Headwinds include macroeconomic softness, secular shifts away from traditional domestic premium beer, and the termination of a major contract brewing agreement. Levers include portfolio premiumisation (increasing the mix of Above Premium brands like Blue Moon and Beyond Beer products) and aggressive net pricing actions. - **Pricing dynamics**: Highly competitive but historically rational oligopoly pricing; the company typically pushes 1% to 2% annual pricing increases, supplemented by positive brand mix. - **Revenue recognition notes**: Recognised upon delivery to independent distributors (the three-tier system in the US) or directly to retail customers, net of excise taxes and promotional discounts. - **Seasonality**: Strongest in the second and third quarters (summer months and major holidays), weakest in the first quarter. ### EMEA&APAC - **Segment name**: EMEA&APAC - **Revenue driver formula**: EMEA&APAC Financial Volume (Hectolitres) x EMEA&APAC Net Sales per Hectolitre - **Historical growth rate**: Flat to low single digits (0% to +3% annually) - **Key growth levers and headwinds**: Growth is driven by the rapid expansion of Madri Excepcional in the UK and pricing actions in Central Europe. Headwinds include European consumer weakness and unfavourable foreign exchange translation. - **Pricing dynamics**: Spot pricing heavily influenced by local inflation and excise tax changes, particularly in the UK and Central European markets. - **Revenue recognition notes**: Similar to the Americas, recognised net of excise taxes, which are substantial in European markets. - **Seasonality**: Highly seasonal, peaking in the European summer (Q2 and Q3). ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown**: Raw materials (barley, hops, corn, packaging materials like aluminium cans and glass bottles), manufacturing costs (labour, energy, water), and freight/logistics. - **Gross margin range**: 37% to 40% (TTM 2025 gross margin was approximately 38.7%). - **Key input costs and commodity exposures**: Aluminium is a massive exposure. The Midwest premium and aluminium inflation represent a quantified $125 million COGS headwind for 2026. - **How COGS scales with revenue**: Largely linear with volume (hectolitres), but suffers from volume deleverage when brewery utilisation drops. ### Operating Expenses - **R&D**: Negligible as a percentage of revenue; product development is absorbed into general corporate expenses. - **SG&A**: Reported as Marketing, General & Administrative (MG&A). Marketing is a massive component (historically 8% to 10% of sales) required to maintain brand equity. General and administrative expenses are largely headcount-driven. - **Depreciation & Amortisation**: Significant due to the asset-heavy brewing infrastructure, typically running at 5% to 6% of revenue. - **Stock-Based Compensation**: Relatively low compared to tech, typically under 0.5% of revenue. - **Restructuring / one-time charges**: Frequent. The company announced a $450 million cost savings programme starting in 2026, which will incur upfront severance and restructuring charges. ### Margin Profile - **Gross margin**: 37% to 40%. - **EBITDA margin**: 20% to 23%. - **Operating margin**: 14% to 16% on an underlying basis. - **Net margin**: Highly volatile on a GAAP basis due to impairments (e.g., -18.6% in 2025 due to a $3.65 billion goodwill write-down), but underlying net margin typically sits between 9% and 11%. - **Margin trend**: Gross margins are expanding slightly due to premiumisation, but operating margins face pressure from volume deleverage and MG&A investments, prompting the new cost savings programme. ## Balance Sheet Structure - **Total assets**: Approximately $25 billion to $28 billion. - **Key asset categories**: Property, Plant & Equipment (breweries) and massive Goodwill/Intangible assets stemming from the 2016 MillerCoors acquisition. - **Goodwill & intangibles as % of total assets**: Historically over 50%, though reduced significantly following the $3.65 billion partial goodwill impairment in 2025. - **Working capital profile**: - **Days Sales Outstanding (DSO)**: 22 to 25 days. - **Days Inventory Outstanding (DIO)**: 30 to 35 days. - **Days Payable Outstanding (DPO)**: 115 to 130 days. - **Net working capital as % of revenue**: Deeply negative. - **Is working capital positive or negative?**: Negative. The company uses its massive scale to stretch payables, funding its operations through the supply chain (a significant negative NWC advantage). - **PP&E**: Consists of brewing equipment, packaging lines, and real estate. Maintenance capex is high. - **Right-of-use assets / operating leases**: Material but secondary to owned PP&E. ## Capital Expenditure & Investment - **Capex as % of revenue**: 5.5% to 6.5%. - **Maintenance capex vs. growth capex**: Roughly 70% maintenance (brewery upkeep, efficiency upgrades) and 30% growth (flavour capabilities, Beyond Beer packaging lines). - **Major capex programmes underway or planned**: Investments in flavour production and packaging capabilities. 2026 capex guidance was reduced to $650 million from historical $750 million levels. - **Capitalised software / development costs if material**: Not a material driver. - **M&A pattern**: Historically transformational (MillerCoors, StarBev), but currently focused on bolt-on acquisitions and partnerships in the Beyond Beer space (e.g., ZOA Energy, Blue Run Spirits). - **Typical acquisition multiple paid**: Not applicable for recent bolt-ons, but historical mega-deals were done at 12x to 15x EBITDA. ## Debt & Capital Structure - **Total debt**: Approximately $6.2 billion, with net debt around $5.4 billion at year-end 2025. - **Debt/EBITDA ratio**: 2.33x at year-end 2025. The long-term target is strictly under 2.5x. - **Credit rating**: Investment grade (BBB-/Baa3). - **Key debt instruments**: Senior unsecured notes (bonds) in USD, EUR, and CAD, supported by a revolving credit facility. - **Maturity profile**: Well-laddered, with average maturities exceeding 5 years. - **Interest rate profile**: Predominantly fixed-rate bonds, insulating the company from short-term rate spikes. - **Covenants**: Standard leverage and interest coverage covenants on the revolver. - **Share repurchase programme**: Highly active. The board expanded the authorisation to $4.0 billion through December 2031, with $2.6 billion remaining at the end of 2025. - **Dividend policy**: Progressive policy. The company declared a $0.48 per share quarterly dividend in early 2026, representing a yield of approximately 3.5% to 4.0%. ## Cash Flow Characteristics - **Operating cash flow conversion**: Very strong, typically >1.2x underlying net income due to high depreciation and negative working capital dynamics. - **Free cash flow margin**: 9% to 11% (FCF was $1.14 billion in 2025 on $11.14 billion in revenue). - **Major non-cash items that bridge net income to OCF**: Depreciation and amortisation, massive periodic goodwill/intangible impairments, and deferred income taxes. - **Working capital cash flow impact**: Generally a source of cash during periods of stable or growing input costs due to extended DPO. - **Capex intensity**: Moderate to high (around $650 million annually). - **Cash tax rate vs. GAAP effective tax rate**: Cash taxes are often lower than the GAAP effective rate due to accelerated depreciation on brewing equipment. ## Sheet Structure 1. **Assumptions**: Hardcoded inputs for volume growth, pricing, margins, working capital days, and capital allocation. 2. **Summary**: Dashboard showing key metrics, target price, FCF yield, and leverage ratios. 3. **Revenue & Volume Build**: Detailed build of Financial Volume (HL) and Net Sales per HL for the Americas and EMEA&APAC segments. 4. **Income Statement**: Consolidated P&L mirroring the 10-K, separating COGS, MG&A, and special items (impairments). 5. **Working Capital**: Schedules for Accounts Receivable, Inventory, and Accounts Payable driven by DSO, DIO, and DPO. 6. **Capex & Depreciation**: PP&E roll-forward, capex projections, and D&A schedule. 7. **Debt & Interest**: Debt schedule detailing senior notes, revolver balance, interest expense, and leverage tracking. 8. **Balance Sheet**: Standard balancing statement. 9. **Cash Flow Statement**: Indirect method starting from Net Income, adjusting for non-cash items (specifically calling out impairments). 10. **Valuation**: DCF model and EV/EBITDA multiples valuation. ## Key Financial Relationships 1. `Americas Net Sales = Americas Financial Volume x Americas Net Sales per Hectolitre` 2. `EMEA&APAC Net Sales = EMEA&APAC Financial Volume x EMEA&APAC Net Sales per Hectolitre` 3. `Total Net Sales = Americas Net Sales + EMEA&APAC Net Sales` 4. `Total COGS = Total Financial Volume x Consolidated COGS per Hectolitre` 5. `Gross Profit = Total Net Sales - Total COGS` 6. `MG&A Expense = Total Net Sales x MG&A Margin %` 7. `Underlying Operating Income = Gross Profit - MG&A Expense` 8. `Accounts Receivable = (Total Net Sales / 365) x DSO` 9. `Inventory = (Total COGS / 365) x DIO` 10. `Accounts Payable = (Total COGS / 365) x DPO` 11. `Underlying EBITDA = Underlying Operating Income + Depreciation & Amortisation` 12. `Net Debt = Total Debt - Cash & Cash Equivalents` 13. `Leverage Ratio = Net Debt / Underlying EBITDA` 14. `Free Cash Flow = Operating Cash Flow - Capital Expenditures` ## Cross-Sheet Dependencies - The **Assumptions** sheet drives the **Revenue & Volume Build**, **Working Capital**, and **Capex & Depreciation** sheets. - **Revenue & Volume Build** feeds the top line of the **Income Statement**. - The **Income Statement** generates Net Income, which flows to the top of the **Cash Flow Statement** and into Retained Earnings on the **Balance Sheet**. - **Working Capital** changes flow directly into the Operating Cash Flow section of the **Cash Flow Statement**. - **Capex & Depreciation** feeds PP&E on the **Balance Sheet**, D&A on the **Income Statement**, and Investing Cash Flow on the **Cash Flow Statement**. - **Debt & Interest** creates a circularity: Interest Expense reduces Net Income, which reduces Cash Flow, which dictates the need for Revolver borrowing, which in turn changes the Interest Expense. This requires a toggle switch to break the circular reference. ## Sign Convention - Revenue and volume figures are entered as positive numbers. - Expenses (COGS, MG&A, Interest, Taxes) are entered as positive numbers in their respective schedules but subtracted in the Income Statement calculations. - Capital expenditures are entered as positive numbers in the Capex schedule but subtracted in the Cash Flow Statement. - On the Balance Sheet, Assets are positive, Liabilities and Equity are positive. - In the Cash Flow Statement, cash inflows are positive, and cash outflows are negative. ## Things Most Likely to Go Wrong - Failing to strip out the massive $3.65 billion non-cash goodwill impairment from 2025 when calculating historical margins; the model must use Underlying (Non-GAAP) figures for forecasting. - Mismodelling the volume decline in the Americas segment by ignoring the wind-down of the contract brewing arrangement, which artificially depressed 2024 and 2025 volumes but will not repeat indefinitely. - Underestimating the impact of aluminium pricing on COGS; the model must account for the specific $125 million headwind guided for 2026. - Miscalculating the cash conversion cycle. Molson Coors relies heavily on extended payables (DPO > 120 days). If DPO is modelled too low, the model will incorrectly forecast a massive cash drain. - Ignoring foreign exchange translation. The EMEA&APAC segment reports in USD but operates in GBP, EUR, and CZK. The model should ideally forecast in constant currency and apply an FX overlay. - Overestimating capex. Management explicitly reduced 2026 capex guidance to $650 million from historical $750 million levels. - Double-counting the $450 million cost savings programme. These savings will phase in over three years (2026-2028) and should be modelled as a gradual reduction in COGS per HL and MG&A as a percentage of sales. - Forgetting to deduct the substantial dividend payments before calculating cash available for the $4.0 billion share repurchase programme. ## Validation Checks - "Gross margin should remain in the 37% to 40% range; flag if outside this band." - "Net Debt to Underlying EBITDA must remain below 2.5x per management's stated long-term target." - "Free Cash Flow should consistently exceed $1.0 billion annually based on historical cash conversion." - "DPO must remain above 110 days; the company structurally relies on supplier financing." - "Capex should equal exactly $650 million in 2026 per management guidance." - "Total Americas volume should not grow in the near term; flag if the model implies positive volume growth before 2028." - "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every forecasted period." - "Dividend payout ratio should remain sustainable (typically 30% to 40% of underlying net income)." ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Americas Volume Growth | -3.0 | % | Reflects ongoing industry softness and secular decline in domestic premium beer. | | Americas Net Sales per HL Growth | 2.5 | % | Driven by premiumisation mix and standard 1-2% pricing increases. | | EMEA&APAC Volume Growth | -1.0 | % | Reflects weak European consumer environment offset slightly by Madri growth. | | EMEA&APAC Net Sales per HL Growth | 3.0 | % | Driven by pricing actions to offset local inflation. | | COGS per HL Growth | 3.5 | % | Captures the $125M aluminium/Midwest premium headwind guided for 2026. | | MG&A as % of Net Sales | 23.5 | % | Historical average, adjusted slightly downward in outer years for the cost savings programme. | | DSO (Days Sales Outstanding) | 24 | Days | Based on 2024/2025 historical averages. | | DIO (Days Inventory Outstanding) | 32 | Days | Based on 2024/2025 historical averages. | | DPO (Days Payable Outstanding) | 125 | Days | Reflects the company's aggressive supplier payment terms. | | Capital Expenditures (2026) | 650 | $ Millions | Explicit management guidance for 2026. | | Effective Tax Rate (Underlying) | 22.0 | % | Standard corporate rate adjusted for international mix. | | Share Repurchases (Annual) | 400 | $ Millions | Run-rate assumption based on the new $4.0B authorisation through 2031. | | Dividend per Share (Annual) | 1.92 | $ | Based on the $0.48 quarterly dividend declared in early 2026. | | Cost of Debt | 4.5 | % | Weighted average interest rate on existing senior notes. | | WACC | 7.5 | % | Standard discount rate for a mature, low-growth consumer staples company. | | Terminal Growth Rate | 0.5 | % | Reflects mature industry dynamics and secular volume headwinds. | ## Data Sources & Benchmarks - **Filings**: SEC EDGAR (Form 10-K, 10-Q, 8-K) and the Molson Coors Investor Relations website (ir.molsoncoors.com). - **Key Peers**: Anheuser-Busch InBev (BUD), Heineken N.V. (HEIA), Constellation Brands (STZ), and Keurig Dr Pepper (KDP). - **Industry Data**: Beer Institute (US volume data), NielsenIQ / Circana (off-premise scanner data for market share tracking). - **Consensus Estimates**: FactSet or Bloomberg for forward-looking EPS and revenue consensus. - **Proprietary Data**: GlobalData for international beer volume trends, and commodity pricing curves (specifically the CME Midwest Aluminium Premium) to forecast COGS pressures. ## Sources - Molson Coors Beverage Company SEC Filings (10-K for FY2024 and FY2025). - Molson Coors Q4 2025 Earnings Release and Investor Presentation. - TradingView News and StockTitan Event Summaries. - DCFmodeling.com Margin Analysis. - MarketBeat Financials and Working Capital Metrics. --- ## Frequently asked questions ### What does Molson Coors Beverage Company do? Molson Coors Beverage Company is a leading global brewer that manufactures, markets, and sells beer and other malt beverage products under brands such as Coors Light and Miller Lite. The company is also actively expanding its "Beyond Beer" portfolio with ready-to-drink cocktails, energy drinks, and non-alcoholic options. ### How does Molson Coors generate revenue? Molson Coors generates revenue primarily through the sale of its diverse portfolio of beer and malt beverages across its Americas and EMEA&APAC segments. The company is strategically focusing on portfolio premiumisation and expanding its "Beyond Beer" offerings to drive future growth and offset traditional beer consumption declines. ### What are the key assumptions in the Molson Coors financial model? Key assumptions in the Molson Coors financial model include an annual revenue growth rate of approximately 1.64% and a COGS as a percentage of revenue around 51.41%. Additionally, Selling, General & Administrative expenses are modeled at about 20.55% of revenue, and the tax rate is assumed to be 21%. ### What is Molson Coors' capital expenditure strategy? Molson Coors' capital expenditure is primarily focused on maintenance, accounting for roughly 70% of total capex for brewery upkeep and efficiency upgrades. The remaining 30% is allocated to growth initiatives, specifically investments in flavour production and packaging capabilities for its "Beyond Beer" portfolio. ### What is the purpose of the Molson Coors financial model? The Molson Coors financial model serves as a comprehensive tool for equity valuation and scenario planning for analysts. It focuses on assessing the impact of portfolio premiumisation, structural volume declines, and cost-saving initiatives on free cash flow generation and capital allocation. ### Can I download an Excel financial model for Molson Coors? Yes, an Excel financial model for Molson Coors Beverage Company is available for download. This general corporate model provides a forecast horizon from FY2026 to FY2030, offering detailed financial projections for analysis. [Interactive forecast calculator](https://finamodel.com/companies/molson-coors-beverage/forecast)