GUIDE

Resort annual budget template: a step-by-step build

Rooms by segment, departments, undistributed costs and GOP through EBITDA, built step by step with a fictional full-year example.

A resort annual budget is a chain: room nights drive rooms revenue, guests drive food and beverage and other departments, volume drives departmental costs, and everything rolls up through gross operating profit to the figure the owner cares about. A resort annual budget template should follow that chain, so changing one assumption updates everything after it. This guide shows the order to build it in, the formulas at each step, and a full-year example with fictional numbers.

Step 1: rooms

Start with capacity: rooms available = keys × days in the year. Then budget room nights and rate by market segment (for example transient and group), because each segment books at a different rate and on a different pattern:

segment rooms revenue = segment room nights × segment ADR

Add the segments, then derive the KPIs rather than typing them: occupancy = total room nights ÷ rooms available, ADR = rooms revenue ÷ room nights and RevPAR = rooms revenue ÷ rooms available. The blended ADR is a weighted result of the mix; if group grows, blended ADR can fall even with no rate change.

Step 2: food and beverage and other operated departments

Drive F&B from volume where you can: covers by outlet and average check, banquet revenue from the group pace, and so on. Other operated departments, such as spa, golf or retail, follow the same idea. Then budget each department's costs: cost of sales as a rate of revenue, payroll from a staffing plan, and other expenses.

Step 3: undistributed operating expenses

Administrative and general, information and telecommunications, sales and marketing, property operation and maintenance, and utilities. These are mostly fixed or step-fixed, so build them from staffing and contracts rather than as a percentage of revenue.

Step 4: GOP to EBITDA

GOP = total operating revenue − departmental expenses − undistributed operating expenses. Below GOP come management fees (often a base fee on revenue and possibly an incentive fee on profit, per the management agreement) and non-operating items such as property taxes, insurance and rent, leading to EBITDA = GOP − management fees − non-operating expenses.

Step 5: spread by month and compare with the prior year

Spread the annual budget across 12 months using seasonality by segment, then put it next to the prior year line by line with the % of revenue and per-available-room figures. Expect the owner to read the budget against last year first.

Worked example: Sample Resort full-year budget (fictional)

All figures are fictional sample data for an imaginary 150-room resort.

Rooms available: 150 × 365 = 54,750.

SegmentRoom nightsADRRooms revenue
Transient22,000$265$5,830,000
Group15,230$215$3,274,450
Total37,230$244.55$9,104,450

Transient: 22,000 × $265 = $5,830,000. Group: 15,230 × $215 = $3,274,450. Occupancy = 37,230 ÷ 54,750 = 68.0%. Blended ADR = $9,104,450 ÷ 37,230 = $244.55. RevPAR = $9,104,450 ÷ 54,750 = $166.29.

Sample Resort (fictional)Budget
Rooms revenue$9,104,450
Food & beverage revenue$4,200,000
Other operated revenue$900,000
Total operating revenue$14,204,450
Rooms expenses-$2,400,000
F&B expenses-$3,150,000
Other operated expenses-$600,000
Undistributed operating expenses-$3,300,000
Gross operating profit$4,754,450
Base management fee (fictional 3% of revenue)-$426,133.50
Non-operating expenses-$1,100,000
EBITDA$3,228,316.50

GOP = $14,204,450 − $2,400,000 − $3,150,000 − $600,000 − $3,300,000 = $4,754,450, a GOP margin of 33.5% and GOPPAR of $86.84. The fee is 3% × $14,204,450 = $426,133.50, and EBITDA = $4,754,450 − $426,133.50 − $1,100,000 = $3,228,316.50.

Once the year starts, measure results against this budget with flow-through; see the flow-through calculation guide. For the line structure, see the USALI-style P&L layout guide.

Keeping assumptions visible

A budget is as easy to defend as its assumptions are to find. Put the drivers in one place: room nights and ADR by segment and month, covers and average check by outlet, cost-of-sales rates, staffing plans and contract amounts. Calculate every revenue and expense line from those drivers, so the owner can ask "what if group ADR is ten dollars lower?" and get an answer by changing one cell.

Add a few checks before the budget goes out: the monthly spread adds back to the annual total for every line, occupancy never exceeds 100% in any month, the summary P&L ties to the department schedules, and the prior-year column ties to the prior-year financial statements. A budget that passes its own checks is much easier to present.

Common mistakes

  • Averaging segment ADRs instead of dividing total rooms revenue by total room nights.
  • Budgeting undistributed expenses as a flat percentage of revenue.
  • Spreading every line evenly across 12 months when the business is seasonal.
THE TEMPLATE

Resort & Hotel Annual Budget & P&L Model

$395 one-time · instant download

An Excel model for building one hotel or resort's 12-month operating budget in a USALI-style layout, through GOP, fees, fixed charges and EBITDA, plus a one-page owner summary against the prior year.

  • 9 tabs: Start Here, Setup, Rooms, Food & Beverage, Other Operated, Undistributed, Summary P&L, Prior Year, Owner Summary
  • Rooms revenue from occupancy and ADR by market segment; monthly Summary P&L with % of revenue and per-available-room figures
  • Full-year sample (fictional Sample Resort, 150 rooms) and blank version, plus a 3-page guide
Coming soon: the model, $395Free: Hotel KPI Reference (PDF)

Paid version coming soon; checkout is not open yet. 12 months of updates · 14-day refund, no questions asked · Excel for Microsoft 365 or 2019+ (Windows and Mac), no macros · Full details and file list

Related guides

Free files: see free downloads.

All figures on this page are fictional sample data. USALI is referenced for layout only; this is not a USALI publication and not a substitute for the USALI manual. Hospitality Finance Tools is not affiliated with or endorsed by HFTP or AHLA.

FAQ

What order should I build a resort budget in?

Rooms by segment first, then F&B and other operated departments, then departmental costs, undistributed expenses, GOP, management fees and non-operating items to EBITDA, then the monthly spread and prior-year comparison.

How do I calculate blended ADR across segments?

Add rooms revenue across segments and divide by total room nights. Don't average the segment ADRs.

What's the difference between GOP and EBITDA?

GOP is total operating revenue less departmental and undistributed operating expenses. EBITDA is GOP less management fees and non-operating expenses such as property taxes, insurance and rent.

Is the Resort & Hotel Annual Budget & P&L Model a USALI publication?

No. It uses a USALI-style layout for reference only and is not affiliated with or endorsed by HFTP or AHLA.

What does the model include?

A 9-tab Excel workbook (Start Here, Setup, Rooms, Food & Beverage, Other Operated, Undistributed, Summary P&L, Prior Year, Owner Summary) in sample and blank versions, plus a 3-page guide.