|
Valoración de DCF de Iron Mountain Incorporated (IRM)
US | Real Estate | REIT - Specialty | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Iron Mountain Incorporated (IRM) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (IRM)! Utilizando datos reales de Iron Mountain y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar Iron Mountain Incorporated como un inversor profesional experimentado.
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 | 4,262.6 | 4,147.3 | 4,491.5 | 5,103.6 | 5,480.3 | 5,844.8 | 6,233.5 | 6,648.1 | 7,090.3 | 7,561.8 |
| Revenue Growth, % | 0 | -2.71 | 8.3 | 13.63 | 7.38 | 6.65 | 6.65 | 6.65 | 6.65 | 6.65 |
| EBITDA | 1,428.9 | 1,297.2 | 1,751.3 | 1,873.6 | 1,618.6 | 1,987.7 | 2,119.9 | 2,260.9 | 2,411.2 | 2,571.6 |
| EBITDA, % | 33.52 | 31.28 | 38.99 | 36.71 | 29.54 | 34.01 | 34.01 | 34.01 | 34.01 | 34.01 |
| Depreciation | 3,545.8 | 3,543.7 | 3,590.2 | 4,057.3 | 793.0 | 4,004.1 | 4,270.4 | 4,554.4 | 4,857.3 | 5,180.4 |
| Depreciation, % | 83.18 | 85.45 | 79.93 | 79.5 | 14.47 | 68.51 | 68.51 | 68.51 | 68.51 | 68.51 |
| EBIT | -2,116.9 | -2,246.6 | -1,838.9 | -2,183.7 | 825.6 | -2,016.4 | -2,150.5 | -2,293.5 | -2,446.1 | -2,608.8 |
| EBIT, % | -49.66 | -54.17 | -40.94 | -42.79 | 15.07 | -34.5 | -34.5 | -34.5 | -34.5 | -34.5 |
| Total Cash | 193.6 | 205.1 | 255.8 | 141.8 | 222.8 | 257.5 | 274.6 | 292.8 | 312.3 | 333.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 850.7 | 859.3 | 961.4 | 1,174.9 | 1,259.8 | 1,263.6 | 1,347.6 | 1,437.2 | 1,532.8 | 1,634.8 |
| Account Receivables, % | 19.96 | 20.72 | 21.41 | 23.02 | 22.99 | 21.62 | 21.62 | 21.62 | 21.62 | 21.62 |
| Inventories | .0 | .0 | .0 | 11.7 | .0 | 2.7 | 2.9 | 3.1 | 3.3 | 3.5 |
| Inventories, % | 0.0000000235 | 0 | 0 | 0.22976 | 0 | 0.04595212 | 0.04595212 | 0.04595212 | 0.04595212 | 0.04595212 |
| Accounts Payable | 324.7 | 359.9 | 369.1 | 469.2 | 539.6 | 509.1 | 543.0 | 579.1 | 617.6 | 658.7 |
| Accounts Payable, % | 7.62 | 8.68 | 8.22 | 9.19 | 9.85 | 8.71 | 8.71 | 8.71 | 8.71 | 8.71 |
| Capital Expenditure | -748.5 | -453.3 | -624.4 | -883.6 | -1,339.2 | -983.5 | -1,049.0 | -1,118.7 | -1,193.1 | -1,272.5 |
| Capital Expenditure, % | -17.56 | -10.93 | -13.9 | -17.31 | -24.44 | -16.83 | -16.83 | -16.83 | -16.83 | -16.83 |
| Tax Rate, % | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 | 18.91 |
| EBITAT | -1,724.9 | -2,065.7 | -1,316.2 | -1,925.6 | 669.5 | -1,670.7 | -1,781.8 | -1,900.3 | -2,026.7 | -2,161.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 546.5 | 1,051.3 | 1,556.8 | 1,122.9 | 120.5 | 1,312.9 | 1,389.3 | 1,481.7 | 1,580.2 | 1,685.3 |
| WACC, % | 7.44 | 7.6 | 7.3 | 7.54 | 7.44 | 7.46 | 7.46 | 7.46 | 7.46 | 7.46 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,979.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 1,753 | |||||||||
| Terminal Value | 50,595 | |||||||||
| Present Terminal Value | 35,302 | |||||||||
| Enterprise Value | 41,281 | |||||||||
| Net Debt | 14,565 | |||||||||
| Equity Value | 26,716 | |||||||||
| Diluted Shares Outstanding, MM | 294 | |||||||||
| Equity Value Per Share | 90.88 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Iron Mountain Incorporated’s (IRM) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your specific valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Pre-Loaded Data: Iron Mountain's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Iron Mountain's intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- 1. Access the Template: Download and open the Excel file containing Iron Mountain Incorporated’s (IRM) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation analyses to back your strategic decisions.
Why Choose This Calculator for Iron Mountain Incorporated (IRM)?
- Accurate Data: Utilize real Iron Mountain financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use Iron Mountain Incorporated (IRM)?
- Investors: Gain insights and make informed decisions with a trusted data management partner.
- Financial Analysts: Streamline your analysis with comprehensive reports and resources available from Iron Mountain.
- Consultants: Easily customize solutions to meet your clients' data storage and management needs.
- Business Leaders: Enhance operational efficiency by leveraging Iron Mountain's innovative storage solutions.
- Educators and Students: Explore case studies and resources to enrich your understanding of data management practices.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Iron Mountain Incorporated (IRM) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that illustrate intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate thorough analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Iron Mountain Incorporated (IRM).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.