nLIGHT, Inc. (LASR) 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
nLIGHT, Inc. (LASR) Bundle
Explore nLIGHT, Inc. (LASR) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate nLIGHT, Inc. (LASR) intrinsic value and enhance your investment approach.
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 | 176.6 | 222.8 | 270.1 | 242.1 | 209.9 | 222.4 | 235.6 | 249.5 | 264.3 | 280.0 |
Revenue Growth, % | 0 | 26.14 | 21.26 | -10.4 | -13.28 | 5.93 | 5.93 | 5.93 | 5.93 | 5.93 |
EBITDA | -.3 | -7.4 | -15.2 | -35.5 | -29.9 | -16.9 | -17.9 | -19.0 | -20.1 | -21.3 |
EBITDA, % | -0.19534 | -3.3 | -5.61 | -14.68 | -14.25 | -7.61 | -7.61 | -7.61 | -7.61 | -7.61 |
Depreciation | 9.6 | 16.6 | 18.3 | 18.7 | 16.0 | 15.6 | 16.5 | 17.5 | 18.5 | 19.6 |
Depreciation, % | 5.42 | 7.45 | 6.78 | 7.73 | 7.64 | 7 | 7 | 7 | 7 | 7 |
EBIT | -9.9 | -24.0 | -33.5 | -54.2 | -45.9 | -32.5 | -34.4 | -36.5 | -38.6 | -40.9 |
EBIT, % | -5.61 | -10.76 | -12.39 | -22.41 | -21.89 | -14.61 | -14.61 | -14.61 | -14.61 | -14.61 |
Total Cash | 117.3 | 102.3 | 146.5 | 108.2 | 112.9 | 117.9 | 124.9 | 132.3 | 140.1 | 148.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 30.0 | 37.8 | 51.2 | 37.9 | 46.9 | 40.4 | 42.8 | 45.4 | 48.1 | 50.9 |
Account Receivables, % | 17.01 | 16.97 | 18.96 | 15.66 | 22.33 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 |
Inventories | 46.1 | 54.7 | 73.7 | 67.6 | 52.2 | 58.1 | 61.6 | 65.3 | 69.1 | 73.2 |
Inventories, % | 26.12 | 24.56 | 27.3 | 27.93 | 24.85 | 26.15 | 26.15 | 26.15 | 26.15 | 26.15 |
Accounts Payable | 12.7 | 21.1 | 26.3 | 17.5 | 12.2 | 17.5 | 18.6 | 19.7 | 20.8 | 22.1 |
Accounts Payable, % | 7.19 | 9.45 | 9.75 | 7.23 | 5.8 | 7.88 | 7.88 | 7.88 | 7.88 | 7.88 |
Capital Expenditure | -13.6 | -24.3 | -21.6 | -21.7 | -5.3 | -17.0 | -18.0 | -19.0 | -20.2 | -21.4 |
Capital Expenditure, % | -7.72 | -10.93 | -7.98 | -8.97 | -2.54 | -7.63 | -7.63 | -7.63 | -7.63 | -7.63 |
Tax Rate, % | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 | 2.29 |
EBITAT | -18.9 | -24.4 | -33.1 | -54.6 | -44.9 | -32.3 | -34.2 | -36.2 | -38.3 | -40.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -86.4 | -40.1 | -63.5 | -47.0 | -33.1 | -27.8 | -40.5 | -42.9 | -45.4 | -48.1 |
WACC, % | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 | 15.1 |
PV UFCF | ||||||||||
SUM PV UFCF | -132.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -49 | |||||||||
Terminal Value | -374 | |||||||||
Present Terminal Value | -185 | |||||||||
Enterprise Value | -318 | |||||||||
Net Debt | -39 | |||||||||
Equity Value | -279 | |||||||||
Diluted Shares Outstanding, MM | 46 | |||||||||
Equity Value Per Share | -6.05 |
What You Will Get
- Pre-Filled Financial Model: nLIGHT, Inc.’s (LASR) actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see results immediately as changes are made.
- 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
- 🔍 Real-Life LASR Financials: Pre-filled historical and projected data for nLIGHT, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate nLIGHT’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize nLIGHT’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for nLIGHT, Inc. (LASR).
- Step 2: Review nLIGHT's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the results and utilize them for investment strategies.
Why Choose This Calculator for nLIGHT, Inc. (LASR)?
- Comprehensive Tool: Offers 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 nLIGHT’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on nLIGHT, Inc. (LASR).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling nLIGHT, Inc. (LASR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for nLIGHT, Inc. (LASR).
- Consultants: Deliver professional valuation insights on nLIGHT, Inc. (LASR) to clients quickly and accurately.
- Business Owners: Understand how companies like nLIGHT, Inc. (LASR) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to nLIGHT, Inc. (LASR).
What the Template Contains
- Preloaded LASR 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.