First Financial Bankshares, Inc. (FFIN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
First Financial Bankshares, Inc. (FFIN) Bundle
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 | .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.