Hotel Financial Model
Hotel Financial Model Excel Template will allow investors or business owners to make financial projections and decide on their hotel investment projects!
If you ever thought of owning a business that would yield steady income over years, you might have considered becoming a hotel’s owner. Over past decades, hospitality industry shows expanding trend, and there is enough room to new entrepreneurs.
However, entering the hotel business requires a quite amount of capital allocation. It is quite possible that you would need to borrow from the bank in order to buy a property and renovate it. Because you want to meet expectations of your target audience, not to say to build it from the ground. That is when Hotel Financial Model comes in because your financial projections are one of the first things your creditors would like to see.
Hotel Financial Model Template Features:
Basically, this template consists of 3 main parts:
This is when our Hotel Financial Model would be of use. With it you will:
- Create financial projections for up to 10 years and test them using a range of assumptions;
- Account for various unit types, taking into account seasonal change and year-to-year fluctuations of prices and occupancy;
- Analyze for different sources of income, such as accommodation, food and beverages, retail and use of amenities;
- Manage different sales channels, such as direct reservation, booking engines and travel agents.
Although being rather simple and user-friendly, this hotel feasibility study model offers a full range of the professional financial modelling tool’s features. Let’s dive into each section:
Start working from the Dashboard. Here you will find the links to all parts of the model, as well as few settings and assumptions.
Model Config section allows you to:
- Set a length of the Projection Period (from 2 to 10 years) by picking from the drop down list;
- Enter the Start Date of the project;
- Enter a code of the currency which all monetary amounts will be displayed in;
- Show or hide instructions by using the drop down list.
There are two tables here as well:
- Sales Channels table contains a list of the applicable sales channels with their assumed revenue shares and commission percentages that each channel entails;
- Occupancy by Years table allows you to set maximum occupancy rates (not taking into account seasonal variations) which you reasonably expect to reach in each of the consequential years of operation.
Next go to the Assumptions section which contains the most important projection, namely your expected sales.
Sales And Pricing Assumptions
In the first table Sales – Accommodation, enter the following information:
- A list of accommodation units;
- Regular nightly rates for each type of units, before taking into account any discounts;
- For each type of units, number of units available;
- For each type of units, number of persons per units. These numbers will be used to calculate other incomes as specific amounts per guest;
- For each month of the year, enter expected occupancy rates and average discounts. Ultimate occupancy rate for a month will be found as the product of the month-specific occupancy rate and year-specific maximum occupancy which you have entered in the Dashboard section.
In the second table Sales – Other Revenue, enter the following:
- Names of facilities with relevant group of income lines (Food & Beverages, Retail, Amenities, Miscellaneous);
- Percentage of variable costs that entails the income line;
- A method for estimating income amounts: specific amount per guest or fixed amount;
- For each month of the year, enter expected income amounts (either average per guest, or fixed sum, depending on the previous setting).
In the next two tables, expected numbers of booked nights for each unit, and expected numbers of guests will be calculated accordingly.
If you expect that prices will increase over time, enter increase rate with its frequency into Price Increase fields. Price Evolution table will contain actual prices adjusted for both seasonal price changes and time-related price increase. Alike, other income amounts will be adjusted to accommodate an expected increase over time.
Ultimately, Sales Revenues from all lines of income will be calculated with sales channel commissions and variable costs (costs of goods and services sold). If you expect that costs will increase over time, enter increase rate with its frequency into Cost Increase fields. Variable cost amounts will be adjusted.
Your next step for your hotel financial model will be entering expected salaries and other fixed costs in the Fixed Costs section.
Start here from the Staff table. Enter names of employee positions with groups of income lines.
For example, maids and cleaners will be associated with accommodation, and cooks and waiters – with food and beverages income. For each position, provide wage/salary level, as on the start date of the project. To account for seasonal variations in the workforce, enter the expected average number of employees for each month of the year.
Other Monthly Expenses table follows the same logic;
- Enter names of expense items into the list, with the groups of income lines,
- Enter expected monthly amounts of expenses for each month of the year.
As it is reasonable to expect that expenses will increase over time, enter expected increase rates and frequencies into Salary Increase and Expenses Increase fields.
The tool will calculate time-adjusted amounts of wages/salaries and other fixed expenses for each month of the projected period.
Last, but not least step will be entering your startup costs into this section. Usefulness of the model’s outcomes will greatly depend on the degree of accurateness in estimating the costs you will need to start your hotel business.
Now as you have entered all necessary data, go to the reports which are available from the Dashboard section.
Financial statements summarize your hotel accounting info in a way that’s simple to understand. For most small hotel business owners, it can be either monthly or quarterly. The Hotel Financial Model provides monthly statements that flow into annual summaries easily including:
- Income Statement
- Balance Sheet
- Cash Flow Statement
Profit (EBITDA) is assessing basic day-to-day operational profitability. The elimination of expenses like interest, taxes, depreciation and amortization from the metric means that performance can be viewed away from accounting and financing. So you will easily present breakdowns of income and expenses by lines of income;
Break-even reports will give you an idea of when you are going to recover your initial investments;
- Yearly Financial Statements;
- NPV & IRR Calculation;
- Sales Report showing break even of occupancy data;
- Detailed Revenue report presenting income by unit types and facilities;
- Gross Profit report for each income line, and overall;
- Salary Breakdown report;
- Marketplace Sales Breakdown, Revenue and Profit reports.
Finally, the Data Source will consolidate all data and inputs of your Hotel Financial Model. We do not recommend you make any manual changes in this section. However, if you are Excel-savvy to be able to modify the file structure, you can edit this section to create much more customized reports with your data.
Hotel Financial Model Template Features Summary
- Unique Excel Template to perform hotel financial feasibility study
- Overview of hotel revenues and expenses at a glance
- Works both on Mac and Windows
- No installation needed, ready to use.
- Professional design and suitable for presentations
- Innovative reporting system
- Financial Statements
- On Sheet Instructions
- White Label
- Compatible with Excel 2010 and later versions