Summit Hotel Properties, Inc. (INN) DCF Valuation

Summit Hotel Properties, Inc. (INN) 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

Summit Hotel Properties, Inc. (INN) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 2.42 5.02 4 3.11 2.9
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Summit Hotel Properties, Inc. (INN) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Summit Hotel Properties, Inc. (INN) intrinsic value.
  5. 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.

No products were found matching.