EastGroup Properties, Inc. (EGP) 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
EastGroup Properties, Inc. (EGP) Bundle
Gain insight into your EastGroup Properties, Inc. (EGP) valuation analysis with our state-of-the-art DCF Calculator! This Excel template is preloaded with real (EGP) data, enabling you to adjust forecasts and assumptions for a precise calculation of EastGroup Properties, Inc.'s intrinsic value.
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 | 331.4 | 363.0 | 409.5 | 487.0 | 570.6 | 654.0 | 749.5 | 859.0 | 984.5 | 1,128.3 |
| Revenue Growth, % | 0 | 9.55 | 12.8 | 18.94 | 17.16 | 14.61 | 14.61 | 14.61 | 14.61 | 14.61 |
| EBITDA | 221.5 | 245.5 | 278.8 | 337.4 | 399.2 | 447.0 | 512.4 | 587.2 | 673.0 | 771.3 |
| EBITDA, % | 66.83 | 67.64 | 68.09 | 69.28 | 69.97 | 68.36 | 68.36 | 68.36 | 68.36 | 68.36 |
| Depreciation | 215.3 | 237.6 | 258.1 | 304.6 | 171.1 | 374.0 | 428.6 | 491.3 | 563.0 | 645.3 |
| Depreciation, % | 64.96 | 65.44 | 63.03 | 62.54 | 29.98 | 57.19 | 57.19 | 57.19 | 57.19 | 57.19 |
| EBIT | 6.2 | 8.0 | 20.7 | 32.8 | 228.1 | 73.0 | 83.7 | 95.9 | 110.0 | 126.0 |
| EBIT, % | 1.87 | 2.2 | 5.06 | 6.74 | 39.98 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
| Total Cash | .2 | .0 | 4.4 | .1 | 40.3 | 10.7 | 12.3 | 14.1 | 16.2 | 18.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 46.0 | 51.3 | 66.8 | 71.4 | 83.8 | 96.3 | 110.4 | 126.5 | 145.0 | 166.2 |
| Account Receivables, % | 13.87 | 14.13 | 16.31 | 14.66 | 14.68 | 14.73 | 14.73 | 14.73 | 14.73 | 14.73 |
| Inventories | -3.5 | .0 | 5.7 | -38.4 | .0 | -9.9 | -11.3 | -12.9 | -14.8 | -17.0 |
| Inventories, % | -1.05 | 0 | 1.39 | -7.87 | 0 | -1.51 | -1.51 | -1.51 | -1.51 | -1.51 |
| Accounts Payable | .0 | 2.4 | 10.6 | 11.0 | 15.0 | 10.6 | 12.2 | 14.0 | 16.0 | 18.4 |
| Accounts Payable, % | 0 | 0.66745 | 2.58 | 2.26 | 2.63 | 1.63 | 1.63 | 1.63 | 1.63 | 1.63 |
| Capital Expenditure | -37.8 | -33.1 | -33.3 | -40.9 | .0 | -48.5 | -55.5 | -63.6 | -72.9 | -83.6 |
| Capital Expenditure, % | -11.4 | -9.13 | -8.13 | -8.39 | 0 | -7.41 | -7.41 | -7.41 | -7.41 | -7.41 |
| Tax Rate, % | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 | 0.02842212 |
| EBITAT | 4.4 | 5.4 | 16.3 | 32.8 | 228.1 | 60.9 | 69.8 | 80.0 | 91.7 | 105.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 139.4 | 203.4 | 228.0 | 336.4 | 352.4 | 379.4 | 431.8 | 494.9 | 567.2 | 650.1 |
| WACC, % | 8.08 | 8.06 | 8.15 | 8.33 | 8.33 | 8.19 | 8.19 | 8.19 | 8.19 | 8.19 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,962.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 676 | |||||||||
| Terminal Value | 16,130 | |||||||||
| Present Terminal Value | 10,881 | |||||||||
| Enterprise Value | 12,844 | |||||||||
| Net Debt | 1,656 | |||||||||
| Equity Value | 11,187 | |||||||||
| Diluted Shares Outstanding, MM | 45 | |||||||||
| Equity Value Per Share | 246.79 |
What You Will Get
- Real EastGroup Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for EastGroup Properties, Inc. (EGP).
- 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 EastGroup Properties, Inc.'s (EGP) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to EastGroup Properties, Inc. (EGP).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility in your evaluations.
Key Features
- Advanced DCF Calculator: Features comprehensive unlevered and levered DCF valuation models tailored for EastGroup Properties, Inc. (EGP).
- WACC Calculator: Comes with a pre-built Weighted Average Cost of Capital sheet that allows for customizable inputs specific to EGP.
- Editable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit the projections for EastGroup Properties, Inc. (EGP).
- Built-In Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to EastGroup Properties, Inc. (EGP).
- Dashboard and Charts: Visual representations provide a summary of key valuation metrics for straightforward analysis of EastGroup Properties, Inc. (EGP).
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered EastGroup Properties, Inc. (EGP) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for EastGroup Properties, Inc. (EGP)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool favored by real estate analysts, investors, and portfolio managers.
- Up-to-Date Data: EastGroup Properties’ (EGP) historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various investment scenarios and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential performance metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Investors: Accurately assess EastGroup Properties, Inc.'s (EGP) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to EastGroup Properties, Inc. (EGP).
- Consultants: Efficiently customize the template for valuation reports tailored to EastGroup Properties, Inc. (EGP) clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading real estate investment trusts like EastGroup Properties, Inc. (EGP).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to EastGroup Properties, Inc. (EGP).
What the Template Contains
- Pre-Filled Data: Includes EastGroup Properties, Inc. (EGP) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for EastGroup Properties, Inc. (EGP).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to EastGroup Properties, Inc. (EGP).
- Key Financial Ratios: Analyze EastGroup Properties, Inc. (EGP) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease for EastGroup Properties, Inc. (EGP).
- Clear Dashboard: Charts and tables summarizing key valuation results for EastGroup Properties, Inc. (EGP).