BancFirst Corporation (BANF) 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
BancFirst Corporation (BANF) Bundle
Evaluate BancFirst Corporation's financial outlook like an expert! This (BANF) DCF Calculator provides you with pre-filled financials and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 419.2 | 443.9 | 485.7 | 557.4 | 623.9 | 689.5 | 761.9 | 842.0 | 930.4 | 1,028.1 |
| Revenue Growth, % | 0 | 5.9 | 9.42 | 14.77 | 11.93 | 10.51 | 10.51 | 10.51 | 10.51 | 10.51 |
| EBITDA | 185.6 | 141.9 | 228.4 | 259.5 | 292.1 | 298.8 | 330.1 | 364.8 | 403.1 | 445.5 |
| EBITDA, % | 44.27 | 31.98 | 47.03 | 46.55 | 46.82 | 43.33 | 43.33 | 43.33 | 43.33 | 43.33 |
| Depreciation | 16.0 | 18.4 | 20.0 | 22.0 | 22.2 | 27.0 | 29.9 | 33.0 | 36.5 | 40.3 |
| Depreciation, % | 3.81 | 4.15 | 4.13 | 3.96 | 3.56 | 3.92 | 3.92 | 3.92 | 3.92 | 3.92 |
| EBIT | 169.6 | 123.5 | 208.4 | 237.4 | 269.9 | 271.7 | 300.3 | 331.8 | 366.7 | 405.2 |
| EBIT, % | 40.45 | 27.82 | 42.91 | 42.59 | 43.27 | 39.41 | 39.41 | 39.41 | 39.41 | 39.41 |
| Total Cash | 2,358.0 | 2,169.1 | 2,581.5 | 4,707.1 | 1,779.4 | 689.5 | 761.9 | 842.0 | 930.4 | 1,028.1 |
| 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 | -1,917.1 | -1,675.1 | -2,111.3 | -3,239.1 | .0 | -551.6 | -609.5 | -673.6 | -744.3 | -822.5 |
| Inventories, % | -457.38 | -377.37 | -434.7 | -581.09 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 49.2 | 51.9 | 56.0 | 76.5 | .0 | 67.1 | 74.2 | 82.0 | 90.6 | 100.1 |
| Accounts Payable, % | 11.75 | 11.68 | 11.53 | 13.72 | 0 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 |
| Capital Expenditure | -27.1 | -66.4 | -27.3 | -19.8 | -22.5 | -47.1 | -52.1 | -57.6 | -63.6 | -70.3 |
| Capital Expenditure, % | -6.45 | -14.97 | -5.61 | -3.55 | -3.61 | -6.84 | -6.84 | -6.84 | -6.84 | -6.84 |
| Tax Rate, % | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 | 21.29 |
| EBITAT | 134.9 | 99.6 | 167.6 | 193.1 | 212.5 | 217.7 | 240.6 | 265.9 | 293.8 | 324.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2,090.1 | -187.8 | 600.7 | 1,343.7 | -3,103.4 | 816.3 | 283.4 | 313.1 | 346.0 | 382.4 |
| WACC, % | 12.98 | 13.04 | 13.03 | 13.07 | 12.94 | 13.01 | 13.01 | 13.01 | 13.01 | 13.01 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,580.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 390 | |||||||||
| Terminal Value | 3,542 | |||||||||
| Present Terminal Value | 1,921 | |||||||||
| Enterprise Value | 3,502 | |||||||||
| Net Debt | -2,302 | |||||||||
| Equity Value | 5,804 | |||||||||
| Diluted Shares Outstanding, MM | 33 | |||||||||
| Equity Value Per Share | 173.28 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: BancFirst Corporation’s financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Historical Data: BancFirst Corporation’s (BANF) detailed financial statements and historical forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Instantly view BancFirst Corporation’s (BANF) intrinsic value recalculating as inputs change.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based BANF DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh BancFirst Corporation’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial assessments.
Why Choose BancFirst Corporation (BANF)?
- Time Efficiency: Quickly access banking services without the hassle of lengthy processes.
- Enhanced Accuracy: Dependable financial insights ensure informed decision-making.
- Customizable Solutions: Tailor banking products to meet your unique financial needs.
- User-Friendly Experience: Intuitive interfaces simplify transactions and account management.
- Expertly Endorsed: Preferred by professionals for its reliability and customer service.
Who Should Use This Product?
- Professional Investors: Create comprehensive and trustworthy valuation models for analyzing BancFirst Corporation (BANF).
- Corporate Finance Teams: Evaluate valuation scenarios to inform internal decision-making processes.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding BancFirst Corporation (BANF).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how banking institutions like BancFirst Corporation (BANF) are valued in the financial market.
What the Template Contains
- Preloaded BANF Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.