InnSuites Hospitality Trust (IHT) DCF Valuation

InnSuites Hospitality Trust (IHT) 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

InnSuites Hospitality Trust (IHT) 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:

Discover the true value of InnSuites Hospitality Trust (IHT) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect InnSuites Hospitality Trust (IHT) valuation – all within a user-friendly Excel template.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 6.6 4.2 6.4 7.1 7.5 8.1 8.8 9.5 10.3 11.1
Revenue Growth, % 0 -36.02 52.52 11.48 4.74 8.18 8.18 8.18 8.18 8.18
EBITDA -1.0 -2.0 1.2 .4 .0 -.6 -.7 -.7 -.8 -.8
EBITDA, % -14.48 -47.14 19.03 5.67 -0.55875 -7.5 -7.5 -7.5 -7.5 -7.5
Depreciation 8.4 6.2 5.6 6.0 .7 6.2 6.7 7.2 7.8 8.4
Depreciation, % 128.21 146.82 86.81 84.52 9.07 76.08 76.08 76.08 76.08 76.08
EBIT -9.4 -8.2 -4.3 -5.6 -.7 -5.8 -6.2 -6.8 -7.3 -7.9
EBIT, % -142.69 -193.96 -67.78 -78.86 -9.63 -71.25 -71.25 -71.25 -71.25 -71.25
Total Cash 1.2 1.7 1.2 2.1 1.3 2.0 2.2 2.4 2.6 2.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .7 .1 .1 .1 .1
Account Receivables, % 10.31 1.44 2 1.42 1.5
Inventories -1.4 -.1 -.4 -1.9 .0 -.9 -1.0 -1.1 -1.1 -1.2
Inventories, % -20.59 -3.07 -6.46 -25.9 0 -11.2 -11.2 -11.2 -11.2 -11.2
Accounts Payable .4 .1 .2 .1 .2 .3 .3 .3 .3 .4
Accounts Payable, % 6.41 3.25 3.17 1.19 3.01 3.41 3.41 3.41 3.41 3.41
Capital Expenditure -.3 .0 -.1 -.3 -.5 -.3 -.3 -.4 -.4 -.4
Capital Expenditure, % -4.94 -0.89095 -1.81 -4.65 -6.96 -3.85 -3.85 -3.85 -3.85 -3.85
Tax Rate, % 26.42 26.42 26.42 26.42 26.42 26.42 26.42 26.42 26.42 26.42
EBITAT -8.2 -8.0 -17.1 5.5 -.5 -4.1 -4.5 -4.8 -5.2 -5.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 1.0 -2.7 -11.4 12.5 -2.1 2.5 1.9 2.1 2.3 2.4
WACC, % 4.83 5 5.04 3.39 4.61 4.57 4.57 4.57 4.57 4.57
PV UFCF
SUM PV UFCF 9.8
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 3
Terminal Value 235
Present Terminal Value 188
Enterprise Value 198
Net Debt 11
Equity Value 187
Diluted Shares Outstanding, MM 9
Equity Value Per Share 20.45

What You Will Get

  • Real IHT Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures.
  • Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess InnSuites' future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Customizable Financial Inputs: Adjust essential variables such as occupancy rates, average daily rates, and operating expenses.
  • Instant Valuation Calculations: Automatically computes intrinsic value, cash flow projections, and other financial metrics.
  • High-Precision Estimates: Leverages InnSuites Hospitality Trust's (IHT) actual performance data for accurate valuation results.
  • Effortless Scenario Testing: Easily evaluate various market conditions and their impacts on financial outcomes.
  • Efficiency Booster: Streamline your analysis process without the need for intricate financial models.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered InnSuites Hospitality Trust (IHT) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for InnSuites Hospitality Trust’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for InnSuites Hospitality Trust (IHT)?

  • Accuracy: Utilizes real InnSuites financial data to ensure precise calculations.
  • Flexibility: Allows users to easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
  • Professional-Grade: Crafted with the expertise and usability expected by CFOs.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.

Who Should Use This Product?

  • Hospitality Students: Explore real estate valuation techniques and apply them to the hospitality sector.
  • Researchers: Utilize professional financial models in your studies or academic papers.
  • Investors: Evaluate your investment strategies and analyze valuation scenarios for InnSuites Hospitality Trust (IHT).
  • Financial Analysts: Enhance your analytical process with a customizable DCF model tailored for hospitality investments.
  • Entrepreneurs: Understand the valuation methods used for publicly traded hospitality companies like InnSuites.

What the Template Contains

  • Pre-Filled Data: Contains InnSuites Hospitality Trust’s (IHT) historical financial performance and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A specific sheet for computing WACC based on user-defined inputs.
  • Key Financial Ratios: Evaluate InnSuites Hospitality Trust’s (IHT) profitability, efficiency, and capital structure.
  • Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.

No products were found matching.