Heritage Global Inc. (HGBL) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Heritage Global Inc. (HGBL) Bundle
Designed for accuracy, our (HGBL) DCF Calculator enables you to evaluate Heritage Global Inc. valuation using real-world financial data, while providing complete flexibility to modify all essential parameters for enhanced projections.
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).