Veritex Holdings, Inc. (VBTX) 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
Veritex Holdings, Inc. (VBTX) Bundle
Looking to assess the intrinsic value of Veritex Holdings, Inc.? Our (VBTX) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts 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 | 315.2 | 313.1 | 333.4 | 422.6 | 377.7 | 398.5 | 420.4 | 443.5 | 467.8 | 493.5 |
Revenue Growth, % | 0 | -0.64567 | 6.48 | 26.75 | -10.62 | 5.49 | 5.49 | 5.49 | 5.49 | 5.49 |
EBITDA | 131.8 | 103.9 | 192.0 | 205.3 | .0 | 144.4 | 152.3 | 160.7 | 169.5 | 178.8 |
EBITDA, % | 41.82 | 33.19 | 57.59 | 48.58 | 0 | 36.23 | 36.23 | 36.23 | 36.23 | 36.23 |
Depreciation | 15.9 | 15.8 | 14.0 | 18.7 | .0 | 14.9 | 15.7 | 16.6 | 17.5 | 18.5 |
Depreciation, % | 5.06 | 5.06 | 4.2 | 4.42 | 0 | 3.75 | 3.75 | 3.75 | 3.75 | 3.75 |
EBIT | 115.9 | 88.1 | 178.0 | 186.6 | .0 | 129.5 | 136.6 | 144.1 | 152.0 | 160.3 |
EBIT, % | 36.76 | 28.13 | 53.39 | 44.16 | 0 | 32.49 | 32.49 | 32.49 | 32.49 | 32.49 |
Total Cash | 251.6 | 1,255.2 | 1,372.8 | 558.5 | 629.1 | 382.4 | 403.4 | 425.6 | 448.9 | 473.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 44.0 | 61.9 | 69.2 | 177.6 | .0 | 76.9 | 81.1 | 85.6 | 90.3 | 95.2 |
Accounts Payable, % | 13.96 | 19.78 | 20.74 | 42.02 | 0 | 19.3 | 19.3 | 19.3 | 19.3 | 19.3 |
Capital Expenditure | -7.7 | -2.9 | -13.6 | -4.6 | -1.9 | -7.2 | -7.6 | -8.0 | -8.4 | -8.9 |
Capital Expenditure, % | -2.43 | -0.9146 | -4.07 | -1.09 | -0.4908 | -1.8 | -1.8 | -1.8 | -1.8 | -1.8 |
Tax Rate, % | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 | 24.97 |
EBITAT | 90.7 | 73.9 | 140.9 | 146.3 | .0 | 102.2 | 107.8 | 113.8 | 120.0 | 126.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 143.0 | 104.8 | 148.6 | 268.8 | -179.4 | 186.9 | 120.2 | 126.8 | 133.8 | 141.2 |
WACC, % | 22.97 | 23.96 | 23.12 | 22.98 | 22.37 | 23.08 | 23.08 | 23.08 | 23.08 | 23.08 |
PV UFCF | ||||||||||
SUM PV UFCF | 407.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 144 | |||||||||
Terminal Value | 683 | |||||||||
Present Terminal Value | 242 | |||||||||
Enterprise Value | 649 | |||||||||
Net Debt | -299 | |||||||||
Equity Value | 949 | |||||||||
Diluted Shares Outstanding, MM | 55 | |||||||||
Equity Value Per Share | 17.38 |
What You Will Get
- Real Veritex Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Veritex Holdings’ fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive VBTX Data: Pre-filled with Veritex Holdings' historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatically updates Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Step 1: Download the Excel file for Veritex Holdings, Inc. (VBTX).
- Step 2: Review the pre-filled financial data and forecasts specific to Veritex Holdings.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Veritex Holdings, Inc. (VBTX)?
- Accurate Data: Utilize real Veritex financials for dependable valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations streamline the process, saving you valuable time.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Finance Students: Master financial analysis techniques and apply them to real-world data for Veritex Holdings, Inc. (VBTX).
- Academics: Integrate industry-standard models into your curriculum or research projects involving Veritex Holdings, Inc. (VBTX).
- Investors: Evaluate your investment strategies and analyze the valuation metrics for Veritex Holdings, Inc. (VBTX).
- Analysts: Enhance your analytical processes with a customizable financial model tailored for Veritex Holdings, Inc. (VBTX).
- Small Business Owners: Understand the financial evaluation methods used for publicly traded companies like Veritex Holdings, Inc. (VBTX).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Veritex Holdings 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 Veritex Holdings, Inc. (VBTX).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.