German American Bancorp, Inc. (GABC) 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
German American Bancorp, Inc. (GABC) Bundle
Looking to determine the intrinsic value of German American Bancorp, Inc.? Our (GABC) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your projections 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 | 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.