|
Inter Parfums, Inc. (IPAR) Valoración de DCF
US | Consumer Defensive | Household & Personal Products | 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
Inter Parfums, Inc. (IPAR) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF Inter Parfums, Inc. (IPAR)! Explore datos financieros genuinos para parfums, ajuste las predicciones y gastos de crecimiento, y observe cómo estas alteraciones afectan el valor intrínseco de Inter Parfums, Inc. (IPAR) 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 | 713.5 | 539.0 | 879.5 | 1,086.7 | 1,317.7 | 1,592.8 | 1,925.4 | 2,327.5 | 2,813.5 | 3,401.0 |
| Revenue Growth, % | 0 | -24.46 | 63.17 | 23.55 | 21.26 | 20.88 | 20.88 | 20.88 | 20.88 | 20.88 |
| EBITDA | 113.5 | 79.2 | 171.7 | 223.9 | 281.0 | 293.2 | 354.4 | 428.4 | 517.9 | 626.0 |
| EBITDA, % | 15.9 | 14.68 | 19.52 | 20.6 | 21.32 | 18.41 | 18.41 | 18.41 | 18.41 | 18.41 |
| Depreciation | 8.7 | 9.1 | 17.6 | 19.8 | 17.3 | 25.6 | 31.0 | 37.4 | 45.3 | 54.7 |
| Depreciation, % | 1.22 | 1.68 | 2 | 1.82 | 1.32 | 1.61 | 1.61 | 1.61 | 1.61 | 1.61 |
| EBIT | 104.7 | 70.1 | 154.0 | 204.1 | 263.6 | 267.6 | 323.4 | 391.0 | 472.6 | 571.3 |
| EBIT, % | 14.68 | 13 | 17.51 | 18.78 | 20.01 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 |
| Total Cash | 253.1 | 296.3 | 319.6 | 255.5 | 182.8 | 523.0 | 632.2 | 764.2 | 923.8 | 1,116.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 135.2 | 128.7 | 169.8 | 226.5 | 254.9 | 326.0 | 394.1 | 476.3 | 575.8 | 696.0 |
| Account Receivables, % | 18.95 | 23.87 | 19.31 | 20.85 | 19.35 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 |
| Inventories | 167.8 | 158.8 | 198.9 | 290.0 | 371.9 | 415.8 | 502.6 | 607.5 | 734.4 | 887.7 |
| Inventories, % | 23.52 | 29.47 | 22.62 | 26.69 | 28.22 | 26.1 | 26.1 | 26.1 | 26.1 | 26.1 |
| Accounts Payable | 54.1 | 35.6 | 82.0 | 88.4 | 97.4 | 124.3 | 150.3 | 181.7 | 219.6 | 265.5 |
| Accounts Payable, % | 7.58 | 6.6 | 9.32 | 8.13 | 7.39 | 7.81 | 7.81 | 7.81 | 7.81 | 7.81 |
| Capital Expenditure | -11.5 | -12.3 | -142.8 | -132.6 | -53.4 | -115.9 | -140.1 | -169.3 | -204.7 | -247.5 |
| Capital Expenditure, % | -1.61 | -2.27 | -16.24 | -12.2 | -4.05 | -7.28 | -7.28 | -7.28 | -7.28 | -7.28 |
| Tax Rate, % | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 | 38.84 |
| EBITAT | 60.0 | 38.6 | 89.2 | 127.1 | 161.2 | 157.2 | 190.0 | 229.7 | 277.6 | 335.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -191.7 | 32.4 | -70.9 | -127.2 | 24.0 | -21.1 | -48.1 | -58.1 | -70.2 | -84.9 |
| WACC, % | 9.7 | 9.69 | 9.7 | 9.71 | 9.71 | 9.7 | 9.7 | 9.7 | 9.7 | 9.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -205.1 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -88 | |||||||||
| Terminal Value | -1,548 | |||||||||
| Present Terminal Value | -975 | |||||||||
| Enterprise Value | -1,180 | |||||||||
| Net Debt | 104 | |||||||||
| Equity Value | -1,284 | |||||||||
| Diluted Shares Outstanding, MM | 32 | |||||||||
| Equity Value Per Share | -39.94 |
What You Will Receive
- Pre-Filled Financial Model: Inter Parfums, Inc.'s (IPAR) actual data enables accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other critical factors.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, permitting repeated use for in-depth forecasts.
Key Features
- 🔍 Real-Life IPAR Financials: Pre-filled historical and projected data for Inter Parfums, Inc. (IPAR).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Inter Parfums’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Inter Parfums’ 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 IPAR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates Inter Parfums, Inc.'s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Inter Parfums, Inc. (IPAR)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financial Data: Inter Parfums’ historical and projected financials are preloaded for reliability.
- 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 ensures a smooth calculation process.
Who Should Use Inter Parfums, Inc. (IPAR)?
- Investors: Make informed investment choices with insights from a leading fragrance company.
- Market Analysts: Analyze trends and performance metrics in the global fragrance market.
- Brand Consultants: Utilize data to enhance brand strategies and client recommendations.
- Fragrance Enthusiasts: Explore the art and science of perfumery through real-world case studies.
- Students and Educators: Incorporate practical examples from a thriving company into marketing and business curriculum.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Inter Parfums, Inc. (IPAR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Inter Parfums, Inc. (IPAR).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.