Financial Forecast for Construction: Growth Lever for Artisans

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.