How to Forecast Hotel Revenue: a Step-by-step Guide

Revenue forecasting is a vital tool for hoteliers, offering insight into the future of their business, and the starting point for many critical decisions.

Revenue forecasting is essential for hoteliers, turning past performance, current bookings, market trends and competitor activity into actionable insights. A strong forecast helps you anticipate revenue, expenses, and profit, guiding operational, pricing, and strategic decisions with confidence.

By leveraging automation and real-time data, hoteliers can track bookings, market signals, and competitor pricing continuously, reducing guesswork and allowing timely adjustments to rates, staffing, and marketing.

Forecasting is also evolving with AI, which can detect emerging trends, model scenarios and enhance decision-making across revenue streams.

Whether managing day-to-day operations or planning long-term strategy, a reliable, data-driven forecast provides clarity, agility and a roadmap for achieving KPIs and optimizing profitability.

But how can we structure this thinking so you can act on it?

In this guide, we’ll walk you through a step-by-step approach to forecasting hotel revenue effectively, turning insights into informed actions that drive results.

Step One: Define your forecasting timeline

For the savvy revenue manager, the first step in revenue forecasting is to define your timeline clearly and precisely. Determine both the period you need to forecast for (e.g., a month, a quarter or a year) and how far ahead you need to forecast based on your business needs and market conditions.

For example, forecasting for December is much more precise and actionable than vaguely forecasting ‘over the next few months’. This clarity allows you to tap into historical data from previous Decembers, making your process more accurate. 

A clearly defined timeline ensures you’re measuring against relevant, like-for-like past performance data.

Different types of hotels may benefit from different forecasting periods depending on their market and guest mix. 

A leisure-focused boutique hotel might forecast quarterly, capturing seasonal swings in demand. A corporate-oriented city hotel often uses monthly forecasts to respond quickly to changes in business travel and event bookings. 

Meanwhile, a mixed-use independent hotel could maintain an annual budget for long-term planning while using rolling quarterly updates to stay agile in response to shifting market conditions.

Best practices:

• Conduct regular forecasting: Monthly or quarterly updates keep your projections current and accurate.

• Adapt to market trends: Frequent updates help you swiftly adapt to market changes, maintaining a competitive edge.

Step Two: Collect and organize historical data

Accurate and relevant historical data serves as the foundation of your hotel revenue forecast. It reveals trends and patterns in demand, pricing and guest behavior that help you build reliable projections. When you understand how your hotel has performed in the past, you can better anticipate future demand.

Hoteliers rely heavily on data points such as past occupancy rates, average daily rate (ADR) and revenue per available room (RevPAR).

But the accuracy of your forecast depends just as much on data quality and how well your systems connect. Clean, consistent data from your PMS, RMS, channel manager, BI tools and benchmarking platforms gives you a single, trustworthy source of truth.

When these systems are integrated – and pulling information in real time – you reduce manual errors, eliminate blind spots and create a far more dependable foundation for forecasting.

Where to find the data:

• Property Management System (PMS): Most of your historical data can be sourced from your PMS, which tracks past bookings, occupancy levels, room rates and more.

• Revenue Management System (RMS): If you use an RMS, it likely has detailed historical data and analytics.

• Business Intelligence solution: Sources data from all of your systems, quickly and efficiently.

Time period to collect data from:

Align the data collection period with your forecasting timeline. For example, if you’re forecasting for the upcoming summer, review last summer’s data.

Data you will want to collect:

Organizing your data:

Ensure all your data is clearly labeled and easy to navigate. Use clear and consistent conventions. Consider specialized forecasting tools that can store, organize and surface your data more efficiently than manual methods.

Best practices:

• Consistency: Ensure data is consistently recorded and maintained.

• Detail: Collect as much detail as possible for deeper insights. This will help you to understand your guest demographics better.

• Segment: Break data down into guest origin, distribution channels, market segments, room type segments or rate codes to spot trends.

Step Three: Assess current bookings

With your historical data in place, the next crucial step in revenue forecasting is to assess your current bookings.

