Siebert Financial Corp. (SIEB) 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
Siebert Financial Corp. (SIEB) Bundle
Explore Siebert Financial Corp.'s (SIEB) financial future with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to determine Siebert Financial Corp.'s (SIEB) intrinsic value and enhance your investment strategy.
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 | 28.6 | 54.9 | 67.5 | 50.1 | 71.5 | 95.1 | 126.4 | 168.1 | 223.6 | 297.3 |
| Revenue Growth, % | 0 | 91.91 | 23.03 | -25.78 | 42.74 | 32.97 | 32.97 | 32.97 | 32.97 | 32.97 |
| EBITDA | 5.4 | 5.8 | 10.5 | -2.9 | 13.5 | 11.1 | 14.8 | 19.6 | 26.1 | 34.7 |
| EBITDA, % | 18.96 | 10.66 | 15.51 | -5.7 | 18.94 | 11.67 | 11.67 | 11.67 | 11.67 | 11.67 |
| Depreciation | 38.4 | 51.3 | 59.9 | 49.2 | 2.0 | 72.9 | 96.9 | 128.9 | 171.4 | 227.9 |
| Depreciation, % | 134.15 | 93.54 | 88.68 | 98.24 | 2.82 | 76.66 | 76.66 | 76.66 | 76.66 | 76.66 |
| EBIT | -32.9 | -45.5 | -49.4 | -52.1 | 11.5 | -64.7 | -86.0 | -114.3 | -152.0 | -202.1 |
| EBIT, % | -115.19 | -82.88 | -73.17 | -103.94 | 16.11 | -67.99 | -67.99 | -67.99 | -67.99 | -67.99 |
| Total Cash | 3.1 | 912.0 | 947.3 | 363.8 | 418.5 | 78.1 | 103.9 | 138.1 | 183.7 | 244.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 90.6 | 112.9 | 95.8 | 63.4 | 79.4 | 95.1 | 126.4 | 168.1 | 223.6 | 297.3 |
| Account Receivables, % | 316.92 | 205.69 | 141.96 | 126.48 | 110.96 | 100 | 100 | 100 | 100 | 100 |
| Inventories | -.5 | 323.6 | 325.9 | -98.9 | .0 | 18.7 | 24.8 | 33.0 | 43.9 | 58.4 |
| Inventories, % | -1.8 | 589.81 | 482.82 | -197.33 | 0 | 19.64 | 19.64 | 19.64 | 19.64 | 19.64 |
| Accounts Payable | 310.5 | 384.3 | 380.3 | 323.9 | 293.4 | 95.1 | 126.4 | 168.1 | 223.6 | 297.3 |
| Accounts Payable, % | 1086.05 | 700.36 | 563.42 | 646.48 | 410.29 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -2.3 | -.4 | -7.5 | -2.1 | -1.7 | -5.0 | -6.6 | -8.8 | -11.7 | -15.6 |
| Capital Expenditure, % | -7.95 | -0.74719 | -11.04 | -4.19 | -2.33 | -5.25 | -5.25 | -5.25 | -5.25 | -5.25 |
| Tax Rate, % | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 | 30.49 |
| EBITAT | -25.1 | -42.3 | -37.0 | -36.3 | 8.0 | -49.6 | -66.0 | -87.7 | -116.6 | -155.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 231.4 | -264.0 | 26.2 | 411.6 | -137.0 | -214.4 | 18.2 | 24.2 | 32.1 | 42.7 |
| WACC, % | 5.78 | 5.82 | 5.77 | 5.76 | 5.76 | 5.78 | 5.78 | 5.78 | 5.78 | 5.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -108.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 44 | |||||||||
| Terminal Value | 1,154 | |||||||||
| Present Terminal Value | 871 | |||||||||
| Enterprise Value | 763 | |||||||||
| Net Debt | 2 | |||||||||
| Equity Value | 762 | |||||||||
| Diluted Shares Outstanding, MM | 37 | |||||||||
| Equity Value Per Share | 20.54 |
What You Will Receive
- Authentic Siebert Data: Preloaded financials – encompassing revenue to EBIT – based on real and projected figures.
- Comprehensive Customization: Modify all key parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalculations to evaluate the effects of changes on Siebert Financial Corp.'s (SIEB) fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Avoid building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Customizable Investment Parameters: Adjust essential factors such as asset allocation, risk tolerance, and expected returns.
- Instant Portfolio Valuation: Provides real-time calculations of portfolio value, risk metrics, and performance analytics.
- Industry-Leading Precision: Incorporates Siebert Financial Corp.'s (SIEB) market insights for accurate investment assessments.
- Effortless Scenario Planning: Easily evaluate various market conditions and their potential impact on your investments.
- Efficiency-Boosting Solution: Streamline the investment analysis process without the hassle of manual calculations.
How It Works
- Download the Template: Gain immediate access to the Excel-based SIEB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells to set growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Siebert Financial Corp.’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose Siebert Financial Corp. (SIEB)?
- Streamlined Processes: Access a comprehensive suite of financial tools without starting from scratch.
- Enhanced Accuracy: Dependable financial insights and methodologies minimize valuation errors.
- Completely Customizable: Adjust the tools to align with your unique financial strategies and forecasts.
- User-Friendly Design: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Professional Investors: Create comprehensive and trustworthy valuation models for investment analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
- Consultants and Advisors: Deliver precise valuation insights for Siebert Financial Corp. (SIEB) to clients.
- Students and Educators: Utilize real-world data for practicing and teaching financial modeling techniques.
- Finance Enthusiasts: Gain insights into how financial firms like Siebert Financial Corp. (SIEB) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Siebert Financial Corp. (SIEB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Siebert Financial Corp. (SIEB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.