RLJ Lodging Trust (RLJ) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
RLJ Lodging Trust (RLJ) Bundle
Discover the true value of RLJ Lodging Trust (RLJ) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes affect RLJ's valuation – all within a single Excel template.
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,566.2 | 473.1 | 785.7 | 1,193.7 | 1,325.6 | 1,522.0 | 1,747.4 | 2,006.3 | 2,303.6 | 2,644.8 |
| Revenue Growth, % | 0 | -69.79 | 66.07 | 51.93 | 11.05 | 14.81 | 14.81 | 14.81 | 14.81 | 14.81 |
| EBITDA | 424.0 | -66.5 | 130.7 | 320.4 | 336.8 | 249.3 | 286.2 | 328.6 | 377.3 | 433.2 |
| EBITDA, % | 27.07 | -14.06 | 16.63 | 26.85 | 25.41 | 16.38 | 16.38 | 16.38 | 16.38 | 16.38 |
| Depreciation | 1,334.9 | 719.3 | 835.7 | 1,072.9 | 179.1 | 1,183.0 | 1,358.2 | 1,559.4 | 1,790.5 | 2,055.7 |
| Depreciation, % | 85.23 | 152.04 | 106.37 | 89.89 | 13.51 | 77.73 | 77.73 | 77.73 | 77.73 | 77.73 |
| EBIT | -910.9 | -785.8 | -705.0 | -752.5 | 157.7 | -910.2 | -1,045.1 | -1,199.9 | -1,377.7 | -1,581.8 |
| EBIT, % | -58.16 | -166.11 | -89.73 | -63.04 | 11.9 | -59.81 | -59.81 | -59.81 | -59.81 | -59.81 |
| Total Cash | 882.5 | 899.8 | 665.3 | 481.3 | 516.7 | 975.1 | 1,119.5 | 1,285.4 | 1,475.8 | 1,694.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 39.8 | 13.3 | 31.1 | 38.5 | 26.2 | 44.2 | 50.7 | 58.3 | 66.9 | 76.8 |
| Account Receivables, % | 2.54 | 2.82 | 3.96 | 3.23 | 1.97 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
| Inventories | 44.7 | 35.0 | 48.5 | 55.1 | .0 | 64.0 | 73.5 | 84.4 | 96.9 | 111.3 |
| Inventories, % | 2.85 | 7.39 | 6.18 | 4.61 | 0 | 4.21 | 4.21 | 4.21 | 4.21 | 4.21 |
| Accounts Payable | 183.4 | 103.3 | 155.1 | 155.9 | 147.2 | 235.8 | 270.7 | 310.8 | 356.8 | 409.7 |
| Accounts Payable, % | 11.71 | 21.83 | 19.75 | 13.06 | 11.11 | 15.49 | 15.49 | 15.49 | 15.49 | 15.49 |
| Capital Expenditure | -157.4 | -73.3 | -48.3 | -124.3 | .0 | -128.2 | -147.1 | -168.9 | -194.0 | -222.7 |
| Capital Expenditure, % | -10.05 | -15.5 | -6.14 | -10.41 | 0 | -8.42 | -8.42 | -8.42 | -8.42 | -8.42 |
| Tax Rate, % | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 |
| EBITAT | -936.7 | -900.3 | -707.7 | -721.4 | 154.8 | -899.3 | -1,032.5 | -1,185.5 | -1,361.1 | -1,562.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 339.9 | -298.3 | 100.3 | 214.1 | 392.6 | 162.0 | 197.5 | 226.7 | 260.3 | 298.9 |
| WACC, % | 7.69 | 7.69 | 7.69 | 7.58 | 7.64 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 903.0 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 309 | |||||||||
| Terminal Value | 7,441 | |||||||||
| Present Terminal Value | 5,146 | |||||||||
| Enterprise Value | 6,049 | |||||||||
| Net Debt | 1,827 | |||||||||
| Equity Value | 4,222 | |||||||||
| Diluted Shares Outstanding, MM | 157 | |||||||||
| Equity Value Per Share | 26.97 |
What You Will Receive
- Comprehensive Financial Model: RLJ Lodging Trust’s actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, operating margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for RLJ Lodging Trust (RLJ).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to RLJ.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed for RLJ.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to RLJ Lodging Trust (RLJ).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of RLJ.
How It Works
- 1. Access the Template: Download and open the Excel file containing RLJ Lodging Trust’s (RLJ) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as occupancy rates, revenue growth, and operational expenses.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation possibilities.
- 5. Present with Confidence: Share professional valuation insights to back your investment decisions.
Why Choose This Calculator for RLJ Lodging Trust (RLJ)?
- Accurate Data: Real RLJ financials provide trustworthy valuation outcomes.
- Customizable: Tailor key inputs such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations streamline the process, saving you from starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the hospitality sector.
- User-Friendly: Easy-to-navigate design and clear instructions make it accessible for all users.
Who Should Use RLJ Lodging Trust (RLJ)?
- Real Estate Investors: Gain insights into lodging investments with a reliable analysis platform.
- Market Analysts: Streamline your research with comprehensive data on RLJ’s performance.
- Hospitality Consultants: Easily tailor reports for clients focusing on the lodging sector.
- Finance Enthusiasts: Explore the dynamics of the lodging market through detailed case studies.
- Educators and Students: Utilize it as a resource for understanding real estate investment strategies.
What the Template Contains
- Pre-Filled DCF Model: RLJ Lodging Trust’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate RLJ Lodging 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.