The data you have ‘on-the-books’ is the most reliable information for building an accurate forecast. Confirmed room reservations, group blocks and scheduled events provide a concrete baseline for your expected revenue. When you know exactly what business is already secured, you can anchor your projections in reality rather than assumptions.

Today, many hotels refine this step further by combining on-the-books data with predictive analytics.

By layering expected pick-up patterns, pace trends and demand signals over your confirmed bookings, you can create a more precise short-term forecast. This approach helps you identify whether your current pace is tracking ahead or behind typical patterns, allowing you to adjust rates, inventory and marketing strategies sooner and with greater confidence.

Steps to assess current bookings:

Review all the booking details:

1. Examine each confirmed booking for the forecast period.

Note key details such as room rate, length of stay and any add-on services (e.g., breakfast, spa packages).

2. Categorize bookings.

Group bookings by room type, booking channel (e.g., direct, OTA) and rate plan.

Identify patterns and trends within these groups to understand how different segments are performing.

3. Update forecasts with current data

Incorporate these confirmed bookings into your revenue forecasts.

Adjust your projections to reflect the actual revenue already secured, providing a more accurate starting point.

Best practices:

Regular updates: Continuously update your records with new bookings.

Monitor patterns: Keep an eye out for booking trends and adjust forecasts accordingly.

Leverage technology: Use technology to automate the tracking and updating of bookings, minimizing manual errors and saving time.

Step Four: Factor in external variables and market conditions

Next, consider the variables that could impact future demand.

Paying attention to wider market trends helps you understand the context in which your hotel is operating, both within the hospitality industry and the broader economy. 

When you can anticipate these external forces, you gain greater flexibility and can respond more confidently to fluctuations.

Today, AI-enabled tools make this step far more efficient by automatically monitoring market shifts, competitor pricing and demand signals in real time. 

Instead of manually tracking dozens of indicators, you can rely on technology to surface anomalies, emerging trends or sudden changes, ensuring your forecast adjusts quickly as conditions evolve.

Market trends:

• Hospitality industry trends: Are you noticing a general increase or decline in hotel visitors in your region? These patterns often signal future demand shifts. For example, many European cities saw a surge in leisure travel after major airline capacity increases in 2023, which lifted weekend occupancy and pushed ADR higher across urban hotels. 

Likewise, destinations hosting large-scale events often experience sharp, short-term spikes in demand that materially impact revenue forecasts.

• Economic conditions: Is the economy experiencing a downturn or an upturn? Economic environments directly influence travel behavior. During periods of inflationary pressure, for instance, many markets observed shorter booking windows and reduced ancillary spending as travellers became more price-sensitive. 

Conversely, when corporate budgets rebounded in 2024 and improved further in 2025, business travel demand strengthened, improving weekday occupancy and stabilizing ADR across many city-centre properties.

Competitive landscape:

• New competitors: Has a new hotel or holiday home opened nearby? New competitors can dilute demand for your property, making it essential to monitor these developments closely.

• Competitor changes: Have local competitors recently undergone renovations or opened up a state-of-the-art conference center? Such changes can significantly raise or lower your demand.

External factors:

• Events and attractions: New local attractions or special events can boost demand to your market, while construction or closures can decrease it.

• Weather patterns: Seasonal weather changes or forecasts of severe weather can influence booking patterns. A ski resort might see the length of its high season dictated by the snowfall it receives, for example.

Step Five: Estimate future profits and expenses

Once you’ve assessed demand drivers, the next step is to translate those insights into financial outcomes by estimating your future profits and expenses.

This is where forecasting becomes truly actionable: it helps you anticipate the revenue you’re likely to generate and the costs required to support that activity.

For example, if your forecast shows a strong pickup for an upcoming event period, you may need to scale staffing, increase housekeeping resources or allocate additional marketing spend to capture more demand.

By grounding these decisions in data, you ensure your operational and financial planning stay aligned with expected business levels.

Profit and expense estimation

To accurately estimate future profits and expenses, start by analyzing the historical data you’ve collected. Break down revenue into different streams and use historical data to project future financial performance. Here’s how you can approach this:

1. Estimating future profits:

