|
Capital Southwest Corporation (CSWC) DCF Valoración
US | Financial Services | Asset Management | NASDAQ
|
- ✓ 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
Capital Southwest Corporation (CSWC) Bundle
¡Descubra el verdadero potencial de Capital Southwest Corporation (CSWC) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los diferentes factores afectan la valoración de Capital Southwest Corporation (CSWC), todo dentro de una plantilla de Excel fácil de usar.
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 | 62.0 | 72.6 | 83.0 | 61.5 | 178.1 | 225.1 | 284.4 | 359.3 | 454.0 | 573.6 |
| Revenue Growth, % | 0 | 16.98 | 14.37 | -25.96 | 189.87 | 26.35 | 26.35 | 26.35 | 26.35 | 26.35 |
| EBITDA | -1.4 | 54.0 | 65.5 | 71.7 | 158.3 | 153.0 | 193.4 | 244.3 | 308.7 | 390.0 |
| EBITDA, % | -2.2 | 74.43 | 78.86 | 116.66 | 88.89 | 68 | 68 | 68 | 68 | 68 |
| Depreciation | 108.0 | -15.0 | 5.6 | 33.5 | 4.3 | 64.3 | 81.3 | 102.7 | 129.8 | 163.9 |
| Depreciation, % | 174.15 | -20.64 | 6.69 | 54.45 | 2.42 | 28.58 | 28.58 | 28.58 | 28.58 | 28.58 |
| EBIT | -109.4 | 69.0 | 59.9 | 38.2 | 154.0 | 97.2 | 122.8 | 155.2 | 196.0 | 247.7 |
| EBIT, % | -176.35 | 95.08 | 72.17 | 62.21 | 86.47 | 43.18 | 43.18 | 43.18 | 43.18 | 43.18 |
| Total Cash | 13.7 | 31.6 | 11.4 | 21.6 | 32.3 | 59.7 | 75.5 | 95.4 | 120.5 | 152.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10.4 | 10.7 | 14.3 | .0 | 30.6 | 29.7 | 37.5 | 47.4 | 59.9 | 75.7 |
| Account Receivables, % | 16.83 | 14.75 | 17.28 | 0 | 17.15 | 13.2 | 13.2 | 13.2 | 13.2 | 13.2 |
| Inventories | 26.0 | 43.6 | 27.3 | 22.3 | .0 | 77.0 | 97.3 | 123.0 | 155.4 | 196.3 |
| Inventories, % | 41.87 | 60.11 | 32.86 | 36.31 | 0 | 34.23 | 34.23 | 34.23 | 34.23 | 34.23 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | .0 | .0 | -2.0 | -.3 | .0 | -1.3 | -1.6 | -2.1 | -2.6 | -3.3 |
| Capital Expenditure, % | 0 | 0 | -2.4 | -0.45726 | -0.00729784 | -0.57362 | -0.57362 | -0.57362 | -0.57362 | -0.57362 |
| Tax Rate, % | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| EBITAT | -151.5 | 63.2 | 54.8 | 31.6 | 151.8 | 90.2 | 114.0 | 144.0 | 182.0 | 229.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -79.8 | 30.3 | 71.0 | 84.1 | 147.9 | 77.1 | 165.5 | 209.1 | 264.2 | 333.8 |
| WACC, % | 8.23 | 8.01 | 8 | 7.77 | 8.19 | 8.04 | 8.04 | 8.04 | 8.04 | 8.04 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 799.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 341 | |||||||||
| Terminal Value | 5,637 | |||||||||
| Present Terminal Value | 3,829 | |||||||||
| Enterprise Value | 4,629 | |||||||||
| Net Debt | 742 | |||||||||
| Equity Value | 3,887 | |||||||||
| Diluted Shares Outstanding, MM | 41 | |||||||||
| Equity Value Per Share | 95.44 |
What You Will Receive
- Authentic CSWC Data: Preloaded financial metrics – from revenue to EBIT – derived from real and forecasted figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to assess the effects of changes on Capital Southwest Corporation’s (CSWC) fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Eliminate the need to build models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive Historical Data: Access Capital Southwest Corporation’s (CSWC) past financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to suit your analysis.
- Real-Time Valuation: Witness the intrinsic value of Capital Southwest Corporation (CSWC) update instantly.
- Interactive Visualizations: Dashboard graphs illustrate valuation findings and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Capital Southwest Corporation’s (CSWC) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results Promptly: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to back your investment choices.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Updates: Instantly observe changes in Capital Southwest Corporation’s (CSWC) valuation as you tweak the inputs.
- Preloaded Data: Comes with actual financial information for Capital Southwest Corporation for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming for data-driven decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for portfolio management involving Capital Southwest Corporation (CSWC).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Capital Southwest Corporation (CSWC).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Finance Enthusiasts: Gain insights into how companies like Capital Southwest Corporation (CSWC) are valued in the financial markets.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Capital Southwest Corporation (CSWC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), incorporating parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that illustrate intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Capital Southwest Corporation (CSWC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.