|
Valoración de DCF de Heritage Global Inc. (HGBL)
US | Financial Services | Financial - Capital Markets | NASDAQ
|
- ✓ 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
Heritage Global Inc. (HGBL) Bundle
Diseñada para la precisión, nuestra calculadora DCF (HGBL) le permite evaluar la valoración de Heritage Global Inc. utilizando datos financieros del mundo real, al tiempo que proporciona flexibilidad completa para modificar todos los parámetros esenciales para las proyecciones mejoradas.
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 | 26.2 | 26.2 | 25.8 | 46.9 | 60.5 | 77.1 | 98.2 | 125.1 | 159.4 | 203.0 |
Revenue Growth, % | 0 | 0.05732192 | -1.49 | 81.89 | 29.06 | 27.38 | 27.38 | 27.38 | 27.38 | 27.38 |
EBITDA | 3.4 | 6.4 | 3.5 | 11.7 | 14.8 | 15.4 | 19.7 | 25.1 | 31.9 | 40.7 |
EBITDA, % | 12.82 | 24.52 | 13.47 | 24.85 | 24.5 | 20.03 | 20.03 | 20.03 | 20.03 | 20.03 |
Depreciation | .3 | .9 | 1.0 | 1.1 | .5 | 1.8 | 2.3 | 2.9 | 3.7 | 4.7 |
Depreciation, % | 1.17 | 3.37 | 3.85 | 2.31 | 0.84896 | 2.31 | 2.31 | 2.31 | 2.31 | 2.31 |
EBIT | 3.1 | 5.5 | 2.5 | 10.6 | 14.3 | 13.7 | 17.4 | 22.2 | 28.2 | 36.0 |
EBIT, % | 11.66 | 21.15 | 9.62 | 22.53 | 23.65 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 |
Total Cash | 2.7 | 23.4 | 13.6 | 12.7 | 12.3 | 30.8 | 39.3 | 50.0 | 63.7 | 81.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.2 | 2.8 | 2.7 | 1.0 | 1.9 | 6.0 | 7.6 | 9.7 | 12.3 | 15.7 |
Account Receivables, % | 12.05 | 10.82 | 10.59 | 2.11 | 3.15 | 7.75 | 7.75 | 7.75 | 7.75 | 7.75 |
Inventories | .1 | .2 | 3.2 | 4.6 | 5.1 | 4.9 | 6.3 | 8.0 | 10.2 | 13.0 |
Inventories, % | 0.39743 | 0.89753 | 12.48 | 9.85 | 8.38 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
Accounts Payable | .0 | .0 | 6.5 | 3.2 | .2 | 4.9 | 6.3 | 8.0 | 10.2 | 13.0 |
Accounts Payable, % | 0 | 0 | 25.01 | 6.8 | 0.26261 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
Capital Expenditure | -.1 | .0 | -1.4 | -.2 | -.3 | -1.1 | -1.4 | -1.7 | -2.2 | -2.8 |
Capital Expenditure, % | -0.44329 | -0.0267349 | -5.52 | -0.45829 | -0.42448 | -1.38 | -1.38 | -1.38 | -1.38 | -1.38 |
Tax Rate, % | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 |
EBITAT | 4.0 | 8.9 | 2.5 | 14.9 | 12.8 | 13.4 | 17.0 | 21.7 | 27.6 | 35.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | .9 | 10.0 | 5.7 | 12.8 | 8.6 | 15.0 | 16.3 | 20.8 | 26.5 | 33.7 |
WACC, % | 9.32 | 9.32 | 9.32 | 9.32 | 9.25 | 9.31 | 9.31 | 9.31 | 9.31 | 9.31 |
PV UFCF | ||||||||||
SUM PV UFCF | 83.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 34 | |||||||||
Terminal Value | 471 | |||||||||
Present Terminal Value | 302 | |||||||||
Enterprise Value | 385 | |||||||||
Net Debt | -2 | |||||||||
Equity Value | 388 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | 10.31 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Heritage Global Inc.'s financial data pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional: A refined Excel model that meets your valuation requirements.
- Designed for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers in-depth unlevered and levered DCF valuation models tailored for Heritage Global Inc. (HGBL).
- WACC Calculator: Comes with a pre-configured Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to suit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Heritage Global Inc. (HGBL).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Heritage Global Inc. (HGBL) 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 the intrinsic value of Heritage Global Inc. (HGBL).
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for Heritage Global Inc. (HGBL)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: Heritage Global’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth user experience.
Who Should Use Heritage Global Inc. (HGBL)?
- Finance Students: Explore asset liquidation strategies and apply them to real-world scenarios.
- Academics: Utilize industry-standard models in your research or teaching materials.
- Investors: Evaluate your investment strategies and assess the market potential of Heritage Global Inc. (HGBL).
- Analysts: Enhance your analysis with a comprehensive, customizable asset management framework.
- Small Business Owners: Understand how public companies like Heritage Global Inc. (HGBL) approach asset valuation and management.
What the Template Contains
- Pre-Filled DCF Model: Heritage Global Inc.’s (HGBL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to (HGBL).
- Financial Ratios: Evaluate Heritage Global Inc.’s (HGBL) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for (HGBL).
- Financial Statements: Annual and quarterly reports to support detailed analysis of (HGBL).
- Interactive Dashboard: Easily visualize key valuation metrics and results for Heritage Global Inc. (HGBL).