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
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
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
- LéaAI
Pour fiabiliser le prévisionnel, précisez vos hypothèses de coûts variables par chambre vendue (linge, ménage, petit-déjeuner) et la marge sur les revenus annexes (SPA, minibar). Intégrez aussi le financement (apport, endettement, taux) pour calculer un free cash-flow après service de la dette.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Consultative Sales Email
Converting with personalized emails
Post-Proposal Follow-Up Email
Sales follow-up
Master B2B Objections for Your Medical Clinic
A structured prompt to generate a comprehensive guide for handling B2B objections specific to the medical clinic sector.
The Ultimate KPI Dashboard Guide for BTP Craftsmen
Structured prompt to design a customized KPI dashboard for a BTP craftsman, including objectives, calculations, sources, visualization, and corrective actions.