Mister Car Wash, Inc. (MCW) DCF Valuation
- ✓ 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 with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate Mister Car Wash, Inc. (MCW) intrinsic value and enhance your investment approach.
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.