|
Eltek Ltd. (ELTK) DCF Valoración
IL | Technology | Hardware, Equipment & Parts | 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
Eltek Ltd. (ELTK) Bundle
¡Descubra el verdadero potencial de Eltek Ltd. (ELTK) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios influyen en la valoración de Eltek Ltd. (ELTK), todo dentro de una sola plantilla de Excel.
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.8 | 36.7 | 33.8 | 39.7 | 46.7 | 50.5 | 54.6 | 59.1 | 63.9 | 69.1 |
Revenue Growth, % | 0 | 5.5 | -7.86 | 17.23 | 17.77 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
EBITDA | 2.9 | 4.6 | 3.7 | 4.5 | 9.2 | 6.4 | 6.9 | 7.4 | 8.0 | 8.7 |
EBITDA, % | 8.32 | 12.6 | 11.03 | 11.38 | 19.61 | 12.59 | 12.59 | 12.59 | 12.59 | 12.59 |
Depreciation | 1.5 | 1.6 | 1.8 | 1.5 | 1.3 | 2.1 | 2.3 | 2.4 | 2.6 | 2.9 |
Depreciation, % | 4.33 | 4.34 | 5.27 | 3.89 | 2.82 | 4.13 | 4.13 | 4.13 | 4.13 | 4.13 |
EBIT | 1.4 | 3.0 | 1.9 | 3.0 | 7.8 | 4.3 | 4.6 | 5.0 | 5.4 | 5.8 |
EBIT, % | 3.99 | 8.26 | 5.76 | 7.49 | 16.79 | 8.46 | 8.46 | 8.46 | 8.46 | 8.46 |
Total Cash | 1.6 | 4.7 | 9.3 | 7.4 | 12.1 | 9.1 | 9.8 | 10.6 | 11.5 | 12.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.6 | 9.1 | 7.0 | 10.4 | 11.3 | 11.9 | 12.9 | 13.9 | 15.0 | 16.3 |
Account Receivables, % | 21.91 | 24.69 | 20.76 | 26.22 | 24.17 | 23.55 | 23.55 | 23.55 | 23.55 | 23.55 |
Inventories | 3.7 | 3.7 | 4.9 | 5.1 | 6.1 | 6.2 | 6.7 | 7.3 | 7.8 | 8.5 |
Inventories, % | 10.73 | 10.09 | 14.47 | 12.94 | 13.14 | 12.27 | 12.27 | 12.27 | 12.27 | 12.27 |
Accounts Payable | 4.2 | 4.5 | 4.0 | 4.8 | 7.5 | 6.5 | 7.0 | 7.6 | 8.2 | 8.9 |
Accounts Payable, % | 12.06 | 12.13 | 11.96 | 12.09 | 16.07 | 12.86 | 12.86 | 12.86 | 12.86 | 12.86 |
Capital Expenditure | -.8 | -1.1 | -1.5 | -3.0 | -2.4 | -2.3 | -2.5 | -2.7 | -2.9 | -3.1 |
Capital Expenditure, % | -2.32 | -2.95 | -4.54 | -7.63 | -5.21 | -4.53 | -4.53 | -4.53 | -4.53 | -4.53 |
Tax Rate, % | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 | 17.68 |
EBITAT | 1.3 | 3.0 | 6.5 | 2.5 | 6.5 | 3.9 | 4.2 | 4.6 | 5.0 | 5.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5.1 | 2.3 | 7.2 | -1.9 | 6.2 | 2.0 | 3.1 | 3.3 | 3.6 | 3.9 |
WACC, % | 6.4 | 6.41 | 6.42 | 6.35 | 6.34 | 6.38 | 6.38 | 6.38 | 6.38 | 6.38 |
PV UFCF | ||||||||||
SUM PV UFCF | 13.0 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 4 | |||||||||
Terminal Value | 118 | |||||||||
Present Terminal Value | 87 | |||||||||
Enterprise Value | 100 | |||||||||
Net Debt | -3 | |||||||||
Equity Value | 102 | |||||||||
Diluted Shares Outstanding, MM | 6 | |||||||||
Equity Value Per Share | 17.20 |
What You Will Get
- Real ELTK Financial Data: Pre-filled with Eltek Ltd.’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 Eltek Ltd.’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 ELTK Data: Pre-populated with Eltek Ltd.'s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Interface: Intuitive, well-structured, suitable for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Eltek Ltd.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust the assumptions.
- Step 5: Analyze the outputs and leverage the results for investment decisions.
Why Choose This Calculator for Eltek Ltd. (ELTK)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Feedback: Watch Eltek’s valuation change dynamically as you tweak your inputs.
- Preloaded Data: Comes equipped with Eltek’s latest financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by analysts and investors for making strategic choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Eltek Ltd. (ELTK) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Eltek Ltd. (ELTK) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how companies like Eltek Ltd. (ELTK) are assessed in the financial market.
What the Template Contains
- Pre-Filled DCF Model: Eltek Ltd.'s (ELTK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Eltek Ltd.'s (ELTK) 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.