SmartFinancial, Inc. (SMBK) 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
SmartFinancial, Inc. (SMBK) Bundle
Looking to determine the intrinsic value of SmartFinancial, Inc.? Our SMBK DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your projections and make more informed investment choices.
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.6 | 114.1 | 137.3 | 6.4 | 152.4 | 171.8 | 193.7 | 218.4 | 246.2 | 277.6 |
Revenue Growth, % | 0 | 25.93 | 20.37 | -95.35 | 2288.04 | 12.74 | 12.74 | 12.74 | 12.74 | 12.74 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 1.4 | 7.8 | 9.0 | 12.6 | 13.5 | 42.5 | 47.9 | 54.0 | 60.9 | 68.7 |
Depreciation, % | 1.51 | 6.8 | 6.55 | 198.12 | 8.86 | 24.74 | 24.74 | 24.74 | 24.74 | 24.74 |
EBIT | -1.4 | -7.8 | -9.0 | -12.6 | -13.5 | -42.5 | -47.9 | -54.0 | -60.9 | -68.7 |
EBIT, % | -1.51 | -6.8 | -6.55 | -198.12 | -8.86 | -24.74 | -24.74 | -24.74 | -24.74 | -24.74 |
Total Cash | 362.3 | 697.4 | 1,527.5 | 750.3 | 470.0 | 171.8 | 193.7 | 218.4 | 246.2 | 277.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 53.7 | 66.1 | 68.1 | 63.2 | 71.2 | 80.3 | 90.5 | 102.0 |
Account Receivables, % | 0 | 0 | 39.11 | 1036.26 | 44.69 | 36.76 | 36.76 | 36.76 | 36.76 | 36.76 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -6.3 | -5.4 | -2.4 | -12.5 | -6.3 | -40.4 | -45.5 | -51.3 | -57.9 | -65.2 |
Capital Expenditure, % | -6.92 | -4.77 | -1.73 | -195.66 | -4.11 | -23.51 | -23.51 | -23.51 | -23.51 | -23.51 |
Tax Rate, % | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 | 21.07 |
EBITAT | -1.1 | -6.1 | -7.1 | -9.9 | -10.7 | -33.5 | -37.8 | -42.6 | -48.0 | -54.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.0 | -3.8 | -54.1 | -22.2 | -5.4 | -26.4 | -43.4 | -48.9 | -55.2 | -62.2 |
WACC, % | 19.08 | 18.99 | 18.95 | 18.92 | 19.01 | 18.99 | 18.99 | 18.99 | 18.99 | 18.99 |
PV UFCF | ||||||||||
SUM PV UFCF | -135.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -63 | |||||||||
Terminal Value | -373 | |||||||||
Present Terminal Value | -157 | |||||||||
Enterprise Value | -292 | |||||||||
Net Debt | -245 | |||||||||
Equity Value | -47 | |||||||||
Diluted Shares Outstanding, MM | 17 | |||||||||
Equity Value Per Share | -2.80 |
What You Will Get
- Real SmartFinancial Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for SmartFinancial, Inc. (SMBK).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to SmartFinancial, Inc. (SMBK).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on SmartFinancial, Inc.'s (SMBK) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for SmartFinancial, Inc. (SMBK).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for SmartFinancial, Inc. (SMBK).
Key Features
- Comprehensive Data: Access SmartFinancial’s historical financial reports and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Calculations: View SmartFinancial’s intrinsic value update instantly.
- Visual Insights: Interactive dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Get the pre-prepared Excel file containing SmartFinancial, Inc.'s (SMBK) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Utilize the valuation outcomes to inform your investment approach.
Why Choose SmartFinancial, Inc. (SMBK) Calculator?
- Precision: Utilizes real SmartFinancial data for reliable calculations.
- Adaptability: Allows users to easily experiment with and adjust inputs.
- Efficiency: Eliminate the need to create a financial model from the ground up.
- Expert-Level: Crafted with the accuracy and functionality expected by finance professionals.
- Intuitive: Simple interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Investors: Evaluate SmartFinancial, Inc. (SMBK) for informed investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts.
- Startup Founders: Understand valuation strategies of established financial firms like SmartFinancial, Inc. (SMBK).
- Consultants: Create detailed valuation reports for clients utilizing SmartFinancial, Inc. (SMBK) data.
- Students and Educators: Apply real-world financial data to enhance learning in valuation practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled SmartFinancial, Inc. 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 SmartFinancial, Inc. (SMBK).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.