Custom Financial Forecast for Real Estate Agency
B2B prompt to generate a detailed financial forecast for a real estate agency, including costs, commissions, break-even point, and cash flow.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are an expert in finance and strategy for a B2B real estate agency. Build a 3-year financial forecast for a [AGENCY_TYPE] agency located in [CITY], with [NUMBER_OF_ADVISORS] advisors and a target of [ANNUAL_TARGET_REVENUE] € in annual revenue.
Include:
- Monthly revenue projection: sales fees (average commission rate of [COMMISSION_RATE]%), property management fees (if applicable), and other services (valuation, home staging).
- Fixed costs: rent (approximately [MONTHLY_RENT] €), salaries + payroll taxes ([AVERAGE_SALARY_PER_ADVISOR] €/month), insurance, CRM software, digital marketing (monthly budget of [MONTHLY_MARKETING_BUDGET] €), and travel expenses.
- Calculation of the monthly break-even point and the number of transactions needed to reach it.
- Cash flow analysis: deferred commission collection (average collection delay of [COLLECTION_DELAY] days) and impact on working capital requirements.
- Key indicators: net margin, sales efficiency ratio (revenue per advisor), and marketing return on investment.
- Actionable recommendations to improve profitability: prioritize exclusive vs. shared mandates, cost optimization, leverage additional services.
Structure your response in clear sections with tables of figures (year 1, 2, 3) and an executive summary at the beginning.
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 for real estate agency directors, marketers, and sales teams who want to model their activity over 3 years. It incorporates sector specifics: variable fees, collection delays, mandate costs, etc.</p><p>To use it, replace the variables in [BRACKETS] with your actual data. The prompt will generate monthly projections, break-even point, and key indicators. Ideal for presenting a business plan to an investor or adjusting your strategy.</p><p><strong>Tip:</strong> Adapt the commission rate and collection delay according to your local market. Use the marketing budget to test different growth scenarios.</p>
Use Cases
Expected Output
A structured document with financial tables over 3 years, break-even calculations, and strategic recommendations.
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 un prévisionnel exploitable, remplacez les variables par vos données réelles : nombre de mandats par conseiller, taux de conversion, panier moyen. Ajoutez un scénario pessimiste (CA -20 %) : les banques et investisseurs exigent une fourchette, pas un chiffre unique. Pensez aussi à la saisonnalité du marché local.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Master BTP Objections: Prompt Guide for Tradespeople
A structured prompt to prepare professional responses to common BTP client objections (prices, deadlines, quality).
Create Quarterly OKRs for a Team
Generates structured quarterly OKRs with inspiring objectives, quantified key results, and priority initiatives.
Write your unique value proposition for a real estate agency
Generates a unique value proposition (UVP) for a real estate agency, tailored to its type, area, and target client, with quantified arguments.
Write a Compelling Client Audit for a Consulting Firm
Structured prompt to generate a comprehensive client audit for a B2B consulting firm.