# Constellation Brands (STZ) Financial Model Free Excel 3-statement financial model and company analysis for Constellation Brands. - Canonical: https://finamodel.com/companies/constellation-brands - Industry: Beverages - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/STZ.xlsx ## Model Purpose This model evaluates the equity valuation and cash flow generation of Constellation Brands, helping an analyst determine if the high-growth, high-margin Beer segment can generate sufficient free cash flow to fund massive Mexican brewery expansions and shareholder returns, despite the ongoing structural decline in the Wine & Spirits segment. ## Company Overview - Constellation Brands is a leading international producer and marketer of beer, wine, and spirits, primarily serving the United States market. - **Business segments**: Beer (approx. 83% of net sales) and Wine & Spirits (approx. 17% of net sales). - **Key geographies**: The vast majority of revenue is generated in the US, though all of its beer is produced in Mexico and imported. - **Business model type**: Asset-heavy manufacturing for beer (requiring massive, capital-intensive breweries in Mexico) combined with an asset-lighter, brand-driven CPG model for wine and spirits. - **Competitive position**: The #1 high-end beer supplier in the US; its Modelo Especial brand recently became the #1 selling beer brand in the US by dollar sales, taking market share from domestic incumbents. - **Recent major events**: A massive $1.5 to $2.5 billion non-cash goodwill impairment charge in the Wine & Spirits segment in FY2025; the divestiture of SVEDKA and other lower-end wine brands to focus on premiumisation; and the historical deconsolidation and write-downs of its investment in Canopy Growth Corporation. ## Revenue Deep Dive ### Beer - **Segment name**: Beer - **Revenue driver formula**: Shipment Volume (millions of 24-pack, 12-ounce case equivalents) × Average Net Sales per Case - **Historical growth rate**: 7% to 9% CAGR over the last 3 years. - **Key growth levers and headwinds**: Driven by the premiumisation trend and growing Hispanic demographics in the US. Headwinds include capacity constraints and potential cross-border tariff risks. - **Pricing dynamics**: Strong pricing power; the company typically takes 1% to 2% price increases annually to offset inflation. - **Revenue recognition notes**: Revenue is recognised upon shipment to distributors (Shipments), though the company closely tracks sales from distributors to retailers (Depletions) as a leading indicator of consumer demand. - **Seasonality**: Strongest in Q1 and Q2 (spring and summer months) due to higher beer consumption during warmer weather and holidays like Cinco de Mayo and the Fourth of July. ### Wine and Spirits - **Segment name**: Wine and Spirits - **Revenue driver formula**: Shipment Volume (millions of 9-liter case equivalents) × Average Net Sales per Case - **Historical growth rate**: Declining at (4)% to (9)% annually. - **Key growth levers and headwinds**: Headwinds include US wholesale destocking, consumer shifts away from wine, and lower mainstream brand demand. Levers include growth in the Direct-to-Consumer (DTC) channel and international markets. - **Pricing dynamics**: Highly competitive; pricing power is limited to the ultra-premium portfolio, while mainstream brands face heavy discounting. - **Revenue recognition notes**: Recognised upon shipment to wholesalers or direct to consumers. - **Seasonality**: Strongest in Q3 (autumn/winter) driven by holiday gifting and Thanksgiving/Christmas consumption. ## Cost Structure ### Variable Costs / COGS - **Line-by-line breakdown**: Raw materials (agricultural inputs like barley, hops, grapes), packaging (glass bottles, aluminium cans, cardboard), inbound and outbound freight, and manufacturing overhead. - **Gross margin range**: 49% to 51% consolidated. - **Key input costs and commodity exposures**: Highly exposed to aluminium, glass, natural gas, and logistics/freight costs from Mexico to the US. - **How COGS scales with revenue**: Step-function scaling. As new modular brewery capacity comes online in Mexico, depreciation and fixed manufacturing overhead increase in steps, temporarily pressuring gross margins until volume fills the new capacity. ### Operating Expenses - **R&D**: Immaterial for this business; product innovation is typically captured in marketing and general SG&A. - **SG&A**: Heavily weighted towards marketing and advertising. Marketing expense typically runs at 8% to 10% of net sales. General and administrative expenses are largely headcount and corporate IT driven. - **Depreciation & Amortisation**: High and growing as a % of revenue (approx. 4% to 5%) due to the multi-billion dollar brewery expansions in Nava, Obregón, and Veracruz. - **Stock-Based Compensation**: Moderate, typical for a mature CPG company (approx. 0.5% to 1.0% of revenue). - **Restructuring / one-time charges**: Frequent in recent years, particularly related to Wine & Spirits goodwill impairments ($1.5B+ in FY25) and losses on unconsolidated investments (Canopy Growth). ### Margin Profile - **Gross margin**: 49% to 51%. - **EBITDA margin**: 35% to 38%. - **Operating margin**: Beer segment operates at a highly lucrative 39% to 40% margin. Wine & Spirits operates at a 15% to 18% margin. Consolidated comparable operating margin sits around 32% to 33%. - **Margin trend**: Beer margins are stable to slightly expanding due to pricing and cost-efficiency initiatives, while Wine & Spirits margins have compressed significantly due to volume deleverage and unfavourable channel mix. ## Balance Sheet Structure - **Total assets**: Approximately $24 billion to $26 billion. - **Key asset categories**: Property, Plant, and Equipment (PP&E) is the largest tangible asset, representing the massive Mexican brewery infrastructure. - **Goodwill & intangibles**: Historically high (approx. 30% to 40% of assets) due to past acquisitions, though significantly reduced recently by the FY25 Wine & Spirits goodwill impairment. - **Working capital profile**: - **Days Sales Outstanding (DSO)**: 25 to 35 days. - **Days Inventory Outstanding (DIO)**: 60 to 80 days (wine requires aging, beer turns much faster). - **Days Payable Outstanding (DPO)**: 65 to 85 days. - **Net working capital as % of revenue**: Slightly positive to neutral. - **Is working capital positive or negative?**: The company operates with relatively tight working capital, using strong supplier terms to fund inventory, though wine aging requires structural inventory investment. - **PP&E**: Dominated by Mexican breweries. Useful lives for brewery equipment are typically 15 to 30 years. - **Right-of-use assets / operating leases**: Moderate, primarily related to corporate offices, warehouses, and some agricultural land. ## Capital Expenditure & Investment - **Capex as % of revenue**: 7% to 10% (highly elevated compared to asset-light peers). - **Maintenance capex vs. growth capex**: Roughly 20% maintenance, 80% growth. - **Major capex programmes underway**: The company is executing a $3 billion capital expenditure programme from FY2025 to FY2028 to build modular additions at existing facilities in Mexico (Nava and Obregón) and construct a third brewery site in Veracruz. - **Capitalised software / development costs**: Immaterial relative to hard asset capex. - **M&A pattern**: Historically a transformational acquirer (Grupo Modelo US rights), but currently focused on organic growth and divesting non-core, lower-end wine brands. ## Debt & Capital Structure - **Total debt**: Approximately $11 billion to $12 billion. - **Debt/EBITDA ratio**: Target net leverage ratio is approximately 3.0x. - **Credit rating**: Investment grade (BBB- / Baa3). - **Key debt instruments**: Senior notes, term loans, and a revolving credit facility. - **Maturity profile**: Well-laddered with average maturities in the 5 to 7 year range. - **Interest rate profile**: Predominantly fixed-rate senior notes. - **Covenants**: Standard investment-grade covenants; no restrictive financial maintenance covenants on the bonds. - **Share repurchase programme**: Highly active. The Board approved a new $4 billion share repurchase authorisation in April 2025. - **Dividend policy**: Quarterly dividend of $1.01 per share (approx. $4.04 annually), representing a yield of roughly 1.5% to 2.0%. ## Cash Flow Characteristics - **Operating cash flow conversion**: Strong; OCF typically exceeds $2.8 billion annually. - **Free cash flow margin**: 12% to 15% (depressed slightly by the heavy growth capex cycle). - **Major non-cash items**: Massive depreciation from breweries, stock-based compensation, and periodic non-cash impairment charges (e.g., Wine & Spirits goodwill). - **Working capital cash flow impact**: Generally a slight use of cash as the business grows, driven by inventory needs for expanded beer volumes. - **Capex intensity**: Very high for a CPG company due to the requirement to build physical breweries in Mexico to support US import growth. - **Cash tax rate vs. GAAP effective tax rate**: The effective tax rate is typically 18% to 20%, benefiting from foreign earnings taxed at lower rates (Mexican production). ## Sheet Structure 1. **Assumptions**: Hardcoded drivers for macro environment, segment volumes, pricing, margins, capex schedule, and WACC. 2. **Revenue & Volumes**: Detailed build of Beer shipments (24-pack equivalents), Wine & Spirits shipments (9-liter equivalents), and pricing per case. 3. **Income Statement**: Segment-level operating income (Beer vs. Wine & Spirits), corporate expense, interest, taxes, and comparable vs. reported EPS reconciliation. 4. **Balance Sheet**: Assets (PP&E schedule, Intangibles), Liabilities (Debt tranches), and Equity. 5. **Cash Flow Statement**: Operating cash flow, investing cash flow (heavy capex line), and financing cash flow (dividends and massive share repurchases). 6. **Debt & Interest Schedule**: Debt maturity ladder, revolver draw/paydown, and interest expense calculation. 7. **DCF Valuation**: Unlevered free cash flow build, terminal value calculation, and implied share price. ## Key Financial Relationships 1. `Beer Net Sales = Beer Shipment Volume (millions of 24-pack case equivalents) × Average Beer Price per Case` 2. `Wine and Spirits Net Sales = W&S Shipment Volume (millions of 9-liter case equivalents) × Average W&S Price per Case` 3. `Consolidated Net Sales = Beer Net Sales + Wine and Spirits Net Sales` 4. `Beer Operating Income = Beer Net Sales × Beer Operating Margin (target 39.0% - 40.0%)` 5. `Wine and Spirits Operating Income = Wine and Spirits Net Sales × Wine and Spirits Operating Margin (target 15.0% - 18.0%)` 6. `Consolidated Comparable Operating Income = Beer Operating Income + Wine and Spirits Operating Income - Corporate Expense` 7. `Depreciation Expense = Beginning PP&E × Blended Depreciation Rate (reflecting 15-30 year useful lives of breweries)` 8. `Free Cash Flow = Cash from Operations - Capital Expenditures` 9. `Ending Shares Outstanding = Beginning Shares Outstanding - (Share Repurchase Spend / Average Share Price)` 10. `Dividends Paid = Dividend per Share × Average Shares Outstanding` ## Cross-Sheet Dependencies - The **Revenue & Volumes** sheet is the primary engine, feeding Net Sales into the **Income Statement**. - Segment margins in the **Income Statement** generate Operating Income, which flows down to Net Income. - Net Income feeds the top of the **Cash Flow Statement** and Retained Earnings on the **Balance Sheet**. - The $3 billion FY25-FY28 Capex assumption in the **Assumptions** sheet drives Investing Cash Flow on the **Cash Flow Statement**, which in turn increases PP&E on the **Balance Sheet** and drives higher Depreciation on the **Income Statement**. - Share repurchases in the **Cash Flow Statement** reduce the share count in the **Assumptions** sheet, impacting EPS calculations on the **Income Statement**. Circularity risk exists in the interest expense calculation if the revolver is used to plug cash deficits. ## Sign Convention - **Revenues, Volumes, and Asset balances**: Positive. - **Expenses (COGS, SG&A, Interest, Taxes)**: Negative in the Income Statement build. - **Cash Outflows (Capex, Dividends, Share Repurchases, Debt Paydown)**: Negative on the Cash Flow Statement. - **Cash Inflows (Debt Issuance)**: Positive on the Cash Flow Statement. - **Margins and Growth Rates**: Positive or negative percentages as mathematically appropriate. ## Things Most Likely to Go Wrong - **Confusing Shipments vs. Depletions**: Revenue is strictly driven by Shipments (sales to distributors). Depletions (sales to retailers) are a health metric but do not directly multiply by price to equal GAAP revenue. - **Ignoring the FY25 Goodwill Impairment**: The model must separate "Reported" operating income (which includes the $1.5B-$2.5B non-cash impairment) from "Comparable" operating income to accurately forecast future cash flows. - **Underestimating Capex**: Constellation is in a massive, multi-year capacity expansion phase. Flat-lining historical capex will severely overstate Free Cash Flow. The model must force $750M to $1B in annual capex through FY28. - **Canopy Growth Noise**: Historical reported EPS is heavily distorted by equity losses and write-downs from Canopy Growth. The model must focus on the core beverage alcohol operations and exclude unconsolidated investment volatility. - **Unit Mismatch**: Beer is reported in 24-pack, 12-ounce case equivalents, while Wine & Spirits is reported in 9-liter case equivalents. Do not mix these volume metrics. - **Corporate Expense Allocation**: Segment operating income does not sum to consolidated operating income. The model must explicitly deduct unallocated Corporate Expense (historically ~$250M-$260M). - **Tariff Sensitivity**: Because 100% of the beer is brewed in Mexico and sold in the US, the model should ideally have a toggle for cross-border tariffs, which would immediately hit COGS. ## Validation Checks - **Beer Operating Margin**: Must remain between 38.0% and 40.5%. Flag if it drops below 38% without a corresponding massive increase in COGS. - **Consolidated Gross Margin**: Should hover tightly around 50.0%. - **Capex to Revenue**: Should be between 7.0% and 10.0% through FY28, dropping to ~5.0% thereafter once the Veracruz brewery is completed. - **Debt to EBITDA**: Net leverage should remain near the company's 3.0x target. Flag if it exceeds 3.5x. - **Balance Sheet Check**: Total Assets must exactly equal Total Liabilities + Equity in all forecast periods. - **Corporate Expense**: Should be hardcoded or grown slightly from the ~$260M baseline; it should not scale linearly with Beer revenue growth. - **Dividend Payout**: The annual dividend should equal approximately $4.04 per share, growing low-single digits annually. ## Key Assumptions (Default Values) | Assumption | Default Value | Unit | Rationale | |---|---|---|---| | Beer Volume Growth (Shipments) | 6.5 | % | Midpoint of recent historical trends and management's 6-8% net sales growth target. | | Beer Price/Mix Growth | 1.5 | % | Standard annual pricing action taken to offset inflation. | | Wine & Spirits Volume Growth | -5.0 | % | Reflects ongoing structural headwinds and wholesale destocking. | | Wine & Spirits Price/Mix Growth | 1.0 | % | Modest benefit from premiumisation and DTC channel mix. | | Beer Operating Margin | 39.5 | % | Aligns with management's target of approximately 39%. | | Wine & Spirits Operating Margin | 16.0 | % | Reflects recent margin compression due to volume deleverage. | | Corporate Expense | 260 | $ Millions | Based on management's explicit FY24/FY25 guidance. | | Annual Capital Expenditures | 850 | $ Millions | Blended annual run-rate to achieve the $3B target from FY25-FY28. | | Effective Tax Rate | 19.0 | % | Historical average benefiting from foreign production tax structures. | | Annual Dividend per Share | 4.04 | $ | Based on the recent $1.01 quarterly declaration. | | Share Repurchases | 1,000 | $ Millions | Run-rate based on the new $4B authorisation over 3-4 years. | | WACC | 7.5 | % | Standard discount rate for a large-cap, investment-grade consumer staples company. | | Terminal Growth Rate | 2.5 | % | Long-term GDP and population growth proxy for beverage alcohol. | ## Data Sources & Benchmarks - **SEC EDGAR**: Constellation Brands (STZ) 10-K, 10-Q, and 8-K filings (specifically the Q4 FY25 and Q1 FY25 earnings releases). - **Investor Relations**: Constellation Brands IR website (ir.cbrands.com) for earnings presentations and the Barclays Global Consumer Staples Conference slides. - **Key Peers**: Anheuser-Busch InBev (BUD), Molson Coors Beverage Company (TAP), Brown-Forman (BF.B), and Diageo plc (DEO). - **Industry Data**: Circana (formerly IRI) for US multi-outlet and convenience store (MULOC) retail scanner data on beer depletions and market share. ## Sources - Constellation Brands Q4 FY24 Earnings Release (SEC.gov) - Constellation Brands Q1 FY25 Earnings Release (SEC.gov) - Constellation Brands FY25 Financial Results & FY26-FY28 Outlook (SEC.gov) - Constellation Brands Updates Fiscal 2025 Outlook (cbrands.com) - Constellation Brands Q2 2025 Earnings Call Transcript (The Motley Fool) - Constellation Brands FY24 Annual Report (cbrands.com) --- ## Frequently asked questions ### What does Constellation Brands (STZ) do and what are its main products? Constellation Brands is a leading international producer and marketer of beer, wine, and spirits, primarily serving the United States market. Its business is dominated by its Beer segment, which accounts for approximately 83% of net sales, with the remaining 17% from Wine & Spirits. ### What drives Constellation Brands' revenue growth, particularly in its Beer segment? Constellation Brands' revenue growth is primarily driven by its high-growth Beer segment, particularly its premium brands like Modelo Especial, which recently became the #1 selling beer brand in the US by dollar sales. The company focuses on premiumization and market share gains in the high-end beer category. ### What is Constellation Brands' capital expenditure strategy and how does it impact its financial model? Constellation Brands has a highly elevated capital expenditure program, with capex as a percentage of revenue typically ranging from 7% to 10%. The company is currently executing a $3 billion program from FY2025-FY2028 to expand its Mexican brewery infrastructure, with roughly 80% of this being growth capex. ### How did the recent goodwill impairment impact Constellation Brands' balance sheet and valuation considerations? Constellation Brands recorded a massive $1.5 to $2.5 billion non-cash goodwill impairment charge in its Wine & Spirits segment in FY2025, significantly reducing its historically high goodwill and intangibles on the balance sheet. This event highlights the challenges in the Wine & Spirits segment and impacts future asset base assumptions for valuation. ### How does Constellation Brands manage its net working capital, and what is its typical profile? Constellation Brands operates with relatively tight working capital, often showing a slightly positive to neutral net working capital as a percentage of revenue. While strong supplier terms help fund inventory, the wine segment's aging requirements necessitate structural inventory investment. ### Can I download an Excel financial model for Constellation Brands (STZ) to analyze its future performance? Yes, an Excel financial model for Constellation Brands (STZ) is available for download, forecasting performance from FY2027 through FY2031. This model helps analysts evaluate the company's equity valuation and cash flow generation, considering key assumptions like revenue growth and capital expenditures. [Interactive forecast calculator](https://finamodel.com/companies/constellation-brands/forecast)