Citizens Community Bancorp, Inc. (CZWI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Citizens Community Bancorp, Inc. (CZWI) Bundle
Looking to assess the intrinsic value of Citizens Community Bancorp, Inc.? Our (CZWI) DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.
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 | 56.3 | 68.4 | 69.7 | 67.2 | 58.5 | 59.5 | 60.6 | 61.6 | 62.7 | 63.7 |
Revenue Growth, % | 0 | 21.45 | 1.89 | -3.58 | -12.88 | 1.72 | 1.72 | 1.72 | 1.72 | 1.72 |
EBITDA | 16.4 | 26.5 | 33.0 | 27.6 | 22.1 | 23.1 | 23.5 | 23.9 | 24.3 | 24.7 |
EBITDA, % | 29.2 | 38.78 | 47.35 | 41.09 | 37.68 | 38.82 | 38.82 | 38.82 | 38.82 | 38.82 |
Depreciation | 3.1 | 3.6 | 3.9 | 3.8 | 3.7 | 3.4 | 3.4 | 3.5 | 3.5 | 3.6 |
Depreciation, % | 5.43 | 5.23 | 5.53 | 5.66 | 6.39 | 5.65 | 5.65 | 5.65 | 5.65 | 5.65 |
EBIT | 13.4 | 22.9 | 29.2 | 23.8 | 18.3 | 19.8 | 20.1 | 20.4 | 20.8 | 21.1 |
EBIT, % | 23.77 | 33.55 | 41.83 | 35.42 | 31.29 | 33.17 | 33.17 | 33.17 | 33.17 | 33.17 |
Total Cash | 240.7 | 267.4 | 252.3 | 35.6 | 37.1 | 49.6 | 50.4 | 51.3 | 52.2 | 53.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.7 | 5.7 | 3.9 | 5.3 | .0 | 3.6 | 3.7 | 3.7 | 3.8 | 3.8 |
Account Receivables, % | 8.41 | 8.26 | 5.62 | 7.87 | 0 | 6.03 | 6.03 | 6.03 | 6.03 | 6.03 |
Inventories | -66.8 | -129.0 | -54.5 | -42.2 | .0 | -40.6 | -41.3 | -42.0 | -42.7 | -43.5 |
Inventories, % | -118.58 | -188.66 | -78.24 | -62.76 | 0 | -68.2 | -68.2 | -68.2 | -68.2 | -68.2 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -6.8 | -2.6 | -3.8 | -3.6 | -1.4 | -3.4 | -3.5 | -3.6 | -3.6 | -3.7 |
Capital Expenditure, % | -12.02 | -3.76 | -5.42 | -5.36 | -2.34 | -5.78 | -5.78 | -5.78 | -5.78 | -5.78 |
Tax Rate, % | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 | 31.02 |
EBITAT | 10.3 | 16.9 | 21.4 | 17.9 | 12.6 | 14.6 | 14.8 | 15.1 | 15.3 | 15.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 68.7 | 79.2 | -51.3 | 4.4 | -21.9 | 51.5 | 15.4 | 15.6 | 15.9 | 16.2 |
WACC, % | 13.81 | 13.42 | 13.4 | 13.61 | 12.9 | 13.43 | 13.43 | 13.43 | 13.43 | 13.43 |
PV UFCF | ||||||||||
SUM PV UFCF | 86.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 16 | |||||||||
Terminal Value | 144 | |||||||||
Present Terminal Value | 77 | |||||||||
Enterprise Value | 163 | |||||||||
Net Debt | 110 | |||||||||
Equity Value | 53 | |||||||||
Diluted Shares Outstanding, MM | 10 | |||||||||
Equity Value Per Share | 5.08 |
What You Will Get
- Pre-Filled Financial Model: Citizens Community Bancorp, Inc.'s (CZWI) actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide real-time results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Pre-Loaded Data: Citizens Community Bancorp, Inc.'s (CZWI) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: Watch Citizens Community Bancorp, Inc.'s (CZWI) intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts present valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Citizens Community Bancorp, Inc. (CZWI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Citizens Community Bancorp, Inc. (CZWI)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Citizens Community Bancorp, Inc. (CZWI)?
- Accurate Data: Utilize precise financial metrics from Citizens Community Bancorp for dependable valuation outcomes.
- Customizable: Tailor essential variables like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-to-use calculations streamline your analysis process, saving you valuable time.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Simple design and guided instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Citizens Community Bancorp, Inc. (CZWI) for informed buying or selling decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and validate financial projections.
- Startup Founders: Gain insights into how community banks like Citizens Community Bancorp, Inc. (CZWI) are appraised.
- Consultants: Provide clients with comprehensive valuation assessments for their banking needs.
- Students and Educators: Utilize current data to learn and teach effective valuation strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Citizens Community Bancorp, Inc. (CZWI) 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 Citizens Community Bancorp, Inc. (CZWI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.