|
Valoración de DCF alemán americano Bancorp, Inc. (GABC)
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
German American Bancorp, Inc. (GABC) Bundle
¿Busca determinar el valor intrínseco de la alemana Americana Bancorp, Inc.? Nuestra calculadora DCF (GABC) integra datos del mundo real con extensas características de personalización, lo que le permite refinar sus proyecciones y mejorar sus opciones de inversión.
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 | 190.7 | 209.7 | 220.3 | 259.7 | 250.7 | 269.1 | 288.9 | 310.2 | 333.0 | 357.5 |
| Revenue Growth, % | 0 | 9.96 | 5.04 | 17.9 | -3.47 | 7.36 | 7.36 | 7.36 | 7.36 | 7.36 |
| EBITDA | 80.7 | 84.5 | 111.6 | 109.3 | 113.1 | 118.6 | 127.4 | 136.7 | 146.8 | 157.6 |
| EBITDA, % | 42.33 | 40.28 | 50.64 | 42.08 | 45.1 | 44.09 | 44.09 | 44.09 | 44.09 | 44.09 |
| Depreciation | 9.5 | 9.5 | 8.5 | 10.4 | 9.6 | 11.4 | 12.2 | 13.1 | 14.1 | 15.2 |
| Depreciation, % | 4.98 | 4.54 | 3.87 | 3.99 | 3.81 | 4.24 | 4.24 | 4.24 | 4.24 | 4.24 |
| EBIT | 71.2 | 74.9 | 103.0 | 98.9 | 103.5 | 107.2 | 115.1 | 123.6 | 132.7 | 142.4 |
| EBIT, % | 37.35 | 35.74 | 46.77 | 38.09 | 41.28 | 39.85 | 39.85 | 39.85 | 39.85 | 39.85 |
| Total Cash | 105.9 | 347.0 | 397.6 | 119.6 | 115.3 | 187.1 | 200.8 | 215.6 | 231.5 | 248.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -124.7 | -367.6 | -417.9 | -271.3 | .0 | -196.7 | -211.1 | -226.7 | -243.3 | -261.2 |
| Inventories, % | -65.39 | -175.28 | -189.69 | -104.46 | 0 | -73.08 | -73.08 | -73.08 | -73.08 | -73.08 |
| Accounts Payable | 44.1 | 51.8 | 43.6 | 43.7 | .0 | 45.5 | 48.8 | 52.4 | 56.3 | 60.4 |
| Accounts Payable, % | 23.15 | 24.7 | 19.78 | 16.84 | 0 | 16.9 | 16.9 | 16.9 | 16.9 | 16.9 |
| Capital Expenditure | -9.4 | -7.1 | -4.7 | -7.9 | -5.7 | -8.5 | -9.1 | -9.8 | -10.5 | -11.2 |
| Capital Expenditure, % | -4.91 | -3.37 | -2.13 | -3.02 | -2.29 | -3.15 | -3.15 | -3.15 | -3.15 | -3.15 |
| Tax Rate, % | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 | 17.13 |
| EBITAT | 59.2 | 62.1 | 84.3 | 81.6 | 85.8 | 88.6 | 95.2 | 102.2 | 109.7 | 117.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 228.2 | 315.1 | 130.2 | -62.3 | -225.5 | 333.7 | 116.1 | 124.7 | 133.8 | 143.7 |
| WACC, % | 10.73 | 10.72 | 10.67 | 10.7 | 10.72 | 10.7 | 10.7 | 10.7 | 10.7 | 10.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 663.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 147 | |||||||||
| Terminal Value | 1,684 | |||||||||
| Present Terminal Value | 1,013 | |||||||||
| Enterprise Value | 1,676 | |||||||||
| Net Debt | 49 | |||||||||
| Equity Value | 1,627 | |||||||||
| Diluted Shares Outstanding, MM | 30 | |||||||||
| Equity Value Per Share | 55.06 |
What You Will Get
- Comprehensive GABC Financial Data: Pre-filled with German American Bancorp’s historical and projected data for accurate analysis.
- Fully Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Watch GABC’s intrinsic value update in real-time as you modify inputs.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and clear guidance suitable for all levels of expertise.
Key Features
- Real-Life GABC Data: Pre-filled with German American Bancorp’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file for German American Bancorp, Inc. (GABC).
- Step 2: Review the pre-filled financial data and forecasts for (GABC).
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and utilize the outputs for your investment decisions regarding (GABC).
Why Choose This Calculator?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis needs.
- Real-Time Insights: Observe immediate updates to German American Bancorp, Inc.'s (GABC) valuation as you change inputs.
- Preloaded Data: Comes with German American Bancorp, Inc.'s (GABC) actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and financial analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for assessing investments in German American Bancorp, Inc. (GABC).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in German American Bancorp, Inc. (GABC).
- Students and Educators: Utilize real-world financial data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into the valuation methods used for community banks like German American Bancorp, Inc. (GABC).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled German American Bancorp, Inc. (GABC) 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 German American Bancorp, Inc. (GABC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.