Hawthorn Bancshares, Inc. (HWBK) 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
Hawthorn Bancshares, Inc. (HWBK) Bundle
Evaluate the financial outlook of Hawthorn Bancshares, Inc. (HWBK) with confidence! This (HWBK) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, profit margins, and other essential assumptions to align with your 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 | 57.6 | 68.0 | 75.1 | 72.7 | 52.8 | 52.5 | 52.2 | 51.9 | 51.7 | 51.4 |
| Revenue Growth, % | 0 | 17.94 | 10.45 | -3.13 | -27.41 | -0.53854 | -0.53854 | -0.53854 | -0.53854 | -0.53854 |
| EBITDA | 22.0 | 19.7 | 30.5 | 27.2 | 2.5 | 15.8 | 15.7 | 15.6 | 15.5 | 15.4 |
| EBITDA, % | 38.17 | 29.04 | 40.62 | 37.44 | 4.81 | 30.02 | 30.02 | 30.02 | 30.02 | 30.02 |
| Depreciation | 2.1 | 2.3 | 2.3 | 2.1 | 2.1 | 1.8 | 1.8 | 1.8 | 1.7 | 1.7 |
| Depreciation, % | 3.58 | 3.33 | 3.04 | 2.94 | 3.99 | 3.38 | 3.38 | 3.38 | 3.38 | 3.38 |
| EBIT | 19.9 | 17.5 | 28.2 | 25.1 | .4 | 14.0 | 13.9 | 13.8 | 13.8 | 13.7 |
| EBIT, % | 34.59 | 25.71 | 37.58 | 34.5 | 0.81832 | 26.64 | 26.64 | 26.64 | 26.64 | 26.64 |
| Total Cash | 208.5 | 226.6 | 333.4 | 337.4 | 93.5 | 52.5 | 52.2 | 51.9 | 51.7 | 51.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.5 | 6.6 | 6.6 | 8.0 | .0 | 4.3 | 4.3 | 4.2 | 4.2 | 4.2 |
| Account Receivables, % | 11.24 | 9.77 | 8.82 | 10.94 | 0 | 8.15 | 8.15 | 8.15 | 8.15 | 8.15 |
| Inventories | -108.2 | -208.7 | -182.2 | -103.4 | .0 | -42.0 | -41.8 | -41.6 | -41.3 | -41.1 |
| Inventories, % | -187.81 | -306.99 | -242.75 | -142.21 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 1.1 | .8 | .3 | .9 | 1.8 | .9 | .9 | .8 | .8 | .8 |
| Accounts Payable, % | 1.97 | 1.23 | 0.37562 | 1.24 | 3.36 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| Capital Expenditure | -2.2 | -1.8 | -.6 | -2.6 | -2.1 | -1.5 | -1.5 | -1.5 | -1.5 | -1.5 |
| Capital Expenditure, % | -3.76 | -2.69 | -0.7872 | -3.53 | -3.97 | -2.95 | -2.95 | -2.95 | -2.95 | -2.95 |
| Tax Rate, % | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 | -121.3 |
| EBITAT | 16.1 | 14.3 | 22.5 | 20.8 | 1.0 | 11.9 | 11.8 | 11.8 | 11.7 | 11.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 118.9 | 114.7 | -2.7 | -59.2 | -93.6 | 48.9 | 11.8 | 11.8 | 11.7 | 11.7 |
| WACC, % | 11.35 | 11.44 | 11.26 | 11.52 | 13.11 | 11.74 | 11.74 | 11.74 | 11.74 | 11.74 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 75.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 12 | |||||||||
| Terminal Value | 122 | |||||||||
| Present Terminal Value | 70 | |||||||||
| Enterprise Value | 146 | |||||||||
| Net Debt | 64 | |||||||||
| Equity Value | 82 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 11.62 |
What You Will Get
- Real HWBK Financial Data: Pre-filled with Hawthorn Bancshares, Inc.'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 Hawthorn Bancshares, Inc.'s 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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Hawthorn Bancshares, Inc. (HWBK).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the banking sector.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit Hawthorn Bancshares, Inc. (HWBK) projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Hawthorn Bancshares, Inc. (HWBK).
- Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Hawthorn Bancshares, Inc. (HWBK)'s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze multiple forecasts to evaluate various valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights that support your investment decisions.
Why Choose This Calculator for Hawthorn Bancshares, Inc. (HWBK)?
- Designed for Financial Experts: A specialized tool tailored for bankers, analysts, and investment consultants.
- Accurate Financial Data: Historical and projected financials for Hawthorn Bancshares preloaded for precision.
- Comprehensive Scenario Analysis: Easily test various forecasts and financial assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation experience.
Who Should Use This Product?
- Investors: Accurately assess Hawthorn Bancshares, Inc.'s (HWBK) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Hawthorn Bancshares, Inc. (HWBK).
- Consultants: Quickly customize the template for valuation reports tailored to Hawthorn Bancshares, Inc. (HWBK) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading banks like Hawthorn Bancshares, Inc. (HWBK).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies applicable to Hawthorn Bancshares, Inc. (HWBK).
What the Template Contains
- Pre-Filled DCF Model: Hawthorn Bancshares, Inc.'s (HWBK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to Hawthorn Bancshares, Inc. (HWBK).
- Financial Ratios: Assess Hawthorn Bancshares, Inc.'s (HWBK) profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth, margins, and CAPEX to suit your analysis for Hawthorn Bancshares, Inc. (HWBK).
- Financial Statements: Annual and quarterly reports to provide comprehensive support for detailed analysis of Hawthorn Bancshares, Inc. (HWBK).
- Interactive Dashboard: Effortlessly visualize key valuation metrics and results for Hawthorn Bancshares, Inc. (HWBK).