OptimumBank Holdings, Inc. (OPHC) DCF Valuation

OptimumBank Holdings, Inc. (OPHC) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
OptimumBank Holdings, Inc. (OPHC) 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

OptimumBank Holdings, Inc. (OPHC) Bundle

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 13.05 25.28 8.69 7.68 6.91
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.