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. 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.Ĭalculations: this were all calculations are performed. Timing: main conventions used in the model + 5 scenarios that can be used in order to evaluate the business plan and valuation. Hotel financial Excel model which generates the 3 financial statements as well as a valuation (incl. Income statement business plan valuation dcf wacc business model discounted cash flows financial model 3 statement model hospitality hotel financial model
Weighted average cost of capital (wacc).International financial reporting standards (ifrs).
