|
Bankwell Financial Group, Inc. (BWFG) 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
Bankwell Financial Group, Inc. (BWFG) Bundle
¡Mejore sus estrategias de inversión con Bankwell Financial Group, Inc. (BWFG) Calculadora DCF! Utilice datos financieros reales, ajuste las predicciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de BWFG.
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 | 59.0 | 57.7 | 73.5 | 97.8 | 98.4 | 112.9 | 129.6 | 148.6 | 170.5 | 195.6 |
| Revenue Growth, % | 0 | -2.18 | 27.42 | 32.96 | 0.67599 | 14.72 | 14.72 | 14.72 | 14.72 | 14.72 |
| EBITDA | 26.3 | 10.6 | 37.4 | 51.3 | 51.7 | 49.4 | 56.7 | 65.0 | 74.6 | 85.6 |
| EBITDA, % | 44.6 | 18.32 | 50.91 | 52.51 | 52.48 | 43.77 | 43.77 | 43.77 | 43.77 | 43.77 |
| Depreciation | 3.4 | 3.3 | 3.6 | 3.4 | 3.6 | 5.3 | 6.1 | 7.0 | 8.0 | 9.2 |
| Depreciation, % | 5.72 | 5.68 | 4.87 | 3.44 | 3.68 | 4.68 | 4.68 | 4.68 | 4.68 | 4.68 |
| EBIT | 22.9 | 7.3 | 33.9 | 48.0 | 48.0 | 44.1 | 50.6 | 58.1 | 66.6 | 76.5 |
| EBIT, % | 38.88 | 12.65 | 46.04 | 49.07 | 48.8 | 39.09 | 39.09 | 39.09 | 39.09 | 39.09 |
| Total Cash | 160.5 | 493.9 | 381.8 | 448.6 | 269.2 | 112.9 | 129.6 | 148.6 | 170.5 | 195.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 | -84.0 | -418.8 | -354.5 | -368.7 | .0 | -90.3 | -103.6 | -118.9 | -136.4 | -156.5 |
| Inventories, % | -142.38 | -725.57 | -481.98 | -377.11 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | .0 | .0 | .0 | -2,605.6 | .0 | -22.6 | -25.9 | -29.7 | -34.1 | -39.1 |
| Accounts Payable, % | 0 | 0 | 0 | -2664.7 | 0 | -20 | -20 | -20 | -20 | -20 |
| Capital Expenditure | -.6 | -3.3 | -5.5 | -5.0 | -2.0 | -4.9 | -5.6 | -6.4 | -7.3 | -8.4 |
| Capital Expenditure, % | -1.09 | -5.78 | -7.48 | -5.07 | -2.08 | -4.3 | -4.3 | -4.3 | -4.3 | -4.3 |
| Tax Rate, % | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 | 23.69 |
| EBITAT | 18.2 | 5.9 | 26.6 | 37.4 | 36.7 | 34.7 | 39.8 | 45.7 | 52.4 | 60.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 105.0 | 340.6 | -39.7 | -2,555.5 | 2,275.1 | 102.9 | 50.3 | 57.7 | 66.2 | 75.9 |
| WACC, % | 23.71 | 24.05 | 23.5 | 23.38 | 22.98 | 23.52 | 23.52 | 23.52 | 23.52 | 23.52 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 201.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 77 | |||||||||
| Terminal Value | 360 | |||||||||
| Present Terminal Value | 125 | |||||||||
| Enterprise Value | 327 | |||||||||
| Net Debt | -108 | |||||||||
| Equity Value | 435 | |||||||||
| Diluted Shares Outstanding, MM | 8 | |||||||||
| Equity Value Per Share | 56.90 |
What You Will Receive
- Adjustable Financial Inputs: Modify key variables (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Financial Data: Bankwell Financial Group’s (BWFG) financial metrics pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailored and Professional Design: A refined Excel model that caters to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Bankwell Financial Group, Inc. (BWFG).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise financial analysis.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Bankwell Financial Group, Inc. (BWFG).
- User-Friendly Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward evaluation.
How It Works
- Download the Template: Gain immediate access to the Excel-based BWFG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Bankwell Financial Group’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Bankwell Financial Group, Inc. (BWFG)?
- Accurate Data: Up-to-date Bankwell financials guarantee trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: Simple design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Bankwell Financial Group's fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently 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 valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: Bankwell Financial Group’s (BWFG) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Bankwell Financial Group’s 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.