United Security Bancshares (UBFO) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
United Security Bancshares (UBFO) Bundle
Explore United Security Bancshares' (UBFO) financial prospects with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of United Security Bancshares (UBFO) and refine your investment approach.
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 | 42.5 | 36.7 | 38.9 | 47.8 | 53.4 | 57.0 | 60.9 | 65.0 | 69.4 | 74.0 |
| Revenue Growth, % | 0 | -13.61 | 6.05 | 22.75 | 11.76 | 6.74 | 6.74 | 6.74 | 6.74 | 6.74 |
| EBITDA | 22.7 | 13.2 | 14.5 | 24.0 | 29.6 | 26.5 | 28.2 | 30.1 | 32.2 | 34.3 |
| EBITDA, % | 53.33 | 36.01 | 37.13 | 50.18 | 55.36 | 46.4 | 46.4 | 46.4 | 46.4 | 46.4 |
| Depreciation | .7 | .8 | 1.1 | .7 | 2.1 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 |
| Depreciation, % | 1.55 | 2.21 | 2.94 | 1.48 | 3.94 | 2.43 | 2.43 | 2.43 | 2.43 | 2.43 |
| EBIT | 22.0 | 12.4 | 13.3 | 23.3 | 27.5 | 25.1 | 26.8 | 28.6 | 30.5 | 32.6 |
| EBIT, % | 51.77 | 33.8 | 34.18 | 48.7 | 51.42 | 43.98 | 43.98 | 43.98 | 43.98 | 43.98 |
| Total Cash | 295.3 | 376.4 | 398.1 | 246.1 | 219.6 | 57.0 | 60.9 | 65.0 | 69.4 | 74.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 8.2 | 9.1 | 7.5 | 8.5 | 7.9 | 11.0 | 11.7 | 12.5 | 13.3 | 14.2 |
| Account Receivables, % | 19.31 | 24.81 | 19.33 | 17.76 | 14.84 | 19.21 | 19.21 | 19.21 | 19.21 | 19.21 |
| Inventories | -234.0 | -307.2 | -231.3 | .0 | .0 | -34.2 | -36.5 | -39.0 | -41.6 | -44.4 |
| Inventories, % | -550.34 | -836.59 | -593.95 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | .1 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0.13879 | 0.08985705 | 0 | 0 | 0 | 0.04572893 | 0.04572893 | 0.04572893 | 0.04572893 | 0.04572893 |
| Capital Expenditure | -1.0 | -1.1 | -1.3 | -2.1 | -.8 | -1.7 | -1.8 | -1.9 | -2.0 | -2.1 |
| Capital Expenditure, % | -2.25 | -3.11 | -3.22 | -4.48 | -1.47 | -2.9 | -2.9 | -2.9 | -2.9 | -2.9 |
| Tax Rate, % | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 | 27.95 |
| EBITAT | 15.7 | 9.0 | 10.1 | 16.6 | 19.8 | 18.2 | 19.4 | 20.7 | 22.1 | 23.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 241.2 | 81.0 | -64.4 | -217.2 | 21.7 | 49.1 | 20.7 | 22.1 | 23.6 | 25.2 |
| WACC, % | 8.14 | 8.18 | 8.34 | 8.13 | 8.17 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 114.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 26 | |||||||||
| Terminal Value | 414 | |||||||||
| Present Terminal Value | 280 | |||||||||
| Enterprise Value | 394 | |||||||||
| Net Debt | 34 | |||||||||
| Equity Value | 360 | |||||||||
| Diluted Shares Outstanding, MM | 17 | |||||||||
| Equity Value Per Share | 21.04 |
What You Will Receive
- Comprehensive Financial Model: United Security Bancshares’ (UBFO) actual data allows for accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate insights as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth financial forecasts.
Key Features
- 🔍 Real-Life UBFO Financials: Pre-filled historical and projected data for United Security Bancshares (UBFO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate United Security Bancshares’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize United Security Bancshares’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based UBFO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional factors.
- Instant Calculations: The model automatically recalculates United Security Bancshares’ intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for United Security Bancshares (UBFO)?
- User-Friendly Interface: Tailored for both novices and seasoned investors.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis.
- Real-Time Valuation: Monitor immediate changes to United Security Bancshares' valuation as you tweak inputs.
- Preloaded Data: Comes with United Security Bancshares' actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Investors: Accurately assess United Security Bancshares’ (UBFO) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Acquire knowledge of financial modeling practices employed by leading financial institutions.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for United Security Bancshares (UBFO).
- Real-World Data: Historical and projected financials for United Security Bancshares (UBFO) preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into United Security Bancshares (UBFO).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to United Security Bancshares (UBFO).
- Dashboard with Visual Outputs: Charts and tables designed to present clear, actionable results for United Security Bancshares (UBFO).