Hayward Holdings, Inc. (HAYW) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Hayward Holdings, Inc. (HAYW) Bundle
Designed for accuracy, our (HAYW) DCF Calculator enables you to assess Hayward Holdings, Inc. valuation using real-world financial data while providing complete flexibility to modify all essential parameters for improved projections.
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 | 733.4 | 875.4 | 1,401.8 | 1,314.1 | 992.5 | 1,113.4 | 1,249.1 | 1,401.4 | 1,572.2 | 1,763.8 |
Revenue Growth, % | 0 | 19.35 | 60.13 | -6.25 | -24.48 | 12.19 | 12.19 | 12.19 | 12.19 | 12.19 |
EBITDA | 155.6 | 188.1 | 390.8 | 356.9 | 227.7 | 268.7 | 301.5 | 338.3 | 379.5 | 425.7 |
EBITDA, % | 21.21 | 21.49 | 27.88 | 27.16 | 22.95 | 24.14 | 24.14 | 24.14 | 24.14 | 24.14 |
Depreciation | 59.0 | 56.7 | 57.8 | 57.6 | 53.1 | 63.2 | 70.9 | 79.5 | 89.2 | 100.1 |
Depreciation, % | 8.04 | 6.48 | 4.12 | 4.39 | 5.35 | 5.68 | 5.68 | 5.68 | 5.68 | 5.68 |
EBIT | 96.6 | 131.4 | 333.0 | 299.2 | 174.7 | 205.6 | 230.6 | 258.7 | 290.3 | 325.6 |
EBIT, % | 13.17 | 15.01 | 23.76 | 22.77 | 17.6 | 18.46 | 18.46 | 18.46 | 18.46 | 18.46 |
Total Cash | 47.2 | 114.9 | 265.8 | 56.2 | 203.1 | 140.9 | 158.0 | 177.3 | 198.9 | 223.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 184.9 | 140.2 | 208.1 | 236.3 | 280.9 | 227.9 | 255.7 | 286.9 | 321.8 | 361.1 |
Account Receivables, % | 25.21 | 16.02 | 14.85 | 17.98 | 28.3 | 20.47 | 20.47 | 20.47 | 20.47 | 20.47 |
Inventories | 137.1 | 145.3 | 233.4 | 283.7 | 215.2 | 212.0 | 237.9 | 266.9 | 299.4 | 335.9 |
Inventories, % | 18.69 | 16.6 | 16.65 | 21.59 | 21.68 | 19.04 | 19.04 | 19.04 | 19.04 | 19.04 |
Accounts Payable | 53.4 | 74.0 | 87.4 | 54.0 | 68.9 | 73.6 | 82.5 | 92.6 | 103.9 | 116.5 |
Accounts Payable, % | 7.28 | 8.45 | 6.24 | 4.11 | 6.95 | 6.61 | 6.61 | 6.61 | 6.61 | 6.61 |
Capital Expenditure | -26.7 | -15.6 | -27.1 | -29.6 | -31.0 | -28.4 | -31.8 | -35.7 | -40.0 | -44.9 |
Capital Expenditure, % | -3.64 | -1.78 | -1.94 | -2.25 | -3.12 | -2.55 | -2.55 | -2.55 | -2.55 | -2.55 |
Tax Rate, % | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 | 20.18 |
EBITAT | 68.1 | 98.4 | 260.8 | 229.1 | 139.4 | 156.3 | 175.3 | 196.7 | 220.6 | 247.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -168.2 | 196.6 | 148.9 | 145.3 | 200.3 | 251.8 | 169.7 | 190.4 | 213.6 | 239.7 |
WACC, % | 8.66 | 8.73 | 8.79 | 8.76 | 8.81 | 8.75 | 8.75 | 8.75 | 8.75 | 8.75 |
PV UFCF | ||||||||||
SUM PV UFCF | 833.4 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 247 | |||||||||
Terminal Value | 4,293 | |||||||||
Present Terminal Value | 2,822 | |||||||||
Enterprise Value | 3,656 | |||||||||
Net Debt | 985 | |||||||||
Equity Value | 2,671 | |||||||||
Diluted Shares Outstanding, MM | 221 | |||||||||
Equity Value Per Share | 12.10 |
What You Will Get
- Pre-Filled Financial Model: Hayward's actual data allows for an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see the results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- 🔍 Real-Life HAYW Financials: Pre-filled historical and projected data for Hayward Holdings, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Hayward’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Hayward’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-built Excel file featuring Hayward Holdings, Inc. (HAYW) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation findings to shape your investment approach.
Why Choose This Calculator for Hayward Holdings, Inc. (HAYW)?
- User-Friendly Interface: Crafted for both novices and seasoned professionals.
- Customizable Inputs: Effortlessly adjust parameters to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Hayward's valuation as you modify the inputs.
- Pre-Loaded Data: Comes equipped with Hayward's actual financial statistics for swift evaluations.
- Endorsed by Experts: A preferred tool among investors and analysts for making well-informed choices.
Who Should Use This Product?
- Finance Students: Master valuation methods and apply them to real-world data with Hayward Holdings, Inc. (HAYW).
- Academics: Integrate industry-standard models into your lectures or research focusing on Hayward Holdings, Inc. (HAYW).
- Investors: Validate your investment hypotheses and assess valuation scenarios for Hayward Holdings, Inc. (HAYW).
- Analysts: Enhance your efficiency with a customizable DCF model tailored for Hayward Holdings, Inc. (HAYW).
- Small Business Owners: Understand the analytical approaches used for evaluating large public companies like Hayward Holdings, Inc. (HAYW).
What the Template Contains
- Historical Data: Includes Hayward Holdings, Inc.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Hayward Holdings, Inc.'s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Hayward Holdings, Inc.'s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.