Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
  • Hotel Valuation Excel Model
Originally published: 29/04/2019 09:24
Last version published: 14/05/2019 20:59
Publication number: ELQ-70782-5
View all versions & Certificate
certified

Hotel Valuation Excel Model

The Hotel Financial Model provides a framework to forecast the Income, cash flows, sensitivity analysis & Breakeven.

Description
Description

Taking into account key assumptions such as occupancy rates, the average check per different room types, and the combination of fixed and variable costs, the model provides a framework to forecast the expected Income, Balance sheet and Cash Flow statement, as well as the valuation of the modeled restaurant business using the DCF approach.

The model also allows the user to develop scenarios based on the variation of key metrics, namely occupancy rate, COGS variation, variation of supplies costs, and changing in average check per guest. After modeling the scenarios, the user can make the comparison between them side-by-side.

Model Structure:
Intermediate Sheets:
• Revenue: Sales Breakdown by the different menu items and by group of sales (room rent, Food, Beverage and others)
• Cost of Revenue: Breakdown of the Cost of revenue for each stream
• Wages & Salaries: Calculation of the cost with wages & salaries for each year and monthly wise for the chosen year
• Suppliers and External Services: Calculation of the cost with supplies for each year and monthly wise for the chosen year
• Loan Schedule: Calculation of the debt service (Principal & Interest) and outstanding balance
• Depreciation: Calculation of the depreciation, according to the Capex for each year.
• Working Capital: Calculation of the working capital requirement by using the collection, payment and duration of storage periods assumptions.
Outputs:
• Executive Summary: Summary of the main KPIs
• Cases Overview: In this sheet the user can analyze all the scenarios side-by-side (the user must run the macro to update the scenarios)
• Yearly Financial Statements: Yearly profit and loss account, Balance sheet and cash flow
• Statement
• Monthly Financial Statements: Monthly profit and loss account, Balance sheet and cash flow
• Statement
• Break Even Analysis: Calculation of the break-even base on revenues
• Valuation: the valuation of the company is calculated based the Free Cash Flows to the Firm

This is a powerful tool that will allow the user to create accurate forecasts, whit multiple scenarios analysis in a hotel business.

Should you have any questions, please feel free to contact.

This business tool includes
1 Excel Template

Acquire business license for $25.00

Add to cart

Add to bookmarks

Discuss

Further information

To help Investors and owners to assess the value of a hotel firm.

Indicated for hotel investments appraisals

Does not work well for not hotel related businesses.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Hotel Valuation Excel Model?

The user community and author are here to help. Go ahead!

please wait...