1 / 51

Hotel Management - Step by Step Approach to analyse Financial Statements

Subscribe to video course here - https://ehotelmanagementschool.com/course/analyse-financial-statements<br><br>This Course will help you to become expert in hotel management by analysing hotel operational & financial performance with ease.<br><br>In our experience Hotel management professionals in operations does not feel comfortable reading and presenting their department's financial performance due to lack of financial background, knowledge and training.<br><br>Why you should take this course<br><br>Learn how to anlayse Hotel financial statements and with key terms used in operations, cost management ideas.<br>After completing this course you will become in analyzing & present your department's performance easily and professionally.<br>You will be able to understand how your decisions affect profitability of hotel and improve hotels profitability.<br>Give your Career a head start by learning one of they key responsibilities as department / division head i.e. Managing the departmental financial performance.<br>In this unique hotel management course, we will<br><br>Discuss and understand key unique terms used in hotel management.<br>Understand definitions of revenue and expense heads.<br>Drill down all revenue and expenses to the deeper level to gain understanding how to create impact through strategic decisions.<br>Learn how to analyse the overall hotel profit and loss statement.<br>Learn important revenue management & marketing reports<br>Learn cost and operation management reports and cost management ideas.<br>Discuss the profit & loss templates prescribed by USALI<br>All terms explained are in compliance with Uniform system of accounting for lodging industries

man150780
Download Presentation

Hotel Management - Step by Step Approach to analyse Financial Statements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hospitality Finance A-Z How to Read and Analyse Hotel Income Statements Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  2. Introduction • How to Read and Analyse Hotel Income Statements • Basic Fundamentals of accounting • Accruals • Allocation • Prepayments • Revenue Terms • Quantitative (Occupancy, covers, guests) • Value (Average rate, Rev Par, Ave Check) • Segmentation (Room Revenue Segments, F&B Revenue) • Hotel Profit & Loss Standard Templates as per International Standards (Uniform System of Accounting for Lodging Industries) • Analysis Fundamentals • Marketing Reports to support analysis • Room Segmentations Report • Nationality Reports • Booking Source, Booking Pace Reports • Market Benchmark Reports • Menu Engineering • F&B Revenue Analysis • Expenses Nature & Classification • Method of Analyzing Expenses • Complete P&L Analysis • Presentation in front of Top Management / Owners Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  3. Let’s Take a Quick Q&A before we move further Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  4. Hospitality Operations and Cost Structure Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  5. What is USALI and why its necessary Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  6. Fundamentals of Accounting Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  7. Accruals What are the Example of Accrued Expenses Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  8. Allocation Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  9. Prepayments Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  10. Hotel Profit & Loss Standard Templates as per International Standards (Uniform System of Accounting for Lodging Industries) Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  11. Hotel Financial Reports - Components Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  12. Grand P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  13. Step 1 & 2 Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  14. Room Division P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  15. Room Division P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  16. F&B Division P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  17. F&B Division P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  18. Other Operating Department P&L Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  19. Administrative Expenses Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  20. Maintenance & Utlilities Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  21. Sales & Marketing Expenses Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  22. P&L Analysis Measures Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  23. Horizontal Analysis • Compares two periods , Need comparative P&L • Shows the absolute change in dollars & % Change between two periods Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  24. Vertical Analysis • Often referred to as common size analysis • Calculating the % of individual revenue to total Revenue • Expenses are also analyzed with reference to total Revenue Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  25. Ratio Analysis Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  26. Ratio Analysis –Things to Remember Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  27. Transient Rooms Revenue • FIT Room Revenue • Discount – Packages /Advance Purchase or with other sort of discount based on rules. • Qualified – Special rates depending on meeting some criteria such as government employee • Wholesale an be offline or online • Groups Room Rev (Min 10 Rooms) • SMERF – Social, Military, education, religion, fraternity • Contract Room Revenue / Permanent Room Revenue - (More than 30 days in one contract) • Other Revenues • No Show • Day Use • Early / Late Departure • Extra Bed Rooms DivisionRevenue – Presentation Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  28. Outlet wise breakdown • Food Revenue • Whether coffee / tea is food revenue? • Beverage Revenue • Audio Visual • Cover Charges • Equipment Rental • Gross Recording or Net margin? • Allowances Meal Periods and menu types in next video Food & Beverage DivisionRevenue – Presentation Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  29. Operating and Marketing Reports Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  30. Revenue by Business Source / Distribution Channels Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  31. Guest Nationality Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  32. Booking Lead Period and Pace Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  33. Competitor Bench Marketing Report Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  34. Upselling / Upgrading • Guest pay for one room type but stay in another room type • Upselling is paid • Upgrade is free due to many possible reasons • Upselling is revenue maximization opportunity • Upgrade is considered as value add service, usually offered to convert potential sales into business. • Upgrades should be controlled though paid and stay statistics Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  35. Menu Engineering Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  36. Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  37. Expenses – Labor CostManagement & Non Management What are the factors to remember Why do we segregate like this? Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  38. Why do we segregate like this? Expenses – Labor CostSegregation by Department on Non Management Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  39. Rooms DivisionExpenses – Labor CostService Charge Distribution - Treatment Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  40. Rooms DivisionExpenses – Labor Cost Other Components Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  41. Labour Cost Analysis Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  42. Expenses – Other Departmental Costs • Nature – Variable & Fixed • Expense Control Reports Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  43. Variable & Fixed Expenses Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  44. Expenses Control Reports Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  45. Profit & Loss Analysis - Steps Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  46. Step 1 & 2 Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  47. Step 3 – Room Division Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  48. Step 3 – F&B Division Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  49. Cost Management Ideas Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

  50. Thank you so Much • Questions please post to Q&A sessions • Did I missed any topic? Please post in Q&A Session • Please Review the course. Copyright - Excel Finance Academy Follow our YouTube Channel and Facebook Page linked in description to support

More Related