Chipotle Mexican Grill, Inc. (CMG) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Chipotle Mexican Grill, Inc. (CMG) Bundle
Looking to determine the intrinsic value of Chipotle Mexican Grill, Inc.? Our CMG DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and make informed investment choices.
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 | 5,586.4 | 5,984.6 | 7,547.1 | 8,634.7 | 9,871.6 | 11,401.1 | 13,167.5 | 15,207.6 | 17,563.7 | 20,285.0 |
Revenue Growth, % | 0 | 7.13 | 26.11 | 14.41 | 14.33 | 15.49 | 15.49 | 15.49 | 15.49 | 15.49 |
EBITDA | 690.9 | 574.8 | 1,067.4 | 1,468.4 | 1,939.9 | 1,659.4 | 1,916.5 | 2,213.4 | 2,556.3 | 2,952.4 |
EBITDA, % | 12.37 | 9.6 | 14.14 | 17.01 | 19.65 | 14.55 | 14.55 | 14.55 | 14.55 | 14.55 |
Depreciation | 376.7 | 423.1 | 254.7 | 286.8 | 319.4 | 541.4 | 625.3 | 722.2 | 834.1 | 963.3 |
Depreciation, % | 6.74 | 7.07 | 3.37 | 3.32 | 3.24 | 4.75 | 4.75 | 4.75 | 4.75 | 4.75 |
EBIT | 314.2 | 151.7 | 812.8 | 1,181.5 | 1,620.5 | 1,118.0 | 1,291.2 | 1,491.2 | 1,722.2 | 1,989.1 |
EBIT, % | 5.62 | 2.54 | 10.77 | 13.68 | 16.42 | 9.81 | 9.81 | 9.81 | 9.81 | 9.81 |
Total Cash | 880.8 | 951.6 | 1,076.3 | 899.1 | 1,295.4 | 1,584.0 | 1,829.4 | 2,112.8 | 2,440.1 | 2,818.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 108.3 | 387.3 | 193.7 | 154.6 | 168.5 | 330.0 | 381.1 | 440.2 | 508.4 | 587.2 |
Account Receivables, % | 1.94 | 6.47 | 2.57 | 1.79 | 1.71 | 2.89 | 2.89 | 2.89 | 2.89 | 2.89 |
Inventories | 26.1 | 26.4 | 32.8 | 35.7 | 39.3 | 49.1 | 56.8 | 65.6 | 75.7 | 87.4 |
Inventories, % | 0.46714 | 0.44188 | 0.43495 | 0.41308 | 0.3982 | 0.43105 | 0.43105 | 0.43105 | 0.43105 | 0.43105 |
Accounts Payable | 115.8 | 122.0 | 163.2 | 184.6 | 197.6 | 237.4 | 274.2 | 316.7 | 365.8 | 422.5 |
Accounts Payable, % | 2.07 | 2.04 | 2.16 | 2.14 | 2 | 2.08 | 2.08 | 2.08 | 2.08 | 2.08 |
Capital Expenditure | -333.9 | -373.4 | -442.5 | -479.2 | -560.7 | -668.3 | -771.8 | -891.4 | -1,029.5 | -1,189.0 |
Capital Expenditure, % | -5.98 | -6.24 | -5.86 | -5.55 | -5.68 | -5.86 | -5.86 | -5.86 | -5.86 | -5.86 |
Tax Rate, % | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 | 24.18 |
EBITAT | 240.1 | 183.7 | 653.0 | 899.1 | 1,228.7 | 913.7 | 1,055.3 | 1,218.8 | 1,407.6 | 1,625.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 264.4 | -39.8 | 693.6 | 764.4 | 983.0 | 655.3 | 886.8 | 1,024.2 | 1,182.9 | 1,366.2 |
WACC, % | 10.1 | 10.15 | 10.11 | 10.1 | 10.1 | 10.11 | 10.11 | 10.11 | 10.11 | 10.11 |
PV UFCF | ||||||||||
SUM PV UFCF | 3,742.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 1,421 | |||||||||
Terminal Value | 23,240 | |||||||||
Present Terminal Value | 14,356 | |||||||||
Enterprise Value | 18,098 | |||||||||
Net Debt | 3,491 | |||||||||
Equity Value | 14,607 | |||||||||
Diluted Shares Outstanding, MM | 1,386 | |||||||||
Equity Value Per Share | 10.54 |
What You Will Get
- Real CMG Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Modify WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are calculated dynamically.
- Scenario Analysis: Test multiple scenarios to evaluate Chipotle’s future performance.
- Clear and Intuitive Design: Tailored for professionals yet user-friendly for beginners.
Key Features
- Pre-Loaded Data: Chipotle’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: See Chipotle’s intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
- Built for Accuracy: A professional tool for analysts, investors, and finance experts.
How It Works
- Download: Access the ready-to-use Excel file with Chipotle Mexican Grill, Inc.'s (CMG) financial data.
- Customize: Adjust forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations update in real-time.
- Test Scenarios: Create multiple projections and compare outcomes instantly.
- Make Decisions: Use the valuation results to guide your investment strategy.
Why Choose This Calculator for Chipotle Mexican Grill, Inc. (CMG)?
- Designed for Industry Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Insights: Chipotle’s historical and projected financial data preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Investors: Assess Chipotle’s valuation prior to making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of leading companies like Chipotle.
- Consultants: Provide comprehensive valuation analyses for their clients.
- Students and Educators: Utilize real market data to learn and teach valuation principles.
What the Template Contains
- Pre-Filled Data: Includes Chipotle’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Chipotle’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.