Armada Hoffler Properties, Inc. (AHH) DCF Valuation
- ✓ 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
Armada Hoffler Properties, Inc. (AHH) Bundle
Evaluate Armada Hoffler Properties, Inc. (AHH) financial outlook like an expert! This (AHH) DCF Calculator provides pre-filled financial data and allows you to customize revenue growth, WACC, margins, and other essential assumptions to match your 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 | 257.2 | 383.6 | 284.1 | 454.2 | 667.2 | 628.6 | 592.3 | 558.1 | 525.9 | 495.5 |
| Revenue Growth, % | 0 | 49.16 | -25.95 | 59.87 | 46.9 | -5.78 | -5.78 | -5.78 | -5.78 | -5.78 |
| EBITDA | 118.1 | 128.3 | 132.6 | 213.6 | 164.7 | 248.6 | 234.2 | 220.7 | 207.9 | 195.9 |
| EBITDA, % | 45.9 | 33.44 | 46.67 | 47.03 | 24.69 | 39.54 | 39.54 | 39.54 | 39.54 | 39.54 |
| Depreciation | 206.6 | 326.1 | 239.5 | 381.8 | 98.0 | 438.0 | 412.7 | 388.9 | 366.4 | 345.3 |
| Depreciation, % | 80.34 | 85.01 | 84.32 | 84.06 | 14.69 | 69.68 | 69.68 | 69.68 | 69.68 | 69.68 |
| EBIT | -88.6 | -197.9 | -107.0 | -168.2 | 66.7 | -189.5 | -178.5 | -168.2 | -158.5 | -149.3 |
| EBIT, % | -34.44 | -51.58 | -37.65 | -37.03 | 10 | -30.14 | -30.14 | -30.14 | -30.14 | -30.14 |
| Total Cash | 39.2 | 41.0 | 35.2 | 48.1 | 27.9 | 66.8 | 62.9 | 59.3 | 55.9 | 52.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 60.1 | 67.1 | 47.7 | 110.4 | 172.1 | 135.4 | 127.6 | 120.3 | 113.3 | 106.8 |
| Account Receivables, % | 23.36 | 17.5 | 16.79 | 24.3 | 25.79 | 21.55 | 21.55 | 21.55 | 21.55 | 21.55 |
| Inventories | 1.5 | 1.2 | -2.9 | 72.0 | -33.0 | 13.5 | 12.7 | 12.0 | 11.3 | 10.6 |
| Inventories, % | 0.56766 | 0.30367 | -1.03 | 15.85 | -4.95 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 |
| Accounts Payable | 71.2 | 73.7 | 60.8 | 120.3 | 31.0 | 125.0 | 117.8 | 111.0 | 104.6 | 98.5 |
| Accounts Payable, % | 27.68 | 19.22 | 21.39 | 26.49 | 4.65 | 19.88 | 19.88 | 19.88 | 19.88 | 19.88 |
| Capital Expenditure | -19.7 | -10.1 | -15.5 | -17.1 | .0 | -24.5 | -23.1 | -21.8 | -20.5 | -19.3 |
| Capital Expenditure, % | -7.67 | -2.63 | -5.45 | -3.76 | 0 | -3.9 | -3.9 | -3.9 | -3.9 | -3.9 |
| Tax Rate, % | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 |
| EBITAT | -89.3 | -157.3 | -94.7 | -126.0 | 61.5 | -164.9 | -155.4 | -146.4 | -137.9 | -130.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 107.2 | 154.6 | 139.9 | 160.7 | 113.5 | 332.7 | 235.7 | 222.0 | 209.2 | 197.1 |
| WACC, % | 5.99 | 5.36 | 5.64 | 5.22 | 5.75 | 5.59 | 5.59 | 5.59 | 5.59 | 5.59 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,033.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 205 | |||||||||
| Terminal Value | 12,869 | |||||||||
| Present Terminal Value | 9,803 | |||||||||
| Enterprise Value | 10,837 | |||||||||
| Net Debt | 1,492 | |||||||||
| Equity Value | 9,344 | |||||||||
| Diluted Shares Outstanding, MM | 68 | |||||||||
| Equity Value Per Share | 138.04 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AHH financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Quickly observe the effects of your inputs on Armada Hoffler Properties' 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
- Customizable Financial Inputs: Adjust essential metrics such as rental income growth, operating margins, and capital investments.
- Instant DCF Valuation: Provides immediate calculations of intrinsic value, NPV, and other key financial metrics.
- High-Precision Results: Leverages Armada Hoffler's actual financial data for accurate valuation projections.
- Effortless Scenario Testing: Easily explore various assumptions and analyze resulting impacts.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.
How It Works
- Step 1: Download the Excel file for Armada Hoffler Properties, Inc. (AHH).
- Step 2: Review the pre-filled financial data and forecasts specific to Armada Hoffler.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify the assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for Armada Hoffler Properties, Inc. (AHH)?
- User-Friendly Interface: Tailored for both novices and seasoned investors.
- Customizable Inputs: Easily adjust parameters to suit your investment analysis.
- Real-Time Valuation: Observe immediate updates to AHH’s valuation as you modify inputs.
- Preloaded Data: Comes with Armada Hoffler’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by analysts and investors for making well-informed decisions.
Who Should Use This Product?
- Investors: Evaluate Armada Hoffler Properties, Inc. (AHH) for informed stock trading decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and validate financial forecasts.
- Real Estate Developers: Understand the valuation strategies of established firms like Armada Hoffler Properties, Inc. (AHH).
- Consultants: Provide comprehensive valuation analyses for your clients’ real estate investments.
- Students and Educators: Utilize current data to learn and teach real estate valuation practices.
What the Template Contains
- Pre-Filled Data: Includes Armada Hoffler Properties, Inc.'s (AHH) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (AHH).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to (AHH).
- Key Financial Ratios: Analyze (AHH)'s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease for (AHH).
- Clear Dashboard: Charts and tables summarizing key valuation results for (AHH).