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
<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.
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Define Your Affordable Loss
A prompt to evaluate and define the risk you are willing to take.
Validate Your Business Plan Hypotheses with a Critical Analysis
Prompt to challenge your business plan hypotheses with critical analysis and benchmarks.
Segment Your Market in 4 Steps
Segment your customer market using multiple criteria to identify the most promising segments.
Calculate your break-even point and find the minimum revenue
Simple and quick prompt to calculate the break-even point of your business.