|
Acadia Realty Trust (AKR) DCF Valuation
US | Real Estate | REIT - Retail | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Acadia Realty Trust (AKR) Bundle
Designed for accuracy, our Acadia Realty Trust (AKR) DCF Calculator enables you to evaluate the company’s valuation utilizing real-world financial data, along with complete flexibility to modify all essential parameters for improved forecasts.
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 | 295.3 | 255.5 | 292.5 | 326.3 | 338.7 | 352.5 | 366.9 | 381.9 | 397.6 | 413.8 |
Revenue Growth, % | 0 | -13.49 | 14.49 | 11.55 | 3.8 | 4.09 | 4.09 | 4.09 | 4.09 | 4.09 |
EBITDA | 174.3 | 115.9 | 167.9 | 162.0 | 194.4 | 189.5 | 197.3 | 205.4 | 213.8 | 222.5 |
EBITDA, % | 59.03 | 45.35 | 57.4 | 49.66 | 57.4 | 53.77 | 53.77 | 53.77 | 53.77 | 53.77 |
Depreciation | 253.0 | 366.7 | 272.4 | 282.3 | 136.0 | 285.9 | 297.6 | 309.7 | 322.4 | 335.6 |
Depreciation, % | 85.68 | 143.51 | 93.12 | 86.52 | 40.15 | 81.09 | 81.09 | 81.09 | 81.09 | 81.09 |
EBIT | -78.7 | -250.8 | -104.5 | -120.3 | 58.4 | -127.0 | -132.2 | -137.6 | -143.2 | -149.1 |
EBIT, % | -26.66 | -98.16 | -35.72 | -36.86 | 17.25 | -36.03 | -36.03 | -36.03 | -36.03 | -36.03 |
Total Cash | 15.8 | 19.2 | 17.7 | 17.2 | 50.8 | 27.6 | 28.8 | 29.9 | 31.2 | 32.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 59.1 | 43.1 | 43.6 | 49.5 | 205.6 | 90.0 | 93.7 | 97.5 | 101.5 | 105.6 |
Account Receivables, % | 20.01 | 16.85 | 14.91 | 15.17 | 60.69 | 25.53 | 25.53 | 25.53 | 25.53 | 25.53 |
Inventories | 253.4 | 247.2 | 203.8 | -17.5 | .0 | 174.1 | 181.2 | 188.6 | 196.3 | 204.3 |
Inventories, % | 85.8 | 96.76 | 69.67 | -5.36 | 0 | 49.37 | 49.37 | 49.37 | 49.37 | 49.37 |
Accounts Payable | 68.8 | 52.4 | 56.6 | 59.9 | 61.4 | 70.3 | 73.1 | 76.1 | 79.2 | 82.5 |
Accounts Payable, % | 23.31 | 20.51 | 19.34 | 18.36 | 18.14 | 19.93 | 19.93 | 19.93 | 19.93 | 19.93 |
Capital Expenditure | -39.0 | -6.4 | -45.6 | -59.0 | .0 | -34.8 | -36.3 | -37.7 | -39.3 | -40.9 |
Capital Expenditure, % | -13.22 | -2.51 | -15.58 | -18.1 | 0 | -9.88 | -9.88 | -9.88 | -9.88 | -9.88 |
Tax Rate, % | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 | 1472.44 |
EBITAT | -73.6 | -251.8 | -97.6 | -120.3 | -801.6 | -98.3 | -102.3 | -106.5 | -110.9 | -115.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -103.3 | 114.2 | 176.2 | 321.7 | -837.7 | 103.1 | 151.1 | 157.2 | 163.7 | 170.4 |
WACC, % | 8.27 | 8.41 | 8.27 | 8.41 | 6.2 | 7.91 | 7.91 | 7.91 | 7.91 | 7.91 |
PV UFCF | ||||||||||
SUM PV UFCF | 587.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 174 | |||||||||
Terminal Value | 2,939 | |||||||||
Present Terminal Value | 2,009 | |||||||||
Enterprise Value | 2,596 | |||||||||
Net Debt | 1,917 | |||||||||
Equity Value | 679 | |||||||||
Diluted Shares Outstanding, MM | 95 | |||||||||
Equity Value Per Share | 7.13 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real AKR financials.
- Authentic Data: Historical performance data and forward-looking projections (highlighted in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Acadia Realty Trust's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Centric Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Real-Life AKR Data: Pre-filled with Acadia Realty Trust’s historical financials and future projections.
- Fully Customizable Inputs: Adjust rental income, occupancy rates, capital expenditures, and discount rates.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to evaluate different valuation outcomes.
- User-Friendly Design: Intuitive, structured, and suitable for both professionals and newcomers.
How It Works
- Download: Obtain the pre-configured Excel file containing Acadia Realty Trust's (AKR) financial data.
- Customize: Modify forecasts, 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 findings to inform your investment strategy.
Why Choose This Calculator for Acadia Realty Trust (AKR)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for real estate investment.
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Acadia Realty Trust’s intrinsic value and Net Present Value.
- Preloaded Data: Access historical and projected data for accurate analysis.
- Professional Quality: Perfect for real estate analysts, investors, and financial consultants.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive valuation models for property analysis.
- Corporate Finance Teams: Evaluate property valuation scenarios to inform strategic decisions.
- Consultants and Advisors: Deliver precise valuation insights for Acadia Realty Trust (AKR) to clients.
- Students and Educators: Utilize real-world data to enhance learning in financial modeling and real estate valuation.
- Market Analysts: Gain insights into how real estate investment trusts like Acadia Realty Trust (AKR) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Acadia Realty Trust’s (AKR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Acadia Realty Trust’s (AKR) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.