|
Valoración de DCF de Service Properties Trust (SVC)
US | Real Estate | REIT - Hotel & Motel | NASDAQ
|
- ✓ 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
Service Properties Trust (SVC) Bundle
¡Maximice la eficiencia y mejore la precisión con nuestra calculadora DCF (SVC)! Repleto de datos de confianza de servicio reales y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar las propiedades del servicio Trust como un inversor 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 | 2,316.1 | 1,265.3 | 1,495.6 | 1,863.0 | 1,873.9 | 1,864.4 | 1,855.0 | 1,845.6 | 1,836.3 | 1,827.1 |
| Revenue Growth, % | 0 | -45.37 | 18.2 | 24.57 | 0.5825 | -0.50457 | -0.50457 | -0.50457 | -0.50457 | -0.50457 |
| EBITDA | 844.4 | 501.8 | 286.0 | 581.5 | 637.4 | 598.3 | 595.3 | 592.3 | 589.3 | 586.4 |
| EBITDA, % | 36.46 | 39.66 | 19.13 | 31.21 | 34.01 | 32.09 | 32.09 | 32.09 | 32.09 | 32.09 |
| Depreciation | 1,944.6 | 1,242.8 | 1,608.0 | 1,696.1 | 384.1 | 1,468.1 | 1,460.7 | 1,453.3 | 1,446.0 | 1,438.7 |
| Depreciation, % | 83.96 | 98.23 | 107.52 | 91.04 | 20.5 | 78.74 | 78.74 | 78.74 | 78.74 | 78.74 |
| EBIT | -1,100.2 | -741.0 | -1,322.0 | -1,114.6 | 253.3 | -897.8 | -893.3 | -888.8 | -884.3 | -879.8 |
| EBIT, % | -47.5 | -58.57 | -88.39 | -59.83 | 13.52 | -48.15 | -48.15 | -48.15 | -48.15 | -48.15 |
| Total Cash | 27.6 | 73.3 | 944.0 | 38.4 | 180.1 | 305.0 | 303.4 | 301.9 | 300.4 | 298.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 70.6 | 71.8 | 75.0 | 67.3 | 63.2 | 77.3 | 76.9 | 76.5 | 76.1 | 75.7 |
| Account Receivables, % | 3.05 | 5.67 | 5.02 | 3.61 | 3.37 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
| Inventories | .0 | 194.9 | .0 | .0 | .0 | 57.4 | 57.2 | 56.9 | 56.6 | 56.3 |
| Inventories, % | 0.0000000432 | 15.41 | 0.0000000669 | 0.0000000537 | 0 | 3.08 | 3.08 | 3.08 | 3.08 | 3.08 |
| Accounts Payable | 335.7 | 345.4 | 433.4 | 426.0 | 380.5 | 424.9 | 422.7 | 420.6 | 418.5 | 416.4 |
| Accounts Payable, % | 14.49 | 27.3 | 28.98 | 22.86 | 20.31 | 22.79 | 22.79 | 22.79 | 22.79 | 22.79 |
| Capital Expenditure | .0 | -190.0 | 101.3 | 50.4 | .0 | -56.0 | -55.7 | -55.4 | -55.2 | -54.9 |
| Capital Expenditure, % | 0 | -15.02 | 6.77 | 2.71 | 0 | -3 | -3 | -3 | -3 | -3 |
| Tax Rate, % | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 | -9.65 |
| EBITAT | -1,090.1 | -785.9 | -1,319.7 | -1,113.0 | 277.7 | -895.6 | -891.1 | -886.6 | -882.1 | -877.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,119.7 | 80.4 | 669.4 | 633.8 | 620.4 | 489.4 | 512.5 | 509.9 | 507.3 | 504.7 |
| WACC, % | 6.66 | 6.71 | 6.7 | 6.7 | 6.71 | 6.69 | 6.69 | 6.69 | 6.69 | 6.69 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,085.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 515 | |||||||||
| Terminal Value | 10,969 | |||||||||
| Present Terminal Value | 7,934 | |||||||||
| Enterprise Value | 10,019 | |||||||||
| Net Debt | 5,340 | |||||||||
| Equity Value | 4,679 | |||||||||
| Diluted Shares Outstanding, MM | 165 | |||||||||
| Equity Value Per Share | 28.36 |
What You Will Receive
- Pre-Filled Financial Model: Service Properties Trust’s (SVC) actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive SVC Data: Pre-loaded with Service Properties Trust’s historical performance metrics and future projections.
- Fully Customizable Inputs: Tailor revenue growth, profit margins, discount rates, tax implications, and capital investments to your needs.
- Dynamic Valuation Model: Instantaneous updates to Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Scenario Analysis: Develop various forecasting scenarios to explore different valuation possibilities.
- User-Friendly Interface: Intuitive, organized, and suitable for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Service Properties Trust (SVC) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Service Properties Trust (SVC)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Service Properties Trust (SVC)?
- Designed for Experts: A sophisticated tool utilized by real estate analysts, investment managers, and financial consultants.
- Comprehensive Data: Service Properties Trust’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Service Properties Trust (SVC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Service Properties Trust (SVC).
- Consultants: Deliver professional valuation insights on Service Properties Trust (SVC) to clients quickly and accurately.
- Business Owners: Understand how real estate investment trusts like Service Properties Trust (SVC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Service Properties Trust (SVC).
What the Template Contains
- Pre-Filled DCF Model: Service Properties Trust’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Service Properties Trust’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.