|
FS KKR Capital Corp. (FSK) Valoración de DCF
US | Financial Services | Asset Management | NYSE
|
- ✓ 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
FS KKR Capital Corp. (FSK) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (FSK)! Con datos reales de FS KKR Capital Corp. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (FSK) al igual que un inversor experimentado.
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 | 779.0 | 639.0 | 1,081.0 | 1,635.0 | 1,830.0 | 2,353.3 | 3,026.1 | 3,891.4 | 5,004.1 | 6,435.0 |
Revenue Growth, % | 0 | -17.97 | 69.17 | 51.25 | 11.93 | 28.59 | 28.59 | 28.59 | 28.59 | 28.59 |
EBITDA | 253.0 | 149.0 | 7.2 | 1,872.0 | 1,175.0 | 1,038.6 | 1,335.5 | 1,717.4 | 2,208.5 | 2,840.0 |
EBITDA, % | 32.48 | 23.32 | 0.66235 | 114.5 | 64.21 | 44.13 | 44.13 | 44.13 | 44.13 | 44.13 |
Depreciation | 438.0 | 362.0 | -474.0 | 1,370.0 | -206.0 | 666.3 | 856.8 | 1,101.8 | 1,416.8 | 1,821.9 |
Depreciation, % | 56.23 | 56.65 | -43.85 | 83.79 | -11.26 | 28.31 | 28.31 | 28.31 | 28.31 | 28.31 |
EBIT | -185.0 | -213.0 | 481.2 | 502.0 | 1,381.0 | 440.5 | 566.5 | 728.4 | 936.7 | 1,204.6 |
EBIT, % | -23.75 | -33.33 | 44.51 | 30.7 | 75.46 | 18.72 | 18.72 | 18.72 | 18.72 | 18.72 |
Total Cash | 106.0 | 191.0 | 377.0 | 251.0 | 231.0 | 500.5 | 643.6 | 827.7 | 1,064.4 | 1,368.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 739.0 | 245.0 | 720.0 | 439.0 | 536.0 | 1,204.6 | 1,549.1 | 1,992.0 | 2,561.6 | 3,294.1 |
Account Receivables, % | 94.87 | 38.34 | 66.6 | 26.85 | 29.29 | 51.19 | 51.19 | 51.19 | 51.19 | 51.19 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 134.0 | 99.0 | 248.0 | 296.0 | 294.0 | 422.7 | 543.5 | 698.9 | 898.8 | 1,155.8 |
Accounts Payable, % | 17.2 | 15.49 | 22.94 | 18.1 | 16.07 | 17.96 | 17.96 | 17.96 | 17.96 | 17.96 |
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, % | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 | 3.06 |
EBITAT | -179.9 | -218.4 | 477.4 | 398.1 | 1,338.7 | 416.5 | 535.5 | 688.7 | 885.6 | 1,138.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -346.9 | 602.6 | -322.6 | 2,097.1 | 1,033.7 | 542.8 | 1,168.7 | 1,502.9 | 1,932.6 | 2,485.3 |
WACC, % | 7.6 | 7.69 | 7.67 | 7.04 | 7.6 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
PV UFCF | ||||||||||
SUM PV UFCF | 5,900.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 2,535 | |||||||||
Terminal Value | 45,925 | |||||||||
Present Terminal Value | 31,960 | |||||||||
Enterprise Value | 37,861 | |||||||||
Net Debt | 7,956 | |||||||||
Equity Value | 29,905 | |||||||||
Diluted Shares Outstanding, MM | 280 | |||||||||
Equity Value Per Share | 106.70 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: FS KKR Capital Corp. (FSK) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life FSK Financials: Pre-filled historical and projected data for FS KKR Capital Corp. (FSK).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate FSK’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize FSK’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-configured Excel file containing FS KKR Capital Corp.'s (FSK) financial data.
- Customize: Modify forecasts, including revenue growth, EBITDA %, and WACC to fit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop multiple projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for FS KKR Capital Corp. (FSK)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financial Data: FS KKR's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and trustworthy valuation models for portfolio management of FS KKR Capital Corp. (FSK).
- Corporate Finance Departments: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Financial Consultants and Advisors: Offer clients precise valuation insights for FS KKR Capital Corp. (FSK) stock.
- Students and Instructors: Utilize real market data to enhance learning and practice in financial modeling.
- Investment Enthusiasts: Gain insights into how companies like FS KKR Capital Corp. (FSK) are assessed in the financial markets.
What the Template Contains
- Pre-Filled DCF Model: FS KKR Capital Corp.'s (FSK) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate FS KKR Capital Corp.'s (FSK) 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.