Ashford Hospitality Trust, Inc. (AHT) DCF Valuation

Ashford Hospitality Trust, Inc. (AHT) DCF Valuation

US | Real Estate | REIT - Hotel & Motel | NYSE
Ashford Hospitality Trust, Inc. (AHT) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

Ashford Hospitality Trust, Inc. (AHT) Bundle

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

TOTAL:

Enhance your investment strategy with the Ashford Hospitality Trust, Inc. (AHT) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and observe how these changes affect the intrinsic value of Ashford Hospitality Trust, Inc. (AHT) in real-time.


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,502.8 508.2 805.4 1,240.9 1,367.5 1,560.9 1,781.7 2,033.6 2,321.2 2,649.4
Revenue Growth, % 0 -66.18 58.47 54.07 10.21 14.14 14.14 14.14 14.14 14.14
EBITDA 389.5 -66.5 110.0 294.2 305.6 226.5 258.5 295.1 336.8 384.4
EBITDA, % 25.92 -13.09 13.66 23.71 22.35 14.51 14.51 14.51 14.51 14.51
Depreciation 1,384.2 827.5 917.5 1,154.1 187.8 1,245.2 1,421.2 1,622.2 1,851.6 2,113.5
Depreciation, % 92.11 162.82 113.92 93.01 13.73 79.77 79.77 79.77 79.77 79.77
EBIT -994.7 -894.1 -807.5 -860.0 117.8 -1,020.5 -1,164.8 -1,329.5 -1,517.5 -1,732.1
EBIT, % -66.19 -175.91 -100.26 -69.3 8.61 -65.38 -65.38 -65.38 -65.38 -65.38
Total Cash 277.2 92.9 592.1 417.1 165.2 486.8 555.7 634.2 723.9 826.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 67.7 45.2 80.8 49.8 45.5
Account Receivables, % 4.51 8.89 10.04 4.01 3.33
Inventories 4.3 2.4 3.3 3.9 3.7 5.5 6.3 7.2 8.2 9.3
Inventories, % 0.2892 0.48147 0.40861 0.31075 0.26902 0.35181 0.35181 0.35181 0.35181 0.35181
Accounts Payable 124.2 100.0 117.7 116.0 129.3 191.5 218.6 249.5 284.8 325.1
Accounts Payable, % 8.27 19.67 14.61 9.35 9.46 12.27 12.27 12.27 12.27 12.27
Capital Expenditure -.5 -15.4 -.1 -103.8 -.6 -35.8 -40.9 -46.7 -53.3 -60.8
Capital Expenditure, % -0.03160853 -3.03 -0.01117442 -8.36 -0.0438015 -2.3 -2.3 -2.3 -2.3 -2.3
Tax Rate, % 0.74791 0.74791 0.74791 0.74791 0.74791 0.74791 0.74791 0.74791 0.74791 0.74791
EBITAT -1,003.2 -892.2 -825.7 -900.4 116.9 -1,018.5 -1,162.5 -1,326.9 -1,514.6 -1,728.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 432.6 -79.9 73.0 178.8 322.0 200.6 230.5 263.1 300.3 342.8
WACC, % 10.93 10.91 10.93 10.93 10.85 10.91 10.91 10.91 10.91 10.91
PV UFCF
SUM PV UFCF 964.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 350
Terminal Value 3,926
Present Terminal Value 2,340
Enterprise Value 3,304
Net Debt 3,294
Equity Value 9
Diluted Shares Outstanding, MM 35
Equity Value Per Share 0.27

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financials for Ashford Hospitality Trust, Inc. (AHT).
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe how your inputs affect the valuation of Ashford Hospitality Trust, Inc. (AHT).
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

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, net present value, and additional financial metrics.
  • High-Precision Accuracy: Leverages Ashford Hospitality Trust's (AHT) actual financial data for dependable valuation results.
  • Effortless Scenario Analysis: Easily explore various assumptions and evaluate their effects on outcomes.
  • Efficiency Booster: Streamline the valuation process without needing to create intricate models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Ashford Hospitality Trust, Inc. (AHT) data.
  • Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
  • Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Immediately see the recalculated results, including Ashford Hospitality Trust, Inc.'s (AHT) intrinsic value.
  • Step 5: Use the outputs to make informed investment decisions or create reports.

Why Choose This Calculator for Ashford Hospitality Trust, Inc. (AHT)?

  • Designed for Industry Experts: A specialized tool tailored for investors, analysts, and real estate professionals.
  • Comprehensive Data: Ashford Hospitality Trust's historical and projected financials are preloaded for precise analysis.
  • Dynamic Scenario Analysis: Effortlessly model various forecasts and assumptions to see potential outcomes.
  • Insightful Results: Automatically computes intrinsic value, NPV, and other essential metrics.
  • User-Friendly Interface: Step-by-step guidance ensures a smooth experience throughout the calculation process.

Who Should Use This Product?

  • Investors: Accurately assess the fair value of Ashford Hospitality Trust, Inc. (AHT) before making investment choices.
  • CFOs: Utilize a high-quality DCF model for financial reporting and analysis related to Ashford Hospitality Trust, Inc. (AHT).
  • Consultants: Efficiently customize the template for valuation reports tailored to clients interested in Ashford Hospitality Trust, Inc. (AHT).
  • Entrepreneurs: Acquire insights into the financial modeling practices employed by leading hospitality firms.
  • Educators: Employ this resource as a teaching aid to illustrate various valuation methodologies.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Ashford Hospitality Trust, Inc. (AHT).
  • Real-World Data: Ashford Hospitality Trust's historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.

No products were found matching.