Generac Holdings Inc. (GNRC) DCF Valuation

Generac Holdings Inc. (GNRC) DCF Valuation
  • ✓ 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

Generac Holdings Inc. (GNRC) 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:

Streamline Generac Holdings Inc. (GNRC) valuation with this adaptable DCF Calculator! With authentic Generac financial data and customizable forecast parameters, you can explore various scenarios and determine Generac's fair value in just minutes.


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 2,204.3 2,485.2 3,737.2 4,564.7 4,022.7 4,760.7 5,634.1 6,667.8 7,891.2 9,339.0
Revenue Growth, % 0 12.74 50.38 22.14 -11.88 18.35 18.35 18.35 18.35 18.35
EBITDA 434.9 549.3 834.6 723.9 553.3 892.9 1,056.7 1,250.6 1,480.1 1,751.6
EBITDA, % 19.73 22.1 22.33 15.86 13.75 18.76 18.76 18.76 18.76 18.76
Depreciation 60.9 68.8 92.0 156.1 166.6 148.1 175.3 207.4 245.5 290.5
Depreciation, % 2.76 2.77 2.46 3.42 4.14 3.11 3.11 3.11 3.11 3.11
EBIT 374.0 480.5 742.6 567.8 386.7 744.8 881.4 1,043.2 1,234.6 1,461.1
EBIT, % 16.97 19.34 19.87 12.44 9.61 15.64 15.64 15.64 15.64 15.64
Total Cash 322.9 655.1 147.3 132.7 201.0 503.3 595.6 704.9 834.2 987.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 319.5 374.9 546.5 522.5 537.3
Account Receivables, % 14.5 15.09 14.62 11.45 13.36
Inventories 522.0 603.3 1,089.7 1,405.4 1,167.5 1,303.7 1,542.9 1,826.0 2,161.0 2,557.5
Inventories, % 23.68 24.28 29.16 30.79 29.02 27.39 27.39 27.39 27.39 27.39
Accounts Payable 262.0 330.2 674.2 446.1 340.7 585.1 692.5 819.5 969.9 1,147.9
Accounts Payable, % 11.88 13.29 18.04 9.77 8.47 12.29 12.29 12.29 12.29 12.29
Capital Expenditure -60.8 -62.1 -110.0 -86.2 -129.1 -126.6 -149.8 -177.3 -209.9 -248.4
Capital Expenditure, % -2.76 -2.5 -2.94 -1.89 -3.21 -2.66 -2.66 -2.66 -2.66 -2.66
Tax Rate, % 30.04 30.04 30.04 30.04 30.04 30.04 30.04 30.04 30.04 30.04
EBITAT 296.4 376.2 572.8 391.1 270.5 556.4 658.5 779.3 922.2 1,091.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -283.1 314.5 240.8 -58.7 425.8 566.3 431.5 510.7 604.4 715.3
WACC, % 9.92 9.91 9.9 9.83 9.84 9.88 9.88 9.88 9.88 9.88
PV UFCF
SUM PV UFCF 2,118.7
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 737
Terminal Value 10,703
Present Terminal Value 6,681
Enterprise Value 8,799
Net Debt 1,533
Equity Value 7,267
Diluted Shares Outstanding, MM 62
Equity Value Per Share 117.10

What You Will Receive

  • Pre-Filled Financial Model: Generac's actual data provides accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
  • Real-Time Calculations: Automatic updates allow you to view results instantly 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 in-depth forecasts.

Key Features

  • Real-Life GNRC Data: Pre-filled with Generac’s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • Step 1: Download the prebuilt Excel template containing Generac Holdings Inc.'s (GNRC) 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 Generac Holdings Inc.'s (GNRC) intrinsic value.
  • Step 5: Use the outputs to make informed investment decisions or create reports.

Why Choose This Calculator?

  • Accurate Data: Real Generac Holdings Inc. (GNRC) financials ensure reliable valuation results.
  • Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
  • Time-Saving: Pre-built calculations eliminate the need to start from scratch.
  • Professional-Grade Tool: Designed for investors, analysts, and consultants.
  • User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.

Who Should Use This Product?

  • Investors: Assess Generac’s valuation prior to making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts.
  • Startup Founders: Understand the valuation strategies of established companies like Generac.
  • Consultants: Provide comprehensive valuation analyses for clients.
  • Students and Educators: Utilize real-time data to learn and teach valuation practices.

What the Template Contains

  • Pre-Filled DCF Model: Generac Holdings Inc.'s (GNRC) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Generac's (GNRC) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.