OFS Credit Company, Inc. (OCCI) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
OFS Credit Company, Inc. (OCCI) Bundle
Looking to evaluate the intrinsic value of OFS Credit Company, Inc.? Our (OCCI) DCF Calculator merges real-world data with extensive customization features, allowing you to adjust forecasts and enhance your investment strategies.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | -1.6 | 23.0 | -10.4 | 1.4 | 18.7 | 9.3 | 4.7 | 2.3 | 1.2 | .6 |
Revenue Growth, % | 0 | -1504.13 | -145.17 | -113.55 | 1228.53 | -50 | -50 | -50 | -50 | -50 |
EBITDA | -3.7 | .0 | -9.5 | -.2 | .0 | 3.4 | 1.7 | .8 | .4 | .2 |
EBITDA, % | 224.76 | 0 | 91.91 | -10.84 | 0 | 36.21 | 36.21 | 36.21 | 36.21 | 36.21 |
Depreciation | 13.1 | -7.5 | 35.4 | 6.9 | .0 | -2.5 | -1.2 | -.6 | -.3 | -.2 |
Depreciation, % | -801.7 | -32.55 | -340.9 | 492.2 | 0 | -26.51 | -26.51 | -26.51 | -26.51 | -26.51 |
EBIT | -16.8 | 7.5 | -44.9 | -7.1 | .0 | 2.5 | 1.2 | .6 | .3 | .2 |
EBIT, % | 1026.46 | 32.55 | 432.81 | -503.04 | 0 | 26.51 | 26.51 | 26.51 | 26.51 | 26.51 |
Total Cash | 6.4 | 15.0 | 12.5 | 16.8 | 24.7 | 1.2 | .6 | .3 | .2 | .1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .3 | .6 | .8 | .8 | 1.1 | .6 | .3 | .1 | .1 |
Account Receivables, % | 0 | 1.26 | -5.85 | 59.23 | 4.29 | 11.79 | 11.79 | 11.79 | 11.79 | 11.79 |
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 | 5.9 | .0 | .0 | .0 | .5 | .2 | .1 | .1 | .0 |
Accounts Payable, % | 0 | 25.68 | 0 | 0 | 0 | 5.14 | 5.14 | 5.14 | 5.14 | 5.14 |
Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 0 | 0 | 0 | -0.00014219573 | 0 | -0.000028439146 | -0.000028439146 | -0.000028439146 | -0.000028439146 | -0.000028439146 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -16.8 | 7.5 | -44.9 | -7.1 | .0 | 2.5 | 1.2 | .6 | .3 | .2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -3.7 | 5.6 | -15.8 | -.4 | .0 | .2 | .3 | .2 | .1 | .0 |
WACC, % | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 |
PV UFCF | ||||||||||
SUM PV UFCF | .6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | 1 | |||||||||
Net Debt | -25 | |||||||||
Equity Value | 26 | |||||||||
Diluted Shares Outstanding, MM | 16 | |||||||||
Equity Value Per Share | 1.58 |
What You Will Get
- Real OCCI Financial Data: Pre-filled with OFS Credit Company, Inc.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See OFS Credit Company, Inc.'s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Financial Data: OFS Credit Company, Inc.'s historical financial statements and pre-filled projections.
- Customizable Assumptions: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view OFS Credit Company, Inc.'s intrinsic value as you make changes.
- Insightful Visualizations: Interactive dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template containing OFS Credit Company, Inc. (OCCI) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth rates, profit margins).
- Step 4: Instantly see the updated results, including the intrinsic value of OFS Credit Company, Inc. (OCCI).
- Step 5: Make well-informed investment decisions or create reports based on the generated outputs.
Why Choose This Calculator for OFS Credit Company, Inc. (OCCI)?
- Designed for Investors: A sophisticated tool tailored for investors, analysts, and financial advisors.
- Accurate Financial Data: OCCI’s historical and forecasted financials integrated for precise analysis.
- Dynamic Scenario Analysis: Effortlessly test various investment scenarios and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Detailed instructions guide you step-by-step through the calculation process.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive valuation models for assessing OCCI's performance.
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic decisions regarding OCCI.
- Financial Consultants: Deliver precise valuation analyses to clients interested in OCCI.
- Students and Instructors: Utilize actual market data to enhance learning in financial modeling with OCCI.
- Market Analysts: Gain insights into how companies like OFS Credit Company, Inc. (OCCI) are valued in the financial landscape.
What the Template Contains
- Pre-Filled DCF Model: OFS Credit Company's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate OFS Credit Company's profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.