Euro Tech Holdings Company Limited (CLWT) 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
Euro Tech Holdings Company Limited (CLWT) Bundle
Designed for accuracy, our (CLWT) DCF Calculator enables you to evaluate Euro Tech Holdings Company Limited's valuation using real-world financial data, while offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 17.4 | 13.4 | 21.4 | 14.9 | 17.9 | 19.1 | 20.4 | 21.8 | 23.3 | 24.8 |
Revenue Growth, % | 0 | -23.23 | 60.13 | -30.11 | 20.01 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
EBITDA | -.2 | -1.6 | .8 | .2 | 1.7 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | -1.36 | -12.28 | 3.84 | 1.08 | 9.57 | 0.17014 | 0.17014 | 0.17014 | 0.17014 | 0.17014 |
Depreciation | .1 | .0 | .0 | .0 | .0 | .0 | .1 | .1 | .1 | .1 |
Depreciation, % | 0.39657 | 0.36685 | 0.17767 | 0.22075 | 0.08361204 | 0.24909 | 0.24909 | 0.24909 | 0.24909 | 0.24909 |
EBIT | -.3 | -1.7 | .8 | .1 | 1.7 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | -1.76 | -12.65 | 3.67 | 0.85624 | 9.49 | -0.07894917 | -0.07894917 | -0.07894917 | -0.07894917 | -0.07894917 |
Total Cash | 6.0 | 3.5 | 5.3 | 5.6 | 5.5 | 5.9 | 6.3 | 6.7 | 7.1 | 7.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.3 | 3.9 | 3.9 | 2.0 | 3.1 | 3.9 | 4.2 | 4.5 | 4.8 | 5.1 |
Account Receivables, % | 24.6 | 29.27 | 18.37 | 13.1 | 17.1 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 |
Inventories | .6 | .3 | .5 | .6 | .7 | .6 | .7 | .7 | .8 | .8 |
Inventories, % | 3.37 | 2.56 | 2.56 | 4.03 | 4.03 | 3.31 | 3.31 | 3.31 | 3.31 | 3.31 |
Accounts Payable | 3.9 | 2.4 | 3.2 | 2.3 | 3.5 | 3.4 | 3.7 | 3.9 | 4.2 | 4.4 |
Accounts Payable, % | 22.5 | 17.92 | 14.73 | 15.25 | 19.26 | 17.93 | 17.93 | 17.93 | 17.93 | 17.93 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -0.1207 | -0.08235382 | -0.01870208 | -0.04682587 | -0.02787068 | -0.05928981 | -0.05928981 | -0.05928981 | -0.05928981 | -0.05928981 |
Tax Rate, % | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 | -7.85 |
EBITAT | -.4 | -1.4 | .8 | .1 | 1.8 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.3 | -2.2 | 1.4 | 1.2 | 1.8 | -.8 | -.1 | -.1 | -.1 | -.1 |
WACC, % | 8.07 | 8.04 | 8.07 | 8.06 | 8.07 | 8.06 | 8.06 | 8.06 | 8.06 | 8.06 |
PV UFCF | ||||||||||
SUM PV UFCF | -.9 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | -1 | |||||||||
Present Terminal Value | -1 | |||||||||
Enterprise Value | -1 | |||||||||
Net Debt | -5 | |||||||||
Equity Value | 4 | |||||||||
Diluted Shares Outstanding, MM | 8 | |||||||||
Equity Value Per Share | 0.47 |
What You Will Get
- Real CLWT Financial Data: Pre-filled with Euro Tech Holdings Company Limited’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Euro Tech Holdings’ intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life CLWT Financials: Pre-filled historical and projected data for Euro Tech Holdings Company Limited.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Euro Tech’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Euro Tech’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based CLWT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, profit margins, and more.
- Instant Calculations: The model automatically computes the intrinsic value of Euro Tech Holdings Company Limited.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose Euro Tech Holdings Company Limited (CLWT) Calculator?
- Accuracy: Utilizes real Euro Tech financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Designed for ease of use, even for those without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing investments in Euro Tech Holdings Company Limited (CLWT).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Euro Tech Holdings Company Limited (CLWT).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Tech Enthusiasts: Gain insights into how technology companies like Euro Tech Holdings Company Limited (CLWT) are assessed in the marketplace.
What the Template Contains
- Pre-Filled DCF Model: Euro Tech Holdings Company Limited’s (CLWT) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for (CLWT).
- Financial Ratios: Analyze (CLWT)’s profitability, leverage, and efficiency metrics.
- Editable Inputs: Adjust assumptions like growth, margins, and CAPEX to suit your scenarios for (CLWT).
- Financial Statements: Access annual and quarterly reports for in-depth analysis of (CLWT).
- Interactive Dashboard: Visualize key valuation metrics and results for (CLWT) effortlessly.