Financial Planning and Forecasting

Looking Forward

Hotel finance isn't just about reading statements. It's about anticipating the future and planning for it.

Budgets, forecasts, and scenarios help you:

  • Set targets and hold teams accountable
  • Anticipate cash flow needs
  • Make informed decisions
  • Respond to changing conditions
  • Communicate with owners and lenders

This chapter covers how to build and use financial plans effectively.

The Budget Process

What a Hotel Budget Is

The annual budget is your financial plan for the year:

  • Monthly revenue projections by segment
  • Monthly expense projections by category
  • Capital expenditure plans
  • Cash flow projections

It becomes the target against which performance is measured.

The Budget Calendar

August-September: Economic outlook, market analysis, preliminary targets.

October: Department budgets submitted.

November: Consolidation, review, negotiation.

December: Final approval.

January: Budget takes effect.

Start early. Good budgets take time.

Building the Revenue Budget

Start with market view:

  • Market demand trends
  • New supply
  • Economic indicators
  • Event calendar

Build room revenue:

  • Available rooms (minus out-of-order)
  • Occupancy by month (based on history and market view)
  • ADR by month (pricing strategy, mix)
  • RevPAR = Occupancy × ADR
  • Room revenue = RevPAR × Available rooms

Build other revenue:

  • F&B based on covers and average check
  • Other departments based on drivers

Building the Expense Budget

Start with revenue: Many expenses scale with revenue.

Fixed costs:

  • Known amounts (rent, insurance, taxes)
  • Contractual obligations
  • Planned changes

Variable costs:

  • Rooms: Cost per occupied room × Occupancy
  • F&B: Cost percentages × Revenue
  • Labor: Staffing model × Wage rates

Semi-variable costs:

  • Base level plus incremental for volume

Zero-Based vs. Incremental

Incremental budgeting: Start with last year, adjust.

  • Quick
  • May perpetuate inefficiencies

Zero-based budgeting: Justify every dollar.

  • Thorough
  • Time-consuming
  • Recommended every few years

AI Prompt: Budget Development

Help me develop next year's budget framework.

This year's results (projected):
- Room revenue: $[Amount]
- F&B revenue: $[Amount]
- Total revenue: $[Amount]
- GOP: $[Amount]
- RevPAR: $[Amount]
- Occupancy: [Percentage]
- ADR: $[Amount]

Market outlook:
- Market RevPAR growth expected: [Percentage]
- New supply: [Description]
- Economic outlook: [Description]
- Special factors: [Events, etc.]

My targets/constraints:
- Owner expectations: [Description]
- Known cost changes: [Wage increases, etc.]
- Planned improvements: [Description]

Help me build:
1. Revenue assumptions by month
2. Expense benchmarks to target
3. GOP margin goal
4. Key sensitivities
5. Risks to the budget

Forecasting

Budget vs. Forecast

Budget: Annual plan, set once.

Forecast: Rolling projection, updated regularly.

Budgets set targets. Forecasts tell you where you're actually heading.

Forecast Frequency

Monthly forecast: Update full-year projection each month.

Rolling forecast: Always looking 12 months ahead (not tied to fiscal year).

Weekly operating forecast: Near-term revenue and staffing.

The Forecast Process

Update for actual results: What actually happened vs. what we expected?

Revise forward assumptions: Has anything changed about the future?

Identify variances: Where will we beat or miss budget?

Calculate full-year landing: Where will we finish?

Determine actions: What can we do to improve the outcome?

AI Prompt: Forecast Update

Help me update my hotel's forecast.

Budget for the year:
- Revenue: $[Amount]
- GOP: $[Amount]

Year-to-date actual (through [Month]):
- Revenue: $[Amount] vs. budget $[Amount]
- GOP: $[Amount] vs. budget $[Amount]

Remaining months last year:
- Revenue: $[Amount]
- GOP: $[Amount]

What's changed:
- Market conditions: [Description]
- Our performance trend: [Description]
- Known factors ahead: [Events, issues, etc.]

Calculate:
1. Projected full-year revenue and GOP
2. Variance to budget
3. What would need to happen to hit budget
4. Recommended actions
5. Risk factors to watch

Scenario Planning

Why Scenarios Matter

The future is uncertain. Single-point forecasts give false precision.

Scenarios explore multiple possible futures:

  • What if demand is stronger than expected?
  • What if a recession hits?
  • What if our main competitor renovates?
  • What if we lose a major corporate account?

Building Scenarios

Base case: Most likely outcome.

Upside case: Things go better than expected.

Downside case: Things go worse than expected.

Stress case: Severe adverse scenario.

For each scenario, model:

  • Revenue impact
  • Cost implications
  • Cash flow
  • Response actions

AI Prompt: Scenario Analysis

Build scenarios for my hotel's forecast.

Base case assumptions:
- RevPAR growth: [Percentage]
- Occupancy: [Percentage]
- ADR: $[Amount]
- GOP margin: [Percentage]

Key uncertainties:
1. [Uncertainty 1, e.g., economic conditions]
2. [Uncertainty 2, e.g., new competition]
3. [Uncertainty 3, e.g., corporate account]

