WhiteHorse Finance, Inc. (WHF) 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
WhiteHorse Finance, Inc. (WHF) Bundle
Looking to assess the intrinsic value of WhiteHorse Finance, Inc. (WHF)? Our (WHF) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your projections and enhance your investment decisions.
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 | 34.2 | 36.0 | 35.4 | 21.4 | 103.3 | 119.7 | 138.8 | 160.9 | 186.6 | 216.3 |
Revenue Growth, % | 0 | 5.2 | -1.85 | -39.6 | 383.59 | 15.94 | 15.94 | 15.94 | 15.94 | 15.94 |
EBITDA | 31.7 | 44.7 | 46.3 | 36.0 | .0 | 94.0 | 108.9 | 126.3 | 146.4 | 169.8 |
EBITDA, % | 92.45 | 124.15 | 131.06 | 168.81 | 0 | 78.49 | 78.49 | 78.49 | 78.49 | 78.49 |
Depreciation | 35.6 | 21.1 | 34.4 | 37.5 | .0 | 85.2 | 98.7 | 114.5 | 132.7 | 153.9 |
Depreciation, % | 104.09 | 58.51 | 97.2 | 175.73 | 0 | 71.14 | 71.14 | 71.14 | 71.14 | 71.14 |
EBIT | -4.0 | 23.6 | 12.0 | -1.5 | .0 | 19.4 | 22.5 | 26.0 | 30.2 | 35.0 |
EBIT, % | -11.64 | 65.64 | 33.85 | -6.92 | 0 | 16.19 | 16.19 | 16.19 | 16.19 | 16.19 |
Total Cash | 4.3 | 8.1 | 12.2 | 660.0 | 10.7 | 43.0 | 49.9 | 57.9 | 67.1 | 77.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.4 | 11.2 | 7.5 | 8.1 | 8.5 | 28.1 | 32.5 | 37.7 | 43.7 | 50.7 |
Account Receivables, % | 18.6 | 31.23 | 21.27 | 37.92 | 8.22 | 23.45 | 23.45 | 23.45 | 23.45 | 23.45 |
Inventories | 33.9 | .0 | .0 | .0 | .0 | 23.7 | 27.5 | 31.9 | 37.0 | 42.8 |
Inventories, % | 99.05 | 0.000002776312 | 0.000002828614 | 0.000004683183 | 0 | 19.81 | 19.81 | 19.81 | 19.81 | 19.81 |
Accounts Payable | 10.9 | 11.4 | 12.7 | 13.4 | 13.1 | 41.8 | 48.5 | 56.2 | 65.2 | 75.6 |
Accounts Payable, % | 31.87 | 31.56 | 36.06 | 62.54 | 12.69 | 34.94 | 34.94 | 34.94 | 34.94 | 34.94 |
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, % | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 |
EBITAT | -3.9 | 23.1 | 11.6 | -1.4 | .0 | 18.7 | 21.6 | 25.1 | 29.1 | 33.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2.4 | 73.7 | 51.1 | 36.2 | -.6 | 89.3 | 118.8 | 137.7 | 159.7 | 185.1 |
WACC, % | 8.73 | 8.75 | 8.7 | 8.56 | 8.64 | 8.68 | 8.68 | 8.68 | 8.68 | 8.68 |
PV UFCF | ||||||||||
SUM PV UFCF | 526.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 189 | |||||||||
Terminal Value | 2,828 | |||||||||
Present Terminal Value | 1,866 | |||||||||
Enterprise Value | 2,392 | |||||||||
Net Debt | -11 | |||||||||
Equity Value | 2,403 | |||||||||
Diluted Shares Outstanding, MM | 23 | |||||||||
Equity Value Per Share | 103.39 |
What You Will Get
- Real WHF Financial Data: Pre-filled with WhiteHorse Finance, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See WhiteHorse Finance, Inc.'s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life WHF Financials: Pre-filled historical and projected data for WhiteHorse Finance, Inc. (WHF).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate WhiteHorse’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize WhiteHorse’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based WHF DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates WhiteHorse Finance’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for WhiteHorse Finance, Inc. (WHF)?
- Accuracy: Real WhiteHorse financials ensure data accuracy.
- Flexibility: Designed for users to test and modify inputs freely.
- Time-Saving: Skip the hassle of building a DCF model from scratch.
- Professional-Grade: Developed with CFO-level precision and usability in mind.
- User-Friendly: Easy to use, even for those without advanced financial modeling experience.
Who Should Use WhiteHorse Finance, Inc. (WHF)?
- Institutional Investors: Develop comprehensive investment strategies using detailed financial analyses of WHF.
- Corporate Finance Departments: Evaluate financial performance to inform strategic decisions within the organization.
- Financial Advisors: Equip clients with precise insights into the investment potential of WhiteHorse Finance, Inc. (WHF).
- Academic Researchers and Students: Leverage real-time financial data to enhance learning and research in finance.
- Investment Enthusiasts: Gain a deeper understanding of how companies like WhiteHorse Finance, Inc. (WHF) operate within the financial sector.
What the Template Contains
- Historical Data: Includes WhiteHorse Finance, Inc.'s (WHF) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate WhiteHorse Finance, Inc.'s (WHF) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of WhiteHorse Finance, Inc.'s (WHF) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.