Gladstone Land Corporation (LAND) 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 Land Corporation (LAND) Bundle
Explore the financial potential of Gladstone Land Corporation (LAND) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Gladstone Land Corporation (LAND) and refine your investment approach.
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 | 40.7 | 57.0 | 75.3 | 89.2 | 90.4 | 111.2 | 136.8 | 168.2 | 206.9 | 254.5 |
| Revenue Growth, % | 0 | 40.15 | 32.07 | 18.48 | 1.3 | 23 | 23 | 23 | 23 | 23 |
| EBITDA | 31.2 | 44.3 | 58.2 | 69.7 | 70.6 | 86.3 | 106.1 | 130.5 | 160.5 | 197.5 |
| EBITDA, % | 76.68 | 77.75 | 77.23 | 78.14 | 78.15 | 77.59 | 77.59 | 77.59 | 77.59 | 77.59 |
| Depreciation | 21.4 | 29.4 | 43.6 | 55.3 | 37.3 | 59.0 | 72.5 | 89.2 | 109.7 | 135.0 |
| Depreciation, % | 52.56 | 51.52 | 57.91 | 61.99 | 41.21 | 53.04 | 53.04 | 53.04 | 53.04 | 53.04 |
| EBIT | 9.8 | 15.0 | 14.6 | 14.4 | 33.4 | 27.3 | 33.6 | 41.3 | 50.8 | 62.5 |
| EBIT, % | 24.12 | 26.23 | 19.33 | 16.15 | 36.94 | 24.55 | 24.55 | 24.55 | 24.55 | 24.55 |
| Total Cash | 13.7 | 9.2 | 16.7 | 61.1 | 18.6 | 35.8 | 44.0 | 54.2 | 66.6 | 82.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | .0 | .0 | .0 | .0 | 53.6 | 13.2 | 16.2 | 20.0 | 24.5 | 30.2 |
| Inventories, % | 0 | 0 | 0 | 0 | 59.32 | 11.86 | 11.86 | 11.86 | 11.86 | 11.86 |
| Accounts Payable | 10.1 | 9.1 | 10.9 | 16.3 | 10.3 | 18.9 | 23.2 | 28.6 | 35.1 | 43.2 |
| Accounts Payable, % | 24.9 | 15.92 | 14.44 | 18.23 | 11.39 | 16.98 | 16.98 | 16.98 | 16.98 | 16.98 |
| Capital Expenditure | -12.3 | -16.5 | -6.1 | -20.1 | -12.8 | -23.1 | -28.4 | -35.0 | -43.0 | -52.9 |
| Capital Expenditure, % | -30.2 | -28.95 | -8.13 | -22.55 | -14.17 | -20.8 | -20.8 | -20.8 | -20.8 | -20.8 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -76.3 | -47.5 | -85.1 | -64.2 | 33.4 | 5.5 | 6.7 | 8.3 | 10.2 | 12.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -57.1 | -35.7 | -45.8 | -23.7 | -1.8 | 90.3 | 52.1 | 64.1 | 78.8 | 97.0 |
| WACC, % | 3.8 | 3.8 | 3.8 | 3.8 | 6.48 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 335.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 99 | |||||||||
| Terminal Value | 4,228 | |||||||||
| Present Terminal Value | 3,419 | |||||||||
| Enterprise Value | 3,755 | |||||||||
| Net Debt | 556 | |||||||||
| Equity Value | 3,199 | |||||||||
| Diluted Shares Outstanding, MM | 36 | |||||||||
| Equity Value Per Share | 89.53 |
What You Will Get
- Real Gladstone Land Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Gladstone Land Corporation (LAND).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Gladstone Land Corporation’s (LAND) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Gladstone Land Corporation (LAND).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Comprehensive LAND Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries for a clear view of your valuation outcomes.
- Suitable for All Skill Levels: A straightforward, intuitive design tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Gladstone Land Corporation’s (LAND) preloaded data.
- 2. Modify Assumptions: Adjust crucial inputs such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Gladstone Land Corporation (LAND)?
- Accuracy: Reliable financial data from Gladstone Land Corporation ensures precise calculations.
- Flexibility: Users can easily adjust and test various inputs to suit their needs.
- Time-Saving: Eliminate the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial backgrounds.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Gladstone Land Corporation (LAND) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models tailored for Gladstone Land Corporation (LAND).
- Consultants: Deliver professional valuation insights on Gladstone Land Corporation (LAND) to clients quickly and accurately.
- Business Owners: Understand how real estate investment trusts like Gladstone Land Corporation (LAND) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Gladstone Land Corporation (LAND).
What the Template Contains
- Pre-Filled Data: Includes Gladstone Land Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Gladstone Land Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.