|
Oportun Financial Corporation (OPRT) DCF Valoración
US | Financial Services | Financial - Credit Services | 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
Oportun Financial Corporation (OPRT) Bundle
¡Mejore su estrategia de inversión con la calculadora DCF de Oportun Financial Corporation (OPRT)! Explore datos financieros auténticos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Oportun.
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 | 442.4 | 335.1 | 530.4 | 640.7 | 1,056.9 | 1,373.4 | 1,784.7 | 2,319.2 | 3,013.7 | 3,916.2 |
| Revenue Growth, % | 0 | -24.25 | 58.28 | 20.8 | 64.96 | 29.95 | 29.95 | 29.95 | 29.95 | 29.95 |
| EBITDA | 98.5 | -37.9 | 89.9 | .0 | -198.8 | 25.0 | 32.5 | 42.3 | 54.9 | 71.4 |
| EBITDA, % | 22.27 | -11.3 | 16.95 | 0 | -18.81 | 1.82 | 1.82 | 1.82 | 1.82 | 1.82 |
| Depreciation | 14.1 | 20.2 | 27.1 | 47.5 | 54.9 | 74.0 | 96.2 | 125.0 | 162.4 | 211.0 |
| Depreciation, % | 3.19 | 6.03 | 5.11 | 7.42 | 5.19 | 5.39 | 5.39 | 5.39 | 5.39 | 5.39 |
| EBIT | 84.4 | -58.1 | 62.8 | -47.5 | -253.7 | -49.0 | -63.6 | -82.7 | -107.5 | -139.7 |
| EBIT, % | 19.08 | -17.34 | 11.84 | -7.42 | -24 | -3.57 | -3.57 | -3.57 | -3.57 | -3.57 |
| Total Cash | 72.2 | 136.2 | 131.0 | 98.8 | 91.2 | 290.4 | 377.3 | 490.3 | 637.2 | 828.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 17.2 | 15.4 | 20.9 | 11.1 | 8.8 | 41.2 | 53.5 | 69.5 | 90.4 | 117.4 |
| Account Receivables, % | 3.89 | 4.6 | 3.94 | 1.74 | 0.83081 | 3 | 3 | 3 | 3 | 3 |
| Inventories | -185.3 | -201.3 | -239.2 | -177.6 | -115.7 | -510.1 | -662.9 | -861.4 | -1,119.4 | -1,454.6 |
| Inventories, % | -41.88 | -60.06 | -45.1 | -27.72 | -10.95 | -37.14 | -37.14 | -37.14 | -37.14 | -37.14 |
| Accounts Payable | 9.8 | 5.2 | 11.6 | 18.1 | 13.7 | 27.7 | 36.0 | 46.8 | 60.8 | 79.0 |
| Accounts Payable, % | 2.21 | 1.57 | 2.19 | 2.83 | 1.3 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
| Capital Expenditure | -26.2 | -26.6 | -26.5 | -48.9 | -31.3 | -80.9 | -105.1 | -136.6 | -177.5 | -230.6 |
| Capital Expenditure, % | -5.92 | -7.94 | -5 | -7.63 | -2.96 | -5.89 | -5.89 | -5.89 | -5.89 | -5.89 |
| Tax Rate, % | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 | 29.06 |
| EBITAT | 61.6 | -45.1 | 47.4 | -49.1 | -180.0 | -38.9 | -50.5 | -65.7 | -85.3 | -110.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 227.4 | -38.2 | 86.9 | -95.8 | -220.3 | 330.2 | 89.3 | 116.0 | 150.7 | 195.9 |
| WACC, % | 4.71 | 4.98 | 4.86 | 6.28 | 4.59 | 5.08 | 5.08 | 5.08 | 5.08 | 5.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 771.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 200 | |||||||||
| Terminal Value | 6,481 | |||||||||
| Present Terminal Value | 5,058 | |||||||||
| Enterprise Value | 5,830 | |||||||||
| Net Debt | 2,847 | |||||||||
| Equity Value | 2,982 | |||||||||
| Diluted Shares Outstanding, MM | 37 | |||||||||
| Equity Value Per Share | 80.87 |
What You Will Receive
- Flexible Forecast Inputs: Modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Oportun Financial Corporation’s (OPRT) financial data pre-loaded to accelerate your analysis.
- Automated DCF Outputs: The model computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Loan Calculator: Offers detailed models for various loan scenarios tailored for Oportun Financial Corporation (OPRT).
- Credit Risk Assessment Tool: Pre-built sheet to evaluate creditworthiness with adjustable parameters.
- Customizable Financial Projections: Adjust assumptions for interest rates, repayment terms, and borrower profiles.
- Integrated Financial Metrics: Review key performance indicators related to lending efficiency and profitability for Oportun Financial Corporation (OPRT).
- User-Friendly Dashboard: Visual representations of important financial data for quick insights and decision-making.
How It Works
- Step 1: Download the prebuilt Excel template featuring Oportun Financial Corporation's (OPRT) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Oportun Financial Corporation's intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or to create comprehensive reports.
Why Choose This Calculator for Oportun Financial Corporation (OPRT)?
- Accurate Data: Utilize real Oportun financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you from 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?
- Investors: Accurately estimate Oportun Financial Corporation’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to OPRT.
- Consultants: Quickly adapt the template for valuation reports for clients interested in Oportun Financial Corporation.
- Entrepreneurs: Gain insights into financial modeling techniques employed by leading financial service companies.
- Educators: Use it as a teaching tool to illustrate valuation methodologies relevant to Oportun Financial Corporation.
What the Template Contains
- Preloaded OPRT Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.