Hotel Financial Model Excel Template
Originally published: 26/04/2019 12:05
Last version published: 29/04/2020 08:55
Publication number: ELQ-24669-3
View all versions & Certificate

Hotel Financial Model Excel Template

This is an essential financial model for those with a hotel investment project.

This is a highly detailed, well-presented financial model template for those looking to project and forecast finances for a hotel investment project.

With a high amount of capital allocation often needed to start a hotel investment project, a hotel financial model will help to assess the viability of your project to both you and creditors.

Ready to download and enter your data immediately, this Excel model is a fantastic tool for both time-saving and presentation purposes. It consists of the following main sections:

- Dashboard: This first part of the document provides an extremely clean view of links to the rest of the document and two tables on Sales Channels and Occupancy by year. There is also the option to configure the length of the projection period, start of the project, currency code add-in, and to toggle instruction visibility.

- Sales and Pricing Assumptions: This section of the model contains tables for data input on the following: Sales - Accommodation rates and occupancy, Sales – Other Revenue, Sales projections – nights booked, Guests – nights booked.

- Fixed Cost: Includes data inputs for staff, other monthly expenses, and salaries evolution.

- Start-up Cost: This section allows start-up cost input; this is an important section and accuracy is essential.

- Report Outputs: Detailed, yet easy-to-read section displaying the income statement, balance sheet, and cash flow statement.

Compatible with 2007 Word and later, this model comes with video tutorial to help you better utilise the document.

If you have any questions surrounding the download, feel free to start a discussion below, or contact through private message via our Eloquens author channel.

This Best Practice includes
1 Excel Spreadsheet, 1 Tutorial Video

Acquire business license for $150.00

Add to cart

Add to bookmarks



  • Be the first to review this Downloadable Best Practice

    Write a review


More Best Practices from Someka

See all

Any questions on Hotel Financial Model Excel Template?

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

0.0 / 5 (0 votes)

please wait...