Financial Modelling in Hospitality

Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Dec-30-2024

    Amsterdam

  • Dec-30-2024

    Dubai

  • Dec-30-2024

    Barcelona

  • Feb-17-2025

    London

  • Feb-17-2025

    Dubai

  • Mar-10-2025

    Kuala Lumpur

  • Mar-10-2025

    Istanbul

  • Mar-10-2025

    Paris

  • Mar-10-2025

    Barcelona

  • Mar-10-2025

    Amsterdam

  • Mar-10-2025

    Singapore

  • Mar-24-2025

    London

  • Mar-24-2025

    Dubai

  • May-19-2025

    Dubai

  • May-19-2025

    London

  • June-09-2025

    Barcelona

  • June-09-2025

    Amsterdam

  • June-09-2025

    Singapore

  • June-09-2025

    Istanbul

  • June-09-2025

    Paris

  • June-09-2025

    Kuala Lumpur

  • Aug-18-2025

    London

  • Aug-18-2025

    Dubai

  • Sep-01-2025

    London

  • Sep-01-2025

    Dubai

  • Sep-08-2025

    Amsterdam

  • Sep-08-2025

    Paris

  • Sep-08-2025

    Barcelona

  • Sep-08-2025

    Istanbul

  • Sep-08-2025

    Singapore

  • Sep-08-2025

    Kuala Lumpur

  • Dec-08-2025

    Istanbul

  • Dec-08-2025

    Singapore

  • Dec-08-2025

    Barcelona

  • Dec-08-2025

    Amsterdam

  • Dec-08-2025

    Kuala Lumpur

  • Dec-08-2025

    Paris

  • Dec-29-2025

    Dubai

  • Dec-29-2025

    London

Course Details

Course Outline

5 days course

Introduction to Financial Modelling in Hospitality 


  • Definition of modeling and financial models
  • Discussing the importance and benefits of financial modeling in strategic decision-making
  • Discovering common financial modeling types
  • Exploring the applications of financial modeling in hospitality
  • Reviewing and analyzing financial statements specific to hospitality:


  1. Income statements
  2. Balance sheets
  3. Cash flow statements

Advanced Excel Techniques for Financial Modeling


  • Advanced functions and formulas in Excel:


  1. Array functions
  2. Index-match
  3. Conditional formulas


  • Data analysis tools:


  1. Pivot Tables
  2. Power Query


  • Steps of structuring models in Excel for clarity and usability
  • Understanding documentation and version control in financial models
  • Discussing best practices and common challenges in building financial models

Chart of Account Classification in Financial Modeling


  • Definition chart of accounts classification and its role in organizing financial data
  • Steps of designing charts and classifying accounts into major categories
  • Ways of linking chart of accounts with revenue and expense models
  • Using chart of accounts to improve financial performance forecasts and facilitate reporting
  • Best practices for regular update and maintenance of charts
  • Discussing the importance of documenting any changes in charts for effective financial management

Detailed Expense Modeling


  • Distinguishing between fixed and variable cost analysis
  • Steps of categorizing costs specific to hospitality operations
  • Labor cost modeling techniques:


  1. Occupancy-based techniques 
  2. Service level-based techniques


  • Process of capital expenditure planning
  • Strategies for identifying areas of cost saving in hospitality

 Financial Analysis and Valuation


  • Exploring various financial metrics
  • Exploring types of financial analysis:


  1. Break-even analysis
  2. Scenario analysis
  3. Sensitivity analysis


  • Ways of conducting financial analysis
  • Discussing the pros and cons of each financial analysis approaches
  • Techniques for integrating sensitivity analysis and scenario analysis in financial models 
  • Lesson learned and best practices