Financial Modelling in Hospitality

Course Info

Length: 1 Week

City: London

Type: In Classroom

Available Dates

  • Feb-03-2025

    London

  • Apr-07-2025

    London

  • June-02-2025

    London

  • Aug-04-2025

    London

  • Oct-06-2025

    London

  • Dec-01-2025

    London

Dates in Other Venues

  • Jan-06-2025

    Dubai

  • Mar-03-2025

    Istanbul

  • Mar-03-2025

    Kuala Lumpur

  • Mar-03-2025

    Barcelona

  • Mar-03-2025

    Singapore

  • Mar-03-2025

    Paris

  • Mar-03-2025

    Amsterdam

  • Mar-03-2025

    Dubai

  • May-05-2025

    Dubai

  • June-02-2025

    Kuala Lumpur

  • June-02-2025

    Istanbul

  • June-02-2025

    Barcelona

  • June-02-2025

    Singapore

  • June-02-2025

    Amsterdam

  • June-02-2025

    Paris

  • July-07-2025

    Dubai

  • Sep-01-2025

    Paris

  • Sep-01-2025

    Amsterdam

  • Sep-01-2025

    Barcelona

  • Sep-01-2025

    Singapore

  • Sep-01-2025

    Istanbul

  • Sep-01-2025

    Dubai

  • Sep-01-2025

    Kuala Lumpur

  • Nov-03-2025

    Dubai

  • Dec-01-2025

    Barcelona

  • Dec-01-2025

    Istanbul

  • Dec-01-2025

    Singapore

  • Dec-01-2025

    Paris

  • Dec-01-2025

    Kuala Lumpur

  • Dec-01-2025

    Amsterdam

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