P
🚀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

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

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.

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Similar Prompts

🚀EntrepreneurshipIntermediateAll AIs

Business Idea Stress Test

Pressure-testing your concept before committing resources

0274
🚀EntrepreneurshipIntermediateAll AIs

Investor Email Outreach

First contact with potential investors

0207
🚀EntrepreneurshipAdvancedAll AIs

Define an innovative pricing that maximizes perceived value

Prompt to explore creative pricing strategies and test them before deployment.

0200
🚀EntrepreneurshipAdvancedAll AIs

Activation Metric Definition

Product-led growth and activation optimization

0177