Hotel Valuation Model (with Business Plan Forecast)
Originally published: 01/08/2018 14:57
Last version published: 13/08/2018 08:18
Publication number: ELQ-48038-2
View all versions & Certificate
certified

Hotel Valuation Model (with Business Plan Forecast)

A comprehensive and very flexible Hotel Valuation model that also allows to generate a 5 year business plan.

Description
This tool is a complete excel model that allows you to perform a DCF (Discounted Cash flow) valuation of a hotel. Also, it allows the user to generate a 5-year business plan with ease.

The template is extremely flexible and allows users to switch between 8 available scenarios. Each scenario supports inputs from the user and by switching between them you will see the impact of certain drivers on the performance of the Hotel, or your business. You can switch between scenarios in cell E3 in the inputs sheet.
All information used for the Valuation of the Hotel can be assessed and changed in the "Inputs" Sheet. The rest of the sheets contain formulae and should not be changed.

Also, on the side of in the "Inputs" Sheet you will find some comments and indications that will help you when completing the information. We will also provide a short YouTube tutorial, on which we are currently working on.

Tabs provided:
- Notice
- Inputs
- Calculations
- Timing
- Income Statement
- DCF Valuation

The model is great to assess the value of your hotel, analyze the viability of an investment or to present your outlook on the hotel to your shareholders.


Should you have any questions on the model you can always contact us.

This Best Practice includes
1 Excel file

Acquire business license for $40.00

Add to cart

Add to bookmarks

Discuss

Further information

Allow the user to easily estimate the value of a Hotel, offering flexibility and a broad overview with the use of different scenarios.

Hotel Valuation


4.7 / 5 (3 votes)

please wait...