Colony Bankcorp, Inc. (CBAN) DCF Valuation

Colony Bankcorp, Inc. (CBAN) DCF Valuation
  • ✓ 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

Colony Bankcorp, Inc. (CBAN) 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:

Explore Colony Bankcorp, Inc. (CBAN) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate Colony Bankcorp, Inc. (CBAN)'s intrinsic value and enhance your investment approach.


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 62.6 79.5 102.5 115.7 160.7 204.0 259.0 328.7 417.2 529.6
Revenue Growth, % 0 26.97 28.92 12.9 38.93 26.93 26.93 26.93 26.93 26.93
EBITDA 15.5 20.5 31.8 34.5 31.1 53.3 67.7 85.9 109.1 138.4
EBITDA, % 24.76 25.78 31.01 29.8 19.36 26.14 26.14 26.14 26.14 26.14
Depreciation 2.7 3.1 3.9 4.4 3.9 7.4 9.4 12.0 15.2 19.3
Depreciation, % 4.31 3.88 3.81 3.8 2.43 3.65 3.65 3.65 3.65 3.65
EBIT 12.8 17.4 27.9 30.1 27.2 45.9 58.3 73.9 93.9 119.1
EBIT, % 20.45 21.89 27.21 26 16.93 22.5 22.5 22.5 22.5 22.5
Total Cash 449.8 564.3 1,145.2 453.1 83.3 184.4 234.0 297.0 377.0 478.6
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 .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
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.5 -4.2 -5.8 -2.9 -3.6 -8.7 -11.1 -14.0 -17.8 -22.6
Capital Expenditure, % -5.57 -5.34 -5.7 -2.5 -2.25 -4.27 -4.27 -4.27 -4.27 -4.27
Tax Rate, % 20.09 20.09 20.09 20.09 20.09 20.09 20.09 20.09 20.09 20.09
EBITAT 10.4 14.1 22.5 25.7 21.7 37.4 47.5 60.3 76.5 97.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 9.6 12.9 20.5 27.2 22.0 36.2 45.9 58.3 73.9 93.9
WACC, % 11.1 11.08 11.07 11.51 11.01 11.15 11.15 11.15 11.15 11.15
PV UFCF
SUM PV UFCF 215.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 96
Terminal Value 1,046
Present Terminal Value 616
Enterprise Value 832
Net Debt 213
Equity Value 619
Diluted Shares Outstanding, MM 18
Equity Value Per Share 35.22

What You Will Get

  • Authentic CBAN Financial Data: Pre-filled with Colony Bankcorp’s historical and projected data for accurate analysis.
  • Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
  • Instant Calculations: Watch Colony Bankcorp’s intrinsic value refresh immediately based on your modifications.
  • Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for reliable DCF results.
  • User-Friendly Layout: Intuitive design and straightforward instructions suitable for all skill levels.

Key Features

  • Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future estimates for Colony Bankcorp, Inc. (CBAN).
  • Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
  • Suitable for All Skill Levels: Designed with a straightforward, intuitive layout for investors, CFOs, and consultants alike.

How It Works

  • Step 1: Download the prebuilt Excel template with Colony Bankcorp, Inc.'s (CBAN) data included.
  • Step 2: Explore the pre-filled sheets and understand the key metrics.
  • Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly view recalculated results, including Colony Bankcorp, Inc.'s (CBAN) intrinsic value.
  • Step 5: Make informed investment decisions or generate reports using the outputs.

Why Choose This Calculator for Colony Bankcorp, Inc. (CBAN)?

  • User-Friendly Interface: Perfectly crafted for both novice and seasoned users.
  • Customizable Inputs: Adjust parameters easily to suit your financial analysis.
  • Real-Time Feedback: Monitor immediate changes to Colony Bankcorp's valuation as you modify inputs.
  • Pre-Configured Data: Comes with Colony Bankcorp's actual financial metrics for swift evaluations.
  • Relied Upon by Experts: A go-to tool for investors and analysts aiming for informed decision-making.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Colony Bankcorp, Inc. (CBAN) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Colony Bankcorp, Inc. (CBAN).
  • Consultants: Deliver professional valuation insights for Colony Bankcorp, Inc. (CBAN) to clients quickly and accurately.
  • Business Owners: Understand how banks like Colony Bankcorp, Inc. (CBAN) are valued to guide your own financial strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios, including Colony Bankcorp, Inc. (CBAN).

What the Template Contains

  • Historical Data: Includes Colony Bankcorp, Inc.'s (CBAN) past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Colony Bankcorp, Inc.'s (CBAN) intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Colony Bankcorp, Inc.'s (CBAN) financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.