P
💼BusinessIntermediateAll AIs

Financial Forecast for Construction: Growth Lever for Artisans

This prompt generates a detailed financial forecast tailored to the construction sector, including specifics of cash flow, margins, and cost variations.

Paste in your AI

Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.

You are a corporate finance expert specialized in the construction sector (building and public works). You help a construction artisan build a realistic and actionable financial forecast for their activity. The forecast must take into account sector specifics: long project cycles, deposits, retention guarantees, material cost fluctuations, and subcontracting. Use the following information to generate the forecast:

  • Type of construction activity: [ACTIVITY_TYPE] (e.g., masonry, electrical, plumbing, framing, etc.)
  • Estimated annual revenue for year N: [ESTIMATED_ANNUAL_REVENUE] euros
  • Average observed gross margin: [GROSS_MARGIN_PERCENT] %
  • Monthly fixed costs (rent, insurance, vehicles, etc.): [MONTHLY_FIXED_COSTS] euros
  • Total workforce: [TOTAL_STAFF] people
  • Average hourly labor rate billed: [AVERAGE_HOURLY_RATE] euros excluding tax
  • Average project price: [AVERAGE_PROJECT_PRICE] euros excluding tax
  • Average project duration: [AVERAGE_PROJECT_DURATION] days
  • Customer payment time: [CUSTOMER_PAYMENT_TERM] days (60 to 90 days typical in construction)
  • Retention guarantee: [RETENTION_GUARANTEE_PERCENT] % (often 5% in private contracts)
  • Planned subcontracting: [SUBCONTRACTING_AMOUNT] euros per year
  • Annual material cost variation: [MATERIAL_COST_VARIATION] % (e.g., 3%)

Generate a 12-month financial forecast including:

  1. A monthly income statement
  2. A monthly cash flow plan with inflows/outflows
  3. Key indicators: net margin, working capital requirement (WCR), debt ratio
  4. A break-even point in revenue and number of projects
  5. A sensitivity analysis on two variables: a [REVENUE_VARIATION] % decrease in revenue and a [COST_VARIATION] % increase in material costs

For each scenario, indicate possible adjustments (reducing overhead, increasing prices, better time management). The forecast should be presented clearly with tables and comments. Conclude with 3 concrete recommendations to improve cash flow and profitability in the construction context.

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 construction artisans or their advisors (accountants, business coaches) who want to build a realistic financial forecast. It incorporates sector-specific constraints: project cycles, long payment terms, retention guarantees, and material volatility.</p><p>To use it, replace each variable in brackets with your actual or estimated data. The prompt requests structured output: monthly income statement, cash flow plan, break-even point, and sensitivity analyses. This helps anticipate cash needs and adjust strategy.</p><p>Ideal for preparing a financing file, evaluating annual viability, or simulating scenarios. The result can be integrated into a spreadsheet or report. Adapt variables based on your specific activity (masonry, electrical, etc.).</p>

Use Cases

Prepare an annual budget for a masonry artisan businessSimulate the impact of a material price increase on an electrician's cash flowSupport a professional loan application with a credible forecast

Expected Output

The prompt generates a complete 12-month financial forecast with tables, key indicators, sensitivity analyses, and recommendations. The expected format is structured text with clear sections.

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

    Le prompt suppose un CA annuel lissé, mais le BTP est très saisonnier. Ajoutez un coefficient mensuel de chiffre d'affaires (ex. : 8% en hiver, 12% au printemps) pour que le plan de trésorerie reflète les pics d'activité. Pensez aussi à intégrer les délais réels de paiement des clients publics, souvent plus longs que 60 jours, et à décaler les achats de matériaux dans le temps.

📬 Get new prompts every week

Join our newsletter and never miss a prompt.

Go further

Similar Prompts

💼BusinessIntermediateAll AIs

ICP Definition Worksheet

Focusing prospecting on highest-probability accounts

0332
💼BusinessIntermediateClaude

Claude Prompt for Competitive Monitoring

Competitive monitoring is a strategic pillar for any company wishing to maintain its competitive advantage. Traditionally time-consuming and expensive, this activity can be significantly accelerated with Claude. By using structured prompts, you can ask Claude to analyze your competitors' positioning, synthesize their marketing strategies, identify their strengths and weaknesses, and spot untapped market opportunities. Claude excels at structuring disparate information into coherent, actionable analyses. Whether you are an entrepreneur, marketing manager, or strategic analyst, the prompts below will allow you to transform Claude into a real competitive monitoring assistant. AI does not replace field data collection, but it helps you organize your observations, formulate relevant hypotheses, and produce professional monitoring reports in a fraction of the usual time. Discover how to structure your requests to obtain rich and actionable competitive analyses.

0775
💼BusinessBeginnerAll AIs

Post-Proposal Follow-Up Email

Sales follow-up

0340
💼BusinessAdvancedAll AIs

Prepare Your B2B SaaS Fundraising in 10 Actionable Steps

A structured prompt to prepare a B2B SaaS fundraising: KPIs, pitch deck, due diligence, valuation, roadshow. Immediately actionable.

0253