P
💼BusinessAdvancedAll AIs

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:

  1. Calculate projected revenue over 3 years, incorporating seasonality (e.g., decline in August and December).
  2. Estimate personnel costs (salaries + payroll taxes) for [NUMBER_OF_EMPLOYEES] employees, considering a business development rate of [CONVERSION_RATE]%.
  3. Model marketing investments (Google Ads, LinkedIn, trade shows) amounting to [MARKETING_BUDGET]€ per year, with an expected ROAS of [ROAS].
  4. Include technical costs: servers, licenses (AWS, GitHub), hosting, SaaS tools (Asana, Notion) for a total of [TECH_COSTS]€/year.
  5. Calculate the breakeven point in days and euros, and the breakeven number of clients.
  6. Project a simplified income statement (revenue, expenses, EBITDA, net income) and a monthly cash flow plan.
  7. 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

Léa rewrites this prompt for your job and your exact goal — 3 quick questions.

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

Preparing a business plan for fundraisingAnnual budget for an existing web agencyProfitability analysis of a new service or SaaS offer

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 Optimizer

Comments

  • LéaAI

    Pour un prévisionnel vraiment robuste, ajoutez un calcul détaillé du besoin en fonds de roulement (BFR) : créances clients selon le délai de paiement, dettes fournisseurs, TVA à reverser. Le plan de trésorerie mensuel doit intégrer ce BFR, sinon les scénarios optimiste/pessimiste resteront théoriques. Demandez aussi un plan de financement initial si le BFR devient négatif.

Glossary Terms

ContextEmbeddingFew-Shot PromptingFine-TuningGPTGuardrailsInferenceLLM

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Improve this prompt with the Optimizer

Analyze the prompt, strengthen the context and get a more precise version.

Prompt Engineering

Cross-model principles for writing more reliable prompts.

Similar Prompts

💼BusinessBeginnerAll AIs

Post-Proposal Follow-Up Email

Sales follow-up

0341
💼BusinessIntermediateAll AIs

Consultative Sales Email

Converting with personalized emails

0305
💼BusinessAdvancedAll AIs

Master B2B Objections for Your Medical Clinic

A structured prompt to generate a comprehensive guide for handling B2B objections specific to the medical clinic sector.

0228
💼BusinessIntermediateAll AIs

The Ultimate KPI Dashboard Guide for BTP Craftsmen

Structured prompt to design a customized KPI dashboard for a BTP craftsman, including objectives, calculations, sources, visualization, and corrective actions.

0194