What is the difficulty level and which AI tool should I use?

This prompt is advanced level. It works with all AI tools (ChatGPT, Claude, Gemini, etc.).

🚀EntrepreneurshipAdvancedAll AIs

Generate a 3-Year Financial Forecast with Detailed Assumptions

Prompt to create a detailed 3-year financial forecast with assumptions and break-even point.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

You are a financial analyst specialized in startups. Generate a 3-year financial forecast for [STARTUP_NAME], a company in the [SECTOR] sector. The forecast must include: 1. Key assumptions: revenue growth (annual growth rate of [RATE]%), gross margin (target [MARGIN]%), fixed costs (rent, salaries: [AMOUNT] €/month), variable costs (marketing, production: [PERCENTAGE]% of revenue). 2. Forecast income statement: revenue, cost of sales, gross margin, operating expenses, EBITDA, net income. 3. Forecast balance sheet: assets (cash, receivables, fixed assets), liabilities (equity, debt). 4. Cash flow statement: cash inflows, outflows, net cash flow, monthly closing cash. 5. Break-even point: calculate the revenue needed to cover all fixed costs, expressed in euros and in number of units (unit price of [UNIT_PRICE] €). Include a simple text chart showing the evolution of cash flows. Present in clear tables with explanations for each line. Use figures consistent with the assumptions.

Personalize this prompt with Léa

Answer 3 questions and Léa tailors the prompt to your situation.

Why this prompt works

This prompt is designed to produce a complete financial forecast. Simply fill in the variables like growth rate or gross margin. The AI will generate consistent tables and calculations.Before using it, make sure you have a clear idea of your assumptions (selling price, costs, etc.). The result can then be copied into Excel for fine-tuning.It is recommended to check the consistency between tables (e.g., final cash should match the balance sheet). Use this prompt to quickly iterate over different scenarios.

Use Cases

Prepare a forecast for a loan applicationSimulate different growth scenariosEvaluate working capital needs

Expected Output

A 3-year financial forecast with tables and break-even analysis.

Improve this prompt

Run this prompt through the Optimizer to strengthen its context, constraints and expected format.

Improve this prompt with the Optimizer

Comments

LéaAI
Pour un résultat fiable, précisez des hypothèses réalistes : basez le taux de croissance sur des benchmarks sectoriels et ajustez le coût variable en fonction de votre modèle d’affaires. Testez deux scénarios (pessimiste/optimiste) en faisant varier le taux de croissance de ±10% et la marge brute de ±5 points.