|
Valoración DCF de OlaPlex Holdings, Inc. (OLPX)
US | Consumer Cyclical | Specialty Retail | NASDAQ
|
- ✓ 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
Olaplex Holdings, Inc. (OLPX) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de OlaPlex Holdings, Inc. (OLPX)! Sumérgete en datos financieros auténticos, ajusta las predicciones y gastos de crecimiento, y observa cómo estas modificaciones afectan el valor intrínseco de Olaplex Holdings, Inc. (OLPX) en tiempo real.
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 | 148.2 | 282.3 | 598.4 | 704.3 | 458.3 | 565.7 | 698.2 | 861.7 | 1,063.6 | 1,312.8 |
Revenue Growth, % | 0 | 90.44 | 112 | 17.7 | -34.93 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 |
EBITDA | .0 | 165.0 | 385.7 | 399.0 | 186.8 | 249.2 | 307.6 | 379.7 | 468.6 | 578.4 |
EBITDA, % | 0 | 58.45 | 64.46 | 56.65 | 40.75 | 44.06 | 44.06 | 44.06 | 44.06 | 44.06 |
Depreciation | -99.0 | 45.9 | 48.9 | 49.1 | 50.3 | -27.7 | -34.1 | -42.1 | -52.0 | -64.2 |
Depreciation, % | -66.83 | 16.25 | 8.18 | 6.98 | 10.97 | -4.89 | -4.89 | -4.89 | -4.89 | -4.89 |
EBIT | 99.0 | 119.1 | 336.8 | 349.8 | 136.5 | 276.9 | 341.8 | 421.8 | 520.6 | 642.6 |
EBIT, % | 66.83 | 42.19 | 56.28 | 49.67 | 29.78 | 48.95 | 48.95 | 48.95 | 48.95 | 48.95 |
Total Cash | 3.2 | 11.0 | 186.4 | 322.8 | 466.4 | 207.0 | 255.5 | 315.4 | 389.3 | 480.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.4 | 14.4 | 40.8 | 46.2 | 40.9 | 37.4 | 46.1 | 56.9 | 70.3 | 86.7 |
Account Receivables, % | 5.63 | 5.09 | 6.82 | 6.56 | 8.93 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
Inventories | 15.9 | 33.6 | 98.4 | 144.4 | 95.9 | 91.1 | 112.4 | 138.8 | 171.3 | 211.4 |
Inventories, % | 10.72 | 11.9 | 16.44 | 20.51 | 20.93 | 16.1 | 16.1 | 16.1 | 16.1 | 16.1 |
Accounts Payable | .9 | 16.8 | 19.2 | 9.7 | 7.1 | 14.4 | 17.8 | 21.9 | 27.1 | 33.4 |
Accounts Payable, % | 0.63088 | 5.96 | 3.2 | 1.38 | 1.54 | 2.54 | 2.54 | 2.54 | 2.54 | 2.54 |
Capital Expenditure | .0 | .0 | -1.8 | -.7 | -3.6 | -1.3 | -1.7 | -2.1 | -2.5 | -3.1 |
Capital Expenditure, % | -0.00472316 | -0.00956599 | -0.29497 | -0.09229362 | -0.78857 | -0.23802 | -0.23802 | -0.23802 | -0.23802 | -0.23802 |
Tax Rate, % | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 | 19.72 |
EBITAT | 99.0 | 99.0 | 269.8 | 279.7 | 109.6 | 234.5 | 289.4 | 357.2 | 440.9 | 544.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -23.3 | 137.0 | 228.1 | 267.3 | 207.4 | 221.2 | 226.9 | 280.1 | 345.7 | 426.7 |
WACC, % | 13.53 | 12.99 | 12.9 | 12.89 | 12.9 | 13.04 | 13.04 | 13.04 | 13.04 | 13.04 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,010.0 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 429 | |||||||||
Terminal Value | 3,419 | |||||||||
Present Terminal Value | 1,852 | |||||||||
Enterprise Value | 2,862 | |||||||||
Net Debt | 189 | |||||||||
Equity Value | 2,673 | |||||||||
Diluted Shares Outstanding, MM | 678 | |||||||||
Equity Value Per Share | 3.94 |
What You Will Get
- Pre-Filled Financial Model: Olaplex’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- 🔍 Real-Life OLPX Financials: Pre-filled historical and projected data for Olaplex Holdings, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Olaplex’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Olaplex’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based OLPX DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Olaplex’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Olaplex Holdings, Inc. (OLPX)?
- Designed for Industry Leaders: A sophisticated tool tailored for analysts, investors, and financial advisors.
- Accurate Financial Data: Olaplex’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and scenarios.
- Comprehensive Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation experience.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for analyzing OLPX investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions for Olaplex Holdings.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in OLPX stock.
- Students and Educators: Utilize real-world data to practice and teach financial modeling with OLPX examples.
- Beauty Industry Enthusiasts: Gain insights into how companies like Olaplex are valued within the beauty market.
What the Template Contains
- Pre-Filled Data: Includes Olaplex Holdings’ 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 Olaplex’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.