FB Financial Corporation (FBK) 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
FB Financial Corporation (FBK) Bundle
Discover the true value of FB Financial Corporation (FBK) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes affect FB Financial Corporation (FBK) 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 | 361.4 | 567.5 | 575.6 | 526.9 | 475.2 | 522.9 | 575.5 | 633.3 | 696.9 | 766.9 |
| Revenue Growth, % | 0 | 57.02 | 1.43 | -8.46 | -9.81 | 10.04 | 10.04 | 10.04 | 10.04 | 10.04 |
| EBITDA | 119.1 | 95.3 | 256.9 | 172.2 | .0 | 132.9 | 146.2 | 160.9 | 177.1 | 194.9 |
| EBITDA, % | 32.94 | 16.8 | 44.64 | 32.68 | 0 | 25.41 | 25.41 | 25.41 | 25.41 | 25.41 |
| Depreciation | 9.5 | 12.3 | 12.9 | 12.1 | .0 | 9.8 | 10.8 | 11.8 | 13.0 | 14.3 |
| Depreciation, % | 2.63 | 2.17 | 2.24 | 2.3 | 0 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
| EBIT | 109.5 | 83.0 | 244.1 | 160.0 | .0 | 123.1 | 135.5 | 149.1 | 164.0 | 180.5 |
| EBIT, % | 30.31 | 14.62 | 42.4 | 30.37 | 0 | 23.54 | 23.54 | 23.54 | 23.54 | 23.54 |
| Total Cash | 789.9 | 2,369.1 | 3,348.2 | 2,287.7 | 763.1 | 522.9 | 575.5 | 633.3 | 696.9 | 766.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 17.1 | 43.6 | 38.5 | .0 | 95.2 | 40.9 | 45.1 | 49.6 | 54.6 | 60.0 |
| Account Receivables, % | 4.73 | 7.68 | 6.69 | 0 | 20.04 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
| Inventories | -295.3 | -1,400.4 | -1,887.6 | -1,087.8 | .0 | -399.2 | -439.3 | -483.4 | -532.0 | -585.4 |
| Inventories, % | -81.69 | -246.76 | -327.93 | -206.45 | 0 | -76.34 | -76.34 | -76.34 | -76.34 | -76.34 |
| Accounts Payable | 6.5 | 6.8 | 3.2 | 8.6 | 18.8 | 9.5 | 10.5 | 11.6 | 12.7 | 14.0 |
| Accounts Payable, % | 1.79 | 1.19 | 0.54932 | 1.64 | 3.96 | 1.83 | 1.83 | 1.83 | 1.83 | 1.83 |
| Capital Expenditure | -6.8 | -5.9 | -6.1 | -10.6 | -20.2 | -10.7 | -11.8 | -13.0 | -14.3 | -15.7 |
| Capital Expenditure, % | -1.88 | -1.05 | -1.06 | -2.02 | -4.26 | -2.05 | -2.05 | -2.05 | -2.05 | -2.05 |
| Tax Rate, % | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 | 20.01 |
| EBITAT | 83.8 | 64.0 | 191.1 | 124.9 | .0 | 96.0 | 105.7 | 116.3 | 128.0 | 140.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 371.2 | 1,149.3 | 686.6 | -629.4 | -1,193.1 | 539.3 | 141.6 | 155.8 | 171.4 | 188.6 |
| WACC, % | 15.34 | 15.4 | 15.5 | 15.48 | 15.66 | 15.48 | 15.48 | 15.48 | 15.48 | 15.48 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 862.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 192 | |||||||||
| Terminal Value | 1,428 | |||||||||
| Present Terminal Value | 695 | |||||||||
| Enterprise Value | 1,558 | |||||||||
| Net Debt | -259 | |||||||||
| Equity Value | 1,817 | |||||||||
| Diluted Shares Outstanding, MM | 47 | |||||||||
| Equity Value Per Share | 38.81 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: FB Financial Corporation’s (FBK) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Provides immediate calculations for intrinsic value, NPV, and other financial metrics.
- High-Precision Analytics: Leverages FB Financial Corporation's actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Easily explore various assumptions and analyze their impacts on outcomes.
- Efficiency Booster: Streamline the valuation process without the need for intricate model development.
How It Works
- Step 1: Download the prebuilt Excel template featuring FB Financial Corporation’s (FBK) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly observe the recalculated results, including FB Financial Corporation’s (FBK) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose FB Financial Corporation (FBK)?
- User-Friendly Interface: Tailored for both novice users and seasoned professionals.
- Customizable Parameters: Adjust inputs easily to suit your financial analysis needs.
- Real-Time Feedback: Observe immediate changes in FB Financial’s metrics as you modify inputs.
- Pre-Loaded Data: Comes equipped with FB Financial’s actual financial figures for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed financial choices.
Who Should Use FB Financial Corporation (FBK)?
- Investors: Make informed choices with a reliable financial services provider.
- Financial Analysts: Streamline your analysis with comprehensive banking solutions tailored for your needs.
- Consultants: Easily modify offerings to meet client requirements and enhance presentations.
- Finance Enthusiasts: Expand your knowledge of banking practices through real-life case studies.
- Educators and Students: Utilize it as a valuable resource for finance-related education and practical applications.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled FB Financial Corporation (FBK) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for FB Financial Corporation (FBK).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.