Building a Robust Financial Forecast for Your Web Agency
This prompt helps you generate a complete financial forecast for a web agency, including revenue, expenses, cash flow, and scenarios.
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
You are a corporate finance expert specializing in web agencies. Your mission is to build a complete financial forecast for [AGENCY_NAME], a web agency located in [CITY] that primarily operates in [TARGET_MARKET] (e.g., SMEs, startups, e-commerce). The agency offers services including [OFFER1], [OFFER2] and a SaaS subscription of [SAAS_PRICE]€/month. The revenue model combines [CONTRACT_TYPE] assignments (fixed-price, managed services, subscription) with an average basket of [AVERAGE_BASKET]€.
Forecast objectives:
- Calculate projected revenue over 3 years, incorporating seasonality (e.g., decline in August and December).
- Estimate personnel costs (salaries + payroll taxes) for [NUMBER_OF_EMPLOYEES] employees, considering a business development rate of [CONVERSION_RATE]%.
- Model marketing investments (Google Ads, LinkedIn, trade shows) amounting to [MARKETING_BUDGET]€ per year, with an expected ROAS of [ROAS].
- Include technical costs: servers, licenses (AWS, GitHub), hosting, SaaS tools (Asana, Notion) for a total of [TECH_COSTS]€/year.
- Calculate the breakeven point in days and euros, and the breakeven number of clients.
- Project a simplified income statement (revenue, expenses, EBITDA, net income) and a monthly cash flow plan.
- Integrate a pessimistic scenario (a [DECLINE]% decrease in revenue) and an optimistic scenario (an [INCREASE]% increase).
Response format: Tables in Markdown with explanatory comments under each section. Specify key assumptions and KPIs to monitor (e.g., churn rate, NPS, LTV/CAC).
Industry constraints:
- Margin rate on services: 60-70%; on SaaS: 80-90%.
- Average payment terms: [PAYMENT_TERM] days.
- Annual client retention rate: [RETENTION]%.
Final deliverable: a structured document ready for export to PDF or Excel.
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 for web agency owners or consultants who want to create a realistic financial business plan. It incorporates industry specifics: revenue mix (fixed-price, managed services, subscription), seasonality, technical costs, and margin ratios.</p><p>To use it, replace the variables in brackets with your agency's data. You can ask the AI to generate the forecast in one go or step by step. The result includes tables and explanatory comments.</p><p>Tip: Use this prompt with models like GPT-4 or Claude to get accurate calculations. Ask for adjustments by varying assumptions (prices, headcount).</p>
Use Cases
Expected Output
A structured financial forecast with tables: projected revenue (3 years), income statement, cash flow plan, breakeven point, and pessimistic/optimistic scenarios. Comments on assumptions and KPIs.
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
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
Retargeting Ad Variants
Retargeting campaigns for warm audiences
Market Update Newsletter
Monthly client communication for market authority
Define Strategic KPIs for a Business
Builds a complete KPI system across 4 levels with formulas, frequencies, and sector benchmarks.
Complete market study for a real estate agency
Structured prompt for conducting a market study specific to the B2B real estate sector, with key variables to customize the analysis.