|
AEye, Inc. (LIDR) DCF Valuation
US | Consumer Cyclical | Auto - Parts | NASDAQ
|
- ✓ 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
AEye, Inc. (LIDR) Bundle
Looking to determine AEye, Inc.'s intrinsic value? Our LIDR DCF Calculator integrates real-world data with comprehensive customization features, allowing you to adjust forecasts and enhance your investment strategy.
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 | 1.5 | 1.6 | 3.0 | 3.6 | 1.5 | 1.7 | 1.9 | 2.2 | 2.6 | 2.9 |
Revenue Growth, % | 0 | 7.71 | 90.44 | 21.28 | -59.86 | 14.89 | 14.89 | 14.89 | 14.89 | 14.89 |
EBITDA | .0 | -24.1 | -61.4 | -94.5 | -85.5 | -1.3 | -1.5 | -1.8 | -2.0 | -2.3 |
EBITDA, % | -0.03751705 | -1527.99 | -2043.5 | -2591.64 | -5841.67 | -80.01 | -80.01 | -80.01 | -80.01 | -80.01 |
Depreciation | .3 | .9 | 1.0 | 2.8 | 1.5 | 1.0 | 1.1 | 1.3 | 1.5 | 1.7 |
Depreciation, % | 23.4 | 58.39 | 33.72 | 75.68 | 105.67 | 58.24 | 58.24 | 58.24 | 58.24 | 58.24 |
EBIT | -.3 | -25.0 | -62.5 | -97.3 | -87.1 | -1.4 | -1.6 | -1.9 | -2.2 | -2.5 |
EBIT, % | -23.43 | -1586.38 | -2077.22 | -2667.32 | -5947.34 | -84.69 | -84.69 | -84.69 | -84.69 | -84.69 |
Total Cash | .0 | 15.3 | 164.0 | 94.2 | 36.5 | 1.4 | 1.6 | 1.8 | 2.0 | 2.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .1 | .2 | 4.2 | .6 | .1 | .5 | .6 | .6 | .7 | .9 |
Account Receivables, % | 9.75 | 9.88 | 140.41 | 16.92 | 8.95 | 29.1 | 29.1 | 29.1 | 29.1 | 29.1 |
Inventories | 2.4 | 2.7 | 4.1 | 4.6 | .6 | 1.5 | 1.7 | 2.0 | 2.2 | 2.6 |
Inventories, % | 164.94 | 168.14 | 135.85 | 124.84 | 39.82 | 87.96 | 87.96 | 87.96 | 87.96 | 87.96 |
Accounts Payable | 4.5 | 1.8 | 2.5 | 3.2 | 3.4 | 1.6 | 1.8 | 2.1 | 2.4 | 2.8 |
Accounts Payable, % | 304.84 | 114.44 | 84.54 | 88.24 | 235.11 | 94.55 | 94.55 | 94.55 | 94.55 | 94.55 |
Capital Expenditure | -1.2 | -4.0 | -1.0 | -4.2 | -2.0 | -1.4 | -1.6 | -1.8 | -2.1 | -2.4 |
Capital Expenditure, % | -80.35 | -255.6 | -33.95 | -115.16 | -133.27 | -82.86 | -82.86 | -82.86 | -82.86 | -82.86 |
Tax Rate, % | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 | -0.06546532 |
EBITAT | -.3 | -26.4 | -67.1 | -97.3 | -87.1 | -1.4 | -1.6 | -1.9 | -2.2 | -2.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | .7 | -32.4 | -71.9 | -95.0 | -82.9 | -4.9 | -2.2 | -2.5 | -2.9 | -3.3 |
WACC, % | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 | 10.13 |
PV UFCF | ||||||||||
SUM PV UFCF | -12.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -3 | |||||||||
Terminal Value | -41 | |||||||||
Present Terminal Value | -25 | |||||||||
Enterprise Value | -38 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | -38 | |||||||||
Diluted Shares Outstanding, MM | 6 | |||||||||
Equity Value Per Share | -6.51 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: AEye, Inc. (LIDR) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Real-Time LIDR Data: Pre-filled with AEye, Inc.'s historical performance metrics and future growth estimates.
- Customizable Parameters: Modify key inputs such as revenue projections, profit margins, discount rates, tax obligations, and capital investments.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value reflecting your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different potential valuation results.
- Intuitive Interface: Clean, organized layout designed for both industry experts and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered AEye, Inc. (LIDR) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for AEye, Inc. (LIDR)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for AEye, Inc. (LIDR)?
- Accurate Data: Access to real AEye financials guarantees trustworthy valuation results.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you from starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate layout and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate AEye, Inc.'s (LIDR) market potential before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess future projections for AEye, Inc. (LIDR).
- Startup Founders: Understand the valuation strategies of innovative tech companies like AEye, Inc. (LIDR).
- Consultants: Provide detailed valuation analyses and reports for clients interested in AEye, Inc. (LIDR).
- Students and Educators: Utilize current data from AEye, Inc. (LIDR) to enhance learning on valuation practices.
What the Template Contains
- Pre-Filled Data: Contains AEye, Inc.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate AEye, Inc.'s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.