|
MVB Financial Corp. (MVBF) DCF Valuation
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
MVB Financial Corp. (MVBF) Bundle
Evaluate MVB Financial Corp.'s (MVBF) financial prospects like an expert! This (MVBF) DCF Calculator provides pre-filled financial data and the freedom to modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.
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 | 124.0 | 160.7 | 139.8 | 150.1 | 144.8 | 152.2 | 160.0 | 168.1 | 176.7 | 185.7 |
Revenue Growth, % | 0 | 29.56 | -13.01 | 7.4 | -3.53 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 |
EBITDA | 38.3 | 50.2 | 52.8 | 20.4 | .0 | 34.5 | 36.3 | 38.2 | 40.1 | 42.2 |
EBITDA, % | 30.87 | 31.27 | 37.76 | 13.56 | 0 | 22.69 | 22.69 | 22.69 | 22.69 | 22.69 |
Depreciation | 3.3 | 3.4 | 4.2 | 5.3 | 5.0 | 4.5 | 4.7 | 5.0 | 5.2 | 5.5 |
Depreciation, % | 2.63 | 2.09 | 3 | 3.55 | 3.45 | 2.94 | 2.94 | 2.94 | 2.94 | 2.94 |
EBIT | 35.0 | 46.9 | 48.6 | 15.0 | -5.0 | 30.1 | 31.6 | 33.2 | 34.9 | 36.7 |
EBIT, % | 28.24 | 29.18 | 34.76 | 10.01 | -3.45 | 19.75 | 19.75 | 19.75 | 19.75 | 19.75 |
Total Cash | 276.4 | 686.3 | 731.6 | 420.1 | 398.2 | 152.2 | 160.0 | 168.1 | 176.7 | 185.7 |
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 | -96.4 | -289.2 | -320.3 | -54.1 | .0 | -95.5 | -100.4 | -105.5 | -110.9 | -116.6 |
Inventories, % | -77.75 | -180.02 | -229.22 | -36.04 | 0 | -62.76 | -62.76 | -62.76 | -62.76 | -62.76 |
Accounts Payable | 41.7 | 55.9 | 55.1 | 41.6 | .0 | 41.3 | 43.4 | 45.6 | 47.9 | 50.4 |
Accounts Payable, % | 33.62 | 34.81 | 39.44 | 27.69 | 0 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 |
Capital Expenditure | -2.0 | -6.6 | -4.9 | -3.0 | -1.9 | -3.8 | -4.0 | -4.2 | -4.5 | -4.7 |
Capital Expenditure, % | -1.65 | -4.12 | -3.48 | -2.03 | -1.32 | -2.52 | -2.52 | -2.52 | -2.52 | -2.52 |
Tax Rate, % | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 | -14.43 |
EBITAT | 27.0 | 37.4 | 39.1 | 12.2 | -5.7 | 25.2 | 26.4 | 27.8 | 29.2 | 30.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 166.3 | 241.2 | 68.8 | -265.3 | -98.3 | 162.6 | 34.1 | 35.9 | 37.7 | 39.6 |
WACC, % | 21.97 | 22.47 | 22.63 | 22.77 | 26.35 | 23.24 | 23.24 | 23.24 | 23.24 | 23.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 203.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 40 | |||||||||
Terminal Value | 190 | |||||||||
Present Terminal Value | 67 | |||||||||
Enterprise Value | 271 | |||||||||
Net Debt | -318 | |||||||||
Equity Value | 589 | |||||||||
Diluted Shares Outstanding, MM | 13 | |||||||||
Equity Value Per Share | 45.29 |
What You Will Get
- Real MVB Financial 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 MVB Financial Corp.’s (MVBF) 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
- 🔍 Real-Life MVBF Financials: Pre-filled historical and projected data for MVB Financial Corp. (MVBF).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate MVB Financial Corp.’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize MVB Financial Corp.’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review MVB Financial Corp.'s (MVBF) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for MVB Financial Corp. (MVBF)?
- Accurate Data: Real MVB Financial Corp. financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the financial sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing MVB Financial Corp. (MVBF).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in MVB Financial Corp. (MVBF).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Banking Enthusiasts: Gain insights into how financial institutions like MVB Financial Corp. (MVBF) are valued in the market.
What the Template Contains
- Historical Data: Includes MVB Financial Corp.'s (MVBF) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate MVB Financial Corp.'s (MVBF) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of MVB Financial Corp.'s (MVBF) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.