|
Sol-Gel Technologies Ltd. (SLGL) DCF Valuation
IL | Healthcare | Biotechnology | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Sol-Gel Technologies Ltd. (SLGL) Bundle
Gain insight into your Sol-Gel Technologies Ltd. (SLGL) valuation analysis with our state-of-the-art DCF Calculator! Equipped with real (SLGL) data, this Excel template lets you adjust forecasts and assumptions to accurately determine the intrinsic value of Sol-Gel Technologies Ltd. (SLGL).
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 | 22.9 | 8.8 | 31.3 | 3.9 | 1.6 | 1.1 | .8 | .6 | .4 | .3 |
| Revenue Growth, % | 0 | -61.71 | 256.54 | -87.58 | -59.98 | -27.32 | -27.32 | -27.32 | -27.32 | -27.32 |
| EBITDA | -25.1 | -29.3 | 3.8 | -15.7 | -29.0 | -.9 | -.6 | -.5 | -.3 | -.2 |
| EBITDA, % | -109.43 | -333.91 | 12.29 | -403.86 | -1863.77 | -77.54 | -77.54 | -77.54 | -77.54 | -77.54 |
| Depreciation | .9 | .9 | .9 | .6 | .3 | .1 | .1 | .1 | .0 | .0 |
| Depreciation, % | 3.87 | 10.79 | 2.81 | 14.47 | 22.01 | 10.79 | 10.79 | 10.79 | 10.79 | 10.79 |
| EBIT | -26.0 | -30.2 | 3.0 | -16.2 | -29.3 | -.9 | -.6 | -.5 | -.3 | -.2 |
| EBIT, % | -113.3 | -344.69 | 9.48 | -418.34 | -1885.78 | -78.1 | -78.1 | -78.1 | -78.1 | -78.1 |
| Total Cash | 50.4 | 50.2 | 43.2 | 33.6 | 38.0 | 1.1 | .8 | .6 | .4 | .3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.1 | 2.2 | 13.1 | 7.9 | .4 | .5 | .3 | .2 | .2 | .1 |
| Account Receivables, % | 17.99 | 24.55 | 41.78 | 202.37 | 24.26 | 41.71 | 41.71 | 41.71 | 41.71 | 41.71 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0.00000436605 | 0 | 0.000003197749 | 0.000025753284 | 0 | 0.000006663416 | 0.000006663416 | 0.000006663416 | 0.000006663416 | 0.000006663416 |
| Accounts Payable | 1.7 | 1.2 | .8 | .3 | .2 | .1 | .1 | .0 | .0 | .0 |
| Accounts Payable, % | 7.47 | 13.72 | 2.45 | 6.46 | 9.91 | 8 | 8 | 8 | 8 | 8 |
| Capital Expenditure | -.6 | -.4 | -.1 | -.2 | -.1 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -2.61 | -5.12 | -0.45728 | -4.4 | -8.62 | -4.24 | -4.24 | -4.24 | -4.24 | -4.24 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -26.0 | -28.3 | 4.0 | -14.8 | -29.3 | -.9 | -.6 | -.5 | -.3 | -.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -28.1 | -26.3 | -6.6 | -9.7 | -21.7 | -.9 | -.5 | -.3 | -.2 | -.2 |
| WACC, % | 11.63 | 11.61 | 11.63 | 11.6 | 11.63 | 11.62 | 11.62 | 11.62 | 11.62 | 11.62 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -2 | |||||||||
| Present Terminal Value | -1 | |||||||||
| Enterprise Value | -3 | |||||||||
| Net Debt | -6 | |||||||||
| Equity Value | 3 | |||||||||
| Diluted Shares Outstanding, MM | 27 | |||||||||
| Equity Value Per Share | 0.11 |
What You Will Get
- Real SLGL Financial Data: Pre-filled with Sol-Gel Technologies' historical and projected data for precise analysis.
- Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
- Automatic Calculations: Instantly see Sol-Gel Technologies' intrinsic value update based on your adjustments.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: A straightforward layout and clear instructions suitable for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Sol-Gel Technologies Ltd. (SLGL).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to SLGL.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as per Sol-Gel's financial outlook.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios relevant to Sol-Gel Technologies Ltd. (SLGL).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Sol-Gel Technologies Ltd. (SLGL) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the critical metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Sol-Gel Technologies Ltd.'s (SLGL) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the generated outputs.
Why Choose This Calculator for Sol-Gel Technologies Ltd. (SLGL)?
- Accurate Data: Utilize real financials from Sol-Gel Technologies to ensure dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the biotech sector.
- User-Friendly: Designed with an intuitive interface and clear instructions for users of all experience levels.
Who Should Use This Product?
- Biotechnology Students: Explore drug development processes and apply them to real-world scenarios.
- Researchers: Utilize advanced models in your studies on pharmaceutical innovations.
- Investors: Evaluate your investment strategies and analyze the market performance of Sol-Gel Technologies Ltd. (SLGL).
- Market Analysts: Enhance your analysis with a customizable framework for assessing biotech companies.
- Healthcare Entrepreneurs: Understand the evaluation methods used for assessing biotech firms like Sol-Gel Technologies Ltd. (SLGL).
What the Template Contains
- Historical Data: Contains Sol-Gel Technologies Ltd.'s (SLGL) previous financials and foundational forecasts.
- DCF and Levered DCF Models: Comprehensive templates for calculating Sol-Gel's intrinsic value.
- WACC Sheet: Pre-configured calculations for Weighted Average Cost of Capital.
- Editable Inputs: Adjust key drivers such as growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: An extensive breakdown of Sol-Gel Technologies Ltd.'s (SLGL) financials.
- Interactive Dashboard: Dynamically visualize valuation results and projections.