Hotel Valuation Financial Model

The Hotel Valuation Financial Model provides a simple way to forecast the expected cash flows for a hotel investment and calculates the relevant investor metrics such as the IRR (levered and unlevered).

Hotel_VaHotel Valuation Financial Modelluation_Financial_Model
, ,
, , , , , ,

The Hotel Valuation Financial Model provides the framework to value a hotel via the Discounted Cash Flow (DCF) method.

Based on user’s feedback we have reworked this model to focus on the DCF value and also have added the Sensitivity Analysis to it. The previous IRR analysis part now is included only in a separate Hotel Investment Model.

The Excel model template provides the following:

  • Executive Summary with key charts, key metrics, and key assumptions. Simply change the assumptions on the right and see immediately the effect on the charts for easy to understand
  • Yearly financial projections for 10 years
  • Key Assumptions
    • Average room rate
    • Average occupancy rate
    • Number of rooms
    • Commission costs for affiliate marketers and transaction costs
    • Cost of sales
    • All other operating expenses (OPEX) costs (modeled as fixed costs)
    • Discount Rate (WACC)
    • Exit EV/EBITDA Multiple
  • Revenue Streams
    • Room rental
    • Food & Beverage
  • Financial Statements (Yearly) – Income Statement, Balance Sheet, Cash Flow Statement
  • DCF Valuation Analysis
  • Sensitivity Tables
    • Show the results what happens when key assumptions such as the average room rates or occupancy rates will be changed
    • Switch for Enterprise Value / Equity Value
  • Debt schedule which models two layers of financial debt (junior and senior debt) – if needed
  • Fixed asset depreciation schedule with different categories of fixed assets
  • Forecast of all relevant financial ratios
  • Print-friendly layout including charts and graphs

The Executive Summary provides an instant overview of a Hotel’s valuation based on DCF analysis and the related assumptions.

The model is available in two versions, a FREE PDF Demo Version and an Excel version where all cells are editable.

Filetypes:

.pdf PDF Acrobat Reader

.xlsx Microsoft Excel

Add to wish list
Download Excluding 0% tax

Below a screenshot of the main executive summary sheet.

Hotel Valuation Financial Model Summary Sheet
Hotel Valuation Financial Model Summary Sheet

Add to wish list
Download Excluding 0% tax

Users who purchased Hotel Valuation Financial Model, also purchased:
Hotel Financial Model and Valuation
Hotel Financial Model and Valuation
Add to wish list
Purchase Excluding 0% tax
DCF Valuation Model Restaurant
DCF_Valuation_Model_for_Restaurants
Add to wish list
Purchase Excluding 0% tax
Hotel Investment Financial Model
Hotel_Investment
Add to wish list
Purchase Excluding 0% tax

Reviews

  • Avatar Hotel Investment Model

    Excellent

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Write a Review

    Get these templates too for a discount!

    Price: $99.00

    This is a bundled product of financial model templates from the Hospitality Industry.

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $95.00

    This is a collection of financial model templates for businesses in the hospitality industry and its related sectors

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $140.00

    This is a bundle of financial model templates related to the Fitness and Sports Industry. To help you save money…

    Add to wish list
    Add to cart Excluding 0% tax