LiqTech International, Inc. (LIQT) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
LiqTech International, Inc. (LIQT) Bundle
Discover the true value of LiqTech International, Inc. (LIQT) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how different changes affect LiqTech International, Inc. (LIQT) valuation – 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 | 32.6 | 22.5 | 18.3 | 16.0 | 18.0 | 15.8 | 13.8 | 12.1 | 10.6 | 9.3 |
| Revenue Growth, % | 0 | -30.98 | -18.88 | -12.54 | 12.63 | -12.44 | -12.44 | -12.44 | -12.44 | -12.44 |
| EBITDA | 1.1 | -7.3 | -7.9 | -12.5 | -5.1 | -5.7 | -4.9 | -4.3 | -3.8 | -3.3 |
| EBITDA, % | 3.38 | -32.52 | -43.49 | -78.42 | -28.24 | -35.86 | -35.86 | -35.86 | -35.86 | -35.86 |
| Depreciation | 1.3 | 2.8 | 2.7 | 2.6 | 3.1 | 2.1 | 1.8 | 1.6 | 1.4 | 1.2 |
| Depreciation, % | 4.12 | 12.55 | 15 | 16.18 | 17.45 | 13.06 | 13.06 | 13.06 | 13.06 | 13.06 |
| EBIT | -.2 | -10.2 | -10.7 | -15.1 | -8.2 | -7.7 | -6.8 | -5.9 | -5.2 | -4.5 |
| EBIT, % | -0.73169 | -45.07 | -58.49 | -94.6 | -45.69 | -48.92 | -48.92 | -48.92 | -48.92 | -48.92 |
| Total Cash | 7.1 | 2.7 | 15.4 | 16.6 | 9.5 | 8.5 | 7.5 | 6.5 | 5.7 | 5.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 11.9 | 5.8 | 3.9 | 4.6 | 6.1 | 4.6 | 4.0 | 3.5 | 3.1 | 2.7 |
| Account Receivables, % | 36.58 | 25.91 | 21.15 | 28.55 | 33.68 | 29.17 | 29.17 | 29.17 | 29.17 | 29.17 |
| Inventories | 5.2 | 5.5 | 5.4 | 4.1 | 5.3 | 3.9 | 3.4 | 3.0 | 2.6 | 2.3 |
| Inventories, % | 15.93 | 24.51 | 29.67 | 25.42 | 29.26 | 24.96 | 24.96 | 24.96 | 24.96 | 24.96 |
| Accounts Payable | 4.3 | 2.3 | 1.6 | 1.4 | 2.4 | 1.7 | 1.5 | 1.3 | 1.2 | 1.0 |
| Accounts Payable, % | 13.29 | 10.35 | 9.01 | 8.69 | 13.58 | 10.99 | 10.99 | 10.99 | 10.99 | 10.99 |
| Capital Expenditure | -2.6 | -3.8 | -1.1 | -1.7 | -2.9 | -1.8 | -1.6 | -1.4 | -1.2 | -1.1 |
| Capital Expenditure, % | -7.87 | -16.91 | -6.2 | -10.58 | -16.07 | -11.53 | -11.53 | -11.53 | -11.53 | -11.53 |
| Tax Rate, % | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
| EBITAT | .0 | -9.7 | -10.6 | -14.9 | -8.0 | -6.0 | -5.3 | -4.6 | -4.0 | -3.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -14.0 | -6.9 | -7.6 | -13.6 | -9.4 | -3.7 | -4.2 | -3.7 | -3.2 | -2.8 |
| WACC, % | 4.27 | 6.53 | 6.62 | 6.59 | 6.58 | 6.12 | 6.12 | 6.12 | 6.12 | 6.12 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -15.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -3 | |||||||||
| Terminal Value | -70 | |||||||||
| Present Terminal Value | -52 | |||||||||
| Enterprise Value | -67 | |||||||||
| Net Debt | 3 | |||||||||
| Equity Value | -70 | |||||||||
| Diluted Shares Outstanding, MM | 6 | |||||||||
| Equity Value Per Share | -12.29 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financials for LiqTech International, Inc. (LIQT).
- Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe how your inputs affect the valuation of LiqTech International, Inc. (LIQT).
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for LiqTech International, Inc. (LIQT).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the industry.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit LiqTech's market outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to LiqTech International, Inc. (LIQT).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for streamlined analysis and decision-making.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered LiqTech International, Inc. (LIQT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for LiqTech International, Inc. (LIQT)'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for LiqTech International, Inc. (LIQT)?
- Designed for Industry Experts: A sophisticated tool utilized by engineers, financial analysts, and industry consultants.
- Comprehensive Data: LiqTech’s historical and projected financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Investors: Evaluate LiqTech International's (LIQT) market potential before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts for LiqTech.
- Startup Founders: Gain insights into how emerging companies like LiqTech are appraised in the market.
- Consultants: Provide comprehensive valuation analyses and reports for clients interested in LiqTech.
- Students and Educators: Utilize current data to explore and teach valuation strategies related to LiqTech International.
What the Template Contains
- Pre-Filled DCF Model: LiqTech International’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate LiqTech International’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.