|
Valoración de DCF Hubbell Incorporated (HUBB)
US | Industrials | Electrical Equipment & Parts | NYSE
|
- ✓ 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
Hubbell Incorporated (HUBB) Bundle
¡Simplifique la valoración de Hubbell Incorporated (HUBB) con esta calculadora DCF personalizable! Con el Real Hubbell Incorporated (HUBB) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Hubbell Incorporated (HUBB) en minutos.
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 | 4,591.0 | 4,186.0 | 4,194.1 | 4,947.9 | 5,372.9 | 5,613.8 | 5,865.5 | 6,128.5 | 6,403.3 | 6,690.3 |
Revenue Growth, % | 0 | -8.82 | 0.1935 | 17.97 | 8.59 | 4.48 | 4.48 | 4.48 | 4.48 | 4.48 |
EBITDA | 740.9 | 671.4 | 661.0 | 854.3 | 1,169.7 | 976.5 | 1,020.3 | 1,066.0 | 1,113.8 | 1,163.8 |
EBITDA, % | 16.14 | 16.04 | 15.76 | 17.27 | 21.77 | 17.39 | 17.39 | 17.39 | 17.39 | 17.39 |
Depreciation | 151.0 | 143.8 | 147.0 | 145.7 | 149.7 | 179.2 | 187.2 | 195.6 | 204.4 | 213.6 |
Depreciation, % | 3.29 | 3.44 | 3.5 | 2.94 | 2.79 | 3.19 | 3.19 | 3.19 | 3.19 | 3.19 |
EBIT | 589.9 | 527.6 | 514.0 | 708.6 | 1,020.0 | 797.3 | 833.1 | 870.4 | 909.4 | 950.2 |
EBIT, % | 12.85 | 12.6 | 12.26 | 14.32 | 18.98 | 14.2 | 14.2 | 14.2 | 14.2 | 14.2 |
Total Cash | 196.2 | 268.9 | 295.6 | 454.8 | 348.7 | 375.3 | 392.1 | 409.7 | 428.1 | 447.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 683.0 | 531.6 | 675.3 | 741.6 | 785.4 | 822.8 | 859.7 | 898.2 | 938.5 | 980.6 |
Account Receivables, % | 14.88 | 12.7 | 16.1 | 14.99 | 14.62 | 14.66 | 14.66 | 14.66 | 14.66 | 14.66 |
Inventories | 633.0 | 607.3 | 662.1 | 740.7 | 832.9 | 837.1 | 874.6 | 913.8 | 954.8 | 997.6 |
Inventories, % | 13.79 | 14.51 | 15.79 | 14.97 | 15.5 | 14.91 | 14.91 | 14.91 | 14.91 | 14.91 |
Accounts Payable | 347.7 | 339.2 | 532.8 | 529.9 | 563.5 | 556.6 | 581.6 | 607.7 | 634.9 | 663.4 |
Accounts Payable, % | 7.57 | 8.1 | 12.7 | 10.71 | 10.49 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 |
Capital Expenditure | -93.9 | -88.4 | -90.2 | -129.3 | -165.7 | -134.8 | -140.8 | -147.1 | -153.7 | -160.6 |
Capital Expenditure, % | -2.05 | -2.11 | -2.15 | -2.61 | -3.08 | -2.4 | -2.4 | -2.4 | -2.4 | -2.4 |
Tax Rate, % | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 | 22.73 |
EBITAT | 454.4 | 408.6 | 447.1 | 588.8 | 788.2 | 640.7 | 669.5 | 699.5 | 730.8 | 763.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -456.8 | 632.6 | 499.0 | 457.4 | 669.8 | 636.7 | 666.4 | 696.3 | 727.5 | 760.1 |
WACC, % | 8.21 | 8.22 | 8.25 | 8.24 | 8.21 | 8.23 | 8.23 | 8.23 | 8.23 | 8.23 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,748.6 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 791 | |||||||||
Terminal Value | 18,701 | |||||||||
Present Terminal Value | 12,594 | |||||||||
Enterprise Value | 15,343 | |||||||||
Net Debt | 1,954 | |||||||||
Equity Value | 13,389 | |||||||||
Diluted Shares Outstanding, MM | 54 | |||||||||
Equity Value Per Share | 247.95 |
What You Will Get
- Real Hubbell Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Hubbell Incorporated (HUBB).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Hubbell’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Hubbell Incorporated (HUBB).
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility in your financial assessments.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue growth, operating margins, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and various financial metrics in real-time.
- High-Precision Accuracy: Leverages Hubbell's (HUBB) actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Evaluate diverse assumptions and easily compare results.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- Download the Template: Get instant access to the Excel-based HUBB DCF Calculator.
- Input Your Assumptions: Adjust the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Hubbell’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Hubbell Incorporated (HUBB)?
- Accurate Data: Access to real Hubbell financials ensures trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate layout and clear instructions simplify the process for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Hubbell Incorporated (HUBB) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Hubbell Incorporated (HUBB).
- Consultants: Deliver professional valuation insights on Hubbell Incorporated (HUBB) to clients quickly and accurately.
- Business Owners: Understand how companies like Hubbell Incorporated (HUBB) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Hubbell Incorporated (HUBB).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Hubbell Incorporated (HUBB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Hubbell Incorporated (HUBB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.