The hotel financial Excel model 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 is where 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 statements, Balance Sheets, 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 on 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 indicate calculation cells.
The model is available as PDF Demo Version and as a Full Version in MS Excel.
Similar Products
Other customers were also interested in...
Hotel Complex – Financial Model (5 Yrs. DCF ...
The Hotel Complex financial model is a comprehensive tool designed to analyze the financial aspects ... Read more
Airbnb Financial Model
Air BnB Financial Model Template presents the business case of the purchase of up to 5 properties wi... Read more
Hotel Development Financial Model
Hotel Development Financial Model presents the case where an hotel is constructed with the intention... Read more
Hospitality Financial Model Bundle
Are you planning to start a business in the Hospitality Industry or its related sectors? Are you int... Read more
ALL IN ONE Boutique Hotel Integrated 5-Year DCF Fi...
This is a real case-based advanced DCF model of a boutique hotel business with scenarios options and... Read more
Hotel Financial Model Excel Template
Download Hotel Financial Model. Creates a financial summary formatted for your Pitch Deck. Ready to ... Read more
Hostel Financial Model Excel Template
Check Hostel Financial Plan. Requesting a loan without a financial model for paying it back is a com... Read more
Best Resort Financial Model
The best financial model for a Resort business. Unlock the true potential of your luxury resort with... Read more
Boutique Hotel Financial Model Excel Template
Check Our Boutique Hotel Financial Projection. Excel - well-tested, robust, and powerful. Get you a ... Read more
Hotel/Guesthouse/Resort Development Model and Valu...
This Hotel / Holiday Resort Development Model will take you through a 20-year period of Three Statem... Read more
You must log in to submit a review.