German American Bancorp, Inc. (GABC) DCF Valuation

German American Bancorp, Inc. (GABC) 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

German American Bancorp, Inc. (GABC) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 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

  1. Step 1: Download the Excel file for German American Bancorp, Inc. (GABC).
  2. Step 2: Review the pre-filled financial data and forecasts for (GABC).
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. 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.

No products were found matching.