OFS Capital Corporation (OFS) DCF Valuation

OFS Capital Corporation (OFS) DCF Valuation
  • ✓ 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

OFS Capital Corporation (OFS) Bundle

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

TOTAL:

Enhance your investment choices with the (OFS) DCF Calculator! Explore authentic financial data for OFS Capital Corporation, adjust growth predictions and expenses, and instantly observe how these modifications affect the intrinsic value of (OFS).


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 14.1 10.3 68.2 46.3 45.6 50.1 55.0 60.5 66.5 73.0
Revenue Growth, % 0 -26.81 560.39 -32.2 -1.45 9.89 9.89 9.89 9.89 9.89
EBITDA 35.1 .0 80.1 35.8 40.1 36.6 40.2 44.2 48.6 53.4
EBITDA, % 248.81 0 117.4 77.36 87.85 73.04 73.04 73.04 73.04 73.04
Depreciation 39.1 11.3 -51.7 37.5 .4 20.7 22.7 24.9 27.4 30.1
Depreciation, % 276.76 109.66 -75.75 80.98 0.89495 41.22 41.22 41.22 41.22 41.22
EBIT -3.9 -11.3 131.8 -1.7 39.6 5.5 6.1 6.7 7.4 8.1
EBIT, % -27.95 -109.66 193.16 -3.61 86.96 11.08 11.08 11.08 11.08 11.08
Total Cash 13.4 37.7 43.0 .5 45.3 36.0 39.5 43.4 47.7 52.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3.3 1.3 16.4 2.2 2.2
Account Receivables, % 23.72 12.56 23.99 4.76 4.86
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0.000009678668 0.000002931176 0.000002161788 0 0.000002954326 0.000002954326 0.000002954326 0.000002954326 0.000002954326
Accounts Payable 13.8 11.6 12.5 3.9 3.7 23.3 25.6 28.1 30.9 34.0
Accounts Payable, % 97.54 112.15 18.28 8.53 8.14 46.5 46.5 46.5 46.5 46.5
Capital Expenditure .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Capital Expenditure, % 0 0 0 0 0 0 0 0 0 0
Tax Rate, % -34.78 -34.78 -34.78 -34.78 -34.78 -34.78 -34.78 -34.78 -34.78 -34.78
EBITAT -3.9 -11.3 131.8 -1.7 53.4 5.5 6.1 6.7 7.4 8.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 45.5 -.1 65.9 41.4 53.6 41.0 30.4 33.4 36.7 40.3
WACC, % 8.22 8.22 8.22 8.22 8.22 8.22 8.22 8.22 8.22 8.22
PV UFCF
SUM PV UFCF 144.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 41
Terminal Value 661
Present Terminal Value 445
Enterprise Value 590
Net Debt 254
Equity Value 335
Diluted Shares Outstanding, MM 13
Equity Value Per Share 25.02

What You Will Get

  • Real OFS Financial Data: Pre-filled with OFS Capital Corporation'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'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 Historical Data: OFS Capital Corporation's (OFS) past financial statements and pre-filled forecasts.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Insights: Observe OFS Capital Corporation's intrinsic value recalculating instantly.
  • Informative Visualizations: Dashboard charts present valuation results and essential metrics clearly.
  • Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.

How It Works

  • Download: Obtain the pre-built Excel file containing OFS Capital Corporation's (OFS) financial data.
  • Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC as per your analysis.
  • Update Automatically: Enjoy real-time updates on intrinsic value and NPV calculations.
  • Test Scenarios: Generate various projections and instantly compare the results.
  • Make Decisions: Leverage the valuation findings to inform your investment strategy for OFS Capital Corporation (OFS).

Why Choose This Calculator for OFS Capital Corporation (OFS)?

  • User-Friendly Interface: Perfect for both novices and seasoned investors.
  • Customizable Inputs: Adjust variables easily to suit your financial analysis.
  • Real-Time Feedback: Observe immediate changes in OFS's valuation as you modify inputs.
  • Pre-Loaded Data: Comes with OFS's current financial metrics for swift evaluations.
  • Preferred by Experts: Utilized by analysts and investors for making strategic choices.

Who Should Use OFS Capital Corporation (OFS)?

  • Institutional Investors: Develop comprehensive and trustworthy valuation models for investment assessment.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decision-making.
  • Financial Consultants: Offer clients precise valuation insights for OFS Capital Corporation stock.
  • Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
  • Market Analysts: Gain insights into how companies like OFS Capital Corporation are valued within the investment landscape.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled OFS Capital Corporation (OFS) 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 OFS Capital Corporation (OFS).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.