For each scenario (base, upside, downside, stress):
1. Define the scenario narrative
2. Estimate RevPAR impact
3. Calculate revenue and GOP
4. Identify response actions
5. Cash flow implications

Cash Flow Management

The Cash Flow Challenge

Hotels face unique cash flow dynamics:

Seasonality: High season generates surplus; low season drains cash.

Timing mismatches: Receivables (corporate accounts), payables, and tax timing.

Capital intensity: Major expenditures are lumpy.

Debt service: Fixed payments regardless of performance.

Cash Flow Forecasting

Project cash flow monthly:

Cash inflows:

  • Room revenue (mostly immediate)
  • F&B revenue (immediate)
  • Corporate AR collections
  • Other income

Cash outflows:

  • Payroll (weekly/bi-weekly)
  • Operating expenses
  • Debt service
  • Owner distributions
  • CapEx
  • FF&E reserve deposits
  • Taxes

Managing Through Seasonality

During high season:

  • Build cash reserves
  • Prepay expenses if beneficial
  • Deposit to FF&E reserve
  • Catch up on deferred payments

During low season:

  • Draw on reserves
  • Manage payables timing
  • Delay discretionary spending
  • Communicate with lenders/owners

Working Capital Management

Accounts receivable:

  • Corporate accounts may take 30-60 days
  • OTAs typically pay within 2-4 weeks
  • Monitor aging; collect promptly

Accounts payable:

  • Standard terms 30 days
  • Take discounts when worthwhile
  • Maintain vendor relationships

Inventory:

  • Minimize F&B inventory
  • Just-in-time where possible
  • Monitor for waste

AI Prompt: Cash Flow Planning

Help me plan cash flow for the next 12 months.

Current position:
- Cash on hand: $[Amount]
- Available credit line: $[Amount]
- Monthly debt service: $[Amount]

Revenue seasonality (monthly as % of annual):
[Provide monthly percentages or description]

Monthly operating expenses (relatively fixed):
- Payroll: $[Amount]
- Fixed costs: $[Amount]
- Variable (as % of revenue): [Percentage]

Upcoming cash needs:
- CapEx planned: $[Amount], timing: [Month]
- Tax payments: $[Amount], timing: [Month]
- Owner distributions: $[Amount], timing: [Description]

Project:
1. Monthly cash flow by month
2. Peak cash need and timing
3. Minimum cash reserves needed
4. Financing requirements
5. Recommendations for smoothing

Financial Reporting

Reports for Different Audiences

Operations team:

  • Daily revenue reports
  • Labor efficiency
  • Occupancy and rate
  • Department P&Ls

Property leadership:

  • Weekly summary
  • Monthly P&L vs. budget
  • STR competitive performance
  • Forecast updates

Ownership:

  • Monthly P&L package
  • Variance analysis
  • Forecast and outlook
  • Capital project status

Lenders:

  • Quarterly or monthly financials
  • Covenant compliance
  • DSCR calculations
  • Reserve status

The Monthly Package

A well-prepared monthly owner report includes:

  1. Executive summary
  2. P&L vs. budget and prior year
  3. RevPAR and STR performance
  4. Variance explanations
  5. Forecast update
  6. Cash flow status
  7. Capital project updates
  8. Key initiatives and issues

Using AI for Reporting

AI can help prepare financial narratives:

Variance explanations: Generate draft explanations for significant variances.

Trend analysis: Identify patterns in the data.

Competitive commentary: Contextualize STR performance.

Executive summary: Draft high-level overviews.

AI Prompt: Financial Narrative

Help me write the financial narrative for this month's owner report.

Performance summary:
- Revenue: $[Amount] vs. budget $[Amount]
- GOP: $[Amount] vs. budget $[Amount]
- RevPAR: $[Amount] vs. comp set $[Amount]

Key variances:
- [Variance 1]: $[Amount] over/under because [reason]
- [Variance 2]: $[Amount] over/under because [reason]

Operational highlights:
- [Achievement or issue]
- [Achievement or issue]

Forward outlook:
- [Key factor for coming months]

Write:
1. Executive summary (3-4 sentences)
2. Revenue commentary
3. Expense commentary
4. Competitive context
5. Outlook statement

KPI Dashboards

Building Effective Dashboards

Good dashboards:

  • Show what matters
  • Enable quick comprehension
  • Highlight exceptions
  • Support action

Essential KPIs

Revenue:

  • RevPAR and RGI
  • ADR and occupancy
  • TRevPAR
  • Booking pace vs. prior year

Profitability:

  • GOP and GOPPAR
  • Flow-through
  • Department margins

Efficiency:

  • Labor cost %
  • Energy per occupied room
  • Cost per occupied room

Cash:

  • Cash position
  • AR aging
  • Debt service coverage

Guest:

  • Review scores
  • NPS or satisfaction
  • Repeat guest %

Visual Design

  • Use consistent formatting
  • Color-code variances (green/red)
  • Show trends, not just snapshots
  • Include targets/benchmarks
  • Keep it on one page

What's Next

You have the financial management framework. Now let's put it all together.

Next chapter: Your 30-day hotel finance upgrade — a structured program to transform your financial operations.

Investment and Asset DecisionsYour 30-Day Hotel Finance Upgrade