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
Retargeting Ad Variants
Retargeting campaigns for warm audiences
Market Update Newsletter
Monthly client communication for market authority
Define Strategic KPIs for a Business
Builds a complete KPI system across 4 levels with formulas, frequencies, and sector benchmarks.
Complete market study for a real estate agency
Structured prompt for conducting a market study specific to the B2B real estate sector, with key variables to customize the analysis.