|
Valoración de DCF de Rand Capital Corporation (RAND)
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
Rand Capital Corporation (RAND) Bundle
¡Simplifique la valoración de Rand Capital Corporation (RAND) con esta calculadora DCF personalizable! Con el Real Rand Capital Corporation (RAND) Financials y los aportes de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Rand Capital Corporation (RAND) 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 | 2.7 | 3.0 | 20.8 | 5.8 | 7.3 | 8.6 | 10.0 | 11.6 | 13.6 | 15.8 |
| Revenue Growth, % | 0 | 11.58 | 583.86 | -72.27 | 27.28 | 16.65 | 16.65 | 16.65 | 16.65 | 16.65 |
| EBITDA | -.5 | -.4 | .1 | .0 | 8.3 | 1.2 | 1.3 | 1.6 | 1.8 | 2.1 |
| EBITDA, % | -19.94 | -13.15 | 0.40939 | 0 | 112.46 | 13.46 | 13.46 | 13.46 | 13.46 | 13.46 |
| Depreciation | 6.3 | -5.4 | -6.3 | 7.0 | .0 | 1.2 | 1.4 | 1.6 | 1.9 | 2.2 |
| Depreciation, % | 232.54 | -176.59 | -30.38 | 120.71 | 0.34068 | 13.99 | 13.99 | 13.99 | 13.99 | 13.99 |
| EBIT | -6.9 | 5.0 | 6.4 | -7.0 | 8.2 | .5 | .6 | .7 | .8 | 1.0 |
| EBIT, % | -252.48 | 163.44 | 30.79 | -120.71 | 112.12 | 6.16 | 6.16 | 6.16 | 6.16 | 6.16 |
| Total Cash | 25.8 | 20.4 | .8 | 4.9 | 3.3 | 5.7 | 6.7 | 7.8 | 9.1 | 10.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .4 | .3 | .3 | .4 | .3 | .6 | .8 | .9 | 1.0 | 1.2 |
| Account Receivables, % | 14.66 | 10.65 | 1.44 | 6.59 | 4.49 | 7.57 | 7.57 | 7.57 | 7.57 | 7.57 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0.000036701342 | 0 | 0.000004809808 | 0.000017345509 | 0 | 0.000011771332 | 0.000011771332 | 0.000011771332 | 0.000011771332 | 0.000011771332 |
| Accounts Payable | .3 | 3.6 | .1 | .1 | .1 | 2.0 | 2.3 | 2.7 | 3.1 | 3.6 |
| Accounts Payable, % | 10.57 | 118.59 | 0.24861 | 1.16 | 1.98 | 22.79 | 22.79 | 22.79 | 22.79 | 22.79 |
| 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, % | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 |
| EBITAT | -5.4 | 1.8 | 6.5 | -11.0 | 8.0 | .4 | .5 | .6 | .7 | .8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | .8 | -.2 | -3.4 | -4.1 | 8.1 | 3.1 | 2.1 | 2.5 | 2.9 | 3.4 |
| WACC, % | 5.9 | 5.19 | 6.25 | 6.25 | 6.2 | 5.96 | 5.96 | 5.96 | 5.96 | 5.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 3 | |||||||||
| Terminal Value | 87 | |||||||||
| Present Terminal Value | 65 | |||||||||
| Enterprise Value | 77 | |||||||||
| Net Debt | 13 | |||||||||
| Equity Value | 64 | |||||||||
| Diluted Shares Outstanding, MM | 3 | |||||||||
| Equity Value Per Share | 24.69 |
What You Will Get
- Real RAND Financial Data: Pre-filled with Rand Capital Corporation’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 Rand Capital Corporation’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
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Rand Capital Corporation (RAND).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily alter growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Rand Capital Corporation (RAND).
- Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based RAND DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Rand Capital Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial strategies.
Why Choose This Calculator for Rand Capital Corporation (RAND)?
- Accurate Data: Utilize real Rand Capital Corporation financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-built calculations save you the effort of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the finance sector.
- User-Friendly: Featuring an intuitive design and step-by-step guidance for ease of use by all individuals.
Who Should Use Rand Capital Corporation (RAND)?
- Finance Students: Explore investment strategies and apply them to real-world scenarios.
- Academics: Utilize Rand Capital's models in your research or teaching materials.
- Investors: Analyze your investment hypotheses and evaluate performance metrics for Rand Capital Corporation (RAND).
- Analysts: Enhance your analysis with a customizable financial model tailored to Rand Capital Corporation (RAND).
- Small Business Owners: Understand how investment firms assess companies like Rand Capital Corporation (RAND).
What the Template Contains
- Pre-Filled DCF Model: Rand Capital Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Rand Capital Corporation’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.