Building an ESN Financial Forecast: Levers, KPIs and Action Plan
Actionable prompt to build a complete financial forecast for an ESN, integrating specific levers (daily rate, productivity, bench, hiring) and scenarios.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a financial forecasting expert for an ESN (IT services company). Your objective is to build a financial forecast over [NUMBER_OF_YEARS] year(s) for an ESN named [IT_SERVICES_FIRM_NAME] located in [CITY/REGION]. The ESN has [NUMBER_OF_CONSULTANTS] consultants and [NUMBER_OF_SUPPORT] support staff (HR, sales, administrative). The target margin rate is [TARGET_MARGIN]%.
Detail the following key elements:
- Basic assumptions: Average daily rate by seniority level (junior: [JUNIOR_RATE]€, confirmed: [CONFIRMED_RATE]€, senior: [SENIOR_RATE]€). Productivity rate (actual billing / theoretical time): [PRODUCTIVITY_RATE]%.
- Growth levers: Change in number of consultants per year (turnover: [TURNOVER]%, hires: [HIRES_PER_YEAR] per year). Target utilization rate (bench): maximum [BENCH_MAX]%.
- Projected income statement: Revenue (Revenue = nb consultants * utilization rate * daily rate * business days). Payroll (salaries + employer charges, [EMPLOYER_CHARGES]%). Overhead costs (rent, tools, accounting, marketing): [OVERHEAD_COSTS]€/year. Net income.
- Key ratios: Net margin, EBITDA, working capital requirement (customer payment period: [CUSTOMER_DAYS] days, supplier period: [SUPPLIER_DAYS] days).
- Scenarios: An optimistic scenario (Revenue+[OPTIMISTIC_PERCENT]%) and a pessimistic one (Revenue-[PESSIMISTIC_PERCENT]%) with impacts on cash flow.
Output format: table structured by year, with comments on each lever. Also give 3 concrete actions to improve margin.
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 generates a <strong>detailed and sector-specific financial forecast</strong> for an ESN. It integrates key variables specific to IT services: daily rate, utilization rate, turnover, payroll, overhead costs.</p><p>To use it: replace the variables in brackets (e.g., [IT_SERVICES_FIRM_NAME]) with your actual or estimated data. The prompt guides you through structured steps: assumptions, income statement, ratios, scenarios. It produces an annual table and actionable recommendations.</p><p>Ideal for a <strong>business plan</strong>, <strong>fundraising</strong> or <strong>strategic review</strong>. Customize the optimistic/pessimistic scenarios to anticipate risks.</p>
Use Cases
Expected Output
A structured financial forecast over [NUMBER_OF_YEARS] years including: detailed assumptions, income statement, ratios, 2 scenarios and 3 concrete actions.
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, remplacez le taux de productivité statique par un taux mensuel reflétant la montée en charge des nouveaux recrutés. Ajoutez un scénario « dégradé » avec un rallongement des délais clients de 15 jours ; le BFR est souvent le vrai frein de trésorerie. Intégrez aussi le coût du bench en avant-ventes ou en R&D pour ne pas sous-estimer la marge.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Post-Proposal Follow-Up Email
Sales follow-up
Consultative Sales Email
Converting with personalized emails
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.
Write Hard-Hitting B2B Prospecting Emails
Generates a 3-email B2B cold email sequence with subject line variants, persuasive logic and mistakes to avoid.