Gladstone Commercial Corporation (GOOD) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Gladstone Commercial Corporation (GOOD) Bundle
Designed for accuracy, our (GOOD) DCF Calculator enables you to evaluate Gladstone Commercial Corporation's valuation using real-world financial data, offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 114.4 | 133.2 | 137.7 | 149.0 | 147.6 | 157.2 | 167.4 | 178.3 | 190.0 | 202.3 |
Revenue Growth, % | 0 | 16.4 | 3.41 | 8.2 | -0.9377 | 6.51 | 6.51 | 6.51 | 6.51 | 6.51 |
EBITDA | 88.7 | 90.5 | 97.0 | 100.9 | 101.3 | 110.8 | 118.0 | 125.7 | 133.8 | 142.6 |
EBITDA, % | 77.56 | 67.97 | 70.43 | 67.7 | 68.64 | 70.46 | 70.46 | 70.46 | 70.46 | 70.46 |
Depreciation | 78.4 | 96.2 | 102.8 | 104.2 | 57.9 | 102.0 | 108.7 | 115.8 | 123.3 | 131.3 |
Depreciation, % | 68.52 | 72.27 | 74.66 | 69.91 | 39.2 | 64.91 | 64.91 | 64.91 | 64.91 | 64.91 |
EBIT | 10.3 | -5.7 | -5.8 | -3.3 | 43.4 | 8.7 | 9.3 | 9.9 | 10.5 | 11.2 |
EBIT, % | 9.04 | -4.3 | -4.23 | -2.21 | 29.44 | 5.55 | 5.55 | 5.55 | 5.55 | 5.55 |
Total Cash | 6.8 | 11.0 | 8.0 | 11.7 | 12.0 | 11.3 | 12.0 | 12.8 | 13.7 | 14.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 37.2 | 36.6 | .0 | .0 | .0 | 18.8 | 20.1 | 21.4 | 22.8 | 24.3 |
Account Receivables, % | 32.5 | 27.45 | 0 | 0 | 0 | 11.99 | 11.99 | 11.99 | 11.99 | 11.99 |
Inventories | -.2 | .0 | -1.2 | 3.3 | 27.5 | 6.2 | 6.6 | 7.1 | 7.5 | 8.0 |
Inventories, % | -0.21856 | -0.00675919 | -0.84612 | 2.21 | 18.63 | 3.95 | 3.95 | 3.95 | 3.95 | 3.95 |
Accounts Payable | 5.6 | 4.5 | 6.7 | 9.6 | 13.6 | 9.0 | 9.6 | 10.3 | 10.9 | 11.6 |
Accounts Payable, % | 4.87 | 3.35 | 4.89 | 6.45 | 9.21 | 5.75 | 5.75 | 5.75 | 5.75 | 5.75 |
Capital Expenditure | -7.6 | -6.4 | -5.3 | -6.8 | .0 | -6.2 | -6.6 | -7.1 | -7.5 | -8.0 |
Capital Expenditure, % | -6.62 | -4.78 | -3.88 | -4.58 | 0 | -3.97 | -3.97 | -3.97 | -3.97 | -3.97 |
Tax Rate, % | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 | -1.28 |
EBITAT | -21.0 | 4.7 | 12.0 | 8.2 | 44.0 | 1.7 | 1.9 | 2.0 | 2.1 | 2.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 18.5 | 93.8 | 149.4 | 104.0 | 81.6 | 95.4 | 102.9 | 109.6 | 116.7 | 124.3 |
WACC, % | 4.69 | 4.69 | 4.69 | 4.69 | 7.38 | 5.23 | 5.23 | 5.23 | 5.23 | 5.23 |
PV UFCF | ||||||||||
SUM PV UFCF | 469.1 | |||||||||
Long Term Growth Rate, % | 3.60 | |||||||||
Free cash flow (T + 1) | 129 | |||||||||
Terminal Value | 7,920 | |||||||||
Present Terminal Value | 6,140 | |||||||||
Enterprise Value | 6,609 | |||||||||
Net Debt | 732 | |||||||||
Equity Value | 5,877 | |||||||||
Diluted Shares Outstanding, MM | 40 | |||||||||
Equity Value Per Share | 147.13 |
What You Will Get
- Real GOOD Financial Data: Pre-filled with Gladstone Commercial 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 Gladstone Commercial Corporation’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
- Customizable Financial Inputs: Adjust essential parameters such as rental income growth, operating expenses, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Gladstone Commercial Corporation's (GOOD) actual financial data for reliable valuation results.
- Simplified Scenario Analysis: Easily explore various assumptions and evaluate different outcomes.
- Efficiency Booster: Remove the hassle of constructing detailed valuation models from the ground up.
How It Works
- Download: Obtain the pre-formatted Excel file containing Gladstone Commercial Corporation's (GOOD) financial data.
- Customize: Modify projections, such as rental income growth, operating margins, and discount rates.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose Gladstone Commercial Corporation (GOOD)?
- Maximize Returns: Benefit from a well-established investment strategy tailored for real estate.
- Transparent Operations: Access clear and comprehensive reports to stay informed about your investments.
- Expert Management: Rely on a team of seasoned professionals with extensive industry experience.
- Diverse Portfolio: Invest in a variety of properties to spread risk and enhance stability.
- Strong Track Record: Join a company with a history of delivering consistent returns to its investors.
Who Should Use Gladstone Commercial Corporation (GOOD)?
- Real Estate Investors: Gain insights into commercial property investments with reliable data.
- Market Analysts: Utilize comprehensive reports to enhance your market analysis.
- Investment Advisors: Easily customize presentations for clients looking to invest in commercial real estate.
- Finance Students: Explore real-world applications of commercial property valuation and investment strategies.
- Portfolio Managers: Integrate Gladstone's offerings into your investment portfolio for diversification.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Gladstone Commercial Corporation (GOOD) 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 Commercial Corporation (GOOD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.