American Homes 4 Rent (AMH) 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
American Homes 4 Rent (AMH) Bundle
Enhance your investment choices with the American Homes 4 Rent (AMH) DCF Calculator! Utilize actual financial data for American Homes 4 Rent, adjust growth projections and expenses, and instantly observe how these adjustments affect the intrinsic value of American Homes 4 Rent (AMH).
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,143.4 | 1,182.8 | 1,303.9 | 1,490.5 | 1,623.6 | 1,773.5 | 1,937.2 | 2,116.1 | 2,311.4 | 2,524.8 |
| Revenue Growth, % | 0 | 3.45 | 10.23 | 14.32 | 8.93 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
| EBITDA | 572.7 | 580.1 | 664.4 | 764.6 | 1,028.9 | 939.1 | 1,025.8 | 1,120.4 | 1,223.9 | 1,336.9 |
| EBITDA, % | 50.09 | 49.05 | 50.95 | 51.29 | 63.37 | 52.95 | 52.95 | 52.95 | 52.95 | 52.95 |
| Depreciation | 1,039.3 | 1,094.7 | 1,055.5 | 1,198.9 | 456.6 | 1,322.8 | 1,445.0 | 1,578.4 | 1,724.1 | 1,883.2 |
| Depreciation, % | 90.9 | 92.55 | 80.95 | 80.43 | 28.12 | 74.59 | 74.59 | 74.59 | 74.59 | 74.59 |
| EBIT | -466.6 | -514.5 | -391.1 | -434.3 | 572.3 | -383.8 | -419.2 | -457.9 | -500.2 | -546.4 |
| EBIT, % | -40.81 | -43.5 | -30 | -29.14 | 35.25 | -21.64 | -21.64 | -21.64 | -21.64 | -21.64 |
| Total Cash | 37.6 | 137.1 | 48.2 | 69.2 | 59.4 | 95.3 | 104.1 | 113.7 | 124.2 | 135.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 66.5 | 77.1 | 76.9 | 50.1 | 43.9 | 86.2 | 94.1 | 102.8 | 112.3 | 122.7 |
| Account Receivables, % | 5.81 | 6.52 | 5.9 | 3.36 | 2.7 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
| Inventories | 559.2 | .0 | 628.9 | 774.0 | .0 | 528.7 | 577.5 | 630.9 | 689.1 | 752.7 |
| Inventories, % | 48.91 | 0.0000000845 | 48.23 | 51.93 | 0 | 29.81 | 29.81 | 29.81 | 29.81 | 29.81 |
| Accounts Payable | 5.0 | .4 | 1.1 | 5.7 | 36.1 | 11.2 | 12.3 | 13.4 | 14.6 | 16.0 |
| Accounts Payable, % | 0.44054 | 0.03652239 | 0.08536049 | 0.38369 | 2.22 | 0.63337 | 0.63337 | 0.63337 | 0.63337 | 0.63337 |
| Capital Expenditure | -71.5 | -104.8 | -122.6 | -138.8 | -134.2 | -149.3 | -163.1 | -178.1 | -194.6 | -212.5 |
| Capital Expenditure, % | -6.25 | -8.86 | -9.4 | -9.31 | -8.26 | -8.42 | -8.42 | -8.42 | -8.42 | -8.42 |
| Tax Rate, % | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 | 12.03 |
| EBITAT | -61.7 | -124.2 | -130.4 | -245.4 | 503.5 | -165.2 | -180.4 | -197.1 | -215.3 | -235.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 285.5 | 1,409.6 | 174.4 | 701.0 | 1,636.5 | 412.5 | 1,045.8 | 1,142.3 | 1,247.8 | 1,362.9 |
| WACC, % | 6.22 | 6.34 | 6.44 | 6.7 | 7.05 | 6.55 | 6.55 | 6.55 | 6.55 | 6.55 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,213.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,417 | |||||||||
| Terminal Value | 55,590 | |||||||||
| Present Terminal Value | 40,480 | |||||||||
| Enterprise Value | 44,693 | |||||||||
| Net Debt | 4,421 | |||||||||
| Equity Value | 40,272 | |||||||||
| Diluted Shares Outstanding, MM | 362 | |||||||||
| Equity Value Per Share | 111.10 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real AMH financials.
- Actual Market Data: Historical figures and forward-looking projections (as indicated in the yellow cells).
- Assumption Flexibility: Modify forecast parameters such as rental growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect American Homes 4 Rent's valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive Data: American Homes 4 Rent's historical financial records and pre-filled projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Instantly view the intrinsic value of American Homes 4 Rent (AMH) updating live.
- Intuitive Visuals: Dashboard graphs present valuation outcomes and critical metrics clearly.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing American Homes 4 Rent's (AMH) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Confidence: Share professional valuation insights to inform your investment decisions.
Why Choose This Calculator for American Homes 4 Rent (AMH)?
- Accuracy: Utilizes real American Homes 4 Rent financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and experiment with inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for all, regardless of financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess American Homes 4 Rent's (AMH) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to AMH.
- Consultants: Easily modify the template for valuation reports tailored to clients interested in AMH.
- Entrepreneurs: Acquire knowledge on financial modeling practices applied by leading real estate firms like AMH.
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to the real estate sector.
What the Template Contains
- Pre-Filled Data: Includes American Homes 4 Rent'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 American Homes 4 Rent'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.