BayFirst Financial Corp. (BAFN) 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
BayFirst Financial Corp. (BAFN) Bundle
Looking to assess the intrinsic value of BayFirst Financial Corp.? Our (BAFN) DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust forecasts and enhance your investment decisions.
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 | 66.7 | 123.8 | 149.6 | 57.8 | 75.7 | 90.2 | 107.3 | 127.8 | 152.1 | 181.1 |
Revenue Growth, % | 0 | 85.71 | 20.85 | -61.35 | 30.95 | 19.04 | 19.04 | 19.04 | 19.04 | 19.04 |
EBITDA | 11.4 | 26.1 | .0 | 12.0 | .0 | 10.6 | 12.6 | 15.1 | 17.9 | 21.3 |
EBITDA, % | 17.05 | 21.11 | 0 | 20.77 | 0 | 11.78 | 11.78 | 11.78 | 11.78 | 11.78 |
Depreciation | 1.5 | 1.4 | 1.7 | 2.0 | 6.8 | 3.0 | 3.6 | 4.3 | 5.1 | 6.1 |
Depreciation, % | 2.22 | 1.14 | 1.16 | 3.42 | 8.91 | 3.37 | 3.37 | 3.37 | 3.37 | 3.37 |
EBIT | 9.9 | 24.7 | -1.7 | 10.0 | -6.8 | 7.6 | 9.0 | 10.7 | 12.8 | 15.2 |
EBIT, % | 14.83 | 19.97 | -1.16 | 17.34 | -8.91 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
Total Cash | 113.0 | 57.8 | 143.0 | 113.3 | 58.4 | 75.6 | 90.0 | 107.1 | 127.6 | 151.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 7.3 | 3.6 | 4.5 | .0 | 2.9 | 3.4 | 4.1 | 4.9 | 5.8 |
Account Receivables, % | 0 | 5.9 | 2.38 | 7.7 | 0 | 3.19 | 3.19 | 3.19 | 3.19 | 3.19 |
Inventories | -115.1 | -65.1 | -115.6 | .0 | .0 | -41.4 | -49.3 | -58.7 | -69.9 | -83.2 |
Inventories, % | -172.61 | -52.55 | -77.28 | 0 | 0 | -45.97 | -45.97 | -45.97 | -45.97 | -45.97 |
Accounts Payable | .2 | 2.0 | .3 | .7 | .9 | .8 | 1.0 | 1.2 | 1.4 | 1.6 |
Accounts Payable, % | 0.33023 | 1.61 | 0.21786 | 1.22 | 1.16 | 0.90885 | 0.90885 | 0.90885 | 0.90885 | 0.90885 |
Capital Expenditure | -7.3 | -3.0 | -13.3 | -8.1 | -7.6 | -8.3 | -9.9 | -11.8 | -14.1 | -16.8 |
Capital Expenditure, % | -10.97 | -2.46 | -8.89 | -13.94 | -10.01 | -9.25 | -9.25 | -9.25 | -9.25 | -9.25 |
Tax Rate, % | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 | 29.03 |
EBITAT | 7.0 | 19.9 | -1.3 | 7.8 | -4.8 | 5.7 | 6.8 | 8.1 | 9.6 | 11.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 116.5 | -37.3 | 39.8 | -114.4 | -1.0 | 38.9 | 8.0 | 9.5 | 11.3 | 13.5 |
WACC, % | 34.42 | 38.03 | 36.2 | 36.99 | 34.33 | 35.99 | 35.99 | 35.99 | 35.99 | 35.99 |
PV UFCF | ||||||||||
SUM PV UFCF | 42.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 14 | |||||||||
Terminal Value | 40 | |||||||||
Present Terminal Value | 9 | |||||||||
Enterprise Value | 52 | |||||||||
Net Debt | -42 | |||||||||
Equity Value | 94 | |||||||||
Diluted Shares Outstanding, MM | 5 | |||||||||
Equity Value Per Share | 20.44 |
What You Will Receive
- Comprehensive Financial Model: BayFirst Financial Corp.’s (BAFN) real data facilitates accurate DCF valuation.
- Complete Forecast Customization: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasting.
Key Features
- Comprehensive Financial Data: Access reliable historical performance metrics and future forecasts for BayFirst Financial Corp. (BAFN).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear and concise charts and overviews to help you interpret your valuation findings.
- Designed for All Skill Levels: An accessible and straightforward layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-built Excel file containing BayFirst Financial Corp.'s (BAFN) financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Develop various projections and instantly compare their results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose BayFirst Financial Corp. (BAFN)?
- Streamlined Processes: Skip the hassle of building financial models from scratch – our tools are ready for immediate use.
- Enhanced Precision: Utilize trustworthy financial data and formulas to minimize valuation errors.
- Completely Adaptable: Modify the model to align with your unique assumptions and forecasts.
- User-Friendly Design: Intuitive charts and outputs simplify result analysis.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use This Product?
- Investors: Accurately assess BayFirst Financial Corp.’s (BAFN) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Preloaded BAFN 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.