Summit Hotel Properties, Inc. (INN) DCF Valuation
- ✓ 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
Summit Hotel Properties, Inc. (INN) Bundle
Optimize your time and improve precision with our [Symbol] DCF Calculator! Utilizing real Summit Hotel Properties, Inc. data and customizable assumptions, this tool empowers you to forecast, analyze, and value Summit Hotel Properties, Inc. (INN) like a seasoned investor.
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 | 549.3 | 234.5 | 361.9 | 675.7 | 736.1 | 906.7 | 1,116.8 | 1,375.5 | 1,694.3 | 2,086.8 |
| Revenue Growth, % | 0 | -57.32 | 54.36 | 86.69 | 8.94 | 23.17 | 23.17 | 23.17 | 23.17 | 23.17 |
| EBITDA | 176.0 | 2.0 | 83.1 | 208.0 | 212.4 | 209.4 | 257.9 | 317.7 | 391.3 | 481.9 |
| EBITDA, % | 32.03 | 0.84619 | 22.95 | 30.79 | 28.85 | 23.09 | 23.09 | 23.09 | 23.09 | 23.09 |
| Depreciation | 472.8 | 342.1 | 391.1 | 617.8 | 150.9 | 721.7 | 889.0 | 1,095.0 | 1,348.7 | 1,661.1 |
| Depreciation, % | 86.07 | 145.91 | 108.05 | 91.43 | 20.5 | 79.6 | 79.6 | 79.6 | 79.6 | 79.6 |
| EBIT | -296.9 | -340.1 | -308.0 | -409.8 | 61.5 | -528.5 | -650.9 | -801.8 | -987.5 | -1,216.4 |
| EBIT, % | -54.04 | -145.06 | -85.1 | -60.64 | 8.35 | -58.29 | -58.29 | -58.29 | -58.29 | -58.29 |
| Total Cash | 42.2 | 20.7 | 64.5 | 51.3 | 51.8 | 88.8 | 109.4 | 134.7 | 165.9 | 204.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 13.3 | 11.8 | 14.5 | 21.0 | 21.3 | 31.6 | 39.0 | 48.0 | 59.1 | 72.8 |
| Account Receivables, % | 2.42 | 5.02 | 4 | 3.11 | 2.9 | 3.49 | 3.49 | 3.49 | 3.49 | 3.49 |
| Inventories | 33.6 | 25.7 | 54.1 | 89.1 | .0 | 82.0 | 101.0 | 124.4 | 153.2 | 188.7 |
| Inventories, % | 6.11 | 10.98 | 14.93 | 13.19 | 0 | 9.04 | 9.04 | 9.04 | 9.04 | 9.04 |
| Accounts Payable | 4.8 | 2.7 | 4.5 | 5.5 | 4.8 | 8.5 | 10.5 | 13.0 | 16.0 | 19.7 |
| Accounts Payable, % | 0.86776 | 1.14 | 1.23 | 0.81649 | 0.65573 | 0.94266 | 0.94266 | 0.94266 | 0.94266 | 0.94266 |
| Capital Expenditure | -59.3 | -22.6 | -20.4 | -76.5 | -89.6 | -89.9 | -110.7 | -136.3 | -167.9 | -206.8 |
| Capital Expenditure, % | -10.79 | -9.65 | -5.62 | -11.32 | -12.17 | -9.91 | -9.91 | -9.91 | -9.91 | -9.91 |
| Tax Rate, % | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 | 62.52 |
| EBITAT | -292.5 | -343.3 | -314.8 | -124.4 | 23.0 | -387.2 | -477.0 | -587.5 | -723.6 | -891.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 79.0 | -16.6 | 26.7 | 376.4 | 172.5 | 156.1 | 277.0 | 341.2 | 420.2 | 517.6 |
| WACC, % | 8.6 | 8.66 | 8.66 | 5.87 | 6.16 | 7.59 | 7.59 | 7.59 | 7.59 | 7.59 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,331.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 538 | |||||||||
| Terminal Value | 15,002 | |||||||||
| Present Terminal Value | 10,407 | |||||||||
| Enterprise Value | 11,738 | |||||||||
| Net Debt | 1,419 | |||||||||
| Equity Value | 10,319 | |||||||||
| Diluted Shares Outstanding, MM | 106 | |||||||||
| Equity Value Per Share | 97.77 |
What You Will Get
- Real Summit Hotel Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Summit Hotel Properties, Inc. (INN).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Summit Hotel Properties, Inc.'s (INN) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to the hospitality sector.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and flexibility in your assessments.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as occupancy rates, average daily rates, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Summit Hotel Properties' (INN) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Summit Hotel Properties, Inc. (INN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Summit Hotel Properties, Inc. (INN) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Summit Hotel Properties, Inc. (INN)?
- Accuracy: Utilizes real Summit Hotel financials to ensure precise data.
- Flexibility: Users can easily test and modify inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with limited financial modeling experience.
Who Should Use This Product?
- Investors: Accurately assess Summit Hotel Properties, Inc.'s (INN) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to Summit Hotel Properties, Inc. (INN).
- Consultants: Efficiently modify the template for valuation reports tailored to clients interested in Summit Hotel Properties, Inc. (INN).
- Entrepreneurs: Acquire knowledge about financial modeling techniques employed by leading hotel management firms.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies in the hospitality industry.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Summit Hotel Properties, Inc. (INN) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Summit Hotel Properties, Inc. (INN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.