Prospect Capital Corporation (PSEC) 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
Prospect Capital Corporation (PSEC) Bundle
Enhance your investment strategies with the Prospect Capital Corporation (PSEC) DCF Calculator! Explore real financial data, adjust growth predictions and expenses, and instantly observe how these changes affect the intrinsic value of PSEC.
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 | 19.0 | 1,017.1 | 622.5 | 852.2 | 770.3 | 940.7 | 1,148.9 | 1,403.1 | 1,713.5 | 2,092.6 |
| Revenue Growth, % | 0 | 5258.98 | -38.8 | 36.91 | -9.61 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 |
| EBITDA | -16.2 | 10.3 | 897.3 | -101.6 | .0 | 6.8 | 8.3 | 10.1 | 12.3 | 15.1 |
| EBITDA, % | -85.48 | 1.01 | 144.15 | -11.93 | 0 | 0.72035 | 0.72035 | 0.72035 | 0.72035 | 0.72035 |
| Depreciation | 629.5 | -478.4 | -12.4 | 764.4 | -580.1 | 123.0 | 150.2 | 183.4 | 224.0 | 273.5 |
| Depreciation, % | 3316.71 | -47.04 | -2 | 89.7 | -75.3 | 13.07 | 13.07 | 13.07 | 13.07 | 13.07 |
| EBIT | -645.7 | 488.7 | 909.7 | -866.1 | 580.1 | 43.9 | 53.7 | 65.5 | 80.0 | 97.8 |
| EBIT, % | -3402.19 | 48.05 | 146.14 | -101.63 | 75.3 | 4.67 | 4.67 | 4.67 | 4.67 | 4.67 |
| Total Cash | 44.6 | 63.6 | 35.4 | 90.6 | 85.9 | 251.6 | 307.2 | 375.2 | 458.2 | 559.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 12.9 | 25.5 | 13.7 | 24.4 | 28.8 | 149.0 | 181.9 | 222.2 | 271.3 | 331.4 |
| Account Receivables, % | 67.87 | 2.51 | 2.2 | 2.86 | 3.74 | 15.84 | 15.84 | 15.84 | 15.84 | 15.84 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0.000005268982 | 0 | 0 | 0.000000117 | 0 | 0.000001077265 | 0.000001077265 | 0.000001077265 | 0.000001077265 | 0.000001077265 |
| Accounts Payable | 51.5 | 50.7 | 50.3 | 53.7 | 47.1 | 236.1 | 288.3 | 352.1 | 430.0 | 525.2 |
| Accounts Payable, % | 271.24 | 4.98 | 8.08 | 6.3 | 6.11 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 |
| 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, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -645.7 | 488.7 | 2,065.0 | -866.1 | 580.1 | 43.9 | 53.7 | 65.5 | 80.0 | 97.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 22.4 | -3.1 | 2,064.1 | -109.0 | -11.1 | 235.8 | 223.1 | 272.5 | 332.8 | 406.4 |
| WACC, % | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,158.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 415 | |||||||||
| Terminal Value | 7,331 | |||||||||
| Present Terminal Value | 5,070 | |||||||||
| Enterprise Value | 6,228 | |||||||||
| Net Debt | 2,348 | |||||||||
| Equity Value | 3,880 | |||||||||
| Diluted Shares Outstanding, MM | 625 | |||||||||
| Equity Value Per Share | 6.21 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled financial data for Prospect Capital Corporation (PSEC).
- Accurate Data: Historical performance metrics and future projections (highlighted in the yellow cells).
- Assumption Adjustability: Modify key forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Prospect Capital Corporation (PSEC).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Real-Time PSEC Data: Pre-loaded with Prospect Capital Corporation's historical financials and future projections.
- Comprehensive Customization: Modify revenue growth, profit margins, discount rates, tax obligations, and capital expenditures.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation results.
- Intuitive User Interface: Clean, organized, and crafted for both industry professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based PSEC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Prospect Capital Corporation’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the findings to inform your investment or financial strategy.
Why Choose This Calculator for Prospect Capital Corporation (PSEC)?
- Designed for Investors: A specialized tool tailored for asset managers, analysts, and financial advisors.
- Comprehensive Data: Prospect Capital Corporation’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Instantly computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Investors: Accurately assess Prospect Capital Corporation's (PSEC) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis of (PSEC).
- Consultants: Easily modify the template for valuation reports tailored to clients focusing on (PSEC).
- Entrepreneurs: Discover financial modeling techniques employed by leading firms, including insights relevant to (PSEC).
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies applicable to (PSEC).
What the Template Contains
- Historical Data: Includes Prospect Capital Corporation’s (PSEC) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Prospect Capital Corporation’s (PSEC) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Prospect Capital Corporation’s (PSEC) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.