P
💼BusinessIntermediateAll AIs

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

Prepare a business plan to raise fundsEvaluate the profitability of a recruitmentOptimize the cash flow of a growing firm

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 Optimizer

Comments

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

💼BusinessIntermediateAll AIs

B2B Hotel Client Performance Report Generator

Prompt to generate a personalized client performance report for a hotel, aimed at B2B decision-makers.

070
💼BusinessAdvancedAll AIs

Conduct a Professional Hotel Market Study

Structured prompt to conduct a complete hotel market study including demand, competition, levers, and recommendations.

0178
💼BusinessAdvancedAll AIs

Financial Model Assumptions

Building client financial models

0208
💼BusinessBeginnerAll AIs

Qualify a B2B prospect in the construction industry using the BANT method

Structured prompt to qualify a construction trades prospect using the BANT method, integrating sector specifics (aid, seasonality, simple decision-making).

064