Hurco Companies, Inc. (HURC) 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
Hurco Companies, Inc. (HURC) Bundle
Explore the financial potential of Hurco Companies, Inc. (HURC) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Hurco Companies, Inc. (HURC) and enhance your investment decisions.
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 | 263.4 | 170.6 | 235.2 | 250.8 | 227.8 | 227.9 | 227.9 | 228.0 | 228.0 | 228.1 |
Revenue Growth, % | 0 | -35.22 | 37.84 | 6.64 | -9.17 | 0.02346696 | 0.02346696 | 0.02346696 | 0.02346696 | 0.02346696 |
EBITDA | 27.1 | -6.2 | 14.3 | 15.8 | 11.1 | 10.9 | 10.9 | 10.9 | 10.9 | 10.9 |
EBITDA, % | 10.3 | -3.61 | 6.1 | 6.31 | 4.89 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
Depreciation | 3.7 | 4.5 | 4.2 | 3.9 | 4.1 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 |
Depreciation, % | 1.42 | 2.66 | 1.78 | 1.56 | 1.8 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 |
EBIT | 23.4 | -10.7 | 10.1 | 11.9 | 7.0 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 |
EBIT, % | 8.88 | -6.28 | 4.31 | 4.75 | 3.09 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
Total Cash | 56.9 | 57.9 | 84.1 | 63.9 | 41.8 | 61.6 | 61.6 | 61.6 | 61.6 | 61.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 43.3 | 27.7 | 42.6 | 38.4 | 40.0 | 38.1 | 38.1 | 38.1 | 38.1 | 38.2 |
Account Receivables, % | 16.43 | 16.23 | 18.12 | 15.33 | 17.54 | 16.73 | 16.73 | 16.73 | 16.73 | 16.73 |
Inventories | 148.9 | 149.9 | 148.2 | 156.2 | 158.0 | 154.5 | 154.5 | 154.6 | 154.6 | 154.6 |
Inventories, % | 56.52 | 87.83 | 63.02 | 62.28 | 69.34 | 67.8 | 67.8 | 67.8 | 67.8 | 67.8 |
Accounts Payable | 34.0 | 27.6 | 48.9 | 40.7 | 29.7 | 36.1 | 36.1 | 36.1 | 36.1 | 36.1 |
Accounts Payable, % | 12.9 | 16.2 | 20.78 | 16.23 | 13.02 | 15.83 | 15.83 | 15.83 | 15.83 | 15.83 |
Capital Expenditure | -4.9 | -1.7 | -2.4 | -2.2 | -2.6 | -2.7 | -2.7 | -2.7 | -2.7 | -2.7 |
Capital Expenditure, % | -1.85 | -0.97054 | -1.01 | -0.87435 | -1.13 | -1.17 | -1.17 | -1.17 | -1.17 | -1.17 |
Tax Rate, % | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 | 35.02 |
EBITAT | 17.5 | -6.2 | 6.8 | 8.2 | 4.6 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -141.7 | 5.0 | 16.6 | -2.0 | -8.2 | 17.8 | 6.0 | 6.0 | 6.0 | 6.0 |
WACC, % | 6.05 | 5.99 | 6.02 | 6.03 | 6.01 | 6.02 | 6.02 | 6.02 | 6.02 | 6.02 |
PV UFCF | ||||||||||
SUM PV UFCF | 36.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 6 | |||||||||
Terminal Value | 152 | |||||||||
Present Terminal Value | 114 | |||||||||
Enterprise Value | 150 | |||||||||
Net Debt | -30 | |||||||||
Equity Value | 181 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 27.67 |
What You Will Get
- Real Hurco Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Hurco Companies, Inc. (HURC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit Hurco's financial model.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Hurco’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Hurco Companies, Inc. (HURC).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Hurco’s financial analysis.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Hurco Companies, Inc. (HURC).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to Hurco's financials.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Hurco's projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Hurco Companies, Inc. (HURC).
- Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-configured Excel file containing Hurco Companies, Inc.'s (HURC) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and evaluate outcomes immediately.
- Make Decisions: Leverage the valuation results to inform your investment strategy.
Why Choose Hurco Companies, Inc. (HURC)?
- Innovative Technology: Leverage cutting-edge CNC machinery that enhances productivity.
- Proven Performance: Our equipment is designed to deliver consistent results in various manufacturing environments.
- Custom Solutions: We offer tailored machinery options to meet your specific production needs.
- User-Friendly Interface: Our machines feature intuitive controls that simplify operation and training.
- Industry Expertise: Backed by years of experience, we understand the demands of modern manufacturing.
Who Should Use This Product?
- Investors: Evaluate Hurco Companies, Inc.'s (HURC) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Hurco.
- Startup Founders: Discover insights into how companies like Hurco are assessed in the market.
- Consultants: Provide expert valuation analyses and reports for clients considering Hurco.
- Students and Educators: Utilize Hurco's data to learn and teach valuation strategies in real-world scenarios.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Hurco Companies, Inc. (HURC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Hurco Companies, Inc. (HURC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.