Griffon Corporation (GFF) DCF Valuation

Griffon Corporation (GFF) 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

Griffon Corporation (GFF) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 11.56 12.98 12.7 11.64 11.92
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Griffon Corporation (GFF) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Griffon Corporation’s intrinsic value.
  5. 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.