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
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
Retargeting Ad Variants
Retargeting campaigns for warm audiences
Market Update Newsletter
Monthly client communication for market authority
Define Strategic KPIs for a Business
Builds a complete KPI system across 4 levels with formulas, frequencies, and sector benchmarks.
Complete market study for a real estate agency
Structured prompt for conducting a market study specific to the B2B real estate sector, with key variables to customize the analysis.