|
Northeast Community Bancorp, Inc. (NECB) 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
Northeast Community Bancorp, Inc. (NECB) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (NECB)! Utilizando datos reales de Northeast Community Bancorp, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (NECB) como un inversor 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 | 56.2 | 41.6 | 45.7 | 65.5 | 99.8 | 119.7 | 143.6 | 172.2 | 206.5 | 247.7 |
| Revenue Growth, % | 0 | -25.96 | 9.8 | 43.4 | 52.5 | 19.93 | 19.93 | 19.93 | 19.93 | 19.93 |
| EBITDA | .0 | 16.7 | 16.7 | 35.7 | .0 | 31.4 | 37.7 | 45.2 | 54.2 | 65.0 |
| EBITDA, % | 0 | 40.12 | 36.56 | 54.5 | 0 | 26.24 | 26.24 | 26.24 | 26.24 | 26.24 |
| Depreciation | .9 | 1.1 | 1.1 | 1.2 | .0 | 2.0 | 2.5 | 2.9 | 3.5 | 4.2 |
| Depreciation, % | 1.63 | 2.57 | 2.45 | 1.9 | 0 | 1.71 | 1.71 | 1.71 | 1.71 | 1.71 |
| EBIT | -.9 | 15.6 | 15.6 | 34.4 | .0 | 29.4 | 35.2 | 42.2 | 50.7 | 60.8 |
| EBIT, % | -1.63 | 37.55 | 34.12 | 52.6 | 0 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 |
| Total Cash | 127.7 | 69.3 | 152.4 | 95.4 | 68.7 | 112.2 | 134.6 | 161.5 | 193.6 | 232.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 4.3 | 8.6 | 12.3 | 8.3 | 10.0 | 12.0 | 14.4 | 17.3 |
| Account Receivables, % | 0 | 0 | 9.38 | 13.13 | 12.33 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 |
| Inventories | .0 | -75.1 | -158.6 | -187.7 | .0 | -71.8 | -86.2 | -103.3 | -123.9 | -148.6 |
| Inventories, % | 0 | -180.7 | -347.53 | -286.68 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | .0 | .0 | .0 | 14.8 | .0 | 5.4 | 6.5 | 7.8 | 9.3 | 11.2 |
| Accounts Payable, % | 0 | 0 | 0 | 22.54 | 0 | 4.51 | 4.51 | 4.51 | 4.51 | 4.51 |
| Capital Expenditure | -4.0 | -1.3 | -6.5 | -3.3 | -.6 | -7.2 | -8.6 | -10.3 | -12.4 | -14.9 |
| Capital Expenditure, % | -7.2 | -3.04 | -14.13 | -5.05 | -0.6271 | -6.01 | -6.01 | -6.01 | -6.01 | -6.01 |
| Tax Rate, % | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 |
| EBITAT | -.7 | 12.3 | 11.9 | 24.8 | .0 | 22.1 | 26.5 | 31.7 | 38.0 | 45.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3.8 | 87.3 | 85.8 | 62.2 | -206.8 | 98.1 | 34.0 | 40.8 | 48.9 | 58.7 |
| WACC, % | 12.56 | 12.77 | 12.56 | 12.19 | 12.13 | 12.44 | 12.44 | 12.44 | 12.44 | 12.44 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 206.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 60 | |||||||||
| Terminal Value | 573 | |||||||||
| Present Terminal Value | 319 | |||||||||
| Enterprise Value | 525 | |||||||||
| Net Debt | 0 | |||||||||
| Equity Value | 524 | |||||||||
| Diluted Shares Outstanding, MM | 14 | |||||||||
| Equity Value Per Share | 37.63 |
What You Will Get
- Real NECB Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Northeast Community Bancorp, Inc. (NECB).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates tailored for NECB.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Northeast Community Bancorp, Inc.'s (NECB) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to NECB.
- Time-Saving and Accurate: Skip building models from scratch while ensuring precision and flexibility for Northeast Community Bancorp, Inc. (NECB).
Key Features
- 🔍 Real-Life NECB Financials: Pre-filled historical and projected data for Northeast Community Bancorp, Inc. (NECB).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Northeast Community Bancorp’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Northeast Community Bancorp’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Open the Template: Download and open the Excel file featuring Northeast Community Bancorp, Inc.'s (NECB) preloaded data.
- 2. Edit Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Test Scenarios: Evaluate various forecasts to explore different valuation scenarios.
- 5. Use with Confidence: Present expert valuation insights to enhance your decision-making process.
Why Choose the NECB Financial Calculator?
- Accuracy: Utilizes real Northeast Community Bancorp, Inc. (NECB) financial data for precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a financial model from the ground up.
- Professional-Grade: Crafted with attention to detail suitable for CFO-level analysis and efficiency.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use Northeast Community Bancorp, Inc. (NECB)?
- Investors: Gain insights and make informed decisions with a reliable banking partner.
- Financial Analysts: Utilize comprehensive financial reports to enhance your market assessments.
- Consultants: Leverage our resources to support client strategies and financial planning.
- Community Members: Access local banking services that cater to your financial needs.
- Students and Educators: Explore case studies and real-world applications in community banking.
What the Template Contains
- Pre-Filled Data: Contains Northeast Community Bancorp, Inc.'s (NECB) historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on customized inputs.
- Key Financial Ratios: Evaluate NECB's profitability, efficiency, and leverage.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing key valuation outcomes.