|
LightPath Technologies, Inc. (LPTH) DCF Valuation
US | Technology | Hardware, Equipment & Parts | 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
LightPath Technologies, Inc. (LPTH) Bundle
Explore the financial potential of LightPath Technologies, Inc. (LPTH) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of LightPath Technologies, Inc. (LPTH) and enhance your investment approach.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 35.0 | 38.5 | 35.6 | 32.9 | 31.7 | 31.0 | 30.4 | 29.7 | 29.1 | 28.5 |
| Revenue Growth, % | 0 | 10 | -7.55 | -7.38 | -3.67 | -2.15 | -2.15 | -2.15 | -2.15 | -2.15 |
| EBITDA | 5.5 | 1.5 | 1.2 | -.4 | -3.7 | .6 | .6 | .6 | .6 | .6 |
| EBITDA, % | 15.62 | 3.83 | 3.28 | -1.08 | -11.66 | 2 | 2 | 2 | 2 | 2 |
| Depreciation | 3.4 | 3.5 | 3.6 | 3.2 | 4.0 | 3.2 | 3.1 | 3.1 | 3.0 | 2.9 |
| Depreciation, % | 9.79 | 9.12 | 10.17 | 9.64 | 12.76 | 10.3 | 10.3 | 10.3 | 10.3 | 10.3 |
| EBIT | 2.0 | -2.0 | -2.4 | -3.5 | -7.7 | -2.6 | -2.5 | -2.5 | -2.4 | -2.4 |
| EBIT, % | 5.83 | -5.29 | -6.89 | -10.72 | -24.42 | -8.3 | -8.3 | -8.3 | -8.3 | -8.3 |
| Total Cash | 5.4 | 6.8 | 5.5 | 4.7 | 3.5 | 4.6 | 4.5 | 4.4 | 4.3 | 4.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.3 | 4.8 | 5.2 | 6.6 | 4.9 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 |
| Account Receivables, % | 18.08 | 12.46 | 14.66 | 20.15 | 15.54 | 16.17 | 16.17 | 16.17 | 16.17 | 16.17 |
| Inventories | 9.0 | 8.7 | 7.0 | 7.4 | 6.6 | 6.9 | 6.7 | 6.6 | 6.5 | 6.3 |
| Inventories, % | 25.69 | 22.51 | 19.64 | 22.5 | 20.65 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 |
| Accounts Payable | 2.6 | 2.9 | 3.1 | 2.6 | 3.2 | 2.6 | 2.5 | 2.5 | 2.4 | 2.4 |
| Accounts Payable, % | 7.32 | 7.6 | 8.64 | 7.82 | 10.19 | 8.31 | 8.31 | 8.31 | 8.31 | 8.31 |
| Capital Expenditure | -2.4 | -3.2 | -1.6 | -3.1 | -2.2 | -2.2 | -2.2 | -2.1 | -2.1 | -2.0 |
| Capital Expenditure, % | -6.99 | -8.21 | -4.57 | -9.34 | -6.88 | -7.2 | -7.2 | -7.2 | -7.2 | -7.2 |
| Tax Rate, % | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 | -0.85002 |
| EBITAT | 1.1 | -2.9 | -3.2 | -3.7 | -7.8 | -2.3 | -2.3 | -2.2 | -2.2 | -2.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -10.7 | -.3 | .2 | -6.0 | -2.7 | -2.5 | -1.1 | -1.1 | -1.1 | -1.1 |
| WACC, % | 10.01 | 10.16 | 10.16 | 10.16 | 10.16 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -5.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1 | |||||||||
| Terminal Value | -13 | |||||||||
| Present Terminal Value | -8 | |||||||||
| Enterprise Value | -14 | |||||||||
| Net Debt | 7 | |||||||||
| Equity Value | -21 | |||||||||
| Diluted Shares Outstanding, MM | 38 | |||||||||
| Equity Value Per Share | -0.54 |
What You Will Get
- Pre-Filled Financial Model: LightPath Technologies’ actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates provide immediate insights as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for versatility, enabling repeated use for comprehensive forecasts.
Key Features
- Accurate Financial Data: Obtain reliable pre-loaded historical figures and future forecasts for LightPath Technologies, Inc. (LPTH).
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear charts and summaries to help visualize your valuation outcomes.
- Suitable for All Levels: A straightforward design tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing LightPath Technologies, Inc. (LPTH) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes for LightPath Technologies, Inc. (LPTH).
- 5. Present with Confidence: Share professional valuation insights to support your investment decisions regarding LightPath Technologies, Inc. (LPTH).
Why Choose This Calculator for LightPath Technologies, Inc. (LPTH)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for LPTH.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes LightPath's intrinsic value and Net Present Value.
- Ready-to-Use Data: Includes historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and consultants focusing on LPTH.
Who Should Use LightPath Technologies, Inc. (LPTH)?
- Investors: Gain insights and make informed investment decisions with our advanced optical solutions.
- Optical Engineers: Streamline your design process with our high-quality optical components tailored for various applications.
- Manufacturers: Enhance product performance by integrating our cutting-edge optical technologies.
- Researchers: Explore innovative optical solutions for your projects and experiments.
- Educators and Students: Utilize our resources to enrich learning in optics and photonics disciplines.
What the Template Contains
- Pre-Filled Data: Includes LightPath Technologies’ historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze LightPath Technologies’ profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.