|
Valoración de DCF de Acushnet Holdings Corp. (Golf)
US | Consumer Cyclical | Leisure | 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
Acushnet Holdings Corp. (GOLF) Bundle
¡Obtenga información sobre su análisis de valoración de Acushnet Holdings Corp. (Golf) con nuestra calculadora DCF de última generación! Equipado con datos reales (de golf), esta plantilla de Excel le permite ajustar los pronósticos y supuestos para determinar con precisión el valor intrínseco de Acushnet Holdings Corp.
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 | 1,681.4 | 1,612.2 | 2,147.9 | 2,270.3 | 2,382.0 | 2,618.6 | 2,878.7 | 3,164.7 | 3,479.1 | 3,824.7 |
Revenue Growth, % | 0 | -4.12 | 33.23 | 5.7 | 4.92 | 9.93 | 9.93 | 9.93 | 9.93 | 9.93 |
EBITDA | 227.6 | 171.3 | 295.8 | 315.2 | 336.6 | 345.4 | 379.7 | 417.4 | 458.9 | 504.4 |
EBITDA, % | 13.54 | 10.62 | 13.77 | 13.88 | 14.13 | 13.19 | 13.19 | 13.19 | 13.19 | 13.19 |
Depreciation | 43.0 | 45.4 | 41.2 | 41.7 | 51.4 | 59.1 | 65.0 | 71.4 | 78.5 | 86.3 |
Depreciation, % | 2.56 | 2.82 | 1.92 | 1.84 | 2.16 | 2.26 | 2.26 | 2.26 | 2.26 | 2.26 |
EBIT | 184.6 | 125.8 | 254.6 | 273.4 | 285.2 | 286.3 | 314.7 | 345.9 | 380.3 | 418.1 |
EBIT, % | 10.98 | 7.81 | 11.85 | 12.04 | 11.97 | 10.93 | 10.93 | 10.93 | 10.93 | 10.93 |
Total Cash | 34.2 | 151.5 | 281.7 | 58.9 | 65.4 | 156.5 | 172.0 | 189.1 | 207.9 | 228.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 215.4 | 201.5 | 174.4 | 216.7 | 201.4 | 269.4 | 296.1 | 325.5 | 357.9 | 393.4 |
Account Receivables, % | 12.81 | 12.5 | 8.12 | 9.54 | 8.45 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 |
Inventories | 398.4 | 357.7 | 413.3 | 674.7 | 615.5 | 632.0 | 694.8 | 763.8 | 839.7 | 923.1 |
Inventories, % | 23.69 | 22.19 | 19.24 | 29.72 | 25.84 | 24.14 | 24.14 | 24.14 | 24.14 | 24.14 |
Accounts Payable | 102.3 | 112.9 | 163.6 | 167.0 | 150.5 | 180.0 | 197.9 | 217.6 | 239.2 | 263.0 |
Accounts Payable, % | 6.09 | 7 | 7.62 | 7.36 | 6.32 | 6.88 | 6.88 | 6.88 | 6.88 | 6.88 |
Capital Expenditure | -33.0 | -24.7 | -37.6 | -126.4 | -75.4 | -73.2 | -80.4 | -88.4 | -97.2 | -106.9 |
Capital Expenditure, % | -1.96 | -1.53 | -1.75 | -5.57 | -3.16 | -2.79 | -2.79 | -2.79 | -2.79 | -2.79 |
Tax Rate, % | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 | 17.87 |
EBITAT | 135.3 | 106.9 | 183.7 | 210.0 | 234.3 | 222.9 | 245.0 | 269.4 | 296.1 | 325.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -366.1 | 192.8 | 209.6 | -174.9 | 268.3 | 153.9 | 157.9 | 173.6 | 190.9 | 209.8 |
WACC, % | 7.84 | 7.93 | 7.83 | 7.87 | 7.91 | 7.88 | 7.88 | 7.88 | 7.88 | 7.88 |
PV UFCF | ||||||||||
SUM PV UFCF | 701.3 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 216 | |||||||||
Terminal Value | 4,432 | |||||||||
Present Terminal Value | 3,033 | |||||||||
Enterprise Value | 3,734 | |||||||||
Net Debt | 729 | |||||||||
Equity Value | 3,006 | |||||||||
Diluted Shares Outstanding, MM | 68 | |||||||||
Equity Value Per Share | 44.52 |
What You Will Receive
- Pre-Filled Financial Model: Acushnet’s actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Instant updates ensure you view results as adjustments are made.
- 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 GOLF Financials: Pre-filled historical and projected data for Acushnet Holdings Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Acushnet’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Acushnet’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template containing Acushnet Holdings Corp. (GOLF) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Acushnet's intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose This Calculator for Acushnet Holdings Corp. (GOLF)?
- Accuracy: Utilizes real Acushnet financial data to ensure precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various inputs.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive interface makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Golf Enthusiasts: Understand the financial metrics behind golf industry leaders like Acushnet Holdings Corp. (GOLF).
- Academics: Integrate industry-specific financial models into your teaching or research projects.
- Investors: Evaluate your investment strategies and assess the performance of Acushnet Holdings Corp. (GOLF).
- Market Analysts: Enhance your analysis with a user-friendly, customizable financial model tailored for the golf sector.
- Small Business Owners: Learn from the financial practices of successful companies in the golf industry, such as Acushnet Holdings Corp. (GOLF).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Acushnet Holdings Corp.'s (GOLF) historical and projected financials preloaded for analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables that present clear, actionable results.