Building a Financial Forecast for a Hotel: Complete Module
Professional prompt to generate a complete hotel financial forecast, including ratios, levers and sensitivity scenarios.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are an expert in hotel finance. Produce a financial forecast over [NUMBER_OF_YEARS] years for a hotel with [NUMBER_OF_ROOMS] rooms, located in [LOCATION], with a [TYPE_OF_ESTABLISHMENT] positioning (luxury, economy, etc.).
Mandatorily include:
- A simplified income statement (revenue, variable costs, fixed costs, EBITDA, net income)
- A cash flow statement (initial investment, working capital requirements, free cash flow)
- Key hotel metrics: average [OCCUPANCY_RATE], [AVERAGE_ROOM_PRICE] (ADR), target [REVPAR], annual [REVPAR] growth objective
- Actionable levers: optimizing [REVENUE_MANAGEMENT] (yield management, overbooking), reducing [LABOR_COSTS] (as % of revenue), controlling [FIXED_EXPENSES] (energy, maintenance)
- Sector-specific constraints: seasonality (distinguish [HIGH_SEASON] and [LOW_SEASON]), applicable tourist tax rate, [MARKETING_ACQUISITION] expenses (Booking.com, TripAdvisor)
- A pessimistic scenario ([NEGATIVE_VARIATION]% decrease in REVPAR) and an optimistic scenario ([POSITIVE_VARIATION]% increase)
For each year, provide a sensitivity analysis on the [BREAK_EVEN_POINT] (minimum occupancy to generate cash). Format the result as numerical tables and strategic comments.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Why this prompt works
<p>This prompt is designed to obtain a financial forecast specific to the hotel industry. Use it by replacing the variables in brackets with your property's data. For example, define the <strong>[NUMBER_OF_ROOMS]</strong> and target <strong>[OCCUPANCY_RATE]</strong>.</p><ul><li>Ideal for CFOs or consultants preparing a business plan for an existing or planned hotel.</li><li>The variables <strong>[REVPAR]</strong>, <strong>[ADR]</strong> and <strong>[OCCUPANCY_RATE]</strong> are the pillars of hotel performance.</li><li>Include seasonality in <strong>[HIGH_SEASON]</strong> and <strong>[LOW_SEASON]</strong> to reflect market reality.</li></ul><p>The expected result includes financial tables and actionable comments for decision-making.</p>
Use Cases
Expected Output
A structured document with financial tables (income statement, cash flow, ratios) and strategic comments per scenario, incorporating hotel-specific aspects (seasonality, REVPAR, labor costs).
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
Be the first to comment on this prompt.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
B2B Hotel Client Performance Report Generator
Prompt to generate a personalized client performance report for a hotel, aimed at B2B decision-makers.
Prepare a Powerful Client Kick-Off for a Law Firm
Structured prompt to generate a client kick-off plan tailored for B2B law firms, with sector variables.
LinkedIn Outreach Message for Communications Agency
This prompt generates an ultra-personalized LinkedIn message for a communications agency targeting B2B prospects.
B2B Sales Script for Real Estate Agencies
A prompt to generate a customized B2B sales script for a real estate agency, with customizable variables.