Molson Coors Beverage Company (TAP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Molson Coors Beverage Company (TAP) Bundle
Streamline your analysis and improve precision with our (TAP) DCF Calculator! Utilizing up-to-date Molson Coors Beverage Company data and customizable assumptions, this tool empowers you to forecast, analyze, and assess (TAP) like a seasoned investor.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 10,579.4 | 9,654.0 | 10,279.7 | 10,701.0 | 11,702.1 | 12,029.4 | 12,365.8 | 12,711.7 | 13,067.2 | 13,432.7 |
| Revenue Growth, % | 0 | -8.75 | 6.48 | 4.1 | 9.36 | 2.8 | 2.8 | 2.8 | 2.8 | 2.8 |
| EBITDA | 1,640.3 | 564.0 | 2,286.7 | 1,814.4 | 2,164.1 | 1,901.6 | 1,954.8 | 2,009.5 | 2,065.7 | 2,123.5 |
| EBITDA, % | 15.5 | 5.84 | 22.24 | 16.96 | 18.49 | 15.81 | 15.81 | 15.81 | 15.81 | 15.81 |
| Depreciation | 859.0 | 922.0 | 786.1 | 684.8 | 682.8 | 903.4 | 928.7 | 954.7 | 981.4 | 1,008.8 |
| Depreciation, % | 8.12 | 9.55 | 7.65 | 6.4 | 5.83 | 7.51 | 7.51 | 7.51 | 7.51 | 7.51 |
| EBIT | 781.3 | -358.0 | 1,500.6 | 1,129.6 | 1,481.3 | 998.2 | 1,026.1 | 1,054.8 | 1,084.3 | 1,114.6 |
| EBIT, % | 7.39 | -3.71 | 14.6 | 10.56 | 12.66 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
| Total Cash | 523.4 | 770.1 | 637.4 | 600.0 | 868.9 | 773.7 | 795.3 | 817.5 | 840.4 | 863.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 820.3 | 687.1 | 879.4 | 866.2 | 879.4 | 939.1 | 965.4 | 992.4 | 1,020.2 | 1,048.7 |
| Account Receivables, % | 7.75 | 7.12 | 8.55 | 8.09 | 7.51 | 7.81 | 7.81 | 7.81 | 7.81 | 7.81 |
| Inventories | 615.9 | 664.3 | 804.7 | 792.9 | 802.3 | 837.2 | 860.6 | 884.6 | 909.4 | 934.8 |
| Inventories, % | 5.82 | 6.88 | 7.83 | 7.41 | 6.86 | 6.96 | 6.96 | 6.96 | 6.96 | 6.96 |
| Accounts Payable | 1,686.8 | 1,732.7 | 2,098.1 | 2,068.2 | 2,149.8 | 2,213.4 | 2,275.3 | 2,339.0 | 2,404.4 | 2,471.6 |
| Accounts Payable, % | 15.94 | 17.95 | 20.41 | 19.33 | 18.37 | 18.4 | 18.4 | 18.4 | 18.4 | 18.4 |
| Capital Expenditure | -593.8 | -574.8 | -522.6 | -661.4 | -671.5 | -687.4 | -706.6 | -726.3 | -746.7 | -767.5 |
| Capital Expenditure, % | -5.61 | -5.95 | -5.08 | -6.18 | -5.74 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 |
| Tax Rate, % | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 | 24.24 |
| EBITAT | 393.5 | -525.8 | 1,218.0 | 3,370.7 | 1,122.2 | 813.1 | 835.8 | 859.2 | 883.3 | 908.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 909.3 | -47.9 | 1,514.2 | 3,389.2 | 1,192.5 | 998.2 | 1,070.2 | 1,100.1 | 1,130.9 | 1,162.5 |
| WACC, % | 6.32 | 7.05 | 6.77 | 7.05 | 6.69 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,484.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,186 | |||||||||
| Terminal Value | 24,812 | |||||||||
| Present Terminal Value | 17,874 | |||||||||
| Enterprise Value | 22,359 | |||||||||
| Net Debt | 5,402 | |||||||||
| Equity Value | 16,957 | |||||||||
| Diluted Shares Outstanding, MM | 217 | |||||||||
| Equity Value Per Share | 78.03 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real TAP financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Molson Coors' valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Financial Data: Access reliable historical performance metrics and future forecasts for Molson Coors Beverage Company (TAP).
- Tailorable Assumptions: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Automated Calculations: Real-time updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation insights.
- Designed for All Skill Levels: A straightforward, intuitive layout catering to investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template with Molson Coors Beverage Company’s (TAP) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Molson Coors Beverage Company’s (TAP) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool favored by analysts, CFOs, and consultants in the beverage sector.
- Accurate Financial Data: Molson Coors’ historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Molson Coors Beverage Company (TAP) stock.
- Financial Analysts: Enhance valuation accuracy with comprehensive financial models tailored for Molson Coors Beverage Company (TAP).
- Consultants: Provide clients with detailed valuation analyses of Molson Coors Beverage Company (TAP) efficiently and effectively.
- Business Owners: Learn from the valuation methods of major players like Molson Coors Beverage Company (TAP) to inform your own business strategies.
- Finance Students: Explore real-world valuation techniques using data from Molson Coors Beverage Company (TAP) to enrich your learning experience.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Molson Coors Beverage Company historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Molson Coors Beverage Company (TAP).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.