Griffon Corporation (GFF) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Griffon Corporation (GFF) Bundle
Discover the true value of Griffon Corporation (GFF) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect Griffon Corporation (GFF) valuation – all within a single Excel template.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 2,407.5 | 2,270.6 | 2,848.5 | 2,685.2 | 2,623.5 | 2,700.5 | 2,779.7 | 2,861.2 | 2,945.2 | 3,031.6 |
Revenue Growth, % | 0 | -5.69 | 25.45 | -5.73 | -2.3 | 2.93 | 2.93 | 2.93 | 2.93 | 2.93 |
EBITDA | 208.1 | 245.2 | -121.8 | 463.1 | 461.4 | 270.1 | 278.0 | 286.1 | 294.5 | 303.2 |
EBITDA, % | 8.64 | 10.8 | -4.28 | 17.25 | 17.59 | 10 | 10 | 10 | 10 | 10 |
Depreciation | 52.1 | 52.3 | 64.7 | 65.4 | 60.7 | 62.0 | 63.9 | 65.7 | 67.7 | 69.7 |
Depreciation, % | 2.16 | 2.3 | 2.27 | 2.44 | 2.31 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
EBIT | 156.0 | 192.9 | -186.5 | 397.7 | 400.7 | 208.0 | 214.1 | 220.4 | 226.9 | 233.5 |
EBIT, % | 6.48 | 8.5 | -6.55 | 14.81 | 15.27 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
Total Cash | 218.1 | 248.7 | 120.2 | 102.9 | 114.4 | 175.1 | 180.2 | 185.5 | 191.0 | 196.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 278.4 | 294.8 | 361.7 | 312.4 | 312.8 | 328.4 | 338.0 | 347.9 | 358.1 | 368.6 |
Account Receivables, % | 11.56 | 12.98 | 12.7 | 11.64 | 11.92 | 12.16 | 12.16 | 12.16 | 12.16 | 12.16 |
Inventories | 413.8 | 472.8 | 669.2 | 507.1 | 425.5 | 521.8 | 537.1 | 552.8 | 569.1 | 585.7 |
Inventories, % | 17.19 | 20.82 | 23.49 | 18.89 | 16.22 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
Accounts Payable | 172.5 | 260.0 | 194.8 | 116.6 | 119.4 | 185.5 | 191.0 | 196.6 | 202.3 | 208.3 |
Accounts Payable, % | 7.17 | 11.45 | 6.84 | 4.34 | 4.55 | 6.87 | 6.87 | 6.87 | 6.87 | 6.87 |
Capital Expenditure | -49.0 | -37.0 | -42.5 | -63.6 | -68.4 | -54.7 | -56.3 | -58.0 | -59.7 | -61.4 |
Capital Expenditure, % | -2.04 | -1.63 | -1.49 | -2.37 | -2.61 | -2.03 | -2.03 | -2.03 | -2.03 | -2.03 |
Tax Rate, % | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 | 29.24 |
EBITAT | 100.7 | 137.4 | -198.1 | 273.9 | 283.5 | 156.2 | 160.8 | 165.5 | 170.3 | 175.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -415.9 | 164.9 | -504.4 | 408.9 | 359.9 | 117.8 | 148.8 | 153.2 | 157.7 | 162.3 |
WACC, % | 8.35 | 8.48 | 9.05 | 8.44 | 8.47 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 |
PV UFCF | ||||||||||
SUM PV UFCF | 575.7 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 169 | |||||||||
Terminal Value | 3,702 | |||||||||
Present Terminal Value | 2,455 | |||||||||
Enterprise Value | 3,031 | |||||||||
Net Debt | 1,592 | |||||||||
Equity Value | 1,439 | |||||||||
Diluted Shares Outstanding, MM | 50 | |||||||||
Equity Value Per Share | 28.97 |
What You Will Receive
- Pre-Filled Financial Model: Griffon Corporation’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Instantaneous updates ensure you see outcomes as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing repeated application for in-depth forecasts.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue projections, operating margins, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and other financial metrics.
- High Precision Analysis: Leverages Griffon Corporation's (GFF) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Griffon Corporation (GFF) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Griffon Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Griffon Corporation (GFF)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Griffon Corporation’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately assess Griffon Corporation’s (GFF) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial analysis and reporting.
- Consultants: Efficiently modify the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading corporations.
- Educators: Apply it as a resource for teaching valuation methods.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Griffon Corporation (GFF).
- Real-World Data: Griffon’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Griffon Corporation (GFF).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable insights.