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
Answer 3 questions and Léa tailors the prompt to your situation.
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
B2B Hotel Client Performance Report Generator
Prompt to generate a personalized client performance report for a hotel, aimed at B2B decision-makers.
B2B Sales Script for Real Estate Agencies
A prompt to generate a customized B2B sales script for a real estate agency, with customizable variables.
Risk Register
Project risk management
Create Quarterly OKRs for a Team
Generates structured quarterly OKRs with inspiring objectives, quantified key results, and priority initiatives.