Community Trust Bancorp, Inc. (CTBI) DCF Valuation

Community Trust Bancorp, Inc. (CTBI) 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

Community Trust Bancorp, Inc. (CTBI) 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 Community Trust Bancorp, Inc. (CTBI)? Our (CTBI) DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust forecasts and make more informed 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 195.1 205.6 223.5 227.0 221.3 228.6 236.1 243.9 251.9 260.2
Revenue Growth, % 0 5.37 8.75 1.55 -2.51 3.29 3.29 3.29 3.29 3.29
EBITDA 75.8 73.8 113.8 104.3 102.3 99.6 102.9 106.3 109.8 113.4
EBITDA, % 38.85 35.89 50.93 45.96 46.24 43.57 43.57 43.57 43.57 43.57
Depreciation 3.8 3.5 3.2 3.3 3.8 3.8 3.9 4.0 4.2 4.3
Depreciation, % 1.95 1.7 1.43 1.45 1.7 1.65 1.65 1.65 1.65 1.65
EBIT 72.0 70.3 110.6 101.0 98.6 95.8 99.0 102.3 105.6 109.1
EBIT, % 36.91 34.18 49.5 44.51 44.54 41.93 41.93 41.93 41.93 41.93
Total Cash 658.5 1,051.5 1,502.0 1,385.2 1,222.6 228.6 236.1 243.9 251.9 260.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 14.8 15.8 15.4 19.6 23.6
Account Receivables, % 7.61 7.7 6.9 8.63 10.65
Inventories -299.2 -362.0 -330.9 -152.2 .0 -167.8 -173.3 -179.1 -184.9 -191.0
Inventories, % -153.4 -176.11 -148.03 -67.04 0 -73.41 -73.41 -73.41 -73.41 -73.41
Accounts Payable 2.8 1.2 1.0 2.2 7.4 3.1 3.2 3.3 3.4 3.6
Accounts Payable, % 1.46 0.60472 0.4545 0.98538 3.34 1.37 1.37 1.37 1.37 1.37
Capital Expenditure -2.6 -1.5 -2.4 -6.2 -6.3 -4.0 -4.1 -4.2 -4.4 -4.5
Capital Expenditure, % -1.32 -0.72099 -1.06 -2.74 -2.86 -1.74 -1.74 -1.74 -1.74 -1.74
Tax Rate, % 20.86 20.86 20.86 20.86 20.86 20.86 20.86 20.86 20.86 20.86
EBITAT 64.5 59.5 87.9 81.8 78.0 79.3 82.0 84.7 87.4 90.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 353.0 121.7 57.9 -102.8 -75.6 247.3 86.7 89.6 92.6 95.6
WACC, % 15.17 14.71 14.23 14.37 14.2 14.54 14.54 14.54 14.54 14.54
PV UFCF
SUM PV UFCF 443.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 98
Terminal Value 778
Present Terminal Value 395
Enterprise Value 838
Net Debt -191
Equity Value 1,029
Diluted Shares Outstanding, MM 18
Equity Value Per Share 57.49

What You Will Get

  • Real CTBI Financial Data: Pre-filled with Community Trust Bancorp’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Community Trust Bancorp’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Customizable Financial Inputs: Adjust essential parameters such as loan growth, interest rates, and operating expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
  • High-Quality Accuracy: Leverages Community Trust Bancorp's (CTBI) actual financial data for precise valuation results.
  • Effortless Scenario Analysis: Easily explore various assumptions and assess their impacts on outcomes.
  • Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.

How It Works

  1. Step 1: Download the Excel file for Community Trust Bancorp, Inc. (CTBI).
  2. Step 2: Review CTBI’s pre-filled financial data and forecasts.
  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 outputs and leverage the results for your investment strategies.

Why Choose This Calculator for Community Trust Bancorp, Inc. (CTBI)?

  • Accurate Data: Utilize real financial metrics from Community Trust Bancorp for dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-built calculations save you the hassle of starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: An intuitive design and guided instructions ensure ease of use for everyone.

Who Should Use This Product?

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

What the Template Contains

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

No products were found matching.