|
OptimumBank Holdings, Inc. (OPHC) DCF Valuation
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
OptimumBank Holdings, Inc. (OPHC) Bundle
Engineered for accuracy, our (OPHC) DCF Calculator empowers you to evaluate OptimumBank Holdings, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 3.3 | 5.3 | 11.2 | 18.8 | 35.8 | 64.2 | 115.3 | 207.1 | 371.8 | 667.4 |
Revenue Growth, % | 0 | 59.64 | 111.54 | 68.15 | 90.36 | 79.54 | 79.54 | 79.54 | 79.54 | 79.54 |
EBITDA | -.9 | -.5 | 3.4 | 6.0 | 9.0 | 6.6 | 11.9 | 21.4 | 38.3 | 68.8 |
EBITDA, % | -26.89 | -8.61 | 30.16 | 31.71 | 25.2 | 10.31 | 10.31 | 10.31 | 10.31 | 10.31 |
Depreciation | .3 | .3 | .3 | .6 | .6 | 2.7 | 4.9 | 8.9 | 15.9 | 28.6 |
Depreciation, % | 7.92 | 6.19 | 2.7 | 3.03 | 1.57 | 4.28 | 4.28 | 4.28 | 4.28 | 4.28 |
EBIT | -1.2 | -.8 | 3.1 | 5.4 | 8.5 | 3.9 | 7.0 | 12.5 | 22.4 | 40.3 |
EBIT, % | -34.8 | -14.8 | 27.46 | 28.69 | 23.64 | 6.04 | 6.04 | 6.04 | 6.04 | 6.04 |
Total Cash | 14.3 | 73.5 | 93.4 | 96.9 | 76.7 | 64.2 | 115.3 | 207.1 | 371.8 | 667.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .4 | 1.3 | 1.0 | 1.4 | 2.5 | 7.9 | 14.2 | 25.5 | 45.8 | 82.3 |
Account Receivables, % | 13.05 | 25.28 | 8.69 | 7.68 | 6.91 | 12.32 | 12.32 | 12.32 | 12.32 | 12.32 |
Inventories | -9.4 | -56.0 | -59.9 | -73.3 | .0 | -51.4 | -92.3 | -165.7 | -297.4 | -534.0 |
Inventories, % | -282.96 | -1059.14 | -536.24 | -389.87 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Capital Expenditure | -.5 | -.2 | -.4 | -.3 | -.7 | -3.4 | -6.0 | -10.8 | -19.4 | -34.9 |
Capital Expenditure, % | -15.38 | -3.79 | -3.41 | -1.71 | -1.87 | -5.23 | -5.23 | -5.23 | -5.23 | -5.23 |
Tax Rate, % | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
EBITAT | -1.1 | -.8 | 6.3 | 4.0 | 6.3 | 3.4 | 6.2 | 11.1 | 19.9 | 35.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 7.6 | 45.0 | 10.6 | 17.1 | -68.1 | 48.8 | 39.7 | 71.2 | 127.9 | 229.6 |
WACC, % | 13.84 | 14.39 | 14.39 | 11.28 | 11.24 | 13.03 | 13.03 | 13.03 | 13.03 | 13.03 |
PV UFCF | ||||||||||
SUM PV UFCF | 326.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 234 | |||||||||
Terminal Value | 2,123 | |||||||||
Present Terminal Value | 1,151 | |||||||||
Enterprise Value | 1,477 | |||||||||
Net Debt | -12 | |||||||||
Equity Value | 1,490 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 205.78 |
What You Will Get
- Real OPHC Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess OptimumBank’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Obtain reliable pre-loaded historical performance and future forecasts for OptimumBank Holdings, Inc. (OPHC).
- Flexible Forecast Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments as inputs change.
- Interactive Dashboard: User-friendly charts and summaries that simplify the visualization of your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and financial consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring OptimumBank Holdings, Inc. (OPHC) preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV.
- 4. Evaluate Scenarios: Compare various forecasts to explore different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to back your decision-making.
Why Choose This Calculator?
- Accurate Data: Up-to-date OptimumBank Holdings, Inc. (OPHC) financials ensure reliable valuation results.
- Customizable: Modify key parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline the process, eliminating the need to start from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: An intuitive design and clear, step-by-step instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Evaluate OptimumBank Holdings, Inc.'s (OPHC) financial health before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess future forecasts for OPHC.
- Startup Founders: Understand the valuation strategies of established financial institutions like OptimumBank Holdings, Inc. (OPHC).
- Consultants: Create detailed valuation analyses and reports for clients involving OPHC.
- Students and Educators: Utilize current data from OptimumBank Holdings, Inc. (OPHC) to teach and practice valuation skills.
What the Template Contains
- Preloaded OPHC Data: Historical and projected financial metrics, including revenue, net income, and operating expenses.
- DCF and WACC Models: Advanced spreadsheets for determining intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for modifying revenue growth rates, tax implications, and discount factors.
- Financial Statements: Detailed annual and quarterly financial reports for thorough analysis.
- Key Ratios: Metrics for profitability, leverage, and operational efficiency to assess performance.
- Dashboard and Charts: Visual representations of valuation results and underlying assumptions.