|
Mister Car Wash, Inc. (MCW) Valoración de DCF
US | Consumer Cyclical | Personal Products & Services | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Mister Car Wash, Inc. (MCW) Bundle
¡Explore Mister Car Wash, Inc. (MCW) Financial Future con nuestra calculadora DCF fácil de usar! Ingrese sus proyecciones para el crecimiento, los márgenes y los gastos para calcular el valor intrínseco de Mister Car Wash, Inc. (MCW) y mejorar su enfoque de inversión.
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 | 629.5 | 574.9 | 758.4 | 876.5 | 927.1 | 1,030.4 | 1,145.2 | 1,272.9 | 1,414.7 | 1,572.4 |
| Revenue Growth, % | 0 | -8.67 | 31.9 | 15.58 | 5.77 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
| EBITDA | 105.9 | 220.7 | 42.8 | 187.7 | 248.1 | 224.7 | 249.8 | 277.6 | 308.5 | 342.9 |
| EBITDA, % | 16.82 | 38.4 | 5.65 | 21.42 | 26.77 | 21.81 | 21.81 | 21.81 | 21.81 | 21.81 |
| Depreciation | 40.0 | 79.6 | 86.6 | 102.7 | 70.0 | 104.8 | 116.5 | 129.5 | 143.9 | 160.0 |
| Depreciation, % | 6.35 | 13.84 | 11.41 | 11.71 | 7.55 | 10.17 | 10.17 | 10.17 | 10.17 | 10.17 |
| EBIT | 65.9 | 141.2 | -43.7 | 85.0 | 178.1 | 119.9 | 133.2 | 148.1 | 164.6 | 182.9 |
| EBIT, % | 10.47 | 24.56 | -5.76 | 9.7 | 19.22 | 11.64 | 11.64 | 11.64 | 11.64 | 11.64 |
| Total Cash | 6.4 | 114.6 | 19.7 | 65.2 | 19.0 | 68.1 | 75.7 | 84.1 | 93.5 | 103.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.8 | 5.7 | 23.9 | 19.1 | 21.0 | 21.9 | 24.3 | 27.0 | 30.1 | 33.4 |
| Account Receivables, % | 2.04 | 0.98358 | 3.15 | 2.18 | 2.27 | 2.12 | 2.12 | 2.12 | 2.12 | 2.12 |
| Inventories | 7.8 | 6.4 | 6.3 | 9.2 | 9.0 | 10.7 | 11.9 | 13.2 | 14.7 | 16.3 |
| Inventories, % | 1.23 | 1.12 | 0.83523 | 1.05 | 0.96562 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 |
| Accounts Payable | 15.8 | 24.4 | 27.3 | 25.6 | 33.6 | 34.8 | 38.7 | 43.0 | 47.8 | 53.2 |
| Accounts Payable, % | 2.51 | 4.24 | 3.61 | 2.93 | 3.63 | 3.38 | 3.38 | 3.38 | 3.38 | 3.38 |
| Capital Expenditure | -74.6 | -58.7 | -125.8 | -191.6 | -328.1 | -197.6 | -219.7 | -244.1 | -271.4 | -301.6 |
| Capital Expenditure, % | -11.85 | -10.22 | -16.58 | -21.86 | -35.39 | -19.18 | -19.18 | -19.18 | -19.18 | -19.18 |
| Tax Rate, % | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 | 22.23 |
| EBITAT | -35.3 | 110.5 | -20.4 | 65.8 | 138.5 | 67.2 | 74.7 | 83.0 | 92.3 | 102.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -74.7 | 148.4 | -74.8 | -22.9 | -113.3 | -27.0 | -28.2 | -31.4 | -34.8 | -38.7 |
| WACC, % | 6.94 | 8.42 | 7.82 | 8.4 | 8.41 | 8 | 8 | 8 | 8 | 8 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -126.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | -40 | |||||||||
| Terminal Value | -891 | |||||||||
| Present Terminal Value | -607 | |||||||||
| Enterprise Value | -733 | |||||||||
| Net Debt | 1,747 | |||||||||
| Equity Value | -2,479 | |||||||||
| Diluted Shares Outstanding, MM | 328 | |||||||||
| Equity Value Per Share | -7.55 |
What You Will Get
- Real Mister Car Wash Data: Preloaded financials – from revenue to EBIT – derived from actual and projected figures.
- Full Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Mister Car Wash's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and flexibility.
Key Features
- Accurate MCW Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Assumptions: Modify highlighted cells for WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to illustrate your valuation findings.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Mister Car Wash, Inc. (MCW).
- Step 2: Review the pre-filled financial data and forecasts for Mister Car Wash.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Mister Car Wash, Inc. (MCW)?
- Save Time: No need to develop a car wash plan from scratch – it's ready for implementation.
- Enhance Customer Satisfaction: Consistent service quality ensures a positive experience for every customer.
- Fully Customizable: Adapt our services to meet your specific needs and preferences.
- Easy to Understand: Simple service options and pricing make it straightforward for customers to choose.
- Trusted by Customers: Preferred by car owners who appreciate reliability and convenience.
Who Should Use This Product?
- Car Wash Enthusiasts: Discover the latest trends in car care and maintenance using real-time data.
- Business Students: Analyze business models and strategies employed by leading companies like Mister Car Wash, Inc. (MCW).
- Investors: Evaluate your investment strategies and assess the performance metrics of Mister Car Wash, Inc. (MCW).
- Market Analysts: Enhance your analysis with a comprehensive framework for evaluating service-based businesses.
- Franchise Owners: Learn from the operational successes of Mister Car Wash, Inc. (MCW) to improve your own business practices.
What the Template Contains
- Pre-Filled Data: Includes Mister Car Wash, Inc.'s (MCW) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for MCW.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to Mister Car Wash.
- Key Financial Ratios: Analyze MCW’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates for accurate projections.
- Clear Dashboard: Visual charts and tables summarizing key valuation results for Mister Car Wash, Inc.