|
Civista Bancshares, Inc. (CIVB) Valoración de DCF
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
Civista Bancshares, Inc. (CIVB) Bundle
¡Mejore sus opciones de inversión con Civista Bancshares, Inc. (CIVB) CALCUTADOR DCF! Utilice datos financieros de Civista auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Civista.
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 | 107.5 | 116.0 | 124.6 | 137.0 | 160.2 | 177.1 | 195.8 | 216.5 | 239.3 | 264.6 |
| Revenue Growth, % | 0 | 7.9 | 7.34 | 10.01 | 16.94 | 10.55 | 10.55 | 10.55 | 10.55 | 10.55 |
| EBITDA | 42.7 | 40.3 | 51.2 | 52.8 | .0 | 54.6 | 60.4 | 66.7 | 73.8 | 81.6 |
| EBITDA, % | 39.75 | 34.73 | 41.14 | 38.52 | 0 | 30.83 | 30.83 | 30.83 | 30.83 | 30.83 |
| Depreciation | 3.2 | 3.2 | 2.9 | 5.8 | 12.3 | 7.0 | 7.8 | 8.6 | 9.5 | 10.5 |
| Depreciation, % | 2.96 | 2.73 | 2.3 | 4.2 | 7.7 | 3.98 | 3.98 | 3.98 | 3.98 | 3.98 |
| EBIT | 39.6 | 37.1 | 48.4 | 47.0 | -12.3 | 47.6 | 52.6 | 58.1 | 64.3 | 71.0 |
| EBIT, % | 36.79 | 32 | 38.84 | 34.32 | -7.7 | 26.85 | 26.85 | 26.85 | 26.85 | 26.85 |
| Total Cash | 407.0 | 503.0 | 825.8 | 660.2 | 8.3 | 143.6 | 158.7 | 175.4 | 193.9 | 214.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 47.5 | .0 | 12.3 | 13.6 | 15.0 | 16.6 | 18.4 |
| Account Receivables, % | 0 | 0 | 0 | 34.7 | 0 | 6.94 | 6.94 | 6.94 | 6.94 | 6.94 |
| Inventories | -55.6 | -149.0 | -273.4 | -44.8 | .0 | -100.8 | -111.4 | -123.2 | -136.1 | -150.5 |
| Inventories, % | -51.73 | -128.38 | -219.45 | -32.72 | 0 | -56.89 | -56.89 | -56.89 | -56.89 | -56.89 |
| 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 | -3.2 | -2.0 | -1.9 | -6.5 | -3.4 | -4.6 | -5.1 | -5.7 | -6.3 | -6.9 |
| Capital Expenditure, % | -2.98 | -1.7 | -1.55 | -4.75 | -2.14 | -2.62 | -2.62 | -2.62 | -2.62 | -2.62 |
| Tax Rate, % | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 | 15.11 |
| EBITAT | 33.9 | 32.2 | 41.2 | 39.4 | -10.5 | 40.6 | 44.8 | 49.6 | 54.8 | 60.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 89.5 | 126.7 | 166.6 | -237.4 | 1.1 | 131.4 | 56.8 | 62.8 | 69.4 | 76.8 |
| WACC, % | 9.68 | 9.76 | 9.65 | 9.54 | 9.62 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 311.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 78 | |||||||||
| Terminal Value | 1,023 | |||||||||
| Present Terminal Value | 646 | |||||||||
| Enterprise Value | 957 | |||||||||
| Net Debt | 393 | |||||||||
| Equity Value | 564 | |||||||||
| Diluted Shares Outstanding, MM | 15 | |||||||||
| Equity Value Per Share | 37.23 |
What You Will Get
- Real CIVB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Civista Bancshares' future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive CIVB Financial Data: Pre-loaded with Civista Bancshares' historical performance metrics and future financial forecasts.
- Flexible Input Options: Modify key variables such as loan growth, interest margins, capital adequacy ratios, and operating expenses.
- Interactive Valuation Model: Real-time updates to Net Present Value (NPV) and intrinsic value based on your customized parameters.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file for Civista Bancshares, Inc. (CIVB).
- Step 2: Review the pre-filled financial data and forecasts for Civista Bancshares.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Analyze the results and leverage the findings for your investment strategies.
Why Choose This Calculator for Civista Bancshares, Inc. (CIVB)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for Civista Bancshares.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Civista’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on Civista Bancshares.
Who Should Use This Product?
- Finance Students: Explore banking fundamentals and apply them using real-world data from Civista Bancshares, Inc. (CIVB).
- Academics: Integrate contemporary banking models into your coursework or research projects.
- Investors: Evaluate your investment strategies and analyze the financial performance of Civista Bancshares, Inc. (CIVB).
- Analysts: Enhance your analysis with a customizable financial model tailored for Civista Bancshares, Inc. (CIVB).
- Small Business Owners: Understand how community banks like Civista Bancshares, Inc. (CIVB) assess financial health and performance.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Civista Bancshares 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 Civista Bancshares, Inc. (CIVB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.