Extra Space Storage Inc. (EXR) 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
Extra Space Storage Inc. (EXR) Bundle
Evaluate Extra Space Storage Inc.'s (EXR) financial future like an expert! This (EXR) DCF Calculator comes with pre-filled financials and offers total flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with 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 | 1,308.5 | 1,356.2 | 1,577.4 | 1,924.2 | 2,560.2 | 2,627.3 | 2,696.1 | 2,766.6 | 2,839.1 | 2,913.4 |
| Revenue Growth, % | 0 | 3.65 | 16.31 | 21.99 | 33.06 | 2.62 | 2.62 | 2.62 | 2.62 | 2.62 |
| EBITDA | 864.9 | 894.9 | 1,109.4 | 1,326.0 | 1,792.4 | 1,793.6 | 1,840.5 | 1,888.7 | 1,938.2 | 1,988.9 |
| EBITDA, % | 66.1 | 65.98 | 70.33 | 68.91 | 70.01 | 68.27 | 68.27 | 68.27 | 68.27 | 68.27 |
| Depreciation | 704.1 | 734.6 | 771.7 | 886.5 | 506.1 | 1,170.4 | 1,201.0 | 1,232.5 | 1,264.7 | 1,297.8 |
| Depreciation, % | 53.81 | 54.17 | 48.92 | 46.07 | 19.77 | 44.55 | 44.55 | 44.55 | 44.55 | 44.55 |
| EBIT | 160.8 | 160.2 | 337.8 | 439.5 | 1,286.3 | 623.2 | 639.5 | 656.3 | 673.5 | 691.1 |
| EBIT, % | 12.29 | 11.81 | 21.41 | 22.84 | 50.24 | 23.72 | 23.72 | 23.72 | 23.72 | 23.72 |
| Total Cash | 65.7 | 109.1 | 71.1 | 92.9 | 99.1 | 138.1 | 141.7 | 145.4 | 149.2 | 153.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 644.0 | 739.5 | 327.6 | 336.2 | 345.0 | 354.0 | 363.3 |
| Account Receivables, % | 0 | 0 | 0 | 33.47 | 28.88 | 12.47 | 12.47 | 12.47 | 12.47 | 12.47 |
| Inventories | .0 | -146.9 | 81.3 | -699.2 | .0 | -220.8 | -226.6 | -232.5 | -238.6 | -244.8 |
| Inventories, % | 0 | -10.83 | 5.15 | -36.34 | 0 | -8.4 | -8.4 | -8.4 | -8.4 | -8.4 |
| Accounts Payable | 111.4 | 130.0 | 142.3 | 171.7 | 334.5 | 258.0 | 264.8 | 271.7 | 278.8 | 286.1 |
| Accounts Payable, % | 8.51 | 9.59 | 9.02 | 8.92 | 13.07 | 9.82 | 9.82 | 9.82 | 9.82 | 9.82 |
| Capital Expenditure | -7.8 | -7.1 | -3.7 | -22.8 | -16.0 | -16.6 | -17.0 | -17.5 | -17.9 | -18.4 |
| Capital Expenditure, % | -0.59337 | -0.523 | -0.23197 | -1.19 | -0.62471 | -0.63193 | -0.63193 | -0.63193 | -0.63193 | -0.63193 |
| Tax Rate, % | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 | 7.89 |
| EBITAT | 146.0 | 145.3 | 311.3 | 401.6 | 1,184.8 | 569.7 | 584.7 | 600.0 | 615.7 | 631.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 953.7 | 1,038.4 | 863.4 | 1,431.1 | 1,043.0 | 2,279.7 | 1,772.6 | 1,819.0 | 1,866.6 | 1,915.5 |
| WACC, % | 7.21 | 7.21 | 7.23 | 7.22 | 7.23 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 7,908.5 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,992 | |||||||||
| Terminal Value | 61,912 | |||||||||
| Present Terminal Value | 43,696 | |||||||||
| Enterprise Value | 51,605 | |||||||||
| Net Debt | 11,154 | |||||||||
| Equity Value | 40,451 | |||||||||
| Diluted Shares Outstanding, MM | 169 | |||||||||
| Equity Value Per Share | 239.04 |
What You Will Get
- Real EXR Financial Data: Pre-filled with Extra Space Storage’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Extra Space Storage’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Storage Data: Gain access to detailed historical performance metrics and future growth forecasts for Extra Space Storage Inc. (EXR).
- Tailored Financial Assumptions: Modify highlighted inputs such as capitalization rates, occupancy rates, and rental growth projections.
- Real-Time Analytics: Automatic refresh of key metrics including Net Operating Income (NOI), cash flow, and valuation models.
- User-Friendly Interface: Intuitive visualizations and dashboards to easily interpret your investment insights.
- Designed for All Skill Levels: An accessible framework suitable for real estate investors, analysts, and financial consultants.
How It Works
- Download: Obtain the pre-formatted Excel file containing Extra Space Storage Inc.'s (EXR) financial data.
- Customize: Modify projections, including rental income growth, operating margin %, and cap rate.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and evaluate results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Storage Calculator?
- Designed for Industry Experts: A sophisticated tool utilized by property managers, investors, and real estate consultants.
- Comprehensive Data: Extra Space Storage’s historical and projected metrics preloaded for precision.
- Scenario Analysis: Effortlessly model various storage demand forecasts and business assumptions.
- Transparent Results: Automatically computes key performance indicators, ROI, and occupancy rates.
- User-Friendly: Detailed instructions walk you through each step of the calculation.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive and accurate valuation models for property investments in Extra Space Storage Inc. (EXR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights for Extra Space Storage Inc. (EXR) investments.
- Students and Educators: Utilize real-world data to enhance learning and teaching of financial modeling techniques.
- Storage Industry Enthusiasts: Gain insights into how storage companies like Extra Space Storage Inc. (EXR) are valued in the market.
What the Template Contains
- Preloaded EXR 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.