|
Valoración DCF de Bright Horizons Family Solutions Inc. (BFAM)
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
Bright Horizons Family Solutions Inc. (BFAM) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (BFAM)! Utilizando datos reales de Bright Horizons Family Solutions Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valor (BFAM) al igual que un inversor experimentado.
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 | 2,062.0 | 1,515.1 | 1,755.3 | 2,020.5 | 2,418.3 | 2,564.1 | 2,718.8 | 2,882.7 | 3,056.6 | 3,241.0 |
| Revenue Growth, % | 0 | -26.52 | 15.85 | 15.11 | 19.69 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
| EBITDA | 376.1 | 165.0 | 230.3 | 265.3 | 271.2 | 341.5 | 362.1 | 383.9 | 407.1 | 431.7 |
| EBITDA, % | 18.24 | 10.89 | 13.12 | 13.13 | 11.21 | 13.32 | 13.32 | 13.32 | 13.32 | 13.32 |
| Depreciation | 108.3 | 111.7 | 108.8 | 106.1 | 110.7 | 146.9 | 155.8 | 165.2 | 175.1 | 185.7 |
| Depreciation, % | 5.25 | 7.37 | 6.2 | 5.25 | 4.58 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 |
| EBIT | 267.8 | 53.3 | 121.5 | 159.1 | 160.5 | 194.6 | 206.3 | 218.8 | 232.0 | 245.9 |
| EBIT, % | 12.99 | 3.52 | 6.92 | 7.88 | 6.64 | 7.59 | 7.59 | 7.59 | 7.59 | 7.59 |
| Total Cash | 27.9 | 384.3 | 261.0 | 36.2 | 93.6 | 242.3 | 256.9 | 272.4 | 288.8 | 306.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 148.9 | 176.6 | 211.0 | 217.2 | 281.7 | 273.3 | 289.8 | 307.3 | 325.8 | 345.4 |
| Account Receivables, % | 7.22 | 11.66 | 12.02 | 10.75 | 11.65 | 10.66 | 10.66 | 10.66 | 10.66 | 10.66 |
| Inventories | .0 | .0 | .0 | 73.3 | .0 | 18.6 | 19.7 | 20.9 | 22.2 | 23.5 |
| Inventories, % | 0 | 0.000000066 | 0.000000057 | 3.63 | 0 | 0.72526 | 0.72526 | 0.72526 | 0.72526 | 0.72526 |
| Accounts Payable | 17.8 | 30.0 | 8.5 | 24.6 | 24.8 | 28.6 | 30.3 | 32.1 | 34.1 | 36.1 |
| Accounts Payable, % | 0.86435 | 1.98 | 0.48442 | 1.22 | 1.03 | 1.11 | 1.11 | 1.11 | 1.11 | 1.11 |
| Capital Expenditure | -104.8 | -72.8 | -57.7 | -60.0 | -91.0 | -102.1 | -108.2 | -114.8 | -121.7 | -129.0 |
| Capital Expenditure, % | -5.08 | -4.81 | -3.29 | -2.97 | -3.76 | -3.98 | -3.98 | -3.98 | -3.98 | -3.98 |
| Tax Rate, % | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 | 38.1 |
| EBITAT | 217.0 | 92.0 | 94.8 | 114.4 | 99.3 | 152.9 | 162.1 | 171.8 | 182.2 | 193.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 89.4 | 115.2 | 90.1 | 97.2 | 127.9 | 191.3 | 193.7 | 205.4 | 217.8 | 231.0 |
| WACC, % | 9.72 | 9.91 | 9.69 | 9.63 | 9.53 | 9.69 | 9.69 | 9.69 | 9.69 | 9.69 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 786.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 238 | |||||||||
| Terminal Value | 3,554 | |||||||||
| Present Terminal Value | 2,238 | |||||||||
| Enterprise Value | 3,025 | |||||||||
| Net Debt | 1,788 | |||||||||
| Equity Value | 1,237 | |||||||||
| Diluted Shares Outstanding, MM | 58 | |||||||||
| Equity Value Per Share | 21.35 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real BFAM financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as enrollment growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Bright Horizons' 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
- Customizable Enrollment Metrics: Adjust essential factors such as student growth rates, tuition fees, and operational costs.
- Instant Valuation Analysis: Provides real-time calculations of intrinsic value, NPV, and additional financial metrics.
- High-Quality Accuracy: Leverages Bright Horizons' actual financial data for precise valuation results.
- Effortless Scenario Planning: Evaluate various assumptions and analyze outcomes with ease.
- Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.
How It Works
- Download: Get the pre-built Excel file containing Bright Horizons Family Solutions Inc.'s (BFAM) financial data.
- Customize: Modify projections, including enrollment growth, EBITDA %, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Bright Horizons Family Solutions Inc. (BFAM)?
- Designed for Experts: A sophisticated tool utilized by educators, financial analysts, and family service professionals.
- Comprehensive Data: Bright Horizons' historical and projected financials are preloaded for reliable insights.
- Flexible Modeling: Effortlessly test various scenarios and assumptions to see potential outcomes.
- Insightful Results: Automatically computes intrinsic value, NPV, and essential performance metrics.
- User-Friendly: Detailed, step-by-step guidance ensures a smooth experience.
Who Should Use Bright Horizons Family Solutions Inc. (BFAM)?
- Parents: Access reliable childcare solutions that fit your family's needs.
- Educators: Enhance your teaching methods with innovative early childhood education resources.
- Employers: Provide valuable benefits to employees by partnering with a trusted childcare provider.
- Investors: Explore growth opportunities in the expanding childcare services market.
- Community Leaders: Collaborate to improve access to quality education and care in your area.
What the Template Contains
- Pre-Filled DCF Model: Bright Horizons' financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Bright Horizons' profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.