First Financial Bankshares, Inc. (FFIN) DCF Valuation

First Financial Bankshares, Inc. (FFIN) 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

First Financial Bankshares, Inc. (FFIN) 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:

Discover the true value of First Financial Bankshares, Inc. (FFIN) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect First Financial Bankshares, Inc. (FFIN) valuation – all within a single Excel template.


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 387.7 478.6 500.6 520.8 478.0 506.6 536.8 568.9 602.9 638.8
Revenue Growth, % 0 23.45 4.59 4.05 -8.22 5.97 5.97 5.97 5.97 5.97
EBITDA 216.2 263.1 285.0 293.6 .0 227.0 240.6 254.9 270.1 286.3
EBITDA, % 55.76 54.97 56.94 56.38 0 44.81 44.81 44.81 44.81 44.81
Depreciation 18.1 20.7 12.1 22.0 12.6 18.5 19.6 20.8 22.0 23.4
Depreciation, % 4.67 4.33 2.42 4.23 2.63 3.66 3.66 3.66 3.66 3.66
EBIT 198.0 242.4 272.9 271.6 -12.6 208.5 220.9 234.1 248.1 262.9
EBIT, % 51.08 50.64 54.52 52.15 -2.63 41.15 41.15 41.15 41.15 41.15
Total Cash 3,692.8 5,122.1 7,101.8 5,805.0 5,014.1 506.6 536.8 568.9 602.9 638.8
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 14.6 .0 .0 .0 3.1 3.3 3.5 3.7 3.9
Accounts Payable, % 0 3.06 0 0 0 0.61185 0.61185 0.61185 0.61185 0.61185
Capital Expenditure -8.7 -16.5 -19.2 -15.8 -17.3 -16.4 -17.3 -18.4 -19.5 -20.6
Capital Expenditure, % -2.24 -3.44 -3.84 -3.03 -3.61 -3.23 -3.23 -3.23 -3.23 -3.23
Tax Rate, % 18.22 18.22 18.22 18.22 18.22 18.22 18.22 18.22 18.22 18.22
EBITAT 164.8 202.0 228.4 226.7 -10.3 173.3 183.6 194.6 206.2 218.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 174.3 220.9 206.6 233.0 -15.0 178.5 186.1 197.2 209.0 221.4
WACC, % 10.46 10.47 10.48 10.47 10.42 10.46 10.46 10.46 10.46 10.46
PV UFCF
SUM PV UFCF 735.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 226
Terminal Value 2,670
Present Terminal Value 1,623
Enterprise Value 2,359
Net Debt -516
Equity Value 2,874
Diluted Shares Outstanding, MM 143
Equity Value Per Share 20.11

What You Will Get

  • Real FFIN Financial Data: Pre-filled with First Financial Bankshares, Inc.’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 First Financial Bankshares, Inc.’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 key metrics such as loan growth, interest margins, and operating expenses.
  • Instant DCF Valuation: Provides immediate calculations of intrinsic value, NPV, and other financial indicators.
  • High-Precision Accuracy: Leverages First Financial Bankshares, Inc.'s (FFIN) actual financial data for credible valuation results.
  • Effortless Scenario Analysis: Easily test various financial assumptions and evaluate different outcomes.
  • Efficiency Booster: Avoid the complexities of creating detailed valuation models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file featuring First Financial Bankshares, Inc.'s (FFIN) preloaded financial data.
  • 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures to fit your analysis.
  • 3. Instant Results: The DCF model automatically computes intrinsic value and NPV based on your inputs.
  • 4. Evaluate Scenarios: Analyze various forecasts to assess different valuation outcomes for First Financial Bankshares, Inc. (FFIN).
  • 5. Present with Assurance: Share professional valuation insights to bolster your decision-making process.

Why Choose This Calculator for First Financial Bankshares, Inc. (FFIN)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for FFIN.
  • Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes FFIN’s intrinsic value and Net Present Value.
  • Preloaded Information: Access to historical and projected data for precise analysis.
  • High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on FFIN.

Who Should Use First Financial Bankshares, Inc. (FFIN)?

  • Investors: Make informed investment choices with comprehensive financial insights from a trusted institution.
  • Financial Analysts: Streamline your analysis with robust financial data and reports tailored for your needs.
  • Consultants: Easily customize reports and presentations for clients using First Financial's reliable financial metrics.
  • Finance Enthusiasts: Enhance your knowledge of banking and finance through real-world case studies and examples.
  • Educators and Students: Utilize First Financial's resources as a valuable tool for finance education and practical applications.

What the Template Contains

  • Preloaded FFIN Data: Historical and projected financial data, including revenue, net interest income, and loan growth.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting interest rates, growth rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, liquidity, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.