• Revenue streams: Break down your revenue into different streams such as room sales, food and beverage, events and other services. For example, if room sales have consistently contributed to 70% of your total revenue, use this as a base to forecast future room sales.

• Historical data analysis: Look at past occupancy rates, ADR and RevPAR to project future room revenue. If your ADR was $150 and your average occupancy rate was 80% last year, use these figures to project future revenue, adjusting for expected changes in demand.

• Trend analysis: Incorporate market trends, seasonality and upcoming events into your forecast. If there’s an annual conference that boosts your bookings every summer, factor this into your revenue predictions.

2. Estimating future expenses:

• Fixed costs: Identify fixed costs such as salaries, utilities, insurance and maintenance. These costs remain relatively constant regardless of occupancy levels.

• Variable costs: Estimate variable costs that fluctuate with occupancy, such as housekeeping, laundry and food and beverage supplies. Use historical ratios to forecast these expenses. If variable costs are typically 30% of your revenue, for example, apply this percentage to your projected revenue.

• Capital expenditures: Plan for significant expenses like renovations or new equipment purchases. These should be factored into your long-term forecasts.

Best practices:

Step Six: Calculate and validate your hotel revenue forecast

Now that you have estimated future profits and expenses, it’s time to use this information to forecast your hotel’s revenue. 

Combine your projected occupancy rates, ADR and additional revenue streams into a comprehensive revenue projection.

Step-by-step process:

1. Determine projected occupancy rate and ADR: Use historical data, current bookings and market trends to estimate your future occupancy rate and ADR.

2. Calculate room revenue: Multiply the projected occupied room nights by the ADR.

3. Add additional revenue streams: Include revenue from food and beverage, events and other services.

4. Calculate total projected revenue: Combine room revenue and additional revenue streams to get the total forecasted revenue.

Step Seven: Use standard financial ratios to check your forecast

Once you’ve forecasted your hotel revenue, validate the accuracy and realism of your projections. Using these standard financial ratios provides a way to cross-check your forecasts and ensure they are grounded in reality.

Consider these ratios:

Gross Operating Profit Per Available Room

Gross Operating Profit Per Available Room (GOPPAR) measures how much operating profit your hotel generates for each available room, offering a more complete picture than revenue-based metrics alone.

Because it incorporates both income and operating expenses, GOPPAR is a powerful indicator of overall financial efficiency and a valuable tool for validating whether your forecasted revenue will translate into real profitability.

The formula is: GOPPAR = Gross Operating Profit ÷ Total Available Rooms

To use it effectively in forecasting, compare projected GOPPAR against historical performance, adjust for expected cost fluctuations and monitor how operational decisions – such as staffing levels or energy management – will impact profitability. This helps ensure your revenue forecast aligns with sustainable, margin-focused growth.

Average Daily Rate

Average Daily Rate or ADR measures the average revenue earned per sold room and is one of the core indicators used to validate and refine a hotel’s revenue forecast. It helps you understand pricing performance and evaluate whether your projected room rates are realistic based on demand patterns and market conditions.

The formula is: ADR = Total Room Revenue ÷ Number of Rooms Sold

To use ADR effectively in forecasting, compare your projected ADR to historical results, competitor pricing and future demand signals. Adjust rates based on pace trends, seasonal influences and market compression to ensure your pricing strategy supports both revenue growth and profitability targets.

Revenue Per Available Room

Revenue Per Available Room(RevPAR) measures the revenue your hotel generates per available room, combining both occupancy and rate performance into a single, highly actionable metric. It’s essential for forecasting because it shows whether you are filling rooms at profitable rates – and how changes in demand or pricing might affect total revenue.

The formula is: RevPAR = Total Room Revenue ÷ Total Available Rooms (or ADR × Occupancy Rate)

To use RevPAR effectively in forecasting, compare projected RevPAR to historical trends, pacing data and market benchmarks. Adjust assumptions for occupancy or ADR when forecasts appear misaligned, ensuring your revenue projections remain realistic, data-driven and sensitive to evolving demand.

Total Revenue Per Available Room

