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
Answer 3 questions and Léa tailors the prompt to your situation.
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
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
Subcontractor Management Plan
Scaling beyond solo freelancing
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.
Conduct a Sector Market Research Study
Generates a comprehensive sector market research study covering size, segmentation, competitors, trends, and opportunities.