|
Acushnet Holdings Corp. (GOLF) DCF Valuation
US | Consumer Cyclical | Leisure | NYSE
|
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Acushnet Holdings Corp. (GOLF) Bundle
Gain insight into your Acushnet Holdings Corp. (GOLF) valuation analysis with our state-of-the-art DCF Calculator! Equipped with real (GOLF) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine Acushnet Holdings Corp.'s intrinsic value.
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.