Total Revenue Per Available Room (TRevPAR) measures how much total revenue your hotel earns per available room, capturing all income streams, not just rooms. This makes it especially valuable for forecasting in full-service or amenities-driven hotels where ancillary revenue significantly impacts performance.

The formula is: TRevPAR = Total Hotel Revenue ÷ Total Available Rooms

To use TRevPAR effectively in forecasting, analyze historical patterns across all revenue sources (rooms, F&B, spa, events, etc.) and evaluate how changes in demand, guest mix or upsell strategies may shift total revenue contribution. 

Incorporate these insights into your forecast to ensure it reflects the full commercial picture, not just room revenue.

Operating Profit Margin

Operating Profit Margin measures the percentage of revenue your hotel retains as operating profit after accounting for all operating expenses. It’s a critical forecasting metric because it reveals whether projected revenue will translate into healthy, sustainable profitability – not just top-line growth.

The formula is: Operating Profit Margin = Operating Profit ÷ Total Revenue × 100

To use this ratio effectively in forecasting, compare projected margins to historical performance, adjust assumptions for rising costs or efficiency gains and model how changes in occupancy, ADR or departmental spending will affect profitability. 

This helps ensure your forecast supports strong financial discipline and long-term operational resilience.

1. Calculate each ratio:

Use your forecasted data to calculate GOPPAR, ADR, RevPAR, TRevPAR and Operating Profit Margin.

2. Compare with industry benchmarks:

Compare your ratios with industry standards to check if your forecasts are realistic. For instance, if your RevPAR or TRevPAR is significantly higher than the industry average, reassess your assumptions.

3. Adjust forecasts accordingly:

If discrepancies are found, adjust your forecasts to align more closely with realistic expectations.

Step Eight: Conduct a variance analysis

To iron out any discrepancies and ensure the accuracy of your forecasting efforts, the next step is to conduct variance analysis in which you compare your forecast revenue and expenses with the actual figures.

Steps to conduct variance analysis:

1. Collect actual data: Gather actual revenue and expense data for the period you forecasted.

2. Compare forecasted vs actual: Calculate the differences between your forecasted and actual figures.

3. Use the formula: Variance = Actual − Forecasted

Categorize variances as favorable (better than expected) or unfavorable (worse than expected).

4. Analyze variances: Investigate the reasons behind significant variances. For instance, if there was a wide variance between forecast and actual, you might have to dig deeper into the causes.

5. Identify patterns and causes: Look for patterns in variances to understand recurring issues. Common causes might include seasonal fluctuations, economic changes or inaccurate assumptions.

6. Implement changes: Use insights from the variance analysis to refine your forecasting models. Adjust your assumptions and models based on the identified causes of variances.

Improve financial forecasting accuracy with software

Forecasting your hotel’s revenue involves compiling and analyzing vast amounts of historical data. If done manually, you introduce the risk of errors and losing valuable time on data gathering.

But with the right tools, fed with high-quality data, this process becomes significantly more manageable and you’ll be able to generate high-quality forecasts with ease. These tools automate data collection and provide real-time insights, allowing you to adjust pricing and distribution strategies dynamically.

Lighthouse Performance, the leading solution in the hospitality industry, not only consolidates your data but also slices and dices it for actionable insights so that you can measure your business performance against your forecast on the go.

Whether you need a quick glance at top performance metrics or an in-depth analysis of long-term trends, Lighthouse Performance makes it effortless.

Forecasting is only an effective tool if its insights lead to concrete actions. By leveraging such technology, you streamline decision-making, identify new revenue opportunities and ensure your hotel’s performance stays on target to meet your revenue goals.

Discover how Lighthouse’s solutions can revolutionize revenue forecasting, ensuring accuracy and efficiency.

About Lighthouse

Lighthouse is the AI commercial operating system for the travel and hospitality industry, purpose-built to help hotels optimize pricing, distribution, marketing, and performance management. Powered by the industry’s most trusted commercial intelligence layer, Lighthouse delivers better commercial outcomes for hotels of every size through a system of autonomous commercial agents. Hotels set the strategy; Lighthouse agents do the work, learn from every outcome, and get better every day. For more information, visit www.mylighthouse.com.