Lightwave Logic, Inc. (LWLG) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Lightwave Logic, Inc. (LWLG) Bundle
Discover the true value of Lightwave Logic, Inc. (LWLG) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes affect the valuation of Lightwave Logic, Inc. (LWLG) – all within a single Excel template.
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -6.0 | -5.9 | -17.8 | -16.2 | -19.7 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | 100 | 100 | -48723.65 | 60 | 60 | 60 | 60 | 60 |
Depreciation | .7 | .8 | .9 | 1.0 | 1.3 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 100 | 100 | 3219.53 | 100 | 100 | 100 | 100 | 100 |
EBIT | -6.7 | -6.7 | -18.6 | -17.2 | -21.0 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | 100 | 100 | -51943.19 | 60 | 60 | 60 | 60 | 60 |
Total Cash | 2.2 | 3.3 | 23.4 | 24.1 | 31.4 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .1 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | -.1 | .0 | .0 | .7 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 100 | 100 | 100 | 100 | 86.06 | 97.21 | 97.21 | 97.21 | 97.21 | 97.21 |
Inventories | .0 | .0 | .0 | .1 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 100 | 100 | -0.00246901 | 80 | 80 | 80 | 80 | 80 |
Accounts Payable | .1 | .2 | .2 | .8 | 1.4 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 3574.13 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -.3 | -.2 | -1.1 | -1.6 | -3.6 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | -8888.23 | -20 | -20 | -20 | -20 | -20 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -6.7 | -6.7 | -18.2 | -17.2 | -21.0 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.2 | -6.2 | -18.4 | -17.9 | -22.0 | -1.4 | .1 | .1 | .1 | .1 |
WACC, % | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 | 13.86 |
PV UFCF | ||||||||||
SUM PV UFCF | -1.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -1 | |||||||||
Net Debt | -29 | |||||||||
Equity Value | 28 | |||||||||
Diluted Shares Outstanding, MM | 115 | |||||||||
Equity Value Per Share | 0.24 |
What You Will Get
- Genuine Lightwave Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Lightwave Logic, Inc. (LWLG).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Adjustments: Automatic recalculations to evaluate the effects of changes on Lightwave Logic’s fair value.
- Dynamic Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Avoid building models from scratch while ensuring accuracy and adaptability.
Key Features
- Advanced DCF Calculator: Provides comprehensive unlevered and levered DCF valuation models tailored for Lightwave Logic, Inc. (LWLG).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to LWLG.
- Editable Forecast Assumptions: Customize growth rates, capital expenditures, and discount rates to fit Lightwave Logic's projections.
- Built-In Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Lightwave Logic, Inc. (LWLG).
- Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of LWLG.
How It Works
- 1. Access the Template: Download and open the Excel file containing Lightwave Logic, Inc.'s (LWLG) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Deliver professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Lightwave Logic, Inc. (LWLG)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Lightwave Logic's intrinsic value and Net Present Value.
- Preloaded Data: Includes historical and projected data for reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on LWLG.
Who Should Use This Product?
- Optoelectronics Students: Explore advanced photonic technologies and their applications with real-world data.
- Researchers: Integrate cutting-edge models into your studies or publications on lightwave technologies.
- Investors: Evaluate your investment strategies and assess valuation scenarios for Lightwave Logic, Inc. (LWLG).
- Market Analysts: Enhance your analysis with a customizable model tailored for the photonics industry.
- Technology Entrepreneurs: Understand how innovative companies like Lightwave Logic, Inc. (LWLG) are evaluated in the market.
What the Template Contains
- Pre-Filled Data: Includes Lightwave Logic, Inc.'s (LWLG) historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on tailored inputs.
- Key Financial Ratios: Assess Lightwave Logic, Inc.'s (LWLG) profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.