|
Enterprise Bancorp, Inc. (EBTC) DCF Valoración
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
Enterprise Bancorp, Inc. (EBTC) Bundle
¡Agilice su análisis financiero y aumente la precisión con nuestra calculadora DCF (EBTC)! Utilizando datos reales de Enterprise Bancorp, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (EBTC) como un profesional de inversión experimentado.
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 | 132.2 | 147.4 | 159.7 | 170.3 | 161.4 | 170.0 | 179.1 | 188.6 | 198.7 | 209.2 |
| Revenue Growth, % | 0 | 11.5 | 8.33 | 6.64 | -5.18 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 |
| EBITDA | 50.7 | 48.4 | 63.6 | 63.2 | 57.4 | 62.5 | 65.8 | 69.3 | 73.0 | 76.9 |
| EBITDA, % | 38.38 | 32.85 | 39.81 | 37.11 | 35.57 | 36.74 | 36.74 | 36.74 | 36.74 | 36.74 |
| Depreciation | 6.1 | 6.8 | 7.8 | 7.0 | 6.2 | 7.5 | 7.9 | 8.3 | 8.8 | 9.3 |
| Depreciation, % | 4.65 | 4.6 | 4.89 | 4.13 | 3.83 | 4.42 | 4.42 | 4.42 | 4.42 | 4.42 |
| EBIT | 44.6 | 41.6 | 55.8 | 56.1 | 51.2 | 55.0 | 57.9 | 61.0 | 64.2 | 67.6 |
| EBIT, % | 33.73 | 28.25 | 34.92 | 32.98 | 31.74 | 32.32 | 32.32 | 32.32 | 32.32 | 32.32 |
| Total Cash | 63.8 | 253.8 | 436.6 | 267.6 | 2.1 | 118.9 | 125.2 | 131.9 | 138.9 | 146.3 |
| 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 | -76.7 | -272.3 | -450.2 | -285.4 | .0 | -121.7 | -128.2 | -135.1 | -142.2 | -149.8 |
| Inventories, % | -58 | -184.77 | -281.97 | -167.62 | 0 | -71.6 | -71.6 | -71.6 | -71.6 | -71.6 |
| Accounts Payable | .8 | 1.9 | 1.5 | 2.0 | 4.7 | 2.4 | 2.5 | 2.6 | 2.8 | 2.9 |
| Accounts Payable, % | 0.64006 | 1.32 | 0.96265 | 1.18 | 2.9 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| Capital Expenditure | -12.5 | -6.7 | -4.2 | -4.8 | -6.0 | -7.9 | -8.3 | -8.7 | -9.2 | -9.7 |
| Capital Expenditure, % | -9.46 | -4.53 | -2.62 | -2.84 | -3.73 | -4.64 | -4.64 | -4.64 | -4.64 | -4.64 |
| Tax Rate, % | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 | 25.73 |
| EBITAT | 34.2 | 31.5 | 42.2 | 42.7 | 38.1 | 41.6 | 43.8 | 46.1 | 48.6 | 51.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 105.4 | 228.3 | 223.3 | -119.4 | -244.5 | 160.7 | 50.0 | 52.7 | 55.5 | 58.4 |
| WACC, % | 11.82 | 11.73 | 11.73 | 11.77 | 11.62 | 11.73 | 11.73 | 11.73 | 11.73 | 11.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 290.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 60 | |||||||||
| Terminal Value | 612 | |||||||||
| Present Terminal Value | 352 | |||||||||
| Enterprise Value | 642 | |||||||||
| Net Debt | 53 | |||||||||
| Equity Value | 589 | |||||||||
| Diluted Shares Outstanding, MM | 12 | |||||||||
| Equity Value Per Share | 48.13 |
What You Will Get
- Real EBTC Financial Data: Pre-filled with Enterprise Bancorp's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Enterprise Bancorp’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life EBTC Financials: Pre-filled historical and projected data for Enterprise Bancorp, Inc. (EBTC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Enterprise Bancorp’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Enterprise Bancorp’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 for Enterprise Bancorp, Inc. (EBTC).
- Step 2: Review the pre-filled financial data and forecasts for Enterprise Bancorp.
- 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 Enterprise Bancorp, Inc. (EBTC)?
- Save Time: No need to navigate complex banking processes – our services are streamlined for efficiency.
- Enhance Financial Security: Robust systems and protocols ensure the safety of your investments.
- Customizable Solutions: Tailor our banking products to meet your specific financial needs.
- User-Friendly Experience: Intuitive interfaces and clear guidance make banking straightforward.
- Endorsed by Professionals: Trusted by industry experts for our commitment to excellence and reliability.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for investment assessments in Enterprise Bancorp, Inc. (EBTC).
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Financial Consultants: Deliver precise valuation analysis to clients considering investments in Enterprise Bancorp, Inc. (EBTC).
- Academics and Learners: Utilize real-time data to enhance understanding and instruction of financial modeling techniques.
- Banking Enthusiasts: Gain insights into how financial institutions like Enterprise Bancorp, Inc. (EBTC) are appraised in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Enterprise Bancorp, Inc. (EBTC) 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 Enterprise Bancorp, Inc. (EBTC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.