Business First Bancshares, Inc. (BFST) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Business First Bancshares, Inc. (BFST) Bundle
Designed for accuracy, our (BFST) DCF Calculator empowers you to evaluate Business First Bancshares, Inc. valuation using real-world financial data while offering complete flexibility to modify all essential parameters for enhanced 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 | 90.9 | 149.2 | 186.6 | 227.5 | 245.8 | 319.1 | 414.1 | 537.5 | 697.7 | 905.5 |
Revenue Growth, % | 0 | 64.14 | 25.03 | 21.97 | 8.04 | 29.79 | 29.79 | 29.79 | 29.79 | 29.79 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 2.5 | 4.3 | 5.8 | 6.9 | .0 | 7.5 | 9.7 | 12.6 | 16.4 | 21.3 |
Depreciation, % | 2.74 | 2.9 | 3.1 | 3.01 | 0 | 2.35 | 2.35 | 2.35 | 2.35 | 2.35 |
EBIT | -2.5 | -4.3 | -5.8 | -6.9 | .0 | -7.5 | -9.7 | -12.6 | -16.4 | -21.3 |
EBIT, % | -2.74 | -2.9 | -3.1 | -3.01 | 0 | -2.35 | -2.35 | -2.35 | -2.35 | -2.35 |
Total Cash | 367.6 | 789.7 | 1,089.4 | 1,043.5 | 377.2 | 319.1 | 414.1 | 537.5 | 697.7 | 905.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.0 | 23.9 | 19.6 | 25.7 | .0 | 29.8 | 38.6 | 50.1 | 65.1 | 84.4 |
Account Receivables, % | 8.83 | 16.01 | 10.5 | 11.28 | 0 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 |
Inventories | -162.8 | -356.2 | -316.4 | -195.4 | .0 | -246.2 | -319.6 | -414.8 | -538.4 | -698.8 |
Inventories, % | -179.09 | -238.74 | -169.62 | -85.87 | 0 | -77.17 | -77.17 | -77.17 | -77.17 | -77.17 |
Accounts Payable | 1.5 | 2.5 | 1.4 | 2.1 | 14.8 | 7.0 | 9.1 | 11.9 | 15.4 | 20.0 |
Accounts Payable, % | 1.69 | 1.67 | 0.72578 | 0.9194 | 6.04 | 2.21 | 2.21 | 2.21 | 2.21 | 2.21 |
Capital Expenditure | -4.0 | -3.0 | -4.0 | -7.8 | -11.6 | -10.6 | -13.8 | -17.9 | -23.2 | -30.1 |
Capital Expenditure, % | -4.36 | -1.99 | -2.13 | -3.42 | -4.74 | -3.33 | -3.33 | -3.33 | -3.33 | -3.33 |
Tax Rate, % | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 |
EBITAT | -2.0 | -3.5 | -4.7 | -5.4 | .0 | -6.0 | -7.8 | -10.1 | -13.1 | -17.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 152.9 | 176.4 | -39.5 | -132.7 | -168.6 | 199.6 | 54.8 | 71.1 | 92.3 | 119.8 |
WACC, % | 13.31 | 13.52 | 13.44 | 13.25 | 13.18 | 13.34 | 13.34 | 13.34 | 13.34 | 13.34 |
PV UFCF | ||||||||||
SUM PV UFCF | 387.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 122 | |||||||||
Terminal Value | 1,077 | |||||||||
Present Terminal Value | 576 | |||||||||
Enterprise Value | 963 | |||||||||
Net Debt | 390 | |||||||||
Equity Value | 573 | |||||||||
Diluted Shares Outstanding, MM | 25 | |||||||||
Equity Value Per Share | 22.67 |
What You Will Get
- Real Business First Bancshares Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Business First Bancshares, Inc. (BFST).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for Business First Bancshares, Inc. (BFST).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Business First Bancshares, Inc.'s (BFST) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Business First Bancshares, Inc. (BFST).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Business First Bancshares, Inc. (BFST).
Key Features
- 🔍 Real-Life BFST Financials: Pre-filled historical and projected data for Business First Bancshares, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Business First Bancshares’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Business First Bancshares’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the ready-to-use Excel file featuring Business First Bancshares, Inc.'s (BFST) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC as per your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time for accurate insights.
- Test Scenarios: Develop various projections and instantly compare different outcomes.
- Make Decisions: Leverage the valuation results to inform your investment strategy with Business First Bancshares, Inc. (BFST).
Why Choose This Calculator for Business First Bancshares, Inc. (BFST)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Effortlessly adjust parameters to suit your financial analysis.
- Real-Time Insights: Monitor immediate changes to Business First Bancshares' valuation as you tweak inputs.
- Pre-Configured Data: Comes loaded with Business First Bancshares' actual financial figures for speedy evaluations.
- Endorsed by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Finance Students: Explore banking fundamentals and apply them to real-world scenarios with Business First Bancshares, Inc. (BFST).
- Academics: Utilize industry-specific models in your research or teaching related to financial institutions.
- Investors: Evaluate your investment strategies and assess the financial health of Business First Bancshares, Inc. (BFST).
- Analysts: Enhance your analysis process with an adaptable financial model tailored for banking stocks.
- Small Business Owners: Understand how community banks like Business First Bancshares, Inc. (BFST) operate and are assessed in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Business First Bancshares, Inc.'s (BFST) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.