|
Valoración de DCF de Supercom Ltd. (SPCB)
IL | Industrials | Security & Protection Services | 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
SuperCom Ltd. (SPCB) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF de Supercom Ltd. (SPCB)! Esta herramienta utiliza datos reales de Supercom y permite suposiciones ajustables, equiparlo para pronosticar, analizar y valorar Supercom Ltd. (SPCB) 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 | 16.5 | 11.8 | 12.3 | 17.6 | 26.6 | 31.2 | 36.7 | 43.1 | 50.7 | 59.6 |
| Revenue Growth, % | 0 | -28.56 | 4.22 | 43.87 | 50.55 | 17.52 | 17.52 | 17.52 | 17.52 | 17.52 |
| EBITDA | -6.4 | -1.3 | -4.3 | -3.3 | 1.5 | -6.1 | -7.2 | -8.4 | -9.9 | -11.7 |
| EBITDA, % | -38.77 | -11.3 | -34.75 | -18.67 | 5.53 | -19.59 | -19.59 | -19.59 | -19.59 | -19.59 |
| Depreciation | 3.1 | 2.7 | 2.2 | 2.7 | 3.0 | 5.4 | 6.4 | 7.5 | 8.8 | 10.3 |
| Depreciation, % | 18.99 | 23.11 | 18.16 | 15.25 | 11.22 | 17.34 | 17.34 | 17.34 | 17.34 | 17.34 |
| EBIT | -9.5 | -4.1 | -6.5 | -6.0 | -1.5 | -11.5 | -13.6 | -15.9 | -18.7 | -22.0 |
| EBIT, % | -57.76 | -34.41 | -52.91 | -33.92 | -5.68 | -36.94 | -36.94 | -36.94 | -36.94 | -36.94 |
| Total Cash | .1 | 3.1 | 3.5 | 4.0 | 5.2 | 6.2 | 7.2 | 8.5 | 10.0 | 11.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 13.0 | 12.4 | 11.1 | 10.9 | 13.4 | 23.8 | 28.0 | 32.9 | 38.6 | 45.4 |
| Account Receivables, % | 79.19 | 105.58 | 90.17 | 61.49 | 50.27 | 76.22 | 76.22 | 76.22 | 76.22 | 76.22 |
| Inventories | 2.6 | 2.4 | 3.6 | 3.4 | 2.5 | 5.9 | 6.9 | 8.1 | 9.6 | 11.2 |
| Inventories, % | 16.06 | 20.42 | 29.03 | 19.33 | 9.42 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 |
| Accounts Payable | 3.5 | 2.9 | 1.4 | 1.3 | 1.9 | 4.5 | 5.2 | 6.2 | 7.2 | 8.5 |
| Accounts Payable, % | 21.49 | 24.3 | 11.37 | 7.18 | 7.09 | 14.29 | 14.29 | 14.29 | 14.29 | 14.29 |
| Capital Expenditure | -1.2 | -1.4 | -1.7 | -2.1 | -3.4 | -3.6 | -4.2 | -5.0 | -5.8 | -6.9 |
| Capital Expenditure, % | -7.13 | -11.91 | -13.72 | -12.11 | -12.67 | -11.51 | -11.51 | -11.51 | -11.51 | -11.51 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -9.6 | -4.1 | -6.5 | -5.8 | -1.5 | -11.4 | -13.4 | -15.8 | -18.6 | -21.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -19.7 | -2.6 | -7.2 | -5.0 | -2.9 | -20.9 | -15.7 | -18.5 | -21.7 | -25.5 |
| WACC, % | 6.38 | 6.38 | 6.38 | 6.22 | 6.38 | 6.35 | 6.35 | 6.35 | 6.35 | 6.35 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -84.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -26 | |||||||||
| Terminal Value | -599 | |||||||||
| Present Terminal Value | -440 | |||||||||
| Enterprise Value | -525 | |||||||||
| Net Debt | 30 | |||||||||
| Equity Value | -555 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | -82.06 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real SuperCom Ltd. (SPCB) financials.
- Actual Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect SuperCom Ltd. (SPCB)’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Design: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive Data Access: SuperCom Ltd.’s (SPCB) historical financial records and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Instantly view SuperCom Ltd.’s (SPCB) intrinsic value as it updates live.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based SuperCom Ltd. (SPCB) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates SuperCom Ltd.’s (SPCB) intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for SuperCom Ltd. (SPCB)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financials: SuperCom Ltd.'s historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the entire process.
Who Should Use This Product?
- Investors: Evaluate SuperCom Ltd.'s (SPCB) market position before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methods and validate financial forecasts for SuperCom Ltd. (SPCB).
- Startup Founders: Understand the valuation strategies used by established companies like SuperCom Ltd. (SPCB).
- Consultants: Create comprehensive valuation reports to assist clients interested in SuperCom Ltd. (SPCB).
- Students and Educators: Utilize real data from SuperCom Ltd. (SPCB) to practice and teach valuation concepts.
What the SuperCom Ltd. (SPCB) Template Contains
- Preloaded SPCB Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.