Chatham Lodging Trust (CLDT) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Chatham Lodging Trust (CLDT) Bundle
Looking to determine the intrinsic value of Chatham Lodging Trust? Our CLDT DCF Calculator integrates real-world data with complete customization features, allowing you to adjust forecasts and enhance your investment decisions.
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 | 328.3 | 144.9 | 204.0 | 294.9 | 311.1 | 338.3 | 367.9 | 400.0 | 435.0 | 473.0 |
| Revenue Growth, % | 0 | -55.86 | 40.75 | 44.55 | 5.51 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
| EBITDA | 98.6 | 3.8 | 58.5 | 95.0 | 91.1 | 83.1 | 90.4 | 98.3 | 106.9 | 116.2 |
| EBITDA, % | 30.04 | 2.64 | 28.66 | 32.23 | 29.29 | 24.57 | 24.57 | 24.57 | 24.57 | 24.57 |
| Depreciation | 271.7 | 192.4 | 215.5 | 260.7 | 58.3 | 263.8 | 286.8 | 311.9 | 339.2 | 368.8 |
| Depreciation, % | 82.74 | 132.77 | 105.66 | 88.41 | 18.72 | 77.97 | 77.97 | 77.97 | 77.97 | 77.97 |
| EBIT | -173.0 | -188.6 | -157.1 | -165.6 | 32.9 | -186.3 | -202.6 | -220.3 | -239.5 | -260.4 |
| EBIT, % | -52.7 | -130.12 | -77 | -56.18 | 10.56 | -55.06 | -55.06 | -55.06 | -55.06 | -55.06 |
| Total Cash | 6.6 | 21.1 | 19.2 | 26.3 | 68.1 | 38.4 | 41.8 | 45.4 | 49.4 | 53.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.6 | 1.7 | 3.0 | 5.2 | 4.4 | 4.9 | 5.3 | 5.8 | 6.3 | 6.8 |
| Account Receivables, % | 1.41 | 1.16 | 1.47 | 1.76 | 1.41 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 |
| Inventories | 13.6 | 10.3 | 10.7 | -.8 | .0 | 11.0 | 11.9 | 13.0 | 14.1 | 15.3 |
| Inventories, % | 4.13 | 7.13 | 5.24 | -0.27132 | 0 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| Accounts Payable | 33.0 | 25.4 | 27.7 | 28.5 | 29.3 | 40.8 | 44.3 | 48.2 | 52.4 | 57.0 |
| Accounts Payable, % | 10.05 | 17.51 | 13.59 | 9.68 | 9.4 | 12.05 | 12.05 | 12.05 | 12.05 | 12.05 |
| Capital Expenditure | -35.9 | -14.5 | -9.5 | -15.7 | .0 | -20.9 | -22.7 | -24.7 | -26.9 | -29.2 |
| Capital Expenditure, % | -10.92 | -10 | -4.66 | -5.31 | 0 | -6.18 | -6.18 | -6.18 | -6.18 | -6.18 |
| Tax Rate, % | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 | -6.27 |
| EBITAT | 15.2 | -226.1 | -341.1 | 281.5 | 34.9 | -111.8 | -121.5 | -132.2 | -143.7 | -156.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 265.8 | -49.6 | -134.4 | 536.7 | 93.9 | 131.1 | 144.8 | 157.4 | 171.2 | 186.1 |
| WACC, % | 6.02 | 8.76 | 8.76 | 6.02 | 8.76 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 628.8 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 194 | |||||||||
| Terminal Value | 5,282 | |||||||||
| Present Terminal Value | 3,651 | |||||||||
| Enterprise Value | 4,280 | |||||||||
| Net Debt | 437 | |||||||||
| Equity Value | 3,843 | |||||||||
| Diluted Shares Outstanding, MM | 49 | |||||||||
| Equity Value Per Share | 78.68 |
What You Will Receive
- Flexible Forecast Inputs: Modify key assumptions (occupancy rates, ADR, RevPAR) to explore various scenarios.
- Industry-Specific Data: Chatham Lodging Trust’s (CLDT) financial information pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for you.
- Tailored and Professional: A refined Excel model that adjusts to your valuation requirements.
- Designed for Analysts and Investors: Perfect for assessing forecasts, verifying strategies, and enhancing efficiency.
Key Features
- Comprehensive CLDT Data: Pre-loaded with Chatham Lodging Trust’s historical performance metrics and future projections.
- Fully Customizable Inputs: Modify occupancy rates, average daily rates, operational costs, and capital expenditures.
- Dynamic Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different investment outcomes.
- User-Friendly Interface: Intuitive, organized, and tailored for both seasoned professionals and newcomers.
How It Works
- 1. Access the Model: Download and open the Excel template featuring Chatham Lodging Trust’s (CLDT) financial data.
- 2. Adjust Key Variables: Modify essential inputs such as occupancy rates, revenue per available room, and operating expenses.
- 3. Analyze Results in Real-Time: The financial model automatically computes valuation metrics and cash flow projections.
- 4. Explore Different Scenarios: Evaluate various market conditions to understand potential investment outcomes.
- 5. Make Informed Decisions: Utilize comprehensive valuation analyses to guide your investment strategies.
Why Choose This Calculator for Chatham Lodging Trust (CLDT)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for the lodging sector.
- Flexible Inputs: Modify the yellow-highlighted cells to explore different investment scenarios.
- In-Depth Analysis: Automatically computes Chatham Lodging Trust’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable benchmarks for analysis.
- High-Quality Standards: Perfect for financial analysts, real estate investors, and hospitality consultants.
Who Should Use This Product?
- Investors: Assess Chatham Lodging Trust’s (CLDT) intrinsic value to inform investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis.
- Consultants: Easily modify the template for client valuation reports related to Chatham Lodging Trust (CLDT).
- Entrepreneurs: Discover financial modeling techniques employed by leading hospitality firms.
- Educators: Implement it as a resource for teaching valuation strategies in finance courses.
What the Template Contains
- Historical Data: Includes Chatham Lodging Trust’s (CLDT) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Chatham Lodging Trust’s (CLDT) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Chatham Lodging Trust’s (CLDT) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.