Hotel Valuation Model (with Business Plan Forecast)

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.