Want FREE Templates on Strategy & Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

Hotel Financial Model and Valuation   Excel template (XLSX)
$119.00

Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Hotel Financial Model and Valuation (Excel template (XLSX)) Preview Image Log in to unlock full preview.
Arrow   Unlock all 37 preview images:   Login Register

Hotel Financial Model and Valuation (Excel XLSX)

File Type: Excel template (XLSX)

$119.00
Created by a Financial Modeling, Planning & Performance Consultant with 15+ years of experience at Ernst & Young, Toyota, Viohalco, and Upstream. Certified by both the Corporate Finance Institute and the Financial Modeling Institute.
Add to Cart
  


BUY WITH CONFIDENCE

Immediate digital download upon purchase.
Lifetime document updates included with purchase.
Fully editable & customizable XLSX document.
Trusted by over 10,000+ organizations.

BENEFITS OF DOCUMENT

  1. Room revenues in 6 different categories along with their respective costs
  2. Food & Beverage Revenues and Costs and other Revenue Generating Activities (Pool Bar, SPA, Weddings, etc…)
  3. Income statement, Balance Sheet, and Cash Flow Statement with the relevant checks

DESCRIPTION

This product (Hotel Financial Model and Valuation) is an Excel template (XLSX), which you can download immediately upon purchase.

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.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in Integrated Financial Model, Real Estate, Hotel Industry Excel: Hotel Financial Model and Valuation Excel (XLSX) Spreadsheet, Big4WallStreet


$119.00
Created by a Financial Modeling, Planning & Performance Consultant with 15+ years of experience at Ernst & Young, Toyota, Viohalco, and Upstream. Certified by both the Corporate Finance Institute and the Financial Modeling Institute.
Add to Cart
  

OVERVIEW

File Type: Excel xlsx (XLSX)
File Size: 903.1 KB


ABOUT THE AUTHOR

Author: Big4WallStreet
Additional documents from author: 70

We help small and midsize businesses' leaders with their strategic problems by creating or improving financial models, implementing tools to drive efficiency, performance, and better decision making. [read more]

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab




Read Customer Testimonials





Customers Also Like These Documents

Related Management Topics


Integrated Financial Model Real Estate Hotel Industry Private Equity

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S Strategy Model, Balanced Scorecard, Disruptive Innovation, BCG Experience Curve, and many more.