|
RBB Bancorp (RBB) 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
RBB Bancorp (RBB) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de RBB Bancorp (RBB)! Utilice datos financieros precisos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de RBB Bancorp (RBB).
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 | 115.0 | 118.7 | 143.0 | 159.9 | 130.9 | 136.6 | 142.6 | 148.7 | 155.2 | 161.9 |
| Revenue Growth, % | 0 | 3.2 | 20.47 | 11.78 | -18.08 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
| EBITDA | 62.1 | 54.3 | 93.4 | 102.4 | .0 | 62.6 | 65.3 | 68.1 | 71.1 | 74.2 |
| EBITDA, % | 53.98 | 45.74 | 65.34 | 64.04 | 0 | 45.82 | 45.82 | 45.82 | 45.82 | 45.82 |
| Depreciation | 3.3 | 3.4 | 8.3 | 8.3 | .0 | 4.6 | 4.8 | 5.0 | 5.2 | 5.4 |
| Depreciation, % | 2.87 | 2.87 | 5.81 | 5.16 | 0 | 3.34 | 3.34 | 3.34 | 3.34 | 3.34 |
| EBIT | 58.8 | 50.9 | 85.1 | 94.1 | .0 | 58.0 | 60.6 | 63.2 | 65.9 | 68.8 |
| EBIT, % | 51.11 | 42.87 | 59.53 | 58.87 | 0 | 42.48 | 42.48 | 42.48 | 42.48 | 42.48 |
| Total Cash | 241.4 | 349.1 | 870.2 | 341.0 | 431.4 | 136.6 | 142.6 | 148.7 | 155.2 | 161.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 34.8 | .0 | 48.8 | .0 | .0 | 17.6 | 18.4 | 19.2 | 20.0 | 20.9 |
| Account Receivables, % | 30.26 | 0 | 34.15 | 0 | 0 | 12.88 | 12.88 | 12.88 | 12.88 | 12.88 |
| Inventories | -182.7 | -195.5 | -695.7 | -84.1 | .0 | -96.4 | -100.5 | -104.9 | -109.5 | -114.2 |
| Inventories, % | -158.78 | -164.73 | -486.51 | -52.64 | 0 | -70.53 | -70.53 | -70.53 | -70.53 | -70.53 |
| Accounts Payable | 17.4 | 16.4 | 14.0 | 20.8 | .0 | 14.1 | 14.7 | 15.4 | 16.1 | 16.7 |
| Accounts Payable, % | 15.09 | 13.81 | 9.78 | 13.03 | 0 | 10.34 | 10.34 | 10.34 | 10.34 | 10.34 |
| Capital Expenditure | -1.4 | -4.2 | -2.0 | -2.1 | -.7 | -2.2 | -2.3 | -2.3 | -2.5 | -2.6 |
| Capital Expenditure, % | -1.17 | -3.54 | -1.39 | -1.29 | -0.49793 | -1.58 | -1.58 | -1.58 | -1.58 | -1.58 |
| Tax Rate, % | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 | 29.51 |
| EBITAT | 41.7 | 35.3 | 59.9 | 66.3 | .0 | 40.8 | 42.6 | 44.4 | 46.3 | 48.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 208.8 | 81.3 | 515.1 | -483.4 | -105.6 | 136.1 | 49.1 | 51.2 | 53.5 | 55.8 |
| WACC, % | 15.15 | 14.94 | 15.07 | 15.09 | 15.1 | 15.07 | 15.07 | 15.07 | 15.07 | 15.07 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 247.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 57 | |||||||||
| Terminal Value | 435 | |||||||||
| Present Terminal Value | 216 | |||||||||
| Enterprise Value | 463 | |||||||||
| Net Debt | -117 | |||||||||
| Equity Value | 580 | |||||||||
| Diluted Shares Outstanding, MM | 19 | |||||||||
| Equity Value Per Share | 30.53 |
What You Will Get
- Real RBB Financial Data: Pre-filled with RBB 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 RBB 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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for RBB Bancorp (RBB).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to RBB Bancorp (RBB).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates for RBB Bancorp (RBB).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to RBB Bancorp (RBB).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for quick analysis of RBB Bancorp (RBB).
How It Works
- Step 1: Download the Excel file for RBB Bancorp (RBB).
- Step 2: Review RBB Bancorp’s pre-filled financial data and forecasts.
- 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 assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment decisions.
Why Choose RBB Bancorp (RBB)?
- Save Time: Instantly access comprehensive financial tools without the hassle of starting from scratch.
- Enhance Accuracy: Dependable financial insights and calculations minimize valuation discrepancies.
- Completely Customizable: Adjust the model to align with your unique assumptions and forecasts.
- User-Friendly: Intuitive charts and results facilitate straightforward analysis.
- Endorsed by Professionals: Crafted for those who prioritize accuracy and functionality in financial assessments.
Who Should Use This Product?
- Investors: Accurately assess RBB Bancorp’s (RBB) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to RBB Bancorp (RBB).
- Consultants: Efficiently modify the template for valuation reports tailored to clients interested in RBB Bancorp (RBB).
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions, including RBB Bancorp (RBB).
- Educators: Apply it as a teaching resource to illustrate valuation techniques relevant to RBB Bancorp (RBB).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled RBB Bancorp (RBB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that display intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for RBB Bancorp (RBB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.