|
SB Financial Group, Inc. (SBFG) Valoración de DCF
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
SB Financial Group, Inc. (SBFG) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF (SBFG) es su herramienta esencial para una valoración precisa. Precedidos con datos reales de SB Financial Group, Inc., puede ajustar los pronósticos y ver los resultados de inmediato.
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 | 52.8 | 66.0 | 68.6 | 57.6 | 56.7 | 58.3 | 60.0 | 61.7 | 63.4 | 65.2 |
Revenue Growth, % | 0 | 24.95 | 3.87 | -15.97 | -1.56 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
EBITDA | 18.6 | 25.2 | 28.9 | 19.3 | .0 | 17.4 | 17.9 | 18.4 | 18.9 | 19.5 |
EBITDA, % | 35.28 | 38.14 | 42.2 | 33.54 | 0 | 29.83 | 29.83 | 29.83 | 29.83 | 29.83 |
Depreciation | 1.9 | 2.0 | 2.3 | 2.3 | .0 | 1.6 | 1.7 | 1.7 | 1.8 | 1.8 |
Depreciation, % | 3.57 | 3 | 3.4 | 3.93 | 0 | 2.78 | 2.78 | 2.78 | 2.78 | 2.78 |
EBIT | 16.8 | 23.2 | 26.6 | 17.1 | .0 | 15.8 | 16.2 | 16.7 | 17.2 | 17.6 |
EBIT, % | 31.71 | 35.14 | 38.8 | 29.61 | 0 | 27.05 | 27.05 | 27.05 | 27.05 | 27.05 |
Total Cash | 128.0 | 295.9 | 415.4 | 268.7 | 23.0 | 51.4 | 52.8 | 54.3 | 55.9 | 57.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.1 | .0 | 2.9 | 4.1 | 4.7 | 3.0 | 3.1 | 3.1 | 3.2 | 3.3 |
Account Receivables, % | 5.88 | 0 | 4.26 | 7.1 | 8.21 | 5.09 | 5.09 | 5.09 | 5.09 | 5.09 |
Inventories | -30.5 | -150.3 | -157.2 | .0 | .0 | -30.1 | -30.9 | -31.8 | -32.7 | -33.6 |
Inventories, % | -57.67 | -227.69 | -229.19 | 0 | 0 | -51.53 | -51.53 | -51.53 | -51.53 | -51.53 |
Accounts Payable | 1.2 | .6 | .3 | .8 | 2.4 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 |
Accounts Payable, % | 2.25 | 0.93297 | 0.43598 | 1.33 | 4.31 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 |
Capital Expenditure | -2.0 | -2.0 | -2.4 | -1.9 | -1.0 | -1.8 | -1.8 | -1.9 | -2.0 | -2.0 |
Capital Expenditure, % | -3.87 | -3 | -3.54 | -3.29 | -1.69 | -3.08 | -3.08 | -3.08 | -3.08 | -3.08 |
Tax Rate, % | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 | 17.82 |
EBITAT | 13.7 | 18.8 | 21.4 | 14.0 | .0 | 12.9 | 13.2 | 13.6 | 14.0 | 14.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 42.1 | 141.2 | 24.9 | -143.6 | .2 | 43.1 | 13.8 | 14.2 | 14.6 | 15.0 |
WACC, % | 10.83 | 10.77 | 10.72 | 10.82 | 10.85 | 10.8 | 10.8 | 10.8 | 10.8 | 10.8 |
PV UFCF | ||||||||||
SUM PV UFCF | 79.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 15 | |||||||||
Terminal Value | 174 | |||||||||
Present Terminal Value | 104 | |||||||||
Enterprise Value | 184 | |||||||||
Net Debt | 79 | |||||||||
Equity Value | 105 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 15.18 |
What You Will Get
- Real SBFG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess SB Financial Group’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential variables such as loan growth, interest rates, and operational expenses.
- Instant Valuation Calculations: Quickly determines the intrinsic value, NPV, and other financial metrics.
- High-Precision Analytics: Leverages SB Financial Group's real-time data for accurate valuation results.
- Effortless Scenario Testing: Easily evaluate various financial scenarios and analyze their impacts.
- Efficiency Booster: Streamline your process by avoiding the complexities of building valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for SB Financial Group, Inc. (SBFG).
- Step 2: Review the pre-entered financial data for SBFG (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis of SBFG.
- Step 4: View automatic recalculations for SBFG’s intrinsic value.
- Step 5: Utilize the outputs for investment decisions or reporting regarding SBFG.
Why Choose SB Financial Group, Inc. (SBFG) Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and advisors.
- Comprehensive Data: SBFG’s past and projected financials integrated for precise analysis.
- Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed instructions walk you through every step of the calculation process.
Who Should Use This Product?
- Investors: Accurately assess SB Financial Group, Inc.'s (SBFG) market potential before making investment choices.
- CFOs: Utilize a sophisticated DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently modify the template for valuation reports tailored to client needs.
- Entrepreneurs: Gain valuable insights into the financial modeling practices of leading financial firms.
- Educators: Employ it as an educational resource to illustrate various valuation techniques.
What the Template Contains
- Pre-Filled DCF Model: SB Financial Group, Inc.'s (SBFG) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate SB Financial Group, Inc.'s (SBFG) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.