|
First Financial Bankshares, Inc. (FFIN) DCF Valoración
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
¡Descubra el verdadero valor de First Financial Bankshares, Inc. (FFIN) con nuestra calculadora DCF de grado profesional! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan a First Financial Bankshares, Inc. (FFIN) Valoración, todo dentro de una sola plantilla de Excel.
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 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 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.