Build a realistic financial forecast for a B2B consulting firm
Structured prompt to generate a detailed financial forecast for a B2B consulting firm, including income statement, cash flow, key indicators, and sensitivity analysis.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a financial expert specializing in B2B consulting firms. Help me build a realistic financial forecast for my firm. Here is the context: [FIRM_NAME] is a consulting firm in [CONSULTING_FIELD] (e.g., strategy, digital, HR, finance). Our main offering is [MAIN_OFFERING]. Our target: [CLIENT_SEGMENT] (e.g., mid-market, large accounts, startups). We are based in [CITY]. We have [NUMBER_OF_CONSULTANTS] consultants (including partners) and [NUMBER_OF_PARTNERS] partners. The target average daily rate is [AVG_DAILY_RATE] €. The target annual utilization rate is [UTILIZATION_RATE] % (excluding holidays). Annual fixed costs are [FIXED_COSTS] € (rent, software, insurance). The margin rate on services (excluding salaries) is [SERVICE_MARGIN] %. The annual marketing budget is [MARKETING_BUDGET] €. The average client payment term is [PAYMENT_TERM] days. The revenue for year N-1 was [REVENUE_N-1] €. Provide a 3-year forecast [START_YEAR]-[END_YEAR], including: 1. A simplified income statement (revenue, variable costs, margin, fixed costs, EBIT, net income). 2. A monthly cash flow plan for year 1. 3. Key indicators: weighted average daily rate, effective utilization rate, number of billed days per consultant, EBIT/revenue ratio. 4. Realistic growth assumptions (e.g., daily rate increase of 3% per year, recruitment of [NUMBER_OF_RECRUITS] consultants in year 2, utilization rate increase of 2 points per year). 5. Sensitivity analysis: minimum revenue to break even? Impact of a 10% decrease in daily rate on net income? 6. Recommendations to improve cash flow (e.g., optimize working capital, increase capital contributions). Be precise, use formulas and typical consulting ratios. Do not make generic sentences, adapt to the specifics of my firm.
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 to get a tailored financial forecast from the AI for your consulting firm. It integrates key industry variables: daily rate, utilization rate, number of consultants, fixed costs, etc. The AI will generate an income statement, a cash flow plan, performance indicators, and a sensitivity analysis, all adapted to your data.</p><p>To use it, replace each [VARIABLE] with your actual or estimated figures. The more precise the data, the more actionable the result. Use the output to refine your business plan, discuss with your banker or partner.</p><p>Tip: after generation, validate the assumptions with your accountant. This prompt is an excellent starting point to structure your financial thinking and avoid common mistakes (e.g., overestimating utilization rate, underestimating working capital).</p>
Use Cases
Expected Output
A complete 3-year financial forecast including income statement, cash flow plan, industry KPIs, and sensitivity analysis, customized according to the provided variables.
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
Pensez à ajouter le taux de TVA et le délai de paiement fournisseurs dans le plan de trésorerie : le BFR du conseil dépend surtout des créances clients. Astuce : demandez un scénario dégradé avec une perte de 20% sur votre principal client pour tester la résilience du prévisionnel. Ajoutez aussi le coefficient de charges salariales pour affiner l’EBIT.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Consultative Sales Email
Converting with personalized emails
Post-Proposal Follow-Up Email
Sales follow-up
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.
The Ultimate KPI Dashboard Guide for BTP Craftsmen
Structured prompt to design a customized KPI dashboard for a BTP craftsman, including objectives, calculations, sources, visualization, and corrective actions.