|
Capital Bancorp, Inc. (CBNK) 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
Capital Bancorp, Inc. (CBNK) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (CBNK)! Equipado con datos de Real Capital Bancorp, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y valorar Capital Bancorp 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 | 92.0 | 145.1 | 167.3 | 170.0 | 157.0 | 183.3 | 213.9 | 249.7 | 291.5 | 340.3 |
Revenue Growth, % | 0 | 57.7 | 15.3 | 1.58 | -7.64 | 16.73 | 16.73 | 16.73 | 16.73 | 16.73 |
EBITDA | 25.1 | 37.0 | 55.1 | 55.7 | 46.7 | 54.3 | 63.4 | 74.0 | 86.4 | 100.8 |
EBITDA, % | 27.24 | 25.52 | 32.92 | 32.75 | 29.75 | 29.63 | 29.63 | 29.63 | 29.63 | 29.63 |
Depreciation | 2.4 | 1.9 | 1.2 | 1.4 | .5 | 2.1 | 2.4 | 2.9 | 3.3 | 3.9 |
Depreciation, % | 2.55 | 1.31 | 0.72074 | 0.84246 | 0.30129 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 |
EBIT | 22.7 | 35.1 | 53.9 | 54.2 | 46.2 | 52.2 | 60.9 | 71.1 | 83.0 | 96.9 |
EBIT, % | 24.68 | 24.21 | 32.2 | 31.91 | 29.44 | 28.49 | 28.49 | 28.49 | 28.49 | 28.49 |
Total Cash | 173.8 | 244.3 | 364.2 | 312.2 | 245.5 | 183.3 | 213.9 | 249.7 | 291.5 | 340.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 | -122.0 | -158.4 | -191.4 | -89.9 | .0 | -129.3 | -151.0 | -176.3 | -205.8 | -240.2 |
Inventories, % | -132.54 | -109.12 | -114.37 | -52.89 | 0 | -70.58 | -70.58 | -70.58 | -70.58 | -70.58 |
Accounts Payable | 1.8 | 1.1 | .5 | 1.0 | 5.6 | 2.6 | 3.1 | 3.6 | 4.2 | 4.9 |
Accounts Payable, % | 1.96 | 0.78137 | 0.28268 | 0.60655 | 3.56 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 |
Capital Expenditure | -.3 | -.3 | .0 | -1.6 | -2.2 | -1.0 | -1.2 | -1.4 | -1.6 | -1.9 |
Capital Expenditure, % | -0.32924 | -0.18397 | -0.014343 | -0.91188 | -1.37 | -0.56255 | -0.56255 | -0.56255 | -0.56255 | -0.56255 |
Tax Rate, % | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 | 22.4 |
EBITAT | 16.9 | 25.8 | 40.0 | 41.8 | 35.9 | 39.3 | 45.9 | 53.6 | 62.6 | 73.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 142.7 | 63.2 | 73.5 | -59.2 | -51.2 | 166.8 | 69.3 | 80.8 | 94.4 | 110.2 |
WACC, % | 12.81 | 12.73 | 12.79 | 13.06 | 13.11 | 12.9 | 12.9 | 12.9 | 12.9 | 12.9 |
PV UFCF | ||||||||||
SUM PV UFCF | 376.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 112 | |||||||||
Terminal Value | 1,031 | |||||||||
Present Terminal Value | 562 | |||||||||
Enterprise Value | 938 | |||||||||
Net Debt | -4 | |||||||||
Equity Value | 943 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | 66.96 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CBNK financials.
- Real-World Data: Historical data and forward-looking estimates (as illustrated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe how your inputs affect Capital Bancorp's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Capital Bancorp, Inc. (CBNK).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Capital Bancorp, Inc. (CBNK).
- Interactive Dashboard and Charts: Visual representations that highlight key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Capital Bancorp, Inc.'s (CBNK) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the recalculated results, including Capital Bancorp, Inc.'s (CBNK) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Capital Bancorp, Inc. (CBNK)?
- Accurate Data: Up-to-date Capital Bancorp financials provide dependable 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 the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Professional Investors: Construct detailed and dependable valuation models for analyzing portfolios involving Capital Bancorp, Inc. (CBNK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients focused on Capital Bancorp, Inc. (CBNK).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Banking and Finance Enthusiasts: Gain insights into how financial institutions like Capital Bancorp, Inc. (CBNK) are valued in the marketplace.
What the Template Contains
- Historical Data: Includes Capital Bancorp, Inc.’s (CBNK) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Capital Bancorp, Inc.’s (CBNK) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital for Capital Bancorp, Inc. (CBNK).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for Capital Bancorp, Inc. (CBNK).
- Quarterly and Annual Statements: A complete breakdown of Capital Bancorp, Inc.’s (CBNK) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically for Capital Bancorp, Inc. (CBNK).