OppFi Inc. (OPFI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
OppFi Inc. (OPFI) Bundle
Evaluate OppFi Inc.'s (OPFI) financial outlook with expert precision! This (OPFI) DCF Calculator provides pre-filled financial data and total versatility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 229.1 | 291.0 | 350.6 | 452.9 | 508.9 | 622.2 | 760.8 | 930.1 | 1,137.1 | 1,390.3 |
| Revenue Growth, % | 0 | 27.01 | 20.46 | 29.18 | 12.39 | 22.26 | 22.26 | 22.26 | 22.26 | 22.26 |
| EBITDA | 57.9 | 103.5 | 118.2 | 55.3 | 46.4 | 144.2 | 176.3 | 215.6 | 263.6 | 322.3 |
| EBITDA, % | 25.28 | 35.58 | 33.72 | 12.22 | 9.11 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 |
| Depreciation | 4.3 | 6.7 | 10.3 | 13.6 | 12.7 | 15.7 | 19.2 | 23.5 | 28.7 | 35.1 |
| Depreciation, % | 1.87 | 2.31 | 2.93 | 3 | 2.5 | 2.52 | 2.52 | 2.52 | 2.52 | 2.52 |
| EBIT | 53.6 | 96.8 | 107.9 | 41.7 | 33.6 | 128.5 | 157.1 | 192.1 | 234.9 | 287.2 |
| EBIT, % | 23.41 | 33.26 | 30.78 | 9.22 | 6.61 | 20.66 | 20.66 | 20.66 | 20.66 | 20.66 |
| Total Cash | 16.8 | 25.6 | 25.1 | 16.2 | 73.9 | 51.5 | 63.0 | 77.0 | 94.1 | 115.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 222.2 | 388.1 | 459.9 | 465.3 | 457.7 | 559.6 | 684.2 | 836.5 | 1,022.7 |
| Account Receivables, % | 0 | 76.37 | 110.71 | 101.56 | 91.43 | 73.56 | 73.56 | 73.56 | 73.56 | 73.56 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Payable | .0 | 1.4 | 6.1 | 6.3 | 4.4 | 5.6 | 6.8 | 8.3 | 10.2 | 12.5 |
| Accounts Payable, % | 0 | 0.4742 | 1.74 | 1.4 | 0.87278 | 0.89731 | 0.89731 | 0.89731 | 0.89731 | 0.89731 |
| Capital Expenditure | -6.6 | -10.7 | -14.4 | -13.3 | -9.0 | -19.1 | -23.4 | -28.6 | -35.0 | -42.8 |
| Capital Expenditure, % | -2.9 | -3.68 | -4.1 | -2.93 | -1.77 | -3.07 | -3.07 | -3.07 | -3.07 | -3.07 |
| Tax Rate, % | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 | 102.4 |
| EBITAT | 53.6 | 96.8 | 30.6 | 96.7 | -.8 | 84.4 | 103.2 | 126.2 | 154.3 | 188.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 51.3 | -128.1 | -134.6 | 25.5 | -4.4 | 89.7 | -1.6 | -2.0 | -2.5 | -3.0 |
| WACC, % | 12.55 | 12.55 | 5.49 | 12.55 | 2.7 | 9.17 | 9.17 | 9.17 | 9.17 | 9.17 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 75.6 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -3 | |||||||||
| Terminal Value | -35 | |||||||||
| Present Terminal Value | -22 | |||||||||
| Enterprise Value | 53 | |||||||||
| Net Debt | 317 | |||||||||
| Equity Value | -264 | |||||||||
| Diluted Shares Outstanding, MM | 16 | |||||||||
| Equity Value Per Share | -16.12 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real OppFi Inc. (OPFI) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly see how your inputs affect OppFi Inc. (OPFI)’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Data: OppFi Inc.'s historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Watch OppFi Inc.'s intrinsic value update instantly as you make changes.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based OPFI DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates OppFi's intrinsic value.
- Test Scenarios: Explore different assumptions to assess potential valuation impacts.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose This Calculator for OppFi Inc. (OPFI)?
- Designed for Experts: A sophisticated tool tailored for financial analysts, CFOs, and consultants.
- Accurate Data: OppFi’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately assess OppFi Inc.’s (OPFI) fair value prior to making investment decisions.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis related to OppFi Inc. (OPFI).
- Consultants: Efficiently modify the template for valuation reports tailored to OppFi Inc. (OPFI) clients.
- Entrepreneurs: Acquire insights into financial modeling techniques employed by leading companies like OppFi Inc. (OPFI).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies using OppFi Inc. (OPFI) as a case study.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled OppFi Inc. (OPFI) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for OppFi Inc. (OPFI).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.