|
Alexandria Real Estate Equities, Inc. (ARE) DCF Valuation
US | Real Estate | REIT - Office | NYSE
|
- ✓ 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
Alexandria Real Estate Equities, Inc. (ARE) Bundle
Whether you’re an investor or an analyst, this (ARE) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Alexandria Real Estate Equities, Inc., you can adjust forecasts and observe the effects in real-time.
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 | 1,531.3 | 1,885.6 | 2,114.2 | 2,589.0 | 2,885.7 | 3,384.8 | 3,970.2 | 4,656.8 | 5,462.2 | 6,406.8 |
| Revenue Growth, % | 0 | 23.14 | 12.12 | 22.46 | 11.46 | 17.29 | 17.29 | 17.29 | 17.29 | 17.29 |
| EBITDA | 1,498.6 | 1,230.2 | 1,351.4 | 1,629.2 | 1,448.7 | 2,302.7 | 2,701.0 | 3,168.1 | 3,716.0 | 4,358.7 |
| EBITDA, % | 97.87 | 65.24 | 63.92 | 62.93 | 50.2 | 68.03 | 68.03 | 68.03 | 68.03 | 68.03 |
| Depreciation | 1,022.6 | 987.6 | 1,552.4 | 2,374.8 | 1,093.5 | 2,181.2 | 2,558.4 | 3,000.9 | 3,519.9 | 4,128.6 |
| Depreciation, % | 66.78 | 52.38 | 73.43 | 91.73 | 37.89 | 64.44 | 64.44 | 64.44 | 64.44 | 64.44 |
| EBIT | 476.1 | 242.6 | -201.1 | -745.6 | 355.2 | 121.6 | 142.6 | 167.2 | 196.2 | 230.1 |
| EBIT, % | 31.09 | 12.86 | -9.51 | -28.8 | 12.31 | 3.59 | 3.59 | 3.59 | 3.59 | 3.59 |
| Total Cash | 189.7 | 568.5 | 361.3 | 825.2 | 618.2 | 764.5 | 896.7 | 1,051.7 | 1,233.6 | 1,447.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10.7 | 7.3 | 7.4 | 66.8 | 24.1 | 32.8 | 38.5 | 45.2 | 53.0 | 62.2 |
| Account Receivables, % | 0.69817 | 0.38889 | 0.34903 | 2.58 | 0.83349 | 0.97027 | 0.97027 | 0.97027 | 0.97027 | 0.97027 |
| Inventories | 306.8 | 637.6 | 489.6 | -49.1 | -32.6 | 500.8 | 587.5 | 689.1 | 808.2 | 948.0 |
| Inventories, % | 20.04 | 33.82 | 23.16 | -1.9 | -1.13 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 |
| Accounts Payable | 199.0 | 285.0 | 513.4 | 389.7 | 524.4 | 579.6 | 679.9 | 797.5 | 935.4 | 1,097.1 |
| Accounts Payable, % | 13 | 15.12 | 24.28 | 15.05 | 18.17 | 17.12 | 17.12 | 17.12 | 17.12 | 17.12 |
| Capital Expenditure | .0 | -3,268.8 | -7,333.9 | .0 | .0 | -1,353.9 | -1,588.1 | -1,862.7 | -2,184.9 | -2,562.7 |
| Capital Expenditure, % | 0 | -173.35 | -346.9 | 0 | 0 | -40 | -40 | -40 | -40 | -40 |
| Tax Rate, % | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 | 63.12 |
| EBITAT | 211.3 | 173.4 | -128.1 | -579.9 | 131.0 | 71.5 | 83.9 | 98.4 | 115.4 | 135.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,115.4 | -2,349.3 | -5,533.2 | 2,150.4 | 1,385.4 | 411.8 | 1,062.2 | 1,245.9 | 1,461.4 | 1,714.1 |
| WACC, % | 6.71 | 7.2 | 7.06 | 7.32 | 6.57 | 6.97 | 6.97 | 6.97 | 6.97 | 6.97 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,670.9 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,783 | |||||||||
| Terminal Value | 59,995 | |||||||||
| Present Terminal Value | 42,833 | |||||||||
| Enterprise Value | 47,504 | |||||||||
| Net Debt | 11,080 | |||||||||
| Equity Value | 36,423 | |||||||||
| Diluted Shares Outstanding, MM | 171 | |||||||||
| Equity Value Per Share | 213.12 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ARE financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Alexandria Real Estate Equities, Inc. (ARE) valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Real-Life ARE Data: Pre-filled with Alexandria Real Estate Equities, Inc.'s historical financials and future growth projections.
- Fully Customizable Inputs: Modify revenue growth rates, operating margins, WACC, tax rates, and capital expenditures as needed.
- Dynamic Valuation Model: Automatically updates Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to explore various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and crafted for both professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based ARE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Alexandria Real Estate Equities' intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose Alexandria Real Estate Equities, Inc. (ARE)?
- Save Time: Utilize our comprehensive tools without the hassle of building from the ground up.
- Enhance Accuracy: Access to trusted real estate data and analytics minimizes valuation errors.
- Fully Customizable: Adjust the model to align with your specific market insights and forecasts.
- User-Friendly: Intuitive visuals and outputs simplify the interpretation of results.
- Preferred by Professionals: Developed for industry leaders who prioritize accuracy and efficiency.
Who Should Use Alexandria Real Estate Equities, Inc. (ARE)?
- Real Estate Students: Explore property valuation methods and apply them to real-world scenarios.
- Researchers: Integrate advanced real estate models into academic studies or projects.
- Investors: Validate your investment strategies and evaluate market trends for Alexandria Real Estate Equities, Inc. (ARE).
- Market Analysts: Enhance your analysis with a ready-to-use, customizable financial model tailored for real estate.
- Property Managers: Understand how large-scale real estate companies like Alexandria Real Estate Equities, Inc. (ARE) operate and are assessed.
What the Template Contains
- Preloaded ARE Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.