Hotel financial Excel model which generates the 3 financial statements as well as a valuation (incl. sensitivity analysis).

The model structure is as follows:

Timing: main conventions used in the model + 5 scenarios that can be used in order to evaluate the business plan and valuation.

Inputs (in yellow whatever can be amended as an assumption): detailed inputs for rooms, food and beverage and various other auxiliary revenue generating activities as well as their costs (includes detailed payroll) and the respective assumptions on balance sheet assumptions (fixed assets, working capital, debt and equity) and cash flow assumptions, includes as well tax and VAT assumptions and macro assumptions.

Calculations: this were all calculations are performed. Room revenues in 6 different categories along with their respective costs, Food & Beverage Revenues and Costs and other Revenue Generating Activities (Pool Bar, SPA, Weddings etc...), Admin Expenses. On the Balance Sheet Calculations we have detailed fixed assets assumptions along with capex and depreciation with 5 different categories, working capital assumptions, taxes (including income tax losses and VAT), debt obligations split as long term and short term, and finally Equity assumptions including minimum cash balance and dividends.

WACC (Weighted Average Cost of Capital): this tab presents a high level weighted average cost of capital used for the specific sector (this might differ depending on the country where the operations are carried over)

Financial Statements: everything is aggregated here into Income Statement, Balance Sheet and Cash Flow Statements with the relevant checks. No macros are needed everything is calculated in real time based on the assumptions used.

Valuation: the valuation of the company is calculated based the Free Cash Flows to the Firm and additionally a sensitivity analysis has been performed based on the WACC and the Growth Rate to Perpetuity. The central values of the sensitivity can be changed manually (yellow cells).

Summary: All the graphical representations of the most important KPIs of the Hotel Company are presented here.

Checks: A dedicated worksheet that makes sure that everything is working as it should!

Important Notice: Yellow indicates inputs and assumptions that the user is able to change, Blue cells are used for called up cells, and white cells with black characters indicates calculation cells.

Reviews Add a review
No reviews yet

More From Big4WallStreet

Browse our top rated business templates. See All
Self Serve Car Wash Financial Model Template
 Self-Serve Car Wash Financial Model consists of a financial model in excel for the opening of a new car wash…
Country Macroeconomic Factsheet Excel Template
Updated with IMF Nov 2021 Data. Factsheet with main macroeconomic indicators based on the country selection and base year. Users can select…
Sales Commissions Dashboard
 This model will allow you to plan your commission structure and monitor the performance of your salespeople versus company targets…
Dynamic Arrays in Excel
Dynamic Arrays (“DA”) allow you to work with multiple values at the same time. Dynamic Arrays are only available in…
Self Storage Financial Model (Buy Upgrade Operate Exit)
Considering investing in a self-storage facility? This might be an easier way for entry-level real estate investors to get into…
Self Storage Financial Model (Construction, Operations & Exit)
 Use our Financial Model to plan the Self-Storage construction, and subsequent rental operations for several years before exiting your investment.…
See All