Book companion · Chapter 21 · Excel workbook / working template
DC-21 GOP, Business Models, Management Fees, and Flow-Through Protection
Build one controlled waterfall from revenue to IBNOIE while protecting flow-through and modelling management fees on the correct basis.
Connected publication: Hotel Budgeting and Forecasting in Practice
What this companion is for
This companion is designed to turn the related reading into applied hotel-finance work. It belongs with Chapter 21 of Hotel Budgeting and Forecasting in Practice, where the underlying method, definitions, and management context are explained before the working resource is used.
When to use it
Open this excel workbook / working template while working through Chapter 21 of Hotel Budgeting and Forecasting in Practice, then revisit it when the same planning, review, or control question returns.
Prepare before you start
Before you start, have the relevant source reports, operating assumptions, supporting schedules, and owner or management notes available. Record the inputs you actually used, the conclusion reached, and the follow-up required so the companion becomes part of the working evidence rather than a disconnected download.
This landing page is public so the companion can be found, shared and reached through a QR code. The working file or tool is available after the matching purchase is verified.
Paperback and hardcover purchasers can upload a receipt, invoice or order screenshot. Once the book purchase is approved, all purchaser companions attached to that book use the same entitlement.
Apply Chapter 21 in a controlled working file
- Read the instructions and confirm the source period, definitions, and assumptions before entering data.
- Complete the driver, calculation, and control sections using the evidence and ownership rules from the chapter.
- Run the verification or scenario checks and record every material exception, decision, and action owner.
- Save the reviewed version with the budget or forecast pack and update it when the chapter trigger changes.