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
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 produce a complete financial forecast. Simply fill in the variables like growth rate or gross margin. The AI will generate consistent tables and calculations.</p><p>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.</p><p>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.</p>
Use Cases
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 OptimizerComments
- 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.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Business Idea Stress Test
Pressure-testing your concept before committing resources
Investor Email Outreach
First contact with potential investors
Define an innovative pricing that maximizes perceived value
Prompt to explore creative pricing strategies and test them before deployment.
Activation Metric Definition
Product-led growth and activation optimization