|
CubeSmart (CUBE) DCF Valuation
US | Real Estate | REIT - Industrial | NYSE
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
CubeSmart (CUBE) Bundle
Explore CubeSmart's (CUBE) financial potential with our easy-to-use DCF Calculator! Enter your projections for growth, profit margins, and expenses to determine CubeSmart's (CUBE) intrinsic value and enhance your investment strategy.
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 | 643.9 | 679.2 | 822.6 | 1,009.6 | 1,050.3 | 1,105.0 | 1,162.6 | 1,223.1 | 1,286.8 | 1,353.8 |
Revenue Growth, % | 0 | 5.48 | 21.11 | 22.74 | 4.03 | 5.21 | 5.21 | 5.21 | 5.21 | 5.21 |
EBITDA | 405.3 | 414.1 | 547.9 | 696.4 | 703.1 | 721.5 | 759.1 | 798.6 | 840.2 | 883.9 |
EBITDA, % | 62.95 | 60.97 | 66.61 | 68.97 | 66.94 | 65.29 | 65.29 | 65.29 | 65.29 | 65.29 |
Depreciation | 414.7 | 421.6 | 532.0 | 658.5 | 201.2 | 608.9 | 640.7 | 674.0 | 709.1 | 746.0 |
Depreciation, % | 64.4 | 62.08 | 64.67 | 65.22 | 19.16 | 55.11 | 55.11 | 55.11 | 55.11 | 55.11 |
EBIT | -9.3 | -7.5 | 16.0 | 37.9 | 501.9 | 112.5 | 118.4 | 124.6 | 131.1 | 137.9 |
EBIT, % | -1.45 | -1.11 | 1.94 | 3.75 | 47.78 | 10.18 | 10.18 | 10.18 | 10.18 | 10.18 |
Total Cash | 54.9 | 3.6 | 11.1 | 6.1 | 6.5 | 25.7 | 27.0 | 28.4 | 29.9 | 31.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 16.8 | 19.0 | 23.6 | 30.0 | 33.2 | 31.8 | 33.5 | 35.2 | 37.1 | 39.0 |
Account Receivables, % | 2.61 | 2.79 | 2.86 | 2.97 | 3.16 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
Inventories | 62.0 | 8.9 | 64.8 | -95.8 | .0 | 20.6 | 21.7 | 22.8 | 24.0 | 25.3 |
Inventories, % | 9.63 | 1.31 | 7.88 | -9.48 | 0 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
Accounts Payable | 137.9 | 37.2 | 200.0 | 214.4 | 35.3 | 167.5 | 176.3 | 185.4 | 195.1 | 205.2 |
Accounts Payable, % | 21.41 | 5.48 | 24.31 | 21.23 | 3.36 | 15.16 | 15.16 | 15.16 | 15.16 | 15.16 |
Capital Expenditure | -102.8 | -49.9 | -34.6 | -41.2 | .0 | -69.8 | -73.5 | -77.3 | -81.3 | -85.6 |
Capital Expenditure, % | -15.97 | -7.34 | -4.21 | -4.08 | 0 | -6.32 | -6.32 | -6.32 | -6.32 | -6.32 |
Tax Rate, % | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 | 0.40685 |
EBITAT | -4.6 | -4.0 | 9.0 | 25.8 | 499.8 | 73.6 | 77.4 | 81.5 | 85.7 | 90.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 366.3 | 318.1 | 608.6 | 811.6 | 423.1 | 725.7 | 650.6 | 684.5 | 720.1 | 757.7 |
WACC, % | 7.01 | 7.06 | 7.09 | 7.21 | 7.54 | 7.18 | 7.18 | 7.18 | 7.18 | 7.18 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,880.8 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 788 | |||||||||
Terminal Value | 24,778 | |||||||||
Present Terminal Value | 17,518 | |||||||||
Enterprise Value | 20,399 | |||||||||
Net Debt | 2,982 | |||||||||
Equity Value | 17,417 | |||||||||
Diluted Shares Outstanding, MM | 226 | |||||||||
Equity Value Per Share | 76.99 |
What You Will Get
- Pre-Filled Financial Model: CubeSmart’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive CubeSmart Financials: Gain access to reliable pre-loaded historical data and future forecasts for CubeSmart (CUBE).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help visualize your investment valuation for CubeSmart (CUBE).
- Designed for All Skill Levels: A straightforward, easy-to-navigate structure tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review CubeSmart’s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for CubeSmart (CUBE)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for CubeSmart (CUBE).
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes CubeSmart’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and real estate consultants focusing on CubeSmart (CUBE).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling CubeSmart (CUBE) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for CubeSmart (CUBE).
- Consultants: Deliver professional valuation insights on CubeSmart (CUBE) to clients quickly and accurately.
- Business Owners: Understand how real estate investment trusts like CubeSmart (CUBE) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to CubeSmart (CUBE).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for CubeSmart (CUBE).
- Real-World Data: CubeSmart’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.