|
Valoración de DCF de Pebblebrook Hotel Trust (PEB)
US | Real Estate | REIT - Hotel & Motel | 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
Pebblebrook Hotel Trust (PEB) Bundle
¡Mejore su estrategia de inversión con la calculadora DCF de Pebblebrook Hotel Trust (PEB)! Utilice datos financieros reales, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Pebblebrook Hotel Trust (PEB).
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,612.2 | 442.9 | 733.0 | 1,391.9 | 1,419.9 | 1,721.3 | 2,086.5 | 2,529.3 | 3,066.0 | 3,716.6 |
| Revenue Growth, % | 0 | -72.53 | 65.51 | 89.88 | 2.02 | 21.22 | 21.22 | 21.22 | 21.22 | 21.22 |
| EBITDA | 470.1 | -100.5 | 84.7 | 238.4 | 296.9 | 193.0 | 234.0 | 283.6 | 343.8 | 416.7 |
| EBITDA, % | 29.16 | -22.68 | 11.55 | 17.13 | 20.91 | 11.21 | 11.21 | 11.21 | 11.21 | 11.21 |
| Depreciation | 1,377.0 | 767.9 | 872.6 | 1,293.1 | 240.6 | 1,360.7 | 1,649.4 | 1,999.4 | 2,423.7 | 2,938.0 |
| Depreciation, % | 85.41 | 173.38 | 119.04 | 92.9 | 16.95 | 79.05 | 79.05 | 79.05 | 79.05 | 79.05 |
| EBIT | -906.9 | -868.3 | -787.9 | -1,054.6 | 56.2 | -1,129.4 | -1,369.0 | -1,659.5 | -2,011.7 | -2,438.5 |
| EBIT, % | -56.25 | -196.06 | -107.49 | -75.77 | 3.96 | -65.61 | -65.61 | -65.61 | -65.61 | -65.61 |
| Total Cash | 30.1 | 124.3 | 58.5 | 41.0 | 183.7 | 185.2 | 224.5 | 272.1 | 329.9 | 399.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 49.6 | 10.2 | 37.0 | 45.3 | 43.9 | 57.8 | 70.0 | 84.9 | 102.9 | 124.8 |
| Account Receivables, % | 3.08 | 2.31 | 5.05 | 3.25 | 3.09 | 3.36 | 3.36 | 3.36 | 3.36 | 3.36 |
| Inventories | .0 | .0 | .0 | 5,874.9 | .0 | 344.3 | 417.3 | 505.9 | 613.2 | 743.3 |
| Inventories, % | 0 | 0.000000226 | 0 | 422.08 | 0 | 20 | 20 | 20 | 20 | 20 |
| Accounts Payable | 260.2 | 226.4 | 250.6 | 250.5 | 238.6 | 469.1 | 568.6 | 689.3 | 835.5 | 1,012.8 |
| Accounts Payable, % | 16.14 | 51.13 | 34.18 | 18 | 16.81 | 27.25 | 27.25 | 27.25 | 27.25 | 27.25 |
| Capital Expenditure | -.8 | -125.0 | -83.8 | -116.7 | .0 | -165.6 | -200.7 | -243.3 | -294.9 | -357.5 |
| Capital Expenditure, % | -0.04664396 | -28.23 | -11.44 | -8.39 | 0 | -9.62 | -9.62 | -9.62 | -9.62 | -9.62 |
| Tax Rate, % | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 | -5.97 |
| EBITAT | -866.0 | -860.2 | -788.2 | -1,058.1 | 59.6 | -1,117.1 | -1,354.1 | -1,641.4 | -1,989.8 | -2,412.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 720.8 | -211.7 | -2.1 | -5,764.9 | 6,164.6 | -49.7 | 108.8 | 131.9 | 159.9 | 193.8 |
| WACC, % | 7.69 | 7.79 | 7.81 | 7.81 | 7.81 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 404.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 202 | |||||||||
| Terminal Value | 5,328 | |||||||||
| Present Terminal Value | 3,663 | |||||||||
| Enterprise Value | 4,067 | |||||||||
| Net Debt | 2,457 | |||||||||
| Equity Value | 1,611 | |||||||||
| Diluted Shares Outstanding, MM | 122 | |||||||||
| Equity Value Per Share | 13.22 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Pebblebrook Hotel Trust’s financial data pre-populated to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Pebblebrook Hotel Trust (PEB).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries for a clear view of your valuation outcomes.
- Designed for All Levels: An accessible layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based PEB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Pebblebrook Hotel Trust’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Pebblebrook Hotel Trust (PEB)?
- Accuracy: Utilizes real Pebblebrook financials to ensure precise data.
- Flexibility: Allows users to easily test and adjust inputs to suit their needs.
- Time-Saving: Eliminate the complexity of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use Pebblebrook Hotel Trust (PEB)?
- Real Estate Investors: Gain insights into hotel property valuations with a trusted investment vehicle.
- Financial Analysts: Utilize comprehensive data to enhance your property analysis and reporting.
- Consultants: Easily customize presentations and reports for clients in the hospitality sector.
- Hospitality Enthusiasts: Explore the dynamics of the hotel industry through real-time market performance.
- Educators and Students: Leverage as a case study for understanding real estate investment trusts (REITs) in academic settings.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring thorough valuation calculations.
- Real-World Data: Pebblebrook Hotel Trust’s historical and projected financials preloaded for 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 for clear, actionable results.