|
Horizon Technology Finance Corporation (HRZN) DCF Valoración
US | Financial Services | Asset Management | 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
Horizon Technology Finance Corporation (HRZN) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora HRZN DCF! Utilizando datos reales de Horizon Technology Finance Corporation y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y evaluar HRZN como un inversor experimentado.
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 | 21.3 | 10.3 | 33.3 | 26.6 | -9.9 | -8.1 | -6.7 | -5.5 | -4.5 | -3.7 |
| Revenue Growth, % | 0 | -51.5 | 221.97 | -19.91 | -137.05 | -17.85 | -17.85 | -17.85 | -17.85 | -17.85 |
| EBITDA | .0 | .0 | .0 | .0 | 11.9 | 1.6 | 1.3 | 1.1 | .9 | .7 |
| EBITDA, % | 0 | 0 | 0 | 0 | -120.93 | -20 | -20 | -20 | -20 | -20 |
| Depreciation | 11.1 | 15.3 | 16.6 | 29.4 | .0 | -4.9 | -4.0 | -3.3 | -2.7 | -2.2 |
| Depreciation, % | 52.22 | 148.08 | 49.77 | 110.18 | 0 | 60.4 | 60.4 | 60.4 | 60.4 | 60.4 |
| EBIT | -11.1 | -15.3 | -16.6 | -29.4 | 11.9 | 6.5 | 5.4 | 4.4 | 3.6 | 3.0 |
| EBIT, % | -52.22 | -148.08 | -49.77 | -110.18 | -120.93 | -80.4 | -80.4 | -80.4 | -80.4 | -80.4 |
| Total Cash | 6.5 | 19.5 | 38.1 | 20.6 | 46.6 | -3.4 | -2.8 | -2.3 | -1.9 | -1.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.5 | 4.9 | 6.2 | 13.6 | 13.9 | -.7 | -.6 | -.5 | -.4 | -.3 |
| Account Receivables, % | 25.96 | 47.87 | 18.5 | 50.95 | -141.08 | 8.66 | 8.66 | 8.66 | 8.66 | 8.66 |
| Inventories | 22.9 | 52.7 | .0 | 44.0 | .0 | -4.9 | -4.0 | -3.3 | -2.7 | -2.2 |
| Inventories, % | 107.58 | 510.1 | 0.000003006072 | 165.3 | 0 | 60 | 60 | 60 | 60 | 60 |
| Accounts Payable | 4.7 | 5.8 | 6.4 | 9.2 | 11.0 | -.5 | -.4 | -.3 | -.3 | -.2 |
| Accounts Payable, % | 21.92 | 56 | 19.13 | 34.38 | -111.55 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 | -9.49 |
| EBITAT | -11.0 | -14.8 | -16.3 | -28.4 | 13.1 | 6.4 | 5.3 | 4.3 | 3.5 | 2.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -23.6 | -27.6 | 52.3 | -47.7 | 58.6 | 9.5 | .3 | .3 | .2 | .2 |
| WACC, % | 7.73 | 7.64 | 7.72 | 7.65 | 7.77 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 9.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 3 | |||||||||
| Present Terminal Value | 2 | |||||||||
| Enterprise Value | 12 | |||||||||
| Net Debt | 389 | |||||||||
| Equity Value | -377 | |||||||||
| Diluted Shares Outstanding, MM | 31 | |||||||||
| Equity Value Per Share | -12.19 |
What You Will Get
- Comprehensive HRZN Financial Data: Pre-filled with Horizon Technology Finance Corporation’s historical and projected data for thorough analysis.
- Fully Customizable Template: Easily adjust essential inputs like revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch Horizon's intrinsic value update in real-time as you make adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and straightforward instructions suitable for all experience levels.
Key Features
- Comprehensive DCF Model: Features detailed unlevered and levered DCF valuation frameworks tailored for Horizon Technology Finance Corporation (HRZN).
- WACC Calculation Tool: Pre-designed Weighted Average Cost of Capital worksheet with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth projections, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Horizon Technology Finance Corporation (HRZN).
- Visual Dashboard and Graphs: Graphical representations highlight essential valuation metrics for straightforward evaluation.
How It Works
- Download the Template: Gain immediate access to the Excel-based HRZN DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Horizon Technology's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Horizon Technology Finance Corporation (HRZN)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis.
- Real-Time Valuation: Instantly observe changes in Horizon Technology's valuation as you modify inputs.
- Preloaded Data: Comes equipped with Horizon Technology's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed financial decisions.
Who Should Use Horizon Technology Finance Corporation (HRZN)?
- Investors: Gain insights and make informed decisions with our specialized financial tools.
- Financial Analysts: Streamline your workflow with our customizable financial models designed for efficiency.
- Consultants: Effortlessly tailor our resources for impactful client presentations and reports.
- Finance Enthusiasts: Enhance your knowledge of tech finance through practical, real-world applications.
- Educators and Students: Utilize our resources as a hands-on learning aid in finance education.
What the Template Contains
- Historical Data: Contains Horizon Technology Finance Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Comprehensive templates to assess the intrinsic value of Horizon Technology Finance Corporation (HRZN).
- WACC Sheet: Pre-calculated metrics for Weighted Average Cost of Capital.
- Editable Inputs: Adjust essential variables such as growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A detailed overview of Horizon Technology Finance Corporation’s financials.
- Interactive Dashboard: Dynamically visualize valuation outcomes and forecasts.