Gladstone Capital Corporation (GLAD) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Gladstone Capital Corporation (GLAD) Bundle
Engineered for accuracy, our Gladstone Capital Corporation (GLAD) DCF Calculator empowers you to evaluate company valuation using authentic financial data, offering complete flexibility to modify all essential parameters for enhanced forecasting.
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 | 8.4 | 94.7 | 32.4 | 86.4 | 96.6 | 131.9 | 180.0 | 245.7 | 335.3 | 457.7 |
Revenue Growth, % | 0 | 1028.22 | -65.83 | 166.98 | 11.79 | 36.49 | 36.49 | 36.49 | 36.49 | 36.49 |
EBITDA | 44.3 | -1.2 | 36.9 | 65.0 | .0 | 72.3 | 98.6 | 134.6 | 183.7 | 250.8 |
EBITDA, % | 527.89 | -1.27 | 114.06 | 75.25 | 0 | 54.8 | 54.8 | 54.8 | 54.8 | 54.8 |
Depreciation | 40.9 | -40.2 | 34.3 | .0 | .0 | 41.6 | 56.7 | 77.4 | 105.7 | 144.2 |
Depreciation, % | 487.66 | -42.42 | 105.85 | 0 | 0 | 31.52 | 31.52 | 31.52 | 31.52 | 31.52 |
EBIT | 3.4 | 39.0 | 2.7 | 65.0 | .0 | 43.5 | 59.3 | 81.0 | 110.6 | 150.9 |
EBIT, % | 40.23 | 41.15 | 8.22 | 75.25 | 0 | 32.97 | 32.97 | 32.97 | 32.97 | 32.97 |
Total Cash | 2.4 | .7 | 2.0 | 1.3 | 2.3 | 10.5 | 14.3 | 19.5 | 26.6 | 36.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.1 | 5.3 | 5.9 | 9.0 | 5.9 | 26.7 | 36.5 | 49.8 | 67.9 | 92.7 |
Account Receivables, % | 60.78 | 5.61 | 18.34 | 10.45 | 6.13 | 20.26 | 20.26 | 20.26 | 20.26 | 20.26 |
Inventories | 7.6 | .0 | .0 | .0 | .0 | 23.8 | 32.5 | 44.3 | 60.5 | 82.6 |
Inventories, % | 90.19 | 0.000001055554 | 0.000003088803 | 0 | 0 | 18.04 | 18.04 | 18.04 | 18.04 | 18.04 |
Accounts Payable | 1.6 | 2.3 | 3.0 | 4.0 | 4.1 | 10.3 | 14.1 | 19.2 | 26.3 | 35.8 |
Accounts Payable, % | 18.55 | 2.41 | 9.32 | 4.58 | 4.29 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
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 | 3.4 | 39.0 | 2.7 | 65.0 | .0 | 43.5 | 59.3 | 81.0 | 110.6 | 150.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 33.2 | 6.9 | 37.0 | 62.9 | 3.3 | 46.6 | 101.4 | 138.4 | 188.9 | 257.9 |
WACC, % | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 | 9.83 |
PV UFCF | ||||||||||
SUM PV UFCF | 522.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 263 | |||||||||
Terminal Value | 3,361 | |||||||||
Present Terminal Value | 2,104 | |||||||||
Enterprise Value | 2,626 | |||||||||
Net Debt | -2 | |||||||||
Equity Value | 2,628 | |||||||||
Diluted Shares Outstanding, MM | 22 | |||||||||
Equity Value Per Share | 120.66 |
What You Will Get
- Accurate GLAD Financials: Access historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are calculated on-the-fly.
- Comprehensive Scenario Analysis: Evaluate various scenarios to assess Gladstone Capital's future performance.
- User-Friendly Design: Crafted for finance professionals while remaining easy to navigate for newcomers.
Key Features
- Customizable Investment Metrics: Adjust essential factors such as dividend yield, loan-to-value ratios, and portfolio diversification.
- Instant Portfolio Valuation: Provides real-time calculations for net asset value (NAV) and other key performance indicators.
- Industry-Leading Precision: Incorporates Gladstone’s actual financial data for accurate investment assessments.
- Effortless Risk Analysis: Evaluate various investment scenarios and analyze potential impacts with ease.
- Efficiency Booster: Streamline the investment analysis process without the hassle of creating detailed models from the ground up.
How It Works
- Download: Obtain the pre-built Excel file containing Gladstone Capital Corporation’s (GLAD) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose Gladstone Capital Corporation (GLAD) Calculator?
- Accuracy: Utilizes real Gladstone financial data to ensure precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Finance Students: Explore investment strategies and apply them using real-world data from Gladstone Capital Corporation (GLAD).
- Academics: Integrate advanced financial models into your curriculum or research focused on Gladstone Capital Corporation (GLAD).
- Investors: Evaluate your investment hypotheses and analyze the performance metrics of Gladstone Capital Corporation (GLAD).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Gladstone Capital Corporation (GLAD).
- Small Business Owners: Understand the valuation methods applied to large public entities like Gladstone Capital Corporation (GLAD).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Gladstone Capital Corporation (GLAD) 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 Gladstone Capital Corporation (GLAD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.