Citizens & Northern Corporation (CZNC) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Citizens & Northern Corporation (CZNC) Bundle
Looking to assess the intrinsic value of Citizens & Northern Corporation? Our CZNC DCF Calculator seamlessly integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment strategy.
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 | 72.7 | 90.8 | 103.8 | 106.0 | 104.6 | 115.1 | 126.6 | 139.3 | 153.3 | 168.6 |
| Revenue Growth, % | 0 | 24.98 | 14.28 | 2.06 | -1.25 | 10.02 | 10.02 | 10.02 | 10.02 | 10.02 |
| EBITDA | 25.2 | 25.2 | 39.8 | 34.7 | .0 | 30.7 | 33.8 | 37.2 | 40.9 | 45.0 |
| EBITDA, % | 34.61 | 27.73 | 38.35 | 32.79 | 0 | 26.7 | 26.7 | 26.7 | 26.7 | 26.7 |
| Depreciation | 2.0 | 2.5 | 2.7 | 2.8 | .0 | 2.5 | 2.7 | 3.0 | 3.3 | 3.6 |
| Depreciation, % | 2.71 | 2.77 | 2.57 | 2.67 | 0 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
| EBIT | 23.2 | 22.7 | 37.2 | 31.9 | .0 | 28.3 | 31.1 | 34.2 | 37.6 | 41.4 |
| EBIT, % | 31.9 | 24.96 | 35.79 | 30.12 | 0 | 24.55 | 24.55 | 24.55 | 24.55 | 24.55 |
| Total Cash | 381.9 | 451.2 | 622.6 | 553.1 | 537.5 | 115.1 | 126.6 | 139.3 | 153.3 | 168.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.0 | 8.3 | .0 | .0 | .0 | 3.7 | 4.1 | 4.5 | 4.9 | 5.4 |
| Account Receivables, % | 6.88 | 9.13 | 0 | 0 | 0 | 3.2 | 3.2 | 3.2 | 3.2 | 3.2 |
| Inventories | -47.2 | -117.3 | -122.0 | -64.0 | .0 | -74.9 | -82.4 | -90.6 | -99.7 | -109.7 |
| Inventories, % | -64.89 | -129.15 | -117.48 | -60.38 | 0 | -65.05 | -65.05 | -65.05 | -65.05 | -65.05 |
| Accounts Payable | 12.2 | 27.7 | 23.6 | 25.6 | .0 | 21.7 | 23.9 | 26.2 | 28.9 | 31.8 |
| Accounts Payable, % | 16.76 | 30.48 | 22.76 | 24.17 | 0 | 18.83 | 18.83 | 18.83 | 18.83 | 18.83 |
| Capital Expenditure | -2.9 | -3.1 | -1.9 | -3.3 | -2.3 | -3.3 | -3.7 | -4.0 | -4.4 | -4.9 |
| Capital Expenditure, % | -3.95 | -3.45 | -1.8 | -3.1 | -2.16 | -2.89 | -2.89 | -2.89 | -2.89 | -2.89 |
| Tax Rate, % | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 | 20.78 |
| EBITAT | 19.3 | 18.8 | 30.1 | 26.3 | .0 | 23.1 | 25.4 | 28.0 | 30.8 | 33.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 72.8 | 100.5 | 39.8 | -30.2 | -91.8 | 115.1 | 33.8 | 37.2 | 40.9 | 45.0 |
| WACC, % | 9.38 | 9.34 | 9.23 | 9.31 | 9.1 | 9.27 | 9.27 | 9.27 | 9.27 | 9.27 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 219.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 46 | |||||||||
| Terminal Value | 631 | |||||||||
| Present Terminal Value | 405 | |||||||||
| Enterprise Value | 624 | |||||||||
| Net Debt | 153 | |||||||||
| Equity Value | 472 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | 30.97 |
What You Will Receive
- Authentic CZNC Financial Data: Pre-loaded with Citizens & Northern Corporation’s historical and projected figures for detailed analysis.
- Completely Customizable Template: Easily adjust key variables such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch CZNC’s intrinsic value refresh in real-time based on your modifications.
- Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- Intuitive Design: Straightforward layout and clear guidance suitable for all skill levels.
Key Features
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Citizens & Northern Corporation (CZNC).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Citizens & Northern Corporation (CZNC).
- Interactive Dashboard and Charts: Visual representations provide a summary of essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based CZNC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model will automatically refresh Citizens & Northern Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the outcomes to inform your investment or financial decisions.
Why Choose This Calculator for Citizens & Northern Corporation (CZNC)?
- Accuracy: Leverages authentic Citizens & Northern Corporation financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with various inputs.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Finance Students: Master financial analysis techniques and implement them with real data from Citizens & Northern Corporation (CZNC).
- Academics: Utilize industry-standard models in your teaching or research on banking and finance.
- Investors: Evaluate your investment strategies and assess valuation scenarios for Citizens & Northern Corporation (CZNC).
- Analysts: Enhance your analysis process with a ready-to-use, customizable financial model tailored for Citizens & Northern Corporation (CZNC).
- Small Business Owners: Discover how financial performance is assessed in large institutions like Citizens & Northern Corporation (CZNC).
What the Template Contains
- Pre-Filled Data: Includes Citizens & Northern Corporation's (CZNC) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Citizens & Northern Corporation's (CZNC) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.