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
Answer 3 questions and Léa tailors the prompt to your situation.
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
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
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.
Offer Submission Summary
Making buyer offers stand out in competitive markets
BTP Sales Pitch Prompt: Convert Your Signed Quotes
Structured prompt to generate a BTP sales pitch targeting B2B decision-makers, with trade variables.
Conduct a Professional Hotel Market Study
Structured prompt to conduct a complete hotel market study including demand, competition, levers, and recommendations.